Query Metrics
34
Database Queries
12
Different statements
22.58 ms
Query time
0
Invalid entities
0
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.43 ms |
SELECT id, name, slug, seo_title, seo_description, seo_h1, description FROM tyre_brands WHERE slug = ? LIMIT 1
Parameters:
[
"fortune-fsr-516"
]
|
||||||||||||||||||||||||
| 2 | 0.52 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:
[ "fortune-fsr-516" "summer" ]
|
||||||||||||||||||||||||
| 3 | 0.38 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:
[ "fortune-fsr-516" "winter" ]
|
||||||||||||||||||||||||
| 4 | 0.35 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:
[ "fortune-fsr-516" "allseason" ]
|
||||||||||||||||||||||||
| 5 | 0.37 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:
[
"467768"
]
|
||||||||||||||||||||||||
| 6 | 0.44 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:
[
"467768"
]
|
||||||||||||||||||||||||
| 7 | 0.55 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:
[
"fortune-fsr-516"
]
|
||||||||||||||||||||||||
| 8 | 0.52 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" "fortune-fsr-516" "205-65-r15" ]
|
||||||||||||||||||||||||
| 9 | 0.47 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" "fortune-fsr-516" "195-65-r15" ]
|
||||||||||||||||||||||||
| 10 | 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" "fortune-fsr-516" "205-55-r16" ]
|
||||||||||||||||||||||||
| 11 | 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" "fortune-fsr-516" "185-60-r15" ]
|
||||||||||||||||||||||||
| 12 | 0.61 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" "fortune-fsr-516" "175-70-r14" ]
|
||||||||||||||||||||||||
| 13 | 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" "fortune-fsr-516" "185-60-r14" ]
|
||||||||||||||||||||||||
| 14 | 0.64 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" "fortune-fsr-516" "195-55-r15" ]
|
||||||||||||||||||||||||
| 15 | 0.80 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" "fortune-fsr-516" "185-65-r15" ]
|
||||||||||||||||||||||||
| 16 | 0.74 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" "fortune-fsr-516" "195-60-r14" ]
|
||||||||||||||||||||||||
| 17 | 0.77 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" "fortune-fsr-516" "195-60-r15" ]
|
||||||||||||||||||||||||
| 18 | 0.91 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:
[ "fortune-fsr-516" "summer" ]
|
||||||||||||||||||||||||
| 19 | 0.69 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:
[ "fortune-fsr-516" "winter" ]
|
||||||||||||||||||||||||
| 20 | 0.83 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:
[ "fortune-fsr-516" "allseason" ]
|
||||||||||||||||||||||||
| 21 | 0.73 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" "fortune-fsr-516" "summer" "2100-3221036516" ]
|
||||||||||||||||||||||||
| 22 | 0.65 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" "fortune-fsr-516" "summer" "2100-3318036516" ]
|
||||||||||||||||||||||||
| 23 | 0.64 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" "fortune-fsr-516" "summer" "2100-3325036516" ]
|
||||||||||||||||||||||||
| 24 | 0.83 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" "fortune-fsr-516" "summer" "2100-3329036516" ]
|
||||||||||||||||||||||||
| 25 | 0.72 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" "fortune-fsr-516" "summer" "2100-3413036516" ]
|
||||||||||||||||||||||||
| 26 | 0.72 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" "fortune-fsr-516" "summer" "2100-3415036516" ]
|
||||||||||||||||||||||||
| 27 | 0.61 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" "fortune-fsr-516" "summer" "2100-3419036516" ]
|
||||||||||||||||||||||||
| 28 | 0.64 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" "fortune-fsr-516" "summer" "2100-3420036516" ]
|
||||||||||||||||||||||||
| 29 | 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" "fortune-fsr-516" "summer" "2100-3516036516" ]
|
||||||||||||||||||||||||
| 30 | 0.77 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" "fortune-fsr-516" "summer" "2100-3521037516" ]
|
||||||||||||||||||||||||
| 31 | 1.75 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:
[
"fortune-fsr-516"
]
|
||||||||||||||||||||||||
| 32 | 0.78 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:
[ "467768" "474075" "467754" "470353" "473790" "482244" "464529" "483612" "470706" "467791" ]
|
||||||||||||||||||||||||
| 33 | 0.86 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:
[ "467768" "474075" "467754" "470353" "473790" "482244" "464529" "483612" "470706" "467791" ]
|
||||||||||||||||||||||||
| 34 | 0.61 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:
[
"fortune-fsr-516"
]
|
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.