Clearance
1 x Application (98.88%) | 1.31s |
1 x Booting (1.12%) | 14.76ms |
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 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
52 |
|
53 |
|
54 |
|
55 |
|
56 |
|
57 |
|
58 |
|
59 |
|
60 |
|
61 |
|
62 |
|
Params | |
---|---|
0 |
|
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 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
52 |
|
53 |
|
54 |
|
55 |
|
56 |
|
57 |
|
58 |
|
59 |
|
60 |
|
61 |
|
62 |
|
63 |
|
64 |
|
65 |
|
66 |
|
67 |
|
68 |
|
69 |
|
70 |
|
71 |
|
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 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
52 |
|
53 |
|
54 |
|
55 |
|
56 |
|
57 |
|
58 |
|
59 |
|
60 |
|
61 |
|
62 |
|
63 |
|
64 |
|
Params | |
---|---|
0 |
|
1 |
|
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 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
52 |
|
53 |
|
54 |
|
55 |
|
56 |
|
57 |
|
58 |
|
59 |
|
60 |
|
61 |
|
62 |
|
63 |
|
64 |
|
65 |
|
66 |
|
67 |
|
68 |
|
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 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
52 |
|
53 |
|
54 |
|
55 |
|
56 |
|
57 |
|
58 |
|
59 |
|
60 |
|
61 |
|
62 |
|
63 |
|
64 |
|
65 |
|
66 |
|
67 |
|
68 |
|
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 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
52 |
|
53 |
|
54 |
|
55 |
|
56 |
|
57 |
|
58 |
|
59 |
|
60 |
|
61 |
|
62 |
|
63 |
|
64 |
|
65 |
|
66 |
|
67 |
|
68 |
|
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 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
52 |
|
53 |
|
54 |
|
55 |
|
56 |
|
57 |
|
58 |
|
59 |
|
60 |
|
61 |
|
62 |
|
63 |
|
64 |
|
65 |
|
66 |
|
67 |
|
68 |
|
69 |
|
70 |
|
71 |
|
72 |
|
73 |
|
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 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
52 |
|
53 |
|
54 |
|
55 |
|
56 |
|
57 |
|
58 |
|
59 |
|
60 |
|
61 |
|
62 |
|
63 |
|
64 |
|
65 |
|
66 |
|
67 |
|
68 |
|
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 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
52 |
|
53 |
|
54 |
|
55 |
|
56 |
|
57 |
|
58 |
|
59 |
|
60 |
|
61 |
|
62 |
|
63 |
|
64 |
|
65 |
|
66 |
|
67 |
|
68 |
|
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 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
52 |
|
53 |
|
54 |
|
55 |
|
56 |
|
57 |
|
58 |
|
59 |
|
60 |
|
61 |
|
62 |
|
63 |
|
64 |
|
65 |
|
66 |
|
67 |
|
68 |
|
select * from `PR_Categories` where `parentId` is null and `slug` = 'roof-racks' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `parentId` = '5C2DD4F5-056B-4961-B309-A37BA1BC5A4E' and `slug` = 'roof-trays' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `parentId` = 'A421D742-61EB-43C9-978F-43AADD8F611B' and `slug` = 'pioneer-trays' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_CategorySpecifications` where `PR_CategorySpecifications`.`categoryId` = '11C9289D-BCE1-4CE6-AABB-BE2169E8302F' and `PR_CategorySpecifications`.`categoryId` is not null and `PR_CategorySpecifications`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Specifications` where `PR_Specifications`.`specificationId` in ('14F3FB81-8947-4E5E-BB23-2F17B1452EF2', '1A76CA3F-315C-4EA6-8002-E3B352C23337', '2148B1D3-F535-4E7C-939D-7FD62DFA2FFB', '2F7D1296-9A11-420C-99DA-0CF2BB9A62DD', '50F360E9-8C0F-437E-A879-5685BEFF3827', 'CE49416F-033B-4F79-A495-86DFDF9F4655') and `PR_Specifications`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_SpecificationProperties` where `PR_SpecificationProperties`.`specificationId` in ('14F3FB81-8947-4E5E-BB23-2F17B1452EF2', '1A76CA3F-315C-4EA6-8002-E3B352C23337', '2148B1D3-F535-4E7C-939D-7FD62DFA2FFB', '2F7D1296-9A11-420C-99DA-0CF2BB9A62DD', '50F360E9-8C0F-437E-A879-5685BEFF3827', 'CE49416F-033B-4F79-A495-86DFDF9F4655') and `PR_SpecificationProperties`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_SpecificationPropertyMasterData` where `PR_SpecificationPropertyMasterData`.`specificationPropertyId` in ('0754223D-333A-4880-B62B-EED1492A023E', '38A9EC0F-41EE-4B46-B03D-5F1B91922988', '3D70412C-100B-4FBD-9E2A-3195E8C38509', '40A339D4-C734-41BE-A9F5-7540C347B360', '7FF6FD81-194A-4575-8110-DA21E2657100', '852775DC-8804-4D09-BF04-1D892D6D9915', '9B57FACA-1967-4CFA-833C-6F9578CFD249', '9EB49FBD-D3D3-428E-9C59-B4E355A0022D', 'CCFCEE3B-1E54-4876-953D-ACD9C9CAA8C7', 'D78F6505-9766-4732-A858-73785505B425') and `PR_SpecificationPropertyMasterData`.`deleted_at` is null order by `title` asc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `categoryId` = '11C9289D-BCE1-4CE6-AABB-BE2169E8302F' and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('02DFEAB4-B4A6-4491-94E4-CF38C0CB78A2', '06E7D881-897B-4943-872E-636B571D7B01', '0F37540D-0972-4652-89DE-71FFDE9188C5', '1390C8D6-7227-44DE-B035-56080E5754A9', '1870D8A9-EC9A-45F1-BFA7-BA9F2D8A46AC', '1FAB2BB8-5A3B-4F3E-9601-C2DE68BDBB14', '2A5E83A2-FDA8-4595-B43A-20FC8956E448', '2D295645-FAA2-45CB-99DE-1BB3AA55F932', '3CFD10BA-206E-4561-9C30-69C75CB3EEA1', '3F486988-F25E-4A09-B1EA-9281BC1D880C', '445589F9-F40D-4422-96E4-FAB5D4CC5153', '518CA1D1-88F9-4CF7-9BD9-C6C1E7035E7D', '629BFC45-F491-43B3-8048-EC685661A4F1', '66D02392-55CD-49EC-9AFF-15DC778A79C3', '68355F4C-5F34-4F72-A510-A14D62F3D36D', '6A34BD4E-E40B-432C-9C9A-89F0CBD84C2B', '73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '78F56B1E-11E1-4279-BA8B-1A73EB2309D3', '7D297319-F7DE-460D-AA80-1CC81D38DF69', '801FEEB5-4429-4550-BC7B-FA5983407CC6', '80B66C4F-1547-4A4C-A9F5-F9C0201CA9C2', '8915BDAE-0C75-473C-BA8D-05B64691155A', '921348F5-7BC4-4B1B-B359-DA6967681CA5', '97F8CEFF-DDEA-4F87-892A-39A2AED96461', '9A2924C2-D4B8-4767-B283-7241E6C70F61', '9FFECC09-52A5-4113-9735-05B8CEE0E550', 'A361EAB2-BD45-4598-AF8F-89FA3624F57B', 'AC241AB8-72DB-413F-9DD9-86086365B967', 'AC40B119-078D-4AFD-859C-5B46BA9DCE43', 'B87FFEF0-ABFB-4C5A-9744-498F3921BC8C', 'BFFECB53-4FB5-4A83-9894-9267B138544E', 'CB1E0A93-AC91-4D64-82D6-8247536CD78A', 'D08AC3FE-798D-482F-96CA-ECE8987C25F2', 'F2B2539E-BA55-4F70-9140-0C857F6C74AE', 'FAA470D2-48C4-4C84-8A10-74144E3CAEC4') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `specificationPropertyMasterDataId` from `PR_ProductSpecificationProperties` where `productId` in ('97F8CEFF-DDEA-4F87-892A-39A2AED96461', '06E7D881-897B-4943-872E-636B571D7B01', '73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '1870D8A9-EC9A-45F1-BFA7-BA9F2D8A46AC', '66D02392-55CD-49EC-9AFF-15DC778A79C3', '0F37540D-0972-4652-89DE-71FFDE9188C5', '78F56B1E-11E1-4279-BA8B-1A73EB2309D3', '629BFC45-F491-43B3-8048-EC685661A4F1', '2A5E83A2-FDA8-4595-B43A-20FC8956E448', '921348F5-7BC4-4B1B-B359-DA6967681CA5', '7D297319-F7DE-460D-AA80-1CC81D38DF69', '801FEEB5-4429-4550-BC7B-FA5983407CC6', 'A361EAB2-BD45-4598-AF8F-89FA3624F57B', 'CB1E0A93-AC91-4D64-82D6-8247536CD78A', 'AC40B119-078D-4AFD-859C-5B46BA9DCE43', 'FAA470D2-48C4-4C84-8A10-74144E3CAEC4', '9A2924C2-D4B8-4767-B283-7241E6C70F61', '8915BDAE-0C75-473C-BA8D-05B64691155A', '80B66C4F-1547-4A4C-A9F5-F9C0201CA9C2', '9FFECC09-52A5-4113-9735-05B8CEE0E550', '68355F4C-5F34-4F72-A510-A14D62F3D36D', '6A34BD4E-E40B-432C-9C9A-89F0CBD84C2B', 'BFFECB53-4FB5-4A83-9894-9267B138544E', 'D08AC3FE-798D-482F-96CA-ECE8987C25F2', 'B87FFEF0-ABFB-4C5A-9744-498F3921BC8C', '445589F9-F40D-4422-96E4-FAB5D4CC5153', '1FAB2BB8-5A3B-4F3E-9601-C2DE68BDBB14', 'F2B2539E-BA55-4F70-9140-0C857F6C74AE', '3CFD10BA-206E-4561-9C30-69C75CB3EEA1', '02DFEAB4-B4A6-4491-94E4-CF38C0CB78A2', '518CA1D1-88F9-4CF7-9BD9-C6C1E7035E7D')
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `categoryId` = '11C9289D-BCE1-4CE6-AABB-BE2169E8302F' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select MAX(`productPrice`) as max_price, MIN(`productPrice`) as min_price, count(*) as product_count from `PR_ProductCategories` inner join `PR_Products` on `PR_Products`.`productId` = `PR_ProductCategories`.`productId` and `PR_Products`.`isActive` = 1 and `isObsolete` is null and `PR_Products`.`deleted_at` is null and `PR_Products`.`lngId` = 7 where `categoryid` = '11C9289D-BCE1-4CE6-AABB-BE2169E8302F' and `PR_ProductCategories`.`deleted_at` is null
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` inner join `PR_Products` on `PR_Products`.`productId` = `PR_ProductCategories`.`productId` and `PR_Products`.`isActive` = 1 and `isObsolete` is null and `PR_Products`.`deleted_at` is null and `PR_Products`.`lngId` = 7 where `categoryid` = '11C9289D-BCE1-4CE6-AABB-BE2169E8302F' and `PR_ProductCategories`.`deleted_at` is null order by `PR_Products`.`newProductExpiryDate` desc limit 24 offset 0
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('0F37540D-0972-4652-89DE-71FFDE9188C5', '1870D8A9-EC9A-45F1-BFA7-BA9F2D8A46AC', '2A5E83A2-FDA8-4595-B43A-20FC8956E448', '445589F9-F40D-4422-96E4-FAB5D4CC5153', '629BFC45-F491-43B3-8048-EC685661A4F1', '66D02392-55CD-49EC-9AFF-15DC778A79C3', '68355F4C-5F34-4F72-A510-A14D62F3D36D', '6A34BD4E-E40B-432C-9C9A-89F0CBD84C2B', '73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '78F56B1E-11E1-4279-BA8B-1A73EB2309D3', '7D297319-F7DE-460D-AA80-1CC81D38DF69', '801FEEB5-4429-4550-BC7B-FA5983407CC6', '80B66C4F-1547-4A4C-A9F5-F9C0201CA9C2', '8915BDAE-0C75-473C-BA8D-05B64691155A', '921348F5-7BC4-4B1B-B359-DA6967681CA5', '9A2924C2-D4B8-4767-B283-7241E6C70F61', '9FFECC09-52A5-4113-9735-05B8CEE0E550', 'A361EAB2-BD45-4598-AF8F-89FA3624F57B', 'AC40B119-078D-4AFD-859C-5B46BA9DCE43', 'B87FFEF0-ABFB-4C5A-9744-498F3921BC8C', 'BFFECB53-4FB5-4A83-9894-9267B138544E', 'CB1E0A93-AC91-4D64-82D6-8247536CD78A', 'D08AC3FE-798D-482F-96CA-ECE8987C25F2', 'FAA470D2-48C4-4C84-8A10-74144E3CAEC4') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Medias` where `mediaUrl` is not null and `mediaUrl` <> '' and `contentType` = 1 and (`vehicleId` is null or exists (select * from `PR_Products` where `PR_Medias`.`productId` = `PR_Products`.`productId` and (select count(*) from `PR_VehicleProducts` where `PR_Products`.`productId` = `PR_VehicleProducts`.`productId` and `PR_VehicleProducts`.`deleted_at` is null and (`PR_VehicleProducts`.`lngId` is null or `PR_VehicleProducts`.`lngId` = '7') order by `lngId` desc) = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc)) and `PR_Medias`.`productId` in ('0F37540D-0972-4652-89DE-71FFDE9188C5', '1870D8A9-EC9A-45F1-BFA7-BA9F2D8A46AC', '2A5E83A2-FDA8-4595-B43A-20FC8956E448', '445589F9-F40D-4422-96E4-FAB5D4CC5153', '629BFC45-F491-43B3-8048-EC685661A4F1', '66D02392-55CD-49EC-9AFF-15DC778A79C3', '68355F4C-5F34-4F72-A510-A14D62F3D36D', '6A34BD4E-E40B-432C-9C9A-89F0CBD84C2B', '73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '78F56B1E-11E1-4279-BA8B-1A73EB2309D3', '7D297319-F7DE-460D-AA80-1CC81D38DF69', '801FEEB5-4429-4550-BC7B-FA5983407CC6', '80B66C4F-1547-4A4C-A9F5-F9C0201CA9C2', '8915BDAE-0C75-473C-BA8D-05B64691155A', '921348F5-7BC4-4B1B-B359-DA6967681CA5', '9A2924C2-D4B8-4767-B283-7241E6C70F61', '9FFECC09-52A5-4113-9735-05B8CEE0E550', 'A361EAB2-BD45-4598-AF8F-89FA3624F57B', 'AC40B119-078D-4AFD-859C-5B46BA9DCE43', 'B87FFEF0-ABFB-4C5A-9744-498F3921BC8C', 'BFFECB53-4FB5-4A83-9894-9267B138544E', 'CB1E0A93-AC91-4D64-82D6-8247536CD78A', 'D08AC3FE-798D-482F-96CA-ECE8987C25F2', 'FAA470D2-48C4-4C84-8A10-74144E3CAEC4') and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '7') and `isActive` = 1 order by `vehicleId` desc, `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `parentId` = '5C2DD4F5-056B-4961-B309-A37BA1BC5A4E' and `slug` = 'roof-trays' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `parentId` = 'A421D742-61EB-43C9-978F-43AADD8F611B' and `slug` = 'pioneer-trays' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` = 'A421D742-61EB-43C9-978F-43AADD8F611B' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_CategoryMeta` where `PR_CategoryMeta`.`categoryId` = '11C9289D-BCE1-4CE6-AABB-BE2169E8302F' and `PR_CategoryMeta`.`categoryId` is not null and `PR_CategoryMeta`.`deleted_at` is null and (`PR_CategoryMeta`.`lngId` is null or `PR_CategoryMeta`.`lngId` = 7) and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `pages` where 0 = 1 and `pages`.`deleted_at` is null and (`pages`.`lngId` is null or `pages`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '80B66C4F-1547-4A4C-A9F5-F9C0201CA9C2' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '1EE3B390-38D4-42FB-8E1E-0FACC26C3C3C', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'CC10C398-FA6F-4D53-A06D-66B723A76B0A') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', 'CC10C398-FA6F-4D53-A06D-66B723A76B0A', '1EE3B390-38D4-42FB-8E1E-0FACC26C3C3C', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '80B66C4F-1547-4A4C-A9F5-F9C0201CA9C2' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('05F86187-482A-48FE-ACAC-42454854124F', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '73AC63D3-C948-4EBA-955E-0D2D3DFA080F', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '80B66C4F-1547-4A4C-A9F5-F9C0201CA9C2' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', 'CC10C398-FA6F-4D53-A06D-66B723A76B0A', '1EE3B390-38D4-42FB-8E1E-0FACC26C3C3C', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', 'CC10C398-FA6F-4D53-A06D-66B723A76B0A', '1EE3B390-38D4-42FB-8E1E-0FACC26C3C3C', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '1870D8A9-EC9A-45F1-BFA7-BA9F2D8A46AC' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '91F7FB08-F114-42CE-A8A9-66AE3E7FB1BC', '92D46036-FCC8-4484-B14A-1FD6DCB38765') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('91F7FB08-F114-42CE-A8A9-66AE3E7FB1BC', '92D46036-FCC8-4484-B14A-1FD6DCB38765', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '1870D8A9-EC9A-45F1-BFA7-BA9F2D8A46AC' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '1870D8A9-EC9A-45F1-BFA7-BA9F2D8A46AC' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('91F7FB08-F114-42CE-A8A9-66AE3E7FB1BC', '92D46036-FCC8-4484-B14A-1FD6DCB38765', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('91F7FB08-F114-42CE-A8A9-66AE3E7FB1BC', '92D46036-FCC8-4484-B14A-1FD6DCB38765', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '9A2924C2-D4B8-4767-B283-7241E6C70F61' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'C2B9C9F1-C904-4686-BFDA-46287FC0283A') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'C2B9C9F1-C904-4686-BFDA-46287FC0283A', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '9A2924C2-D4B8-4767-B283-7241E6C70F61' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '9A2924C2-D4B8-4767-B283-7241E6C70F61' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'C2B9C9F1-C904-4686-BFDA-46287FC0283A', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'C2B9C9F1-C904-4686-BFDA-46287FC0283A', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'FAA470D2-48C4-4C84-8A10-74144E3CAEC4' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = 'FAA470D2-48C4-4C84-8A10-74144E3CAEC4' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = 'FAA470D2-48C4-4C84-8A10-74144E3CAEC4' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'AC40B119-078D-4AFD-859C-5B46BA9DCE43' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '376B70F1-C925-4540-A2E7-DEEC55F2830D', '864AA342-55D0-4D5A-89AE-DCD4F01CE4AE', 'ECCC67CC-BA48-4F54-8D20-6F3C4C569743', 'F56358A7-D643-45F7-A974-6A4B3E32F820') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('F56358A7-D643-45F7-A974-6A4B3E32F820', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', 'ECCC67CC-BA48-4F54-8D20-6F3C4C569743', '376B70F1-C925-4540-A2E7-DEEC55F2830D', '864AA342-55D0-4D5A-89AE-DCD4F01CE4AE', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = 'AC40B119-078D-4AFD-859C-5B46BA9DCE43' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('05F86187-482A-48FE-ACAC-42454854124F', '06E7D881-897B-4943-872E-636B571D7B01', '7B63CFF4-F78F-44F7-9E95-9F9F90505B82', '9A915692-6FDF-40C0-AA16-720A3917FCAC', 'AD8B1681-9882-498D-952B-C02B007A041E', 'EAB7EC9F-3C88-4232-BA56-807D7DA08EB1') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('06E7D881-897B-4943-872E-636B571D7B01', 'EAB7EC9F-3C88-4232-BA56-807D7DA08EB1', '7B63CFF4-F78F-44F7-9E95-9F9F90505B82', 'AD8B1681-9882-498D-952B-C02B007A041E', '9A915692-6FDF-40C0-AA16-720A3917FCAC', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = 'AC40B119-078D-4AFD-859C-5B46BA9DCE43' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('F56358A7-D643-45F7-A974-6A4B3E32F820', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', 'ECCC67CC-BA48-4F54-8D20-6F3C4C569743', '376B70F1-C925-4540-A2E7-DEEC55F2830D', '864AA342-55D0-4D5A-89AE-DCD4F01CE4AE', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('06E7D881-897B-4943-872E-636B571D7B01', 'EAB7EC9F-3C88-4232-BA56-807D7DA08EB1', '7B63CFF4-F78F-44F7-9E95-9F9F90505B82', 'AD8B1681-9882-498D-952B-C02B007A041E', '9A915692-6FDF-40C0-AA16-720A3917FCAC', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('F56358A7-D643-45F7-A974-6A4B3E32F820', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', 'ECCC67CC-BA48-4F54-8D20-6F3C4C569743', '376B70F1-C925-4540-A2E7-DEEC55F2830D', '864AA342-55D0-4D5A-89AE-DCD4F01CE4AE', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('06E7D881-897B-4943-872E-636B571D7B01', 'EAB7EC9F-3C88-4232-BA56-807D7DA08EB1', '7B63CFF4-F78F-44F7-9E95-9F9F90505B82', 'AD8B1681-9882-498D-952B-C02B007A041E', '9A915692-6FDF-40C0-AA16-720A3917FCAC', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'CB1E0A93-AC91-4D64-82D6-8247536CD78A' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '376B70F1-C925-4540-A2E7-DEEC55F2830D', '864AA342-55D0-4D5A-89AE-DCD4F01CE4AE', 'ECCC67CC-BA48-4F54-8D20-6F3C4C569743', 'F56358A7-D643-45F7-A974-6A4B3E32F820') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('F56358A7-D643-45F7-A974-6A4B3E32F820', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', 'ECCC67CC-BA48-4F54-8D20-6F3C4C569743', '376B70F1-C925-4540-A2E7-DEEC55F2830D', '864AA342-55D0-4D5A-89AE-DCD4F01CE4AE', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = 'CB1E0A93-AC91-4D64-82D6-8247536CD78A' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('05F86187-482A-48FE-ACAC-42454854124F', '06E7D881-897B-4943-872E-636B571D7B01', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '2CBD78E5-6F12-40AE-87A8-682042E21BF6', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('06E7D881-897B-4943-872E-636B571D7B01', '2CBD78E5-6F12-40AE-87A8-682042E21BF6', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = 'CB1E0A93-AC91-4D64-82D6-8247536CD78A' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('F56358A7-D643-45F7-A974-6A4B3E32F820', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', 'ECCC67CC-BA48-4F54-8D20-6F3C4C569743', '376B70F1-C925-4540-A2E7-DEEC55F2830D', '864AA342-55D0-4D5A-89AE-DCD4F01CE4AE', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('06E7D881-897B-4943-872E-636B571D7B01', '2CBD78E5-6F12-40AE-87A8-682042E21BF6', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('F56358A7-D643-45F7-A974-6A4B3E32F820', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', 'ECCC67CC-BA48-4F54-8D20-6F3C4C569743', '376B70F1-C925-4540-A2E7-DEEC55F2830D', '864AA342-55D0-4D5A-89AE-DCD4F01CE4AE', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('06E7D881-897B-4943-872E-636B571D7B01', '2CBD78E5-6F12-40AE-87A8-682042E21BF6', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'A361EAB2-BD45-4598-AF8F-89FA3624F57B' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '376B70F1-C925-4540-A2E7-DEEC55F2830D', '864AA342-55D0-4D5A-89AE-DCD4F01CE4AE', 'ECCC67CC-BA48-4F54-8D20-6F3C4C569743', 'F56358A7-D643-45F7-A974-6A4B3E32F820') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('F56358A7-D643-45F7-A974-6A4B3E32F820', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', 'ECCC67CC-BA48-4F54-8D20-6F3C4C569743', '376B70F1-C925-4540-A2E7-DEEC55F2830D', '864AA342-55D0-4D5A-89AE-DCD4F01CE4AE', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = 'A361EAB2-BD45-4598-AF8F-89FA3624F57B' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('05F86187-482A-48FE-ACAC-42454854124F', '06E7D881-897B-4943-872E-636B571D7B01', '7B63CFF4-F78F-44F7-9E95-9F9F90505B82', '81017A1D-D7F1-465A-8F71-C202FB9E50B7', '8FFCFC4E-36DE-4735-990F-C19B9848777B', 'AD8B1681-9882-498D-952B-C02B007A041E', 'CA281D8D-5095-4855-92DD-F567D5F62490') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('06E7D881-897B-4943-872E-636B571D7B01', 'CA281D8D-5095-4855-92DD-F567D5F62490', '7B63CFF4-F78F-44F7-9E95-9F9F90505B82', 'AD8B1681-9882-498D-952B-C02B007A041E', '81017A1D-D7F1-465A-8F71-C202FB9E50B7', '8FFCFC4E-36DE-4735-990F-C19B9848777B', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = 'A361EAB2-BD45-4598-AF8F-89FA3624F57B' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('F56358A7-D643-45F7-A974-6A4B3E32F820', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', 'ECCC67CC-BA48-4F54-8D20-6F3C4C569743', '376B70F1-C925-4540-A2E7-DEEC55F2830D', '864AA342-55D0-4D5A-89AE-DCD4F01CE4AE', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('06E7D881-897B-4943-872E-636B571D7B01', 'CA281D8D-5095-4855-92DD-F567D5F62490', '7B63CFF4-F78F-44F7-9E95-9F9F90505B82', 'AD8B1681-9882-498D-952B-C02B007A041E', '81017A1D-D7F1-465A-8F71-C202FB9E50B7', '8FFCFC4E-36DE-4735-990F-C19B9848777B', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('F56358A7-D643-45F7-A974-6A4B3E32F820', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', 'ECCC67CC-BA48-4F54-8D20-6F3C4C569743', '376B70F1-C925-4540-A2E7-DEEC55F2830D', '864AA342-55D0-4D5A-89AE-DCD4F01CE4AE', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('06E7D881-897B-4943-872E-636B571D7B01', 'CA281D8D-5095-4855-92DD-F567D5F62490', '7B63CFF4-F78F-44F7-9E95-9F9F90505B82', 'AD8B1681-9882-498D-952B-C02B007A041E', '81017A1D-D7F1-465A-8F71-C202FB9E50B7', '8FFCFC4E-36DE-4735-990F-C19B9848777B', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '801FEEB5-4429-4550-BC7B-FA5983407CC6' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'AB7D65CA-31FA-4586-8475-182A089287A2', 'D6164D33-DF96-43AE-80EA-0BEEECEB0393', 'F56358A7-D643-45F7-A974-6A4B3E32F820') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('D6164D33-DF96-43AE-80EA-0BEEECEB0393', 'F56358A7-D643-45F7-A974-6A4B3E32F820', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', 'AB7D65CA-31FA-4586-8475-182A089287A2', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '801FEEB5-4429-4550-BC7B-FA5983407CC6' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('131B1314-78F7-4F05-AFC2-1A170FAF0692', '73AC63D3-C948-4EBA-955E-0D2D3DFA080F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '131B1314-78F7-4F05-AFC2-1A170FAF0692') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '801FEEB5-4429-4550-BC7B-FA5983407CC6' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('D6164D33-DF96-43AE-80EA-0BEEECEB0393', 'F56358A7-D643-45F7-A974-6A4B3E32F820', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', 'AB7D65CA-31FA-4586-8475-182A089287A2', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '131B1314-78F7-4F05-AFC2-1A170FAF0692') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('D6164D33-DF96-43AE-80EA-0BEEECEB0393', 'F56358A7-D643-45F7-A974-6A4B3E32F820', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', 'AB7D65CA-31FA-4586-8475-182A089287A2', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '131B1314-78F7-4F05-AFC2-1A170FAF0692') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '7D297319-F7DE-460D-AA80-1CC81D38DF69' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '1EE3B390-38D4-42FB-8E1E-0FACC26C3C3C', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'CC10C398-FA6F-4D53-A06D-66B723A76B0A', 'F56358A7-D643-45F7-A974-6A4B3E32F820') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('1EE3B390-38D4-42FB-8E1E-0FACC26C3C3C', 'F56358A7-D643-45F7-A974-6A4B3E32F820', 'CC10C398-FA6F-4D53-A06D-66B723A76B0A', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '7D297319-F7DE-460D-AA80-1CC81D38DF69' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('05F86187-482A-48FE-ACAC-42454854124F', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '9F51A563-DC0C-4204-804A-A95E5758578C', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F', '9F51A563-DC0C-4204-804A-A95E5758578C') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '7D297319-F7DE-460D-AA80-1CC81D38DF69' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('1EE3B390-38D4-42FB-8E1E-0FACC26C3C3C', 'F56358A7-D643-45F7-A974-6A4B3E32F820', 'CC10C398-FA6F-4D53-A06D-66B723A76B0A', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F', '9F51A563-DC0C-4204-804A-A95E5758578C') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('1EE3B390-38D4-42FB-8E1E-0FACC26C3C3C', 'F56358A7-D643-45F7-A974-6A4B3E32F820', 'CC10C398-FA6F-4D53-A06D-66B723A76B0A', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F', '9F51A563-DC0C-4204-804A-A95E5758578C') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '921348F5-7BC4-4B1B-B359-DA6967681CA5' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '74021267-51CD-4522-AEBE-19BE83181D3F', 'ECCC67CC-BA48-4F54-8D20-6F3C4C569743', 'F56358A7-D643-45F7-A974-6A4B3E32F820') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('F56358A7-D643-45F7-A974-6A4B3E32F820', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', 'ECCC67CC-BA48-4F54-8D20-6F3C4C569743', '74021267-51CD-4522-AEBE-19BE83181D3F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '921348F5-7BC4-4B1B-B359-DA6967681CA5' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('05F86187-482A-48FE-ACAC-42454854124F', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '73AC63D3-C948-4EBA-955E-0D2D3DFA080F', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '921348F5-7BC4-4B1B-B359-DA6967681CA5' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('F56358A7-D643-45F7-A974-6A4B3E32F820', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', 'ECCC67CC-BA48-4F54-8D20-6F3C4C569743', '74021267-51CD-4522-AEBE-19BE83181D3F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('F56358A7-D643-45F7-A974-6A4B3E32F820', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', 'ECCC67CC-BA48-4F54-8D20-6F3C4C569743', '74021267-51CD-4522-AEBE-19BE83181D3F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '2A5E83A2-FDA8-4595-B43A-20FC8956E448' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '864AA342-55D0-4D5A-89AE-DCD4F01CE4AE', 'ECCC67CC-BA48-4F54-8D20-6F3C4C569743', 'F56358A7-D643-45F7-A974-6A4B3E32F820') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('F56358A7-D643-45F7-A974-6A4B3E32F820', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', 'ECCC67CC-BA48-4F54-8D20-6F3C4C569743', '864AA342-55D0-4D5A-89AE-DCD4F01CE4AE', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '2A5E83A2-FDA8-4595-B43A-20FC8956E448' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('05F86187-482A-48FE-ACAC-42454854124F', '0B2D0762-7818-4C72-8CA9-10498FE806D9', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '73AC63D3-C948-4EBA-955E-0D2D3DFA080F', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F', '0B2D0762-7818-4C72-8CA9-10498FE806D9') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '2A5E83A2-FDA8-4595-B43A-20FC8956E448' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('F56358A7-D643-45F7-A974-6A4B3E32F820', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', 'ECCC67CC-BA48-4F54-8D20-6F3C4C569743', '864AA342-55D0-4D5A-89AE-DCD4F01CE4AE', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F', '0B2D0762-7818-4C72-8CA9-10498FE806D9') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('F56358A7-D643-45F7-A974-6A4B3E32F820', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', 'ECCC67CC-BA48-4F54-8D20-6F3C4C569743', '864AA342-55D0-4D5A-89AE-DCD4F01CE4AE', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F', '0B2D0762-7818-4C72-8CA9-10498FE806D9') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '629BFC45-F491-43B3-8048-EC685661A4F1' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'ECCC67CC-BA48-4F54-8D20-6F3C4C569743', 'F56358A7-D643-45F7-A974-6A4B3E32F820') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('ECCC67CC-BA48-4F54-8D20-6F3C4C569743', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', 'F56358A7-D643-45F7-A974-6A4B3E32F820', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '629BFC45-F491-43B3-8048-EC685661A4F1' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('53E9B671-B8A0-4001-9914-1961A135C0D3', '73AC63D3-C948-4EBA-955E-0D2D3DFA080F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '53E9B671-B8A0-4001-9914-1961A135C0D3') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '629BFC45-F491-43B3-8048-EC685661A4F1' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('ECCC67CC-BA48-4F54-8D20-6F3C4C569743', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', 'F56358A7-D643-45F7-A974-6A4B3E32F820', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '53E9B671-B8A0-4001-9914-1961A135C0D3') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('ECCC67CC-BA48-4F54-8D20-6F3C4C569743', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', 'F56358A7-D643-45F7-A974-6A4B3E32F820', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '53E9B671-B8A0-4001-9914-1961A135C0D3') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '78F56B1E-11E1-4279-BA8B-1A73EB2309D3' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'AB7D65CA-31FA-4586-8475-182A089287A2') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', 'AB7D65CA-31FA-4586-8475-182A089287A2', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '78F56B1E-11E1-4279-BA8B-1A73EB2309D3' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('131B1314-78F7-4F05-AFC2-1A170FAF0692', '73AC63D3-C948-4EBA-955E-0D2D3DFA080F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '131B1314-78F7-4F05-AFC2-1A170FAF0692') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '78F56B1E-11E1-4279-BA8B-1A73EB2309D3' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', 'AB7D65CA-31FA-4586-8475-182A089287A2', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '131B1314-78F7-4F05-AFC2-1A170FAF0692') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', 'AB7D65CA-31FA-4586-8475-182A089287A2', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '131B1314-78F7-4F05-AFC2-1A170FAF0692') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '0F37540D-0972-4652-89DE-71FFDE9188C5' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'AB7D65CA-31FA-4586-8475-182A089287A2') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', 'AB7D65CA-31FA-4586-8475-182A089287A2', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '0F37540D-0972-4652-89DE-71FFDE9188C5' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('06E7D881-897B-4943-872E-636B571D7B01', '50D6789D-8616-41FF-9F4C-2E003AD2B49A', '9A614125-30A9-4863-BFCF-C0E51BA20780') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('06E7D881-897B-4943-872E-636B571D7B01', '9A614125-30A9-4863-BFCF-C0E51BA20780', '50D6789D-8616-41FF-9F4C-2E003AD2B49A') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '0F37540D-0972-4652-89DE-71FFDE9188C5' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', 'AB7D65CA-31FA-4586-8475-182A089287A2', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('06E7D881-897B-4943-872E-636B571D7B01', '9A614125-30A9-4863-BFCF-C0E51BA20780', '50D6789D-8616-41FF-9F4C-2E003AD2B49A') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', 'AB7D65CA-31FA-4586-8475-182A089287A2', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('06E7D881-897B-4943-872E-636B571D7B01', '9A614125-30A9-4863-BFCF-C0E51BA20780', '50D6789D-8616-41FF-9F4C-2E003AD2B49A') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '66D02392-55CD-49EC-9AFF-15DC778A79C3' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'C4F4361F-391E-4A44-A2DB-A8A94CAFCEB7') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', 'C4F4361F-391E-4A44-A2DB-A8A94CAFCEB7', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '66D02392-55CD-49EC-9AFF-15DC778A79C3' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', 'BC94303A-44AC-4F15-A532-380C3D428F15') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', 'BC94303A-44AC-4F15-A532-380C3D428F15') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '66D02392-55CD-49EC-9AFF-15DC778A79C3' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', 'C4F4361F-391E-4A44-A2DB-A8A94CAFCEB7', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', 'BC94303A-44AC-4F15-A532-380C3D428F15') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', 'C4F4361F-391E-4A44-A2DB-A8A94CAFCEB7', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', 'BC94303A-44AC-4F15-A532-380C3D428F15') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '8915BDAE-0C75-473C-BA8D-05B64691155A' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '1EE3B390-38D4-42FB-8E1E-0FACC26C3C3C', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'CC10C398-FA6F-4D53-A06D-66B723A76B0A') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('1EE3B390-38D4-42FB-8E1E-0FACC26C3C3C', 'CC10C398-FA6F-4D53-A06D-66B723A76B0A', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '8915BDAE-0C75-473C-BA8D-05B64691155A' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('0054E208-751D-42E2-ABF1-AD0E84786DF3', '05F86187-482A-48FE-ACAC-42454854124F', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '73AC63D3-C948-4EBA-955E-0D2D3DFA080F', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F', '0054E208-751D-42E2-ABF1-AD0E84786DF3') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '8915BDAE-0C75-473C-BA8D-05B64691155A' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('1EE3B390-38D4-42FB-8E1E-0FACC26C3C3C', 'CC10C398-FA6F-4D53-A06D-66B723A76B0A', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F', '0054E208-751D-42E2-ABF1-AD0E84786DF3') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('1EE3B390-38D4-42FB-8E1E-0FACC26C3C3C', 'CC10C398-FA6F-4D53-A06D-66B723A76B0A', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F', '0054E208-751D-42E2-ABF1-AD0E84786DF3') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '73AC63D3-C948-4EBA-955E-0D2D3DFA080F' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '73AC63D3-C948-4EBA-955E-0D2D3DFA080F' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '73AC63D3-C948-4EBA-955E-0D2D3DFA080F' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '9FFECC09-52A5-4113-9735-05B8CEE0E550' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '8030E215-2BB2-457B-A510-84B98AC52BF9') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '8030E215-2BB2-457B-A510-84B98AC52BF9', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '9FFECC09-52A5-4113-9735-05B8CEE0E550' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('5D6C330B-19F4-4D89-BF7C-55B14A28879F', '73AC63D3-C948-4EBA-955E-0D2D3DFA080F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '5D6C330B-19F4-4D89-BF7C-55B14A28879F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '9FFECC09-52A5-4113-9735-05B8CEE0E550' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '8030E215-2BB2-457B-A510-84B98AC52BF9', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '5D6C330B-19F4-4D89-BF7C-55B14A28879F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '8030E215-2BB2-457B-A510-84B98AC52BF9', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '5D6C330B-19F4-4D89-BF7C-55B14A28879F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '68355F4C-5F34-4F72-A510-A14D62F3D36D' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '376B70F1-C925-4540-A2E7-DEEC55F2830D') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('376B70F1-C925-4540-A2E7-DEEC55F2830D', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '68355F4C-5F34-4F72-A510-A14D62F3D36D' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('05F86187-482A-48FE-ACAC-42454854124F', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '7236FB29-2012-4348-8E33-1B06CAB423B6', '73AC63D3-C948-4EBA-955E-0D2D3DFA080F', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '7236FB29-2012-4348-8E33-1B06CAB423B6', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '68355F4C-5F34-4F72-A510-A14D62F3D36D' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('376B70F1-C925-4540-A2E7-DEEC55F2830D', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '7236FB29-2012-4348-8E33-1B06CAB423B6', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('376B70F1-C925-4540-A2E7-DEEC55F2830D', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '7236FB29-2012-4348-8E33-1B06CAB423B6', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '6A34BD4E-E40B-432C-9C9A-89F0CBD84C2B' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '376B70F1-C925-4540-A2E7-DEEC55F2830D') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('376B70F1-C925-4540-A2E7-DEEC55F2830D', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '6A34BD4E-E40B-432C-9C9A-89F0CBD84C2B' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('05F86187-482A-48FE-ACAC-42454854124F', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '2CBD78E5-6F12-40AE-87A8-682042E21BF6', '73AC63D3-C948-4EBA-955E-0D2D3DFA080F', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '2CBD78E5-6F12-40AE-87A8-682042E21BF6', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '6A34BD4E-E40B-432C-9C9A-89F0CBD84C2B' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('376B70F1-C925-4540-A2E7-DEEC55F2830D', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '2CBD78E5-6F12-40AE-87A8-682042E21BF6', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('376B70F1-C925-4540-A2E7-DEEC55F2830D', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '2CBD78E5-6F12-40AE-87A8-682042E21BF6', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'BFFECB53-4FB5-4A83-9894-9267B138544E' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '376B70F1-C925-4540-A2E7-DEEC55F2830D') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('376B70F1-C925-4540-A2E7-DEEC55F2830D', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = 'BFFECB53-4FB5-4A83-9894-9267B138544E' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('05F86187-482A-48FE-ACAC-42454854124F', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '577C39A6-D608-4705-99FA-5E316D717E92', '73AC63D3-C948-4EBA-955E-0D2D3DFA080F', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '577C39A6-D608-4705-99FA-5E316D717E92', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = 'BFFECB53-4FB5-4A83-9894-9267B138544E' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('376B70F1-C925-4540-A2E7-DEEC55F2830D', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '577C39A6-D608-4705-99FA-5E316D717E92', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('376B70F1-C925-4540-A2E7-DEEC55F2830D', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '577C39A6-D608-4705-99FA-5E316D717E92', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'D08AC3FE-798D-482F-96CA-ECE8987C25F2' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '376B70F1-C925-4540-A2E7-DEEC55F2830D') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('376B70F1-C925-4540-A2E7-DEEC55F2830D', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = 'D08AC3FE-798D-482F-96CA-ECE8987C25F2' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('05F86187-482A-48FE-ACAC-42454854124F', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '22ADDDD8-F9BB-444C-8325-7022C158858C', '73AC63D3-C948-4EBA-955E-0D2D3DFA080F', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '22ADDDD8-F9BB-444C-8325-7022C158858C', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = 'D08AC3FE-798D-482F-96CA-ECE8987C25F2' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('376B70F1-C925-4540-A2E7-DEEC55F2830D', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '22ADDDD8-F9BB-444C-8325-7022C158858C', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('376B70F1-C925-4540-A2E7-DEEC55F2830D', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '22ADDDD8-F9BB-444C-8325-7022C158858C', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'B87FFEF0-ABFB-4C5A-9744-498F3921BC8C' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '376B70F1-C925-4540-A2E7-DEEC55F2830D') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('376B70F1-C925-4540-A2E7-DEEC55F2830D', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = 'B87FFEF0-ABFB-4C5A-9744-498F3921BC8C' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('05F86187-482A-48FE-ACAC-42454854124F', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '34B3AC20-1470-4163-9002-4A2DEF58B895', '73AC63D3-C948-4EBA-955E-0D2D3DFA080F', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '34B3AC20-1470-4163-9002-4A2DEF58B895', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = 'B87FFEF0-ABFB-4C5A-9744-498F3921BC8C' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('376B70F1-C925-4540-A2E7-DEEC55F2830D', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '34B3AC20-1470-4163-9002-4A2DEF58B895', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('376B70F1-C925-4540-A2E7-DEEC55F2830D', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '34B3AC20-1470-4163-9002-4A2DEF58B895', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '445589F9-F40D-4422-96E4-FAB5D4CC5153' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '376B70F1-C925-4540-A2E7-DEEC55F2830D') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('376B70F1-C925-4540-A2E7-DEEC55F2830D', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '445589F9-F40D-4422-96E4-FAB5D4CC5153' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('05F86187-482A-48FE-ACAC-42454854124F', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '4D21C51A-A239-44A1-A690-B406AD84464C', '73AC63D3-C948-4EBA-955E-0D2D3DFA080F', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '4D21C51A-A239-44A1-A690-B406AD84464C', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '445589F9-F40D-4422-96E4-FAB5D4CC5153' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('376B70F1-C925-4540-A2E7-DEEC55F2830D', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '4D21C51A-A239-44A1-A690-B406AD84464C', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('376B70F1-C925-4540-A2E7-DEEC55F2830D', '11C9289D-BCE1-4CE6-AABB-BE2169E8302F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('73AC63D3-C948-4EBA-955E-0D2D3DFA080F', '4D21C51A-A239-44A1-A690-B406AD84464C', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `settings` where `key` = 'global_announcement' and `settings`.`deleted_at` is null and (`settings`.`lngId` is null or `settings`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `settings` where `key` = 'global_announcement_dealers' and `settings`.`deleted_at` is null and (`settings`.`lngId` is null or `settings`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
200
[]
[]
0 of 0array:15 [▼ "host" => array:1 [▶ 0 => "rrweb.webexpertsnepal.com" ] "connection" => array:1 [▶ 0 => "keep-alive" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "sec-ch-ua" => array:1 [▶ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] ]
0 of 0array:48 [▼ "REDIRECT_SCRIPT_URL" => "/en-au/products/roof-racks/roof-trays/pioneer-trays" "REDIRECT_SCRIPT_URI" => "https://rrweb.webexpertsnepal.com/en-au/products/roof-racks/roof-trays/pioneer-trays" "REDIRECT_HTTPS" => "on" "REDIRECT_SSL_TLS_SNI" => "rrweb.webexpertsnepal.com" "REDIRECT_STATUS" => "200" "SCRIPT_URL" => "/en-au/products/roof-racks/roof-trays/pioneer-trays" "SCRIPT_URI" => "https://rrweb.webexpertsnepal.com/en-au/products/roof-racks/roof-trays/pioneer-trays" "HTTPS" => "on" "SSL_TLS_SNI" => "rrweb.webexpertsnepal.com" "HTTP_HOST" => "rrweb.webexpertsnepal.com" "HTTP_CONNECTION" => "keep-alive" "HTTP_PRAGMA" => "no-cache" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin" "SERVER_SIGNATURE" => "<address>Apache/2.4.52 (Ubuntu) Server at rrweb.webexpertsnepal.com Port 443</address>\n" "SERVER_SOFTWARE" => "Apache/2.4.52 (Ubuntu)" "SERVER_NAME" => "rrweb.webexpertsnepal.com" "SERVER_ADDR" => "192.168.2.5" "SERVER_PORT" => "443" "REMOTE_ADDR" => "192.168.2.1" "DOCUMENT_ROOT" => "/var/www/rhinorack/web/public" "REQUEST_SCHEME" => "https" "CONTEXT_PREFIX" => "" "CONTEXT_DOCUMENT_ROOT" => "/var/www/rhinorack/web/public" "SERVER_ADMIN" => "webmaster@" "SCRIPT_FILENAME" => "/var/www/rhinorack/web/public/index.php" "REMOTE_PORT" => "4445" "REDIRECT_URL" => "/en-au/products/roof-racks/roof-trays/pioneer-trays" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/en-au/products/roof-racks/roof-trays/pioneer-trays" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1744355237.0229 "REQUEST_TIME" => 1744355237 ]
[]
0 of 0array:5 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Fri, 11 Apr 2025 07:07:17 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlZBU3RYL21CT3hUbUdFQzVoVUtxVWc9PSIsInZhbHVlIjoiSTZEa2d1NVQ0TC9HaStXYTc2VXU2bllFcGVYbjFIczZYdXpzYzYxTjhac3hNd1ptaTJGUVBFd3pZVGlUMW9oNlpRZDJVVWJtR1F3N1kwWWJVNjlkdGt4R3ZzT296UlNGSnpNTVNnN0RUQjVDUjBRSVd0emgwZXZER3lKdnVNNjAiLCJtYWMiOiIwYzRhZmExNjNhODk3ZmJjYzNmNzIwMTdhM2VmN2ZkYzY2OTk5Nzk4OWNjMjBhZjQ2YTBjMmRmZGQzOTdmYzExIiwidGFnIjoiIn0%3D; expires=Sun, 11 May 2025 17:07:18 GMT; Max-Age=2628000; path=/ ◀XSRF-TOKEN=eyJpdiI6IlZBU3RYL21CT3hUbUdFQzVoVUtxVWc9PSIsInZhbHVlIjoiSTZEa2d1NVQ0TC9HaStXYTc2VXU2bllFcGVYbjFIczZYdXpzYzYxTjhac3hNd1ptaTJGUVBFd3pZVGlUMW9oNlpRZDJVV ▶" 1 => "rhino_rack_session=eyJpdiI6IjZtZmg3U0ZKM3U0dTd2Y1laa2N3Vmc9PSIsInZhbHVlIjoicEpYeTlqa0Z6WGdWd00vcVN2dkhRK2FwdVNWUzFheWtLRFJUWGVnNjgwbExPTTFaTlBQTmE1NnpyU0JwazAwWVQzeUlsVTJBYk1xb1pFbzFaWXRYWkVwSnBzc05MMEdFL3l2UXNTaHhFcUo0czdDazRyS3RXV2tiRUZxbUdYZmkiLCJtYWMiOiJjYmZhNWQ3NzcyZTVhMmQ1ZGJkZWFhYWNkNWM2ZDE0MDc2YzRjM2I3MTczM2VmM2RhZDllYTM0ZGUzMmU3YTQ3IiwidGFnIjoiIn0%3D; expires=Sun, 11 May 2025 17:07:18 GMT; Max-Age=2628000; path=/; httponly ◀rhino_rack_session=eyJpdiI6IjZtZmg3U0ZKM3U0dTd2Y1laa2N3Vmc9PSIsInZhbHVlIjoicEpYeTlqa0Z6WGdWd00vcVN2dkhRK2FwdVNWUzFheWtLRFJUWGVnNjgwbExPTTFaTlBQTmE1NnpyU0JwazAwW ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlZBU3RYL21CT3hUbUdFQzVoVUtxVWc9PSIsInZhbHVlIjoiSTZEa2d1NVQ0TC9HaStXYTc2VXU2bllFcGVYbjFIczZYdXpzYzYxTjhac3hNd1ptaTJGUVBFd3pZVGlUMW9oNlpRZDJVVWJtR1F3N1kwWWJVNjlkdGt4R3ZzT296UlNGSnpNTVNnN0RUQjVDUjBRSVd0emgwZXZER3lKdnVNNjAiLCJtYWMiOiIwYzRhZmExNjNhODk3ZmJjYzNmNzIwMTdhM2VmN2ZkYzY2OTk5Nzk4OWNjMjBhZjQ2YTBjMmRmZGQzOTdmYzExIiwidGFnIjoiIn0%3D; expires=Sun, 11-May-2025 17:07:18 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlZBU3RYL21CT3hUbUdFQzVoVUtxVWc9PSIsInZhbHVlIjoiSTZEa2d1NVQ0TC9HaStXYTc2VXU2bllFcGVYbjFIczZYdXpzYzYxTjhac3hNd1ptaTJGUVBFd3pZVGlUMW9oNlpRZDJVV ▶" 1 => "rhino_rack_session=eyJpdiI6IjZtZmg3U0ZKM3U0dTd2Y1laa2N3Vmc9PSIsInZhbHVlIjoicEpYeTlqa0Z6WGdWd00vcVN2dkhRK2FwdVNWUzFheWtLRFJUWGVnNjgwbExPTTFaTlBQTmE1NnpyU0JwazAwWVQzeUlsVTJBYk1xb1pFbzFaWXRYWkVwSnBzc05MMEdFL3l2UXNTaHhFcUo0czdDazRyS3RXV2tiRUZxbUdYZmkiLCJtYWMiOiJjYmZhNWQ3NzcyZTVhMmQ1ZGJkZWFhYWNkNWM2ZDE0MDc2YzRjM2I3MTczM2VmM2RhZDllYTM0ZGUzMmU3YTQ3IiwidGFnIjoiIn0%3D; expires=Sun, 11-May-2025 17:07:18 GMT; path=/; httponly ◀rhino_rack_session=eyJpdiI6IjZtZmg3U0ZKM3U0dTd2Y1laa2N3Vmc9PSIsInZhbHVlIjoicEpYeTlqa0Z6WGdWd00vcVN2dkhRK2FwdVNWUzFheWtLRFJUWGVnNjgwbExPTTFaTlBQTmE1NnpyU0JwazAwW ▶" ] ]
0 of 0array:9 [▼ "_token" => "WfujvxLvBq6flqvd5yS3bRWC9093M8QwUwRJb6tz" "country" => "au" "_flash" => array:2 [▶ "old" => [] "new" => [] ] "lngId" => 7 "session_culture" => "en-au" "random_number" => 67 "locale" => "en" "_previous" => array:1 [▶ "url" => "https://rrweb.webexpertsnepal.com/en-au/products/roof-racks/roof-trays/pioneer-trays" ] "PHPDEBUGBAR_STACK_DATA" => [] ]