Symfony Profiler

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

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

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` = 'firstPageIsLogin';

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 = '64';

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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_.ozelkod AS ozelkod_14,
          p0_.ozelkod2 AS ozelkod2_15,
          p0_.ozelkod3 AS ozelkod3_16,
          p0_.ozelkod4 AS ozelkod4_17,
          p0_.ozelkod5 AS ozelkod5_18,
          p0_.ozelkod6 AS ozelkod6_19,
          p0_.ozelkod7 AS ozelkod7_20,
          p0_.ozelkod8 AS ozelkod8_21,
          p0_.ozelkod9 AS ozelkod9_22,
          p0_.ozelkod10 AS ozelkod10_23
        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_.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_.ozelkod AS ozelkod_14, p0_.ozelkod2 AS ozelkod2_15, p0_.ozelkod3 AS ozelkod3_16, p0_.ozelkod4 AS ozelkod4_17, p0_.ozelkod5 AS ozelkod5_18, p0_.ozelkod6 AS ozelkod6_19, p0_.ozelkod7 AS ozelkod7_20, p0_.ozelkod8 AS ozelkod8_21, p0_.ozelkod9 AS ozelkod9_22, p0_.ozelkod10 AS ozelkod10_23 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 = 64 AND p0_.parent_id IS NULL ORDER BY p0_.name ASC) dctrn_result) dctrn_table;

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.ozelkod AS ozelkod_15,
  t0.ozelkod2 AS ozelkod2_16,
  t0.ozelkod3 AS ozelkod3_17,
  t0.ozelkod4 AS ozelkod4_18,
  t0.ozelkod5 AS ozelkod5_19,
  t0.ozelkod6 AS ozelkod6_20,
  t0.ozelkod7 AS ozelkod7_21,
  t0.ozelkod8 AS ozelkod8_22,
  t0.ozelkod9 AS ozelkod9_23,
  t0.ozelkod10 AS ozelkod10_24,
  t0.parent_id AS parent_id_25,
  t0.model_id AS model_id_26,
  t0.brand_id AS brand_id_27
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.ozelkod AS ozelkod_15, t0.ozelkod2 AS ozelkod2_16, t0.ozelkod3 AS ozelkod3_17, t0.ozelkod4 AS ozelkod4_18, t0.ozelkod5 AS ozelkod5_19, t0.ozelkod6 AS ozelkod6_20, t0.ozelkod7 AS ozelkod7_21, t0.ozelkod8 AS ozelkod8_22, t0.ozelkod9 AS ozelkod9_23, t0.ozelkod10 AS ozelkod10_24, t0.parent_id AS parent_id_25, t0.model_id AS model_id_26, t0.brand_id AS brand_id_27 FROM product t0 WHERE t0.parent_id = 2353;