42.61 ms (38.45%)
1
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 :
[
6207
"App\Entity\MediaTranslation:es "
]
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 = 6207 AND t1_ . resource_type = 'App\\Entity\\MediaTranslation:es' ) ORDER BY t0_ . name ASC ;
Copy
18.77 ms (16.94%)
1
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 :
[
44
148
804
497
373
61
]
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 (44 , 148 , 804 , 497 , 373 , 61 );
Copy
18.55 ms (16.74%)
1
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 = 781 ;
Copy
11.16 ms (10.07%)
1
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
5.71 ms (5.16%)
1
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 = 781 ;
Copy
4.01 ms (3.62%)
2
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 < = 67 AND n0_ . rgt > = 68 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 < = 67 AND n0_ . rgt > = 68 AND n0_ . root = 106 ORDER BY n0_ . lft ASC ;
Copy
3.20 ms (2.88%)
2
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 = 121 ;
Copy
2.74 ms (2.47%)
1
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 = 781 ;
Copy
1.75 ms (1.58%)
1
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 = 121 ORDER BY t0 . position ASC ;
Copy
1.19 ms (1.08%)
1
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 :
[
44
148
804
497
373
61
]
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 (44 , 148 , 804 , 497 , 373 , 61 );
Copy
1.12 ms (1.01%)
1
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 < = 166 AND n0_ . rgt > = 167 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 < = 166 AND n0_ . rgt > = 167 AND n0_ . root = 105 ORDER BY n0_ . lft ASC ;
Copy