Query time 0.00081
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_21_apr`.`cscart_product_reviews`.`product_id` <=> 248)",
"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_21_apr`.`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_21_apr.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_21_apr.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_21_apr.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 |
| 42 |
248 |
0 |
Lisbeth |
|
|
I got this for my twin sons so they could stop fighting each other and learn how to compete in peaceful, positive ways. The problem of violence has gone away, but now there’s another one. They spend all day long playing games. I can only hope they’ll get tired of it someday. |
4 |
7f000001 |
N |
1484309400 |
|
|
0 |
|
0 |
3 |
A |
1 |
1 |
4 |
1 |
|
|
|
| 43 |
248 |
0 |
Bill |
+ Nice graphics and optimization |
- Controllers in general aren't the most suitable for shooters |
I have a PC already, got this to play some Xbox exclusives that didn’t come out yet on PC. I’m very satisfied with the optimization and graphics, less so with controls. Seriously, after a keyboard and mouse, how can a controller compare to them? Despite that, I really like to play low to mid active games, it’s very relaxing. But for real action gaming, you definitely need a PC. |
4 |
7f000001 |
N |
1484309400 |
|
|
1 |
Thank you for sharing your experience! X-Box One does support keyboard and mouse. Of course, the drawback is that you can't play from the couch with them :( |
1618476542 |
0 |
A |
1 |
0 |
0 |
0 |
0 |
|
|
| 41 |
248 |
0 |
Hugh |
+ Nice controller |
- Takes some time to get used to |
Never had a game console before (not talking about old handheld ones, another story), this is a totally new experience for me. I was mesmerized by the abundance of various games of all types of genres, some of them look more like interactive movies than something made from polygons and textures. Some games require you to stand up and move your body, something I was not expecting and was very excited about. The Xbox controller is very nice, grippy, with adjustable rumbling levels. Controls are something to get used to though.
Overall, I think I will recommend this console to my friends who still don’t have one or who have another one from Sony. Very joyful pastime. |
5 |
7f000001 |
N |
1484309340 |
|
|
0 |
|
0 |
5 |
A |
1 |
1 |
5 |
0 |
|
|
|