DB
13 queries
|
25.32 ms
| # | Time | Query |
|---|---|---|
| 1 | 2.34 ms | SELECT url, namespace, method, content_redirection FROM `redirect` WHERE status = 1 |
| 2 | 7.71 ms | INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,... |
| 3 | 2 ms | SELECT * FROM `languages` WHERE TRUE AND `short` = 'en' |
| 4 | 1.34 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.89 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` = 127 AND t.`status` = '34' AND m.`id_language` = 1 |
| 6 | 2.44 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.57 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` = 'Rovaniemi ' LIMIT 0 , 30 |
| 8 | 0.59 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 =... |
| 9 | 0.47 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 =... |
| 10 | 2.08 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 ? |
| 11 | 0.8 ms | SELECT id_product, metaname, metavalue FROM `product_meta` WHERE id_product IN (?) AND metaname IN (?) AND id_language = ? |
| 12 | 3.41 ms | SELECT id_product, metaname, metavalue FROM `product_meta` WHERE id_product IN (?) AND metaname IN (?) AND id_language = ? |
| 13 | 0.69 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 |