Query time 0.00172
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "46.81"
},
"ordering_operation": {
"using_temporary_table": true,
"using_filesort": true,
"cost_info": {
"sort_cost": "2.60"
},
"nested_loop": [
{
"table": {
"table_name": "cscart_shippings",
"access_type": "ALL",
"possible_keys": [
"shipping_id",
"c_status"
],
"rows_examined_per_scan": 176,
"rows_produced_per_join": 1,
"filtered": "0.57",
"cost_info": {
"read_cost": "38.00",
"eval_cost": "0.20",
"prefix_cost": "38.20",
"data_read_per_join": "2K"
},
"used_columns": [
"shipping_id",
"destination",
"min_weight",
"max_weight",
"usergroup_ids",
"rate_calculation",
"service_id",
"service_params",
"position",
"status",
"free_shipping",
"is_address_required"
],
"attached_condition": "((`webmarco`.`cscart_shippings`.`status` = 'A') and (`webmarco`.`cscart_shippings`.`shipping_id` in (129,100,98,10,9,77,44,19,43,12,48,49,78,96,97,38,45,46,47,17,42,40,11,39,23,80,86,85,84,116,83,82,24,81)) and (`webmarco`.`cscart_shippings`.`min_weight` <= 0.001) and ((`webmarco`.`cscart_shippings`.`max_weight` >= 0.001) or (`webmarco`.`cscart_shippings`.`max_weight` = 0.00)) and ((`webmarco`.`cscart_shippings`.`usergroup_ids` = '') or find_in_set(0,`webmarco`.`cscart_shippings`.`usergroup_ids`) or find_in_set(1,`webmarco`.`cscart_shippings`.`usergroup_ids`)))"
}
},
{
"table": {
"table_name": "cscart_shipping_descriptions",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"shipping_id",
"lang_code"
],
"key_length": "9",
"ref": [
"webmarco.cscart_shippings.shipping_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.00",
"eval_cost": "0.20",
"prefix_cost": "39.40",
"data_read_per_join": "984"
},
"used_columns": [
"shipping_id",
"lang_code",
"shipping",
"delivery_time",
"description"
]
}
},
{
"table": {
"table_name": "cscart_shipping_services",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"sa"
],
"key": "PRIMARY",
"used_key_parts": [
"service_id"
],
"key_length": "3",
"ref": [
"webmarco.cscart_shippings.service_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.00",
"eval_cost": "0.20",
"prefix_cost": "40.60",
"data_read_per_join": "400"
},
"used_columns": [
"service_id",
"module",
"code"
]
}
},
{
"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": 2,
"filtered": "20.00",
"using_index": true,
"using_join_buffer": "Block Nested Loop",
"cost_info": {
"read_cost": "3.09",
"eval_cost": "0.52",
"prefix_cost": "44.21",
"data_read_per_join": "41"
},
"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`.`cscart_shippings`.`shipping_id`), true))"
}
}
]
}
}
}
Result
shipping_id |
shipping |
delivery_time |
description |
rate_calculation |
service_params |
destination |
min_weight |
max_weight |
service_id |
free_shipping |
module |
service_code |
is_address_required |
98 |
DHL Express Worldwide - From Netherlands |
|
|
M |
a:0:{} |
I |
0.000 |
10.000 |
0 |
N |
|
|
Y |
100 |
DHL Express Worldwide - From Turkey |
3-12 business days |
|
M |
a:0:{} |
I |
0.000 |
32.000 |
0 |
N |
|
|
Y |
129 |
DHL Express Worldwide - From Romania |
3-12 business days |
|
M |
a:0:{} |
I |
0.000 |
0.000 |
0 |
N |
|
|
Y |
9 |
Crono Standard ( €6.00 ) |
2-4 days |
|
M |
a:0:{} |
I |
0.000 |
10.000 |
0 |
Y |
|
|
Y |
10 |
Crono Express ( €8.00 ) |
1-2 days |
|
M |
a:0:{} |
I |
0.000 |
10.000 |
0 |
Y |
|
|
Y |
77 |
DHL Express - Italy National Shipping |
2-4 business days |
|
R |
a:10:{s:9:"system_id";s:14:"v62_X3Bpbbforg";s:8:"password";s:10:"UaHGw5zZdR";s:14:"account_number";s:9:"100083707";s:15:"account_country";s:2:"IT";s:9:"test_mode";s:1:"N";s:21:"system_of_measurement";s:1:"I";s:17:"max_weight_of_box";s:1:"0";s:6:"length";s:0:"";s:5:"width";s:0:"";s:6:"height";s:0:"";} |
I |
0.000 |
0.000 |
390 |
N |
dhl |
N |
Y |
44 |
SDA |
|
<p>Grazie ai suoi servizi innovativi, SDA è un’assicurazione di spedizioni rapide e flessibilità di consegna.</p> |
M |
a:0:{} |
I |
0.000 |
0.000 |
0 |
N |
|
|
Y |
12 |
Bartolini SG |
2-4 days |
|
M |
a:0:{} |
I |
0.000 |
70.000 |
0 |
Y |
|
|
Y |
19 |
Bartolini - Intruglio |
2-4 days |
|
M |
a:0:{} |
I |
0.000 |
0.000 |
0 |
Y |
|
|
Y |
43 |
BRT |
|
<p>Grazie alla distribuzione capillare su tutto il territorio italiano ed europeo, Bartolini ti garantisce <b>spedizioni sicure, precise e affidabili</b>.</p> |
M |
a:0:{} |
I |
0.000 |
0.000 |
0 |
N |
|
|
Y |
48 |
SDA Express courier |
|
<p>SDA Express courier</p> |
M |
a:0:{} |
I |
0.000 |
0.000 |
0 |
N |
|
|
Y |
49 |
DHL Express |
1-6 business days |
<p>DHL Express - Delivery Time: 1-6 business days </p> |
M |
a:0:{} |
I |
0.000 |
0.000 |
0 |
N |
|
|
Y |
78 |
DHL Express Worldwide - from Italy |
1-6 business days |
|
R |
a:10:{s:9:"system_id";s:14:"v62_X3Bpbbforg";s:8:"password";s:10:"UaHGw5zZdR";s:14:"account_number";s:9:"100083707";s:15:"account_country";s:2:"IT";s:9:"test_mode";s:1:"N";s:21:"system_of_measurement";s:1:"M";s:17:"max_weight_of_box";s:1:"0";s:6:"length";s:0:"";s:5:"width";s:0:"";s:6:"height";s:0:"";} |
I |
0.000 |
0.000 |
385 |
N |
dhl |
P |
Y |
96 |
DHL Express Worldwide - From Greece |
2-4 business days |
|
M |
a:0:{} |
I |
0.000 |
0.000 |
0 |
N |
|
|
Y |
97 |
DHL Express Worldwide - From Germany |
2-4 business days |
|
M |
a:0:{} |
I |
0.000 |
31.500 |
0 |
N |
|
|
Y |
38 |
UPS |
|
<p><em>ups</em></p> |
R |
a:14:{s:10:"access_key";s:0:"";s:8:"username";s:16:"2021021214131415";s:8:"password";s:15:"C;&w<.72iX.csV6";s:16:"negotiated_rates";s:1:"N";s:14:"shipper_number";s:0:"";s:9:"test_mode";s:1:"Y";s:11:"pickup_type";s:2:"01";s:12:"package_type";s:2:"01";s:21:"delivery_confirmation";s:1:"N";s:10:"dcist_type";s:1:"1";s:17:"max_weight_of_box";s:1:"0";s:5:"width";s:2:"10";s:6:"height";s:2:"10";s:6:"length";s:2:"10";} |
I |
0.000 |
0.000 |
451 |
N |
upsdeprecated |
96 |
Y |
45 |
Italmondo |
|
<p>Per spedire su territorio nazionale e all’estero con Italmondo al miglior prezzo</p> |
M |
a:0:{} |
I |
0.000 |
0.000 |
0 |
N |
|
|
Y |
46 |
Sailpost |
|
<p>Con Sailpost, uno dei più importanti operatori postali italiani, puoi inviare corrispondenza, pacchi e raccomandate a un prezzo davvero conveniente.</p> |
M |
a:0:{} |
I |
0.000 |
0.000 |
0 |
N |
|
|
Y |
47 |
SkyNet |
|
<p><strong>Spedizioni veloci, a buon prezzo e garantite sono il punto di forza di SkyNet Italia</strong>. </p> |
M |
a:0:{} |
I |
0.000 |
0.000 |
0 |
N |
|
|
Y |
11 |
Bartolini |
2-4 days |
|
M |
a:0:{} |
I |
0.000 |
0.000 |
0 |
Y |
|
|
Y |
17 |
MBE Standard |
|
|
M |
a:0:{} |
I |
0.000 |
0.000 |
0 |
Y |
|
|
Y |
39 |
Swiss Post |
|
<p></p>
<h1>Swiss Post</h1> |
M |
a:0:{} |
I |
0.000 |
0.000 |
0 |
N |
|
|
Y |
40 |
PosteItaliane |
|
<p>PosteItaliane</p> |
M |
a:0:{} |
I |
0.000 |
0.000 |
0 |
N |
|
|
Y |
42 |
GLS |
|
<p>GLS </p> |
M |
a:0:{} |
I |
0.000 |
0.000 |
0 |
N |
|
|
Y |
23 |
MBE Nazionale |
|
|
M |
a:0:{} |
I |
0.000 |
0.000 |
0 |
Y |
|
|
Y |
24 |
Free Shipping For Italy |
2-4 days |
|
M |
a:0:{} |
I |
0.000 |
0.000 |
0 |
Y |
|
|
Y |
80 |
Free Shipping For Turkey |
2-4 business days |
|
M |
a:0:{} |
I |
0.000 |
0.000 |
0 |
N |
|
|
Y |
81 |
Free Shipping for Greece |
2-4 business days |
|
M |
a:0:{} |
I |
0.000 |
0.000 |
0 |
N |
|
|
Y |
82 |
Free Shipping For Albania |
2-4 business days |
|
M |
a:0:{} |
I |
0.000 |
0.000 |
0 |
N |
|
|
Y |
83 |
Free Shipping for Spain |
2-4 business days |
|
M |
a:0:{} |
I |
0.000 |
0.000 |
0 |
N |
|
|
Y |
84 |
Free Shipping For Germany |
2-4 business days |
|
M |
a:0:{} |
I |
0.000 |
0.000 |
0 |
N |
|
|
Y |
85 |
Free Shipping For France |
2-4 business days |
|
M |
a:0:{} |
I |
0.000 |
0.000 |
0 |
N |
|
|
Y |
86 |
Free Shipping For North Macedonia |
2-4 business days |
|
M |
a:0:{} |
I |
0.000 |
0.000 |
0 |
N |
|
|
Y |
116 |
Free Shipping For Kosovo |
|
|
M |
a:0:{} |
I |
0.000 |
0.000 |
0 |
N |
|
|
Y |