Query time 0.00330
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "79.37"
},
"ordering_operation": {
"using_temporary_table": true,
"using_filesort": true,
"nested_loop": [
{
"table": {
"table_name": "q_categories",
"access_type": "range",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"rows_examined_per_scan": 32,
"rows_produced_per_join": 1,
"filtered": "3.33",
"index_condition": "(`portal`.`q_categories`.`category_id` in (6,184,185,190,193,194,196,199,200,201,202,301,300,375,299,382,383,386,402,191,418,424,428,429,445,446,482,207,513,248,544,545))",
"cost_info": {
"read_cost": "76.60",
"eval_cost": "0.21",
"prefix_cost": "76.81",
"data_read_per_join": "2K"
},
"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))"
}
},
{
"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": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.07",
"eval_cost": "0.21",
"prefix_cost": "78.09",
"data_read_per_join": "3K"
},
"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": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.07",
"eval_cost": "0.21",
"prefix_cost": "79.37",
"data_read_per_join": "1K"
},
"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 |
301 |
0 |
301 |
Products |
0 |
A |
products |
|
none |
191 |
190 |
190/191 |
Cover Cases |
10 |
A |
cases |
190 |
none |
446 |
445 |
6/445/446 |
Cleaning Supplies & Tools |
10 |
A |
cleaning-tools |
6/445 |
none |
375 |
300 |
300/375 |
Interior Accessories |
10 |
A |
interior-accessories |
300 |
none |
418 |
191 |
190/191/418 |
Mobile Cover Case |
10 |
A |
mobile-cover-case |
190/191 |
none |
185 |
184 |
6/184/185 |
Power Tools |
10 |
A |
power-tools |
6/184 |
none |
382 |
299 |
299/382 |
Speakers |
10 |
A |
speakers |
299 |
none |
545 |
544 |
248/544/545 |
Stationery |
10 |
A |
stationery |
248/544 |
none |
402 |
383 |
299/383/402 |
Cables, Adapters & Connectors |
20 |
A |
cables-adapters-and-connectors |
299/383 |
none |
383 |
299 |
299/383 |
Computer & Laptop Accessories |
20 |
A |
computer-and-laptop-accessories |
299 |
none |
6 |
0 |
6 |
Home & Decor |
20 |
A |
home-and-decor |
|
none |
193 |
190 |
190/193 |
Chargers & Power Adapters |
30 |
A |
chargers-and-power-adapters |
190 |
none |
194 |
190 |
190/194 |
Batteries & Power Banks |
40 |
A |
batteries-and-powerbanks |
190 |
none |
190 |
0 |
190 |
Mobiles & Tablets |
40 |
A |
mobiles-tablets |
|
none |
184 |
6 |
6/184 |
Tools & Home Improvement |
40 |
A |
tools-and-home |
6 |
none |
207 |
0 |
207 |
Sport & Fitness |
50 |
A |
sport-fitness |
|
none |
196 |
190 |
190/196 |
Selfie Sticks & Tripods |
60 |
A |
selfie-sticks-and-tripods |
190 |
none |
248 |
0 |
248 |
Kids Corner |
60 |
A |
kids-corner |
|
none |
299 |
0 |
299 |
Electronics |
70 |
A |
electronics |
|
none |
300 |
0 |
300 |
Automotive |
80 |
A |
automotive |
|
none |
199 |
190 |
190/199 |
Car Accessories |
90 |
A |
car-accessories |
190 |
none |
544 |
248 |
248/544 |
School & Stationery |
90 |
A |
school-and-stationery |
248 |
none |
200 |
190 |
190/200 |
Corded Headsets |
100 |
A |
corded-headsets |
190 |
none |
445 |
6 |
6/445 |
Household Supplies |
100 |
A |
house-supplies |
6 |
none |
201 |
190 |
190/201 |
Bluetooth Headsets |
110 |
A |
bluetooth-headsets |
190 |
none |
202 |
190 |
190/202 |
Cables & Connectors |
120 |
A |
selfie-sticks-and-tripods-en |
190 |
none |
386 |
190 |
190/386 |
Headset |
160 |
A |
headset |
190 |
none |
424 |
190 |
190/424 |
Bluetooth Speakers |
180 |
A |
bluetooth-speakers |
190 |
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 |
429 |
190 |
190/429 |
Mobile Tools & Accessories |
200 |
A |
mobile-tools-and-accessories |
190 |
none |