GET http://88.99.167.175/en/catalog/parts/27-toyota-celica-2004-rear-bumper

Response
200 OK
IP
216.73.216.47
Profiled on
Token
7fcb46

Query Metrics

9 Database Queries
8 Different statements
4.85 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
1.16 ms
(23.89%) 		1 
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: 
[
  27
  "active"
  "active"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.81 ms
(16.64%) 		1 
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
  26
  28
  29
  23
  24
]
View formatted query    View runnable query    Explain query    View query backtrace
0.66 ms
(13.60%) 		1 
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
  27
  "active"
  "active"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.59 ms
(12.06%) 		1 
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"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.58 ms
(11.87%) 		2 
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: 
[
  115
]
View formatted query    View runnable query    Explain query    View query backtrace
0.39 ms
(7.94%) 		1 
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"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.36 ms
(7.36%) 		1 
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"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.32 ms
(6.64%) 		1 
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
]
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.

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
  • The field App\Entity\Order#sellerReviews is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SellerReview#order does not contain the required 'inversedBy: "sellerReviews"' attribute.
App\Entity\OrderItem No errors.