Symfony Profiler

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

Query Metrics

SELECT column_name FROM information_schema.columns WHERE table_schema = DATABASE() AND table_name = ? ORDER BY ordinal_position

[
  "pointage"
]

SELECT
  column_name
FROM
  information_schema.columns
WHERE
  table_schema = DATABASE()
  AND table_name = ?
ORDER BY
  ordinal_position

SELECT column_name FROM information_schema.columns WHERE table_schema = DATABASE() AND table_name = 'pointage' ORDER BY ordinal_position;

SELECT id, monday_item_id AS monday_item_id, monday_item_name AS monday_item_name, monday_user_id AS employee_key, monday_user_id AS employee_name, work_date, workflow AS workflow, travel_hours AS travel_hours, deplacement_code AS deplacement_code, task_planning_item_id AS task_planning_item_id, affaire_item_id AS affaire_item_id, activite_item_id AS activite_item_id, last_snapshot AS last_snapshot
             FROM pointage
             WHERE work_date IS NOT NULL
             ORDER BY employee_key, work_date, id

[]

SELECT
  id,
  monday_item_id AS monday_item_id,
  monday_item_name AS monday_item_name,
  monday_user_id AS employee_key,
  monday_user_id AS employee_name,
  work_date,
  workflow AS workflow,
  travel_hours AS travel_hours,
  deplacement_code AS deplacement_code,
  task_planning_item_id AS task_planning_item_id,
  affaire_item_id AS affaire_item_id,
  activite_item_id AS activite_item_id,
  last_snapshot AS last_snapshot
FROM
  pointage
WHERE
  work_date IS NOT NULL
ORDER BY
  employee_key,
  work_date,
  id

SELECT id, monday_item_id AS monday_item_id, monday_item_name AS monday_item_name, monday_user_id AS employee_key, monday_user_id AS employee_name, work_date, workflow AS workflow, travel_hours AS travel_hours, deplacement_code AS deplacement_code, task_planning_item_id AS task_planning_item_id, affaire_item_id AS affaire_item_id, activite_item_id AS activite_item_id, last_snapshot AS last_snapshot
             FROM pointage
             WHERE work_date IS NOT NULL
             ORDER BY employee_key, work_date, id;