Query time 0.00082
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "1.47"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "0.05"
},
"nested_loop": [
{
"table": {
"table_name": "storefronts_shippings",
"access_type": "system",
"rows_examined_per_scan": 0,
"rows_produced_per_join": 1,
"filtered": "0.00",
"const_row_not_found": true,
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.10",
"prefix_cost": "0.00",
"data_read_per_join": "16"
},
"used_columns": [
"storefront_id",
"shipping_id"
]
}
},
{
"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": 2,
"rows_produced_per_join": 0,
"filtered": "2.50",
"index_condition": "(`cscartdb`.`cscart_shippings`.`shipping_id` in (176,192))",
"cost_info": {
"read_cost": "1.40",
"eval_cost": "0.01",
"prefix_cost": "1.41",
"data_read_per_join": "118"
},
"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": "((`cscartdb`.`cscart_shippings`.`status` = 'A') and (`cscartdb`.`cscart_shippings`.`min_weight` <= 0.001) and ((`cscartdb`.`cscart_shippings`.`max_weight` >= 0.001) or (`cscartdb`.`cscart_shippings`.`max_weight` = 0.000)) and ((`cscartdb`.`cscart_shippings`.`usergroup_ids` = '') or (0 <> find_in_set(0,`cscartdb`.`cscart_shippings`.`usergroup_ids`)) or (0 <> find_in_set(1,`cscartdb`.`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": [
"cscartdb.cscart_shippings.shipping_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.01",
"prefix_cost": "1.42",
"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": [
"cscartdb.cscart_shippings.service_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.01",
"prefix_cost": "1.42",
"data_read_per_join": "20"
},
"used_columns": [
"service_id",
"module",
"code"
]
}
}
]
}
}
}
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 |
176 |
USPS |
3-5 days |
|
M |
a:0:{} |
I |
0.000 |
0.000 |
0 |
N |
|
|
Y |
192 |
Free Shipping |
3-5 days |
|
M |
a:0:{} |
I |
0.000 |
0.000 |
0 |
N |
|
|
Y |