Query time 0.00192
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "41.55"
},
"ordering_operation": {
"using_temporary_table": true,
"using_filesort": true,
"nested_loop": [
{
"table": {
"table_name": "cscart_categories",
"access_type": "range",
"possible_keys": [
"c_status",
"id_path"
],
"key": "id_path",
"used_key_parts": [
"id_path"
],
"key_length": "767",
"rows_examined_per_scan": 28,
"rows_produced_per_join": 0,
"filtered": "2.00",
"index_condition": "(`webmarco`.`cscart_categories`.`id_path` like '1467/%')",
"cost_info": {
"read_cost": "40.10",
"eval_cost": "0.11",
"prefix_cost": "40.21",
"data_read_per_join": "3K"
},
"used_columns": [
"category_id",
"parent_id",
"id_path",
"company_id",
"usergroup_ids",
"status",
"product_count",
"position",
"is_trash",
"storefront_id"
],
"attached_condition": "(((`webmarco`.`cscart_categories`.`usergroup_ids` = '') or find_in_set(0,`webmarco`.`cscart_categories`.`usergroup_ids`) or find_in_set(1,`webmarco`.`cscart_categories`.`usergroup_ids`)) and (`webmarco`.`cscart_categories`.`status` = 'A') and (`webmarco`.`cscart_categories`.`storefront_id` in (0,1)))"
}
},
{
"table": {
"table_name": "cscart_category_descriptions",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id",
"lang_code"
],
"key_length": "9",
"ref": [
"webmarco.cscart_categories.category_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.56",
"eval_cost": "0.11",
"prefix_cost": "40.88",
"data_read_per_join": "2K"
},
"used_columns": [
"category_id",
"lang_code",
"category"
]
}
},
{
"table": {
"table_name": "cscart_seo_names",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"dispatch"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"type",
"dispatch",
"lang_code"
],
"key_length": "206",
"ref": [
"webmarco.cscart_categories.category_id",
"const",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.56",
"eval_cost": "0.11",
"prefix_cost": "41.55",
"data_read_per_join": "972"
},
"used_columns": [
"name",
"object_id",
"company_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
]
}
}
}
Result
category_id |
parent_id |
id_path |
category |
position |
status |
company_id |
storefront_id |
product_count |
seo_name |
seo_path |
9964 |
1467 |
1467/9964 |
Backpacks |
0 |
A |
0 |
0 |
730 |
backpacks-en |
1467 |
9974 |
1467 |
1467/9974 |
Luggage Accessories |
0 |
A |
0 |
0 |
0 |
luggage-accessories-en |
1467 |
9975 |
9974 |
1467/9974/9975 |
Luggage Straps |
0 |
A |
0 |
0 |
22 |
luggage-straps |
1467/9974 |
9976 |
3473 |
1467/3473/9976 |
Luggage Straps |
0 |
A |
0 |
0 |
72 |
luggage-straps-en |
1467/3473 |
3479 |
3473 |
1467/3473/3479 |
Packing Organizers |
10 |
A |
0 |
0 |
27 |
packing-organizers |
1467/3473 |
3480 |
3473 |
1467/3473/3480 |
Dry Box Liners & Inserts |
20 |
A |
0 |
0 |
0 |
dry-box-liners-and-inserts |
1467/3473 |
3483 |
3473 |
1467/3473/3483 |
Luggage Covers |
30 |
A |
0 |
0 |
0 |
luggage-covers |
1467/3473 |
3486 |
3473 |
1467/3473/3486 |
Travel Bottles & Containers |
40 |
A |
0 |
0 |
2 |
travel-bottles-and-containers |
1467/3473 |
3494 |
3473 |
1467/3473/3494 |
Luggage Racks & Stands |
50 |
A |
0 |
0 |
0 |
luggage-racks-and-stands |
1467/3473 |
505 |
1467 |
1467/505 |
Backpacks |
60 |
A |
0 |
0 |
497 |
backpacks |
1467 |
3496 |
3473 |
1467/3473/3496 |
Travel Pouches |
60 |
A |
0 |
0 |
12 |
travel-pouches |
1467/3473 |
3511 |
3473 |
1467/3473/3511 |
Luggage Straps |
70 |
A |
0 |
0 |
146 |
luggage-straps |
1467/3473 |
3517 |
3473 |
1467/3473/3517 |
Luggage Tags |
80 |
A |
0 |
0 |
0 |
luggage-tags |
1467/3473 |
1471 |
1467 |
1467/1471 |
Luggage |
100 |
A |
0 |
0 |
162 |
luggage |
1467 |
1472 |
1467 |
1467/1472 |
Briefcases |
110 |
A |
0 |
0 |
9 |
work-wallets-and-briefcases |
1467 |
1473 |
1467 |
1467/1473 |
Travel Duffels & Totes |
120 |
A |
0 |
0 |
5 |
travel-duffels-and-totes |
1467 |
1476 |
1467 |
1467/1476 |
Travel Accessories |
150 |
A |
0 |
0 |
9 |
travel-accessories |
1467 |
3076 |
1467 |
1467/3076 |
Diaper Bags |
160 |
A |
0 |
0 |
5 |
diaper-bags |
1467 |
3504 |
1467 |
1467/3504 |
Cosmetic & Toiletry Bags |
1030 |
A |
0 |
0 |
7 |
cosmetic-and-toiletry-bags |
1467 |
3242 |
1467 |
1467/3242 |
Messenger Bags |
1030 |
A |
0 |
0 |
7 |
messenger-bags |
1467 |
3422 |
1467 |
1467/3422 |
Suitcases |
1040 |
A |
0 |
0 |
4 |
suitcases |
1467 |
3509 |
1467 |
1467/3509 |
Dry Boxes |
1040 |
A |
0 |
0 |
0 |
dry-boxes |
1467 |
3473 |
1467 |
1467/3473 |
Luggage Accessories |
1050 |
A |
0 |
0 |
11 |
luggage-accessories |
1467 |
3476 |
1467 |
1467/3476 |
Duffel Bags |
1060 |
A |
0 |
0 |
1 |
duffel-bags |
1467 |
3490 |
1467 |
1467/3490 |
Shopping Totes |
1070 |
A |
0 |
0 |
7 |
shopping-totes |
1467 |
3492 |
1467 |
1467/3492 |
Fanny Packs |
1080 |
A |
0 |
0 |
0 |
fanny-packs |
1467 |
3505 |
1467 |
1467/3505 |
Garment Bags |
1090 |
A |
0 |
0 |
0 |
garment-bags |
1467 |
3512 |
1467 |
1467/3512 |
Train Cases |
1100 |
A |
0 |
0 |
0 |
train-cases |
1467 |