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.13mssmp_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.08mssmp_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
4.61mssmp_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
116.07mssmp_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'
48.36mssmp_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
3.15mssmp_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`
10.27mssmp_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`
4.07mssmp_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
56.23mssmp_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.32mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_attribute` where `cad_attribute`.`deleted_at` is null and (select count(*) from `cad_attribute` as `self_d68059b7acf0cab621f94ab8ad13e554` where `cad_attribute`.`deleted_at` is null and `self_d68059b7acf0cab621f94ab8ad13e554`.`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_d68059b7acf0cab621f94ab8ad13e554`.`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
5.97mssmp_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.91mssmp_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 140
8.76mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_product_image` where `cad_product_image`.`deleted_at` is null and `cad_product_image`.`product_id` in ('6021', '6026', '6027', '6038', '6042', '6046', '6123', '6125', '6211', '6274', '6284', '6285', '6421', '6423', '6424', '6425', '6427', '6428', '6429', '6430') order by `sequence` asc
2.09mssmp_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 ('6021', '6026', '6027', '6038', '6042', '6046', '6123', '6125', '6211', '6274', '6284', '6285', '6421', '6423', '6424', '6425', '6427', '6428', '6429', '6430') and `cad_sku`.`status` = '1' and `stock` > '0' and `cad_sku`.`status` = '1' and (select count(*) from `cad_price_table_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and ((`retail` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2C', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1) or (`wholesale` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2B', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1)) and `cad_price_table_sku`.`deleted_at` is null) >= 1 order by
cad_price_table_sku.retail = 0, cad_price_table_sku.wholesale = 0,
CASE
WHEN (cad_store.business_model = "B2C" AND cad_price_table_sku.sale_retail > 0)
THEN cad_price_table_sku.sale_retail
WHEN (cad_store.business_model = "B2C" AND cad_price_table_sku.sale_retail <= 0)
THEN cad_price_table_sku.retail
WHEN (cad_store.business_model = "B2B" AND cad_price_table_sku.sale_wholesale > 0)
THEN cad_price_table_sku.sale_wholesale
WHEN (cad_store.business_model = "B2B" AND cad_price_table_sku.sale_wholesale <= 0)
THEN cad_price_table_sku.wholesale
WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_retail > 0)
THEN cad_price_table_sku.sale_retail
WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_retail <= 0 AND cad_price_table_sku.retail > 0)
THEN cad_price_table_sku.retail
WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_wholesale > 0)
THEN cad_price_table_sku.sale_wholesale
WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_wholesale <= 0 AND cad_price_table_sku.wholesale > 0)
THEN cad_price_table_sku.wholesale
END
asc
3.92mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_product` where `cad_product`.`deleted_at` is null and `cad_product`.`id` in ('6284', '6430', '6429', '6428', '6427', '6425', '6424', '6423', '6421', '6285', '6021', '6274', '6211', '6125', '6123', '6046', '6042', '6038', '6027', '6026')
1.87mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_store` where `cad_store`.`deleted_at` is null and `cad_store`.`id` in ('2241')
1.31mssmp_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 ('8222', '8452', '8451', '8450', '8449', '8447', '8446', '8445', '8443', '8223', '7932', '8212', '8147', '8055', '8053', '7960', '7956', '7952', '7938', '7937')
1.55mssmp_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 ('6021', '6026', '6027', '6038', '6042', '6046', '6123', '6125', '6211', '6274', '6284', '6285', '6421', '6423', '6424', '6425', '6427', '6428', '6429', '6430')
3.15mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_store` where `cad_store`.`deleted_at` is null and `cad_store`.`id` in ('2241')
1.43mssmp_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
5.58mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_category` where `cad_category`.`deleted_at` is null and `cad_category`.`id` = '1' limit 1
1.3mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_category` where `cad_category`.`deleted_at` is null and `cad_category`.`id` is null limit 1
900μssmp_mercadoblackmoneyMetadata | |
---|---|
Hints |
|
select * from `cad_payment_installment_settings` where `cad_payment_installment_settings`.`deleted_at` is null and `cad_payment_installment_settings`.`id` = '3' limit 1
1.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` = '6021'
1.34mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '2241' and `cad_payment_recipient`.`store_id` is not null
3.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` = '6026'
1.41mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '6027'
2.41mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '6038'
1.63mssmp_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` = '6042'
1.62mssmp_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` = '6046'
1.51mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '6123'
1.18mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_product_image` where `cad_product_image`.`deleted_at` is null and `default` = '1' limit 1
4.43mssmp_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` = '6125'
1.03mssmp_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` = '6211'
1.13mssmp_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` = '6274'
1.16mssmp_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` = '6284'
1.51mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '6285'
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` = '6421'
1.37mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '6423'
1.58mssmp_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` = '6424'
1.43mssmp_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` = '6425'
1.37mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '6427'
1.51mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '6428'
1.93mssmp_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` = '6429'
1.58mssmp_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` = '6430'
1.9mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` = 'cssEditor' and `attribute` = '' limit 1
1mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` not like 'cssEditor'
1.13mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_social_media` where `status` = '1' order by `sequence` asc
1.12mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_menu_items` where `cad_menu_items`.`deleted_at` is null and `active` = '1'
1.14mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_social_media` where `status` = '1' order by `sequence` asc
1.24mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` not like 'cssEditor'
930μssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` not like 'cssEditor'
1.08mssmp_mercadoblackmoneyMetadata | |
---|---|
Bindings |
|
Hints |
|