| # | Time | Query |
|---|
| 1 |
1.35 ms |
SELECT url, namespace, method, content_redirection FROM `redirect` WHERE status = 1 |
| 2 |
3.64 ms |
INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,... |
| 3 |
0.28 ms |
SELECT * FROM `languages` WHERE TRUE AND `short` = 'en' |
| 4 |
143.29 ms |
SELECT * FROM `product_meta` WHERE TRUE AND `id_language` = 1 AND `metaname` = 'redirect_from_id' AND `metavalue` = '3702' ORDER BY `id` DESC LIMIT 0 , 30 |
| 5 |
0.27 ms |
SELECT * FROM `products` p WHERE TRUE AND p.`id` = 3702 ORDER BY `id` DESC |
| 6 |
0.19 ms |
SELECT * FROM `type` WHERE TRUE AND `id` = 2 ORDER BY `id` DESC LIMIT 0 , 30 |
| 7 |
0.23 ms |
SELECT * FROM `type` WHERE TRUE AND `group` = 'products_product_type' AND `name` = 'activity' ORDER BY `id` DESC LIMIT 0 , 30 |
| 8 |
0.22 ms |
SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3702 ORDER BY `id_language` DESC LIMIT 0 , 30 |
| 9 |
0.15 ms |
SELECT * FROM `languages` WHERE TRUE AND `id` = 1 |
| 10 |
0.13 ms |
SELECT * FROM `type` WHERE TRUE AND `id` = 4 ORDER BY `id` DESC LIMIT 0 , 30 |
| 11 |
0.24 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 |
| 12 |
0.19 ms |
SELECT * FROM `products` p WHERE TRUE AND p.`id` = 3702 AND p.`status` = '23' ORDER BY `id` DESC |
| 13 |
0.14 ms |
SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC |
| 14 |
0.23 ms |
SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `id` = '10' ORDER BY `id` DESC LIMIT 0 , 30 |
| 15 |
0.29 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, AVG(rating_overall) as rating_overall_avg, COUNT(*) as review_count FROM `reviews` WHERE status IN... |
| 16 |
0.27 ms |
SELECT * FROM `reviews` WHERE status in (select id from status s where s.name = 'active' and s.group = 'review_status') and title not like '' AND `id_product` = 3702 ORDER BY `rating_overall` desc LIMIT 20 , 30 |
| 17 |
0.19 ms |
SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `id` = '9' ORDER BY `id` DESC LIMIT 0 , 30 |
| 18 |
0.38 ms |
SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3702 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 1000 |
| 19 |
0.32 ms |
SELECT * FROM `product_system_meta` WHERE TRUE AND `id_product` = 3702 AND `metaname` = 'bookingextranote' ORDER BY `id` DESC LIMIT 0 , 30 |
| 20 |
0.34 ms |
SELECT pr.price as min FROM `product_prices` as pr INNER JOIN `sub_product` AS s ON s.id = pr.id_subproduct INNER JOIN `age_group` AS a ON a.id = pr.id_agegroup -- WHERE a.show_order = 1 AND s.`id_product` = 3702 ORDER BY s.`id_language` ASC |
| 21 |
0.24 ms |
SELECT * FROM `product_system` WHERE TRUE AND `id_product_dotravel` = 3702 ORDER BY `id` DESC |
| 22 |
0.35 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 |
| 23 |
0.38 ms |
SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3702 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30 |
| 24 |
0.3 ms |
SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 3702 ORDER BY `show_order` asc LIMIT 0 , 30 |
| 25 |
0.29 ms |
SELECT * FROM `seo` WHERE TRUE AND `id_product` = 3702 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30 |
| 26 |
0.22 ms |
SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3702 ORDER BY `id` DESC LIMIT 0 , 30 |
| 27 |
0.21 ms |
SELECT * FROM `product_prices` WHERE TRUE AND `id_subproduct` = 2360 ORDER BY `id` DESC LIMIT 0 , 30 |
| 28 |
0.16 ms |
SELECT * FROM `age_group` WHERE TRUE AND `id` = 1 ORDER BY `id` DESC LIMIT 0 , 30 |
| 29 |
0.17 ms |
SELECT * FROM `product_bookingfees` WHERE TRUE AND `id_productprice` = 6684 ORDER BY `id` DESC LIMIT 0 , 30 |
| 30 |
0.23 ms |
SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'group' ORDER BY `id` DESC LIMIT 0 , 30 |
| 31 |
0.24 ms |
SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3702 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30 |
| 32 |
0.24 ms |
SELECT * FROM `product_advantage` WHERE TRUE AND `id_product` = 3702 ORDER BY `id` DESC LIMIT 0 , 30 |
| 33 |
0.25 ms |
SELECT a.*, m.id_language, m.name, m.description FROM `advantages` AS a INNER JOIN `advantage_meta` AS m on a.id=m.id_advantage WHERE TRUE AND a.`id` = 7 AND m.`id_language` = 1 ORDER BY `id` desc LIMIT 0 , 30 |
| 34 |
0.24 ms |
SELECT short_description, image_name,image_path, id_language, name FROM `label_products` LEFT JOIN labels lb on lb.id = id_label LEFT JOIN labels_meta lm on lm.id_label = label_products.id_label where id_product ='3702' |
| 35 |
0.19 ms |
SELECT * FROM `favorites` WHERE TRUE AND `id_product` = 3702 ORDER BY `id` DESC LIMIT 0 , 30 |
| 36 |
0.25 ms |
SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'disabled' AND `group` = 'favorites_status' ORDER BY `id` DESC LIMIT 0 , 30 |
| 37 |
0.35 ms |
SELECT pc.id_category as id, cm.name as name, cm.seo_url as seo_url ,(SELECT img_name FROM categories where id = pc.id_category) as img FROM `product_category` AS pc INNER JOIN `category_meta` AS cm ON pc.id_category = cm.id_category WHERE TRUE AND pc.`id_product` = 3702 AND cm.`id_language` = 1... |
| 38 |
0.27 ms |
SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 3702 ORDER BY `show_order` ASC LIMIT 0 , 30 |
| 39 |
0.16 ms |
SELECT * FROM `languages` WHERE TRUE AND `name` = 'English' |
| 40 |
0.19 ms |
SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 75 ORDER BY `id` DESC LIMIT 0 , 30 |
| 41 |
0.26 ms |
SELECT destinations.id, destination_meta.name,seo_url FROM `destinations` join destination_meta on destination_meta.id_destination = destinations.id join destination_parent on destination_parent.id_parent = destinations.id where true AND destinations.status = 24 AND destination_meta.id_language =... |
| 42 |
0.16 ms |
SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 71 ORDER BY `id` DESC LIMIT 0 , 30 |
| 43 |
0.25 ms |
SELECT destinations.id, destination_meta.name,seo_url FROM `destinations` join destination_meta on destination_meta.id_destination = destinations.id join destination_parent on destination_parent.id_parent = destinations.id where true AND destinations.status = 24 AND destination_meta.id_language =... |
| 44 |
0.16 ms |
SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 70 ORDER BY `id` DESC LIMIT 0 , 30 |
| 45 |
0.31 ms |
SELECT p.* FROM `related_product` rp inner join products p on rp.id_related = p.id inner join suppliers s on p.id_supplier = s.id WHERE TRUE AND `id_product` = 3702 AND p.`status` = 23 AND s.`status` = 10 ORDER BY `id` DESC LIMIT 0 , 3 |
| 46 |
14.83 ms |
SELECT p.* FROM `products` p JOIN `suppliers` s ON p.id_supplier = s.id JOIN `status` st ON s.status = st.id WHERE p.`status` = 23 AND p.id not in ( 3702 ) AND st.name = 'active' AND st.group = 'suppliers_status' AND p.id IN ( SELECT id_product FROM `product_destination` WHERE id_destination IN... |
| 47 |
0.45 ms |
SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3737 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30 |
| 48 |
0.38 ms |
SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3737 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30 |
| 49 |
0.34 ms |
SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3737 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30 |
| 50 |
0.49 ms |
SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3737 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30 |
| 51 |
0.29 ms |
SELECT * FROM `seo` WHERE TRUE AND `id_product` = 3737 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30 |
| 52 |
0.28 ms |
SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 3737 ORDER BY `id` DESC LIMIT 0 , 30 |
| 53 |
0.46 ms |
SELECT pr.price as min FROM `product_prices` as pr INNER JOIN `sub_product` AS s ON s.id = pr.id_subproduct INNER JOIN `age_group` AS a ON a.id = pr.id_agegroup -- WHERE a.show_order = 1 AND s.`id_product` = 3737 ORDER BY s.`id_language` ASC |
| 54 |
0.44 ms |
SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3737 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30 |
| 55 |
0.4 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, AVG(rating_overall) as rating_overall_avg, COUNT(*) as review_count FROM `reviews` WHERE status IN... |
| 56 |
0.41 ms |
SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3701 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30 |
| 57 |
0.37 ms |
SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3701 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30 |
| 58 |
0.39 ms |
SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3701 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30 |
| 59 |
0.39 ms |
SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3701 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30 |
| 60 |
0.33 ms |
SELECT * FROM `seo` WHERE TRUE AND `id_product` = 3701 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30 |
| 61 |
0.25 ms |
SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 3701 ORDER BY `id` DESC LIMIT 0 , 30 |
| 62 |
0.35 ms |
SELECT pr.price as min FROM `product_prices` as pr INNER JOIN `sub_product` AS s ON s.id = pr.id_subproduct INNER JOIN `age_group` AS a ON a.id = pr.id_agegroup -- WHERE a.show_order = 1 AND s.`id_product` = 3701 ORDER BY s.`id_language` ASC |
| 63 |
0.39 ms |
SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3701 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30 |
| 64 |
0.41 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, AVG(rating_overall) as rating_overall_avg, COUNT(*) as review_count FROM `reviews` WHERE status IN... |
| 65 |
0.57 ms |
SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3699 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30 |
| 66 |
0.53 ms |
SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3699 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30 |
| 67 |
0.49 ms |
SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3699 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30 |
| 68 |
0.56 ms |
SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3699 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30 |
| 69 |
0.3 ms |
SELECT * FROM `seo` WHERE TRUE AND `id_product` = 3699 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30 |
| 70 |
0.25 ms |
SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 3699 ORDER BY `id` DESC LIMIT 0 , 30 |
| 71 |
0.33 ms |
SELECT pr.price as min FROM `product_prices` as pr INNER JOIN `sub_product` AS s ON s.id = pr.id_subproduct INNER JOIN `age_group` AS a ON a.id = pr.id_agegroup -- WHERE a.show_order = 1 AND s.`id_product` = 3699 ORDER BY s.`id_language` ASC |
| 72 |
0.4 ms |
SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3699 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30 |
| 73 |
0.4 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, AVG(rating_overall) as rating_overall_avg, COUNT(*) as review_count FROM `reviews` WHERE status IN... |
| 74 |
0.64 ms |
SELECT id_product, metavalue FROM `product_meta` WHERE id_product IN (?,?,?) AND metaname = ? AND id_language = ? |
| 75 |
0.27 ms |
SELECT * FROM `type` WHERE TRUE AND `group` = 'subproduct_blockeddates_block_type' ORDER BY `id` DESC LIMIT 0 , 30 |
| 76 |
0.26 ms |
SELECT * FROM `subproduct_blockeddates` WHERE TRUE AND `id_subproduct` = 2360 ORDER BY `date` ASC LIMIT 0 , 30 |
| 77 |
0.51 ms |
SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3702 AND `id_language` = 1 AND `metaname` = 'availability_next_date' ORDER BY `id` DESC LIMIT 0 , 30 |
| 78 |
0.22 ms |
SELECT * FROM `customer_productlog` WHERE TRUE AND `id` = 711387 |
| 79 |
5.66 ms |
UPDATE `customer_productlog` SET `id` = 711387 , `content` =... |
| 80 |
0.34 ms |
SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC |
| 81 |
0.43 ms |
SELECT * FROM `supplier_meta` WHERE TRUE AND `id_supplier` = 36 ORDER BY `id` DESC LIMIT 0 , 1000 |
Duration:
8h-9h
Group:
Max 50 people
