GET https://dev.hebu-music.com/de/kategorie/buecher.5-84/3

Response
200 OK
IP
216.73.216.104
Profiled on
Token
017022

Query Metrics

883 Database Queries
23 Different statements
223.00 ms Query time
0 Invalid entities
898 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
54.58 ms
(24.48%) 		380 
SELECT t0.code AS code_1, t0.title AS title_2, t0.description AS description_3, t0.trail AS trail_4, t0.google_key AS google_key_5, t0.is_visible AS is_visible_6, t0.rid AS rid_7, t0.state AS state_8, t0.sync AS sync_9, t0.state_at AS state_at_10, t0.id AS id_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.indexable AS indexable_14, t0.parent_id AS parent_id_15, t16.title AS title_17, t16.article_count AS article_count_18, t16.position AS position_19, t16.is_visible AS is_visible_20, t16.id AS id_21, t16.created_at AS created_at_22, t16.updated_at AS updated_at_23, t16.shop_id AS shop_id_24, t16.parent_id AS parent_id_25, t16.genre_id AS genre_id_26 FROM genres t0 LEFT JOIN categories t16 ON t16.genre_id = t0.id INNER JOIN article_genres ON t0.id = article_genres.genre_id WHERE article_genres.article_id = ?
Parameters: 
[
  66561
]
View formatted query    View runnable query    Explain query
43.55 ms
(19.53%) 		276 
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: 
[
  8864
]
View formatted query    View runnable query    Explain query
42.29 ms
(18.96%) 		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 OFFSET 48
Parameters: 
[
  66561
  102021
  135690
  842239
  861236
  85271
  535237
  679769
  317489
  756181
  422305
  760029
  823720
  535707
  84569
  513206
  633187
  503093
  826291
  138533
  303157
  71054
  98349
  422292
  103540
  150234
  600400
  600401
  600399
  217335
  722606
  136037
  102076
  564173
  825996
  548848
  823746
  135660
  69059
  67367
  50160
  68545
  48180
  46387
  48181
  66301
  84568
  66303
  572286
  66326
  45499
  45689
  8242
  135160
  66302
  83693
  56071
  45872
  52103
  65881
  65878
  46068
  67149
  66328
  66324
  71052
  57321
  51691
  455328
  79885
  68947
  19301
  46458
  111597
  68228
  71753
  71755
  71754
  68943
  47159
  110710
  46069
  94173
  72891
  64211
  64452
  64456
  498928
  819128
  45788
  48183
  108185
  65284
  46772
  83925
  67368
  134076
  78876
  53277
  53876
  67075
  56945
  48179
  83689
  56280
  56279
  81789
  83883
  66305
  58618
  46439
  52698
  94099
  72892
  86940
  72609
  72610
  54873
  45611
  65879
  65880
  65892
  72893
  62963
  535270
  47375
  95268
  88164
  78183
  88431
  107122
  64717
  84586
  87831
  48062
  175755
  53278
  81325
  78877
  52608
  81531
  68767
  108113
  79000
  94018
  81352
  66771
  73321
  81552
  94019
  71394
  94020
  72622
  737731
  220125
  842453
  87364
  89212
  93872
  67165
  532803
  258089
  50048
  655306
  655307
  91855
  722682
  547779
  67120
  591338
  135267
  767213
  605996
  219477
  653520
  571653
  636626
  457836
  306427
  89556
  128218
  453231
  457517
  412580
  858076
  151240
  572064
  362692
  824321
  453230
  457104
  618082
  600411
  137075
  575371
  600212
  548851
  600402
  777335
  81669
  644434
  96191
  737797
  420832
  136036
  218904
  138699
  153897
  572299
  521806
  878572
  377221
  842469
  363513
  138639
  93594
  258159
  85250
  572089
  760202
  106461
  106278
  46727
  409787
  409788
  529896
  317517
  858062
  633180
  81850
  574901
  571494
  750454
  150238
  303233
  527247
  422086
  820181
  67052
  79087
  258036
  138528
  138531
  138257
  572090
  759704
  759723
  296409
  65549
  139050
  139042
  139048
  139049
  139044
  139047
  139045
  139046
  139043
  47606
  58133
  571371
  571375
  571374
  600022
  722678
  81667
  84002
  88128
  220043
  84935
  139296
  66292
  349448
  109071
  842456
  65548
  541553
  303126
  735342
  737733
  138530
  224946
  225655
  224993
  224947
  219405
  224173
  722680
  408829
  722681
  614568
  150240
  215285
  555308
  65550
  317541
  572091
  457431
  63338
  89467
  89468
  826301
  773279
  306415
  50194
  50193
  50192
  50195
  50163
  50190
  45658
  50164
  50191
  67166
  67379
  67380
  645507
  600451
  46257
  47588
  303137
  603121
  735343
  879380
  411936
  413469
  303155
  823755
  424650
  826160
  633752
  618079
  150237
  825857
  603357
  99182
  87797
  286234
  66332
  362720
  178883
  804581
  103541
  84845
  618028
  248315
  84585
  527285
  570430
  149818
  151270
  566886
  102077
  63303
  457519
  96540
  138529
  138532
  136031
  136032
  315011
  412619
  633181
  93882
  153830
  861237
  637685
  68766
  296085
  534925
  535300
  820226
  556500
  78926
  773274
  805726
  527703
  633097
  66333
  72623
]
View formatted query    View runnable query    Explain query
27.23 ms
(12.21%) 		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: 
[
  150234
]
View formatted query    View runnable query    Explain query
23.01 ms
(10.32%) 		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"
  150234
]
View formatted query    View runnable query    Explain query
17.54 ms
(7.87%) 		122 
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: 
[
  442
]
View formatted query    View runnable query    Explain query
4.89 ms
(2.19%) 		10 
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: 
[
  153830
]
View formatted query    View runnable query    Explain query
3.19 ms
(1.43%) 		17 
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"
  "2025-11-08 12:44:10"
  "2025-11-08 12:44:10"
]
View formatted query    View runnable query    Explain query
1.03 ms
(0.46%) 		7 
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
0.93 ms
(0.42%) 		1 
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"
  705789
]
View formatted query    View runnable query    Explain query
0.75 ms
(0.34%) 		5 
SELECT c0_.title AS title_0, c0_.article_count AS article_count_1, c0_.position AS position_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_.parent_id AS parent_id_8, c0_.genre_id AS genre_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.56 ms
(0.25%) 		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.51 ms
(0.23%) 		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 article_genres a2_ ON a0_.id = a2_.article_id LEFT JOIN genres g1_ ON g1_.id = a2_.genre_id LEFT JOIN shop_subshops s3_ ON (s3_.shop_id = a0_.shop_id AND s3_.is_active = 1) WHERE g1_.id IN (?) AND a0_.is_saleable = 1 AND a0_.is_visible = 1 AND (a0_.shop_id = ? OR s3_.subshop_id = ?) AND a0_.state NOT IN (?, ?) ORDER BY a0_.title ASC
Parameters: 
[
  6
  5
  5
  "base"
  "deleted"
]
View formatted query    View runnable query    Explain query
0.51 ms
(0.23%) 		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.45 ms
(0.20%) 		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: 
[
  66561
  102021
  135690
  842239
  861236
  85271
  535237
  679769
  317489
  756181
  422305
  760029
  823720
  535707
  84569
  513206
  633187
  503093
  826291
  138533
  303157
  71054
  98349
  422292
  103540
  150234
  600400
  600401
  600399
  217335
  722606
  136037
  102076
  564173
  825996
  548848
  823746
  135660
  69059
  67367
  50160
  68545
  48180
  46387
  48181
  66301
  84568
  66303
  572286
  66326
  45499
  45689
  8242
  135160
  66302
  83693
  56071
  45872
  52103
  65881
  65878
  46068
  67149
  66328
  66324
  71052
  57321
  51691
  455328
  79885
  68947
  19301
  46458
  111597
  68228
  71753
  71755
  71754
  68943
  47159
  110710
  46069
  94173
  72891
  64211
  64452
  64456
  498928
  819128
  45788
  48183
  108185
  65284
  46772
  83925
  67368
  134076
  78876
  53277
  53876
  67075
  56945
  48179
  83689
  56280
  56279
  81789
  83883
  66305
  58618
  46439
  52698
  94099
  72892
  86940
  72609
  72610
  54873
  45611
  65879
  65880
  65892
  72893
  62963
  535270
  47375
  95268
  88164
  78183
  88431
  107122
  64717
  84586
  87831
  48062
  175755
  53278
  81325
  78877
  52608
  81531
  68767
  108113
  79000
  94018
  81352
  66771
  73321
  81552
  94019
  71394
  94020
  72622
  737731
  220125
  842453
  87364
  89212
  93872
  67165
  532803
  258089
  50048
  655306
  655307
  91855
  722682
  547779
  67120
  591338
  135267
  767213
  605996
  219477
  653520
  571653
  636626
  457836
  306427
  89556
  128218
  453231
  457517
  412580
  858076
  151240
  572064
  362692
  824321
  453230
  457104
  618082
  600411
  137075
  575371
  600212
  548851
  600402
  777335
  81669
  644434
  96191
  737797
  420832
  136036
  218904
  138699
  153897
  572299
  521806
  878572
  377221
  842469
  363513
  138639
  93594
  258159
  85250
  572089
  760202
  106461
  106278
  46727
  409787
  409788
  529896
  317517
  858062
  633180
  81850
  574901
  571494
  750454
  150238
  303233
  527247
  422086
  820181
  67052
  79087
  258036
  138528
  138531
  138257
  572090
  759704
  759723
  296409
  65549
  139050
  139042
  139048
  139049
  139044
  139047
  139045
  139046
  139043
  47606
  58133
  571371
  571375
  571374
  600022
  722678
  81667
  84002
  88128
  220043
  84935
  139296
  66292
  349448
  109071
  842456
  65548
  541553
  303126
  735342
  737733
  138530
  224946
  225655
  224993
  224947
  219405
  224173
  722680
  408829
  722681
  614568
  150240
  215285
  555308
  65550
  317541
  572091
  457431
  63338
  89467
  89468
  826301
  773279
  306415
  50194
  50193
  50192
  50195
  50163
  50190
  45658
  50164
  50191
  67166
  67379
  67380
  645507
  600451
  46257
  47588
  303137
  603121
  735343
  879380
  411936
  413469
  303155
  823755
  424650
  826160
  633752
  618079
  150237
  825857
  603357
  99182
  87797
  286234
  66332
  362720
  178883
  804581
  103541
  84845
  618028
  248315
  84585
  527285
  570430
  149818
  151270
  566886
  102077
  63303
  457519
  96540
  138529
  138532
  136031
  136032
  315011
  412619
  633181
  93882
  153830
  861237
  637685
  68766
  296085
  534925
  535300
  820226
  556500
  78926
  773274
  805726
  527703
  633097
  66333
  72623
]
View formatted query    View runnable query    Explain query
0.36 ms
(0.16%) 		2 
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: 
[
  8
]
View formatted query    View runnable query    Explain query
0.35 ms
(0.16%) 		2 
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: 
[
  5
]
View formatted query    View runnable query    Explain query
0.29 ms
(0.13%) 		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.id = ?
Parameters: 
[
  "5"
]
View formatted query    View runnable query    Explain query
0.29 ms
(0.13%) 		1 
SELECT t0.title AS title_1, t0.article_count AS article_count_2, t0.position AS position_3, t0.is_visible AS is_visible_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.shop_id AS shop_id_8, t0.parent_id AS parent_id_9, t0.genre_id AS genre_id_10 FROM categories t0 WHERE (t0.is_visible = ? AND t0.parent_id = ?) ORDER BY t0.position ASC
Parameters: 
[
  1
  84
]
View formatted query    View runnable query    Explain query
0.24 ms
(0.11%) 		1 
SELECT t0.title AS title_1, t0.article_count AS article_count_2, t0.position AS position_3, t0.is_visible AS is_visible_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.shop_id AS shop_id_8, t0.parent_id AS parent_id_9, t0.genre_id AS genre_id_10 FROM categories t0 WHERE t0.id = ?
Parameters: 
[
  84
]
View formatted query    View runnable query    Explain query
0.16 ms
(0.07%) 		1 
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: 
[
  3
]
View formatted query    View runnable query    Explain query
0.15 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.is_master = ? LIMIT 1
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.14 ms
(0.06%) 		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

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 380
Database\Entity\Musician 276
Database\Entity\Publisher 122
Database\Entity\Genre 47
Database\Entity\ArticleKind 26
Database\Entity\Category 24
Database\Entity\Country 9
Database\Entity\Shop 7
Database\Entity\Kind 2
Database\Entity\Address 1
Database\Entity\Currency 1
Database\Entity\Group 1
Database\Entity\Tax 1
Database\Entity\ArticleAsset 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\Genre No errors.
Database\Entity\Article No errors.
Database\Entity\Musician No errors.
Database\Entity\Group No errors.
Database\Entity\ArticleAsset No errors.
Database\Entity\ArticleChild No errors.
Database\Entity\ExternalData No errors.
Database\Entity\ArticleKind No errors.
Database\Entity\Kind No errors.
Database\Entity\Price No errors.
Database\Entity\Tax No errors.
Database\Entity\ArticleAssetUrl No errors.