Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

25.14 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

21.03 ms

SELECT l0_.id AS id_0, l0_.full_name AS full_name_1, l0_.email AS email_2, l0_.vat_number AS vat_number_3, l0_.phone AS phone_4, l0_.monthly_income AS monthly_income_5, l0_.additional_income AS additional_income_6, l0_.co_monthly_income AS co_monthly_income_7, l0_.co_additional_income AS co_additional_income_8, l0_.tax_income AS tax_income_9, l0_.tax_year AS tax_year_10, l0_.co_tax_income AS co_tax_income_11, l0_.co_tax_year AS co_tax_year_12, l0_.co_full_name AS co_full_name_13, l0_.co_employer AS co_employer_14, l0_.children_count AS children_count_15, l0_.household_adults AS household_adults_16, l0_.has_guarantor AS has_guarantor_17, l0_.guarantor_income AS guarantor_income_18, l0_.target_rent AS target_rent_19, l0_.status AS status_20, l0_.employer AS employer_21, l0_.notes AS notes_22, l0_.created_at AS created_at_23, l0_.updated_at AS updated_at_24, l0_.tenancy_status AS tenancy_status_25, l0_.public_token AS public_token_26, l0_.move_in_date AS move_in_date_27, l0_.property_id AS property_id_28 FROM location_rental_application l0_ WHERE l0_.tenancy_status IN (?, ?) AND l0_.email IS NOT NULL AND l0_.property_id IS NOT NULL AND (NOT EXISTS (SELECT 1 AS sclr_29 FROM location_rent_payment l1_ WHERE l1_.application_id = l0_.id AND l1_.year = ? AND l1_.month = ?)) ORDER BY l0_.updated_at DESC

Parameters:

[
  "current"
  "leaving"
  2026
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.full_name AS full_name_1,
  l0_.email AS email_2,
  l0_.vat_number AS vat_number_3,
  l0_.phone AS phone_4,
  l0_.monthly_income AS monthly_income_5,
  l0_.additional_income AS additional_income_6,
  l0_.co_monthly_income AS co_monthly_income_7,
  l0_.co_additional_income AS co_additional_income_8,
  l0_.tax_income AS tax_income_9,
  l0_.tax_year AS tax_year_10,
  l0_.co_tax_income AS co_tax_income_11,
  l0_.co_tax_year AS co_tax_year_12,
  l0_.co_full_name AS co_full_name_13,
  l0_.co_employer AS co_employer_14,
  l0_.children_count AS children_count_15,
  l0_.household_adults AS household_adults_16,
  l0_.has_guarantor AS has_guarantor_17,
  l0_.guarantor_income AS guarantor_income_18,
  l0_.target_rent AS target_rent_19,
  l0_.status AS status_20,
  l0_.employer AS employer_21,
  l0_.notes AS notes_22,
  l0_.created_at AS created_at_23,
  l0_.updated_at AS updated_at_24,
  l0_.tenancy_status AS tenancy_status_25,
  l0_.public_token AS public_token_26,
  l0_.move_in_date AS move_in_date_27,
  l0_.property_id AS property_id_28
FROM
  location_rental_application l0_
WHERE
  l0_.tenancy_status IN (?, ?)
  AND l0_.email IS NOT NULL
  AND l0_.property_id IS NOT NULL
  AND (
    NOT EXISTS (
      SELECT
        1 AS sclr_29
      FROM
        location_rent_payment l1_
      WHERE
        l1_.application_id = l0_.id
        AND l1_.year = ?
        AND l1_.month = ?
    )
  )
ORDER BY
  l0_.updated_at DESC

SELECT l0_.id AS id_0, l0_.full_name AS full_name_1, l0_.email AS email_2, l0_.vat_number AS vat_number_3, l0_.phone AS phone_4, l0_.monthly_income AS monthly_income_5, l0_.additional_income AS additional_income_6, l0_.co_monthly_income AS co_monthly_income_7, l0_.co_additional_income AS co_additional_income_8, l0_.tax_income AS tax_income_9, l0_.tax_year AS tax_year_10, l0_.co_tax_income AS co_tax_income_11, l0_.co_tax_year AS co_tax_year_12, l0_.co_full_name AS co_full_name_13, l0_.co_employer AS co_employer_14, l0_.children_count AS children_count_15, l0_.household_adults AS household_adults_16, l0_.has_guarantor AS has_guarantor_17, l0_.guarantor_income AS guarantor_income_18, l0_.target_rent AS target_rent_19, l0_.status AS status_20, l0_.employer AS employer_21, l0_.notes AS notes_22, l0_.created_at AS created_at_23, l0_.updated_at AS updated_at_24, l0_.tenancy_status AS tenancy_status_25, l0_.public_token AS public_token_26, l0_.move_in_date AS move_in_date_27, l0_.property_id AS property_id_28 FROM location_rental_application l0_ WHERE l0_.tenancy_status IN ('current', 'leaving') AND l0_.email IS NOT NULL AND l0_.property_id IS NOT NULL AND (NOT EXISTS (SELECT 1 AS sclr_29 FROM location_rent_payment l1_ WHERE l1_.application_id = l0_.id AND l1_.year = 2026 AND l1_.month = 1)) ORDER BY l0_.updated_at DESC;

#	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 128)
7	App\Repository\Location\RentalApplicationRepository->findActiveWithoutPaymentForMonth (line 43)
8	App\Controller\Location\RentReminderController->send (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

1.23 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.postal_code AS postal_code_4, t0.city AS city_5, t0.rent_amount AS rent_amount_6, t0.charges_amount AS charges_amount_7, t0.property_type AS property_type_8, t0.tva_rate AS tva_rate_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.owner_id AS owner_id_12 FROM location_property t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.postal_code AS postal_code_4,
  t0.city AS city_5,
  t0.rent_amount AS rent_amount_6,
  t0.charges_amount AS charges_amount_7,
  t0.property_type AS property_type_8,
  t0.tva_rate AS tva_rate_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.owner_id AS owner_id_12
FROM
  location_property t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.postal_code AS postal_code_4, t0.city AS city_5, t0.rent_amount AS rent_amount_6, t0.charges_amount AS charges_amount_7, t0.property_type AS property_type_8, t0.tva_rate AS tva_rate_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.owner_id AS owner_id_12 FROM location_property t0 WHERE t0.id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():219} (line 286)
5	Proxies\__CG__\App\Entity\Location\Property::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():284}:285} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\Location\Property->__get (line 210)
8	App\Entity\Location\Property->getAuthorizedUsers (line 108)
9	App\Controller\Location\RentReminderController->getManagerEmails (line 51)
10	App\Controller\Location\RentReminderController->send (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

1.96 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.taux_horaire AS taux_horaire_5, t0.roles AS roles_6, t0.password AS password_7 FROM `user` t0 INNER JOIN location_property_user ON t0.id = location_property_user.user_id WHERE location_property_user.property_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.nom AS nom_3,
  t0.prenom AS prenom_4,
  t0.taux_horaire AS taux_horaire_5,
  t0.roles AS roles_6,
  t0.password AS password_7
FROM
  `user` t0
  INNER JOIN location_property_user ON t0.id = location_property_user.user_id
WHERE
  location_property_user.property_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.taux_horaire AS taux_horaire_5, t0.roles AS roles_6, t0.password AS password_7 FROM `user` t0 INNER JOIN location_property_user ON t0.id = location_property_user.user_id WHERE location_property_user.property_id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1081)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1010)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2710)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 108)
8	App\Controller\Location\RentReminderController->getManagerEmails (line 51)
9	App\Controller\Location\RentReminderController->send (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.93 ms

SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.amount_ht AS amount_ht_4, t0.tva_rate AS tva_rate_5, t0.amount_ttc AS amount_ttc_6, t0.invoice_number AS invoice_number_7, t0.created_at AS created_at_8, t0.application_id AS application_id_9 FROM location_rent_invoice t0 WHERE t0.application_id = ? ORDER BY t0.start_date DESC

Parameters:

[
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.start_date AS start_date_2,
  t0.end_date AS end_date_3,
  t0.amount_ht AS amount_ht_4,
  t0.tva_rate AS tva_rate_5,
  t0.amount_ttc AS amount_ttc_6,
  t0.invoice_number AS invoice_number_7,
  t0.created_at AS created_at_8,
  t0.application_id AS application_id_9
FROM
  location_rent_invoice t0
WHERE
  t0.application_id = ?
ORDER BY
  t0.start_date DESC

SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.amount_ht AS amount_ht_4, t0.tva_rate AS tva_rate_5, t0.amount_ttc AS amount_ttc_6, t0.invoice_number AS invoice_number_7, t0.created_at AS created_at_8, t0.application_id AS application_id_9 FROM location_rent_invoice t0 WHERE t0.application_id = 13 ORDER BY t0.start_date DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 167)
7	Doctrine\Common\Collections\AbstractLazyCollection->first (line 518)
8	Doctrine\ORM\PersistentCollection->first (line 61)
9	App\Controller\Location\RentReminderController->send (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	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.

Entities Mapping

Class	Mapping errors
App\Entity\Location\RentalApplication	No errors.
App\Entity\Location\RentPayment	No errors.
App\Entity\Location\Property	No errors.
App\Entity\Location\RentalApplicationDocument	No errors.
App\Entity\Location\RentInvoice	No errors.
App\Entity\Location\Owner	No errors.
App\Entity\User	No errors.
App\Entity\Gps\BaliseGPS	No errors.
App\Entity\Gps\Pointage	No errors.
App\Entity\Gps\Absence	No errors.

Symfony Profiler

GET http://www.coupinade.fr/cron/rent/reminders/kdjhngr54fgG4

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping