Nunc semper urna a interdum lobortis. Etiam efficitur lobortis urna malesuada congue. Pellentesque rhoncus mollis neque at sodales. Proin sagittis id est quis aliquam. Donec volutpat ligula ac diam lobortis, nec accumsan urna imperdiet. Duis nunc odio, semper sed turpis nec, pharetra ultricies mauris. Aliquam erat volutpat. Phasellus pretium, erat nec efficitur pharetra, enim erat lobortis eros, vitae fermentum dui arcu eget lorem. Morbi accumsan sed felis eu scelerisque. Nam eu purus enim. Suspendisse elementum condimentum tincidunt. Aenean et sapien a dui porta feugiat. Ut ac dui turpis. Orci varius natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Cras eu erat nec neque elementum vehicula vitae et lorem. Integer ipsum nulla, placerat vitae elit a, iaculis commodo libero.
No reviews yet
| # | Time | Query |
|---|---|---|
| 1 | 1.39 ms | SELECT url, namespace, method, content_redirection FROM `redirect` WHERE status = 1 |
| 2 | 3.78 ms | INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,... |
| 3 | 0.5 ms | SELECT * FROM `languages` WHERE TRUE AND `short` = 'en' |
| 4 | 141.55 ms | SELECT * FROM `product_meta` WHERE TRUE AND `id_language` = 1 AND `metaname` = 'redirect_from_id' AND `metavalue` = '4743' ORDER BY `id` DESC LIMIT 0 , 30 |
| 5 | 0.51 ms | SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4743 ORDER BY `id` DESC |
| 6 | 0.4 ms | SELECT * FROM `type` WHERE TRUE AND `id` = 2 ORDER BY `id` DESC LIMIT 0 , 30 |
| 7 | 0.33 ms | SELECT * FROM `type` WHERE TRUE AND `group` = 'products_product_type' AND `name` = 'activity' ORDER BY `id` DESC LIMIT 0 , 30 |
| 8 | 0.38 ms | SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4743 ORDER BY `id_language` DESC LIMIT 0 , 30 |
| 9 | 0.22 ms | SELECT * FROM `languages` WHERE TRUE AND `id` = 1 |
| 10 | 0.21 ms | SELECT * FROM `type` WHERE TRUE AND `id` = 4 ORDER BY `id` DESC LIMIT 0 , 30 |
| 11 | 0.46 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.26 ms | SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4743 AND p.`status` = '23' ORDER BY `id` DESC |
| 13 | 0.22 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.38 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.41 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` = 4743 ORDER BY `rating_overall` desc LIMIT 20 , 30 |
| 17 | 0.24 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.44 ms | SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4743 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 1000 |
| 19 | 0.55 ms | SELECT * FROM `product_system_meta` WHERE TRUE AND `id_product` = 4743 AND `metaname` = 'bookingextranote' ORDER BY `id` DESC LIMIT 0 , 30 |
| 20 | 0.43 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` = 4743 ORDER BY s.`id_language` ASC |
| 21 | 0.4 ms | SELECT * FROM `product_system` WHERE TRUE AND `id_product_dotravel` = 4743 ORDER BY `id` DESC |
| 22 | 0.37 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.34 ms | SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4743 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30 |
| 24 | 0.34 ms | SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4743 ORDER BY `show_order` asc LIMIT 0 , 30 |
| 25 | 0.34 ms | SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4743 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30 |
| 26 | 0.32 ms | SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4743 ORDER BY `id` DESC LIMIT 0 , 30 |
| 27 | 0.28 ms | SELECT * FROM `product_prices` WHERE TRUE AND `id_subproduct` = 3769 ORDER BY `id` DESC LIMIT 0 , 30 |
| 28 | 0.24 ms | SELECT * FROM `age_group` WHERE TRUE AND `id` = 1 ORDER BY `id` DESC LIMIT 0 , 30 |
| 29 | 0.29 ms | SELECT * FROM `product_bookingfees` WHERE TRUE AND `id_productprice` = 10048 ORDER BY `id` DESC LIMIT 0 , 30 |
| 30 | 0.3 ms | SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'group' ORDER BY `id` DESC LIMIT 0 , 30 |
| 31 | 0.42 ms | SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4743 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30 |
| 32 | 0.28 ms | SELECT * FROM `product_advantage` WHERE TRUE AND `id_product` = 4743 ORDER BY `id` DESC LIMIT 0 , 30 |
| 33 | 0.35 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 ='4743' |
| 34 | 0.3 ms | SELECT * FROM `favorites` WHERE TRUE AND `id_product` = 4743 ORDER BY `id` DESC LIMIT 0 , 30 |
| 35 | 0.37 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 |
| 36 | 0.4 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` = 4743 AND cm.`id_language` = 1... |
| 37 | 0.26 ms | SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4743 ORDER BY `show_order` ASC LIMIT 0 , 30 |
| 38 | 0.23 ms | SELECT * FROM `languages` WHERE TRUE AND `name` = 'English' |
| 39 | 1.13 ms | SELECT d.*, d.cdn_image_uuid, d.cdn_variants, d.cdn_processing_status, d.use_cdn, m.id_language, m.name, m.description, m.summary, m.seo_title, m.seo_description, m.seo_keywords, m.seo_url, m.img_alt, m.faqs, m.index_content FROM `destinations` AS d INNER JOIN `destination_meta` AS m on d.id =... |
| 40 | 0.36 ms | SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 7 ORDER BY `id` DESC LIMIT 0 , 30 |
| 41 | 0.46 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.31 ms | SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 3 ORDER BY `id` DESC LIMIT 0 , 30 |
| 43 | 0.41 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.25 ms | SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 1 ORDER BY `id` DESC LIMIT 0 , 30 |
| 45 | 0.5 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` = 4743 AND p.`status` = 23 AND s.`status` = 10 ORDER BY `id` DESC LIMIT 0 , 3 |
| 46 | 17.16 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 ( 4743 ) 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.8 ms | SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4574 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30 |
| 48 | 0.63 ms | SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4574 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30 |
| 49 | 0.5 ms | SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4574 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30 |
| 50 | 0.55 ms | SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4574 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30 |
| 51 | 0.39 ms | SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4574 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30 |
| 52 | 0.27 ms | SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4574 ORDER BY `id` DESC LIMIT 0 , 30 |
| 53 | 0.36 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` = 4574 ORDER BY s.`id_language` ASC |
| 54 | 0.77 ms | SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4574 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30 |
| 55 | 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, AVG(rating_overall) as rating_overall_avg, COUNT(*) as review_count FROM `reviews` WHERE status IN... |
| 56 | 0.59 ms | SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 2673 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30 |
| 57 | 0.56 ms | SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 2673 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30 |
| 58 | 0.6 ms | SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 2673 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30 |
| 59 | 0.57 ms | SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 2673 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30 |
| 60 | 0.34 ms | SELECT * FROM `seo` WHERE TRUE AND `id_product` = 2673 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30 |
| 61 | 0.31 ms | SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 2673 ORDER BY `id` DESC LIMIT 0 , 30 |
| 62 | 0.47 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` = 2673 ORDER BY s.`id_language` ASC |
| 63 | 0.86 ms | SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 2673 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30 |
| 64 | 0.89 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.64 ms | SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4571 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30 |
| 66 | 0.63 ms | SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4571 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30 |
| 67 | 0.45 ms | SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4571 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30 |
| 68 | 0.42 ms | SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4571 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30 |
| 69 | 0.33 ms | SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4571 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30 |
| 70 | 0.31 ms | SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4571 ORDER BY `id` DESC LIMIT 0 , 30 |
| 71 | 0.41 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` = 4571 ORDER BY s.`id_language` ASC |
| 72 | 0.78 ms | SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4571 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30 |
| 73 | 0.57 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.81 ms | SELECT id_product, metavalue FROM `product_meta` WHERE id_product IN (?,?,?) AND metaname = ? AND id_language = ? |
| 75 | 0.42 ms | SELECT * FROM `type` WHERE TRUE AND `group` = 'subproduct_blockeddates_block_type' ORDER BY `id` DESC LIMIT 0 , 30 |
| 76 | 0.68 ms | SELECT * FROM `subproduct_blockeddates` WHERE TRUE AND `id_subproduct` = 3769 ORDER BY `date` ASC LIMIT 0 , 30 |
| 77 | 0.72 ms | SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4743 AND `id_language` = 1 AND `metaname` = 'availability_next_date' ORDER BY `id` DESC LIMIT 0 , 30 |
| 78 | 995.09 ms | SELECT * FROM `customer_productlog` WHERE TRUE |
| 79 | 3.11 ms | INSERT INTO `customer_productlog` ( `id` , `content` ) VALUES( NULL , '{\"id_product\":\"4743\",\"id_user\":\"NULL\",\"dateVisited\":1785187430}' ) |
| 80 | 0.65 ms | SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC |
| 81 | 0.84 ms | SELECT * FROM `supplier_meta` WHERE TRUE AND `id_supplier` = 36 ORDER BY `id` DESC LIMIT 0 , 1000 |