Query Metrics
12
Database Queries
2
Different statements
13.51 ms
Query time
1
Invalid entities
48
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
11.04 ms (81.73%) |
11 |
SELECT DISTINCT m0_.id AS id_0, m0_.nume AS nume_1, m0_.prenume AS prenume_2, m0_.titlul AS titlul_3, m0_.grad_profesional AS grad_profesional_4, m0_.stiinte_medicale AS stiinte_medicale_5, m0_.competente AS competente_6, m0_.cod_parafa AS cod_parafa_7, m0_.oras AS oras_8, m0_.judet AS judet_9, m0_.telefon AS telefon_10, m0_.consultatii_pentru AS consultatii_pentru_11, m0_.descriere AS descriere_12, m0_.slug AS slug_13, m0_.fotografie AS fotografie_14, m0_.fotografie_size AS fotografie_size_15, m0_.created_at AS created_at_16, m0_.updated_at AS updated_at_17, m0_.cmr AS cmr_18, m0_.asigurare_malpraxis AS asigurare_malpraxis_19, m0_.asigurare_malpraxis_expirare AS asigurare_malpraxis_expirare_20, m0_.aviz_practica AS aviz_practica_21, m0_.aviz_practica_expirare AS aviz_practica_expirare_22, m0_.loc_munca AS loc_munca_23, m0_.medic_top AS medic_top_24, m0_.medic_top_expira AS medic_top_expira_25, m0_.prefix_telefon AS prefix_telefon_26, m0_.profil_completat AS profil_completat_27, m0_.status AS status_28, m0_.contract_semnat AS contract_semnat_29, m0_.specialitate_id AS specialitate_id_30, m0_.utilizator_id AS utilizator_id_31, m0_.clinica_id AS clinica_id_32, m0_.colaborare_id AS colaborare_id_33 FROM medic m0_ LEFT JOIN specialitate s1_ ON m0_.specialitate_id = s1_.id LEFT JOIN medic_documente_medicale m3_ ON m0_.id = m3_.medic_id LEFT JOIN documente_medicale d2_ ON d2_.id = m3_.documente_medicale_id WHERE m0_.slug <> ? AND m0_.slug <> ? AND m0_.status = ? AND d2_.slug IN (?)
Parameters:
[ "" "-1" "STATUS_APROBAT" "adeverinte-medicale-pentru-scoli-gradinite" ]
|
||||||||||||||||||||||||||||
|
2.47 ms (18.27%) |
1 |
SELECT d0_.id AS id_0, d0_.nume AS nume_1, d0_.slug AS slug_2, d0_.created_at AS created_at_3, d0_.updated_at AS updated_at_4 FROM documente_medicale d0_ ORDER BY d0_.nume ASC
Parameters:
[]
|
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\DocumenteMedicale | 11 |
| App\Entity\Medic | 10 |
| App\Entity\User | 10 |
| App\Entity\Specialitate | 8 |
| App\Entity\Colaborare | 6 |
| App\Entity\Clinica | 3 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\DocumenteMedicale | No errors. |
| App\Entity\Medic | No errors. |
| App\Entity\Specialitate | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Clinica | No errors. |
| App\Entity\Colaborare | No errors. |
| App\Entity\Consultatie |
|
| App\Entity\Decont | No errors. |
| App\Entity\Program | No errors. |
| App\Entity\ServiciuMedical | No errors. |