| 1 |
1.94 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.76 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.83 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;
|
| 4 |
0.74 ms |
SELECT t0.id AS id_1, t0.image AS image_2, t0.filesize AS filesize_3, t0.del AS del_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM main_product_catalogs t0 WHERE t0.del = ?
SELECT t0.id AS id_1, t0.image AS image_2, t0.filesize AS filesize_3, t0.del AS del_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM main_product_catalogs t0 WHERE t0.del = 0;
|
| 5 |
0.50 ms |
SELECT t0.id AS id_1, t0.image AS image_2, t0.filesize AS filesize_3, t0.del AS del_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM main_product_catalogs t0 WHERE t0.del = ?
SELECT t0.id AS id_1, t0.image AS image_2, t0.filesize AS filesize_3, t0.del AS del_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM main_product_catalogs t0 WHERE t0.del = 0;
|
| 6 |
0.94 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.del AS del_5, t0.is_enabled AS is_enabled_6, t0.private AS private_7, t0.show_home AS show_home_8, t0.all_products AS all_products_9, t0.start_date AS start_date_10, t0.end_date AS end_date_11, t0.min_price AS min_price_12, t0.buy_by AS buy_by_13, t0.pay_by AS pay_by_14, t0.th_order AS th_order_15, t0.percent_discount AS percent_discount_16, t0.discount_amount AS discount_amount_17, t0.free_shipping AS free_shipping_18, t0.campaign_type_id AS campaign_type_id_19 FROM main_campaign t0 WHERE t0.del = ? AND t0.show_home = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.del AS del_5, t0.is_enabled AS is_enabled_6, t0.private AS private_7, t0.show_home AS show_home_8, t0.all_products AS all_products_9, t0.start_date AS start_date_10, t0.end_date AS end_date_11, t0.min_price AS min_price_12, t0.buy_by AS buy_by_13, t0.pay_by AS pay_by_14, t0.th_order AS th_order_15, t0.percent_discount AS percent_discount_16, t0.discount_amount AS discount_amount_17, t0.free_shipping AS free_shipping_18, t0.campaign_type_id AS campaign_type_id_19 FROM main_campaign t0 WHERE t0.del = 0 AND t0.show_home = 1;
|
| 7 |
0.79 ms |
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.del = ? AND t0.show_home = ?
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.del = 0 AND t0.show_home = 1;
|
| 8 |
0.73 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.file_name AS file_name_5 FROM main_pop_up t0 ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.position AS position_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.file_name AS file_name_5 FROM main_pop_up t0 ORDER BY t0.position ASC;
|
| 9 |
0.70 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;
|
| 10 |
0.63 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;
|
| 11 |
0.90 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;
|
| 12 |
0.82 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;
|
| 13 |
0.63 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.id = ?
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.id = 1;
|
| 14 |
0.63 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;
|
| 15 |
1.36 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;
|
| 16 |
0.68 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;
|
| 17 |
0.64 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;
|
| 18 |
0.71 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;
|
| 19 |
0.65 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;
|
| 20 |
0.65 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.62 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;
|
| 22 |
1.10 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;
|
| 23 |
0.55 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.53 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 |
1.03 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;
|
| 26 |
0.60 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;
|
| 27 |
0.77 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;
|
| 28 |
0.49 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;
|
| 29 |
0.80 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;
|
| 30 |
0.51 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;
|
| 31 |
0.80 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;
|
| 32 |
0.48 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;
|
| 33 |
0.90 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;
|
| 34 |
0.51 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;
|
| 35 |
0.76 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;
|
| 36 |
0.48 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;
|
| 37 |
0.77 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;
|
| 38 |
0.55 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;
|
| 39 |
0.80 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;
|
| 40 |
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;
|
| 41 |
0.72 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;
|
| 42 |
0.49 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;
|
| 43 |
0.74 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;
|
| 44 |
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;
|
| 45 |
0.71 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;
|
| 46 |
0.49 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;
|
| 47 |
0.92 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;
|
| 48 |
0.49 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;
|
| 49 |
0.91 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;
|
| 50 |
0.50 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;
|
| 51 |
0.90 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;
|
| 52 |
0.68 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;
|
| 53 |
2.51 ms |
SELECT m0_.id AS id_0, m0_.uuid AS uuid_1, m0_.alias AS alias_2, m0_.is_enabled AS is_enabled_3, m0_.position AS position_4, m0_.link AS link_5, m0_.image_file AS image_file_6, m0_.video_file AS video_file_7, m0_.mobile_image AS mobile_image_8, m0_.created_at AS created_at_9, m0_.updated_at AS updated_at_10, m1_.id AS id_11, m1_.title1 AS title1_12, m1_.title2 AS title2_13, m1_.description AS description_14, m1_.created_at AS created_at_15, m1_.updated_at AS updated_at_16, m2_.id AS id_17, m2_.title AS title_18, m2_.alias AS alias_19, m2_.image_size AS image_size_20, m2_.mobil_image_size AS mobil_image_size_21, m2_.is_mobile_image AS is_mobile_image_22, m2_.is_video AS is_video_23, m2_.created_at AS created_at_24, m2_.updated_at AS updated_at_25, m3_.id AS id_26, m3_.code AS code_27, m3_.sira AS sira_28, m3_.barcode AS barcode_29, m3_.product_code AS product_code_30, m3_.is_enabled AS is_enabled_31, m3_.del AS del_32, m3_.new_product AS new_product_33, m3_.show_home AS show_home_34, m3_.is_variant AS is_variant_35, m3_.avarage_rating AS avarage_rating_36, m3_.total_visited AS total_visited_37, m3_.position AS position_38, m3_.total_sales AS total_sales_39, m3_.audio_file AS audio_file_40, m3_.uuid AS uuid_41, m3_.length AS length_42, m3_.depth AS depth_43, m3_.height AS height_44, m3_.weight AS weight_45, m3_.product_material AS product_material_46, m3_.product_color AS product_color_47, m3_.product_suggestion AS product_suggestion_48, m3_.product_paint_type AS product_paint_type_49, m3_.delivery_time AS delivery_time_50, m3_.created_at AS created_at_51, m3_.updated_at AS updated_at_52, m3_.is_jewel_price AS is_jewel_price_53, m0_.banner_group_id AS banner_group_id_54, m0_.product_id AS product_id_55, m1_.banner_id AS banner_id_56, m1_.lang_id AS lang_id_57, m3_.brand_id AS brand_id_58, m3_.main_category_id AS main_category_id_59, m3_.blog_id AS blog_id_60 FROM main_banners m0_ LEFT JOIN main_banner_langs m1_ ON m0_.id = m1_.banner_id LEFT JOIN sys_langs s4_ ON m1_.lang_id = s4_.id LEFT JOIN main_banner_groups m2_ ON m0_.banner_group_id = m2_.id LEFT JOIN main_products m3_ ON m0_.product_id = m3_.id WHERE s4_.id = ? AND m2_.alias = ? ORDER BY m0_.position ASC
Parameters: [
1
"slider"
]
SELECT
m0_.id AS id_0,
m0_.uuid AS uuid_1,
m0_.alias AS alias_2,
m0_.is_enabled AS is_enabled_3,
m0_.position AS position_4,
m0_.link AS link_5,
m0_.image_file AS image_file_6,
m0_.video_file AS video_file_7,
m0_.mobile_image AS mobile_image_8,
m0_.created_at AS created_at_9,
m0_.updated_at AS updated_at_10,
m1_.id AS id_11,
m1_.title1 AS title1_12,
m1_.title2 AS title2_13,
m1_.description AS description_14,
m1_.created_at AS created_at_15,
m1_.updated_at AS updated_at_16,
m2_.id AS id_17,
m2_.title AS title_18,
m2_.alias AS alias_19,
m2_.image_size AS image_size_20,
m2_.mobil_image_size AS mobil_image_size_21,
m2_.is_mobile_image AS is_mobile_image_22,
m2_.is_video AS is_video_23,
m2_.created_at AS created_at_24,
m2_.updated_at AS updated_at_25,
m3_.id AS id_26,
m3_.code AS code_27,
m3_.sira AS sira_28,
m3_.barcode AS barcode_29,
m3_.product_code AS product_code_30,
m3_.is_enabled AS is_enabled_31,
m3_.del AS del_32,
m3_.new_product AS new_product_33,
m3_.show_home AS show_home_34,
m3_.is_variant AS is_variant_35,
m3_.avarage_rating AS avarage_rating_36,
m3_.total_visited AS total_visited_37,
m3_.position AS position_38,
m3_.total_sales AS total_sales_39,
m3_.audio_file AS audio_file_40,
m3_.uuid AS uuid_41,
m3_.length AS length_42,
m3_.depth AS depth_43,
m3_.height AS height_44,
m3_.weight AS weight_45,
m3_.product_material AS product_material_46,
m3_.product_color AS product_color_47,
m3_.product_suggestion AS product_suggestion_48,
m3_.product_paint_type AS product_paint_type_49,
m3_.delivery_time AS delivery_time_50,
m3_.created_at AS created_at_51,
m3_.updated_at AS updated_at_52,
m3_.is_jewel_price AS is_jewel_price_53,
m0_.banner_group_id AS banner_group_id_54,
m0_.product_id AS product_id_55,
m1_.banner_id AS banner_id_56,
m1_.lang_id AS lang_id_57,
m3_.brand_id AS brand_id_58,
m3_.main_category_id AS main_category_id_59,
m3_.blog_id AS blog_id_60
FROM
main_banners m0_
LEFT JOIN main_banner_langs m1_ ON m0_.id = m1_.banner_id
LEFT JOIN sys_langs s4_ ON m1_.lang_id = s4_.id
LEFT JOIN main_banner_groups m2_ ON m0_.banner_group_id = m2_.id
LEFT JOIN main_products m3_ ON m0_.product_id = m3_.id
WHERE
s4_.id = ?
AND m2_.alias = ?
ORDER BY
m0_.position ASC
SELECT m0_.id AS id_0, m0_.uuid AS uuid_1, m0_.alias AS alias_2, m0_.is_enabled AS is_enabled_3, m0_.position AS position_4, m0_.link AS link_5, m0_.image_file AS image_file_6, m0_.video_file AS video_file_7, m0_.mobile_image AS mobile_image_8, m0_.created_at AS created_at_9, m0_.updated_at AS updated_at_10, m1_.id AS id_11, m1_.title1 AS title1_12, m1_.title2 AS title2_13, m1_.description AS description_14, m1_.created_at AS created_at_15, m1_.updated_at AS updated_at_16, m2_.id AS id_17, m2_.title AS title_18, m2_.alias AS alias_19, m2_.image_size AS image_size_20, m2_.mobil_image_size AS mobil_image_size_21, m2_.is_mobile_image AS is_mobile_image_22, m2_.is_video AS is_video_23, m2_.created_at AS created_at_24, m2_.updated_at AS updated_at_25, m3_.id AS id_26, m3_.code AS code_27, m3_.sira AS sira_28, m3_.barcode AS barcode_29, m3_.product_code AS product_code_30, m3_.is_enabled AS is_enabled_31, m3_.del AS del_32, m3_.new_product AS new_product_33, m3_.show_home AS show_home_34, m3_.is_variant AS is_variant_35, m3_.avarage_rating AS avarage_rating_36, m3_.total_visited AS total_visited_37, m3_.position AS position_38, m3_.total_sales AS total_sales_39, m3_.audio_file AS audio_file_40, m3_.uuid AS uuid_41, m3_.length AS length_42, m3_.depth AS depth_43, m3_.height AS height_44, m3_.weight AS weight_45, m3_.product_material AS product_material_46, m3_.product_color AS product_color_47, m3_.product_suggestion AS product_suggestion_48, m3_.product_paint_type AS product_paint_type_49, m3_.delivery_time AS delivery_time_50, m3_.created_at AS created_at_51, m3_.updated_at AS updated_at_52, m3_.is_jewel_price AS is_jewel_price_53, m0_.banner_group_id AS banner_group_id_54, m0_.product_id AS product_id_55, m1_.banner_id AS banner_id_56, m1_.lang_id AS lang_id_57, m3_.brand_id AS brand_id_58, m3_.main_category_id AS main_category_id_59, m3_.blog_id AS blog_id_60 FROM main_banners m0_ LEFT JOIN main_banner_langs m1_ ON m0_.id = m1_.banner_id LEFT JOIN sys_langs s4_ ON m1_.lang_id = s4_.id LEFT JOIN main_banner_groups m2_ ON m0_.banner_group_id = m2_.id LEFT JOIN main_products m3_ ON m0_.product_id = m3_.id WHERE s4_.id = 1 AND m2_.alias = 'slider' ORDER BY m0_.position ASC;
|
| 54 |
0.63 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;
|
| 55 |
0.72 ms |
SELECT t0.id AS id_1, t0.title1 AS title1_2, t0.title2 AS title2_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.banner_id AS banner_id_7, t0.lang_id AS lang_id_8 FROM main_banner_langs t0 WHERE t0.banner_id = ? AND t0.lang_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.title1 AS title1_2, t0.title2 AS title2_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.banner_id AS banner_id_7, t0.lang_id AS lang_id_8 FROM main_banner_langs t0 WHERE t0.banner_id = 10 AND t0.lang_id = 1 LIMIT 1;
|
| 56 |
0.51 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;
|
| 57 |
1.88 ms |
SELECT m0_.id AS id_0, m0_.uuid AS uuid_1, m0_.alias AS alias_2, m0_.is_enabled AS is_enabled_3, m0_.position AS position_4, m0_.link AS link_5, m0_.image_file AS image_file_6, m0_.video_file AS video_file_7, m0_.mobile_image AS mobile_image_8, m0_.created_at AS created_at_9, m0_.updated_at AS updated_at_10, m1_.id AS id_11, m1_.title1 AS title1_12, m1_.title2 AS title2_13, m1_.description AS description_14, m1_.created_at AS created_at_15, m1_.updated_at AS updated_at_16, m2_.id AS id_17, m2_.title AS title_18, m2_.alias AS alias_19, m2_.image_size AS image_size_20, m2_.mobil_image_size AS mobil_image_size_21, m2_.is_mobile_image AS is_mobile_image_22, m2_.is_video AS is_video_23, m2_.created_at AS created_at_24, m2_.updated_at AS updated_at_25, m3_.id AS id_26, m3_.code AS code_27, m3_.sira AS sira_28, m3_.barcode AS barcode_29, m3_.product_code AS product_code_30, m3_.is_enabled AS is_enabled_31, m3_.del AS del_32, m3_.new_product AS new_product_33, m3_.show_home AS show_home_34, m3_.is_variant AS is_variant_35, m3_.avarage_rating AS avarage_rating_36, m3_.total_visited AS total_visited_37, m3_.position AS position_38, m3_.total_sales AS total_sales_39, m3_.audio_file AS audio_file_40, m3_.uuid AS uuid_41, m3_.length AS length_42, m3_.depth AS depth_43, m3_.height AS height_44, m3_.weight AS weight_45, m3_.product_material AS product_material_46, m3_.product_color AS product_color_47, m3_.product_suggestion AS product_suggestion_48, m3_.product_paint_type AS product_paint_type_49, m3_.delivery_time AS delivery_time_50, m3_.created_at AS created_at_51, m3_.updated_at AS updated_at_52, m3_.is_jewel_price AS is_jewel_price_53, m0_.banner_group_id AS banner_group_id_54, m0_.product_id AS product_id_55, m1_.banner_id AS banner_id_56, m1_.lang_id AS lang_id_57, m3_.brand_id AS brand_id_58, m3_.main_category_id AS main_category_id_59, m3_.blog_id AS blog_id_60 FROM main_banners m0_ LEFT JOIN main_banner_langs m1_ ON m0_.id = m1_.banner_id LEFT JOIN sys_langs s4_ ON m1_.lang_id = s4_.id LEFT JOIN main_banner_groups m2_ ON m0_.banner_group_id = m2_.id LEFT JOIN main_products m3_ ON m0_.product_id = m3_.id WHERE s4_.id = ? AND m2_.alias = ? ORDER BY m0_.position ASC
Parameters: [
1
"banner"
]
SELECT
m0_.id AS id_0,
m0_.uuid AS uuid_1,
m0_.alias AS alias_2,
m0_.is_enabled AS is_enabled_3,
m0_.position AS position_4,
m0_.link AS link_5,
m0_.image_file AS image_file_6,
m0_.video_file AS video_file_7,
m0_.mobile_image AS mobile_image_8,
m0_.created_at AS created_at_9,
m0_.updated_at AS updated_at_10,
m1_.id AS id_11,
m1_.title1 AS title1_12,
m1_.title2 AS title2_13,
m1_.description AS description_14,
m1_.created_at AS created_at_15,
m1_.updated_at AS updated_at_16,
m2_.id AS id_17,
m2_.title AS title_18,
m2_.alias AS alias_19,
m2_.image_size AS image_size_20,
m2_.mobil_image_size AS mobil_image_size_21,
m2_.is_mobile_image AS is_mobile_image_22,
m2_.is_video AS is_video_23,
m2_.created_at AS created_at_24,
m2_.updated_at AS updated_at_25,
m3_.id AS id_26,
m3_.code AS code_27,
m3_.sira AS sira_28,
m3_.barcode AS barcode_29,
m3_.product_code AS product_code_30,
m3_.is_enabled AS is_enabled_31,
m3_.del AS del_32,
m3_.new_product AS new_product_33,
m3_.show_home AS show_home_34,
m3_.is_variant AS is_variant_35,
m3_.avarage_rating AS avarage_rating_36,
m3_.total_visited AS total_visited_37,
m3_.position AS position_38,
m3_.total_sales AS total_sales_39,
m3_.audio_file AS audio_file_40,
m3_.uuid AS uuid_41,
m3_.length AS length_42,
m3_.depth AS depth_43,
m3_.height AS height_44,
m3_.weight AS weight_45,
m3_.product_material AS product_material_46,
m3_.product_color AS product_color_47,
m3_.product_suggestion AS product_suggestion_48,
m3_.product_paint_type AS product_paint_type_49,
m3_.delivery_time AS delivery_time_50,
m3_.created_at AS created_at_51,
m3_.updated_at AS updated_at_52,
m3_.is_jewel_price AS is_jewel_price_53,
m0_.banner_group_id AS banner_group_id_54,
m0_.product_id AS product_id_55,
m1_.banner_id AS banner_id_56,
m1_.lang_id AS lang_id_57,
m3_.brand_id AS brand_id_58,
m3_.main_category_id AS main_category_id_59,
m3_.blog_id AS blog_id_60
FROM
main_banners m0_
LEFT JOIN main_banner_langs m1_ ON m0_.id = m1_.banner_id
LEFT JOIN sys_langs s4_ ON m1_.lang_id = s4_.id
LEFT JOIN main_banner_groups m2_ ON m0_.banner_group_id = m2_.id
LEFT JOIN main_products m3_ ON m0_.product_id = m3_.id
WHERE
s4_.id = ?
AND m2_.alias = ?
ORDER BY
m0_.position ASC
SELECT m0_.id AS id_0, m0_.uuid AS uuid_1, m0_.alias AS alias_2, m0_.is_enabled AS is_enabled_3, m0_.position AS position_4, m0_.link AS link_5, m0_.image_file AS image_file_6, m0_.video_file AS video_file_7, m0_.mobile_image AS mobile_image_8, m0_.created_at AS created_at_9, m0_.updated_at AS updated_at_10, m1_.id AS id_11, m1_.title1 AS title1_12, m1_.title2 AS title2_13, m1_.description AS description_14, m1_.created_at AS created_at_15, m1_.updated_at AS updated_at_16, m2_.id AS id_17, m2_.title AS title_18, m2_.alias AS alias_19, m2_.image_size AS image_size_20, m2_.mobil_image_size AS mobil_image_size_21, m2_.is_mobile_image AS is_mobile_image_22, m2_.is_video AS is_video_23, m2_.created_at AS created_at_24, m2_.updated_at AS updated_at_25, m3_.id AS id_26, m3_.code AS code_27, m3_.sira AS sira_28, m3_.barcode AS barcode_29, m3_.product_code AS product_code_30, m3_.is_enabled AS is_enabled_31, m3_.del AS del_32, m3_.new_product AS new_product_33, m3_.show_home AS show_home_34, m3_.is_variant AS is_variant_35, m3_.avarage_rating AS avarage_rating_36, m3_.total_visited AS total_visited_37, m3_.position AS position_38, m3_.total_sales AS total_sales_39, m3_.audio_file AS audio_file_40, m3_.uuid AS uuid_41, m3_.length AS length_42, m3_.depth AS depth_43, m3_.height AS height_44, m3_.weight AS weight_45, m3_.product_material AS product_material_46, m3_.product_color AS product_color_47, m3_.product_suggestion AS product_suggestion_48, m3_.product_paint_type AS product_paint_type_49, m3_.delivery_time AS delivery_time_50, m3_.created_at AS created_at_51, m3_.updated_at AS updated_at_52, m3_.is_jewel_price AS is_jewel_price_53, m0_.banner_group_id AS banner_group_id_54, m0_.product_id AS product_id_55, m1_.banner_id AS banner_id_56, m1_.lang_id AS lang_id_57, m3_.brand_id AS brand_id_58, m3_.main_category_id AS main_category_id_59, m3_.blog_id AS blog_id_60 FROM main_banners m0_ LEFT JOIN main_banner_langs m1_ ON m0_.id = m1_.banner_id LEFT JOIN sys_langs s4_ ON m1_.lang_id = s4_.id LEFT JOIN main_banner_groups m2_ ON m0_.banner_group_id = m2_.id LEFT JOIN main_products m3_ ON m0_.product_id = m3_.id WHERE s4_.id = 1 AND m2_.alias = 'banner' ORDER BY m0_.position ASC;
|
| 58 |
0.52 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;
|
| 59 |
0.64 ms |
SELECT t0.id AS id_1, t0.title1 AS title1_2, t0.title2 AS title2_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.banner_id AS banner_id_7, t0.lang_id AS lang_id_8 FROM main_banner_langs t0 WHERE t0.banner_id = ? AND t0.lang_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.title1 AS title1_2, t0.title2 AS title2_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.banner_id AS banner_id_7, t0.lang_id AS lang_id_8 FROM main_banner_langs t0 WHERE t0.banner_id = 8 AND t0.lang_id = 1 LIMIT 1;
|
| 60 |
0.51 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;
|
| 61 |
0.59 ms |
SELECT t0.id AS id_1, t0.title1 AS title1_2, t0.title2 AS title2_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.banner_id AS banner_id_7, t0.lang_id AS lang_id_8 FROM main_banner_langs t0 WHERE t0.banner_id = ? AND t0.lang_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.title1 AS title1_2, t0.title2 AS title2_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.banner_id AS banner_id_7, t0.lang_id AS lang_id_8 FROM main_banner_langs t0 WHERE t0.banner_id = 9 AND t0.lang_id = 1 LIMIT 1;
|
| 62 |
0.49 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;
|
| 63 |
0.86 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;
|
| 64 |
0.50 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;
|
| 65 |
0.89 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;
|
| 66 |
0.53 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;
|
| 67 |
1.28 ms |
SELECT m0_.id AS id_0, m0_.position AS position_1, m0_.link AS link_2, m0_.uuid AS uuid_3, m0_.image_file AS image_file_4, m1_.title1 AS title1_5, m1_.title2 AS title2_6, m1_.description AS description_7 FROM main_instagrams m0_ LEFT JOIN main_instagram_langs m1_ ON m0_.id = m1_.instagram_id LEFT JOIN sys_langs s2_ ON m1_.lang_id = s2_.id WHERE s2_.short_title = ? ORDER BY m0_.position ASC LIMIT 15
SELECT m0_.id AS id_0, m0_.position AS position_1, m0_.link AS link_2, m0_.uuid AS uuid_3, m0_.image_file AS image_file_4, m1_.title1 AS title1_5, m1_.title2 AS title2_6, m1_.description AS description_7 FROM main_instagrams m0_ LEFT JOIN main_instagram_langs m1_ ON m0_.id = m1_.instagram_id LEFT JOIN sys_langs s2_ ON m1_.lang_id = s2_.id WHERE s2_.short_title = 'tr' ORDER BY m0_.position ASC LIMIT 15;
|
| 68 |
0.67 ms |
SELECT m0_.id AS id_0, m0_.alias AS alias_1, m0_.page_id AS page_id_2, m0_.section_id AS section_id_3 FROM main_page_sections m0_ INNER JOIN main_page_sections m1_ ON m0_.section_id = m1_.id WHERE m1_.alias = ?
SELECT m0_.id AS id_0, m0_.alias AS alias_1, m0_.page_id AS page_id_2, m0_.section_id AS section_id_3 FROM main_page_sections m0_ INNER JOIN main_page_sections m1_ ON m0_.section_id = m1_.id WHERE m1_.alias = '';
|
| 69 |
0.81 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;
|
| 70 |
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 = ? 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;
|
| 71 |
0.69 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;
|
| 72 |
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 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;
|
| 73 |
0.76 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;
|
| 74 |
2.68 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 m0_.show_home = ? 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
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 m0_.show_home = 1 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;
|
| 75 |
0.68 ms |
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = 13;
|
| 76 |
0.60 ms |
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = 11;
|
| 77 |
0.48 ms |
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;
|
| 78 |
0.44 ms |
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = 7;
|
| 79 |
0.44 ms |
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = 12;
|
| 80 |
0.44 ms |
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = 10;
|
| 81 |
0.45 ms |
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = 8;
|
| 82 |
0.43 ms |
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = 6;
|
| 83 |
0.45 ms |
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = 5;
|
| 84 |
0.44 ms |
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = 4;
|
| 85 |
0.47 ms |
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = 1;
|
| 86 |
0.43 ms |
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.jewel_id AS jewel_id_6 FROM main_product_jewels t0 WHERE t0.product_id = 2;
|
| 87 |
3.70 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 m1_.show_home = ? 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
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 m1_.show_home = ?
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
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 m1_.show_home = 1 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;
|
| 88 |
0.63 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;
|
| 89 |
0.94 ms |
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;
|
| 90 |
0.91 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;
|
| 91 |
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;
|
| 92 |
0.52 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;
|
| 93 |
0.86 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;
|
| 94 |
0.57 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;
|
| 95 |
0.58 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;
|
| 96 |
0.65 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;
|
| 97 |
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 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;
|
| 98 |
0.51 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;
|
| 99 |
0.54 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;
|
| 100 |
0.52 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;
|
| 101 |
0.83 ms |
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 = 7;
|
| 102 |
1.00 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 = 7 AND t0.del = 0 LIMIT 1;
|
| 103 |
0.65 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;
|
| 104 |
0.58 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;
|
| 105 |
0.92 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 = 7 AND m0_.is_default = 1 AND s3_.id = 1 ORDER BY m2_.sales_price ASC LIMIT 1;
|
| 106 |
0.50 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;
|
| 107 |
0.55 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;
|
| 108 |
0.61 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 = 7 LIMIT 1;
|
| 109 |
0.51 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;
|
| 110 |
0.56 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;
|
| 111 |
0.70 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;
|
| 112 |
0.65 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;
|
| 113 |
0.70 ms |
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 = 8;
|
| 114 |
0.82 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 = 8 AND t0.del = 0 LIMIT 1;
|
| 115 |
0.56 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;
|
| 116 |
0.67 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;
|
| 117 |
1.09 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 = 8 AND m0_.is_default = 1 AND s3_.id = 1 ORDER BY m2_.sales_price ASC LIMIT 1;
|
| 118 |
0.64 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;
|
| 119 |
0.65 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;
|
| 120 |
0.61 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 = 8 LIMIT 1;
|
| 121 |
0.54 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;
|
| 122 |
0.55 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;
|
| 123 |
0.57 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;
|
| 124 |
0.58 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;
|
| 125 |
0.68 ms |
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 = 9;
|
| 126 |
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.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 = 9 AND t0.del = 0 LIMIT 1;
|
| 127 |
0.54 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;
|
| 128 |
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.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;
|
| 129 |
0.84 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 = 9 AND m0_.is_default = 1 AND s3_.id = 1 ORDER BY m2_.sales_price ASC LIMIT 1;
|
| 130 |
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;
|
| 131 |
0.54 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;
|
| 132 |
0.59 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 = 9 LIMIT 1;
|
| 133 |
0.54 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;
|
| 134 |
0.51 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;
|
| 135 |
0.46 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;
|
| 136 |
0.50 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;
|
| 137 |
0.78 ms |
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 = 10;
|
| 138 |
0.82 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 = 10 AND t0.del = 0 LIMIT 1;
|
| 139 |
0.51 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;
|
| 140 |
0.51 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;
|
| 141 |
0.87 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 = 10 AND m0_.is_default = 1 AND s3_.id = 1 ORDER BY m2_.sales_price ASC LIMIT 1;
|
| 142 |
0.50 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;
|
| 143 |
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.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;
|
| 144 |
0.58 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 = 10 LIMIT 1;
|
| 145 |
0.52 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;
|
| 146 |
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.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;
|
| 147 |
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 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;
|
| 148 |
0.54 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;
|
| 149 |
0.63 ms |
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 = 11;
|
| 150 |
0.82 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 = 11 AND t0.del = 0 LIMIT 1;
|
| 151 |
0.50 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;
|
| 152 |
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.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;
|
| 153 |
0.81 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 = 11 AND m0_.is_default = 1 AND s3_.id = 1 ORDER BY m2_.sales_price ASC LIMIT 1;
|
| 154 |
0.51 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;
|
| 155 |
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.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;
|
| 156 |
0.61 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 = 11 LIMIT 1;
|
| 157 |
0.52 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;
|
| 158 |
0.55 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;
|
| 159 |
0.50 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;
|
| 160 |
0.51 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;
|
| 161 |
0.63 ms |
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 = 12;
|
| 162 |
0.84 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 = 12 AND t0.del = 0 LIMIT 1;
|
| 163 |
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;
|
| 164 |
0.54 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;
|
| 165 |
0.79 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 = 12 AND m0_.is_default = 1 AND s3_.id = 1 ORDER BY m2_.sales_price ASC LIMIT 1;
|
| 166 |
0.50 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;
|
| 167 |
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.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;
|
| 168 |
0.64 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 = 12 LIMIT 1;
|
| 169 |
0.61 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;
|
| 170 |
0.54 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;
|
| 171 |
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;
|
| 172 |
0.52 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;
|
| 173 |
0.65 ms |
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 = 13;
|
| 174 |
0.78 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 = 13 AND t0.del = 0 LIMIT 1;
|
| 175 |
0.47 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;
|
| 176 |
0.52 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;
|
| 177 |
0.80 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 = 13 AND m0_.is_default = 1 AND s3_.id = 1 ORDER BY m2_.sales_price ASC LIMIT 1;
|
| 178 |
0.50 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;
|
| 179 |
0.57 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;
|
| 180 |
0.57 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 = 13 LIMIT 1;
|
| 181 |
0.54 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;
|
| 182 |
0.55 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;
|
| 183 |
0.50 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;
|
| 184 |
0.52 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;
|
| 185 |
0.61 ms |
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 = 5;
|
| 186 |
0.80 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 = 5 AND t0.del = 0 LIMIT 1;
|
| 187 |
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 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;
|
| 188 |
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.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;
|
| 189 |
0.85 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 = 5 AND m0_.is_default = 1 AND s3_.id = 1 ORDER BY m2_.sales_price ASC LIMIT 1;
|
| 190 |
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 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;
|
| 191 |
0.52 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;
|
| 192 |
0.64 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 = 5 LIMIT 1;
|
| 193 |
0.50 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;
|
| 194 |
0.54 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;
|
| 195 |
0.62 ms |
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 = 4;
|
| 196 |
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.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 = 4 AND t0.del = 0 LIMIT 1;
|
| 197 |
0.50 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;
|
| 198 |
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.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;
|
| 199 |
0.82 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 = 4 AND m0_.is_default = 1 AND s3_.id = 1 ORDER BY m2_.sales_price ASC LIMIT 1;
|
| 200 |
0.50 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;
|
| 201 |
0.55 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;
|
| 202 |
0.59 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 = 4 LIMIT 1;
|
| 203 |
0.57 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;
|
| 204 |
0.76 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;
|
| 205 |
0.74 ms |
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 = 1;
|
| 206 |
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 = ? 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 = 1 AND t0.del = 0 LIMIT 1;
|
| 207 |
0.55 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;
|
| 208 |
0.61 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;
|
| 209 |
0.85 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 = 1 AND m0_.is_default = 1 AND s3_.id = 1 ORDER BY m2_.sales_price ASC LIMIT 1;
|
| 210 |
0.50 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;
|
| 211 |
0.57 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;
|
| 212 |
0.59 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 = 1 LIMIT 1;
|
| 213 |
0.52 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;
|
| 214 |
0.55 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;
|
| 215 |
0.61 ms |
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 = 2;
|
| 216 |
0.86 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 = 2 AND t0.del = 0 LIMIT 1;
|
| 217 |
0.51 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;
|
| 218 |
0.50 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;
|
| 219 |
0.85 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 = 2 AND m0_.is_default = 1 AND s3_.id = 1 ORDER BY m2_.sales_price ASC LIMIT 1;
|
| 220 |
0.54 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;
|
| 221 |
0.54 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;
|
| 222 |
0.64 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 = 2 LIMIT 1;
|
| 223 |
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;
|
| 224 |
0.55 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;
|