Query time 0.00163
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "577.49"
},
"ordering_operation": {
"using_temporary_table": true,
"using_filesort": true,
"cost_info": {
"sort_cost": "251.68"
},
"nested_loop": [
{
"table": {
"table_name": "a",
"access_type": "ALL",
"possible_keys": [
"shipping_id"
],
"rows_examined_per_scan": 176,
"rows_produced_per_join": 96,
"filtered": "55.00",
"cost_info": {
"read_cost": "18.84",
"eval_cost": "19.36",
"prefix_cost": "38.20",
"data_read_per_join": "223K"
},
"used_columns": [
"shipping_id",
"company_id",
"min_weight",
"max_weight",
"usergroup_ids",
"tax_ids",
"position",
"status"
],
"attached_condition": "((`webmarco`.`a`.`company_id` = 618) or (`webmarco`.`a`.`shipping_id` in (129,100,98,10,9,77,44,19,12,43,48,49,78,96,97,38,45,46,47,40,39,17,42,11,23,24,116,86,85,84,83,82,81,80)))"
}
},
{
"table": {
"table_name": "b",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"shipping_id",
"lang_code"
],
"key_length": "9",
"ref": [
"webmarco.a.shipping_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 96,
"filtered": "100.00",
"cost_info": {
"read_cost": "96.80",
"eval_cost": "19.36",
"prefix_cost": "154.36",
"data_read_per_join": "93K"
},
"used_columns": [
"shipping_id",
"lang_code",
"shipping",
"delivery_time"
]
}
},
{
"table": {
"table_name": "c",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id"
],
"key_length": "4",
"ref": [
"webmarco.a.company_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 96,
"filtered": "100.00",
"cost_info": {
"read_cost": "96.80",
"eval_cost": "19.36",
"prefix_cost": "270.52",
"data_read_per_join": "921K"
},
"used_columns": [
"company_id",
"company"
]
}
},
{
"table": {
"table_name": "storefronts_shippings",
"access_type": "index",
"key": "idx_storefront_id",
"used_key_parts": [
"storefront_id"
],
"key_length": "4",
"rows_examined_per_scan": 13,
"rows_produced_per_join": 251,
"filtered": "20.00",
"using_index": true,
"using_join_buffer": "Block Nested Loop",
"cost_info": {
"read_cost": "4.96",
"eval_cost": "50.34",
"prefix_cost": "325.81",
"data_read_per_join": "3K"
},
"used_columns": [
"storefront_id",
"shipping_id"
],
"attached_condition": "(<if>(found_match(storefronts_shippings), ((`webmarco`.`storefronts_shippings`.`storefront_id` = 1) or isnull(`webmarco`.`storefronts_shippings`.`storefront_id`)), true) and <if>(is_not_null_compl(storefronts_shippings), (`webmarco`.`storefronts_shippings`.`shipping_id` = `webmarco`.`a`.`shipping_id`), true))"
}
}
]
}
}
}
Result
shipping_id |
company_id |
min_weight |
max_weight |
position |
status |
tax_ids |
usergroup_ids |
shipping |
delivery_time |
company_name |
storefront_id |
98 |
0 |
0.000 |
10.000 |
0 |
A |
|
0 |
DHL Express Worldwide - From Netherlands |
|
|
|
129 |
0 |
0.000 |
0.000 |
0 |
A |
|
0 |
DHL Express Worldwide - From Romania |
3-12 business days |
|
|
100 |
0 |
0.000 |
32.000 |
0 |
A |
|
0 |
DHL Express Worldwide - From Turkey |
3-12 business days |
|
|
10 |
0 |
0.000 |
10.000 |
10 |
A |
|
0 |
Crono Express ( €8.00 ) |
1-2 days |
|
|
9 |
0 |
0.000 |
10.000 |
10 |
A |
|
0 |
Crono Standard ( €6.00 ) |
2-4 days |
|
|
77 |
0 |
0.000 |
0.000 |
12 |
A |
|
0 |
DHL Express - Italy National Shipping |
2-4 business days |
|
|
44 |
0 |
0.000 |
0.000 |
15 |
A |
|
0 |
SDA |
|
|
|
19 |
0 |
0.000 |
0.000 |
20 |
A |
|
0 |
Bartolini - Intruglio |
2-4 days |
|
|
43 |
0 |
0.000 |
0.000 |
20 |
A |
|
0 |
BRT |
|
|
|
12 |
0 |
0.000 |
70.000 |
20 |
A |
|
0 |
Bartolini SG |
2-4 days |
|
|
48 |
0 |
0.000 |
0.000 |
25 |
A |
|
0 |
SDA Express courier |
|
|
|
49 |
0 |
0.000 |
0.000 |
26 |
A |
|
0 |
DHL Express |
1-6 business days |
|
|
78 |
0 |
0.000 |
0.000 |
27 |
A |
|
0 |
DHL Express Worldwide - from Italy |
1-6 business days |
|
|
96 |
0 |
0.000 |
0.000 |
28 |
A |
|
0 |
DHL Express Worldwide - From Greece |
2-4 business days |
|
|
97 |
0 |
0.000 |
31.500 |
29 |
A |
|
0 |
DHL Express Worldwide - From Germany |
2-4 business days |
|
|
38 |
0 |
0.000 |
0.000 |
40 |
A |
|
0 |
UPS |
|
|
|
45 |
0 |
0.000 |
0.000 |
50 |
A |
|
0 |
Italmondo |
|
|
|
46 |
0 |
0.000 |
0.000 |
60 |
A |
|
0 |
Sailpost |
|
|
|
47 |
0 |
0.000 |
0.000 |
70 |
A |
|
0 |
SkyNet |
|
|
|
17 |
0 |
0.000 |
0.000 |
100 |
A |
|
0 |
MBE Standard |
|
|
|
42 |
0 |
0.000 |
0.000 |
100 |
A |
|
0 |
GLS |
|
|
|
11 |
0 |
0.000 |
0.000 |
100 |
A |
|
0 |
Bartolini |
2-4 days |
|
|
40 |
0 |
0.000 |
0.000 |
100 |
A |
|
0 |
PosteItaliane |
|
|
|
39 |
0 |
0.000 |
0.000 |
100 |
A |
|
0 |
Swiss Post |
|
|
|
23 |
0 |
0.000 |
0.000 |
700 |
A |
|
0 |
MBE Nazionale |
|
|
|
81 |
0 |
0.000 |
0.000 |
1000 |
A |
|
0 |
Free Shipping for Greece |
2-4 business days |
|
|
80 |
0 |
0.000 |
0.000 |
1000 |
A |
|
0 |
Free Shipping For Turkey |
2-4 business days |
|
|
86 |
0 |
0.000 |
0.000 |
1000 |
A |
|
0 |
Free Shipping For North Macedonia |
2-4 business days |
|
|
85 |
0 |
0.000 |
0.000 |
1000 |
A |
|
0 |
Free Shipping For France |
2-4 business days |
|
|
84 |
0 |
0.000 |
0.000 |
1000 |
A |
|
0 |
Free Shipping For Germany |
2-4 business days |
|
|
83 |
0 |
0.000 |
0.000 |
1000 |
A |
|
0 |
Free Shipping for Spain |
2-4 business days |
|
|
116 |
0 |
0.000 |
0.000 |
1000 |
A |
|
0 |
Free Shipping For Kosovo |
|
|
|
82 |
0 |
0.000 |
0.000 |
1000 |
A |
|
0 |
Free Shipping For Albania |
2-4 business days |
|
|
24 |
0 |
0.000 |
0.000 |
1000 |
A |
|
0 |
Free Shipping For Italy |
2-4 days |
|
|