Query Metrics

4 Database Queries
4 Different statements
23.22 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
22.30 ms
(96.05%)
1
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:
[
  "20251204-224644_69320f54d5312=deleted; expires=Wed, 04 Dec 2024 22:46:44 GMT; Max-Age=0; path=/; httponly; samesite=lax"
]
0.66 ms
(2.85%)
1
"COMMIT"
Parameters:
[]
0.18 ms
(0.76%)
1
UPDATE sw_visitor SET lastAccess = ?, totalVisit = ? WHERE id = ?
Parameters:
[
  "2025-12-04 23:45:32"
  2
  5027378
]
0.08 ms
(0.34%)
1
"START TRANSACTION"
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
  • The field SkinSoft\SkinWebBundle\Entity\Visitor#latestNotices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity SkinSoft\SkinWebBundle\Entity\LatestNotice#visitor does not contain the required 'inversedBy="latestNotices"' attribute.
App\Entity\ExtendVisitor
  • The field App\Entity\ExtendVisitor#latestNotices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity SkinSoft\SkinWebBundle\Entity\LatestNotice#visitor does not contain the required 'inversedBy="latestNotices"' attribute.
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.