POST http://server17.clicks.de/admin/app/ai-chat/run?_sonata_admin=appbundle.admin.ai.prompt&chatId=59e6f6be-eb97-4ec0-8351-d746289c1db3&domain=&id=&jiraIssue=null&m…

Query Metrics

7 Database Queries
7 Different statements
2.41 ms Query time
9 Invalid entities
11 Managed entities

Grouped Statements

Show all queries

default connection

Time Count Info
0.72 ms
(30.10%)
1
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"
]
0.36 ms
(15.05%)
1
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:
[
  ""
]
0.36 ms
(15.00%)
1
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
]
0.27 ms
(11.23%)
1
SELECT count(DISTINCT a0_.model_id) AS sclr_0 FROM ai_chat_response a0_ WHERE a0_.chat_id = ?
Parameters:
[
  "59e6f6be-eb97-4ec0-8351-d746289c1db3"
]
0.25 ms
(10.59%)
1
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:
[
  ""
]
0.24 ms
(9.97%)
1
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"
]
0.19 ms
(8.06%)
1
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"
]

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
  • The mappings AppBundle\Entity\User#groups and AppBundle\Entity\UserGroup#user are inconsistent with each other.
  • The field AppBundle\Entity\User#roleDomainUser is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\RoleDomainUser#user does not contain the required 'inversedBy="roleDomainUser"' attribute.
AppBundle\Entity\UserGroup
  • The association AppBundle\Entity\UserGroup#user refers to the inverse side field AppBundle\Entity\User#userGroup which does not exist.
  • The field AppBundle\Entity\UserGroup#permission is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\Permission#userGroup does not contain the required 'inversedBy="permission"' attribute.
AppBundle\Entity\Department
  • The field AppBundle\Entity\Department#contract is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\Contract#department does not contain the required 'inversedBy="contract"' attribute.
AppBundle\Entity\Customer
  • The field AppBundle\Entity\Customer#domain is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\Domain#customer does not contain the required 'inversedBy="domain"' attribute.
  • The field AppBundle\Entity\Customer#customSetting is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity CustomBundle\Entity\Setting#customer does not contain the required 'inversedBy="customSetting"' attribute.
  • The association AppBundle\Entity\Customer#pvDepartment refers to the inverse side field AppBundle\Entity\Department#customer which does not exist.
  • The field AppBundle\Entity\Customer#roleDomainUser is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\RoleDomainUser#customer does not contain the required 'inversedBy="roleDomainUser"' attribute.
AppBundle\Entity\RoleDomainUser No errors.
AppBundle\Entity\AI\Prompt
  • The field AppBundle\Entity\AI\Prompt#promptParameter is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\AI\PromptParameter#prompt does not contain the required 'inversedBy="promptParameter"' attribute.
  • The association AppBundle\Entity\AI\Prompt#model refers to the inverse side field AppBundle\Entity\AI\Model#prompt which does not exist.
  • The association AppBundle\Entity\AI\Prompt#department refers to the inverse side field AppBundle\Entity\Department#prompt which does not exist.
  • The association AppBundle\Entity\AI\Prompt#tag refers to the inverse side field AppBundle\Entity\AI\Tag#prompt which does not exist.
AppBundle\Entity\Domain
  • The field AppBundle\Entity\Domain#roleDomainUser is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\RoleDomainUser#domain does not contain the required 'inversedBy="roleDomainUser"' attribute.
  • The field AppBundle\Entity\Domain#contract is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\Contract#domain does not contain the required 'inversedBy="contract"' attribute.
  • The field AppBundle\Entity\Domain#aiChat is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\AI\Chat#domain does not contain the required 'inversedBy="aiChat"' attribute.
  • The mappings AppBundle\Entity\Domain#crawlerConfigs and AppBundle\Entity\CrawlerConfig#domain are inconsistent with each other.
AppBundle\Entity\CustomerDomainData No errors.
AppBundle\Entity\CustomerDomainDataDescription
  • The association AppBundle\Entity\CustomerDomainDataDescription#customer refers to the inverse side field AppBundle\Entity\Customer#domainDataDescriptions which does not exist.
  • The association AppBundle\Entity\CustomerDomainDataDescription#domain refers to the inverse side field AppBundle\Entity\Domain#domainDataDescriptions which does not exist.
  • The field AppBundle\Entity\CustomerDomainDataDescription#customerDomainDataDescription is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\CustomerDomainData#description does not contain the required 'inversedBy="customerDomainDataDescription"' attribute.
  • The field AppBundle\Entity\CustomerDomainDataDescription#customerDomainDataOfferDescription is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\CustomerDomainData#offerDescription does not contain the required 'inversedBy="customerDomainDataOfferDescription"' attribute.
  • The field AppBundle\Entity\CustomerDomainDataDescription#customerDomainDataLongTermGoals is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\CustomerDomainData#longTermGoals does not contain the required 'inversedBy="customerDomainDataLongTermGoals"' attribute.
  • The field AppBundle\Entity\CustomerDomainDataDescription#customerDomainDataTargetAudienceDescription is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\CustomerDomainData#targetAudienceDescription does not contain the required 'inversedBy="customerDomainDataTargetAudienceDescription"' attribute.
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
  • The field AppBundle\Entity\AI\ChatResponse#chatUpload is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\AI\ChatUpload#chatResponse does not contain the required 'inversedBy="chatUpload"' attribute.
AppBundle\Entity\AI\Chat
  • The field AppBundle\Entity\AI\Chat#chatResponse is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\AI\ChatResponse#chat does not contain the required 'inversedBy="chatResponse"' attribute.
  • The field AppBundle\Entity\AI\Chat#chatUpload is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\AI\ChatUpload#chat does not contain the required 'inversedBy="chatUpload"' attribute.
  • The field AppBundle\Entity\AI\Chat#chatPermissionUser is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\AI\ChatPermission#chat does not contain the required 'inversedBy="chatPermissionUser"' attribute.
  • The field AppBundle\Entity\AI\Chat#chatPermissionDepartment is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\AI\ChatPermission#chat does not contain the required 'inversedBy="chatPermissionDepartment"' attribute.
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.