Query Metrics
948
Database Queries
22
Different statements
391.32 ms
Query time
0
Invalid entities
1005
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
167.40 ms (42.78%) |
502 |
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:
[
33264
]
|
|
133.62 ms (34.14%) |
311 |
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:
[
7160
]
|
|
18.20 ms (4.65%) |
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" 8293 ] |
|
16.08 ms (4.11%) |
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:
[
8293
]
|
|
14.75 ms (3.77%) |
1 |
SELECT t0.title AS title_1, t0.article_nr AS article_nr_2, t0.publisher_nr AS publisher_nr_3, t0.gtin AS gtin_4, t0.rank AS rank_5, t0.duration AS duration_6, t0.difficulty AS difficulty_7, t0.difficulty_detail AS difficulty_detail_8, t0.trial_voice AS trial_voice_9, t0.sequence AS sequence_10, t0.pages AS pages_11, t0.weight AS weight_12, t0.quantity AS quantity_13, t0.delivery_time AS delivery_time_14, t0.external_nr AS external_nr_15, t0.options AS options_16, t0.indexable AS indexable_17, t0.is_catalog AS is_catalog_18, t0.is_new AS is_new_19, t0.is_slider AS is_slider_20, t0.is_saleable AS is_saleable_21, t0.is_visible AS is_visible_22, t0.rid AS rid_23, t0.state AS state_24, t0.sync AS sync_25, t0.state_at AS state_at_26, t0.id AS id_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.arranger_id AS arranger_id_30, t0.group_id AS group_id_31, t0.composer_id AS composer_id_32, t0.country_id AS country_id_33, t0.publisher_id AS publisher_id_34, t0.shop_id AS shop_id_35 FROM articles t0 WHERE ((t0.is_saleable = ? AND t0.is_visible = ?) AND t0.publisher_id = ?)
Parameters:
[ 1 1 98 ] |
|
11.38 ms (2.91%) |
24 |
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:
[
8293
]
|
|
8.23 ms (2.10%) |
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:
[ 33264 33304 33196 35960 42044 35965 33197 35945 92392 69249 820237 92455 92427 42067 92391 33308 92430 84601 35961 45336 33200 42063 94175 69770 45338 46563 33216 99802 92413 99776 96187 33176 109467 66979 33309 35972 92404 33219 33327 46569 33328 35966 353570 42048 33329 33179 33220 97838 33253 33310 42068 33254 92443 92393 92436 33255 33256 24015 99796 69645 33257 92414 99761 33258 826246 33181 42069 134979 33259 148883 35967 92454 33221 45333 33182 33222 33183 33184 600448 33223 33311 99803 46571 33316 92262 33307 99813 33312 99814 35971 45327 33185 99816 46567 33186 33261 42039 42043 73474 45340 88786 31172 363501 92415 516101 33260 92394 99804 33224 33225 33190 42070 109703 45339 92417 127034 70682 92444 33262 33193 42066 69091 457523 99777 33263 68910 33249 820208 33330 33194 603250 33265 45328 92405 92419 35970 33266 92420 33226 33313 46568 45335 35969 33267 92395 33268 103229 603079 33331 92428 45321 92396 108287 87020 87018 821346 92406 42050 109866 135193 35958 99778 69934 878518 33269 33270 33207 35959 33271 92461 92445 33198 33204 33272 92397 99817 33199 33273 99810 33227 33195 33274 92437 109810 42041 33275 33314 66449 99815 33306 33276 33277 92431 33332 92423 80672 81662 68811 33278 33280 42064 33279 33281 33333 92407 92408 92409 92410 92411 35973 92446 33315 99805 45319 33282 33283 42057 99797 820203 45343 35952 45337 33334 67803 33284 33228 33201 33229 45331 33230 42034 457474 35938 767668 99779 99806 46573 35946 45334 33335 33208 99811 33336 139018 92421 97997 45317 92402 33285 33286 33337 87021 33231 27576 33209 33232 42036 92418 35953 457414 457507 457550 99812 33233 69493 33287 42055 100496 99798 92459 33288 8293 33205 100285 45325 33203 33289 46566 33202 33234 33339 99780 33340 33338 33235 33236 33341 42045 46572 35956 33237 600134 31272 457418 33238 45323 35949 33290 136927 138640 33210 92447 33317 35954 99799 42052 33291 33211 577811 137562 92448 92462 92441 33212 35948 42049 33213 42056 73055 92449 33342 488009 94180 33214 22893 33215 92424 42046 92453 33292 35962 42054 92432 35968 33293 33239 22898 100053 99807 99781 33318 33240 99782 99792 92450 99783 45316 42071 99993 35941 99784 33241 99785 35944 45320 33294 484044 87019 33295 33343 33217 99786 99506 33242 50774 97850 33243 42065 33218 33296 33244 99793 33344 92457 33245 33345 42061 535127 33297 92460 45330 33206 33319 33346 92433 92434 35942 42058 33175 50552 45341 42035 33320 80313 33298 33177 45322 572058 33321 92463 42051 33299 35951 45342 69251 33178 33180 35943 45318 92422 35940 42059 33300 35963 35964 22923 42047 35939 45324 45332 33246 35957 99808 45344 99809 45329 137563 33187 92451 92398 33188 45326 92452 42040 33347 66133 33322 33247 42037 33302 92442 92458 33323 35955 92401 33303 33189 92464 89484 33305 87022 35947 33248 92399 42062 71253 33301 33324 33325 99800 33348 68915 228916 33250 99788 422423 42042 87023 99789 827226 99794 99790 33349 92438 35950 33191 46570 33251 93117 33192 42038 33350 138237 46565 92412 33252 92400 46564 138705 826374 92439 92435 42060 92429 99801 99795 31015 99905 99791 137628 603081 33326 ] |
|
5.96 ms (1.52%) |
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_.publisher_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:
[ 98 1 1 "base" "deleted" ] |
|
4.05 ms (1.03%) |
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:
[ 33264 33304 33196 35960 42044 35965 33197 35945 92392 69249 820237 92455 92427 42067 92391 33308 92430 84601 35961 45336 33200 42063 94175 69770 45338 46563 33216 99802 92413 99776 96187 33176 109467 66979 33309 35972 92404 33219 33327 46569 33328 35966 353570 42048 33329 33179 33220 97838 33253 33310 42068 33254 92443 92393 92436 33255 33256 24015 99796 69645 33257 92414 99761 33258 826246 33181 42069 134979 33259 148883 35967 92454 33221 45333 33182 33222 33183 33184 600448 33223 33311 99803 46571 33316 92262 33307 99813 33312 99814 35971 45327 33185 99816 46567 33186 33261 42039 42043 73474 45340 88786 31172 363501 92415 516101 33260 92394 99804 33224 33225 33190 42070 109703 45339 92417 127034 70682 92444 33262 33193 42066 69091 457523 99777 33263 68910 33249 820208 33330 33194 603250 33265 45328 92405 92419 35970 33266 92420 33226 33313 46568 45335 35969 33267 92395 33268 103229 603079 33331 92428 45321 92396 108287 87020 87018 821346 92406 42050 109866 135193 35958 99778 69934 878518 33269 33270 33207 35959 33271 92461 92445 33198 33204 33272 92397 99817 33199 33273 99810 33227 33195 33274 92437 109810 42041 33275 33314 66449 99815 33306 33276 33277 92431 33332 92423 80672 81662 68811 33278 33280 42064 33279 33281 33333 92407 92408 92409 92410 92411 35973 92446 33315 99805 45319 33282 33283 42057 99797 820203 45343 35952 45337 33334 67803 33284 33228 33201 33229 45331 33230 42034 457474 35938 767668 99779 99806 46573 35946 45334 33335 33208 99811 33336 139018 92421 97997 45317 92402 33285 33286 33337 87021 33231 27576 33209 33232 42036 92418 35953 457414 457507 457550 99812 33233 69493 33287 42055 100496 99798 92459 33288 8293 33205 100285 45325 33203 33289 46566 33202 33234 33339 99780 33340 33338 33235 33236 33341 42045 46572 35956 33237 600134 31272 457418 33238 45323 35949 33290 136927 138640 33210 92447 33317 35954 99799 42052 33291 33211 577811 137562 92448 92462 92441 33212 35948 42049 33213 42056 73055 92449 33342 488009 94180 33214 22893 33215 92424 42046 92453 33292 35962 42054 92432 35968 33293 33239 22898 100053 99807 99781 33318 33240 99782 99792 92450 99783 45316 42071 99993 35941 99784 33241 99785 35944 45320 33294 484044 87019 33295 33343 33217 99786 99506 33242 50774 97850 33243 42065 33218 33296 33244 99793 33344 92457 33245 33345 42061 535127 33297 92460 45330 33206 33319 33346 92433 92434 35942 42058 33175 50552 45341 42035 33320 80313 33298 33177 45322 572058 33321 92463 42051 33299 35951 45342 69251 33178 33180 35943 45318 92422 35940 42059 33300 35963 35964 22923 42047 35939 45324 45332 33246 35957 99808 45344 99809 45329 137563 33187 92451 92398 33188 45326 92452 42040 33347 66133 33322 33247 42037 33302 92442 92458 33323 35955 92401 33303 33189 92464 89484 33305 87022 35947 33248 92399 42062 71253 33301 33324 33325 99800 33348 68915 228916 33250 99788 422423 42042 87023 99789 827226 99794 99790 33349 92438 35950 33191 46570 33251 93117 33192 42038 33350 138237 46565 92412 33252 92400 46564 138705 826374 92439 92435 42060 92429 99801 99795 31015 99905 99791 137628 603081 33326 ] |
|
3.14 ms (0.80%) |
18 |
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-30 10:56:37" "2025-12-30 10:56:37" ] |
|
1.56 ms (0.40%) |
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.34 ms (0.34%) |
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.23 ms (0.31%) |
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" 669796 ] |
|
0.90 ms (0.23%) |
1 |
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.rid = ? LIMIT 1
Parameters:
[
421
]
|
|
0.74 ms (0.19%) |
5 |
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.69 ms (0.18%) |
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.67 ms (0.17%) |
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.60 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.27 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.18 ms (0.05%) |
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.17 ms (0.04%) |
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.17 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 | 542 |
| Database\Entity\Musician | 323 |
| Database\Entity\Genre | 49 |
| Database\Entity\Category | 34 |
| Database\Entity\ArticleKind | 28 |
| Database\Entity\Group | 7 |
| Database\Entity\Shop | 6 |
| Database\Entity\Kind | 5 |
| Database\Entity\Country | 3 |
| Database\Entity\ShopData | 3 |
| Database\Entity\Address | 1 |
| Database\Entity\Currency | 1 |
| Database\Entity\Publisher | 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\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\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. |