
Utilising a simple and effective leg clamp attachment the ROC25 roof system is easy to install and remove. The ROC25 Flush roof rack system is specifically molded to fit the contours of your vehicle's roof. Sleek and stylish bars which are cut to a length that matches your vehicle's roof means no overhang and a neat fit. Another great feature is the long-lasting santoprene rubber padding which won't rub off on your vehicle and the lockable legs for added security.
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 contractor - the ROC25 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.
ACURA MDX 4dr SUV 01 to 06
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 contractor - the ROC25 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.
ACURA MDX 4dr SUV 01 to 06
NEXT
1 x Application (97.43%) | 536.27ms |
1 x Booting (2.56%) | 14.11ms |
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 |
|
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 |
|
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 `slug` = 'roof-rack-extras' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `parentId` = '3A0BDA4C-DFC8-4C88-AF5E-A1E56D78ECB7' and `slug` = 'roof-rack-parts' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `parentId` = '1F1129D9-79D8-4138-A3E2-926E9090C4FE' and `slug` = 'complete-roof-racks' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `stockCode` like 'rv0037b' and (title like 'vortex%roc25%flush%black%2%bar%roof%rack' or title_US_CA like 'vortex%roc25%flush%black%2%bar%roof%rack') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Medias` where `mediaUrl` is not null and `mediaUrl` <> '' and `contentType` = 1 and (`vehicleId` is null or exists (select * from `PR_Products` where `PR_Medias`.`productId` = `PR_Products`.`productId` and (select count(*) from `PR_VehicleProducts` where `PR_Products`.`productId` = `PR_VehicleProducts`.`productId` and `PR_VehicleProducts`.`deleted_at` is null and (`PR_VehicleProducts`.`lngId` is null or `PR_VehicleProducts`.`lngId` = '5') order by `lngId` desc) = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc)) and `PR_Medias`.`productId` in ('BFF76ADF-5FA3-475E-8611-50130F4561F1') and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '5') and `isActive` = 1 order by `vehicleId` desc, `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Medias` where `embedCode` is not null and `embedCode` <> '' and `PR_Medias`.`productId` in ('BFF76ADF-5FA3-475E-8611-50130F4561F1') and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '5') 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 ('BFF76ADF-5FA3-475E-8611-50130F4561F1') and `PR_Links`.`deleted_at` is null and (`PR_Links`.`lngId` is null or `PR_Links`.`lngId` = '5') 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') and `PR_LinkNames`.`deleted_at` is null and (`PR_LinkNames`.`lngId` is null or `PR_LinkNames`.`lngId` = 5) order by `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` = 5) and `isActive` = 1 order by `lngId` desc) and `PR_ProductCompatibilities`.`productId1` in ('BFF76ADF-5FA3-475E-8611-50130F4561F1') and `PR_ProductCompatibilities`.`deleted_at` is null and (`PR_ProductCompatibilities`.`lngId` is null or `PR_ProductCompatibilities`.`lngId` = '5') 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` = 5) and `isActive` = 1 order by `lngId` desc) and `PR_ProductSpareParts`.`productId1` in ('BFF76ADF-5FA3-475E-8611-50130F4561F1') 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` = 5) and `isActive` = 1 order by `lngId` desc) and `PR_WindFairings`.`productId1` in ('BFF76ADF-5FA3-475E-8611-50130F4561F1') and `lngId` = 5 and `PR_WindFairings`.`deleted_at` is null order by `id` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductSpecifications` where `PR_ProductSpecifications`.`productId` in ('BFF76ADF-5FA3-475E-8611-50130F4561F1') 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', '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') and `PR_Specifications`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductSpecificationProperties` where `PR_ProductSpecificationProperties`.`productId` in ('BFF76ADF-5FA3-475E-8611-50130F4561F1') 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` = 5) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`productId` in ('BFF76ADF-5FA3-475E-8611-50130F4561F1') and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `CM_CanopyProducts` where `CM_CanopyProducts`.`productId` in ('BFF76ADF-5FA3-475E-8611-50130F4561F1') and `CM_CanopyProducts`.`deleted_at` is null and (`CM_CanopyProducts`.`lngId` is null or `CM_CanopyProducts`.`lngId` = '5') 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 ('BFF76ADF-5FA3-475E-8611-50130F4561F1') and PR_BarTypes.lngId=5 and `PR_BarTypeProductCompatibilities`.`deleted_at` is null order by `PR_BarTypes`.`order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_BarTypes` where `PR_BarTypes`.`barTypeId` in ('B07CD0CA-94E0-4DF5-BB74-38F1371DE605') and `PR_BarTypes`.`deleted_at` is null and (`PR_BarTypes`.`lngId` is null or `PR_BarTypes`.`lngId` = 5) order by `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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `productId2`, `order`, `lngId` from `PR_RelatedProducts` where `productId1` = 'BFF76ADF-5FA3-475E-8611-50130F4561F1' and `PR_RelatedProducts`.`deleted_at` is null and (`PR_RelatedProducts`.`lngId` is null or `PR_RelatedProducts`.`lngId` = '5') order by `order` asc, `id` desc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `productId2`, `order`, `lngId` from `PR_RelatedProducts` where 0 = 1 and `PR_RelatedProducts`.`deleted_at` is null and (`PR_RelatedProducts`.`lngId` is null or `PR_RelatedProducts`.`lngId` = '5') order by `order` asc, `id` desc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `productId` in ('4A128EC9-5B91-4DBA-AA56-6252C2CDA2E0', 'A80B6709-D371-4C88-805E-A54FA99C9A89', '33E49DB8-70C6-4B85-9149-36226B21FF0C', 'F1B7BB11-ACA1-4272-A54E-7268B0C87617', 'E5AE30A5-62E9-474D-BF9E-64EE6723DA53', '7C9F1875-1602-4BD2-A761-CD4B7C1A92CF', 'EE369577-4815-45D5-A6AA-A83BC2598FCD', '8D6433AC-58C9-4185-80B9-87816B02B1D5', '5E1E1476-3A49-4382-B513-48F318F3CB7D', 'C26D80DE-73DD-4440-ADC9-8B9ECC72F5B7') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Medias` where `mediaUrl` is not null and `mediaUrl` <> '' and `contentType` = 1 and (`vehicleId` is null or exists (select * from `PR_Products` where `PR_Medias`.`productId` = `PR_Products`.`productId` and (select count(*) from `PR_VehicleProducts` where `PR_Products`.`productId` = `PR_VehicleProducts`.`productId` and `PR_VehicleProducts`.`deleted_at` is null and (`PR_VehicleProducts`.`lngId` is null or `PR_VehicleProducts`.`lngId` = '5') order by `lngId` desc) = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc)) and `PR_Medias`.`productId` in ('33E49DB8-70C6-4B85-9149-36226B21FF0C', '4A128EC9-5B91-4DBA-AA56-6252C2CDA2E0', '5E1E1476-3A49-4382-B513-48F318F3CB7D', '7C9F1875-1602-4BD2-A761-CD4B7C1A92CF', '8D6433AC-58C9-4185-80B9-87816B02B1D5', 'A80B6709-D371-4C88-805E-A54FA99C9A89', 'C26D80DE-73DD-4440-ADC9-8B9ECC72F5B7', 'E5AE30A5-62E9-474D-BF9E-64EE6723DA53', 'EE369577-4815-45D5-A6AA-A83BC2598FCD', 'F1B7BB11-ACA1-4272-A54E-7268B0C87617') and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '5') and `isActive` = 1 order by `vehicleId` desc, `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductSpecificationProperties` where `PR_ProductSpecificationProperties`.`productId` = 'BFF76ADF-5FA3-475E-8611-50130F4561F1' 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', '6B65CCB5-C611-4252-AC40-B081C6520F2E', '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') 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', '145F0358-820E-4757-BC2C-B69CC2B2204A', '3492BB0B-E151-4006-B785-A2E65269871B', '66E7F1BA-B555-492C-9374-8F26C71C15F1', '6C9D3CFB-941F-4A87-8D5E-75DD2A98D884', '706802A1-C753-4C62-AFE7-AC2A34C21017', '97623ACD-37D7-43A6-88A9-F7EB6B05B75D', 'A1683C3B-FBB8-45FF-8258-BF0444E0762D') 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', '145F0358-820E-4757-BC2C-B69CC2B2204A', '3492BB0B-E151-4006-B785-A2E65269871B', '66E7F1BA-B555-492C-9374-8F26C71C15F1', '6C9D3CFB-941F-4A87-8D5E-75DD2A98D884', '706802A1-C753-4C62-AFE7-AC2A34C21017', '97623ACD-37D7-43A6-88A9-F7EB6B05B75D', 'A1683C3B-FBB8-45FF-8258-BF0444E0762D') and `PR_SpecificationPropertyMasterData_Features`.`deleted_at` is null and (`PR_SpecificationPropertyMasterData_Features`.`lngId` is null or `PR_SpecificationPropertyMasterData_Features`.`lngId` = 5) order by `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'BFF76ADF-5FA3-475E-8611-50130F4561F1' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '3B393703-FAA0-4701-A5B4-DFA329A3DC9B', '9EAD993D-3F7F-434C-914C-C1AB0B64EC6C') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `specificationId` from `PR_CategorySpecifications` where `categoryId` in ('9EAD993D-3F7F-434C-914C-C1AB0B64EC6C', '3B393703-FAA0-4701-A5B4-DFA329A3DC9B', '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', '7A90BAEF-94DE-4E35-9446-A53AE478B8C7', '65EBFA01-7744-4861-803E-BA026DFC9BA0', '6284DBED-EF43-4436-A768-B530DA94D027', '1298F3AA-BDBF-44E3-BC7B-9A4A42E539AF', '6FEC7B95-51EA-498A-A900-8FD5DA6C89D2', '2261BB38-5354-44FE-B45C-849D201849B0', '2A37E3E3-CB54-453A-9EE9-53B3406A76CB', '14F3FB81-8947-4E5E-BB23-2F17B1452EF2', 'AEF3ACA8-93E7-4674-B28B-1AECF6611583', '7A90BAEF-94DE-4E35-9446-A53AE478B8C7', '65EBFA01-7744-4861-803E-BA026DFC9BA0', '6284DBED-EF43-4436-A768-B530DA94D027', '1298F3AA-BDBF-44E3-BC7B-9A4A42E539AF', '6FEC7B95-51EA-498A-A900-8FD5DA6C89D2', '2261BB38-5354-44FE-B45C-849D201849B0', '2A37E3E3-CB54-453A-9EE9-53B3406A76CB', '14F3FB81-8947-4E5E-BB23-2F17B1452EF2') and `PR_Specifications`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCustomSpecification` where `PR_ProductCustomSpecification`.`ProductId` = 'BFF76ADF-5FA3-475E-8611-50130F4561F1' 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_VehicleProducts` where `PR_VehicleProducts`.`productId` = 'BFF76ADF-5FA3-475E-8611-50130F4561F1' 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` = '5') and `isActive` = 1 order by `lngId` desc) and `VM_Vehicles`.`deleted_at` is null and (`VM_Vehicles`.`lngId` is null or `VM_Vehicles`.`lngId` = '5') and `isActive` = 1 order by `lngId` desc) and `PR_VehicleProducts`.`deleted_at` is null and (`PR_VehicleProducts`.`lngId` is null or `PR_VehicleProducts`.`lngId` = '5') order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `VM_Vehicles` where `VM_Vehicles`.`vehicleId` in ('61FA77C9-6C7D-4A2D-B1E7-C4F4C754DF1B') and `VM_Vehicles`.`deleted_at` is null and (`VM_Vehicles`.`lngId` is null or `VM_Vehicles`.`lngId` = '5') and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'BFF76ADF-5FA3-475E-8611-50130F4561F1' 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_CategoryProductImages` where `categoryId` in ('9EAD993D-3F7F-434C-914C-C1AB0B64EC6C', '3B393703-FAA0-4701-A5B4-DFA329A3DC9B', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `lngId` = 5 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 ('9EAD993D-3F7F-434C-914C-C1AB0B64EC6C', '3B393703-FAA0-4701-A5B4-DFA329A3DC9B', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `lngId` = 5 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', '1F1129D9-79D8-4138-A3E2-926E9090C4FE') and `lngId` = 5 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', '1F1129D9-79D8-4138-A3E2-926E9090C4FE') and `lngId` = 5 and `deleted_at` is null
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_CategoryProductImages` where `categoryId` in ('5C2DD4F5-056B-4961-B309-A37BA1BC5A4E', '3A0BDA4C-DFC8-4C88-AF5E-A1E56D78ECB7', 'F1D7419B-13D1-4D95-8AF7-0D95AED30BF2') and `lngId` = 5 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` = 'BFF76ADF-5FA3-475E-8611-50130F4561F1' 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` = 'BFF76ADF-5FA3-475E-8611-50130F4561F1' 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` = 5) and `isActive` = 1 order by `lngId` desc) and `PR_ZwiflocRetrofit`.`deleted_at` is null and (`PR_ZwiflocRetrofit`.`lngId` is null or `PR_ZwiflocRetrofit`.`lngId` = 5) order by `id` asc, `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `key`, `value` from `settings` where `key` = 'shipping_policy' and `settings`.`deleted_at` is null and (`settings`.`lngId` is null or `settings`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `settings` where `key` = 'enable_locally' and `settings`.`deleted_at` is null and (`settings`.`lngId` is null or `settings`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `parentId` is null and `slug` = 'roof-rack-extras' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `parentId` = '3A0BDA4C-DFC8-4C88-AF5E-A1E56D78ECB7' and `slug` = 'roof-rack-parts' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `parentId` = '1F1129D9-79D8-4138-A3E2-926E9090C4FE' and `slug` = 'complete-roof-racks' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `stockCode` like 'rv0037b' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Medias` where `mediaUrl` is not null and `mediaUrl` <> '' and `contentType` = 1 and (`vehicleId` is null or exists (select * from `PR_Products` where `PR_Medias`.`productId` = `PR_Products`.`productId` and (select count(*) from `PR_VehicleProducts` where `PR_Products`.`productId` = `PR_VehicleProducts`.`productId` and `PR_VehicleProducts`.`deleted_at` is null and (`PR_VehicleProducts`.`lngId` is null or `PR_VehicleProducts`.`lngId` = '5') order by `lngId` desc) = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc)) and `PR_Medias`.`productId` in ('BFF76ADF-5FA3-475E-8611-50130F4561F1') and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '5') and `isActive` = 1 order by `vehicleId` desc, `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Medias` where `embedCode` is not null and `embedCode` <> '' and `PR_Medias`.`productId` in ('BFF76ADF-5FA3-475E-8611-50130F4561F1') and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '5') 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 ('BFF76ADF-5FA3-475E-8611-50130F4561F1') and `PR_Links`.`deleted_at` is null and (`PR_Links`.`lngId` is null or `PR_Links`.`lngId` = '5') 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') and `PR_LinkNames`.`deleted_at` is null and (`PR_LinkNames`.`lngId` is null or `PR_LinkNames`.`lngId` = 5) order by `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` = 5) and `isActive` = 1 order by `lngId` desc) and `PR_ProductCompatibilities`.`productId1` in ('BFF76ADF-5FA3-475E-8611-50130F4561F1') and `PR_ProductCompatibilities`.`deleted_at` is null and (`PR_ProductCompatibilities`.`lngId` is null or `PR_ProductCompatibilities`.`lngId` = '5') 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` = 5) and `isActive` = 1 order by `lngId` desc) and `PR_ProductSpareParts`.`productId1` in ('BFF76ADF-5FA3-475E-8611-50130F4561F1') 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` = 5) and `isActive` = 1 order by `lngId` desc) and `PR_WindFairings`.`productId1` in ('BFF76ADF-5FA3-475E-8611-50130F4561F1') and `lngId` = 5 and `PR_WindFairings`.`deleted_at` is null order by `id` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductSpecifications` where `PR_ProductSpecifications`.`productId` in ('BFF76ADF-5FA3-475E-8611-50130F4561F1') 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', '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') and `PR_Specifications`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductSpecificationProperties` where `PR_ProductSpecificationProperties`.`productId` in ('BFF76ADF-5FA3-475E-8611-50130F4561F1') 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` = 5) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`productId` in ('BFF76ADF-5FA3-475E-8611-50130F4561F1') and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `CM_CanopyProducts` where `CM_CanopyProducts`.`productId` in ('BFF76ADF-5FA3-475E-8611-50130F4561F1') and `CM_CanopyProducts`.`deleted_at` is null and (`CM_CanopyProducts`.`lngId` is null or `CM_CanopyProducts`.`lngId` = '5') 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 ('BFF76ADF-5FA3-475E-8611-50130F4561F1') and PR_BarTypes.lngId=5 and `PR_BarTypeProductCompatibilities`.`deleted_at` is null order by `PR_BarTypes`.`order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_BarTypes` where `PR_BarTypes`.`barTypeId` in ('B07CD0CA-94E0-4DF5-BB74-38F1371DE605') and `PR_BarTypes`.`deleted_at` is null and (`PR_BarTypes`.`lngId` is null or `PR_BarTypes`.`lngId` = 5) order by `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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'BFF76ADF-5FA3-475E-8611-50130F4561F1' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '3B393703-FAA0-4701-A5B4-DFA329A3DC9B', '9EAD993D-3F7F-434C-914C-C1AB0B64EC6C') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `specificationId` from `PR_CategorySpecifications` where `categoryId` in ('9EAD993D-3F7F-434C-914C-C1AB0B64EC6C', '3B393703-FAA0-4701-A5B4-DFA329A3DC9B', '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', '7A90BAEF-94DE-4E35-9446-A53AE478B8C7', '65EBFA01-7744-4861-803E-BA026DFC9BA0', '6284DBED-EF43-4436-A768-B530DA94D027', '1298F3AA-BDBF-44E3-BC7B-9A4A42E539AF', '6FEC7B95-51EA-498A-A900-8FD5DA6C89D2', '2261BB38-5354-44FE-B45C-849D201849B0', '2A37E3E3-CB54-453A-9EE9-53B3406A76CB', '14F3FB81-8947-4E5E-BB23-2F17B1452EF2', 'AEF3ACA8-93E7-4674-B28B-1AECF6611583', '7A90BAEF-94DE-4E35-9446-A53AE478B8C7', '65EBFA01-7744-4861-803E-BA026DFC9BA0', '6284DBED-EF43-4436-A768-B530DA94D027', '1298F3AA-BDBF-44E3-BC7B-9A4A42E539AF', '6FEC7B95-51EA-498A-A900-8FD5DA6C89D2', '2261BB38-5354-44FE-B45C-849D201849B0', '2A37E3E3-CB54-453A-9EE9-53B3406A76CB', '14F3FB81-8947-4E5E-BB23-2F17B1452EF2') and `PR_Specifications`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCustomSpecification` where `PR_ProductCustomSpecification`.`ProductId` = 'BFF76ADF-5FA3-475E-8611-50130F4561F1' 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_ProductCategories` where `productId` = 'BFF76ADF-5FA3-475E-8611-50130F4561F1' and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('9EAD993D-3F7F-434C-914C-C1AB0B64EC6C') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Medias` where `PR_Medias`.`productId` = 'BFF76ADF-5FA3-475E-8611-50130F4561F1' 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` = '5') order by `lngId` desc) = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc)) and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '5') and `isActive` = 1 order by `vehicleId` desc, `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Medias` where `PR_Medias`.`productId` = 'BFF76ADF-5FA3-475E-8611-50130F4561F1' 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` = '5') and `isActive` = 1 order by `vehicleId` asc, `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_VehicleProducts` where `PR_VehicleProducts`.`productId` = 'BFF76ADF-5FA3-475E-8611-50130F4561F1' 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` = '5') and `isActive` = 1 order by `lngId` desc) and `VM_Vehicles`.`deleted_at` is null and (`VM_Vehicles`.`lngId` is null or `VM_Vehicles`.`lngId` = '5') and `isActive` = 1 order by `lngId` desc) and `PR_VehicleProducts`.`deleted_at` is null and (`PR_VehicleProducts`.`lngId` is null or `PR_VehicleProducts`.`lngId` = '5') order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `VM_Vehicles` where `VM_Vehicles`.`vehicleId` in ('61FA77C9-6C7D-4A2D-B1E7-C4F4C754DF1B') and `VM_Vehicles`.`deleted_at` is null and (`VM_Vehicles`.`lngId` is null or `VM_Vehicles`.`lngId` = '5') and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `VM_Models` where `VM_Models`.`modelId` = '777076D3-3A08-4E6E-B2F6-D2960ADB2600' and exists (select * from `VM_Manufacturers` where `VM_Models`.`manufacturerId` = `VM_Manufacturers`.`manufacturerId` and `VM_Manufacturers`.`deleted_at` is null and (`VM_Manufacturers`.`lngId` is null or `VM_Manufacturers`.`lngId` = '5') and `isActive` = 1 order by `lngId` desc) and (`VM_Models`.`lngId` is null or `VM_Models`.`lngId` = '5') and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `VM_Manufacturers` where `VM_Manufacturers`.`manufacturerId` in ('9DE86C84-2864-4F84-9AF1-F5FD368BEF92') and `VM_Manufacturers`.`deleted_at` is null and (`VM_Manufacturers`.`lngId` is null or `VM_Manufacturers`.`lngId` = '5') and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `VM_BodyTypes` where `VM_BodyTypes`.`bodyTypeId` = 'E6EBBFB9-8EEF-4449-ADF8-BD1D6801C953' and `VM_BodyTypes`.`deleted_at` is null and (`VM_BodyTypes`.`lngId` is null or `VM_BodyTypes`.`lngId` = '5') and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('9EAD993D-3F7F-434C-914C-C1AB0B64EC6C', '3B393703-FAA0-4701-A5B4-DFA329A3DC9B', '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` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `categoryId` from `PR_Categories` where `categoryType` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `fmv_product_specifications` where `fmv_product_specifications`.`productId` = 'BFF76ADF-5FA3-475E-8611-50130F4561F1' 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` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `VM_Models` where `VM_Models`.`modelId` = '777076D3-3A08-4E6E-B2F6-D2960ADB2600' and exists (select * from `VM_Manufacturers` where `VM_Models`.`manufacturerId` = `VM_Manufacturers`.`manufacturerId` and `VM_Manufacturers`.`deleted_at` is null and (`VM_Manufacturers`.`lngId` is null or `VM_Manufacturers`.`lngId` = '5') and `isActive` = 1 order by `lngId` desc) and (`VM_Models`.`lngId` is null or `VM_Models`.`lngId` = '5') and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `VM_Manufacturers` where `VM_Manufacturers`.`manufacturerId` in ('9DE86C84-2864-4F84-9AF1-F5FD368BEF92') and `VM_Manufacturers`.`deleted_at` is null and (`VM_Manufacturers`.`lngId` is null or `VM_Manufacturers`.`lngId` = '5') and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '4A128EC9-5B91-4DBA-AA56-6252C2CDA2E0' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '92962506-9FF0-4A88-83C3-2883165466E1') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '92962506-9FF0-4A88-83C3-2883165466E1', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '4A128EC9-5B91-4DBA-AA56-6252C2CDA2E0' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '92962506-9FF0-4A88-83C3-2883165466E1', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'A80B6709-D371-4C88-805E-A54FA99C9A89' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('18FCA1F1-E71D-496E-9AAF-18DBA3549385', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'B8B347E3-63D0-406C-A666-E26FB2E4C35B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '18FCA1F1-E71D-496E-9AAF-18DBA3549385', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'B8B347E3-63D0-406C-A666-E26FB2E4C35B', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = 'A80B6709-D371-4C88-805E-A54FA99C9A89' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '18FCA1F1-E71D-496E-9AAF-18DBA3549385', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'B8B347E3-63D0-406C-A666-E26FB2E4C35B', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '33E49DB8-70C6-4B85-9149-36226B21FF0C' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'A17D765A-858D-44A2-98B7-D2D4FCE06356') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('A17D765A-858D-44A2-98B7-D2D4FCE06356', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '33E49DB8-70C6-4B85-9149-36226B21FF0C' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('A17D765A-858D-44A2-98B7-D2D4FCE06356', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'F1B7BB11-ACA1-4272-A54E-7268B0C87617' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'D2463931-314A-492F-B7D7-C5FC39E5FCC9') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'D2463931-314A-492F-B7D7-C5FC39E5FCC9', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = 'F1B7BB11-ACA1-4272-A54E-7268B0C87617' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'D2463931-314A-492F-B7D7-C5FC39E5FCC9', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'E5AE30A5-62E9-474D-BF9E-64EE6723DA53' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '41C0E016-D44F-414F-8DCD-07CBA1565B47', '903F14E1-03DD-48EA-8E69-B837D70C3C0F') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', '41C0E016-D44F-414F-8DCD-07CBA1565B47', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = 'E5AE30A5-62E9-474D-BF9E-64EE6723DA53' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', '41C0E016-D44F-414F-8DCD-07CBA1565B47', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '7C9F1875-1602-4BD2-A761-CD4B7C1A92CF' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'A17D765A-858D-44A2-98B7-D2D4FCE06356') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'A17D765A-858D-44A2-98B7-D2D4FCE06356', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '7C9F1875-1602-4BD2-A761-CD4B7C1A92CF' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'A17D765A-858D-44A2-98B7-D2D4FCE06356', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'EE369577-4815-45D5-A6AA-A83BC2598FCD' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'D2463931-314A-492F-B7D7-C5FC39E5FCC9') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('D2463931-314A-492F-B7D7-C5FC39E5FCC9', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = 'EE369577-4815-45D5-A6AA-A83BC2598FCD' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('D2463931-314A-492F-B7D7-C5FC39E5FCC9', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '8D6433AC-58C9-4185-80B9-87816B02B1D5' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'A17D765A-858D-44A2-98B7-D2D4FCE06356') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('A17D765A-858D-44A2-98B7-D2D4FCE06356', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '8D6433AC-58C9-4185-80B9-87816B02B1D5' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('A17D765A-858D-44A2-98B7-D2D4FCE06356', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '5E1E1476-3A49-4382-B513-48F318F3CB7D' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '92962506-9FF0-4A88-83C3-2883165466E1') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('92962506-9FF0-4A88-83C3-2883165466E1', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '5E1E1476-3A49-4382-B513-48F318F3CB7D' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('92962506-9FF0-4A88-83C3-2883165466E1', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'C26D80DE-73DD-4440-ADC9-8B9ECC72F5B7' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '41C0E016-D44F-414F-8DCD-07CBA1565B47', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'E10C09F3-8A29-4DDE-AF71-067C4D90F3D5') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'E10C09F3-8A29-4DDE-AF71-067C4D90F3D5', '41C0E016-D44F-414F-8DCD-07CBA1565B47', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = 'C26D80DE-73DD-4440-ADC9-8B9ECC72F5B7' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'E10C09F3-8A29-4DDE-AF71-067C4D90F3D5', '41C0E016-D44F-414F-8DCD-07CBA1565B47', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 5) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 5) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
200
[]
[]
0 of 0array:15 [▼ "host" => array:1 [▶ 0 => "rrweb.webexpertsnepal.com" ] "connection" => array:1 [▶ 0 => "keep-alive" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "sec-ch-ua" => array:1 [▶ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] ]
0 of 0array:48 [▼ "REDIRECT_SCRIPT_URL" => "/en-ca/products/roof-rack-extras/roof-rack-parts/complete-roof-racks/vortex-roc25-flush-black-2-bar-roof-rack_rv0037b" "REDIRECT_SCRIPT_URI" => "https://rrweb.webexpertsnepal.com/en-ca/products/roof-rack-extras/roof-rack-parts/complete-roof-racks/vortex-roc25-flush-black-2-bar-roof-rack_rv0037b" "REDIRECT_HTTPS" => "on" "REDIRECT_SSL_TLS_SNI" => "rrweb.webexpertsnepal.com" "REDIRECT_STATUS" => "200" "SCRIPT_URL" => "/en-ca/products/roof-rack-extras/roof-rack-parts/complete-roof-racks/vortex-roc25-flush-black-2-bar-roof-rack_rv0037b" "SCRIPT_URI" => "https://rrweb.webexpertsnepal.com/en-ca/products/roof-rack-extras/roof-rack-parts/complete-roof-racks/vortex-roc25-flush-black-2-bar-roof-rack_rv0037b" "HTTPS" => "on" "SSL_TLS_SNI" => "rrweb.webexpertsnepal.com" "HTTP_HOST" => "rrweb.webexpertsnepal.com" "HTTP_CONNECTION" => "keep-alive" "HTTP_PRAGMA" => "no-cache" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin" "SERVER_SIGNATURE" => "<address>Apache/2.4.52 (Ubuntu) Server at rrweb.webexpertsnepal.com Port 443</address>\n" "SERVER_SOFTWARE" => "Apache/2.4.52 (Ubuntu)" "SERVER_NAME" => "rrweb.webexpertsnepal.com" "SERVER_ADDR" => "192.168.2.5" "SERVER_PORT" => "443" "REMOTE_ADDR" => "192.168.2.1" "DOCUMENT_ROOT" => "/var/www/rhinorack/web/public" "REQUEST_SCHEME" => "https" "CONTEXT_PREFIX" => "" "CONTEXT_DOCUMENT_ROOT" => "/var/www/rhinorack/web/public" "SERVER_ADMIN" => "webmaster@" "SCRIPT_FILENAME" => "/var/www/rhinorack/web/public/index.php" "REMOTE_PORT" => "28813" "REDIRECT_URL" => "/en-ca/products/roof-rack-extras/roof-rack-parts/complete-roof-racks/vortex-roc25-flush-black-2-bar-roof-rack_rv0037b" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/en-ca/products/roof-rack-extras/roof-rack-parts/complete-roof-racks/vortex-roc25-flush-black-2-bar-roof-rack_rv0037b" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1740507450.7626 "REQUEST_TIME" => 1740507450 ]
[]
0 of 0array:5 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Tue, 25 Feb 2025 18:17:30 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Img1T0lJZTNoWHQrbU5xUGR2MVBPcUE9PSIsInZhbHVlIjoiUmQvUkNOTm8zOXBIQzJocmd2bC91MUgzR09lVmZaTk5YSjhDTHIvc01qNTB4QTRZZ01iUDZMVXB3bEVTeGlnZGR0VjBtZ0xjdGlrd1ZCRm5ncXRFMWJpRUVwQjRHQS9PTGtKQXU1ckF0TTRKcC9nNHVKTkFjSnBDMFZFWXA3VG8iLCJtYWMiOiI0MzgzMGYzZDQ4ZTAwZDA2MTU5MjVjZGVkZjM5NmQyZDYxMjEyNGEzMTYyY2E3ZDI2NzZlYjY2NWEzZjgyNDQzIiwidGFnIjoiIn0%3D; expires=Fri, 28 Mar 2025 04:17:31 GMT; Max-Age=2628000; path=/ ◀XSRF-TOKEN=eyJpdiI6Img1T0lJZTNoWHQrbU5xUGR2MVBPcUE9PSIsInZhbHVlIjoiUmQvUkNOTm8zOXBIQzJocmd2bC91MUgzR09lVmZaTk5YSjhDTHIvc01qNTB4QTRZZ01iUDZMVXB3bEVTeGlnZGR0VjBtZ ▶" 1 => "rhino_rack_session=eyJpdiI6Ik1sSklRVVU2WTVWbFFyMEZLY1h0cWc9PSIsInZhbHVlIjoiY0NJR1k4Mm4wV2tTOXRReElyMEEyUjAwOUhRanp3T0ZhbjhwY0tSRUlrbnBPMndJN3ZzakZ4a1N2d3dHWnlPYXJmQWRYSjh5MmREb3ZpRVphYW1mR0J4QU1aQlNCN2dHVXBiVk5SVnNtQTh2dW95NTBrV1dEYkJlWk8zL1h0dGsiLCJtYWMiOiIxOTE0NDgxYWY4YjlhNTRlZjk3MTZjOTc4ZWVlZDM4MDRmM2VmZDEzMTljN2ZhZDUxN2NkOTVlMmRhYjhlYjU3IiwidGFnIjoiIn0%3D; expires=Fri, 28 Mar 2025 04:17:31 GMT; Max-Age=2628000; path=/; httponly ◀rhino_rack_session=eyJpdiI6Ik1sSklRVVU2WTVWbFFyMEZLY1h0cWc9PSIsInZhbHVlIjoiY0NJR1k4Mm4wV2tTOXRReElyMEEyUjAwOUhRanp3T0ZhbjhwY0tSRUlrbnBPMndJN3ZzakZ4a1N2d3dHWnlPY ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Img1T0lJZTNoWHQrbU5xUGR2MVBPcUE9PSIsInZhbHVlIjoiUmQvUkNOTm8zOXBIQzJocmd2bC91MUgzR09lVmZaTk5YSjhDTHIvc01qNTB4QTRZZ01iUDZMVXB3bEVTeGlnZGR0VjBtZ0xjdGlrd1ZCRm5ncXRFMWJpRUVwQjRHQS9PTGtKQXU1ckF0TTRKcC9nNHVKTkFjSnBDMFZFWXA3VG8iLCJtYWMiOiI0MzgzMGYzZDQ4ZTAwZDA2MTU5MjVjZGVkZjM5NmQyZDYxMjEyNGEzMTYyY2E3ZDI2NzZlYjY2NWEzZjgyNDQzIiwidGFnIjoiIn0%3D; expires=Fri, 28-Mar-2025 04:17:31 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Img1T0lJZTNoWHQrbU5xUGR2MVBPcUE9PSIsInZhbHVlIjoiUmQvUkNOTm8zOXBIQzJocmd2bC91MUgzR09lVmZaTk5YSjhDTHIvc01qNTB4QTRZZ01iUDZMVXB3bEVTeGlnZGR0VjBtZ ▶" 1 => "rhino_rack_session=eyJpdiI6Ik1sSklRVVU2WTVWbFFyMEZLY1h0cWc9PSIsInZhbHVlIjoiY0NJR1k4Mm4wV2tTOXRReElyMEEyUjAwOUhRanp3T0ZhbjhwY0tSRUlrbnBPMndJN3ZzakZ4a1N2d3dHWnlPYXJmQWRYSjh5MmREb3ZpRVphYW1mR0J4QU1aQlNCN2dHVXBiVk5SVnNtQTh2dW95NTBrV1dEYkJlWk8zL1h0dGsiLCJtYWMiOiIxOTE0NDgxYWY4YjlhNTRlZjk3MTZjOTc4ZWVlZDM4MDRmM2VmZDEzMTljN2ZhZDUxN2NkOTVlMmRhYjhlYjU3IiwidGFnIjoiIn0%3D; expires=Fri, 28-Mar-2025 04:17:31 GMT; path=/; httponly ◀rhino_rack_session=eyJpdiI6Ik1sSklRVVU2WTVWbFFyMEZLY1h0cWc9PSIsInZhbHVlIjoiY0NJR1k4Mm4wV2tTOXRReElyMEEyUjAwOUhRanp3T0ZhbjhwY0tSRUlrbnBPMndJN3ZzakZ4a1N2d3dHWnlPY ▶" ] ]
0 of 0array:9 [▼ "_token" => "sxfGqSy3HvnnaZw2vEOF8wdlOInEzPe6lvq2JNWw" "country" => "ca" "_flash" => array:2 [▶ "old" => [] "new" => [] ] "lngId" => 5 "session_culture" => "en-ca" "random_number" => 88 "locale" => "en" "_previous" => array:1 [▶ "url" => "https://rrweb.webexpertsnepal.com/en-ca/products/roof-rack-extras/roof-rack-parts/complete-roof-racks/vortex-roc25-flush-black-2-bar-roof-rack_rv0037b" ] "PHPDEBUGBAR_STACK_DATA" => [] ]