26.77 ms
(16.21%)
|
47 |
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;
|
24.38 ms
(14.77%)
|
44 |
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.is_default = ? 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.is_default = 1 AND t0.is_enabled = 1 LIMIT 1;
|
16.79 ms
(10.17%)
|
13 |
SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.is_enabled AS is_enabled_2, m1_.name AS name_3, m2_.filename AS filename_4, m0_.image AS image_5, m1_.alias AS alias_6, m1_.meta_description AS meta_description_7, m3_.id AS id_8 FROM main_categories m0_ LEFT JOIN main_categories m3_ ON m0_.parent_category_id = m3_.id LEFT JOIN main_category_lang m1_ ON m0_.id = m1_.category_id LEFT JOIN main_category_images m2_ ON m0_.id = m2_.category_id WHERE m0_.del = 0 AND m0_.del = ? AND m3_.id = ? AND m1_.lang_id = ? AND m0_.parent_category_id = ? ORDER BY m0_.position ASC
Parameters: [
0
45
1
45
]
SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.is_enabled AS is_enabled_2, m1_.name AS name_3, m2_.filename AS filename_4, m0_.image AS image_5, m1_.alias AS alias_6, m1_.meta_description AS meta_description_7, m3_.id AS id_8 FROM main_categories m0_ LEFT JOIN main_categories m3_ ON m0_.parent_category_id = m3_.id LEFT JOIN main_category_lang m1_ ON m0_.id = m1_.category_id LEFT JOIN main_category_images m2_ ON m0_.id = m2_.category_id WHERE m0_.del = 0 AND m0_.del = 0 AND m3_.id = 45 AND m1_.lang_id = 1 AND m0_.parent_category_id = 45 ORDER BY m0_.position ASC;
|
15.96 ms
(9.67%)
|
28 |
SELECT t0.id AS id_1, t0.short_title AS short_title_2, t0.name AS name_3, t0.is_default AS is_default_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM sys_langs t0 WHERE t0.is_default = ? LIMIT 1
SELECT t0.id AS id_1, t0.short_title AS short_title_2, t0.name AS name_3, t0.is_default AS is_default_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM sys_langs t0 WHERE t0.is_default = 1 LIMIT 1;
|
11.05 ms
(6.69%)
|
11 |
SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.is_enabled AS is_enabled_2, m1_.name AS name_3, m2_.filename AS filename_4, m0_.image AS image_5, m1_.alias AS alias_6, m1_.meta_description AS meta_description_7, m3_.id AS id_8 FROM main_categories m0_ LEFT JOIN main_categories m3_ ON m0_.parent_category_id = m3_.id LEFT JOIN main_category_lang m1_ ON m0_.id = m1_.category_id LEFT JOIN main_category_images m2_ ON m0_.id = m2_.category_id WHERE m0_.del = 0 AND m0_.del = ? AND m3_.id = ? AND m1_.lang_id = ? AND m0_.is_enabled = 1 AND m0_.parent_category_id = ? ORDER BY m0_.position ASC
Parameters: [
0
45
1
45
]
SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.is_enabled AS is_enabled_2, m1_.name AS name_3, m2_.filename AS filename_4, m0_.image AS image_5, m1_.alias AS alias_6, m1_.meta_description AS meta_description_7, m3_.id AS id_8 FROM main_categories m0_ LEFT JOIN main_categories m3_ ON m0_.parent_category_id = m3_.id LEFT JOIN main_category_lang m1_ ON m0_.id = m1_.category_id LEFT JOIN main_category_images m2_ ON m0_.id = m2_.category_id WHERE m0_.del = 0 AND m0_.del = 0 AND m3_.id = 45 AND m1_.lang_id = 1 AND m0_.is_enabled = 1 AND m0_.parent_category_id = 45 ORDER BY m0_.position ASC;
|
10.20 ms
(6.18%)
|
12 |
SELECT m0_.id AS id_0, m0_.stock AS stock_1, m0_.is_tracked AS is_tracked_2, m0_.is_default AS is_default_3, m0_.created_at AS created_at_4, m0_.updated_at AS updated_at_5, m0_.product_id AS product_id_6 FROM main_product_variants m0_ LEFT JOIN main_products m1_ ON m0_.product_id = m1_.id LEFT JOIN main_product_pricing m2_ ON m0_.id = m2_.product_variant_id LEFT JOIN sys_currencies s3_ ON m2_.currency_id = s3_.id WHERE m1_.id = ? AND m0_.is_default = 1 AND s3_.id = ? ORDER BY m2_.sales_price ASC LIMIT 1
SELECT m0_.id AS id_0, m0_.stock AS stock_1, m0_.is_tracked AS is_tracked_2, m0_.is_default AS is_default_3, m0_.created_at AS created_at_4, m0_.updated_at AS updated_at_5, m0_.product_id AS product_id_6 FROM main_product_variants m0_ LEFT JOIN main_products m1_ ON m0_.product_id = m1_.id LEFT JOIN main_product_pricing m2_ ON m0_.id = m2_.product_variant_id LEFT JOIN sys_currencies s3_ ON m2_.currency_id = s3_.id WHERE m1_.id = 6 AND m0_.is_default = 1 AND s3_.id = 1 ORDER BY m2_.sales_price ASC LIMIT 1;
|
9.87 ms
(5.97%)
|
12 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.sira AS sira_3, t0.barcode AS barcode_4, t0.product_code AS product_code_5, t0.is_enabled AS is_enabled_6, t0.del AS del_7, t0.new_product AS new_product_8, t0.show_home AS show_home_9, t0.is_variant AS is_variant_10, t0.avarage_rating AS avarage_rating_11, t0.total_visited AS total_visited_12, t0.position AS position_13, t0.total_sales AS total_sales_14, t0.audio_file AS audio_file_15, t0.uuid AS uuid_16, t0.length AS length_17, t0.depth AS depth_18, t0.height AS height_19, t0.weight AS weight_20, t0.product_material AS product_material_21, t0.product_color AS product_color_22, t0.product_suggestion AS product_suggestion_23, t0.product_paint_type AS product_paint_type_24, t0.delivery_time AS delivery_time_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.is_jewel_price AS is_jewel_price_28, t0.brand_id AS brand_id_29, t0.main_category_id AS main_category_id_30, t0.blog_id AS blog_id_31, t32.id AS id_33, t32.amount AS amount_34, t32.created_at AS created_at_35, t32.updated_at AS updated_at_36, t32.product_id AS product_id_37, t32.jewel_id AS jewel_id_38 FROM main_products t0 LEFT JOIN main_product_jewels t32 ON t32.product_id = t0.id WHERE t0.id = ? AND t0.del = ? LIMIT 1
SELECT t0.id AS id_1, t0.code AS code_2, t0.sira AS sira_3, t0.barcode AS barcode_4, t0.product_code AS product_code_5, t0.is_enabled AS is_enabled_6, t0.del AS del_7, t0.new_product AS new_product_8, t0.show_home AS show_home_9, t0.is_variant AS is_variant_10, t0.avarage_rating AS avarage_rating_11, t0.total_visited AS total_visited_12, t0.position AS position_13, t0.total_sales AS total_sales_14, t0.audio_file AS audio_file_15, t0.uuid AS uuid_16, t0.length AS length_17, t0.depth AS depth_18, t0.height AS height_19, t0.weight AS weight_20, t0.product_material AS product_material_21, t0.product_color AS product_color_22, t0.product_suggestion AS product_suggestion_23, t0.product_paint_type AS product_paint_type_24, t0.delivery_time AS delivery_time_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.is_jewel_price AS is_jewel_price_28, t0.brand_id AS brand_id_29, t0.main_category_id AS main_category_id_30, t0.blog_id AS blog_id_31, t32.id AS id_33, t32.amount AS amount_34, t32.created_at AS created_at_35, t32.updated_at AS updated_at_36, t32.product_id AS product_id_37, t32.jewel_id AS jewel_id_38 FROM main_products t0 LEFT JOIN main_product_jewels t32 ON t32.product_id = t0.id WHERE t0.id = 6 AND t0.del = 0 LIMIT 1;
|
8.08 ms
(4.89%)
|
12 |
SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.is_default AS is_default_2, m0_.filename AS filename_3, m0_.filesize AS filesize_4, m0_.alt AS alt_5, m0_.created_at AS created_at_6, m0_.updated_at AS updated_at_7 FROM main_product_images m0_ LEFT JOIN main_products m1_ ON m0_.product_id = m1_.id WHERE m1_.id = ?
SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.is_default AS is_default_2, m0_.filename AS filename_3, m0_.filesize AS filesize_4, m0_.alt AS alt_5, m0_.created_at AS created_at_6, m0_.updated_at AS updated_at_7 FROM main_product_images m0_ LEFT JOIN main_products m1_ ON m0_.product_id = m1_.id WHERE m1_.id = 6;
|
7.30 ms
(4.42%)
|
12 |
SELECT t0.id AS id_1, t0.original_price AS original_price_2, t0.discount_rate AS discount_rate_3, t0.sales_price AS sales_price_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7, t0.product_variant_id AS product_variant_id_8, t0.currency_id AS currency_id_9 FROM main_product_pricing t0 WHERE t0.currency_id = ? AND t0.product_variant_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.original_price AS original_price_2, t0.discount_rate AS discount_rate_3, t0.sales_price AS sales_price_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7, t0.product_variant_id AS product_variant_id_8, t0.currency_id AS currency_id_9 FROM main_product_pricing t0 WHERE t0.currency_id = 1 AND t0.product_variant_id = 6 LIMIT 1;
|
6.25 ms
(3.78%)
|
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 = 9;
|
4.90 ms
(2.97%)
|
8 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.page_id AS page_id_6, t0.lang_id AS lang_id_7 FROM main_page_langs t0 WHERE t0.page_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.page_id AS page_id_6, t0.lang_id AS lang_id_7 FROM main_page_langs t0 WHERE t0.page_id = 1;
|
3.55 ms
(2.15%)
|
1 |
SELECT MIN(m0_.sales_price) AS sclr_0, MAX(m0_.sales_price) AS sclr_1, m1_.id AS id_2, m1_.code AS code_3, m1_.sira AS sira_4, m1_.barcode AS barcode_5, m1_.product_code AS product_code_6, m1_.is_enabled AS is_enabled_7, m1_.del AS del_8, m1_.new_product AS new_product_9, m1_.show_home AS show_home_10, m1_.is_variant AS is_variant_11, m1_.avarage_rating AS avarage_rating_12, m1_.total_visited AS total_visited_13, m1_.position AS position_14, m1_.total_sales AS total_sales_15, m1_.audio_file AS audio_file_16, m1_.uuid AS uuid_17, m1_.length AS length_18, m1_.depth AS depth_19, m1_.height AS height_20, m1_.weight AS weight_21, m1_.product_material AS product_material_22, m1_.product_color AS product_color_23, m1_.product_suggestion AS product_suggestion_24, m1_.product_paint_type AS product_paint_type_25, m1_.delivery_time AS delivery_time_26, m1_.created_at AS created_at_27, m1_.updated_at AS updated_at_28, m1_.is_jewel_price AS is_jewel_price_29, m2_.id AS id_30, m2_.name AS name_31, m2_.alias AS alias_32, m2_.description AS description_33, m2_.description_long AS description_long_34, m2_.description_cargo AS description_cargo_35, m2_.meta_title AS meta_title_36, m2_.meta_description AS meta_description_37, m2_.meta_keywords AS meta_keywords_38, m2_.short_description AS short_description_39, m0_.id AS id_40, m0_.original_price AS original_price_41, m0_.discount_rate AS discount_rate_42, m0_.sales_price AS sales_price_43, m0_.created_at AS created_at_44, m0_.updated_at AS updated_at_45, m3_.id AS id_46, m3_.stock AS stock_47, m3_.is_tracked AS is_tracked_48, m3_.is_default AS is_default_49, m3_.created_at AS created_at_50, m3_.updated_at AS updated_at_51 FROM main_products m1_ LEFT JOIN main_product_lang m2_ ON m1_.id = m2_.product_id LEFT JOIN sys_langs s4_ ON m2_.lang_id = s4_.id LEFT JOIN main_categories m5_ ON m1_.main_category_id = m5_.id LEFT JOIN main_product_other_categories m6_ ON m1_.id = m6_.product_id LEFT JOIN main_categories m7_ ON m6_.category_id = m7_.id LEFT JOIN main_product_pricing m0_ ON m1_.id = m0_.product_id LEFT JOIN main_product_variants m3_ ON m0_.product_variant_id = m3_.id WHERE m0_.id > 0 AND s4_.id = ? AND ((m5_.id IN (?, ?, ?, ?) OR m7_.id IN (?, ?, ?, ?))) AND m1_.is_enabled = 1 AND m1_.del = 0 AND ((m5_.id IN (?, ?, ?, ?) OR m7_.id IN (?, ?, ?, ?))) GROUP BY m1_.id, m2_.id, m0_.id, m6_.id ORDER BY MIN(m0_.sales_price) DESC
Parameters: [
1
52
53
55
45
52
53
55
45
52
53
55
45
52
53
55
45
]
SELECT
MIN(m0_.sales_price) AS sclr_0,
MAX(m0_.sales_price) AS sclr_1,
m1_.id AS id_2,
m1_.code AS code_3,
m1_.sira AS sira_4,
m1_.barcode AS barcode_5,
m1_.product_code AS product_code_6,
m1_.is_enabled AS is_enabled_7,
m1_.del AS del_8,
m1_.new_product AS new_product_9,
m1_.show_home AS show_home_10,
m1_.is_variant AS is_variant_11,
m1_.avarage_rating AS avarage_rating_12,
m1_.total_visited AS total_visited_13,
m1_.position AS position_14,
m1_.total_sales AS total_sales_15,
m1_.audio_file AS audio_file_16,
m1_.uuid AS uuid_17,
m1_.length AS length_18,
m1_.depth AS depth_19,
m1_.height AS height_20,
m1_.weight AS weight_21,
m1_.product_material AS product_material_22,
m1_.product_color AS product_color_23,
m1_.product_suggestion AS product_suggestion_24,
m1_.product_paint_type AS product_paint_type_25,
m1_.delivery_time AS delivery_time_26,
m1_.created_at AS created_at_27,
m1_.updated_at AS updated_at_28,
m1_.is_jewel_price AS is_jewel_price_29,
m2_.id AS id_30,
m2_.name AS name_31,
m2_.alias AS alias_32,
m2_.description AS description_33,
m2_.description_long AS description_long_34,
m2_.description_cargo AS description_cargo_35,
m2_.meta_title AS meta_title_36,
m2_.meta_description AS meta_description_37,
m2_.meta_keywords AS meta_keywords_38,
m2_.short_description AS short_description_39,
m0_.id AS id_40,
m0_.original_price AS original_price_41,
m0_.discount_rate AS discount_rate_42,
m0_.sales_price AS sales_price_43,
m0_.created_at AS created_at_44,
m0_.updated_at AS updated_at_45,
m3_.id AS id_46,
m3_.stock AS stock_47,
m3_.is_tracked AS is_tracked_48,
m3_.is_default AS is_default_49,
m3_.created_at AS created_at_50,
m3_.updated_at AS updated_at_51
FROM
main_products m1_
LEFT JOIN main_product_lang m2_ ON m1_.id = m2_.product_id
LEFT JOIN sys_langs s4_ ON m2_.lang_id = s4_.id
LEFT JOIN main_categories m5_ ON m1_.main_category_id = m5_.id
LEFT JOIN main_product_other_categories m6_ ON m1_.id = m6_.product_id
LEFT JOIN main_categories m7_ ON m6_.category_id = m7_.id
LEFT JOIN main_product_pricing m0_ ON m1_.id = m0_.product_id
LEFT JOIN main_product_variants m3_ ON m0_.product_variant_id = m3_.id
WHERE
m0_.id > 0
AND s4_.id = ?
AND (
(
m5_.id IN (?, ?, ?, ?)
OR m7_.id IN (?, ?, ?, ?)
)
)
AND m1_.is_enabled = 1
AND m1_.del = 0
AND (
(
m5_.id IN (?, ?, ?, ?)
OR m7_.id IN (?, ?, ?, ?)
)
)
GROUP BY
m1_.id,
m2_.id,
m0_.id,
m6_.id
ORDER BY
MIN(m0_.sales_price) DESC
SELECT MIN(m0_.sales_price) AS sclr_0, MAX(m0_.sales_price) AS sclr_1, m1_.id AS id_2, m1_.code AS code_3, m1_.sira AS sira_4, m1_.barcode AS barcode_5, m1_.product_code AS product_code_6, m1_.is_enabled AS is_enabled_7, m1_.del AS del_8, m1_.new_product AS new_product_9, m1_.show_home AS show_home_10, m1_.is_variant AS is_variant_11, m1_.avarage_rating AS avarage_rating_12, m1_.total_visited AS total_visited_13, m1_.position AS position_14, m1_.total_sales AS total_sales_15, m1_.audio_file AS audio_file_16, m1_.uuid AS uuid_17, m1_.length AS length_18, m1_.depth AS depth_19, m1_.height AS height_20, m1_.weight AS weight_21, m1_.product_material AS product_material_22, m1_.product_color AS product_color_23, m1_.product_suggestion AS product_suggestion_24, m1_.product_paint_type AS product_paint_type_25, m1_.delivery_time AS delivery_time_26, m1_.created_at AS created_at_27, m1_.updated_at AS updated_at_28, m1_.is_jewel_price AS is_jewel_price_29, m2_.id AS id_30, m2_.name AS name_31, m2_.alias AS alias_32, m2_.description AS description_33, m2_.description_long AS description_long_34, m2_.description_cargo AS description_cargo_35, m2_.meta_title AS meta_title_36, m2_.meta_description AS meta_description_37, m2_.meta_keywords AS meta_keywords_38, m2_.short_description AS short_description_39, m0_.id AS id_40, m0_.original_price AS original_price_41, m0_.discount_rate AS discount_rate_42, m0_.sales_price AS sales_price_43, m0_.created_at AS created_at_44, m0_.updated_at AS updated_at_45, m3_.id AS id_46, m3_.stock AS stock_47, m3_.is_tracked AS is_tracked_48, m3_.is_default AS is_default_49, m3_.created_at AS created_at_50, m3_.updated_at AS updated_at_51 FROM main_products m1_ LEFT JOIN main_product_lang m2_ ON m1_.id = m2_.product_id LEFT JOIN sys_langs s4_ ON m2_.lang_id = s4_.id LEFT JOIN main_categories m5_ ON m1_.main_category_id = m5_.id LEFT JOIN main_product_other_categories m6_ ON m1_.id = m6_.product_id LEFT JOIN main_categories m7_ ON m6_.category_id = m7_.id LEFT JOIN main_product_pricing m0_ ON m1_.id = m0_.product_id LEFT JOIN main_product_variants m3_ ON m0_.product_variant_id = m3_.id WHERE m0_.id > 0 AND s4_.id = 1 AND ((m5_.id IN (52, 53, 55, 45) OR m7_.id IN (52, 53, 55, 45))) AND m1_.is_enabled = 1 AND m1_.del = 0 AND ((m5_.id IN (52, 53, 55, 45) OR m7_.id IN (52, 53, 55, 45))) GROUP BY m1_.id, m2_.id, m0_.id, m6_.id ORDER BY MIN(m0_.sales_price) DESC;
|
3.26 ms
(1.97%)
|
4 |
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;
|
2.90 ms
(1.76%)
|
5 |
SELECT t0.id AS id_1, t0.is_enabled AS is_enabled_2, t0.name AS name_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM main_thema t0 WHERE t0.is_enabled = ? LIMIT 1
SELECT t0.id AS id_1, t0.is_enabled AS is_enabled_2, t0.name AS name_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM main_thema t0 WHERE t0.is_enabled = 1 LIMIT 1;
|
2.59 ms
(1.57%)
|
1 |
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
Parameters: [
1
52
53
55
45
52
53
55
45
52
53
55
45
52
53
55
45
]
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;
|
2.07 ms
(1.25%)
|
3 |
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;
|
2.06 ms
(1.25%)
|
2 |
SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.is_enabled AS is_enabled_2, m1_.name AS name_3, m2_.filename AS filename_4, m0_.image AS image_5, m1_.alias AS alias_6, m1_.meta_description AS meta_description_7, m3_.id AS id_8 FROM main_categories m0_ LEFT JOIN main_categories m3_ ON m0_.parent_category_id = m3_.id LEFT JOIN main_category_lang m1_ ON m0_.id = m1_.category_id LEFT JOIN main_category_images m2_ ON m0_.id = m2_.category_id WHERE m0_.del = 0 AND m0_.del = ? AND m1_.lang_id = ? AND m3_.id IS NULL AND m0_.is_enabled = 1 ORDER BY m0_.position ASC
SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.is_enabled AS is_enabled_2, m1_.name AS name_3, m2_.filename AS filename_4, m0_.image AS image_5, m1_.alias AS alias_6, m1_.meta_description AS meta_description_7, m3_.id AS id_8 FROM main_categories m0_ LEFT JOIN main_categories m3_ ON m0_.parent_category_id = m3_.id LEFT JOIN main_category_lang m1_ ON m0_.id = m1_.category_id LEFT JOIN main_category_images m2_ ON m0_.id = m2_.category_id WHERE m0_.del = 0 AND m0_.del = 0 AND m1_.lang_id = 1 AND m3_.id IS NULL AND m0_.is_enabled = 1 ORDER BY m0_.position ASC;
|
1.20 ms
(0.73%)
|
1 |
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;
|
1.10 ms
(0.67%)
|
1 |
SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.is_enabled AS is_enabled_2, m1_.name AS name_3, m2_.filename AS filename_4, m0_.image AS image_5, m1_.alias AS alias_6, m1_.meta_description AS meta_description_7, m3_.id AS id_8 FROM main_categories m0_ LEFT JOIN main_categories m3_ ON m0_.parent_category_id = m3_.id LEFT JOIN main_category_lang m1_ ON m0_.id = m1_.category_id LEFT JOIN main_category_images m2_ ON m0_.id = m2_.category_id WHERE m0_.del = 0 AND m1_.lang_id = ? AND m3_.id IS NULL ORDER BY m0_.position ASC
SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.is_enabled AS is_enabled_2, m1_.name AS name_3, m2_.filename AS filename_4, m0_.image AS image_5, m1_.alias AS alias_6, m1_.meta_description AS meta_description_7, m3_.id AS id_8 FROM main_categories m0_ LEFT JOIN main_categories m3_ ON m0_.parent_category_id = m3_.id LEFT JOIN main_category_lang m1_ ON m0_.id = m1_.category_id LEFT JOIN main_category_images m2_ ON m0_.id = m2_.category_id WHERE m0_.del = 0 AND m1_.lang_id = 1 AND m3_.id IS NULL ORDER BY m0_.position ASC;
|
0.78 ms
(0.47%)
|
1 |
SELECT t0.id AS id_1, t0.system_mail AS system_mail_2, t0.system_phone AS system_phone_3, t0.system_instagram AS system_instagram_4, t0.system_linkedin AS system_linkedin_5, t0.system_youtube AS system_youtube_6, t0.system_pinterest AS system_pinterest_7, t0.google_analystic_code AS google_analystic_code_8, t0.monthly_order_target AS monthly_order_target_9, t0.yearly_order_target AS yearly_order_target_10, t0.logo AS logo_11, t0.logo_sabit_menu AS logo_sabit_menu_12, t0.logo_footer AS logo_footer_13, t0.favicon AS favicon_14, t0.free_shipping_limit AS free_shipping_limit_15, t0.cargo_price AS cargo_price_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18 FROM main_setting_global_settings t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.system_mail AS system_mail_2, t0.system_phone AS system_phone_3, t0.system_instagram AS system_instagram_4, t0.system_linkedin AS system_linkedin_5, t0.system_youtube AS system_youtube_6, t0.system_pinterest AS system_pinterest_7, t0.google_analystic_code AS google_analystic_code_8, t0.monthly_order_target AS monthly_order_target_9, t0.yearly_order_target AS yearly_order_target_10, t0.logo AS logo_11, t0.logo_sabit_menu AS logo_sabit_menu_12, t0.logo_footer AS logo_footer_13, t0.favicon AS favicon_14, t0.free_shipping_limit AS free_shipping_limit_15, t0.cargo_price AS cargo_price_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18 FROM main_setting_global_settings t0 WHERE t0.id = 1;
|
0.75 ms
(0.45%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.meta_description AS meta_description_4, t0.meta_baslik AS meta_baslik_5, t0.meta_keywords AS meta_keywords_6, t0.description AS description_7, t0.category_id AS category_id_8, t0.lang_id AS lang_id_9 FROM main_category_lang t0 WHERE t0.lang_id = ? AND t0.category_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.meta_description AS meta_description_4, t0.meta_baslik AS meta_baslik_5, t0.meta_keywords AS meta_keywords_6, t0.description AS description_7, t0.category_id AS category_id_8, t0.lang_id AS lang_id_9 FROM main_category_lang t0 WHERE t0.lang_id = 1 AND t0.category_id = 45 LIMIT 1;
|
0.73 ms
(0.44%)
|
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';
|
0.68 ms
(0.41%)
|
1 |
SELECT t0.id AS id_1, t0.alias AS alias_2, t0.page_id AS page_id_3, t0.section_id AS section_id_4 FROM main_page_sections t0 WHERE t0.section_id IS NULL
SELECT t0.id AS id_1, t0.alias AS alias_2, t0.page_id AS page_id_3, t0.section_id AS section_id_4 FROM main_page_sections t0 WHERE t0.section_id IS NULL;
|
0.65 ms
(0.40%)
|
1 |
SELECT t0.id AS id_1, t0.baslama_tarihi AS baslama_tarihi_2, t0.bitis_tarihi AS bitis_tarihi_3, t0.alan_adi AS alan_adi_4, t0.tip_alias AS tip_alias_5, t0.tema_id AS tema_id_6, t0.abone_paket_id AS abone_paket_id_7 FROM firma_site_ayar t0 LIMIT 1
SELECT t0.id AS id_1, t0.baslama_tarihi AS baslama_tarihi_2, t0.bitis_tarihi AS bitis_tarihi_3, t0.alan_adi AS alan_adi_4, t0.tip_alias AS tip_alias_5, t0.tema_id AS tema_id_6, t0.abone_paket_id AS abone_paket_id_7 FROM firma_site_ayar t0 LIMIT 1;
|
0.65 ms
(0.40%)
|
1 |
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_slogan AS meta_slogan_3, t0.meta_description AS meta_description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.glabal_setting_id AS glabal_setting_id_7, t0.lang_id AS lang_id_8 FROM main_setting_global_setting_langs t0 WHERE t0.glabal_setting_id = ?
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_slogan AS meta_slogan_3, t0.meta_description AS meta_description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.glabal_setting_id AS glabal_setting_id_7, t0.lang_id AS lang_id_8 FROM main_setting_global_setting_langs t0 WHERE t0.glabal_setting_id = 1;
|
0.60 ms
(0.37%)
|
1 |
SELECT t0.id AS id_1, t0.alias AS alias_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM main_pages t0
SELECT t0.id AS id_1, t0.alias AS alias_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM main_pages t0;
|