Symfony Profiler

Query Metrics

10 Database Queries

10 Different statements

21.38 ms Query time

1 Invalid entities

Queries


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
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
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 = ?
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_ WHERE s0_.id = ?
"START TRANSACTION"
UPDATE scheduled_learning SET study_session = ? WHERE id = ?
"COMMIT"
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 = ?
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 = ?
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 = ?

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.

Symfony Profiler

PATCH https://api.simulatorestrategico.com/scheduled_learnings/2362

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping