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.16mssmp_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
1.5mssmp_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
2.27mssmp_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.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 ('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
110.26mssmp_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'
60.99mssmp_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.16mssmp_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.11mssmp_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
57.16mssmp_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.36mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_attribute` where `cad_attribute`.`deleted_at` is null and (select count(*) from `cad_attribute` as `self_9fc1f9f396691c44bf1afc61b6ec4d55` where `cad_attribute`.`deleted_at` is null and `self_9fc1f9f396691c44bf1afc61b6ec4d55`.`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_9fc1f9f396691c44bf1afc61b6ec4d55`.`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
7.43mssmp_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.5mssmp_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 200
8.96mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_product_image` where `cad_product_image`.`deleted_at` is null and `cad_product_image`.`product_id` in ('4225', '5442', '5681', '5682', '2626', '3788', '5678', '2462', '2463', '2465', '4700', '4702', '4705', '4707', '4708', '4709', '4710', '4711', '4712', '4715') order by `sequence` asc
1.98mssmp_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 ('4225', '5442', '5681', '5682', '2626', '3788', '5678', '2462', '2463', '2465', '4700', '4702', '4705', '4707', '4708', '4709', '4710', '4711', '4712', '4715') 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.68mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_product` where `cad_product`.`deleted_at` is null and `cad_product`.`id` in ('5678', '3788', '5682', '5681', '4708', '4715', '4712', '4711', '4710', '4709', '4707', '4705', '4702', '4700', '2462', '2465', '2463', '2626', '5442', '4225')
1.85mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_store` where `cad_store`.`deleted_at` is null and `cad_store`.`id` in ('1038', '1100', '1549', '1352', '1866', '2115', '781')
1.43mssmp_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 ('7528', '5001', '7532', '7531', '6380', '6387', '6384', '6383', '6382', '6381', '6379', '6377', '6374', '6372', '3349', '3352', '3350', '3570', '7274', '5594')
1.59mssmp_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 ('4225', '5442', '5681', '5682', '2626', '3788', '5678', '2462', '2463', '2465', '4700', '4702', '4705', '4707', '4708', '4709', '4710', '4711', '4712', '4715')
2.95mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_store` where `cad_store`.`deleted_at` is null and `cad_store`.`id` in ('1352', '2115', '781', '1100', '1549', '1038', '1866')
2.12mssmp_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
3.76mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_category` where `cad_category`.`deleted_at` is null and `cad_category`.`id` = '2' limit 1
1.19mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_category` where `cad_category`.`deleted_at` is null and `cad_category`.`id` = '1' limit 1
1.28mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_category` where `cad_category`.`deleted_at` is null and `cad_category`.`id` is null limit 1
3.98mssmp_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.71mssmp_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` = '4225'
1.78mssmp_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.33mssmp_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` = '5442'
1.88mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '2115' and `cad_payment_recipient`.`store_id` is not null
1.74mssmp_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` = '5681'
1.64mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '781' and `cad_payment_recipient`.`store_id` is not null
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` = '5682'
1.53mssmp_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` = '2626'
1.79mssmp_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
970μssmp_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` = '3788'
1.72mssmp_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.11mssmp_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` = '5678'
1.08mssmp_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` = '2462'
1.59mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '1038' and `cad_payment_recipient`.`store_id` is not null
1.08mssmp_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` = '2463'
1.57mssmp_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` = '2465'
1.37mssmp_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` = '4700'
1.67mssmp_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` = '4702'
1.69mssmp_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` = '4705'
1.53mssmp_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` = '4707'
1.23mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '1866' and `cad_payment_recipient`.`store_id` is not null
980μssmp_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` = '4708'
1.65mssmp_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` = '4709'
1.09mssmp_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` = '4710'
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` = '4711'
1.48mssmp_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` = '4712'
1.24mssmp_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` = '4715'
1.89mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` = 'cssEditor' and `attribute` = '' limit 1
1.27mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` not like 'cssEditor'
730μssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_social_media` where `status` = '1' order by `sequence` asc
1mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_menu_items` where `cad_menu_items`.`deleted_at` is null and `active` = '1'
980μssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_social_media` where `status` = '1' order by `sequence` asc
1.53mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` not like 'cssEditor'
920μssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` not like 'cssEditor'
930μssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|