Drinks

Bars & Drinks in Lagos: Where to Unwind

From a quiet morning coffee to a cocktail as the cliffs turn copper, Lagos has a drink for every hour and every mood — and they're rarely more than a short walk apart. The trick is matching the spot to the moment. Here's how a local reads the day.

By the moment

Coffee, the local way — a "café" (espresso) at the counter is the everyday rhythm, and far cheaper than a tourist terrace. The town is full of good cafés and pastelarias for a pastel de nata and a bica.

Sunset drinks — Lagos does golden hour beautifully. The Ponta da Piedade clifftops (free and spectacular), the marina terraces, and the Meia Praia beach bars are the classic spots to watch the light go.

Evening and beyond — wine bars, cocktail spots, beach bars, pubs and lively late-night places, mostly clustered in the walkable old town so you can wander and find your level.

The full nightlife picture

Lagos has one of the liveliest nightlife scenes on the Algarve, but it's more varied than its party reputation suggests — there's a quiet glass of wine here as easily as a big night out. For the full local rundown of where to go for each kind of evening, read our guide to Lagos nightlife, from sunset drinks to late-night bars.

If you're pairing drinks with dinner, our guide to where locals actually eat helps you find the right table first. And in the quieter months, a core of old-town bars stays open year-round — see what Lagos out of season is like.

A couple of local notes

Things start late. In summer, bars build after 22:00–23:00; arrive earlier for a calmer atmosphere.

Stay central to walk home. The old town is compact, so you can bar-hop on foot without planning transport.

Pace the sun-and-drinks combo. A beach day plus an evening out is dehydrating — drink water between.

Browse the bars, cafés and terraces below by the kind of drink and setting you're after, and let the old town do the rest.

FAQ

Where are the best bars in Lagos?

Most of the nightlife is in the walkable old town, where wine bars, cocktail spots, pubs and late-night places sit close together. For sunset, the marina terraces, Meia Praia beach bars and the Ponta da Piedade cliffs are hard to beat.

Where can I watch the sunset with a drink in Lagos?

The Ponta da Piedade clifftops (free and spectacular), the marina and waterfront terraces, and the Meia Praia beach bars are the classic sunset spots.

What time does nightlife start in Lagos?

Late — bars get going around 22:00–23:00 in summer. Earlier evenings are calmer and more relaxed, good for a quiet drink or for families.

Is there nightlife in Lagos in winter?

It's quieter off-season, but a core of old-town bars stays open year-round for a relaxed evening out.

Is Lagos nightlife family-friendly?

Early evenings are — an old-town terrace before the later crowd works well. The busiest late-night scene is better suited to adults.

Where can I get good coffee in Lagos?

The town is full of cafés and pastelarias; a "café" (espresso) at the counter is the local way, ideal with a pastel de nata, and cheaper than sitting on a tourist terrace.

x Historic Center

Just relax

Different occasions require different environments

Beach Bar

Close to the Sand

Cocktails

Daytime

Wine Bar

National & Imported

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/relax-with-a-drink',
	'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]
			)
		),
		(int) 1 => 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]
			)
		),
		(int) 2 => 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]
			)
		),
		(int) 3 => 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]
			)
		),
		(int) 5 => 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/relax-with-a-drink',
	'title_for_layout' => 'Bars & Drinks 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/relax-with-a-drink'
$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/relax-with-a-drink',
			'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/relax-with-a-drink',
			'title_for_layout' => 'Bars & Drinks 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' => '173',
			'publish' => '1',
			'video_mp4_url' => 'https://res.cloudinary.com/dsb2jsgvd/video/upload/v1685720431/videos/bars/mp4/beach_bar_3840x1714_yjoslx.mp4',
			'video_webm_url' => 'https://res.cloudinary.com/dsb2jsgvd/video/upload/v1685720459/videos/bars/webm/beach_bar_3840x1714_i5qmwe.webm',
			'video_mobile_mp4_url' => 'https://res.cloudinary.com/dsb2jsgvd/video/upload/v1697220418/videos/bars/mobile/mp4/beach_bar_400x400_cjzfpz.mp4',
			'video_mobile_webm_url' => 'https://res.cloudinary.com/dsb2jsgvd/video/upload/v1697220488/videos/bars/mobile/webm/beach_bar_400x400_cfuuoo.webm'
		),
		'PageContentTranslation' => array(
			'title' => 'Beach Bar',
			'subtitle' => 'Close to the Sand',
			'slug' => 'beach-bar',
			'introduction' => 'Beach'
		),
		'Image' => array(
			'name' => 'beach_2_final.jpg'
		),
		'TopImage' => array(
			'name' => 'beach_2_top.jpg'
		),
		'MobileTopImage' => array(
			'name' => 'beach_2_top-1697571927.jpg'
		),
		'Business' => array(
			'TOT_ID' => '173',
			'TOT' => '1'
		)
	),
	(int) 1 => array(
		'PageContent' => array(
			'id' => '175',
			'publish' => '1',
			'video_mp4_url' => 'https://res.cloudinary.com/dsb2jsgvd/video/upload/v1684952131/videos/bars/mp4/cocktails_3840x1714_hjmv1h.mp4',
			'video_webm_url' => 'https://res.cloudinary.com/dsb2jsgvd/video/upload/v1684952157/videos/bars/webm/cocktails_3840x1714_shbmqa.webm',
			'video_mobile_mp4_url' => 'https://res.cloudinary.com/dsb2jsgvd/video/upload/v1697220422/videos/bars/mobile/mp4/cocktails_400x400_ckh9ot.mp4',
			'video_mobile_webm_url' => 'https://res.cloudinary.com/dsb2jsgvd/video/upload/v1697220488/videos/bars/mobile/webm/cocktails_400x400_dnheeh.webm'
		),
		'PageContentTranslation' => array(
			'title' => 'Cocktails',
			'subtitle' => '',
			'slug' => 'cocktails',
			'introduction' => 'Cocktails'
		),
		'Image' => array(
			'name' => 'cocktails_2_final.jpg'
		),
		'TopImage' => array(
			'name' => 'cocktails_2_top.jpg'
		),
		'MobileTopImage' => array(
			'name' => 'cocktails_2_top-1697571969.jpg'
		),
		'Business' => array(
			'TOT_ID' => '175',
			'TOT' => '2'
		)
	),
	(int) 2 => array(
		'PageContent' => array(
			'id' => '179',
			'publish' => '1',
			'video_mp4_url' => 'https://res.cloudinary.com/dsb2jsgvd/video/upload/v1685125350/videos/bars/mp4/daytime_3840x1714_zedy85.mp4',
			'video_webm_url' => 'https://res.cloudinary.com/dsb2jsgvd/video/upload/v1685125378/videos/bars/webm/daytime_3840x1714_xdiswp.webm',
			'video_mobile_mp4_url' => 'https://res.cloudinary.com/dsb2jsgvd/video/upload/v1697220420/videos/bars/mobile/mp4/day_time_400x400_td2855.mp4',
			'video_mobile_webm_url' => 'https://res.cloudinary.com/dsb2jsgvd/video/upload/v1697220490/videos/bars/mobile/webm/day_time_400x400_xae5qb.webm'
		),
		'PageContentTranslation' => array(
			'title' => 'Daytime',
			'subtitle' => '',
			'slug' => 'daytime',
			'introduction' => 'Daytime'
		),
		'Image' => array(
			'name' => 'daytime_final.jpg'
		),
		'TopImage' => array(
			'name' => 'daytime_top.jpg'
		),
		'MobileTopImage' => array(
			'name' => 'daytime_top-1697572135.jpg'
		),
		'Business' => array(
			'TOT_ID' => '179',
			'TOT' => '1'
		)
	),
	(int) 3 => array(
		'PageContent' => array(
			'id' => '255',
			'publish' => '1',
			'video_mp4_url' => '',
			'video_webm_url' => '',
			'video_mobile_mp4_url' => null,
			'video_mobile_webm_url' => null
		),
		'PageContentTranslation' => array(
			'title' => 'Wine Bar',
			'subtitle' => 'National & Imported',
			'slug' => 'wine-bar',
			'introduction' => null
		),
		'Image' => array(
			'name' => 'wine_bar_main.jpg'
		),
		'TopImage' => array(
			'name' => 'wine_bar_top.jpg'
		),
		'MobileTopImage' => array(
			'name' => 'wine_bar_top-1697573383.jpg'
		),
		'Business' => array(
			'TOT_ID' => '255',
			'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' => '46',
			'question' => 'Where are the best bars in Lagos?',
			'answer' => 'Most of the nightlife is in the walkable old town, where wine bars, cocktail spots, pubs and late-night places sit close together. For sunset, the marina terraces, Meia Praia beach bars and the Ponta da Piedade cliffs are hard to beat.',
			'faq_order' => '0'
		)
	),
	(int) 1 => array(
		'PageContentFaq' => array(
			'id' => '47',
			'question' => 'Where can I watch the sunset with a drink in Lagos?',
			'answer' => 'The Ponta da Piedade clifftops (free and spectacular), the marina and waterfront terraces, and the Meia Praia beach bars are the classic sunset spots.',
			'faq_order' => '1'
		)
	),
	(int) 2 => array(
		'PageContentFaq' => array(
			'id' => '48',
			'question' => 'What time does nightlife start in Lagos?',
			'answer' => 'Late — bars get going around 22:00–23:00 in summer. Earlier evenings are calmer and more relaxed, good for a quiet drink or for families.',
			'faq_order' => '2'
		)
	),
	(int) 3 => array(
		'PageContentFaq' => array(
			'id' => '49',
			'question' => 'Is there nightlife in Lagos in winter?',
			'answer' => 'It's quieter off-season, but a core of old-town bars stays open year-round for a relaxed evening out.',
			'faq_order' => '3'
		)
	),
	(int) 4 => array(
		'PageContentFaq' => array(
			'id' => '50',
			'question' => 'Is Lagos nightlife family-friendly?',
			'answer' => 'Early evenings are — an old-town terrace before the later crowd works well. The busiest late-night scene is better suited to adults.',
			'faq_order' => '4'
		)
	),
	(int) 5 => array(
		'PageContentFaq' => array(
			'id' => '51',
			'question' => 'Where can I get good coffee in Lagos?',
			'answer' => 'The town is full of cafés and pastelarias; a "café" (espresso) at the counter is the local way, ideal with a pastel de nata, and cheaper than sitting on a tourist terrace.',
			'faq_order' => '5'
		)
	)
)
$hreflangs_contents = array(
	(int) 0 => array(
		'PageContent' => array(
			'id' => '165'
		),
		'PageContentTranslation' => array(
			'slug' => 'relax-with-a-drink'
		),
		'Language' => array(
			'id' => '3',
			'code_link' => 'en',
			'default_language' => '1'
		)
	),
	(int) 1 => array(
		'PageContent' => array(
			'id' => '165'
		),
		'PageContentTranslation' => array(
			'slug' => 'relaxar-com-uma-bebida'
		),
		'Language' => array(
			'id' => '2',
			'code_link' => 'pt',
			'default_language' => '0'
		)
	)
)
$canonical_url_path = '/en/relax-with-a-drink'
$title_for_layout = 'Bars & Drinks in Lagos, Algarve | Discover Lagos'
$page_type = array(
	(int) 0 => array(
		'PageContent' => array(
			'id' => '165',
			'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' => 'Just relax',
			'seo_title' => 'Bars & Drinks in Lagos, Algarve | Discover Lagos',
			'subtitle' => 'Drinks',
			'introduction' => 'Different occasions require different environments',
			'description' => '<h2>Bars &amp; Drinks in Lagos: Where to Unwind</h2>
<p>From a quiet morning coffee to a cocktail as the cliffs turn copper, Lagos has a drink for every hour and every mood — and they're rarely more than a short walk apart. The trick is matching the spot to the moment. Here's how a local reads the day.</p>
<h3>By the moment</h3>
<ul>
<li><strong>Coffee, the local way</strong> — a "café" (espresso) at the counter is the everyday rhythm, and far cheaper than a tourist terrace. The town is full of good cafés and pastelarias for a pastel de nata and a bica.</li>
<li><strong>Sunset drinks</strong> — Lagos does golden hour beautifully. The Ponta da Piedade clifftops (free and spectacular), the marina terraces, and the Meia Praia beach bars are the classic spots to watch the light go.</li>
<li><strong>Evening and beyond</strong> — wine bars, cocktail spots, beach bars, pubs and lively late-night places, mostly clustered in the walkable old town so you can wander and find your level.</li>
</ul>
<h3>The full nightlife picture</h3>
<p>Lagos has one of the liveliest nightlife scenes on the Algarve, but it's more varied than its party reputation suggests — there's a quiet glass of wine here as easily as a big night out. For the full local rundown of where to go for each kind of evening, read our guide to <a href="/en/blog/lagos-nightlife">Lagos nightlife, from sunset drinks to late-night bars</a>.</p>
<p>If you're pairing drinks with dinner, our guide to <a href="/en/blog/where-locals-eat-lagos">where locals actually eat</a> helps you find the right table first. And in the quieter months, a core of old-town bars stays open year-round — see what <a href="/en/blog/lagos-in-winter">Lagos out of season</a> is like.</p>
<h3>A couple of local notes</h3>
<ul>
<li><strong>Things start late.</strong> In summer, bars build after 22:00–23:00; arrive earlier for a calmer atmosphere.</li>
<li><strong>Stay central to walk home.</strong> The old town is compact, so you can bar-hop on foot without planning transport.</li>
<li><strong>Pace the sun-and-drinks combo.</strong> A beach day plus an evening out is dehydrating — drink water between.</li>
</ul>
<p>Browse the bars, cafés and terraces below by the kind of drink and setting you're after, and let the old town do the rest.</p>',
			'slug' => 'relax-with-a-drink',
			'seo_meta_description' => 'Unwind with a drink at the best bars, cafes and rooftop terraces in Lagos, Algarve. Browse our guide and find your perfect spot for tonight!',
			'seo_meta_keywords' => null
		),
		'TopImage' => array(
			'id' => '1388',
			'name' => 'top_view_mix_alcohol_bottles.jpg'
		),
		'Image' => array(
			'id' => null,
			'name' => null
		)
	)
)
$is_mobile = 'no'
$faq = array(
	'PageContentFaq' => array(
		'id' => '51',
		'question' => 'Where can I get good coffee in Lagos?',
		'answer' => 'The town is full of cafés and pastelarias; a "café" (espresso) at the counter is the local way, ideal with a pastel de nata, and cheaper than sitting on a tourist terrace.',
		'faq_order' => '5'
	)
)
$i = (int) 4
$product_type = array(
	'PageContent' => array(
		'id' => '255',
		'publish' => '1',
		'video_mp4_url' => '',
		'video_webm_url' => '',
		'video_mobile_mp4_url' => null,
		'video_mobile_webm_url' => null
	),
	'PageContentTranslation' => array(
		'title' => 'Wine Bar',
		'subtitle' => 'National & Imported',
		'slug' => 'wine-bar',
		'introduction' => null
	),
	'Image' => array(
		'name' => 'wine_bar_main.jpg'
	),
	'TopImage' => array(
		'name' => 'wine_bar_top.jpg'
	),
	'MobileTopImage' => array(
		'name' => 'wine_bar_top-1697573383.jpg'
	),
	'Business' => array(
		'TOT_ID' => '255',
		'TOT' => '1'
	)
)
$top_video_mp4 = ''
$top_video_webm = ''
$top_image_name = 'wine_bar_top.jpg'
$top_image_folder = 'top_images'
$bottom_banner_img = '/img/top_images_webp/top_view_mix_alcohol_bottles.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	2	maybe slow
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 "relax-with-a-drink" 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	2	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 = "relax-with-a-drink" AND PageType.static_page = 0	1	1	4	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 = 165	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 = 165 ORDER BY PageContentFaq.faq_order ASC;	6	6	1	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	7	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 = 165 ORDER BY PageContent.content_order ASC;	4	4	15	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	5
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	6	maybe slow
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 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 = "relax-with-a-drink?place=historic-center"	0	0	1	maybe slow
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 = "relax-with-a-drink?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.44 MB
View render complete	6.98 MB

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	54.12
Event: Controller.initialize	1.84
Event: Controller.startup	1.59
Controller action	54.98
Event: Controller.beforeRender	43.94
» Processing toolbar data	10.64
Rendering View	10.02
» Event: View.beforeRender	0.03
» Rendering APP/View/PageTypes/view.ctp	6.28
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/default.ctp	2.98
» » 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/'

Bars & Drinks in Lagos: Where to Unwind

By the moment

The full nightlife picture

A couple of local notes

FAQ

Just relax

Beach Bar

Cocktails

Daytime

Wine Bar

default

Total Time: 58 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	'ajnuQg2txvCDlVbVJ7VrOwAAAAA'
Redirect Redirect Script Url	'/en/relax-with-a-drink'
Redirect Redirect Script Uri	'https://www.discoverlagos.com/en/relax-with-a-drink'
Redirect Redirect Https	'on'
Redirect Redirect Ssl Tls Sni	'www.discoverlagos.com'
Redirect Redirect Status	'200'
Redirect Unique Id	'ajnuQg2txvCDlVbVJ7VrOwAAAAA'
Redirect Script Url	'/en/relax-with-a-drink'
Redirect Script Uri	'https://www.discoverlagos.com/en/relax-with-a-drink'
Redirect Http Authorization	''
Redirect Https	'on'
Redirect Ssl Tls Sni	'www.discoverlagos.com'
Redirect Status	'200'
Unique Id	'ajnuQg2txvCDlVbVJ7VrOwAAAAA'
Script Url	'/en/relax-with-a-drink'
Script Uri	'https://www.discoverlagos.com/en/relax-with-a-drink'
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	'50080'
Redirect Url	'/app/webroot/en/relax-with-a-drink'
Redirect Query String	'place=historic-center'
Server Protocol	'HTTP/1.0'
Request Method	'GET'
Query String	'place=historic-center'
Request Uri	'/en/relax-with-a-drink?place=historic-center'
Script Name	'/app/webroot/index.php'
Php Self	'/app/webroot/index.php'
Request Time Float	(float) 1782181443.3755
Request Time	(int) 1782181443

Bars & Drinks in Lagos: Where to Unwind

By the moment

The full nightlife picture

A couple of local notes

FAQ

Just relax

Beach Bar

Cocktails

Daytime

Wine Bar

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 58 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: 58 ms
Total Queries: 24 queries