Symfony Profiler

Query Metrics

9 Database Queries

7 Different statements

310.56 ms Query time

0 Invalid entities

2 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

297.10 ms
(95.67%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 432)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Service\ActionLogger->log (line 33)
4	App\Controller\AdminController->sireneReconciliationProposals (line 5288)
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)

4.57 ms
(1.47%)

SELECT s0_.id AS id_0, s0_.match_score AS match_score_1, s0_.status AS status_2, s0_.date_created AS date_created_3, s0_.date_validated AS date_validated_4, s0_.date_sent_to_osm AS date_sent_to_osm_5, s0_.comment AS comment_6, s0_.osm_changeset_id AS osm_changeset_id_7, s0_.sirene_entreprise_id AS sirene_entreprise_id_8, s0_.place_id AS place_id_9 FROM sirene_reconciliation_proposal s0_ INNER JOIN place p1_ ON s0_.place_id = p1_.id WHERE p1_.stats_id = ? AND s0_.status = ? ORDER BY s0_.date_validated DESC

Parameters:

[
  12733
  "validated"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.match_score AS match_score_1,
  s0_.status AS status_2,
  s0_.date_created AS date_created_3,
  s0_.date_validated AS date_validated_4,
  s0_.date_sent_to_osm AS date_sent_to_osm_5,
  s0_.comment AS comment_6,
  s0_.osm_changeset_id AS osm_changeset_id_7,
  s0_.sirene_entreprise_id AS sirene_entreprise_id_8,
  s0_.place_id AS place_id_9
FROM
  sirene_reconciliation_proposal s0_
  INNER JOIN place p1_ ON s0_.place_id = p1_.id
WHERE
  p1_.stats_id = ?
  AND s0_.status = ?
ORDER BY
  s0_.date_validated DESC

SELECT s0_.id AS id_0, s0_.match_score AS match_score_1, s0_.status AS status_2, s0_.date_created AS date_created_3, s0_.date_validated AS date_validated_4, s0_.date_sent_to_osm AS date_sent_to_osm_5, s0_.comment AS comment_6, s0_.osm_changeset_id AS osm_changeset_id_7, s0_.sirene_entreprise_id AS sirene_entreprise_id_8, s0_.place_id AS place_id_9 FROM sirene_reconciliation_proposal s0_ INNER JOIN place p1_ ON s0_.place_id = p1_.id WHERE p1_.stats_id = 12733 AND s0_.status = 'validated' ORDER BY s0_.date_validated DESC;

#	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\SireneReconciliationProposalRepository->findValidatedByStats (line 50)
7	App\Controller\AdminController->sireneReconciliationProposals (line 5282)
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)

3.97 ms
(1.28%)

SELECT COUNT(s0_.id) AS sclr_0 FROM sirene_reconciliation_proposal s0_ INNER JOIN place p1_ ON s0_.place_id = p1_.id WHERE p1_.stats_id = ? AND s0_.status = ?

Parameters:

[
  12733
  "pending"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  sirene_reconciliation_proposal s0_
  INNER JOIN place p1_ ON s0_.place_id = p1_.id
WHERE
  p1_.stats_id = ?
  AND s0_.status = ?

SELECT COUNT(s0_.id) AS sclr_0 FROM sirene_reconciliation_proposal s0_ INNER JOIN place p1_ ON s0_.place_id = p1_.id WHERE p1_.stats_id = 12733 AND s0_.status = 'pending';

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Repository\SireneReconciliationProposalRepository->countByStatusAndStats (line 66)
8	App\Controller\AdminController->sireneReconciliationProposals (line 5284)
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)

3.15 ms
(1.02%)

INSERT INTO action_log (type, data, created_at, from_url, who) VALUES (?, ?, ?, ?, ?)

Parameters:

[
  "admin/sirene_reconciliation_proposals"
  "{"insee_code":"64024"}"
  "2026-03-04 04:35:54"
  null
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO action_log (
  type, data, created_at, from_url, who
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO action_log (type, data, created_at, from_url, who) VALUES ('admin/sirene_reconciliation_proposals', '{\"insee_code\":\"64024\"}', '2026-03-04 04:35:54', NULL, NULL);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1059)
4	Doctrine\ORM\UnitOfWork->commit (line 402)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Service\ActionLogger->log (line 33)
7	App\Controller\AdminController->sireneReconciliationProposals (line 5288)
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)

1.16 ms
(0.37%)

SELECT t0.id AS id_1, t0.zone AS zone_2, t0.completion_percent AS completion_percent_3, t0.places_count AS places_count_4, t0.avec_horaires AS avec_horaires_5, t0.avec_adresse AS avec_adresse_6, t0.avec_site AS avec_site_7, t0.avec_accessibilite AS avec_accessibilite_8, t0.avec_note AS avec_note_9, t0.name AS name_10, t0.population AS population_11, t0.siren AS siren_12, t0.code_epci AS code_epci_13, t0.codes_postaux AS codes_postaux_14, t0.date_created AS date_created_15, t0.date_modified AS date_modified_16, t0.avec_siret AS avec_siret_17, t0.avec_name AS avec_name_18, t0.osm_data_date_min AS osm_data_date_min_19, t0.osm_data_date_avg AS osm_data_date_avg_20, t0.osm_data_date_max AS osm_data_date_max_21, t0.budget_annuel AS budget_annuel_22, t0.lat AS lat_23, t0.lon AS lon_24, t0.date_labourage_requested AS date_labourage_requested_25, t0.date_labourage_done AS date_labourage_done_26, t0.kind AS kind_27 FROM stats t0 WHERE t0.zone = ? LIMIT 1

Parameters:

[
  "64024"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.zone AS zone_2,
  t0.completion_percent AS completion_percent_3,
  t0.places_count AS places_count_4,
  t0.avec_horaires AS avec_horaires_5,
  t0.avec_adresse AS avec_adresse_6,
  t0.avec_site AS avec_site_7,
  t0.avec_accessibilite AS avec_accessibilite_8,
  t0.avec_note AS avec_note_9,
  t0.name AS name_10,
  t0.population AS population_11,
  t0.siren AS siren_12,
  t0.code_epci AS code_epci_13,
  t0.codes_postaux AS codes_postaux_14,
  t0.date_created AS date_created_15,
  t0.date_modified AS date_modified_16,
  t0.avec_siret AS avec_siret_17,
  t0.avec_name AS avec_name_18,
  t0.osm_data_date_min AS osm_data_date_min_19,
  t0.osm_data_date_avg AS osm_data_date_avg_20,
  t0.osm_data_date_max AS osm_data_date_max_21,
  t0.budget_annuel AS budget_annuel_22,
  t0.lat AS lat_23,
  t0.lon AS lon_24,
  t0.date_labourage_requested AS date_labourage_requested_25,
  t0.date_labourage_done AS date_labourage_done_26,
  t0.kind AS kind_27
FROM
  stats t0
WHERE
  t0.zone = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.zone AS zone_2, t0.completion_percent AS completion_percent_3, t0.places_count AS places_count_4, t0.avec_horaires AS avec_horaires_5, t0.avec_adresse AS avec_adresse_6, t0.avec_site AS avec_site_7, t0.avec_accessibilite AS avec_accessibilite_8, t0.avec_note AS avec_note_9, t0.name AS name_10, t0.population AS population_11, t0.siren AS siren_12, t0.code_epci AS code_epci_13, t0.codes_postaux AS codes_postaux_14, t0.date_created AS date_created_15, t0.date_modified AS date_modified_16, t0.avec_siret AS avec_siret_17, t0.avec_name AS avec_name_18, t0.osm_data_date_min AS osm_data_date_min_19, t0.osm_data_date_avg AS osm_data_date_avg_20, t0.osm_data_date_max AS osm_data_date_max_21, t0.budget_annuel AS budget_annuel_22, t0.lat AS lat_23, t0.lon AS lon_24, t0.date_labourage_requested AS date_labourage_requested_25, t0.date_labourage_done AS date_labourage_done_26, t0.kind AS kind_27 FROM stats t0 WHERE t0.zone = '64024' 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\AdminController->sireneReconciliationProposals (line 5273)
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)

0.46 ms
(0.15%)

SELECT s0_.id AS id_0, s0_.match_score AS match_score_1, s0_.status AS status_2, s0_.date_created AS date_created_3, s0_.date_validated AS date_validated_4, s0_.date_sent_to_osm AS date_sent_to_osm_5, s0_.comment AS comment_6, s0_.osm_changeset_id AS osm_changeset_id_7, s0_.sirene_entreprise_id AS sirene_entreprise_id_8, s0_.place_id AS place_id_9 FROM sirene_reconciliation_proposal s0_ INNER JOIN place p1_ ON s0_.place_id = p1_.id INNER JOIN sirene_entreprise s2_ ON s0_.sirene_entreprise_id = s2_.id WHERE p1_.stats_id = ? AND s0_.status = ? ORDER BY s0_.match_score DESC

Parameters:

[
  12733
  "pending"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.match_score AS match_score_1,
  s0_.status AS status_2,
  s0_.date_created AS date_created_3,
  s0_.date_validated AS date_validated_4,
  s0_.date_sent_to_osm AS date_sent_to_osm_5,
  s0_.comment AS comment_6,
  s0_.osm_changeset_id AS osm_changeset_id_7,
  s0_.sirene_entreprise_id AS sirene_entreprise_id_8,
  s0_.place_id AS place_id_9
FROM
  sirene_reconciliation_proposal s0_
  INNER JOIN place p1_ ON s0_.place_id = p1_.id
  INNER JOIN sirene_entreprise s2_ ON s0_.sirene_entreprise_id = s2_.id
WHERE
  p1_.stats_id = ?
  AND s0_.status = ?
ORDER BY
  s0_.match_score DESC

SELECT s0_.id AS id_0, s0_.match_score AS match_score_1, s0_.status AS status_2, s0_.date_created AS date_created_3, s0_.date_validated AS date_validated_4, s0_.date_sent_to_osm AS date_sent_to_osm_5, s0_.comment AS comment_6, s0_.osm_changeset_id AS osm_changeset_id_7, s0_.sirene_entreprise_id AS sirene_entreprise_id_8, s0_.place_id AS place_id_9 FROM sirene_reconciliation_proposal s0_ INNER JOIN place p1_ ON s0_.place_id = p1_.id INNER JOIN sirene_entreprise s2_ ON s0_.sirene_entreprise_id = s2_.id WHERE p1_.stats_id = 12733 AND s0_.status = 'pending' ORDER BY s0_.match_score DESC;

#	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\SireneReconciliationProposalRepository->findPendingByStats (line 34)
7	App\Controller\AdminController->sireneReconciliationProposals (line 5281)
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)

0.14 ms
(0.05%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 381)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Service\ActionLogger->log (line 33)
4	App\Controller\AdminController->sireneReconciliationProposals (line 5288)
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\Stats	1
App\Entity\ActionLog	1

Entities Mapping

Class	Mapping errors
App\Entity\Stats	No errors.
App\Entity\Place	No errors.
App\Entity\StatsHistory	No errors.
App\Entity\CityFollowUp	No errors.
App\Entity\ZonePlaces	No errors.
App\Entity\SireneEntreprise	No errors.
App\Entity\SireneReconciliationProposal	No errors.
App\Entity\ActionLog	No errors.

Symfony Profiler

GET https://osm-commerces.cipherbliss.com/admin/stats/64024/sirene-proposals

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping