Query Metrics
5
Database Queries
5
Different statements
1.79 ms
Query time
1
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.43 ms |
SELECT t0.membre_id AS membre_id_1, t0.membre_identifiant AS membre_identifiant_2, t0.membre_civ AS membre_civ_3, t0.membre_pays AS membre_pays_4, t0.membre_naissance AS membre_naissance_5, t0.membre_inscription AS membre_inscription_6, t0.membre_email AS membre_email_7, t0.membre_nom AS membre_nom_8, t0.membre_prenom AS membre_prenom_9, t0.membre_pass AS membre_pass_10, t0.membre_passcrypte AS membre_passcrypte_11, t0.membre_connexion AS membre_connexion_12, t0.membre_last_connexion AS membre_last_connexion_13, t0.membre_actif AS membre_actif_14, t0.membre_appli_lang AS membre_appli_lang_15, t0.membre_facebook_id AS membre_facebook_id_16, t0.membre_apple_signin_subject AS membre_apple_signin_subject_17, t0.membre_activite_id AS membre_activite_id_18 FROM membre t0 WHERE t0.membre_identifiant = ? LIMIT 1
Parameters:
[
"lim"
]
|
2 | 0.67 ms |
SELECT t0.galerie_id AS galerie_id_1, t0.galerie_title AS galerie_title_2, t0.galerie_surface AS galerie_surface_3, t0.galerie_nbrpiece AS galerie_nbrpiece_4, t0.galerie_description AS galerie_description_5, t0.galerie_public AS galerie_public_6, t0.galerie_tags AS galerie_tags_7, t0.galerie_officialtags AS galerie_officialtags_8, t0.galerie_date_publication AS galerie_date_publication_9, t0.galerie_date_update AS galerie_date_update_10, t0.galerie_plateforme AS galerie_plateforme_11, t0.galerie_protoversion AS galerie_protoversion_12, t0.galerie_note AS galerie_note_13, t0.galerie_votants AS galerie_votants_14, t0.galerie_vues AS galerie_vues_15, t0.galerie_projecthd3d AS galerie_projecthd3d_16, t0.galerie_favorited AS galerie_favorited_17, t0.galerie_downloads AS galerie_downloads_18, t0.galerie_contributors AS galerie_contributors_19, t0.galerie_hasexport3d AS galerie_hasexport3d_20, t0.galerie_export3d AS galerie_export3d_21, t0.galerie_valid AS galerie_valid_22, t0.galerie_iduser AS galerie_iduser_23, t0.galerie_idogproject AS galerie_idogproject_24, t0.galerie_idcreator AS galerie_idcreator_25, t0.galerie_categorie AS galerie_categorie_26, t27.galerie_meta_id AS galerie_meta_id_28, t27.galerie_meta_nbr_floors AS galerie_meta_nbr_floors_29, t27.galerie_meta_surface_ext AS galerie_meta_surface_ext_30, t27.galerie_meta_nbr_furnitures AS galerie_meta_nbr_furnitures_31, t27.galerie_meta_nbr_furniture_types AS galerie_meta_nbr_furniture_types_32, t27.galerie_meta_nbr_windows AS galerie_meta_nbr_windows_33, t27.galerie_meta_nbr_doors AS galerie_meta_nbr_doors_34, t27.galerie_meta_nbr_stairs AS galerie_meta_nbr_stairs_35, t27.galerie_meta_nbr_openings AS galerie_meta_nbr_openings_36, t27.galerie_meta_playtime_seconds AS galerie_meta_playtime_seconds_37, t27.galerie_meta_idprojet AS galerie_meta_idprojet_38 FROM galerie t0 LEFT JOIN galerie_meta_version4 t27 ON t27.galerie_meta_idprojet = t0.galerie_id WHERE t0.galerie_iduser = ? AND t0.galerie_valid = ? ORDER BY t0.galerie_date_update DESC, t0.galerie_date_publication DESC
Parameters:
[ 204635 1 ] |
3 | 0.28 ms |
SELECT t0.favoris_id_membre AS favoris_id_membre_1, t0.favoris_id_galerie AS favoris_id_galerie_2 FROM favoris t0 WHERE t0.favoris_id_membre = ?
Parameters:
[
204635
]
|
4 | 0.31 ms |
SELECT SUM(g0_.galerie_favorited) AS sclr_0 FROM galerie g0_ WHERE g0_.galerie_iduser = 204635
Parameters:
[] |
5 | 0.11 ms |
SELECT t0.galerie_image_id AS galerie_image_id_1, t0.galerie_image_image AS galerie_image_image_2, t0.galerie_image_thumbnail AS galerie_image_thumbnail_3, t0.galerie_image_guid AS galerie_image_guid_4, t0.galerie_image_position AS galerie_image_position_5, t0.galerie_image_weight AS galerie_image_weight_6, t0.galerie_image_valid_admin AS galerie_image_valid_admin_7, t0.galerie_image_idprojet AS galerie_image_idprojet_8 FROM galerie_image t0 WHERE t0.galerie_image_idprojet = ? ORDER BY t0.galerie_image_weight DESC, t0.galerie_image_position ASC
Parameters:
[
71680
]
|
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 |
---|---|
ModelBundle\Entity\User |
|
ModelBundle\Entity\Activite | No errors. |
ModelBundle\Entity\Project | No errors. |
ModelBundle\Entity\TagV4 | No errors. |
ModelBundle\Entity\MetasV4 | No errors. |
ModelBundle\Entity\Tag | No errors. |
ModelBundle\Entity\Image | No errors. |
ModelBundle\Entity\Favorite | No errors. |