Find Nightclubs in Tenby - Opening Times & Reviews

Messages Timeline Exceptions Views272 Route Queries81 Models443 Livewire62 Mails Gate Session Request

Request history8.2.281.44s8MBGET {route}

Booting (9.03ms)time
Application (1.43s)time
1 x Application (99.37%)
1.43s
1 x Booting (0.63%)
9.03ms

272 templates were rendered

1x pages.city-categorycity-category.blade.php#?blade
1x livewire.topbartopbar.blade.php#?blade
1x components.login-buttonlogin-button.blade.php#?blade
1x components.partials.hero-v2.defaultdefault.blade.php#?blade
1x livewire.partials.top-ratedtop-rated.blade.php#?blade
5x livewire.partials.cards.card-chainratingcard-chainrating.blade.php#?blade
15x livewire.partials.cards.card-chainrating-blockcard-chainrating-block.blade.php#?blade
15x components.common.reviews.starsstars.blade.php#?blade
1x livewire.partials.join-usjoin-us.blade.php#?blade
1x livewire.partials.city-guidescity-guides.blade.php#?blade
1x livewire.breadcrumbsbreadcrumbs.blade.php#?blade
1x components.partials.footerfooter.blade.php#?blade
1x livewire.search.search-resultssearch-results.blade.php#?blade
1x livewire.search.search-aroundsearch-around.blade.php#?blade
61x components.img-responsiveimg-responsive.blade.php#?blade
4x livewire.sidebar.cards.areaarea.blade.php#?blade
10x livewire.sidebar.cards.categorycategory.blade.php#?blade
1x static.template-parts.modal.modal-locationmodal-location.blade.php#?blade
1x components.maps.mapsmaps.blade.php#?blade
1x components.maps.staticstatic.blade.php#?blade
2x livewire.sidebar.blocks.locationslocations.blade.php#?blade
60x components.sidebar.cards.storestore.blade.php#?blade
60x components.partials.location.open-closedopen-closed.blade.php#?blade
1x layouts.mainmain.blade.php#?blade
1x meta.google-analyticsgoogle-analytics.blade.php#?blade
1x components.sidebar.headerheader.blade.php#?blade
2x livewire.search.searchsearch.blade.php#?blade
1x components.sidebar.sidebarsidebar.blade.php#?blade
2x livewire.filter.filterfilter.blade.php#?blade
2x livewire.filter.slide-inslide-in.blade.php#?blade
4x livewire.location.location-autocompletelocation-autocomplete.blade.php#?blade
1x livewire.sidebar.navigationnavigation.blade.php#?blade
1x livewire.modal.locationlocation.blade.php#?blade
1x components.sidebar.locationlocation.blade.php#?blade
1x livewire.common.local-barlocal-bar.blade.php#?blade
1x components.modal.loginlogin.blade.php#?blade
1x livewire.auth.signupsignup.blade.php#?blade
1x livewire.auth.loginlogin.blade.php#?blade
1x livewire.auth.onboardingonboarding.blade.php#?blade
1x livewire.auth.registerregister.blade.php#?blade
1x livewire.auth.forgot-passwordforgot-password.blade.php#?blade
1x livewire.auth.delete-accountdelete-account.blade.php#?blade
1x meta.yext-scriptyext-script.blade.php#?blade

uri: GET {route}
middleware: web
uses: App\Http\Controllers\DynamicRouteControllerDispatcher@__invoke
controller: App\Http\Controllers\DynamicRouteControllerDispatcher
namespace
prefix
where

80 statements were executed (10 duplicates)Show only duplicates1.04s

Connection Establishedhours_frontendDynamicRouteControllerDispatcher.php#39
Backtrace
select * from `routes` where `route` = 'Carmarthenshire/Tenby/Nightclubs' limit 1
2.81mshours_frontendDynamicRouteControllerDispatcher.php#39
Bindings
Backtrace
update `routes` set `visit_count` = `visit_count` + 1, `routes`.`updated_at` = '2025-03-14 06:43:54' where `id` = 76444262
540μshours_frontendDynamicRouteControllerDispatcher.php#43
Bindings
Backtrace
select * from `establishments` where `slug` = 'Carmarthenshire/Tenby/Nightclubs' and `establishments`.`deleted_at` is null limit 1
990μshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `regions` where `slug` = 'Carmarthenshire/Tenby/Nightclubs' limit 1
850μshours_frontendDynamicRouteControllerDispatcher.php#111
Bindings
Backtrace
select * from `categories` where `slug` = 'Carmarthenshire/Tenby/Nightclubs' limit 1
780μshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `slug` = 'Carmarthenshire/Tenby/Nightclubs' limit 1
750μshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `attributes` where `slug` = 'Carmarthenshire/Tenby/Nightclubs' limit 1
730μshours_frontendDynamicRouteControllerDispatcher.php#111
Bindings
Backtrace
select * from `categories` where `slug` = 'Nightclubs' limit 1
740μshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `regions` where `slug` = 'Carmarthenshire/Tenby' and `type` = 'locality' limit 1
810μshours_frontendDynamicRouteControllerDispatcher.php#195
Bindings
Backtrace
select * from `regions` where `regions`.`id` = 101852995 and `type` = 'locality' limit 1
1.25mshours_frontendTopbar.php#66
Bindings
Backtrace
select count(*) as aggregate from `regions` where `regions`.`locality_id` = 101852995 and `regions`.`locality_id` is not null and `type` = 'neighbourhood'
1.92mshours_frontendTopbar.php#78
Bindings
Backtrace
select count(*) as aggregate from `attributes` where `attributes`.`locality_id` = 101852995 and `attributes`.`locality_id` is not null and `subtype` = 'uk shopping area'
1.18mshours_frontendTopbar.php#84
Bindings
Backtrace
select count(*) as aggregate from `attributes` where `attributes`.`locality_id` = 101852995 and `attributes`.`locality_id` is not null and `subtype` = 'uk shopping street'
930μshours_frontendTopbar.php#90
Bindings
Backtrace
select `slug`, `path`, `static_text`, `text` from `lang_slug` left join `lang_text` on `lang_slug_id` = `lang_slug`.`id` order by `lang_slug`.`id` desc
161mshours_frontendTranslations.php#17
Backtrace
select `establishments`.*, (select count(*) from `reviews` where `establishments`.`hash` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null) as `reviews_count` from `establishments` where `establishments`.`locality_id` = 101852995 and `establishments`.`locality_id` is not null and exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and exists (select * from `categories` where `businesses`.`category_id` = `categories`.`id` and `name` = 'Nightclubs')) and `establishments`.`deleted_at` is null limit 3
30.93mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select `establishments`.*, (select count(*) from `reviews` where `establishments`.`hash` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null) as `reviews_count`, establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('-4.70229300', '51.66379200')) AS distance from `establishments` where exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and exists (select * from `categories` where `businesses`.`category_id` = `categories`.`id` and `name` = 'Nightclubs')) and 1 = 1 and `establishments`.`deleted_at` is null order by `distance` asc limit 3
55.77mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (1256000, 1256452, 1256652)
3.64mshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select * from `categories` where `categories`.`id` in (100327)
3.01mshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select `establishments`.*, (select count(*) from `reviews` where `establishments`.`hash` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null) as `reviews_count` from `establishments` where `establishments`.`locality_id` = 101852995 and `establishments`.`locality_id` is not null and exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and exists (select * from `categories` where `businesses`.`category_id` = `categories`.`id` and `name` = 'Clothing')) and `establishments`.`deleted_at` is null limit 3
19.36mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select `establishments`.*, (select count(*) from `reviews` where `establishments`.`hash` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null) as `reviews_count`, establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('-4.70229300', '51.66379200')) AS distance from `establishments` where exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and exists (select * from `categories` where `businesses`.`category_id` = `categories`.`id` and `name` = 'Clothing')) and 1 = 1 and `establishments`.`deleted_at` is null order by `distance` asc limit 3
13.85mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select `establishments`.*, (select count(*) from `reviews` where `establishments`.`hash` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null) as `reviews_count` from `establishments` where `establishments`.`locality_id` = 101852995 and `establishments`.`locality_id` is not null and exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and exists (select * from `categories` where `businesses`.`category_id` = `categories`.`id` and `name` = 'Supermarkets')) and `establishments`.`deleted_at` is null limit 3
28.98mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (892975, 892994, 893004)
780μshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select * from `categories` where `categories`.`id` in (100450)
610μshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select `establishments`.*, (select count(*) from `reviews` where `establishments`.`hash` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null) as `reviews_count` from `establishments` where `establishments`.`locality_id` = 101852995 and `establishments`.`locality_id` is not null and exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and exists (select * from `categories` where `businesses`.`category_id` = `categories`.`id` and `name` = 'Restaurants')) and `establishments`.`deleted_at` is null limit 3
43.5mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (892973)
610μshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select * from `categories` where `categories`.`id` in (100394)
610μshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select `establishments`.*, (select count(*) from `reviews` where `establishments`.`hash` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null) as `reviews_count`, establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('-4.70229300', '51.66379200')) AS distance from `establishments` where exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and exists (select * from `categories` where `businesses`.`category_id` = `categories`.`id` and `name` = 'Restaurants')) and `id` not in (962355) and `establishments`.`deleted_at` is null order by `distance` asc limit 2
303mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (892973, 893798)
580μshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select * from `categories` where `categories`.`id` in (100394)
690μshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select `establishments`.*, (select count(*) from `reviews` where `establishments`.`hash` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null) as `reviews_count` from `establishments` where `establishments`.`locality_id` = 101852995 and `establishments`.`locality_id` is not null and exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and exists (select * from `categories` where `businesses`.`category_id` = `categories`.`id` and `name` = 'Hotels')) and `establishments`.`deleted_at` is null limit 3
22.42mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (1222995)
670μshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select * from `categories` where `categories`.`id` in (100209)
550μshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select `establishments`.*, (select count(*) from `reviews` where `establishments`.`hash` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null) as `reviews_count`, establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('-4.70229300', '51.66379200')) AS distance from `establishments` where exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and exists (select * from `categories` where `businesses`.`category_id` = `categories`.`id` and `name` = 'Hotels')) and `id` not in (2217718) and `establishments`.`deleted_at` is null order by `distance` asc limit 2
104mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (1256193, 1844103)
1.31mshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select * from `categories` where `categories`.`id` in (100209)
440μshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select `establishments`.*, (select count(*) from `reviews` where `establishments`.`hash` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null) as `reviews_count` from `establishments` where `establishments`.`locality_id` = 101852995 and `establishments`.`locality_id` is not null and exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and exists (select * from `categories` where `businesses`.`category_id` = `categories`.`id` and `name` = 'DIY Stores')) and `establishments`.`deleted_at` is null limit 3
28.22mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (892998, 893619)
780μshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select * from `categories` where `categories`.`id` in (100076)
530μshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select `establishments`.*, (select count(*) from `reviews` where `establishments`.`hash` = `reviews`.`reviewable_id` and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null) as `reviews_count`, establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('-4.70229300', '51.66379200')) AS distance from `establishments` where exists (select * from `businesses` where `establishments`.`business_id` = `businesses`.`id` and exists (select * from `categories` where `businesses`.`category_id` = `categories`.`id` and `name` = 'DIY Stores')) and `id` not in (919803, 935303) and `establishments`.`deleted_at` is null order by `distance` asc limit 1
59.69mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (893000)
820μshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select * from `categories` where `categories`.`id` in (100076)
460μshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point(-0.13184, 51.50532)) AS distance, `businesses`.`category_id` as `laravel_through_key` from `establishments` inner join `businesses` on `businesses`.`id` = `establishments`.`business_id` where `businesses`.`category_id` = 100327 and `establishments`.`deleted_at` is null order by `distance` asc limit 6
15.52mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select *, ST_Distance_Sphere(point(longitude, latitude), point(-0.13184, 51.50532)) AS distance from `regions` where `type` = 'locality' order by `distance` asc limit 1
6.78mshours_frontendUserLocation.php#51
Bindings
Backtrace
select *, ST_Distance_Sphere(point(longitude, latitude), point(-0.13184, 51.50532)) AS distance from `regions` where `type` = 'neighbourhood' order by `distance` asc limit 1
3.25mshours_frontendUserLocation.php#65
Bindings
Backtrace
select *, ST_Distance_Sphere(point(longitude, latitude), point(-0.13184, 51.50532)) AS distance from `attributes` where `subtype` = 'uk shopping area' order by `distance` asc limit 2
1.41mshours_frontendUserLocation.php#78
Bindings
Backtrace
select * from `static_maps` where (`longitude` = '-4.70229300' and `latitude` = '51.66379200' and `height` = 1200 and `width` = 1200) limit 1
850μshours_frontendStaticMap.php#28
Bindings
Backtrace
select establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('-4.70229300', '51.66379200')) AS distance, `businesses`.`category_id` as `laravel_through_key` from `establishments` inner join `businesses` on `businesses`.`id` = `establishments`.`business_id` where `businesses`.`category_id` = 100327 and `establishments`.`deleted_at` is null order by `distance` asc limit 90
43.98mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (1247157, 1255446, 1255461, 1255463, 1255493, 1255548, 1255600, 1255604, 1255613, 1255632, 1255643, 1255649, 1255674, 1255703, 1255750, 1255751, 1255758, 1255802, 1255814, 1255837, 1255898, 1255908, 1255924, 1255926, 1255941, 1255957, 1255964, 1255967, 1255984, 1255998, 1256000, 1256012, 1256016, 1256037, 1256056, 1256092, 1256097, 1256100, 1256110, 1256124, 1256129, 1256132, 1256141, 1256148, 1256171, 1256207, 1256211, 1256239, 1256258, 1256259, 1256265, 1256283, 1256291, 1256293, 1256299, 1256333, 1256348, 1256368, 1256382, 1256387, 1256402, 1256438, 1256452, 1256485, 1256487, 1256512, 1256531, 1256572, 1256578, 1256590, 1256616, 1256643, 1256652, 1256663, 1256666, 1256682, 1256683, 1256685, 1256753, 1256759, 1256787, 1256795, 1256816, 1256858, 1256913, 1280228, 1280236, 1280242, 1820144, 1820150)
2.63mshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2260343 and `establishment_departments`.`establishment_id` is not null
640μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2260125 and `establishment_departments`.`establishment_id` is not null
670μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2259556 and `establishment_departments`.`establishment_id` is not null
720μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2259603 and `establishment_departments`.`establishment_id` is not null
730μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2259910 and `establishment_departments`.`establishment_id` is not null
770μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2259891 and `establishment_departments`.`establishment_id` is not null
2.68mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2259953 and `establishment_departments`.`establishment_id` is not null
1.11mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2260078 and `establishment_departments`.`establishment_id` is not null
710μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2260161 and `establishment_departments`.`establishment_id` is not null
710μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2259766 and `establishment_departments`.`establishment_id` is not null
2.26mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2259232 and `establishment_departments`.`establishment_id` is not null
2.54mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2259458 and `establishment_departments`.`establishment_id` is not null
1.06mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2259158 and `establishment_departments`.`establishment_id` is not null
720μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2259818 and `establishment_departments`.`establishment_id` is not null
640μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2260512 and `establishment_departments`.`establishment_id` is not null
690μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2259912 and `establishment_departments`.`establishment_id` is not null
680μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2259759 and `establishment_departments`.`establishment_id` is not null
680μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2259518 and `establishment_departments`.`establishment_id` is not null
730μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 3162544 and `establishment_departments`.`establishment_id` is not null
770μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2259772 and `establishment_departments`.`establishment_id` is not null
660μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2259792 and `establishment_departments`.`establishment_id` is not null
720μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2259568 and `establishment_departments`.`establishment_id` is not null
730μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2260652 and `establishment_departments`.`establishment_id` is not null
700μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2260016 and `establishment_departments`.`establishment_id` is not null
580μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2291430 and `establishment_departments`.`establishment_id` is not null
710μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 3173888 and `establishment_departments`.`establishment_id` is not null
640μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2259505 and `establishment_departments`.`establishment_id` is not null
780μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2259789 and `establishment_departments`.`establishment_id` is not null
610μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2259855 and `establishment_departments`.`establishment_id` is not null
550μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2260327 and `establishment_departments`.`establishment_id` is not null
610μshours_frontendHasHours.php#36
Bindings
Backtrace
select establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('-4.70229300', '51.66379200')) AS distance, `businesses`.`category_id` as `laravel_through_key` from `establishments` inner join `businesses` on `businesses`.`id` = `establishments`.`business_id` where `businesses`.`category_id` = 100327 and `establishments`.`deleted_at` is null order by `distance` asc limit 90
39.11mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (1247157, 1255446, 1255461, 1255463, 1255493, 1255548, 1255600, 1255604, 1255613, 1255632, 1255643, 1255649, 1255674, 1255703, 1255750, 1255751, 1255758, 1255802, 1255814, 1255837, 1255898, 1255908, 1255924, 1255926, 1255941, 1255957, 1255964, 1255967, 1255984, 1255998, 1256000, 1256012, 1256016, 1256037, 1256056, 1256092, 1256097, 1256100, 1256110, 1256124, 1256129, 1256132, 1256141, 1256148, 1256171, 1256207, 1256211, 1256239, 1256258, 1256259, 1256265, 1256283, 1256291, 1256293, 1256299, 1256333, 1256348, 1256368, 1256382, 1256387, 1256402, 1256438, 1256452, 1256485, 1256487, 1256512, 1256531, 1256572, 1256578, 1256590, 1256616, 1256643, 1256652, 1256663, 1256666, 1256682, 1256683, 1256685, 1256753, 1256759, 1256787, 1256795, 1256816, 1256858, 1256913, 1280228, 1280236, 1280242, 1820144, 1820150)
2.26mshours_frontendBuildsGroupLimitQueries.php#38
Backtrace

App\Models\Establishment: 201Establishment.php#?
App\Models\Business: 195Business.php#?
App\Models\EstablishmentDepartment: 30EstablishmentDepartment.php#?
App\Models\Category: 9Category.php#?
App\Models\Region: 4Region.php#?
App\Models\Attribute: 2Attribute.php#?
App\Models\Route: 1Route.php#?
App\Models\StaticMap: 1StaticMap.php#?

topbar #IUqpSPOLm6Agg7mSL3AJ: array:4 [ "data" => array:4 [ "user" => null "parent" => App\Models\Region {#1877 #c...
partials.top-rated #tgpWdOhEb2Ze297Q1yVv: array:4 [ "data" => array:5 [ "title" => "Best-reviewed Nightclub in Tenby" "description" ...
partials.cards.card-chainrating #iWciAgWT0xmH0A6YPsHZ: array:4 [ "data" => array:3 [ "headingText" => "Best in Nightclubs" "blocks" => Illuminat...
partials.cards.card-chainrating-block #l111EMLhEcQb5R6rxzJ2: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#9005 #connec...
partials.cards.card-chainrating-block #06fWtJJ5P4ymS36DJY8O: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#9002 #connec...
partials.cards.card-chainrating-block #VDtfIkhCQ5SMK1zddMI8: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#9001 #connec...
partials.cards.card-chainrating #34dcJZ0MAVyZOhr48pci: array:4 [ "data" => array:3 [ "headingText" => "Best in Supermarkets" "blocks" => Illumin...
partials.cards.card-chainrating-block #vSPF3lfiQDhd4TUJ67gN: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8847 #connec...
partials.cards.card-chainrating-block #JzRuBmfdnpssS41NIZiS: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8848 #connec...
partials.cards.card-chainrating-block #B36UH1kYQFhiF9vm1vGN: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8849 #connec...
partials.cards.card-chainrating #fmPc0t1eUcUka5wMzeom: array:4 [ "data" => array:3 [ "headingText" => "Best in Restaurants" "blocks" => Illumina...
partials.cards.card-chainrating-block #9tnLek3zY9MP0D9gMesQ: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8791 #connec...
partials.cards.card-chainrating-block #u8TTV4C82QfikZU34Ad6: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8735 #connec...
partials.cards.card-chainrating-block #Qy1VRB9uZI9CP5gAIgWD: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8736 #connec...
partials.cards.card-chainrating #aNd1IpMzDSpjR9JK52SY: array:4 [ "data" => array:3 [ "headingText" => "Best in Hotels" "blocks" => Illuminate\Da...
partials.cards.card-chainrating-block #qv5LCx5CkkXLbCC6WsCy: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8681 #connec...
partials.cards.card-chainrating-block #JGPsHTeqYzQIDpxRog3V: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8625 #connec...
partials.cards.card-chainrating-block #sJJXWlGLqNP3Wlke6v4i: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8626 #connec...
partials.cards.card-chainrating #dYp1cMj0HRUdV2YRbJLh: array:4 [ "data" => array:3 [ "headingText" => "Best in DIY Stores" "blocks" => Illuminat...
partials.cards.card-chainrating-block #jSR5ImDZfBYOGJ4Vrkv8: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8570 #connec...
partials.cards.card-chainrating-block #mCsm9t5AMZ4vIoAB2olQ: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8571 #connec...
partials.cards.card-chainrating-block #0OfD9arGUjd3bGK9JCMe: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8514 #connec...
partials.join-us #wJvvMCJXUL6jkfcs1fL2: array:4 [ "data" => array:1 [ "cityName" => "Tenby" ] "name" => "partials.join-us" "comp...
partials.city-guides #klc80EbJ1nZRaoEhXRXh: array:4 [ "data" => array:2 [ "scrollable" => null "locations" => Illuminate\Database\Eloq...
breadcrumbs #Nzfz20f2brxyFeA38PX4: array:4 [ "data" => array:3 [ "parent" => App\Models\Region {#1877 #connection: "mysql" ...
search-results #HhhMVSsaYJPJzNKp4wUu: array:4 [ "data" => array:6 [ "search" => "" "results" => [] "searchOverlayActive" => ...
partials.search-around #o5YlBGN7AKgn9VFrCCui: array:4 [ "data" => array:1 [ "userLocation" => array:4 [ "longitude" => -0.13184 ...
sidebar.cards.area #XF7z9Mq4KPab7lzYQUDK: array:4 [ "data" => array:1 [ "area" => App\Models\Region {#7224 #connection: "mysql" ...
sidebar.cards.area #fu1fyZI1iF37wkmxoxqC: array:4 [ "data" => array:1 [ "area" => App\Models\Region {#7154 #connection: "mysql" ...
sidebar.cards.area #zlH1D8TsNCD98TDDVtcW: array:4 [ "data" => array:1 [ "area" => App\Models\Attribute {#7269 #connection: "mysql"...
sidebar.cards.area #d5wn1uu5nrBz9vM9DniJ: array:4 [ "data" => array:1 [ "area" => App\Models\Attribute {#7276 #connection: "mysql"...
sidebar.cards.category #xmsrLpsNmpEHWdUu9V0Z: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#7159 #connection: "mys...
sidebar.cards.category #0Zk4ohsuggb3Grm4nKcM: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#7051 #connection: "mys...
sidebar.cards.category #OzCl0YjgmJJ8qAVcK04U: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#7150 #connection: "mys...
sidebar.cards.category #BLdixsP5Z2IItURdSJfv: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#7143 #connection: "mys...
sidebar.cards.category #MDus6BE6FkqtjDhUG0RU: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#6888 #connection: "mys...
sidebar.cards.category #Z2XGNcfvr2fHKtYLCry9: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#6887 #connection: "mys...
sidebar.cards.category #t1gNUKy6c4l2QAjdT3fc: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#6886 #connection: "mys...
sidebar.cards.category #YS1My3xLJrxohpg2VBEt: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#6885 #connection: "mys...
sidebar.cards.category #ZL4SV5xSCfCYLU5olAzt: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#6884 #connection: "mys...
sidebar.cards.category #CCPdighiX2KiJ55LfGjU: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#6883 #connection: "mys...
sidebar.blocks.locations #ZbHzm1QVdLKMDa9jrNrV: array:4 [ "data" => array:16 [ "locations" => null "current_id" => null "heading" => "...
sidebar.blocks.locations #m1h52GIHfRoff8IPNxhS: array:4 [ "data" => array:16 [ "locations" => null "current_id" => null "heading" => "...
search #B13cjFRLn3hAbZKKpQqD: array:4 [ "data" => array:1 [ "search" => "" ] "name" => "search" "component" => "App\Li...
search #howeBC7zZVGvhq6rZtmz: array:4 [ "data" => array:1 [ "search" => "" ] "name" => "search" "component" => "App\Li...
filter.filter #qBDIqSsMa8jK3nIw8Fot: array:4 [ "data" => array:5 [ "hours" => 0 "filtersAreNotEmpty" => false "showFilter" ...
filter.slide-in #c4ugP2V8leXW8EX7tSnF: array:4 [ "data" => array:8 [ "openFrom" => "" "openTo" => "" "dayRange" => "today" ...
location.location-autocomplete #mHhUJpGOjzYxsUOs7J8C: array:4 [ "data" => array:5 [ "initialLocation" => "London, E1 8RU" "location" => "London,...
sidebar.navigation #ZwWOhxEvcaTnjjbHKbW2: array:4 [ "data" => [] "name" => "sidebar.navigation" "component" => "App\Livewire\Sidebar\Nav...
modal.location #X1XY4jZqfQo7aCyWOAaF: array:4 [ "data" => array:2 [ "classes" => [] "showModal" => false ] "name" => "modal....
location.location-autocomplete #VO8596u3vUQEdHXK42Vy: array:4 [ "data" => array:5 [ "initialLocation" => "London, E1 8RU" "location" => "London,...
filter.filter #GUqx3DyyrzJQ8EVvgI3I: array:4 [ "data" => array:5 [ "hours" => 0 "filtersAreNotEmpty" => false "showFilter" ...
filter.slide-in #cKR85fxhpCEcN2iIrzTT: array:4 [ "data" => array:8 [ "openFrom" => "" "openTo" => "" "dayRange" => "today" ...
location.location-autocomplete #mh4FuIkWNUONCm5UtSZs: array:4 [ "data" => array:5 [ "initialLocation" => "London, E1 8RU" "location" => "London,...
common.local-bar #Jn022alVCp9TfsrZENz2: array:4 [ "data" => [] "name" => "common.local-bar" "component" => "App\Livewire\Common\LocalB...
auth.signup #doCzfCNAlryBblzfoRb0: array:4 [ "data" => [] "name" => "auth.signup" "component" => "App\Livewire\Auth\Signup" "id...
auth.login #xHgTt8CEbMwRClRJ21a6: array:4 [ "data" => array:3 [ "email" => null "password" => null "class" => "" ] "...
auth.onboarding #Wz2foXMszeolO3l6WoMC: array:4 [ "data" => array:6 [ "name" => null "classes" => [] "localities" => null ...
location.location-autocomplete #6MKQydDuwL58ypaMAFSy: array:4 [ "data" => array:5 [ "initialLocation" => "London, E1 8RU" "location" => "London,...
auth.register #SvhfoJaTEFbStp1yHFO6: array:4 [ "data" => array:3 [ "email" => null "password" => null "class" => "" ] "...
auth.forgot-password #19D2CwOpOuM4jUmmCCTj: array:4 [ "data" => array:3 [ "email" => "" "class" => "" "successMessage" => null ]...
auth.delete-account #L062RFACsm5VVKiTJ2Hv: array:4 [ "data" => [] "name" => "auth.delete-account" "component" => "App\Livewire\Auth\Delet...

_token: c0tNIzyeRND8gLUqc1GodjIrxNKCwsxS3o8XSsjS
parent_page: pages.city-category
url: array:1 [ "intended" => "https://alpha.hours.com/Carmarthenshire/Tenby/Nightclubs" ]
_previous: array:1 [ "url" => "https://alpha.hours.com/Carmarthenshire/Tenby/Nightclubs" ]
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/Carmarthenshire/Tenby/Nightclubs

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:15 [▼
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "host" => array:1 [▶
    0 => "alpha.hours.com"
  ]
]

request_cookies

[]

response_headers

  0 of 0   
array:7 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "max-age=0, must-revalidate, no-cache, no-store, private"
  ]
  "date" => array:1 [▶
    0 => "Fri, 14 Mar 2025 06:43:54 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "Fri, 01 Jan 1990 00:00:00 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlNzNTlib1B3NEYrWVJYaUs2K1huMFE9PSIsInZhbHVlIjoiVjljaUFlRlJrQURtZ0xYY2tiRU5qSElhQzlvQVhpMWhNQmFnc29NY2JtWlpNTFBtbC9PcnRtcGdSK05sRlZISHI3NUdXYzR3bkg4UGpaaGdhZERQUG9SWXZuVWJvWUVENEVjY3dlS0s4WXJHQmx1dHU5TE1Tc2ZxNjAwY0xqa24iLCJtYWMiOiJjNTY0NDA2MmY1NTQyYmU4ZTZjZmMzYWI1NThhY2RkNTFiZTBiZGYwZDk5YWIzZGY1NjFlN2I5OWY1MTg2MjM2IiwidGFnIjoiIn0%3D; expires=Fri, 14 Mar 2025 08:43:56 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IlNzNTlib1B3NEYrWVJYaUs2K1huMFE9PSIsInZhbHVlIjoiVjljaUFlRlJrQURtZ0xYY2tiRU5qSElhQzlvQVhpMWhNQmFnc29NY2JtWlpNTFBtbC9PcnRtcGdSK05sRlZISHI3NUdXY ▶"
    1 => "hours_frontend_session=eyJpdiI6IktDVDM2cVNsMklpUS82UzJnTW9WSXc9PSIsInZhbHVlIjoiR2xPRnlUUzZZWnBiV2pzT1ROeFF6aFpMWExvTkxqYVpoRVhrMGlYUmFjSi9LWVAzMG1IUFFBMFJUWEg1aXBHaFBYclhPbzBsOWJlOVh5MHAwSFNXQ2FucG5NeWxjK3RsMnZTdGc0b1dPWWNpSWRUczA1UG5FbWRMZXVnamhjeEMiLCJtYWMiOiIwNDY3YmMyMWY4Yjc3YzcyYjY2YTg5YWI2YzNkMjA5YTFjNGFiNWVjNmU4ZGZiYWU0MDM1ODNjZjljNzcwOTBkIiwidGFnIjoiIn0%3D; expires=Fri, 14 Mar 2025 08:43:56 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀hours_frontend_session=eyJpdiI6IktDVDM2cVNsMklpUS82UzJnTW9WSXc9PSIsInZhbHVlIjoiR2xPRnlUUzZZWnBiV2pzT1ROeFF6aFpMWExvTkxqYVpoRVhrMGlYUmFjSi9LWVAzMG1IUFFBMFJUWEg1a ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlNzNTlib1B3NEYrWVJYaUs2K1huMFE9PSIsInZhbHVlIjoiVjljaUFlRlJrQURtZ0xYY2tiRU5qSElhQzlvQVhpMWhNQmFnc29NY2JtWlpNTFBtbC9PcnRtcGdSK05sRlZISHI3NUdXYzR3bkg4UGpaaGdhZERQUG9SWXZuVWJvWUVENEVjY3dlS0s4WXJHQmx1dHU5TE1Tc2ZxNjAwY0xqa24iLCJtYWMiOiJjNTY0NDA2MmY1NTQyYmU4ZTZjZmMzYWI1NThhY2RkNTFiZTBiZGYwZDk5YWIzZGY1NjFlN2I5OWY1MTg2MjM2IiwidGFnIjoiIn0%3D; expires=Fri, 14-Mar-2025 08:43:56 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IlNzNTlib1B3NEYrWVJYaUs2K1huMFE9PSIsInZhbHVlIjoiVjljaUFlRlJrQURtZ0xYY2tiRU5qSElhQzlvQVhpMWhNQmFnc29NY2JtWlpNTFBtbC9PcnRtcGdSK05sRlZISHI3NUdXY ▶"
    1 => "hours_frontend_session=eyJpdiI6IktDVDM2cVNsMklpUS82UzJnTW9WSXc9PSIsInZhbHVlIjoiR2xPRnlUUzZZWnBiV2pzT1ROeFF6aFpMWExvTkxqYVpoRVhrMGlYUmFjSi9LWVAzMG1IUFFBMFJUWEg1aXBHaFBYclhPbzBsOWJlOVh5MHAwSFNXQ2FucG5NeWxjK3RsMnZTdGc0b1dPWWNpSWRUczA1UG5FbWRMZXVnamhjeEMiLCJtYWMiOiIwNDY3YmMyMWY4Yjc3YzcyYjY2YTg5YWI2YzNkMjA5YTFjNGFiNWVjNmU4ZGZiYWU0MDM1ODNjZjljNzcwOTBkIiwidGFnIjoiIn0%3D; expires=Fri, 14-Mar-2025 08:43:56 GMT; path=/; httponly ◀hours_frontend_session=eyJpdiI6IktDVDM2cVNsMklpUS82UzJnTW9WSXc9PSIsInZhbHVlIjoiR2xPRnlUUzZZWnBiV2pzT1ROeFF6aFpMWExvTkxqYVpoRVhrMGlYUmFjSi9LWVAzMG1IUFFBMFJUWEg1a ▶"
  ]
]

session_attributes

  0 of 0   
array:5 [▼
  "_token" => "c0tNIzyeRND8gLUqc1GodjIrxNKCwsxS3o8XSsjS"
  "parent_page" => "pages.city-category"
  "url" => array:1 [▶
    "intended" => "https://alpha.hours.com/Carmarthenshire/Tenby/Nightclubs"
  ]
  "_previous" => array:1 [▶
    "url" => "https://alpha.hours.com/Carmarthenshire/Tenby/Nightclubs"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-03-14 06:43:56	GET	/Carmarthenshire/Tenby/Nightclubs	272 81 443 62

1 x Application (99.37%)	1.43s
1 x Booting (0.63%)	9.03ms

Bindings
Backtrace

Bindings
Backtrace

Bindings
Backtrace

Nightclub locations, opening times & reviews in Tenby

Best-reviewed Nightclub in Tenby

Register on our platform and enjoy all the benefits for free!

Welcome back

Not a member yet?

To get the most out of your account, we'd like to know more about you:

Sign up to get the most out of Openingstijden.nl.

Forgot your password?

Delete account

Do you really want to delete your account?