Query Metrics
8
Database Queries
4
Different statements
2.66 ms
Query time
1
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.29 ms |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.content AS content_2, a0_.excerpt AS excerpt_3, a0_.created_at AS created_at_4, a0_.translation AS translation_5, a0_.slug AS slug_6, a0_.status AS status_7, a0_.subtitle AS subtitle_8, a0_.review AS review_9, a0_.front_image AS front_image_10, a0_.picture AS picture_11, a0_.photo_auteur_id AS photo_auteur_id_12, a0_.image_avant_id AS image_avant_id_13 FROM article a0_ WHERE a0_.status = 'a:1:{s:9:\"published\";i:1;}'
Parameters:
[] |
2 | 0.52 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_article ON t0.id = media_article.media_id WHERE media_article.article_id = ?
Parameters:
[
19
]
|
3 | 0.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_article ON t0.id = media_article.media_id WHERE media_article.article_id = ?
Parameters:
[
57
]
|
4 | 0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_article ON t0.id = media_article.media_id WHERE media_article.article_id = ?
Parameters:
[
58
]
|
5 | 0.70 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.status AS status_3, c0_.created_at AS created_at_4, a1_.id AS id_5, a1_.title AS title_6, a1_.content AS content_7, a1_.excerpt AS excerpt_8, a1_.created_at AS created_at_9, a1_.translation AS translation_10, a1_.slug AS slug_11, a1_.status AS status_12, a1_.subtitle AS subtitle_13, a1_.review AS review_14, a1_.front_image AS front_image_15, a1_.picture AS picture_16, c0_.parent_id AS parent_id_17, a1_.photo_auteur_id AS photo_auteur_id_18, a1_.image_avant_id AS image_avant_id_19 FROM category c0_ INNER JOIN category_article c2_ ON c0_.id = c2_.category_id INNER JOIN article a1_ ON a1_.id = c2_.article_id WHERE c0_.status = 'a:1:{s:9:\"published\";i:1;}'
Parameters:
[] |
6 | 0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN category_article ON t0.id = category_article.category_id WHERE category_article.article_id = ?
Parameters:
[
19
]
|
7 | 0.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN category_article ON t0.id = category_article.category_id WHERE category_article.article_id = ?
Parameters:
[
57
]
|
8 | 0.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN category_article ON t0.id = category_article.category_id WHERE category_article.article_id = ?
Parameters:
[
58
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Article | No errors. |
App\Entity\Media | No errors. |
App\Entity\Comment | No errors. |
App\Entity\User |
|
App\Entity\Institution | No errors. |
App\Entity\Lab | No errors. |
App\Entity\License | No errors. |
App\Entity\Software | No errors. |
App\Entity\Training | No errors. |
App\Entity\Team | No errors. |
App\Entity\Page | No errors. |
App\Entity\Category | No errors. |
App\Entity\Keyword | No errors. |
App\Entity\Tag | No errors. |