| # | Time | Query |
|---|
| 1 |
3.96 ms |
INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,... |
| 2 |
0.79 ms |
SELECT * FROM `languages` WHERE TRUE AND `short` = 'en' |
| 3 |
0.83 ms |
SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'published' AND `group` = 'products_status' ORDER BY `id` DESC LIMIT 0 , 30 |
| 4 |
0.42 ms |
SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'active' AND `group` = 'products_status_booking' ORDER BY `id` DESC LIMIT 0 , 30 |
| 5 |
1.77 ms |
SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4781 AND p.`status` = '23' AND p.`status_booking` = '9' ORDER BY `id` DESC |
| 6 |
1.6 ms |
SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4781 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 1000 |
| 7 |
0.57 ms |
SELECT * FROM `product_system_meta` WHERE TRUE AND `id_product` = 4781 AND `metaname` = 'bookingextranote' ORDER BY `id` DESC LIMIT 0 , 30 |
| 8 |
0.43 ms |
SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'active' AND `group` = 'review_status' ORDER BY `id` DESC LIMIT 0 , 30 |
| 9 |
0.35 ms |
SELECT * FROM `type` WHERE TRUE AND `id` = 2 ORDER BY `id` DESC LIMIT 0 , 30 |
| 10 |
0.55 ms |
SELECT SUM(rating_valueformoney) as rating_valueformoney, SUM(rating_convenience) as rating_convenience, SUM(rating_accessibility) as rating_accessibility, SUM(rating_overall) as rating_overall FROM `reviews` WHERE TRUE AND `id_product` = 4781 AND `status` = '26' |
| 11 |
0.31 ms |
SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'group' ORDER BY `id` DESC LIMIT 0 , 30 |
| 12 |
0.31 ms |
SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'active' AND `group` = 'sub_product_status' ORDER BY `id` DESC LIMIT 0 , 30 |
| 13 |
2.38 ms |
SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4781 AND `type` = 4 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30 |
| 14 |
0.79 ms |
SELECT * FROM `languages` WHERE TRUE AND `id` = 1 |
| 15 |
0.5 ms |
SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4781 ORDER BY `show_order` asc LIMIT 0 , 30 |
| 16 |
0.42 ms |
SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4781 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30 |
| 17 |
1.92 ms |
SELECT sb.*, lg.name as language, t.name as groupType ,t.id as groupTypeId,lg.id as languageId, pp.price as price,pp.id as priceId FROM `sub_product` sb inner join languages lg on sb.id_language = lg.id inner join type t on t.id = sb.type left join product_prices pp on pp.id_subproduct = sb.id... |
| 18 |
0.35 ms |
SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4781 AND `status` = '15' ORDER BY `id_language` DESC LIMIT 0 , 30 |
| 19 |
0.2 ms |
SELECT * FROM `type` WHERE TRUE AND `id` = 4 ORDER BY `id` DESC LIMIT 0 , 30 |
| 20 |
1.05 ms |
SELECT * FROM `setting` WHERE TRUE AND `st_group` = 'fileServices' AND `st_key` = 'calendar' |
| 21 |
0.46 ms |
SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC |
| 22 |
1.56 ms |
SELECT * FROM `supplier_meta` WHERE TRUE AND `id_supplier` = 36 ORDER BY `id` DESC LIMIT 0 , 1000 |
| 23 |
1.66 ms |
SELECT * FROM `product_system` WHERE TRUE AND `id_product_dotravel` = 4781 ORDER BY `id` DESC |
| 24 |
0.42 ms |
SELECT SUM(rating_overall) / count(*) as rating_overall FROM `reviews` WHERE TRUE AND `id_product` = 4781 AND `status` = '26' |
| 25 |
0.3 ms |
SELECT COUNT(*) FROM `reviews` WHERE status in (select id from status s where s.name = 'active' and s.group = 'review_status') AND `id_product` = 4781 |
| 26 |
14.35 ms |
select r.*, c.firstname , c.lastname,(select metavalue from customer_meta where id_customer = c.id and metaname = 'avatar') as avatar from reviews r inner join customers c on c.id = r.id_customer WHERE TRUE AND `id_product` = 4781 AND r.`status` = '26' ORDER BY `rating_overall` DESC LIMIT 0 , 5 |
| 27 |
0.78 ms |
SELECT * FROM `languages` WHERE TRUE AND `name` = 'English' |
| 28 |
1.62 ms |
SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4781 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30 |
| 29 |
0.3 ms |
SELECT * FROM `product_prices` WHERE TRUE AND `id_subproduct` = 3807 ORDER BY `id` DESC LIMIT 0 , 30 |
| 30 |
1.21 ms |
SELECT * FROM `age_group` WHERE TRUE ORDER BY `id` DESC LIMIT 0 , 30 |
| 31 |
0.32 ms |
SELECT * FROM `product_bookingfees` WHERE TRUE ORDER BY `id` DESC LIMIT 0 , 30 |
| 32 |
0.29 ms |
SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4781 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30 |
| 33 |
1.31 ms |
SELECT * FROM `product_advantage` WHERE TRUE AND `id_product` = 4781 ORDER BY `id` DESC LIMIT 0 , 30 |
| 34 |
0.51 ms |
SELECT sb.*, t.name AS type_name FROM `subproduct_blockeddates` AS sb INNER JOIN `type` AS t ON sb.block_type = t.id WHERE t.`group` = 'subproduct_blockeddates_block_type' AND sb.`id_subproduct` = 3807 ORDER BY sb.`id` DESC |
| 35 |
0.38 ms |
SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'private' ORDER BY `id` DESC LIMIT 0 , 30 |
| 36 |
0.22 ms |
SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'group' ORDER BY `id` DESC LIMIT 0 , 30 |
| 37 |
0.57 ms |
SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4781 AND `type` = 5 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30 |
| 38 |
0.28 ms |
SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4781 AND `type` = 4 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30 |
| 39 |
0.51 ms |
SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4781 AND `id_language` = 1 AND `metaname` = 'availability_next_date' ORDER BY `id` DESC LIMIT 0 , 30 |
