Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.currency AS currency_3,
  t0.price_order AS price_order_4,
  t0.product_unit_id AS product_unit_id_5
FROM
  product_price t0
WHERE
  t0.product_unit_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.currency AS currency_3, t0.price_order AS price_order_4, t0.product_unit_id AS product_unit_id_5 FROM product_price t0 WHERE t0.product_unit_id = 366;

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 = 387;

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` = 'showNotInStocks' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.equivalent_code AS equivalent_code_3,
  t0.name AS name_4,
  t0.meta_description AS meta_description_5,
  t0.meta_title AS meta_title_6,
  t0.meta_keywords AS meta_keywords_7,
  t0.description AS description_8,
  t0.seo AS seo_9,
  t0.default_unit AS default_unit_10,
  t0.quantity AS quantity_11,
  t0.tax_rate AS tax_rate_12,
  t0.image AS image_13,
  t0.currency AS currency_14,
  t0.comment_count AS comment_count_15,
  t0.star_rate AS star_rate_16,
  t0.sales_number AS sales_number_17,
  t0.parent_id AS parent_id_18,
  t0.model_id AS model_id_19,
  t0.brand_id AS brand_id_20
FROM
  product t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.equivalent_code AS equivalent_code_3, t0.name AS name_4, t0.meta_description AS meta_description_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.description AS description_8, t0.seo AS seo_9, t0.default_unit AS default_unit_10, t0.quantity AS quantity_11, t0.tax_rate AS tax_rate_12, t0.image AS image_13, t0.currency AS currency_14, t0.comment_count AS comment_count_15, t0.star_rate AS star_rate_16, t0.sales_number AS sales_number_17, t0.parent_id AS parent_id_18, t0.model_id AS model_id_19, t0.brand_id AS brand_id_20 FROM product t0 WHERE t0.parent_id = 5173;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.barcode AS barcode_3,
  t0.default_price_order AS default_price_order_4,
  t0.list_price_order AS list_price_order_5,
  t0.multiplier AS multiplier_6,
  t0.length AS length_7,
  t0.width AS width_8,
  t0.height AS height_9,
  t0.weight AS weight_10,
  t0.product_id AS product_id_11
FROM
  product_unit t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.barcode AS barcode_3, t0.default_price_order AS default_price_order_4, t0.list_price_order AS list_price_order_5, t0.multiplier AS multiplier_6, t0.length AS length_7, t0.width AS width_8, t0.height AS height_9, t0.weight AS weight_10, t0.product_id AS product_id_11 FROM product_unit t0 WHERE t0.product_id = 5173;

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.warehouseId AS warehouseId_3,
  t0.date AS date_4,
  t0.warehouseName AS warehouseName_5,
  t0.inventoryId AS inventoryId_6,
  t0.productId AS productId_7
FROM
  stock_inventory t0
WHERE
  t0.productId = ?

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.warehouseId AS warehouseId_3, t0.date AS date_4, t0.warehouseName AS warehouseName_5, t0.inventoryId AS inventoryId_6, t0.productId AS productId_7 FROM stock_inventory t0 WHERE t0.productId = 5173;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.code AS code_2,
  COUNT(p1_.id) AS sclr_3,
  0 AS sclr_4
FROM
  brand b0_
  INNER JOIN product p1_ ON b0_.id = p1_.brand_id
  INNER JOIN product_to_category p3_ ON p1_.id = p3_.product_id
  INNER JOIN category c2_ ON c2_.id = p3_.category_id
  INNER JOIN product_unit p4_ ON p1_.id = p4_.product_id
  AND (p1_.default_unit = p4_.value)
  INNER JOIN product_price p5_ ON p4_.id = p5_.product_unit_id
  AND (
    p4_.default_price_order = p5_.price_order
  )
  INNER JOIN currency c6_ ON (c6_.code = p5_.currency)
WHERE
  c2_.id = ?
  AND (
    p1_.quantity > 0
    AND p1_.id <> ''
    AND p1_.parent_id IS NULL
  )
GROUP BY
  b0_.id
ORDER BY
  b0_.name ASC

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.code AS code_2, COUNT(p1_.id) AS sclr_3, 0 AS sclr_4 FROM brand b0_ INNER JOIN product p1_ ON b0_.id = p1_.brand_id INNER JOIN product_to_category p3_ ON p1_.id = p3_.product_id INNER JOIN category c2_ ON c2_.id = p3_.category_id INNER JOIN product_unit p4_ ON p1_.id = p4_.product_id AND (p1_.default_unit = p4_.value) INNER JOIN product_price p5_ ON p4_.id = p5_.product_unit_id AND (p4_.default_price_order = p5_.price_order) INNER JOIN currency c6_ ON (c6_.code = p5_.currency) WHERE c2_.id = 404 AND (p1_.quantity > 0 AND p1_.id <> '' AND p1_.parent_id IS NULL) GROUP BY b0_.id ORDER BY b0_.name ASC;

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
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    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_
          INNER JOIN product_to_category p2_ ON p0_.id = p2_.product_id
          INNER JOIN category c1_ ON c1_.id = p2_.category_id
          LEFT JOIN brand b3_ ON p0_.brand_id = b3_.id
          INNER JOIN product_unit p4_ ON p0_.id = p4_.product_id
          AND (p0_.default_unit = p4_.value)
          INNER JOIN product_price p5_ ON p4_.id = p5_.product_unit_id
          AND (
            p4_.default_price_order = p5_.price_order
          )
          INNER JOIN currency c6_ ON (c6_.code = p5_.currency)
        WHERE
          c1_.id = ?
          AND (
            p0_.quantity > 0
            AND p0_.id <> ''
            AND p0_.parent_id IS NULL
          )
        ORDER BY
          p0_.name ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 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_ INNER JOIN product_to_category p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.category_id LEFT JOIN brand b3_ ON p0_.brand_id = b3_.id INNER JOIN product_unit p4_ ON p0_.id = p4_.product_id AND (p0_.default_unit = p4_.value) INNER JOIN product_price p5_ ON p4_.id = p5_.product_unit_id AND (p4_.default_price_order = p5_.price_order) INNER JOIN currency c6_ ON (c6_.code = p5_.currency) WHERE c1_.id = 404 AND (p0_.quantity > 0 AND p0_.id <> '' AND p0_.parent_id IS NULL) ORDER BY p0_.name ASC) dctrn_result) dctrn_table;

SELECT
  v0_.id AS id_0,
  v0_.code AS code_1,
  v0_.name AS name_2
FROM
  variant v0_
  INNER JOIN variant_value v1_ ON v0_.id = v1_.variant_id
  INNER JOIN product_to_variant_value p3_ ON v1_.id = p3_.variant_value_id
  INNER JOIN product p2_ ON p2_.id = p3_.product_id
  LEFT JOIN brand b4_ ON p2_.brand_id = b4_.id
  INNER JOIN product_to_category p6_ ON p2_.id = p6_.product_id
  INNER JOIN category c5_ ON c5_.id = p6_.category_id
  INNER JOIN product_unit p7_ ON p2_.id = p7_.product_id
  AND (p2_.default_unit = p7_.value)
  INNER JOIN product_price p8_ ON p7_.id = p8_.product_unit_id
  AND (
    p7_.default_price_order = p8_.price_order
  )
  INNER JOIN currency c9_ ON (c9_.code = p8_.currency)
WHERE
  c5_.id = ?
  AND (
    p2_.quantity > 0
    AND p2_.id <> ''
    AND p2_.parent_id IS NULL
  )
GROUP BY
  v0_.id
ORDER BY
  v0_.name ASC

SELECT v0_.id AS id_0, v0_.code AS code_1, v0_.name AS name_2 FROM variant v0_ INNER JOIN variant_value v1_ ON v0_.id = v1_.variant_id INNER JOIN product_to_variant_value p3_ ON v1_.id = p3_.variant_value_id INNER JOIN product p2_ ON p2_.id = p3_.product_id LEFT JOIN brand b4_ ON p2_.brand_id = b4_.id INNER JOIN product_to_category p6_ ON p2_.id = p6_.product_id INNER JOIN category c5_ ON c5_.id = p6_.category_id INNER JOIN product_unit p7_ ON p2_.id = p7_.product_id AND (p2_.default_unit = p7_.value) INNER JOIN product_price p8_ ON p7_.id = p8_.product_unit_id AND (p7_.default_price_order = p8_.price_order) INNER JOIN currency c9_ ON (c9_.code = p8_.currency) WHERE c5_.id = 404 AND (p2_.quantity > 0 AND p2_.id <> '' AND p2_.parent_id IS NULL) GROUP BY v0_.id ORDER BY v0_.name ASC;

SELECT
  p0_.id AS id_0,
  p0_.value AS value_1,
  p0_.barcode AS barcode_2,
  p0_.default_price_order AS default_price_order_3,
  p0_.list_price_order AS list_price_order_4,
  p0_.multiplier AS multiplier_5,
  p0_.length AS length_6,
  p0_.width AS width_7,
  p0_.height AS height_8,
  p0_.weight AS weight_9,
  p1_.id AS id_10,
  p1_.value AS value_11,
  p1_.currency AS currency_12,
  p1_.price_order AS price_order_13,
  p0_.product_id AS product_id_14,
  p1_.product_unit_id AS product_unit_id_15
FROM
  product_unit p0_
  LEFT JOIN product_price p1_ ON p0_.id = p1_.product_unit_id
WHERE
  p0_.product_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.barcode AS barcode_2, p0_.default_price_order AS default_price_order_3, p0_.list_price_order AS list_price_order_4, p0_.multiplier AS multiplier_5, p0_.length AS length_6, p0_.width AS width_7, p0_.height AS height_8, p0_.weight AS weight_9, p1_.id AS id_10, p1_.value AS value_11, p1_.currency AS currency_12, p1_.price_order AS price_order_13, p0_.product_id AS product_id_14, p1_.product_unit_id AS product_unit_id_15 FROM product_unit p0_ LEFT JOIN product_price p1_ ON p0_.id = p1_.product_unit_id WHERE p0_.product_id IN (5173, 5157, 5216, 4099, 4102, 8891, 8885, 8887, 8890, 8884, 8892, 8969, 8889, 8963, 4101, 8886);

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.description AS description_2,
  c0_.meta_title AS meta_title_3,
  c0_.meta_description AS meta_description_4,
  c0_.meta_keyword AS meta_keyword_5,
  c0_.seo AS seo_6,
  c0_.order AS order_7,
  c0_.parent_id AS parent_id_8
FROM
  category c0_
WHERE
  c0_.parent_id IS NULL
ORDER BY
  c0_.order ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.meta_title AS meta_title_3, c0_.meta_description AS meta_description_4, c0_.meta_keyword AS meta_keyword_5, c0_.seo AS seo_6, c0_.order AS order_7, c0_.parent_id AS parent_id_8 FROM category c0_ WHERE c0_.parent_id IS NULL ORDER BY c0_.order ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.description AS description_2,
  c0_.meta_title AS meta_title_3,
  c0_.meta_description AS meta_description_4,
  c0_.meta_keyword AS meta_keyword_5,
  c0_.seo AS seo_6,
  c0_.order AS order_7,
  COUNT(p1_.id) AS sclr_8,
  c0_.parent_id AS parent_id_9
FROM
  category c0_
  INNER JOIN product_to_category p2_ ON c0_.id = p2_.category_id
  INNER JOIN product p1_ ON p1_.id = p2_.product_id
  LEFT JOIN brand b3_ ON p1_.brand_id = b3_.id
  INNER JOIN product_unit p4_ ON p1_.id = p4_.product_id
  AND (p1_.default_unit = p4_.value)
  INNER JOIN product_price p5_ ON p4_.id = p5_.product_unit_id
  AND (
    p4_.default_price_order = p5_.price_order
  )
  INNER JOIN currency c6_ ON (c6_.code = p5_.currency)
WHERE
  c0_.parent_id = ?
  AND (
    p1_.quantity > 0
    AND p1_.id <> ''
    AND p1_.parent_id IS NULL
  )
GROUP BY
  c0_.id
ORDER BY
  c0_.order ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.meta_title AS meta_title_3, c0_.meta_description AS meta_description_4, c0_.meta_keyword AS meta_keyword_5, c0_.seo AS seo_6, c0_.order AS order_7, COUNT(p1_.id) AS sclr_8, c0_.parent_id AS parent_id_9 FROM category c0_ INNER JOIN product_to_category p2_ ON c0_.id = p2_.category_id INNER JOIN product p1_ ON p1_.id = p2_.product_id LEFT JOIN brand b3_ ON p1_.brand_id = b3_.id INNER JOIN product_unit p4_ ON p1_.id = p4_.product_id AND (p1_.default_unit = p4_.value) INNER JOIN product_price p5_ ON p4_.id = p5_.product_unit_id AND (p4_.default_price_order = p5_.price_order) INNER JOIN currency c6_ ON (c6_.code = p5_.currency) WHERE c0_.parent_id = 404 AND (p1_.quantity > 0 AND p1_.id <> '' AND p1_.parent_id IS NULL) GROUP BY c0_.id ORDER BY c0_.order ASC;

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.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.id = '404';

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.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
  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
  s0_.id AS id_0,
  s0_.quantity AS quantity_1,
  s0_.warehouseId AS warehouseId_2,
  s0_.date AS date_3,
  s0_.warehouseName AS warehouseName_4,
  s0_.inventoryId AS inventoryId_5,
  s0_.productId AS productId_6
FROM
  stock_inventory s0_
WHERE
  s0_.productId IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT s0_.id AS id_0, s0_.quantity AS quantity_1, s0_.warehouseId AS warehouseId_2, s0_.date AS date_3, s0_.warehouseName AS warehouseName_4, s0_.inventoryId AS inventoryId_5, s0_.productId AS productId_6 FROM stock_inventory s0_ WHERE s0_.productId IN (5173, 5157, 5216, 4099, 4102, 8891, 8885, 8887, 8890, 8884, 8892, 8969, 8889, 8963, 4101, 8886);

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;

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_
WHERE
  p0_.parent_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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_ WHERE p0_.parent_id IN (5173, 5157, 5216, 4099, 4102, 8891, 8885, 8887, 8890, 8884, 8892, 8969, 8889, 8963, 4101, 8886);

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
  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.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;