Symfony Profiler

Query Metrics

21 Database Queries
9 Different statements
19.02 ms Query time
0 Invalid entities
Queries


SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_name AS image_name_4, t0.parent_id AS parent_id_5 FROM part_categories t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_name AS image_name_4, t0.parent_id AS parent_id_5 FROM part_categories t0 ORDER BY t0.name ASC
SELECT p0_.part_category_id AS sclr_0, COUNT(p0_.id) AS sclr_1 FROM part_listings p0_ LEFT JOIN part_categories p1_ ON p0_.part_category_id = p1_.id LEFT JOIN makes m2_ ON p0_.make_id = m2_.id LEFT JOIN models m3_ ON p0_.model_id = m3_.id LEFT JOIN vehicle_ranges v4_ ON p0_.vehicle_range_id = v4_.id INNER JOIN users u5_ ON p0_.owner_id = u5_.id INNER JOIN company_profiles c6_ ON u5_.id = c6_.user_id WHERE p0_.status = ? AND c6_.status = ? AND p0_.quantity > 0 AND p0_.part_category_id IS NOT NULL GROUP BY p0_.part_category_id
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_name AS image_name_4, t0.parent_id AS parent_id_5 FROM part_categories t0 ORDER BY t0.name ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_name AS image_name_4, t0.parent_id AS parent_id_5 FROM part_categories t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (?, ?, ?) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC
SELECT p0_.id AS id_0, p0_.short_description AS short_description_1, p0_.slug AS slug_2, p0_.full_description AS full_description_3, p0_.tags AS tags_4, p0_.catalog_number AS catalog_number_5, p0_.oem_number AS oem_number_6, p0_.article_number AS article_number_7, p0_.condition_type AS condition_type_8, p0_.price AS price_9, p0_.price_new AS price_new_10, p0_.quantity AS quantity_11, p0_.status AS status_12, p0_.created_at AS created_at_13, p1_.id AS id_14, p1_.image_name AS image_name_15, p1_.sort_order AS sort_order_16, p2_.id AS id_17, p2_.name AS name_18, p2_.slug AS slug_19, p2_.image_name AS image_name_20, m3_.id AS id_21, m3_.name AS name_22, m3_.slug AS slug_23, m3_.ext_source AS ext_source_24, m3_.ext_id AS ext_id_25, m4_.id AS id_26, m4_.name AS name_27, m4_.slug AS slug_28, m4_.ext_id AS ext_id_29, v5_.id AS id_30, v5_.year_from AS year_from_31, v5_.year_to AS year_to_32, v5_.generation_name AS generation_name_33, p6_.id AS id_34, p6_.value_text AS value_text_35, p6_.value_number_from AS value_number_from_36, p6_.value_number_to AS value_number_to_37, p6_.value_json AS value_json_38, c7_.id AS id_39, c7_.code AS code_40, c7_.name_en AS name_en_41, c7_.name_es AS name_es_42, c7_.type AS type_43, c7_.sort_order AS sort_order_44, p0_.owner_id AS owner_id_45, p0_.make_id AS make_id_46, p0_.model_id AS model_id_47, p0_.vehicle_range_id AS vehicle_range_id_48, p0_.part_category_id AS part_category_id_49, p0_.dismantled_vehicle_id AS dismantled_vehicle_id_50, p1_.listing_id AS listing_id_51, p2_.parent_id AS parent_id_52, m4_.make_id AS make_id_53, v5_.model_id AS model_id_54, p6_.listing_id AS listing_id_55, p6_.filter_id AS filter_id_56 FROM part_listings p0_ LEFT JOIN part_listing_images p1_ ON p0_.id = p1_.listing_id LEFT JOIN part_categories p2_ ON p0_.part_category_id = p2_.id LEFT JOIN makes m3_ ON p0_.make_id = m3_.id LEFT JOIN models m4_ ON p0_.model_id = m4_.id LEFT JOIN vehicle_ranges v5_ ON p0_.vehicle_range_id = v5_.id LEFT JOIN part_listing_custom_filter_values p6_ ON p0_.id = p6_.listing_id LEFT JOIN custom_filters c7_ ON p6_.filter_id = c7_.id INNER JOIN users u8_ ON p0_.owner_id = u8_.id INNER JOIN company_profiles c9_ ON u8_.id = c9_.user_id WHERE p0_.status = ? AND c9_.status = ? AND p0_.quantity > 0 AND p2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.created_at DESC
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.ext_source AS ext_source_4, t0.ext_id AS ext_id_5 FROM makes t0 ORDER BY t0.name ASC
SELECT c0_.id AS id_0, c0_.company_name AS company_name_1, c0_.logo_name AS logo_name_2, c0_.ein AS ein_3, c0_.status AS status_4, c0_.submitted_at AS submitted_at_5, c0_.reviewed_at AS reviewed_at_6, u1_.id AS id_7, u1_.email AS email_8, u1_.roles AS roles_9, u1_.password AS password_10, u1_.is_verified AS is_verified_11, u1_.phone AS phone_12, u1_.address_line1 AS address_line1_13, u1_.address_line2 AS address_line2_14, u1_.city AS city_15, u1_.state AS state_16, u1_.postal_code AS postal_code_17, u1_.is_company AS is_company_18, c0_.user_id AS user_id_19 FROM company_profiles c0_ INNER JOIN users u1_ ON c0_.user_id = u1_.id WHERE c0_.status = ? AND c0_.company_name IS NOT NULL AND TRIM(c0_.company_name) <> '' ORDER BY c0_.company_name ASC
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.
Entities Mapping

Class	Mapping errors
App\Entity\PartCategory	No errors.
App\Entity\CustomFilter	No errors.
App\Entity\PartListing	No errors.
App\Entity\Make	No errors.
App\Entity\Model	No errors.
App\Entity\VehicleRange	No errors.
App\Entity\Users	No errors.
App\Entity\CompanyProfile	No errors.
App\Entity\CustomFilterOption	No errors.
App\Entity\PartListingImage	No errors.
App\Entity\PartListingCustomFilterValue	No errors.
App\Entity\DismantledVehicle	No errors.
App\Entity\PartListingFitment	No errors.
Symfony Profiler

GET http://88.99.167.175/en/catalog/parts?categories%5B0%5D=3

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping
