Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 16
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Data Tables
• VichUploader
• Geocoder
• Elastica
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.email_verification_token AS email_verification_token_6, t0.email_verification_token_expires_at AS email_verification_token_expires_at_7, t0.totp_secret AS totp_secret_8, t0.totp_verified AS totp_verified_9, t0.first_name AS first_name_10, t0.last_name AS last_name_11, t0.created_at AS created_at_12, t0.terms_and_conditions_at AS terms_and_conditions_at_13, t0.reminder_unsubscribed AS reminder_unsubscribed_14, t0.deleted AS deleted_15, t0.deleted_at AS deleted_at_16, t0.company_id AS company_id_17 FROM user t0 WHERE t0.email = ? LIMIT 1

[
  "office.musicmission@gmail.com"
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.email_verification_token AS email_verification_token_6,
  t0.email_verification_token_expires_at AS email_verification_token_expires_at_7,
  t0.totp_secret AS totp_secret_8,
  t0.totp_verified AS totp_verified_9,
  t0.first_name AS first_name_10,
  t0.last_name AS last_name_11,
  t0.created_at AS created_at_12,
  t0.terms_and_conditions_at AS terms_and_conditions_at_13,
  t0.reminder_unsubscribed AS reminder_unsubscribed_14,
  t0.deleted AS deleted_15,
  t0.deleted_at AS deleted_at_16,
  t0.company_id AS company_id_17
FROM
  user t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.email_verification_token AS email_verification_token_6, t0.email_verification_token_expires_at AS email_verification_token_expires_at_7, t0.totp_secret AS totp_secret_8, t0.totp_verified AS totp_verified_9, t0.first_name AS first_name_10, t0.last_name AS last_name_11, t0.created_at AS created_at_12, t0.terms_and_conditions_at AS terms_and_conditions_at_13, t0.reminder_unsubscribed AS reminder_unsubscribed_14, t0.deleted AS deleted_15, t0.deleted_at AS deleted_at_16, t0.company_id AS company_id_17 FROM user t0 WHERE t0.email = 'office.musicmission@gmail.com' LIMIT 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.street AS street_4, t0.zip AS zip_5, t0.city AS city_6, t0.vat_number AS vat_number_7, t0.email AS email_8, t0.telephone AS telephone_9, t0.longitude AS longitude_10, t0.latitude AS latitude_11, t0.is_visible AS is_visible_12, t0.onboarding_completed AS onboarding_completed_13, t0.stripe_customer_id AS stripe_customer_id_14, t0.stripe_subscription_id AS stripe_subscription_id_15, t0.average_rating AS average_rating_16, t0.review_count AS review_count_17, t0.additional_discount AS additional_discount_18, t0.country_id AS country_id_19, t0.edu_package_id AS edu_package_id_20, t21.id AS id_22, t21.slogan AS slogan_23, t21.short_description AS short_description_24, t21.long_description AS long_description_25, t21.website AS website_26, t21.facebook_link AS facebook_link_27, t21.instagram_link AS instagram_link_28, t21.linkedin_link AS linkedin_link_29, t21.vimeo_video_id AS vimeo_video_id_30, t21.vimeo_thumbnail_url AS vimeo_thumbnail_url_31, t21.created_at AS created_at_32, t21.updated_at AS updated_at_33, t21.company_id AS company_id_34, t21.logo_image_id AS logo_image_id_35, t21.main_image_id AS main_image_id_36 FROM company t0 LEFT JOIN company_detail t21 ON t21.company_id = t0.id WHERE t0.id = ?

[
  28
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.street AS street_4,
  t0.zip AS zip_5,
  t0.city AS city_6,
  t0.vat_number AS vat_number_7,
  t0.email AS email_8,
  t0.telephone AS telephone_9,
  t0.longitude AS longitude_10,
  t0.latitude AS latitude_11,
  t0.is_visible AS is_visible_12,
  t0.onboarding_completed AS onboarding_completed_13,
  t0.stripe_customer_id AS stripe_customer_id_14,
  t0.stripe_subscription_id AS stripe_subscription_id_15,
  t0.average_rating AS average_rating_16,
  t0.review_count AS review_count_17,
  t0.additional_discount AS additional_discount_18,
  t0.country_id AS country_id_19,
  t0.edu_package_id AS edu_package_id_20,
  t21.id AS id_22,
  t21.slogan AS slogan_23,
  t21.short_description AS short_description_24,
  t21.long_description AS long_description_25,
  t21.website AS website_26,
  t21.facebook_link AS facebook_link_27,
  t21.instagram_link AS instagram_link_28,
  t21.linkedin_link AS linkedin_link_29,
  t21.vimeo_video_id AS vimeo_video_id_30,
  t21.vimeo_thumbnail_url AS vimeo_thumbnail_url_31,
  t21.created_at AS created_at_32,
  t21.updated_at AS updated_at_33,
  t21.company_id AS company_id_34,
  t21.logo_image_id AS logo_image_id_35,
  t21.main_image_id AS main_image_id_36
FROM
  company t0
  LEFT JOIN company_detail t21 ON t21.company_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.street AS street_4, t0.zip AS zip_5, t0.city AS city_6, t0.vat_number AS vat_number_7, t0.email AS email_8, t0.telephone AS telephone_9, t0.longitude AS longitude_10, t0.latitude AS latitude_11, t0.is_visible AS is_visible_12, t0.onboarding_completed AS onboarding_completed_13, t0.stripe_customer_id AS stripe_customer_id_14, t0.stripe_subscription_id AS stripe_subscription_id_15, t0.average_rating AS average_rating_16, t0.review_count AS review_count_17, t0.additional_discount AS additional_discount_18, t0.country_id AS country_id_19, t0.edu_package_id AS edu_package_id_20, t21.id AS id_22, t21.slogan AS slogan_23, t21.short_description AS short_description_24, t21.long_description AS long_description_25, t21.website AS website_26, t21.facebook_link AS facebook_link_27, t21.instagram_link AS instagram_link_28, t21.linkedin_link AS linkedin_link_29, t21.vimeo_video_id AS vimeo_video_id_30, t21.vimeo_thumbnail_url AS vimeo_thumbnail_url_31, t21.created_at AS created_at_32, t21.updated_at AS updated_at_33, t21.company_id AS company_id_34, t21.logo_image_id AS logo_image_id_35, t21.main_image_id AS main_image_id_36 FROM company t0 LEFT JOIN company_detail t21 ON t21.company_id = t0.id WHERE t0.id = 28;

SELECT COUNT(m0_.id) AS sclr_0 FROM my_course m0_ WHERE m0_.company_id = ?

[
  28
]

SELECT
  COUNT(m0_.id) AS sclr_0
FROM
  my_course m0_
WHERE
  m0_.company_id = ?

SELECT COUNT(m0_.id) AS sclr_0 FROM my_course m0_ WHERE m0_.company_id = 28;

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.sorting AS sorting_4, t0.reminder_delay_days AS reminder_delay_days_5, t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6, t0.reminder_max_sends AS reminder_max_sends_7, t0.mail_template_id AS mail_template_id_8 FROM user_actions t0 WHERE t0.name = ? LIMIT 1

[
  "CREATE_COMPANY"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.sorting AS sorting_4,
  t0.reminder_delay_days AS reminder_delay_days_5,
  t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6,
  t0.reminder_max_sends AS reminder_max_sends_7,
  t0.mail_template_id AS mail_template_id_8
FROM
  user_actions t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.sorting AS sorting_4, t0.reminder_delay_days AS reminder_delay_days_5, t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6, t0.reminder_max_sends AS reminder_max_sends_7, t0.mail_template_id AS mail_template_id_8 FROM user_actions t0 WHERE t0.name = 'CREATE_COMPANY' LIMIT 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.sorting AS sorting_4, t0.reminder_delay_days AS reminder_delay_days_5, t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6, t0.reminder_max_sends AS reminder_max_sends_7, t0.mail_template_id AS mail_template_id_8 FROM user_actions t0 INNER JOIN user_user_actions ON t0.id = user_user_actions.user_actions_id WHERE user_user_actions.user_id = ?

[
  b"\x01žDËéŽp§ "á,,ù÷í"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.sorting AS sorting_4,
  t0.reminder_delay_days AS reminder_delay_days_5,
  t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6,
  t0.reminder_max_sends AS reminder_max_sends_7,
  t0.mail_template_id AS mail_template_id_8
FROM
  user_actions t0
  INNER JOIN user_user_actions ON t0.id = user_user_actions.user_actions_id
WHERE
  user_user_actions.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.sorting AS sorting_4, t0.reminder_delay_days AS reminder_delay_days_5, t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6, t0.reminder_max_sends AS reminder_max_sends_7, t0.mail_template_id AS mail_template_id_8 FROM user_actions t0 INNER JOIN user_user_actions ON t0.id = user_user_actions.user_actions_id WHERE user_user_actions.user_id = 0x019E44CBE98D70A7A022E12C2CF9F7ED;

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.sorting AS sorting_4, t0.reminder_delay_days AS reminder_delay_days_5, t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6, t0.reminder_max_sends AS reminder_max_sends_7, t0.mail_template_id AS mail_template_id_8 FROM user_actions t0 WHERE t0.name = ? LIMIT 1

[
  "CHOOSE_PACKAGE"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.sorting AS sorting_4,
  t0.reminder_delay_days AS reminder_delay_days_5,
  t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6,
  t0.reminder_max_sends AS reminder_max_sends_7,
  t0.mail_template_id AS mail_template_id_8
FROM
  user_actions t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.sorting AS sorting_4, t0.reminder_delay_days AS reminder_delay_days_5, t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6, t0.reminder_max_sends AS reminder_max_sends_7, t0.mail_template_id AS mail_template_id_8 FROM user_actions t0 WHERE t0.name = 'CHOOSE_PACKAGE' LIMIT 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.sorting AS sorting_4, t0.reminder_delay_days AS reminder_delay_days_5, t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6, t0.reminder_max_sends AS reminder_max_sends_7, t0.mail_template_id AS mail_template_id_8 FROM user_actions t0 WHERE t0.name = ? LIMIT 1

[
  "CREATE_FIRST_COURSE"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.sorting AS sorting_4,
  t0.reminder_delay_days AS reminder_delay_days_5,
  t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6,
  t0.reminder_max_sends AS reminder_max_sends_7,
  t0.mail_template_id AS mail_template_id_8
FROM
  user_actions t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.sorting AS sorting_4, t0.reminder_delay_days AS reminder_delay_days_5, t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6, t0.reminder_max_sends AS reminder_max_sends_7, t0.mail_template_id AS mail_template_id_8 FROM user_actions t0 WHERE t0.name = 'CREATE_FIRST_COURSE' LIMIT 1;