ou até 10x de R$ 89,84 (com juros)
ou até 10x de R$ 71,61 (com juros)
ou até 10x de R$ 48,82 (com juros)
ou até 10x de R$ 48,50 (com juros)
ou até 10x de R$ 46,87 (com juros)
ou até 10x de R$ 41,17 (com juros)
ou até 10x de R$ 41,17 (com juros)
ou até 10x de R$ 41,17 (com juros)
ou até 8x de R$ 40,95 (com juros)
ou até 7x de R$ 42,52 (com juros)
ou até 7x de R$ 41,06 (com juros)
ou até 5x de R$ 41,15 (com juros)
ou até 5x de R$ 40,62 (com juros)
ou até 4x de R$ 47,32 (com juros)
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 |
|
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 |
|
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` = 'casual' and `status` = '1' order by `sequence` asc limit 1
2.25mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_category` where `cad_category`.`deleted_at` is null and `cad_category`.`parent_id` in ('25') order by `sequence` asc
1.5mssmp_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` = '25' and `cad_category`.`deleted_at` is null) >= 1 and `status` <> '0' order by `created_at` desc
2.59mssmp_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 ('25') 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 = 25 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
117.99mssmp_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 ('2376', '3495', '2379', '1937', '2381', '6222', '430', '6224', '6226', '6227', '2052', '2554', '6221', '3141', '429', '4409', '3499', '2380', '2569', '6236', '2051', '4406', '4408', '2157', '3448', '3501', '6235', '3177', '5273', '4092', '4095', '2568', '3331', '2561', '2566', '6229', '6231', '6237', '4407', '4410', '6233', '6220', '605', '1707', '3330', '5267', '5268', '5269', '5270', '5271', '4091', '4094', '6225', '658', '663', '664', '6228', '86', '87', '88', '89', '90', '91', '2824', '2825', '3255', '5396', '2123', '3251', '4405', '4411', '6577', '6578', '6584', '2166', '2168', '3081', '3082', '5266', '5398', '2124', '4036', '6471', '6474', '6475', '6477', '6481', '6482', '6483', '6484', '2043', '2044', '2045', '5861', '5862', '5864', '5865', '5866', '5971', '5814', '5815', '5816', '5817', '5819', '5821', '5822', '5824', '5825', '5826', '5827', '5828', '5829', '5830', '5831', '5832', '5835', '5836', '5840', '5843', '5844', '5845', '5846', '5847', '5848', '5849', '5850', '5851', '5852', '5854', '5855', '5856', '5857', '5859', '5860', '5868', '5869', '5882', '5902', '5958', '5970', '6021', '6026', '6027', '6038', '6042', '6046', '6123', '6125', '6211', '6274', '6284', '6285', '6421', '6423', '6424', '6425', '6427', '6428', '6429', '6430', '6437', '6438', '6439', '6440', '6502', '6503', '6504', '6505', '6575', '6576', '6579', '6580', '6582', '6583', '5874', '5875', '5876', '5877', '5879', '5880', '5881', '5883', '5884', '5885', '5925', '5978', '6276', '6507', '6508', '6509', '6510', '6512', '6513', '6514', '6230', '2281', '6234', '2558', '5980', '2067', '2553', '4658', '4659', '4660', '4661', '4674', '4676', '4678', '4679') and `cad_product`.`deleted_at` is null) >= 1 and `status` = '1'
55.01mssmp_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 ('2376', '3495', '2379', '1937', '2381', '6222', '430', '6224', '6226', '6227', '2052', '2554', '6221', '3141', '429', '4409', '3499', '2380', '2569', '6236', '2051', '4406', '4408', '2157', '3448', '3501', '6235', '3177', '5273', '4092', '4095', '2568', '3331', '2561', '2566', '6229', '6231', '6237', '4407', '4410', '6233', '6220', '605', '1707', '3330', '5267', '5268', '5269', '5270', '5271', '4091', '4094', '6225', '658', '663', '664', '6228', '86', '87', '88', '89', '90', '91', '2824', '2825', '3255', '5396', '2123', '3251', '4405', '4411', '6577', '6578', '6584', '2166', '2168', '3081', '3082', '5266', '5398', '2124', '4036', '6471', '6474', '6475', '6477', '6481', '6482', '6483', '6484', '2043', '2044', '2045', '5861', '5862', '5864', '5865', '5866', '5971', '5814', '5815', '5816', '5817', '5819', '5821', '5822', '5824', '5825', '5826', '5827', '5828', '5829', '5830', '5831', '5832', '5835', '5836', '5840', '5843', '5844', '5845', '5846', '5847', '5848', '5849', '5850', '5851', '5852', '5854', '5855', '5856', '5857', '5859', '5860', '5868', '5869', '5882', '5902', '5958', '5970', '6021', '6026', '6027', '6038', '6042', '6046', '6123', '6125', '6211', '6274', '6284', '6285', '6421', '6423', '6424', '6425', '6427', '6428', '6429', '6430', '6437', '6438', '6439', '6440', '6502', '6503', '6504', '6505', '6575', '6576', '6579', '6580', '6582', '6583', '5874', '5875', '5876', '5877', '5879', '5880', '5881', '5883', '5884', '5885', '5925', '5978', '6276', '6507', '6508', '6509', '6510', '6512', '6513', '6514', '6230', '2281', '6234', '2558', '5980', '2067', '2553', '4658', '4659', '4660', '4661', '4674', '4676', '4678', '4679') and `cad_product`.`deleted_at` is null) >= 1 order by `name` asc
5.55mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select exists(select * from `cad_product` where `cad_product`.`deleted_at` is null and `id` in ('2376', '3495', '2379', '1937', '2381', '6222', '430', '6224', '6226', '6227', '2052', '2554', '6221', '3141', '429', '4409', '3499', '2380', '2569', '6236', '2051', '4406', '4408', '2157', '3448', '3501', '6235', '3177', '5273', '4092', '4095', '2568', '3331', '2561', '2566', '6229', '6231', '6237', '4407', '4410', '6233', '6220', '605', '1707', '3330', '5267', '5268', '5269', '5270', '5271', '4091', '4094', '6225', '658', '663', '664', '6228', '86', '87', '88', '89', '90', '91', '2824', '2825', '3255', '5396', '2123', '3251', '4405', '4411', '6577', '6578', '6584', '2166', '2168', '3081', '3082', '5266', '5398', '2124', '4036', '6471', '6474', '6475', '6477', '6481', '6482', '6483', '6484', '2043', '2044', '2045', '5861', '5862', '5864', '5865', '5866', '5971', '5814', '5815', '5816', '5817', '5819', '5821', '5822', '5824', '5825', '5826', '5827', '5828', '5829', '5830', '5831', '5832', '5835', '5836', '5840', '5843', '5844', '5845', '5846', '5847', '5848', '5849', '5850', '5851', '5852', '5854', '5855', '5856', '5857', '5859', '5860', '5868', '5869', '5882', '5902', '5958', '5970', '6021', '6026', '6027', '6038', '6042', '6046', '6123', '6125', '6211', '6274', '6284', '6285', '6421', '6423', '6424', '6425', '6427', '6428', '6429', '6430', '6437', '6438', '6439', '6440', '6502', '6503', '6504', '6505', '6575', '6576', '6579', '6580', '6582', '6583', '5874', '5875', '5876', '5877', '5879', '5880', '5881', '5883', '5884', '5885', '5925', '5978', '6276', '6507', '6508', '6509', '6510', '6512', '6513', '6514', '6230', '2281', '6234', '2558', '5980', '2067', '2553', '4658', '4659', '4660', '4661', '4674', '4676', '4678', '4679') 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`
8.48mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select exists(select * from `cad_product` where `cad_product`.`deleted_at` is null and `id` in ('2376', '3495', '2379', '1937', '2381', '6222', '430', '6224', '6226', '6227', '2052', '2554', '6221', '3141', '429', '4409', '3499', '2380', '2569', '6236', '2051', '4406', '4408', '2157', '3448', '3501', '6235', '3177', '5273', '4092', '4095', '2568', '3331', '2561', '2566', '6229', '6231', '6237', '4407', '4410', '6233', '6220', '605', '1707', '3330', '5267', '5268', '5269', '5270', '5271', '4091', '4094', '6225', '658', '663', '664', '6228', '86', '87', '88', '89', '90', '91', '2824', '2825', '3255', '5396', '2123', '3251', '4405', '4411', '6577', '6578', '6584', '2166', '2168', '3081', '3082', '5266', '5398', '2124', '4036', '6471', '6474', '6475', '6477', '6481', '6482', '6483', '6484', '2043', '2044', '2045', '5861', '5862', '5864', '5865', '5866', '5971', '5814', '5815', '5816', '5817', '5819', '5821', '5822', '5824', '5825', '5826', '5827', '5828', '5829', '5830', '5831', '5832', '5835', '5836', '5840', '5843', '5844', '5845', '5846', '5847', '5848', '5849', '5850', '5851', '5852', '5854', '5855', '5856', '5857', '5859', '5860', '5868', '5869', '5882', '5902', '5958', '5970', '6021', '6026', '6027', '6038', '6042', '6046', '6123', '6125', '6211', '6274', '6284', '6285', '6421', '6423', '6424', '6425', '6427', '6428', '6429', '6430', '6437', '6438', '6439', '6440', '6502', '6503', '6504', '6505', '6575', '6576', '6579', '6580', '6582', '6583', '5874', '5875', '5876', '5877', '5879', '5880', '5881', '5883', '5884', '5885', '5925', '5978', '6276', '6507', '6508', '6509', '6510', '6512', '6513', '6514', '6230', '2281', '6234', '2558', '5980', '2067', '2553', '4658', '4659', '4660', '4661', '4674', '4676', '4678', '4679') and (select count(*) from `cad_sku` where `cad_sku`.`product_id` = `cad_product`.`id` and `cad_sku`.`status` = '1' and (select count(*) from `cad_price_table_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and ((`retail` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2C', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1)) and `cad_price_table_sku`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1) as `exists`
2.76mssmp_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 ('2376', '3495', '2379', '1937', '2381', '6222', '430', '6224', '6226', '6227', '2052', '2554', '6221', '3141', '429', '4409', '3499', '2380', '2569', '6236', '2051', '4406', '4408', '2157', '3448', '3501', '6235', '3177', '5273', '4092', '4095', '2568', '3331', '2561', '2566', '6229', '6231', '6237', '4407', '4410', '6233', '6220', '605', '1707', '3330', '5267', '5268', '5269', '5270', '5271', '4091', '4094', '6225', '658', '663', '664', '6228', '86', '87', '88', '89', '90', '91', '2824', '2825', '3255', '5396', '2123', '3251', '4405', '4411', '6577', '6578', '6584', '2166', '2168', '3081', '3082', '5266', '5398', '2124', '4036', '6471', '6474', '6475', '6477', '6481', '6482', '6483', '6484', '2043', '2044', '2045', '5861', '5862', '5864', '5865', '5866', '5971', '5814', '5815', '5816', '5817', '5819', '5821', '5822', '5824', '5825', '5826', '5827', '5828', '5829', '5830', '5831', '5832', '5835', '5836', '5840', '5843', '5844', '5845', '5846', '5847', '5848', '5849', '5850', '5851', '5852', '5854', '5855', '5856', '5857', '5859', '5860', '5868', '5869', '5882', '5902', '5958', '5970', '6021', '6026', '6027', '6038', '6042', '6046', '6123', '6125', '6211', '6274', '6284', '6285', '6421', '6423', '6424', '6425', '6427', '6428', '6429', '6430', '6437', '6438', '6439', '6440', '6502', '6503', '6504', '6505', '6575', '6576', '6579', '6580', '6582', '6583', '5874', '5875', '5876', '5877', '5879', '5880', '5881', '5883', '5884', '5885', '5925', '5978', '6276', '6507', '6508', '6509', '6510', '6512', '6513', '6514', '6230', '2281', '6234', '2558', '5980', '2067', '2553', '4658', '4659', '4660', '4661', '4674', '4676', '4678', '4679') 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.97mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select `id`, `name` from `cad_variant` where `cad_variant`.`deleted_at` is null and `cad_variant`.`id` in ('1', '6', '8', '14', '562', '620', '254', '11', '637', '556', '1002')
1.39mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_attribute` where `cad_attribute`.`deleted_at` is null and (select count(*) from `cad_attribute` as `self_9358ffec03085f7ce35012aba7761c2a` where `cad_attribute`.`deleted_at` is null and `self_9358ffec03085f7ce35012aba7761c2a`.`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_9358ffec03085f7ce35012aba7761c2a`.`id` and `product_id` in ('2376', '3495', '2379', '1937', '2381', '6222', '430', '6224', '6226', '6227', '2052', '2554', '6221', '3141', '429', '4409', '3499', '2380', '2569', '6236', '2051', '4406', '4408', '2157', '3448', '3501', '6235', '3177', '5273', '4092', '4095', '2568', '3331', '2561', '2566', '6229', '6231', '6237', '4407', '4410', '6233', '6220', '605', '1707', '3330', '5267', '5268', '5269', '5270', '5271', '4091', '4094', '6225', '658', '663', '664', '6228', '86', '87', '88', '89', '90', '91', '2824', '2825', '3255', '5396', '2123', '3251', '4405', '4411', '6577', '6578', '6584', '2166', '2168', '3081', '3082', '5266', '5398', '2124', '4036', '6471', '6474', '6475', '6477', '6481', '6482', '6483', '6484', '2043', '2044', '2045', '5861', '5862', '5864', '5865', '5866', '5971', '5814', '5815', '5816', '5817', '5819', '5821', '5822', '5824', '5825', '5826', '5827', '5828', '5829', '5830', '5831', '5832', '5835', '5836', '5840', '5843', '5844', '5845', '5846', '5847', '5848', '5849', '5850', '5851', '5852', '5854', '5855', '5856', '5857', '5859', '5860', '5868', '5869', '5882', '5902', '5958', '5970', '6021', '6026', '6027', '6038', '6042', '6046', '6123', '6125', '6211', '6274', '6284', '6285', '6421', '6423', '6424', '6425', '6427', '6428', '6429', '6430', '6437', '6438', '6439', '6440', '6502', '6503', '6504', '6505', '6575', '6576', '6579', '6580', '6582', '6583', '5874', '5875', '5876', '5877', '5879', '5880', '5881', '5883', '5884', '5885', '5925', '5978', '6276', '6507', '6508', '6509', '6510', '6512', '6513', '6514', '6230', '2281', '6234', '2558', '5980', '2067', '2553', '4658', '4659', '4660', '4661', '4674', '4676', '4678', '4679') 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
4.23mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select count(*) as aggregate from `cad_product` where `cad_product`.`deleted_at` is null and `id` in ('2376', '3495', '2379', '1937', '2381', '6222', '430', '6224', '6226', '6227', '2052', '2554', '6221', '3141', '429', '4409', '3499', '2380', '2569', '6236', '2051', '4406', '4408', '2157', '3448', '3501', '6235', '3177', '5273', '4092', '4095', '2568', '3331', '2561', '2566', '6229', '6231', '6237', '4407', '4410', '6233', '6220', '605', '1707', '3330', '5267', '5268', '5269', '5270', '5271', '4091', '4094', '6225', '658', '663', '664', '6228', '86', '87', '88', '89', '90', '91', '2824', '2825', '3255', '5396', '2123', '3251', '4405', '4411', '6577', '6578', '6584', '2166', '2168', '3081', '3082', '5266', '5398', '2124', '4036', '6471', '6474', '6475', '6477', '6481', '6482', '6483', '6484', '2043', '2044', '2045', '5861', '5862', '5864', '5865', '5866', '5971', '5814', '5815', '5816', '5817', '5819', '5821', '5822', '5824', '5825', '5826', '5827', '5828', '5829', '5830', '5831', '5832', '5835', '5836', '5840', '5843', '5844', '5845', '5846', '5847', '5848', '5849', '5850', '5851', '5852', '5854', '5855', '5856', '5857', '5859', '5860', '5868', '5869', '5882', '5902', '5958', '5970', '6021', '6026', '6027', '6038', '6042', '6046', '6123', '6125', '6211', '6274', '6284', '6285', '6421', '6423', '6424', '6425', '6427', '6428', '6429', '6430', '6437', '6438', '6439', '6440', '6502', '6503', '6504', '6505', '6575', '6576', '6579', '6580', '6582', '6583', '5874', '5875', '5876', '5877', '5879', '5880', '5881', '5883', '5884', '5885', '5925', '5978', '6276', '6507', '6508', '6509', '6510', '6512', '6513', '6514', '6230', '2281', '6234', '2558', '5980', '2067', '2553', '4658', '4659', '4660', '4661', '4674', '4676', '4678', '4679')
2.49mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_product` where `cad_product`.`deleted_at` is null and `id` in ('2376', '3495', '2379', '1937', '2381', '6222', '430', '6224', '6226', '6227', '2052', '2554', '6221', '3141', '429', '4409', '3499', '2380', '2569', '6236', '2051', '4406', '4408', '2157', '3448', '3501', '6235', '3177', '5273', '4092', '4095', '2568', '3331', '2561', '2566', '6229', '6231', '6237', '4407', '4410', '6233', '6220', '605', '1707', '3330', '5267', '5268', '5269', '5270', '5271', '4091', '4094', '6225', '658', '663', '664', '6228', '86', '87', '88', '89', '90', '91', '2824', '2825', '3255', '5396', '2123', '3251', '4405', '4411', '6577', '6578', '6584', '2166', '2168', '3081', '3082', '5266', '5398', '2124', '4036', '6471', '6474', '6475', '6477', '6481', '6482', '6483', '6484', '2043', '2044', '2045', '5861', '5862', '5864', '5865', '5866', '5971', '5814', '5815', '5816', '5817', '5819', '5821', '5822', '5824', '5825', '5826', '5827', '5828', '5829', '5830', '5831', '5832', '5835', '5836', '5840', '5843', '5844', '5845', '5846', '5847', '5848', '5849', '5850', '5851', '5852', '5854', '5855', '5856', '5857', '5859', '5860', '5868', '5869', '5882', '5902', '5958', '5970', '6021', '6026', '6027', '6038', '6042', '6046', '6123', '6125', '6211', '6274', '6284', '6285', '6421', '6423', '6424', '6425', '6427', '6428', '6429', '6430', '6437', '6438', '6439', '6440', '6502', '6503', '6504', '6505', '6575', '6576', '6579', '6580', '6582', '6583', '5874', '5875', '5876', '5877', '5879', '5880', '5881', '5883', '5884', '5885', '5925', '5978', '6276', '6507', '6508', '6509', '6510', '6512', '6513', '6514', '6230', '2281', '6234', '2558', '5980', '2067', '2553', '4658', '4659', '4660', '4661', '4674', '4676', '4678', '4679') order by FIELD(id, 2376,3495,2379,1937,2381,6222,430,6224,6226,6227,2052,2554,6221,3141,429,4409,3499,2380,2569,6236,2051,4406,4408,2157,3448,3501,6235,3177,5273,4092,4095,2568,3331,2561,2566,6229,6231,6237,4407,4410,6233,6220,605,1707,3330,5267,5268,5269,5270,5271,4091,4094,6225,658,663,664,6228,86,87,88,89,90,91,2824,2825,3255,5396,2123,3251,4405,4411,6577,6578,6584,2166,2168,3081,3082,5266,5398,2124,4036,6471,6474,6475,6477,6481,6482,6483,6484,2043,2044,2045,5861,5862,5864,5865,5866,5971,5814,5815,5816,5817,5819,5821,5822,5824,5825,5826,5827,5828,5829,5830,5831,5832,5835,5836,5840,5843,5844,5845,5846,5847,5848,5849,5850,5851,5852,5854,5855,5856,5857,5859,5860,5868,5869,5882,5902,5958,5970,6021,6026,6027,6038,6042,6046,6123,6125,6211,6274,6284,6285,6421,6423,6424,6425,6427,6428,6429,6430,6437,6438,6439,6440,6502,6503,6504,6505,6575,6576,6579,6580,6582,6583,5874,5875,5876,5877,5879,5880,5881,5883,5884,5885,5925,5978,6276,6507,6508,6509,6510,6512,6513,6514,6230,2281,6234,2558,5980,2067,2553,4658,4659,4660,4661,4674,4676,4678,4679) limit 20 offset 0
5.51mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_product_image` where `cad_product_image`.`deleted_at` is null and `cad_product_image`.`product_id` in ('2376', '3495', '2379', '1937', '2381', '6222', '430', '6224', '6226', '6227', '2052', '2554', '6221', '3141', '429', '4409', '3499', '2380', '2569', '6236') order by `sequence` asc
3.54mssmp_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 ('2376', '3495', '2379', '1937', '2381', '6222', '430', '6224', '6226', '6227', '2052', '2554', '6221', '3141', '429', '4409', '3499', '2380', '2569', '6236') 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
5.79mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_product` where `cad_product`.`deleted_at` is null and `cad_product`.`id` in ('2554', '6236', '2569', '2380', '3499', '4409', '429', '3141', '6221', '2052', '6224', '6226', '6227', '430', '6222', '2381', '1937', '2379', '3495', '2376')
2mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_store` where `cad_store`.`deleted_at` is null and `cad_store`.`id` in ('176', '841', '229', '795', '1105', '1729', '2368')
1.41mssmp_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 ('3482', '3483', '8172', '3508', '3228', '4671', '5990', '5989', '5988', '5987', '620', '4225', '8157', '3481', '2827', '2825', '2826', '2828', '8160', '8162', '8163', '621', '8158', '3229', '2680', '3227', '4661', '3218')
2.17mssmp_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 ('2376', '3495', '2379', '1937', '2381', '6222', '430', '6224', '6226', '6227', '2052', '2554', '6221', '3141', '429', '4409', '3499', '2380', '2569', '6236')
3.91mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_store` where `cad_store`.`deleted_at` is null and `cad_store`.`id` in ('795', '841', '2368', '176', '229', '1105', '1729')
1.84mssmp_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` = '25' and `cad_category`.`deleted_at` is null) >= 1 and `status` = '1' order by `sequence` asc
3.79mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_category` where `cad_category`.`deleted_at` is null and `cad_category`.`id` = '1' limit 1
1mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_category` where `cad_category`.`deleted_at` is null and `cad_category`.`id` is null limit 1
730μssmp_mercadoblackmoneyMetadata | |
---|---|
Hints |
|
select * from `cad_payment_installment_settings` where `cad_payment_installment_settings`.`deleted_at` is null and `cad_payment_installment_settings`.`id` = '3' limit 1
2.79mssmp_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` = '2376'
1.06mssmp_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.6mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '3495'
1.49mssmp_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` = '2379'
1.64mssmp_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` = '1937'
1.16mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '841' and `cad_payment_recipient`.`store_id` is not null
960μ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` = '2381'
1.54mssmp_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` = '6222'
1.61mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '2368' and `cad_payment_recipient`.`store_id` is not null
1.23mssmp_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` = '430'
1.83mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '176' 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` = '6224'
1.27mssmp_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` = '6226'
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` = '6227'
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` = '2052'
1.18mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '229' 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` = '2554'
1.85mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '6221'
1.4mssmp_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` = '3141'
2.48mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '1105' and `cad_payment_recipient`.`store_id` is not null
1.53mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '429'
1.85mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '4409'
2mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '1729' 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` = '3499'
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` = '2380'
2.19mssmp_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` = '2569'
1.72mssmp_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` = '6236'
1.61mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` = 'cssEditor' and `attribute` = '' limit 1
1.87mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` not like 'cssEditor'
710μssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_social_media` where `status` = '1' order by `sequence` asc
1.88mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_menu_items` where `cad_menu_items`.`deleted_at` is null and `active` = '1'
2.49mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_social_media` where `status` = '1' order by `sequence` asc
1.22mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` not like 'cssEditor'
1.07mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` not like 'cssEditor'
1.04mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|