Symfony Profiler

Query Metrics

9 Database Queries
9 Different statements
97.40 ms Query time
0 Invalid entities
0 Managed entities
Queries


SELECT
                p.id,
                p.eprel_registration_number,
                p.model_identifier,
                p.commercial_name,
                p.tyre_designation,
                p.tyre_class,
                p.load_index,
                p.speed_index,
                p.load_capacity_indicator,
                p.energy_class,
                p.wet_grip_class,
                p.noise_class,
                p.noise_value,
                p.is_xl,
                p.is_runflat,
                p.is_severe_snow,
                p.is_ice,
                p.raw_detail_data,
                b.id AS brand_id,
                b.name AS brand_name,
                b.slug AS brand_slug,
                s.id AS series_id,
                s.name AS series_name,
                s.slug AS series_slug,
                ss.code AS season_code,
                ss.name AS season_name,
                g.id AS size_group_id,
                g.label AS size_label
             FROM tyre_products p
             INNER JOIN tyre_brands b ON b.id = p.brand_id
             LEFT JOIN tyre_series s ON s.id = p.series_id
             INNER JOIN tyre_seasons ss ON ss.id = p.season_id
             INNER JOIN tyre_size_groups g ON g.id = p.size_group_id
             WHERE p.eprel_registration_number = ?
               AND b.slug = ?
               AND COALESCE(s.slug, ?) = ?
             LIMIT 1
SELECT
                p2.eprel_registration_number,
                g2.label AS size_label,
                g2.width AS size_width,
                g2.profile AS size_profile,
                g2.diameter AS size_diameter,
                p2.load_index,
                p2.speed_index
             FROM tyre_products p2
             INNER JOIN tyre_size_groups g2 ON g2.id = p2.size_group_id
             WHERE p2.brand_id = ?
               AND (
                    (p2.series_id = ?)
                    OR (p2.series_id IS NULL AND ? IS NULL)
               )
               AND p2.is_active = 1
             ORDER BY g2.diameter ASC, g2.width ASC, g2.profile ASC, p2.load_index ASC, p2.speed_index ASC, p2.eprel_registration_number ASC
             LIMIT 100
SELECT
                o.id,
                o.external_id,
                o.name,
                sup.code AS supplier_code,
                sup.name AS supplier_name,
                o.match_status,
                o.match_score,
                o.is_active,
                p.net_offer_price,
                p.gross_offer_price,
                p.net_list_price,
                p.gross_list_price,
                MIN(tp_offer.eprel_registration_number) AS linked_eprel_registration_number,
                COALESCE(SUM(CASE WHEN st.quantity > 0 THEN st.quantity ELSE 0 END), 0) AS total_quantity,
                MAX(CASE WHEN st.quantity > 0 THEN 1 ELSE 0 END) AS has_stock
             FROM tyre_supplier_offers o
             INNER JOIN tyre_products tp_offer ON tp_offer.id = o.tyre_product_id
             INNER JOIN tyre_suppliers sup ON sup.id = o.supplier_id
             LEFT JOIN tyre_supplier_offer_prices p ON p.offer_id = o.id AND p.is_current = 1
             LEFT JOIN tyre_supplier_offer_stocks st ON st.offer_id = o.id AND st.is_current = 1
             WHERE tp_offer.brand_id = ?
               AND tp_offer.size_group_id = ?
               AND (
                    (tp_offer.series_id = ?)
                    OR (tp_offer.series_id IS NULL AND ? IS NULL)
               )
               AND (
                    (tp_offer.load_index = ?)
                    OR (tp_offer.load_index IS NULL AND ? IS NULL)
               )
               AND COALESCE(tp_offer.speed_index, '') = ?
               AND tp_offer.is_xl = ?
               AND tp_offer.is_runflat = ?
               AND o.match_status = ?
               AND o.is_active = 1
             GROUP BY
                o.id,
                o.external_id,
                o.name,
                sup.code,
                sup.name,
                o.match_status,
                o.match_score,
                o.is_active,
                p.net_offer_price,
                p.gross_offer_price,
                p.net_list_price,
                p.gross_list_price
             ORDER BY has_stock DESC, p.gross_offer_price ASC, p.net_offer_price ASC, o.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 (?)
               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
                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
                    o.id AS offer_id,
                    st.warehouse_code,
                    st.warehouse_name,
                    st.quantity
                 FROM tyre_supplier_offers o
                 INNER JOIN tyre_supplier_offer_stocks st ON st.offer_id = o.id AND st.is_current = 1
                 INNER JOIN tyre_products tp_offer ON tp_offer.id = o.tyre_product_id
                 WHERE tp_offer.brand_id = ?
                   AND tp_offer.size_group_id = ?
                   AND (
                        (tp_offer.series_id = ?)
                        OR (tp_offer.series_id IS NULL AND ? IS NULL)
                   )
                   AND (
                        (tp_offer.load_index = ?)
                        OR (tp_offer.load_index IS NULL AND ? IS NULL)
                   )
                   AND COALESCE(tp_offer.speed_index, '') = ?
                   AND tp_offer.is_xl = ?
                   AND tp_offer.is_runflat = ?
                   AND o.match_status = ?
                   AND o.is_active = 1
                 ORDER BY o.id ASC, st.quantity DESC, st.warehouse_name ASC
SELECT
                    o.id AS offer_id,
                    ph.file_name,
                    ph.local_path,
                    ph.sort_order,
                    ph.is_primary
                 FROM tyre_supplier_offers o
                 INNER JOIN latex_products lp ON lp.supplier_index = o.external_id
                 INNER JOIN latex_product_photos ph ON ph.product_id = lp.id
                 INNER JOIN tyre_products tp_offer ON tp_offer.id = o.tyre_product_id
                 WHERE tp_offer.brand_id = ?
                   AND tp_offer.size_group_id = ?
                   AND (
                        (tp_offer.series_id = ?)
                        OR (tp_offer.series_id IS NULL AND ? IS NULL)
                   )
                   AND (
                        (tp_offer.load_index = ?)
                        OR (tp_offer.load_index IS NULL AND ? IS NULL)
                   )
                   AND COALESCE(tp_offer.speed_index, '') = ?
                   AND tp_offer.is_xl = ?
                   AND tp_offer.is_runflat = ?
                   AND o.match_status = ?
                   AND o.is_active = 1
                 ORDER BY ph.is_primary DESC, ph.sort_order ASC, ph.id ASC
SELECT
                        COUNT(*) AS total_reviews,
                        ROUND(AVG(r.rating_overall), 1) AS avg_overall,
                        ROUND(AVG(r.rating_comfort), 1) AS avg_comfort,
                        ROUND(AVG(r.rating_dry), 1) AS avg_dry,
                        ROUND(AVG(r.rating_wet), 1) AS avg_wet,
                        ROUND(AVG(r.rating_winter), 1) AS avg_winter,
                        ROUND(100 * AVG(CASE WHEN r.recommend = 1 THEN 1 ELSE 0 END), 0) AS recommend_percent
                     FROM tyre_series_reviews r
                     WHERE r.series_id = ?
                       AND r.is_active = 1
SELECT
                        r.id,
                        r.author_name,
                        r.tyre_size_label,
                        r.rating_overall,
                        r.rating_comfort,
                        r.rating_dry,
                        r.rating_wet,
                        r.rating_winter,
                        r.recommend,
                        r.is_verified_purchase,
                        r.comment,
                        r.created_at
                     FROM tyre_series_reviews r
                     WHERE r.series_id = ?
                       AND r.is_active = 1
                     ORDER BY r.created_at DESC, r.id DESC
                     LIMIT ? OFFSET ?
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/opony/hankook/1028487/1020074

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping
