GET https://cars.monkaidev.com/catalog?type=Plan%20de%20Ahorro

Query Metrics

12 Database Queries
9 Different statements
3.83 ms Query time
1 Invalid entities
6 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.34 ms
SELECT COUNT(v0_.id) AS sclr_0 FROM vehicle v0_ WHERE v0_.published = ? AND v0_.type = ? ORDER BY v0_.created_at DESC
Parameters:
[
  1
  "Plan de Ahorro"
]
3 0.39 ms
SELECT v0_.id AS id_0, v0_.brand AS brand_1, v0_.model AS model_2, v0_.year AS year_3, v0_.version AS version_4, v0_.type AS type_5, v0_.price_purchase AS price_purchase_6, v0_.price_sale AS price_sale_7, v0_.consignment_price AS consignment_price_8, v0_.commission AS commission_9, v0_.status AS status_10, v0_.published AS published_11, v0_.featured AS featured_12, v0_.is_unique AS is_unique_13, v0_.stock AS stock_14, v0_.mileage AS mileage_15, v0_.vehicle_condition AS vehicle_condition_16, v0_.fuel_type AS fuel_type_17, v0_.transmission AS transmission_18, v0_.color AS color_19, v0_.description AS description_20, v0_.images AS images_21, v0_.location AS location_22, v0_.currency AS currency_23, v0_.license_plate AS license_plate_24, v0_.engine_number AS engine_number_25, v0_.chassis_number AS chassis_number_26, v0_.registration_date AS registration_date_27, v0_.slug AS slug_28, v0_.tire_type AS tire_type_29, v0_.created_at AS created_at_30, v0_.updated_at AS updated_at_31, v0_.provider_id AS provider_id_32, v0_.owner_id AS owner_id_33 FROM vehicle v0_ WHERE v0_.published = ? AND v0_.type = ? ORDER BY v0_.created_at DESC LIMIT 9
Parameters:
[
  1
  "Plan de Ahorro"
]
4 0.29 ms
SELECT MIN(v0_.price_sale) AS sclr_0, MAX(v0_.price_sale) AS sclr_1 FROM vehicle v0_ WHERE v0_.published = ?
Parameters:
[
  1
]
5 0.42 ms
SELECT DISTINCT v0_.brand AS brand_0 FROM vehicle v0_ WHERE v0_.published = ? ORDER BY v0_.brand ASC
Parameters:
[
  1
]
6 0.23 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:
[]
7 0.23 ms
SELECT DISTINCT v0_.type AS type_0 FROM vehicle v0_
Parameters:
[]
8 0.41 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"
]
9 0.31 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"
]
10 0.27 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"
]
11 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
Parameters:
[]
12 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.installments_count AS installments_count_4, t0.initial_price AS initial_price_5, t0.subscriber_limit AS subscriber_limit_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM plan t0 WHERE t0.is_active = ? ORDER BY t0.created_at DESC
Parameters:
[
  1
]

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\Company 1
App\Entity\Plan 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\Plan No errors.
App\Entity\Customer No errors.
App\Entity\Employee
  • The field App\Entity\Employee#transactions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\CashTransaction#employee does not contain the required 'inversedBy: "transactions"' attribute.
App\Entity\Installment No errors.