Query Metrics
16
Database Queries
3
Different statements
23.67 ms
Query time
5
Invalid entities
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21.21 ms (89.61%) |
1 |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.image_size AS image_size_3, t0.title AS title_4, t0.description AS description_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.type_art AS type_art_8, t0.professionel_id AS professionel_id_9, t0.admin_id AS admin_id_10 FROM article t0 WHERE t0.admin_id = ? AND t0.type_art IS NULL ORDER BY t0.updated_at DESC, t0.created_at DESC
Parameters:
[
4
]
|
||||||||||||||||||||
2.17 ms (9.15%) |
14 |
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:
[ "4" "en" "App\Entity\User" ] |
||||||||||||||||||||
0.29 ms (1.24%) |
1 |
SELECT t0.id AS id_4, t0.email AS email_5, t0.roles AS roles_6, t0.password AS password_7, t0.type_compte AS type_compte_8, t0.is_verified AS is_verified_9, t0.tel AS tel_10, t0.approve AS approve_11, t0.facebook_id AS facebook_id_12, t0.is_super_admin AS is_super_admin_13, t0.facebook AS facebook_14, t0.twitter AS twitter_15, t0.instagram AS instagram_16, t0.linkedin AS linkedin_17, t0.youtube AS youtube_18, t0.whatsapp AS whatsapp_19, t0.pinterest AS pinterest_20, t0.facebook_access_token AS facebook_access_token_21, t0.twitter_id AS twitter_id_22, t0.twitter_access_token AS twitter_access_token_23, t0.google_id AS google_id_24, t0.google_access_token AS google_access_token_25, t0.compte, t1.logo AS logo_26, t1.nom_professionel AS nom_professionel_27, t1.addresse AS addresse_28, t1.marques AS marques_29, t1.website AS website_30, t1.image_size AS image_size_31, t1.updated_at AS updated_at_32, t1.description AS description_33, t2.prenom AS prenom_34, t2.nom AS nom_35, t2.civility AS civility_36, t2.photo AS photo_37, t2.image_size AS image_size_38, t2.updated_at AS updated_at_39, t3.photo AS photo_40, t3.image_size AS image_size_41, t3.updated_at AS updated_at_42 FROM user t0 LEFT JOIN professionel t1 ON t0.id = t1.id LEFT JOIN particulier t2 ON t0.id = t2.id LEFT JOIN admin t3 ON t0.id = t3.id WHERE t0.is_super_admin = ?
Parameters:
[
1
]
|
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\User |
|
App\Entity\Professionel |
|
App\Entity\Particulier |
|
App\Entity\Admin |
|
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\Article |
|
App\Entity\PubInfos | No errors. |
App\Entity\Portrait | No errors. |
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation | No errors. |
Gedmo\Translatable\Entity\Translation | No errors. |
App\Entity\Comment | No errors. |