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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
27.42 ms
(92.95%)
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_PROJECT"
]
1.39 ms
(4.71%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.ville AS ville_4, t0.image_file_name AS image_file_name_5, t0.image_file_others AS image_file_others_6, t0.slug AS slug_7, t0.pays AS pays_8, t0.updated_at AS updated_at_9, t0.banner_autorisation AS banner_autorisation_10, t0.home_autorisation AS home_autorisation_11, t0.publicity_autorisation AS publicity_autorisation_12, t0.created_at AS created_at_13, t0.users_id AS users_id_14, t0.categoriesprojects_id AS categoriesprojects_id_15 FROM projects t0 WHERE t0.users_id = ? ORDER BY t0.id DESC
Parameters:
[
  "2"
]
0.69 ms
(2.35%)
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\Projects
  • The mappings App\Entity\Projects#users and App\Entity\Users#projects are inconsistent with each other.
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\CategoriesProjects No errors.
App\Entity\CategoriesUsers No errors.
App\Entity\Orders No errors.
App\Entity\Products No errors.
App\Entity\Immobiliers No errors.
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.