Symfony Profiler

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.playtime AS playtime_2,
  s0_.created AS created_3,
  s0_.plays AS plays_4,
  s0_.rate AS rate_5,
  s0_.deleted AS deleted_6,
  s0_.artist_link AS artist_link_7,
  s0_.thumbnail_image AS thumbnail_image_8,
  s0_.track_list_text AS track_list_text_9,
  SUM(
    IF(
      (
        h1_.created > DATE_SUB(
          NOW(),
          INTERVAL 4 HOUR
        )
      ),
      1,
      0
    )
  ) AS sclr_10,
  SUM(
    IF(
      (
        h1_.created > DATE_SUB(
          NOW(),
          INTERVAL 6 HOUR
        )
      ),
      1,
      0
    )
  ) AS sclr_11,
  SUM(
    IF(
      (
        h1_.created > DATE_SUB(
          NOW(),
          INTERVAL 12 HOUR
        )
      ),
      1,
      0
    )
  ) AS sclr_12,
  SUM(
    IF(
      (
        h1_.created > DATE_SUB(
          NOW(),
          INTERVAL 24 HOUR
        )
      ),
      1,
      0
    )
  ) AS sclr_13,
  SUM(
    IF(
      (
        h1_.created > DATE_SUB(
          NOW(),
          INTERVAL 48 HOUR
        )
      ),
      1,
      0
    )
  ) AS sclr_14
FROM
  song s0_
  LEFT JOIN song_tag s3_ ON s0_.id = s3_.song_id
  LEFT JOIN tag t2_ ON t2_.id = s3_.tag_id
  LEFT JOIN event_tag e4_ ON t2_.id = e4_.tag_id
  LEFT JOIN history h1_ ON (
    h1_.song_id = s0_.id
    AND h1_.event_tag_id = e4_.id
  )
WHERE
  e4_.id = ?
  AND s0_.deleted = 0
GROUP BY
  s0_.id
ORDER BY
  sclr_10 ASC,
  sclr_11 ASC,
  sclr_12 ASC,
  sclr_13 ASC,
  sclr_14 ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.playtime AS playtime_2, s0_.created AS created_3, s0_.plays AS plays_4, s0_.rate AS rate_5, s0_.deleted AS deleted_6, s0_.artist_link AS artist_link_7, s0_.thumbnail_image AS thumbnail_image_8, s0_.track_list_text AS track_list_text_9, SUM(IF((h1_.created>DATE_SUB(NOW(), INTERVAL 4 HOUR)), 1, 0)) AS sclr_10, SUM(IF((h1_.created>DATE_SUB(NOW(), INTERVAL 6 HOUR)), 1, 0)) AS sclr_11, SUM(IF((h1_.created>DATE_SUB(NOW(), INTERVAL 12 HOUR)), 1, 0)) AS sclr_12, SUM(IF((h1_.created>DATE_SUB(NOW(), INTERVAL 24 HOUR)), 1, 0)) AS sclr_13, SUM(IF((h1_.created>DATE_SUB(NOW(), INTERVAL 48 HOUR)), 1, 0)) AS sclr_14 FROM song s0_ LEFT JOIN song_tag s3_ ON s0_.id = s3_.song_id LEFT JOIN tag t2_ ON t2_.id = s3_.tag_id LEFT JOIN event_tag e4_ ON t2_.id = e4_.tag_id LEFT JOIN history h1_ ON (h1_.song_id = s0_.id AND h1_.event_tag_id = e4_.id) WHERE e4_.id = 4 AND s0_.deleted = 0 GROUP BY s0_.id ORDER BY sclr_10 ASC, sclr_11 ASC, sclr_12 ASC, sclr_13 ASC, sclr_14 ASC;

SELECT
  h0_.id AS id_0,
  h0_.created AS created_1,
  h0_.test_id AS test_id_2,
  h0_.event_tag_id AS event_tag_id_3,
  h0_.song_id AS song_id_4
FROM
  history h0_
  LEFT JOIN event_tag e1_ ON h0_.event_tag_id = e1_.id
  LEFT JOIN event e2_ ON e1_.event_id = e2_.id
  LEFT JOIN station s3_ ON e2_.station_id = s3_.id
WHERE
  s3_.id = ?
ORDER BY
  h0_.id DESC
LIMIT
  1

SELECT h0_.id AS id_0, h0_.created AS created_1, h0_.test_id AS test_id_2, h0_.event_tag_id AS event_tag_id_3, h0_.song_id AS song_id_4 FROM history h0_ LEFT JOIN event_tag e1_ ON h0_.event_tag_id = e1_.id LEFT JOIN event e2_ ON e1_.event_id = e2_.id LEFT JOIN station s3_ ON e2_.station_id = s3_.id WHERE s3_.id = 4 ORDER BY h0_.id DESC LIMIT 1;

"COMMIT"

"COMMIT";

INSERT INTO history (
  created, test_id, event_tag_id, song_id
)
VALUES
  (?, ?, ?, ?)

INSERT INTO history (created, test_id, event_tag_id, song_id) VALUES ('2026-03-24 01:58:32', 0, 4, 7);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.color AS color_3,
  t0.deleted AS deleted_4,
  t0.type AS type_5,
  t0.parent_id AS parent_id_6
FROM
  tag t0
  INNER JOIN song_tag ON t0.id = song_tag.tag_id
WHERE
  song_tag.song_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.deleted AS deleted_4, t0.type AS type_5, t0.parent_id AS parent_id_6 FROM tag t0 INNER JOIN song_tag ON t0.id = song_tag.tag_id WHERE song_tag.song_id = 7;

SELECT
  t0.id AS id_1,
  t0.ord AS ord_2,
  t0.remote_id AS remote_id_3,
  t0.remote_name AS remote_name_4,
  t0.event_id AS event_id_5,
  t0.tag_id AS tag_id_6
FROM
  event_tag t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.ord AS ord_2, t0.remote_id AS remote_id_3, t0.remote_name AS remote_name_4, t0.event_id AS event_id_5, t0.tag_id AS tag_id_6 FROM event_tag t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.media_id AS media_id_2,
  t0.song_id AS song_id_3,
  t0.station_id AS station_id_4
FROM
  song_station t0
WHERE
  t0.song_id = ?
  AND t0.station_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.media_id AS media_id_2, t0.song_id AS song_id_3, t0.station_id AS station_id_4 FROM song_station t0 WHERE t0.song_id = 7 AND t0.station_id = 4 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.host AS host_3,
  t0.apikey AS apikey_4,
  t0.description AS description_5,
  t0.rsync_target AS rsync_target_6,
  t0.rsync_host AS rsync_host_7,
  t0.rsync_port AS rsync_port_8,
  t0.control_user AS control_user_9,
  t0.control_pass AS control_pass_10,
  t0.timezone_diff AS timezone_diff_11,
  t0.listen_prefix AS listen_prefix_12,
  t0.listen_ip AS listen_ip_13
FROM
  server t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.host AS host_3, t0.apikey AS apikey_4, t0.description AS description_5, t0.rsync_target AS rsync_target_6, t0.rsync_host AS rsync_host_7, t0.rsync_port AS rsync_port_8, t0.control_user AS control_user_9, t0.control_pass AS control_pass_10, t0.timezone_diff AS timezone_diff_11, t0.listen_prefix AS listen_prefix_12, t0.listen_ip AS listen_ip_13 FROM server t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.shortcode AS shortcode_3,
  t0.description AS description_4,
  t0.listen_url AS listen_url_5,
  t0.remote_id AS remote_id_6,
  t0.default_playlist_remote_id AS default_playlist_remote_id_7,
  t0.channel_logo AS channel_logo_8,
  t0.channel_video AS channel_video_9,
  t0.color AS color_10,
  t0.server_id AS server_id_11
FROM
  station t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.shortcode AS shortcode_3, t0.description AS description_4, t0.listen_url AS listen_url_5, t0.remote_id AS remote_id_6, t0.default_playlist_remote_id AS default_playlist_remote_id_7, t0.channel_logo AS channel_logo_8, t0.channel_video AS channel_video_9, t0.color AS color_10, t0.server_id AS server_id_11 FROM station t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.playtime AS playtime_3,
  t0.created AS created_4,
  t0.plays AS plays_5,
  t0.rate AS rate_6,
  t0.deleted AS deleted_7,
  t0.artist_link AS artist_link_8,
  t0.thumbnail_image AS thumbnail_image_9,
  t0.track_list_text AS track_list_text_10
FROM
  song t0
  INNER JOIN song_tag ON t0.id = song_tag.song_id
WHERE
  song_tag.tag_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.playtime AS playtime_3, t0.created AS created_4, t0.plays AS plays_5, t0.rate AS rate_6, t0.deleted AS deleted_7, t0.artist_link AS artist_link_8, t0.thumbnail_image AS thumbnail_image_9, t0.track_list_text AS track_list_text_10 FROM song t0 INNER JOIN song_tag ON t0.id = song_tag.song_id WHERE song_tag.tag_id = 3;

SELECT
  t0.id AS id_1,
  t0.frequency AS frequency_2,
  t0.time AS time_3,
  t0.name AS name_4,
  t0.type AS type_5,
  t0.enabled AS enabled_6,
  t0.station_id AS station_id_7
FROM
  event t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.frequency AS frequency_2, t0.time AS time_3, t0.name AS name_4, t0.type AS type_5, t0.enabled AS enabled_6, t0.station_id AS station_id_7 FROM event t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.shortcode AS shortcode_3,
  t0.description AS description_4,
  t0.listen_url AS listen_url_5,
  t0.remote_id AS remote_id_6,
  t0.default_playlist_remote_id AS default_playlist_remote_id_7,
  t0.channel_logo AS channel_logo_8,
  t0.channel_video AS channel_video_9,
  t0.color AS color_10,
  t0.server_id AS server_id_11
FROM
  station t0
WHERE
  t0.remote_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.shortcode AS shortcode_3, t0.description AS description_4, t0.listen_url AS listen_url_5, t0.remote_id AS remote_id_6, t0.default_playlist_remote_id AS default_playlist_remote_id_7, t0.channel_logo AS channel_logo_8, t0.channel_video AS channel_video_9, t0.color AS color_10, t0.server_id AS server_id_11 FROM station t0 WHERE t0.remote_id = '5' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

SELECT
  t0.id AS id_1,
  t0.frequency AS frequency_2,
  t0.time AS time_3,
  t0.name AS name_4,
  t0.type AS type_5,
  t0.enabled AS enabled_6,
  t0.station_id AS station_id_7
FROM
  event t0
WHERE
  t0.station_id = ?

SELECT t0.id AS id_1, t0.frequency AS frequency_2, t0.time AS time_3, t0.name AS name_4, t0.type AS type_5, t0.enabled AS enabled_6, t0.station_id AS station_id_7 FROM event t0 WHERE t0.station_id = 4;

SELECT
  t0.id AS id_1,
  t0.ord AS ord_2,
  t0.remote_id AS remote_id_3,
  t0.remote_name AS remote_name_4,
  t0.event_id AS event_id_5,
  t0.tag_id AS tag_id_6
FROM
  event_tag t0
WHERE
  t0.event_id = ?
ORDER BY
  t0.ord ASC

SELECT t0.id AS id_1, t0.ord AS ord_2, t0.remote_id AS remote_id_3, t0.remote_name AS remote_name_4, t0.event_id AS event_id_5, t0.tag_id AS tag_id_6 FROM event_tag t0 WHERE t0.event_id = 4 ORDER BY t0.ord ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.color AS color_3,
  t0.deleted AS deleted_4,
  t0.type AS type_5,
  t0.parent_id AS parent_id_6
FROM
  tag t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.deleted AS deleted_4, t0.type AS type_5, t0.parent_id AS parent_id_6 FROM tag t0 WHERE t0.id = 3;