http://abacus.globegs.com/uk/student/start-training

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
29.39 ms
(59.99%)
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":5,"complexity":0,"level":"50","iterator":"2","combine":""}"
  "response" => "ERROR- looping in a file NumberGeneratorService"
]
18.69 ms
(38.14%)
1
DELETE FROM `mc_http_log` WHERE `id` = :id
Parameters:
[
  "id" => "547"
]
0.58 ms
(1.18%)
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.45%)
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.24%)
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
  • The mappings MentalSchool\AppBundle\Entity\TaskTemplate#subtaskTemplate and MentalSchool\AppBundle\Entity\SubtaskTemplate#taskTemplate are inconsistent with each other.
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.