Symfony Profiler

SELECT
  count(DISTINCT i0_.id) AS sclr_0
FROM
  item i0_
  INNER JOIN item_category i2_ ON i0_.id = i2_.item_id
  INNER JOIN category c1_ ON c1_.id = i2_.category_id
  LEFT JOIN item_media i3_ ON i0_.id = i3_.item_id
  AND (i3_.type = ?)
  INNER JOIN item_category i5_ ON i0_.id = i5_.item_id
  INNER JOIN category c4_ ON c4_.id = i5_.category_id
  INNER JOIN category c6_ ON c4_.parent_id = c6_.id
  INNER JOIN category c7_ ON c6_.parent_id = c7_.id
  INNER JOIN category c8_ ON c7_.parent_id = c8_.id
WHERE
  (
    i0_.status <> ?
    AND i0_.status <> ?
  )
  AND c8_.visible = ?
  AND (
    c8_.id = ?
    OR c7_.id = ?
    OR c6_.id = ?
    OR c4_.id = ?
  )
  AND (
    i0_.name_brand_fa LIKE ?
    OR i0_.producer LIKE ?
  )

SELECT count(DISTINCT i0_.id) AS sclr_0 FROM item i0_ INNER JOIN item_category i2_ ON i0_.id = i2_.item_id INNER JOIN category c1_ ON c1_.id = i2_.category_id LEFT JOIN item_media i3_ ON i0_.id = i3_.item_id AND (i3_.type = 1) INNER JOIN item_category i5_ ON i0_.id = i5_.item_id INNER JOIN category c4_ ON c4_.id = i5_.category_id INNER JOIN category c6_ ON c4_.parent_id = c6_.id INNER JOIN category c7_ ON c6_.parent_id = c7_.id INNER JOIN category c8_ ON c7_.parent_id = c8_.id WHERE (i0_.status <> 0 AND i0_.status <> 3) AND c8_.visible = 1 AND (c8_.id = 3885 OR c7_.id = 3885 OR c6_.id = 3885 OR c4_.id = 3885) AND (i0_.name_brand_fa LIKE '%%' OR i0_.producer LIKE '%%');

SELECT
  DISTINCT i0_.id AS id_0
FROM
  item i0_
  INNER JOIN item_category i2_ ON i0_.id = i2_.item_id
  INNER JOIN category c1_ ON c1_.id = i2_.category_id
  LEFT JOIN item_media i3_ ON i0_.id = i3_.item_id
  AND (i3_.type = ?)
  INNER JOIN item_category i5_ ON i0_.id = i5_.item_id
  INNER JOIN category c4_ ON c4_.id = i5_.category_id
  INNER JOIN category c6_ ON c4_.parent_id = c6_.id
  INNER JOIN category c7_ ON c6_.parent_id = c7_.id
  INNER JOIN category c8_ ON c7_.parent_id = c8_.id
WHERE
  (
    i0_.status <> ?
    AND i0_.status <> ?
  )
  AND c8_.visible = ?
  AND (
    c8_.id = ?
    OR c7_.id = ?
    OR c6_.id = ?
    OR c4_.id = ?
  )
  AND (
    i0_.name_brand_fa LIKE ?
    OR i0_.producer LIKE ?
  )
LIMIT
  20

SELECT DISTINCT i0_.id AS id_0 FROM item i0_ INNER JOIN item_category i2_ ON i0_.id = i2_.item_id INNER JOIN category c1_ ON c1_.id = i2_.category_id LEFT JOIN item_media i3_ ON i0_.id = i3_.item_id AND (i3_.type = 1) INNER JOIN item_category i5_ ON i0_.id = i5_.item_id INNER JOIN category c4_ ON c4_.id = i5_.category_id INNER JOIN category c6_ ON c4_.parent_id = c6_.id INNER JOIN category c7_ ON c6_.parent_id = c7_.id INNER JOIN category c8_ ON c7_.parent_id = c8_.id WHERE (i0_.status <> 0 AND i0_.status <> 3) AND c8_.visible = 1 AND (c8_.id = 3885 OR c7_.id = 3885 OR c6_.id = 3885 OR c4_.id = 3885) AND (i0_.name_brand_fa LIKE '%%' OR i0_.producer LIKE '%%') LIMIT 20;

SELECT
  t0.id AS id_1,
  t0.about_us AS about_us_2,
  t0.contact_us AS contact_us_3,
  t0.introduce AS introduce_4,
  t0.privacy_policy_ext AS privacy_policy_ext_5,
  t0.terms_and_conditions_ext AS terms_and_conditions_ext_6,
  t0.website_title AS website_title_7,
  t0.meta_description AS meta_description_8,
  t0.footer_description AS footer_description_9,
  t0.logo_ext AS logo_ext_10,
  t0.fav_icon_ext AS fav_icon_ext_11,
  t0.top_banner_ext AS top_banner_ext_12,
  t0.top_banner_link AS top_banner_link_13,
  t0.updated_at AS updated_at_14,
  t0.footer_column1_title AS footer_column1_title_15,
  t0.footer_column2_title AS footer_column2_title_16,
  t0.footer_column3_title AS footer_column3_title_17,
  t0.footer_column4_title AS footer_column4_title_18,
  t0.buy_without_login AS buy_without_login_19,
  t0.footer_social_instagram AS footer_social_instagram_20,
  t0.footer_social_whatsapp AS footer_social_whatsapp_21,
  t0.footer_social_telegram AS footer_social_telegram_22,
  t0.footer_social_twitter AS footer_social_twitter_23,
  t0.footer_script AS footer_script_24
FROM
  setting t0
LIMIT
  1

SELECT t0.id AS id_1, t0.about_us AS about_us_2, t0.contact_us AS contact_us_3, t0.introduce AS introduce_4, t0.privacy_policy_ext AS privacy_policy_ext_5, t0.terms_and_conditions_ext AS terms_and_conditions_ext_6, t0.website_title AS website_title_7, t0.meta_description AS meta_description_8, t0.footer_description AS footer_description_9, t0.logo_ext AS logo_ext_10, t0.fav_icon_ext AS fav_icon_ext_11, t0.top_banner_ext AS top_banner_ext_12, t0.top_banner_link AS top_banner_link_13, t0.updated_at AS updated_at_14, t0.footer_column1_title AS footer_column1_title_15, t0.footer_column2_title AS footer_column2_title_16, t0.footer_column3_title AS footer_column3_title_17, t0.footer_column4_title AS footer_column4_title_18, t0.buy_without_login AS buy_without_login_19, t0.footer_social_instagram AS footer_social_instagram_20, t0.footer_social_whatsapp AS footer_social_whatsapp_21, t0.footer_social_telegram AS footer_social_telegram_22, t0.footer_social_twitter AS footer_social_twitter_23, t0.footer_script AS footer_script_24 FROM setting t0 LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.code AS code_2,
  c0_.level AS level_3,
  c0_.pic_ext AS pic_ext_4,
  c0_.features AS features_5,
  c0_.raychat_code AS raychat_code_6,
  c0_.visible AS visible_7,
  c0_.updated_at AS updated_at_8,
  c1_.id AS id_9,
  c1_.name AS name_10,
  c1_.code AS code_11,
  c1_.level AS level_12,
  c1_.pic_ext AS pic_ext_13,
  c1_.features AS features_14,
  c1_.raychat_code AS raychat_code_15,
  c1_.visible AS visible_16,
  c1_.updated_at AS updated_at_17,
  c2_.id AS id_18,
  c2_.name AS name_19,
  c2_.code AS code_20,
  c2_.level AS level_21,
  c2_.pic_ext AS pic_ext_22,
  c2_.features AS features_23,
  c2_.raychat_code AS raychat_code_24,
  c2_.visible AS visible_25,
  c2_.updated_at AS updated_at_26,
  c0_.parent_id AS parent_id_27,
  c1_.parent_id AS parent_id_28,
  c2_.parent_id AS parent_id_29
FROM
  category c0_
  LEFT JOIN category c1_ ON c0_.id = c1_.parent_id
  LEFT JOIN category c2_ ON c1_.id = c2_.parent_id
WHERE
  c0_.parent_id IS NULL
  AND c0_.visible = ?

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.level AS level_3, c0_.pic_ext AS pic_ext_4, c0_.features AS features_5, c0_.raychat_code AS raychat_code_6, c0_.visible AS visible_7, c0_.updated_at AS updated_at_8, c1_.id AS id_9, c1_.name AS name_10, c1_.code AS code_11, c1_.level AS level_12, c1_.pic_ext AS pic_ext_13, c1_.features AS features_14, c1_.raychat_code AS raychat_code_15, c1_.visible AS visible_16, c1_.updated_at AS updated_at_17, c2_.id AS id_18, c2_.name AS name_19, c2_.code AS code_20, c2_.level AS level_21, c2_.pic_ext AS pic_ext_22, c2_.features AS features_23, c2_.raychat_code AS raychat_code_24, c2_.visible AS visible_25, c2_.updated_at AS updated_at_26, c0_.parent_id AS parent_id_27, c1_.parent_id AS parent_id_28, c2_.parent_id AS parent_id_29 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.parent_id LEFT JOIN category c2_ ON c1_.id = c2_.parent_id WHERE c0_.parent_id IS NULL AND c0_.visible = 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.link AS link_3,
  t0.type AS type_4,
  t0.position AS position_5,
  t0.order AS order_6,
  t0.page_id AS page_id_7,
  t0.category_id AS category_id_8,
  t0.parent_id AS parent_id_9
FROM
  menu t0
WHERE
  t0.parent_id IS NULL
  AND t0.position = ?
ORDER BY
  t0.order ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.type AS type_4, t0.position AS position_5, t0.order AS order_6, t0.page_id AS page_id_7, t0.category_id AS category_id_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id IS NULL AND t0.position = 0 ORDER BY t0.order ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.code AS code_2,
  c0_.level AS level_3,
  c0_.pic_ext AS pic_ext_4,
  c0_.features AS features_5,
  c0_.raychat_code AS raychat_code_6,
  c0_.visible AS visible_7,
  c0_.updated_at AS updated_at_8,
  c1_.id AS id_9,
  c1_.name AS name_10,
  c1_.code AS code_11,
  c1_.level AS level_12,
  c1_.pic_ext AS pic_ext_13,
  c1_.features AS features_14,
  c1_.raychat_code AS raychat_code_15,
  c1_.visible AS visible_16,
  c1_.updated_at AS updated_at_17,
  c2_.id AS id_18,
  c2_.name AS name_19,
  c2_.code AS code_20,
  c2_.level AS level_21,
  c2_.pic_ext AS pic_ext_22,
  c2_.features AS features_23,
  c2_.raychat_code AS raychat_code_24,
  c2_.visible AS visible_25,
  c2_.updated_at AS updated_at_26,
  c0_.parent_id AS parent_id_27,
  c1_.parent_id AS parent_id_28,
  c2_.parent_id AS parent_id_29
FROM
  category c0_
  LEFT JOIN category c1_ ON c0_.id = c1_.parent_id
  LEFT JOIN category c2_ ON c1_.id = c2_.parent_id
WHERE
  c0_.parent_id IS NULL
  AND c0_.visible = ?

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.level AS level_3, c0_.pic_ext AS pic_ext_4, c0_.features AS features_5, c0_.raychat_code AS raychat_code_6, c0_.visible AS visible_7, c0_.updated_at AS updated_at_8, c1_.id AS id_9, c1_.name AS name_10, c1_.code AS code_11, c1_.level AS level_12, c1_.pic_ext AS pic_ext_13, c1_.features AS features_14, c1_.raychat_code AS raychat_code_15, c1_.visible AS visible_16, c1_.updated_at AS updated_at_17, c2_.id AS id_18, c2_.name AS name_19, c2_.code AS code_20, c2_.level AS level_21, c2_.pic_ext AS pic_ext_22, c2_.features AS features_23, c2_.raychat_code AS raychat_code_24, c2_.visible AS visible_25, c2_.updated_at AS updated_at_26, c0_.parent_id AS parent_id_27, c1_.parent_id AS parent_id_28, c2_.parent_id AS parent_id_29 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.parent_id LEFT JOIN category c2_ ON c1_.id = c2_.parent_id WHERE c0_.parent_id IS NULL AND c0_.visible = 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.link AS link_3,
  t0.type AS type_4,
  t0.position AS position_5,
  t0.order AS order_6,
  t0.page_id AS page_id_7,
  t0.category_id AS category_id_8,
  t0.parent_id AS parent_id_9
FROM
  menu t0
WHERE
  t0.parent_id IS NULL
  AND t0.position = ?
ORDER BY
  t0.order ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.type AS type_4, t0.position AS position_5, t0.order AS order_6, t0.page_id AS page_id_7, t0.category_id AS category_id_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id IS NULL AND t0.position = 0 ORDER BY t0.order ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.link AS link_3,
  t0.type AS type_4,
  t0.position AS position_5,
  t0.order AS order_6,
  t0.page_id AS page_id_7,
  t0.category_id AS category_id_8,
  t0.parent_id AS parent_id_9
FROM
  menu t0
WHERE
  t0.parent_id IS NULL
  AND t0.position = ?
ORDER BY
  t0.order ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.type AS type_4, t0.position AS position_5, t0.order AS order_6, t0.page_id AS page_id_7, t0.category_id AS category_id_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id IS NULL AND t0.position = 1 ORDER BY t0.order ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.link AS link_3,
  t0.type AS type_4,
  t0.position AS position_5,
  t0.order AS order_6,
  t0.page_id AS page_id_7,
  t0.category_id AS category_id_8,
  t0.parent_id AS parent_id_9
FROM
  menu t0
WHERE
  t0.parent_id IS NULL
  AND t0.position = ?
ORDER BY
  t0.order ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.type AS type_4, t0.position AS position_5, t0.order AS order_6, t0.page_id AS page_id_7, t0.category_id AS category_id_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id IS NULL AND t0.position = 2 ORDER BY t0.order ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.link AS link_3,
  t0.type AS type_4,
  t0.position AS position_5,
  t0.order AS order_6,
  t0.page_id AS page_id_7,
  t0.category_id AS category_id_8,
  t0.parent_id AS parent_id_9
FROM
  menu t0
WHERE
  t0.parent_id IS NULL
  AND t0.position = ?
ORDER BY
  t0.order ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.type AS type_4, t0.position AS position_5, t0.order AS order_6, t0.page_id AS page_id_7, t0.category_id AS category_id_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id IS NULL AND t0.position = 3 ORDER BY t0.order ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.link AS link_3,
  t0.type AS type_4,
  t0.position AS position_5,
  t0.order AS order_6,
  t0.page_id AS page_id_7,
  t0.category_id AS category_id_8,
  t0.parent_id AS parent_id_9
FROM
  menu t0
WHERE
  t0.parent_id IS NULL
  AND t0.position = ?
ORDER BY
  t0.order ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.type AS type_4, t0.position AS position_5, t0.order AS order_6, t0.page_id AS page_id_7, t0.category_id AS category_id_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id IS NULL AND t0.position = 4 ORDER BY t0.order ASC;