Symfony Profiler

SELECT
  COUNT(*)
FROM
  trainer t0
WHERE
  t0.status = ?

SELECT COUNT(*) FROM trainer t0 WHERE t0.status = 'ENABLED';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.enable AS enable_4,
  t0.updated_at AS updated_at_5,
  t0.seo_title AS seo_title_6,
  t0.seo_description AS seo_description_7,
  t0.seo_canonical AS seo_canonical_8,
  t0.seo_indexed AS seo_indexed_9
FROM
  cms_page t0
WHERE
  t0.enable = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.enable AS enable_4, t0.updated_at AS updated_at_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_canonical AS seo_canonical_8, t0.seo_indexed AS seo_indexed_9 FROM cms_page t0 WHERE t0.enable = 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.address AS address_3,
  t0.zip_code AS zip_code_4,
  t0.city AS city_5,
  t0.image_name AS image_name_6,
  t0.updated_at AS updated_at_7,
  t0.phone_number AS phone_number_8,
  t0.information AS information_9,
  t0.amenities AS amenities_10,
  t0.google_map_link AS google_map_link_11
FROM
  place t0
ORDER BY
  t0.city ASC

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.address AS address_3, t0.zip_code AS zip_code_4, t0.city AS city_5, t0.image_name AS image_name_6, t0.updated_at AS updated_at_7, t0.phone_number AS phone_number_8, t0.information AS information_9, t0.amenities AS amenities_10, t0.google_map_link AS google_map_link_11 FROM place t0 ORDER BY t0.city ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image_name AS image_name_3,
  t0.updated_at AS updated_at_4,
  t0.total_trainings AS total_trainings_5
FROM
  training_category t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.image_name AS image_name_3, t0.updated_at AS updated_at_4, t0.total_trainings AS total_trainings_5 FROM training_category t0 ORDER BY t0.name ASC;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          t0_.id AS id_0,
          t0_.firstname AS firstname_1,
          t0_.lastname AS lastname_2,
          t0_.slug AS slug_3,
          t0_.description AS description_4,
          t0_.certifications AS certifications_5,
          t0_.status AS status_6,
          t0_.image_name AS image_name_7,
          t0_.updated_at AS updated_at_8,
          t0_.available AS available_9,
          t0_.nda_status AS nda_status_10,
          t0_.joined_at AS joined_at_11,
          t0_.is_senza_trainer AS is_senza_trainer_12,
          t0_.data_gouv_link AS data_gouv_link_13,
          t0_.level AS level_14,
          t0_.languages AS languages_15,
          t0_.total_trainings AS total_trainings_16,
          t0_.quality_chart_signed AS quality_chart_signed_17,
          t0_.senza_training_validated AS senza_training_validated_18,
          t0_.siret AS siret_19,
          t0_.nda_number AS nda_number_20,
          t0_.email_hash AS email_hash_21
        FROM
          trainer t0_
        WHERE
          t0_.status = ?
        ORDER BY
          t0_.updated_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT t0_.id AS id_0, t0_.firstname AS firstname_1, t0_.lastname AS lastname_2, t0_.slug AS slug_3, t0_.description AS description_4, t0_.certifications AS certifications_5, t0_.status AS status_6, t0_.image_name AS image_name_7, t0_.updated_at AS updated_at_8, t0_.available AS available_9, t0_.nda_status AS nda_status_10, t0_.joined_at AS joined_at_11, t0_.is_senza_trainer AS is_senza_trainer_12, t0_.data_gouv_link AS data_gouv_link_13, t0_.level AS level_14, t0_.languages AS languages_15, t0_.total_trainings AS total_trainings_16, t0_.quality_chart_signed AS quality_chart_signed_17, t0_.senza_training_validated AS senza_training_validated_18, t0_.siret AS siret_19, t0_.nda_number AS nda_number_20, t0_.email_hash AS email_hash_21 FROM trainer t0_ WHERE t0_.status = 'ENABLED' ORDER BY t0_.updated_at DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      updated_at_8
    FROM
      (
        SELECT
          t0_.id AS id_0,
          t0_.firstname AS firstname_1,
          t0_.lastname AS lastname_2,
          t0_.slug AS slug_3,
          t0_.description AS description_4,
          t0_.certifications AS certifications_5,
          t0_.status AS status_6,
          t0_.image_name AS image_name_7,
          t0_.updated_at AS updated_at_8,
          t0_.available AS available_9,
          t0_.nda_status AS nda_status_10,
          t0_.joined_at AS joined_at_11,
          t0_.is_senza_trainer AS is_senza_trainer_12,
          t0_.data_gouv_link AS data_gouv_link_13,
          t0_.level AS level_14,
          t0_.languages AS languages_15,
          t0_.total_trainings AS total_trainings_16,
          t0_.quality_chart_signed AS quality_chart_signed_17,
          t0_.senza_training_validated AS senza_training_validated_18,
          t0_.siret AS siret_19,
          t0_.nda_number AS nda_number_20,
          t0_.email_hash AS email_hash_21
        FROM
          trainer t0_
        WHERE
          t0_.status = ?
      ) dctrn_result_inner
    ORDER BY
      updated_at_8 DESC
  ) dctrn_result
LIMIT
  7

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, updated_at_8 FROM (SELECT t0_.id AS id_0, t0_.firstname AS firstname_1, t0_.lastname AS lastname_2, t0_.slug AS slug_3, t0_.description AS description_4, t0_.certifications AS certifications_5, t0_.status AS status_6, t0_.image_name AS image_name_7, t0_.updated_at AS updated_at_8, t0_.available AS available_9, t0_.nda_status AS nda_status_10, t0_.joined_at AS joined_at_11, t0_.is_senza_trainer AS is_senza_trainer_12, t0_.data_gouv_link AS data_gouv_link_13, t0_.level AS level_14, t0_.languages AS languages_15, t0_.total_trainings AS total_trainings_16, t0_.quality_chart_signed AS quality_chart_signed_17, t0_.senza_training_validated AS senza_training_validated_18, t0_.siret AS siret_19, t0_.nda_number AS nda_number_20, t0_.email_hash AS email_hash_21 FROM trainer t0_ WHERE t0_.status = 'ENABLED') dctrn_result_inner ORDER BY updated_at_8 DESC) dctrn_result LIMIT 7;

SELECT
  t0_.id AS id_0,
  t0_.firstname AS firstname_1,
  t0_.lastname AS lastname_2,
  t0_.slug AS slug_3,
  t0_.description AS description_4,
  t0_.certifications AS certifications_5,
  t0_.status AS status_6,
  t0_.image_name AS image_name_7,
  t0_.updated_at AS updated_at_8,
  t0_.available AS available_9,
  t0_.nda_status AS nda_status_10,
  t0_.joined_at AS joined_at_11,
  t0_.is_senza_trainer AS is_senza_trainer_12,
  t0_.data_gouv_link AS data_gouv_link_13,
  t0_.level AS level_14,
  t0_.languages AS languages_15,
  t0_.total_trainings AS total_trainings_16,
  t0_.quality_chart_signed AS quality_chart_signed_17,
  t0_.senza_training_validated AS senza_training_validated_18,
  t0_.siret AS siret_19,
  t0_.nda_number AS nda_number_20,
  t0_.email_hash AS email_hash_21,
  t0_.user_id AS user_id_22
FROM
  trainer t0_
WHERE
  t0_.status = ?
  AND t0_.id IN (?, ?)
ORDER BY
  t0_.updated_at DESC

SELECT t0_.id AS id_0, t0_.firstname AS firstname_1, t0_.lastname AS lastname_2, t0_.slug AS slug_3, t0_.description AS description_4, t0_.certifications AS certifications_5, t0_.status AS status_6, t0_.image_name AS image_name_7, t0_.updated_at AS updated_at_8, t0_.available AS available_9, t0_.nda_status AS nda_status_10, t0_.joined_at AS joined_at_11, t0_.is_senza_trainer AS is_senza_trainer_12, t0_.data_gouv_link AS data_gouv_link_13, t0_.level AS level_14, t0_.languages AS languages_15, t0_.total_trainings AS total_trainings_16, t0_.quality_chart_signed AS quality_chart_signed_17, t0_.senza_training_validated AS senza_training_validated_18, t0_.siret AS siret_19, t0_.nda_number AS nda_number_20, t0_.email_hash AS email_hash_21, t0_.user_id AS user_id_22 FROM trainer t0_ WHERE t0_.status = 'ENABLED' AND t0_.id IN (14, 13) ORDER BY t0_.updated_at DESC;

SELECT
  COUNT(*)
FROM
  trainer_review t0
WHERE
  t0.trainer_id = ?

SELECT COUNT(*) FROM trainer_review t0 WHERE t0.trainer_id = 14;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image_name AS image_name_3,
  t0.updated_at AS updated_at_4,
  t0.total_trainings AS total_trainings_5
FROM
  training_category t0
  INNER JOIN trainer_training_category ON t0.id = trainer_training_category.training_category_id
WHERE
  trainer_training_category.trainer_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.image_name AS image_name_3, t0.updated_at AS updated_at_4, t0.total_trainings AS total_trainings_5 FROM training_category t0 INNER JOIN trainer_training_category ON t0.id = trainer_training_category.training_category_id WHERE trainer_training_category.trainer_id = 14;

SELECT
  COUNT(*)
FROM
  trainer_review t0
WHERE
  t0.trainer_id = ?

SELECT COUNT(*) FROM trainer_review t0 WHERE t0.trainer_id = 13;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image_name AS image_name_3,
  t0.updated_at AS updated_at_4,
  t0.total_trainings AS total_trainings_5
FROM
  training_category t0
  INNER JOIN trainer_training_category ON t0.id = trainer_training_category.training_category_id
WHERE
  trainer_training_category.trainer_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.image_name AS image_name_3, t0.updated_at AS updated_at_4, t0.total_trainings AS total_trainings_5 FROM training_category t0 INNER JOIN trainer_training_category ON t0.id = trainer_training_category.training_category_id WHERE trainer_training_category.trainer_id = 13;