Query time 0.00150
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "34.92"
},
"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": 29,
"rows_produced_per_join": 0,
"filtered": "0.17",
"cost_info": {
"read_cost": "29.00",
"eval_cost": "0.01",
"prefix_cost": "34.80",
"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 '5372/6196/6446/%') 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": "34.86",
"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": "34.92",
"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 |
6460 |
6446 |
5372/6196/6446/6460 |
Advice Cards |
10 |
A |
0 |
0 |
advice-cards |
5372/6196/6446 |
6470 |
6446 |
5372/6196/6446/6470 |
Balloon Kits |
20 |
A |
0 |
0 |
balloon-kits |
5372/6196/6446 |
6477 |
6446 |
5372/6196/6446/6477 |
Balloons |
30 |
A |
0 |
0 |
balloons |
5372/6196/6446 |
6486 |
6446 |
5372/6196/6446/6486 |
Banners |
40 |
A |
0 |
0 |
banners |
5372/6196/6446 |
6497 |
6446 |
5372/6196/6446/6497 |
Birthday Candles |
50 |
A |
0 |
0 |
birthday-candles |
5372/6196/6446 |
6503 |
6446 |
5372/6196/6446/6503 |
Chair Sashes |
60 |
A |
0 |
0 |
chair-sashes |
5372/6196/6446 |
6511 |
6446 |
5372/6196/6446/6511 |
Cocktail Decorations |
70 |
A |
0 |
0 |
cocktail-decorations |
5372/6196/6446 |
6517 |
6446 |
5372/6196/6446/6517 |
Confetti |
80 |
A |
0 |
0 |
confetti |
5372/6196/6446 |
6523 |
6446 |
5372/6196/6446/6523 |
Decorative Pom-Poms |
90 |
A |
0 |
0 |
decorative-pom-poms |
5372/6196/6446 |
6533 |
6446 |
5372/6196/6446/6533 |
Drinking Games |
100 |
A |
0 |
0 |
drinking-games |
5372/6196/6446 |
6586 |
6446 |
5372/6196/6446/6586 |
Drinking Straws & Stirrers |
110 |
A |
0 |
0 |
drinking-straws-and-stirrers |
5372/6196/6446 |
6602 |
6446 |
5372/6196/6446/6602 |
Envelope Seals |
120 |
A |
0 |
0 |
envelope-seals |
5372/6196/6446 |
6611 |
6446 |
5372/6196/6446/6611 |
Event Programs |
130 |
A |
0 |
0 |
event-programs |
5372/6196/6446 |
6623 |
6446 |
5372/6196/6446/6623 |
Fireworks & Firecrackers |
140 |
A |
0 |
0 |
fireworks-and-firecrackers |
5372/6196/6446 |
6640 |
6446 |
5372/6196/6446/6640 |
Inflatable Party Decorations |
150 |
A |
0 |
0 |
inflatable-party-decorations |
5372/6196/6446 |
6657 |
6446 |
5372/6196/6446/6657 |
Invitations |
160 |
A |
0 |
0 |
invitations |
5372/6196/6446 |
6671 |
6446 |
5372/6196/6446/6671 |
Noisemakers & Party Blowers |
170 |
A |
0 |
0 |
noisemakers-and-party-blowers |
5372/6196/6446 |
6707 |
6446 |
5372/6196/6446/6707 |
Party Favors |
180 |
A |
0 |
0 |
party-favors |
5372/6196/6446 |
6751 |
6446 |
5372/6196/6446/6751 |
Party Games |
190 |
A |
0 |
0 |
party-games |
5372/6196/6446 |
6766 |
6446 |
5372/6196/6446/6766 |
Party Hats |
200 |
A |
0 |
0 |
party-hats |
5372/6196/6446 |
6778 |
6446 |
5372/6196/6446/6778 |
Party Streamers & Curtains |
210 |
A |
0 |
0 |
party-streamers-and-curtains |
5372/6196/6446 |
6789 |
6446 |
5372/6196/6446/6789 |
Party Supply Kits |
220 |
A |
0 |
0 |
party-supply-kit |
5372/6196/6446 |
6817 |
6446 |
5372/6196/6446/6817 |
Place Card Holders |
230 |
A |
0 |
0 |
place-card-holders |
5372/6196/6446 |
6826 |
6446 |
5372/6196/6446/6826 |
Place Cards |
240 |
A |
0 |
0 |
place-cards |
5372/6196/6446 |
6833 |
6446 |
5372/6196/6446/6833 |
Response Cards |
250 |
A |
0 |
0 |
response-cards |
5372/6196/6446 |
6843 |
6446 |
5372/6196/6446/6843 |
Sparklers |
260 |
A |
0 |
0 |
sparklers |
5372/6196/6446 |
6849 |
6446 |
5372/6196/6446/6849 |
Special Occasion Card Boxes & Holders |
270 |
A |
0 |
0 |
special-occasion-card-boxes-and-holders |
5372/6196/6446 |
6861 |
6446 |
5372/6196/6446/6861 |
Spray String |
280 |
A |
0 |
0 |
spray-string |
5372/6196/6446 |
8986 |
6446 |
5372/6196/6446/8986 |
Pinatas |
290 |
A |
0 |
0 |
pinatas |
5372/6196/6446 |