Query Metrics
3
Database Queries
3
Different statements
11.08 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.66 ms |
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.roles AS roles_5, t0.password AS password_6, t0.image AS image_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.agency_days_notification AS agency_days_notification_10, t0.allow_user AS allow_user_11, t0.allow_clients AS allow_clients_12, t0.allow_vehicles AS allow_vehicles_13, t0.allow_vehicles_buys AS allow_vehicles_buys_14, t0.allow_vehicles_sales AS allow_vehicles_sales_15, t0.allow_vehicles_resales AS allow_vehicles_resales_16, t0.allow_agency AS allow_agency_17, t0.allow_administration AS allow_administration_18, t0.allow_transfers AS allow_transfers_19, t0.allow_system AS allow_system_20, t0.cellphone AS cellphone_21, t0.profile_id AS profile_id_22 FROM user t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 2 | 5.93 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.year AS year_2, c0_.description AS description_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.km AS km_6, c0_.patent AS patent_7, c0_.price_purchase AS price_purchase_8, c0_.price_sale AS price_sale_9, c0_.price_currency_purchase AS price_currency_purchase_10, c0_.price_currency_sale AS price_currency_sale_11, c0_.features AS features_12, c0_.status AS status_13, c0_.engine_number AS engine_number_14, c0_.chassis_number AS chassis_number_15, c0_.type AS type_16, c0_.settlement AS settlement_17, c0_.position AS position_18, c0_.features_infoauto AS features_infoauto_19, c0_.color AS color_20, c0_.is_opportunity AS is_opportunity_21, c0_.is_0km AS is_0km_22, c0_.is_immediate_delivery AS is_immediate_delivery_23, b1_.id AS id_24, b1_.name AS name_25, b1_.image AS image_26, b1_.created_at AS created_at_27, b1_.updated_at AS updated_at_28, b1_.infoauto_id AS infoauto_id_29 FROM car c0_ LEFT JOIN brand b1_ ON c0_.brand_id = b1_.id WHERE c0_.id > ? AND c0_.status IN (?, ?) ORDER BY b1_.name ASC, c0_.name ASC
Parameters:
[ "0" "entered" "to enter" ] |
| 3 | 4.48 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.year AS year_2, c0_.description AS description_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.km AS km_6, c0_.patent AS patent_7, c0_.price_purchase AS price_purchase_8, c0_.price_sale AS price_sale_9, c0_.price_currency_purchase AS price_currency_purchase_10, c0_.price_currency_sale AS price_currency_sale_11, c0_.features AS features_12, c0_.status AS status_13, c0_.engine_number AS engine_number_14, c0_.chassis_number AS chassis_number_15, c0_.type AS type_16, c0_.settlement AS settlement_17, c0_.position AS position_18, c0_.features_infoauto AS features_infoauto_19, c0_.color AS color_20, c0_.is_opportunity AS is_opportunity_21, c0_.is_0km AS is_0km_22, c0_.is_immediate_delivery AS is_immediate_delivery_23, b1_.id AS id_24, b1_.name AS name_25, b1_.image AS image_26, b1_.created_at AS created_at_27, b1_.updated_at AS updated_at_28, b1_.infoauto_id AS infoauto_id_29, c0_.updated_by_id AS updated_by_id_30, c0_.brand_id AS brand_id_31, c0_.branches_id AS branches_id_32, c0_.destination_id AS destination_id_33 FROM car c0_ LEFT JOIN brand b1_ ON c0_.brand_id = b1_.id WHERE c0_.id > ? AND c0_.status IN (?, ?) ORDER BY b1_.name ASC, c0_.name ASC LIMIT 10
Parameters:
[ "0" "entered" "to enter" ] |
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\User | No errors. |
| App\Entity\Profile | No errors. |
| App\Entity\CarBuy | No errors. |
| App\Entity\CarSale | No errors. |
| App\Entity\Client | No errors. |
| App\Entity\CarResale | No errors. |
| App\Entity\Car | No errors. |
| App\Entity\Brand | No errors. |
| App\Entity\Branches | No errors. |
| App\Entity\Destinations | No errors. |