Symfony Profiler

Query Metrics

49 Database Queries

4 Different statements

24.43 ms Query time

2 Invalid entities

78 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

11.04 ms
(45.18%)

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"
]

View formatted query View runnable query Explain query View query backtrace

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 (?)

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 <> '-1' AND m0_.status = 'STATUS_APROBAT' AND d2_.slug IN ('adeverinte-medicale-pentru-scoli-gradinite');

#	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 104)
7	App\Repository\MedicRepository->filterMedici (line 27)
8	App\Controller\DocumenteMedicaleController->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)

10.44 ms
(42.71%)

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_eb45371f49a7b38f9d366f7b10b7a9aa->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 36)
31	App\Controller\DocumenteMedicaleController->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)

2.47 ms
(10.10%)

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:

[]

View formatted query View runnable query Explain query View query backtrace

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

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;

#	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\DocumenteMedicaleRepository->findAllOrderedByName (line 21)
8	App\Controller\DocumenteMedicaleController->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.49 ms
(2.01%)

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_eb45371f49a7b38f9d366f7b10b7a9aa->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 36)
27	App\Controller\DocumenteMedicaleController->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\DocumenteMedicale	11
App\Entity\Medic	11
App\Entity\User	11
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	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\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/documente-medicale

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping