
This system fits vehicles with deck/utility rails installed
Introducing the new Reconn-Deck™, our versatile truck bed system. Carefully crafted with a sleek and rugged design that looks stylish on even the toughest trucks. Whether you're heading out on overlanding adventures, taking the family camping, or tackling your next job, the many options to customize the Reconn-Deck means means it's suited to a range of uses. The system doubles your storage space and still gives you access to the truck bed for bulkier items. The system is also designed to minimize the vehicle height, protecting pop-up tents from the wind and ensuring easy access to parking lot and campsites.
Your LAND ROVER DEFENDER L663 110 RCL4 + RDB126 X2 + RCP73 X2 solution is made up of the following individual parts:
Reconn-Deck™ Bars have been constructed from powder coated aluminum providing the ultimate in corrosion resistance. The bars have integrated channels on all 4 sides for mounting of accessories.
There are countless ways to customize, accessorize and extend your set-up, giving you all the carry space you need for overlanding adventures.
Features:
LAND ROVER Defender 110 L663 5dr SUV With Factory Track 20 On
NEXT
Reconn-Deck™ Bars have been constructed from powder coated aluminum providing the ultimate in corrosion resistance. The bars have integrated channels on all 4 sides for mounting of accessories.
There are countless ways to customize, accessorize and extend your set-up, giving you all the carry space you need for overlanding adventures.
Features:
LAND ROVER Defender 110 L663 5dr SUV With Factory Track 20 On
NEXT
Your LAND ROVER DEFENDER L663 110 RCL4 + RDB126 X2 + RCP73 X2 solution can be equipped with these
1 x Application (99.52%) | 1.36s |
1 x Booting (0.48%) | 6.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 |
|
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 `Country` where `id` in ('2', '3', '4', '5', '1') and `Country`.`deleted_at` is null order by `title` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `Language` where `Language`.`countryid` in (1, 2, 3, 4, 5) and `Language`.`deleted_at` is null and `isActive` = 1 order by `title` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `Language` where `culture` = 'en-au' and `Language`.`deleted_at` is null and `isActive` = 1 limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `menus` where `position` = 1 and `parent_id` is null and `menus`.`deleted_at` is null and (`menus`.`lngId` is null or `menus`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `order` asc, `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `menus` where `menus`.`parent_id` in (4, 8, 9, 10, 11, 1089) and `menus`.`deleted_at` is null and (`menus`.`lngId` is null or `menus`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `pages` where `pages`.`id` in (337, 340, 341, 2667) and `pages`.`deleted_at` is null and (`pages`.`lngId` is null or `pages`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `pages` where `pages`.`id` = 2646 and `pages`.`deleted_at` is null and (`pages`.`lngId` is null or `pages`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `pages` where `pages`.`id` = 1304 and `pages`.`deleted_at` is null and (`pages`.`lngId` is null or `pages`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `pages` where `pages`.`id` = 341 and `pages`.`deleted_at` is null and (`pages`.`lngId` is null or `pages`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `pages` where `pages`.`id` = 662 and `pages`.`deleted_at` is null and (`pages`.`lngId` is null or `pages`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `pages` where `pages`.`id` = 130 and `pages`.`deleted_at` is null and (`pages`.`lngId` is null or `pages`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `pages` where `pages`.`id` = 2320 and `pages`.`deleted_at` is null and (`pages`.`lngId` is null or `pages`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `pages` where `pages`.`id` = 2722 and `pages`.`deleted_at` is null and (`pages`.`lngId` is null or `pages`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `pages` where `pages`.`id` = 3452 and `pages`.`deleted_at` is null and (`pages`.`lngId` is null or `pages`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `pages` where `pages`.`id` = 182 and `pages`.`deleted_at` is null and (`pages`.`lngId` is null or `pages`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `pages` where `pages`.`id` = 352 and `pages`.`deleted_at` is null and (`pages`.`lngId` is null or `pages`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `pages` where `pages`.`id` = 2361 and `pages`.`deleted_at` is null and (`pages`.`lngId` is null or `pages`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `menus` where `position` = 2 and `parent_id` is null and `menus`.`deleted_at` is null and (`menus`.`lngId` is null or `menus`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `order` asc, `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `menus` where `menus`.`parent_id` in (53, 61, 62, 63, 154, 157, 158, 204, 209, 880, 943, 974, 975, 984, 985, 986, 987, 1083) and `menus`.`deleted_at` is null and (`menus`.`lngId` is null or `menus`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `pages` where `pages`.`id` in (130, 174, 340, 341, 342, 352, 576, 662, 1307, 2646, 2667, 2982, 3169, 3170, 3183, 3452) and `pages`.`deleted_at` is null and (`pages`.`lngId` is null or `pages`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `menus` where `position` = 4 and `parent_id` is null and `menus`.`deleted_at` is null and (`menus`.`lngId` is null or `menus`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `order` asc, `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `menus` where `menus`.`parent_id` in (166, 167, 169, 260, 261, 264, 267, 1002) and `menus`.`deleted_at` is null and (`menus`.`lngId` is null or `menus`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `pages` where `pages`.`id` in (216, 232, 240, 248, 342, 362, 556, 3252) and `pages`.`deleted_at` is null and (`pages`.`lngId` is null or `pages`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `parentId` is null and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `order` asc, `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`parentId` in ('2DBF99C2-B887-45CC-B040-C11B8685B420', '30E5B649-D124-444D-90E8-15700ACFA643', '368F6AEA-1878-42A3-BD33-61B899A802DB', '3A0BDA4C-DFC8-4C88-AF5E-A1E56D78ECB7', '42FB0E18-E8BA-4F1C-9A44-AC43B4AA4108', '54891694-B598-4749-9332-822476DA4E14', '5C2DD4F5-056B-4961-B309-A37BA1BC5A4E', '6693BD7E-0B35-49EE-9F86-03F232998927', '7A6D08A3-DB1C-445C-8FEE-52E108F5E215', '8AA3B9B8-D2B6-4D55-A3FC-0395CD31FC52', 'B1335701-77AD-48E8-8384-13EE0A4C7AA6', 'D2377297-85F4-4F80-A7C1-97C4C9D341B0', 'F1D7419B-13D1-4D95-8AF7-0D95AED30BF2') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `order` asc, `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2DBF99C2-B887-45CC-B040-C11B8685B420', '30E5B649-D124-444D-90E8-15700ACFA643', '368F6AEA-1878-42A3-BD33-61B899A802DB', '3A0BDA4C-DFC8-4C88-AF5E-A1E56D78ECB7', '42FB0E18-E8BA-4F1C-9A44-AC43B4AA4108', '54891694-B598-4749-9332-822476DA4E14', '5C2DD4F5-056B-4961-B309-A37BA1BC5A4E', '6693BD7E-0B35-49EE-9F86-03F232998927', '7A6D08A3-DB1C-445C-8FEE-52E108F5E215', '8AA3B9B8-D2B6-4D55-A3FC-0395CD31FC52', 'B1335701-77AD-48E8-8384-13EE0A4C7AA6', 'D2377297-85F4-4F80-A7C1-97C4C9D341B0', 'F1D7419B-13D1-4D95-8AF7-0D95AED30BF2') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `lngId` = '7' and `PR_Categories`.`categoryId` in ('2DBF99C2-B887-45CC-B040-C11B8685B420', '30E5B649-D124-444D-90E8-15700ACFA643', '368F6AEA-1878-42A3-BD33-61B899A802DB', '3A0BDA4C-DFC8-4C88-AF5E-A1E56D78ECB7', '42FB0E18-E8BA-4F1C-9A44-AC43B4AA4108', '54891694-B598-4749-9332-822476DA4E14', '5C2DD4F5-056B-4961-B309-A37BA1BC5A4E', '6693BD7E-0B35-49EE-9F86-03F232998927', '7A6D08A3-DB1C-445C-8FEE-52E108F5E215', '8AA3B9B8-D2B6-4D55-A3FC-0395CD31FC52', 'B1335701-77AD-48E8-8384-13EE0A4C7AA6', 'D2377297-85F4-4F80-A7C1-97C4C9D341B0', 'F1D7419B-13D1-4D95-8AF7-0D95AED30BF2') and `PR_Categories`.`deleted_at` is null and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `key`, `value` from `settings` where `settings`.`deleted_at` is null and (`settings`.`lngId` is null or `settings`.`lngId` = 7) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `parentId` is null and `slug` = 'roof-racks' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `parentId` = '5C2DD4F5-056B-4961-B309-A37BA1BC5A4E' and `slug` = 'cross-bar-roof-racks' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `parentId` = '13674F82-0F17-442D-AD28-13A8C7683425' and `slug` = 'reconn-deck-bar' and `PR_Categories`.`deleted_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%01588' and (title like 'land%rover%defender%l663%110%rcl4%rdb126%x2%rcp73%x2' or title_US_CA like 'land%rover%defender%l663%110%rcl4%rdb126%x2%rcp73%x2') and `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 ('B2B00668-0769-425F-9AAE-37E0E6558D43') 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 ('B2B00668-0769-425F-9AAE-37E0E6558D43') 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 ('B2B00668-0769-425F-9AAE-37E0E6558D43') 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 ('B2B00668-0769-425F-9AAE-37E0E6558D43') 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_Products` where `PR_Products`.`productId` in ('4FDE377B-99E5-495E-A6B0-38E5A61161BA', 'AB57AF60-B0FB-4FD2-9D09-287AED792BA6', 'F4CDDAAD-7D24-4FBD-990E-29B414435741') and `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 ('4FDE377B-99E5-495E-A6B0-38E5A61161BA', 'AB57AF60-B0FB-4FD2-9D09-287AED792BA6', 'F4CDDAAD-7D24-4FBD-990E-29B414435741') 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_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 ('B2B00668-0769-425F-9AAE-37E0E6558D43') 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 ('B2B00668-0769-425F-9AAE-37E0E6558D43') 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 ('B2B00668-0769-425F-9AAE-37E0E6558D43') and `PR_ProductSpecifications`.`deleted_at` is null
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Specifications` where `PR_Specifications`.`specificationId` in ('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', 'E9C9995C-92C7-4080-8082-696261075237') and `PR_Specifications`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductSpecificationProperties` where `PR_ProductSpecificationProperties`.`productId` in ('B2B00668-0769-425F-9AAE-37E0E6558D43') 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 ('B2B00668-0769-425F-9AAE-37E0E6558D43') and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('143A7C4F-815D-4B17-B08E-BEAD3B7537D2', '958A5D94-F707-4100-9DED-71A1F9469BBC', '9A915692-6FDF-40C0-AA16-720A3917FCAC', 'F02BBDE5-BD2F-4411-9C6D-65254BCFFC77') and `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 ('143A7C4F-815D-4B17-B08E-BEAD3B7537D2', '958A5D94-F707-4100-9DED-71A1F9469BBC', '9A915692-6FDF-40C0-AA16-720A3917FCAC', 'F02BBDE5-BD2F-4411-9C6D-65254BCFFC77') 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 ('B2B00668-0769-425F-9AAE-37E0E6558D43') 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 `PR_BarTypeProductCompatibilities` inner join `PR_BarTypes` on `PR_BarTypeProductCompatibilities`.`barTypeId` = `PR_BarTypes`.`barTypeId` where `PR_BarTypeProductCompatibilities`.`productId` in ('B2B00668-0769-425F-9AAE-37E0E6558D43') 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` = 'B2B00668-0769-425F-9AAE-37E0E6558D43' 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 ('958A5D94-F707-4100-9DED-71A1F9469BBC', '9A915692-6FDF-40C0-AA16-720A3917FCAC', 'F02BBDE5-BD2F-4411-9C6D-65254BCFFC77', '143A7C4F-815D-4B17-B08E-BEAD3B7537D2') 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 `productId` in ('30F1AEB2-BEF8-4E03-8F81-EA7A167060CB', '3996D16E-E405-4813-8D78-AF5AF135AD27', '39FF3FD0-C6DF-4D19-B212-2292A45BF9B8', '50F327F9-1758-478A-9979-C5D7157FB3EA', '7D2ED2A1-8EDB-4163-A79E-6D90E95D0DD2', '9950C96B-B913-4CF1-BA47-8B54B0DD889E') and `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 `productId` in ('30F1AEB2-BEF8-4E03-8F81-EA7A167060CB', '3996D16E-E405-4813-8D78-AF5AF135AD27', '39FF3FD0-C6DF-4D19-B212-2292A45BF9B8', '50F327F9-1758-478A-9979-C5D7157FB3EA', '7D2ED2A1-8EDB-4163-A79E-6D90E95D0DD2', '9950C96B-B913-4CF1-BA47-8B54B0DD889E') and `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 ('30F1AEB2-BEF8-4E03-8F81-EA7A167060CB', '3996D16E-E405-4813-8D78-AF5AF135AD27', '39FF3FD0-C6DF-4D19-B212-2292A45BF9B8', '50F327F9-1758-478A-9979-C5D7157FB3EA', '7D2ED2A1-8EDB-4163-A79E-6D90E95D0DD2', '9950C96B-B913-4CF1-BA47-8B54B0DD889E') 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_ProductSpecificationProperties` where `PR_ProductSpecificationProperties`.`productId` = 'B2B00668-0769-425F-9AAE-37E0E6558D43' 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', '3178C8C8-BCD1-49B2-8B42-5D6A9F870FE9', '48062BB7-CD0E-41B9-88D0-4C6174AD6AAF', '6024D9B1-0D46-48C2-934F-6541BB04B02B', 'B2B090A4-D7F1-48B1-BB9A-7979E5D901D2', 'BDB99B83-7053-4913-94AA-4A53DBDE5668') and `PR_SpecificationProperties`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Specifications` where `PR_Specifications`.`specificationId` in ('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', 'E9C9995C-92C7-4080-8082-696261075237') 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', '3F14EB95-4454-41D0-A8BC-0F6C5625FC02', '66E7F1BA-B555-492C-9374-8F26C71C15F1', '706802A2-C753-4C62-AFE7-AC2A34C21018', 'A6B4D90E-958D-41CE-BC01-7DAECAE521B0') 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', '3F14EB95-4454-41D0-A8BC-0F6C5625FC02', '66E7F1BA-B555-492C-9374-8F26C71C15F1', '706802A2-C753-4C62-AFE7-AC2A34C21018', 'A6B4D90E-958D-41CE-BC01-7DAECAE521B0') 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` = 'B2B00668-0769-425F-9AAE-37E0E6558D43' 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', '9DAE2B8A-A943-4F24-9F86-C273B4A7AD16', '9FAEEF1B-AA94-48F9-A1B4-197ED61FD233') and `PR_Categories`.`deleted_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 ('9DAE2B8A-A943-4F24-9F86-C273B4A7AD16', '9FAEEF1B-AA94-48F9-A1B4-197ED61FD233', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '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 ('65EBFA01-7744-4861-803E-BA026DFC9BA0', 'E9C9995C-92C7-4080-8082-696261075237', '6284DBED-EF43-4436-A768-B530DA94D027', '65EBFA01-7744-4861-803E-BA026DFC9BA0', '65DE24DC-83D6-4790-8EDE-0DEAD147EF02', '6FEC7B95-51EA-498A-A900-8FD5DA6C89D2', '2A37E3E3-CB54-453A-9EE9-53B3406A76CB', '2261BB38-5354-44FE-B45C-849D201849B0', '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` = 'B2B00668-0769-425F-9AAE-37E0E6558D43' 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 ('143A7C4F-815D-4B17-B08E-BEAD3B7537D2', '958A5D94-F707-4100-9DED-71A1F9469BBC', '9A915692-6FDF-40C0-AA16-720A3917FCAC', 'F02BBDE5-BD2F-4411-9C6D-65254BCFFC77') and `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 ('143A7C4F-815D-4B17-B08E-BEAD3B7537D2', '958A5D94-F707-4100-9DED-71A1F9469BBC', '9A915692-6FDF-40C0-AA16-720A3917FCAC', 'F02BBDE5-BD2F-4411-9C6D-65254BCFFC77') 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 ('113B5E60-DCB5-40FC-B3B8-84B60A71FF4F', '4A65457B-DF19-4771-99C7-D4BE4B313755', '6F803376-8210-4FCB-823C-0D1ED8CF52AF', '7BEC1597-3FE2-4512-B2AB-81B3D45734E7') 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` = 'B2B00668-0769-425F-9AAE-37E0E6558D43' 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` = '958A5D94-F707-4100-9DED-71A1F9469BBC' and `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` = '958A5D94-F707-4100-9DED-71A1F9469BBC' 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` = '9A915692-6FDF-40C0-AA16-720A3917FCAC' and `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` = '9A915692-6FDF-40C0-AA16-720A3917FCAC' 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', '8631BC7A-EEA0-4493-ACC0-BBE87A548574', '8FFCFC4E-36DE-4735-990F-C19B9848777B', 'B845D6C5-F078-4D34-BE15-D394D64B9011', 'C3F2A9BE-BCBD-4B0C-B834-2EA62E99A733') and `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` = 'F02BBDE5-BD2F-4411-9C6D-65254BCFFC77' and `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` = 'F02BBDE5-BD2F-4411-9C6D-65254BCFFC77' 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` = '143A7C4F-815D-4B17-B08E-BEAD3B7537D2' and `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` = '143A7C4F-815D-4B17-B08E-BEAD3B7537D2' 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 ('A9ED3662-2F8B-41AF-B174-7A07C8290FFE') and `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 ('9DAE2B8A-A943-4F24-9F86-C273B4A7AD16', '9FAEEF1B-AA94-48F9-A1B4-197ED61FD233', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '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 ('9DAE2B8A-A943-4F24-9F86-C273B4A7AD16', '9FAEEF1B-AA94-48F9-A1B4-197ED61FD233', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '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', '13674F82-0F17-442D-AD28-13A8C7683425') 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', '13674F82-0F17-442D-AD28-13A8C7683425') 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') 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` = 'B2B00668-0769-425F-9AAE-37E0E6558D43' 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` = 'B2B00668-0769-425F-9AAE-37E0E6558D43' 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` = '958A5D94-F707-4100-9DED-71A1F9469BBC' 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` = '9A915692-6FDF-40C0-AA16-720A3917FCAC' 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` = 'F02BBDE5-BD2F-4411-9C6D-65254BCFFC77' 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` = '143A7C4F-815D-4B17-B08E-BEAD3B7537D2' 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` = '5C2DD4F5-056B-4961-B309-A37BA1BC5A4E' and `slug` = 'cross-bar-roof-racks' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `parentId` = '13674F82-0F17-442D-AD28-13A8C7683425' and `slug` = 'reconn-deck-bar' 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%01588' 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 ('B2B00668-0769-425F-9AAE-37E0E6558D43') 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 ('B2B00668-0769-425F-9AAE-37E0E6558D43') 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 ('B2B00668-0769-425F-9AAE-37E0E6558D43') 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 ('B2B00668-0769-425F-9AAE-37E0E6558D43') 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_Products` where `PR_Products`.`productId` in ('4FDE377B-99E5-495E-A6B0-38E5A61161BA', 'AB57AF60-B0FB-4FD2-9D09-287AED792BA6', 'F4CDDAAD-7D24-4FBD-990E-29B414435741') and `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 ('4FDE377B-99E5-495E-A6B0-38E5A61161BA', 'AB57AF60-B0FB-4FD2-9D09-287AED792BA6', 'F4CDDAAD-7D24-4FBD-990E-29B414435741') 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_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 ('B2B00668-0769-425F-9AAE-37E0E6558D43') 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 ('B2B00668-0769-425F-9AAE-37E0E6558D43') 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 ('B2B00668-0769-425F-9AAE-37E0E6558D43') and `PR_ProductSpecifications`.`deleted_at` is null
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Specifications` where `PR_Specifications`.`specificationId` in ('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', 'E9C9995C-92C7-4080-8082-696261075237') and `PR_Specifications`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductSpecificationProperties` where `PR_ProductSpecificationProperties`.`productId` in ('B2B00668-0769-425F-9AAE-37E0E6558D43') 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 ('B2B00668-0769-425F-9AAE-37E0E6558D43') and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('143A7C4F-815D-4B17-B08E-BEAD3B7537D2', '958A5D94-F707-4100-9DED-71A1F9469BBC', '9A915692-6FDF-40C0-AA16-720A3917FCAC', 'F02BBDE5-BD2F-4411-9C6D-65254BCFFC77') and `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 ('143A7C4F-815D-4B17-B08E-BEAD3B7537D2', '958A5D94-F707-4100-9DED-71A1F9469BBC', '9A915692-6FDF-40C0-AA16-720A3917FCAC', 'F02BBDE5-BD2F-4411-9C6D-65254BCFFC77') 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 ('B2B00668-0769-425F-9AAE-37E0E6558D43') 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 `PR_BarTypeProductCompatibilities` inner join `PR_BarTypes` on `PR_BarTypeProductCompatibilities`.`barTypeId` = `PR_BarTypes`.`barTypeId` where `PR_BarTypeProductCompatibilities`.`productId` in ('B2B00668-0769-425F-9AAE-37E0E6558D43') 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` = 'B2B00668-0769-425F-9AAE-37E0E6558D43' 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', '9DAE2B8A-A943-4F24-9F86-C273B4A7AD16', '9FAEEF1B-AA94-48F9-A1B4-197ED61FD233') and `PR_Categories`.`deleted_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 ('9DAE2B8A-A943-4F24-9F86-C273B4A7AD16', '9FAEEF1B-AA94-48F9-A1B4-197ED61FD233', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '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 ('65EBFA01-7744-4861-803E-BA026DFC9BA0', 'E9C9995C-92C7-4080-8082-696261075237', '6284DBED-EF43-4436-A768-B530DA94D027', '65EBFA01-7744-4861-803E-BA026DFC9BA0', '65DE24DC-83D6-4790-8EDE-0DEAD147EF02', '6FEC7B95-51EA-498A-A900-8FD5DA6C89D2', '2A37E3E3-CB54-453A-9EE9-53B3406A76CB', '2261BB38-5354-44FE-B45C-849D201849B0', '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` = 'B2B00668-0769-425F-9AAE-37E0E6558D43' 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 ('143A7C4F-815D-4B17-B08E-BEAD3B7537D2', '958A5D94-F707-4100-9DED-71A1F9469BBC', '9A915692-6FDF-40C0-AA16-720A3917FCAC', 'F02BBDE5-BD2F-4411-9C6D-65254BCFFC77') and `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 ('143A7C4F-815D-4B17-B08E-BEAD3B7537D2', '958A5D94-F707-4100-9DED-71A1F9469BBC', '9A915692-6FDF-40C0-AA16-720A3917FCAC', 'F02BBDE5-BD2F-4411-9C6D-65254BCFFC77') 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 ('113B5E60-DCB5-40FC-B3B8-84B60A71FF4F', '4A65457B-DF19-4771-99C7-D4BE4B313755', '6F803376-8210-4FCB-823C-0D1ED8CF52AF', '7BEC1597-3FE2-4512-B2AB-81B3D45734E7') 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` = 'B2B00668-0769-425F-9AAE-37E0E6558D43' 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 ('9DAE2B8A-A943-4F24-9F86-C273B4A7AD16') and `PR_Categories`.`deleted_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` = 'B2B00668-0769-425F-9AAE-37E0E6558D43' 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` = 'B2B00668-0769-425F-9AAE-37E0E6558D43' 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` = '958A5D94-F707-4100-9DED-71A1F9469BBC' 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` = '9A915692-6FDF-40C0-AA16-720A3917FCAC' 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` = 'F02BBDE5-BD2F-4411-9C6D-65254BCFFC77' 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` = '143A7C4F-815D-4B17-B08E-BEAD3B7537D2' 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` = 'B2B00668-0769-425F-9AAE-37E0E6558D43' 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 * from `VM_Vehicles` where `VM_Vehicles`.`vehicleId` in ('982E1138-9A85-42F2-9C02-EE82FC56906B') 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
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_VehicleProducts` where `PR_VehicleProducts`.`productId` = 'B2B00668-0769-425F-9AAE-37E0E6558D43' 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 * from `VM_Vehicles` where `VM_Vehicles`.`vehicleId` in ('982E1138-9A85-42F2-9C02-EE82FC56906B') 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
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `VM_Models` where `VM_Models`.`modelId` = '0D6229C8-1602-4BC3-AED0-C88D56E9B476' 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` = '7') and `isActive` = 1 order by `lngId` desc) and (`VM_Models`.`lngId` is null or `VM_Models`.`lngId` = '7') and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `VM_Manufacturers` where `VM_Manufacturers`.`manufacturerId` in ('EF1E54BF-5743-454D-8C17-7AD8333C3BBC') and `VM_Manufacturers`.`deleted_at` is null and (`VM_Manufacturers`.`lngId` is null or `VM_Manufacturers`.`lngId` = '7') 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` = '7') and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `VM_Attributes` where `VM_Attributes`.`attributeId` = '6ED7AC05-5293-422F-B070-0B0C6648DB22' and `VM_Attributes`.`deleted_at` is null and (`VM_Attributes`.`lngId` is null or `VM_Attributes`.`lngId` = '7') and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('9DAE2B8A-A943-4F24-9F86-C273B4A7AD16', '9FAEEF1B-AA94-48F9-A1B4-197ED61FD233', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '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` = 'B2B00668-0769-425F-9AAE-37E0E6558D43' 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 `VM_Models` where `VM_Models`.`modelId` = '0D6229C8-1602-4BC3-AED0-C88D56E9B476' 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` = '7') and `isActive` = 1 order by `lngId` desc) and (`VM_Models`.`lngId` is null or `VM_Models`.`lngId` = '7') and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `VM_Manufacturers` where `VM_Manufacturers`.`manufacturerId` in ('EF1E54BF-5743-454D-8C17-7AD8333C3BBC') and `VM_Manufacturers`.`deleted_at` is null and (`VM_Manufacturers`.`lngId` is null or `VM_Manufacturers`.`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` = '8FFCFC4E-36DE-4735-990F-C19B9848777B' 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` = '8FFCFC4E-36DE-4735-990F-C19B9848777B' 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` = 'C3F2A9BE-BCBD-4B0C-B834-2EA62E99A733' 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` = 'C3F2A9BE-BCBD-4B0C-B834-2EA62E99A733' 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` = 'A9ED3662-2F8B-41AF-B174-7A07C8290FFE' 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 ('16D1C297-9551-4682-AA9B-2C0535FDE1C1', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('16D1C297-9551-4682-AA9B-2C0535FDE1C1', '2C0FB2F9-F310-435A-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` = 'A9ED3662-2F8B-41AF-B174-7A07C8290FFE' 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 ('16D1C297-9551-4682-AA9B-2C0535FDE1C1', '2C0FB2F9-F310-435A-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 ('16D1C297-9551-4682-AA9B-2C0535FDE1C1', '2C0FB2F9-F310-435A-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` = '30F1AEB2-BEF8-4E03-8F81-EA7A167060CB' 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 ('08FDCA51-149B-4C4B-8C87-D52042CA6273', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '6B4D0CB0-AC14-42A6-AB32-AA7FB8A79ADA', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', 'DFC7031B-350D-4256-BFD8-A01156482C16') and `PR_Categories`.`deleted_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', 'DFC7031B-350D-4256-BFD8-A01156482C16', '6B4D0CB0-AC14-42A6-AB32-AA7FB8A79ADA', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '08FDCA51-149B-4C4B-8C87-D52042CA6273', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '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` = '30F1AEB2-BEF8-4E03-8F81-EA7A167060CB' 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', 'DFC7031B-350D-4256-BFD8-A01156482C16', '6B4D0CB0-AC14-42A6-AB32-AA7FB8A79ADA', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '08FDCA51-149B-4C4B-8C87-D52042CA6273', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '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', 'DFC7031B-350D-4256-BFD8-A01156482C16', '6B4D0CB0-AC14-42A6-AB32-AA7FB8A79ADA', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '08FDCA51-149B-4C4B-8C87-D52042CA6273', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '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` = '3996D16E-E405-4813-8D78-AF5AF135AD27' 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 ('08FDCA51-149B-4C4B-8C87-D52042CA6273', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'AA01953E-CABA-43AF-B1A3-226E590C3B1B', 'DFC7031B-350D-4256-BFD8-A01156482C16') and `PR_Categories`.`deleted_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', 'AA01953E-CABA-43AF-B1A3-226E590C3B1B', 'DFC7031B-350D-4256-BFD8-A01156482C16', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '08FDCA51-149B-4C4B-8C87-D52042CA6273', '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` = '3996D16E-E405-4813-8D78-AF5AF135AD27' 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', 'AA01953E-CABA-43AF-B1A3-226E590C3B1B', 'DFC7031B-350D-4256-BFD8-A01156482C16', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '08FDCA51-149B-4C4B-8C87-D52042CA6273', '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', 'AA01953E-CABA-43AF-B1A3-226E590C3B1B', 'DFC7031B-350D-4256-BFD8-A01156482C16', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '08FDCA51-149B-4C4B-8C87-D52042CA6273', '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` = '39FF3FD0-C6DF-4D19-B212-2292A45BF9B8' 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 ('08FDCA51-149B-4C4B-8C87-D52042CA6273', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', 'DFC7031B-350D-4256-BFD8-A01156482C16') and `PR_Categories`.`deleted_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 ('DFC7031B-350D-4256-BFD8-A01156482C16', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '08FDCA51-149B-4C4B-8C87-D52042CA6273', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '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` = '39FF3FD0-C6DF-4D19-B212-2292A45BF9B8' 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 ('DFC7031B-350D-4256-BFD8-A01156482C16', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '08FDCA51-149B-4C4B-8C87-D52042CA6273', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '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 ('DFC7031B-350D-4256-BFD8-A01156482C16', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '08FDCA51-149B-4C4B-8C87-D52042CA6273', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '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` = '50F327F9-1758-478A-9979-C5D7157FB3EA' 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', 'C575480C-6360-4727-83BC-7B8AEEC03B3C', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', 'C575480C-6360-4727-83BC-7B8AEEC03B3C', '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` = '50F327F9-1758-478A-9979-C5D7157FB3EA' 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 ('DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', 'C575480C-6360-4727-83BC-7B8AEEC03B3C', '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 ('DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', 'C575480C-6360-4727-83BC-7B8AEEC03B3C', '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` = '7D2ED2A1-8EDB-4163-A79E-6D90E95D0DD2' 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 ('08FDCA51-149B-4C4B-8C87-D52042CA6273', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC7031B-350D-4256-BFD8-A01156482C16') and `PR_Categories`.`deleted_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 ('08FDCA51-149B-4C4B-8C87-D52042CA6273', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC7031B-350D-4256-BFD8-A01156482C16', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '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` = '7D2ED2A1-8EDB-4163-A79E-6D90E95D0DD2' 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 ('08FDCA51-149B-4C4B-8C87-D52042CA6273', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC7031B-350D-4256-BFD8-A01156482C16', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '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 ('08FDCA51-149B-4C4B-8C87-D52042CA6273', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC7031B-350D-4256-BFD8-A01156482C16', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '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` = '9950C96B-B913-4CF1-BA47-8B54B0DD889E' 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 ('15C302E4-2F9B-4FC3-98C3-3B843089FBAE', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '41C0E016-D44F-414F-8DCD-07CBA1565B47', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '90C0F092-493B-4085-A77B-97371E143D35', 'DFC7031B-350D-4256-BFD8-A01156482C16', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 7) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('DFC7031B-350D-4256-BFD8-A01156482C16', '41C0E016-D44F-414F-8DCD-07CBA1565B47', '15C302E4-2F9B-4FC3-98C3-3B843089FBAE', '90C0F092-493B-4085-A77B-97371E143D35', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '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` = '9950C96B-B913-4CF1-BA47-8B54B0DD889E' 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 ('DFC7031B-350D-4256-BFD8-A01156482C16', '41C0E016-D44F-414F-8DCD-07CBA1565B47', '15C302E4-2F9B-4FC3-98C3-3B843089FBAE', '90C0F092-493B-4085-A77B-97371E143D35', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '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 ('DFC7031B-350D-4256-BFD8-A01156482C16', '41C0E016-D44F-414F-8DCD-07CBA1565B47', '15C302E4-2F9B-4FC3-98C3-3B843089FBAE', '90C0F092-493B-4085-A77B-97371E143D35', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '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 `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/cross-bar-roof-racks/reconn-deck-bar/land-rover-defender-l663-110-rcl4-rdb126-x2-rcp73-x2_jc-01588" "REDIRECT_SCRIPT_URI" => "https://rrweb.webexpertsnepal.com/en-au/products/roof-racks/cross-bar-roof-racks/reconn-deck-bar/land-rover-defender-l663-110-rcl4-rdb126-x2-rcp73-x2_jc-01588" "REDIRECT_HTTPS" => "on" "REDIRECT_SSL_TLS_SNI" => "rrweb.webexpertsnepal.com" "REDIRECT_STATUS" => "200" "SCRIPT_URL" => "/en-au/products/roof-racks/cross-bar-roof-racks/reconn-deck-bar/land-rover-defender-l663-110-rcl4-rdb126-x2-rcp73-x2_jc-01588" "SCRIPT_URI" => "https://rrweb.webexpertsnepal.com/en-au/products/roof-racks/cross-bar-roof-racks/reconn-deck-bar/land-rover-defender-l663-110-rcl4-rdb126-x2-rcp73-x2_jc-01588" "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" => "24803" "REDIRECT_URL" => "/en-au/products/roof-racks/cross-bar-roof-racks/reconn-deck-bar/land-rover-defender-l663-110-rcl4-rdb126-x2-rcp73-x2_jc-01588" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/en-au/products/roof-racks/cross-bar-roof-racks/reconn-deck-bar/land-rover-defender-l663-110-rcl4-rdb126-x2-rcp73-x2_jc-01588" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1746944956.7186 "REQUEST_TIME" => 1746944956 ]
[]
0 of 0array:5 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Sun, 11 May 2025 06:29:17 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkJSZTRGOWZHN2hYcEk0c3NJYlZDWnc9PSIsInZhbHVlIjoiLzhSY2tkNk1jUGdISlpQSytxUE43NFNUQWh1M1dacS95U0tyYUxTWTUrSTVSWnI3YW9zZkF0bnMwSzZpQnZZdE4xWTJzU2hLdjRnTnFuQ0RUdVloNUJBUnVUYlBjZjE2eG5YMXI3ZGxLNjhCOEZkQ0o3aWJMRmE5L0E3VnZaOEciLCJtYWMiOiJmN2I4NWUzOGEyZGU3NGUzZjBhMzNhMGUzMjg4MTA2NzEwZTM0ZDNlNjAyYWExNzRjOTVjZTY4YjQ1YzEzMDI3IiwidGFnIjoiIn0%3D; expires=Tue, 10 Jun 2025 16:29:18 GMT; Max-Age=2628000; path=/ ◀XSRF-TOKEN=eyJpdiI6IkJSZTRGOWZHN2hYcEk0c3NJYlZDWnc9PSIsInZhbHVlIjoiLzhSY2tkNk1jUGdISlpQSytxUE43NFNUQWh1M1dacS95U0tyYUxTWTUrSTVSWnI3YW9zZkF0bnMwSzZpQnZZdE4xWTJzU ▶" 1 => "rhino_rack_session=eyJpdiI6IkxZR2NRT1gxeFV4TVNlWXNmbkZKTFE9PSIsInZhbHVlIjoiNzRPaU9PYVhyNFFDVnN1ZmpVNVZQalBUMG1XOHJsc0xsaitqYzNpcDFQdjc5dDBmeWxsUTlCT0laQmFQWjdtamdiMXJoelpPRUh4ekdqMDNtdkIwK3p0bU5JSzFjOHJGakVtS0FoRFhCb1QzdG1wZkk2KzJjTEluL3JuN0s0bXAiLCJtYWMiOiIwOWNhOGE1MDYwMGJkZTgxYjc1ZjA3ZWFlMzk3ZjNmZDY1N2Y2NmUyNzgxNmU5MjVlYTcyYWJhN2RkYzA4YmU2IiwidGFnIjoiIn0%3D; expires=Tue, 10 Jun 2025 16:29:18 GMT; Max-Age=2628000; path=/; httponly ◀rhino_rack_session=eyJpdiI6IkxZR2NRT1gxeFV4TVNlWXNmbkZKTFE9PSIsInZhbHVlIjoiNzRPaU9PYVhyNFFDVnN1ZmpVNVZQalBUMG1XOHJsc0xsaitqYzNpcDFQdjc5dDBmeWxsUTlCT0laQmFQWjdta ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkJSZTRGOWZHN2hYcEk0c3NJYlZDWnc9PSIsInZhbHVlIjoiLzhSY2tkNk1jUGdISlpQSytxUE43NFNUQWh1M1dacS95U0tyYUxTWTUrSTVSWnI3YW9zZkF0bnMwSzZpQnZZdE4xWTJzU2hLdjRnTnFuQ0RUdVloNUJBUnVUYlBjZjE2eG5YMXI3ZGxLNjhCOEZkQ0o3aWJMRmE5L0E3VnZaOEciLCJtYWMiOiJmN2I4NWUzOGEyZGU3NGUzZjBhMzNhMGUzMjg4MTA2NzEwZTM0ZDNlNjAyYWExNzRjOTVjZTY4YjQ1YzEzMDI3IiwidGFnIjoiIn0%3D; expires=Tue, 10-Jun-2025 16:29:18 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkJSZTRGOWZHN2hYcEk0c3NJYlZDWnc9PSIsInZhbHVlIjoiLzhSY2tkNk1jUGdISlpQSytxUE43NFNUQWh1M1dacS95U0tyYUxTWTUrSTVSWnI3YW9zZkF0bnMwSzZpQnZZdE4xWTJzU ▶" 1 => "rhino_rack_session=eyJpdiI6IkxZR2NRT1gxeFV4TVNlWXNmbkZKTFE9PSIsInZhbHVlIjoiNzRPaU9PYVhyNFFDVnN1ZmpVNVZQalBUMG1XOHJsc0xsaitqYzNpcDFQdjc5dDBmeWxsUTlCT0laQmFQWjdtamdiMXJoelpPRUh4ekdqMDNtdkIwK3p0bU5JSzFjOHJGakVtS0FoRFhCb1QzdG1wZkk2KzJjTEluL3JuN0s0bXAiLCJtYWMiOiIwOWNhOGE1MDYwMGJkZTgxYjc1ZjA3ZWFlMzk3ZjNmZDY1N2Y2NmUyNzgxNmU5MjVlYTcyYWJhN2RkYzA4YmU2IiwidGFnIjoiIn0%3D; expires=Tue, 10-Jun-2025 16:29:18 GMT; path=/; httponly ◀rhino_rack_session=eyJpdiI6IkxZR2NRT1gxeFV4TVNlWXNmbkZKTFE9PSIsInZhbHVlIjoiNzRPaU9PYVhyNFFDVnN1ZmpVNVZQalBUMG1XOHJsc0xsaitqYzNpcDFQdjc5dDBmeWxsUTlCT0laQmFQWjdta ▶" ] ]
0 of 0array:9 [▼ "_token" => "q3Vtj6f1GkXzN1EuQ39Vq9R47kvdlj11A8UFQ2sd" "country" => "au" "_flash" => array:2 [▶ "old" => [] "new" => [] ] "lngId" => 7 "session_culture" => "en-au" "random_number" => 83 "locale" => "en" "_previous" => array:1 [▶ "url" => "https://rrweb.webexpertsnepal.com/en-au/products/roof-racks/cross-bar-roof-racks/reconn-deck-bar/land-rover-defender-l663-110-rcl4-rdb126-x2-rcp73-x2_jc-01588" ] "PHPDEBUGBAR_STACK_DATA" => [] ]