Query Metrics
7
Database Queries
7
Different statements
2.41 ms
Query time
9
Invalid entities
11
Managed entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.36 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.username_canonical AS username_canonical_3, t0.email AS email_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.email_canonical AS email_canonical_7, t0.password AS password_8, t0.last_login AS last_login_9, t0.confirmation_token AS confirmation_token_10, t0.password_requested_at AS password_requested_at_11, t0.roles AS roles_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.firstname AS firstname_15, t0.lastname AS lastname_16, t0.name AS name_17, t0.jira_account_id AS jira_account_id_18, t0.pv_id AS pv_id_19, t0.pv_active AS pv_active_20, t0.confirmation_first_login_token AS confirmation_first_login_token_21, t0.user_type AS user_type_22, t0.assigned_customer_user_id AS assigned_customer_user_id_23 FROM fos_user_user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
64
]
|
| 2 | 0.25 ms |
SELECT t0.id AS id_1, t0.short_summary AS short_summary_2, t0.prompt AS prompt_3, t0.temperature AS temperature_4, t0.web_search AS web_search_5, t0.reasoning AS reasoning_6, t0.enabled AS enabled_7, t0.entry_date AS entry_date_8, t0.version AS version_9, t0.domain_id AS domain_id_10, t0.insert_user_id AS insert_user_id_11, t0.update_user_id AS update_user_id_12 FROM ai_prompt t0 WHERE t0.id = ?
Parameters:
[ "" ] |
| 3 | 0.36 ms |
SELECT t0.id AS id_1, t0.domain AS domain_2, t0.display_name AS display_name_3, t0.pv_domain AS pv_domain_4, t0.pv_id AS pv_id_5, t0.pv_active AS pv_active_6, t0.jira_option_id AS jira_option_id_7, t0.page_speed_insights_test AS page_speed_insights_test_8, t0.page_speed_insights_test_urls AS page_speed_insights_test_urls_9, t0.customer_id AS customer_id_10, t11.id AS id_12, t11.target_audience AS target_audience_13, t11.type AS type_14, t11.backend_url AS backend_url_15, t11.username AS username_16, t11.password AS password_17, t11.created AS created_18, t11.updated AS updated_19, t11.customer AS customer_20, t11.domain AS domain_21, t11.description_id AS description_id_22, t11.offer_description_id AS offer_description_id_23, t11.long_term_goals_id AS long_term_goals_id_24, t11.target_audience_description_id AS target_audience_description_id_25, t11.cms_system_id AS cms_system_id_26, t27.id AS id_28, t27.language AS language_29, t27.urls_per_second AS urls_per_second_30, t27.max_pages AS max_pages_31, t27.crawl_depth AS crawl_depth_32, t27.crawl_sub_domains AS crawl_sub_domains_33, t27.is_javascript_necessary AS is_javascript_necessary_34, t27.week_interval AS week_interval_35, t27.start_date AS start_date_36, t27.active AS active_37, t27.domain_id AS domain_id_38, t27.cronjob_id AS cronjob_id_39, t0.page_purpose_id AS page_purpose_id_40, t0.domain_type_id AS domain_type_id_41 FROM domain t0 LEFT JOIN customer_domain_data t11 ON t11.domain = t0.id LEFT JOIN crawler_config t27 ON t27.domain_id = t0.id WHERE t0.id = ?
Parameters:
[ "" ] |
| 4 | 0.72 ms |
SELECT t0.id AS id_1, t0.issue_key AS issue_key_2, t0.project_id AS project_id_3, t0.project_key AS project_key_4, t0.summary AS summary_5, t0.status AS status_6 FROM jira_issue t0 WHERE t0.id = ?
Parameters:
[
"null"
]
|
| 5 | 0.19 ms |
SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.api_name AS api_name_3, t0.service AS service_4, t0.position AS position_5 FROM ai_model t0 WHERE t0.id = ?
Parameters:
[
"2377fa2b-4b0f-4c0d-be0a-e9206bb21b46"
]
|
| 6 | 0.27 ms |
SELECT count(DISTINCT a0_.model_id) AS sclr_0 FROM ai_chat_response a0_ WHERE a0_.chat_id = ?
Parameters:
[
"59e6f6be-eb97-4ec0-8351-d746289c1db3"
]
|
| 7 | 0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.rating AS rating_3, t0.rating_comment AS rating_comment_4, t0.status AS status_5, t0.temperature AS temperature_6, t0.stream AS stream_7, t0.max_tokens AS max_tokens_8, t0.web_search AS web_search_9, t0.reasoning AS reasoning_10, t0.entry_date AS entry_date_11, t0.prompt_id AS prompt_id_12, t0.domain_id AS domain_id_13, t0.jira_issue_id AS jira_issue_id_14, t0.user_id AS user_id_15 FROM ai_chat t0 WHERE t0.id = ?
Parameters:
[
"59e6f6be-eb97-4ec0-8351-d746289c1db3"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| api_data | doctrine.dbal.api_data_connection |
| pv | doctrine.dbal.pv_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| api_data | doctrine.orm.api_data_entity_manager |
| pv | doctrine.orm.pv_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| AppBundle\Entity\AccountType | 4 |
| AppBundle\Entity\User | 3 |
| AppBundle\Entity\Department | 2 |
| AppBundle\Entity\AI\Model | 1 |
| AppBundle\Entity\AI\Chat | 1 |
api_data entity manager
| Class | Amount of managed objects |
|---|
pv entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| AppBundle\Entity\User |
|
| AppBundle\Entity\UserGroup |
|
| AppBundle\Entity\Department |
|
| AppBundle\Entity\Customer |
|
| AppBundle\Entity\RoleDomainUser | No errors. |
| AppBundle\Entity\AI\Prompt |
|
| AppBundle\Entity\Domain |
|
| AppBundle\Entity\CustomerDomainData | No errors. |
| AppBundle\Entity\CustomerDomainDataDescription |
|
| AppBundle\Entity\CmsSystem | No errors. |
| AppBundle\Entity\CrawlerConfig | No errors. |
| Cron\CronBundle\Entity\CronJob | No errors. |
| AppBundle\Entity\PagePurpose | No errors. |
| AppBundle\Entity\DomainType | No errors. |
| AppBundle\Entity\JiraIssue | No errors. |
| AppBundle\Entity\AI\Model | No errors. |
| AppBundle\Entity\AI\ChatResponse |
|
| AppBundle\Entity\AI\Chat |
|
| AppBundle\Entity\AI\ChatUpload | No errors. |
| AppBundle\Entity\AI\ChatPermission | No errors. |
api_data entity manager
No loaded entities.
pv entity manager
No loaded entities.