
The Vortex RCH Trackmount roof rack system is fixed to your canopy using a specialised track. However, the legs and bars can be removed when not required.
Your Vortex RCH Trackmount Black 2 Bar Canopy Roof Rack solution is made up of the following individual parts:
Utilising our highly regarded Vortex bars, this system offers you compatibility with a wide selection of Rhino-Rack accessories. So whether you're a traveller, cyclist, surfer or tradesperson - the Vortex RCH roof rack system has you covered.
Features:
Q1. What tools are required to fit this system?
A1. Please see the documents section for details on what is included and what additional tools may be required.
NEXT
Utilising our highly regarded Vortex bars, this system offers you compatibility with a wide selection of Rhino-Rack accessories. So whether you're a traveller, cyclist, surfer or tradesperson - the Vortex RCH roof rack system has you covered.
Features:
Q1. What tools are required to fit this system?
A1. Please see the documents section for details on what is included and what additional tools may be required.
EGR, EGR, All Dual Cab Vehicles
Toyota Genuine, Toyota Hilux (Without Genuine Internal Support), Toyota Hilux Gen 8 4dr Ute Double Cab 10/15 On
NEXT
1 x Application (99.71%) | 1.57s |
1 x Booting (0.29%) | 4.56ms |
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
select * from `PR_Categories` where `parentId` is null and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `order` asc, `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`parentId` in ('2DBF99C2-B887-45CC-B040-C11B8685B420', '30E5B649-D124-444D-90E8-15700ACFA643', '368F6AEA-1878-42A3-BD33-61B899A802DB', '3A0BDA4C-DFC8-4C88-AF5E-A1E56D78ECB7', '42FB0E18-E8BA-4F1C-9A44-AC43B4AA4108', '54891694-B598-4749-9332-822476DA4E14', '5C2DD4F5-056B-4961-B309-A37BA1BC5A4E', '6693BD7E-0B35-49EE-9F86-03F232998927', '7A6D08A3-DB1C-445C-8FEE-52E108F5E215', '8AA3B9B8-D2B6-4D55-A3FC-0395CD31FC52', 'B1335701-77AD-48E8-8384-13EE0A4C7AA6', 'D2377297-85F4-4F80-A7C1-97C4C9D341B0', 'F1D7419B-13D1-4D95-8AF7-0D95AED30BF2') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `order` asc, `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2DBF99C2-B887-45CC-B040-C11B8685B420', '30E5B649-D124-444D-90E8-15700ACFA643', '368F6AEA-1878-42A3-BD33-61B899A802DB', '3A0BDA4C-DFC8-4C88-AF5E-A1E56D78ECB7', '42FB0E18-E8BA-4F1C-9A44-AC43B4AA4108', '54891694-B598-4749-9332-822476DA4E14', '5C2DD4F5-056B-4961-B309-A37BA1BC5A4E', '6693BD7E-0B35-49EE-9F86-03F232998927', '7A6D08A3-DB1C-445C-8FEE-52E108F5E215', '8AA3B9B8-D2B6-4D55-A3FC-0395CD31FC52', 'B1335701-77AD-48E8-8384-13EE0A4C7AA6', 'D2377297-85F4-4F80-A7C1-97C4C9D341B0', 'F1D7419B-13D1-4D95-8AF7-0D95AED30BF2') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `lngId` = '7' and `PR_Categories`.`categoryId` in ('2DBF99C2-B887-45CC-B040-C11B8685B420', '30E5B649-D124-444D-90E8-15700ACFA643', '368F6AEA-1878-42A3-BD33-61B899A802DB', '3A0BDA4C-DFC8-4C88-AF5E-A1E56D78ECB7', '42FB0E18-E8BA-4F1C-9A44-AC43B4AA4108', '54891694-B598-4749-9332-822476DA4E14', '5C2DD4F5-056B-4961-B309-A37BA1BC5A4E', '6693BD7E-0B35-49EE-9F86-03F232998927', '7A6D08A3-DB1C-445C-8FEE-52E108F5E215', '8AA3B9B8-D2B6-4D55-A3FC-0395CD31FC52', 'B1335701-77AD-48E8-8384-13EE0A4C7AA6', 'D2377297-85F4-4F80-A7C1-97C4C9D341B0', 'F1D7419B-13D1-4D95-8AF7-0D95AED30BF2') and `PR_Categories`.`deleted_at` is null and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `parentId` = '8452459B-2689-4B32-BF7A-18D7DB57EDF7' and `slug` = 'toyota-genuine' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `stockCode` like 'jc%00609' and (title like 'vortex%rch%trackmount%black%2%bar%canopy%roof%rack' or title_US_CA like 'vortex%rch%trackmount%black%2%bar%canopy%roof%rack') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Medias` where `mediaUrl` is not null and `mediaUrl` <> '' and `contentType` = 1 and (`vehicleId` is null or exists (select * from `PR_Products` where `PR_Medias`.`productId` = `PR_Products`.`productId` and (select count(*) from `PR_VehicleProducts` where `PR_Products`.`productId` = `PR_VehicleProducts`.`productId` and `PR_VehicleProducts`.`deleted_at` is null and (`PR_VehicleProducts`.`lngId` is null or `PR_VehicleProducts`.`lngId` = '7') order by `lngId` desc) = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc)) and `PR_Medias`.`productId` in ('2983AA05-9CDD-4A41-AB1F-2DCB0AE97534') and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '7') and `isActive` = 1 order by `vehicleId` desc, `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Medias` where `embedCode` is not null and `embedCode` <> '' and `PR_Medias`.`productId` in ('2983AA05-9CDD-4A41-AB1F-2DCB0AE97534') and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '7') and `isActive` = 1 order by `vehicleId` asc, `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Links` where `vehicleId` is null and `PR_Links`.`productId` in ('2983AA05-9CDD-4A41-AB1F-2DCB0AE97534') and `PR_Links`.`deleted_at` is null and (`PR_Links`.`lngId` is null or `PR_Links`.`lngId` = '7') order by `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCompatibilities` where exists (select * from `PR_Products` where `PR_ProductCompatibilities`.`productId2` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_ProductCompatibilities`.`productId1` in ('2983AA05-9CDD-4A41-AB1F-2DCB0AE97534') and `PR_ProductCompatibilities`.`deleted_at` is null and (`PR_ProductCompatibilities`.`lngId` is null or `PR_ProductCompatibilities`.`lngId` = '7') order by `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductSpareParts` where exists (select * from `PR_Products` where `PR_ProductSpareParts`.`productId2` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_ProductSpareParts`.`productId1` in ('2983AA05-9CDD-4A41-AB1F-2DCB0AE97534') and `PR_ProductSpareParts`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_WindFairings` where exists (select * from `PR_Products` where `PR_WindFairings`.`productId2` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_WindFairings`.`productId1` in ('2983AA05-9CDD-4A41-AB1F-2DCB0AE97534') and `lngId` = 7 and `PR_WindFairings`.`deleted_at` is null order by `id` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductSpecifications` where `PR_ProductSpecifications`.`productId` in ('2983AA05-9CDD-4A41-AB1F-2DCB0AE97534') and `PR_ProductSpecifications`.`deleted_at` is null
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Specifications` where `PR_Specifications`.`specificationId` in ('1298F3AA-BDBF-44E3-BC7B-9A4A42E539AF', '14F3FB81-8947-4E5E-BB23-2F17B1452EF2', '2261BB38-5354-44FE-B45C-849D201849B0', '2A37E3E3-CB54-453A-9EE9-53B3406A76CB', '33C27305-6859-4DF9-9CC5-FB5E0806602D', '6284DBED-EF43-4436-A768-B530DA94D027', '65DE24DC-83D6-4790-8EDE-0DEAD147EF02', '65EBFA01-7744-4861-803E-BA026DFC9BA0', '6FEC7B95-51EA-498A-A900-8FD5DA6C89D2', 'AEF3ACA8-93E7-4674-B28B-1AECF6611583', 'AFDBF6AE-7B97-42D6-8960-BC87744D5F7F', 'C2625794-E9E2-40F4-AD72-26B5C1878B75', 'CCBF1F5D-ADE4-4020-BBA9-A81B1D4019B6', 'DBEE4D87-9FCC-4FA9-9D1D-7C8822B2A568', 'E4BEE2B3-3F00-4174-8C5C-F7F11EC125BE', 'F59236C8-DE3C-45A9-975D-0E0EE462E09E') and `PR_Specifications`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductSpecificationProperties` where `PR_ProductSpecificationProperties`.`productId` in ('2983AA05-9CDD-4A41-AB1F-2DCB0AE97534') and `PR_ProductSpecificationProperties`.`deleted_at` is null
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`productId` in ('2983AA05-9CDD-4A41-AB1F-2DCB0AE97534') and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('05F86187-482A-48FE-ACAC-42454854124F', '0B2D0762-7818-4C72-8CA9-10498FE806D9', 'D872661D-7FD5-4986-BC31-1BB4C789005C', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Medias` where `mediaUrl` is not null and `mediaUrl` <> '' and `contentType` = 1 and (`vehicleId` is null or exists (select * from `PR_Products` where `PR_Medias`.`productId` = `PR_Products`.`productId` and (select count(*) from `PR_VehicleProducts` where `PR_Products`.`productId` = `PR_VehicleProducts`.`productId` and `PR_VehicleProducts`.`deleted_at` is null and (`PR_VehicleProducts`.`lngId` is null or `PR_VehicleProducts`.`lngId` = '7') order by `lngId` desc) = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc)) and `PR_Medias`.`productId` in ('05F86187-482A-48FE-ACAC-42454854124F', '0B2D0762-7818-4C72-8CA9-10498FE806D9', 'D872661D-7FD5-4986-BC31-1BB4C789005C', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B') and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '7') and `isActive` = 1 order by `vehicleId` desc, `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `CM_CanopyProducts` where `CM_CanopyProducts`.`productId` in ('2983AA05-9CDD-4A41-AB1F-2DCB0AE97534') and `CM_CanopyProducts`.`deleted_at` is null and (`CM_CanopyProducts`.`lngId` is null or `CM_CanopyProducts`.`lngId` = '7') order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `CM_Canopies` where `CM_Canopies`.`canopyId` in ('DEF14CEE-6D80-4E4C-A6A1-2F9270850013', 'DEF14CEE-6D80-4E4C-A6A1-2F9270850014') and `CM_Canopies`.`deleted_at` is null and (`CM_Canopies`.`lngId` is null or `CM_Canopies`.`lngId` = '7') and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `CM_Manufacturers` where `CM_Manufacturers`.`manufacturerId` in ('49249A89-93D3-45DE-907A-B2DD75C10008', '49249A89-93D3-45DE-907A-B2DD75C10009') and `CM_Manufacturers`.`deleted_at` is null and (`CM_Manufacturers`.`lngId` is null or `CM_Manufacturers`.`lngId` = '7') and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `CM_CanopyVehicleTypes` where `CM_CanopyVehicleTypes`.`vehicleTypeId` in ('23AA629C-5EB0-4CA6-85A2-69C97CA10038', 'C759FEF7-B45B-426F-89D5-EEBCDE997D9F') and `CM_CanopyVehicleTypes`.`deleted_at` is null and (`CM_CanopyVehicleTypes`.`lngId` is null or `CM_CanopyVehicleTypes`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_BarTypeProductCompatibilities` inner join `PR_BarTypes` on `PR_BarTypeProductCompatibilities`.`barTypeId` = `PR_BarTypes`.`barTypeId` where `PR_BarTypeProductCompatibilities`.`productId` in ('2983AA05-9CDD-4A41-AB1F-2DCB0AE97534') and PR_BarTypes.lngId=7 and `PR_BarTypeProductCompatibilities`.`deleted_at` is null order by `PR_BarTypes`.`order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `productId2`, `order`, `lngId` from `PR_RelatedProducts` where `productId1` = '2983AA05-9CDD-4A41-AB1F-2DCB0AE97534' and `PR_RelatedProducts`.`deleted_at` is null and (`PR_RelatedProducts`.`lngId` is null or `PR_RelatedProducts`.`lngId` = '7') order by `order` asc, `id` desc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `productId2`, `order`, `lngId` from `PR_RelatedProducts` where `productId1` in ('EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F', '0B2D0762-7818-4C72-8CA9-10498FE806D9', 'D872661D-7FD5-4986-BC31-1BB4C789005C') and `PR_RelatedProducts`.`deleted_at` is null and (`PR_RelatedProducts`.`lngId` is null or `PR_RelatedProducts`.`lngId` = '7') order by `order` asc, `id` desc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductSpecificationProperties` where `PR_ProductSpecificationProperties`.`productId` = '2983AA05-9CDD-4A41-AB1F-2DCB0AE97534' and `PR_ProductSpecificationProperties`.`productId` is not null and exists (select * from `PR_SpecificationProperties` where `PR_ProductSpecificationProperties`.`specificationPropertyId` = `PR_SpecificationProperties`.`specificationPropertyId` and `PR_SpecificationProperties`.`deleted_at` is null order by `order` asc) and `PR_ProductSpecificationProperties`.`deleted_at` is null
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_SpecificationProperties` where `PR_SpecificationProperties`.`specificationPropertyId` in ('1404128B-8306-4A41-926F-05ACF8F3B461', '22D06B2F-4F51-4E1B-B599-B3E1C01E8627', '3178C8C8-BCD1-49B2-8B42-5D6A9F870FE9', '36233E8D-5640-404E-BE06-765E3B9EE8FB', '48062BB7-CD0E-41B9-88D0-4C6174AD6AAF', '59B96AF4-09D2-47B0-87D6-BA9A4C61F6AB', '6B65CCB5-C611-4252-AC40-B081C6520F2E', '9DAB68AF-1462-455F-9B00-9C8FDE0F92AA', 'B2B090A4-D7F1-48B1-BB9A-7979E5D901D2', 'BDB99B83-7053-4913-94AA-4A53DBDE5668', 'D78F6505-9766-4732-A858-73785505B425') and `PR_SpecificationProperties`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Specifications` where `PR_Specifications`.`specificationId` in ('1298F3AA-BDBF-44E3-BC7B-9A4A42E539AF', '14F3FB81-8947-4E5E-BB23-2F17B1452EF2', '2261BB38-5354-44FE-B45C-849D201849B0', '2A37E3E3-CB54-453A-9EE9-53B3406A76CB', '6284DBED-EF43-4436-A768-B530DA94D027', '65DE24DC-83D6-4790-8EDE-0DEAD147EF02', '65EBFA01-7744-4861-803E-BA026DFC9BA0', '6FEC7B95-51EA-498A-A900-8FD5DA6C89D2', 'AEF3ACA8-93E7-4674-B28B-1AECF6611583', 'AFDBF6AE-7B97-42D6-8960-BC87744D5F7F', 'CCBF1F5D-ADE4-4020-BBA9-A81B1D4019B6') and `PR_Specifications`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_SpecificationPropertyMasterData` where `PR_SpecificationPropertyMasterData`.`specificationPropertyMasterDataId` in ('13EE9F51-90CA-4128-9C57-2DB36ED18057', '15BB5D02-A2F6-4C55-A2D1-C8A9A4C4177C', '308A2222-0273-4663-B9AD-F8E7C0000015', '30D68F7A-9767-4A85-A202-7E2D36DDA630', '66E7F1BA-B555-492C-9374-8F26C71C15F1', '6C9D3CFB-941F-4A87-8D5E-75DD2A98D884', '706802A1-C753-4C62-AFE7-AC2A34C21017', '97623ACD-37D7-43A6-88A9-F7EB6B05B75E', 'F3B62232-BF24-465B-85FC-31F14EEFE3C8') and `PR_SpecificationPropertyMasterData`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `id`, `specificationPropertyMasterDataId`, `key`, `name`, `value` from `PR_SpecificationPropertyMasterData_Features` where `PR_SpecificationPropertyMasterData_Features`.`specificationPropertyMasterDataId` in ('13EE9F51-90CA-4128-9C57-2DB36ED18057', '15BB5D02-A2F6-4C55-A2D1-C8A9A4C4177C', '308A2222-0273-4663-B9AD-F8E7C0000015', '30D68F7A-9767-4A85-A202-7E2D36DDA630', '66E7F1BA-B555-492C-9374-8F26C71C15F1', '6C9D3CFB-941F-4A87-8D5E-75DD2A98D884', '706802A1-C753-4C62-AFE7-AC2A34C21017', '97623ACD-37D7-43A6-88A9-F7EB6B05B75E', 'F3B62232-BF24-465B-85FC-31F14EEFE3C8') and `PR_SpecificationPropertyMasterData_Features`.`deleted_at` is null and (`PR_SpecificationPropertyMasterData_Features`.`lngId` is null or `PR_SpecificationPropertyMasterData_Features`.`lngId` = 7) order by `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '2983AA05-9CDD-4A41-AB1F-2DCB0AE97534' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '3B393703-FAA0-4701-A5B4-DFA329A3DC9B', '864AA342-55D0-4D5A-89AE-DCD4F01CE4AE', 'ECCC67CC-BA48-4F54-8D20-6F3C4C569743') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `specificationId` from `PR_CategorySpecifications` where `categoryId` in ('3B393703-FAA0-4701-A5B4-DFA329A3DC9B', 'ECCC67CC-BA48-4F54-8D20-6F3C4C569743', '864AA342-55D0-4D5A-89AE-DCD4F01CE4AE', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `isVisibleOnProduct` = 1 and `PR_CategorySpecifications`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `title` from `PR_Specifications` where `specificationId` in ('AEF3ACA8-93E7-4674-B28B-1AECF6611583', '14F3FB81-8947-4E5E-BB23-2F17B1452EF2', '2A37E3E3-CB54-453A-9EE9-53B3406A76CB', '2261BB38-5354-44FE-B45C-849D201849B0', '6FEC7B95-51EA-498A-A900-8FD5DA6C89D2', '1298F3AA-BDBF-44E3-BC7B-9A4A42E539AF', '6284DBED-EF43-4436-A768-B530DA94D027', '65EBFA01-7744-4861-803E-BA026DFC9BA0', '7A90BAEF-94DE-4E35-9446-A53AE478B8C7') and `PR_Specifications`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCustomSpecification` where `PR_ProductCustomSpecification`.`ProductId` = '2983AA05-9CDD-4A41-AB1F-2DCB0AE97534' and `PR_ProductCustomSpecification`.`ProductId` is not null and `PR_ProductCustomSpecification`.`deleted_at` is null order by `order` asc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('05F86187-482A-48FE-ACAC-42454854124F', '0B2D0762-7818-4C72-8CA9-10498FE806D9', 'D872661D-7FD5-4986-BC31-1BB4C789005C', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Links` where `vehicleId` is null and `PR_Links`.`productId` in ('05F86187-482A-48FE-ACAC-42454854124F', '0B2D0762-7818-4C72-8CA9-10498FE806D9', 'D872661D-7FD5-4986-BC31-1BB4C789005C', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B') and `PR_Links`.`deleted_at` is null and (`PR_Links`.`lngId` is null or `PR_Links`.`lngId` = '7') order by `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_LinkNames` where `PR_LinkNames`.`linkNameId` in ('4A65457B-DF19-4771-99C7-D4BE4B313755', '6F803376-8210-4FCB-823C-0D1ED8CF52AF', '7BEC1597-3FE2-4512-B2AB-81B3D45734E7', 'B7270C14-0850-4705-B117-DA5B4401FA94') and `PR_LinkNames`.`deleted_at` is null and (`PR_LinkNames`.`lngId` is null or `PR_LinkNames`.`lngId` = 7) order by `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '2983AA05-9CDD-4A41-AB1F-2DCB0AE97534' and `PR_ProductCategories`.`productId` is not null and `categoryId` in ('2B39426A-55C6-45D5-9418-5A79A0166DEA', '23C6863F-91C0-44EE-B8DB-949A42E96573', 'DBE8AFC5-A2D9-4715-BB32-79424DBECA14', 'F7380C9C-AF6D-4B3D-82C9-17E81216DCA2') and `PR_ProductCategories`.`deleted_at` is null
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductSpareParts` where `PR_ProductSpareParts`.`productId1` = 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B' and `PR_ProductSpareParts`.`productId1` is not null and exists (select * from `PR_Products` where `PR_ProductSpareParts`.`productId2` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_ProductSpareParts`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('507AEDCA-4FA0-4B63-8AA4-BBCA422C05E3', '5737D782-2372-409E-ACA8-A2EE32A4A7AF', '61E84CE6-8D37-4D57-9335-98D7B69BE9BB', '81017A1D-D7F1-465A-8F71-C202FB9E50B7', '8631BC7A-EEA0-4493-ACC0-BBE87A548574', 'A370E503-D47F-4479-8387-384C95C59458', 'B845D6C5-F078-4D34-BE15-D394D64B9011') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '05F86187-482A-48FE-ACAC-42454854124F' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductSpareParts` where `PR_ProductSpareParts`.`productId1` = '05F86187-482A-48FE-ACAC-42454854124F' and `PR_ProductSpareParts`.`productId1` is not null and exists (select * from `PR_Products` where `PR_ProductSpareParts`.`productId2` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_ProductSpareParts`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('507AEDCA-4FA0-4B63-8AA4-BBCA422C05E3', 'A1F8181A-8E45-44C3-9F57-68BA9226C338', 'B845D6C5-F078-4D34-BE15-D394D64B9011', 'E784A82A-4169-4DF0-ADAC-6AEBB435CBD2') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = '0B2D0762-7818-4C72-8CA9-10498FE806D9' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductSpareParts` where `PR_ProductSpareParts`.`productId1` = '0B2D0762-7818-4C72-8CA9-10498FE806D9' and `PR_ProductSpareParts`.`productId1` is not null and exists (select * from `PR_Products` where `PR_ProductSpareParts`.`productId2` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_ProductSpareParts`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('40FD3D7C-73DC-4197-9D07-CA2BDE437CDC', '718F31D7-A41D-4202-B4FB-133A89100329') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = 'D872661D-7FD5-4986-BC31-1BB4C789005C' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductSpareParts` where `PR_ProductSpareParts`.`productId1` = 'D872661D-7FD5-4986-BC31-1BB4C789005C' and `PR_ProductSpareParts`.`productId1` is not null and exists (select * from `PR_Products` where `PR_ProductSpareParts`.`productId2` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_ProductSpareParts`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('2A83C842-9278-44DB-92B2-E9ED8A752FDF', '6E941F21-EFA3-434C-BE65-7B3FCE835CC1', '7828112D-94AA-450E-BB8E-DCB4688CB564', 'CA4DB0DE-794F-4B8C-86B4-B6268D2D9972', 'D06245D5-8FAA-4F34-9B56-93DF46C8C302') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_CategoryProductImages` where `categoryId` in ('3B393703-FAA0-4701-A5B4-DFA329A3DC9B', 'ECCC67CC-BA48-4F54-8D20-6F3C4C569743', '864AA342-55D0-4D5A-89AE-DCD4F01CE4AE', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `lngId` = 7 and `categoryId1` is not null and `categoryId2` is not null and `deleted_at` is null
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `parentId` from `PR_Categories` where `categoryId` in ('3B393703-FAA0-4701-A5B4-DFA329A3DC9B', 'ECCC67CC-BA48-4F54-8D20-6F3C4C569743', '864AA342-55D0-4D5A-89AE-DCD4F01CE4AE', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `lngId` = 7 and `deleted_at` is null
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_CategoryProductImages` where `categoryId` in ('5480AA8E-3C8D-4831-8005-8E1D56C668EA', '13674F82-0F17-442D-AD28-13A8C7683425', '8452459B-2689-4B32-BF7A-18D7DB57EDF7', '8452459B-2689-4B32-BF7A-18D7DB57EDF7') and `lngId` = 7 and `categoryId1` is not null and (`categoryId2` = '' or `categoryId2` is null) and `deleted_at` is null
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `parentId` from `PR_Categories` where `categoryId` in ('5480AA8E-3C8D-4831-8005-8E1D56C668EA', '13674F82-0F17-442D-AD28-13A8C7683425', '8452459B-2689-4B32-BF7A-18D7DB57EDF7', '8452459B-2689-4B32-BF7A-18D7DB57EDF7') and `lngId` = 7 and `deleted_at` is null
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_CategoryProductImages` where `categoryId` in ('5C2DD4F5-056B-4961-B309-A37BA1BC5A4E', 'F1D7419B-13D1-4D95-8AF7-0D95AED30BF2', '5C2DD4F5-056B-4961-B309-A37BA1BC5A4E') and `lngId` = 7 and (`categoryId1` = '' or `categoryId1` is null) and (`categoryId2` = '' or `categoryId2` is null) and `deleted_at` is null
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductBanners` where `PR_ProductBanners`.`productId` = '2983AA05-9CDD-4A41-AB1F-2DCB0AE97534' and `PR_ProductBanners`.`productId` is not null and `PR_ProductBanners`.`deleted_at` is null
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ZwiflocRetrofit` where `PR_ZwiflocRetrofit`.`productId1` = '2983AA05-9CDD-4A41-AB1F-2DCB0AE97534' and `PR_ZwiflocRetrofit`.`productId1` is not null and exists (select * from `PR_Products` where `PR_ZwiflocRetrofit`.`productId2` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_ZwiflocRetrofit`.`deleted_at` is null and (`PR_ZwiflocRetrofit`.`lngId` is null or `PR_ZwiflocRetrofit`.`lngId` = 7) order by `id` asc, `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ZwiflocRetrofit` where `PR_ZwiflocRetrofit`.`productId1` = 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B' and `PR_ZwiflocRetrofit`.`productId1` is not null and exists (select * from `PR_Products` where `PR_ZwiflocRetrofit`.`productId2` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `lngId` = 7 and `PR_ZwiflocRetrofit`.`deleted_at` is null and (`PR_ZwiflocRetrofit`.`lngId` is null or `PR_ZwiflocRetrofit`.`lngId` = 7) order by `id` asc, `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ZwiflocRetrofit` where `PR_ZwiflocRetrofit`.`productId1` = '05F86187-482A-48FE-ACAC-42454854124F' and `PR_ZwiflocRetrofit`.`productId1` is not null and exists (select * from `PR_Products` where `PR_ZwiflocRetrofit`.`productId2` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `lngId` = 7 and `PR_ZwiflocRetrofit`.`deleted_at` is null and (`PR_ZwiflocRetrofit`.`lngId` is null or `PR_ZwiflocRetrofit`.`lngId` = 7) order by `id` asc, `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ZwiflocRetrofit` where `PR_ZwiflocRetrofit`.`productId1` = '0B2D0762-7818-4C72-8CA9-10498FE806D9' and `PR_ZwiflocRetrofit`.`productId1` is not null and exists (select * from `PR_Products` where `PR_ZwiflocRetrofit`.`productId2` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `lngId` = 7 and `PR_ZwiflocRetrofit`.`deleted_at` is null and (`PR_ZwiflocRetrofit`.`lngId` is null or `PR_ZwiflocRetrofit`.`lngId` = 7) order by `id` asc, `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ZwiflocRetrofit` where `PR_ZwiflocRetrofit`.`productId1` = 'D872661D-7FD5-4986-BC31-1BB4C789005C' and `PR_ZwiflocRetrofit`.`productId1` is not null and exists (select * from `PR_Products` where `PR_ZwiflocRetrofit`.`productId2` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `lngId` = 7 and `PR_ZwiflocRetrofit`.`deleted_at` is null and (`PR_ZwiflocRetrofit`.`lngId` is null or `PR_ZwiflocRetrofit`.`lngId` = 7) order by `id` asc, `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `parentId` = '8452459B-2689-4B32-BF7A-18D7DB57EDF7' and `slug` = 'toyota-genuine' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `stockCode` like 'jc%00609' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Medias` where `mediaUrl` is not null and `mediaUrl` <> '' and `contentType` = 1 and (`vehicleId` is null or exists (select * from `PR_Products` where `PR_Medias`.`productId` = `PR_Products`.`productId` and (select count(*) from `PR_VehicleProducts` where `PR_Products`.`productId` = `PR_VehicleProducts`.`productId` and `PR_VehicleProducts`.`deleted_at` is null and (`PR_VehicleProducts`.`lngId` is null or `PR_VehicleProducts`.`lngId` = '7') order by `lngId` desc) = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc)) and `PR_Medias`.`productId` in ('2983AA05-9CDD-4A41-AB1F-2DCB0AE97534') and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '7') and `isActive` = 1 order by `vehicleId` desc, `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Medias` where `embedCode` is not null and `embedCode` <> '' and `PR_Medias`.`productId` in ('2983AA05-9CDD-4A41-AB1F-2DCB0AE97534') and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '7') and `isActive` = 1 order by `vehicleId` asc, `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Links` where `vehicleId` is null and `PR_Links`.`productId` in ('2983AA05-9CDD-4A41-AB1F-2DCB0AE97534') and `PR_Links`.`deleted_at` is null and (`PR_Links`.`lngId` is null or `PR_Links`.`lngId` = '7') order by `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCompatibilities` where exists (select * from `PR_Products` where `PR_ProductCompatibilities`.`productId2` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_ProductCompatibilities`.`productId1` in ('2983AA05-9CDD-4A41-AB1F-2DCB0AE97534') and `PR_ProductCompatibilities`.`deleted_at` is null and (`PR_ProductCompatibilities`.`lngId` is null or `PR_ProductCompatibilities`.`lngId` = '7') order by `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductSpareParts` where exists (select * from `PR_Products` where `PR_ProductSpareParts`.`productId2` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_ProductSpareParts`.`productId1` in ('2983AA05-9CDD-4A41-AB1F-2DCB0AE97534') and `PR_ProductSpareParts`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_WindFairings` where exists (select * from `PR_Products` where `PR_WindFairings`.`productId2` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_WindFairings`.`productId1` in ('2983AA05-9CDD-4A41-AB1F-2DCB0AE97534') and `lngId` = 7 and `PR_WindFairings`.`deleted_at` is null order by `id` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductSpecifications` where `PR_ProductSpecifications`.`productId` in ('2983AA05-9CDD-4A41-AB1F-2DCB0AE97534') and `PR_ProductSpecifications`.`deleted_at` is null
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Specifications` where `PR_Specifications`.`specificationId` in ('1298F3AA-BDBF-44E3-BC7B-9A4A42E539AF', '14F3FB81-8947-4E5E-BB23-2F17B1452EF2', '2261BB38-5354-44FE-B45C-849D201849B0', '2A37E3E3-CB54-453A-9EE9-53B3406A76CB', '33C27305-6859-4DF9-9CC5-FB5E0806602D', '6284DBED-EF43-4436-A768-B530DA94D027', '65DE24DC-83D6-4790-8EDE-0DEAD147EF02', '65EBFA01-7744-4861-803E-BA026DFC9BA0', '6FEC7B95-51EA-498A-A900-8FD5DA6C89D2', 'AEF3ACA8-93E7-4674-B28B-1AECF6611583', 'AFDBF6AE-7B97-42D6-8960-BC87744D5F7F', 'C2625794-E9E2-40F4-AD72-26B5C1878B75', 'CCBF1F5D-ADE4-4020-BBA9-A81B1D4019B6', 'DBEE4D87-9FCC-4FA9-9D1D-7C8822B2A568', 'E4BEE2B3-3F00-4174-8C5C-F7F11EC125BE', 'F59236C8-DE3C-45A9-975D-0E0EE462E09E') and `PR_Specifications`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductSpecificationProperties` where `PR_ProductSpecificationProperties`.`productId` in ('2983AA05-9CDD-4A41-AB1F-2DCB0AE97534') and `PR_ProductSpecificationProperties`.`deleted_at` is null
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`productId` in ('2983AA05-9CDD-4A41-AB1F-2DCB0AE97534') and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('05F86187-482A-48FE-ACAC-42454854124F', '0B2D0762-7818-4C72-8CA9-10498FE806D9', 'D872661D-7FD5-4986-BC31-1BB4C789005C', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Medias` where `mediaUrl` is not null and `mediaUrl` <> '' and `contentType` = 1 and (`vehicleId` is null or exists (select * from `PR_Products` where `PR_Medias`.`productId` = `PR_Products`.`productId` and (select count(*) from `PR_VehicleProducts` where `PR_Products`.`productId` = `PR_VehicleProducts`.`productId` and `PR_VehicleProducts`.`deleted_at` is null and (`PR_VehicleProducts`.`lngId` is null or `PR_VehicleProducts`.`lngId` = '7') order by `lngId` desc) = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc)) and `PR_Medias`.`productId` in ('05F86187-482A-48FE-ACAC-42454854124F', '0B2D0762-7818-4C72-8CA9-10498FE806D9', 'D872661D-7FD5-4986-BC31-1BB4C789005C', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B') and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '7') and `isActive` = 1 order by `vehicleId` desc, `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `CM_CanopyProducts` where `CM_CanopyProducts`.`productId` in ('2983AA05-9CDD-4A41-AB1F-2DCB0AE97534') and `CM_CanopyProducts`.`deleted_at` is null and (`CM_CanopyProducts`.`lngId` is null or `CM_CanopyProducts`.`lngId` = '7') order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `CM_Canopies` where `CM_Canopies`.`canopyId` in ('DEF14CEE-6D80-4E4C-A6A1-2F9270850013', 'DEF14CEE-6D80-4E4C-A6A1-2F9270850014') and `CM_Canopies`.`deleted_at` is null and (`CM_Canopies`.`lngId` is null or `CM_Canopies`.`lngId` = '7') and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `CM_Manufacturers` where `CM_Manufacturers`.`manufacturerId` in ('49249A89-93D3-45DE-907A-B2DD75C10008', '49249A89-93D3-45DE-907A-B2DD75C10009') and `CM_Manufacturers`.`deleted_at` is null and (`CM_Manufacturers`.`lngId` is null or `CM_Manufacturers`.`lngId` = '7') and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `CM_CanopyVehicleTypes` where `CM_CanopyVehicleTypes`.`vehicleTypeId` in ('23AA629C-5EB0-4CA6-85A2-69C97CA10038', 'C759FEF7-B45B-426F-89D5-EEBCDE997D9F') and `CM_CanopyVehicleTypes`.`deleted_at` is null and (`CM_CanopyVehicleTypes`.`lngId` is null or `CM_CanopyVehicleTypes`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_BarTypeProductCompatibilities` inner join `PR_BarTypes` on `PR_BarTypeProductCompatibilities`.`barTypeId` = `PR_BarTypes`.`barTypeId` where `PR_BarTypeProductCompatibilities`.`productId` in ('2983AA05-9CDD-4A41-AB1F-2DCB0AE97534') and PR_BarTypes.lngId=7 and `PR_BarTypeProductCompatibilities`.`deleted_at` is null order by `PR_BarTypes`.`order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '2983AA05-9CDD-4A41-AB1F-2DCB0AE97534' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '3B393703-FAA0-4701-A5B4-DFA329A3DC9B', '864AA342-55D0-4D5A-89AE-DCD4F01CE4AE', 'ECCC67CC-BA48-4F54-8D20-6F3C4C569743') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `specificationId` from `PR_CategorySpecifications` where `categoryId` in ('3B393703-FAA0-4701-A5B4-DFA329A3DC9B', 'ECCC67CC-BA48-4F54-8D20-6F3C4C569743', '864AA342-55D0-4D5A-89AE-DCD4F01CE4AE', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `isVisibleOnProduct` = 1 and `PR_CategorySpecifications`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `title` from `PR_Specifications` where `specificationId` in ('AEF3ACA8-93E7-4674-B28B-1AECF6611583', '14F3FB81-8947-4E5E-BB23-2F17B1452EF2', '2A37E3E3-CB54-453A-9EE9-53B3406A76CB', '2261BB38-5354-44FE-B45C-849D201849B0', '6FEC7B95-51EA-498A-A900-8FD5DA6C89D2', '1298F3AA-BDBF-44E3-BC7B-9A4A42E539AF', '6284DBED-EF43-4436-A768-B530DA94D027', '65EBFA01-7744-4861-803E-BA026DFC9BA0', '7A90BAEF-94DE-4E35-9446-A53AE478B8C7') and `PR_Specifications`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCustomSpecification` where `PR_ProductCustomSpecification`.`ProductId` = '2983AA05-9CDD-4A41-AB1F-2DCB0AE97534' and `PR_ProductCustomSpecification`.`ProductId` is not null and `PR_ProductCustomSpecification`.`deleted_at` is null order by `order` asc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('05F86187-482A-48FE-ACAC-42454854124F', '0B2D0762-7818-4C72-8CA9-10498FE806D9', 'D872661D-7FD5-4986-BC31-1BB4C789005C', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Links` where `vehicleId` is null and `PR_Links`.`productId` in ('05F86187-482A-48FE-ACAC-42454854124F', '0B2D0762-7818-4C72-8CA9-10498FE806D9', 'D872661D-7FD5-4986-BC31-1BB4C789005C', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B') and `PR_Links`.`deleted_at` is null and (`PR_Links`.`lngId` is null or `PR_Links`.`lngId` = '7') order by `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_LinkNames` where `PR_LinkNames`.`linkNameId` in ('4A65457B-DF19-4771-99C7-D4BE4B313755', '6F803376-8210-4FCB-823C-0D1ED8CF52AF', '7BEC1597-3FE2-4512-B2AB-81B3D45734E7', 'B7270C14-0850-4705-B117-DA5B4401FA94') and `PR_LinkNames`.`deleted_at` is null and (`PR_LinkNames`.`lngId` is null or `PR_LinkNames`.`lngId` = 7) order by `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `productId` = '2983AA05-9CDD-4A41-AB1F-2DCB0AE97534' and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('3B393703-FAA0-4701-A5B4-DFA329A3DC9B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Medias` where `PR_Medias`.`productId` = '2983AA05-9CDD-4A41-AB1F-2DCB0AE97534' and `PR_Medias`.`productId` is not null and `mediaUrl` is not null and `mediaUrl` <> '' and `contentType` = 1 and (`vehicleId` is null or exists (select * from `PR_Products` where `PR_Medias`.`productId` = `PR_Products`.`productId` and (select count(*) from `PR_VehicleProducts` where `PR_Products`.`productId` = `PR_VehicleProducts`.`productId` and `PR_VehicleProducts`.`deleted_at` is null and (`PR_VehicleProducts`.`lngId` is null or `PR_VehicleProducts`.`lngId` = '7') order by `lngId` desc) = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc)) and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '7') and `isActive` = 1 order by `vehicleId` desc, `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Medias` where `PR_Medias`.`productId` = '2983AA05-9CDD-4A41-AB1F-2DCB0AE97534' and `PR_Medias`.`productId` is not null and `embedCode` is not null and `embedCode` <> '' and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '7') and `isActive` = 1 order by `vehicleId` asc, `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Medias` where `PR_Medias`.`productId` = 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B' and `PR_Medias`.`productId` is not null and `mediaUrl` is not null and `mediaUrl` <> '' and `contentType` = 1 and (`vehicleId` is null or exists (select * from `PR_Products` where `PR_Medias`.`productId` = `PR_Products`.`productId` and (select count(*) from `PR_VehicleProducts` where `PR_Products`.`productId` = `PR_VehicleProducts`.`productId` and `PR_VehicleProducts`.`deleted_at` is null and (`PR_VehicleProducts`.`lngId` is null or `PR_VehicleProducts`.`lngId` = '7') order by `lngId` desc) = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc)) and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '7') and `isActive` = 1 order by `vehicleId` desc, `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Medias` where `PR_Medias`.`productId` = '05F86187-482A-48FE-ACAC-42454854124F' and `PR_Medias`.`productId` is not null and `mediaUrl` is not null and `mediaUrl` <> '' and `contentType` = 1 and (`vehicleId` is null or exists (select * from `PR_Products` where `PR_Medias`.`productId` = `PR_Products`.`productId` and (select count(*) from `PR_VehicleProducts` where `PR_Products`.`productId` = `PR_VehicleProducts`.`productId` and `PR_VehicleProducts`.`deleted_at` is null and (`PR_VehicleProducts`.`lngId` is null or `PR_VehicleProducts`.`lngId` = '7') order by `lngId` desc) = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc)) and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '7') and `isActive` = 1 order by `vehicleId` desc, `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Medias` where `PR_Medias`.`productId` = '0B2D0762-7818-4C72-8CA9-10498FE806D9' and `PR_Medias`.`productId` is not null and `mediaUrl` is not null and `mediaUrl` <> '' and `contentType` = 1 and (`vehicleId` is null or exists (select * from `PR_Products` where `PR_Medias`.`productId` = `PR_Products`.`productId` and (select count(*) from `PR_VehicleProducts` where `PR_Products`.`productId` = `PR_VehicleProducts`.`productId` and `PR_VehicleProducts`.`deleted_at` is null and (`PR_VehicleProducts`.`lngId` is null or `PR_VehicleProducts`.`lngId` = '7') order by `lngId` desc) = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc)) and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '7') and `isActive` = 1 order by `vehicleId` desc, `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Medias` where `PR_Medias`.`productId` = 'D872661D-7FD5-4986-BC31-1BB4C789005C' and `PR_Medias`.`productId` is not null and `mediaUrl` is not null and `mediaUrl` <> '' and `contentType` = 1 and (`vehicleId` is null or exists (select * from `PR_Products` where `PR_Medias`.`productId` = `PR_Products`.`productId` and (select count(*) from `PR_VehicleProducts` where `PR_Products`.`productId` = `PR_VehicleProducts`.`productId` and `PR_VehicleProducts`.`deleted_at` is null and (`PR_VehicleProducts`.`lngId` is null or `PR_VehicleProducts`.`lngId` = '7') order by `lngId` desc) = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc)) and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '7') and `isActive` = 1 order by `vehicleId` desc, `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_VehicleProducts` where `PR_VehicleProducts`.`productId` = '2983AA05-9CDD-4A41-AB1F-2DCB0AE97534' and `PR_VehicleProducts`.`productId` is not null and exists (select * from `VM_Vehicles` where `PR_VehicleProducts`.`vehicleId` = `VM_Vehicles`.`vehicleId` and exists (select * from `VM_Models` where `VM_Vehicles`.`modelId` = `VM_Models`.`modelId` and `VM_Models`.`deleted_at` is null and (`VM_Models`.`lngId` is null or `VM_Models`.`lngId` = '7') and `isActive` = 1 order by `lngId` desc) and `VM_Vehicles`.`deleted_at` is null and (`VM_Vehicles`.`lngId` is null or `VM_Vehicles`.`lngId` = '7') and `isActive` = 1 order by `lngId` desc) and `PR_VehicleProducts`.`deleted_at` is null and (`PR_VehicleProducts`.`lngId` is null or `PR_VehicleProducts`.`lngId` = '7') order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('3B393703-FAA0-4701-A5B4-DFA329A3DC9B', 'ECCC67CC-BA48-4F54-8D20-6F3C4C569743', '864AA342-55D0-4D5A-89AE-DCD4F01CE4AE', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `isRoofRackCategory` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `fmv_product_specifications` where `fmv_product_specifications`.`productId` = '2983AA05-9CDD-4A41-AB1F-2DCB0AE97534' and `fmv_product_specifications`.`productId` is not null and `fmv_product_specifications`.`deleted_at` is null and (`fmv_product_specifications`.`lngId` is null or `fmv_product_specifications`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '5737D782-2372-409E-ACA8-A2EE32A4A7AF' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', '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` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '5737D782-2372-409E-ACA8-A2EE32A4A7AF' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select 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` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', '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` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '61E84CE6-8D37-4D57-9335-98D7B69BE9BB' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '61E84CE6-8D37-4D57-9335-98D7B69BE9BB' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '8631BC7A-EEA0-4493-ACC0-BBE87A548574' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', '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` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '8631BC7A-EEA0-4493-ACC0-BBE87A548574' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select 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` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', '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` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '81017A1D-D7F1-465A-8F71-C202FB9E50B7' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '334EB155-5559-451E-AA48-EBB686039F00') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('334EB155-5559-451E-AA48-EBB686039F00', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '81017A1D-D7F1-465A-8F71-C202FB9E50B7' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('334EB155-5559-451E-AA48-EBB686039F00', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('334EB155-5559-451E-AA48-EBB686039F00', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'A370E503-D47F-4479-8387-384C95C59458' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'F4494C65-A162-480E-802A-DF677D82C4F7') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('F4494C65-A162-480E-802A-DF677D82C4F7', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = 'A370E503-D47F-4479-8387-384C95C59458' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('F4494C65-A162-480E-802A-DF677D82C4F7', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('F4494C65-A162-480E-802A-DF677D82C4F7', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'B845D6C5-F078-4D34-BE15-D394D64B9011' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('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` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = 'B845D6C5-F078-4D34-BE15-D394D64B9011' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select 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` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('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` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '507AEDCA-4FA0-4B63-8AA4-BBCA422C05E3' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('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` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '507AEDCA-4FA0-4B63-8AA4-BBCA422C05E3' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select 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` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('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` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'E784A82A-4169-4DF0-ADAC-6AEBB435CBD2' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = 'E784A82A-4169-4DF0-ADAC-6AEBB435CBD2' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'A1F8181A-8E45-44C3-9F57-68BA9226C338' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('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` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = 'A1F8181A-8E45-44C3-9F57-68BA9226C338' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select 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` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('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` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'B845D6C5-F078-4D34-BE15-D394D64B9011' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('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` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = 'B845D6C5-F078-4D34-BE15-D394D64B9011' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select 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` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('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` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '507AEDCA-4FA0-4B63-8AA4-BBCA422C05E3' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('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` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '507AEDCA-4FA0-4B63-8AA4-BBCA422C05E3' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select 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` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('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` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '40FD3D7C-73DC-4197-9D07-CA2BDE437CDC' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('1481CF80-9553-4672-B659-22175F76D729', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', '1481CF80-9553-4672-B659-22175F76D729', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '40FD3D7C-73DC-4197-9D07-CA2BDE437CDC' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', '1481CF80-9553-4672-B659-22175F76D729', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', '1481CF80-9553-4672-B659-22175F76D729', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '718F31D7-A41D-4202-B4FB-133A89100329' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '718F31D7-A41D-4202-B4FB-133A89100329' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'D06245D5-8FAA-4F34-9B56-93DF46C8C302' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '8CF72D43-A9BD-4BF0-BCB6-7DB289481BA9', '903F14E1-03DD-48EA-8E69-B837D70C3C0F') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', '8CF72D43-A9BD-4BF0-BCB6-7DB289481BA9', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = 'D06245D5-8FAA-4F34-9B56-93DF46C8C302' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', '8CF72D43-A9BD-4BF0-BCB6-7DB289481BA9', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', '8CF72D43-A9BD-4BF0-BCB6-7DB289481BA9', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '6E941F21-EFA3-434C-BE65-7B3FCE835CC1' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('07753194-ABBB-4626-958A-EA91F81130DD', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('07753194-ABBB-4626-958A-EA91F81130DD', '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` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '6E941F21-EFA3-434C-BE65-7B3FCE835CC1' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('07753194-ABBB-4626-958A-EA91F81130DD', '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` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('07753194-ABBB-4626-958A-EA91F81130DD', '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` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '2A83C842-9278-44DB-92B2-E9ED8A752FDF' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('07753194-ABBB-4626-958A-EA91F81130DD', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('07753194-ABBB-4626-958A-EA91F81130DD', '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` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '2A83C842-9278-44DB-92B2-E9ED8A752FDF' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('07753194-ABBB-4626-958A-EA91F81130DD', '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` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('07753194-ABBB-4626-958A-EA91F81130DD', '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` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '7828112D-94AA-450E-BB8E-DCB4688CB564' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'ABF92798-CC3F-4210-89E5-1E089DF26108') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('ABF92798-CC3F-4210-89E5-1E089DF26108', '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` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '7828112D-94AA-450E-BB8E-DCB4688CB564' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('ABF92798-CC3F-4210-89E5-1E089DF26108', '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` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('ABF92798-CC3F-4210-89E5-1E089DF26108', '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` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'CA4DB0DE-794F-4B8C-86B4-B6268D2D9972' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'ABF92798-CC3F-4210-89E5-1E089DF26108') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('ABF92798-CC3F-4210-89E5-1E089DF26108', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = 'CA4DB0DE-794F-4B8C-86B4-B6268D2D9972' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('ABF92798-CC3F-4210-89E5-1E089DF26108', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('ABF92798-CC3F-4210-89E5-1E089DF26108', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `settings` where `key` = 'global_announcement' and `settings`.`deleted_at` is null and (`settings`.`lngId` is null or `settings`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `settings` where `key` = 'global_announcement_dealers' and `settings`.`deleted_at` is null and (`settings`.`lngId` is null or `settings`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
200
[]
[]
0 of 0array:15 [▼ "host" => array:1 [▶ 0 => "rrweb.webexpertsnepal.com" ] "connection" => array:1 [▶ 0 => "keep-alive" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "sec-ch-ua" => array:1 [▶ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] ]
0 of 0array:48 [▼ "REDIRECT_SCRIPT_URL" => "/en-au/products/roof-racks/canopy/toyota-genuine/vortex-rch-trackmount-black-2-bar-canopy-roof-rack_jc-00609" "REDIRECT_SCRIPT_URI" => "https://rrweb.webexpertsnepal.com/en-au/products/roof-racks/canopy/toyota-genuine/vortex-rch-trackmount-black-2-bar-canopy-roof-rack_jc-00609" "REDIRECT_HTTPS" => "on" "REDIRECT_SSL_TLS_SNI" => "rrweb.webexpertsnepal.com" "REDIRECT_STATUS" => "200" "SCRIPT_URL" => "/en-au/products/roof-racks/canopy/toyota-genuine/vortex-rch-trackmount-black-2-bar-canopy-roof-rack_jc-00609" "SCRIPT_URI" => "https://rrweb.webexpertsnepal.com/en-au/products/roof-racks/canopy/toyota-genuine/vortex-rch-trackmount-black-2-bar-canopy-roof-rack_jc-00609" "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" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" "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" => "48156" "REDIRECT_URL" => "/en-au/products/roof-racks/canopy/toyota-genuine/vortex-rch-trackmount-black-2-bar-canopy-roof-rack_jc-00609" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/en-au/products/roof-racks/canopy/toyota-genuine/vortex-rch-trackmount-black-2-bar-canopy-roof-rack_jc-00609" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1746906038.3531 "REQUEST_TIME" => 1746906038 ]
[]
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 => "Sat, 10 May 2025 19:40:39 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IktkTVZIZ3N1dG1lTm04M1NMaVVQSWc9PSIsInZhbHVlIjoiOUYydXE1Q1RvckpMRlltRkh0UjVma0FTWDVscnNBcjNDYWtBZ29FdEF2ei9rVkF1WUNObVZTTm4ycE5Fd0xPdXhHbXBlLzFYd3N5dXFCK3lidDRSYm9MQnVFN3hNSnpaZXRjMnMrNVBjdFdhdmd4aGJ4cFFqRzhvai83UmN2OWUiLCJtYWMiOiIwMTYxODExNzYwOThiNGNmZTI5YmM0ZWEwYTVlNDgwNDgzZTYyNDg1ZTE0ODY4YWYxZTM1ZjgxZjY4MGNhMWIzIiwidGFnIjoiIn0%3D; expires=Tue, 10 Jun 2025 05:40:39 GMT; Max-Age=2628000; path=/ ◀XSRF-TOKEN=eyJpdiI6IktkTVZIZ3N1dG1lTm04M1NMaVVQSWc9PSIsInZhbHVlIjoiOUYydXE1Q1RvckpMRlltRkh0UjVma0FTWDVscnNBcjNDYWtBZ29FdEF2ei9rVkF1WUNObVZTTm4ycE5Fd0xPdXhHbXBlL ▶" 1 => "rhino_rack_session=eyJpdiI6ImdWRnVrRHNLbXpkZWdDSGVqbmpDbWc9PSIsInZhbHVlIjoiUG91b204M3hXYjYxMm5CckRUajBoYStSOUpVb3dPUno1SWwxejR0ZjZPdi9jZDB2ODdQa0pXdEJEY2hoTTdzaVAwc3VxY25lWGt0T2pnWE1WUW85L2k4SFlQREV0eUxjcHhvRnFXRTRteDM4N2RDUWI4a0V6RHJ0TktmcCsxVG4iLCJtYWMiOiI0MDM5MGVmZDViMGU2YjRlMWNkMzU0MjE3ZDZjYjgyNmY2Mzc4YjU0OWU4NTNkNzRlN2ZmZjY1YjY2MTJjZGM0IiwidGFnIjoiIn0%3D; expires=Tue, 10 Jun 2025 05:40:39 GMT; Max-Age=2628000; path=/; httponly ◀rhino_rack_session=eyJpdiI6ImdWRnVrRHNLbXpkZWdDSGVqbmpDbWc9PSIsInZhbHVlIjoiUG91b204M3hXYjYxMm5CckRUajBoYStSOUpVb3dPUno1SWwxejR0ZjZPdi9jZDB2ODdQa0pXdEJEY2hoTTdza ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IktkTVZIZ3N1dG1lTm04M1NMaVVQSWc9PSIsInZhbHVlIjoiOUYydXE1Q1RvckpMRlltRkh0UjVma0FTWDVscnNBcjNDYWtBZ29FdEF2ei9rVkF1WUNObVZTTm4ycE5Fd0xPdXhHbXBlLzFYd3N5dXFCK3lidDRSYm9MQnVFN3hNSnpaZXRjMnMrNVBjdFdhdmd4aGJ4cFFqRzhvai83UmN2OWUiLCJtYWMiOiIwMTYxODExNzYwOThiNGNmZTI5YmM0ZWEwYTVlNDgwNDgzZTYyNDg1ZTE0ODY4YWYxZTM1ZjgxZjY4MGNhMWIzIiwidGFnIjoiIn0%3D; expires=Tue, 10-Jun-2025 05:40:39 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IktkTVZIZ3N1dG1lTm04M1NMaVVQSWc9PSIsInZhbHVlIjoiOUYydXE1Q1RvckpMRlltRkh0UjVma0FTWDVscnNBcjNDYWtBZ29FdEF2ei9rVkF1WUNObVZTTm4ycE5Fd0xPdXhHbXBlL ▶" 1 => "rhino_rack_session=eyJpdiI6ImdWRnVrRHNLbXpkZWdDSGVqbmpDbWc9PSIsInZhbHVlIjoiUG91b204M3hXYjYxMm5CckRUajBoYStSOUpVb3dPUno1SWwxejR0ZjZPdi9jZDB2ODdQa0pXdEJEY2hoTTdzaVAwc3VxY25lWGt0T2pnWE1WUW85L2k4SFlQREV0eUxjcHhvRnFXRTRteDM4N2RDUWI4a0V6RHJ0TktmcCsxVG4iLCJtYWMiOiI0MDM5MGVmZDViMGU2YjRlMWNkMzU0MjE3ZDZjYjgyNmY2Mzc4YjU0OWU4NTNkNzRlN2ZmZjY1YjY2MTJjZGM0IiwidGFnIjoiIn0%3D; expires=Tue, 10-Jun-2025 05:40:39 GMT; path=/; httponly ◀rhino_rack_session=eyJpdiI6ImdWRnVrRHNLbXpkZWdDSGVqbmpDbWc9PSIsInZhbHVlIjoiUG91b204M3hXYjYxMm5CckRUajBoYStSOUpVb3dPUno1SWwxejR0ZjZPdi9jZDB2ODdQa0pXdEJEY2hoTTdza ▶" ] ]
0 of 0array:9 [▼ "_token" => "ffblABcyV1WUXa9GZ8SrrL6dIlkqBrnRUBj7oyWS" "country" => "au" "_flash" => array:2 [▶ "old" => [] "new" => [] ] "lngId" => 7 "session_culture" => "en-au" "random_number" => 64 "locale" => "en" "_previous" => array:1 [▶ "url" => "https://rrweb.webexpertsnepal.com/en-au/products/roof-racks/canopy/toyota-genuine/vortex-rch-trackmount-black-2-bar-canopy-roof-rack_jc-00609" ] "PHPDEBUGBAR_STACK_DATA" => [] ]