Symfony Profiler

SELECT
  COUNT(*) AS total,
  SUM(status = ?) AS completed,
  SUM(status = ?) AS loading,
  SUM(status = ?) AS checked_in,
  SUM(status = ?) AS scheduled,
  SUM(status = ?) AS no_show
FROM
  appointments
WHERE
  scheduled_date = ?

SELECT
                COUNT(*) AS total,
                SUM(status = 'completed')  AS completed,
                SUM(status = 'loading')    AS loading,
                SUM(status = 'checked_in') AS checked_in,
                SUM(status = 'scheduled')  AS scheduled,
                SUM(status = 'no_show')    AS no_show
             FROM appointments WHERE scheduled_date = '2026-04-02';

SELECT
  COUNT(*)
FROM
  appointments
WHERE
  scheduled_date BETWEEN ?
  AND ?
  AND status != ?

SELECT COUNT(*) FROM appointments
             WHERE scheduled_date BETWEEN '2026-04-01' AND '2026-04-30'
               AND status != 'cancelled';

SELECT
  COUNT(*)
FROM
  appointments
WHERE
  scheduled_date BETWEEN ?
  AND ?
  AND status = ?

SELECT COUNT(*) FROM appointments
             WHERE scheduled_date BETWEEN '2026-04-01' AND '2026-04-30' AND status = 'completed';

SELECT
  COUNT(*)
FROM
  appointments
WHERE
  scheduled_date BETWEEN ?
  AND ?
  AND status = ?
  AND checked_in_at IS NOT NULL
  AND TIME(checked_in_at) <= start_time

SELECT COUNT(*) FROM appointments
             WHERE scheduled_date BETWEEN '2026-04-01' AND '2026-04-30'
               AND status = 'completed'
               AND checked_in_at IS NOT NULL
               AND TIME(checked_in_at) <= start_time;

SELECT
  a0_.id AS id_0,
  a0_.scheduled_date AS scheduled_date_1,
  a0_.start_time AS start_time_2,
  a0_.end_time AS end_time_3,
  a0_.direction AS direction_4,
  a0_.status AS status_5,
  a0_.po_number AS po_number_6,
  a0_.trailer_number AS trailer_number_7,
  a0_.driver_name AS driver_name_8,
  a0_.unit_count AS unit_count_9,
  a0_.unit_type AS unit_type_10,
  a0_.notes AS notes_11,
  a0_.created_at AS created_at_12,
  a0_.checked_in_at AS checked_in_at_13,
  a0_.completed_at AS completed_at_14,
  d1_.id AS id_15,
  d1_.door_number AS door_number_16,
  d1_.label AS label_17,
  d1_.type AS type_18,
  d1_.status AS status_19,
  d1_.has_leveler AS has_leveler_20,
  d1_.temp_controlled AS temp_controlled_21,
  d1_.max_trailer_length_ft AS max_trailer_length_ft_22,
  d1_.notes AS notes_23,
  c2_.id AS id_24,
  c2_.name AS name_25,
  c2_.scac_code AS scac_code_26,
  c2_.contact_name AS contact_name_27,
  c2_.contact_email AS contact_email_28,
  c2_.contact_phone AS contact_phone_29,
  c2_.active AS active_30,
  c2_.notes AS notes_31,
  a0_.dock_door_id AS dock_door_id_32,
  a0_.carrier_id AS carrier_id_33
FROM
  appointments a0_
  INNER JOIN dock_doors d1_ ON a0_.dock_door_id = d1_.id
  INNER JOIN carriers c2_ ON a0_.carrier_id = c2_.id
WHERE
  a0_.scheduled_date = ?
ORDER BY
  a0_.start_time ASC,
  d1_.door_number ASC

SELECT a0_.id AS id_0, a0_.scheduled_date AS scheduled_date_1, a0_.start_time AS start_time_2, a0_.end_time AS end_time_3, a0_.direction AS direction_4, a0_.status AS status_5, a0_.po_number AS po_number_6, a0_.trailer_number AS trailer_number_7, a0_.driver_name AS driver_name_8, a0_.unit_count AS unit_count_9, a0_.unit_type AS unit_type_10, a0_.notes AS notes_11, a0_.created_at AS created_at_12, a0_.checked_in_at AS checked_in_at_13, a0_.completed_at AS completed_at_14, d1_.id AS id_15, d1_.door_number AS door_number_16, d1_.label AS label_17, d1_.type AS type_18, d1_.status AS status_19, d1_.has_leveler AS has_leveler_20, d1_.temp_controlled AS temp_controlled_21, d1_.max_trailer_length_ft AS max_trailer_length_ft_22, d1_.notes AS notes_23, c2_.id AS id_24, c2_.name AS name_25, c2_.scac_code AS scac_code_26, c2_.contact_name AS contact_name_27, c2_.contact_email AS contact_email_28, c2_.contact_phone AS contact_phone_29, c2_.active AS active_30, c2_.notes AS notes_31, a0_.dock_door_id AS dock_door_id_32, a0_.carrier_id AS carrier_id_33 FROM appointments a0_ INNER JOIN dock_doors d1_ ON a0_.dock_door_id = d1_.id INNER JOIN carriers c2_ ON a0_.carrier_id = c2_.id WHERE a0_.scheduled_date = '2026-04-02' ORDER BY a0_.start_time ASC, d1_.door_number ASC;

SELECT
  a0_.id AS id_0,
  a0_.scheduled_date AS scheduled_date_1,
  a0_.start_time AS start_time_2,
  a0_.end_time AS end_time_3,
  a0_.direction AS direction_4,
  a0_.status AS status_5,
  a0_.po_number AS po_number_6,
  a0_.trailer_number AS trailer_number_7,
  a0_.driver_name AS driver_name_8,
  a0_.unit_count AS unit_count_9,
  a0_.unit_type AS unit_type_10,
  a0_.notes AS notes_11,
  a0_.created_at AS created_at_12,
  a0_.checked_in_at AS checked_in_at_13,
  a0_.completed_at AS completed_at_14,
  d1_.id AS id_15,
  d1_.door_number AS door_number_16,
  d1_.label AS label_17,
  d1_.type AS type_18,
  d1_.status AS status_19,
  d1_.has_leveler AS has_leveler_20,
  d1_.temp_controlled AS temp_controlled_21,
  d1_.max_trailer_length_ft AS max_trailer_length_ft_22,
  d1_.notes AS notes_23,
  c2_.id AS id_24,
  c2_.name AS name_25,
  c2_.scac_code AS scac_code_26,
  c2_.contact_name AS contact_name_27,
  c2_.contact_email AS contact_email_28,
  c2_.contact_phone AS contact_phone_29,
  c2_.active AS active_30,
  c2_.notes AS notes_31,
  a0_.dock_door_id AS dock_door_id_32,
  a0_.carrier_id AS carrier_id_33
FROM
  appointments a0_
  INNER JOIN dock_doors d1_ ON a0_.dock_door_id = d1_.id
  INNER JOIN carriers c2_ ON a0_.carrier_id = c2_.id
WHERE
  (
    a0_.scheduled_date BETWEEN ?
    AND ?
  )
  AND a0_.status NOT IN (?, ?, ?)
ORDER BY
  a0_.scheduled_date ASC,
  a0_.start_time ASC
LIMIT
  10

SELECT a0_.id AS id_0, a0_.scheduled_date AS scheduled_date_1, a0_.start_time AS start_time_2, a0_.end_time AS end_time_3, a0_.direction AS direction_4, a0_.status AS status_5, a0_.po_number AS po_number_6, a0_.trailer_number AS trailer_number_7, a0_.driver_name AS driver_name_8, a0_.unit_count AS unit_count_9, a0_.unit_type AS unit_type_10, a0_.notes AS notes_11, a0_.created_at AS created_at_12, a0_.checked_in_at AS checked_in_at_13, a0_.completed_at AS completed_at_14, d1_.id AS id_15, d1_.door_number AS door_number_16, d1_.label AS label_17, d1_.type AS type_18, d1_.status AS status_19, d1_.has_leveler AS has_leveler_20, d1_.temp_controlled AS temp_controlled_21, d1_.max_trailer_length_ft AS max_trailer_length_ft_22, d1_.notes AS notes_23, c2_.id AS id_24, c2_.name AS name_25, c2_.scac_code AS scac_code_26, c2_.contact_name AS contact_name_27, c2_.contact_email AS contact_email_28, c2_.contact_phone AS contact_phone_29, c2_.active AS active_30, c2_.notes AS notes_31, a0_.dock_door_id AS dock_door_id_32, a0_.carrier_id AS carrier_id_33 FROM appointments a0_ INNER JOIN dock_doors d1_ ON a0_.dock_door_id = d1_.id INNER JOIN carriers c2_ ON a0_.carrier_id = c2_.id WHERE (a0_.scheduled_date BETWEEN '2026-04-03' AND '2026-04-09') AND a0_.status NOT IN ('completed', 'cancelled', 'no_show') ORDER BY a0_.scheduled_date ASC, a0_.start_time ASC LIMIT 10;

SELECT
  d.door_number,
  d.label,
  d.type,
  COALESCE(
    SUM(
      TIMESTAMPDIFF(MINUTE, a.start_time, a.end_time)
    ),
    0
  ) AS booked_minutes,
  ? AS total_minutes,
  ROUND(
    COALESCE(
      SUM(
        TIMESTAMPDIFF(MINUTE, a.start_time, a.end_time)
      ),
      0
    ) / ? * 100,
    1
  ) AS utilization_pct
FROM
  dock_doors d
  LEFT JOIN appointments a ON a.dock_door_id = d.id
  AND a.scheduled_date = ?
  AND a.status NOT IN (?, ?)
WHERE
  d.status != ?
GROUP BY
  d.id,
  d.door_number,
  d.label,
  d.type
ORDER BY
  CAST(d.door_number AS UNSIGNED) ASC

SELECT
                d.door_number,
                d.label,
                d.type,
                COALESCE(SUM(TIMESTAMPDIFF(MINUTE, a.start_time, a.end_time)), 0) AS booked_minutes,
                480 AS total_minutes,
                ROUND(
                    COALESCE(SUM(TIMESTAMPDIFF(MINUTE, a.start_time, a.end_time)), 0) / 480 * 100,
                    1
                ) AS utilization_pct
             FROM dock_doors d
             LEFT JOIN appointments a
               ON a.dock_door_id = d.id
               AND a.scheduled_date = '2026-04-02'
               AND a.status NOT IN ('cancelled', 'no_show')
             WHERE d.status != 'closed'
             GROUP BY d.id, d.door_number, d.label, d.type
             ORDER BY CAST(d.door_number AS UNSIGNED) ASC;

SELECT
  HOUR(start_time) AS hour,
  COUNT(*) AS count,
  direction
FROM
  appointments
WHERE
  scheduled_date = ?
  AND status != ?
GROUP BY
  hour,
  direction
ORDER BY
  hour ASC

SELECT HOUR(start_time) AS hour, COUNT(*) AS count, direction
             FROM appointments
             WHERE scheduled_date = '2026-04-02' AND status != 'cancelled'
             GROUP BY hour, direction
             ORDER BY hour ASC;

SELECT
  t0.id AS id_1,
  t0.door_number AS door_number_2,
  t0.label AS label_3,
  t0.type AS type_4,
  t0.status AS status_5,
  t0.has_leveler AS has_leveler_6,
  t0.temp_controlled AS temp_controlled_7,
  t0.max_trailer_length_ft AS max_trailer_length_ft_8,
  t0.notes AS notes_9
FROM
  dock_doors t0

SELECT t0.id AS id_1, t0.door_number AS door_number_2, t0.label AS label_3, t0.type AS type_4, t0.status AS status_5, t0.has_leveler AS has_leveler_6, t0.temp_controlled AS temp_controlled_7, t0.max_trailer_length_ft AS max_trailer_length_ft_8, t0.notes AS notes_9 FROM dock_doors t0;

SELECT
  d0_.id AS id_0,
  d0_.door_number AS door_number_1,
  d0_.label AS label_2,
  d0_.type AS type_3,
  d0_.status AS status_4,
  d0_.has_leveler AS has_leveler_5,
  d0_.temp_controlled AS temp_controlled_6,
  d0_.max_trailer_length_ft AS max_trailer_length_ft_7,
  d0_.notes AS notes_8
FROM
  dock_doors d0_
WHERE
  d0_.status IN (?, ?)
ORDER BY
  d0_.door_number ASC

SELECT d0_.id AS id_0, d0_.door_number AS door_number_1, d0_.label AS label_2, d0_.type AS type_3, d0_.status AS status_4, d0_.has_leveler AS has_leveler_5, d0_.temp_controlled AS temp_controlled_6, d0_.max_trailer_length_ft AS max_trailer_length_ft_7, d0_.notes AS notes_8 FROM dock_doors d0_ WHERE d0_.status IN ('available', 'occupied') ORDER BY d0_.door_number ASC;