West region of the USA offers all the crazy things from glitzy cities, tasty food, beautiful drives to stunning national parks. While the cities like Seattle, Los Angeles and Las Vegas are famous for glamour and fun, spots like Redwood National Park, Grand Canyon, Death Valley and Lake Tahoe will leave you mesmerised with its magical environment.
| # | Time | Query |
|---|---|---|
| 1 | 1.55 ms | SELECT url, namespace, method, content_redirection FROM `redirect` WHERE status = 1 |
| 2 | 3.91 ms | INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,... |
| 3 | 0.52 ms | SELECT * FROM `languages` WHERE TRUE AND `short` = 'en' |
| 4 | 0.74 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.61 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` = 84 AND t.`status` = '34' AND m.`id_language` = 1 |
| 6 | 0.79 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.59 ms | SELECT pd.id_destination, COUNT(DISTINCT pd.id_product) AS cnt FROM `product_destination` pd INNER JOIN products p ON p.id = pd.id_product INNER JOIN product_meta pm ON pm.id_product = p.id AND pm.metaname = 'availability_next_date' AND pm.metavalue IS NOT NULL AND pm.metavalue <> '' AND... |
| 8 | 0.25 ms | SELECT * FROM `languages` WHERE TRUE AND `name` = 'English' |
| 9 | 0.22 ms | SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 84 ORDER BY `id` DESC LIMIT 0 , 30 |
| 10 | 0.35 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.2 ms | SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 82 ORDER BY `id` DESC LIMIT 0 , 30 |
| 12 | 4.01 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... |
| 13 | 0.45 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 = 84 ORDER BY a.title ASC |