https://www.homedesign3d.com.cn/app_dev.php/user/david0322/project/100576

Method
GET
HTTP Status
200
IP
66.249.68.4
Profiled on
Sun, 04 May 2025 16:58:30 +0800
Token
4c8216

Query Metrics

13 Database Queries
6 Different statements
2.58 ms Query time
1 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.59 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_id = ?
Parameters: 
[
  "100576"
]
View formatted query    View runnable query    Explain query
2 0.70 ms 
SELECT g0_.galerie_id AS galerie_id_0, g0_.galerie_title AS galerie_title_1, g0_.galerie_surface AS galerie_surface_2, g0_.galerie_nbrpiece AS galerie_nbrpiece_3, g0_.galerie_description AS galerie_description_4, g0_.galerie_public AS galerie_public_5, g0_.galerie_tags AS galerie_tags_6, g0_.galerie_officialtags AS galerie_officialtags_7, g0_.galerie_date_publication AS galerie_date_publication_8, g0_.galerie_date_update AS galerie_date_update_9, g0_.galerie_plateforme AS galerie_plateforme_10, g0_.galerie_protoversion AS galerie_protoversion_11, g0_.galerie_note AS galerie_note_12, g0_.galerie_votants AS galerie_votants_13, g0_.galerie_vues AS galerie_vues_14, g0_.galerie_projecthd3d AS galerie_projecthd3d_15, g0_.galerie_favorited AS galerie_favorited_16, g0_.galerie_downloads AS galerie_downloads_17, g0_.galerie_contributors AS galerie_contributors_18, g0_.galerie_hasexport3d AS galerie_hasexport3d_19, g0_.galerie_export3d AS galerie_export3d_20, g0_.galerie_valid AS galerie_valid_21, g0_.galerie_iduser AS galerie_iduser_22, g0_.galerie_idogproject AS galerie_idogproject_23, g0_.galerie_idcreator AS galerie_idcreator_24, g0_.galerie_categorie AS galerie_categorie_25 FROM galerie g0_ WHERE g0_.galerie_valid = ? AND g0_.galerie_id <> ? AND g0_.galerie_iduser = ? ORDER BY g0_.galerie_date_update DESC LIMIT 4
Parameters: 
[
  1
  "100576"
  206693
]
View formatted query    View runnable query    Explain query
3 0.13 ms 
SELECT t0.galerie_meta_id AS galerie_meta_id_1, t0.galerie_meta_nbr_floors AS galerie_meta_nbr_floors_2, t0.galerie_meta_surface_ext AS galerie_meta_surface_ext_3, t0.galerie_meta_nbr_furnitures AS galerie_meta_nbr_furnitures_4, t0.galerie_meta_nbr_furniture_types AS galerie_meta_nbr_furniture_types_5, t0.galerie_meta_nbr_windows AS galerie_meta_nbr_windows_6, t0.galerie_meta_nbr_doors AS galerie_meta_nbr_doors_7, t0.galerie_meta_nbr_stairs AS galerie_meta_nbr_stairs_8, t0.galerie_meta_nbr_openings AS galerie_meta_nbr_openings_9, t0.galerie_meta_playtime_seconds AS galerie_meta_playtime_seconds_10, t0.galerie_meta_idprojet AS galerie_meta_idprojet_11 FROM galerie_meta_version4 t0 WHERE t0.galerie_meta_idprojet = ?
Parameters: 
[
  101492
]
View formatted query    View runnable query    Explain query
4 0.07 ms 
SELECT t0.galerie_meta_id AS galerie_meta_id_1, t0.galerie_meta_nbr_floors AS galerie_meta_nbr_floors_2, t0.galerie_meta_surface_ext AS galerie_meta_surface_ext_3, t0.galerie_meta_nbr_furnitures AS galerie_meta_nbr_furnitures_4, t0.galerie_meta_nbr_furniture_types AS galerie_meta_nbr_furniture_types_5, t0.galerie_meta_nbr_windows AS galerie_meta_nbr_windows_6, t0.galerie_meta_nbr_doors AS galerie_meta_nbr_doors_7, t0.galerie_meta_nbr_stairs AS galerie_meta_nbr_stairs_8, t0.galerie_meta_nbr_openings AS galerie_meta_nbr_openings_9, t0.galerie_meta_playtime_seconds AS galerie_meta_playtime_seconds_10, t0.galerie_meta_idprojet AS galerie_meta_idprojet_11 FROM galerie_meta_version4 t0 WHERE t0.galerie_meta_idprojet = ?
Parameters: 
[
  100864
]
View formatted query    View runnable query    Explain query
5 0.07 ms 
SELECT t0.galerie_meta_id AS galerie_meta_id_1, t0.galerie_meta_nbr_floors AS galerie_meta_nbr_floors_2, t0.galerie_meta_surface_ext AS galerie_meta_surface_ext_3, t0.galerie_meta_nbr_furnitures AS galerie_meta_nbr_furnitures_4, t0.galerie_meta_nbr_furniture_types AS galerie_meta_nbr_furniture_types_5, t0.galerie_meta_nbr_windows AS galerie_meta_nbr_windows_6, t0.galerie_meta_nbr_doors AS galerie_meta_nbr_doors_7, t0.galerie_meta_nbr_stairs AS galerie_meta_nbr_stairs_8, t0.galerie_meta_nbr_openings AS galerie_meta_nbr_openings_9, t0.galerie_meta_playtime_seconds AS galerie_meta_playtime_seconds_10, t0.galerie_meta_idprojet AS galerie_meta_idprojet_11 FROM galerie_meta_version4 t0 WHERE t0.galerie_meta_idprojet = ?
Parameters: 
[
  100852
]
View formatted query    View runnable query    Explain query
6 0.09 ms 
SELECT t0.galerie_meta_id AS galerie_meta_id_1, t0.galerie_meta_nbr_floors AS galerie_meta_nbr_floors_2, t0.galerie_meta_surface_ext AS galerie_meta_surface_ext_3, t0.galerie_meta_nbr_furnitures AS galerie_meta_nbr_furnitures_4, t0.galerie_meta_nbr_furniture_types AS galerie_meta_nbr_furniture_types_5, t0.galerie_meta_nbr_windows AS galerie_meta_nbr_windows_6, t0.galerie_meta_nbr_doors AS galerie_meta_nbr_doors_7, t0.galerie_meta_nbr_stairs AS galerie_meta_nbr_stairs_8, t0.galerie_meta_nbr_openings AS galerie_meta_nbr_openings_9, t0.galerie_meta_playtime_seconds AS galerie_meta_playtime_seconds_10, t0.galerie_meta_idprojet AS galerie_meta_idprojet_11 FROM galerie_meta_version4 t0 WHERE t0.galerie_meta_idprojet = ?
Parameters: 
[
  100850
]
View formatted query    View runnable query    Explain query
7 0.18 ms 
SELECT COUNT(1) AS sclr_0 FROM galerie g0_ WHERE g0_.galerie_iduser = 206693
Parameters: 
[]
View formatted query    View runnable query    Explain query
8 0.12 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_id = ?
Parameters: 
[
  206693
]
View formatted query    View runnable query    Explain query
9 0.26 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: 
[
  100576
]
View formatted query    View runnable query    Explain query
10 0.12 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: 
[
  101492
]
View formatted query    View runnable query    Explain query
11 0.08 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: 
[
  100864
]
View formatted query    View runnable query    Explain query
12 0.10 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: 
[
  100852
]
View formatted query    View runnable query    Explain query
13 0.07 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: 
[
  100850
]
View formatted query    View runnable query    Explain query

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\Project No 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\TagV4 No errors.
ModelBundle\Entity\MetasV4 No errors.
ModelBundle\Entity\Tag No errors.
ModelBundle\Entity\Image No errors.
ModelBundle\Entity\Activite No errors.