| 1 |
50.64 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: [
976
981
194
974
977
973
922
900
825
132
93
562
"fr"
"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 (976, 981, 194, 974, 977, 973, 922, 900, 825, 132, 93, 562) AND m0_.locale = 'fr' AND m0_.status = 'published';
|
| 4 |
15.40 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 |
19.43 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: [
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_.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 (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);
|
| 6 |
37.14 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: [
1010
301
375
231
314
319
380
519
568
691
696
734
785
53
122
321
636
673
807
130
256
348
358
374
543
787
795
6
23
29
79
153
155
178
235
463
474
478
547
823
820
834
921
9
14
18
32
44
61
148
373
480
497
518
551
680
781
804
936
8
"fr"
"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 (1010, 301, 375, 231, 314, 319, 380, 519, 568, 691, 696, 734, 785, 53, 122, 321, 636, 673, 807, 130, 256, 348, 358, 374, 543, 787, 795, 6, 23, 29, 79, 153, 155, 178, 235, 463, 474, 478, 547, 823, 820, 834, 921, 9, 14, 18, 32, 44, 61, 148, 373, 480, 497, 518, 551, 680, 781, 804, 936, 8) AND m0_.locale = 'fr' AND m0_.status = 'published';
|