| 1 |
75.73 ms |
SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.description AS description_2, m0_.legends AS legends_3, m0_.goals AS goals_4, m0_.more AS more_5, m0_.scenario AS scenario_6, m0_.features AS features_7, m0_.published_at AS published_at_8, m0_.status AS status_9, m0_.created_at AS created_at_10, m0_.updated_at AS updated_at_11, m0_.locale AS locale_12, m1_.id AS id_13, m1_.type AS type_14, m1_.is_wide AS is_wide_15, m1_.thumbnail_name AS thumbnail_name_16, m1_.thumbnail_background AS thumbnail_background_17, m1_.project_id AS project_id_18, m1_.is_expert AS is_expert_19, m1_.created_at AS created_at_20, m1_.updated_at AS updated_at_21, m0_.translatable_id AS translatable_id_22 FROM media_translation m0_ INNER JOIN media m1_ ON m0_.translatable_id = m1_.id WHERE m1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND m0_.locale = ? AND m0_.status = ?
Parameters: [
330
147
414
140
506
472
173
600
622
15
948
593
"en"
"published"
]
SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.description AS description_2, m0_.legends AS legends_3, m0_.goals AS goals_4, m0_.more AS more_5, m0_.scenario AS scenario_6, m0_.features AS features_7, m0_.published_at AS published_at_8, m0_.status AS status_9, m0_.created_at AS created_at_10, m0_.updated_at AS updated_at_11, m0_.locale AS locale_12, m1_.id AS id_13, m1_.type AS type_14, m1_.is_wide AS is_wide_15, m1_.thumbnail_name AS thumbnail_name_16, m1_.thumbnail_background AS thumbnail_background_17, m1_.project_id AS project_id_18, m1_.is_expert AS is_expert_19, m1_.created_at AS created_at_20, m1_.updated_at AS updated_at_21, m0_.translatable_id AS translatable_id_22 FROM media_translation m0_ INNER JOIN media m1_ ON m0_.translatable_id = m1_.id WHERE m1_.id IN (330, 147, 414, 140, 506, 472, 173, 600, 622, 15, 948, 593) AND m0_.locale = 'en' AND m0_.status = 'published';
|
| 2 |
2.04 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.root AS root_5, t0.lvl AS lvl_6, t0.lft AS lft_7, t0.rgt AS rgt_8, t0.status AS status_9, t0.parent_id AS parent_id_10 FROM node t0 WHERE t0.parent_id IS NULL
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.root AS root_5, t0.lvl AS lvl_6, t0.lft AS lft_7, t0.rgt AS rgt_8, t0.status AS status_9, t0.parent_id AS parent_id_10 FROM node t0 WHERE t0.parent_id IS NULL;
|
| 3 |
1.85 ms |
SELECT n0_.id AS id_0, n0_.slug AS slug_1, n0_.created_at AS created_at_2, n0_.updated_at AS updated_at_3, n0_.root AS root_4, n0_.lvl AS lvl_5, n0_.lft AS lft_6, n0_.rgt AS rgt_7, n0_.status AS status_8 FROM node n0_ WHERE (n0_.rgt < 84 AND n0_.lft > 1 AND n0_.root = ?) OR n0_.id = ? ORDER BY n0_.root ASC, n0_.lft ASC
SELECT n0_.id AS id_0, n0_.slug AS slug_1, n0_.created_at AS created_at_2, n0_.updated_at AS updated_at_3, n0_.root AS root_4, n0_.lvl AS lvl_5, n0_.lft AS lft_6, n0_.rgt AS rgt_7, n0_.status AS status_8 FROM node n0_ WHERE (n0_.rgt < 84 AND n0_.lft > 1 AND n0_.root = 106) OR n0_.id = 106 ORDER BY n0_.root ASC, n0_.lft ASC;
|
| 4 |
9.89 ms |
SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.locale AS locale_2, n0_.translatable_id AS translatable_id_3 FROM node_translation n0_ WHERE n0_.translatable_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: [
106
112
136
409
408
407
406
405
135
413
412
411
410
111
137
134
133
140
132
110
131
130
139
129
128
138
109
127
126
125
242
123
108
122
121
107
244
120
119
118
117
115
]
SELECT
n0_.id AS id_0,
n0_.name AS name_1,
n0_.locale AS locale_2,
n0_.translatable_id AS translatable_id_3
FROM
node_translation n0_
WHERE
n0_.translatable_id IN (
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
)
SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.locale AS locale_2, n0_.translatable_id AS translatable_id_3 FROM node_translation n0_ WHERE n0_.translatable_id IN (106, 112, 136, 409, 408, 407, 406, 405, 135, 413, 412, 411, 410, 111, 137, 134, 133, 140, 132, 110, 131, 130, 139, 129, 128, 138, 109, 127, 126, 125, 242, 123, 108, 122, 121, 107, 244, 120, 119, 118, 117, 115);
|
| 5 |
2.44 ms |
SELECT n0_.id AS id_0, n0_.slug AS slug_1, n0_.created_at AS created_at_2, n0_.updated_at AS updated_at_3, n0_.root AS root_4, n0_.lvl AS lvl_5, n0_.lft AS lft_6, n0_.rgt AS rgt_7, n0_.status AS status_8 FROM node n0_ WHERE (n0_.rgt < 192 AND n0_.lft > 1 AND n0_.root = ?) OR n0_.id = ? ORDER BY n0_.root ASC, n0_.lft ASC
SELECT n0_.id AS id_0, n0_.slug AS slug_1, n0_.created_at AS created_at_2, n0_.updated_at AS updated_at_3, n0_.root AS root_4, n0_.lvl AS lvl_5, n0_.lft AS lft_6, n0_.rgt AS rgt_7, n0_.status AS status_8 FROM node n0_ WHERE (n0_.rgt < 192 AND n0_.lft > 1 AND n0_.root = 105) OR n0_.id = 105 ORDER BY n0_.root ASC, n0_.lft ASC;
|
| 6 |
4.75 ms |
SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.locale AS locale_2, n0_.translatable_id AS translatable_id_3 FROM node_translation n0_ WHERE n0_.translatable_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: [
105
18
28
346
102
23
101
99
98
97
22
96
95
94
17
26
24
20
86
91
357
90
404
53
55
420
424
347
421
422
54
61
83
85
84
243
74
82
78
349
348
81
403
80
75
76
77
67
70
73
72
71
69
68
356
355
354
62
66
65
64
402
418
417
416
415
47
49
352
351
60
51
52
59
241
423
30
46
45
31
33
32
350
400
48
34
35
36
40
398
39
397
399
37
43
]
SELECT
n0_.id AS id_0,
n0_.name AS name_1,
n0_.locale AS locale_2,
n0_.translatable_id AS translatable_id_3
FROM
node_translation n0_
WHERE
n0_.translatable_id IN (
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?
)
SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.locale AS locale_2, n0_.translatable_id AS translatable_id_3 FROM node_translation n0_ WHERE n0_.translatable_id IN (105, 18, 28, 346, 102, 23, 101, 99, 98, 97, 22, 96, 95, 94, 17, 26, 24, 20, 86, 91, 357, 90, 404, 53, 55, 420, 424, 347, 421, 422, 54, 61, 83, 85, 84, 243, 74, 82, 78, 349, 348, 81, 403, 80, 75, 76, 77, 67, 70, 73, 72, 71, 69, 68, 356, 355, 354, 62, 66, 65, 64, 402, 418, 417, 416, 415, 47, 49, 352, 351, 60, 51, 52, 59, 241, 423, 30, 46, 45, 31, 33, 32, 350, 400, 48, 34, 35, 36, 40, 398, 39, 397, 399, 37, 43);
|
| 7 |
1.59 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.root AS root_5, t0.lvl AS lvl_6, t0.lft AS lft_7, t0.rgt AS rgt_8, t0.status AS status_9, t0.parent_id AS parent_id_10 FROM node t0 WHERE t0.parent_id IS NULL
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.root AS root_5, t0.lvl AS lvl_6, t0.lft AS lft_7, t0.rgt AS rgt_8, t0.status AS status_9, t0.parent_id AS parent_id_10 FROM node t0 WHERE t0.parent_id IS NULL;
|
| 8 |
2.99 ms |
SELECT n0_.id AS id_0, n0_.slug AS slug_1, n0_.created_at AS created_at_2, n0_.updated_at AS updated_at_3, n0_.root AS root_4, n0_.lvl AS lvl_5, n0_.lft AS lft_6, n0_.rgt AS rgt_7, n0_.status AS status_8 FROM node n0_ WHERE (n0_.rgt < 192 AND n0_.lft > 1 AND n0_.root = ?) OR n0_.id = ? ORDER BY n0_.root ASC, n0_.lft ASC
SELECT n0_.id AS id_0, n0_.slug AS slug_1, n0_.created_at AS created_at_2, n0_.updated_at AS updated_at_3, n0_.root AS root_4, n0_.lvl AS lvl_5, n0_.lft AS lft_6, n0_.rgt AS rgt_7, n0_.status AS status_8 FROM node n0_ WHERE (n0_.rgt < 192 AND n0_.lft > 1 AND n0_.root = 105) OR n0_.id = 105 ORDER BY n0_.root ASC, n0_.lft ASC;
|
| 9 |
1.00 ms |
SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.locale AS locale_2, n0_.translatable_id AS translatable_id_3 FROM node_translation n0_ WHERE n0_.translatable_id IN (NULL)
SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.locale AS locale_2, n0_.translatable_id AS translatable_id_3 FROM node_translation n0_ WHERE n0_.translatable_id IN (NULL);
|
| 10 |
11.65 ms |
SELECT n0_.id AS id_0, n0_.position AS position_1, n0_.node_id AS node_id_2, n0_.media_id AS media_id_3 FROM node_media n0_ WHERE n0_.node_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: [
105
18
28
346
102
23
101
99
98
97
22
96
95
94
17
26
24
20
86
91
357
90
404
53
55
420
424
347
421
422
54
61
83
85
84
243
74
82
78
349
348
81
403
80
75
76
77
67
70
73
72
71
69
68
356
355
354
62
66
65
64
402
418
417
416
415
47
49
352
351
60
51
52
59
241
423
30
46
45
31
33
32
350
400
48
34
35
36
40
398
39
397
399
37
43
]
SELECT
n0_.id AS id_0,
n0_.position AS position_1,
n0_.node_id AS node_id_2,
n0_.media_id AS media_id_3
FROM
node_media n0_
WHERE
n0_.node_id IN (
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?
)
SELECT n0_.id AS id_0, n0_.position AS position_1, n0_.node_id AS node_id_2, n0_.media_id AS media_id_3 FROM node_media n0_ WHERE n0_.node_id IN (105, 18, 28, 346, 102, 23, 101, 99, 98, 97, 22, 96, 95, 94, 17, 26, 24, 20, 86, 91, 357, 90, 404, 53, 55, 420, 424, 347, 421, 422, 54, 61, 83, 85, 84, 243, 74, 82, 78, 349, 348, 81, 403, 80, 75, 76, 77, 67, 70, 73, 72, 71, 69, 68, 356, 355, 354, 62, 66, 65, 64, 402, 418, 417, 416, 415, 47, 49, 352, 351, 60, 51, 52, 59, 241, 423, 30, 46, 45, 31, 33, 32, 350, 400, 48, 34, 35, 36, 40, 398, 39, 397, 399, 37, 43);
|
| 11 |
4.66 ms |
SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.description AS description_2, m0_.legends AS legends_3, m0_.goals AS goals_4, m0_.more AS more_5, m0_.scenario AS scenario_6, m0_.features AS features_7, m0_.published_at AS published_at_8, m0_.status AS status_9, m0_.created_at AS created_at_10, m0_.updated_at AS updated_at_11, m0_.locale AS locale_12, m1_.id AS id_13, m1_.type AS type_14, m1_.is_wide AS is_wide_15, m1_.thumbnail_name AS thumbnail_name_16, m1_.thumbnail_background AS thumbnail_background_17, m1_.project_id AS project_id_18, m1_.is_expert AS is_expert_19, m1_.created_at AS created_at_20, m1_.updated_at AS updated_at_21, m0_.translatable_id AS translatable_id_22 FROM media_translation m0_ INNER JOIN media m1_ ON m0_.translatable_id = m1_.id WHERE m1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND m0_.locale = ? AND m0_.status = ?
Parameters: [
418
420
1008
1010
750
648
1012
290
94
137
161
226
233
322
339
366
549
552
661
663
767
893
30
259
266
555
905
925
951
17
35
69
329
360
394
505
507
644
684
694
730
741
851
927
931
25
232
310
315
452
558
590
743
761
955
54
110
113
129
166
"en"
"published"
]
SELECT
m0_.id AS id_0,
m0_.title AS title_1,
m0_.description AS description_2,
m0_.legends AS legends_3,
m0_.goals AS goals_4,
m0_.more AS more_5,
m0_.scenario AS scenario_6,
m0_.features AS features_7,
m0_.published_at AS published_at_8,
m0_.status AS status_9,
m0_.created_at AS created_at_10,
m0_.updated_at AS updated_at_11,
m0_.locale AS locale_12,
m1_.id AS id_13,
m1_.type AS type_14,
m1_.is_wide AS is_wide_15,
m1_.thumbnail_name AS thumbnail_name_16,
m1_.thumbnail_background AS thumbnail_background_17,
m1_.project_id AS project_id_18,
m1_.is_expert AS is_expert_19,
m1_.created_at AS created_at_20,
m1_.updated_at AS updated_at_21,
m0_.translatable_id AS translatable_id_22
FROM
media_translation m0_
INNER JOIN media m1_ ON m0_.translatable_id = m1_.id
WHERE
m1_.id IN (
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
)
AND m0_.locale = ?
AND m0_.status = ?
SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.description AS description_2, m0_.legends AS legends_3, m0_.goals AS goals_4, m0_.more AS more_5, m0_.scenario AS scenario_6, m0_.features AS features_7, m0_.published_at AS published_at_8, m0_.status AS status_9, m0_.created_at AS created_at_10, m0_.updated_at AS updated_at_11, m0_.locale AS locale_12, m1_.id AS id_13, m1_.type AS type_14, m1_.is_wide AS is_wide_15, m1_.thumbnail_name AS thumbnail_name_16, m1_.thumbnail_background AS thumbnail_background_17, m1_.project_id AS project_id_18, m1_.is_expert AS is_expert_19, m1_.created_at AS created_at_20, m1_.updated_at AS updated_at_21, m0_.translatable_id AS translatable_id_22 FROM media_translation m0_ INNER JOIN media m1_ ON m0_.translatable_id = m1_.id WHERE m1_.id IN (418, 420, 1008, 1010, 750, 648, 1012, 290, 94, 137, 161, 226, 233, 322, 339, 366, 549, 552, 661, 663, 767, 893, 30, 259, 266, 555, 905, 925, 951, 17, 35, 69, 329, 360, 394, 505, 507, 644, 684, 694, 730, 741, 851, 927, 931, 25, 232, 310, 315, 452, 558, 590, 743, 761, 955, 54, 110, 113, 129, 166) AND m0_.locale = 'en' AND m0_.status = 'published';
|
