Symfony Profiler

Query Metrics

157 Database Queries

12 Different statements

1081.77 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

880.98 ms
(81.44%)

131

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"
  "michelin"
  "summer"
  "primacy-5"
]

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 = 'michelin'
                       AND ss.code = 'summer'
                       AND s.slug = 'primacy-5'
                       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)

87.80 ms
(8.12%)

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"
  "michelin"
  "205-55-r16"
]

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 = 'michelin'
                   AND g.slug = '205-55-r16'
                   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)

30.24 ms
(2.80%)

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:

[
  "michelin"
  "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 = 'michelin'
                   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)

27.53 ms
(2.54%)

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:

[
  "michelin"
]

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 = 'michelin'
               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)

17.56 ms
(1.62%)

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:

[
  "michelin"
  "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 = 'michelin'
                   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)

15.47 ms
(1.43%)

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:

[
  "michelin"
]

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 = 'michelin'
               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)

12.82 ms
(1.19%)

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:

[
  "michelin"
]

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 = 'michelin'
               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)

5.21 ms
(0.48%)

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 ('412350', '412528', '412324', '412307', '412303', '412300', '1594640', '1594631', '1596045', '1596044', '410657', '410647', '410646', '410635', '410443', '410432', '920030', '409009', '409008', '998064', '924260', '924167', '1123715', '2503399', '2420477', '2420464', '1677581', '1573576', '1574164', '1804009', '1803981', '2384578', '1788322', '2339448', '2335771', '2335765', '2335759', '2273438', '2273432', '2271519', '2271375', '2270616', '2269771', '2267317', '2267040', '2267881', '1441061', '1441038', '1428406', '409703', '409510', '409503', '409702', '409697', '409694', '409778', '409775', '409767', '409756', '409749', '409724', '409802', '408987', '408968', '409036', '409029', '409006', '409005', '409001', '408999', '409109', '412488', '412487', '831080', '664254', '664097', '664094', '2540523', '2510884', '2501355', '2495686', '2433505', '2296681', '2296680', '2258903', '1974905', '2343920', '2342983', '2342969', '2313481', '2309498', '2309497', '2309490', '2312140', '2209189', '1909858', '1874581', '1876179', '1876159', '1672045', '1925501', '1869634', '1871124', '1871122', '409136', '409131', '409122', '411082', '1353047', '1353032', '1350647', '1345006', '408630', '1294112', '1255748', '1257582', '1166671', '1121543', '1104747', '1104734')
               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)

2.33 ms
(0.22%)

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 ('412350', '412528', '412324', '412307', '412303', '412300', '1594640', '1594631', '1596045', '1596044', '410657', '410647', '410646', '410635', '410443', '410432', '920030', '409009', '409008', '998064', '924260', '924167', '1123715', '2503399', '2420477', '2420464', '1677581', '1573576', '1574164', '1804009', '1803981', '2384578', '1788322', '2339448', '2335771', '2335765', '2335759', '2273438', '2273432', '2271519', '2271375', '2270616', '2269771', '2267317', '2267040', '2267881', '1441061', '1441038', '1428406', '409703', '409510', '409503', '409702', '409697', '409694', '409778', '409775', '409767', '409756', '409749', '409724', '409802', '408987', '408968', '409036', '409029', '409006', '409005', '409001', '408999', '409109', '412488', '412487', '831080', '664254', '664097', '664094', '2540523', '2510884', '2501355', '2495686', '2433505', '2296681', '2296680', '2258903', '1974905', '2343920', '2342983', '2342969', '2313481', '2309498', '2309497', '2309490', '2312140', '2209189', '1909858', '1874581', '1876179', '1876159', '1672045', '1925501', '1869634', '1871124', '1871122', '409136', '409131', '409122', '411082', '1353047', '1353032', '1350647', '1345006', '408630', '1294112', '1255748', '1257582', '1166671', '1121543', '1104747', '1104734')
               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.75 ms
(0.07%)

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:

[
  "412300"
  "412303"
  "1988002"
]

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 ('412300', '412303', '1988002')
               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.67 ms
(0.06%)

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:

[
  "412300"
  "412303"
  "1988002"
]

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 ('412300', '412303', '1988002')
               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)

0.41 ms
(0.04%)

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

Parameters:

[
  "michelin"
]

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 = 'michelin'
             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)

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/michelin

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping