Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 34
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 4
• Debug
• Messages
• E-mails
• Notifications
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.external_id AS external_id_4, t0.avg_restock_days AS avg_restock_days_5, t0.is_active AS is_active_6, t0.product_id AS product_id_7, t0.colour_id AS colour_id_8, t0.availability_id AS availability_id_9, t0.upload_id AS upload_id_10, t0.product_type_id AS product_type_id_11 FROM product_variant t0 WHERE t0.id = ?

[
  "321"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.stock AS stock_3,
  t0.external_id AS external_id_4,
  t0.avg_restock_days AS avg_restock_days_5,
  t0.is_active AS is_active_6,
  t0.product_id AS product_id_7,
  t0.colour_id AS colour_id_8,
  t0.availability_id AS availability_id_9,
  t0.upload_id AS upload_id_10,
  t0.product_type_id AS product_type_id_11
FROM
  product_variant t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.external_id AS external_id_4, t0.avg_restock_days AS avg_restock_days_5, t0.is_active AS is_active_6, t0.product_id AS product_id_7, t0.colour_id AS colour_id_8, t0.availability_id AS availability_id_9, t0.upload_id AS upload_id_10, t0.product_type_id AS product_type_id_11 FROM product_variant t0 WHERE t0.id = '321';

SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.vat AS vat_2, p0_.minimal_amount AS minimal_amount_3, p0_.discount AS discount_4, p0_.valid_from AS valid_from_5, p0_.valid_until AS valid_until_6, p0_.created AS created_7, p0_.is_package AS is_package_8, p0_.min_price AS min_price_9, p0_.product_variant_id AS product_variant_id_10, p0_.event_id AS event_id_11 FROM price p0_ WHERE p0_.product_variant_id = ? AND p0_.valid_from <= ? AND (p0_.valid_until >= ? OR p0_.valid_until IS NULL) ORDER BY p0_.minimal_amount ASC LIMIT 1

[
  321
  "2025-08-31 14:57:22"
  "2025-08-31 14:57:22"
]

SELECT
  p0_.id AS id_0,
  p0_.price AS price_1,
  p0_.vat AS vat_2,
  p0_.minimal_amount AS minimal_amount_3,
  p0_.discount AS discount_4,
  p0_.valid_from AS valid_from_5,
  p0_.valid_until AS valid_until_6,
  p0_.created AS created_7,
  p0_.is_package AS is_package_8,
  p0_.min_price AS min_price_9,
  p0_.product_variant_id AS product_variant_id_10,
  p0_.event_id AS event_id_11
FROM
  price p0_
WHERE
  p0_.product_variant_id = ?
  AND p0_.valid_from <= ?
  AND (
    p0_.valid_until >= ?
    OR p0_.valid_until IS NULL
  )
ORDER BY
  p0_.minimal_amount ASC
LIMIT
  1

SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.vat AS vat_2, p0_.minimal_amount AS minimal_amount_3, p0_.discount AS discount_4, p0_.valid_from AS valid_from_5, p0_.valid_until AS valid_until_6, p0_.created AS created_7, p0_.is_package AS is_package_8, p0_.min_price AS min_price_9, p0_.product_variant_id AS product_variant_id_10, p0_.event_id AS event_id_11 FROM price p0_ WHERE p0_.product_variant_id = 321 AND p0_.valid_from <= '2025-08-31 14:57:22' AND (p0_.valid_until >= '2025-08-31 14:57:22' OR p0_.valid_until IS NULL) ORDER BY p0_.minimal_amount ASC LIMIT 1;

SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.vat AS vat_2, p0_.minimal_amount AS minimal_amount_3, p0_.discount AS discount_4, p0_.valid_from AS valid_from_5, p0_.valid_until AS valid_until_6, p0_.created AS created_7, p0_.is_package AS is_package_8, p0_.min_price AS min_price_9, p0_.product_variant_id AS product_variant_id_10, p0_.event_id AS event_id_11 FROM price p0_ WHERE p0_.product_variant_id = ? AND p0_.valid_from <= ? AND (p0_.valid_until >= ? OR p0_.valid_until IS NULL) AND p0_.minimal_amount <= ? ORDER BY p0_.minimal_amount DESC, p0_.price ASC, p0_.discount DESC

[
  321
  "2025-08-31 14:57:22"
  "2025-08-31 14:57:22"
  1
]

SELECT
  p0_.id AS id_0,
  p0_.price AS price_1,
  p0_.vat AS vat_2,
  p0_.minimal_amount AS minimal_amount_3,
  p0_.discount AS discount_4,
  p0_.valid_from AS valid_from_5,
  p0_.valid_until AS valid_until_6,
  p0_.created AS created_7,
  p0_.is_package AS is_package_8,
  p0_.min_price AS min_price_9,
  p0_.product_variant_id AS product_variant_id_10,
  p0_.event_id AS event_id_11
FROM
  price p0_
WHERE
  p0_.product_variant_id = ?
  AND p0_.valid_from <= ?
  AND (
    p0_.valid_until >= ?
    OR p0_.valid_until IS NULL
  )
  AND p0_.minimal_amount <= ?
ORDER BY
  p0_.minimal_amount DESC,
  p0_.price ASC,
  p0_.discount DESC

SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.vat AS vat_2, p0_.minimal_amount AS minimal_amount_3, p0_.discount AS discount_4, p0_.valid_from AS valid_from_5, p0_.valid_until AS valid_until_6, p0_.created AS created_7, p0_.is_package AS is_package_8, p0_.min_price AS min_price_9, p0_.product_variant_id AS product_variant_id_10, p0_.event_id AS event_id_11 FROM price p0_ WHERE p0_.product_variant_id = 321 AND p0_.valid_from <= '2025-08-31 14:57:22' AND (p0_.valid_until >= '2025-08-31 14:57:22' OR p0_.valid_until IS NULL) AND p0_.minimal_amount <= 1 ORDER BY p0_.minimal_amount DESC, p0_.price ASC, p0_.discount DESC;