Find Cosmetics in Boxley - Opening Times & Reviews

Messages1 Timeline Exceptions Views266 Route Queries71 Models339 Livewire62 Mails Gate Session Request

Request history8.2.283.45s8MBGET {route}

warninglog[06:35:33] LOG.warning: Implicit conversion from float 3.33 to int loses precision in /var/www/alpha...

Booting (9.1ms)time
Application (3.44s)time
1 x Application (99.74%)
3.44s
1 x Booting (0.26%)
9.10ms

266 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
55x 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

70 statements were executed (12 duplicates)Show only duplicates3.08s

Connection Establishedhours_frontendDynamicRouteControllerDispatcher.php#39
Backtrace
select * from `routes` where `route` = 'Kent/Boxley/Cosmetics' limit 1
2.96mshours_frontendDynamicRouteControllerDispatcher.php#39
Bindings
Backtrace
update `routes` set `visit_count` = `visit_count` + 1, `routes`.`updated_at` = '2025-03-14 06:35:30' where `id` = 77394971
710μshours_frontendDynamicRouteControllerDispatcher.php#43
Bindings
Backtrace
select * from `establishments` where `slug` = 'Kent/Boxley/Cosmetics' and `establishments`.`deleted_at` is null limit 1
990μshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `regions` where `slug` = 'Kent/Boxley/Cosmetics' limit 1
490μshours_frontendDynamicRouteControllerDispatcher.php#111
Bindings
Backtrace
select * from `categories` where `slug` = 'Kent/Boxley/Cosmetics' limit 1
420μshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `slug` = 'Kent/Boxley/Cosmetics' limit 1
430μshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `attributes` where `slug` = 'Kent/Boxley/Cosmetics' limit 1
520μshours_frontendDynamicRouteControllerDispatcher.php#111
Bindings
Backtrace
select * from `categories` where `slug` = 'Cosmetics' limit 1
460μshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `regions` where `slug` = 'Kent/Boxley' and `type` = 'locality' limit 1
500μshours_frontendDynamicRouteControllerDispatcher.php#195
Bindings
Backtrace
select * from `regions` where `regions`.`id` = 1125798653 and `type` = 'locality' limit 1
590μshours_frontendTopbar.php#66
Bindings
Backtrace
select count(*) as aggregate from `regions` where `regions`.`locality_id` = 1125798653 and `regions`.`locality_id` is not null and `type` = 'neighbourhood'
1.71mshours_frontendTopbar.php#78
Bindings
Backtrace
select count(*) as aggregate from `attributes` where `attributes`.`locality_id` = 1125798653 and `attributes`.`locality_id` is not null and `subtype` = 'uk shopping area'
1.2mshours_frontendTopbar.php#84
Bindings
Backtrace
select count(*) as aggregate from `attributes` where `attributes`.`locality_id` = 1125798653 and `attributes`.`locality_id` is not null and `subtype` = 'uk shopping street'
920μ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
62.66mshours_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` = 1125798653 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` = 'Cosmetics')) and `establishments`.`deleted_at` is null limit 3
21.35mshours_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('0.54352000', '51.30781800')) 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` = 'Cosmetics')) and 1 = 1 and `establishments`.`deleted_at` is null order by `distance` asc limit 3
36.07mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (893097, 893241, 893764)
970μshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select * from `categories` where `categories`.`id` in (100116)
590μ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` = 1125798653 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
16.04mshours_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('0.54352000', '51.30781800')) 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
19.21mshours_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` = 1125798653 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
75.44mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (1229440)
710μshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select * from `categories` where `categories`.`id` in (100450)
490μ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('0.54352000', '51.30781800')) 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` = 'Supermarkets')) and `id` not in (2323413) and `establishments`.`deleted_at` is null order by `distance` asc limit 2
2.3shours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (892994, 1276919)
720μ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` = 1125798653 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.34mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (893328, 1294554)
640μshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select * from `categories` where `categories`.`id` in (100394)
490μ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('0.54352000', '51.30781800')) 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 (955874, 2316757) and `establishments`.`deleted_at` is null order by `distance` asc limit 1
259mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (893798)
2.76mshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select * from `categories` where `categories`.`id` in (100394)
3.12mshours_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` = 1125798653 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.3mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (1216294)
650μshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select * from `categories` where `categories`.`id` in (100209)
410μ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('0.54352000', '51.30781800')) 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 (2211060) and `establishments`.`deleted_at` is null order by `distance` asc limit 2
65.49mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (1216410, 1216653)
790μshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select * from `categories` where `categories`.`id` in (100209)
510μ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` = 1125798653 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
24.17mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (893000)
500μshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select * from `categories` where `categories`.`id` in (100076)
370μ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('0.54352000', '51.30781800')) 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 (2292230) and `establishments`.`deleted_at` is null order by `distance` asc limit 2
47.85mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (892998, 893281)
2.71mshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select * from `categories` where `categories`.`id` in (100076)
2.72mshours_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` = 100116 and `establishments`.`deleted_at` is null order by `distance` asc limit 6
5.82mshours_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.4mshours_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.07mshours_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.44mshours_frontendUserLocation.php#78
Bindings
Backtrace
select establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('0.54352000', '51.30781800')) AS distance, `businesses`.`category_id` as `laravel_through_key` from `establishments` inner join `businesses` on `businesses`.`id` = `establishments`.`business_id` where `businesses`.`category_id` = 100116 and `establishments`.`deleted_at` is null order by `distance` asc limit 90
11.47mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (893097, 893241, 893764, 894717, 895228, 897454, 897681, 898849, 899376, 900232, 907112, 907170, 1048425, 1048438, 1048584, 1048649, 1048653, 1056773, 1060377, 1138274, 1241116, 1247102, 1249186, 1249873, 1259075, 1259086, 1272801, 1294279, 1297919, 1297971, 1297985, 1298321, 1298338, 1298373, 1601246, 1634804, 1668048, 1685749, 1787853, 1813128, 1816391, 1839493, 1845043, 1901877)
2.06mshours_frontendBuildsGroupLimitQueries.php#38
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 925377 and `establishment_departments`.`establishment_id` is not null
910μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 936150 and `establishment_departments`.`establishment_id` is not null
680μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 929586 and `establishment_departments`.`establishment_id` is not null
830μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2321298 and `establishment_departments`.`establishment_id` is not null
780μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2248612 and `establishment_departments`.`establishment_id` is not null
700μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2250922 and `establishment_departments`.`establishment_id` is not null
530μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2321280 and `establishment_departments`.`establishment_id` is not null
580μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 925302 and `establishment_departments`.`establishment_id` is not null
1.35mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 929547 and `establishment_departments`.`establishment_id` is not null
530μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 1947551 and `establishment_departments`.`establishment_id` is not null
900μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2264194 and `establishment_departments`.`establishment_id` is not null
660μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2264164 and `establishment_departments`.`establishment_id` is not null
760μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 936168 and `establishment_departments`.`establishment_id` is not null
1.03mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2321869 and `establishment_departments`.`establishment_id` is not null
700μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 929598 and `establishment_departments`.`establishment_id` is not null
630μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 925417 and `establishment_departments`.`establishment_id` is not null
2.37mshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2264321 and `establishment_departments`.`establishment_id` is not null
580μshours_frontendHasHours.php#36
Bindings
Backtrace
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2240640 and `establishment_departments`.`establishment_id` is not null
1.1mshours_frontendHasHours.php#36
Bindings
Backtrace
select establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('0.54352000', '51.30781800')) AS distance, `businesses`.`category_id` as `laravel_through_key` from `establishments` inner join `businesses` on `businesses`.`id` = `establishments`.`business_id` where `businesses`.`category_id` = 100116 and `establishments`.`deleted_at` is null order by `distance` asc limit 90
15.2mshours_frontendBuildsGroupLimitQueries.php#38
Bindings
Backtrace
select * from `businesses` where `businesses`.`id` in (893097, 893241, 893764, 894717, 895228, 897454, 897681, 898849, 899376, 900232, 907112, 907170, 1048425, 1048438, 1048584, 1048649, 1048653, 1056773, 1060377, 1138274, 1241116, 1247102, 1249186, 1249873, 1259075, 1259086, 1272801, 1294279, 1297919, 1297971, 1297985, 1298321, 1298338, 1298373, 1601246, 1634804, 1668048, 1685749, 1787853, 1813128, 1816391, 1839493, 1845043, 1901877)
2.37mshours_frontendBuildsGroupLimitQueries.php#38
Backtrace

App\Models\Establishment: 201Establishment.php#?
App\Models\Business: 103Business.php#?
App\Models\EstablishmentDepartment: 18EstablishmentDepartment.php#?
App\Models\Category: 10Category.php#?
App\Models\Region: 4Region.php#?
App\Models\Attribute: 2Attribute.php#?
App\Models\Route: 1Route.php#?

topbar #mZDNVg9HufECRdnMUWFC: array:4 [ "data" => array:4 [ "user" => null "parent" => App\Models\Region {#1877 #c...
partials.top-rated #x9ifZ6DlvncoMvkyPWG9: array:4 [ "data" => array:5 [ "title" => "Best-reviewed Cosmetics in Boxley" "description"...
partials.cards.card-chainrating #9Y4ChhwZNepU7amPf3lJ: array:4 [ "data" => array:3 [ "headingText" => "Best in Cosmetics" "blocks" => Illuminate...
partials.cards.card-chainrating-block #CBfvIEG8gPz0L8P6m0al: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#9005 #connec...
partials.cards.card-chainrating-block #PFkjhZnfT3pO2vl6DZxN: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#9002 #connec...
partials.cards.card-chainrating-block #BIwvSJVgO4tAF4kSyQ3O: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#9001 #connec...
partials.cards.card-chainrating #lvqQxqzX3XDlmsmgwB9w: array:4 [ "data" => array:3 [ "headingText" => "Best in Supermarkets" "blocks" => Illumin...
partials.cards.card-chainrating-block #KJ6iSMwoWVAM43lTPJEj: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8793 #connec...
partials.cards.card-chainrating-block #8XnGap6Bc3FA13pGTx3w: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8849 #connec...
partials.cards.card-chainrating-block #8WSoo2F00YejmBdRRFLY: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8794 #connec...
partials.cards.card-chainrating #5XnsBRPiB71dHhEKbR6H: array:4 [ "data" => array:3 [ "headingText" => "Best in Restaurants" "blocks" => Illumina...
partials.cards.card-chainrating-block #oOCLWfIzizdjPFxD6Apm: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8738 #connec...
partials.cards.card-chainrating-block #NhPMdqtJALku7V2vKRHW: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8739 #connec...
partials.cards.card-chainrating-block #oWiD3L78IvymJowrAtHq: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8682 #connec...
partials.cards.card-chainrating #cExlablCYmEQ7EoWTnSq: array:4 [ "data" => array:3 [ "headingText" => "Best in Hotels" "blocks" => Illuminate\Da...
partials.cards.card-chainrating-block #fMqQjhTJfNadW2cAhcpK: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8629 #connec...
partials.cards.card-chainrating-block #3GBBxAwAbkdTgKOzxS81: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8573 #connec...
partials.cards.card-chainrating-block #gVoRhRfQTZ2sJiqAMdf0: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8574 #connec...
partials.cards.card-chainrating #J5XzpkubkSs3c85jTpul: array:4 [ "data" => array:3 [ "headingText" => "Best in DIY Stores" "blocks" => Illuminat...
partials.cards.card-chainrating-block #oiVRqb33tasro5n7bmG4: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8519 #connec...
partials.cards.card-chainrating-block #YRr89K7nDB5C3rkbFXlO: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8463 #connec...
partials.cards.card-chainrating-block #UWfT8ic0LxlFSsGbbF5A: array:4 [ "data" => array:4 [ "establishment" => App\Models\Establishment {#8464 #connec...
partials.join-us #hBg0pbQcL7ejFDE7O3s3: array:4 [ "data" => array:1 [ "cityName" => "Boxley" ] "name" => "partials.join-us" "com...
partials.city-guides #gL6ZcF2rOjj5nSja9neh: array:4 [ "data" => array:2 [ "scrollable" => null "locations" => Illuminate\Database\Eloq...
breadcrumbs #xXLuc9e9AhcqxqPDX3lU: array:4 [ "data" => array:3 [ "parent" => App\Models\Region {#1877 #connection: "mysql" ...
search-results #52hDxmMIWwbbB0UEqLOq: array:4 [ "data" => array:6 [ "search" => "" "results" => [] "searchOverlayActive" => ...
partials.search-around #W5qxYteNpTjBfcMA2S83: array:4 [ "data" => array:1 [ "userLocation" => array:4 [ "longitude" => -0.13184 ...
sidebar.cards.area #tx4RIM9OPP1TsFt9ZCQc: array:4 [ "data" => array:1 [ "area" => App\Models\Region {#7090 #connection: "mysql" ...
sidebar.cards.area #aBMgThPSz6apQKu9BGEE: array:4 [ "data" => array:1 [ "area" => App\Models\Region {#7094 #connection: "mysql" ...
sidebar.cards.area #5LhNPKWIfZ2rTelJUiFj: array:4 [ "data" => array:1 [ "area" => App\Models\Attribute {#7213 #connection: "mysql"...
sidebar.cards.area #lV2VlFiRkhzhu2oei0uD: array:4 [ "data" => array:1 [ "area" => App\Models\Attribute {#7214 #connection: "mysql"...
sidebar.cards.category #HXyphbIzzQTmL8yFgOv3: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#7099 #connection: "mys...
sidebar.cards.category #Bo7CbTCHKAmZ5pzlig9K: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#6987 #connection: "mys...
sidebar.cards.category #6TL6JQQKauVVJyHtGwuq: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#7079 #connection: "mys...
sidebar.cards.category #yE0imq68vExXnN1LD8GJ: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#6744 #connection: "mys...
sidebar.cards.category #2N7VYkJGt0Gy6s86dirx: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#6824 #connection: "mys...
sidebar.cards.category #8e5k4OPDxYjvYeYTbCse: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#6823 #connection: "mys...
sidebar.cards.category #S3427E8x63QJ35MLkrHo: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#6822 #connection: "mys...
sidebar.cards.category #PsDAgBQ2kHNpkCXuNhMH: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#6821 #connection: "mys...
sidebar.cards.category #soJwpwIHHZbG1pGBtpQg: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#6820 #connection: "mys...
sidebar.cards.category #pX87ci3d0UWoSSuCVsOZ: array:4 [ "data" => array:2 [ "category" => App\Models\Category {#6819 #connection: "mys...
sidebar.blocks.locations #XA9BiV0eyjkh2qoXkMvY: array:4 [ "data" => array:16 [ "locations" => null "current_id" => null "heading" => "...
sidebar.blocks.locations #BoXwnpGtptnE5wcYHp0Z: array:4 [ "data" => array:16 [ "locations" => null "current_id" => null "heading" => "...
search #SIHqL1KX6Dq5VPxOdxbO: array:4 [ "data" => array:1 [ "search" => "" ] "name" => "search" "component" => "App\Li...
search #PbCpdEfHyEtQazL0rTy9: array:4 [ "data" => array:1 [ "search" => "" ] "name" => "search" "component" => "App\Li...
filter.filter #hPPgboDBe1G7hcVQ8Q1v: array:4 [ "data" => array:5 [ "hours" => 0 "filtersAreNotEmpty" => false "showFilter" ...
filter.slide-in #ZRD8012ayaJtH3WmYMiL: array:4 [ "data" => array:8 [ "openFrom" => "" "openTo" => "" "dayRange" => "today" ...
location.location-autocomplete #X0oVnh8XKwOKklWfdrcm: array:4 [ "data" => array:5 [ "initialLocation" => "London, E1 8RU" "location" => "London,...
sidebar.navigation #7m0m2WalCYJD6imV4DDO: array:4 [ "data" => [] "name" => "sidebar.navigation" "component" => "App\Livewire\Sidebar\Nav...
modal.location #5trqYPMTRLRLaJFvgMo7: array:4 [ "data" => array:2 [ "classes" => [] "showModal" => false ] "name" => "modal....
location.location-autocomplete #cZSzD7OGAC665HQdM7gA: array:4 [ "data" => array:5 [ "initialLocation" => "London, E1 8RU" "location" => "London,...
filter.filter #Z2XDGogXxMWwjxwoCcFk: array:4 [ "data" => array:5 [ "hours" => 0 "filtersAreNotEmpty" => false "showFilter" ...
filter.slide-in #QJbBI2KkNPyiDQltSPhJ: array:4 [ "data" => array:8 [ "openFrom" => "" "openTo" => "" "dayRange" => "today" ...
location.location-autocomplete #HJNmtrCmnlWfnR3Undlj: array:4 [ "data" => array:5 [ "initialLocation" => "London, E1 8RU" "location" => "London,...
common.local-bar #own047UtXtvrGDLwEwFw: array:4 [ "data" => [] "name" => "common.local-bar" "component" => "App\Livewire\Common\LocalB...
auth.signup #6qMK7Vlhb5KnAzO7bqJg: array:4 [ "data" => [] "name" => "auth.signup" "component" => "App\Livewire\Auth\Signup" "id...
auth.login #wgxA4uA2vpHrI0VjTG2g: array:4 [ "data" => array:3 [ "email" => null "password" => null "class" => "" ] "...
auth.onboarding #T8pNWfFwLBaCnQcduMQg: array:4 [ "data" => array:6 [ "name" => null "classes" => [] "localities" => null ...
location.location-autocomplete #ERsNuDU1kUwnSA8wpOuX: array:4 [ "data" => array:5 [ "initialLocation" => "London, E1 8RU" "location" => "London,...
auth.register #cuhBdriFbAtMuhz5gqf5: array:4 [ "data" => array:3 [ "email" => null "password" => null "class" => "" ] "...
auth.forgot-password #2edBe2Sh0eEqqtDhEQEm: array:4 [ "data" => array:3 [ "email" => "" "class" => "" "successMessage" => null ]...
auth.delete-account #jyvwi5P1Bcart7nV1Yra: array:4 [ "data" => [] "name" => "auth.delete-account" "component" => "App\Livewire\Auth\Delet...

_token: CkPSeBK0dTCv5I7C65DSHf6GoUS6zPfnyPTvpyC3
parent_page: pages.city-category
url: array:1 [ "intended" => "https://alpha.hours.com/Kent/Boxley/Cosmetics" ]
_previous: array:1 [ "url" => "https://alpha.hours.com/Kent/Boxley/Cosmetics" ]
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/Kent/Boxley/Cosmetics

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:16 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InJVdHJpT0xpcXZNQVN3SGJYNzFERmc9PSIsInZhbHVlIjoiSzlVMDJjc3R2NW5tNmRrdUtjVEM4Q1VFRlR2dXVBWmsvVTVxV2c5SGNMY0IwbHpzQ056V01ZUGtCT0xuSGYxTE4vTk5LYzN0Qnl4L0Z6TS9GQ3FrOXZaQnc1dkg1c05aMis4OVdBR0pITGhCZ01CTjI5M2FzZ2lmbGs1TFB2MEsiLCJtYWMiOiI1ZmNiMTAzYTNjZjdlN2UxYmIzYWU4NmQ5ZTU5ZjZmMWU0YmRlMTgzZGE1MGIxODhhMGNlMDI4NTBjNGVkZjI0IiwidGFnIjoiIn0%3D; hours_frontend_session=eyJpdiI6IlNzeHVrMytSVmJYcVZ3em9pVzZHK1E9PSIsInZhbHVlIjoibXZHam9vWmZ3eEorV01SdkNvdmpleEtVbzdxTWx5K21vRElaMTE5amxrZjY2RFRKd3I0Q09hN0lKWXk5U0xJR0gwT2UxVHlJMkZhZDNMWkFxaFlxYkZXY0FNRU8wLzQwSHZ3aGkwN3VOL3JLY0dPRy81VEF4VkovVGFSbGVlUXoiLCJtYWMiOiI5ZGM4NmRlNTBmOGJjZjQ4YjAzOWM0NDI4ZmUwMWE1MGM3ODJhNDFjYTYxMmM5NDljN2ZkNzgxOGZmYjUwNTczIiwidGFnIjoiIn0%3D; _pk_id.3.58f2=d687ab7429271760.1741934130.; _pk_ses.3.58f2=1 ◀XSRF-TOKEN=eyJpdiI6InJVdHJpT0xpcXZNQVN3SGJYNzFERmc9PSIsInZhbHVlIjoiSzlVMDJjc3R2NW5tNmRrdUtjVEM4Q1VFRlR2dXVBWmsvVTVxV2c5SGNMY0IwbHpzQ056V01ZUGtCT0xuSGYxTE4vTk5LY ▶"
  ]
  "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

  0 of 0   
array:4 [▼
  "XSRF-TOKEN" => "CkPSeBK0dTCv5I7C65DSHf6GoUS6zPfnyPTvpyC3"
  "hours_frontend_session" => "bpjmQKLAnIPxfOHiL2vxmwrAiyWjaHa0X3JPmWSq"
  "_pk_id_3_58f2" => null
  "_pk_ses_3_58f2" => null
]

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:35:30 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=eyJpdiI6InhSNHoyTno0dENrK1dka05NMWkrL1E9PSIsInZhbHVlIjoiZjlERG1yMkt5eXEwSkR6YnFJVDR4L1M3RUxUS3F1ZUZQUDY0MVoycVhpbUdUcHFIaWQrbzE2OWxtTjNBSHk4NUc5YVRKazFYZGRNbEM1UjRIeXF5aFlhQ0x6aGZoemhDU1AwTzJYS0ZPVUNMZVp5Y2ZyeTdNOFBHZmE3Zk9oTEMiLCJtYWMiOiI1NzA2ZGRhZGYzNjM0Zjg5MzAwZjU0NzEyYjY1YjNkNzQxMjk3Y2ExYjAwOGZkNmU1NmRmMWM5ZTdlNzY3MTU5IiwidGFnIjoiIn0%3D; expires=Fri, 14 Mar 2025 08:35:34 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InhSNHoyTno0dENrK1dka05NMWkrL1E9PSIsInZhbHVlIjoiZjlERG1yMkt5eXEwSkR6YnFJVDR4L1M3RUxUS3F1ZUZQUDY0MVoycVhpbUdUcHFIaWQrbzE2OWxtTjNBSHk4NUc5YVRKa ▶"
    1 => "hours_frontend_session=eyJpdiI6Ikozam1xUkpqMUR0a1I0bDcxTUZjeEE9PSIsInZhbHVlIjoibW1mb2IrTmxmZ0Q0c3FaZUVXTmhLOWR1WCs3d2QrcjJkMEtxUDErYVJTdU1ONmprc2FSYW5kQmtydUdtWm56Q2pVc29VbXRzc29HVzViM0NhYzdvbjdpZnZWWmowdUVHem9BK3BpMUZ4ZnNPNXFXQ0ZVM3dWTjJuMXk1T3FDSDgiLCJtYWMiOiJlMjcyMGM5MjEyMGVmZWVlZWNhMmNiZWMwNGFmZWY4OTg3MDQ1MTVhNjc4YTc1NDQyYzU2ZDc0M2M2YTQxYjQwIiwidGFnIjoiIn0%3D; expires=Fri, 14 Mar 2025 08:35:34 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀hours_frontend_session=eyJpdiI6Ikozam1xUkpqMUR0a1I0bDcxTUZjeEE9PSIsInZhbHVlIjoibW1mb2IrTmxmZ0Q0c3FaZUVXTmhLOWR1WCs3d2QrcjJkMEtxUDErYVJTdU1ONmprc2FSYW5kQmtydUdtW ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InhSNHoyTno0dENrK1dka05NMWkrL1E9PSIsInZhbHVlIjoiZjlERG1yMkt5eXEwSkR6YnFJVDR4L1M3RUxUS3F1ZUZQUDY0MVoycVhpbUdUcHFIaWQrbzE2OWxtTjNBSHk4NUc5YVRKazFYZGRNbEM1UjRIeXF5aFlhQ0x6aGZoemhDU1AwTzJYS0ZPVUNMZVp5Y2ZyeTdNOFBHZmE3Zk9oTEMiLCJtYWMiOiI1NzA2ZGRhZGYzNjM0Zjg5MzAwZjU0NzEyYjY1YjNkNzQxMjk3Y2ExYjAwOGZkNmU1NmRmMWM5ZTdlNzY3MTU5IiwidGFnIjoiIn0%3D; expires=Fri, 14-Mar-2025 08:35:34 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6InhSNHoyTno0dENrK1dka05NMWkrL1E9PSIsInZhbHVlIjoiZjlERG1yMkt5eXEwSkR6YnFJVDR4L1M3RUxUS3F1ZUZQUDY0MVoycVhpbUdUcHFIaWQrbzE2OWxtTjNBSHk4NUc5YVRKa ▶"
    1 => "hours_frontend_session=eyJpdiI6Ikozam1xUkpqMUR0a1I0bDcxTUZjeEE9PSIsInZhbHVlIjoibW1mb2IrTmxmZ0Q0c3FaZUVXTmhLOWR1WCs3d2QrcjJkMEtxUDErYVJTdU1ONmprc2FSYW5kQmtydUdtWm56Q2pVc29VbXRzc29HVzViM0NhYzdvbjdpZnZWWmowdUVHem9BK3BpMUZ4ZnNPNXFXQ0ZVM3dWTjJuMXk1T3FDSDgiLCJtYWMiOiJlMjcyMGM5MjEyMGVmZWVlZWNhMmNiZWMwNGFmZWY4OTg3MDQ1MTVhNjc4YTc1NDQyYzU2ZDc0M2M2YTQxYjQwIiwidGFnIjoiIn0%3D; expires=Fri, 14-Mar-2025 08:35:34 GMT; path=/; httponly ◀hours_frontend_session=eyJpdiI6Ikozam1xUkpqMUR0a1I0bDcxTUZjeEE9PSIsInZhbHVlIjoibW1mb2IrTmxmZ0Q0c3FaZUVXTmhLOWR1WCs3d2QrcjJkMEtxUDErYVJTdU1ONmprc2FSYW5kQmtydUdtW ▶"
  ]
]

session_attributes

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

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-03-14 06:35:34	GET	/Kent/Boxley/Cosmetics	1 266 71 339 62

1 x Application (99.74%)	3.44s
1 x Booting (0.26%)	9.10ms

Bindings
Backtrace

Bindings
Backtrace

Bindings
Backtrace

Cosmetics locations, opening times & reviews in Boxley

Best-reviewed Cosmetics in Boxley

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?