Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

203.05 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

199.80 ms
(98.40%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM country t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3
FROM
  country t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM country t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 36)
6	App\Controller\NearestStoreController->findNearestStore (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

3.25 ms
(1.60%)

SELECT f0_.id AS id_0, f0_.franchise_name AS franchise_name_1, f0_.calling_number AS calling_number_2, f0_.whatsapp_number AS whatsapp_number_3, f0_.address AS address_4, f0_.googlemap_link AS googlemap_link_5, f0_.insta_id_link AS insta_id_link_6, f0_.website_link AS website_link_7, f0_.latitude AS latitude_8, f0_.longitude AS longitude_9, f0_.visit_page AS visit_page_10, f0_.fon AS fon_11, f0_.country_id AS country_id_12, f0_.state_id AS state_id_13, f0_.city_id AS city_id_14, f0_.area_id AS area_id_15 FROM franchise f0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.franchise_name AS franchise_name_1,
  f0_.calling_number AS calling_number_2,
  f0_.whatsapp_number AS whatsapp_number_3,
  f0_.address AS address_4,
  f0_.googlemap_link AS googlemap_link_5,
  f0_.insta_id_link AS insta_id_link_6,
  f0_.website_link AS website_link_7,
  f0_.latitude AS latitude_8,
  f0_.longitude AS longitude_9,
  f0_.visit_page AS visit_page_10,
  f0_.fon AS fon_11,
  f0_.country_id AS country_id_12,
  f0_.state_id AS state_id_13,
  f0_.city_id AS city_id_14,
  f0_.area_id AS area_id_15
FROM
  franchise f0_

SELECT f0_.id AS id_0, f0_.franchise_name AS franchise_name_1, f0_.calling_number AS calling_number_2, f0_.whatsapp_number AS whatsapp_number_3, f0_.address AS address_4, f0_.googlemap_link AS googlemap_link_5, f0_.insta_id_link AS insta_id_link_6, f0_.website_link AS website_link_7, f0_.latitude AS latitude_8, f0_.longitude AS longitude_9, f0_.visit_page AS visit_page_10, f0_.fon AS fon_11, f0_.country_id AS country_id_12, f0_.state_id AS state_id_13, f0_.city_id AS city_id_14, f0_.area_id AS area_id_15 FROM franchise f0_;

#	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 72)
7	App\Controller\NearestStoreController->findNearestStore (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	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\Country	No errors.
App\Entity\Franchise	No errors.
App\Entity\State	No errors.
App\Entity\City	No errors.
App\Entity\Area	No errors.

Symfony Profiler

GET https://www.pleatsanddrapes.in/find-nearest-store

Configuration Settings

Theme