| 1 x Application (94.95%) | 135ms |
| 1 x Booting (5.04%) | 7.15ms |
| Backtrace |
|
select * from `categories` where `slug` = 'Games_Sports' and `is_delete` = 0 and `is_active` = 1 limit 1| Bindings |
|
| Backtrace |
|
select * from `categories` where `categories`.`id` = 55 limit 1| 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 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 (55) 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 * 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 => ""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" ] "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 => "Wed, 07 May 2025 19:42:11 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjNPZzVtbUNmUjZUVDR2ekNla2Jjb3c9PSIsInZhbHVlIjoiaDBiek56QUREUEVYWUdTR3ZOZWVXd294MFVhQkNuUmJXZ2xNamdZSUk4V3FKU2JSVDd1YXZrNDZlS25iZTBsOXE3Z1lLZjZ2N1pLdmJ4eGI1cGxtQnF0MVFEUm5rczc2UVh4Nmp1QnVvUW40MDNweTJwbDhZQmg5dEc3a1NRUnUiLCJtYWMiOiIzZDU4YjZiN2Q4NTI0ZGIwNDgyOGMxYzcwZDk3NzlmZTQ4NjM3NTE0ZDdmMTY3MzI3ZDhjOWE3NjI0YjZmYjc0IiwidGFnIjoiIn0%3D; expires=Wed, 07 May 2025 21:42:11 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IjNPZzVtbUNmUjZUVDR2ekNla2Jjb3c9PSIsInZhbHVlIjoiaDBiek56QUREUEVYWUdTR3ZOZWVXd294MFVhQkNuUmJXZ2xNamdZSUk4V3FKU2JSVDd1YXZrNDZlS25iZTBsOXE3Z1lLZ ▶" 1 => "laravel_session=eyJpdiI6ImgwOXgwaERtSFdhUnoxM201RFhhbHc9PSIsInZhbHVlIjoidWFjSkpkaWtHbVE5MzVHclBTYzIzZCtEWkgzVnJiYXBaRFFOL2l1bXViVXdiL29BTzNBem1wS0pnN1BUbVJBYkE0S1Y4Yyt1ckdxa1hWTnJablQvT3B4cFl5ZGRja2ZzdmpvMkJDR3pOYjRWU3JaOVJ0VHhzVGc2K2N0NVN5Y20iLCJtYWMiOiJmMjIyZmY4NzdlNmFkM2QwOTE1YzUyOGVhOWJmNzc4YmRjOTI5MTE1MWNhMDdjYTNkNWNjZmUxZDdmOGU2N2U2IiwidGFnIjoiIn0%3D; expires=Wed, 07 May 2025 21:42:11 GMT; Max-Age=7200; path=/; httponly ◀laravel_session=eyJpdiI6ImgwOXgwaERtSFdhUnoxM201RFhhbHc9PSIsInZhbHVlIjoidWFjSkpkaWtHbVE5MzVHclBTYzIzZCtEWkgzVnJiYXBaRFFOL2l1bXViVXdiL29BTzNBem1wS0pnN1BUbVJBYkE0 ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjNPZzVtbUNmUjZUVDR2ekNla2Jjb3c9PSIsInZhbHVlIjoiaDBiek56QUREUEVYWUdTR3ZOZWVXd294MFVhQkNuUmJXZ2xNamdZSUk4V3FKU2JSVDd1YXZrNDZlS25iZTBsOXE3Z1lLZjZ2N1pLdmJ4eGI1cGxtQnF0MVFEUm5rczc2UVh4Nmp1QnVvUW40MDNweTJwbDhZQmg5dEc3a1NRUnUiLCJtYWMiOiIzZDU4YjZiN2Q4NTI0ZGIwNDgyOGMxYzcwZDk3NzlmZTQ4NjM3NTE0ZDdmMTY3MzI3ZDhjOWE3NjI0YjZmYjc0IiwidGFnIjoiIn0%3D; expires=Wed, 07-May-2025 21:42:11 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjNPZzVtbUNmUjZUVDR2ekNla2Jjb3c9PSIsInZhbHVlIjoiaDBiek56QUREUEVYWUdTR3ZOZWVXd294MFVhQkNuUmJXZ2xNamdZSUk4V3FKU2JSVDd1YXZrNDZlS25iZTBsOXE3Z1lLZ ▶" 1 => "laravel_session=eyJpdiI6ImgwOXgwaERtSFdhUnoxM201RFhhbHc9PSIsInZhbHVlIjoidWFjSkpkaWtHbVE5MzVHclBTYzIzZCtEWkgzVnJiYXBaRFFOL2l1bXViVXdiL29BTzNBem1wS0pnN1BUbVJBYkE0S1Y4Yyt1ckdxa1hWTnJablQvT3B4cFl5ZGRja2ZzdmpvMkJDR3pOYjRWU3JaOVJ0VHhzVGc2K2N0NVN5Y20iLCJtYWMiOiJmMjIyZmY4NzdlNmFkM2QwOTE1YzUyOGVhOWJmNzc4YmRjOTI5MTE1MWNhMDdjYTNkNWNjZmUxZDdmOGU2N2U2IiwidGFnIjoiIn0%3D; expires=Wed, 07-May-2025 21:42:11 GMT; path=/; httponly ◀laravel_session=eyJpdiI6ImgwOXgwaERtSFdhUnoxM201RFhhbHc9PSIsInZhbHVlIjoidWFjSkpkaWtHbVE5MzVHclBTYzIzZCtEWkgzVnJiYXBaRFFOL2l1bXViVXdiL29BTzNBem1wS0pnN1BUbVJBYkE0 ▶" ] ]
0 of 0array:4 [▼ "_token" => "5U2vNBwGG7dR3E7sS0o5ACifVZ4rr2RivngBgn5K" "_previous" => array:1 [▶ "url" => "https://shop72.com/category/Games_Sports" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
