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

Query Metrics

3 Database Queries
2 Different statements
5.20 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.81 ms
(73.22%)
2
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:
[
  "ro"
]
1.39 ms
(26.78%)
1
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:
[
  "2024-09-28 17:20:01"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Language No errors.
App\Entity\RewardNotification No errors.
App\Entity\ScheduledNotifications No errors.