Query time 0.00142
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "49.04"
},
"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": 48,
"rows_produced_per_join": 0,
"filtered": "1.00",
"index_condition": "(`maniamall_cscart`.`cscart_categories`.`id_path` like '285/30411/%')",
"cost_info": {
"read_cost": "47.95",
"eval_cost": "0.05",
"prefix_cost": "47.99",
"data_read_per_join": "1K"
},
"used_columns": [
"category_id",
"parent_id",
"id_path",
"company_id",
"usergroup_ids",
"status",
"position",
"is_trash"
],
"attached_condition": "((`maniamall_cscart`.`cscart_categories`.`company_id` = 1) and ((`maniamall_cscart`.`cscart_categories`.`usergroup_ids` = '') or (0 <> find_in_set(0,`maniamall_cscart`.`cscart_categories`.`usergroup_ids`)) or (0 <> find_in_set(1,`maniamall_cscart`.`cscart_categories`.`usergroup_ids`))) and (`maniamall_cscart`.`cscart_categories`.`status` = 'A'))"
}
},
{
"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": [
"maniamall_cscart.cscart_categories.category_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.47",
"eval_cost": "0.05",
"prefix_cost": "48.51",
"data_read_per_join": "1K"
},
"used_columns": [
"category_id",
"lang_code",
"category"
]
}
},
{
"table": {
"table_name": "cscart_seo_names",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"dispatch"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"type",
"dispatch",
"lang_code",
"company_id"
],
"key_length": "210",
"ref": [
"maniamall_cscart.cscart_categories.category_id",
"const",
"const",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.48",
"eval_cost": "0.05",
"prefix_cost": "49.04",
"data_read_per_join": "833"
},
"used_columns": [
"name",
"object_id",
"company_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
]
}
}
}
Result
| category_id |
parent_id |
id_path |
category |
position |
status |
company_id |
seo_name |
seo_path |
| 30421 |
30412 |
285/30411/30412/30421 |
Ambielaje |
90 |
A |
1 |
ambielaje-ro |
285/30411/30412 |
| 30427 |
30412 |
285/30411/30412/30427 |
Ambreiaje |
90 |
A |
1 |
ambreiaje-ro |
285/30411/30412 |
| 30423 |
30422 |
285/30411/30422/30423 |
Amortizoare |
90 |
A |
1 |
amortizoare |
285/30411/30422 |
| 30426 |
30425 |
285/30411/30412/30425/30426 |
Aprinderi |
90 |
A |
1 |
aprinderi |
285/30411/30412/30425 |
| 30430 |
30429 |
285/30411/30412/30427/30428/30429/30430 |
Arcuri |
90 |
A |
1 |
arcuri-ro |
285/30411/30412/30427/30428/30429 |
| 30414 |
30413 |
285/30411/30412/30413/30414 |
Arcuri Demaror |
90 |
A |
1 |
arcuri-demaror-ro |
285/30411/30412/30413 |
| 30415 |
30414 |
285/30411/30412/30413/30414/30415 |
Arcuri Pornire |
90 |
A |
1 |
arcuri-pornire-ro |
285/30411/30412/30413/30414 |
| 30432 |
30412 |
285/30411/30412/30432 |
Benzi Frana |
90 |
A |
1 |
benzi-frana |
285/30411/30412 |
| 30420 |
30419 |
285/30411/30412/30419/30420 |
Benzina |
90 |
A |
1 |
benzina-ro-2 |
285/30411/30412/30419 |
| 30425 |
30412 |
285/30411/30412/30425 |
Bobine Inductie |
90 |
A |
1 |
bobine-inductie-ro |
285/30411/30412 |
| 30436 |
30412 |
285/30411/30412/30436 |
Bujii |
90 |
A |
1 |
bujii |
285/30411/30412 |
| 30439 |
30412 |
285/30411/30412/30439 |
Busoane Benzina |
90 |
A |
1 |
busoane-benzina |
285/30411/30412 |
| 30434 |
30433 |
285/30411/30412/30433/30434 |
Buton Soc |
90 |
A |
1 |
buton-soc |
285/30411/30412/30433 |
| 30441 |
30412 |
285/30411/30412/30441 |
Capace Ambreiaj |
90 |
A |
1 |
capace-ambreiaj |
285/30411/30412 |
| 30443 |
30442 |
285/30411/30412/30442/30443 |
Capace Cilindri |
90 |
A |
1 |
capace-cilindri-ro |
285/30411/30412/30442 |
| 30417 |
30412 |
285/30411/30412/30417 |
Carburatoare |
90 |
A |
1 |
carburatoare-ro |
285/30411/30412 |
| 30444 |
30443 |
285/30411/30412/30442/30443/30444 |
Cartere |
90 |
A |
1 |
cartere-ro |
285/30411/30412/30442/30443 |
| 30438 |
30437 |
285/30411/30412/30436/30437/30438 |
Chei Bujie |
90 |
A |
1 |
chei-bujie |
285/30411/30412/30436/30437 |
| 30442 |
30412 |
285/30411/30412/30442 |
Cilindri |
90 |
A |
1 |
cilindri-ro-2 |
285/30411/30412 |
| 30413 |
30412 |
285/30411/30412/30413 |
Demaroare |
90 |
A |
1 |
demaroare-ro |
285/30411/30412 |
| 30424 |
30412 |
285/30411/30412/30424 |
Diverse |
90 |
A |
1 |
diverse-ro-8 |
285/30411/30412 |
| 30446 |
30412 |
285/30411/30412/30446 |
Esapamente |
90 |
A |
1 |
esapamente |
285/30411/30412 |
| 30419 |
30412 |
285/30411/30412/30419 |
Filtre Aer |
90 |
A |
1 |
filtre-aer-ro-5 |
285/30411/30412 |
| 30437 |
30436 |
285/30411/30412/30436/30437 |
Fise Bujie |
90 |
A |
1 |
fise-bujie |
285/30411/30412/30436 |
| 30416 |
30415 |
285/30411/30412/30413/30414/30415/30416 |
Fulii Pornire |
90 |
A |
1 |
fulii-pornire-ro |
285/30411/30412/30413/30414/30415 |
| 30447 |
30412 |
285/30411/30412/30447 |
Furtunuri Benzina |
90 |
A |
1 |
furtunuri-benzina |
285/30411/30412 |
| 30450 |
30412 |
285/30411/30412/30450 |
Galerii Admisie |
90 |
A |
1 |
galerii-admisie |
285/30411/30412 |
| 30451 |
30412 |
285/30411/30412/30451 |
Garnituri |
90 |
A |
1 |
garnituri-ro |
285/30411/30412 |
| 30449 |
30448 |
285/30411/30412/30447/30448/30449 |
Impuls |
90 |
A |
1 |
impuls |
285/30411/30412/30447/30448 |
| 30418 |
30417 |
285/30411/30412/30417/30418 |
Kituri Reparatie |
90 |
A |
1 |
kituri-reparatie-ro |
285/30411/30412/30417 |
| 30453 |
30412 |
285/30411/30412/30453 |
Lame |
90 |
A |
1 |
lame |
285/30411/30412 |
| 30428 |
30427 |
285/30411/30412/30427/30428 |
Oale |
90 |
A |
1 |
oale-ro |
285/30411/30412/30427 |
| 30452 |
30412 |
285/30411/30412/30452 |
Pistoane |
90 |
A |
1 |
pistoane |
285/30411/30412 |
| 30454 |
30412 |
285/30411/30412/30454 |
Pompe Ulei |
90 |
A |
1 |
pompe-ulei |
285/30411/30412 |
| 30455 |
30412 |
285/30411/30412/30455 |
Rezervoare Benzina |
90 |
A |
1 |
rezervoare-benzina |
285/30411/30412 |
| 30431 |
30430 |
285/30411/30412/30427/30428/30429/30430/30431 |
Rotite Motrice |
90 |
A |
1 |
rotite-motrice-ro |
285/30411/30412/30427/30428/30429/30430 |
| 30457 |
30412 |
285/30411/30412/30457 |
Rulmenti Si Simeringuri |
90 |
A |
1 |
rulmenti-si-simeringuri |
285/30411/30412 |
| 30429 |
30428 |
285/30411/30412/30427/30428/30429 |
Saboti |
90 |
A |
1 |
saboti-ro |
285/30411/30412/30427/30428 |
| 30458 |
30412 |
285/30411/30412/30458 |
Segmenti Piston |
90 |
A |
1 |
segmenti-piston |
285/30411/30412 |
| 30412 |
30411 |
285/30411/30412 |
Stihl Husqvarna Partner Etc. |
90 |
A |
1 |
stihl-husqvarna-partner-etc. |
285/30411 |
| 30422 |
30411 |
285/30411/30422 |
Stihl Husqvarna Partner Etc.. |
90 |
A |
1 |
stihl-husqvarna-partner-etc.. |
285/30411 |
| 30435 |
30434 |
285/30411/30412/30433/30434/30435 |
Tija Soc |
90 |
A |
1 |
tija-soc |
285/30411/30412/30433/30434 |
| 30433 |
30412 |
285/30411/30412/30433 |
Tragaci Acceleratie |
90 |
A |
1 |
tragaci-acceleratie |
285/30411/30412 |
| 30448 |
30447 |
285/30411/30412/30447/30448 |
Ulei |
90 |
A |
1 |
ulei-ro-2 |
285/30411/30412/30447 |
| 30456 |
30455 |
285/30411/30412/30455/30456 |
ulei |
90 |
A |
1 |
ulei-ro-3 |
285/30411/30412/30455 |
| 30440 |
30439 |
285/30411/30412/30439/30440 |
ulei |
90 |
A |
1 |
ulei-ro |
285/30411/30412/30439 |
| 30459 |
30412 |
285/30411/30412/30459 |
Uleiuri |
90 |
A |
1 |
uleiuri-ro |
285/30411/30412 |
| 30445 |
30412 |
285/30411/30412/30445 |
Volante |
90 |
A |
1 |
volante |
285/30411/30412 |