GET https://api.simulatorestrategico.com/scheduled_learnings/active

Query Metrics

6 Database Queries
6 Different statements
2.89 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.33 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:
[
  "lafranca.vincent@icloud.com"
]
2 0.28 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:
[
  587
]
3 0.38 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:
[
  889
]
4 0.81 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.status AS status_2, s0_.created_at AS created_at_3, s0_.study_session AS study_session_4, s0_.competition_id AS competition_id_5, s0_.user_id AS user_id_6 FROM scheduled_learning s0_ INNER JOIN learning l1_ ON s0_.id = l1_.scheduled_learning_id WHERE s0_.user_id = ? AND s0_.status = ? ORDER BY s0_.id DESC LIMIT 1
Parameters:
[
  587
  "ACTIVE"
]
5 0.32 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.with_dataset AS with_dataset_3, t0.active AS active_4, t0.hero_image AS hero_image_5, t0.name AS name_6, t0.content AS content_7, t0.created_at AS created_at_8 FROM competition t0 WHERE t0.id = ?
Parameters:
[
  22
]
6 0.77 ms
SELECT t0.id AS id_1, t0.day AS day_2, t0.mode AS mode_3, t0.score AS score_4, t0.start_at AS start_at_5, t0.end_at AS end_at_6, t0.created_at AS created_at_7, t0.scheduled_at AS scheduled_at_8, t0.status AS status_9, t0.options AS options_10, t0.admin_note AS admin_note_11, t0.user_id AS user_id_12, t0.dataset_version_id AS dataset_version_id_13, t0.scheduled_learning_id AS scheduled_learning_id_14 FROM learning t0 WHERE t0.scheduled_learning_id = ?
Parameters:
[
  2363
]

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\Learning No errors.
App\Entity\Competition No errors.
App\Entity\DatasetVersion No errors.
App\Entity\UserAnswer No errors.