Query Metrics
4
Database Queries
4
Different statements
14.92 ms
Query time
0
Invalid entities
17
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.05 ms |
SELECT s0_.id AS id_0, s0_.slug AS slug_1, s0_.hash AS hash_2, b1_.id AS id_3, b1_.creation_date AS creation_date_4, b1_.modification_date AS modification_date_5, b1_.name AS name_6, b1_.template AS template_7, b1_.type AS type_8, b1_.active AS active_9, b1_.reference_id AS reference_id_10, b1_.system_board AS system_board_11, b1_.title AS title_12, b10_.id AS id_13, b10_.reference_id AS reference_id_14, b10_.creation_date AS creation_date_15, b10_.modification_date AS modification_date_16, b10_.schedule_date AS schedule_date_17, b10_.extra_data AS extra_data_18, b11_.id AS id_19, b11_.metas AS metas_20, c12_.id AS id_21, c12_.reference_id AS reference_id_22, c12_.creation_date AS creation_date_23, c12_.scheduled_date AS scheduled_date_24, c12_.published_date AS published_date_25, c12_.event_start_date AS event_start_date_26, c12_.event_end_date AS event_end_date_27, c12_.show_on_list AS show_on_list_28, c12_.deleted AS deleted_29, s0_.content_id AS content_id_30, s0_.tag_id AS tag_id_31, s0_.section_id AS section_id_32, s0_.place_id AS place_id_33, s0_.redirect_slug_id AS redirect_slug_id_34, s0_.board_id AS board_id_35, s0_.editor_updated_id AS editor_updated_id_36, s0_.media_id AS media_id_37, s0_.legal_page_id AS legal_page_id_38, s0_.opinion_id AS opinion_id_39, s0_.person_id AS person_id_40, b1_.disc AS disc_41, b1_.published_version_id AS published_version_id_42, b1_.editor_created_id AS editor_created_id_43, b1_.editor_updated_id AS editor_updated_id_44, b1_.board_web_id AS board_web_id_45, b2_.content_id AS content_id_46, b3_.section_id AS section_id_47, b4_.tag_id AS tag_id_48, b5_.place_id AS place_id_49, b6_.media_id AS media_id_50, b7_.person_id AS person_id_51, b8_.legal_page_id AS legal_page_id_52, b9_.person_id AS person_id_53, b10_.editor_created_id AS editor_created_id_54, b10_.editor_updated_id AS editor_updated_id_55, b10_.editor_published_id AS editor_published_id_56, b10_.board_id AS board_id_57, c12_.published_version_id AS published_version_id_58, c12_.section_id AS section_id_59, c12_.place_id AS place_id_60, c12_.board_content_id AS board_content_id_61, c12_.editor_created_id AS editor_created_id_62, c12_.content_type_id AS content_type_id_63, c12_.book_id AS book_id_64, c12_.bookshelf_person AS bookshelf_person_65, c12_.board_legal_page_id AS board_legal_page_id_66 FROM slugs s0_ LEFT JOIN boards b1_ ON s0_.board_id = b1_.id LEFT JOIN board_contents b2_ ON b1_.id = b2_.id LEFT JOIN board_sections b3_ ON b1_.id = b3_.id LEFT JOIN board_tags b4_ ON b1_.id = b4_.id LEFT JOIN board_places b5_ ON b1_.id = b5_.id LEFT JOIN board_medias b6_ ON b1_.id = b6_.id LEFT JOIN board_inspirators b7_ ON b1_.id = b7_.id LEFT JOIN board_legal_pages b8_ ON b1_.id = b8_.id LEFT JOIN board_authors b9_ ON b1_.id = b9_.id LEFT JOIN board_versions b10_ ON b1_.published_version_id = b10_.id LEFT JOIN board_webs b11_ ON b1_.board_web_id = b11_.id LEFT JOIN contents c12_ ON s0_.content_id = c12_.id WHERE s0_.hash = ?
Parameters:
[
b" Îtèn”#gœÀJëü:N\x04Ö!;G"
]
|
| 2 | 12.63 ms |
SELECT t0.id AS id_1, t0.reference_id AS reference_id_2, t0.creation_date AS creation_date_3, t0.modification_date AS modification_date_4, t0.name AS name_5, t0.active AS active_6, t0.weight AS weight_7, t0.editor_updated_id AS editor_updated_id_8 FROM places t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 3 | 0.50 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.hash AS hash_3, t0.content_id AS content_id_4, t0.tag_id AS tag_id_5, t0.section_id AS section_id_6, t0.place_id AS place_id_7, t0.redirect_slug_id AS redirect_slug_id_8, t0.board_id AS board_id_9, t0.editor_updated_id AS editor_updated_id_10, t0.media_id AS media_id_11, t0.legal_page_id AS legal_page_id_12, t0.opinion_id AS opinion_id_13, t0.person_id AS person_id_14 FROM slugs t0 WHERE t0.id = ?
Parameters:
[
64174
]
|
| 4 | 0.74 ms |
SELECT t0.id AS id_9, t0.creation_date AS creation_date_10, t0.modification_date AS modification_date_11, t0.name AS name_12, t0.template AS template_13, t0.type AS type_14, t0.active AS active_15, t0.reference_id AS reference_id_16, t0.system_board AS system_board_17, t0.title AS title_18, t0.published_version_id AS published_version_id_19, t0.editor_created_id AS editor_created_id_20, t0.editor_updated_id AS editor_updated_id_21, t0.board_web_id AS board_web_id_22, t0.disc, t1.content_id AS content_id_23, t2.section_id AS section_id_24, t3.tag_id AS tag_id_25, t4.place_id AS place_id_26, t5.media_id AS media_id_27, t6.person_id AS person_id_28, t7.legal_page_id AS legal_page_id_29, t8.person_id AS person_id_30 FROM boards t0 LEFT JOIN board_contents t1 ON t0.id = t1.id LEFT JOIN board_sections t2 ON t0.id = t2.id LEFT JOIN board_tags t3 ON t0.id = t3.id LEFT JOIN board_places t4 ON t0.id = t4.id LEFT JOIN board_medias t5 ON t0.id = t5.id LEFT JOIN board_inspirators t6 ON t0.id = t6.id LEFT JOIN board_legal_pages t7 ON t0.id = t7.id LEFT JOIN board_authors t8 ON t0.id = t8.id WHERE t0.id = ?
Parameters:
[
80649
]
|
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\Admin\Sonata\UserBundle\Entity\User | 3 |
| Camus\ModelBundle\Entity\Board\Slug | 2 |
| Camus\ModelBundle\Entity\Board\Board | 2 |
| Camus\ModelBundle\Entity\Board\BoardVersion | 2 |
| Camus\ModelBundle\Entity\Board\BoardWeb | 2 |
| Camus\ModelBundle\Entity\Place | 2 |
| App\Entity\Content | 1 |
| App\Entity\Version | 1 |
| Camus\ModelBundle\Entity\Section | 1 |
| Camus\ModelBundle\Entity\ContentType | 1 |