Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

3.91 ms Query time

0 Invalid entities

16 Managed entities

Queries

Group similar statements

plenary connection

#▲

Time

Info

1.20 ms

SELECT dep.AFM FROM GEDepartments dep WHERE dep.Code = ?

Parameters:

[
  "00"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  dep.AFM
FROM
  GEDepartments dep
WHERE
  dep.Code = ?

SELECT dep.AFM FROM GEDepartments dep WHERE dep.Code = '00';

#	File/Call
1	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->fetchAssociative (line 245)
3	App\Repository\Plenary\BasePlenaryRepository->getBarAssociationByCode (line 74)
4	App\Service\API\DisciplinaryCasesService->getPetitionsByField (line 80)
5	App\Service\API\DisciplinaryCasesService->getPetitionsAgainstByRegistrationNumber (line 40)
6	App\Controller\API\DisciplinaryCasesController->getPetitionsAgainstByRegistrationNumber (line 41)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 197)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

default connection

#▲

Time

Info

0.80 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.vat_number AS vat_number_3, t0.contact_info_id AS contact_info_id_4, t0.logo_id AS logo_id_5, t0.stamp_id AS stamp_id_6 FROM bar_association t0 WHERE t0.vat_number = ? ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY

Parameters:

[
  "090011035"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.vat_number AS vat_number_3,
  t0.contact_info_id AS contact_info_id_4,
  t0.logo_id AS logo_id_5,
  t0.stamp_id AS stamp_id_6
FROM
  bar_association t0
WHERE
  t0.vat_number = ?
ORDER BY
  (
    SELECT
      0
  )
OFFSET
  0
ROWS
FETCH
  NEXT 1
ROWS
  ONLY

SELECT t0.id AS id_1, t0.name AS name_2, t0.vat_number AS vat_number_3, t0.contact_info_id AS contact_info_id_4, t0.logo_id AS logo_id_5, t0.stamp_id AS stamp_id_6 FROM bar_association t0 WHERE t0.vat_number = '090011035' ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	App\Service\API\DisciplinaryCasesService->getPetitionsByField (line 96)
4	App\Service\API\DisciplinaryCasesService->getPetitionsAgainstByRegistrationNumber (line 40)
5	App\Controller\API\DisciplinaryCasesController->getPetitionsAgainstByRegistrationNumber (line 41)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 197)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

0.68 ms

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.vat_number AS vat_number_3, t0.id_card AS id_card_4, t0.client_id AS client_id_5, t0.lawyer_id AS lawyer_id_6, t0.registration_number AS registration_number_7, t0.gender AS gender_8, t0.contact_info_id AS contact_info_id_9, t0.bar_association_id AS bar_association_id_10, t0.discr FROM person t0 WHERE t0.registration_number = ? AND t0.bar_association_id = ? AND t0.discr IN ('lawyer') ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY

Parameters:

[
  "018814"
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.full_name AS full_name_2,
  t0.vat_number AS vat_number_3,
  t0.id_card AS id_card_4,
  t0.client_id AS client_id_5,
  t0.lawyer_id AS lawyer_id_6,
  t0.registration_number AS registration_number_7,
  t0.gender AS gender_8,
  t0.contact_info_id AS contact_info_id_9,
  t0.bar_association_id AS bar_association_id_10,
  t0.discr
FROM
  person t0
WHERE
  t0.registration_number = ?
  AND t0.bar_association_id = ?
  AND t0.discr IN ('lawyer')
ORDER BY
  (
    SELECT
      0
  )
OFFSET
  0
ROWS
FETCH
  NEXT 1
ROWS
  ONLY

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.vat_number AS vat_number_3, t0.id_card AS id_card_4, t0.client_id AS client_id_5, t0.lawyer_id AS lawyer_id_6, t0.registration_number AS registration_number_7, t0.gender AS gender_8, t0.contact_info_id AS contact_info_id_9, t0.bar_association_id AS bar_association_id_10, t0.discr FROM person t0 WHERE t0.registration_number = '018814' AND t0.bar_association_id = 2 AND t0.discr IN ('lawyer') ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	App\Service\API\DisciplinaryCasesService->getPetitionsByField (line 126)
4	App\Service\API\DisciplinaryCasesService->getPetitionsAgainstByRegistrationNumber (line 40)
5	App\Controller\API\DisciplinaryCasesController->getPetitionsAgainstByRegistrationNumber (line 41)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 197)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

0.75 ms

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.petition_no AS petition_no_3, t0.dummy_petition_no AS dummy_petition_no_4, t0.petition_year AS petition_year_5, t0.ex_officio AS ex_officio_6, t0.type AS type_7, t0.ex_officio_type AS ex_officio_type_8, t0.ex_officio_description AS ex_officio_description_9, t0.defendant_attorney_accepted AS defendant_attorney_accepted_10, t0.synopsis AS synopsis_11, t0.offence_start_date AS offence_start_date_12, t0.offence_end_date AS offence_end_date_13, t0.merchant_reference AS merchant_reference_14, t0.payment_completed AS payment_completed_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.created_by_admin AS created_by_admin_18, t0.statute_limitations_date AS statute_limitations_date_19, t0.assignment_date AS assignment_date_20, t0.archive_no AS archive_no_21, t0.archive_year AS archive_year_22, t0.current_state AS current_state_23, t0.amount AS amount_24, t0.receipt_no AS receipt_no_25, t0.receipt_date AS receipt_date_26, t0.plaintiff_id AS plaintiff_id_27, t0.civilian_plaintiff_id AS civilian_plaintiff_id_28, t0.defendant_id AS defendant_id_29, t0.defendant_attorney_id AS defendant_attorney_id_30, t0.petition_doc_id AS petition_doc_id_31, t0.folder_retention_id AS folder_retention_id_32, t0.initial_rapporteur_id AS initial_rapporteur_id_33, t0.preliminary_inquiry_id AS preliminary_inquiry_id_34, t0.bar_president_verdict_id AS bar_president_verdict_id_35, t0.preliminary_investigation_id AS preliminary_investigation_id_36, t0.state_council_decision_cancellation_id AS state_council_decision_cancellation_id_37, t0.bar_association_id AS bar_association_id_38, t0.petition_case_id AS petition_case_id_39 FROM petition t0 WHERE t0.defendant_id = ?

Parameters:

[
  534
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.petition_no AS petition_no_3,
  t0.dummy_petition_no AS dummy_petition_no_4,
  t0.petition_year AS petition_year_5,
  t0.ex_officio AS ex_officio_6,
  t0.type AS type_7,
  t0.ex_officio_type AS ex_officio_type_8,
  t0.ex_officio_description AS ex_officio_description_9,
  t0.defendant_attorney_accepted AS defendant_attorney_accepted_10,
  t0.synopsis AS synopsis_11,
  t0.offence_start_date AS offence_start_date_12,
  t0.offence_end_date AS offence_end_date_13,
  t0.merchant_reference AS merchant_reference_14,
  t0.payment_completed AS payment_completed_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.created_by_admin AS created_by_admin_18,
  t0.statute_limitations_date AS statute_limitations_date_19,
  t0.assignment_date AS assignment_date_20,
  t0.archive_no AS archive_no_21,
  t0.archive_year AS archive_year_22,
  t0.current_state AS current_state_23,
  t0.amount AS amount_24,
  t0.receipt_no AS receipt_no_25,
  t0.receipt_date AS receipt_date_26,
  t0.plaintiff_id AS plaintiff_id_27,
  t0.civilian_plaintiff_id AS civilian_plaintiff_id_28,
  t0.defendant_id AS defendant_id_29,
  t0.defendant_attorney_id AS defendant_attorney_id_30,
  t0.petition_doc_id AS petition_doc_id_31,
  t0.folder_retention_id AS folder_retention_id_32,
  t0.initial_rapporteur_id AS initial_rapporteur_id_33,
  t0.preliminary_inquiry_id AS preliminary_inquiry_id_34,
  t0.bar_president_verdict_id AS bar_president_verdict_id_35,
  t0.preliminary_investigation_id AS preliminary_investigation_id_36,
  t0.state_council_decision_cancellation_id AS state_council_decision_cancellation_id_37,
  t0.bar_association_id AS bar_association_id_38,
  t0.petition_case_id AS petition_case_id_39
FROM
  petition t0
WHERE
  t0.defendant_id = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.petition_no AS petition_no_3, t0.dummy_petition_no AS dummy_petition_no_4, t0.petition_year AS petition_year_5, t0.ex_officio AS ex_officio_6, t0.type AS type_7, t0.ex_officio_type AS ex_officio_type_8, t0.ex_officio_description AS ex_officio_description_9, t0.defendant_attorney_accepted AS defendant_attorney_accepted_10, t0.synopsis AS synopsis_11, t0.offence_start_date AS offence_start_date_12, t0.offence_end_date AS offence_end_date_13, t0.merchant_reference AS merchant_reference_14, t0.payment_completed AS payment_completed_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.created_by_admin AS created_by_admin_18, t0.statute_limitations_date AS statute_limitations_date_19, t0.assignment_date AS assignment_date_20, t0.archive_no AS archive_no_21, t0.archive_year AS archive_year_22, t0.current_state AS current_state_23, t0.amount AS amount_24, t0.receipt_no AS receipt_no_25, t0.receipt_date AS receipt_date_26, t0.plaintiff_id AS plaintiff_id_27, t0.civilian_plaintiff_id AS civilian_plaintiff_id_28, t0.defendant_id AS defendant_id_29, t0.defendant_attorney_id AS defendant_attorney_id_30, t0.petition_doc_id AS petition_doc_id_31, t0.folder_retention_id AS folder_retention_id_32, t0.initial_rapporteur_id AS initial_rapporteur_id_33, t0.preliminary_inquiry_id AS preliminary_inquiry_id_34, t0.bar_president_verdict_id AS bar_president_verdict_id_35, t0.preliminary_investigation_id AS preliminary_investigation_id_36, t0.state_council_decision_cancellation_id AS state_council_decision_cancellation_id_37, t0.bar_association_id AS bar_association_id_38, t0.petition_case_id AS petition_case_id_39 FROM petition t0 WHERE t0.defendant_id = 534;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 995)
2	Doctrine\ORM\EntityRepository->findBy (line 224)
3	App\Service\API\DisciplinaryCasesService->getPetitionsByField (line 147)
4	App\Service\API\DisciplinaryCasesService->getPetitionsAgainstByRegistrationNumber (line 40)
5	App\Controller\API\DisciplinaryCasesController->getPetitionsAgainstByRegistrationNumber (line 41)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 197)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

0.48 ms

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.vat_number AS vat_number_3, t0.id_card AS id_card_4, t0.client_id AS client_id_5, t0.lawyer_id AS lawyer_id_6, t0.registration_number AS registration_number_7, t0.gender AS gender_8, t0.contact_info_id AS contact_info_id_9, t0.bar_association_id AS bar_association_id_10, t0.discr FROM person t0 WHERE t0.id = ? AND t0.discr IN ('lawyer')

Parameters:

[
  535
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.full_name AS full_name_2,
  t0.vat_number AS vat_number_3,
  t0.id_card AS id_card_4,
  t0.client_id AS client_id_5,
  t0.lawyer_id AS lawyer_id_6,
  t0.registration_number AS registration_number_7,
  t0.gender AS gender_8,
  t0.contact_info_id AS contact_info_id_9,
  t0.bar_association_id AS bar_association_id_10,
  t0.discr
FROM
  person t0
WHERE
  t0.id = ?
  AND t0.discr IN ('lawyer')

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.vat_number AS vat_number_3, t0.id_card AS id_card_4, t0.client_id AS client_id_5, t0.lawyer_id AS lawyer_id_6, t0.registration_number AS registration_number_7, t0.gender AS gender_8, t0.contact_info_id AS contact_info_id_9, t0.bar_association_id AS bar_association_id_10, t0.discr FROM person t0 WHERE t0.id = 535 AND t0.discr IN ('lawyer');

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 369)
4	Proxies\__CG__\App\Entity\Common\Lawyer::Doctrine\ORM\Proxy\{closure} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Entity\Common\Lawyer->__get (line 184)
7	App\Entity\Common\Person->getFullName (line 64)
8	App\Service\API\DisciplinaryCasesService->getPetitionsByField (line 173)
9	App\Service\API\DisciplinaryCasesService->getPetitionsAgainstByRegistrationNumber (line 40)
10	App\Controller\API\DisciplinaryCasesController->getPetitionsAgainstByRegistrationNumber (line 41)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 197)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
plenary	doctrine.dbal.plenary_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\Common\AppFile	5
App\Entity\Common\ContactInfo	3
App\Entity\Petition\Petition	3
App\Entity\Common\Person	2
App\Entity\Common\CivilianUser	2
App\Entity\Common\BarAssociation	1

Entities Mapping

Class	Mapping errors
App\Entity\Common\BarAssociation	No errors.
App\Entity\Common\ContactInfo	No errors.
App\Entity\Common\AppFile	No errors.
App\Entity\Common\Person	No errors.
App\Entity\Common\Lawyer	No errors.
App\Entity\Petition\Money	No errors.
App\Entity\Petition\Receipt	No errors.
App\Entity\Petition\Petition	No errors.
App\Entity\Common\AppUser	No errors.
App\Entity\Common\CivilianUser	No errors.
App\Entity\Petition\FolderRetention	No errors.
App\Entity\Petition\CouncilMember	No errors.
App\Entity\Petition\PreliminaryInquiry	No errors.
App\Entity\Petition\PresidentVerdict	No errors.
App\Entity\Petition\PreliminaryInvestigation	No errors.
App\Entity\Petition\StateCouncilDecisionCancellation	No errors.
App\Entity\Petition\PetitionCase	No errors.

Symfony Profiler

GET https://disciplinary.dev-1.olomeleia.gr/api/petitions/against/l00018814

Configuration Settings

Theme

Page Width

Query Metrics

Queries

plenary connection

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping