Query Metrics
310
Database Queries
45
Different statements
580.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
91.37 ms (15.73%) |
76 |
SELECT m0_.id AS id_0, m0_.created AS created_1, m0_.changed AS changed_2, m1_.name AS name_3, m1_.description AS description_4, m1_.id AS id_5, m2_.style AS style_6, m2_.lft AS lft_7, m2_.rgt AS rgt_8, m2_.depth AS depth_9, m2_.collection_key AS collection_key_10, m2_.id AS id_11, m2_.created AS created_12, m2_.changed AS changed_13, m3_.version AS version_14, m3_.id AS id_15, m3_.created AS created_16, m3_.changed AS changed_17, m4_.name AS name_18, m4_.version AS version_19, m4_.subVersion AS subVersion_20, m4_.size AS size_21, m4_.downloadCounter AS downloadCounter_22, m4_.storageOptions AS storageOptions_23, m4_.mimeType AS mimeType_24, m4_.properties AS properties_25, m4_.focusPointX AS focusPointX_26, m4_.focusPointY AS focusPointY_27, m4_.id AS id_28, m4_.created AS created_29, m4_.changed AS changed_30, t5_.name AS name_31, t5_.id AS id_32, t5_.created AS created_33, t5_.changed AS changed_34, m6_.crop_x AS crop_x_35, m6_.crop_y AS crop_y_36, m6_.crop_width AS crop_width_37, m6_.crop_height AS crop_height_38, m6_.format_key AS format_key_39, m7_.title AS title_40, m7_.description AS description_41, m7_.copyright AS copyright_42, m7_.credits AS credits_43, m7_.locale AS locale_44, m7_.id AS id_45, m8_.title AS title_46, m8_.description AS description_47, m8_.copyright AS copyright_48, m8_.credits AS credits_49, m8_.locale AS locale_50, m8_.id AS id_51, m9_.locale AS locale_52, m9_.id AS id_53, m10_.locale AS locale_54, m10_.id AS id_55, s11_.username AS username_56, s11_.password AS password_57, s11_.locale AS locale_58, s11_.salt AS salt_59, s11_.locked AS locked_60, s11_.enabled AS enabled_61, s11_.lastLogin AS lastLogin_62, s11_.confirmationKey AS confirmationKey_63, s11_.passwordResetToken AS passwordResetToken_64, s11_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_65, s11_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_66, s11_.privateKey AS privateKey_67, s11_.apiKey AS apiKey_68, s11_.email AS email_69, s11_.id AS id_70, s11_.created AS created_71, s11_.changed AS changed_72, s11_.from_api AS from_api_73, s11_.from_csv AS from_csv_74, s11_.token_google AS token_google_75, s11_.token_facebook AS token_facebook_76, s11_.front_access_token AS front_access_token_77, s11_.front_access_token_expires_at AS front_access_token_expires_at_78, c12_.firstName AS firstName_79, c12_.middleName AS middleName_80, c12_.lastName AS lastName_81, c12_.birthday AS birthday_82, c12_.salutation AS salutation_83, c12_.formOfAddress AS formOfAddress_84, c12_.newsletter AS newsletter_85, c12_.gender AS gender_86, c12_.note AS note_87, c12_.mainEmail AS mainEmail_88, c12_.mainPhone AS mainPhone_89, c12_.mainFax AS mainFax_90, c12_.mainUrl AS mainUrl_91, c12_.id AS id_92, c12_.created AS created_93, c12_.changed AS changed_94, s13_.username AS username_95, s13_.password AS password_96, s13_.locale AS locale_97, s13_.salt AS salt_98, s13_.locked AS locked_99, s13_.enabled AS enabled_100, s13_.lastLogin AS lastLogin_101, s13_.confirmationKey AS confirmationKey_102, s13_.passwordResetToken AS passwordResetToken_103, s13_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_104, s13_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_105, s13_.privateKey AS privateKey_106, s13_.apiKey AS apiKey_107, s13_.email AS email_108, s13_.id AS id_109, s13_.created AS created_110, s13_.changed AS changed_111, s13_.from_api AS from_api_112, s13_.from_csv AS from_csv_113, s13_.token_google AS token_google_114, s13_.token_facebook AS token_facebook_115, s13_.front_access_token AS front_access_token_116, s13_.front_access_token_expires_at AS front_access_token_expires_at_117, c14_.firstName AS firstName_118, c14_.middleName AS middleName_119, c14_.lastName AS lastName_120, c14_.birthday AS birthday_121, c14_.salutation AS salutation_122, c14_.formOfAddress AS formOfAddress_123, c14_.newsletter AS newsletter_124, c14_.gender AS gender_125, c14_.note AS note_126, c14_.mainEmail AS mainEmail_127, c14_.mainPhone AS mainPhone_128, c14_.mainFax AS mainFax_129, c14_.mainUrl AS mainUrl_130, c14_.id AS id_131, c14_.created AS created_132, c14_.changed AS changed_133, m15_.id AS id_134, m15_.created AS created_135, m15_.changed AS changed_136, m0_.idMediaTypes AS idMediaTypes_137, m0_.idPreviewImage AS idPreviewImage_138, m0_.idCollections AS idCollections_139, m0_.idUsersCreator AS idUsersCreator_140, m0_.idUsersChanger AS idUsersChanger_141, m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_142, m2_.idCollectionTypes AS idCollectionTypes_143, m2_.idCollectionsParent AS idCollectionsParent_144, m2_.idUsersCreator AS idUsersCreator_145, m2_.idUsersChanger AS idUsersChanger_146, m3_.idMedia AS idMedia_147, m3_.idUsersCreator AS idUsersCreator_148, m3_.idUsersChanger AS idUsersChanger_149, m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_150, m4_.idFiles AS idFiles_151, m4_.idUsersCreator AS idUsersCreator_152, m4_.idUsersChanger AS idUsersChanger_153, t5_.idUsersCreator AS idUsersCreator_154, t5_.idUsersChanger AS idUsersChanger_155, m6_.fileVersion AS fileVersion_156, m7_.idFileVersions AS idFileVersions_157, m8_.idFileVersions AS idFileVersions_158, m9_.idFileVersions AS idFileVersions_159, m10_.idFileVersions AS idFileVersions_160, s11_.idUsersCreator AS idUsersCreator_161, s11_.idUsersChanger AS idUsersChanger_162, s11_.idContacts AS idContacts_163, c12_.idTitles AS idTitles_164, c12_.avatar AS avatar_165, c12_.idUsersCreator AS idUsersCreator_166, c12_.idUsersChanger AS idUsersChanger_167, s13_.idUsersCreator AS idUsersCreator_168, s13_.idUsersChanger AS idUsersChanger_169, s13_.idContacts AS idContacts_170, c14_.idTitles AS idTitles_171, c14_.avatar AS avatar_172, c14_.idUsersCreator AS idUsersCreator_173, c14_.idUsersChanger AS idUsersChanger_174, m15_.idMediaTypes AS idMediaTypes_175, m15_.idPreviewImage AS idPreviewImage_176, m15_.idCollections AS idCollections_177, m15_.idUsersCreator AS idUsersCreator_178, m15_.idUsersChanger AS idUsersChanger_179 FROM me_media m0_ LEFT JOIN me_media_types m1_ ON m0_.idMediaTypes = m1_.id LEFT JOIN me_collections m2_ ON m0_.idCollections = m2_.id LEFT JOIN me_files m3_ ON m0_.id = m3_.idMedia LEFT JOIN me_file_versions m4_ ON m3_.id = m4_.idFiles LEFT JOIN me_file_version_tags m16_ ON m4_.id = m16_.idFileVersions LEFT JOIN ta_tags t5_ ON t5_.id = m16_.idTags LEFT JOIN me_file_version_categories m18_ ON m4_.id = m18_.idFileVersions LEFT JOIN ca_categories c17_ ON c17_.id = m18_.idCategories LEFT JOIN me_format_options m6_ ON m4_.id = m6_.fileVersion LEFT JOIN me_file_version_meta m7_ ON m4_.id = m7_.idFileVersions LEFT JOIN me_file_version_meta m8_ ON m4_.idFileVersionsMetaDefault = m8_.id LEFT JOIN me_file_version_content_languages m9_ ON m4_.id = m9_.idFileVersions LEFT JOIN me_file_version_publish_languages m10_ ON m4_.id = m10_.idFileVersions LEFT JOIN se_users s11_ ON m0_.idUsersCreator = s11_.id LEFT JOIN co_contacts c12_ ON s11_.idContacts = c12_.id LEFT JOIN se_users s13_ ON m0_.idUsersChanger = s13_.id LEFT JOIN co_contacts c14_ ON s13_.idContacts = c14_.id LEFT JOIN me_media m15_ ON m0_.idPreviewImage = m15_.id WHERE m0_.id = ?
Parameters:
[
232567
]
|
|
65.49 ms (11.27%) |
15 |
SELECT * FROM phpcr_nodes WHERE identifier = ? AND workspace_name = ?
Parameters:
[ "dd991113-3aa4-4e99-b3f3-684362ec7aa8" "default_live" ] |
|
61.36 ms (10.56%) |
1 |
SELECT h0_.nom AS nom_0, h0_.prenom AS prenom_1, h0_.slug AS slug_2, h0_.photo_url_externe AS photo_url_externe_3, h0_.structure_professionnelle AS structure_professionnelle_4, h0_.site_web AS site_web_5, h0_.facebook AS facebook_6, h0_.twitter AS twitter_7, h0_.linkedin AS linkedin_8, h0_.instagram AS instagram_9, h0_.titres_diplomes AS titres_diplomes_10, h0_.fonctions_actuelles AS fonctions_actuelles_11, h0_.biographie AS biographie_12, h0_.autres_parutions AS autres_parutions_13, h0_.artiste_id AS artiste_id_14, h0_.externe_id AS externe_id_15, h0_.date_creation AS date_creation_16, h0_.date_modification AS date_modification_17, h0_.image_changed AS image_changed_18, h0_.id AS id_19, h0_.created AS created_20, h0_.changed AS changed_21, h0_.compte_id AS compte_id_22, h0_.photo_id AS photo_id_23, h0_.parent_id AS parent_id_24 FROM har_intervenant h0_ INNER JOIN har_ouvrage_intervenant h1_ ON h0_.id = h1_.intervenant_id WHERE h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY h0_.prenom ASC, h0_.nom ASC
Parameters:
[ 38544 13865 35595 4524 7171 9830 33433 754 11862 18719 49511 397 23401 27279 11 474 680 798 3055 3320 4540 5449 5988 7567 10138 11371 18181 26463 26762 51490 380 535 967 1013 2275 3400 3851 4578 5034 6914 10593 12022 12434 14703 16895 17195 17705 18125 21169 22162 22281 22365 22976 23650 24596 24616 26115 26561 26832 29178 43476 46604 49521 50110 60 302 311 772 823 832 859 1086 1319 1395 1661 2488 2621 2953 2979 3192 3195 3208 3440 3572 3686 3783 3855 3986 4684 4841 5241 5324 5462 5830 6046 6808 7417 7926 10559 10927 11057 11793 11904 12209 13011 13246 13702 13704 13920 13996 14061 15181 15741 16414 16534 16727 17204 17683 18076 18633 18954 19529 19659 19800 20416 20612 20752 20774 21085 21261 22074 22172 22630 22790 22854 23047 23232 23648 24295 24507 25075 25162 25357 25578 26326 26357 26542 26633 26663 26717 26795 26963 27982 29651 34968 36761 37110 37590 37751 37952 39860 40097 40315 40530 40598 40739 41627 41783 42006 43321 44691 45212 46195 47081 48304 49440 49891 70 117 362 419 423 451 472 558 575 638 692 763 764 824 865 924 957 984 1033 1081 1113 1149 1164 1205 1217 1613 1744 1757 1824 1826 1833 2000 2119 2196 2235 2364 2385 2426 2517 2609 2700 2750 2803 3001 3047 3121 3132 3233 3319 3464 3513 3570 3613 3632 3740 3765 3976 4115 4145 4203 4215 4237 4285 4454 4712 4756 4812 4948 4972 5032 5144 5183 5234 5329 5363 5367 5368 5387 5392 5409 5436 5552 5561 5577 5603 5652 5725 5740 5753 5825 5869 5905 5947 5961 5993 6115 6211 6228 6276 6339 6415 6526 6529 6567 6792 6850 7084 7186 7192 7396 7473 7525 7533 7545 7629 7662 7747 7858 7912 7951 8152 8212 8251 8422 8482 8566 8588 8642 9073 9082 9159 9254 9324 9448 9498 9509 9606 9689 9697 9789 9944 10110 10145 10154 10203 10225 10250 10363 10540 10589 10591 10632 10665 10725 10768 10804 10810 10835 10934 10969 10986 11015 11050 11112 11195 11322 11339 11393 11427 11464 11478 11617 11626 11680 11706 11732 11827 11848 11851 11871 11887 12025 12110 12117 12137 12224 12231 12238 12373 12398 12430 12441 12468 12544 12595 12612 12760 12788 12833 12886 12942 12968 12998 13021 13083 13121 13128 13141 13296 13352 13433 13490 13612 13725 13790 13879 13913 14077 14087 14109 14126 14148 14159 14160 14199 14364 14383 14406 14414 14496 14624 14684 14700 14736 14780 14783 14816 14960 15014 15027 15057 15125 15196 15257 15396 15517 15703 15717 15784 15809 15834 15932 15991 16029 16055 16103 16124 16128 16145 16148 16158 16308 16419 16436 16575 16600 16642 16720 16842 16894 16896 16986 17096 17121 17190 17210 17337 17366 17404 17442 17492 17560 17637 17793 17882 18014 18154 18319 18334 18372 18419 18465 18490 18578 18583 18656 18663 18726 18727 18930 18949 18952 18989 19077 19096 19132 19163 19241 19312 19454 19470 19490 19610 19656 19703 19721 19737 19810 19834 19900 19916 19937 20046 20140 20211 20270 20312 20316 20319 20405 20428 20429 20448 20504 20517 20520 20526 20539 20552 20600 20641 20647 20677 20681 20719 20822 20868 20873 20875 20886 20907 21011 21030 21039 21069 21078 21084 21095 21108 21125 21146 21150 21175 21276 21277 21288 21294 21307 21328 21348 21356 21382 21396 21554 21567 21615 21634 21661 21684 21713 21730 21737 21739 21758 21762 21763 21946 21953 22024 22025 22060 22145 22183 22184 22226 22227 22243 22276 22324 22334 22341 22346 22430 22480 22483 22507 22516 22537 22544 22548 22557 22574 22578 22616 22617 22621 22644 22647 22671 22681 22697 22717 22793 22886 22888 22899 22927 22956 22997 23024 23025 23036 23070 23084 23113 23161 23184 23223 23262 23270 23274 23312 23324 23330 23332 23352 23395 23464 23465 23480 23504 23534 23537 23561 23634 23705 23711 24069 24099 24371 24387 24414 24540 24547 24618 24674 24725 24856 24890 24985 25055 25136 25160 25240 25282 25388 25451 25528 25647 25728 25734 25788 25831 25853 25863 25975 26044 26090 26186 26216 26263 26284 26315 26345 26352 26370 26391 26405 26421 26436 26475 26488 26505 26511 26539 26575 26587 26614 26733 26747 26836 26847 26861 26872 26924 26926 26948 26966 26969 26974 26976 27172 27432 27522 27690 28027 28033 28068 28140 28144 28693 29061 29182 29242 29658 29664 30645 30662 32148 32182 32460 32492 33106 33312 33391 33477 33560 33599 33641 33908 33923 34522 34525 35482 35869 36202 36589 36709 36834 36889 37035 37355 37363 37667 38027 38195 38222 38472 38568 38674 38870 39630 39735 39789 39810 39825 39829 39910 40053 40096 40306 40312 40324 40344 40378 40451 40507 40511 40558 40587 40589 40628 40705 40707 40725 40751 40752 40770 40814 40822 40874 40882 40903 40930 41054 41101 41118 41134 41151 41187 41190 41220 41309 41341 41425 41468 41476 41485 41531 41545 41559 41619 41647 41677 41680 41784 41810 41819 41834 41890 41940 41945 41953 41993 42118 42126 42141 42161 42168 42173 42328 42375 42412 42499 42664 42699 42767 42878 42893 42940 42943 42948 43070 43126 43300 43314 43484 43487 43518 43565 43617 43621 43668 43831 43874 44085 44207 44208 44282 44333 44371 44484 44631 44636 44684 44690 44703 44714 44742 44744 44944 45135 45272 45441 45592 45713 45891 46136 46188 46364 46512 46524 46557 46731 46766 46992 47168 47196 47474 47623 48427 49091 49463 49701 50050 50052 50347 50427 50521 51283 51793 52165 53441 54168 54593 54596 56554 57423 57433 ] |
|
45.75 ms (7.88%) |
1 |
SELECT h0_.type AS type_0, h0_.titre AS titre_1, h0_.slug AS slug_2, h0_.sous_titre AS sous_titre_3, h0_.tome AS tome_4, h0_.revue_numero AS revue_numero_5, h0_.resume AS resume_6, h0_.date_publication AS date_publication_7, h0_.biographie AS biographie_8, h0_.extrait_pdf AS extrait_pdf_9, h0_.extrait_audio AS extrait_audio_10, h0_.sommaire AS sommaire_11, h0_.date_modification AS date_modification_12, h0_.prix_papier AS prix_papier_13, h0_.prix_numerique AS prix_numerique_14, h0_.prix_audio AS prix_audio_15, h0_.disponibilite_epub AS disponibilite_epub_16, h0_.largeur AS largeur_17, h0_.hauteur AS hauteur_18, h0_.nb_pages AS nb_pages_19, h0_.poids AS poids_20, h0_.isbn AS isbn_21, h0_.ean13 AS ean13_22, h0_.ean_epub AS ean_epub_23, h0_.ean_pdf AS ean_pdf_24, h0_.multilingue AS multilingue_25, h0_.avis_expert AS avis_expert_26, h0_.externe_id AS externe_id_27, h0_.image_recto_url_externe AS image_recto_url_externe_28, h0_.image_verso_url_externe AS image_verso_url_externe_29, h0_.updated AS updated_30, h0_.added AS added_31, h0_.image_changed AS image_changed_32, h0_.a_la_une AS a_la_une_33, h0_.lien_aplat AS lien_aplat_34, h0_.id AS id_35, h0_.created AS created_36, h0_.changed AS changed_37, h0_.revue_id AS revue_id_38, h0_.image_recto_id AS image_recto_id_39, h0_.image_verso_id AS image_verso_id_40, h0_.disponibilite_papier_id AS disponibilite_papier_id_41, h0_.disponibilite_numerique_id AS disponibilite_numerique_id_42, h0_.disponibilite_audio_id AS disponibilite_audio_id_43, h0_.editeur_id AS editeur_id_44, h0_.collection_id AS collection_id_45, h0_.sous_collection_id AS sous_collection_id_46, h0_.nature_id AS nature_id_47, h0_.type_couverture_id AS type_couverture_id_48 FROM har_ouvrage h0_ INNER JOIN har_disponibilite_ouvrage h1_ ON h0_.disponibilite_papier_id = h1_.id WHERE h1_.externe_id NOT IN (?, ?) AND h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY h0_.a_la_une DESC, h0_.date_publication DESC
Parameters:
[ 5 6 4710 81853 81786 81663 80894 80858 80838 80509 80436 80086 79495 79004 78897 79141 78510 78487 78116 77501 77469 77337 77233 76611 76498 76369 75814 74058 74443 16142 16329 16378 98 199 307 526 608 810 1376 1430 1486 1504 1585 1589 1797 1810 1882 1926 1956 1995 2187 2181 2630 2705 2788 2873 2952 2996 3001 6912 3042 6949 6970 3312 3483 3649 3653 3664 3688 3703 3863 4029 4087 4157 4376 4529 4870 4936 5081 5100 5134 5184 5188 5196 7749 7774 7861 7863 7955 7976 8005 8308 8334 8381 8388 8391 8409 8422 8485 8551 8559 8640 8648 8756 8993 8999 9019 9055 9193 9269 9298 9306 9308 9325 9330 9459 9482 9638 9646 9658 9714 9774 9803 9943 9950 10227 10379 10534 10583 10584 10611 10781 10818 10825 10894 10943 10968 11001 11073 11084 11112 11385 11456 11514 11589 11622 11668 11702 11722 11865 11886 11874 11942 11945 11947 12026 12131 12137 12168 12212 12193 12199 12204 12322 12405 12496 12565 12556 12573 12666 12762 12749 12900 12975 13085 13119 13172 13183 13266 13288 13347 13389 13464 13533 13630 13777 13899 13986 14166 14278 14418 14437 14449 14496 14526 14575 14624 14621 14694 14759 15000 15003 15021 15034 15041 15139 15247 15271 15295 15368 15419 15496 15624 15640 15733 15748 16584 16573 16761 16840 16873 16958 16940 17226 17340 17383 17437 17423 17957 18025 18035 18037 18108 18158 18342 18396 18476 18631 18634 18656 18700 18778 18904 18940 19069 19057 19037 19364 19581 19593 19903 19923 19924 19937 19939 20237 20238 20563 20549 20579 20806 20812 20817 20888 20869 21262 21263 21259 21260 21282 21288 21286 21506 21495 21502 21535 21536 21527 21740 21741 21744 21738 21751 21777 21772 22072 22073 22074 22087 22077 22089 22280 22281 22282 22285 22316 22319 22323 22325 22561 22560 22598 22584 22588 22780 22766 22773 23062 23065 23096 23373 23625 24249 24238 24239 24278 24292 24297 24528 24561 24565 24567 24569 24794 24804 24823 25106 25113 25407 25399 25401 25425 25429 25919 25921 25924 25955 25954 25958 25961 25962 25963 25968 26140 26143 26147 26163 26479 26480 26508 26511 26517 26776 26797 26798 27063 27426 27710 27711 27731 27984 27988 27989 28028 28504 28506 28533 28651 28785 28799 29073 29074 29102 29384 29370 29374 29375 29621 29627 29628 29629 29930 29928 29934 29975 29953 29958 29967 29973 30255 30257 30264 30347 30377 30389 30440 30794 30801 30896 30901 31016 31045 31046 31111 31390 31339 31368 31429 31522 31802 31717 31853 31929 32136 31937 31977 32268 32445 32409 32538 32549 32684 33014 33175 33234 33367 33688 33596 33670 33528 34082 33752 33778 33952 33984 33986 34024 34309 34411 34457 34481 34511 34557 34679 34798 35067 34921 35022 35023 35048 35094 35175 35110 35123 35139 35248 35498 35500 35329 35399 35412 35451 35519 35600 35836 35617 35661 36023 36006 35970 35976 36081 36312 36318 36323 36241 36180 36129 36372 36399 36534 36524 36478 36454 36397 37014 37034 37039 36970 36984 36952 36921 36823 36836 36841 36843 36849 36693 36705 37213 37219 37107 37108 37431 37482 37397 37308 37835 37748 38072 38131 38093 38039 38467 38480 38421 38377 38348 38339 38242 38569 38513 38740 38663 38624 38549 38571 38518 38795 39011 38972 38979 38928 39284 39348 39283 39214 39225 39183 39185 39132 39442 39597 39615 39593 39566 39568 39522 39477 39434 39416 39431 39529 39953 39942 39896 39857 39876 39819 39711 40239 40163 40164 40165 40188 40105 40118 40119 40060 40090 40320 40434 40435 40296 40700 40674 40562 40544 40513 40474 40906 40813 40822 40765 40787 40746 40742 41224 41226 41266 41426 41399 41410 41380 41390 41354 41598 41539 41511 41460 42002 41962 41834 41769 42199 42204 42175 42180 42156 42155 42138 42109 42093 42094 42056 42046 42110 42452 42364 42331 42332 42321 42322 42716 42729 42507 42579 43020 42815 42819 42792 43336 43321 43154 43316 43516 43499 43372 43358 43652 43672 43810 43769 43759 43741 43713 43662 43861 43854 44122 44082 43913 43909 43880 44363 44369 44283 44284 44250 44160 44436 44577 44551 44503 44506 44510 44387 44460 76708 44615 44623 74730 44642 44727 44729 44749 44756 44823 44830 44837 44847 44891 44900 44907 45004 45082 45128 45179 45206 45234 45210 45280 45322 45333 45336 45345 45374 45387 45388 45411 45420 45455 45457 45495 45562 45582 45586 45594 45628 45727 45764 45800 45771 45820 45848 45853 45881 74794 45923 45947 46050 46065 46074 46081 46149 46460 46177 46213 46293 46342 46344 46473 46569 46608 46663 74873 74858 74803 46674 46686 46711 46762 46827 46842 47035 46865 46868 46952 46989 47009 47047 47112 47136 47183 47197 47200 47250 47282 47302 47368 47443 47448 47461 47484 47559 47582 47674 47690 47713 47762 47800 47801 47813 47840 47854 47880 47917 47948 48007 48012 48055 48080 48377 48417 48470 48507 48653 48689 48962 49012 49332 49508 49717 49692 50341 50305 50221 50621 50542 50860 50791 50794 50697 50919 51124 51291 51247 51183 51184 51205 51497 51483 51711 51708 51694 51696 51702 51674 51642 51570 51881 51851 51862 52089 51954 52321 52426 52346 52701 52703 52949 52939 52942 52760 52723 52819 53106 53326 53212 53358 53357 53465 53456 53538 53659 53899 53838 53791 53983 54540 54504 54517 54480 54444 54619 54647 54884 54963 55155 55113 55058 55085 55617 55535 55415 56113 56089 56312 56286 56162 56164 56344 56513 56434 56651 56645 56684 56748 56709 56710 56873 56983 57280 57239 57212 57136 57380 57352 57524 57493 57427 57799 57761 57663 57688 57633 57823 57917 57918 57925 57877 57880 57884 58088 58089 58176 58407 58209 58217 58234 58182 58470 58699 58664 58855 58821 58829 58727 58879 58895 58896 59102 59098 59244 59498 59514 59489 59490 59457 59468 59446 59528 59647 59534 59830 59801 59802 59756 59761 59726 59868 60080 60005 59940 59883 60133 60253 60192 60151 60166 60172 60109 60102 60153 60430 60355 60356 60400 60623 60547 60539 60467 60470 60487 60489 60447 60674 60662 62066 60776 62223 74908 60934 60886 60948 61040 61045 61007 61016 60970 60965 60952 61133 61100 61101 61173 61180 61296 61303 61266 61275 61317 61402 61361 61336 61337 61338 61351 62105 62109 62073 61991 ] |
|
42.18 ms (7.26%) |
53 |
SELECT t0.thematique_principale AS thematique_principale_1, t0.id AS id_2, t0.created AS created_3, t0.changed AS changed_4, t0.ouvrage_id AS ouvrage_id_5, t0.thematique_id AS thematique_id_6 FROM har_ouvrage_thematique t0 WHERE t0.ouvrage_id = ?
Parameters:
[
98
]
|
|
31.63 ms (5.45%) |
1 |
SELECT h0_.nom AS nom_0, h0_.prenom AS prenom_1, h0_.slug AS slug_2, h0_.photo_url_externe AS photo_url_externe_3, h0_.structure_professionnelle AS structure_professionnelle_4, h0_.site_web AS site_web_5, h0_.facebook AS facebook_6, h0_.twitter AS twitter_7, h0_.linkedin AS linkedin_8, h0_.instagram AS instagram_9, h0_.titres_diplomes AS titres_diplomes_10, h0_.fonctions_actuelles AS fonctions_actuelles_11, h0_.biographie AS biographie_12, h0_.autres_parutions AS autres_parutions_13, h0_.artiste_id AS artiste_id_14, h0_.externe_id AS externe_id_15, h0_.date_creation AS date_creation_16, h0_.date_modification AS date_modification_17, h0_.image_changed AS image_changed_18, h0_.id AS id_19, h0_.created AS created_20, h0_.changed AS changed_21, h0_.compte_id AS compte_id_22, h0_.photo_id AS photo_id_23, h0_.parent_id AS parent_id_24 FROM har_intervenant h0_ INNER JOIN har_ouvrage_intervenant h1_ ON h0_.id = h1_.intervenant_id WHERE h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY h0_.prenom ASC, h0_.nom ASC
Parameters:
[ 5988 6228 1149 5387 772 6339 27806 3855 1824 24547 21762 18014 7473 16055 5869 40306 17793 7417 2235 40312 40315 10835 35482 3976 23534 40324 20319 20405 18930 5753 40344 22281 7525 57433 42328 7533 12231 9789 12886 38027 49511 7545 17442 42375 50050 35595 60 22681 40378 28144 42412 7567 26539 24616 11887 6529 34968 37035 42499 19132 48304 18656 10154 16842 26542 14684 24618 10591 3251 24890 7629 10632 19454 70 26115 54593 23262 16579 10810 23650 40451 42664 21946 7662 5449 33908 23504 7171 18372 42699 2488 472 22074 25853 16124 21261 51490 42767 11904 40507 56554 40511 14496 25528 12398 26561 12544 18490 10540 19529 798 40530 680 42878 16575 26263 42893 16894 21150 22024 823 40558 18663 7747 311 26575 5462 5825 15257 42940 13021 42943 22888 42948 11732 957 39860 40587 5409 22557 23024 33641 40589 22341 37952 12117 824 23161 11793 33923 43070 2119 2979 638 23324 27172 12209 40628 20416 14364 22334 25788 43126 15057 33106 4712 19241 22697 5993 2385 11851 13433 15991 22976 21730 22854 16720 40673 38870 4948 19659 7858 24856 26587 38195 13702 29061 43300 3192 33312 29178 40598 43314 20868 2941 11322 12022 43321 967 419 11371 11057 34522 23070 40705 21348 40707 4684 5234 24371 26284 48427 22647 40725 23634 7912 22025 16128 17337 18952 49521 40739 21288 9689 38222 43476 40751 5830 40752 474 22365 43518 36834 30645 3765 3513 40770 22621 7951 20312 18726 21763 23330 43565 13879 3986 22276 13296 27279 50521 11112 3055 1205 43617 43621 26614 12942 13011 40814 11195 23223 13725 10225 43668 17190 12998 40822 15196 3195 423 15932 21713 33391 43484 10986 10927 13790 14383 21661 20270 21276 12468 16436 21078 7926 20681 26924 32182 13484 7396 39810 40874 15396 40882 37590 43831 12025 25863 26926 117 43874 43487 40903 5603 22324 984 49701 11862 3686 15741 22717 23184 18727 32492 40930 14783 23537 4812 54168 54596 8152 6792 50427 1826 5436 10138 14087 11848 20774 56871 25388 26633 22430 53441 44085 5392 26315 22483 3464 21108 40097 14816 13612 14406 19490 8212 22997 39825 17560 10593 23464 19610 10725 15784 44207 44208 12434 22790 12441 25160 21396 4540 17121 8251 44282 27432 20448 26326 24295 2426 16986 24596 6850 16727 22183 41054 1613 24414 20552 44333 21294 22346 11339 52165 44371 20641 41082 18583 1033 36889 2953 5183 20504 2000 41101 16896 2517 44484 17404 18633 15027 4841 41118 33560 10110 24507 4756 23648 34525 41134 11680 5241 18578 362 754 41151 26663 22548 13121 21011 35869 44631 23270 865 17366 44636 3208 5552 27522 22544 40096 17096 25728 18954 19937 37667 28140 3613 44684 41187 21030 41190 44690 44691 44703 3121 23465 44714 859 25975 36589 44742 44744 13996 4578 4972 26345 24674 17882 41220 3783 397 20600 8422 21737 3400 26948 24540 12238 36202 20428 5561 26505 50347 18334 16158 2803 20429 5324 21554 15517 26352 25162 8482 23352 18076 44944 763 44956 56935 26357 41309 1319 4524 4203 15809 23480 17637 22516 2196 8566 5144 14148 764 6415 41341 22507 16600 40053 25647 45135 20677 5947 21307 21382 17492 23705 26717 20140 535 25451 21634 19096 15703 49891 19800 45212 12137 12373 11393 13913 16029 26370 10250 37355 13246 15717 23707 9697 21169 45272 11617 19163 11 6115 19703 23084 2609 22537 10203 41425 29651 23025 19737 8642 41430 18181 27690 38472 21953 29182 22671 3132 13128 23561 14624 10934 19077 26733 39630 22184 39829 18319 5740 3851 11626 45441 2364 20526 41468 26963 18125 41476 3319 924 5652 22480 26216 23401 41485 22793 15181 3320 10768 5032 45592 25578 37751 3632 10804 26391 26747 21069 9606 16414 41531 57279 4285 23332 41545 13920 20873 45713 23312 41559 17705 22578 19834 11050 26186 26966 12833 14199 37363 10145 26405 4215 19810 32148 16145 5363 51283 19470 451 26762 33599 23232 832 15834 3440 45891 38544 13083 41619 12430 1013 17204 41627 18949 26969 25282 12595 41647 21039 49463 51793 25831 12612 14414 1744 38568 26090 14077 41677 15014 1217 10559 41680 2750 692 5961 302 39789 26974 46136 20520 21615 10665 21095 6808 22617 30662 46188 21084 26421 14159 46195 20647 9073 2275 18465 17195 23166 25075 11827 9082 24099 1164 10969 22616 50052 39735 16534 2621 16308 23036 19656 26976 26795 21146 6046 16148 5905 6567 25240 36709 46364 9830 1661 13490 41783 41784 26436 20046 3570 14736 19900 41810 22226 7084 15125 9159 41819 22227 5577 46512 20517 46524 3572 1395 49091 41834 21277 20719 21085 23047 46557 21356 23395 14109 575 22162 3233 14061 1081 11464 2700 46604 18719 14126 10589 14160 19721 17210 6526 13865 16895 3001 41890 12224 23113 12788 21758 27982 22574 46731 22826 14703 20907 10363 11427 46766 50110 21567 1833 22956 23711 9254 20539 23274 26044 41940 11015 26832 38674 41945 1113 22927 9944 33477 41953 26836 26463 22060 14700 18154 20612 22886 7192 22644 37110 19312 4454 39910 5367 18419 11706 46992 4237 9324 28027 20752 25055 22899 41993 5034 26847 558 3047 16619 28033 14780 25136 47081 42006 18989 21684 5329 1086 17683 20886 3740 47168 16103 12110 5368 26861 26475 47196 13141 8588 32460 22145 380 21328 12760 24985 28068 9448 49440 21175 25357 6211 20316 21739 13352 25734 22172 13704 11871 24069 24387 28693 5725 16419 36761 42118 26488 29664 4145 20875 24725 20822 42126 20211 6914 47474 21125 6276 9498 26511 22630 42141 9509 12968 16642 29658 26872 22243 11478 1757 33433 42161 42168 19663 42173 14960 19916 47623 7186 57423 ] |
|
29.19 ms (5.03%) |
1 |
SELECT h0_.type AS type_0, h0_.titre AS titre_1, h0_.slug AS slug_2, h0_.sous_titre AS sous_titre_3, h0_.tome AS tome_4, h0_.revue_numero AS revue_numero_5, h0_.resume AS resume_6, h0_.date_publication AS date_publication_7, h0_.biographie AS biographie_8, h0_.extrait_pdf AS extrait_pdf_9, h0_.extrait_audio AS extrait_audio_10, h0_.sommaire AS sommaire_11, h0_.date_modification AS date_modification_12, h0_.prix_papier AS prix_papier_13, h0_.prix_numerique AS prix_numerique_14, h0_.prix_audio AS prix_audio_15, h0_.disponibilite_epub AS disponibilite_epub_16, h0_.largeur AS largeur_17, h0_.hauteur AS hauteur_18, h0_.nb_pages AS nb_pages_19, h0_.poids AS poids_20, h0_.isbn AS isbn_21, h0_.ean13 AS ean13_22, h0_.ean_epub AS ean_epub_23, h0_.ean_pdf AS ean_pdf_24, h0_.multilingue AS multilingue_25, h0_.avis_expert AS avis_expert_26, h0_.externe_id AS externe_id_27, h0_.image_recto_url_externe AS image_recto_url_externe_28, h0_.image_verso_url_externe AS image_verso_url_externe_29, h0_.updated AS updated_30, h0_.added AS added_31, h0_.image_changed AS image_changed_32, h0_.a_la_une AS a_la_une_33, h0_.lien_aplat AS lien_aplat_34, h0_.id AS id_35, h0_.created AS created_36, h0_.changed AS changed_37, h0_.revue_id AS revue_id_38, h0_.image_recto_id AS image_recto_id_39, h0_.image_verso_id AS image_verso_id_40, h0_.disponibilite_papier_id AS disponibilite_papier_id_41, h0_.disponibilite_numerique_id AS disponibilite_numerique_id_42, h0_.disponibilite_audio_id AS disponibilite_audio_id_43, h0_.editeur_id AS editeur_id_44, h0_.collection_id AS collection_id_45, h0_.sous_collection_id AS sous_collection_id_46, h0_.nature_id AS nature_id_47, h0_.type_couverture_id AS type_couverture_id_48 FROM har_ouvrage h0_ INNER JOIN har_commande_detail h1_ ON h0_.id = h1_.ouvrage_id INNER JOIN har_disponibilite_ouvrage h2_ ON h0_.disponibilite_papier_id = h2_.id INNER JOIN har_collection h3_ ON h0_.collection_id = h3_.id WHERE h2_.externe_id NOT IN (?, ?) AND h3_.id = ? GROUP BY h0_.id ORDER BY SUM(h1_.quantity) DESC LIMIT 4
Parameters:
[ 5 6 68 ] |
|
25.59 ms (4.41%) |
14 |
SELECT t0.libelle AS libelle_1, t0.description AS description_2, t0.date AS date_3, t0.id AS id_4, t0.created AS created_5, t0.changed AS changed_6, t0.ouvrage_id AS ouvrage_id_7 FROM har_prix t0 WHERE t0.ouvrage_id = ?
Parameters:
[
57535
]
|
|
25.28 ms (4.35%) |
1 |
SELECT t0.type AS type_1, t0.titre AS titre_2, t0.slug AS slug_3, t0.sous_titre AS sous_titre_4, t0.tome AS tome_5, t0.revue_numero AS revue_numero_6, t0.resume AS resume_7, t0.date_publication AS date_publication_8, t0.biographie AS biographie_9, t0.extrait_pdf AS extrait_pdf_10, t0.extrait_audio AS extrait_audio_11, t0.sommaire AS sommaire_12, t0.date_modification AS date_modification_13, t0.prix_papier AS prix_papier_14, t0.prix_numerique AS prix_numerique_15, t0.prix_audio AS prix_audio_16, t0.disponibilite_epub AS disponibilite_epub_17, t0.largeur AS largeur_18, t0.hauteur AS hauteur_19, t0.nb_pages AS nb_pages_20, t0.poids AS poids_21, t0.isbn AS isbn_22, t0.ean13 AS ean13_23, t0.ean_epub AS ean_epub_24, t0.ean_pdf AS ean_pdf_25, t0.multilingue AS multilingue_26, t0.avis_expert AS avis_expert_27, t0.externe_id AS externe_id_28, t0.image_recto_url_externe AS image_recto_url_externe_29, t0.image_verso_url_externe AS image_verso_url_externe_30, t0.updated AS updated_31, t0.added AS added_32, t0.image_changed AS image_changed_33, t0.a_la_une AS a_la_une_34, t0.lien_aplat AS lien_aplat_35, t0.id AS id_36, t0.created AS created_37, t0.changed AS changed_38, t0.revue_id AS revue_id_39, t0.image_recto_id AS image_recto_id_40, t0.image_verso_id AS image_verso_id_41, t0.disponibilite_papier_id AS disponibilite_papier_id_42, t0.disponibilite_numerique_id AS disponibilite_numerique_id_43, t0.disponibilite_audio_id AS disponibilite_audio_id_44, t0.editeur_id AS editeur_id_45, t0.collection_id AS collection_id_46, t0.sous_collection_id AS sous_collection_id_47, t0.nature_id AS nature_id_48, t0.type_couverture_id AS type_couverture_id_49 FROM har_ouvrage t0 WHERE t0.collection_id = ?
Parameters:
[
68
]
|
|
21.06 ms (3.63%) |
4 |
SELECT DATABASE()
Parameters:
[] |
|
20.94 ms (3.60%) |
32 |
SELECT t0.libelle AS libelle_1, t0.slug AS slug_2, t0.description AS description_3, t0.level AS level_4, t0.externe_id AS externe_id_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.parent_id AS parent_id_9 FROM har_thematique t0 WHERE t0.id = ?
Parameters:
[
176
]
|
|
19.86 ms (3.42%) |
20 |
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters:
[ "/cmf/default/contents" "default_live" ] |
|
12.65 ms (2.18%) |
5 |
SELECT * FROM phpcr_nodes WHERE path = ? AND workspace_name = ? ORDER BY depth, sort_order ASC
Parameters:
[ "/cmf/default/contents" "default_live" ] |
|
12.32 ms (2.12%) |
1 |
SELECT 1 FROM phpcr_workspaces WHERE name = ?
Parameters:
[
"default_live"
]
|
|
12.06 ms (2.08%) |
1 |
SELECT a.id FROM har_intervenant a, har_ouvrage_intervenant b, har_ouvrage c, har_collection d WHERE d.id = :collection AND c.collection_id = d.id AND b.type_intervenant_id = :type AND b.ouvrage_id = c.id AND a.id = b.intervenant_id ORDER BY b.intervenant_position, a.nom
Parameters:
[ "collection" => 68 "type" => 1 ] |
|
11.01 ms (1.90%) |
1 |
SELECT c.id, c.nom, c.slug, count(*) as nbOuvrage FROM har_collection c INNER JOIN har_ouvrage o ON c.id = o.collection_id INNER JOIN har_ouvrage_thematique ot ON o.id = ot.ouvrage_id INNER JOIN har_disponibilite_ouvrage dp ON o.disponibilite_papier_id = dp.id WHERE ot.thematique_id = :thematique AND dp.externe_id NOT IN (:disponibilitePapierIds) GROUP BY c.id HAVING nbOuvrage > 0 ORDER BY c.nom DESC
Parameters:
[ "thematique" => 171 "disponibilitePapierIds" => "5,6" ] |
|
9.80 ms (1.69%) |
2 |
SELECT phpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract, phpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable, phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes, phpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names, phpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created, phpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected, phpcr_type_props.on_parent_version AS property_on_parent_version, phpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple, phpcr_type_props.fulltext_searchable AS property_fulltext_searchable, phpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value as property_default_value, phpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created, phpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected, phpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type, phpcr_type_childs.primary_types AS child_primary_types FROM phpcr_type_nodes LEFT JOIN phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id LEFT JOIN phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id
Parameters:
[] |
|
7.80 ms (1.34%) |
2 |
SELECT t0.nom AS nom_1, t0.disponible AS disponible_2, t0.externe_id AS externe_id_3, t0.id AS id_4, t0.created AS created_5, t0.changed AS changed_6 FROM har_disponibilite_ouvrage t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
7.69 ms (1.32%) |
3 |
SELECT t0.email AS email_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.telephone AS telephone_4, t0.telephone2 AS telephone2_5, t0.date_naissance AS date_naissance_6, t0.lieu_naissance AS lieu_naissance_7, t0.adresse_intitule AS adresse_intitule_8, t0.adresse AS adresse_9, t0.complement_adresse AS complement_adresse_10, t0.code_postal AS code_postal_11, t0.ville AS ville_12, t0.code_auteur AS code_auteur_13, t0.isni AS isni_14, t0.securite_sociale AS securite_sociale_15, t0.securite_social_numero AS securite_social_numero_16, t0.rib_iban AS rib_iban_17, t0.rib_bic AS rib_bic_18, t0.droits_num AS droits_num_19, t0.externe_id AS externe_id_20, t0.image_auteur_url_externe AS image_auteur_url_externe_21, t0.date_creation AS date_creation_22, t0.date_modification AS date_modification_23, t0.reference AS reference_24, t0.civilite AS civilite_25, t0.indicateur_telephonique AS indicateur_telephonique_26, t0.indicateur_telephonique2 AS indicateur_telephonique2_27, t0.societe AS societe_28, t0.numero_tva AS numero_tva_29, t0.siret AS siret_30, t0.latitude AS latitude_31, t0.longitude AS longitude_32, t0.ref_banque_intitule_compte AS ref_banque_intitule_compte_33, t0.ref_banque_iban AS ref_banque_iban_34, t0.ref_banque_code_swift AS ref_banque_code_swift_35, t0.image_changed AS image_changed_36, t0.client_auteur AS client_auteur_37, t0.id AS id_38, t0.created AS created_39, t0.changed AS changed_40, t0.idUser AS idUser_41, t0.image_auteur_id AS image_auteur_id_42, t0.code_pays_id AS code_pays_id_43 FROM har_compte t0 WHERE t0.idUser = ?
Parameters:
[
35411
]
|
|
5.12 ms (0.88%) |
33 |
SELECT t0.zone_principale AS zone_principale_1, t0.id AS id_2, t0.created AS created_3, t0.changed AS changed_4, t0.ouvrage_id AS ouvrage_id_5, t0.zone_geographique_id AS zone_geographique_id_6 FROM har_ouvrage_zone_geographique t0 WHERE t0.ouvrage_id = ?
Parameters:
[
1
]
|
|
4.52 ms (0.78%) |
1 |
SELECT h0_.libelle AS libelle_0, h0_.slug AS slug_1, h0_.description AS description_2, h0_.level AS level_3, h0_.externe_id AS externe_id_4, h0_.id AS id_5, h0_.created AS created_6, h0_.changed AS changed_7, h1_.libelle AS libelle_8, h1_.slug AS slug_9, h1_.description AS description_10, h1_.level AS level_11, h1_.externe_id AS externe_id_12, h1_.id AS id_13, h1_.created AS created_14, h1_.changed AS changed_15, h0_.parent_id AS parent_id_16, h1_.parent_id AS parent_id_17 FROM har_zone_geographique h0_ LEFT JOIN har_zone_geographique h1_ ON h0_.parent_id = h1_.id WHERE h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY h0_.libelle ASC
Parameters:
[ 114 3 10 127 20 57 113 126 135 21 38 119 216 1 60 83 112 86 246 8 28 67 104 141 155 168 176 316 321 322 7 9 36 94 123 129 131 154 165 167 211 220 223 303 318 324 328 61 68 69 70 93 96 116 128 134 137 139 148 150 152 157 161 162 166 169 173 175 187 191 212 221 222 227 236 240 242 243 275 282 289 306 319 323 325 327 331 341 342 343 344 ] |
|
3.23 ms (0.56%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND (n0.parent = '/cmf/snippets/main_menu' AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:snippet"]) > 0')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="i18n:fr-title"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:fr-title"]/sv:value[1]') ASC
Parameters:
[
"default_live"
]
|
|
3.19 ms (0.55%) |
1 |
SELECT h0_.titre AS titre_0, h0_.slug AS slug_1, h0_.format AS format_2, h0_.date_debut AS date_debut_3, h0_.date_fin AS date_fin_4, h0_.horaire AS horaire_5, h0_.resume AS resume_6, h0_.description AS description_7, h0_.savoir_plus AS savoir_plus_8, h0_.externe_id AS externe_id_9, h0_.en_ligne AS en_ligne_10, h0_.location AS location_11, h0_.nom_lieu AS nom_lieu_12, h0_.email AS email_13, h0_.informations AS informations_14, h0_.date_modification AS date_modification_15, h0_.id AS id_16, h0_.created AS created_17, h0_.changed AS changed_18, h0_.categorie_id AS categorie_id_19, h0_.image_id AS image_id_20 FROM har_evenement h0_ WHERE (h0_.date_debut >= ? OR (h0_.date_fin IS NOT NULL AND h0_.date_fin >= ?)) AND h0_.en_ligne = ? ORDER BY h0_.date_debut ASC LIMIT 4
Parameters:
[ "2026-02-04" "2026-02-04" 1 ] |
|
1.76 ms (0.30%) |
1 |
SELECT a.* FROM har_intervenant a, har_intervenant_collection b, har_collection c where c.id = :collection and b.type_intervenant_id = :type and b.collection_har_id = c.id and a.id = b.intervenant_id order by b.intervenant_position, a.nom
Parameters:
[ "collection" => 68 "type" => 23 ] |
|
1.73 ms (0.30%) |
5 |
SELECT t0.type_intervenant_position AS type_intervenant_position_1, t0.intervenant_position AS intervenant_position_2, t0.id AS id_3, t0.created AS created_4, t0.changed AS changed_5, t0.ouvrage_id AS ouvrage_id_6, t0.type_intervenant_id AS type_intervenant_id_7, t0.intervenant_id AS intervenant_id_8 FROM har_ouvrage_intervenant t0 WHERE t0.ouvrage_id = ?
Parameters:
[
81997
]
|
|
1.41 ms (0.24%) |
1 |
SELECT h0_.libelle AS libelle_0, h0_.slug AS slug_1, h0_.description AS description_2, h0_.level AS level_3, h0_.externe_id AS externe_id_4, h0_.id AS id_5, h0_.created AS created_6, h0_.changed AS changed_7, h1_.libelle AS libelle_8, h1_.slug AS slug_9, h1_.description AS description_10, h1_.level AS level_11, h1_.externe_id AS externe_id_12, h1_.id AS id_13, h1_.created AS created_14, h1_.changed AS changed_15, h0_.parent_id AS parent_id_16, h1_.parent_id AS parent_id_17 FROM har_thematique h0_ LEFT JOIN har_thematique h1_ ON h0_.parent_id = h1_.id WHERE h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY h1_.libelle ASC, h0_.libelle ASC
Parameters:
[ 173 165 176 175 166 170 182 171 185 167 180 314 23 186 193 255 160 174 177 344 362 181 244 254 327 369 400 5 28 35 140 141 151 184 209 257 291 300 307 315 323 329 348 349 370 372 373 385 ] |
|
1.18 ms (0.20%) |
1 |
SELECT count(DISTINCT h0_.id) AS sclr_0 FROM har_evenement h0_ WHERE (h0_.date_debut >= ? OR (h0_.date_fin IS NOT NULL AND h0_.date_fin >= ?)) AND h0_.en_ligne = ? ORDER BY h0_.date_debut ASC
Parameters:
[ "2026-02-04" "2026-02-04" 1 ] |
|
1.00 ms (0.17%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND (n0.parent = '/cmf/snippets/footer' AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:snippet"]) > 0')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="i18n:fr-title"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:fr-title"]/sv:value[1]') ASC
Parameters:
[
"default_live"
]
|
|
0.87 ms (0.15%) |
3 |
SELECT t0.method AS method_1, t0.options AS options_2, t0.id AS id_3, t0.idUsers AS idUsers_4 FROM se_user_two_factors t0 WHERE t0.idUsers = ?
Parameters:
[
35411
]
|
|
0.80 ms (0.14%) |
10 |
SELECT t0.libelle AS libelle_1, t0.slug AS slug_2, t0.description AS description_3, t0.level AS level_4, t0.externe_id AS externe_id_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.parent_id AS parent_id_9 FROM har_zone_geographique t0 WHERE t0.id = ?
Parameters:
[
2
]
|
|
0.51 ms (0.09%) |
1 |
SELECT t0.nom AS nom_1, t0.slug AS slug_2, t0.description AS description_3, t0.hors_collection AS hors_collection_4, t0.issn AS issn_5, t0.erp_id AS erp_id_6, t0.externe_id AS externe_id_7, t0.id AS id_8, t0.created AS created_9, t0.changed AS changed_10, t0.editeur_id AS editeur_id_11 FROM har_collection t0 WHERE t0.id = ?
Parameters:
[
68
]
|
|
0.36 ms (0.06%) |
3 |
SELECT t0.nom AS nom_1, t0.prenom AS prenom_2, t0.slug AS slug_3, t0.photo_url_externe AS photo_url_externe_4, t0.structure_professionnelle AS structure_professionnelle_5, t0.site_web AS site_web_6, t0.facebook AS facebook_7, t0.twitter AS twitter_8, t0.linkedin AS linkedin_9, t0.instagram AS instagram_10, t0.titres_diplomes AS titres_diplomes_11, t0.fonctions_actuelles AS fonctions_actuelles_12, t0.biographie AS biographie_13, t0.autres_parutions AS autres_parutions_14, t0.artiste_id AS artiste_id_15, t0.externe_id AS externe_id_16, t0.date_creation AS date_creation_17, t0.date_modification AS date_modification_18, t0.image_changed AS image_changed_19, t0.id AS id_20, t0.created AS created_21, t0.changed AS changed_22, t0.compte_id AS compte_id_23, t0.photo_id AS photo_id_24, t0.parent_id AS parent_id_25 FROM har_intervenant t0 WHERE t0.id = ?
Parameters:
[
5355
]
|
|
0.32 ms (0.06%) |
2 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND (EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:fr-template"]/sv:value[text()="homepage"]) > 0') AND (EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')))
Parameters:
[
"default_live"
]
|
|
0.22 ms (0.04%) |
1 |
SELECT h0_.nom AS nom_0, h0_.periode_validite_du AS periode_validite_du_1, h0_.periode_validite_au AS periode_validite_au_2, h0_.formats AS formats_3, h0_.cibles AS cibles_4, h0_.montant AS montant_5, h0_.enabled AS enabled_6, h0_.affichage_bandeau AS affichage_bandeau_7, h0_.filtre_par AS filtre_par_8, h0_.id AS id_9, h0_.created AS created_10, h0_.changed AS changed_11, h0_.thematique_id AS thematique_id_12, h0_.zone_geographique_id AS zone_geographique_id_13, h0_.collection_id AS collection_id_14, h0_.idUsersCreator AS idUsersCreator_15, h0_.idUsersChanger AS idUsersChanger_16 FROM har_code_avantage h0_ WHERE h0_.periode_validite_du <= ? AND h0_.periode_validite_au >= ? AND JSON_CONTAINS(h0_.cibles, ?) = 1 AND ((h0_.filtre_par IS NULL OR h0_.filtre_par = '')) AND h0_.enabled = 1 AND h0_.affichage_bandeau = 1 ORDER BY h0_.montant DESC LIMIT 1
Parameters:
[ "2026-02-04 00:00:00" "2026-02-04 00:00:00" "["client"]" ] |
|
0.21 ms (0.04%) |
1 |
SELECT h0_.type AS type_0, h0_.titre AS titre_1, h0_.slug AS slug_2, h0_.sous_titre AS sous_titre_3, h0_.tome AS tome_4, h0_.revue_numero AS revue_numero_5, h0_.resume AS resume_6, h0_.date_publication AS date_publication_7, h0_.biographie AS biographie_8, h0_.extrait_pdf AS extrait_pdf_9, h0_.extrait_audio AS extrait_audio_10, h0_.sommaire AS sommaire_11, h0_.date_modification AS date_modification_12, h0_.prix_papier AS prix_papier_13, h0_.prix_numerique AS prix_numerique_14, h0_.prix_audio AS prix_audio_15, h0_.disponibilite_epub AS disponibilite_epub_16, h0_.largeur AS largeur_17, h0_.hauteur AS hauteur_18, h0_.nb_pages AS nb_pages_19, h0_.poids AS poids_20, h0_.isbn AS isbn_21, h0_.ean13 AS ean13_22, h0_.ean_epub AS ean_epub_23, h0_.ean_pdf AS ean_pdf_24, h0_.multilingue AS multilingue_25, h0_.avis_expert AS avis_expert_26, h0_.externe_id AS externe_id_27, h0_.image_recto_url_externe AS image_recto_url_externe_28, h0_.image_verso_url_externe AS image_verso_url_externe_29, h0_.updated AS updated_30, h0_.added AS added_31, h0_.image_changed AS image_changed_32, h0_.a_la_une AS a_la_une_33, h0_.lien_aplat AS lien_aplat_34, h0_.id AS id_35, h0_.created AS created_36, h0_.changed AS changed_37, h0_.revue_id AS revue_id_38, h0_.image_recto_id AS image_recto_id_39, h0_.image_verso_id AS image_verso_id_40, h0_.disponibilite_papier_id AS disponibilite_papier_id_41, h0_.disponibilite_numerique_id AS disponibilite_numerique_id_42, h0_.disponibilite_audio_id AS disponibilite_audio_id_43, h0_.editeur_id AS editeur_id_44, h0_.collection_id AS collection_id_45, h0_.sous_collection_id AS sous_collection_id_46, h0_.nature_id AS nature_id_47, h0_.type_couverture_id AS type_couverture_id_48 FROM har_ouvrage h0_ WHERE h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 78324 19666 77717 76148 74008 75862 2895 1461 537 13 1830 1 8 9 10 1046 11 12 14 6434 16092 74511 6402 16137 17636 23898 74344 4710 74399 74481 73971 57535 16 ] |
|
0.20 ms (0.03%) |
1 |
SELECT h0_.titre AS titre_0, h0_.source AS source_1, h0_.media AS media_2, h0_.media_url AS media_url_3, h0_.lien AS lien_4, h0_.lien_url AS lien_url_5, h0_.mois AS mois_6, h0_.annee AS annee_7, h0_.externe_id AS externe_id_8, h0_.en_ligne AS en_ligne_9, h0_.date_modification AS date_modification_10, h0_.id AS id_11, h0_.created AS created_12, h0_.changed AS changed_13, h0_.categorie_id AS categorie_id_14, h0_.media_image_id AS media_image_id_15, h0_.lien_fichier_id AS lien_fichier_id_16, h0_.idUsersCreator AS idUsersCreator_17, h0_.idUsersChanger AS idUsersChanger_18 FROM har_actualite_media h0_ WHERE h0_.en_ligne = ? ORDER BY h0_.created DESC LIMIT 3
Parameters:
[
1
]
|
|
0.18 ms (0.03%) |
1 |
SELECT h0_.type AS type_0, h0_.titre AS titre_1, h0_.slug AS slug_2, h0_.sous_titre AS sous_titre_3, h0_.tome AS tome_4, h0_.revue_numero AS revue_numero_5, h0_.resume AS resume_6, h0_.date_publication AS date_publication_7, h0_.biographie AS biographie_8, h0_.extrait_pdf AS extrait_pdf_9, h0_.extrait_audio AS extrait_audio_10, h0_.sommaire AS sommaire_11, h0_.date_modification AS date_modification_12, h0_.prix_papier AS prix_papier_13, h0_.prix_numerique AS prix_numerique_14, h0_.prix_audio AS prix_audio_15, h0_.disponibilite_epub AS disponibilite_epub_16, h0_.largeur AS largeur_17, h0_.hauteur AS hauteur_18, h0_.nb_pages AS nb_pages_19, h0_.poids AS poids_20, h0_.isbn AS isbn_21, h0_.ean13 AS ean13_22, h0_.ean_epub AS ean_epub_23, h0_.ean_pdf AS ean_pdf_24, h0_.multilingue AS multilingue_25, h0_.avis_expert AS avis_expert_26, h0_.externe_id AS externe_id_27, h0_.image_recto_url_externe AS image_recto_url_externe_28, h0_.image_verso_url_externe AS image_verso_url_externe_29, h0_.updated AS updated_30, h0_.added AS added_31, h0_.image_changed AS image_changed_32, h0_.a_la_une AS a_la_une_33, h0_.lien_aplat AS lien_aplat_34, h0_.id AS id_35, h0_.created AS created_36, h0_.changed AS changed_37, h0_.revue_id AS revue_id_38, h0_.image_recto_id AS image_recto_id_39, h0_.image_verso_id AS image_verso_id_40, h0_.disponibilite_papier_id AS disponibilite_papier_id_41, h0_.disponibilite_numerique_id AS disponibilite_numerique_id_42, h0_.disponibilite_audio_id AS disponibilite_audio_id_43, h0_.editeur_id AS editeur_id_44, h0_.collection_id AS collection_id_45, h0_.sous_collection_id AS sous_collection_id_46, h0_.nature_id AS nature_id_47, h0_.type_couverture_id AS type_couverture_id_48 FROM har_ouvrage h0_ INNER JOIN har_disponibilite_ouvrage h1_ ON h0_.disponibilite_papier_id = h1_.id WHERE h1_.externe_id NOT IN (?, ?) AND h0_.id IN (?, ?, ?, ?, ?) ORDER BY h0_.a_la_une DESC, h0_.date_publication DESC
Parameters:
[ 5 6 81875 81893 82005 82006 81997 ] |
|
0.15 ms (0.03%) |
1 |
SELECT t0.version AS version_1, t0.id AS id_2, t0.created AS created_3, t0.changed AS changed_4, t0.idMedia AS idMedia_5, t0.idUsersCreator AS idUsersCreator_6, t0.idUsersChanger AS idUsersChanger_7 FROM me_files t0 WHERE t0.idMedia = ?
Parameters:
[
128995
]
|
|
0.14 ms (0.02%) |
1 |
SELECT h0_.nom AS nom_0, h0_.issn AS issn_1, h0_.position AS position_2, h0_.externe_id AS externe_id_3, h0_.id AS id_4, h0_.created AS created_5, h0_.changed AS changed_6, h0_.collection_id AS collection_id_7 FROM har_sous_collection h0_ WHERE h0_.id IN (NULL) ORDER BY h0_.nom ASC
Parameters:
[] |
|
0.14 ms (0.02%) |
1 |
SELECT t0.type AS type_1, t0.titre AS titre_2, t0.slug AS slug_3, t0.sous_titre AS sous_titre_4, t0.tome AS tome_5, t0.revue_numero AS revue_numero_6, t0.resume AS resume_7, t0.date_publication AS date_publication_8, t0.biographie AS biographie_9, t0.extrait_pdf AS extrait_pdf_10, t0.extrait_audio AS extrait_audio_11, t0.sommaire AS sommaire_12, t0.date_modification AS date_modification_13, t0.prix_papier AS prix_papier_14, t0.prix_numerique AS prix_numerique_15, t0.prix_audio AS prix_audio_16, t0.disponibilite_epub AS disponibilite_epub_17, t0.largeur AS largeur_18, t0.hauteur AS hauteur_19, t0.nb_pages AS nb_pages_20, t0.poids AS poids_21, t0.isbn AS isbn_22, t0.ean13 AS ean13_23, t0.ean_epub AS ean_epub_24, t0.ean_pdf AS ean_pdf_25, t0.multilingue AS multilingue_26, t0.avis_expert AS avis_expert_27, t0.externe_id AS externe_id_28, t0.image_recto_url_externe AS image_recto_url_externe_29, t0.image_verso_url_externe AS image_verso_url_externe_30, t0.updated AS updated_31, t0.added AS added_32, t0.image_changed AS image_changed_33, t0.a_la_une AS a_la_une_34, t0.lien_aplat AS lien_aplat_35, t0.id AS id_36, t0.created AS created_37, t0.changed AS changed_38, t0.revue_id AS revue_id_39, t0.image_recto_id AS image_recto_id_40, t0.image_verso_id AS image_verso_id_41, t0.disponibilite_papier_id AS disponibilite_papier_id_42, t0.disponibilite_numerique_id AS disponibilite_numerique_id_43, t0.disponibilite_audio_id AS disponibilite_audio_id_44, t0.editeur_id AS editeur_id_45, t0.collection_id AS collection_id_46, t0.sous_collection_id AS sous_collection_id_47, t0.nature_id AS nature_id_48, t0.type_couverture_id AS type_couverture_id_49 FROM har_ouvrage t0 WHERE t0.id IN (NULL)
Parameters:
[] |
|
0.13 ms (0.02%) |
1 |
SELECT t0.id AS id_1, t0.created AS created_2, t0.changed AS changed_3, t0.idMediaTypes AS idMediaTypes_4, t0.idPreviewImage AS idPreviewImage_5, t0.idCollections AS idCollections_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM me_media t0 WHERE t0.id = ?
Parameters:
[
128995
]
|
|
0.13 ms (0.02%) |
1 |
SELECT DISTINCT h0_.indicateur_telephonique AS indicateur_telephonique_0 FROM har_code_pays h0_ WHERE h0_.indicateur_telephonique IS NOT NULL AND h0_.indisponible = ? ORDER BY CAST(h0_.indicateur_telephonique AS signed) ASC
Parameters:
[
0
]
|
|
0.12 ms (0.02%) |
1 |
SELECT prefix, uri FROM phpcr_namespaces
Parameters:
[] |
|
0.12 ms (0.02%) |
1 |
SELECT t0.nom AS nom_1, t0.nom_abrege AS nom_abrege_2, t0.slug AS slug_3, t0.description AS description_4, t0.gln AS gln_5, t0.groupehmt AS groupehmt_6, t0.type AS type_7, t0.adresse AS adresse_8, t0.code_postal AS code_postal_9, t0.ville AS ville_10, t0.telephone AS telephone_11, t0.telephone2 AS telephone2_12, t0.email AS email_13, t0.url AS url_14, t0.externe_id AS externe_id_15, t0.date_creation AS date_creation_16, t0.date_modification AS date_modification_17, t0.id AS id_18, t0.created AS created_19, t0.changed AS changed_20, t0.logo_id AS logo_id_21, t0.code_pays_id AS code_pays_id_22 FROM har_editeur t0 WHERE t0.id = ?
Parameters:
[
8
]
|
|
0.09 ms (0.02%) |
1 |
SELECT t0.name AS name_1, t0.version AS version_2, t0.subVersion AS subVersion_3, t0.size AS size_4, t0.downloadCounter AS downloadCounter_5, t0.storageOptions AS storageOptions_6, t0.mimeType AS mimeType_7, t0.properties AS properties_8, t0.focusPointX AS focusPointX_9, t0.focusPointY AS focusPointY_10, t0.id AS id_11, t0.created AS created_12, t0.changed AS changed_13, t0.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_14, t0.idFiles AS idFiles_15, t0.idUsersCreator AS idUsersCreator_16, t0.idUsersChanger AS idUsersChanger_17 FROM me_file_versions t0 WHERE t0.idFiles = ?
Parameters:
[
128995
]
|
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.