Activities

Things to Do in Lagos: A Local's Overview

Lagos packs an extraordinary amount into a small, walkable town — and the best way to plan is to think in two halves: what you do on the water and what you do on land. Between them you've got days of options, from the iconic to the quietly local. Here's how we'd frame it.

On the water — the unmissable side of Lagos

This coast is the reason most people come, and the sea is where Lagos shines:

Boat trips to the grottos and the Benagil cave — the famous sea caves and rock formations. Start with our guide to visiting Benagil from Lagos and our honest comparison of the boat tours.

Dolphin watching — wild dolphins in the Atlantic, a short fast trip offshore. See our dolphin watching guide.

Ponta da Piedade by boat, kayak or on foot — the headland of golden cliffs and arches. Our complete Ponta da Piedade guide covers all three ways to see it.

Kayak, SUP, surfing and other watersports — from gentle paddles to your first wave. If you fancy learning to surf, read our beginner's surf guide.

On land — culture, history and easy exploring

When you're off the water, the old town and its surroundings reward slow exploring: the historic centre with its walls, churches and squares; the open-air gallery of Lagos street art; and easy day trips to Sagres, Silves and the west coast when you want to venture further.

How to choose

One day? Pair a grotto boat trip with the old town — that's the essential Lagos.

With kids? Dolphin watching and gentle grotto tours are the usual hits.

Active? Kayak the arches of Ponta da Piedade or take a surf lesson.

Prefer dry land? A street-art walk and the historic centre fill a relaxed day.

Not sure how to fit it together? Our guide to how many days to spend in Lagos lays out itineraries for one to four days.

Browse all the activities below to see what's on offer and book directly — and as a registered local agency (RNAAT 40/2022), we're always happy to point you to the right experience.

FAQ

What are the best things to do in Lagos?

The highlights are on the water: a boat trip to the grottos and the Benagil cave, dolphin watching, and seeing Ponta da Piedade by boat or kayak. On land, the historic old town and the street-art trail are the must-dos.

What is there to do in Lagos when it's not beach weather?

Plenty — boat trips often run year-round, and the old town, museums, churches and the street-art walk are great in any weather. Day trips to Sagres or Silves also work well on cooler days.

What can you do in Lagos with kids?

Dolphin watching and gentle grotto boat tours are firm family favourites, along with the beaches and easy clifftop walks. See our guide to Lagos with kids for more.

Do you need to book activities in advance?

In July and August, yes — the popular boat and dolphin tours sell out a day or two ahead. In quieter months you can often book on the day.

What's the one thing not to miss in Lagos?

If you do only one thing, take a small-boat trip into the grottos at Ponta da Piedade — it's the experience that defines this coast.

x Historic Center

What to do

Exciting activities to enjoy alone or with more persons

Kayak Tours

Ponta da Piedade

Reservation for

Notice (8): Undefined variable: time_slots_array [APP/View/PageTypes/view.ctp, line 3445]Code Context

                        <?php echo $this->Form->input('bkg_rqst_time', array('type'=>'select', 'id'=>'bkg_rqst_time', 'class'=>'input', 'style'=>'color: #909090; margin-top: 15px; margin-bottom: 0px;', 'empty'=>'* '.__('What time ?'), 'options'=>$time_slots_array, 'label'=>false, 'div'=>false)); ?>
$viewFile = '/home/discover/public_html/app/View/PageTypes/view.ctp'
$dataForView = array(
	'canonical_url' => 'https://www.discoverlagos.com/en/what-to-do',
	'total_compras' => (int) 0,
	'lang_menu_array' => array(
		'en' => 'English',
		'pt' => 'Português'
	),
	'redirects_translations' => array(
		(int) 0 => array(
			'slug' => '',
			'language_code_id' => '',
			'code' => '',
			'code_link' => 'pt'
		),
		(int) 1 => array(
			'slug' => '',
			'language_code_id' => '',
			'code' => '',
			'code_link' => 'en'
		)
	),
	'url_get_variables' => '?place=historic-center',
	'filter_by_place' => 'historic-center',
	'place_filter_tag' => array(
		(int) 0 => array(
			'PageContent' => array(
				[maximum depth reached]
			),
			'PageContentTranslation' => array(
				[maximum depth reached]
			)
		)
	),
	'title_for_layout_default' => 'Discover Lagos - Local Tourist Guide',
	'meta_tags_details' => array(
		(int) 0 => array(
			'PageContentTranslation' => array(
				[maximum depth reached]
			)
		)
	),
	'website_settings' => array(
		'Setting' => array(
			'website_title' => 'Discover Lagos',
			'website_link' => 'www.discoverlagos.com',
			'social_networks_script' => '',
			'social_networks_div' => '',
			'google_analytics_script' => '<!-- Google tag (gtag.js) -->
<script async src="https://www.googletagmanager.com/gtag/js?id=G-Y6JG801LRY"></script>
<script>
  window.dataLayer = window.dataLayer || [];
  function gtag(){dataLayer.push(arguments);}
  gtag('js', new Date());

  gtag('config', 'G-Y6JG801LRY');

gtag('consent', 'default', {
  'ad_storage': 'denied',
  'ad_user_data': 'denied',
  'ad_personalization': 'denied',
  'analytics_storage': 'denied'
});
</script>',
			'email_contact' => 'info@discoverlagos.com',
			'company_cellphone' => '(+351) 962 111 620',
			'company_cellphone_whatsapp' => '0',
			'company_telephone' => '',
			'company_telephone_whatsapp' => '0',
			'company_address_1' => '',
			'company_address_2' => '',
			'company_address_3' => '',
			'company_image_id' => '330',
			'accept_payments' => '0',
			'localhost_img_link_frontend' => '/cake/DiscoverLagos/discoverlagos.com/APP/'
		),
		'Image' => array(
			'id' => '330',
			'name' => 'discover_lagos_facebook.jpg'
		)
	),
	'places_menu' => array(
		(int) 0 => array(
			'PageContent' => array(
				[maximum depth reached]
			),
			'PageContentTranslation' => array(
				[maximum depth reached]
			)
		),
		(int) 1 => array(
			'PageContent' => array(
				[maximum depth reached]
			),
			'PageContentTranslation' => array(
				[maximum depth reached]
			)
		),
		(int) 2 => array(
			'PageContent' => array(
				[maximum depth reached]
			),
			'PageContentTranslation' => array(
				[maximum depth reached]
			)
		),
		(int) 3 => array(
			'PageContent' => array(
				[maximum depth reached]
			),
			'PageContentTranslation' => array(
				[maximum depth reached]
			)
		),
		(int) 4 => array(
			'PageContent' => array(
				[maximum depth reached]
			),
			'PageContentTranslation' => array(
				[maximum depth reached]
			)
		)
	),
	'footer_menus' => array(
		(int) 0 => array(
			'PageType' => array(
				[maximum depth reached]
			),
			'PageTypeTranslation' => array(
				[maximum depth reached]
			)
		),
		(int) 1 => array(
			'PageType' => array(
				[maximum depth reached]
			),
			'PageTypeTranslation' => array(
				[maximum depth reached]
			)
		),
		(int) 2 => array(
			'PageType' => array(
				[maximum depth reached]
			),
			'PageTypeTranslation' => array(
				[maximum depth reached]
			)
		),
		(int) 3 => array(
			'PageType' => array(
				[maximum depth reached]
			),
			'PageTypeTranslation' => array(
				[maximum depth reached]
			)
		),
		(int) 4 => array(
			'PageType' => array(
				[maximum depth reached]
			),
			'PageTypeTranslation' => array(
				[maximum depth reached]
			)
		)
	),
	'sub_menus_extra' => array(
		(int) 0 => array(
			'ShopProduct' => array(
				[maximum depth reached]
			),
			'ShopProductTranslation' => array(
				[maximum depth reached]
			)
		),
		(int) 1 => array(
			'ShopProduct' => array(
				[maximum depth reached]
			),
			'ShopProductTranslation' => array(
				[maximum depth reached]
			)
		),
		(int) 2 => array(
			'ShopProduct' => array(
				[maximum depth reached]
			),
			'ShopProductTranslation' => array(
				[maximum depth reached]
			)
		)
	),
	'menus_extra' => array(
		(int) 0 => array(
			'ShopCategory' => array(
				[maximum depth reached]
			),
			'ShopCategoryTranslation' => array(
				[maximum depth reached]
			)
		),
		(int) 1 => array(
			'ShopCategory' => array(
				[maximum depth reached]
			),
			'ShopCategoryTranslation' => array(
				[maximum depth reached]
			)
		),
		(int) 2 => array(
			'ShopCategory' => array(
				[maximum depth reached]
			),
			'ShopCategoryTranslation' => array(
				[maximum depth reached]
			)
		)
	),
	'menus_services' => array(
		(int) 0 => array(
			'PageContent' => array(
				[maximum depth reached]
			),
			'PageContentTranslation' => array(
				[maximum depth reached]
			),
			'PageTypeTranslation' => array(
				[maximum depth reached]
			)
		),
		(int) 1 => array(
			'PageContent' => array(
				[maximum depth reached]
			),
			'PageContentTranslation' => array(
				[maximum depth reached]
			),
			'PageTypeTranslation' => array(
				[maximum depth reached]
			)
		),
		(int) 2 => array(
			'PageContent' => array(
				[maximum depth reached]
			),
			'PageContentTranslation' => array(
				[maximum depth reached]
			),
			'PageTypeTranslation' => array(
				[maximum depth reached]
			)
		),
		(int) 3 => array(
			'PageContent' => array(
				[maximum depth reached]
			),
			'PageContentTranslation' => array(
				[maximum depth reached]
			),
			'PageTypeTranslation' => array(
				[maximum depth reached]
			)
		)
	),
	'menus_explore' => array(
		(int) 0 => array(
			'PageContent' => array(
				[maximum depth reached]
			),
			'PageContentTranslation' => array(
				[maximum depth reached]
			),
			'PageTypeTranslation' => array(
				[maximum depth reached]
			)
		),
		(int) 1 => array(
			'PageContent' => array(
				[maximum depth reached]
			),
			'PageContentTranslation' => array(
				[maximum depth reached]
			),
			'PageTypeTranslation' => array(
				[maximum depth reached]
			)
		),
		(int) 2 => array(
			'PageContent' => array(
				[maximum depth reached]
			),
			'PageContentTranslation' => array(
				[maximum depth reached]
			),
			'PageTypeTranslation' => array(
				[maximum depth reached]
			)
		),
		(int) 3 => array(
			'PageContent' => array(
				[maximum depth reached]
			),
			'PageContentTranslation' => array(
				[maximum depth reached]
			),
			'PageTypeTranslation' => array(
				[maximum depth reached]
			)
		)
	),
	'menus_categories' => array(
		(int) 0 => array(
			'PageContent' => array(
				[maximum depth reached]
			),
			'PageContentTranslation' => array(
				[maximum depth reached]
			)
		),
		(int) 1 => array(
			'PageContent' => array(
				[maximum depth reached]
			),
			'PageContentTranslation' => array(
				[maximum depth reached]
			)
		),
		(int) 2 => array(
			'PageContent' => array(
				[maximum depth reached]
			),
			'PageContentTranslation' => array(
				[maximum depth reached]
			)
		),
		(int) 3 => array(
			'PageContent' => array(
				[maximum depth reached]
			),
			'PageContentTranslation' => array(
				[maximum depth reached]
			)
		),
		(int) 4 => array(
			'PageContent' => array(
				[maximum depth reached]
			),
			'PageContentTranslation' => array(
				[maximum depth reached]
			)
		),
		(int) 5 => array(
			'PageType' => array(
				[maximum depth reached]
			),
			'PageTypeTranslation' => array(
				[maximum depth reached]
			)
		)
	),
	'menus' => array(
		(int) 0 => array(
			'PageType' => array(
				[maximum depth reached]
			),
			'PageTypeTranslation' => array(
				[maximum depth reached]
			)
		)
	),
	'array_langs' => array(
		(int) 0 => 'English',
		(int) 1 => 'Português'
	),
	'flag_array' => array(
		'en' => 'eng.jpg',
		'pt' => 'por.jpg'
	),
	'curr_languages' => array(
		(int) 0 => array(
			'Language' => array(
				[maximum depth reached]
			)
		),
		(int) 1 => array(
			'Language' => array(
				[maximum depth reached]
			)
		)
	),
	'curr_language' => array(
		'Language' => array(
			'id' => '3',
			'title' => 'English',
			'flag' => 'eng.jpg'
		)
	),
	'webroot' => '/',
	'curr_lang' => 'en',
	'debugToolbarPanels' => array(
		'history' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'history_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'session' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'session_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'request' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'request_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'sql_log' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'sql_log_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'timer' => array(
			'content' => null,
			'elementName' => 'timer_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'log' => array(
			'content' => object(DebugKitLog) {},
			'elementName' => 'log_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'variables' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'variables_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'environment' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'environment_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'include' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'include_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		)
	),
	'debugToolbarJavascript' => array(
		'libs' => 'DebugKit./js/js_debug_toolbar'
	),
	'debugToolbarCss' => array(
		(int) 0 => 'DebugKit./css/debug_toolbar.css'
	),
	'product_types' => array(
		(int) 0 => array(
			'PageContent' => array(
				[maximum depth reached]
			),
			'PageContentTranslation' => array(
				[maximum depth reached]
			),
			'Image' => array(
				[maximum depth reached]
			),
			'TopImage' => array(
				[maximum depth reached]
			),
			'MobileTopImage' => array(
				[maximum depth reached]
			),
			'Business' => array(
				[maximum depth reached]
			)
		)
	),
	'places' => array(
		(int) 0 => array(
			'PageContent' => array(
				[maximum depth reached]
			),
			'PageContentTranslation' => array(
				[maximum depth reached]
			)
		),
		(int) 1 => array(
			'PageContent' => array(
				[maximum depth reached]
			),
			'PageContentTranslation' => array(
				[maximum depth reached]
			)
		),
		(int) 2 => array(
			'PageContent' => array(
				[maximum depth reached]
			),
			'PageContentTranslation' => array(
				[maximum depth reached]
			)
		),
		(int) 3 => array(
			'PageContent' => array(
				[maximum depth reached]
			),
			'PageContentTranslation' => array(
				[maximum depth reached]
			)
		)
	),
	'page_faqs' => array(
		(int) 0 => array(
			'PageContentFaq' => array(
				[maximum depth reached]
			)
		),
		(int) 1 => array(
			'PageContentFaq' => array(
				[maximum depth reached]
			)
		),
		(int) 2 => array(
			'PageContentFaq' => array(
				[maximum depth reached]
			)
		),
		(int) 3 => array(
			'PageContentFaq' => array(
				[maximum depth reached]
			)
		),
		(int) 4 => array(
			'PageContentFaq' => array(
				[maximum depth reached]
			)
		)
	),
	'hreflangs_contents' => array(
		(int) 0 => array(
			'PageContent' => array(
				[maximum depth reached]
			),
			'PageContentTranslation' => array(
				[maximum depth reached]
			),
			'Language' => array(
				[maximum depth reached]
			)
		),
		(int) 1 => array(
			'PageContent' => array(
				[maximum depth reached]
			),
			'PageContentTranslation' => array(
				[maximum depth reached]
			),
			'Language' => array(
				[maximum depth reached]
			)
		)
	),
	'canonical_url_path' => '/en/what-to-do',
	'title_for_layout' => 'Things to Do in Lagos, Algarve | Discover Lagos',
	'page_type' => array(
		(int) 0 => array(
			'PageContent' => array(
				[maximum depth reached]
			),
			'PageContentTranslation' => array(
				[maximum depth reached]
			),
			'TopImage' => array(
				[maximum depth reached]
			),
			'Image' => array(
				[maximum depth reached]
			)
		)
	),
	'is_mobile' => 'no'
)
$canonical_url = 'https://www.discoverlagos.com/en/what-to-do'
$total_compras = (int) 0
$lang_menu_array = array(
	'en' => 'English',
	'pt' => 'Português'
)
$redirects_translations = array(
	(int) 0 => array(
		'slug' => '',
		'language_code_id' => '',
		'code' => '',
		'code_link' => 'pt'
	),
	(int) 1 => array(
		'slug' => '',
		'language_code_id' => '',
		'code' => '',
		'code_link' => 'en'
	)
)
$url_get_variables = '?place=historic-center'
$filter_by_place = 'historic-center'
$place_filter_tag = array(
	(int) 0 => array(
		'PageContent' => array(
			'id' => '261'
		),
		'PageContentTranslation' => array(
			'title' => 'Historic Center',
			'slug' => 'historic-center'
		)
	)
)
$title_for_layout_default = 'Discover Lagos - Local Tourist Guide'
$meta_tags_details = array(
	(int) 0 => array(
		'PageContentTranslation' => array(
			'id' => '101',
			'title' => 'Discover Lagos - Local Tourist Guide',
			'introduction' => 'Discover Lagos',
			'seo_meta_keywords' => '',
			'seo_meta_description' => ''
		)
	)
)
$website_settings = array(
	'Setting' => array(
		'website_title' => 'Discover Lagos',
		'website_link' => 'www.discoverlagos.com',
		'social_networks_script' => '',
		'social_networks_div' => '',
		'google_analytics_script' => '<!-- Google tag (gtag.js) -->
<script async src="https://www.googletagmanager.com/gtag/js?id=G-Y6JG801LRY"></script>
<script>
  window.dataLayer = window.dataLayer || [];
  function gtag(){dataLayer.push(arguments);}
  gtag('js', new Date());

  gtag('config', 'G-Y6JG801LRY');

gtag('consent', 'default', {
  'ad_storage': 'denied',
  'ad_user_data': 'denied',
  'ad_personalization': 'denied',
  'analytics_storage': 'denied'
});
</script>',
		'email_contact' => 'info@discoverlagos.com',
		'company_cellphone' => '(+351) 962 111 620',
		'company_cellphone_whatsapp' => '0',
		'company_telephone' => '',
		'company_telephone_whatsapp' => '0',
		'company_address_1' => '',
		'company_address_2' => '',
		'company_address_3' => '',
		'company_image_id' => '330',
		'accept_payments' => '0',
		'localhost_img_link_frontend' => '/cake/DiscoverLagos/discoverlagos.com/APP/'
	),
	'Image' => array(
		'id' => '330',
		'name' => 'discover_lagos_facebook.jpg'
	)
)
$places_menu = array(
	(int) 0 => array(
		'PageContent' => array(
			'id' => '443'
		),
		'PageContentTranslation' => array(
			'title' => 'Places',
			'slug' => 'places',
			'subtitle' => null,
			'introduction' => null
		)
	),
	(int) 1 => array(
		'PageContent' => array(
			'id' => '261'
		),
		'PageContentTranslation' => array(
			'title' => 'Historic Center',
			'slug' => 'historic-center',
			'subtitle' => 'Inside the castle walls',
			'introduction' => 'Old Town'
		)
	),
	(int) 2 => array(
		'PageContent' => array(
			'id' => '289'
		),
		'PageContentTranslation' => array(
			'title' => 'Urban Town',
			'slug' => 'urban-town',
			'subtitle' => 'Outside the castle walls',
			'introduction' => null
		)
	),
	(int) 3 => array(
		'PageContent' => array(
			'id' => '259'
		),
		'PageContentTranslation' => array(
			'title' => 'Odiáxere',
			'slug' => 'odiaxere',
			'subtitle' => '6 km to the center of Lagos',
			'introduction' => 'Odiáxere'
		)
	),
	(int) 4 => array(
		'PageContent' => array(
			'id' => '260'
		),
		'PageContentTranslation' => array(
			'title' => 'Luz',
			'slug' => 'luz',
			'subtitle' => '7 km to the center of Lagos',
			'introduction' => 'Praia da Luz'
		)
	)
)
$footer_menus = array(
	(int) 0 => array(
		'PageType' => array(
			'id' => '40',
			'is_homepage' => '0',
			'type_footer_order' => '1',
			'footer_column' => '1'
		),
		'PageTypeTranslation' => array(
			'id' => '53',
			'title' => 'FAQ',
			'slug' => 'faq'
		)
	),
	(int) 1 => array(
		'PageType' => array(
			'id' => '21',
			'is_homepage' => '0',
			'type_footer_order' => '2',
			'footer_column' => '1'
		),
		'PageTypeTranslation' => array(
			'id' => '13',
			'title' => 'Contact Us',
			'slug' => 'contact-us'
		)
	),
	(int) 2 => array(
		'PageType' => array(
			'id' => '41',
			'is_homepage' => '0',
			'type_footer_order' => '3',
			'footer_column' => '1'
		),
		'PageTypeTranslation' => array(
			'id' => '55',
			'title' => 'Privacy Policy',
			'slug' => 'privacy-policy'
		)
	),
	(int) 3 => array(
		'PageType' => array(
			'id' => '24',
			'is_homepage' => '0',
			'type_footer_order' => '4',
			'footer_column' => '1'
		),
		'PageTypeTranslation' => array(
			'id' => '19',
			'title' => 'About the Project',
			'slug' => 'about-the-project'
		)
	),
	(int) 4 => array(
		'PageType' => array(
			'id' => '25',
			'is_homepage' => '0',
			'type_footer_order' => '6',
			'footer_column' => '1'
		),
		'PageTypeTranslation' => array(
			'id' => '21',
			'title' => 'Blog',
			'slug' => 'blog'
		)
	)
)
$sub_menus_extra = array(
	(int) 0 => array(
		'ShopProduct' => array(
			'id' => '34',
			'category_id' => '13'
		),
		'ShopProductTranslation' => array(
			'id' => '67',
			'title' => 'Lagos illustrations',
			'slug' => 'lagos-illustrations'
		)
	),
	(int) 1 => array(
		'ShopProduct' => array(
			'id' => '36',
			'category_id' => '15'
		),
		'ShopProductTranslation' => array(
			'id' => '71',
			'title' => 'City Tours',
			'slug' => 'city-tours'
		)
	),
	(int) 2 => array(
		'ShopProduct' => array(
			'id' => '37',
			'category_id' => '15'
		),
		'ShopProductTranslation' => array(
			'id' => '73',
			'title' => 'Virtual Tours',
			'slug' => 'virtual-tours'
		)
	)
)
$menus_extra = array(
	(int) 0 => array(
		'ShopCategory' => array(
			'id' => '13'
		),
		'ShopCategoryTranslation' => array(
			'id' => '25',
			'title' => 'Postcards',
			'slug' => 'postcards'
		)
	),
	(int) 1 => array(
		'ShopCategory' => array(
			'id' => '14'
		),
		'ShopCategoryTranslation' => array(
			'id' => '27',
			'title' => 'NFT's',
			'slug' => 'nft-s'
		)
	),
	(int) 2 => array(
		'ShopCategory' => array(
			'id' => '15'
		),
		'ShopCategoryTranslation' => array(
			'id' => '29',
			'title' => 'Tours',
			'slug' => 'tours'
		)
	)
)
$menus_services = array(
	(int) 0 => array(
		'PageContent' => array(
			'id' => '389'
		),
		'PageContentTranslation' => array(
			'id' => '763',
			'title' => 'Dentists',
			'slug' => 'dentists'
		),
		'PageTypeTranslation' => array(
			'slug' => 'need-help'
		)
	),
	(int) 1 => array(
		'PageContent' => array(
			'id' => '390'
		),
		'PageContentTranslation' => array(
			'id' => '765',
			'title' => 'Health',
			'slug' => 'health'
		),
		'PageTypeTranslation' => array(
			'slug' => 'need-help'
		)
	),
	(int) 2 => array(
		'PageContent' => array(
			'id' => '400'
		),
		'PageContentTranslation' => array(
			'id' => '785',
			'title' => 'Pharmacies',
			'slug' => 'pharmacies'
		),
		'PageTypeTranslation' => array(
			'slug' => 'need-help'
		)
	),
	(int) 3 => array(
		'PageContent' => array(
			'id' => '423'
		),
		'PageContentTranslation' => array(
			'id' => '831',
			'title' => 'Transports',
			'slug' => 'transports'
		),
		'PageTypeTranslation' => array(
			'slug' => 'need-help'
		)
	)
)
$menus_explore = array(
	(int) 0 => array(
		'PageContent' => array(
			'id' => '280'
		),
		'PageContentTranslation' => array(
			'id' => '545',
			'title' => 'Beaches',
			'slug' => 'beaches'
		),
		'PageTypeTranslation' => array(
			'slug' => 'explore'
		)
	),
	(int) 1 => array(
		'PageContent' => array(
			'id' => '281'
		),
		'PageContentTranslation' => array(
			'id' => '547',
			'title' => 'Sights',
			'slug' => 'sights'
		),
		'PageTypeTranslation' => array(
			'slug' => 'explore'
		)
	),
	(int) 2 => array(
		'PageContent' => array(
			'id' => '282'
		),
		'PageContentTranslation' => array(
			'id' => '549',
			'title' => 'Urban Art',
			'slug' => 'urban-art'
		),
		'PageTypeTranslation' => array(
			'slug' => 'explore'
		)
	),
	(int) 3 => array(
		'PageContent' => array(
			'id' => '284'
		),
		'PageContentTranslation' => array(
			'id' => '553',
			'title' => 'Other Places',
			'slug' => 'other-places'
		),
		'PageTypeTranslation' => array(
			'slug' => 'explore'
		)
	)
)
$menus_categories = array(
	(int) 0 => array(
		'PageContent' => array(
			'id' => '162'
		),
		'PageContentTranslation' => array(
			'id' => '309',
			'title' => 'What to do',
			'subtitle' => 'Activities',
			'slug' => 'what-to-do'
		)
	),
	(int) 1 => array(
		'PageContent' => array(
			'id' => '164'
		),
		'PageContentTranslation' => array(
			'id' => '313',
			'title' => 'Enjoy a meal',
			'subtitle' => 'Foods',
			'slug' => 'enjoy-a-meal'
		)
	),
	(int) 2 => array(
		'PageContent' => array(
			'id' => '165'
		),
		'PageContentTranslation' => array(
			'id' => '315',
			'title' => 'Just relax',
			'subtitle' => 'Drinks',
			'slug' => 'relax-with-a-drink'
		)
	),
	(int) 3 => array(
		'PageContent' => array(
			'id' => '209'
		),
		'PageContentTranslation' => array(
			'id' => '403',
			'title' => 'Shopping',
			'subtitle' => 'Shopping',
			'slug' => 'shopping'
		)
	),
	(int) 4 => array(
		'PageContent' => array(
			'id' => '219'
		),
		'PageContentTranslation' => array(
			'id' => '423',
			'title' => 'Enjoy',
			'subtitle' => 'Leisure',
			'slug' => 'enjoy'
		)
	),
	(int) 5 => array(
		'PageType' => array(
			'id' => '64'
		),
		'PageTypeTranslation' => array(
			'id' => '100',
			'title' => 'Services',
			'slug' => 'need-help',
			'subtitle' => 'Services'
		)
	)
)
$menus = array(
	(int) 0 => array(
		'PageType' => array(
			'id' => '27',
			'is_homepage' => '1'
		),
		'PageTypeTranslation' => array(
			'id' => '25',
			'title' => 'Home',
			'slug' => 'home'
		)
	)
)
$array_langs = array(
	(int) 0 => 'English',
	(int) 1 => 'Português'
)
$flag_array = array(
	'en' => 'eng.jpg',
	'pt' => 'por.jpg'
)
$curr_languages = array(
	(int) 0 => array(
		'Language' => array(
			'id' => '3',
			'title' => 'English',
			'code_link' => 'en',
			'flag' => 'eng.jpg',
			'default_language' => '1'
		)
	),
	(int) 1 => array(
		'Language' => array(
			'id' => '2',
			'title' => 'Português',
			'code_link' => 'pt',
			'flag' => 'por.jpg',
			'default_language' => '0'
		)
	)
)
$curr_language = array(
	'Language' => array(
		'id' => '3',
		'title' => 'English',
		'flag' => 'eng.jpg'
	)
)
$webroot = '/'
$curr_lang = 'en'
$debugToolbarPanels = array(
	'history' => array(
		'content' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			)
		),
		'elementName' => 'history_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'session' => array(
		'content' => array(
			'Config' => array(
				[maximum depth reached]
			),
			'config_language' => 'en',
			'_Token' => array(
				[maximum depth reached]
			)
		),
		'elementName' => 'session_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'request' => array(
		'content' => array(
			'params' => array(
				[maximum depth reached]
			),
			'url' => 'en/what-to-do',
			'query' => array(
				[maximum depth reached]
			),
			'data' => array([maximum depth reached]),
			'cookie' => array([maximum depth reached]),
			'get' => array(
				[maximum depth reached]
			),
			'currentRoute' => object(CakeRoute) {}
		),
		'elementName' => 'request_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'sql_log' => array(
		'content' => array(
			'connections' => array(
				[maximum depth reached]
			),
			'threshold' => (int) 20
		),
		'elementName' => 'sql_log_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'timer' => array(
		'content' => null,
		'elementName' => 'timer_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'log' => array(
		'content' => object(DebugKitLog) {},
		'elementName' => 'log_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'variables' => array(
		'content' => array(
			'product_types' => array(
				[maximum depth reached]
			),
			'places' => array(
				[maximum depth reached]
			),
			'page_faqs' => array(
				[maximum depth reached]
			),
			'hreflangs_contents' => array(
				[maximum depth reached]
			),
			'canonical_url_path' => '/en/what-to-do',
			'title_for_layout' => 'Things to Do in Lagos, Algarve | Discover Lagos',
			'page_type' => array(
				[maximum depth reached]
			),
			'is_mobile' => 'no',
			'$request->data' => array([maximum depth reached])
		),
		'elementName' => 'variables_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'environment' => array(
		'content' => array(
			'php' => array(
				[maximum depth reached]
			),
			'cake' => array(
				[maximum depth reached]
			),
			'app' => array(
				[maximum depth reached]
			)
		),
		'elementName' => 'environment_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'include' => array(
		'content' => array(
			'core' => array(
				[maximum depth reached]
			),
			'app' => array(
				[maximum depth reached]
			),
			'plugins' => array(
				[maximum depth reached]
			),
			'paths' => array(
				[maximum depth reached]
			)
		),
		'elementName' => 'include_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	)
)
$debugToolbarJavascript = array(
	'libs' => 'DebugKit./js/js_debug_toolbar'
)
$debugToolbarCss = array(
	(int) 0 => 'DebugKit./css/debug_toolbar.css'
)
$product_types = array(
	(int) 0 => array(
		'PageContent' => array(
			'id' => '168',
			'publish' => '1',
			'video_mp4_url' => 'https://res.cloudinary.com/dsb2jsgvd/video/upload/v1685037627/videos/activities/mp4/kayaks_3840x1714_uu7iiq.mp4',
			'video_webm_url' => 'https://res.cloudinary.com/dsb2jsgvd/video/upload/v1685037670/videos/activities/webm/kayaks_3840x1714_ij5ou0.webm',
			'video_mobile_mp4_url' => 'https://res.cloudinary.com/dsb2jsgvd/video/upload/v1697220297/videos/activities/mobile/mp4/kayak_tours_400x400_kswn9l.mp4',
			'video_mobile_webm_url' => 'https://res.cloudinary.com/dsb2jsgvd/video/upload/v1697220357/videos/activities/mobile/webm/kayak_tours_400x400_fbjpdq.webm'
		),
		'PageContentTranslation' => array(
			'title' => 'Kayak Tours',
			'subtitle' => 'Ponta da Piedade',
			'slug' => 'kayak-tours',
			'introduction' => 'Kayak'
		),
		'Image' => array(
			'name' => 'Kayak_final.jpg'
		),
		'TopImage' => array(
			'name' => 'Kayak_top.jpg'
		),
		'MobileTopImage' => array(
			'name' => 'Kayak_top-1697571721.jpg'
		),
		'Business' => array(
			'TOT_ID' => '168',
			'TOT' => '1'
		)
	)
)
$places = array(
	(int) 0 => array(
		'PageContent' => array(
			'id' => '261'
		),
		'PageContentTranslation' => array(
			'title' => 'Historic Center',
			'slug' => 'historic-center'
		)
	),
	(int) 1 => array(
		'PageContent' => array(
			'id' => '289'
		),
		'PageContentTranslation' => array(
			'title' => 'Urban Town',
			'slug' => 'urban-town'
		)
	),
	(int) 2 => array(
		'PageContent' => array(
			'id' => '259'
		),
		'PageContentTranslation' => array(
			'title' => 'Odiáxere',
			'slug' => 'odiaxere'
		)
	),
	(int) 3 => array(
		'PageContent' => array(
			'id' => '260'
		),
		'PageContentTranslation' => array(
			'title' => 'Luz',
			'slug' => 'luz'
		)
	)
)
$page_faqs = array(
	(int) 0 => array(
		'PageContentFaq' => array(
			'id' => '24',
			'question' => 'What are the best things to do in Lagos?',
			'answer' => 'The highlights are on the water: a boat trip to the grottos and the Benagil cave, dolphin watching, and seeing Ponta da Piedade by boat or kayak. On land, the historic old town and the street-art trail are the must-dos.',
			'faq_order' => '1'
		)
	),
	(int) 1 => array(
		'PageContentFaq' => array(
			'id' => '25',
			'question' => 'What is there to do in Lagos when it's not beach weather?',
			'answer' => 'Plenty — boat trips often run year-round, and the old town, museums, churches and the street-art walk are great in any weather. Day trips to Sagres or Silves also work well on cooler days.',
			'faq_order' => '2'
		)
	),
	(int) 2 => array(
		'PageContentFaq' => array(
			'id' => '26',
			'question' => 'What can you do in Lagos with kids?',
			'answer' => 'Dolphin watching and gentle grotto boat tours are firm family favourites, along with the beaches and easy clifftop walks. See our guide to Lagos with kids for more.',
			'faq_order' => '3'
		)
	),
	(int) 3 => array(
		'PageContentFaq' => array(
			'id' => '27',
			'question' => 'Do you need to book activities in advance?',
			'answer' => 'In July and August, yes — the popular boat and dolphin tours sell out a day or two ahead. In quieter months you can often book on the day.',
			'faq_order' => '4'
		)
	),
	(int) 4 => array(
		'PageContentFaq' => array(
			'id' => '28',
			'question' => 'What's the one thing not to miss in Lagos?',
			'answer' => 'If you do only one thing, take a small-boat trip into the grottos at Ponta da Piedade — it's the experience that defines this coast.',
			'faq_order' => '5'
		)
	)
)
$hreflangs_contents = array(
	(int) 0 => array(
		'PageContent' => array(
			'id' => '162'
		),
		'PageContentTranslation' => array(
			'slug' => 'what-to-do'
		),
		'Language' => array(
			'id' => '3',
			'code_link' => 'en',
			'default_language' => '1'
		)
	),
	(int) 1 => array(
		'PageContent' => array(
			'id' => '162'
		),
		'PageContentTranslation' => array(
			'slug' => 'o-que-fazer'
		),
		'Language' => array(
			'id' => '2',
			'code_link' => 'pt',
			'default_language' => '0'
		)
	)
)
$canonical_url_path = '/en/what-to-do'
$title_for_layout = 'Things to Do in Lagos, Algarve | Discover Lagos'
$page_type = array(
	(int) 0 => array(
		'PageContent' => array(
			'id' => '162',
			'page_type_id' => '53',
			'google_maps_latitude' => null,
			'google_maps_longitude' => null,
			'image_id' => null,
			'company_id' => null,
			'page_type_associate' => null,
			'website' => null,
			'facebook' => null,
			'instagram' => null
		),
		'PageContentTranslation' => array(
			'title' => 'What to do',
			'seo_title' => 'Things to Do in Lagos, Algarve | Discover Lagos',
			'subtitle' => 'Activities',
			'introduction' => 'Exciting activities to enjoy alone or with more persons',
			'description' => '<h2>Things to Do in Lagos: A Local's Overview</h2>
<p>Lagos packs an extraordinary amount into a small, walkable town — and the best way to plan is to think in two halves: what you do <strong>on the water</strong> and what you do <strong>on land</strong>. Between them you've got days of options, from the iconic to the quietly local. Here's how we'd frame it.</p>
<h3>On the water — the unmissable side of Lagos</h3>
<p>This coast is the reason most people come, and the sea is where Lagos shines:</p>
<ul>
<li><strong>Boat trips to the grottos and the Benagil cave</strong> — the famous sea caves and rock formations. Start with our <a href="/en/blog/benagil-cave-from-lagos">guide to visiting Benagil from Lagos</a> and our <a href="/en/blog/best-boat-tours-lagos">honest comparison of the boat tours</a>.</li>
<li><strong>Dolphin watching</strong> — wild dolphins in the Atlantic, a short fast trip offshore. See our <a href="/en/blog/dolphin-watching-lagos">dolphin watching guide</a>.</li>
<li><strong>Ponta da Piedade</strong> by boat, kayak or on foot — the headland of golden cliffs and arches. Our <a href="/en/blog/ponta-da-piedade-guide">complete Ponta da Piedade guide</a> covers all three ways to see it.</li>
<li><strong>Kayak, SUP, surfing and other watersports</strong> — from gentle paddles to your first wave. If you fancy learning to surf, read our <a href="/en/blog/surf-lessons-lagos">beginner's surf guide</a>.</li>
</ul>
<h3>On land — culture, history and easy exploring</h3>
<p>When you're off the water, the old town and its surroundings reward slow exploring: the historic centre with its walls, churches and squares; the open-air gallery of <a href="/en/urban-art">Lagos street art</a>; and easy <a href="/en/blog/day-trips-from-lagos">day trips</a> to Sagres, Silves and the west coast when you want to venture further.</p>
<h3>How to choose</h3>
<ul>
<li><strong>One day?</strong> Pair a grotto boat trip with the old town — that's the essential Lagos.</li>
<li><strong>With kids?</strong> Dolphin watching and gentle grotto tours are the usual hits.</li>
<li><strong>Active?</strong> Kayak the arches of Ponta da Piedade or take a surf lesson.</li>
<li><strong>Prefer dry land?</strong> A street-art walk and the historic centre fill a relaxed day.</li>
</ul>
<p>Not sure how to fit it together? Our guide to <a href="/en/blog/how-many-days-in-lagos">how many days to spend in Lagos</a> lays out itineraries for one to four days.</p>
<p>Browse all the activities below to see what's on offer and book directly — and as a registered local agency (RNAAT 40/2022), we're always happy to point you to the right experience.</p>',
			'slug' => 'what-to-do',
			'seo_meta_description' => 'Find watersports, boat trips and cultural tours in Lagos, Algarve - activities for every taste. Browse our guide and start planning your adventure today!',
			'seo_meta_keywords' => null
		),
		'TopImage' => array(
			'id' => '1386',
			'name' => 'people_taking_part_sustainable_travel_movement.jpg'
		),
		'Image' => array(
			'id' => null,
			'name' => null
		)
	)
)
$is_mobile = 'no'
$faq = array(
	'PageContentFaq' => array(
		'id' => '28',
		'question' => 'What's the one thing not to miss in Lagos?',
		'answer' => 'If you do only one thing, take a small-boat trip into the grottos at Ponta da Piedade — it's the experience that defines this coast.',
		'faq_order' => '5'
	)
)
$i = (int) 4
$product_type = array(
	'PageContent' => array(
		'id' => '168',
		'publish' => '1',
		'video_mp4_url' => 'https://res.cloudinary.com/dsb2jsgvd/video/upload/v1685037627/videos/activities/mp4/kayaks_3840x1714_uu7iiq.mp4',
		'video_webm_url' => 'https://res.cloudinary.com/dsb2jsgvd/video/upload/v1685037670/videos/activities/webm/kayaks_3840x1714_ij5ou0.webm',
		'video_mobile_mp4_url' => 'https://res.cloudinary.com/dsb2jsgvd/video/upload/v1697220297/videos/activities/mobile/mp4/kayak_tours_400x400_kswn9l.mp4',
		'video_mobile_webm_url' => 'https://res.cloudinary.com/dsb2jsgvd/video/upload/v1697220357/videos/activities/mobile/webm/kayak_tours_400x400_fbjpdq.webm'
	),
	'PageContentTranslation' => array(
		'title' => 'Kayak Tours',
		'subtitle' => 'Ponta da Piedade',
		'slug' => 'kayak-tours',
		'introduction' => 'Kayak'
	),
	'Image' => array(
		'name' => 'Kayak_final.jpg'
	),
	'TopImage' => array(
		'name' => 'Kayak_top.jpg'
	),
	'MobileTopImage' => array(
		'name' => 'Kayak_top-1697571721.jpg'
	),
	'Business' => array(
		'TOT_ID' => '168',
		'TOT' => '1'
	)
)
$top_video_mp4 = 'https://res.cloudinary.com/dsb2jsgvd/video/upload/v1685037627/videos/activities/mp4/kayaks_3840x1714_uu7iiq.mp4'
$top_video_webm = 'https://res.cloudinary.com/dsb2jsgvd/video/upload/v1685037670/videos/activities/webm/kayaks_3840x1714_ij5ou0.webm'
$top_image_name = 'Kayak_top.jpg'
$top_image_folder = 'top_images'
$bottom_banner_img = '/img/top_images_webp/people_taking_part_sustainable_travel_movement.jpg.webp'
include - APP/View/PageTypes/view.ctp, line 3445
View::_evaluate() - CORE/Cake/View/View.php, line 971
View::_render() - CORE/Cake/View/View.php, line 933
View::render() - CORE/Cake/View/View.php, line 473
Controller::render() - CORE/Cake/Controller/Controller.php, line 968
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 200
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 117

Discover Addons

Project Information

Filter by Location

RNAAT Registration no. 40/2022

Query	Affected	Num. rows	Took (ms)	Actions
SELECT PageContent.id 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 PageContentTranslation.slug LIKE "historic-center" AND PageContent.page_type_id = 57	1	1	1
SELECT PageType.id, PageType.order_pages, PageType.static_page, PageType.listing_page, PageType.collect_slug, PageType.booking_system, PageType.blog, PageTypeTranslation.* FROM page_types PageType INNER JOIN page_type_translations PageTypeTranslation ON PageTypeTranslation.page_type_id = PageType.id AND PageTypeTranslation.slug LIKE "what-to-do" INNER JOIN languages Language ON Language.id = PageTypeTranslation.language_code_id AND Language.code_link = "en" WHERE PageType.is_homepage = 0 AND PageType.publish = 1 AND PageType.block = 0;	0	0	1	maybe slow
SELECT PageContent.id, PageContent.page_type_id, PageContent.google_maps_latitude, PageContent.google_maps_longitude, PageContent.image_id, PageContent.company_id, PageContent.page_type_associate, PageContent.website, PageContent.facebook, PageContent.instagram, PageContentTranslation.title, PageContentTranslation.seo_title, PageContentTranslation.subtitle, PageContentTranslation.introduction, PageContentTranslation.description, PageContentTranslation.slug, PageContentTranslation.seo_meta_description, PageContentTranslation.seo_meta_keywords, TopImage.id, TopImage.name, Image.id, Image.name FROM page_contents PageContent INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id 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 INNER JOIN languages Language ON Language.code_link = "en" AND Language.id = PageContentTranslation.language_code_id AND Language.id = PageTypeTranslation.language_code_id LEFT JOIN images TopImage ON TopImage.id = PageContent.top_image_id LEFT JOIN images Image ON Image.id = PageContent.image_id WHERE PageContentTranslation.slug = "what-to-do" AND PageType.static_page = 0	1	1	3	maybe slow
SELECT PageContent.id, PageContentTranslation.slug, Language.id, Language.code_link, Language.default_language 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.publish = 1 WHERE PageContent.id = 162	2	2	1	maybe slow
SELECT PageContentFaq.id, PageContentFaq.question, PageContentFaq.answer, PageContentFaq.faq_order FROM page_content_faqs PageContentFaq INNER JOIN languages Language ON Language.id = PageContentFaq.language_code_id AND Language.code_link = "en" WHERE PageContentFaq.page_content_id = 162 ORDER BY PageContentFaq.faq_order ASC;	5	5	2	maybe slow
SELECT PageContent.id, PageContentTranslation.title, 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 = 57 AND PageContent.publish = 1 AND PageContent.group_of_pages = 0 ORDER BY PageContent.content_order ASC;	4	4	5	maybe slow
SELECT PageContent.id, PageContent.publish, PageContent.video_mp4_url, PageContent.video_webm_url, PageContent.video_mobile_mp4_url, PageContent.video_mobile_webm_url, PageContentTranslation.title, PageContentTranslation.subtitle, PageContentTranslation.slug, 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.id = PageContentTranslation.language_code_id AND Language.code_link = "en" 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 AND C.associated_select_box_id = 261 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;	1	1	9	maybe slow
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	1
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	3	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	1
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	3	maybe slow
SELECT PageContent.id, PageContentTranslation.title, 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.id = PageContentTranslation.language_code_id AND Language.code_link = "en" WHERE PageContentTranslation.slug = "historic-center"	1	1	1
SELECT PageContent.id, PageContentTranslation.id, PageContentTranslation.language_code_id, PageContentTranslation.slug FROM page_contents PageContent INNER JOIN page_content_translations PageContentTranslation ON PageContentTranslation.page_content_id = PageContent.id WHERE PageContentTranslation.slug = "what-to-do?place=historic-center"	0	0	0
SELECT PageType.id, PageTypeTranslation.id, PageTypeTranslation.language_code_id, PageTypeTranslation.slug FROM page_types PageType INNER JOIN page_type_translations PageTypeTranslation ON PageTypeTranslation.page_type_id = PageType.id WHERE PageTypeTranslation.slug = "what-to-do?place=historic-center"	0	0	0
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

Message	Memory use
Component initialization	3.83 MB
Controller action start	4.23 MB
Controller render start	5.43 MB
View render complete	6.95 MB

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	47.79
Event: Controller.initialize	1.42
Event: Controller.startup	1.41
Controller action	38.64
Event: Controller.beforeRender	38.48
» Processing toolbar data	6.73
Rendering View	14.36
» Event: View.beforeRender	0.05
» Rendering APP/View/PageTypes/view.ctp	8.84
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	4.61
» » Rendering APP/View/Elements/site_search.ctp	0.16
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/'

Things to Do in Lagos: A Local's Overview

On the water — the unmissable side of Lagos

On land — culture, history and easy exploring

How to choose

FAQ

What to do

Kayak Tours

default

Total Time: 43 ms
Total Queries: 24 queries

Query Explain:

Memory

Timers

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 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.54'
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	'ajntwDXVDoQEXBLHmGLZOAAAAAg'
Redirect Redirect Script Url	'/en/what-to-do'
Redirect Redirect Script Uri	'https://www.discoverlagos.com/en/what-to-do'
Redirect Redirect Https	'on'
Redirect Redirect Ssl Tls Sni	'www.discoverlagos.com'
Redirect Redirect Status	'200'
Redirect Unique Id	'ajntwDXVDoQEXBLHmGLZOAAAAAg'
Redirect Script Url	'/en/what-to-do'
Redirect Script Uri	'https://www.discoverlagos.com/en/what-to-do'
Redirect Http Authorization	''
Redirect Https	'on'
Redirect Ssl Tls Sni	'www.discoverlagos.com'
Redirect Status	'200'
Unique Id	'ajntwDXVDoQEXBLHmGLZOAAAAAg'
Script Url	'/en/what-to-do'
Script Uri	'https://www.discoverlagos.com/en/what-to-do'
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.54'
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	'33214'
Redirect Url	'/app/webroot/en/what-to-do'
Redirect Query String	'place=historic-center'
Server Protocol	'HTTP/1.0'
Request Method	'GET'
Query String	'place=historic-center'
Request Uri	'/en/what-to-do?place=historic-center'
Script Name	'/app/webroot/index.php'
Php Self	'/app/webroot/index.php'
Request Time Float	(float) 1782181312.7711
Request Time	(int) 1782181312

Things to Do in Lagos: A Local's Overview

On the water — the unmissable side of Lagos

On land — culture, history and easy exploring

How to choose

FAQ

What to do

Kayak Tours

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 43 ms Total Queries: 24 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 43 ms
Total Queries: 24 queries