GET http://stage-mx.librotea.com/aviso-legal

Query Metrics

4 Database Queries
3 Different statements
6.40 ms Query time
0 Invalid entities
10 Managed entities

Queries

Group similar statements

# Time Info
1 3.27 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"G~òõy®\eXªç—õD\x1Dâ5š÷·\v"
]
2 0.59 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
]
3 1.82 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"W\x11¶,åÂC@5PHƒ3NðñÔ;Ó2"
]
4 0.71 ms
SELECT p0_.id AS id_0, p0_.reference_id AS reference_id_1, p0_.creation_date AS creation_date_2, p0_.modification_date AS modification_date_3, p0_.name AS name_4, p0_.active AS active_5, p0_.weight AS weight_6, p0_.editor_updated_id AS editor_updated_id_7 FROM places p0_, slugs s1_ LEFT JOIN places p2_ ON s1_.place_id = p2_.id LEFT JOIN contents c3_ ON s1_.content_id = c3_.id LEFT JOIN places p4_ ON c3_.place_id = p4_.id LEFT JOIN medias m5_ ON s1_.media_id = m5_.id LEFT JOIN places p6_ ON m5_.place_id = p6_.id WHERE s1_.hash = ? AND (p2_.id = p0_.id OR p4_.id = p0_.id OR p6_.id = p0_.id)
Parameters:
[
  b"G~òõy®\eXªç—õD\x1Dâ5š÷·\v"
]

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 2
Camus\ModelBundle\Entity\Board\Slug 1
Camus\ModelBundle\Entity\Board\Board 1
App\Entity\Content 1
Camus\ModelBundle\Entity\Board\BoardVersion 1
Camus\ModelBundle\Entity\Board\BoardWeb 1
App\Entity\Version 1
Camus\ModelBundle\Entity\Place 1
Camus\ModelBundle\Entity\ContentType 1

Entities Mapping

Class Mapping errors
Camus\AdBundle\Entity\AdSpace No errors.
Camus\ModelBundle\Entity\Board\Slug No errors.
Camus\ModelBundle\Entity\Board\Board No errors.
Camus\ModelBundle\Entity\Board\BoardVersion No errors.
Camus\ModelBundle\Entity\Board\BoardWeb No errors.
Camus\ModelBundle\Entity\BaseContent No errors.
App\Entity\Content No errors.
Camus\ModelBundle\Entity\Board\BoardContent No errors.
Camus\ModelBundle\Entity\Board\BoardSection No errors.
Camus\ModelBundle\Entity\Board\BoardTag No errors.
Camus\ModelBundle\Entity\Board\BoardPlace No errors.
Camus\ModelBundle\Entity\Board\BoardMedia No errors.
Camus\ModelBundle\Entity\Board\BoardInspirator No errors.
Camus\ModelBundle\Entity\Board\BoardLegalPage No errors.
Camus\ModelBundle\Entity\Board\BoardAuthor No errors.
Camus\ModelBundle\Entity\Tag No errors.
Camus\ModelBundle\Entity\Section No errors.
Camus\ModelBundle\Entity\Place No errors.
App\Admin\Sonata\UserBundle\Entity\User No errors.
Camus\MediaBundle\Entity\Media No errors.
Camus\ModelBundle\Entity\LegalPage No errors.
App\Entity\Opinion No errors.
Camus\ModelBundle\Entity\Person No errors.
App\Entity\Person No errors.
Camus\ModelBundle\Entity\BaseVersion No errors.
App\Entity\Version No errors.
Camus\ModelBundle\Entity\ContentType No errors.
App\Entity\Book No errors.
Camus\ModelBundle\Entity\Board\Module No errors.
Camus\ModelBundle\Entity\Keyword No errors.
Camus\ModelBundle\Entity\ContentHasContent No errors.
Camus\ModelBundle\Entity\ContentHasTag No errors.
Camus\ModelBundle\Entity\ContentHasKeyword No errors.
Camus\ModelBundle\Entity\ContentHasTrackingTag No errors.
Camus\ModelBundle\Entity\ContentHasNewsEvent No errors.
Camus\MediaBundle\Entity\ContentHasMedia No errors.
Camus\ModelBundle\Entity\PersonHasPlaces No errors.