Query time 0.00175
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "3.60"
},
"ordering_operation": {
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "cscart_shippings",
"access_type": "const",
"possible_keys": [
"shipping_id",
"c_status"
],
"key": "shipping_id",
"used_key_parts": [
"shipping_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"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"
]
}
},
{
"table": {
"table_name": "cscart_shipping_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"shipping_id",
"lang_code"
],
"key_length": "9",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "984"
},
"used_columns": [
"shipping_id",
"lang_code",
"shipping",
"delivery_time",
"description"
]
}
},
{
"table": {
"table_name": "cscart_shipping_services",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"sa"
],
"key": "PRIMARY",
"used_key_parts": [
"service_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 0,
"rows_produced_per_join": 1,
"filtered": "0.00",
"unique_row_not_found": true,
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"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,
"cost_info": {
"read_cost": "3.08",
"eval_cost": "0.52",
"prefix_cost": "3.60",
"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` = 212), 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 |
212 |
Mia Dolce Case - Italy Only |
|
|
M |
a:0:{} |
I |
0.000 |
0.000 |
0 |
N |
|
|
Y |