Next five days
Available 24h today
A specific area in Lagos to make the results more objective
14/06/2026
Lagos is one of the best places in Europe to catch your first wave. It sits between two coastlines with completely diffe...
14/06/2026
Lagos has one of the liveliest nightlife scenes on the Algarve — but it's also more varied than its party reputation sug...
13/06/2026
Lagos is a brilliant base, and some of the western Algarve's best experiences are a short drive away. If you have an ext...
Sign up to receive our offers
|
|
Login via social networks
Sign Up via social networks
No post data.
No querystring data.
| Query | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|
| SELECT PageType.*, PageTypeTranslation.id, PageTypeTranslation.title, PageTypeTranslation.slug, PageContent.*, PageContentTranslation.id, PageContentTranslation.slug, PageContentTranslation.title, PageContentTranslation.seo_title, PageContentTranslation.subtitle, PageContentTranslation.introduction, PageContentTranslation.description, PageContentTranslation.description_complement, PageContentTranslation.seo_meta_description, PageContentTranslation.seo_meta_keywords, Image.id, Image.name, TopImage.id, TopImage.name FROM page_types PageType INNER JOIN page_contents PageContent ON PageContent.page_type_id = PageType.id AND PageContent.publish = 1 AND PageContent.group_of_pages = 0 INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id INNER JOIN languages Language ON Language.id = PageContentTranslation.language_code_id AND Language.code_link = "en" INNER JOIN page_type_translations PageTypeTranslation ON PageTypeTranslation.page_type_id = PageType.id AND PageTypeTranslation.language_code_id = Language.id LEFT JOIN images Image ON Image.id = PageContent.image_id LEFT JOIN images TopImage ON TopImage.id = PageContent.top_image_id WHERE PageType.id = 27 AND PageType.publish = 1 AND PageType.block = 0; | 1 | 1 | 4 | maybe slow |
| SELECT Promotion.id, Promotion.discount, PromotionContent.id, PromotionContent.title FROM promotions Promotion INNER JOIN promotion_contents PromotionContent ON PromotionContent.promotion_id = Promotion.id INNER JOIN languages Language ON Language.id = PromotionContent.language_code_id AND Language.code_link = "en" WHERE Promotion.publish = 1; | 0 | 0 | 1 | maybe slow |
| SELECT PageContentTranslation.id, PageContentTranslation.title FROM page_contents PageContent INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id INNER JOIN languages Language ON Language.id = PageContentTranslation.language_code_id AND Language.code_link = "en" WHERE PageContent.settings_page = 1 | 1 | 1 | 3 | maybe slow |
| SELECT PageType.id, PageTypeTranslation.slug, Language.id, Language.code_link, Language.default_language FROM page_types PageType INNER JOIN page_type_translations PageTypeTranslation ON PageTypeTranslation.page_type_id = PageType.id INNER JOIN languages Language ON Language.id = PageTypeTranslation.language_code_id AND Language.publish = 1 WHERE PageType.id = 27 | 2 | 2 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`created`, `Gallery`.`modified`, `Gallery`.`title`, `Gallery`.`page_content_id`, `Gallery`.`product_type_id`, `Gallery`.`mobile` FROM `discover_discoverlagosdb2023`.`galleries` AS `Gallery` WHERE `Gallery`.`page_content_id` = 34 LIMIT 1 | 0 | 0 | 0 | |
| SELECT PageContent.id, PageContent.page_type_associate, PageContentTranslation.id, PageContentTranslation.title, PageContentTranslation.subtitle, PageContentTranslation.introduction FROM page_contents PageContent INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id INNER JOIN languages Language ON Language.id = PageContentTranslation.language_code_id AND Language.code_link = "en" INNER JOIN page_types PageType ON PageType.id = PageContent.page_type_id AND PageType.publish = 1 AND PageType.block = 0 WHERE PageContent.page_type_id = 30 AND PageContent.publish = 1 AND PageContent.page_type_associate = 27 ORDER BY PageContent.content_order ASC; | 0 | 0 | 4 | maybe slow |
| SELECT PageType.id, PageType.static_page, PageType.booking_system, PageType.associate_promotion, PageType.blog, PageTypeTranslation.slug, PageContent.id, PageContent.created, PageContent.associate_promotion, PageContent.duration_tour, PageContent.price_tour, PageContent.video_mobile_mp4_url, PageContent.video_mp4_url, PageContent.video_mobile_webm_url, PageContent.video_webm_url, PageContentTranslation.id, PageContentTranslation.slug, PageContentTranslation.title, PageContentTranslation.subtitle, PageContentTranslation.introduction, PageContentTranslation.description, PageContent.booking_url, Image.id, Image.name, TopImage.id, TopImage.name, Gallery.id FROM page_types PageType INNER JOIN page_contents PageContent ON PageContent.page_type_id = PageType.id AND PageContent.publish = 1 AND PageContent.group_of_pages = 0 INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id INNER JOIN languages Language ON Language.id = PageContentTranslation.language_code_id AND Language.code_link = "en" INNER JOIN page_type_translations PageTypeTranslation ON PageTypeTranslation.page_type_id = PageType.id AND PageTypeTranslation.language_code_id = Language.id LEFT JOIN images Image ON Image.id = PageContent.image_id LEFT JOIN images TopImage ON TopImage.id = PageContent.top_image_id LEFT JOIN galleries Gallery ON Gallery.page_content_id = PageContent.id WHERE PageType.id = 25 AND PageType.publish = 1 AND PageType.block = 0 ORDER BY PageContent.id DESC; | 20 | 20 | 10 | maybe slow |
| SELECT Promotion.id, Promotion.discount, PromotionContent.id, PromotionContent.title FROM promotions Promotion INNER JOIN promotion_contents PromotionContent ON PromotionContent.promotion_id = Promotion.id INNER JOIN languages Language ON Language.id = PromotionContent.language_code_id AND Language.code_link = "en" WHERE Promotion.publish = 1; | 0 | 0 | 0 | |
| SELECT PageContent.id, PageContentTranslation.title, PageContentTranslation.subtitle, PageContentTranslation.introduction, PageContentTranslation.slug FROM page_contents PageContent INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id INNER JOIN languages Language ON Language.code_link = "en" AND Language.id = PageContentTranslation.language_code_id WHERE PageContent.page_type_id = 53 AND PageContent.publish = 1 ORDER BY PageContent.content_order ASC; | 6 | 6 | 4 | maybe slow |
| SELECT PageContent.id, PageContent.video_mp4_url, PageContent.video_webm_url, PageContent.video_mobile_mp4_url, PageContent.video_mobile_webm_url, PageContentTranslation.title, PageContentTranslation.subtitle, PageContentTranslation.slug, Image.name, TopImage.name, MobileTopImage.name, Business.* FROM page_contents PageContent INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id INNER JOIN languages Language ON Language.code_link = "en" AND Language.id = PageContentTranslation.language_code_id LEFT JOIN images Image ON Image.id = PageContent.image_id LEFT JOIN images TopImage ON TopImage.id = PageContent.top_image_id LEFT JOIN images MobileTopImage ON MobileTopImage.id = PageContent.mobile_top_image_id INNER JOIN ( SELECT PC.id AS TOT_ID, COUNT(*) AS TOT FROM page_contents PC INNER JOIN page_contents C ON C.page_type_associate LIKE CONCAT("%", PC.id, "%") WHERE C.publish = 1 GROUP BY PC.id ) as Business ON Business.TOT_ID = PageContent.id WHERE PageContent.publish = 1 AND PageContent.page_type_associate = 445 ORDER BY PageContent.content_order ASC; | 0 | 0 | 5 | maybe slow |
| SELECT PageContent.id, PageContent.video_mp4_url, PageContent.video_webm_url, PageContent.video_mobile_mp4_url, PageContent.video_mobile_webm_url, PageContentTranslation.title, PageContentTranslation.subtitle, PageContentTranslation.slug, Image.name, TopImage.name, MobileTopImage.name, Business.* FROM page_contents PageContent INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id INNER JOIN languages Language ON Language.code_link = "en" AND Language.id = PageContentTranslation.language_code_id LEFT JOIN images Image ON Image.id = PageContent.image_id LEFT JOIN images TopImage ON TopImage.id = PageContent.top_image_id LEFT JOIN images MobileTopImage ON MobileTopImage.id = PageContent.mobile_top_image_id INNER JOIN ( SELECT PC.id AS TOT_ID, COUNT(*) AS TOT FROM page_contents PC INNER JOIN page_contents C ON C.page_type_associate LIKE CONCAT("%", PC.id, "%") WHERE C.publish = 1 GROUP BY PC.id ) as Business ON Business.TOT_ID = PageContent.id WHERE PageContent.publish = 1 AND PageContent.page_type_associate = 162 ORDER BY PageContent.content_order ASC; | 9 | 9 | 16 | maybe slow |
| SELECT PageContent.id, PageContent.video_mp4_url, PageContent.video_webm_url, PageContent.video_mobile_mp4_url, PageContent.video_mobile_webm_url, PageContentTranslation.title, PageContentTranslation.subtitle, PageContentTranslation.slug, Image.name, TopImage.name, MobileTopImage.name, Business.* FROM page_contents PageContent INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id INNER JOIN languages Language ON Language.code_link = "en" AND Language.id = PageContentTranslation.language_code_id LEFT JOIN images Image ON Image.id = PageContent.image_id LEFT JOIN images TopImage ON TopImage.id = PageContent.top_image_id LEFT JOIN images MobileTopImage ON MobileTopImage.id = PageContent.mobile_top_image_id INNER JOIN ( SELECT PC.id AS TOT_ID, COUNT(*) AS TOT FROM page_contents PC INNER JOIN page_contents C ON C.page_type_associate LIKE CONCAT("%", PC.id, "%") WHERE C.publish = 1 GROUP BY PC.id ) as Business ON Business.TOT_ID = PageContent.id WHERE PageContent.publish = 1 AND PageContent.page_type_associate = 164 ORDER BY PageContent.content_order ASC; | 13 | 13 | 13 | |
| SELECT PageContent.id, PageContent.video_mp4_url, PageContent.video_webm_url, PageContent.video_mobile_mp4_url, PageContent.video_mobile_webm_url, PageContentTranslation.title, PageContentTranslation.subtitle, PageContentTranslation.slug, Image.name, TopImage.name, MobileTopImage.name, Business.* FROM page_contents PageContent INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id INNER JOIN languages Language ON Language.code_link = "en" AND Language.id = PageContentTranslation.language_code_id LEFT JOIN images Image ON Image.id = PageContent.image_id LEFT JOIN images TopImage ON TopImage.id = PageContent.top_image_id LEFT JOIN images MobileTopImage ON MobileTopImage.id = PageContent.mobile_top_image_id INNER JOIN ( SELECT PC.id AS TOT_ID, COUNT(*) AS TOT FROM page_contents PC INNER JOIN page_contents C ON C.page_type_associate LIKE CONCAT("%", PC.id, "%") WHERE C.publish = 1 GROUP BY PC.id ) as Business ON Business.TOT_ID = PageContent.id WHERE PageContent.publish = 1 AND PageContent.page_type_associate = 165 ORDER BY PageContent.content_order ASC; | 6 | 6 | 27 | maybe slow |
| SELECT PageContent.id, PageContent.video_mp4_url, PageContent.video_webm_url, PageContent.video_mobile_mp4_url, PageContent.video_mobile_webm_url, PageContentTranslation.title, PageContentTranslation.subtitle, PageContentTranslation.slug, Image.name, TopImage.name, MobileTopImage.name, Business.* FROM page_contents PageContent INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id INNER JOIN languages Language ON Language.code_link = "en" AND Language.id = PageContentTranslation.language_code_id LEFT JOIN images Image ON Image.id = PageContent.image_id LEFT JOIN images TopImage ON TopImage.id = PageContent.top_image_id LEFT JOIN images MobileTopImage ON MobileTopImage.id = PageContent.mobile_top_image_id INNER JOIN ( SELECT PC.id AS TOT_ID, COUNT(*) AS TOT FROM page_contents PC INNER JOIN page_contents C ON C.page_type_associate LIKE CONCAT("%", PC.id, "%") WHERE C.publish = 1 GROUP BY PC.id ) as Business ON Business.TOT_ID = PageContent.id WHERE PageContent.publish = 1 AND PageContent.page_type_associate = 209 ORDER BY PageContent.content_order ASC; | 7 | 7 | 24 | maybe slow |
| SELECT PageContent.id, PageContent.video_mp4_url, PageContent.video_webm_url, PageContent.video_mobile_mp4_url, PageContent.video_mobile_webm_url, PageContentTranslation.title, PageContentTranslation.subtitle, PageContentTranslation.slug, Image.name, TopImage.name, MobileTopImage.name, Business.* FROM page_contents PageContent INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id INNER JOIN languages Language ON Language.code_link = "en" AND Language.id = PageContentTranslation.language_code_id LEFT JOIN images Image ON Image.id = PageContent.image_id LEFT JOIN images TopImage ON TopImage.id = PageContent.top_image_id LEFT JOIN images MobileTopImage ON MobileTopImage.id = PageContent.mobile_top_image_id INNER JOIN ( SELECT PC.id AS TOT_ID, COUNT(*) AS TOT FROM page_contents PC INNER JOIN page_contents C ON C.page_type_associate LIKE CONCAT("%", PC.id, "%") WHERE C.publish = 1 GROUP BY PC.id ) as Business ON Business.TOT_ID = PageContent.id WHERE PageContent.publish = 1 AND PageContent.page_type_associate = 219 ORDER BY PageContent.content_order ASC; | 2 | 2 | 12 | maybe slow |
| SELECT DISTINCT ShopType.id, ShopType.price, ShopType.promo, ShopType.price_promo, ShopTypeTranslation.title, ShopTypeTranslation.color, ShopTypeTranslation.type, ShopTypeTranslation.slug, ShopTypeTranslation.duration, ShopCategoryTranslation.id, ShopCategoryTranslation.slug, ShopCategoryTranslation.title, ShopProductTranslation.id, ShopProductTranslation.slug, ShopProductTranslation.title, BrandTranslation.title, Image.name FROM shop_types ShopType INNER JOIN shop_type_translations ShopTypeTranslation ON ShopTypeTranslation.product_type_id = ShopType.id INNER JOIN shop_categories ShopCategorie ON ShopCategorie.id = ShopType.category_id AND ShopCategorie.category_type = "booking_agenda" INNER JOIN shop_category_translations ShopCategoryTranslation ON ShopCategoryTranslation.category_id = ShopCategorie.id INNER JOIN shop_products ShopProduct ON ShopProduct.id = ShopType.product_id INNER JOIN shop_product_translations ShopProductTranslation ON ShopProductTranslation.product_id = ShopProduct.id INNER JOIN languages Language ON Language.code_link = "en" AND Language.id = ShopTypeTranslation.language_code_id AND Language.id = ShopCategoryTranslation.language_code_id AND Language.id = ShopProductTranslation.language_code_id LEFT JOIN shop_brands ShopBrand ON ShopBrand.product_type_id = ShopType.id LEFT JOIN page_contents Brand ON Brand.id = ShopBrand.brand_id LEFT JOIN page_content_translations BrandTranslation ON BrandTranslation.page_content_id = Brand.id LEFT OUTER JOIN ( SELECT i.id, i.name, i.item_id, min(i.image_order) as image_order FROM images i GROUP BY i.item_id ) as Image ON Image.item_id = ShopType.id WHERE ShopType.publish = 1 AND ShopType.destaque = 1 ORDER BY rand() LIMIT 4; | 0 | 0 | 3 | maybe slow |
| SELECT PageContent.id, PageContentTranslation.title, PageContentTranslation.slug, PageContentTranslation.subtitle, PageContentTranslation.introduction, Image.name FROM page_contents PageContent INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id INNER JOIN languages Language ON Language.code_link = "en" AND Language.id = PageContentTranslation.language_code_id LEFT JOIN images Image ON Image.id = PageContent.image_id WHERE PageContent.page_type_id = 57 AND PageContent.publish = 1 AND PageContent.group_of_pages = 0 ORDER BY PageContent.content_order ASC; | 4 | 4 | 4 | |
| SELECT PageContent.id, PageContentTranslation.title, PageContentTranslation.slug, PageContentTranslation.subtitle FROM page_contents PageContent INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id INNER JOIN languages Language ON Language.code_link = "en" AND Language.id = PageContentTranslation.language_code_id WHERE PageContent.page_type_id = 59 AND PageContent.publish = 1 AND PageContent.group_of_pages = 1 | 1 | 1 | 3 | maybe slow |
| SELECT PageContent.id, PageContent.video_mp4_url, PageContent.video_webm_url, PageContent.video_mobile_mp4_url, PageContent.video_mobile_webm_url, PageContentTranslation.title, PageContentTranslation.slug, PageContentTranslation.subtitle, PageContentTranslation.introduction, Image.name, TopImage.name, MobileTopImage.name, Business.* FROM page_contents PageContent INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id INNER JOIN languages Language ON Language.code_link = "en" AND Language.id = PageContentTranslation.language_code_id LEFT JOIN images Image ON Image.id = PageContent.image_id LEFT JOIN images TopImage ON TopImage.id = PageContent.top_image_id LEFT JOIN images MobileTopImage ON MobileTopImage.id = PageContent.mobile_top_image_id INNER JOIN ( SELECT PC.id AS TOT_ID, COUNT(*) AS TOT FROM page_contents PC INNER JOIN page_contents C ON C.page_type_associate LIKE CONCAT("%", PC.id, "%") WHERE C.publish = 1 GROUP BY PC.id ) as Business ON Business.TOT_ID = PageContent.id WHERE PageContent.page_type_id = 59 AND PageContent.publish = 1 AND PageContent.group_of_pages = 0 ORDER BY PageContent.content_order ASC; | 4 | 4 | 12 | maybe slow |
| SELECT PageContent.id, PageContentTranslation.title, PageContentTranslation.slug, PageContentTranslation.subtitle, PageContentTranslation.introduction FROM page_contents PageContent INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id INNER JOIN languages Language ON Language.code_link = "en" AND Language.id = PageContentTranslation.language_code_id WHERE PageContent.page_type_id = 64 AND PageContent.publish = 1 AND PageContent.group_of_pages = 1 | 1 | 1 | 3 | maybe slow |
| SELECT PageContent.id, PageContent.video_mp4_url, PageContent.video_webm_url, PageContent.video_mobile_mp4_url, PageContent.video_mobile_webm_url, PageContentTranslation.title, PageContentTranslation.slug, PageContentTranslation.subtitle, PageContentTranslation.introduction, Image.name, TopImage.name, MobileTopImage.name, Business.* FROM page_contents PageContent INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id INNER JOIN languages Language ON Language.code_link = "en" AND Language.id = PageContentTranslation.language_code_id LEFT JOIN images Image ON Image.id = PageContent.image_id LEFT JOIN images TopImage ON TopImage.id = PageContent.top_image_id LEFT JOIN images MobileTopImage ON MobileTopImage.id = PageContent.mobile_top_image_id INNER JOIN ( SELECT PC.id AS TOT_ID, COUNT(*) AS TOT FROM page_contents PC INNER JOIN page_contents C ON C.page_type_associate LIKE CONCAT("%", PC.id, "%") WHERE C.publish = 1 GROUP BY PC.id ) as Business ON Business.TOT_ID = PageContent.id WHERE PageContent.page_type_id = 64 AND PageContent.publish = 1 AND PageContent.group_of_pages = 0 ORDER BY PageContent.content_order ASC; | 3 | 3 | 13 | maybe slow |
| SELECT DISTINCT ShopType.id, ShopType.price, ShopType.promo, ShopType.price_promo, ShopTypeTranslation.title, ShopTypeTranslation.color, ShopTypeTranslation.type, ShopTypeTranslation.slug, ShopCategoryTranslation.id, ShopCategoryTranslation.slug, ShopCategoryTranslation.title, ShopProductTranslation.id, ShopProductTranslation.slug, ShopProductTranslation.title, BrandTranslation.title, Image.name FROM shop_types ShopType INNER JOIN shop_type_translations ShopTypeTranslation ON ShopTypeTranslation.product_type_id = ShopType.id INNER JOIN shop_categories ShopCategorie ON ShopCategorie.id = ShopType.category_id AND ShopCategorie.category_type = "collect_information" INNER JOIN shop_category_translations ShopCategoryTranslation ON ShopCategoryTranslation.category_id = ShopCategorie.id INNER JOIN shop_products ShopProduct ON ShopProduct.id = ShopType.product_id INNER JOIN shop_product_translations ShopProductTranslation ON ShopProductTranslation.product_id = ShopProduct.id INNER JOIN languages Language ON Language.code_link = "en" AND Language.id = ShopTypeTranslation.language_code_id AND Language.id = ShopCategoryTranslation.language_code_id AND Language.id = ShopProductTranslation.language_code_id LEFT JOIN shop_brands ShopBrand ON ShopBrand.product_type_id = ShopType.id LEFT JOIN page_contents Brand ON Brand.id = ShopBrand.brand_id LEFT JOIN page_content_translations BrandTranslation ON BrandTranslation.page_content_id = Brand.id LEFT OUTER JOIN ( SELECT i.id, i.name, i.item_id, min(i.image_order) as image_order FROM images i GROUP BY i.item_id ) as Image ON Image.item_id = ShopType.id WHERE ShopType.publish = 1 AND ShopType.destaque = 1 ORDER BY rand() LIMIT 4; | 0 | 0 | 1 | maybe slow |
| SELECT PageType.id, PageTypeTranslation.title, PageTypeTranslation.slug, PageContent.id, PageContentTranslation.title, PageContentTranslation.slug, PageContentTranslation.introduction, PageContentTranslation.description FROM page_types PageType INNER JOIN page_type_translations PageTypeTranslation ON PageTypeTranslation.page_type_id = PageType.id INNER JOIN languages Language ON Language.id = PageTypeTranslation.language_code_id AND Language.code_link = "en" INNER JOIN page_contents PageContent ON PageContent.page_type_id = PageType.id AND PageContent.group_of_pages = 1 INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id AND PageContentTranslation.language_code_id = Language.id WHERE PageType.id = 25 AND PageType.publish = 1 AND PageType.block = 0 AND PageType.static_page = 0 AND PageType.blog = 1; | 1 | 1 | 3 | maybe slow |
| SELECT PageContent.id, PageContent.created, PageContentTranslation.title, PageContentTranslation.introduction, PageContentTranslation.subtitle, PageContentTranslation.description, PageContentTranslation.slug, PageType.id, PageTypeTranslation.title, PageTypeTranslation.slug, Image.id, Image.name, ImageContent.id, ImageContent.title FROM page_types PageType INNER JOIN page_type_translations PageTypeTranslation ON PageTypeTranslation.page_type_id = PageType.id INNER JOIN page_contents PageContent ON PageContent.page_type_id = PageType.id AND PageContent.publish = 1 AND PageContent.group_of_pages = 0 INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id INNER JOIN languages Language ON Language.id = PageContentTranslation.language_code_id AND Language.id = PageTypeTranslation.language_code_id AND Language.code_link = "en" LEFT JOIN images Image ON Image.id = PageContent.image_id LEFT JOIN image_contents ImageContent ON ImageContent.image_id = Image.id WHERE PageType.id = 25 AND PageType.publish = 1 AND PageType.block = 0 AND PageType.static_page = 0 AND PageType.blog = 1 ORDER BY PageContent.content_order DESC LIMIT 3; | 3 | 3 | 11 | maybe slow |
| SELECT PageType.id, PageType.static_page, PageType.booking_system, PageType.associate_promotion, PageType.blog, PageTypeTranslation.slug, PageContent.id, PageContent.created, PageContent.associate_promotion, PageContent.duration_tour, PageContent.price_tour, PageContent.video_mobile_mp4_url, PageContent.video_mp4_url, PageContent.video_mobile_webm_url, PageContent.video_webm_url, PageContentTranslation.id, PageContentTranslation.slug, PageContentTranslation.title, PageContentTranslation.subtitle, PageContentTranslation.introduction, PageContentTranslation.description, PageContent.booking_url, Image.id, Image.name, TopImage.id, TopImage.name, Gallery.id FROM page_types PageType INNER JOIN page_contents PageContent ON PageContent.page_type_id = PageType.id AND PageContent.publish = 1 AND PageContent.group_of_pages = 0 INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id INNER JOIN languages Language ON Language.id = PageContentTranslation.language_code_id AND Language.code_link = "en" INNER JOIN page_type_translations PageTypeTranslation ON PageTypeTranslation.page_type_id = PageType.id AND PageTypeTranslation.language_code_id = Language.id LEFT JOIN images Image ON Image.id = PageContent.image_id LEFT JOIN images TopImage ON TopImage.id = PageContent.top_image_id LEFT JOIN galleries Gallery ON Gallery.page_content_id = PageContent.id WHERE PageType.id = 46 AND PageType.publish = 1 AND PageType.block = 0 ORDER BY PageContent.content_order ASC; | 3 | 3 | 4 | maybe slow |
| SELECT Promotion.id, Promotion.discount, PromotionContent.id, PromotionContent.title FROM promotions Promotion INNER JOIN promotion_contents PromotionContent ON PromotionContent.promotion_id = Promotion.id INNER JOIN languages Language ON Language.id = PromotionContent.language_code_id AND Language.code_link = "en" WHERE Promotion.publish = 1; | 0 | 0 | 0 | |
| SELECT `Language`.`id`, `Language`.`title`, `Language`.`flag` FROM `discover_discoverlagosdb2023`.`languages` AS `Language` WHERE `Language`.`code_link` = 'en' LIMIT 1 | 1 | 1 | 0 | |
| SELECT Language.id, Language.title, Language.code_link, Language.flag, Language.default_language FROM languages Language WHERE Language.publish = 1 ORDER BY Language.title ASC; | 2 | 2 | 0 | |
| SELECT PageType.id, PageType.is_homepage, PageTypeTranslation.id, PageTypeTranslation.title, PageTypeTranslation.slug FROM page_types PageType LEFT JOIN page_type_translations PageTypeTranslation ON PageTypeTranslation.page_type_id = PageType.id AND PageTypeTranslation.language_code_id = 3 WHERE PageType.show_on_menu = 1 AND PageType.publish = 1 AND PageType.block = 0 AND PageType.id <> 53 ORDER BY PageType.type_order ASC; | 1 | 1 | 0 | |
| SELECT PageContent.id, PageContentTranslation.id, PageContentTranslation.title, PageContentTranslation.subtitle, PageContentTranslation.slug FROM page_contents PageContent INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id AND PageContentTranslation.language_code_id = 3 WHERE PageContent.page_type_id = 53 AND PageContent.publish = 1 AND PageContent.group_of_pages = 0 ORDER BY PageContent.content_order ASC; | 5 | 5 | 4 | maybe slow |
| SELECT PageType.id, PageTypeTranslation.id, PageTypeTranslation.title, PageTypeTranslation.slug FROM page_types PageType INNER JOIN page_type_translations PageTypeTranslation ON PageTypeTranslation.page_type_id = PageType.id AND PageTypeTranslation.language_code_id = 3 WHERE PageType.id = 64 AND PageType.publish = 1 ORDER BY PageType.type_order ASC; | 1 | 1 | 0 | |
| SELECT PageContent.id, PageContentTranslation.id, PageContentTranslation.title, PageContentTranslation.slug, PageTypeTranslation.slug FROM page_contents PageContent INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id AND PageContentTranslation.language_code_id = 3 INNER JOIN page_types PageType ON PageType.id = PageContent.page_type_id INNER JOIN page_type_translations PageTypeTranslation ON PageTypeTranslation.page_type_id = PageType.id AND PageTypeTranslation.language_code_id = 3 WHERE PageContent.page_type_id = 59 AND PageContent.publish = 1 AND PageContent.group_of_pages = 0 ORDER BY PageContent.content_order ASC; | 4 | 4 | 4 | |
| SELECT PageContent.id, PageContentTranslation.id, PageContentTranslation.title, PageContentTranslation.slug, PageTypeTranslation.slug FROM page_contents PageContent INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id AND PageContentTranslation.language_code_id = 3 INNER JOIN page_types PageType ON PageType.id = PageContent.page_type_id INNER JOIN page_type_translations PageTypeTranslation ON PageTypeTranslation.page_type_id = PageType.id AND PageTypeTranslation.language_code_id = 3 WHERE PageContent.page_type_id = 64 AND PageContent.publish = 1 AND PageContent.group_of_pages = 0 ORDER BY PageContent.content_order ASC; | 4 | 4 | 4 | |
| SELECT ShopCategory.id, ShopCategoryTranslation.id, ShopCategoryTranslation.title, ShopCategoryTranslation.slug FROM shop_categories ShopCategory INNER JOIN shop_category_translations ShopCategoryTranslation ON ShopCategoryTranslation.category_id = ShopCategory.id AND ShopCategoryTranslation.language_code_id = 3 WHERE ShopCategory.publish = 1 ORDER BY ShopCategory.content_order ASC; | 3 | 3 | 0 | |
| SELECT ShopProduct.id, ShopProduct.category_id, ShopProductTranslation.id, ShopProductTranslation.title, ShopProductTranslation.slug FROM shop_products ShopProduct INNER JOIN shop_product_translations ShopProductTranslation ON ShopProductTranslation.product_id = ShopProduct.id AND ShopProductTranslation.language_code_id = 3 WHERE ShopProduct.publish = 1 ORDER BY ShopProduct.category_id ASC, ShopProduct.content_order ASC; | 3 | 3 | 0 | |
| SELECT PageType.id, PageType.is_homepage, PageType.type_footer_order, PageType.footer_column, PageTypeTranslation.id, PageTypeTranslation.title, PageTypeTranslation.slug FROM page_types PageType LEFT JOIN page_type_translations PageTypeTranslation ON PageTypeTranslation.page_type_id = PageType.id AND PageTypeTranslation.language_code_id = 3 WHERE PageType.show_on_footer_menu = 1 AND PageType.publish = 1 AND PageType.block = 0 ORDER BY PageType.type_footer_order ASC; | 5 | 5 | 0 | |
| SELECT PageContent.id, PageContentTranslation.title, PageContentTranslation.slug, PageContentTranslation.subtitle, PageContentTranslation.introduction FROM page_contents PageContent INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id INNER JOIN languages Language ON Language.code_link = "en" AND Language.id = PageContentTranslation.language_code_id WHERE PageContent.page_type_id = 57 AND PageContent.publish = 1 ORDER BY PageContent.content_order ASC; | 5 | 5 | 4 | maybe slow |
| SELECT `Setting`.`website_title`, `Setting`.`website_link`, `Setting`.`social_networks_script`, `Setting`.`social_networks_div`, `Setting`.`google_analytics_script`, `Setting`.`email_contact`, `Setting`.`company_cellphone`, `Setting`.`company_cellphone_whatsapp`, `Setting`.`company_telephone`, `Setting`.`company_telephone_whatsapp`, `Setting`.`company_address_1`, `Setting`.`company_address_2`, `Setting`.`company_address_3`, `Setting`.`company_image_id`, `Setting`.`accept_payments`, `Setting`.`localhost_img_link_frontend`, `Image`.`id`, `Image`.`name` FROM `discover_discoverlagosdb2023`.`settings` AS `Setting` LEFT JOIN `discover_discoverlagosdb2023`.`images` AS `Image` ON (`Setting`.`company_image_id` = `Image`.`id`) WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT PageContentTranslation.id, PageContentTranslation.title, PageContentTranslation.introduction, PageContentTranslation.seo_meta_keywords, PageContentTranslation.seo_meta_description FROM page_contents PageContent INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id AND PageContentTranslation.language_code_id = 3 WHERE PageContent.settings_page = 1 | 1 | 1 | 4 | maybe slow |
| SELECT WebsiteContact.id, WebsiteContact.type, WebsiteContact.contact_order, WebsiteContact.email_content, WebsiteContact.phone_country_code, WebsiteContact.phone_number, WebsiteContact.address_1, WebsiteContact.address_2, WebsiteContact.address_3, WebsiteContact.gps_lat, WebsiteContact.gps_lon, WebsiteContactContent.title, WebsiteContactContent.timetable_1, WebsiteContactContent.timetable_2 FROM website_contacts WebsiteContact LEFT JOIN website_contact_contents WebsiteContactContent ON WebsiteContactContent.website_contact_id = WebsiteContact.id AND WebsiteContactContent.language_code_id = 3 WHERE WebsiteContact.publish = 1 ORDER BY WebsiteContact.type DESC, WebsiteContact.contact_order ASC; | 0 | 0 | 0 |
2 duplicate queries run.
Peak Memory Use 9.12 MB
| Message | Memory use |
|---|---|
| Component initialization | 3.79 MB |
| Controller action start | 4.20 MB |
| Controller render start | 5.94 MB |
| View render complete | 7.47 MB |
Total Request Time: 327 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 45.97 | |
| Event: Controller.initialize | 1.19 | |
| Event: Controller.startup | 1.54 | |
| Controller action | 211.08 | |
| Event: Controller.beforeRender | 32.61 | |
| » Processing toolbar data | 4.48 | |
| Rendering View | 5.19 | |
| » Event: View.beforeRender | 0.02 | |
| » Rendering APP/View/PageTypes/homepage.ctp | 1.37 | |
| » Event: View.afterRender | 0.01 | |
| » Event: View.beforeLayout | 0.01 | |
| » Rendering APP/View/Layouts/default.ctp | 3.18 | |
| » » Rendering APP/View/Elements/site_search.ctp | 0.12 | |
| Event: View.afterLayout | 0.00 |
| Constant | Value |
|---|---|
| CONFIG | '/home/discover/public_html/app/Config/' |
| DEFAULT_LANGUAGE | 'en' |
| PRODUCT_TYPES_INDEXABLE_PAGE_IDS | array( (int) 0 => (int) 166, (int) 1 => (int) 167, (int) 2 => (int) 168, (int) 3 => (int) 170, (int) 4 => (int) 172, (int) 5 => (int) 226, (int) 6 => (int) 360, (int) 7 => (int) 369 ) |
| Constant | Value |
|---|---|
| APP | '/home/discover/public_html/app/' |
| APP_DIR | 'app' |
| APPLIBS | '/home/discover/public_html/app/Lib/' |
| CACHE | '/home/discover/public_html/app/tmp/cache/' |
| CAKE | '/home/discover/public_html/lib/Cake/' |
| CAKE_CORE_INCLUDE_PATH | '/home/discover/public_html/lib' |
| CORE_PATH | '/home/discover/public_html/lib/' |
| CAKE_VERSION | '2.10.24' |
| CSS | '/home/discover/public_html/app/webroot/css/' |
| CSS_URL | 'css/' |
| DS | '/' |
| FULL_BASE_URL | 'https://www.discoverlagos.com' |
| IMAGES | '/home/discover/public_html/app/webroot/img/' |
| IMAGES_URL | 'img/' |
| JS | '/home/discover/public_html/app/webroot/js/' |
| JS_URL | 'js/' |
| LOGS | '/home/discover/public_html/app/tmp/logs/' |
| ROOT | '/home/discover/public_html' |
| TESTS | '/home/discover/public_html/app/Test/' |
| TMP | '/home/discover/public_html/app/tmp/' |
| VENDORS | '/home/discover/public_html/vendors/' |
| WEBROOT_DIR | 'webroot' |
| WWW_ROOT | '/home/discover/public_html/app/webroot/' |
| Environment Variable | Value |
|---|---|
| Php Version | '7.4.33' |
| Http Host | 'www.discoverlagos.com' |
| Document Root | '/home/discover/public_html' |
| Path | '/usr/local/bin:/usr/bin:/bin' |
| Temp | '/tmp' |
| Tmp | '/tmp' |
| Tmpdir | '/tmp' |
| Pwd | '/' |
| Lscapi Criu Sync Fd | '7' |
| Http Accept | '*/*' |
| Http Accept Encoding | 'gzip, br, zstd, deflate' |
| Http Connection | 'close' |
| Content Length | '0' |
| Http Cookie | 'preferred_language_source=auto; preferred_language=en; CAKEPHP=11c362630f1e422b92db0d4f2e767699; CakeCookie[config_language]=Q2FrZQ%3D%3D.HGM%3D' |
| Http Referer | 'https://www.discoverlagos.com/' |
| Http User Agent | 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' |
| Http X Real Ip | '216.73.216.91' |
| Http X Forwarded By | '94.46.183.45:443' |
| Http X Forwarded Port | '443' |
| Http X Forwarded Proto | 'https' |
| Http X Https | '1' |
| Redirect Redirect Unique Id | 'ajlslzP2GQcSUjLYZp89QgAAAAQ' |
| Redirect Redirect Script Url | '/en' |
| Redirect Redirect Script Uri | 'https://www.discoverlagos.com/en' |
| Redirect Redirect Https | 'on' |
| Redirect Redirect Ssl Tls Sni | 'www.discoverlagos.com' |
| Redirect Redirect Status | '200' |
| Redirect Unique Id | 'ajlslzP2GQcSUjLYZp89QgAAAAQ' |
| Redirect Script Url | '/en' |
| Redirect Script Uri | 'https://www.discoverlagos.com/en' |
| Redirect Http Authorization | '' |
| Redirect Https | 'on' |
| Redirect Ssl Tls Sni | 'www.discoverlagos.com' |
| Redirect Status | '200' |
| Unique Id | 'ajlslzP2GQcSUjLYZp89QgAAAAQ' |
| Script Url | '/en' |
| Script Uri | 'https://www.discoverlagos.com/en' |
| Http Authorization | '' |
| Https | 'on' |
| Ssl Tls Sni | 'www.discoverlagos.com' |
| Server Signature | '' |
| Server Software | 'Apache' |
| Server Name | 'www.discoverlagos.com' |
| Server Addr | '94.46.183.45' |
| Server Port | '443' |
| Remote Addr | '216.73.216.91' |
| Request Scheme | 'https' |
| Context Prefix | '' |
| Context Document Root | '/home/discover/public_html' |
| Server Admin | 'webmaster@discoverlagos.com' |
| Script Filename | '/home/discover/public_html/app/webroot/index.php' |
| Remote Port | '33826' |
| Redirect Url | '/app/webroot/en' |
| Server Protocol | 'HTTP/1.0' |
| Request Method | 'GET' |
| Query String | '' |
| Request Uri | '/en' |
| Script Name | '/app/webroot/index.php' |
| Php Self | '/app/webroot/index.php' |
| Request Time Float | (float) 1782148247.515 |
| Request Time | (int) 1782148247 |