Query Metrics

11 Database Queries
5 Different statements
21.79 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
12.80 ms
(58.74%)
7
SELECT m0_.id AS id_0, m0_.content AS content_1, m0_.lang AS lang_2, m0_.loading_time AS loading_time_3, m0_.pool_id AS pool_id_4 FROM message m0_ WHERE m0_.pool_id = ? AND m0_.lang = ?
Parameters:
[
  1
  "fr"
]
3.01 ms
(13.82%)
1
SELECT c0_.id AS id_0, c0_.message_order AS message_order_1, p1_.id AS id_2, p1_.title AS title_3, p1_.description AS description_4, p1_.info AS info_5, p1_.ai_prompt_en AS ai_prompt_en_6, p1_.ai_prompt_fr AS ai_prompt_fr_7, p1_.name AS name_8, c0_.campaign_id AS campaign_id_9, c0_.pool_id AS pool_id_10 FROM campaign_pool c0_ LEFT JOIN pool p1_ ON c0_.pool_id = p1_.id WHERE c0_.campaign_id = ? ORDER BY c0_.message_order ASC
Parameters:
[
  1
]
2.19 ms
(10.06%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.code AS code_4, t0.foresight_id AS foresight_id_5, t0.enabled AS enabled_6, t0.token AS token_7, t0.whatsapp_number_id AS whatsapp_number_id_8, t0.messenger_page_id AS messenger_page_id_9, t0.messenger_page_token AS messenger_page_token_10, t0.completion_message AS completion_message_11, t0.provider_id AS provider_id_12 FROM campaign t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "66c4896f88ffa"
]
1.96 ms
(9.01%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.info AS info_4, t0.ai_prompt_en AS ai_prompt_en_5, t0.ai_prompt_fr AS ai_prompt_fr_6, t0.name AS name_7 FROM pool t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "final_error"
]
1.83 ms
(8.38%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.lang AS lang_4, t0.pdc_url AS pdc_url_5, t0.cgu_url AS cgu_url_6, t0.base_url AS base_url_7, t0.logo_url AS logo_url_8, t0.intro_message AS intro_message_9 FROM provider t0 WHERE t0.id = ?
Parameters:
[
  3
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Campaign No errors.
App\Entity\Provider No errors.
App\Entity\CampaignPool No errors.
App\Entity\ProspectUser No errors.
App\Entity\Pool No errors.
App\Entity\Message No errors.
App\Entity\ErrorMessage No errors.
App\Entity\ProspectMessage No errors.