| 1 |
2.26 ms |
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"
]
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 = '66c4896f88ffa' LIMIT 1;
|
| 2 |
2.01 ms |
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 = ?
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 = 3;
|
| 3 |
2.24 ms |
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
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 = 1 ORDER BY c0_.message_order ASC;
|
| 4 |
1.71 ms |
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 = ?
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 = 1 AND m0_.lang = 'fr';
|
| 5 |
1.41 ms |
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 = ?
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 = 2 AND m0_.lang = 'fr';
|
| 6 |
1.80 ms |
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 = ?
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 = 4 AND m0_.lang = 'fr';
|
| 7 |
1.73 ms |
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 = ?
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 = 6 AND m0_.lang = 'fr';
|
| 8 |
1.75 ms |
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 = ?
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 = 3 AND m0_.lang = 'fr';
|
| 9 |
1.36 ms |
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 = ?
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 = 7 AND m0_.lang = 'fr';
|
| 10 |
1.54 ms |
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"
]
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 = 'final_error' LIMIT 1;
|
| 11 |
1.29 ms |
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 = ?
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 = 21 AND m0_.lang = 'fr';
|