Query Metrics
192
Database Queries
17
Different statements
66.33 ms
Query time
0
Invalid entities
137
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
38.57 ms (58.15%) |
6 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.co_name AS co_name_6, t0.join_date AS join_date_7, t0.image AS image_8, t0.roles AS roles_9, t0.password AS password_10, t0.status AS status_11, t0.type AS type_12, t0.token AS token_13 FROM user t0 WHERE t0.id = ?
Parameters:
[
15
]
|
|
5.60 ms (8.44%) |
41 |
SELECT t0.id AS id_1, t0.en_name AS en_name_2, t0.ar_name AS ar_name_3, t0.status AS status_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM car_comfort t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
|
3.35 ms (5.05%) |
18 |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.update_date AS update_date_3, t0.featured AS featured_4, t0.published AS published_5, t0.price AS price_6, t0.fab_year AS fab_year_7, t0.kms AS kms_8, t0.engine AS engine_9, t0.description AS description_10, t0.seats AS seats_11, t0.safety AS safety_12, t0.entertainment AS entertainment_13, t0.comfort AS comfort_14, t0.saled AS saled_15, t0.deleted AS deleted_16, t0.created_by_id AS created_by_id_17, t0.updated_by_id AS updated_by_id_18, t0.city_id AS city_id_19, t0.brand_id AS brand_id_20, t0.model_id AS model_id_21, t0.condition_id AS condition_id_22, t0.transmission_id AS transmission_id_23, t0.dtype_id AS dtype_id_24, t0.btype_id AS btype_id_25, t0.ftype_id AS ftype_id_26, t0.extcolor_id AS extcolor_id_27, t0.intcolor_id AS intcolor_id_28 FROM cars_info t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
18
]
|
|
3.29 ms (4.97%) |
21 |
SELECT t0.id AS id_1, t0.en_name AS en_name_2, t0.ar_name AS ar_name_3, t0.status AS status_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM car_safety t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
2
]
|
|
2.99 ms (4.50%) |
18 |
SELECT t0.id AS id_1, t0.image AS image_2, t0.car_id AS car_id_3 FROM cars_info_images t0 WHERE t0.car_id = ?
Parameters:
[
18
]
|
|
2.93 ms (4.42%) |
20 |
SELECT t0.id AS id_1, t0.en_name AS en_name_2, t0.ar_name AS ar_name_3, t0.status AS status_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM car_entertainment t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
4
]
|
|
1.91 ms (2.87%) |
14 |
SELECT t0.id AS id_1, t0.en_name AS en_name_2, t0.ar_name AS ar_name_3, t0.status AS status_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM car_seats t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
|
1.62 ms (2.44%) |
12 |
SELECT t0.id AS id_1, t0.en_name AS en_name_2, t0.ar_name AS ar_name_3, t0.hex_color AS hex_color_4, t0.status AS status_5, t0.create_date AS create_date_6, t0.update_date AS update_date_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9 FROM car_colors t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
1.27 ms (1.92%) |
9 |
SELECT t0.id AS id_1, t0.model_name AS model_name_2, t0.status AS status_3, t0.corder AS corder_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.brand_id AS brand_id_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9 FROM car_models t0 WHERE t0.id = ?
Parameters:
[
160
]
|
|
1.09 ms (1.64%) |
7 |
SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.logo AS logo_3, t0.status AS status_4, t0.corder AS corder_5, t0.create_date AS create_date_6, t0.update_date AS update_date_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9 FROM car_brands t0 WHERE t0.id = ?
Parameters:
[
20
]
|
|
0.85 ms (1.29%) |
6 |
SELECT t0.id AS id_1, t0.en_name AS en_name_2, t0.ar_name AS ar_name_3, t0.status AS status_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM car_city t0 WHERE t0.id = ?
Parameters:
[
8
]
|
|
0.64 ms (0.96%) |
5 |
SELECT t0.id AS id_1, t0.en_name AS en_name_2, t0.ar_name AS ar_name_3, t0.status AS status_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM car_conditions t0 WHERE t0.id = ?
Parameters:
[
2
]
|
|
0.53 ms (0.79%) |
4 |
SELECT t0.id AS id_1, t0.en_name AS en_name_2, t0.ar_name AS ar_name_3, t0.logo AS logo_4, t0.status AS status_5, t0.create_date AS create_date_6, t0.update_date AS update_date_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9 FROM car_body_types t0 WHERE t0.id = ?
Parameters:
[
4
]
|
|
0.50 ms (0.75%) |
4 |
SELECT t0.id AS id_1, t0.en_name AS en_name_2, t0.ar_name AS ar_name_3, t0.status AS status_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM car_transmissions t0 WHERE t0.id = ?
Parameters:
[
2
]
|
|
0.44 ms (0.67%) |
1 |
SELECT c0_.id AS id_0, c0_.create_date AS create_date_1, c0_.update_date AS update_date_2, c0_.featured AS featured_3, c0_.published AS published_4, c0_.price AS price_5, c0_.fab_year AS fab_year_6, c0_.kms AS kms_7, c0_.engine AS engine_8, c0_.description AS description_9, c0_.seats AS seats_10, c0_.safety AS safety_11, c0_.entertainment AS entertainment_12, c0_.comfort AS comfort_13, c0_.saled AS saled_14, c0_.deleted AS deleted_15, c0_.created_by_id AS created_by_id_16, c0_.updated_by_id AS updated_by_id_17, c0_.city_id AS city_id_18, c0_.brand_id AS brand_id_19, c0_.model_id AS model_id_20, c0_.condition_id AS condition_id_21, c0_.transmission_id AS transmission_id_22, c0_.dtype_id AS dtype_id_23, c0_.btype_id AS btype_id_24, c0_.ftype_id AS ftype_id_25, c0_.extcolor_id AS extcolor_id_26, c0_.intcolor_id AS intcolor_id_27 FROM cars_info c0_ WHERE c0_.saled = 1 AND c0_.deleted = 1 AND c0_.published = ? ORDER BY c0_.featured DESC, c0_.create_date DESC
Parameters:
[
2
]
|
|
0.39 ms (0.58%) |
3 |
SELECT t0.id AS id_1, t0.en_name AS en_name_2, t0.ar_name AS ar_name_3, t0.status AS status_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM car_fuel_types t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.37 ms (0.55%) |
3 |
SELECT t0.id AS id_1, t0.en_name AS en_name_2, t0.ar_name AS ar_name_3, t0.status AS status_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM car_drive_types t0 WHERE t0.id = ?
Parameters:
[
3
]
|
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\CarsInfoImages | 34 |
| App\Entity\CarsInfo | 18 |
| App\Entity\CarColors | 12 |
| App\Entity\CarBrands | 9 |
| App\Entity\CarModels | 9 |
| App\Entity\CarComfort | 9 |
| App\Entity\User | 7 |
| App\Entity\CarCity | 6 |
| App\Entity\CarSafety | 6 |
| App\Entity\CarConditions | 5 |
| App\Entity\CarEntertainment | 5 |
| App\Entity\CarTransmissions | 4 |
| App\Entity\CarBodyTypes | 4 |
| App\Entity\CarDriveTypes | 3 |
| App\Entity\CarFuelTypes | 3 |
| App\Entity\CarSeats | 3 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\CarsInfo | No errors. |
| App\Entity\User | No errors. |
| App\Entity\CarCity | No errors. |
| App\Entity\CarBrands | No errors. |
| App\Entity\CarModels | No errors. |
| App\Entity\CarConditions | No errors. |
| App\Entity\CarTransmissions | No errors. |
| App\Entity\CarDriveTypes | No errors. |
| App\Entity\CarBodyTypes | No errors. |
| App\Entity\CarFuelTypes | No errors. |
| App\Entity\CarColors | No errors. |
| App\Entity\CarsInfoImages | No errors. |
| App\Entity\CarSeats | No errors. |
| App\Entity\CarEntertainment | No errors. |
| App\Entity\CarComfort | No errors. |
| App\Entity\CarSafety | No errors. |