Query time 0.00059
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "4.68"
},
"ordering_operation": {
"using_filesort": true,
"nested_loop": [
{
"table": {
"table_name": "cscart_product_reviews",
"access_type": "ref",
"possible_keys": [
"idx_product_id"
],
"key": "idx_product_id",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 3,
"rows_produced_per_join": 0,
"filtered": "10.00",
"index_condition": "(`danishecarter_latest`.`cscart_product_reviews`.`product_id` <=> 150)",
"cost_info": {
"read_cost": "3.00",
"eval_cost": "0.06",
"prefix_cost": "3.60",
"data_read_per_join": "501"
},
"used_columns": [
"product_review_id",
"product_id",
"user_id",
"name",
"advantages",
"disadvantages",
"comment",
"rating_value",
"ip_address",
"is_buyer",
"product_review_timestamp",
"country_code",
"city",
"reply_user_id",
"reply",
"reply_timestamp",
"helpfulness",
"status",
"storefront_id",
"images_count",
"vote_up",
"vote_down"
],
"attached_condition": "(`danishecarter_latest`.`cscart_product_reviews`.`status` = 'A')"
}
},
{
"table": {
"table_name": "cscart_users",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"user_id"
],
"key_length": "3",
"ref": [
"danishecarter_latest.cscart_product_reviews.reply_user_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.30",
"eval_cost": "0.06",
"prefix_cost": "3.96",
"data_read_per_join": "1K"
},
"used_columns": [
"user_id",
"company_id"
]
}
},
{
"table": {
"table_name": "cscart_companies",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id"
],
"key_length": "4",
"ref": [
"danishecarter_latest.cscart_users.company_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.30",
"eval_cost": "0.06",
"prefix_cost": "4.32",
"data_read_per_join": "2K"
},
"used_columns": [
"company_id",
"company"
]
}
},
{
"table": {
"table_name": "cscart_country_descriptions",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"code",
"lang_code"
],
"key_length": "12",
"ref": [
"danishecarter_latest.cscart_product_reviews.country_code",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.30",
"eval_cost": "0.06",
"prefix_cost": "4.68",
"data_read_per_join": "120"
},
"used_columns": [
"code",
"lang_code",
"country"
]
}
}
]
}
}
}
Result
| product_review_id |
product_id |
user_id |
name |
advantages |
disadvantages |
comment |
rating_value |
ip_address |
is_buyer |
product_review_timestamp |
country_code |
city |
reply_user_id |
reply |
reply_timestamp |
helpfulness |
status |
storefront_id |
images_count |
vote_up |
vote_down |
reply_company_id |
reply_company |
country |
| 20 |
150 |
0 |
Julia |
|
|
Got this bike with a discount, a really affordable option for most people out there. I got almost 100 miles on it, no problems so far. Don’t forget to clean it after every ride. |
5 |
7f000001 |
N |
1484901840 |
|
|
0 |
|
0 |
0 |
A |
1 |
0 |
0 |
0 |
|
|
|
| 21 |
150 |
0 |
Steve |
+ Price
+ It worked for me... in a city. |
- It didn't work for me when I went cross-country. |
I know it’s not an MTB, but I used it for some hardcore cross-country riding! Had to replace almost half of the parts after the first two rides, they just won’t do at all. Can't blame the manufacturer or the store for it though. So, if you're looking for a city bike, this may as well be a good choice. |
4 |
7f000001 |
N |
1484901900 |
|
|
0 |
|
0 |
0 |
A |
1 |
0 |
0 |
0 |
|
|
|
| 22 |
150 |
0 |
Rosa |
|
|
I wish it had a softer seat… Besides that, I use it for short park riding, and it provides a very smooth riding experience. |
3 |
7f000001 |
N |
1484901900 |
|
|
0 |
|
0 |
0 |
A |
1 |
0 |
0 |
0 |
|
|
|