ou até 10x de R$ 48,82 (com juros)
ou até 10x de R$ 48,82 (com juros)
ou até 10x de R$ 48,82 (com juros)
ou até 10x de R$ 48,82 (com juros)
ou até 10x de R$ 48,82 (com juros)
ou até 10x de R$ 48,82 (com juros)
ou até 10x de R$ 48,82 (com juros)
ou até 10x de R$ 48,82 (com juros)
ou até 10x de R$ 48,66 (com juros)
ou até 6x de R$ 41,10 (com juros)
ou até 10x de R$ 46,87 (com juros)
ou até 10x de R$ 45,57 (com juros)
ou até 10x de R$ 44,75 (com juros)
ou até 10x de R$ 42,31 (com juros)
ou até 10x de R$ 40,69 (com juros)
ou até 10x de R$ 40,69 (com juros)
ou até 10x de R$ 40,69 (com juros)
ou até 10x de R$ 40,69 (com juros)
ou até 10x de R$ 40,69 (com juros)
ou até 10x de R$ 40,69 (com juros)
ou até 6x de R$ 40,18 (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 |
|
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 |
|
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` = 'servicos' and `status` = '1' order by `sequence` asc limit 1
2.6mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_category` where `cad_category`.`deleted_at` is null and `cad_category`.`parent_id` in ('4') order by `sequence` asc
2.07mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_category` where `cad_category`.`deleted_at` is null and `cad_category`.`parent_id` in ('19', '20', '21', '35', '106', '109', '110', '113', '114', '115', '116', '120', '121', '122', '123', '129', '130', '131', '132', '143', '165') order by `sequence` asc
1.61mssmp_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` = '4' and `cad_category`.`deleted_at` is null) >= 1 and `status` <> '0' order by `created_at` desc
2.03mssmp_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 ('4') 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 = 4 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
102.88mssmp_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 ('3449', '4371', '4792', '3632', '3634', '5762', '6088', '5195', '5687', '4649', '5618', '5220', '349', '5221', '5740', '5587', '5226', '5229', '3999', '2113', '484', '5735', '4703', '4889', '3604', '4442', '594', '5219', '5222', '5611', '2898', '3998', '5986', '996', '4328', '4701', '5196', '5223', '5228', '5230', '5035', '3997', '5404', '2302', '4232', '5697', '2103', '2101', '6041', '2267', '4458', '5192', '5227', '907', '737', '4000', '1237', '1784', '4891', '5926', '6033', '1766', '2896', '5698', '5972', '485', '2587', '736', '363', '5619', '712', '3240', '3244', '4451', '5650', '6053', '2496', '1954', '368', '665', '2086', '3040', '4205', '4667', '4771', '5217', '5794', '5795', '5905', '2451', '4751', '1965', '1186', '1602', '282', '1203', '1458', '3410', '3641', '5610', '5620', '940', '1963', '2495', '1964', '1955', '1238', '1274', '3139', '3431', '3492', '3506', '3557', '3677', '3975', '5176', '5216', '5628', '5796', '5797', '5798', '5800', '5802', '4364', '3310', '876', '1962', '4752', '802', '1617', '2175', '3558', '3912', '3913', '915', '1951', '3372', '2538', '1846', '288', '911', '2073', '3041', '3272', '3273', '3505', '3705', '5629', '4363', '1486', '615', '414', '1601', '4694', '535', '537', '593', '912', '3249', '3582', '2494', '1543', '4361', '6040', '111', '112', '160', '396', '417', '914', '2303', '3583', '3706', '5218', '5239', '5810', '985', '4001', '3752', '5369', '2681', '3237', '6099', '4285', '109', '595', '2076', '3231', '3666', '1806', '5924', '656', '1542', '1950', '2383', '3668', '3712', '5784', '5801', '3390', '4362', '1818', '3229', '1407', '2928', '5870', '559', '864', '1967', '5458', '6102', '834', '972', '987', '2373', '3080', '2930', '1771', '2929', '2077', '2519', '6108', '5206', '5207', '5799', '6100', '6101', '3472', '6260', '6470', '5873', '917', '862', '3226', '3227') and `cad_product`.`deleted_at` is null) >= 1 and `status` = '1'
62.11mssmp_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 ('3449', '4371', '4792', '3632', '3634', '5762', '6088', '5195', '5687', '4649', '5618', '5220', '349', '5221', '5740', '5587', '5226', '5229', '3999', '2113', '484', '5735', '4703', '4889', '3604', '4442', '594', '5219', '5222', '5611', '2898', '3998', '5986', '996', '4328', '4701', '5196', '5223', '5228', '5230', '5035', '3997', '5404', '2302', '4232', '5697', '2103', '2101', '6041', '2267', '4458', '5192', '5227', '907', '737', '4000', '1237', '1784', '4891', '5926', '6033', '1766', '2896', '5698', '5972', '485', '2587', '736', '363', '5619', '712', '3240', '3244', '4451', '5650', '6053', '2496', '1954', '368', '665', '2086', '3040', '4205', '4667', '4771', '5217', '5794', '5795', '5905', '2451', '4751', '1965', '1186', '1602', '282', '1203', '1458', '3410', '3641', '5610', '5620', '940', '1963', '2495', '1964', '1955', '1238', '1274', '3139', '3431', '3492', '3506', '3557', '3677', '3975', '5176', '5216', '5628', '5796', '5797', '5798', '5800', '5802', '4364', '3310', '876', '1962', '4752', '802', '1617', '2175', '3558', '3912', '3913', '915', '1951', '3372', '2538', '1846', '288', '911', '2073', '3041', '3272', '3273', '3505', '3705', '5629', '4363', '1486', '615', '414', '1601', '4694', '535', '537', '593', '912', '3249', '3582', '2494', '1543', '4361', '6040', '111', '112', '160', '396', '417', '914', '2303', '3583', '3706', '5218', '5239', '5810', '985', '4001', '3752', '5369', '2681', '3237', '6099', '4285', '109', '595', '2076', '3231', '3666', '1806', '5924', '656', '1542', '1950', '2383', '3668', '3712', '5784', '5801', '3390', '4362', '1818', '3229', '1407', '2928', '5870', '559', '864', '1967', '5458', '6102', '834', '972', '987', '2373', '3080', '2930', '1771', '2929', '2077', '2519', '6108', '5206', '5207', '5799', '6100', '6101', '3472', '6260', '6470', '5873', '917', '862', '3226', '3227') and `cad_product`.`deleted_at` is null) >= 1 order by `name` asc
5.21mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select exists(select * from `cad_product` where `cad_product`.`deleted_at` is null and `id` in ('3449', '4371', '4792', '3632', '3634', '5762', '6088', '5195', '5687', '4649', '5618', '5220', '349', '5221', '5740', '5587', '5226', '5229', '3999', '2113', '484', '5735', '4703', '4889', '3604', '4442', '594', '5219', '5222', '5611', '2898', '3998', '5986', '996', '4328', '4701', '5196', '5223', '5228', '5230', '5035', '3997', '5404', '2302', '4232', '5697', '2103', '2101', '6041', '2267', '4458', '5192', '5227', '907', '737', '4000', '1237', '1784', '4891', '5926', '6033', '1766', '2896', '5698', '5972', '485', '2587', '736', '363', '5619', '712', '3240', '3244', '4451', '5650', '6053', '2496', '1954', '368', '665', '2086', '3040', '4205', '4667', '4771', '5217', '5794', '5795', '5905', '2451', '4751', '1965', '1186', '1602', '282', '1203', '1458', '3410', '3641', '5610', '5620', '940', '1963', '2495', '1964', '1955', '1238', '1274', '3139', '3431', '3492', '3506', '3557', '3677', '3975', '5176', '5216', '5628', '5796', '5797', '5798', '5800', '5802', '4364', '3310', '876', '1962', '4752', '802', '1617', '2175', '3558', '3912', '3913', '915', '1951', '3372', '2538', '1846', '288', '911', '2073', '3041', '3272', '3273', '3505', '3705', '5629', '4363', '1486', '615', '414', '1601', '4694', '535', '537', '593', '912', '3249', '3582', '2494', '1543', '4361', '6040', '111', '112', '160', '396', '417', '914', '2303', '3583', '3706', '5218', '5239', '5810', '985', '4001', '3752', '5369', '2681', '3237', '6099', '4285', '109', '595', '2076', '3231', '3666', '1806', '5924', '656', '1542', '1950', '2383', '3668', '3712', '5784', '5801', '3390', '4362', '1818', '3229', '1407', '2928', '5870', '559', '864', '1967', '5458', '6102', '834', '972', '987', '2373', '3080', '2930', '1771', '2929', '2077', '2519', '6108', '5206', '5207', '5799', '6100', '6101', '3472', '6260', '6470', '5873', '917', '862', '3226', '3227') and (select count(*) from `cad_sku` where `cad_sku`.`product_id` = `cad_product`.`id` and `cad_sku`.`status` = '1' and (select count(*) from `cad_price_table_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and ((`wholesale` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2B', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1)) and `cad_price_table_sku`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1) as `exists`
3.66mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select exists(select * from `cad_product` where `cad_product`.`deleted_at` is null and `id` in ('3449', '4371', '4792', '3632', '3634', '5762', '6088', '5195', '5687', '4649', '5618', '5220', '349', '5221', '5740', '5587', '5226', '5229', '3999', '2113', '484', '5735', '4703', '4889', '3604', '4442', '594', '5219', '5222', '5611', '2898', '3998', '5986', '996', '4328', '4701', '5196', '5223', '5228', '5230', '5035', '3997', '5404', '2302', '4232', '5697', '2103', '2101', '6041', '2267', '4458', '5192', '5227', '907', '737', '4000', '1237', '1784', '4891', '5926', '6033', '1766', '2896', '5698', '5972', '485', '2587', '736', '363', '5619', '712', '3240', '3244', '4451', '5650', '6053', '2496', '1954', '368', '665', '2086', '3040', '4205', '4667', '4771', '5217', '5794', '5795', '5905', '2451', '4751', '1965', '1186', '1602', '282', '1203', '1458', '3410', '3641', '5610', '5620', '940', '1963', '2495', '1964', '1955', '1238', '1274', '3139', '3431', '3492', '3506', '3557', '3677', '3975', '5176', '5216', '5628', '5796', '5797', '5798', '5800', '5802', '4364', '3310', '876', '1962', '4752', '802', '1617', '2175', '3558', '3912', '3913', '915', '1951', '3372', '2538', '1846', '288', '911', '2073', '3041', '3272', '3273', '3505', '3705', '5629', '4363', '1486', '615', '414', '1601', '4694', '535', '537', '593', '912', '3249', '3582', '2494', '1543', '4361', '6040', '111', '112', '160', '396', '417', '914', '2303', '3583', '3706', '5218', '5239', '5810', '985', '4001', '3752', '5369', '2681', '3237', '6099', '4285', '109', '595', '2076', '3231', '3666', '1806', '5924', '656', '1542', '1950', '2383', '3668', '3712', '5784', '5801', '3390', '4362', '1818', '3229', '1407', '2928', '5870', '559', '864', '1967', '5458', '6102', '834', '972', '987', '2373', '3080', '2930', '1771', '2929', '2077', '2519', '6108', '5206', '5207', '5799', '6100', '6101', '3472', '6260', '6470', '5873', '917', '862', '3226', '3227') 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.03mssmp_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 ('3449', '4371', '4792', '3632', '3634', '5762', '6088', '5195', '5687', '4649', '5618', '5220', '349', '5221', '5740', '5587', '5226', '5229', '3999', '2113', '484', '5735', '4703', '4889', '3604', '4442', '594', '5219', '5222', '5611', '2898', '3998', '5986', '996', '4328', '4701', '5196', '5223', '5228', '5230', '5035', '3997', '5404', '2302', '4232', '5697', '2103', '2101', '6041', '2267', '4458', '5192', '5227', '907', '737', '4000', '1237', '1784', '4891', '5926', '6033', '1766', '2896', '5698', '5972', '485', '2587', '736', '363', '5619', '712', '3240', '3244', '4451', '5650', '6053', '2496', '1954', '368', '665', '2086', '3040', '4205', '4667', '4771', '5217', '5794', '5795', '5905', '2451', '4751', '1965', '1186', '1602', '282', '1203', '1458', '3410', '3641', '5610', '5620', '940', '1963', '2495', '1964', '1955', '1238', '1274', '3139', '3431', '3492', '3506', '3557', '3677', '3975', '5176', '5216', '5628', '5796', '5797', '5798', '5800', '5802', '4364', '3310', '876', '1962', '4752', '802', '1617', '2175', '3558', '3912', '3913', '915', '1951', '3372', '2538', '1846', '288', '911', '2073', '3041', '3272', '3273', '3505', '3705', '5629', '4363', '1486', '615', '414', '1601', '4694', '535', '537', '593', '912', '3249', '3582', '2494', '1543', '4361', '6040', '111', '112', '160', '396', '417', '914', '2303', '3583', '3706', '5218', '5239', '5810', '985', '4001', '3752', '5369', '2681', '3237', '6099', '4285', '109', '595', '2076', '3231', '3666', '1806', '5924', '656', '1542', '1950', '2383', '3668', '3712', '5784', '5801', '3390', '4362', '1818', '3229', '1407', '2928', '5870', '559', '864', '1967', '5458', '6102', '834', '972', '987', '2373', '3080', '2930', '1771', '2929', '2077', '2519', '6108', '5206', '5207', '5799', '6100', '6101', '3472', '6260', '6470', '5873', '917', '862', '3226', '3227') 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
45.56mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select `id`, `name` from `cad_variant` where `cad_variant`.`deleted_at` is null and `cad_variant`.`id` in ('188', '266', '499', '556', '570', '574', '745', '840', '1035', '1037', '1039', '1153')
1.95mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_attribute` where `cad_attribute`.`deleted_at` is null and (select count(*) from `cad_attribute` as `self_16e91ed3f15a4a6c77599e92844257e6` where `cad_attribute`.`deleted_at` is null and `self_16e91ed3f15a4a6c77599e92844257e6`.`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_16e91ed3f15a4a6c77599e92844257e6`.`id` and `product_id` in ('3449', '4371', '4792', '3632', '3634', '5762', '6088', '5195', '5687', '4649', '5618', '5220', '349', '5221', '5740', '5587', '5226', '5229', '3999', '2113', '484', '5735', '4703', '4889', '3604', '4442', '594', '5219', '5222', '5611', '2898', '3998', '5986', '996', '4328', '4701', '5196', '5223', '5228', '5230', '5035', '3997', '5404', '2302', '4232', '5697', '2103', '2101', '6041', '2267', '4458', '5192', '5227', '907', '737', '4000', '1237', '1784', '4891', '5926', '6033', '1766', '2896', '5698', '5972', '485', '2587', '736', '363', '5619', '712', '3240', '3244', '4451', '5650', '6053', '2496', '1954', '368', '665', '2086', '3040', '4205', '4667', '4771', '5217', '5794', '5795', '5905', '2451', '4751', '1965', '1186', '1602', '282', '1203', '1458', '3410', '3641', '5610', '5620', '940', '1963', '2495', '1964', '1955', '1238', '1274', '3139', '3431', '3492', '3506', '3557', '3677', '3975', '5176', '5216', '5628', '5796', '5797', '5798', '5800', '5802', '4364', '3310', '876', '1962', '4752', '802', '1617', '2175', '3558', '3912', '3913', '915', '1951', '3372', '2538', '1846', '288', '911', '2073', '3041', '3272', '3273', '3505', '3705', '5629', '4363', '1486', '615', '414', '1601', '4694', '535', '537', '593', '912', '3249', '3582', '2494', '1543', '4361', '6040', '111', '112', '160', '396', '417', '914', '2303', '3583', '3706', '5218', '5239', '5810', '985', '4001', '3752', '5369', '2681', '3237', '6099', '4285', '109', '595', '2076', '3231', '3666', '1806', '5924', '656', '1542', '1950', '2383', '3668', '3712', '5784', '5801', '3390', '4362', '1818', '3229', '1407', '2928', '5870', '559', '864', '1967', '5458', '6102', '834', '972', '987', '2373', '3080', '2930', '1771', '2929', '2077', '2519', '6108', '5206', '5207', '5799', '6100', '6101', '3472', '6260', '6470', '5873', '917', '862', '3226', '3227') 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.14mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select count(*) as aggregate from `cad_product` where `cad_product`.`deleted_at` is null and `id` in ('3449', '4371', '4792', '3632', '3634', '5762', '6088', '5195', '5687', '4649', '5618', '5220', '349', '5221', '5740', '5587', '5226', '5229', '3999', '2113', '484', '5735', '4703', '4889', '3604', '4442', '594', '5219', '5222', '5611', '2898', '3998', '5986', '996', '4328', '4701', '5196', '5223', '5228', '5230', '5035', '3997', '5404', '2302', '4232', '5697', '2103', '2101', '6041', '2267', '4458', '5192', '5227', '907', '737', '4000', '1237', '1784', '4891', '5926', '6033', '1766', '2896', '5698', '5972', '485', '2587', '736', '363', '5619', '712', '3240', '3244', '4451', '5650', '6053', '2496', '1954', '368', '665', '2086', '3040', '4205', '4667', '4771', '5217', '5794', '5795', '5905', '2451', '4751', '1965', '1186', '1602', '282', '1203', '1458', '3410', '3641', '5610', '5620', '940', '1963', '2495', '1964', '1955', '1238', '1274', '3139', '3431', '3492', '3506', '3557', '3677', '3975', '5176', '5216', '5628', '5796', '5797', '5798', '5800', '5802', '4364', '3310', '876', '1962', '4752', '802', '1617', '2175', '3558', '3912', '3913', '915', '1951', '3372', '2538', '1846', '288', '911', '2073', '3041', '3272', '3273', '3505', '3705', '5629', '4363', '1486', '615', '414', '1601', '4694', '535', '537', '593', '912', '3249', '3582', '2494', '1543', '4361', '6040', '111', '112', '160', '396', '417', '914', '2303', '3583', '3706', '5218', '5239', '5810', '985', '4001', '3752', '5369', '2681', '3237', '6099', '4285', '109', '595', '2076', '3231', '3666', '1806', '5924', '656', '1542', '1950', '2383', '3668', '3712', '5784', '5801', '3390', '4362', '1818', '3229', '1407', '2928', '5870', '559', '864', '1967', '5458', '6102', '834', '972', '987', '2373', '3080', '2930', '1771', '2929', '2077', '2519', '6108', '5206', '5207', '5799', '6100', '6101', '3472', '6260', '6470', '5873', '917', '862', '3226', '3227')
3.81mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_product` where `cad_product`.`deleted_at` is null and `id` in ('3449', '4371', '4792', '3632', '3634', '5762', '6088', '5195', '5687', '4649', '5618', '5220', '349', '5221', '5740', '5587', '5226', '5229', '3999', '2113', '484', '5735', '4703', '4889', '3604', '4442', '594', '5219', '5222', '5611', '2898', '3998', '5986', '996', '4328', '4701', '5196', '5223', '5228', '5230', '5035', '3997', '5404', '2302', '4232', '5697', '2103', '2101', '6041', '2267', '4458', '5192', '5227', '907', '737', '4000', '1237', '1784', '4891', '5926', '6033', '1766', '2896', '5698', '5972', '485', '2587', '736', '363', '5619', '712', '3240', '3244', '4451', '5650', '6053', '2496', '1954', '368', '665', '2086', '3040', '4205', '4667', '4771', '5217', '5794', '5795', '5905', '2451', '4751', '1965', '1186', '1602', '282', '1203', '1458', '3410', '3641', '5610', '5620', '940', '1963', '2495', '1964', '1955', '1238', '1274', '3139', '3431', '3492', '3506', '3557', '3677', '3975', '5176', '5216', '5628', '5796', '5797', '5798', '5800', '5802', '4364', '3310', '876', '1962', '4752', '802', '1617', '2175', '3558', '3912', '3913', '915', '1951', '3372', '2538', '1846', '288', '911', '2073', '3041', '3272', '3273', '3505', '3705', '5629', '4363', '1486', '615', '414', '1601', '4694', '535', '537', '593', '912', '3249', '3582', '2494', '1543', '4361', '6040', '111', '112', '160', '396', '417', '914', '2303', '3583', '3706', '5218', '5239', '5810', '985', '4001', '3752', '5369', '2681', '3237', '6099', '4285', '109', '595', '2076', '3231', '3666', '1806', '5924', '656', '1542', '1950', '2383', '3668', '3712', '5784', '5801', '3390', '4362', '1818', '3229', '1407', '2928', '5870', '559', '864', '1967', '5458', '6102', '834', '972', '987', '2373', '3080', '2930', '1771', '2929', '2077', '2519', '6108', '5206', '5207', '5799', '6100', '6101', '3472', '6260', '6470', '5873', '917', '862', '3226', '3227') order by FIELD(id, 3449,4371,4792,3632,3634,5762,6088,5195,5687,4649,5618,5220,349,5221,5740,5587,5226,5229,3999,2113,484,5735,4703,4889,3604,4442,594,5219,5222,5611,2898,3998,5986,996,4328,4701,5196,5223,5228,5230,5035,3997,5404,2302,4232,5697,2103,2101,6041,2267,4458,5192,5227,907,737,4000,1237,1784,4891,5926,6033,1766,2896,5698,5972,485,2587,736,363,5619,712,3240,3244,4451,5650,6053,2496,1954,368,665,2086,3040,4205,4667,4771,5217,5794,5795,5905,2451,4751,1965,1186,1602,282,1203,1458,3410,3641,5610,5620,940,1963,2495,1964,1955,1238,1274,3139,3431,3492,3506,3557,3677,3975,5176,5216,5628,5796,5797,5798,5800,5802,4364,3310,876,1962,4752,802,1617,2175,3558,3912,3913,915,1951,3372,2538,1846,288,911,2073,3041,3272,3273,3505,3705,5629,4363,1486,615,414,1601,4694,535,537,593,912,3249,3582,2494,1543,4361,6040,111,112,160,396,417,914,2303,3583,3706,5218,5239,5810,985,4001,3752,5369,2681,3237,6099,4285,109,595,2076,3231,3666,1806,5924,656,1542,1950,2383,3668,3712,5784,5801,3390,4362,1818,3229,1407,2928,5870,559,864,1967,5458,6102,834,972,987,2373,3080,2930,1771,2929,2077,2519,6108,5206,5207,5799,6100,6101,3472,6260,6470,5873,917,862,3226,3227) limit 20 offset 80
10.62mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_product_image` where `cad_product_image`.`deleted_at` is null and `cad_product_image`.`product_id` in ('2086', '3040', '4205', '4667', '4771', '5217', '5794', '5795', '5905', '2451', '4751', '1965', '1186', '1602', '282', '1203', '1458', '3410', '3641', '5610') order by `sequence` asc
4.57mssmp_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 ('2086', '3040', '4205', '4667', '4771', '5217', '5794', '5795', '5905', '2451', '4751', '1965', '1186', '1602', '282', '1203', '1458', '3410', '3641', '5610') 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
4.85mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_product` where `cad_product`.`deleted_at` is null and `cad_product`.`id` in ('5610', '1602', '2451', '5794', '4667', '282', '1203', '1458', '3410', '3641', '1186', '1965', '4751', '4205', '3040', '4771', '5217', '2086', '5795', '5905')
1.87mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_store` where `cad_store`.`deleted_at` is null and `cad_store`.`id` in ('132', '548', '92', '713', '678', '907', '1039', '971', '710', '1474', '1686', '1836', '1877', '1889', '2042', '2151', '2103')
1.87mssmp_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 ('7460', '2278', '3338', '7692', '6338', '378', '1516', '2065', '4571', '4844', '1495', '2708', '6427', '5571', '4071', '6447', '7010', '2883', '7693', '7805')
2.5mssmp_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 ('2086', '3040', '4205', '4667', '4771', '5217', '5794', '5795', '5905', '2451', '4751', '1965', '1186', '1602', '282', '1203', '1458', '3410', '3641', '5610')
3.06mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_store` where `cad_store`.`deleted_at` is null and `cad_store`.`id` in ('92', '971', '1686', '1836', '1889', '2042', '2103', '1039', '1877', '907', '548', '678', '132', '713', '710', '1474', '2151')
3.26mssmp_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` = '4' and `cad_category`.`deleted_at` is null) >= 1 and `status` = '1' order by `sequence` asc
3.45mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_category` where `cad_category`.`deleted_at` is null and `cad_category`.`id` is null limit 1
930μ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.15mssmp_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` = '2086'
1.46mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '92' and `cad_payment_recipient`.`store_id` is not null
1.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` = '3040'
1.3mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '971' and `cad_payment_recipient`.`store_id` is not null
1.4mssmp_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` = '4205'
1.18mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '1686' and `cad_payment_recipient`.`store_id` is not null
1.1mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '4667'
1.85mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '1836' and `cad_payment_recipient`.`store_id` is not null
1.45mssmp_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` = '4771'
1.39mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '1889' and `cad_payment_recipient`.`store_id` is not null
930μ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` = '5217'
1.56mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '2042' and `cad_payment_recipient`.`store_id` is not null
1.18mssmp_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` = '5794'
1.71mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '2103' and `cad_payment_recipient`.`store_id` is not null
1.48mssmp_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` = '5795'
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` = '5905'
1.79mssmp_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` = '2451'
1.48mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '1039' and `cad_payment_recipient`.`store_id` is not null
1.28mssmp_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` = '4751'
1.64mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '1877' and `cad_payment_recipient`.`store_id` is not null
1.57mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '1965'
1.47mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '907' and `cad_payment_recipient`.`store_id` is not null
1.14mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '1186'
1.68mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '548' 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` = '1602'
1.77mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '678' and `cad_payment_recipient`.`store_id` is not null
1.35mssmp_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` = '282'
1.51mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '132' and `cad_payment_recipient`.`store_id` is not null
1.46mssmp_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` = '1203'
1.87mssmp_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` = '1458'
1.57mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '713' and `cad_payment_recipient`.`store_id` is not null
1.27mssmp_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` = '3410'
1.9mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '710' and `cad_payment_recipient`.`store_id` is not null
1.62mssmp_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` = '3641'
1.66mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '1474' and `cad_payment_recipient`.`store_id` is not null
1.34mssmp_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` = '5610'
1.69mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '2151' and `cad_payment_recipient`.`store_id` is not null
1.17mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` = 'cssEditor' and `attribute` = '' limit 1
2.63mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` not like 'cssEditor'
1.42mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_social_media` where `status` = '1' order by `sequence` asc
2.77mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_menu_items` where `cad_menu_items`.`deleted_at` is null and `active` = '1'
2.43mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_social_media` where `status` = '1' order by `sequence` asc
1.14mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` not like 'cssEditor'
1.33mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` not like 'cssEditor'
1.15mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|