Symfony Profiler

"COMMIT"

"COMMIT";

delete from
  job_history
where
  job_id = 8
  and id < 7169785

delete from job_history where job_id=8 and id <7169785;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3
FROM
  type_sendavis_state t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM type_sendavis_state t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.start AS start_4,
  t0.end AS end_5,
  t0.autotext AS autotext_6,
  t0.content AS content_7,
  t0.subject AS subject_8,
  t0.html AS html_9,
  t0.dropable AS dropable_10,
  t0.language AS language_11,
  t0.hwt AS hwt_12,
  t0.use_hwt AS use_hwt_13,
  t0.avis AS avis_14,
  t0.does_25_v AS does_25_v_15,
  t0.fixdate AS fixdate_16,
  t0.priority AS priority_17,
  t0.sending_state_id AS sending_state_id_18,
  t0.attach_type_id AS attach_type_id_19
FROM
  message t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.start AS start_4, t0.end AS end_5, t0.autotext AS autotext_6, t0.content AS content_7, t0.subject AS subject_8, t0.html AS html_9, t0.dropable AS dropable_10, t0.language AS language_11, t0.hwt AS hwt_12, t0.use_hwt AS use_hwt_13, t0.avis AS avis_14, t0.does_25_v AS does_25_v_15, t0.fixdate AS fixdate_16, t0.priority AS priority_17, t0.sending_state_id AS sending_state_id_18, t0.attach_type_id AS attach_type_id_19 FROM message t0 WHERE t0.id = 1 LIMIT 1;

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

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;

"START TRANSACTION"

"START TRANSACTION";

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

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 = -1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3
FROM
  type_sendavis_result t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM type_sendavis_result t0;

INSERT INTO job_history (
  start, end, resultcode, resulttext,
  job_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO job_history (start, end, resultcode, resulttext, job_id) VALUES ('2025-04-05 07:26:02', NULL, 1, '', 8);

delete from
  job_history
where
  job_id = 8
  and resultcode = 4
  and id < 0

delete from job_history where job_id=8 and resultcode=4 and id <0;

SELECT
  t0.id AS id_1,
  t0.kind AS kind_2,
  t0.start AS start_3,
  t0.recipients AS recipients_4,
  t0.content AS content_5,
  t0.lastaction AS lastaction_6,
  t0.sending_id AS sending_id_7,
  t0.depot_id AS depot_id_8,
  t0.state_id AS state_id_9,
  t0.result_id AS result_id_10
FROM
  send_avis t0
WHERE
  t0.state_id = ?
ORDER BY
  t0.lastaction ASC
LIMIT
  1000

SELECT t0.id AS id_1, t0.kind AS kind_2, t0.start AS start_3, t0.recipients AS recipients_4, t0.content AS content_5, t0.lastaction AS lastaction_6, t0.sending_id AS sending_id_7, t0.depot_id AS depot_id_8, t0.state_id AS state_id_9, t0.result_id AS result_id_10 FROM send_avis t0 WHERE t0.state_id = 1 ORDER BY t0.lastaction ASC LIMIT 1000;

select
  min(id)
from
  (
    select
      jh.id
    from
      job_history jh
    where
      jh.job_id = 8
    order by
      jh.id desc
    limit
      100
  ) x

select min(id) from (select jh.id from job_history jh where jh.job_id=8 order by jh.id desc limit 100) x;

INSERT INTO error (
  message, file, line, calls, url, callerip,
  created_at, updated_at, user_id,
  created_by_id, updated_by_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO error (message, file, line, calls, url, callerip, created_at, updated_at, user_id, created_by_id, updated_by_id) VALUES ('Warning: Undefined array key 0', '/var/www/revision/dev/v05.00.0750/src/Job/AvisSend.php', 87, '[{\"file\":\"\\/var\\/www\\/revision\\/dev\\/v05.00.0750\\/src\\/Controller\\/RunController.php\",\"line\":\"100\",\"function\":\"run\",\"class\":\"App\\\\Job\\\\AvisSend\",\"type\":\"->\"},{\"file\":\"\\/var\\/www\\/revision\\/dev\\/v05.00.0750\\/vendor\\/symfony\\/http-kernel\\/HttpKernel.php\",\"line\":\"163\",\"function\":\"run\",\"class\":\"App\\\\Controller\\\\RunController\",\"type\":\"->\"},{\"file\":\"\\/var\\/www\\/revision\\/dev\\/v05.00.0750\\/vendor\\/symfony\\/http-kernel\\/HttpKernel.php\",\"line\":\"74\",\"function\":\"handleRaw\",\"class\":\"Symfony\\\\Component\\\\HttpKernel\\\\HttpKernel\",\"type\":\"->\"},{\"file\":\"\\/var\\/www\\/revision\\/dev\\/v05.00.0750\\/vendor\\/symfony\\/http-kernel\\/Kernel.php\",\"line\":\"184\",\"function\":\"handle\",\"class\":\"Symfony\\\\Component\\\\HttpKernel\\\\HttpKernel\",\"type\":\"->\"},{\"file\":\"\\/var\\/www\\/revision\\/dev\\/v05.00.0750\\/vendor\\/symfony\\/runtime\\/Runner\\/Symfony\\/HttpKernelRunner.php\",\"line\":\"35\",\"function\":\"handle\",\"class\":\"Symfony\\\\Component\\\\HttpKernel\\\\Kernel\",\"type\":\"->\"},{\"file\":\"\\/var\\/www\\/revision\\/dev\\/v05.00.0750\\/vendor\\/autoload_runtime.php\",\"line\":\"29\",\"function\":\"run\",\"class\":\"Symfony\\\\Component\\\\Runtime\\\\Runner\\\\Symfony\\\\HttpKernelRunner\",\"type\":\"->\"},{\"file\":\"\\/var\\/www\\/revision\\/dev\\/v05.00.0750\\/public\\/index.php\",\"line\":\"5\",\"args\":[\"\\/var\\/www\\/revision\\/dev\\/v05.00.0750\\/vendor\\/autoload_runtime.php\"],\"function\":\"require_once\"}]', 'https://dev.wunschliefertag.de/run/AvisSend/46dc73d2612a09fced1c1d70196b2cbfae0b5a8315145861c8', '80.158.57.161', '2025-04-05 07:26:02', '2025-04-05 07:26:02', NULL, '-1', '-1');

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

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;

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.description AS description_2,
  m0_.start AS start_3,
  m0_.end AS end_4,
  m0_.autotext AS autotext_5,
  m0_.content AS content_6,
  m0_.subject AS subject_7,
  m0_.html AS html_8,
  m0_.dropable AS dropable_9,
  m0_.language AS language_10,
  m0_.hwt AS hwt_11,
  m0_.use_hwt AS use_hwt_12,
  m0_.avis AS avis_13,
  m0_.does_25_v AS does_25_v_14,
  m0_.fixdate AS fixdate_15,
  m0_.priority AS priority_16,
  m0_.sending_state_id AS sending_state_id_17,
  m0_.attach_type_id AS attach_type_id_18
FROM
  message m0_
  LEFT JOIN depot_message d1_ ON m0_.id = d1_.message_id
WHERE
  d1_.depot_id = ?
  AND m0_.name LIKE ?
ORDER BY
  m0_.id DESC

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.description AS description_2, m0_.start AS start_3, m0_.end AS end_4, m0_.autotext AS autotext_5, m0_.content AS content_6, m0_.subject AS subject_7, m0_.html AS html_8, m0_.dropable AS dropable_9, m0_.language AS language_10, m0_.hwt AS hwt_11, m0_.use_hwt AS use_hwt_12, m0_.avis AS avis_13, m0_.does_25_v AS does_25_v_14, m0_.fixdate AS fixdate_15, m0_.priority AS priority_16, m0_.sending_state_id AS sending_state_id_17, m0_.attach_type_id AS attach_type_id_18 FROM message m0_ LEFT JOIN depot_message d1_ ON m0_.id = d1_.message_id WHERE d1_.depot_id = '9' AND m0_.name LIKE 'avis_sms%' ORDER BY m0_.id DESC;

UPDATE
  job
SET
  last_run = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE job SET last_run = '2025-04-05 07:26:02', updated_at = '2025-04-05 07:26:02' WHERE id = 8;

select
  min(id)
from
  (
    select
      jh.id
    from
      job_history jh
    where
      jh.job_id = 8
      and resultcode = 4
    order by
      jh.id desc
    limit
      20
  ) x

select min(id) from (select jh.id from job_history jh where jh.job_id=8 and resultcode=4 order by jh.id desc limit 20) x;