select*from `bravo_locations` where `bravo_locations`.`id` in ('') and `bravo_locations`.`deleted_at` isnull470μs/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 (35)540μ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 (35)430μ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` =35and `object_model` ='tour'and `status` ='approved'and `bravo_review`.`deleted_at` isnull680μ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` =35and `object_model` ='tour'and `status` ='approved'and `bravo_review`.`deleted_at` isnull limit 1790μs/modules/Tour/Models/Tour.php:750tripura_nature_trails_and_resorts
Metadata
Bindings
0. 35
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` =35and `object_model` ='tour'and `status` ='approved'and `bravo_review`.`deleted_at` isnull limit 1900μs/modules/Booking/Models/Bookable.php:370tripura_nature_trails_and_resorts
Metadata
Bindings
0. 35
1. tour
2. approved
Hints
LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan