Symfony Profiler

Query Metrics

18 Database Queries

9 Different statements

41.66 ms Query time

2 Invalid entities

180 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

16.92 ms
(40.61%)

SELECT DISTINCT r0_.id AS id_0, r0_.name AS name_1 FROM retailer r0_ WHERE ((LOWER(CONCAT(r0_.name, '')) LIKE ? OR LOWER(CONCAT(r0_.address, '')) LIKE ? OR LOWER(CONCAT(r0_.zipcode, '')) LIKE ? OR LOWER(CONCAT(r0_.city, '')) LIKE ? OR LOWER(CONCAT(r0_.phone, '')) LIKE ? OR LOWER(CONCAT(r0_.email, '')) LIKE ? OR LOWER(CONCAT(r0_.siret, '')) LIKE ? OR LOWER(CONCAT(r0_.tva_number, '')) LIKE ? OR LOWER(CONCAT(r0_.type, '')) LIKE ? OR LOWER(CONCAT(r0_.commercial_zone, '')) LIKE ? OR LOWER(CONCAT(r0_.country, '')) LIKE ? OR LOWER(CONCAT(r0_.admin_comment, '')) LIKE ? OR LOWER(CONCAT(r0_.type_profile, '')) LIKE ? OR LOWER(CONCAT(r0_.reseau, '')) LIKE ? OR LOWER(CONCAT(r0_.groupe, '')) LIKE ? OR LOWER(CONCAT(r0_.imported, '')) LIKE ? OR LOWER(CONCAT(r0_.sap_code, '')) LIKE ?) AND (LOWER(CONCAT(r0_.name, '')) LIKE ? OR LOWER(CONCAT(r0_.address, '')) LIKE ? OR LOWER(CONCAT(r0_.zipcode, '')) LIKE ? OR LOWER(CONCAT(r0_.city, '')) LIKE ? OR LOWER(CONCAT(r0_.phone, '')) LIKE ? OR LOWER(CONCAT(r0_.email, '')) LIKE ? OR LOWER(CONCAT(r0_.siret, '')) LIKE ? OR LOWER(CONCAT(r0_.tva_number, '')) LIKE ? OR LOWER(CONCAT(r0_.type, '')) LIKE ? OR LOWER(CONCAT(r0_.commercial_zone, '')) LIKE ? OR LOWER(CONCAT(r0_.country, '')) LIKE ? OR LOWER(CONCAT(r0_.admin_comment, '')) LIKE ? OR LOWER(CONCAT(r0_.type_profile, '')) LIKE ? OR LOWER(CONCAT(r0_.reseau, '')) LIKE ? OR LOWER(CONCAT(r0_.groupe, '')) LIKE ? OR LOWER(CONCAT(r0_.imported, '')) LIKE ? OR LOWER(CONCAT(r0_.sap_code, '')) LIKE ?)) OR (r0_.id IN (SELECT a1_.retailer_id AS sclr_2 FROM address a1_ WHERE LOWER(a1_.street) LIKE LOWER(?) OR LOWER(a1_.street2) LIKE LOWER(?) OR LOWER(a1_.city) LIKE LOWER(?) OR LOWER(a1_.zipcode) LIKE LOWER(?))) ORDER BY r0_.name ASC LIMIT 20

Parameters:

[
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%am env%"
  "%am env%"
  "%am env%"
  "%am env%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT r0_.id AS id_0,
  r0_.name AS name_1
FROM
  retailer r0_
WHERE
  (
    (
      LOWER(
        CONCAT(r0_.name, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.address, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.zipcode, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.city, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.phone, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.email, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.siret, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.tva_number, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.type, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.commercial_zone, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.country, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.admin_comment, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.type_profile, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.reseau, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.groupe, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.imported, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.sap_code, '')
      ) LIKE ?
    )
    AND (
      LOWER(
        CONCAT(r0_.name, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.address, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.zipcode, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.city, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.phone, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.email, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.siret, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.tva_number, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.type, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.commercial_zone, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.country, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.admin_comment, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.type_profile, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.reseau, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.groupe, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.imported, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.sap_code, '')
      ) LIKE ?
    )
  )
  OR (
    r0_.id IN (
      SELECT
        a1_.retailer_id AS sclr_2
      FROM
        address a1_
      WHERE
        LOWER(a1_.street) LIKE LOWER(?)
        OR LOWER(a1_.street2) LIKE LOWER(?)
        OR LOWER(a1_.city) LIKE LOWER(?)
        OR LOWER(a1_.zipcode) LIKE LOWER(?)
    )
  )
ORDER BY
  r0_.name ASC
LIMIT
  20

SELECT DISTINCT r0_.id AS id_0, r0_.name AS name_1 FROM retailer r0_ WHERE ((LOWER(CONCAT(r0_.name, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.address, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.zipcode, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.city, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.phone, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.email, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.siret, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.tva_number, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.type, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.commercial_zone, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.country, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.admin_comment, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.type_profile, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.reseau, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.groupe, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.imported, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.sap_code, '')) LIKE '%am%') AND (LOWER(CONCAT(r0_.name, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.address, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.zipcode, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.city, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.phone, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.email, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.siret, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.tva_number, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.type, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.commercial_zone, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.country, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.admin_comment, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.type_profile, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.reseau, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.groupe, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.imported, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.sap_code, '')) LIKE '%env%')) OR (r0_.id IN (SELECT a1_.retailer_id AS sclr_2 FROM address a1_ WHERE LOWER(a1_.street) LIKE LOWER('%am env%') OR LOWER(a1_.street2) LIKE LOWER('%am env%') OR LOWER(a1_.city) LIKE LOWER('%am env%') OR LOWER(a1_.zipcode) LIKE LOWER('%am env%'))) ORDER BY r0_.name ASC LIMIT 20;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 68)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 138)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

9.97 ms
(23.92%)

SELECT count(*) AS sclr_0 FROM retailer r0_ WHERE ((LOWER(CONCAT(r0_.name, '')) LIKE ? OR LOWER(CONCAT(r0_.address, '')) LIKE ? OR LOWER(CONCAT(r0_.zipcode, '')) LIKE ? OR LOWER(CONCAT(r0_.city, '')) LIKE ? OR LOWER(CONCAT(r0_.phone, '')) LIKE ? OR LOWER(CONCAT(r0_.email, '')) LIKE ? OR LOWER(CONCAT(r0_.siret, '')) LIKE ? OR LOWER(CONCAT(r0_.tva_number, '')) LIKE ? OR LOWER(CONCAT(r0_.type, '')) LIKE ? OR LOWER(CONCAT(r0_.commercial_zone, '')) LIKE ? OR LOWER(CONCAT(r0_.country, '')) LIKE ? OR LOWER(CONCAT(r0_.admin_comment, '')) LIKE ? OR LOWER(CONCAT(r0_.type_profile, '')) LIKE ? OR LOWER(CONCAT(r0_.reseau, '')) LIKE ? OR LOWER(CONCAT(r0_.groupe, '')) LIKE ? OR LOWER(CONCAT(r0_.imported, '')) LIKE ? OR LOWER(CONCAT(r0_.sap_code, '')) LIKE ?) AND (LOWER(CONCAT(r0_.name, '')) LIKE ? OR LOWER(CONCAT(r0_.address, '')) LIKE ? OR LOWER(CONCAT(r0_.zipcode, '')) LIKE ? OR LOWER(CONCAT(r0_.city, '')) LIKE ? OR LOWER(CONCAT(r0_.phone, '')) LIKE ? OR LOWER(CONCAT(r0_.email, '')) LIKE ? OR LOWER(CONCAT(r0_.siret, '')) LIKE ? OR LOWER(CONCAT(r0_.tva_number, '')) LIKE ? OR LOWER(CONCAT(r0_.type, '')) LIKE ? OR LOWER(CONCAT(r0_.commercial_zone, '')) LIKE ? OR LOWER(CONCAT(r0_.country, '')) LIKE ? OR LOWER(CONCAT(r0_.admin_comment, '')) LIKE ? OR LOWER(CONCAT(r0_.type_profile, '')) LIKE ? OR LOWER(CONCAT(r0_.reseau, '')) LIKE ? OR LOWER(CONCAT(r0_.groupe, '')) LIKE ? OR LOWER(CONCAT(r0_.imported, '')) LIKE ? OR LOWER(CONCAT(r0_.sap_code, '')) LIKE ?)) OR (r0_.id IN (SELECT a1_.retailer_id AS sclr_1 FROM address a1_ WHERE LOWER(a1_.street) LIKE LOWER(?) OR LOWER(a1_.street2) LIKE LOWER(?) OR LOWER(a1_.city) LIKE LOWER(?) OR LOWER(a1_.zipcode) LIKE LOWER(?)))

Parameters:

[
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%am env%"
  "%am env%"
  "%am env%"
  "%am env%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(*) AS sclr_0
FROM
  retailer r0_
WHERE
  (
    (
      LOWER(
        CONCAT(r0_.name, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.address, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.zipcode, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.city, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.phone, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.email, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.siret, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.tva_number, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.type, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.commercial_zone, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.country, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.admin_comment, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.type_profile, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.reseau, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.groupe, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.imported, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.sap_code, '')
      ) LIKE ?
    )
    AND (
      LOWER(
        CONCAT(r0_.name, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.address, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.zipcode, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.city, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.phone, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.email, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.siret, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.tva_number, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.type, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.commercial_zone, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.country, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.admin_comment, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.type_profile, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.reseau, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.groupe, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.imported, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.sap_code, '')
      ) LIKE ?
    )
  )
  OR (
    r0_.id IN (
      SELECT
        a1_.retailer_id AS sclr_1
      FROM
        address a1_
      WHERE
        LOWER(a1_.street) LIKE LOWER(?)
        OR LOWER(a1_.street2) LIKE LOWER(?)
        OR LOWER(a1_.city) LIKE LOWER(?)
        OR LOWER(a1_.zipcode) LIKE LOWER(?)
    )
  )

SELECT count(*) AS sclr_0 FROM retailer r0_ WHERE ((LOWER(CONCAT(r0_.name, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.address, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.zipcode, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.city, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.phone, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.email, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.siret, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.tva_number, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.type, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.commercial_zone, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.country, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.admin_comment, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.type_profile, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.reseau, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.groupe, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.imported, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.sap_code, '')) LIKE '%am%') AND (LOWER(CONCAT(r0_.name, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.address, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.zipcode, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.city, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.phone, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.email, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.siret, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.tva_number, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.type, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.commercial_zone, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.country, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.admin_comment, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.type_profile, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.reseau, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.groupe, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.imported, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.sap_code, '')) LIKE '%env%')) OR (r0_.id IN (SELECT a1_.retailer_id AS sclr_1 FROM address a1_ WHERE LOWER(a1_.street) LIKE LOWER('%am env%') OR LOWER(a1_.street2) LIKE LOWER('%am env%') OR LOWER(a1_.city) LIKE LOWER('%am env%') OR LOWER(a1_.zipcode) LIKE LOWER('%am env%')));

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 69)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 138)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

4.62 ms
(11.09%)

SELECT t0.id AS id_1, t0.street AS street_2, t0.street2 AS street2_3, t0.zipcode AS zipcode_4, t0.city AS city_5, t0.country AS country_6, t0.phone AS phone_7, t0.mobile AS mobile_8, t0.type AS type_9, t0.opening_hours AS opening_hours_10, t0.bp AS bp_11, t0.imported AS imported_12, t0.title AS title_13, t0.comment AS comment_14, t0.retailer_id AS retailer_id_15 FROM address t0 WHERE t0.retailer_id = ?

Parameters:

[
  6233
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.street AS street_2,
  t0.street2 AS street2_3,
  t0.zipcode AS zipcode_4,
  t0.city AS city_5,
  t0.country AS country_6,
  t0.phone AS phone_7,
  t0.mobile AS mobile_8,
  t0.type AS type_9,
  t0.opening_hours AS opening_hours_10,
  t0.bp AS bp_11,
  t0.imported AS imported_12,
  t0.title AS title_13,
  t0.comment AS comment_14,
  t0.retailer_id AS retailer_id_15
FROM
  address t0
WHERE
  t0.retailer_id = ?

SELECT t0.id AS id_1, t0.street AS street_2, t0.street2 AS street2_3, t0.zipcode AS zipcode_4, t0.city AS city_5, t0.country AS country_6, t0.phone AS phone_7, t0.mobile AS mobile_8, t0.type AS type_9, t0.opening_hours AS opening_hours_10, t0.bp AS bp_11, t0.imported AS imported_12, t0.title AS title_13, t0.comment AS comment_14, t0.retailer_id AS retailer_id_15 FROM address t0 WHERE t0.retailer_id = 6233;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	App\Entity\Retailer->getHasAddressComment (line 612)
8	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 401)
9	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 102)
10	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\CommonPreConfigurator->configure (line 48)
11	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFields (line 115)
12	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFieldsForAll (line 149)
13	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 149)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 193)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 32)
19	require_once (line 5)

3.57 ms
(8.56%)

SELECT DISTINCT SUBSTRING(a0_.zipcode FROM 1 FOR 2) AS sclr_0 FROM address a0_ WHERE a0_.zipcode IS NOT NULL AND a0_.zipcode <> ? AND CHAR_LENGTH(a0_.zipcode) >= 2 ORDER BY sclr_0 ASC

Parameters:

[
  ""
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT SUBSTRING(
    a0_.zipcode
    FROM
      1 FOR 2
  ) AS sclr_0
FROM
  address a0_
WHERE
  a0_.zipcode IS NOT NULL
  AND a0_.zipcode <> ?
  AND CHAR_LENGTH(a0_.zipcode) >= 2
ORDER BY
  sclr_0 ASC

SELECT DISTINCT SUBSTRING(a0_.zipcode FROM 1 FOR 2) AS sclr_0 FROM address a0_ WHERE a0_.zipcode IS NOT NULL AND a0_.zipcode <> '' AND CHAR_LENGTH(a0_.zipcode) >= 2 ORDER BY sclr_0 ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Controller\Admin\RetailerCrudController->getDepartmentChoices (line 352)
7	App\Controller\Admin\RetailerCrudController->configureFilters (line 297)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->getFilters (line 172)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->create (line 60)
10	EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber->onKernelRequest (line 182)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 193)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 32)
20	require_once (line 5)

3.14 ms
(7.54%)

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.address AS address_2, r0_.zipcode AS zipcode_3, r0_.city AS city_4, r0_.phone AS phone_5, r0_.email AS email_6, r0_.siret AS siret_7, r0_.tva_number AS tva_number_8, r0_.created_at AS created_at_9, r0_.type AS type_10, r0_.status AS status_11, r0_.commercial_zone AS commercial_zone_12, r0_.country AS country_13, r0_.verify_by_bd AS verify_by_bd_14, r0_.verify_by_na AS verify_by_na_15, r0_.verify_by_rl AS verify_by_rl_16, r0_.admin_comment AS admin_comment_17, r0_.close AS close_18, r0_.type_profile AS type_profile_19, r0_.reseau AS reseau_20, r0_.groupe AS groupe_21, r0_.imported AS imported_22, r0_.sap_code AS sap_code_23, r0_.activity_id AS activity_id_24, r0_.rachat_matiere_id AS rachat_matiere_id_25, r0_.network_id AS network_id_26, r0_.retailer_group_id AS retailer_group_id_27 FROM retailer r0_ WHERE (((LOWER(CONCAT(r0_.name, '')) LIKE ? OR LOWER(CONCAT(r0_.address, '')) LIKE ? OR LOWER(CONCAT(r0_.zipcode, '')) LIKE ? OR LOWER(CONCAT(r0_.city, '')) LIKE ? OR LOWER(CONCAT(r0_.phone, '')) LIKE ? OR LOWER(CONCAT(r0_.email, '')) LIKE ? OR LOWER(CONCAT(r0_.siret, '')) LIKE ? OR LOWER(CONCAT(r0_.tva_number, '')) LIKE ? OR LOWER(CONCAT(r0_.type, '')) LIKE ? OR LOWER(CONCAT(r0_.commercial_zone, '')) LIKE ? OR LOWER(CONCAT(r0_.country, '')) LIKE ? OR LOWER(CONCAT(r0_.admin_comment, '')) LIKE ? OR LOWER(CONCAT(r0_.type_profile, '')) LIKE ? OR LOWER(CONCAT(r0_.reseau, '')) LIKE ? OR LOWER(CONCAT(r0_.groupe, '')) LIKE ? OR LOWER(CONCAT(r0_.imported, '')) LIKE ? OR LOWER(CONCAT(r0_.sap_code, '')) LIKE ?) AND (LOWER(CONCAT(r0_.name, '')) LIKE ? OR LOWER(CONCAT(r0_.address, '')) LIKE ? OR LOWER(CONCAT(r0_.zipcode, '')) LIKE ? OR LOWER(CONCAT(r0_.city, '')) LIKE ? OR LOWER(CONCAT(r0_.phone, '')) LIKE ? OR LOWER(CONCAT(r0_.email, '')) LIKE ? OR LOWER(CONCAT(r0_.siret, '')) LIKE ? OR LOWER(CONCAT(r0_.tva_number, '')) LIKE ? OR LOWER(CONCAT(r0_.type, '')) LIKE ? OR LOWER(CONCAT(r0_.commercial_zone, '')) LIKE ? OR LOWER(CONCAT(r0_.country, '')) LIKE ? OR LOWER(CONCAT(r0_.admin_comment, '')) LIKE ? OR LOWER(CONCAT(r0_.type_profile, '')) LIKE ? OR LOWER(CONCAT(r0_.reseau, '')) LIKE ? OR LOWER(CONCAT(r0_.groupe, '')) LIKE ? OR LOWER(CONCAT(r0_.imported, '')) LIKE ? OR LOWER(CONCAT(r0_.sap_code, '')) LIKE ?)) OR (r0_.id IN (SELECT a1_.retailer_id AS sclr_28 FROM address a1_ WHERE LOWER(a1_.street) LIKE LOWER(?) OR LOWER(a1_.street2) LIKE LOWER(?) OR LOWER(a1_.city) LIKE LOWER(?) OR LOWER(a1_.zipcode) LIKE LOWER(?)))) AND r0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY r0_.name ASC

Parameters:

[
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%am%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%env%"
  "%am env%"
  "%am env%"
  "%am env%"
  "%am env%"
  6233
  6631
  6409
  6447
  6641
  6640
  3546
  84
  107
  116
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.address AS address_2,
  r0_.zipcode AS zipcode_3,
  r0_.city AS city_4,
  r0_.phone AS phone_5,
  r0_.email AS email_6,
  r0_.siret AS siret_7,
  r0_.tva_number AS tva_number_8,
  r0_.created_at AS created_at_9,
  r0_.type AS type_10,
  r0_.status AS status_11,
  r0_.commercial_zone AS commercial_zone_12,
  r0_.country AS country_13,
  r0_.verify_by_bd AS verify_by_bd_14,
  r0_.verify_by_na AS verify_by_na_15,
  r0_.verify_by_rl AS verify_by_rl_16,
  r0_.admin_comment AS admin_comment_17,
  r0_.close AS close_18,
  r0_.type_profile AS type_profile_19,
  r0_.reseau AS reseau_20,
  r0_.groupe AS groupe_21,
  r0_.imported AS imported_22,
  r0_.sap_code AS sap_code_23,
  r0_.activity_id AS activity_id_24,
  r0_.rachat_matiere_id AS rachat_matiere_id_25,
  r0_.network_id AS network_id_26,
  r0_.retailer_group_id AS retailer_group_id_27
FROM
  retailer r0_
WHERE
  (
    (
      (
        LOWER(
          CONCAT(r0_.name, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.address, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.zipcode, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.city, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.phone, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.email, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.siret, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.tva_number, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.type, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.commercial_zone, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.country, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.admin_comment, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.type_profile, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.reseau, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.groupe, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.imported, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.sap_code, '')
        ) LIKE ?
      )
      AND (
        LOWER(
          CONCAT(r0_.name, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.address, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.zipcode, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.city, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.phone, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.email, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.siret, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.tva_number, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.type, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.commercial_zone, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.country, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.admin_comment, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.type_profile, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.reseau, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.groupe, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.imported, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.sap_code, '')
        ) LIKE ?
      )
    )
    OR (
      r0_.id IN (
        SELECT
          a1_.retailer_id AS sclr_28
        FROM
          address a1_
        WHERE
          LOWER(a1_.street) LIKE LOWER(?)
          OR LOWER(a1_.street2) LIKE LOWER(?)
          OR LOWER(a1_.city) LIKE LOWER(?)
          OR LOWER(a1_.zipcode) LIKE LOWER(?)
      )
    )
  )
  AND r0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  r0_.name ASC

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.address AS address_2, r0_.zipcode AS zipcode_3, r0_.city AS city_4, r0_.phone AS phone_5, r0_.email AS email_6, r0_.siret AS siret_7, r0_.tva_number AS tva_number_8, r0_.created_at AS created_at_9, r0_.type AS type_10, r0_.status AS status_11, r0_.commercial_zone AS commercial_zone_12, r0_.country AS country_13, r0_.verify_by_bd AS verify_by_bd_14, r0_.verify_by_na AS verify_by_na_15, r0_.verify_by_rl AS verify_by_rl_16, r0_.admin_comment AS admin_comment_17, r0_.close AS close_18, r0_.type_profile AS type_profile_19, r0_.reseau AS reseau_20, r0_.groupe AS groupe_21, r0_.imported AS imported_22, r0_.sap_code AS sap_code_23, r0_.activity_id AS activity_id_24, r0_.rachat_matiere_id AS rachat_matiere_id_25, r0_.network_id AS network_id_26, r0_.retailer_group_id AS retailer_group_id_27 FROM retailer r0_ WHERE (((LOWER(CONCAT(r0_.name, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.address, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.zipcode, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.city, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.phone, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.email, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.siret, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.tva_number, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.type, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.commercial_zone, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.country, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.admin_comment, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.type_profile, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.reseau, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.groupe, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.imported, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.sap_code, '')) LIKE '%am%') AND (LOWER(CONCAT(r0_.name, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.address, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.zipcode, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.city, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.phone, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.email, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.siret, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.tva_number, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.type, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.commercial_zone, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.country, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.admin_comment, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.type_profile, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.reseau, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.groupe, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.imported, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.sap_code, '')) LIKE '%env%')) OR (r0_.id IN (SELECT a1_.retailer_id AS sclr_28 FROM address a1_ WHERE LOWER(a1_.street) LIKE LOWER('%am env%') OR LOWER(a1_.street2) LIKE LOWER('%am env%') OR LOWER(a1_.city) LIKE LOWER('%am env%') OR LOWER(a1_.zipcode) LIKE LOWER('%am env%')))) AND r0_.id IN (6233, 6631, 6409, 6447, 6641, 6640, 3546, 84, 107, 116) ORDER BY r0_.name ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
7	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 68)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 138)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

2.50 ms
(6.01%)

SELECT DISTINCT r0_.country AS country_0 FROM retailer r0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT r0_.country AS country_0
FROM
  retailer r0_

SELECT DISTINCT r0_.country AS country_0 FROM retailer r0_;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Controller\Admin\RetailerCrudController->getCountryChoices (line 318)
7	App\Controller\Admin\RetailerCrudController->configureFilters (line 284)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->getFilters (line 172)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->create (line 60)
10	EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber->onKernelRequest (line 182)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 193)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 32)
20	require_once (line 5)

0.35 ms
(0.84%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.locale AS locale_7, t0.favorite_apps AS favorite_apps_8 FROM user t0 WHERE t0.id = ?

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.locale AS locale_7,
  t0.favorite_apps AS favorite_apps_8
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.locale AS locale_7, t0.favorite_apps AS favorite_apps_8 FROM user t0 WHERE t0.id = 10;

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

0.32 ms
(0.78%)

SELECT t0.id AS id_1, t0.name AS name_2 FROM `group` t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  `group` t0

SELECT t0.id AS id_1, t0.name AS name_2 FROM `group` t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\Admin\RetailerCrudController->getRetailerGroupChoices (line 330)
6	App\Controller\Admin\RetailerCrudController->configureFilters (line 285)
7	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->getFilters (line 172)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->create (line 60)
9	EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber->onKernelRequest (line 182)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 193)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 32)
19	require_once (line 5)

0.27 ms
(0.66%)

SELECT t0.id AS id_1, t0.title AS title_2 FROM activity t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2
FROM
  activity t0

SELECT t0.id AS id_1, t0.title AS title_2 FROM activity t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\Admin\RetailerCrudController->getActivityChoices (line 303)
6	App\Controller\Admin\RetailerCrudController->configureFilters (line 283)
7	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->getFilters (line 172)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->create (line 60)
9	EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber->onKernelRequest (line 182)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 193)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 32)
19	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\Group	128
App\Entity\Activity	31
App\Entity\Retailer	10
App\Entity\Address	10
App\Entity\User	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Log	No errors.
Gedmo\Loggable\Entity\MappedSuperclass\AbstractLogEntry	No errors.
Gedmo\Loggable\Entity\LogEntry	No errors.
App\Entity\Activity	No errors.
App\Entity\Retailer	No errors.
App\Entity\Group	No errors.
App\Entity\Address	No errors.
App\Entity\Network	No errors.
App\Entity\BoxQty	No errors.
App\Entity\Contact	The mappings App\Entity\Contact#serviceList and App\Entity\Service#contacts are inconsistent with each other. If association App\Entity\Contact#serviceList is many-to-one, then the inversed side App\Entity\Service#contacts has to be one-to-many.
App\Entity\Delivery	The mappings App\Entity\Delivery#carrier and App\Entity\Retailer#deliveries are inconsistent with each other.
App\Entity\RetailerBoxSpec	No errors.
App\Entity\Profiling	No errors.
App\Entity\Iban	No errors.
App\Entity\Preparation	No errors.
App\Entity\SiretResult	No errors.
App\Entity\MaterialEntry	No errors.

Symfony Profiler

GET https://dev.veka-ws.ovh/admin?crudAction=index&crudControllerFqcn=App%5CController%5CAdmin%5CRetailerCrudController&page=1&query=am%20env

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping