Query Metrics
8
Database Queries
8
Different statements
4.64 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.20 ms |
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, u2_.id AS id_17, u2_.email AS email_18, u2_.roles AS roles_19, u2_.password AS password_20, u2_.is_verified AS is_verified_21, u2_.phone AS phone_22, u2_.address_line1 AS address_line1_23, u2_.address_line2 AS address_line2_24, u2_.city AS city_25, u2_.state AS state_26, u2_.postal_code AS postal_code_27, u2_.is_company AS is_company_28, c3_.id AS id_29, c3_.company_name AS company_name_30, c3_.logo_name AS logo_name_31, c3_.ein AS ein_32, c3_.status AS status_33, c3_.submitted_at AS submitted_at_34, c3_.reviewed_at AS reviewed_at_35, p4_.id AS id_36, m5_.id AS id_37, m5_.name AS name_38, m5_.slug AS slug_39, m5_.ext_source AS ext_source_40, m5_.ext_id AS ext_id_41, m6_.id AS id_42, m6_.name AS name_43, m6_.slug AS slug_44, m6_.ext_id AS ext_id_45, v7_.id AS id_46, v7_.year_from AS year_from_47, v7_.year_to AS year_to_48, v7_.generation_name AS generation_name_49, p8_.id AS id_50, p8_.name AS name_51, p8_.slug AS slug_52, p8_.image_name AS image_name_53, m9_.id AS id_54, m9_.name AS name_55, m9_.slug AS slug_56, m9_.ext_source AS ext_source_57, m9_.ext_id AS ext_id_58, m10_.id AS id_59, m10_.name AS name_60, m10_.slug AS slug_61, m10_.ext_id AS ext_id_62, v11_.id AS id_63, v11_.year_from AS year_from_64, v11_.year_to AS year_to_65, v11_.generation_name AS generation_name_66, d12_.id AS id_67, d12_.description AS description_68, d12_.year AS year_69, d12_.engine_volume AS engine_volume_70, d12_.drivetrain AS drivetrain_71, d12_.fuel_type AS fuel_type_72, d12_.transmission_type AS transmission_type_73, d12_.vin AS vin_74, d12_.stock_number AS stock_number_75, d12_.slug AS slug_76, d12_.address AS address_77, d12_.created_at AS created_at_78, d13_.id AS id_79, d13_.image_name AS image_name_80, d13_.sort_order AS sort_order_81, p14_.id AS id_82, p14_.value_text AS value_text_83, p14_.value_number_from AS value_number_from_84, p14_.value_number_to AS value_number_to_85, p14_.value_json AS value_json_86, c15_.id AS id_87, c15_.code AS code_88, c15_.name_en AS name_en_89, c15_.name_es AS name_es_90, c15_.type AS type_91, c15_.sort_order AS sort_order_92, p0_.owner_id AS owner_id_93, p0_.make_id AS make_id_94, p0_.model_id AS model_id_95, p0_.vehicle_range_id AS vehicle_range_id_96, p0_.part_category_id AS part_category_id_97, p0_.dismantled_vehicle_id AS dismantled_vehicle_id_98, p1_.listing_id AS listing_id_99, c3_.user_id AS user_id_100, p4_.listing_id AS listing_id_101, p4_.make_id AS make_id_102, p4_.model_id AS model_id_103, p4_.vehicle_range_id AS vehicle_range_id_104, m6_.make_id AS make_id_105, v7_.model_id AS model_id_106, p8_.parent_id AS parent_id_107, m10_.make_id AS make_id_108, v11_.model_id AS model_id_109, d12_.owner_id AS owner_id_110, d12_.make_id AS make_id_111, d12_.model_id AS model_id_112, d12_.vehicle_range_id AS vehicle_range_id_113, d12_.auto_dismantling_id AS auto_dismantling_id_114, d13_.vehicle_id AS vehicle_id_115, p14_.listing_id AS listing_id_116, p14_.filter_id AS filter_id_117 FROM part_listings p0_ LEFT JOIN part_listing_images p1_ ON p0_.id = p1_.listing_id LEFT JOIN users u2_ ON p0_.owner_id = u2_.id INNER JOIN company_profiles c3_ ON u2_.id = c3_.user_id LEFT JOIN part_listing_fitments p4_ ON p0_.id = p4_.listing_id LEFT JOIN makes m5_ ON p4_.make_id = m5_.id LEFT JOIN models m6_ ON p4_.model_id = m6_.id LEFT JOIN vehicle_ranges v7_ ON p4_.vehicle_range_id = v7_.id LEFT JOIN part_categories p8_ ON p0_.part_category_id = p8_.id LEFT JOIN makes m9_ ON p0_.make_id = m9_.id LEFT JOIN models m10_ ON p0_.model_id = m10_.id LEFT JOIN vehicle_ranges v11_ ON p0_.vehicle_range_id = v11_.id LEFT JOIN dismantled_vehicles d12_ ON p0_.dismantled_vehicle_id = d12_.id LEFT JOIN dismantled_vehicle_photos d13_ ON d12_.id = d13_.vehicle_id LEFT JOIN part_listing_custom_filter_values p14_ ON p0_.id = p14_.listing_id LEFT JOIN custom_filters c15_ ON p14_.filter_id = c15_.id WHERE p0_.id = ? AND p0_.status = ? AND c3_.status = ?
Parameters:
[ 26 "active" "active" ]
|
||||||||||||||||||||||||||||||||
| 2 | 0.67 ms |
SELECT p0_.id AS id_0 FROM part_listings p0_ INNER JOIN users u1_ ON p0_.owner_id = u1_.id INNER JOIN company_profiles c2_ ON u1_.id = c2_.user_id WHERE p0_.dismantled_vehicle_id = ? AND p0_.id <> ? AND p0_.status = ? AND c2_.status = ? AND p0_.quantity > 0 ORDER BY p0_.created_at DESC LIMIT 12
Parameters:
[ 16 26 "active" "active" ]
|
||||||||||||||||||||||||||||||||
| 3 | 0.80 ms |
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, u2_.id AS id_17, u2_.email AS email_18, u2_.roles AS roles_19, u2_.password AS password_20, u2_.is_verified AS is_verified_21, u2_.phone AS phone_22, u2_.address_line1 AS address_line1_23, u2_.address_line2 AS address_line2_24, u2_.city AS city_25, u2_.state AS state_26, u2_.postal_code AS postal_code_27, u2_.is_company AS is_company_28, c3_.id AS id_29, c3_.company_name AS company_name_30, c3_.logo_name AS logo_name_31, c3_.ein AS ein_32, c3_.status AS status_33, c3_.submitted_at AS submitted_at_34, c3_.reviewed_at AS reviewed_at_35, p4_.id AS id_36, p4_.name AS name_37, p4_.slug AS slug_38, p4_.image_name AS image_name_39, m5_.id AS id_40, m5_.name AS name_41, m5_.slug AS slug_42, m5_.ext_source AS ext_source_43, m5_.ext_id AS ext_id_44, m6_.id AS id_45, m6_.name AS name_46, m6_.slug AS slug_47, m6_.ext_id AS ext_id_48, p0_.owner_id AS owner_id_49, p0_.make_id AS make_id_50, p0_.model_id AS model_id_51, p0_.vehicle_range_id AS vehicle_range_id_52, p0_.part_category_id AS part_category_id_53, p0_.dismantled_vehicle_id AS dismantled_vehicle_id_54, p1_.listing_id AS listing_id_55, c3_.user_id AS user_id_56, p4_.parent_id AS parent_id_57, m6_.make_id AS make_id_58 FROM part_listings p0_ LEFT JOIN part_listing_images p1_ ON p0_.id = p1_.listing_id INNER JOIN users u2_ ON p0_.owner_id = u2_.id INNER JOIN company_profiles c3_ ON u2_.id = c3_.user_id LEFT JOIN part_categories p4_ ON p0_.part_category_id = p4_.id LEFT JOIN makes m5_ ON p0_.make_id = m5_.id LEFT JOIN models m6_ ON p0_.model_id = m6_.id WHERE p0_.status = ? AND c3_.status = ? AND p0_.quantity > 0 AND p0_.id IN (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "active" "active" 30 25 27 28 29 23 24 ]
|
||||||||||||||||||||||||||||||||
| 4 | 0.40 ms |
SELECT COUNT(s0_.id) AS sclr_0 FROM seller_reviews s0_ INNER JOIN users u1_ ON s0_.seller_id = u1_.id WHERE u1_.id = ? AND s0_.status = ?
Parameters:
[ 1 "active" ]
|
||||||||||||||||||||||||||||||||
| 5 | 0.39 ms |
SELECT COALESCE(AVG(s0_.rating), 0) AS sclr_0 FROM seller_reviews s0_ INNER JOIN users u1_ ON s0_.seller_id = u1_.id WHERE u1_.id = ? AND s0_.status = ?
Parameters:
[ 1 "active" ]
|
||||||||||||||||||||||||||||||||
| 6 | 0.56 ms |
SELECT s0_.id AS id_0, s0_.rating AS rating_1, s0_.message AS message_2, s0_.status AS status_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.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, u2_.id AS id_19, u2_.email AS email_20, u2_.roles AS roles_21, u2_.password AS password_22, u2_.is_verified AS is_verified_23, u2_.phone AS phone_24, u2_.address_line1 AS address_line1_25, u2_.address_line2 AS address_line2_26, u2_.city AS city_27, u2_.state AS state_28, u2_.postal_code AS postal_code_29, u2_.is_company AS is_company_30, o3_.id AS id_31, o3_.order_index AS order_index_32, o3_.delivery_address AS delivery_address_33, o3_.phone AS phone_34, o3_.email AS email_35, o3_.delivery_method AS delivery_method_36, o3_.delivery_price AS delivery_price_37, o3_.subtotal AS subtotal_38, o3_.total AS total_39, o3_.status AS status_40, o3_.created_at AS created_at_41, s0_.order_id AS order_id_42, s0_.buyer_id AS buyer_id_43, s0_.seller_id AS seller_id_44, o3_.buyer_id AS buyer_id_45 FROM seller_reviews s0_ INNER JOIN users u1_ ON s0_.buyer_id = u1_.id INNER JOIN users u2_ ON s0_.seller_id = u2_.id INNER JOIN `orders` o3_ ON s0_.order_id = o3_.id WHERE u2_.id = ? AND s0_.status = ? ORDER BY s0_.created_at DESC LIMIT 10
Parameters:
[ 1 "active" ]
|
||||||||||||||||||||||||||||||||
| 7 | 0.30 ms |
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.logo_name AS logo_name_3, t0.ein AS ein_4, t0.status AS status_5, t0.submitted_at AS submitted_at_6, t0.reviewed_at AS reviewed_at_7, t0.user_id AS user_id_8 FROM company_profiles t0 WHERE t0.user_id = ?
Parameters:
[
10
]
|
||||||||||||||||||||||||||||||||
| 8 | 0.32 ms |
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 = ?
Parameters:
[
19
]
|
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\PartListing | No errors. |
| App\Entity\PartListingImage | No errors. |
| App\Entity\Users | No errors. |
| App\Entity\CompanyProfile | No errors. |
| App\Entity\PartListingFitment | No errors. |
| App\Entity\Make | No errors. |
| App\Entity\Model | No errors. |
| App\Entity\VehicleRange | No errors. |
| App\Entity\PartCategory | No errors. |
| App\Entity\DismantledVehicle | No errors. |
| App\Entity\DismantledVehiclePhoto | No errors. |
| App\Entity\PartListingCustomFilterValue | No errors. |
| App\Entity\CustomFilter | No errors. |
| App\Entity\AutoDismantling | No errors. |
| App\Entity\DismantledVehiclePhone | No errors. |
| App\Entity\SellerReview | No errors. |
| App\Entity\Order |
|
| App\Entity\OrderItem | No errors. |