Symfony Profiler

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
  count(DISTINCT p0_.id) AS sclr_0
FROM
  post p0_
WHERE
  p0_.published = 1

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM post p0_ WHERE p0_.published = 1;

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
  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 = '1' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Post';

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
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.slug AS slug_2,
  p0_.content AS content_3,
  p0_.short_description AS short_description_4,
  p0_.thumbnail AS thumbnail_5,
  p0_.main_image AS main_image_6,
  p0_.published AS published_7,
  p0_.featured AS featured_8,
  p0_.updated_at AS updated_at_9,
  p0_.created_at AS created_at_10,
  p0_.category_id AS category_id_11
FROM
  post p0_
WHERE
  p0_.published = 1
  AND p0_.id IN (?)
ORDER BY
  p0_.created_at DESC

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.content AS content_3, p0_.short_description AS short_description_4, p0_.thumbnail AS thumbnail_5, p0_.main_image AS main_image_6, p0_.published AS published_7, p0_.featured AS featured_8, p0_.updated_at AS updated_at_9, p0_.created_at AS created_at_10, p0_.category_id AS category_id_11 FROM post p0_ WHERE p0_.published = 1 AND p0_.id IN (1) ORDER BY p0_.created_at DESC;

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
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.slug AS slug_2,
  p0_.content AS content_3,
  p0_.short_description AS short_description_4,
  p0_.thumbnail AS thumbnail_5,
  p0_.main_image AS main_image_6,
  p0_.published AS published_7,
  p0_.featured AS featured_8,
  p0_.updated_at AS updated_at_9,
  p0_.created_at AS created_at_10,
  p0_.category_id AS category_id_11
FROM
  post p0_
WHERE
  p0_.published = 1
  AND p0_.featured = 1
ORDER BY
  p0_.created_at DESC
LIMIT
  3

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.content AS content_3, p0_.short_description AS short_description_4, p0_.thumbnail AS thumbnail_5, p0_.main_image AS main_image_6, p0_.published AS published_7, p0_.featured AS featured_8, p0_.updated_at AS updated_at_9, p0_.created_at AS created_at_10, p0_.category_id AS category_id_11 FROM post p0_ WHERE p0_.published = 1 AND p0_.featured = 1 ORDER BY p0_.created_at DESC LIMIT 3;

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
  DISTINCT p0_.id AS id_0,
  p0_.created_at AS created_at_1
FROM
  post p0_
WHERE
  p0_.published = 1
ORDER BY
  p0_.created_at DESC
LIMIT
  9

SELECT DISTINCT p0_.id AS id_0, p0_.created_at AS created_at_1 FROM post p0_ WHERE p0_.published = 1 ORDER BY p0_.created_at DESC LIMIT 9;