Symfony Profiler

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

Query Metrics

SELECT 
                DATE(created_at) AS account_date,
                COUNT(id) AS tx_count,
                IFNULL(SUM(amount), 0) AS revenue
            FROM transaction
            WHERE created_at >= ? AND created_at <= ? AND is_cancelled = 0
            GROUP BY DATE(created_at)
            ORDER BY account_date ASC

[
  "2026-09-17 00:00:00"
  "2026-09-23 23:59:59"
]

SELECT
  DATE(created_at) AS account_date,
  COUNT(id) AS tx_count,
  IFNULL(
    SUM(amount),
    0
  ) AS revenue
FROM
  transaction
WHERE
  created_at >= ?
  AND created_at <= ?
  AND is_cancelled = 0
GROUP BY
  DATE(created_at)
ORDER BY
  account_date ASC

SELECT 
                DATE(created_at) AS account_date,
                COUNT(id) AS tx_count,
                IFNULL(SUM(amount), 0) AS revenue
            FROM transaction
            WHERE created_at >= '2026-09-17 00:00:00' AND created_at <= '2026-09-23 23:59:59' AND is_cancelled = 0
            GROUP BY DATE(created_at)
            ORDER BY account_date ASC
        ;

SELECT COUNT(*) FROM transaction WHERE created_at >= ? AND is_cancelled = 0

[
  "2026-09-23 00:00:00"
]

SELECT
  COUNT(*)
FROM
  transaction
WHERE
  created_at >= ?
  AND is_cancelled = 0

SELECT COUNT(*) FROM transaction WHERE created_at >= '2026-09-23 00:00:00' AND is_cancelled = 0;

SELECT 
                COUNT(t.id) AS transactions, 
                IFNULL(SUM(t.amount), 0) AS amount
            FROM transaction t
            WHERE t.created_at >= ? AND t.created_at <= ? AND t.is_cancelled = 0

[
  "2026-09-23 00:00:00"
  "2026-09-23 23:59:59"
]

SELECT
  COUNT(t.id) AS transactions,
  IFNULL(
    SUM(t.amount),
    0
  ) AS amount
FROM
  transaction t
WHERE
  t.created_at >= ?
  AND t.created_at <= ?
  AND t.is_cancelled = 0

SELECT 
                COUNT(t.id) AS transactions, 
                IFNULL(SUM(t.amount), 0) AS amount
            FROM transaction t
            WHERE t.created_at >= '2026-09-23 00:00:00' AND t.created_at <= '2026-09-23 23:59:59' AND t.is_cancelled = 0
        ;

SELECT IFNULL(SUM(se.amount), 0) AS expenses
            FROM station_expense se
            WHERE se.created_at >= ? AND se.created_at <= ? AND se.is_cancelled = 0

[
  "2026-09-23 00:00:00"
  "2026-09-23 23:59:59"
]

SELECT
  IFNULL(
    SUM(se.amount),
    0
  ) AS expenses
FROM
  station_expense se
WHERE
  se.created_at >= ?
  AND se.created_at <= ?
  AND se.is_cancelled = 0

SELECT IFNULL(SUM(se.amount), 0) AS expenses
            FROM station_expense se
            WHERE se.created_at >= '2026-09-23 00:00:00' AND se.created_at <= '2026-09-23 23:59:59' AND se.is_cancelled = 0
        ;

SELECT 
                t.id, 
                t.amount, 
                t.payment_method, 
                t.created_at,
                t.is_paid,
                w.id AS waybill_id,
                w.sender_name,
                w.sender_phone_number,
                w.receiver_name,
                w.receiver_phone_number,
                w.percel_count,
                w.is_collected,
                sf.station_name AS from_station, 
                st.station_name AS to_station
            FROM transaction t
            LEFT JOIN way_bill w ON t.way_bill_id = w.id
            LEFT JOIN station sf ON w.from_station_id = sf.id
            LEFT JOIN station st ON w.to_station_id = st.id
            WHERE t.is_cancelled = 0
            ORDER BY t.id DESC
            LIMIT 15

[]

SELECT
  t.id,
  t.amount,
  t.payment_method,
  t.created_at,
  t.is_paid,
  w.id AS waybill_id,
  w.sender_name,
  w.sender_phone_number,
  w.receiver_name,
  w.receiver_phone_number,
  w.percel_count,
  w.is_collected,
  sf.station_name AS from_station,
  st.station_name AS to_station
FROM
  transaction t
  LEFT JOIN way_bill w ON t.way_bill_id = w.id
  LEFT JOIN station sf ON w.from_station_id = sf.id
  LEFT JOIN station st ON w.to_station_id = st.id
WHERE
  t.is_cancelled = 0
ORDER BY
  t.id DESC
LIMIT
  15

SELECT 
                t.id, 
                t.amount, 
                t.payment_method, 
                t.created_at,
                t.is_paid,
                w.id AS waybill_id,
                w.sender_name,
                w.sender_phone_number,
                w.receiver_name,
                w.receiver_phone_number,
                w.percel_count,
                w.is_collected,
                sf.station_name AS from_station, 
                st.station_name AS to_station
            FROM transaction t
            LEFT JOIN way_bill w ON t.way_bill_id = w.id
            LEFT JOIN station sf ON w.from_station_id = sf.id
            LEFT JOIN station st ON w.to_station_id = st.id
            WHERE t.is_cancelled = 0
            ORDER BY t.id DESC
            LIMIT 15;

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.password AS password_2, u0_.email AS email_3, u0_.roles AS roles_4, u0_.is_active AS is_active_5, u0_.person_id AS person_id_6 FROM user u0_ WHERE u0_.username = ? OR u0_.email = ?

[
  "0712907075"
  "0712907075"
]

SELECT
  u0_.id AS id_0,
  u0_.username AS username_1,
  u0_.password AS password_2,
  u0_.email AS email_3,
  u0_.roles AS roles_4,
  u0_.is_active AS is_active_5,
  u0_.person_id AS person_id_6
FROM
  user u0_
WHERE
  u0_.username = ?
  OR u0_.email = ?

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.password AS password_2, u0_.email AS email_3, u0_.roles AS roles_4, u0_.is_active AS is_active_5, u0_.person_id AS person_id_6 FROM user u0_ WHERE u0_.username = '0712907075' OR u0_.email = '0712907075';

SELECT 
                s.id, 
                s.station_name, 
                COUNT(t.id) AS tx_count, 
                IFNULL(SUM(t.amount), 0) AS revenue
            FROM station s
            JOIN way_bill w ON w.from_station_id = s.id
            JOIN transaction t ON t.way_bill_id = w.id
            WHERE t.created_at >= ? AND t.created_at <= ? AND t.is_cancelled = 0
            GROUP BY s.id, s.station_name
            ORDER BY revenue DESC
            LIMIT 8

[
  "2026-09-23 00:00:00"
  "2026-09-23 23:59:59"
]

SELECT
  s.id,
  s.station_name,
  COUNT(t.id) AS tx_count,
  IFNULL(
    SUM(t.amount),
    0
  ) AS revenue
FROM
  station s
  JOIN way_bill w ON w.from_station_id = s.id
  JOIN transaction t ON t.way_bill_id = w.id
WHERE
  t.created_at >= ?
  AND t.created_at <= ?
  AND t.is_cancelled = 0
GROUP BY
  s.id,
  s.station_name
ORDER BY
  revenue DESC
LIMIT
  8

SELECT 
                s.id, 
                s.station_name, 
                COUNT(t.id) AS tx_count, 
                IFNULL(SUM(t.amount), 0) AS revenue
            FROM station s
            JOIN way_bill w ON w.from_station_id = s.id
            JOIN transaction t ON t.way_bill_id = w.id
            WHERE t.created_at >= '2026-09-23 00:00:00' AND t.created_at <= '2026-09-23 23:59:59' AND t.is_cancelled = 0
            GROUP BY s.id, s.station_name
            ORDER BY revenue DESC
            LIMIT 8;

SELECT MAX(id) FROM way_bill

[]

SELECT
  MAX(id)
FROM
  way_bill

SELECT MAX(id) FROM way_bill;

SELECT COUNT(*) FROM vehicle

[]

SELECT
  COUNT(*)
FROM
  vehicle

SELECT COUNT(*) FROM vehicle;

SELECT COUNT(*) FROM user WHERE is_active = 1

[]

SELECT
  COUNT(*)
FROM
  user
WHERE
  is_active = 1

SELECT COUNT(*) FROM user WHERE is_active = 1;

SELECT COUNT(*) FROM station WHERE is_active = 1

[]

SELECT
  COUNT(*)
FROM
  station
WHERE
  is_active = 1

SELECT COUNT(*) FROM station WHERE is_active = 1;