Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

4.67 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.47 ms
(31.45%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_21 FROM (SELECT l0_.reference AS reference_0, l0_.legacy_reference AS legacy_reference_1, l0_.is_published AS is_published_2, l0_.is_pending AS is_pending_3, l0_.title AS title_4, l0_.summary AS summary_5, l0_.address1 AS address1_6, l0_.address2 AS address2_7, l0_.city AS city_8, l0_.region AS region_9, l0_.postcode AS postcode_10, l0_.country AS country_11, l0_.website AS website_12, l0_.contact_name AS contact_name_13, l0_.primary_number AS primary_number_14, l0_.secondary_number AS secondary_number_15, l0_.tertiary_number AS tertiary_number_16, l0_.email AS email_17, l0_.latitude AS latitude_18, l0_.longitude AS longitude_19, l0_.legacy_listing AS legacy_listing_20, l0_.id AS id_21, l0_.uuid AS uuid_22, l0_.created AS created_23, l0_.modified AS modified_24 FROM listings_listing l0_ LEFT JOIN listing_service l2_ ON l0_.id = l2_.listing_id LEFT JOIN services_service s1_ ON s1_.id = l2_.service_id WHERE l0_.is_published = ? AND l0_.country = ? ORDER BY l0_.created DESC) dctrn_result) dctrn_table

Parameters:

[
  1
  "KH"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_21
    FROM
      (
        SELECT
          l0_.reference AS reference_0,
          l0_.legacy_reference AS legacy_reference_1,
          l0_.is_published AS is_published_2,
          l0_.is_pending AS is_pending_3,
          l0_.title AS title_4,
          l0_.summary AS summary_5,
          l0_.address1 AS address1_6,
          l0_.address2 AS address2_7,
          l0_.city AS city_8,
          l0_.region AS region_9,
          l0_.postcode AS postcode_10,
          l0_.country AS country_11,
          l0_.website AS website_12,
          l0_.contact_name AS contact_name_13,
          l0_.primary_number AS primary_number_14,
          l0_.secondary_number AS secondary_number_15,
          l0_.tertiary_number AS tertiary_number_16,
          l0_.email AS email_17,
          l0_.latitude AS latitude_18,
          l0_.longitude AS longitude_19,
          l0_.legacy_listing AS legacy_listing_20,
          l0_.id AS id_21,
          l0_.uuid AS uuid_22,
          l0_.created AS created_23,
          l0_.modified AS modified_24
        FROM
          listings_listing l0_
          LEFT JOIN listing_service l2_ ON l0_.id = l2_.listing_id
          LEFT JOIN services_service s1_ ON s1_.id = l2_.service_id
        WHERE
          l0_.is_published = ?
          AND l0_.country = ?
        ORDER BY
          l0_.created DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_21 FROM (SELECT l0_.reference AS reference_0, l0_.legacy_reference AS legacy_reference_1, l0_.is_published AS is_published_2, l0_.is_pending AS is_pending_3, l0_.title AS title_4, l0_.summary AS summary_5, l0_.address1 AS address1_6, l0_.address2 AS address2_7, l0_.city AS city_8, l0_.region AS region_9, l0_.postcode AS postcode_10, l0_.country AS country_11, l0_.website AS website_12, l0_.contact_name AS contact_name_13, l0_.primary_number AS primary_number_14, l0_.secondary_number AS secondary_number_15, l0_.tertiary_number AS tertiary_number_16, l0_.email AS email_17, l0_.latitude AS latitude_18, l0_.longitude AS longitude_19, l0_.legacy_listing AS legacy_listing_20, l0_.id AS id_21, l0_.uuid AS uuid_22, l0_.created AS created_23, l0_.modified AS modified_24 FROM listings_listing l0_ LEFT JOIN listing_service l2_ ON l0_.id = l2_.listing_id LEFT JOIN services_service s1_ ON s1_.id = l2_.service_id WHERE l0_.is_published = 1 AND l0_.country = 'KH' ORDER BY l0_.created DESC) dctrn_result) 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 1)
8	count (line 43)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	Container0GFx49W\PaginatorProxyBa079e5->paginate (line 338)
16	App\Controller\Frontend\Search\SearchController->search (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

1.27 ms
(27.07%)

SELECT DISTINCT id_21 FROM (SELECT DISTINCT id_21, created_23 FROM (SELECT l0_.reference AS reference_0, l0_.legacy_reference AS legacy_reference_1, l0_.is_published AS is_published_2, l0_.is_pending AS is_pending_3, l0_.title AS title_4, l0_.summary AS summary_5, l0_.address1 AS address1_6, l0_.address2 AS address2_7, l0_.city AS city_8, l0_.region AS region_9, l0_.postcode AS postcode_10, l0_.country AS country_11, l0_.website AS website_12, l0_.contact_name AS contact_name_13, l0_.primary_number AS primary_number_14, l0_.secondary_number AS secondary_number_15, l0_.tertiary_number AS tertiary_number_16, l0_.email AS email_17, l0_.latitude AS latitude_18, l0_.longitude AS longitude_19, l0_.legacy_listing AS legacy_listing_20, l0_.id AS id_21, l0_.uuid AS uuid_22, l0_.created AS created_23, l0_.modified AS modified_24 FROM listings_listing l0_ LEFT JOIN listing_service l2_ ON l0_.id = l2_.listing_id LEFT JOIN services_service s1_ ON s1_.id = l2_.service_id WHERE l0_.is_published = ? AND l0_.country = ?) dctrn_result_inner ORDER BY created_23 DESC) dctrn_result LIMIT 50

Parameters:

[
  1
  "KH"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_21
FROM
  (
    SELECT
      DISTINCT id_21,
      created_23
    FROM
      (
        SELECT
          l0_.reference AS reference_0,
          l0_.legacy_reference AS legacy_reference_1,
          l0_.is_published AS is_published_2,
          l0_.is_pending AS is_pending_3,
          l0_.title AS title_4,
          l0_.summary AS summary_5,
          l0_.address1 AS address1_6,
          l0_.address2 AS address2_7,
          l0_.city AS city_8,
          l0_.region AS region_9,
          l0_.postcode AS postcode_10,
          l0_.country AS country_11,
          l0_.website AS website_12,
          l0_.contact_name AS contact_name_13,
          l0_.primary_number AS primary_number_14,
          l0_.secondary_number AS secondary_number_15,
          l0_.tertiary_number AS tertiary_number_16,
          l0_.email AS email_17,
          l0_.latitude AS latitude_18,
          l0_.longitude AS longitude_19,
          l0_.legacy_listing AS legacy_listing_20,
          l0_.id AS id_21,
          l0_.uuid AS uuid_22,
          l0_.created AS created_23,
          l0_.modified AS modified_24
        FROM
          listings_listing l0_
          LEFT JOIN listing_service l2_ ON l0_.id = l2_.listing_id
          LEFT JOIN services_service s1_ ON s1_.id = l2_.service_id
        WHERE
          l0_.is_published = ?
          AND l0_.country = ?
      ) dctrn_result_inner
    ORDER BY
      created_23 DESC
  ) dctrn_result
LIMIT
  50

SELECT DISTINCT id_21 FROM (SELECT DISTINCT id_21, created_23 FROM (SELECT l0_.reference AS reference_0, l0_.legacy_reference AS legacy_reference_1, l0_.is_published AS is_published_2, l0_.is_pending AS is_pending_3, l0_.title AS title_4, l0_.summary AS summary_5, l0_.address1 AS address1_6, l0_.address2 AS address2_7, l0_.city AS city_8, l0_.region AS region_9, l0_.postcode AS postcode_10, l0_.country AS country_11, l0_.website AS website_12, l0_.contact_name AS contact_name_13, l0_.primary_number AS primary_number_14, l0_.secondary_number AS secondary_number_15, l0_.tertiary_number AS tertiary_number_16, l0_.email AS email_17, l0_.latitude AS latitude_18, l0_.longitude AS longitude_19, l0_.legacy_listing AS legacy_listing_20, l0_.id AS id_21, l0_.uuid AS uuid_22, l0_.created AS created_23, l0_.modified AS modified_24 FROM listings_listing l0_ LEFT JOIN listing_service l2_ ON l0_.id = l2_.listing_id LEFT JOIN services_service s1_ ON s1_.id = l2_.service_id WHERE l0_.is_published = 1 AND l0_.country = 'KH') dctrn_result_inner ORDER BY created_23 DESC) dctrn_result LIMIT 50;

#	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 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	Container0GFx49W\PaginatorProxyBa079e5->paginate (line 338)
16	App\Controller\Frontend\Search\SearchController->search (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

1.20 ms
(25.59%)

SELECT s0_.identifier AS identifier_0, s0_.type AS type_1, s0_.label AS label_2, s0_.value AS value_3, s0_.id AS id_4, s0_.uuid AS uuid_5, s0_.created AS created_6, s0_.modified AS modified_7 FROM system_config s0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.identifier AS identifier_0,
  s0_.type AS type_1,
  s0_.label AS label_2,
  s0_.value AS value_3,
  s0_.id AS id_4,
  s0_.uuid AS uuid_5,
  s0_.created AS created_6,
  s0_.modified AS modified_7
FROM
  system_config s0_

SELECT s0_.identifier AS identifier_0, s0_.type AS type_1, s0_.label AS label_2, s0_.value AS value_3, s0_.id AS id_4, s0_.uuid AS uuid_5, s0_.created AS created_6, s0_.modified AS modified_7 FROM system_config s0_;

#	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 55)
7	WelshDev\DoctrineBaseRepository\BaseRepository->findFiltered (line 22)
8	App\Helper\ConfigHelper->__construct (line 1237)
9	Container0GFx49W\App_KernelDevDebugContainer::getConfigHelperService (line 1253)
10	Container0GFx49W\App_KernelDevDebugContainer::getUtilHelperService (line 2231)
11	Container0GFx49W\App_KernelDevDebugContainer::getTwigService (line 585)
12	Container0GFx49W\App_KernelDevDebugContainer::get_Container_Private_ProfilerService (line 1305)
13	Container0GFx49W\App_KernelDevDebugContainer::getAssetMapper_DevServerSubscriberService (line 994)
14	Container0GFx49W\App_KernelDevDebugContainer::Container0GFx49W\{closure} (line 221)
15	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 70)
16	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 252)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 116)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.74 ms
(15.89%)

SELECT s0_.name AS name_0, s0_.slug AS slug_1, s0_.description AS description_2, s0_.import_matches AS import_matches_3, s0_.id AS id_4, s0_.uuid AS uuid_5, s0_.created AS created_6, s0_.modified AS modified_7 FROM services_service s0_ ORDER BY s0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.name AS name_0,
  s0_.slug AS slug_1,
  s0_.description AS description_2,
  s0_.import_matches AS import_matches_3,
  s0_.id AS id_4,
  s0_.uuid AS uuid_5,
  s0_.created AS created_6,
  s0_.modified AS modified_7
FROM
  services_service s0_
ORDER BY
  s0_.name ASC

SELECT s0_.name AS name_0, s0_.slug AS slug_1, s0_.description AS description_2, s0_.import_matches AS import_matches_3, s0_.id AS id_4, s0_.uuid AS uuid_5, s0_.created AS created_6, s0_.modified AS modified_7 FROM services_service s0_ ORDER BY s0_.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 55)
7	WelshDev\DoctrineBaseRepository\BaseRepository->findFiltered (line 140)
8	App\Controller\Frontend\Search\SearchController->search (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	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\System\Config\Config	No errors.
App\Entity\Services\Service	No errors.
App\Entity\Listings\Listing	No errors.

Symfony Profiler

GET https://varsity.cwd-dev.com/search/cambodia

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping