1 x Application (98.9%) | 998.79ms |
1 x Booting (1.09%) | 11.05ms |
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` = 'canopy' 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` = '8452459B-2689-4B32-BF7A-18D7DB57EDF7' and `slug` = 'crown-canopy-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_CategorySpecifications` where `PR_CategorySpecifications`.`categoryId` = 'AB7D65CA-31FA-4586-8475-182A089287A2' 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', '2261BB38-5354-44FE-B45C-849D201849B0', '2A37E3E3-CB54-453A-9EE9-53B3406A76CB', '6284DBED-EF43-4436-A768-B530DA94D027', '65DE24DC-83D6-4790-8EDE-0DEAD147EF02', '65EBFA01-7744-4861-803E-BA026DFC9BA0', '6FEC7B95-51EA-498A-A900-8FD5DA6C89D2', 'AEF3ACA8-93E7-4674-B28B-1AECF6611583', 'AFDBF6AE-7B97-42D6-8960-BC87744D5F7F', 'DBEE4D87-9FCC-4FA9-9D1D-7C8822B2A568') 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', '2261BB38-5354-44FE-B45C-849D201849B0', '2A37E3E3-CB54-453A-9EE9-53B3406A76CB', '6284DBED-EF43-4436-A768-B530DA94D027', '65DE24DC-83D6-4790-8EDE-0DEAD147EF02', '65EBFA01-7744-4861-803E-BA026DFC9BA0', '6FEC7B95-51EA-498A-A900-8FD5DA6C89D2', 'AEF3ACA8-93E7-4674-B28B-1AECF6611583', 'AFDBF6AE-7B97-42D6-8960-BC87744D5F7F', 'DBEE4D87-9FCC-4FA9-9D1D-7C8822B2A568') and `PR_SpecificationProperties`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_SpecificationPropertyMasterData` where `PR_SpecificationPropertyMasterData`.`specificationPropertyId` in ('1404128B-8306-4A41-926F-05ACF8F3B461', '22D06B2F-4F51-4E1B-B599-B3E1C01E8627', '3178C8C8-BCD1-49B2-8B42-5D6A9F870FE9', '48062BB7-CD0E-41B9-88D0-4C6174AD6AAF', '5781D63B-A789-4A08-BA84-BEB7ED3D094A', '59B96AF4-09D2-47B0-87D6-BA9A4C61F6AB', '6B65CCB5-C611-4252-AC40-B081C6520F2E', 'B2B090A4-D7F1-48B1-BB9A-7979E5D901D2', 'BDB99B83-7053-4913-94AA-4A53DBDE5668', '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` = 'AB7D65CA-31FA-4586-8475-182A089287A2' and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('05F5D45B-959E-4BB5-9F45-B2BC04982FD3', '0B6E47F3-AC7E-4810-AA9D-50492965082D', '0F37540D-0972-4652-89DE-71FFDE9188C5', '10C46043-9E20-4282-B3EC-668E8B2D19BE', '11A4BE04-D8C3-4CB1-AB89-B133B68BBFAA', '13CF2332-1A9E-4D60-AC4B-DB02A5DF848A', '15F79D2D-1CD2-4921-A8E7-F377467518A1', '1BB9776B-AB6B-4F20-9522-97BF6131D926', '1C634DE3-1641-4CF7-8F03-515A2B07B7FB', '1D68CC63-D104-41D6-837B-010FA131BDF5', '1EF2BAF6-76CC-4BBB-8C89-CC07730FA0C3', '21E697BD-8970-4AF8-A315-66BBE5D089E7', '28D17BA1-60D3-451A-B24D-5853FD7A7926', '3B85163E-C550-4EE8-A4DA-CC685F3786AD', '424B9EEF-D5C1-486D-8DAE-744E675F0E25', '43F3F4DA-20F0-4021-B8FD-B2D50DBEEEEB', '4DC7E565-327C-4BC0-A127-3805E604E92E', '4F0E06C7-B8C0-43BE-89E0-4EBC9146882D', '4F94ED52-4BFD-400B-933F-825D9225D720', '50E1D80C-2206-4716-AB68-6BA8590ECDDE', '516EAF3C-C583-4C1E-89A1-FF3ACA66DAB0', '5B7D0D01-9B6E-4C3B-9A4E-82E78616A31B', '606DFA31-1EBF-4256-8205-CB8377FF356B', '63CBA45A-6109-4B4F-85EB-BCA2BE361BDD', '65EC0577-3D40-46A1-A677-13FEE440CCA6', '6615AF59-F625-409F-BCC2-FE17F2AFE87F', '661D755E-A69D-46E4-92D6-F55FF9B29B55', '7396FC2A-6F4B-4925-8E40-CE3343DA066A', '74745E6D-CE7A-40B3-A7DE-D345E4AA52E0', '749CD9B6-7E9C-4A1E-9321-1E103906D08F', '78F56B1E-11E1-4279-BA8B-1A73EB2309D3', '7B9AD139-76E3-4E08-98E8-BEA51F1ECEA4', '801FEEB5-4429-4550-BC7B-FA5983407CC6', '8C0AD5D1-4A07-425A-9811-438F7B505F93', '9215F786-524B-4CE8-9E32-A495B45AF858', '9676ECB4-0747-424B-9113-B26D6BA27C8D', '9E6F334B-A5D1-434C-BAAE-FD2B31A9903B', 'A3A6C1D9-D5F2-47D7-A55D-839F7D79EC57', 'A7165789-468B-4838-A0CD-B3A5B64D49F8', 'A8FDBBDE-26AB-4F36-BE7F-0301387D5053', 'AE34C913-7B0D-4C4B-9E2B-652834417128', 'B01D0272-4251-4955-B122-133F02496601', 'C3842C43-EB1C-49E8-A715-9EE21FD9C3D4', 'CC1C80B2-CB4A-4407-A985-9E0D58289A7C', 'CE05EF6A-4F00-49D4-8AB7-9B4300A2FC91', 'DA6B90F8-55D4-42AD-96C6-CC453FD427B6', 'E0172277-D680-47F2-B132-B94E532FC9A4', 'ECE6A528-3139-465D-A409-3AE13B654E27', 'EFA694BD-C966-4C76-9BE2-E9557C3C2747', 'F823A624-0295-47AE-A731-31F43833F493', 'FDF4D781-163D-4602-8401-E63687E0018B') 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 ('65EC0577-3D40-46A1-A677-13FEE440CCA6', 'EFA694BD-C966-4C76-9BE2-E9557C3C2747', '0F37540D-0972-4652-89DE-71FFDE9188C5', '8C0AD5D1-4A07-425A-9811-438F7B505F93', '4F94ED52-4BFD-400B-933F-825D9225D720', '424B9EEF-D5C1-486D-8DAE-744E675F0E25', '1C634DE3-1641-4CF7-8F03-515A2B07B7FB', '78F56B1E-11E1-4279-BA8B-1A73EB2309D3', '0B6E47F3-AC7E-4810-AA9D-50492965082D', '9E6F334B-A5D1-434C-BAAE-FD2B31A9903B', 'CC1C80B2-CB4A-4407-A985-9E0D58289A7C', '10C46043-9E20-4282-B3EC-668E8B2D19BE', '43F3F4DA-20F0-4021-B8FD-B2D50DBEEEEB', 'AE34C913-7B0D-4C4B-9E2B-652834417128', '7396FC2A-6F4B-4925-8E40-CE3343DA066A', '21E697BD-8970-4AF8-A315-66BBE5D089E7', '5B7D0D01-9B6E-4C3B-9A4E-82E78616A31B', 'ECE6A528-3139-465D-A409-3AE13B654E27', '801FEEB5-4429-4550-BC7B-FA5983407CC6', '11A4BE04-D8C3-4CB1-AB89-B133B68BBFAA', '74745E6D-CE7A-40B3-A7DE-D345E4AA52E0', 'F823A624-0295-47AE-A731-31F43833F493', '28D17BA1-60D3-451A-B24D-5853FD7A7926', '50E1D80C-2206-4716-AB68-6BA8590ECDDE', 'CE05EF6A-4F00-49D4-8AB7-9B4300A2FC91', 'C3842C43-EB1C-49E8-A715-9EE21FD9C3D4', '9676ECB4-0747-424B-9113-B26D6BA27C8D', 'A7165789-468B-4838-A0CD-B3A5B64D49F8', '63CBA45A-6109-4B4F-85EB-BCA2BE361BDD', '1D68CC63-D104-41D6-837B-010FA131BDF5', '606DFA31-1EBF-4256-8205-CB8377FF356B', '1EF2BAF6-76CC-4BBB-8C89-CC07730FA0C3', '13CF2332-1A9E-4D60-AC4B-DB02A5DF848A', '15F79D2D-1CD2-4921-A8E7-F377467518A1', '661D755E-A69D-46E4-92D6-F55FF9B29B55', '6615AF59-F625-409F-BCC2-FE17F2AFE87F', '516EAF3C-C583-4C1E-89A1-FF3ACA66DAB0')
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `categoryId` = '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 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` = 'AB7D65CA-31FA-4586-8475-182A089287A2' 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` = 'AB7D65CA-31FA-4586-8475-182A089287A2' 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 ('0B6E47F3-AC7E-4810-AA9D-50492965082D', '10C46043-9E20-4282-B3EC-668E8B2D19BE', '11A4BE04-D8C3-4CB1-AB89-B133B68BBFAA', '1C634DE3-1641-4CF7-8F03-515A2B07B7FB', '21E697BD-8970-4AF8-A315-66BBE5D089E7', '28D17BA1-60D3-451A-B24D-5853FD7A7926', '424B9EEF-D5C1-486D-8DAE-744E675F0E25', '43F3F4DA-20F0-4021-B8FD-B2D50DBEEEEB', '4F94ED52-4BFD-400B-933F-825D9225D720', '50E1D80C-2206-4716-AB68-6BA8590ECDDE', '5B7D0D01-9B6E-4C3B-9A4E-82E78616A31B', '606DFA31-1EBF-4256-8205-CB8377FF356B', '65EC0577-3D40-46A1-A677-13FEE440CCA6', '7396FC2A-6F4B-4925-8E40-CE3343DA066A', '74745E6D-CE7A-40B3-A7DE-D345E4AA52E0', '78F56B1E-11E1-4279-BA8B-1A73EB2309D3', '801FEEB5-4429-4550-BC7B-FA5983407CC6', '8C0AD5D1-4A07-425A-9811-438F7B505F93', '9E6F334B-A5D1-434C-BAAE-FD2B31A9903B', 'AE34C913-7B0D-4C4B-9E2B-652834417128', 'CC1C80B2-CB4A-4407-A985-9E0D58289A7C', 'CE05EF6A-4F00-49D4-8AB7-9B4300A2FC91', 'ECE6A528-3139-465D-A409-3AE13B654E27', 'F823A624-0295-47AE-A731-31F43833F493') 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 ('0B6E47F3-AC7E-4810-AA9D-50492965082D', '10C46043-9E20-4282-B3EC-668E8B2D19BE', '11A4BE04-D8C3-4CB1-AB89-B133B68BBFAA', '1C634DE3-1641-4CF7-8F03-515A2B07B7FB', '21E697BD-8970-4AF8-A315-66BBE5D089E7', '28D17BA1-60D3-451A-B24D-5853FD7A7926', '424B9EEF-D5C1-486D-8DAE-744E675F0E25', '43F3F4DA-20F0-4021-B8FD-B2D50DBEEEEB', '4F94ED52-4BFD-400B-933F-825D9225D720', '50E1D80C-2206-4716-AB68-6BA8590ECDDE', '5B7D0D01-9B6E-4C3B-9A4E-82E78616A31B', '606DFA31-1EBF-4256-8205-CB8377FF356B', '65EC0577-3D40-46A1-A677-13FEE440CCA6', '7396FC2A-6F4B-4925-8E40-CE3343DA066A', '74745E6D-CE7A-40B3-A7DE-D345E4AA52E0', '78F56B1E-11E1-4279-BA8B-1A73EB2309D3', '801FEEB5-4429-4550-BC7B-FA5983407CC6', '8C0AD5D1-4A07-425A-9811-438F7B505F93', '9E6F334B-A5D1-434C-BAAE-FD2B31A9903B', 'AE34C913-7B0D-4C4B-9E2B-652834417128', 'CC1C80B2-CB4A-4407-A985-9E0D58289A7C', 'CE05EF6A-4F00-49D4-8AB7-9B4300A2FC91', 'ECE6A528-3139-465D-A409-3AE13B654E27', 'F823A624-0295-47AE-A731-31F43833F493') 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 ('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 * 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 (`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` = 'canopy' 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` = '8452459B-2689-4B32-BF7A-18D7DB57EDF7' and `slug` = 'crown-canopy-racks' 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` = '8452459B-2689-4B32-BF7A-18D7DB57EDF7' 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` = 'AB7D65CA-31FA-4586-8475-182A089287A2' 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` = '43F3F4DA-20F0-4021-B8FD-B2D50DBEEEEB' 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 ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '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 ('AB7D65CA-31FA-4586-8475-182A089287A2', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '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` = '43F3F4DA-20F0-4021-B8FD-B2D50DBEEEEB' 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', 'D2750AC9-265D-4816-8311-019B0AC34727') 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 ('131B1314-78F7-4F05-AFC2-1A170FAF0692', 'D2750AC9-265D-4816-8311-019B0AC34727') 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` = '43F3F4DA-20F0-4021-B8FD-B2D50DBEEEEB' 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 ('AB7D65CA-31FA-4586-8475-182A089287A2', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '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 ('131B1314-78F7-4F05-AFC2-1A170FAF0692', 'D2750AC9-265D-4816-8311-019B0AC34727') 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 ('AB7D65CA-31FA-4586-8475-182A089287A2', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '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 ('131B1314-78F7-4F05-AFC2-1A170FAF0692', 'D2750AC9-265D-4816-8311-019B0AC34727') 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` = '4F94ED52-4BFD-400B-933F-825D9225D720' 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 ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '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 ('AB7D65CA-31FA-4586-8475-182A089287A2', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '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` = '4F94ED52-4BFD-400B-933F-825D9225D720' 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 ('50D6789D-8616-41FF-9F4C-2E003AD2B49A', '9A614125-30A9-4863-BFCF-C0E51BA20780', 'F4002455-238B-4D8A-A05D-A91AF642DC79') 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 ('9A614125-30A9-4863-BFCF-C0E51BA20780', 'F4002455-238B-4D8A-A05D-A91AF642DC79', '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` = '4F94ED52-4BFD-400B-933F-825D9225D720' 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 ('AB7D65CA-31FA-4586-8475-182A089287A2', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '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 ('9A614125-30A9-4863-BFCF-C0E51BA20780', 'F4002455-238B-4D8A-A05D-A91AF642DC79', '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 ('AB7D65CA-31FA-4586-8475-182A089287A2', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '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 ('9A614125-30A9-4863-BFCF-C0E51BA20780', 'F4002455-238B-4D8A-A05D-A91AF642DC79', '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` = '424B9EEF-D5C1-486D-8DAE-744E675F0E25' 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 ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '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 ('AB7D65CA-31FA-4586-8475-182A089287A2', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '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` = '424B9EEF-D5C1-486D-8DAE-744E675F0E25' 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 ('50D6789D-8616-41FF-9F4C-2E003AD2B49A', '9A614125-30A9-4863-BFCF-C0E51BA20780', 'D2750AC9-265D-4816-8311-019B0AC34727') 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 ('9A614125-30A9-4863-BFCF-C0E51BA20780', 'D2750AC9-265D-4816-8311-019B0AC34727', '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` = '424B9EEF-D5C1-486D-8DAE-744E675F0E25' 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 ('AB7D65CA-31FA-4586-8475-182A089287A2', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '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 ('9A614125-30A9-4863-BFCF-C0E51BA20780', 'D2750AC9-265D-4816-8311-019B0AC34727', '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 ('AB7D65CA-31FA-4586-8475-182A089287A2', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '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 ('9A614125-30A9-4863-BFCF-C0E51BA20780', 'D2750AC9-265D-4816-8311-019B0AC34727', '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` = '1C634DE3-1641-4CF7-8F03-515A2B07B7FB' 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 ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '91F7FB08-F114-42CE-A8A9-66AE3E7FB1BC', '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 ('91F7FB08-F114-42CE-A8A9-66AE3E7FB1BC', '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` = '1C634DE3-1641-4CF7-8F03-515A2B07B7FB' 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 ('0A6068D0-6709-4B1D-BD83-800893B31242', '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 `netSuiteId` from `PR_Products` where `productId` in ('0A6068D0-6709-4B1D-BD83-800893B31242', '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` = '1C634DE3-1641-4CF7-8F03-515A2B07B7FB' 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', '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 ('0A6068D0-6709-4B1D-BD83-800893B31242', '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 ('91F7FB08-F114-42CE-A8A9-66AE3E7FB1BC', '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 ('0A6068D0-6709-4B1D-BD83-800893B31242', '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` = '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` = '0B6E47F3-AC7E-4810-AA9D-50492965082D' 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 ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '3B393703-FAA0-4701-A5B4-DFA329A3DC9B', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '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 ('4CA5F18E-7591-4B57-AC5F-D23F950CF945', 'AB7D65CA-31FA-4586-8475-182A089287A2', '3B393703-FAA0-4701-A5B4-DFA329A3DC9B', '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` = '0B6E47F3-AC7E-4810-AA9D-50492965082D' 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 ('D872661D-7FD5-4986-BC31-1BB4C789005C') 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 ('D872661D-7FD5-4986-BC31-1BB4C789005C') 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` = '0B6E47F3-AC7E-4810-AA9D-50492965082D' 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 ('4CA5F18E-7591-4B57-AC5F-D23F950CF945', 'AB7D65CA-31FA-4586-8475-182A089287A2', '3B393703-FAA0-4701-A5B4-DFA329A3DC9B', '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 ('D872661D-7FD5-4986-BC31-1BB4C789005C') 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 ('4CA5F18E-7591-4B57-AC5F-D23F950CF945', 'AB7D65CA-31FA-4586-8475-182A089287A2', '3B393703-FAA0-4701-A5B4-DFA329A3DC9B', '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 ('D872661D-7FD5-4986-BC31-1BB4C789005C') 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` = '9E6F334B-A5D1-434C-BAAE-FD2B31A9903B' 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 ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '3B393703-FAA0-4701-A5B4-DFA329A3DC9B', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '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 ('4CA5F18E-7591-4B57-AC5F-D23F950CF945', 'AB7D65CA-31FA-4586-8475-182A089287A2', '3B393703-FAA0-4701-A5B4-DFA329A3DC9B', '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` = '9E6F334B-A5D1-434C-BAAE-FD2B31A9903B' 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 ('D872661D-7FD5-4986-BC31-1BB4C789005C') 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 ('D872661D-7FD5-4986-BC31-1BB4C789005C') 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` = '9E6F334B-A5D1-434C-BAAE-FD2B31A9903B' 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 ('4CA5F18E-7591-4B57-AC5F-D23F950CF945', 'AB7D65CA-31FA-4586-8475-182A089287A2', '3B393703-FAA0-4701-A5B4-DFA329A3DC9B', '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 ('D872661D-7FD5-4986-BC31-1BB4C789005C') 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 ('4CA5F18E-7591-4B57-AC5F-D23F950CF945', 'AB7D65CA-31FA-4586-8475-182A089287A2', '3B393703-FAA0-4701-A5B4-DFA329A3DC9B', '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 ('D872661D-7FD5-4986-BC31-1BB4C789005C') 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` = '65EC0577-3D40-46A1-A677-13FEE440CCA6' 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 ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '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 ('4CA5F18E-7591-4B57-AC5F-D23F950CF945', 'AB7D65CA-31FA-4586-8475-182A089287A2', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '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` = '65EC0577-3D40-46A1-A677-13FEE440CCA6' 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', 'F4002455-238B-4D8A-A05D-A91AF642DC79') 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 ('131B1314-78F7-4F05-AFC2-1A170FAF0692', 'F4002455-238B-4D8A-A05D-A91AF642DC79') 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` = '65EC0577-3D40-46A1-A677-13FEE440CCA6' 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 ('4CA5F18E-7591-4B57-AC5F-D23F950CF945', 'AB7D65CA-31FA-4586-8475-182A089287A2', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '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 ('131B1314-78F7-4F05-AFC2-1A170FAF0692', 'F4002455-238B-4D8A-A05D-A91AF642DC79') 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 ('4CA5F18E-7591-4B57-AC5F-D23F950CF945', 'AB7D65CA-31FA-4586-8475-182A089287A2', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '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 ('131B1314-78F7-4F05-AFC2-1A170FAF0692', 'F4002455-238B-4D8A-A05D-A91AF642DC79') 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` = 'CC1C80B2-CB4A-4407-A985-9E0D58289A7C' 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 ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '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 ('4CA5F18E-7591-4B57-AC5F-D23F950CF945', 'AB7D65CA-31FA-4586-8475-182A089287A2', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '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` = 'CC1C80B2-CB4A-4407-A985-9E0D58289A7C' 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', 'D2750AC9-265D-4816-8311-019B0AC34727') 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 ('131B1314-78F7-4F05-AFC2-1A170FAF0692', 'D2750AC9-265D-4816-8311-019B0AC34727') 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` = 'CC1C80B2-CB4A-4407-A985-9E0D58289A7C' 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 ('4CA5F18E-7591-4B57-AC5F-D23F950CF945', 'AB7D65CA-31FA-4586-8475-182A089287A2', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '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 ('131B1314-78F7-4F05-AFC2-1A170FAF0692', 'D2750AC9-265D-4816-8311-019B0AC34727') 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 ('4CA5F18E-7591-4B57-AC5F-D23F950CF945', 'AB7D65CA-31FA-4586-8475-182A089287A2', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '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 ('131B1314-78F7-4F05-AFC2-1A170FAF0692', 'D2750AC9-265D-4816-8311-019B0AC34727') 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` = '10C46043-9E20-4282-B3EC-668E8B2D19BE' 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 ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '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 ('4CA5F18E-7591-4B57-AC5F-D23F950CF945', 'AB7D65CA-31FA-4586-8475-182A089287A2', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '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` = '10C46043-9E20-4282-B3EC-668E8B2D19BE' 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', 'F4002455-238B-4D8A-A05D-A91AF642DC79') 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 ('131B1314-78F7-4F05-AFC2-1A170FAF0692', 'F4002455-238B-4D8A-A05D-A91AF642DC79') 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` = '10C46043-9E20-4282-B3EC-668E8B2D19BE' 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 ('4CA5F18E-7591-4B57-AC5F-D23F950CF945', 'AB7D65CA-31FA-4586-8475-182A089287A2', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '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 ('131B1314-78F7-4F05-AFC2-1A170FAF0692', 'F4002455-238B-4D8A-A05D-A91AF642DC79') 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 ('4CA5F18E-7591-4B57-AC5F-D23F950CF945', 'AB7D65CA-31FA-4586-8475-182A089287A2', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '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 ('131B1314-78F7-4F05-AFC2-1A170FAF0692', 'F4002455-238B-4D8A-A05D-A91AF642DC79') 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` = '8C0AD5D1-4A07-425A-9811-438F7B505F93' 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 ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '3B393703-FAA0-4701-A5B4-DFA329A3DC9B', '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 ('3B393703-FAA0-4701-A5B4-DFA329A3DC9B', '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` = '8C0AD5D1-4A07-425A-9811-438F7B505F93' 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 ('50D6789D-8616-41FF-9F4C-2E003AD2B49A', '8D7D7313-DB13-4970-8ABC-F1A4DD7E68EB', '9A614125-30A9-4863-BFCF-C0E51BA20780', 'D974FD02-A291-4724-8FFB-A37BD398E8FC') 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 ('9A614125-30A9-4863-BFCF-C0E51BA20780', '50D6789D-8616-41FF-9F4C-2E003AD2B49A', '8D7D7313-DB13-4970-8ABC-F1A4DD7E68EB', 'D974FD02-A291-4724-8FFB-A37BD398E8FC') 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` = '8C0AD5D1-4A07-425A-9811-438F7B505F93' 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 ('3B393703-FAA0-4701-A5B4-DFA329A3DC9B', '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 ('9A614125-30A9-4863-BFCF-C0E51BA20780', '50D6789D-8616-41FF-9F4C-2E003AD2B49A', '8D7D7313-DB13-4970-8ABC-F1A4DD7E68EB', 'D974FD02-A291-4724-8FFB-A37BD398E8FC') 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 ('3B393703-FAA0-4701-A5B4-DFA329A3DC9B', '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 ('9A614125-30A9-4863-BFCF-C0E51BA20780', '50D6789D-8616-41FF-9F4C-2E003AD2B49A', '8D7D7313-DB13-4970-8ABC-F1A4DD7E68EB', 'D974FD02-A291-4724-8FFB-A37BD398E8FC') 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` = 'AE34C913-7B0D-4C4B-9E2B-652834417128' 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 ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '3B393703-FAA0-4701-A5B4-DFA329A3DC9B', 'AB7D65CA-31FA-4586-8475-182A089287A2', 'D6164D33-DF96-43AE-80EA-0BEEECEB0393') 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 ('3B393703-FAA0-4701-A5B4-DFA329A3DC9B', 'D6164D33-DF96-43AE-80EA-0BEEECEB0393', '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` = 'AE34C913-7B0D-4C4B-9E2B-652834417128' 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 ('D872661D-7FD5-4986-BC31-1BB4C789005C') 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 ('D872661D-7FD5-4986-BC31-1BB4C789005C') 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` = 'AE34C913-7B0D-4C4B-9E2B-652834417128' 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 ('3B393703-FAA0-4701-A5B4-DFA329A3DC9B', 'D6164D33-DF96-43AE-80EA-0BEEECEB0393', '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 ('D872661D-7FD5-4986-BC31-1BB4C789005C') 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 ('3B393703-FAA0-4701-A5B4-DFA329A3DC9B', 'D6164D33-DF96-43AE-80EA-0BEEECEB0393', '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 ('D872661D-7FD5-4986-BC31-1BB4C789005C') 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` = '7396FC2A-6F4B-4925-8E40-CE3343DA066A' 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 ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', 'AB7D65CA-31FA-4586-8475-182A089287A2', 'D6164D33-DF96-43AE-80EA-0BEEECEB0393') 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', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '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` = '7396FC2A-6F4B-4925-8E40-CE3343DA066A' 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', 'F4002455-238B-4D8A-A05D-A91AF642DC79') 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 ('131B1314-78F7-4F05-AFC2-1A170FAF0692', 'F4002455-238B-4D8A-A05D-A91AF642DC79') 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` = '7396FC2A-6F4B-4925-8E40-CE3343DA066A' 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', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '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 ('131B1314-78F7-4F05-AFC2-1A170FAF0692', 'F4002455-238B-4D8A-A05D-A91AF642DC79') 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', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '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 ('131B1314-78F7-4F05-AFC2-1A170FAF0692', 'F4002455-238B-4D8A-A05D-A91AF642DC79') 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` = '21E697BD-8970-4AF8-A315-66BBE5D089E7' 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 ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', 'AB7D65CA-31FA-4586-8475-182A089287A2', 'D6164D33-DF96-43AE-80EA-0BEEECEB0393') 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', 'AB7D65CA-31FA-4586-8475-182A089287A2', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '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` = '21E697BD-8970-4AF8-A315-66BBE5D089E7' 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', 'D2750AC9-265D-4816-8311-019B0AC34727') 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 ('131B1314-78F7-4F05-AFC2-1A170FAF0692', 'D2750AC9-265D-4816-8311-019B0AC34727') 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` = '21E697BD-8970-4AF8-A315-66BBE5D089E7' 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', 'AB7D65CA-31FA-4586-8475-182A089287A2', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '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 ('131B1314-78F7-4F05-AFC2-1A170FAF0692', 'D2750AC9-265D-4816-8311-019B0AC34727') 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', 'AB7D65CA-31FA-4586-8475-182A089287A2', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '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 ('131B1314-78F7-4F05-AFC2-1A170FAF0692', 'D2750AC9-265D-4816-8311-019B0AC34727') 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` = '5B7D0D01-9B6E-4C3B-9A4E-82E78616A31B' 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 ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '5B45A723-3C5D-4822-B5A6-BAD5DD250D1E', '92D46036-FCC8-4484-B14A-1FD6DCB38765', 'AB7D65CA-31FA-4586-8475-182A089287A2', 'D6164D33-DF96-43AE-80EA-0BEEECEB0393') 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', '92D46036-FCC8-4484-B14A-1FD6DCB38765', '5B45A723-3C5D-4822-B5A6-BAD5DD250D1E', '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` = '5B7D0D01-9B6E-4C3B-9A4E-82E78616A31B' 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 ('E27C36B9-13DC-4563-896C-0329D70F30B7') 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 ('E27C36B9-13DC-4563-896C-0329D70F30B7') 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` = '5B7D0D01-9B6E-4C3B-9A4E-82E78616A31B' 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', '92D46036-FCC8-4484-B14A-1FD6DCB38765', '5B45A723-3C5D-4822-B5A6-BAD5DD250D1E', '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 ('E27C36B9-13DC-4563-896C-0329D70F30B7') 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', '92D46036-FCC8-4484-B14A-1FD6DCB38765', '5B45A723-3C5D-4822-B5A6-BAD5DD250D1E', '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 ('E27C36B9-13DC-4563-896C-0329D70F30B7') 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` = 'ECE6A528-3139-465D-A409-3AE13B654E27' 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 ('0763DB5B-024D-4F37-901D-C483BA83712B', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '91F7FB08-F114-42CE-A8A9-66AE3E7FB1BC', 'AB7D65CA-31FA-4586-8475-182A089287A2', 'D6164D33-DF96-43AE-80EA-0BEEECEB0393') 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', '91F7FB08-F114-42CE-A8A9-66AE3E7FB1BC', 'AB7D65CA-31FA-4586-8475-182A089287A2', '0763DB5B-024D-4F37-901D-C483BA83712B', '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` = 'ECE6A528-3139-465D-A409-3AE13B654E27' 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 ('0A6068D0-6709-4B1D-BD83-800893B31242', '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 `netSuiteId` from `PR_Products` where `productId` in ('0A6068D0-6709-4B1D-BD83-800893B31242', '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` = 'ECE6A528-3139-465D-A409-3AE13B654E27' 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', '91F7FB08-F114-42CE-A8A9-66AE3E7FB1BC', 'AB7D65CA-31FA-4586-8475-182A089287A2', '0763DB5B-024D-4F37-901D-C483BA83712B', '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 ('0A6068D0-6709-4B1D-BD83-800893B31242', '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', '91F7FB08-F114-42CE-A8A9-66AE3E7FB1BC', 'AB7D65CA-31FA-4586-8475-182A089287A2', '0763DB5B-024D-4F37-901D-C483BA83712B', '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 ('0A6068D0-6709-4B1D-BD83-800893B31242', '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` = '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` = '11A4BE04-D8C3-4CB1-AB89-B133B68BBFAA' 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 ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '5B45A723-3C5D-4822-B5A6-BAD5DD250D1E', '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 ('5B45A723-3C5D-4822-B5A6-BAD5DD250D1E', '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` = '11A4BE04-D8C3-4CB1-AB89-B133B68BBFAA' 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 ('E27C36B9-13DC-4563-896C-0329D70F30B7') 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 ('E27C36B9-13DC-4563-896C-0329D70F30B7') 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` = '11A4BE04-D8C3-4CB1-AB89-B133B68BBFAA' 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 ('5B45A723-3C5D-4822-B5A6-BAD5DD250D1E', '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 ('E27C36B9-13DC-4563-896C-0329D70F30B7') 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 ('5B45A723-3C5D-4822-B5A6-BAD5DD250D1E', '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 ('E27C36B9-13DC-4563-896C-0329D70F30B7') 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` = '74745E6D-CE7A-40B3-A7DE-D345E4AA52E0' 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 ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '5B45A723-3C5D-4822-B5A6-BAD5DD250D1E', '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 ('5B45A723-3C5D-4822-B5A6-BAD5DD250D1E', '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` = '74745E6D-CE7A-40B3-A7DE-D345E4AA52E0' 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 ('50D6789D-8616-41FF-9F4C-2E003AD2B49A', '8D7D7313-DB13-4970-8ABC-F1A4DD7E68EB', '9A614125-30A9-4863-BFCF-C0E51BA20780', 'E27C36B9-13DC-4563-896C-0329D70F30B8') 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 ('E27C36B9-13DC-4563-896C-0329D70F30B8', '9A614125-30A9-4863-BFCF-C0E51BA20780', '50D6789D-8616-41FF-9F4C-2E003AD2B49A', '8D7D7313-DB13-4970-8ABC-F1A4DD7E68EB') 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` = '74745E6D-CE7A-40B3-A7DE-D345E4AA52E0' 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 ('5B45A723-3C5D-4822-B5A6-BAD5DD250D1E', '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 ('E27C36B9-13DC-4563-896C-0329D70F30B8', '9A614125-30A9-4863-BFCF-C0E51BA20780', '50D6789D-8616-41FF-9F4C-2E003AD2B49A', '8D7D7313-DB13-4970-8ABC-F1A4DD7E68EB') 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 ('5B45A723-3C5D-4822-B5A6-BAD5DD250D1E', '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 ('E27C36B9-13DC-4563-896C-0329D70F30B8', '9A614125-30A9-4863-BFCF-C0E51BA20780', '50D6789D-8616-41FF-9F4C-2E003AD2B49A', '8D7D7313-DB13-4970-8ABC-F1A4DD7E68EB') 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` = '606DFA31-1EBF-4256-8205-CB8377FF356B' 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 ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', 'AB7D65CA-31FA-4586-8475-182A089287A2', 'D6164D33-DF96-43AE-80EA-0BEEECEB0393') 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 ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', 'D6164D33-DF96-43AE-80EA-0BEEECEB0393', 'AB7D65CA-31FA-4586-8475-182A089287A2', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '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` = '606DFA31-1EBF-4256-8205-CB8377FF356B' 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', '21948AA5-0A8D-4CE6-AC7E-2722FBB92A15') 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 ('21948AA5-0A8D-4CE6-AC7E-2722FBB92A15', '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` = '606DFA31-1EBF-4256-8205-CB8377FF356B' 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 ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', 'D6164D33-DF96-43AE-80EA-0BEEECEB0393', 'AB7D65CA-31FA-4586-8475-182A089287A2', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '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 ('21948AA5-0A8D-4CE6-AC7E-2722FBB92A15', '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 ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', 'D6164D33-DF96-43AE-80EA-0BEEECEB0393', 'AB7D65CA-31FA-4586-8475-182A089287A2', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '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 ('21948AA5-0A8D-4CE6-AC7E-2722FBB92A15', '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` = 'F823A624-0295-47AE-A731-31F43833F493' 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 ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '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 ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', 'AB7D65CA-31FA-4586-8475-182A089287A2', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '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` = 'F823A624-0295-47AE-A731-31F43833F493' 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 ('14DD0175-CED9-42B8-9DBA-9BC14A45EC00', '50D6789D-8616-41FF-9F4C-2E003AD2B49A', '9A614125-30A9-4863-BFCF-C0E51BA20780', 'D2750AC9-265D-4816-8311-019B0AC34727') 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 ('D2750AC9-265D-4816-8311-019B0AC34727', '50D6789D-8616-41FF-9F4C-2E003AD2B49A', '14DD0175-CED9-42B8-9DBA-9BC14A45EC00', '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 * from `PR_Products` where `PR_Products`.`productId` = 'F823A624-0295-47AE-A731-31F43833F493' 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 ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', 'AB7D65CA-31FA-4586-8475-182A089287A2', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '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 ('D2750AC9-265D-4816-8311-019B0AC34727', '50D6789D-8616-41FF-9F4C-2E003AD2B49A', '14DD0175-CED9-42B8-9DBA-9BC14A45EC00', '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 count(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', 'AB7D65CA-31FA-4586-8475-182A089287A2', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '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 ('D2750AC9-265D-4816-8311-019B0AC34727', '50D6789D-8616-41FF-9F4C-2E003AD2B49A', '14DD0175-CED9-42B8-9DBA-9BC14A45EC00', '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 * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '28D17BA1-60D3-451A-B24D-5853FD7A7926' 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 ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '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 ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', 'AB7D65CA-31FA-4586-8475-182A089287A2', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '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` = '28D17BA1-60D3-451A-B24D-5853FD7A7926' 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 ('21948AA5-0A8D-4CE6-AC7E-2722FBB92A15', '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 ('21948AA5-0A8D-4CE6-AC7E-2722FBB92A15', '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 * from `PR_Products` where `PR_Products`.`productId` = '28D17BA1-60D3-451A-B24D-5853FD7A7926' 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 ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', 'AB7D65CA-31FA-4586-8475-182A089287A2', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '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 ('21948AA5-0A8D-4CE6-AC7E-2722FBB92A15', '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 count(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', 'AB7D65CA-31FA-4586-8475-182A089287A2', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '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 ('21948AA5-0A8D-4CE6-AC7E-2722FBB92A15', '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 * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '50E1D80C-2206-4716-AB68-6BA8590ECDDE' 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 ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '3B393703-FAA0-4701-A5B4-DFA329A3DC9B', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '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 ('3B393703-FAA0-4701-A5B4-DFA329A3DC9B', 'AB7D65CA-31FA-4586-8475-182A089287A2', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '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` = '50E1D80C-2206-4716-AB68-6BA8590ECDDE' 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 ('50D6789D-8616-41FF-9F4C-2E003AD2B49A', '8D7D7313-DB13-4970-8ABC-F1A4DD7E68EB', '9A614125-30A9-4863-BFCF-C0E51BA20780', 'D872661D-7FD5-4986-BC31-1BB4C789005C') 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 ('D872661D-7FD5-4986-BC31-1BB4C789005C', '8D7D7313-DB13-4970-8ABC-F1A4DD7E68EB', '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 * from `PR_Products` where `PR_Products`.`productId` = '50E1D80C-2206-4716-AB68-6BA8590ECDDE' 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 ('3B393703-FAA0-4701-A5B4-DFA329A3DC9B', 'AB7D65CA-31FA-4586-8475-182A089287A2', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '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 ('D872661D-7FD5-4986-BC31-1BB4C789005C', '8D7D7313-DB13-4970-8ABC-F1A4DD7E68EB', '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 count(*) as aggregate from `PR_Categories` where `categoryId` in ('3B393703-FAA0-4701-A5B4-DFA329A3DC9B', 'AB7D65CA-31FA-4586-8475-182A089287A2', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '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 ('D872661D-7FD5-4986-BC31-1BB4C789005C', '8D7D7313-DB13-4970-8ABC-F1A4DD7E68EB', '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 * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'CE05EF6A-4F00-49D4-8AB7-9B4300A2FC91' 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 ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', 'AB7D65CA-31FA-4586-8475-182A089287A2', 'D6164D33-DF96-43AE-80EA-0BEEECEB0393') 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 ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', 'D6164D33-DF96-43AE-80EA-0BEEECEB0393', 'AB7D65CA-31FA-4586-8475-182A089287A2', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '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` = 'CE05EF6A-4F00-49D4-8AB7-9B4300A2FC91' 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', '7CD87081-4C6C-469C-B2FB-E05ED64E7814') 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 ('131B1314-78F7-4F05-AFC2-1A170FAF0692', '7CD87081-4C6C-469C-B2FB-E05ED64E7814') 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` = 'CE05EF6A-4F00-49D4-8AB7-9B4300A2FC91' 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 ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', 'D6164D33-DF96-43AE-80EA-0BEEECEB0393', 'AB7D65CA-31FA-4586-8475-182A089287A2', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '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 ('131B1314-78F7-4F05-AFC2-1A170FAF0692', '7CD87081-4C6C-469C-B2FB-E05ED64E7814') 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 ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', 'D6164D33-DF96-43AE-80EA-0BEEECEB0393', 'AB7D65CA-31FA-4586-8475-182A089287A2', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '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 ('131B1314-78F7-4F05-AFC2-1A170FAF0692', '7CD87081-4C6C-469C-B2FB-E05ED64E7814') 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/canopy/crown-canopy-racks" "REDIRECT_SCRIPT_URI" => "https://rrweb.webexpertsnepal.com/en-au/products/roof-racks/canopy/crown-canopy-racks" "REDIRECT_HTTPS" => "on" "REDIRECT_SSL_TLS_SNI" => "rrweb.webexpertsnepal.com" "REDIRECT_STATUS" => "200" "SCRIPT_URL" => "/en-au/products/roof-racks/canopy/crown-canopy-racks" "SCRIPT_URI" => "https://rrweb.webexpertsnepal.com/en-au/products/roof-racks/canopy/crown-canopy-racks" "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" => "13109" "REDIRECT_URL" => "/en-au/products/roof-racks/canopy/crown-canopy-racks" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/en-au/products/roof-racks/canopy/crown-canopy-racks" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1744357615.1855 "REQUEST_TIME" => 1744357615 ]
[]
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:46:55 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InpxbFJyZlFQMjFzdjJoSW9QdGhTdmc9PSIsInZhbHVlIjoiZGxzMHhJVlExb0tFRjQ3b2xYNURNYVNpUEVyeHN1UXBQWDI2NmErem10SXIyNVF3TkF5QkorQlBsajFnTnJrQU1vK0F6S3MxQjU5andRVXdVRURvZ0RWSXRpWnQ4QkJTRElrMEFoZktvcTYwVE1DKzF4TDdENy9rQWRyandWM1oiLCJtYWMiOiJjM2ViMjM2NjU1NzBhZTFjNjMwY2YzNjJiZTBkMmU4MjZlMGRkOGIyOWViMmQ0ZWEwMzI3MTE5MzRhOWVjOTA0IiwidGFnIjoiIn0%3D; expires=Sun, 11 May 2025 17:46:56 GMT; Max-Age=2628000; path=/ ◀XSRF-TOKEN=eyJpdiI6InpxbFJyZlFQMjFzdjJoSW9QdGhTdmc9PSIsInZhbHVlIjoiZGxzMHhJVlExb0tFRjQ3b2xYNURNYVNpUEVyeHN1UXBQWDI2NmErem10SXIyNVF3TkF5QkorQlBsajFnTnJrQU1vK0F6S ▶" 1 => "rhino_rack_session=eyJpdiI6Ik1pay8raFRaUzdLRWVZUDF3R29EaWc9PSIsInZhbHVlIjoiSVdTOEIyS09EREZSdE1FYXZZQUVUSGpvRE9QNEhSRkVsZFgrS1NBTGJma0JJSm9lOXoxNm1WdXViZ3RPL3pyNG5EeUFYUFJ5eG1zakIxenJtWUZMLzNoQitxT1ZKL3JsTnJQM1Nuem5iRm1aU1huQWpHTjIyVktkanlCc0l1NWQiLCJtYWMiOiI2MmZmMWI3Mzc5ZDk0MmRhNmIwMjg3ODhjZGFmNjViMjRiYTVhYTNiOTU1MDZkNGNkNTZhZWExYTI4ZjZlN2U4IiwidGFnIjoiIn0%3D; expires=Sun, 11 May 2025 17:46:56 GMT; Max-Age=2628000; path=/; httponly ◀rhino_rack_session=eyJpdiI6Ik1pay8raFRaUzdLRWVZUDF3R29EaWc9PSIsInZhbHVlIjoiSVdTOEIyS09EREZSdE1FYXZZQUVUSGpvRE9QNEhSRkVsZFgrS1NBTGJma0JJSm9lOXoxNm1WdXViZ3RPL3pyN ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InpxbFJyZlFQMjFzdjJoSW9QdGhTdmc9PSIsInZhbHVlIjoiZGxzMHhJVlExb0tFRjQ3b2xYNURNYVNpUEVyeHN1UXBQWDI2NmErem10SXIyNVF3TkF5QkorQlBsajFnTnJrQU1vK0F6S3MxQjU5andRVXdVRURvZ0RWSXRpWnQ4QkJTRElrMEFoZktvcTYwVE1DKzF4TDdENy9rQWRyandWM1oiLCJtYWMiOiJjM2ViMjM2NjU1NzBhZTFjNjMwY2YzNjJiZTBkMmU4MjZlMGRkOGIyOWViMmQ0ZWEwMzI3MTE5MzRhOWVjOTA0IiwidGFnIjoiIn0%3D; expires=Sun, 11-May-2025 17:46:56 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InpxbFJyZlFQMjFzdjJoSW9QdGhTdmc9PSIsInZhbHVlIjoiZGxzMHhJVlExb0tFRjQ3b2xYNURNYVNpUEVyeHN1UXBQWDI2NmErem10SXIyNVF3TkF5QkorQlBsajFnTnJrQU1vK0F6S ▶" 1 => "rhino_rack_session=eyJpdiI6Ik1pay8raFRaUzdLRWVZUDF3R29EaWc9PSIsInZhbHVlIjoiSVdTOEIyS09EREZSdE1FYXZZQUVUSGpvRE9QNEhSRkVsZFgrS1NBTGJma0JJSm9lOXoxNm1WdXViZ3RPL3pyNG5EeUFYUFJ5eG1zakIxenJtWUZMLzNoQitxT1ZKL3JsTnJQM1Nuem5iRm1aU1huQWpHTjIyVktkanlCc0l1NWQiLCJtYWMiOiI2MmZmMWI3Mzc5ZDk0MmRhNmIwMjg3ODhjZGFmNjViMjRiYTVhYTNiOTU1MDZkNGNkNTZhZWExYTI4ZjZlN2U4IiwidGFnIjoiIn0%3D; expires=Sun, 11-May-2025 17:46:56 GMT; path=/; httponly ◀rhino_rack_session=eyJpdiI6Ik1pay8raFRaUzdLRWVZUDF3R29EaWc9PSIsInZhbHVlIjoiSVdTOEIyS09EREZSdE1FYXZZQUVUSGpvRE9QNEhSRkVsZFgrS1NBTGJma0JJSm9lOXoxNm1WdXViZ3RPL3pyN ▶" ] ]
0 of 0array:9 [▼ "_token" => "dLIhB1aNrrT2AUN3kHrFAgEhFUI9gq01dNV5jLuz" "country" => "au" "_flash" => array:2 [▶ "old" => [] "new" => [] ] "lngId" => 7 "session_culture" => "en-au" "random_number" => 36 "locale" => "en" "_previous" => array:1 [▶ "url" => "https://rrweb.webexpertsnepal.com/en-au/products/roof-racks/canopy/crown-canopy-racks" ] "PHPDEBUGBAR_STACK_DATA" => [] ]