Symfony Profiler

Query Metrics

9 Database Queries

6 Different statements

17.78 ms Query time

0 Invalid entities

454 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

7.93 ms
(44.58%)

SELECT s0_.id AS id_0, s0_.cartatout_shop_id AS cartatout_shop_id_1, s0_.address AS address_2, s0_.city AS city_3, s0_.zip_code AS zip_code_4, s0_.tel AS tel_5, s0_.email AS email_6, s0_.latitude AS latitude_7, s0_.longitude AS longitude_8, s0_.website AS website_9, s0_.zone_geo AS zone_geo_10, s0_.opening_hours AS opening_hours_11, s0_.is_active AS is_active_12, s0_.payload_hash AS payload_hash_13, s0_.last_synced_at AS last_synced_at_14, p1_.id AS id_15, p1_.cartatout_partner_id AS cartatout_partner_id_16, p1_.name AS name_17, p1_.slogan AS slogan_18, p1_.category AS category_19, p1_.discount_percent AS discount_percent_20, p1_.legal_notice AS legal_notice_21, p1_.logo_url AS logo_url_22, p1_.cover_url AS cover_url_23, p1_.presentation AS presentation_24, p1_.region AS region_25, p1_.is_active AS is_active_26, p1_.payload_hash AS payload_hash_27, p1_.last_synced_at AS last_synced_at_28, p1_.created_at AS created_at_29, p1_.updated_at AS updated_at_30, p1_.gallery_urls AS gallery_urls_31, s0_.partner_id AS partner_id_32 FROM shops s0_ INNER JOIN partners p1_ ON s0_.partner_id = p1_.id WHERE s0_.is_active = ? AND p1_.is_active = ? AND s0_.latitude IS NOT NULL AND s0_.longitude IS NOT NULL

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.cartatout_shop_id AS cartatout_shop_id_1,
  s0_.address AS address_2,
  s0_.city AS city_3,
  s0_.zip_code AS zip_code_4,
  s0_.tel AS tel_5,
  s0_.email AS email_6,
  s0_.latitude AS latitude_7,
  s0_.longitude AS longitude_8,
  s0_.website AS website_9,
  s0_.zone_geo AS zone_geo_10,
  s0_.opening_hours AS opening_hours_11,
  s0_.is_active AS is_active_12,
  s0_.payload_hash AS payload_hash_13,
  s0_.last_synced_at AS last_synced_at_14,
  p1_.id AS id_15,
  p1_.cartatout_partner_id AS cartatout_partner_id_16,
  p1_.name AS name_17,
  p1_.slogan AS slogan_18,
  p1_.category AS category_19,
  p1_.discount_percent AS discount_percent_20,
  p1_.legal_notice AS legal_notice_21,
  p1_.logo_url AS logo_url_22,
  p1_.cover_url AS cover_url_23,
  p1_.presentation AS presentation_24,
  p1_.region AS region_25,
  p1_.is_active AS is_active_26,
  p1_.payload_hash AS payload_hash_27,
  p1_.last_synced_at AS last_synced_at_28,
  p1_.created_at AS created_at_29,
  p1_.updated_at AS updated_at_30,
  p1_.gallery_urls AS gallery_urls_31,
  s0_.partner_id AS partner_id_32
FROM
  shops s0_
  INNER JOIN partners p1_ ON s0_.partner_id = p1_.id
WHERE
  s0_.is_active = ?
  AND p1_.is_active = ?
  AND s0_.latitude IS NOT NULL
  AND s0_.longitude IS NOT NULL

SELECT s0_.id AS id_0, s0_.cartatout_shop_id AS cartatout_shop_id_1, s0_.address AS address_2, s0_.city AS city_3, s0_.zip_code AS zip_code_4, s0_.tel AS tel_5, s0_.email AS email_6, s0_.latitude AS latitude_7, s0_.longitude AS longitude_8, s0_.website AS website_9, s0_.zone_geo AS zone_geo_10, s0_.opening_hours AS opening_hours_11, s0_.is_active AS is_active_12, s0_.payload_hash AS payload_hash_13, s0_.last_synced_at AS last_synced_at_14, p1_.id AS id_15, p1_.cartatout_partner_id AS cartatout_partner_id_16, p1_.name AS name_17, p1_.slogan AS slogan_18, p1_.category AS category_19, p1_.discount_percent AS discount_percent_20, p1_.legal_notice AS legal_notice_21, p1_.logo_url AS logo_url_22, p1_.cover_url AS cover_url_23, p1_.presentation AS presentation_24, p1_.region AS region_25, p1_.is_active AS is_active_26, p1_.payload_hash AS payload_hash_27, p1_.last_synced_at AS last_synced_at_28, p1_.created_at AS created_at_29, p1_.updated_at AS updated_at_30, p1_.gallery_urls AS gallery_urls_31, s0_.partner_id AS partner_id_32 FROM shops s0_ INNER JOIN partners p1_ ON s0_.partner_id = p1_.id WHERE s0_.is_active = 1 AND p1_.is_active = 1 AND s0_.latitude IS NOT NULL AND s0_.longitude IS NOT NULL;

#	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\Repository\ShopRepository->findActiveByDestinationArea (line 239)
7	App\Controller\HomeController->index (line 113)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

5.91 ms
(33.21%)

SELECT t0.id AS id_1, t0.cartatout_country_id AS cartatout_country_id_2, t0.lang AS lang_3, t0.label AS label_4, t0.code AS code_5, t0.image_url AS image_url_6, t0.center_lat AS center_lat_7, t0.center_lng AS center_lng_8, t0.geojson AS geojson_9, t0.ticketing_url AS ticketing_url_10, t0.ticketing_image_url AS ticketing_image_url_11, t0.is_active AS is_active_12, t0.payload_hash AS payload_hash_13, t0.last_synced_at AS last_synced_at_14, t0.updated_at AS updated_at_15 FROM countries t0 WHERE t0.is_active = ? AND t0.lang = ?

Parameters:

[
  1
  "fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.cartatout_country_id AS cartatout_country_id_2,
  t0.lang AS lang_3,
  t0.label AS label_4,
  t0.code AS code_5,
  t0.image_url AS image_url_6,
  t0.center_lat AS center_lat_7,
  t0.center_lng AS center_lng_8,
  t0.geojson AS geojson_9,
  t0.ticketing_url AS ticketing_url_10,
  t0.ticketing_image_url AS ticketing_image_url_11,
  t0.is_active AS is_active_12,
  t0.payload_hash AS payload_hash_13,
  t0.last_synced_at AS last_synced_at_14,
  t0.updated_at AS updated_at_15
FROM
  countries t0
WHERE
  t0.is_active = ?
  AND t0.lang = ?

SELECT t0.id AS id_1, t0.cartatout_country_id AS cartatout_country_id_2, t0.lang AS lang_3, t0.label AS label_4, t0.code AS code_5, t0.image_url AS image_url_6, t0.center_lat AS center_lat_7, t0.center_lng AS center_lng_8, t0.geojson AS geojson_9, t0.ticketing_url AS ticketing_url_10, t0.ticketing_image_url AS ticketing_image_url_11, t0.is_active AS is_active_12, t0.payload_hash AS payload_hash_13, t0.last_synced_at AS last_synced_at_14, t0.updated_at AS updated_at_15 FROM countries t0 WHERE t0.is_active = 1 AND t0.lang = 'fr';

#	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	App\Controller\HomeController->index (line 34)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

1.27 ms
(7.14%)

SELECT t0.id AS id_1, t0.cartatout_partner_id AS cartatout_partner_id_2, t0.name AS name_3, t0.slogan AS slogan_4, t0.category AS category_5, t0.discount_percent AS discount_percent_6, t0.legal_notice AS legal_notice_7, t0.logo_url AS logo_url_8, t0.cover_url AS cover_url_9, t0.presentation AS presentation_10, t0.region AS region_11, t0.is_active AS is_active_12, t0.payload_hash AS payload_hash_13, t0.last_synced_at AS last_synced_at_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.gallery_urls AS gallery_urls_17 FROM partners t0 WHERE t0.id = ?

Parameters:

[
  "941"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.cartatout_partner_id AS cartatout_partner_id_2,
  t0.name AS name_3,
  t0.slogan AS slogan_4,
  t0.category AS category_5,
  t0.discount_percent AS discount_percent_6,
  t0.legal_notice AS legal_notice_7,
  t0.logo_url AS logo_url_8,
  t0.cover_url AS cover_url_9,
  t0.presentation AS presentation_10,
  t0.region AS region_11,
  t0.is_active AS is_active_12,
  t0.payload_hash AS payload_hash_13,
  t0.last_synced_at AS last_synced_at_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.gallery_urls AS gallery_urls_17
FROM
  partners t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.cartatout_partner_id AS cartatout_partner_id_2, t0.name AS name_3, t0.slogan AS slogan_4, t0.category AS category_5, t0.discount_percent AS discount_percent_6, t0.legal_notice AS legal_notice_7, t0.logo_url AS logo_url_8, t0.cover_url AS cover_url_9, t0.presentation AS presentation_10, t0.region AS region_11, t0.is_active AS is_active_12, t0.payload_hash AS payload_hash_13, t0.last_synced_at AS last_synced_at_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.gallery_urls AS gallery_urls_17 FROM partners t0 WHERE t0.id = '941';

#	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	App\Controller\HomeController->App\Controller\{closure} (line 229)
7	array_map (line 226)
8	App\Controller\HomeController::index (line 226)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

1.10 ms
(6.20%)

SELECT t0.id AS id_1, t0.cartatout_shop_id AS cartatout_shop_id_2, t0.address AS address_3, t0.city AS city_4, t0.zip_code AS zip_code_5, t0.tel AS tel_6, t0.email AS email_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.website AS website_10, t0.zone_geo AS zone_geo_11, t0.opening_hours AS opening_hours_12, t0.is_active AS is_active_13, t0.payload_hash AS payload_hash_14, t0.last_synced_at AS last_synced_at_15, t0.partner_id AS partner_id_16 FROM shops t0 WHERE t0.partner_id = ? LIMIT 1

Parameters:

[
  45
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.cartatout_shop_id AS cartatout_shop_id_2,
  t0.address AS address_3,
  t0.city AS city_4,
  t0.zip_code AS zip_code_5,
  t0.tel AS tel_6,
  t0.email AS email_7,
  t0.latitude AS latitude_8,
  t0.longitude AS longitude_9,
  t0.website AS website_10,
  t0.zone_geo AS zone_geo_11,
  t0.opening_hours AS opening_hours_12,
  t0.is_active AS is_active_13,
  t0.payload_hash AS payload_hash_14,
  t0.last_synced_at AS last_synced_at_15,
  t0.partner_id AS partner_id_16
FROM
  shops t0
WHERE
  t0.partner_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.cartatout_shop_id AS cartatout_shop_id_2, t0.address AS address_3, t0.city AS city_4, t0.zip_code AS zip_code_5, t0.tel AS tel_6, t0.email AS email_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.website AS website_10, t0.zone_geo AS zone_geo_11, t0.opening_hours AS opening_hours_12, t0.is_active AS is_active_13, t0.payload_hash AS payload_hash_14, t0.last_synced_at AS last_synced_at_15, t0.partner_id AS partner_id_16 FROM shops t0 WHERE t0.partner_id = 45 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\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\HomeController->App\Controller\{closure} (line 292)
5	array_map (line 251)
6	App\Controller\HomeController::index (line 251)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.94 ms
(5.28%)

SELECT t0.id AS id_1, t0.cartatout_partner_id AS cartatout_partner_id_2, t0.name AS name_3, t0.slogan AS slogan_4, t0.category AS category_5, t0.discount_percent AS discount_percent_6, t0.legal_notice AS legal_notice_7, t0.logo_url AS logo_url_8, t0.cover_url AS cover_url_9, t0.presentation AS presentation_10, t0.region AS region_11, t0.is_active AS is_active_12, t0.payload_hash AS payload_hash_13, t0.last_synced_at AS last_synced_at_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.gallery_urls AS gallery_urls_17 FROM partners t0 WHERE t0.cartatout_partner_id = ? LIMIT 1

Parameters:

[
  "941"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.cartatout_partner_id AS cartatout_partner_id_2,
  t0.name AS name_3,
  t0.slogan AS slogan_4,
  t0.category AS category_5,
  t0.discount_percent AS discount_percent_6,
  t0.legal_notice AS legal_notice_7,
  t0.logo_url AS logo_url_8,
  t0.cover_url AS cover_url_9,
  t0.presentation AS presentation_10,
  t0.region AS region_11,
  t0.is_active AS is_active_12,
  t0.payload_hash AS payload_hash_13,
  t0.last_synced_at AS last_synced_at_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.gallery_urls AS gallery_urls_17
FROM
  partners t0
WHERE
  t0.cartatout_partner_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.cartatout_partner_id AS cartatout_partner_id_2, t0.name AS name_3, t0.slogan AS slogan_4, t0.category AS category_5, t0.discount_percent AS discount_percent_6, t0.legal_notice AS legal_notice_7, t0.logo_url AS logo_url_8, t0.cover_url AS cover_url_9, t0.presentation AS presentation_10, t0.region AS region_11, t0.is_active AS is_active_12, t0.payload_hash AS payload_hash_13, t0.last_synced_at AS last_synced_at_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.gallery_urls AS gallery_urls_17 FROM partners t0 WHERE t0.cartatout_partner_id = '941' 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\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\HomeController->App\Controller\{closure} (line 258)
5	array_map (line 251)
6	App\Controller\HomeController::index (line 251)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.64 ms
(3.59%)

SELECT t0.id AS id_1, t0.cartatout_country_id AS cartatout_country_id_2, t0.lang AS lang_3, t0.label AS label_4, t0.code AS code_5, t0.image_url AS image_url_6, t0.center_lat AS center_lat_7, t0.center_lng AS center_lng_8, t0.geojson AS geojson_9, t0.ticketing_url AS ticketing_url_10, t0.ticketing_image_url AS ticketing_image_url_11, t0.is_active AS is_active_12, t0.payload_hash AS payload_hash_13, t0.last_synced_at AS last_synced_at_14, t0.updated_at AS updated_at_15 FROM countries t0 WHERE t0.cartatout_country_id = ? AND t0.lang = ? LIMIT 1

Parameters:

[
  "3"
  "fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.cartatout_country_id AS cartatout_country_id_2,
  t0.lang AS lang_3,
  t0.label AS label_4,
  t0.code AS code_5,
  t0.image_url AS image_url_6,
  t0.center_lat AS center_lat_7,
  t0.center_lng AS center_lng_8,
  t0.geojson AS geojson_9,
  t0.ticketing_url AS ticketing_url_10,
  t0.ticketing_image_url AS ticketing_image_url_11,
  t0.is_active AS is_active_12,
  t0.payload_hash AS payload_hash_13,
  t0.last_synced_at AS last_synced_at_14,
  t0.updated_at AS updated_at_15
FROM
  countries t0
WHERE
  t0.cartatout_country_id = ?
  AND t0.lang = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.cartatout_country_id AS cartatout_country_id_2, t0.lang AS lang_3, t0.label AS label_4, t0.code AS code_5, t0.image_url AS image_url_6, t0.center_lat AS center_lat_7, t0.center_lng AS center_lng_8, t0.geojson AS geojson_9, t0.ticketing_url AS ticketing_url_10, t0.ticketing_image_url AS ticketing_image_url_11, t0.is_active AS is_active_12, t0.payload_hash AS payload_hash_13, t0.last_synced_at AS last_synced_at_14, t0.updated_at AS updated_at_15 FROM countries t0 WHERE t0.cartatout_country_id = '3' AND t0.lang = 'fr' 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\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\HomeController->index (line 60)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	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\Shop	257
App\Entity\Partner	194
App\Entity\Country	3

Entities Mapping

Class	Mapping errors
App\Entity\Country	No errors.
App\Entity\Shop	No errors.
App\Entity\Partner	No errors.

Symfony Profiler

GET https://app.smiilecard.com/fr?country=3

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping