https://www.homedesign3d.com.cn/app_dev.php/user/lim

Query Metrics

5 Database Queries
5 Different statements
1.79 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.67 ms
(37.14%)
1
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
]
0.43 ms
(23.92%)
1
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"
]
0.31 ms
(17.07%)
1
SELECT SUM(g0_.galerie_favorited) AS sclr_0 FROM galerie g0_ WHERE g0_.galerie_iduser = 204635
Parameters:
[]
0.28 ms
(15.51%)
1
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
]
0.11 ms
(6.36%)
1
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
  • The association ModelBundle\Entity\User#activite refers to the inverse side field ModelBundle\Entity\Activite#membres which does not exist.
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.