Query time 0.00247
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "91.72"
},
"ordering_operation": {
"using_temporary_table": true,
"using_filesort": true,
"nested_loop": [
{
"table": {
"table_name": "cscart_product_filters",
"access_type": "ALL",
"rows_examined_per_scan": 162,
"rows_produced_per_join": 16,
"filtered": "10.00",
"cost_info": {
"read_cost": "30.16",
"eval_cost": "3.24",
"prefix_cost": "33.40",
"data_read_per_join": "1K"
},
"used_columns": [
"filter_id",
"categories_path",
"feature_id",
"position",
"field_type",
"status",
"round_to",
"display_count",
"display"
],
"attached_condition": "((`webmarco`.`cscart_product_filters`.`status` = 'A') and ((`webmarco`.`cscart_product_filters`.`categories_path` = '') or find_in_set(3001,`webmarco`.`cscart_product_filters`.`categories_path`)))"
}
},
{
"table": {
"table_name": "cscart_product_filter_descriptions",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"filter_id",
"lang_code"
],
"key_length": "9",
"ref": [
"webmarco.cscart_product_filters.filter_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 16,
"filtered": "100.00",
"cost_info": {
"read_cost": "16.20",
"eval_cost": "3.24",
"prefix_cost": "52.84",
"data_read_per_join": "73K"
},
"used_columns": [
"filter_id",
"lang_code",
"filter"
]
}
},
{
"table": {
"table_name": "cscart_product_features",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"feature_id"
],
"key_length": "3",
"ref": [
"webmarco.cscart_product_filters.feature_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 16,
"filtered": "100.00",
"cost_info": {
"read_cost": "16.20",
"eval_cost": "3.24",
"prefix_cost": "72.28",
"data_read_per_join": "6K"
},
"used_columns": [
"feature_id",
"filter_style",
"feature_type"
]
}
},
{
"table": {
"table_name": "cscart_product_features_descriptions",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"feature_id",
"lang_code"
],
"key_length": "9",
"ref": [
"webmarco.cscart_product_filters.feature_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 16,
"filtered": "100.00",
"cost_info": {
"read_cost": "16.20",
"eval_cost": "3.24",
"prefix_cost": "91.72",
"data_read_per_join": "36K"
},
"used_columns": [
"feature_id",
"prefix",
"suffix",
"lang_code"
]
}
}
]
}
}
}
Result
feature_id |
filter_id |
field_type |
round_to |
display |
display_count |
filter |
feature_type |
filter_style |
prefix |
suffix |
837 |
394 |
|
0.01 |
Y |
10 |
Abruzzo Provinces |
M |
checkbox |
|
|
1143 |
511 |
|
0.01 |
Y |
10 |
Fuel |
S |
checkbox |
|
|
1148 |
516 |
|
0.01 |
Y |
10 |
Fuqia Motorrike |
S |
checkbox |
|
|
1146 |
515 |
|
0.01 |
Y |
10 |
Kapaciteti |
S |
checkbox |
|
|
1147 |
514 |
|
0.01 |
Y |
10 |
Karburanti |
S |
checkbox |
|
|
1064 |
512 |
|
0.01 |
Y |
10 |
Masa Test |
S |
checkbox |
|
|
1152 |
517 |
|
0.01 |
Y |
10 |
Number of guests |
M |
checkbox |
|
|
1142 |
510 |
|
0.01 |
Y |
10 |
Pickup |
S |
checkbox |
|
|
1149 |
513 |
|
0.01 |
Y |
10 |
Type of Room |
S |
checkbox |
|
|
865 |
397 |
|
0.01 |
Y |
10 |
Albanian Cities |
M |
checkbox |
|
|
867 |
399 |
|
0.01 |
Y |
10 |
Attica Provinces |
M |
checkbox |
|
|
1023 |
437 |
|
0.01 |
Y |
10 |
AUSTRIA - Cities |
M |
checkbox |
|
|
838 |
375 |
|
0.01 |
Y |
10 |
Basilicata Provinces |
M |
checkbox |
|
|
1024 |
438 |
|
0.01 |
Y |
10 |
BOSNIA AND HERZEGOVINA - Cities |
M |
checkbox |
|
|
1041 |
455 |
|
0.01 |
Y |
10 |
Brand |
M |
checkbox |
|
|
1125 |
500 |
|
0.01 |
Y |
10 |
Brand Name |
M |
checkbox |
|
|
1025 |
439 |
|
0.01 |
Y |
10 |
BULGARIA - Cities |
M |
checkbox |
|
|
839 |
376 |
|
0.01 |
Y |
10 |
Calabria Provinces |
M |
checkbox |
|
|
840 |
377 |
|
0.01 |
Y |
10 |
Campania Provinces |
M |
checkbox |
|
|
868 |
400 |
|
0.01 |
Y |
10 |
Central Greece Provinces |
M |
checkbox |
|
|
869 |
401 |
|
0.01 |
Y |
10 |
Central Macedonia Provinces |
M |
checkbox |
|
|
860 |
494 |
|
0.01 |
Y |
10 |
Color |
S |
checkbox |
|
|
870 |
402 |
|
0.01 |
Y |
10 |
Crete Provinces |
M |
checkbox |
|
|
1026 |
440 |
|
0.01 |
Y |
10 |
CROATIA - Cities |
M |
checkbox |
|
|
1027 |
441 |
|
0.01 |
Y |
10 |
CZECH REPUBLIC - Cities |
M |
checkbox |
|
|
1043 |
457 |
|
0.01 |
Y |
10 |
Demonia - Shoe Size |
M |
checkbox |
|
|
871 |
403 |
|
0.01 |
Y |
10 |
Eastern Macedonia and Thrace Provinces |
M |
checkbox |
|
|
1028 |
442 |
|
0.01 |
Y |
10 |
EGYPT - Cities |
M |
checkbox |
|
|
841 |
378 |
|
0.01 |
Y |
10 |
Emilia-Romagna Provinces |
M |
checkbox |
|
|
872 |
404 |
|
0.01 |
Y |
10 |
Epirus Provinces |
M |
checkbox |
|
|
1029 |
443 |
|
0.01 |
Y |
10 |
FRANCE - Cities |
M |
checkbox |
|
|
842 |
379 |
|
0.01 |
Y |
10 |
Friuli-Venezia Giulia Provinces |
M |
checkbox |
|
|
904 |
415 |
|
0.01 |
Y |
10 |
Germany |
M |
checkbox |
|
|
1030 |
444 |
|
0.01 |
Y |
10 |
GERMANY - Cities |
M |
checkbox |
|
|
1031 |
445 |
|
0.01 |
Y |
10 |
GREECE - Cities |
M |
checkbox |
|
|
866 |
398 |
|
0.01 |
Y |
10 |
Greece Regions |
S |
checkbox |
|
|
962 |
420 |
|
0.01 |
Y |
10 |
How long would you like to stay |
M |
checkbox |
|
|
873 |
405 |
|
0.01 |
Y |
10 |
Ionian Islands Provinces |
M |
checkbox |
|
|
834 |
395 |
|
0.01 |
Y |
10 |
Italian Regions |
M |
checkbox |
|
|
1032 |
446 |
|
0.01 |
Y |
10 |
ITALY - Cities |
M |
checkbox |
|
|
1012 |
425 |
|
0.01 |
Y |
10 |
Collection |
E |
checkbox |
|
|
843 |
380 |
|
0.01 |
Y |
10 |
Lazio Provinces |
M |
checkbox |
|
|
844 |
381 |
|
0.01 |
Y |
10 |
Liguria Provinces |
M |
checkbox |
|
|
845 |
382 |
|
0.01 |
Y |
10 |
Lombardia Provinces |
M |
checkbox |
|
|
846 |
383 |
|
0.01 |
Y |
10 |
Marche Provinces |
M |
checkbox |
|
|
600 |
427 |
|
0.01 |
Y |
10 |
Material |
M |
checkbox |
|
|
847 |
384 |
|
0.01 |
Y |
10 |
Molise Provinces |
M |
checkbox |
|
|
1033 |
447 |
|
0.01 |
Y |
10 |
MONTENEGRO - Cities |
M |
checkbox |
|
|
874 |
406 |
|
0.01 |
Y |
10 |
North Aegean Provinces |
M |
checkbox |
|
|
1037 |
448 |
|
0.01 |
Y |
10 |
NORWAY - Cities |
M |
checkbox |
|
|
875 |
407 |
|
0.01 |
Y |
10 |
Peloponnese Provinces |
M |
checkbox |
|
|
848 |
385 |
|
0.01 |
Y |
10 |
Piemonte Provinces |
M |
checkbox |
|
|
849 |
386 |
|
0.01 |
Y |
10 |
Puglia Provinces |
M |
checkbox |
|
|
850 |
387 |
|
0.01 |
Y |
10 |
Sardegna Provinces |
M |
checkbox |
|
|
1034 |
449 |
|
0.01 |
Y |
10 |
SERBIA - Cities |
M |
checkbox |
|
|
882 |
412 |
|
0.01 |
Y |
10 |
Shoe Color |
S |
checkbox |
|
|
835 |
373 |
|
0.01 |
Y |
10 |
Country |
M |
checkbox |
|
|
851 |
388 |
|
0.01 |
Y |
10 |
Sicilia Provinces |
M |
checkbox |
|
|
1130 |
502 |
|
0.01 |
Y |
10 |
Sizes of Towels |
S |
checkbox |
|
|
1088 |
484 |
|
0.01 |
Y |
10 |
Sock Size |
S |
checkbox |
|
|
876 |
408 |
|
0.01 |
Y |
10 |
South Aegean Provinces |
M |
checkbox |
|
|
1036 |
451 |
|
0.01 |
Y |
10 |
SPAIN - Cities |
M |
checkbox |
|
|
1035 |
450 |
|
0.01 |
Y |
10 |
SWITZERLAND - Cities |
M |
checkbox |
|
|
1078 |
480 |
|
0.01 |
Y |
5 |
THEO.dotted |
S |
checkbox |
|
|
877 |
409 |
|
0.01 |
Y |
10 |
Thessaly Provinces |
M |
checkbox |
|
|
853 |
390 |
|
0.01 |
Y |
10 |
Toscana Provinces |
M |
checkbox |
|
|
852 |
389 |
|
0.01 |
Y |
10 |
Trentino-Alto Adige Provinces |
M |
checkbox |
|
|
1022 |
436 |
|
0.01 |
Y |
10 |
TURKEY - Cities |
M |
checkbox |
|
|
854 |
391 |
|
0.01 |
Y |
10 |
Umbria Provinces |
M |
checkbox |
|
|
1021 |
435 |
|
0.01 |
Y |
10 |
UNITED ARAB EMIRATES - Cities |
M |
checkbox |
|
|
855 |
392 |
|
0.01 |
Y |
10 |
Valle d'Aosta Provinces |
M |
checkbox |
|
|
856 |
393 |
|
0.01 |
Y |
10 |
Veneto Provinces |
M |
checkbox |
|
|
878 |
410 |
|
0.01 |
Y |
10 |
Western Greece Provinces |
M |
checkbox |
|
|
879 |
411 |
|
0.01 |
Y |
10 |
Western Macedonia Provinces |
M |
checkbox |
|
|
817 |
371 |
|
0.01 |
Y |
10 |
Zona / Provincia di Servizio |
M |
checkbox |
|
|
0 |
329 |
S |
0.01 |
Y |
10 |
Shop By Vendor |
|
|
|
|
741 |
343 |
|
0.01 |
Y |
10 |
Find Professionals |
M |
checkbox |
|
|
782 |
368 |
|
0.01 |
Y |
6 |
Fitness & Diet |
S |
checkbox |
|
|
622 |
350 |
|
0.01 |
Y |
10 |
Gender |
S |
checkbox |
|
|
609 |
318 |
|
0.01 |
Y |
10 |
Color |
S |
color |
|
|
0 |
328 |
F |
0.01 |
Y |
10 |
Free Shipping |
|
|
|
|
747 |
347 |
|
0.01 |
Y |
10 |
Delivery Zone |
M |
checkbox |
|
|
816 |
370 |
|
0.01 |
Y |
10 |
Ice Cream Taste |
S |
checkbox |
|
|
711 |
334 |
|
0.01 |
Y |
3 |
Production Method |
S |
checkbox |
|
|
729 |
339 |
|
0.01 |
Y |
4 |
Attributes |
M |
checkbox |
|
|
719 |
336 |
|
0.01 |
Y |
10 |
Book Language |
S |
checkbox |
|
|
725 |
337 |
|
0.01 |
Y |
10 |
Children's Book Age Group |
S |
checkbox |
|
|
608 |
319 |
|
0.01 |
Y |
5 |
Pattern Style |
S |
checkbox |
|
|
750 |
349 |
|
0.01 |
Y |
6 |
Materials |
M |
checkbox |
|
|
648 |
323 |
|
0.01 |
Y |
5 |
Kid's Shoe Size EU) |
S |
checkbox |
|
|
548 |
312 |
|
0.01 |
Y |
6 |
Size |
S |
checkbox |
|
|
665 |
325 |
|
0.01 |
Y |
10 |
Pans & Frying Pans Coating |
S |
checkbox |
|
|
649 |
322 |
|
0.01 |
Y |
10 |
Shoe Size |
S |
checkbox |
|
|
18 |
10 |
|
1 |
Y |
10 |
Brand |
E |
checkbox |
|
|
702 |
331 |
|
0.01 |
Y |
6 |
Pizza Type |
S |
checkbox |
|
|
619 |
351 |
|
0.01 |
Y |
10 |
Condition |
S |
checkbox |
|
|
968 |
421 |
|
0.01 |
Y |
10 |
What kind of package are you looking for ? |
S |
checkbox |
|
|
960 |
416 |
|
0.01 |
Y |
10 |
What country would you like to go? |
M |
checkbox |
|
|
963 |
419 |
|
0.01 |
Y |
10 |
When would you like to go ? |
M |
checkbox |
|
|
1134 |
505 |
|
0.01 |
N |
0 |
ON SALE |
S |
checkbox |
|
|
0 |
1 |
P |
1 |
Y |
10 |
Price |
|
|
|
|
1129 |
501 |
|
0.01 |
Y |
10 |
PROMO |
S |
checkbox |
|
|