Symfony Profiler

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;

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;

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
  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.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
  min(id)
from
  (
    select
      jh.id
    from
      job_history jh
    where
      jh.job_id = 17
      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=17 and resultcode=4 order by jh.id desc limit 20) x;

delete from
  job_history
where
  job_id = 17
  and resultcode = 4
  and id < 8648650

delete from job_history where job_id=17 and resultcode=4 and id <8648650;

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

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

delete from
  job_history
where
  job_id = 17
  and id < 8648650

delete from job_history where job_id=17 and id <8648650;

"START TRANSACTION"

"START TRANSACTION";

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

INSERT INTO job_history (start, end, resultcode, resulttext, job_id) VALUES ('2025-09-16 04:58:05', NULL, 1, '', 17);

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

UPDATE job SET last_run = '2025-09-16 04:58:05', updated_at = '2025-09-16 04:58:05' WHERE id = 17;

"COMMIT"

"COMMIT";

select
  distinct s.id
from
  sending s
  inner join address a2 on s.hinted = 0
  and s.recipient_id = a2.id
  and a2.isocountry is not null
  left join address a3 on s.hinted = 0
  and s.sender_id = a3.id
  and a3.isocountry is not null
where
  s.id not in (
    select
      distinct s.id
    from
      sending s
      left join address a on a.id = s.recipient_id
      left join avis_hint av on a.isocountry = av.country
      and a.zip = av.zip
    where
      (
        av.depot_id = s.depot_id
        or av.depot_id is null
      )
      and s.hinted = 0
      and av.hint_type_id in (2, 3)
      and lower(
        concat(
          ifnull(a.name1, ''),
          ' ',
          ifnull(a.name2, '')
        )
      ) like lower(
        concat(
          '%',
          replace(name, ' ', '%'),
          '%'
        )
      )
      and (
        av.street is null
        or lower(
          concat(
            ifnull(a.street1, ''),
            ' ',
            ifnull(a.street2, '')
          )
        ) like lower(
          concat(
            '%',
            replace(av.street, ' ', '%'),
            '%'
          )
        )
      )
  )
  and s.id not in (
    select
      distinct s.id
    from
      sending s
      left join address a on a.id = s.sender_id
      left join avis_hint av on a.isocountry = av.country
      and a.zip = av.zip
    where
      (
        av.depot_id = s.depot_id
        or av.depot_id is null
      )
      and s.hinted = 0
      and av.hint_type_id in (1, 3)
      and lower(
        concat(
          ifnull(a.name1, ''),
          ' ',
          ifnull(a.name2, '')
        )
      ) like lower(
        concat(
          '%',
          replace(name, ' ', '%'),
          '%'
        )
      )
      and (
        av.street is null
        or lower(
          concat(
            ifnull(a.street1, ''),
            ' ',
            ifnull(a.street2, '')
          )
        ) like lower(
          concat(
            '%',
            replace(av.street, ' ', '%'),
            '%'
          )
        )
      )
  )
limit
  1000

select distinct s.id from sending s
    inner join address a2 on s.hinted=0 and s.recipient_id = a2.id and a2.isocountry is not null
    left join address a3 on s.hinted=0 and s.sender_id = a3.id and a3.isocountry is not null
where s.id not in (
    select distinct s.id
    from sending s
         left join address a on a.id = s.recipient_id
         left join avis_hint av on a.isocountry = av.country and a.zip = av.zip
    where (av.depot_id = s.depot_id or av.depot_id is null)
      and s.hinted=0
      and av.hint_type_id in (2,3)
      and lower(concat(ifnull(a.name1,''), ' ', ifnull(a.name2,''))) like lower(concat('%', replace(name, ' ', '%'), '%')) 
      and (av.street is null or lower(concat(ifnull(a.street1,''), ' ', ifnull(a.street2,''))) like lower(concat('%', replace(av.street, ' ', '%'), '%'))))
and s.id not in (
    select distinct s.id
    from sending s
         left join address a on a.id = s.sender_id
         left join avis_hint av on a.isocountry = av.country and a.zip = av.zip
    where (av.depot_id = s.depot_id or av.depot_id is null)
      and s.hinted=0
      and av.hint_type_id in (1,3)
      and lower(concat(ifnull(a.name1,''), ' ', ifnull(a.name2,''))) like lower(concat('%', replace(name, ' ', '%'), '%'))
      and (av.street is null or lower(concat(ifnull(a.street1,''), ' ', ifnull(a.street2,''))) like lower(concat('%', replace(av.street, ' ', '%'), '%'))))
limit 1000;

insert ignore into sending_avis_hint (sending_id, avis_hint_id)
select
  s.id,
  ah.id
from
  sending s
  inner join address a on s.recipient_id = a.id
  and a.isocountry is not null
  left join avis_hint ah on a.isocountry = ah.country
  and ah.zip = a.zip
where
  hint_type_id in (2, 3)
  and s.hinted = 0
  and (
    s.depot_id = ah.depot_id
    or ah.depot_id is null
  )
  and lower(
    concat(
      ifnull(a.name1, ''),
      ' ',
      ifnull(a.name2, '')
    )
  ) like lower(
    concat(
      '%',
      replace(ah.name, ' ', '%'),
      '%'
    )
  )
  and (
    ah.street is null
    or lower(
      concat(
        ifnull(a.street1, ''),
        ' ',
        ifnull(a.street2, '')
      )
    ) like lower(
      concat(
        '%',
        replace(ah.street, ' ', '%'),
        '%'
      )
    )
  )

insert ignore into sending_avis_hint (sending_id, avis_hint_id) 
select s.id, ah.id
from sending s
         inner join address a on s.recipient_id = a.id and a.isocountry is not null
         left join avis_hint ah on a.isocountry=ah.country and ah.zip=a.zip
where hint_type_id in (2, 3)
  and s.hinted = 0
  and (s.depot_id = ah.depot_id or ah.depot_id is null)
  and lower(concat(ifnull(a.name1,''), ' ', ifnull(a.name2,''))) like lower(concat('%', replace(ah.name, ' ', '%'), '%'))
  and (ah.street is null or lower(concat(ifnull(a.street1,''), ' ', ifnull(a.street2,''))) like lower(concat('%', replace(ah.street, ' ', '%'), '%')));

insert ignore into sending_avis_hint (sending_id, avis_hint_id)
select
  s.id,
  ah.id
from
  sending s
  inner join address a on s.sender_id = a.id
  and a.isocountry is not null
  left join avis_hint ah on a.isocountry = ah.country
  and ah.zip = a.zip
where
  hint_type_id in (1, 3)
  and s.hinted = 0
  and (
    s.depot_id = ah.depot_id
    or ah.depot_id is null
  )
  and lower(
    concat(
      ifnull(a.name1, ''),
      ' ',
      ifnull(a.name2, '')
    )
  ) like lower(
    concat(
      '%',
      replace(ah.name, ' ', '%'),
      '%'
    )
  )
  and (
    ah.street is null
    or lower(
      concat(
        ifnull(a.street1, ''),
        ' ',
        ifnull(a.street2, '')
      )
    ) like lower(
      concat(
        '%',
        replace(ah.street, ' ', '%'),
        '%'
      )
    )
  )

insert ignore into sending_avis_hint (sending_id, avis_hint_id) 
select s.id, ah.id
from sending s
         inner join address a on s.sender_id = a.id and a.isocountry is not null
         left join avis_hint ah on a.isocountry=ah.country and ah.zip=a.zip
where hint_type_id in (1, 3)
  and s.hinted = 0
  and (s.depot_id = ah.depot_id or ah.depot_id is null)
  and lower(concat(ifnull(a.name1,''), ' ', ifnull(a.name2,''))) like lower(concat('%', replace(ah.name, ' ', '%'), '%'))
  and (ah.street is null or lower(concat(ifnull(a.street1,''), ' ', ifnull(a.street2,''))) like lower(concat('%', replace(ah.street, ' ', '%'), '%')));

update
  sending
set
  hinted = 1
where
  hinted = 0
  and id in (
    select
      distinct sending_id
    from
      sending_avis_hint
  );

update sending set hinted=1 where hinted=0 and id in (select distinct sending_id from sending_avis_hint); ;

"START TRANSACTION"

"START TRANSACTION";

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

UPDATE job SET hash = NULL, updated_at = '2025-09-16 04:58:05' WHERE id = 17;

UPDATE
  job_history
SET
  end = ?,
  resultcode = ?
WHERE
  id = ?

UPDATE job_history SET end = '2025-09-16 04:58:05', resultcode = 4 WHERE id = 8648728;

"COMMIT"

"COMMIT";