Query Metrics
904
Database Queries
22
Different statements
352.63 ms
Query time
0
Invalid entities
938
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
230.95 ms (65.49%) |
653 |
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:
[
67482
]
|
|
33.57 ms (9.52%) |
112 |
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:
[
42459
]
|
|
19.98 ms (5.67%) |
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:
[
25234
]
|
|
14.56 ms (4.13%) |
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" 25234 ] |
|
9.94 ms (2.82%) |
19 |
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-12-29 16:01:54" "2025-12-29 16:01:54" ] |
|
9.60 ms (2.72%) |
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:
[ 67482 683055 697341 63516 869601 869602 842226 697188 139054 7193 683142 24163 15929 869595 7195 761920 47322 697249 697253 46996 688326 697428 82352 24363 54467 688323 73641 682307 68120 687442 82316 688083 565783 7479 24729 682287 65190 45277 682276 108850 687907 688322 54469 8217 92192 682514 697151 11269 42617 687140 683173 9340 73638 687108 149550 688028 7554 24930 7320 24952 697336 697053 68764 682283 52885 697283 48407 49912 25234 687111 9220 697174 33009 738844 71784 687356 687402 80260 90889 687526 688086 565848 688269 688270 687774 102727 112349 687965 8372 688321 688243 7562 697313 697463 85722 52848 25496 687592 682863 686988 738845 7329 95542 25524 683024 687474 85701 683025 25576 67506 67496 67507 67499 67497 67501 67503 67493 67498 67500 67502 67504 67494 67510 67495 67509 67505 67508 71877 682310 7184 707415 68077 687312 15987 881245 869638 90881 687516 25818 687669 99013 682674 49865 662735 25855 697460 85759 52864 687211 15972 697158 9328 687216 52868 25955 16002 687116 688399 25979 66205 687283 149528 65146 688169 688170 26035 682324 67485 761789 102717 687650 99001 85692 687483 95501 687577 67562 67568 67564 67558 67569 67559 67535 67556 67566 67572 67557 67571 67573 67563 67567 67565 67570 67560 67561 67520 67522 67524 67521 67518 67528 67532 67519 67515 67516 67526 67531 67517 67530 67533 67523 67527 67525 67529 67534 67542 67544 67550 67546 67543 67540 67541 67547 67555 67548 67538 67553 67539 67552 67554 67545 67549 67551 67582 67584 67586 67583 67580 67591 67581 67590 67596 67536 67578 67588 67594 67579 67595 67585 67589 67587 67592 682254 67593 682247 26211 682285 67481 682911 682910 682292 697085 65187 687286 26463 148723 688031 26568 26592 49867 682281 697166 22205 49863 682328 32975 697171 683036 697187 682877 682878 26701 683000 42486 26748 49913 697288 697168 22207 682858 36827 26789 26791 683051 69992 600312 682311 82354 26911 71786 687349 102726 687808 80278 697425 688392 22214 688327 36292 697206 49852 687197 565785 697181 27073 80259 687405 688264 688262 688263 45233 27144 697279 48415 683052 688324 697152 682912 78190 127008 687955 11271 15920 102716 9331 42478 697281 48410 9332 686987 7332 869608 682978 682977 682947 7943 682294 687249 101507 27512 687152 90930 45259 697020 27542 47233 687668 99005 682329 52881 108848 687906 687550 93671 22226 9333 682273 687121 22227 52883 682304 149553 687492 85704 27717 682880 27732 139161 27738 27759 27760 697214 27782 67486 7623 137665 688401 682331 697039 99522 773380 688325 682280 47286 688328 7321 697172 32979 457363 688394 682267 28113 139085 42614 687136 52050 697302 12412 24332 687631 96410 36295 687947 110185 54455 697353 65181 71876 15996 28233 28238 697180 683091 687252 63377 99007 687614 28451 23440 761725 688101 575252 82313 687439 45256 861486 52860 687206 688247 688248 42610 687143 688154 688153 102715 687720 869565 82303 682251 28712 47290 687177 682255 687240 54452 95506 53259 68763 738846 15930 9223 22237 682322 688309 101071 9320 697194 600294 682268 95505 687566 453425 80247 687383 82638 687433 65139 687272 112339 687952 687954 687953 7429 682909 29179 687882 108079 246862 29195 45272 687298 68081 42483 697219 687610 98989 687611 869624 44316 697221 42479 71855 687000 138994 682881 47319 29525 682303 52882 102631 687763 687762 687761 149531 688049 687307 69986 575231 688113 603379 682952 52454 29692 697426 82350 687518 90879 687302 68075 687858 108089 682338 9339 34793 108064 687822 67492 682354 687554 95496 71878 682290 27381 82595 682352 16000 29992 29995 45275 682300 688330 112357 697055 697153 682861 20653 682834 25389 90929 98937 22204 687120 682298 67483 571941 682942 99016 41974 578712 688177 682348 697186 15962 687089 47292 575234 688032 682755 682946 687933 110298 683093 30214 73628 9335 565840 688106 687340 69987 697154 68113 697381 697083 68115 697380 682908 90874 687509 687375 80257 47283 682330 52880 682288 68118 101087 8373 9336 16011 30667 16005 34811 45263 127599 687959 102698 687750 67484 682306 869651 682859 688329 7200 7201 673762 30884 9330 68071 687309 71872 30956 688023 139084 687275 839216 778540 49857 687189 31041 31051 682867 683049 68112 687313 45264 761856 31070 20654 773370 773371 22248 40283 697179 ] |
|
9.10 ms (2.58%) |
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:
[ 231 231 1 1 "base" "deleted" ] |
|
8.72 ms (2.47%) |
16 |
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:
[
25234
]
|
|
4.78 ms (1.36%) |
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:
[ 67482 683055 697341 63516 869601 869602 842226 697188 139054 7193 683142 24163 15929 869595 7195 761920 47322 697249 697253 46996 688326 697428 82352 24363 54467 688323 73641 682307 68120 687442 82316 688083 565783 7479 24729 682287 65190 45277 682276 108850 687907 688322 54469 8217 92192 682514 697151 11269 42617 687140 683173 9340 73638 687108 149550 688028 7554 24930 7320 24952 697336 697053 68764 682283 52885 697283 48407 49912 25234 687111 9220 697174 33009 738844 71784 687356 687402 80260 90889 687526 688086 565848 688269 688270 687774 102727 112349 687965 8372 688321 688243 7562 697313 697463 85722 52848 25496 687592 682863 686988 738845 7329 95542 25524 683024 687474 85701 683025 25576 67506 67496 67507 67499 67497 67501 67503 67493 67498 67500 67502 67504 67494 67510 67495 67509 67505 67508 71877 682310 7184 707415 68077 687312 15987 881245 869638 90881 687516 25818 687669 99013 682674 49865 662735 25855 697460 85759 52864 687211 15972 697158 9328 687216 52868 25955 16002 687116 688399 25979 66205 687283 149528 65146 688169 688170 26035 682324 67485 761789 102717 687650 99001 85692 687483 95501 687577 67562 67568 67564 67558 67569 67559 67535 67556 67566 67572 67557 67571 67573 67563 67567 67565 67570 67560 67561 67520 67522 67524 67521 67518 67528 67532 67519 67515 67516 67526 67531 67517 67530 67533 67523 67527 67525 67529 67534 67542 67544 67550 67546 67543 67540 67541 67547 67555 67548 67538 67553 67539 67552 67554 67545 67549 67551 67582 67584 67586 67583 67580 67591 67581 67590 67596 67536 67578 67588 67594 67579 67595 67585 67589 67587 67592 682254 67593 682247 26211 682285 67481 682911 682910 682292 697085 65187 687286 26463 148723 688031 26568 26592 49867 682281 697166 22205 49863 682328 32975 697171 683036 697187 682877 682878 26701 683000 42486 26748 49913 697288 697168 22207 682858 36827 26789 26791 683051 69992 600312 682311 82354 26911 71786 687349 102726 687808 80278 697425 688392 22214 688327 36292 697206 49852 687197 565785 697181 27073 80259 687405 688264 688262 688263 45233 27144 697279 48415 683052 688324 697152 682912 78190 127008 687955 11271 15920 102716 9331 42478 697281 48410 9332 686987 7332 869608 682978 682977 682947 7943 682294 687249 101507 27512 687152 90930 45259 697020 27542 47233 687668 99005 682329 52881 108848 687906 687550 93671 22226 9333 682273 687121 22227 52883 682304 149553 687492 85704 27717 682880 27732 139161 27738 27759 27760 697214 27782 67486 7623 137665 688401 682331 697039 99522 773380 688325 682280 47286 688328 7321 697172 32979 457363 688394 682267 28113 139085 42614 687136 52050 697302 12412 24332 687631 96410 36295 687947 110185 54455 697353 65181 71876 15996 28233 28238 697180 683091 687252 63377 99007 687614 28451 23440 761725 688101 575252 82313 687439 45256 861486 52860 687206 688247 688248 42610 687143 688154 688153 102715 687720 869565 82303 682251 28712 47290 687177 682255 687240 54452 95506 53259 68763 738846 15930 9223 22237 682322 688309 101071 9320 697194 600294 682268 95505 687566 453425 80247 687383 82638 687433 65139 687272 112339 687952 687954 687953 7429 682909 29179 687882 108079 246862 29195 45272 687298 68081 42483 697219 687610 98989 687611 869624 44316 697221 42479 71855 687000 138994 682881 47319 29525 682303 52882 102631 687763 687762 687761 149531 688049 687307 69986 575231 688113 603379 682952 52454 29692 697426 82350 687518 90879 687302 68075 687858 108089 682338 9339 34793 108064 687822 67492 682354 687554 95496 71878 682290 27381 82595 682352 16000 29992 29995 45275 682300 688330 112357 697055 697153 682861 20653 682834 25389 90929 98937 22204 687120 682298 67483 571941 682942 99016 41974 578712 688177 682348 697186 15962 687089 47292 575234 688032 682755 682946 687933 110298 683093 30214 73628 9335 565840 688106 687340 69987 697154 68113 697381 697083 68115 697380 682908 90874 687509 687375 80257 47283 682330 52880 682288 68118 101087 8373 9336 16011 30667 16005 34811 45263 127599 687959 102698 687750 67484 682306 869651 682859 688329 7200 7201 673762 30884 9330 68071 687309 71872 30956 688023 139084 687275 839216 778540 49857 687189 31041 31051 682867 683049 68112 687313 45264 761856 31070 20654 773370 773371 22248 40283 697179 ] |
|
2.88 ms (0.82%) |
8 |
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" 502297 ] |
|
2.14 ms (0.61%) |
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 ] |
|
1.51 ms (0.43%) |
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
]
|
|
1.22 ms (0.35%) |
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
]
|
|
0.86 ms (0.24%) |
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
]
|
|
0.69 ms (0.20%) |
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:
[
308
]
|
|
0.53 ms (0.15%) |
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.48 ms (0.14%) |
3 |
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
]
|
|
0.38 ms (0.11%) |
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.27 ms (0.08%) |
2 |
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.17 ms (0.05%) |
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.16 ms (0.05%) |
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.13 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 | 654 |
| Database\Entity\Musician | 114 |
| Database\Entity\Genre | 73 |
| Database\Entity\Category | 34 |
| Database\Entity\ArticleKind | 30 |
| Database\Entity\ArticleAsset | 8 |
| Database\Entity\Shop | 6 |
| Database\Entity\Kind | 6 |
| Database\Entity\Publisher | 3 |
| Database\Entity\ShopData | 3 |
| Database\Entity\Country | 2 |
| Database\Entity\Group | 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. |