Query Metrics
3
Database Queries
3
Different statements
3.23 ms
Query time
0
Invalid entities
28
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.76 ms (54.33%) |
1 |
SELECT q0_.id AS id_0, q0_.name AS name_1, q0_.slug AS slug_2, q0_.chamber AS chamber_3, q0_.international_documents AS international_documents_4, q0_.ra_constitution AS ra_constitution_5, q0_.ra_criminal_code AS ra_criminal_code_6, q0_.ra_criminal_procedure_code AS ra_criminal_procedure_code_7, q0_.civil_proceedings AS civil_proceedings_8, q0_.civil_rights AS civil_rights_9, q0_.administrative_law AS administrative_law_10, q0_.administrative_proceedings AS administrative_proceedings_11, q0_.administrative_case_interim AS administrative_case_interim_12, q0_.civil_case_interim AS civil_case_interim_13, q0_.description AS description_14, q0_.status AS status_15, q0_.keywords AS keywords_16, q0_.accept_date AS accept_date_17, q0_.reject_description AS reject_description_18, q0_.created AS created_19, q0_.updated AS updated_20, q0_.position AS position_21, q0_.enabled AS enabled_22, CASE WHEN q0_.status = ? THEN 1 WHEN q0_.status = ? THEN 2 WHEN q0_.status = ? THEN 3 WHEN q0_.status = ? THEN 4 ELSE 5 END AS sclr_23, q0_.accept_or_reject_user_id AS accept_or_reject_user_id_24, q0_.author_id AS author_id_25 FROM quotes q0_ WHERE q0_.status <> ? AND q0_.chamber IN (?) ORDER BY sclr_23 ASC LIMIT 25
Parameters:
[ 4 2 3 1 5 4 ] |
|
0.83 ms (25.62%) |
1 |
SELECT count(q0_.id) AS sclr_0 FROM quotes q0_ WHERE q0_.status <> ? AND q0_.chamber IN (?)
Parameters:
[ 5 4 ] |
|
0.65 ms (20.05%) |
1 |
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.chamber_type AS chamber_type_4, u0_.show_criminal AS show_criminal_5, u0_.show_civil AS show_civil_6, u0_.show_administrative AS show_administrative_7 FROM user u0_ WHERE u0_.email = ?
Parameters:
[
"saribekuyan.meri@cassationcourt.am"
]
|
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\Entity\Quotes | 25 |
| App\Entity\User | 3 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Quotes | No errors. |
| App\Entity\QuotesLink | No errors. |