Query time 0.00289
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "1.55"
},
"ordering_operation": {
"using_filesort": true,
"grouping_operation": {
"using_temporary_table": true,
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "languages",
"access_type": "index",
"possible_keys": [
"PRIMARY",
"idx_storefront_id"
],
"key": "PRIMARY",
"used_key_parts": [
"storefront_id",
"language_id"
],
"key_length": "8",
"rows_examined_per_scan": 7,
"rows_produced_per_join": 0,
"filtered": "14.29",
"using_index": true,
"cost_info": {
"read_cost": "1.10",
"eval_cost": "0.10",
"prefix_cost": "1.20",
"data_read_per_join": "15"
},
"used_columns": [
"storefront_id",
"language_id"
],
"attached_condition": "((`s2cart`.`languages`.`language_id` = 2) and (`s2cart`.`languages`.`storefront_id` is not null))"
}
},
{
"table": {
"table_name": "storefronts",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"storefront_id"
],
"key_length": "4",
"ref": [
"s2cart.languages.storefront_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.25",
"eval_cost": "0.10",
"prefix_cost": "1.55",
"data_read_per_join": "2K"
},
"used_columns": [
"storefront_id",
"url",
"redirect_customer",
"is_default",
"status",
"access_key",
"name",
"theme_name",
"is_accessible_for_authorized_customers_only"
]
}
}
]
}
}
}
}
Result
storefront_id |
url |
redirect_customer |
is_default |
status |
access_key |
name |
theme_name |
is_accessible_for_authorized_customers_only |
1 |
www.stock2cart.com |
N |
Y |
N |
123 |
www.stock2cart.com |
abt__unitheme2 |
N |
2 |
firmkart.com |
Y |
N |
Y |
12354 |
GEESYS Technologies India Private Limited |
abt__unitheme2 |
N |
4 |
www.shop.geesysindia.com |
N |
N |
N |
d6b46e6200726efb4cbd0e6323d1ba53 |
Geesys Shopping Site |
abt__unitheme2 |
N |