Query Metrics
36
Database Queries
12
Different statements
17.17 ms
Query time
0
Invalid entities
0
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.47 ms |
SELECT id, name, slug, seo_title, seo_description, seo_h1, description FROM tyre_brands WHERE slug = ? LIMIT 1
Parameters:
[
"falken-ze914ec"
]
|
||||||||||||||||||||||||
| 2 | 0.60 ms |
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:
[ "falken-ze914ec" "summer" ]
|
||||||||||||||||||||||||
| 3 | 0.43 ms |
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:
[ "falken-ze914ec" "winter" ]
|
||||||||||||||||||||||||
| 4 | 0.41 ms |
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:
[ "falken-ze914ec" "allseason" ]
|
||||||||||||||||||||||||
| 5 | 0.40 ms |
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:
[
"923502"
]
|
||||||||||||||||||||||||
| 6 | 0.42 ms |
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:
[
"923502"
]
|
||||||||||||||||||||||||
| 7 | 0.57 ms |
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:
[
"falken-ze914ec"
]
|
||||||||||||||||||||||||
| 8 | 0.50 ms |
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" "falken-ze914ec" "205-45-r17" ]
|
||||||||||||||||||||||||
| 9 | 0.67 ms |
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" "falken-ze914ec" "205-55-r17" ]
|
||||||||||||||||||||||||
| 10 | 0.63 ms |
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" "falken-ze914ec" "225-50-r17" ]
|
||||||||||||||||||||||||
| 11 | 0.45 ms |
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" "falken-ze914ec" "215-60-r16" ]
|
||||||||||||||||||||||||
| 12 | 0.44 ms |
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" "falken-ze914ec" "215-45-r16" ]
|
||||||||||||||||||||||||
| 13 | 0.41 ms |
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" "falken-ze914ec" "185-60-r15" ]
|
||||||||||||||||||||||||
| 14 | 0.40 ms |
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" "falken-ze914ec" "235-50-r18" ]
|
||||||||||||||||||||||||
| 15 | 0.40 ms |
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" "falken-ze914ec" "225-45-r17" ]
|
||||||||||||||||||||||||
| 16 | 0.41 ms |
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" "falken-ze914ec" "195-60-r16" ]
|
||||||||||||||||||||||||
| 17 | 0.38 ms |
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" "falken-ze914ec" "195-55-r15" ]
|
||||||||||||||||||||||||
| 18 | 0.42 ms |
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" "falken-ze914ec" "225-45-r18" ]
|
||||||||||||||||||||||||
| 19 | 0.39 ms |
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" "falken-ze914ec" "195-55-r16" ]
|
||||||||||||||||||||||||
| 20 | 0.62 ms |
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:
[ "falken-ze914ec" "summer" ]
|
||||||||||||||||||||||||
| 21 | 0.44 ms |
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:
[ "falken-ze914ec" "winter" ]
|
||||||||||||||||||||||||
| 22 | 0.43 ms |
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:
[ "falken-ze914ec" "allseason" ]
|
||||||||||||||||||||||||
| 23 | 0.47 ms |
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" "falken-ze914ec" "summer" "ziex-ze914ecorun" ]
|
||||||||||||||||||||||||
| 24 | 0.47 ms |
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" "falken-ze914ec" "summer" "ziex-ze9140ecorun" ]
|
||||||||||||||||||||||||
| 25 | 0.45 ms |
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" "falken-ze914ec" "summer" "ziex-ze914-ecorun" ]
|
||||||||||||||||||||||||
| 26 | 0.50 ms |
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" "falken-ze914ec" "summer" "303141" ]
|
||||||||||||||||||||||||
| 27 | 0.41 ms |
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" "falken-ze914ec" "summer" "303197" ]
|
||||||||||||||||||||||||
| 28 | 0.43 ms |
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" "falken-ze914ec" "summer" "313127" ]
|
||||||||||||||||||||||||
| 29 | 0.45 ms |
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" "falken-ze914ec" "summer" "315727" ]
|
||||||||||||||||||||||||
| 30 | 0.52 ms |
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" "falken-ze914ec" "summer" "317711tr" ]
|
||||||||||||||||||||||||
| 31 | 0.55 ms |
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" "falken-ze914ec" "summer" "317715" ]
|
||||||||||||||||||||||||
| 32 | 0.44 ms |
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" "falken-ze914ec" "summer" "317883" ]
|
||||||||||||||||||||||||
| 33 | 0.71 ms |
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:
[
"falken-ze914ec"
]
|
||||||||||||||||||||||||
| 34 | 0.53 ms |
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:
[ "923502" "773730" "583334" "616729" "614548" "616731" "616725" "616724" "616649" "616722" "616617" "616401" "616399" "616395" "469795" "616728" "616720" "616645" "616641" "616408" "583314" "616404" ]
|
||||||||||||||||||||||||
| 35 | 0.52 ms |
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:
[ "923502" "773730" "583334" "616729" "614548" "616731" "616725" "616724" "616649" "616722" "616617" "616401" "616399" "616395" "469795" "616728" "616720" "616645" "616641" "616408" "583314" "616404" ]
|
||||||||||||||||||||||||
| 36 | 0.43 ms |
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:
[
"falken-ze914ec"
]
|
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.