Query time 0.00157
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "26.52"
},
"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": 22,
"rows_produced_per_join": 0,
"filtered": "0.23",
"cost_info": {
"read_cost": "22.00",
"eval_cost": "0.01",
"prefix_cost": "26.40",
"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 '4271/4338/%') 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": "26.46",
"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": "26.52",
"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 |
4354 |
4338 |
4271/4338/4354 |
Adapters |
0 |
A |
0 |
0 |
adapters |
4271/4338 |
4409 |
4338 |
4271/4338/4409 |
Antenna Accessories |
0 |
A |
0 |
0 |
antenna-accessories |
4271/4338 |
4449 |
4338 |
4271/4338/4449 |
Antennas |
0 |
A |
0 |
0 |
antennas |
4271/4338 |
4464 |
4338 |
4271/4338/4464 |
Audio & Video Splitters & Switches |
0 |
A |
0 |
0 |
audio-and-video-splitters-and-switches |
4271/4338 |
4527 |
4338 |
4271/4338/4527 |
Blank Media |
0 |
A |
0 |
0 |
blank-media |
4271/4338 |
4538 |
4338 |
4271/4338/4538 |
Cable Management |
0 |
A |
0 |
0 |
cable-management |
4271/4338 |
4643 |
4338 |
4271/4338/4643 |
Cables |
0 |
A |
0 |
0 |
cables |
4271/4338 |
4400 |
4338 |
4271/4338/4400 |
Computer Accessories |
0 |
A |
0 |
0 |
computer-accessories |
4271/4338 |
4467 |
4338 |
4271/4338/4467 |
Computer Components |
0 |
A |
0 |
0 |
computer-components |
4271/4338 |
9389 |
4338 |
4271/4338/9389 |
Computer ComponentsI/O Cards & Adapters |
0 |
A |
0 |
0 |
computer-componentsi-o-cards-and-adapters |
4271/4338 |
4719 |
4338 |
4271/4338/4719 |
Electronics Cleaners |
0 |
A |
0 |
0 |
electronics-cleaners |
4271/4338 |
5107 |
4338 |
4271/4338/5107 |
Electronics Films & Shields |
0 |
A |
0 |
0 |
electronics-films-and-shields-en |
4271/4338 |
5165 |
4338 |
4271/4338/5165 |
Memory |
0 |
A |
0 |
0 |
memory |
4271/4338 |
5219 |
4338 |
4271/4338/5219 |
Memory Accessories |
0 |
A |
0 |
0 |
memory-accessories |
4271/4338 |
9428 |
4338 |
4271/4338/9428 |
MemoryFlash Memory |
0 |
A |
0 |
0 |
memoryflash-memory |
4271/4338 |
5236 |
4338 |
4271/4338/5236 |
Mobile Phone & Tablet Tripods & Monopods |
0 |
A |
0 |
0 |
mobile-phone-and-tablet-tripods-and-monopods |
4271/4338 |
4718 |
4338 |
4271/4338/4718 |
Power |
0 |
A |
0 |
0 |
power |
4271/4338 |
9612 |
4338 |
4271/4338/9612 |
PowerBatteries |
0 |
A |
0 |
0 |
powerbatteries |
4271/4338 |
9433 |
4338 |
4271/4338/9433 |
PowerUPS Accessories |
0 |
A |
0 |
0 |
powerups-accessories |
4271/4338 |
4956 |
4338 |
4271/4338/4956 |
Remote Controls |
0 |
A |
0 |
0 |
remote-controls |
4271/4338 |
4975 |
4338 |
4271/4338/4975 |
Signal Boosters |
0 |
A |
0 |
0 |
signal-boosters |
4271/4338 |
5085 |
4338 |
4271/4338/5085 |
Signal Jammers |
0 |
A |
0 |
0 |
signal-jammers |
4271/4338 |