{
"query_block": {
"select_id": 1,
"read_sorted_file": {
"filesort": {
"sort_key": "cscart_discussion_posts.`timestamp` desc",
"table": {
"table_name": "cscart_discussion_posts",
"access_type": "ref",
"possible_keys": ["thread_id", "thread_id_2"],
"key": "thread_id_2",
"key_length": "6",
"used_key_parts": ["thread_id", "status"],
"ref": ["const", "const"],
"rows": 1,
"filtered": 100,
"index_condition": "cscart_discussion_posts.`status` = 'A'",
"attached_condition": "cscart_discussion_posts.thread_id <=> 17420 and cscart_discussion_posts.`status` <=> 'A'"
}
}
},
"table": {
"table_name": "cscart_discussion_messages",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["post_id"],
"ref": ["cscart_migrate.cscart_discussion_posts.post_id"],
"rows": 1,
"filtered": 100
},
"table": {
"table_name": "cscart_discussion_rating",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["post_id"],
"ref": ["cscart_migrate.cscart_discussion_posts.post_id"],
"rows": 1,
"filtered": 100
}
}
}
| post_id | thread_id | name | timestamp | user_id | ip_address | status | message | rating_value | |
|---|---|---|---|---|---|---|---|---|---|
| 5974 | 17420 | Mary Kay | 1376841660 | 0 | 173.88.92.28 | A | We bought the 16" galvanized with red cage to go above our kitchen table. We are pleased with the overall quality and styling. We originally ordered the clear glass and it ended up being too bright out the top area. It also left a sunburst shadow on the ceiling which we didn't care for. We switched it out for the frosted glass. We also bought a socket extender (local hardware store) to adjust the bulb to make it sit lower in shade. Now, with these adjustments the light is great! | 5 |