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 |
|
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 |
|
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` = 'acessorios-gUqS' and `status` = '1' order by `sequence` asc limit 1
1.89mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_category` where `cad_category`.`deleted_at` is null and `cad_category`.`parent_id` in ('163') order by `sequence` asc
1.24mssmp_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` = '163' and `cad_category`.`deleted_at` is null) >= 1 and `status` <> '0' order by `created_at` desc
1.74mssmp_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 ('163') 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 = 163 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
54.92mssmp_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 ('3384', '1192', '1194', '3223', '3221', '1808', '1191', '1195', '1196', '1201', '1197', '1198', '942', '1692', '1691', '3387', '1226', '1207', '1206', '1228', '1223', '1224', '1225', '1222', '1221', '1220', '1219', '1218', '919') and `cad_product`.`deleted_at` is null) >= 1 and `status` = '1'
72.46mssmp_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 ('3384', '1192', '1194', '3223', '3221', '1808', '1191', '1195', '1196', '1201', '1197', '1198', '942', '1692', '1691', '3387', '1226', '1207', '1206', '1228', '1223', '1224', '1225', '1222', '1221', '1220', '1219', '1218', '919') and `cad_product`.`deleted_at` is null) >= 1 order by `name` asc
2.1mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select exists(select * from `cad_product` where `cad_product`.`deleted_at` is null and `id` in ('3384', '1192', '1194', '3223', '3221', '1808', '1191', '1195', '1196', '1201', '1197', '1198', '942', '1692', '1691', '3387', '1226', '1207', '1206', '1228', '1223', '1224', '1225', '1222', '1221', '1220', '1219', '1218', '919') 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`
3.35mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select exists(select * from `cad_product` where `cad_product`.`deleted_at` is null and `id` in ('3384', '1192', '1194', '3223', '3221', '1808', '1191', '1195', '1196', '1201', '1197', '1198', '942', '1692', '1691', '3387', '1226', '1207', '1206', '1228', '1223', '1224', '1225', '1222', '1221', '1220', '1219', '1218', '919') 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.13mssmp_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 ('3384', '1192', '1194', '3223', '3221', '1808', '1191', '1195', '1196', '1201', '1197', '1198', '942', '1692', '1691', '3387', '1226', '1207', '1206', '1228', '1223', '1224', '1225', '1222', '1221', '1220', '1219', '1218', '919') 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
42.85mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select `id`, `name` from `cad_variant` where `cad_variant`.`deleted_at` is null and `cad_variant`.`id` in ('177', '14', '330')
1.57mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_attribute` where `cad_attribute`.`deleted_at` is null and (select count(*) from `cad_attribute` as `self_cd9054457d844f3d97177b2f5dfb9bd0` where `cad_attribute`.`deleted_at` is null and `self_cd9054457d844f3d97177b2f5dfb9bd0`.`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_cd9054457d844f3d97177b2f5dfb9bd0`.`id` and `product_id` in ('3384', '1192', '1194', '3223', '3221', '1808', '1191', '1195', '1196', '1201', '1197', '1198', '942', '1692', '1691', '3387', '1226', '1207', '1206', '1228', '1223', '1224', '1225', '1222', '1221', '1220', '1219', '1218', '919') 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
2.82mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select count(*) as aggregate from `cad_product` where `cad_product`.`deleted_at` is null and `id` in ('3384', '1192', '1194', '3223', '3221', '1808', '1191', '1195', '1196', '1201', '1197', '1198', '942', '1692', '1691', '3387', '1226', '1207', '1206', '1228', '1223', '1224', '1225', '1222', '1221', '1220', '1219', '1218', '919')
1.18mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_product` where `cad_product`.`deleted_at` is null and `id` in ('3384', '1192', '1194', '3223', '3221', '1808', '1191', '1195', '1196', '1201', '1197', '1198', '942', '1692', '1691', '3387', '1226', '1207', '1206', '1228', '1223', '1224', '1225', '1222', '1221', '1220', '1219', '1218', '919') order by FIELD(id, 3384,1192,1194,3223,3221,1808,1191,1195,1196,1201,1197,1198,942,1692,1691,3387,1226,1207,1206,1228,1223,1224,1225,1222,1221,1220,1219,1218,919) limit 20 offset 20
2.26mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_product_image` where `cad_product_image`.`deleted_at` is null and `cad_product_image`.`product_id` in ('1223', '1224', '1225', '1222', '1221', '1220', '1219', '1218', '919') order by `sequence` asc
1.35mssmp_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 ('1223', '1224', '1225', '1222', '1221', '1220', '1219', '1218', '919') 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.48mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_product` where `cad_product`.`deleted_at` is null and `cad_product`.`id` in ('1221', '1225', '1224', '1223', '1222', '919', '1220', '1219', '1218')
1.29mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_store` where `cad_store`.`deleted_at` is null and `cad_store`.`id` in ('368', '578')
1.16mssmp_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 ('1553', '1567', '1566', '1565', '1564', '1563', '1562', '1561', '1560', '1559', '1558', '1557', '1556', '1555', '1554', '1153', '1552', '1551', '1550', '1549', '1548', '1547', '1546', '1545', '1544', '1543', '1542', '1541', '1539', '1538')
1.72mssmp_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 ('1223', '1224', '1225', '1222', '1221', '1220', '1219', '1218', '919')
1.68mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_store` where `cad_store`.`deleted_at` is null and `cad_store`.`id` in ('578', '368')
1.51mssmp_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` = '163' and `cad_category`.`deleted_at` is null) >= 1 and `status` = '1' order by `sequence` asc
3.11mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_category` where `cad_category`.`deleted_at` is null and `cad_category`.`id` is null limit 1
980μssmp_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.03mssmp_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` = '1223'
1.43mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '578' and `cad_payment_recipient`.`store_id` is not null
1.12mssmp_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` = '1224'
1.71mssmp_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` = '1225'
1.51mssmp_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` = '1222'
1.36mssmp_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` = '1221'
1.35mssmp_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` = '1220'
1.21mssmp_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` = '1219'
1.41mssmp_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` = '1218'
1.68mssmp_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` = '919'
1.52mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '368' and `cad_payment_recipient`.`store_id` is not null
1.24mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` = 'cssEditor' and `attribute` = '' limit 1
1.29mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` not like 'cssEditor'
710μssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_social_media` where `status` = '1' order by `sequence` asc
1.14mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_menu_items` where `cad_menu_items`.`deleted_at` is null and `active` = '1'
1.1mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_social_media` where `status` = '1' order by `sequence` asc
1.49mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` not like 'cssEditor'
1.56mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` not like 'cssEditor'
940μssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|