1 |
11.37 ms |
SELECT count(DISTINCT i0_.id) AS sclr_0 FROM item i0_ INNER JOIN item_category i2_ ON i0_.id = i2_.item_id INNER JOIN category c1_ ON c1_.id = i2_.category_id LEFT JOIN item_media i3_ ON i0_.id = i3_.item_id AND (i3_.type = ?) INNER JOIN item_category i5_ ON i0_.id = i5_.item_id INNER JOIN category c4_ ON c4_.id = i5_.category_id INNER JOIN category c6_ ON c4_.parent_id = c6_.id INNER JOIN category c7_ ON c6_.parent_id = c7_.id INNER JOIN category c8_ ON c7_.parent_id = c8_.id WHERE (i0_.status <> ? AND i0_.status <> ?) AND c8_.visible = ? AND (c8_.id = ? OR c7_.id = ? OR c6_.id = ? OR c4_.id = ?) AND (i0_.name_brand_fa LIKE ? OR i0_.producer LIKE ?)
Parameters: [
1
0
3
1
6304
6304
6304
6304
"%%"
"%%"
]
SELECT count(DISTINCT i0_.id) AS sclr_0 FROM item i0_ INNER JOIN item_category i2_ ON i0_.id = i2_.item_id INNER JOIN category c1_ ON c1_.id = i2_.category_id LEFT JOIN item_media i3_ ON i0_.id = i3_.item_id AND (i3_.type = 1) INNER JOIN item_category i5_ ON i0_.id = i5_.item_id INNER JOIN category c4_ ON c4_.id = i5_.category_id INNER JOIN category c6_ ON c4_.parent_id = c6_.id INNER JOIN category c7_ ON c6_.parent_id = c7_.id INNER JOIN category c8_ ON c7_.parent_id = c8_.id WHERE (i0_.status <> 0 AND i0_.status <> 3) AND c8_.visible = 1 AND (c8_.id = 6304 OR c7_.id = 6304 OR c6_.id = 6304 OR c4_.id = 6304) AND (i0_.name_brand_fa LIKE '%%' OR i0_.producer LIKE '%%');
|
2 |
3.02 ms |
SELECT DISTINCT i0_.id AS id_0 FROM item i0_ INNER JOIN item_category i2_ ON i0_.id = i2_.item_id INNER JOIN category c1_ ON c1_.id = i2_.category_id LEFT JOIN item_media i3_ ON i0_.id = i3_.item_id AND (i3_.type = ?) INNER JOIN item_category i5_ ON i0_.id = i5_.item_id INNER JOIN category c4_ ON c4_.id = i5_.category_id INNER JOIN category c6_ ON c4_.parent_id = c6_.id INNER JOIN category c7_ ON c6_.parent_id = c7_.id INNER JOIN category c8_ ON c7_.parent_id = c8_.id WHERE (i0_.status <> ? AND i0_.status <> ?) AND c8_.visible = ? AND (c8_.id = ? OR c7_.id = ? OR c6_.id = ? OR c4_.id = ?) AND (i0_.name_brand_fa LIKE ? OR i0_.producer LIKE ?) LIMIT 20
Parameters: [
1
0
3
1
6304
6304
6304
6304
"%%"
"%%"
]
SELECT DISTINCT i0_.id AS id_0 FROM item i0_ INNER JOIN item_category i2_ ON i0_.id = i2_.item_id INNER JOIN category c1_ ON c1_.id = i2_.category_id LEFT JOIN item_media i3_ ON i0_.id = i3_.item_id AND (i3_.type = 1) INNER JOIN item_category i5_ ON i0_.id = i5_.item_id INNER JOIN category c4_ ON c4_.id = i5_.category_id INNER JOIN category c6_ ON c4_.parent_id = c6_.id INNER JOIN category c7_ ON c6_.parent_id = c7_.id INNER JOIN category c8_ ON c7_.parent_id = c8_.id WHERE (i0_.status <> 0 AND i0_.status <> 3) AND c8_.visible = 1 AND (c8_.id = 6304 OR c7_.id = 6304 OR c6_.id = 6304 OR c4_.id = 6304) AND (i0_.name_brand_fa LIKE '%%' OR i0_.producer LIKE '%%') LIMIT 20;
|
3 |
2.36 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, c1_.id AS id_27, c1_.name AS name_28, c1_.code AS code_29, c1_.level AS level_30, c1_.pic_ext AS pic_ext_31, c1_.features AS features_32, c1_.raychat_code AS raychat_code_33, c1_.visible AS visible_34, c1_.updated_at AS updated_at_35, i2_.id AS id_36, i2_.pic_ext AS pic_ext_37, i2_.type AS type_38, i2_.updated_at AS updated_at_39, i0_.license_owner_id AS license_owner_id_40, c1_.parent_id AS parent_id_41, i2_.item_id AS item_id_42 FROM item i0_ INNER JOIN item_category i3_ ON i0_.id = i3_.item_id INNER JOIN category c1_ ON c1_.id = i3_.category_id LEFT JOIN item_media i2_ ON i0_.id = i2_.item_id AND (i2_.type = ?) INNER JOIN item_category i5_ ON i0_.id = i5_.item_id INNER JOIN category c4_ ON c4_.id = i5_.category_id INNER JOIN category c6_ ON c4_.parent_id = c6_.id INNER JOIN category c7_ ON c6_.parent_id = c7_.id INNER JOIN category c8_ ON c7_.parent_id = c8_.id WHERE (i0_.status <> ? AND i0_.status <> ?) AND c8_.visible = ? AND (c8_.id = ? OR c7_.id = ? OR c6_.id = ? OR c4_.id = ?) AND (i0_.name_brand_fa LIKE ? OR i0_.producer LIKE ?) AND i0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: [
1
0
3
1
6304
6304
6304
6304
"%%"
"%%"
316881
316887
316909
316943
317018
317019
317020
317021
317023
317026
317027
317028
317029
317030
317032
317035
317036
317037
317038
317040
]
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,
c1_.id AS id_27,
c1_.name AS name_28,
c1_.code AS code_29,
c1_.level AS level_30,
c1_.pic_ext AS pic_ext_31,
c1_.features AS features_32,
c1_.raychat_code AS raychat_code_33,
c1_.visible AS visible_34,
c1_.updated_at AS updated_at_35,
i2_.id AS id_36,
i2_.pic_ext AS pic_ext_37,
i2_.type AS type_38,
i2_.updated_at AS updated_at_39,
i0_.license_owner_id AS license_owner_id_40,
c1_.parent_id AS parent_id_41,
i2_.item_id AS item_id_42
FROM
item i0_
INNER JOIN item_category i3_ ON i0_.id = i3_.item_id
INNER JOIN category c1_ ON c1_.id = i3_.category_id
LEFT JOIN item_media i2_ ON i0_.id = i2_.item_id
AND (i2_.type = ?)
INNER JOIN item_category i5_ ON i0_.id = i5_.item_id
INNER JOIN category c4_ ON c4_.id = i5_.category_id
INNER JOIN category c6_ ON c4_.parent_id = c6_.id
INNER JOIN category c7_ ON c6_.parent_id = c7_.id
INNER JOIN category c8_ ON c7_.parent_id = c8_.id
WHERE
(
i0_.status <> ?
AND i0_.status <> ?
)
AND c8_.visible = ?
AND (
c8_.id = ?
OR c7_.id = ?
OR c6_.id = ?
OR c4_.id = ?
)
AND (
i0_.name_brand_fa LIKE ?
OR i0_.producer LIKE ?
)
AND i0_.id IN (
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?
)
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, c1_.id AS id_27, c1_.name AS name_28, c1_.code AS code_29, c1_.level AS level_30, c1_.pic_ext AS pic_ext_31, c1_.features AS features_32, c1_.raychat_code AS raychat_code_33, c1_.visible AS visible_34, c1_.updated_at AS updated_at_35, i2_.id AS id_36, i2_.pic_ext AS pic_ext_37, i2_.type AS type_38, i2_.updated_at AS updated_at_39, i0_.license_owner_id AS license_owner_id_40, c1_.parent_id AS parent_id_41, i2_.item_id AS item_id_42 FROM item i0_ INNER JOIN item_category i3_ ON i0_.id = i3_.item_id INNER JOIN category c1_ ON c1_.id = i3_.category_id LEFT JOIN item_media i2_ ON i0_.id = i2_.item_id AND (i2_.type = 1) INNER JOIN item_category i5_ ON i0_.id = i5_.item_id INNER JOIN category c4_ ON c4_.id = i5_.category_id INNER JOIN category c6_ ON c4_.parent_id = c6_.id INNER JOIN category c7_ ON c6_.parent_id = c7_.id INNER JOIN category c8_ ON c7_.parent_id = c8_.id WHERE (i0_.status <> 0 AND i0_.status <> 3) AND c8_.visible = 1 AND (c8_.id = 6304 OR c7_.id = 6304 OR c6_.id = 6304 OR c4_.id = 6304) AND (i0_.name_brand_fa LIKE '%%' OR i0_.producer LIKE '%%') AND i0_.id IN (316881, 316887, 316909, 316943, 317018, 317019, 317020, 317021, 317023, 317026, 317027, 317028, 317029, 317030, 317032, 317035, 317036, 317037, 317038, 317040);
|
4 |
0.37 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;
|
5 |
2.54 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;
|
6 |
0.33 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;
|
7 |
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;
|
8 |
0.28 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;
|
9 |
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;
|
10 |
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 = 2 ORDER BY t0.order ASC;
|
11 |
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;
|
12 |
0.19 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;
|