Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

32.30 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

30.62 ms

SELECT et.*, COALESCE(ts.code, CASE
            WHEN LOWER(CONCAT_WS(' ', et.commercial_name, et.model_identifier, et.tyre_designation)) REGEXP 'all[[:space:]]*season|allseason|4[[:space:]]*season|4season|[[:<:]]as[[:>:]]|calorocz|ca[łl]orocz|wielosezon' THEN 'allseason'
            WHEN et.ice_tyre = 1 OR et.severe_snow_tyre = 1 THEN 'winter'
            ELSE 'summer'
        END) AS season_code
             FROM eprel_tyres et
             LEFT JOIN tyre_products tp ON tp.eprel_registration_number = et.eprel_registration_number
             LEFT JOIN tyre_seasons ts ON ts.id = tp.season_id
             WHERE et.eprel_registration_number = ?
             LIMIT 1

Parameters:

[
  "508495"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  et.*,
  COALESCE(
    ts.code,
    CASE WHEN LOWER(
      CONCAT_WS(
        ' ', et.commercial_name, et.model_identifier,
        et.tyre_designation
      )
    ) REGEXP 'all[[:space:]]*season|allseason|4[[:space:]]*season|4season|[[:<:]]as[[:>:]]|calorocz|ca[łl]orocz|wielosezon' THEN
      'allseason'
    WHEN et.ice_tyre = 1
    OR et.severe_snow_tyre = 1 THEN
      'winter'
    ELSE
      'summer'
    END
  ) AS season_code
FROM
  eprel_tyres et
  LEFT JOIN tyre_products tp ON tp.eprel_registration_number = et.eprel_registration_number
  LEFT JOIN tyre_seasons ts ON ts.id = tp.season_id
WHERE
  et.eprel_registration_number = ?
LIMIT
  1

SELECT et.*, COALESCE(ts.code, CASE
            WHEN LOWER(CONCAT_WS(' ', et.commercial_name, et.model_identifier, et.tyre_designation)) REGEXP 'all[['508495':]]*season|allseason|4[[:space:]]*season|4season|[[:<:]]as[[:>:]]|calorocz|ca[łl]orocz|wielosezon' THEN 'allseason'
            WHEN et.ice_tyre = 1 OR et.severe_snow_tyre = 1 THEN 'winter'
            ELSE 'summer'
        END) AS season_code
             FROM eprel_tyres et
             LEFT JOIN tyre_products tp ON tp.eprel_registration_number = et.eprel_registration_number
             LEFT JOIN tyre_seasons ts ON ts.id = tp.season_id
             WHERE et.eprel_registration_number = ?
             LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAssociative (line 593)
2	App\Service\EprelTyreLookupService->findDetailByEprelRegistrationNumber (line 89)
3	App\Controller\Api\EprelTyreLookupController->detail (line 59)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 208)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	require_once (line 5)

0.63 ms

SELECT
                lp.id AS latex_product_id,
                lp.supplier_index,
                lp.product_code,
                lp.name AS product_name,
                lp.manufacturer,
                lp.tread_name,
                lp.width,
                lp.profile,
                lp.diameter,
                lp.load_index,
                lp.speed_index,
                lp.enabled,
                lp.qty_reported,
                ph.id AS photo_id,
                ph.file_name,
                ph.remote_path,
                ph.local_path,
                ph.sort_order,
                ph.is_primary,
                ph.source
             FROM latex_products lp
             INNER JOIN latex_product_photos ph ON ph.product_id = lp.id
             WHERE lp.eprel_code = ?
               AND ph.local_path IS NOT NULL
               AND ph.local_path <> ''
             ORDER BY lp.enabled DESC, lp.qty_reported DESC, lp.id ASC, ph.is_primary DESC, ph.sort_order ASC, ph.id ASC

Parameters:

[
  "508495"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  lp.id AS latex_product_id,
  lp.supplier_index,
  lp.product_code,
  lp.name AS product_name,
  lp.manufacturer,
  lp.tread_name,
  lp.width,
  lp.profile,
  lp.diameter,
  lp.load_index,
  lp.speed_index,
  lp.enabled,
  lp.qty_reported,
  ph.id AS photo_id,
  ph.file_name,
  ph.remote_path,
  ph.local_path,
  ph.sort_order,
  ph.is_primary,
  ph.source
FROM
  latex_products lp
  INNER JOIN latex_product_photos ph ON ph.product_id = lp.id
WHERE
  lp.eprel_code = ?
  AND ph.local_path IS NOT NULL
  AND ph.local_path <> ''
ORDER BY
  lp.enabled DESC,
  lp.qty_reported DESC,
  lp.id ASC,
  ph.is_primary DESC,
  ph.sort_order ASC,
  ph.id ASC

SELECT
                lp.id AS latex_product_id,
                lp.supplier_index,
                lp.product_code,
                lp.name AS product_name,
                lp.manufacturer,
                lp.tread_name,
                lp.width,
                lp.profile,
                lp.diameter,
                lp.load_index,
                lp.speed_index,
                lp.enabled,
                lp.qty_reported,
                ph.id AS photo_id,
                ph.file_name,
                ph.remote_path,
                ph.local_path,
                ph.sort_order,
                ph.is_primary,
                ph.source
             FROM latex_products lp
             INNER JOIN latex_product_photos ph ON ph.product_id = lp.id
             WHERE lp.eprel_code = '508495'
               AND ph.local_path IS NOT NULL
               AND ph.local_path <> ''
             ORDER BY lp.enabled DESC, lp.qty_reported DESC, lp.id ASC, ph.is_primary DESC, ph.sort_order ASC, ph.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 907)
2	App\Service\EprelTyreLookupService->fetchLatexPhotosForErn (line 841)
3	App\Service\EprelTyreLookupService->fetchPhotosForErn (line 831)
4	App\Service\EprelTyreLookupService->findDetailByEprelRegistrationNumber (line 103)
5	App\Controller\Api\EprelTyreLookupController->detail (line 59)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 208)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

1.05 ms

SELECT
                icp.id AS inter_cars_product_id,
                icp.supplier_index,
                icp.catalog_index,
                icp.article_number,
                icp.tec_doc_number,
                icp.brand,
                icp.short_description AS product_name,
                icp.description,
                icp.enabled,
                icp.quote_status,
                ph.id AS photo_id,
                ph.file_name,
                ph.remote_path,
                ph.local_path,
                ph.sort_order,
                ph.is_primary,
                ph.source
             FROM eprel_tyres et
             INNER JOIN inter_cars_products icp ON icp.eprel_tyre_id = et.id
             INNER JOIN inter_cars_product_photos ph ON ph.product_id = icp.id
             WHERE et.eprel_registration_number = ?
               AND ph.local_path IS NOT NULL
               AND ph.local_path <> ''
             ORDER BY icp.enabled DESC, icp.id ASC, ph.is_primary DESC, ph.sort_order ASC, ph.id ASC

Parameters:

[
  "508495"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  icp.id AS inter_cars_product_id,
  icp.supplier_index,
  icp.catalog_index,
  icp.article_number,
  icp.tec_doc_number,
  icp.brand,
  icp.short_description AS product_name,
  icp.description,
  icp.enabled,
  icp.quote_status,
  ph.id AS photo_id,
  ph.file_name,
  ph.remote_path,
  ph.local_path,
  ph.sort_order,
  ph.is_primary,
  ph.source
FROM
  eprel_tyres et
  INNER JOIN inter_cars_products icp ON icp.eprel_tyre_id = et.id
  INNER JOIN inter_cars_product_photos ph ON ph.product_id = icp.id
WHERE
  et.eprel_registration_number = ?
  AND ph.local_path IS NOT NULL
  AND ph.local_path <> ''
ORDER BY
  icp.enabled DESC,
  icp.id ASC,
  ph.is_primary DESC,
  ph.sort_order ASC,
  ph.id ASC

SELECT
                icp.id AS inter_cars_product_id,
                icp.supplier_index,
                icp.catalog_index,
                icp.article_number,
                icp.tec_doc_number,
                icp.brand,
                icp.short_description AS product_name,
                icp.description,
                icp.enabled,
                icp.quote_status,
                ph.id AS photo_id,
                ph.file_name,
                ph.remote_path,
                ph.local_path,
                ph.sort_order,
                ph.is_primary,
                ph.source
             FROM eprel_tyres et
             INNER JOIN inter_cars_products icp ON icp.eprel_tyre_id = et.id
             INNER JOIN inter_cars_product_photos ph ON ph.product_id = icp.id
             WHERE et.eprel_registration_number = '508495'
               AND ph.local_path IS NOT NULL
               AND ph.local_path <> ''
             ORDER BY icp.enabled DESC, icp.id ASC, ph.is_primary DESC, ph.sort_order ASC, ph.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 907)
2	App\Service\EprelTyreLookupService->fetchInterCarsPhotosForErn (line 914)
3	App\Service\EprelTyreLookupService->fetchPhotosForErn (line 832)
4	App\Service\EprelTyreLookupService->findDetailByEprelRegistrationNumber (line 103)
5	App\Controller\Api\EprelTyreLookupController->detail (line 59)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 208)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	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://pewneopony.pl/api/eprel/tyres/508495

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping