GET https://topautosntest.sn-topauto.com/fr/annuaires/pro/Concessionnaires/13

Query Metrics

4 Database Queries
4 Different statements
0.89 ms Query time
5 Invalid entities
20 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.22 ms
SELECT t0.id AS id_1, t0.categorie AS categorie_2, t0.nom_an AS nom_an_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.logo AS logo_6, t0.image_size AS image_size_7, t0.email AS email_8, t0.address AS address_9, t0.website AS website_10, t0.updated_at AS updated_at_11, t0.statut AS statut_12, t0.date_abonnement AS date_abonnement_13, t0.date_expiration AS date_expiration_14, t0.validity AS validity_15, t0.user_an_id AS user_an_id_16 FROM annuaire t0 WHERE t0.id = ?
Parameters:
[
  "13"
]
2 0.17 ms
SELECT t1.id AS id_2, t1.email AS email_3, t1.roles AS roles_4, t1.password AS password_5, t1.type_compte AS type_compte_6, t1.is_verified AS is_verified_7, t1.tel AS tel_8, t1.approve AS approve_9, t1.facebook_id AS facebook_id_10, t1.is_super_admin AS is_super_admin_11, t1.facebook AS facebook_12, t1.twitter AS twitter_13, t1.instagram AS instagram_14, t1.linkedin AS linkedin_15, t1.youtube AS youtube_16, t1.whatsapp AS whatsapp_17, t1.pinterest AS pinterest_18, t1.facebook_access_token AS facebook_access_token_19, t1.twitter_id AS twitter_id_20, t1.twitter_access_token AS twitter_access_token_21, t1.google_id AS google_id_22, t1.google_access_token AS google_access_token_23, t1.total_credits AS total_credits_24, t0.logo AS logo_25, t0.nom_professionel AS nom_professionel_26, t0.addresse AS addresse_27, t0.marques AS marques_28, t0.website AS website_29, t0.image_size AS image_size_30, t0.updated_at AS updated_at_31, t0.description AS description_32, t1.compte FROM professionel t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
  55
]
3 0.22 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.image_pub AS image_pub_2, p0_.created_at AS created_at_3, p0_.image_size AS image_size_4, p0_.updated_at AS updated_at_5, p0_.description AS description_6, p0_.admin_id AS admin_id_7 FROM pub_infos p0_ ORDER BY p0_.id DESC LIMIT 3
Parameters:
[]
4 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.validity AS validity_3, t0.location AS location_4, t0.category AS category_5, t0.link AS link_6, t0.file_pub AS file_pub_7, t0.file_size AS file_size_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.expireted_at AS expireted_at_11, t0.back_link AS back_link_12 FROM pub t0 WHERE t0.location = ?
Parameters:
[
  "Entéte du site"
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Pub 14
App\Entity\PubInfos 3
App\Entity\User 2
App\Entity\Annuaire 1

Entities Mapping

Class Mapping errors
App\Entity\Annuaire No errors.
App\Entity\User
  • The association App\Entity\User#boutiques refers to the owning side field App\Entity\Boutique#userId which does not exist.
App\Entity\Professionel
  • The association App\Entity\Professionel#boutiques refers to the owning side field App\Entity\Boutique#userId which does not exist.
  • The mappings App\Entity\Professionel#artilces and App\Entity\Article#professionel are inconsistent with each other.
App\Entity\Annonce No errors.
App\Entity\Boutique No errors.
App\Entity\Code No errors.
App\Entity\Avis No errors.
App\Entity\OffreCredit No errors.
App\Entity\JournalCredit No errors.
App\Entity\Message No errors.
App\Entity\UserOffreCredit
  • The association App\Entity\UserOffreCredit#offre refers to the inverse side field App\Entity\OffreCredit#userOffreCredits which does not exist.
App\Entity\Vitrine No errors.
App\Entity\Article
  • The association App\Entity\Article#professionel refers to the inverse side field App\Entity\Professionel#articles which does not exist.
App\Entity\Contact No errors.
App\Entity\PubInfos No errors.
App\Entity\Admin
  • The association App\Entity\Admin#boutiques refers to the owning side field App\Entity\Boutique#userId which does not exist.
App\Entity\Pub No errors.