1 x Application (99.25%) | 853.95ms |
1 x Booting (0.74%) | 6.38ms |
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-ca' 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` = 5) 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 (805, 806, 807, 808, 920) and `menus`.`deleted_at` is null and (`menus`.`lngId` is null or `menus`.`lngId` = 5) 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 (2670, 3419) and `pages`.`deleted_at` is null and (`pages`.`lngId` is null or `pages`.`lngId` = 5) 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` = 3437 and `pages`.`deleted_at` is null and (`pages`.`lngId` is null or `pages`.`lngId` = 5) 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` = 2380 and `pages`.`deleted_at` is null and (`pages`.`lngId` is null or `pages`.`lngId` = 5) 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` = 2393 and `pages`.`deleted_at` is null and (`pages`.`lngId` is null or `pages`.`lngId` = 5) 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` = 3431 and `pages`.`deleted_at` is null and (`pages`.`lngId` is null or `pages`.`lngId` = 5) 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` = 3401 and `pages`.`deleted_at` is null and (`pages`.`lngId` is null or `pages`.`lngId` = 5) 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` = 2964 and `pages`.`deleted_at` is null and (`pages`.`lngId` is null or `pages`.`lngId` = 5) 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` = 5) 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 (1013, 1014, 1015, 1017, 1018, 1019, 1020, 1022, 1023, 1025, 1026, 1027, 1028, 1029, 1030, 1031, 1033) and `menus`.`deleted_at` is null and (`menus`.`lngId` is null or `menus`.`lngId` = 5) 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 (2374, 2393, 2670, 3419, 3421, 3425, 3427, 3429, 3435, 3437, 3441, 3443, 3445) and `pages`.`deleted_at` is null and (`pages`.`lngId` is null or `pages`.`lngId` = 5) 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` = 5) 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 (828, 829, 830, 838, 839, 841, 842, 1004) and `menus`.`deleted_at` is null and (`menus`.`lngId` is null or `menus`.`lngId` = 5) 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 (2369, 2370, 2371, 2372, 2383, 2460, 3286, 3421) and `pages`.`deleted_at` is null and (`pages`.`lngId` is null or `pages`.`lngId` = 5) 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` = 5) 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', '3A0BDA4C-DFC8-4C88-AF5E-A1E56D78ECB7', '42FB0E18-E8BA-4F1C-9A44-AC43B4AA4108', '4414ADDD-ACCE-4100-8D90-17F712102BB4', '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` = 5) 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', '3A0BDA4C-DFC8-4C88-AF5E-A1E56D78ECB7', '42FB0E18-E8BA-4F1C-9A44-AC43B4AA4108', '4414ADDD-ACCE-4100-8D90-17F712102BB4', '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` = 5) 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` = '5' and `PR_Categories`.`categoryId` in ('2DBF99C2-B887-45CC-B040-C11B8685B420', '30E5B649-D124-444D-90E8-15700ACFA643', '3A0BDA4C-DFC8-4C88-AF5E-A1E56D78ECB7', '42FB0E18-E8BA-4F1C-9A44-AC43B4AA4108', '4414ADDD-ACCE-4100-8D90-17F712102BB4', '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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `parentId` is null and `slug` = 'roof-rack-extras' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) 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` = 'spare-parts' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) 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` = '0D272934-989A-40FC-B661-F832E87EFEB1' and `slug` = 'nuts-bolts-washers-rivets' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) 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` = 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B' 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 ('0B56462C-E152-45DE-839E-5D01A5C2A95E', '14F3FB81-8947-4E5E-BB23-2F17B1452EF2', '7A993F12-A4FA-4CEC-8FB5-B094C4C8CF4C') and `PR_Specifications`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_SpecificationProperties` where `PR_SpecificationProperties`.`specificationId` in ('0B56462C-E152-45DE-839E-5D01A5C2A95E', '14F3FB81-8947-4E5E-BB23-2F17B1452EF2', '7A993F12-A4FA-4CEC-8FB5-B094C4C8CF4C') and `PR_SpecificationProperties`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_SpecificationPropertyMasterData` where `PR_SpecificationPropertyMasterData`.`specificationPropertyId` in ('41D4AB7C-555B-4DE5-B2CB-994EA80C0B7D', '64BF05B2-58E6-4D51-BB25-6F04310D1101', '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` = 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B' and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('01146191-4AE2-4E77-92F8-EE0147A6DACE', '025F9D86-E27D-470E-BCC5-82E94176FAE4', '02C97692-2C1E-454B-8A12-7233847B370C', '0353637C-80E1-48E0-9FF9-ECE22E59ED5E', '04F70390-60F4-4CE2-9D19-7B2A2BB148C3', '0A4A45D5-AE35-4CBA-BFF1-27756A0966F7', '0A4B109D-9943-4B2C-ACDB-93016FE52020', '0CF89293-4B1C-4930-9AE4-85A98D8EBF85', '0E9B4D70-CB3B-4D70-A068-BE4C8B5F2D19', '0F329528-E5BE-4CB4-A018-89C880569B2A', '101DA6E2-933C-4767-A273-AD02D34B276B', '127610D8-8CCC-42BF-8226-88DC0BE1DC23', '1325FFAB-7866-46F6-975E-1C58BE0B2911', '1380CBC0-D20A-4605-A9E4-CF7DC1376075', '1382CC6E-26AB-4A1C-B168-A8BF1D59E467', '178529AB-1EA3-4EDF-A491-FD999D51B5AE', '17C6ADF3-7C3B-48EC-A628-FE50F95C77A6', '186B091A-A4DA-4D1C-8EF2-C8CDCA98A1C4', '18D39929-AA81-4404-9840-48B66FDF8AE5', '1A34D917-7B94-4562-BBEE-A778CEF17548', '2116BF62-2AB5-4363-837D-137CF792DA62', '2D049E5A-CB2B-45AD-8380-47F941204B88', '322E0386-48ED-4568-9737-FE9AE943640F', '36730B26-04B6-43A4-92BA-3CFC90853BF3', '38EB0925-F704-4CF0-A51D-3B7860DCD965', '3A40FE65-337A-48A1-A9DE-493EE7306E8B', '3CD6AC57-117B-4401-B3FC-CE77C698A112', '3CFDAA4E-0E45-4D5D-9540-6C1E42432723', '3E64BDE7-8447-4ACD-A7C1-A040ADA429C0', '41118C4E-EFE6-44A7-8C9C-EA530816D63C', '439A8867-2688-4A16-A5E8-762F8F0E0965', '453C8F28-42E4-4A21-8D93-0BF96D38B8E6', '4607166B-5E69-4168-AFBC-9ED54812C5B6', '4A011DA4-6318-44A5-8174-72ACE1E6BEB2', '4B0D8989-E495-4699-9551-B3D4C7B05DFC', '4D1C044A-6010-4CB2-91C7-737966325F0B', '4FF81962-4338-44A2-A056-AD88BBE466AA', '507AEDCA-4FA0-4B63-8AA4-BBCA422C05E3', '5737D782-2372-409E-ACA8-A2EE32A4A7AF', '5AB139B3-09C0-4BE3-88AB-E195A73EE5FF', '5CB16A43-18E2-4D21-9004-A1A726A54EC0', '5EE69167-835D-48B0-AB54-649DFDF51396', '5F34ECA3-17D5-4E7A-86D1-820AF79EAA35', '6147CF9F-3EED-458F-941C-28C4A62026F6', '61E84CE6-8D37-4D57-9335-98D7B69BE9BB', '62A256F4-5FA2-45C4-85CB-A0FA2EB28A99', '66EB10D4-9DAC-4DCB-9CE9-AE9AC6555662', '683B453F-16B7-42A1-B647-CAD5AFAA16B2', '69437D3B-25FB-4999-A910-BF63850F11E9', '6A943469-B5FC-476D-99BA-5E3D003DA414', '6B0EC045-8678-466E-8E2D-831566DC4884', '6FABA7E8-2110-46FC-9383-E61D86C26B3E', '718F31D7-A41D-4202-B4FB-133A89100329', '71C29E6A-98AB-4DB8-8EC6-2C0F9A0708EF', '71E527AD-6535-4817-8EC9-6B920EABF053', '74EFA1D1-B0F8-4BBB-9BEE-F7A045BBE286', '773CB743-69CB-4F57-B5BD-0016FF4C1544', '7822B654-79A6-468E-A57E-5B5CB5417415', '7974DE0E-C8E9-4DE6-A9AD-75CE9FA70899', '7D32D617-4802-46EB-B6B9-2D274F761117', '81E411EA-63E6-4AD5-8FAC-BB63E4077733', '8242BCBC-9512-444C-AB5F-88EFD7EF6FED', '8590EF8A-E175-494F-BACB-2B7EB76956F1', '8631BC7A-EEA0-4493-ACC0-BBE87A548574', '881183D4-C36E-4B27-8A50-38D22181A015', '8ADDE884-B661-424A-BCF4-CB9B3153AC81', '8C740BC2-3337-4604-B25D-5ACD39D94ED3', '8D4D117F-BB23-4C78-BAF3-1E947A3A7C47', '8D566E11-7332-4DE4-B257-40CB22E0EC0B', '8E95AC89-2AD7-4F4A-80D0-5E3C0D303C3D', '8E9CC6B4-9675-4840-ACFC-78464775E906', '9233A6EC-C20E-4F3D-94DF-57E68723B9CD', '929B8349-8FE0-4CA8-9498-1FB58492C020', '92A19C2C-1326-4EC2-8AFC-39F89816CC1A', '932B865C-98A2-430D-B07A-F735F4705D6A', '98046CF9-DDE4-4FAA-A21C-06998CE66CE8', '980A7462-8417-4078-B5FC-96D6790BE9D8', '9A5E8B28-BEAC-4A2A-9482-6F044FAE1CBD', '9CDC97DF-3F12-4C4B-A6B9-4B2D71919C4F', 'A1F8181A-8E45-44C3-9F57-68BA9226C338', 'A3945F1C-B98E-4B9F-9D8C-C6B3C45CA956', 'A51A79D2-E2CE-4779-A784-AC84A6354A35', 'A530E6E3-6860-4B5B-8C0F-5261F6B7E813', 'A8D98ECD-3F72-40BB-8CBF-DD3E83B47709', 'A9AE1A57-5D24-4D8A-B6E2-5772092590E2', 'ABE943FE-CA31-47B7-93B5-F8A2247A0017', 'B0ABD9B1-7864-4759-A4B9-BAF6791F01A7', 'B0B3668C-521C-4E30-9713-DAD2E7117DAD', 'B7E0BB42-1344-4C6A-A503-8D9A2BA6B83C', 'B845D6C5-F078-4D34-BE15-D394D64B9011', 'B8D21907-24DD-492C-980C-EDBA55515448', 'BFA6B20B-EB34-462A-99BF-E875079D9677', 'C06149E6-9661-4AF1-B592-E837FA37805C', 'C9156571-E3BA-410C-B56D-73A7575119A3', 'C9E71E74-2B3E-4B08-A7F2-7C5778140B7C', 'CC64551C-8424-4974-A4A7-BF64FD20BB3F', 'CDC5026F-27B2-4533-BFF2-7517BB06738D', 'CF30BEDC-6DE0-43B4-A78A-C29FB5C07B89', 'D2967B47-DD04-4232-95C8-99DE93E07324', 'D4E2B1F0-5117-4A32-8FD9-908F700E7910', 'D8C9C203-29F9-477A-8DB0-427E26BF1443', 'DA2BD9CE-EB6A-4A46-84DF-7B8034D605DB', 'DADE0696-0136-4C57-9524-E96F2AEDA27F', 'E25B36D6-3A1F-4D36-9B38-362E11E347CB', 'E3704687-7BBC-4567-8665-903FD66219D4', 'E3A825D7-F1AA-46E0-B9CC-65EA62B0461A', 'E784A82A-4169-4DF0-ADAC-6AEBB435CBD2', 'EEE7F596-30D7-4E63-9C65-01A5A7EA03F2', 'EFC0301E-7BEF-48C4-AAC4-08A44B5E7CFA', 'F0025C9C-FCB8-482C-A7C5-5A812F5A2CBF', 'F236CABE-EF37-4DD3-BB14-E7CAE2C89734', 'F403BEC8-3F22-45E6-9CD9-018578947805', 'F4A676E6-16F3-4169-B08D-414DED209248', 'F6B77B13-82A1-49E5-A90F-A9E06BA4E9DA', 'F887BFD7-A59D-4752-8806-5D45E53BD4B7', 'FB4AD273-A41A-4080-8209-DCBE772A16A0', 'FDC9B30E-DAEB-4DA2-99A8-38111C20A4B8') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `specificationPropertyMasterDataId` from `PR_ProductSpecificationProperties` where `productId` in ('8E95AC89-2AD7-4F4A-80D0-5E3C0D303C3D', '932B865C-98A2-430D-B07A-F735F4705D6A', 'E784A82A-4169-4DF0-ADAC-6AEBB435CBD2', '62A256F4-5FA2-45C4-85CB-A0FA2EB28A99', '8242BCBC-9512-444C-AB5F-88EFD7EF6FED', '61E84CE6-8D37-4D57-9335-98D7B69BE9BB', '507AEDCA-4FA0-4B63-8AA4-BBCA422C05E3', '5CB16A43-18E2-4D21-9004-A1A726A54EC0', '101DA6E2-933C-4767-A273-AD02D34B276B', '8ADDE884-B661-424A-BCF4-CB9B3153AC81', 'E3A825D7-F1AA-46E0-B9CC-65EA62B0461A', '5737D782-2372-409E-ACA8-A2EE32A4A7AF', 'B0B3668C-521C-4E30-9713-DAD2E7117DAD', 'B845D6C5-F078-4D34-BE15-D394D64B9011', '6A943469-B5FC-476D-99BA-5E3D003DA414', 'CF30BEDC-6DE0-43B4-A78A-C29FB5C07B89', 'A3945F1C-B98E-4B9F-9D8C-C6B3C45CA956', '4607166B-5E69-4168-AFBC-9ED54812C5B6', '4A011DA4-6318-44A5-8174-72ACE1E6BEB2', '6147CF9F-3EED-458F-941C-28C4A62026F6', '025F9D86-E27D-470E-BCC5-82E94176FAE4', '1A34D917-7B94-4562-BBEE-A778CEF17548', '5F34ECA3-17D5-4E7A-86D1-820AF79EAA35', 'A8D98ECD-3F72-40BB-8CBF-DD3E83B47709', 'C9E71E74-2B3E-4B08-A7F2-7C5778140B7C', '881183D4-C36E-4B27-8A50-38D22181A015', '0CF89293-4B1C-4930-9AE4-85A98D8EBF85', 'B0ABD9B1-7864-4759-A4B9-BAF6791F01A7', '6FABA7E8-2110-46FC-9383-E61D86C26B3E', '18D39929-AA81-4404-9840-48B66FDF8AE5', '8D4D117F-BB23-4C78-BAF3-1E947A3A7C47', '41118C4E-EFE6-44A7-8C9C-EA530816D63C', '36730B26-04B6-43A4-92BA-3CFC90853BF3', '453C8F28-42E4-4A21-8D93-0BF96D38B8E6', '92A19C2C-1326-4EC2-8AFC-39F89816CC1A', '04F70390-60F4-4CE2-9D19-7B2A2BB148C3', 'F887BFD7-A59D-4752-8806-5D45E53BD4B7', '0353637C-80E1-48E0-9FF9-ECE22E59ED5E', 'CDC5026F-27B2-4533-BFF2-7517BB06738D', 'A9AE1A57-5D24-4D8A-B6E2-5772092590E2', '3A40FE65-337A-48A1-A9DE-493EE7306E8B', '4D1C044A-6010-4CB2-91C7-737966325F0B', 'DA2BD9CE-EB6A-4A46-84DF-7B8034D605DB', '1380CBC0-D20A-4605-A9E4-CF7DC1376075', '01146191-4AE2-4E77-92F8-EE0147A6DACE', 'B8D21907-24DD-492C-980C-EDBA55515448', '17C6ADF3-7C3B-48EC-A628-FE50F95C77A6', '4B0D8989-E495-4699-9551-B3D4C7B05DFC', 'F236CABE-EF37-4DD3-BB14-E7CAE2C89734', '3E64BDE7-8447-4ACD-A7C1-A040ADA429C0', '1382CC6E-26AB-4A1C-B168-A8BF1D59E467', 'EEE7F596-30D7-4E63-9C65-01A5A7EA03F2', 'FB4AD273-A41A-4080-8209-DCBE772A16A0', 'BFA6B20B-EB34-462A-99BF-E875079D9677', 'CC64551C-8424-4974-A4A7-BF64FD20BB3F', 'A1F8181A-8E45-44C3-9F57-68BA9226C338', '8631BC7A-EEA0-4493-ACC0-BBE87A548574', '9CDC97DF-3F12-4C4B-A6B9-4B2D71919C4F', '178529AB-1EA3-4EDF-A491-FD999D51B5AE', '8C740BC2-3337-4604-B25D-5ACD39D94ED3', '186B091A-A4DA-4D1C-8EF2-C8CDCA98A1C4', '9233A6EC-C20E-4F3D-94DF-57E68723B9CD', '5AB139B3-09C0-4BE3-88AB-E195A73EE5FF', '322E0386-48ED-4568-9737-FE9AE943640F', '81E411EA-63E6-4AD5-8FAC-BB63E4077733')
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `categoryId` = 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) 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` = 5 where `categoryid` = 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B' 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` = 5 where `categoryid` = 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B' 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 ('01146191-4AE2-4E77-92F8-EE0147A6DACE', '0353637C-80E1-48E0-9FF9-ECE22E59ED5E', '04F70390-60F4-4CE2-9D19-7B2A2BB148C3', '1380CBC0-D20A-4605-A9E4-CF7DC1376075', '178529AB-1EA3-4EDF-A491-FD999D51B5AE', '17C6ADF3-7C3B-48EC-A628-FE50F95C77A6', '186B091A-A4DA-4D1C-8EF2-C8CDCA98A1C4', '322E0386-48ED-4568-9737-FE9AE943640F', '3A40FE65-337A-48A1-A9DE-493EE7306E8B', '3E64BDE7-8447-4ACD-A7C1-A040ADA429C0', '453C8F28-42E4-4A21-8D93-0BF96D38B8E6', '4B0D8989-E495-4699-9551-B3D4C7B05DFC', '4D1C044A-6010-4CB2-91C7-737966325F0B', '81E411EA-63E6-4AD5-8FAC-BB63E4077733', '8C740BC2-3337-4604-B25D-5ACD39D94ED3', '9233A6EC-C20E-4F3D-94DF-57E68723B9CD', '92A19C2C-1326-4EC2-8AFC-39F89816CC1A', '9CDC97DF-3F12-4C4B-A6B9-4B2D71919C4F', 'A9AE1A57-5D24-4D8A-B6E2-5772092590E2', 'B8D21907-24DD-492C-980C-EDBA55515448', 'CDC5026F-27B2-4533-BFF2-7517BB06738D', 'DA2BD9CE-EB6A-4A46-84DF-7B8034D605DB', 'F236CABE-EF37-4DD3-BB14-E7CAE2C89734', 'F887BFD7-A59D-4752-8806-5D45E53BD4B7') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) 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` = '5') order by `lngId` desc) = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc)) and `PR_Medias`.`productId` in ('01146191-4AE2-4E77-92F8-EE0147A6DACE', '0353637C-80E1-48E0-9FF9-ECE22E59ED5E', '04F70390-60F4-4CE2-9D19-7B2A2BB148C3', '1380CBC0-D20A-4605-A9E4-CF7DC1376075', '178529AB-1EA3-4EDF-A491-FD999D51B5AE', '17C6ADF3-7C3B-48EC-A628-FE50F95C77A6', '186B091A-A4DA-4D1C-8EF2-C8CDCA98A1C4', '322E0386-48ED-4568-9737-FE9AE943640F', '3A40FE65-337A-48A1-A9DE-493EE7306E8B', '3E64BDE7-8447-4ACD-A7C1-A040ADA429C0', '453C8F28-42E4-4A21-8D93-0BF96D38B8E6', '4B0D8989-E495-4699-9551-B3D4C7B05DFC', '4D1C044A-6010-4CB2-91C7-737966325F0B', '81E411EA-63E6-4AD5-8FAC-BB63E4077733', '8C740BC2-3337-4604-B25D-5ACD39D94ED3', '9233A6EC-C20E-4F3D-94DF-57E68723B9CD', '92A19C2C-1326-4EC2-8AFC-39F89816CC1A', '9CDC97DF-3F12-4C4B-A6B9-4B2D71919C4F', 'A9AE1A57-5D24-4D8A-B6E2-5772092590E2', 'B8D21907-24DD-492C-980C-EDBA55515448', 'CDC5026F-27B2-4533-BFF2-7517BB06738D', 'DA2BD9CE-EB6A-4A46-84DF-7B8034D605DB', 'F236CABE-EF37-4DD3-BB14-E7CAE2C89734', 'F887BFD7-A59D-4752-8806-5D45E53BD4B7') and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '5') 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 ('FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `parentId` is null and `slug` = 'roof-rack-extras' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) 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` = 'spare-parts' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) 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` = '0D272934-989A-40FC-B661-F832E87EFEB1' and `slug` = 'nuts-bolts-washers-rivets' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) 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` = '0D272934-989A-40FC-B661-F832E87EFEB1' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) 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` = 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B' and `PR_CategoryMeta`.`categoryId` is not null and `PR_CategoryMeta`.`deleted_at` is null and (`PR_CategoryMeta`.`lngId` is null or `PR_CategoryMeta`.`lngId` = 5) 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` = 5) 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` = '01146191-4AE2-4E77-92F8-EE0147A6DACE' 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` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '01146191-4AE2-4E77-92F8-EE0147A6DACE' 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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '01146191-4AE2-4E77-92F8-EE0147A6DACE' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '9CDC97DF-3F12-4C4B-A6B9-4B2D71919C4F' 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` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '9CDC97DF-3F12-4C4B-A6B9-4B2D71919C4F' 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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '9CDC97DF-3F12-4C4B-A6B9-4B2D71919C4F' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '81E411EA-63E6-4AD5-8FAC-BB63E4077733' 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` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '81E411EA-63E6-4AD5-8FAC-BB63E4077733' 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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '81E411EA-63E6-4AD5-8FAC-BB63E4077733' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '322E0386-48ED-4568-9737-FE9AE943640F' 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` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '322E0386-48ED-4568-9737-FE9AE943640F' 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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '322E0386-48ED-4568-9737-FE9AE943640F' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '186B091A-A4DA-4D1C-8EF2-C8CDCA98A1C4' 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` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '186B091A-A4DA-4D1C-8EF2-C8CDCA98A1C4' 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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '186B091A-A4DA-4D1C-8EF2-C8CDCA98A1C4' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '8C740BC2-3337-4604-B25D-5ACD39D94ED3' 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` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '8C740BC2-3337-4604-B25D-5ACD39D94ED3' 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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '8C740BC2-3337-4604-B25D-5ACD39D94ED3' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '178529AB-1EA3-4EDF-A491-FD999D51B5AE' 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` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '178529AB-1EA3-4EDF-A491-FD999D51B5AE' 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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '178529AB-1EA3-4EDF-A491-FD999D51B5AE' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '9233A6EC-C20E-4F3D-94DF-57E68723B9CD' 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` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '9233A6EC-C20E-4F3D-94DF-57E68723B9CD' 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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '9233A6EC-C20E-4F3D-94DF-57E68723B9CD' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'F236CABE-EF37-4DD3-BB14-E7CAE2C89734' 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` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = 'F236CABE-EF37-4DD3-BB14-E7CAE2C89734' 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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = 'F236CABE-EF37-4DD3-BB14-E7CAE2C89734' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '4B0D8989-E495-4699-9551-B3D4C7B05DFC' 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` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '4B0D8989-E495-4699-9551-B3D4C7B05DFC' 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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '4B0D8989-E495-4699-9551-B3D4C7B05DFC' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '17C6ADF3-7C3B-48EC-A628-FE50F95C77A6' 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` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '17C6ADF3-7C3B-48EC-A628-FE50F95C77A6' 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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '17C6ADF3-7C3B-48EC-A628-FE50F95C77A6' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'B8D21907-24DD-492C-980C-EDBA55515448' 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` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = 'B8D21907-24DD-492C-980C-EDBA55515448' 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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = 'B8D21907-24DD-492C-980C-EDBA55515448' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '3E64BDE7-8447-4ACD-A7C1-A040ADA429C0' 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` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '3E64BDE7-8447-4ACD-A7C1-A040ADA429C0' 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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '3E64BDE7-8447-4ACD-A7C1-A040ADA429C0' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '1380CBC0-D20A-4605-A9E4-CF7DC1376075' 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` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '1380CBC0-D20A-4605-A9E4-CF7DC1376075' 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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '1380CBC0-D20A-4605-A9E4-CF7DC1376075' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'DA2BD9CE-EB6A-4A46-84DF-7B8034D605DB' 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` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = 'DA2BD9CE-EB6A-4A46-84DF-7B8034D605DB' 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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = 'DA2BD9CE-EB6A-4A46-84DF-7B8034D605DB' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '4D1C044A-6010-4CB2-91C7-737966325F0B' 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` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '4D1C044A-6010-4CB2-91C7-737966325F0B' 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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '4D1C044A-6010-4CB2-91C7-737966325F0B' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '3A40FE65-337A-48A1-A9DE-493EE7306E8B' 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` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '3A40FE65-337A-48A1-A9DE-493EE7306E8B' 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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '3A40FE65-337A-48A1-A9DE-493EE7306E8B' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'A9AE1A57-5D24-4D8A-B6E2-5772092590E2' 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` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = 'A9AE1A57-5D24-4D8A-B6E2-5772092590E2' 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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = 'A9AE1A57-5D24-4D8A-B6E2-5772092590E2' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'CDC5026F-27B2-4533-BFF2-7517BB06738D' 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` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = 'CDC5026F-27B2-4533-BFF2-7517BB06738D' 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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = 'CDC5026F-27B2-4533-BFF2-7517BB06738D' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '0353637C-80E1-48E0-9FF9-ECE22E59ED5E' 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` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) 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 ('FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '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` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '0353637C-80E1-48E0-9FF9-ECE22E59ED5E' 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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '0353637C-80E1-48E0-9FF9-ECE22E59ED5E' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'F887BFD7-A59D-4752-8806-5D45E53BD4B7' 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` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = 'F887BFD7-A59D-4752-8806-5D45E53BD4B7' 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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = 'F887BFD7-A59D-4752-8806-5D45E53BD4B7' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '04F70390-60F4-4CE2-9D19-7B2A2BB148C3' 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` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) 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 ('FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '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` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '04F70390-60F4-4CE2-9D19-7B2A2BB148C3' 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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '04F70390-60F4-4CE2-9D19-7B2A2BB148C3' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '92A19C2C-1326-4EC2-8AFC-39F89816CC1A' 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` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '92A19C2C-1326-4EC2-8AFC-39F89816CC1A' 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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '92A19C2C-1326-4EC2-8AFC-39F89816CC1A' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '453C8F28-42E4-4A21-8D93-0BF96D38B8E6' 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` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '453C8F28-42E4-4A21-8D93-0BF96D38B8E6' 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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '453C8F28-42E4-4A21-8D93-0BF96D38B8E6' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) 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', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '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` = 5) 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
200
[]
[]
0 of 0array:15 [▼ "host" => array:1 [▶ 0 => "rrweb.webexpertsnepal.com" ] "connection" => array:1 [▶ 0 => "keep-alive" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "sec-ch-ua" => array:1 [▶ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] ]
0 of 0array:48 [▼ "REDIRECT_SCRIPT_URL" => "/en-ca/products/roof-rack-extras/spare-parts/nuts-bolts-washers-rivets" "REDIRECT_SCRIPT_URI" => "https://rrweb.webexpertsnepal.com/en-ca/products/roof-rack-extras/spare-parts/nuts-bolts-washers-rivets" "REDIRECT_HTTPS" => "on" "REDIRECT_SSL_TLS_SNI" => "rrweb.webexpertsnepal.com" "REDIRECT_STATUS" => "200" "SCRIPT_URL" => "/en-ca/products/roof-rack-extras/spare-parts/nuts-bolts-washers-rivets" "SCRIPT_URI" => "https://rrweb.webexpertsnepal.com/en-ca/products/roof-rack-extras/spare-parts/nuts-bolts-washers-rivets" "HTTPS" => "on" "SSL_TLS_SNI" => "rrweb.webexpertsnepal.com" "HTTP_HOST" => "rrweb.webexpertsnepal.com" "HTTP_CONNECTION" => "keep-alive" "HTTP_PRAGMA" => "no-cache" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin" "SERVER_SIGNATURE" => "<address>Apache/2.4.52 (Ubuntu) Server at rrweb.webexpertsnepal.com Port 443</address>\n" "SERVER_SOFTWARE" => "Apache/2.4.52 (Ubuntu)" "SERVER_NAME" => "rrweb.webexpertsnepal.com" "SERVER_ADDR" => "192.168.2.5" "SERVER_PORT" => "443" "REMOTE_ADDR" => "192.168.2.1" "DOCUMENT_ROOT" => "/var/www/rhinorack/web/public" "REQUEST_SCHEME" => "https" "CONTEXT_PREFIX" => "" "CONTEXT_DOCUMENT_ROOT" => "/var/www/rhinorack/web/public" "SERVER_ADMIN" => "webmaster@" "SCRIPT_FILENAME" => "/var/www/rhinorack/web/public/index.php" "REMOTE_PORT" => "57980" "REDIRECT_URL" => "/en-ca/products/roof-rack-extras/spare-parts/nuts-bolts-washers-rivets" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/en-ca/products/roof-rack-extras/spare-parts/nuts-bolts-washers-rivets" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1745757809.5132 "REQUEST_TIME" => 1745757809 ]
[]
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 => "Sun, 27 Apr 2025 12:43:29 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkxVbGJ4cUZ2MTdKaXVGajBKbEpld3c9PSIsInZhbHVlIjoiTXEvakx5bkdYSzl1Sm5ieGxkYmdWTnY3eVE1RXBZRXh2QzNNZllrTlpINTY0ZTRtRmFIZTlkZkhacHJSTzd2Szc2b0RmNWY0UmJISHVQZlFVak8yT0dIc1IyS1BmRUJRYnVtRFVjVjVNUlBjYmo0M1VWR0xmZk1CSVViRFU3UHgiLCJtYWMiOiJhZjAxNTAzY2ViODc5OTM3Nzg3YmQxNGMyZTZkOTQxNjhiMThiYzM3OWZiOWQxYTVlNDk4ODBkOWFkNDBlNDEwIiwidGFnIjoiIn0%3D; expires=Tue, 27 May 2025 22:43:30 GMT; Max-Age=2628000; path=/ ◀XSRF-TOKEN=eyJpdiI6IkxVbGJ4cUZ2MTdKaXVGajBKbEpld3c9PSIsInZhbHVlIjoiTXEvakx5bkdYSzl1Sm5ieGxkYmdWTnY3eVE1RXBZRXh2QzNNZllrTlpINTY0ZTRtRmFIZTlkZkhacHJSTzd2Szc2b0RmN ▶" 1 => "rhino_rack_session=eyJpdiI6IkpRNGplZ1pYZVQxN3ZKRVhCVmNIR0E9PSIsInZhbHVlIjoibE4wMU1veUg5dFBrU2FSUWRzWGxDQlNnVERWbUxva2hjak1IU1dnVnJQUkVZbUc4bXhDc21JMjlpZjN6S1pKWjEwVW96elVsdHQ1N285YUF6RjRFTStpdjZBVVBhQlY1QlB3V3RjckYxNitTN2JUczRMSFYyOXJLUkExaERVMkEiLCJtYWMiOiIwYzU4Y2ZmYmMxMDRjYjY5YzVlMGU3YWFjYjVkMmZmMGJlNjYzY2NmMGYyZDRhYzZjMjc5YWViNDE4YjY3Y2VmIiwidGFnIjoiIn0%3D; expires=Tue, 27 May 2025 22:43:30 GMT; Max-Age=2628000; path=/; httponly ◀rhino_rack_session=eyJpdiI6IkpRNGplZ1pYZVQxN3ZKRVhCVmNIR0E9PSIsInZhbHVlIjoibE4wMU1veUg5dFBrU2FSUWRzWGxDQlNnVERWbUxva2hjak1IU1dnVnJQUkVZbUc4bXhDc21JMjlpZjN6S1pKW ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkxVbGJ4cUZ2MTdKaXVGajBKbEpld3c9PSIsInZhbHVlIjoiTXEvakx5bkdYSzl1Sm5ieGxkYmdWTnY3eVE1RXBZRXh2QzNNZllrTlpINTY0ZTRtRmFIZTlkZkhacHJSTzd2Szc2b0RmNWY0UmJISHVQZlFVak8yT0dIc1IyS1BmRUJRYnVtRFVjVjVNUlBjYmo0M1VWR0xmZk1CSVViRFU3UHgiLCJtYWMiOiJhZjAxNTAzY2ViODc5OTM3Nzg3YmQxNGMyZTZkOTQxNjhiMThiYzM3OWZiOWQxYTVlNDk4ODBkOWFkNDBlNDEwIiwidGFnIjoiIn0%3D; expires=Tue, 27-May-2025 22:43:30 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkxVbGJ4cUZ2MTdKaXVGajBKbEpld3c9PSIsInZhbHVlIjoiTXEvakx5bkdYSzl1Sm5ieGxkYmdWTnY3eVE1RXBZRXh2QzNNZllrTlpINTY0ZTRtRmFIZTlkZkhacHJSTzd2Szc2b0RmN ▶" 1 => "rhino_rack_session=eyJpdiI6IkpRNGplZ1pYZVQxN3ZKRVhCVmNIR0E9PSIsInZhbHVlIjoibE4wMU1veUg5dFBrU2FSUWRzWGxDQlNnVERWbUxva2hjak1IU1dnVnJQUkVZbUc4bXhDc21JMjlpZjN6S1pKWjEwVW96elVsdHQ1N285YUF6RjRFTStpdjZBVVBhQlY1QlB3V3RjckYxNitTN2JUczRMSFYyOXJLUkExaERVMkEiLCJtYWMiOiIwYzU4Y2ZmYmMxMDRjYjY5YzVlMGU3YWFjYjVkMmZmMGJlNjYzY2NmMGYyZDRhYzZjMjc5YWViNDE4YjY3Y2VmIiwidGFnIjoiIn0%3D; expires=Tue, 27-May-2025 22:43:30 GMT; path=/; httponly ◀rhino_rack_session=eyJpdiI6IkpRNGplZ1pYZVQxN3ZKRVhCVmNIR0E9PSIsInZhbHVlIjoibE4wMU1veUg5dFBrU2FSUWRzWGxDQlNnVERWbUxva2hjak1IU1dnVnJQUkVZbUc4bXhDc21JMjlpZjN6S1pKW ▶" ] ]
0 of 0array:9 [▼ "_token" => "kz0PE6aFbh09oaJg4588nw4l5l5HqAO7KPbrTDl1" "country" => "ca" "_flash" => array:2 [▶ "old" => [] "new" => [] ] "lngId" => 5 "session_culture" => "en-ca" "random_number" => 23 "locale" => "en" "_previous" => array:1 [▶ "url" => "https://rrweb.webexpertsnepal.com/en-ca/products/roof-rack-extras/spare-parts/nuts-bolts-washers-rivets" ] "PHPDEBUGBAR_STACK_DATA" => [] ]