MORE
MORE
| Company Name | Address | Date Established | Revenue to Date |
|---|---|---|---|
Filter
| 1 x Application (92.38%) | 799ms |
| 1 x Booting (7.61%) | 65.85ms |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
select `name` from `categories` where `slug` = 'american'| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `id` from `categories` where `slug` = 'american'| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `id` from `businesses` where `parent_category_id` = 399| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `merchant_analytics` where `user_ip` = '3.137.170.78' and `module_id` = 399 and `module_type` = 'category' and `module_sub_type` = 'view' and `listing_id` is null and date(`created_at`) = '2025-05-07'| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
insert into `merchant_analytics` (`user_ip`, `user_id`, `module_id`, `module_type`, `module_sub_type`, `listing_id`, `updated_at`, `created_at`) values ('3.137.170.78', '', 399, 'category', 'view', '', '2025-05-07 07:18:06', '2025-05-07 07:18:06')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `locations` where `slug` = 'emerald-coast' limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `images` where (`status` = 1 and `payment_status` = 1 and `type` = 'sub_category_banner') and date(`expired_at`) >= '2025-05-07' order by RAND() limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select exists(select * from `categories` where `slug` = 'american' and `parent_id` is not null) as `exists`| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `categories` where `slug` = 'american' and `parent_id` is not null and `parent_id` is not null limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `id`, `name` from `pricing_options` where `pricing_options`.`name` in ('Exclusive', 'Gold', 'Silver', 'Bronze', 'Free')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `businesses` where (`location` = 1 and (`sub_category_id` = 399 and `pricing_option` in (1, 10, 11)) or exists (select * from `listings` where `businesses`.`id` = `listings`.`business_id` and `sub_category_id` = 399 and `pricing_option` in (1, 10, 11))) and `is_published` = 1 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `value`, `name` from `settings`| Metadata | |
|---|---|
| Backtrace |
|
select `value`, `name` from `settings`| Metadata | |
|---|---|
| Backtrace |
|
select `value`, `name` from `settings`| Metadata | |
|---|---|
| Backtrace |
|
select `value`, `name` from `settings`| Metadata | |
|---|---|
| Backtrace |
|
select `value`, `name` from `settings`| Metadata | |
|---|---|
| Backtrace |
|
select `value`, `name` from `settings`| Metadata | |
|---|---|
| Backtrace |
|
select `value`, `name` from `settings`| Metadata | |
|---|---|
| Backtrace |
|
select count(*) as aggregate from `businesses` where `status` != 'Suspended' and `location` = 1 and (`sub_category_id` = 399 or exists (select * from `listings` where `businesses`.`id` = `listings`.`business_id` and `sub_category_id` = 399)) and (`parent_category_id` = 27 or exists (select * from `listings` where `businesses`.`id` = `listings`.`business_id` and `parent_category_id` = 27)) and `is_published` = 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `businesses` where `status` != 'Suspended' and `location` = 1 and (`sub_category_id` = 399 or exists (select * from `listings` where `businesses`.`id` = `listings`.`business_id` and `sub_category_id` = 399)) and (`parent_category_id` = 27 or exists (select * from `listings` where `businesses`.`id` = `listings`.`business_id` and `parent_category_id` = 27)) and `is_published` = 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `businesses` where `status` != 'Suspended' and `location` = 1 and (`sub_category_id` = 399 or exists (select * from `listings` where `businesses`.`id` = `listings`.`business_id` and `sub_category_id` = 399)) and (`parent_category_id` = 27 or exists (select * from `listings` where `businesses`.`id` = `listings`.`business_id` and `parent_category_id` = 27)) and `is_published` = 1 order by (SELECT sorting_order FROM pricing_options WHERE pricing_options.id = businesses.pricing_option) limit 15 offset 0| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `discounts` where `discounts`.`business_id` in (14350, 14592, 14593, 14594, 14595, 14596, 14597, 14598, 14599, 14600, 14601, 14602, 14603, 14604, 14605)| Metadata | |
|---|---|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` in (14350, 14592, 14593, 14594, 14595, 14596, 14597, 14598, 14599, 14600, 14601, 14602, 14603, 14604, 14605)| Metadata | |
|---|---|
| Backtrace |
|
select * from `events` where `is_published` = '1' and `events`.`business_id` in (14350, 14592, 14593, 14594, 14595, 14596, 14597, 14598, 14599, 14600, 14601, 14602, 14603, 14604, 14605)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `jobs` where `is_published` = '1' and `jobs`.`business_id` in (14350, 14592, 14593, 14594, 14595, 14596, 14597, 14598, 14599, 14600, 14601, 14602, 14603, 14604, 14605)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `discounts` where (`is_published` = 1 and `expired` = 0) and `discounts`.`business_id` in (14350, 14592, 14593, 14594, 14595, 14596, 14597, 14598, 14599, 14600, 14601, 14602, 14603, 14604, 14605)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `categories` where `type` = 'business' and `parent_id` is null and `deleted_at` is null order by `name` asc, `created_at` desc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `categories` where `deleted_at` is null and `categories`.`parent_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33) order by RAND()| Metadata | |
|---|---|
| Backtrace |
|
select `name`, `id` from `categories` where `parent_id` = 27 order by `name` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `name`, `id` from `categories` where `parent_id` = 27 order by `name` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `cities`.`name` as `city_name` from `cities` inner join `locations` on `cities`.`location_id` = `locations`.`id` order by `city_name` asc| Metadata | |
|---|---|
| Backtrace |
|
select * from `additional_infos` where `category_id` = 399| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `categories` where `categories`.`id` in (399)| Metadata | |
|---|---|
| Backtrace |
|
select * from `additional_infos` where `category_id` = 399| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `categories` where `categories`.`id` in (399)| Metadata | |
|---|---|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14592 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (2, 6, 8, 9) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14593 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (2, 6, 8, 9) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14594 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (2, 6, 8, 9) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14595 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (2, 6, 8, 9) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14596 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (2, 6, 8, 9) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14597 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (2, 6, 8, 9) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14598 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (2, 6, 8, 9) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14599 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (2, 6, 8, 9) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14600 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (2, 6, 8, 9) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14601 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (2, 6, 8, 9) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14602 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (2, 6, 8, 9) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14603 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (2, 6, 8, 9) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14604 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (2, 6, 8, 9) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14605 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (2, 6, 8, 9) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14350 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (2, 6, 8, 9) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14592 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (3, 7, 14, 15) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14592 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (4, 16, 17) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14593 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (3, 7, 14, 15) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14593 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (4, 16, 17) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14594 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (3, 7, 14, 15) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14594 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (4, 16, 17) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14595 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (3, 7, 14, 15) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14595 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (4, 16, 17) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14596 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (3, 7, 14, 15) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14596 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (4, 16, 17) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14597 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (3, 7, 14, 15) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14597 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (4, 16, 17) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14598 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (3, 7, 14, 15) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14598 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (4, 16, 17) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14599 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (3, 7, 14, 15) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14599 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (4, 16, 17) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14600 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (3, 7, 14, 15) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14600 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (4, 16, 17) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14601 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (3, 7, 14, 15) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14601 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (4, 16, 17) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14602 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (3, 7, 14, 15) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14602 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (4, 16, 17) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14603 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (3, 7, 14, 15) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14603 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (4, 16, 17) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14604 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (3, 7, 14, 15) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14604 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (4, 16, 17) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14605 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (3, 7, 14, 15) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14605 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (4, 16, 17) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14350 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (3, 7, 14, 15) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `listings` where `listings`.`business_id` = 14350 and `listings`.`business_id` is not null and `sub_category_id` = 399 and `pricing_option` in (4, 16, 17) limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `locations` where `status` = 'active'| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `locations` where `status` = 'active'| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
200
0 of 0array:1 [▼ "location" => "emerald-coast" ]
0 of 0array:1 [▼ "location" => "emerald-coast" ]
0 of 0array:16 [▼ "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" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] "content-length" => array:1 [▶ 0 => "0" ] "host" => array:1 [▶ 0 => "demo.parentlivingplus.com" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "sec-ch-ua" => array:1 [▶ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "priority" => array:1 [▶ 0 => "u=0, i" ] ]
0 of 0array:70 [▼ "LSPHP_ENABLE_USER_INI" => "on" "PATH" => "/usr/local/bin:/usr/bin:/bin" "TEMP" => "/tmp" "TMP" => "/tmp" "TMPDIR" => "/tmp" "PWD" => "/" "HTTP_ACCEPT" => "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" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "CONTENT_LENGTH" => "0" "HTTP_HOST" => "demo.parentlivingplus.com" "HTTP_PRAGMA" => "no-cache" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_PRIORITY" => "u=0, i" "REDIRECT_UNIQUE_ID" => "aBtPfpPvwCu9Pk4pMZHVCgABxQA" "REDIRECT_QS_ConnectionId" => "174662028677515668715533" "REDIRECT_HTTPS" => "on" "REDIRECT_SSL_TLS_SNI" => "demo.parentlivingplus.com" "REDIRECT_HTTP2" => "on" "REDIRECT_H2PUSH" => "off" "REDIRECT_H2_PUSH" => "off" "REDIRECT_H2_PUSHED" => "" "REDIRECT_H2_PUSHED_ON" => "" "REDIRECT_H2_STREAM_ID" => "1" "REDIRECT_H2_STREAM_TAG" => "715533-913-1" "REDIRECT_STATUS" => "200" "UNIQUE_ID" => "aBtPfpPvwCu9Pk4pMZHVCgABxQA" "QS_ConnectionId" => "174662028677515668715533" "HTTPS" => "on" "SSL_TLS_SNI" => "demo.parentlivingplus.com" "HTTP2" => "on" "H2PUSH" => "off" "H2_PUSH" => "off" "H2_PUSHED" => "" "H2_PUSHED_ON" => "" "H2_STREAM_ID" => "1" "H2_STREAM_TAG" => "715533-913-1" "SERVER_SIGNATURE" => "" "SERVER_SOFTWARE" => "Apache" "SERVER_NAME" => "demo.parentlivingplus.com" "SERVER_ADDR" => "162.241.248.17" "SERVER_PORT" => "443" "REMOTE_ADDR" => "3.137.170.78" "DOCUMENT_ROOT" => "/home3/itsyoux2/demo.parentlivingplus.com" "REQUEST_SCHEME" => "https" "CONTEXT_PREFIX" => "" "CONTEXT_DOCUMENT_ROOT" => "/home3/itsyoux2/demo.parentlivingplus.com" "SERVER_ADMIN" => "webmaster@demo.parentlivingplus.com" "SCRIPT_FILENAME" => "/home3/itsyoux2/demo.parentlivingplus.com/public/index.php" "REMOTE_PORT" => "64039" "REDIRECT_URL" => "/public/detail/american" "REDIRECT_QUERY_STRING" => "location=emerald-coast" "SERVER_PROTOCOL" => "HTTP/2.0" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "location=emerald-coast" "REQUEST_URI" => "/public/detail/american?location=emerald-coast" "SCRIPT_NAME" => "/public/index.php" "PHP_SELF" => "/public/index.php" "REQUEST_TIME_FLOAT" => 1746620286.7889 "REQUEST_TIME" => 1746620286 "argv" => array:1 [▶ 0 => "location=emerald-coast" ] "argc" => 1 ]
[]
0 of 0array:5 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Wed, 07 May 2025 12:18:07 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Ind5R0RkZlo5d0poSzVHL1VnRW5GQWc9PSIsInZhbHVlIjoiOXVwOXk3SkJJYTFYRUhnTTRaOHI0b1RyVUxna2NwcnBaQzdwcmZZUzFveStPcUlBV2ZmaXlSaGVLcFh5UnROUjRTbTdjblJzb2NPcTZYVHpUdFNLbER0RDA0UmR4US9meXVBZWVzUElVNzNKcGh5cVlpTlpCdzVyRHhFMHc1SkIiLCJtYWMiOiI2Mjk5MzBkZTYyZGMxOTQwODRiMTEyMmZkMzk1ZTQ1M2E2NGNmNGQ4NGNmZTkzZjQ0YWUyOWE2M2M0NjgxYThlIiwidGFnIjoiIn0%3D; expires=Wed, 14-May-2025 12:18:07 GMT; Max-Age=604800; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Ind5R0RkZlo5d0poSzVHL1VnRW5GQWc9PSIsInZhbHVlIjoiOXVwOXk3SkJJYTFYRUhnTTRaOHI0b1RyVUxna2NwcnBaQzdwcmZZUzFveStPcUlBV2ZmaXlSaGVLcFh5UnROUjRTbTdjb ▶" 1 => "parent_living_plus_session=eyJpdiI6Im1tRFJUWHBLNStKcTdReWt5Nng3a0E9PSIsInZhbHVlIjoiMUZGakhNK0lLdVVMeTR4VmN3Ylgzc1NvUFB1eWVQYXZTYTJCK3NtQVpjTDN3akpRTDAzQkJ5bjY0bmorSHFrS0RwSHBydDBZVzlzNVdFTk5CWDRFUy9BSE1lRHhRNHlFTkdxdytTamJ6bXh5UGNKTit2SzV1NFJadVZUaDl0YjMiLCJtYWMiOiIzMDU5MWZmZThkZWQwNGQ2NzFlMzc0NTA3MWM1YmU4MjZlYTZlMTNlOWIyNzZkZDU0ZTZlNjBkZTgwZTExMTI0IiwidGFnIjoiIn0%3D; expires=Wed, 14-May-2025 12:18:07 GMT; Max-Age=604800; path=/; httponly; samesite=lax ◀parent_living_plus_session=eyJpdiI6Im1tRFJUWHBLNStKcTdReWt5Nng3a0E9PSIsInZhbHVlIjoiMUZGakhNK0lLdVVMeTR4VmN3Ylgzc1NvUFB1eWVQYXZTYTJCK3NtQVpjTDN3akpRTDAzQkJ5bjY0b ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Ind5R0RkZlo5d0poSzVHL1VnRW5GQWc9PSIsInZhbHVlIjoiOXVwOXk3SkJJYTFYRUhnTTRaOHI0b1RyVUxna2NwcnBaQzdwcmZZUzFveStPcUlBV2ZmaXlSaGVLcFh5UnROUjRTbTdjblJzb2NPcTZYVHpUdFNLbER0RDA0UmR4US9meXVBZWVzUElVNzNKcGh5cVlpTlpCdzVyRHhFMHc1SkIiLCJtYWMiOiI2Mjk5MzBkZTYyZGMxOTQwODRiMTEyMmZkMzk1ZTQ1M2E2NGNmNGQ4NGNmZTkzZjQ0YWUyOWE2M2M0NjgxYThlIiwidGFnIjoiIn0%3D; expires=Wed, 14-May-2025 12:18:07 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ind5R0RkZlo5d0poSzVHL1VnRW5GQWc9PSIsInZhbHVlIjoiOXVwOXk3SkJJYTFYRUhnTTRaOHI0b1RyVUxna2NwcnBaQzdwcmZZUzFveStPcUlBV2ZmaXlSaGVLcFh5UnROUjRTbTdjb ▶" 1 => "parent_living_plus_session=eyJpdiI6Im1tRFJUWHBLNStKcTdReWt5Nng3a0E9PSIsInZhbHVlIjoiMUZGakhNK0lLdVVMeTR4VmN3Ylgzc1NvUFB1eWVQYXZTYTJCK3NtQVpjTDN3akpRTDAzQkJ5bjY0bmorSHFrS0RwSHBydDBZVzlzNVdFTk5CWDRFUy9BSE1lRHhRNHlFTkdxdytTamJ6bXh5UGNKTit2SzV1NFJadVZUaDl0YjMiLCJtYWMiOiIzMDU5MWZmZThkZWQwNGQ2NzFlMzc0NTA3MWM1YmU4MjZlYTZlMTNlOWIyNzZkZDU0ZTZlNjBkZTgwZTExMTI0IiwidGFnIjoiIn0%3D; expires=Wed, 14-May-2025 12:18:07 GMT; path=/; httponly ◀parent_living_plus_session=eyJpdiI6Im1tRFJUWHBLNStKcTdReWt5Nng3a0E9PSIsInZhbHVlIjoiMUZGakhNK0lLdVVMeTR4VmN3Ylgzc1NvUFB1eWVQYXZTYTJCK3NtQVpjTDN3akpRTDAzQkJ5bjY0b ▶" ] ]
0 of 0array:6 [▼ "_token" => "IEX02TZqqmU4npXDFOfEylmauf72GVV2FS36CzXS" "category" => 27 "sub_category" => 399 "_previous" => array:1 [▶ "url" => "https://demo.parentlivingplus.com/public/detail/american?location=emerald-coast" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]