Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

17.32 ms Query time

0 Invalid entities

2 Managed entities

Queries

Group similar statements

#▲

Time

Info

16.94 ms

SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.updated_at AS updated_at_2, p0_.slug AS slug_3, p0_.departements AS departements_4, p0_.name AS name_5, p0_.lastname AS lastname_6, p0_.enterprise_name AS enterprise_name_7, p0_.email AS email_8, p0_.address AS address_9, p0_.zipcode AS zipcode_10, p0_.city AS city_11, p0_.country AS country_12, p0_.note AS note_13, p0_.phone AS phone_14, p0_.rayon AS rayon_15, p0_.point_x AS point_x_16, p0_.point_y AS point_y_17, p0_.cgu AS cgu_18, p0_.agessa AS agessa_19, p0_.numero_agessa AS numero_agessa_20, p0_.tva AS tva_21, p0_.skill_apnfisheye AS skill_apnfisheye_22, p0_.skill_matterport AS skill_matterport_23, p0_.skill_streetviewvoiture AS skill_streetviewvoiture_24, p0_.skill_reportagephotos AS skill_reportagephotos_25, p0_.skill_portrait AS skill_portrait_26, p0_.skill_shootinglifestyle AS skill_shootinglifestyle_27, p0_.skill_dronephoto AS skill_dronephoto_28, p0_.skill_drone360 AS skill_drone360_29, p0_.skill_dronefpvindoor AS skill_dronefpvindoor_30, p0_.cgu_acceptedAt AS cgu_acceptedAt_31, p0_.actif AS actif_32, p0_.rib AS rib_33, p0_.message AS message_34, p0_.image_name AS image_name_35, p0_.image_original_name AS image_original_name_36, p0_.image_mime_type AS image_mime_type_37, p0_.image_size AS image_size_38, p0_.image_dimensions AS image_dimensions_39 FROM photographe p0_ WHERE p0_.actif = 1 ORDER BY p0_.id ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.created_at AS created_at_1,
  p0_.updated_at AS updated_at_2,
  p0_.slug AS slug_3,
  p0_.departements AS departements_4,
  p0_.name AS name_5,
  p0_.lastname AS lastname_6,
  p0_.enterprise_name AS enterprise_name_7,
  p0_.email AS email_8,
  p0_.address AS address_9,
  p0_.zipcode AS zipcode_10,
  p0_.city AS city_11,
  p0_.country AS country_12,
  p0_.note AS note_13,
  p0_.phone AS phone_14,
  p0_.rayon AS rayon_15,
  p0_.point_x AS point_x_16,
  p0_.point_y AS point_y_17,
  p0_.cgu AS cgu_18,
  p0_.agessa AS agessa_19,
  p0_.numero_agessa AS numero_agessa_20,
  p0_.tva AS tva_21,
  p0_.skill_apnfisheye AS skill_apnfisheye_22,
  p0_.skill_matterport AS skill_matterport_23,
  p0_.skill_streetviewvoiture AS skill_streetviewvoiture_24,
  p0_.skill_reportagephotos AS skill_reportagephotos_25,
  p0_.skill_portrait AS skill_portrait_26,
  p0_.skill_shootinglifestyle AS skill_shootinglifestyle_27,
  p0_.skill_dronephoto AS skill_dronephoto_28,
  p0_.skill_drone360 AS skill_drone360_29,
  p0_.skill_dronefpvindoor AS skill_dronefpvindoor_30,
  p0_.cgu_acceptedAt AS cgu_acceptedAt_31,
  p0_.actif AS actif_32,
  p0_.rib AS rib_33,
  p0_.message AS message_34,
  p0_.image_name AS image_name_35,
  p0_.image_original_name AS image_original_name_36,
  p0_.image_mime_type AS image_mime_type_37,
  p0_.image_size AS image_size_38,
  p0_.image_dimensions AS image_dimensions_39
FROM
  photographe p0_
WHERE
  p0_.actif = 1
ORDER BY
  p0_.id ASC

SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.updated_at AS updated_at_2, p0_.slug AS slug_3, p0_.departements AS departements_4, p0_.name AS name_5, p0_.lastname AS lastname_6, p0_.enterprise_name AS enterprise_name_7, p0_.email AS email_8, p0_.address AS address_9, p0_.zipcode AS zipcode_10, p0_.city AS city_11, p0_.country AS country_12, p0_.note AS note_13, p0_.phone AS phone_14, p0_.rayon AS rayon_15, p0_.point_x AS point_x_16, p0_.point_y AS point_y_17, p0_.cgu AS cgu_18, p0_.agessa AS agessa_19, p0_.numero_agessa AS numero_agessa_20, p0_.tva AS tva_21, p0_.skill_apnfisheye AS skill_apnfisheye_22, p0_.skill_matterport AS skill_matterport_23, p0_.skill_streetviewvoiture AS skill_streetviewvoiture_24, p0_.skill_reportagephotos AS skill_reportagephotos_25, p0_.skill_portrait AS skill_portrait_26, p0_.skill_shootinglifestyle AS skill_shootinglifestyle_27, p0_.skill_dronephoto AS skill_dronephoto_28, p0_.skill_drone360 AS skill_drone360_29, p0_.skill_dronefpvindoor AS skill_dronefpvindoor_30, p0_.cgu_acceptedAt AS cgu_acceptedAt_31, p0_.actif AS actif_32, p0_.rib AS rib_33, p0_.message AS message_34, p0_.image_name AS image_name_35, p0_.image_original_name AS image_original_name_36, p0_.image_mime_type AS image_mime_type_37, p0_.image_size AS image_size_38, p0_.image_dimensions AS image_dimensions_39 FROM photographe p0_ WHERE p0_.actif = 1 ORDER BY p0_.id ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	App\Repository\PhotographeRepository->searchByCityAndDepartment (line 425)
7	App\Controller\Visitors\HomepageController->homepage (line 61)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 208)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.38 ms

SELECT DISTINCT p0_.city AS city_0 FROM photographe p0_ WHERE p0_.city IS NOT NULL AND p0_.actif = 1 ORDER BY p0_.city ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.city AS city_0
FROM
  photographe p0_
WHERE
  p0_.city IS NOT NULL
  AND p0_.actif = 1
ORDER BY
  p0_.city ASC

SELECT DISTINCT p0_.city AS city_0 FROM photographe p0_ WHERE p0_.city IS NOT NULL AND p0_.actif = 1 ORDER BY p0_.city ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	App\Repository\PhotographeRepository->getDistinctCities (line 274)
7	App\Controller\Visitors\HomepageController->homepage (line 63)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 208)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Photographe	2

Entities Mapping

Class	Mapping errors
Vich\UploaderBundle\Entity\File	No errors.
App\Entity\Photographe	No errors.

Symfony Profiler

GET https://devp.visitme360.com/

Configuration Settings

Theme

Page Width