selectcount(*) as aggregate from (select `bravo_tours`.*from `bravo_tours` where `bravo_tours`.`status` ='publish'and `bravo_tours`.`deleted_at` isnullgroupby `bravo_tours`.`id`) as `aggregate_table`117msxpusoxqk_mainTourController.php#51
select*from `bravo_location_translations` where `locale` ='en'and `bravo_location_translations`.`origin_id` in (11)83.4msxpusoxqk_mainTourController.php#51
Bindings
0: en
Hints
0: Use SELECT * only if you need all columns from table
select `bravo_terms`.*, (selectcount(*) from `bravo_tours` innerjoin `bravo_tour_term` on `bravo_tours`.`id` = `bravo_tour_term`.`tour_id` where `bravo_terms`.`id` = `bravo_tour_term`.`term_id` and `bravo_tours`.`deleted_at` isnull) as `tour_count` from `bravo_terms` where `bravo_terms`.`attr_id` in (16, 17) and `bravo_terms`.`deleted_at` isnull2.41sxpusoxqk_mainTourController.php#97
select*from `bravo_attrs_translations` where `locale` ='en'and `bravo_attrs_translations`.`origin_id` in (16, 17)1.19sxpusoxqk_mainTourController.php#97
Bindings
0: en
Hints
0: Use SELECT * only if you need all columns from table
selectCOUNT( id ) AS total_review, COUNT( CASEWHEN rate_number >=4THEN1ELSEnullEND ) as total_review_recommend from `bravo_review` where `object_id` =23and `object_model` ='tour'and `status` ='approved'and `bravo_review`.`deleted_at` isnull limit 115.78msxpusoxqk_mainBookable.php#359
Bindings
0: 23
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 110.34msxpusoxqk_mainBookable.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
selectCOUNT( id ) AS total_review, COUNT( CASEWHEN rate_number >=4THEN1ELSEnullEND ) as total_review_recommend from `bravo_review` where `object_id` =21and `object_model` ='tour'and `status` ='approved'and `bravo_review`.`deleted_at` isnull limit 11.61msxpusoxqk_mainBookable.php#359
Bindings
0: 21
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` =20and `object_model` ='tour'and `status` ='approved'and `bravo_review`.`deleted_at` isnull limit 12.3msxpusoxqk_mainBookable.php#359
Bindings
0: 20
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` =19and `object_model` ='tour'and `status` ='approved'and `bravo_review`.`deleted_at` isnull limit 110.33msxpusoxqk_mainBookable.php#359
Bindings
0: 19
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` =18and `object_model` ='tour'and `status` ='approved'and `bravo_review`.`deleted_at` isnull limit 14.69msxpusoxqk_mainBookable.php#359
Bindings
0: 18
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` =17and `object_model` ='tour'and `status` ='approved'and `bravo_review`.`deleted_at` isnull limit 1900μsxpusoxqk_mainBookable.php#359
Bindings
0: 17
1: tour
2: approved
Hints
0:LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan