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 |
|
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 |
|
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 |
|
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 |
|
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` = 'joias' and `status` = '1' order by `sequence` asc limit 1
2.22mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_category` where `cad_category`.`deleted_at` is null and `cad_category`.`parent_id` in ('14') order by `sequence` asc
2.01mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_category` where `cad_category`.`deleted_at` is null and `cad_category`.`parent_id` in ('174', '175', '176', '177', '187') order by `sequence` asc
1.33mssmp_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` = '14' and `cad_category`.`deleted_at` is null) >= 1 and `status` <> '0' order by `created_at` desc
2.11mssmp_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 ('14') 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 = 14 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
104.87mssmp_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 ('2378', '2377', '2280', '2276', '2279', '2376', '4600', '2564', '3168', '2274', '4599', '1277', '1278', '1279', '2278', '2554', '3178', '2271', '2423', '2426', '4597', '4598', '6569', '901', '3163', '3185', '6447', '3171', '904', '1280', '1281', '2275', '2789', '2872', '3265', '6453', '2736', '3143', '2785', '3165', '3740', '2710', '3148', '2769', '380', '2751', '123', '125', '3190', '2702', '2779', '1282', '1283', '1284', '2707', '2738', '3146', '2713', '2748', '3274', '2739', '2778', '2780', '2206', '2207', '3161', '3162', '2735', '2777', '2374', '2711', '2783', '2708', '2709', '3170', '2744', '2784', '2718', '2770', '2551', '2786', '2714', '2743', '2773', '2787', '2703', '884', '2208', '2767', '2776', '2725', '2272', '2273', '2715', '2749', '2722', '2721', '2747', '2705', '2647', '2782', '6562', '6563', '6565', '6566', '6567', '6568', '6570', '2425', '6520', '2704', '1192', '1194', '2706', '3172', '2764', '1191', '1195', '2745', '2741', '2733', '2774', '1196', '6564', '6571', '1201', '2731', '2742', '3278', '1197', '1198', '2757', '2762', '2549', '2716', '2752', '2753', '2723', '892', '3910', '3911', '1691', '2369', '2373', '2720', '3261', '6572', '455', '4651', '4652', '4655', '2755', '2756', '2724', '2746', '2649', '2650', '2651', '3781', '2758', '2734', '2368', '2370', '2371', '2552', '2553', '2627', '2727', '2728', '2729', '2730', '2726', '3267', '3279', '4203', '4658', '4674', '442', '4653', '4654', '4656', '2359', '2522', '2765', '2372', '2628', '2629', '3617', '448', '450', '452', '3588', '5966', '5967', '5016', '5017', '5018', '3614', '4202', '4206', '4225', '5442', '5681', '5682', '2626', '3788', '5678', '2462', '2463', '2465', '4700', '4702', '4705', '4707', '4708', '4709', '4710', '4711', '4712', '4715', '4716', '4717', '4718', '4719', '4721', '4723', '4724', '4725', '4726', '4728', '4699', '5441', '5445') and `cad_product`.`deleted_at` is null) >= 1 and `status` = '1'
64.79mssmp_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 ('2378', '2377', '2280', '2276', '2279', '2376', '4600', '2564', '3168', '2274', '4599', '1277', '1278', '1279', '2278', '2554', '3178', '2271', '2423', '2426', '4597', '4598', '6569', '901', '3163', '3185', '6447', '3171', '904', '1280', '1281', '2275', '2789', '2872', '3265', '6453', '2736', '3143', '2785', '3165', '3740', '2710', '3148', '2769', '380', '2751', '123', '125', '3190', '2702', '2779', '1282', '1283', '1284', '2707', '2738', '3146', '2713', '2748', '3274', '2739', '2778', '2780', '2206', '2207', '3161', '3162', '2735', '2777', '2374', '2711', '2783', '2708', '2709', '3170', '2744', '2784', '2718', '2770', '2551', '2786', '2714', '2743', '2773', '2787', '2703', '884', '2208', '2767', '2776', '2725', '2272', '2273', '2715', '2749', '2722', '2721', '2747', '2705', '2647', '2782', '6562', '6563', '6565', '6566', '6567', '6568', '6570', '2425', '6520', '2704', '1192', '1194', '2706', '3172', '2764', '1191', '1195', '2745', '2741', '2733', '2774', '1196', '6564', '6571', '1201', '2731', '2742', '3278', '1197', '1198', '2757', '2762', '2549', '2716', '2752', '2753', '2723', '892', '3910', '3911', '1691', '2369', '2373', '2720', '3261', '6572', '455', '4651', '4652', '4655', '2755', '2756', '2724', '2746', '2649', '2650', '2651', '3781', '2758', '2734', '2368', '2370', '2371', '2552', '2553', '2627', '2727', '2728', '2729', '2730', '2726', '3267', '3279', '4203', '4658', '4674', '442', '4653', '4654', '4656', '2359', '2522', '2765', '2372', '2628', '2629', '3617', '448', '450', '452', '3588', '5966', '5967', '5016', '5017', '5018', '3614', '4202', '4206', '4225', '5442', '5681', '5682', '2626', '3788', '5678', '2462', '2463', '2465', '4700', '4702', '4705', '4707', '4708', '4709', '4710', '4711', '4712', '4715', '4716', '4717', '4718', '4719', '4721', '4723', '4724', '4725', '4726', '4728', '4699', '5441', '5445') and `cad_product`.`deleted_at` is null) >= 1 order by `name` asc
3.74mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select exists(select * from `cad_product` where `cad_product`.`deleted_at` is null and `id` in ('2378', '2377', '2280', '2276', '2279', '2376', '4600', '2564', '3168', '2274', '4599', '1277', '1278', '1279', '2278', '2554', '3178', '2271', '2423', '2426', '4597', '4598', '6569', '901', '3163', '3185', '6447', '3171', '904', '1280', '1281', '2275', '2789', '2872', '3265', '6453', '2736', '3143', '2785', '3165', '3740', '2710', '3148', '2769', '380', '2751', '123', '125', '3190', '2702', '2779', '1282', '1283', '1284', '2707', '2738', '3146', '2713', '2748', '3274', '2739', '2778', '2780', '2206', '2207', '3161', '3162', '2735', '2777', '2374', '2711', '2783', '2708', '2709', '3170', '2744', '2784', '2718', '2770', '2551', '2786', '2714', '2743', '2773', '2787', '2703', '884', '2208', '2767', '2776', '2725', '2272', '2273', '2715', '2749', '2722', '2721', '2747', '2705', '2647', '2782', '6562', '6563', '6565', '6566', '6567', '6568', '6570', '2425', '6520', '2704', '1192', '1194', '2706', '3172', '2764', '1191', '1195', '2745', '2741', '2733', '2774', '1196', '6564', '6571', '1201', '2731', '2742', '3278', '1197', '1198', '2757', '2762', '2549', '2716', '2752', '2753', '2723', '892', '3910', '3911', '1691', '2369', '2373', '2720', '3261', '6572', '455', '4651', '4652', '4655', '2755', '2756', '2724', '2746', '2649', '2650', '2651', '3781', '2758', '2734', '2368', '2370', '2371', '2552', '2553', '2627', '2727', '2728', '2729', '2730', '2726', '3267', '3279', '4203', '4658', '4674', '442', '4653', '4654', '4656', '2359', '2522', '2765', '2372', '2628', '2629', '3617', '448', '450', '452', '3588', '5966', '5967', '5016', '5017', '5018', '3614', '4202', '4206', '4225', '5442', '5681', '5682', '2626', '3788', '5678', '2462', '2463', '2465', '4700', '4702', '4705', '4707', '4708', '4709', '4710', '4711', '4712', '4715', '4716', '4717', '4718', '4719', '4721', '4723', '4724', '4725', '4726', '4728', '4699', '5441', '5445') 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`
9.35mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select exists(select * from `cad_product` where `cad_product`.`deleted_at` is null and `id` in ('2378', '2377', '2280', '2276', '2279', '2376', '4600', '2564', '3168', '2274', '4599', '1277', '1278', '1279', '2278', '2554', '3178', '2271', '2423', '2426', '4597', '4598', '6569', '901', '3163', '3185', '6447', '3171', '904', '1280', '1281', '2275', '2789', '2872', '3265', '6453', '2736', '3143', '2785', '3165', '3740', '2710', '3148', '2769', '380', '2751', '123', '125', '3190', '2702', '2779', '1282', '1283', '1284', '2707', '2738', '3146', '2713', '2748', '3274', '2739', '2778', '2780', '2206', '2207', '3161', '3162', '2735', '2777', '2374', '2711', '2783', '2708', '2709', '3170', '2744', '2784', '2718', '2770', '2551', '2786', '2714', '2743', '2773', '2787', '2703', '884', '2208', '2767', '2776', '2725', '2272', '2273', '2715', '2749', '2722', '2721', '2747', '2705', '2647', '2782', '6562', '6563', '6565', '6566', '6567', '6568', '6570', '2425', '6520', '2704', '1192', '1194', '2706', '3172', '2764', '1191', '1195', '2745', '2741', '2733', '2774', '1196', '6564', '6571', '1201', '2731', '2742', '3278', '1197', '1198', '2757', '2762', '2549', '2716', '2752', '2753', '2723', '892', '3910', '3911', '1691', '2369', '2373', '2720', '3261', '6572', '455', '4651', '4652', '4655', '2755', '2756', '2724', '2746', '2649', '2650', '2651', '3781', '2758', '2734', '2368', '2370', '2371', '2552', '2553', '2627', '2727', '2728', '2729', '2730', '2726', '3267', '3279', '4203', '4658', '4674', '442', '4653', '4654', '4656', '2359', '2522', '2765', '2372', '2628', '2629', '3617', '448', '450', '452', '3588', '5966', '5967', '5016', '5017', '5018', '3614', '4202', '4206', '4225', '5442', '5681', '5682', '2626', '3788', '5678', '2462', '2463', '2465', '4700', '4702', '4705', '4707', '4708', '4709', '4710', '4711', '4712', '4715', '4716', '4717', '4718', '4719', '4721', '4723', '4724', '4725', '4726', '4728', '4699', '5441', '5445') 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`
4.27mssmp_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 ('2378', '2377', '2280', '2276', '2279', '2376', '4600', '2564', '3168', '2274', '4599', '1277', '1278', '1279', '2278', '2554', '3178', '2271', '2423', '2426', '4597', '4598', '6569', '901', '3163', '3185', '6447', '3171', '904', '1280', '1281', '2275', '2789', '2872', '3265', '6453', '2736', '3143', '2785', '3165', '3740', '2710', '3148', '2769', '380', '2751', '123', '125', '3190', '2702', '2779', '1282', '1283', '1284', '2707', '2738', '3146', '2713', '2748', '3274', '2739', '2778', '2780', '2206', '2207', '3161', '3162', '2735', '2777', '2374', '2711', '2783', '2708', '2709', '3170', '2744', '2784', '2718', '2770', '2551', '2786', '2714', '2743', '2773', '2787', '2703', '884', '2208', '2767', '2776', '2725', '2272', '2273', '2715', '2749', '2722', '2721', '2747', '2705', '2647', '2782', '6562', '6563', '6565', '6566', '6567', '6568', '6570', '2425', '6520', '2704', '1192', '1194', '2706', '3172', '2764', '1191', '1195', '2745', '2741', '2733', '2774', '1196', '6564', '6571', '1201', '2731', '2742', '3278', '1197', '1198', '2757', '2762', '2549', '2716', '2752', '2753', '2723', '892', '3910', '3911', '1691', '2369', '2373', '2720', '3261', '6572', '455', '4651', '4652', '4655', '2755', '2756', '2724', '2746', '2649', '2650', '2651', '3781', '2758', '2734', '2368', '2370', '2371', '2552', '2553', '2627', '2727', '2728', '2729', '2730', '2726', '3267', '3279', '4203', '4658', '4674', '442', '4653', '4654', '4656', '2359', '2522', '2765', '2372', '2628', '2629', '3617', '448', '450', '452', '3588', '5966', '5967', '5016', '5017', '5018', '3614', '4202', '4206', '4225', '5442', '5681', '5682', '2626', '3788', '5678', '2462', '2463', '2465', '4700', '4702', '4705', '4707', '4708', '4709', '4710', '4711', '4712', '4715', '4716', '4717', '4718', '4719', '4721', '4723', '4724', '4725', '4726', '4728', '4699', '5441', '5445') 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
50.82mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select `id`, `name` from `cad_variant` where `cad_variant`.`deleted_at` is null and `cad_variant`.`id` in ('14', '1', '556', '558', '562', '605', '50', '177')
1.52mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_attribute` where `cad_attribute`.`deleted_at` is null and (select count(*) from `cad_attribute` as `self_379b5a3ae13d328f3f30ed734108abfa` where `cad_attribute`.`deleted_at` is null and `self_379b5a3ae13d328f3f30ed734108abfa`.`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_379b5a3ae13d328f3f30ed734108abfa`.`id` and `product_id` in ('2378', '2377', '2280', '2276', '2279', '2376', '4600', '2564', '3168', '2274', '4599', '1277', '1278', '1279', '2278', '2554', '3178', '2271', '2423', '2426', '4597', '4598', '6569', '901', '3163', '3185', '6447', '3171', '904', '1280', '1281', '2275', '2789', '2872', '3265', '6453', '2736', '3143', '2785', '3165', '3740', '2710', '3148', '2769', '380', '2751', '123', '125', '3190', '2702', '2779', '1282', '1283', '1284', '2707', '2738', '3146', '2713', '2748', '3274', '2739', '2778', '2780', '2206', '2207', '3161', '3162', '2735', '2777', '2374', '2711', '2783', '2708', '2709', '3170', '2744', '2784', '2718', '2770', '2551', '2786', '2714', '2743', '2773', '2787', '2703', '884', '2208', '2767', '2776', '2725', '2272', '2273', '2715', '2749', '2722', '2721', '2747', '2705', '2647', '2782', '6562', '6563', '6565', '6566', '6567', '6568', '6570', '2425', '6520', '2704', '1192', '1194', '2706', '3172', '2764', '1191', '1195', '2745', '2741', '2733', '2774', '1196', '6564', '6571', '1201', '2731', '2742', '3278', '1197', '1198', '2757', '2762', '2549', '2716', '2752', '2753', '2723', '892', '3910', '3911', '1691', '2369', '2373', '2720', '3261', '6572', '455', '4651', '4652', '4655', '2755', '2756', '2724', '2746', '2649', '2650', '2651', '3781', '2758', '2734', '2368', '2370', '2371', '2552', '2553', '2627', '2727', '2728', '2729', '2730', '2726', '3267', '3279', '4203', '4658', '4674', '442', '4653', '4654', '4656', '2359', '2522', '2765', '2372', '2628', '2629', '3617', '448', '450', '452', '3588', '5966', '5967', '5016', '5017', '5018', '3614', '4202', '4206', '4225', '5442', '5681', '5682', '2626', '3788', '5678', '2462', '2463', '2465', '4700', '4702', '4705', '4707', '4708', '4709', '4710', '4711', '4712', '4715', '4716', '4717', '4718', '4719', '4721', '4723', '4724', '4725', '4726', '4728', '4699', '5441', '5445') 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
3.01mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select count(*) as aggregate from `cad_product` where `cad_product`.`deleted_at` is null and `id` in ('2378', '2377', '2280', '2276', '2279', '2376', '4600', '2564', '3168', '2274', '4599', '1277', '1278', '1279', '2278', '2554', '3178', '2271', '2423', '2426', '4597', '4598', '6569', '901', '3163', '3185', '6447', '3171', '904', '1280', '1281', '2275', '2789', '2872', '3265', '6453', '2736', '3143', '2785', '3165', '3740', '2710', '3148', '2769', '380', '2751', '123', '125', '3190', '2702', '2779', '1282', '1283', '1284', '2707', '2738', '3146', '2713', '2748', '3274', '2739', '2778', '2780', '2206', '2207', '3161', '3162', '2735', '2777', '2374', '2711', '2783', '2708', '2709', '3170', '2744', '2784', '2718', '2770', '2551', '2786', '2714', '2743', '2773', '2787', '2703', '884', '2208', '2767', '2776', '2725', '2272', '2273', '2715', '2749', '2722', '2721', '2747', '2705', '2647', '2782', '6562', '6563', '6565', '6566', '6567', '6568', '6570', '2425', '6520', '2704', '1192', '1194', '2706', '3172', '2764', '1191', '1195', '2745', '2741', '2733', '2774', '1196', '6564', '6571', '1201', '2731', '2742', '3278', '1197', '1198', '2757', '2762', '2549', '2716', '2752', '2753', '2723', '892', '3910', '3911', '1691', '2369', '2373', '2720', '3261', '6572', '455', '4651', '4652', '4655', '2755', '2756', '2724', '2746', '2649', '2650', '2651', '3781', '2758', '2734', '2368', '2370', '2371', '2552', '2553', '2627', '2727', '2728', '2729', '2730', '2726', '3267', '3279', '4203', '4658', '4674', '442', '4653', '4654', '4656', '2359', '2522', '2765', '2372', '2628', '2629', '3617', '448', '450', '452', '3588', '5966', '5967', '5016', '5017', '5018', '3614', '4202', '4206', '4225', '5442', '5681', '5682', '2626', '3788', '5678', '2462', '2463', '2465', '4700', '4702', '4705', '4707', '4708', '4709', '4710', '4711', '4712', '4715', '4716', '4717', '4718', '4719', '4721', '4723', '4724', '4725', '4726', '4728', '4699', '5441', '5445')
4.18mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_product` where `cad_product`.`deleted_at` is null and `id` in ('2378', '2377', '2280', '2276', '2279', '2376', '4600', '2564', '3168', '2274', '4599', '1277', '1278', '1279', '2278', '2554', '3178', '2271', '2423', '2426', '4597', '4598', '6569', '901', '3163', '3185', '6447', '3171', '904', '1280', '1281', '2275', '2789', '2872', '3265', '6453', '2736', '3143', '2785', '3165', '3740', '2710', '3148', '2769', '380', '2751', '123', '125', '3190', '2702', '2779', '1282', '1283', '1284', '2707', '2738', '3146', '2713', '2748', '3274', '2739', '2778', '2780', '2206', '2207', '3161', '3162', '2735', '2777', '2374', '2711', '2783', '2708', '2709', '3170', '2744', '2784', '2718', '2770', '2551', '2786', '2714', '2743', '2773', '2787', '2703', '884', '2208', '2767', '2776', '2725', '2272', '2273', '2715', '2749', '2722', '2721', '2747', '2705', '2647', '2782', '6562', '6563', '6565', '6566', '6567', '6568', '6570', '2425', '6520', '2704', '1192', '1194', '2706', '3172', '2764', '1191', '1195', '2745', '2741', '2733', '2774', '1196', '6564', '6571', '1201', '2731', '2742', '3278', '1197', '1198', '2757', '2762', '2549', '2716', '2752', '2753', '2723', '892', '3910', '3911', '1691', '2369', '2373', '2720', '3261', '6572', '455', '4651', '4652', '4655', '2755', '2756', '2724', '2746', '2649', '2650', '2651', '3781', '2758', '2734', '2368', '2370', '2371', '2552', '2553', '2627', '2727', '2728', '2729', '2730', '2726', '3267', '3279', '4203', '4658', '4674', '442', '4653', '4654', '4656', '2359', '2522', '2765', '2372', '2628', '2629', '3617', '448', '450', '452', '3588', '5966', '5967', '5016', '5017', '5018', '3614', '4202', '4206', '4225', '5442', '5681', '5682', '2626', '3788', '5678', '2462', '2463', '2465', '4700', '4702', '4705', '4707', '4708', '4709', '4710', '4711', '4712', '4715', '4716', '4717', '4718', '4719', '4721', '4723', '4724', '4725', '4726', '4728', '4699', '5441', '5445') order by FIELD(id, 2378,2377,2280,2276,2279,2376,4600,2564,3168,2274,4599,1277,1278,1279,2278,2554,3178,2271,2423,2426,4597,4598,6569,901,3163,3185,6447,3171,904,1280,1281,2275,2789,2872,3265,6453,2736,3143,2785,3165,3740,2710,3148,2769,380,2751,123,125,3190,2702,2779,1282,1283,1284,2707,2738,3146,2713,2748,3274,2739,2778,2780,2206,2207,3161,3162,2735,2777,2374,2711,2783,2708,2709,3170,2744,2784,2718,2770,2551,2786,2714,2743,2773,2787,2703,884,2208,2767,2776,2725,2272,2273,2715,2749,2722,2721,2747,2705,2647,2782,6562,6563,6565,6566,6567,6568,6570,2425,6520,2704,1192,1194,2706,3172,2764,1191,1195,2745,2741,2733,2774,1196,6564,6571,1201,2731,2742,3278,1197,1198,2757,2762,2549,2716,2752,2753,2723,892,3910,3911,1691,2369,2373,2720,3261,6572,455,4651,4652,4655,2755,2756,2724,2746,2649,2650,2651,3781,2758,2734,2368,2370,2371,2552,2553,2627,2727,2728,2729,2730,2726,3267,3279,4203,4658,4674,442,4653,4654,4656,2359,2522,2765,2372,2628,2629,3617,448,450,452,3588,5966,5967,5016,5017,5018,3614,4202,4206,4225,5442,5681,5682,2626,3788,5678,2462,2463,2465,4700,4702,4705,4707,4708,4709,4710,4711,4712,4715,4716,4717,4718,4719,4721,4723,4724,4725,4726,4728,4699,5441,5445) limit 20 offset 140
6.95mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_product_image` where `cad_product_image`.`deleted_at` is null and `cad_product_image`.`product_id` in ('3911', '1691', '2369', '2373', '2720', '3261', '6572', '455', '4651', '4652', '4655', '2755', '2756', '2724', '2746', '2649', '2650', '2651', '3781', '2758') order by `sequence` asc
2.68mssmp_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 ('3911', '1691', '2369', '2373', '2720', '3261', '6572', '455', '4651', '4652', '4655', '2755', '2756', '2724', '2746', '2649', '2650', '2651', '3781', '2758') 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
6.12mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_product` where `cad_product`.`deleted_at` is null and `cad_product`.`id` in ('2649', '2650', '2651', '3781', '3911', '2758', '2746', '2724', '2755', '2756', '4655', '455', '4652', '4651', '6572', '3261', '2720', '2373', '2369', '1691')
3.03mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_store` where `cad_store`.`deleted_at` is null and `cad_store`.`id` in ('186', '798', '1012', '795', '1100', '1141', '1549', '1583', '578', '2506')
2.19mssmp_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 ('3593', '3594', '3595', '4994', '5147', '3739', '3727', '3705', '3736', '3737', '6326', '649', '6323', '6322', '8600', '4393', '3701', '3212', '3208', '2403')
2.66mssmp_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 ('3911', '1691', '2369', '2373', '2720', '3261', '6572', '455', '4651', '4652', '4655', '2755', '2756', '2724', '2746', '2649', '2650', '2651', '3781', '2758')
4.47mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_store` where `cad_store`.`deleted_at` is null and `cad_store`.`id` in ('1583', '798', '1012', '795', '1141', '2506', '186', '578', '1100', '1549')
2.66mssmp_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` = '14' and `cad_category`.`deleted_at` is null) >= 1 and `status` = '1' order by `sequence` asc
3mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_category` where `cad_category`.`deleted_at` is null and `cad_category`.`id` = '2' limit 1
2.01mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_category` where `cad_category`.`deleted_at` is null and `cad_category`.`id` = '1' limit 1
1.32mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_category` where `cad_category`.`deleted_at` is null and `cad_category`.`id` is null limit 1
1.04mssmp_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.57mssmp_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` = '3911'
2.1mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '1583' and `cad_payment_recipient`.`store_id` is not null
1.69mssmp_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` = '1691'
2.14mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '798' and `cad_payment_recipient`.`store_id` is not null
1.13mssmp_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` = '2369'
1.3mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '1012' and `cad_payment_recipient`.`store_id` is not null
1.22mssmp_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` = '2373'
1.81mssmp_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.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` = '2720'
1.55mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '1141' and `cad_payment_recipient`.`store_id` is not null
1.1mssmp_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` = '3261'
1.89mssmp_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` = '6572'
1.86mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '2506' and `cad_payment_recipient`.`store_id` is not null
1.52mssmp_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` = '455'
1.1mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '186' 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` = '4651'
1.49mssmp_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.14mssmp_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` = '4652'
1.61mssmp_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` = '4655'
1.97mssmp_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` = '2755'
1.55mssmp_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` = '2756'
1.77mssmp_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` = '2724'
1.39mssmp_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` = '2746'
1.78mssmp_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` = '2649'
1.6mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '1100' and `cad_payment_recipient`.`store_id` is not null
3.86mssmp_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` = '2650'
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` = '2651'
1.91mssmp_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` = '3781'
1.54mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '1549' and `cad_payment_recipient`.`store_id` is not null
1.38mssmp_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` = '2758'
1.63mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` = 'cssEditor' and `attribute` = '' limit 1
1.58mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` not like 'cssEditor'
1.31mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_social_media` where `status` = '1' order by `sequence` asc
1.15mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_menu_items` where `cad_menu_items`.`deleted_at` is null and `active` = '1'
1.39mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_social_media` where `status` = '1' order by `sequence` asc
1.4mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` not like 'cssEditor'
1.26mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` not like 'cssEditor'
1.45mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|