Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.label AS label_3,
  t0.value AS value_4,
  t0.position AS position_5
FROM
  sf_configurations t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.value AS value_4, t0.position AS position_5 FROM sf_configurations t0 WHERE t0.name = 'IFC_Config_To_Email' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.label AS label_3,
  t0.value AS value_4,
  t0.position AS position_5
FROM
  sf_configurations t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.value AS value_4, t0.position AS position_5 FROM sf_configurations t0 WHERE t0.name = 'IFC_Config_From_Email' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.label AS label_3,
  t0.value AS value_4,
  t0.position AS position_5
FROM
  sf_configurations t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.value AS value_4, t0.position AS position_5 FROM sf_configurations t0 WHERE t0.name = 'IFC_Configs_Domain' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.shortname AS shortname_3,
  t0.description AS description_4,
  t0.price AS price_5,
  t0.position AS position_6,
  t0.type_produit AS type_produit_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.image AS image_10,
  t0.is_epreuve_only_choice AS is_epreuve_only_choice_11,
  t0.is_require_inscription_motif AS is_require_inscription_motif_12,
  t0.deleted AS deleted_13,
  t0.color AS color_14,
  t0.category_produit_id AS category_produit_id_15
FROM
  produit t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.shortname AS shortname_3, t0.description AS description_4, t0.price AS price_5, t0.position AS position_6, t0.type_produit AS type_produit_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.image AS image_10, t0.is_epreuve_only_choice AS is_epreuve_only_choice_11, t0.is_require_inscription_motif AS is_require_inscription_motif_12, t0.deleted AS deleted_13, t0.color AS color_14, t0.category_produit_id AS category_produit_id_15 FROM produit t0 WHERE t0.id = 5;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.session_start_date AS session_start_date_2,
  s0_.session_end_date AS session_end_date_3,
  s0_.registration_start_date AS registration_start_date_4,
  s0_.registration_end_date AS registration_end_date_5,
  s0_.created_at AS created_at_6,
  s0_.updated_at AS updated_at_7,
  s0_.date_debut_paiement AS date_debut_paiement_8,
  s0_.date_fin_paiement AS date_fin_paiement_9,
  s0_.dabut_creneau_paiement1 AS dabut_creneau_paiement1_10,
  s0_.fin_creneau_paiement1 AS fin_creneau_paiement1_11,
  s0_.dabut_creneau_paiement2 AS dabut_creneau_paiement2_12,
  s0_.fin_creneau_paiement2 AS fin_creneau_paiement2_13,
  s0_.date_tirage_paiement AS date_tirage_paiement_14,
  s0_.date_tirage_candidat AS date_tirage_candidat_15,
  s0_.duree_creneau_paiement AS duree_creneau_paiement_16,
  s0_.nombre_candidat_creneau_paiement AS nombre_candidat_creneau_paiement_17,
  s0_.active AS active_18,
  s0_.deleted AS deleted_19
FROM
  SESSION s0_
  INNER JOIN session_examen s1_ ON s0_.id = s1_.session_id
  INNER JOIN produit p2_ ON s1_.produit_id = p2_.id
WHERE
  p2_.id = ?
  AND s0_.session_end_date > ?
  AND s0_.active = 1
  AND s0_.deleted = 0
ORDER BY
  s0_.session_end_date ASC
LIMIT
  2

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.session_start_date AS session_start_date_2, s0_.session_end_date AS session_end_date_3, s0_.registration_start_date AS registration_start_date_4, s0_.registration_end_date AS registration_end_date_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.date_debut_paiement AS date_debut_paiement_8, s0_.date_fin_paiement AS date_fin_paiement_9, s0_.dabut_creneau_paiement1 AS dabut_creneau_paiement1_10, s0_.fin_creneau_paiement1 AS fin_creneau_paiement1_11, s0_.dabut_creneau_paiement2 AS dabut_creneau_paiement2_12, s0_.fin_creneau_paiement2 AS fin_creneau_paiement2_13, s0_.date_tirage_paiement AS date_tirage_paiement_14, s0_.date_tirage_candidat AS date_tirage_candidat_15, s0_.duree_creneau_paiement AS duree_creneau_paiement_16, s0_.nombre_candidat_creneau_paiement AS nombre_candidat_creneau_paiement_17, s0_.active AS active_18, s0_.deleted AS deleted_19 FROM SESSION s0_ INNER JOIN session_examen s1_ ON s0_.id = s1_.session_id INNER JOIN produit p2_ ON s1_.produit_id = p2_.id WHERE p2_.id = 5 AND s0_.session_end_date > '2024-12-23 14:51:42' AND s0_.active = 1 AND s0_.deleted = 0 ORDER BY s0_.session_end_date ASC LIMIT 2;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.shortname AS shortname_2,
  p0_.description AS description_3,
  p0_.price AS price_4,
  p0_.position AS position_5,
  p0_.type_produit AS type_produit_6,
  p0_.created_at AS created_at_7,
  p0_.updated_at AS updated_at_8,
  p0_.image AS image_9,
  p0_.is_epreuve_only_choice AS is_epreuve_only_choice_10,
  p0_.is_require_inscription_motif AS is_require_inscription_motif_11,
  p0_.deleted AS deleted_12,
  p0_.color AS color_13,
  p0_.category_produit_id AS category_produit_id_14
FROM
  produit p0_
WHERE
  p0_.type_produit = ?
  AND p0_.deleted = 0
GROUP BY
  p0_.id
ORDER BY
  p0_.name ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.shortname AS shortname_2, p0_.description AS description_3, p0_.price AS price_4, p0_.position AS position_5, p0_.type_produit AS type_produit_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.image AS image_9, p0_.is_epreuve_only_choice AS is_epreuve_only_choice_10, p0_.is_require_inscription_motif AS is_require_inscription_motif_11, p0_.deleted AS deleted_12, p0_.color AS color_13, p0_.category_produit_id AS category_produit_id_14 FROM produit p0_ WHERE p0_.type_produit = 'cours' AND p0_.deleted = 0 GROUP BY p0_.id ORDER BY p0_.name ASC;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.session_start_date AS session_start_date_2,
  s0_.session_end_date AS session_end_date_3,
  s0_.registration_start_date AS registration_start_date_4,
  s0_.registration_end_date AS registration_end_date_5,
  s0_.created_at AS created_at_6,
  s0_.updated_at AS updated_at_7,
  s0_.date_debut_paiement AS date_debut_paiement_8,
  s0_.date_fin_paiement AS date_fin_paiement_9,
  s0_.dabut_creneau_paiement1 AS dabut_creneau_paiement1_10,
  s0_.fin_creneau_paiement1 AS fin_creneau_paiement1_11,
  s0_.dabut_creneau_paiement2 AS dabut_creneau_paiement2_12,
  s0_.fin_creneau_paiement2 AS fin_creneau_paiement2_13,
  s0_.date_tirage_paiement AS date_tirage_paiement_14,
  s0_.date_tirage_candidat AS date_tirage_candidat_15,
  s0_.duree_creneau_paiement AS duree_creneau_paiement_16,
  s0_.nombre_candidat_creneau_paiement AS nombre_candidat_creneau_paiement_17,
  s0_.active AS active_18,
  s0_.deleted AS deleted_19
FROM
  SESSION s0_
  INNER JOIN session_examen s1_ ON s0_.id = s1_.session_id
  INNER JOIN produit p2_ ON s1_.produit_id = p2_.id
WHERE
  p2_.id = ?
  AND (
    ? >= s0_.registration_start_date
    AND ? <= s0_.registration_end_date
  )
  AND s0_.active = 1
  AND s0_.deleted = 0
ORDER BY
  s0_.registration_start_date ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.session_start_date AS session_start_date_2, s0_.session_end_date AS session_end_date_3, s0_.registration_start_date AS registration_start_date_4, s0_.registration_end_date AS registration_end_date_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.date_debut_paiement AS date_debut_paiement_8, s0_.date_fin_paiement AS date_fin_paiement_9, s0_.dabut_creneau_paiement1 AS dabut_creneau_paiement1_10, s0_.fin_creneau_paiement1 AS fin_creneau_paiement1_11, s0_.dabut_creneau_paiement2 AS dabut_creneau_paiement2_12, s0_.fin_creneau_paiement2 AS fin_creneau_paiement2_13, s0_.date_tirage_paiement AS date_tirage_paiement_14, s0_.date_tirage_candidat AS date_tirage_candidat_15, s0_.duree_creneau_paiement AS duree_creneau_paiement_16, s0_.nombre_candidat_creneau_paiement AS nombre_candidat_creneau_paiement_17, s0_.active AS active_18, s0_.deleted AS deleted_19 FROM SESSION s0_ INNER JOIN session_examen s1_ ON s0_.id = s1_.session_id INNER JOIN produit p2_ ON s1_.produit_id = p2_.id WHERE p2_.id = 5 AND ('2024-12-23 14:51:42' >= s0_.registration_start_date AND '2024-12-23 14:51:42' <= s0_.registration_end_date) AND s0_.active = 1 AND s0_.deleted = 0 ORDER BY s0_.registration_start_date ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.label AS label_3,
  t0.value AS value_4,
  t0.position AS position_5
FROM
  sf_configurations t0
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.value AS value_4, t0.position AS position_5 FROM sf_configurations t0 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.label AS label_3,
  t0.value AS value_4,
  t0.position AS position_5
FROM
  sf_configurations t0
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.value AS value_4, t0.position AS position_5 FROM sf_configurations t0 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.hook AS hook_3,
  t0.menu_type AS menu_type_4,
  t0.active AS active_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  menu t0
WHERE
  t0.hook = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.hook AS hook_3, t0.menu_type AS menu_type_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM menu t0 WHERE t0.hook = 'Top' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.value AS value_4,
  t0.link_value AS link_value_5,
  t0.blank_target AS blank_target_6,
  t0.active AS active_7,
  t0.cliquable AS cliquable_8,
  t0.position AS position_9,
  t0.display_children AS display_children_10,
  t0.display_title AS display_title_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.menu_id AS menu_id_14,
  t0.parent_item_menu_id AS parent_item_menu_id_15,
  t0.c_mspage_id AS c_mspage_id_16
FROM
  menu_item t0
WHERE
  t0.menu_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.value AS value_4, t0.link_value AS link_value_5, t0.blank_target AS blank_target_6, t0.active AS active_7, t0.cliquable AS cliquable_8, t0.position AS position_9, t0.display_children AS display_children_10, t0.display_title AS display_title_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.menu_id AS menu_id_14, t0.parent_item_menu_id AS parent_item_menu_id_15, t0.c_mspage_id AS c_mspage_id_16 FROM menu_item t0 WHERE t0.menu_id = 1 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.price AS price_4,
  t0.is_required AS is_required_5,
  t0.produit_id AS produit_id_6
FROM
  epreuve_produit t0
WHERE
  t0.produit_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.is_required AS is_required_5, t0.produit_id AS produit_id_6 FROM epreuve_produit t0 WHERE t0.produit_id = 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.position AS position_3,
  t0.description AS description_4
FROM
  category_produit t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.description AS description_4 FROM category_produit t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.shortname AS shortname_3,
  t0.description AS description_4,
  t0.price AS price_5,
  t0.position AS position_6,
  t0.type_produit AS type_produit_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.image AS image_10,
  t0.is_epreuve_only_choice AS is_epreuve_only_choice_11,
  t0.is_require_inscription_motif AS is_require_inscription_motif_12,
  t0.deleted AS deleted_13,
  t0.color AS color_14,
  t0.category_produit_id AS category_produit_id_15
FROM
  produit t0
WHERE
  (
    (
      t0.type_produit = ?
      AND t0.deleted = ?
    )
    AND t0.category_produit_id = ?
  )
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.shortname AS shortname_3, t0.description AS description_4, t0.price AS price_5, t0.position AS position_6, t0.type_produit AS type_produit_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.image AS image_10, t0.is_epreuve_only_choice AS is_epreuve_only_choice_11, t0.is_require_inscription_motif AS is_require_inscription_motif_12, t0.deleted AS deleted_13, t0.color AS color_14, t0.category_produit_id AS category_produit_id_15 FROM produit t0 WHERE ((t0.type_produit = 'cours' AND t0.deleted = 0) AND t0.category_produit_id = 2) ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.shortname AS shortname_3,
  t0.description AS description_4,
  t0.price AS price_5,
  t0.position AS position_6,
  t0.type_produit AS type_produit_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.image AS image_10,
  t0.is_epreuve_only_choice AS is_epreuve_only_choice_11,
  t0.is_require_inscription_motif AS is_require_inscription_motif_12,
  t0.deleted AS deleted_13,
  t0.color AS color_14,
  t0.category_produit_id AS category_produit_id_15
FROM
  produit t0
WHERE
  (
    (
      t0.type_produit = ?
      AND t0.deleted = ?
    )
    AND t0.category_produit_id = ?
  )
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.shortname AS shortname_3, t0.description AS description_4, t0.price AS price_5, t0.position AS position_6, t0.type_produit AS type_produit_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.image AS image_10, t0.is_epreuve_only_choice AS is_epreuve_only_choice_11, t0.is_require_inscription_motif AS is_require_inscription_motif_12, t0.deleted AS deleted_13, t0.color AS color_14, t0.category_produit_id AS category_produit_id_15 FROM produit t0 WHERE ((t0.type_produit = 'cours' AND t0.deleted = 0) AND t0.category_produit_id = 2) ORDER BY t0.position ASC;