Query Metrics
739
Database Queries
22
Different statements
343.58 ms
Query time
0
Invalid entities
724
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
202.03 ms (58.80%) |
549 |
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:
[
716115
]
|
|
41.88 ms (12.19%) |
67 |
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:
[
715
]
|
|
26.84 ms (7.81%) |
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:
[ 2246 2246 1 1 "base" "deleted" ] |
|
20.49 ms (5.96%) |
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:
[
716047
]
|
|
11.11 ms (3.23%) |
23 |
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:
[
716047
]
|
|
10.34 ms (3.01%) |
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" 716047 ] |
|
6.42 ms (1.87%) |
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:
[ 716115 676958 676959 716046 716005 716142 715781 715782 716124 716294 716233 716226 716329 672767 672766 715104 24177 884226 715967 83674 715913 715736 715735 716066 716345 715914 24305 678115 678116 716064 715867 867389 716144 24524 715161 715160 24696 884228 716293 24748 676960 676961 24761 24799 24807 715869 671745 715988 678018 678019 715435 715436 715437 716145 678110 678109 716292 715483 715484 715482 716047 716343 24903 673730 571381 136945 25031 716356 677044 677043 25087 715917 25110 715969 716146 715783 715784 716125 715566 715564 25246 715990 715565 715970 715971 715127 715128 715872 25365 25366 715940 715849 25367 25368 25376 25516 715108 716048 716049 716006 25587 681096 867385 92193 25744 715850 673733 673734 716070 672724 672723 672726 672725 39087 678020 678021 715875 25909 716213 715490 715488 716051 715489 715487 716050 715200 715201 25966 25972 867390 26215 671746 716321 716342 867387 715942 26210 716148 599946 671794 99657 761985 716325 673701 673700 867391 103547 715992 26584 715710 671733 26627 672759 102751 715975 715976 26700 26706 716350 715944 26720 716215 26792 715977 715129 677032 674659 26802 716029 26870 716164 26919 716296 716278 677038 677037 106383 716318 27003 715531 716071 715532 715530 715533 715838 715837 27041 671024 671025 27051 678456 678457 715715 27075 715716 715077 27104 715921 27105 715492 715491 716053 27125 673739 673740 27145 715751 715922 715750 677033 677034 27148 716247 716246 716291 716245 716103 716250 679110 716328 679109 716251 716252 84520 716134 716149 84523 715978 27162 715152 716135 716227 672577 672576 716181 27383 715101 10317 715924 716091 715262 715261 715785 716150 715786 716015 716016 715458 715456 716030 715457 27524 715956 715957 27525 27539 715900 27553 84524 678071 678070 27573 715980 716107 39066 716057 716055 716056 673692 673693 716299 671734 678113 678114 27741 716182 716244 716341 716093 27852 27946 715117 715118 28406 29248 83657 40443 10747 31938 28026 678022 678023 716249 28073 715084 715628 715629 28129 867388 28160 679108 679107 716352 716351 28189 715958 715541 716074 715539 715602 715540 715603 715582 715412 716017 715580 715581 715411 715579 867392 715948 28219 28231 675002 716166 672574 672575 28296 678068 678069 28320 715824 716033 675001 678112 678111 715418 715417 716018 28332 716167 715996 715901 28471 716095 716231 716353 716315 716316 672727 672728 671793 28536 28543 28545 28578 715858 715375 28608 715998 28612 675003 716168 715155 135713 715999 28761 716298 672729 672730 84525 716076 716201 715903 28997 673742 673741 600440 673696 673697 716202 716138 715982 29152 716158 715795 715796 716114 716111 716112 716113 716232 84526 716186 715842 716220 715234 29281 716354 715271 29305 715272 715843 29367 671736 716001 715905 29420 715906 715119 671747 716344 716171 29518 715883 673705 673704 678117 678118 716221 84527 716139 715661 716059 715660 29552 671749 672937 672938 84528 715725 715908 715726 715420 716159 716248 716002 29789 716041 671026 671027 716100 677035 677036 884425 672731 672732 30011 716188 715624 716195 715625 716173 716077 30218 715812 676963 676962 715092 26676 715091 677040 677039 716216 673920 673919 716072 27655 716242 716243 84519 716036 716037 29653 29654 716172 30466 30806 716211 84530 716117 716116 30274 716196 715631 715630 30317 30407 30409 673746 673745 678073 678072 867386 716204 715774 715935 30538 715773 715553 715249 715951 715552 715248 30573 716078 674657 674658 30768 102752 672573 716301 681097 884131 716045 671023 96372 716346 716300 716322 715593 715592 716003 457464 716330 715626 716197 715627 681108 884135 716004 30885 39086 716347 673694 673695 677042 677041 716101 31056 31077 715985 716079 31080 31084 716140 716320 671735 716141 ] |
|
4.17 ms (1.21%) |
7 |
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:
[
74
]
|
|
3.30 ms (0.96%) |
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 ] |
|
3.13 ms (0.91%) |
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:
[ 716115 676958 676959 716046 716005 716142 715781 715782 716124 716294 716233 716226 716329 672767 672766 715104 24177 884226 715967 83674 715913 715736 715735 716066 716345 715914 24305 678115 678116 716064 715867 867389 716144 24524 715161 715160 24696 884228 716293 24748 676960 676961 24761 24799 24807 715869 671745 715988 678018 678019 715435 715436 715437 716145 678110 678109 716292 715483 715484 715482 716047 716343 24903 673730 571381 136945 25031 716356 677044 677043 25087 715917 25110 715969 716146 715783 715784 716125 715566 715564 25246 715990 715565 715970 715971 715127 715128 715872 25365 25366 715940 715849 25367 25368 25376 25516 715108 716048 716049 716006 25587 681096 867385 92193 25744 715850 673733 673734 716070 672724 672723 672726 672725 39087 678020 678021 715875 25909 716213 715490 715488 716051 715489 715487 716050 715200 715201 25966 25972 867390 26215 671746 716321 716342 867387 715942 26210 716148 599946 671794 99657 761985 716325 673701 673700 867391 103547 715992 26584 715710 671733 26627 672759 102751 715975 715976 26700 26706 716350 715944 26720 716215 26792 715977 715129 677032 674659 26802 716029 26870 716164 26919 716296 716278 677038 677037 106383 716318 27003 715531 716071 715532 715530 715533 715838 715837 27041 671024 671025 27051 678456 678457 715715 27075 715716 715077 27104 715921 27105 715492 715491 716053 27125 673739 673740 27145 715751 715922 715750 677033 677034 27148 716247 716246 716291 716245 716103 716250 679110 716328 679109 716251 716252 84520 716134 716149 84523 715978 27162 715152 716135 716227 672577 672576 716181 27383 715101 10317 715924 716091 715262 715261 715785 716150 715786 716015 716016 715458 715456 716030 715457 27524 715956 715957 27525 27539 715900 27553 84524 678071 678070 27573 715980 716107 39066 716057 716055 716056 673692 673693 716299 671734 678113 678114 27741 716182 716244 716341 716093 27852 27946 715117 715118 28406 29248 83657 40443 10747 31938 28026 678022 678023 716249 28073 715084 715628 715629 28129 867388 28160 679108 679107 716352 716351 28189 715958 715541 716074 715539 715602 715540 715603 715582 715412 716017 715580 715581 715411 715579 867392 715948 28219 28231 675002 716166 672574 672575 28296 678068 678069 28320 715824 716033 675001 678112 678111 715418 715417 716018 28332 716167 715996 715901 28471 716095 716231 716353 716315 716316 672727 672728 671793 28536 28543 28545 28578 715858 715375 28608 715998 28612 675003 716168 715155 135713 715999 28761 716298 672729 672730 84525 716076 716201 715903 28997 673742 673741 600440 673696 673697 716202 716138 715982 29152 716158 715795 715796 716114 716111 716112 716113 716232 84526 716186 715842 716220 715234 29281 716354 715271 29305 715272 715843 29367 671736 716001 715905 29420 715906 715119 671747 716344 716171 29518 715883 673705 673704 678117 678118 716221 84527 716139 715661 716059 715660 29552 671749 672937 672938 84528 715725 715908 715726 715420 716159 716248 716002 29789 716041 671026 671027 716100 677035 677036 884425 672731 672732 30011 716188 715624 716195 715625 716173 716077 30218 715812 676963 676962 715092 26676 715091 677040 677039 716216 673920 673919 716072 27655 716242 716243 84519 716036 716037 29653 29654 716172 30466 30806 716211 84530 716117 716116 30274 716196 715631 715630 30317 30407 30409 673746 673745 678073 678072 867386 716204 715774 715935 30538 715773 715553 715249 715951 715552 715248 30573 716078 674657 674658 30768 102752 672573 716301 681097 884131 716045 671023 96372 716346 716300 716322 715593 715592 716003 457464 716330 715626 716197 715627 681108 884135 716004 30885 39086 716347 673694 673695 677042 677041 716101 31056 31077 715985 716079 31080 31084 716140 716320 671735 716141 ] |
|
2.85 ms (0.83%) |
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" 730339 ] |
|
2.62 ms (0.76%) |
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
]
|
|
2.60 ms (0.76%) |
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
]
|
|
1.82 ms (0.53%) |
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:
[
3957
]
|
|
0.86 ms (0.25%) |
4 |
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-01 23:31:02" "2026-01-01 23:31:02" ] |
|
0.81 ms (0.24%) |
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:
[
5
]
|
|
0.62 ms (0.18%) |
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"
]
|
|
0.55 ms (0.16%) |
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:
[
7
]
|
|
0.51 ms (0.15%) |
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:
[] |
|
0.25 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.parent_id = ?
Parameters:
[
10
]
|
|
0.21 ms (0.06%) |
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
]
|
|
0.15 ms (0.04%) |
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"
]
|
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 | 549 |
| Database\Entity\Musician | 68 |
| Database\Entity\Category | 34 |
| Database\Entity\ArticleKind | 25 |
| Database\Entity\Genre | 21 |
| Database\Entity\Publisher | 7 |
| Database\Entity\Shop | 6 |
| Database\Entity\Country | 4 |
| Database\Entity\ShopData | 3 |
| 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\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\Kind | No errors. |
| Database\Entity\Price | No errors. |
| Database\Entity\Tax | No errors. |
| Database\Entity\ArticleAssetUrl | No errors. |