| 1 |
1.44 ms |
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;
|
| 2 |
0.68 ms |
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;
|
| 3 |
0.93 ms |
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 = ?
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';
|
| 4 |
0.35 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 5 |
0.61 ms |
UPDATE main_products SET total_visited = ? WHERE id = ?
UPDATE main_products SET total_visited = 9 WHERE id = 6;
|
| 6 |
1.20 ms |
"COMMIT"
|
| 7 |
0.81 ms |
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.del = ?
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.del = 0;
|
| 8 |
0.49 ms |
SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.simular_product_id AS simular_product_id_3 FROM main_simular_products t0
SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.simular_product_id AS simular_product_id_3 FROM main_simular_products t0;
|
| 9 |
0.48 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.resim AS resim_3, t0.taksit1 AS taksit1_4, t0.taksit2 AS taksit2_5, t0.taksit3 AS taksit3_6, t0.taksit6 AS taksit6_7, t0.taksit9 AS taksit9_8, t0.taksit12 AS taksit12_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM main_credit_card t0
SELECT t0.id AS id_1, t0.title AS title_2, t0.resim AS resim_3, t0.taksit1 AS taksit1_4, t0.taksit2 AS taksit2_5, t0.taksit3 AS taksit3_6, t0.taksit6 AS taksit6_7, t0.taksit9 AS taksit9_8, t0.taksit12 AS taksit12_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM main_credit_card t0;
|
| 10 |
0.59 ms |
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.id = ? LIMIT 1
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.id = 11 LIMIT 1;
|
| 11 |
0.47 ms |
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.id = ? LIMIT 1
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.id = 21 LIMIT 1;
|
| 12 |
0.66 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.comment AS comment_3, t0.rating AS rating_4, t0.is_enabled AS is_enabled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.product_id AS product_id_8, t0.user_id AS user_id_9 FROM main_product_reviews t0 WHERE t0.is_enabled = ? AND t0.product_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.comment AS comment_3, t0.rating AS rating_4, t0.is_enabled AS is_enabled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.product_id AS product_id_8, t0.user_id AS user_id_9 FROM main_product_reviews t0 WHERE t0.is_enabled = 1 AND t0.product_id = 6;
|
| 13 |
0.47 ms |
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;
|
| 14 |
0.32 ms |
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;
|
| 15 |
0.37 ms |
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;
|
| 16 |
0.71 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.description AS description_4, t0.description_long AS description_long_5, t0.description_cargo AS description_cargo_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.meta_keywords AS meta_keywords_9, t0.short_description AS short_description_10, t0.product_id AS product_id_11, t0.lang_id AS lang_id_12 FROM main_product_lang t0 WHERE t0.lang_id = ? AND t0.product_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.description AS description_4, t0.description_long AS description_long_5, t0.description_cargo AS description_cargo_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.meta_keywords AS meta_keywords_9, t0.short_description AS short_description_10, t0.product_id AS product_id_11, t0.lang_id AS lang_id_12 FROM main_product_lang t0 WHERE t0.lang_id = 1 AND t0.product_id = 6 LIMIT 1;
|
| 17 |
0.64 ms |
SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.comment AS comment_2, m0_.rating AS rating_3, m0_.is_enabled AS is_enabled_4, m0_.created_at AS created_at_5, m0_.updated_at AS updated_at_6, m0_.product_id AS product_id_7, m0_.user_id AS user_id_8 FROM main_product_reviews m0_ LEFT JOIN main_products m1_ ON m0_.product_id = m1_.id WHERE m1_.id = ? AND m0_.is_enabled = 1 ORDER BY m0_.id DESC
SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.comment AS comment_2, m0_.rating AS rating_3, m0_.is_enabled AS is_enabled_4, m0_.created_at AS created_at_5, m0_.updated_at AS updated_at_6, m0_.product_id AS product_id_7, m0_.user_id AS user_id_8 FROM main_product_reviews m0_ LEFT JOIN main_products m1_ ON m0_.product_id = m1_.id WHERE m1_.id = 6 AND m0_.is_enabled = 1 ORDER BY m0_.id DESC;
|
| 18 |
0.53 ms |
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;
|
| 19 |
0.66 ms |
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;
|
| 20 |
0.42 ms |
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;
|
| 21 |
0.48 ms |
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;
|
| 22 |
0.49 ms |
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;
|
| 23 |
0.43 ms |
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;
|
| 24 |
0.38 ms |
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;
|
| 25 |
0.85 ms |
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;
|
| 26 |
0.40 ms |
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;
|
| 27 |
0.47 ms |
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;
|
| 28 |
0.67 ms |
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;
|
| 29 |
0.41 ms |
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;
|
| 30 |
0.55 ms |
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
52
1
52
]
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 = 52 AND m1_.lang_id = 1 AND m0_.is_enabled = 1 AND m0_.parent_category_id = 52 ORDER BY m0_.position ASC;
|
| 31 |
0.39 ms |
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;
|
| 32 |
0.54 ms |
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
53
1
53
]
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 = 53 AND m1_.lang_id = 1 AND m0_.is_enabled = 1 AND m0_.parent_category_id = 53 ORDER BY m0_.position ASC;
|
| 33 |
0.43 ms |
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;
|
| 34 |
0.55 ms |
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
55
1
55
]
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 = 55 AND m1_.lang_id = 1 AND m0_.is_enabled = 1 AND m0_.parent_category_id = 55 ORDER BY m0_.position ASC;
|
| 35 |
0.40 ms |
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;
|
| 36 |
0.62 ms |
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
54
1
54
]
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 = 54 AND m1_.lang_id = 1 AND m0_.is_enabled = 1 AND m0_.parent_category_id = 54 ORDER BY m0_.position ASC;
|
| 37 |
0.34 ms |
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;
|
| 38 |
0.48 ms |
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
46
1
46
]
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 = 46 AND m1_.lang_id = 1 AND m0_.is_enabled = 1 AND m0_.parent_category_id = 46 ORDER BY m0_.position ASC;
|
| 39 |
0.35 ms |
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;
|
| 40 |
0.54 ms |
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
47
1
47
]
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 = 47 AND m1_.lang_id = 1 AND m0_.is_enabled = 1 AND m0_.parent_category_id = 47 ORDER BY m0_.position ASC;
|
| 41 |
0.43 ms |
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;
|
| 42 |
0.64 ms |
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
48
1
48
]
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 = 48 AND m1_.lang_id = 1 AND m0_.is_enabled = 1 AND m0_.parent_category_id = 48 ORDER BY m0_.position ASC;
|
| 43 |
0.28 ms |
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;
|
| 44 |
0.39 ms |
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
49
1
49
]
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 = 49 AND m1_.lang_id = 1 AND m0_.is_enabled = 1 AND m0_.parent_category_id = 49 ORDER BY m0_.position ASC;
|
| 45 |
0.27 ms |
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;
|
| 46 |
0.39 ms |
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
50
1
50
]
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 = 50 AND m1_.lang_id = 1 AND m0_.is_enabled = 1 AND m0_.parent_category_id = 50 ORDER BY m0_.position ASC;
|
| 47 |
0.27 ms |
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;
|
| 48 |
0.40 ms |
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
51
1
51
]
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 = 51 AND m1_.lang_id = 1 AND m0_.is_enabled = 1 AND m0_.parent_category_id = 51 ORDER BY m0_.position ASC;
|
| 49 |
0.26 ms |
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;
|
| 50 |
0.48 ms |
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;
|
| 51 |
0.25 ms |
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;
|
| 52 |
0.44 ms |
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;
|
| 53 |
0.26 ms |
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;
|
| 54 |
0.44 ms |
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
54
1
54
]
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 = 54 AND m1_.lang_id = 1 AND m0_.parent_category_id = 54 ORDER BY m0_.position ASC;
|
| 55 |
0.53 ms |
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 = 52 ORDER BY m0_.position ASC;
|
| 56 |
0.47 ms |
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;
|
| 57 |
0.26 ms |
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;
|
| 58 |
0.31 ms |
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;
|
| 59 |
0.29 ms |
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;
|
| 60 |
0.41 ms |
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 = 52 LIMIT 1;
|
| 61 |
0.41 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.is_default AS is_default_3, t0.filename AS filename_4, t0.filesize AS filesize_5, t0.alt AS alt_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.product_id AS product_id_9 FROM main_product_images t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.is_default AS is_default_3, t0.filename AS filename_4, t0.filesize AS filesize_5, t0.alt AS alt_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.product_id AS product_id_9 FROM main_product_images t0 WHERE t0.product_id = 6;
|
| 62 |
0.57 ms |
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;
|
| 63 |
0.36 ms |
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;
|
| 64 |
0.32 ms |
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;
|
| 65 |
0.71 ms |
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;
|
| 66 |
0.33 ms |
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.product_variant_id = ?
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.product_variant_id = 6;
|
| 67 |
0.30 ms |
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;
|
| 68 |
0.31 ms |
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;
|
| 69 |
0.33 ms |
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;
|
| 70 |
0.27 ms |
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;
|
| 71 |
0.31 ms |
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;
|
| 72 |
0.43 ms |
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 = 52 ORDER BY m0_.position ASC;
|
| 73 |
0.40 ms |
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;
|
| 74 |
0.28 ms |
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;
|
| 75 |
0.34 ms |
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;
|
| 76 |
0.26 ms |
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;
|
| 77 |
0.33 ms |
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 = 52 LIMIT 1;
|
| 78 |
0.29 ms |
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;
|
| 79 |
0.53 ms |
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;
|
| 80 |
0.49 ms |
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;
|
| 81 |
0.38 ms |
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;
|
| 82 |
0.41 ms |
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;
|
| 83 |
0.37 ms |
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;
|
| 84 |
1.53 ms |
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_ INNER JOIN main_product_lang m1_ ON m0_.id = m1_.product_id INNER 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 LEFT JOIN sys_currencies s8_ ON m6_.currency_id = s8_.id WHERE s2_.id = ? AND (m3_.id IN (?) OR m5_.id IN (?)) AND s8_.id = ? AND m0_.is_enabled = 1 AND m0_.del = 0 GROUP BY m0_.id, m1_.id, m6_.id, m7_.id ORDER BY m0_.position ASC LIMIT 8
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_ INNER JOIN main_product_lang m1_ ON m0_.id = m1_.product_id INNER 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 LEFT JOIN sys_currencies s8_ ON m6_.currency_id = s8_.id WHERE s2_.id = 1 AND (m3_.id IN (2) OR m5_.id IN (2)) AND s8_.id = 1 AND m0_.is_enabled = 1 AND m0_.del = 0 GROUP BY m0_.id, m1_.id, m6_.id, m7_.id ORDER BY m0_.position ASC LIMIT 8;
|
| 85 |
1.90 ms |
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, m3_.id AS id_40, m3_.code AS code_41, m3_.position AS position_42, m3_.is_enabled AS is_enabled_43, m3_.del AS del_44, m3_.show_home AS show_home_45, m3_.image AS image_46, m3_.created_at AS created_at_47, m3_.updated_at AS updated_at_48, m0_.id AS id_49, m0_.original_price AS original_price_50, m0_.discount_rate AS discount_rate_51, m0_.sales_price AS sales_price_52, m0_.created_at AS created_at_53, m0_.updated_at AS updated_at_54, m4_.id AS id_55, m4_.stock AS stock_56, m4_.is_tracked AS is_tracked_57, m4_.is_default AS is_default_58, m4_.created_at AS created_at_59, m4_.updated_at AS updated_at_60 FROM main_products m1_ INNER JOIN main_product_lang m2_ ON m1_.id = m2_.product_id INNER JOIN sys_langs s5_ ON m2_.lang_id = s5_.id LEFT JOIN main_categories m3_ ON m1_.main_category_id = m3_.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 m4_ ON m0_.product_variant_id = m4_.id LEFT JOIN sys_currencies s8_ ON m0_.currency_id = s8_.id WHERE s5_.id = ? AND (m3_.id IN (?) OR m7_.id IN (?)) AND s8_.id = ? AND m1_.is_enabled = 1 AND m1_.del = 0 GROUP BY m1_.id, m2_.id, m0_.id, m4_.id ORDER BY m1_.position ASC LIMIT 8
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,
m3_.id AS id_40,
m3_.code AS code_41,
m3_.position AS position_42,
m3_.is_enabled AS is_enabled_43,
m3_.del AS del_44,
m3_.show_home AS show_home_45,
m3_.image AS image_46,
m3_.created_at AS created_at_47,
m3_.updated_at AS updated_at_48,
m0_.id AS id_49,
m0_.original_price AS original_price_50,
m0_.discount_rate AS discount_rate_51,
m0_.sales_price AS sales_price_52,
m0_.created_at AS created_at_53,
m0_.updated_at AS updated_at_54,
m4_.id AS id_55,
m4_.stock AS stock_56,
m4_.is_tracked AS is_tracked_57,
m4_.is_default AS is_default_58,
m4_.created_at AS created_at_59,
m4_.updated_at AS updated_at_60
FROM
main_products m1_
INNER JOIN main_product_lang m2_ ON m1_.id = m2_.product_id
INNER JOIN sys_langs s5_ ON m2_.lang_id = s5_.id
LEFT JOIN main_categories m3_ ON m1_.main_category_id = m3_.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 m4_ ON m0_.product_variant_id = m4_.id
LEFT JOIN sys_currencies s8_ ON m0_.currency_id = s8_.id
WHERE
s5_.id = ?
AND (
m3_.id IN (?)
OR m7_.id IN (?)
)
AND s8_.id = ?
AND m1_.is_enabled = 1
AND m1_.del = 0
GROUP BY
m1_.id,
m2_.id,
m0_.id,
m4_.id
ORDER BY
m1_.position ASC
LIMIT
8
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, m3_.id AS id_40, m3_.code AS code_41, m3_.position AS position_42, m3_.is_enabled AS is_enabled_43, m3_.del AS del_44, m3_.show_home AS show_home_45, m3_.image AS image_46, m3_.created_at AS created_at_47, m3_.updated_at AS updated_at_48, m0_.id AS id_49, m0_.original_price AS original_price_50, m0_.discount_rate AS discount_rate_51, m0_.sales_price AS sales_price_52, m0_.created_at AS created_at_53, m0_.updated_at AS updated_at_54, m4_.id AS id_55, m4_.stock AS stock_56, m4_.is_tracked AS is_tracked_57, m4_.is_default AS is_default_58, m4_.created_at AS created_at_59, m4_.updated_at AS updated_at_60 FROM main_products m1_ INNER JOIN main_product_lang m2_ ON m1_.id = m2_.product_id INNER JOIN sys_langs s5_ ON m2_.lang_id = s5_.id LEFT JOIN main_categories m3_ ON m1_.main_category_id = m3_.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 m4_ ON m0_.product_variant_id = m4_.id LEFT JOIN sys_currencies s8_ ON m0_.currency_id = s8_.id WHERE s5_.id = 1 AND (m3_.id IN (2) OR m7_.id IN (2)) AND s8_.id = 1 AND m1_.is_enabled = 1 AND m1_.del = 0 GROUP BY m1_.id, m2_.id, m0_.id, m4_.id ORDER BY m1_.position ASC LIMIT 8;
|
| 86 |
0.45 ms |
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;
|
| 87 |
0.69 ms |
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;
|
| 88 |
0.63 ms |
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;
|
| 89 |
0.60 ms |
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;
|
| 90 |
0.57 ms |
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;
|
| 91 |
0.54 ms |
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;
|
| 92 |
0.63 ms |
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 = 2;
|
| 93 |
0.50 ms |
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 = 3;
|
| 94 |
0.47 ms |
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 = 4;
|
| 95 |
0.48 ms |
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 = 5;
|
| 96 |
0.44 ms |
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 = 6;
|
| 97 |
0.46 ms |
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 = 7;
|
| 98 |
0.45 ms |
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 = 8;
|
| 99 |
0.59 ms |
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;
|