https://www.homedesign3d.com.cn/app_dev.php/user/%E5%93%88%E5%93%88%E5%93%88@/project/101374

Query Metrics

14 Database Queries
7 Different statements
2.63 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.50 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:
[
  "101374"
]
2 0.46 ms
SELECT g0_.tag_slug AS tag_slug_0, g0_.tag_taxonomy AS tag_taxonomy_1, g0_.tag_name AS tag_name_2, g0_.tag_date AS tag_date_3, g0_.tag_valid AS tag_valid_4 FROM galerie_tag_version4 g0_ WHERE g0_.tag_slug IN (?)
Parameters:
[
  [
    "cat.2021.7"
    "cat.2021.8"
    "cat.2021.9"
    "cat.2021.30"
    "cat.2021.21"
    "cat.2021.54"
    "cat.2021.60"
  ]
]
3 0.10 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "cat.2021.21"
  "zh-Hans"
  "ModelBundle\Entity\TagV4"
]
4 0.08 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "cat.2021.30"
  "zh-Hans"
  "ModelBundle\Entity\TagV4"
]
5 0.08 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "cat.2021.54"
  "zh-Hans"
  "ModelBundle\Entity\TagV4"
]
6 0.12 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "cat.2021.60"
  "zh-Hans"
  "ModelBundle\Entity\TagV4"
]
7 0.07 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "cat.2021.7"
  "zh-Hans"
  "ModelBundle\Entity\TagV4"
]
8 0.06 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "cat.2021.8"
  "zh-Hans"
  "ModelBundle\Entity\TagV4"
]
9 0.08 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "cat.2021.9"
  "zh-Hans"
  "ModelBundle\Entity\TagV4"
]
10 0.10 ms
SELECT g0_.tag_slug AS tag_slug_0, g0_.tag_taxonomy AS tag_taxonomy_1, g0_.tag_name AS tag_name_2, g0_.tag_date AS tag_date_3, g0_.tag_valid AS tag_valid_4 FROM galerie_tag_version4 g0_ WHERE g0_.tag_slug IN (?)
Parameters:
[
  [
    "cat.2021.7"
    "cat.2021.8"
    "cat.2021.9"
    "cat.2021.30"
    "cat.2021.21"
    "cat.2021.54"
    "cat.2021.60"
  ]
]
11 0.39 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
  "101374"
  231154
]
12 0.16 ms
SELECT COUNT(1) AS sclr_0 FROM galerie g0_ WHERE g0_.galerie_iduser = 231154
Parameters:
[]
13 0.32 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:
[
  231154
]
14 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:
[
  101374
]

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.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation No errors.
Gedmo\Translatable\Entity\Translation No errors.
ModelBundle\Entity\Activite No errors.