Missing p-85876 in pages/attribute
0.0 km
0.0 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.0 km
0.0 km
0.1 km
0.1 km
0.1 km
0.1 km
0.1 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.64%) | 568ms |
| 1 x Booting (1.36%) | 7.80ms |
| Backtrace |
select * from `routes` where `route` = 'Noord-Holland/Hoorn/Winkelcentrum-De-Kersenboogerd' limit 1| Bindings | |
| Backtrace |
update `routes` set `visit_count` = `visit_count` + 1, `routes`.`updated_at` = '2025-04-05 23:38:02' where `id` = 262062| Bindings | |
| Backtrace |
select * from `establishments` where `slug` = 'Noord-Holland/Hoorn/Winkelcentrum-De-Kersenboogerd' and `establishments`.`deleted_at` is null limit 1| Bindings | |
| Backtrace |
select * from `regions` where `slug` = 'Noord-Holland/Hoorn/Winkelcentrum-De-Kersenboogerd' limit 1| Bindings | |
| Backtrace |
select * from `categories` where `slug` = 'Noord-Holland/Hoorn/Winkelcentrum-De-Kersenboogerd' limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `slug` = 'Noord-Holland/Hoorn/Winkelcentrum-De-Kersenboogerd' limit 1| Bindings | |
| Backtrace |
select * from `attributes` where `slug` = 'Noord-Holland/Hoorn/Winkelcentrum-De-Kersenboogerd' limit 1| Bindings | |
| Backtrace |
select * from `regions` where `regions`.`id` = 1158820021 limit 1| Bindings | |
| Backtrace |
select * from `regions` where `regions`.`id` = 101751883 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` = 1416 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` = 101751883 and `type` = 'locality' limit 1| Bindings | |
| Backtrace |
select count(*) as aggregate from `regions` where `regions`.`locality_id` = 101751883 and `regions`.`locality_id` is not null and `type` = 'neighbourhood'| Bindings | |
| Backtrace |
select count(*) as aggregate from `attributes` where `attributes`.`locality_id` = 101751883 and `attributes`.`locality_id` is not null and `subtype` = 'uk shopping area'| Bindings | |
| Backtrace |
select count(*) as aggregate from `attributes` where `attributes`.`locality_id` = 101751883 and `attributes`.`locality_id` is not null and `subtype` = 'uk shopping street'| Bindings | |
| Backtrace |
select * from `regions` where `regions`.`id` = 85687053 and `type` = 'region' limit 1| Bindings | |
| Backtrace |
select * from `regions` where `regions`.`id` = 101751883 and `type` = 'locality' limit 1| Bindings | |
| Backtrace |
select * from `regions` where `regions`.`id` = 1158820021 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` = 101751883 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('5.08567465', '52.65213220')) 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` = 1416 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('5.08567465', '52.65213220')) 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` = 1416 and `establishments`.`deleted_at` is null order by `distance` asc limit 4| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 11849 limit 1| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 987530 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 40724 limit 1| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 412502 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 5813 limit 1| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 522596 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 6001 limit 1| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 557159 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `static_maps` where (`longitude` = '5.08567465' and `latitude` = '52.65213220' 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, 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, 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, 8958, 1096738, 35124, 76462, 5688, 9220, 42979, 11502, 5815, 906310, 305733, 7196, 5696, 11820, 69087, 5845, 6082, 11594, 5731, 726312, 69943, 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, 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, 11641, 11668, 6174, 5972, 6242, 68319, 5780, 11665, 77692, 48178, 11661, 5827, 11596, 11637, 11609, 79190, 730349, 11682, 32779, 5650, 5973, 7996, 48136, 6564, 5706, 5740, 11674, 11660, 7997, 6077, 5697, 11575, 11655, 47494, 5829, 1096969, 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, 11657, 11663, 727916, 6077, 5814, 11647, 5972, 5744, 5700, 11676, 5791, 6092, 57349, 57329, 11649, 5716, 5814, 11588, 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 (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, 70653, 5697, 55104, 5811, 11758, 5925, 11591, 7996, 5816, 78209, 5994, 6069, 40529, 11720, 6059, 5713, 6049, 6179, 5861, 5780, 52593, 5770, 77692, 80240, 11594, 7832, 5782, 5777, 11720, 10117, 5721, 5742, 8212, 5816, 5815, 11556, 80240, 7306, 5667, 65181, 37281, 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, 5815, 11589, 6046, 68133, 12015, 1064160, 5712, 5827, 51867, 7780, 11503, 50666, 5816, 7196, 68850, 34091, 5888, 48031, 57349, 68983, 5825, 68523, 5814, 5925, 5814, 57349, 65372, 11853, 8481, 6109, 62127, 10824, 5745, 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, 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, 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, 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` = 1416 and `establishments`.`deleted_at` is null order by `average_rating` desc limit 9| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 5817 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 5839 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 40724 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 69090 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 36619 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 5814 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 11849 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 5813 limit 1| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` = 5863 limit 1| Bindings | |
| Backtrace |
select `business_id` from `establishments` where `establishments`.`locality_id` = 101751883 and `establishments`.`locality_id` is not null and `establishments`.`deleted_at` is null| Bindings | |
| Backtrace |
select * from `businesses` where `id` in (10048, 10287, 10360, 10741, 10779, 11166, 11502, 11637, 11718, 11723, 11758, 11758, 11834, 11834, 11835, 11849, 12014, 12015, 18143, 18190, 20424, 30853, 31241, 31363, 31406, 32163, 32248, 32361, 32549, 32683, 32694, 32917, 33454, 33764, 34673, 36017, 36162, 36619, 37454, 37537, 38712, 38824, 39587, 39709, 40034, 40645, 40724, 41630, 41788, 41804, 42084, 42151, 42439, 42496, 42556, 42654, 42979, 43093, 43279, 43371, 43600, 43627, 43837, 43844, 44066, 44114, 44169, 44295, 44376, 44792, 46382, 46957, 46962, 47231, 47309, 47369, 48101, 48102, 48415, 48585, 50071, 50676, 51895, 52174, 52210, 52685, 53060, 54818, 55222, 55325, 5652, 5652, 5652, 77692, 56606, 56610, 5685, 56878, 5692, 5694, 5695, 5697, 5700, 5706, 5706, 5708, 5711, 5712, 5713, 5715, 5724, 57349, 57349, 57349, 57349, 57349, 5739, 5743, 5743, 5744, 5744, 5749, 5749, 57528, 57543, 5758, 5759, 5760, 5770, 5773, 5773, 5775, 5778, 5780, 5788, 5789, 57936, 57974, 57982, 57989, 5799, 58008, 58011, 58050, 58056, 58072, 58088, 5813, 5813, 5814, 5814, 5816, 5822, 5823, 5825, 5827, 5839, 5845, 5849, 5851, 5861, 5861, 5863, 5869, 58987, 5933, 5958, 5961, 5965, 5966, 59691, 5970, 5975, 5980, 5994, 5994, 6001, 6001, 6011, 6016, 60073, 6024, 6057, 60576, 6059, 6068, 6068, 6069, 6081, 6095, 6095, 6132, 6142, 6143, 61475, 6154, 6165, 61784, 6179, 6181, 6185, 61908, 61942, 6242, 6255, 6311, 6423, 65073, 67540, 68509, 68651, 68697, 68739, 68828, 68983, 69053, 69248, 69247, 6944, 69611, 70249, 70451, 71063, 71281, 7196, 7217, 72487, 72778, 72831, 72832, 74826, 74831, 75267, 75368, 75503, 76804, 77014, 77015, 77041, 77621, 7781, 78748, 79048, 80240, 62766, 80632, 80697, 80711, 81031, 8113, 82011, 82692, 82798, 83037, 83036, 83428, 83443, 83471, 8354, 8445, 8464, 9624, 9883, 41761, 74989, 72804, 82015, 72662, 58055, 40843, 45898, 43474, 57961, 33692, 307824, 304548, 728825, 875230, 5739, 68651, 68651, 906394, 11849, 5811, 907303, 5772, 1064160, 69090, 5812, 5813, 1094327, 6082, 5815, 5829, 5655, 5823, 43155, 69090, 44477, 11789, 68779, 1105755, 1106213, 1106338, 1107605, 1107613, 72536, 1107711, 1107746, 1108142, 1108143, 1108855, 1109680, 1112103, 1112284, 5674, 11076, 6081, 1171681, 1171868, 5817, 5817, 5817, 5688, 5814, 5972, 80240, 80240, 1916506, 1919021, 5913, 80240, 1935159, 1111271, 5935, 5836, 7364, 5874, 70014, 5718) and exists (select * from `files` where `businesses`.`id` = `files`.`fileable_id` and `files`.`fileable_type` = 'App\\Models\\Business' and `type` = 'favicon') and `is_chain` = 1 order by `locations_count` desc limit 3| 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` = 1416 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` = 1416 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` = 1416 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` = 1416 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('5.08567465', '52.65213220')) 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` = 1416 and `establishments`.`deleted_at` is null order by `distance` asc limit 90| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` in (5775, 5813, 5814, 5817, 5839, 5863, 6001, 11849, 36619, 40724, 59691, 69090)| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 553463 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2158887 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 524216 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 538406 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 2092621 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 511697 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select * from `establishment_departments` where `establishment_departments`.`establishment_id` = 533786 and `establishment_departments`.`establishment_id` is not null| Bindings | |
| Backtrace |
select establishments.*, ST_Distance_Sphere(point(establishments.longitude, establishments.latitude), point('5.08567465', '52.65213220')) 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` = 1416 and `establishments`.`deleted_at` is null order by `distance` asc limit 90| Bindings | |
| Backtrace |
select * from `businesses` where `businesses`.`id` in (5775, 5813, 5814, 5817, 5839, 5863, 6001, 11849, 36619, 40724, 59691, 69090)| 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: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" ] ]
[]
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 => "Sat, 05 Apr 2025 23:38:02 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=eyJpdiI6ImlPNFJYOTZPckZIcWFZSDlDWnYzM0E9PSIsInZhbHVlIjoiV3pUdEo4aElTSzRwU0VUTG5aYSsxYjUwRlZyTkc1b3l6MTlQUUhMLzJwV3lBck5iZHNLMnd4aGxQbTMyUlJrVWloeFdpTzNzb3RKWjBEMEd6SGMvWXNUS3NxNndjWFRGWklHcGdOYmh5SHBWZC9WUWtaUnIweks4cldmRjlISXUiLCJtYWMiOiI3Y2EwMGQyZmIzZWQ3OWE2YTM1N2FiMzA5YjA4NTI0ODc4ZmRmY2FjYTRmYWYxY2I4Mzg4YWY4Yjc2YTE5NjQyIiwidGFnIjoiIn0%3D; expires=Sun, 06 Apr 2025 01:38:03 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImlPNFJYOTZPckZIcWFZSDlDWnYzM0E9PSIsInZhbHVlIjoiV3pUdEo4aElTSzRwU0VUTG5aYSsxYjUwRlZyTkc1b3l6MTlQUUhMLzJwV3lBck5iZHNLMnd4aGxQbTMyUlJrVWloeFdpT ▶" 1 => "hours_frontend_session=eyJpdiI6IkoxRzc1SWNFL3h3aE4zVTB4MGpJQUE9PSIsInZhbHVlIjoiYVdXZndBdUF6d2lBZUk3MWlMcU56RkVsb0lLK1VNSG5YaG1yTERmNUtwOVVGZExBcEJaVUEvWUZoajlLM1dwVnNhMUJZZSt6RDB6a0VVUGU4SjVhSVBOV0VSeVZuaWpGbWhRU0laZEVHM25PanF6S0V3TVVWQlpuZ2FwUFdFVi8iLCJtYWMiOiI4OTQ1YjNhYjRiYjJkNmJmMGRiNDRkMjViMzFjZDkwMmExNjViNGFmYTdlMTlhMWIzNmRhMTNjZjFkYzU1OWEyIiwidGFnIjoiIn0%3D; expires=Sun, 06 Apr 2025 01:38:03 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀hours_frontend_session=eyJpdiI6IkoxRzc1SWNFL3h3aE4zVTB4MGpJQUE9PSIsInZhbHVlIjoiYVdXZndBdUF6d2lBZUk3MWlMcU56RkVsb0lLK1VNSG5YaG1yTERmNUtwOVVGZExBcEJaVUEvWUZoajlLM ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImlPNFJYOTZPckZIcWFZSDlDWnYzM0E9PSIsInZhbHVlIjoiV3pUdEo4aElTSzRwU0VUTG5aYSsxYjUwRlZyTkc1b3l6MTlQUUhMLzJwV3lBck5iZHNLMnd4aGxQbTMyUlJrVWloeFdpTzNzb3RKWjBEMEd6SGMvWXNUS3NxNndjWFRGWklHcGdOYmh5SHBWZC9WUWtaUnIweks4cldmRjlISXUiLCJtYWMiOiI3Y2EwMGQyZmIzZWQ3OWE2YTM1N2FiMzA5YjA4NTI0ODc4ZmRmY2FjYTRmYWYxY2I4Mzg4YWY4Yjc2YTE5NjQyIiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 01:38:03 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6ImlPNFJYOTZPckZIcWFZSDlDWnYzM0E9PSIsInZhbHVlIjoiV3pUdEo4aElTSzRwU0VUTG5aYSsxYjUwRlZyTkc1b3l6MTlQUUhMLzJwV3lBck5iZHNLMnd4aGxQbTMyUlJrVWloeFdpT ▶" 1 => "hours_frontend_session=eyJpdiI6IkoxRzc1SWNFL3h3aE4zVTB4MGpJQUE9PSIsInZhbHVlIjoiYVdXZndBdUF6d2lBZUk3MWlMcU56RkVsb0lLK1VNSG5YaG1yTERmNUtwOVVGZExBcEJaVUEvWUZoajlLM1dwVnNhMUJZZSt6RDB6a0VVUGU4SjVhSVBOV0VSeVZuaWpGbWhRU0laZEVHM25PanF6S0V3TVVWQlpuZ2FwUFdFVi8iLCJtYWMiOiI4OTQ1YjNhYjRiYjJkNmJmMGRiNDRkMjViMzFjZDkwMmExNjViNGFmYTdlMTlhMWIzNmRhMTNjZjFkYzU1OWEyIiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 01:38:03 GMT; path=/; httponly ◀hours_frontend_session=eyJpdiI6IkoxRzc1SWNFL3h3aE4zVTB4MGpJQUE9PSIsInZhbHVlIjoiYVdXZndBdUF6d2lBZUk3MWlMcU56RkVsb0lLK1VNSG5YaG1yTERmNUtwOVVGZExBcEJaVUEvWUZoajlLM ▶" ] ]
0 of 0array:5 [▼ "_token" => "mukDTxdiw0VUq8t4ETGkRvPL7tTu0k2V8Jx87n3K" "parent_page" => "pages.attribute" "url" => array:1 [▶ "intended" => "https://alpha.hours.com/Noord-Holland/Hoorn/Winkelcentrum-De-Kersenboogerd" ] "_previous" => array:1 [▶ "url" => "https://alpha.hours.com/Noord-Holland/Hoorn/Winkelcentrum-De-Kersenboogerd" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] ]