Symfony Profiler

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2,
  s0_.meta_title AS meta_title_3,
  s0_.meta_description AS meta_description_4,
  s0_.h1 AS h1_5,
  s0_.content AS content_6,
  s0_.keywords AS keywords_7,
  s0_.is_active AS is_active_8,
  s0_.postal_code AS postal_code_9,
  s0_.region AS region_10,
  s0_.country AS country_11,
  s0_.city_image AS city_image_12,
  s0_.created_at AS created_at_13,
  s0_.updated_at AS updated_at_14
FROM
  seo_city s0_
WHERE
  s0_.is_active = ?
ORDER BY
  s0_.name ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.meta_title AS meta_title_3, s0_.meta_description AS meta_description_4, s0_.h1 AS h1_5, s0_.content AS content_6, s0_.keywords AS keywords_7, s0_.is_active AS is_active_8, s0_.postal_code AS postal_code_9, s0_.region AS region_10, s0_.country AS country_11, s0_.city_image AS city_image_12, s0_.created_at AS created_at_13, s0_.updated_at AS updated_at_14 FROM seo_city s0_ WHERE s0_.is_active = 1 ORDER BY s0_.name ASC;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2,
  s0_.meta_title AS meta_title_3,
  s0_.meta_description AS meta_description_4,
  s0_.h1 AS h1_5,
  s0_.content AS content_6,
  s0_.keywords AS keywords_7,
  s0_.is_active AS is_active_8,
  s0_.country_code AS country_code_9,
  s0_.continent AS continent_10,
  s0_.language AS language_11,
  s0_.created_at AS created_at_12,
  s0_.updated_at AS updated_at_13
FROM
  seo_country s0_
WHERE
  s0_.is_active = ?
ORDER BY
  s0_.name ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.meta_title AS meta_title_3, s0_.meta_description AS meta_description_4, s0_.h1 AS h1_5, s0_.content AS content_6, s0_.keywords AS keywords_7, s0_.is_active AS is_active_8, s0_.country_code AS country_code_9, s0_.continent AS continent_10, s0_.language AS language_11, s0_.created_at AS created_at_12, s0_.updated_at AS updated_at_13 FROM seo_country s0_ WHERE s0_.is_active = 1 ORDER BY s0_.name ASC;

SELECT
  c0_.id AS id_0,
  COALESCE(t1_.content, c0_.title) AS title_1,
  c0_.slug AS slug_2,
  COALESCE(t2_.content, c0_.content) AS content_3,
  COALESCE(t3_.content, c0_.meta_title) AS meta_title_4,
  COALESCE(
    t4_.content, c0_.meta_description
  ) AS meta_description_5,
  COALESCE(t5_.content, c0_.meta_keywords) AS meta_keywords_6,
  c0_.layout AS layout_7,
  c0_.published AS published_8,
  c0_.image1 AS image1_9,
  c0_.image2 AS image2_10,
  c0_.updated_at AS updated_at_11,
  c0_.created_at AS created_at_12
FROM
  custom_page c0_
  LEFT JOIN ext_translations t1_ ON t1_.locale = 'en'
  AND t1_.field = 'title'
  AND t1_.object_class = 'App\\Entity\\CustomPage'
  AND t1_.foreign_key = c0_.id
  LEFT JOIN ext_translations t2_ ON t2_.locale = 'en'
  AND t2_.field = 'content'
  AND t2_.object_class = 'App\\Entity\\CustomPage'
  AND t2_.foreign_key = c0_.id
  LEFT JOIN ext_translations t3_ ON t3_.locale = 'en'
  AND t3_.field = 'metaTitle'
  AND t3_.object_class = 'App\\Entity\\CustomPage'
  AND t3_.foreign_key = c0_.id
  LEFT JOIN ext_translations t4_ ON t4_.locale = 'en'
  AND t4_.field = 'metaDescription'
  AND t4_.object_class = 'App\\Entity\\CustomPage'
  AND t4_.foreign_key = c0_.id
  LEFT JOIN ext_translations t5_ ON t5_.locale = 'en'
  AND t5_.field = 'metaKeywords'
  AND t5_.object_class = 'App\\Entity\\CustomPage'
  AND t5_.foreign_key = c0_.id
WHERE
  c0_.slug = ?
  AND c0_.published = ?

SELECT c0_.id AS id_0, COALESCE(t1_.content, c0_.title) AS title_1, c0_.slug AS slug_2, COALESCE(t2_.content, c0_.content) AS content_3, COALESCE(t3_.content, c0_.meta_title) AS meta_title_4, COALESCE(t4_.content, c0_.meta_description) AS meta_description_5, COALESCE(t5_.content, c0_.meta_keywords) AS meta_keywords_6, c0_.layout AS layout_7, c0_.published AS published_8, c0_.image1 AS image1_9, c0_.image2 AS image2_10, c0_.updated_at AS updated_at_11, c0_.created_at AS created_at_12 FROM custom_page c0_ LEFT JOIN ext_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'title' AND t1_.object_class = 'App\\Entity\\CustomPage' AND t1_.foreign_key = c0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'en' AND t2_.field = 'content' AND t2_.object_class = 'App\\Entity\\CustomPage' AND t2_.foreign_key = c0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'metaTitle' AND t3_.object_class = 'App\\Entity\\CustomPage' AND t3_.foreign_key = c0_.id LEFT JOIN ext_translations t4_ ON t4_.locale = 'en' AND t4_.field = 'metaDescription' AND t4_.object_class = 'App\\Entity\\CustomPage' AND t4_.foreign_key = c0_.id LEFT JOIN ext_translations t5_ ON t5_.locale = 'en' AND t5_.field = 'metaKeywords' AND t5_.object_class = 'App\\Entity\\CustomPage' AND t5_.foreign_key = c0_.id WHERE c0_.slug = 'legal' AND c0_.published = 1;

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '3' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\CustomPage';

SELECT
  t0.id AS id_1,
  t0.author_name AS author_name_2,
  t0.author_url AS author_url_3,
  t0.profile_photo_url AS profile_photo_url_4,
  t0.rating AS rating_5,
  t0.text AS text_6,
  t0.time AS time_7,
  t0.is_active AS is_active_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  google_reviews t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.rating DESC,
  t0.created_at DESC
LIMIT
  50

SELECT t0.id AS id_1, t0.author_name AS author_name_2, t0.author_url AS author_url_3, t0.profile_photo_url AS profile_photo_url_4, t0.rating AS rating_5, t0.text AS text_6, t0.time AS time_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM google_reviews t0 WHERE t0.is_active = 1 ORDER BY t0.rating DESC, t0.created_at DESC LIMIT 50;

SELECT
  t0.id AS id_1,
  t0.author_name AS author_name_2,
  t0.author_url AS author_url_3,
  t0.profile_photo_url AS profile_photo_url_4,
  t0.rating AS rating_5,
  t0.text AS text_6,
  t0.time AS time_7,
  t0.is_active AS is_active_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  google_reviews t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.rating DESC,
  t0.created_at DESC
LIMIT
  5

SELECT t0.id AS id_1, t0.author_name AS author_name_2, t0.author_url AS author_url_3, t0.profile_photo_url AS profile_photo_url_4, t0.rating AS rating_5, t0.text AS text_6, t0.time AS time_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM google_reviews t0 WHERE t0.is_active = 1 ORDER BY t0.rating DESC, t0.created_at DESC LIMIT 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.email AS email_3,
  t0.complete_address AS complete_address_4,
  t0.number AS number_5,
  t0.description AS description_6,
  t0.siret AS siret_7,
  t0.siren AS siren_8,
  t0.day_limit_subscription AS day_limit_subscription_9,
  t0.trial_period_days_time AS trial_period_days_time_10,
  t0.trial_period_days_status AS trial_period_days_status_11,
  t0.type AS type_12,
  t0.website AS website_13,
  t0.capital_social AS capital_social_14,
  t0.updated_at AS updated_at_15,
  t0.created_at AS created_at_16
FROM
  manager t0
WHERE
  t0.type = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.complete_address AS complete_address_4, t0.number AS number_5, t0.description AS description_6, t0.siret AS siret_7, t0.siren AS siren_8, t0.day_limit_subscription AS day_limit_subscription_9, t0.trial_period_days_time AS trial_period_days_time_10, t0.trial_period_days_status AS trial_period_days_status_11, t0.type AS type_12, t0.website AS website_13, t0.capital_social AS capital_social_14, t0.updated_at AS updated_at_15, t0.created_at AS created_at_16 FROM manager t0 WHERE t0.type = 'manager' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.email AS email_3,
  t0.complete_address AS complete_address_4,
  t0.number AS number_5,
  t0.description AS description_6,
  t0.siret AS siret_7,
  t0.siren AS siren_8,
  t0.day_limit_subscription AS day_limit_subscription_9,
  t0.trial_period_days_time AS trial_period_days_time_10,
  t0.trial_period_days_status AS trial_period_days_status_11,
  t0.type AS type_12,
  t0.website AS website_13,
  t0.capital_social AS capital_social_14,
  t0.updated_at AS updated_at_15,
  t0.created_at AS created_at_16
FROM
  manager t0
WHERE
  t0.type = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.complete_address AS complete_address_4, t0.number AS number_5, t0.description AS description_6, t0.siret AS siret_7, t0.siren AS siren_8, t0.day_limit_subscription AS day_limit_subscription_9, t0.trial_period_days_time AS trial_period_days_time_10, t0.trial_period_days_status AS trial_period_days_status_11, t0.type AS type_12, t0.website AS website_13, t0.capital_social AS capital_social_14, t0.updated_at AS updated_at_15, t0.created_at AS created_at_16 FROM manager t0 WHERE t0.type = 'manager' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.email AS email_3,
  t0.complete_address AS complete_address_4,
  t0.number AS number_5,
  t0.description AS description_6,
  t0.siret AS siret_7,
  t0.siren AS siren_8,
  t0.day_limit_subscription AS day_limit_subscription_9,
  t0.trial_period_days_time AS trial_period_days_time_10,
  t0.trial_period_days_status AS trial_period_days_status_11,
  t0.type AS type_12,
  t0.website AS website_13,
  t0.capital_social AS capital_social_14,
  t0.updated_at AS updated_at_15,
  t0.created_at AS created_at_16
FROM
  manager t0
WHERE
  t0.type = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.complete_address AS complete_address_4, t0.number AS number_5, t0.description AS description_6, t0.siret AS siret_7, t0.siren AS siren_8, t0.day_limit_subscription AS day_limit_subscription_9, t0.trial_period_days_time AS trial_period_days_time_10, t0.trial_period_days_status AS trial_period_days_status_11, t0.type AS type_12, t0.website AS website_13, t0.capital_social AS capital_social_14, t0.updated_at AS updated_at_15, t0.created_at AS created_at_16 FROM manager t0 WHERE t0.type = 'manager' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.email AS email_3,
  t0.complete_address AS complete_address_4,
  t0.number AS number_5,
  t0.description AS description_6,
  t0.siret AS siret_7,
  t0.siren AS siren_8,
  t0.day_limit_subscription AS day_limit_subscription_9,
  t0.trial_period_days_time AS trial_period_days_time_10,
  t0.trial_period_days_status AS trial_period_days_status_11,
  t0.type AS type_12,
  t0.website AS website_13,
  t0.capital_social AS capital_social_14,
  t0.updated_at AS updated_at_15,
  t0.created_at AS created_at_16
FROM
  manager t0
WHERE
  t0.type = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.complete_address AS complete_address_4, t0.number AS number_5, t0.description AS description_6, t0.siret AS siret_7, t0.siren AS siren_8, t0.day_limit_subscription AS day_limit_subscription_9, t0.trial_period_days_time AS trial_period_days_time_10, t0.trial_period_days_status AS trial_period_days_status_11, t0.type AS type_12, t0.website AS website_13, t0.capital_social AS capital_social_14, t0.updated_at AS updated_at_15, t0.created_at AS created_at_16 FROM manager t0 WHERE t0.type = 'manager' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.email AS email_3,
  t0.complete_address AS complete_address_4,
  t0.number AS number_5,
  t0.description AS description_6,
  t0.siret AS siret_7,
  t0.siren AS siren_8,
  t0.day_limit_subscription AS day_limit_subscription_9,
  t0.trial_period_days_time AS trial_period_days_time_10,
  t0.trial_period_days_status AS trial_period_days_status_11,
  t0.type AS type_12,
  t0.website AS website_13,
  t0.capital_social AS capital_social_14,
  t0.updated_at AS updated_at_15,
  t0.created_at AS created_at_16
FROM
  manager t0
WHERE
  t0.type = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.complete_address AS complete_address_4, t0.number AS number_5, t0.description AS description_6, t0.siret AS siret_7, t0.siren AS siren_8, t0.day_limit_subscription AS day_limit_subscription_9, t0.trial_period_days_time AS trial_period_days_time_10, t0.trial_period_days_status AS trial_period_days_status_11, t0.type AS type_12, t0.website AS website_13, t0.capital_social AS capital_social_14, t0.updated_at AS updated_at_15, t0.created_at AS created_at_16 FROM manager t0 WHERE t0.type = 'manager' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.email AS email_3,
  t0.complete_address AS complete_address_4,
  t0.number AS number_5,
  t0.description AS description_6,
  t0.siret AS siret_7,
  t0.siren AS siren_8,
  t0.day_limit_subscription AS day_limit_subscription_9,
  t0.trial_period_days_time AS trial_period_days_time_10,
  t0.trial_period_days_status AS trial_period_days_status_11,
  t0.type AS type_12,
  t0.website AS website_13,
  t0.capital_social AS capital_social_14,
  t0.updated_at AS updated_at_15,
  t0.created_at AS created_at_16
FROM
  manager t0
WHERE
  t0.type = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.complete_address AS complete_address_4, t0.number AS number_5, t0.description AS description_6, t0.siret AS siret_7, t0.siren AS siren_8, t0.day_limit_subscription AS day_limit_subscription_9, t0.trial_period_days_time AS trial_period_days_time_10, t0.trial_period_days_status AS trial_period_days_status_11, t0.type AS type_12, t0.website AS website_13, t0.capital_social AS capital_social_14, t0.updated_at AS updated_at_15, t0.created_at AS created_at_16 FROM manager t0 WHERE t0.type = 'manager' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.email AS email_3,
  t0.complete_address AS complete_address_4,
  t0.number AS number_5,
  t0.description AS description_6,
  t0.siret AS siret_7,
  t0.siren AS siren_8,
  t0.day_limit_subscription AS day_limit_subscription_9,
  t0.trial_period_days_time AS trial_period_days_time_10,
  t0.trial_period_days_status AS trial_period_days_status_11,
  t0.type AS type_12,
  t0.website AS website_13,
  t0.capital_social AS capital_social_14,
  t0.updated_at AS updated_at_15,
  t0.created_at AS created_at_16
FROM
  manager t0
WHERE
  t0.type = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.complete_address AS complete_address_4, t0.number AS number_5, t0.description AS description_6, t0.siret AS siret_7, t0.siren AS siren_8, t0.day_limit_subscription AS day_limit_subscription_9, t0.trial_period_days_time AS trial_period_days_time_10, t0.trial_period_days_status AS trial_period_days_status_11, t0.type AS type_12, t0.website AS website_13, t0.capital_social AS capital_social_14, t0.updated_at AS updated_at_15, t0.created_at AS created_at_16 FROM manager t0 WHERE t0.type = 'manager' LIMIT 1;