{
"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": 4,
"filtered": 100,
"index_condition": "cscart_discussion_posts.`status` = 'A'",
"attached_condition": "cscart_discussion_posts.thread_id <=> 22682 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 | |
|---|---|---|---|---|---|---|---|---|---|
| 125133 | 22682 | Erica L | 1631121480 | 0 | 4610419a | A | We purchased two mini eclipse sconces for a spare bedroom and they are great for our guests! We love them. | 5 | |
| 119147 | 22682 | Deb | 1462619220 | 0 | 74.78.124.7 | A | I bought four of these mini galvanized lights to go over my working stations in my new farmhouse kitchen. They are perfect - exactly what I was looking for. I would definitely recommend if you like this look. The company was great to work with. | 5 | |
| 10213 | 22682 | chris | 1394298480 | 0 | 173.190.158.145 | A | I bought a white mini gooseneck and am very happy with it. Perfect size and style for what I needed. White powdercoat very good thickness and consistency. Recommend product to all. | 4 | |
| 7073 | 22682 | Robin | 1383933240 | 0 | 24.105.223.160 | A | Overall, this lamp looks good--it has a beautiful bronze finish and very nice shape. However, the metal used in the shade is quite thin--thinner than desk lamps I use--which, to me, slightly cheapens the overall look and makes the lamp more vulnerable to damage. | 4 |