https://api.dahnapp.com/cronjobs/notifications/scheduled_notifications

Query Metrics

3 Database Queries
2 Different statements
5.14 ms Query time
0 Invalid entities
  • Queries
  • Database Connections
  • Entity Managers
  • Second Level Cache
  • Entities Mapping

Group similar statements

# Time Info
1 1.07 ms
SELECT t0.id AS id_1, t0.language_name AS language_name_2, t0.language_shortname AS language_shortname_3 FROM language t0 WHERE t0.language_shortname = ? LIMIT 1
Parameters:
0 of 0
[ "ro" ]
2 2.87 ms
SELECT t0.id AS id_1, t0.language_name AS language_name_2, t0.language_shortname AS language_shortname_3 FROM language t0 WHERE t0.language_shortname = ? LIMIT 1
Parameters:
0 of 0
[ "en" ]
3 1.20 ms
SELECT s0_.id AS id_0, s0_.notification_title AS notification_title_1, s0_.notification_title_en AS notification_title_en_2, s0_.notification_body AS notification_body_3, s0_.notification_body_en AS notification_body_en_4, s0_.notification_preview AS notification_preview_5, s0_.notification_preview_en AS notification_preview_en_6, s0_.forward_to AS forward_to_7, s0_.scheduled_at AS scheduled_at_8, s0_.runned_at AS runned_at_9, s0_.created_at AS created_at_10, s0_.removed_at AS removed_at_11, s0_.pro_users AS pro_users_12 FROM scheduled_notifications s0_ WHERE s0_.removed_at IS NULL AND s0_.runned_at IS NULL AND s0_.scheduled_at <= ? AND s0_.pro_users = 0 ORDER BY s0_.scheduled_at ASC LIMIT 1
Parameters:
0 of 0
[ "2025-04-27 03:30:02" ]