| 1 x Application (97.88%) | 528ms |
| 1 x Booting (2.11%) | 11.40ms |
| Backtrace |
|
select * from `categories` where `slug` = 'Candy_and_Chocolates' and `is_delete` = 0 and `is_active` = 1 limit 1| Bindings |
|
| Backtrace |
|
select * from `categories` where `categories`.`id` = 129 limit 1| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 129 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from (select `products`.* from `products` inner join `product_categories` on `product_categories`.`product_id` = `products`.`id` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `type` in ('parent', 'single') and `master_duplicate` in ('original', 'set') and `website_listing` = 1 and `product_categories`.`category_id` in (129) and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) group by `color_style_variation`) as `aggregate_table`| Bindings |
|
| Backtrace |
|
select `products`.* from `products` inner join `product_categories` on `product_categories`.`product_id` = `products`.`id` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `type` in ('parent', 'single') and `master_duplicate` in ('original', 'set') and `website_listing` = 1 and `product_categories`.`category_id` in (129) and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) group by `color_style_variation` order by `modified` desc limit 30 offset 0| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 39388| Bindings |
|
| Backtrace |
|
select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 39388 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1| Bindings |
|
| Backtrace |
|
select * from `product_prices` where `channel` = 'website' and `product_id` = 39388 and `wholesale` = 0 limit 1| Bindings |
|
| Backtrace |
|
select `categories`.*, `product_categories`.`product_id` as `pivot_product_id`, `product_categories`.`category_id` as `pivot_category_id` from `categories` inner join `product_categories` on `categories`.`id` = `product_categories`.`category_id` where `product_categories`.`product_id` = 39388 limit 1| Bindings |
|
| Backtrace |
|
select * from `products_po_costs` where `product_id` = 39388 and `quantity` > 0 order by `date_received` asc limit 1| Bindings |
|
| Backtrace |
|
select * from `supplier_costs` where `product_id` = 39388 and `is_current` = '1' limit 1| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 42352| Bindings |
|
| Backtrace |
|
select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 42352 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1| Bindings |
|
| Backtrace |
|
select * from `product_prices` where `channel` = 'website' and `product_id` = 42352 and `wholesale` = 0 limit 1| Bindings |
|
| Backtrace |
|
select `categories`.*, `product_categories`.`product_id` as `pivot_product_id`, `product_categories`.`category_id` as `pivot_category_id` from `categories` inner join `product_categories` on `categories`.`id` = `product_categories`.`category_id` where `product_categories`.`product_id` = 42352 limit 1| Bindings |
|
| Backtrace |
|
select * from `products_po_costs` where `product_id` = 42352 and `quantity` > 0 order by `date_received` asc limit 1| Bindings |
|
| Backtrace |
|
select * from `supplier_costs` where `product_id` = 42352 and `is_current` = '1' limit 1| Bindings |
|
| Backtrace |
|
select * from `categories` where `is_delete` = 0 and `is_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `website_banners` where `banner_type` = 'website' and `position` = 'top' limit 1| Bindings |
|
| Backtrace |
|
select * from `banner_images` where `is_active` = '1' and `banner_id` = 5 order by `sort_order` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `level` = '1' and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 203 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 100 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 99 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 50 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 61 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 106 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 120 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 141 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 146 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 147 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 164 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 174 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 80 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 89 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 200 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 97 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 217 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 232 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 192 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 180 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 188 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 35 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 55 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 194 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 242 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 52 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 135 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 172 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 94 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 48 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 93 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 67 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 240 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 225 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 167 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 129 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 237 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 239 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `categories` where `parent_id` = 224 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select `id`, `name`, `slug` from `pages` where `channel` = 'website' and `is_active` = 1 and `is_delete` = 0| Bindings |
|
| Backtrace |
|
200
[]
[]
0 of 0array:15 [▼ "host" => array:1 [▶ 0 => "shop72.com" ] "connection" => array:1 [▶ 0 => "keep-alive" ] "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 0array:5 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Thu, 27 Mar 2025 09:45:54 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InE5ZTdmVksxVjMwdjVqOWxzbFM0ZVE9PSIsInZhbHVlIjoicCtmME5qdkpOSlo0YXZxNGo2Q1ovSndUSGxIVzhnQ2ZLRWdyemkxK2tmU2FCbTYxU1FvRnQrZWl1L05PeWUrV3BTeUNYVlJrUW5LTy9HNFBseS9hNmV5V3FsaXVwQVY2MjJlQlhBWVQ5aGozZzRGcytMT2hJSS9neG1SdWRTbk0iLCJtYWMiOiIwYTllZDA3ZmQyZjFiYjFhMDhkZTg0OTBiNjAxNzI1NzczZTVhMWVlMjNiMjRjZWNkZjFkZTc0ZGUxOGFjMDBmIiwidGFnIjoiIn0%3D; expires=Thu, 27 Mar 2025 11:45:55 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6InE5ZTdmVksxVjMwdjVqOWxzbFM0ZVE9PSIsInZhbHVlIjoicCtmME5qdkpOSlo0YXZxNGo2Q1ovSndUSGxIVzhnQ2ZLRWdyemkxK2tmU2FCbTYxU1FvRnQrZWl1L05PeWUrV3BTeUNYV ▶" 1 => "laravel_session=eyJpdiI6ImVrUzdDcTB0Yjg2NThieUZGWkZtdlE9PSIsInZhbHVlIjoiMUV0bzhoSE5WNk53bHRldHptR2lPMzh1LzI3MjREbTRGd3p4VmRZWkNOV1VKMDBPT2o1cWZkc3F2enRZcVh4eWNST3pCcnIrMUFWSkdHZmM4Zm1vcXlieVRVV1Q2THkydjVkQXhnUVJsZlNNQnlXWDJ4OFpJNDFDWE1pL3E5ZkkiLCJtYWMiOiI1OTE4N2E4ZDc0NTQ3ZDNlOWFhYTI1YjkzZGIwYjY3NGM2ODBmMTk1N2ZkNjc2ZjFlZWVjYTE0NTM4MjNmYmIxIiwidGFnIjoiIn0%3D; expires=Thu, 27 Mar 2025 11:45:55 GMT; Max-Age=7200; path=/; httponly ◀laravel_session=eyJpdiI6ImVrUzdDcTB0Yjg2NThieUZGWkZtdlE9PSIsInZhbHVlIjoiMUV0bzhoSE5WNk53bHRldHptR2lPMzh1LzI3MjREbTRGd3p4VmRZWkNOV1VKMDBPT2o1cWZkc3F2enRZcVh4eWNS ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InE5ZTdmVksxVjMwdjVqOWxzbFM0ZVE9PSIsInZhbHVlIjoicCtmME5qdkpOSlo0YXZxNGo2Q1ovSndUSGxIVzhnQ2ZLRWdyemkxK2tmU2FCbTYxU1FvRnQrZWl1L05PeWUrV3BTeUNYVlJrUW5LTy9HNFBseS9hNmV5V3FsaXVwQVY2MjJlQlhBWVQ5aGozZzRGcytMT2hJSS9neG1SdWRTbk0iLCJtYWMiOiIwYTllZDA3ZmQyZjFiYjFhMDhkZTg0OTBiNjAxNzI1NzczZTVhMWVlMjNiMjRjZWNkZjFkZTc0ZGUxOGFjMDBmIiwidGFnIjoiIn0%3D; expires=Thu, 27-Mar-2025 11:45:55 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InE5ZTdmVksxVjMwdjVqOWxzbFM0ZVE9PSIsInZhbHVlIjoicCtmME5qdkpOSlo0YXZxNGo2Q1ovSndUSGxIVzhnQ2ZLRWdyemkxK2tmU2FCbTYxU1FvRnQrZWl1L05PeWUrV3BTeUNYV ▶" 1 => "laravel_session=eyJpdiI6ImVrUzdDcTB0Yjg2NThieUZGWkZtdlE9PSIsInZhbHVlIjoiMUV0bzhoSE5WNk53bHRldHptR2lPMzh1LzI3MjREbTRGd3p4VmRZWkNOV1VKMDBPT2o1cWZkc3F2enRZcVh4eWNST3pCcnIrMUFWSkdHZmM4Zm1vcXlieVRVV1Q2THkydjVkQXhnUVJsZlNNQnlXWDJ4OFpJNDFDWE1pL3E5ZkkiLCJtYWMiOiI1OTE4N2E4ZDc0NTQ3ZDNlOWFhYTI1YjkzZGIwYjY3NGM2ODBmMTk1N2ZkNjc2ZjFlZWVjYTE0NTM4MjNmYmIxIiwidGFnIjoiIn0%3D; expires=Thu, 27-Mar-2025 11:45:55 GMT; path=/; httponly ◀laravel_session=eyJpdiI6ImVrUzdDcTB0Yjg2NThieUZGWkZtdlE9PSIsInZhbHVlIjoiMUV0bzhoSE5WNk53bHRldHptR2lPMzh1LzI3MjREbTRGd3p4VmRZWkNOV1VKMDBPT2o1cWZkc3F2enRZcVh4eWNS ▶" ] ]
0 of 0array:4 [▼ "_token" => "vVdpWf0jw7omyJnu818XnOlc0G308odJ3Kya9xXl" "_previous" => array:1 [▶ "url" => "https://shop72.com/category/Candy_and_Chocolates" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
