Query time 0.00050
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "3.12"
},
"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": 2,
"rows_produced_per_join": 0,
"filtered": "10.00",
"index_condition": "(`danishecarter_25_march`.`cscart_product_reviews`.`product_id` <=> 228)",
"cost_info": {
"read_cost": "2.00",
"eval_cost": "0.04",
"prefix_cost": "2.40",
"data_read_per_join": "334"
},
"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.20",
"eval_cost": "0.04",
"prefix_cost": "2.64",
"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.20",
"eval_cost": "0.04",
"prefix_cost": "2.88",
"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": [
"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.20",
"eval_cost": "0.04",
"prefix_cost": "3.12",
"data_read_per_join": "80"
},
"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 |
2 |
228 |
0 |
A PC Hardware Fan |
|
Can't configure brightness, contrast, etc. for a nice look |
This monitor is way too light (everything appears faded out), and adjusting the contrast and brightness controls don't help. No matter what brightness contrast setting is used, everything is either way too dim & gray or way too light. The monitor's brightness & contrast controls seem to have the exact same function - contrast setting appears to actually be adjusting the brightness and nothing seems to be actually changing the contrast. This will probably be returned soon, unless someone can tell me how to get the correct brightness/contrast setting. |
2 |
7f000001 |
N |
1129559367 |
|
|
1 |
Sorry to hear you ran into this problem. Have you tried enabling full dynamic range in your videocard driver settings? Usually it provides a much better image. |
1618556137 |
-3 |
A |
1 |
0 |
0 |
3 |
0 |
|
|
1 |
228 |
3 |
Tom |
+ Sharp focus
+ No ghosting in games |
- Can't rotate the screen |
I first noticed this monitor at one of those computer stores where they place all the monitors on the same shelf. This one really stood out for color and very sharp focus. I watch movies and play some games and I haven't noticed any ghosting. The only thing that I wish I could do is rotate the screen for word processing (kind of a minor complaint). Otherwise this is a very good monitor and the price is good for a 3D LCD. |
4 |
7f000001 |
N |
1129547428 |
|
|
0 |
|
0 |
-3 |
A |
1 |
0 |
1 |
4 |
|
|
|