| # | Time | Query |
|---|
| 1 |
4.3 ms |
SELECT url, namespace, method, content_redirection FROM `redirect` WHERE status = 1 |
| 2 |
3.86 ms |
SELECT * FROM `setting` WHERE TRUE |
| 3 |
31.63 ms |
INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,... |
| 4 |
29.26 ms |
SELECT * FROM `languages` WHERE TRUE AND `short` = 'en' |
| 5 |
0.99 ms |
SELECT * FROM `setting` WHERE TRUE AND `st_group` = 'fileServices' AND `st_key` = 'currency' |
| 6 |
0.27 ms |
SET SESSION group_concat_max_len = 1000000 |
| 7 |
83.91 ms |
SELECT dm.name, ANY_VALUE(dm.index_content) AS index_content, GROUP_CONCAT( '"', dma.name, '":{"id":', d.id, ',', '"name":', '"', dma.name, '",', '"seo":', '"', dma.seo_url, '",', '"type":', '"', COALESCE(dt.name, ''), '"', ',', '"index_content":', COALESCE(NULLIF(dma.index_content, ''), 'null'),... |
| 8 |
33.14 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 |
| 9 |
0.52 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 |
| 10 |
0.9 ms |
SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4718 AND p.`status` = '23' AND p.`status_booking` = '9' ORDER BY `id` DESC |
| 11 |
0.28 ms |
SELECT * FROM `languages` WHERE TRUE AND `name` = 'English' |
| 12 |
5.86 ms |
SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4718 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 1000 |
| 13 |
2.98 ms |
SELECT * FROM `product_system_meta` WHERE TRUE AND `id_product` = 4718 AND `metaname` = 'bookingextranote' ORDER BY `id` DESC LIMIT 0 , 30 |
| 14 |
0.58 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 |
| 15 |
0.27 ms |
SELECT * FROM `type` WHERE TRUE AND `id` = 2 ORDER BY `id` DESC LIMIT 0 , 30 |
| 16 |
4.07 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` = 4718 AND `status` = '26' |
| 17 |
0.62 ms |
SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'group' ORDER BY `id` DESC LIMIT 0 , 30 |
| 18 |
0.58 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 |
| 19 |
6.08 ms |
SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4718 AND `type` = 4 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30 |
| 20 |
0.48 ms |
SELECT * FROM `languages` WHERE TRUE AND `id` = 1 |
| 21 |
2.72 ms |
SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4718 ORDER BY `show_order` asc LIMIT 0 , 30 |
| 22 |
3.9 ms |
SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4718 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30 |
| 23 |
3.32 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... |
| 24 |
0.57 ms |
SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4718 AND `status` = '15' ORDER BY `id_language` DESC LIMIT 0 , 30 |
| 25 |
0.38 ms |
SELECT * FROM `type` WHERE TRUE AND `id` = 4 ORDER BY `id` DESC LIMIT 0 , 30 |
| 26 |
0.73 ms |
SELECT * FROM `setting` WHERE TRUE AND `st_group` = 'fileServices' AND `st_key` = 'calendar' |
| 27 |
2.39 ms |
SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC |
| 28 |
3.44 ms |
SELECT * FROM `supplier_meta` WHERE TRUE AND `id_supplier` = 36 ORDER BY `id` DESC LIMIT 0 , 1000 |
| 29 |
3.01 ms |
SELECT * FROM `product_system` WHERE TRUE AND `id_product_dotravel` = 4718 ORDER BY `id` DESC |
| 30 |
0.66 ms |
SELECT SUM(rating_overall) / count(*) as rating_overall FROM `reviews` WHERE TRUE AND `id_product` = 4718 AND `status` = '26' |
| 31 |
0.45 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` = 4718 |
| 32 |
1.49 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` = 4718 AND r.`status` = '26' ORDER BY `rating_overall` DESC LIMIT 0 , 5 |
| 33 |
2.78 ms |
SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4718 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30 |
| 34 |
0.48 ms |
SELECT * FROM `product_prices` WHERE TRUE AND `id_subproduct` = 3744 ORDER BY `id` DESC LIMIT 0 , 30 |
| 35 |
2.74 ms |
SELECT * FROM `age_group` WHERE TRUE ORDER BY `id` DESC LIMIT 0 , 30 |
| 36 |
2.26 ms |
SELECT * FROM `product_bookingfees` WHERE TRUE ORDER BY `id` DESC LIMIT 0 , 30 |
| 37 |
0.74 ms |
SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4718 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30 |
| 38 |
2.83 ms |
SELECT * FROM `product_advantage` WHERE TRUE AND `id_product` = 4718 ORDER BY `id` DESC LIMIT 0 , 30 |
| 39 |
3.37 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` = 3744 ORDER BY sb.`id` DESC |
| 40 |
0.56 ms |
SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'private' ORDER BY `id` DESC LIMIT 0 , 30 |
| 41 |
0.38 ms |
SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'group' ORDER BY `id` DESC LIMIT 0 , 30 |
| 42 |
0.84 ms |
SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4718 AND `type` = 5 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30 |
| 43 |
0.43 ms |
SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4718 AND `type` = 4 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30 |
| 44 |
0.48 ms |
SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4718 AND `id_language` = 1 AND `metaname` = 'availability_next_date' ORDER BY `id` DESC LIMIT 0 , 30 |
