Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.type_reference AS type_reference_2,
  t0.id_element AS id_element_3,
  t0.language AS language_4,
  t0.name AS name_5
FROM
  reference_list t0

SELECT t0.id AS id_1, t0.type_reference AS type_reference_2, t0.id_element AS id_element_3, t0.language AS language_4, t0.name AS name_5 FROM reference_list t0;

SELECT
  r0_.id_element AS id_element_0,
  r0_.name AS name_1,
  r1_.id_element AS id_element_2,
  r0_.language AS language_3,
  r0_.type_reference AS type_reference_4
FROM
  reference_list_relation r1_
  INNER JOIN reference_list r0_ ON (
    r0_.id_element = r1_.reference_list_element
  )

SELECT r0_.id_element AS id_element_0, r0_.name AS name_1, r1_.id_element AS id_element_2, r0_.language AS language_3, r0_.type_reference AS type_reference_4 FROM reference_list_relation r1_ INNER JOIN reference_list r0_ ON (r0_.id_element = r1_.reference_list_element);

SELECT
  t0.id AS id_1,
  t0.type_reference AS type_reference_2,
  t0.id_element AS id_element_3,
  t0.language AS language_4,
  t0.name AS name_5
FROM
  reference_list t0

SELECT t0.id AS id_1, t0.type_reference AS type_reference_2, t0.id_element AS id_element_3, t0.language AS language_4, t0.name AS name_5 FROM reference_list t0;

SELECT
  t0.id AS id_1,
  t0.data AS data_2,
  t0.help AS help_3,
  t0.id_mail_account AS id_mail_account_4,
  t0.id_user AS id_user_5
FROM
  customized_filter t0
WHERE
  t0.id_mail_account IS NULL

SELECT t0.id AS id_1, t0.data AS data_2, t0.help AS help_3, t0.id_mail_account AS id_mail_account_4, t0.id_user AS id_user_5 FROM customized_filter t0 WHERE t0.id_mail_account IS NULL;

SELECT
  g0_.id AS id_0,
  g0_.name AS name_1,
  g0_.status AS status_2,
  g0_.max_winners AS max_winners_3,
  g0_.reward AS reward_4,
  g0_.begin_date AS begin_date_5,
  g0_.end_date AS end_date_6,
  g0_.created_at AS created_at_7,
  g0_.teams AS teams_8,
  g0_.created_by AS created_by_9
FROM
  gamification_config g0_
WHERE
  g0_.end_date >= ?
  AND g0_.status = ?
ORDER BY
  g0_.end_date DESC

SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.status AS status_2, g0_.max_winners AS max_winners_3, g0_.reward AS reward_4, g0_.begin_date AS begin_date_5, g0_.end_date AS end_date_6, g0_.created_at AS created_at_7, g0_.teams AS teams_8, g0_.created_by AS created_by_9 FROM gamification_config g0_ WHERE g0_.end_date >= '2024-09-21 00:00:00' AND g0_.status = 1 ORDER BY g0_.end_date DESC;

SELECT
  g0_.id AS id_0,
  g0_.name AS name_1,
  g0_.status AS status_2,
  g0_.max_winners AS max_winners_3,
  g0_.reward AS reward_4,
  g0_.begin_date AS begin_date_5,
  g0_.end_date AS end_date_6,
  g0_.created_at AS created_at_7,
  g0_.teams AS teams_8,
  g0_.created_by AS created_by_9
FROM
  gamification_config g0_
WHERE
  g0_.status = ?
ORDER BY
  g0_.end_date DESC

SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.status AS status_2, g0_.max_winners AS max_winners_3, g0_.reward AS reward_4, g0_.begin_date AS begin_date_5, g0_.end_date AS end_date_6, g0_.created_at AS created_at_7, g0_.teams AS teams_8, g0_.created_by AS created_by_9 FROM gamification_config g0_ WHERE g0_.status = 4 ORDER BY g0_.end_date DESC;

SELECT
  g0_.id AS id_0,
  g0_.score_total AS score_total_1,
  g0_.level AS level_2,
  g0_.is_rewarded AS is_rewarded_3,
  g0_.created_at AS created_at_4,
  g0_.id_gamification_config AS id_gamification_config_5,
  g0_.id_user AS id_user_6
FROM
  gamification_user_score g0_
WHERE
  g0_.id_user = ?
  AND g0_.id_gamification_config = ?

SELECT g0_.id AS id_0, g0_.score_total AS score_total_1, g0_.level AS level_2, g0_.is_rewarded AS is_rewarded_3, g0_.created_at AS created_at_4, g0_.id_gamification_config AS id_gamification_config_5, g0_.id_user AS id_user_6 FROM gamification_user_score g0_ WHERE g0_.id_user = NULL AND g0_.id_gamification_config = 10;

SELECT
  h0_.id AS id_0,
  h0_.name AS name_1,
  h0_.type AS type_2,
  h0_.message AS message_3,
  h0_.page AS page_4,
  h0_.modal AS modal_5
FROM
  help_information h0_
WHERE
  LOWER(
    REPLACE(h0_.page, 'https://', '')
  ) = ?
  AND h0_.type = ?
LIMIT
  1

SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.type AS type_2, h0_.message AS message_3, h0_.page AS page_4, h0_.modal AS modal_5 FROM help_information h0_ WHERE LOWER(REPLACE(h0_.page, 'https://', '')) = 'dev3.myoverview.fr/login' AND h0_.type = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.price_month AS price_month_3,
  t0.standard_price_month AS standard_price_month_4,
  t0.price_year AS price_year_5,
  t0.standard_price_year AS standard_price_year_6,
  t0.nb_days_trial AS nb_days_trial_7
FROM
  app_module t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.price_month AS price_month_3, t0.standard_price_month AS standard_price_month_4, t0.price_year AS price_year_5, t0.standard_price_year AS standard_price_year_6, t0.nb_days_trial AS nb_days_trial_7 FROM app_module t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.app_key AS app_key_2,
  t0.value AS value_3,
  t0.id_entity AS id_entity_4
FROM
  app_data t0
WHERE
  t0.id_entity = ?

SELECT t0.id AS id_1, t0.app_key AS app_key_2, t0.value AS value_3, t0.id_entity AS id_entity_4 FROM app_data t0 WHERE t0.id_entity = 2;

SELECT
  t0.id AS id_1,
  t0.app_key AS app_key_2,
  t0.value AS value_3,
  t0.id_entity AS id_entity_4
FROM
  app_data t0
WHERE
  t0.id_entity = ?

SELECT t0.id AS id_1, t0.app_key AS app_key_2, t0.value AS value_3, t0.id_entity AS id_entity_4 FROM app_data t0 WHERE t0.id_entity = 2;

SELECT
  t0.id AS id_1,
  t0.app_key AS app_key_2,
  t0.value AS value_3,
  t0.id_entity AS id_entity_4
FROM
  app_data t0
WHERE
  t0.id_entity = ?

SELECT t0.id AS id_1, t0.app_key AS app_key_2, t0.value AS value_3, t0.id_entity AS id_entity_4 FROM app_data t0 WHERE t0.id_entity = 2;

SELECT
  t0.id AS id_1,
  t0.app_key AS app_key_2,
  t0.value AS value_3,
  t0.id_entity AS id_entity_4
FROM
  app_data t0
WHERE
  t0.id_entity = ?

SELECT t0.id AS id_1, t0.app_key AS app_key_2, t0.value AS value_3, t0.id_entity AS id_entity_4 FROM app_data t0 WHERE t0.id_entity = 2;

SELECT
  t0.id AS id_1,
  t0.app_key AS app_key_2,
  t0.value AS value_3,
  t0.id_entity AS id_entity_4
FROM
  app_data t0
WHERE
  t0.id_entity = ?

SELECT t0.id AS id_1, t0.app_key AS app_key_2, t0.value AS value_3, t0.id_entity AS id_entity_4 FROM app_data t0 WHERE t0.id_entity = 2;

SELECT
  t0.id AS id_1,
  t0.app_key AS app_key_2,
  t0.value AS value_3,
  t0.id_entity AS id_entity_4
FROM
  app_data t0
WHERE
  t0.id_entity = ?

SELECT t0.id AS id_1, t0.app_key AS app_key_2, t0.value AS value_3, t0.id_entity AS id_entity_4 FROM app_data t0 WHERE t0.id_entity = 2;

SELECT
  t0.id AS id_1,
  t0.app_key AS app_key_2,
  t0.value AS value_3,
  t0.id_entity AS id_entity_4
FROM
  app_data t0
WHERE
  t0.app_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.app_key AS app_key_2, t0.value AS value_3, t0.id_entity AS id_entity_4 FROM app_data t0 WHERE t0.app_key = 'advice_popin' LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.app_key AS app_key_1,
  a0_.value AS value_2,
  a0_.id_entity AS id_entity_3
FROM
  app_data a0_
WHERE
  a0_.app_key = ?
  AND a0_.id_entity = ?

SELECT a0_.id AS id_0, a0_.app_key AS app_key_1, a0_.value AS value_2, a0_.id_entity AS id_entity_3 FROM app_data a0_ WHERE a0_.app_key = 'advice_popin' AND a0_.id_entity = 2;