Query Metrics
19
Database Queries
10
Different statements
17.46 ms
Query time
1
Invalid entities
33
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.58 ms |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.name_normalized AS name_normalized_2, t0_.creation_date AS creation_date_3, t0_.from_section AS from_section_4, t0_.reference_id AS reference_id_5, t0_.editor_created_id AS editor_created_id_6, t0_.editor_updated_id AS editor_updated_id_7 FROM tags t0_ INNER JOIN slugs s1_ ON t0_.id = s1_.tag_id WHERE s1_.hash = ?
Parameters:
[
b"\x16{ײš¯þ0=\x18뫤G€”¯Š¢å"
]
|
| 2 | 0.79 ms |
SELECT DISTINCT s0_.id AS id_0 FROM slugs s0_ INNER JOIN contents c1_ ON s0_.content_id = c1_.id INNER JOIN content_has_tags c2_ ON c1_.id = c2_.content_id INNER JOIN tags t3_ ON c2_.tag_id = t3_.id WHERE t3_.id = ? LIMIT 100
Parameters:
[
37
]
|
| 3 | 1.60 ms |
SELECT s0_.id AS id_0, s0_.slug AS slug_1, s0_.hash AS hash_2, c1_.id AS id_3, c1_.reference_id AS reference_id_4, c1_.creation_date AS creation_date_5, c1_.scheduled_date AS scheduled_date_6, c1_.published_date AS published_date_7, c1_.event_start_date AS event_start_date_8, c1_.event_end_date AS event_end_date_9, c1_.show_on_list AS show_on_list_10, c1_.deleted AS deleted_11, v2_.id AS id_12, v2_.creation_date AS creation_date_13, v2_.title AS title_14, v2_.subtitle AS subtitle_15, v2_.short_title AS short_title_16, v2_.summary AS summary_17, v2_.body AS body_18, v2_.short_piece AS short_piece_19, v2_.signature AS signature_20, v2_.signature_place AS signature_place_21, v2_.type AS type_22, v2_.kind AS kind_23, v2_.language AS language_24, s3_.id AS id_25, s3_.reference_id AS reference_id_26, s3_.creation_date AS creation_date_27, s3_.modification_date AS modification_date_28, s3_.name AS name_29, s3_.title AS title_30, s3_.active AS active_31, s0_.content_id AS content_id_32, s0_.tag_id AS tag_id_33, s0_.section_id AS section_id_34, s0_.place_id AS place_id_35, s0_.redirect_slug_id AS redirect_slug_id_36, s0_.board_id AS board_id_37, s0_.editor_updated_id AS editor_updated_id_38, s0_.media_id AS media_id_39, s0_.legal_page_id AS legal_page_id_40, s0_.opinion_id AS opinion_id_41, s0_.person_id AS person_id_42, c1_.published_version_id AS published_version_id_43, c1_.section_id AS section_id_44, c1_.place_id AS place_id_45, c1_.board_content_id AS board_content_id_46, c1_.editor_created_id AS editor_created_id_47, c1_.content_type_id AS content_type_id_48, c1_.book_id AS book_id_49, c1_.bookshelf_person AS bookshelf_person_50, c1_.board_legal_page_id AS board_legal_page_id_51, v2_.editor_created_id AS editor_created_id_52, v2_.content_id AS content_id_53, v2_.thumbnail_id AS thumbnail_id_54, s3_.editor_created_id AS editor_created_id_55, s3_.editor_updated_id AS editor_updated_id_56, s3_.parent_id AS parent_id_57 FROM slugs s0_ INNER JOIN contents c1_ ON s0_.content_id = c1_.id INNER JOIN versions v2_ ON c1_.published_version_id = v2_.id INNER JOIN sections s3_ ON c1_.section_id = s3_.id WHERE s0_.id IN (?, ?) ORDER BY c1_.published_date DESC
Parameters:
[ 797068 809240 ] |
| 4 | 0.85 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:
[
1029182
]
|
| 5 | 0.81 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:
[
1013359
]
|
| 6 | 0.54 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.creation_date AS creation_date_4, t0.updated_date AS updated_date_5 FROM content_types t0 WHERE t0.id = ?
Parameters:
[
5
]
|
| 7 | 0.85 ms |
SELECT t0.id AS id_1, t0.metas AS metas_2 FROM board_webs t0 WHERE t0.id = ?
Parameters:
[
1029311
]
|
| 8 | 0.62 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.title AS title_3, t0.media_id AS media_id_4, t0.content_id AS content_id_5, t0.media_clipping_id AS media_clipping_id_6 FROM content_has_medias t0 WHERE t0.content_id = ?
Parameters:
[
610998
]
|
| 9 | 0.61 ms |
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.normalized_name AS normalized_name_4, t0.email AS email_5, t0.biography AS biography_6, t0.weight AS weight_7, t0.full_name AS full_name_8, t0.is_inspirador AS is_inspirador_9, t0.facebook_url AS facebook_url_10, t0.linked_in_url AS linked_in_url_11, t0.x_url AS x_url_12, t0.occupation AS occupation_13, t0.editor_created_id AS editor_created_id_14, t0.editor_updated_id AS editor_updated_id_15, t0.profile_image_id AS profile_image_id_16 FROM persons t0 INNER JOIN contents_has_persons ON t0.id = contents_has_persons.persons WHERE contents_has_persons.base_contents = ?
Parameters:
[
610998
]
|
| 10 | 0.57 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.person_id = ?
Parameters:
[
4
]
|
| 11 | 0.69 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:
[
719326
]
|
| 12 | 0.53 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
]
|
| 13 | 2.04 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.creation_date AS creation_date_4, t0.updated_date AS updated_date_5 FROM content_types t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 14 | 0.73 ms |
SELECT t0.id AS id_1, t0.metas AS metas_2 FROM board_webs t0 WHERE t0.id = ?
Parameters:
[
1013485
]
|
| 15 | 2.39 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.title AS title_3, t0.media_id AS media_id_4, t0.content_id AS content_id_5, t0.media_clipping_id AS media_clipping_id_6 FROM content_has_medias t0 WHERE t0.content_id = ?
Parameters:
[
603483
]
|
| 16 | 0.75 ms |
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.normalized_name AS normalized_name_4, t0.email AS email_5, t0.biography AS biography_6, t0.weight AS weight_7, t0.full_name AS full_name_8, t0.is_inspirador AS is_inspirador_9, t0.facebook_url AS facebook_url_10, t0.linked_in_url AS linked_in_url_11, t0.x_url AS x_url_12, t0.occupation AS occupation_13, t0.editor_created_id AS editor_created_id_14, t0.editor_updated_id AS editor_updated_id_15, t0.profile_image_id AS profile_image_id_16 FROM persons t0 INNER JOIN contents_has_persons ON t0.id = contents_has_persons.persons WHERE contents_has_persons.base_contents = ?
Parameters:
[
603483
]
|
| 17 | 1.23 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.person_id = ?
Parameters:
[
3
]
|
| 18 | 0.80 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:
[
725965
]
|
| 19 | 0.48 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:
[
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\Admin\Sonata\UserBundle\Entity\User | 4 |
| Camus\ModelBundle\Entity\Board\Slug | 4 |
| Camus\ModelBundle\Entity\Board\Board | 4 |
| Camus\ModelBundle\Entity\Board\BoardVersion | 4 |
| Camus\ModelBundle\Entity\Board\BoardWeb | 4 |
| App\Entity\Content | 2 |
| Camus\ModelBundle\Entity\Place | 2 |
| Camus\ModelBundle\Entity\ContentType | 2 |
| App\Entity\Version | 2 |
| Camus\ModelBundle\Entity\Section | 2 |
| App\Entity\Person | 2 |
| Camus\ModelBundle\Entity\Tag | 1 |