GET https://joenglish.dev123.site/buy-voucher?value=12900

Response
200 OK
IP
216.73.216.151
Profiled on
Token
148f3f

Query Metrics

3 Database Queries
3 Different statements
8.03 ms Query time
0 Invalid entities
2 Managed entities

Queries

Group similar statements

#▲ Time Info
1 4.90 ms 
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.email AS email_4, t0.parent_email AS parent_email_5, t0.roles AS roles_6, t0.name AS name_7, t0.profile_image AS profile_image_8, t0.emailresetkey AS emailresetkey_9, t0.phone AS phone_10, t0.notify_new_course_by_followed_tutor_available AS notify_new_course_by_followed_tutor_available_11, t0.notify_new_course_by_followed_tutor_available_email AS notify_new_course_by_followed_tutor_available_email_12, t0.notify_new_lesson_available AS notify_new_lesson_available_13, t0.notify_new_lesson_planned AS notify_new_lesson_planned_14, t0.notify_special_promo AS notify_special_promo_15, t0.notify_comment_response AS notify_comment_response_16, t0.mute_until AS mute_until_17, t0.stripe_customer AS stripe_customer_18, t0.currency AS currency_19, t0.billing_interval AS billing_interval_20, t0.uuid AS uuid_21, t0.referral_points AS referral_points_22, t0.notify_new_lesson_available_email AS notify_new_lesson_available_email_23, t0.notify_new_lesson_planned_email AS notify_new_lesson_planned_email_24, t0.notify_special_promo_email AS notify_special_promo_email_25, t0.notify_comment_response_email AS notify_comment_response_email_26, t0.notify_comment_like_response AS notify_comment_like_response_27, t0.notify_comment_like_response_email AS notify_comment_like_response_email_28, t0.marketing_consent AS marketing_consent_29, t0.can_deliver_individual_lessons AS can_deliver_individual_lessons_30, t0.can_deliver_live_lessons AS can_deliver_live_lessons_31, t0.bio AS bio_32, t0.lessons_delivered AS lessons_delivered_33, t0.subscribed_till AS subscribed_till_34, t0.date_of_birth AS date_of_birth_35, t0.location AS location_36, t0.country AS country_37, t0.login_streak AS login_streak_38, t0.video AS video_39, t0.completed_weekly_goals_count AS completed_weekly_goals_count_40, t0.completed_weekly_goals_date AS completed_weekly_goals_date_41, t0.has_recieved_subscription_activation_email AS has_recieved_subscription_activation_email_42, t0.device_id AS device_id_43, t0.school_types AS school_types_44, t0.voucher_code AS voucher_code_45, t0.last_booking_time AS last_booking_time_46, t0.tutor_suitability AS tutor_suitability_47, t0.stream_url AS stream_url_48, t0.stream_key AS stream_key_49, t0.allow_public_profile AS allow_public_profile_50, t0.invisible_in_search_and_requests AS invisible_in_search_and_requests_51, t0.active AS active_52, t0.deleted AS deleted_53, t0.created_at AS created_at_54, t0.updated_at AS updated_at_55, t0.teaches_at_id AS teaches_at_id_56, t0.student_at_id AS student_at_id_57, t58.id AS id_59, t58.subscribed_till AS subscribed_till_60, t58.email AS email_61, t58.phone AS phone_62, t58.school_types AS school_types_63, t58.title AS title_64, t58.content AS content_65, t58.active AS active_66, t58.deleted AS deleted_67, t58.created_at AS created_at_68, t58.updated_at AS updated_at_69, t58.administrator_id AS administrator_id_70, t0.taught_by_id AS taught_by_id_71, t0.school_class_id AS school_class_id_72, t73.id AS id_74, t73.school_type AS school_type_75, t73.title AS title_76, t73.content AS content_77, t73.active AS active_78, t73.deleted AS deleted_79, t73.created_at AS created_at_80, t73.updated_at AS updated_at_81, t73.class_user_id AS class_user_id_82, t73.school_id AS school_id_83, t73.teacher_id AS teacher_id_84 FROM Users t0 LEFT JOIN school t58 ON t58.administrator_id = t0.id LEFT JOIN school_class t73 ON t73.class_user_id = t0.id WHERE t0.id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
2 2.07 ms 
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.user_id AS user_id_4, t5.id AS id_6, t5.username AS username_7, t5.password AS password_8, t5.email AS email_9, t5.parent_email AS parent_email_10, t5.roles AS roles_11, t5.name AS name_12, t5.profile_image AS profile_image_13, t5.emailresetkey AS emailresetkey_14, t5.phone AS phone_15, t5.notify_new_course_by_followed_tutor_available AS notify_new_course_by_followed_tutor_available_16, t5.notify_new_course_by_followed_tutor_available_email AS notify_new_course_by_followed_tutor_available_email_17, t5.notify_new_lesson_available AS notify_new_lesson_available_18, t5.notify_new_lesson_planned AS notify_new_lesson_planned_19, t5.notify_special_promo AS notify_special_promo_20, t5.notify_comment_response AS notify_comment_response_21, t5.mute_until AS mute_until_22, t5.stripe_customer AS stripe_customer_23, t5.currency AS currency_24, t5.billing_interval AS billing_interval_25, t5.uuid AS uuid_26, t5.referral_points AS referral_points_27, t5.notify_new_lesson_available_email AS notify_new_lesson_available_email_28, t5.notify_new_lesson_planned_email AS notify_new_lesson_planned_email_29, t5.notify_special_promo_email AS notify_special_promo_email_30, t5.notify_comment_response_email AS notify_comment_response_email_31, t5.notify_comment_like_response AS notify_comment_like_response_32, t5.notify_comment_like_response_email AS notify_comment_like_response_email_33, t5.marketing_consent AS marketing_consent_34, t5.can_deliver_individual_lessons AS can_deliver_individual_lessons_35, t5.can_deliver_live_lessons AS can_deliver_live_lessons_36, t5.bio AS bio_37, t5.lessons_delivered AS lessons_delivered_38, t5.subscribed_till AS subscribed_till_39, t5.date_of_birth AS date_of_birth_40, t5.location AS location_41, t5.country AS country_42, t5.login_streak AS login_streak_43, t5.video AS video_44, t5.completed_weekly_goals_count AS completed_weekly_goals_count_45, t5.completed_weekly_goals_date AS completed_weekly_goals_date_46, t5.has_recieved_subscription_activation_email AS has_recieved_subscription_activation_email_47, t5.device_id AS device_id_48, t5.school_types AS school_types_49, t5.voucher_code AS voucher_code_50, t5.last_booking_time AS last_booking_time_51, t5.tutor_suitability AS tutor_suitability_52, t5.stream_url AS stream_url_53, t5.stream_key AS stream_key_54, t5.allow_public_profile AS allow_public_profile_55, t5.invisible_in_search_and_requests AS invisible_in_search_and_requests_56, t5.active AS active_57, t5.deleted AS deleted_58, t5.created_at AS created_at_59, t5.updated_at AS updated_at_60, t5.teaches_at_id AS teaches_at_id_61, t5.student_at_id AS student_at_id_62, t5.taught_by_id AS taught_by_id_63, t5.school_class_id AS school_class_id_64, t0.badge_id AS badge_id_65 FROM user_badge t0 INNER JOIN Users t5 ON t0.user_id = t5.id WHERE t0.user_id IN (?) ORDER BY t0.created_at DESC
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
3 1.06 ms 
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM setting t0 WHERE t0.id = ?
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\User 1
App\Entity\Setting 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\School No errors.
App\Entity\SchoolClass No errors.
App\Entity\Page No errors.
App\Entity\Menu No errors.
App\Entity\Notifications No errors.
App\Entity\UserMessage No errors.
App\Entity\LessonEvaluation No errors.
App\Entity\LessonTracking No errors.
App\Entity\OnboardingVideoTracking No errors.
App\Entity\TimeLog No errors.
App\Entity\ForumPosts No errors.
App\Entity\ForumComments No errors.
App\Entity\LiveLessonQuestion No errors.
App\Entity\LiveLessonTracking No errors.
App\Entity\StripeUserSubscription No errors.
App\Entity\ForumCommentReplies No errors.
App\Entity\ForumCommentLikes No errors.
App\Entity\Courses No errors.
App\Entity\SessionBooking No errors.
App\Entity\SessionInterest No errors.
App\Entity\TutorSessionFeedback No errors.
App\Entity\LevelInterest No errors.
App\Entity\PodcastTracking No errors.
App\Entity\PodcastEvaluation No errors.
App\Entity\UserBadge No errors.
App\Entity\UserLogin No errors.
App\Entity\BadgeProgress No errors.
App\Entity\ForumPostLike No errors.
App\Entity\UserObjective No errors.
App\Entity\SchoolNotificationRead No errors.
App\Entity\QuizTracking No errors.
App\Entity\FriendRequest No errors.
App\Entity\UserBlock No errors.
App\Entity\Badge No errors.
App\Entity\Setting No errors.