Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.name AS name_4,
  t0.surname AS surname_5,
  t0.user_photo_id AS user_photo_id_6,
  t7.id AS id_8,
  t7.user_id AS user_id_9,
  t7.timestamp AS timestamp_10,
  t7.edited_order_id AS edited_order_id_11,
  t7.user_id AS user_id_12
FROM
  `users` t0
  LEFT JOIN edit_user t7 ON t7.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.name AS name_4, t0.surname AS surname_5, t0.user_photo_id AS user_photo_id_6, t7.id AS id_8, t7.user_id AS user_id_9, t7.timestamp AS timestamp_10, t7.edited_order_id AS edited_order_id_11, t7.user_id AS user_id_12 FROM `users` t0 LEFT JOIN edit_user t7 ON t7.user_id = t0.id WHERE t0.id = 29;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_date AS created_date_3,
  t0.created_username AS created_username_4,
  t0.update_date AS update_date_5,
  t0.update_username AS update_username_6,
  t0.super_admin AS super_admin_7
FROM
  `roles` t0
  INNER JOIN user_role ON t0.id = user_role.role_id
WHERE
  user_role.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_date AS created_date_3, t0.created_username AS created_username_4, t0.update_date AS update_date_5, t0.update_username AS update_username_6, t0.super_admin AS super_admin_7 FROM `roles` t0 INNER JOIN user_role ON t0.id = user_role.role_id WHERE user_role.user_id = 29;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.number_of_tarifs_per_site AS number_of_tarifs_per_site_3,
  t0.hotline_number AS hotline_number_4,
  t0.public_name AS public_name_5,
  t0.contact_email AS contact_email_6,
  t0.logo AS logo_7,
  t0.cashback_redemption_days AS cashback_redemption_days_8
FROM
  `partners` t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.number_of_tarifs_per_site AS number_of_tarifs_per_site_3, t0.hotline_number AS hotline_number_4, t0.public_name AS public_name_5, t0.contact_email AS contact_email_6, t0.logo AS logo_7, t0.cashback_redemption_days AS cashback_redemption_days_8 FROM `partners` t0 WHERE t0.id = 1 LIMIT 1;

SELECT
  COUNT(o0_.booking_provider) AS sclr_0,
  o0_.booking_provider AS booking_provider_1
FROM
  `orders` o0_
WHERE
  o0_.status <> 9
  AND (
    o0_.timestamp BETWEEN ?
    AND ?
  )
GROUP BY
  o0_.booking_provider
ORDER BY
  sclr_0 DESC

SELECT COUNT(o0_.booking_provider) AS sclr_0, o0_.booking_provider AS booking_provider_1 FROM `orders` o0_ WHERE o0_.status <> 9 AND (o0_.timestamp BETWEEN '2026-05-03' AND '2026-06-02 23:59:59') GROUP BY o0_.booking_provider ORDER BY sclr_0 DESC;

SELECT
  COUNT(o0_.partner_id) AS sclr_0,
  o0_.partner_id AS sclr_1,
  p1_.name AS name_2
FROM
  `orders` o0_
  LEFT JOIN `partners` p1_ ON o0_.partner_id = p1_.id
  AND (p1_.id = o0_.partner_id)
WHERE
  o0_.status <> 9
  AND (
    o0_.timestamp BETWEEN ?
    AND ?
  )
GROUP BY
  o0_.partner_id
ORDER BY
  sclr_0 DESC

SELECT COUNT(o0_.partner_id) AS sclr_0, o0_.partner_id AS sclr_1, p1_.name AS name_2 FROM `orders` o0_ LEFT JOIN `partners` p1_ ON o0_.partner_id = p1_.id AND (p1_.id = o0_.partner_id) WHERE o0_.status <> 9 AND (o0_.timestamp BETWEEN '2026-05-03' AND '2026-06-02 23:59:59') GROUP BY o0_.partner_id ORDER BY sclr_0 DESC;

SELECT
  DATE(o0_.timestamp) AS sclr_0,
  ROUND(
    SUM(o0_.commission),
    0
  ) AS sclr_1,
  COUNT(o0_.id) AS sclr_2,
  SUM(
    CASE WHEN o0_.router_rental = 1 THEN
      1
    ELSE
      0
    END
  ) AS sclr_3
FROM
  `orders` o0_
WHERE
  o0_.status <> 9
  AND (
    o0_.timestamp BETWEEN ?
    AND ?
  )
GROUP BY
  sclr_0
ORDER BY
  sclr_0 DESC

SELECT DATE(o0_.timestamp) AS sclr_0, ROUND(SUM(o0_.commission), 0) AS sclr_1, COUNT(o0_.id) AS sclr_2, SUM(CASE WHEN o0_.router_rental = 1 THEN 1 ELSE 0 END) AS sclr_3 FROM `orders` o0_ WHERE o0_.status <> 9 AND (o0_.timestamp BETWEEN '2026-05-03' AND '2026-06-02 23:59:59') GROUP BY sclr_0 ORDER BY sclr_0 DESC;

SELECT
  DATE(o0_.timestamp) AS sclr_0,
  ROUND(
    SUM(o0_.commission),
    0
  ) AS sclr_1,
  COUNT(o0_.id) AS sclr_2,
  SUM(
    CASE WHEN o0_.router_rental = 1 THEN
      1
    ELSE
      0
    END
  ) AS sclr_3
FROM
  `orders` o0_
WHERE
  o0_.status <> 9
  AND (
    o0_.timestamp BETWEEN ?
    AND ?
  )
  AND o0_.partner_id IN (?, ?)
GROUP BY
  sclr_0
ORDER BY
  sclr_0 DESC

SELECT DATE(o0_.timestamp) AS sclr_0, ROUND(SUM(o0_.commission), 0) AS sclr_1, COUNT(o0_.id) AS sclr_2, SUM(CASE WHEN o0_.router_rental = 1 THEN 1 ELSE 0 END) AS sclr_3 FROM `orders` o0_ WHERE o0_.status <> 9 AND (o0_.timestamp BETWEEN '2026-05-03' AND '2026-06-02 23:59:59') AND o0_.partner_id IN ('10', ' 12') GROUP BY sclr_0 ORDER BY sclr_0 DESC;

SELECT
  DATE(o0_.timestamp) AS sclr_0,
  ROUND(
    SUM(o0_.commission),
    0
  ) AS sclr_1,
  COUNT(o0_.id) AS sclr_2,
  SUM(
    CASE WHEN o0_.router_rental = 1 THEN
      1
    ELSE
      0
    END
  ) AS sclr_3
FROM
  `orders` o0_
WHERE
  o0_.status <> 9
  AND (
    o0_.timestamp BETWEEN ?
    AND ?
  )
  AND o0_.partner_id NOT IN (10, 12)
GROUP BY
  sclr_0
ORDER BY
  sclr_0 DESC

SELECT DATE(o0_.timestamp) AS sclr_0, ROUND(SUM(o0_.commission), 0) AS sclr_1, COUNT(o0_.id) AS sclr_2, SUM(CASE WHEN o0_.router_rental = 1 THEN 1 ELSE 0 END) AS sclr_3 FROM `orders` o0_ WHERE o0_.status <> 9 AND (o0_.timestamp BETWEEN '2026-05-03' AND '2026-06-02 23:59:59') AND o0_.partner_id NOT IN (10, 12) GROUP BY sclr_0 ORDER BY sclr_0 DESC;

SELECT
  COUNT(1) AS sclr_0
FROM
  `orders` o0_
WHERE
  o0_.status <> 9
  AND (
    o0_.timestamp BETWEEN ?
    AND ?
  )

SELECT COUNT(1) AS sclr_0 FROM `orders` o0_ WHERE o0_.status <> 9 AND (o0_.timestamp BETWEEN '2026-05-19 00:00:00' AND '2026-05-19 08:51:08');

SELECT
  COUNT(1) AS sclr_0
FROM
  `orders` o0_
WHERE
  o0_.status <> 9
  AND (
    o0_.timestamp BETWEEN ?
    AND ?
  )

SELECT COUNT(1) AS sclr_0 FROM `orders` o0_ WHERE o0_.status <> 9 AND (o0_.timestamp BETWEEN '2026-05-12 00:00:00' AND '2026-05-12 08:51:08');

SELECT
  COUNT(1) AS sclr_0
FROM
  `orders` o0_
WHERE
  o0_.status <> 9
  AND (
    o0_.timestamp BETWEEN ?
    AND ?
  )

SELECT COUNT(1) AS sclr_0 FROM `orders` o0_ WHERE o0_.status <> 9 AND (o0_.timestamp BETWEEN '2026-05-05 00:00:00' AND '2026-05-05 08:51:08');

SELECT
  COUNT(1) AS sclr_0
FROM
  `orders` o0_
WHERE
  o0_.status <> 9
  AND (
    o0_.timestamp BETWEEN ?
    AND ?
  )

SELECT COUNT(1) AS sclr_0 FROM `orders` o0_ WHERE o0_.status <> 9 AND (o0_.timestamp BETWEEN '2026-05-26 00:00:00' AND '2026-05-26 08:51:08');

SELECT
  COUNT(1) AS sclr_0
FROM
  `orders` o0_
WHERE
  o0_.status <> 9
  AND (
    o0_.timestamp BETWEEN ?
    AND ?
  )

SELECT COUNT(1) AS sclr_0 FROM `orders` o0_ WHERE o0_.status <> 9 AND (o0_.timestamp BETWEEN '2026-06-02 00:00:00' AND '2026-06-02 08:51:08');

SELECT
  DATE(o0_.timestamp) AS sclr_0,
  sum(
    CASE WHEN o0_.status = 8 THEN
      1
    ELSE
      0
    END
  ) AS sclr_1,
  sum(
    CASE WHEN o0_.status NOT IN (8, 9) THEN
      1
    ELSE
      0
    END
  ) AS sclr_2,
  MONTH(o0_.timestamp) AS sclr_3,
  YEAR(o0_.timestamp) AS sclr_4
FROM
  `orders` o0_
WHERE
  o0_.timestamp > ?
GROUP BY
  sclr_3
ORDER BY
  sclr_0 DESC
LIMIT
  12

SELECT DATE(o0_.timestamp) AS sclr_0, sum(CASE WHEN o0_.status = 8 THEN 1 ELSE 0 END) AS sclr_1, sum(CASE WHEN o0_.status NOT IN (8, 9) THEN 1 ELSE 0 END) AS sclr_2, MONTH(o0_.timestamp) AS sclr_3, YEAR(o0_.timestamp) AS sclr_4 FROM `orders` o0_ WHERE o0_.timestamp > '2025-07-01' GROUP BY sclr_3 ORDER BY sclr_0 DESC LIMIT 12;

SELECT
  DATE(o0_.timestamp) AS sclr_0,
  sum(
    CASE WHEN o0_.status = 8 THEN
      1
    ELSE
      0
    END
  ) AS sclr_1,
  sum(
    CASE WHEN o0_.status NOT IN (8, 9) THEN
      1
    ELSE
      0
    END
  ) AS sclr_2,
  WEEK(o0_.timestamp, 1) AS sclr_3,
  YEAR(o0_.timestamp) AS sclr_4
FROM
  `orders` o0_
WHERE
  o0_.status <> 9
  AND YEAR(o0_.timestamp) = ?
GROUP BY
  sclr_3
ORDER BY
  sclr_0 DESC
LIMIT
  12

SELECT DATE(o0_.timestamp) AS sclr_0, sum(CASE WHEN o0_.status = 8 THEN 1 ELSE 0 END) AS sclr_1, sum(CASE WHEN o0_.status NOT IN (8, 9) THEN 1 ELSE 0 END) AS sclr_2, WEEK(o0_.timestamp, 1) AS sclr_3, YEAR(o0_.timestamp) AS sclr_4 FROM `orders` o0_ WHERE o0_.status <> 9 AND YEAR(o0_.timestamp) = '2026' GROUP BY sclr_3 ORDER BY sclr_0 DESC LIMIT 12;

SELECT
  SUM(
    CASE WHEN o0_.partner_id IN (10, 12) THEN
      1
    ELSE
      0
    END
  ) AS sclr_0,
  SUM(
    CASE WHEN o0_.partner_id NOT IN (10, 12) THEN
      1
    ELSE
      0
    END
  ) AS sclr_1
FROM
  `orders` o0_
WHERE
  o0_.status <> 9
  AND (
    o0_.timestamp BETWEEN ?
    AND ?
  )

SELECT SUM(CASE WHEN o0_.partner_id IN (10, 12) THEN 1 ELSE 0 END) AS sclr_0, SUM(CASE WHEN o0_.partner_id NOT IN (10, 12) THEN 1 ELSE 0 END) AS sclr_1 FROM `orders` o0_ WHERE o0_.status <> 9 AND (o0_.timestamp BETWEEN '2026-05-03' AND '2026-06-02 23:59:59');

SELECT
  SUM(o0_.cashback_value) AS sclr_0,
  COUNT(1) AS sclr_1
FROM
  `orders` o0_
  LEFT JOIN `cashback_doc_uploads` c1_ ON o0_.id = c1_.customer_order_id
WHERE
  o0_.cashback_status_id = 2
  AND o0_.status <> 9

SELECT SUM(o0_.cashback_value) AS sclr_0, COUNT(1) AS sclr_1 FROM `orders` o0_ LEFT JOIN `cashback_doc_uploads` c1_ ON o0_.id = c1_.customer_order_id WHERE o0_.cashback_status_id = 2 AND o0_.status <> 9;

SELECT
  HOUR(o0_.timestamp) AS sclr_0,
  COUNT(1) AS sclr_1
FROM
  `orders` o0_
WHERE
  o0_.status <> 9
  AND YEAR(o0_.timestamp) = ?
  AND MONTH(o0_.timestamp) = ?
  AND DAY(o0_.timestamp) = ?
GROUP BY
  sclr_0

SELECT HOUR(o0_.timestamp) AS sclr_0, COUNT(1) AS sclr_1 FROM `orders` o0_ WHERE o0_.status <> 9 AND YEAR(o0_.timestamp) = '2026' AND MONTH(o0_.timestamp) = '06' AND DAY(o0_.timestamp) = '02' GROUP BY sclr_0;

SELECT
  HOUR(o0_.timestamp) AS sclr_0,
  COUNT(1) AS sclr_1
FROM
  `orders` o0_
WHERE
  o0_.status <> 9
  AND YEAR(o0_.timestamp) = ?
  AND MONTH(o0_.timestamp) = ?
  AND DAY(o0_.timestamp) = ?
GROUP BY
  sclr_0

SELECT HOUR(o0_.timestamp) AS sclr_0, COUNT(1) AS sclr_1 FROM `orders` o0_ WHERE o0_.status <> 9 AND YEAR(o0_.timestamp) = '2026' AND MONTH(o0_.timestamp) = '05' AND DAY(o0_.timestamp) = '26' GROUP BY sclr_0;

SELECT
  ROUND(
    AVG(a0_.duration) / 1000000,
    2
  ) AS sclr_0,
  a0_.api_id AS api_id_1
FROM
  `api_durations` a0_
WHERE
  YEAR(a0_.timestamp) = ?
  AND MONTH(a0_.timestamp) = ?
  AND DAY(a0_.timestamp) = ?
  AND HOUR(a0_.timestamp) >= ?
  AND MINUTE(a0_.timestamp) >= ?
  AND a0_.timestamp < NOW()
GROUP BY
  a0_.api_id
ORDER BY
  a0_.api_id ASC

SELECT ROUND(AVG(a0_.duration) / 1000000, 2) AS sclr_0, a0_.api_id AS api_id_1 FROM `api_durations` a0_ WHERE YEAR(a0_.timestamp) = '2026' AND MONTH(a0_.timestamp) = '06' AND DAY(a0_.timestamp) = '02' AND HOUR(a0_.timestamp) >= '08' AND MINUTE(a0_.timestamp) >= '50' AND a0_.timestamp < NOW() GROUP BY a0_.api_id ORDER BY a0_.api_id ASC;

SELECT
  ROUND(
    AVG(a0_.duration) / 1000000,
    2
  ) AS sclr_0,
  a0_.api_id AS api_id_1
FROM
  `api_durations` a0_
WHERE
  YEAR(a0_.timestamp) = ?
  AND MONTH(a0_.timestamp) = ?
  AND DAY(a0_.timestamp) = ?
  AND HOUR(a0_.timestamp) >= ?
  AND MINUTE(a0_.timestamp) >= ?
  AND a0_.timestamp < NOW()
GROUP BY
  a0_.api_id
ORDER BY
  a0_.api_id ASC

SELECT ROUND(AVG(a0_.duration) / 1000000, 2) AS sclr_0, a0_.api_id AS api_id_1 FROM `api_durations` a0_ WHERE YEAR(a0_.timestamp) = '2026' AND MONTH(a0_.timestamp) = '06' AND DAY(a0_.timestamp) = '02' AND HOUR(a0_.timestamp) >= '08' AND MINUTE(a0_.timestamp) >= '21' AND a0_.timestamp < NOW() GROUP BY a0_.api_id ORDER BY a0_.api_id ASC;

SELECT
  ROUND(
    AVG(a0_.duration) / 1000000,
    2
  ) AS sclr_0,
  a0_.api_id AS api_id_1
FROM
  `api_durations` a0_
WHERE
  YEAR(a0_.timestamp) = ?
  AND MONTH(a0_.timestamp) = ?
  AND DAY(a0_.timestamp) = ?
  AND HOUR(a0_.timestamp) >= ?
  AND MINUTE(a0_.timestamp) >= ?
  AND a0_.timestamp < NOW()
GROUP BY
  a0_.api_id
ORDER BY
  a0_.api_id ASC

SELECT ROUND(AVG(a0_.duration) / 1000000, 2) AS sclr_0, a0_.api_id AS api_id_1 FROM `api_durations` a0_ WHERE YEAR(a0_.timestamp) = '2026' AND MONTH(a0_.timestamp) = '06' AND DAY(a0_.timestamp) = '02' AND HOUR(a0_.timestamp) >= '06' AND MINUTE(a0_.timestamp) >= '51' AND a0_.timestamp < NOW() GROUP BY a0_.api_id ORDER BY a0_.api_id ASC;

SELECT
  SUM(
    CASE WHEN a0_.error = 1 THEN
      1
    ELSE
      0
    END
  ) AS sclr_0,
  SUM(
    CASE WHEN a0_.error = 2 THEN
      1
    ELSE
      0
    END
  ) AS sclr_1,
  SUM(
    CASE WHEN a0_.error = 0 THEN
      1
    ELSE
      0
    END
  ) AS sclr_2,
  a0_.api_id AS api_id_3
FROM
  `api_durations` a0_
WHERE
  YEAR(a0_.timestamp) = ?
  AND MONTH(a0_.timestamp) = ?
  AND DAY(a0_.timestamp) = ?
GROUP BY
  a0_.api_id
ORDER BY
  a0_.api_id ASC

SELECT SUM(CASE WHEN a0_.error = 1 THEN 1 ELSE 0 END) AS sclr_0, SUM(CASE WHEN a0_.error = 2 THEN 1 ELSE 0 END) AS sclr_1, SUM(CASE WHEN a0_.error = 0 THEN 1 ELSE 0 END) AS sclr_2, a0_.api_id AS api_id_3 FROM `api_durations` a0_ WHERE YEAR(a0_.timestamp) = '2026' AND MONTH(a0_.timestamp) = '06' AND DAY(a0_.timestamp) = '02' GROUP BY a0_.api_id ORDER BY a0_.api_id ASC;

DELETE FROM
  `api_durations`
WHERE
  timestamp < ?

DELETE FROM `api_durations` WHERE timestamp < '2026-06-02';

SELECT
  COUNT(1) AS sclr_0
FROM
  indexing_schedule i0_

SELECT COUNT(1) AS sclr_0 FROM indexing_schedule i0_;

SELECT
  COUNT(1) AS sclr_0
FROM
  edit_user e0_

SELECT COUNT(1) AS sclr_0 FROM edit_user e0_;

SELECT
  COUNT(1) AS sclr_0
FROM
  `query_cache` q0_

SELECT COUNT(1) AS sclr_0 FROM `query_cache` q0_;

INSERT INTO user_last_seen (
  user_id, user_name, last_used_module,
  timestamp
)
VALUES
  (
    29,
    'Tomasz Jacek',
    'Index',
    NOW()
  ) ON DUPLICATE KEY
UPDATE
  user_id = 29,
  user_name = 'Tomasz Jacek',
  last_used_module = 'Index',
  timestamp = NOW()

INSERT INTO user_last_seen (user_id, user_name, last_used_module, timestamp) VALUES (29, 'Tomasz Jacek', 'Index', NOW())
                        ON DUPLICATE KEY UPDATE user_id = 29, user_name = 'Tomasz Jacek', last_used_module = 'Index', timestamp = NOW();

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO `logs` (
  module, ip, timestamp, action, user_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO `logs` (module, ip, timestamp, action, user_id) VALUES ('Index', '213.136.243.144', '2026-06-02 08:51:10', 'Requested Uri: /
Parameters:
array (
)', 29);

"COMMIT"

"COMMIT";