Department store locations, opening times & reviews in Narberth

Looking for Department stores locations in Narberth? Using our locator, you can easily find the current opening times, reviews, contact details, and route information for a Department store near you in Narberth

Best-reviewed Department store in Narberth

Not sure which Department store to visit in Narberth? Other locals like you have visited Department stores and left reviews to help you decide where to go. Use our locator to find a nearby Department store, and be sure to check the opening times, contact details, and route information before you go.

Best in Department stores

Premier stores St. John Street

(0)

Premier stores High Street

(0)

Poundland High Street 16

Best in Supermarkets

SPAR Narberth 36 High Street, Narb...

(0)

Best in Restaurants

Greggs 44-45 High Street

(0)

Greggs Texaco Haverford Wes...

(0)

Waldo Lounge Bridge Street

(0)

Best in Hotels

Premier Inn Tenby... White Lion St

(0)

Premier Inn Haverf... Glanafon Farm House...

(0)

Savoy Country Inn... Tenby Road

(0)

Best in DIY Stores

Travis Perkins Begelly Cross Road

(0)

Jewson The Green

(0)

Wolseley The Salterns

(0)

Do you know everything about Narberth?

Help visitors, residents, friends, and family explore Narberth with a true local guide. Sign up and review your favorite spots today!

Nearby:

Argos

Nisa

Premier stores

Go to

Categories

Business Owners

Messages Timeline Exceptions Views274 Route Queries76 Models293 Livewire62 Mails Gate Session Request

Request history8.2.283.82s7MBGET {route}

Booting (8.84ms)time
Application (3.81s)time
1 x Application (99.77%)
3.81s
1 x Booting (0.23%)
8.84ms

274 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
63x 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

75 statements were executed (6 duplicates)Show only duplicates3.49s

Connection Establishedhours_frontendDynamicRouteControllerDispatcher.php#39
Backtrace
select * from `routes` where `route` = 'Carmarthenshire/Narberth/Department-stores' limit 1
3mshours_frontendDynamicRouteControllerDispatcher.php#39
Bindings
Backtrace
update `routes` set `visit_count` = `visit_count` + 1, `routes`.`updated_at` = '2025-03-14 07:44:10' where `id` = 76460030
560μshours_frontendDynamicRouteControllerDispatcher.php#43
Bindings
Backtrace
select * from `establishments` where `slug` = 'Carmarthenshire/Narberth/Department-stores' and `establishments`.`deleted_at` is null limit 1
1.45mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `regions` where `slug` = 'Carmarthenshire/Narberth/Department-stores' limit 1
970μshours_frontendDynamicRouteControllerDispatcher.php#111
Bindings
Backtrace
select * from `categories` where `slug` = 'Carmarthenshire/Narberth/Department-stores' limit 1
420μshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `slug` = 'Carmarthenshire/Narberth/Department-stores' limit 1
660μshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `attributes` where `slug` = 'Carmarthenshire/Narberth/Department-stores' limit 1
660μshours_frontendDynamicRouteControllerDispatcher.php#111
Bindings
Backtrace
select * from `categories` where `slug` = 'Department-stores' limit 1
1.02mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `regions` where `slug` = 'Carmarthenshire/Narberth' and `type` = 'locality' limit 1
480μshours_frontendDynamicRouteControllerDispatcher.php#195
Bindings
Backtrace
select * from `regions` where `regions`.`id` = 101852987 and `type` = 'locality' limit 1
940μshours_frontendTopbar.php#66
Bindings
Backtrace
select count(*) as aggregate from `regions` where `regions`.`locality_id` = 101852987 and `regions`.`locality_id` is not null and `type` = 'neighbourhood'
1.57mshours_frontendTopbar.php#78
Bindings
Backtrace
select count(*) as aggregate from `attributes` where `attributes`.`locality_id` = 101852987 and `attributes`.`locality_id` is not null and `subtype` = 'uk shopping area'
930μshours_frontendTopbar.php#84
Bindings
Backtrace
select count(*) as aggregate from `attributes` where `attributes`.`locality_id` = 101852987 and `attributes`.`locality_id` is not null and `subtype` = 'uk shopping street'
1.14mshours_frontendTopbar.php#90
Bindings
Backtrace
select * from `regions` where `regions`.`id` = 1880772913 and `type` = 'region' limit 1
1.02mshours_frontendRegion.php#51
Bindings
Backtrace
select * from `regions` where `regions`.`id` = 101852987 and `type` = 'locality' limit 1
830μshours_frontendRegion.php#52
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
188mshours_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` = 101852987 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` = 'Department stores')) and `establishments`.`deleted_at` is null limit 3
31.7mshours_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.74092000', '51.80390200')) 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` = 'Department stores')) and 1 = 1 and `establishments`.`deleted_at` is null order by `distance` asc limit 3
2.54shours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (893012, 893185)
830μshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select * from `categories` where `categories`.`id` in (100518)
720μ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` = 101852987 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
13.07mshours_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.74092000', '51.80390200')) 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
16.28mshours_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` = 101852987 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
65.74mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (892970, 892994, 1277127)
680μshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select * from `categories` where `categories`.`id` in (100450)
580μ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` = 101852987 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
42.7mshours_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.74092000', '51.80390200')) 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 1 = 1 and `establishments`.`deleted_at` is null order by `distance` asc limit 3
282mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (892973, 1845056)
530μshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select * from `categories` where `categories`.`id` in (100394)
500μ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` = 101852987 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.24mshours_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.74092000', '51.80390200')) 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 1 = 1 and `establishments`.`deleted_at` is null order by `distance` asc limit 3
63.48mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (1216607, 1222995, 1256193)
480μshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select * from `categories` where `categories`.`id` in (100209)
390μ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` = 101852987 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
18.57mshours_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.74092000', '51.80390200')) 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 1 = 1 and `establishments`.`deleted_at` is null order by `distance` asc limit 3
48.19mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (892998, 893000, 893619)
550μshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select * from `categories` where `categories`.`id` in (100076)
440μ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` = 100518 and `establishments`.`deleted_at` is null order by `distance` asc limit 6
33.97mshours_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
4.69mshours_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
2.19mshours_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.5mshours_frontendUserLocation.php#78
Bindings
Backtrace
select establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('-4.74092000', '51.80390200')) AS distance, `businesses`.`category_id` as `laravel_through_key` from `establishments` inner join `businesses` on `businesses`.`id` = `establishments`.`business_id` where `businesses`.`category_id` = 100518 and `establishments`.`deleted_at` is null order by `distance` asc limit 90
32.58mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (892966, 893012, 893079, 893093, 893096, 893098, 893185, 893243, 893421, 893906, 1262241, 1262410, 1262576, 1263453, 1263676, 1263730, 1264913)
1.7mshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 893460 and `establishment_departments`.`establishment_id` is not null
990μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 893492 and `establishment_departments`.`establishment_id` is not null
610μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 921659 and `establishment_departments`.`establishment_id` is not null
1.16mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 908760 and `establishment_departments`.`establishment_id` is not null
1.09mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2270447 and `establishment_departments`.`establishment_id` is not null
800μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2268340 and `establishment_departments`.`establishment_id` is not null
720μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 908762 and `establishment_departments`.`establishment_id` is not null
560μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 921657 and `establishment_departments`.`establishment_id` is not null
570μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 938681 and `establishment_departments`.`establishment_id` is not null
980μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 923339 and `establishment_departments`.`establishment_id` is not null
1.04mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 923337 and `establishment_departments`.`establishment_id` is not null
590μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 893483 and `establishment_departments`.`establishment_id` is not null
600μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 893481 and `establishment_departments`.`establishment_id` is not null
570μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 947173 and `establishment_departments`.`establishment_id` is not null
1.15mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 947172 and `establishment_departments`.`establishment_id` is not null
630μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 893500 and `establishment_departments`.`establishment_id` is not null
580μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 908763 and `establishment_departments`.`establishment_id` is not null
650μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 923340 and `establishment_departments`.`establishment_id` is not null
590μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2268801 and `establishment_departments`.`establishment_id` is not null
820μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 938684 and `establishment_departments`.`establishment_id` is not null
670μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 953887 and `establishment_departments`.`establishment_id` is not null
860μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 893494 and `establishment_departments`.`establishment_id` is not null
1mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 958029 and `establishment_departments`.`establishment_id` is not null
980μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 893497 and `establishment_departments`.`establishment_id` is not null
640μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 893503 and `establishment_departments`.`establishment_id` is not null
600μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 953484 and `establishment_departments`.`establishment_id` is not null
1.22mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 947174 and `establishment_departments`.`establishment_id` is not null
590μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 980635 and `establishment_departments`.`establishment_id` is not null
1.11mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 953890 and `establishment_departments`.`establishment_id` is not null
620μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 953891 and `establishment_departments`.`establishment_id` is not null
700μshours_frontendHasHours.php#36
Bindings
Backtrace
select establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('-4.74092000', '51.80390200')) AS distance, `businesses`.`category_id` as `laravel_through_key` from `establishments` inner join `businesses` on `businesses`.`id` = `establishments`.`business_id` where `businesses`.`category_id` = 100518 and `establishments`.`deleted_at` is null order by `distance` asc limit 90
33.99mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (892966, 893012, 893079, 893093, 893096, 893098, 893185, 893243, 893421, 893906, 1262241, 1262410, 1262576, 1263453, 1263676, 1263730, 1264913)
680μshours_frontendBuildsGroupLimitQueries.php#38
Backtrace

App\Models\Establishment: 201Establishment.php#?
App\Models\Business: 47Business.php#?
App\Models\EstablishmentDepartment: 30EstablishmentDepartment.php#?
App\Models\Category: 6Category.php#?
App\Models\Region: 6Region.php#?
App\Models\Attribute: 2Attribute.php#?
App\Models\Route: 1Route.php#?

topbar #yGHRagX4Jj7GGTH4TOhg: array:4 [ "data" => array:4 [ "user" => null "parent" => App\Models\Region {#1877 #c...
partials.top-rated #t22XzsD9RsIoLkdsb35o: array:4 [ "data" => array:5 [ "title" => "Best-reviewed Department store in Narberth" "des...
partials.cards.card-chainrating #aqfuI4X2OEUIFxTqAO9u: array:4 [ "data" => array:3 [ "headingText" => "Best in Department stores" "blocks" => Il...
partials.cards.card-chainrating-block #OXnLPgT38TTWpidUGCSo: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#9031 #connec...
partials.cards.card-chainrating-block #6qAx73yRzlqOdyEcmoDK: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#9028 #connec...
partials.cards.card-chainrating-block #Bw8xRXd1SirR8VEzyqiv: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#9027 #connec...
partials.cards.card-chainrating #AzCkNsFsFsV80FD7RRZp: array:4 [ "data" => array:3 [ "headingText" => "Best in Supermarkets" "blocks" => Illumin...
partials.cards.card-chainrating-block #8hT7dJkRrBIxVkESnapm: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8878 #connec...
partials.cards.card-chainrating-block #rjrOtWgq6MfQ7SjmnXEg: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8879 #connec...
partials.cards.card-chainrating-block #dH9K7y48LKplvLfJ2sii: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8880 #connec...
partials.cards.card-chainrating #4HpV5E2jcng8yp9BJWVO: array:4 [ "data" => array:3 [ "headingText" => "Best in Restaurants" "blocks" => Illumina...
partials.cards.card-chainrating-block #j18wbJh82boiQQqOZf9F: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8788 #connec...
partials.cards.card-chainrating-block #Pr4K5SMuUeOhb3TTrPfb: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8789 #connec...
partials.cards.card-chainrating-block #7FQctRxVlB4syrKqbrWz: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8790 #connec...
partials.cards.card-chainrating #FinlTqXFqEsCKN2hONWH: array:4 [ "data" => array:3 [ "headingText" => "Best in Hotels" "blocks" => Illuminate\Da...
partials.cards.card-chainrating-block #rBi5B82huvD9kuRRDZmc: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8700 #connec...
partials.cards.card-chainrating-block #JnmRInSGokkz47tqc6UH: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8701 #connec...
partials.cards.card-chainrating-block #1ufHW5xv9bRGcMoH8uT9: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8702 #connec...
partials.cards.card-chainrating #1qfSmFvzU58gGmqWLkn8: array:4 [ "data" => array:3 [ "headingText" => "Best in DIY Stores" "blocks" => Illuminat...
partials.cards.card-chainrating-block #fzgl4oTouCdlImfLbl6I: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8611 #connec...
partials.cards.card-chainrating-block #tMhPCplxbz2NrZVqZ3Wg: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8612 #connec...
partials.cards.card-chainrating-block #v9WfWYxvvVkHP4qj9Zzs: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8613 #connec...
partials.join-us #dsNm5ufwKLZJHAOHHgaB: array:4 [ "data" => array:1 [ "cityName" => "Narberth" ] "name" => "partials.join-us" "c...
partials.city-guides #wVbbZMm98WbxoXA0u1tF: array:4 [ "data" => array:2 [ "scrollable" => null "locations" => Illuminate\Database\Eloq...
breadcrumbs #6UmDVOEaKCp5Adx7m5xH: array:4 [ "data" => array:3 [ "parent" => App\Models\Region {#1877 #connection: "mysql" ...
search-results #6vuiVK5V9IT1t79m5Lzv: array:4 [ "data" => array:6 [ "search" => "" "results" => [] "searchOverlayActive" => ...
partials.search-around #pWPN8L7PKosMryzEyMAa: array:4 [ "data" => array:1 [ "userLocation" => array:4 [ "longitude" => -0.13184 ...
sidebar.cards.area #iWzTSI5mlqpgNDYcI5JH: array:4 [ "data" => array:1 [ "area" => App\Models\Region {#6966 #connection: "mysql" ...
sidebar.cards.area #glSq5YE9vuhSF3fJ8NNM: array:4 [ "data" => array:1 [ "area" => App\Models\Region {#6970 #connection: "mysql" ...
sidebar.cards.area #QOR396eIWJON5W6U4xHe: array:4 [ "data" => array:1 [ "area" => App\Models\Attribute {#6963 #connection: "mysql"...
sidebar.cards.area #SQ9KoyNdhIMh5TPGZRaY: array:4 [ "data" => array:1 [ "area" => App\Models\Attribute {#6914 #connection: "mysql"...
sidebar.cards.category #Lqe5hLn68dFw3IhX35i6: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#6975 #connection: "mys...
sidebar.cards.category #UIEGalb5lpNjj0PDGHcR: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#7099 #connection: "mys...
sidebar.cards.category #lkntpqNAisgxzPuNuhBM: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#7236 #connection: "mys...
sidebar.cards.category #vumlPqnHtiMju33D0Ghb: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#7237 #connection: "mys...
sidebar.cards.category #IAwbNN3JIFL2iuDTxqrE: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#7262 #connection: "mys...
sidebar.cards.category #8M8mo8oKEGYWHEOgYqKL: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#7261 #connection: "mys...
sidebar.cards.category #pMphKcx4Ao016YIt6Zan: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#7260 #connection: "mys...
sidebar.cards.category #si0GAGhMSB3VxJ8XtnP0: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#7259 #connection: "mys...
sidebar.cards.category #wzell98tchVm2KCL77fn: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#7258 #connection: "mys...
sidebar.cards.category #LhJRavTy33fK49QHyv1b: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#7257 #connection: "mys...
sidebar.blocks.locations #AeEe59ElW2s3WcFnFNwO: array:4 [ "data" => array:16 [ "locations" => null "current_id" => null "heading" => "...
sidebar.blocks.locations #lX7cqllqvSjBYNtFYB7x: array:4 [ "data" => array:16 [ "locations" => null "current_id" => null "heading" => "...
search #ZiSZDZnjCQVgFuepWOUf: array:4 [ "data" => array:1 [ "search" => "" ] "name" => "search" "component" => "App\Li...
search #FXb9g9ebYxJxyyJpQTBr: array:4 [ "data" => array:1 [ "search" => "" ] "name" => "search" "component" => "App\Li...
filter.filter #ra5tcOSwpNBnyUivEWSB: array:4 [ "data" => array:5 [ "hours" => 0 "filtersAreNotEmpty" => false "showFilter" ...
filter.slide-in #n4Cqj9K4r2XcwZbp19Cw: array:4 [ "data" => array:8 [ "openFrom" => "" "openTo" => "" "dayRange" => "today" ...
location.location-autocomplete #f9pVPTwcFU8ojTZqyhrw: array:4 [ "data" => array:5 [ "initialLocation" => "London, E1 8RU" "location" => "London,...
sidebar.navigation #5gg9VV7fS3ei9ammHGEK: array:4 [ "data" => [] "name" => "sidebar.navigation" "component" => "App\Livewire\Sidebar\Nav...
modal.location #caGmqMf3c51C01LmUnmx: array:4 [ "data" => array:2 [ "classes" => [] "showModal" => false ] "name" => "modal....
location.location-autocomplete #kFGh9EupIGjWETAu1L3f: array:4 [ "data" => array:5 [ "initialLocation" => "London, E1 8RU" "location" => "London,...
filter.filter #wEksV7BC5MUGbpMOvSuI: array:4 [ "data" => array:5 [ "hours" => 0 "filtersAreNotEmpty" => false "showFilter" ...
filter.slide-in #oa9itxi20WVTZIz01AI0: array:4 [ "data" => array:8 [ "openFrom" => "" "openTo" => "" "dayRange" => "today" ...
location.location-autocomplete #eiDR5129iugmGWK7n90U: array:4 [ "data" => array:5 [ "initialLocation" => "London, E1 8RU" "location" => "London,...
common.local-bar #88XKA5XYBm2NdQV642hz: array:4 [ "data" => [] "name" => "common.local-bar" "component" => "App\Livewire\Common\LocalB...
auth.signup #iZgQG7AsS0ASISPRbGgo: array:4 [ "data" => [] "name" => "auth.signup" "component" => "App\Livewire\Auth\Signup" "id...
auth.login #F5W0UR05IuHk4DHQ3cts: array:4 [ "data" => array:3 [ "email" => null "password" => null "class" => "" ] "...
auth.onboarding #lsGaSX07XOcbGk9YURga: array:4 [ "data" => array:6 [ "name" => null "classes" => [] "localities" => null ...
location.location-autocomplete #eKDwrXqEZmxbv2EpcEmB: array:4 [ "data" => array:5 [ "initialLocation" => "London, E1 8RU" "location" => "London,...
auth.register #KZdlBRZsFNoV0VeIzfkN: array:4 [ "data" => array:3 [ "email" => null "password" => null "class" => "" ] "...
auth.forgot-password #vgA3r6jUhSZ4eWDMpwtE: array:4 [ "data" => array:3 [ "email" => "" "class" => "" "successMessage" => null ]...
auth.delete-account #BajsNtle0yZp2diyNz2k: array:4 [ "data" => [] "name" => "auth.delete-account" "component" => "App\Livewire\Auth\Delet...

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

path_info

/Carmarthenshire/Narberth/Department-stores

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 07:44:10 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=eyJpdiI6Ii8xSjYzVThhSk13V2FWSS8zSXhsaUE9PSIsInZhbHVlIjoidjFvN2g2UFBEWWpjRzNVWUUxWTgxL2pTZUN5N2RXRCtyRjg3aDdMcGZpdWY3ZjdnZ2w4Mk9hOU5aL2pMRWNLdlRkRVI1dHVER1V3MFBNWEVDOC83Tk50YnJtWXZYOGkzZWxhbUpPT3VBWnJ3bU00VThjVDk3T3VzamxjLzlQVmkiLCJtYWMiOiIyMTI0NzA1YWI5MjdjNzZmODk1OTJiNzJhY2VhZDZhMWY0NThiMjU2Y2Y3NTA1YTIwZmM1ZTg0Y2RiZGYxYmNmIiwidGFnIjoiIn0%3D; expires=Fri, 14 Mar 2025 09:44:14 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Ii8xSjYzVThhSk13V2FWSS8zSXhsaUE9PSIsInZhbHVlIjoidjFvN2g2UFBEWWpjRzNVWUUxWTgxL2pTZUN5N2RXRCtyRjg3aDdMcGZpdWY3ZjdnZ2w4Mk9hOU5aL2pMRWNLdlRkRVI1d ▶"
    1 => "hours_frontend_session=eyJpdiI6IkRLd3luaitLM3Q0OUlOLzJ6blNzRXc9PSIsInZhbHVlIjoiSlVVQXNXbE9ZaXNQTitZZEc5QmZLZnRIaEd0RmVQNnZVNnVmM1Q4anJ0TWtUYnFZS25ia2NjWEp3b04rajBwSXZmT0VkeFBFVXh2cVFuazVYZ2RmbTkySDZId1E5Ylk0ZDBnNnE3a291V2NjRUJMRnUrZ2FlVzE1aXNWb0ZISWQiLCJtYWMiOiIzNTU1OGJlYTMzNDhjYWIxZDBiNjlhOGQyMDMzNDcxODA5NWYxNWJjZTMyMWE5OGU0OWU0NmNkNzYxOTQxMDRjIiwidGFnIjoiIn0%3D; expires=Fri, 14 Mar 2025 09:44:14 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀hours_frontend_session=eyJpdiI6IkRLd3luaitLM3Q0OUlOLzJ6blNzRXc9PSIsInZhbHVlIjoiSlVVQXNXbE9ZaXNQTitZZEc5QmZLZnRIaEd0RmVQNnZVNnVmM1Q4anJ0TWtUYnFZS25ia2NjWEp3b04ra ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ii8xSjYzVThhSk13V2FWSS8zSXhsaUE9PSIsInZhbHVlIjoidjFvN2g2UFBEWWpjRzNVWUUxWTgxL2pTZUN5N2RXRCtyRjg3aDdMcGZpdWY3ZjdnZ2w4Mk9hOU5aL2pMRWNLdlRkRVI1dHVER1V3MFBNWEVDOC83Tk50YnJtWXZYOGkzZWxhbUpPT3VBWnJ3bU00VThjVDk3T3VzamxjLzlQVmkiLCJtYWMiOiIyMTI0NzA1YWI5MjdjNzZmODk1OTJiNzJhY2VhZDZhMWY0NThiMjU2Y2Y3NTA1YTIwZmM1ZTg0Y2RiZGYxYmNmIiwidGFnIjoiIn0%3D; expires=Fri, 14-Mar-2025 09:44:14 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6Ii8xSjYzVThhSk13V2FWSS8zSXhsaUE9PSIsInZhbHVlIjoidjFvN2g2UFBEWWpjRzNVWUUxWTgxL2pTZUN5N2RXRCtyRjg3aDdMcGZpdWY3ZjdnZ2w4Mk9hOU5aL2pMRWNLdlRkRVI1d ▶"
    1 => "hours_frontend_session=eyJpdiI6IkRLd3luaitLM3Q0OUlOLzJ6blNzRXc9PSIsInZhbHVlIjoiSlVVQXNXbE9ZaXNQTitZZEc5QmZLZnRIaEd0RmVQNnZVNnVmM1Q4anJ0TWtUYnFZS25ia2NjWEp3b04rajBwSXZmT0VkeFBFVXh2cVFuazVYZ2RmbTkySDZId1E5Ylk0ZDBnNnE3a291V2NjRUJMRnUrZ2FlVzE1aXNWb0ZISWQiLCJtYWMiOiIzNTU1OGJlYTMzNDhjYWIxZDBiNjlhOGQyMDMzNDcxODA5NWYxNWJjZTMyMWE5OGU0OWU0NmNkNzYxOTQxMDRjIiwidGFnIjoiIn0%3D; expires=Fri, 14-Mar-2025 09:44:14 GMT; path=/; httponly ◀hours_frontend_session=eyJpdiI6IkRLd3luaitLM3Q0OUlOLzJ6blNzRXc9PSIsInZhbHVlIjoiSlVVQXNXbE9ZaXNQTitZZEc5QmZLZnRIaEd0RmVQNnZVNnVmM1Q4anJ0TWtUYnFZS25ia2NjWEp3b04ra ▶"
  ]
]

session_attributes

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

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-03-14 07:44:14	GET	/Carmarthenshire/Narberth/Department-stores	274 76 293 62

1 x Application (99.77%)	3.81s
1 x Booting (0.23%)	8.84ms

Bindings
Backtrace

Bindings
Backtrace

Bindings
Backtrace

Department store locations, opening times & reviews in Narberth

Best-reviewed Department store in Narberth

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?