Symfony Profiler

Query Metrics

74 Database Queries

4 Different statements

18.99 ms Query time

2 Invalid entities

67 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

9.28 ms
(48.88%)

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)

8.62 ms
(45.43%)

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 = ?

Parameters:

[
  1
]

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 = ?

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 = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1928)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1869)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->count (line 45)
9	App\Menu\MenuBuilder->createMainMenu (line 39)
10	Knp\Menu\Provider\LazyProvider->get (line 26)
11	Knp\Menu\Provider\ChainProvider->get (line 43)
12	Knp\Menu\Twig\Helper->get (line 142)
13	Knp\Menu\Twig\Helper->castMenu (line 75)
14	Knp\Menu\Twig\Helper->render (line 38)
15	Knp\Menu\Twig\MenuRuntimeExtension->render (line 216)
16	__TwigTemplate_c912a6edbc664f6db522446f76b6bf5a->doDisplay (line 388)
17	Twig\Template->yield (line 204)
18	__TwigTemplate_c51eedb337008ede4462b47353f8b4cc->block_header (line 432)
19	Twig\Template->yieldBlock (line 114)
20	__TwigTemplate_c51eedb337008ede4462b47353f8b4cc->doDisplay (line 388)
21	Twig\Template->yield (line 54)
22	__TwigTemplate_f96dec883c61251e6742347f1ce7e93c->doDisplay (line 388)
23	Twig\Template->yield (line 344)
24	Twig\Template->display (line 359)
25	Twig\Template->render (line 51)
26	Twig\TemplateWrapper->render (line 334)
27	Twig\Environment->render (line 448)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 40)
31	App\Controller\SpecialitatiMedicaleController->index (line 181)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 5)

0.72 ms
(3.77%)

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)

0.37 ms
(1.93%)

SELECT t0.id AS id_1, t0.nume AS nume_2, t0.slug AS slug_3 FROM specialitate t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nume AS nume_2,
  t0.slug AS slug_3
FROM
  specialitate t0

SELECT t0.id AS id_1, t0.nume AS nume_2, t0.slug AS slug_3 FROM specialitate t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 28)
5	App\Menu\MenuBuilder->createMainMenu (line 39)
6	Knp\Menu\Provider\LazyProvider->get (line 26)
7	Knp\Menu\Provider\ChainProvider->get (line 43)
8	Knp\Menu\Twig\Helper->get (line 142)
9	Knp\Menu\Twig\Helper->castMenu (line 75)
10	Knp\Menu\Twig\Helper->render (line 38)
11	Knp\Menu\Twig\MenuRuntimeExtension->render (line 216)
12	__TwigTemplate_c912a6edbc664f6db522446f76b6bf5a->doDisplay (line 388)
13	Twig\Template->yield (line 204)
14	__TwigTemplate_c51eedb337008ede4462b47353f8b4cc->block_header (line 432)
15	Twig\Template->yieldBlock (line 114)
16	__TwigTemplate_c51eedb337008ede4462b47353f8b4cc->doDisplay (line 388)
17	Twig\Template->yield (line 54)
18	__TwigTemplate_f96dec883c61251e6742347f1ce7e93c->doDisplay (line 388)
19	Twig\Template->yield (line 344)
20	Twig\Template->display (line 359)
21	Twig\Template->render (line 51)
22	Twig\TemplateWrapper->render (line 334)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 40)
27	App\Controller\SpecialitatiMedicaleController->index (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	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	11
App\Entity\User	11
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.
App\Entity\Pacient	No errors.
App\Entity\Review	No errors.
App\Entity\PersoanaConsultatie	No errors.
App\Entity\Document	No errors.
App\Entity\ConsultDocPacient	No errors.
App\Entity\ConsultDocMedic	No errors.
App\Entity\AbonamentVoucher	No errors.
App\Entity\Voucher	No errors.
App\Entity\Abonament	No errors.
App\Entity\Factura	No errors.
App\Entity\CodAbonamentVoucher	No errors.
App\Entity\FacturaJuridica	No errors.
App\Entity\Banner	No errors.
App\Entity\Competente	The association App\Entity\Competente#medics refers to the owning side field App\Entity\Medic#competente which is not defined as association, but as field. The association App\Entity\Competente#medics refers to the owning side field App\Entity\Medic#competente which does not exist.
App\Entity\DocumentPacient	No errors.
App\Entity\InscrierePacient	No errors.
App\Entity\Menu	No errors.
App\Entity\MenuItem	No errors.
App\Entity\Page	No errors.
App\Entity\Plata	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\Slide	No errors.
App\Entity\Slider	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://www.consultatie-medicala.happy-projects.ro/specialitati-medicale

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping