select*from `bravo_locations` where `bravo_locations`.`id` in ('') and `bravo_locations`.`deleted_at` isnull1.08ms/modules/Tour/Controllers/TourController.php:88tripura_nature_trails_and_resorts
Metadata
Bindings
0.
Hints
Use SELECT * only if you need all columns from table
select*from `bravo_tour_translations` where `bravo_tour_translations`.`origin_id` in (33)550μs/modules/Tour/Controllers/TourController.php:88tripura_nature_trails_and_resorts
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `user_wishlist` where `object_model` ='tour'and `user_id` =0and `user_wishlist`.`object_id` in (33)480μs/modules/Tour/Controllers/TourController.php:88tripura_nature_trails_and_resorts
Metadata
Bindings
0. tour
1. 0
Hints
Use SELECT * only if you need all columns from table
selectcount(*) as aggregate from `bravo_review` where `object_id` =33and `object_model` ='tour'and `status` ='approved'and `bravo_review`.`deleted_at` isnull770μs/modules/Tour/Models/Tour.php:824tripura_nature_trails_and_resorts
selectAVG(rate_number) as score_total , COUNT(id) as total_review from `bravo_review` where `object_id` =33and `object_model` ='tour'and `status` ='approved'and `bravo_review`.`deleted_at` isnull limit 1700μs/modules/Tour/Models/Tour.php:750tripura_nature_trails_and_resorts
Metadata
Bindings
0. 33
1. tour
2. approved
Hints
LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
selectCOUNT( id ) AS total_review, COUNT( CASEWHEN rate_number >=4THEN1ELSEnullEND ) as total_review_recommend from `bravo_review` where `object_id` =33and `object_model` ='tour'and `status` ='approved'and `bravo_review`.`deleted_at` isnull limit 1830μs/modules/Booking/Models/Bookable.php:370tripura_nature_trails_and_resorts
Metadata
Bindings
0. 33
1. tour
2. approved
Hints
LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan