Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

32.74 ms Query time

0 Invalid entities

20 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.83 ms

SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.need_password_update AS need_password_update_4, t0.tryout AS tryout_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.phone AS phone_8, t0.mobile AS mobile_9, t0.image AS image_10, t0.theme AS theme_11, t0.status AS status_12, t0.last_login AS last_login_13, t0.last_activity AS last_activity_14, t0.note AS note_15, t0.acl AS acl_16, t0.widgets AS widgets_17, t0.preferences AS preferences_18, t0.notification AS notification_19, t0.id AS id_20, t0.uuid AS uuid_21, t0.company_id AS company_id_22 FROM user t0 WHERE t0.id = ?

Parameters:

[
  11
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.email AS email_1,
  t0.roles AS roles_2,
  t0.password AS password_3,
  t0.need_password_update AS need_password_update_4,
  t0.tryout AS tryout_5,
  t0.firstname AS firstname_6,
  t0.lastname AS lastname_7,
  t0.phone AS phone_8,
  t0.mobile AS mobile_9,
  t0.image AS image_10,
  t0.theme AS theme_11,
  t0.status AS status_12,
  t0.last_login AS last_login_13,
  t0.last_activity AS last_activity_14,
  t0.note AS note_15,
  t0.acl AS acl_16,
  t0.widgets AS widgets_17,
  t0.preferences AS preferences_18,
  t0.notification AS notification_19,
  t0.id AS id_20,
  t0.uuid AS uuid_21,
  t0.company_id AS company_id_22
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.need_password_update AS need_password_update_4, t0.tryout AS tryout_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.phone AS phone_8, t0.mobile AS mobile_9, t0.image AS image_10, t0.theme AS theme_11, t0.status AS status_12, t0.last_login AS last_login_13, t0.last_activity AS last_activity_14, t0.note AS note_15, t0.acl AS acl_16, t0.widgets AS widgets_17, t0.preferences AS preferences_18, t0.notification AS notification_19, t0.id AS id_20, t0.uuid AS uuid_21, t0.company_id AS company_id_22 FROM user t0 WHERE t0.id = 11;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 129)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 61)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

18.00 ms

SELECT COUNT(*) AS dctrn_count FROM (SELECT p0_.code AS code_0, p0_.display_name AS display_name_1, p0_.lwin AS lwin_2, p0_.site AS site_3, p0_.seller_price_qty AS seller_price_qty_4, p0_.price AS price_5, p0_.merged_uuids AS merged_uuids_6, p0_.has_lwin_suggests AS has_lwin_suggests_7, p0_.from_import AS from_import_8, p0_.bundle AS bundle_9, p0_.id AS id_10, p0_.uuid AS uuid_11, p0_.name AS name_12, p0_.status AS status_13 FROM product p0_ WHERE p0_.status = ? AND (p0_.name LIKE ? OR p0_.display_name LIKE ? OR p0_.code LIKE ?) GROUP BY p0_.id ORDER BY p0_.name ASC) dctrn_table

Parameters:

[
  1
  "%drc%"
  "%drc%"
  "%drc%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      p0_.code AS code_0,
      p0_.display_name AS display_name_1,
      p0_.lwin AS lwin_2,
      p0_.site AS site_3,
      p0_.seller_price_qty AS seller_price_qty_4,
      p0_.price AS price_5,
      p0_.merged_uuids AS merged_uuids_6,
      p0_.has_lwin_suggests AS has_lwin_suggests_7,
      p0_.from_import AS from_import_8,
      p0_.bundle AS bundle_9,
      p0_.id AS id_10,
      p0_.uuid AS uuid_11,
      p0_.name AS name_12,
      p0_.status AS status_13
    FROM
      product p0_
    WHERE
      p0_.status = ?
      AND (
        p0_.name LIKE ?
        OR p0_.display_name LIKE ?
        OR p0_.code LIKE ?
      )
    GROUP BY
      p0_.id
    ORDER BY
      p0_.name ASC
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT p0_.code AS code_0, p0_.display_name AS display_name_1, p0_.lwin AS lwin_2, p0_.site AS site_3, p0_.seller_price_qty AS seller_price_qty_4, p0_.price AS price_5, p0_.merged_uuids AS merged_uuids_6, p0_.has_lwin_suggests AS has_lwin_suggests_7, p0_.from_import AS from_import_8, p0_.bundle AS bundle_9, p0_.id AS id_10, p0_.uuid AS uuid_11, p0_.name AS name_12, p0_.status AS status_13 FROM product p0_ WHERE p0_.status = 1 AND (p0_.name LIKE '%drc%' OR p0_.display_name LIKE '%drc%' OR p0_.code LIKE '%drc%') GROUP BY p0_.id ORDER BY p0_.name ASC) dctrn_table;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 69)
8	Symfony\UX\Autocomplete\AutocompleteResultsExecutor->fetchResults (line 56)
9	Symfony\UX\Autocomplete\Controller\EntityAutocompleteController->__invoke (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

12.98 ms

SELECT DISTINCT id_10 FROM (SELECT DISTINCT id_10, name_12 FROM (SELECT p0_.code AS code_0, p0_.display_name AS display_name_1, p0_.lwin AS lwin_2, p0_.site AS site_3, p0_.seller_price_qty AS seller_price_qty_4, p0_.price AS price_5, p0_.merged_uuids AS merged_uuids_6, p0_.has_lwin_suggests AS has_lwin_suggests_7, p0_.from_import AS from_import_8, p0_.bundle AS bundle_9, p0_.id AS id_10, p0_.uuid AS uuid_11, p0_.name AS name_12, p0_.status AS status_13 FROM product p0_ WHERE p0_.status = ? AND (p0_.name LIKE ? OR p0_.display_name LIKE ? OR p0_.code LIKE ?) GROUP BY p0_.id) dctrn_result_inner ORDER BY name_12 ASC) dctrn_result LIMIT 10 OFFSET 10

Parameters:

[
  1
  "%drc%"
  "%drc%"
  "%drc%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_10
FROM
  (
    SELECT
      DISTINCT id_10,
      name_12
    FROM
      (
        SELECT
          p0_.code AS code_0,
          p0_.display_name AS display_name_1,
          p0_.lwin AS lwin_2,
          p0_.site AS site_3,
          p0_.seller_price_qty AS seller_price_qty_4,
          p0_.price AS price_5,
          p0_.merged_uuids AS merged_uuids_6,
          p0_.has_lwin_suggests AS has_lwin_suggests_7,
          p0_.from_import AS from_import_8,
          p0_.bundle AS bundle_9,
          p0_.id AS id_10,
          p0_.uuid AS uuid_11,
          p0_.name AS name_12,
          p0_.status AS status_13
        FROM
          product p0_
        WHERE
          p0_.status = ?
          AND (
            p0_.name LIKE ?
            OR p0_.display_name LIKE ?
            OR p0_.code LIKE ?
          )
        GROUP BY
          p0_.id
      ) dctrn_result_inner
    ORDER BY
      name_12 ASC
  ) dctrn_result
LIMIT
  10
OFFSET
  10

SELECT DISTINCT id_10 FROM (SELECT DISTINCT id_10, name_12 FROM (SELECT p0_.code AS code_0, p0_.display_name AS display_name_1, p0_.lwin AS lwin_2, p0_.site AS site_3, p0_.seller_price_qty AS seller_price_qty_4, p0_.price AS price_5, p0_.merged_uuids AS merged_uuids_6, p0_.has_lwin_suggests AS has_lwin_suggests_7, p0_.from_import AS from_import_8, p0_.bundle AS bundle_9, p0_.id AS id_10, p0_.uuid AS uuid_11, p0_.name AS name_12, p0_.status AS status_13 FROM product p0_ WHERE p0_.status = 1 AND (p0_.name LIKE '%drc%' OR p0_.display_name LIKE '%drc%' OR p0_.code LIKE '%drc%') GROUP BY p0_.id) dctrn_result_inner ORDER BY name_12 ASC) dctrn_result LIMIT 10 OFFSET 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 75)
8	Symfony\UX\Autocomplete\AutocompleteResultsExecutor->fetchResults (line 56)
9	Symfony\UX\Autocomplete\Controller\EntityAutocompleteController->__invoke (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.94 ms

SELECT p0_.code AS code_0, p0_.display_name AS display_name_1, p0_.lwin AS lwin_2, p0_.site AS site_3, p0_.seller_price_qty AS seller_price_qty_4, p0_.price AS price_5, p0_.merged_uuids AS merged_uuids_6, p0_.has_lwin_suggests AS has_lwin_suggests_7, p0_.from_import AS from_import_8, p0_.bundle AS bundle_9, p0_.id AS id_10, p0_.uuid AS uuid_11, p0_.name AS name_12, p0_.status AS status_13, p0_.country_id AS country_id_14, p0_.region_id AS region_id_15, p0_.sub_region_id AS sub_region_id_16, p0_.color_id AS color_id_17, p0_.type_id AS type_id_18, p0_.sub_type_id AS sub_type_id_19, p0_.entity_id AS entity_id_20, p0_.classification_id AS classification_id_21, p0_.line_id AS line_id_22, p0_.producer_id AS producer_id_23 FROM product p0_ WHERE p0_.status = ? AND (p0_.name LIKE ? OR p0_.display_name LIKE ? OR p0_.code LIKE ?) AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY p0_.id ORDER BY p0_.name ASC

Parameters:

[
  1
  "%drc%"
  "%drc%"
  "%drc%"
  2810
  2811
  2812
  5590
  2813
  2809
  4286
  4356
  4359
  5217
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.code AS code_0,
  p0_.display_name AS display_name_1,
  p0_.lwin AS lwin_2,
  p0_.site AS site_3,
  p0_.seller_price_qty AS seller_price_qty_4,
  p0_.price AS price_5,
  p0_.merged_uuids AS merged_uuids_6,
  p0_.has_lwin_suggests AS has_lwin_suggests_7,
  p0_.from_import AS from_import_8,
  p0_.bundle AS bundle_9,
  p0_.id AS id_10,
  p0_.uuid AS uuid_11,
  p0_.name AS name_12,
  p0_.status AS status_13,
  p0_.country_id AS country_id_14,
  p0_.region_id AS region_id_15,
  p0_.sub_region_id AS sub_region_id_16,
  p0_.color_id AS color_id_17,
  p0_.type_id AS type_id_18,
  p0_.sub_type_id AS sub_type_id_19,
  p0_.entity_id AS entity_id_20,
  p0_.classification_id AS classification_id_21,
  p0_.line_id AS line_id_22,
  p0_.producer_id AS producer_id_23
FROM
  product p0_
WHERE
  p0_.status = ?
  AND (
    p0_.name LIKE ?
    OR p0_.display_name LIKE ?
    OR p0_.code LIKE ?
  )
  AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
GROUP BY
  p0_.id
ORDER BY
  p0_.name ASC

SELECT p0_.code AS code_0, p0_.display_name AS display_name_1, p0_.lwin AS lwin_2, p0_.site AS site_3, p0_.seller_price_qty AS seller_price_qty_4, p0_.price AS price_5, p0_.merged_uuids AS merged_uuids_6, p0_.has_lwin_suggests AS has_lwin_suggests_7, p0_.from_import AS from_import_8, p0_.bundle AS bundle_9, p0_.id AS id_10, p0_.uuid AS uuid_11, p0_.name AS name_12, p0_.status AS status_13, p0_.country_id AS country_id_14, p0_.region_id AS region_id_15, p0_.sub_region_id AS sub_region_id_16, p0_.color_id AS color_id_17, p0_.type_id AS type_id_18, p0_.sub_type_id AS sub_type_id_19, p0_.entity_id AS entity_id_20, p0_.classification_id AS classification_id_21, p0_.line_id AS line_id_22, p0_.producer_id AS producer_id_23 FROM product p0_ WHERE p0_.status = 1 AND (p0_.name LIKE '%drc%' OR p0_.display_name LIKE '%drc%' OR p0_.code LIKE '%drc%') AND p0_.id IN (2810, 2811, 2812, 5590, 2813, 2809, 4286, 4356, 4359, 5217) GROUP BY p0_.id ORDER BY p0_.name ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 75)
8	Symfony\UX\Autocomplete\AutocompleteResultsExecutor->fetchResults (line 56)
9	Symfony\UX\Autocomplete\Controller\EntityAutocompleteController->__invoke (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
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\Product\Product	10
App\Entity\Product\Color	2
App\Entity\Product\Type	2
App\Entity\Property\Property	2
App\Entity\Product\Classification	2
App\Entity\User	1
App\Entity\Company	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Company	No errors.
App\Entity\Product\Offer	No errors.
App\Entity\Product\FavouriteOffer	No errors.
App\Entity\Offer\OfferProposal	No errors.
App\Entity\Offer\OfferUserConsult	No errors.
App\Entity\Product\Product	No errors.
App\Entity\Country	No errors.
App\Entity\Region	No errors.
App\Entity\SubRegion	No errors.
App\Entity\Product\Color	No errors.
App\Entity\Product\Type	No errors.
App\Entity\Product\SubType	No errors.
App\Entity\Property\Property	No errors.
App\Entity\Product\Classification	No errors.
App\Entity\Product\Line	No errors.
App\Entity\Property\Producer	No errors.
App\Entity\Product\VintageSettings	No errors.
App\Entity\Product\Vintage	No errors.
App\Entity\Product\Appellation	No errors.
App\Entity\Product\Dictionary	No errors.
App\Entity\Product\Acronym	No errors.

Symfony Profiler

GET https://app103.fr/autocomplete/product?page=2&query=drc

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping