Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

77.67 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.99 ms

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

Parameters:

[
  32753
]

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 593)
2	Doctrine\DBAL\Connection->fetchAssociative (line 1051)
3	App\Controller\intercars\api\ProductSearchController->fetchVehicleById (line 130)
4	App\Controller\intercars\api\ProductSearchController->searchByVehicle (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

3.76 ms

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 ?

Parameters:

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

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 1029)
3	App\Controller\intercars\api\ProductSearchController->findBaseProductsByVehicle (line 143)
4	App\Controller\intercars\api\ProductSearchController->searchByVehicle (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

72.23 ms

SELECT inter_cars_reference_id AS ref_id, name, value
                 FROM inter_cars_product_attributes
                 WHERE enabled = 1 AND inter_cars_reference_id IN (?, ?, ?, ?, ?, ?)
                 ORDER BY id ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  inter_cars_reference_id AS ref_id,
  name,
  value
FROM
  inter_cars_product_attributes
WHERE
  enabled = 1
  AND inter_cars_reference_id IN (?, ?, ?, ?, ?, ?)
ORDER BY
  id ASC

SELECT inter_cars_reference_id AS ref_id, name, value
                 FROM inter_cars_product_attributes
                 WHERE enabled = 1 AND inter_cars_reference_id IN (62728, 5098, 244973, 7184, 578565, 241883)
                 ORDER BY id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 1183)
3	App\Controller\intercars\api\ProductSearchController->fetchAttributesByRefIds (line 523)
4	App\Controller\intercars\api\ProductSearchController->buildSearchResponse (line 157)
5	App\Controller\intercars\api\ProductSearchController->searchByVehicle (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.69 ms

SELECT
    rr.reference_id AS base_id,
    r.id,
    r.supplier_number,
    r.catalog_number,
    r.catalog_number2 AS catalog_number2,
    r.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_references_replacements rr
JOIN inter_cars_references_csv r ON r.id = rr.replacement_reference_id
WHERE rr.enabled = 1
  AND rr.reference_id IN (?, ?, ?, ?, ?, ?)
  AND r.enabled = 1
ORDER BY rr.id ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  rr.reference_id AS base_id,
  r.id,
  r.supplier_number,
  r.catalog_number,
  r.catalog_number2 AS catalog_number2,
  r.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_references_replacements rr
  JOIN inter_cars_references_csv r ON r.id = rr.replacement_reference_id
WHERE
  rr.enabled = 1
  AND rr.reference_id IN (?, ?, ?, ?, ?, ?)
  AND r.enabled = 1
ORDER BY
  rr.id ASC

SELECT
    rr.reference_id AS base_id,
    r.id,
    r.supplier_number,
    r.catalog_number,
    r.catalog_number2 AS catalog_number2,
    r.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_references_replacements rr
JOIN inter_cars_references_csv r ON r.id = rr.replacement_reference_id
WHERE rr.enabled = 1
  AND rr.reference_id IN (62728, 5098, 244973, 7184, 578565, 241883)
  AND r.enabled = 1
ORDER BY rr.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 1255)
3	App\Controller\intercars\api\ProductSearchController->fetchReplacementsByRefIds (line 524)
4	App\Controller\intercars\api\ProductSearchController->buildSearchResponse (line 157)
5	App\Controller\intercars\api\ProductSearchController->searchByVehicle (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects

Entities Mapping

No loaded entities.

Symfony Profiler

GET https://e-commerce.motoer.synology.me/api/ic/products/search-by-vehicle?limit=8&q=usz%20kor&source=ic&vehicle_id=32753

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping