GET https://www.tycotr.lapatteprecieuse.fr/

Query Metrics

12 Database Queries
5 Different statements
8.91 ms Query time
0 Invalid entities
19 Managed entities

Queries

Group similar statements

# Time Info
1 0.94 ms
SELECT a0_.id AS id_0, a0_.description AS description_1, a0_.nom AS nom_2, a0_.date_naissance AS date_naissance_3, a0_.maladie AS maladie_4, a0_.etat AS etat_5, a0_.sexe AS sexe_6, a0_.image_name AS image_name_7, a0_.image_size AS image_size_8, a0_.updated_at AS updated_at_9, a0_.num_iden_valid AS num_iden_valid_10, a0_.num_iden AS num_iden_11, a0_.datepublication AS datepublication_12, a0_.vaccine AS vaccine_13, a0_.dresse AS dresse_14, a0_.sterile AS sterile_15, a0_.couleur AS couleur_16, a0_.poil AS poil_17, a0_.possedeallergie AS possedeallergie_18, a0_.allergie AS allergie_19, a0_.traiter AS traiter_20, a0_.goodwith AS goodwith_21, a0_.raison AS raison_22, a0_.custom_id AS custom_id_23, a0_.etape AS etape_24, a0_.race_id AS race_id_25, a0_.ville_id AS ville_id_26, a0_.donneur_id AS donneur_id_27 FROM annonce a0_ WHERE a0_.etat = ? ORDER BY RAND() ASC LIMIT 6
Parameters:
[
  "EN_LIGNE"
]
2 0.81 ms
SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.type AS type_3, t0.montant AS montant_4, t0.date_paiement AS date_paiement_5, t0.status AS status_6, t0.helloasso_id AS helloasso_id_7, t0.annonce_id AS annonce_id_8, t0.user_id AS user_id_9 FROM paiement t0 WHERE t0.annonce_id = ?
Parameters:
[
  26
]
3 0.66 ms
SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.type AS type_3, t0.montant AS montant_4, t0.date_paiement AS date_paiement_5, t0.status AS status_6, t0.helloasso_id AS helloasso_id_7, t0.annonce_id AS annonce_id_8, t0.user_id AS user_id_9 FROM paiement t0 WHERE t0.annonce_id = ?
Parameters:
[
  24
]
4 0.65 ms
SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.type AS type_3, t0.montant AS montant_4, t0.date_paiement AS date_paiement_5, t0.status AS status_6, t0.helloasso_id AS helloasso_id_7, t0.annonce_id AS annonce_id_8, t0.user_id AS user_id_9 FROM paiement t0 WHERE t0.annonce_id = ?
Parameters:
[
  1
]
5 0.50 ms
SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.type AS type_3, t0.montant AS montant_4, t0.date_paiement AS date_paiement_5, t0.status AS status_6, t0.helloasso_id AS helloasso_id_7, t0.annonce_id AS annonce_id_8, t0.user_id AS user_id_9 FROM paiement t0 WHERE t0.annonce_id = ?
Parameters:
[
  21
]
6 0.73 ms
SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.type AS type_3, t0.montant AS montant_4, t0.date_paiement AS date_paiement_5, t0.status AS status_6, t0.helloasso_id AS helloasso_id_7, t0.annonce_id AS annonce_id_8, t0.user_id AS user_id_9 FROM paiement t0 WHERE t0.annonce_id = ?
Parameters:
[
  14
]
7 1.06 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.objectif AS objectif_3, t0.description AS description_4, t0.datelimite AS datelimite_5, t0.status AS status_6, t0.image_name AS image_name_7, t0.image_size AS image_size_8, t0.updated_at AS updated_at_9, t0.datedebut AS datedebut_10, t0.montant_collecte AS montant_collecte_11, t0.custom_id AS custom_id_12 FROM campagne t0 WHERE t0.status = ?
Parameters:
[
  "EN_COURS"
]
8 0.99 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.race_slug AS race_slug_3, t0.poids_min AS poids_min_4, t0.poids_max AS poids_max_5, t0.taille_min AS taille_min_6, t0.taille_max AS taille_max_7, t0.vie_min AS vie_min_8, t0.vie_max AS vie_max_9, t0.temps_balade AS temps_balade_10, t0.avantage AS avantage_11, t0.inconvenient AS inconvenient_12, t0.description AS description_13, t0.lof AS lof_14, t0.espece_id AS espece_id_15 FROM race t0 WHERE t0.id = ?
Parameters:
[
  10
]
9 0.78 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM espece t0 WHERE t0.id = ?
Parameters:
[
  1
]
10 0.68 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.race_slug AS race_slug_3, t0.poids_min AS poids_min_4, t0.poids_max AS poids_max_5, t0.taille_min AS taille_min_6, t0.taille_max AS taille_max_7, t0.vie_min AS vie_min_8, t0.vie_max AS vie_max_9, t0.temps_balade AS temps_balade_10, t0.avantage AS avantage_11, t0.inconvenient AS inconvenient_12, t0.description AS description_13, t0.lof AS lof_14, t0.espece_id AS espece_id_15 FROM race t0 WHERE t0.id = ?
Parameters:
[
  295
]
11 0.54 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.race_slug AS race_slug_3, t0.poids_min AS poids_min_4, t0.poids_max AS poids_max_5, t0.taille_min AS taille_min_6, t0.taille_max AS taille_max_7, t0.vie_min AS vie_min_8, t0.vie_max AS vie_max_9, t0.temps_balade AS temps_balade_10, t0.avantage AS avantage_11, t0.inconvenient AS inconvenient_12, t0.description AS description_13, t0.lof AS lof_14, t0.espece_id AS espece_id_15 FROM race t0 WHERE t0.id = ?
Parameters:
[
  285
]
12 0.58 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.race_slug AS race_slug_3, t0.poids_min AS poids_min_4, t0.poids_max AS poids_max_5, t0.taille_min AS taille_min_6, t0.taille_max AS taille_max_7, t0.vie_min AS vie_min_8, t0.vie_max AS vie_max_9, t0.temps_balade AS temps_balade_10, t0.avantage AS avantage_11, t0.inconvenient AS inconvenient_12, t0.description AS description_13, t0.lof AS lof_14, t0.espece_id AS espece_id_15 FROM race t0 WHERE t0.id = ?
Parameters:
[
  359
]

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\Annonce 5
App\Entity\Ville 5
App\Entity\Race 4
App\Entity\User 3
App\Entity\Paiement 1
App\Entity\Espece 1

Entities Mapping

Class Mapping errors
App\Entity\Annonce No errors.
App\Entity\Race No errors.
App\Entity\Ville No errors.
App\Entity\User No errors.
App\Entity\FormAdoption No errors.
App\Entity\Paiement No errors.
App\Entity\AnnoncePreuve No errors.
App\Entity\AnnonceHistorique No errors.
App\Entity\Conversation No errors.
App\Entity\Campagne No errors.
App\Entity\Espece No errors.
App\Entity\Article No errors.
App\Entity\RaceCaractere No errors.