1 |
0.41 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.pic_ext AS pic_ext_3, t0.pic_small_ext AS pic_small_ext_4, t0.link AS link_5, t0.updated_at AS updated_at_6, t0.date_insert AS date_insert_7, t0.type AS type_8, t0.`order` AS order_9 FROM advertise t0 WHERE t0.type = ? ORDER BY t0.`order` ASC
SELECT t0.id AS id_1, t0.title AS title_2, t0.pic_ext AS pic_ext_3, t0.pic_small_ext AS pic_small_ext_4, t0.link AS link_5, t0.updated_at AS updated_at_6, t0.date_insert AS date_insert_7, t0.type AS type_8, t0.`order` AS order_9 FROM advertise t0 WHERE t0.type = 1 ORDER BY t0.`order` ASC;
|
2 |
0.34 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.pic_ext AS pic_ext_3, t0.pic_small_ext AS pic_small_ext_4, t0.link AS link_5, t0.updated_at AS updated_at_6, t0.date_insert AS date_insert_7, t0.type AS type_8, t0.`order` AS order_9 FROM advertise t0 WHERE t0.type = ? ORDER BY t0.`order` ASC
SELECT t0.id AS id_1, t0.title AS title_2, t0.pic_ext AS pic_ext_3, t0.pic_small_ext AS pic_small_ext_4, t0.link AS link_5, t0.updated_at AS updated_at_6, t0.date_insert AS date_insert_7, t0.type AS type_8, t0.`order` AS order_9 FROM advertise t0 WHERE t0.type = 4 ORDER BY t0.`order` ASC;
|
3 |
0.19 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.pic_ext AS pic_ext_3, t0.pic_small_ext AS pic_small_ext_4, t0.link AS link_5, t0.updated_at AS updated_at_6, t0.date_insert AS date_insert_7, t0.type AS type_8, t0.`order` AS order_9 FROM advertise t0 WHERE t0.type = ? ORDER BY t0.`order` ASC
SELECT t0.id AS id_1, t0.title AS title_2, t0.pic_ext AS pic_ext_3, t0.pic_small_ext AS pic_small_ext_4, t0.link AS link_5, t0.updated_at AS updated_at_6, t0.date_insert AS date_insert_7, t0.type AS type_8, t0.`order` AS order_9 FROM advertise t0 WHERE t0.type = 2 ORDER BY t0.`order` ASC;
|
4 |
0.20 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.pic_ext AS pic_ext_3, t0.pic_small_ext AS pic_small_ext_4, t0.link AS link_5, t0.updated_at AS updated_at_6, t0.date_insert AS date_insert_7, t0.type AS type_8, t0.`order` AS order_9 FROM advertise t0 WHERE t0.type = ? ORDER BY t0.`order` ASC
SELECT t0.id AS id_1, t0.title AS title_2, t0.pic_ext AS pic_ext_3, t0.pic_small_ext AS pic_small_ext_4, t0.link AS link_5, t0.updated_at AS updated_at_6, t0.date_insert AS date_insert_7, t0.type AS type_8, t0.`order` AS order_9 FROM advertise t0 WHERE t0.type = 3 ORDER BY t0.`order` ASC;
|
5 |
0.21 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.pic_ext AS pic_ext_3, t0.link AS link_4, t0.updated_at AS updated_at_5, t0.date_insert AS date_insert_6, t0.`order` AS order_7 FROM brand t0 ORDER BY t0.`order` ASC
SELECT t0.id AS id_1, t0.title AS title_2, t0.pic_ext AS pic_ext_3, t0.link AS link_4, t0.updated_at AS updated_at_5, t0.date_insert AS date_insert_6, t0.`order` AS order_7 FROM brand t0 ORDER BY t0.`order` ASC;
|
6 |
0.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.visible AS visible_3, t0.ordering AS ordering_4 FROM shop_special t0 WHERE t0.visible = ? ORDER BY t0.ordering ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.visible AS visible_3, t0.ordering AS ordering_4 FROM shop_special t0 WHERE t0.visible = 1 ORDER BY t0.ordering ASC;
|
7 |
0.48 ms |
SELECT t0.id AS id_1, t0.about_us AS about_us_2, t0.contact_us AS contact_us_3, t0.introduce AS introduce_4, t0.privacy_policy_ext AS privacy_policy_ext_5, t0.terms_and_conditions_ext AS terms_and_conditions_ext_6, t0.website_title AS website_title_7, t0.meta_description AS meta_description_8, t0.footer_description AS footer_description_9, t0.logo_ext AS logo_ext_10, t0.fav_icon_ext AS fav_icon_ext_11, t0.top_banner_ext AS top_banner_ext_12, t0.top_banner_link AS top_banner_link_13, t0.updated_at AS updated_at_14, t0.footer_column1_title AS footer_column1_title_15, t0.footer_column2_title AS footer_column2_title_16, t0.footer_column3_title AS footer_column3_title_17, t0.footer_column4_title AS footer_column4_title_18, t0.buy_without_login AS buy_without_login_19, t0.footer_social_instagram AS footer_social_instagram_20, t0.footer_social_whatsapp AS footer_social_whatsapp_21, t0.footer_social_telegram AS footer_social_telegram_22, t0.footer_social_twitter AS footer_social_twitter_23, t0.footer_script AS footer_script_24 FROM setting t0 LIMIT 1
SELECT t0.id AS id_1, t0.about_us AS about_us_2, t0.contact_us AS contact_us_3, t0.introduce AS introduce_4, t0.privacy_policy_ext AS privacy_policy_ext_5, t0.terms_and_conditions_ext AS terms_and_conditions_ext_6, t0.website_title AS website_title_7, t0.meta_description AS meta_description_8, t0.footer_description AS footer_description_9, t0.logo_ext AS logo_ext_10, t0.fav_icon_ext AS fav_icon_ext_11, t0.top_banner_ext AS top_banner_ext_12, t0.top_banner_link AS top_banner_link_13, t0.updated_at AS updated_at_14, t0.footer_column1_title AS footer_column1_title_15, t0.footer_column2_title AS footer_column2_title_16, t0.footer_column3_title AS footer_column3_title_17, t0.footer_column4_title AS footer_column4_title_18, t0.buy_without_login AS buy_without_login_19, t0.footer_social_instagram AS footer_social_instagram_20, t0.footer_social_whatsapp AS footer_social_whatsapp_21, t0.footer_social_telegram AS footer_social_telegram_22, t0.footer_social_twitter AS footer_social_twitter_23, t0.footer_script AS footer_script_24 FROM setting t0 LIMIT 1;
|
8 |
2.75 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.level AS level_3, c0_.pic_ext AS pic_ext_4, c0_.features AS features_5, c0_.raychat_code AS raychat_code_6, c0_.visible AS visible_7, c0_.updated_at AS updated_at_8, c1_.id AS id_9, c1_.name AS name_10, c1_.code AS code_11, c1_.level AS level_12, c1_.pic_ext AS pic_ext_13, c1_.features AS features_14, c1_.raychat_code AS raychat_code_15, c1_.visible AS visible_16, c1_.updated_at AS updated_at_17, c2_.id AS id_18, c2_.name AS name_19, c2_.code AS code_20, c2_.level AS level_21, c2_.pic_ext AS pic_ext_22, c2_.features AS features_23, c2_.raychat_code AS raychat_code_24, c2_.visible AS visible_25, c2_.updated_at AS updated_at_26, c0_.parent_id AS parent_id_27, c1_.parent_id AS parent_id_28, c2_.parent_id AS parent_id_29 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.parent_id LEFT JOIN category c2_ ON c1_.id = c2_.parent_id WHERE c0_.parent_id IS NULL AND c0_.visible = ?
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.level AS level_3, c0_.pic_ext AS pic_ext_4, c0_.features AS features_5, c0_.raychat_code AS raychat_code_6, c0_.visible AS visible_7, c0_.updated_at AS updated_at_8, c1_.id AS id_9, c1_.name AS name_10, c1_.code AS code_11, c1_.level AS level_12, c1_.pic_ext AS pic_ext_13, c1_.features AS features_14, c1_.raychat_code AS raychat_code_15, c1_.visible AS visible_16, c1_.updated_at AS updated_at_17, c2_.id AS id_18, c2_.name AS name_19, c2_.code AS code_20, c2_.level AS level_21, c2_.pic_ext AS pic_ext_22, c2_.features AS features_23, c2_.raychat_code AS raychat_code_24, c2_.visible AS visible_25, c2_.updated_at AS updated_at_26, c0_.parent_id AS parent_id_27, c1_.parent_id AS parent_id_28, c2_.parent_id AS parent_id_29 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.parent_id LEFT JOIN category c2_ ON c1_.id = c2_.parent_id WHERE c0_.parent_id IS NULL AND c0_.visible = 1;
|
9 |
0.43 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.type AS type_4, t0.position AS position_5, t0.order AS order_6, t0.page_id AS page_id_7, t0.category_id AS category_id_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id IS NULL AND t0.position = ? ORDER BY t0.order ASC
SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.type AS type_4, t0.position AS position_5, t0.order AS order_6, t0.page_id AS page_id_7, t0.category_id AS category_id_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id IS NULL AND t0.position = 0 ORDER BY t0.order ASC;
|
10 |
2.73 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.level AS level_3, c0_.pic_ext AS pic_ext_4, c0_.features AS features_5, c0_.raychat_code AS raychat_code_6, c0_.visible AS visible_7, c0_.updated_at AS updated_at_8, c1_.id AS id_9, c1_.name AS name_10, c1_.code AS code_11, c1_.level AS level_12, c1_.pic_ext AS pic_ext_13, c1_.features AS features_14, c1_.raychat_code AS raychat_code_15, c1_.visible AS visible_16, c1_.updated_at AS updated_at_17, c2_.id AS id_18, c2_.name AS name_19, c2_.code AS code_20, c2_.level AS level_21, c2_.pic_ext AS pic_ext_22, c2_.features AS features_23, c2_.raychat_code AS raychat_code_24, c2_.visible AS visible_25, c2_.updated_at AS updated_at_26, c0_.parent_id AS parent_id_27, c1_.parent_id AS parent_id_28, c2_.parent_id AS parent_id_29 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.parent_id LEFT JOIN category c2_ ON c1_.id = c2_.parent_id WHERE c0_.parent_id IS NULL AND c0_.visible = ?
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.level AS level_3, c0_.pic_ext AS pic_ext_4, c0_.features AS features_5, c0_.raychat_code AS raychat_code_6, c0_.visible AS visible_7, c0_.updated_at AS updated_at_8, c1_.id AS id_9, c1_.name AS name_10, c1_.code AS code_11, c1_.level AS level_12, c1_.pic_ext AS pic_ext_13, c1_.features AS features_14, c1_.raychat_code AS raychat_code_15, c1_.visible AS visible_16, c1_.updated_at AS updated_at_17, c2_.id AS id_18, c2_.name AS name_19, c2_.code AS code_20, c2_.level AS level_21, c2_.pic_ext AS pic_ext_22, c2_.features AS features_23, c2_.raychat_code AS raychat_code_24, c2_.visible AS visible_25, c2_.updated_at AS updated_at_26, c0_.parent_id AS parent_id_27, c1_.parent_id AS parent_id_28, c2_.parent_id AS parent_id_29 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.parent_id LEFT JOIN category c2_ ON c1_.id = c2_.parent_id WHERE c0_.parent_id IS NULL AND c0_.visible = 1;
|
11 |
0.35 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.type AS type_4, t0.position AS position_5, t0.order AS order_6, t0.page_id AS page_id_7, t0.category_id AS category_id_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id IS NULL AND t0.position = ? ORDER BY t0.order ASC
SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.type AS type_4, t0.position AS position_5, t0.order AS order_6, t0.page_id AS page_id_7, t0.category_id AS category_id_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id IS NULL AND t0.position = 0 ORDER BY t0.order ASC;
|
12 |
0.53 ms |
SELECT t0.id AS id_1, t0.name_en AS name_en_2, t0.name_fa AS name_fa_3, t0.brand_en AS brand_en_4, t0.brand_fa AS brand_fa_5, t0.name_brand_en AS name_brand_en_6, t0.name_brand_fa AS name_brand_fa_7, t0.erx_code AS erx_code_8, t0.erx_code_base AS erx_code_base_9, t0.rx_behdasht AS rx_behdasht_10, t0.generic_code AS generic_code_11, t0.mother_code AS mother_code_12, t0.licence_owner AS licence_owner_13, t0.brand_owner AS brand_owner_14, t0.brand_owner_country AS brand_owner_country_15, t0.producer AS producer_16, t0.producer_country AS producer_country_17, t0.name_interactive AS name_interactive_18, t0.packing AS packing_19, t0.form AS form_20, t0.pregnancy_category AS pregnancy_category_21, t0.other AS other_22, t0.features AS features_23, t0.video_id AS video_id_24, t0.last_price AS last_price_25, t0.only_doctor_user AS only_doctor_user_26, t0.status AS status_27, t0.license_owner_id AS license_owner_id_28 FROM item t0 INNER JOIN item_shop_specials ON t0.id = item_shop_specials.item_id WHERE item_shop_specials.shop_special_id = ?
SELECT t0.id AS id_1, t0.name_en AS name_en_2, t0.name_fa AS name_fa_3, t0.brand_en AS brand_en_4, t0.brand_fa AS brand_fa_5, t0.name_brand_en AS name_brand_en_6, t0.name_brand_fa AS name_brand_fa_7, t0.erx_code AS erx_code_8, t0.erx_code_base AS erx_code_base_9, t0.rx_behdasht AS rx_behdasht_10, t0.generic_code AS generic_code_11, t0.mother_code AS mother_code_12, t0.licence_owner AS licence_owner_13, t0.brand_owner AS brand_owner_14, t0.brand_owner_country AS brand_owner_country_15, t0.producer AS producer_16, t0.producer_country AS producer_country_17, t0.name_interactive AS name_interactive_18, t0.packing AS packing_19, t0.form AS form_20, t0.pregnancy_category AS pregnancy_category_21, t0.other AS other_22, t0.features AS features_23, t0.video_id AS video_id_24, t0.last_price AS last_price_25, t0.only_doctor_user AS only_doctor_user_26, t0.status AS status_27, t0.license_owner_id AS license_owner_id_28 FROM item t0 INNER JOIN item_shop_specials ON t0.id = item_shop_specials.item_id WHERE item_shop_specials.shop_special_id = 7;
|
13 |
0.26 ms |
SELECT t0.id AS id_1, t0.pic_ext AS pic_ext_2, t0.type AS type_3, t0.updated_at AS updated_at_4, t0.item_id AS item_id_5 FROM item_media t0 WHERE t0.item_id = ?
SELECT t0.id AS id_1, t0.pic_ext AS pic_ext_2, t0.type AS type_3, t0.updated_at AS updated_at_4, t0.item_id AS item_id_5 FROM item_media t0 WHERE t0.item_id = 321083;
|
14 |
0.21 ms |
SELECT t0.id AS id_1, t0.pic_ext AS pic_ext_2, t0.type AS type_3, t0.updated_at AS updated_at_4, t0.item_id AS item_id_5 FROM item_media t0 WHERE t0.item_id = ?
SELECT t0.id AS id_1, t0.pic_ext AS pic_ext_2, t0.type AS type_3, t0.updated_at AS updated_at_4, t0.item_id AS item_id_5 FROM item_media t0 WHERE t0.item_id = 321469;
|
15 |
0.23 ms |
SELECT t0.id AS id_1, t0.pic_ext AS pic_ext_2, t0.type AS type_3, t0.updated_at AS updated_at_4, t0.item_id AS item_id_5 FROM item_media t0 WHERE t0.item_id = ?
SELECT t0.id AS id_1, t0.pic_ext AS pic_ext_2, t0.type AS type_3, t0.updated_at AS updated_at_4, t0.item_id AS item_id_5 FROM item_media t0 WHERE t0.item_id = 325041;
|
16 |
0.22 ms |
SELECT t0.id AS id_1, t0.pic_ext AS pic_ext_2, t0.type AS type_3, t0.updated_at AS updated_at_4, t0.item_id AS item_id_5 FROM item_media t0 WHERE t0.item_id = ?
SELECT t0.id AS id_1, t0.pic_ext AS pic_ext_2, t0.type AS type_3, t0.updated_at AS updated_at_4, t0.item_id AS item_id_5 FROM item_media t0 WHERE t0.item_id = 325043;
|
17 |
0.20 ms |
SELECT t0.id AS id_1, t0.pic_ext AS pic_ext_2, t0.type AS type_3, t0.updated_at AS updated_at_4, t0.item_id AS item_id_5 FROM item_media t0 WHERE t0.item_id = ?
SELECT t0.id AS id_1, t0.pic_ext AS pic_ext_2, t0.type AS type_3, t0.updated_at AS updated_at_4, t0.item_id AS item_id_5 FROM item_media t0 WHERE t0.item_id = 325053;
|
18 |
0.19 ms |
SELECT t0.id AS id_1, t0.pic_ext AS pic_ext_2, t0.type AS type_3, t0.updated_at AS updated_at_4, t0.item_id AS item_id_5 FROM item_media t0 WHERE t0.item_id = ?
SELECT t0.id AS id_1, t0.pic_ext AS pic_ext_2, t0.type AS type_3, t0.updated_at AS updated_at_4, t0.item_id AS item_id_5 FROM item_media t0 WHERE t0.item_id = 575331;
|
19 |
0.20 ms |
SELECT t0.id AS id_1, t0.pic_ext AS pic_ext_2, t0.type AS type_3, t0.updated_at AS updated_at_4, t0.item_id AS item_id_5 FROM item_media t0 WHERE t0.item_id = ?
SELECT t0.id AS id_1, t0.pic_ext AS pic_ext_2, t0.type AS type_3, t0.updated_at AS updated_at_4, t0.item_id AS item_id_5 FROM item_media t0 WHERE t0.item_id = 575483;
|
20 |
0.18 ms |
SELECT t0.id AS id_1, t0.pic_ext AS pic_ext_2, t0.type AS type_3, t0.updated_at AS updated_at_4, t0.item_id AS item_id_5 FROM item_media t0 WHERE t0.item_id = ?
SELECT t0.id AS id_1, t0.pic_ext AS pic_ext_2, t0.type AS type_3, t0.updated_at AS updated_at_4, t0.item_id AS item_id_5 FROM item_media t0 WHERE t0.item_id = 575490;
|
21 |
0.17 ms |
SELECT t0.id AS id_1, t0.pic_ext AS pic_ext_2, t0.type AS type_3, t0.updated_at AS updated_at_4, t0.item_id AS item_id_5 FROM item_media t0 WHERE t0.item_id = ?
SELECT t0.id AS id_1, t0.pic_ext AS pic_ext_2, t0.type AS type_3, t0.updated_at AS updated_at_4, t0.item_id AS item_id_5 FROM item_media t0 WHERE t0.item_id = 575507;
|
22 |
0.27 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.type AS type_4, t0.position AS position_5, t0.order AS order_6, t0.page_id AS page_id_7, t0.category_id AS category_id_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id IS NULL AND t0.position = ? ORDER BY t0.order ASC
SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.type AS type_4, t0.position AS position_5, t0.order AS order_6, t0.page_id AS page_id_7, t0.category_id AS category_id_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id IS NULL AND t0.position = 1 ORDER BY t0.order ASC;
|
23 |
0.25 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.type AS type_4, t0.position AS position_5, t0.order AS order_6, t0.page_id AS page_id_7, t0.category_id AS category_id_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id IS NULL AND t0.position = ? ORDER BY t0.order ASC
SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.type AS type_4, t0.position AS position_5, t0.order AS order_6, t0.page_id AS page_id_7, t0.category_id AS category_id_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id IS NULL AND t0.position = 2 ORDER BY t0.order ASC;
|
24 |
0.23 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.type AS type_4, t0.position AS position_5, t0.order AS order_6, t0.page_id AS page_id_7, t0.category_id AS category_id_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id IS NULL AND t0.position = ? ORDER BY t0.order ASC
SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.type AS type_4, t0.position AS position_5, t0.order AS order_6, t0.page_id AS page_id_7, t0.category_id AS category_id_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id IS NULL AND t0.position = 3 ORDER BY t0.order ASC;
|
25 |
0.21 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.type AS type_4, t0.position AS position_5, t0.order AS order_6, t0.page_id AS page_id_7, t0.category_id AS category_id_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id IS NULL AND t0.position = ? ORDER BY t0.order ASC
SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.type AS type_4, t0.position AS position_5, t0.order AS order_6, t0.page_id AS page_id_7, t0.category_id AS category_id_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id IS NULL AND t0.position = 4 ORDER BY t0.order ASC;
|