F1752
Dining Chair
F1753
Dining Bench
F1754
Counter Height Chair
F1755
Counter Height Bench
F1756
F1757
F1773
F1775
F2053
Bar Stand
F2059
F2093
Dining Table
F2114
F2120
F2150
F2151
F2153
F2179
F2182
F2187
F2207
F2208
Counter Height Table
F2232
5-Pcs Dining Set
F2237
F2238
F2252
5-Pcs Counter Height Set
F2271
F2273
F2290
F2291
F2294
7-Pcs Dining Set
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` = '113' 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 ('F1752', 'F1753', 'F1754', 'F1755', 'F1756', 'F1757', 'F1773', 'F1775', 'F2053', 'F2059', 'F2093', 'F2114', 'F2120', 'F2150', 'F2151', 'F2153', 'F2179', 'F2182', 'F2187', 'F2207', 'F2208', 'F2232', 'F2237', 'F2238', 'F2252', 'F2271', 'F2273', 'F2290', 'F2291', 'F2294', 'F2297', 'F2322', 'F2323', 'F2329', 'F2339', 'F2345', 'F2347', 'F2356', 'F2361', 'F2363', 'F2366', 'F2367', 'F2368', 'F2389', 'F2398', 'F2399', 'F2428', 'F2430', 'F2431', 'F2432', 'F2460', 'F2461', 'F2480', 'F2547', 'F2548', 'F3054', 'F3069', 'F3075', 'F3087', 'F3090', 'F3091', 'F3093', 'F3098', 'F3111', 'F3114', 'F3126', 'F3139', 'F3141', 'F3143', 'F3144', 'F3145', 'F3147', 'F3148', 'F3150', 'F3151', 'F3152', 'F3157', 'F4060', 'F4071', 'F4072', 'F4074', 'F4079', 'F4116', 'F4117', 'F4118', 'F4119', 'F4145', 'F4146', 'F4147', 'F4148', 'F4177', 'F4178', 'F4179', 'F4234', 'F4235', 'F4236', 'F4237', 'F4238', 'F4239', 'F4251', 'F4252', 'F4253', 'F4254', 'F4255', 'F4256', 'F4277', 'F4278', 'F4279', 'F4335', 'F4336', 'F4337', 'F4338', 'F4345', 'F4346', 'F4347', 'F4348', 'F4349', 'F4350', 'F4351', 'F4352', 'F4359', 'F4360', 'F4361', 'F4362', 'F4390', 'F4391', 'F4392', 'F4393', 'F4715', 'F4716', 'F4717', 'F4718', 'F4725', 'F4726', 'F4727', 'F4728', 'F4735', 'F4736', 'F4737', 'F4738', 'F4776', 'F4777', 'F4778', 'F4779', 'F4822', 'F4823', 'F4861', 'F4862', 'F4863', 'F4864', 'F4873', 'F4874', 'F4875', 'F4876', 'F4881', 'F4882', 'F4883', 'F4884', 'F4926', 'F4927', 'F4928', 'F4929', 'F4937', 'F4961', 'F4962', 'F4963', 'F4964', 'F4966', 'F4967') 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-10" >= products.discounted_start_date AND (products.discounted_end_date IS NULL OR "2025-04-10" <= products.discounted_end_date) THEN round(products.discounted_percentage,0) ELSE 0 END AS discounted_percentage, CASE WHEN "2025-04-10" >= products.discounted_start_date AND (products.discounted_end_date IS NULL OR "2025-04-10" <= 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-10" >= products.discounted_start_date AND (products.discounted_end_date IS NULL OR "2025-04-10" <= 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 ('F1752', 'F1753', 'F1754', 'F1755', 'F1756', 'F1757', 'F1773', 'F1775', 'F2053', 'F2059', 'F2093', 'F2114', 'F2120', 'F2150', 'F2151', 'F2153', 'F2179', 'F2182', 'F2187', 'F2207', 'F2208', 'F2232', 'F2237', 'F2238', 'F2252', 'F2271', 'F2273', 'F2290', 'F2291', 'F2294', 'F2297', 'F2322', 'F2323', 'F2329', 'F2339', 'F2345', 'F2347', 'F2356', 'F2361', 'F2363', 'F2366', 'F2367', 'F2368', 'F2389', 'F2398', 'F2399', 'F2428', 'F2430', 'F2431', 'F2432', 'F2460', 'F2461', 'F2480', 'F2547', 'F2548', 'F3054', 'F3069', 'F3075', 'F3087', 'F3090', 'F3091', 'F3093', 'F3098', 'F3111', 'F3114', 'F3126', 'F3139', 'F3141', 'F3143', 'F3144', 'F3145', 'F3147', 'F3148', 'F3150', 'F3151', 'F3152', 'F3157', 'F4060', 'F4071', 'F4072', 'F4074', 'F4079', 'F4116', 'F4117', 'F4118', 'F4119', 'F4145', 'F4146', 'F4147', 'F4148', 'F4177', 'F4178', 'F4179', 'F4234', 'F4235', 'F4236', 'F4237', 'F4238', 'F4239', 'F4251', 'F4252', 'F4253', 'F4254', 'F4255', 'F4256', 'F4277', 'F4278', 'F4279', 'F4335', 'F4336', 'F4337', 'F4338', 'F4345', 'F4346', 'F4347', 'F4348', 'F4349', 'F4350', 'F4351', 'F4352', 'F4359', 'F4360', 'F4361', 'F4362', 'F4390', 'F4391', 'F4392', 'F4393', 'F4715', 'F4716', 'F4717', 'F4718', 'F4725', 'F4726', 'F4727', 'F4728', 'F4735', 'F4736', 'F4737', 'F4738', 'F4776', 'F4777', 'F4778', 'F4779', 'F4822', 'F4823', 'F4861', 'F4862', 'F4863', 'F4864', 'F4873', 'F4874', 'F4875', 'F4876', 'F4881', 'F4882', 'F4883', 'F4884', 'F4926', 'F4927', 'F4928', 'F4929', 'F4937', 'F4961', 'F4962', 'F4963', 'F4964', 'F4966', 'F4967') and `product_boxes`.`parent_child` = 'p' order by `products`.`item_number` asc limit 30 offset 0
select CASE WHEN "2025-04-10" >= products.discounted_start_date AND (products.discounted_end_date IS NULL OR "2025-04-10" <= 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 ('F1752', 'F1753', 'F1754', 'F1755', 'F1756', 'F1757', 'F1773', 'F1775', 'F2053', 'F2059', 'F2093', 'F2114', 'F2120', 'F2150', 'F2151', 'F2153', 'F2179', 'F2182', 'F2187', 'F2207', 'F2208', 'F2232', 'F2237', 'F2238', 'F2252', 'F2271', 'F2273', 'F2290', 'F2291', 'F2294', 'F2297', 'F2322', 'F2323', 'F2329', 'F2339', 'F2345', 'F2347', 'F2356', 'F2361', 'F2363', 'F2366', 'F2367', 'F2368', 'F2389', 'F2398', 'F2399', 'F2428', 'F2430', 'F2431', 'F2432', 'F2460', 'F2461', 'F2480', 'F2547', 'F2548', 'F3054', 'F3069', 'F3075', 'F3087', 'F3090', 'F3091', 'F3093', 'F3098', 'F3111', 'F3114', 'F3126', 'F3139', 'F3141', 'F3143', 'F3144', 'F3145', 'F3147', 'F3148', 'F3150', 'F3151', 'F3152', 'F3157', 'F4060', 'F4071', 'F4072', 'F4074', 'F4079', 'F4116', 'F4117', 'F4118', 'F4119', 'F4145', 'F4146', 'F4147', 'F4148', 'F4177', 'F4178', 'F4179', 'F4234', 'F4235', 'F4236', 'F4237', 'F4238', 'F4239', 'F4251', 'F4252', 'F4253', 'F4254', 'F4255', 'F4256', 'F4277', 'F4278', 'F4279', 'F4335', 'F4336', 'F4337', 'F4338', 'F4345', 'F4346', 'F4347', 'F4348', 'F4349', 'F4350', 'F4351', 'F4352', 'F4359', 'F4360', 'F4361', 'F4362', 'F4390', 'F4391', 'F4392', 'F4393', 'F4715', 'F4716', 'F4717', 'F4718', 'F4725', 'F4726', 'F4727', 'F4728', 'F4735', 'F4736', 'F4737', 'F4738', 'F4776', 'F4777', 'F4778', 'F4779', 'F4822', 'F4823', 'F4861', 'F4862', 'F4863', 'F4864', 'F4873', 'F4874', 'F4875', 'F4876', 'F4881', 'F4882', 'F4883', 'F4884', 'F4926', 'F4927', 'F4928', 'F4929', 'F4937', 'F4961', 'F4962', 'F4963', 'F4964', 'F4966', 'F4967') 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_gx67k6rXLOO-r2vQStwQAAAAE" "REDIRECT_STATUS" => "200" "UNIQUE_ID" => "Z_gx67k6rXLOO-r2vQStwQAAAAE" "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" => "34760" "REDIRECT_URL" => "/promotion-landing-page/113" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/promotion-landing-page/113" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1744318955.1977 "REQUEST_TIME" => 1744318955 ]
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 => "Thu, 10 Apr 2025 21:02:35 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Ijd6SUg2ZWJZNWtXeGRXbFB0dVlHSEE9PSIsInZhbHVlIjoieG9NU3pUSnltRG1iNXVST21EVkNaOU5PcWVIek45ODdWd0ljUmtzWmpKZi9VcFFRRXd3UldkV0t5all0K0MvV3dHMVlLVktQNy9PdWFxRVJOeFZhMVcwRVJpcEs5NXdGclkybzV1QTk3ZEpVTWZsaldIOEVMRFdHaTRtdHRqUU4iLCJtYWMiOiJjMTY2ZWNkYTRmYjlmNjQ3NjE3NGFhNjg2Yjc1MDk2OWIzZmE4ZWNmMjk5ZjNiZDg5NzI3OGY1YWUzYjAxNmM3IiwidGFnIjoiIn0%3D; expires=Thu, 10 Apr 2025 21:17:35 GMT; Max-Age=900; path=/ ◀XSRF-TOKEN=eyJpdiI6Ijd6SUg2ZWJZNWtXeGRXbFB0dVlHSEE9PSIsInZhbHVlIjoieG9NU3pUSnltRG1iNXVST21EVkNaOU5PcWVIek45ODdWd0ljUmtzWmpKZi9VcFFRRXd3UldkV0t5all0K0MvV3dHMVlLV ▶" 1 => "poundex_associates_corporation_session=eyJpdiI6IjhxUHdGaVVZeC9VOTdqYXQyZzlLZmc9PSIsInZhbHVlIjoiYnZtRmlmN3hpcGRMNU9FSGxoQXArb0hjKzk0TStINHVtNWNTUm4xUHBwaUM2ckl4UFZXUlpvaC92YWY3bXlqZWVaR3dqR2d1Z2dyRDVQSXdOclJqOVQ0SVVXdC9oYVFLV0JwenI5djhDSGs5TklWTnQ5eWtSSy9pRzFyK1l6RloiLCJtYWMiOiIyZGJmNGMzMTY3ZmRmNDUyYzgwYzU1NmIxZGNkNTJmOGQ4M2QwMjI5NjI0YzUyYmIwODJkMzEwNDAxYWIzYTY4IiwidGFnIjoiIn0%3D; expires=Thu, 10 Apr 2025 21:17:35 GMT; Max-Age=900; path=/; httponly ◀poundex_associates_corporation_session=eyJpdiI6IjhxUHdGaVVZeC9VOTdqYXQyZzlLZmc9PSIsInZhbHVlIjoiYnZtRmlmN3hpcGRMNU9FSGxoQXArb0hjKzk0TStINHVtNWNTUm4xUHBwaUM2ckl4U ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Ijd6SUg2ZWJZNWtXeGRXbFB0dVlHSEE9PSIsInZhbHVlIjoieG9NU3pUSnltRG1iNXVST21EVkNaOU5PcWVIek45ODdWd0ljUmtzWmpKZi9VcFFRRXd3UldkV0t5all0K0MvV3dHMVlLVktQNy9PdWFxRVJOeFZhMVcwRVJpcEs5NXdGclkybzV1QTk3ZEpVTWZsaldIOEVMRFdHaTRtdHRqUU4iLCJtYWMiOiJjMTY2ZWNkYTRmYjlmNjQ3NjE3NGFhNjg2Yjc1MDk2OWIzZmE4ZWNmMjk5ZjNiZDg5NzI3OGY1YWUzYjAxNmM3IiwidGFnIjoiIn0%3D; expires=Thu, 10-Apr-2025 21:17:35 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ijd6SUg2ZWJZNWtXeGRXbFB0dVlHSEE9PSIsInZhbHVlIjoieG9NU3pUSnltRG1iNXVST21EVkNaOU5PcWVIek45ODdWd0ljUmtzWmpKZi9VcFFRRXd3UldkV0t5all0K0MvV3dHMVlLV ▶" 1 => "poundex_associates_corporation_session=eyJpdiI6IjhxUHdGaVVZeC9VOTdqYXQyZzlLZmc9PSIsInZhbHVlIjoiYnZtRmlmN3hpcGRMNU9FSGxoQXArb0hjKzk0TStINHVtNWNTUm4xUHBwaUM2ckl4UFZXUlpvaC92YWY3bXlqZWVaR3dqR2d1Z2dyRDVQSXdOclJqOVQ0SVVXdC9oYVFLV0JwenI5djhDSGs5TklWTnQ5eWtSSy9pRzFyK1l6RloiLCJtYWMiOiIyZGJmNGMzMTY3ZmRmNDUyYzgwYzU1NmIxZGNkNTJmOGQ4M2QwMjI5NjI0YzUyYmIwODJkMzEwNDAxYWIzYTY4IiwidGFnIjoiIn0%3D; expires=Thu, 10-Apr-2025 21:17:35 GMT; path=/; httponly ◀poundex_associates_corporation_session=eyJpdiI6IjhxUHdGaVVZeC9VOTdqYXQyZzlLZmc9PSIsInZhbHVlIjoiYnZtRmlmN3hpcGRMNU9FSGxoQXArb0hjKzk0TStINHVtNWNTUm4xUHBwaUM2ckl4U ▶" ] ]
0 of 0 array:5 [▼ "_token" => "ZwpgP2HxXWbSSkYNWzYYYtYdj6wDYSqFdBDtmrSp" "links" => array:1 [▶ 0 => "http://bobkonaonline.com/promotion-landing-page/113" ] "_previous" => array:1 [▶ "url" => "http://bobkonaonline.com/promotion-landing-page/113" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]