Check Product Deliverability
If your city is not on the list we cannot deliver the product there.
Shoe Sizes | 11k, 12k, 13k, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11 |
---|
Average Rating
Related Products
1 x Application (88.75%) | 276ms |
1 x Booting (11.25%) | 34.99ms |
# Query soft limit for Debugbar is reached after 100 queries, additional 49 queries only show the query. Limit can be raised in the config. Limits can be raised in the config (debugbar.options.db.soft_limit)
select * from `stores` where `is_default_store` = 1 and `status` = 1 limit 1
Bindings |
|
Backtrace |
|
select * from `stores` where (`slug` = 'kappaas-uniforms')
Bindings |
|
Backtrace |
|
select * from `settings` where `variable` = 'system_settings' limit 1
Bindings |
|
Backtrace |
|
select `p`.`id`, `p`.`category_id`, `p`.`no_of_ratings`, `p`.`brand`, `b`.`name` as `brand_name`, GROUP_CONCAT(pa.attribute_value_ids) as attr_value_ids from `products` as `p` left join `categories` as `c` on `p`.`category_id` = `c`.`id` left join `brands` as `b` on `p`.`brand` = `b`.`id` left join `seller_data` as `sd` on `p`.`seller_id` = `sd`.`id` left join `seller_store` as `ss` on `p`.`seller_id` = `ss`.`seller_id` left join `product_variants` as `pv` on `p`.`id` = `pv`.`product_id` left join `product_attributes` as `pa` on `pa`.`product_id` = `p`.`id` left join `order_items` as `oi` on `oi`.`product_variant_id` = `pv`.`id` left join `taxes` as `tax_id` on FIND_IN_SET(tax_id.id, p.tax) > 0 left join `taxes` as `tax` on FIND_IN_SET(tax.id, p.tax) > 0 where `p`.`slug` = 'action-campus-shoes' and (`p`.`status` = '1' and `pv`.`status` = 1 and `sd`.`status` = 1 and `p`.`store_id` = 1) and (`c`.`status` = '1' or `c`.`status` = '0') group by `p`.`id`, `p`.`id` order by `p`.`row_order` asc
Bindings |
|
Backtrace |
|
select `p`.*, `b`.`name` as `brand_name`, `b`.`slug` as `brand_slug`, `ss`.`rating` as `seller_rating`, `ss`.`slug` as `seller_slug`, `ss`.`no_of_ratings` as `seller_no_of_ratings`, `ss`.`logo` as `seller_profile`, `ss`.`store_name` as `store_name`, `ss`.`store_description`, `u`.`username` as `seller_name`, `c`.`name` as `category_name`, `c`.`slug` as `category_slug`, SUM(oi.quantity) as total_sale, (SELECT GROUP_CONCAT(tax.percentage) FROM taxes as tax WHERE FIND_IN_SET(tax.id, p.tax)) as tax_percentage, GROUP_CONCAT(DISTINCT tax_id.id) as tax_id, GROUP_CONCAT(DISTINCT pa.attribute_value_ids) as attr_value_ids from `products` as `p` left join `seller_data` as `sd` on `p`.`seller_id` = `sd`.`id` left join `seller_store` as `ss` on `p`.`seller_id` = `ss`.`seller_id` left join `categories` as `c` on `p`.`category_id` = `c`.`id` left join `brands` as `b` on `p`.`brand` = `b`.`id` left join `users` as `u` on `u`.`id` = `sd`.`user_id` left join `product_variants` as `pv` on `p`.`id` = `pv`.`product_id` left join `order_items` as `oi` on `oi`.`product_variant_id` = `pv`.`id` left join `taxes` as `tax_id` on FIND_IN_SET(tax_id.id, p.tax) > 0 left join `product_attributes` as `pa` on `pa`.`product_id` = `p`.`id` left join `taxes` as `tax` on FIND_IN_SET(tax.id, p.tax) > 0 where `p`.`slug` = 'action-campus-shoes' and `p`.`store_id` = 1 and (`p`.`status` = '1' and `pv`.`status` = 1 and `sd`.`status` = 1) and (`c`.`status` = '1' or `c`.`status` = '0') group by `p`.`id`, `p`.`id` order by `p`.`id` desc, `pv`.`price` desc, `p`.`row_order` asc limit 20 offset 0
Bindings |
|
Backtrace |
|
select IF(pv.special_price > 0, pv.special_price, pv.price) as pr_price,
p.is_prices_inclusive_tax,
IF(p.is_prices_inclusive_tax = 0 AND p.tax IS NOT NULL,
(SELECT percentage FROM taxes WHERE id = p.tax AND status = 1),
0) as tax_percentage from `products` as `p` left join `categories` as `c` on `p`.`category_id` = `c`.`id` left join `seller_data` as `sd` on `p`.`seller_id` = `sd`.`id` left join `product_variants` as `pv` on `p`.`id` = `pv`.`product_id` left join `product_attributes` as `pa` on `pa`.`product_id` = `p`.`id` where `p`.`status` = 1 and `pv`.`status` = 1 and `sd`.`status` = 1 and `p`.`store_id` = 1 and (`c`.`status` = 1 or `c`.`status` = 0)
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `product_faqs` as `pf` left join `users` as `u` on `u`.`id` = `pf`.`user_id` left join `products` as `p` on `p`.`id` = `pf`.`product_id` left join `users` as `answered_by_user` on `answered_by_user`.`id` = `pf`.`answered_by` where `pf`.`product_id` = 9
Bindings |
|
Backtrace |
|
select `pf`.*, `u`.`username` as `user_username`, `answered_by_user`.`username` as `answered_by` from `product_faqs` as `pf` left join `users` as `u` on `u`.`id` = `pf`.`user_id` left join `products` as `p` on `p`.`id` = `pf`.`product_id` left join `users` as `answered_by_user` on `answered_by_user`.`id` = `pf`.`answered_by` where `pf`.`product_id` = 9 order by `pf`.`id` desc limit 10 offset 0
Bindings |
|
Backtrace |
|
select `pr`.*, `u`.`username` as `user_name`, `u`.`image` as `user_profile` from `product_ratings` as `pr` left join `users` as `u` on `u`.`id` = `pr`.`user_id` where `pr`.`product_id` = 9
Bindings |
|
Backtrace |
|
select count(`pr`.`id`) as aggregate from `product_ratings` as `pr` left join `users` as `u` on `u`.`id` = `pr`.`user_id` where `pr`.`product_id` = 9
Bindings |
|
Backtrace |
|
select count(LENGTH(images) - LENGTH(REPLACE(images, ",", "")) + 1) as aggregate from `product_ratings` where `product_id` = 9 and `images` is not null
Bindings |
|
Backtrace |
|
select count(`pr`.`id`) as aggregate from `product_ratings` as `pr` where `product_id` = 9 and `images` is not null
Bindings |
|
Backtrace |
|
select count(pr.id) as total, sum(case when CEIL(pr.rating) = 1 then 1 else 0 end) as rating_1, sum(case when CEIL(pr.rating) = 2 then 1 else 0 end) as rating_2, sum(case when CEIL(pr.rating) = 3 then 1 else 0 end) as rating_3, sum(case when pr.rating >= 4 and pr.rating < 4.5 then 1 else 0 end) as rating_4, sum(case when pr.rating >= 4.5 then 1 else 0 end) as rating_5 from `product_ratings` as `pr` where `product_id` = 9 limit 1
Bindings |
|
Backtrace |
|
select `p`.`is_prices_inclusive_tax`, `pv`.`price`, `pv`.`special_price`, (SELECT GROUP_CONCAT(tax.percentage) FROM taxes as tax WHERE FIND_IN_SET(tax.id, p.tax)) as tax_percentage from `products` as `p` left join `product_variants` as `pv` on `p`.`id` = `pv`.`product_id` left join `taxes` as `tax_id` on FIND_IN_SET(tax_id.id, p.tax) > 0 where `p`.`id` = 9
Bindings |
|
Backtrace |
|
select
GROUP_CONCAT(av.id ORDER BY av.id ASC) as ids,
GROUP_CONCAT(' ', av.value ORDER BY av.id ASC) as value,
a.name as attr_name,
a.name from `product_attributes` as `pa` inner join `attribute_values` as `av` on FIND_IN_SET(av.id, pa.attribute_value_ids) > 0 inner join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` where `pa`.`product_id` = 9 group by `a`.`name`
Bindings |
|
Backtrace |
|
select pv.*, pv.product_id,p.name as product_name,p.image as product_image,
group_concat(av.id ORDER BY av.id ASC) as variant_ids,
group_concat(a.name ORDER BY av.id ASC SEPARATOR " ") as attr_name,
group_concat(av.value ORDER BY av.id ASC) as variant_values,
group_concat(av.swatche_type ORDER BY av.id ASC ) as swatche_type ,
group_concat(av.swatche_value ORDER BY av.id ASC ) as swatche_value,
pv.price as price from `product_variants` as `pv` left join `attribute_values` as `av` on FIND_IN_SET(av.id, pv.attribute_value_ids) > 0 left join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` left join `products` as `p` on `p`.`id` = `pv`.`product_id` where `pv`.`product_id` = 9 and `pv`.`status` in (1) group by `pv`.`id` order by `pv`.`id` asc
Bindings |
|
Backtrace |
|
select `p`.`is_prices_inclusive_tax`, `pv`.`price`, `pv`.`special_price`, (SELECT GROUP_CONCAT(tax.percentage) FROM taxes as tax WHERE FIND_IN_SET(tax.id, p.tax)) as tax_percentage from `products` as `p` left join `taxes` as `tax_id` on FIND_IN_SET(tax_id.id, p.tax) > 0 left join `product_variants` as `pv` on `p`.`id` = `pv`.`product_id` where `p`.`id` = 9
Bindings |
|
Backtrace |
|
select * from `taxes` where `id` in ('0')
Bindings |
|
Backtrace |
|
select * from `taxes` where `id` in ('0')
Bindings |
|
Backtrace |
|
select * from `zones` where `id` in ('')
Bindings |
|
Backtrace |
|
select * from `currencies`
Backtrace |
|
select `attributes`.`name` as `attribute_name`, GROUP_CONCAT(attribute_values.value ORDER BY attribute_values.id ASC) AS attribute_values, GROUP_CONCAT(attribute_values.id ORDER BY attribute_values.id ASC) AS attribute_values_id from `attribute_values` inner join `attributes` on `attribute_values`.`attribute_id` = `attributes`.`id` where `attribute_values`.`id` in ('19', '20', '21', '22', '23', '24', '25', '26', '27', '28', '29', '30', '31', '32') group by `attributes`.`name`
Bindings |
|
Backtrace |
|
select * from `products` where (`id` = 9)
Bindings |
|
Backtrace |
|
select `p`.`id` from `products` as `p` inner join `categories` as `c` on `p`.`category_id` = `c`.`id` inner join `brands` as `b` on `p`.`brand` = `b`.`id` where ((`p`.`category_id` = 2 or `p`.`brand` = '' or `p`.`store_id` = 1)) and `p`.`id` not in (9) group by `p`.`id` limit 10
Bindings |
|
Backtrace |
|
select `p`.`id`, `p`.`category_id`, `p`.`no_of_ratings`, `p`.`brand`, `b`.`name` as `brand_name`, GROUP_CONCAT(pa.attribute_value_ids) as attr_value_ids from `products` as `p` left join `categories` as `c` on `p`.`category_id` = `c`.`id` left join `brands` as `b` on `p`.`brand` = `b`.`id` left join `seller_data` as `sd` on `p`.`seller_id` = `sd`.`id` left join `seller_store` as `ss` on `p`.`seller_id` = `ss`.`seller_id` left join `product_variants` as `pv` on `p`.`id` = `pv`.`product_id` left join `product_attributes` as `pa` on `pa`.`product_id` = `p`.`id` left join `order_items` as `oi` on `oi`.`product_variant_id` = `pv`.`id` left join `taxes` as `tax_id` on FIND_IN_SET(tax_id.id, p.tax) > 0 left join `taxes` as `tax` on FIND_IN_SET(tax.id, p.tax) > 0 where (`p`.`status` = '1' and `pv`.`status` = 1 and `sd`.`status` = 1) and (`c`.`status` = '1' or `c`.`status` = '0') group by `p`.`id`, `p`.`id` order by `p`.`row_order` asc
Bindings |
|
Backtrace |
|
select `p`.*, `b`.`name` as `brand_name`, `b`.`slug` as `brand_slug`, `ss`.`rating` as `seller_rating`, `ss`.`slug` as `seller_slug`, `ss`.`no_of_ratings` as `seller_no_of_ratings`, `ss`.`logo` as `seller_profile`, `ss`.`store_name` as `store_name`, `ss`.`store_description`, `u`.`username` as `seller_name`, `c`.`name` as `category_name`, `c`.`slug` as `category_slug`, SUM(oi.quantity) as total_sale, (SELECT GROUP_CONCAT(tax.percentage) FROM taxes as tax WHERE FIND_IN_SET(tax.id, p.tax)) as tax_percentage, GROUP_CONCAT(DISTINCT tax_id.id) as tax_id, GROUP_CONCAT(DISTINCT pa.attribute_value_ids) as attr_value_ids from `products` as `p` left join `seller_data` as `sd` on `p`.`seller_id` = `sd`.`id` left join `seller_store` as `ss` on `p`.`seller_id` = `ss`.`seller_id` left join `categories` as `c` on `p`.`category_id` = `c`.`id` left join `brands` as `b` on `p`.`brand` = `b`.`id` left join `users` as `u` on `u`.`id` = `sd`.`user_id` left join `product_variants` as `pv` on `p`.`id` = `pv`.`product_id` left join `order_items` as `oi` on `oi`.`product_variant_id` = `pv`.`id` left join `taxes` as `tax_id` on FIND_IN_SET(tax_id.id, p.tax) > 0 left join `product_attributes` as `pa` on `pa`.`product_id` = `p`.`id` left join `taxes` as `tax` on FIND_IN_SET(tax.id, p.tax) > 0 where (`p`.`status` = '1' and `pv`.`status` = 1 and `sd`.`status` = 1) and (`c`.`status` = '1' or `c`.`status` = '0') group by `p`.`id`, `p`.`id` order by `p`.`id` desc, `pv`.`price` desc, `p`.`row_order` asc limit 20 offset 0
Bindings |
|
Backtrace |
|
select
GROUP_CONCAT(av.id ORDER BY av.id ASC) as ids,
GROUP_CONCAT(' ', av.value ORDER BY av.id ASC) as value,
a.name as attr_name,
a.name from `product_attributes` as `pa` inner join `attribute_values` as `av` on FIND_IN_SET(av.id, pa.attribute_value_ids) > 0 inner join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` where `pa`.`product_id` = 18 group by `a`.`name`
Bindings |
|
Backtrace |
|
select pv.*, pv.product_id,p.name as product_name,p.image as product_image,
group_concat(av.id ORDER BY av.id ASC) as variant_ids,
group_concat(a.name ORDER BY av.id ASC SEPARATOR " ") as attr_name,
group_concat(av.value ORDER BY av.id ASC) as variant_values,
group_concat(av.swatche_type ORDER BY av.id ASC ) as swatche_type ,
group_concat(av.swatche_value ORDER BY av.id ASC ) as swatche_value,
pv.price as price from `product_variants` as `pv` left join `attribute_values` as `av` on FIND_IN_SET(av.id, pv.attribute_value_ids) > 0 left join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` left join `products` as `p` on `p`.`id` = `pv`.`product_id` where `pv`.`product_id` = 18 and `pv`.`status` in (1) group by `pv`.`id` order by `pv`.`id` asc
Bindings |
|
Backtrace |
|
select `p`.`is_prices_inclusive_tax`, `pv`.`price`, `pv`.`special_price`, (SELECT GROUP_CONCAT(tax.percentage) FROM taxes as tax WHERE FIND_IN_SET(tax.id, p.tax)) as tax_percentage from `products` as `p` left join `taxes` as `tax_id` on FIND_IN_SET(tax_id.id, p.tax) > 0 left join `product_variants` as `pv` on `p`.`id` = `pv`.`product_id` where `p`.`id` = 18
Bindings |
|
Backtrace |
|
select * from `taxes` where `id` in ('0')
Bindings |
|
Backtrace |
|
select * from `taxes` where `id` in ('0')
Bindings |
|
Backtrace |
|
select * from `zones` where `id` in ('')
Bindings |
|
Backtrace |
|
select
GROUP_CONCAT(av.id ORDER BY av.id ASC) as ids,
GROUP_CONCAT(' ', av.value ORDER BY av.id ASC) as value,
a.name as attr_name,
a.name from `product_attributes` as `pa` inner join `attribute_values` as `av` on FIND_IN_SET(av.id, pa.attribute_value_ids) > 0 inner join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` where `pa`.`product_id` = 17 group by `a`.`name`
Bindings |
|
Backtrace |
|
select pv.*, pv.product_id,p.name as product_name,p.image as product_image,
group_concat(av.id ORDER BY av.id ASC) as variant_ids,
group_concat(a.name ORDER BY av.id ASC SEPARATOR " ") as attr_name,
group_concat(av.value ORDER BY av.id ASC) as variant_values,
group_concat(av.swatche_type ORDER BY av.id ASC ) as swatche_type ,
group_concat(av.swatche_value ORDER BY av.id ASC ) as swatche_value,
pv.price as price from `product_variants` as `pv` left join `attribute_values` as `av` on FIND_IN_SET(av.id, pv.attribute_value_ids) > 0 left join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` left join `products` as `p` on `p`.`id` = `pv`.`product_id` where `pv`.`product_id` = 17 and `pv`.`status` in (1) group by `pv`.`id` order by `pv`.`id` asc
Bindings |
|
Backtrace |
|
select `p`.`is_prices_inclusive_tax`, `pv`.`price`, `pv`.`special_price`, (SELECT GROUP_CONCAT(tax.percentage) FROM taxes as tax WHERE FIND_IN_SET(tax.id, p.tax)) as tax_percentage from `products` as `p` left join `taxes` as `tax_id` on FIND_IN_SET(tax_id.id, p.tax) > 0 left join `product_variants` as `pv` on `p`.`id` = `pv`.`product_id` where `p`.`id` = 17
Bindings |
|
Backtrace |
|
select * from `taxes` where `id` in ('0')
Bindings |
|
Backtrace |
|
select * from `taxes` where `id` in ('0')
Bindings |
|
Backtrace |
|
select * from `zones` where `id` in ('')
Bindings |
|
Backtrace |
|
select
GROUP_CONCAT(av.id ORDER BY av.id ASC) as ids,
GROUP_CONCAT(' ', av.value ORDER BY av.id ASC) as value,
a.name as attr_name,
a.name from `product_attributes` as `pa` inner join `attribute_values` as `av` on FIND_IN_SET(av.id, pa.attribute_value_ids) > 0 inner join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` where `pa`.`product_id` = 16 group by `a`.`name`
Bindings |
|
Backtrace |
|
select pv.*, pv.product_id,p.name as product_name,p.image as product_image,
group_concat(av.id ORDER BY av.id ASC) as variant_ids,
group_concat(a.name ORDER BY av.id ASC SEPARATOR " ") as attr_name,
group_concat(av.value ORDER BY av.id ASC) as variant_values,
group_concat(av.swatche_type ORDER BY av.id ASC ) as swatche_type ,
group_concat(av.swatche_value ORDER BY av.id ASC ) as swatche_value,
pv.price as price from `product_variants` as `pv` left join `attribute_values` as `av` on FIND_IN_SET(av.id, pv.attribute_value_ids) > 0 left join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` left join `products` as `p` on `p`.`id` = `pv`.`product_id` where `pv`.`product_id` = 16 and `pv`.`status` in (1) group by `pv`.`id` order by `pv`.`id` asc
Bindings |
|
Backtrace |
|
select `p`.`is_prices_inclusive_tax`, `pv`.`price`, `pv`.`special_price`, (SELECT GROUP_CONCAT(tax.percentage) FROM taxes as tax WHERE FIND_IN_SET(tax.id, p.tax)) as tax_percentage from `products` as `p` left join `taxes` as `tax_id` on FIND_IN_SET(tax_id.id, p.tax) > 0 left join `product_variants` as `pv` on `p`.`id` = `pv`.`product_id` where `p`.`id` = 16
Bindings |
|
Backtrace |
|
select * from `taxes` where `id` in ('0')
Bindings |
|
Backtrace |
|
select * from `taxes` where `id` in ('0')
Bindings |
|
Backtrace |
|
select * from `zones` where `id` in ('')
Bindings |
|
Backtrace |
|
select
GROUP_CONCAT(av.id ORDER BY av.id ASC) as ids,
GROUP_CONCAT(' ', av.value ORDER BY av.id ASC) as value,
a.name as attr_name,
a.name from `product_attributes` as `pa` inner join `attribute_values` as `av` on FIND_IN_SET(av.id, pa.attribute_value_ids) > 0 inner join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` where `pa`.`product_id` = 15 group by `a`.`name`
Bindings |
|
Backtrace |
|
select pv.*, pv.product_id,p.name as product_name,p.image as product_image,
group_concat(av.id ORDER BY av.id ASC) as variant_ids,
group_concat(a.name ORDER BY av.id ASC SEPARATOR " ") as attr_name,
group_concat(av.value ORDER BY av.id ASC) as variant_values,
group_concat(av.swatche_type ORDER BY av.id ASC ) as swatche_type ,
group_concat(av.swatche_value ORDER BY av.id ASC ) as swatche_value,
pv.price as price from `product_variants` as `pv` left join `attribute_values` as `av` on FIND_IN_SET(av.id, pv.attribute_value_ids) > 0 left join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` left join `products` as `p` on `p`.`id` = `pv`.`product_id` where `pv`.`product_id` = 15 and `pv`.`status` in (1) group by `pv`.`id` order by `pv`.`id` asc
Bindings |
|
Backtrace |
|
select `p`.`is_prices_inclusive_tax`, `pv`.`price`, `pv`.`special_price`, (SELECT GROUP_CONCAT(tax.percentage) FROM taxes as tax WHERE FIND_IN_SET(tax.id, p.tax)) as tax_percentage from `products` as `p` left join `taxes` as `tax_id` on FIND_IN_SET(tax_id.id, p.tax) > 0 left join `product_variants` as `pv` on `p`.`id` = `pv`.`product_id` where `p`.`id` = 15
Bindings |
|
Backtrace |
|
select * from `taxes` where `id` in ('0')
Bindings |
|
Backtrace |
|
select * from `taxes` where `id` in ('0')
Bindings |
|
Backtrace |
|
select * from `zones` where `id` in ('')
Bindings |
|
Backtrace |
|
select
GROUP_CONCAT(av.id ORDER BY av.id ASC) as ids,
GROUP_CONCAT(' ', av.value ORDER BY av.id ASC) as value,
a.name as attr_name,
a.name from `product_attributes` as `pa` inner join `attribute_values` as `av` on FIND_IN_SET(av.id, pa.attribute_value_ids) > 0 inner join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` where `pa`.`product_id` = 14 group by `a`.`name`
Bindings |
|
Backtrace |
|
select pv.*, pv.product_id,p.name as product_name,p.image as product_image,
group_concat(av.id ORDER BY av.id ASC) as variant_ids,
group_concat(a.name ORDER BY av.id ASC SEPARATOR " ") as attr_name,
group_concat(av.value ORDER BY av.id ASC) as variant_values,
group_concat(av.swatche_type ORDER BY av.id ASC ) as swatche_type ,
group_concat(av.swatche_value ORDER BY av.id ASC ) as swatche_value,
pv.price as price from `product_variants` as `pv` left join `attribute_values` as `av` on FIND_IN_SET(av.id, pv.attribute_value_ids) > 0 left join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` left join `products` as `p` on `p`.`id` = `pv`.`product_id` where `pv`.`product_id` = 14 and `pv`.`status` in (1) group by `pv`.`id` order by `pv`.`id` asc
Bindings |
|
Backtrace |
|
select `p`.`is_prices_inclusive_tax`, `pv`.`price`, `pv`.`special_price`, (SELECT GROUP_CONCAT(tax.percentage) FROM taxes as tax WHERE FIND_IN_SET(tax.id, p.tax)) as tax_percentage from `products` as `p` left join `taxes` as `tax_id` on FIND_IN_SET(tax_id.id, p.tax) > 0 left join `product_variants` as `pv` on `p`.`id` = `pv`.`product_id` where `p`.`id` = 14
Bindings |
|
Backtrace |
|
select * from `taxes` where `id` in ('0')
Bindings |
|
Backtrace |
|
select * from `taxes` where `id` in ('0')
Bindings |
|
Backtrace |
|
select * from `zones` where `id` in ('')
Bindings |
|
Backtrace |
|
select
GROUP_CONCAT(av.id ORDER BY av.id ASC) as ids,
GROUP_CONCAT(' ', av.value ORDER BY av.id ASC) as value,
a.name as attr_name,
a.name from `product_attributes` as `pa` inner join `attribute_values` as `av` on FIND_IN_SET(av.id, pa.attribute_value_ids) > 0 inner join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` where `pa`.`product_id` = 13 group by `a`.`name`
Bindings |
|
Backtrace |
|
select pv.*, pv.product_id,p.name as product_name,p.image as product_image,
group_concat(av.id ORDER BY av.id ASC) as variant_ids,
group_concat(a.name ORDER BY av.id ASC SEPARATOR " ") as attr_name,
group_concat(av.value ORDER BY av.id ASC) as variant_values,
group_concat(av.swatche_type ORDER BY av.id ASC ) as swatche_type ,
group_concat(av.swatche_value ORDER BY av.id ASC ) as swatche_value,
pv.price as price from `product_variants` as `pv` left join `attribute_values` as `av` on FIND_IN_SET(av.id, pv.attribute_value_ids) > 0 left join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` left join `products` as `p` on `p`.`id` = `pv`.`product_id` where `pv`.`product_id` = 13 and `pv`.`status` in (1) group by `pv`.`id` order by `pv`.`id` asc
Bindings |
|
Backtrace |
|
select `p`.`is_prices_inclusive_tax`, `pv`.`price`, `pv`.`special_price`, (SELECT GROUP_CONCAT(tax.percentage) FROM taxes as tax WHERE FIND_IN_SET(tax.id, p.tax)) as tax_percentage from `products` as `p` left join `taxes` as `tax_id` on FIND_IN_SET(tax_id.id, p.tax) > 0 left join `product_variants` as `pv` on `p`.`id` = `pv`.`product_id` where `p`.`id` = 13
Bindings |
|
Backtrace |
|
select * from `taxes` where `id` in ('0')
Bindings |
|
Backtrace |
|
select * from `taxes` where `id` in ('0')
Bindings |
|
Backtrace |
|
select * from `zones` where `id` in ('')
Bindings |
|
Backtrace |
|
select
GROUP_CONCAT(av.id ORDER BY av.id ASC) as ids,
GROUP_CONCAT(' ', av.value ORDER BY av.id ASC) as value,
a.name as attr_name,
a.name from `product_attributes` as `pa` inner join `attribute_values` as `av` on FIND_IN_SET(av.id, pa.attribute_value_ids) > 0 inner join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` where `pa`.`product_id` = 12 group by `a`.`name`
Bindings |
|
Backtrace |
|
select pv.*, pv.product_id,p.name as product_name,p.image as product_image,
group_concat(av.id ORDER BY av.id ASC) as variant_ids,
group_concat(a.name ORDER BY av.id ASC SEPARATOR " ") as attr_name,
group_concat(av.value ORDER BY av.id ASC) as variant_values,
group_concat(av.swatche_type ORDER BY av.id ASC ) as swatche_type ,
group_concat(av.swatche_value ORDER BY av.id ASC ) as swatche_value,
pv.price as price from `product_variants` as `pv` left join `attribute_values` as `av` on FIND_IN_SET(av.id, pv.attribute_value_ids) > 0 left join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` left join `products` as `p` on `p`.`id` = `pv`.`product_id` where `pv`.`product_id` = 12 and `pv`.`status` in (1) group by `pv`.`id` order by `pv`.`id` asc
Bindings |
|
Backtrace |
|
select `p`.`is_prices_inclusive_tax`, `pv`.`price`, `pv`.`special_price`, (SELECT GROUP_CONCAT(tax.percentage) FROM taxes as tax WHERE FIND_IN_SET(tax.id, p.tax)) as tax_percentage from `products` as `p` left join `taxes` as `tax_id` on FIND_IN_SET(tax_id.id, p.tax) > 0 left join `product_variants` as `pv` on `p`.`id` = `pv`.`product_id` where `p`.`id` = 12
Bindings |
|
Backtrace |
|
select * from `taxes` where `id` in ('0')
Bindings |
|
Backtrace |
|
select * from `taxes` where `id` in ('0')
Bindings |
|
Backtrace |
|
select * from `zones` where `id` in ('')
Bindings |
|
Backtrace |
|
select
GROUP_CONCAT(av.id ORDER BY av.id ASC) as ids,
GROUP_CONCAT(' ', av.value ORDER BY av.id ASC) as value,
a.name as attr_name,
a.name from `product_attributes` as `pa` inner join `attribute_values` as `av` on FIND_IN_SET(av.id, pa.attribute_value_ids) > 0 inner join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` where `pa`.`product_id` = 11 group by `a`.`name`
Bindings |
|
Backtrace |
|
select pv.*, pv.product_id,p.name as product_name,p.image as product_image,
group_concat(av.id ORDER BY av.id ASC) as variant_ids,
group_concat(a.name ORDER BY av.id ASC SEPARATOR " ") as attr_name,
group_concat(av.value ORDER BY av.id ASC) as variant_values,
group_concat(av.swatche_type ORDER BY av.id ASC ) as swatche_type ,
group_concat(av.swatche_value ORDER BY av.id ASC ) as swatche_value,
pv.price as price from `product_variants` as `pv` left join `attribute_values` as `av` on FIND_IN_SET(av.id, pv.attribute_value_ids) > 0 left join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` left join `products` as `p` on `p`.`id` = `pv`.`product_id` where `pv`.`product_id` = 11 and `pv`.`status` in (1) group by `pv`.`id` order by `pv`.`id` asc
Bindings |
|
Backtrace |
|
select `p`.`is_prices_inclusive_tax`, `pv`.`price`, `pv`.`special_price`, (SELECT GROUP_CONCAT(tax.percentage) FROM taxes as tax WHERE FIND_IN_SET(tax.id, p.tax)) as tax_percentage from `products` as `p` left join `taxes` as `tax_id` on FIND_IN_SET(tax_id.id, p.tax) > 0 left join `product_variants` as `pv` on `p`.`id` = `pv`.`product_id` where `p`.`id` = 11
Bindings |
|
Backtrace |
|
select * from `taxes` where `id` in ('0')
Bindings |
|
Backtrace |
|
select * from `taxes` where `id` in ('0')
Bindings |
|
Backtrace |
|
select * from `zones` where `id` in ('')
Bindings |
|
Backtrace |
|
select
GROUP_CONCAT(av.id ORDER BY av.id ASC) as ids,
GROUP_CONCAT(' ', av.value ORDER BY av.id ASC) as value,
a.name as attr_name,
a.name from `product_attributes` as `pa` inner join `attribute_values` as `av` on FIND_IN_SET(av.id, pa.attribute_value_ids) > 0 inner join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` where `pa`.`product_id` = 10 group by `a`.`name`
Bindings |
|
Backtrace |
|
select pv.*, pv.product_id,p.name as product_name,p.image as product_image,
group_concat(av.id ORDER BY av.id ASC) as variant_ids,
group_concat(a.name ORDER BY av.id ASC SEPARATOR " ") as attr_name,
group_concat(av.value ORDER BY av.id ASC) as variant_values,
group_concat(av.swatche_type ORDER BY av.id ASC ) as swatche_type ,
group_concat(av.swatche_value ORDER BY av.id ASC ) as swatche_value,
pv.price as price from `product_variants` as `pv` left join `attribute_values` as `av` on FIND_IN_SET(av.id, pv.attribute_value_ids) > 0 left join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` left join `products` as `p` on `p`.`id` = `pv`.`product_id` where `pv`.`product_id` = 10 and `pv`.`status` in (1) group by `pv`.`id` order by `pv`.`id` asc
Bindings |
|
Backtrace |
|
select `p`.`is_prices_inclusive_tax`, `pv`.`price`, `pv`.`special_price`, (SELECT GROUP_CONCAT(tax.percentage) FROM taxes as tax WHERE FIND_IN_SET(tax.id, p.tax)) as tax_percentage from `products` as `p` left join `taxes` as `tax_id` on FIND_IN_SET(tax_id.id, p.tax) > 0 left join `product_variants` as `pv` on `p`.`id` = `pv`.`product_id` where `p`.`id` = 10
Bindings |
|
Backtrace |
|
select * from `taxes` where `id` in ('0')
Bindings |
|
Backtrace |
|
select * from `taxes` where `id` in ('0')
Bindings |
|
Backtrace |
|
select * from `zones` where `id` in ('')
Bindings |
|
Backtrace |
|
select
GROUP_CONCAT(av.id ORDER BY av.id ASC) as ids,
GROUP_CONCAT(' ', av.value ORDER BY av.id ASC) as value,
a.name as attr_name,
a.name from `product_attributes` as `pa` inner join `attribute_values` as `av` on FIND_IN_SET(av.id, pa.attribute_value_ids) > 0 inner join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` where `pa`.`product_id` = 9 group by `a`.`name`
Bindings |
|
Backtrace |
|
select pv.*, pv.product_id,p.name as product_name,p.image as product_image,
group_concat(av.id ORDER BY av.id ASC) as variant_ids,
group_concat(a.name ORDER BY av.id ASC SEPARATOR " ") as attr_name,
group_concat(av.value ORDER BY av.id ASC) as variant_values,
group_concat(av.swatche_type ORDER BY av.id ASC ) as swatche_type ,
group_concat(av.swatche_value ORDER BY av.id ASC ) as swatche_value,
pv.price as price from `product_variants` as `pv` left join `attribute_values` as `av` on FIND_IN_SET(av.id, pv.attribute_value_ids) > 0 left join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` left join `products` as `p` on `p`.`id` = `pv`.`product_id` where `pv`.`product_id` = 9 and `pv`.`status` in (1) group by `pv`.`id` order by `pv`.`id` asc
Bindings |
|
Backtrace |
|
select `p`.`is_prices_inclusive_tax`, `pv`.`price`, `pv`.`special_price`, (SELECT GROUP_CONCAT(tax.percentage) FROM taxes as tax WHERE FIND_IN_SET(tax.id, p.tax)) as tax_percentage from `products` as `p` left join `taxes` as `tax_id` on FIND_IN_SET(tax_id.id, p.tax) > 0 left join `product_variants` as `pv` on `p`.`id` = `pv`.`product_id` where `p`.`id` = 9
Bindings |
|
Backtrace |
|
select * from `taxes` where `id` in ('0')
Bindings |
|
Backtrace |
|
select * from `taxes` where `id` in ('0')
Bindings |
|
Backtrace |
|
select * from `zones` where `id` in ('')
Bindings |
|
Backtrace |
|
select
GROUP_CONCAT(av.id ORDER BY av.id ASC) as ids,
GROUP_CONCAT(' ', av.value ORDER BY av.id ASC) as value,
a.name as attr_name,
a.name from `product_attributes` as `pa` inner join `attribute_values` as `av` on FIND_IN_SET(av.id, pa.attribute_value_ids) > 0 inner join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` where `pa`.`product_id` = 8 group by `a`.`name`
Bindings |
|
Backtrace |
|
select pv.*, pv.product_id,p.name as product_name,p.image as product_image,
group_concat(av.id ORDER BY av.id ASC) as variant_ids,
group_concat(a.name ORDER BY av.id ASC SEPARATOR " ") as attr_name,
group_concat(av.value ORDER BY av.id ASC) as variant_values,
group_concat(av.swatche_type ORDER BY av.id ASC ) as swatche_type ,
group_concat(av.swatche_value ORDER BY av.id ASC ) as swatche_value,
pv.price as price from `product_variants` as `pv` left join `attribute_values` as `av` on FIND_IN_SET(av.id, pv.attribute_value_ids) > 0 left join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` left join `products` as `p` on `p`.`id` = `pv`.`product_id` where `pv`.`product_id` = 8 and `pv`.`status` in (1) group by `pv`.`id` order by `pv`.`id` asc
Bindings |
|
Backtrace |
|
select `p`.`is_prices_inclusive_tax`, `pv`.`price`, `pv`.`special_price`, (SELECT GROUP_CONCAT(tax.percentage) FROM taxes as tax WHERE FIND_IN_SET(tax.id, p.tax)) as tax_percentage from `products` as `p` left join `taxes` as `tax_id` on FIND_IN_SET(tax_id.id, p.tax) > 0 left join `product_variants` as `pv` on `p`.`id` = `pv`.`product_id` where `p`.`id` = 8
Bindings |
|
Backtrace |
|
select * from `taxes` where `id` in ('0')
Bindings |
|
Backtrace |
|
select * from `taxes` where `id` in ('0')
Bindings |
|
Backtrace |
|
select * from `zones` where `id` in ('')
Bindings |
|
Backtrace |
|
select
GROUP_CONCAT(av.id ORDER BY av.id ASC) as ids,
GROUP_CONCAT(' ', av.value ORDER BY av.id ASC) as value,
a.name as attr_name,
a.name from `product_attributes` as `pa` inner join `attribute_values` as `av` on FIND_IN_SET(av.id, pa.attribute_value_ids) > 0 inner join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` where `pa`.`product_id` = 7 group by `a`.`name`
Bindings |
|
Backtrace |
|
select pv.*, pv.product_id,p.name as product_name,p.image as product_image,
group_concat(av.id ORDER BY av.id ASC) as variant_ids,
group_concat(a.name ORDER BY av.id ASC SEPARATOR " ") as attr_name,
group_concat(av.value ORDER BY av.id ASC) as variant_values,
group_concat(av.swatche_type ORDER BY av.id ASC ) as swatche_type ,
group_concat(av.swatche_value ORDER BY av.id ASC ) as swatche_value,
pv.price as price from `product_variants` as `pv` left join `attribute_values` as `av` on FIND_IN_SET(av.id, pv.attribute_value_ids) > 0 left join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` left join `products` as `p` on `p`.`id` = `pv`.`product_id` where `pv`.`product_id` = 7 and `pv`.`status` in (1) group by `pv`.`id` order by `pv`.`id` asc
Bindings |
|
Backtrace |
|
select `p`.`is_prices_inclusive_tax`, `pv`.`price`, `pv`.`special_price`, (SELECT GROUP_CONCAT(tax.percentage) FROM taxes as tax WHERE FIND_IN_SET(tax.id, p.tax)) as tax_percentage from `products` as `p` left join `taxes` as `tax_id` on FIND_IN_SET(tax_id.id, p.tax) > 0 left join `product_variants` as `pv` on `p`.`id` = `pv`.`product_id` where `p`.`id` = 7
Bindings |
|
Backtrace |
|
select * from `taxes` where `id` in ('0')
Bindings |
|
Backtrace |
|
select * from `taxes` where `id` in ('0')
Bindings |
|
Backtrace |
|
select * from `zones` where `id` in ('')
Bindings |
|
Backtrace |
|
select
GROUP_CONCAT(av.id ORDER BY av.id ASC) as ids,
GROUP_CONCAT(' ', av.value ORDER BY av.id ASC) as value,
a.name as attr_name,
a.name from `product_attributes` as `pa` inner join `attribute_values` as `av` on FIND_IN_SET(av.id, pa.attribute_value_ids) > 0 inner join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` where `pa`.`product_id` = 6 group by `a`.`name`
Bindings |
|
Backtrace |
|
select pv.*, pv.product_id,p.name as product_name,p.image as product_image,
group_concat(av.id ORDER BY av.id ASC) as variant_ids,
group_concat(a.name ORDER BY av.id ASC SEPARATOR " ") as attr_name,
group_concat(av.value ORDER BY av.id ASC) as variant_values,
group_concat(av.swatche_type ORDER BY av.id ASC ) as swatche_type ,
group_concat(av.swatche_value ORDER BY av.id ASC ) as swatche_value,
pv.price as price from `product_variants` as `pv` left join `attribute_values` as `av` on FIND_IN_SET(av.id, pv.attribute_value_ids) > 0 left join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` left join `products` as `p` on `p`.`id` = `pv`.`product_id` where `pv`.`product_id` = 6 and `pv`.`status` in (1) group by `pv`.`id` order by `pv`.`id` asc
Bindings |
|
Backtrace |
|
select `p`.`is_prices_inclusive_tax`, `pv`.`price`, `pv`.`special_price`, (SELECT GROUP_CONCAT(tax.percentage) FROM taxes as tax WHERE FIND_IN_SET(tax.id, p.tax)) as tax_percentage from `products` as `p` left join `taxes` as `tax_id` on FIND_IN_SET(tax_id.id, p.tax) > 0 left join `product_variants` as `pv` on `p`.`id` = `pv`.`product_id` where `p`.`id` = ?
select * from `taxes` where `id` in (?)
select * from `taxes` where `id` in (?)
select * from `zones` where `id` in (?)
select
GROUP_CONCAT(av.id ORDER BY av.id ASC) as ids,
GROUP_CONCAT(' ', av.value ORDER BY av.id ASC) as value,
a.name as attr_name,
a.name from `product_attributes` as `pa` inner join `attribute_values` as `av` on FIND_IN_SET(av.id, pa.attribute_value_ids) > 0 inner join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` where `pa`.`product_id` = ? group by `a`.`name`
select pv.*, pv.product_id,p.name as product_name,p.image as product_image,
group_concat(av.id ORDER BY av.id ASC) as variant_ids,
group_concat(a.name ORDER BY av.id ASC SEPARATOR " ") as attr_name,
group_concat(av.value ORDER BY av.id ASC) as variant_values,
group_concat(av.swatche_type ORDER BY av.id ASC ) as swatche_type ,
group_concat(av.swatche_value ORDER BY av.id ASC ) as swatche_value,
pv.price as price from `product_variants` as `pv` left join `attribute_values` as `av` on FIND_IN_SET(av.id, pv.attribute_value_ids) > 0 left join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` left join `products` as `p` on `p`.`id` = `pv`.`product_id` where `pv`.`product_id` = ? and `pv`.`status` in (?) group by `pv`.`id` order by `pv`.`id` asc
select `p`.`is_prices_inclusive_tax`, `pv`.`price`, `pv`.`special_price`, (SELECT GROUP_CONCAT(tax.percentage) FROM taxes as tax WHERE FIND_IN_SET(tax.id, p.tax)) as tax_percentage from `products` as `p` left join `taxes` as `tax_id` on FIND_IN_SET(tax_id.id, p.tax) > 0 left join `product_variants` as `pv` on `p`.`id` = `pv`.`product_id` where `p`.`id` = ?
select * from `taxes` where `id` in (?)
select * from `taxes` where `id` in (?)
select * from `zones` where `id` in (?)
select
GROUP_CONCAT(av.id ORDER BY av.id ASC) as ids,
GROUP_CONCAT(' ', av.value ORDER BY av.id ASC) as value,
a.name as attr_name,
a.name from `product_attributes` as `pa` inner join `attribute_values` as `av` on FIND_IN_SET(av.id, pa.attribute_value_ids) > 0 inner join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` where `pa`.`product_id` = ? group by `a`.`name`
select pv.*, pv.product_id,p.name as product_name,p.image as product_image,
group_concat(av.id ORDER BY av.id ASC) as variant_ids,
group_concat(a.name ORDER BY av.id ASC SEPARATOR " ") as attr_name,
group_concat(av.value ORDER BY av.id ASC) as variant_values,
group_concat(av.swatche_type ORDER BY av.id ASC ) as swatche_type ,
group_concat(av.swatche_value ORDER BY av.id ASC ) as swatche_value,
pv.price as price from `product_variants` as `pv` left join `attribute_values` as `av` on FIND_IN_SET(av.id, pv.attribute_value_ids) > 0 left join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` left join `products` as `p` on `p`.`id` = `pv`.`product_id` where `pv`.`product_id` = ? and `pv`.`status` in (?) group by `pv`.`id` order by `pv`.`id` asc
select `p`.`is_prices_inclusive_tax`, `pv`.`price`, `pv`.`special_price`, (SELECT GROUP_CONCAT(tax.percentage) FROM taxes as tax WHERE FIND_IN_SET(tax.id, p.tax)) as tax_percentage from `products` as `p` left join `taxes` as `tax_id` on FIND_IN_SET(tax_id.id, p.tax) > 0 left join `product_variants` as `pv` on `p`.`id` = `pv`.`product_id` where `p`.`id` = ?
select * from `taxes` where `id` in (?)
select * from `taxes` where `id` in (?)
select * from `zones` where `id` in (?)
select `delivery_charge_type`, `delivery_charge_amount`, `minimum_free_delivery_amount`, `product_deliverability_type` from `stores` where (`id` = ?)
select * from `products` where `id` < ? and `store_id` = ? order by `id` desc limit 1
select * from `products` where `id` > ? and `store_id` = ? order by `id` asc limit 1
select `p`.`id`, `p`.`category_id`, `p`.`no_of_ratings`, `p`.`brand`, `b`.`name` as `brand_name`, GROUP_CONCAT(pa.attribute_value_ids) as attr_value_ids from `products` as `p` left join `categories` as `c` on `p`.`category_id` = `c`.`id` left join `brands` as `b` on `p`.`brand` = `b`.`id` left join `seller_data` as `sd` on `p`.`seller_id` = `sd`.`id` left join `seller_store` as `ss` on `p`.`seller_id` = `ss`.`seller_id` left join `product_variants` as `pv` on `p`.`id` = `pv`.`product_id` left join `product_attributes` as `pa` on `pa`.`product_id` = `p`.`id` left join `order_items` as `oi` on `oi`.`product_variant_id` = `pv`.`id` left join `taxes` as `tax_id` on FIND_IN_SET(tax_id.id, p.tax) > 0 left join `taxes` as `tax` on FIND_IN_SET(tax.id, p.tax) > 0 where (`p`.`status` = ? and `pv`.`status` = ? and `sd`.`status` = ?) and `p`.`id` in (?, ?) and (`c`.`status` = ? or `c`.`status` = ?) group by `p`.`id`, `p`.`id` order by `p`.`row_order` asc
select `p`.*, `b`.`name` as `brand_name`, `b`.`slug` as `brand_slug`, `ss`.`rating` as `seller_rating`, `ss`.`slug` as `seller_slug`, `ss`.`no_of_ratings` as `seller_no_of_ratings`, `ss`.`logo` as `seller_profile`, `ss`.`store_name` as `store_name`, `ss`.`store_description`, `u`.`username` as `seller_name`, `c`.`name` as `category_name`, `c`.`slug` as `category_slug`, SUM(oi.quantity) as total_sale, (SELECT GROUP_CONCAT(tax.percentage) FROM taxes as tax WHERE FIND_IN_SET(tax.id, p.tax)) as tax_percentage, GROUP_CONCAT(DISTINCT tax_id.id) as tax_id, GROUP_CONCAT(DISTINCT pa.attribute_value_ids) as attr_value_ids from `products` as `p` left join `seller_data` as `sd` on `p`.`seller_id` = `sd`.`id` left join `seller_store` as `ss` on `p`.`seller_id` = `ss`.`seller_id` left join `categories` as `c` on `p`.`category_id` = `c`.`id` left join `brands` as `b` on `p`.`brand` = `b`.`id` left join `users` as `u` on `u`.`id` = `sd`.`user_id` left join `product_variants` as `pv` on `p`.`id` = `pv`.`product_id` left join `order_items` as `oi` on `oi`.`product_variant_id` = `pv`.`id` left join `taxes` as `tax_id` on FIND_IN_SET(tax_id.id, p.tax) > 0 left join `product_attributes` as `pa` on `pa`.`product_id` = `p`.`id` left join `taxes` as `tax` on FIND_IN_SET(tax.id, p.tax) > 0 where `p`.`id` in (?, ?) and (`p`.`status` = ? and `pv`.`status` = ? and `sd`.`status` = ?) and (`c`.`status` = ? or `c`.`status` = ?) group by `p`.`id`, `p`.`id` order by `p`.`id` desc, `pv`.`price` desc, `p`.`row_order` asc limit 20 offset 0
select
GROUP_CONCAT(av.id ORDER BY av.id ASC) as ids,
GROUP_CONCAT(' ', av.value ORDER BY av.id ASC) as value,
a.name as attr_name,
a.name from `product_attributes` as `pa` inner join `attribute_values` as `av` on FIND_IN_SET(av.id, pa.attribute_value_ids) > 0 inner join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` where `pa`.`product_id` = ? group by `a`.`name`
select pv.*, pv.product_id,p.name as product_name,p.image as product_image,
group_concat(av.id ORDER BY av.id ASC) as variant_ids,
group_concat(a.name ORDER BY av.id ASC SEPARATOR " ") as attr_name,
group_concat(av.value ORDER BY av.id ASC) as variant_values,
group_concat(av.swatche_type ORDER BY av.id ASC ) as swatche_type ,
group_concat(av.swatche_value ORDER BY av.id ASC ) as swatche_value,
pv.price as price from `product_variants` as `pv` left join `attribute_values` as `av` on FIND_IN_SET(av.id, pv.attribute_value_ids) > 0 left join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` left join `products` as `p` on `p`.`id` = `pv`.`product_id` where `pv`.`product_id` = ? and `pv`.`status` in (?) group by `pv`.`id` order by `pv`.`id` asc
select `p`.`is_prices_inclusive_tax`, `pv`.`price`, `pv`.`special_price`, (SELECT GROUP_CONCAT(tax.percentage) FROM taxes as tax WHERE FIND_IN_SET(tax.id, p.tax)) as tax_percentage from `products` as `p` left join `taxes` as `tax_id` on FIND_IN_SET(tax_id.id, p.tax) > 0 left join `product_variants` as `pv` on `p`.`id` = `pv`.`product_id` where `p`.`id` = ?
select * from `taxes` where `id` in (?)
select * from `taxes` where `id` in (?)
select * from `zones` where `id` in (?)
select
GROUP_CONCAT(av.id ORDER BY av.id ASC) as ids,
GROUP_CONCAT(' ', av.value ORDER BY av.id ASC) as value,
a.name as attr_name,
a.name from `product_attributes` as `pa` inner join `attribute_values` as `av` on FIND_IN_SET(av.id, pa.attribute_value_ids) > 0 inner join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` where `pa`.`product_id` = ? group by `a`.`name`
select pv.*, pv.product_id,p.name as product_name,p.image as product_image,
group_concat(av.id ORDER BY av.id ASC) as variant_ids,
group_concat(a.name ORDER BY av.id ASC SEPARATOR " ") as attr_name,
group_concat(av.value ORDER BY av.id ASC) as variant_values,
group_concat(av.swatche_type ORDER BY av.id ASC ) as swatche_type ,
group_concat(av.swatche_value ORDER BY av.id ASC ) as swatche_value,
pv.price as price from `product_variants` as `pv` left join `attribute_values` as `av` on FIND_IN_SET(av.id, pv.attribute_value_ids) > 0 left join `attributes` as `a` on `a`.`id` = `av`.`attribute_id` left join `products` as `p` on `p`.`id` = `pv`.`product_id` where `pv`.`product_id` = ? and `pv`.`status` in (?) group by `pv`.`id` order by `pv`.`id` asc
select `p`.`is_prices_inclusive_tax`, `pv`.`price`, `pv`.`special_price`, (SELECT GROUP_CONCAT(tax.percentage) FROM taxes as tax WHERE FIND_IN_SET(tax.id, p.tax)) as tax_percentage from `products` as `p` left join `taxes` as `tax_id` on FIND_IN_SET(tax_id.id, p.tax) > 0 left join `product_variants` as `pv` on `p`.`id` = `pv`.`product_id` where `p`.`id` = ?
select * from `taxes` where `id` in (?)
select * from `taxes` where `id` in (?)
select * from `zones` where `id` in (?)
select * from `currencies` where `code` = ?
select `slug` from `categories` where (`id` = ?)
select * from `product_ratings` where (`user_id` is null and `product_id` = ?)
select * from `product_ratings` where (`product_id` = ?)
select * from `currencies` where (`code` = ?)
select * from `settings` where `variable` = ? limit 1
select * from `currencies`
select * from `languages`
select * from `stores` where (`status` = ?)
select * from `stores` where `id` = ? and `status` = ?
select * from `categories` where (`status` = ? and `parent_id` is null or `status` = ? and `parent_id` = ? or `id` is null and `status` = ?) and `store_id` = ? order by `row_order` desc limit 3 offset 0
select * from `categories` where `categories`.`parent_id` in (2, 5, 6)
select * from `categories` where `categories`.`parent_id` in (3, 4, 11)
select count(*) as aggregate from `categories` where (`status` = ? and `parent_id` is null or `status` = ? and `parent_id` = ? or `id` is null and `status` = ?)
select `c`.`qty`, `c`.`id` as `cart_id`, `c`.`is_saved_for_later`, `c`.`product_type` as `cart_product_type`, `p`.`store_id`, `p`.`cod_allowed`, `p`.`seller_id`, `p`.`type`, `p`.`download_allowed`, `p`.`minimum_order_quantity`, `p`.`minimum_free_delivery_order_qty`, `p`.`delivery_charges` as `product_delivery_charge`, `p`.`slug`, `p`.`quantity_step_size`, `p`.`total_allowed_quantity`, `p`.`name`, `p`.`image`, `p`.`category_id`, `p`.`stock` as `product_stock`, `p`.`availability` as `product_availability`, `p`.`short_description`, `p`.`pickup_location`, `p`.`is_prices_inclusive_tax`, `pv`.`weight`, `c`.`user_id`, `pv`.*, (SELECT GROUP_CONCAT(tax.percentage) FROM taxes as tax WHERE FIND_IN_SET(tax.id, p.tax)) as tax_percentage, (SELECT GROUP_CONCAT(tax_title.title) FROM taxes as tax_title WHERE FIND_IN_SET(tax_title.id, p.tax)) as tax_title from `cart` as `c` inner join `product_variants` as `pv` on `pv`.`id` = `c`.`product_variant_id` inner join `products` as `p` on `pv`.`product_id` = `p`.`id` inner join `seller_data` as `sd` on `sd`.`id` = `p`.`seller_id` left join `taxes` as `tax_id` on FIND_IN_SET(tax_id.id, p.tax) > 0 left join `categories` as `ctg` on `p`.`category_id` = `ctg`.`id` where `c`.`user_id` is null and `c`.`qty` >= ? and `is_saved_for_later` = ? and `c`.`store_id` = ? and (`p`.`status` = ? and `pv`.`status` = ? and `sd`.`status` = ? and `c`.`product_type` = ?) group by `c`.`id` order by `c`.`id` desc
select `c`.`qty`, `c`.`id` as `cart_id`, `c`.`is_saved_for_later`, `c`.`product_type` as `cart_product_type`, `cp`.*, `cp`.`id` as `product_id`, `cp`.`title` as `name`, `cp`.`delivery_charges` as `product_delivery_charge`, `cp`.`stock` as `product_stock`, `cp`.`availability` as `product_availability`, (SELECT GROUP_CONCAT(c_tax.percentage) FROM taxes as c_tax WHERE FIND_IN_SET(c_tax.id, cp.tax)) as tax_percentage, (SELECT GROUP_CONCAT(c_tax_title.title) FROM taxes as c_tax_title WHERE FIND_IN_SET(c_tax_title.id, cp.tax)) as c_tax_title from `cart` as `c` left join `combo_products` as `cp` on `c`.`product_variant_id` = `cp`.`id` inner join `seller_data` as `sd` on `sd`.`id` = `cp`.`seller_id` left join `taxes` as `c_tax_id` on FIND_IN_SET(c_tax_id.id, cp.tax) > 0 where `c`.`user_id` is null and `c`.`qty` >= ? and `is_saved_for_later` = ? and `c`.`store_id` = ? and (`cp`.`status` = ? and `sd`.`status` = ? and `c`.`product_type` = ?) group by `c`.`id` order by `c`.`id` desc
200
0 of 0array:1 [▼ "store" => "kappaas-uniforms" ]
[]
0 of 0array:15 [▼ "priority" => array:1 [▶ 0 => "u=0, i" ] "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" ] "host" => array:1 [▶ 0 => "www.kappaas.in" ] ]
[]
0 of 0array:7 [▼ "cache-control" => array:1 [▶ 0 => "max-age=0, must-revalidate, no-cache, no-store, private" ] "date" => array:1 [▶ 0 => "Wed, 13 Aug 2025 03:36:54 GMT" ] "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "expires" => array:1 [▶ 0 => "Fri, 01 Jan 1990 00:00:00 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkxzVzVaTmswWmNjdGhhRjY0VFJHSlE9PSIsInZhbHVlIjoiQjVtc1NiVlk2ZTFJMm56dmowcVNYYW5OaDg4dHFRSXNhRXZQbG5Ud3lrU0FPV2ZUQlpiY01uMVo5RzkzRjQySm91bHhPSG91U2ZZTDNvdjZnNFFoWU1yb1M5elQ0MTlYd2Z3K3MyelBad3NLdXJ5SkNiNVNwc2F3NStDMTAvWlgiLCJtYWMiOiJkYjk3MjRiODNmMjM5Yjg3NDhjYzNiMDE4NDQzNDdiYWE1OTRiMzhhYjk2OTg5MTE3MmY0ZjViMGI4ZGI2MmY1IiwidGFnIjoiIn0%3D; expires=Wed, 13 Aug 2025 05:36:54 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IkxzVzVaTmswWmNjdGhhRjY0VFJHSlE9PSIsInZhbHVlIjoiQjVtc1NiVlk2ZTFJMm56dmowcVNYYW5OaDg4dHFRSXNhRXZQbG5Ud3lrU0FPV2ZUQlpiY01uMVo5RzkzRjQySm91bHhPS ▶" 1 => "laravel_session=eyJpdiI6IjJVdkh5SDd4d25JZXJFMW9nRTJuWFE9PSIsInZhbHVlIjoiR1FyblM0WTI2dzVXL05pcVlyMUtyeTB2ZTMxdTRJR0lQanluSnZVMmNiU0ZBcitaOHZIUUR1T1VES2RSVHdRUEg2cWtaQUVXL0IxY0lDRzd4dkZNQjRtSXUxdUY0OE1PUkV1bHRGQWwrMjV2TWx2akxXT0xidXdtTGw5TlVEdzUiLCJtYWMiOiJiZTViYzI5NmQzOTkwOGRmYTdmZTlhMTVmNTNjMzk2Njk4ZmFlNTRjMGI1MDZmZmJiNzI1NjQ2NDU3NjFkMzJmIiwidGFnIjoiIn0%3D; expires=Wed, 13 Aug 2025 05:36:54 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6IjJVdkh5SDd4d25JZXJFMW9nRTJuWFE9PSIsInZhbHVlIjoiR1FyblM0WTI2dzVXL05pcVlyMUtyeTB2ZTMxdTRJR0lQanluSnZVMmNiU0ZBcitaOHZIUUR1T1VES2RSVHdRUEg2 ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkxzVzVaTmswWmNjdGhhRjY0VFJHSlE9PSIsInZhbHVlIjoiQjVtc1NiVlk2ZTFJMm56dmowcVNYYW5OaDg4dHFRSXNhRXZQbG5Ud3lrU0FPV2ZUQlpiY01uMVo5RzkzRjQySm91bHhPSG91U2ZZTDNvdjZnNFFoWU1yb1M5elQ0MTlYd2Z3K3MyelBad3NLdXJ5SkNiNVNwc2F3NStDMTAvWlgiLCJtYWMiOiJkYjk3MjRiODNmMjM5Yjg3NDhjYzNiMDE4NDQzNDdiYWE1OTRiMzhhYjk2OTg5MTE3MmY0ZjViMGI4ZGI2MmY1IiwidGFnIjoiIn0%3D; expires=Wed, 13-Aug-2025 05:36:54 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IkxzVzVaTmswWmNjdGhhRjY0VFJHSlE9PSIsInZhbHVlIjoiQjVtc1NiVlk2ZTFJMm56dmowcVNYYW5OaDg4dHFRSXNhRXZQbG5Ud3lrU0FPV2ZUQlpiY01uMVo5RzkzRjQySm91bHhPS ▶" 1 => "laravel_session=eyJpdiI6IjJVdkh5SDd4d25JZXJFMW9nRTJuWFE9PSIsInZhbHVlIjoiR1FyblM0WTI2dzVXL05pcVlyMUtyeTB2ZTMxdTRJR0lQanluSnZVMmNiU0ZBcitaOHZIUUR1T1VES2RSVHdRUEg2cWtaQUVXL0IxY0lDRzd4dkZNQjRtSXUxdUY0OE1PUkV1bHRGQWwrMjV2TWx2akxXT0xidXdtTGw5TlVEdzUiLCJtYWMiOiJiZTViYzI5NmQzOTkwOGRmYTdmZTlhMTVmNTNjMzk2Njk4ZmFlNTRjMGI1MDZmZmJiNzI1NjQ2NDU3NjFkMzJmIiwidGFnIjoiIn0%3D; expires=Wed, 13-Aug-2025 05:36:54 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IjJVdkh5SDd4d25JZXJFMW9nRTJuWFE9PSIsInZhbHVlIjoiR1FyblM0WTI2dzVXL05pcVlyMUtyeTB2ZTMxdTRJR0lQanluSnZVMmNiU0ZBcitaOHZIUUR1T1VES2RSVHdRUEg2 ▶" ] ]
0 of 0array:16 [▼ "firebase_settings" => "{"apiKey":"","authDomain":"","databaseURL":"","projectId":"","storageBucket":"ezeemart-3e0b9.firebasestorage.app","messagingSenderId":"","appId":"","measurementId":"","google_client_id":"","google_client_secret":"","google_redirect_url":"","facebook_client_id":"","facebook_client_secret":"","facebook_redirect_url":""} ◀{"apiKey":"","authDomain":"","databaseURL":"","projectId":"","storageBucket":"ezeemart-3e0b9.firebasestorage.app","messagingSenderId":"","appId":"","measurement ▶" "default-currency" => "{"id":2,"name":"Indian Rupee","code":"inr","symbol":"\u20b9","exchange_rate":"1","is_default":1,"status":1,"created_at":"2025-02-14 06:37:02","updated_at":"2025-02-14 06:37:36"} ◀{"id":2,"name":"Indian Rupee","code":"inr","symbol":"\u20b9","exchange_rate":"1","is_default":1,"status":1,"created_at":"2025-02-14 06:37:02","updated_at":"2025 ▶" "_token" => "jYXqXJwepofph7Jp5JxWXNb2ZwVBcn6J9oI9WPgn" "store_id" => 1 "store_name" => "Kappaas Uniforms" "store_image" => "/logo-sm-(1)-1739514332_4147.png" "store_slug" => "kappaas-uniforms" "default_store_slug" => "kappaas-uniforms" "show_store_popup" => true "system_settings" => "{"app_name":"Kappaas","support_number":"8519990027","support_email":"uniforms@kappaas.com","logo":"\/media\/web-logo-1736311270_9133.svg","favicon":"\/media\/web-logo-1736311270_9133.svg","on_boarding_image":"","on_boarding_video":"","storage_type":"local","on_boarding_media_type":"image","current_version_of_android_app":"1.0.0","current_version_of_ios_app":"1.0.0","current_version_of_android_app_for_seller":"1.0.0","current_version_of_ios_app_for_seller":"1.0.0","current_version_of_android_app_for_delivery_boy":"1.0.0","current_version_of_ios_app_for_delivery_boy":"1.0.0","order_delivery_otp_system":1,"system_timezone":"Asia\/Kolkata","minimum_cart_amount":"10","maximum_item_allowed_in_cart":"10","low_stock_limit":"7","max_days_to_return_item":"1","delivery_boy_bonus":"11","enable_cart_button_on_product_list_view":1,"version_system_status":1,"expand_product_image":1,"tax_name":"GST","tax_number":"123456","google":0,"facebook":0,"apple":0,"refer_and_earn_status":1,"minimum_refer_and_earn_amount":"10","minimum_refer_and_earn_bonus":"10","refer_and_earn_method":"percentage","max_refer_and_earn_amount":"10","number_of_times_bonus_given_to_customer":"1","wallet_balance_status":1,"wallet_balance_amount":"9999","authentication_method":"firebase","store_currency":null,"single_seller_order_system":0,"customer_app_maintenance_status":0,"seller_app_maintenance_status":0,"delivery_boy_app_maintenance_status":0,"message_for_customer_app":null,"message_for_seller_app":"test testtesttesttes tt esttesttesttestt esttesttesttesttes ttesttest testtesttesttesttes ttesttesttesttesttesttesttest","message_for_delivery_boy_app":"test","sidebar_color":null,"sidebar_type":null,"navbar_fixed":0,"theme_mode":0,"currency_setting":{"id":2,"name":"Indian Rupee","code":"inr","symbol":"\u20b9","exchange_rate":"1","is_default":1,"status":1,"created_at":"2025-02-14 06:37:02","updated_at":"2025-02-14 06:37:36"}} ◀{"app_name":"Kappaas","support_number":"8519990027","support_email":"uniforms@kappaas.com","logo":"\/media\/web-logo-1736311270_9133.svg","favicon":"\/media\/we ▶" "all-currency" => "[{"id":2,"name":"Indian Rupee","code":"inr","symbol":"\u20b9","exchange_rate":"1","is_default":1,"status":1,"created_at":"2025-02-14 06:37:02","updated_at":"2025-02-14 06:37:36"}] ◀[{"id":2,"name":"Indian Rupee","code":"inr","symbol":"\u20b9","exchange_rate":"1","is_default":1,"status":1,"created_at":"2025-02-14 06:37:02","updated_at":"202 ▶" "currency-inr" => "[{"id":2,"name":"Indian Rupee","code":"inr","symbol":"\u20b9","exchange_rate":"1","is_default":1,"status":1,"created_at":"2025-02-14 06:37:02","updated_at":"2025-02-14 06:37:36"}] ◀[{"id":2,"name":"Indian Rupee","code":"inr","symbol":"\u20b9","exchange_rate":"1","is_default":1,"status":1,"created_at":"2025-02-14 06:37:02","updated_at":"202 ▶" "web_settings" => "{"site_title":"eZeemartsssssssssssss","support_number":"+91 98765 43210","support_email":"support@ezeemart.com","copyright_details":"Copyright \u00a9 2024-2025, All Right Reserved <a href=\"https:\/\/wrteam.in\/\">WRTeam<\/a>","logo":"\/media\/web-logo-1735034121_4458.svg","favicon":"\/media\/web-logo-1735034121_4458.svg","address":"Time Square Empire, WRTeam , Mirzapar Highway , Bhuj , Kutch , Gujarat - 370001","app_short_description":"FREE SHIPPING ON ALL ORDERS OVER $99 SHOP NOW","map_iframe":"<iframe src=\"https:\/\/www.google.com\/maps\/embed?pb=!1m18!1m12!1m3!1d58652.60185263579!2d69.63381478835316!3d23.250814410717105!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x3950e209000b6f17:0x7077f358af0774a6!2sBhuj, Gujarat!5e0!3m2!1sen!2sin!4v1614852897708!5m2!1sen!2sin\" width=\"600\" height=\"450\" style=\"border:0;\" allowfullscreen=\"\" loading=\"lazy\"><\/iframe>","meta_keywords":"eZeemart","meta_description":"eZeemart","app_download_section":0,"app_download_section_title":"Download Our App","app_download_section_tagline":"Download Our App","app_download_section_short_description":"Download Our App","app_download_section_playstore_url":"https:\/\/www.playstore.com","app_download_section_appstore_url":"https:\/\/www.appstore.com","twitter_link":"https:\/\/www.twitter.com","facebook_link":"https:\/\/www.facebook.com","instagram_link":"https:\/\/www.instagram.com","youtube_link":"https:\/\/www.youtube.com","shipping_mode":0,"shipping_title":"Pickup At Any Store","shipping_description":"Free shipping on orders over $65","return_mode":0,"return_title":"Free Returns","return_description":"30-days free return policy","support_mode":0,"support_title":"Call us any time","support_description":"Contact us 24\/7 hours a day","safety_security_mode":0,"safety_security_title":"Secured Payment","safety_security_description":"We accept all major credit cards"} ◀{"site_title":"eZeemartsssssssssssss","support_number":"+91 98765 43210","support_email":"support@ezeemart.com","copyright_details":"Copyright \u00a9 2024-2025, ▶" "store_details" => "[{"id":1,"name":"Kappaas Uniforms","slug":"kappaas-uniforms","description":"Kappaas Uniforms","image":"\/logo-sm-(1)-1739514332_4147.png","banner_image":"\/logo-sm-(1)-1739514332_4172.png","banner_image_for_most_selling_product":"\/logo-sm-(1)-1739514332_9607.png","stack_image":"\/logo-sm-(1)-1739514332_2852.png","login_image":"\/logo-sm-(1)-1739514332_1533.png","half_store_logo":"\/logo-sm-(1)-1739514332_9638.png","disk":"public","is_single_seller_order_system":1,"is_default_store":1,"note_for_necessary_documents":"","primary_color":"#be2d2d","secondary_color":"#f35858","store_settings":"{\"store_style\":\"header_style_1\",\"product_style\":\"style_1\",\"category_section_title\":\"Schools\",\"category_style\":\"category_style_1\",\"category_card_style\":\"category_card_style_2\",\"brand_style\":\"brands_style_2\",\"offer_slider_style\":\"slider_style_3\"}","hover_color":"#be2d2d","active_color":"#be2d2d","background_color":"#ffffff","status":1,"rating":0,"no_of_ratings":0,"delivery_charge_type":"city_wise_delivery_charge","delivery_charge_amount":0,"minimum_free_delivery_amount":0,"product_deliverability_type":"city_wise_deliverability","created_at":"2025-02-14T06:25:32.000000Z","updated_at":"2025-02-14T06:25:32.000000Z"}] ◀[{"id":1,"name":"Kappaas Uniforms","slug":"kappaas-uniforms","description":"Kappaas Uniforms","image":"\/logo-sm-(1)-1739514332_4147.png","banner_image":"\/logo ▶" "_previous" => array:1 [▶ "url" => "https://www.kappaas.in/products/action-campus-shoes?store=kappaas-uniforms" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] ]