Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.symbol AS symbol_3,
  t0.short_title AS short_title_4,
  t0.code AS code_5,
  t0.tcmb_code AS tcmb_code_6,
  t0.currency_number AS currency_number_7,
  t0.exchange_rate AS exchange_rate_8,
  t0.is_default AS is_default_9,
  t0.is_enabled AS is_enabled_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12
FROM
  sys_currencies t0
WHERE
  t0.short_title IS NULL
  AND t0.is_enabled = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.symbol AS symbol_3, t0.short_title AS short_title_4, t0.code AS code_5, t0.tcmb_code AS tcmb_code_6, t0.currency_number AS currency_number_7, t0.exchange_rate AS exchange_rate_8, t0.is_default AS is_default_9, t0.is_enabled AS is_enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM sys_currencies t0 WHERE t0.short_title IS NULL AND t0.is_enabled = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.symbol AS symbol_3,
  t0.short_title AS short_title_4,
  t0.code AS code_5,
  t0.tcmb_code AS tcmb_code_6,
  t0.currency_number AS currency_number_7,
  t0.exchange_rate AS exchange_rate_8,
  t0.is_default AS is_default_9,
  t0.is_enabled AS is_enabled_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12
FROM
  sys_currencies t0
WHERE
  t0.short_title = ?
  AND t0.is_enabled = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.symbol AS symbol_3, t0.short_title AS short_title_4, t0.code AS code_5, t0.tcmb_code AS tcmb_code_6, t0.currency_number AS currency_number_7, t0.exchange_rate AS exchange_rate_8, t0.is_default AS is_default_9, t0.is_enabled AS is_enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM sys_currencies t0 WHERE t0.short_title = 'USD' AND t0.is_enabled = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.position AS position_3,
  t0.is_enabled AS is_enabled_4,
  t0.del AS del_5,
  t0.show_home AS show_home_6,
  t0.image AS image_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.parent_category_id AS parent_category_id_10
FROM
  main_categories t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.position AS position_3, t0.is_enabled AS is_enabled_4, t0.del AS del_5, t0.show_home AS show_home_6, t0.image AS image_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_category_id AS parent_category_id_10 FROM main_categories t0 WHERE t0.id = '45';

SELECT
  m0_.id AS id_0,
  m0_.code AS code_1,
  m0_.position AS position_2,
  m0_.is_enabled AS is_enabled_3,
  m0_.del AS del_4,
  m0_.show_home AS show_home_5,
  m0_.image AS image_6,
  m0_.created_at AS created_at_7,
  m0_.updated_at AS updated_at_8,
  m0_.parent_category_id AS parent_category_id_9
FROM
  main_categories m0_
  LEFT JOIN main_categories m1_ ON m0_.parent_category_id = m1_.id
  LEFT JOIN main_category_lang m2_ ON m0_.id = m2_.category_id
  LEFT JOIN main_category_images m3_ ON m0_.id = m3_.category_id
WHERE
  m0_.del = 0
  AND m0_.id = ?
ORDER BY
  m0_.position ASC

SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.position AS position_2, m0_.is_enabled AS is_enabled_3, m0_.del AS del_4, m0_.show_home AS show_home_5, m0_.image AS image_6, m0_.created_at AS created_at_7, m0_.updated_at AS updated_at_8, m0_.parent_category_id AS parent_category_id_9 FROM main_categories m0_ LEFT JOIN main_categories m1_ ON m0_.parent_category_id = m1_.id LEFT JOIN main_category_lang m2_ ON m0_.id = m2_.category_id LEFT JOIN main_category_images m3_ ON m0_.id = m3_.category_id WHERE m0_.del = 0 AND m0_.id = 45 ORDER BY m0_.position ASC;

SELECT
  m0_.id AS id_0,
  m0_.code AS code_1,
  m0_.position AS position_2,
  m0_.is_enabled AS is_enabled_3,
  m0_.del AS del_4,
  m0_.show_home AS show_home_5,
  m0_.image AS image_6,
  m0_.created_at AS created_at_7,
  m0_.updated_at AS updated_at_8,
  m0_.parent_category_id AS parent_category_id_9
FROM
  main_categories m0_
  LEFT JOIN main_categories m1_ ON m0_.parent_category_id = m1_.id
  LEFT JOIN main_category_lang m2_ ON m0_.id = m2_.category_id
  LEFT JOIN main_category_images m3_ ON m0_.id = m3_.category_id
WHERE
  m0_.del = 0
  AND m1_.id = ?
ORDER BY
  m0_.position ASC

SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.position AS position_2, m0_.is_enabled AS is_enabled_3, m0_.del AS del_4, m0_.show_home AS show_home_5, m0_.image AS image_6, m0_.created_at AS created_at_7, m0_.updated_at AS updated_at_8, m0_.parent_category_id AS parent_category_id_9 FROM main_categories m0_ LEFT JOIN main_categories m1_ ON m0_.parent_category_id = m1_.id LEFT JOIN main_category_lang m2_ ON m0_.id = m2_.category_id LEFT JOIN main_category_images m3_ ON m0_.id = m3_.category_id WHERE m0_.del = 0 AND m1_.id = 45 ORDER BY m0_.position ASC;

SELECT
  m0_.id AS id_0,
  m0_.code AS code_1,
  m0_.position AS position_2,
  m0_.is_enabled AS is_enabled_3,
  m0_.del AS del_4,
  m0_.show_home AS show_home_5,
  m0_.image AS image_6,
  m0_.created_at AS created_at_7,
  m0_.updated_at AS updated_at_8,
  m0_.parent_category_id AS parent_category_id_9
FROM
  main_categories m0_
  LEFT JOIN main_categories m1_ ON m0_.parent_category_id = m1_.id
  LEFT JOIN main_category_lang m2_ ON m0_.id = m2_.category_id
  LEFT JOIN main_category_images m3_ ON m0_.id = m3_.category_id
WHERE
  m0_.del = 0
  AND m1_.id = ?
ORDER BY
  m0_.position ASC

SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.position AS position_2, m0_.is_enabled AS is_enabled_3, m0_.del AS del_4, m0_.show_home AS show_home_5, m0_.image AS image_6, m0_.created_at AS created_at_7, m0_.updated_at AS updated_at_8, m0_.parent_category_id AS parent_category_id_9 FROM main_categories m0_ LEFT JOIN main_categories m1_ ON m0_.parent_category_id = m1_.id LEFT JOIN main_category_lang m2_ ON m0_.id = m2_.category_id LEFT JOIN main_category_images m3_ ON m0_.id = m3_.category_id WHERE m0_.del = 0 AND m1_.id = 52 ORDER BY m0_.position ASC;

SELECT
  m0_.id AS id_0,
  m0_.code AS code_1,
  m0_.position AS position_2,
  m0_.is_enabled AS is_enabled_3,
  m0_.del AS del_4,
  m0_.show_home AS show_home_5,
  m0_.image AS image_6,
  m0_.created_at AS created_at_7,
  m0_.updated_at AS updated_at_8,
  m0_.parent_category_id AS parent_category_id_9
FROM
  main_categories m0_
  LEFT JOIN main_categories m1_ ON m0_.parent_category_id = m1_.id
  LEFT JOIN main_category_lang m2_ ON m0_.id = m2_.category_id
  LEFT JOIN main_category_images m3_ ON m0_.id = m3_.category_id
WHERE
  m0_.del = 0
  AND m1_.id = ?
ORDER BY
  m0_.position ASC

SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.position AS position_2, m0_.is_enabled AS is_enabled_3, m0_.del AS del_4, m0_.show_home AS show_home_5, m0_.image AS image_6, m0_.created_at AS created_at_7, m0_.updated_at AS updated_at_8, m0_.parent_category_id AS parent_category_id_9 FROM main_categories m0_ LEFT JOIN main_categories m1_ ON m0_.parent_category_id = m1_.id LEFT JOIN main_category_lang m2_ ON m0_.id = m2_.category_id LEFT JOIN main_category_images m3_ ON m0_.id = m3_.category_id WHERE m0_.del = 0 AND m1_.id = 53 ORDER BY m0_.position ASC;

SELECT
  m0_.id AS id_0,
  m0_.code AS code_1,
  m0_.position AS position_2,
  m0_.is_enabled AS is_enabled_3,
  m0_.del AS del_4,
  m0_.show_home AS show_home_5,
  m0_.image AS image_6,
  m0_.created_at AS created_at_7,
  m0_.updated_at AS updated_at_8,
  m0_.parent_category_id AS parent_category_id_9
FROM
  main_categories m0_
  LEFT JOIN main_categories m1_ ON m0_.parent_category_id = m1_.id
  LEFT JOIN main_category_lang m2_ ON m0_.id = m2_.category_id
  LEFT JOIN main_category_images m3_ ON m0_.id = m3_.category_id
WHERE
  m0_.del = 0
  AND m1_.id = ?
ORDER BY
  m0_.position ASC

SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.position AS position_2, m0_.is_enabled AS is_enabled_3, m0_.del AS del_4, m0_.show_home AS show_home_5, m0_.image AS image_6, m0_.created_at AS created_at_7, m0_.updated_at AS updated_at_8, m0_.parent_category_id AS parent_category_id_9 FROM main_categories m0_ LEFT JOIN main_categories m1_ ON m0_.parent_category_id = m1_.id LEFT JOIN main_category_lang m2_ ON m0_.id = m2_.category_id LEFT JOIN main_category_images m3_ ON m0_.id = m3_.category_id WHERE m0_.del = 0 AND m1_.id = 55 ORDER BY m0_.position ASC;

SELECT
  m0_.id AS id_0,
  m0_.code AS code_1,
  m0_.sira AS sira_2,
  m0_.barcode AS barcode_3,
  m0_.product_code AS product_code_4,
  m0_.is_enabled AS is_enabled_5,
  m0_.del AS del_6,
  m0_.new_product AS new_product_7,
  m0_.show_home AS show_home_8,
  m0_.is_variant AS is_variant_9,
  m0_.avarage_rating AS avarage_rating_10,
  m0_.total_visited AS total_visited_11,
  m0_.position AS position_12,
  m0_.total_sales AS total_sales_13,
  m0_.audio_file AS audio_file_14,
  m0_.uuid AS uuid_15,
  m0_.length AS length_16,
  m0_.depth AS depth_17,
  m0_.height AS height_18,
  m0_.weight AS weight_19,
  m0_.product_material AS product_material_20,
  m0_.product_color AS product_color_21,
  m0_.product_suggestion AS product_suggestion_22,
  m0_.product_paint_type AS product_paint_type_23,
  m0_.delivery_time AS delivery_time_24,
  m0_.created_at AS created_at_25,
  m0_.updated_at AS updated_at_26,
  m0_.is_jewel_price AS is_jewel_price_27,
  m0_.brand_id AS brand_id_28,
  m0_.main_category_id AS main_category_id_29,
  m0_.blog_id AS blog_id_30
FROM
  main_products m0_
  LEFT JOIN main_product_lang m1_ ON m0_.id = m1_.product_id
  LEFT JOIN sys_langs s2_ ON m1_.lang_id = s2_.id
  LEFT JOIN main_categories m3_ ON m0_.main_category_id = m3_.id
  LEFT JOIN main_product_other_categories m4_ ON m0_.id = m4_.product_id
  LEFT JOIN main_categories m5_ ON m4_.category_id = m5_.id
  LEFT JOIN main_product_pricing m6_ ON m0_.id = m6_.product_id
  LEFT JOIN main_product_variants m7_ ON m6_.product_variant_id = m7_.id
WHERE
  m6_.id > 0
  AND s2_.id = ?
  AND (
    (
      m3_.id IN (?, ?, ?, ?)
      OR m5_.id IN (?, ?, ?, ?)
    )
  )
  AND m0_.is_enabled = 1
  AND m0_.del = 0
  AND (
    (
      m3_.id IN (?, ?, ?, ?)
      OR m5_.id IN (?, ?, ?, ?)
    )
  )
GROUP BY
  m0_.id,
  m1_.id,
  m6_.id,
  m4_.id
ORDER BY
  MIN(m6_.sales_price) DESC

SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.sira AS sira_2, m0_.barcode AS barcode_3, m0_.product_code AS product_code_4, m0_.is_enabled AS is_enabled_5, m0_.del AS del_6, m0_.new_product AS new_product_7, m0_.show_home AS show_home_8, m0_.is_variant AS is_variant_9, m0_.avarage_rating AS avarage_rating_10, m0_.total_visited AS total_visited_11, m0_.position AS position_12, m0_.total_sales AS total_sales_13, m0_.audio_file AS audio_file_14, m0_.uuid AS uuid_15, m0_.length AS length_16, m0_.depth AS depth_17, m0_.height AS height_18, m0_.weight AS weight_19, m0_.product_material AS product_material_20, m0_.product_color AS product_color_21, m0_.product_suggestion AS product_suggestion_22, m0_.product_paint_type AS product_paint_type_23, m0_.delivery_time AS delivery_time_24, m0_.created_at AS created_at_25, m0_.updated_at AS updated_at_26, m0_.is_jewel_price AS is_jewel_price_27, m0_.brand_id AS brand_id_28, m0_.main_category_id AS main_category_id_29, m0_.blog_id AS blog_id_30 FROM main_products m0_ LEFT JOIN main_product_lang m1_ ON m0_.id = m1_.product_id LEFT JOIN sys_langs s2_ ON m1_.lang_id = s2_.id LEFT JOIN main_categories m3_ ON m0_.main_category_id = m3_.id LEFT JOIN main_product_other_categories m4_ ON m0_.id = m4_.product_id LEFT JOIN main_categories m5_ ON m4_.category_id = m5_.id LEFT JOIN main_product_pricing m6_ ON m0_.id = m6_.product_id LEFT JOIN main_product_variants m7_ ON m6_.product_variant_id = m7_.id WHERE m6_.id > 0 AND s2_.id = 1 AND ((m3_.id IN (52, 53, 55, 45) OR m5_.id IN (52, 53, 55, 45))) AND m0_.is_enabled = 1 AND m0_.del = 0 AND ((m3_.id IN (52, 53, 55, 45) OR m5_.id IN (52, 53, 55, 45))) GROUP BY m0_.id, m1_.id, m6_.id, m4_.id ORDER BY MIN(m6_.sales_price) DESC;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.product_id AS product_id_5,
  t0.jewel_id AS jewel_id_6
FROM
  main_product_jewels t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = 9;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.product_id AS product_id_5,
  t0.jewel_id AS jewel_id_6
FROM
  main_product_jewels t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = 6;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.product_id AS product_id_5,
  t0.jewel_id AS jewel_id_6
FROM
  main_product_jewels t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = 5;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.product_id AS product_id_5,
  t0.jewel_id AS jewel_id_6
FROM
  main_product_jewels t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = 8;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.product_id AS product_id_5,
  t0.jewel_id AS jewel_id_6
FROM
  main_product_jewels t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = 13;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.product_id AS product_id_5,
  t0.jewel_id AS jewel_id_6
FROM
  main_product_jewels t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = 7;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.product_id AS product_id_5,
  t0.jewel_id AS jewel_id_6
FROM
  main_product_jewels t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = 4;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.product_id AS product_id_5,
  t0.jewel_id AS jewel_id_6
FROM
  main_product_jewels t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = 12;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.product_id AS product_id_5,
  t0.jewel_id AS jewel_id_6
FROM
  main_product_jewels t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = 11;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.product_id AS product_id_5,
  t0.jewel_id AS jewel_id_6
FROM
  main_product_jewels t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = 2;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.product_id AS product_id_5,
  t0.jewel_id AS jewel_id_6
FROM
  main_product_jewels t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = 1;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.product_id AS product_id_5,
  t0.jewel_id AS jewel_id_6
FROM
  main_product_jewels t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = 10;