Query time 0.00270
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "83.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": 57,
"rows_produced_per_join": 1,
"filtered": "2.00",
"index_condition": "(`webmarco`.`cscart_categories`.`id_path` like '5372/6196/%')",
"cost_info": {
"read_cost": "80.58",
"eval_cost": "0.23",
"prefix_cost": "80.81",
"data_read_per_join": "6K"
},
"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": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.14",
"eval_cost": "0.23",
"prefix_cost": "82.18",
"data_read_per_join": "4K"
},
"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": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.14",
"eval_cost": "0.23",
"prefix_cost": "83.55",
"data_read_per_join": "1K"
},
"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 |
6901 |
6887 |
5372/6196/6887/6901 |
Disco Balls |
10 |
A |
0 |
0 |
0 |
disco-balls |
5372/6196/6887 |
6460 |
6446 |
5372/6196/6446/6460 |
Advice Cards |
10 |
A |
0 |
0 |
44 |
advice-cards |
5372/6196/6446 |
6985 |
6970 |
5372/6196/6970/6985 |
Award Certificates |
10 |
A |
0 |
0 |
0 |
award-certificates |
5372/6196/6970 |
6546 |
6533 |
5372/6196/6446/6533/6546 |
Beer Pong |
10 |
A |
0 |
0 |
0 |
beer-pong |
5372/6196/6446/6533 |
6557 |
6546 |
5372/6196/6446/6533/6546/6557 |
Beer Pong Tables |
10 |
A |
0 |
0 |
0 |
beer-pong-tables |
5372/6196/6446/6533/6546 |
6329 |
6318 |
5372/6196/6231/6318/6329 |
Gift Bags |
10 |
A |
0 |
0 |
36 |
gift-bags |
5372/6196/6231/6318 |
6231 |
6196 |
5372/6196/6231 |
Gift Giving |
10 |
A |
0 |
0 |
190 |
gift-giving |
5372/6196 |
6432 |
6231 |
5372/6196/6231/6432 |
Greeting & Note Cards |
10 |
A |
0 |
0 |
58 |
greeting-and-note-cards |
5372/6196/6231 |
6732 |
6707 |
5372/6196/6446/6707/6732 |
Wedding Favors |
10 |
A |
0 |
0 |
1 |
wedding-favors |
5372/6196/6446/6707 |
6998 |
6970 |
5372/6196/6970/6998 |
Award Pins & Medals |
20 |
A |
0 |
0 |
0 |
award-pins-and-medals |
5372/6196/6970 |
6470 |
6446 |
5372/6196/6446/6470 |
Balloon Kits |
20 |
A |
0 |
0 |
414 |
balloon-kits |
5372/6196/6446 |
6252 |
6231 |
5372/6196/6231/6252 |
Corsage & Boutonniere Pins |
20 |
A |
0 |
0 |
0 |
corsage-and-boutonniare-pins |
5372/6196/6231 |
6912 |
6887 |
5372/6196/6887/6912 |
Fog Machines |
20 |
A |
0 |
0 |
0 |
fog-machines |
5372/6196/6887 |
6344 |
6318 |
5372/6196/6231/6318/6344 |
Gift Boxes & Tins |
20 |
A |
0 |
0 |
130 |
gift-boxes-and-tins |
5372/6196/6231/6318 |
7007 |
6970 |
5372/6196/6970/7007 |
Award Plaques |
30 |
A |
0 |
0 |
0 |
award-plaques |
5372/6196/6970 |
6477 |
6446 |
5372/6196/6446/6477 |
Balloons |
30 |
A |
0 |
0 |
867 |
balloons |
5372/6196/6446 |
6269 |
6231 |
5372/6196/6231/6269 |
Corsage & Boutonnieres |
30 |
A |
0 |
0 |
0 |
corsages-and-boutonniares |
5372/6196/6231 |
6356 |
6318 |
5372/6196/6231/6318/6356 |
Gift Tags & Labels |
30 |
A |
0 |
0 |
2 |
gift-tags-and-labels |
5372/6196/6231/6318 |
6922 |
6887 |
5372/6196/6887/6922 |
Special Effects Controllers |
30 |
A |
0 |
0 |
0 |
special-effects-controllers |
5372/6196/6887 |
7016 |
6970 |
5372/6196/6970/7016 |
Award Ribbons |
40 |
A |
0 |
0 |
0 |
award-ribbons |
5372/6196/6970 |
6486 |
6446 |
5372/6196/6446/6486 |
Banners |
40 |
A |
0 |
0 |
0 |
banners |
5372/6196/6446 |
6282 |
6231 |
5372/6196/6231/6282 |
Fresh Cut Flowers |
40 |
A |
0 |
0 |
0 |
fresh-cut-flowers |
5372/6196/6231 |
6940 |
6887 |
5372/6196/6887/6940 |
Special Effects Light Stands |
40 |
A |
0 |
0 |
0 |
special-effects-light-stands |
5372/6196/6887 |
6369 |
6318 |
5372/6196/6231/6318/6369 |
Tissue Paper |
40 |
A |
0 |
0 |
0 |
tissue-paper |
5372/6196/6231/6318 |
6497 |
6446 |
5372/6196/6446/6497 |
Birthday Candles |
50 |
A |
0 |
0 |
562 |
birthday-candles |
5372/6196/6446 |
6297 |
6231 |
5372/6196/6231/6297 |
Gift Cards & Certificates |
50 |
A |
0 |
0 |
8 |
gift-cards-and-certificates |
5372/6196/6231 |
6952 |
6887 |
5372/6196/6887/6952 |
Special Effects Lighting |
50 |
A |
0 |
0 |
0 |
special-effects-lighting |
5372/6196/6887 |
7044 |
6970 |
5372/6196/6970/7044 |
Trophies |
50 |
A |
0 |
0 |
0 |
trophies |
5372/6196/6970 |
6376 |
6318 |
5372/6196/6231/6318/6376 |
Wrapping Paper |
50 |
A |
0 |
0 |
3 |
wrapping-paper |
5372/6196/6231/6318 |
6503 |
6446 |
5372/6196/6446/6503 |
Chair Sashes |
60 |
A |
0 |
0 |
0 |
chair-sashes |
5372/6196/6446 |
6318 |
6231 |
5372/6196/6231/6318 |
Gift Wrapping |
60 |
A |
0 |
0 |
38 |
gift-wrapping |
5372/6196/6231 |
6511 |
6446 |
5372/6196/6446/6511 |
Cocktail Decorations |
70 |
A |
0 |
0 |
1 |
cocktail-decorations |
5372/6196/6446 |
6446 |
6196 |
5372/6196/6446 |
Party Supplies |
70 |
A |
0 |
0 |
961 |
party-supplies |
5372/6196 |
6517 |
6446 |
5372/6196/6446/6517 |
Confetti |
80 |
A |
0 |
0 |
0 |
confetti |
5372/6196/6446 |
6887 |
6196 |
5372/6196/6887 |
Special Effects |
80 |
A |
0 |
0 |
0 |
special-effects |
5372/6196 |
6523 |
6446 |
5372/6196/6446/6523 |
Decorative Pom-Poms |
90 |
A |
0 |
0 |
4 |
decorative-pom-poms |
5372/6196/6446 |
6970 |
6196 |
5372/6196/6970 |
Trophies & Awards |
90 |
A |
0 |
0 |
0 |
trophies-and-awards |
5372/6196 |
6533 |
6446 |
5372/6196/6446/6533 |
Drinking Games |
100 |
A |
0 |
0 |
0 |
drinking-games |
5372/6196/6446 |
6586 |
6446 |
5372/6196/6446/6586 |
Drinking Straws & Stirrers |
110 |
A |
0 |
0 |
19 |
drinking-straws-and-stirrers |
5372/6196/6446 |
6602 |
6446 |
5372/6196/6446/6602 |
Envelope Seals |
120 |
A |
0 |
0 |
0 |
envelope-seals |
5372/6196/6446 |
6611 |
6446 |
5372/6196/6446/6611 |
Event Programs |
130 |
A |
0 |
0 |
0 |
event-programs |
5372/6196/6446 |
6623 |
6446 |
5372/6196/6446/6623 |
Fireworks & Firecrackers |
140 |
A |
0 |
0 |
0 |
fireworks-and-firecrackers |
5372/6196/6446 |
6640 |
6446 |
5372/6196/6446/6640 |
Inflatable Party Decorations |
150 |
A |
0 |
0 |
850 |
inflatable-party-decorations |
5372/6196/6446 |
6657 |
6446 |
5372/6196/6446/6657 |
Invitations |
160 |
A |
0 |
0 |
2 |
invitations |
5372/6196/6446 |
6671 |
6446 |
5372/6196/6446/6671 |
Noisemakers & Party Blowers |
170 |
A |
0 |
0 |
2 |
noisemakers-and-party-blowers |
5372/6196/6446 |
6707 |
6446 |
5372/6196/6446/6707 |
Party Favors |
180 |
A |
0 |
0 |
1 |
party-favors |
5372/6196/6446 |
6751 |
6446 |
5372/6196/6446/6751 |
Party Games |
190 |
A |
0 |
0 |
17 |
party-games |
5372/6196/6446 |
6766 |
6446 |
5372/6196/6446/6766 |
Party Hats |
200 |
A |
0 |
0 |
1 |
party-hats |
5372/6196/6446 |
6778 |
6446 |
5372/6196/6446/6778 |
Party Streamers & Curtains |
210 |
A |
0 |
0 |
0 |
party-streamers-and-curtains |
5372/6196/6446 |
6789 |
6446 |
5372/6196/6446/6789 |
Party Supply Kits |
220 |
A |
0 |
0 |
338 |
party-supply-kit |
5372/6196/6446 |
6817 |
6446 |
5372/6196/6446/6817 |
Place Card Holders |
230 |
A |
0 |
0 |
0 |
place-card-holders |
5372/6196/6446 |
6826 |
6446 |
5372/6196/6446/6826 |
Place Cards |
240 |
A |
0 |
0 |
2 |
place-cards |
5372/6196/6446 |
6833 |
6446 |
5372/6196/6446/6833 |
Response Cards |
250 |
A |
0 |
0 |
0 |
response-cards |
5372/6196/6446 |
6843 |
6446 |
5372/6196/6446/6843 |
Sparklers |
260 |
A |
0 |
0 |
0 |
sparklers |
5372/6196/6446 |
6849 |
6446 |
5372/6196/6446/6849 |
Special Occasion Card Boxes & Holders |
270 |
A |
0 |
0 |
1 |
special-occasion-card-boxes-and-holders |
5372/6196/6446 |
6861 |
6446 |
5372/6196/6446/6861 |
Spray String |
280 |
A |
0 |
0 |
0 |
spray-string |
5372/6196/6446 |
8986 |
6446 |
5372/6196/6446/8986 |
Pinatas |
290 |
A |
0 |
0 |
0 |
pinatas |
5372/6196/6446 |