Symfony Profiler

Query Metrics

973 Database Queries

23 Different statements

450.44 ms Query time

0 Invalid entities

1213 Managed entities

Grouped Statements

Time▼	Count	Info
235.62 ms (52.31%)	673	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: [`91746`] View formatted query View runnable query Explain query 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 = ? 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 = 91746;
159.21 ms (35.35%)	253	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: [`2075`] 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 = 2075;
19.94 ms (4.43%)	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 53`] 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 = 53);
6.87 ms (1.53%)	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: [91746 89082 23934 87934 86748 81017 86753 804587 68131 88994 87921 98516 95050 95053 98495 89073 89039 722430 108708 98498 98499 63709 68861 722435 722436 722439 722440 722433 722434 89035 95057 92591 91355 89074 86759 8548 89047 88920 89077 98511 98491 86491 89084 110426 722444 722445 68151 86022 95046 88934 88911 65003 89113 108693 95047 98492 89040 88990 33746 89124 89161 95052 68140 89005 99899 89059 68128 88992 89041 89112 804610 149652 149650 149651 149653 89008 89100 68150 89116 89128 89042 64051 88909 108694 95051 87938 86740 89106 88959 89051 67065 102315 89017 89053 89034 108703 89136 89068 91366 86738 89170 89107 102302 88969 89007 88944 88340 88971 103201 103200 88933 86745 87918 87919 87920 103006 103007 103008 102298 722446 804584 722442 88922 91344 86728 95037 89176 88982 68129 89002 86770 88945 87315 89115 133973 89012 33743 89052 88977 88938 23935 89160 95036 89021 23936 98500 102317 722447 804585 133974 88915 722448 722449 89062 86761 89063 89003 108695 89172 88936 68148 95035 91358 722450 722451 804586 95041 102304 103004 87923 89009 89050 86734 89000 89001 83672 88923 88974 33745 89038 64041 804588 89150 89148 89067 30080 89154 89168 89089 804589 102301 86741 89169 89083 89076 134985 722432 89033 33744 88966 89056 86769 88914 89139 89046 89070 88946 89049 89153 84807 89075 33740 85249 89123 89110 89135 88937 68146 84875 134023 89165 68143 88996 826496 133975 149655 91356 95054 95058 89152 88919 80581 86736 91365 86729 88953 95040 722452 88917 68153 68155 89057 86731 103005 95043 32475 26484 98501 33742 89016 91363 19963 89138 133976 65931 23930 89015 68127 88952 89079 85353 88932 89151 89014 89013 98509 89060 88910 23937 89099 86018 88927 102311 86762 23938 87917 86749 89146 63716 68158 95042 102295 89158 89011 72144 108706 88943 88947 88907 89088 89157 88948 89125 89121 86767 722443 89108 86727 86765 722453 722454 88918 68149 149656 86721 68139 86742 86724 89095 64043 89036 95048 68156 88975 95049 95044 88980 722455 89131 68160 89055 89117 88981 89122 91360 86768 89129 86725 64569 86723 23939 89098 89144 108704 86726 64050 88921 88987 89126 68141 89031 88985 133977 722431 89159 88968 91350 95039 88913 88908 83673 133980 88950 86771 722441 134024 722456 722457 88928 50171 88912 88984 88941 89094 98513 89147 89133 89130 88955 88958 68154 88940 85025 108696 98514 89137 87735 68133 88954 89171 89025 89029 102303 108697 92778 89091 89101 89071 88972 89198 89173 134179 89096 804590 89145 102308 87925 86722 108698 95060 86754 88931 89004 91359 98494 102319 804600 804603 804604 804605 804606 804607 804608 804609 89111 89109 88989 108699 88935 89167 89010 89092 68142 95056 88964 86737 88929 804591 89140 89141 89142 89143 87926 87416 95038 88979 102314 86755 102306 91354 86773 89163 89114 89064 88942 91364 68157 89020 133978 86732 86711 89069 89019 88951 88988 86739 102316 87924 108707 722429 149657 149649 149658 89078 95034 804592 89156 108709 133981 85254 102307 89018 68159 23931 89166 92735 68514 86719 91935 95070 98883 102532 108892 133983 149648 722462 804734 826151 133982 102312 89120 89044 804593 89090 95059 89134 64016 68147 88998 88957 102309 89118 98512 826165 91351 68134 88995 89023 89061 98502 98503 98504 68138 88926 81970 102313 89174 87922 86757 86744 68162 149659 89132 88939 88976 86756 87927 87928 87935 87937 87936 81073 102300 103003 68136 88924 88961 86758 89103 95055 89086 571831 86763 108710 804597 804598 804599 91362 102296 68135 722458 722459 95045 89030 89043 23932 71882 108700 88970 86730 91353 108705 89027 102310 23933 33741 88962 89081 89032 33739 89066 89065 86743 91347 722460 722461 68130 88993 98517 65604 89175 89105 89164 68145 89022 91352 89054 88965 86750 88956 91349 91348 722437 722438 89058 68132 88963 97901 98508 91345 89072 88983 98518 86772 98506 98505 85603 88949 91346 804602 89024 88991 91357 98510 89026 88973 86735 86751 108701 68152 89085 804601 804594 804595 89006 86746 86747 88986 89045 91361 98507 83680 89155 89104 88999 149660 88978 149661 88967 804596 89048 89037 86752 89028 68144 88997 89149 89093 89080 89162 133979 89127 89102 89097 98493 86766 98515 108702 32476 88916 68161 68137 88925 95033 88930 86733 89119 98496 102318 88960 86764 102305 89087] 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 (91746, 89082, 23934, 87934, 86748, 81017, 86753, 804587, 68131, 88994, 87921, 98516, 95050, 95053, 98495, 89073, 89039, 722430, 108708, 98498, 98499, 63709, 68861, 722435, 722436, 722439, 722440, 722433, 722434, 89035, 95057, 92591, 91355, 89074, 86759, 8548, 89047, 88920, 89077, 98511, 98491, 86491, 89084, 110426, 722444, 722445, 68151, 86022, 95046, 88934, 88911, 65003, 89113, 108693, 95047, 98492, 89040, 88990, 33746, 89124, 89161, 95052, 68140, 89005, 99899, 89059, 68128, 88992, 89041, 89112, 804610, 149652, 149650, 149651, 149653, 89008, 89100, 68150, 89116, 89128, 89042, 64051, 88909, 108694, 95051, 87938, 86740, 89106, 88959, 89051, 67065, 102315, 89017, 89053, 89034, 108703, 89136, 89068, 91366, 86738, 89170, 89107, 102302, 88969, 89007, 88944, 88340, 88971, 103201, 103200, 88933, 86745, 87918, 87919, 87920, 103006, 103007, 103008, 102298, 722446, 804584, 722442, 88922, 91344, 86728, 95037, 89176, 88982, 68129, 89002, 86770, 88945, 87315, 89115, 133973, 89012, 33743, 89052, 88977, 88938, 23935, 89160, 95036, 89021, 23936, 98500, 102317, 722447, 804585, 133974, 88915, 722448, 722449, 89062, 86761, 89063, 89003, 108695, 89172, 88936, 68148, 95035, 91358, 722450, 722451, 804586, 95041, 102304, 103004, 87923, 89009, 89050, 86734, 89000, 89001, 83672, 88923, 88974, 33745, 89038, 64041, 804588, 89150, 89148, 89067, 30080, 89154, 89168, 89089, 804589, 102301, 86741, 89169, 89083, 89076, 134985, 722432, 89033, 33744, 88966, 89056, 86769, 88914, 89139, 89046, 89070, 88946, 89049, 89153, 84807, 89075, 33740, 85249, 89123, 89110, 89135, 88937, 68146, 84875, 134023, 89165, 68143, 88996, 826496, 133975, 149655, 91356, 95054, 95058, 89152, 88919, 80581, 86736, 91365, 86729, 88953, 95040, 722452, 88917, 68153, 68155, 89057, 86731, 103005, 95043, 32475, 26484, 98501, 33742, 89016, 91363, 19963, 89138, 133976, 65931, 23930, 89015, 68127, 88952, 89079, 85353, 88932, 89151, 89014, 89013, 98509, 89060, 88910, 23937, 89099, 86018, 88927, 102311, 86762, 23938, 87917, 86749, 89146, 63716, 68158, 95042, 102295, 89158, 89011, 72144, 108706, 88943, 88947, 88907, 89088, 89157, 88948, 89125, 89121, 86767, 722443, 89108, 86727, 86765, 722453, 722454, 88918, 68149, 149656, 86721, 68139, 86742, 86724, 89095, 64043, 89036, 95048, 68156, 88975, 95049, 95044, 88980, 722455, 89131, 68160, 89055, 89117, 88981, 89122, 91360, 86768, 89129, 86725, 64569, 86723, 23939, 89098, 89144, 108704, 86726, 64050, 88921, 88987, 89126, 68141, 89031, 88985, 133977, 722431, 89159, 88968, 91350, 95039, 88913, 88908, 83673, 133980, 88950, 86771, 722441, 134024, 722456, 722457, 88928, 50171, 88912, 88984, 88941, 89094, 98513, 89147, 89133, 89130, 88955, 88958, 68154, 88940, 85025, 108696, 98514, 89137, 87735, 68133, 88954, 89171, 89025, 89029, 102303, 108697, 92778, 89091, 89101, 89071, 88972, 89198, 89173, 134179, 89096, 804590, 89145, 102308, 87925, 86722, 108698, 95060, 86754, 88931, 89004, 91359, 98494, 102319, 804600, 804603, 804604, 804605, 804606, 804607, 804608, 804609, 89111, 89109, 88989, 108699, 88935, 89167, 89010, 89092, 68142, 95056, 88964, 86737, 88929, 804591, 89140, 89141, 89142, 89143, 87926, 87416, 95038, 88979, 102314, 86755, 102306, 91354, 86773, 89163, 89114, 89064, 88942, 91364, 68157, 89020, 133978, 86732, 86711, 89069, 89019, 88951, 88988, 86739, 102316, 87924, 108707, 722429, 149657, 149649, 149658, 89078, 95034, 804592, 89156, 108709, 133981, 85254, 102307, 89018, 68159, 23931, 89166, 92735, 68514, 86719, 91935, 95070, 98883, 102532, 108892, 133983, 149648, 722462, 804734, 826151, 133982, 102312, 89120, 89044, 804593, 89090, 95059, 89134, 64016, 68147, 88998, 88957, 102309, 89118, 98512, 826165, 91351, 68134, 88995, 89023, 89061, 98502, 98503, 98504, 68138, 88926, 81970, 102313, 89174, 87922, 86757, 86744, 68162, 149659, 89132, 88939, 88976, 86756, 87927, 87928, 87935, 87937, 87936, 81073, 102300, 103003, 68136, 88924, 88961, 86758, 89103, 95055, 89086, 571831, 86763, 108710, 804597, 804598, 804599, 91362, 102296, 68135, 722458, 722459, 95045, 89030, 89043, 23932, 71882, 108700, 88970, 86730, 91353, 108705, 89027, 102310, 23933, 33741, 88962, 89081, 89032, 33739, 89066, 89065, 86743, 91347, 722460, 722461, 68130, 88993, 98517, 65604, 89175, 89105, 89164, 68145, 89022, 91352, 89054, 88965, 86750, 88956, 91349, 91348, 722437, 722438, 89058, 68132, 88963, 97901, 98508, 91345, 89072, 88983, 98518, 86772, 98506, 98505, 85603, 88949, 91346, 804602, 89024, 88991, 91357, 98510, 89026, 88973, 86735, 86751, 108701, 68152, 89085, 804601, 804594, 804595, 89006, 86746, 86747, 88986, 89045, 91361, 98507, 83680, 89155, 89104, 88999, 149660, 88978, 149661, 88967, 804596, 89048, 89037, 86752, 89028, 68144, 88997, 89149, 89093, 89080, 89162, 133979, 89127, 89102, 89097, 98493, 86766, 98515, 108702, 32476, 88916, 68161, 68137, 88925, 95033, 88930, 86733, 89119, 98496, 102318, 88960, 86764, 102305, 89087) ORDER BY a0_.rank DESC, a0_.title ASC, a0_.title ASC) dctrn_result) dctrn_table;
5.97 ms (1.33%)	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: [`53 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 = 53 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;
3.83 ms (0.85%)	1	SELECT a0_.title AS title_0, a0_.article_nr AS article_nr_1, a0_.publisher_nr AS publisher_nr_2, a0_.gtin AS gtin_3, a0_.rank AS rank_4, a0_.duration AS duration_5, a0_.difficulty AS difficulty_6, a0_.difficulty_detail AS difficulty_detail_7, a0_.trial_voice AS trial_voice_8, a0_.sequence AS sequence_9, a0_.pages AS pages_10, a0_.weight AS weight_11, a0_.quantity AS quantity_12, a0_.delivery_time AS delivery_time_13, a0_.external_nr AS external_nr_14, a0_.options AS options_15, a0_.indexable AS indexable_16, a0_.is_catalog AS is_catalog_17, a0_.is_new AS is_new_18, a0_.is_slider AS is_slider_19, a0_.is_saleable AS is_saleable_20, a0_.is_visible AS is_visible_21, a0_.rid AS rid_22, a0_.state AS state_23, a0_.sync AS sync_24, a0_.state_at AS state_at_25, a0_.id AS id_26, a0_.created_at AS created_at_27, a0_.updated_at AS updated_at_28, a0_.arranger_id AS arranger_id_29, a0_.group_id AS group_id_30, a0_.composer_id AS composer_id_31, a0_.country_id AS country_id_32, a0_.publisher_id AS publisher_id_33, a0_.shop_id AS shop_id_34 FROM articles a0_ WHERE a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.rank DESC, a0_.title ASC, a0_.title ASC LIMIT 24 OFFSET 672 Parameters: [91746 89082 23934 87934 86748 81017 86753 804587 68131 88994 87921 98516 95050 95053 98495 89073 89039 722430 108708 98498 98499 63709 68861 722435 722436 722439 722440 722433 722434 89035 95057 92591 91355 89074 86759 8548 89047 88920 89077 98511 98491 86491 89084 110426 722444 722445 68151 86022 95046 88934 88911 65003 89113 108693 95047 98492 89040 88990 33746 89124 89161 95052 68140 89005 99899 89059 68128 88992 89041 89112 804610 149652 149650 149651 149653 89008 89100 68150 89116 89128 89042 64051 88909 108694 95051 87938 86740 89106 88959 89051 67065 102315 89017 89053 89034 108703 89136 89068 91366 86738 89170 89107 102302 88969 89007 88944 88340 88971 103201 103200 88933 86745 87918 87919 87920 103006 103007 103008 102298 722446 804584 722442 88922 91344 86728 95037 89176 88982 68129 89002 86770 88945 87315 89115 133973 89012 33743 89052 88977 88938 23935 89160 95036 89021 23936 98500 102317 722447 804585 133974 88915 722448 722449 89062 86761 89063 89003 108695 89172 88936 68148 95035 91358 722450 722451 804586 95041 102304 103004 87923 89009 89050 86734 89000 89001 83672 88923 88974 33745 89038 64041 804588 89150 89148 89067 30080 89154 89168 89089 804589 102301 86741 89169 89083 89076 134985 722432 89033 33744 88966 89056 86769 88914 89139 89046 89070 88946 89049 89153 84807 89075 33740 85249 89123 89110 89135 88937 68146 84875 134023 89165 68143 88996 826496 133975 149655 91356 95054 95058 89152 88919 80581 86736 91365 86729 88953 95040 722452 88917 68153 68155 89057 86731 103005 95043 32475 26484 98501 33742 89016 91363 19963 89138 133976 65931 23930 89015 68127 88952 89079 85353 88932 89151 89014 89013 98509 89060 88910 23937 89099 86018 88927 102311 86762 23938 87917 86749 89146 63716 68158 95042 102295 89158 89011 72144 108706 88943 88947 88907 89088 89157 88948 89125 89121 86767 722443 89108 86727 86765 722453 722454 88918 68149 149656 86721 68139 86742 86724 89095 64043 89036 95048 68156 88975 95049 95044 88980 722455 89131 68160 89055 89117 88981 89122 91360 86768 89129 86725 64569 86723 23939 89098 89144 108704 86726 64050 88921 88987 89126 68141 89031 88985 133977 722431 89159 88968 91350 95039 88913 88908 83673 133980 88950 86771 722441 134024 722456 722457 88928 50171 88912 88984 88941 89094 98513 89147 89133 89130 88955 88958 68154 88940 85025 108696 98514 89137 87735 68133 88954 89171 89025 89029 102303 108697 92778 89091 89101 89071 88972 89198 89173 134179 89096 804590 89145 102308 87925 86722 108698 95060 86754 88931 89004 91359 98494 102319 804600 804603 804604 804605 804606 804607 804608 804609 89111 89109 88989 108699 88935 89167 89010 89092 68142 95056 88964 86737 88929 804591 89140 89141 89142 89143 87926 87416 95038 88979 102314 86755 102306 91354 86773 89163 89114 89064 88942 91364 68157 89020 133978 86732 86711 89069 89019 88951 88988 86739 102316 87924 108707 722429 149657 149649 149658 89078 95034 804592 89156 108709 133981 85254 102307 89018 68159 23931 89166 92735 68514 86719 91935 95070 98883 102532 108892 133983 149648 722462 804734 826151 133982 102312 89120 89044 804593 89090 95059 89134 64016 68147 88998 88957 102309 89118 98512 826165 91351 68134 88995 89023 89061 98502 98503 98504 68138 88926 81970 102313 89174 87922 86757 86744 68162 149659 89132 88939 88976 86756 87927 87928 87935 87937 87936 81073 102300 103003 68136 88924 88961 86758 89103 95055 89086 571831 86763 108710 804597 804598 804599 91362 102296 68135 722458 722459 95045 89030 89043 23932 71882 108700 88970 86730 91353 108705 89027 102310 23933 33741 88962 89081 89032 33739 89066 89065 86743 91347 722460 722461 68130 88993 98517 65604 89175 89105 89164 68145 89022 91352 89054 88965 86750 88956 91349 91348 722437 722438 89058 68132 88963 97901 98508 91345 89072 88983 98518 86772 98506 98505 85603 88949 91346 804602 89024 88991 91357 98510 89026 88973 86735 86751 108701 68152 89085 804601 804594 804595 89006 86746 86747 88986 89045 91361 98507 83680 89155 89104 88999 149660 88978 149661 88967 804596 89048 89037 86752 89028 68144 88997 89149 89093 89080 89162 133979 89127 89102 89097 98493 86766 98515 108702 32476 88916 68161 68137 88925 95033 88930 86733 89119 98496 102318 88960 86764 102305 89087] 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 OFFSET 672 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 (91746, 89082, 23934, 87934, 86748, 81017, 86753, 804587, 68131, 88994, 87921, 98516, 95050, 95053, 98495, 89073, 89039, 722430, 108708, 98498, 98499, 63709, 68861, 722435, 722436, 722439, 722440, 722433, 722434, 89035, 95057, 92591, 91355, 89074, 86759, 8548, 89047, 88920, 89077, 98511, 98491, 86491, 89084, 110426, 722444, 722445, 68151, 86022, 95046, 88934, 88911, 65003, 89113, 108693, 95047, 98492, 89040, 88990, 33746, 89124, 89161, 95052, 68140, 89005, 99899, 89059, 68128, 88992, 89041, 89112, 804610, 149652, 149650, 149651, 149653, 89008, 89100, 68150, 89116, 89128, 89042, 64051, 88909, 108694, 95051, 87938, 86740, 89106, 88959, 89051, 67065, 102315, 89017, 89053, 89034, 108703, 89136, 89068, 91366, 86738, 89170, 89107, 102302, 88969, 89007, 88944, 88340, 88971, 103201, 103200, 88933, 86745, 87918, 87919, 87920, 103006, 103007, 103008, 102298, 722446, 804584, 722442, 88922, 91344, 86728, 95037, 89176, 88982, 68129, 89002, 86770, 88945, 87315, 89115, 133973, 89012, 33743, 89052, 88977, 88938, 23935, 89160, 95036, 89021, 23936, 98500, 102317, 722447, 804585, 133974, 88915, 722448, 722449, 89062, 86761, 89063, 89003, 108695, 89172, 88936, 68148, 95035, 91358, 722450, 722451, 804586, 95041, 102304, 103004, 87923, 89009, 89050, 86734, 89000, 89001, 83672, 88923, 88974, 33745, 89038, 64041, 804588, 89150, 89148, 89067, 30080, 89154, 89168, 89089, 804589, 102301, 86741, 89169, 89083, 89076, 134985, 722432, 89033, 33744, 88966, 89056, 86769, 88914, 89139, 89046, 89070, 88946, 89049, 89153, 84807, 89075, 33740, 85249, 89123, 89110, 89135, 88937, 68146, 84875, 134023, 89165, 68143, 88996, 826496, 133975, 149655, 91356, 95054, 95058, 89152, 88919, 80581, 86736, 91365, 86729, 88953, 95040, 722452, 88917, 68153, 68155, 89057, 86731, 103005, 95043, 32475, 26484, 98501, 33742, 89016, 91363, 19963, 89138, 133976, 65931, 23930, 89015, 68127, 88952, 89079, 85353, 88932, 89151, 89014, 89013, 98509, 89060, 88910, 23937, 89099, 86018, 88927, 102311, 86762, 23938, 87917, 86749, 89146, 63716, 68158, 95042, 102295, 89158, 89011, 72144, 108706, 88943, 88947, 88907, 89088, 89157, 88948, 89125, 89121, 86767, 722443, 89108, 86727, 86765, 722453, 722454, 88918, 68149, 149656, 86721, 68139, 86742, 86724, 89095, 64043, 89036, 95048, 68156, 88975, 95049, 95044, 88980, 722455, 89131, 68160, 89055, 89117, 88981, 89122, 91360, 86768, 89129, 86725, 64569, 86723, 23939, 89098, 89144, 108704, 86726, 64050, 88921, 88987, 89126, 68141, 89031, 88985, 133977, 722431, 89159, 88968, 91350, 95039, 88913, 88908, 83673, 133980, 88950, 86771, 722441, 134024, 722456, 722457, 88928, 50171, 88912, 88984, 88941, 89094, 98513, 89147, 89133, 89130, 88955, 88958, 68154, 88940, 85025, 108696, 98514, 89137, 87735, 68133, 88954, 89171, 89025, 89029, 102303, 108697, 92778, 89091, 89101, 89071, 88972, 89198, 89173, 134179, 89096, 804590, 89145, 102308, 87925, 86722, 108698, 95060, 86754, 88931, 89004, 91359, 98494, 102319, 804600, 804603, 804604, 804605, 804606, 804607, 804608, 804609, 89111, 89109, 88989, 108699, 88935, 89167, 89010, 89092, 68142, 95056, 88964, 86737, 88929, 804591, 89140, 89141, 89142, 89143, 87926, 87416, 95038, 88979, 102314, 86755, 102306, 91354, 86773, 89163, 89114, 89064, 88942, 91364, 68157, 89020, 133978, 86732, 86711, 89069, 89019, 88951, 88988, 86739, 102316, 87924, 108707, 722429, 149657, 149649, 149658, 89078, 95034, 804592, 89156, 108709, 133981, 85254, 102307, 89018, 68159, 23931, 89166, 92735, 68514, 86719, 91935, 95070, 98883, 102532, 108892, 133983, 149648, 722462, 804734, 826151, 133982, 102312, 89120, 89044, 804593, 89090, 95059, 89134, 64016, 68147, 88998, 88957, 102309, 89118, 98512, 826165, 91351, 68134, 88995, 89023, 89061, 98502, 98503, 98504, 68138, 88926, 81970, 102313, 89174, 87922, 86757, 86744, 68162, 149659, 89132, 88939, 88976, 86756, 87927, 87928, 87935, 87937, 87936, 81073, 102300, 103003, 68136, 88924, 88961, 86758, 89103, 95055, 89086, 571831, 86763, 108710, 804597, 804598, 804599, 91362, 102296, 68135, 722458, 722459, 95045, 89030, 89043, 23932, 71882, 108700, 88970, 86730, 91353, 108705, 89027, 102310, 23933, 33741, 88962, 89081, 89032, 33739, 89066, 89065, 86743, 91347, 722460, 722461, 68130, 88993, 98517, 65604, 89175, 89105, 89164, 68145, 89022, 91352, 89054, 88965, 86750, 88956, 91349, 91348, 722437, 722438, 89058, 68132, 88963, 97901, 98508, 91345, 89072, 88983, 98518, 86772, 98506, 98505, 85603, 88949, 91346, 804602, 89024, 88991, 91357, 98510, 89026, 88973, 86735, 86751, 108701, 68152, 89085, 804601, 804594, 804595, 89006, 86746, 86747, 88986, 89045, 91361, 98507, 83680, 89155, 89104, 88999, 149660, 88978, 149661, 88967, 804596, 89048, 89037, 86752, 89028, 68144, 88997, 89149, 89093, 89080, 89162, 133979, 89127, 89102, 89097, 98493, 86766, 98515, 108702, 32476, 88916, 68161, 68137, 88925, 95033, 88930, 86733, 89119, 98496, 102318, 88960, 86764, 102305, 89087) ORDER BY a0_.rank DESC, a0_.title ASC, a0_.title ASC LIMIT 24 OFFSET 672;
3.13 ms (0.69%)	1	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: [`68137`] 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 = 68137 ORDER BY t0.sort_order ASC, t0.kind_id ASC;
2.97 ms (0.66%)	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`] 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;
2.17 ms (0.48%)	8	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: [`1201`] View formatted query View runnable query Explain query 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 = ? 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 = 1201;
1.81 ms (0.40%)	2	SELECT t0.title AS title_1, t0.tax_name AS tax_name_2, t0.price_attributes AS price_attributes_3, t0.is_active AS is_active_4, t0.rid AS rid_5, t0.state AS state_6, t0.sync AS sync_7, t0.state_at AS state_at_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.shop_id AS shop_id_12 FROM groups t0 WHERE t0.id = ? Parameters: [`7`] 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 = 7;
1.47 ms (0.33%)	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`] View formatted query View runnable query Explain query 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 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 = 1 AND c0_.is_visible = 1 ORDER BY c0_.position ASC;
1.27 ms (0.28%)	1	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" 68137`] 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 = 68137) ORDER BY t0.sort_order ASC;
1.22 ms (0.27%)	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: [`299`] 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 = 299 LIMIT 1;
0.91 ms (0.20%)	2	SELECT t0.name AS name_1, t0.short AS short_2, t0.is_main AS is_main_3, t0.is_part AS is_part_4, t0.is_visible AS is_visible_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.article_id AS article_id_13 FROM kinds t0 WHERE t0.id = ? Parameters: [`1`] 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 = 1;
0.76 ms (0.17%)	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 = ? 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-31 05:32:08" "2025-12-31 05:32:08"`] 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-12-31 05:32:08') AND (t0_.valid_until IS NULL OR t0_.valid_until >= '2025-12-31 05:32:08') ORDER BY t0_.name ASC LIMIT 1;
0.75 ms (0.17%)	1	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: [`68137`] View formatted query View runnable query Explain query 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 = ? 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 = 68137;
0.52 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.50 ms (0.11%)	1	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: [`2014`] 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 = 2014;
0.48 ms (0.11%)	3	SELECT c0_.code AS code_0, c0_.title AS title_1, c0_.locale AS locale_2, c0_.city_format AS city_format_3, c0_.is_default AS is_default_4, c0_.rid AS rid_5, c0_.state AS state_6, c0_.sync AS sync_7, c0_.state_at AS state_at_8, c0_.id AS id_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11, c0_.currency AS currency_12 FROM countries c0_ WHERE c0_.is_default = 1 ORDER BY c0_.id ASC LIMIT 1 Parameters: [] 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.42 ms (0.09%)	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" 461924`] 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 = 461924) ORDER BY t0.sort_order ASC;
0.29 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.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`] 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.15 ms (0.03%)	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	801
Database\Entity\Musician	273
Database\Entity\Genre	76
Database\Entity\Category	34
Database\Entity\Group	7
Database\Entity\Shop	6
Database\Entity\Country	3
Database\Entity\ShopData	3
Database\Entity\ArticleKind	2
Database\Entity\Kind	2
Database\Entity\Address	1
Database\Entity\Currency	1
Database\Entity\Publisher	1
Database\Entity\ArticleAsset	1
Database\Entity\Price	1
Database\Entity\Tax	1

Entities Mapping

Class	Mapping errors
Database\Entity\Shop	No errors.
Database\Entity\Address	No errors.
Database\Entity\Currency	No errors.
Database\Entity\ShopBilling	No errors.
Database\Entity\Category	No errors.
Database\Entity\ShopData	No errors.
Database\Entity\ShopKindFilename	No errors.
Database\Entity\Publisher	No errors.
Database\Entity\ShopSale	No errors.
Database\Entity\ShopSubshop	No errors.
Database\Entity\User	No errors.
Database\Entity\Country	No errors.
Database\Entity\State	No errors.
Database\Entity\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\ArticleAssetUrl	No errors.
Database\Entity\Kind	No errors.
Database\Entity\Price	No errors.
Database\Entity\Tax	No errors.

Symfony Profiler

GET https://dev.hebu-music.com/de/verlag/difem.299/29

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping