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 | 5.15 ms | SELECT url, namespace, method, content_redirection FROM `redirect` WHERE status = 1 |
| 2 | 24.82 ms | INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,... |
| 3 | 2.26 ms | SELECT * FROM `languages` WHERE TRUE AND `short` = 'en' |
| 4 | 2.65 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 | 1.31 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 | 3.77 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 | 2.05 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 | 1.23 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 =... |