1 x Application (85.99%) | 823.85ms |
1 x Booting (13.95%) | 133.66ms |
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
Params | |
---|---|
0 |
|
1 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
select * from `utility_guides` where (`url` = 'shop' or `route` = 'shop') limit 1
1.55ms/Corals/modules/Utility/Middleware/AddGuideAssetsMiddleware.php:44daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 'shower' or (`ecommerce_categories`.`parent_id` = 'shower' and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 'shower'
1.81ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from (select `ecommerce_products`.* from `ecommerce_products` inner join `ecommerce_sku` on `ecommerce_sku`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where `ecommerce_products`.`status` = 'active' and `ecommerce_sku`.`status` = 'active' and (`ecommerce_categories`.`id` in (35) or `ecommerce_categories`.`parent_id` in (35)) and `ecommerce_categories`.`status` = 'active' group by `ecommerce_sku`.`product_id`, `ecommerce_products`.`id`) as `aggregate_table`
4.65ms/Corals/modules/Ecommerce/Classes/Shop.php:63daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `ecommerce_products`.* from `ecommerce_products` inner join `ecommerce_sku` on `ecommerce_sku`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where `ecommerce_products`.`status` = 'active' and `ecommerce_sku`.`status` = 'active' and (`ecommerce_categories`.`id` in (35) or `ecommerce_categories`.`parent_id` in (35)) and `ecommerce_categories`.`status` = 'active' group by `ecommerce_sku`.`product_id`, `ecommerce_products`.`id` limit 15 offset 0
2.63ms/Corals/modules/Ecommerce/Classes/Shop.php:63daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`status` = 'active' and (`parent_id` is null or `parent_id` = 0)
1.38ms/Corals/modules/Ecommerce/Classes/Shop.php:358daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 1 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
1.21ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 1 or (`ecommerce_categories`.`parent_id` = 1 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 1
1.21ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (1) or `ecommerce_categories`.`parent_id` in (1)) and `ecommerce_categories`.`status` = 'active'
1.79ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 8 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
930μs/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 8 or (`ecommerce_categories`.`parent_id` = 8 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 8
1.14ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (8) or `ecommerce_categories`.`parent_id` in (8)) and `ecommerce_categories`.`status` = 'active'
1.47ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 9 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
1.01ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 9 or (`ecommerce_categories`.`parent_id` = 9 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 9
1.09ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (9) or `ecommerce_categories`.`parent_id` in (9)) and `ecommerce_categories`.`status` = 'active'
1.75ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 10 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
1.22ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 10 or (`ecommerce_categories`.`parent_id` = 10 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 10
1.09ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (10) or `ecommerce_categories`.`parent_id` in (10)) and `ecommerce_categories`.`status` = 'active'
1.48ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 11 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
1.05ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 19 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
1.11ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 20 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
1.26ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 21 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
950μs/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 22 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
1.09ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 11 or (`ecommerce_categories`.`parent_id` = 11 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 11
1.14ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (11, 19, 20, 21, 22) or `ecommerce_categories`.`parent_id` in (11, 19, 20, 21, 22)) and `ecommerce_categories`.`status` = 'active'
1.92ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 19 or (`ecommerce_categories`.`parent_id` = 19 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 19
1.17ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (19) or `ecommerce_categories`.`parent_id` in (19)) and `ecommerce_categories`.`status` = 'active'
1.39ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 20 or (`ecommerce_categories`.`parent_id` = 20 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 20
1.13ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (20) or `ecommerce_categories`.`parent_id` in (20)) and `ecommerce_categories`.`status` = 'active'
1.76ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 21 or (`ecommerce_categories`.`parent_id` = 21 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 21
1.04ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (21) or `ecommerce_categories`.`parent_id` in (21)) and `ecommerce_categories`.`status` = 'active'
1.48ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 22 or (`ecommerce_categories`.`parent_id` = 22 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 22
1.16ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (22) or `ecommerce_categories`.`parent_id` in (22)) and `ecommerce_categories`.`status` = 'active'
1.59ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 12 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
970μs/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 12 or (`ecommerce_categories`.`parent_id` = 12 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 12
1.05ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (12) or `ecommerce_categories`.`parent_id` in (12)) and `ecommerce_categories`.`status` = 'active'
1.62ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 13 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
1.15ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 13 or (`ecommerce_categories`.`parent_id` = 13 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 13
1.2ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (13) or `ecommerce_categories`.`parent_id` in (13)) and `ecommerce_categories`.`status` = 'active'
1.43ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 14 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
1.22ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 14 or (`ecommerce_categories`.`parent_id` = 14 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 14
1.25ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (14) or `ecommerce_categories`.`parent_id` in (14)) and `ecommerce_categories`.`status` = 'active'
1.83ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 30 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
1.06ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 30 or (`ecommerce_categories`.`parent_id` = 30 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 30
1.1ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (30) or `ecommerce_categories`.`parent_id` in (30)) and `ecommerce_categories`.`status` = 'active'
1.7ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 31 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
1.14ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 31 or (`ecommerce_categories`.`parent_id` = 31 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 31
1.21ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (31) or `ecommerce_categories`.`parent_id` in (31)) and `ecommerce_categories`.`status` = 'active'
1.4ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 32 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
1.13ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 32 or (`ecommerce_categories`.`parent_id` = 32 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 32
1.13ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (32) or `ecommerce_categories`.`parent_id` in (32)) and `ecommerce_categories`.`status` = 'active'
2.49ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 34 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
1.35ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 34 or (`ecommerce_categories`.`parent_id` = 34 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 34
1.06ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (34) or `ecommerce_categories`.`parent_id` in (34)) and `ecommerce_categories`.`status` = 'active'
1.86ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 35 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
1.2ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 35 or (`ecommerce_categories`.`parent_id` = 35 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 35
1.16ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (35) or `ecommerce_categories`.`parent_id` in (35)) and `ecommerce_categories`.`status` = 'active'
1.77ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 36 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
1.19ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 36 or (`ecommerce_categories`.`parent_id` = 36 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 36
1.36ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (36) or `ecommerce_categories`.`parent_id` in (36)) and `ecommerce_categories`.`status` = 'active'
1.86ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 37 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
1.25ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 37 or (`ecommerce_categories`.`parent_id` = 37 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 37
1.3ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (37) or `ecommerce_categories`.`parent_id` in (37)) and `ecommerce_categories`.`status` = 'active'
1.66ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select min(`regular_price`) as aggregate from `ecommerce_sku`
990μs/Corals/core/Foundation/Traits/Hookable.php:78daneenbrandMetadata | |
---|---|
Hints |
|
Backtrace |
|
select max(`regular_price`) as aggregate from `ecommerce_sku`
730μs/Corals/core/Foundation/Traits/Hookable.php:78daneenbrandMetadata | |
---|---|
Hints |
|
Backtrace |
|
select count(ecommerce_products.id) as products_count, `ecommerce_brands`.* from `ecommerce_brands` left join `ecommerce_products` on `ecommerce_products`.`brand_id` = `ecommerce_brands`.`id` where `ecommerce_brands`.`status` = 'active' and exists (select * from `ecommerce_categories` inner join `ecommerce_category_product` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` inner join `ecommerce_products` on `ecommerce_products`.`id` = `ecommerce_category_product`.`product_id` where `ecommerce_brands`.`id` = `ecommerce_products`.`brand_id` and `ecommerce_categories`.`slug` = 'shower') group by `ecommerce_products`.`brand_id`, `ecommerce_brands`.`id`
2.62ms/Corals/modules/Ecommerce/Classes/Shop.php:407daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_attributes` where exists (select * from `ecommerce_categories` inner join `ecommerce_category_attributes` on `ecommerce_categories`.`id` = `ecommerce_category_attributes`.`category_id` where `ecommerce_attributes`.`id` = `ecommerce_category_attributes`.`attribute_id` and `slug` in ('shower'))
1.73ms/Corals/modules/Ecommerce/Classes/Shop.php:478daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`status` = 'active' and (`parent_id` is null or `parent_id` = 0)
1.16ms/Corals/modules/Ecommerce/Classes/Shop.php:358daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 1 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
1.02ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 1 or (`ecommerce_categories`.`parent_id` = 1 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 1
1.01ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (1) or `ecommerce_categories`.`parent_id` in (1)) and `ecommerce_categories`.`status` = 'active'
1.49ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 8 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
1.04ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 8 or (`ecommerce_categories`.`parent_id` = 8 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 8
1.06ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (8) or `ecommerce_categories`.`parent_id` in (8)) and `ecommerce_categories`.`status` = 'active'
1.46ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 9 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
1.02ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 9 or (`ecommerce_categories`.`parent_id` = 9 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 9
950μs/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (9) or `ecommerce_categories`.`parent_id` in (9)) and `ecommerce_categories`.`status` = 'active'
1.4ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 10 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
1.19ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 10 or (`ecommerce_categories`.`parent_id` = 10 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 10
1.3ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (10) or `ecommerce_categories`.`parent_id` in (10)) and `ecommerce_categories`.`status` = 'active'
1.85ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 11 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
1.39ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 19 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
1.28ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 20 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
1.81ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 21 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
1.78ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 22 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
1.24ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 11 or (`ecommerce_categories`.`parent_id` = 11 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 11
1.4ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (11, 19, 20, 21, 22) or `ecommerce_categories`.`parent_id` in (11, 19, 20, 21, 22)) and `ecommerce_categories`.`status` = 'active'
2.51ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 19 or (`ecommerce_categories`.`parent_id` = 19 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 19
1.19ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (19) or `ecommerce_categories`.`parent_id` in (19)) and `ecommerce_categories`.`status` = 'active'
1.67ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 20 or (`ecommerce_categories`.`parent_id` = 20 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 20
1.26ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (20) or `ecommerce_categories`.`parent_id` in (20)) and `ecommerce_categories`.`status` = 'active'
1.67ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 21 or (`ecommerce_categories`.`parent_id` = 21 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 21
1.09ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (21) or `ecommerce_categories`.`parent_id` in (21)) and `ecommerce_categories`.`status` = 'active'
1.66ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 22 or (`ecommerce_categories`.`parent_id` = 22 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 22
1.32ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (22) or `ecommerce_categories`.`parent_id` in (22)) and `ecommerce_categories`.`status` = 'active'
1.58ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 12 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
1.13ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 12 or (`ecommerce_categories`.`parent_id` = 12 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 12
1.17ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (12) or `ecommerce_categories`.`parent_id` in (12)) and `ecommerce_categories`.`status` = 'active'
1.68ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 13 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
1.17ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 13 or (`ecommerce_categories`.`parent_id` = 13 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 13
1.29ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (13) or `ecommerce_categories`.`parent_id` in (13)) and `ecommerce_categories`.`status` = 'active'
1.7ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 14 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
1.36ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 14 or (`ecommerce_categories`.`parent_id` = 14 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 14
1.17ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (14) or `ecommerce_categories`.`parent_id` in (14)) and `ecommerce_categories`.`status` = 'active'
1.79ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 30 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
1.13ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 30 or (`ecommerce_categories`.`parent_id` = 30 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 30
1.34ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (30) or `ecommerce_categories`.`parent_id` in (30)) and `ecommerce_categories`.`status` = 'active'
1.69ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 31 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
1.1ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 31 or (`ecommerce_categories`.`parent_id` = 31 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 31
1.37ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (31) or `ecommerce_categories`.`parent_id` in (31)) and `ecommerce_categories`.`status` = 'active'
1.74ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 32 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
1.21ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 32 or (`ecommerce_categories`.`parent_id` = 32 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 32
1.23ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (32) or `ecommerce_categories`.`parent_id` in (32)) and `ecommerce_categories`.`status` = 'active'
1.79ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 34 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
1.11ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 34 or (`ecommerce_categories`.`parent_id` = 34 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 34
1.18ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (34) or `ecommerce_categories`.`parent_id` in (34)) and `ecommerce_categories`.`status` = 'active'
1.91ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 35 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
1.07ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 35 or (`ecommerce_categories`.`parent_id` = 35 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 35
1.19ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (35) or `ecommerce_categories`.`parent_id` in (35)) and `ecommerce_categories`.`status` = 'active'
1.61ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 36 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
1.07ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 36 or (`ecommerce_categories`.`parent_id` = 36 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 36
1.47ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (36) or `ecommerce_categories`.`parent_id` in (36)) and `ecommerce_categories`.`status` = 'active'
1.78ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_categories` where `ecommerce_categories`.`parent_id` = 37 and `ecommerce_categories`.`parent_id` is not null order by `id` asc
1.34ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 37 or (`ecommerce_categories`.`parent_id` = 37 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 37
1.38ms/Corals/modules/Ecommerce/Classes/Shop.php:227daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (37) or `ecommerce_categories`.`parent_id` in (37)) and `ecommerce_categories`.`status` = 'active'
1.95ms/Corals/modules/Ecommerce/Classes/Shop.php:279daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select min(`regular_price`) as aggregate from `ecommerce_sku`
1.01ms/Corals/core/Foundation/Traits/Hookable.php:78daneenbrandMetadata | |
---|---|
Hints |
|
Backtrace |
|
select max(`regular_price`) as aggregate from `ecommerce_sku`
1.02ms/Corals/core/Foundation/Traits/Hookable.php:78daneenbrandMetadata | |
---|---|
Hints |
|
Backtrace |
|
select count(ecommerce_products.id) as products_count, `ecommerce_brands`.* from `ecommerce_brands` left join `ecommerce_products` on `ecommerce_products`.`brand_id` = `ecommerce_brands`.`id` where `ecommerce_brands`.`status` = 'active' and exists (select * from `ecommerce_categories` inner join `ecommerce_category_product` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` inner join `ecommerce_products` on `ecommerce_products`.`id` = `ecommerce_category_product`.`product_id` where `ecommerce_brands`.`id` = `ecommerce_products`.`brand_id` and `ecommerce_categories`.`slug` = 'shower') group by `ecommerce_products`.`brand_id`, `ecommerce_brands`.`id`
2.14ms/Corals/modules/Ecommerce/Classes/Shop.php:407daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_attributes` where exists (select * from `ecommerce_categories` inner join `ecommerce_category_attributes` on `ecommerce_categories`.`id` = `ecommerce_category_attributes`.`category_id` where `ecommerce_attributes`.`id` = `ecommerce_category_attributes`.`attribute_id` and `slug` in ('shower'))
2.19ms/Corals/modules/Ecommerce/Classes/Shop.php:478daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `ecommerce_sku` where `ecommerce_sku`.`product_id` = 52 and `ecommerce_sku`.`product_id` is not null
1.45ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `media` where `media`.`model_type` = 'Corals\Modules\Ecommerce\Models\Product' and `media`.`model_id` = 52 and `media`.`model_id` is not null
1.73ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `currencies`
2.71ms/Corals/modules/Payment/Common/Drivers/Database.php:62daneenbrandMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `utility_avg_ratings` where `utility_avg_ratings`.`avgreviewable_type` = 'Corals\Modules\Ecommerce\Models\Product' and `utility_avg_ratings`.`avgreviewable_id` = 52 and `utility_avg_ratings`.`avgreviewable_id` is not null limit 1
1.69ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_attributes` inner join `ecommerce_product_attributes` on `ecommerce_attributes`.`id` = `ecommerce_product_attributes`.`attribute_id` where `ecommerce_product_attributes`.`product_id` = 52
1.59msview::728b549d83d6a25c984a9acab37e96c7f19b50e9:31daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_sku` where `ecommerce_sku`.`product_id` = 52 and `ecommerce_sku`.`product_id` is not null and `ecommerce_sku`.`status` = 'active' limit 1
1.35ms/Corals/modules/Ecommerce/Models/Product.php:146daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `ecommerce_sku` where `ecommerce_sku`.`product_id` = 53 and `ecommerce_sku`.`product_id` is not null
1.26ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `media` where `media`.`model_type` = 'Corals\Modules\Ecommerce\Models\Product' and `media`.`model_id` = 53 and `media`.`model_id` is not null
1.06ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `utility_avg_ratings` where `utility_avg_ratings`.`avgreviewable_type` = 'Corals\Modules\Ecommerce\Models\Product' and `utility_avg_ratings`.`avgreviewable_id` = 53 and `utility_avg_ratings`.`avgreviewable_id` is not null limit 1
1.08ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_attributes` inner join `ecommerce_product_attributes` on `ecommerce_attributes`.`id` = `ecommerce_product_attributes`.`attribute_id` where `ecommerce_product_attributes`.`product_id` = 53
1.22msview::728b549d83d6a25c984a9acab37e96c7f19b50e9:31daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_sku` where `ecommerce_sku`.`product_id` = 53 and `ecommerce_sku`.`product_id` is not null and `ecommerce_sku`.`status` = 'active' limit 1
1.73ms/Corals/modules/Ecommerce/Models/Product.php:146daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `ecommerce_sku` where `ecommerce_sku`.`product_id` = 54 and `ecommerce_sku`.`product_id` is not null
1.33ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `media` where `media`.`model_type` = 'Corals\Modules\Ecommerce\Models\Product' and `media`.`model_id` = 54 and `media`.`model_id` is not null
1ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `utility_avg_ratings` where `utility_avg_ratings`.`avgreviewable_type` = 'Corals\Modules\Ecommerce\Models\Product' and `utility_avg_ratings`.`avgreviewable_id` = 54 and `utility_avg_ratings`.`avgreviewable_id` is not null limit 1
1.25ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_attributes` inner join `ecommerce_product_attributes` on `ecommerce_attributes`.`id` = `ecommerce_product_attributes`.`attribute_id` where `ecommerce_product_attributes`.`product_id` = 54
1.08msview::728b549d83d6a25c984a9acab37e96c7f19b50e9:31daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_sku` where `ecommerce_sku`.`product_id` = 54 and `ecommerce_sku`.`product_id` is not null and `ecommerce_sku`.`status` = 'active' limit 1
1.3ms/Corals/modules/Ecommerce/Models/Product.php:146daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `ecommerce_sku` where `ecommerce_sku`.`product_id` = 55 and `ecommerce_sku`.`product_id` is not null
1.42ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `media` where `media`.`model_type` = 'Corals\Modules\Ecommerce\Models\Product' and `media`.`model_id` = 55 and `media`.`model_id` is not null
1.36ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `utility_avg_ratings` where `utility_avg_ratings`.`avgreviewable_type` = 'Corals\Modules\Ecommerce\Models\Product' and `utility_avg_ratings`.`avgreviewable_id` = 55 and `utility_avg_ratings`.`avgreviewable_id` is not null limit 1
1.27ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_attributes` inner join `ecommerce_product_attributes` on `ecommerce_attributes`.`id` = `ecommerce_product_attributes`.`attribute_id` where `ecommerce_product_attributes`.`product_id` = 55
1.43msview::728b549d83d6a25c984a9acab37e96c7f19b50e9:31daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_sku` where `ecommerce_sku`.`product_id` = 55 and `ecommerce_sku`.`product_id` is not null and `ecommerce_sku`.`status` = 'active' limit 1
1.91ms/Corals/modules/Ecommerce/Models/Product.php:146daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `ecommerce_sku` where `ecommerce_sku`.`product_id` = 56 and `ecommerce_sku`.`product_id` is not null
1.26ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `media` where `media`.`model_type` = 'Corals\Modules\Ecommerce\Models\Product' and `media`.`model_id` = 56 and `media`.`model_id` is not null
1.34ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `utility_avg_ratings` where `utility_avg_ratings`.`avgreviewable_type` = 'Corals\Modules\Ecommerce\Models\Product' and `utility_avg_ratings`.`avgreviewable_id` = 56 and `utility_avg_ratings`.`avgreviewable_id` is not null limit 1
1.27ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_attributes` inner join `ecommerce_product_attributes` on `ecommerce_attributes`.`id` = `ecommerce_product_attributes`.`attribute_id` where `ecommerce_product_attributes`.`product_id` = 56
1.27msview::728b549d83d6a25c984a9acab37e96c7f19b50e9:31daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_sku` where `ecommerce_sku`.`product_id` = 56 and `ecommerce_sku`.`product_id` is not null and `ecommerce_sku`.`status` = 'active' limit 1
1.29ms/Corals/modules/Ecommerce/Models/Product.php:146daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `ecommerce_sku` where `ecommerce_sku`.`product_id` = 57 and `ecommerce_sku`.`product_id` is not null
1.36ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `media` where `media`.`model_type` = 'Corals\Modules\Ecommerce\Models\Product' and `media`.`model_id` = 57 and `media`.`model_id` is not null
1.26ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `utility_avg_ratings` where `utility_avg_ratings`.`avgreviewable_type` = 'Corals\Modules\Ecommerce\Models\Product' and `utility_avg_ratings`.`avgreviewable_id` = 57 and `utility_avg_ratings`.`avgreviewable_id` is not null limit 1
1.46ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_attributes` inner join `ecommerce_product_attributes` on `ecommerce_attributes`.`id` = `ecommerce_product_attributes`.`attribute_id` where `ecommerce_product_attributes`.`product_id` = 57
1.26msview::728b549d83d6a25c984a9acab37e96c7f19b50e9:31daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_sku` where `ecommerce_sku`.`product_id` = 57 and `ecommerce_sku`.`product_id` is not null and `ecommerce_sku`.`status` = 'active' limit 1
1.35ms/Corals/modules/Ecommerce/Models/Product.php:146daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `ecommerce_sku` where `ecommerce_sku`.`product_id` = 58 and `ecommerce_sku`.`product_id` is not null
1.36ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `media` where `media`.`model_type` = 'Corals\Modules\Ecommerce\Models\Product' and `media`.`model_id` = 58 and `media`.`model_id` is not null
1.34ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `utility_avg_ratings` where `utility_avg_ratings`.`avgreviewable_type` = 'Corals\Modules\Ecommerce\Models\Product' and `utility_avg_ratings`.`avgreviewable_id` = 58 and `utility_avg_ratings`.`avgreviewable_id` is not null limit 1
1.45ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_attributes` inner join `ecommerce_product_attributes` on `ecommerce_attributes`.`id` = `ecommerce_product_attributes`.`attribute_id` where `ecommerce_product_attributes`.`product_id` = 58
1.43msview::728b549d83d6a25c984a9acab37e96c7f19b50e9:31daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_sku` where `ecommerce_sku`.`product_id` = 58 and `ecommerce_sku`.`product_id` is not null and `ecommerce_sku`.`status` = 'active' limit 1
2.16ms/Corals/modules/Ecommerce/Models/Product.php:146daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `ecommerce_sku` where `ecommerce_sku`.`product_id` = 59 and `ecommerce_sku`.`product_id` is not null
1.6ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `media` where `media`.`model_type` = 'Corals\Modules\Ecommerce\Models\Product' and `media`.`model_id` = 59 and `media`.`model_id` is not null
1.45ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `utility_avg_ratings` where `utility_avg_ratings`.`avgreviewable_type` = 'Corals\Modules\Ecommerce\Models\Product' and `utility_avg_ratings`.`avgreviewable_id` = 59 and `utility_avg_ratings`.`avgreviewable_id` is not null limit 1
1.53ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_attributes` inner join `ecommerce_product_attributes` on `ecommerce_attributes`.`id` = `ecommerce_product_attributes`.`attribute_id` where `ecommerce_product_attributes`.`product_id` = 59
1.21msview::728b549d83d6a25c984a9acab37e96c7f19b50e9:31daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_sku` where `ecommerce_sku`.`product_id` = 59 and `ecommerce_sku`.`product_id` is not null and `ecommerce_sku`.`status` = 'active' limit 1
1.12ms/Corals/modules/Ecommerce/Models/Product.php:146daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `ecommerce_sku` where `ecommerce_sku`.`product_id` = 60 and `ecommerce_sku`.`product_id` is not null
1.17ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `media` where `media`.`model_type` = 'Corals\Modules\Ecommerce\Models\Product' and `media`.`model_id` = 60 and `media`.`model_id` is not null
1.05ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `utility_avg_ratings` where `utility_avg_ratings`.`avgreviewable_type` = 'Corals\Modules\Ecommerce\Models\Product' and `utility_avg_ratings`.`avgreviewable_id` = 60 and `utility_avg_ratings`.`avgreviewable_id` is not null limit 1
1.28ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_attributes` inner join `ecommerce_product_attributes` on `ecommerce_attributes`.`id` = `ecommerce_product_attributes`.`attribute_id` where `ecommerce_product_attributes`.`product_id` = 60
1.24msview::728b549d83d6a25c984a9acab37e96c7f19b50e9:31daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_sku` where `ecommerce_sku`.`product_id` = 60 and `ecommerce_sku`.`product_id` is not null and `ecommerce_sku`.`status` = 'active' limit 1
1.26ms/Corals/modules/Ecommerce/Models/Product.php:146daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `ecommerce_sku` where `ecommerce_sku`.`product_id` = 61 and `ecommerce_sku`.`product_id` is not null
1.42ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `media` where `media`.`model_type` = 'Corals\Modules\Ecommerce\Models\Product' and `media`.`model_id` = 61 and `media`.`model_id` is not null
1.29ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `utility_avg_ratings` where `utility_avg_ratings`.`avgreviewable_type` = 'Corals\Modules\Ecommerce\Models\Product' and `utility_avg_ratings`.`avgreviewable_id` = 61 and `utility_avg_ratings`.`avgreviewable_id` is not null limit 1
1.24ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_attributes` inner join `ecommerce_product_attributes` on `ecommerce_attributes`.`id` = `ecommerce_product_attributes`.`attribute_id` where `ecommerce_product_attributes`.`product_id` = 61
1.3msview::728b549d83d6a25c984a9acab37e96c7f19b50e9:31daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_sku` where `ecommerce_sku`.`product_id` = 61 and `ecommerce_sku`.`product_id` is not null and `ecommerce_sku`.`status` = 'active' limit 1
1.25ms/Corals/modules/Ecommerce/Models/Product.php:146daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `ecommerce_sku` where `ecommerce_sku`.`product_id` = 66 and `ecommerce_sku`.`product_id` is not null
1.36ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `media` where `media`.`model_type` = 'Corals\Modules\Ecommerce\Models\Product' and `media`.`model_id` = 66 and `media`.`model_id` is not null
1.13ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `utility_avg_ratings` where `utility_avg_ratings`.`avgreviewable_type` = 'Corals\Modules\Ecommerce\Models\Product' and `utility_avg_ratings`.`avgreviewable_id` = 66 and `utility_avg_ratings`.`avgreviewable_id` is not null limit 1
1.52ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_attributes` inner join `ecommerce_product_attributes` on `ecommerce_attributes`.`id` = `ecommerce_product_attributes`.`attribute_id` where `ecommerce_product_attributes`.`product_id` = 66
1.4msview::728b549d83d6a25c984a9acab37e96c7f19b50e9:31daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_sku` where `ecommerce_sku`.`product_id` = 66 and `ecommerce_sku`.`product_id` is not null and `ecommerce_sku`.`status` = 'active' limit 1
1.49ms/Corals/modules/Ecommerce/Models/Product.php:146daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `ecommerce_sku` where `ecommerce_sku`.`product_id` = 67 and `ecommerce_sku`.`product_id` is not null
1.5ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `media` where `media`.`model_type` = 'Corals\Modules\Ecommerce\Models\Product' and `media`.`model_id` = 67 and `media`.`model_id` is not null
1.41ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `utility_avg_ratings` where `utility_avg_ratings`.`avgreviewable_type` = 'Corals\Modules\Ecommerce\Models\Product' and `utility_avg_ratings`.`avgreviewable_id` = 67 and `utility_avg_ratings`.`avgreviewable_id` is not null limit 1
1.3ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `ecommerce_attributes` inner join `ecommerce_product_attributes` on `ecommerce_attributes`.`id` = `ecommerce_product_attributes`.`attribute_id` where `ecommerce_product_attributes`.`product_id` = 67
1.54msview::728b549d83d6a25c984a9acab37e96c7f19b50e9:31daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_sku` where `ecommerce_sku`.`product_id` = 67 and `ecommerce_sku`.`product_id` is not null and `ecommerce_sku`.`status` = 'active' limit 1
1.37ms/Corals/modules/Ecommerce/Models/Product.php:146daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `utilities_seo_items` where `slug` = 'shop' limit 1
3.53ms/Corals/modules/CMS/Classes/SEOTools.php:146daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `utilities_seo_items` where `route` = 'shop' limit 1
1ms/Corals/modules/CMS/Classes/SEOTools.php:149daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `ecommerce_brands` where `ecommerce_brands`.`id` = 1 limit 1
1.27ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `ecommerce_categories`.*, `ecommerce_category_product`.`product_id` as `pivot_product_id`, `ecommerce_category_product`.`category_id` as `pivot_category_id` from `ecommerce_categories` inner join `ecommerce_category_product` on `ecommerce_categories`.`id` = `ecommerce_category_product`.`category_id` where `ecommerce_category_product`.`product_id` = 52
1.29ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_brands` where `ecommerce_brands`.`id` = 1 limit 1
1.19ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `ecommerce_categories`.*, `ecommerce_category_product`.`product_id` as `pivot_product_id`, `ecommerce_category_product`.`category_id` as `pivot_category_id` from `ecommerce_categories` inner join `ecommerce_category_product` on `ecommerce_categories`.`id` = `ecommerce_category_product`.`category_id` where `ecommerce_category_product`.`product_id` = 53
1.64ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_brands` where `ecommerce_brands`.`id` = 1 limit 1
920μs/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `ecommerce_categories`.*, `ecommerce_category_product`.`product_id` as `pivot_product_id`, `ecommerce_category_product`.`category_id` as `pivot_category_id` from `ecommerce_categories` inner join `ecommerce_category_product` on `ecommerce_categories`.`id` = `ecommerce_category_product`.`category_id` where `ecommerce_category_product`.`product_id` = 54
1.31ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_brands` where `ecommerce_brands`.`id` = 1 limit 1
1.11ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `ecommerce_categories`.*, `ecommerce_category_product`.`product_id` as `pivot_product_id`, `ecommerce_category_product`.`category_id` as `pivot_category_id` from `ecommerce_categories` inner join `ecommerce_category_product` on `ecommerce_categories`.`id` = `ecommerce_category_product`.`category_id` where `ecommerce_category_product`.`product_id` = 55
1.93ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_brands` where `ecommerce_brands`.`id` = 1 limit 1
1.07ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `ecommerce_categories`.*, `ecommerce_category_product`.`product_id` as `pivot_product_id`, `ecommerce_category_product`.`category_id` as `pivot_category_id` from `ecommerce_categories` inner join `ecommerce_category_product` on `ecommerce_categories`.`id` = `ecommerce_category_product`.`category_id` where `ecommerce_category_product`.`product_id` = 56
1.2ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_brands` where `ecommerce_brands`.`id` = 1 limit 1
1.07ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `ecommerce_categories`.*, `ecommerce_category_product`.`product_id` as `pivot_product_id`, `ecommerce_category_product`.`category_id` as `pivot_category_id` from `ecommerce_categories` inner join `ecommerce_category_product` on `ecommerce_categories`.`id` = `ecommerce_category_product`.`category_id` where `ecommerce_category_product`.`product_id` = 57
1.37ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_brands` where `ecommerce_brands`.`id` = 1 limit 1
1.1ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `ecommerce_categories`.*, `ecommerce_category_product`.`product_id` as `pivot_product_id`, `ecommerce_category_product`.`category_id` as `pivot_category_id` from `ecommerce_categories` inner join `ecommerce_category_product` on `ecommerce_categories`.`id` = `ecommerce_category_product`.`category_id` where `ecommerce_category_product`.`product_id` = 58
1.27ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_brands` where `ecommerce_brands`.`id` = 1 limit 1
940μs/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `ecommerce_categories`.*, `ecommerce_category_product`.`product_id` as `pivot_product_id`, `ecommerce_category_product`.`category_id` as `pivot_category_id` from `ecommerce_categories` inner join `ecommerce_category_product` on `ecommerce_categories`.`id` = `ecommerce_category_product`.`category_id` where `ecommerce_category_product`.`product_id` = 59
1.98ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_brands` where `ecommerce_brands`.`id` = 1 limit 1
1.2ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `ecommerce_categories`.*, `ecommerce_category_product`.`product_id` as `pivot_product_id`, `ecommerce_category_product`.`category_id` as `pivot_category_id` from `ecommerce_categories` inner join `ecommerce_category_product` on `ecommerce_categories`.`id` = `ecommerce_category_product`.`category_id` where `ecommerce_category_product`.`product_id` = 60
1.43ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_brands` where `ecommerce_brands`.`id` = 1 limit 1
1.13ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `ecommerce_categories`.*, `ecommerce_category_product`.`product_id` as `pivot_product_id`, `ecommerce_category_product`.`category_id` as `pivot_category_id` from `ecommerce_categories` inner join `ecommerce_category_product` on `ecommerce_categories`.`id` = `ecommerce_category_product`.`category_id` where `ecommerce_category_product`.`product_id` = 61
1.39ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_brands` where `ecommerce_brands`.`id` = 1 limit 1
1.18ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `ecommerce_categories`.*, `ecommerce_category_product`.`product_id` as `pivot_product_id`, `ecommerce_category_product`.`category_id` as `pivot_category_id` from `ecommerce_categories` inner join `ecommerce_category_product` on `ecommerce_categories`.`id` = `ecommerce_category_product`.`category_id` where `ecommerce_category_product`.`product_id` = 66
1.27ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ecommerce_brands` where `ecommerce_brands`.`id` = 1 limit 1
1.17ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `ecommerce_categories`.*, `ecommerce_category_product`.`product_id` as `pivot_product_id`, `ecommerce_category_product`.`category_id` as `pivot_category_id` from `ecommerce_categories` inner join `ecommerce_category_product` on `ecommerce_categories`.`id` = `ecommerce_category_product`.`category_id` where `ecommerce_category_product`.`product_id` = 67
1.34ms/Corals/core/Foundation/Traits/Hookable.php:115daneenbrandMetadata | |
---|---|
Bindings |
|
Backtrace |
|
200
0 of 0array:1 [▼ "category" => "shower" ]
0 of 0array:1 [▼ "category" => "shower" ]
0 of 0array:15 [▼ "host" => array:1 [▶ 0 => "daneenbrand.com" ] "connection" => array:1 [▶ 0 => "keep-alive" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "sec-ch-ua" => array:1 [▶ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] ]
0 of 0array:45 [▼ "REDIRECT_HTTPS" => "on" "REDIRECT_SSL_TLS_SNI" => "daneenbrand.com" "REDIRECT_STATUS" => "200" "HTTPS" => "on" "SSL_TLS_SNI" => "daneenbrand.com" "HTTP_HOST" => "daneenbrand.com" "HTTP_CONNECTION" => "keep-alive" "HTTP_PRAGMA" => "no-cache" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "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_SEC_FETCH_SITE" => "none" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin" "SERVER_SIGNATURE" => "<address>Apache/2.4.52 (Ubuntu) Server at daneenbrand.com Port 443</address>\n" "SERVER_SOFTWARE" => "Apache/2.4.52 (Ubuntu)" "SERVER_NAME" => "daneenbrand.com" "SERVER_ADDR" => "142.171.111.97" "SERVER_PORT" => "443" "REMOTE_ADDR" => "18.117.85.183" "DOCUMENT_ROOT" => "/var/www/daneenbrand/public" "REQUEST_SCHEME" => "https" "CONTEXT_PREFIX" => "" "CONTEXT_DOCUMENT_ROOT" => "/var/www/daneenbrand/public" "SERVER_ADMIN" => "webmaster@localhost" "SCRIPT_FILENAME" => "/var/www/daneenbrand/public/index.php" "REMOTE_PORT" => "34606" "REDIRECT_URL" => "/shop" "REDIRECT_QUERY_STRING" => "category=shower" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "category=shower" "REQUEST_URI" => "/shop?category=shower" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1743796508.5738 "REQUEST_TIME" => 1743796508 ]
[]
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 => "Fri, 04 Apr 2025 19:55:08 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjZ0VEwyYTJtM2hMNUtYa2lsMHh6a3c9PSIsInZhbHVlIjoiOGRHVzdDUUZ1OVZRd3ZKcmlkRmFISXkvZWx4QnNpaEhtVDhCUW80RXptNC91cWkvdFQrNE1xNThZYk5XUU9GQnY5YlE5VGMwYVVMSG5nalVFMmNjdWR6ZDN4dGplQlNkVTVEZmhxdWhsbXpMM1JnQlg4aXpzWGlBaVZCVTN6dHAiLCJtYWMiOiJiZGI0Zjg0YzU5NGQ0N2UzMTliZTYwNjRkMzA4OTNhZGYyYzliNWU4NjdkNmZlMzNkMTY1ZTRjOGU5ZjZjODk2IiwidGFnIjoiIn0%3D; expires=Fri, 04-Apr-2025 21:55:09 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IjZ0VEwyYTJtM2hMNUtYa2lsMHh6a3c9PSIsInZhbHVlIjoiOGRHVzdDUUZ1OVZRd3ZKcmlkRmFISXkvZWx4QnNpaEhtVDhCUW80RXptNC91cWkvdFQrNE1xNThZYk5XUU9GQnY5YlE5V ▶" 1 => "daneenbrand_session=eyJpdiI6ImxubGhQak9XWno2bndjbmVjdzFOdnc9PSIsInZhbHVlIjoiRkxBTVNvS1g1UW5kWTZaNDRXYTRIL1kwS0Zvc0szdXk2WS82WndlMkVVQXhDTHdMUUZ5WUZqR3licjE2bzRDWDZ2THl6eWR2anBkQjRVTjlyZUVWdWFHVW5EbmQ3d2JxcWZ1alFzQmFRRDFtL3JYei82cmV3T0t4elF2aFVEUlciLCJtYWMiOiI3MGRkODhjZDNlZjkwZmY5OTdhN2VkNjQ0Mjg0MDE3ZTAxYjEwZGNkNmQ0ZDZlNDZlOWUwMGQwODZkZTVlMGM1IiwidGFnIjoiIn0%3D; expires=Fri, 04-Apr-2025 21:55:09 GMT; Max-Age=7200; path=/; httponly ◀daneenbrand_session=eyJpdiI6ImxubGhQak9XWno2bndjbmVjdzFOdnc9PSIsInZhbHVlIjoiRkxBTVNvS1g1UW5kWTZaNDRXYTRIL1kwS0Zvc0szdXk2WS82WndlMkVVQXhDTHdMUUZ5WUZqR3licjE2bzRD ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjZ0VEwyYTJtM2hMNUtYa2lsMHh6a3c9PSIsInZhbHVlIjoiOGRHVzdDUUZ1OVZRd3ZKcmlkRmFISXkvZWx4QnNpaEhtVDhCUW80RXptNC91cWkvdFQrNE1xNThZYk5XUU9GQnY5YlE5VGMwYVVMSG5nalVFMmNjdWR6ZDN4dGplQlNkVTVEZmhxdWhsbXpMM1JnQlg4aXpzWGlBaVZCVTN6dHAiLCJtYWMiOiJiZGI0Zjg0YzU5NGQ0N2UzMTliZTYwNjRkMzA4OTNhZGYyYzliNWU4NjdkNmZlMzNkMTY1ZTRjOGU5ZjZjODk2IiwidGFnIjoiIn0%3D; expires=Fri, 04-Apr-2025 21:55:09 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjZ0VEwyYTJtM2hMNUtYa2lsMHh6a3c9PSIsInZhbHVlIjoiOGRHVzdDUUZ1OVZRd3ZKcmlkRmFISXkvZWx4QnNpaEhtVDhCUW80RXptNC91cWkvdFQrNE1xNThZYk5XUU9GQnY5YlE5V ▶" 1 => "daneenbrand_session=eyJpdiI6ImxubGhQak9XWno2bndjbmVjdzFOdnc9PSIsInZhbHVlIjoiRkxBTVNvS1g1UW5kWTZaNDRXYTRIL1kwS0Zvc0szdXk2WS82WndlMkVVQXhDTHdMUUZ5WUZqR3licjE2bzRDWDZ2THl6eWR2anBkQjRVTjlyZUVWdWFHVW5EbmQ3d2JxcWZ1alFzQmFRRDFtL3JYei82cmV3T0t4elF2aFVEUlciLCJtYWMiOiI3MGRkODhjZDNlZjkwZmY5OTdhN2VkNjQ0Mjg0MDE3ZTAxYjEwZGNkNmQ0ZDZlNDZlOWUwMGQwODZkZTVlMGM1IiwidGFnIjoiIn0%3D; expires=Fri, 04-Apr-2025 21:55:09 GMT; path=/; httponly ◀daneenbrand_session=eyJpdiI6ImxubGhQak9XWno2bndjbmVjdzFOdnc9PSIsInZhbHVlIjoiRkxBTVNvS1g1UW5kWTZaNDRXYTRIL1kwS0Zvc0szdXk2WS82WndlMkVVQXhDTHdMUUZ5WUZqR3licjE2bzRD ▶" ] ]
0 of 0array:6 [▼ "_token" => "1BGGIu1tEGN9QO1kyZCaedKItxTOD3FiW5xluOAn" "currency" => "AED" "shoppingcart" => array:2 [▶ "instance" => "default" "instances" => array:1 [▶ 0 => "default" ] ] "_previous" => array:1 [▶ "url" => "https://daneenbrand.com/shop?category=shower" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]