POST https://api.simulatorestrategico.com/notes

Query Metrics

8 Database Queries
8 Different statements
7.25 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.47 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.last_name AS last_name_6, t0.tax_id AS tax_id_7 FROM `user` t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "paffile488@gmail.com"
]
2 0.46 ms
SELECT m0_.id AS id_0, m0_.uuid AS uuid_1, m0_.expire_at AS expire_at_2, m0_.created_at AS created_at_3, m0_.license_id AS license_id_4, m0_.user_id AS user_id_5 FROM membership m0_ WHERE m0_.user_id = ? ORDER BY m0_.id DESC LIMIT 1
Parameters:
[
  678
]
3 0.42 ms
SELECT t0.price_payed AS price_payed_1, t0.currency AS currency_2, t0.gateway AS gateway_3, t0.gateway_identifier AS gateway_identifier_4, t0.billing_address AS billing_address_5, t0.created_at AS created_at_6, t0.payed_at AS payed_at_7, t0.is_invoiced AS is_invoiced_8, t0.membership_id AS membership_id_9 FROM transaction t0 WHERE t0.membership_id = ?
Parameters:
[
  1092
]
4 1.19 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url_image AS url_image_3, t0.dataset_question_id AS dataset_question_id_4, t0.answers AS answers_5, t0.subject_id AS subject_id_6, t7.id AS id_8, t7.content AS content_9, t7.question_id AS question_id_10, t7.user_id AS user_id_11 FROM question t0 LEFT JOIN notes t7 ON t7.question_id = t0.id WHERE t0.id = ?
Parameters:
[
  471244
]
5 0.43 ms
"START TRANSACTION"
Parameters:
[]
6 0.89 ms
INSERT INTO notes (content, question_id, user_id) VALUES (?, ?, ?)
Parameters:
[
  "saturno è fatto di ghiaccio"
  471244
  678
]
7 2.74 ms
"COMMIT"
Parameters:
[]
8 0.66 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.question_id AS question_id_3, t0.user_id AS user_id_4 FROM notes t0 WHERE t0.id = ?
Parameters:
[
  42312
]

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
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken No errors.
App\Entity\RefreshToken No errors.
App\Entity\User No errors.
App\Entity\Dataset No errors.
App\Entity\Membership No errors.
App\Entity\License No errors.
App\Entity\Transaction No errors.
App\Entity\Question No errors.
App\Entity\Subject No errors.
App\Entity\Note No errors.
App\Entity\DatasetVersion No errors.
App\Entity\Tag No errors.
App\Entity\Suggestions No errors.
App\Entity\Highlight
  • The association App\Entity\Highlight#owner refers to the inverse side field App\Entity\User#highlights which does not exist.