GET https://fight-impro.fr/equipe/96

Query Metrics

18 Database Queries
11 Different statements
1.41 ms Query time
2 Invalid entities
3 Managed entities

Queries

Group similar statements

# Time Info
1 0.08 ms
SELECT t0.id AS id_1, t0.prenom AS prenom_2, t0.nom AS nom_3, t0.bio AS bio_4, t0.affiche AS affiche_5, t0.url AS url_6, t0.linkedin AS linkedin_7, t0.photo_portrait AS photo_portrait_8, t0.credit_photo AS credit_photo_9, t0.archive AS archive_10, t0.membre AS membre_11, t0.facebook AS facebook_12, t0.instagram AS instagram_13, t0.lien_bio AS lien_bio_14 FROM equipe t0 WHERE t0.id = ?
Parameters:
[
  "96"
]
2 0.09 ms
SELECT t0.id AS id_1, t0.role_id AS role_id_2, t0.personne_id AS personne_id_3 FROM distribution t0 WHERE t0.personne_id = ?
Parameters:
[
  96
]
3 0.10 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.rubrique AS rubrique_4 FROM role t0 WHERE t0.id = ?
Parameters:
[
  4
]
4 0.09 ms
SELECT 'main'
Parameters:
[]
5 0.17 ms
SELECT name AS table_name
FROM sqlite_master
WHERE type = 'table'
  AND name != 'sqlite_sequence'
  AND name != 'geometry_columns'
  AND name != 'spatial_ref_sys'
UNION ALL
SELECT name
FROM sqlite_temp_master
WHERE type = 'table'
ORDER BY name
Parameters:
[]
6 0.04 ms
SELECT 'main'
Parameters:
[]
7 0.09 ms
SELECT name AS table_name
FROM sqlite_master
WHERE type = 'table'
  AND name != 'sqlite_sequence'
  AND name != 'geometry_columns'
  AND name != 'spatial_ref_sys'
UNION ALL
SELECT name
FROM sqlite_temp_master
WHERE type = 'table'
ORDER BY name
Parameters:
[]
8 0.05 ms
SELECT 'main'
Parameters:
[]
9 0.13 ms
SELECT t.name AS table_name,
                   c.*
              FROM sqlite_master t
              JOIN pragma_table_info(t.name) c WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ? ORDER BY t.name, c.cid
Parameters:
[
  "doctrine_migration_versions"
]
10 0.06 ms
SELECT sql
  FROM (
      SELECT *
        FROM sqlite_master
   UNION ALL
      SELECT *
        FROM sqlite_temp_master
  )
WHERE type = 'table'
AND name = ?
Parameters:
[
  "doctrine_migration_versions"
]
11 0.04 ms
SELECT 'main'
Parameters:
[]
12 0.09 ms
SELECT t.name AS table_name,
                   i.*
              FROM sqlite_master t
              JOIN pragma_index_list(t.name) i WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ? ORDER BY t.name, i.seq
Parameters:
[
  "doctrine_migration_versions"
]
13 0.06 ms
SELECT * FROM PRAGMA_TABLE_INFO (?)
Parameters:
[
  "doctrine_migration_versions"
]
14 0.08 ms
SELECT t.name AS table_name,
                   p.*
              FROM sqlite_master t
              JOIN pragma_foreign_key_list(t.name) p
                ON p."seq" != '-1' WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ? ORDER BY t.name, p.id DESC, p.seq
Parameters:
[
  "doctrine_migration_versions"
]
15 0.04 ms
SELECT 'main'
Parameters:
[]
16 0.05 ms
SELECT sql
  FROM (
      SELECT *
        FROM sqlite_master
   UNION ALL
      SELECT *
        FROM sqlite_temp_master
  )
WHERE type = 'table'
AND name = ?
Parameters:
[
  "doctrine_migration_versions"
]
17 0.07 ms
SELECT * FROM doctrine_migration_versions
Parameters:
[]
18 0.08 ms
SELECT 'main'
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
App\Entity\Equipe 1
App\Entity\Distribution 1
App\Entity\Role 1

Entities Mapping

Class Mapping errors
App\Entity\Equipe No errors.
App\Entity\Distribution No errors.
App\Entity\Structure No errors.
App\Entity\Role No errors.
App\Entity\Agenda No errors.
App\Entity\Atelier No errors.
App\Entity\Spectacle No errors.
App\Entity\Article No errors.
App\Entity\RevuePresse No errors.
App\Entity\Bloc No errors.
App\Entity\SpectacleType No errors.
App\Entity\Evenement No errors.
App\Entity\CommuniquePresse No errors.
App\Entity\Lettre\Abonne No errors.
App\Entity\Lettre\LettreDiffusion
  • The association App\Entity\Lettre\LettreDiffusion#articles refers to the inverse side field App\Entity\Article#lettreDiffusions which does not exist.
  • The association App\Entity\Lettre\LettreDiffusion#Presse refers to the inverse side field App\Entity\RevuePresse#lettreDiffusions which does not exist.
  • The association App\Entity\Lettre\LettreDiffusion#photoSpectacle refers to the inverse side field App\Entity\PhotoSpectacle#lettreDiffusions which does not exist.
  • The association App\Entity\Lettre\LettreDiffusion#imageCompagnie refers to the inverse side field App\Entity\Image#lettreDiffusions which does not exist.
App\Entity\Soutien No errors.
App\Entity\Dossier No errors.
App\Entity\MenuSite No errors.
App\Entity\Lieu No errors.
App\Entity\Organisateur No errors.
App\Entity\Image No errors.
App\Entity\AfficheSpectacle No errors.
App\Entity\TypePublic No errors.
App\Entity\Compagnie No errors.
App\Entity\PhotoSpectacle No errors.
App\Entity\Gallerie No errors.
App\Entity\LivreDor No errors.
App\Entity\Clients No errors.
App\Entity\SpectaclePage No errors.
App\Entity\Utilisateur No errors.
App\Entity\Rubrique No errors.
App\Entity\Page No errors.
App\Entity\MotCle
  • The association App\Entity\MotCle#structure refers to the inverse side field App\Entity\Structure#tags which does not exist.
App\Entity\Lettre\Categorie No errors.
App\Entity\LieuSuitecrmMapping No errors.
App\Entity\Galerie No errors.
App\Entity\SpectacleSuitecrmMapping No errors.
Vich\UploaderBundle\Entity\File No errors.