Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

4.28 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.97 ms
(46.18%)

SELECT DISTINCT id_4 FROM (SELECT DISTINCT id_4 FROM (SELECT c0_.active AS active_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.deleted_at AS deleted_at_3, c0_.id AS id_4, c0_.name AS name_5, c0_.manager_name AS manager_name_6, c0_.manager_photo_file_name AS manager_photo_file_name_7, c0_.on_website AS on_website_8, c0_.email AS email_9, c0_.phone AS phone_10, c0_.address1 AS address1_11, c0_.address2 AS address2_12, c0_.zipcode AS zipcode_13, c0_.city AS city_14, c0_.rcs_number AS rcs_number_15, c0_.tva_number AS tva_number_16, c0_.creditor_id AS creditor_id_17, c0_.pdf_footer AS pdf_footer_18, c0_.sms_token AS sms_token_19, c0_.mailjet_public_key AS mailjet_public_key_20, c0_.mailjet_private_key AS mailjet_private_key_21, c0_.yousign_host AS yousign_host_22, c0_.yousign_token AS yousign_token_23, c0_.url_presentation AS url_presentation_24, c0_.url_access AS url_access_25, c0_.iban AS iban_26, c0_.token AS token_27, c0_.insurance_name AS insurance_name_28, c0_.insurance_policy AS insurance_policy_29, c0_.insurance_price AS insurance_price_30 FROM center c0_ WHERE c0_.deleted_at IS NULL) dctrn_result_inner ORDER BY id_4 ASC) dctrn_result LIMIT 1000

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_4
FROM
  (
    SELECT
      DISTINCT id_4
    FROM
      (
        SELECT
          c0_.active AS active_0,
          c0_.created_at AS created_at_1,
          c0_.updated_at AS updated_at_2,
          c0_.deleted_at AS deleted_at_3,
          c0_.id AS id_4,
          c0_.name AS name_5,
          c0_.manager_name AS manager_name_6,
          c0_.manager_photo_file_name AS manager_photo_file_name_7,
          c0_.on_website AS on_website_8,
          c0_.email AS email_9,
          c0_.phone AS phone_10,
          c0_.address1 AS address1_11,
          c0_.address2 AS address2_12,
          c0_.zipcode AS zipcode_13,
          c0_.city AS city_14,
          c0_.rcs_number AS rcs_number_15,
          c0_.tva_number AS tva_number_16,
          c0_.creditor_id AS creditor_id_17,
          c0_.pdf_footer AS pdf_footer_18,
          c0_.sms_token AS sms_token_19,
          c0_.mailjet_public_key AS mailjet_public_key_20,
          c0_.mailjet_private_key AS mailjet_private_key_21,
          c0_.yousign_host AS yousign_host_22,
          c0_.yousign_token AS yousign_token_23,
          c0_.url_presentation AS url_presentation_24,
          c0_.url_access AS url_access_25,
          c0_.iban AS iban_26,
          c0_.token AS token_27,
          c0_.insurance_name AS insurance_name_28,
          c0_.insurance_policy AS insurance_policy_29,
          c0_.insurance_price AS insurance_price_30
        FROM
          center c0_
        WHERE
          c0_.deleted_at IS NULL
      ) dctrn_result_inner
    ORDER BY
      id_4 ASC
  ) dctrn_result
LIMIT
  1000

SELECT DISTINCT id_4 FROM (SELECT DISTINCT id_4 FROM (SELECT c0_.active AS active_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.deleted_at AS deleted_at_3, c0_.id AS id_4, c0_.name AS name_5, c0_.manager_name AS manager_name_6, c0_.manager_photo_file_name AS manager_photo_file_name_7, c0_.on_website AS on_website_8, c0_.email AS email_9, c0_.phone AS phone_10, c0_.address1 AS address1_11, c0_.address2 AS address2_12, c0_.zipcode AS zipcode_13, c0_.city AS city_14, c0_.rcs_number AS rcs_number_15, c0_.tva_number AS tva_number_16, c0_.creditor_id AS creditor_id_17, c0_.pdf_footer AS pdf_footer_18, c0_.sms_token AS sms_token_19, c0_.mailjet_public_key AS mailjet_public_key_20, c0_.mailjet_private_key AS mailjet_private_key_21, c0_.yousign_host AS yousign_host_22, c0_.yousign_token AS yousign_token_23, c0_.url_presentation AS url_presentation_24, c0_.url_access AS url_access_25, c0_.iban AS iban_26, c0_.token AS token_27, c0_.insurance_name AS insurance_name_28, c0_.insurance_policy AS insurance_policy_29, c0_.insurance_price AS insurance_price_30 FROM center c0_ WHERE c0_.deleted_at IS NULL) dctrn_result_inner ORDER BY id_4 ASC) dctrn_result LIMIT 1000;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 127)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 86)
8	App\Repository\CrudRepository->getAll (line 38)
9	App\Manager\CenterManager->getDefaultCenter (line 33)
10	App\Manager\CenterManager->getCurrentCenter (line 413)
11	App\Service\MailjetService->isConfigured (line 30)
12	App\Controller\SecurityController->login (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

1.16 ms
(27.22%)

SELECT c0_.active AS active_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.deleted_at AS deleted_at_3, c0_.id AS id_4, c0_.name AS name_5, c0_.manager_name AS manager_name_6, c0_.manager_photo_file_name AS manager_photo_file_name_7, c0_.on_website AS on_website_8, c0_.email AS email_9, c0_.phone AS phone_10, c0_.address1 AS address1_11, c0_.address2 AS address2_12, c0_.zipcode AS zipcode_13, c0_.city AS city_14, c0_.rcs_number AS rcs_number_15, c0_.tva_number AS tva_number_16, c0_.creditor_id AS creditor_id_17, c0_.pdf_footer AS pdf_footer_18, c0_.sms_token AS sms_token_19, c0_.mailjet_public_key AS mailjet_public_key_20, c0_.mailjet_private_key AS mailjet_private_key_21, c0_.yousign_host AS yousign_host_22, c0_.yousign_token AS yousign_token_23, c0_.url_presentation AS url_presentation_24, c0_.url_access AS url_access_25, c0_.iban AS iban_26, c0_.token AS token_27, c0_.insurance_name AS insurance_name_28, c0_.insurance_policy AS insurance_policy_29, c0_.insurance_price AS insurance_price_30 FROM center c0_ WHERE c0_.deleted_at IS NULL AND c0_.id IN (?, ?) ORDER BY c0_.id ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.active AS active_0,
  c0_.created_at AS created_at_1,
  c0_.updated_at AS updated_at_2,
  c0_.deleted_at AS deleted_at_3,
  c0_.id AS id_4,
  c0_.name AS name_5,
  c0_.manager_name AS manager_name_6,
  c0_.manager_photo_file_name AS manager_photo_file_name_7,
  c0_.on_website AS on_website_8,
  c0_.email AS email_9,
  c0_.phone AS phone_10,
  c0_.address1 AS address1_11,
  c0_.address2 AS address2_12,
  c0_.zipcode AS zipcode_13,
  c0_.city AS city_14,
  c0_.rcs_number AS rcs_number_15,
  c0_.tva_number AS tva_number_16,
  c0_.creditor_id AS creditor_id_17,
  c0_.pdf_footer AS pdf_footer_18,
  c0_.sms_token AS sms_token_19,
  c0_.mailjet_public_key AS mailjet_public_key_20,
  c0_.mailjet_private_key AS mailjet_private_key_21,
  c0_.yousign_host AS yousign_host_22,
  c0_.yousign_token AS yousign_token_23,
  c0_.url_presentation AS url_presentation_24,
  c0_.url_access AS url_access_25,
  c0_.iban AS iban_26,
  c0_.token AS token_27,
  c0_.insurance_name AS insurance_name_28,
  c0_.insurance_policy AS insurance_policy_29,
  c0_.insurance_price AS insurance_price_30
FROM
  center c0_
WHERE
  c0_.deleted_at IS NULL
  AND c0_.id IN (?, ?)
ORDER BY
  c0_.id ASC

SELECT c0_.active AS active_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.deleted_at AS deleted_at_3, c0_.id AS id_4, c0_.name AS name_5, c0_.manager_name AS manager_name_6, c0_.manager_photo_file_name AS manager_photo_file_name_7, c0_.on_website AS on_website_8, c0_.email AS email_9, c0_.phone AS phone_10, c0_.address1 AS address1_11, c0_.address2 AS address2_12, c0_.zipcode AS zipcode_13, c0_.city AS city_14, c0_.rcs_number AS rcs_number_15, c0_.tva_number AS tva_number_16, c0_.creditor_id AS creditor_id_17, c0_.pdf_footer AS pdf_footer_18, c0_.sms_token AS sms_token_19, c0_.mailjet_public_key AS mailjet_public_key_20, c0_.mailjet_private_key AS mailjet_private_key_21, c0_.yousign_host AS yousign_host_22, c0_.yousign_token AS yousign_token_23, c0_.url_presentation AS url_presentation_24, c0_.url_access AS url_access_25, c0_.iban AS iban_26, c0_.token AS token_27, c0_.insurance_name AS insurance_name_28, c0_.insurance_policy AS insurance_policy_29, c0_.insurance_price AS insurance_price_30 FROM center c0_ WHERE c0_.deleted_at IS NULL AND c0_.id IN (1, 2) ORDER BY c0_.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 145)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 86)
8	App\Repository\CrudRepository->getAll (line 38)
9	App\Manager\CenterManager->getDefaultCenter (line 33)
10	App\Manager\CenterManager->getCurrentCenter (line 413)
11	App\Service\MailjetService->isConfigured (line 30)
12	App\Controller\SecurityController->login (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

1.14 ms
(26.61%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_4 FROM (SELECT c0_.active AS active_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.deleted_at AS deleted_at_3, c0_.id AS id_4, c0_.name AS name_5, c0_.manager_name AS manager_name_6, c0_.manager_photo_file_name AS manager_photo_file_name_7, c0_.on_website AS on_website_8, c0_.email AS email_9, c0_.phone AS phone_10, c0_.address1 AS address1_11, c0_.address2 AS address2_12, c0_.zipcode AS zipcode_13, c0_.city AS city_14, c0_.rcs_number AS rcs_number_15, c0_.tva_number AS tva_number_16, c0_.creditor_id AS creditor_id_17, c0_.pdf_footer AS pdf_footer_18, c0_.sms_token AS sms_token_19, c0_.mailjet_public_key AS mailjet_public_key_20, c0_.mailjet_private_key AS mailjet_private_key_21, c0_.yousign_host AS yousign_host_22, c0_.yousign_token AS yousign_token_23, c0_.url_presentation AS url_presentation_24, c0_.url_access AS url_access_25, c0_.iban AS iban_26, c0_.token AS token_27, c0_.insurance_name AS insurance_name_28, c0_.insurance_policy AS insurance_policy_29, c0_.insurance_price AS insurance_price_30 FROM center c0_ WHERE c0_.deleted_at IS NULL ORDER BY c0_.id ASC) dctrn_result) dctrn_table

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_4
    FROM
      (
        SELECT
          c0_.active AS active_0,
          c0_.created_at AS created_at_1,
          c0_.updated_at AS updated_at_2,
          c0_.deleted_at AS deleted_at_3,
          c0_.id AS id_4,
          c0_.name AS name_5,
          c0_.manager_name AS manager_name_6,
          c0_.manager_photo_file_name AS manager_photo_file_name_7,
          c0_.on_website AS on_website_8,
          c0_.email AS email_9,
          c0_.phone AS phone_10,
          c0_.address1 AS address1_11,
          c0_.address2 AS address2_12,
          c0_.zipcode AS zipcode_13,
          c0_.city AS city_14,
          c0_.rcs_number AS rcs_number_15,
          c0_.tva_number AS tva_number_16,
          c0_.creditor_id AS creditor_id_17,
          c0_.pdf_footer AS pdf_footer_18,
          c0_.sms_token AS sms_token_19,
          c0_.mailjet_public_key AS mailjet_public_key_20,
          c0_.mailjet_private_key AS mailjet_private_key_21,
          c0_.yousign_host AS yousign_host_22,
          c0_.yousign_token AS yousign_token_23,
          c0_.url_presentation AS url_presentation_24,
          c0_.url_access AS url_access_25,
          c0_.iban AS iban_26,
          c0_.token AS token_27,
          c0_.insurance_name AS insurance_name_28,
          c0_.insurance_policy AS insurance_policy_29,
          c0_.insurance_price AS insurance_price_30
        FROM
          center c0_
        WHERE
          c0_.deleted_at IS NULL
        ORDER BY
          c0_.id ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_4 FROM (SELECT c0_.active AS active_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.deleted_at AS deleted_at_3, c0_.id AS id_4, c0_.name AS name_5, c0_.manager_name AS manager_name_6, c0_.manager_photo_file_name AS manager_photo_file_name_7, c0_.on_website AS on_website_8, c0_.email AS email_9, c0_.phone AS phone_10, c0_.address1 AS address1_11, c0_.address2 AS address2_12, c0_.zipcode AS zipcode_13, c0_.city AS city_14, c0_.rcs_number AS rcs_number_15, c0_.tva_number AS tva_number_16, c0_.creditor_id AS creditor_id_17, c0_.pdf_footer AS pdf_footer_18, c0_.sms_token AS sms_token_19, c0_.mailjet_public_key AS mailjet_public_key_20, c0_.mailjet_private_key AS mailjet_private_key_21, c0_.yousign_host AS yousign_host_22, c0_.yousign_token AS yousign_token_23, c0_.url_presentation AS url_presentation_24, c0_.url_access AS url_access_25, c0_.iban AS iban_26, c0_.token AS token_27, c0_.insurance_name AS insurance_name_28, c0_.insurance_policy AS insurance_policy_29, c0_.insurance_price AS insurance_price_30 FROM center c0_ WHERE c0_.deleted_at IS NULL ORDER BY c0_.id ASC) dctrn_result) dctrn_table;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 1)
8	count (line 87)
9	App\Repository\CrudRepository->getAll (line 38)
10	App\Manager\CenterManager->getDefaultCenter (line 33)
11	App\Manager\CenterManager->getCurrentCenter (line 413)
12	App\Service\MailjetService->isConfigured (line 30)
13	App\Controller\SecurityController->login (line 181)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	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\Datable	No errors.
App\Entity\Center	No errors.
App\Entity\CenterHour	No errors.
App\Entity\CenterReview	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET https://logibox.bcubix.fr/login

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping