823
Modular Sectional
F6414
3-PCS Sectional Set
F6415
F6416
F6417
F6418
F6419
F6423
3-PCS Sectional Sofa Set
F6424
F6429
2-PCS Sectional Sofa Set
F6430
F6433
4-PCS Sectional Set
F6434
4-PCS Sectional
F6437
F6438
F6457
REVERSIBLE SECTIONAL W/2 ACCENT PILLOW
F6458
F6459
F6471
3-PC SECTIONAL W/2 ACCENT PILLOW (OTTOMAN INCLUDED)
F6474
F6475
F6476
F6477
F6478
F6479
F6501
2-Pcs Sofa Set
F6504
3-Pcs Sectional Sofa
F6505
F6506
F6511
2-Pcs Sectional Sofa
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` = '119' 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 ('F8890', 'F6479', 'F6478', 'F6477', 'F6476', 'F6475', 'F6474', 'F6473', 'F6472', 'F6471', 'F6459', 'F6458', 'F6457', 'F6593', 'F6592', 'F6591', 'F6584', 'F6574', 'F6500', 'F6430', 'F6429', 'F6426', 'F6425', '828', '827', '823', 'F6438', 'F6437', 'F6434', 'F6433', 'F6404', 'F6424', 'F6423', 'F6422', 'F6421', 'F6420', 'F6419', 'F6418', 'F6417', 'F6416', 'F6415', 'F6414', 'F7975', 'F7916', 'F7915', 'F7910', 'F7908', 'F7907', 'F7770', 'F7769', 'F7620', 'F7616', 'F7615', 'F7614', 'F7613', 'F7609', 'F7608', 'F7606', 'F7605', 'F7603', 'F7602', 'F7601', 'F7587', 'F7569', 'F7564', 'F7364', 'F7363', 'F7355', 'F7354', 'F7351', 'F7320', 'F7315', 'F7310', 'F7300', 'F7299', 'F7140', 'F7139', 'F7094', 'F7086', 'F7084', 'F6999', 'F6998', 'F6997', 'F6994', 'F6991', 'F6990', 'F6989', 'F6988', 'F6985', 'F6984', 'F6979', 'F6977', 'F6976', 'F6975', 'F6974', 'F6973', 'F6969', 'F6967', 'F6963', 'F6962', 'F6961', 'F6955', 'F6954', 'F6953', 'F6889', 'F6888', 'F6887', 'F6858', 'F6857', 'F6855', 'F6599', 'F6598', 'F6597', 'F6590', 'F6589', 'F6588', 'F6587', 'F6586', 'F6585', 'F6583', 'F6582', 'F6581', 'F6577', 'F6576', 'F6573', 'F6572', 'F6570', 'F6553', 'F6552', 'F6551', 'F6544', 'F6543', 'F6542', 'F6541', 'F6540', 'F6539', 'F6520', 'F6519', 'F6514', 'F6513', 'F6512', 'F6511', 'F6509', 'F6508', 'F6507', 'F6506', 'F6505', 'F6504', 'F6503', 'F6502', 'F6501') 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 ('F8890', 'F6479', 'F6478', 'F6477', 'F6476', 'F6475', 'F6474', 'F6473', 'F6472', 'F6471', 'F6459', 'F6458', 'F6457', 'F6593', 'F6592', 'F6591', 'F6584', 'F6574', 'F6500', 'F6430', 'F6429', 'F6426', 'F6425', '828', '827', '823', 'F6438', 'F6437', 'F6434', 'F6433', 'F6404', 'F6424', 'F6423', 'F6422', 'F6421', 'F6420', 'F6419', 'F6418', 'F6417', 'F6416', 'F6415', 'F6414', 'F7975', 'F7916', 'F7915', 'F7910', 'F7908', 'F7907', 'F7770', 'F7769', 'F7620', 'F7616', 'F7615', 'F7614', 'F7613', 'F7609', 'F7608', 'F7606', 'F7605', 'F7603', 'F7602', 'F7601', 'F7587', 'F7569', 'F7564', 'F7364', 'F7363', 'F7355', 'F7354', 'F7351', 'F7320', 'F7315', 'F7310', 'F7300', 'F7299', 'F7140', 'F7139', 'F7094', 'F7086', 'F7084', 'F6999', 'F6998', 'F6997', 'F6994', 'F6991', 'F6990', 'F6989', 'F6988', 'F6985', 'F6984', 'F6979', 'F6977', 'F6976', 'F6975', 'F6974', 'F6973', 'F6969', 'F6967', 'F6963', 'F6962', 'F6961', 'F6955', 'F6954', 'F6953', 'F6889', 'F6888', 'F6887', 'F6858', 'F6857', 'F6855', 'F6599', 'F6598', 'F6597', 'F6590', 'F6589', 'F6588', 'F6587', 'F6586', 'F6585', 'F6583', 'F6582', 'F6581', 'F6577', 'F6576', 'F6573', 'F6572', 'F6570', 'F6553', 'F6552', 'F6551', 'F6544', 'F6543', 'F6542', 'F6541', 'F6540', 'F6539', 'F6520', 'F6519', 'F6514', 'F6513', 'F6512', 'F6511', 'F6509', 'F6508', 'F6507', 'F6506', 'F6505', 'F6504', 'F6503', 'F6502', 'F6501') 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 ('F8890', 'F6479', 'F6478', 'F6477', 'F6476', 'F6475', 'F6474', 'F6473', 'F6472', 'F6471', 'F6459', 'F6458', 'F6457', 'F6593', 'F6592', 'F6591', 'F6584', 'F6574', 'F6500', 'F6430', 'F6429', 'F6426', 'F6425', '828', '827', '823', 'F6438', 'F6437', 'F6434', 'F6433', 'F6404', 'F6424', 'F6423', 'F6422', 'F6421', 'F6420', 'F6419', 'F6418', 'F6417', 'F6416', 'F6415', 'F6414', 'F7975', 'F7916', 'F7915', 'F7910', 'F7908', 'F7907', 'F7770', 'F7769', 'F7620', 'F7616', 'F7615', 'F7614', 'F7613', 'F7609', 'F7608', 'F7606', 'F7605', 'F7603', 'F7602', 'F7601', 'F7587', 'F7569', 'F7564', 'F7364', 'F7363', 'F7355', 'F7354', 'F7351', 'F7320', 'F7315', 'F7310', 'F7300', 'F7299', 'F7140', 'F7139', 'F7094', 'F7086', 'F7084', 'F6999', 'F6998', 'F6997', 'F6994', 'F6991', 'F6990', 'F6989', 'F6988', 'F6985', 'F6984', 'F6979', 'F6977', 'F6976', 'F6975', 'F6974', 'F6973', 'F6969', 'F6967', 'F6963', 'F6962', 'F6961', 'F6955', 'F6954', 'F6953', 'F6889', 'F6888', 'F6887', 'F6858', 'F6857', 'F6855', 'F6599', 'F6598', 'F6597', 'F6590', 'F6589', 'F6588', 'F6587', 'F6586', 'F6585', 'F6583', 'F6582', 'F6581', 'F6577', 'F6576', 'F6573', 'F6572', 'F6570', 'F6553', 'F6552', 'F6551', 'F6544', 'F6543', 'F6542', 'F6541', 'F6540', 'F6539', 'F6520', 'F6519', 'F6514', 'F6513', 'F6512', 'F6511', 'F6509', 'F6508', 'F6507', 'F6506', 'F6505', 'F6504', 'F6503', 'F6502', 'F6501') 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_ChF6Ckngy_oLbnwq2hDwAAAAU" "REDIRECT_STATUS" => "200" "UNIQUE_ID" => "Z_ChF6Ckngy_oLbnwq2hDwAAAAU" "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" => "50784" "REDIRECT_URL" => "/promotion-landing-page/119" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/promotion-landing-page/119" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1743823127.481 "REQUEST_TIME" => 1743823127 ]
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 => "Sat, 05 Apr 2025 03:18:47 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjhFNGY5bGtPRTZGVCtGcDZldS9YZlE9PSIsInZhbHVlIjoiSUhCVTJVNEdjcFNOUlRPSWlkVGpMcjBBMXZZSVlIdk94TnFmRGovbjdFTEUwSHJaWEtPbEZSWExoaWNvcXBYR2ZEZGdRMEFVd1VZalpSMHJiSnE0RVNMNjZIR0NacE9OOTFSSWRReVVLcVhxVlBVNVR2MmRTL3dhanN0Y0hPdVkiLCJtYWMiOiJkNDFmNmQ0NDE1NzNlZWE3MmYxOWViZWExOGU0MjExNDg2OGYxZjlhNGQ4MTA3YTA1N2FiNDY3ZTY2YTIzMzA0IiwidGFnIjoiIn0%3D; expires=Sat, 05 Apr 2025 03:33:47 GMT; Max-Age=900; path=/ ◀XSRF-TOKEN=eyJpdiI6IjhFNGY5bGtPRTZGVCtGcDZldS9YZlE9PSIsInZhbHVlIjoiSUhCVTJVNEdjcFNOUlRPSWlkVGpMcjBBMXZZSVlIdk94TnFmRGovbjdFTEUwSHJaWEtPbEZSWExoaWNvcXBYR2ZEZGdRM ▶" 1 => "poundex_associates_corporation_session=eyJpdiI6IjZxQ1ZjQnArVjRJaUc1UTltOUcxVHc9PSIsInZhbHVlIjoiOXhGb1B6Zk5MMjhsY2Jhb2tRZ0xYWGhtaUdCQW5Sbno5Vm9RSGdEUUxmZE5mZWdWWWNISThya2RZV1lYejJCQnQ2ZVhNSFVBQWFaaStZeHk1YUprNGJrTmZKaEY5OGZYUVk2ZzNML2hlRFpRbklLUy85QmJ1YURlRDU1djNoZ0wiLCJtYWMiOiJmOWFjZTMxZTBhYTc2OWJiYmJjNzEzYzkyMzM0M2JmZDY3MmQwZjgyMjFlMjAyZDA2NmMwMzJkZDJkZDliZWZlIiwidGFnIjoiIn0%3D; expires=Sat, 05 Apr 2025 03:33:47 GMT; Max-Age=900; path=/; httponly ◀poundex_associates_corporation_session=eyJpdiI6IjZxQ1ZjQnArVjRJaUc1UTltOUcxVHc9PSIsInZhbHVlIjoiOXhGb1B6Zk5MMjhsY2Jhb2tRZ0xYWGhtaUdCQW5Sbno5Vm9RSGdEUUxmZE5mZWdWW ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjhFNGY5bGtPRTZGVCtGcDZldS9YZlE9PSIsInZhbHVlIjoiSUhCVTJVNEdjcFNOUlRPSWlkVGpMcjBBMXZZSVlIdk94TnFmRGovbjdFTEUwSHJaWEtPbEZSWExoaWNvcXBYR2ZEZGdRMEFVd1VZalpSMHJiSnE0RVNMNjZIR0NacE9OOTFSSWRReVVLcVhxVlBVNVR2MmRTL3dhanN0Y0hPdVkiLCJtYWMiOiJkNDFmNmQ0NDE1NzNlZWE3MmYxOWViZWExOGU0MjExNDg2OGYxZjlhNGQ4MTA3YTA1N2FiNDY3ZTY2YTIzMzA0IiwidGFnIjoiIn0%3D; expires=Sat, 05-Apr-2025 03:33:47 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjhFNGY5bGtPRTZGVCtGcDZldS9YZlE9PSIsInZhbHVlIjoiSUhCVTJVNEdjcFNOUlRPSWlkVGpMcjBBMXZZSVlIdk94TnFmRGovbjdFTEUwSHJaWEtPbEZSWExoaWNvcXBYR2ZEZGdRM ▶" 1 => "poundex_associates_corporation_session=eyJpdiI6IjZxQ1ZjQnArVjRJaUc1UTltOUcxVHc9PSIsInZhbHVlIjoiOXhGb1B6Zk5MMjhsY2Jhb2tRZ0xYWGhtaUdCQW5Sbno5Vm9RSGdEUUxmZE5mZWdWWWNISThya2RZV1lYejJCQnQ2ZVhNSFVBQWFaaStZeHk1YUprNGJrTmZKaEY5OGZYUVk2ZzNML2hlRFpRbklLUy85QmJ1YURlRDU1djNoZ0wiLCJtYWMiOiJmOWFjZTMxZTBhYTc2OWJiYmJjNzEzYzkyMzM0M2JmZDY3MmQwZjgyMjFlMjAyZDA2NmMwMzJkZDJkZDliZWZlIiwidGFnIjoiIn0%3D; expires=Sat, 05-Apr-2025 03:33:47 GMT; path=/; httponly ◀poundex_associates_corporation_session=eyJpdiI6IjZxQ1ZjQnArVjRJaUc1UTltOUcxVHc9PSIsInZhbHVlIjoiOXhGb1B6Zk5MMjhsY2Jhb2tRZ0xYWGhtaUdCQW5Sbno5Vm9RSGdEUUxmZE5mZWdWW ▶" ] ]
0 of 0 array:5 [▼ "_token" => "ybpykJmLJLGMhtRZrLuq8ldC8Y2VQqv4SiYpetMz" "links" => array:1 [▶ 0 => "http://bobkonaonline.com/promotion-landing-page/119" ] "_previous" => array:1 [▶ "url" => "http://bobkonaonline.com/promotion-landing-page/119" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
