GET https://www.fw-demoserver-1.de/musikersuche

Response
200 OK
IP
216.73.216.96
Profiled on
Token
31bb1d

Query Metrics

29 Database Queries
9 Different statements
15.48 ms Query time
0 Invalid entities
427 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
9.08 ms
(58.68%) 		21 
SELECT t0.id AS id_1, t0.title AS title_2, t0.path AS path_3, t0.html_content AS html_content_4, t0.article_description AS article_description_5, t0.article_preview_slideshow_html AS article_preview_slideshow_html_6, t0.article_tag_ids AS article_tag_ids_7, t0.article AS article_8, t0.hide_current_information AS hide_current_information_9, t0.visibility AS visibility_10, t0.author AS author_11, t0.article_section AS article_section_12, t0.creation_time AS creation_time_13, t0.edit_time AS edit_time_14 FROM pages t0 WHERE t0.path = ? LIMIT 1
Parameters: 
[
  "landesverband"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.83 ms
(11.85%) 		1 
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.first_name AS first_name_3, u0_.last_name AS last_name_4, u0_.street AS street_5, u0_.zip_code AS zip_code_6, u0_.city AS city_7, u0_.district AS district_8, u0_.latitude AS latitude_9, u0_.longitude AS longitude_10, u0_.phone AS phone_11, u0_.website AS website_12, u0_.profile_image AS profile_image_13, u0_.short_description AS short_description_14, u0_.additional_information AS additional_information_15, u0_.musician_search_visible AS musician_search_visible_16, u0_.blackboard_profile_visible AS blackboard_profile_visible_17, u0_.password AS password_18, i1_.id AS id_19, i1_.name AS name_20 FROM "user" u0_ LEFT JOIN user_instrument u2_ ON u0_.id = u2_.user_id LEFT JOIN instrument i1_ ON i1_.id = u2_.instrument_id WHERE u0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY u0_.last_name ASC, u0_.first_name ASC, u0_.id ASC, i1_.name ASC
Parameters: 
[
  104
  105
  106
  107
  109
  108
  110
  111
  112
  113
  114
  115
  117
  118
  119
  120
  121
  122
  123
  124
  126
  129
  130
  131
  133
  134
  135
  136
  137
  139
  132
  138
  140
  141
  142
  125
  127
  128
  402
  143
  144
  145
  146
  147
  148
  149
  172
  151
  152
  190
  191
  153
  155
  154
  156
  157
  158
  159
  160
  161
  162
  163
  164
  165
  166
  167
  168
  169
  170
  171
  173
  174
  175
  116
  177
  178
  179
  180
  182
  183
  185
  187
  188
  189
  192
  186
  176
  181
  184
  193
  194
  196
  195
  197
  198
  199
  200
  201
  202
  203
  204
  205
  206
  207
  208
  209
  210
  212
  211
  213
  214
  215
  216
  217
  218
  219
  221
  223
  220
  222
  224
  225
  226
  227
  228
  403
  229
  230
  231
  232
  233
  234
  235
  236
  237
  238
  239
  240
  241
  242
  243
  244
  246
  247
  250
  251
  252
  253
  254
  255
  256
  257
  260
  258
  259
  261
  245
  248
  249
  262
  263
  264
  265
  266
  267
  268
  269
  270
  271
  273
  274
  272
  275
  276
  277
  278
  280
  279
  1
  281
  282
  283
  284
  285
  286
  287
  288
  290
  404
  289
  291
  292
  293
  294
  295
  296
  297
  298
  299
  300
  301
  303
  302
  304
  305
  306
  307
  308
  309
  310
  311
  312
  313
  314
  315
  316
  317
  318
  319
  405
  406
  320
  322
  323
  321
  328
  329
  330
  331
  332
  333
  335
  336
  337
  338
  340
  407
  341
  342
  343
  344
  327
  325
  326
  334
  339
  345
  346
  347
  348
  349
  350
  351
  352
  353
  354
  355
  356
  357
  358
  359
  360
  361
  362
  324
  363
  364
  365
  366
  367
  368
  369
  370
  371
  373
  374
  375
  376
  380
  382
  383
  384
  385
  386
  388
  387
  389
  390
  408
  391
  392
  393
  394
  395
  396
  381
  409
  410
  397
  398
  400
  399
  401
  150
  372
  377
  378
  379
]
View formatted query    View runnable query    Explain query    View query backtrace
1.31 ms
(8.48%) 		1 
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.target_path AS target_path_2, m0_.sort_order AS sort_order_3, m1_.id AS id_4, m1_.name AS name_5, m1_.target_path AS target_path_6, m1_.sort_order AS sort_order_7, m0_.parent_id AS parent_id_8, m1_.parent_id AS parent_id_9 FROM Menu m0_ LEFT JOIN Menu m1_ ON m0_.parent_id = m1_.id ORDER BY m0_.sort_order ASC, m0_.id ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.69 ms
(4.47%) 		1 
SELECT DISTINCT u0_.id AS id_0 FROM "user" u0_ WHERE u0_.latitude IS NOT NULL AND u0_.longitude IS NOT NULL AND (u0_.roles LIKE ? OR u0_.roles LIKE ?) AND u0_.musician_search_visible = ? ORDER BY u0_.last_name ASC, u0_.first_name ASC, u0_.id ASC
Parameters: 
[
  "%"ROLE_MUSICIAN"%"
  "%"ROLE_TEACHER"%"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.57 ms
(3.67%) 		1 
SELECT DISTINCT u0_.id AS id_0 FROM "user" u0_ WHERE (u0_.roles LIKE ? OR u0_.roles LIKE ?) AND u0_.musician_search_visible = ? ORDER BY u0_.last_name ASC, u0_.first_name ASC, u0_.id ASC LIMIT 40
Parameters: 
[
  "%"ROLE_MUSICIAN"%"
  "%"ROLE_TEACHER"%"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.56 ms
(3.63%) 		1 
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM "user" u0_ WHERE (u0_.roles LIKE ? OR u0_.roles LIKE ?) AND u0_.musician_search_visible = ?
Parameters: 
[
  "%"ROLE_MUSICIAN"%"
  "%"ROLE_TEACHER"%"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.56 ms
(3.63%) 		1 
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.first_name AS first_name_3, u0_.last_name AS last_name_4, u0_.street AS street_5, u0_.zip_code AS zip_code_6, u0_.city AS city_7, u0_.district AS district_8, u0_.latitude AS latitude_9, u0_.longitude AS longitude_10, u0_.phone AS phone_11, u0_.website AS website_12, u0_.profile_image AS profile_image_13, u0_.short_description AS short_description_14, u0_.additional_information AS additional_information_15, u0_.musician_search_visible AS musician_search_visible_16, u0_.blackboard_profile_visible AS blackboard_profile_visible_17, u0_.password AS password_18, i1_.id AS id_19, i1_.name AS name_20 FROM "user" u0_ LEFT JOIN user_instrument u2_ ON u0_.id = u2_.user_id LEFT JOIN instrument i1_ ON i1_.id = u2_.instrument_id WHERE u0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY u0_.last_name ASC, u0_.first_name ASC, u0_.id ASC, i1_.name ASC
Parameters: 
[
  104
  105
  106
  107
  109
  108
  110
  111
  112
  113
  114
  115
  117
  118
  119
  120
  121
  122
  123
  124
  126
  129
  130
  131
  133
  134
  135
  136
  137
  139
  132
  138
  140
  141
  142
  125
  127
  128
  402
  143
]
View formatted query    View runnable query    Explain query    View query backtrace
0.48 ms
(3.10%) 		1 
SELECT i0_.id AS id_0, i0_.name AS name_1 FROM instrument i0_ ORDER BY i0_.name ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.38 ms
(2.49%) 		1 
SELECT t0.id AS id_1, t0.slot_key AS slot_key_2, t0.label AS label_3, t0.html_content AS html_content_4, t0.author AS author_5, t0.creation_time AS creation_time_6, t0.edit_time AS edit_time_7 FROM specialPages t0
Parameters: 
[]
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\User 308
App\Entity\Instrument 64
App\Entity\Menu 23
App\Entity\SpecialPage 17
App\Entity\Page 15

Entities Mapping

Class Mapping errors
App\Entity\Menu No errors.
App\Entity\Page No errors.
App\Entity\SpecialPage No errors.
App\Entity\User No errors.
App\Entity\Instrument No errors.