Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.short_description AS short_description_3,
  p0_.description AS description_4,
  p0_.price AS price_5,
  p0_.special_price AS special_price_6,
  p0_.max_discount AS max_discount_7,
  p0_.sku AS sku_8,
  p0_.featured_image AS featured_image_9,
  p0_.image_gallery AS image_gallery_10,
  p0_.tabs AS tabs_11,
  p0_.seo_meta AS seo_meta_12,
  p0_.is_publish AS is_publish_13,
  p0_.is_archived AS is_archived_14,
  p0_.is_featured AS is_featured_15,
  p0_.is_homepage_slider AS is_homepage_slider_16,
  p0_.show_in_category AS show_in_category_17,
  p0_.is_highlighted AS is_highlighted_18,
  p0_.is_b2_c AS is_b2_c_19,
  p0_.created_at AS created_at_20,
  p0_.updated_at AS updated_at_21,
  p0_.documents AS documents_22,
  p0_.related_products AS related_products_23,
  p0_.stock_quantity AS stock_quantity_24,
  p0_.category_id AS category_id_25,
  p0_.brand_id AS brand_id_26
FROM
  product p0_
WHERE
  p0_.name LIKE CONCAT('%', ?, '%')
  AND p0_.is_publish = ?
ORDER BY
  p0_.id ASC
LIMIT
  100

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.short_description AS short_description_3, p0_.description AS description_4, p0_.price AS price_5, p0_.special_price AS special_price_6, p0_.max_discount AS max_discount_7, p0_.sku AS sku_8, p0_.featured_image AS featured_image_9, p0_.image_gallery AS image_gallery_10, p0_.tabs AS tabs_11, p0_.seo_meta AS seo_meta_12, p0_.is_publish AS is_publish_13, p0_.is_archived AS is_archived_14, p0_.is_featured AS is_featured_15, p0_.is_homepage_slider AS is_homepage_slider_16, p0_.show_in_category AS show_in_category_17, p0_.is_highlighted AS is_highlighted_18, p0_.is_b2_c AS is_b2_c_19, p0_.created_at AS created_at_20, p0_.updated_at AS updated_at_21, p0_.documents AS documents_22, p0_.related_products AS related_products_23, p0_.stock_quantity AS stock_quantity_24, p0_.category_id AS category_id_25, p0_.brand_id AS brand_id_26 FROM product p0_ WHERE p0_.name LIKE CONCAT('%', '4104', '%') AND p0_.is_publish = 1 ORDER BY p0_.id ASC LIMIT 100;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.subtitle AS subtitle_4,
  t0.description AS description_5,
  t0.position AS position_6,
  t0.lft AS lft_7,
  t0.lvl AS lvl_8,
  t0.rgt AS rgt_9,
  t0.is_publish AS is_publish_10,
  t0.is_archived AS is_archived_11,
  t0.tree_root AS tree_root_12,
  t0.parent_id AS parent_id_13
FROM
  product_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.description AS description_5, t0.position AS position_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.is_publish AS is_publish_10, t0.is_archived AS is_archived_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13 FROM product_category t0 WHERE t0.id = '976c3062-bfeb-4751-a477-ae0f99866f12';

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.subtitle AS subtitle_4,
  t0.description AS description_5,
  t0.position AS position_6,
  t0.lft AS lft_7,
  t0.lvl AS lvl_8,
  t0.rgt AS rgt_9,
  t0.is_publish AS is_publish_10,
  t0.is_archived AS is_archived_11,
  t0.tree_root AS tree_root_12,
  t0.parent_id AS parent_id_13
FROM
  product_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.description AS description_5, t0.position AS position_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.is_publish AS is_publish_10, t0.is_archived AS is_archived_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13 FROM product_category t0 WHERE t0.id = '8127323e-58f7-4a21-9a7f-da63120338c8';

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.subtitle AS subtitle_4,
  t0.description AS description_5,
  t0.position AS position_6,
  t0.lft AS lft_7,
  t0.lvl AS lvl_8,
  t0.rgt AS rgt_9,
  t0.is_publish AS is_publish_10,
  t0.is_archived AS is_archived_11,
  t0.tree_root AS tree_root_12,
  t0.parent_id AS parent_id_13
FROM
  product_category t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.lft ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.description AS description_5, t0.position AS position_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.is_publish AS is_publish_10, t0.is_archived AS is_archived_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13 FROM product_category t0 WHERE t0.parent_id = '8127323e-58f7-4a21-9a7f-da63120338c8' ORDER BY t0.lft ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.subtitle AS subtitle_4,
  t0.description AS description_5,
  t0.position AS position_6,
  t0.lft AS lft_7,
  t0.lvl AS lvl_8,
  t0.rgt AS rgt_9,
  t0.is_publish AS is_publish_10,
  t0.is_archived AS is_archived_11,
  t0.tree_root AS tree_root_12,
  t0.parent_id AS parent_id_13
FROM
  product_category t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.lft ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.description AS description_5, t0.position AS position_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.is_publish AS is_publish_10, t0.is_archived AS is_archived_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13 FROM product_category t0 WHERE t0.parent_id = '413d26b0-a381-46a9-8daf-6916c425e137' ORDER BY t0.lft ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.subtitle AS subtitle_4,
  t0.description AS description_5,
  t0.position AS position_6,
  t0.lft AS lft_7,
  t0.lvl AS lvl_8,
  t0.rgt AS rgt_9,
  t0.is_publish AS is_publish_10,
  t0.is_archived AS is_archived_11,
  t0.tree_root AS tree_root_12,
  t0.parent_id AS parent_id_13
FROM
  product_category t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.lft ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.description AS description_5, t0.position AS position_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.is_publish AS is_publish_10, t0.is_archived AS is_archived_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13 FROM product_category t0 WHERE t0.parent_id = '4b595f3d-10e1-4ad0-b7d3-24bdebbf429d' ORDER BY t0.lft ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.subtitle AS subtitle_4,
  t0.description AS description_5,
  t0.position AS position_6,
  t0.lft AS lft_7,
  t0.lvl AS lvl_8,
  t0.rgt AS rgt_9,
  t0.is_publish AS is_publish_10,
  t0.is_archived AS is_archived_11,
  t0.tree_root AS tree_root_12,
  t0.parent_id AS parent_id_13
FROM
  product_category t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.lft ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.description AS description_5, t0.position AS position_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.is_publish AS is_publish_10, t0.is_archived AS is_archived_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13 FROM product_category t0 WHERE t0.parent_id = '7d289d82-b8a0-41b6-991c-069502b80ebe' ORDER BY t0.lft ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.subtitle AS subtitle_4,
  t0.description AS description_5,
  t0.position AS position_6,
  t0.lft AS lft_7,
  t0.lvl AS lvl_8,
  t0.rgt AS rgt_9,
  t0.is_publish AS is_publish_10,
  t0.is_archived AS is_archived_11,
  t0.tree_root AS tree_root_12,
  t0.parent_id AS parent_id_13
FROM
  product_category t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.lft ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.description AS description_5, t0.position AS position_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.is_publish AS is_publish_10, t0.is_archived AS is_archived_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13 FROM product_category t0 WHERE t0.parent_id = '01a5b01f-423b-499a-9e04-64be124df642' ORDER BY t0.lft ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.subtitle AS subtitle_4,
  t0.description AS description_5,
  t0.position AS position_6,
  t0.lft AS lft_7,
  t0.lvl AS lvl_8,
  t0.rgt AS rgt_9,
  t0.is_publish AS is_publish_10,
  t0.is_archived AS is_archived_11,
  t0.tree_root AS tree_root_12,
  t0.parent_id AS parent_id_13
FROM
  product_category t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.lft ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.description AS description_5, t0.position AS position_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.is_publish AS is_publish_10, t0.is_archived AS is_archived_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13 FROM product_category t0 WHERE t0.parent_id = '1478c592-e492-473b-8252-341bca99d0fa' ORDER BY t0.lft ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.subtitle AS subtitle_4,
  t0.description AS description_5,
  t0.position AS position_6,
  t0.lft AS lft_7,
  t0.lvl AS lvl_8,
  t0.rgt AS rgt_9,
  t0.is_publish AS is_publish_10,
  t0.is_archived AS is_archived_11,
  t0.tree_root AS tree_root_12,
  t0.parent_id AS parent_id_13
FROM
  product_category t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.lft ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.description AS description_5, t0.position AS position_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.is_publish AS is_publish_10, t0.is_archived AS is_archived_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13 FROM product_category t0 WHERE t0.parent_id = '89549a61-99ef-4283-84a1-9c3f4958a348' ORDER BY t0.lft ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.subtitle AS subtitle_4,
  t0.description AS description_5,
  t0.position AS position_6,
  t0.lft AS lft_7,
  t0.lvl AS lvl_8,
  t0.rgt AS rgt_9,
  t0.is_publish AS is_publish_10,
  t0.is_archived AS is_archived_11,
  t0.tree_root AS tree_root_12,
  t0.parent_id AS parent_id_13
FROM
  product_category t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.lft ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.description AS description_5, t0.position AS position_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.is_publish AS is_publish_10, t0.is_archived AS is_archived_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13 FROM product_category t0 WHERE t0.parent_id = '53352697-db09-480a-a330-a7890c4dee34' ORDER BY t0.lft ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.subtitle AS subtitle_4,
  t0.description AS description_5,
  t0.position AS position_6,
  t0.lft AS lft_7,
  t0.lvl AS lvl_8,
  t0.rgt AS rgt_9,
  t0.is_publish AS is_publish_10,
  t0.is_archived AS is_archived_11,
  t0.tree_root AS tree_root_12,
  t0.parent_id AS parent_id_13
FROM
  product_category t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.lft ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.description AS description_5, t0.position AS position_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.is_publish AS is_publish_10, t0.is_archived AS is_archived_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13 FROM product_category t0 WHERE t0.parent_id = '41503e4f-70e1-4177-935d-6c60c496622b' ORDER BY t0.lft ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.subtitle AS subtitle_4,
  t0.description AS description_5,
  t0.position AS position_6,
  t0.lft AS lft_7,
  t0.lvl AS lvl_8,
  t0.rgt AS rgt_9,
  t0.is_publish AS is_publish_10,
  t0.is_archived AS is_archived_11,
  t0.tree_root AS tree_root_12,
  t0.parent_id AS parent_id_13
FROM
  product_category t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.lft ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.description AS description_5, t0.position AS position_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.is_publish AS is_publish_10, t0.is_archived AS is_archived_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13 FROM product_category t0 WHERE t0.parent_id = '91ca862d-08ee-4fe9-b49b-b54fe6d7aefe' ORDER BY t0.lft ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.subtitle AS subtitle_4,
  t0.description AS description_5,
  t0.position AS position_6,
  t0.lft AS lft_7,
  t0.lvl AS lvl_8,
  t0.rgt AS rgt_9,
  t0.is_publish AS is_publish_10,
  t0.is_archived AS is_archived_11,
  t0.tree_root AS tree_root_12,
  t0.parent_id AS parent_id_13
FROM
  product_category t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.lft ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.description AS description_5, t0.position AS position_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.is_publish AS is_publish_10, t0.is_archived AS is_archived_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13 FROM product_category t0 WHERE t0.parent_id = '6b45ebc3-bed1-4501-aba1-0c2aef976c98' ORDER BY t0.lft ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.subtitle AS subtitle_4,
  t0.description AS description_5,
  t0.position AS position_6,
  t0.lft AS lft_7,
  t0.lvl AS lvl_8,
  t0.rgt AS rgt_9,
  t0.is_publish AS is_publish_10,
  t0.is_archived AS is_archived_11,
  t0.tree_root AS tree_root_12,
  t0.parent_id AS parent_id_13
FROM
  product_category t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.lft ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.description AS description_5, t0.position AS position_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.is_publish AS is_publish_10, t0.is_archived AS is_archived_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13 FROM product_category t0 WHERE t0.parent_id = 'a24082a7-04c6-4b47-bc0a-9a2ee046e9a5' ORDER BY t0.lft ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.subtitle AS subtitle_4,
  t0.description AS description_5,
  t0.position AS position_6,
  t0.lft AS lft_7,
  t0.lvl AS lvl_8,
  t0.rgt AS rgt_9,
  t0.is_publish AS is_publish_10,
  t0.is_archived AS is_archived_11,
  t0.tree_root AS tree_root_12,
  t0.parent_id AS parent_id_13
FROM
  product_category t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.lft ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.description AS description_5, t0.position AS position_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.is_publish AS is_publish_10, t0.is_archived AS is_archived_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13 FROM product_category t0 WHERE t0.parent_id = '9e9a1da9-0f05-49dc-b15e-d153d5b23318' ORDER BY t0.lft ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.subtitle AS subtitle_4,
  t0.description AS description_5,
  t0.position AS position_6,
  t0.lft AS lft_7,
  t0.lvl AS lvl_8,
  t0.rgt AS rgt_9,
  t0.is_publish AS is_publish_10,
  t0.is_archived AS is_archived_11,
  t0.tree_root AS tree_root_12,
  t0.parent_id AS parent_id_13
FROM
  product_category t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.lft ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.description AS description_5, t0.position AS position_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.is_publish AS is_publish_10, t0.is_archived AS is_archived_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13 FROM product_category t0 WHERE t0.parent_id = '976c3062-bfeb-4751-a477-ae0f99866f12' ORDER BY t0.lft ASC;