Query time 0.00691
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "91.32"
},
"ordering_operation": {
"using_temporary_table": true,
"using_filesort": true,
"nested_loop": [
{
"table": {
"table_name": "cscart_categories",
"access_type": "ref",
"possible_keys": [
"c_status",
"parent",
"id_path"
],
"key": "parent",
"used_key_parts": [
"parent_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 76,
"rows_produced_per_join": 0,
"filtered": "0.07",
"cost_info": {
"read_cost": "76.00",
"eval_cost": "0.01",
"prefix_cost": "91.20",
"data_read_per_join": "303"
},
"used_columns": [
"category_id",
"parent_id",
"id_path",
"company_id",
"usergroup_ids",
"status",
"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`.`id_path` like '2910/2916/%') 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.05",
"eval_cost": "0.01",
"prefix_cost": "91.26",
"data_read_per_join": "208"
},
"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.05",
"eval_cost": "0.01",
"prefix_cost": "91.32",
"data_read_per_join": "86"
},
"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 |
seo_name |
seo_path |
3064 |
2916 |
2910/2916/3064 |
Cardboard Cutouts |
0 |
A |
0 |
0 |
cardboard-cutouts |
2910/2916 |
3201 |
2916 |
2910/2916/3201 |
Dried Flowers |
0 |
A |
0 |
0 |
dried-flowers |
2910/2916 |
2926 |
2916 |
2910/2916/2926 |
Address Signs |
0 |
A |
0 |
0 |
address-signs |
2910/2916 |
2931 |
2916 |
2910/2916/2931 |
Artificial Flora |
0 |
A |
0 |
0 |
artificial-flora |
2910/2916 |
2940 |
2916 |
2910/2916/2940 |
Artificial Food |
0 |
A |
0 |
0 |
artificial-food |
2910/2916 |
2951 |
2916 |
2910/2916/2951 |
Artwork |
0 |
A |
0 |
0 |
artwork |
2910/2916 |
2978 |
2916 |
2910/2916/2978 |
Backrest Pillows |
0 |
A |
0 |
0 |
backrest-pillows |
2910/2916 |
2983 |
2916 |
2910/2916/2983 |
Baskets |
0 |
A |
0 |
0 |
baskets |
2910/2916 |
2989 |
2916 |
2910/2916/2989 |
Bird & Wildlife Feeder Accessories |
0 |
A |
0 |
0 |
bird-and-wildlife-feeder-accessories |
2910/2916 |
2993 |
2916 |
2910/2916/2993 |
Bird & Wildlife Feeders |
0 |
A |
0 |
0 |
bird-and-wildlife-feeders |
2910/2916 |
3014 |
2916 |
2910/2916/3014 |
Bird & Wildlife House Accessories |
0 |
A |
0 |
0 |
bird-and-wildlife-house-accessories |
2910/2916 |
3017 |
2916 |
2910/2916/3017 |
Bird & Wildlife Houses |
0 |
A |
0 |
0 |
bird-and-wildlife-houses |
2910/2916 |
3040 |
2916 |
2910/2916/3040 |
Bird Baths |
0 |
A |
0 |
0 |
bird-baths |
2910/2916 |
3052 |
2916 |
2910/2916/3052 |
Bookends |
0 |
A |
0 |
0 |
bookends |
2910/2916 |
3073 |
2916 |
2910/2916/3073 |
Chair & Sofa Cushions |
0 |
A |
0 |
0 |
chair-and-sofa-cushions |
2910/2916 |
3079 |
2916 |
2910/2916/3079 |
Clock Parts |
0 |
A |
0 |
0 |
clock-parts |
2910/2916 |
3087 |
2916 |
2910/2916/3087 |
Clocks |
0 |
A |
0 |
0 |
clocks |
2910/2916 |
3116 |
2916 |
2910/2916/3116 |
Coat & Hat Racks |
0 |
A |
0 |
0 |
coat-and-hat-racks |
2910/2916 |
3140 |
2916 |
2910/2916/3140 |
Decorative Bells |
0 |
A |
0 |
0 |
decorative-bells |
2910/2916 |
3145 |
2916 |
2910/2916/3145 |
Decorative Bottles |
0 |
A |
0 |
0 |
decorative-bottles |
2910/2916 |
3149 |
2916 |
2910/2916/3149 |
Decorative Bowls |
0 |
A |
0 |
0 |
decorative-bowls |
2910/2916 |
3153 |
2916 |
2910/2916/3153 |
Decorative Jars |
0 |
A |
0 |
0 |
decorative-jars |
2910/2916 |
3159 |
2916 |
2910/2916/3159 |
Decorative Plaques |
0 |
A |
0 |
0 |
decorative-plaques |
2910/2916 |
3181 |
2916 |
2910/2916/3181 |
Decorative Plates |
0 |
A |
0 |
0 |
decorative-plates |
2910/2916 |
3187 |
2916 |
2910/2916/3187 |
Decorative Trays |
0 |
A |
0 |
0 |
decorative-trays |
2910/2916 |
3192 |
2916 |
2910/2916/3192 |
Door Mats |
0 |
A |
0 |
0 |
door-mats |
2910/2916 |
3197 |
2916 |
2910/2916/3197 |
Dreamcatchers |
0 |
A |
0 |
0 |
dreamcatchers |
2910/2916 |
3206 |
2916 |
2910/2916/3206 |
Ecospheres |
0 |
A |
0 |
0 |
ecospheres |
2910/2916 |
3212 |
2916 |
2910/2916/3212 |
Figurines |
0 |
A |
0 |
0 |
figurines |
2910/2916 |
3217 |
2916 |
2910/2916/3217 |
Finials |
0 |
A |
0 |
0 |
finials |
2910/2916 |
3234 |
2916 |
2910/2916/3234 |
Flag & Windsock Accessories |
0 |
A |
0 |
0 |
flag-and-windsock-accessories |
2910/2916 |
3253 |
2916 |
2910/2916/3253 |
Flags & Windsocks |
0 |
A |
0 |
0 |
flags-and-windsocks |
2910/2916 |
9595 |
2916 |
2910/2916/9595 |
Mailboxe |
0 |
A |
0 |
0 |
mailboxe |
2910/2916 |
3096 |
2916 |
2910/2916/3096 |
Seasonal & Holiday Decorations |
0 |
A |
0 |
0 |
seasonal-and-holiday-decorations |
2910/2916 |
3221 |
2916 |
2910/2916/3221 |
Shadow Boxes |
0 |
A |
0 |
0 |
shadow-boxes |
2910/2916 |
3237 |
2916 |
2910/2916/3237 |
Slipcovers |
0 |
A |
0 |
0 |
slipcovers |
2910/2916 |
3243 |
2916 |
2910/2916/3243 |
Snow Globes |
0 |
A |
0 |
0 |
snow-globes |
2910/2916 |
3250 |
2916 |
2910/2916/3250 |
Suncatchers |
0 |
A |
0 |
0 |
suncatchers |
2910/2916 |
3256 |
2916 |
2910/2916/3256 |
Sundials |
380 |
A |
0 |
0 |
sundials |
2910/2916 |
3259 |
2916 |
2910/2916/3259 |
Flameless Candles |
390 |
A |
0 |
0 |
flameless-candles |
2910/2916 |
3264 |
2916 |
2910/2916/3264 |
Fountains & Ponds |
400 |
A |
0 |
0 |
fountains-and-ponds |
2910/2916 |
3270 |
2916 |
2910/2916/3270 |
Throw Pillows |
410 |
A |
0 |
0 |
throw-pillows |
2910/2916 |
3276 |
2916 |
2910/2916/3276 |
Trunks |
420 |
A |
0 |
0 |
trunks |
2910/2916 |
3282 |
2916 |
2910/2916/3282 |
Vase Fillers & Table Scatters |
430 |
A |
0 |
0 |
vase-fillers-and-table-scatters |
2910/2916 |
3306 |
2916 |
2910/2916/3306 |
Garden & Stepping Stones |
440 |
A |
0 |
0 |
garden-and-stepping-stones |
2910/2916 |
3308 |
2916 |
2910/2916/3308 |
Vases |
450 |
A |
0 |
0 |
vases |
2910/2916 |
3309 |
2916 |
2910/2916/3309 |
Growth Charts |
460 |
A |
0 |
0 |
growth-charts |
2910/2916 |
3312 |
2916 |
2910/2916/3312 |
Home Decor Decals |
470 |
A |
0 |
0 |
home-decor-decals |
2910/2916 |
3314 |
2916 |
2910/2916/3314 |
Wallpaper |
480 |
A |
0 |
0 |
wallpaper |
2910/2916 |
3317 |
2916 |
2910/2916/3317 |
Home Fragrance Accessories |
490 |
A |
0 |
0 |
home-fragrance-accessories |
2910/2916 |
3318 |
2916 |
2910/2916/3318 |
Weather Vanes & Roof Decor |
500 |
A |
0 |
0 |
weather-vanes-and-roof-decor |
2910/2916 |
3323 |
2916 |
2910/2916/3323 |
Wind Chimes |
510 |
A |
0 |
0 |
wind-chimes |
2910/2916 |
3334 |
2916 |
2910/2916/3334 |
Wind Wheels & Spinners |
520 |
A |
0 |
0 |
wind-wheels-and-spinners |
2910/2916 |
3335 |
2916 |
2910/2916/3335 |
Home Fragrances |
530 |
A |
0 |
0 |
home-fragrances |
2910/2916 |
3338 |
2916 |
2910/2916/3338 |
Window Magnets |
540 |
A |
0 |
0 |
window-magnets |
2910/2916 |
3343 |
2916 |
2910/2916/3343 |
Window Treatment Accessories |
550 |
A |
0 |
0 |
window-treatment-accessories |
2910/2916 |
3386 |
2916 |
2910/2916/3386 |
Hourglasses |
560 |
A |
0 |
0 |
hourglasses |
2910/2916 |
3401 |
2916 |
2910/2916/3401 |
House Numbers & Letters |
570 |
A |
0 |
0 |
house-numbers-and-letters |
2910/2916 |
3412 |
2916 |
2910/2916/3412 |
Lawn Ornaments & Garden Sculptures |
580 |
A |
0 |
0 |
lawn-ornaments-and-garden-sculptures |
2910/2916 |
3414 |
2916 |
2910/2916/3414 |
Window Treatments |
590 |
A |
0 |
0 |
window-treatments |
2910/2916 |
3423 |
2916 |
2910/2916/3423 |
Mail Slots |
600 |
A |
0 |
0 |
mail-slots |
2910/2916 |
3425 |
2916 |
2910/2916/3425 |
Mailbox Accessories |
610 |
A |
0 |
0 |
mailbox-accessories |
2910/2916 |
3453 |
2916 |
2910/2916/3453 |
Mailboxes |
620 |
A |
0 |
0 |
mailboxes |
2910/2916 |
3454 |
2916 |
2910/2916/3454 |
Mirrors |
630 |
A |
0 |
0 |
mirrors |
2910/2916 |
3459 |
2916 |
2910/2916/3459 |
Music Boxes |
640 |
A |
0 |
0 |
music-boxes |
2910/2916 |
3461 |
2916 |
2910/2916/3461 |
World Globes |
650 |
A |
0 |
0 |
world-globes |
2910/2916 |
3462 |
2916 |
2910/2916/3462 |
Napkin Rings |
660 |
A |
0 |
0 |
napkin-rings |
2910/2916 |
3468 |
2916 |
2910/2916/3468 |
Novelty Signs |
670 |
A |
0 |
0 |
novelty-signs |
2910/2916 |
3469 |
2916 |
2910/2916/3469 |
Wreaths & Garlands |
680 |
A |
0 |
0 |
wreaths-and-garlands |
2910/2916 |
3472 |
2916 |
2910/2916/3472 |
Ottoman Cushions |
690 |
A |
0 |
0 |
ottoman-cushions |
2910/2916 |
3478 |
2916 |
2910/2916/3478 |
Picture Frames |
700 |
A |
0 |
0 |
picture-frames |
2910/2916 |
3487 |
2916 |
2910/2916/3487 |
Piggy Banks & Money Jars |
710 |
A |
0 |
0 |
piggy-banks-and-money-jars |
2910/2916 |
3488 |
2916 |
2910/2916/3488 |
Rain Gauges |
720 |
A |
0 |
0 |
rain-gauges |
2910/2916 |
3491 |
2916 |
2910/2916/3491 |
Rain Chains |
730 |
A |
0 |
0 |
rain-chains |
2910/2916 |
3498 |
2916 |
2910/2916/3498 |
Refrigerator Magnets |
740 |
A |
0 |
0 |
refrigerator-magnets |
2910/2916 |
3507 |
2916 |
2910/2916/3507 |
Rugs |
750 |
A |
0 |
0 |
rugs |
2910/2916 |