Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.zip AS zip_4,
  t0.city AS city_5,
  t0.email AS email_6,
  t0.phone AS phone_7,
  t0.opening_hours AS opening_hours_8,
  t0.net_helium AS net_helium_9,
  t0.facebook AS facebook_10,
  t0.twitter AS twitter_11,
  t0.instagram AS instagram_12,
  t0.linkedin AS linkedin_13,
  t0.youtube AS youtube_14,
  t0.gta AS gta_15,
  t0.gtm AS gtm_16,
  t0.matomo AS matomo_17,
  t0.matomo_url AS matomo_url_18,
  t0.matomo_js AS matomo_js_19,
  t0.matomo_tracker AS matomo_tracker_20,
  t0.google_map AS google_map_21,
  t0.maintenance AS maintenance_22,
  t0.logo AS logo_23,
  t0.fav_icon AS fav_icon_24,
  t0.contact_url AS contact_url_25,
  t0.contact_background AS contact_background_26,
  t0.contact_latitude AS contact_latitude_27,
  t0.contact_longitude AS contact_longitude_28,
  t0.type_map AS type_map_29,
  t0.tarte_au_citron_url AS tarte_au_citron_url_30,
  t0.tarte_au_citron_js AS tarte_au_citron_js_31,
  t0.created_at AS created_at_32,
  t0.updated_at AS updated_at_33,
  t0.default_blog_image AS default_blog_image_34,
  t0.default_auction_image AS default_auction_image_35
FROM
  site t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.zip AS zip_4, t0.city AS city_5, t0.email AS email_6, t0.phone AS phone_7, t0.opening_hours AS opening_hours_8, t0.net_helium AS net_helium_9, t0.facebook AS facebook_10, t0.twitter AS twitter_11, t0.instagram AS instagram_12, t0.linkedin AS linkedin_13, t0.youtube AS youtube_14, t0.gta AS gta_15, t0.gtm AS gtm_16, t0.matomo AS matomo_17, t0.matomo_url AS matomo_url_18, t0.matomo_js AS matomo_js_19, t0.matomo_tracker AS matomo_tracker_20, t0.google_map AS google_map_21, t0.maintenance AS maintenance_22, t0.logo AS logo_23, t0.fav_icon AS fav_icon_24, t0.contact_url AS contact_url_25, t0.contact_background AS contact_background_26, t0.contact_latitude AS contact_latitude_27, t0.contact_longitude AS contact_longitude_28, t0.type_map AS type_map_29, t0.tarte_au_citron_url AS tarte_au_citron_url_30, t0.tarte_au_citron_js AS tarte_au_citron_js_31, t0.created_at AS created_at_32, t0.updated_at AS updated_at_33, t0.default_blog_image AS default_blog_image_34, t0.default_auction_image AS default_auction_image_35 FROM site t0 WHERE t0.id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.image AS image_4,
  t0.slug AS slug_5,
  t0.display AS display_6,
  t0.description AS description_7,
  t0.price AS price_8,
  t0.position_section AS position_section_9,
  t0.display_section AS display_section_10,
  t0.position_carrousel AS position_carrousel_11,
  t0.display_carrousel AS display_carrousel_12,
  t0.start_date AS start_date_13,
  t0.end_date AS end_date_14,
  t0.consultant AS consultant_15,
  t0.exposition AS exposition_16,
  t0.interencheres_link AS interencheres_link_17,
  t0.drouot_link AS drouot_link_18,
  t0.import_id AS import_id_19,
  t0.created_at AS created_at_20,
  t0.updated_at AS updated_at_21,
  t0.image_pdf AS image_pdf_22,
  t23.id AS id_24,
  t23.street AS street_25,
  t23.postal_code AS postal_code_26,
  t23.city AS city_27,
  t23.created_at AS created_at_28,
  t23.updated_at AS updated_at_29,
  t23.auction_id AS auction_id_30
FROM
  auction t0
  LEFT JOIN address_auction t23 ON t23.auction_id = t0.id
WHERE
  t0.slug = ?
  AND t0.display = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.image AS image_4, t0.slug AS slug_5, t0.display AS display_6, t0.description AS description_7, t0.price AS price_8, t0.position_section AS position_section_9, t0.display_section AS display_section_10, t0.position_carrousel AS position_carrousel_11, t0.display_carrousel AS display_carrousel_12, t0.start_date AS start_date_13, t0.end_date AS end_date_14, t0.consultant AS consultant_15, t0.exposition AS exposition_16, t0.interencheres_link AS interencheres_link_17, t0.drouot_link AS drouot_link_18, t0.import_id AS import_id_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.image_pdf AS image_pdf_22, t23.id AS id_24, t23.street AS street_25, t23.postal_code AS postal_code_26, t23.city AS city_27, t23.created_at AS created_at_28, t23.updated_at AS updated_at_29, t23.auction_id AS auction_id_30 FROM auction t0 LEFT JOIN address_auction t23 ON t23.auction_id = t0.id WHERE t0.slug = '235-militaria' AND t0.display = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.agence AS agence_2,
  t0.agence_address AS agence_address_3,
  t0.agence_zip AS agence_zip_4,
  t0.agence_city AS agence_city_5,
  t0.agence_email AS agence_email_6,
  t0.agence_phone AS agence_phone_7,
  t0.agence_opening_hours AS agence_opening_hours_8,
  t0.agence_contact_url AS agence_contact_url_9,
  t0.agence_contact_latitude AS agence_contact_latitude_10,
  t0.agence_contact_longitude AS agence_contact_longitude_11,
  t0.agence_nethelium AS agence_nethelium_12,
  t0.agence_contact_zoom AS agence_contact_zoom_13,
  t0.breadcrumb AS breadcrumb_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.title AS title_17,
  t0.meta_title AS meta_title_18,
  t0.meta_description AS meta_description_19,
  t0.affichage_menu AS affichage_menu_20,
  t0.slug AS slug_21,
  t0.display AS display_22,
  t0.no_index AS no_index_23,
  t0.primary_page AS primary_page_24,
  t0.parent_id AS parent_id_25
FROM
  page t0
WHERE
  t0.display = ?

SELECT t0.id AS id_1, t0.agence AS agence_2, t0.agence_address AS agence_address_3, t0.agence_zip AS agence_zip_4, t0.agence_city AS agence_city_5, t0.agence_email AS agence_email_6, t0.agence_phone AS agence_phone_7, t0.agence_opening_hours AS agence_opening_hours_8, t0.agence_contact_url AS agence_contact_url_9, t0.agence_contact_latitude AS agence_contact_latitude_10, t0.agence_contact_longitude AS agence_contact_longitude_11, t0.agence_nethelium AS agence_nethelium_12, t0.agence_contact_zoom AS agence_contact_zoom_13, t0.breadcrumb AS breadcrumb_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.title AS title_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.affichage_menu AS affichage_menu_20, t0.slug AS slug_21, t0.display AS display_22, t0.no_index AS no_index_23, t0.primary_page AS primary_page_24, t0.parent_id AS parent_id_25 FROM page t0 WHERE t0.display = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.libelle AS libelle_4,
  t0.public AS public_5
FROM
  parameter t0
WHERE
  t0.public = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.libelle AS libelle_4, t0.public AS public_5 FROM parameter t0 WHERE t0.public = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.libelle AS libelle_4,
  t0.public AS public_5
FROM
  parameter_module t0
WHERE
  t0.public = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.libelle AS libelle_4, t0.public AS public_5 FROM parameter_module t0 WHERE t0.public = 1;

SELECT
  p0_.id AS id_0,
  p0_.agence AS agence_1,
  p0_.agence_address AS agence_address_2,
  p0_.agence_zip AS agence_zip_3,
  p0_.agence_city AS agence_city_4,
  p0_.agence_email AS agence_email_5,
  p0_.agence_phone AS agence_phone_6,
  p0_.agence_opening_hours AS agence_opening_hours_7,
  p0_.agence_contact_url AS agence_contact_url_8,
  p0_.agence_contact_latitude AS agence_contact_latitude_9,
  p0_.agence_contact_longitude AS agence_contact_longitude_10,
  p0_.agence_nethelium AS agence_nethelium_11,
  p0_.agence_contact_zoom AS agence_contact_zoom_12,
  p0_.breadcrumb AS breadcrumb_13,
  p0_.created_at AS created_at_14,
  p0_.updated_at AS updated_at_15,
  p0_.title AS title_16,
  p0_.meta_title AS meta_title_17,
  p0_.meta_description AS meta_description_18,
  p0_.affichage_menu AS affichage_menu_19,
  p0_.slug AS slug_20,
  p0_.display AS display_21,
  p0_.no_index AS no_index_22,
  p0_.primary_page AS primary_page_23,
  p0_.parent_id AS parent_id_24
FROM
  page p0_
  LEFT JOIN page p1_ ON p0_.parent_id = p1_.id
  LEFT JOIN page p2_ ON p1_.parent_id = p2_.id
WHERE
  p0_.slug = ?
  AND p0_.display = 1
  AND p1_.slug = ?
  AND p2_.slug = ?
  AND p2_.parent_id IS NULL

SELECT p0_.id AS id_0, p0_.agence AS agence_1, p0_.agence_address AS agence_address_2, p0_.agence_zip AS agence_zip_3, p0_.agence_city AS agence_city_4, p0_.agence_email AS agence_email_5, p0_.agence_phone AS agence_phone_6, p0_.agence_opening_hours AS agence_opening_hours_7, p0_.agence_contact_url AS agence_contact_url_8, p0_.agence_contact_latitude AS agence_contact_latitude_9, p0_.agence_contact_longitude AS agence_contact_longitude_10, p0_.agence_nethelium AS agence_nethelium_11, p0_.agence_contact_zoom AS agence_contact_zoom_12, p0_.breadcrumb AS breadcrumb_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, p0_.title AS title_16, p0_.meta_title AS meta_title_17, p0_.meta_description AS meta_description_18, p0_.affichage_menu AS affichage_menu_19, p0_.slug AS slug_20, p0_.display AS display_21, p0_.no_index AS no_index_22, p0_.primary_page AS primary_page_23, p0_.parent_id AS parent_id_24 FROM page p0_ LEFT JOIN page p1_ ON p0_.parent_id = p1_.id LEFT JOIN page p2_ ON p1_.parent_id = p2_.id WHERE p0_.slug = '71830-civ-medaille-en-argent-de-l-administration-penitentiaire' AND p0_.display = 1 AND p1_.slug = '235-militaria' AND p2_.slug = 'vente-aux-encheres' AND p2_.parent_id IS NULL;

SELECT
  r0_.id AS id_0,
  r0_.old_url AS old_url_1,
  r0_.type AS type_2,
  r0_.created_at AS created_at_3,
  r0_.updated_at AS updated_at_4,
  r0_.page_id AS page_id_5
FROM
  redirection r0_
WHERE
  r0_.old_url = ?
  OR r0_.old_url = ?
  OR r0_.old_url = ?

SELECT r0_.id AS id_0, r0_.old_url AS old_url_1, r0_.type AS type_2, r0_.created_at AS created_at_3, r0_.updated_at AS updated_at_4, r0_.page_id AS page_id_5 FROM redirection r0_ WHERE r0_.old_url = 'vente-aux-encheres/235-militaria/71830-civ-medaille-en-argent-de-l-administration-penitentiaire' OR r0_.old_url = 'vente-aux-encheres/235-militaria/71830-civ-medaille-en-argent-de-l-administration-penitentiaire/' OR r0_.old_url = 'vente-aux-encheres/235-militaria/71830-civ-medaille-en-argent-de-l-administration-penitentiaire';

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.vignette_text AS vignette_text_3,
  t0.vignette_image AS vignette_image_4,
  t0.breadcrumb AS breadcrumb_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.title AS title_8,
  t0.meta_title AS meta_title_9,
  t0.meta_description AS meta_description_10,
  t0.affichage_menu AS affichage_menu_11,
  t0.display AS display_12,
  t0.no_index AS no_index_13,
  t0.primary_page AS primary_page_14,
  t0.parent_id AS parent_id_15
FROM
  blog_category t0
WHERE
  t0.slug = ?
  AND t0.display = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.vignette_text AS vignette_text_3, t0.vignette_image AS vignette_image_4, t0.breadcrumb AS breadcrumb_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.title AS title_8, t0.meta_title AS meta_title_9, t0.meta_description AS meta_description_10, t0.affichage_menu AS affichage_menu_11, t0.display AS display_12, t0.no_index AS no_index_13, t0.primary_page AS primary_page_14, t0.parent_id AS parent_id_15 FROM blog_category t0 WHERE t0.slug = '71830-civ-medaille-en-argent-de-l-administration-penitentiaire' AND t0.display = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.vignette_text AS vignette_text_2,
  t0.vignette_image AS vignette_image_3,
  t0.date_debut AS date_debut_4,
  t0.date_fin AS date_fin_5,
  t0.breadcrumb AS breadcrumb_6,
  t0.sub_title AS sub_title_7,
  t0.highlighted AS highlighted_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.title AS title_11,
  t0.meta_title AS meta_title_12,
  t0.meta_description AS meta_description_13,
  t0.affichage_menu AS affichage_menu_14,
  t0.slug AS slug_15,
  t0.display AS display_16,
  t0.no_index AS no_index_17,
  t0.primary_page AS primary_page_18
FROM
  blog_article t0
WHERE
  t0.slug = ?
  AND t0.display = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.vignette_text AS vignette_text_2, t0.vignette_image AS vignette_image_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.breadcrumb AS breadcrumb_6, t0.sub_title AS sub_title_7, t0.highlighted AS highlighted_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.title AS title_11, t0.meta_title AS meta_title_12, t0.meta_description AS meta_description_13, t0.affichage_menu AS affichage_menu_14, t0.slug AS slug_15, t0.display AS display_16, t0.no_index AS no_index_17, t0.primary_page AS primary_page_18 FROM blog_article t0 WHERE t0.slug = '71830-civ-medaille-en-argent-de-l-administration-penitentiaire' AND t0.display = 1 LIMIT 1;