Symfony Profiler

Query Metrics

37 Database Queries

2 Different statements

9.99 ms Query time

1 Invalid entities

65 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

9.28 ms
(92.85%)

SELECT t0.id AS id_1, t0.nume AS nume_2, t0.prenume AS prenume_3, t0.titlul AS titlul_4, t0.grad_profesional AS grad_profesional_5, t0.stiinte_medicale AS stiinte_medicale_6, t0.competente AS competente_7, t0.cod_parafa AS cod_parafa_8, t0.oras AS oras_9, t0.judet AS judet_10, t0.telefon AS telefon_11, t0.consultatii_pentru AS consultatii_pentru_12, t0.descriere AS descriere_13, t0.slug AS slug_14, t0.fotografie AS fotografie_15, t0.fotografie_size AS fotografie_size_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.cmr AS cmr_19, t0.asigurare_malpraxis AS asigurare_malpraxis_20, t0.asigurare_malpraxis_expirare AS asigurare_malpraxis_expirare_21, t0.aviz_practica AS aviz_practica_22, t0.aviz_practica_expirare AS aviz_practica_expirare_23, t0.loc_munca AS loc_munca_24, t0.medic_top AS medic_top_25, t0.medic_top_expira AS medic_top_expira_26, t0.prefix_telefon AS prefix_telefon_27, t0.profil_completat AS profil_completat_28, t0.status AS status_29, t0.contract_semnat AS contract_semnat_30, t0.specialitate_id AS specialitate_id_31, t0.utilizator_id AS utilizator_id_32, t0.clinica_id AS clinica_id_33, t0.colaborare_id AS colaborare_id_34 FROM medic t0 WHERE t0.specialitate_id = ? AND t0.status = ?

Parameters:

[
  41
  "STATUS_APROBAT"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nume AS nume_2,
  t0.prenume AS prenume_3,
  t0.titlul AS titlul_4,
  t0.grad_profesional AS grad_profesional_5,
  t0.stiinte_medicale AS stiinte_medicale_6,
  t0.competente AS competente_7,
  t0.cod_parafa AS cod_parafa_8,
  t0.oras AS oras_9,
  t0.judet AS judet_10,
  t0.telefon AS telefon_11,
  t0.consultatii_pentru AS consultatii_pentru_12,
  t0.descriere AS descriere_13,
  t0.slug AS slug_14,
  t0.fotografie AS fotografie_15,
  t0.fotografie_size AS fotografie_size_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.cmr AS cmr_19,
  t0.asigurare_malpraxis AS asigurare_malpraxis_20,
  t0.asigurare_malpraxis_expirare AS asigurare_malpraxis_expirare_21,
  t0.aviz_practica AS aviz_practica_22,
  t0.aviz_practica_expirare AS aviz_practica_expirare_23,
  t0.loc_munca AS loc_munca_24,
  t0.medic_top AS medic_top_25,
  t0.medic_top_expira AS medic_top_expira_26,
  t0.prefix_telefon AS prefix_telefon_27,
  t0.profil_completat AS profil_completat_28,
  t0.status AS status_29,
  t0.contract_semnat AS contract_semnat_30,
  t0.specialitate_id AS specialitate_id_31,
  t0.utilizator_id AS utilizator_id_32,
  t0.clinica_id AS clinica_id_33,
  t0.colaborare_id AS colaborare_id_34
FROM
  medic t0
WHERE
  t0.specialitate_id = ?
  AND t0.status = ?

SELECT t0.id AS id_1, t0.nume AS nume_2, t0.prenume AS prenume_3, t0.titlul AS titlul_4, t0.grad_profesional AS grad_profesional_5, t0.stiinte_medicale AS stiinte_medicale_6, t0.competente AS competente_7, t0.cod_parafa AS cod_parafa_8, t0.oras AS oras_9, t0.judet AS judet_10, t0.telefon AS telefon_11, t0.consultatii_pentru AS consultatii_pentru_12, t0.descriere AS descriere_13, t0.slug AS slug_14, t0.fotografie AS fotografie_15, t0.fotografie_size AS fotografie_size_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.cmr AS cmr_19, t0.asigurare_malpraxis AS asigurare_malpraxis_20, t0.asigurare_malpraxis_expirare AS asigurare_malpraxis_expirare_21, t0.aviz_practica AS aviz_practica_22, t0.aviz_practica_expirare AS aviz_practica_expirare_23, t0.loc_munca AS loc_munca_24, t0.medic_top AS medic_top_25, t0.medic_top_expira AS medic_top_expira_26, t0.prefix_telefon AS prefix_telefon_27, t0.profil_completat AS profil_completat_28, t0.status AS status_29, t0.contract_semnat AS contract_semnat_30, t0.specialitate_id AS specialitate_id_31, t0.utilizator_id AS utilizator_id_32, t0.clinica_id AS clinica_id_33, t0.colaborare_id AS colaborare_id_34 FROM medic t0 WHERE t0.specialitate_id = 41 AND t0.status = 'STATUS_APROBAT';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 29)
4	App\Controller\SpecialitatiMedicaleController->index (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.72 ms
(7.15%)

SELECT s0_.id AS id_0, s0_.nume AS nume_1, s0_.slug AS slug_2 FROM specialitate s0_ ORDER BY s0_.nume ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.nume AS nume_1,
  s0_.slug AS slug_2
FROM
  specialitate s0_
ORDER BY
  s0_.nume ASC

SELECT s0_.id AS id_0, s0_.nume AS nume_1, s0_.slug AS slug_2 FROM specialitate s0_ ORDER BY s0_.nume ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 29)
7	App\Repository\SpecialitateRepository->findAllOrderedByName (line 20)
8	App\Controller\SpecialitatiMedicaleController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

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\Specialitate	36
App\Entity\Medic	10
App\Entity\User	10
App\Entity\Colaborare	6
App\Entity\Clinica	3

Entities Mapping

Class	Mapping errors
App\Entity\Specialitate	No errors.
App\Entity\Medic	No errors.
App\Entity\User	No errors.
App\Entity\Clinica	No errors.
App\Entity\Colaborare	No errors.
App\Entity\Consultatie	The mappings App\Entity\Consultatie#abonament and App\Entity\Abonament#consultatii are inconsistent with each other.
App\Entity\Decont	No errors.
App\Entity\Program	No errors.
App\Entity\DocumenteMedicale	No errors.
App\Entity\ServiciuMedical	No errors.

Symfony Profiler

GET https://www.consultatie-medicala.happy-projects.ro/_fragment?_path=_format%3Dhtml%26_locale%3Dro%26_controller%3DApp%255CController%255CSearchController%253A%25…

Configuration Settings

Theme

Page Width