GET https://preprod.api.agenceauto.com/es/api/make?maxPerPage=616&orderByName=ASC

Response
200 OK
Browse referrer URL
IP
66.249.78.41
Profiled on
Token
1ad533

Query Metrics

4 Database Queries
4 Different statements
1.30 ms Query time
0 Invalid entities
250 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.11 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.tax AS tax_3, t0.reference_eloa AS reference_eloa_4, t0.label AS label_5 FROM country t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "es"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.30 ms 
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.slug AS slug_2 FROM make m0_ ORDER BY m0_.name ASC) dctrn_result) dctrn_table
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.33 ms 
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, name_1 FROM (SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.slug AS slug_2 FROM make m0_) dctrn_result_inner ORDER BY name_1 ASC) dctrn_result LIMIT 616
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.55 ms 
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.slug AS slug_2 FROM make m0_ WHERE m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY m0_.name ASC
Parameters: 
[
  142
  166
  110
  214
  221
  206
  70
  183
  1
  2
  208
  174
  254
  151
  76
  3
  140
  152
  167
  4
  202
  121
  102
  145
  190
  5
  6
  146
  143
  132
  89
  230
  127
  106
  149
  181
  84
  235
  7
  8
  204
  228
  9
  73
  118
  168
  96
  86
  164
  107
  165
  72
  87
  10
  219
  11
  82
  12
  128
  177
  13
  14
  233
  15
  100
  236
  154
  217
  139
  211
  114
  117
  226
  16
  95
  213
  104
  108
  189
  248
  103
  203
  75
  83
  97
  17
  18
  137
  153
  80
  187
  19
  94
  81
  193
  116
  112
  196
  200
  20
  115
  21
  71
  250
  22
  156
  79
  23
  201
  109
  234
  24
  138
  25
  207
  26
  27
  229
  69
  28
  192
  29
  30
  126
  158
  31
  32
  33
  34
  35
  178
  162
  36
  37
  171
  38
  232
  223
  188
  198
  224
  40
  179
  125
  205
  41
  42
  241
  39
  98
  43
  257
  194
  44
  218
  45
  222
  46
  47
  251
  99
  239
  184
  191
  175
  111
  252
  48
  182
  144
  141
  169
  49
  163
  244
  253
  50
  210
  186
  170
  51
  91
  77
  90
  124
  157
  245
  85
  52
  150
  249
  53
  155
  256
  93
  101
  131
  54
  227
  209
  195
  225
  78
  247
  212
  148
  74
  55
  215
  180
  56
  172
  57
  123
  220
  58
  240
  59
  60
  61
  88
  237
  62
  242
  63
  216
  113
  122
  105
  136
  64
  185
  159
  246
  65
  120
  199
  231
  243
  147
  119
  133
  66
  255
  67
  173
  197
  68
  238
]
View formatted query    View runnable query    Explain query    View query backtrace

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\Make 249
App\Entity\Country 1

Entities Mapping

Class Mapping errors
App\Entity\Country No errors.
App\Entity\Department No errors.
App\Entity\Make No errors.
App\Entity\Model No errors.