GET http://interview-coach.net/

Query Metrics

11 Database Queries
8 Different statements
175.17 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 100.89 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.email AS email_4, t0.uuid AS uuid_5, t0.date_created AS date_created_6 FROM user t0 WHERE t0.uuid = ? LIMIT 1
Parameters:
[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#302
    __toString(): "03d46eb4-2f0e-4c84-81f1-166ea8f3654e"
  }
]
2 0.65 ms
"START TRANSACTION"
Parameters:
[]
3 1.53 ms
INSERT INTO user (username, roles, email, uuid, date_created) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "03d46eb4-2f0e-4c84-81f1-166ea8f3654e"
  "["ROLE_USER"]"
  ""
  "03d46eb4-2f0e-4c84-81f1-166ea8f3654e"
  "2025-02-22 21:24:58"
]
4 7.50 ms
"COMMIT"
Parameters:
[]
5 55.90 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.email AS email_4, t0.uuid AS uuid_5, t0.date_created AS date_created_6 FROM user t0 WHERE t0.uuid = ? LIMIT 1
Parameters:
[
  "03d46eb4-2f0e-4c84-81f1-166ea8f3654e"
]
6 0.96 ms
SELECT t0.id AS id_1, t0.category_id AS category_id_2, t0.title AS title_3, t0.url AS url_4, t0.date_created AS date_created_5, t0.level AS level_6, t0.image AS image_7, t0.category_id AS category_id_8 FROM quiz t0
Parameters:
[]
7 1.24 ms
SELECT t0.id AS id_1, t0.text AS text_2, t0.category_id AS category_id_3, t0.date_created AS date_created_4, t0.title AS title_5, t0.url AS url_6, t0.image AS image_7, t0.category_id AS category_id_8 FROM post t0
Parameters:
[]
8 0.47 ms
"START TRANSACTION"
Parameters:
[]
9 0.90 ms
INSERT INTO user_log (user_id, action, data, date_created) VALUES (?, ?, ?, ?)
Parameters:
[
  64077
  "home_view"
  "[]"
  "2025-02-22 21:24:58"
]
10 4.05 ms
"COMMIT"
Parameters:
[]
11 1.09 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.date_created AS date_created_4, t0.image AS image_5, t0.description AS description_6 FROM quiz_category t0 WHERE t0.id = ?
Parameters:
[
  3
]

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 No errors.
App\Entity\Quiz
  • The mappings App\Entity\Quiz#category and App\Entity\QuizCategory#quizzes are inconsistent with each other.
App\Entity\QuizCategory
  • The association App\Entity\QuizCategory#quizzes refers to the owning side field App\Entity\Quiz#category_id which is not defined as association, but as field.
  • The association App\Entity\QuizCategory#quizzes refers to the owning side field App\Entity\Quiz#category_id which does not exist.
  • The association App\Entity\QuizCategory#posts refers to the owning side field App\Entity\Post#category_id which is not defined as association, but as field.
  • The association App\Entity\QuizCategory#posts refers to the owning side field App\Entity\Post#category_id which does not exist.
App\Entity\QuizQuestion No errors.
App\Entity\UserQuizLog No errors.
App\Entity\Post
  • The mappings App\Entity\Post#category and App\Entity\QuizCategory#posts are inconsistent with each other.
App\Entity\UserLog No errors.