https://www.bestmarketbusiness.com/profile/immobiliers/2

Query Metrics

3 Database Queries
3 Different statements
28.61 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
26.63 ms
(93.08%)
1
SELECT t0.id AS id_1, t0.page AS page_2, t0.element AS element_3, t0.visitor_identity AS visitor_identity_4, t0.id_element AS id_element_5, t0.id_session AS id_session_6, t0.created_at AS created_at_7, t0.users_id AS users_id_8 FROM statistiques t0 WHERE t0.page = ?
Parameters:
[
  "DETAIL_IMMOBILIER"
]
1.37 ms
(4.80%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.ville AS ville_4, t0.pays AS pays_5, t0.image_file_name AS image_file_name_6, t0.image_file_others AS image_file_others_7, t0.slug AS slug_8, t0.quantity AS quantity_9, t0.banner_autorisation AS banner_autorisation_10, t0.home_autorisation AS home_autorisation_11, t0.publicity_autorisation AS publicity_autorisation_12, t0.prix AS prix_13, t0.created_at AS created_at_14, t0.users_id AS users_id_15, t0.categoriesimmobiliers_id AS categoriesimmobiliers_id_16 FROM immobiliers t0 WHERE t0.users_id = ? ORDER BY t0.id DESC
Parameters:
[
  "2"
]
0.61 ms
(2.13%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.lastname AS lastname_5, t0.firstname AS firstname_6, t0.address AS address_7, t0.zipcode AS zipcode_8, t0.city AS city_9, t0.is_verified AS is_verified_10, t0.autorisation AS autorisation_11, t0.reset_token AS reset_token_12, t0.image_user AS image_user_13, t0.image_couverture AS image_couverture_14, t0.job AS job_15, t0.country AS country_16, t0.email_phone_secured AS email_phone_secured_17, t0.phone_public AS phone_public_18, t0.phone_private AS phone_private_19, t0.site_web AS site_web_20, t0.media_social1 AS media_social1_21, t0.media_social2 AS media_social2_22, t0.media_social3 AS media_social3_23, t0.media_social4 AS media_social4_24, t0.media_social5 AS media_social5_25, t0.creation_entreprise AS creation_entreprise_26, t0.creation_hebergement AS creation_hebergement_27, t0.media_social_name1 AS media_social_name1_28, t0.media_social_name2 AS media_social_name2_29, t0.media_social_name3 AS media_social_name3_30, t0.media_social_name4 AS media_social_name4_31, t0.media_social_name5 AS media_social_name5_32, t0.visibility_search AS visibility_search_33, t0.access_cv AS access_cv_34, t0.creation_annonce AS creation_annonce_35, t0.creation_emploi AS creation_emploi_36, t0.creation_video AS creation_video_37, t0.home_autorisation AS home_autorisation_38, t0.banner_autorisation AS banner_autorisation_39, t0.publicity_autorisation AS publicity_autorisation_40, t0.created_at AS created_at_41, t0.categoriesusers_id AS categoriesusers_id_42 FROM users t0 WHERE t0.id = ?
Parameters:
[
  "2"
]

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
App\Entity\Immobiliers No errors.
App\Entity\Users
  • The association App\Entity\Users#products refers to the owning side field App\Entity\Products#Users which does not exist.
  • The association App\Entity\Users#projects refers to the owning side field App\Entity\Projects#Users which does not exist.
App\Entity\CategoriesImmobiliers No errors.
App\Entity\CategoriesUsers No errors.
App\Entity\Orders No errors.
App\Entity\Products No errors.
App\Entity\Projects
  • The mappings App\Entity\Projects#users and App\Entity\Users#projects are inconsistent with each other.
App\Entity\Hebergements No errors.
App\Entity\Prestations No errors.
App\Entity\Entreprises No errors.
App\Entity\Emplois No errors.
App\Entity\Annonces No errors.
App\Entity\Videos No errors.
App\Entity\Statistiques No errors.