GET https://cars.akarat-sy.com/api/car/list/?page=1

Query Metrics

192 Database Queries
17 Different statements
66.33 ms Query time
0 Invalid entities
137 Managed entities

Grouped Statements

Show all queries

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