Query Metrics
8
Database Queries
6
Different statements
4.50 ms
Query time
2
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.96 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.user_status AS user_status_4, t0.password AS password_5, t0.cookie AS cookie_6, t0.lastAccess AS lastAccess_7, t0.creation_date AS creation_date_8, t0.ip AS ip_9, t0.language AS language_10, t0.totalVisit AS totalVisit_11, t0.discriminator FROM sw_visitor t0 WHERE t0.cookie = ? AND t0.discriminator IN ('sw_visitor', 'sw_visitor_extend') LIMIT 1
Parameters:
[
"20251205-004343_69322abff15ed=deleted; expires=Thu, 05 Dec 2024 00:43:44 GMT; Max-Age=0; path=/; httponly; samesite=lax"
]
|
| 2 | 0.07 ms |
"START TRANSACTION"
Parameters:
[] |
| 3 | 0.19 ms |
UPDATE sw_visitor SET lastAccess = ?, totalVisit = ? WHERE id = ?
Parameters:
[ "2025-12-05 00:46:56" 24 5027664 ] |
| 4 | 0.41 ms |
"COMMIT"
Parameters:
[] |
| 5 | 0.20 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.user_status AS user_status_4, t0.password AS password_5, t0.cookie AS cookie_6, t0.lastAccess AS lastAccess_7, t0.creation_date AS creation_date_8, t0.ip AS ip_9, t0.language AS language_10, t0.totalVisit AS totalVisit_11, t0.discriminator FROM sw_visitor t0 WHERE t0.username = ? AND t0.discriminator IN ('sw_visitor', 'sw_visitor_extend') LIMIT 2
Parameters:
[
"pixivdump1"
]
|
| 6 | 0.07 ms |
"START TRANSACTION"
Parameters:
[] |
| 7 | 0.16 ms |
INSERT INTO sw_visitor (username, roles, user_status, password, cookie, lastAccess, creation_date, ip, language, totalVisit, discriminator) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "pixivdump1" "["ROLE_USER"]" "PENDING_STATUS" "$2y$13$Tne63R9WkqDCptZeNVfec.pTIcViIs.gUNf2t60b0Xewpb2BFvKOC" "user-connected" "2025-12-05 00:46:57" "2025-12-05 00:46:56" null "fr" 1 "sw_visitor" ] |
| 8 | 0.45 ms |
"COMMIT"
Parameters:
[] |
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 |
|---|---|
| SkinSoft\SkinWebBundle\Entity\Visitor |
|
| App\Entity\ExtendVisitor |
|
| SkinSoft\SkinWebBundle\Entity\Favourite | No errors. |
| SkinSoft\SkinWebBundle\Entity\Publication | No errors. |
| SkinSoft\SkinWebBundle\Entity\SearchHistory | No errors. |
| SkinSoft\SkinWebBundle\Entity\SavedSearch | No errors. |
| SkinSoft\SkinWebBundle\Entity\LatestNotice | No errors. |