Symfony Profiler

SELECT
  p0_.domain AS domain_0,
  p0_.name AS name_1,
  p0_.api_key AS api_key_2,
  p0_.updated_at AS updated_at_3,
  p0_.id AS id_4,
  p0_.deleted_at AS deleted_at_5,
  p0_.legal_id AS legal_id_6,
  p0_.city_id AS city_id_7
FROM
  projects p0_
WHERE
  (p0_.deleted_at IS NULL)

SELECT p0_.domain AS domain_0, p0_.name AS name_1, p0_.api_key AS api_key_2, p0_.updated_at AS updated_at_3, p0_.id AS id_4, p0_.deleted_at AS deleted_at_5, p0_.legal_id AS legal_id_6, p0_.city_id AS city_id_7 FROM projects p0_ WHERE (p0_.deleted_at IS NULL);

SELECT
  DISTINCT id_1,
  MIN(sclr_2) AS dctrn_minrownum
FROM
  (
    SELECT
      p0_.updated_at AS updated_at_0,
      p0_.id AS id_1,
      ROW_NUMBER() OVER(
        ORDER BY
          p0_.project_id ASC
      ) AS sclr_2
    FROM
      project_category_products p0_
  ) dctrn_result
GROUP BY
  id_1
ORDER BY
  dctrn_minrownum ASC
LIMIT
  25

SELECT DISTINCT id_1, MIN(sclr_2) AS dctrn_minrownum FROM (SELECT p0_.updated_at AS updated_at_0, p0_.id AS id_1, ROW_NUMBER() OVER(ORDER BY p0_.project_id ASC) AS sclr_2 FROM project_category_products p0_) dctrn_result GROUP BY id_1 ORDER BY dctrn_minrownum ASC LIMIT 25;

SELECT
  p0_.updated_at AS updated_at_0,
  p0_.id AS id_1,
  p0_.project_id AS project_id_2,
  p0_.product_category_id AS product_category_id_3,
  p0_.product_id AS product_id_4
FROM
  project_category_products p0_
WHERE
  p0_.id IN (?, ?, ?, ?, ?, ?, ?)
ORDER BY
  p0_.project_id ASC

SELECT p0_.updated_at AS updated_at_0, p0_.id AS id_1, p0_.project_id AS project_id_2, p0_.product_category_id AS product_category_id_3, p0_.product_id AS product_id_4 FROM project_category_products p0_ WHERE p0_.id IN ('b4d6306f-d615-40cd-8721-349bcba26501', '73d84181-f937-4d9e-8322-bef078fea425', '2e0e91e5-5056-4da3-92e3-4c93cc9a7bd6', '2bc9c00d-e3e7-41eb-9600-4c1e6fe8ae25', '53f77aa2-1c14-43b5-ae2a-d6f22b2382a0', '0a7d84bf-f1a8-4a75-a6c5-a3c7c3d7c378', 'f7256f48-764c-48c1-9986-3cb482ab2b6f') ORDER BY p0_.project_id ASC;

SELECT
  t0.lft AS lft_1,
  t0.rgt AS rgt_2,
  t0.lvl AS lvl_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.id AS id_6,
  t0.prt AS prt_7,
  t0.project_id AS project_id_8,
  t0.tree_root AS tree_root_9
FROM
  categories_all t0
WHERE
  t0.id = ?

SELECT t0.lft AS lft_1, t0.rgt AS rgt_2, t0.lvl AS lvl_3, t0.name AS name_4, t0.slug AS slug_5, t0.id AS id_6, t0.prt AS prt_7, t0.project_id AS project_id_8, t0.tree_root AS tree_root_9 FROM categories_all t0 WHERE t0.id = '1f0adb7f-5768-6516-bf71-278e933446f6';

SELECT
  t0.name AS name_1,
  t0.updated_at AS updated_at_2,
  t0.id AS id_3,
  t0.deleted_at AS deleted_at_4,
  t0.product_type_id AS product_type_id_5,
  t0.brand_id AS brand_id_6
FROM
  products t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.name AS name_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.product_type_id AS product_type_id_5, t0.brand_id AS brand_id_6 FROM products t0 WHERE t0.id = '1df45d75-bf6a-458a-86bb-aab2d770c9d7' AND ((t0.deleted_at IS NULL));

SELECT
  t0.name AS name_1,
  t0.updated_at AS updated_at_2,
  t0.id AS id_3,
  t0.deleted_at AS deleted_at_4,
  t0.product_type_id AS product_type_id_5,
  t0.brand_id AS brand_id_6
FROM
  products t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.name AS name_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.product_type_id AS product_type_id_5, t0.brand_id AS brand_id_6 FROM products t0 WHERE t0.id = '3576bf0c-7daa-4a0f-8b40-777a44f3ae9d' AND ((t0.deleted_at IS NULL));

SELECT
  t0.name AS name_1,
  t0.updated_at AS updated_at_2,
  t0.id AS id_3,
  t0.deleted_at AS deleted_at_4,
  t0.product_type_id AS product_type_id_5,
  t0.brand_id AS brand_id_6
FROM
  products t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.name AS name_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.product_type_id AS product_type_id_5, t0.brand_id AS brand_id_6 FROM products t0 WHERE t0.id = '37758d8c-f1e3-4349-b3d6-890d9303f44e' AND ((t0.deleted_at IS NULL));

SELECT
  t0.name AS name_1,
  t0.updated_at AS updated_at_2,
  t0.id AS id_3,
  t0.deleted_at AS deleted_at_4,
  t0.product_type_id AS product_type_id_5,
  t0.brand_id AS brand_id_6
FROM
  products t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.name AS name_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.product_type_id AS product_type_id_5, t0.brand_id AS brand_id_6 FROM products t0 WHERE t0.id = '5153e619-86e3-481f-8743-c36a5dfb45c5' AND ((t0.deleted_at IS NULL));

SELECT
  t0.name AS name_1,
  t0.updated_at AS updated_at_2,
  t0.id AS id_3,
  t0.deleted_at AS deleted_at_4,
  t0.product_type_id AS product_type_id_5,
  t0.brand_id AS brand_id_6
FROM
  products t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.name AS name_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.product_type_id AS product_type_id_5, t0.brand_id AS brand_id_6 FROM products t0 WHERE t0.id = '9b75f464-cf66-4042-a94d-cdeda4f92220' AND ((t0.deleted_at IS NULL));

SELECT
  t0.name AS name_1,
  t0.updated_at AS updated_at_2,
  t0.id AS id_3,
  t0.deleted_at AS deleted_at_4,
  t0.product_type_id AS product_type_id_5,
  t0.brand_id AS brand_id_6
FROM
  products t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.name AS name_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.product_type_id AS product_type_id_5, t0.brand_id AS brand_id_6 FROM products t0 WHERE t0.id = 'ddded8b0-1ac9-423b-a78c-a14605b8a26b' AND ((t0.deleted_at IS NULL));

SELECT
  t0.name AS name_1,
  t0.updated_at AS updated_at_2,
  t0.id AS id_3,
  t0.deleted_at AS deleted_at_4,
  t0.product_type_id AS product_type_id_5,
  t0.brand_id AS brand_id_6
FROM
  products t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.name AS name_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.product_type_id AS product_type_id_5, t0.brand_id AS brand_id_6 FROM products t0 WHERE t0.id = 'e4b6d9ba-b559-4fc8-b468-f192817f9b92' AND ((t0.deleted_at IS NULL));

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_1
    FROM
      (
        SELECT
          p0_.updated_at AS updated_at_0,
          p0_.id AS id_1
        FROM
          project_category_products p0_
        ORDER BY
          p0_.project_id ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_1 FROM (SELECT p0_.updated_at AS updated_at_0, p0_.id AS id_1 FROM project_category_products p0_ ORDER BY p0_.project_id ASC) dctrn_result) dctrn_table;