Symfony Profiler

Query Metrics

61 Database Queries

10 Different statements

26.04 ms Query time

2 Invalid entities

84 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

9.14 ms
(35.12%)

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_3422eb33809ca3b0187a8cb785ccc6d8->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 117)
31	App\Controller\MedicController->list (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)

6.38 ms
(24.49%)

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"
  "prescriptie-reteta-electronica"
]

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 ('prescriptie-reteta-electronica');

#	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 89)
8	App\Controller\MedicController->list (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)

3.82 ms
(14.67%)

SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.consultatie_id AS consultatie_id_2 FROM medic m1_, review r0_ INNER JOIN consultatie c2_ ON r0_.consultatie_id = c2_.id WHERE c2_.medic_id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.rating AS rating_1,
  r0_.consultatie_id AS consultatie_id_2
FROM
  medic m1_,
  review r0_
  INNER JOIN consultatie c2_ ON r0_.consultatie_id = c2_.id
WHERE
  c2_.medic_id = ?

SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.consultatie_id AS consultatie_id_2 FROM medic m1_, review r0_ INNER JOIN consultatie c2_ ON r0_.consultatie_id = c2_.id WHERE c2_.medic_id = 4;

#	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 209)
7	App\Repository\MedicRepository->getRatings (line 187)
8	App\Repository\MedicRepository->getRating (line 91)
9	App\Controller\MedicController->list (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

3.30 ms
(12.66%)

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 INNER JOIN medic_documente_medicale ON t0.id = medic_documente_medicale.medic_id WHERE medic_documente_medicale.documente_medicale_id = ?

Parameters:

[
  14
]

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
  INNER JOIN medic_documente_medicale ON t0.id = medic_documente_medicale.medic_id
WHERE
  medic_documente_medicale.documente_medicale_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 INNER JOIN medic_documente_medicale ON t0.id = medic_documente_medicale.medic_id WHERE medic_documente_medicale.documente_medicale_id = 14;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1120)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1042)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3305)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 108)
7	Doctrine\Common\Collections\AbstractLazyCollection->containsKey (line 412)
8	Doctrine\ORM\PersistentCollection->containsKey (line 496)
9	Doctrine\ORM\PersistentCollection->offsetExists (line 1671)
10	Twig\Extension\CoreExtension::getAttribute (line 166)
11	__TwigTemplate_3422eb33809ca3b0187a8cb785ccc6d8->block_content (line 432)
12	Twig\Template->yieldBlock (line 244)
13	__TwigTemplate_c51eedb337008ede4462b47353f8b4cc->block_body (line 432)
14	Twig\Template->yieldBlock (line 117)
15	__TwigTemplate_c51eedb337008ede4462b47353f8b4cc->doDisplay (line 388)
16	Twig\Template->yield (line 54)
17	__TwigTemplate_3422eb33809ca3b0187a8cb785ccc6d8->doDisplay (line 388)
18	Twig\Template->yield (line 344)
19	Twig\Template->display (line 359)
20	Twig\Template->render (line 51)
21	Twig\TemplateWrapper->render (line 334)
22	Twig\Environment->render (line 448)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 117)
26	App\Controller\MedicController->list (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

2.12 ms
(8.16%)

SELECT t0.id AS id_1, t0.tip AS tip_2, t0.pret AS pret_3, t0.medic_id AS medic_id_4 FROM serviciu_medical t0 WHERE t0.medic_id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.tip AS tip_2,
  t0.pret AS pret_3,
  t0.medic_id AS medic_id_4
FROM
  serviciu_medical t0
WHERE
  t0.medic_id = ?

SELECT t0.id AS id_1, t0.tip AS tip_2, t0.pret AS pret_3, t0.medic_id AS medic_id_4 FROM serviciu_medical t0 WHERE t0.medic_id = 4;

#	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 1241)
9	Twig\Extension\CoreExtension::length (line 153)
10	__TwigTemplate_11a0ee036368b33c4a9d21fda6f4a94d->doDisplay (line 388)
11	Twig\Template->yield (line 298)
12	__TwigTemplate_3422eb33809ca3b0187a8cb785ccc6d8->block_content (line 432)
13	Twig\Template->yieldBlock (line 244)
14	__TwigTemplate_c51eedb337008ede4462b47353f8b4cc->block_body (line 432)
15	Twig\Template->yieldBlock (line 117)
16	__TwigTemplate_c51eedb337008ede4462b47353f8b4cc->doDisplay (line 388)
17	Twig\Template->yield (line 54)
18	__TwigTemplate_3422eb33809ca3b0187a8cb785ccc6d8->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 117)
27	App\Controller\MedicController->list (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)

0.30 ms
(1.13%)

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 93)
8	App\Controller\MedicController->list (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.28 ms
(1.06%)

SELECT t0.id AS id_1, t0.nume AS nume_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM documente_medicale t0 ORDER BY t0.nume ASC

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,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  documente_medicale t0
ORDER BY
  t0.nume ASC

SELECT t0.id AS id_1, t0.nume AS nume_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM documente_medicale t0 ORDER BY t0.nume ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 94)
4	App\Controller\MedicController->list (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.27 ms
(1.03%)

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_3422eb33809ca3b0187a8cb785ccc6d8->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 117)
27	App\Controller\MedicController->list (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)

0.23 ms
(0.86%)

SELECT m0_.judet AS judet_0 FROM medic m0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.judet AS judet_0
FROM
  medic m0_

SELECT m0_.judet AS judet_0 FROM medic m0_;

#	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 234)
7	App\Repository\MedicRepository->getJudete (line 96)
8	App\Controller\MedicController->list (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.21 ms
(0.81%)

SELECT m0_.oras AS oras_0 FROM medic m0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.oras AS oras_0
FROM
  medic m0_

SELECT m0_.oras AS oras_0 FROM medic m0_;

#	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 252)
7	App\Repository\MedicRepository->getOrase (line 102)
8	App\Controller\MedicController->list (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	11
App\Entity\User	11
App\Entity\DocumenteMedicale	11
App\Entity\Colaborare	6
App\Entity\ServiciuMedical	6
App\Entity\Clinica	3

Entities Mapping

Class	Mapping errors
App\Entity\Medic	No errors.
App\Entity\Specialitate	No errors.
App\Entity\DocumenteMedicale	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\Review	No errors.
App\Entity\Pacient	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/medici?documenteMedicale%5B0%5D=prescriptie-reteta-electronica

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping