Symfony Profiler

SELECT
  r0_.id AS id_0,
  r0_.alphasia_id AS alphasia_id_1,
  r0_.chantier_id AS chantier_id_2,
  r0_.title AS title_3,
  r0_.type AS type_4,
  r0_.type_realisation AS type_realisation_5,
  r0_.type_realisation_label AS type_realisation_label_6,
  r0_.code_entreprise AS code_entreprise_7,
  r0_.client AS client_8,
  r0_.selection_dm AS selection_dm_9,
  r0_.fav AS fav_10,
  r0_.video_url AS video_url_11,
  r0_.created_at AS created_at_12,
  r0_.date_prise AS date_prise_13,
  r0_.dispo_site AS dispo_site_14,
  r0_.dispo_appli AS dispo_appli_15,
  r0_.description AS description_16,
  r0_.date_realisation AS date_realisation_17,
  r0_.ville AS ville_18,
  r0_.code_postal AS code_postal_19,
  r0_.affichage_franchise_seul AS affichage_franchise_seul_20,
  r0_.realisation_poussee AS realisation_poussee_21,
  r0_.slug AS slug_22,
  r0_.source_modified_at AS source_modified_at_23,
  r0_.synced_at AS synced_at_24,
  p1_.id AS id_25,
  p1_.source_url AS source_url_26,
  p1_.local_path_big AS local_path_big_27,
  p1_.local_path_medium AS local_path_medium_28,
  p1_.width_big AS width_big_29,
  p1_.height_big AS height_big_30,
  p1_.width_medium AS width_medium_31,
  p1_.height_medium AS height_medium_32,
  p1_.source_timestamp AS source_timestamp_33,
  p1_.orientation AS orientation_34,
  p1_.cached AS cached_35,
  r2_.id AS id_36,
  r2_.code AS code_37,
  r2_.label AS label_38,
  r2_.alphasia_network_id AS alphasia_network_id_39,
  p3_.id AS id_40,
  p3_.nom AS nom_41,
  m4_.id AS id_42,
  m4_.nom AS nom_43,
  s5_.id AS id_44,
  s5_.nom AS nom_45,
  g6_.id AS id_46,
  g6_.nom AS nom_47,
  p1_.realisation_id AS realisation_id_48
FROM
  realisation r0_
  LEFT JOIN photo p1_ ON r0_.id = p1_.realisation_id
  LEFT JOIN realisation_reseau r7_ ON r0_.id = r7_.realisation_id
  LEFT JOIN reseau r2_ ON r2_.id = r7_.reseau_id
  LEFT JOIN realisation_produit r8_ ON r0_.id = r8_.realisation_id
  LEFT JOIN produit p3_ ON p3_.id = r8_.produit_id
  LEFT JOIN realisation_materiau r9_ ON r0_.id = r9_.realisation_id
  LEFT JOIN materiau m4_ ON m4_.id = r9_.materiau_id
  LEFT JOIN realisation_style r10_ ON r0_.id = r10_.realisation_id
  LEFT JOIN style s5_ ON s5_.id = r10_.style_id
  LEFT JOIN realisation_geographie r11_ ON r0_.id = r11_.realisation_id
  LEFT JOIN geographie g6_ ON g6_.id = r11_.geographie_id
  INNER JOIN realisation_reseau r13_ ON r0_.id = r13_.realisation_id
  INNER JOIN reseau r12_ ON r12_.id = r13_.reseau_id
WHERE
  r12_.code = ?
  AND r0_.type_realisation LIKE ?
  AND r0_.dispo_site = ?
  AND r0_.affichage_franchise_seul = ?
  AND r0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  r0_.created_at DESC

SELECT r0_.id AS id_0, r0_.alphasia_id AS alphasia_id_1, r0_.chantier_id AS chantier_id_2, r0_.title AS title_3, r0_.type AS type_4, r0_.type_realisation AS type_realisation_5, r0_.type_realisation_label AS type_realisation_label_6, r0_.code_entreprise AS code_entreprise_7, r0_.client AS client_8, r0_.selection_dm AS selection_dm_9, r0_.fav AS fav_10, r0_.video_url AS video_url_11, r0_.created_at AS created_at_12, r0_.date_prise AS date_prise_13, r0_.dispo_site AS dispo_site_14, r0_.dispo_appli AS dispo_appli_15, r0_.description AS description_16, r0_.date_realisation AS date_realisation_17, r0_.ville AS ville_18, r0_.code_postal AS code_postal_19, r0_.affichage_franchise_seul AS affichage_franchise_seul_20, r0_.realisation_poussee AS realisation_poussee_21, r0_.slug AS slug_22, r0_.source_modified_at AS source_modified_at_23, r0_.synced_at AS synced_at_24, p1_.id AS id_25, p1_.source_url AS source_url_26, p1_.local_path_big AS local_path_big_27, p1_.local_path_medium AS local_path_medium_28, p1_.width_big AS width_big_29, p1_.height_big AS height_big_30, p1_.width_medium AS width_medium_31, p1_.height_medium AS height_medium_32, p1_.source_timestamp AS source_timestamp_33, p1_.orientation AS orientation_34, p1_.cached AS cached_35, r2_.id AS id_36, r2_.code AS code_37, r2_.label AS label_38, r2_.alphasia_network_id AS alphasia_network_id_39, p3_.id AS id_40, p3_.nom AS nom_41, m4_.id AS id_42, m4_.nom AS nom_43, s5_.id AS id_44, s5_.nom AS nom_45, g6_.id AS id_46, g6_.nom AS nom_47, p1_.realisation_id AS realisation_id_48 FROM realisation r0_ LEFT JOIN photo p1_ ON r0_.id = p1_.realisation_id LEFT JOIN realisation_reseau r7_ ON r0_.id = r7_.realisation_id LEFT JOIN reseau r2_ ON r2_.id = r7_.reseau_id LEFT JOIN realisation_produit r8_ ON r0_.id = r8_.realisation_id LEFT JOIN produit p3_ ON p3_.id = r8_.produit_id LEFT JOIN realisation_materiau r9_ ON r0_.id = r9_.realisation_id LEFT JOIN materiau m4_ ON m4_.id = r9_.materiau_id LEFT JOIN realisation_style r10_ ON r0_.id = r10_.realisation_id LEFT JOIN style s5_ ON s5_.id = r10_.style_id LEFT JOIN realisation_geographie r11_ ON r0_.id = r11_.realisation_id LEFT JOIN geographie g6_ ON g6_.id = r11_.geographie_id INNER JOIN realisation_reseau r13_ ON r0_.id = r13_.realisation_id INNER JOIN reseau r12_ ON r12_.id = r13_.reseau_id WHERE r12_.code = 'DMP' AND r0_.type_realisation LIKE 'piscine%' AND r0_.dispo_site = 1 AND r0_.affichage_franchise_seul = 0 AND r0_.id IN (155, 154, 4182, 4183, 4187, 4186, 4185, 4184, 4181, 4188, 4189, 4190) ORDER BY r0_.created_at DESC;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      created_at_12
    FROM
      (
        SELECT
          r0_.id AS id_0,
          r0_.alphasia_id AS alphasia_id_1,
          r0_.chantier_id AS chantier_id_2,
          r0_.title AS title_3,
          r0_.type AS type_4,
          r0_.type_realisation AS type_realisation_5,
          r0_.type_realisation_label AS type_realisation_label_6,
          r0_.code_entreprise AS code_entreprise_7,
          r0_.client AS client_8,
          r0_.selection_dm AS selection_dm_9,
          r0_.fav AS fav_10,
          r0_.video_url AS video_url_11,
          r0_.created_at AS created_at_12,
          r0_.date_prise AS date_prise_13,
          r0_.dispo_site AS dispo_site_14,
          r0_.dispo_appli AS dispo_appli_15,
          r0_.description AS description_16,
          r0_.date_realisation AS date_realisation_17,
          r0_.ville AS ville_18,
          r0_.code_postal AS code_postal_19,
          r0_.affichage_franchise_seul AS affichage_franchise_seul_20,
          r0_.realisation_poussee AS realisation_poussee_21,
          r0_.slug AS slug_22,
          r0_.source_modified_at AS source_modified_at_23,
          r0_.synced_at AS synced_at_24,
          p1_.id AS id_25,
          p1_.source_url AS source_url_26,
          p1_.local_path_big AS local_path_big_27,
          p1_.local_path_medium AS local_path_medium_28,
          p1_.width_big AS width_big_29,
          p1_.height_big AS height_big_30,
          p1_.width_medium AS width_medium_31,
          p1_.height_medium AS height_medium_32,
          p1_.source_timestamp AS source_timestamp_33,
          p1_.orientation AS orientation_34,
          p1_.cached AS cached_35,
          r2_.id AS id_36,
          r2_.code AS code_37,
          r2_.label AS label_38,
          r2_.alphasia_network_id AS alphasia_network_id_39,
          p3_.id AS id_40,
          p3_.nom AS nom_41,
          m4_.id AS id_42,
          m4_.nom AS nom_43,
          s5_.id AS id_44,
          s5_.nom AS nom_45,
          g6_.id AS id_46,
          g6_.nom AS nom_47,
          r7_.id AS id_48,
          r7_.code AS code_49,
          r7_.label AS label_50,
          r7_.alphasia_network_id AS alphasia_network_id_51
        FROM
          realisation r0_
          LEFT JOIN photo p1_ ON r0_.id = p1_.realisation_id
          LEFT JOIN realisation_reseau r8_ ON r0_.id = r8_.realisation_id
          LEFT JOIN reseau r2_ ON r2_.id = r8_.reseau_id
          LEFT JOIN realisation_produit r9_ ON r0_.id = r9_.realisation_id
          LEFT JOIN produit p3_ ON p3_.id = r9_.produit_id
          LEFT JOIN realisation_materiau r10_ ON r0_.id = r10_.realisation_id
          LEFT JOIN materiau m4_ ON m4_.id = r10_.materiau_id
          LEFT JOIN realisation_style r11_ ON r0_.id = r11_.realisation_id
          LEFT JOIN style s5_ ON s5_.id = r11_.style_id
          LEFT JOIN realisation_geographie r12_ ON r0_.id = r12_.realisation_id
          LEFT JOIN geographie g6_ ON g6_.id = r12_.geographie_id
          INNER JOIN realisation_reseau r13_ ON r0_.id = r13_.realisation_id
          INNER JOIN reseau r7_ ON r7_.id = r13_.reseau_id
        WHERE
          r7_.code = ?
          AND r0_.type_realisation LIKE ?
          AND r0_.dispo_site = ?
          AND r0_.affichage_franchise_seul = ?
      ) dctrn_result_inner
    ORDER BY
      created_at_12 DESC
  ) dctrn_result
LIMIT
  12

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_12 FROM (SELECT r0_.id AS id_0, r0_.alphasia_id AS alphasia_id_1, r0_.chantier_id AS chantier_id_2, r0_.title AS title_3, r0_.type AS type_4, r0_.type_realisation AS type_realisation_5, r0_.type_realisation_label AS type_realisation_label_6, r0_.code_entreprise AS code_entreprise_7, r0_.client AS client_8, r0_.selection_dm AS selection_dm_9, r0_.fav AS fav_10, r0_.video_url AS video_url_11, r0_.created_at AS created_at_12, r0_.date_prise AS date_prise_13, r0_.dispo_site AS dispo_site_14, r0_.dispo_appli AS dispo_appli_15, r0_.description AS description_16, r0_.date_realisation AS date_realisation_17, r0_.ville AS ville_18, r0_.code_postal AS code_postal_19, r0_.affichage_franchise_seul AS affichage_franchise_seul_20, r0_.realisation_poussee AS realisation_poussee_21, r0_.slug AS slug_22, r0_.source_modified_at AS source_modified_at_23, r0_.synced_at AS synced_at_24, p1_.id AS id_25, p1_.source_url AS source_url_26, p1_.local_path_big AS local_path_big_27, p1_.local_path_medium AS local_path_medium_28, p1_.width_big AS width_big_29, p1_.height_big AS height_big_30, p1_.width_medium AS width_medium_31, p1_.height_medium AS height_medium_32, p1_.source_timestamp AS source_timestamp_33, p1_.orientation AS orientation_34, p1_.cached AS cached_35, r2_.id AS id_36, r2_.code AS code_37, r2_.label AS label_38, r2_.alphasia_network_id AS alphasia_network_id_39, p3_.id AS id_40, p3_.nom AS nom_41, m4_.id AS id_42, m4_.nom AS nom_43, s5_.id AS id_44, s5_.nom AS nom_45, g6_.id AS id_46, g6_.nom AS nom_47, r7_.id AS id_48, r7_.code AS code_49, r7_.label AS label_50, r7_.alphasia_network_id AS alphasia_network_id_51 FROM realisation r0_ LEFT JOIN photo p1_ ON r0_.id = p1_.realisation_id LEFT JOIN realisation_reseau r8_ ON r0_.id = r8_.realisation_id LEFT JOIN reseau r2_ ON r2_.id = r8_.reseau_id LEFT JOIN realisation_produit r9_ ON r0_.id = r9_.realisation_id LEFT JOIN produit p3_ ON p3_.id = r9_.produit_id LEFT JOIN realisation_materiau r10_ ON r0_.id = r10_.realisation_id LEFT JOIN materiau m4_ ON m4_.id = r10_.materiau_id LEFT JOIN realisation_style r11_ ON r0_.id = r11_.realisation_id LEFT JOIN style s5_ ON s5_.id = r11_.style_id LEFT JOIN realisation_geographie r12_ ON r0_.id = r12_.realisation_id LEFT JOIN geographie g6_ ON g6_.id = r12_.geographie_id INNER JOIN realisation_reseau r13_ ON r0_.id = r13_.realisation_id INNER JOIN reseau r7_ ON r7_.id = r13_.reseau_id WHERE r7_.code = 'DMP' AND r0_.type_realisation LIKE 'piscine%' AND r0_.dispo_site = 1 AND r0_.affichage_franchise_seul = 0) dctrn_result_inner ORDER BY created_at_12 DESC) dctrn_result LIMIT 12;

SELECT
  COUNT(DISTINCT r0_.id) AS sclr_0
FROM
  realisation r0_
  INNER JOIN realisation_reseau r2_ ON r0_.id = r2_.realisation_id
  INNER JOIN reseau r1_ ON r1_.id = r2_.reseau_id
WHERE
  r1_.code = ?
  AND r0_.type_realisation LIKE ?
  AND r0_.dispo_site = ?
  AND r0_.affichage_franchise_seul = ?

SELECT COUNT(DISTINCT r0_.id) AS sclr_0 FROM realisation r0_ INNER JOIN realisation_reseau r2_ ON r0_.id = r2_.realisation_id INNER JOIN reseau r1_ ON r1_.id = r2_.reseau_id WHERE r1_.code = 'DMP' AND r0_.type_realisation LIKE 'piscine%' AND r0_.dispo_site = 1 AND r0_.affichage_franchise_seul = 0;

SELECT
  t0.id AS id_1,
  t0.api_key AS api_key_2,
  t0.name AS name_3,
  t0.active AS active_4,
  t0.created_at AS created_at_5
FROM
  api_key t0
WHERE
  t0.api_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.name AS name_3, t0.active AS active_4, t0.created_at AS created_at_5 FROM api_key t0 WHERE t0.api_key = 'e9cd5bbb94ff23fdd3ef6ff56bc638b87cec1ac66f99c2981957edd9f221f7b2' LIMIT 1;