Query Metrics
1
Database Queries
1
Different statements
8.55 ms
Query time
0
Invalid entities
5
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 8.55 ms |
SELECT p0_.title AS title_0, p0_.status AS status_1, p0_.published AS published_2, p0_.content AS content_3, p0_.id AS id_4, p0_.idnum AS idnum_5, p0_.enabled AS enabled_6, p0_.slug AS slug_7, p0_.created AS created_8, p0_.updated AS updated_9, p0_.file_name AS file_name_10, p0_.file_url AS file_url_11, p0_.title AS title_12, p0_.status AS status_13, p0_.published AS published_14, p0_.content AS content_15, p0_.id AS id_16, p0_.idnum AS idnum_17, p0_.enabled AS enabled_18, p0_.slug AS slug_19, p0_.created AS created_20, p0_.updated AS updated_21, p0_.file_name AS file_name_22, p0_.file_url AS file_url_23, p1_.name AS name_24, p1_.id AS id_25, p1_.idnum AS idnum_26, p1_.enabled AS enabled_27, p1_.slug AS slug_28, p2_.id AS id_29, p2_.idnum AS idnum_30, p2_.enabled AS enabled_31, p2_.fullname AS fullname_32, p2_.slug AS slug_33, p3_.status AS status_34, p3_.created AS created_35, p3_.published AS published_36, p3_.token AS token_37, p3_.content AS content_38, p3_.id AS id_39, p3_.idnum AS idnum_40, p3_.enabled AS enabled_41, p3_.email AS email_42, p3_.fullname AS fullname_43, t4_.name AS name_44, t4_.scopes AS scopes_45, t4_.id AS id_46, t4_.idnum AS idnum_47, t4_.enabled AS enabled_48, t4_.slug AS slug_49, p0_.category_id AS category_id_50, p0_.author_id AS author_id_51, p3_.post_id AS post_id_52 FROM post p0_ LEFT JOIN post_category p1_ ON p0_.category_id = p1_.id LEFT JOIN post_author p2_ ON p0_.author_id = p2_.id LEFT JOIN post_comment p3_ ON p0_.id = p3_.post_id LEFT JOIN post_tag p5_ ON p0_.id = p5_.post_id LEFT JOIN tag t4_ ON t4_.id = p5_.tag_id WHERE p0_.slug = ? AND p0_.enabled = ? ORDER BY p3_.published DESC
Parameters:
[ "powerpoint-creer-des-presentations-qui-marquent-les-esprits" 1 ]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Setting\Tag | 2 |
| App\Entity\Blog\Post | 1 |
| App\Entity\Blog\PostCategory | 1 |
| App\Entity\Blog\PostAuthor | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Blog\Post | No errors. |
| App\Entity\Blog\PostCategory | No errors. |
| App\Entity\Blog\PostAuthor | No errors. |
| App\Entity\Blog\PostComment | No errors. |
| App\Entity\Setting\Tag | No errors. |
| App\Entity\Training\Training | No errors. |