1
4.62 ms
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . is_wide AS is_wide_3 , t0 . thumbnail_name AS thumbnail_name_4 , t0 . thumbnail_background AS thumbnail_background_5 , t0 . project_id AS project_id_6 , t0 . is_expert AS is_expert_7 , t0 . created_at AS created_at_8 , t0 . updated_at AS updated_at_9 FROM media t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . is_wide AS is_wide_3 , t0 . thumbnail_name AS thumbnail_name_4 , t0 . thumbnail_background AS thumbnail_background_5 , t0 . project_id AS project_id_6 , t0 . is_expert AS is_expert_7 , t0 . created_at AS created_at_8 , t0 . updated_at AS updated_at_9 FROM media t0 WHERE t0 . id = 208 ;
Copy
2
15.30 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . legends AS legends_4 , t0 . goals AS goals_5 , t0 . more AS more_6 , t0 . scenario AS scenario_7 , t0 . features AS features_8 , t0 . published_at AS published_at_9 , t0 . status AS status_10 , t0 . created_at AS created_at_11 , t0 . updated_at AS updated_at_12 , t0 . locale AS locale_13 , t0 . translatable_id AS translatable_id_14 FROM media_translation t0 WHERE t0 . translatable_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . legends AS legends_4 , t0 . goals AS goals_5 , t0 . more AS more_6 , t0 . scenario AS scenario_7 , t0 . features AS features_8 , t0 . published_at AS published_at_9 , t0 . status AS status_10 , t0 . created_at AS created_at_11 , t0 . updated_at AS updated_at_12 , t0 . locale AS locale_13 , t0 . translatable_id AS translatable_id_14 FROM media_translation t0 WHERE t0 . translatable_id = 208 ;
Copy
3
2.28 ms
SELECT t0 . id AS id_1 , t0 . position AS position_2 , t0 . node_id AS node_id_3 , t0 . media_id AS media_id_4 FROM node_media t0 WHERE t0 . media_id = ?
SELECT t0 . id AS id_1 , t0 . position AS position_2 , t0 . node_id AS node_id_3 , t0 . media_id AS media_id_4 FROM node_media t0 WHERE t0 . media_id = 208 ;
Copy
4
2.35 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 . id = ?
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 . id = 45 ;
Copy
5
3.11 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 , n0_ . parent_id AS parent_id_9 FROM node n0_ WHERE n0_ . lft < = 157 AND n0_ . rgt > = 158 AND n0_ . root = ? ORDER BY 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 , n0_ . parent_id AS parent_id_9 FROM node n0_ WHERE n0_ . lft < = 157 AND n0_ . rgt > = 158 AND n0_ . root = 105 ORDER BY n0_ . lft ASC ;
Copy
6
1.78 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 . id = ?
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 . id = 122 ;
Copy
7
10.52 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 , n0_ . parent_id AS parent_id_9 FROM node n0_ WHERE n0_ . lft < = 65 AND n0_ . rgt > = 66 AND n0_ . root = ? ORDER BY 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 , n0_ . parent_id AS parent_id_9 FROM node n0_ WHERE n0_ . lft < = 65 AND n0_ . rgt > = 66 AND n0_ . root = 106 ORDER BY n0_ . lft ASC ;
Copy
8
1.86 ms
SELECT t0 . id AS id_1 , t0 . position AS position_2 , t0 . node_id AS node_id_3 , t0 . media_id AS media_id_4 FROM node_media t0 WHERE t0 . node_id = ? ORDER BY t0 . position ASC
SELECT t0 . id AS id_1 , t0 . position AS position_2 , t0 . node_id AS node_id_3 , t0 . media_id AS media_id_4 FROM node_media t0 WHERE t0 . node_id = 122 ORDER BY t0 . position ASC ;
Copy
9
1.60 ms
SELECT m0_ . id AS id_0 , m0_ . type AS type_1 , m0_ . is_wide AS is_wide_2 , m0_ . thumbnail_name AS thumbnail_name_3 , m0_ . thumbnail_background AS thumbnail_background_4 , m0_ . project_id AS project_id_5 , m0_ . is_expert AS is_expert_6 , m0_ . created_at AS created_at_7 , m0_ . updated_at AS updated_at_8 FROM media m0_ WHERE m0_ . id IN (? , ? , ? , ? , ? , ? )
Parameters :
[
562
620
8
163
672
708
]
SELECT m0_ . id AS id_0 , m0_ . type AS type_1 , m0_ . is_wide AS is_wide_2 , m0_ . thumbnail_name AS thumbnail_name_3 , m0_ . thumbnail_background AS thumbnail_background_4 , m0_ . project_id AS project_id_5 , m0_ . is_expert AS is_expert_6 , m0_ . created_at AS created_at_7 , m0_ . updated_at AS updated_at_8 FROM media m0_ WHERE m0_ . id IN (562 , 620 , 8 , 163 , 672 , 708 );
Copy
10
9.65 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 , m0_ . translatable_id AS translatable_id_13 FROM media_translation m0_ WHERE m0_ . translatable_id IN (? , ? , ? , ? , ? , ? )
Parameters :
[
562
620
8
163
672
708
]
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 , m0_ . translatable_id AS translatable_id_13 FROM media_translation m0_ WHERE m0_ . translatable_id IN (562 , 620 , 8 , 163 , 672 , 708 );
Copy
11
84.04 ms
SELECT t0_ . id AS id_0 , t0_ . name AS name_1 FROM tag t0_ INNER JOIN tagging t1_ ON t0_ . id = t1_ . tag_id AND (t1_ . resource_id = ? AND t1_ . resource_type = ? ) ORDER BY t0_ . name ASC
Parameters :
[
1004
"App\Entity\MediaTranslation:de "
]
SELECT t0_ . id AS id_0 , t0_ . name AS name_1 FROM tag t0_ INNER JOIN tagging t1_ ON t0_ . id = t1_ . tag_id AND (t1_ . resource_id = 1004 AND t1_ . resource_type = 'App\\Entity\\MediaTranslation:de' ) ORDER BY t0_ . name ASC ;
Copy
12
2.39 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 , n0_ . parent_id AS parent_id_9 FROM node n0_ WHERE n0_ . lft < = 157 AND n0_ . rgt > = 158 AND n0_ . root = ? ORDER BY 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 , n0_ . parent_id AS parent_id_9 FROM node n0_ WHERE n0_ . lft < = 157 AND n0_ . rgt > = 158 AND n0_ . root = 105 ORDER BY n0_ . lft ASC ;
Copy
13
1.80 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 , n0_ . parent_id AS parent_id_9 FROM node n0_ WHERE n0_ . lft < = 65 AND n0_ . rgt > = 66 AND n0_ . root = ? ORDER BY 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 , n0_ . parent_id AS parent_id_9 FROM node n0_ WHERE n0_ . lft < = 65 AND n0_ . rgt > = 66 AND n0_ . root = 106 ORDER BY n0_ . lft ASC ;
Copy
14
4.23 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . locale AS locale_3 , t0 . translatable_id AS translatable_id_4 FROM node_translation t0 WHERE t0 . translatable_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . locale AS locale_3 , t0 . translatable_id AS translatable_id_4 FROM node_translation t0 WHERE t0 . translatable_id = 108 ;
Copy