Query Metrics
12
Database Queries
6
Different statements
36.42 ms
Query time
2
Invalid entities
3
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
14.60 ms (40.07%) |
2 |
SELECT t0.refresh_token AS refresh_token_1, t0.username AS username_2, t0.valid AS valid_3, t0.id AS id_4 FROM refresh_tokens t0 WHERE t0.refresh_token = ? LIMIT 1
Parameters:
[
"ae99090b0ee7443ae3adea5d12c0cfbc4d20cd28e388c1c54b10ac7d9fa8a62f03a55192fb2ee8e0e19441bc17716f81c49b7e3b09dfa24717fabbeb4590a215"
]
|
|
11.80 ms (32.39%) |
1 |
INSERT INTO user (email, roles, password, facebook_id, google_id, confirmation_token, linkedin_id, apple_id, has_web_device, has_ios_device, has_android_device, username, name, firstname, locale, locale_original, timezone, timezone_original, birthday, last_login, registration_date, gender, city, phone, about, guid, image, original_image, image_cover, original_image_cover, organization, position, facebook, twitter, instagram, linkedin, youtube, is_send_welcome_notification, is_validated, elle_token, last_registration_mail_confirm_date, registration_confirmed_message, history) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "e4f59659b66a25d4e3fd20c43d091062" "[]" "" null null null null null 1 null null "7f1cafaf14aa498b15c162da53dd2894" "" "" "fr" "fr" null null null "2026-03-30 19:24:01" "2026-03-30 19:24:01" "" null null null "8bbf98b5661ac523b87cb1e585c2c1ce" null null null null null null null null null null null 0 0 0 null null null ] |
|
6.37 ms (17.49%) |
3 |
"COMMIT"
Parameters:
[] |
|
1.59 ms (4.37%) |
2 |
INSERT INTO refresh_tokens (refresh_token, username, valid) VALUES (?, ?, ?)
Parameters:
[ "ae99090b0ee7443ae3adea5d12c0cfbc4d20cd28e388c1c54b10ac7d9fa8a62f03a55192fb2ee8e0e19441bc17716f81c49b7e3b09dfa24717fabbeb4590a215" "e4f59659b66a25d4e3fd20c43d091062" "2026-04-30 05:54:01" ] |
|
1.17 ms (3.20%) |
1 |
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.content AS content_4, t0.data1 AS data1_5, t0.data2 AS data2_6, t0.data3 AS data3_7, t0.data4 AS data4_8, t0.data5 AS data5_9, t0.data6 AS data6_10, t0.data7 AS data7_11, t0.data8 AS data8_12, t0.data9 AS data9_13, t0.data10 AS data10_14, t0.link AS link_15, t0.image AS image_16, t0.original_image AS original_image_17, t0.source AS source_18, t0.position AS position_19, t0.date AS date_20, t0.date_update AS date_update_21, t0.date_begin AS date_begin_22, t0.date_end AS date_end_23, t0.is_active AS is_active_24, t0.is_archived AS is_archived_25, t0.data AS data_26, t0.locale AS locale_27, t0.user_id AS user_id_28, t0.original_id AS original_id_29, t0.authentification_process_id AS authentification_process_id_30, t0.item_id AS item_id_31, t0.item_type FROM content t0 WHERE t0.content = ? AND t0.user_id = ? AND t0.item_type IN ('authentification_process_answer')
Parameters:
[ "code" 11256854 ] |
|
0.90 ms (2.48%) |
3 |
"START TRANSACTION"
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| automation | doctrine.dbal.automation_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| automation | doctrine.orm.automation_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\JWT\RefreshToken | 2 |
| App\Entity\User\User | 1 |
automation entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\JWT\RefreshToken | No errors. |
| App\Entity\User\User | No errors. |
| App\Entity\User\UserFollow | No errors. |
| App\Entity\User\UserNotification | No errors. |
| App\Entity\Common\Notification | No errors. |
| App\Entity\Common\BlogArticle | No errors. |
| App\Entity\Common\DeviceToken | No errors. |
| App\Entity\Common\Follow | No errors. |
| App\Entity\User\UserMetadata | No errors. |
| App\Entity\Common\Content | No errors. |
| App\Entity\Module\Registration\RegistrationInvoice | No errors. |
| App\Entity\User\UserRole |
|
| App\Entity\Tool\History\HistoryLog | No errors. |
| App\Entity\User\UserConversation | No errors. |
| App\Entity\User\UserInvitation | No errors. |
| App\Entity\Pro\Statistic\StatisticPosition | No errors. |
| App\Entity\Pro\Statistic\StatisticIbeacon | No errors. |
| App\Entity\Common\StatisticView | No errors. |
| App\Entity\User\UserTag | No errors. |
| App\Entity\Common\HistoryTypes\UserResourcesHistory | No errors. |
| App\Entity\Common\UserGaugeSubscription | No errors. |
| App\Entity\Module\Interactivity\InteractivityTeam | No errors. |
| App\Entity\Tool\Authentification\AuthentificationProcessAnswer | No errors. |
| App\Entity\Tool\Authentification\AuthentificationProcess |
|
| App\Entity\Tool\UserManagement\UserManagementUserCode | No errors. |
| Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken | No errors. |
automation entity manager
No loaded entities.