Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

35.97 ms Query time

0 Invalid entities

44 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

20.30 ms
(56.43%)

SELECT p0_.id AS id_0, p0_.uuid_for_url AS uuid_for_url_1, p0_.osm_kind AS osm_kind_2, p0_.email AS email_3, p0_.opted_out AS opted_out_4, p0_.dead AS dead_5, p0_.note AS note_6, p0_.modified_date AS modified_date_7, p0_.zip_code AS zip_code_8, p0_.asked_humains_support AS asked_humains_support_9, p0_.last_contact_attempt_date AS last_contact_attempt_date_10, p0_.osm_id AS osm_id_11, p0_.name AS name_12, p0_.has_opening_hours AS has_opening_hours_13, p0_.has_address AS has_address_14, p0_.has_website AS has_website_15, p0_.has_wheelchair AS has_wheelchair_16, p0_.has_note AS has_note_17, p0_.main_tag AS main_tag_18, p0_.note_content AS note_content_19, p0_.displayed_date AS displayed_date_20, p0_.lat AS lat_21, p0_.lon AS lon_22, p0_.street AS street_23, p0_.housenumber AS housenumber_24, p0_.siret AS siret_25, p0_.stats_id AS stats_id_26 FROM place p0_ WHERE p0_.modified_date IS NOT NULL ORDER BY p0_.modified_date DESC LIMIT 20

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.uuid_for_url AS uuid_for_url_1,
  p0_.osm_kind AS osm_kind_2,
  p0_.email AS email_3,
  p0_.opted_out AS opted_out_4,
  p0_.dead AS dead_5,
  p0_.note AS note_6,
  p0_.modified_date AS modified_date_7,
  p0_.zip_code AS zip_code_8,
  p0_.asked_humains_support AS asked_humains_support_9,
  p0_.last_contact_attempt_date AS last_contact_attempt_date_10,
  p0_.osm_id AS osm_id_11,
  p0_.name AS name_12,
  p0_.has_opening_hours AS has_opening_hours_13,
  p0_.has_address AS has_address_14,
  p0_.has_website AS has_website_15,
  p0_.has_wheelchair AS has_wheelchair_16,
  p0_.has_note AS has_note_17,
  p0_.main_tag AS main_tag_18,
  p0_.note_content AS note_content_19,
  p0_.displayed_date AS displayed_date_20,
  p0_.lat AS lat_21,
  p0_.lon AS lon_22,
  p0_.street AS street_23,
  p0_.housenumber AS housenumber_24,
  p0_.siret AS siret_25,
  p0_.stats_id AS stats_id_26
FROM
  place p0_
WHERE
  p0_.modified_date IS NOT NULL
ORDER BY
  p0_.modified_date DESC
LIMIT
  20

SELECT p0_.id AS id_0, p0_.uuid_for_url AS uuid_for_url_1, p0_.osm_kind AS osm_kind_2, p0_.email AS email_3, p0_.opted_out AS opted_out_4, p0_.dead AS dead_5, p0_.note AS note_6, p0_.modified_date AS modified_date_7, p0_.zip_code AS zip_code_8, p0_.asked_humains_support AS asked_humains_support_9, p0_.last_contact_attempt_date AS last_contact_attempt_date_10, p0_.osm_id AS osm_id_11, p0_.name AS name_12, p0_.has_opening_hours AS has_opening_hours_13, p0_.has_address AS has_address_14, p0_.has_website AS has_website_15, p0_.has_wheelchair AS has_wheelchair_16, p0_.has_note AS has_note_17, p0_.main_tag AS main_tag_18, p0_.note_content AS note_content_19, p0_.displayed_date AS displayed_date_20, p0_.lat AS lat_21, p0_.lon AS lon_22, p0_.street AS street_23, p0_.housenumber AS housenumber_24, p0_.siret AS siret_25, p0_.stats_id AS stats_id_26 FROM place p0_ WHERE p0_.modified_date IS NOT NULL ORDER BY p0_.modified_date DESC LIMIT 20;

#	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 450)
7	App\Controller\PublicController->latestChanges (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

15.67 ms
(43.57%)

SELECT p0_.id AS id_0, p0_.uuid_for_url AS uuid_for_url_1, p0_.osm_kind AS osm_kind_2, p0_.email AS email_3, p0_.opted_out AS opted_out_4, p0_.dead AS dead_5, p0_.note AS note_6, p0_.modified_date AS modified_date_7, p0_.zip_code AS zip_code_8, p0_.asked_humains_support AS asked_humains_support_9, p0_.last_contact_attempt_date AS last_contact_attempt_date_10, p0_.osm_id AS osm_id_11, p0_.name AS name_12, p0_.has_opening_hours AS has_opening_hours_13, p0_.has_address AS has_address_14, p0_.has_website AS has_website_15, p0_.has_wheelchair AS has_wheelchair_16, p0_.has_note AS has_note_17, p0_.main_tag AS main_tag_18, p0_.note_content AS note_content_19, p0_.displayed_date AS displayed_date_20, p0_.lat AS lat_21, p0_.lon AS lon_22, p0_.street AS street_23, p0_.housenumber AS housenumber_24, p0_.siret AS siret_25, p0_.stats_id AS stats_id_26 FROM place p0_ WHERE p0_.displayed_date IS NOT NULL ORDER BY p0_.displayed_date DESC LIMIT 20

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.uuid_for_url AS uuid_for_url_1,
  p0_.osm_kind AS osm_kind_2,
  p0_.email AS email_3,
  p0_.opted_out AS opted_out_4,
  p0_.dead AS dead_5,
  p0_.note AS note_6,
  p0_.modified_date AS modified_date_7,
  p0_.zip_code AS zip_code_8,
  p0_.asked_humains_support AS asked_humains_support_9,
  p0_.last_contact_attempt_date AS last_contact_attempt_date_10,
  p0_.osm_id AS osm_id_11,
  p0_.name AS name_12,
  p0_.has_opening_hours AS has_opening_hours_13,
  p0_.has_address AS has_address_14,
  p0_.has_website AS has_website_15,
  p0_.has_wheelchair AS has_wheelchair_16,
  p0_.has_note AS has_note_17,
  p0_.main_tag AS main_tag_18,
  p0_.note_content AS note_content_19,
  p0_.displayed_date AS displayed_date_20,
  p0_.lat AS lat_21,
  p0_.lon AS lon_22,
  p0_.street AS street_23,
  p0_.housenumber AS housenumber_24,
  p0_.siret AS siret_25,
  p0_.stats_id AS stats_id_26
FROM
  place p0_
WHERE
  p0_.displayed_date IS NOT NULL
ORDER BY
  p0_.displayed_date DESC
LIMIT
  20

SELECT p0_.id AS id_0, p0_.uuid_for_url AS uuid_for_url_1, p0_.osm_kind AS osm_kind_2, p0_.email AS email_3, p0_.opted_out AS opted_out_4, p0_.dead AS dead_5, p0_.note AS note_6, p0_.modified_date AS modified_date_7, p0_.zip_code AS zip_code_8, p0_.asked_humains_support AS asked_humains_support_9, p0_.last_contact_attempt_date AS last_contact_attempt_date_10, p0_.osm_id AS osm_id_11, p0_.name AS name_12, p0_.has_opening_hours AS has_opening_hours_13, p0_.has_address AS has_address_14, p0_.has_website AS has_website_15, p0_.has_wheelchair AS has_wheelchair_16, p0_.has_note AS has_note_17, p0_.main_tag AS main_tag_18, p0_.note_content AS note_content_19, p0_.displayed_date AS displayed_date_20, p0_.lat AS lat_21, p0_.lon AS lon_22, p0_.street AS street_23, p0_.housenumber AS housenumber_24, p0_.siret AS siret_25, p0_.stats_id AS stats_id_26 FROM place p0_ WHERE p0_.displayed_date IS NOT NULL ORDER BY p0_.displayed_date DESC LIMIT 20;

#	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 459)
7	App\Controller\PublicController->latestChanges (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Place	40
App\Entity\Stats	4

Entities Mapping

Class	Mapping errors
App\Entity\Place	No errors.
App\Entity\Stats	No errors.
App\Entity\History	No errors.

Symfony Profiler

GET https://osm-commerces.cipherbliss.com/latest_changes

Configuration Settings

Theme

Page Width