Query time 0.00500
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "140.69"
},
"ordering_operation": {
"using_temporary_table": true,
"using_filesort": true,
"nested_loop": [
{
"table": {
"table_name": "q_categories",
"access_type": "ALL",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"rows_examined_per_scan": 598,
"rows_produced_per_join": 2,
"filtered": "0.43",
"cost_info": {
"read_cost": "134.02",
"eval_cost": "0.51",
"prefix_cost": "134.53",
"data_read_per_join": "6K"
},
"used_columns": [
"category_id",
"parent_id",
"id_path",
"level",
"usergroup_ids",
"status",
"position",
"is_trash",
"ab__lc_catalog_image_control"
],
"attached_condition": "(((`portal`.`q_categories`.`usergroup_ids` = '') or find_in_set(0,`portal`.`q_categories`.`usergroup_ids`) or find_in_set(1,`portal`.`q_categories`.`usergroup_ids`)) and (`portal`.`q_categories`.`status` = 'A') and (`portal`.`q_categories`.`level` <= 3) and (`portal`.`q_categories`.`category_id` in (2,3,5,12,13,38,40,43,44,49,50,77,82,95,96,144,100,113,114,117,11,133,10,134,136,138,139,145,6,168,169,170,171,177,180,181,183,184,190,244,248,249,251,252,253,46,298,366,207,379,386,299,387,389,393,428,434,435,438,454,455,460,464,484,489,513,518,519,523,525,526,532,533,544,546,551,552)))"
}
},
{
"table": {
"table_name": "q_category_descriptions",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id",
"lang_code"
],
"key_length": "9",
"ref": [
"portal.q_categories.category_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 2,
"filtered": "100.00",
"cost_info": {
"read_cost": "2.57",
"eval_cost": "0.51",
"prefix_cost": "137.61",
"data_read_per_join": "7K"
},
"used_columns": [
"category_id",
"lang_code",
"category"
]
}
},
{
"table": {
"table_name": "q_seo_names",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"dispatch"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"type",
"dispatch",
"lang_code"
],
"key_length": "206",
"ref": [
"portal.q_categories.category_id",
"const",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 2,
"filtered": "100.00",
"cost_info": {
"read_cost": "2.57",
"eval_cost": "0.51",
"prefix_cost": "140.69",
"data_read_per_join": "4K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
]
}
}
}
Result
category_id |
parent_id |
id_path |
category |
position |
status |
seo_name |
seo_path |
ab__lc_catalog_image_control |
551 |
190 |
190/551 |
Tablets |
5 |
A |
tablets |
190 |
none |
169 |
168 |
6/168/169 |
Blenders |
10 |
A |
blenders |
6/168 |
none |
134 |
10 |
2/10/134 |
Face |
10 |
A |
face |
2/10 |
none |
3 |
2 |
2/3 |
Fragrance |
10 |
A |
fragrance |
2 |
none |
2 |
0 |
2 |
Health & Beauty |
10 |
A |
beauty |
|
none |
145 |
144 |
2/144/145 |
Shave & Hair Cutting |
10 |
A |
shave-and-hair-cutting |
2/144 |
none |
139 |
138 |
2/138/139 |
Toothbrushes |
10 |
A |
toothbrushes |
2/138 |
none |
249 |
248 |
248/249 |
Toys |
10 |
A |
toys |
248 |
none |
96 |
95 |
12/95/96 |
Women |
10 |
A |
women-watches |
12/95 |
none |
13 |
12 |
12/13 |
Womens Fashion |
10 |
A |
womens-fashion |
12 |
none |
251 |
249 |
248/249/251 |
Cars & Trucks |
20 |
A |
cars-and-trucks |
248/249 |
none |
6 |
0 |
6 |
Home & Decor |
20 |
A |
home-and-decor |
|
none |
170 |
168 |
6/168/170 |
Juicers |
20 |
A |
juicers |
6/168 |
none |
100 |
144 |
2/144/100 |
Make-Up |
20 |
A |
make-up |
2/144 |
none |
5 |
3 |
2/3/5 |
Men |
20 |
A |
men-fragrance |
2/3 |
none |
50 |
12 |
12/50 |
Mens Fashion |
20 |
A |
mens-fashion |
12 |
none |
546 |
544 |
248/544/546 |
School Bags |
20 |
A |
school-bags |
248/544 |
none |
38 |
13 |
12/13/38 |
Bags |
30 |
A |
women-bags |
12/13 |
none |
77 |
50 |
12/50/77 |
Bags |
30 |
A |
bags |
12/50 |
none |
252 |
249 |
248/249/252 |
Building & Blocks |
30 |
A |
building-and-blocks |
248/249 |
none |
366 |
144 |
2/144/366 |
Family Planning & Contraceptives |
30 |
A |
family-planning-and-contraceptives |
2/144 |
none |
12 |
0 |
12 |
Fashion |
30 |
A |
fashion |
|
none |
136 |
10 |
2/10/136 |
Feet |
30 |
A |
feet |
2/10 |
none |
454 |
438 |
6/438/454 |
Kitchen Utensils & Gadgets |
30 |
A |
kitchen-gadgets |
6/438 |
none |
171 |
168 |
6/168/171 |
Mixers |
30 |
A |
mixers |
6/168 |
none |
10 |
2 |
2/10 |
Skin Care |
30 |
A |
skin-care |
2 |
none |
168 |
6 |
6/168 |
Small Appliances |
30 |
A |
small-appliances |
6 |
none |
44 |
13 |
12/13/44 |
Accessories |
40 |
A |
women-accessories |
12/13 |
none |
460 |
438 |
6/438/460 |
Cookware |
40 |
A |
cookware |
6/438 |
none |
11 |
2 |
2/11 |
Hair Care |
40 |
A |
hair-care |
2 |
none |
133 |
11 |
2/11/133 |
Hair Treatment Products |
40 |
A |
hair-treatment-products |
2/11 |
none |
190 |
0 |
190 |
Mobiles & Tablets |
40 |
A |
mobiles-tablets |
|
none |
253 |
249 |
248/249/253 |
Puzzles & Boardgames |
40 |
A |
puzzles-and-boardgames |
248/249 |
none |
387 |
299 |
299/387 |
Scales |
40 |
A |
scales |
299 |
none |
184 |
6 |
6/184 |
Tools & Home Improvement |
40 |
A |
tools-and-home |
6 |
none |
95 |
12 |
12/95 |
Watches |
40 |
A |
watches |
12 |
none |
523 |
11 |
2/11/523 |
Hair Styling Tools |
50 |
A |
hair-styling-tools |
2/11 |
none |
138 |
2 |
2/138 |
Oral Care |
50 |
A |
oral-care |
2 |
none |
207 |
0 |
207 |
Sport & Fitness |
50 |
A |
sport-fitness |
|
none |
248 |
0 |
248 |
Kids Corner |
60 |
A |
kids-corner |
|
none |
144 |
2 |
2/144 |
Personal Care |
60 |
A |
personalcare |
2 |
none |
389 |
299 |
299/389 |
Security Cameras |
60 |
A |
security-cameras |
299 |
none |
299 |
0 |
299 |
Electronics |
70 |
A |
electronics |
|
none |
393 |
248 |
248/393 |
Electronics |
70 |
A |
electronics |
248 |
none |
177 |
168 |
6/168/177 |
Coffee Machines |
90 |
A |
coffee-machines |
6/168 |
none |
438 |
6 |
6/438 |
Kitchen & Dining |
90 |
A |
kitchen-dining |
6 |
none |
544 |
248 |
248/544 |
School & Stationery |
90 |
A |
school-and-stationery |
248 |
none |
434 |
249 |
248/249/434 |
Hobby |
100 |
A |
hobby |
248/249 |
none |
519 |
6 |
6/519 |
Large Appliances |
110 |
A |
large-appliances |
6 |
none |
552 |
299 |
299/552 |
Telephones & Accessories |
120 |
A |
telephones-and-accessories |
299 |
none |
180 |
168 |
6/168/180 |
Vacuum Cleaner |
120 |
A |
vacuum-cleaner |
6/168 |
none |
181 |
168 |
6/168/181 |
Iron & Steamers |
130 |
A |
iron-and-steamers |
6/168 |
none |
484 |
249 |
248/249/484 |
Toy Balls |
130 |
A |
toy-balls-en |
248/249 |
none |
533 |
249 |
248/249/533 |
Remote Control Toys |
140 |
A |
remote-control-toys |
248/249 |
none |
183 |
168 |
6/168/183 |
Kitchen Tools & Accessories |
150 |
A |
kitchen-tools-and-accessories |
6/168 |
none |
386 |
190 |
190/386 |
Headset |
160 |
A |
headset |
190 |
none |
379 |
207 |
207/379 |
Fitness Technology |
170 |
A |
fitness-technology |
207 |
none |
244 |
168 |
6/168/244 |
Kettles |
170 |
A |
kettles |
6/168 |
none |
518 |
168 |
6/168/518 |
Electric Cookers |
190 |
A |
electric-cookers |
6/168 |
none |
513 |
207 |
207/513 |
Exercise & Fitness Accessories |
190 |
A |
exercise-and-fitness-accessories |
207 |
none |
428 |
190 |
190/428 |
Mobile Holders & Stands |
190 |
A |
mobile-holders-and-stands |
190 |
none |