Symfony Profiler

Query Metrics

324 Database Queries

46 Different statements

494.00 ms Query time

0 Invalid entities

Grouped Statements

Time▼	Count	Info
88.20 ms (17.85%)	71	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`] View formatted query View runnable query Explain query 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 = ? 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 = 232567;
75.86 ms (15.36%)	15	SELECT * FROM phpcr_nodes WHERE identifier = ? AND workspace_name = ? Parameters: [`"dd991113-3aa4-4e99-b3f3-684362ec7aa8" "default_live"`] View formatted query View runnable query Explain query SELECT * FROM phpcr_nodes WHERE identifier = ? AND workspace_name = ? SELECT * FROM phpcr_nodes WHERE identifier = 'dd991113-3aa4-4e99-b3f3-684362ec7aa8' AND workspace_name = 'default_live';
53.84 ms (10.90%)	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: [43981 91 1029 29359 742 4463 49511 2440 2986 3801 6777 12599 47211 455 1576 3252 3705 3976 4370 6691 9703 15057 25693 26044 33551 36763 40470 45561 48301 50107 320 419 1450 3730 3993 4194 4611 4707 5296 6059 6646 11175 13058 13366 20290 20648 22089 26120 26963 28167 28168 36728 446 747 841 868 998 1026 1086 1207 1488 1536 1671 1682 1718 2371 2513 2664 2759 3066 3133 4260 4765 4767 5225 5867 6560 7473 7482 7501 7504 8397 8737 9545 9795 10321 11214 11413 11587 12022 12304 12783 12822 13152 13835 14572 15103 16113 16757 16872 17152 17586 18125 18510 18534 19137 19600 19990 20103 20683 20718 20838 20865 21046 21311 21589 21609 22771 22974 23235 23875 24221 24880 25101 25285 25561 25748 26177 26635 26752 26828 27568 27847 28054 28363 29075 30239 32048 35647 35707 36295 40459 41291 42093 42619 43021 44572 45125 45514 45543 45793 49568 49771 50117 50437 46 62 149 347 405 524 527 531 548 598 695 734 752 754 804 854 977 990 1098 1328 1330 1380 1386 1395 1503 1583 1668 1722 1930 1976 1993 2011 2038 2070 2088 2098 2169 2230 2318 2400 2501 2526 2582 2598 2771 2833 2853 2927 2938 2941 2947 2972 3030 3141 3159 3208 3242 3357 3453 3466 3523 3527 3563 3666 3686 3723 3746 3821 3837 3839 3955 4014 4106 4138 4148 4179 4215 4262 4276 4294 4357 4363 4400 4412 4457 4485 4616 4656 4660 4688 4741 4812 4937 4962 5034 5077 5177 5187 5189 5211 5271 5423 5425 5517 5651 5664 5680 5686 5722 5828 5853 5855 5856 5859 5925 6025 6219 6224 6247 6302 6370 6552 6677 6683 6743 6840 6877 6906 6908 6938 6952 6999 7026 7127 7154 7167 7170 7185 7229 7243 7247 7266 7383 7487 7515 7553 7568 7584 7592 7662 7691 7741 7767 7815 7828 7844 7854 8189 8190 8194 8200 8329 8387 8529 8903 8940 8970 9142 9167 9240 9263 9314 9357 9386 9406 9413 9426 9467 9473 9486 9560 9643 9671 9698 9753 9780 9794 9865 9875 9886 10054 10066 10230 10263 10586 10645 10666 10685 10718 10774 10834 10886 10913 10923 11006 11020 11138 11144 11149 11177 11186 11187 11339 11430 11449 11472 11648 11778 11835 11947 12192 12395 12523 12570 12583 12678 12693 12738 12776 12897 12995 12996 13150 13268 13277 13310 13324 13396 13415 13506 13536 13632 13684 13700 13755 13804 13817 13870 13897 14150 14289 14554 14555 14598 14634 14725 14743 14758 14810 14844 14874 15002 15041 15102 15203 15204 15212 15236 15239 15249 15254 15265 15280 15281 15329 15386 15435 15480 15505 15527 15603 15604 15613 15614 15643 15709 15715 15781 15813 15835 15996 15999 16000 16234 16306 16367 16370 16374 16400 16402 16475 16561 16589 16590 16605 16696 16878 17017 17062 17078 17080 17081 17103 17122 17261 17328 17354 17437 17469 17473 17482 17509 17534 17541 17572 17595 17616 17661 17729 17732 17792 17815 17912 18006 18045 18059 18079 18086 18122 18162 18171 18250 18339 18426 18439 18443 18452 18500 18639 18682 18819 18948 18950 19020 19085 19126 19162 19200 19440 19497 19500 19501 19512 19561 19616 19638 19735 19812 19839 19859 19863 19927 19964 19974 20010 20014 20033 20065 20084 20114 20128 20210 20218 20376 20389 20397 20447 20576 20616 20629 20640 20679 20780 20796 20804 20808 20816 20879 20888 20913 20927 20928 20958 21018 21110 21132 21173 21204 21250 21332 21404 21502 21542 21625 21646 21654 21799 21805 21808 21810 21893 21961 21991 21992 21998 22071 22081 22113 22124 22141 22198 22203 22207 22270 22283 22286 22295 22296 22350 22364 22451 22618 22694 22700 22722 22749 22756 22773 22826 22849 22933 22941 22970 23048 23059 23158 23215 23306 23351 23561 23705 23748 23806 23987 24031 24133 24207 24237 24336 24353 24461 24482 24514 24537 24617 24652 24668 24721 24909 24935 24955 25024 25054 25083 25128 25146 25157 25212 25290 25299 25337 25371 25377 25514 25522 25548 25572 25597 25660 25706 25727 25890 25907 25922 26013 26096 26236 26239 26543 26582 26604 26628 26655 26672 26763 26977 26989 27010 27020 27065 27115 27194 27262 27264 27282 27314 27527 27603 27606 27663 27737 27764 27773 27775 27848 27928 27946 27986 27997 28001 28133 28135 28301 28319 28369 28413 28422 28533 28768 28933 29031 29037 29044 29289 29520 29553 29599 29701 29713 29751 29948 30002 30050 30092 30123 30392 30447 30508 30525 30664 30665 30678 30747 31149 31255 31259 31312 31414 31417 31418 31440 31547 31694 31764 31784 31846 31848 31882 31894 31895 31954 32052 32061 32156 32186 32298 32428 32531 32619 32676 32721 32760 32933 33034 33035 33142 33169 33280 33281 33282 33326 33327 33328 33329 33330 33331 33332 33333 33334 33337 33338 33423 33461 33466 33499 33500 33525 33552 33697 33788 33881 33986 34056 34150 34183 34186 34198 34201 34253 34285 34613 34726 34819 34829 34890 34897 35087 35360 35472 35474 35519 35522 35552 35650 35787 35821 36065 36066 36186 36187 36297 36371 36723 36725 37046 37056 37090 37111 37425 37466 37658 38014 38161 38209 38310 38318 38361 38430 38704 39091 39101 39367 39563 39662 39697 39725 39780 39886 40037 40117 40139 40257 40276 40311 40348 40498 40792 40800 40845 41167 41184 41293 41461 41494 41548 41811 41820 41847 41905 41907 42004 42015 42251 42252 42268 42269 42270 42286 42318 42350 42379 42413 42427 42477 42487 42527 42574 42591 42593 42627 42676 42712 42759 42875 43055 43062 43116 43136 43187 43190 43211 43218 43271 43411 43529 43788 43815 43904 43949 43965 43978 44007 44143 44187 44213 44395 44407 44493 44554 44575 44587 44615 44635 44636 44832 44875 44942 44955 44989 45318 45391 45400 45430 45662 45702 45726 45735 45745 45754 45804 45805 45821 45848 45982 46041 46086 46158 46208 46242 46309 46353 46354 46410 46446 46599 46700 46706 46710 46731 46732 46733 46766 46823 46902 46917 46918 46923 46941 47151 47154 47197 47337 47398 47414 47415 47547 47590 47615 47631 48273 48972 49174 49379 49382 49487 49567 49626 49657 49687 49765 49889 50048 50279 50321 50391 50442 50480 50481 50598 50894 50912 50918 51158 51208 51399 51428 51461 51569 51598 51623 51889 51890 51970 52010 52088 52124 52364 52593 52599 52663 52664 52673 52708 52750 52756 52759 52771 53741 53760 53888 53901 53911 54032 54187 54493 54570 54617 54623 54691 54726 54748 54754 54755 54948 55028 55100 55152 55245 55301 55333 55354 55413 55432 55532 55734 55744 55763 55767 56105 56313 56325 56607 56608 56609 56678 57881 57915 58444 58477 58577 59375 59541 59542 59763] View formatted query View runnable query Explain query 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 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 (43981, 91, 1029, 29359, 742, 4463, 49511, 2440, 2986, 3801, 6777, 12599, 47211, 455, 1576, 3252, 3705, 3976, 4370, 6691, 9703, 15057, 25693, 26044, 33551, 36763, 40470, 45561, 48301, 50107, 320, 419, 1450, 3730, 3993, 4194, 4611, 4707, 5296, 6059, 6646, 11175, 13058, 13366, 20290, 20648, 22089, 26120, 26963, 28167, 28168, 36728, 446, 747, 841, 868, 998, 1026, 1086, 1207, 1488, 1536, 1671, 1682, 1718, 2371, 2513, 2664, 2759, 3066, 3133, 4260, 4765, 4767, 5225, 5867, 6560, 7473, 7482, 7501, 7504, 8397, 8737, 9545, 9795, 10321, 11214, 11413, 11587, 12022, 12304, 12783, 12822, 13152, 13835, 14572, 15103, 16113, 16757, 16872, 17152, 17586, 18125, 18510, 18534, 19137, 19600, 19990, 20103, 20683, 20718, 20838, 20865, 21046, 21311, 21589, 21609, 22771, 22974, 23235, 23875, 24221, 24880, 25101, 25285, 25561, 25748, 26177, 26635, 26752, 26828, 27568, 27847, 28054, 28363, 29075, 30239, 32048, 35647, 35707, 36295, 40459, 41291, 42093, 42619, 43021, 44572, 45125, 45514, 45543, 45793, 49568, 49771, 50117, 50437, 46, 62, 149, 347, 405, 524, 527, 531, 548, 598, 695, 734, 752, 754, 804, 854, 977, 990, 1098, 1328, 1330, 1380, 1386, 1395, 1503, 1583, 1668, 1722, 1930, 1976, 1993, 2011, 2038, 2070, 2088, 2098, 2169, 2230, 2318, 2400, 2501, 2526, 2582, 2598, 2771, 2833, 2853, 2927, 2938, 2941, 2947, 2972, 3030, 3141, 3159, 3208, 3242, 3357, 3453, 3466, 3523, 3527, 3563, 3666, 3686, 3723, 3746, 3821, 3837, 3839, 3955, 4014, 4106, 4138, 4148, 4179, 4215, 4262, 4276, 4294, 4357, 4363, 4400, 4412, 4457, 4485, 4616, 4656, 4660, 4688, 4741, 4812, 4937, 4962, 5034, 5077, 5177, 5187, 5189, 5211, 5271, 5423, 5425, 5517, 5651, 5664, 5680, 5686, 5722, 5828, 5853, 5855, 5856, 5859, 5925, 6025, 6219, 6224, 6247, 6302, 6370, 6552, 6677, 6683, 6743, 6840, 6877, 6906, 6908, 6938, 6952, 6999, 7026, 7127, 7154, 7167, 7170, 7185, 7229, 7243, 7247, 7266, 7383, 7487, 7515, 7553, 7568, 7584, 7592, 7662, 7691, 7741, 7767, 7815, 7828, 7844, 7854, 8189, 8190, 8194, 8200, 8329, 8387, 8529, 8903, 8940, 8970, 9142, 9167, 9240, 9263, 9314, 9357, 9386, 9406, 9413, 9426, 9467, 9473, 9486, 9560, 9643, 9671, 9698, 9753, 9780, 9794, 9865, 9875, 9886, 10054, 10066, 10230, 10263, 10586, 10645, 10666, 10685, 10718, 10774, 10834, 10886, 10913, 10923, 11006, 11020, 11138, 11144, 11149, 11177, 11186, 11187, 11339, 11430, 11449, 11472, 11648, 11778, 11835, 11947, 12192, 12395, 12523, 12570, 12583, 12678, 12693, 12738, 12776, 12897, 12995, 12996, 13150, 13268, 13277, 13310, 13324, 13396, 13415, 13506, 13536, 13632, 13684, 13700, 13755, 13804, 13817, 13870, 13897, 14150, 14289, 14554, 14555, 14598, 14634, 14725, 14743, 14758, 14810, 14844, 14874, 15002, 15041, 15102, 15203, 15204, 15212, 15236, 15239, 15249, 15254, 15265, 15280, 15281, 15329, 15386, 15435, 15480, 15505, 15527, 15603, 15604, 15613, 15614, 15643, 15709, 15715, 15781, 15813, 15835, 15996, 15999, 16000, 16234, 16306, 16367, 16370, 16374, 16400, 16402, 16475, 16561, 16589, 16590, 16605, 16696, 16878, 17017, 17062, 17078, 17080, 17081, 17103, 17122, 17261, 17328, 17354, 17437, 17469, 17473, 17482, 17509, 17534, 17541, 17572, 17595, 17616, 17661, 17729, 17732, 17792, 17815, 17912, 18006, 18045, 18059, 18079, 18086, 18122, 18162, 18171, 18250, 18339, 18426, 18439, 18443, 18452, 18500, 18639, 18682, 18819, 18948, 18950, 19020, 19085, 19126, 19162, 19200, 19440, 19497, 19500, 19501, 19512, 19561, 19616, 19638, 19735, 19812, 19839, 19859, 19863, 19927, 19964, 19974, 20010, 20014, 20033, 20065, 20084, 20114, 20128, 20210, 20218, 20376, 20389, 20397, 20447, 20576, 20616, 20629, 20640, 20679, 20780, 20796, 20804, 20808, 20816, 20879, 20888, 20913, 20927, 20928, 20958, 21018, 21110, 21132, 21173, 21204, 21250, 21332, 21404, 21502, 21542, 21625, 21646, 21654, 21799, 21805, 21808, 21810, 21893, 21961, 21991, 21992, 21998, 22071, 22081, 22113, 22124, 22141, 22198, 22203, 22207, 22270, 22283, 22286, 22295, 22296, 22350, 22364, 22451, 22618, 22694, 22700, 22722, 22749, 22756, 22773, 22826, 22849, 22933, 22941, 22970, 23048, 23059, 23158, 23215, 23306, 23351, 23561, 23705, 23748, 23806, 23987, 24031, 24133, 24207, 24237, 24336, 24353, 24461, 24482, 24514, 24537, 24617, 24652, 24668, 24721, 24909, 24935, 24955, 25024, 25054, 25083, 25128, 25146, 25157, 25212, 25290, 25299, 25337, 25371, 25377, 25514, 25522, 25548, 25572, 25597, 25660, 25706, 25727, 25890, 25907, 25922, 26013, 26096, 26236, 26239, 26543, 26582, 26604, 26628, 26655, 26672, 26763, 26977, 26989, 27010, 27020, 27065, 27115, 27194, 27262, 27264, 27282, 27314, 27527, 27603, 27606, 27663, 27737, 27764, 27773, 27775, 27848, 27928, 27946, 27986, 27997, 28001, 28133, 28135, 28301, 28319, 28369, 28413, 28422, 28533, 28768, 28933, 29031, 29037, 29044, 29289, 29520, 29553, 29599, 29701, 29713, 29751, 29948, 30002, 30050, 30092, 30123, 30392, 30447, 30508, 30525, 30664, 30665, 30678, 30747, 31149, 31255, 31259, 31312, 31414, 31417, 31418, 31440, 31547, 31694, 31764, 31784, 31846, 31848, 31882, 31894, 31895, 31954, 32052, 32061, 32156, 32186, 32298, 32428, 32531, 32619, 32676, 32721, 32760, 32933, 33034, 33035, 33142, 33169, 33280, 33281, 33282, 33326, 33327, 33328, 33329, 33330, 33331, 33332, 33333, 33334, 33337, 33338, 33423, 33461, 33466, 33499, 33500, 33525, 33552, 33697, 33788, 33881, 33986, 34056, 34150, 34183, 34186, 34198, 34201, 34253, 34285, 34613, 34726, 34819, 34829, 34890, 34897, 35087, 35360, 35472, 35474, 35519, 35522, 35552, 35650, 35787, 35821, 36065, 36066, 36186, 36187, 36297, 36371, 36723, 36725, 37046, 37056, 37090, 37111, 37425, 37466, 37658, 38014, 38161, 38209, 38310, 38318, 38361, 38430, 38704, 39091, 39101, 39367, 39563, 39662, 39697, 39725, 39780, 39886, 40037, 40117, 40139, 40257, 40276, 40311, 40348, 40498, 40792, 40800, 40845, 41167, 41184, 41293, 41461, 41494, 41548, 41811, 41820, 41847, 41905, 41907, 42004, 42015, 42251, 42252, 42268, 42269, 42270, 42286, 42318, 42350, 42379, 42413, 42427, 42477, 42487, 42527, 42574, 42591, 42593, 42627, 42676, 42712, 42759, 42875, 43055, 43062, 43116, 43136, 43187, 43190, 43211, 43218, 43271, 43411, 43529, 43788, 43815, 43904, 43949, 43965, 43978, 44007, 44143, 44187, 44213, 44395, 44407, 44493, 44554, 44575, 44587, 44615, 44635, 44636, 44832, 44875, 44942, 44955, 44989, 45318, 45391, 45400, 45430, 45662, 45702, 45726, 45735, 45745, 45754, 45804, 45805, 45821, 45848, 45982, 46041, 46086, 46158, 46208, 46242, 46309, 46353, 46354, 46410, 46446, 46599, 46700, 46706, 46710, 46731, 46732, 46733, 46766, 46823, 46902, 46917, 46918, 46923, 46941, 47151, 47154, 47197, 47337, 47398, 47414, 47415, 47547, 47590, 47615, 47631, 48273, 48972, 49174, 49379, 49382, 49487, 49567, 49626, 49657, 49687, 49765, 49889, 50048, 50279, 50321, 50391, 50442, 50480, 50481, 50598, 50894, 50912, 50918, 51158, 51208, 51399, 51428, 51461, 51569, 51598, 51623, 51889, 51890, 51970, 52010, 52088, 52124, 52364, 52593, 52599, 52663, 52664, 52673, 52708, 52750, 52756, 52759, 52771, 53741, 53760, 53888, 53901, 53911, 54032, 54187, 54493, 54570, 54617, 54623, 54691, 54726, 54748, 54754, 54755, 54948, 55028, 55100, 55152, 55245, 55301, 55333, 55354, 55413, 55432, 55532, 55734, 55744, 55763, 55767, 56105, 56313, 56325, 56607, 56608, 56609, 56678, 57881, 57915, 58444, 58477, 58577, 59375, 59541, 59542, 59763) ORDER BY h0_.prenom ASC, h0_.nom ASC;
46.63 ms (9.44%)	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 81850 81973 81948 81882 81803 81698 81709 81657 81755 80895 80680 80658 80681 80626 80530 80600 80392 80289 80340 80362 80372 80012 80029 79943 79894 79786 79858 79802 79834 79722 79587 79498 79454 79389 79196 79353 79360 79300 79308 79304 79305 79294 79272 79006 79182 79083 79140 78684 78524 78453 78468 78326 78344 78397 78143 78152 78064 78044 77927 77935 77822 77805 77812 77837 77348 77407 76648 77154 76603 76596 76632 76564 76495 76354 76310 76269 76316 76304 76366 76245 76265 76069 76156 76065 76263 75925 75938 75937 75908 73986 73988 74013 74022 74028 74052 74125 74194 74371 74468 16131 74591 16259 16284 16272 16319 16370 16356 16372 15876 15877 6190 5932 6231 5907 5915 6240 5945 57 137 116 211 236 352 379 554 595 607 612 633 743 826 842 875 905 961 957 976 1014 1049 1060 1109 1125 1344 1364 1411 1415 1433 1478 6605 1513 1713 6680 1783 1815 1826 1863 1981 2056 2196 6819 2299 2321 2338 2378 2417 2503 2572 2711 6876 2740 6887 2820 2936 2937 2967 2964 2989 3014 3046 6944 3082 3148 3221 3353 3422 3433 3435 7021 3572 3595 3648 3678 3722 3728 3764 3775 7128 7154 3936 3965 4089 4369 4393 4443 7302 7332 4632 7363 7384 7419 4989 5091 7535 7539 5232 5284 7606 7726 7744 7857 7966 5346 8248 8296 8373 8378 8380 8497 8574 8615 8685 8691 8728 8823 8864 8989 9050 9055 9114 9142 9182 9322 9334 9357 9394 9396 9405 9463 9516 9521 9577 9638 9674 9679 9767 9808 9885 9945 10088 10137 10350 10499 10565 10679 10682 10955 11007 11008 11081 11172 11391 11410 11414 11459 11476 11632 11635 11875 11950 12086 12265 12315 12345 12341 12359 12385 12404 5564 12564 12602 12798 12864 12856 13229 13232 13267 13344 13491 13580 13650 13692 13739 13766 13769 5640 13853 13859 13896 14175 14203 14257 14435 14528 14548 14762 14790 15059 15186 15216 15236 15308 15311 15350 15438 15446 15494 15499 15572 15611 15668 15802 16554 16590 16715 5761 16854 16914 17073 17149 17284 17430 17474 17666 17690 17725 17744 17763 17769 17794 17825 18070 18117 18132 18169 18206 18298 18315 18368 18383 18393 18465 18474 18638 18694 18698 18699 18702 18703 18727 18748 18756 18822 18817 18836 18866 18882 18947 18987 19050 19170 19356 19480 19493 19391 19560 19567 19568 19585 19596 19648 19611 19710 19809 19761 19904 20096 20081 20049 20192 20256 20415 20420 20544 20602 20732 20820 20829 20833 20863 21071 21069 21160 21341 21387 21463 21501 21537 21623 21569 21713 21734 21820 21983 21937 22051 22075 22130 22348 22485 22548 22578 22580 22723 22712 22615 22623 22940 22998 23067 23081 23181 23100 23170 23166 23200 23249 23345 23352 23359 23364 23563 23551 23690 23692 23872 23881 23889 23904 24080 23994 24072 24152 24194 24276 24399 24439 24444 24519 24531 24553 24737 24705 24807 24871 24887 24932 24938 25020 25022 25102 25168 25172 25257 25288 25353 25554 25846 26128 26132 26265 26169 26387 26365 26481 26497 26498 26617 26657 26697 26703 26778 26788 26794 26850 27028 27038 27120 27221 27244 27226 27433 27486 27500 27505 27641 27671 27710 27721 27723 27800 27801 27856 27954 27998 28176 28155 28598 28600 28662 28670 28745 28783 28872 29063 29083 29113 29124 29196 29244 29250 29335 29352 29380 29435 29564 29587 29611 29855 29850 30051 30053 30101 30159 30251 30344 30365 30463 30541 30607 30796 30805 30917 30967 31233 31113 31098 31561 31502 31378 31307 31427 31625 31859 31663 31696 31779 31792 31819 32173 31881 32305 32072 32093 32098 32190 32405 32478 32494 32516 32851 32626 32828 32867 33039 32950 33020 33091 33332 33309 33147 33194 33231 33246 33275 33363 33651 33530 33540 33555 33698 34028 33872 33897 33920 33967 34056 34064 34121 34154 34186 34582 34472 34335 34390 34421 34439 34562 34565 34775 34662 34714 34730 34792 34977 34885 34993 35068 35188 35186 35160 35216 35221 35310 35335 35395 35422 35424 35527 35539 35552 35575 35725 35745 35747 35662 35631 35872 36041 35991 36254 36212 36215 36531 36626 36395 36594 36779 36652 36965 36969 36660 37172 37180 37085 37506 37510 37639 37466 37667 37887 37868 37859 37817 37764 37768 37769 37789 38186 38135 38051 37971 38464 38397 38340 38316 38330 38247 38253 38765 38732 38658 38572 38530 38522 39081 39025 38932 38880 38864 39377 39353 39322 39142 39679 39672 39644 39625 39584 39893 39807 39706 39707 40182 39971 40127 40039 39977 40413 40386 40452 40661 40633 40597 40469 40756 40835 40799 40750 40911 40946 40944 41096 41097 41083 41346 41358 41365 41315 41321 41297 41311 41608 41570 41555 41957 41960 41986 41924 41910 41891 41814 41701 42172 42150 42088 42189 42448 42273 42671 42574 42567 42521 42986 42949 42874 42879 42817 43289 43290 43273 43212 43187 43192 43158 43105 43102 43173 43507 43582 43557 43519 43494 43496 43622 43720 43732 43665 44061 44035 43989 43994 43955 43979 44268 44361 44348 44234 44193 44196 44184 44374 44585 44534 44531 44474 44591 44601 74713 44739 44800 44836 44917 44945 45016 44969 45074 45088 45222 45277 45315 45364 45552 74773 74785 45796 45833 45840 45850 46108 45931 46044 46135 46149 46206 46214 46291 46356 46380 46633 46470 46511 46525 46548 46610 74883 74858 74826 46763 46820 46843 46916 46942 46967 46968 46969 46984 47066 47152 47189 47193 47194 47271 47291 47468 47506 47556 47600 47621 47669 47685 47790 47852 47917 48016 48076 48378 48569 48603 48623 48648 48653 48755 48782 48840 48849 48878 48955 49075 49334 49289 49575 49563 49383 49758 49657 49636 49638 49619 49909 49843 50102 49986 50082 50382 50355 50289 50622 50656 50513 50555 50806 50761 50988 50926 51069 51320 51281 51162 51348 51536 51501 51426 51658 51749 51876 52061 52006 52018 52022 52033 51969 52114 52273 52311 52463 52474 52416 52423 52495 52486 52579 52699 52956 52922 52882 52760 52715 52718 52985 53116 53289 53293 53272 53210 53376 53747 53656 53614 53583 53648 53775 53871 53810 53817 53830 53835 53897 53952 54114 53989 54380 54312 54458 54515 54455 54436 54441 54733 54704 54722 54660 54612 54740 54765 54831 54945 54910 54874 54859 54846] View formatted query View runnable query Explain query 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 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 (5, 6) AND h0_.id IN (81850, 81973, 81948, 81882, 81803, 81698, 81709, 81657, 81755, 80895, 80680, 80658, 80681, 80626, 80530, 80600, 80392, 80289, 80340, 80362, 80372, 80012, 80029, 79943, 79894, 79786, 79858, 79802, 79834, 79722, 79587, 79498, 79454, 79389, 79196, 79353, 79360, 79300, 79308, 79304, 79305, 79294, 79272, 79006, 79182, 79083, 79140, 78684, 78524, 78453, 78468, 78326, 78344, 78397, 78143, 78152, 78064, 78044, 77927, 77935, 77822, 77805, 77812, 77837, 77348, 77407, 76648, 77154, 76603, 76596, 76632, 76564, 76495, 76354, 76310, 76269, 76316, 76304, 76366, 76245, 76265, 76069, 76156, 76065, 76263, 75925, 75938, 75937, 75908, 73986, 73988, 74013, 74022, 74028, 74052, 74125, 74194, 74371, 74468, 16131, 74591, 16259, 16284, 16272, 16319, 16370, 16356, 16372, 15876, 15877, 6190, 5932, 6231, 5907, 5915, 6240, 5945, 57, 137, 116, 211, 236, 352, 379, 554, 595, 607, 612, 633, 743, 826, 842, 875, 905, 961, 957, 976, 1014, 1049, 1060, 1109, 1125, 1344, 1364, 1411, 1415, 1433, 1478, 6605, 1513, 1713, 6680, 1783, 1815, 1826, 1863, 1981, 2056, 2196, 6819, 2299, 2321, 2338, 2378, 2417, 2503, 2572, 2711, 6876, 2740, 6887, 2820, 2936, 2937, 2967, 2964, 2989, 3014, 3046, 6944, 3082, 3148, 3221, 3353, 3422, 3433, 3435, 7021, 3572, 3595, 3648, 3678, 3722, 3728, 3764, 3775, 7128, 7154, 3936, 3965, 4089, 4369, 4393, 4443, 7302, 7332, 4632, 7363, 7384, 7419, 4989, 5091, 7535, 7539, 5232, 5284, 7606, 7726, 7744, 7857, 7966, 5346, 8248, 8296, 8373, 8378, 8380, 8497, 8574, 8615, 8685, 8691, 8728, 8823, 8864, 8989, 9050, 9055, 9114, 9142, 9182, 9322, 9334, 9357, 9394, 9396, 9405, 9463, 9516, 9521, 9577, 9638, 9674, 9679, 9767, 9808, 9885, 9945, 10088, 10137, 10350, 10499, 10565, 10679, 10682, 10955, 11007, 11008, 11081, 11172, 11391, 11410, 11414, 11459, 11476, 11632, 11635, 11875, 11950, 12086, 12265, 12315, 12345, 12341, 12359, 12385, 12404, 5564, 12564, 12602, 12798, 12864, 12856, 13229, 13232, 13267, 13344, 13491, 13580, 13650, 13692, 13739, 13766, 13769, 5640, 13853, 13859, 13896, 14175, 14203, 14257, 14435, 14528, 14548, 14762, 14790, 15059, 15186, 15216, 15236, 15308, 15311, 15350, 15438, 15446, 15494, 15499, 15572, 15611, 15668, 15802, 16554, 16590, 16715, 5761, 16854, 16914, 17073, 17149, 17284, 17430, 17474, 17666, 17690, 17725, 17744, 17763, 17769, 17794, 17825, 18070, 18117, 18132, 18169, 18206, 18298, 18315, 18368, 18383, 18393, 18465, 18474, 18638, 18694, 18698, 18699, 18702, 18703, 18727, 18748, 18756, 18822, 18817, 18836, 18866, 18882, 18947, 18987, 19050, 19170, 19356, 19480, 19493, 19391, 19560, 19567, 19568, 19585, 19596, 19648, 19611, 19710, 19809, 19761, 19904, 20096, 20081, 20049, 20192, 20256, 20415, 20420, 20544, 20602, 20732, 20820, 20829, 20833, 20863, 21071, 21069, 21160, 21341, 21387, 21463, 21501, 21537, 21623, 21569, 21713, 21734, 21820, 21983, 21937, 22051, 22075, 22130, 22348, 22485, 22548, 22578, 22580, 22723, 22712, 22615, 22623, 22940, 22998, 23067, 23081, 23181, 23100, 23170, 23166, 23200, 23249, 23345, 23352, 23359, 23364, 23563, 23551, 23690, 23692, 23872, 23881, 23889, 23904, 24080, 23994, 24072, 24152, 24194, 24276, 24399, 24439, 24444, 24519, 24531, 24553, 24737, 24705, 24807, 24871, 24887, 24932, 24938, 25020, 25022, 25102, 25168, 25172, 25257, 25288, 25353, 25554, 25846, 26128, 26132, 26265, 26169, 26387, 26365, 26481, 26497, 26498, 26617, 26657, 26697, 26703, 26778, 26788, 26794, 26850, 27028, 27038, 27120, 27221, 27244, 27226, 27433, 27486, 27500, 27505, 27641, 27671, 27710, 27721, 27723, 27800, 27801, 27856, 27954, 27998, 28176, 28155, 28598, 28600, 28662, 28670, 28745, 28783, 28872, 29063, 29083, 29113, 29124, 29196, 29244, 29250, 29335, 29352, 29380, 29435, 29564, 29587, 29611, 29855, 29850, 30051, 30053, 30101, 30159, 30251, 30344, 30365, 30463, 30541, 30607, 30796, 30805, 30917, 30967, 31233, 31113, 31098, 31561, 31502, 31378, 31307, 31427, 31625, 31859, 31663, 31696, 31779, 31792, 31819, 32173, 31881, 32305, 32072, 32093, 32098, 32190, 32405, 32478, 32494, 32516, 32851, 32626, 32828, 32867, 33039, 32950, 33020, 33091, 33332, 33309, 33147, 33194, 33231, 33246, 33275, 33363, 33651, 33530, 33540, 33555, 33698, 34028, 33872, 33897, 33920, 33967, 34056, 34064, 34121, 34154, 34186, 34582, 34472, 34335, 34390, 34421, 34439, 34562, 34565, 34775, 34662, 34714, 34730, 34792, 34977, 34885, 34993, 35068, 35188, 35186, 35160, 35216, 35221, 35310, 35335, 35395, 35422, 35424, 35527, 35539, 35552, 35575, 35725, 35745, 35747, 35662, 35631, 35872, 36041, 35991, 36254, 36212, 36215, 36531, 36626, 36395, 36594, 36779, 36652, 36965, 36969, 36660, 37172, 37180, 37085, 37506, 37510, 37639, 37466, 37667, 37887, 37868, 37859, 37817, 37764, 37768, 37769, 37789, 38186, 38135, 38051, 37971, 38464, 38397, 38340, 38316, 38330, 38247, 38253, 38765, 38732, 38658, 38572, 38530, 38522, 39081, 39025, 38932, 38880, 38864, 39377, 39353, 39322, 39142, 39679, 39672, 39644, 39625, 39584, 39893, 39807, 39706, 39707, 40182, 39971, 40127, 40039, 39977, 40413, 40386, 40452, 40661, 40633, 40597, 40469, 40756, 40835, 40799, 40750, 40911, 40946, 40944, 41096, 41097, 41083, 41346, 41358, 41365, 41315, 41321, 41297, 41311, 41608, 41570, 41555, 41957, 41960, 41986, 41924, 41910, 41891, 41814, 41701, 42172, 42150, 42088, 42189, 42448, 42273, 42671, 42574, 42567, 42521, 42986, 42949, 42874, 42879, 42817, 43289, 43290, 43273, 43212, 43187, 43192, 43158, 43105, 43102, 43173, 43507, 43582, 43557, 43519, 43494, 43496, 43622, 43720, 43732, 43665, 44061, 44035, 43989, 43994, 43955, 43979, 44268, 44361, 44348, 44234, 44193, 44196, 44184, 44374, 44585, 44534, 44531, 44474, 44591, 44601, 74713, 44739, 44800, 44836, 44917, 44945, 45016, 44969, 45074, 45088, 45222, 45277, 45315, 45364, 45552, 74773, 74785, 45796, 45833, 45840, 45850, 46108, 45931, 46044, 46135, 46149, 46206, 46214, 46291, 46356, 46380, 46633, 46470, 46511, 46525, 46548, 46610, 74883, 74858, 74826, 46763, 46820, 46843, 46916, 46942, 46967, 46968, 46969, 46984, 47066, 47152, 47189, 47193, 47194, 47271, 47291, 47468, 47506, 47556, 47600, 47621, 47669, 47685, 47790, 47852, 47917, 48016, 48076, 48378, 48569, 48603, 48623, 48648, 48653, 48755, 48782, 48840, 48849, 48878, 48955, 49075, 49334, 49289, 49575, 49563, 49383, 49758, 49657, 49636, 49638, 49619, 49909, 49843, 50102, 49986, 50082, 50382, 50355, 50289, 50622, 50656, 50513, 50555, 50806, 50761, 50988, 50926, 51069, 51320, 51281, 51162, 51348, 51536, 51501, 51426, 51658, 51749, 51876, 52061, 52006, 52018, 52022, 52033, 51969, 52114, 52273, 52311, 52463, 52474, 52416, 52423, 52495, 52486, 52579, 52699, 52956, 52922, 52882, 52760, 52715, 52718, 52985, 53116, 53289, 53293, 53272, 53210, 53376, 53747, 53656, 53614, 53583, 53648, 53775, 53871, 53810, 53817, 53830, 53835, 53897, 53952, 54114, 53989, 54380, 54312, 54458, 54515, 54455, 54436, 54441, 54733, 54704, 54722, 54660, 54612, 54740, 54765, 54831, 54945, 54910, 54874, 54859, 54846) ORDER BY h0_.a_la_une DESC, h0_.date_publication DESC;
37.03 ms (7.50%)	44	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`] View formatted query View runnable query Explain query 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 = ? 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 = 176;
26.63 ms (5.39%)	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: [`81850`] View formatted query View runnable query Explain query 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 = ? 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 = 81850;
24.01 ms (4.86%)	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`] View formatted query View runnable query Explain query 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 = ? 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 = 81997;
21.68 ms (4.39%)	1	SELECT z.id, z.libelle, z.slug, count() as nbOuvrage FROM har_zone_geographique z INNER JOIN har_ouvrage_zone_geographique oz ON z.id = oz.zone_geographique_id INNER JOIN har_ouvrage o ON oz.ouvrage_id = o.id INNER JOIN har_disponibilite_ouvrage dp ON o.disponibilite_papier_id = dp.id WHERE z.parent_id = :zoneGeographique AND dp.externe_id NOT IN (:disponibilitePapierIds) GROUP BY 1 ORDER BY 2 ASC Parameters: [`"zoneGeographique" => 42 "disponibilitePapierIds" => "5,6"`] View formatted query View runnable query Explain query SELECT z.id, z.libelle, z.slug, count() as nbOuvrage FROM har_zone_geographique z INNER JOIN har_ouvrage_zone_geographique oz ON z.id = oz.zone_geographique_id INNER JOIN har_ouvrage o ON oz.ouvrage_id = o.id INNER JOIN har_disponibilite_ouvrage dp ON o.disponibilite_papier_id = dp.id WHERE z.parent_id = :zoneGeographique AND dp.externe_id NOT IN (:disponibilitePapierIds) GROUP BY 1 ORDER BY 2 ASC SELECT z.id, z.libelle, z.slug, count(*) as nbOuvrage FROM har_zone_geographique z INNER JOIN har_ouvrage_zone_geographique oz ON z.id = oz.zone_geographique_id INNER JOIN har_ouvrage o ON oz.ouvrage_id = o.id INNER JOIN har_disponibilite_ouvrage dp ON o.disponibilite_papier_id = dp.id WHERE z.parent_id = 42 AND dp.externe_id NOT IN ('5,6') GROUP BY 1 ORDER BY 2 ASC;
13.37 ms (2.71%)	1	SELECT h0_.nom AS nom_0, h0_.slug AS slug_1, h0_.externe_id AS externe_id_2, h0_.sous_titre AS sous_titre_3, h0_.description AS description_4, h0_.date_revue AS date_revue_5, h0_.abonnement AS abonnement_6, h0_.issn AS issn_7, h0_.periodicite AS periodicite_8, h0_.adresse AS adresse_9, h0_.code_postal AS code_postal_10, h0_.ville AS ville_11, h0_.email AS email_12, h0_.id AS id_13, h0_.created AS created_14, h0_.changed AS changed_15, h0_.editeur_id AS editeur_id_16, h0_.code_pays_id AS code_pays_id_17 FROM har_revue h0_ WHERE h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY h0_.nom ASC Parameters: [`9 133 107 215 184 12 23 27 58 104 190`] View formatted query View runnable query Explain query SELECT h0_.nom AS nom_0, h0_.slug AS slug_1, h0_.externe_id AS externe_id_2, h0_.sous_titre AS sous_titre_3, h0_.description AS description_4, h0_.date_revue AS date_revue_5, h0_.abonnement AS abonnement_6, h0_.issn AS issn_7, h0_.periodicite AS periodicite_8, h0_.adresse AS adresse_9, h0_.code_postal AS code_postal_10, h0_.ville AS ville_11, h0_.email AS email_12, h0_.id AS id_13, h0_.created AS created_14, h0_.changed AS changed_15, h0_.editeur_id AS editeur_id_16, h0_.code_pays_id AS code_pays_id_17 FROM har_revue h0_ WHERE h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY h0_.nom ASC SELECT h0_.nom AS nom_0, h0_.slug AS slug_1, h0_.externe_id AS externe_id_2, h0_.sous_titre AS sous_titre_3, h0_.description AS description_4, h0_.date_revue AS date_revue_5, h0_.abonnement AS abonnement_6, h0_.issn AS issn_7, h0_.periodicite AS periodicite_8, h0_.adresse AS adresse_9, h0_.code_postal AS code_postal_10, h0_.ville AS ville_11, h0_.email AS email_12, h0_.id AS id_13, h0_.created AS created_14, h0_.changed AS changed_15, h0_.editeur_id AS editeur_id_16, h0_.code_pays_id AS code_pays_id_17 FROM har_revue h0_ WHERE h0_.id IN (9, 133, 107, 215, 184, 12, 23, 27, 58, 104, 190) ORDER BY h0_.nom ASC;
12.15 ms (2.46%)	1	WITH RECURSIVE zones AS ( SELECT id, parent_id FROM har_zone_geographique WHERE parent_id = :parent_id UNION ALL SELECT zg.id, zg.parent_id FROM har_zone_geographique zg JOIN zones z ON zg.parent_id = z.id ) SELECT DISTINCT z.id FROM zones z JOIN har_ouvrage_zone_geographique ozg ON ozg.zone_geographique_id = z.id; Parameters: [`"parent_id" => 42`] View formatted query View runnable query Explain query WITH RECURSIVE zones AS ( SELECT id, parent_id FROM har_zone_geographique WHERE parent_id = :parent_id UNION ALL SELECT zg.id, zg.parent_id FROM har_zone_geographique zg JOIN zones z ON zg.parent_id = z.id ) SELECT DISTINCT z.id FROM zones z JOIN har_ouvrage_zone_geographique ozg ON ozg.zone_geographique_id = z.id; WITH RECURSIVE zones AS ( SELECT id, parent_id FROM har_zone_geographique WHERE parent_id = 42 UNION ALL SELECT zg.id, zg.parent_id FROM har_zone_geographique zg JOIN zones z ON zg.parent_id = z.id ) SELECT DISTINCT z.id FROM zones z JOIN har_ouvrage_zone_geographique ozg ON ozg.zone_geographique_id = z.id; ;
11.43 ms (2.31%)	20	SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC Parameters: [`"/cmf/default/contents" "default_live"`] View formatted query View runnable query Explain query SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/default/contents') AND workspace_name = 'default_live' ORDER BY sort_order ASC;
9.46 ms (1.92%)	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`] View formatted query View runnable query Explain query 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 = ? 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 = 128995;
8.02 ms (1.62%)	1	SELECT prefix, uri FROM phpcr_namespaces Parameters: [] View formatted query View runnable query Explain query SELECT prefix, uri FROM phpcr_namespaces SELECT prefix, uri FROM phpcr_namespaces;
6.69 ms (1.35%)	1	SELECT a.id FROM har_intervenant a, har_ouvrage_intervenant b, har_ouvrage_zone_geographique c, har_zone_geographique d WHERE d.id = :zoneGeographique AND b.type_intervenant_id = :type AND c.zone_geographique_id = d.id AND b.ouvrage_id = c.ouvrage_id AND a.id = b.intervenant_id ORDER BY b.intervenant_position, a.nom Parameters: [`"zoneGeographique" => 42 "type" => 1`] View formatted query View runnable query Explain query SELECT a.id FROM har_intervenant a, har_ouvrage_intervenant b, har_ouvrage_zone_geographique c, har_zone_geographique d WHERE d.id = :zoneGeographique AND b.type_intervenant_id = :type AND c.zone_geographique_id = d.id AND b.ouvrage_id = c.ouvrage_id AND a.id = b.intervenant_id ORDER BY b.intervenant_position, a.nom SELECT a.id FROM har_intervenant a, har_ouvrage_intervenant b, har_ouvrage_zone_geographique c, har_zone_geographique d WHERE d.id = 42 AND b.type_intervenant_id = 1 AND c.zone_geographique_id = d.id AND b.ouvrage_id = c.ouvrage_id AND a.id = b.intervenant_id ORDER BY b.intervenant_position, a.nom;
6.05 ms (1.23%)	5	SELECT * FROM phpcr_nodes WHERE path = ? AND workspace_name = ? ORDER BY depth, sort_order ASC Parameters: [`"/cmf/default/contents" "default_live"`] View formatted query View runnable query Explain query SELECT * FROM phpcr_nodes WHERE path = ? AND workspace_name = ? ORDER BY depth, sort_order ASC SELECT * FROM phpcr_nodes WHERE path = '/cmf/default/contents' AND workspace_name = 'default_live' ORDER BY depth, sort_order ASC;
6.02 ms (1.22%)	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: [] View formatted query View runnable query Explain query 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 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 ;
5.88 ms (1.19%)	11	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: [`42`] View formatted query View runnable query Explain query 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 = ? 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 = 42;
5.57 ms (1.13%)	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`] View formatted query View runnable query Explain query 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 = ? 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 = 1;
5.34 ms (1.08%)	4	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
4.02 ms (0.81%)	10	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`] View formatted query View runnable query Explain query 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 = ? 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 = 57535;
3.17 ms (0.64%)	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`] View formatted query View runnable query Explain query 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 = ? 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 = 5355;
2.77 ms (0.56%)	1	SELECT 1 FROM phpcr_workspaces WHERE name = ? Parameters: [`"default_live"`] View formatted query View runnable query Explain query SELECT 1 FROM phpcr_workspaces WHERE name = ? SELECT 1 FROM phpcr_workspaces WHERE name = 'default_live';
2.37 ms (0.48%)	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: [120 173 241 170 153 166 141 186 323 165 307 348 230 328 107 373 185 349 89 176 140 345 327 159 167 244 278 334 35 325 344 39 78 171 108 285 300 370 121 362 23 155 160 182 79 157 172 175 193 2 137 209 322 336 363 3 142 174 190 293 314 408 30 116 122 189 246 259 20 96 147 236 245 289 291 295 313 342 347 350 358 365 387 9 12 13 91 98 99 102 103 106 109 113 117 154 161 163 168 177 179 180 181 183 188 194 202 213 218 233 235 254 260 262 266 281 309 312 315 329 330 331 332 333 343 361 371 375 376 382 388 394 395 403 407] View formatted query View runnable query Explain query 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 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 (120, 173, 241, 170, 153, 166, 141, 186, 323, 165, 307, 348, 230, 328, 107, 373, 185, 349, 89, 176, 140, 345, 327, 159, 167, 244, 278, 334, 35, 325, 344, 39, 78, 171, 108, 285, 300, 370, 121, 362, 23, 155, 160, 182, 79, 157, 172, 175, 193, 2, 137, 209, 322, 336, 363, 3, 142, 174, 190, 293, 314, 408, 30, 116, 122, 189, 246, 259, 20, 96, 147, 236, 245, 289, 291, 295, 313, 342, 347, 350, 358, 365, 387, 9, 12, 13, 91, 98, 99, 102, 103, 106, 109, 113, 117, 154, 161, 163, 168, 177, 179, 180, 181, 183, 188, 194, 202, 213, 218, 233, 235, 254, 260, 262, 266, 281, 309, 312, 315, 329, 330, 331, 332, 333, 343, 361, 371, 375, 376, 382, 388, 394, 395, 403, 407) ORDER BY h1_.libelle ASC, h0_.libelle ASC;
2.26 ms (0.46%)	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`] View formatted query View runnable query Explain query 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 = ? 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 = 35411;
2.16 ms (0.44%)	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"`] View formatted query View runnable query Explain query 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 SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' 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;
2.01 ms (0.41%)	1	SELECT h0_.nom AS nom_0, h0_.slug AS slug_1, h0_.description AS description_2, h0_.hors_collection AS hors_collection_3, h0_.issn AS issn_4, h0_.erp_id AS erp_id_5, h0_.externe_id AS externe_id_6, h0_.id AS id_7, h0_.created AS created_8, h0_.changed AS changed_9, h0_.editeur_id AS editeur_id_10 FROM har_collection h0_ WHERE h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY h0_.nom ASC Parameters: [315 253 60 748 58 90 717 772 284 68 750 793 64 224 350 55 218 269 200 1200 241 532 663 944 1133 198 239 256 773 822 1201 61 222 230 242 440 752 788 1211 57 65 434 642 816 818 50 62 93 196 214 325 417 608 1174 1285 1300 66 73 89 138 159 179 201 209 213 226 255 335 355 356 394 581 622 728 807 1166 1255 6 47 53 70 110 114 116 118 128 135 184 191 195 202 203 217 254 259 272 324 338 344 364 367 395 427 496 526 547 562 586 620 630 650 654 662 665 671 688 691 699 718 723 736 744 785 787 806 814 823 827 833 837 841 842 879 884 956 1053 1055 1117 1137 1168 1204 1219 1248] View formatted query View runnable query Explain query SELECT h0_.nom AS nom_0, h0_.slug AS slug_1, h0_.description AS description_2, h0_.hors_collection AS hors_collection_3, h0_.issn AS issn_4, h0_.erp_id AS erp_id_5, h0_.externe_id AS externe_id_6, h0_.id AS id_7, h0_.created AS created_8, h0_.changed AS changed_9, h0_.editeur_id AS editeur_id_10 FROM har_collection h0_ WHERE h0_.id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ORDER BY h0_.nom ASC SELECT h0_.nom AS nom_0, h0_.slug AS slug_1, h0_.description AS description_2, h0_.hors_collection AS hors_collection_3, h0_.issn AS issn_4, h0_.erp_id AS erp_id_5, h0_.externe_id AS externe_id_6, h0_.id AS id_7, h0_.created AS created_8, h0_.changed AS changed_9, h0_.editeur_id AS editeur_id_10 FROM har_collection h0_ WHERE h0_.id IN (315, 253, 60, 748, 58, 90, 717, 772, 284, 68, 750, 793, 64, 224, 350, 55, 218, 269, 200, 1200, 241, 532, 663, 944, 1133, 198, 239, 256, 773, 822, 1201, 61, 222, 230, 242, 440, 752, 788, 1211, 57, 65, 434, 642, 816, 818, 50, 62, 93, 196, 214, 325, 417, 608, 1174, 1285, 1300, 66, 73, 89, 138, 159, 179, 201, 209, 213, 226, 255, 335, 355, 356, 394, 581, 622, 728, 807, 1166, 1255, 6, 47, 53, 70, 110, 114, 116, 118, 128, 135, 184, 191, 195, 202, 203, 217, 254, 259, 272, 324, 338, 344, 364, 367, 395, 427, 496, 526, 547, 562, 586, 620, 630, 650, 654, 662, 665, 671, 688, 691, 699, 718, 723, 736, 744, 785, 787, 806, 814, 823, 827, 833, 837, 841, 842, 879, 884, 956, 1053, 1055, 1117, 1137, 1168, 1204, 1219, 1248) ORDER BY h0_.nom ASC;
1.98 ms (0.40%)	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_ouvrage_zone_geographique h3_ ON h0_.id = h3_.ouvrage_id INNER JOIN har_zone_geographique h4_ ON h3_.zone_geographique_id = h4_.id WHERE h2_.externe_id NOT IN (?, ?) AND h4_.id = ? GROUP BY h0_.id ORDER BY SUM(h1_.quantity) DESC LIMIT 4 Parameters: [`5 6 42`] View formatted query View runnable query Explain query 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_ouvrage_zone_geographique h3_ ON h0_.id = h3_.ouvrage_id INNER JOIN har_zone_geographique h4_ ON h3_.zone_geographique_id = h4_.id WHERE h2_.externe_id NOT IN (?, ?) AND h4_.id = ? GROUP BY h0_.id ORDER BY SUM(h1_.quantity) DESC LIMIT 4 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_ouvrage_zone_geographique h3_ ON h0_.id = h3_.ouvrage_id INNER JOIN har_zone_geographique h4_ ON h3_.zone_geographique_id = h4_.id WHERE h2_.externe_id NOT IN (5, 6) AND h4_.id = 42 GROUP BY h0_.id ORDER BY SUM(h1_.quantity) DESC LIMIT 4;
1.86 ms (0.38%)	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`] View formatted query View runnable query Explain query 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 = ? 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 = 128995;
1.20 ms (0.24%)	1	SELECT h0_.nom AS nom_0, h0_.nom_abrege AS nom_abrege_1, h0_.slug AS slug_2, h0_.description AS description_3, h0_.gln AS gln_4, h0_.groupehmt AS groupehmt_5, h0_.type AS type_6, h0_.adresse AS adresse_7, h0_.code_postal AS code_postal_8, h0_.ville AS ville_9, h0_.telephone AS telephone_10, h0_.telephone2 AS telephone2_11, h0_.email AS email_12, h0_.url AS url_13, h0_.externe_id AS externe_id_14, h0_.date_creation AS date_creation_15, h0_.date_modification AS date_modification_16, h0_.id AS id_17, h0_.created AS created_18, h0_.changed AS changed_19, h0_.logo_id AS logo_id_20, h0_.code_pays_id AS code_pays_id_21 FROM har_editeur h0_ WHERE h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY h0_.nom ASC Parameters: [`8 73 16 65 10 21 26 82 94 14 17 24 34 40 69`] View formatted query View runnable query Explain query SELECT h0_.nom AS nom_0, h0_.nom_abrege AS nom_abrege_1, h0_.slug AS slug_2, h0_.description AS description_3, h0_.gln AS gln_4, h0_.groupehmt AS groupehmt_5, h0_.type AS type_6, h0_.adresse AS adresse_7, h0_.code_postal AS code_postal_8, h0_.ville AS ville_9, h0_.telephone AS telephone_10, h0_.telephone2 AS telephone2_11, h0_.email AS email_12, h0_.url AS url_13, h0_.externe_id AS externe_id_14, h0_.date_creation AS date_creation_15, h0_.date_modification AS date_modification_16, h0_.id AS id_17, h0_.created AS created_18, h0_.changed AS changed_19, h0_.logo_id AS logo_id_20, h0_.code_pays_id AS code_pays_id_21 FROM har_editeur h0_ WHERE h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY h0_.nom ASC SELECT h0_.nom AS nom_0, h0_.nom_abrege AS nom_abrege_1, h0_.slug AS slug_2, h0_.description AS description_3, h0_.gln AS gln_4, h0_.groupehmt AS groupehmt_5, h0_.type AS type_6, h0_.adresse AS adresse_7, h0_.code_postal AS code_postal_8, h0_.ville AS ville_9, h0_.telephone AS telephone_10, h0_.telephone2 AS telephone2_11, h0_.email AS email_12, h0_.url AS url_13, h0_.externe_id AS externe_id_14, h0_.date_creation AS date_creation_15, h0_.date_modification AS date_modification_16, h0_.id AS id_17, h0_.created AS created_18, h0_.changed AS changed_19, h0_.logo_id AS logo_id_20, h0_.code_pays_id AS code_pays_id_21 FROM har_editeur h0_ WHERE h0_.id IN (8, 73, 16, 65, 10, 21, 26, 82, 94, 14, 17, 24, 34, 40, 69) ORDER BY h0_.nom ASC;
1.14 ms (0.23%)	9	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: [`785`] View formatted query View runnable query Explain query 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 = ? 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 = 785;
0.82 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"`] View formatted query View runnable query Explain query 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 SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' 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;
0.80 ms (0.16%)	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: [`211 216 221 218 212 220 210 207 215 222 209 219 213 217 208 42 214`] View formatted query View runnable query Explain query 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 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 (211, 216, 221, 218, 212, 220, 210, 207, 215, 222, 209, 219, 213, 217, 208, 42, 214) ORDER BY h0_.libelle ASC;
0.67 ms (0.14%)	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`] View formatted query View runnable query Explain query 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 = ? 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 = 128995;
0.47 ms (0.10%)	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`] View formatted query View runnable query Explain query 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 = ? 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 = 35411;
0.38 ms (0.08%)	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: [`51598 9780`] View formatted query View runnable query Explain query 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 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 (51598, 9780) ORDER BY h0_.prenom ASC, h0_.nom ASC;
0.27 ms (0.05%)	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"`] View formatted query View runnable query Explain query 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' ) ) ) SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' 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')));
0.22 ms (0.05%)	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`] View formatted query View runnable query Explain query 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 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 (5, 6) AND h0_.id IN (81875, 81893, 82005, 82006, 81997) ORDER BY h0_.a_la_une DESC, h0_.date_publication DESC;
0.22 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`] View formatted query View runnable query Explain query 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 ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) 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 (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.21 ms (0.04%)	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`] View formatted query View runnable query Explain query 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 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 >= '2026-02-04' OR (h0_.date_fin IS NOT NULL AND h0_.date_fin >= '2026-02-04')) AND h0_.en_ligne = 1 ORDER BY h0_.date_debut ASC LIMIT 4;
0.21 ms (0.04%)	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`] View formatted query View runnable query Explain query 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 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 = 1 ORDER BY h0_.created DESC LIMIT 3;
0.19 ms (0.04%)	2	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: [`73`] View formatted query View runnable query Explain query 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 = ? 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 = 73;
0.18 ms (0.04%)	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`] View formatted query View runnable query Explain query 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 = ? 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 = 1;
0.16 ms (0.03%)	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"]"`] View formatted query View runnable query Explain query 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 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 <= '2026-02-04 00:00:00' AND h0_.periode_validite_au >= '2026-02-04 00:00:00' AND JSON_CONTAINS(h0_.cibles, '[\"client\"]') = 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;
0.14 ms (0.03%)	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: [] View formatted query View runnable query Explain query 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) 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);
0.14 ms (0.03%)	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`] View formatted query View runnable query Explain query 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 SELECT DISTINCT h0_.indicateur_telephonique AS indicateur_telephonique_0 FROM har_code_pays h0_ WHERE h0_.indicateur_telephonique IS NOT NULL AND h0_.indisponible = 0 ORDER BY CAST(h0_.indicateur_telephonique AS signed) ASC;
0.12 ms (0.02%)	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`] View formatted query View runnable query Explain query 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 SELECT count(DISTINCT h0_.id) AS sclr_0 FROM har_evenement h0_ WHERE (h0_.date_debut >= '2026-02-04' OR (h0_.date_fin IS NOT NULL AND h0_.date_fin >= '2026-02-04')) AND h0_.en_ligne = 1 ORDER BY h0_.date_debut ASC;

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.

Entities Mapping

Class	Mapping errors
Sulu\Bundle\TrashBundle\Domain\Model\TrashItem	No errors.
Sulu\Bundle\MediaBundle\Entity\Collection	No errors.
Sulu\Bundle\ContactBundle\Entity\ContactTitle	No errors.
Sulu\Bundle\SecurityBundle\Entity\Group	No errors.
App\Entity\ZoneGeographique	No errors.
App\Entity\OuvrageZoneGeographique	No errors.
App\Entity\CodeAvantage	No errors.
App\Entity\Ouvrage	No errors.
App\Entity\DisponibiliteOuvrage	No errors.
App\Entity\Revue	No errors.
Sulu\Bundle\MediaBundle\Entity\Media	No errors.
App\Entity\Editeur	No errors.
App\Entity\CollectionHar	No errors.
App\Entity\SousCollection	No errors.
App\Entity\Nature	No errors.
App\Entity\TypeCouverture	No errors.
App\Entity\OuvrageIntervenant	No errors.
App\Entity\OuvrageThematique	No errors.
App\Entity\OuvrageLangue	No errors.
App\Entity\Alerte	No errors.
App\Entity\PrixRecompense	No errors.
App\Entity\CommandeDetail	No errors.
App\Entity\Thematique	No errors.
App\Entity\CodePays	No errors.
App\Entity\IntervenantCollectionHar	No errors.
Sulu\Bundle\SecurityBundle\Entity\User	No errors.
App\Entity\User	No errors.
Sulu\Bundle\MediaBundle\Entity\MediaType	No errors.
Sulu\Bundle\MediaBundle\Entity\File	No errors.
Sulu\Bundle\MediaBundle\Entity\FileVersion	No errors.
Sulu\Bundle\TagBundle\Entity\Tag	No errors.
Sulu\Bundle\CategoryBundle\Entity\Category	No errors.
Sulu\Bundle\MediaBundle\Entity\FormatOptions	No errors.
Sulu\Bundle\MediaBundle\Entity\FileVersionMeta	No errors.
Sulu\Bundle\MediaBundle\Entity\FileVersionContentLanguage	No errors.
Sulu\Bundle\MediaBundle\Entity\FileVersionPublishLanguage	No errors.
Sulu\Bundle\ContactBundle\Entity\Contact	No errors.
Sulu\Bundle\MediaBundle\Entity\CollectionMeta	No errors.
Sulu\Bundle\MediaBundle\Entity\CollectionType	No errors.
App\Entity\Compte	No errors.
Sulu\Bundle\SecurityBundle\Entity\UserTwoFactor	No errors.
Sulu\Bundle\SecurityBundle\Entity\UserRole	No errors.
Sulu\Bundle\SecurityBundle\Entity\UserGroup	No errors.
Sulu\Bundle\SecurityBundle\Entity\UserSetting	No errors.
Sulu\Bundle\ContactBundle\Entity\ContactLocale	No errors.
Sulu\Bundle\ContactBundle\Entity\ContactAddress	No errors.
Sulu\Bundle\ContactBundle\Entity\AccountContact	No errors.
Sulu\Bundle\ContactBundle\Entity\Url	No errors.
Sulu\Bundle\ContactBundle\Entity\Note	No errors.
Sulu\Bundle\ContactBundle\Entity\Email	No errors.
Sulu\Bundle\ContactBundle\Entity\Phone	No errors.
Sulu\Bundle\ContactBundle\Entity\Fax	No errors.
Sulu\Bundle\ContactBundle\Entity\SocialMediaProfile	No errors.
Sulu\Bundle\ContactBundle\Entity\BankAccount	No errors.
App\Entity\Intervenant	No errors.
App\Entity\CompteLivraison	No errors.
App\Entity\CompteFacturation	No errors.
App\Entity\Commande	No errors.
App\Entity\TypeIntervenant	No errors.
App\Entity\IntervenantRevue	No errors.
App\Entity\Evenement	No errors.
App\Entity\AgendaCategorie	No errors.
Sulu\Bundle\TrashBundle\Domain\Model\TrashItemTranslation	No errors.
Sulu\Bundle\SecurityBundle\Entity\Role	No errors.
App\Entity\Langue	No errors.
Sulu\Bundle\CategoryBundle\Entity\CategoryMeta	No errors.
Sulu\Bundle\CategoryBundle\Entity\CategoryTranslation	No errors.
Sulu\Bundle\ContactBundle\Entity\Address	No errors.
Sulu\Bundle\ContactBundle\Entity\Position	No errors.
Sulu\Bundle\ContactBundle\Entity\Account	No errors.
Sulu\Bundle\ContactBundle\Entity\UrlType	No errors.
Sulu\Bundle\ContactBundle\Entity\EmailType	No errors.
Sulu\Bundle\ContactBundle\Entity\PhoneType	No errors.
Sulu\Bundle\ContactBundle\Entity\FaxType	No errors.
Sulu\Bundle\ContactBundle\Entity\SocialMediaProfileType	No errors.
App\Entity\Cart	No errors.
App\Entity\Paiement	No errors.
App\Entity\CommandeSuivi	No errors.
App\Entity\ActualiteMedia	No errors.
App\Entity\ActualiteMediaCategorie	No errors.

Symfony Profiler

GET https://harmattan.feelandclic.dev/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DApp%255CController%255CWebsite%255CGlobalController%253A%253AgaT…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping