Query time 0.00278
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "74.86"
},
"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": 51,
"rows_produced_per_join": 1,
"filtered": "2.00",
"index_condition": "(`webmarco`.`cscart_categories`.`id_path` like '5684/7840/%')",
"cost_info": {
"read_cost": "72.21",
"eval_cost": "0.20",
"prefix_cost": "72.41",
"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.02",
"eval_cost": "0.20",
"prefix_cost": "73.63",
"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.02",
"eval_cost": "0.20",
"prefix_cost": "74.86",
"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 |
7846 |
7840 |
5684/7840/7846 |
Air Hockey |
10 |
A |
0 |
0 |
0 |
air-hockey |
5684/7840 |
7852 |
7846 |
5684/7840/7846/7852 |
Air Hockey Equipment |
10 |
A |
0 |
0 |
0 |
air-hockey-equipment |
5684/7840/7846 |
7907 |
7900 |
5684/7840/7900/7907 |
Billiard Ball Racks |
10 |
A |
0 |
0 |
0 |
billiard-ball-racks |
5684/7840/7900 |
7961 |
7952 |
5684/7840/7900/7952/7961 |
Billiard Cue Cases |
10 |
A |
0 |
0 |
0 |
billiard-cue-cases |
5684/7840/7900/7952 |
8042 |
8022 |
5684/7840/7900/8022/8042 |
Billiard Pockets |
10 |
A |
0 |
0 |
0 |
billiard-pockets |
5684/7840/7900/8022 |
8107 |
8103 |
5684/7840/8103/8107 |
Bowling Ball Bags |
10 |
A |
0 |
0 |
0 |
bowling-ball-bags |
5684/7840/8103 |
8310 |
8303 |
5684/7840/8303/8310 |
Dart Backboards |
10 |
A |
0 |
0 |
0 |
dart-backboards |
5684/7840/8303 |
8319 |
8314 |
5684/7840/8303/8314/8319 |
Dart Flights |
10 |
A |
0 |
0 |
0 |
dart-flights |
5684/7840/8303/8314 |
8164 |
8158 |
5684/7840/8158/8164 |
Foosball Balls |
10 |
A |
0 |
0 |
0 |
foosball-balls |
5684/7840/8158 |
8189 |
8186 |
5684/7840/8186/8189 |
Ping Pong Balls |
10 |
A |
0 |
0 |
0 |
ping-pong-balls |
5684/7840/8186 |
8271 |
8265 |
5684/7840/8265/8271 |
Shuffleboard Tables |
10 |
A |
0 |
0 |
0 |
shuffleboard-tables |
5684/7840/8265 |
7915 |
7900 |
5684/7840/7900/7915 |
Billiard Balls |
20 |
A |
0 |
0 |
0 |
billiard-balls |
5684/7840/7900 |
7885 |
7846 |
5684/7840/7846/7885 |
Air Hockey Table Parts |
20 |
A |
0 |
0 |
0 |
air-hockey-table-parts |
5684/7840/7846 |
7969 |
7952 |
5684/7840/7900/7952/7969 |
Billiard Cue Chalk |
20 |
A |
0 |
0 |
0 |
billiard-cue-chalk |
5684/7840/7900/7952 |
8055 |
8022 |
5684/7840/7900/8022/8055 |
Billiard Table Cloth |
20 |
A |
0 |
0 |
0 |
billiard-table-brushes |
5684/7840/7900/8022 |
7900 |
7840 |
5684/7840/7900 |
Billiards |
20 |
A |
0 |
0 |
0 |
billiards |
5684/7840 |
8128 |
8103 |
5684/7840/8103/8128 |
Bowling Balls |
20 |
A |
0 |
0 |
0 |
bowling-balls |
5684/7840/8103 |
8314 |
8303 |
5684/7840/8303/8314 |
Dart Parts |
20 |
A |
0 |
0 |
0 |
dart-parts |
5684/7840/8303 |
8327 |
8314 |
5684/7840/8303/8314/8327 |
Dart Shafts |
20 |
A |
0 |
0 |
0 |
dart-shafts |
5684/7840/8303/8314 |
8166 |
8158 |
5684/7840/8158/8166 |
Foosball Table Parts & Accessories |
20 |
A |
0 |
0 |
0 |
foosball-table-parts-and-accessories |
5684/7840/8158 |
8202 |
8186 |
5684/7840/8186/8202 |
Ping Pong Nets & Posts |
20 |
A |
0 |
0 |
0 |
ping-pong-nets-and-posts |
5684/7840/8186 |
8284 |
8265 |
5684/7840/8265/8284 |
Table Shuffleboard Powder |
20 |
A |
0 |
0 |
0 |
table-shuffleboard-powder |
5684/7840/8265 |
7892 |
7846 |
5684/7840/7846/7892 |
Air Hockey Tables |
30 |
A |
0 |
0 |
6 |
air-hockey-tables |
5684/7840/7846 |
7952 |
7900 |
5684/7840/7900/7952 |
Billiard Cue Accessories |
30 |
A |
0 |
0 |
0 |
billiard-cue-accessories |
5684/7840/7900 |
7988 |
7952 |
5684/7840/7900/7952/7988 |
Billiard Cue Racks |
30 |
A |
0 |
0 |
0 |
billiard-cue-racks |
5684/7840/7900/7952 |
8073 |
8022 |
5684/7840/7900/8022/8073 |
Billiard Table Covers |
30 |
A |
0 |
0 |
0 |
billiard-table-covers |
5684/7840/7900/8022 |
8103 |
7840 |
5684/7840/8103 |
Bowling |
30 |
A |
0 |
0 |
0 |
bowling |
5684/7840 |
8133 |
8103 |
5684/7840/8103/8133 |
Bowling Gloves |
30 |
A |
0 |
0 |
0 |
bowling-gloves |
5684/7840/8103 |
8332 |
8314 |
5684/7840/8303/8314/8332 |
Dart Tips |
30 |
A |
0 |
0 |
0 |
dart-tips |
5684/7840/8303/8314 |
8343 |
8303 |
5684/7840/8303/8343 |
Dartboards |
30 |
A |
0 |
0 |
0 |
dartboards |
5684/7840/8303 |
8173 |
8158 |
5684/7840/8158/8173 |
Foosball Tables |
30 |
A |
0 |
0 |
0 |
foosball-tables |
5684/7840/8158 |
8208 |
8186 |
5684/7840/8186/8208 |
Ping Pong Paddle Accessories |
30 |
A |
0 |
0 |
0 |
ping-pong-paddle-accessories |
5684/7840/8186 |
8291 |
8265 |
5684/7840/8265/8291 |
Table Shuffleboard Pucks |
30 |
A |
0 |
0 |
0 |
table-shuffleboard-pucks |
5684/7840/8265 |
7995 |
7900 |
5684/7840/7900/7995 |
Billiard Cues & Bridges |
40 |
A |
0 |
0 |
0 |
billiard-cues-and-bridges |
5684/7840/7900 |
8086 |
8022 |
5684/7840/7900/8022/8086 |
Billiard Table Brushes |
40 |
A |
0 |
0 |
0 |
billiard-table-brushes-en |
5684/7840/7900/8022 |
8142 |
8103 |
5684/7840/8103/8142 |
Bowling Pins |
40 |
A |
0 |
0 |
0 |
bowling-pins |
5684/7840/8103 |
8348 |
8303 |
5684/7840/8303/8348 |
Darts |
40 |
A |
0 |
0 |
0 |
darts |
5684/7840/8303 |
8158 |
7840 |
5684/7840/8158 |
Foosball |
40 |
A |
0 |
0 |
0 |
foosball |
5684/7840 |
8211 |
8186 |
5684/7840/8186/8211 |
Ping Pong Paddles & Sets |
40 |
A |
0 |
0 |
0 |
ping-pong-paddles-and-sets |
5684/7840/8186 |
8180 |
7840 |
5684/7840/8180 |
Multi-Game Tables |
50 |
A |
0 |
0 |
0 |
multi-game-tables |
5684/7840 |
8009 |
7900 |
5684/7840/7900/8009 |
Billiard Gloves |
50 |
A |
0 |
0 |
0 |
billiard-gloves |
5684/7840/7900 |
8148 |
8103 |
5684/7840/8103/8148 |
Bowling Wrist Supports |
50 |
A |
0 |
0 |
0 |
bowling-wrist-supports |
5684/7840/8103 |
8224 |
8186 |
5684/7840/8186/8224 |
Ping Pong Robot Accessories |
50 |
A |
0 |
0 |
0 |
ping-pong-robot-accessories |
5684/7840/8186 |
8014 |
7900 |
5684/7840/7900/8014 |
Billiard Table Lights |
60 |
A |
0 |
0 |
0 |
billiard-table-lights |
5684/7840/7900 |
8186 |
7840 |
5684/7840/8186 |
Ping Pong |
60 |
A |
0 |
0 |
4 |
ping-pong |
5684/7840 |
8251 |
8186 |
5684/7840/8186/8251 |
Ping Pong Robots |
60 |
A |
0 |
0 |
0 |
ping-pong-robots |
5684/7840/8186 |
8022 |
7900 |
5684/7840/7900/8022 |
Billiard Table Parts & Accessories |
70 |
A |
0 |
0 |
0 |
billiard-table-parts-and-accessories |
5684/7840/7900 |
8259 |
8186 |
5684/7840/8186/8259 |
Ping Pong Tables |
70 |
A |
0 |
0 |
1 |
ping-pong-tables |
5684/7840/8186 |
8265 |
7840 |
5684/7840/8265 |
Table Shuffleboard |
70 |
A |
0 |
0 |
0 |
table-shuffleboard |
5684/7840 |
8096 |
7900 |
5684/7840/7900/8096 |
Billiard Tables |
80 |
A |
0 |
0 |
0 |
billiard-tables |
5684/7840/7900 |
8303 |
7840 |
5684/7840/8303 |
Throwing Darts |
80 |
A |
0 |
0 |
0 |
throwing-darts |
5684/7840 |