Query Metrics
32
Database Queries
12
Different statements
17.08 ms
Query time
0
Invalid entities
0
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.48 ms |
SELECT id, name, slug, seo_title, seo_description, seo_h1, description FROM tyre_brands WHERE slug = ? LIMIT 1
Parameters:
[
"normaks"
]
|
||||||||||||||||||||||||
| 2 | 0.65 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:
[ "normaks" "summer" ]
|
||||||||||||||||||||||||
| 3 | 0.76 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:
[ "normaks" "winter" ]
|
||||||||||||||||||||||||
| 4 | 0.63 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:
[ "normaks" "allseason" ]
|
||||||||||||||||||||||||
| 5 | 0.50 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:
[ "2200999" "2585594" ]
|
||||||||||||||||||||||||
| 6 | 0.56 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:
[ "2200999" "2585594" ]
|
||||||||||||||||||||||||
| 7 | 0.85 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:
[
"normaks"
]
|
||||||||||||||||||||||||
| 8 | 0.59 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" "normaks" "315-80-r22" ]
|
||||||||||||||||||||||||
| 9 | 0.62 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" "normaks" "235-65-r16" ]
|
||||||||||||||||||||||||
| 10 | 0.51 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" "normaks" "185-75-r16" ]
|
||||||||||||||||||||||||
| 11 | 0.48 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" "normaks" "215-65-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" "normaks" "195-65-r16" ]
|
||||||||||||||||||||||||
| 13 | 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" "normaks" "195-70-r15" ]
|
||||||||||||||||||||||||
| 14 | 0.49 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" "normaks" "205-65-r16" ]
|
||||||||||||||||||||||||
| 15 | 0.55 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" "normaks" "215-70-r15" ]
|
||||||||||||||||||||||||
| 16 | 0.43 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" "normaks" "385-65-r22" ]
|
||||||||||||||||||||||||
| 17 | 0.46 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" "normaks" "225-70-r15" ]
|
||||||||||||||||||||||||
| 18 | 0.43 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" "normaks" "195-75-r16" ]
|
||||||||||||||||||||||||
| 19 | 0.43 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" "normaks" "215-75-r14" ]
|
||||||||||||||||||||||||
| 20 | 0.47 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:
[ "normaks" "summer" ]
|
||||||||||||||||||||||||
| 21 | 0.50 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:
[ "normaks" "winter" ]
|
||||||||||||||||||||||||
| 22 | 0.39 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:
[ "normaks" "allseason" ]
|
||||||||||||||||||||||||
| 23 | 0.40 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" "normaks" "summer" "nd638" ]
|
||||||||||||||||||||||||
| 24 | 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" "normaks" "summer" "nd768" ]
|
||||||||||||||||||||||||
| 25 | 0.35 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" "normaks" "summer" "nu568" ]
|
||||||||||||||||||||||||
| 26 | 0.36 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" "normaks" "summer" "tf907" ]
|
||||||||||||||||||||||||
| 27 | 0.42 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" "normaks" "summer" "tt608" ]
|
||||||||||||||||||||||||
| 28 | 0.69 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" "normaks" "winter" "profi" ]
|
||||||||||||||||||||||||
| 29 | 0.79 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:
[
"normaks"
]
|
||||||||||||||||||||||||
| 30 | 0.54 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:
[ "2585597" "2585594" "2200999" "2585606" "2585605" "2585604" "2585602" "2585600" "2201007" "2200998" "2585592" "2585603" "2585601" "2585599" "2585598" "2585596" "2200997" "2354880" "2201006" "2585608" "2585609" "2585595" "2585593" "2585591" ]
|
||||||||||||||||||||||||
| 31 | 0.72 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:
[ "2585597" "2585594" "2200999" "2585606" "2585605" "2585604" "2585602" "2585600" "2201007" "2200998" "2585592" "2585603" "2585601" "2585599" "2585598" "2585596" "2200997" "2354880" "2201006" "2585608" "2585609" "2585595" "2585593" "2585591" ]
|
||||||||||||||||||||||||
| 32 | 0.67 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:
[
"normaks"
]
|
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.