Query time 0.00074
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": "(`atulecarter_atul_demo5`.`cscart_product_reviews`.`product_id` <=> 247)",
"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": "(`atulecarter_atul_demo5`.`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": [
"atulecarter_atul_demo5.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": [
"atulecarter_atul_demo5.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": "1K"
},
"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": [
"atulecarter_atul_demo5.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 |
| 40 |
247 |
0 |
Richard |
+ Camera |
- Battery life
- Performance |
I already had an old iPad when I decided to get this. Interesting at first, it became clear that this tablet is in some areas not as good as an iPad. I’m talking about battery life, the responsiveness of user interface, and performance in the apps and games. One thing it excels over the iPad is the camera, it’s much better than on iPad. My personal score for this tablet is 6/10. Good for those who never had a tablet or iPad before, not so much for everyone else. |
3 |
7f000001 |
N |
1484309040 |
|
|
0 |
|
0 |
0 |
A |
1 |
0 |
0 |
0 |
|
|
|
| 38 |
247 |
0 |
James |
|
|
I would never anticipate that Nokia will make an android tablet one day. But they did.
I bought it, tried it, it’s a typical 8-inch android tablet with a square-ish aspect ratio. Don’t expect miracles from it, it will deliver none. Specs are OK, the software is a bit of a different story though. After a month of use, it became a bit sluggish, and I had to install a cleaner app. I think Nokia can do better than that. |
3 |
7f000001 |
N |
1484308980 |
|
|
0 |
|
0 |
2 |
A |
1 |
1 |
4 |
2 |
|
|
|
| 39 |
247 |
0 |
Jeremy |
|
|
I left it on the driver seat of my car and accidentally sat on it. It broke in half and the service center refused to exchange it for a new one, telling me something about a “non-warranty case.” I’ll stick to a notebook and pen until they begin to manufacture something sturdier. |
2 |
7f000001 |
N |
1484308980 |
|
|
0 |
|
0 |
6 |
A |
1 |
1 |
6 |
0 |
|
|
|