Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
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 |
|
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 |
|
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 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
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 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
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 |
|
19 |
|
20 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
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 |
|
19 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
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 |
|
select * from `cad_category` where `cad_category`.`deleted_at` is null and `slug` = 'vestido' and `status` = '1' order by `sequence` asc limit 1
2.13mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_category` where `cad_category`.`deleted_at` is null and `cad_category`.`parent_id` in ('178') order by `sequence` asc
1.23mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_banner_group` where `cad_banner_group`.`deleted_at` is null and (select count(*) from `cad_category` inner join `cad_category_banner_group` on `cad_category`.`id` = `cad_category_banner_group`.`category_id` where `cad_category_banner_group`.`banner_group_id` = `cad_banner_group`.`id` and `id` = '178' and `cad_category`.`deleted_at` is null) >= 1 and `status` <> '0' order by `created_at` desc
1.53mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select `cad_product`.`id` from `cad_product` inner join `cad_store` on `cad_product`.`store_id` = `cad_store`.`id` inner join `cad_sku` on `cad_product`.`id` = `cad_sku`.`product_id` inner join `cad_price_table_sku` on `cad_sku`.`id` = `cad_price_table_sku`.`sku_id` where `cad_product`.`deleted_at` is null and (select count(*) from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_product_category`.`product_id` = `cad_product`.`id` and `category_id` in ('178') and `cad_category`.`deleted_at` is null) >= 1 and (`cad_product`.`publish` = '1' and `cad_product`.`deleted_at` is null) and (select count(*) from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_product_category`.`product_id` = `cad_product`.`id` and `status` = '1' and `cad_category`.`deleted_at` is null) >= 1 and (select count(*) from `cad_sku` where `cad_sku`.`product_id` = `cad_product`.`id` and `stock` > '0' and `cad_sku`.`status` = '1' and (select count(*) from `cad_price_table_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and ((`retail` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2C', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1) or (`wholesale` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2B', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1)) and `cad_price_table_sku`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1 and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `status` = '1' and `percent` >= '6.5' and `cad_store`.`deleted_at` is null) >= 1 and `cad_sku`.`status` = '1' and (`cad_price_table_sku`.`retail` > '0' or `cad_price_table_sku`.`wholesale` > '0') group by `cad_sku`.`product_id` order by
(SELECT -sequence from cad_product_category where category_id = 178 and product_id = cad_product.id LIMIT 1)
desc,
CASE
WHEN (cad_store.business_model = "B2C" AND cad_price_table_sku.sale_retail > 0)
THEN cad_price_table_sku.sale_retail
WHEN (cad_store.business_model = "B2C" AND cad_price_table_sku.sale_retail <= 0)
THEN cad_price_table_sku.retail
WHEN (cad_store.business_model = "B2B" AND cad_price_table_sku.sale_wholesale > 0)
THEN cad_price_table_sku.sale_wholesale
WHEN (cad_store.business_model = "B2B" AND cad_price_table_sku.sale_wholesale <= 0)
THEN cad_price_table_sku.wholesale
WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_retail > 0)
THEN cad_price_table_sku.sale_retail
WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_retail <= 0 AND cad_price_table_sku.retail > 0)
THEN cad_price_table_sku.retail
WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_wholesale > 0)
THEN cad_price_table_sku.sale_wholesale
WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_wholesale <= 0 AND cad_price_table_sku.wholesale > 0)
THEN cad_price_table_sku.wholesale
END
desc
68.09mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select `id`, `name`, `parent_id`, `slug`, `sequence` from `cad_category` where `cad_category`.`deleted_at` is null and (select count(*) from `cad_product` inner join `cad_product_category` on `cad_product`.`id` = `cad_product_category`.`product_id` where `cad_product_category`.`category_id` = `cad_category`.`id` and `product_id` in ('430', '426', '2792', '5721', '5723', '5724', '427', '3496', '3524', '4406', '5273', '2954', '4390', '5961', '2958', '2955', '6225', '4637', '4644', '4636', '5959', '4315', '4996', '4318', '4314', '4312', '2558') and `cad_product`.`deleted_at` is null) >= 1 and `status` = '1'
66.32mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select distinct `id`, `name` from `cad_brand` where `cad_brand`.`deleted_at` is null and (select count(*) from `cad_product` where `cad_product`.`brand_id` = `cad_brand`.`id` and `id` in ('430', '426', '2792', '5721', '5723', '5724', '427', '3496', '3524', '4406', '5273', '2954', '4390', '5961', '2958', '2955', '6225', '4637', '4644', '4636', '5959', '4315', '4996', '4318', '4314', '4312', '2558') and `cad_product`.`deleted_at` is null) >= 1 order by `name` asc
1.46mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select exists(select * from `cad_product` where `cad_product`.`deleted_at` is null and `id` in ('430', '426', '2792', '5721', '5723', '5724', '427', '3496', '3524', '4406', '5273', '2954', '4390', '5961', '2958', '2955', '6225', '4637', '4644', '4636', '5959', '4315', '4996', '4318', '4314', '4312', '2558') and (select count(*) from `cad_sku` where `cad_sku`.`product_id` = `cad_product`.`id` and `cad_sku`.`status` = '1' and (select count(*) from `cad_price_table_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and ((`wholesale` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2B', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1)) and `cad_price_table_sku`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1) as `exists`
4.31mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select exists(select * from `cad_product` where `cad_product`.`deleted_at` is null and `id` in ('430', '426', '2792', '5721', '5723', '5724', '427', '3496', '3524', '4406', '5273', '2954', '4390', '5961', '2958', '2955', '6225', '4637', '4644', '4636', '5959', '4315', '4996', '4318', '4314', '4312', '2558') and (select count(*) from `cad_sku` where `cad_sku`.`product_id` = `cad_product`.`id` and `cad_sku`.`status` = '1' and (select count(*) from `cad_price_table_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and ((`retail` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2C', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1)) and `cad_price_table_sku`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1) as `exists`
2.06mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select `id`, `name`, `main_id` from `cad_variant` where `cad_variant`.`deleted_at` is null and (select count(*) from `cad_sku` inner join `cad_sku_variant` on `cad_sku`.`id` = `cad_sku_variant`.`sku_id` where `cad_sku_variant`.`variant_id` = `cad_variant`.`id` and `cad_sku`.`product_id` in ('430', '426', '2792', '5721', '5723', '5724', '427', '3496', '3524', '4406', '5273', '2954', '4390', '5961', '2958', '2955', '6225', '4637', '4644', '4636', '5959', '4315', '4996', '4318', '4314', '4312', '2558') and `stock` > '0' and `cad_sku`.`status` = '1' and (select count(*) from `cad_price_table_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and ((`retail` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2C', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1) or (`wholesale` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2B', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1)) and `cad_price_table_sku`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1
41.24mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select `id`, `name` from `cad_variant` where `cad_variant`.`deleted_at` is null and `cad_variant`.`id` in ('1', '14', '556')
2.49mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_attribute` where `cad_attribute`.`deleted_at` is null and (select count(*) from `cad_attribute` as `self_7d71be89288fd7c864172c9d1297212b` where `cad_attribute`.`deleted_at` is null and `self_7d71be89288fd7c864172c9d1297212b`.`main_id` = `cad_attribute`.`id` and (select count(*) from `cad_product` inner join `cad_product_attributes` on `cad_product`.`id` = `cad_product_attributes`.`product_id` where `cad_product_attributes`.`attribute_id` = `self_7d71be89288fd7c864172c9d1297212b`.`id` and `product_id` in ('430', '426', '2792', '5721', '5723', '5724', '427', '3496', '3524', '4406', '5273', '2954', '4390', '5961', '2958', '2955', '6225', '4637', '4644', '4636', '5959', '4315', '4996', '4318', '4314', '4312', '2558') and `cad_product`.`deleted_at` is null) >= 1 and `cad_attribute`.`deleted_at` is null) >= 1 and `main_id` is null order by `name` asc
1.99mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select count(*) as aggregate from `cad_product` where `cad_product`.`deleted_at` is null and `id` in ('430', '426', '2792', '5721', '5723', '5724', '427', '3496', '3524', '4406', '5273', '2954', '4390', '5961', '2958', '2955', '6225', '4637', '4644', '4636', '5959', '4315', '4996', '4318', '4314', '4312', '2558')
1.8mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_product` where `cad_product`.`deleted_at` is null and `id` in ('430', '426', '2792', '5721', '5723', '5724', '427', '3496', '3524', '4406', '5273', '2954', '4390', '5961', '2958', '2955', '6225', '4637', '4644', '4636', '5959', '4315', '4996', '4318', '4314', '4312', '2558') order by FIELD(id, 430,426,2792,5721,5723,5724,427,3496,3524,4406,5273,2954,4390,5961,2958,2955,6225,4637,4644,4636,5959,4315,4996,4318,4314,4312,2558) limit 20 offset 20
2.5mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_product_image` where `cad_product_image`.`deleted_at` is null and `cad_product_image`.`product_id` in ('5959', '4315', '4996', '4318', '4314', '4312', '2558') order by `sequence` asc
2.31mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select `cad_sku`.* from `cad_sku` inner join `cad_product` on `cad_sku`.`product_id` = `cad_product`.`id` inner join `cad_store` on `cad_product`.`store_id` = `cad_store`.`id` inner join `cad_price_table_sku` on `cad_sku`.`id` = `cad_price_table_sku`.`sku_id` where `cad_sku`.`deleted_at` is null and `cad_sku`.`product_id` in ('5959', '4315', '4996', '4318', '4314', '4312', '2558') and `cad_sku`.`status` = '1' and `stock` > '0' and `cad_sku`.`status` = '1' and (select count(*) from `cad_price_table_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and ((`retail` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2C', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1) or (`wholesale` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2B', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1)) and `cad_price_table_sku`.`deleted_at` is null) >= 1 order by
cad_price_table_sku.retail = 0, cad_price_table_sku.wholesale = 0,
CASE
WHEN (cad_store.business_model = "B2C" AND cad_price_table_sku.sale_retail > 0)
THEN cad_price_table_sku.sale_retail
WHEN (cad_store.business_model = "B2C" AND cad_price_table_sku.sale_retail <= 0)
THEN cad_price_table_sku.retail
WHEN (cad_store.business_model = "B2B" AND cad_price_table_sku.sale_wholesale > 0)
THEN cad_price_table_sku.sale_wholesale
WHEN (cad_store.business_model = "B2B" AND cad_price_table_sku.sale_wholesale <= 0)
THEN cad_price_table_sku.wholesale
WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_retail > 0)
THEN cad_price_table_sku.sale_retail
WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_retail <= 0 AND cad_price_table_sku.retail > 0)
THEN cad_price_table_sku.retail
WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_wholesale > 0)
THEN cad_price_table_sku.sale_wholesale
WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_wholesale <= 0 AND cad_price_table_sku.wholesale > 0)
THEN cad_price_table_sku.wholesale
END
asc
3.46mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_product` where `cad_product`.`deleted_at` is null and `cad_product`.`id` in ('2558', '4312', '4314', '4318', '4996', '4315', '5959')
1.6mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_store` where `cad_store`.`deleted_at` is null and `cad_store`.`id` in ('795', '1352', '1979', '1819')
1.79mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_price_table_sku` where `cad_price_table_sku`.`deleted_at` is null and `cad_price_table_sku`.`sku_id` in ('3487', '5682', '5684', '5688', '6693', '5685', '7867')
1.6mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` in ('5959', '4315', '4996', '4318', '4314', '4312', '2558')
2.17mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_store` where `cad_store`.`deleted_at` is null and `cad_store`.`id` in ('1819', '1352', '1979', '795')
1.77mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_show_case` where `cad_show_case`.`deleted_at` is null and (select count(*) from `cad_category` inner join `cad_category_show_case` on `cad_category`.`id` = `cad_category_show_case`.`category_id` where `cad_category_show_case`.`show_case_id` = `cad_show_case`.`id` and `category_id` = '178' and `cad_category`.`deleted_at` is null) >= 1 and `status` = '1' order by `sequence` asc
2.72mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_category` where `cad_category`.`deleted_at` is null and `cad_category`.`id` = '11' limit 1
1.51mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_category` where `cad_category`.`deleted_at` is null and `cad_category`.`id` = '1' limit 1
1.38mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_category` where `cad_category`.`deleted_at` is null and `cad_category`.`id` is null limit 1
1.08mssmp_mercadoblackmoneyMetadata | |
---|---|
Hints |
|
select * from `cad_payment_installment_settings` where `cad_payment_installment_settings`.`deleted_at` is null and `cad_payment_installment_settings`.`id` = '3' limit 1
1.42mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '5959'
2.41mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '1819' and `cad_payment_recipient`.`store_id` is not null
1.53mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '4315'
1.44mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '1352' and `cad_payment_recipient`.`store_id` is not null
1.54mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '4996'
2.01mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '1979' and `cad_payment_recipient`.`store_id` is not null
1.31mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '4318'
1.85mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '4314'
1.7mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '4312'
1.86mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '2558'
2.15mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '795' and `cad_payment_recipient`.`store_id` is not null
1.75mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` = 'cssEditor' and `attribute` = '' limit 1
1.54mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` not like 'cssEditor'
1.4mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_social_media` where `status` = '1' order by `sequence` asc
1.32mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_menu_items` where `cad_menu_items`.`deleted_at` is null and `active` = '1'
1.78mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_social_media` where `status` = '1' order by `sequence` asc
1.6mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` not like 'cssEditor'
1.37mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` not like 'cssEditor'
1.32mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|