select*from `icommerce__products` whereexists (select*from `icommerce__product_translations` where `icommerce__products`.`id` = `icommerce__product_translations`.`product_id` and `locale` ='es'and `slug` ='cloro-desinfectante') and (`date_available` <='2025-04-07'or `date_available` isnull) and `status` =1and ((stock_status =0) or (subtract =1and quantity >0) or (subtract =0)) and (`organization_id` isnullor icommerce__products.organization_id IN (SELECT id from isite__organizations where status =1)) and (`category_id` isnullor icommerce__products.category_id IN (SELECT id from icommerce__categories where status =1)) and `is_internal` =0and `icommerce__products`.`deleted_at` isnullorderby `sort_order` desc limit 12.12msiatropac_dbEloquentCrudRepository.php#488
Bindings
0: es
1: cloro-desinfectante
2: 2025-04-07
3: 1
4: 0
Hints
0: Use SELECT * only if you need all columns from table
select*from `icommerce__product_translations` where `icommerce__product_translations`.`product_id` in (15)460μsiatropac_dbEloquentCrudRepository.php#488
Hints
0: Use SELECT * only if you need all columns from table
select*from `icommerce__categories` where `icommerce__categories`.`id` in (2) and `icommerce__categories`.`deleted_at` isnull410μsiatropac_dbEloquentCrudRepository.php#488
Hints
0: Use SELECT * only if you need all columns from table
select*from `icommerce__category_translations` where `icommerce__category_translations`.`category_id` in (2)700μsiatropac_dbEloquentCrudRepository.php#488
Hints
0: Use SELECT * only if you need all columns from table
select `icommerce__categories`.*, `icommerce__product_category`.`product_id` as `pivot_product_id`, `icommerce__product_category`.`category_id` as `pivot_category_id`, `icommerce__product_category`.`created_at` as `pivot_created_at`, `icommerce__product_category`.`updated_at` as `pivot_updated_at` from `icommerce__categories` innerjoin `icommerce__product_category` on `icommerce__categories`.`id` = `icommerce__product_category`.`category_id` where `icommerce__product_category`.`product_id` in (15) and `icommerce__categories`.`deleted_at` isnull870μsiatropac_dbEloquentCrudRepository.php#488
select*from `icommerce__category_translations` where `icommerce__category_translations`.`category_id` in (2)270μsiatropac_dbEloquentCrudRepository.php#488
Hints
0: Use SELECT * only if you need all columns from table
select `tag__tags`.*, `tag__tagged`.`taggable_id` as `pivot_taggable_id`, `tag__tagged`.`tag_id` as `pivot_tag_id`, `tag__tagged`.`taggable_type` as `pivot_taggable_type` from `tag__tags` innerjoin `tag__tagged` on `tag__tags`.`id` = `tag__tagged`.`tag_id` where `tag__tagged`.`taggable_id` in (15) and `tag__tagged`.`taggable_type` ='Modules\Icommerce\Entities\Product'620μsiatropac_dbEloquentCrudRepository.php#488
select*from `isite__typeables` where `isite__typeables`.`typeable_id` in (15) and `isite__typeables`.`typeable_type` ='Modules\Icommerce\Entities\Product'and `isite__typeables`.`deleted_at` isnull500μsiatropac_dbEloquentCrudRepository.php#488
Bindings
0: Modules\Icommerce\Entities\Product
Hints
0: Use SELECT * only if you need all columns from table
select*from `icommerce__product_option` where `icommerce__product_option`.`product_id` in (15) and `icommerce__product_option`.`deleted_at` isnull740μsiatropac_dbEloquentCrudRepository.php#488
Hints
0: Use SELECT * only if you need all columns from table
select `icommerce__options`.*, `icommerce__product_option`.`product_id` as `pivot_product_id`, `icommerce__product_option`.`option_id` as `pivot_option_id`, `icommerce__product_option`.`id` as `pivot_id`, `icommerce__product_option`.`parent_id` as `pivot_parent_id`, `icommerce__product_option`.`parent_option_value_id` as `pivot_parent_option_value_id`, `icommerce__product_option`.`value` as `pivot_value`, `icommerce__product_option`.`required` as `pivot_required`, `icommerce__product_option`.`created_at` as `pivot_created_at`, `icommerce__product_option`.`updated_at` as `pivot_updated_at` from `icommerce__options` innerjoin `icommerce__product_option` on `icommerce__options`.`id` = `icommerce__product_option`.`option_id` where `icommerce__product_option`.`product_id` in (15) and `icommerce__options`.`deleted_at` isnull580μsiatropac_dbEloquentCrudRepository.php#488
select*from `icommerce__product_option_value` where `icommerce__product_option_value`.`product_id` in (15) and `icommerce__product_option_value`.`deleted_at` isnull680μsiatropac_dbEloquentCrudRepository.php#488
Hints
0: Use SELECT * only if you need all columns from table
select `icommerce__products`.*, `icommerce__related_product`.`product_id` as `pivot_product_id`, `icommerce__related_product`.`related_id` as `pivot_related_id`, `icommerce__related_product`.`created_at` as `pivot_created_at`, `icommerce__related_product`.`updated_at` as `pivot_updated_at` from `icommerce__products` innerjoin `icommerce__related_product` on `icommerce__products`.`id` = `icommerce__related_product`.`related_id` where `icommerce__related_product`.`product_id` in (15) and `icommerce__products`.`deleted_at` isnull880μsiatropac_dbEloquentCrudRepository.php#488
select `media__files`.*, `media__imageables`.`imageable_id` as `pivot_imageable_id`, `media__imageables`.`file_id` as `pivot_file_id`, `media__imageables`.`imageable_type` as `pivot_imageable_type`, `media__imageables`.`zone` as `pivot_zone`, `media__imageables`.`id` as `pivot_id`, `media__imageables`.`created_at` as `pivot_created_at`, `media__imageables`.`updated_at` as `pivot_updated_at` from `media__files` innerjoin `media__imageables` on `media__files`.`id` = `media__imageables`.`file_id` where `media__imageables`.`imageable_id` in (15) and `media__imageables`.`imageable_type` ='Modules\Icommerce\Entities\Product'and `media__files`.`deleted_at` isnullorderby `order` asc790μsiatropac_dbEloquentCrudRepository.php#488
select `tag__tags`.*, `tag__tagged`.`taggable_id` as `pivot_taggable_id`, `tag__tagged`.`tag_id` as `pivot_tag_id`, `tag__tagged`.`taggable_type` as `pivot_taggable_type` from `tag__tags` innerjoin `tag__tagged` on `tag__tags`.`id` = `tag__tagged`.`tag_id` where `tag__tagged`.`taggable_id` in (118) and `tag__tagged`.`taggable_type` ='Modules\Media\Entities\File'530μsiatropac_dbEloquentCrudRepository.php#488
select*from `icommerce__categories` where ((select `_`.`rgt` from `icommerce__categories` as `_` where `icommerce__categories`.`deleted_at` isnulland `id` =2 limit 1) between `icommerce__categories`.`lft` and `icommerce__categories`.`rgt`) and `icommerce__categories`.`deleted_at` isnullorderby `lft` asc650μsiatropac_dbQueryBuilder.php#176
Bindings
0: 2
Hints
0: Use SELECT * only if you need all columns from table
selectcount(*) as aggregate from `icommerce__products` where (icommerce__products.id IN (SELECT product_id from icommerce__product_category where category_id IN (2)) or `icommerce__products`.`category_id` in (2)) and `id` notin (15) and (`date_available` <='2025-04-07'or `date_available` isnull) and `status` =1and ((stock_status =0) or (subtract =1and quantity >0) or (subtract =0)) and (`organization_id` isnullor icommerce__products.organization_id IN (SELECT id from isite__organizations where status =1)) and (`category_id` isnullor icommerce__products.category_id IN (SELECT id from icommerce__categories where status =1)) and `is_internal` =0and `icommerce__products`.`deleted_at` isnull970μsiatropac_dbEloquentCrudRepository.php#397
select*from `icommerce__products` where (icommerce__products.id IN (SELECT product_id from icommerce__product_category where category_id IN (2)) or `icommerce__products`.`category_id` in (2)) and `id` notin (15) and (`date_available` <='2025-04-07'or `date_available` isnull) and `status` =1and ((stock_status =0) or (subtract =1and quantity >0) or (subtract =0)) and (`organization_id` isnullor icommerce__products.organization_id IN (SELECT id from isite__organizations where status =1)) and (`category_id` isnullor icommerce__products.category_id IN (SELECT id from icommerce__categories where status =1)) and `is_internal` =0and `icommerce__products`.`deleted_at` isnullorderby `sort_order` desc, COALESCE(sort_order, 0) desc, `created_at` desc limit 20offset01.49msiatropac_dbEloquentCrudRepository.php#397
Bindings
0: 2
1: 15
2: 2025-04-07
3: 1
4: 0
Hints
0: Use SELECT * only if you need all columns from table
select*from `icommerce__categories` where `icommerce__categories`.`id` in (2) and `icommerce__categories`.`deleted_at` isnull290μsiatropac_dbEloquentCrudRepository.php#397
Hints
0: Use SELECT * only if you need all columns from table
select*from `icommerce__category_translations` where `icommerce__category_translations`.`category_id` in (2)260μsiatropac_dbEloquentCrudRepository.php#397
Hints
0: Use SELECT * only if you need all columns from table
select `media__files`.*, `media__imageables`.`imageable_id` as `pivot_imageable_id`, `media__imageables`.`file_id` as `pivot_file_id`, `media__imageables`.`imageable_type` as `pivot_imageable_type`, `media__imageables`.`zone` as `pivot_zone`, `media__imageables`.`id` as `pivot_id`, `media__imageables`.`created_at` as `pivot_created_at`, `media__imageables`.`updated_at` as `pivot_updated_at` from `media__files` innerjoin `media__imageables` on `media__files`.`id` = `media__imageables`.`file_id` where `media__imageables`.`imageable_id` in (11, 12, 14, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26) and `media__imageables`.`imageable_type` ='Modules\Icommerce\Entities\Product'and `media__files`.`deleted_at` isnullorderby `order` asc740μsiatropac_dbEloquentCrudRepository.php#397
select `tag__tags`.*, `tag__tagged`.`taggable_id` as `pivot_taggable_id`, `tag__tagged`.`tag_id` as `pivot_tag_id`, `tag__tagged`.`taggable_type` as `pivot_taggable_type` from `tag__tags` innerjoin `tag__tagged` on `tag__tags`.`id` = `tag__tagged`.`tag_id` where `tag__tagged`.`taggable_id` in (73, 102, 103, 104, 105, 106, 107, 113, 114, 115, 116, 117, 119) and `tag__tagged`.`taggable_type` ='Modules\Media\Entities\File'540μsiatropac_dbEloquentCrudRepository.php#397
