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
  s0_.id AS id_0,
  s0_.title AS title_1,
  s0_.link AS link_2,
  s0_.imageURL AS imageURL_3,
  s0_.status AS status_4,
  s0_.sortstatus AS sortstatus_5
FROM
  slider s0_
WHERE
  s0_.status = ?
ORDER BY
  s0_.sortstatus ASC

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.link AS link_2, s0_.imageURL AS imageURL_3, s0_.status AS status_4, s0_.sortstatus AS sortstatus_5 FROM slider s0_ WHERE s0_.status = 1 ORDER BY s0_.sortstatus ASC;

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.explanation AS explanation_2,
  b0_.link AS link_3,
  b0_.imageURL AS imageURL_4,
  b0_.column_width AS column_width_5,
  b0_.status AS status_6,
  b0_.sortstatus AS sortstatus_7,
  b0_.titleA AS titleA_8,
  b0_.explanationA AS explanationA_9,
  b0_.animation AS animation_10
FROM
  banner b0_
WHERE
  b0_.status = ?
ORDER BY
  b0_.sortstatus ASC

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.explanation AS explanation_2, b0_.link AS link_3, b0_.imageURL AS imageURL_4, b0_.column_width AS column_width_5, b0_.status AS status_6, b0_.sortstatus AS sortstatus_7, b0_.titleA AS titleA_8, b0_.explanationA AS explanationA_9, b0_.animation AS animation_10 FROM banner b0_ WHERE b0_.status = 1 ORDER BY b0_.sortstatus ASC;

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

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

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.sortstatus AS sortstatus_2,
  c0_.row_count AS row_count_3,
  c0_.display_type AS display_type_4,
  p1_.id AS id_5,
  p1_.code AS code_6,
  p1_.equivalent_code AS equivalent_code_7,
  p1_.name AS name_8,
  p1_.meta_description AS meta_description_9,
  p1_.meta_title AS meta_title_10,
  p1_.meta_keywords AS meta_keywords_11,
  p1_.description AS description_12,
  p1_.seo AS seo_13,
  p1_.default_unit AS default_unit_14,
  p1_.quantity AS quantity_15,
  p1_.tax_rate AS tax_rate_16,
  p1_.image AS image_17,
  p1_.currency AS currency_18,
  p1_.ozelkod AS ozelkod_19,
  p1_.ozelkod2 AS ozelkod2_20,
  p1_.ozelkod3 AS ozelkod3_21,
  p1_.ozelkod4 AS ozelkod4_22,
  p1_.ozelkod5 AS ozelkod5_23,
  p1_.ozelkod6 AS ozelkod6_24,
  p1_.ozelkod7 AS ozelkod7_25,
  p1_.ozelkod8 AS ozelkod8_26,
  p1_.ozelkod9 AS ozelkod9_27,
  p1_.ozelkod10 AS ozelkod10_28,
  p2_.id AS id_29,
  p2_.value AS value_30,
  p2_.barcode AS barcode_31,
  p2_.default_price_order AS default_price_order_32,
  p2_.list_price_order AS list_price_order_33,
  p2_.multiplier AS multiplier_34,
  p2_.length AS length_35,
  p2_.width AS width_36,
  p2_.height AS height_37,
  p2_.weight AS weight_38,
  p3_.id AS id_39,
  p3_.value AS value_40,
  p3_.currency AS currency_41,
  p3_.price_order AS price_order_42,
  s4_.id AS id_43,
  s4_.quantity AS quantity_44,
  s4_.warehouseId AS warehouseId_45,
  s4_.date AS date_46,
  s4_.warehouseName AS warehouseName_47,
  s4_.inventoryId AS inventoryId_48,
  i5_.id AS id_49,
  i5_.image AS image_50,
  i5_.name AS name_51,
  b6_.id AS id_52,
  b6_.name AS name_53,
  b6_.code AS code_54,
  c7_.id AS id_55,
  c7_.name AS name_56,
  c7_.description AS description_57,
  c7_.meta_title AS meta_title_58,
  c7_.meta_description AS meta_description_59,
  c7_.meta_keyword AS meta_keyword_60,
  c7_.seo AS seo_61,
  c7_.order AS order_62,
  c0_.product_id AS product_id_63,
  p1_.parent_id AS parent_id_64,
  p1_.model_id AS model_id_65,
  p1_.brand_id AS brand_id_66,
  p2_.product_id AS product_id_67,
  p3_.product_unit_id AS product_unit_id_68,
  s4_.productId AS productId_69,
  i5_.product_id AS product_id_70,
  c7_.parent_id AS parent_id_71
FROM
  campaign c0_
  LEFT JOIN product_to_campaign p8_ ON c0_.id = p8_.campaign_id
  LEFT JOIN product p1_ ON p1_.id = p8_.product_id
  LEFT JOIN product_unit p2_ ON p1_.id = p2_.product_id
  LEFT JOIN product_price p3_ ON p2_.id = p3_.product_unit_id
  LEFT JOIN stock_inventory s4_ ON p1_.id = s4_.productId
  LEFT JOIN image i5_ ON p1_.id = i5_.product_id
  LEFT JOIN brand b6_ ON p1_.brand_id = b6_.id
  LEFT JOIN product_to_category p9_ ON p1_.id = p9_.product_id
  LEFT JOIN category c7_ ON c7_.id = p9_.category_id
WHERE
  c0_.product_id IS NULL
ORDER BY
  c0_.sortstatus ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.sortstatus AS sortstatus_2, c0_.row_count AS row_count_3, c0_.display_type AS display_type_4, p1_.id AS id_5, p1_.code AS code_6, p1_.equivalent_code AS equivalent_code_7, p1_.name AS name_8, p1_.meta_description AS meta_description_9, p1_.meta_title AS meta_title_10, p1_.meta_keywords AS meta_keywords_11, p1_.description AS description_12, p1_.seo AS seo_13, p1_.default_unit AS default_unit_14, p1_.quantity AS quantity_15, p1_.tax_rate AS tax_rate_16, p1_.image AS image_17, p1_.currency AS currency_18, p1_.ozelkod AS ozelkod_19, p1_.ozelkod2 AS ozelkod2_20, p1_.ozelkod3 AS ozelkod3_21, p1_.ozelkod4 AS ozelkod4_22, p1_.ozelkod5 AS ozelkod5_23, p1_.ozelkod6 AS ozelkod6_24, p1_.ozelkod7 AS ozelkod7_25, p1_.ozelkod8 AS ozelkod8_26, p1_.ozelkod9 AS ozelkod9_27, p1_.ozelkod10 AS ozelkod10_28, p2_.id AS id_29, p2_.value AS value_30, p2_.barcode AS barcode_31, p2_.default_price_order AS default_price_order_32, p2_.list_price_order AS list_price_order_33, p2_.multiplier AS multiplier_34, p2_.length AS length_35, p2_.width AS width_36, p2_.height AS height_37, p2_.weight AS weight_38, p3_.id AS id_39, p3_.value AS value_40, p3_.currency AS currency_41, p3_.price_order AS price_order_42, s4_.id AS id_43, s4_.quantity AS quantity_44, s4_.warehouseId AS warehouseId_45, s4_.date AS date_46, s4_.warehouseName AS warehouseName_47, s4_.inventoryId AS inventoryId_48, i5_.id AS id_49, i5_.image AS image_50, i5_.name AS name_51, b6_.id AS id_52, b6_.name AS name_53, b6_.code AS code_54, c7_.id AS id_55, c7_.name AS name_56, c7_.description AS description_57, c7_.meta_title AS meta_title_58, c7_.meta_description AS meta_description_59, c7_.meta_keyword AS meta_keyword_60, c7_.seo AS seo_61, c7_.order AS order_62, c0_.product_id AS product_id_63, p1_.parent_id AS parent_id_64, p1_.model_id AS model_id_65, p1_.brand_id AS brand_id_66, p2_.product_id AS product_id_67, p3_.product_unit_id AS product_unit_id_68, s4_.productId AS productId_69, i5_.product_id AS product_id_70, c7_.parent_id AS parent_id_71 FROM campaign c0_ LEFT JOIN product_to_campaign p8_ ON c0_.id = p8_.campaign_id LEFT JOIN product p1_ ON p1_.id = p8_.product_id LEFT JOIN product_unit p2_ ON p1_.id = p2_.product_id LEFT JOIN product_price p3_ ON p2_.id = p3_.product_unit_id LEFT JOIN stock_inventory s4_ ON p1_.id = s4_.productId LEFT JOIN image i5_ ON p1_.id = i5_.product_id LEFT JOIN brand b6_ ON p1_.brand_id = b6_.id LEFT JOIN product_to_category p9_ ON p1_.id = p9_.product_id LEFT JOIN category c7_ ON c7_.id = p9_.category_id WHERE c0_.product_id IS NULL ORDER BY c0_.sortstatus ASC;

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

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

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.email AS email_6,
  t0.description AS description_7,
  t0.logo AS logo_8,
  t0.whatsapp AS whatsapp_9,
  t0.social_media AS social_media_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.email AS email_6, t0.description AS description_7, t0.logo AS logo_8, t0.whatsapp AS whatsapp_9, t0.social_media AS social_media_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
  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` = 'defaultCurrency' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.session_id AS session_id_1,
  c0_.var1 AS var1_2,
  c0_.quantity AS quantity_3,
  c0_.customer_number AS customer_number_4,
  c0_.is_discounted AS is_discounted_5,
  c0_.product_id AS product_id_6,
  c0_.user_id AS user_id_7,
  c0_.product_unit_id AS product_unit_id_8
FROM
  cart c0_
WHERE
  c0_.session_id = ?

SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.var1 AS var1_2, c0_.quantity AS quantity_3, c0_.customer_number AS customer_number_4, c0_.is_discounted AS is_discounted_5, c0_.product_id AS product_id_6, c0_.user_id AS user_id_7, c0_.product_unit_id AS product_unit_id_8 FROM cart c0_ WHERE c0_.session_id = NULL;

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
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.description AS description_2,
  p0_.keywords AS keywords_3,
  p0_.content AS content_4,
  p0_.seo AS seo_5,
  p0_.sortStatus AS sortStatus_6,
  p0_.page_category_id AS page_category_id_7
FROM
  page p0_
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.keywords AS keywords_3, p0_.content AS content_4, p0_.seo AS seo_5, p0_.sortStatus AS sortStatus_6, p0_.page_category_id AS page_category_id_7 FROM page p0_ ORDER BY p0_.id DESC;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.status AS status_2
FROM
  page_category p0_
WHERE
  (
    SELECT
      COUNT(*)
    FROM
      page p1_
    WHERE
      p1_.page_category_id = p0_.id
  ) > 0
ORDER BY
  p0_.status ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.status AS status_2 FROM page_category p0_ WHERE (SELECT COUNT(*) FROM page p1_ WHERE p1_.page_category_id = p0_.id) > 0 ORDER BY p0_.status ASC;

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.description AS description_2,
  p0_.keywords AS keywords_3,
  p0_.content AS content_4,
  p0_.seo AS seo_5,
  p0_.sortStatus AS sortStatus_6,
  p0_.page_category_id AS page_category_id_7
FROM
  page p0_
GROUP BY
  p0_.page_category_id

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.keywords AS keywords_3, p0_.content AS content_4, p0_.seo AS seo_5, p0_.sortStatus AS sortStatus_6, p0_.page_category_id AS page_category_id_7 FROM page p0_ GROUP BY p0_.page_category_id;