1 |
3.32 ms |
SELECT i0_.id AS id_0, i0_.name_en AS name_en_1, i0_.name_fa AS name_fa_2, i0_.brand_en AS brand_en_3, i0_.brand_fa AS brand_fa_4, i0_.name_brand_en AS name_brand_en_5, i0_.name_brand_fa AS name_brand_fa_6, i0_.erx_code AS erx_code_7, i0_.erx_code_base AS erx_code_base_8, i0_.rx_behdasht AS rx_behdasht_9, i0_.generic_code AS generic_code_10, i0_.mother_code AS mother_code_11, i0_.licence_owner AS licence_owner_12, i0_.brand_owner AS brand_owner_13, i0_.brand_owner_country AS brand_owner_country_14, i0_.producer AS producer_15, i0_.producer_country AS producer_country_16, i0_.name_interactive AS name_interactive_17, i0_.packing AS packing_18, i0_.form AS form_19, i0_.pregnancy_category AS pregnancy_category_20, i0_.other AS other_21, i0_.features AS features_22, i0_.video_id AS video_id_23, i0_.last_price AS last_price_24, i0_.only_doctor_user AS only_doctor_user_25, i0_.status AS status_26, i1_.id AS id_27, i1_.pic_ext AS pic_ext_28, i1_.type AS type_29, i1_.updated_at AS updated_at_30, c2_.id AS id_31, c2_.name AS name_32, c2_.code AS code_33, c2_.level AS level_34, c2_.pic_ext AS pic_ext_35, c2_.features AS features_36, c2_.raychat_code AS raychat_code_37, c2_.visible AS visible_38, c2_.updated_at AS updated_at_39, i0_.license_owner_id AS license_owner_id_40, i1_.item_id AS item_id_41, c2_.parent_id AS parent_id_42 FROM item i0_ LEFT JOIN item_media i1_ ON i0_.id = i1_.item_id AND (i1_.type = ?) INNER JOIN item_category i3_ ON i0_.id = i3_.item_id INNER JOIN category c2_ ON c2_.id = i3_.category_id WHERE i0_.erx_code = ?
Parameters: [
1
"eRx594996"
]
SELECT
i0_.id AS id_0,
i0_.name_en AS name_en_1,
i0_.name_fa AS name_fa_2,
i0_.brand_en AS brand_en_3,
i0_.brand_fa AS brand_fa_4,
i0_.name_brand_en AS name_brand_en_5,
i0_.name_brand_fa AS name_brand_fa_6,
i0_.erx_code AS erx_code_7,
i0_.erx_code_base AS erx_code_base_8,
i0_.rx_behdasht AS rx_behdasht_9,
i0_.generic_code AS generic_code_10,
i0_.mother_code AS mother_code_11,
i0_.licence_owner AS licence_owner_12,
i0_.brand_owner AS brand_owner_13,
i0_.brand_owner_country AS brand_owner_country_14,
i0_.producer AS producer_15,
i0_.producer_country AS producer_country_16,
i0_.name_interactive AS name_interactive_17,
i0_.packing AS packing_18,
i0_.form AS form_19,
i0_.pregnancy_category AS pregnancy_category_20,
i0_.other AS other_21,
i0_.features AS features_22,
i0_.video_id AS video_id_23,
i0_.last_price AS last_price_24,
i0_.only_doctor_user AS only_doctor_user_25,
i0_.status AS status_26,
i1_.id AS id_27,
i1_.pic_ext AS pic_ext_28,
i1_.type AS type_29,
i1_.updated_at AS updated_at_30,
c2_.id AS id_31,
c2_.name AS name_32,
c2_.code AS code_33,
c2_.level AS level_34,
c2_.pic_ext AS pic_ext_35,
c2_.features AS features_36,
c2_.raychat_code AS raychat_code_37,
c2_.visible AS visible_38,
c2_.updated_at AS updated_at_39,
i0_.license_owner_id AS license_owner_id_40,
i1_.item_id AS item_id_41,
c2_.parent_id AS parent_id_42
FROM
item i0_
LEFT JOIN item_media i1_ ON i0_.id = i1_.item_id
AND (i1_.type = ?)
INNER JOIN item_category i3_ ON i0_.id = i3_.item_id
INNER JOIN category c2_ ON c2_.id = i3_.category_id
WHERE
i0_.erx_code = ?
SELECT i0_.id AS id_0, i0_.name_en AS name_en_1, i0_.name_fa AS name_fa_2, i0_.brand_en AS brand_en_3, i0_.brand_fa AS brand_fa_4, i0_.name_brand_en AS name_brand_en_5, i0_.name_brand_fa AS name_brand_fa_6, i0_.erx_code AS erx_code_7, i0_.erx_code_base AS erx_code_base_8, i0_.rx_behdasht AS rx_behdasht_9, i0_.generic_code AS generic_code_10, i0_.mother_code AS mother_code_11, i0_.licence_owner AS licence_owner_12, i0_.brand_owner AS brand_owner_13, i0_.brand_owner_country AS brand_owner_country_14, i0_.producer AS producer_15, i0_.producer_country AS producer_country_16, i0_.name_interactive AS name_interactive_17, i0_.packing AS packing_18, i0_.form AS form_19, i0_.pregnancy_category AS pregnancy_category_20, i0_.other AS other_21, i0_.features AS features_22, i0_.video_id AS video_id_23, i0_.last_price AS last_price_24, i0_.only_doctor_user AS only_doctor_user_25, i0_.status AS status_26, i1_.id AS id_27, i1_.pic_ext AS pic_ext_28, i1_.type AS type_29, i1_.updated_at AS updated_at_30, c2_.id AS id_31, c2_.name AS name_32, c2_.code AS code_33, c2_.level AS level_34, c2_.pic_ext AS pic_ext_35, c2_.features AS features_36, c2_.raychat_code AS raychat_code_37, c2_.visible AS visible_38, c2_.updated_at AS updated_at_39, i0_.license_owner_id AS license_owner_id_40, i1_.item_id AS item_id_41, c2_.parent_id AS parent_id_42 FROM item i0_ LEFT JOIN item_media i1_ ON i0_.id = i1_.item_id AND (i1_.type = 1) INNER JOIN item_category i3_ ON i0_.id = i3_.item_id INNER JOIN category c2_ ON c2_.id = i3_.category_id WHERE i0_.erx_code = 'eRx594996';
|
2 |
0.66 ms |
SELECT i0_.id AS id_0, i0_.sale_code AS sale_code_1, i0_.exist AS exist_2, i0_.last_percent_price AS last_percent_price_3, i0_.last_custom_price AS last_custom_price_4, i0_.broadcast_code AS broadcast_code_5, i0_.broadcast_name AS broadcast_name_6, i0_.respite AS respite_7, i0_.award AS award_8, i0_.date_expire AS date_expire_9, i0_.date_update AS date_update_10, i0_.inventory AS inventory_11, u1_.username AS username_12, u1_.username_canonical AS username_canonical_13, u1_.email AS email_14, u1_.email_canonical AS email_canonical_15, u1_.enabled AS enabled_16, u1_.salt AS salt_17, u1_.password AS password_18, u1_.last_login AS last_login_19, u1_.confirmation_token AS confirmation_token_20, u1_.password_requested_at AS password_requested_at_21, u1_.roles AS roles_22, u1_.id AS id_23, u1_.full_name AS full_name_24, u1_.code_melli AS code_melli_25, u1_.mobile AS mobile_26, u1_.mail AS mail_27, u1_.insert_date AS insert_date_28, u1_.api_key AS api_key_29, u1_.pic_ext AS pic_ext_30, u1_.updated_at AS updated_at_31, u1_.medical_council_code AS medical_council_code_32, u1_.drugstore_code AS drugstore_code_33, u1_.drugstore_originator AS drugstore_originator_34, u1_.drugstore_license AS drugstore_license_35, u1_.drugstore_license_pic_ext AS drugstore_license_pic_ext_36, u1_.drugstore_hix AS drugstore_hix_37, u1_.drugstore_gln AS drugstore_gln_38, u1_.birth_date AS birth_date_39, u1_.status AS status_40, u1_.is_male AS is_male_41, u1_.is_information_complete AS is_information_complete_42, u1_.description AS description_43, u1_.operator_job_title AS operator_job_title_44, u1_.auth_code AS auth_code_45, u1_.trusted_version AS trusted_version_46, u1_.balance AS balance_47, u1_.operator_all_categories AS operator_all_categories_48, u1_.operator_all_license_owners AS operator_all_license_owners_49, u1_.cart_count AS cart_count_50, i0_.item_id AS item_id_51, i0_.drugstore_id AS drugstore_id_52, u1_.city_id AS city_id_53, u1_.type_id AS type_id_54 FROM item_drugstore i0_ INNER JOIN user u1_ ON i0_.drugstore_id = u1_.id INNER JOIN address a2_ ON u1_.id = a2_.user_id INNER JOIN drugstore_type d3_ ON u1_.type_id = d3_.id INNER JOIN item i4_ ON i0_.item_id = i4_.id WHERE i4_.id = ? AND u1_.status = ? AND u1_.enabled = ? AND i0_.exist = 1 AND i4_.status = ? AND u1_.id <> ? ORDER BY i0_.last_percent_price DESC LIMIT 20
Parameters: [
439524
2
1
1
null
]
SELECT
i0_.id AS id_0,
i0_.sale_code AS sale_code_1,
i0_.exist AS exist_2,
i0_.last_percent_price AS last_percent_price_3,
i0_.last_custom_price AS last_custom_price_4,
i0_.broadcast_code AS broadcast_code_5,
i0_.broadcast_name AS broadcast_name_6,
i0_.respite AS respite_7,
i0_.award AS award_8,
i0_.date_expire AS date_expire_9,
i0_.date_update AS date_update_10,
i0_.inventory AS inventory_11,
u1_.username AS username_12,
u1_.username_canonical AS username_canonical_13,
u1_.email AS email_14,
u1_.email_canonical AS email_canonical_15,
u1_.enabled AS enabled_16,
u1_.salt AS salt_17,
u1_.password AS password_18,
u1_.last_login AS last_login_19,
u1_.confirmation_token AS confirmation_token_20,
u1_.password_requested_at AS password_requested_at_21,
u1_.roles AS roles_22,
u1_.id AS id_23,
u1_.full_name AS full_name_24,
u1_.code_melli AS code_melli_25,
u1_.mobile AS mobile_26,
u1_.mail AS mail_27,
u1_.insert_date AS insert_date_28,
u1_.api_key AS api_key_29,
u1_.pic_ext AS pic_ext_30,
u1_.updated_at AS updated_at_31,
u1_.medical_council_code AS medical_council_code_32,
u1_.drugstore_code AS drugstore_code_33,
u1_.drugstore_originator AS drugstore_originator_34,
u1_.drugstore_license AS drugstore_license_35,
u1_.drugstore_license_pic_ext AS drugstore_license_pic_ext_36,
u1_.drugstore_hix AS drugstore_hix_37,
u1_.drugstore_gln AS drugstore_gln_38,
u1_.birth_date AS birth_date_39,
u1_.status AS status_40,
u1_.is_male AS is_male_41,
u1_.is_information_complete AS is_information_complete_42,
u1_.description AS description_43,
u1_.operator_job_title AS operator_job_title_44,
u1_.auth_code AS auth_code_45,
u1_.trusted_version AS trusted_version_46,
u1_.balance AS balance_47,
u1_.operator_all_categories AS operator_all_categories_48,
u1_.operator_all_license_owners AS operator_all_license_owners_49,
u1_.cart_count AS cart_count_50,
i0_.item_id AS item_id_51,
i0_.drugstore_id AS drugstore_id_52,
u1_.city_id AS city_id_53,
u1_.type_id AS type_id_54
FROM
item_drugstore i0_
INNER JOIN user u1_ ON i0_.drugstore_id = u1_.id
INNER JOIN address a2_ ON u1_.id = a2_.user_id
INNER JOIN drugstore_type d3_ ON u1_.type_id = d3_.id
INNER JOIN item i4_ ON i0_.item_id = i4_.id
WHERE
i4_.id = ?
AND u1_.status = ?
AND u1_.enabled = ?
AND i0_.exist = 1
AND i4_.status = ?
AND u1_.id <> ?
ORDER BY
i0_.last_percent_price DESC
LIMIT
20
SELECT i0_.id AS id_0, i0_.sale_code AS sale_code_1, i0_.exist AS exist_2, i0_.last_percent_price AS last_percent_price_3, i0_.last_custom_price AS last_custom_price_4, i0_.broadcast_code AS broadcast_code_5, i0_.broadcast_name AS broadcast_name_6, i0_.respite AS respite_7, i0_.award AS award_8, i0_.date_expire AS date_expire_9, i0_.date_update AS date_update_10, i0_.inventory AS inventory_11, u1_.username AS username_12, u1_.username_canonical AS username_canonical_13, u1_.email AS email_14, u1_.email_canonical AS email_canonical_15, u1_.enabled AS enabled_16, u1_.salt AS salt_17, u1_.password AS password_18, u1_.last_login AS last_login_19, u1_.confirmation_token AS confirmation_token_20, u1_.password_requested_at AS password_requested_at_21, u1_.roles AS roles_22, u1_.id AS id_23, u1_.full_name AS full_name_24, u1_.code_melli AS code_melli_25, u1_.mobile AS mobile_26, u1_.mail AS mail_27, u1_.insert_date AS insert_date_28, u1_.api_key AS api_key_29, u1_.pic_ext AS pic_ext_30, u1_.updated_at AS updated_at_31, u1_.medical_council_code AS medical_council_code_32, u1_.drugstore_code AS drugstore_code_33, u1_.drugstore_originator AS drugstore_originator_34, u1_.drugstore_license AS drugstore_license_35, u1_.drugstore_license_pic_ext AS drugstore_license_pic_ext_36, u1_.drugstore_hix AS drugstore_hix_37, u1_.drugstore_gln AS drugstore_gln_38, u1_.birth_date AS birth_date_39, u1_.status AS status_40, u1_.is_male AS is_male_41, u1_.is_information_complete AS is_information_complete_42, u1_.description AS description_43, u1_.operator_job_title AS operator_job_title_44, u1_.auth_code AS auth_code_45, u1_.trusted_version AS trusted_version_46, u1_.balance AS balance_47, u1_.operator_all_categories AS operator_all_categories_48, u1_.operator_all_license_owners AS operator_all_license_owners_49, u1_.cart_count AS cart_count_50, i0_.item_id AS item_id_51, i0_.drugstore_id AS drugstore_id_52, u1_.city_id AS city_id_53, u1_.type_id AS type_id_54 FROM item_drugstore i0_ INNER JOIN user u1_ ON i0_.drugstore_id = u1_.id INNER JOIN address a2_ ON u1_.id = a2_.user_id INNER JOIN drugstore_type d3_ ON u1_.type_id = d3_.id INNER JOIN item i4_ ON i0_.item_id = i4_.id WHERE i4_.id = 439524 AND u1_.status = 2 AND u1_.enabled = 1 AND i0_.exist = 1 AND i4_.status = 1 AND u1_.id <> NULL ORDER BY i0_.last_percent_price DESC LIMIT 20;
|
3 |
58.04 ms |
SELECT i0_.id AS id_0, i0_.name_en AS name_en_1, i0_.name_fa AS name_fa_2, i0_.brand_en AS brand_en_3, i0_.brand_fa AS brand_fa_4, i0_.name_brand_en AS name_brand_en_5, i0_.name_brand_fa AS name_brand_fa_6, i0_.erx_code AS erx_code_7, i0_.erx_code_base AS erx_code_base_8, i0_.rx_behdasht AS rx_behdasht_9, i0_.generic_code AS generic_code_10, i0_.mother_code AS mother_code_11, i0_.licence_owner AS licence_owner_12, i0_.brand_owner AS brand_owner_13, i0_.brand_owner_country AS brand_owner_country_14, i0_.producer AS producer_15, i0_.producer_country AS producer_country_16, i0_.name_interactive AS name_interactive_17, i0_.packing AS packing_18, i0_.form AS form_19, i0_.pregnancy_category AS pregnancy_category_20, i0_.other AS other_21, i0_.features AS features_22, i0_.video_id AS video_id_23, i0_.last_price AS last_price_24, i0_.only_doctor_user AS only_doctor_user_25, i0_.status AS status_26, RAND() AS sclr_27, i0_.license_owner_id AS license_owner_id_28 FROM item i0_ INNER JOIN item_category i2_ ON i0_.id = i2_.item_id INNER JOIN category c1_ ON c1_.id = i2_.category_id WHERE c1_.id = ? AND i0_.id <> ? ORDER BY sclr_27 ASC, i0_.id DESC LIMIT 8
Parameters: [
6518
439524
]
SELECT i0_.id AS id_0, i0_.name_en AS name_en_1, i0_.name_fa AS name_fa_2, i0_.brand_en AS brand_en_3, i0_.brand_fa AS brand_fa_4, i0_.name_brand_en AS name_brand_en_5, i0_.name_brand_fa AS name_brand_fa_6, i0_.erx_code AS erx_code_7, i0_.erx_code_base AS erx_code_base_8, i0_.rx_behdasht AS rx_behdasht_9, i0_.generic_code AS generic_code_10, i0_.mother_code AS mother_code_11, i0_.licence_owner AS licence_owner_12, i0_.brand_owner AS brand_owner_13, i0_.brand_owner_country AS brand_owner_country_14, i0_.producer AS producer_15, i0_.producer_country AS producer_country_16, i0_.name_interactive AS name_interactive_17, i0_.packing AS packing_18, i0_.form AS form_19, i0_.pregnancy_category AS pregnancy_category_20, i0_.other AS other_21, i0_.features AS features_22, i0_.video_id AS video_id_23, i0_.last_price AS last_price_24, i0_.only_doctor_user AS only_doctor_user_25, i0_.status AS status_26, RAND() AS sclr_27, i0_.license_owner_id AS license_owner_id_28 FROM item i0_ INNER JOIN item_category i2_ ON i0_.id = i2_.item_id INNER JOIN category c1_ ON c1_.id = i2_.category_id WHERE c1_.id = 6518 AND i0_.id <> 439524 ORDER BY sclr_27 ASC, i0_.id DESC LIMIT 8;
|
4 |
0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.level AS level_4, t0.pic_ext AS pic_ext_5, t0.features AS features_6, t0.raychat_code AS raychat_code_7, t0.visible AS visible_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.level AS level_4, t0.pic_ext AS pic_ext_5, t0.features AS features_6, t0.raychat_code AS raychat_code_7, t0.visible AS visible_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM category t0 WHERE t0.id = 6506;
|
5 |
0.20 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.level AS level_4, t0.pic_ext AS pic_ext_5, t0.features AS features_6, t0.raychat_code AS raychat_code_7, t0.visible AS visible_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.level AS level_4, t0.pic_ext AS pic_ext_5, t0.features AS features_6, t0.raychat_code AS raychat_code_7, t0.visible AS visible_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM category t0 WHERE t0.id = 6502;
|
6 |
0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.level AS level_4, t0.pic_ext AS pic_ext_5, t0.features AS features_6, t0.raychat_code AS raychat_code_7, t0.visible AS visible_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.level AS level_4, t0.pic_ext AS pic_ext_5, t0.features AS features_6, t0.raychat_code AS raychat_code_7, t0.visible AS visible_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM category t0 WHERE t0.id = 6136;
|
7 |
0.32 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 |
6.93 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 |
4.96 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 |
7.77 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.45 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.65 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 = 347266;
|
13 |
1.68 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 = 390399;
|
14 |
2.78 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 = 357473;
|
15 |
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 = 504617;
|
16 |
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 = 433168;
|
17 |
0.16 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 = 485406;
|
18 |
0.16 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 = 412747;
|
19 |
0.16 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 = 458513;
|
20 |
0.29 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;
|
21 |
2.71 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;
|
22 |
0.24 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;
|
23 |
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;
|