GET https://pewneopony.pl/marki/austone-sp-6

Response
200 OK
IP
216.73.216.76
Profiled on
Token
be5820

Query Metrics

47 Database Queries
12 Different statements
30.64 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.61 ms 
SELECT id, name, slug, seo_title, seo_description, seo_h1, description
             FROM tyre_brands
             WHERE slug = ?
             LIMIT 1
Parameters: 
[
  "austone-sp-6"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 4.91 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: 
[
  "austone-sp-6"
  "summer"
]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.55 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: 
[
  "austone-sp-6"
  "winter"
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.46 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: 
[
  "austone-sp-6"
  "allseason"
]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.41 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: 
[
  "467764"
]
View formatted query    View runnable query    Explain query    View query backtrace
6 0.41 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: 
[
  "467764"
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.59 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: 
[
  "austone-sp-6"
]
View formatted query    View runnable query    Explain query    View query backtrace
8 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"
  "austone-sp-6"
  "185-65-r14"
]
View formatted query    View runnable query    Explain query    View query backtrace
9 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"
  "austone-sp-6"
  "195-50-r16"
]
View formatted query    View runnable query    Explain query    View query backtrace
10 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"
  "austone-sp-6"
  "195-55-r16"
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.54 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"
  "austone-sp-6"
  "205-60-r15"
]
View formatted query    View runnable query    Explain query    View query backtrace
12 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"
  "austone-sp-6"
  "185-65-r15"
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.54 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"
  "austone-sp-6"
  "195-65-r15"
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.54 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"
  "austone-sp-6"
  "205-65-r16"
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.71 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"
  "austone-sp-6"
  "195-55-r15"
]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.60 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"
  "austone-sp-6"
  "205-60-r16"
]
View formatted query    View runnable query    Explain query    View query backtrace
17 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"
  "austone-sp-6"
  "175-70-r14"
]
View formatted query    View runnable query    Explain query    View query backtrace
18 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"
  "austone-sp-6"
  "205-65-r15"
]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.58 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"
  "austone-sp-6"
  "215-65-r15"
]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.76 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: 
[
  "austone-sp-6"
  "summer"
]
View formatted query    View runnable query    Explain query    View query backtrace
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: 
[
  "austone-sp-6"
  "winter"
]
View formatted query    View runnable query    Explain query    View query backtrace
22 0.51 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: 
[
  "austone-sp-6"
  "allseason"
]
View formatted query    View runnable query    Explain query    View query backtrace
23 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"
  "austone-sp-6"
  "summer"
  "2100-3221026004"
]
View formatted query    View runnable query    Explain query    View query backtrace
24 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"
  "austone-sp-6"
  "summer"
  "2100-3235024004"
]
View formatted query    View runnable query    Explain query    View query backtrace
25 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"
  "austone-sp-6"
  "summer"
  "2100-3241026004"
]
View formatted query    View runnable query    Explain query    View query backtrace
26 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"
  "austone-sp-6"
  "summer"
  "2100-3312026004"
]
View formatted query    View runnable query    Explain query    View query backtrace
27 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"
  "austone-sp-6"
  "summer"
  "2100-3316026004"
]
View formatted query    View runnable query    Explain query    View query backtrace
28 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"
  "austone-sp-6"
  "summer"
  "2100-3318026004"
]
View formatted query    View runnable query    Explain query    View query backtrace
29 0.82 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"
  "austone-sp-6"
  "summer"
  "2100-3325027004"
]
View formatted query    View runnable query    Explain query    View query backtrace
30 0.66 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"
  "austone-sp-6"
  "summer"
  "2100-3329027004"
]
View formatted query    View runnable query    Explain query    View query backtrace
31 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"
  "austone-sp-6"
  "summer"
  "2100-3331026004"
]
View formatted query    View runnable query    Explain query    View query backtrace
32 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"
  "austone-sp-6"
  "summer"
  "2100-3334026004"
]
View formatted query    View runnable query    Explain query    View query backtrace
33 0.66 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"
  "austone-sp-6"
  "summer"
  "2100-3415026004"
]
View formatted query    View runnable query    Explain query    View query backtrace
34 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"
  "austone-sp-6"
  "summer"
  "2100-3420027004"
]
View formatted query    View runnable query    Explain query    View query backtrace
35 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"
  "austone-sp-6"
  "summer"
  "2100-3421026004"
]
View formatted query    View runnable query    Explain query    View query backtrace
36 0.48 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"
  "austone-sp-6"
  "summer"
  "2100-3424027004"
]
View formatted query    View runnable query    Explain query    View query backtrace
37 0.49 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"
  "austone-sp-6"
  "summer"
  "2100-3427027004"
]
View formatted query    View runnable query    Explain query    View query backtrace
38 0.48 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"
  "austone-sp-6"
  "summer"
  "2100-3432026004"
]
View formatted query    View runnable query    Explain query    View query backtrace
39 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"
  "austone-sp-6"
  "summer"
  "2100-3515027004"
]
View formatted query    View runnable query    Explain query    View query backtrace
40 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"
  "austone-sp-6"
  "summer"
  "2100-3517027004"
]
View formatted query    View runnable query    Explain query    View query backtrace
41 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"
  "austone-sp-6"
  "summer"
  "2100-3521027004"
]
View formatted query    View runnable query    Explain query    View query backtrace
42 0.53 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"
  "austone-sp-6"
  "summer"
  "2100-3614027004"
]
View formatted query    View runnable query    Explain query    View query backtrace
43 0.63 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"
  "austone-sp-6"
  "summer"
  "2100-3620027004"
]
View formatted query    View runnable query    Explain query    View query backtrace
44 0.89 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: 
[
  "austone-sp-6"
]
View formatted query    View runnable query    Explain query    View query backtrace
45 0.68 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: 
[
  "467787"
  "467764"
  "467703"
  "474155"
  "483214"
  "473988"
  "468058"
  "467796"
  "488195"
  "466356"
  "464571"
  "464522"
  "467738"
  "464556"
  "474566"
  "470589"
  "477033"
  "482290"
  "488234"
  "474416"
  "474251"
]
View formatted query    View runnable query    Explain query    View query backtrace
46 0.66 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: 
[
  "467787"
  "467764"
  "467703"
  "474155"
  "483214"
  "473988"
  "468058"
  "467796"
  "488195"
  "466356"
  "464571"
  "464522"
  "467738"
  "464556"
  "474566"
  "470589"
  "477033"
  "482290"
  "488234"
  "474416"
  "474251"
]
View formatted query    View runnable query    Explain query    View query backtrace
47 0.51 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: 
[
  "austone-sp-6"
]
View formatted query    View runnable query    Explain query    View query backtrace

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.