Symfony Profiler

Query Metrics

9 Database Queries

6 Different statements

11.21 ms Query time

1 Invalid entities

59 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

6.38 ms
(56.91%)

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
(34.09%)

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)

0.30 ms
(2.63%)

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
(2.46%)

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.23 ms
(2.01%)

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
(1.89%)

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\DocumenteMedicale	11
App\Entity\Medic	4
App\Entity\User	4
App\Entity\Colaborare	3
App\Entity\Clinica	1

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.

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

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping