GET https://netvendeur.kodkodkod.studio/prix-immobilier/?t=ville-prix-d

Query Metrics

8 Database Queries
7 Different statements
72.72 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

# Time Info
1 6.16 ms
SELECT COUNT(a0_.id_ticket) AS sclr_0 FROM abnv_tickets a0_ WHERE a0_.init = 0
Parameters:
[]
2 7.12 ms
SELECT COUNT(*) FROM abnv_users t0 WHERE t0.deletion = ?
Parameters:
[
  0
]
3 16.47 ms
SELECT COUNT(DISTINCT a0_.id_user) AS sclr_0 FROM abnv_users a0_ LEFT JOIN abnv_user_bank a1_ ON a0_.id_user = a1_.id_user AND (a1_.archived = 0) WHERE a0_.deletion = 0 AND a0_.active = 1 AND (a1_.active = 0 OR a1_.active IS NULL)
Parameters:
[]
4 7.50 ms
SELECT COUNT(a0_.id_user) AS sclr_0 FROM abnv_users a0_ WHERE a0_.offre_mois_gratuit = 0 AND a0_.deletion = 0
Parameters:
[]
5 6.92 ms
SELECT COUNT(a0_.id_user) AS sclr_0 FROM abnv_users a0_ WHERE a0_.deletion <> 0
Parameters:
[]
6 14.63 ms
SELECT COUNT(*) FROM abnv_tmp_prospect t0 WHERE t0.moved = ?
Parameters:
[
  0
]
7 13.18 ms
SELECT COUNT(*) FROM abnv_tmp_prospect t0 WHERE t0.moved = ?
Parameters:
[
  1
]
8 0.74 ms
SELECT COUNT(a0_.id_user) AS sclr_0 FROM abnv_users a0_ WHERE a0_.active = 0 AND a0_.deletion = 0
Parameters:
[]

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

Entities Mapping

Class Mapping errors
App\Entity\Ticket No errors.
App\Entity\User No errors.
App\Entity\UserBank No errors.
App\Entity\TmpProspect No errors.