Symfony Profiler

Query Metrics

927 Database Queries

22 Different statements

416.47 ms Query time

0 Invalid entities

1299 Managed entities

Grouped Statements

Time▼	Count	Info
229.64 ms (55.14%)	567	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: [`488073`] View formatted query View runnable query Explain query 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 = ? 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 = 488073;
108.00 ms (25.93%)	226	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: [`1723`] View formatted query View runnable query Explain query 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 = ? 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 = 1723;
17.96 ms (4.31%)	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: [`32734`] View formatted query View runnable query Explain query 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 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 = 32734 ORDER BY t0.sort_order ASC, t0.kind_id ASC;
13.00 ms (3.12%)	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" 32734`] View formatted query View runnable query Explain query 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 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 = 'link' AND t0.article_id = 32734) ORDER BY t0.sort_order ASC;
12.57 ms (3.02%)	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: [`378 1 1 "base" "deleted"`] View formatted query View runnable query Explain query 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 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 = 378 AND a0_.is_saleable = 1 AND a0_.is_visible = 1 AND (a0_.shop_id = 1 OR s1_.subshop_id = 1) AND a0_.state NOT IN ('base', 'deleted') ORDER BY a0_.title ASC;
9.75 ms (2.34%)	27	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: [`47030`] View formatted query View runnable query Explain query 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 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 = 47030 LIMIT 1;
6.20 ms (1.49%)	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 378`] View formatted query View runnable query Explain query 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 = ? ) 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 = 1 AND t0.is_visible = 1) AND t0.publisher_id = 378);
5.85 ms (1.41%)	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: [488073 54731 47212 47209 47210 47211 47214 47217 47213 47215 47216 47219 47222 47218 47221 47220 47225 47223 47224 47226 46985 49958 109443 127783 84752 54477 89184 47568 127787 66899 127784 57668 46595 69678 842467 46997 54012 100700 46058 24575 83706 84142 84868 127791 46773 54063 81068 98306 46047 51436 48352 79655 83911 49986 96307 46671 46055 50170 54493 54482 127789 54274 136832 46066 54481 49987 51006 66679 138209 77448 56993 50457 54004 57669 148736 77763 68873 53300 103068 49985 78719 77759 54490 55466 571384 87325 48655 79654 71647 65778 48658 68874 77453 56933 56935 24576 48066 56938 79014 46208 46053 63128 73488 67777 83912 48355 65941 54486 571669 100705 66672 46079 363508 46077 739421 107001 77438 51016 739419 57667 87739 77821 66674 57666 78725 858337 53622 51012 46065 83713 77439 78724 54005 64036 64038 63521 64037 64724 64723 64722 63520 64725 46154 77479 96190 81051 72981 68916 56634 63606 66673 534973 534974 534975 457505 127495 53264 80334 82920 842466 127788 82924 79635 24582 82425 861678 47572 46074 50628 57193 86014 46821 94185 57317 78723 86712 51015 875806 46209 54496 106438 54479 98282 50627 72998 79725 65777 458704 457459 67620 24577 54001 859023 84345 50602 52167 82931 77824 80926 83598 77452 46152 68942 73002 51008 89315 96268 95988 56395 95934 107000 106826 46082 565778 878491 565780 484048 457460 67050 24578 572152 77442 54008 66680 102263 48657 67617 824931 565779 55677 82857 48119 84869 57176 623040 106671 51009 106404 46067 48118 66677 93593 64743 65779 73092 739420 64380 66016 138745 47567 24579 47574 66705 135881 66779 79639 24580 66865 73024 88710 127786 84009 572269 575282 73003 63129 148893 54478 79656 50624 47570 71644 111002 135252 47569 77823 66225 32732 78035 67779 50686 54031 79098 57194 48354 46084 78722 77820 66675 106546 84803 46083 46061 46064 127790 66682 80793 66676 46052 127785 46060 77432 66085 82858 89521 24583 64739 488001 457461 57120 127674 56281 54113 56277 56276 48120 46051 53234 92787 24581 64319 57913 46048 93592 488049 100765 24584 78721 83607 83608 83609 83610 83611 83612 83613 83614 83615 83616 83617 83659 83618 83619 83620 83621 83622 83623 83624 83625 46078 106999 102261 72909 100851 70330 82922 66681 64741 57665 83893 127711 98537 81760 136833 53293 84342 66671 58483 88635 89268 89267 45681 57197 81895 101892 48084 67778 861273 32733 47576 54010 66683 47573 54002 81381 77476 46062 51013 89270 51014 70798 54759 48353 73000 24585 84402 89317 81081 54494 32734 71645 81355 46785 78727 53233 110381 48083 54483 57195 77474 46998 51435 57196 77480 72613 72616 72614 72615 46596 92738 83910 81070 67618 66640 48068 78720 50410 66678 67070 46820 106827 32737 68559 53880 51010 77472 139112 54691 48656 67769 46081 77437 77475 46046 95938 70575 826631 50802 77486 67815 54495 127782 54011 46816 54480 77762 77764 77473 574943 85367 24586 83299 46080 47578 47566 46057 100767 71643 92367 54758 67057 77477 95212 71646 96196 64740 64738 64742 72491 54484 52607 84321 73492 54488 54489 54492 54497 739422 53314 32735 54485 87869 53312 46822 32740 68723 66721 46054 71648 87358 83297 46063 83724 46819 92212 87870 66223 139109 137612 139107 92809 139102 54003 79094 67768 73099 72618 72619 63018 63021 70636 70635 72627 72628 66756 82932 50625 32738 54061 88685 32739 32736 54009 51007 67619 68407 68771 79887 68778 46073 48659 81382 64737 82928 89322 77822 111118 46056 102262 51011 100766 46817 47577 78065 56274 54487 54062 46050 66780 54006 72624 72626 79588 72625 66224 47579 47575 47571] View formatted query View runnable query Explain query 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 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 (488073, 54731, 47212, 47209, 47210, 47211, 47214, 47217, 47213, 47215, 47216, 47219, 47222, 47218, 47221, 47220, 47225, 47223, 47224, 47226, 46985, 49958, 109443, 127783, 84752, 54477, 89184, 47568, 127787, 66899, 127784, 57668, 46595, 69678, 842467, 46997, 54012, 100700, 46058, 24575, 83706, 84142, 84868, 127791, 46773, 54063, 81068, 98306, 46047, 51436, 48352, 79655, 83911, 49986, 96307, 46671, 46055, 50170, 54493, 54482, 127789, 54274, 136832, 46066, 54481, 49987, 51006, 66679, 138209, 77448, 56993, 50457, 54004, 57669, 148736, 77763, 68873, 53300, 103068, 49985, 78719, 77759, 54490, 55466, 571384, 87325, 48655, 79654, 71647, 65778, 48658, 68874, 77453, 56933, 56935, 24576, 48066, 56938, 79014, 46208, 46053, 63128, 73488, 67777, 83912, 48355, 65941, 54486, 571669, 100705, 66672, 46079, 363508, 46077, 739421, 107001, 77438, 51016, 739419, 57667, 87739, 77821, 66674, 57666, 78725, 858337, 53622, 51012, 46065, 83713, 77439, 78724, 54005, 64036, 64038, 63521, 64037, 64724, 64723, 64722, 63520, 64725, 46154, 77479, 96190, 81051, 72981, 68916, 56634, 63606, 66673, 534973, 534974, 534975, 457505, 127495, 53264, 80334, 82920, 842466, 127788, 82924, 79635, 24582, 82425, 861678, 47572, 46074, 50628, 57193, 86014, 46821, 94185, 57317, 78723, 86712, 51015, 875806, 46209, 54496, 106438, 54479, 98282, 50627, 72998, 79725, 65777, 458704, 457459, 67620, 24577, 54001, 859023, 84345, 50602, 52167, 82931, 77824, 80926, 83598, 77452, 46152, 68942, 73002, 51008, 89315, 96268, 95988, 56395, 95934, 107000, 106826, 46082, 565778, 878491, 565780, 484048, 457460, 67050, 24578, 572152, 77442, 54008, 66680, 102263, 48657, 67617, 824931, 565779, 55677, 82857, 48119, 84869, 57176, 623040, 106671, 51009, 106404, 46067, 48118, 66677, 93593, 64743, 65779, 73092, 739420, 64380, 66016, 138745, 47567, 24579, 47574, 66705, 135881, 66779, 79639, 24580, 66865, 73024, 88710, 127786, 84009, 572269, 575282, 73003, 63129, 148893, 54478, 79656, 50624, 47570, 71644, 111002, 135252, 47569, 77823, 66225, 32732, 78035, 67779, 50686, 54031, 79098, 57194, 48354, 46084, 78722, 77820, 66675, 106546, 84803, 46083, 46061, 46064, 127790, 66682, 80793, 66676, 46052, 127785, 46060, 77432, 66085, 82858, 89521, 24583, 64739, 488001, 457461, 57120, 127674, 56281, 54113, 56277, 56276, 48120, 46051, 53234, 92787, 24581, 64319, 57913, 46048, 93592, 488049, 100765, 24584, 78721, 83607, 83608, 83609, 83610, 83611, 83612, 83613, 83614, 83615, 83616, 83617, 83659, 83618, 83619, 83620, 83621, 83622, 83623, 83624, 83625, 46078, 106999, 102261, 72909, 100851, 70330, 82922, 66681, 64741, 57665, 83893, 127711, 98537, 81760, 136833, 53293, 84342, 66671, 58483, 88635, 89268, 89267, 45681, 57197, 81895, 101892, 48084, 67778, 861273, 32733, 47576, 54010, 66683, 47573, 54002, 81381, 77476, 46062, 51013, 89270, 51014, 70798, 54759, 48353, 73000, 24585, 84402, 89317, 81081, 54494, 32734, 71645, 81355, 46785, 78727, 53233, 110381, 48083, 54483, 57195, 77474, 46998, 51435, 57196, 77480, 72613, 72616, 72614, 72615, 46596, 92738, 83910, 81070, 67618, 66640, 48068, 78720, 50410, 66678, 67070, 46820, 106827, 32737, 68559, 53880, 51010, 77472, 139112, 54691, 48656, 67769, 46081, 77437, 77475, 46046, 95938, 70575, 826631, 50802, 77486, 67815, 54495, 127782, 54011, 46816, 54480, 77762, 77764, 77473, 574943, 85367, 24586, 83299, 46080, 47578, 47566, 46057, 100767, 71643, 92367, 54758, 67057, 77477, 95212, 71646, 96196, 64740, 64738, 64742, 72491, 54484, 52607, 84321, 73492, 54488, 54489, 54492, 54497, 739422, 53314, 32735, 54485, 87869, 53312, 46822, 32740, 68723, 66721, 46054, 71648, 87358, 83297, 46063, 83724, 46819, 92212, 87870, 66223, 139109, 137612, 139107, 92809, 139102, 54003, 79094, 67768, 73099, 72618, 72619, 63018, 63021, 70636, 70635, 72627, 72628, 66756, 82932, 50625, 32738, 54061, 88685, 32739, 32736, 54009, 51007, 67619, 68407, 68771, 79887, 68778, 46073, 48659, 81382, 64737, 82928, 89322, 77822, 111118, 46056, 102262, 51011, 100766, 46817, 47577, 78065, 56274, 54487, 54062, 46050, 66780, 54006, 72624, 72626, 79588, 72625, 66224, 47579, 47575, 47571) ORDER BY a0_.rank DESC, a0_.title ASC, a0_.title ASC) dctrn_result) dctrn_table;
2.91 ms (0.70%)	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-11-08 11:17:04" "2025-11-08 11:17:04"`] View formatted query View runnable query Explain query 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 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 = 'SATZ2' AND (t0_.valid_from IS NULL OR t0_.valid_from <= '2025-11-08 11:17:04') AND (t0_.valid_until IS NULL OR t0_.valid_until >= '2025-11-08 11:17:04') ORDER BY t0_.name ASC LIMIT 1;
2.89 ms (0.69%)	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: [488073 54731 47212 47209 47210 47211 47214 47217 47213 47215 47216 47219 47222 47218 47221 47220 47225 47223 47224 47226 46985 49958 109443 127783 84752 54477 89184 47568 127787 66899 127784 57668 46595 69678 842467 46997 54012 100700 46058 24575 83706 84142 84868 127791 46773 54063 81068 98306 46047 51436 48352 79655 83911 49986 96307 46671 46055 50170 54493 54482 127789 54274 136832 46066 54481 49987 51006 66679 138209 77448 56993 50457 54004 57669 148736 77763 68873 53300 103068 49985 78719 77759 54490 55466 571384 87325 48655 79654 71647 65778 48658 68874 77453 56933 56935 24576 48066 56938 79014 46208 46053 63128 73488 67777 83912 48355 65941 54486 571669 100705 66672 46079 363508 46077 739421 107001 77438 51016 739419 57667 87739 77821 66674 57666 78725 858337 53622 51012 46065 83713 77439 78724 54005 64036 64038 63521 64037 64724 64723 64722 63520 64725 46154 77479 96190 81051 72981 68916 56634 63606 66673 534973 534974 534975 457505 127495 53264 80334 82920 842466 127788 82924 79635 24582 82425 861678 47572 46074 50628 57193 86014 46821 94185 57317 78723 86712 51015 875806 46209 54496 106438 54479 98282 50627 72998 79725 65777 458704 457459 67620 24577 54001 859023 84345 50602 52167 82931 77824 80926 83598 77452 46152 68942 73002 51008 89315 96268 95988 56395 95934 107000 106826 46082 565778 878491 565780 484048 457460 67050 24578 572152 77442 54008 66680 102263 48657 67617 824931 565779 55677 82857 48119 84869 57176 623040 106671 51009 106404 46067 48118 66677 93593 64743 65779 73092 739420 64380 66016 138745 47567 24579 47574 66705 135881 66779 79639 24580 66865 73024 88710 127786 84009 572269 575282 73003 63129 148893 54478 79656 50624 47570 71644 111002 135252 47569 77823 66225 32732 78035 67779 50686 54031 79098 57194 48354 46084 78722 77820 66675 106546 84803 46083 46061 46064 127790 66682 80793 66676 46052 127785 46060 77432 66085 82858 89521 24583 64739 488001 457461 57120 127674 56281 54113 56277 56276 48120 46051 53234 92787 24581 64319 57913 46048 93592 488049 100765 24584 78721 83607 83608 83609 83610 83611 83612 83613 83614 83615 83616 83617 83659 83618 83619 83620 83621 83622 83623 83624 83625 46078 106999 102261 72909 100851 70330 82922 66681 64741 57665 83893 127711 98537 81760 136833 53293 84342 66671 58483 88635 89268 89267 45681 57197 81895 101892 48084 67778 861273 32733 47576 54010 66683 47573 54002 81381 77476 46062 51013 89270 51014 70798 54759 48353 73000 24585 84402 89317 81081 54494 32734 71645 81355 46785 78727 53233 110381 48083 54483 57195 77474 46998 51435 57196 77480 72613 72616 72614 72615 46596 92738 83910 81070 67618 66640 48068 78720 50410 66678 67070 46820 106827 32737 68559 53880 51010 77472 139112 54691 48656 67769 46081 77437 77475 46046 95938 70575 826631 50802 77486 67815 54495 127782 54011 46816 54480 77762 77764 77473 574943 85367 24586 83299 46080 47578 47566 46057 100767 71643 92367 54758 67057 77477 95212 71646 96196 64740 64738 64742 72491 54484 52607 84321 73492 54488 54489 54492 54497 739422 53314 32735 54485 87869 53312 46822 32740 68723 66721 46054 71648 87358 83297 46063 83724 46819 92212 87870 66223 139109 137612 139107 92809 139102 54003 79094 67768 73099 72618 72619 63018 63021 70636 70635 72627 72628 66756 82932 50625 32738 54061 88685 32739 32736 54009 51007 67619 68407 68771 79887 68778 46073 48659 81382 64737 82928 89322 77822 111118 46056 102262 51011 100766 46817 47577 78065 56274 54487 54062 46050 66780 54006 72624 72626 79588 72625 66224 47579 47575 47571] View formatted query View runnable query Explain query 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 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 (488073, 54731, 47212, 47209, 47210, 47211, 47214, 47217, 47213, 47215, 47216, 47219, 47222, 47218, 47221, 47220, 47225, 47223, 47224, 47226, 46985, 49958, 109443, 127783, 84752, 54477, 89184, 47568, 127787, 66899, 127784, 57668, 46595, 69678, 842467, 46997, 54012, 100700, 46058, 24575, 83706, 84142, 84868, 127791, 46773, 54063, 81068, 98306, 46047, 51436, 48352, 79655, 83911, 49986, 96307, 46671, 46055, 50170, 54493, 54482, 127789, 54274, 136832, 46066, 54481, 49987, 51006, 66679, 138209, 77448, 56993, 50457, 54004, 57669, 148736, 77763, 68873, 53300, 103068, 49985, 78719, 77759, 54490, 55466, 571384, 87325, 48655, 79654, 71647, 65778, 48658, 68874, 77453, 56933, 56935, 24576, 48066, 56938, 79014, 46208, 46053, 63128, 73488, 67777, 83912, 48355, 65941, 54486, 571669, 100705, 66672, 46079, 363508, 46077, 739421, 107001, 77438, 51016, 739419, 57667, 87739, 77821, 66674, 57666, 78725, 858337, 53622, 51012, 46065, 83713, 77439, 78724, 54005, 64036, 64038, 63521, 64037, 64724, 64723, 64722, 63520, 64725, 46154, 77479, 96190, 81051, 72981, 68916, 56634, 63606, 66673, 534973, 534974, 534975, 457505, 127495, 53264, 80334, 82920, 842466, 127788, 82924, 79635, 24582, 82425, 861678, 47572, 46074, 50628, 57193, 86014, 46821, 94185, 57317, 78723, 86712, 51015, 875806, 46209, 54496, 106438, 54479, 98282, 50627, 72998, 79725, 65777, 458704, 457459, 67620, 24577, 54001, 859023, 84345, 50602, 52167, 82931, 77824, 80926, 83598, 77452, 46152, 68942, 73002, 51008, 89315, 96268, 95988, 56395, 95934, 107000, 106826, 46082, 565778, 878491, 565780, 484048, 457460, 67050, 24578, 572152, 77442, 54008, 66680, 102263, 48657, 67617, 824931, 565779, 55677, 82857, 48119, 84869, 57176, 623040, 106671, 51009, 106404, 46067, 48118, 66677, 93593, 64743, 65779, 73092, 739420, 64380, 66016, 138745, 47567, 24579, 47574, 66705, 135881, 66779, 79639, 24580, 66865, 73024, 88710, 127786, 84009, 572269, 575282, 73003, 63129, 148893, 54478, 79656, 50624, 47570, 71644, 111002, 135252, 47569, 77823, 66225, 32732, 78035, 67779, 50686, 54031, 79098, 57194, 48354, 46084, 78722, 77820, 66675, 106546, 84803, 46083, 46061, 46064, 127790, 66682, 80793, 66676, 46052, 127785, 46060, 77432, 66085, 82858, 89521, 24583, 64739, 488001, 457461, 57120, 127674, 56281, 54113, 56277, 56276, 48120, 46051, 53234, 92787, 24581, 64319, 57913, 46048, 93592, 488049, 100765, 24584, 78721, 83607, 83608, 83609, 83610, 83611, 83612, 83613, 83614, 83615, 83616, 83617, 83659, 83618, 83619, 83620, 83621, 83622, 83623, 83624, 83625, 46078, 106999, 102261, 72909, 100851, 70330, 82922, 66681, 64741, 57665, 83893, 127711, 98537, 81760, 136833, 53293, 84342, 66671, 58483, 88635, 89268, 89267, 45681, 57197, 81895, 101892, 48084, 67778, 861273, 32733, 47576, 54010, 66683, 47573, 54002, 81381, 77476, 46062, 51013, 89270, 51014, 70798, 54759, 48353, 73000, 24585, 84402, 89317, 81081, 54494, 32734, 71645, 81355, 46785, 78727, 53233, 110381, 48083, 54483, 57195, 77474, 46998, 51435, 57196, 77480, 72613, 72616, 72614, 72615, 46596, 92738, 83910, 81070, 67618, 66640, 48068, 78720, 50410, 66678, 67070, 46820, 106827, 32737, 68559, 53880, 51010, 77472, 139112, 54691, 48656, 67769, 46081, 77437, 77475, 46046, 95938, 70575, 826631, 50802, 77486, 67815, 54495, 127782, 54011, 46816, 54480, 77762, 77764, 77473, 574943, 85367, 24586, 83299, 46080, 47578, 47566, 46057, 100767, 71643, 92367, 54758, 67057, 77477, 95212, 71646, 96196, 64740, 64738, 64742, 72491, 54484, 52607, 84321, 73492, 54488, 54489, 54492, 54497, 739422, 53314, 32735, 54485, 87869, 53312, 46822, 32740, 68723, 66721, 46054, 71648, 87358, 83297, 46063, 83724, 46819, 92212, 87870, 66223, 139109, 137612, 139107, 92809, 139102, 54003, 79094, 67768, 73099, 72618, 72619, 63018, 63021, 70636, 70635, 72627, 72628, 66756, 82932, 50625, 32738, 54061, 88685, 32739, 32736, 54009, 51007, 67619, 68407, 68771, 79887, 68778, 46073, 48659, 81382, 64737, 82928, 89322, 77822, 111118, 46056, 102262, 51011, 100766, 46817, 47577, 78065, 56274, 54487, 54062, 46050, 66780, 54006, 72624, 72626, 79588, 72625, 66224, 47579, 47575, 47571) ORDER BY a0_.rank DESC, a0_.title ASC, a0_.title ASC LIMIT 24;
1.53 ms (0.37%)	7	SELECT t0.code AS code_1, t0.chf AS chf_2, t0.eur AS eur_3, t0.usd AS usd_4, t0.rid AS rid_5, t0.state AS state_6, t0.sync AS sync_7, t0.state_at AS state_at_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.publisher_id AS publisher_id_12 FROM prices t0 WHERE t0.id = ? Parameters: [`951`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.chf AS chf_2, t0.eur AS eur_3, t0.usd AS usd_4, t0.rid AS rid_5, t0.state AS state_6, t0.sync AS sync_7, t0.state_at AS state_at_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.publisher_id AS publisher_id_12 FROM prices t0 WHERE t0.id = ? SELECT t0.code AS code_1, t0.chf AS chf_2, t0.eur AS eur_3, t0.usd AS usd_4, t0.rid AS rid_5, t0.state AS state_6, t0.sync AS sync_7, t0.state_at AS state_at_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.publisher_id AS publisher_id_12 FROM prices t0 WHERE t0.id = 951;
1.30 ms (0.31%)	2	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.rid = ? LIMIT 1 Parameters: [`150778`] View formatted query View runnable query Explain query 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.rid = ? LIMIT 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.rid = 150778 LIMIT 1;
0.87 ms (0.21%)	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 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 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 = 'rid.catalog' AND t0.shop_id = 1) ORDER BY t0.type ASC LIMIT 1;
0.63 ms (0.15%)	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 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 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 = 1 AND c0_.is_visible = 1 ORDER BY c0_.position ASC;
0.61 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: [] View formatted query View runnable query Explain query 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 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;
0.59 ms (0.14%)	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" 725623`] View formatted query View runnable query Explain query 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 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 = 1 AND t0.type = 'sound') AND t0.asset_id = 725623) ORDER BY t0.sort_order ASC;
0.54 ms (0.13%)	4	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: [`21`] View formatted query View runnable query Explain query 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 = ? 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 = 21;
0.49 ms (0.12%)	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 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 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 = 'dev.hebu-music.com' LIMIT 1;
0.49 ms (0.12%)	3	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: [`1`] View formatted query View runnable query Explain query 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 = ? 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 = 1;
0.24 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`] View formatted query View runnable query Explain query 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 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 = 1 LIMIT 1;
0.23 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.parent_id = ? Parameters: [`10`] View formatted query View runnable query Explain query 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 = ? 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 = 10;
0.19 ms (0.05%)	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 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 = ? 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 = '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	730
Database\Entity\Musician	262
Database\Entity\Genre	189
Database\Entity\ArticleKind	30
Database\Entity\Publisher	25
Database\Entity\Category	24
Database\Entity\Group	12
Database\Entity\Shop	9
Database\Entity\Price	7
Database\Entity\Kind	4
Database\Entity\Country	3
Database\Entity\Address	1
Database\Entity\Currency	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.

Symfony Profiler

GET https://dev.hebu-music.com/de/verlag/hebu-musikverlag-gmbh.47030

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping