Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• Doctrine
• Debug
• EasyAdmin
• Configuration

Query Metrics

SELECT o.id id, o.short_name short_name, o.name name, count(`p`.`id`) pool_cnt, logo FROM operator o INNER JOIN pool p ON o.id = p.operator_id AND p.is_deleted IS NULL WHERE o.is_deleted IS NULL GROUP BY o.id, o.name HAVING pool_cnt > 0 ORDER BY pool_cnt DESC, o.name ASC

[]

SELECT
  o.id id,
  o.short_name short_name,
  o.name name,
  count(`p`.`id`) pool_cnt,
  logo
FROM
  operator o
  INNER JOIN pool p ON o.id = p.operator_id
  AND p.is_deleted IS NULL
WHERE
  o.is_deleted IS NULL
GROUP BY
  o.id,
  o.name
HAVING
  pool_cnt > 0
ORDER BY
  pool_cnt DESC,
  o.name ASC

SELECT o.id id, o.short_name short_name, o.name name, count(`p`.`id`) pool_cnt, logo FROM operator o INNER JOIN pool p ON o.id = p.operator_id AND p.is_deleted IS NULL WHERE o.is_deleted IS NULL GROUP BY o.id, o.name HAVING pool_cnt > 0 ORDER BY pool_cnt DESC, o.name ASC;

SELECT o.short_name AS name, COUNT(pt.id) AS cnt FROM operator o INNER JOIN pool p ON o.id = p.operator_id INNER JOIN station st ON p.id = st.pool_id INNER JOIN point pt ON st.id = pt.station_id AND pt.is_deleted IS NULL WHERE o.is_deleted IS NULL GROUP BY o.id ORDER BY cnt DESC LIMIT 5

[]

SELECT
  o.short_name AS name,
  COUNT(pt.id) AS cnt
FROM
  operator o
  INNER JOIN pool p ON o.id = p.operator_id
  INNER JOIN station st ON p.id = st.pool_id
  INNER JOIN point pt ON st.id = pt.station_id
  AND pt.is_deleted IS NULL
WHERE
  o.is_deleted IS NULL
GROUP BY
  o.id
ORDER BY
  cnt DESC
LIMIT
  5

SELECT o.short_name AS name, COUNT(pt.id) AS cnt FROM operator o INNER JOIN pool p ON o.id = p.operator_id INNER JOIN station st ON p.id = st.pool_id INNER JOIN point pt ON st.id = pt.station_id AND pt.is_deleted IS NULL WHERE o.is_deleted IS NULL GROUP BY o.id ORDER BY cnt DESC LIMIT 5;

SELECT COUNT(*) FROM status WHERE (status = 0) AND (updated_at >= ?) AND (updated_at <= ?)

[
  "2026-07-09 00:00:00"
  "2026-07-09 16:49:34"
]

SELECT
  COUNT(*)
FROM
  status
WHERE
  (status = 0)
  AND (updated_at >= ?)
  AND (updated_at <= ?)

SELECT COUNT(*) FROM status WHERE (status = 0) AND (updated_at >= '2026-07-09 00:00:00') AND (updated_at <= '2026-07-09 16:49:34');

SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.pool_id AS pool_id_2, c0_.txt AS txt_3 FROM change_log c0_ ORDER BY c0_.date DESC, c0_.id DESC LIMIT 40

[]

SELECT
  c0_.id AS id_0,
  c0_.date AS date_1,
  c0_.pool_id AS pool_id_2,
  c0_.txt AS txt_3
FROM
  change_log c0_
ORDER BY
  c0_.date DESC,
  c0_.id DESC
LIMIT
  40

SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.pool_id AS pool_id_2, c0_.txt AS txt_3 FROM change_log c0_ ORDER BY c0_.date DESC, c0_.id DESC LIMIT 40;

SELECT o.short_name AS name, COUNT(p.id) AS cnt FROM operator o INNER JOIN pool p ON o.id = p.operator_id AND p.is_deleted IS NULL WHERE o.is_deleted IS NULL GROUP BY o.id ORDER BY cnt DESC LIMIT 5

[]

SELECT
  o.short_name AS name,
  COUNT(p.id) AS cnt
FROM
  operator o
  INNER JOIN pool p ON o.id = p.operator_id
  AND p.is_deleted IS NULL
WHERE
  o.is_deleted IS NULL
GROUP BY
  o.id
ORDER BY
  cnt DESC
LIMIT
  5

SELECT o.short_name AS name, COUNT(p.id) AS cnt FROM operator o INNER JOIN pool p ON o.id = p.operator_id AND p.is_deleted IS NULL WHERE o.is_deleted IS NULL GROUP BY o.id ORDER BY cnt DESC LIMIT 5;

SELECT (date DIV 100) AS month, ROUND(SUM(value) / COUNT(*), 1) AS avg_daily FROM stats_global_charging_sessions WHERE (date >= ?) AND (date <= ?) AND (type = ?) GROUP BY month ORDER BY month ASC

[
  20241201
  20260731
  "day"
]

SELECT
  (date DIV 100) AS month,
  ROUND(
    SUM(value) / COUNT(*),
    1
  ) AS avg_daily
FROM
  stats_global_charging_sessions
WHERE
  (date >= ?)
  AND (date <= ?)
  AND (type = ?)
GROUP BY
  month
ORDER BY
  month ASC

SELECT (date DIV 100) AS month, ROUND(SUM(value) / COUNT(*), 1) AS avg_daily FROM stats_global_charging_sessions WHERE (date >= 20241201) AND (date <= 20260731) AND (type = 'day') GROUP BY month ORDER BY month ASC;

SELECT available, busy, unavailable, unknown, busy_ac, busy_dc FROM stats_global_status ORDER BY updated_at DESC LIMIT 1

[]

SELECT
  available,
  busy,
  unavailable,
  unknown,
  busy_ac,
  busy_dc
FROM
  stats_global_status
ORDER BY
  updated_at DESC
LIMIT
  1

SELECT available, busy, unavailable, unknown, busy_ac, busy_dc FROM stats_global_status ORDER BY updated_at DESC LIMIT 1;

SELECT month, new_points_any_status, new_points_status_0
             FROM stats_global_new_points
             ORDER BY month ASC

[]

SELECT
  month,
  new_points_any_status,
  new_points_status_0
FROM
  stats_global_new_points
ORDER BY
  month ASC

SELECT month, new_points_any_status, new_points_status_0
             FROM stats_global_new_points
             ORDER BY month ASC;

SELECT t0.month AS month_1, t0.ccs AS ccs_2, t0.chademo AS chademo_3, t0.type2_cable AS type2_cable_4, t0.type2_socket AS type2_socket_5, t0.other AS other_6, t0.dc_charging AS dc_charging_7, t0.ac_charging AS ac_charging_8 FROM stats_global_connectors t0 WHERE t0.month = ?

[
  202607
]

SELECT
  t0.month AS month_1,
  t0.ccs AS ccs_2,
  t0.chademo AS chademo_3,
  t0.type2_cable AS type2_cable_4,
  t0.type2_socket AS type2_socket_5,
  t0.other AS other_6,
  t0.dc_charging AS dc_charging_7,
  t0.ac_charging AS ac_charging_8
FROM
  stats_global_connectors t0
WHERE
  t0.month = ?

SELECT t0.month AS month_1, t0.ccs AS ccs_2, t0.chademo AS chademo_3, t0.type2_cable AS type2_cable_4, t0.type2_socket AS type2_socket_5, t0.other AS other_6, t0.dc_charging AS dc_charging_7, t0.ac_charging AS ac_charging_8 FROM stats_global_connectors t0 WHERE t0.month = 202607;