Miami is a popular destination that offers something for everyone. Bejewelled with art and trendy nightlife, South USA indeed is a place worth visiting. The high energy of Havana, Bustle of beaches, the amazing coconut groves, the dazzling hotels and historic hideaways of Coral Gables are some of the great things about this city. Representing the American, Yankee and Caribbean cultures, this city never fails to win hearts.
| # | Time | Query |
|---|---|---|
| 1 | 2.05 ms | SELECT url, namespace, method, content_redirection FROM `redirect` WHERE status = 1 |
| 2 | 3.08 ms | INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,... |
| 3 | 0.51 ms | SELECT * FROM `languages` WHERE TRUE AND `short` = 'en' |
| 4 | 1.02 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.77 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` = 91 AND t.`status` = '34' AND m.`id_language` = 1 |
| 6 | 1.5 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.62 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` = 'Miami' LIMIT 0 , 30 |
| 8 | 0.48 ms | SELECT * FROM `languages` WHERE TRUE AND `name` = 'English' |
| 9 | 0.38 ms | SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 91 ORDER BY `id` DESC LIMIT 0 , 30 |
| 10 | 0.5 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` = 85 ORDER BY `id` DESC LIMIT 0 , 30 |
| 12 | 0.46 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 | 0.31 ms | SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 82 ORDER BY `id` DESC LIMIT 0 , 30 |
| 14 | 1.66 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.21 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 | 0.65 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 = 91 ORDER BY a.title ASC |