Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.intro AS intro_3,
  t0.product_name AS product_name_4,
  t0.product_size AS product_size_5,
  t0.product_file_updated_at AS product_file_updated_at_6,
  t0.display AS display_7,
  t0.meta_title AS meta_title_8,
  t0.meta_description AS meta_description_9,
  t0.position AS position_10,
  t0.slug AS slug_11,
  t0.category_id AS category_id_12
FROM
  product t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.intro AS intro_3, t0.product_name AS product_name_4, t0.product_size AS product_size_5, t0.product_file_updated_at AS product_file_updated_at_6, t0.display AS display_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.position AS position_10, t0.slug AS slug_11, t0.category_id AS category_id_12 FROM product t0 WHERE t0.category_id = 7;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.sub_title AS sub_title_3,
  t0.intro AS intro_4,
  t0.sub_title_detail AS sub_title_detail_5,
  t0.description AS description_6,
  t0.category_name AS category_name_7,
  t0.category_size AS category_size_8,
  t0.category_file_updated_at AS category_file_updated_at_9,
  t0.meta_title AS meta_title_10,
  t0.meta_description AS meta_description_11,
  t0.position AS position_12,
  t0.slug AS slug_13
FROM
  category t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.sub_title AS sub_title_3, t0.intro AS intro_4, t0.sub_title_detail AS sub_title_detail_5, t0.description AS description_6, t0.category_name AS category_name_7, t0.category_size AS category_size_8, t0.category_file_updated_at AS category_file_updated_at_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11, t0.position AS position_12, t0.slug AS slug_13 FROM category t0;

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.description AS description_2,
  a0_.achievement_name AS achievement_name_3,
  a0_.achievement_size AS achievement_size_4,
  a0_.achievement_file_updated_at AS achievement_file_updated_at_5,
  a0_.updated_at AS updated_at_6,
  a0_.meta_title AS meta_title_7,
  a0_.meta_description AS meta_description_8,
  a0_.position AS position_9,
  a0_.slug AS slug_10,
  a0_.product_id AS product_id_11
FROM
  achievement a0_
WHERE
  a0_.id IN (?)
ORDER BY
  a0_.position ASC,
  a0_.updated_at DESC

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.achievement_name AS achievement_name_3, a0_.achievement_size AS achievement_size_4, a0_.achievement_file_updated_at AS achievement_file_updated_at_5, a0_.updated_at AS updated_at_6, a0_.meta_title AS meta_title_7, a0_.meta_description AS meta_description_8, a0_.position AS position_9, a0_.slug AS slug_10, a0_.product_id AS product_id_11 FROM achievement a0_ WHERE a0_.id IN (53, 54, 55, 56, 58, 60, 61, 63, 64, 68, 69, 70, 72) ORDER BY a0_.position ASC, a0_.updated_at DESC;

SELECT
  t0.route AS route_1,
  t0.id AS id_2,
  t0.page_name AS page_name_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.h1_enabled AS h1_enabled_6,
  t0.h1 AS h1_7
FROM
  seopage t0
WHERE
  t0.route = ?
LIMIT
  1

SELECT t0.route AS route_1, t0.id AS id_2, t0.page_name AS page_name_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.h1_enabled AS h1_enabled_6, t0.h1 AS h1_7 FROM seopage t0 WHERE t0.route = 'app_achievement_list' LIMIT 1;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      position_9,
      updated_at_6
    FROM
      (
        SELECT
          a0_.id AS id_0,
          a0_.title AS title_1,
          a0_.description AS description_2,
          a0_.achievement_name AS achievement_name_3,
          a0_.achievement_size AS achievement_size_4,
          a0_.achievement_file_updated_at AS achievement_file_updated_at_5,
          a0_.updated_at AS updated_at_6,
          a0_.meta_title AS meta_title_7,
          a0_.meta_description AS meta_description_8,
          a0_.position AS position_9,
          a0_.slug AS slug_10
        FROM
          achievement a0_
      ) dctrn_result_inner
    ORDER BY
      position_9 ASC,
      updated_at_6 DESC
  ) dctrn_result
LIMIT
  13 OFFSET 39

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, position_9, updated_at_6 FROM (SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.achievement_name AS achievement_name_3, a0_.achievement_size AS achievement_size_4, a0_.achievement_file_updated_at AS achievement_file_updated_at_5, a0_.updated_at AS updated_at_6, a0_.meta_title AS meta_title_7, a0_.meta_description AS meta_description_8, a0_.position AS position_9, a0_.slug AS slug_10 FROM achievement a0_) dctrn_result_inner ORDER BY position_9 ASC, updated_at_6 DESC) dctrn_result LIMIT 13 OFFSET 39;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          a0_.id AS id_0,
          a0_.title AS title_1,
          a0_.description AS description_2,
          a0_.achievement_name AS achievement_name_3,
          a0_.achievement_size AS achievement_size_4,
          a0_.achievement_file_updated_at AS achievement_file_updated_at_5,
          a0_.updated_at AS updated_at_6,
          a0_.meta_title AS meta_title_7,
          a0_.meta_description AS meta_description_8,
          a0_.position AS position_9,
          a0_.slug AS slug_10
        FROM
          achievement a0_
        ORDER BY
          a0_.position ASC,
          a0_.updated_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.achievement_name AS achievement_name_3, a0_.achievement_size AS achievement_size_4, a0_.achievement_file_updated_at AS achievement_file_updated_at_5, a0_.updated_at AS updated_at_6, a0_.meta_title AS meta_title_7, a0_.meta_description AS meta_description_8, a0_.position AS position_9, a0_.slug AS slug_10 FROM achievement a0_ ORDER BY a0_.position ASC, a0_.updated_at DESC) dctrn_result) dctrn_table;

SELECT
  t0.id AS id_1,
  t0.phone AS phone_2,
  t0.email AS email_3,
  t0.address_street AS address_street_4,
  t0.zipcode AS zipcode_5,
  t0.city AS city_6,
  t0.legal_site_name AS legal_site_name_7,
  t0.legal_siret AS legal_siret_8,
  t0.legal_siren AS legal_siren_9,
  t0.legal_rcs AS legal_rcs_10,
  t0.legal_address AS legal_address_11,
  t0.legal_zipcode AS legal_zipcode_12,
  t0.legal_city AS legal_city_13,
  t0.legal_phone AS legal_phone_14,
  t0.legal_email AS legal_email_15,
  t0.legal_publication_owner AS legal_publication_owner_16,
  t0.legal_site_url AS legal_site_url_17,
  t0.default_title AS default_title_18,
  t0.default_meta_desc AS default_meta_desc_19
FROM
  site_settings t0

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.email AS email_3, t0.address_street AS address_street_4, t0.zipcode AS zipcode_5, t0.city AS city_6, t0.legal_site_name AS legal_site_name_7, t0.legal_siret AS legal_siret_8, t0.legal_siren AS legal_siren_9, t0.legal_rcs AS legal_rcs_10, t0.legal_address AS legal_address_11, t0.legal_zipcode AS legal_zipcode_12, t0.legal_city AS legal_city_13, t0.legal_phone AS legal_phone_14, t0.legal_email AS legal_email_15, t0.legal_publication_owner AS legal_publication_owner_16, t0.legal_site_url AS legal_site_url_17, t0.default_title AS default_title_18, t0.default_meta_desc AS default_meta_desc_19 FROM site_settings t0;