Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

2.46 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.50 ms
(20.21%)

SELECT
                ss.code,
                ss.name,
                ss.slug,
                NULL AS total
             FROM tyre_products p
             INNER JOIN tyre_seasons ss ON ss.id = p.season_id
             INNER JOIN tyre_brands b ON b.id = p.brand_id
             INNER JOIN tyre_size_groups g ON g.id = p.size_group_id
             WHERE p.is_active = 1 AND p.size_group_id = ?
             GROUP BY ss.id, ss.code, ss.name, ss.slug
             ORDER BY CASE ss.code
                WHEN 'summer' THEN 1
                WHEN 'winter' THEN 2
                WHEN 'allseason' THEN 3
                ELSE 4
             END, ss.name ASC

Parameters:

[
  1925
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  ss.code,
  ss.name,
  ss.slug,
  NULL AS total
FROM
  tyre_products p
  INNER JOIN tyre_seasons ss ON ss.id = p.season_id
  INNER JOIN tyre_brands b ON b.id = p.brand_id
  INNER JOIN tyre_size_groups g ON g.id = p.size_group_id
WHERE
  p.is_active = 1
  AND p.size_group_id = ?
GROUP BY
  ss.id,
  ss.code,
  ss.name,
  ss.slug
ORDER BY
  CASE ss.code
  WHEN 'summer' THEN
    1
  WHEN 'winter' THEN
    2
  WHEN 'allseason' THEN
    3
  ELSE
    4
  END,
  ss.name ASC

SELECT
                ss.code,
                ss.name,
                ss.slug,
                NULL AS total
             FROM tyre_products p
             INNER JOIN tyre_seasons ss ON ss.id = p.season_id
             INNER JOIN tyre_brands b ON b.id = p.brand_id
             INNER JOIN tyre_size_groups g ON g.id = p.size_group_id
             WHERE p.is_active = 1 AND p.size_group_id = 1925
             GROUP BY ss.id, ss.code, ss.name, ss.slug
             ORDER BY CASE ss.code
                WHEN 'summer' THEN 1
                WHEN 'winter' THEN 2
                WHEN 'allseason' THEN 3
                ELSE 4
             END, ss.name ASC;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 907)
2	App\Controller\TyreCatalogController->fetchSeasons (line 157)
3	App\Controller\TyreCatalogController->size (line 129)
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.49 ms
(19.84%)

SELECT
                p.eprel_registration_number,
                p.commercial_name,
                p.model_identifier,
                p.load_index,
                p.speed_index,
                p.energy_class,
                p.wet_grip_class,
                p.noise_value,
                p.noise_class,
                p.is_xl,
                p.is_runflat,
                b.name AS brand_name,
                b.slug AS brand_slug,
                COALESCE(s.name, p.commercial_name, p.model_identifier) AS series_name,
                COALESCE(s.slug, ?) AS series_slug,
                g.label AS size_label,
                g.slug AS size_slug,
                ss.name AS season_name,
                ss.slug AS season_slug
             FROM tyre_products p
             INNER JOIN tyre_brands b ON b.id = p.brand_id
             LEFT JOIN tyre_series s ON s.id = p.series_id
             INNER JOIN tyre_size_groups g ON g.id = p.size_group_id
             INNER JOIN tyre_seasons ss ON ss.id = p.season_id
             WHERE p.is_active = 1 AND p.size_group_id = ? AND ss.slug = ?
             ORDER BY p.id DESC
             LIMIT ?

Parameters:

[
  "unknown"
  1925
  "zimowe"
  72
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p.eprel_registration_number,
  p.commercial_name,
  p.model_identifier,
  p.load_index,
  p.speed_index,
  p.energy_class,
  p.wet_grip_class,
  p.noise_value,
  p.noise_class,
  p.is_xl,
  p.is_runflat,
  b.name AS brand_name,
  b.slug AS brand_slug,
  COALESCE(
    s.name, p.commercial_name, p.model_identifier
  ) AS series_name,
  COALESCE(s.slug, ?) AS series_slug,
  g.label AS size_label,
  g.slug AS size_slug,
  ss.name AS season_name,
  ss.slug AS season_slug
FROM
  tyre_products p
  INNER JOIN tyre_brands b ON b.id = p.brand_id
  LEFT JOIN tyre_series s ON s.id = p.series_id
  INNER JOIN tyre_size_groups g ON g.id = p.size_group_id
  INNER JOIN tyre_seasons ss ON ss.id = p.season_id
WHERE
  p.is_active = 1
  AND p.size_group_id = ?
  AND ss.slug = ?
ORDER BY
  p.id DESC
LIMIT
  ?

SELECT
                p.eprel_registration_number,
                p.commercial_name,
                p.model_identifier,
                p.load_index,
                p.speed_index,
                p.energy_class,
                p.wet_grip_class,
                p.noise_value,
                p.noise_class,
                p.is_xl,
                p.is_runflat,
                b.name AS brand_name,
                b.slug AS brand_slug,
                COALESCE(s.name, p.commercial_name, p.model_identifier) AS series_name,
                COALESCE(s.slug, 'unknown') AS series_slug,
                g.label AS size_label,
                g.slug AS size_slug,
                ss.name AS season_name,
                ss.slug AS season_slug
             FROM tyre_products p
             INNER JOIN tyre_brands b ON b.id = p.brand_id
             LEFT JOIN tyre_series s ON s.id = p.series_id
             INNER JOIN tyre_size_groups g ON g.id = p.size_group_id
             INNER JOIN tyre_seasons ss ON ss.id = p.season_id
             WHERE p.is_active = 1 AND p.size_group_id = 1925 AND ss.slug = 'zimowe'
             ORDER BY p.id DESC
             LIMIT 72;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 907)
2	App\Controller\TyreCatalogController->fetchProducts (line 262)
3	App\Controller\TyreCatalogController->size (line 131)
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.39 ms
(15.97%)

SELECT
                et.eprel_registration_number AS ern,
                ph.file_name,
                ph.local_path,
                ph.sort_order,
                ph.is_primary,
                'intercars' AS 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 IN (?)
               AND ph.local_path IS NOT NULL
               AND ph.local_path <> ''
             ORDER BY et.eprel_registration_number ASC, ph.is_primary DESC, ph.sort_order ASC, ph.id ASC

Parameters:

[
  "669690"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  et.eprel_registration_number AS ern,
  ph.file_name,
  ph.local_path,
  ph.sort_order,
  ph.is_primary,
  'intercars' AS 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 IN (?)
  AND ph.local_path IS NOT NULL
  AND ph.local_path <> ''
ORDER BY
  et.eprel_registration_number ASC,
  ph.is_primary DESC,
  ph.sort_order ASC,
  ph.id ASC

SELECT
                et.eprel_registration_number AS ern,
                ph.file_name,
                ph.local_path,
                ph.sort_order,
                ph.is_primary,
                'intercars' AS 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 IN ('669690')
               AND ph.local_path IS NOT NULL
               AND ph.local_path <> ''
             ORDER BY et.eprel_registration_number ASC, ph.is_primary DESC, ph.sort_order ASC, ph.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 907)
2	App\Service\TyreProductPhotoResolver->fetchInterCarsPhotos (line 166)
3	App\Service\TyreProductPhotoResolver->primaryPhotosByErn (line 63)
4	App\Service\TyreProductPhotoResolver->addPrimaryPhotos (line 33)
5	App\Controller\TyreCatalogController->fetchProducts (line 295)
6	App\Controller\TyreCatalogController->size (line 131)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 208)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.38 ms
(15.36%)

SELECT id, label, slug, width, profile, diameter
             FROM tyre_size_groups
             WHERE slug = ?
             LIMIT 1

Parameters:

[
  "185-65-r13"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id,
  label,
  slug,
  width,
  profile,
  diameter
FROM
  tyre_size_groups
WHERE
  slug = ?
LIMIT
  1

SELECT id, label, slug, width, profile, diameter
             FROM tyre_size_groups
             WHERE slug = '185-65-r13'
             LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAssociative (line 593)
2	App\Controller\TyreCatalogController->size (line 102)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
5	Symfony\Component\HttpKernel\Kernel->handle (line 208)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
7	require_once (line 29)
8	require_once (line 5)

0.36 ms
(14.52%)

SELECT
                b.name,
                b.slug,
                NULL AS total
             FROM tyre_products p
             INNER JOIN tyre_brands b ON b.id = p.brand_id
             INNER JOIN tyre_seasons ss ON ss.id = p.season_id
             INNER JOIN tyre_size_groups g ON g.id = p.size_group_id
             WHERE p.is_active = 1 AND p.size_group_id = ?
             GROUP BY b.id, b.name, b.slug
             ORDER BY b.name ASC
             LIMIT ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  b.name,
  b.slug,
  NULL AS total
FROM
  tyre_products p
  INNER JOIN tyre_brands b ON b.id = p.brand_id
  INNER JOIN tyre_seasons ss ON ss.id = p.season_id
  INNER JOIN tyre_size_groups g ON g.id = p.size_group_id
WHERE
  p.is_active = 1
  AND p.size_group_id = ?
GROUP BY
  b.id,
  b.name,
  b.slug
ORDER BY
  b.name ASC
LIMIT
  ?

SELECT
                b.name,
                b.slug,
                NULL AS total
             FROM tyre_products p
             INNER JOIN tyre_brands b ON b.id = p.brand_id
             INNER JOIN tyre_seasons ss ON ss.id = p.season_id
             INNER JOIN tyre_size_groups g ON g.id = p.size_group_id
             WHERE p.is_active = 1 AND p.size_group_id = 1925
             GROUP BY b.id, b.name, b.slug
             ORDER BY b.name ASC
             LIMIT 24;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 907)
2	App\Controller\TyreCatalogController->fetchBrands (line 197)
3	App\Controller\TyreCatalogController->size (line 130)
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.35 ms
(14.11%)

SELECT
                lp.eprel_code AS ern,
                ph.file_name,
                ph.local_path,
                ph.sort_order,
                ph.is_primary,
                'latex' AS source
             FROM latex_products lp
             INNER JOIN latex_product_photos ph ON ph.product_id = lp.id
             WHERE lp.eprel_code IN (?)
               AND ph.local_path IS NOT NULL
               AND ph.local_path <> ''
             ORDER BY lp.eprel_code ASC, ph.is_primary DESC, ph.sort_order ASC, ph.id ASC

Parameters:

[
  "669690"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  lp.eprel_code AS ern,
  ph.file_name,
  ph.local_path,
  ph.sort_order,
  ph.is_primary,
  'latex' AS source
FROM
  latex_products lp
  INNER JOIN latex_product_photos ph ON ph.product_id = lp.id
WHERE
  lp.eprel_code IN (?)
  AND ph.local_path IS NOT NULL
  AND ph.local_path <> ''
ORDER BY
  lp.eprel_code ASC,
  ph.is_primary DESC,
  ph.sort_order ASC,
  ph.id ASC

SELECT
                lp.eprel_code AS ern,
                ph.file_name,
                ph.local_path,
                ph.sort_order,
                ph.is_primary,
                'latex' AS source
             FROM latex_products lp
             INNER JOIN latex_product_photos ph ON ph.product_id = lp.id
             WHERE lp.eprel_code IN ('669690')
               AND ph.local_path IS NOT NULL
               AND ph.local_path <> ''
             ORDER BY lp.eprel_code ASC, ph.is_primary DESC, ph.sort_order ASC, ph.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 907)
2	App\Service\TyreProductPhotoResolver->fetchLatexPhotos (line 139)
3	App\Service\TyreProductPhotoResolver->primaryPhotosByErn (line 56)
4	App\Service\TyreProductPhotoResolver->addPrimaryPhotos (line 33)
5	App\Controller\TyreCatalogController->fetchProducts (line 295)
6	App\Controller\TyreCatalogController->size (line 131)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 208)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	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/rozmiary/185-65-r13?season=zimowe

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping