GET https://dev.wunschliefertag.de/run/schedule

Query Metrics

45 Database Queries
7 Different statements
141.48 ms Query time
4 Invalid entities

Queries

Group similar statements

# Time Info
1 1.54 ms
SELECT t0.id AS id_1, t0.state AS state_2, t0.step_kind AS step_kind_3, t0.description AS description_4, t0.state_message_ftp AS state_message_ftp_5, t0.state_message_fax AS state_message_fax_6, t0.state_message_mail AS state_message_mail_7, t0.state_message_sms AS state_message_sms_8, t0.state_message_api AS state_message_api_9, t0.changing_sending AS changing_sending_10, t0.state_group AS state_group_11, t0.avis_try AS avis_try_12, t0.show_hist AS show_hist_13, t0.bookable AS bookable_14, t0.export_state_id AS export_state_id_15, t0.sgroup_id AS sgroup_id_16 FROM type_sending_state t0
Parameters:
[]
2 3.92 ms
SELECT t0.id AS id_1, t0.state AS state_2, t0.step_kind AS step_kind_3, t0.description AS description_4, t0.state_message_ftp AS state_message_ftp_5, t0.state_message_fax AS state_message_fax_6, t0.state_message_mail AS state_message_mail_7, t0.state_message_sms AS state_message_sms_8, t0.state_message_api AS state_message_api_9, t0.changing_sending AS changing_sending_10, t0.state_group AS state_group_11, t0.avis_try AS avis_try_12, t0.show_hist AS show_hist_13, t0.bookable AS bookable_14, t0.export_state_id AS export_state_id_15, t0.sgroup_id AS sgroup_id_16 FROM type_sending_state t0
Parameters:
[]
3 1.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.last_run AS last_run_4, t0.last_state AS last_state_5, t0.hash AS hash_6, t0.enabled AS enabled_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 FROM job t0
Parameters:
[]
4 1.38 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_dev AS is_dev_5, t0.all_depot AS all_depot_6, t0.email AS email_7, t0.firstname AS firstname_8, t0.lastname AS lastname_9, t0.title AS title_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.right_level_id AS right_level_id_13, t0.standard_depot_id AS standard_depot_id_14, t0.state_id AS state_id_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  -1
]
5 1.32 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_dev AS is_dev_5, t0.all_depot AS all_depot_6, t0.email AS email_7, t0.firstname AS firstname_8, t0.lastname AS lastname_9, t0.title AS title_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.right_level_id AS right_level_id_13, t0.standard_depot_id AS standard_depot_id_14, t0.state_id AS state_id_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  -1
]
6 1.23 ms
SELECT t0.id AS id_1, t0.hours AS hours_2, t0.minutes AS minutes_3, t0.days_of_week AS days_of_week_4, t0.days_of_month AS days_of_month_5, t0.months AS months_6, t0.no_holidays AS no_holidays_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 FROM cron_time_entry t0 INNER JOIN job_cron_time_entry ON t0.id = job_cron_time_entry.cron_time_entry_id WHERE job_cron_time_entry.job_id = ?
Parameters:
[
  1
]
7 1.47 ms
SELECT t0.id AS id_1, t0.hours AS hours_2, t0.minutes AS minutes_3, t0.days_of_week AS days_of_week_4, t0.days_of_month AS days_of_month_5, t0.months AS months_6, t0.no_holidays AS no_holidays_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 FROM cron_time_entry t0 INNER JOIN job_cron_time_entry ON t0.id = job_cron_time_entry.cron_time_entry_id WHERE job_cron_time_entry.job_id = ?
Parameters:
[
  2
]
8 3.37 ms
SELECT t0.id AS id_1, t0.hours AS hours_2, t0.minutes AS minutes_3, t0.days_of_week AS days_of_week_4, t0.days_of_month AS days_of_month_5, t0.months AS months_6, t0.no_holidays AS no_holidays_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 FROM cron_time_entry t0 INNER JOIN job_cron_time_entry ON t0.id = job_cron_time_entry.cron_time_entry_id WHERE job_cron_time_entry.job_id = ?
Parameters:
[
  3
]
9 1.07 ms
SELECT t0.id AS id_1, t0.hours AS hours_2, t0.minutes AS minutes_3, t0.days_of_week AS days_of_week_4, t0.days_of_month AS days_of_month_5, t0.months AS months_6, t0.no_holidays AS no_holidays_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 FROM cron_time_entry t0 INNER JOIN job_cron_time_entry ON t0.id = job_cron_time_entry.cron_time_entry_id WHERE job_cron_time_entry.job_id = ?
Parameters:
[
  4
]
10 1.08 ms
SELECT t0.id AS id_1, t0.hours AS hours_2, t0.minutes AS minutes_3, t0.days_of_week AS days_of_week_4, t0.days_of_month AS days_of_month_5, t0.months AS months_6, t0.no_holidays AS no_holidays_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 FROM cron_time_entry t0 INNER JOIN job_cron_time_entry ON t0.id = job_cron_time_entry.cron_time_entry_id WHERE job_cron_time_entry.job_id = ?
Parameters:
[
  5
]
11 1.05 ms
SELECT t0.id AS id_1, t0.hours AS hours_2, t0.minutes AS minutes_3, t0.days_of_week AS days_of_week_4, t0.days_of_month AS days_of_month_5, t0.months AS months_6, t0.no_holidays AS no_holidays_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 FROM cron_time_entry t0 INNER JOIN job_cron_time_entry ON t0.id = job_cron_time_entry.cron_time_entry_id WHERE job_cron_time_entry.job_id = ?
Parameters:
[
  6
]
12 1.06 ms
SELECT t0.id AS id_1, t0.hours AS hours_2, t0.minutes AS minutes_3, t0.days_of_week AS days_of_week_4, t0.days_of_month AS days_of_month_5, t0.months AS months_6, t0.no_holidays AS no_holidays_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 FROM cron_time_entry t0 INNER JOIN job_cron_time_entry ON t0.id = job_cron_time_entry.cron_time_entry_id WHERE job_cron_time_entry.job_id = ?
Parameters:
[
  7
]
13 1.02 ms
SELECT t0.id AS id_1, t0.hours AS hours_2, t0.minutes AS minutes_3, t0.days_of_week AS days_of_week_4, t0.days_of_month AS days_of_month_5, t0.months AS months_6, t0.no_holidays AS no_holidays_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 FROM cron_time_entry t0 INNER JOIN job_cron_time_entry ON t0.id = job_cron_time_entry.cron_time_entry_id WHERE job_cron_time_entry.job_id = ?
Parameters:
[
  8
]
14 1.06 ms
SELECT t0.id AS id_1, t0.hours AS hours_2, t0.minutes AS minutes_3, t0.days_of_week AS days_of_week_4, t0.days_of_month AS days_of_month_5, t0.months AS months_6, t0.no_holidays AS no_holidays_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 FROM cron_time_entry t0 INNER JOIN job_cron_time_entry ON t0.id = job_cron_time_entry.cron_time_entry_id WHERE job_cron_time_entry.job_id = ?
Parameters:
[
  10
]
15 1.01 ms
SELECT t0.id AS id_1, t0.hours AS hours_2, t0.minutes AS minutes_3, t0.days_of_week AS days_of_week_4, t0.days_of_month AS days_of_month_5, t0.months AS months_6, t0.no_holidays AS no_holidays_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 FROM cron_time_entry t0 INNER JOIN job_cron_time_entry ON t0.id = job_cron_time_entry.cron_time_entry_id WHERE job_cron_time_entry.job_id = ?
Parameters:
[
  13
]
16 1.10 ms
SELECT t0.id AS id_1, t0.hours AS hours_2, t0.minutes AS minutes_3, t0.days_of_week AS days_of_week_4, t0.days_of_month AS days_of_month_5, t0.months AS months_6, t0.no_holidays AS no_holidays_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 FROM cron_time_entry t0 INNER JOIN job_cron_time_entry ON t0.id = job_cron_time_entry.cron_time_entry_id WHERE job_cron_time_entry.job_id = ?
Parameters:
[
  15
]
17 1.13 ms
SELECT t0.id AS id_1, t0.hours AS hours_2, t0.minutes AS minutes_3, t0.days_of_week AS days_of_week_4, t0.days_of_month AS days_of_month_5, t0.months AS months_6, t0.no_holidays AS no_holidays_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 FROM cron_time_entry t0 INNER JOIN job_cron_time_entry ON t0.id = job_cron_time_entry.cron_time_entry_id WHERE job_cron_time_entry.job_id = ?
Parameters:
[
  16
]
18 1.07 ms
SELECT t0.id AS id_1, t0.hours AS hours_2, t0.minutes AS minutes_3, t0.days_of_week AS days_of_week_4, t0.days_of_month AS days_of_month_5, t0.months AS months_6, t0.no_holidays AS no_holidays_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 FROM cron_time_entry t0 INNER JOIN job_cron_time_entry ON t0.id = job_cron_time_entry.cron_time_entry_id WHERE job_cron_time_entry.job_id = ?
Parameters:
[
  17
]
19 0.94 ms
"START TRANSACTION"
Parameters:
[]
20 1.12 ms
UPDATE job SET hash = ?, updated_at = ? WHERE id = ?
Parameters:
[
  "06eb5bdac0f17d146a11974f996f0d24ea0a2661d769e04f19"
  "2025-07-03 05:40:01"
  1
]
21 14.59 ms
"COMMIT"
Parameters:
[]
22 3.11 ms
"START TRANSACTION"
Parameters:
[]
23 1.11 ms
UPDATE job SET hash = ?, updated_at = ? WHERE id = ?
Parameters:
[
  "6c6f4cd0f2af4feb07731beda269cbd727b90b46957943a2e6"
  "2025-07-03 05:40:09"
  3
]
24 9.26 ms
"COMMIT"
Parameters:
[]
25 1.03 ms
"START TRANSACTION"
Parameters:
[]
26 1.07 ms
UPDATE job SET hash = ?, updated_at = ? WHERE id = ?
Parameters:
[
  "d1c5a8604ed060e592604b39d3d6f20675b555e94490ca7656"
  "2025-07-03 05:40:11"
  5
]
27 6.71 ms
"COMMIT"
Parameters:
[]
28 1.00 ms
"START TRANSACTION"
Parameters:
[]
29 1.12 ms
UPDATE job SET hash = ?, updated_at = ? WHERE id = ?
Parameters:
[
  "d1e94d427a56e8bdec589b08f445740756a51ae71fe3b0133c"
  "2025-07-03 05:40:11"
  7
]
30 5.97 ms
"COMMIT"
Parameters:
[]
31 1.08 ms
"START TRANSACTION"
Parameters:
[]
32 1.16 ms
UPDATE job SET hash = ?, updated_at = ? WHERE id = ?
Parameters:
[
  "e38f76a5e999102dae4efc0c46b3df6a6fc69121858b46b59f"
  "2025-07-03 05:40:11"
  8
]
33 28.23 ms
"COMMIT"
Parameters:
[]
34 1.01 ms
"START TRANSACTION"
Parameters:
[]
35 1.08 ms
UPDATE job SET hash = ?, updated_at = ? WHERE id = ?
Parameters:
[
  "d46f438a17b656c0b81dd7ca21245e59b3ca08f5777941e888"
  "2025-07-03 05:40:12"
  10
]
36 6.35 ms
"COMMIT"
Parameters:
[]
37 1.01 ms
"START TRANSACTION"
Parameters:
[]
38 1.11 ms
UPDATE job SET hash = ?, updated_at = ? WHERE id = ?
Parameters:
[
  "95672e254cdb493607723c71eca643f75b7690c806efebc992"
  "2025-07-03 05:40:12"
  13
]
39 6.46 ms
"COMMIT"
Parameters:
[]
40 1.01 ms
"START TRANSACTION"
Parameters:
[]
41 4.47 ms
UPDATE job SET hash = ?, updated_at = ? WHERE id = ?
Parameters:
[
  "ccf98644ed3c1350ed9e9005eefc8319bd7b75e5f298731da8"
  "2025-07-03 05:40:12"
  15
]
42 7.27 ms
"COMMIT"
Parameters:
[]
43 0.99 ms
"START TRANSACTION"
Parameters:
[]
44 1.12 ms
UPDATE job SET hash = ?, updated_at = ? WHERE id = ?
Parameters:
[
  "55cd1a14429a2327b02d27f745ae160ad58efb553ee3325ebc"
  "2025-07-03 05:40:12"
  17
]
45 5.93 ms
"COMMIT"
Parameters:
[]

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\TypeSendingState No errors.
App\Entity\TypeExportState No errors.
App\Entity\TypeSendingStateGroup No errors.
App\Entity\Message No errors.
App\Entity\StatSending
  • The mappings App\Entity\StatSending#backup_sending and App\Entity\BackupSending#statSendings are inconsistent with each other.
App\Entity\Job No errors.
App\Entity\User No errors.
App\Entity\CronTimeEntry No errors.
App\Entity\JobHistory No errors.
App\Entity\TypeRightlevel No errors.
App\Entity\Depot
  • The mappings App\Entity\Depot#CalendarTourLogistics and App\Entity\CalendarTourLogistic#depot are inconsistent with each other.
App\Entity\TypeState No errors.
App\Entity\UserSetting No errors.
App\Entity\Sending No errors.
App\Entity\DepotGroup No errors.
App\Entity\AssignDepot No errors.
App\Entity\StatSc
  • The mappings App\Entity\StatSc#backup_sending and App\Entity\BackupSending#statScs are inconsistent with each other.
App\Entity\UserLogin No errors.
App\Entity\RulesAutomatic
  • The field 'App\Entity\RulesAutomatic#minimum_age' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
  • The association App\Entity\RulesAutomatic#sender refers to the inverse side field App\Entity\Address#getAutomaticRulesAsSender which does not exist.
  • The association App\Entity\RulesAutomatic#recipient refers to the inverse side field App\Entity\Address#getAutomaticRulesAsRecipient which does not exist.