GET https://dev.hebu-music.com/de/musiker/ludwig-van-beethoven.19

Response
200 OK
IP
216.73.216.166
Profiled on
Token
8e5532

Query Metrics

851 Database Queries
23 Different statements
677.67 ms Query time
0 Invalid entities
886 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
237.43 ms
(35.04%) 		1 
SELECT DISTINCT a0_.title AS title_0, a0_.article_nr AS article_nr_1, a0_.publisher_nr AS publisher_nr_2, a0_.gtin AS gtin_3, a0_.rank AS rank_4, a0_.duration AS duration_5, a0_.difficulty AS difficulty_6, a0_.difficulty_detail AS difficulty_detail_7, a0_.trial_voice AS trial_voice_8, a0_.sequence AS sequence_9, a0_.pages AS pages_10, a0_.weight AS weight_11, a0_.quantity AS quantity_12, a0_.delivery_time AS delivery_time_13, a0_.external_nr AS external_nr_14, a0_.options AS options_15, a0_.indexable AS indexable_16, a0_.is_catalog AS is_catalog_17, a0_.is_new AS is_new_18, a0_.is_slider AS is_slider_19, a0_.is_saleable AS is_saleable_20, a0_.is_visible AS is_visible_21, a0_.rid AS rid_22, a0_.state AS state_23, a0_.sync AS sync_24, a0_.state_at AS state_at_25, a0_.id AS id_26, a0_.created_at AS created_at_27, a0_.updated_at AS updated_at_28, a0_.arranger_id AS arranger_id_29, a0_.group_id AS group_id_30, a0_.composer_id AS composer_id_31, a0_.country_id AS country_id_32, a0_.publisher_id AS publisher_id_33, a0_.shop_id AS shop_id_34 FROM articles a0_ LEFT JOIN shop_subshops s1_ ON (s1_.shop_id = a0_.shop_id AND s1_.is_active = 1) WHERE (a0_.arranger_id = ? OR a0_.composer_id = ?) AND a0_.is_saleable = 1 AND a0_.is_visible = 1 AND (a0_.shop_id = ? OR s1_.subshop_id = ?) AND a0_.state NOT IN (?, ?) ORDER BY a0_.title ASC
Parameters: 
[
  18
  18
  1
  1
  "base"
  "deleted"
]
View formatted query    View runnable query    Explain query
211.12 ms
(31.15%) 		395 
SELECT t0.code AS code_1, t0.title AS title_2, t0.google_key AS google_key_3, t0.rid AS rid_4, t0.state AS state_5, t0.sync AS sync_6, t0.state_at AS state_at_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.description AS description_11, t0.indexable AS indexable_12, t0.parent_id AS parent_id_13 FROM genres t0 INNER JOIN article_genres ON t0.id = article_genres.genre_id WHERE article_genres.article_id = ?
Parameters: 
[
  459825
]
View formatted query    View runnable query    Explain query
123.66 ms
(18.25%) 		215 
SELECT t0.name AS name_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.birthday AS birthday_4, t0.deathday AS deathday_5, t0.tail_sign AS tail_sign_6, t0.is_arranger AS is_arranger_7, t0.is_composer AS is_composer_8, t0.rid AS rid_9, t0.state AS state_10, t0.sync AS sync_11, t0.state_at AS state_at_12, t0.id AS id_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.description AS description_16, t0.indexable AS indexable_17, t0.musician_id AS musician_id_18, t0.tail_id AS tail_id_19, t20.name AS name_21, t20.firstname AS firstname_22, t20.lastname AS lastname_23, t20.birthday AS birthday_24, t20.deathday AS deathday_25, t20.tail_sign AS tail_sign_26, t20.is_arranger AS is_arranger_27, t20.is_composer AS is_composer_28, t20.rid AS rid_29, t20.state AS state_30, t20.sync AS sync_31, t20.state_at AS state_at_32, t20.id AS id_33, t20.created_at AS created_at_34, t20.updated_at AS updated_at_35, t20.description AS description_36, t20.indexable AS indexable_37, t20.musician_id AS musician_id_38, t20.tail_id AS tail_id_39 FROM musicians t0 LEFT JOIN musicians t20 ON t20.tail_id = t0.id WHERE t0.id = ?
Parameters: 
[
  5665
]
View formatted query    View runnable query    Explain query
29.13 ms
(4.30%) 		99 
SELECT t0.name AS name_1, t0.delivery_time AS delivery_time_2, t0.rid AS rid_3, t0.state AS state_4, t0.sync AS sync_5, t0.state_at AS state_at_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.description AS description_10, t0.indexable AS indexable_11, t0.shop_id AS shop_id_12 FROM publishers t0 WHERE t0.id = ?
Parameters: 
[
  696
]
View formatted query    View runnable query    Explain query
23.17 ms
(3.42%) 		24 
SELECT t0.title AS title_1, t0.price_chf AS price_chf_2, t0.price_eur AS price_eur_3, t0.price_usd AS price_usd_4, t0.price_attributes AS price_attributes_5, t0.tax_name AS tax_name_6, t0.quantity AS quantity_7, t0.minimum_order AS minimum_order_8, t0.minimum_stock AS minimum_stock_9, t0.filename AS filename_10, t0.sort_order AS sort_order_11, t0.is_printable AS is_printable_12, t0.is_saleable AS is_saleable_13, t0.printable_at AS printable_at_14, t0.saleable_at AS saleable_at_15, t0.rid AS rid_16, t0.state AS state_17, t0.sync AS sync_18, t0.state_at AS state_at_19, t0.id AS id_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.article_id AS article_id_23, t0.kind_id AS kind_id_24, t0.price_id AS price_id_25, t0.external_id AS external_id_26, t0.parent_id AS parent_id_27, t28.title AS title_29, t28.price_chf AS price_chf_30, t28.price_eur AS price_eur_31, t28.price_usd AS price_usd_32, t28.price_attributes AS price_attributes_33, t28.tax_name AS tax_name_34, t28.quantity AS quantity_35, t28.minimum_order AS minimum_order_36, t28.minimum_stock AS minimum_stock_37, t28.filename AS filename_38, t28.sort_order AS sort_order_39, t28.is_printable AS is_printable_40, t28.is_saleable AS is_saleable_41, t28.printable_at AS printable_at_42, t28.saleable_at AS saleable_at_43, t28.rid AS rid_44, t28.state AS state_45, t28.sync AS sync_46, t28.state_at AS state_at_47, t28.id AS id_48, t28.created_at AS created_at_49, t28.updated_at AS updated_at_50, t28.article_id AS article_id_51, t28.kind_id AS kind_id_52, t28.price_id AS price_id_53, t28.external_id AS external_id_54, t28.parent_id AS parent_id_55 FROM article_kinds t0 LEFT JOIN article_kinds t28 ON t28.parent_id = t0.id WHERE t0.article_id = ? ORDER BY t0.sort_order ASC, t0.kind_id ASC
Parameters: 
[
  93268
]
View formatted query    View runnable query    Explain query
14.74 ms
(2.17%) 		24 
SELECT t0.type AS type_1, t0.name AS name_2, t0.value AS value_3, t0.checksum AS checksum_4, t0.sort_order AS sort_order_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.article_id AS article_id_13, t0.parent_id AS parent_id_14 FROM article_assets t0 WHERE (t0.type = ? AND t0.article_id = ?) ORDER BY t0.sort_order ASC
Parameters: 
[
  "link"
  93268
]
View formatted query    View runnable query    Explain query
10.71 ms
(1.58%) 		19 
SELECT t0.type AS type_1, t0.nr AS nr_2, t0.quantity AS quantity_3, t0.delivery_time AS delivery_time_4, t0.gtin AS gtin_5, t0.publisher_nr AS publisher_nr_6, t0.arranger AS arranger_7, t0.arranger_r AS arranger_r_8, t0.composer AS composer_9, t0.composer_r AS composer_r_10, t0.publisher AS publisher_11, t0.publisher_r AS publisher_r_12, t0.title AS title_13, t0.description AS description_14, t0.picture AS picture_15, t0.picture_hash AS picture_hash_16, t0.price AS price_17, t0.tax AS tax_18, t0.price_date AS price_date_19, t0.currency AS currency_20, t0.duration AS duration_21, t0.difficulty AS difficulty_22, t0.difficulty_detail AS difficulty_detail_23, t0.pages AS pages_24, t0.weight AS weight_25, t0.genre AS genre_26, t0.sortiment AS sortiment_27, t0.sortiment_r AS sortiment_r_28, t0.category_r AS category_r_29, t0.kind AS kind_30, t0.grouping AS grouping_31, t0.sort_order AS sort_order_32, t0.flag AS flag_33, t0.is_active AS is_active_34, t0.is_catalog AS is_catalog_35, t0.is_parent AS is_parent_36, t0.is_saleable AS is_saleable_37, t0.id AS id_38, t0.created_at AS created_at_39, t0.updated_at AS updated_at_40, t0.article_id AS article_id_41, t42.title AS title_43, t42.price_chf AS price_chf_44, t42.price_eur AS price_eur_45, t42.price_usd AS price_usd_46, t42.price_attributes AS price_attributes_47, t42.tax_name AS tax_name_48, t42.quantity AS quantity_49, t42.minimum_order AS minimum_order_50, t42.minimum_stock AS minimum_stock_51, t42.filename AS filename_52, t42.sort_order AS sort_order_53, t42.is_printable AS is_printable_54, t42.is_saleable AS is_saleable_55, t42.printable_at AS printable_at_56, t42.saleable_at AS saleable_at_57, t42.rid AS rid_58, t42.state AS state_59, t42.sync AS sync_60, t42.state_at AS state_at_61, t42.id AS id_62, t42.created_at AS created_at_63, t42.updated_at AS updated_at_64, t42.article_id AS article_id_65, t42.kind_id AS kind_id_66, t42.price_id AS price_id_67, t42.external_id AS external_id_68, t42.parent_id AS parent_id_69, t0.parent_id AS parent_id_70 FROM external_data t0 LEFT JOIN article_kinds t42 ON t42.external_id = t0.id WHERE t0.article_id = ?
Parameters: 
[
  93268
]
View formatted query    View runnable query    Explain query
5.35 ms
(0.79%) 		1 
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_26 FROM (SELECT a0_.title AS title_0, a0_.article_nr AS article_nr_1, a0_.publisher_nr AS publisher_nr_2, a0_.gtin AS gtin_3, a0_.rank AS rank_4, a0_.duration AS duration_5, a0_.difficulty AS difficulty_6, a0_.difficulty_detail AS difficulty_detail_7, a0_.trial_voice AS trial_voice_8, a0_.sequence AS sequence_9, a0_.pages AS pages_10, a0_.weight AS weight_11, a0_.quantity AS quantity_12, a0_.delivery_time AS delivery_time_13, a0_.external_nr AS external_nr_14, a0_.options AS options_15, a0_.indexable AS indexable_16, a0_.is_catalog AS is_catalog_17, a0_.is_new AS is_new_18, a0_.is_slider AS is_slider_19, a0_.is_saleable AS is_saleable_20, a0_.is_visible AS is_visible_21, a0_.rid AS rid_22, a0_.state AS state_23, a0_.sync AS sync_24, a0_.state_at AS state_at_25, a0_.id AS id_26, a0_.created_at AS created_at_27, a0_.updated_at AS updated_at_28 FROM articles a0_ WHERE a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.rank DESC, a0_.title ASC, a0_.title ASC) dctrn_result) dctrn_table
Parameters: 
[
  459825
  34208
  86131
  823954
  45189
  31127
  87160
  35698
  110610
  135057
  31128
  92887
  92430
  17683
  7235
  763771
  843206
  134285
  90885
  246631
  68861
  108563
  22520
  103428
  35011
  65358
  14078
  8596
  6076
  12717
  64997
  24793
  35982
  669107
  591959
  101716
  24813
  55082
  24814
  6883
  48954
  826080
  42223
  778440
  682272
  16007
  66001
  84745
  24949
  843205
  55466
  878306
  100642
  44023
  819416
  40430
  101268
  805044
  80189
  104710
  265551
  25708
  25736
  25882
  10054
  89856
  127034
  51290
  8694
  814622
  80957
  91396
  103889
  8702
  37866
  41262
  108436
  778926
  90262
  111362
  8229
  780783
  9256
  94871
  837713
  840322
  82376
  100778
  96971
  149102
  48253
  56252
  92076
  32778
  93829
  767453
  21823
  21822
  98547
  779124
  454423
  79855
  780106
  18185
  626051
  134951
  488418
  488417
  843208
  31402
  837771
  840296
  44393
  96145
  34211
  39089
  600251
  34797
  688237
  604336
  68746
  101263
  26544
  41997
  21436
  18248
  104709
  6078
  623486
  22133
  15058
  684286
  819235
  8541
  103885
  754046
  101389
  71299
  780100
  603148
  89057
  41788
  99734
  36539
  64846
  93676
  39002
  134157
  67926
  780116
  94784
  94560
  98105
  34553
  32961
  10730
  805045
  23774
  425980
  425979
  54266
  42190
  98167
  41276
  27571
  6081
  6859
  777994
  715632
  716193
  715633
  716194
  759654
  52507
  26398
  27838
  37912
  8856
  98513
  136054
  35275
  12718
  23457
  39299
  21900
  618073
  19848
  23748
  46527
  35285
  21334
  857942
  79305
  34023
  107637
  28089
  101712
  575529
  6021
  6079
  878307
  19700
  107299
  90073
  87634
  86441
  6080
  104711
  28222
  767659
  103272
  626050
  455349
  12719
  112371
  87060
  813028
  6082
  93268
  89886
  28425
  69015
  89617
  28423
  93803
  85796
  103886
  28421
  66724
  80713
  28424
  43281
  28422
  715996
  778636
  99372
  454165
  149768
  40584
  40585
  18151
  40583
  778061
  571681
  599980
  878367
  878365
  878366
  5119
  26100
  12575
  18106
  53293
  31813
  6077
  26399
  32157
  10225
  149024
  67764
  56777
  763041
  41261
  38075
  37011
  600218
  28821
  42505
  103887
  12576
  37941
  71285
  779212
  86273
  22173
  484024
  98428
  669051
  109459
  69557
  147908
  34826
  591499
  778511
  94700
  45028
  878369
  49115
  17263
  112614
  836186
  54439
  110481
  488419
  95107
  804996
  804994
  804992
  804995
  804993
  134173
  134174
  134175
  5327
  44522
  827516
  147925
  147926
  94813
  29965
  83077
  110764
  30311
  103890
  42224
  20026
  878303
  722797
  134691
  683021
  103888
  878304
  83596
  108335
  860072
  861081
  751078
  101140
  100420
  622646
  878305
  30127
  30137
  134660
  778402
  19082
  16092
  201229
  778015
  566861
  778058
  30310
  93270
  93269
  41388
  13310
  40459
  734942
  604337
  842376
  603149
  21333
  46618
  9125
  817830
  97322
  111363
  780389
  34809
  93539
  92438
  778137
  834770
  839533
  778485
  49013
  87085
  30622
  66731
  30627
  600196
  43849
  9072
  14743
  592555
  819437
  16370
  269989
  269988
  79292
  618165
  50623
  31066
  9102
  266114
  266113
  263912
  266115
  263918
  819190
  600390
  26670
  107632
  759737
  41259
]
View formatted query    View runnable query    Explain query
4.71 ms
(0.69%) 		21 
SELECT t0_.name AS name_0, t0_.value AS value_1, t0_.valid_from AS valid_from_2, t0_.valid_until AS valid_until_3, t0_.rid AS rid_4, t0_.state AS state_5, t0_.sync AS sync_6, t0_.state_at AS state_at_7, t0_.id AS id_8, t0_.created_at AS created_at_9, t0_.updated_at AS updated_at_10 FROM taxes t0_ WHERE t0_.name = ? AND (t0_.valid_from IS NULL OR t0_.valid_from <= ?) AND (t0_.valid_until IS NULL OR t0_.valid_until >= ?) ORDER BY t0_.name ASC LIMIT 1
Parameters: 
[
  "SATZ2"
  "2026-01-02 02:21:35"
  "2026-01-02 02:21:35"
]
View formatted query    View runnable query    Explain query
4.63 ms
(0.68%) 		5 
SELECT t0.code AS code_1, t0.chf AS chf_2, t0.eur AS eur_3, t0.usd AS usd_4, t0.rid AS rid_5, t0.state AS state_6, t0.sync AS sync_7, t0.state_at AS state_at_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.publisher_id AS publisher_id_12 FROM prices t0 WHERE t0.id = ?
Parameters: 
[
  1375
]
View formatted query    View runnable query    Explain query
3.05 ms
(0.45%) 		1 
SELECT a0_.title AS title_0, a0_.article_nr AS article_nr_1, a0_.publisher_nr AS publisher_nr_2, a0_.gtin AS gtin_3, a0_.rank AS rank_4, a0_.duration AS duration_5, a0_.difficulty AS difficulty_6, a0_.difficulty_detail AS difficulty_detail_7, a0_.trial_voice AS trial_voice_8, a0_.sequence AS sequence_9, a0_.pages AS pages_10, a0_.weight AS weight_11, a0_.quantity AS quantity_12, a0_.delivery_time AS delivery_time_13, a0_.external_nr AS external_nr_14, a0_.options AS options_15, a0_.indexable AS indexable_16, a0_.is_catalog AS is_catalog_17, a0_.is_new AS is_new_18, a0_.is_slider AS is_slider_19, a0_.is_saleable AS is_saleable_20, a0_.is_visible AS is_visible_21, a0_.rid AS rid_22, a0_.state AS state_23, a0_.sync AS sync_24, a0_.state_at AS state_at_25, a0_.id AS id_26, a0_.created_at AS created_at_27, a0_.updated_at AS updated_at_28, a0_.arranger_id AS arranger_id_29, a0_.group_id AS group_id_30, a0_.composer_id AS composer_id_31, a0_.country_id AS country_id_32, a0_.publisher_id AS publisher_id_33, a0_.shop_id AS shop_id_34 FROM articles a0_ WHERE a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.rank DESC, a0_.title ASC, a0_.title ASC LIMIT 24
Parameters: 
[
  459825
  34208
  86131
  823954
  45189
  31127
  87160
  35698
  110610
  135057
  31128
  92887
  92430
  17683
  7235
  763771
  843206
  134285
  90885
  246631
  68861
  108563
  22520
  103428
  35011
  65358
  14078
  8596
  6076
  12717
  64997
  24793
  35982
  669107
  591959
  101716
  24813
  55082
  24814
  6883
  48954
  826080
  42223
  778440
  682272
  16007
  66001
  84745
  24949
  843205
  55466
  878306
  100642
  44023
  819416
  40430
  101268
  805044
  80189
  104710
  265551
  25708
  25736
  25882
  10054
  89856
  127034
  51290
  8694
  814622
  80957
  91396
  103889
  8702
  37866
  41262
  108436
  778926
  90262
  111362
  8229
  780783
  9256
  94871
  837713
  840322
  82376
  100778
  96971
  149102
  48253
  56252
  92076
  32778
  93829
  767453
  21823
  21822
  98547
  779124
  454423
  79855
  780106
  18185
  626051
  134951
  488418
  488417
  843208
  31402
  837771
  840296
  44393
  96145
  34211
  39089
  600251
  34797
  688237
  604336
  68746
  101263
  26544
  41997
  21436
  18248
  104709
  6078
  623486
  22133
  15058
  684286
  819235
  8541
  103885
  754046
  101389
  71299
  780100
  603148
  89057
  41788
  99734
  36539
  64846
  93676
  39002
  134157
  67926
  780116
  94784
  94560
  98105
  34553
  32961
  10730
  805045
  23774
  425980
  425979
  54266
  42190
  98167
  41276
  27571
  6081
  6859
  777994
  715632
  716193
  715633
  716194
  759654
  52507
  26398
  27838
  37912
  8856
  98513
  136054
  35275
  12718
  23457
  39299
  21900
  618073
  19848
  23748
  46527
  35285
  21334
  857942
  79305
  34023
  107637
  28089
  101712
  575529
  6021
  6079
  878307
  19700
  107299
  90073
  87634
  86441
  6080
  104711
  28222
  767659
  103272
  626050
  455349
  12719
  112371
  87060
  813028
  6082
  93268
  89886
  28425
  69015
  89617
  28423
  93803
  85796
  103886
  28421
  66724
  80713
  28424
  43281
  28422
  715996
  778636
  99372
  454165
  149768
  40584
  40585
  18151
  40583
  778061
  571681
  599980
  878367
  878365
  878366
  5119
  26100
  12575
  18106
  53293
  31813
  6077
  26399
  32157
  10225
  149024
  67764
  56777
  763041
  41261
  38075
  37011
  600218
  28821
  42505
  103887
  12576
  37941
  71285
  779212
  86273
  22173
  484024
  98428
  669051
  109459
  69557
  147908
  34826
  591499
  778511
  94700
  45028
  878369
  49115
  17263
  112614
  836186
  54439
  110481
  488419
  95107
  804996
  804994
  804992
  804995
  804993
  134173
  134174
  134175
  5327
  44522
  827516
  147925
  147926
  94813
  29965
  83077
  110764
  30311
  103890
  42224
  20026
  878303
  722797
  134691
  683021
  103888
  878304
  83596
  108335
  860072
  861081
  751078
  101140
  100420
  622646
  878305
  30127
  30137
  134660
  778402
  19082
  16092
  201229
  778015
  566861
  778058
  30310
  93270
  93269
  41388
  13310
  40459
  734942
  604337
  842376
  603149
  21333
  46618
  9125
  817830
  97322
  111363
  780389
  34809
  93539
  92438
  778137
  834770
  839533
  778485
  49013
  87085
  30622
  66731
  30627
  600196
  43849
  9072
  14743
  592555
  819437
  16370
  269989
  269988
  79292
  618165
  50623
  31066
  9102
  266114
  266113
  263912
  266115
  263918
  819190
  600390
  26670
  107632
  759737
  41259
]
View formatted query    View runnable query    Explain query
1.92 ms
(0.28%) 		12 
SELECT t0.type AS type_1, t0.value AS value_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.shop_id AS shop_id_6 FROM shop_data t0 WHERE (t0.type = ? AND t0.shop_id = ?) ORDER BY t0.type ASC LIMIT 1
Parameters: 
[
  "rid.catalog"
  1
]
View formatted query    View runnable query    Explain query
1.58 ms
(0.23%) 		9 
SELECT t0.code AS code_1, t0.title AS title_2, t0.google_key AS google_key_3, t0.rid AS rid_4, t0.state AS state_5, t0.sync AS sync_6, t0.state_at AS state_at_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.description AS description_11, t0.indexable AS indexable_12, t0.parent_id AS parent_id_13 FROM genres t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
1.21 ms
(0.18%) 		6 
SELECT t0.name AS name_1, t0.short AS short_2, t0.is_main AS is_main_3, t0.is_part AS is_part_4, t0.is_visible AS is_visible_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.article_id AS article_id_13 FROM kinds t0 WHERE t0.id = ?
Parameters: 
[
  20
]
View formatted query    View runnable query    Explain query
1.00 ms
(0.15%) 		1 
SELECT t0.name AS name_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.birthday AS birthday_4, t0.deathday AS deathday_5, t0.tail_sign AS tail_sign_6, t0.is_arranger AS is_arranger_7, t0.is_composer AS is_composer_8, t0.rid AS rid_9, t0.state AS state_10, t0.sync AS sync_11, t0.state_at AS state_at_12, t0.id AS id_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.description AS description_16, t0.indexable AS indexable_17, t0.musician_id AS musician_id_18, t0.tail_id AS tail_id_19, t20.name AS name_21, t20.firstname AS firstname_22, t20.lastname AS lastname_23, t20.birthday AS birthday_24, t20.deathday AS deathday_25, t20.tail_sign AS tail_sign_26, t20.is_arranger AS is_arranger_27, t20.is_composer AS is_composer_28, t20.rid AS rid_29, t20.state AS state_30, t20.sync AS sync_31, t20.state_at AS state_at_32, t20.id AS id_33, t20.created_at AS created_at_34, t20.updated_at AS updated_at_35, t20.description AS description_36, t20.indexable AS indexable_37, t20.musician_id AS musician_id_38, t20.tail_id AS tail_id_39 FROM musicians t0 LEFT JOIN musicians t20 ON t20.tail_id = t0.id WHERE t0.rid = ? LIMIT 1
Parameters: 
[
  19
]
View formatted query    View runnable query    Explain query
0.98 ms
(0.14%) 		5 
SELECT c0_.count AS count_0, c0_.position AS position_1, c0_.is_active AS is_active_2, c0_.is_visible AS is_visible_3, c0_.id AS id_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.shop_id AS shop_id_7, c0_.genre_id AS genre_id_8, c0_.parent_id AS parent_id_9 FROM categories c0_ WHERE c0_.shop_id = ? AND c0_.is_visible = 1 ORDER BY c0_.position ASC
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.84 ms
(0.12%) 		2 
SELECT t0.type AS type_1, t0.url AS url_2, t0.parameter AS parameter_3, t0.sort_order AS sort_order_4, t0.is_active AS is_active_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.asset_id AS asset_id_9 FROM article_asset_urls t0 WHERE ((t0.is_active = ? AND t0.type = ?) AND t0.asset_id = ?) ORDER BY t0.sort_order ASC
Parameters: 
[
  1
  "sound"
  469403
]
View formatted query    View runnable query    Explain query
0.77 ms
(0.11%) 		4 
SELECT t0.title AS title_1, t0.tax_name AS tax_name_2, t0.price_attributes AS price_attributes_3, t0.is_active AS is_active_4, t0.rid AS rid_5, t0.state AS state_6, t0.sync AS sync_7, t0.state_at AS state_at_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.shop_id AS shop_id_12 FROM groups t0 WHERE t0.id = ?
Parameters: 
[
  7
]
View formatted query    View runnable query    Explain query
0.69 ms
(0.10%) 		3 
SELECT c0_.code AS code_0, c0_.title AS title_1, c0_.locale AS locale_2, c0_.city_format AS city_format_3, c0_.is_default AS is_default_4, c0_.rid AS rid_5, c0_.state AS state_6, c0_.sync AS sync_7, c0_.state_at AS state_at_8, c0_.id AS id_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11, c0_.currency AS currency_12 FROM countries c0_ WHERE c0_.is_default = 1 ORDER BY c0_.id ASC LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.50 ms
(0.07%) 		1 
SELECT t0.nr AS nr_1, t0.name AS name_2, t0.mail AS mail_3, t0.vat_id AS vat_id_4, t0.background AS background_5, t0.logo AS logo_6, t0.template AS template_7, t0.url AS url_8, t0.bank_bic AS bank_bic_9, t0.bank_iban AS bank_iban_10, t0.api_username AS api_username_11, t0.api_key AS api_key_12, t0.web_key AS web_key_13, t0.is_active AS is_active_14, t0.is_master AS is_master_15, t0.id AS id_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.address_id AS address_id_19, t0.currency AS currency_20, t0.parent_id AS parent_id_21 FROM shops t0 WHERE t0.web_key = ? LIMIT 1
Parameters: 
[
  "dev.hebu-music.com"
]
View formatted query    View runnable query    Explain query
0.19 ms
(0.03%) 		1 
SELECT t0.nr AS nr_1, t0.name AS name_2, t0.mail AS mail_3, t0.vat_id AS vat_id_4, t0.background AS background_5, t0.logo AS logo_6, t0.template AS template_7, t0.url AS url_8, t0.bank_bic AS bank_bic_9, t0.bank_iban AS bank_iban_10, t0.api_username AS api_username_11, t0.api_key AS api_key_12, t0.web_key AS web_key_13, t0.is_active AS is_active_14, t0.is_master AS is_master_15, t0.id AS id_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.address_id AS address_id_19, t0.currency AS currency_20, t0.parent_id AS parent_id_21 FROM shops t0 WHERE t0.parent_id = ?
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query
0.15 ms
(0.02%) 		1 
SELECT t0.code AS code_1, t0.title AS title_2, t0.rate AS rate_3, t0.sign AS sign_4, t0.is_active AS is_active_5, t0.is_default AS is_default_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.rate_at AS rate_at_9 FROM currencies t0 WHERE t0.code = ?
Parameters: 
[
  "EUR"
]
View formatted query    View runnable query    Explain query
0.14 ms
(0.02%) 		1 
SELECT t0.nr AS nr_1, t0.name AS name_2, t0.mail AS mail_3, t0.vat_id AS vat_id_4, t0.background AS background_5, t0.logo AS logo_6, t0.template AS template_7, t0.url AS url_8, t0.bank_bic AS bank_bic_9, t0.bank_iban AS bank_iban_10, t0.api_username AS api_username_11, t0.api_key AS api_key_12, t0.web_key AS web_key_13, t0.is_active AS is_active_14, t0.is_master AS is_master_15, t0.id AS id_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.address_id AS address_id_19, t0.currency AS currency_20, t0.parent_id AS parent_id_21 FROM shops t0 WHERE t0.is_master = ? LIMIT 1
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query

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
Database\Entity\Article 395
Database\Entity\Musician 218
Database\Entity\Publisher 99
Database\Entity\Genre 65
Database\Entity\Category 34
Database\Entity\ArticleKind 33
Database\Entity\Country 13
Database\Entity\Shop 6
Database\Entity\Kind 6
Database\Entity\Price 5
Database\Entity\Group 4
Database\Entity\ShopData 3
Database\Entity\ArticleAsset 2
Database\Entity\Address 1
Database\Entity\Currency 1
Database\Entity\Tax 1

Entities Mapping

Class Mapping errors
Database\Entity\Shop No errors.
Database\Entity\Address No errors.
Database\Entity\Currency No errors.
Database\Entity\ShopBilling No errors.
Database\Entity\Category No errors.
Database\Entity\ShopData No errors.
Database\Entity\ShopKindFilename No errors.
Database\Entity\Publisher No errors.
Database\Entity\ShopSale No errors.
Database\Entity\ShopSubshop No errors.
Database\Entity\User No errors.
Database\Entity\Country No errors.
Database\Entity\State No errors.
Database\Entity\Musician No errors.
Database\Entity\Article No errors.
Database\Entity\Group No errors.
Database\Entity\ArticleAsset No errors.
Database\Entity\ArticleChild No errors.
Database\Entity\ExternalData No errors.
Database\Entity\Genre No errors.
Database\Entity\ArticleKind No errors.
Database\Entity\ArticleAssetUrl No errors.
Database\Entity\Kind No errors.
Database\Entity\Price No errors.
Database\Entity\Tax No errors.