1 x Application (99.38%) | 1.04s |
1 x Booting (0.62%) | 6.48ms |
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` = 'cross-bar-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` = '13674F82-0F17-442D-AD28-13A8C7683425' and `slug` = 'pioneer-tradie' 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` = '0763DB5B-024D-4F37-901D-C483BA83712B' and `PR_CategorySpecifications`.`categoryId` is not null and `PR_CategorySpecifications`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Specifications` where `PR_Specifications`.`specificationId` in ('14F3FB81-8947-4E5E-BB23-2F17B1452EF2', '1A76CA3F-315C-4EA6-8002-E3B352C23337', '2148B1D3-F535-4E7C-939D-7FD62DFA2FFB', '2261BB38-5354-44FE-B45C-849D201849B0', '2A37E3E3-CB54-453A-9EE9-53B3406A76CB', '2F7D1296-9A11-420C-99DA-0CF2BB9A62DD', '33C27305-6859-4DF9-9CC5-FB5E0806602D', '50F360E9-8C0F-437E-A879-5685BEFF3827', '6FEC7B95-51EA-498A-A900-8FD5DA6C89D2', '7A90BAEF-94DE-4E35-9446-A53AE478B8C7', 'CE49416F-033B-4F79-A495-86DFDF9F4655', 'F59236C8-DE3C-45A9-975D-0E0EE462E09E') and `PR_Specifications`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_SpecificationProperties` where `PR_SpecificationProperties`.`specificationId` in ('14F3FB81-8947-4E5E-BB23-2F17B1452EF2', '1A76CA3F-315C-4EA6-8002-E3B352C23337', '2148B1D3-F535-4E7C-939D-7FD62DFA2FFB', '2261BB38-5354-44FE-B45C-849D201849B0', '2A37E3E3-CB54-453A-9EE9-53B3406A76CB', '2F7D1296-9A11-420C-99DA-0CF2BB9A62DD', '33C27305-6859-4DF9-9CC5-FB5E0806602D', '50F360E9-8C0F-437E-A879-5685BEFF3827', '6FEC7B95-51EA-498A-A900-8FD5DA6C89D2', '7A90BAEF-94DE-4E35-9446-A53AE478B8C7', 'CE49416F-033B-4F79-A495-86DFDF9F4655', 'F59236C8-DE3C-45A9-975D-0E0EE462E09E') and `PR_SpecificationProperties`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_SpecificationPropertyMasterData` where `PR_SpecificationPropertyMasterData`.`specificationPropertyId` in ('0754223D-333A-4880-B62B-EED1492A023E', '1404128B-8306-4A41-926F-05ACF8F3B461', '3178C8C8-BCD1-49B2-8B42-5D6A9F870FE9', '3678388B-7153-434F-B245-0795D8AD6E60', '38A9EC0F-41EE-4B46-B03D-5F1B91922988', '3D70412C-100B-4FBD-9E2A-3195E8C38509', '40A339D4-C734-41BE-A9F5-7540C347B360', '6B65CCB5-C611-4252-AC40-B081C6520F2E', '6EC81350-90AD-44AC-93DD-C4259723C2F5', '7FF6FD81-194A-4575-8110-DA21E2657100', '852775DC-8804-4D09-BF04-1D892D6D9915', '91DFCCD6-DB15-4B07-ADFD-2CA86F1C45F0', '9B57FACA-1967-4CFA-833C-6F9578CFD249', '9EB49FBD-D3D3-428E-9C59-B4E355A0022D', 'CCFCEE3B-1E54-4876-953D-ACD9C9CAA8C7', 'D78F6505-9766-4732-A858-73785505B425') and `PR_SpecificationPropertyMasterData`.`deleted_at` is null order by `title` asc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `categoryId` = '0763DB5B-024D-4F37-901D-C483BA83712B' and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('008856CD-B583-4480-9165-9D3E7CC80167', '0266FCCE-68CF-433A-875C-54CA36669701', '04E84F81-179A-4AF5-9BA5-0A6D64CFC4B4', '05638384-1F67-4DCC-BC75-D4BC6BCCD317', '0603116A-DD7E-43F0-84DD-9B9CD2395E44', '07EFD79D-3ABE-48F5-B239-9A6F9506FFC2', '08E1DF2F-307A-44C8-B3BC-51CEB2582809', '08EE8D2C-B4FE-4C1B-963A-9AD5121059E7', '09F059AA-EC62-4C06-9289-FD9F77FC47AB', '0A5663A3-2805-4A31-81B4-2C5128756996', '0AB4A866-FAF4-414C-94F0-E166C1CBE988', '0B062848-D7A0-410A-B577-2F4F7246F996', '0BDD9620-5F30-4618-9767-91464F7A3249', '0BE7E8A4-422D-4D1D-B7BC-9AE1F795F455', '0F6EF452-2AC4-4665-B09B-C7024138B747', '102E079B-3D41-40EF-8566-2EB45E0591D1', '1081B4A8-76E0-4906-A715-8618610F2C5D', '1160C0CE-D433-447B-8188-15810F039D07', '178CBDDF-72E2-46C0-A932-33A66F81FFAE', '18A84E43-9B60-4E27-9C4B-FA0F9CE4BDD0', '18D128FD-FE2F-4CC7-A6CA-BE205300C2BE', '1A038DF9-A85F-42E8-88A9-42D60D9105C8', '1A19001B-28C9-4CBC-967F-EEE03E792ACC', '1A1D6E9A-F6F8-4F54-8CAD-BA966B52394D', '1A5525E4-A98F-4CAD-9586-A9B577A48224', '1A617C54-BDD6-42B5-8596-F00349B9BA19', '1B9DFF0E-D2EF-474C-8F3D-9ECF58743315', '1D3EFDCA-99B5-4ACD-A98C-413E0E7F1D8C', '1E2509DB-1A0C-41E3-B7A0-E594F467CE1E', '1E4074FD-7BB9-4EAF-A80A-C5217F28280D', '1F0AA421-E364-46EA-AF36-8CD1CA44B211', '1F8D5C8E-F8E8-44F4-AA15-81D88DD58290', '2078A62D-CE87-4A4D-B44F-E6FD8BD564DB', '2083441F-1246-4571-A9B4-9C1AEF5F4CF2', '20F220E6-7F0D-47F9-9E03-F5F9402B2C6C', '215C7E9D-0CD4-4790-9590-961A8ABAEE61', '25C7F8D8-2C9B-41C5-A77D-4249657DB0BC', '25DF507B-5CB3-4058-ABB9-AE62EB512337', '25E3CD37-4D85-41F4-AFF5-C8F1C5500225', '27103301-3352-4F98-829C-BE6496A8D7B0', '27382933-BC7C-46BE-B649-B526627F54E7', '28A7BFEA-5BF8-4056-8C54-1F23A0387B06', '29549450-CCEF-403A-A926-52B082060C5D', '296CB1FB-AFB0-43AA-BCDF-C9C58E0E4DDA', '2A4DADFF-9AF6-424E-9585-DE417DAF65CA', '2AF4D63B-6BD7-4535-BE91-36EB1A2DE58D', '2D569088-DFC7-411E-9902-FF2FA8501A76', '2E1ADE75-778A-4BA8-AB1D-6527DC130AA0', '2E306D86-29F9-4018-86C0-D6CD6861F308', '2F514031-723A-499C-B55A-A97B40873536', '2F7D5B61-0613-4A45-9ABC-DCC8336FC5FB', '2F8349CB-21CD-4413-B14C-8DEEC0603E7A', '309EB518-B74F-435F-92ED-5DC7966E2259', '30ADE99F-E388-434E-B863-FB6ED8612B2B', '310DC125-3714-407C-825B-56DF3E80996C', '3147AE75-C2B7-4ECF-BBAA-293ACC34A642', '331A0713-F3FD-469C-9BE9-0DCC17323D5A', '344C8060-6283-4DE0-9FB9-EFD538491472', '34A79857-8A67-488B-BB69-DCBBFE3367E1', '34DA074E-3139-4821-9BF8-BF995ED5BA4C', '352B6BAE-9BEB-441E-9734-A7FFA4826A9C', '3541106F-E3C9-45B7-AAE6-EDBB2C3931B4', '36DA6A80-3659-40FD-B789-DE47F51A5E5A', '3818F205-87E4-4B16-BBE7-7CCEB7280031', '385CF1C1-C9D7-4262-8B42-A563574BAA71', '38968536-F8D3-482C-9898-A99B50D178B4', '3B3A9D0B-8A7F-4400-8843-95EE1E3E0C18', '3B484CD3-8813-4D24-87F7-D2ECDC72D0A1', '3BE59EBC-8AA4-481E-8721-80E838123819', '3BF3534D-941E-4910-A242-2DEAB4C322EE', '3CB5463A-934A-46B1-A8D5-F471D907B04B', '3CFD4A18-EAF1-40FD-A597-379901507B2D', '3F0AB43C-05F4-4127-877C-ED14F1C14D03', '3FB501F8-ED6F-4D50-874E-87DE0071704C', '4172E3E6-D0B2-4A7C-B163-E2B2C601CAC3', '42B1F413-D367-415F-8D02-C3A26DE6316E', '439135D9-8BC8-4D82-A41F-695101CF8F49', '43DCE98C-1E2E-4388-83DE-645A822F6D32', '45B5DC2B-8E9D-406F-9172-945EE62DC9EE', '46486A0F-5875-47C9-9694-18F69C9A0820', '46AEA8EF-F8AC-430D-A2C8-C5548D4746E1', '476C4500-DD6D-428F-A5C8-70993C091C54', '47F4DDF3-F082-4CE4-8FB7-C259C7ABFD18', '48DF62A1-7607-41CD-B6D5-B026B26BA098', '492D6F82-1DE5-40E2-B3B4-ECB56F96CD98', '494AD70E-BE91-49AB-A25E-C10DE18F10FD', '4963F803-0B5A-4839-9394-9AB97A301DF6', '496AF304-685E-4DA2-959C-0B6BAD099019', '4A801029-F6C3-41EC-B92C-8F2E49935590', '4CE137E7-6123-4B3B-B9DF-C6E07EE1AE82', '4CEB8E70-951E-4D1E-9E8A-48504BE4818B', '4D7E7C15-1A87-4F4A-AB61-D2B50D84FADC', '4F133498-8E4D-478F-957D-AB8EB05FC0B4', '4F190BA5-02AF-4358-89F8-9704EF7A43B3', '4F9EDBA0-CEE7-4DBC-8AC7-CD355A1D2D88', '5014F9A6-EF42-45F1-9DF0-9A557B06A19C', '51041998-272F-48FD-832D-3392467C079F', '51141551-9A9C-47CB-B1F6-B2A4A1654BBD', '51A83D6A-3412-4E86-83B7-A94691DF0C71', '538694C4-130A-4CCC-A145-A15B39D5FFFD', '551255C3-1729-4C5F-BA30-5C43F86DB311', '571FC7C2-0F0D-4D5A-9294-C6E2E050ED55', '578D76EB-7B46-49B0-A567-7201E1EFFFFE', '584A4C27-290A-45FB-AC77-ACF29488269D', '585CEAA9-7667-4206-A361-B3AA8B3E2A72', '5AE6562C-06B0-432D-B715-45C7CB81903D', '5AF1C828-E64F-489D-ABB4-60524E93EBC9', '5CAE148C-4D46-435A-B292-8378CC6015FF', '5E629405-AF14-4401-9BFE-D24135BE41B1', '5E89E2A5-E516-4474-BF69-FAA36E130242', '5EB05269-32BF-4A4E-B7F0-AA2A5EDD3860', '6015BA2A-8C24-44C8-A13E-6983C079F553', '60BE12D1-74F5-434D-8FE8-3A86C680141C', '6112F889-1729-4FB4-A192-C1BEFAD118E3', '61E2E72E-12E1-4FDF-9C22-6D813C331FA5', '639CACDD-8FD4-42DC-984B-4BA6E7B2A789', '675100E2-74DA-4AC5-AF15-4A5C4BF956EE', '688326B4-7848-436C-BF54-5B4C0AE615D3', '68F2CC5C-F761-4105-B959-D5A0015D7BFA', '6924522D-D634-4B72-AF8B-6F2450D8A932', '6926A24D-A233-4E07-89F1-58CDF2991796', '6B2A6B20-59B5-4260-9D62-0FB6984A9780', '6C16116F-DCC5-488E-94D3-03C4003EC253', '6E8872F2-0588-4767-970B-BC51F01DB6DB', '6F6D1F24-B5F3-439D-8E32-41FB693B1508', '6F6D4D66-E004-478D-B5EE-953CC640B900', '6FB34A75-ECB1-43B3-B2CF-4A8445F46226', '71D12048-6A95-4C72-B836-355D9FC2D74C', '726CE068-326E-4079-899A-EBCB10EA09EC', '72ED845C-F95C-4354-AD57-35ED04FAA2F0', '7337ABD3-64B6-4818-ADD2-CE000652944E', '7339FB6E-8E29-4D14-9445-F238703841C8', '73A0F334-97E9-45D4-9CFF-905E50005AE0', '74EA247F-0CCD-406A-BD0B-7F89EFE57233', '771C4488-FF5E-4718-B7ED-13922F074535', '775E18D5-11CB-4F65-917E-B8A9A142761C', '78A8156F-7704-49CD-BA63-B5629B850B4C', '78FE87F5-BC05-4079-801C-E3BFB3E705B7', '79A41C3E-3256-44EF-992B-3AF439A25760', '7B987EF8-7919-43DD-BCBE-C98B94662558', '7B997077-667A-4024-895B-2330D376ADC7', '7CD53628-5BA5-4616-88A0-C15937921A1F', '7D8C9D45-7DB6-41E3-BCE3-809C3878FDC7', '7EE29634-647A-40D4-97E2-387BD8481EE2', '804473BF-3A91-4EB4-B011-A003E4C3C572', '81292956-D251-4943-9916-2934B7A98165', '82349677-E7A2-4A36-B555-BE82A3DF0000', '82FA8D6F-BB75-4C86-8253-3D2D66F17446', '8327CD3E-2101-475B-8F72-63AB002D4657', '832DF131-F51A-4BED-AAB4-43D721D8BD91', '8479F3C9-EA87-43C6-94B5-A5A06C65F75B', '85CEF166-D39E-4CF2-94D2-3A7BFED31C27', '865AFAD2-29C6-4C1E-AE88-429238E49E20', '86664EC5-4099-45F9-97D0-0FC4EBACF05E', '86D5C4BC-6350-4806-BFA6-2D0157764B97', '86FFA035-2DCE-488B-A6B2-4A4A35F9EF72', '8A175381-CAA8-432E-B212-503A9BA49BD7', '8ABE8F2F-348A-4A3F-BC8F-7D9DA746892D', '8B499747-4BA8-4605-9B52-26351E0B3D00', '8B826575-7D30-469D-A504-6B1FE354500D', '8BCF1D0C-9815-4539-A1BD-8E2C41071AA5', '8C008B38-042D-4E62-B216-4B810536C68C', '8FBB9512-C5B6-46D3-8B41-4D62996D19D6', '8FD7D92C-2B06-4E9D-BCB9-565B73B3EBF1', '9262D28F-B249-4343-8A24-50F735701F23', '93A8494D-E4D3-4087-B83C-0F82A69056CF', '94A9C5C1-5AF8-40D3-BE9C-CF3DF9F293C2', '953AEBC8-A8E9-418F-A424-3EAE0613E4C9', '95BA5779-779C-48F6-9FDD-2A3C690C149B', '96FEB298-9FCF-48D7-882F-B1D60CCB0E29', '99F4D3B3-9725-437E-81AC-E6BB40E78C4B', '9ABD2EF7-EDD7-412B-B216-F6BD2612AD02', '9C393B71-7AC7-4046-B127-708CB48C545C', '9D01647A-AF78-4D6F-A635-8DC15BB27E95', 'A101B6B6-F8AC-46ED-82D3-65014B700463', 'A16B5BF9-DFD9-43F0-8838-A75C84C19C7D', 'A1878C5E-399B-4745-BE88-5A5D84EC11FD', 'A1DED501-592E-4479-B632-186292E1368B', 'A2003C0B-BC9A-4DC4-956C-A5CCAC28F659', 'A26F72E5-EEE1-467C-9F6C-42624D7810DF', 'A3167D78-DF56-459B-9ADB-F7313BEDD3B6', 'A38D4DFA-DA27-4F23-AFA7-BCFA5F89D241', 'A3C07BF3-828C-4AD3-8E93-B6F109FDDD8F', 'A3C45994-A108-4FEF-A3D2-5A934B7075AE', 'A4017353-F553-458B-81CC-61F40BFCA497', 'A449FEC5-8C1F-4F40-BF07-2D7329BCFDAE', 'A46D0ADA-B6AE-42E9-998E-4DB73BF8D384', 'A4BE87B3-6D1C-4EF8-AD0A-8153D5B79B7F', 'A580429A-39AC-47C9-A52E-D09C67AA2CFB', 'A5E7910D-6F52-4B24-82E3-257C67F29CA0', 'A64D2BEF-6CEF-4CF0-B3D5-E4D391797CAC', 'A6763106-A7D4-4A94-B90B-5BCD1AB56FD2', 'A695CEA4-7F45-4146-B19D-1794A5EB68FA', 'A801E744-569C-4645-9A4B-A6B5E7B80A03', 'A813003F-CA89-438D-BBE1-7BA7666C2FC5', 'A9BACFB6-D55C-47FE-89D8-915345F1AEFA', 'ABF7B457-CAE0-49A7-9050-8F93AE2C4423', 'AD14FAFE-0ADB-4B3C-B4D4-B5A2A77313C1', 'AD9ACDA4-D83A-49A1-9587-3ABB04B0B1A9', 'AE71337A-12D9-47E2-930A-75AA47EA1678', 'B081134B-A90B-4C92-A0A3-E4851E422812', 'B1ECDD84-8ED0-455F-9C86-6D5274B72AB1', 'B27C4AD1-7203-48FB-8502-87BA2A268C92', 'B28032E4-3369-4039-8754-64A3F2900765', 'B3E2E549-F5D0-4F91-BC5E-6F43943246A3', 'B401D172-1D03-4CED-A124-4E53BD3551C3', 'B4F26E66-8BD9-4E89-AC50-5E927257386D', 'B5222E64-18D5-4E0D-9F00-C76EE11BE9FA', 'B5FFB79B-0669-47AC-9B68-EF0FA5131157', 'B854A978-39B4-4B94-A97C-F2201051B507', 'B954FBF3-F776-4ED4-A24C-A248BBF52804', 'BAEE47CC-657F-436B-8B70-BFCD35D70A9E', 'BCE30E03-CA96-4698-9558-22444BF0F841', 'BCF7C103-8A7D-4AE5-98E5-86BF69912CB0', 'BEE57B32-6F76-45FA-B8EA-A31686CC28CF', 'BF6AAE15-0F98-4839-A1E3-F11CE0573449', 'BFBA7871-5EF9-4EEC-BE67-18DDE8FEB7D0', 'C056D4D1-06D9-4822-BCC4-D19E5D0E02AF', 'C1414235-7E9E-49E7-B5D6-88B82974E37F', 'C1BB503E-1944-40FE-A56B-85CB72606F34', 'C1CBF0FA-732C-4500-AB01-801AB091C712', 'C1D21407-5BD2-475C-8EB1-0348FA63AF78', 'C27C52D1-8381-49A8-9973-464E9EC83FDD', 'C3A311F1-C413-456F-A8E0-F6C09D10DE57', 'C43C485E-B761-401E-9DF6-71CF677CC77D', 'C468DEEE-3016-4D46-91D3-F6E8FBA6909A', 'C55DE7B6-4F64-4EAE-996B-0704EADB1917', 'C59EF11D-655E-4001-A935-512D6C947FB5', 'C5C2659B-DA8A-4A38-9AEB-5E7125DF2C90', 'C64B59F0-77E5-416D-BA53-4D7160EF1533', 'C79D8D71-8DF6-4CAF-A47B-ACE33C62B26B', 'C817D596-0FA3-4925-A266-EE890AB0BD2D', 'C8B0A0E2-8913-4AAF-B25E-01FF396D1963', 'C9521B67-3F0E-4BE0-B2A0-6D558EA16D17', 'C9F999EA-3AB1-426D-AB3D-AE2E5C817BF6', 'CACC0FAD-A6D0-48DA-9242-A57AE8A527CA', 'CB9606EB-65D5-4F22-8789-0B26A0EE176A', 'CD07482E-1BB2-428A-AE91-C5786BE49975', 'CDD3AC5F-CA3F-46BE-9E14-0CC0FDBE0290', 'CE98101A-F1D2-4377-B8C1-6110E9236503', 'CF226DA5-284C-4C28-B61D-BBE610A12B67', 'CF5DD92D-0D98-4489-8653-B5FC550A78A6', 'CFBD745F-852B-4BC1-BEE5-84DDAD4330C7', 'D1E3721B-1FB2-4B2E-8829-2ECBBEAA861C', 'D211E02B-5E35-4B3B-B0D8-A658FB4FF6F6', 'D5523D4C-101A-428B-935B-AF997083527A', 'D5EE3C45-E259-4F69-92D9-6C52A4C147E1', 'D821D9D4-CEB9-4E0D-9757-104EAFD93579', 'D892A776-BFC5-494B-B5E3-58234E4A53C7', 'D939C4DD-69C0-4BA1-AB14-E4B8986C3457', 'DA738E97-F7DC-4468-A21C-70F73C1BC027', 'DAE6089B-E5E4-4503-AD39-5B74498390F9', 'DAEE4D91-2A1E-434D-8E71-BEF8F11AC56C', 'DB8EE226-EF4E-4D9A-BA13-32FCF65D1FBF', 'DBECD2D2-98DE-401C-878F-95E3FBFF3DC9', 'DC3F31EA-B162-4FA8-A997-65F3D9F49DD6', 'DD028AF8-88B6-48CE-A04D-12B136510577', 'DDEFF94B-8DFA-4FC1-AEBF-D035DBF01285', 'DE40BB59-7769-4FCE-A9AD-65638822947D', 'DE527032-045D-49A9-9FD9-DD86840097E6', 'DEABF242-F004-41DF-8934-D7B7F5D85182', 'E0ADDA91-5E90-43D6-B348-8514CDC7011B', 'E0C20E9F-4C30-4A21-A755-DE0DDEE2876E', 'E1441F66-0954-4B02-8499-E9E38FF3C308', 'E1DB032D-D544-4631-BAC7-02E2D5ED1C2F', 'E251E66B-877C-4D6A-A2F7-F8ADE889518C', 'E2FF9BAB-A657-429B-B680-43B1D6692914', 'E3096205-7469-499E-8202-7C4A5CB5A8D4', 'E32B5511-7A7C-49F8-87DC-6D47A91625D6', 'E3AECDBA-5324-4517-8E0E-0C77F3030F73', 'E40CD6EA-663E-4B33-AEA6-553C39F075AF', 'E42344FD-58FD-4325-BFC0-6ED258E87265', 'E4BE83B5-5418-4DC2-9F22-F7AD871529BE', 'E4D51DA6-B407-4912-A8F8-E6F738CD8E37', 'E57F24CC-58F6-4EE1-8353-C1C75AF1212E', 'E5E4CA1F-A255-4EA6-A382-34FC01E3BCC9', 'E65B7A0D-E9C6-4E66-974D-C5F6A8A1DE83', 'E7818164-7A34-471E-B645-58557F03C2C8', 'E876B559-69C9-4FAB-BC13-6190DCCFE8AC', 'E8805D84-6192-433E-8870-6404BA2479E0', 'E90C384F-3EA8-4964-94C3-EE12FC11B6D4', 'EA9EB880-1913-4D6E-B89D-2C309D26F68F', 'EAFEAB63-9A48-48F3-A83E-6C37DB7DC4E6', 'EB381DEE-2F9E-4A6C-9245-191C37E6FF29', 'ECE6A528-3139-465D-A409-3AE13B654E27', 'ED871B8A-D900-4BF3-AAAF-61F5E85BABD0', 'EF478749-84B6-441E-A808-4EED8D78AAD9', 'F0158813-49B7-4769-891F-BCEFA12A90BC', 'F04FE2F1-7EC6-4B2B-8CA4-21D36DCE5D82', 'F1035B99-9D06-4C60-8BA5-7FEFDD202D39', 'F2596F1B-87A9-4CD3-9BB5-5020A11D4B3D', 'F2DDDB1B-0222-4E97-9DF3-C1BFC13CC059', 'F36A1894-41F5-400C-9132-3C9A0BBC8C00', 'F3ADCB43-42DC-472B-99D3-5DE1A199E351', 'F3F11A35-228E-4A70-84A9-03C4BB86A3D0', 'F4913AC7-2CD2-4C42-BEF6-72FAC2AAE599', 'F57D13F5-6D33-4AEE-8932-473D4BA13F16', 'F5D1E109-DB4E-4901-A333-5AB732F33B54', 'F5DF5363-42D2-475E-8BE2-F14155E61F05', 'F6E01732-2F42-4CBA-8603-9B5322E7206E', 'F737A375-91B2-420C-A25E-217F39D86A30', 'F790420C-D9C0-4B01-A2F0-2B09FCBE5F4F', 'F82933AB-5E1F-4469-907F-CE0DA0092B9F', 'F9306F4B-6333-42EA-A5DD-18D6965FFEF0', 'F9C772DF-344D-4EB6-ACB2-DCDB42A2FC2F', 'F9F91152-AAA4-4AE6-9FB9-FFCC8B9DE6EF', 'FA61183F-C49C-4EC6-8F21-49361D611162', 'FAD913D4-BA54-4622-8C86-EA888859FA35', 'FAF21C1B-D9A9-4874-8648-515B2609BF6D', 'FB04A18E-CB2F-458D-B6C5-91240354C6FF', 'FE215627-1E50-4A59-B8E2-7F715B592251', 'FF40CC7C-AA40-41B5-A78F-014C24CA4856', 'FF51E858-7AAA-4627-90CC-4C54F8BA2526', 'FF93DF33-5A2C-497A-800C-B2DB5483BAB6') and `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 ('FF40CC7C-AA40-41B5-A78F-014C24CA4856', '6C16116F-DCC5-488E-94D3-03C4003EC253', 'C55DE7B6-4F64-4EAE-996B-0704EADB1917', '496AF304-685E-4DA2-959C-0B6BAD099019', 'DD028AF8-88B6-48CE-A04D-12B136510577', '771C4488-FF5E-4718-B7ED-13922F074535', 'F9306F4B-6333-42EA-A5DD-18D6965FFEF0', 'BFBA7871-5EF9-4EEC-BE67-18DDE8FEB7D0', 'BCE30E03-CA96-4698-9558-22444BF0F841', 'A5E7910D-6F52-4B24-82E3-257C67F29CA0', '8B499747-4BA8-4605-9B52-26351E0B3D00', '81292956-D251-4943-9916-2934B7A98165', '3147AE75-C2B7-4ECF-BBAA-293ACC34A642', '95BA5779-779C-48F6-9FDD-2A3C690C149B', 'F790420C-D9C0-4B01-A2F0-2B09FCBE5F4F', '0A5663A3-2805-4A31-81B4-2C5128756996', 'A449FEC5-8C1F-4F40-BF07-2D7329BCFDAE', '3BF3534D-941E-4910-A242-2DEAB4C322EE', '51041998-272F-48FD-832D-3392467C079F', 'E5E4CA1F-A255-4EA6-A382-34FC01E3BCC9', '72ED845C-F95C-4354-AD57-35ED04FAA2F0', '60BE12D1-74F5-434D-8FE8-3A86C680141C', '79A41C3E-3256-44EF-992B-3AF439A25760', 'F36A1894-41F5-400C-9132-3C9A0BBC8C00', '82FA8D6F-BB75-4C86-8253-3D2D66F17446', '1D3EFDCA-99B5-4ACD-A98C-413E0E7F1D8C', '6F6D1F24-B5F3-439D-8E32-41FB693B1508', 'E2FF9BAB-A657-429B-B680-43B1D6692914', 'F57D13F5-6D33-4AEE-8932-473D4BA13F16', '4CEB8E70-951E-4D1E-9E8A-48504BE4818B', 'FA61183F-C49C-4EC6-8F21-49361D611162', '86FFA035-2DCE-488B-A6B2-4A4A35F9EF72', '8C008B38-042D-4E62-B216-4B810536C68C', '639CACDD-8FD4-42DC-984B-4BA6E7B2A789', 'A46D0ADA-B6AE-42E9-998E-4DB73BF8D384', 'B401D172-1D03-4CED-A124-4E53BD3551C3', '8A175381-CAA8-432E-B212-503A9BA49BD7', 'E40CD6EA-663E-4B33-AEA6-553C39F075AF', 'A3C45994-A108-4FEF-A3D2-5A934B7075AE', 'F3ADCB43-42DC-472B-99D3-5DE1A199E351', 'B4F26E66-8BD9-4E89-AC50-5E927257386D', 'E876B559-69C9-4FAB-BC13-6190DCCFE8AC', 'A4017353-F553-458B-81CC-61F40BFCA497', '43DCE98C-1E2E-4388-83DE-645A822F6D32', 'DC3F31EA-B162-4FA8-A997-65F3D9F49DD6', '6015BA2A-8C24-44C8-A13E-6983C079F553', 'EAFEAB63-9A48-48F3-A83E-6C37DB7DC4E6', 'D5EE3C45-E259-4F69-92D9-6C52A4C147E1', 'B3E2E549-F5D0-4F91-BC5E-6F43943246A3', '476C4500-DD6D-428F-A5C8-70993C091C54', 'DA738E97-F7DC-4468-A21C-70F73C1BC027', 'AE71337A-12D9-47E2-930A-75AA47EA1678', '3818F205-87E4-4B16-BBE7-7CCEB7280031', 'F1035B99-9D06-4C60-8BA5-7FEFDD202D39', '3BE59EBC-8AA4-481E-8721-80E838123819', '1F8D5C8E-F8E8-44F4-AA15-81D88DD58290', 'B27C4AD1-7203-48FB-8502-87BA2A268C92', '9D01647A-AF78-4D6F-A635-8DC15BB27E95', 'ABF7B457-CAE0-49A7-9050-8F93AE2C4423', 'A9BACFB6-D55C-47FE-89D8-915345F1AEFA', 'DBECD2D2-98DE-401C-878F-95E3FBFF3DC9', '07EFD79D-3ABE-48F5-B239-9A6F9506FFC2', '08EE8D2C-B4FE-4C1B-963A-9AD5121059E7', '0BE7E8A4-422D-4D1D-B7BC-9AE1F795F455', '2083441F-1246-4571-A9B4-9C1AEF5F4CF2', '538694C4-130A-4CCC-A145-A15B39D5FFFD', 'B954FBF3-F776-4ED4-A24C-A248BBF52804', 'CACC0FAD-A6D0-48DA-9242-A57AE8A527CA', '8479F3C9-EA87-43C6-94B5-A5A06C65F75B', 'A16B5BF9-DFD9-43F0-8838-A75C84C19C7D', '352B6BAE-9BEB-441E-9734-A7FFA4826A9C', '38968536-F8D3-482C-9898-A99B50D178B4', '5EB05269-32BF-4A4E-B7F0-AA2A5EDD3860', 'C79D8D71-8DF6-4CAF-A47B-ACE33C62B26B', '48DF62A1-7607-41CD-B6D5-B026B26BA098', 'FF93DF33-5A2C-497A-800C-B2DB5483BAB6', '585CEAA9-7667-4206-A361-B3AA8B3E2A72', '27382933-BC7C-46BE-B649-B526627F54E7', 'CF5DD92D-0D98-4489-8653-B5FC550A78A6', 'A3C07BF3-828C-4AD3-8E93-B6F109FDDD8F', 'F0158813-49B7-4769-891F-BCEFA12A90BC', '27103301-3352-4F98-829C-BE6496A8D7B0', '82349677-E7A2-4A36-B555-BE82A3DF0000', 'BAEE47CC-657F-436B-8B70-BFCD35D70A9E', '494AD70E-BE91-49AB-A25E-C10DE18F10FD', '6112F889-1729-4FB4-A192-C1BEFAD118E3', '4CE137E7-6123-4B3B-B9DF-C6E07EE1AE82', '0F6EF452-2AC4-4665-B09B-C7024138B747', 'B5222E64-18D5-4E0D-9F00-C76EE11BE9FA', '25E3CD37-4D85-41F4-AFF5-C8F1C5500225', '7337ABD3-64B6-4818-ADD2-CE000652944E', '94A9C5C1-5AF8-40D3-BE9C-CF3DF9F293C2', '4D7E7C15-1A87-4F4A-AB61-D2B50D84FADC', '68F2CC5C-F761-4105-B959-D5A0015D7BFA', 'DEABF242-F004-41DF-8934-D7B7F5D85182', '2F7D5B61-0613-4A45-9ABC-DCC8336FC5FB', 'DE527032-045D-49A9-9FD9-DD86840097E6', 'E0C20E9F-4C30-4A21-A755-DE0DDEE2876E', 'A64D2BEF-6CEF-4CF0-B3D5-E4D391797CAC', '1E2509DB-1A0C-41E3-B7A0-E594F467CE1E', 'E1441F66-0954-4B02-8499-E9E38FF3C308', '492D6F82-1DE5-40E2-B3B4-ECB56F96CD98', '3F0AB43C-05F4-4127-877C-ED14F1C14D03', 'E90C384F-3EA8-4964-94C3-EE12FC11B6D4', 'C817D596-0FA3-4925-A266-EE890AB0BD2D', 'B854A978-39B4-4B94-A97C-F2201051B507', '7339FB6E-8E29-4D14-9445-F238703841C8', '9ABD2EF7-EDD7-412B-B216-F6BD2612AD02', 'C468DEEE-3016-4D46-91D3-F6E8FBA6909A', 'F9F91152-AAA4-4AE6-9FB9-FFCC8B9DE6EF', '78FE87F5-BC05-4079-801C-E3BFB3E705B7', '18D128FD-FE2F-4CC7-A6CA-BE205300C2BE', '832DF131-F51A-4BED-AAB4-43D721D8BD91', 'AD9ACDA4-D83A-49A1-9587-3ABB04B0B1A9', '96FEB298-9FCF-48D7-882F-B1D60CCB0E29', 'A801E744-569C-4645-9A4B-A6B5E7B80A03', '3541106F-E3C9-45B7-AAE6-EDBB2C3931B4', '0266FCCE-68CF-433A-875C-54CA36669701', '3FB501F8-ED6F-4D50-874E-87DE0071704C', '296CB1FB-AFB0-43AA-BCDF-C9C58E0E4DDA', '008856CD-B583-4480-9165-9D3E7CC80167', '73A0F334-97E9-45D4-9CFF-905E50005AE0', 'ECE6A528-3139-465D-A409-3AE13B654E27', '5CAE148C-4D46-435A-B292-8378CC6015FF', 'E1DB032D-D544-4631-BAC7-02E2D5ED1C2F', '2F8349CB-21CD-4413-B14C-8DEEC0603E7A', 'E7818164-7A34-471E-B645-58557F03C2C8', '8FBB9512-C5B6-46D3-8B41-4D62996D19D6', '775E18D5-11CB-4F65-917E-B8A9A142761C', 'F5DF5363-42D2-475E-8BE2-F14155E61F05', '4963F803-0B5A-4839-9394-9AB97A301DF6')
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `categoryId` = '0763DB5B-024D-4F37-901D-C483BA83712B' 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` = '0763DB5B-024D-4F37-901D-C483BA83712B' and not exists (select 1 from `PR_VehicleProducts` where PR_VehicleProducts.productid = PR_ProductCategories.productid and
PR_VehicleProducts.deleted_at is null and
PR_VehicleProducts.lngId = 7) 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` = '0763DB5B-024D-4F37-901D-C483BA83712B' and not exists (select 1 from `PR_VehicleProducts` where PR_VehicleProducts.productid = PR_ProductCategories.productid and
PR_VehicleProducts.deleted_at is null and
PR_VehicleProducts.lngId = 7) 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 ('008856CD-B583-4480-9165-9D3E7CC80167', '0F6EF452-2AC4-4665-B09B-C7024138B747', '27103301-3352-4F98-829C-BE6496A8D7B0', '296CB1FB-AFB0-43AA-BCDF-C9C58E0E4DDA', '3147AE75-C2B7-4ECF-BBAA-293ACC34A642', '38968536-F8D3-482C-9898-A99B50D178B4', '3FB501F8-ED6F-4D50-874E-87DE0071704C', '494AD70E-BE91-49AB-A25E-C10DE18F10FD', '4D7E7C15-1A87-4F4A-AB61-D2B50D84FADC', '5EB05269-32BF-4A4E-B7F0-AA2A5EDD3860', '68F2CC5C-F761-4105-B959-D5A0015D7BFA', '6C16116F-DCC5-488E-94D3-03C4003EC253', '72ED845C-F95C-4354-AD57-35ED04FAA2F0', '73A0F334-97E9-45D4-9CFF-905E50005AE0', '78FE87F5-BC05-4079-801C-E3BFB3E705B7', '82FA8D6F-BB75-4C86-8253-3D2D66F17446', '8479F3C9-EA87-43C6-94B5-A5A06C65F75B', '94A9C5C1-5AF8-40D3-BE9C-CF3DF9F293C2', 'A5E7910D-6F52-4B24-82E3-257C67F29CA0', 'A9BACFB6-D55C-47FE-89D8-915345F1AEFA', 'BAEE47CC-657F-436B-8B70-BFCD35D70A9E', 'C468DEEE-3016-4D46-91D3-F6E8FBA6909A', 'E0C20E9F-4C30-4A21-A755-DE0DDEE2876E', '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
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 ('008856CD-B583-4480-9165-9D3E7CC80167', '0F6EF452-2AC4-4665-B09B-C7024138B747', '27103301-3352-4F98-829C-BE6496A8D7B0', '296CB1FB-AFB0-43AA-BCDF-C9C58E0E4DDA', '3147AE75-C2B7-4ECF-BBAA-293ACC34A642', '38968536-F8D3-482C-9898-A99B50D178B4', '3FB501F8-ED6F-4D50-874E-87DE0071704C', '494AD70E-BE91-49AB-A25E-C10DE18F10FD', '4D7E7C15-1A87-4F4A-AB61-D2B50D84FADC', '5EB05269-32BF-4A4E-B7F0-AA2A5EDD3860', '68F2CC5C-F761-4105-B959-D5A0015D7BFA', '6C16116F-DCC5-488E-94D3-03C4003EC253', '72ED845C-F95C-4354-AD57-35ED04FAA2F0', '73A0F334-97E9-45D4-9CFF-905E50005AE0', '78FE87F5-BC05-4079-801C-E3BFB3E705B7', '82FA8D6F-BB75-4C86-8253-3D2D66F17446', '8479F3C9-EA87-43C6-94B5-A5A06C65F75B', '94A9C5C1-5AF8-40D3-BE9C-CF3DF9F293C2', 'A5E7910D-6F52-4B24-82E3-257C67F29CA0', 'A9BACFB6-D55C-47FE-89D8-915345F1AEFA', 'BAEE47CC-657F-436B-8B70-BFCD35D70A9E', 'C468DEEE-3016-4D46-91D3-F6E8FBA6909A', 'E0C20E9F-4C30-4A21-A755-DE0DDEE2876E', 'ECE6A528-3139-465D-A409-3AE13B654E27') 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 ('0763DB5B-024D-4F37-901D-C483BA83712B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `parentId` = '5C2DD4F5-056B-4961-B309-A37BA1BC5A4E' and `slug` = 'cross-bar-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` = '13674F82-0F17-442D-AD28-13A8C7683425' and `slug` = 'pioneer-tradie' 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` = '13674F82-0F17-442D-AD28-13A8C7683425' 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` = '0763DB5B-024D-4F37-901D-C483BA83712B' 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` = 'C468DEEE-3016-4D46-91D3-F6E8FBA6909A' 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') 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 ('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` = 'C468DEEE-3016-4D46-91D3-F6E8FBA6909A' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = 'C468DEEE-3016-4D46-91D3-F6E8FBA6909A' and `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 ('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 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('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 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '27103301-3352-4F98-829C-BE6496A8D7B0' 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') 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 ('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` = '27103301-3352-4F98-829C-BE6496A8D7B0' 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', '8009B2E2-533E-4AF3-B22D-4DDF27BDAA15', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', 'F7C51A49-5297-4EC1-B1EF-71414676433F') and `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 ('F7C51A49-5297-4EC1-B1EF-71414676433F', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '8009B2E2-533E-4AF3-B22D-4DDF27BDAA15') and `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` = '27103301-3352-4F98-829C-BE6496A8D7B0' and `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 ('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 ('F7C51A49-5297-4EC1-B1EF-71414676433F', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '8009B2E2-533E-4AF3-B22D-4DDF27BDAA15') and `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 ('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 ('F7C51A49-5297-4EC1-B1EF-71414676433F', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '8009B2E2-533E-4AF3-B22D-4DDF27BDAA15') and `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` = '6C16116F-DCC5-488E-94D3-03C4003EC253' 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') 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 ('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` = '6C16116F-DCC5-488E-94D3-03C4003EC253' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('05F86187-482A-48FE-ACAC-42454854124F', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '37F77B1A-CA54-4713-A328-B3D865FEFBC2', '5B25E67C-FBDB-489D-A95F-B203FF6CDF2D', '5BB62387-DCE6-4B8E-95AA-594C226A2458', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('5BB62387-DCE6-4B8E-95AA-594C226A2458', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F', '5B25E67C-FBDB-489D-A95F-B203FF6CDF2D', '37F77B1A-CA54-4713-A328-B3D865FEFBC2') and `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` = '6C16116F-DCC5-488E-94D3-03C4003EC253' and `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 ('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 ('5BB62387-DCE6-4B8E-95AA-594C226A2458', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F', '5B25E67C-FBDB-489D-A95F-B203FF6CDF2D', '37F77B1A-CA54-4713-A328-B3D865FEFBC2') and `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 ('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 ('5BB62387-DCE6-4B8E-95AA-594C226A2458', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F', '5B25E67C-FBDB-489D-A95F-B203FF6CDF2D', '37F77B1A-CA54-4713-A328-B3D865FEFBC2') and `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` = '0F6EF452-2AC4-4665-B09B-C7024138B747' 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') 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 ('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` = '0F6EF452-2AC4-4665-B09B-C7024138B747' 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', '5AA1AFF0-E93B-4404-88FC-935187ED4130', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('0A6068D0-6709-4B1D-BD83-800893B31242', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '5AA1AFF0-E93B-4404-88FC-935187ED4130') and `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` = '0F6EF452-2AC4-4665-B09B-C7024138B747' and `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 ('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', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '5AA1AFF0-E93B-4404-88FC-935187ED4130') and `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 ('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', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '5AA1AFF0-E93B-4404-88FC-935187ED4130') and `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` = 'A9BACFB6-D55C-47FE-89D8-915345F1AEFA' 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') 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 ('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` = 'A9BACFB6-D55C-47FE-89D8-915345F1AEFA' 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 ('74069641-FC48-4104-95B9-1F21E4D5EB61', '97634195-3EE0-49C5-B50F-2DE738A4B600', '977432CE-97E9-412E-BA47-89686EBB284D') and `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 ('977432CE-97E9-412E-BA47-89686EBB284D', '74069641-FC48-4104-95B9-1F21E4D5EB61', '97634195-3EE0-49C5-B50F-2DE738A4B600') and `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` = 'A9BACFB6-D55C-47FE-89D8-915345F1AEFA' and `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 ('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 ('977432CE-97E9-412E-BA47-89686EBB284D', '74069641-FC48-4104-95B9-1F21E4D5EB61', '97634195-3EE0-49C5-B50F-2DE738A4B600') and `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 ('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 ('977432CE-97E9-412E-BA47-89686EBB284D', '74069641-FC48-4104-95B9-1F21E4D5EB61', '97634195-3EE0-49C5-B50F-2DE738A4B600') and `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` = '82FA8D6F-BB75-4C86-8253-3D2D66F17446' 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') 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 ('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` = '82FA8D6F-BB75-4C86-8253-3D2D66F17446' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('05F86187-482A-48FE-ACAC-42454854124F', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '5BB62387-DCE6-4B8E-95AA-594C226A2458', '62045C14-9104-4735-8CC2-AFF4C4D87168', '9A915692-6FDF-40C0-AA16-720A3917FCAC', 'C30C4B30-1014-4F63-A46D-AAD0E1430258') and `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 ('5BB62387-DCE6-4B8E-95AA-594C226A2458', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '9A915692-6FDF-40C0-AA16-720A3917FCAC', '05F86187-482A-48FE-ACAC-42454854124F', '62045C14-9104-4735-8CC2-AFF4C4D87168', 'C30C4B30-1014-4F63-A46D-AAD0E1430258') and `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` = '82FA8D6F-BB75-4C86-8253-3D2D66F17446' and `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 ('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 ('5BB62387-DCE6-4B8E-95AA-594C226A2458', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '9A915692-6FDF-40C0-AA16-720A3917FCAC', '05F86187-482A-48FE-ACAC-42454854124F', '62045C14-9104-4735-8CC2-AFF4C4D87168', 'C30C4B30-1014-4F63-A46D-AAD0E1430258') and `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 ('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 ('5BB62387-DCE6-4B8E-95AA-594C226A2458', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '9A915692-6FDF-40C0-AA16-720A3917FCAC', '05F86187-482A-48FE-ACAC-42454854124F', '62045C14-9104-4735-8CC2-AFF4C4D87168', 'C30C4B30-1014-4F63-A46D-AAD0E1430258') and `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` = '72ED845C-F95C-4354-AD57-35ED04FAA2F0' 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') 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 ('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` = '72ED845C-F95C-4354-AD57-35ED04FAA2F0' 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', '74069641-FC48-4104-95B9-1F21E4D5EB61', '8009B2E2-533E-4AF3-B22D-4DDF27BDAA15', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('74069641-FC48-4104-95B9-1F21E4D5EB61', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '8009B2E2-533E-4AF3-B22D-4DDF27BDAA15') and `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` = '72ED845C-F95C-4354-AD57-35ED04FAA2F0' and `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 ('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 ('74069641-FC48-4104-95B9-1F21E4D5EB61', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '8009B2E2-533E-4AF3-B22D-4DDF27BDAA15') and `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 ('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 ('74069641-FC48-4104-95B9-1F21E4D5EB61', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '8009B2E2-533E-4AF3-B22D-4DDF27BDAA15') and `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` = '3147AE75-C2B7-4ECF-BBAA-293ACC34A642' 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') 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 ('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` = '3147AE75-C2B7-4ECF-BBAA-293ACC34A642' 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 ('06BD3DCC-7838-4A67-A0B1-BF9388E2209C', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '74F52094-081A-447F-B51D-AD08920F8F48', '90EE85C5-361F-4498-9BC3-41004388D913') and `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 ('06BD3DCC-7838-4A67-A0B1-BF9388E2209C', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '74F52094-081A-447F-B51D-AD08920F8F48', '90EE85C5-361F-4498-9BC3-41004388D913') and `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` = '3147AE75-C2B7-4ECF-BBAA-293ACC34A642' and `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 ('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 ('06BD3DCC-7838-4A67-A0B1-BF9388E2209C', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '74F52094-081A-447F-B51D-AD08920F8F48', '90EE85C5-361F-4498-9BC3-41004388D913') and `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 ('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 ('06BD3DCC-7838-4A67-A0B1-BF9388E2209C', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '74F52094-081A-447F-B51D-AD08920F8F48', '90EE85C5-361F-4498-9BC3-41004388D913') and `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` = 'A5E7910D-6F52-4B24-82E3-257C67F29CA0' 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') 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 ('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` = 'A5E7910D-6F52-4B24-82E3-257C67F29CA0' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = 'A5E7910D-6F52-4B24-82E3-257C67F29CA0' and `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 ('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 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('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 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '296CB1FB-AFB0-43AA-BCDF-C9C58E0E4DDA' 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', '864AA342-55D0-4D5A-89AE-DCD4F01CE4AE', '91F7FB08-F114-42CE-A8A9-66AE3E7FB1BC', 'ECCC67CC-BA48-4F54-8D20-6F3C4C569743') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('ECCC67CC-BA48-4F54-8D20-6F3C4C569743', '91F7FB08-F114-42CE-A8A9-66AE3E7FB1BC', '0763DB5B-024D-4F37-901D-C483BA83712B', '864AA342-55D0-4D5A-89AE-DCD4F01CE4AE', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '296CB1FB-AFB0-43AA-BCDF-C9C58E0E4DDA' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('05F86187-482A-48FE-ACAC-42454854124F', '0B2D0762-7818-4C72-8CA9-10498FE806D9', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '5BB62387-DCE6-4B8E-95AA-594C226A2458', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('5BB62387-DCE6-4B8E-95AA-594C226A2458', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F', '0B2D0762-7818-4C72-8CA9-10498FE806D9') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '296CB1FB-AFB0-43AA-BCDF-C9C58E0E4DDA' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('ECCC67CC-BA48-4F54-8D20-6F3C4C569743', '91F7FB08-F114-42CE-A8A9-66AE3E7FB1BC', '0763DB5B-024D-4F37-901D-C483BA83712B', '864AA342-55D0-4D5A-89AE-DCD4F01CE4AE', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('5BB62387-DCE6-4B8E-95AA-594C226A2458', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F', '0B2D0762-7818-4C72-8CA9-10498FE806D9') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('ECCC67CC-BA48-4F54-8D20-6F3C4C569743', '91F7FB08-F114-42CE-A8A9-66AE3E7FB1BC', '0763DB5B-024D-4F37-901D-C483BA83712B', '864AA342-55D0-4D5A-89AE-DCD4F01CE4AE', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('5BB62387-DCE6-4B8E-95AA-594C226A2458', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F', '0B2D0762-7818-4C72-8CA9-10498FE806D9') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '3FB501F8-ED6F-4D50-874E-87DE0071704C' 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', 'ECCC67CC-BA48-4F54-8D20-6F3C4C569743') 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 ('0763DB5B-024D-4F37-901D-C483BA83712B', '91F7FB08-F114-42CE-A8A9-66AE3E7FB1BC', 'ECCC67CC-BA48-4F54-8D20-6F3C4C569743', '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` = '3FB501F8-ED6F-4D50-874E-87DE0071704C' 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', '53E9B671-B8A0-4001-9914-1961A135C0D3') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('0A6068D0-6709-4B1D-BD83-800893B31242', '53E9B671-B8A0-4001-9914-1961A135C0D3') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '3FB501F8-ED6F-4D50-874E-87DE0071704C' and `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 ('0763DB5B-024D-4F37-901D-C483BA83712B', '91F7FB08-F114-42CE-A8A9-66AE3E7FB1BC', 'ECCC67CC-BA48-4F54-8D20-6F3C4C569743', '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', '53E9B671-B8A0-4001-9914-1961A135C0D3') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('0763DB5B-024D-4F37-901D-C483BA83712B', '91F7FB08-F114-42CE-A8A9-66AE3E7FB1BC', 'ECCC67CC-BA48-4F54-8D20-6F3C4C569743', '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', '53E9B671-B8A0-4001-9914-1961A135C0D3') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '78FE87F5-BC05-4079-801C-E3BFB3E705B7' 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', '1EE3B390-38D4-42FB-8E1E-0FACC26C3C3C', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '91F7FB08-F114-42CE-A8A9-66AE3E7FB1BC', 'CC10C398-FA6F-4D53-A06D-66B723A76B0A') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('0763DB5B-024D-4F37-901D-C483BA83712B', '91F7FB08-F114-42CE-A8A9-66AE3E7FB1BC', '1EE3B390-38D4-42FB-8E1E-0FACC26C3C3C', 'CC10C398-FA6F-4D53-A06D-66B723A76B0A', '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` = '78FE87F5-BC05-4079-801C-E3BFB3E705B7' 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', '9F51A563-DC0C-4204-804A-A95E5758578C') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('131B1314-78F7-4F05-AFC2-1A170FAF0692', '0A6068D0-6709-4B1D-BD83-800893B31242', '9F51A563-DC0C-4204-804A-A95E5758578C') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '78FE87F5-BC05-4079-801C-E3BFB3E705B7' and `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 ('0763DB5B-024D-4F37-901D-C483BA83712B', '91F7FB08-F114-42CE-A8A9-66AE3E7FB1BC', '1EE3B390-38D4-42FB-8E1E-0FACC26C3C3C', 'CC10C398-FA6F-4D53-A06D-66B723A76B0A', '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', '0A6068D0-6709-4B1D-BD83-800893B31242', '9F51A563-DC0C-4204-804A-A95E5758578C') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('0763DB5B-024D-4F37-901D-C483BA83712B', '91F7FB08-F114-42CE-A8A9-66AE3E7FB1BC', '1EE3B390-38D4-42FB-8E1E-0FACC26C3C3C', 'CC10C398-FA6F-4D53-A06D-66B723A76B0A', '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', '0A6068D0-6709-4B1D-BD83-800893B31242', '9F51A563-DC0C-4204-804A-A95E5758578C') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '8479F3C9-EA87-43C6-94B5-A5A06C65F75B' 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') 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 ('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` = '8479F3C9-EA87-43C6-94B5-A5A06C65F75B' 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 ('11877E7F-7EA1-4FD9-8523-86C7279F9F32', '3AC34934-F911-43F7-ACEA-22F5AFDA1FE0', '5BB62387-DCE6-4B8E-95AA-594C226A2458') and `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 ('5BB62387-DCE6-4B8E-95AA-594C226A2458', '3AC34934-F911-43F7-ACEA-22F5AFDA1FE0', '11877E7F-7EA1-4FD9-8523-86C7279F9F32') and `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` = '8479F3C9-EA87-43C6-94B5-A5A06C65F75B' and `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 ('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 ('5BB62387-DCE6-4B8E-95AA-594C226A2458', '3AC34934-F911-43F7-ACEA-22F5AFDA1FE0', '11877E7F-7EA1-4FD9-8523-86C7279F9F32') and `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 ('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 ('5BB62387-DCE6-4B8E-95AA-594C226A2458', '3AC34934-F911-43F7-ACEA-22F5AFDA1FE0', '11877E7F-7EA1-4FD9-8523-86C7279F9F32') and `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` = 'E0C20E9F-4C30-4A21-A755-DE0DDEE2876E' 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') 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 ('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` = 'E0C20E9F-4C30-4A21-A755-DE0DDEE2876E' 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 ('3B1DD2D8-9B08-4C56-940D-5EE577232839', '74069641-FC48-4104-95B9-1F21E4D5EB61', 'DAB1706C-1C57-4B3F-BD24-923BFB275F35') and `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 ('74069641-FC48-4104-95B9-1F21E4D5EB61', 'DAB1706C-1C57-4B3F-BD24-923BFB275F35', '3B1DD2D8-9B08-4C56-940D-5EE577232839') and `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` = 'E0C20E9F-4C30-4A21-A755-DE0DDEE2876E' and `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 ('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 ('74069641-FC48-4104-95B9-1F21E4D5EB61', 'DAB1706C-1C57-4B3F-BD24-923BFB275F35', '3B1DD2D8-9B08-4C56-940D-5EE577232839') and `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 ('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 ('74069641-FC48-4104-95B9-1F21E4D5EB61', 'DAB1706C-1C57-4B3F-BD24-923BFB275F35', '3B1DD2D8-9B08-4C56-940D-5EE577232839') and `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` = '68F2CC5C-F761-4105-B959-D5A0015D7BFA' 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') 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 ('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` = '68F2CC5C-F761-4105-B959-D5A0015D7BFA' 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 ('227EB8BE-AFE0-4248-AD3C-E133B6E0C478', 'BAA901D1-F5BB-4DDD-8E51-30F303C791F8') and `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 ('BAA901D1-F5BB-4DDD-8E51-30F303C791F8', '227EB8BE-AFE0-4248-AD3C-E133B6E0C478') and `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` = '68F2CC5C-F761-4105-B959-D5A0015D7BFA' and `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 ('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 ('BAA901D1-F5BB-4DDD-8E51-30F303C791F8', '227EB8BE-AFE0-4248-AD3C-E133B6E0C478') and `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 ('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 ('BAA901D1-F5BB-4DDD-8E51-30F303C791F8', '227EB8BE-AFE0-4248-AD3C-E133B6E0C478') and `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` = '4D7E7C15-1A87-4F4A-AB61-D2B50D84FADC' 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') 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 ('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` = '4D7E7C15-1A87-4F4A-AB61-D2B50D84FADC' 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 ('7C9F96D7-7A79-4C14-BE82-0483983E789F', 'F7C51A49-5297-4EC1-B1EF-71414676433F') and `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 ('F7C51A49-5297-4EC1-B1EF-71414676433F', '7C9F96D7-7A79-4C14-BE82-0483983E789F') and `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` = '4D7E7C15-1A87-4F4A-AB61-D2B50D84FADC' and `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 ('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 ('F7C51A49-5297-4EC1-B1EF-71414676433F', '7C9F96D7-7A79-4C14-BE82-0483983E789F') and `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 ('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 ('F7C51A49-5297-4EC1-B1EF-71414676433F', '7C9F96D7-7A79-4C14-BE82-0483983E789F') and `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` = '94A9C5C1-5AF8-40D3-BE9C-CF3DF9F293C2' 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') 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 ('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` = '94A9C5C1-5AF8-40D3-BE9C-CF3DF9F293C2' 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', '5BB62387-DCE6-4B8E-95AA-594C226A2458', 'AD8B1681-9882-498D-952B-C02B007A041E') and `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 ('5BB62387-DCE6-4B8E-95AA-594C226A2458', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'AD8B1681-9882-498D-952B-C02B007A041E') and `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` = '94A9C5C1-5AF8-40D3-BE9C-CF3DF9F293C2' and `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 ('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 ('5BB62387-DCE6-4B8E-95AA-594C226A2458', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'AD8B1681-9882-498D-952B-C02B007A041E') and `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 ('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 ('5BB62387-DCE6-4B8E-95AA-594C226A2458', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'AD8B1681-9882-498D-952B-C02B007A041E') and `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` = '008856CD-B583-4480-9165-9D3E7CC80167' 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', '74021267-51CD-4522-AEBE-19BE83181D3F', '91F7FB08-F114-42CE-A8A9-66AE3E7FB1BC', 'ECCC67CC-BA48-4F54-8D20-6F3C4C569743') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('ECCC67CC-BA48-4F54-8D20-6F3C4C569743', '0763DB5B-024D-4F37-901D-C483BA83712B', '91F7FB08-F114-42CE-A8A9-66AE3E7FB1BC', '74021267-51CD-4522-AEBE-19BE83181D3F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '008856CD-B583-4480-9165-9D3E7CC80167' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('05F86187-482A-48FE-ACAC-42454854124F', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '5BB62387-DCE6-4B8E-95AA-594C226A2458', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('5BB62387-DCE6-4B8E-95AA-594C226A2458', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '008856CD-B583-4480-9165-9D3E7CC80167' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('ECCC67CC-BA48-4F54-8D20-6F3C4C569743', '0763DB5B-024D-4F37-901D-C483BA83712B', '91F7FB08-F114-42CE-A8A9-66AE3E7FB1BC', '74021267-51CD-4522-AEBE-19BE83181D3F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('5BB62387-DCE6-4B8E-95AA-594C226A2458', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('ECCC67CC-BA48-4F54-8D20-6F3C4C569743', '0763DB5B-024D-4F37-901D-C483BA83712B', '91F7FB08-F114-42CE-A8A9-66AE3E7FB1BC', '74021267-51CD-4522-AEBE-19BE83181D3F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('5BB62387-DCE6-4B8E-95AA-594C226A2458', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '73A0F334-97E9-45D4-9CFF-905E50005AE0' 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', '1EE3B390-38D4-42FB-8E1E-0FACC26C3C3C', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '91F7FB08-F114-42CE-A8A9-66AE3E7FB1BC', 'CC10C398-FA6F-4D53-A06D-66B723A76B0A') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('1EE3B390-38D4-42FB-8E1E-0FACC26C3C3C', 'CC10C398-FA6F-4D53-A06D-66B723A76B0A', '0763DB5B-024D-4F37-901D-C483BA83712B', '91F7FB08-F114-42CE-A8A9-66AE3E7FB1BC', '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` = '73A0F334-97E9-45D4-9CFF-905E50005AE0' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('05F86187-482A-48FE-ACAC-42454854124F', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '5BB62387-DCE6-4B8E-95AA-594C226A2458', '9F51A563-DC0C-4204-804A-A95E5758578C', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where `productId` in ('5BB62387-DCE6-4B8E-95AA-594C226A2458', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F', '9F51A563-DC0C-4204-804A-A95E5758578C') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '73A0F334-97E9-45D4-9CFF-905E50005AE0' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('1EE3B390-38D4-42FB-8E1E-0FACC26C3C3C', 'CC10C398-FA6F-4D53-A06D-66B723A76B0A', '0763DB5B-024D-4F37-901D-C483BA83712B', '91F7FB08-F114-42CE-A8A9-66AE3E7FB1BC', '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 ('5BB62387-DCE6-4B8E-95AA-594C226A2458', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F', '9F51A563-DC0C-4204-804A-A95E5758578C') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('1EE3B390-38D4-42FB-8E1E-0FACC26C3C3C', 'CC10C398-FA6F-4D53-A06D-66B723A76B0A', '0763DB5B-024D-4F37-901D-C483BA83712B', '91F7FB08-F114-42CE-A8A9-66AE3E7FB1BC', '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 ('5BB62387-DCE6-4B8E-95AA-594C226A2458', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F', '9F51A563-DC0C-4204-804A-A95E5758578C') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '494AD70E-BE91-49AB-A25E-C10DE18F10FD' 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') 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 ('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` = '494AD70E-BE91-49AB-A25E-C10DE18F10FD' 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 ('044BD587-A778-4C20-A91A-3883620ABC3D', 'B9DF1F4F-D8A0-4695-ACD7-6DD8E62FDD20') and `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 ('044BD587-A778-4C20-A91A-3883620ABC3D', 'B9DF1F4F-D8A0-4695-ACD7-6DD8E62FDD20') and `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` = '494AD70E-BE91-49AB-A25E-C10DE18F10FD' and `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 ('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 ('044BD587-A778-4C20-A91A-3883620ABC3D', 'B9DF1F4F-D8A0-4695-ACD7-6DD8E62FDD20') and `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 ('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 ('044BD587-A778-4C20-A91A-3883620ABC3D', 'B9DF1F4F-D8A0-4695-ACD7-6DD8E62FDD20') and `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` = 'BAEE47CC-657F-436B-8B70-BFCD35D70A9E' 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') 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 ('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` = 'BAEE47CC-657F-436B-8B70-BFCD35D70A9E' 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 ('137ACDD7-0579-4E90-8474-3652E7A60134', '5BB62387-DCE6-4B8E-95AA-594C226A2458', '977432CE-97E9-412E-BA47-89686EBB284D') and `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 ('137ACDD7-0579-4E90-8474-3652E7A60134', '5BB62387-DCE6-4B8E-95AA-594C226A2458', '977432CE-97E9-412E-BA47-89686EBB284D') and `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` = 'BAEE47CC-657F-436B-8B70-BFCD35D70A9E' and `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 ('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 ('137ACDD7-0579-4E90-8474-3652E7A60134', '5BB62387-DCE6-4B8E-95AA-594C226A2458', '977432CE-97E9-412E-BA47-89686EBB284D') and `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 ('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 ('137ACDD7-0579-4E90-8474-3652E7A60134', '5BB62387-DCE6-4B8E-95AA-594C226A2458', '977432CE-97E9-412E-BA47-89686EBB284D') and `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` = '5EB05269-32BF-4A4E-B7F0-AA2A5EDD3860' 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', '99AE33D6-3212-4C77-8A8A-F97CF1039C15') 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 ('0763DB5B-024D-4F37-901D-C483BA83712B', '99AE33D6-3212-4C77-8A8A-F97CF1039C15', '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` = '5EB05269-32BF-4A4E-B7F0-AA2A5EDD3860' 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', '1759B7B8-824F-451D-9CAF-BD72E4F58BB6', '6960CA14-58B6-4361-892B-53573BDFE1DC', 'DAB1706C-1C57-4B3F-BD24-923BFB275F35') and `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', 'DAB1706C-1C57-4B3F-BD24-923BFB275F35', '6960CA14-58B6-4361-892B-53573BDFE1DC', '1759B7B8-824F-451D-9CAF-BD72E4F58BB6') and `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` = '5EB05269-32BF-4A4E-B7F0-AA2A5EDD3860' and `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 ('0763DB5B-024D-4F37-901D-C483BA83712B', '99AE33D6-3212-4C77-8A8A-F97CF1039C15', '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', 'DAB1706C-1C57-4B3F-BD24-923BFB275F35', '6960CA14-58B6-4361-892B-53573BDFE1DC', '1759B7B8-824F-451D-9CAF-BD72E4F58BB6') and `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 ('0763DB5B-024D-4F37-901D-C483BA83712B', '99AE33D6-3212-4C77-8A8A-F97CF1039C15', '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', 'DAB1706C-1C57-4B3F-BD24-923BFB275F35', '6960CA14-58B6-4361-892B-53573BDFE1DC', '1759B7B8-824F-451D-9CAF-BD72E4F58BB6') and `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` = '38968536-F8D3-482C-9898-A99B50D178B4' 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') 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 ('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` = '38968536-F8D3-482C-9898-A99B50D178B4' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '38968536-F8D3-482C-9898-A99B50D178B4' and `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 ('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 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('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 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `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/cross-bar-roof-racks/pioneer-tradie" "REDIRECT_SCRIPT_URI" => "https://rrweb.webexpertsnepal.com/en-au/products/roof-racks/cross-bar-roof-racks/pioneer-tradie" "REDIRECT_HTTPS" => "on" "REDIRECT_SSL_TLS_SNI" => "rrweb.webexpertsnepal.com" "REDIRECT_STATUS" => "200" "SCRIPT_URL" => "/en-au/products/roof-racks/cross-bar-roof-racks/pioneer-tradie" "SCRIPT_URI" => "https://rrweb.webexpertsnepal.com/en-au/products/roof-racks/cross-bar-roof-racks/pioneer-tradie" "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" => "45917" "REDIRECT_URL" => "/en-au/products/roof-racks/cross-bar-roof-racks/pioneer-tradie" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/en-au/products/roof-racks/cross-bar-roof-racks/pioneer-tradie" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1744400321.6946 "REQUEST_TIME" => 1744400321 ]
[]
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 19:38:41 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlpLYU5aVVl2OWJWQkM3WWU0UnFTK1E9PSIsInZhbHVlIjoiOCtvb0F0bW5nY0tUc20xMjY0MW1wOWZKYUZxajEvSFJhSjREaGUwem5RajFNMHFQNUUvaGMvLzdlRllPN1RiekdlK3MvZkVwZ2xGaUovakZnTjQzQlRyOWZoZGJjdXBJZGh2Y2RDSUtLZlVhQWx6bFBnS1M2QWhEUlpMcG5PcWQiLCJtYWMiOiJlOGEwNGUxYjk0NGIzYzcxNjBlMzM2NWUxOGQ5ZmQ1OGQzYTlhOTBjYjU3OWNjMjBhNmNjNTI2OGVlN2I4YzMwIiwidGFnIjoiIn0%3D; expires=Mon, 12 May 2025 05:38:42 GMT; Max-Age=2628000; path=/ ◀XSRF-TOKEN=eyJpdiI6IlpLYU5aVVl2OWJWQkM3WWU0UnFTK1E9PSIsInZhbHVlIjoiOCtvb0F0bW5nY0tUc20xMjY0MW1wOWZKYUZxajEvSFJhSjREaGUwem5RajFNMHFQNUUvaGMvLzdlRllPN1RiekdlK3MvZ ▶" 1 => "rhino_rack_session=eyJpdiI6IlpaTWljcXNGVDFWWS90djBJZzZ5TVE9PSIsInZhbHVlIjoiWTI1WjRPdkFHZkhmanBJZld2UGV5UUJYK1N1cVVhVmYyQ0ZybXd4c2JKbVZ0WWZRTzlBdU9YNElZVjRaVnVaNmhjTTgyT2YyakFiM2FFeVBZVFE2TmNybUJKRkh6QUx6NWZxWXNCczVwbjNkeHVVb3J3WnlmVkNZTWVqZFZrbVciLCJtYWMiOiI1ODVjNTY1ZTJlMDczZDhkYmQwZTRmYTNjODExZDE5ZThhOGUyM2FjMDQ2MDU3NDFhNTM4ODM4MjBkNzBiY2VkIiwidGFnIjoiIn0%3D; expires=Mon, 12 May 2025 05:38:42 GMT; Max-Age=2628000; path=/; httponly ◀rhino_rack_session=eyJpdiI6IlpaTWljcXNGVDFWWS90djBJZzZ5TVE9PSIsInZhbHVlIjoiWTI1WjRPdkFHZkhmanBJZld2UGV5UUJYK1N1cVVhVmYyQ0ZybXd4c2JKbVZ0WWZRTzlBdU9YNElZVjRaVnVaN ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlpLYU5aVVl2OWJWQkM3WWU0UnFTK1E9PSIsInZhbHVlIjoiOCtvb0F0bW5nY0tUc20xMjY0MW1wOWZKYUZxajEvSFJhSjREaGUwem5RajFNMHFQNUUvaGMvLzdlRllPN1RiekdlK3MvZkVwZ2xGaUovakZnTjQzQlRyOWZoZGJjdXBJZGh2Y2RDSUtLZlVhQWx6bFBnS1M2QWhEUlpMcG5PcWQiLCJtYWMiOiJlOGEwNGUxYjk0NGIzYzcxNjBlMzM2NWUxOGQ5ZmQ1OGQzYTlhOTBjYjU3OWNjMjBhNmNjNTI2OGVlN2I4YzMwIiwidGFnIjoiIn0%3D; expires=Mon, 12-May-2025 05:38:42 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlpLYU5aVVl2OWJWQkM3WWU0UnFTK1E9PSIsInZhbHVlIjoiOCtvb0F0bW5nY0tUc20xMjY0MW1wOWZKYUZxajEvSFJhSjREaGUwem5RajFNMHFQNUUvaGMvLzdlRllPN1RiekdlK3MvZ ▶" 1 => "rhino_rack_session=eyJpdiI6IlpaTWljcXNGVDFWWS90djBJZzZ5TVE9PSIsInZhbHVlIjoiWTI1WjRPdkFHZkhmanBJZld2UGV5UUJYK1N1cVVhVmYyQ0ZybXd4c2JKbVZ0WWZRTzlBdU9YNElZVjRaVnVaNmhjTTgyT2YyakFiM2FFeVBZVFE2TmNybUJKRkh6QUx6NWZxWXNCczVwbjNkeHVVb3J3WnlmVkNZTWVqZFZrbVciLCJtYWMiOiI1ODVjNTY1ZTJlMDczZDhkYmQwZTRmYTNjODExZDE5ZThhOGUyM2FjMDQ2MDU3NDFhNTM4ODM4MjBkNzBiY2VkIiwidGFnIjoiIn0%3D; expires=Mon, 12-May-2025 05:38:42 GMT; path=/; httponly ◀rhino_rack_session=eyJpdiI6IlpaTWljcXNGVDFWWS90djBJZzZ5TVE9PSIsInZhbHVlIjoiWTI1WjRPdkFHZkhmanBJZld2UGV5UUJYK1N1cVVhVmYyQ0ZybXd4c2JKbVZ0WWZRTzlBdU9YNElZVjRaVnVaN ▶" ] ]
0 of 0array:9 [▼ "_token" => "MAwS0VeY3LnWRtRhkCBvYPzPMJEZVl3cNFAxgd9c" "country" => "au" "_flash" => array:2 [▶ "old" => [] "new" => [] ] "lngId" => 7 "session_culture" => "en-au" "random_number" => 52 "locale" => "en" "_previous" => array:1 [▶ "url" => "https://rrweb.webexpertsnepal.com/en-au/products/roof-racks/cross-bar-roof-racks/pioneer-tradie" ] "PHPDEBUGBAR_STACK_DATA" => [] ]