test
| # | Time | Query |
|---|---|---|
| 1 | 1.68 ms | SELECT url, namespace, method, content_redirection FROM `redirect` WHERE status = 1 |
| 2 | 3.68 ms | INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,... |
| 3 | 0.45 ms | SELECT * FROM `languages` WHERE TRUE AND `short` = 'en' |
| 4 | 0.75 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.63 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` = 131 AND t.`status` = '34' AND m.`id_language` = 1 |
| 6 | 0.75 ms | SELECT d.*, m.id_language, m.name, m.description, m.summary, m.seo_title, m.seo_description, m.seo_keywords, m.seo_url, m.img_alt, (select count(*) from product_destination where id_destination = d.id) + (select count(*) from product_destination where id_destination = d.id) as experiencies FROM... |
| 7 | 0.29 ms | SELECT * FROM `languages` WHERE TRUE AND `name` = 'English' |
| 8 | 0.27 ms | SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 131 ORDER BY `id` DESC LIMIT 0 , 30 |
| 9 | 0.4 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 | 0.22 ms | SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 105 ORDER BY `id` DESC LIMIT 0 , 30 |
| 11 | 3.76 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... |
| 12 | 0.46 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 = 131 ORDER BY a.title ASC |