Query Metrics

8 Database Queries
5 Different statements
2.49 ms Query time
0 Invalid entities
8 Managed entities

Queries

Group similar statements

# Time Info
1 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.address AS address_4, t0.phone AS phone_5, t0.whatsapp AS whatsapp_6, t0.instagram AS instagram_7, t0.email AS email_8, t0.primary_color AS primary_color_9, t0.banner AS banner_10, t0.privacy AS privacy_11, t0.terms AS terms_12, t0.hero_video AS hero_video_13, t0.popup_enabled AS popup_enabled_14, t0.popup_side_text AS popup_side_text_15, t0.popup_title AS popup_title_16, t0.popup_description AS popup_description_17 FROM company t0 LIMIT 1
Parameters:
[]
2 0.42 ms
SELECT t0.id AS id_1, t0.brand AS brand_2, t0.model AS model_3, t0.year AS year_4, t0.version AS version_5, t0.type AS type_6, t0.price_purchase AS price_purchase_7, t0.price_sale AS price_sale_8, t0.consignment_price AS consignment_price_9, t0.commission AS commission_10, t0.status AS status_11, t0.published AS published_12, t0.featured AS featured_13, t0.is_unique AS is_unique_14, t0.stock AS stock_15, t0.mileage AS mileage_16, t0.vehicle_condition AS vehicle_condition_17, t0.fuel_type AS fuel_type_18, t0.transmission AS transmission_19, t0.color AS color_20, t0.description AS description_21, t0.images AS images_22, t0.location AS location_23, t0.currency AS currency_24, t0.license_plate AS license_plate_25, t0.engine_number AS engine_number_26, t0.chassis_number AS chassis_number_27, t0.registration_date AS registration_date_28, t0.slug AS slug_29, t0.tire_type AS tire_type_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.provider_id AS provider_id_33, t0.owner_id AS owner_id_34 FROM vehicle t0 WHERE t0.featured = ? AND t0.published = ? ORDER BY t0.created_at DESC LIMIT 6
Parameters:
[
  1
  1
]
3 0.19 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.title AS title_3, t0.car_model AS car_model_4 FROM happy_customer t0
Parameters:
[]
4 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.address AS address_4, t0.phone AS phone_5, t0.whatsapp AS whatsapp_6, t0.instagram AS instagram_7, t0.email AS email_8, t0.primary_color AS primary_color_9, t0.banner AS banner_10, t0.privacy AS privacy_11, t0.terms AS terms_12, t0.hero_video AS hero_video_13, t0.popup_enabled AS popup_enabled_14, t0.popup_side_text AS popup_side_text_15, t0.popup_title AS popup_title_16, t0.popup_description AS popup_description_17 FROM company t0 LIMIT 1
Parameters:
[]
5 0.28 ms
SELECT DISTINCT v0_.type AS type_0 FROM vehicle v0_
Parameters:
[]
6 0.36 ms
SELECT t0.id AS id_1, t0.brand AS brand_2, t0.model AS model_3, t0.year AS year_4, t0.version AS version_5, t0.type AS type_6, t0.price_purchase AS price_purchase_7, t0.price_sale AS price_sale_8, t0.consignment_price AS consignment_price_9, t0.commission AS commission_10, t0.status AS status_11, t0.published AS published_12, t0.featured AS featured_13, t0.is_unique AS is_unique_14, t0.stock AS stock_15, t0.mileage AS mileage_16, t0.vehicle_condition AS vehicle_condition_17, t0.fuel_type AS fuel_type_18, t0.transmission AS transmission_19, t0.color AS color_20, t0.description AS description_21, t0.images AS images_22, t0.location AS location_23, t0.currency AS currency_24, t0.license_plate AS license_plate_25, t0.engine_number AS engine_number_26, t0.chassis_number AS chassis_number_27, t0.registration_date AS registration_date_28, t0.slug AS slug_29, t0.tire_type AS tire_type_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.provider_id AS provider_id_33, t0.owner_id AS owner_id_34 FROM vehicle t0 WHERE t0.type = ? ORDER BY t0.created_at DESC LIMIT 3
Parameters:
[
  "deportivo"
]
7 0.35 ms
SELECT t0.id AS id_1, t0.brand AS brand_2, t0.model AS model_3, t0.year AS year_4, t0.version AS version_5, t0.type AS type_6, t0.price_purchase AS price_purchase_7, t0.price_sale AS price_sale_8, t0.consignment_price AS consignment_price_9, t0.commission AS commission_10, t0.status AS status_11, t0.published AS published_12, t0.featured AS featured_13, t0.is_unique AS is_unique_14, t0.stock AS stock_15, t0.mileage AS mileage_16, t0.vehicle_condition AS vehicle_condition_17, t0.fuel_type AS fuel_type_18, t0.transmission AS transmission_19, t0.color AS color_20, t0.description AS description_21, t0.images AS images_22, t0.location AS location_23, t0.currency AS currency_24, t0.license_plate AS license_plate_25, t0.engine_number AS engine_number_26, t0.chassis_number AS chassis_number_27, t0.registration_date AS registration_date_28, t0.slug AS slug_29, t0.tire_type AS tire_type_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.provider_id AS provider_id_33, t0.owner_id AS owner_id_34 FROM vehicle t0 WHERE t0.type = ? ORDER BY t0.created_at DESC LIMIT 3
Parameters:
[
  "pickup"
]
8 0.30 ms
SELECT t0.id AS id_1, t0.brand AS brand_2, t0.model AS model_3, t0.year AS year_4, t0.version AS version_5, t0.type AS type_6, t0.price_purchase AS price_purchase_7, t0.price_sale AS price_sale_8, t0.consignment_price AS consignment_price_9, t0.commission AS commission_10, t0.status AS status_11, t0.published AS published_12, t0.featured AS featured_13, t0.is_unique AS is_unique_14, t0.stock AS stock_15, t0.mileage AS mileage_16, t0.vehicle_condition AS vehicle_condition_17, t0.fuel_type AS fuel_type_18, t0.transmission AS transmission_19, t0.color AS color_20, t0.description AS description_21, t0.images AS images_22, t0.location AS location_23, t0.currency AS currency_24, t0.license_plate AS license_plate_25, t0.engine_number AS engine_number_26, t0.chassis_number AS chassis_number_27, t0.registration_date AS registration_date_28, t0.slug AS slug_29, t0.tire_type AS tire_type_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.provider_id AS provider_id_33, t0.owner_id AS owner_id_34 FROM vehicle t0 WHERE t0.type = ? ORDER BY t0.created_at DESC LIMIT 3
Parameters:
[
  "convertible"
]

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
App\Entity\Vehicle 4
App\Entity\HappyCustomer 3
App\Entity\Company 1

Entities Mapping

Class Mapping errors
App\Entity\Company No errors.
App\Entity\Vehicle No errors.
App\Entity\Provider No errors.
App\Entity\Owner No errors.
App\Entity\HappyCustomer No errors.