Symfony Profiler

Query Metrics

42 Database Queries

7 Different statements

17.56 ms Query time

2 Invalid entities

70 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

8.61 ms
(49.03%)

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 55)
22	__TwigTemplate_b4328557047ad89775524088bc717d80->doDisplay (line 388)
23	Twig\Template->yield (line 54)
24	__TwigTemplate_cfde88fb0b5b9ea20158e310b6fc3132->doDisplay (line 388)
25	Twig\Template->yield (line 344)
26	Twig\Template->display (line 359)
27	Twig\Template->render (line 51)
28	Twig\TemplateWrapper->render (line 334)
29	Twig\Environment->render (line 448)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 89)
33	App\Controller\ClinicaController->single (line 181)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
36	Symfony\Component\HttpKernel\Kernel->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	require_once (line 5)

3.12 ms
(17.76%)

SELECT t0.id AS id_1, t0.denumire AS denumire_2, t0.slug AS slug_3, t0.sigla_size AS sigla_size_4, t0.sigla AS sigla_5, t0.cui AS cui_6, t0.nr_reg_comert AS nr_reg_comert_7, t0.adresa AS adresa_8, t0.oras AS oras_9, t0.judet AS judet_10, t0.telefon AS telefon_11, t0.descriere AS descriere_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.clinica_top AS clinica_top_15, t0.clinica_top_expira AS clinica_top_expira_16, t0.slogan AS slogan_17, t0.approved AS approved_18, t0.nume_societate AS nume_societate_19, t0.reprezentant AS reprezentant_20, t0.prefix_telefon AS prefix_telefon_21, t0.cui_firma AS cui_firma_22, t0.status AS status_23, t0.contract_semnat AS contract_semnat_24, t0.utilizator_id AS utilizator_id_25 FROM clinica t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "masa-tacerii"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.denumire AS denumire_2,
  t0.slug AS slug_3,
  t0.sigla_size AS sigla_size_4,
  t0.sigla AS sigla_5,
  t0.cui AS cui_6,
  t0.nr_reg_comert AS nr_reg_comert_7,
  t0.adresa AS adresa_8,
  t0.oras AS oras_9,
  t0.judet AS judet_10,
  t0.telefon AS telefon_11,
  t0.descriere AS descriere_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.clinica_top AS clinica_top_15,
  t0.clinica_top_expira AS clinica_top_expira_16,
  t0.slogan AS slogan_17,
  t0.approved AS approved_18,
  t0.nume_societate AS nume_societate_19,
  t0.reprezentant AS reprezentant_20,
  t0.prefix_telefon AS prefix_telefon_21,
  t0.cui_firma AS cui_firma_22,
  t0.status AS status_23,
  t0.contract_semnat AS contract_semnat_24,
  t0.utilizator_id AS utilizator_id_25
FROM
  clinica t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.denumire AS denumire_2, t0.slug AS slug_3, t0.sigla_size AS sigla_size_4, t0.sigla AS sigla_5, t0.cui AS cui_6, t0.nr_reg_comert AS nr_reg_comert_7, t0.adresa AS adresa_8, t0.oras AS oras_9, t0.judet AS judet_10, t0.telefon AS telefon_11, t0.descriere AS descriere_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.clinica_top AS clinica_top_15, t0.clinica_top_expira AS clinica_top_expira_16, t0.slogan AS slogan_17, t0.approved AS approved_18, t0.nume_societate AS nume_societate_19, t0.reprezentant AS reprezentant_20, t0.prefix_telefon AS prefix_telefon_21, t0.cui_firma AS cui_firma_22, t0.status AS status_23, t0.contract_semnat AS contract_semnat_24, t0.utilizator_id AS utilizator_id_25 FROM clinica t0 WHERE t0.slug = 'masa-tacerii' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 79)
4	App\Controller\ClinicaController->single (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)

3.11 ms
(17.72%)

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

Parameters:

[
  2
]

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
  clinica c1_,
  review r0_
  INNER JOIN consultatie c2_ ON r0_.consultatie_id = c2_.id
  INNER JOIN medic m3_ ON c2_.medic_id = m3_.id
WHERE
  m3_.clinica_id = ?

SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.consultatie_id AS consultatie_id_2 FROM clinica c1_, review r0_ INNER JOIN consultatie c2_ ON r0_.consultatie_id = c2_.id INNER JOIN medic m3_ ON c2_.medic_id = m3_.id WHERE m3_.clinica_id = 2;

#	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 111)
7	App\Repository\ClinicaRepository->getRatings (line 88)
8	App\Repository\ClinicaRepository->getRating (line 80)
9	App\Controller\ClinicaController->single (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)

1.11 ms
(6.34%)

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 55)
18	__TwigTemplate_b4328557047ad89775524088bc717d80->doDisplay (line 388)
19	Twig\Template->yield (line 54)
20	__TwigTemplate_cfde88fb0b5b9ea20158e310b6fc3132->doDisplay (line 388)
21	Twig\Template->yield (line 344)
22	Twig\Template->display (line 359)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 334)
25	Twig\Environment->render (line 448)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 89)
29	App\Controller\ClinicaController->single (line 181)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

0.98 ms
(5.58%)

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:

[
  14
]

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

#	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 167)
12	__TwigTemplate_cfde88fb0b5b9ea20158e310b6fc3132->block_clinica (line 432)
13	Twig\Template->yieldBlock (line 117)
14	__TwigTemplate_b4328557047ad89775524088bc717d80->block_content (line 432)
15	Twig\Template->yieldBlock (line 244)
16	__TwigTemplate_c51eedb337008ede4462b47353f8b4cc->block_body (line 432)
17	Twig\Template->yieldBlock (line 117)
18	__TwigTemplate_c51eedb337008ede4462b47353f8b4cc->doDisplay (line 388)
19	Twig\Template->yield (line 55)
20	__TwigTemplate_b4328557047ad89775524088bc717d80->doDisplay (line 388)
21	Twig\Template->yield (line 54)
22	__TwigTemplate_cfde88fb0b5b9ea20158e310b6fc3132->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 89)
31	App\Controller\ClinicaController->single (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.34 ms
(1.93%)

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.clinica_id = ? AND t0.status = ?

Parameters:

[
  2
  "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.clinica_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.clinica_id = 2 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 82)
4	App\Controller\ClinicaController->single (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.29 ms
(1.63%)

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:

[
  14
]

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

#	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 83)
9	App\Controller\ClinicaController->single (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)

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\User	12
App\Entity\Medic	11
App\Entity\Colaborare	6
App\Entity\Clinica	3
App\Entity\ServiciuMedical	2

Entities Mapping

Class	Mapping errors
App\Entity\Clinica	No errors.
App\Entity\User	No errors.
App\Entity\Medic	No errors.
App\Entity\Review	No errors.
App\Entity\Consultatie	The mappings App\Entity\Consultatie#abonament and App\Entity\Abonament#consultatii are inconsistent with each other.
App\Entity\Specialitate	No errors.
App\Entity\Colaborare	No errors.
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\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/clinica/masa-tacerii

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping