GET https://api.simulatorestrategico.com/scheduled_learnings/2075/learnings

Query Metrics

5 Database Queries
5 Different statements
2.85 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.40 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:
[
  "paolo.marcozzi@libero.it"
]
2 0.29 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:
[
  471
]
3 0.25 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:
[
  717
]
4 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.study_session AS study_session_5, t0.competition_id AS competition_id_6, t0.user_id AS user_id_7 FROM scheduled_learning t0 WHERE t0.id = ?
Parameters:
[
  "2075"
]
5 1.60 ms
SELECT l0_.id AS id_0, l0_.day AS day_1, l0_.mode AS mode_2, l0_.score AS score_3, l0_.start_at AS start_at_4, l0_.end_at AS end_at_5, l0_.created_at AS created_at_6, l0_.scheduled_at AS scheduled_at_7, l0_.status AS status_8, l0_.options AS options_9, l0_.admin_note AS admin_note_10, l0_.user_id AS user_id_11, l0_.dataset_version_id AS dataset_version_id_12, l0_.scheduled_learning_id AS scheduled_learning_id_13 FROM learning l0_ WHERE l0_.scheduled_learning_id = ? ORDER BY l0_.day ASC
Parameters:
[
  2075
]

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\ScheduledLearning
  • The field App\Entity\ScheduledLearning#learnings is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Learning#scheduledLearning does not contain the required 'inversedBy="learnings"' attribute.
App\Entity\Competition No errors.
App\Entity\Learning No errors.
App\Entity\DatasetVersion No errors.
App\Entity\UserAnswer No errors.