Symfony Profiler

Query Metrics

49 Database Queries

12 Different statements

23.91 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

11.40 ms
(47.67%)

SELECT
                        p.eprel_registration_number,
                        COALESCE(s.slug, ?) AS series_slug
                     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
                     LEFT JOIN tyre_series s ON s.id = p.series_id
                     WHERE b.slug = ?
                       AND ss.code = ?
                       AND s.slug = ?
                       AND p.is_active = 1
                     ORDER BY p.updated_at DESC, p.id DESC
                     LIMIT 1

Parameters:

[
  "unknown"
  "chengshan-csr71"
  "summer"
  "2100-9165012071"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p.eprel_registration_number,
  COALESCE(s.slug, ?) AS series_slug
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
  LEFT JOIN tyre_series s ON s.id = p.series_id
WHERE
  b.slug = ?
  AND ss.code = ?
  AND s.slug = ?
  AND p.is_active = 1
ORDER BY
  p.updated_at DESC,
  p.id DESC
LIMIT
  1

SELECT
                        p.eprel_registration_number,
                        COALESCE(s.slug, 'unknown') AS series_slug
                     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
                     LEFT JOIN tyre_series s ON s.id = p.series_id
                     WHERE b.slug = 'chengshan-csr71'
                       AND ss.code = 'summer'
                       AND s.slug = '2100-9165012071'
                       AND p.is_active = 1
                     ORDER BY p.updated_at DESC, p.id DESC
                     LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAssociative (line 593)
2	App\Controller\TyreBrandController->show (line 152)
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)

5.33 ms
(22.30%)

SELECT
                    p.eprel_registration_number,
                    COALESCE(ts.slug, ?) AS series_slug
                 FROM tyre_products p
                 INNER JOIN tyre_brands b ON b.id = p.brand_id
                 INNER JOIN tyre_size_groups g ON g.id = p.size_group_id
                 LEFT JOIN tyre_series ts ON ts.id = p.series_id
                 WHERE b.slug = ?
                   AND g.slug = ?
                   AND p.is_active = 1
                 ORDER BY p.updated_at DESC, p.id DESC
                 LIMIT 1

Parameters:

[
  "unknown"
  "chengshan-csr71"
  "195-70-r15"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p.eprel_registration_number,
  COALESCE(ts.slug, ?) AS series_slug
FROM
  tyre_products p
  INNER JOIN tyre_brands b ON b.id = p.brand_id
  INNER JOIN tyre_size_groups g ON g.id = p.size_group_id
  LEFT JOIN tyre_series ts ON ts.id = p.series_id
WHERE
  b.slug = ?
  AND g.slug = ?
  AND p.is_active = 1
ORDER BY
  p.updated_at DESC,
  p.id DESC
LIMIT
  1

SELECT
                    p.eprel_registration_number,
                    COALESCE(ts.slug, 'unknown') AS series_slug
                 FROM tyre_products p
                 INNER JOIN tyre_brands b ON b.id = p.brand_id
                 INNER JOIN tyre_size_groups g ON g.id = p.size_group_id
                 LEFT JOIN tyre_series ts ON ts.id = p.series_id
                 WHERE b.slug = 'chengshan-csr71'
                   AND g.slug = '195-70-r15'
                   AND p.is_active = 1
                 ORDER BY p.updated_at DESC, p.id DESC
                 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAssociative (line 593)
2	App\Controller\TyreBrandController->show (line 89)
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)

1.53 ms
(6.41%)

SELECT
                    s.name AS series_name,
                    s.slug AS series_slug,
                    MIN(g.diameter) AS min_diameter,
                    MAX(g.diameter) AS max_diameter,
                    COUNT(*) AS total
                 FROM tyre_products p
                 INNER 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
                 INNER JOIN tyre_brands b ON b.id = p.brand_id
                 WHERE b.slug = ?
                   AND p.is_active = 1
                   AND ss.code = ?
                 GROUP BY s.id, s.name, s.slug
                 ORDER BY total DESC, s.name ASC
                 LIMIT 60

Parameters:

[
  "chengshan-csr71"
  "summer"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s.name AS series_name,
  s.slug AS series_slug,
  MIN(g.diameter) AS min_diameter,
  MAX(g.diameter) AS max_diameter,
  COUNT(*) AS total
FROM
  tyre_products p
  INNER 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
  INNER JOIN tyre_brands b ON b.id = p.brand_id
WHERE
  b.slug = ?
  AND p.is_active = 1
  AND ss.code = ?
GROUP BY
  s.id,
  s.name,
  s.slug
ORDER BY
  total DESC,
  s.name ASC
LIMIT
  60

SELECT
                    s.name AS series_name,
                    s.slug AS series_slug,
                    MIN(g.diameter) AS min_diameter,
                    MAX(g.diameter) AS max_diameter,
                    COUNT(*) AS total
                 FROM tyre_products p
                 INNER 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
                 INNER JOIN tyre_brands b ON b.id = p.brand_id
                 WHERE b.slug = 'chengshan-csr71'
                   AND p.is_active = 1
                   AND ss.code = 'summer'
                 GROUP BY s.id, s.name, s.slug
                 ORDER BY total DESC, s.name ASC
                 LIMIT 60;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 907)
2	App\Controller\TyreBrandController->show (line 116)
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)

1.33 ms
(5.55%)

SELECT
                    p.commercial_name,
                    p.model_identifier,
                    p.energy_class,
                    p.wet_grip_class,
                    p.noise_value,
                    p.tyre_class,
                    p.eprel_registration_number,
                    ts.slug AS series_slug,
                    ss.name AS season_name,
                    ss.slug AS season_slug
                 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
                 LEFT JOIN tyre_series ts ON ts.id = p.series_id
                 WHERE b.slug = ?
                   AND p.is_active = 1
                   AND ss.code = ?
                 ORDER BY p.updated_at DESC
                 LIMIT 1

Parameters:

[
  "chengshan-csr71"
  "summer"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p.commercial_name,
  p.model_identifier,
  p.energy_class,
  p.wet_grip_class,
  p.noise_value,
  p.tyre_class,
  p.eprel_registration_number,
  ts.slug AS series_slug,
  ss.name AS season_name,
  ss.slug AS season_slug
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
  LEFT JOIN tyre_series ts ON ts.id = p.series_id
WHERE
  b.slug = ?
  AND p.is_active = 1
  AND ss.code = ?
ORDER BY
  p.updated_at DESC
LIMIT
  1

SELECT
                    p.commercial_name,
                    p.model_identifier,
                    p.energy_class,
                    p.wet_grip_class,
                    p.noise_value,
                    p.tyre_class,
                    p.eprel_registration_number,
                    ts.slug AS series_slug,
                    ss.name AS season_name,
                    ss.slug AS season_slug
                 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
                 LEFT JOIN tyre_series ts ON ts.id = p.series_id
                 WHERE b.slug = 'chengshan-csr71'
                   AND p.is_active = 1
                   AND ss.code = 'summer'
                 ORDER BY p.updated_at DESC
                 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAssociative (line 593)
2	App\Controller\TyreBrandController->show (line 45)
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)

1.08 ms
(4.50%)

SELECT
                p.eprel_registration_number,
                p.commercial_name,
                p.model_identifier,
                g.label AS size_label,
                p.load_index,
                p.speed_index,
                p.energy_class,
                p.wet_grip_class,
                p.noise_value,
                p.noise_class,
                p.raw_detail_data,
                ts.slug AS series_slug,
                ts.name AS series_name,
                g.slug AS size_slug,
                g.label AS size_group_label,
                ss.slug AS season_slug,
                ss.name AS season_name
             FROM tyre_products p
             INNER JOIN tyre_brands b ON b.id = p.brand_id
             LEFT JOIN tyre_series ts ON ts.id = p.series_id
             LEFT JOIN tyre_size_groups g ON g.id = p.size_group_id
             LEFT JOIN tyre_seasons ss ON ss.id = p.season_id
             WHERE b.slug = ?
               AND p.is_active = 1
             ORDER BY p.updated_at DESC, p.id DESC
             LIMIT 120

Parameters:

[
  "chengshan-csr71"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p.eprel_registration_number,
  p.commercial_name,
  p.model_identifier,
  g.label AS size_label,
  p.load_index,
  p.speed_index,
  p.energy_class,
  p.wet_grip_class,
  p.noise_value,
  p.noise_class,
  p.raw_detail_data,
  ts.slug AS series_slug,
  ts.name AS series_name,
  g.slug AS size_slug,
  g.label AS size_group_label,
  ss.slug AS season_slug,
  ss.name AS season_name
FROM
  tyre_products p
  INNER JOIN tyre_brands b ON b.id = p.brand_id
  LEFT JOIN tyre_series ts ON ts.id = p.series_id
  LEFT JOIN tyre_size_groups g ON g.id = p.size_group_id
  LEFT JOIN tyre_seasons ss ON ss.id = p.season_id
WHERE
  b.slug = ?
  AND p.is_active = 1
ORDER BY
  p.updated_at DESC,
  p.id DESC
LIMIT
  120

SELECT
                p.eprel_registration_number,
                p.commercial_name,
                p.model_identifier,
                g.label AS size_label,
                p.load_index,
                p.speed_index,
                p.energy_class,
                p.wet_grip_class,
                p.noise_value,
                p.noise_class,
                p.raw_detail_data,
                ts.slug AS series_slug,
                ts.name AS series_name,
                g.slug AS size_slug,
                g.label AS size_group_label,
                ss.slug AS season_slug,
                ss.name AS season_name
             FROM tyre_products p
             INNER JOIN tyre_brands b ON b.id = p.brand_id
             LEFT JOIN tyre_series ts ON ts.id = p.series_id
             LEFT JOIN tyre_size_groups g ON g.id = p.size_group_id
             LEFT JOIN tyre_seasons ss ON ss.id = p.season_id
             WHERE b.slug = 'chengshan-csr71'
               AND p.is_active = 1
             ORDER BY p.updated_at DESC, p.id DESC
             LIMIT 120;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 907)
2	App\Controller\TyreBrandController->show (line 201)
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.62 ms
(2.58%)

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:

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 ('507668', '509232', '507661', '494154', '493725', '493720', '494136', '494015', '507413', '509299', '509214', '509194', '493916', '493777', '507588', '507468', '507456', '507445', '493765', '494177', '507653', '507479', '507564')
               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\TyreBrandController->show (line 232)
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)

0.56 ms
(2.34%)

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:

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 ('507668', '509232', '507661', '494154', '493725', '493720', '494136', '494015', '507413', '509299', '509214', '509194', '493916', '493777', '507588', '507468', '507456', '507445', '493765', '494177', '507653', '507479', '507564')
               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\TyreBrandController->show (line 232)
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)

0.50 ms
(2.09%)

SELECT g.label, g.slug, COUNT(*) AS total
             FROM tyre_products p
             INNER JOIN tyre_size_groups g ON g.id = p.size_group_id
             INNER JOIN tyre_brands b ON b.id = p.brand_id
             WHERE b.slug = ?
               AND p.is_active = 1
             GROUP BY g.id, g.label, g.slug
             ORDER BY total DESC
             LIMIT 12

Parameters:

[
  "chengshan-csr71"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  g.label,
  g.slug,
  COUNT(*) AS total
FROM
  tyre_products p
  INNER JOIN tyre_size_groups g ON g.id = p.size_group_id
  INNER JOIN tyre_brands b ON b.id = p.brand_id
WHERE
  b.slug = ?
  AND p.is_active = 1
GROUP BY
  g.id,
  g.label,
  g.slug
ORDER BY
  total DESC
LIMIT
  12

SELECT g.label, g.slug, COUNT(*) AS total
             FROM tyre_products p
             INNER JOIN tyre_size_groups g ON g.id = p.size_group_id
             INNER JOIN tyre_brands b ON b.id = p.brand_id
             WHERE b.slug = 'chengshan-csr71'
               AND p.is_active = 1
             GROUP BY g.id, g.label, g.slug
             ORDER BY total DESC
             LIMIT 12;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 907)
2	App\Controller\TyreBrandController->show (line 75)
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.45 ms
(1.86%)

SELECT id, name, slug, seo_title, seo_description, seo_h1, description
             FROM tyre_brands
             WHERE slug = ?
             LIMIT 1

Parameters:

[
  "chengshan-csr71"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id,
  name,
  slug,
  seo_title,
  seo_description,
  seo_h1,
  description
FROM
  tyre_brands
WHERE
  slug = ?
LIMIT
  1

SELECT id, name, slug, seo_title, seo_description, seo_h1, description
             FROM tyre_brands
             WHERE slug = 'chengshan-csr71'
             LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAssociative (line 593)
2	App\Controller\TyreBrandController->show (line 31)
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.43 ms
(1.78%)

SELECT COUNT(*)
             FROM tyre_products p
             INNER JOIN tyre_brands b ON b.id = p.brand_id
             LEFT JOIN tyre_series ts ON ts.id = p.series_id
             LEFT JOIN tyre_size_groups g ON g.id = p.size_group_id
             LEFT JOIN tyre_seasons ss ON ss.id = p.season_id
             WHERE b.slug = ?
               AND p.is_active = 1

Parameters:

[
  "chengshan-csr71"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  tyre_products p
  INNER JOIN tyre_brands b ON b.id = p.brand_id
  LEFT JOIN tyre_series ts ON ts.id = p.series_id
  LEFT JOIN tyre_size_groups g ON g.id = p.size_group_id
  LEFT JOIN tyre_seasons ss ON ss.id = p.season_id
WHERE
  b.slug = ?
  AND p.is_active = 1

SELECT COUNT(*)
             FROM tyre_products p
             INNER JOIN tyre_brands b ON b.id = p.brand_id
             LEFT JOIN tyre_series ts ON ts.id = p.series_id
             LEFT JOIN tyre_size_groups g ON g.id = p.size_group_id
             LEFT JOIN tyre_seasons ss ON ss.id = p.season_id
             WHERE b.slug = 'chengshan-csr71'
               AND p.is_active = 1;

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 627)
2	App\Controller\TyreBrandController->show (line 234)
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.37 ms
(1.53%)

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:

[
  "507668"
]

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 ('507668')
               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\TyreBrandController->show (line 73)
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)

0.33 ms
(1.38%)

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:

[
  "507668"
]

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 ('507668')
               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\TyreBrandController->show (line 73)
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/marki/chengshan-csr71

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping