Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.position AS position_4,
  t0.category_id AS category_id_5
FROM
  subcategory t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.category_id AS category_id_5 FROM subcategory t0 WHERE t0.slug = 'poissons-et-fruits-de-mer' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.position AS position_4,
  t0.category_id AS category_id_5
FROM
  subcategory t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.category_id AS category_id_5 FROM subcategory t0 WHERE t0.slug = 'poissons-et-fruits-de-mer' LIMIT 1;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.name AS name_1,
          p0_.extra AS extra_2,
          p0_.slug AS slug_3,
          p0_.description AS description_4,
          p0_.origin AS origin_5,
          p0_.price AS price_6,
          p0_.stock AS stock_7,
          p0_.sku AS sku_8,
          p0_.weight AS weight_9,
          p0_.created_at AS created_at_10,
          p0_.updated_at AS updated_at_11,
          p0_.reference AS reference_12,
          p0_.status AS status_13,
          p0_.is_mts_product AS is_mts_product_14
        FROM
          product p0_
        WHERE
          (
            p0_.status = ?
            OR p0_.status = ?
          )
          AND p0_.subcategory_id IS NOT NULL
          AND p0_.subcategory_id = ?
        ORDER BY
          p0_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.extra AS extra_2, p0_.slug AS slug_3, p0_.description AS description_4, p0_.origin AS origin_5, p0_.price AS price_6, p0_.stock AS stock_7, p0_.sku AS sku_8, p0_.weight AS weight_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.reference AS reference_12, p0_.status AS status_13, p0_.is_mts_product AS is_mts_product_14 FROM product p0_ WHERE (p0_.status = 'active' OR p0_.status = 'out-of-stock') AND p0_.subcategory_id IS NOT NULL AND p0_.subcategory_id = 8 ORDER BY p0_.id DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.name AS name_1,
          p0_.extra AS extra_2,
          p0_.slug AS slug_3,
          p0_.description AS description_4,
          p0_.origin AS origin_5,
          p0_.price AS price_6,
          p0_.stock AS stock_7,
          p0_.sku AS sku_8,
          p0_.weight AS weight_9,
          p0_.created_at AS created_at_10,
          p0_.updated_at AS updated_at_11,
          p0_.reference AS reference_12,
          p0_.status AS status_13,
          p0_.is_mts_product AS is_mts_product_14
        FROM
          product p0_
        WHERE
          (
            p0_.status = ?
            OR p0_.status = ?
          )
          AND p0_.subcategory_id IS NOT NULL
          AND p0_.subcategory_id = ?
      ) dctrn_result_inner
    ORDER BY
      id_0 DESC
  ) dctrn_result
LIMIT
  36

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.extra AS extra_2, p0_.slug AS slug_3, p0_.description AS description_4, p0_.origin AS origin_5, p0_.price AS price_6, p0_.stock AS stock_7, p0_.sku AS sku_8, p0_.weight AS weight_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.reference AS reference_12, p0_.status AS status_13, p0_.is_mts_product AS is_mts_product_14 FROM product p0_ WHERE (p0_.status = 'active' OR p0_.status = 'out-of-stock') AND p0_.subcategory_id IS NOT NULL AND p0_.subcategory_id = 8) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 36;

SELECT
  t0.id AS id_1,
  t0.setting_key AS setting_key_2,
  t0.setting_value AS setting_value_3
FROM
  site_setting t0
WHERE
  t0.setting_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = 'address_ofici' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.setting_key AS setting_key_2,
  t0.setting_value AS setting_value_3
FROM
  site_setting t0
WHERE
  t0.setting_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = 'contact_email' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.setting_key AS setting_key_2,
  t0.setting_value AS setting_value_3
FROM
  site_setting t0
WHERE
  t0.setting_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = 'contact_phone' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.setting_key AS setting_key_2,
  t0.setting_value AS setting_value_3
FROM
  site_setting t0
WHERE
  t0.setting_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = 'facebook_link' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.setting_key AS setting_key_2,
  t0.setting_value AS setting_value_3
FROM
  site_setting t0
WHERE
  t0.setting_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = 'instagram_link' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.setting_key AS setting_key_2,
  t0.setting_value AS setting_value_3
FROM
  site_setting t0
WHERE
  t0.setting_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = 'linkedin_link' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.setting_key AS setting_key_2,
  t0.setting_value AS setting_value_3
FROM
  site_setting t0
WHERE
  t0.setting_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = 'x_link' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.setting_key AS setting_key_2,
  t0.setting_value AS setting_value_3
FROM
  site_setting t0
WHERE
  t0.setting_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = 'tiktok_link' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.setting_key AS setting_key_2,
  t0.setting_value AS setting_value_3
FROM
  site_setting t0
WHERE
  t0.setting_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = 'youtube_link' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.position AS position_4,
  t0.is_active AS is_active_5,
  t0.image AS image_6
FROM
  category t0
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.is_active AS is_active_5, t0.image AS image_6 FROM category t0 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.position AS position_4,
  t0.category_id AS category_id_5
FROM
  subcategory t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.category_id AS category_id_5 FROM subcategory t0 WHERE t0.category_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.position AS position_4,
  t0.category_id AS category_id_5
FROM
  subcategory t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.category_id AS category_id_5 FROM subcategory t0 WHERE t0.category_id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.position AS position_4,
  t0.category_id AS category_id_5
FROM
  subcategory t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.category_id AS category_id_5 FROM subcategory t0 WHERE t0.category_id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.position AS position_4,
  t0.category_id AS category_id_5
FROM
  subcategory t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.category_id AS category_id_5 FROM subcategory t0 WHERE t0.category_id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.position AS position_4,
  t0.category_id AS category_id_5
FROM
  subcategory t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.category_id AS category_id_5 FROM subcategory t0 WHERE t0.category_id = 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.position AS position_4,
  t0.category_id AS category_id_5
FROM
  subcategory t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.category_id AS category_id_5 FROM subcategory t0 WHERE t0.category_id = 6;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.position AS position_4,
  t0.category_id AS category_id_5
FROM
  subcategory t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.category_id AS category_id_5 FROM subcategory t0 WHERE t0.category_id = 7;