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 id, tecdoc_id, brand, model, variant, engine_codes, production_start, production_end, body_type, drive_type, power_kw, power_hp, engine_capacity_cc, fuel_type
             FROM auto_partner_vehicles_tecdoc
             WHERE id = ?
             LIMIT 1

[
  32753
]

SELECT
  id,
  tecdoc_id,
  brand,
  model,
  variant,
  engine_codes,
  production_start,
  production_end,
  body_type,
  drive_type,
  power_kw,
  power_hp,
  engine_capacity_cc,
  fuel_type
FROM
  auto_partner_vehicles_tecdoc
WHERE
  id = ?
LIMIT
  1

SELECT id, tecdoc_id, brand, model, variant, engine_codes, production_start, production_end, body_type, drive_type, power_kw, power_hp, engine_capacity_cc, fuel_type
             FROM auto_partner_vehicles_tecdoc
             WHERE id = 32753
             LIMIT 1;

SELECT DISTINCT
    r.id,
    r.supplier_number,
    r.catalog_number,
    r.catalog_number2 AS catalog_number2,
    r.item_number AS item_number,
    r.name_manufacturer,
    r.ean,
    r.dlnr,
    r.name,
    r.short_name AS short_name,
    r.photo_exists,
    r.api_connection,
    r.enabled,
    r.central_stock,
    r.branch_stock,
    r.net_purchase_price,
    r.last_price_update
FROM inter_cars_reference_vehicles rv
JOIN inter_cars_references_csv r ON r.id = rv.reference_id
WHERE
    rv.vehicle_id = ?
    AND r.enabled = 1
    AND (
        r.name LIKE ?
        OR COALESCE(r.short_name, '') LIKE ?
        OR COALESCE(r.catalog_number2, '') LIKE ?
        OR COALESCE(r.item_number, '') LIKE ?
        OR COALESCE(r.supplier_number, '') LIKE ?
        OR (
            ? = 1
            AND (
                r.name LIKE ?
                OR COALESCE(r.short_name, '') LIKE ?
                OR COALESCE(r.catalog_number2, '') LIKE ?
                OR COALESCE(r.item_number, '') LIKE ?
                OR COALESCE(r.supplier_number, '') LIKE ?
            )
        )
    )
ORDER BY
    CASE
        WHEN COALESCE(r.item_number, '') LIKE ? THEN 0
        WHEN COALESCE(r.catalog_number2, '') LIKE ? THEN 1
        WHEN COALESCE(r.supplier_number, '') LIKE ? THEN 2
        WHEN r.name LIKE ? THEN 3
        WHEN COALESCE(r.short_name, '') LIKE ? THEN 4
        ELSE 5
    END ASC,
    r.api_connection DESC,
    r.last_price_update DESC,
    r.id DESC
LIMIT ?

[
  32753
  "usz%"
  "usz%"
  "usz%"
  "usz%"
  "usz%"
  1
  "%usz%"
  "%usz%"
  "%usz%"
  "%usz%"
  "%usz%"
  "usz%"
  "usz%"
  "usz%"
  "usz%"
  "usz%"
  120
]

SELECT
  DISTINCT r.id,
  r.supplier_number,
  r.catalog_number,
  r.catalog_number2 AS catalog_number2,
  r.item_number AS item_number,
  r.name_manufacturer,
  r.ean,
  r.dlnr,
  r.name,
  r.short_name AS short_name,
  r.photo_exists,
  r.api_connection,
  r.enabled,
  r.central_stock,
  r.branch_stock,
  r.net_purchase_price,
  r.last_price_update
FROM
  inter_cars_reference_vehicles rv
  JOIN inter_cars_references_csv r ON r.id = rv.reference_id
WHERE
  rv.vehicle_id = ?
  AND r.enabled = 1
  AND (
    r.name LIKE ?
    OR COALESCE(r.short_name, '') LIKE ?
    OR COALESCE(r.catalog_number2, '') LIKE ?
    OR COALESCE(r.item_number, '') LIKE ?
    OR COALESCE(r.supplier_number, '') LIKE ?
    OR (
      ? = 1
      AND (
        r.name LIKE ?
        OR COALESCE(r.short_name, '') LIKE ?
        OR COALESCE(r.catalog_number2, '') LIKE ?
        OR COALESCE(r.item_number, '') LIKE ?
        OR COALESCE(r.supplier_number, '') LIKE ?
      )
    )
  )
ORDER BY
  CASE WHEN COALESCE(r.item_number, '') LIKE ? THEN
    0
  WHEN COALESCE(r.catalog_number2, '') LIKE ? THEN
    1
  WHEN COALESCE(r.supplier_number, '') LIKE ? THEN
    2
  WHEN r.name LIKE ? THEN
    3
  WHEN COALESCE(r.short_name, '') LIKE ? THEN
    4
  ELSE
    5
  END ASC,
  r.api_connection DESC,
  r.last_price_update DESC,
  r.id DESC
LIMIT
  ?

SELECT DISTINCT
    r.id,
    r.supplier_number,
    r.catalog_number,
    r.catalog_number2 AS catalog_number2,
    r.item_number AS item_number,
    r.name_manufacturer,
    r.ean,
    r.dlnr,
    r.name,
    r.short_name AS short_name,
    r.photo_exists,
    r.api_connection,
    r.enabled,
    r.central_stock,
    r.branch_stock,
    r.net_purchase_price,
    r.last_price_update
FROM inter_cars_reference_vehicles rv
JOIN inter_cars_references_csv r ON r.id = rv.reference_id
WHERE
    rv.vehicle_id = 32753
    AND r.enabled = 1
    AND (
        r.name LIKE 'usz%'
        OR COALESCE(r.short_name, '') LIKE 'usz%'
        OR COALESCE(r.catalog_number2, '') LIKE 'usz%'
        OR COALESCE(r.item_number, '') LIKE 'usz%'
        OR COALESCE(r.supplier_number, '') LIKE 'usz%'
        OR (
            1 = 1
            AND (
                r.name LIKE '%usz%'
                OR COALESCE(r.short_name, '') LIKE '%usz%'
                OR COALESCE(r.catalog_number2, '') LIKE '%usz%'
                OR COALESCE(r.item_number, '') LIKE '%usz%'
                OR COALESCE(r.supplier_number, '') LIKE '%usz%'
            )
        )
    )
ORDER BY
    CASE
        WHEN COALESCE(r.item_number, '') LIKE 'usz%' THEN 0
        WHEN COALESCE(r.catalog_number2, '') LIKE 'usz%' THEN 1
        WHEN COALESCE(r.supplier_number, '') LIKE 'usz%' THEN 2
        WHEN r.name LIKE 'usz%' THEN 3
        WHEN COALESCE(r.short_name, '') LIKE 'usz%' THEN 4
        ELSE 5
    END ASC,
    r.api_connection DESC,
    r.last_price_update DESC,
    r.id DESC
LIMIT 120;