Query time 0.00203
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "5.10"
},
"ordering_operation": {
"using_filesort": true,
"nested_loop": [
{
"table": {
"table_name": "discussion_posts",
"access_type": "ref",
"possible_keys": [
"thread_id",
"thread_id_2"
],
"key": "thread_id",
"used_key_parts": [
"thread_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 12,
"rows_produced_per_join": 1,
"filtered": "10.00",
"cost_info": {
"read_cost": "3.00",
"eval_cost": "0.12",
"prefix_cost": "4.20",
"data_read_per_join": "537"
},
"used_columns": [
"post_id",
"thread_id",
"name",
"timestamp",
"user_id",
"ip_address",
"status"
],
"attached_condition": "(`goimagine`.`discussion_posts`.`status` = 'A')"
}
},
{
"table": {
"table_name": "discussion_messages",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"post_id"
],
"key_length": "3",
"ref": [
"goimagine.discussion_posts.post_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.36",
"eval_cost": "0.12",
"prefix_cost": "4.68",
"data_read_per_join": "28"
},
"used_columns": [
"message",
"post_id"
]
}
},
{
"table": {
"table_name": "discussion_rating",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"post_id"
],
"key_length": "3",
"ref": [
"goimagine.discussion_posts.post_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.30",
"eval_cost": "0.12",
"prefix_cost": "5.10",
"data_read_per_join": "19"
},
"used_columns": [
"rating_value",
"post_id"
]
}
}
]
}
}
}
Result
| post_id |
thread_id |
name |
timestamp |
user_id |
ip_address |
status |
message |
rating_value |
| 1848 |
856 |
Sandra DeSoto |
1668101880 |
33 |
aecb4c99 |
A |
This is my second time to order from Sing-a-long Soaps. Their soaps are amazing. I ordered the charcoal soap and it is wonderful. I’ll be ordering again |
5 |
| 1771 |
856 |
Stephanie Romkey |
1663876740 |
4512 |
2f0e8e4d |
A |
I've purchased soap from Sing-Along before... but my new obsession is the shower steamers. They smell amazing and they seem to last longer than others I've tried in the shower. Will be ordering more to have on hand. |
5 |
| 1171 |
856 |
Sandra DeSoto |
1644018780 |
33 |
aecb2e84 |
A |
I ordered their special sandalwood with anise and I loved it... it smelled so nice and I couldn’t wait to use it. I’ll be ordering again. |
5 |
| 944 |
856 |
stephanie |
1638565980 |
325 |
2f0e8e4d |
A |
looooved the soap! Java Jive is my new favorite, not over powering at all. so glad I got the soap decks as well, they are perfect. |
5 |
| 708 |
856 |
Deborah Johns |
1629125880 |
3839 |
b83df9a0 |
A |
These soap dishes are made with such high quality and the soap is amazing! Good communication from the seller and shipped fast! |
5 |
| 698 |
856 |
Crystal Hayes |
1628730960 |
5859 |
4c162fa7 |
A |
Amazing soap! Smells so pretty and leaves my hands feeling clean and soft. Highly recommend. |
5 |
| 411 |
856 |
Shirley L Walle |
1617319620 |
414 |
ccc37710 |
A |
I bought the Rose Clay Bar of soap as a gift. It's been sitting in my dining room for more than two months, and though I won't be using it myself, I wanted to at least say that the aroma is just as luscious and lasting as when I first received it. And the Natural Pine Wood Soap Deck is a perfect accompaniment. The Rose soap and deck will be going to their home this month. Shipping was prompt, good communication. Thanks much! ♥ Shirley @ Wild Gatherings |
5 |
| 329 |
856 |
Gracie R |
1611257520 |
1622 |
b858feb8 |
A |
I got two soaps and they smell really good! They were shipped really fast!!! |
5 |
| 263 |
856 |
Trevor |
1606925220 |
2735 |
60e93382 |
A |
I shave my head at least once a week and no matter what I have tried for commercial shaving gels and creams, my head is always itchy and dry after shaving it. I ordered the Tuff Enuff and Cold as Ice shaving soaps hoping for a different result and I was not disappointed. The soaps arrived quickly. They smelled amazing right out of the package. I used the Tuff Enuff soap last time I shaved and wow what a difference. It lathered well, rinsed well, smelled amazing, and my head felt GREAT afterwards. I'll never go back to the chemical-filled foams and gels now that I've tried these natural options. Thank you for making an awesome product! |
5 |
| 236 |
856 |
Tiffany Martinez |
1603154100 |
984 |
615db818 |
A |
I waited a bit to try them out before reviewing, but now I can honestly say I love the scents. I love the sample packs also. Now I can pick which ones I want full size. Will definitely order again once my samples run out. It's been almost a month and still going strong. |
5 |