Symfony Profiler

SELECT
  c.id,
  c.code,
  c.used
FROM
  pm_pregenerated_code c
  LEFT JOIN pm_package_code pc ON (c.code = pc.code)
WHERE
  pc.id IS NULL
  AND (
    c.used IS NULL
    OR c.used < :minDate
  )
ORDER BY
  c.used ASC NULLS FIRST
LIMIT
  1

SELECT c.id, c.code, c.used
            FROM pm_pregenerated_code c
            LEFT JOIN pm_package_code pc ON (c.code = pc.code)
            WHERE pc.id IS NULL
            AND (c.used IS NULL OR c.used < :minDate)
            ORDER BY c.used ASC NULLS FIRST
            LIMIT 1;

SELECT
  COUNT(c.id)
FROM
  pm_pregenerated_code c
  LEFT JOIN pm_package_code pc ON (c.code = pc.code)
WHERE
  pc.id IS NULL
  AND (
    c.used IS NULL
    OR c.used < :minDate
  )

SELECT COUNT(c.id)
            FROM pm_pregenerated_code c
            LEFT JOIN pm_package_code pc ON (c.code = pc.code)
            WHERE pc.id IS NULL
            AND (c.used IS NULL OR c.used < :minDate)
            ;

SELECT
  t0.key AS key_1,
  t0.value AS value_2,
  t0.modified AS modified_3,
  t0.description AS description_4
FROM
  pm_configuration t0
WHERE
  t0.key = ?
LIMIT
  1

SELECT t0.key AS key_1, t0.value AS value_2, t0.modified AS modified_3, t0.description AS description_4 FROM pm_configuration t0 WHERE t0.key = 'flexibee_api_url' LIMIT 1;

SELECT
  t0.key AS key_1,
  t0.value AS value_2,
  t0.modified AS modified_3,
  t0.description AS description_4
FROM
  pm_configuration t0
WHERE
  t0.key = ?

SELECT t0.key AS key_1, t0.value AS value_2, t0.modified AS modified_3, t0.description AS description_4 FROM pm_configuration t0 WHERE t0.key = 'flexibee_api_url';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.nameOrigin AS nameorigin_3,
  t0.iso3 AS iso3_4,
  t0.iso AS iso_5,
  t0.vat AS vat_6,
  t0.language_id AS language_id_7,
  t0.currency_id AS currency_id_8
FROM
  pm_country t0
WHERE
  t0.iso = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.nameOrigin AS nameorigin_3, t0.iso3 AS iso3_4, t0.iso AS iso_5, t0.vat AS vat_6, t0.language_id AS language_id_7, t0.currency_id AS currency_id_8 FROM pm_country t0 WHERE t0.iso = 'de' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.nameOrigin AS nameorigin_2,
  p0_.iso3 AS iso3_3,
  p0_.iso AS iso_4,
  p0_.vat AS vat_5,
  p0_.language_id AS language_id_6,
  p0_.currency_id AS currency_id_7
FROM
  pm_country p0_
  INNER JOIN (
    pm_carrier_price p1_
    LEFT JOIN pm_carrier_price_delivery p2_ ON p1_.id = p2_.id
    LEFT JOIN pm_carrier_price_postman p3_ ON p1_.id = p3_.id
  ) ON (p0_.id = p1_.country_id)
WHERE
  p1_.discriminator IN ('carrierpricepostman')
  AND p1_.active = true
  AND p0_.iso = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.nameOrigin AS nameorigin_2, p0_.iso3 AS iso3_3, p0_.iso AS iso_4, p0_.vat AS vat_5, p0_.language_id AS language_id_6, p0_.currency_id AS currency_id_7 FROM pm_country p0_ INNER JOIN (pm_carrier_price p1_ LEFT JOIN pm_carrier_price_delivery p2_ ON p1_.id = p2_.id LEFT JOIN pm_carrier_price_postman p3_ ON p1_.id = p3_.id) ON (p0_.id = p1_.country_id) WHERE p1_.discriminator IN ('carrierpricepostman') AND p1_.active = true AND p0_.iso = 'de';

SELECT
  p0_.id AS id_0,
  p0_.weight AS weight_1,
  p0_.price_buy AS price_buy_2,
  p0_.price_sell AS price_sell_3,
  p0_.length AS length_4,
  p0_.width AS width_5,
  p0_.active AS active_6,
  p0_.height AS height_7,
  p0_.discriminator AS discriminator_8,
  p0_.carrier_id AS carrier_id_9,
  p0_.country_id AS country_id_10
FROM
  pm_carrier_price_postman p1_
  INNER JOIN pm_carrier_price p0_ ON p1_.id = p0_.id
WHERE
  p0_.country_id = ?
  AND p0_.weight >= ?
  AND p0_.active = true
ORDER BY
  p0_.price_sell ASC,
  p0_.weight ASC
LIMIT
  1

SELECT p0_.id AS id_0, p0_.weight AS weight_1, p0_.price_buy AS price_buy_2, p0_.price_sell AS price_sell_3, p0_.length AS length_4, p0_.width AS width_5, p0_.active AS active_6, p0_.height AS height_7, p0_.discriminator AS discriminator_8, p0_.carrier_id AS carrier_id_9, p0_.country_id AS country_id_10 FROM pm_carrier_price_postman p1_ INNER JOIN pm_carrier_price p0_ ON p1_.id = p0_.id WHERE p0_.country_id = 2 AND p0_.weight >= 0 AND p0_.active = true ORDER BY p0_.price_sell ASC, p0_.weight ASC LIMIT 1;

"COMMIT"

"COMMIT";

UPDATE
  pm_pregenerated_code
SET
  used = ?
WHERE
  id = ?

UPDATE pm_pregenerated_code SET used = '2026-01-15 06:29:31' WHERE id = 12745;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.used AS used_3
FROM
  pm_pregenerated_code t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.used AS used_3 FROM pm_pregenerated_code t0 WHERE t0.id = 12745;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.nameOrigin AS nameorigin_2,
  p0_.iso3 AS iso3_3,
  p0_.iso AS iso_4,
  p0_.vat AS vat_5,
  p0_.language_id AS language_id_6,
  p0_.currency_id AS currency_id_7
FROM
  pm_country p0_
  INNER JOIN (
    pm_carrier_price p1_
    LEFT JOIN pm_carrier_price_delivery p2_ ON p1_.id = p2_.id
    LEFT JOIN pm_carrier_price_postman p3_ ON p1_.id = p3_.id
  ) ON (p0_.id = p1_.country_id)
WHERE
  p1_.discriminator IN ('carrierpricepostman')
  AND p1_.active = true
GROUP BY
  p0_.id

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.nameOrigin AS nameorigin_2, p0_.iso3 AS iso3_3, p0_.iso AS iso_4, p0_.vat AS vat_5, p0_.language_id AS language_id_6, p0_.currency_id AS currency_id_7 FROM pm_country p0_ INNER JOIN (pm_carrier_price p1_ LEFT JOIN pm_carrier_price_delivery p2_ ON p1_.id = p2_.id LEFT JOIN pm_carrier_price_postman p3_ ON p1_.id = p3_.id) ON (p0_.id = p1_.country_id) WHERE p1_.discriminator IN ('carrierpricepostman') AND p1_.active = true GROUP BY p0_.id;

"START TRANSACTION"

"START TRANSACTION";