Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 110
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT
    r.id,
    r.item_number,
    r.catalog_number,
    r.catalog_number2,
    r.supplier_number,
    r.name_manufacturer,
    r.name,
    r.ean,
    r.enabled
FROM inter_cars_references_csv r
WHERE r.enabled = 1
  AND UPPER(r.item_number) IN (?)
ORDER BY r.enabled DESC, r.id DESC

[
  "H0AAA2"
]

SELECT
  r.id,
  r.item_number,
  r.catalog_number,
  r.catalog_number2,
  r.supplier_number,
  r.name_manufacturer,
  r.name,
  r.ean,
  r.enabled
FROM
  inter_cars_references_csv r
WHERE
  r.enabled = 1
  AND UPPER(r.item_number) IN (?)
ORDER BY
  r.enabled DESC,
  r.id DESC

SELECT
    r.id,
    r.item_number,
    r.catalog_number,
    r.catalog_number2,
    r.supplier_number,
    r.name_manufacturer,
    r.name,
    r.ean,
    r.enabled
FROM inter_cars_references_csv r
WHERE r.enabled = 1
  AND UPPER(r.item_number) IN ('H0AAA2')
ORDER BY r.enabled DESC, r.id DESC;

SELECT
    r.id,
    r.item_number,
    r.catalog_number,
    r.catalog_number2,
    r.supplier_number,
    r.name_manufacturer,
    r.name,
    r.ean,
    r.enabled
FROM inter_cars_references_csv r
WHERE r.enabled = 1
  AND (
      UPPER(COALESCE(r.supplier_number, '')) IN (?)
      OR UPPER(COALESCE(r.catalog_number, '')) IN (?)
      OR UPPER(COALESCE(r.catalog_number2, '')) IN (?)
  )
ORDER BY r.enabled DESC, r.id DESC

[
  "6PG013 114-411"
  "6PG013 114-411"
  "6PG013 114-411"
]

SELECT
  r.id,
  r.item_number,
  r.catalog_number,
  r.catalog_number2,
  r.supplier_number,
  r.name_manufacturer,
  r.name,
  r.ean,
  r.enabled
FROM
  inter_cars_references_csv r
WHERE
  r.enabled = 1
  AND (
    UPPER(
      COALESCE(r.supplier_number, '')
    ) IN (?)
    OR UPPER(
      COALESCE(r.catalog_number, '')
    ) IN (?)
    OR UPPER(
      COALESCE(r.catalog_number2, '')
    ) IN (?)
  )
ORDER BY
  r.enabled DESC,
  r.id DESC

SELECT
    r.id,
    r.item_number,
    r.catalog_number,
    r.catalog_number2,
    r.supplier_number,
    r.name_manufacturer,
    r.name,
    r.ean,
    r.enabled
FROM inter_cars_references_csv r
WHERE r.enabled = 1
  AND (
      UPPER(COALESCE(r.supplier_number, '')) IN ('6PG013 114-411')
      OR UPPER(COALESCE(r.catalog_number, '')) IN ('6PG013 114-411')
      OR UPPER(COALESCE(r.catalog_number2, '')) IN ('6PG013 114-411')
  )
ORDER BY r.enabled DESC, r.id DESC;