Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

5.27 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

4.07 ms

SELECT r0_.id AS id_0, r0_.code AS code_1, r0_.registration_number AS registration_number_2, r0_.status AS status_3, r0_.registered_on AS registered_on_4, r0_.categories AS categories_5, r0_.legal_name AS legal_name_6, r0_.legal_organization_form AS legal_organization_form_7, r0_.address AS address_8, r0_.city AS city_9, r0_.postcode AS postcode_10, r0_.country AS country_11, r0_.unique_identification_number AS unique_identification_number_12, r0_.bic AS bic_13, r0_.company_employee AS company_employee_14, r0_.fiscal_code AS fiscal_code_15, r0_.vat_number AS vat_number_16, r0_.official_web_page AS official_web_page_17, r0_.employment_info AS employment_info_18, r0_.effective_beneficiary AS effective_beneficiary_19, r0_.final_control_person AS final_control_person_20, r0_.privileged_info_page1 AS privileged_info_page1_21, r0_.privileged_info_page2 AS privileged_info_page2_22, r0_.privileged_info_page3 AS privileged_info_page3_23, r0_.responsible_people AS responsible_people_24, r0_.administrators AS administrators_25, r0_.reason AS reason_26, r0_.revoke_on AS revoke_on_27, r0_.registration_dates AS registration_dates_28, r0_.company_info_id AS company_info_id_29, r0_.legal_form_lookup_record_id AS legal_form_lookup_record_id_30 FROM remit_participants r0_ WHERE r0_.status IN (?) AND (r0_.categories #>> '{}') LIKE ? ORDER BY r0_.id ASC

Parameters:

[
  20
  "%gaz%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.code AS code_1,
  r0_.registration_number AS registration_number_2,
  r0_.status AS status_3,
  r0_.registered_on AS registered_on_4,
  r0_.categories AS categories_5,
  r0_.legal_name AS legal_name_6,
  r0_.legal_organization_form AS legal_organization_form_7,
  r0_.address AS address_8,
  r0_.city AS city_9,
  r0_.postcode AS postcode_10,
  r0_.country AS country_11,
  r0_.unique_identification_number AS unique_identification_number_12,
  r0_.bic AS bic_13,
  r0_.company_employee AS company_employee_14,
  r0_.fiscal_code AS fiscal_code_15,
  r0_.vat_number AS vat_number_16,
  r0_.official_web_page AS official_web_page_17,
  r0_.employment_info AS employment_info_18,
  r0_.effective_beneficiary AS effective_beneficiary_19,
  r0_.final_control_person AS final_control_person_20,
  r0_.privileged_info_page1 AS privileged_info_page1_21,
  r0_.privileged_info_page2 AS privileged_info_page2_22,
  r0_.privileged_info_page3 AS privileged_info_page3_23,
  r0_.responsible_people AS responsible_people_24,
  r0_.administrators AS administrators_25,
  r0_.reason AS reason_26,
  r0_.revoke_on AS revoke_on_27,
  r0_.registration_dates AS registration_dates_28,
  r0_.company_info_id AS company_info_id_29,
  r0_.legal_form_lookup_record_id AS legal_form_lookup_record_id_30
FROM
  remit_participants r0_
WHERE
  r0_.status IN (?)
  AND (
    r0_.categories #>> '{}') LIKE ? ORDER BY r0_.id ASC
WARNING: unclosed parentheses or section

SELECT r0_.id AS id_0, r0_.code AS code_1, r0_.registration_number AS registration_number_2, r0_.status AS status_3, r0_.registered_on AS registered_on_4, r0_.categories AS categories_5, r0_.legal_name AS legal_name_6, r0_.legal_organization_form AS legal_organization_form_7, r0_.address AS address_8, r0_.city AS city_9, r0_.postcode AS postcode_10, r0_.country AS country_11, r0_.unique_identification_number AS unique_identification_number_12, r0_.bic AS bic_13, r0_.company_employee AS company_employee_14, r0_.fiscal_code AS fiscal_code_15, r0_.vat_number AS vat_number_16, r0_.official_web_page AS official_web_page_17, r0_.employment_info AS employment_info_18, r0_.effective_beneficiary AS effective_beneficiary_19, r0_.final_control_person AS final_control_person_20, r0_.privileged_info_page1 AS privileged_info_page1_21, r0_.privileged_info_page2 AS privileged_info_page2_22, r0_.privileged_info_page3 AS privileged_info_page3_23, r0_.responsible_people AS responsible_people_24, r0_.administrators AS administrators_25, r0_.reason AS reason_26, r0_.revoke_on AS revoke_on_27, r0_.registration_dates AS registration_dates_28, r0_.company_info_id AS company_info_id_29, r0_.legal_form_lookup_record_id AS legal_form_lookup_record_id_30 FROM remit_participants r0_ WHERE r0_.status IN (20) AND (r0_.categories #>> '{}') LIKE '%gaz%' ORDER BY r0_.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 61)
6	App\Controller\Public\StaticPageController->registry (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

1.20 ms

SELECT t0.id AS id_1, t0.doc_type AS doc_type_2, t0.path AS path_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.verified_status AS verified_status_6, t0.verified_at AS verified_at_7, t0.presented_at AS presented_at_8, t0.signed AS signed_9, t0.signed_at AS signed_at_10, t0.signed_by AS signed_by_11, t0.application_id AS application_id_12, t0.participant_id AS participant_id_13, t0.verified_by_id AS verified_by_id_14, t0.presented_to_id AS presented_to_id_15 FROM remit_applications_documents t0 WHERE t0.participant_id IN (NULL) AND t0.doc_type IN (?, ?) ORDER BY t0.id DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.doc_type AS doc_type_2,
  t0.path AS path_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.verified_status AS verified_status_6,
  t0.verified_at AS verified_at_7,
  t0.presented_at AS presented_at_8,
  t0.signed AS signed_9,
  t0.signed_at AS signed_at_10,
  t0.signed_by AS signed_by_11,
  t0.application_id AS application_id_12,
  t0.participant_id AS participant_id_13,
  t0.verified_by_id AS verified_by_id_14,
  t0.presented_to_id AS presented_to_id_15
FROM
  remit_applications_documents t0
WHERE
  t0.participant_id IN (NULL)
  AND t0.doc_type IN (?, ?)
ORDER BY
  t0.id DESC

SELECT t0.id AS id_1, t0.doc_type AS doc_type_2, t0.path AS path_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.verified_status AS verified_status_6, t0.verified_at AS verified_at_7, t0.presented_at AS presented_at_8, t0.signed AS signed_9, t0.signed_at AS signed_at_10, t0.signed_by AS signed_by_11, t0.application_id AS application_id_12, t0.participant_id AS participant_id_13, t0.verified_by_id AS verified_by_id_14, t0.presented_to_id AS presented_to_id_15 FROM remit_applications_documents t0 WHERE t0.participant_id IN (NULL) AND t0.doc_type IN (5, 4) ORDER BY t0.id DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 66)
4	App\Controller\Public\StaticPageController->registry (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)

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.

Entities Mapping

Class	Mapping errors
App\Entity\Participant	No errors.
App\Entity\Customer\AbstractCustomerInfo	No errors.
App\Entity\Customer\CompanyInfo	No errors.
SoneroCOM\MConnectBundle\Entity\Record	No errors.
App\Entity\Application\ApplicationDocument	No errors.
App\Entity\Application\AbstractApplication	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET http://remit.sonero-com.com/en/pages/registry?category=gaz

Configuration Settings

Theme