| # | Time | Query |
|---|
| 1 |
1.81 ms |
SELECT url, namespace, method, content_redirection FROM `redirect` WHERE status = 1 |
| 2 |
6.78 ms |
INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,... |
| 3 |
0.59 ms |
SELECT * FROM `languages` WHERE TRUE AND `short` = 'en' |
| 4 |
0.63 ms |
SELECT * FROM `languages` WHERE TRUE AND `name` = 'English' |
| 5 |
171.16 ms |
SELECT * FROM `product_meta` WHERE TRUE AND `id_language` = 1 AND `metaname` = 'redirect_from_id' AND `metavalue` = '4788' ORDER BY `id` DESC LIMIT 0 , 30 |
| 6 |
0.67 ms |
SELECT * FROM `type` WHERE TRUE AND `group` = 'products_product_type' AND `name` = 'activity' ORDER BY `id` DESC LIMIT 0 , 30 |
| 7 |
0.43 ms |
SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4788 ORDER BY `id_language` DESC LIMIT 0 , 30 |
| 8 |
0.23 ms |
SELECT * FROM `languages` WHERE TRUE AND `id` = 1 |
| 9 |
0.23 ms |
SELECT * FROM `type` WHERE TRUE AND `id` = 4 ORDER BY `id` DESC LIMIT 0 , 30 |
| 10 |
0.38 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 |
| 11 |
0.32 ms |
SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4788 AND p.`status` = '23' ORDER BY `id` DESC |
| 12 |
0.21 ms |
SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC |
| 13 |
0.32 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 |
| 14 |
0.63 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... |
| 15 |
0.42 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` = 4788 ORDER BY `rating_overall` desc LIMIT 20 , 30 |
| 16 |
0.26 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 |
| 17 |
0.35 ms |
SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4788 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 1000 |
| 18 |
0.45 ms |
SELECT * FROM `product_system_meta` WHERE TRUE AND `id_product` = 4788 AND `metaname` = 'bookingextranote' ORDER BY `id` DESC LIMIT 0 , 30 |
| 19 |
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` = 4788 ORDER BY s.`id_language` ASC |
| 20 |
0.27 ms |
SELECT * FROM `type` WHERE TRUE AND `id` = 2 ORDER BY `id` DESC LIMIT 0 , 30 |
| 21 |
0.4 ms |
SELECT * FROM `product_system` WHERE TRUE AND `id_product_dotravel` = 4788 ORDER BY `id` DESC |
| 22 |
0.36 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.32 ms |
SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4788 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30 |
| 24 |
0.27 ms |
SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4788 ORDER BY `show_order` asc LIMIT 0 , 30 |
| 25 |
0.26 ms |
SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4788 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30 |
| 26 |
0.27 ms |
SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4788 ORDER BY `id` DESC LIMIT 0 , 30 |
| 27 |
0.27 ms |
SELECT * FROM `product_prices` WHERE TRUE AND `id_subproduct` = 3814 ORDER BY `id` DESC LIMIT 0 , 30 |
| 28 |
0.24 ms |
SELECT * FROM `age_group` WHERE TRUE ORDER BY `id` DESC LIMIT 0 , 30 |
| 29 |
0.21 ms |
SELECT * FROM `product_bookingfees` WHERE TRUE ORDER BY `id` DESC LIMIT 0 , 30 |
| 30 |
0.32 ms |
SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'group' ORDER BY `id` DESC LIMIT 0 , 30 |
| 31 |
0.29 ms |
SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4788 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30 |
| 32 |
0.22 ms |
SELECT * FROM `product_advantage` WHERE TRUE AND `id_product` = 4788 ORDER BY `id` DESC LIMIT 0 , 30 |
| 33 |
0.33 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 ='4788' |
| 34 |
0.28 ms |
SELECT * FROM `favorites` WHERE TRUE AND `id_product` = 4788 ORDER BY `id` DESC LIMIT 0 , 30 |
| 35 |
0.34 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.42 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` = 4788 AND cm.`id_language` = 1... |
| 37 |
0.32 ms |
SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4788 ORDER BY `show_order` ASC LIMIT 0 , 30 |
| 38 |
1.33 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 =... |
| 39 |
0.42 ms |
SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 28 ORDER BY `id` DESC LIMIT 0 , 30 |
| 40 |
0.39 ms |
SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 16 ORDER BY `id` DESC LIMIT 0 , 30 |
| 41 |
0.51 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 =... |
| 42 |
0.54 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` = 4788 AND p.`status` = 23 AND s.`status` = 10 ORDER BY `id` DESC LIMIT 0 , 3 |
| 43 |
15.57 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 ( 4788 ) AND st.name = 'active' AND st.group = 'suppliers_status' AND p.id IN ( SELECT id_product FROM `product_destination` WHERE id_destination IN... |
| 44 |
0.69 ms |
SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4766 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30 |
| 45 |
0.5 ms |
SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4766 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30 |
| 46 |
0.42 ms |
SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4766 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30 |
| 47 |
0.55 ms |
SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4766 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30 |
| 48 |
0.37 ms |
SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4766 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30 |
| 49 |
0.29 ms |
SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4766 ORDER BY `id` DESC LIMIT 0 , 30 |
| 50 |
0.37 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` = 4766 ORDER BY s.`id_language` ASC |
| 51 |
0.9 ms |
SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4766 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30 |
| 52 |
0.63 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... |
| 53 |
0.54 ms |
SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4778 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30 |
| 54 |
0.46 ms |
SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4778 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30 |
| 55 |
0.41 ms |
SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4778 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30 |
| 56 |
0.37 ms |
SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4778 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30 |
| 57 |
0.3 ms |
SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4778 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30 |
| 58 |
0.41 ms |
SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4778 ORDER BY `id` DESC LIMIT 0 , 30 |
| 59 |
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` = 4778 ORDER BY s.`id_language` ASC |
| 60 |
0.87 ms |
SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4778 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30 |
| 61 |
0.6 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... |
| 62 |
0.76 ms |
SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4761 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30 |
| 63 |
0.55 ms |
SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4761 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30 |
| 64 |
0.51 ms |
SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4761 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30 |
| 65 |
0.43 ms |
SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4761 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30 |
| 66 |
0.47 ms |
SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4761 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30 |
| 67 |
0.39 ms |
SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4761 ORDER BY `id` DESC LIMIT 0 , 30 |
| 68 |
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` = 4761 ORDER BY s.`id_language` ASC |
| 69 |
1.03 ms |
SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4761 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30 |
| 70 |
0.74 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... |
| 71 |
0.43 ms |
SELECT * FROM `type` WHERE TRUE AND `group` = 'subproduct_blockeddates_block_type' ORDER BY `id` DESC LIMIT 0 , 30 |
| 72 |
0.37 ms |
SELECT * FROM `subproduct_blockeddates` WHERE TRUE AND `id_subproduct` = 3814 ORDER BY `date` ASC LIMIT 0 , 30 |
| 73 |
0.49 ms |
SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4788 AND `id_language` = 1 AND `metaname` = 'availability_next_date' ORDER BY `id` DESC LIMIT 0 , 30 |
| 74 |
0.52 ms |
SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4788 AND `id_language` = 1 AND `metaname` = 'timezone' ORDER BY `id` DESC LIMIT 0 , 30 |
| 75 |
1079.31 ms |
SELECT * FROM `customer_productlog` WHERE TRUE |
| 76 |
481.03 ms |
INSERT INTO `customer_productlog` ( `id` , `content` ) VALUES( NULL , '{\"id_product\":\"4788\",\"id_user\":\"NULL\",\"dateVisited\":1779118041}' ) |
| 77 |
2.37 ms |
SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC |
| 78 |
0.63 ms |
SELECT * FROM `supplier_meta` WHERE TRUE AND `id_supplier` = 36 ORDER BY `id` DESC LIMIT 0 , 1000 |
