Query Metrics
6
Database Queries
5
Different statements
3.72 ms
Query time
9
Invalid entities
Queries
default connection
#▲ | Time | Info |
---|---|---|
1 | 0.88 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.department AS department_4, t0.position AS position_5, t0.email AS email_6, t0.password AS password_7, t0.phone AS phone_8, t0.mobile AS mobile_9, t0.website AS website_10, t0.roles AS roles_11, t0.activation_token AS activation_token_12, t0.activation_token_created_at AS activation_token_created_at_13, t0.is_enabled AS is_enabled_14, t0.expire_at AS expire_at_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.application_master AS application_master_18, t0.lang AS lang_19, t0.customer_associated AS customer_associated_20, t0.hide_in_pa AS hide_in_pa_21, t0.is_hotline AS is_hotline_22, t0.customer_id AS customer_id_23, t0.profile_picture_id AS profile_picture_id_24 FROM user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"bechir.f@axelites.com"
]
|
2 | 0.68 ms |
SELECT d0_.id AS id_0, d0_.topic AS topic_1, d0_.created_at AS created_at_2, d0_.type AS type_3, d0_.updated_at AS updated_at_4, d0_.user_id AS user_id_5, d0_.document_id AS document_id_6, d0_.site_id AS site_id_7 FROM discussion d0_ WHERE d0_.site_id = ? AND d0_.type = ? ORDER BY d0_.updated_at DESC
Parameters:
[ "38319" "forum" ] |
3 | 0.67 ms |
SELECT d0_.id AS id_0, d0_.topic AS topic_1, d0_.created_at AS created_at_2, d0_.type AS type_3, d0_.updated_at AS updated_at_4, d0_.user_id AS user_id_5, d0_.document_id AS document_id_6, d0_.site_id AS site_id_7 FROM discussion d0_ WHERE d0_.site_id = ? AND d0_.type = ? ORDER BY d0_.updated_at DESC
Parameters:
[ "38319" "forum" ] |
4 | 0.45 ms |
SELECT t0.id AS id_1, t0.message_text AS message_text_2, t0.created_at AS created_at_3, t0.is_hotline_readed AS is_hotline_readed_4, t0.discussion_id AS discussion_id_5, t0.sender_id AS sender_id_6 FROM message t0 WHERE t0.discussion_id = ?
Parameters:
[
101
]
|
5 | 0.54 ms |
SELECT t0.id AS id_1, t0.old_id AS old_id_2, t0.code AS code_3, t0.name AS name_4, t0.kind AS kind_5, t0.address AS address_6, t0.additional_address AS additional_address_7, t0.zipcode AS zipcode_8, t0.phone AS phone_9, t0.naf AS naf_10, t0.adr AS adr_11, t0.fax AS fax_12, t0.groupe AS groupe_13, t0.coordinates_lambert AS coordinates_lambert_14, t0.is_active AS is_active_15, t0.type AS type_16, t0.city AS city_17, t0.reference AS reference_18, t0.init_site AS init_site_19, t0.path AS path_20, t0.year AS year_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.parent_id AS parent_id_24, t0.country_id AS country_id_25, t0.customer_id AS customer_id_26 FROM site t0 WHERE t0.id = ?
Parameters:
[
38319
]
|
6 | 0.50 ms |
SELECT t0.id AS id_1, t0.old_id AS old_id_2, t0.code AS code_3, t0.reference AS reference_4, t0.name AS name_5, t0.year AS year_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM customer t0 WHERE t0.id = ?
Parameters:
[
302
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
bechir | doctrine.dbal.bechir_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
bechir | doctrine.orm.bechir_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
Class | Mapping errors |
---|---|
App\Entity\Discussion |
|
App\Entity\User |
|
App\Entity\Customer |
|
App\Entity\Media | No errors. |
App\Entity\UserSite | No errors. |
App\Entity\Export |
|
App\Entity\Affectation |
|
App\Entity\SiteQuestions | No errors. |
App\Entity\Document | No errors. |
App\Entity\Site |
|
App\Entity\Message | No errors. |
App\Entity\MessageFile | No errors. |
App\Entity\Country | No errors. |
App\Entity\Category | No errors. |
App\Entity\Evaluation |
|
App\Entity\ActionPlan |
|
bechir entity manager
Class | Mapping errors |
---|---|
App\Entity\Discussion |
|