Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.seo_title AS seo_title_3,
  t0.seo_meta_description AS seo_meta_description_4,
  t0.seo_h1 AS seo_h1_5,
  t0.seo_intro AS seo_intro_6,
  t0.seo_content AS seo_content_7,
  t0.cta_label AS cta_label_8,
  t0.faq AS faq_9,
  t0.hero_image_url AS hero_image_url_10,
  t0.hero_image_alt AS hero_image_alt_11,
  t0.status AS status_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.deleted_at AS deleted_at_15,
  t0.city_id AS city_id_16
FROM
  estimation_pages t0
WHERE
  t0.slug = ?
  AND t0.status = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.seo_title AS seo_title_3, t0.seo_meta_description AS seo_meta_description_4, t0.seo_h1 AS seo_h1_5, t0.seo_intro AS seo_intro_6, t0.seo_content AS seo_content_7, t0.cta_label AS cta_label_8, t0.faq AS faq_9, t0.hero_image_url AS hero_image_url_10, t0.hero_image_alt AS hero_image_alt_11, t0.status AS status_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.city_id AS city_id_16 FROM estimation_pages t0 WHERE t0.slug = 'tassin-la-demi-lune' AND t0.status = 'published' AND ((t0.deleted_at IS NULL)) LIMIT 1;

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.slug AS slug_2,
  d0_.description AS description_3,
  d0_.latitude AS latitude_4,
  d0_.longitude AS longitude_5,
  d0_.seo_title AS seo_title_6,
  d0_.seo_meta_description AS seo_meta_description_7,
  d0_.seo_h1 AS seo_h1_8,
  d0_.seo_content AS seo_content_9,
  d0_.status AS status_10,
  d0_.created_at AS created_at_11,
  d0_.updated_at AS updated_at_12,
  d0_.deleted_at AS deleted_at_13,
  d0_.city_id AS city_id_14
FROM
  districts d0_
WHERE
  (
    d0_.city_id = ?
    AND d0_.status = ?
  )
  AND (d0_.deleted_at IS NULL)
ORDER BY
  d0_.name ASC

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.slug AS slug_2, d0_.description AS description_3, d0_.latitude AS latitude_4, d0_.longitude AS longitude_5, d0_.seo_title AS seo_title_6, d0_.seo_meta_description AS seo_meta_description_7, d0_.seo_h1 AS seo_h1_8, d0_.seo_content AS seo_content_9, d0_.status AS status_10, d0_.created_at AS created_at_11, d0_.updated_at AS updated_at_12, d0_.deleted_at AS deleted_at_13, d0_.city_id AS city_id_14 FROM districts d0_ WHERE (d0_.city_id = 0x019F4B803A45764CB52EC3019F7A93B5 AND d0_.status = 'published') AND (d0_.deleted_at IS NULL) ORDER BY d0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.baseline AS baseline_4,
  t0.description AS description_5,
  t0.hero_image_url AS hero_image_url_6,
  t0.seo_title AS seo_title_7,
  t0.seo_meta_description AS seo_meta_description_8,
  t0.seo_h1 AS seo_h1_9,
  t0.seo_content AS seo_content_10,
  t0.status AS status_11,
  t0.display_order AS display_order_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.deleted_at AS deleted_at_15,
  t0.agency_id AS agency_id_16
FROM
  territories t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.baseline AS baseline_4, t0.description AS description_5, t0.hero_image_url AS hero_image_url_6, t0.seo_title AS seo_title_7, t0.seo_meta_description AS seo_meta_description_8, t0.seo_h1 AS seo_h1_9, t0.seo_content AS seo_content_10, t0.status AS status_11, t0.display_order AS display_order_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.agency_id AS agency_id_16 FROM territories t0 WHERE t0.id = 0x019F4B803A3779F4A7ABAD7D547B7968 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.legal_name AS legal_name_4,
  t0.commercial_name AS commercial_name_5,
  t0.siret AS siret_6,
  t0.vat_number AS vat_number_7,
  t0.hektor_id AS hektor_id_8,
  t0.address AS address_9,
  t0.postal_code AS postal_code_10,
  t0.city AS city_11,
  t0.country AS country_12,
  t0.phone AS phone_13,
  t0.email AS email_14,
  t0.website_url AS website_url_15,
  t0.logo_url AS logo_url_16,
  t0.primary_color AS primary_color_17,
  t0.secondary_color AS secondary_color_18,
  t0.google_business_url AS google_business_url_19,
  t0.google_review_url AS google_review_url_20,
  t0.linkedin_url AS linkedin_url_21,
  t0.facebook_url AS facebook_url_22,
  t0.instagram_url AS instagram_url_23,
  t0.youtube_url AS youtube_url_24,
  t0.latitude AS latitude_25,
  t0.longitude AS longitude_26,
  t0.status AS status_27,
  t0.seo_title AS seo_title_28,
  t0.seo_meta_description AS seo_meta_description_29,
  t0.seo_h1 AS seo_h1_30,
  t0.seo_content AS seo_content_31,
  t0.created_at AS created_at_32,
  t0.updated_at AS updated_at_33,
  t0.deleted_at AS deleted_at_34
FROM
  agencies t0
WHERE
  t0.status = ?
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legal_name AS legal_name_4, t0.commercial_name AS commercial_name_5, t0.siret AS siret_6, t0.vat_number AS vat_number_7, t0.hektor_id AS hektor_id_8, t0.address AS address_9, t0.postal_code AS postal_code_10, t0.city AS city_11, t0.country AS country_12, t0.phone AS phone_13, t0.email AS email_14, t0.website_url AS website_url_15, t0.logo_url AS logo_url_16, t0.primary_color AS primary_color_17, t0.secondary_color AS secondary_color_18, t0.google_business_url AS google_business_url_19, t0.google_review_url AS google_review_url_20, t0.linkedin_url AS linkedin_url_21, t0.facebook_url AS facebook_url_22, t0.instagram_url AS instagram_url_23, t0.youtube_url AS youtube_url_24, t0.latitude AS latitude_25, t0.longitude AS longitude_26, t0.status AS status_27, t0.seo_title AS seo_title_28, t0.seo_meta_description AS seo_meta_description_29, t0.seo_h1 AS seo_h1_30, t0.seo_content AS seo_content_31, t0.created_at AS created_at_32, t0.updated_at AS updated_at_33, t0.deleted_at AS deleted_at_34 FROM agencies t0 WHERE t0.status = 'active' AND ((t0.deleted_at IS NULL)) ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.postal_code AS postal_code_4,
  t0.department AS department_5,
  t0.region AS region_6,
  t0.latitude AS latitude_7,
  t0.longitude AS longitude_8,
  t0.population AS population_9,
  t0.seo_title AS seo_title_10,
  t0.seo_meta_description AS seo_meta_description_11,
  t0.seo_h1 AS seo_h1_12,
  t0.seo_intro AS seo_intro_13,
  t0.seo_content AS seo_content_14,
  t0.faq AS faq_15,
  t0.hero_image_url AS hero_image_url_16,
  t0.hero_image_alt AS hero_image_alt_17,
  t0.google_business_url AS google_business_url_18,
  t0.status AS status_19,
  t0.created_at AS created_at_20,
  t0.updated_at AS updated_at_21,
  t0.deleted_at AS deleted_at_22,
  t0.territory_id AS territory_id_23
FROM
  cities t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.postal_code AS postal_code_4, t0.department AS department_5, t0.region AS region_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.population AS population_9, t0.seo_title AS seo_title_10, t0.seo_meta_description AS seo_meta_description_11, t0.seo_h1 AS seo_h1_12, t0.seo_intro AS seo_intro_13, t0.seo_content AS seo_content_14, t0.faq AS faq_15, t0.hero_image_url AS hero_image_url_16, t0.hero_image_alt AS hero_image_alt_17, t0.google_business_url AS google_business_url_18, t0.status AS status_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.deleted_at AS deleted_at_22, t0.territory_id AS territory_id_23 FROM cities t0 WHERE t0.id = 0x019F4B803A45764CB52EC3019F7A93B5 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.postal_code AS postal_code_4,
  t0.department AS department_5,
  t0.region AS region_6,
  t0.latitude AS latitude_7,
  t0.longitude AS longitude_8,
  t0.population AS population_9,
  t0.seo_title AS seo_title_10,
  t0.seo_meta_description AS seo_meta_description_11,
  t0.seo_h1 AS seo_h1_12,
  t0.seo_intro AS seo_intro_13,
  t0.seo_content AS seo_content_14,
  t0.faq AS faq_15,
  t0.hero_image_url AS hero_image_url_16,
  t0.hero_image_alt AS hero_image_alt_17,
  t0.google_business_url AS google_business_url_18,
  t0.status AS status_19,
  t0.created_at AS created_at_20,
  t0.updated_at AS updated_at_21,
  t0.deleted_at AS deleted_at_22,
  t0.territory_id AS territory_id_23
FROM
  cities t0
WHERE
  t0.territory_id = ?
  AND t0.status = ?
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.postal_code AS postal_code_4, t0.department AS department_5, t0.region AS region_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.population AS population_9, t0.seo_title AS seo_title_10, t0.seo_meta_description AS seo_meta_description_11, t0.seo_h1 AS seo_h1_12, t0.seo_intro AS seo_intro_13, t0.seo_content AS seo_content_14, t0.faq AS faq_15, t0.hero_image_url AS hero_image_url_16, t0.hero_image_alt AS hero_image_alt_17, t0.google_business_url AS google_business_url_18, t0.status AS status_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.deleted_at AS deleted_at_22, t0.territory_id AS territory_id_23 FROM cities t0 WHERE t0.territory_id = 0x019F4B803A3779F4A7ABAD7D547B7968 AND t0.status = 'published' AND ((t0.deleted_at IS NULL)) ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.content AS content_4,
  t0.published AS published_5,
  t0.in_footer AS in_footer_6,
  t0.position AS position_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  legal_pages t0
WHERE
  t0.published = ?
  AND t0.in_footer = ?
ORDER BY
  t0.position ASC,
  t0.title ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.published AS published_5, t0.in_footer AS in_footer_6, t0.position AS position_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM legal_pages t0 WHERE t0.published = 1 AND t0.in_footer = 1 ORDER BY t0.position ASC, t0.title ASC;

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.category AS category_2,
  t0_.placement AS placement_3,
  t0_.code AS code_4,
  t0_.enabled AS enabled_5,
  t0_.position AS position_6,
  t0_.created_at AS created_at_7,
  t0_.updated_at AS updated_at_8
FROM
  tracking_scripts t0_
WHERE
  t0_.enabled = 1
ORDER BY
  t0_.position ASC,
  t0_.created_at ASC

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.category AS category_2, t0_.placement AS placement_3, t0_.code AS code_4, t0_.enabled AS enabled_5, t0_.position AS position_6, t0_.created_at AS created_at_7, t0_.updated_at AS updated_at_8 FROM tracking_scripts t0_ WHERE t0_.enabled = 1 ORDER BY t0_.position ASC, t0_.created_at ASC;