Query time 0.00032
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "2.70"
},
"ordering_operation": {
"using_temporary_table": true,
"using_filesort": true,
"cost_info": {
"sort_cost": "0.05"
},
"nested_loop": [
{
"table": {
"table_name": "cscart_shippings",
"access_type": "range",
"possible_keys": [
"shipping_id",
"c_status"
],
"key": "shipping_id",
"used_key_parts": [
"shipping_id"
],
"key_length": "3",
"rows_examined_per_scan": 3,
"rows_produced_per_join": 0,
"filtered": "1.67",
"index_condition": "(`cscartdevel`.`cscart_shippings`.`shipping_id` in (45,47,48))",
"cost_info": {
"read_cost": "2.10",
"eval_cost": "0.01",
"prefix_cost": "2.11",
"data_read_per_join": "119"
},
"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": "((`cscartdevel`.`cscart_shippings`.`status` = 'A') and (`cscartdevel`.`cscart_shippings`.`min_weight` <= 0.001) and ((`cscartdevel`.`cscart_shippings`.`max_weight` >= 0.001) or (`cscartdevel`.`cscart_shippings`.`max_weight` = 0.000)) and ((`cscartdevel`.`cscart_shippings`.`usergroup_ids` = '') or (0 <> find_in_set(0,`cscartdevel`.`cscart_shippings`.`usergroup_ids`)) or (0 <> find_in_set(1,`cscartdevel`.`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": [
"cscartdevel.cscart_shippings.shipping_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.01",
"eval_cost": "0.01",
"prefix_cost": "2.13",
"data_read_per_join": "49"
},
"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": [
"cscartdevel.cscart_shippings.service_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.01",
"eval_cost": "0.01",
"prefix_cost": "2.15",
"data_read_per_join": "20"
},
"used_columns": [
"service_id",
"module",
"code"
]
}
},
{
"table": {
"table_name": "storefronts_shippings",
"access_type": "index",
"key": "PRIMARY",
"used_key_parts": [
"storefront_id",
"shipping_id"
],
"key_length": "8",
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"using_index": true,
"using_join_buffer": "hash join",
"cost_info": {
"read_cost": "0.50",
"eval_cost": "0.01",
"prefix_cost": "2.65",
"data_read_per_join": "0"
},
"used_columns": [
"storefront_id",
"shipping_id"
],
"attached_condition": "(<if>(found_match(storefronts_shippings), ((`cscartdevel`.`storefronts_shippings`.`storefront_id` = 1) or (`cscartdevel`.`storefronts_shippings`.`storefront_id` is null)), true) and <if>(is_not_null_compl(storefronts_shippings), (`cscartdevel`.`storefronts_shippings`.`shipping_id` = `cscartdevel`.`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 |
| 45 |
Paczkomat InPost |
1-2 dni robocze od momentu wysyłki |
|
M |
a:30:{s:19:"ss_paczkomaty_token";s:0:"";s:24:"ss_paczkomaty_test_token";s:0:"";s:25:"ss_paczkomaty_shipping_id";s:2:"80";s:30:"ss_paczkomaty_test_shipping_id";s:2:"80";s:18:"ss_shipx_test_mode";s:1:"N";s:19:"ss_shipx_size_label";s:2:"A6";s:21:"ss_shipx_format_label";s:3:"pdf";s:23:"ss_shipx_default_status";s:0:"";s:21:"ss_shipx_weight_param";s:0:"";s:23:"ss_shipx_sending_method";s:14:"dispatch_order";s:20:"ss_shipx_disable_cod";s:1:"N";s:26:"ss_shipx_disable_insurance";s:1:"N";s:25:"ss_shipx_weekend_delivery";s:1:"N";s:13:"ss_shipx_size";s:1:"B";s:29:"ss_paczkomaty_displayed_types";s:3:"ALL";s:27:"ss_paczkomaty_dropoff_point";s:0:"";s:26:"ss_shipx_sender_point_name";s:0:"";s:20:"ss_shipx_sender_name";s:7:"Maslove";s:28:"ss_shipx_sender_company_name";s:7:"Maslove";s:26:"ss_shipx_sender_first_name";s:6:"Maciej";s:25:"ss_shipx_sender_last_name";s:9:"Basiński";s:21:"ss_shipx_sender_phone";s:9:"510203550";s:21:"ss_shipx_sender_email";s:18:"kontakt@maslove.pl";s:22:"ss_shipx_sender_street";s:12:"Przemysłowa";s:31:"ss_shipx_sender_building_number";s:1:"1";s:20:"ss_shipx_sender_city";s:9:"Wasilków";s:25:"ss_shipx_sender_post_code";s:6:"16-010";s:28:"ss_shipx_sender_country_code";s:2:"PL";s:28:"ss_shipx_sender_office_hours";s:4:"8-16";s:23:"ss_shipx_sender_comment";s:0:"";} |
I |
0.000 |
40.000 |
601 |
N |
shipx |
InPost_Paczkomaty |
Y |
| 47 |
Kurier Inpost |
1-2 dni robocze |
<p>Przesyłka kurierska pod wskazany adres.</p> |
M |
a:3:{s:24:"ss_baselinker_enable_map";s:1:"N";s:21:"ss_baselinker_service";a:10:{s:3:"dhl";s:1:"N";s:3:"dpd";s:1:"N";s:5:"fedex";s:1:"N";s:10:"furgonetka";s:1:"N";s:3:"gls";s:1:"N";s:6:"inpost";s:1:"Y";s:5:"meest";s:1:"N";s:7:"pocztex";s:1:"N";s:5:"orlen";s:1:"N";s:3:"ups";s:1:"N";}s:24:"ss_baselinker_point_type";s:3:"ALL";} |
I |
0.000 |
40.000 |
0 |
N |
|
|
Y |
| 48 |
Za pobraniem InPost |
1-2 dni robocze |
<p>Przesyłka kurierska InPost z płatnością przy odbiorze</p> |
M |
a:3:{s:24:"ss_baselinker_enable_map";s:1:"N";s:21:"ss_baselinker_service";a:10:{s:3:"dhl";s:1:"N";s:3:"dpd";s:1:"N";s:5:"fedex";s:1:"N";s:10:"furgonetka";s:1:"N";s:3:"gls";s:1:"N";s:6:"inpost";s:1:"Y";s:5:"meest";s:1:"N";s:7:"pocztex";s:1:"N";s:5:"orlen";s:1:"N";s:3:"ups";s:1:"N";}s:24:"ss_baselinker_point_type";s:8:"ONLY_COD";} |
I |
0.000 |
40.000 |
0 |
N |
|
|
Y |