Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

4.64 ms Query time

1 Invalid entities

5 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.54 ms

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:

[
  "picpic"
]

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 = 'picpic' 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)

2.13 ms

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:

[
  3
]

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

#	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)

0.47 ms

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:

[
  3
  "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 = 3 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.50 ms

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:

[
  15
]

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

#	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\User	2
App\Entity\Clinica	1
App\Entity\Medic	1
App\Entity\Specialitate	1

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.

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

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping