Symfony Profiler

Query Metrics

4 Database Queries

3 Different statements

784.65 ms Query time

0 Invalid entities

2 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

432.40 ms
(55.11%)

SELECT p0_.id AS id_0 FROM product p0_ LEFT JOIN seller s1_ ON p0_.seller_id = s1_.id LEFT JOIN seller_profile s2_ ON s1_.id = s2_.seller_id LEFT JOIN seller_address s3_ ON s1_.id = s3_.seller_id LEFT JOIN geo_city g4_ ON s3_.geo_city_id = g4_.id WHERE p0_.status IN (?, ?) AND p0_.display = 1 AND ((EXISTS (SELECT 1 AS sclr_1 FROM product_translation p5_ WHERE p5_.product_id = p0_.id AND (p5_.title LIKE ? OR (p5_.description IS NOT NULL AND p5_.description LIKE ?)))) OR s2_.business_name LIKE ? OR (EXISTS (SELECT 1 AS sclr_2 FROM tag t6_ INNER JOIN product_tag p8_ ON t6_.id = p8_.tag_id INNER JOIN product p7_ ON p7_.id = p8_.product_id INNER JOIN tag_translation t9_ ON t6_.id = t9_.tag_id WHERE p7_.id = p0_.id AND t9_.label LIKE ?))) GROUP BY p0_.id ORDER BY CASE WHEN p0_.status = ? THEN 1 ELSE 0 END ASC, p0_.published_at DESC LIMIT 8

Parameters:

[
  "active"
  "sold"
  "%vendor symfony maker bundle src Maker MakeEntity.php%"
  "%vendor symfony maker bundle src Maker MakeEntity.php%"
  "%vendor symfony maker bundle src Maker MakeEntity.php%"
  "%vendor symfony maker bundle src Maker MakeEntity.php%"
  "sold"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0
FROM
  product p0_
  LEFT JOIN seller s1_ ON p0_.seller_id = s1_.id
  LEFT JOIN seller_profile s2_ ON s1_.id = s2_.seller_id
  LEFT JOIN seller_address s3_ ON s1_.id = s3_.seller_id
  LEFT JOIN geo_city g4_ ON s3_.geo_city_id = g4_.id
WHERE
  p0_.status IN (?, ?)
  AND p0_.display = 1
  AND (
    (
      EXISTS (
        SELECT
          1 AS sclr_1
        FROM
          product_translation p5_
        WHERE
          p5_.product_id = p0_.id
          AND (
            p5_.title LIKE ?
            OR (
              p5_.description IS NOT NULL
              AND p5_.description LIKE ?
            )
          )
      )
    )
    OR s2_.business_name LIKE ?
    OR (
      EXISTS (
        SELECT
          1 AS sclr_2
        FROM
          tag t6_
          INNER JOIN product_tag p8_ ON t6_.id = p8_.tag_id
          INNER JOIN product p7_ ON p7_.id = p8_.product_id
          INNER JOIN tag_translation t9_ ON t6_.id = t9_.tag_id
        WHERE
          p7_.id = p0_.id
          AND t9_.label LIKE ?
      )
    )
  )
GROUP BY
  p0_.id
ORDER BY
  CASE WHEN p0_.status = ? THEN
    1
  ELSE
    0
  END ASC,
  p0_.published_at DESC
LIMIT
  8

SELECT p0_.id AS id_0 FROM product p0_ LEFT JOIN seller s1_ ON p0_.seller_id = s1_.id LEFT JOIN seller_profile s2_ ON s1_.id = s2_.seller_id LEFT JOIN seller_address s3_ ON s1_.id = s3_.seller_id LEFT JOIN geo_city g4_ ON s3_.geo_city_id = g4_.id WHERE p0_.status IN ('active', 'sold') AND p0_.display = 1 AND ((EXISTS (SELECT 1 AS sclr_1 FROM product_translation p5_ WHERE p5_.product_id = p0_.id AND (p5_.title LIKE '%vendor symfony maker bundle src Maker MakeEntity.php%' OR (p5_.description IS NOT NULL AND p5_.description LIKE '%vendor symfony maker bundle src Maker MakeEntity.php%')))) OR s2_.business_name LIKE '%vendor symfony maker bundle src Maker MakeEntity.php%' OR (EXISTS (SELECT 1 AS sclr_2 FROM tag t6_ INNER JOIN product_tag p8_ ON t6_.id = p8_.tag_id INNER JOIN product p7_ ON p7_.id = p8_.product_id INNER JOIN tag_translation t9_ ON t6_.id = t9_.tag_id WHERE p7_.id = p0_.id AND t9_.label LIKE '%vendor symfony maker bundle src Maker MakeEntity.php%'))) GROUP BY p0_.id ORDER BY CASE WHEN p0_.status = 'sold' THEN 1 ELSE 0 END ASC, p0_.published_at DESC LIMIT 8;

#	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->getSingleColumnResult (line 712)
6	App\Repository\ProductRepository->{closure:App\Repository\ProductRepository::findFiltered():491} (line 493)
7	App\Repository\ProductRepository->findFiltered (line 499)
8	App\Core\Search\CatalogueSearchService->searchWithText (line 55)
9	App\Core\EventSubscriber\NotFoundHtmlSubscriber->onKernelException (line 68)
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 129)
14	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
16	Symfony\Component\HttpKernel\Kernel->handle (line 191)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 32)
19	require_once (line 5)

350.37 ms
(44.65%)

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN seller s1_ ON p0_.seller_id = s1_.id LEFT JOIN seller_profile s2_ ON s1_.id = s2_.seller_id LEFT JOIN seller_address s3_ ON s1_.id = s3_.seller_id LEFT JOIN geo_city g4_ ON s3_.geo_city_id = g4_.id WHERE p0_.status IN (?, ?) AND p0_.display = 1 AND ((EXISTS (SELECT 1 AS sclr_1 FROM product_translation p5_ WHERE p5_.product_id = p0_.id AND (p5_.title LIKE ? OR (p5_.description IS NOT NULL AND p5_.description LIKE ?)))) OR s2_.business_name LIKE ? OR (EXISTS (SELECT 1 AS sclr_2 FROM tag t6_ INNER JOIN product_tag p8_ ON t6_.id = p8_.tag_id INNER JOIN product p7_ ON p7_.id = p8_.product_id INNER JOIN tag_translation t9_ ON t6_.id = t9_.tag_id WHERE p7_.id = p0_.id AND t9_.label LIKE ?)))

Parameters:

[
  "active"
  "sold"
  "%vendor symfony maker bundle src Maker MakeEntity.php%"
  "%vendor symfony maker bundle src Maker MakeEntity.php%"
  "%vendor symfony maker bundle src Maker MakeEntity.php%"
  "%vendor symfony maker bundle src Maker MakeEntity.php%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0
FROM
  product p0_
  LEFT JOIN seller s1_ ON p0_.seller_id = s1_.id
  LEFT JOIN seller_profile s2_ ON s1_.id = s2_.seller_id
  LEFT JOIN seller_address s3_ ON s1_.id = s3_.seller_id
  LEFT JOIN geo_city g4_ ON s3_.geo_city_id = g4_.id
WHERE
  p0_.status IN (?, ?)
  AND p0_.display = 1
  AND (
    (
      EXISTS (
        SELECT
          1 AS sclr_1
        FROM
          product_translation p5_
        WHERE
          p5_.product_id = p0_.id
          AND (
            p5_.title LIKE ?
            OR (
              p5_.description IS NOT NULL
              AND p5_.description LIKE ?
            )
          )
      )
    )
    OR s2_.business_name LIKE ?
    OR (
      EXISTS (
        SELECT
          1 AS sclr_2
        FROM
          tag t6_
          INNER JOIN product_tag p8_ ON t6_.id = p8_.tag_id
          INNER JOIN product p7_ ON p7_.id = p8_.product_id
          INNER JOIN tag_translation t9_ ON t6_.id = t9_.tag_id
        WHERE
          p7_.id = p0_.id
          AND t9_.label LIKE ?
      )
    )
  )

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN seller s1_ ON p0_.seller_id = s1_.id LEFT JOIN seller_profile s2_ ON s1_.id = s2_.seller_id LEFT JOIN seller_address s3_ ON s1_.id = s3_.seller_id LEFT JOIN geo_city g4_ ON s3_.geo_city_id = g4_.id WHERE p0_.status IN ('active', 'sold') AND p0_.display = 1 AND ((EXISTS (SELECT 1 AS sclr_1 FROM product_translation p5_ WHERE p5_.product_id = p0_.id AND (p5_.title LIKE '%vendor symfony maker bundle src Maker MakeEntity.php%' OR (p5_.description IS NOT NULL AND p5_.description LIKE '%vendor symfony maker bundle src Maker MakeEntity.php%')))) OR s2_.business_name LIKE '%vendor symfony maker bundle src Maker MakeEntity.php%' OR (EXISTS (SELECT 1 AS sclr_2 FROM tag t6_ INNER JOIN product_tag p8_ ON t6_.id = p8_.tag_id INNER JOIN product p7_ ON p7_.id = p8_.product_id INNER JOIN tag_translation t9_ ON t6_.id = t9_.tag_id WHERE p7_.id = p0_.id AND t9_.label LIKE '%vendor symfony maker bundle src Maker MakeEntity.php%')));

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Repository\ProductRepository->countFiltered (line 524)
8	App\Core\Search\CatalogueSearchService->searchWithText (line 56)
9	App\Core\EventSubscriber\NotFoundHtmlSubscriber->onKernelException (line 68)
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 129)
14	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
16	Symfony\Component\HttpKernel\Kernel->handle (line 191)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 32)
19	require_once (line 5)

1.88 ms
(0.24%)

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.updated_at AS updated_at_4 FROM marketplace_setting t0 WHERE t0.setting_key = ? LIMIT 1

Parameters:

[
  "meilisearch.enabled"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.setting_key AS setting_key_2,
  t0.value AS value_3,
  t0.updated_at AS updated_at_4
FROM
  marketplace_setting t0
WHERE
  t0.setting_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.updated_at AS updated_at_4 FROM marketplace_setting t0 WHERE t0.setting_key = 'meilisearch.enabled' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	App\Repository\MarketplaceSettingRepository->getValue (line 25)
5	App\Core\Search\MeilisearchRuntime->readEnabled (line 55)
6	App\Core\Search\MeilisearchRuntime->isUsable (line 25)
7	App\Core\Search\CatalogueSearchService->searchWithText (line 36)
8	App\Core\EventSubscriber\NotFoundHtmlSubscriber->onKernelException (line 68)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
13	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
15	Symfony\Component\HttpKernel\Kernel->handle (line 191)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 32)
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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\MarketplaceSetting	2

Entities Mapping

Class	Mapping errors
App\Entity\MarketplaceSetting	No errors.
App\Entity\Product	No errors.
App\Entity\Seller	No errors.
App\Entity\SellerProfile	No errors.
App\Entity\SellerAddress	No errors.
App\Entity\Geo\GeoCity	No errors.
App\Entity\ProductTranslation	No errors.
App\Entity\Tag	No errors.
App\Entity\TagTranslation	No errors.

Symfony Profiler

GET https://www.nxt.antiquites-en-france.com/vendor/symfony/maker-bundle/src/Maker/MakeEntity.php

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping