Query Metrics
2
Database Queries
2
Different statements
1.20 ms
Query time
0
Invalid entities
Queries
umem connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.38 ms |
SELECT t0.pearl_category_index AS pearl_category_index_1, t0.pearl_category_name AS pearl_category_name_2 FROM pearl_category t0 WHERE t0.pearl_category_index = ? LIMIT 1
Parameters:
[
"33"
]
|
| 2 | 0.82 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT pearl_index_0 FROM (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, p1_.pearl_file_index AS pearl_file_index_16, p1_.pearl_message_index AS pearl_message_index_17, p1_.pearl_file_title AS pearl_file_title_18, p1_.pearl_file_type AS pearl_file_type_19, p1_.pearl_file_size AS pearl_file_size_20, p1_.pearl_file_timestamp AS pearl_file_timestamp_21, p1_.pearl_file_location AS pearl_file_location_22, p1_.pearl_file_audience AS pearl_file_audience_23 FROM pearl p0_ LEFT JOIN pearl_file p1_ ON p0_.pearl_index = p1_.pearl_message_index WHERE p0_.pearl_active = 1 AND p0_.pearl_category = ? ORDER BY p0_.pearl_emailed DESC) dctrn_result) dctrn_table
Parameters:
[
"33"
]
|
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\PearlBundle\Entity\PearlCategory | No errors. |
| Umem\PearlBundle\Entity\Pearl | No errors. |
| Umem\PearlBundle\Entity\PearlFile | No errors. |
fabric entity manager
No loaded entities.