Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception 1
• Logs 2
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.start_time AS start_time_2, t0.end_time AS end_time_3, t0.action_target AS action_target_4, t0.action_type AS action_type_5, t0.platform AS platform_6, t0.ip AS ip_7, t0.duration AS duration_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.is_deleted AS is_deleted_11, t0.student_id AS student_id_12, t0.video_id AS video_id_13 FROM learn_track t0 WHERE t0.student_id = ? AND t0.video_id = ? AND t0.action_type = ? AND t0.is_deleted = ? ORDER BY t0.id DESC LIMIT 1

[
  40
  31
  "随机验证"
  0
]

SELECT
  t0.id AS id_1,
  t0.start_time AS start_time_2,
  t0.end_time AS end_time_3,
  t0.action_target AS action_target_4,
  t0.action_type AS action_type_5,
  t0.platform AS platform_6,
  t0.ip AS ip_7,
  t0.duration AS duration_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.is_deleted AS is_deleted_11,
  t0.student_id AS student_id_12,
  t0.video_id AS video_id_13
FROM
  learn_track t0
WHERE
  t0.student_id = ?
  AND t0.video_id = ?
  AND t0.action_type = ?
  AND t0.is_deleted = ?
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.start_time AS start_time_2, t0.end_time AS end_time_3, t0.action_target AS action_target_4, t0.action_type AS action_type_5, t0.platform AS platform_6, t0.ip AS ip_7, t0.duration AS duration_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.is_deleted AS is_deleted_11, t0.student_id AS student_id_12, t0.video_id AS video_id_13 FROM learn_track t0 WHERE t0.student_id = 40 AND t0.video_id = 31 AND t0.action_type = '随机验证' AND t0.is_deleted = 0 ORDER BY t0.id DESC LIMIT 1;

SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.file_id AS file_id_4, t0.teacher AS teacher_5, t0.duration AS duration_6, t0.credit_hours AS credit_hours_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.is_deleted AS is_deleted_10, t0.chapter_id AS chapter_id_11 FROM video t0 WHERE t0.id = ?

[
  "31"
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.url AS url_3,
  t0.file_id AS file_id_4,
  t0.teacher AS teacher_5,
  t0.duration AS duration_6,
  t0.credit_hours AS credit_hours_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.is_deleted AS is_deleted_10,
  t0.chapter_id AS chapter_id_11
FROM
  video t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.file_id AS file_id_4, t0.teacher AS teacher_5, t0.duration AS duration_6, t0.credit_hours AS credit_hours_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.is_deleted AS is_deleted_10, t0.chapter_id AS chapter_id_11 FROM video t0 WHERE t0.id = '31';

SELECT COUNT(*) FROM verification_log t0 WHERE t0.video_id = ? AND t0.student_id = ? AND t0.is_verified = ? AND t0.verification_type = ?

[
  31
  40
  1
  "人脸比对"
]

SELECT
  COUNT(*)
FROM
  verification_log t0
WHERE
  t0.video_id = ?
  AND t0.student_id = ?
  AND t0.is_verified = ?
  AND t0.verification_type = ?

SELECT COUNT(*) FROM verification_log t0 WHERE t0.video_id = 31 AND t0.student_id = 40 AND t0.is_verified = 1 AND t0.verification_type = '人脸比对';

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.id_card AS id_card_6, t0.cover AS cover_7, t0.idno AS idno_8, t0.is_resigned AS is_resigned_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.is_deleted AS is_deleted_12, t0.merchant_id AS merchant_id_13 FROM student t0 WHERE t0.id = ?

[
  "40"
]

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.id_card AS id_card_6,
  t0.cover AS cover_7,
  t0.idno AS idno_8,
  t0.is_resigned AS is_resigned_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.is_deleted AS is_deleted_12,
  t0.merchant_id AS merchant_id_13
FROM
  student t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.id_card AS id_card_6, t0.cover AS cover_7, t0.idno AS idno_8, t0.is_resigned AS is_resigned_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.is_deleted AS is_deleted_12, t0.merchant_id AS merchant_id_13 FROM student t0 WHERE t0.id = '40';