Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

6.74 ms Query time

1 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.42 ms
(35.87%)

SELECT r0_.id AS id_0, r0_.uid AS uid_1, r0_.created_at AS created_at_2, r0_.user_agent AS user_agent_3, r0_.ip AS ip_4, r0_.min_area AS min_area_5, r0_.min_rooms AS min_rooms_6, r0_.furnished AS furnished_7, r0_.max_rent AS max_rent_8, r0_.residents AS residents_9, r0_.cities AS cities_10, r0_.state AS state_11, r0_.extrafields AS extrafields_12, r0_.city_id AS city_id_13 FROM rental_file_draft r0_ WHERE r0_.ip = ? AND r0_.user_agent = ? AND r0_.created_at > ? LIMIT 1

Parameters:

[
  "216.73.216.103"
  "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "2026-09-23 05:07:50"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.uid AS uid_1,
  r0_.created_at AS created_at_2,
  r0_.user_agent AS user_agent_3,
  r0_.ip AS ip_4,
  r0_.min_area AS min_area_5,
  r0_.min_rooms AS min_rooms_6,
  r0_.furnished AS furnished_7,
  r0_.max_rent AS max_rent_8,
  r0_.residents AS residents_9,
  r0_.cities AS cities_10,
  r0_.state AS state_11,
  r0_.extrafields AS extrafields_12,
  r0_.city_id AS city_id_13
FROM
  rental_file_draft r0_
WHERE
  r0_.ip = ?
  AND r0_.user_agent = ?
  AND r0_.created_at > ?
LIMIT
  1

SELECT r0_.id AS id_0, r0_.uid AS uid_1, r0_.created_at AS created_at_2, r0_.user_agent AS user_agent_3, r0_.ip AS ip_4, r0_.min_area AS min_area_5, r0_.min_rooms AS min_rooms_6, r0_.furnished AS furnished_7, r0_.max_rent AS max_rent_8, r0_.residents AS residents_9, r0_.cities AS cities_10, r0_.state AS state_11, r0_.extrafields AS extrafields_12, r0_.city_id AS city_id_13 FROM rental_file_draft r0_ WHERE r0_.ip = '216.73.216.103' AND r0_.user_agent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' AND r0_.created_at > '2026-09-23 05:07:50' LIMIT 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->getOneOrNullResult (line 958)
6	App\Repository\RentalFileDraftRepository->findActiveFileDraft (line 37)
7	App\Controller\RegistrationController->rentalfile (line 578)
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 34)
12	require_once (line 32)
13	require_once (line 5)

2.30 ms
(34.13%)

SELECT NEXTVAL('rental_file_draft_id_seq')

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  NEXTVAL('rental_file_draft_id_seq')

SELECT NEXTVAL('rental_file_draft_id_seq');

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 627)
2	Doctrine\ORM\Id\SequenceGenerator->generateId (line 65)
3	Doctrine\ORM\UnitOfWork->persistNew (line 1049)
4	Doctrine\ORM\UnitOfWork->doPersist (line 2071)
5	Doctrine\ORM\UnitOfWork->persist (line 2028)
6	Doctrine\ORM\EntityManager->persist (line 681)
7	App\Controller\RegistrationController->rentalfile (line 587)
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 34)
12	require_once (line 32)
13	require_once (line 5)

1.30 ms
(19.30%)

INSERT INTO rental_file_draft (id, uid, created_at, user_agent, ip, min_area, min_rooms, furnished, max_rent, residents, cities, state, extrafields, city_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  9
  "6ab35fd24639"
  "2026-09-23 05:12:50"
  "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "216.73.216.103"
  20
  1
  2
  null
  null
  null
  "city"
  null
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO rental_file_draft (
  id, uid, created_at, user_agent, ip,
  min_area, min_rooms, furnished, max_rent,
  residents, cities, state, extrafields,
  city_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO rental_file_draft (id, uid, created_at, user_agent, ip, min_area, min_rooms, furnished, max_rent, residents, cities, state, extrafields, city_id) VALUES (9, '6ab35fd24639', '2026-09-23 05:12:50', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '216.73.216.103', 20, 1, 2, NULL, NULL, NULL, 'city', NULL, NULL);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 249)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 288)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1191)
4	Doctrine\ORM\UnitOfWork->commit (line 451)
5	Doctrine\ORM\EntityManager->flush (line 414)
6	App\Controller\RegistrationController->rentalfile (line 588)
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 34)
11	require_once (line 32)
12	require_once (line 5)

0.54 ms
(7.94%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->commit (line 1454)
2	Doctrine\ORM\UnitOfWork->commit (line 480)
3	Doctrine\ORM\EntityManager->flush (line 414)
4	App\Controller\RegistrationController->rentalfile (line 588)
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 34)
9	require_once (line 32)
10	require_once (line 5)

0.19 ms
(2.76%)

"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 430)
2	Doctrine\ORM\EntityManager->flush (line 414)
3	App\Controller\RegistrationController->rentalfile (line 588)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 182)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
8	require_once (line 32)
9	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\RentalFileDraft	1

Entities Mapping

Class	Mapping errors
App\Entity\RentalFileDraft	No errors.
App\Entity\Locality	The association App\Entity\Locality#stateReference refers to the inverse side field App\Entity\State#localityId which does not exist.

Symfony Profiler

GET https://test.123loger.com/location/signup/file/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping