select*from `bravo_tour_translations` where `locale` ='en'and `bravo_tour_translations`.`origin_id` in (22)2.32msbarianti_go2merzougaTourController.php#107
Bindings
0: en
Hints
0: 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 (22)710μsbarianti_go2merzougaTourController.php#107
Bindings
0: tour
1: 0
Hints
0: Use SELECT * only if you need all columns from table
selectcount(*) as aggregate from `bravo_review` where `object_id` =22and `object_model` ='tour'and `status` ='approved'and `bravo_review`.`deleted_at` isnull2.95msbarianti_go2merzougaTour.php#831
select*from `location_category_translations` where `locale` ='en'and `location_category_translations`.`origin_id` in (1, 2, 3)1.09msbarianti_go2merzougaTourController.php#133
Bindings
0: en
Hints
0: 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` =22and `object_model` ='tour'and `status` ='approved'and `bravo_review`.`deleted_at` isnull limit 11.14msbarianti_go2merzougaTour.php#757
Bindings
0: 22
1: tour
2: approved
Hints
0: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` =22and `object_model` ='tour'and `status` ='approved'and `bravo_review`.`deleted_at` isnull limit 11msbarianti_go2merzougaBookable.php#359
Bindings
0: 22
1: tour
2: approved
Hints
0:LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan