Verified
7, Bell Yard WC2A 2JR, St James's
Open Until 23:59
Share
Save
Phone number 07444244007
Missing yext-special-offer in pages/location local reliable Professional!
Neighborhood Clare Market
What3Words dined.duty.script

Opening times Drainage Blast Ltd 7, Bell Yard

Discover the latest opening times for Drainage Blast Ltd. This Plumber is located at 7, Bell Yard in St James's (Clare Market). Want to make sure this Drainage Blast Ltd in near you is open now? Be sure to check the opening hours before you go!

Open today until 23:59
This week(10 Mar - 16 Mar)
Next week(17 Mar - 23 Mar)
Monday
00:00 - 23:59
Tuesday
00:00 - 23:59
Wednesday
00:00 - 23:59
Thursday
00:00 - 23:59
Friday
00:00 - 23:59
Saturday
00:00 - 23:59
Sunday
00:00 - 23:59

Reviews for Drainage Blast Ltd 7, Bell Yard

Let others know what you think about Drainage Blast Ltd at 7, Bell Yard. Your review can help others decide whether to visit this Plumber or avoid it. By sharing a positive and honest review, you can help Drainage Blast Ltd stand out on our platform!

0.00
No reviews
Have you visited this location before? Share your experience!

Handy Nearby Locations

If you’re looking for convenient locations near Drainage Blast Ltd; whether it's a supermarket, a bank, a post office or a restaurant. Below your will find all the handy options nearby 7, Bell Yard in Clare Market

Banks
Hotels
Post offices
Restaurants
Supermarkets

Banks

0.1 mi
Yorkshire Building Society
Strand 200
0.1 mi
HSBC
Fleet Street 165
0.3 mi
Barclays Bank
326-328 High Holborn
0.3 mi
Santander
High Holborn 306
0.3 mi
Santander
Ludgate Circus 11
0.3 mi
Santander
Leather Lane 10
0.3 mi
Halifax
High Holborn
0.5 mi
Metro Bank
1 Southampton Row
0.5 mi
Metro Bank
Southampton Row

Hotels

0.3 mi
Premier Inn London Blackfriars (Fleet Street) hotel
1-2 Dorset Rise
0.3 mi
Club Quarters Hotel Covent Garden Holborn, London
61 Lincoln's Inn Fields
0.4 mi
Citadines Holborn-Covent Garden London
94-99 High Holborn
0.4 mi
Hyde London City
15 Old Bailey
0.4 mi
Premier Inn London Holborn hotel
27-29 Red Lion Street Holborn
0.4 mi
NoMad London
28 Bow Street
0.5 mi
Club Quarters Hotel St. Paul’s, London
24 Ludgate Hill
0.5 mi
Sea Containers London
20 Upper Ground
0.5 mi
Premier Inn London Farringdon (Smithfield) hotel
24 30 West Smithfield West Smithfield

Post offices

0.3 mi
Mail Boxes Etc
Bride Court 3
0.5 mi
Mail Boxes Etc
Clerkenwell Road 101
0.6 mi
Mail Boxes Etc
Bedford Street 43
0.7 mi
Mail Boxes Etc
Aldersgate Street 128
0.9 mi
Mail Boxes Etc
Lower Marsh 88
1.1 mi
Mail Boxes Etc
Ingestre Place 15
1.2 mi
Mail Boxes Etc
Pentonville Road 254
1.3 mi
Mail Boxes Etc
Great Titchfield Street 72
1.4 mi
Mail Boxes Etc
Duncan Street 8

Restaurants

0.1 mi
Soho Coffee Co
Strand
0.1 mi
Pret A Manger
Strand
0.1 mi
Pret A Manger
Chancery Lane 81
0.1 mi
EAT
Chancery Lane 77
0.1 mi
EAT
Fleet Street 170
0.2 mi
Pret A Manger
Fetter Lane 5453
0.2 mi
McDonald's
Fleet Street 152
0.2 mi
Wasabi
Fleet Street
0.2 mi
EAT
Fetter Lane 95

Supermarkets

0.1 mi
Holland & Barrett
Fetter Lane 146
0.2 mi
Sainsbury's
Fleet Street 77
0.2 mi
Sainsbury's
Fetter Lane 60
0.3 mi
Co-op Food - Holborn - Kingsway
18 Kingsway Holborn
0.3 mi
Sainsbury's Local
60 Fetter Lane
0.3 mi
Holland & Barrett
High Holborn 8
0.3 mi
Sainsbury's
Holborn 123
0.3 mi
Sainsbury's Local
123 Holborn
0.3 mi
Holland & Barrett
Ludgate Circus 5

Missing h2-29993 in pages/location

Missing h2-29993-p in pages/location

Q&A

Drainage Blast Ltd Q&A

Do you have any questions about Drainage Blast Ltd at 7, Bell Yard? Feel free to ask, and the owner or our community will provide you with an answer.

Route to 7, Bell Yard

Enter your address, click route, and you're on your way to Drainage Blast Ltd!

Map
Reviews
Reviews of   7, Bell Yard
0.00
No reviews
1   stars
0
2   stars
0
3   stars
0
4   stars
0
5   stars
0

How was your experience?

0   Reviews

Write a review
Back to Reviews
Review   7, Bell Yard

What do you think of:

Add photos - we love them!
Write a review
Reviewing   7, Bell Yard
Review posted

Thank you for your review. After checking, it will be published as soon as possible.

Close window
Request history8.2.28PHP Version607msRequest Duration7MBMemory UsageGET {route}Route
    • Booting (7.85ms)time
    • Application (599ms)time
    • 1 x Application (98.71%)
      599ms
      1 x Booting (1.29%)
      7.85ms
      164 templates were rendered
      • 1x pages.locationlocation.blade.php#?blade
      • 1x livewire.topbartopbar.blade.php#?blade
      • 1x components.login-buttonlogin-button.blade.php#?blade
      • 1x components.partials.hero-v2.texttext.blade.php#?blade
      • 3x components.common.reviews.starsstars.blade.php#?blade
      • 1x components.partials.location.open-closedopen-closed.blade.php#?blade
      • 1x livewire.common.share-buttonshare-button.blade.php#?blade
      • 1x livewire.common.save-to-listsave-to-list.blade.php#?blade
      • 1x components.modal.modal-report-locationmodal-report-location.blade.php#?blade
      • 1x components.partials.location.openinghoursopeninghours.blade.php#?blade
      • 1x components.common.ratingsratings.blade.php#?blade
      • 1x components.common.review-panelreview-panel.blade.php#?blade
      • 1x livewire.location.handy-nearbyhandy-nearby.blade.php#?blade
      • 45x components.partials.location.establishment-tabestablishment-tab.blade.php#?blade
      • 45x __components::5e93d402ed1f3da8a07f4840136a03cb5e93d402ed1f3da8a07f4840136a03cb.blade.php#?blade
      • 1x components.cards.image-cardsimage-cards.blade.php#?blade
      • 1x livewire.partials.question.questionsquestions.blade.php#?blade
      • 1x livewire.partials.question.qaqa.blade.php#?blade
      • 5x livewire.location.location-autocompletelocation-autocomplete.blade.php#?blade
      • 1x livewire.breadcrumbsbreadcrumbs.blade.php#?blade
      • 1x components.partials.footerfooter.blade.php#?blade
      • 1x components.maps.mapsmaps.blade.php#?blade
      • 1x components.maps.staticstatic.blade.php#?blade
      • 1x livewire.search.search-resultssearch-results.blade.php#?blade
      • 1x livewire.search.search-aroundsearch-around.blade.php#?blade
      • 3x components.img-responsiveimg-responsive.blade.php#?blade
      • 4x livewire.sidebar.cards.areaarea.blade.php#?blade
      • 10x livewire.sidebar.cards.categorycategory.blade.php#?blade
      • 1x components.popover.review.viewview.blade.php#?blade
      • 1x components.common.reviews.barsbars.blade.php#?blade
      • 1x components.popover.review.writewrite.blade.php#?blade
      • 1x components.popover.review.confirmconfirm.blade.php#?blade
      • 2x __components::1104a916f0c55dd05f91d3db3e3f592b1104a916f0c55dd05f91d3db3e3f592b.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
      • 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
      53 statements were executed (16 duplicates)Show only duplicates302ms
      • Connection Establishedhours_frontendDynamicRouteControllerDispatcher.php#39
        Backtrace
        • select * from `routes` where `route` = 'Drainage-Blast-Ltd/London/7-Bell-Yard' limit 1
          2.92mshours_frontendDynamicRouteControllerDispatcher.php#39
          Bindings
            Backtrace
            • update `routes` set `visit_count` = `visit_count` + 1, `routes`.`updated_at` = '2025-03-15 16:48:51' where `id` = 77395835
              610μshours_frontendDynamicRouteControllerDispatcher.php#43
              Bindings
                Backtrace
                • select * from `establishments` where `slug` = 'Drainage-Blast-Ltd/London/7-Bell-Yard' and `establishments`.`deleted_at` is null limit 1
                  680μshours_frontendBuildsGroupLimitQueries.php#38
                  Bindings
                    Backtrace
                    • select * from `regions` where `regions`.`id` = 101750367 limit 1
                      520μshours_frontendDynamicRouteControllerDispatcher.php#310
                      Bindings
                        Backtrace
                        • select * from `businesses` where `businesses`.`id` = 1853232 limit 1
                          430μshours_frontendBuildsGroupLimitQueries.php#38
                          Bindings
                            Backtrace
                            • select `categories`.*, `businesses`.`id` as `laravel_through_key` from `categories` inner join `businesses` on `businesses`.`category_id` = `categories`.`id` where `businesses`.`id` = 1853232 limit 1
                              580μshours_frontendBuildsGroupLimitQueries.php#38
                              Bindings
                                Backtrace
                                • select `attributes`.*, `attribute_establishment`.`establishment_hash` as `pivot_establishment_hash`, `attribute_establishment`.`attribute_id` as `pivot_attribute_id` from `attributes` inner join `attribute_establishment` on `attributes`.`id` = `attribute_establishment`.`attribute_id` where `attribute_establishment`.`establishment_hash` = '280673ff-269e-4a59-b257-5de78aafce01' and `subtype` in ('shopping area', 'shopping center/mall', 'living mall', 'shopping street', 'uk shopping street', 'uk shopping area', 'uk retail park', 'uk shopping park', 'uk shopping centre', 'uk leisure park', '0') order by `connected_locations` desc limit 1
                                  1.16mshours_frontendEstablishment.php#281
                                  Bindings
                                    Backtrace
                                    • select * from `regions` where `regions`.`id` = 1158859077 limit 1
                                      510μshours_frontendDynamicRouteControllerDispatcher.php#314
                                      Bindings
                                        Backtrace
                                        • select `reviews`.*, (select count(*) from `ratings` where `reviews`.`id` = `ratings`.`review_id`) as `ratings_count`, (select avg(`ratings`.`rating`) from `ratings` where `reviews`.`id` = `ratings`.`review_id`) as `ratings_avg_rating` from `reviews` where `reviews`.`reviewable_id` in ('280673ff-269e-4a59-b257-5de78aafce01') and `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`deleted_at` is null
                                          620μshours_frontendBusinessController.php#87
                                          Bindings
                                            Backtrace
                                            • select * from `questions` where `questions`.`questionable_id` in ('280673ff-269e-4a59-b257-5de78aafce01') and `questions`.`questionable_type` = 'App\\Models\\Establishment' and `questions`.`deleted_at` is null
                                              460μshours_frontendBusinessController.php#98
                                              Bindings
                                                Backtrace
                                                • select * from `categories` where `categories`.`id` = 100289 limit 1
                                                  380μshours_frontendBuildsGroupLimitQueries.php#38
                                                  Bindings
                                                    Backtrace
                                                    • select * from `regions` where `regions`.`id` = 101750367 limit 1
                                                      400μshours_frontendBusinessController.php#117
                                                      Bindings
                                                        Backtrace
                                                        • select * from `regions` where `type` = 'locality' and `regions`.`id` in (101750367)
                                                          420μshours_frontend356fe112bc062b18148dd6583d961031.php#9
                                                          Bindings
                                                            Backtrace
                                                            • select count(*) as aggregate from `regions` where `regions`.`locality_id` = 101750367 and `regions`.`locality_id` is not null and `type` = 'neighbourhood'
                                                              1.54mshours_frontendTopbar.php#78
                                                              Bindings
                                                                Backtrace
                                                                • select count(*) as aggregate from `attributes` where `attributes`.`locality_id` = 101750367 and `attributes`.`locality_id` is not null and `subtype` = 'uk shopping area'
                                                                  1.03mshours_frontendTopbar.php#84
                                                                  Bindings
                                                                    Backtrace
                                                                    • select count(*) as aggregate from `attributes` where `attributes`.`locality_id` = 101750367 and `attributes`.`locality_id` is not null and `subtype` = 'uk shopping street'
                                                                      840μshours_frontendTopbar.php#90
                                                                      Bindings
                                                                        Backtrace
                                                                        • select * from `regions` where `regions`.`id` = 1158859077 and `type` = 'neighbourhood' limit 1
                                                                          530μshours_frontendRegion.php#50
                                                                          Bindings
                                                                            Backtrace
                                                                            • select * from `regions` where `regions`.`id` = 1880762729 and `type` = 'region' limit 1
                                                                              500μshours_frontendRegion.php#51
                                                                              Bindings
                                                                                Backtrace
                                                                                • select * from `regions` where `regions`.`id` = 101750367 and `type` = 'locality' limit 1
                                                                                  420μ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
                                                                                      41.19mshours_frontendTranslations.php#17
                                                                                      Backtrace
                                                                                      • select * from `regions` where `regions`.`id` = 1158859077 limit 1
                                                                                        690μshours_frontend356fe112bc062b18148dd6583d961031.php#222
                                                                                        Bindings
                                                                                          Backtrace
                                                                                          • select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 3175866 and `establishment_departments`.`establishment_id` is not null limit 1
                                                                                            680μshours_frontenddd14a96e88664e934f656ffe283e69df.php#22
                                                                                            Bindings
                                                                                              Backtrace
                                                                                              • select * from `reviews` where `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`reviewable_id` = '280673ff-269e-4a59-b257-5de78aafce01' and `reviews`.`reviewable_id` is not null and `review` is not null and `review` != '' and `reviews`.`deleted_at` is null order by `created_at` desc
                                                                                                810μshours_frontend17277c34235421d97751feb36413b757.php#24
                                                                                                Bindings
                                                                                                  Backtrace
                                                                                                  • select * from `reviews` where `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`reviewable_id` = '280673ff-269e-4a59-b257-5de78aafce01' and `reviews`.`reviewable_id` is not null and `reviews`.`deleted_at` is null
                                                                                                    540μshours_frontend17277c34235421d97751feb36413b757.php#28
                                                                                                    Bindings
                                                                                                      Backtrace
                                                                                                      • select `attributes`.*, `attribute_establishment`.`establishment_hash` as `pivot_establishment_hash`, `attribute_establishment`.`attribute_id` as `pivot_attribute_id` from `attributes` inner join `attribute_establishment` on `attributes`.`id` = `attribute_establishment`.`attribute_id` where `attribute_establishment`.`establishment_hash` = '280673ff-269e-4a59-b257-5de78aafce01' and `subtype` in ('shopping area', 'shopping center/mall', 'living mall', 'shopping street', 'uk shopping street', 'uk shopping area', 'uk retail park', 'uk shopping park', 'uk shopping centre', 'uk leisure park', '0') order by `connected_locations` desc limit 1
                                                                                                        1.25mshours_frontendEstablishment.php#281
                                                                                                        Bindings
                                                                                                          Backtrace
                                                                                                          • select * from `categories` where `handy_nearby` = 1
                                                                                                            660μshours_frontendBuildsGroupLimitQueries.php#38
                                                                                                            Bindings
                                                                                                              Backtrace
                                                                                                              • select * from `categories` where `categories`.`id` in (1000003, 1000013, 1000015, 1000016)
                                                                                                                900μshours_frontendBuildsGroupLimitQueries.php#38
                                                                                                                Backtrace
                                                                                                                • select * from `categories` where `categories`.`id` = 1000008 limit 1
                                                                                                                  500μshours_frontendBuildsGroupLimitQueries.php#38
                                                                                                                  Bindings
                                                                                                                    Backtrace
                                                                                                                    • select establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point(-0.1117246, 51.5143544)) AS distance from `establishments` inner join `businesses` on `businesses`.`id` = `establishments`.`business_id` where `establishments`.`id` is not null and `category_id` = 100046 and `establishments`.`deleted_at` is null order by `distance` asc limit 9
                                                                                                                      23.63mshours_frontendBuildsGroupLimitQueries.php#38
                                                                                                                      Bindings
                                                                                                                        Backtrace
                                                                                                                        • select * from `businesses` where `businesses`.`id` in (892976, 892986, 893154, 893590, 893797, 1279302)
                                                                                                                          700μshours_frontendBuildsGroupLimitQueries.php#38
                                                                                                                          Backtrace
                                                                                                                          • select establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point(-0.1117246, 51.5143544)) AS distance from `establishments` inner join `businesses` on `businesses`.`id` = `establishments`.`business_id` where `establishments`.`id` is not null and `category_id` = 100209 and `establishments`.`deleted_at` is null order by `distance` asc limit 9
                                                                                                                            20mshours_frontendBuildsGroupLimitQueries.php#38
                                                                                                                            Bindings
                                                                                                                              Backtrace
                                                                                                                              • select * from `businesses` where `businesses`.`id` in (1215258, 1216061, 1216829, 1217957, 1218093, 1232751, 1232769, 1242239, 1259458)
                                                                                                                                770μshours_frontendBuildsGroupLimitQueries.php#38
                                                                                                                                Backtrace
                                                                                                                                • select establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point(-0.1117246, 51.5143544)) AS distance from `establishments` inner join `businesses` on `businesses`.`id` = `establishments`.`business_id` where `establishments`.`id` is not null and `category_id` = 100374 and `establishments`.`deleted_at` is null order by `distance` asc limit 9
                                                                                                                                  3.88mshours_frontendBuildsGroupLimitQueries.php#38
                                                                                                                                  Bindings
                                                                                                                                    Backtrace
                                                                                                                                    • select * from `businesses` where `businesses`.`id` in (893197)
                                                                                                                                      440μshours_frontendBuildsGroupLimitQueries.php#38
                                                                                                                                      Backtrace
                                                                                                                                      • select establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point(-0.1117246, 51.5143544)) AS distance from `establishments` inner join `businesses` on `businesses`.`id` = `establishments`.`business_id` where `establishments`.`id` is not null and `category_id` = 100394 and `establishments`.`deleted_at` is null order by `distance` asc limit 9
                                                                                                                                        55.86mshours_frontendBuildsGroupLimitQueries.php#38
                                                                                                                                        Bindings
                                                                                                                                          Backtrace
                                                                                                                                          • select * from `businesses` where `businesses`.`id` in (893122, 893326, 893511, 893798, 894217)
                                                                                                                                            720μshours_frontendBuildsGroupLimitQueries.php#38
                                                                                                                                            Backtrace
                                                                                                                                            • select establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point(-0.1117246, 51.5143544)) AS distance from `establishments` inner join `businesses` on `businesses`.`id` = `establishments`.`business_id` where `establishments`.`id` is not null and `category_id` = 100450 and `establishments`.`deleted_at` is null order by `distance` asc limit 9
                                                                                                                                              119mshours_frontendBuildsGroupLimitQueries.php#38
                                                                                                                                              Bindings
                                                                                                                                                Backtrace
                                                                                                                                                • select * from `businesses` where `businesses`.`id` in (892975, 893004, 1261917, 1272523)
                                                                                                                                                  680μshours_frontendBuildsGroupLimitQueries.php#38
                                                                                                                                                  Backtrace
                                                                                                                                                  • select * from `questions` where `questions`.`questionable_type` = 'App\\Models\\Establishment' and `questions`.`questionable_id` = '280673ff-269e-4a59-b257-5de78aafce01' and `questions`.`questionable_id` is not null and `questions`.`deleted_at` is null order by `created_at` desc
                                                                                                                                                    810μshours_frontendQa.php#25
                                                                                                                                                    Bindings
                                                                                                                                                      Backtrace
                                                                                                                                                      • select * from `questions` where `questions`.`questionable_type` = 'App\\Models\\Establishment' and `questions`.`questionable_id` = '280673ff-269e-4a59-b257-5de78aafce01' and `questions`.`questionable_id` is not null and `questions`.`deleted_at` is null order by `created_at` desc limit 3
                                                                                                                                                        560μshours_frontend4ab8d689553e1b9274c635a1c5492a5b.php#40
                                                                                                                                                        Bindings
                                                                                                                                                          Backtrace
                                                                                                                                                          • select * from `texts` where `texts`.`textable_type` = 'App\\Models\\Business' and `texts`.`textable_id` = 1853232 and `texts`.`textable_id` is not null
                                                                                                                                                            580μshours_frontendHasTexts.php#17
                                                                                                                                                            Bindings
                                                                                                                                                              Backtrace
                                                                                                                                                              • select * from `texts` where `texts`.`textable_type` = 'App\\Models\\Establishment' and `texts`.`textable_id` = 3175866 and `texts`.`textable_id` is not null and `slug` = 'business-about' limit 1
                                                                                                                                                                630μshours_frontendEstablishment.php#292
                                                                                                                                                                Bindings
                                                                                                                                                                  Backtrace
                                                                                                                                                                  • select * from `regions` where `regions`.`id` in (101750367)
                                                                                                                                                                    460μshours_frontend356fe112bc062b18148dd6583d961031.php#772
                                                                                                                                                                    Backtrace
                                                                                                                                                                    • select `categories`.*, `businesses`.`id` as `laravel_through_key` from `categories` inner join `businesses` on `businesses`.`category_id` = `categories`.`id` where `businesses`.`id` = 1853232 limit 1
                                                                                                                                                                      560μshours_frontendBuildsGroupLimitQueries.php#38
                                                                                                                                                                      Bindings
                                                                                                                                                                        Backtrace
                                                                                                                                                                        • select * from `static_maps` where (`longitude` = '-0.1117246' and `latitude` = '51.5143544' and `height` = 1200 and `width` = 1200) limit 1
                                                                                                                                                                          610μshours_frontendStaticMap.php#28
                                                                                                                                                                          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.23mshours_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.16mshours_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.36mshours_frontendUserLocation.php#78
                                                                                                                                                                                      Bindings
                                                                                                                                                                                        Backtrace
                                                                                                                                                                                        • select * from `reviews` where `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`reviewable_id` = '280673ff-269e-4a59-b257-5de78aafce01' and `reviews`.`reviewable_id` is not null and `review` is not null and `review` != '' and `reviews`.`deleted_at` is null order by `created_at` desc
                                                                                                                                                                                          700μshours_frontendbd02aa5f958fbb0dbcd1683300f93f26.php#31
                                                                                                                                                                                          Bindings
                                                                                                                                                                                            Backtrace
                                                                                                                                                                                            • select * from `reviews` where `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`reviewable_id` = '280673ff-269e-4a59-b257-5de78aafce01' and `reviews`.`reviewable_id` is not null and `reviews`.`deleted_at` is null
                                                                                                                                                                                              490μshours_frontendbd02aa5f958fbb0dbcd1683300f93f26.php#32
                                                                                                                                                                                              Bindings
                                                                                                                                                                                                Backtrace
                                                                                                                                                                                                • select * from `reviews` where `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`reviewable_id` = '280673ff-269e-4a59-b257-5de78aafce01' and `reviews`.`reviewable_id` is not null and `reviews`.`deleted_at` is null
                                                                                                                                                                                                  490μshours_frontendbd02aa5f958fbb0dbcd1683300f93f26.php#94
                                                                                                                                                                                                  Bindings
                                                                                                                                                                                                    Backtrace
                                                                                                                                                                                                    • select * from `reviews` where `reviews`.`reviewable_type` = 'App\\Models\\Establishment' and `reviews`.`reviewable_id` = '280673ff-269e-4a59-b257-5de78aafce01' and `reviews`.`reviewable_id` is not null and `reviews`.`deleted_at` is null
                                                                                                                                                                                                      490μshours_frontendbd02aa5f958fbb0dbcd1683300f93f26.php#105
                                                                                                                                                                                                      Bindings
                                                                                                                                                                                                        Backtrace
                                                                                                                                                                                                        • select * from `businesses` where `businesses`.`id` = 1853232 limit 1
                                                                                                                                                                                                          790μshours_frontendBuildsGroupLimitQueries.php#38
                                                                                                                                                                                                          Bindings
                                                                                                                                                                                                            Backtrace
                                                                                                                                                                                                            App\Models\Establishment
                                                                                                                                                                                                            46Establishment.php#?
                                                                                                                                                                                                            App\Models\Business
                                                                                                                                                                                                            27Business.php#?
                                                                                                                                                                                                            App\Models\Category
                                                                                                                                                                                                            13Category.php#?
                                                                                                                                                                                                            App\Models\Region
                                                                                                                                                                                                            11Region.php#?
                                                                                                                                                                                                            App\Models\Attribute
                                                                                                                                                                                                            2Attribute.php#?
                                                                                                                                                                                                            App\Models\Route
                                                                                                                                                                                                            1Route.php#?
                                                                                                                                                                                                            App\Models\EstablishmentDepartment
                                                                                                                                                                                                            1EstablishmentDepartment.php#?
                                                                                                                                                                                                            App\Models\StaticMap
                                                                                                                                                                                                            1StaticMap.php#?
                                                                                                                                                                                                            topbar #NOu58usbNpTFOefT56hx
                                                                                                                                                                                                            array:4 [ "data" => array:4 [ "user" => null "parent" => App\Models\Region {#2047 #c...
                                                                                                                                                                                                            common.share-button #GgaclUJgK0fBc6JaYJtG
                                                                                                                                                                                                            array:4 [ "data" => array:3 [ "currentUrl" => "https://alpha.hours.com/Drainage-Blast-Ltd/Lond...
                                                                                                                                                                                                            common.save-to-list #hDIti2cYzhlpR0zfo9CD
                                                                                                                                                                                                            array:4 [ "data" => array:3 [ "establishment" => App\Models\Establishment {#2019 #connec...
                                                                                                                                                                                                            location.handy-nearby #51q6haiKF0ZMcXO4sGkb
                                                                                                                                                                                                            array:4 [ "data" => array:2 [ "coordinates" => App\Support\Coordinates {#2059 +longitude...
                                                                                                                                                                                                            partials.question.questions #UUobwhGOQxmAfIILVP0I
                                                                                                                                                                                                            array:4 [ "data" => array:2 [ "entity" => App\Models\Establishment {#2019 #connection: "...
                                                                                                                                                                                                            partials.question.qa #e2XVV0telq9UFeAlheOc
                                                                                                                                                                                                            array:4 [ "data" => array:4 [ "entity" => "establishment" "object" => App\Models\Establish...
                                                                                                                                                                                                            location.location-autocomplete #pDikX7nFHtVNjkox0GSy
                                                                                                                                                                                                            array:4 [ "data" => array:5 [ "initialLocation" => "London, E1 8RU" "location" => "London,...
                                                                                                                                                                                                            breadcrumbs #2SJucj1HpRYLl8VaaOu7
                                                                                                                                                                                                            array:4 [ "data" => array:3 [ "parent" => App\Models\Establishment {#2019 #connection: "...
                                                                                                                                                                                                            search-results #gFw79wtp4wxHcsIj4Lwj
                                                                                                                                                                                                            array:4 [ "data" => array:6 [ "search" => "" "results" => [] "searchOverlayActive" => ...
                                                                                                                                                                                                            partials.search-around #I23pAUB8BV6x1xSGtgGa
                                                                                                                                                                                                            array:4 [ "data" => array:1 [ "userLocation" => array:4 [ "longitude" => -0.13184 ...
                                                                                                                                                                                                            sidebar.cards.area #ZqIh77vzOClFiVBMoWk8
                                                                                                                                                                                                            array:4 [ "data" => array:1 [ "area" => App\Models\Region {#6605 #connection: "mysql" ...
                                                                                                                                                                                                            sidebar.cards.area #9rGWgDlPmQFuiXE5aTgj
                                                                                                                                                                                                            array:4 [ "data" => array:1 [ "area" => App\Models\Region {#6609 #connection: "mysql" ...
                                                                                                                                                                                                            sidebar.cards.area #4D1iIMjTzsxmhr1R5Mxn
                                                                                                                                                                                                            array:4 [ "data" => array:1 [ "area" => App\Models\Attribute {#6676 #connection: "mysql"...
                                                                                                                                                                                                            sidebar.cards.area #Xw94d47BFds3tCImtZ8v
                                                                                                                                                                                                            array:4 [ "data" => array:1 [ "area" => App\Models\Attribute {#6732 #connection: "mysql"...
                                                                                                                                                                                                            sidebar.cards.category #JFslNrRbxJwJ4eHGvSUg
                                                                                                                                                                                                            array:4 [ "data" => array:2 [ "category" => App\Models\Category {#6614 #connection: "mys...
                                                                                                                                                                                                            sidebar.cards.category #gQA8F4pppSXWg8XNQ37r
                                                                                                                                                                                                            array:4 [ "data" => array:2 [ "category" => App\Models\Category {#6593 #connection: "mys...
                                                                                                                                                                                                            sidebar.cards.category #Jscu3iyXt4DiMff68l30
                                                                                                                                                                                                            array:4 [ "data" => array:2 [ "category" => App\Models\Category {#6915 #connection: "mys...
                                                                                                                                                                                                            sidebar.cards.category #cJ4wvuFNk3zmaeGKV2qI
                                                                                                                                                                                                            array:4 [ "data" => array:2 [ "category" => App\Models\Category {#6591 #connection: "mys...
                                                                                                                                                                                                            sidebar.cards.category #oVu6FUQdJfYfFfp6Trjc
                                                                                                                                                                                                            array:4 [ "data" => array:2 [ "category" => App\Models\Category {#6337 #connection: "mys...
                                                                                                                                                                                                            sidebar.cards.category #Ya8NGwMfXlD3GLG59PjQ
                                                                                                                                                                                                            array:4 [ "data" => array:2 [ "category" => App\Models\Category {#6336 #connection: "mys...
                                                                                                                                                                                                            sidebar.cards.category #8HuxNqLhtjQBwrWXiF6d
                                                                                                                                                                                                            array:4 [ "data" => array:2 [ "category" => App\Models\Category {#6335 #connection: "mys...
                                                                                                                                                                                                            sidebar.cards.category #YPwcKcLXaVmIkWPU70qf
                                                                                                                                                                                                            array:4 [ "data" => array:2 [ "category" => App\Models\Category {#6334 #connection: "mys...
                                                                                                                                                                                                            sidebar.cards.category #U35ndCQcDnoUQhP8XngN
                                                                                                                                                                                                            array:4 [ "data" => array:2 [ "category" => App\Models\Category {#6333 #connection: "mys...
                                                                                                                                                                                                            sidebar.cards.category #mq59rEkSFzrrA0YerZwe
                                                                                                                                                                                                            array:4 [ "data" => array:2 [ "category" => App\Models\Category {#6332 #connection: "mys...
                                                                                                                                                                                                            search #ulHUZjElLMkw37VORf7R
                                                                                                                                                                                                            array:4 [ "data" => array:1 [ "search" => "" ] "name" => "search" "component" => "App\Li...
                                                                                                                                                                                                            search #iQmaAJ5JrWKVO7aQrxJt
                                                                                                                                                                                                            array:4 [ "data" => array:1 [ "search" => "" ] "name" => "search" "component" => "App\Li...
                                                                                                                                                                                                            filter.filter #qZVYuKfWRdwWOllNXB71
                                                                                                                                                                                                            array:4 [ "data" => array:5 [ "hours" => 0 "filtersAreNotEmpty" => false "showFilter" ...
                                                                                                                                                                                                            filter.slide-in #hFpn2aYAHQZIEJi0s0gN
                                                                                                                                                                                                            array:4 [ "data" => array:8 [ "openFrom" => "" "openTo" => "" "dayRange" => "today" ...
                                                                                                                                                                                                            location.location-autocomplete #eEsWR6DsdQwqZJr54KiT
                                                                                                                                                                                                            array:4 [ "data" => array:5 [ "initialLocation" => "London, E1 8RU" "location" => "London,...
                                                                                                                                                                                                            sidebar.navigation #UBiWkJKngTVsm1TeQdOf
                                                                                                                                                                                                            array:4 [ "data" => [] "name" => "sidebar.navigation" "component" => "App\Livewire\Sidebar\Nav...
                                                                                                                                                                                                            modal.location #N64ZWnG9VWoEs6tLMSEj
                                                                                                                                                                                                            array:4 [ "data" => array:2 [ "classes" => [] "showModal" => false ] "name" => "modal....
                                                                                                                                                                                                            location.location-autocomplete #AFTmYN7jqkKjdaBtZrN8
                                                                                                                                                                                                            array:4 [ "data" => array:5 [ "initialLocation" => "London, E1 8RU" "location" => "London,...
                                                                                                                                                                                                            filter.filter #7PAHq4nry0RUvfUIOpXO
                                                                                                                                                                                                            array:4 [ "data" => array:5 [ "hours" => 0 "filtersAreNotEmpty" => false "showFilter" ...
                                                                                                                                                                                                            filter.slide-in #yo6D1IJ5EPe0IpHKgSfe
                                                                                                                                                                                                            array:4 [ "data" => array:8 [ "openFrom" => "" "openTo" => "" "dayRange" => "today" ...
                                                                                                                                                                                                            location.location-autocomplete #dSMMRRYOJFSNS5Brwqtt
                                                                                                                                                                                                            array:4 [ "data" => array:5 [ "initialLocation" => "London, E1 8RU" "location" => "London,...
                                                                                                                                                                                                            common.local-bar #3xW9SYPxqEqBtVUKykcD
                                                                                                                                                                                                            array:4 [ "data" => [] "name" => "common.local-bar" "component" => "App\Livewire\Common\LocalB...
                                                                                                                                                                                                            auth.signup #fMJpWJT2g7lewaPpFEWz
                                                                                                                                                                                                            array:4 [ "data" => [] "name" => "auth.signup" "component" => "App\Livewire\Auth\Signup" "id...
                                                                                                                                                                                                            auth.login #Zu3NpV7Euab7xO7mpdT8
                                                                                                                                                                                                            array:4 [ "data" => array:3 [ "email" => null "password" => null "class" => "" ] "...
                                                                                                                                                                                                            auth.onboarding #W2cyOG6nS5F8qGb1Niem
                                                                                                                                                                                                            array:4 [ "data" => array:6 [ "name" => null "classes" => [] "localities" => null ...
                                                                                                                                                                                                            location.location-autocomplete #pXKv6minCIFJXdicc67x
                                                                                                                                                                                                            array:4 [ "data" => array:5 [ "initialLocation" => "London, E1 8RU" "location" => "London,...
                                                                                                                                                                                                            auth.register #d5PkHgub9OgZmA5euf1n
                                                                                                                                                                                                            array:4 [ "data" => array:3 [ "email" => null "password" => null "class" => "" ] "...
                                                                                                                                                                                                            auth.forgot-password #c7bqaW6ZhMkialPgaVZE
                                                                                                                                                                                                            array:4 [ "data" => array:3 [ "email" => "" "class" => "" "successMessage" => null ]...
                                                                                                                                                                                                            auth.delete-account #zB2x3b3GyJfz13F0gvYK
                                                                                                                                                                                                            array:4 [ "data" => [] "name" => "auth.delete-account" "component" => "App\Livewire\Auth\Delet...
                                                                                                                                                                                                                _token
                                                                                                                                                                                                                RgQwV6h1AYFoRal1BzRt5cf9pmJCpRQPwTHy4pJE
                                                                                                                                                                                                                parent_page
                                                                                                                                                                                                                pages.location
                                                                                                                                                                                                                url
                                                                                                                                                                                                                array:1 [ "intended" => "https://alpha.hours.com/Drainage-Blast-Ltd/London/7-Bell-Yard" ]
                                                                                                                                                                                                                _previous
                                                                                                                                                                                                                array:1 [ "url" => "https://alpha.hours.com/Drainage-Blast-Ltd/London/7-Bell-Yard" ]
                                                                                                                                                                                                                _flash
                                                                                                                                                                                                                array:2 [ "old" => [] "new" => [] ]
                                                                                                                                                                                                                path_info
                                                                                                                                                                                                                /Drainage-Blast-Ltd/London/7-Bell-Yard
                                                                                                                                                                                                                status_code
                                                                                                                                                                                                                200
                                                                                                                                                                                                                
                                                                                                                                                                                                                status_text
                                                                                                                                                                                                                OK
                                                                                                                                                                                                                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 => "Sat, 15 Mar 2025 16:48:51 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=eyJpdiI6ImROdUZWSHhYd0kvVHVleGtTdjNHVmc9PSIsInZhbHVlIjoiY0F3V0R1SFJveU1jU0Z4ZzArM2tpSUltcVhxaUlUdU5heTJZbnhjS1BRUEJlbmRBMjN4Umd4RjN6Rjgzc2NsaVB0N3Z6dFZQUmdwdWRTdmk3bDZYZnpVekZ0d0V3aGFPUVQzbjd4NzdWekhrc1h2ejgvVFpDU0RkaXZhNzIxQmoiLCJtYWMiOiI4OTg2YzI1MmJiZWYzZGQwZGI4MzU2ZWEzN2ZmY2UyN2JiZTM0Y2ZmYjJlZGE1Y2VjNTNiYzY2YmM4NzQ3OTRiIiwidGFnIjoiIn0%3D; expires=Sat, 15 Mar 2025 18:48:52 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6ImROdUZWSHhYd0kvVHVleGtTdjNHVmc9PSIsInZhbHVlIjoiY0F3V0R1SFJveU1jU0Z4ZzArM2tpSUltcVhxaUlUdU5heTJZbnhjS1BRUEJlbmRBMjN4Umd4RjN6Rjgzc2NsaVB0N3Z6d" 1 => "hours_frontend_session=eyJpdiI6IkR1eStHdkpDT25hU3pUcnZ3SmI3b1E9PSIsInZhbHVlIjoiRG1UMGttYkphc0lFUngrT3p3T1lPbml0WmIwQXpDMXZEY2h0YkJjQWczbWJGOHRNUXpkMHpGa2VMUy8zUXZpL1JXNFZwRzVPZkVVK1VWeVlnbVFVNit0Mnc3ZEI1aEhQc2RWbm5BMHMxOFJib1VwdDVsb2JYcWdCMmk0RXdkYUEiLCJtYWMiOiI5YzgwMDdhZjRlMDEwYjZlMjlkMmM4M2YwYzdiYmU0Nzk2NjFiZGNjYzNlMDAwNDQzZmMxYTZmNjBiMTkyMzZlIiwidGFnIjoiIn0%3D; expires=Sat, 15 Mar 2025 18:48:52 GMT; Max-Age=7200; path=/; httponly; samesite=laxhours_frontend_session=eyJpdiI6IkR1eStHdkpDT25hU3pUcnZ3SmI3b1E9PSIsInZhbHVlIjoiRG1UMGttYkphc0lFUngrT3p3T1lPbml0WmIwQXpDMXZEY2h0YkJjQWczbWJGOHRNUXpkMHpGa2VMUy8zU" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImROdUZWSHhYd0kvVHVleGtTdjNHVmc9PSIsInZhbHVlIjoiY0F3V0R1SFJveU1jU0Z4ZzArM2tpSUltcVhxaUlUdU5heTJZbnhjS1BRUEJlbmRBMjN4Umd4RjN6Rjgzc2NsaVB0N3Z6dFZQUmdwdWRTdmk3bDZYZnpVekZ0d0V3aGFPUVQzbjd4NzdWekhrc1h2ejgvVFpDU0RkaXZhNzIxQmoiLCJtYWMiOiI4OTg2YzI1MmJiZWYzZGQwZGI4MzU2ZWEzN2ZmY2UyN2JiZTM0Y2ZmYjJlZGE1Y2VjNTNiYzY2YmM4NzQ3OTRiIiwidGFnIjoiIn0%3D; expires=Sat, 15-Mar-2025 18:48:52 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6ImROdUZWSHhYd0kvVHVleGtTdjNHVmc9PSIsInZhbHVlIjoiY0F3V0R1SFJveU1jU0Z4ZzArM2tpSUltcVhxaUlUdU5heTJZbnhjS1BRUEJlbmRBMjN4Umd4RjN6Rjgzc2NsaVB0N3Z6d" 1 => "hours_frontend_session=eyJpdiI6IkR1eStHdkpDT25hU3pUcnZ3SmI3b1E9PSIsInZhbHVlIjoiRG1UMGttYkphc0lFUngrT3p3T1lPbml0WmIwQXpDMXZEY2h0YkJjQWczbWJGOHRNUXpkMHpGa2VMUy8zUXZpL1JXNFZwRzVPZkVVK1VWeVlnbVFVNit0Mnc3ZEI1aEhQc2RWbm5BMHMxOFJib1VwdDVsb2JYcWdCMmk0RXdkYUEiLCJtYWMiOiI5YzgwMDdhZjRlMDEwYjZlMjlkMmM4M2YwYzdiYmU0Nzk2NjFiZGNjYzNlMDAwNDQzZmMxYTZmNjBiMTkyMzZlIiwidGFnIjoiIn0%3D; expires=Sat, 15-Mar-2025 18:48:52 GMT; path=/; httponlyhours_frontend_session=eyJpdiI6IkR1eStHdkpDT25hU3pUcnZ3SmI3b1E9PSIsInZhbHVlIjoiRG1UMGttYkphc0lFUngrT3p3T1lPbml0WmIwQXpDMXZEY2h0YkJjQWczbWJGOHRNUXpkMHpGa2VMUy8zU" ] ]
                                                                                                                                                                                                                session_attributes
                                                                                                                                                                                                                0 of 0
                                                                                                                                                                                                                array:5 [ "_token" => "RgQwV6h1AYFoRal1BzRt5cf9pmJCpRQPwTHy4pJE" "parent_page" => "pages.location" "url" => array:1 [ "intended" => "https://alpha.hours.com/Drainage-Blast-Ltd/London/7-Bell-Yard" ] "_previous" => array:1 [ "url" => "https://alpha.hours.com/Drainage-Blast-Ltd/London/7-Bell-Yard" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
                                                                                                                                                                                                                ClearShow all
                                                                                                                                                                                                                Date ↕MethodURLData
                                                                                                                                                                                                                #12025-03-15 16:48:52GET/Drainage-Blast-Ltd/London/7-Bell-Yard1645410243