Query Metrics

3 Database Queries
3 Different statements
8.51 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

umem connection

Time Count Info
6.91 ms
(81.21%)
1
SELECT p0_.pearl_index AS pearl_index_0, p0_.pearl_title AS pearl_title_1, p0_.pearl_author AS pearl_author_2, p0_.pearl_category AS pearl_category_3, p0_.pearl_audience AS pearl_audience_4, p0_.pearl_message AS pearl_message_5, p0_.pearl_timestamp AS pearl_timestamp_6, p0_.pearl_emailed AS pearl_emailed_7, p0_.pearl_keywords AS pearl_keywords_8, p0_.pearl_reference AS pearl_reference_9, p0_.pearl_active AS pearl_active_10, p0_.pearl_updated AS pearl_updated_11, p0_.pearl_preview AS pearl_preview_12, p0_.pearl_visualdiagnosis_flag AS pearl_visualdiagnosis_flag_13, p0_.pearl_visualdiagnosis_text AS pearl_visualdiagnosis_text_14, p0_.format AS format_15, p0_.pearl_author AS pearl_author_16, p0_.pearl_category AS pearl_category_17 FROM pearl p0_ WHERE p0_.pearl_active = 1 ORDER BY p0_.pearl_emailed DESC LIMIT 5
Parameters:
[]
1.07 ms
(12.53%)
1
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.body AS body_2, b0_.post_date AS post_date_3, b0_.posted_by AS posted_by_4, b0_.created AS created_5, b0_.created_by AS created_by_6, b0_.modified AS modified_7, b0_.modified_by AS modified_by_8, b0_.posted_by AS posted_by_9 FROM blog_post b0_ WHERE b0_.post_date <= CURRENT_DATE ORDER BY b0_.post_date DESC LIMIT 3
Parameters:
[]
0.53 ms
(6.26%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.body AS body_4, t0.sidebar AS sidebar_5, t0.publish AS publish_6, t0.authors AS authors_7, t0.url_slug AS url_slug_8, t0.created_by AS created_by_9, t0.created AS created_10, t0.updated_by AS updated_by_11, t0.updated AS updated_12, t0.alternate_template AS alternate_template_13, t0.secure AS secure_14 FROM dynamic_content t0 WHERE t0.url_slug = ? LIMIT 1
Parameters:
[
  "department/chairmans_welcome"
]

Database Connections

Name Service
umem doctrine.dbal.umem_connection
mailman doctrine.dbal.mailman_connection
moodle doctrine.dbal.moodle_connection
fabric doctrine.dbal.fabric_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
fabric doctrine.orm.fabric_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class Mapping errors
Umem\ContentBundle\Entity\DynamicContent No errors.
Umem\ContentBundle\Entity\BlogPost No errors.
Umem\EmployeeBundle\Entity\Employee No errors.
Umem\PearlBundle\Entity\Pearl No errors.
Umem\PearlBundle\Entity\PearlCategory No errors.
Umem\PearlBundle\Entity\PearlFile No errors.

fabric entity manager

No loaded entities.