| 1 x Booting (56.34%) | 237.73ms |
| 1 x Application (42.94%) | 181.17ms |
| Params | |
|---|---|
| 0 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
select * from `lang` where `active` = 1 and `iso_code` = 'en' limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `currency` where `active` = 1 and `iso_code_currency` = 'USD' limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `geo_ip_location` where `geo_ip_location`.`ip` = '216.73.216.226' limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `geo_country` where `active` = 1 and `iso_code` = 'US' limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category` where `active` = 1 and `category_id` = '8' limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `category_id` from `category` where `active` = 1 and lft >= 4 AND rgt <= 5| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `product` where exists (select * from `product_availability` where `product`.`product_id` = `product_availability`.`product_id` and `country_code` in ('ALL', 'US')) and exists (select * from `product_category` where `product`.`product_id` = `product_category`.`product_id` and `category_id` in (8)) and `product`.`active` = 1 and `product`.`deleted_at` is null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `manufacturer_lang` where `manufacturer_lang`.`manufacturer_id` in (12) and `manufacturer_lang`.`deleted_at` is null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `product_image` where `cover` = 1 and `product_image`.`product_id` in (75, 90)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `product_image` where `product_image`.`product_id` in (75, 90)| Metadata | |
|---|---|
| Backtrace |
|
select * from `product_discount_promotion` where (date_from <= NOW() AND date_to >= NOW()) or (date_from is null) and `active` = 1 and `product_discount_promotion`.`product_id` in (75, 90) and country_id = 0 OR country_id = 236| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `product_category` where `product_category`.`product_id` in (75, 90)| Metadata | |
|---|---|
| Backtrace |
|
select * from `category` where `category`.`category_id` in (8)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category_lang` where `category_lang`.`category_id` in (8) and `lang_id` = 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `product_lang` where `product_lang`.`product_id` in (75, 90) and `lang_id` = 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `product_attribute_combination` where `product_attribute_combination`.`product_id` in (75, 90) order by `default_on` desc| Metadata | |
|---|---|
| Backtrace |
|
select * from `attribute_lang` where `attribute_lang`.`attribute_id` in (0) and `lang_id` = 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `product_image` where `product_image`.`product_id` = 75 and `product_image`.`product_id` is not null and `cover` = 1 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `product_image` where `product_image`.`product_id` = 75 and `product_image`.`product_id` is not null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select avg(`rating`) as aggregate from `product_review` where `product_id` = 75| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `product_category` where `product_category`.`product_id` = 75 and `product_category`.`product_id` is not null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category_lang` where `category_lang`.`category_id` = 8 and `category_lang`.`category_id` is not null limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category_lang` where `category_lang`.`category_id` = 8 and `category_lang`.`category_id` is not null and `lang_id` = 1 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category` where `category`.`category_id` = 8 and `category`.`category_id` is not null limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `product_image` where `product_image`.`product_id` = 90 and `product_image`.`product_id` is not null and `cover` = 1 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `product_image` where `product_image`.`product_id` = 90 and `product_image`.`product_id` is not null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select avg(`rating`) as aggregate from `product_review` where `product_id` = 90| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `product_category` where `product_category`.`product_id` = 90 and `product_category`.`product_id` is not null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category_lang` where `category_lang`.`category_id` = 8 and `category_lang`.`category_id` is not null limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category_lang` where `category_lang`.`category_id` = 8 and `category_lang`.`category_id` is not null and `lang_id` = 1 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category` where `category`.`category_id` = 8 and `category`.`category_id` is not null limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category` inner join `category_lang` on `category`.`category_id` = `category_lang`.`category_id` and `category_lang`.`lang_id` = 1 where `active` = 1 and `parent` = 1 order by `position` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category` where `active` = 1 and `category_id` = 2 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `category_id` from `category` where `active` = 1 and lft >= 8 AND rgt <= 11| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `product_category` where exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and `active` = 1 and `product`.`deleted_at` is null) and exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and exists (select * from `product_availability` where `product`.`product_id` = `product_availability`.`product_id` and `country_code` in ('ALL', 'US')) and `product`.`deleted_at` is null) and `category_id` in (2)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category_lang` where `category_lang`.`category_id` = 2 and `category_lang`.`category_id` is not null and `lang_id` = 1 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category` where `active` = 1 and `category_id` = 5 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `category_id` from `category` where `active` = 1 and lft >= 16 AND rgt <= 17| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `product_category` where exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and `active` = 1 and `product`.`deleted_at` is null) and exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and exists (select * from `product_availability` where `product`.`product_id` = `product_availability`.`product_id` and `country_code` in ('ALL', 'US')) and `product`.`deleted_at` is null) and `category_id` in (5)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category_lang` where `category_lang`.`category_id` = 5 and `category_lang`.`category_id` is not null and `lang_id` = 1 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category` where `active` = 1 and `category_id` = 3 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `category_id` from `category` where `active` = 1 and lft >= 12 AND rgt <= 13| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `product_category` where exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and `active` = 1 and `product`.`deleted_at` is null) and exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and exists (select * from `product_availability` where `product`.`product_id` = `product_availability`.`product_id` and `country_code` in ('ALL', 'US')) and `product`.`deleted_at` is null) and `category_id` in (3)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category` where `active` = 1 and `category_id` = 4 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `category_id` from `category` where `active` = 1 and lft >= 14 AND rgt <= 15| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `product_category` where exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and `active` = 1 and `product`.`deleted_at` is null) and exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and exists (select * from `product_availability` where `product`.`product_id` = `product_availability`.`product_id` and `country_code` in ('ALL', 'US')) and `product`.`deleted_at` is null) and `category_id` in (4)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category` where `active` = 1 and `category_id` = 7 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `category_id` from `category` where `active` = 1 and lft >= 6 AND rgt <= 7| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `product_category` where exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and `active` = 1 and `product`.`deleted_at` is null) and exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and exists (select * from `product_availability` where `product`.`product_id` = `product_availability`.`product_id` and `country_code` in ('ALL', 'US')) and `product`.`deleted_at` is null) and `category_id` in (7)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category_lang` where `category_lang`.`category_id` = 7 and `category_lang`.`category_id` is not null and `lang_id` = 1 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category` where `active` = 1 and `category_id` = 9 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `category_id` from `category` where `active` = 1 and lft >= 2 AND rgt <= 3| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `product_category` where exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and `active` = 1 and `product`.`deleted_at` is null) and exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and exists (select * from `product_availability` where `product`.`product_id` = `product_availability`.`product_id` and `country_code` in ('ALL', 'US')) and `product`.`deleted_at` is null) and `category_id` in (9)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category_lang` where `category_lang`.`category_id` = 9 and `category_lang`.`category_id` is not null and `lang_id` = 1 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category` where `active` = 1 and `category_id` = 8 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `category_id` from `category` where `active` = 1 and lft >= 4 AND rgt <= 5| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `product_category` where exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and `active` = 1 and `product`.`deleted_at` is null) and exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and exists (select * from `product_availability` where `product`.`product_id` = `product_availability`.`product_id` and `country_code` in ('ALL', 'US')) and `product`.`deleted_at` is null) and `category_id` in (8)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category_lang` where `category_lang`.`category_id` = 8 and `category_lang`.`category_id` is not null and `lang_id` = 1 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `lang` where `active` = 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `currency` where `active` = 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `lang` where `iso_code` = 'light' limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `lang` where `iso_code` = 'en' limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category` inner join `category_lang` on `category`.`category_id` = `category_lang`.`category_id` and `category_lang`.`lang_id` = 1 where `active` = 1 and `parent` = 1 order by `position` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `category_id` from `category` where `active` = 1 and (lft >= 8 AND rgt <= 11) order by `depth` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `product_category` where exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and `offline` = 1 and `product`.`deleted_at` is null) and exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and exists (select * from `product_availability` where `product`.`product_id` = `product_availability`.`product_id` and `country_code` in ('ALL', 'US')) and `product`.`deleted_at` is null) and `category_id` in (2)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `category_id` from `category` where `active` = 1 and (lft >= 16 AND rgt <= 17) order by `depth` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `product_category` where exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and `offline` = 1 and `product`.`deleted_at` is null) and exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and exists (select * from `product_availability` where `product`.`product_id` = `product_availability`.`product_id` and `country_code` in ('ALL', 'US')) and `product`.`deleted_at` is null) and `category_id` in (5)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `category_id` from `category` where `active` = 1 and (lft >= 12 AND rgt <= 13) order by `depth` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `product_category` where exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and `offline` = 1 and `product`.`deleted_at` is null) and exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and exists (select * from `product_availability` where `product`.`product_id` = `product_availability`.`product_id` and `country_code` in ('ALL', 'US')) and `product`.`deleted_at` is null) and `category_id` in (3)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `category_id` from `category` where `active` = 1 and (lft >= 14 AND rgt <= 15) order by `depth` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `product_category` where exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and `offline` = 1 and `product`.`deleted_at` is null) and exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and exists (select * from `product_availability` where `product`.`product_id` = `product_availability`.`product_id` and `country_code` in ('ALL', 'US')) and `product`.`deleted_at` is null) and `category_id` in (4)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `category_id` from `category` where `active` = 1 and (lft >= 6 AND rgt <= 7) order by `depth` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `product_category` where exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and `offline` = 1 and `product`.`deleted_at` is null) and exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and exists (select * from `product_availability` where `product`.`product_id` = `product_availability`.`product_id` and `country_code` in ('ALL', 'US')) and `product`.`deleted_at` is null) and `category_id` in (7)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `category_id` from `category` where `active` = 1 and (lft >= 2 AND rgt <= 3) order by `depth` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `product_category` where exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and `offline` = 1 and `product`.`deleted_at` is null) and exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and exists (select * from `product_availability` where `product`.`product_id` = `product_availability`.`product_id` and `country_code` in ('ALL', 'US')) and `product`.`deleted_at` is null) and `category_id` in (9)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `category_id` from `category` where `active` = 1 and (lft >= 4 AND rgt <= 5) order by `depth` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `product_category` where exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and `offline` = 1 and `product`.`deleted_at` is null) and exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and exists (select * from `product_availability` where `product`.`product_id` = `product_availability`.`product_id` and `country_code` in ('ALL', 'US')) and `product`.`deleted_at` is null) and `category_id` in (8)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category_lang` where `category_lang`.`category_id` = 2 and `category_lang`.`category_id` is not null and `lang_id` = 1 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category_lang` where `category_lang`.`category_id` = 5 and `category_lang`.`category_id` is not null and `lang_id` = 1 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category_lang` where `category_lang`.`category_id` = 3 and `category_lang`.`category_id` is not null and `lang_id` = 1 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category_lang` where `category_lang`.`category_id` = 7 and `category_lang`.`category_id` is not null and `lang_id` = 1 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category_lang` where `category_lang`.`category_id` = 9 and `category_lang`.`category_id` is not null and `lang_id` = 1 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category_lang` where `category_lang`.`category_id` = 8 and `category_lang`.`category_id` is not null and `lang_id` = 1 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category` inner join `category_lang` on `category`.`category_id` = `category_lang`.`category_id` and `category_lang`.`lang_id` = 1 where `active` = 1 and `parent` = 1 order by `position` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `category_id` from `category` where `active` = 1 and (lft >= 8 AND rgt <= 11) order by `depth` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `product_category` where exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and `offline` = 1 and `product`.`deleted_at` is null) and exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and exists (select * from `product_availability` where `product`.`product_id` = `product_availability`.`product_id` and `country_code` in ('ALL', 'US')) and `product`.`deleted_at` is null) and `category_id` in (2)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `category_id` from `category` where `active` = 1 and (lft >= 16 AND rgt <= 17) order by `depth` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `product_category` where exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and `offline` = 1 and `product`.`deleted_at` is null) and exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and exists (select * from `product_availability` where `product`.`product_id` = `product_availability`.`product_id` and `country_code` in ('ALL', 'US')) and `product`.`deleted_at` is null) and `category_id` in (5)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `category_id` from `category` where `active` = 1 and (lft >= 12 AND rgt <= 13) order by `depth` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `product_category` where exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and `offline` = 1 and `product`.`deleted_at` is null) and exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and exists (select * from `product_availability` where `product`.`product_id` = `product_availability`.`product_id` and `country_code` in ('ALL', 'US')) and `product`.`deleted_at` is null) and `category_id` in (3)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `category_id` from `category` where `active` = 1 and (lft >= 14 AND rgt <= 15) order by `depth` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `product_category` where exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and `offline` = 1 and `product`.`deleted_at` is null) and exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and exists (select * from `product_availability` where `product`.`product_id` = `product_availability`.`product_id` and `country_code` in ('ALL', 'US')) and `product`.`deleted_at` is null) and `category_id` in (4)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `category_id` from `category` where `active` = 1 and (lft >= 6 AND rgt <= 7) order by `depth` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `product_category` where exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and `offline` = 1 and `product`.`deleted_at` is null) and exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and exists (select * from `product_availability` where `product`.`product_id` = `product_availability`.`product_id` and `country_code` in ('ALL', 'US')) and `product`.`deleted_at` is null) and `category_id` in (7)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `category_id` from `category` where `active` = 1 and (lft >= 2 AND rgt <= 3) order by `depth` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `product_category` where exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and `offline` = 1 and `product`.`deleted_at` is null) and exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and exists (select * from `product_availability` where `product`.`product_id` = `product_availability`.`product_id` and `country_code` in ('ALL', 'US')) and `product`.`deleted_at` is null) and `category_id` in (9)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `category_id` from `category` where `active` = 1 and (lft >= 4 AND rgt <= 5) order by `depth` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `product_category` where exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and `offline` = 1 and `product`.`deleted_at` is null) and exists (select * from `product` where `product_category`.`product_id` = `product`.`product_id` and exists (select * from `product_availability` where `product`.`product_id` = `product_availability`.`product_id` and `country_code` in ('ALL', 'US')) and `product`.`deleted_at` is null) and `category_id` in (8)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category_lang` where `category_lang`.`category_id` = 2 and `category_lang`.`category_id` is not null limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `category_id`, `icon`, `parent` from `category` where `category`.`parent` = 2 and `category`.`parent` is not null and `active` = 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category_lang` where `category_lang`.`category_id` = 5 and `category_lang`.`category_id` is not null limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `category_id`, `icon`, `parent` from `category` where `category`.`parent` = 5 and `category`.`parent` is not null and `active` = 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category_lang` where `category_lang`.`category_id` = 3 and `category_lang`.`category_id` is not null limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `category_id`, `icon`, `parent` from `category` where `category`.`parent` = 3 and `category`.`parent` is not null and `active` = 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category_lang` where `category_lang`.`category_id` = 7 and `category_lang`.`category_id` is not null limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `category_id`, `icon`, `parent` from `category` where `category`.`parent` = 7 and `category`.`parent` is not null and `active` = 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category_lang` where `category_lang`.`category_id` = 9 and `category_lang`.`category_id` is not null limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `category_id`, `icon`, `parent` from `category` where `category`.`parent` = 9 and `category`.`parent` is not null and `active` = 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category_lang` where `category_lang`.`category_id` = 8 and `category_lang`.`category_id` is not null limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `category_id`, `icon`, `parent` from `category` where `category`.`parent` = 8 and `category`.`parent` is not null and `active` = 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `category` inner join `category_lang` on `category`.`category_id` = `category_lang`.`category_id` and `category_lang`.`lang_id` = 1 where `active` = 1 and `parent` = 1 order by `position` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
200
0 of 0array:2 [▼ "cId" => "8" "page" => "3" ]
0 of 0array:2 [▼ "cId" => "8" "page" => "3" ]
0 of 0array:17 [▼ "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "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" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua" => array:1 [▶ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "connection" => array:1 [▶ 0 => "keep-alive" ] "host" => array:1 [▶ 0 => "sn-store.unimart.work" ] "content-length" => array:1 [▶ 0 => "" ] "content-type" => array:1 [▶ 0 => "" ] ]
0 of 0array:42 [▼ "USER" => "www-data" "HOME" => "/var/www" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_SITE" => "none" "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_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_PRAGMA" => "no-cache" "HTTP_CONNECTION" => "keep-alive" "HTTP_HOST" => "sn-store.unimart.work" "REDIRECT_STATUS" => "200" "SERVER_NAME" => "sn-store.unimart.work" "SERVER_PORT" => "443" "SERVER_ADDR" => "139.162.128.201" "REMOTE_USER" => "" "REMOTE_PORT" => "22779" "REMOTE_ADDR" => "216.73.216.226" "SERVER_SOFTWARE" => "nginx/1.18.0" "GATEWAY_INTERFACE" => "CGI/1.1" "HTTPS" => "on" "REQUEST_SCHEME" => "https" "SERVER_PROTOCOL" => "HTTP/1.1" "DOCUMENT_ROOT" => "/var/www/snono/unimart-ecommerce-store/public" "DOCUMENT_URI" => "/index.php" "REQUEST_URI" => "/search?cId=8&page=3" "SCRIPT_NAME" => "/index.php" "CONTENT_LENGTH" => "" "CONTENT_TYPE" => "" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "cId=8&page=3" "SCRIPT_FILENAME" => "/var/www/snono/unimart-ecommerce-store/public/index.php" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1753651569.9963 "REQUEST_TIME" => 1753651569 ]
[]
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 => "Sun, 27 Jul 2025 21:26:10 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlRlcWV0UG1oU1JwRjZnYkxuejFlZEE9PSIsInZhbHVlIjoiMlZuV25RQlhFR0pNM3JXTXI0NUJNWitxa3NEWkRDNFptWTg5YUNSRGMyNEgzOWVYbmNjWDkxZUVQSFh3bWJLak5ENHRJbStxRnBHc2JjN1pyK1licDdxSDU1MnMrSXAyTGI3Wk5KM0E2QjB0MTB6NFNXY0pwd21zZjlKaENENDkiLCJtYWMiOiI3OGIwZjExMTFkZDY1YzU2NmIzODFmZmMyMmY1N2Y2MWY1NjAyMmMzYjM0YjU2ZGVlMGFlNjdlM2U5YTZkZDczIiwidGFnIjoiIn0%3D; expires=Wed, 30-Jul-2025 07:46:10 GMT; Max-Age=210000; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IlRlcWV0UG1oU1JwRjZnYkxuejFlZEE9PSIsInZhbHVlIjoiMlZuV25RQlhFR0pNM3JXTXI0NUJNWitxa3NEWkRDNFptWTg5YUNSRGMyNEgzOWVYbmNjWDkxZUVQSFh3bWJLak5ENHRJb ▶" 1 => "STORE_UNIMART_SESSION=eyJpdiI6ImdKcUZOOGlzUHdqY2pZVEFRdzhmR3c9PSIsInZhbHVlIjoicEZVTjdncEdTMlFISFg3U1ZKSGZDTFlrYUhTSGtFNjJyaElkWjVaMFlZaUFBYmtxT25DeVNwU053dTM0QjZ1V0VtOXZ5ZVdxaWgyd2I3c2RkMGMwci92QytEdjU2SlVKM3RHSytUMWlORGlXNnpyeXVySWYwTk9wc1VXWW5tM2oiLCJtYWMiOiJmODZlM2ZlODI3ZDE5YTczZTg5ZTljOTdiZjNiMmUzYmM4MWFmZDJmNGY3YWE2MWQwYzVhMTUyMmUwOTM1NTExIiwidGFnIjoiIn0%3D; expires=Wed, 30-Jul-2025 07:46:10 GMT; Max-Age=210000; path=/; httponly; samesite=lax ◀STORE_UNIMART_SESSION=eyJpdiI6ImdKcUZOOGlzUHdqY2pZVEFRdzhmR3c9PSIsInZhbHVlIjoicEZVTjdncEdTMlFISFg3U1ZKSGZDTFlrYUhTSGtFNjJyaElkWjVaMFlZaUFBYmtxT25DeVNwU053dTM0Qj ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlRlcWV0UG1oU1JwRjZnYkxuejFlZEE9PSIsInZhbHVlIjoiMlZuV25RQlhFR0pNM3JXTXI0NUJNWitxa3NEWkRDNFptWTg5YUNSRGMyNEgzOWVYbmNjWDkxZUVQSFh3bWJLak5ENHRJbStxRnBHc2JjN1pyK1licDdxSDU1MnMrSXAyTGI3Wk5KM0E2QjB0MTB6NFNXY0pwd21zZjlKaENENDkiLCJtYWMiOiI3OGIwZjExMTFkZDY1YzU2NmIzODFmZmMyMmY1N2Y2MWY1NjAyMmMzYjM0YjU2ZGVlMGFlNjdlM2U5YTZkZDczIiwidGFnIjoiIn0%3D; expires=Wed, 30-Jul-2025 07:46:10 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlRlcWV0UG1oU1JwRjZnYkxuejFlZEE9PSIsInZhbHVlIjoiMlZuV25RQlhFR0pNM3JXTXI0NUJNWitxa3NEWkRDNFptWTg5YUNSRGMyNEgzOWVYbmNjWDkxZUVQSFh3bWJLak5ENHRJb ▶" 1 => "STORE_UNIMART_SESSION=eyJpdiI6ImdKcUZOOGlzUHdqY2pZVEFRdzhmR3c9PSIsInZhbHVlIjoicEZVTjdncEdTMlFISFg3U1ZKSGZDTFlrYUhTSGtFNjJyaElkWjVaMFlZaUFBYmtxT25DeVNwU053dTM0QjZ1V0VtOXZ5ZVdxaWgyd2I3c2RkMGMwci92QytEdjU2SlVKM3RHSytUMWlORGlXNnpyeXVySWYwTk9wc1VXWW5tM2oiLCJtYWMiOiJmODZlM2ZlODI3ZDE5YTczZTg5ZTljOTdiZjNiMmUzYmM4MWFmZDJmNGY3YWE2MWQwYzVhMTUyMmUwOTM1NTExIiwidGFnIjoiIn0%3D; expires=Wed, 30-Jul-2025 07:46:10 GMT; path=/; httponly ◀STORE_UNIMART_SESSION=eyJpdiI6ImdKcUZOOGlzUHdqY2pZVEFRdzhmR3c9PSIsInZhbHVlIjoicEZVTjdncEdTMlFISFg3U1ZKSGZDTFlrYUhTSGtFNjJyaElkWjVaMFlZaUFBYmtxT25DeVNwU053dTM0Qj ▶" ] ]
0 of 0array:7 [▼ "lang" => "en" "direction" => "ltr" "currency" => "USD" "_token" => "bfHFaFcOYdSrON5DcSMKq8dvBmR7oau00wesRKGh" "_flash" => array:2 [▶ "old" => [] "new" => [] ] "_previous" => array:1 [▶ "url" => "https://sn-store.unimart.work/search?cId=8&page=3" ] "PHPDEBUGBAR_STACK_DATA" => [] ]