For unbeatable performance and looks, pair your Pioneer Platform with a Backbone mounting system.
For unbeatable performance and looks, pair your Pioneer Platform with a Backbone mounting system.
Clearance
Clearance
Clearance
Clearance
Clearance
Clearance
Clearance
Clearance
Clearance
Clearance
Clearance
1 x Application (99.55%) | 971.87ms |
1 x Booting (0.45%) | 4.41ms |
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 `Country` where `id` in ('2', '3', '4', '5', '1') and `Country`.`deleted_at` is null order by `title` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `Language` where `Language`.`countryid` in (1, 2, 3, 4, 5) and `Language`.`deleted_at` is null and `isActive` = 1 order by `title` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `Language` where `culture` = 'en-au' and `Language`.`deleted_at` is null and `isActive` = 1 limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `menus` where `position` = 1 and `parent_id` is null and `menus`.`deleted_at` is null and (`menus`.`lngId` is null or `menus`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `order` asc, `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `menus` where `menus`.`parent_id` in (4, 8, 9, 10, 11, 1089) and `menus`.`deleted_at` is null and (`menus`.`lngId` is null or `menus`.`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 `pages` where `pages`.`id` in (337, 340, 341, 2667) 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 `pages` where `pages`.`id` = 2646 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 limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `pages` where `pages`.`id` = 1304 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 limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `pages` where `pages`.`id` = 341 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 limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `pages` where `pages`.`id` = 662 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 limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `pages` where `pages`.`id` = 130 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 limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `pages` where `pages`.`id` = 2320 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 limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `pages` where `pages`.`id` = 2722 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 limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `pages` where `pages`.`id` = 3452 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 limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `pages` where `pages`.`id` = 182 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 limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `pages` where `pages`.`id` = 352 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 limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `pages` where `pages`.`id` = 2361 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 limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `menus` where `position` = 2 and `parent_id` is null and `menus`.`deleted_at` is null and (`menus`.`lngId` is null or `menus`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `order` asc, `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `menus` where `menus`.`parent_id` in (53, 61, 62, 63, 154, 157, 158, 204, 209, 880, 943, 974, 975, 984, 985, 986, 987, 1083) and `menus`.`deleted_at` is null and (`menus`.`lngId` is null or `menus`.`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 `pages` where `pages`.`id` in (130, 174, 340, 341, 342, 352, 576, 662, 1307, 2646, 2667, 2982, 3169, 3170, 3183, 3452) 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 `menus` where `position` = 4 and `parent_id` is null and `menus`.`deleted_at` is null and (`menus`.`lngId` is null or `menus`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `order` asc, `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `menus` where `menus`.`parent_id` in (166, 167, 169, 260, 261, 264, 267, 1002) and `menus`.`deleted_at` is null and (`menus`.`lngId` is null or `menus`.`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 `pages` where `pages`.`id` in (216, 232, 240, 248, 342, 362, 556, 3252) 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_Categories` where `parentId` is null and `PR_Categories`.`deleted_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 `order` asc, `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`parentId` in ('2DBF99C2-B887-45CC-B040-C11B8685B420', '30E5B649-D124-444D-90E8-15700ACFA643', '368F6AEA-1878-42A3-BD33-61B899A802DB', '3A0BDA4C-DFC8-4C88-AF5E-A1E56D78ECB7', '42FB0E18-E8BA-4F1C-9A44-AC43B4AA4108', '54891694-B598-4749-9332-822476DA4E14', '5C2DD4F5-056B-4961-B309-A37BA1BC5A4E', '6693BD7E-0B35-49EE-9F86-03F232998927', '7A6D08A3-DB1C-445C-8FEE-52E108F5E215', '8AA3B9B8-D2B6-4D55-A3FC-0395CD31FC52', 'B1335701-77AD-48E8-8384-13EE0A4C7AA6', 'D2377297-85F4-4F80-A7C1-97C4C9D341B0', 'F1D7419B-13D1-4D95-8AF7-0D95AED30BF2') and `PR_Categories`.`deleted_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 `order` asc, `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2DBF99C2-B887-45CC-B040-C11B8685B420', '30E5B649-D124-444D-90E8-15700ACFA643', '368F6AEA-1878-42A3-BD33-61B899A802DB', '3A0BDA4C-DFC8-4C88-AF5E-A1E56D78ECB7', '42FB0E18-E8BA-4F1C-9A44-AC43B4AA4108', '54891694-B598-4749-9332-822476DA4E14', '5C2DD4F5-056B-4961-B309-A37BA1BC5A4E', '6693BD7E-0B35-49EE-9F86-03F232998927', '7A6D08A3-DB1C-445C-8FEE-52E108F5E215', '8AA3B9B8-D2B6-4D55-A3FC-0395CD31FC52', 'B1335701-77AD-48E8-8384-13EE0A4C7AA6', 'D2377297-85F4-4F80-A7C1-97C4C9D341B0', 'F1D7419B-13D1-4D95-8AF7-0D95AED30BF2') and `PR_Categories`.`deleted_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 `lngId` = '7' and `PR_Categories`.`categoryId` in ('2DBF99C2-B887-45CC-B040-C11B8685B420', '30E5B649-D124-444D-90E8-15700ACFA643', '368F6AEA-1878-42A3-BD33-61B899A802DB', '3A0BDA4C-DFC8-4C88-AF5E-A1E56D78ECB7', '42FB0E18-E8BA-4F1C-9A44-AC43B4AA4108', '54891694-B598-4749-9332-822476DA4E14', '5C2DD4F5-056B-4961-B309-A37BA1BC5A4E', '6693BD7E-0B35-49EE-9F86-03F232998927', '7A6D08A3-DB1C-445C-8FEE-52E108F5E215', '8AA3B9B8-D2B6-4D55-A3FC-0395CD31FC52', 'B1335701-77AD-48E8-8384-13EE0A4C7AA6', 'D2377297-85F4-4F80-A7C1-97C4C9D341B0', 'F1D7419B-13D1-4D95-8AF7-0D95AED30BF2') and `PR_Categories`.`deleted_at` is null and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `key`, `value` from `settings` where `settings`.`deleted_at` is null and (`settings`.`lngId` is null or `settings`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `parentId` is null and `slug` = 'spares-brackets-components' and `PR_Categories`.`deleted_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` = '3A0BDA4C-DFC8-4C88-AF5E-A1E56D78ECB7' and `slug` = 'roof-rack-parts' and `PR_Categories`.`deleted_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` = '1F1129D9-79D8-4138-A3E2-926E9090C4FE' and `slug` = 'rhino-rack-backbone' and `PR_Categories`.`deleted_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` = 'B2CDA476-C8A3-4130-B00A-2DF9161E4632' 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-000000000001', '14F3FB81-8947-4E5E-BB23-000000000002', '14F3FB81-8947-4E5E-BB23-000000000003', '14F3FB81-8947-4E5E-BB23-2F17B1452EF2') 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-000000000001', '14F3FB81-8947-4E5E-BB23-000000000002', '14F3FB81-8947-4E5E-BB23-000000000003', '14F3FB81-8947-4E5E-BB23-2F17B1452EF2') and `PR_SpecificationProperties`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_SpecificationPropertyMasterData` where `PR_SpecificationPropertyMasterData`.`specificationPropertyId` in ('D78F6505-9766-4732-A858-000000000001', 'D78F6505-9766-4732-A858-000000000002', 'D78F6505-9766-4732-A858-000000000003', '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` = 'B2CDA476-C8A3-4130-B00A-2DF9161E4632' and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('003379CB-8A6C-479F-B8C7-34F193129999', '02C352BC-BA66-478E-953D-AFB824958CF0', '063CB28C-0EAC-49AC-9FC9-880BF355553C', '0CC6E1BD-5B8B-4956-90BC-5D6E60E4B248', '0CC89478-8974-478C-BFF6-927AD4A8D830', '0D93AE9C-3014-451D-9EF1-7BBDF5B52B50', '0DCEBC73-9BFB-4D66-892F-452CCBFE6CF3', '100974F9-AFE2-454F-A473-CF28857FEAD6', '10097E8C-907B-41A5-B234-E5D27CEA0EEE', '1313458F-A498-454B-AFC3-993A5FFBD868', '1749FDEC-9CDB-4727-98AF-962AA12CF20E', '1CD191EC-91E3-4010-8821-A46AC0CC5FE8', '1F393FE2-DF4D-497E-BD0A-2AE7EE5E403A', '1FC51253-3095-4CEA-A616-29EE562B8F51', '227EB8BE-AFE0-4248-AD3C-E133B6E0C478', '2369F01F-7BA2-41FC-852E-8F603D41C638', '2426E1D7-A8A2-4BD5-8777-98DE2663FC9B', '279405D2-4B00-418C-AE30-AF3A78CE9304', '34BBAB4E-47DD-4D8B-A855-F504905F4A89', '375F2858-2294-4C8B-B1EC-C9896FE0609C', '380D3E41-77CE-45E6-AB90-14D6647A8A8E', '3954246E-AE9D-4506-B49B-B3A74BB1F491', '398AF70F-4A24-4BE7-8368-AAE19D0CEFBC', '3A53EACE-E543-4EF2-9647-1350AAFFDF16', '3E316085-DB84-4CE0-83F5-BF7E6D4EB38D', '45FEFF38-8D8A-4960-A86D-174E22FFDC5E', '48BAF303-9925-4A9D-9110-4213FFB2CCA9', '4C24F1AD-C342-4AE8-9A2A-F4E70BE1F7BD', '5098AA75-99F8-4D6F-937C-17D80149BFC1', '51B2BF58-B7D6-4915-A91D-1A5C81495528', '566106BE-4D09-41A0-81D7-3F28C0A85E58', '5C8A9CA1-38FD-4A97-9403-74A839DA1882', '6745A1AA-E52D-4B8F-AD63-2F113F0E426B', '7C9F96D7-7A79-4C14-BE82-0483983E789F', '8A388678-E132-4CAB-9003-DF7970234A64', '8EA23896-2F60-43C3-AAE9-A14520012A11', '9690B2C0-8DA3-446A-9078-51A7D3593279', '9F6ED7C4-AE10-4988-9755-913E3AD51118', 'A6355BE5-97FE-4CFE-99FC-22C22714C481', 'A655C4F7-F8E8-46A4-B822-2261DCA889C5', 'A9DC0478-C741-477B-85E6-5FEB99A83B65', 'B5668A80-16AA-404F-A6C7-A45FFDC2D14B', 'B884E2C6-4BC0-466D-87E5-5F0539E3AE75', 'B89619BB-A4EC-447B-8DE6-275A7C6ADF1F', 'B89BB4FF-A507-4D64-A966-B6C0A5D1B31E', 'B91512A1-DA24-4DD7-AD49-5BCBAE7CCCE6', 'B9DF1F4F-D8A0-4695-ACD7-6DD8E62FDD20', 'C7B24A8F-D55A-4FFC-BD89-C38A6978F20D', 'C8EBCF90-2802-4255-93B7-DE798D0F2EE8', 'CCE1A2BC-8BAA-40AF-AA1B-F9BBDE6F5383', 'CD00CC5F-BC78-4B81-BFD3-CCC311079A6E', 'CD9B6D8F-8DCE-4C3D-B46C-01D9BFEC9D06', 'CE88120A-5668-4A34-B7E3-0A830117224A', 'CFBE859B-E1CA-4504-9F77-E5FA94AF26DD', 'D180CD17-50A8-4984-9FA5-E9AAFDB0B79B', 'D1F75239-AB18-4369-9D94-2912126462E3', 'D85DFA94-6F5C-4008-8F1E-063D7EC6BCC9', 'DE8CBD7E-F33D-4D35-BB2C-3E2AA20AC510', 'E27C36B9-15DC-4563-896C-0329D70F3AF4', 'E27C36B9-15DC-4563-896C-0329D70F3AF6', 'E84AA333-F294-4440-A4BC-5035DF721FB2', 'F118CA22-8EA6-40E2-B4C3-A3D174773E68', 'F39533E0-DBEE-4733-AF6E-F4274EE92773', 'F4091097-7160-4DDE-8EA0-E3C0E69AFBE8', 'F947BA60-E3DD-4727-A95F-3CF398D9BD08', 'F950CE65-0011-4E6A-903E-9749FD0280D1') and `PR_Products`.`deleted_at` 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 ('B5668A80-16AA-404F-A6C7-A45FFDC2D14B', 'CD00CC5F-BC78-4B81-BFD3-CCC311079A6E', 'C7B24A8F-D55A-4FFC-BD89-C38A6978F20D', '380D3E41-77CE-45E6-AB90-14D6647A8A8E', 'CFBE859B-E1CA-4504-9F77-E5FA94AF26DD', '1CD191EC-91E3-4010-8821-A46AC0CC5FE8', 'B91512A1-DA24-4DD7-AD49-5BCBAE7CCCE6', '3A53EACE-E543-4EF2-9647-1350AAFFDF16', '9690B2C0-8DA3-446A-9078-51A7D3593279', '6745A1AA-E52D-4B8F-AD63-2F113F0E426B', '1FC51253-3095-4CEA-A616-29EE562B8F51', '3E316085-DB84-4CE0-83F5-BF7E6D4EB38D', '227EB8BE-AFE0-4248-AD3C-E133B6E0C478', '5C8A9CA1-38FD-4A97-9403-74A839DA1882', '34BBAB4E-47DD-4D8B-A855-F504905F4A89', '3954246E-AE9D-4506-B49B-B3A74BB1F491', '45FEFF38-8D8A-4960-A86D-174E22FFDC5E', '1313458F-A498-454B-AFC3-993A5FFBD868', 'E27C36B9-15DC-4563-896C-0329D70F3AF4', 'A6355BE5-97FE-4CFE-99FC-22C22714C481', '8EA23896-2F60-43C3-AAE9-A14520012A11', '2426E1D7-A8A2-4BD5-8777-98DE2663FC9B', '003379CB-8A6C-479F-B8C7-34F193129999', '398AF70F-4A24-4BE7-8368-AAE19D0CEFBC', 'A9DC0478-C741-477B-85E6-5FEB99A83B65', '0DCEBC73-9BFB-4D66-892F-452CCBFE6CF3', '8A388678-E132-4CAB-9003-DF7970234A64', 'B89BB4FF-A507-4D64-A966-B6C0A5D1B31E', 'A655C4F7-F8E8-46A4-B822-2261DCA889C5', 'F118CA22-8EA6-40E2-B4C3-A3D174773E68', 'D85DFA94-6F5C-4008-8F1E-063D7EC6BCC9', 'CCE1A2BC-8BAA-40AF-AA1B-F9BBDE6F5383', '4C24F1AD-C342-4AE8-9A2A-F4E70BE1F7BD', 'D180CD17-50A8-4984-9FA5-E9AAFDB0B79B', '0CC89478-8974-478C-BFF6-927AD4A8D830', 'C8EBCF90-2802-4255-93B7-DE798D0F2EE8', '375F2858-2294-4C8B-B1EC-C9896FE0609C', 'F950CE65-0011-4E6A-903E-9749FD0280D1', '7C9F96D7-7A79-4C14-BE82-0483983E789F', 'CD9B6D8F-8DCE-4C3D-B46C-01D9BFEC9D06', '9F6ED7C4-AE10-4988-9755-913E3AD51118', '51B2BF58-B7D6-4915-A91D-1A5C81495528', 'F947BA60-E3DD-4727-A95F-3CF398D9BD08', 'B884E2C6-4BC0-466D-87E5-5F0539E3AE75', 'B9DF1F4F-D8A0-4695-ACD7-6DD8E62FDD20', 'F4091097-7160-4DDE-8EA0-E3C0E69AFBE8', 'F39533E0-DBEE-4733-AF6E-F4274EE92773', '0CC6E1BD-5B8B-4956-90BC-5D6E60E4B248', '48BAF303-9925-4A9D-9110-4213FFB2CCA9', '566106BE-4D09-41A0-81D7-3F28C0A85E58', 'CE88120A-5668-4A34-B7E3-0A830117224A')
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `categoryId` = 'B2CDA476-C8A3-4130-B00A-2DF9161E4632' and `PR_Categories`.`deleted_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` = 'B2CDA476-C8A3-4130-B00A-2DF9161E4632' 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` = 'B2CDA476-C8A3-4130-B00A-2DF9161E4632' 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 ('003379CB-8A6C-479F-B8C7-34F193129999', '0DCEBC73-9BFB-4D66-892F-452CCBFE6CF3', '227EB8BE-AFE0-4248-AD3C-E133B6E0C478', '34BBAB4E-47DD-4D8B-A855-F504905F4A89', '380D3E41-77CE-45E6-AB90-14D6647A8A8E', '3954246E-AE9D-4506-B49B-B3A74BB1F491', '398AF70F-4A24-4BE7-8368-AAE19D0CEFBC', '3A53EACE-E543-4EF2-9647-1350AAFFDF16', '3E316085-DB84-4CE0-83F5-BF7E6D4EB38D', '45FEFF38-8D8A-4960-A86D-174E22FFDC5E', '5C8A9CA1-38FD-4A97-9403-74A839DA1882', '8EA23896-2F60-43C3-AAE9-A14520012A11', '9690B2C0-8DA3-446A-9078-51A7D3593279', 'A6355BE5-97FE-4CFE-99FC-22C22714C481', 'A655C4F7-F8E8-46A4-B822-2261DCA889C5', 'A9DC0478-C741-477B-85E6-5FEB99A83B65', 'B5668A80-16AA-404F-A6C7-A45FFDC2D14B', 'B89BB4FF-A507-4D64-A966-B6C0A5D1B31E', 'B91512A1-DA24-4DD7-AD49-5BCBAE7CCCE6', 'C7B24A8F-D55A-4FFC-BD89-C38A6978F20D', 'CD00CC5F-BC78-4B81-BFD3-CCC311079A6E', 'E27C36B9-15DC-4563-896C-0329D70F3AF4', 'F118CA22-8EA6-40E2-B4C3-A3D174773E68', 'F4091097-7160-4DDE-8EA0-E3C0E69AFBE8') and `PR_Products`.`deleted_at` 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 ('003379CB-8A6C-479F-B8C7-34F193129999', '0DCEBC73-9BFB-4D66-892F-452CCBFE6CF3', '227EB8BE-AFE0-4248-AD3C-E133B6E0C478', '34BBAB4E-47DD-4D8B-A855-F504905F4A89', '380D3E41-77CE-45E6-AB90-14D6647A8A8E', '3954246E-AE9D-4506-B49B-B3A74BB1F491', '398AF70F-4A24-4BE7-8368-AAE19D0CEFBC', '3A53EACE-E543-4EF2-9647-1350AAFFDF16', '3E316085-DB84-4CE0-83F5-BF7E6D4EB38D', '45FEFF38-8D8A-4960-A86D-174E22FFDC5E', '5C8A9CA1-38FD-4A97-9403-74A839DA1882', '8EA23896-2F60-43C3-AAE9-A14520012A11', '9690B2C0-8DA3-446A-9078-51A7D3593279', 'A6355BE5-97FE-4CFE-99FC-22C22714C481', 'A655C4F7-F8E8-46A4-B822-2261DCA889C5', 'A9DC0478-C741-477B-85E6-5FEB99A83B65', 'B5668A80-16AA-404F-A6C7-A45FFDC2D14B', 'B89BB4FF-A507-4D64-A966-B6C0A5D1B31E', 'B91512A1-DA24-4DD7-AD49-5BCBAE7CCCE6', 'C7B24A8F-D55A-4FFC-BD89-C38A6978F20D', 'CD00CC5F-BC78-4B81-BFD3-CCC311079A6E', 'E27C36B9-15DC-4563-896C-0329D70F3AF4', 'F118CA22-8EA6-40E2-B4C3-A3D174773E68', 'F4091097-7160-4DDE-8EA0-E3C0E69AFBE8') 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 ('B2CDA476-C8A3-4130-B00A-2DF9161E4632') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `parentId` is null and `slug` = 'spares-brackets-components' 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` = '3A0BDA4C-DFC8-4C88-AF5E-A1E56D78ECB7' and `slug` = 'roof-rack-parts' 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` = '1F1129D9-79D8-4138-A3E2-926E9090C4FE' and `slug` = 'rhino-rack-backbone' 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` = '1F1129D9-79D8-4138-A3E2-926E9090C4FE' and `PR_Categories`.`deleted_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` = 'B2CDA476-C8A3-4130-B00A-2DF9161E4632' 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` = '0DCEBC73-9BFB-4D66-892F-452CCBFE6CF3' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52') and `PR_Categories`.`deleted_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 ('B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '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` = '0DCEBC73-9BFB-4D66-892F-452CCBFE6CF3' 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` = '0DCEBC73-9BFB-4D66-892F-452CCBFE6CF3' and `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 ('B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '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 ('B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '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` = 'A9DC0478-C741-477B-85E6-5FEB99A83B65' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '9A33C4D1-ADFD-4599-98C7-B4A02CF33000', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52') and `PR_Categories`.`deleted_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 ('B2CDA476-C8A3-4130-B00A-2DF9161E4632', '9A33C4D1-ADFD-4599-98C7-B4A02CF33000', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '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` = 'A9DC0478-C741-477B-85E6-5FEB99A83B65' 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` = 'A9DC0478-C741-477B-85E6-5FEB99A83B65' and `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 ('B2CDA476-C8A3-4130-B00A-2DF9161E4632', '9A33C4D1-ADFD-4599-98C7-B4A02CF33000', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '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 ('B2CDA476-C8A3-4130-B00A-2DF9161E4632', '9A33C4D1-ADFD-4599-98C7-B4A02CF33000', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '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` = '003379CB-8A6C-479F-B8C7-34F193129999' 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 ('05E803A7-793A-4E6A-A1AA-C1B163BDDF5A', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52') and `PR_Categories`.`deleted_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 ('05E803A7-793A-4E6A-A1AA-C1B163BDDF5A', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '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` = '003379CB-8A6C-479F-B8C7-34F193129999' 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` = '003379CB-8A6C-479F-B8C7-34F193129999' and `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 ('05E803A7-793A-4E6A-A1AA-C1B163BDDF5A', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '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 ('05E803A7-793A-4E6A-A1AA-C1B163BDDF5A', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '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` = '8EA23896-2F60-43C3-AAE9-A14520012A11' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '9A33C4D1-ADFD-4599-98C7-B4A02CF33000', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52') and `PR_Categories`.`deleted_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 ('B2CDA476-C8A3-4130-B00A-2DF9161E4632', '9A33C4D1-ADFD-4599-98C7-B4A02CF33000', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '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` = '8EA23896-2F60-43C3-AAE9-A14520012A11' 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` = '8EA23896-2F60-43C3-AAE9-A14520012A11' and `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 ('B2CDA476-C8A3-4130-B00A-2DF9161E4632', '9A33C4D1-ADFD-4599-98C7-B4A02CF33000', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '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 ('B2CDA476-C8A3-4130-B00A-2DF9161E4632', '9A33C4D1-ADFD-4599-98C7-B4A02CF33000', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '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` = '45FEFF38-8D8A-4960-A86D-174E22FFDC5E' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52') and `PR_Categories`.`deleted_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 ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '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` = '45FEFF38-8D8A-4960-A86D-174E22FFDC5E' 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` = '45FEFF38-8D8A-4960-A86D-174E22FFDC5E' and `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 ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '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 ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '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` = '3954246E-AE9D-4506-B49B-B3A74BB1F491' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52') and `PR_Categories`.`deleted_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 ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '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` = '3954246E-AE9D-4506-B49B-B3A74BB1F491' 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` = '3954246E-AE9D-4506-B49B-B3A74BB1F491' and `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 ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '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 ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '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` = 'A6355BE5-97FE-4CFE-99FC-22C22714C481' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52') and `PR_Categories`.`deleted_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 ('DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', '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` = 'A6355BE5-97FE-4CFE-99FC-22C22714C481' 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` = 'A6355BE5-97FE-4CFE-99FC-22C22714C481' and `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 ('DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', '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 ('DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', '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` = '398AF70F-4A24-4BE7-8368-AAE19D0CEFBC' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52') and `PR_Categories`.`deleted_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 ('B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '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` = '398AF70F-4A24-4BE7-8368-AAE19D0CEFBC' 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` = '398AF70F-4A24-4BE7-8368-AAE19D0CEFBC' and `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 ('B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '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 ('B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '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` = '34BBAB4E-47DD-4D8B-A855-F504905F4A89' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52') and `PR_Categories`.`deleted_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 ('D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '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` = '34BBAB4E-47DD-4D8B-A855-F504905F4A89' 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` = '34BBAB4E-47DD-4D8B-A855-F504905F4A89' and `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 ('D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '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 ('D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '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` = '5C8A9CA1-38FD-4A97-9403-74A839DA1882' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52') and `PR_Categories`.`deleted_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 ('DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', '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` = '5C8A9CA1-38FD-4A97-9403-74A839DA1882' 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` = '5C8A9CA1-38FD-4A97-9403-74A839DA1882' and `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 ('DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', '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 ('DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', '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` = 'CD00CC5F-BC78-4B81-BFD3-CCC311079A6E' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52') and `PR_Categories`.`deleted_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 ('B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '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` = 'CD00CC5F-BC78-4B81-BFD3-CCC311079A6E' 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` = 'CD00CC5F-BC78-4B81-BFD3-CCC311079A6E' and `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 ('B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '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 ('B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '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` = 'C7B24A8F-D55A-4FFC-BD89-C38A6978F20D' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52') and `PR_Categories`.`deleted_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 ('B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '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` = 'C7B24A8F-D55A-4FFC-BD89-C38A6978F20D' 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` = 'C7B24A8F-D55A-4FFC-BD89-C38A6978F20D' and `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 ('B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '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 ('B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '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` = 'B89BB4FF-A507-4D64-A966-B6C0A5D1B31E' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52') and `PR_Categories`.`deleted_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 ('DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', '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` = 'B89BB4FF-A507-4D64-A966-B6C0A5D1B31E' 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` = 'B89BB4FF-A507-4D64-A966-B6C0A5D1B31E' and `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 ('DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', '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 ('DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', '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` = '380D3E41-77CE-45E6-AB90-14D6647A8A8E' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52') and `PR_Categories`.`deleted_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 ('DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '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` = '380D3E41-77CE-45E6-AB90-14D6647A8A8E' 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` = '380D3E41-77CE-45E6-AB90-14D6647A8A8E' and `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 ('DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '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 ('DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '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` = 'A655C4F7-F8E8-46A4-B822-2261DCA889C5' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52') and `PR_Categories`.`deleted_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 ('D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', '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` = 'A655C4F7-F8E8-46A4-B822-2261DCA889C5' 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` = 'A655C4F7-F8E8-46A4-B822-2261DCA889C5' and `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 ('D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', '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 ('D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', '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` = 'F4091097-7160-4DDE-8EA0-E3C0E69AFBE8' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52') and `PR_Categories`.`deleted_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 ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '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` = 'F4091097-7160-4DDE-8EA0-E3C0E69AFBE8' 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` = 'F4091097-7160-4DDE-8EA0-E3C0E69AFBE8' and `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 ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '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 ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '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` = '9690B2C0-8DA3-446A-9078-51A7D3593279' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52') and `PR_Categories`.`deleted_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 ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '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` = '9690B2C0-8DA3-446A-9078-51A7D3593279' 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` = '9690B2C0-8DA3-446A-9078-51A7D3593279' and `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 ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '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 ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '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` = 'F118CA22-8EA6-40E2-B4C3-A3D174773E68' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52') and `PR_Categories`.`deleted_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 ('D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '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` = 'F118CA22-8EA6-40E2-B4C3-A3D174773E68' 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` = 'F118CA22-8EA6-40E2-B4C3-A3D174773E68' and `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 ('D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '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 ('D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '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` = '3A53EACE-E543-4EF2-9647-1350AAFFDF16' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', '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` = '3A53EACE-E543-4EF2-9647-1350AAFFDF16' 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` = '3A53EACE-E543-4EF2-9647-1350AAFFDF16' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', '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 ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', '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` = 'B91512A1-DA24-4DD7-AD49-5BCBAE7CCCE6' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E') and `PR_Categories`.`deleted_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 ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '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` = 'B91512A1-DA24-4DD7-AD49-5BCBAE7CCCE6' 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` = 'B91512A1-DA24-4DD7-AD49-5BCBAE7CCCE6' and `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 ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '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 ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '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` = '227EB8BE-AFE0-4248-AD3C-E133B6E0C478' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E') and `PR_Categories`.`deleted_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 ('B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', '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` = '227EB8BE-AFE0-4248-AD3C-E133B6E0C478' 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` = '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 limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', '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 ('B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', '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` = 'B5668A80-16AA-404F-A6C7-A45FFDC2D14B' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E') and `PR_Categories`.`deleted_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 ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '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` = 'B5668A80-16AA-404F-A6C7-A45FFDC2D14B' 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` = 'B5668A80-16AA-404F-A6C7-A45FFDC2D14B' and `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 ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '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 ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '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` = '3E316085-DB84-4CE0-83F5-BF7E6D4EB38D' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52') and `PR_Categories`.`deleted_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 ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '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` = '3E316085-DB84-4CE0-83F5-BF7E6D4EB38D' 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` = '3E316085-DB84-4CE0-83F5-BF7E6D4EB38D' and `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 ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '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 ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '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` = 'E27C36B9-15DC-4563-896C-0329D70F3AF4' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632') 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` = 'E27C36B9-15DC-4563-896C-0329D70F3AF4' 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` = 'E27C36B9-15DC-4563-896C-0329D70F3AF4' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'D6EB3D66-6A8B-4820-843F-AFA5693B549E', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632') 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:16 [▼ "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" ] "cookie" => array:1 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Im5xSklxUUdNYU5WdGlPZmx4cGlyblE9PSIsInZhbHVlIjoiWUJtNXE1ZGlNUUV6OXlxcFkzSWFkOExtTTMyc2dDTHdLRlJ5MTI3RFNxOGJ0UjlNbVo5WWszMGNLQnBVWDQzS2tMTURkTHBMOUdjWU5EN1ZFMWxBY2I0NTlnU2J2OGhXUGViTVhZTXZEWjlMZFBreFlpN0ZaZ3lSRHV5b2cxWDEiLCJtYWMiOiI0MmIzN2QxZmZjMmYxODUwN2Q1OGI0ZjczOTJjMDUxNjhhYmJlN2I2YmI5Y2JjODU0ZWI4YTNkMWNlYjc0MzI3IiwidGFnIjoiIn0%3D; rhino_rack_session=eyJpdiI6IlEzZGdKSDZ0L0UxZnVIMmhIMDAvUmc9PSIsInZhbHVlIjoicnZpcVRhRXFrR0FRQ0pPZlpsdEdCbVdYdDhScTkzRHk4aXg0cW1Wc2ZkNG5XSDNrMUJVSnA4a2pJbmVaVURGa0FibjZjQWw3U1VQZnZaNVJuakN1RVZ5ZkFkRkZpdXZtTjkrb2NVN3gvM0tNR0VrOTlkYTRBSXRZSTVVczErSm0iLCJtYWMiOiI3ODI2ZWU3NDAzNDE1ZjZhNTc2M2Q1ZDc5ZDZjNzk4ZTg0ZDkxMjUxNjJhMDU2MDY0YmExOTM3ODllOWZjODU4IiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6Im5xSklxUUdNYU5WdGlPZmx4cGlyblE9PSIsInZhbHVlIjoiWUJtNXE1ZGlNUUV6OXlxcFkzSWFkOExtTTMyc2dDTHdLRlJ5MTI3RFNxOGJ0UjlNbVo5WWszMGNLQnBVWDQzS2tMTURkT ▶" ] ]
0 of 0array:49 [▼ "REDIRECT_SCRIPT_URL" => "/en-au/products/spares-brackets-components/roof-rack-parts/rhino-rack-backbone" "REDIRECT_SCRIPT_URI" => "https://rrweb.webexpertsnepal.com/en-au/products/spares-brackets-components/roof-rack-parts/rhino-rack-backbone" "REDIRECT_HTTPS" => "on" "REDIRECT_SSL_TLS_SNI" => "rrweb.webexpertsnepal.com" "REDIRECT_STATUS" => "200" "SCRIPT_URL" => "/en-au/products/spares-brackets-components/roof-rack-parts/rhino-rack-backbone" "SCRIPT_URI" => "https://rrweb.webexpertsnepal.com/en-au/products/spares-brackets-components/roof-rack-parts/rhino-rack-backbone" "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" "HTTP_COOKIE" => "XSRF-TOKEN=eyJpdiI6Im5xSklxUUdNYU5WdGlPZmx4cGlyblE9PSIsInZhbHVlIjoiWUJtNXE1ZGlNUUV6OXlxcFkzSWFkOExtTTMyc2dDTHdLRlJ5MTI3RFNxOGJ0UjlNbVo5WWszMGNLQnBVWDQzS2tMTURkTHBMOUdjWU5EN1ZFMWxBY2I0NTlnU2J2OGhXUGViTVhZTXZEWjlMZFBreFlpN0ZaZ3lSRHV5b2cxWDEiLCJtYWMiOiI0MmIzN2QxZmZjMmYxODUwN2Q1OGI0ZjczOTJjMDUxNjhhYmJlN2I2YmI5Y2JjODU0ZWI4YTNkMWNlYjc0MzI3IiwidGFnIjoiIn0%3D; rhino_rack_session=eyJpdiI6IlEzZGdKSDZ0L0UxZnVIMmhIMDAvUmc9PSIsInZhbHVlIjoicnZpcVRhRXFrR0FRQ0pPZlpsdEdCbVdYdDhScTkzRHk4aXg0cW1Wc2ZkNG5XSDNrMUJVSnA4a2pJbmVaVURGa0FibjZjQWw3U1VQZnZaNVJuakN1RVZ5ZkFkRkZpdXZtTjkrb2NVN3gvM0tNR0VrOTlkYTRBSXRZSTVVczErSm0iLCJtYWMiOiI3ODI2ZWU3NDAzNDE1ZjZhNTc2M2Q1ZDc5ZDZjNzk4ZTg0ZDkxMjUxNjJhMDU2MDY0YmExOTM3ODllOWZjODU4IiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6Im5xSklxUUdNYU5WdGlPZmx4cGlyblE9PSIsInZhbHVlIjoiWUJtNXE1ZGlNUUV6OXlxcFkzSWFkOExtTTMyc2dDTHdLRlJ5MTI3RFNxOGJ0UjlNbVo5WWszMGNLQnBVWDQzS2tMTURkT ▶" "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" => "19148" "REDIRECT_URL" => "/en-au/products/spares-brackets-components/roof-rack-parts/rhino-rack-backbone" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/en-au/products/spares-brackets-components/roof-rack-parts/rhino-rack-backbone" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1744074942.0661 "REQUEST_TIME" => 1744074942 ]
0 of 0array:2 [▼ "XSRF-TOKEN" => "re7h5a4qLGmAufmzTEyEWAicovlnVV19hb4zS7nX" "rhino_rack_session" => "O2shQ0F0DpEBxr8sxB8v6amMzbiplkJiqkZ626nN" ]
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 => "Tue, 08 Apr 2025 01:15:42 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Ikg3ZkZ3cG8xa3gvdzl2dFRuenUyUnc9PSIsInZhbHVlIjoiUzVhOFBMVExqQ2NwOTV3bFRwWFJVY25ibVhIU1V1NXZodUhvRURaZ1p5dDUwNlhCWVBuTzFOei9TaGNsOHdPSGZvWEY1d0lFeFZqWEdhaHhsRjZRSzlFS2NjTGJjWjl3U0lvOUlyaGcvV09QaC9mYXdxVDFObVpzNmxhZkJTd1kiLCJtYWMiOiJkMjNhNjUxZGFkZTgzNGViMzhmMTI0ZWU1N2EyNjA5NmE4ZWQwYzViNjBiZmYzZmNiZDllZWU3MWYxOGYzMzhiIiwidGFnIjoiIn0%3D; expires=Thu, 08 May 2025 11:15:43 GMT; Max-Age=2628000; path=/ ◀XSRF-TOKEN=eyJpdiI6Ikg3ZkZ3cG8xa3gvdzl2dFRuenUyUnc9PSIsInZhbHVlIjoiUzVhOFBMVExqQ2NwOTV3bFRwWFJVY25ibVhIU1V1NXZodUhvRURaZ1p5dDUwNlhCWVBuTzFOei9TaGNsOHdPSGZvWEY1d ▶" 1 => "rhino_rack_session=eyJpdiI6IlNlV1U4Mmg4Y0xyZkJHc0I5TXlHT2c9PSIsInZhbHVlIjoiTWhJTUJLSW9OWEdndzl0clYraVlScVpmOWlsYk9PN0J2Y0tHY1VVL29nellTOXNEY0Zuc0MwNmJFY3h6amFzY0o0ejJSVUZoU295cVU4d0tNMmJhYjZreFVYdEoyU3g0WnpBWG5Ma3dwbUlzOGM5S2JzNUFBWEpZQXV1bHZvREQiLCJtYWMiOiJiMWY1YjBlYTcyZWUyMWViOTg2NDQzZDMxZDA4NjYzMDVhMjZiMjhlNDkyZWIxMDllZTE3OGY3ODcwYWUxN2M2IiwidGFnIjoiIn0%3D; expires=Thu, 08 May 2025 11:15:43 GMT; Max-Age=2628000; path=/; httponly ◀rhino_rack_session=eyJpdiI6IlNlV1U4Mmg4Y0xyZkJHc0I5TXlHT2c9PSIsInZhbHVlIjoiTWhJTUJLSW9OWEdndzl0clYraVlScVpmOWlsYk9PN0J2Y0tHY1VVL29nellTOXNEY0Zuc0MwNmJFY3h6amFzY ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Ikg3ZkZ3cG8xa3gvdzl2dFRuenUyUnc9PSIsInZhbHVlIjoiUzVhOFBMVExqQ2NwOTV3bFRwWFJVY25ibVhIU1V1NXZodUhvRURaZ1p5dDUwNlhCWVBuTzFOei9TaGNsOHdPSGZvWEY1d0lFeFZqWEdhaHhsRjZRSzlFS2NjTGJjWjl3U0lvOUlyaGcvV09QaC9mYXdxVDFObVpzNmxhZkJTd1kiLCJtYWMiOiJkMjNhNjUxZGFkZTgzNGViMzhmMTI0ZWU1N2EyNjA5NmE4ZWQwYzViNjBiZmYzZmNiZDllZWU3MWYxOGYzMzhiIiwidGFnIjoiIn0%3D; expires=Thu, 08-May-2025 11:15:43 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ikg3ZkZ3cG8xa3gvdzl2dFRuenUyUnc9PSIsInZhbHVlIjoiUzVhOFBMVExqQ2NwOTV3bFRwWFJVY25ibVhIU1V1NXZodUhvRURaZ1p5dDUwNlhCWVBuTzFOei9TaGNsOHdPSGZvWEY1d ▶" 1 => "rhino_rack_session=eyJpdiI6IlNlV1U4Mmg4Y0xyZkJHc0I5TXlHT2c9PSIsInZhbHVlIjoiTWhJTUJLSW9OWEdndzl0clYraVlScVpmOWlsYk9PN0J2Y0tHY1VVL29nellTOXNEY0Zuc0MwNmJFY3h6amFzY0o0ejJSVUZoU295cVU4d0tNMmJhYjZreFVYdEoyU3g0WnpBWG5Ma3dwbUlzOGM5S2JzNUFBWEpZQXV1bHZvREQiLCJtYWMiOiJiMWY1YjBlYTcyZWUyMWViOTg2NDQzZDMxZDA4NjYzMDVhMjZiMjhlNDkyZWIxMDllZTE3OGY3ODcwYWUxN2M2IiwidGFnIjoiIn0%3D; expires=Thu, 08-May-2025 11:15:43 GMT; path=/; httponly ◀rhino_rack_session=eyJpdiI6IlNlV1U4Mmg4Y0xyZkJHc0I5TXlHT2c9PSIsInZhbHVlIjoiTWhJTUJLSW9OWEdndzl0clYraVlScVpmOWlsYk9PN0J2Y0tHY1VVL29nellTOXNEY0Zuc0MwNmJFY3h6amFzY ▶" ] ]
0 of 0array:9 [▼ "_token" => "re7h5a4qLGmAufmzTEyEWAicovlnVV19hb4zS7nX" "_previous" => array:1 [▶ "url" => "https://rrweb.webexpertsnepal.com/en-au/products/spares-brackets-components/roof-rack-parts/rhino-rack-backbone" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "country" => "au" "lngId" => 7 "session_culture" => "en-au" "random_number" => 15 "locale" => "en" "PHPDEBUGBAR_STACK_DATA" => [] ]