Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.code AS code_1,
  p0_.equivalent_code AS equivalent_code_2,
  p0_.name AS name_3,
  p0_.meta_description AS meta_description_4,
  p0_.meta_title AS meta_title_5,
  p0_.meta_keywords AS meta_keywords_6,
  p0_.description AS description_7,
  p0_.seo AS seo_8,
  p0_.default_unit AS default_unit_9,
  p0_.quantity AS quantity_10,
  p0_.tax_rate AS tax_rate_11,
  p0_.image AS image_12,
  p0_.currency AS currency_13,
  p0_.comment_count AS comment_count_14,
  p0_.star_rate AS star_rate_15,
  p0_.sales_number AS sales_number_16,
  p0_.parent_id AS parent_id_17,
  p0_.model_id AS model_id_18,
  p0_.brand_id AS brand_id_19
FROM
  product p0_
  LEFT JOIN brand b1_ ON p0_.brand_id = b1_.id
  INNER JOIN product_unit p2_ ON p0_.id = p2_.product_id
  AND (p0_.default_unit = p2_.value)
  INNER JOIN product_price p3_ ON p2_.id = p3_.product_unit_id
  AND (
    p2_.default_price_order = p3_.price_order
  )
  INNER JOIN currency c4_ ON (c4_.code = p3_.currency)
WHERE
  (
    (
      p0_.code LIKE ?
      OR p0_.equivalent_code LIKE ?
      OR p2_.barcode LIKE ?
    )
    OR (p0_.name LIKE ?)
  )
  AND (
    p0_.id <> ''
    AND p0_.parent_id IS NULL
  )
  AND b1_.code IN (?)
GROUP BY
  p0_.id
ORDER BY
  p3_.value * c4_.exchangeRate ASC
LIMIT
  20

SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.equivalent_code AS equivalent_code_2, p0_.name AS name_3, p0_.meta_description AS meta_description_4, p0_.meta_title AS meta_title_5, p0_.meta_keywords AS meta_keywords_6, p0_.description AS description_7, p0_.seo AS seo_8, p0_.default_unit AS default_unit_9, p0_.quantity AS quantity_10, p0_.tax_rate AS tax_rate_11, p0_.image AS image_12, p0_.currency AS currency_13, p0_.comment_count AS comment_count_14, p0_.star_rate AS star_rate_15, p0_.sales_number AS sales_number_16, p0_.parent_id AS parent_id_17, p0_.model_id AS model_id_18, p0_.brand_id AS brand_id_19 FROM product p0_ LEFT JOIN brand b1_ ON p0_.brand_id = b1_.id INNER JOIN product_unit p2_ ON p0_.id = p2_.product_id AND (p0_.default_unit = p2_.value) INNER JOIN product_price p3_ ON p2_.id = p3_.product_unit_id AND (p2_.default_price_order = p3_.price_order) INNER JOIN currency c4_ ON (c4_.code = p3_.currency) WHERE ((p0_.code LIKE '%%' OR p0_.equivalent_code LIKE '%%' OR p2_.barcode LIKE '%%') OR (p0_.name LIKE '%%')) AND (p0_.id <> '' AND p0_.parent_id IS NULL) AND b1_.code IN ('agrofarmix') GROUP BY p0_.id ORDER BY p3_.value * c4_.exchangeRate ASC LIMIT 20;

SELECT
  t0.id AS id_1,
  t0.`key` AS key_2,
  t0.`value` AS value_3
FROM
  setting t0
WHERE
  t0.`key` = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3 FROM setting t0 WHERE t0.`key` = 'b2b_license_end_date' LIMIT 1;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      p0_.id AS id_0,
      p0_.code AS code_1,
      p0_.equivalent_code AS equivalent_code_2,
      p0_.name AS name_3,
      p0_.meta_description AS meta_description_4,
      p0_.meta_title AS meta_title_5,
      p0_.meta_keywords AS meta_keywords_6,
      p0_.description AS description_7,
      p0_.seo AS seo_8,
      p0_.default_unit AS default_unit_9,
      p0_.quantity AS quantity_10,
      p0_.tax_rate AS tax_rate_11,
      p0_.image AS image_12,
      p0_.currency AS currency_13,
      p0_.comment_count AS comment_count_14,
      p0_.star_rate AS star_rate_15,
      p0_.sales_number AS sales_number_16
    FROM
      product p0_
      LEFT JOIN brand b1_ ON p0_.brand_id = b1_.id
      INNER JOIN product_unit p2_ ON p0_.id = p2_.product_id
      AND (p0_.default_unit = p2_.value)
      INNER JOIN product_price p3_ ON p2_.id = p3_.product_unit_id
      AND (
        p2_.default_price_order = p3_.price_order
      )
      INNER JOIN currency c4_ ON (c4_.code = p3_.currency)
    WHERE
      (
        (
          p0_.code LIKE ?
          OR p0_.equivalent_code LIKE ?
          OR p2_.barcode LIKE ?
        )
        OR (p0_.name LIKE ?)
      )
      AND (
        p0_.id <> ''
        AND p0_.parent_id IS NULL
      )
      AND b1_.code IN (?)
    GROUP BY
      p0_.id
    ORDER BY
      p3_.value * c4_.exchangeRate ASC
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.equivalent_code AS equivalent_code_2, p0_.name AS name_3, p0_.meta_description AS meta_description_4, p0_.meta_title AS meta_title_5, p0_.meta_keywords AS meta_keywords_6, p0_.description AS description_7, p0_.seo AS seo_8, p0_.default_unit AS default_unit_9, p0_.quantity AS quantity_10, p0_.tax_rate AS tax_rate_11, p0_.image AS image_12, p0_.currency AS currency_13, p0_.comment_count AS comment_count_14, p0_.star_rate AS star_rate_15, p0_.sales_number AS sales_number_16 FROM product p0_ LEFT JOIN brand b1_ ON p0_.brand_id = b1_.id INNER JOIN product_unit p2_ ON p0_.id = p2_.product_id AND (p0_.default_unit = p2_.value) INNER JOIN product_price p3_ ON p2_.id = p3_.product_unit_id AND (p2_.default_price_order = p3_.price_order) INNER JOIN currency c4_ ON (c4_.code = p3_.currency) WHERE ((p0_.code LIKE '%%' OR p0_.equivalent_code LIKE '%%' OR p2_.barcode LIKE '%%') OR (p0_.name LIKE '%%')) AND (p0_.id <> '' AND p0_.parent_id IS NULL) AND b1_.code IN ('agrofarmix') GROUP BY p0_.id ORDER BY p3_.value * c4_.exchangeRate ASC) dctrn_table;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.meta_keyword AS meta_keyword_6,
  t0.seo AS seo_7,
  t0.order AS order_8,
  t0.parent_id AS parent_id_9
FROM
  category t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keyword AS meta_keyword_6, t0.seo AS seo_7, t0.order AS order_8, t0.parent_id AS parent_id_9 FROM category t0 WHERE t0.parent_id = 246;

SELECT
  s0_.id AS id_0,
  s0_.`key` AS key_1,
  s0_.`value` AS value_2
FROM
  setting s0_
WHERE
  s0_.`key` = ?

SELECT s0_.id AS id_0, s0_.`key` AS key_1, s0_.`value` AS value_2 FROM setting s0_ WHERE s0_.`key` = 'maintenance_mode';

SELECT
  DISTINCT s0_.warehouseId AS warehouseId_0,
  s0_.warehouseName AS warehouseName_1
FROM
  stock_inventory s0_

SELECT DISTINCT s0_.warehouseId AS warehouseId_0, s0_.warehouseName AS warehouseName_1 FROM stock_inventory s0_;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3
FROM
  brand t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM brand t0;

SELECT
  s0_.id AS id_0,
  s0_.`key` AS key_1,
  s0_.`value` AS value_2
FROM
  setting s0_

SELECT s0_.id AS id_0, s0_.`key` AS key_1, s0_.`value` AS value_2 FROM setting s0_;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.address AS address_4,
  t0.phone AS phone_5,
  t0.whatsapp AS whatsapp_6,
  t0.social_media AS social_media_7,
  t0.email AS email_8,
  t0.description AS description_9,
  t0.logo AS logo_10,
  t0.whatsapp_control AS whatsapp_control_11
FROM
  store t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.address AS address_4, t0.phone AS phone_5, t0.whatsapp AS whatsapp_6, t0.social_media AS social_media_7, t0.email AS email_8, t0.description AS description_9, t0.logo AS logo_10, t0.whatsapp_control AS whatsapp_control_11 FROM store t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.symbol AS symbol_4,
  t0.exchangeRate AS exchangeRate_5
FROM
  currency t0

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.symbol AS symbol_4, t0.exchangeRate AS exchangeRate_5 FROM currency t0;

SELECT
  c0_.id AS id_0,
  c0_.session_id AS session_id_1,
  c0_.quantity AS quantity_2,
  c0_.product_id AS product_id_3,
  c0_.user_id AS user_id_4,
  c0_.product_unit_id AS product_unit_id_5
FROM
  cart c0_
WHERE
  c0_.session_id = ?

SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.quantity AS quantity_2, c0_.product_id AS product_id_3, c0_.user_id AS user_id_4, c0_.product_unit_id AS product_unit_id_5 FROM cart c0_ WHERE c0_.session_id = NULL;

SELECT
  t0.id AS id_1,
  t0.comment_title AS comment_title_2,
  t0.comment_description AS comment_description_3,
  t0.order_no AS order_no_4,
  t0.star AS star_5,
  t0.date AS date_6,
  t0.name AS name_7,
  t0.user_id AS user_id_8,
  t0.product_id AS product_id_9
FROM
  user_comment t0

SELECT t0.id AS id_1, t0.comment_title AS comment_title_2, t0.comment_description AS comment_description_3, t0.order_no AS order_no_4, t0.star AS star_5, t0.date AS date_6, t0.name AS name_7, t0.user_id AS user_id_8, t0.product_id AS product_id_9 FROM user_comment t0;