[SQL]SELECTEXISTS(SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = 'wikindx5' AND LOWER(TABLE_NAME)= LOWER('version'));
Elapsed time: 0.000 s
[SQL]SELECTEXISTS(SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = 'wikindx5' AND LOWER(TABLE_NAME)= LOWER('users'));
Elapsed time: 0.000 s
[SQL]SELECT `usersId` FROM users WHERE(`usersId` IN(1))
Elapsed time: 0.000 s
[SQL]SELECTEXISTS(SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = 'wikindx5' AND LOWER(TABLE_NAME)= LOWER('version'));
Elapsed time: 0.000 s
[SQL]SELECT `versionInternalVersion` FROM version WHERE(`versionComponentType` = 'core')AND(`versionComponentId` = 'core')
Elapsed time: 0.000 s
[SQL]SELECT `sessionData` FROM session WHERE(`sessionId` = 'ddpl4u63su05jlpn73fsrp280h')
Elapsed time: 0.000 s
[SQL]SELECT `configName`, `configInt`, `configVarchar`, `configText`, `configBoolean`, `configDatetime` FROM config
Elapsed time: 0.000 s
[SQL]SET time_zone = '+02:00';
Elapsed time: 0.000 s
[SQL]SELECT `newsId` FROM news
Elapsed time: 0.000 s
[SQL]SELECT `tempstorageData` FROM temp_storage WHERE(`tempstorageId` = '040ecdc6-281c-426e-9686-81dfce55738d')
Elapsed time: 0.000 s
[SQL]SELECT `customId`, `customLabel` FROM custom
Elapsed time: 0.000 s
[SQL]SELECT COUNT(`resourceId`)AS count FROM resource
Elapsed time: 0.003 s
[SQL]SELECTNOTEXISTS(SELECT 1 FROM resource)AS IsEmpty;
Elapsed time: 0.000 s
[SQL]SELECTDISTINCT `resourcemiscId` FROM resource_misc WHERE(`resourcemiscQuarantine` = 'N')AND(`resourcemiscCollection` = 1147)
Elapsed time: 0.001 s
[SQL]SELECT `creatorSurname`, `resourcecreatorResourceId`, `resourceId`, `resourceType`, `resourceTitle`, `resourceSubtitle`, `resourceShortTitle`, `resourceTitleSort`, `resourceTransTitle`, `resourceTransSubtitle`, `resourceTransShortTitle`, `resourceField1`, `resourceField2`, `resourceField3`, `resourceField4`, `resourceField5`, `resourceField6`, `resourceField7`, `resourceField8`, `resourceField9`, `resourceNoSort`, `resourceTransNoSort`, `resourceIsbn`, `resourceDoi`, `resourceLanguage`, `resourceyearId`, `resourceyearYear1`, `resourceyearYear2`, `resourceyearYear3`, `resourceyearYear4`, `resourcepageId`, `resourcepagePageStart`, `resourcepagePageEnd`, `resourcemiscId`, `resourcemiscCollection`, `resourcemiscPublisher`, `resourcemiscField1`, `resourcemiscField2`, `resourcemiscField3`, `resourcemiscField4`, `resourcemiscField5`, `resourcemiscField6`, `resourcemiscAddUserIdResource`, `resourcemiscEditUserIdResource`, `resourcemiscMaturityIndex`, `resourcemiscPeerReviewed`, `resourcetimestampTimestampAdd`, `resourcetimestampTimestamp`, `resourcemiscQuarantine`, `resourceBibtexKey`, `resourcetextAbstract`, `resourcetextAddUserIdAbstract`, `resourcetextEditUserIdAbstract`, `resourcetextNote`, `resourcetextAddUserIdNote`, `resourcetextEditUserIdNote`, `resourcemiscMetadata`, `publisherName`, `usersFullname`, `usersUsername` FROM(SELECT GROUP_CONCAT(`creatorSurname` ORDER BY `resourcecreatorRole`, `resourcecreatorOrder` ASC SEPARATOR ' ')AS 'creatorSurname', `creatorPrefix`, `resourcecreatorResourceId` FROM resource_creator LEFT JOIN resource ON `resourcecreatorResourceId` = `resourceId` LEFT JOIN creator ON `resourcecreatorCreatorId` = `creatorId` LEFT JOIN resource_misc ON `resourcemiscId` = `resourceId` WHERE(IF(`resourceType` = 'book' OR `resourceType` = 'book_chapter' OR `resourceType` = 'book_article' OR `resourceType` = 'web_encyclopedia' OR `resourceType` = 'web_encyclopedia_article', CASEWHEN(`resourcecreatorRole` = 1)THEN `resourcecreatorRole` = 1 WHEN(`resourcecreatorRole` = 2)THEN `resourcecreatorRole` = 2 WHEN(`resourcecreatorRole` = 3)THEN `resourcecreatorRole` = 3 WHEN(`resourcecreatorRole` = 4)THEN `resourcecreatorRole` = 4 WHEN(`resourcecreatorRole` = 5)THEN `resourcecreatorRole` = 5 ELSE(`resourcecreatorRole` ISNULL)END, 1))AND(`resourcecreatorResourceId` IN(4386, 4387, 4388, 4389, 4390, 4391, 4408, 4409))AND(`resourcemiscQuarantine` = 'N')GROUP BY `resourcecreatorResourceId` ORDER BY `resourcecreatorOrder` ASC)AS t1 LEFT JOIN resource ON `resourceId` = `resourcecreatorResourceId` LEFT JOIN resource_year ON `resourceId` = `resourceyearId` LEFT JOIN resource_page ON `resourceId` = `resourcepageId` LEFT JOIN resource_misc ON `resourceId` = `resourcemiscId` LEFT JOIN resource_timestamp ON `resourceId` = `resourcetimestampId` LEFT JOIN resource_text ON `resourceId` = `resourcetextId` LEFT JOIN publisher ON `resourcemiscPublisher` = `publisherId` LEFT JOIN users ON `resourcemiscAddUserIdResource` = `usersId` ORDER BY REPLACE( REPLACE(IF(`creatorSurname` ISNOTNULL, `creatorSurname`, `resourceTitleSort`), '{', ''), '}', '')ASC, CASEWHEN((`resourceType` = 'book' OR `resourceType` = 'book_chapter' OR `resourceType` = 'book_article' OR `resourceType` = 'web_encyclopedia' OR `resourceType` = 'web_encyclopedia_article')AND CAST(`resourceyearYear2` AS UNSIGNED)ISNOTNULL)OR((`resourceType` = 'proceedings_article' OR `resourceType` = 'conference_paper' OR `resourceType` = 'conference_poster')AND CAST(`resourceyearYear1` AS UNSIGNED)ISNULL)THEN CAST(`resourceyearYear2` AS UNSIGNED)ELSE CAST(`resourceyearYear1` AS UNSIGNED)ENDASC, REPLACE( REPLACE(`resourceTitleSort`, '{', ''), '}', '')ASC, `resourceId` ASCLIMIT 0, 100
Elapsed time: 0.002 s
[SQL]SELECT `resourcecreatorResourceId`, `creatorId`, `resourcecreatorRole`, `resourcecreatorOrder`, `creatorSurname` AS surname, `creatorFirstname` AS firstname, `creatorInitials` AS initials, `creatorPrefix` AS prefix, `creatorId` FROM(SELECTDISTINCT `resourcecreatorResourceId`, `creatorId`, `resourcecreatorRole`, `resourcecreatorOrder`, `creatorSurname`, `creatorFirstname`, `creatorInitials`, `creatorPrefix` FROM resource_creator LEFT JOIN creator ON `creatorId` = `resourcecreatorCreatorId` WHERE(`resourcecreatorResourceId` IN(4386, 4387, 4408, 4409, 4388, 4389, 4390, 4391))AND(`resourcecreatorRole` IN(1, 2, 3, 4, 5))ORDER BY `resourcecreatorRole` ASC, `resourcecreatorOrder` ASC)AS rc
[SQL]SELECT `resourceattachmentsText`, `resourceattachmentsResourceId` FROM resource_attachments WHERE(`resourceattachmentsResourceId` IN(4386, 4387, 4408, 4409, 4388, 4389, 4390, 4391))AND(`resourceattachmentsEmbargo` = 'N')AND(`resourceattachmentsText` ISNOTNULL)GROUP BY `resourceattachmentsResourceId`
Elapsed time: 0.000 s
[SQL]SELECT `collectionTitle` FROM collection WHERE(`collectionId` = 1147)
Elapsed time: 0.000 s
[SQL]SELECT COUNT(`resourceId`)AS count FROM resource
Elapsed time: 0.003 s
[SQL]SELECT COUNT(`resourceId`)AS count FROM resource
Elapsed time: 0.003 s
[SQL]SELECT COUNT(`resourcemetadataId`)AS count FROM resource_metadata WHERE(`resourcemetadataType` = 'q')
Elapsed time: 0.000 s
[SQL]SELECT COUNT(`resourcemetadataId`)AS count FROM resource_metadata WHERE(`resourcemetadataType` = 'p')
Elapsed time: 0.000 s
[SQL]SELECT COUNT(`resourcemetadataId`)AS count FROM resource_metadata WHERE(`resourcemetadataType` = 'm')
Elapsed time: 0.000 s
[SQL]SELECT `usersbasketBasket` FROM users_basket WHERE(`usersbasketUserId` = '')
Elapsed time: 0.000 s
[SQL]SELECT `usersbasketIdeasbasket` FROM users_basket WHERE(`usersbasketUserId` = '')
Elapsed time: 0.000 s
[SQL]SELECT `collectionType` FROM collection GROUP BY `collectionType`
Elapsed time: 0.000 s
[SQL]SELECT `publisherType` FROM publisher GROUP BY `publisherType`
Elapsed time: 0.000 s
[SQL]SELECT `resourcemiscId` FROM resource_misc WHERE(`resourcemiscQuarantine` = 'Y')LIMIT 0, 1
Elapsed time: 0.000 s
[SQL]SELECTEXISTS(SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = 'wikindx5' AND LOWER(TABLE_NAME)= LOWER('version'));
Elapsed time: 0.000 s
[SQL]SELECT `versionInternalVersion` FROM version WHERE(`versionComponentType` = 'plugin')AND(`versionComponentId` = 'localedescription')
Elapsed time: 0.000 s
[SQL]SELECT `tempstorageData` FROM temp_storage WHERE(`tempstorageId` = '040ecdc6-281c-426e-9686-81dfce55738d')
Elapsed time: 0.000 s
[SQL]UPDATE temp_storage SET `tempstorageData` = 'a:31:{s:12:\"sql_LastSolo\";s:4:\"3343\";s:19:\"bookmark_DisplayAdd\";b:1;s:14:\"display_AllIds\";a:8:{i:0;s:4:\"4386\";i:1;s:4:\"4387\";i:2;s:4:\"4408\";i:3;s:4:\"4409\";i:4;s:4:\"4388\";i:5;s:4:\"4389\";i:6;s:4:\"4390\";i:7;s:4:\"4391\";}s:13:\"basket_AllIds\";b:0;s:18:\"ideasbasket_AllIds\";a:0:{}s:10:\"list_Order\";s:4:\"year\";s:12:\"list_AscDesc\";s:4:\" ASC\";s:12:\"sql_ListType\";s:6:\"browse\";s:10:\"sql_AllIds\";a:8:{i:0;s:4:\"4386\";i:1;s:4:\"4387\";i:2;s:4:\"4408\";i:3;s:4:\"4409\";i:4;s:4:\"4388\";i:5;s:4:\"4389\";i:6;s:4:\"4390\";i:7;s:4:\"4391\";}s:12:\"sql_ListStmt\";s:3728:\"SELECT `creatorSurname`, `resourcecreatorResourceId`, `resourceId`, `resourceType`, `resourceTitle`, `resourceSubtitle`, `resourceShortTitle`, `resourceTitleSort`, `resourceTransTitle`, `resourceTransSubtitle`, `resourceTransShortTitle`, `resourceField1`, `resourceField2`, `resourceField3`, `resourceField4`, `resourceField5`, `resourceField6`, `resourceField7`, `resourceField8`, `resourceField9`, `resourceNoSort`, `resourceTransNoSort`, `resourceIsbn`, `resourceDoi`, `resourceLanguage`, `resourceyearId`, `resourceyearYear1`, `resourceyearYear2`, `resourceyearYear3`, `resourceyearYear4`, `resourcepageId`, `resourcepagePageStart`, `resourcepagePageEnd`, `resourcemiscId`, `resourcemiscCollection`, `resourcemiscPublisher`, `resourcemiscField1`, `resourcemiscField2`, `resourcemiscField3`, `resourcemiscField4`, `resourcemiscField5`, `resourcemiscField6`, `resourcemiscAddUserIdResource`, `resourcemiscEditUserIdResource`, `resourcemiscMaturityIndex`, `resourcemiscPeerReviewed`, `resourcetimestampTimestampAdd`, `resourcetimestampTimestamp`, `resourcemiscQuarantine`, `resourceBibtexKey`, `resourcetextAbstract`, `resourcetextAddUserIdAbstract`, `resourcetextEditUserIdAbstract`, `resourcetextNote`, `resourcetextAddUserIdNote`, `resourcetextEditUserIdNote`, `resourcemiscMetadata`, `publisherName`, `usersFullname`, `usersUsername` FROM(SELECT GROUP_CONCAT(`creatorSurname` ORDER BY `resourcecreatorRole`, `resourcecreatorOrder` ASC SEPARATOR \' \')AS \'creatorSurname\', `creatorPrefix`, `resourcecreatorResourceId` FROM resource_creator LEFT JOIN resource ON `resourcecreatorResourceId` = `resourceId` LEFT JOIN creator ON `resourcecreatorCreatorId` = `creatorId` LEFT JOIN resource_misc ON `resourcemiscId` = `resourceId` WHERE(IF(`resourceType` = \'book\' OR `resourceType` = \'book_chapter\' OR `resourceType` = \'book_article\' OR `resourceType` = \'web_encyclopedia\' OR `resourceType` = \'web_encyclopedia_article\', CASEWHEN(`resourcecreatorRole` = 1)THEN `resourcecreatorRole` = 1 WHEN(`resourcecreatorRole` = 2)THEN `resourcecreatorRole` = 2 WHEN(`resourcecreatorRole` = 3)THEN `resourcecreatorRole` = 3 WHEN(`resourcecreatorRole` = 4)THEN `resourcecreatorRole` = 4 WHEN(`resourcecreatorRole` = 5)THEN `resourcecreatorRole` = 5 ELSE(`resourcecreatorRole` ISNULL)END, 1))AND(`resourcecreatorResourceId` IN(4386, 4387, 4388, 4389, 4390, 4391, 4408, 4409))AND(`resourcemiscQuarantine` = \'N\')GROUP BY `resourcecreatorResourceId` ORDER BY `resourcecreatorOrder` ASC)AS t1 LEFT JOIN resource ON `resourceId` = `resourcecreatorResourceId` LEFT JOIN resource_year ON `resourceId` = `resourceyearId` LEFT JOIN resource_page ON `resourceId` = `resourcepageId` LEFT JOIN resource_misc ON `resourceId` = `resourcemiscId` LEFT JOIN resource_timestamp ON `resourceId` = `resourcetimestampId` LEFT JOIN resource_text ON `resourceId` = `resourcetextId` LEFT JOIN publisher ON `resourcemiscPublisher` = `publisherId` LEFT JOIN users ON `resourcemiscAddUserIdResource` = `usersId` ORDER BY REPLACE( REPLACE(IF(`creatorSurname` ISNOTNULL, `creatorSurname`, `resourceTitleSort`), \'{\', \'\'), \'}\', \'\')ASC, CASEWHEN((`resourceType` = \'book\' OR `resourceType` = \'book_chapter\' OR `resourceType` = \'book_article\' OR `resourceType` = \'web_encyclopedia\' OR `resourceType` = \'web_encyclopedia_article\')AND CAST(`resourceyearYear2` AS UNSIGNED)ISNOTNULL)OR((`resourceType` = \'proceedings_article\' OR `resourceType` = \'conference_paper\' OR `resourceType` = \'conference_poster\')AND CAST(`resourceyearYear1` AS UNSIGNED)ISNULL)THEN CAST(`resourceyearYear2` AS UNSIGNED)ELSE CAST(`resourceyearYear1` AS UNSIGNED)ENDASC, REPLACE( REPLACE(`resourceTitleSort`, \'{\', \'\'), \'}\', \'\')ASC, `resourceId` ASC\";s:13:\"sql_LastMulti\";s:67:\"action=list_LISTSOMERESOURCES_CORE&method=collectionProcess&id=1147\";s:13:\"bookmark_View\";s:5:\"multi\";s:14:\"sql_ListParams\";a:1:{i:0;s:68:\"Collection: Der Fremdsprachliche Unterricht. Französisch\";}s:14:\"list_LastOrder\";s:4:\"year\";s:16:\"list_LastAscDesc\";s:4:\" ASC\";s:16:\"list_PagingTotal\";i:14267;s:16:\"list_PagingStart\";i:0;s:12:\"browse_Order\";s:7:\"creator\";s:14:\"browse_AscDesc\";s:4:\" ASC\";s:16:\"browse_LastOrder\";s:7:\"creator\";s:18:\"browse_LastAscDesc\";s:4:\" ASC\";s:13:\"browse_Method\";s:17:\"collectionProcess\";s:9:\"browse_Id\";s:4:\"1147\";s:18:\"browse_PagingTotal\";i:8;s:18:\"browse_PagingStart\";i:0;s:18:\"list_SomeResources\";s:9:\"publisher\";s:13:\"browse_AllIds\";a:58:{i:0;s:5:\"10970\";i:1;s:5:\"15286\";i:2;s:4:\"8464\";i:3;s:5:\"15235\";i:4;s:5:\"11598\";i:5;s:5:\"16084\";i:6;s:5:\"15071\";i:7;s:5:\"15561\";i:8;s:5:\"14871\";i:9;s:4:\"9948\";i:10;s:5:\"11395\";i:11;s:5:\"15077\";i:12;s:5:\"15148\";i:13;s:5:\"15612\";i:14;s:5:\"15699\";i:15;s:4:\"7221\";i:16;s:5:\"16140\";i:17;s:5:\"15616\";i:18;s:5:\"15085\";i:19;s:5:\"14532\";i:20;s:4:\"6687\";i:21;s:4:\"4114\";i:22;s:5:\"15086\";i:23;s:4:\"8314\";i:24;s:5:\"14872\";i:25;s:5:\"16131\";i:26;s:5:\"14870\";i:27;s:5:\"15078\";i:28;s:5:\"15081\";i:29;s:5:\"15115\";i:30;s:5:\"15118\";i:31;s:5:\"11908\";i:32;s:5:\"15084\";i:33;s:4:\"6928\";i:34;s:5:\"15007\";i:35;s:5:\"15082\";i:36;s:4:\"6669\";i:37;s:5:\"15080\";i:38;s:5:\"15119\";i:39;s:5:\"15234\";i:40;s:5:\"15617\";i:41;s:5:\"15685\";i:42;s:5:\"15680\";i:43;s:5:\"14388\";i:44;s:5:\"15079\";i:45;s:5:\"15083\";i:46;s:5:\"11466\";i:47;s:5:\"15613\";i:48;s:5:\"15192\";i:49;s:5:\"15684\";i:50;s:5:\"15881\";i:51;s:5:\"15076\";i:52;s:5:\"15244\";i:53;s:5:\"12589\";i:54;s:5:\"15434\";i:55;s:5:\"13404\";i:56;s:4:\"5685\";i:57;s:5:\"15157\";}s:12:\"browse_CatId\";b:0;s:17:\"browse_Department\";b:0;s:18:\"browse_Institution\";b:0;s:12:\"browse_MType\";b:0;}' WHERE(`tempstorageId` = '040ecdc6-281c-426e-9686-81dfce55738d')
Elapsed time: 0.001 s
[SQL]UPDATE temp_storage SET `tempStorageTimestamp` = CURRENT_TIMESTAMP WHERE(`tempstorageId` = '040ecdc6-281c-426e-9686-81dfce55738d')
Elapsed time: 0.001 s
PHP execution time: 0.04561 s
SQL execution time: 0.02194 s
TPL rendering time: 0.00377 s
Total elapsed time: 0.07132 s
Peak memory usage: 2.9404 MB
Memory at close: 2.2361 MB
Database queries: 52