823
Modular Sectional
F1550
Barstool
F1552
F1553
F6402
2-Pcs Sofa Set
F6581
3-Pcs Sectional Set
F6582
F6584
2-PCS Sectional Sofa Set
F6649
Motion Sectional
F6650
F6703
F6743
F8512
ADJUSTABLE SOFA
F8513
F86626
3-Pcs Power Reclining Sectional
products
productCount
promotionLabel
promotionProducts
poundexSettings
companyListing
productSort
__env
app
errors
categories
dealerGuide
__sentry_tracing_view_name
__currentLoopData
product
loop
paginator
elements
items
options
alerts
select * from `category` where (`active` = 1 and `level` = 'main') order by `order` asc
select * from `category` where (`active` = 1 and `level` = 'sub') order by `order` asc
select * from `dealer_guides` where (`file_type` = 'Flipbook' and `active` = 1) order by `id` desc
select `promotion_products`, `promotion_label` from `banners` where (`active` = 1 and `id` = '111' and `link_option` = 'Add Products') limit 1
select count(*) as aggregate from `products` inner join `product_boxes` on `product_boxes`.`product_id` = `products`.`id` where (`products`.`in_catalog` = 1 and `products`.`product_view` = 'available') and `products`.`item_number` in ('F8513', 'F8512', 'F4563', 'F6402', 'F86626', 'F6584', '823', 'F6743', 'F6703', 'F6650', 'F6649', 'F6582', 'F6581', 'F1553', 'F1552', 'F1550') and `product_boxes`.`parent_child` = 'p'
select distinct `products`.`id` as `product_id`, `products`.`name`, `products`.`slug`, `products`.`image`, `products`.`item_number`, `products`.`base_price`, `products`.`quantity`, `products`.`block_cart_view`, `products`.`product_view`, `products`.`in_catalog`, `products`.`unit_per_case`, CASE WHEN "2025-04-04" >= products.discounted_start_date AND (products.discounted_end_date IS NULL OR "2025-04-04" <= products.discounted_end_date) THEN round(products.discounted_percentage,0) ELSE 0 END AS discounted_percentage, CASE WHEN "2025-04-04" >= products.discounted_start_date AND (products.discounted_end_date IS NULL OR "2025-04-04" <= products.discounted_end_date) AND products.discounted_price < products.base_price THEN products.discounted_price ELSE 0 END AS discounted_price, CASE WHEN "2025-04-04" >= products.discounted_start_date AND (products.discounted_end_date IS NULL OR "2025-04-04" <= products.discounted_end_date) AND products.discounted_price < products.base_price THEN products.discounted_price ELSE products.base_price END AS final_price from `products` inner join `product_boxes` on `product_boxes`.`product_id` = `products`.`id` where (`products`.`in_catalog` = 1 and `products`.`product_view` = 'available') and `products`.`item_number` in ('F8513', 'F8512', 'F4563', 'F6402', 'F86626', 'F6584', '823', 'F6743', 'F6703', 'F6650', 'F6649', 'F6582', 'F6581', 'F1553', 'F1552', 'F1550') and `product_boxes`.`parent_child` = 'p' order by `products`.`item_number` asc limit 30 offset 0
select CASE WHEN "2025-04-04" >= products.discounted_start_date AND (products.discounted_end_date IS NULL OR "2025-04-04" <= products.discounted_end_date) AND products.discounted_price < products.base_price THEN products.discounted_price ELSE products.base_price END AS final_price from `products` inner join `product_boxes` on `product_boxes`.`product_id` = `products`.`id` where (`products`.`in_catalog` = 1 and `products`.`product_view` = 'available') and `products`.`item_number` in ('F8513', 'F8512', 'F4563', 'F6402', 'F86626', 'F6584', '823', 'F6743', 'F6703', 'F6650', 'F6649', 'F6582', 'F6581', 'F1553', 'F1552', 'F1550') and `product_boxes`.`parent_child` = 'p'
select * from `poundex_settings` where `id` = 1 limit 1
200
[]
0 of 0 array:15 [▼ "connection" => array:1 [▶ 0 => "upgrade" ] "host" => array:1 [▶ 0 => "bobkonaonline.com" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "sec-ch-ua" => array:1 [▶ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "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" ] "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" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] ]
0 of 0 array:42 [▼ "REDIRECT_UNIQUE_ID" => "Z-_ztWWzYtQt-CmVYCxdVwAAAAE" "REDIRECT_STATUS" => "200" "UNIQUE_ID" => "Z-_ztWWzYtQt-CmVYCxdVwAAAAE" "HTTP_CONNECTION" => "upgrade" "HTTP_HOST" => "bobkonaonline.com" "HTTP_PRAGMA" => "no-cache" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "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_SEC_FETCH_SITE" => "none" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin" "SERVER_SIGNATURE" => "" "SERVER_SOFTWARE" => "Apache/2.4.62 () OpenSSL/1.0.2k-fips PHP/8.2.27" "SERVER_NAME" => "bobkonaonline.com" "SERVER_ADDR" => "127.0.0.1" "SERVER_PORT" => "80" "REMOTE_ADDR" => "127.0.0.1" "DOCUMENT_ROOT" => "/home/poundex-staging/laravel-ecommerce/public/" "REQUEST_SCHEME" => "http" "CONTEXT_PREFIX" => "" "CONTEXT_DOCUMENT_ROOT" => "/home/poundex-staging/laravel-ecommerce/public/" "SERVER_ADMIN" => "root@localhost" "SCRIPT_FILENAME" => "/home/poundex-staging/laravel-ecommerce/public/index.php" "REMOTE_PORT" => "60354" "REDIRECT_URL" => "/promotion-landing-page/111" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/promotion-landing-page/111" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1743778741.4684 "REQUEST_TIME" => 1743778741 ]
0 of 0 array:5 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Fri, 04 Apr 2025 14:59:01 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Ik5zSGlwUkJJdXBlOXVuTWZtZm1QUEE9PSIsInZhbHVlIjoiS2xTRlUyUHg1ZDVJcnE2dUM5blBqZHZpOTVIZTNPNjdSR3IycFUvUGlxcDRrUDV3endDQjZhOEcvNGNkSXd3eWRoWjBjRFFGdGEvOXFSRVBSKzJCa1RoMER3ZlVwd0VBRnpucEpYT2pDTDd6OTFJR1Ixb1ljZGdPMkVHNm9uNjgiLCJtYWMiOiIzZDk3YjI3ODc4NzlkZTlkMzc1YmJhMDBhYWYyMWE2NzY0YWRkNjIyNDUyZmUwNDZhMjZjM2U3MDhlM2M1MjU4IiwidGFnIjoiIn0%3D; expires=Fri, 04 Apr 2025 15:14:01 GMT; Max-Age=900; path=/ ◀XSRF-TOKEN=eyJpdiI6Ik5zSGlwUkJJdXBlOXVuTWZtZm1QUEE9PSIsInZhbHVlIjoiS2xTRlUyUHg1ZDVJcnE2dUM5blBqZHZpOTVIZTNPNjdSR3IycFUvUGlxcDRrUDV3endDQjZhOEcvNGNkSXd3eWRoWjBjR ▶" 1 => "poundex_associates_corporation_session=eyJpdiI6IlFhUFUrWmo2WERJblJEdVlCVVY2Rnc9PSIsInZhbHVlIjoiWEtyQmYxVzNBS3c3SGR4bTRHVFp2S3hjTVJyV1QrbFNzYlZMMkhpR2JMVW1EMk9UcUhxWTltVkFMTGdiOHB6Q1JEOHlVZ0hqb1Q3alZ0c0NZL0dqbWVWQ0xBTzI5R3kyNnZldzJ6STAwaHdLb29KVWRXN1JnN0doSm5ZeVZGWlYiLCJtYWMiOiJiNmE3ZDU5MmMzODk4ZGJkNzRiNTQyYWE0YzkwNThjOWMwMTI0MGY0M2RmMGVlNTgxZTNiZTg5NGFkYjQwMGE3IiwidGFnIjoiIn0%3D; expires=Fri, 04 Apr 2025 15:14:01 GMT; Max-Age=900; path=/; httponly ◀poundex_associates_corporation_session=eyJpdiI6IlFhUFUrWmo2WERJblJEdVlCVVY2Rnc9PSIsInZhbHVlIjoiWEtyQmYxVzNBS3c3SGR4bTRHVFp2S3hjTVJyV1QrbFNzYlZMMkhpR2JMVW1EMk9Uc ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Ik5zSGlwUkJJdXBlOXVuTWZtZm1QUEE9PSIsInZhbHVlIjoiS2xTRlUyUHg1ZDVJcnE2dUM5blBqZHZpOTVIZTNPNjdSR3IycFUvUGlxcDRrUDV3endDQjZhOEcvNGNkSXd3eWRoWjBjRFFGdGEvOXFSRVBSKzJCa1RoMER3ZlVwd0VBRnpucEpYT2pDTDd6OTFJR1Ixb1ljZGdPMkVHNm9uNjgiLCJtYWMiOiIzZDk3YjI3ODc4NzlkZTlkMzc1YmJhMDBhYWYyMWE2NzY0YWRkNjIyNDUyZmUwNDZhMjZjM2U3MDhlM2M1MjU4IiwidGFnIjoiIn0%3D; expires=Fri, 04-Apr-2025 15:14:01 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ik5zSGlwUkJJdXBlOXVuTWZtZm1QUEE9PSIsInZhbHVlIjoiS2xTRlUyUHg1ZDVJcnE2dUM5blBqZHZpOTVIZTNPNjdSR3IycFUvUGlxcDRrUDV3endDQjZhOEcvNGNkSXd3eWRoWjBjR ▶" 1 => "poundex_associates_corporation_session=eyJpdiI6IlFhUFUrWmo2WERJblJEdVlCVVY2Rnc9PSIsInZhbHVlIjoiWEtyQmYxVzNBS3c3SGR4bTRHVFp2S3hjTVJyV1QrbFNzYlZMMkhpR2JMVW1EMk9UcUhxWTltVkFMTGdiOHB6Q1JEOHlVZ0hqb1Q3alZ0c0NZL0dqbWVWQ0xBTzI5R3kyNnZldzJ6STAwaHdLb29KVWRXN1JnN0doSm5ZeVZGWlYiLCJtYWMiOiJiNmE3ZDU5MmMzODk4ZGJkNzRiNTQyYWE0YzkwNThjOWMwMTI0MGY0M2RmMGVlNTgxZTNiZTg5NGFkYjQwMGE3IiwidGFnIjoiIn0%3D; expires=Fri, 04-Apr-2025 15:14:01 GMT; path=/; httponly ◀poundex_associates_corporation_session=eyJpdiI6IlFhUFUrWmo2WERJblJEdVlCVVY2Rnc9PSIsInZhbHVlIjoiWEtyQmYxVzNBS3c3SGR4bTRHVFp2S3hjTVJyV1QrbFNzYlZMMkhpR2JMVW1EMk9Uc ▶" ] ]
0 of 0 array:5 [▼ "_token" => "AkG0zdcj3i681rrdpdewLDaUSz1tW3OdQ0jQtAdF" "links" => array:1 [▶ 0 => "http://bobkonaonline.com/promotion-landing-page/111" ] "_previous" => array:1 [▶ "url" => "http://bobkonaonline.com/promotion-landing-page/111" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
