Query Metrics
5
Database Queries
5
Different statements
47.16 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
24.33 ms (51.60%) |
1 |
INSERT INTO `mc_http_log` (`user_id`, `request_at`, `url`, `request`, `response`) VALUES (:user_id, NOW(), :url, :request, :response)
Parameters:
[ "user_id" => 794 "url" => "/uk/student/start-training" "request" => "{"type":"Game","themeUniqueId":1,"complexity":"1","level":"2","iterator":"2","combine":"1"}" "response" => "ERROR- looping in a file MasterNumberGeneratorService" ] |
21.93 ms (46.51%) |
1 |
DELETE FROM `mc_http_log` WHERE `id` = :id
Parameters:
[ "id" => "545" ] |
0.55 ms (1.17%) |
1 |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.updated AS updated_13, t0.created AS created_14, t0.avatar_file_name AS avatar_file_name_15, t0.balance AS balance_16, t0.abacoins AS abacoins_17, t0.first_name AS first_name_18, t0.last_name AS last_name_19, t0.phone AS phone_20, t0.address AS address_21, t0.language AS language_22, t0.type AS type_23, t0.birthday AS birthday_24, t0.theme_color AS theme_color_25, t0.is_deleted AS is_deleted_26, t0.is_available_rating AS is_available_rating_27, t0.show_info_about_payment AS show_info_about_payment_28, t0.type_available_rating AS type_available_rating_29, t0.date_of_change_status AS date_of_change_status_30, t0.country_id AS country_id_31, t0.city_id AS city_id_32, t0.school_id AS school_id_33, t0.group_id AS group_id_34, t35.id AS id_36, t35.cost_full_course AS cost_full_course_37, t35.cost_partly_course AS cost_partly_course_38, t35.status AS status_39, t35.sort_theme_id AS sort_theme_id_40, t35.sort_theme_level AS sort_theme_level_41, t35.email_signature AS email_signature_42, t35.is_subscribed AS is_subscribed_43, t35.user_id AS user_id_44 FROM fos_user t0 LEFT JOIN mc_student_profile t35 ON t35.user_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
794
]
|
0.22 ms (0.47%) |
1 |
SELECT COUNT(m0_.id) AS sclr_0 FROM mc_notification m0_ INNER JOIN ms_user_notification m1_ ON m0_.id = m1_.notification_id WHERE (m1_.isRead = ? AND m1_.user_id = ?) AND m1_.is_deleted_by_recipient = ?
Parameters:
[ 0 794 0 ] |
0.12 ms (0.25%) |
1 |
SELECT COUNT(m0_.id) AS sclr_0 FROM mc_users_tasks m0_ WHERE m0_.status = ? AND m0_.user_id = ?
Parameters:
[ 0 794 ] |
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 |
---|---|
FOS\UserBundle\Model\User | No errors. |
MentalSchool\AppBundle\Entity\User | No errors. |
MentalSchool\AppBundle\Entity\Country | No errors. |
MentalSchool\AppBundle\Entity\City | No errors. |
MentalSchool\AppBundle\Entity\School | No errors. |
MentalSchool\AppBundle\Entity\SchoolGroup | No errors. |
MentalSchool\AppBundle\Entity\StudentProfile | No errors. |
MentalSchool\AppBundle\Entity\TaskTemplate |
|
MentalSchool\AppBundle\Entity\Task | No errors. |
MentalSchool\AppBundle\Entity\UserPermissions | No errors. |
MentalSchool\AppBundle\Entity\UsersTasks | No errors. |
MentalSchool\AppBundle\Entity\PaymentHistory | No errors. |
MentalSchool\AppBundle\Entity\AbacoinHistory | No errors. |
MentalSchool\AppBundle\Entity\UserNotification | No errors. |
MentalSchool\AppBundle\Entity\Notification | No errors. |