Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

0.96 ms Query time

0 Invalid entities

4 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.45 ms

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.username AS username_4, t0.email AS email_5, t0.password AS password_6, t0.name AS name_7, t0.lastname AS lastname_8, t0.phone AS phone_9, t0.password_key AS password_key_10, t0.password_expired_at AS password_expired_at_11, t0.roles AS roles_12, t0.is_verified AS is_verified_13, t0.is_enabled AS is_enabled_14, t0.is_first AS is_first_15, t0.admin_id AS admin_id_16 FROM users t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.username AS username_4,
  t0.email AS email_5,
  t0.password AS password_6,
  t0.name AS name_7,
  t0.lastname AS lastname_8,
  t0.phone AS phone_9,
  t0.password_key AS password_key_10,
  t0.password_expired_at AS password_expired_at_11,
  t0.roles AS roles_12,
  t0.is_verified AS is_verified_13,
  t0.is_enabled AS is_enabled_14,
  t0.is_first AS is_first_15,
  t0.admin_id AS admin_id_16
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.username AS username_4, t0.email AS email_5, t0.password AS password_6, t0.name AS name_7, t0.lastname AS lastname_8, t0.phone AS phone_9, t0.password_key AS password_key_10, t0.password_expired_at AS password_expired_at_11, t0.roles AS roles_12, t0.is_verified AS is_verified_13, t0.is_enabled AS is_enabled_14, t0.is_first AS is_first_15, t0.admin_id AS admin_id_16 FROM users t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\EntityManager->find (line 530)
4	Doctrine\ORM\EntityRepository->find (line 196)
5	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
6	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 214)
7	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 131)
8	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 60)
10	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 80)
11	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 208)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.25 ms

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM photographe p0_ WHERE (6371000 * acos(cos(radians(?)) * cos(radians(p0_.point_x)) * cos(radians(p0_.point_y) - radians(?)) + sin(radians(?)) * sin(radians(p0_.point_x)))) <= ? AND p0_.actif = ?

Parameters:

[
  46.78
  2.43
  46.78
  677606.77131185
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0
FROM
  photographe p0_
WHERE
  (
    6371000 * acos(
      cos(
        radians(?)
      ) * cos(
        radians(p0_.point_x)
      ) * cos(
        radians(p0_.point_y) - radians(?)
      ) + sin(
        radians(?)
      ) * sin(
        radians(p0_.point_x)
      )
    )
  ) <= ?
  AND p0_.actif = ?

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM photographe p0_ WHERE (6371000 * acos(cos(radians(46.78)) * cos(radians(p0_.point_x)) * cos(radians(p0_.point_y) - radians(2.43)) + sin(radians(46.78)) * sin(radians(p0_.point_x)))) <= 677606.77131185 AND p0_.actif = 1;

#	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->getSingleResult (line 996)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 1025)
7	App\Repository\PhotographeRepository->searchPinsByTerm (line 176)
8	App\Controller\Backoffice\Photographes\DashboardController->searchListing (line 255)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 208)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.26 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_.region AS region_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 (6371000 * acos(cos(radians(?)) * cos(radians(p0_.point_x)) * cos(radians(p0_.point_y) - radians(?)) + sin(radians(?)) * sin(radians(p0_.point_x)))) <= ? AND p0_.actif = ? GROUP BY p0_.id ORDER BY p0_.id DESC LIMIT 50

Parameters:

[
  46.78
  2.43
  46.78
  677606.77131185
  1
]

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_.region AS region_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
  (
    6371000 * acos(
      cos(
        radians(?)
      ) * cos(
        radians(p0_.point_x)
      ) * cos(
        radians(p0_.point_y) - radians(?)
      ) + sin(
        radians(?)
      ) * sin(
        radians(p0_.point_x)
      )
    )
  ) <= ?
  AND p0_.actif = ?
GROUP BY
  p0_.id
ORDER BY
  p0_.id DESC
LIMIT
  50

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_.region AS region_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 (6371000 * acos(cos(radians(46.78)) * cos(radians(p0_.point_x)) * cos(radians(p0_.point_y) - radians(2.43)) + sin(radians(46.78)) * sin(radians(p0_.point_x)))) <= 677606.77131185 AND p0_.actif = 1 GROUP BY p0_.id ORDER BY p0_.id DESC LIMIT 50;

#	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->searchPinsByTerm (line 179)
7	App\Controller\Backoffice\Photographes\DashboardController->searchListing (line 256)
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
App\Entity\Users	1
App\Entity\Admin	1

Entities Mapping

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

Symfony Profiler

GET https://devp.visitme360.com/administration/photographes/search-listing?actif=true&currentPage=1&direction=DESC&latitude=46.78&longitude=2.43&nonactif=false&radi…

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping