GET https://api-console.kissmada.com/brands

Query Metrics

41 Database Queries
2 Different statements
9.62 ms Query time
0 Invalid entities
236 Managed entities

Queries

Group similar statements

# Time Info
1 0.73 ms
SELECT t0.id_brand AS id_brand_1, t0.name AS name_2 FROM brands t0
Parameters:
[]
2 1.16 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  35
]
3 0.27 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  31
]
4 0.25 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  34
]
5 0.21 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  19
]
6 0.21 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  27
]
7 0.19 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  20
]
8 0.22 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  2
]
9 0.20 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  15
]
10 0.19 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  38
]
11 0.21 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  25
]
12 0.20 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  11
]
13 0.20 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  33
]
14 0.21 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  32
]
15 0.19 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  16
]
16 0.20 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  14
]
17 0.19 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  7
]
18 0.20 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  1
]
19 0.20 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  29
]
20 0.17 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  22
]
21 0.20 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  23
]
22 0.22 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  13
]
23 0.19 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  37
]
24 0.19 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  40
]
25 0.18 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  10
]
26 0.18 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  30
]
27 0.20 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  6
]
28 0.21 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  3
]
29 0.18 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  12
]
30 0.18 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  9
]
31 0.18 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  17
]
32 0.18 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  28
]
33 0.18 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  26
]
34 0.20 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  24
]
35 0.19 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  39
]
36 0.21 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  5
]
37 0.22 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  21
]
38 0.20 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  8
]
39 0.19 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  36
]
40 0.18 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  18
]
41 0.18 ms
SELECT t0.id_model AS id_model_1, t0.model_key AS model_key_2, t0.id_brand AS id_brand_3 FROM brands_models t0 WHERE t0.id_brand = ?
Parameters:
[
  4
]

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\Model 196
App\Entity\Brand 40

Entities Mapping

Class Mapping errors
App\Entity\Brand No errors.
App\Entity\Model No errors.
App\Entity\ModelLang No errors.