select*from `bravo_locations` where `bravo_locations`.`id` in ('') and `bravo_locations`.`deleted_at` isnull560μs/modules/Space/Controllers/SpaceController.php:91tripura_nature_trails_and_resorts
Metadata
Bindings
0.
Hints
Use SELECT * only if you need all columns from table
select*from `bravo_space_translations` where `bravo_space_translations`.`origin_id` in (25) and `bravo_space_translations`.`deleted_at` isnull510μs/modules/Space/Controllers/SpaceController.php:91tripura_nature_trails_and_resorts
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `user_wishlist` where `object_model` ='space'and `user_id` =0and `user_wishlist`.`object_id` in (25)490μs/modules/Space/Controllers/SpaceController.php:91tripura_nature_trails_and_resorts
Metadata
Bindings
0. space
1. 0
Hints
Use SELECT * only if you need all columns from table
selectcount(*) as aggregate from `bravo_review` where `object_id` =25and `object_model` ='space'and `status` ='approved'and `bravo_review`.`deleted_at` isnull890μs/modules/Space/Models/Space.php:723tripura_nature_trails_and_resorts
select*from `location_category_translations` where `locale` ='egy'and `location_category_translations`.`origin_id` in (4, 5)500μs/modules/Space/Controllers/SpaceController.php:106tripura_nature_trails_and_resorts
Metadata
Bindings
0. egy
Hints
Use SELECT * only if you need all columns from table
selectAVG(rate_number) as score_total , COUNT(id) as total_review from `bravo_review` where `object_id` =25and `object_model` ='space'and `status` ='approved'and `bravo_review`.`deleted_at` isnull limit 1830μs/modules/Space/Models/Space.php:669tripura_nature_trails_and_resorts
Metadata
Bindings
0. 25
1. space
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` =25and `object_model` ='space'and `status` ='approved'and `bravo_review`.`deleted_at` isnull limit 1870μs/modules/Booking/Models/Bookable.php:370tripura_nature_trails_and_resorts
Metadata
Bindings
0. 25
1. space
2. approved
Hints
LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan