Missing p-85876 in pages/attribute
0.1 km
0.1 km
Missing p-14387 in pages/attribute
Missing p-98723 in pages/attribute
Missing 69245-p in livewire/partials/join-us
Bedankt voor je beoordeling. Na controle wordt deze zo snel mogelijk gepubliceerd.
0.1 km
0.1 km
0.1 km
0.2 km
0.2 km
Als je verdergaat, ga je akkoord met onzeGebruiksvoorwaardenen bevestig je dat je onzePrivacy- en cookieverklaringhebt gelezen.
Meld je aan om het meeste uit Openingstijden.nl te halen.
Inloggenmet Openingstijden.nl account
Als je verdergaat, ga je akkoord met onzeGebruiksvoorwaardenen bevestig je dat je onzePrivacy- en cookieverklaringhebt gelezen.
All your data will be deleted. You will not be able to undo this action.
| 1 x Application (98.85%) | 711ms |
| 1 x Booting (1.16%) | 8.32ms |
| Backtrace |
select * from `routes` where `route` = 'Noord-Holland/Amsterdam/De-Jan-Eef' limit 1| Bindings | |
| Backtrace |
update `routes` set `visit_count` = `visit_count` + 1, `routes`.`updated_at` = '2025-04-09 12:21:29' where `id` = 310376| Bindings | |
| Backtrace |
select * from `establishments` where `slug` = 'Noord-Holland/Amsterdam/De-Jan-Eef' and `establishments`.`deleted_at` is null limit 1| Bindings | |
| Backtrace |
select * from `regions` where `slug` = 'Noord-Holland/Amsterdam/De-Jan-Eef' limit 1| Bindings | |
| Backtrace |
select * from `categories` where `slug` = 'Noord-Holland/Amsterdam/De-Jan-Eef' limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `slug` = 'Noord-Holland/Amsterdam/De-Jan-Eef' limit 1| Bindings | |
| Backtrace |
select * from `attributes` where `slug` = 'Noord-Holland/Amsterdam/De-Jan-Eef' limit 1| Bindings | |
| Backtrace |
select * from `regions` where `regions`.`id` = 1108802827 limit 1| Bindings | |
| Backtrace |
select * from `regions` where `regions`.`id` = 101751893 limit 1| Bindings | |
| Backtrace |
select * from `regions` where `regions`.`id` = 85687053 limit 1| Bindings | |
| Backtrace |
select * from `reviews` where `reviews`.`reviewable_type` = 'App\\Models\\Attribute' and `reviews`.`reviewable_id` = 1655 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| Bindings | |
| Backtrace |
select * from `regions` where `regions`.`id` = 101751893 and `type` = 'locality' limit 1| Bindings | |
| Backtrace |
select count(*) as aggregate from `regions` where `regions`.`locality_id` = 101751893 and `regions`.`locality_id` is not null and `type` = 'neighbourhood'| Bindings | |
| Backtrace |
select count(*) as aggregate from `attributes` where `attributes`.`locality_id` = 101751893 and `attributes`.`locality_id` is not null and `subtype` = 'uk shopping area'| Bindings | |
| Backtrace |
select count(*) as aggregate from `attributes` where `attributes`.`locality_id` = 101751893 and `attributes`.`locality_id` is not null and `subtype` = 'uk shopping street'| Bindings | |
| Backtrace |
select * from `regions` where `regions`.`id` = 1108802827 and `type` = 'neighbourhood' limit 1| Bindings | |
| Backtrace |
select * from `regions` where `regions`.`id` = 85687053 and `type` = 'region' limit 1| Bindings | |
| Backtrace |
select * from `regions` where `regions`.`id` = 101751893 and `type` = 'locality' limit 1| 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| Backtrace |
select establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('4.85378945', '52.37063190')) AS distance, `attribute_establishment`.`attribute_id` as `pivot_attribute_id`, `attribute_establishment`.`establishment_hash` as `pivot_establishment_hash` from `establishments` inner join `attribute_establishment` on `establishments`.`hash` = `attribute_establishment`.`establishment_hash` where `attribute_establishment`.`attribute_id` = 1655 and `establishments`.`deleted_at` is null order by `distance` asc limit 4| Bindings | |
| Backtrace |
select establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('4.85378945', '52.37063190')) AS distance, `attribute_establishment`.`attribute_id` as `pivot_attribute_id`, `attribute_establishment`.`establishment_hash` as `pivot_establishment_hash` from `establishments` inner join `attribute_establishment` on `establishments`.`hash` = `attribute_establishment`.`establishment_hash` where `attribute_establishment`.`attribute_id` = 1655 and `establishments`.`deleted_at` is null order by `distance` asc limit 4| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 5813 limit 1| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2098900 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 12292 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 5814 limit 1| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 523976 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 47827 limit 1| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 437924 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `static_maps` where (`longitude` = '4.85378945' and `latitude` = '52.37063190' and `height` = 1200 and `width` = 1200) limit 1| Bindings | |
| Backtrace |
select * from `attributes` where `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 6| Bindings | |
| Backtrace |
select * from `regions` where `regions`.`id` = 101752763 limit 1| Bindings | |
| Backtrace |
select `business_id` from `establishments` inner join `attribute_establishment` on `establishments`.`hash` = `attribute_establishment`.`establishment_hash` where `attribute_establishment`.`attribute_id` = 1799 and `establishments`.`deleted_at` is null| Bindings | |
| Backtrace |
select * from `businesses` where `favicon` is not null and `id` in (11637, 19591, 5811, 5712, 5925, 5768, 8354, 11758, 43825, 7306, 68781, 53277, 8771, 47486, 78307, 77692, 5716, 5817, 46953, 1613674, 5777, 11591, 12339, 69152, 305733, 34512, 8809, 8924, 18430, 8956, 6132, 6069, 1170501, 5716, 5777, 5819, 5716, 8829, 1109193, 68413, 7996, 40915, 5813, 8768, 5861, 36884, 5937, 6075, 296349, 879362, 1161570, 5814, 5849, 1106736, 81110, 6011, 11600, 11588, 11676, 5937, 5827, 80979, 55275, 48136, 5895, 7677, 6084, 7666, 5662, 5874, 11503, 5688, 5812, 47775, 6297, 6185, 6283, 8840, 5814, 11826, 5750, 8550, 68809, 5667, 54707, 80376, 5815, 5692, 5825, 77692, 1108898, 6014, 8462, 7217, 5777, 48095, 47878, 80376, 730037, 6984, 6051, 6542, 5670, 19569, 5816, 5761, 5932, 5772, 5697, 48300, 11720, 51241, 5751, 81289, 878047, 50901, 39454, 11870, 78331, 5770, 5752, 6874, 5688, 82901, 5659, 47774, 11568, 48469, 5961, 11506, 5925, 7958, 5846, 1053909, 9400, 6069, 11337, 5694, 68828, 50132, 48186, 5706, 83171, 11556, 32890, 47885, 9991, 47860, 11514, 11610, 5688, 51819, 1115954, 5780, 81592, 5655, 8770, 62947, 47922, 80168, 68913, 68699, 5655, 8253, 37486, 81220, 47499, 47773, 12164, 11748, 11819, 38739, 8464, 1109187, 5875, 8958, 1096738, 35124, 76462, 5688, 9220, 42979, 11502, 5815, 906310, 305733, 7196, 5696, 11820, 69087, 5845, 6082, 11594, 5731, 726312, 69943, 5723, 68850, 5822, 10719, 33437, 8454, 1171090, 69261, 6019, 39585) order by `locations_count` desc limit 3| Bindings | |
| Backtrace |
select * from `regions` where `regions`.`id` = 101751887 limit 1| Bindings | |
| Backtrace |
select `business_id` from `establishments` inner join `attribute_establishment` on `establishments`.`hash` = `attribute_establishment`.`establishment_hash` where `attribute_establishment`.`attribute_id` = 1410 and `establishments`.`deleted_at` is null| Bindings | |
| Backtrace |
select * from `businesses` where `favicon` is not null and `id` in (59986, 68509, 8748, 6106, 5696, 5715, 5698, 7781, 8746, 8726, 9106, 5822, 8730, 5731, 71088, 5721, 44520, 5761, 39435, 8691, 72754, 5696, 8689, 70039, 57349, 60002, 78459, 34769, 8740, 70039, 12014, 9665, 43155, 9079, 8757, 5694, 82302, 5813, 76352, 5974, 5861, 5814, 35049, 8755, 68983, 11515, 49766, 8726, 6396, 8752, 68697, 6132, 6132, 5791, 46494, 6171, 11591, 5812, 8739, 57324, 38741, 34362, 65645, 50139, 6796, 5819, 38286, 61324, 5723, 7163, 44490, 5930, 5872, 8749, 76310, 49684, 8733, 76391, 5793, 9093, 68692, 8712, 8731, 9080, 6301, 7217, 5845, 77692, 11503, 9105, 5815, 8253, 76462, 77207, 11600, 1115820, 8775, 5816, 5777, 48300, 59958, 65181, 1170485, 47996, 11761, 56828, 8690, 9132, 8723, 5799, 7997, 6016, 62442, 6059, 5780, 8724, 49375, 1111339, 47376, 5768, 8760, 5768, 35377, 11402, 76334, 8725, 9129, 6185, 8735, 5817, 11782, 10029, 7196, 42664, 8481, 11022, 70985, 38267, 8756, 5706, 10029, 81521, 6024, 45053, 11588, 60528, 9071, 43155, 80240, 42979, 5750, 5801, 5744, 74841, 6321, 5875, 6069, 10805, 6418, 5849, 8688, 5872, 33498, 6014, 7530, 9107, 48136, 51222, 9094, 5814, 8719, 6090, 83700, 11758, 6082, 68651, 5800, 83171, 1617083, 68911, 11637, 11337, 43155, 11758, 907298, 5752, 48569, 7306, 52746, 34177, 5825, 50748, 8745, 906310, 60737, 59998, 5994, 11505, 9440, 11579, 11257, 43155, 52685, 52593, 5961, 5925, 9635, 9080, 6003, 5777, 7364, 8727, 43178, 6011, 8753, 11502, 5655) order by `locations_count` desc limit 3| Bindings | |
| Backtrace |
select * from `regions` where `regions`.`id` = 101751843 limit 1| Bindings | |
| Backtrace |
select `business_id` from `establishments` inner join `attribute_establishment` on `establishments`.`hash` = `attribute_establishment`.`establishment_hash` where `attribute_establishment`.`attribute_id` = 2113 and `establishments`.`deleted_at` is null| Bindings | |
| Backtrace |
select * from `businesses` where `favicon` is not null and `id` in (5771, 11553, 5715, 11646, 79485, 11679, 11642, 48300, 5812, 11600, 11664, 11634, 5979, 5759, 5799, 11599, 11659, 5884, 5987, 11631, 47914, 11677, 11654, 11635, 11644, 5935, 11641, 11668, 6174, 5935, 5972, 6242, 68319, 5780, 11665, 77692, 48178, 11750, 11661, 5827, 11596, 5819, 11637, 11609, 79190, 730349, 11682, 32779, 5650, 5973, 7996, 48136, 6564, 5706, 5740, 11674, 11660, 7997, 6077, 5697, 11575, 11655, 47494, 5829, 1096969, 5688, 5842, 6011, 11666, 5768, 5773, 65149, 6094, 11652, 5777, 11632, 10478, 42979, 11656, 6081, 5815, 11662, 11645, 11681, 11975, 11671, 6079, 11638, 5752, 65181, 5767, 5716, 6075, 5766, 75287, 5811, 11658, 11669, 5850, 11678, 10645, 5694, 6035, 5816, 12537, 5813, 5817, 8214, 5998, 65181, 11672, 6094, 11650, 11670, 5723, 11657, 11663, 727916, 6077, 5814, 11647, 5972, 5744, 5700, 11676, 5791, 6092, 57349, 57329, 11649, 5716, 5814, 11588, 5874, 5983, 11675, 5655, 11667, 11640, 11653, 48175, 11651, 5845, 11673, 11090, 57349, 6069, 5692, 12015, 5763) order by `locations_count` desc limit 3| Bindings | |
| Backtrace |
select * from `regions` where `regions`.`id` = 1158787345 limit 1| Bindings | |
| Backtrace |
select `business_id` from `establishments` inner join `attribute_establishment` on `establishments`.`hash` = `attribute_establishment`.`establishment_hash` where `attribute_establishment`.`attribute_id` = 1685 and `establishments`.`deleted_at` is null| Bindings | |
| Backtrace |
select * from `businesses` where `favicon` is not null and `id` in (5819, 68850, 5812, 5817, 5933, 6171, 6003, 5751, 5731, 5825, 5749, 8481, 46817, 8253, 5759, 10945, 52685, 8464, 6068, 46510, 11750, 5814, 6016, 8354, 11588, 6095, 5750, 7306, 5791, 5752, 68916, 5779, 80240, 44905, 80240, 77652, 5715, 5813, 6185, 71128, 47406, 5724, 5813, 5814, 77692, 48136, 5845, 78167, 6109, 58426, 5766, 5845, 30954, 5874, 70653, 5697, 55104, 5811, 11758, 5925, 11591, 7996, 5816, 78209, 5994, 6069, 40529, 11720, 6059, 5713, 6049, 6179, 5861, 5780, 52593, 5770, 5723, 77692, 80240, 11594, 7832, 5782, 5777, 11720, 10117, 5721, 5742, 8212, 5816, 5815, 11556, 80240, 7306, 5667, 65181, 37281, 5935, 69090, 43155, 10220, 68064, 907303, 5780, 5653, 5726, 42979, 1073051, 68731, 69090, 81110, 5655, 11600, 6011) order by `locations_count` desc limit 3| Bindings | |
| Backtrace |
select * from `regions` where `regions`.`id` = 101751829 limit 1| Bindings | |
| Backtrace |
select `business_id` from `establishments` inner join `attribute_establishment` on `establishments`.`hash` = `attribute_establishment`.`establishment_hash` where `attribute_establishment`.`attribute_id` = 1713 and `establishments`.`deleted_at` is null| Bindings | |
| Backtrace |
select * from `businesses` where `favicon` is not null and `id` in (5888, 5895, 5716, 10902, 5922, 5724, 54581, 875230, 5815, 11589, 6046, 68133, 12015, 1064160, 5712, 5827, 51867, 7780, 11503, 5908, 50666, 5816, 7196, 68850, 34091, 5888, 48031, 57349, 68983, 5825, 68523, 5814, 5925, 5814, 57349, 65372, 11853, 8481, 6109, 62127, 10824, 5745, 5949, 41118, 7779, 52685, 10797, 5752, 5823, 11600, 5782, 5800, 75064, 6001, 5749, 5799, 5694, 11502, 43155, 1115859, 62191, 35394, 62057, 5713, 5905, 11720, 5692, 76920, 5811, 5655, 5672, 5780, 6082, 6059, 6097, 5782, 5723, 5716, 11752, 5659, 48136, 10899, 82816, 5738, 5731, 5956, 5770, 10288, 68916, 69086, 5778, 1114633, 6090, 62070, 75389, 5688, 6016, 1172341, 5957, 43155, 5716, 5726, 62766, 46298, 43155, 5715, 6069, 6179) order by `locations_count` desc limit 3| Bindings | |
| Backtrace |
select * from `regions` where `regions`.`id` = 101751871 limit 1| Bindings | |
| Backtrace |
select `business_id` from `establishments` inner join `attribute_establishment` on `establishments`.`hash` = `attribute_establishment`.`establishment_hash` where `attribute_establishment`.`attribute_id` = 1923 and `establishments`.`deleted_at` is null| Bindings | |
| Backtrace |
select * from `businesses` where `favicon` is not null and `id` in (5825, 11337, 7217, 5813, 69087, 6014, 5872, 9141, 5957, 5849, 5904, 6016, 9206, 76810, 5913, 5692, 7997, 5715, 48136, 5812, 68913, 9139, 5773, 8464, 59110, 11637, 7996, 5819, 5815, 6011, 43311, 5674, 5655, 6069, 7693, 11870, 5709, 9143, 5849, 906310, 5697, 5688, 6478, 6313, 6082, 9209, 5672, 36889, 5846, 5651, 53294, 9142, 11579, 11588, 5932, 48300, 5712, 308898, 42979, 11600, 5780, 5814, 5659, 7100, 59435, 5811, 68983, 5822, 5814, 5750, 5870, 5823, 60530, 5844, 5672, 69090, 5814, 34988, 5817, 5672, 37627, 5723, 39838, 5731, 5777, 5791, 5696, 7196, 50220, 7306, 5935, 5961, 50965, 8253, 5770, 11591, 36941, 5925, 5799, 7307, 5752, 5761, 68386, 10288, 59065, 10658, 11557, 76462, 5845, 9178, 5814, 6229, 6011, 57186, 77692, 48888, 5713) order by `locations_count` desc limit 3| 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`, `attribute_establishment`.`attribute_id` as `pivot_attribute_id`, `attribute_establishment`.`establishment_hash` as `pivot_establishment_hash` from `establishments` inner join `attribute_establishment` on `establishments`.`hash` = `attribute_establishment`.`establishment_hash` where `attribute_establishment`.`attribute_id` = 1655 and `establishments`.`deleted_at` is null order by `average_rating` desc limit 9| Bindings | |
| Backtrace |
select establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('4.85378945', '52.37063190')) AS distance from `establishments` where `id` not in (377429, 2850287, 2098900, 523976, 437924, 389684) and `establishments`.`deleted_at` is null order by `distance` asc limit 3| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 12292 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 5744 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 5813 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 5814 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 47827 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 33280 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 5823 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 907108 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 5816 limit 1| Bindings | |
| Backtrace |
select *, ST_Distance_Sphere(point(longitude, latitude), point(4.895168, 52.370216)) AS distance from `regions` where `type` = 'locality' order by `distance` asc limit 1| Bindings | |
| Backtrace |
select *, ST_Distance_Sphere(point(longitude, latitude), point(4.895168, 52.370216)) AS distance from `regions` where `type` = 'neighbourhood' order by `distance` asc limit 1| Bindings | |
| Backtrace |
select *, ST_Distance_Sphere(point(longitude, latitude), point(4.895168, 52.370216)) AS distance from `attributes` where `subtype` = 'uk shopping area' order by `distance` asc limit 2| Bindings | |
| Backtrace |
select * from `reviews` where `reviews`.`reviewable_type` = 'App\\Models\\Attribute' and `reviews`.`reviewable_id` = 1655 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| Bindings | |
| Backtrace |
select * from `reviews` where `reviews`.`reviewable_type` = 'App\\Models\\Attribute' and `reviews`.`reviewable_id` = 1655 and `reviews`.`reviewable_id` is not null and `reviews`.`deleted_at` is null| Bindings | |
| Backtrace |
select * from `reviews` where `reviews`.`reviewable_type` = 'App\\Models\\Attribute' and `reviews`.`reviewable_id` = 1655 and `reviews`.`reviewable_id` is not null and `reviews`.`deleted_at` is null| Bindings | |
| Backtrace |
select * from `reviews` where `reviews`.`reviewable_type` = 'App\\Models\\Attribute' and `reviews`.`reviewable_id` = 1655 and `reviews`.`reviewable_id` is not null and `reviews`.`deleted_at` is null| Bindings | |
| Backtrace |
select establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('4.85378945', '52.37063190')) AS distance, `attribute_establishment`.`attribute_id` as `pivot_attribute_id`, `attribute_establishment`.`establishment_hash` as `pivot_establishment_hash` from `establishments` inner join `attribute_establishment` on `establishments`.`hash` = `attribute_establishment`.`establishment_hash` where `attribute_establishment`.`attribute_id` = 1655 and `establishments`.`deleted_at` is null order by `distance` asc limit 90| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` in (5744, 5813, 5814, 12292, 33280, 47827)| Backtrace |
select establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('4.85378945', '52.37063190')) AS distance from `establishments` where `id` not in (2098900, 377429, 523976, 437924, 2850287, 389684) and `establishments`.`deleted_at` is null order by `distance` asc limit 3| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2850287 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 389684 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 5823 limit 1| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 529514 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 907108 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 5816 limit 1| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 527399 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('4.85378945', '52.37063190')) AS distance, `attribute_establishment`.`attribute_id` as `pivot_attribute_id`, `attribute_establishment`.`establishment_hash` as `pivot_establishment_hash` from `establishments` inner join `attribute_establishment` on `establishments`.`hash` = `attribute_establishment`.`establishment_hash` where `attribute_establishment`.`attribute_id` = 1655 and `establishments`.`deleted_at` is null order by `distance` asc limit 90| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` in (5744, 5813, 5814, 12292, 33280, 47827)| Backtrace |
select establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('4.85378945', '52.37063190')) AS distance from `establishments` where `id` not in (2098900, 377429, 523976, 437924, 2850287, 389684) and `establishments`.`deleted_at` is null order by `distance` asc limit 3| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 5823 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 907108 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 5816 limit 1| Bindings | |
| Backtrace |
select * from `regions` where `regions`.`id` = 85687053 limit 1| Bindings | |
| Backtrace |
select * from `regions` where `regions`.`id` = 85687053 limit 1| Bindings | |
| Backtrace |
200
[]
[]
0 of 0array:16 [▼ "cookie" => array:1 [▶ 0 => "_pk_id.3.58f2=ebca14998660c2cd.1744201267.; _pk_ses.3.58f2=1; XSRF-TOKEN=eyJpdiI6IndMeGZqbnVZTU1zak81OGdEWTc3alE9PSIsInZhbHVlIjoiV0JzMHhGUmNZa2Q2cSthV1dUTWdoY1lpWHpLZFFlUzVaUjJialRTNWJRZUE3NG9kZXJaSFByTkVvb3FlaGdMeE1MRktJcFB1N0xyNjRUelRVK3ZjVDVFVEpvV0pITXRYYzB5OWY4aUlneGVyNG5teU5HZnpqTkJhUmVhRzYwd1giLCJtYWMiOiJhNzU3NDgzOGU1YTc4ZjM1M2NmMWU4NTkxMTAxMzVmMWIzY2FlZjllYmQ5YTEwYjhlOWMyMzI3NjU1YTE0ZWIwIiwidGFnIjoiIn0%3D; hours_frontend_session=eyJpdiI6IkdEWjdHK0tyemd6VmFUNEpKY21IMFE9PSIsInZhbHVlIjoiMk5UNXBHcDN3djBtalViZUVNdjkybFc1bnIzdnZqWDE4MlpaUHlSU1JuNnh5NXd1TE8yUFZBQ2VjVDArS3RzWGFPcXE0ak5rWEJMVE8waXhuSEdGdElTU2xtT1FVMGJYaUd6TlVFYUx3VCt3a215VGVCdzU2eHR0SmJZeEpQdXUiLCJtYWMiOiIxOWQ0MTI0ZGE0ZjViYzYxZTc4ODViNGUyZmM5ODUyNDhjN2RkYzQxYjIyNTVhZTY5Y2VhNDkzOTdhODRiMWU2IiwidGFnIjoiIn0%3D ◀_pk_id.3.58f2=ebca14998660c2cd.1744201267.; _pk_ses.3.58f2=1; XSRF-TOKEN=eyJpdiI6IndMeGZqbnVZTU1zak81OGdEWTc3alE9PSIsInZhbHVlIjoiV0JzMHhGUmNZa2Q2cSthV1dUTWdoY1l ▶" ] "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" ] ]
0 of 0array:4 [▼ "_pk_id_3_58f2" => null "_pk_ses_3_58f2" => null "XSRF-TOKEN" => "qtlZecrX0HW3KceIkYZLRmjvnceFXtnxYcJ96dqs" "hours_frontend_session" => "REW1pqDW8nnfuPPYKPhcMP0v0XRfTX6LurFTDVN0" ]
0 of 0array: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 => "Wed, 09 Apr 2025 12:21:29 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=eyJpdiI6Imx5VERxb3FKdGNWVFRmRkJUOWx2N3c9PSIsInZhbHVlIjoiWElWb2pqcFh4eVVWdVlCQXFWbjZwamJjeDlMWEdhaXFRZ3JyeWtiZjI3WXdzSm8yelZObEZMUnBuMStEdFZ2cm1meFpHYkpqenlZSnMxL3VLUndmbHlrK3JuT1JvMEpkeHRkcGVnbCtiWlh1bUJ6UlZJejRSMU1obFBveGhDSE4iLCJtYWMiOiI4ZWMzOWIyYWVlYTIyYjA2YTQ5ZjU0YjNmOWJjOGMxZmUxNWZkMjZlZjIxNjc0YzMwODFjYmJjYTYwZjg3OTY1IiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 14:21:29 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Imx5VERxb3FKdGNWVFRmRkJUOWx2N3c9PSIsInZhbHVlIjoiWElWb2pqcFh4eVVWdVlCQXFWbjZwamJjeDlMWEdhaXFRZ3JyeWtiZjI3WXdzSm8yelZObEZMUnBuMStEdFZ2cm1meFpHY ▶" 1 => "hours_frontend_session=eyJpdiI6ImdjcjJUcjlQNkVSa0JnK0FlTTFSc2c9PSIsInZhbHVlIjoiZGZFb2Y5VE41dDM1L3pIREhUKzg5UFNoZUxPK0Z3NDF6cHpQZVhsYUJGbnpMOXZVVThkemhYYXlRVXVBTzY2WVNUcHJEYm40TmtuTW9qTWtPdVMvbFhxV2RGK0wwV2VJTTdvc1FoU1ZWME5iNTluVGtCNXZLcFU3S1JVUEVDZDMiLCJtYWMiOiJmY2E0ZTAxYjE4NDM1ZjNkNDFlNTM1MzVkM2Q3NTI3MmFlZDIzMGUzOTE1MzQ2OTBkMzRhYTA1OWQwYzE1NGZmIiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 14:21:29 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀hours_frontend_session=eyJpdiI6ImdjcjJUcjlQNkVSa0JnK0FlTTFSc2c9PSIsInZhbHVlIjoiZGZFb2Y5VE41dDM1L3pIREhUKzg5UFNoZUxPK0Z3NDF6cHpQZVhsYUJGbnpMOXZVVThkemhYYXlRVXVBT ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Imx5VERxb3FKdGNWVFRmRkJUOWx2N3c9PSIsInZhbHVlIjoiWElWb2pqcFh4eVVWdVlCQXFWbjZwamJjeDlMWEdhaXFRZ3JyeWtiZjI3WXdzSm8yelZObEZMUnBuMStEdFZ2cm1meFpHYkpqenlZSnMxL3VLUndmbHlrK3JuT1JvMEpkeHRkcGVnbCtiWlh1bUJ6UlZJejRSMU1obFBveGhDSE4iLCJtYWMiOiI4ZWMzOWIyYWVlYTIyYjA2YTQ5ZjU0YjNmOWJjOGMxZmUxNWZkMjZlZjIxNjc0YzMwODFjYmJjYTYwZjg3OTY1IiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 14:21:29 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6Imx5VERxb3FKdGNWVFRmRkJUOWx2N3c9PSIsInZhbHVlIjoiWElWb2pqcFh4eVVWdVlCQXFWbjZwamJjeDlMWEdhaXFRZ3JyeWtiZjI3WXdzSm8yelZObEZMUnBuMStEdFZ2cm1meFpHY ▶" 1 => "hours_frontend_session=eyJpdiI6ImdjcjJUcjlQNkVSa0JnK0FlTTFSc2c9PSIsInZhbHVlIjoiZGZFb2Y5VE41dDM1L3pIREhUKzg5UFNoZUxPK0Z3NDF6cHpQZVhsYUJGbnpMOXZVVThkemhYYXlRVXVBTzY2WVNUcHJEYm40TmtuTW9qTWtPdVMvbFhxV2RGK0wwV2VJTTdvc1FoU1ZWME5iNTluVGtCNXZLcFU3S1JVUEVDZDMiLCJtYWMiOiJmY2E0ZTAxYjE4NDM1ZjNkNDFlNTM1MzVkM2Q3NTI3MmFlZDIzMGUzOTE1MzQ2OTBkMzRhYTA1OWQwYzE1NGZmIiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 14:21:29 GMT; path=/; httponly ◀hours_frontend_session=eyJpdiI6ImdjcjJUcjlQNkVSa0JnK0FlTTFSc2c9PSIsInZhbHVlIjoiZGZFb2Y5VE41dDM1L3pIREhUKzg5UFNoZUxPK0Z3NDF6cHpQZVhsYUJGbnpMOXZVVThkemhYYXlRVXVBT ▶" ] ]
0 of 0array:5 [▼ "_token" => "qtlZecrX0HW3KceIkYZLRmjvnceFXtnxYcJ96dqs" "parent_page" => "pages.attribute" "url" => array:1 [▶ "intended" => "https://alpha.hours.com/Noord-Holland/Amsterdam/De-Jan-Eef" ] "_previous" => array:1 [▶ "url" => "https://alpha.hours.com/Noord-Holland/Amsterdam/De-Jan-Eef" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] ]