https://www.puzzlax.com/api/react/user/chats/unread_messages

Query Metrics

2 Database Queries
2 Different statements
1.84 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.84 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.uuid AS uuid_3, t0.name AS name_4, t0.phone AS phone_5, t0.roles AS roles_6, t0.password AS password_7, t0.paths AS paths_8, t0.access_code AS access_code_9, t0.refresh_token AS refresh_token_10, t0.pic AS pic_11, t0.birth_date AS birth_date_12, t0.country AS country_13, t0.city AS city_14, t0.address AS address_15, t0.zip AS zip_16, t0.company AS company_17, t0.profession AS profession_18, t0.is_verified AS is_verified_19, t0.is_active AS is_active_20, t0.is_finished_quiz AS is_finished_quiz_21, t0.auto_login AS auto_login_22, t0.is_banned AS is_banned_23, t0.is_new AS is_new_24, t0.google_id AS google_id_25, t0.is_deleted AS is_deleted_26, t0.deleted_at AS deleted_at_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.referral_id AS referral_id_30 FROM user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "zorina@puzzlax.com"
]
2 0.99 ms
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.sender AS sender_2, c0_.status AS status_3, c0_.created_at AS created_at_4, c0_.content AS content_5, c0_.attach AS attach_6, c0_.chat_id AS chat_id_7 FROM chat_message c0_ INNER JOIN chat c1_ ON c0_.chat_id = c1_.id WHERE c1_.user_id = ? AND c0_.created_at >= ? AND c0_.status = ? ORDER BY c0_.id DESC
Parameters:
[
  348
  "2025-10-18 14:54:02"
  "sent"
]

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
  • The mappings App\Entity\User#referral and App\Entity\Referral#users are inconsistent with each other.
App\Entity\Referral
  • The association App\Entity\Referral#users refers to the owning side field App\Entity\User#Referral which does not exist.
App\Entity\UserQuizStep No errors.
App\Entity\UserCheckListStep No errors.
App\Entity\UserOrderService No errors.
App\Entity\UserLog No errors.
App\Entity\UserInstructionProgress No errors.
App\Entity\Tag No errors.
App\Entity\ProgressInstruction No errors.
App\Entity\UserOrderMessage No errors.
App\Entity\UserCheckList No errors.
App\Entity\UserBrief No errors.
App\Entity\UserExtraData No errors.
App\Entity\UserInstructionCategory No errors.
App\Entity\Chat No errors.
App\Entity\UserSubscription No errors.
App\Entity\UserSubscriptionTransaction No errors.
App\Entity\UserFile No errors.
App\Entity\UserCalendarEvent No errors.
App\Entity\ChatMessage No errors.