Query time 0.00075
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_25_march`.`cscart_product_reviews`.`product_id` <=> 246)",
"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_25_march`.`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_25_march.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_25_march.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_25_march.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 |
| 37 |
246 |
0 |
Robert |
|
|
It was a good camera… Unfortunately, now it’s lying at the bottom of the Adriatic. I’ll buy a new one soon and will be more careful next time. |
5 |
7f000001 |
N |
1484307780 |
|
|
1 |
Sorry to hear about that! We can offer you a small discount as consolation. We'll reach out to you and let you know how you can claim it ;-) |
1618477438 |
0 |
A |
1 |
0 |
0 |
0 |
0 |
|
|
| 35 |
246 |
0 |
Mark |
|
|
I received it as a present from my friends. I’m a lover of extreme activities and I also love to record my activities and share it with friends, family, and other people interested in all things extreme. My previous camera, the original Hero, was good enough, but my friends just thought that I may want to try this new Hero3+. It comes with a waterproof case so splashes and waves are not a problem. It also records video in 1080p with 50 frames per second which is a major improvement for me. |
5 |
7f000001 |
N |
1484307720 |
|
|
0 |
|
0 |
0 |
A |
1 |
1 |
2 |
0 |
|
|
|
| 36 |
246 |
0 |
Jessica |
|
|
We (me and my hubby) bought this camera for our trip to Italy. The videos we took on that trip were as sharp as photos! We tried to visit all the popular places in Italy and thanks to the quality of videos we can refresh our good memories as much as we want to! |
5 |
7f000001 |
N |
1484307720 |
|
|
0 |
|
0 |
2 |
A |
1 |
1 |
3 |
1 |
|
|
|