| # | Time | Query |
|---|
| 1 |
2.75 ms |
SELECT url, namespace, method, content_redirection FROM `redirect` WHERE status = 1 |
| 2 |
32.67 ms |
INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,... |
| 3 |
0.55 ms |
SELECT * FROM `languages` WHERE TRUE AND `short` = 'en' |
| 4 |
0.8 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 =... |
| 5 |
0.79 ms |
SELECT t.*, m.id_language, m.title, m.description, m.img_alt, m.blog_link, m.category_link FROM `thingstodo` AS t INNER JOIN `thingtodo_meta` AS m ON t.id = m.id_thingtodo WHERE TRUE AND t.`id_destination` = 7 AND t.`status` = '34' AND m.`id_language` = 1 |
| 6 |
1.84 ms |
SELECT destinations.*,destination_meta.* FROM `destination_parent` join destinations on destinations.id = destination_parent.id_child join destination_meta on destination_meta.id_destination = destinations.id where true and (id_parent = (SELECT id_parent FROM `destination_parent` where `id_child`... |
| 7 |
0.61 ms |
SELECT c.*, m.id_language, m.name, m.description, m.seo_title, m.seo_description, m.seo_keywords, m.seo_url, m.img_alt FROM `categories` AS c INNER JOIN `category_meta` AS m on c.id = m.id_category WHERE TRUE AND c.`status` = '32' AND m.`id_language` = 1 AND m.`name` = 'Barcelona' LIMIT 0 , 30 |
| 8 |
0.46 ms |
SELECT * FROM `languages` WHERE TRUE AND `name` = 'English' |
| 9 |
0.44 ms |
SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 7 ORDER BY `id` DESC LIMIT 0 , 30 |
| 10 |
0.49 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 =... |
| 11 |
0.34 ms |
SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 3 ORDER BY `id` DESC LIMIT 0 , 30 |
| 12 |
0.56 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 =... |
| 13 |
1.47 ms |
SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 1 ORDER BY `id` DESC LIMIT 0 , 30 |
| 14 |
48.81 ms |
SELECT p.id FROM `products` p INNER JOIN `product_meta` pm ON pm.id_product = p.id AND pm.metaname = 'featured' AND pm.metavalue = '1' WHERE p.city = ? LIMIT ? |
| 15 |
4.61 ms |
SELECT DISTINCT pd.id_product FROM product_destination pd INNER JOIN products p ON p.id = pd.id_product INNER JOIN suppliers s ON s.id = p.id_supplier WHERE p.status = ? AND s.status = ? AND ( pd.id_destination = ? OR pd.id_destination IN ( SELECT id_child FROM destination_parent WHERE id_parent... |
| 16 |
1.52 ms |
SELECT * FROM `product_system` WHERE id_product_dotravel IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) |
| 17 |
8.84 ms |
SELECT id_product, metavalue FROM `product_meta` WHERE id_product IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND metaname = ? AND id_language = ? |
| 18 |
0.82 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 |
| 19 |
1.68 ms |
SELECT id_product, SUM(rating_overall) / COUNT(*) AS rating_overall, COUNT(*) AS review_count FROM `reviews` WHERE id_product IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND status = ?... |
| 20 |
0.49 ms |
SELECT * FROM `products` WHERE `id` IN (?,?,?,?,?,?,?,?) |
| 21 |
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 |
| 22 |
0.42 ms |
SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'group' ORDER BY `id` DESC LIMIT 0 , 30 |
| 23 |
0.64 ms |
SELECT id_product, id_language FROM `sub_product` WHERE id_product IN (?,?,?,?,?,?,?,?) AND type = ? ORDER BY id_language ASC |
| 24 |
0.47 ms |
SELECT * FROM `languages` WHERE TRUE AND `id` = 1 |
| 25 |
0.6 ms |
SELECT id_product, seo_url FROM `seo` WHERE id_product IN (?,?,?,?,?,?,?,?) AND id_language = ? |
| 26 |
1.96 ms |
SELECT id_product, metaname, metavalue FROM `product_meta` WHERE id_product IN (?,?,?,?,?,?,?,?) AND metaname IN (?,?,?,?) AND id_language = ? |
| 27 |
1.11 ms |
SELECT pp.* FROM `product_photos` pp INNER JOIN ( SELECT id_product, MIN(show_order) AS min_order FROM `product_photos` WHERE id_product IN (?,?,?,?,?,?,?,?) GROUP BY id_product ) first ON pp.id_product = first.id_product AND pp.show_order = first.min_order WHERE pp.id_product IN (?,?,?,?,?,?,?,?) |
| 28 |
0.69 ms |
SELECT id_product, SUM(rating_overall) / COUNT(*) AS rating_overall, COUNT(*) AS review_count FROM `reviews` WHERE id_product IN (?,?,?,?,?,?,?,?) AND status = ? GROUP BY id_product |
| 29 |
0.81 ms |
SELECT s.id_product, MIN(pr.price) AS min FROM `product_prices` pr INNER JOIN `sub_product` s ON s.id = pr.id_subproduct INNER JOIN `age_group` a ON a.id = pr.id_agegroup WHERE s.id_product IN (?,?,?,?,?,?,?,?) AND pr.price > 0 GROUP BY s.id_product |
| 30 |
0.31 ms |
SELECT * FROM `type` WHERE TRUE AND `id` = 1 ORDER BY `id` DESC LIMIT 0 , 30 |
| 31 |
0.47 ms |
SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `id` = '23' ORDER BY `id` DESC LIMIT 0 , 30 |
| 32 |
0.66 ms |
SELECT * FROM `type` WHERE TRUE AND `id` = 2 ORDER BY `id` DESC LIMIT 0 , 30 |
| 33 |
3.68 ms |
SELECT id_product, metaname, metavalue FROM `product_meta` WHERE id_product IN (?,?,?,?,?,?,?,?) AND metaname IN (?,?) AND id_language = ? |
| 34 |
2.17 ms |
SELECT id_product, metavalue FROM `product_meta` WHERE id_product IN (?,?,?,?,?,?,?,?) AND metaname = ? AND id_language = ? |
| 35 |
5.28 ms |
SELECT s.id_product, MIN(pr.price) AS min FROM `product_prices` pr INNER JOIN `sub_product` s ON s.id = pr.id_subproduct INNER JOIN `age_group` a ON a.id = pr.id_agegroup WHERE s.id_product IN (?,?,?,?,?,?,?,?) AND pr.price > 0 GROUP BY s.id_product |
| 36 |
2.54 ms |
SELECT id_category, COUNT(DISTINCT id_product) AS cnt FROM product_category WHERE id_product IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) GROUP BY id_category |
| 37 |
1.26 ms |
SELECT DISTINCT id_product FROM product_category WHERE id_category IN (?) AND id_product IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) |
| 38 |
0.64 ms |
SELECT * FROM `product_system` WHERE id_product_dotravel IN (?,?,?) |
| 39 |
1.21 ms |
SELECT id_product, metavalue FROM `product_meta` WHERE id_product IN (?,?,?) AND metaname = ? AND id_language = ? |
| 40 |
0.6 ms |
SELECT id_product, SUM(rating_overall) / COUNT(*) AS rating_overall, COUNT(*) AS review_count FROM `reviews` WHERE id_product IN (?,?,?) AND status = ? GROUP BY id_product |
| 41 |
0.51 ms |
SELECT * FROM `products` WHERE `id` IN (?,?,?) |
| 42 |
0.55 ms |
SELECT id_product, id_language FROM `sub_product` WHERE id_product IN (?,?,?) AND type = ? ORDER BY id_language ASC |
| 43 |
0.82 ms |
SELECT id_product, seo_url FROM `seo` WHERE id_product IN (?,?,?) AND id_language = ? |
| 44 |
1.61 ms |
SELECT id_product, metaname, metavalue FROM `product_meta` WHERE id_product IN (?,?,?) AND metaname IN (?,?,?,?) AND id_language = ? |
| 45 |
1.46 ms |
SELECT pp.* FROM `product_photos` pp INNER JOIN ( SELECT id_product, MIN(show_order) AS min_order FROM `product_photos` WHERE id_product IN (?,?,?) GROUP BY id_product ) first ON pp.id_product = first.id_product AND pp.show_order = first.min_order WHERE pp.id_product IN (?,?,?) |
| 46 |
0.6 ms |
SELECT id_product, SUM(rating_overall) / COUNT(*) AS rating_overall, COUNT(*) AS review_count FROM `reviews` WHERE id_product IN (?,?,?) AND status = ? GROUP BY id_product |
| 47 |
0.62 ms |
SELECT s.id_product, MIN(pr.price) AS min FROM `product_prices` pr INNER JOIN `sub_product` s ON s.id = pr.id_subproduct INNER JOIN `age_group` a ON a.id = pr.id_agegroup WHERE s.id_product IN (?,?,?) AND pr.price > 0 GROUP BY s.id_product |
| 48 |
1.84 ms |
SELECT id_product, metaname, metavalue FROM `product_meta` WHERE id_product IN (?,?,?) AND metaname IN (?,?) AND id_language = ? |
| 49 |
1.02 ms |
SELECT id_product, metavalue FROM `product_meta` WHERE id_product IN (?,?,?) AND metaname = ? AND id_language = ? |
| 50 |
1.57 ms |
SELECT s.id_product, MIN(pr.price) AS min FROM `product_prices` pr INNER JOIN `sub_product` s ON s.id = pr.id_subproduct INNER JOIN `age_group` a ON a.id = pr.id_agegroup WHERE s.id_product IN (?,?,?) AND pr.price > 0 GROUP BY s.id_product |
| 51 |
2.18 ms |
SELECT a.id, a.title, a.seo_url, a.description, a.id_adminuser FROM `article_destination` ad INNER JOIN `articles` a ON ad.id_article = a.id WHERE ad.id_destination = 7 ORDER BY a.title ASC |
| 52 |
0.98 ms |
SELECT au.*, s.name as status_name FROM `admin_user` au INNER JOIN status s ON s.id = au.status AND s.group = 'admin_user_status' WHERE TRUE AND au.`id` = 23 ORDER BY au.`id` DESC |
| 53 |
0.66 ms |
SELECT * FROM `article_photos` WHERE TRUE AND `id_article` = 117 ORDER BY `id` DESC LIMIT 0 , 30 |
| 54 |
0.95 ms |
SELECT au.*, s.name as status_name FROM `admin_user` au INNER JOIN status s ON s.id = au.status AND s.group = 'admin_user_status' WHERE TRUE AND au.`id` = 37 ORDER BY au.`id` DESC |
| 55 |
0.65 ms |
SELECT * FROM `article_photos` WHERE TRUE AND `id_article` = 147 ORDER BY `id` DESC LIMIT 0 , 30 |
.jpg)
