vBulletin - Explain SQL Queries (216)

Duplicate Queries: (Exact textual duplicates, also included in the full listing of queries below)

Times run: 3

				SELECT 
					userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
					IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
				FROM user AS user
				LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
				LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) 
					WHERE user.userid IN (0)
					/** fetchUserinfo **/

Times run: 2

SELECT * FROM searchlog
 WHERE `searchlogid` = 23994723 
 LIMIT 1

Times run: 5

SELECT * FROM routenew
 WHERE `routeid` IN (227)

Times run: 5

SELECT `username`,`userid` FROM user
 WHERE `userid` IN ('','','')

Times run: 2

SELECT * FROM searchlog
 WHERE `searchlogid` = 23994724 
 LIMIT 1

Times run: 2

SELECT * FROM searchlog
 WHERE `searchlogid` = 23994725 
 LIMIT 1

Times run: 2

SELECT * FROM searchlog
 WHERE `searchlogid` = 23994726 
 LIMIT 1

Times run: 2

SELECT * FROM searchlog
 WHERE `searchlogid` = 23994727 
 LIMIT 1

SQL Query #1

SET @@sql_mode = ''

Time Before: 1713927719.7267
Time After: 1713927719.7269
Time Taken: 0.00011920928955078
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/database.php(561)
#1 vB_Database->query_write('') in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/database.php(529)
#2 vB_Database->force_sql_mode('') in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/mysql/assertor.php(79)
#3 vB_dB_MYSQL_Assertor->load_database(array[len:4], array[len:8]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/assertor.php(140)
#4 vB_dB_Assertor::init(array[len:4], array[len:8]) in /core/vb/vb.php(835)
#5 vB::getDbAssertor() in /core/vb/vb.php(851)
#6 vB::getDatastore() in /includes/api/interface/collapsed.php(48)
#7 Api_Interface_Collapsed->init() in /includes/api/interfaceabstract.php(71)
#8 Api_InterfaceAbstract::instance() in /includes/vb5/frontend/routing.php(120)
#9 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#10 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #2

SELECT * FROM datastore
 WHERE `title` IN ('options','bitfields','attachmentcache','usergroupcache','stylecache','languagecache','products','cron','profilefield','loadcache','miscoptions','noticecache','hooks','publicoptions','prefixcache','vBUgChannelPermissionsFrom','vBChannelTypes','locations')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	datastore	range	PRIMARY	PRIMARY	200		18	Using where

Time Before: 1713927719.7271
Time After: 1713927719.7272
Time Taken: 0.00013208389282227
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:299]', false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('datastore', array[len:1]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/datastore.php(620)
#7 vB_Datastore->do_db_fetch(array[len:18]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/datastore.php(575)
#8 vB_Datastore->fetch(array[len:18]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/datastore.php(180)
#9 vB_Datastore->getValue('options') in /includes/api/interface/collapsed.php(48)
#10 Api_Interface_Collapsed->init() in /includes/api/interfaceabstract.php(71)
#11 Api_InterfaceAbstract::instance() in /includes/vb5/frontend/routing.php(120)
#12 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#13 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #3

SELECT * FROM session
 WHERE `userid` = 0 AND `host` = '18.222.125.171' AND `idhash` = 'a8d1e831020cac5dbbedc942c79aead0' 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	session	ref	user_activity,guest_lookup	guest_lookup	314	const,const,const	1	Using index condition

Time Before: 1713927719.7277
Time After: 1713927719.728
Time Taken: 0.00023603439331055
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:131]', false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('session', array[len:4], false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('session', array[len:4]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/session.php(217)
#8 vB_Session->loadExistingSession('', array[len:2]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/session.php(498)
#9 vB_Session->__construct(vB_dB_MYSQL_Assertor, vB_Datastore, array[len:7], '', array[len:2], 0, 0) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/session/web.php(31)
#10 vB_Session_Web->__construct(vB_dB_MYSQL_Assertor, vB_Datastore, array[len:7], '', array[len:2], 0, 0) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/session/webapi.php(72)
#11 vB_Session_WebApi->__construct(vB_dB_MYSQL_Assertor, vB_Datastore, array[len:7], '', array[len:2]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/session/webapi.php(66)
#12 vB_Session_WebApi::createSessionNew('', array[len:2]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/request/webapi.php(54)
#13 vB_Request_WebApi->createSessionNew('', array[len:2]) in /includes/api/interfaceabstract.php(180)
#14 Api_InterfaceAbstract->createSession(vB_Request_WebApi, array[len:419]) in /includes/api/interface/collapsed.php(60)
#15 Api_Interface_Collapsed->init() in /includes/api/interfaceabstract.php(71)
#16 Api_InterfaceAbstract::instance() in /includes/vb5/frontend/routing.php(120)
#17 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#18 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #4

SELECT * FROM cache
 WHERE `cacheid` IN ('d192b4e23e62be4d6d71b7005a67b3b9')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1713927719.7281
Time After: 1713927719.7283
Time Taken: 0.00014591217041016
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:77]', false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:1]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/language.php(75)
#9 vB_Language::getPhraseCache('d192b4e23e[len:32]') in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/language.php(50)
#10 vB_Language::getPhraseInfo(2) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/session.php(835)
#11 vB_Session->loadLanguage() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/session.php(943)
#12 vB_Session->fetch_userinfo() in /core/vb/vb.php(990)
#13 vB::setCurrentSession(vB_Session_WebApi) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/request.php(173)
#14 vB_Request->setSession(vB_Session_WebApi) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/request/webapi.php(55)
#15 vB_Request_WebApi->createSessionNew('', array[len:2]) in /includes/api/interfaceabstract.php(180)
#16 Api_InterfaceAbstract->createSession(vB_Request_WebApi, array[len:419]) in /includes/api/interface/collapsed.php(60)
#17 Api_Interface_Collapsed->init() in /includes/api/interfaceabstract.php(71)
#18 Api_InterfaceAbstract::instance() in /includes/vb5/frontend/routing.php(120)
#19 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#20 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #5

SELECT * FROM cache
 WHERE `cacheid` IN ('vB_CommonRoutes')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1713927719.7294
Time After: 1713927719.7294
Time Taken: 7.7962875366211E-5
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:60]', false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:1]) in /core/vb5/route.php(1695)
#9 vB5_Route::fetchCommonRoutes() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/route.php(87)
#10 vB_Api_Route->getRoute('forum/inte[len:96]', 'explain=1') in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/wrapper.php(201)
#11 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#12 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#13 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#14 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #6

				SELECT routenew.*
				FROM routenew AS routenew
				WHERE routenew.prefix IN ('forum/interne-schreibtreffs-und-übungen/fingerübungen/76984-freitagsinfusion-1-fantasiewörter','forum/interne-schreibtreffs-und-übungen/fingerübungen','forum/interne-schreibtreffs-und-übungen','forum') OR ishomeroute = 1
			
/**get_best_routes**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	routenew	index_merge	prefix,ishomeroute	prefix,ishomeroute	766,2		6	Using sort_union(prefix,ishomeroute); Using where

Time Before: 1713927719.7295
Time After: 1713927719.7297
Time Taken: 0.00022315979003906
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, '\n\t\t\t\tSELEC[len:336]', false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/stored.php(104)
#4 vB_dB_Query_Stored->execSQL() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/assertor.php(293)
#5 vB_dB_Assertor->assertQuery('get_best_routes', array[len:1]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/route.php(127)
#6 vB_Api_Route->getRoute('forum/inte[len:96]', 'explain=1') in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/wrapper.php(201)
#7 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#8 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#9 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#10 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #7

SELECT * FROM cache
 WHERE `cacheid` IN ('vB_UserPerms0')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1713927719.7298
Time After: 1713927719.7299
Time Taken: 7.2002410888672E-5
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:58]', false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:1]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/usercontext.php(142)
#9 vB_UserContext->reloadUserPerms() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/usercontext.php(115)
#10 vB_UserContext->__construct(0, vB_dB_MYSQL_Assertor, vB_Datastore, array[len:8]) in /core/vb/vb.php(940)
#11 vB::getUserContext(0) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/library/user.php(32)
#12 vB_Library_User->isBanned('0') in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/library/user.php(61)
#13 vB_Library_User->fetchBannedInfo('0') in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/route.php(152)
#14 vB_Api_Route->getRoute('forum/inte[len:96]', 'explain=1') in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/wrapper.php(201)
#15 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#16 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#17 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#18 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #8

SELECT * FROM cache
 WHERE `cacheid` IN ('vb_types.types')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1713927719.73
Time After: 1713927719.7301
Time Taken: 7.5817108154297E-5
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:59]', false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], true) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:1], true, true) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/types.php(183)
#9 vB_Types->loadTypes() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/types.php(151)
#10 vB_Types->__construct() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/types.php(167)
#11 vB_Types::instance() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/library/content.php(149)
#12 vB_Library_Content->__construct() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/library.php(46)
#13 vB_Library::instance('Content_Channel') in /core/vb5/route/conversation.php(29)
#14 vB5_Route_Conversation->__construct(array[len:14], array[len:6], 'explain=1', '') in /core/vb5/route.php(1168)
#15 vB5_Route::checkRoute(array[len:14], 'forum/inte[len:206]', 'forum/inte[len:96]', 'explain=1', '') in /core/vb5/route.php(1104)
#16 vB5_Route::selectBestRoute('forum/inte[len:96]', 'explain=1', '', array[len:5]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/route.php(159)
#17 vB_Api_Route->getRoute('forum/inte[len:96]', 'explain=1') in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/wrapper.php(201)
#18 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#19 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#20 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#21 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #9

SELECT * FROM cache
 WHERE `cacheid` IN ('node_116_lvl3data')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1713927719.7303
Time After: 1713927719.7304
Time Taken: 7.3909759521484E-5
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:62]', false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:1]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/library/content.php(3881)
#9 vB_Library_Content::fetchFromCache(array[len:1], 3) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/library/content.php(2596)
#10 vB_Library_Content->getRawContent(array[len:1]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/library/content.php(2537)
#11 vB_Library_Content->getBareContent(array[len:1]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/library/content/channel.php(414)
#12 vB_Library_Content_Channel->getBareContent(116) in /core/vb5/route/conversation.php(29)
#13 vB5_Route_Conversation->__construct(array[len:14], array[len:6], 'explain=1', '') in /core/vb5/route.php(1168)
#14 vB5_Route::checkRoute(array[len:14], 'forum/inte[len:206]', 'forum/inte[len:96]', 'explain=1', '') in /core/vb5/route.php(1104)
#15 vB5_Route::selectBestRoute('forum/inte[len:96]', 'explain=1', '', array[len:5]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/route.php(159)
#16 vB_Api_Route->getRoute('forum/inte[len:96]', 'explain=1') in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/wrapper.php(201)
#17 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#18 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#19 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#20 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #10

SELECT * FROM cache
 WHERE `cacheid` IN ('node_76984_lvl1data')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE noticed after reading const tables

Time Before: 1713927719.7305
Time After: 1713927719.7306
Time Taken: 0.00012087821960449
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:64]', false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:1]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/library/content.php(3881)
#9 vB_Library_Content::fetchFromCache(array[len:1], 1) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/library/node.php(883)
#10 vB_Library_Node->getNodeBare('76984') in /core/vb5/route/conversation.php(83)
#11 vB5_Route_Conversation->__construct(array[len:14], array[len:6], 'explain=1', '') in /core/vb5/route.php(1168)
#12 vB5_Route::checkRoute(array[len:14], 'forum/inte[len:206]', 'forum/inte[len:96]', 'explain=1', '') in /core/vb5/route.php(1104)
#13 vB5_Route::selectBestRoute('forum/inte[len:96]', 'explain=1', '', array[len:5]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/route.php(159)
#14 vB_Api_Route->getRoute('forum/inte[len:96]', 'explain=1') in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/wrapper.php(201)
#15 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#16 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#17 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#18 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #11

SELECT * FROM node
 WHERE `nodeid` = 76984 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	node	const	PRIMARY,nodeid	PRIMARY	4	const	1

Time Before: 1713927719.7307
Time After: 1713927719.7308
Time Taken: 0.00017309188842773
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:52]', false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('vBForum:node', array[len:2], false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('vBForum:node', array[len:2]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/library/node.php(891)
#8 vB_Library_Node->getNodeBare('76984') in /core/vb5/route/conversation.php(83)
#9 vB5_Route_Conversation->__construct(array[len:14], array[len:6], 'explain=1', '') in /core/vb5/route.php(1168)
#10 vB5_Route::checkRoute(array[len:14], 'forum/inte[len:206]', 'forum/inte[len:96]', 'explain=1', '') in /core/vb5/route.php(1104)
#11 vB5_Route::selectBestRoute('forum/inte[len:96]', 'explain=1', '', array[len:5]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/route.php(159)
#12 vB_Api_Route->getRoute('forum/inte[len:96]', 'explain=1') in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/wrapper.php(201)
#13 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#14 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#15 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#16 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #12

SELECT * FROM channel
 WHERE `guid` IN ('vbulletin-4ecbdf567f2773.55528984','vbulletin-4ecbdf567f3341.44450667','vbulletin-4ecbdf567f3341.44451100','vbulletin-4ecbdf567f2c35.70389590','vbulletin-4ecbdf567f3a38.99555305','vbulletin-4ecbdf567f3a38.99555306','vbulletin-4ecbdf567f3a38.99555307','vbulletin-c-cmshome5229fa38b251e2.92227401','vbulletin-4ecbdf567f3da8.31769341','vbulletin-4ecbdf567f36c3.90966558','vbulletin-4ecbdf567f3a38.99555303','vbulletin-4ecbdf567f3a38.99555304','vbulletin-4ecbdf567f3a38.99555308')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	channel	range	guid	guid	601		13	Using index condition

Time Before: 1713927719.731
Time After: 1713927719.731
Time Taken: 3.9815902709961E-5
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:518]', false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('vBForum:channel', array[len:1]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/library/content/channel.php(958)
#7 vB_Library_Content_Channel->fetchChannelByGUID('vbulletin-[len:33]') in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/content/channel.php(156)
#8 vB_Api_Content_Channel->fetchChannelByGUID('vbulletin-[len:33]') in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/library/node.php(2179)
#9 vB_Library_Node->fetchAlbumChannel() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/node.php(1968)
#10 vB_Api_Node->fetchAlbumChannel('76984') in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/wrapper.php(201)
#11 vB_Api_Wrapper->__call('fetchAlbumChannel', array[len:1]) in /core/vb5/route/conversation.php(101)
#12 vB5_Route_Conversation->__construct(array[len:14], array[len:6], 'explain=1', '') in /core/vb5/route.php(1168)
#13 vB5_Route::checkRoute(array[len:14], 'forum/inte[len:206]', 'forum/inte[len:96]', 'explain=1', '') in /core/vb5/route.php(1104)
#14 vB5_Route::selectBestRoute('forum/inte[len:96]', 'explain=1', '', array[len:5]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/route.php(159)
#15 vB_Api_Route->getRoute('forum/inte[len:96]', 'explain=1') in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/wrapper.php(201)
#16 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#17 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#18 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#19 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #13

SELECT * FROM cache
 WHERE `cacheid` IN ('vB_NamedRoutes')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1713927719.7313
Time After: 1713927719.7314
Time Taken: 0.00012087821960449
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:59]', false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:1]) in /core/vb5/route.php(1305)
#9 vB5_Route::loadNameRoutes() in /core/vb5/route.php(1191)
#10 vB5_Route::getRouteByIdent('226') in /core/vb5/route.php(1335)
#11 vB5_Route::getClassName('226', array[len:14]) in /core/vb5/route.php(1407)
#12 vB5_Route::buildUrl(array[len:1]) in /core/vb5/route/conversation.php(212)
#13 vB5_Route_Conversation::getChannelURL(116, array[len:6]) in /core/vb5/route/conversation.php(484)
#14 vB5_Route_Conversation->getUrl() in /core/vb5/route.php(466)
#15 vB5_Route->getFullUrl(array[len:1]) in /core/vb5/route/conversation.php(130)
#16 vB5_Route_Conversation->__construct(array[len:14], array[len:6], 'explain=1', '') in /core/vb5/route.php(1168)
#17 vB5_Route::checkRoute(array[len:14], 'forum/inte[len:206]', 'forum/inte[len:96]', 'explain=1', '') in /core/vb5/route.php(1104)
#18 vB5_Route::selectBestRoute('forum/inte[len:96]', 'explain=1', '', array[len:5]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/route.php(159)
#19 vB_Api_Route->getRoute('forum/inte[len:96]', 'explain=1') in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/wrapper.php(201)
#20 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#21 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#22 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#23 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #14

SELECT * FROM routenew
 WHERE `routeid` = 226 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	routenew	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927719.7315
Time After: 1713927719.7316
Time Taken: 0.00011110305786133
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:55]', false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('routenew', array[len:2], false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('routenew', array[len:2]) in /core/vb5/route.php(1199)
#8 vB5_Route::getRouteByIdent('226') in /core/vb5/route.php(1335)
#9 vB5_Route::getClassName('226', array[len:14]) in /core/vb5/route.php(1407)
#10 vB5_Route::buildUrl(array[len:1]) in /core/vb5/route/conversation.php(212)
#11 vB5_Route_Conversation::getChannelURL(116, array[len:6]) in /core/vb5/route/conversation.php(484)
#12 vB5_Route_Conversation->getUrl() in /core/vb5/route.php(466)
#13 vB5_Route->getFullUrl(array[len:1]) in /core/vb5/route/conversation.php(130)
#14 vB5_Route_Conversation->__construct(array[len:14], array[len:6], 'explain=1', '') in /core/vb5/route.php(1168)
#15 vB5_Route::checkRoute(array[len:14], 'forum/inte[len:206]', 'forum/inte[len:96]', 'explain=1', '') in /core/vb5/route.php(1104)
#16 vB5_Route::selectBestRoute('forum/inte[len:96]', 'explain=1', '', array[len:5]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/route.php(159)
#17 vB_Api_Route->getRoute('forum/inte[len:96]', 'explain=1') in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/wrapper.php(201)
#18 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#19 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#20 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#21 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #15

SELECT * FROM cache
 WHERE `cacheid` IN ('node_116_lvl1data')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1713927719.7317
Time After: 1713927719.7318
Time Taken: 7.7009201049805E-5
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:62]', false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:1]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/library/content.php(3881)
#9 vB_Library_Content::fetchFromCache(array[len:1], 1) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/library/node.php(883)
#10 vB_Library_Node->getNodeBare(116) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/library/node.php(958)
#11 vB_Library_Node->getNode(116) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/usercontext.php(535)
#12 vB_UserContext->getChannelLimitPermission('forumpermissions', 'canview', 116, false, false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/usercontext.php(823)
#13 vB_UserContext->getChannelPermission('forumpermissions', 'canview', 116) in /core/vb5/route/channel.php(21)
#14 vB5_Route_Channel->__construct(array[len:14], array[len:0], '', '') in /core/vb5/route.php(1417)
#15 vB5_Route::buildUrl(array[len:1]) in /core/vb5/route/conversation.php(212)
#16 vB5_Route_Conversation::getChannelURL(116, array[len:6]) in /core/vb5/route/conversation.php(484)
#17 vB5_Route_Conversation->getUrl() in /core/vb5/route.php(466)
#18 vB5_Route->getFullUrl(array[len:1]) in /core/vb5/route/conversation.php(130)
#19 vB5_Route_Conversation->__construct(array[len:14], array[len:6], 'explain=1', '') in /core/vb5/route.php(1168)
#20 vB5_Route::checkRoute(array[len:14], 'forum/inte[len:206]', 'forum/inte[len:96]', 'explain=1', '') in /core/vb5/route.php(1104)
#21 vB5_Route::selectBestRoute('forum/inte[len:96]', 'explain=1', '', array[len:5]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/route.php(159)
#22 vB_Api_Route->getRoute('forum/inte[len:96]', 'explain=1') in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/wrapper.php(201)
#23 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#24 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#25 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#26 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #16

SELECT * FROM cache
 WHERE `cacheid` IN ('channelperms_1')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1713927719.7318
Time After: 1713927719.7319
Time Taken: 8.2969665527344E-5
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:59]', false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], true) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:1], true, false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/permissioncontext.php(872)
#9 vB_PermissionContext->loadChannelPermissions(1) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/permissioncontext.php(761)
#10 vB_PermissionContext->getChannelPerm(1, 'forumpermissions', 'canview', 116) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/usercontext.php(609)
#11 vB_UserContext->getChannelLimitPermission('forumpermissions', 'canview', 116, false, false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/usercontext.php(823)
#12 vB_UserContext->getChannelPermission('forumpermissions', 'canview', 116) in /core/vb5/route/channel.php(21)
#13 vB5_Route_Channel->__construct(array[len:14], array[len:0], '', '') in /core/vb5/route.php(1417)
#14 vB5_Route::buildUrl(array[len:1]) in /core/vb5/route/conversation.php(212)
#15 vB5_Route_Conversation::getChannelURL(116, array[len:6]) in /core/vb5/route/conversation.php(484)
#16 vB5_Route_Conversation->getUrl() in /core/vb5/route.php(466)
#17 vB5_Route->getFullUrl(array[len:1]) in /core/vb5/route/conversation.php(130)
#18 vB5_Route_Conversation->__construct(array[len:14], array[len:6], 'explain=1', '') in /core/vb5/route.php(1168)
#19 vB5_Route::checkRoute(array[len:14], 'forum/inte[len:206]', 'forum/inte[len:96]', 'explain=1', '') in /core/vb5/route.php(1104)
#20 vB5_Route::selectBestRoute('forum/inte[len:96]', 'explain=1', '', array[len:5]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/route.php(159)
#21 vB_Api_Route->getRoute('forum/inte[len:96]', 'explain=1') in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/wrapper.php(201)
#22 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#23 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#24 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#25 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #17

SELECT * FROM cache
 WHERE `cacheid` IN ('node_1_lvl1data')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1713927719.7321
Time After: 1713927719.7322
Time Taken: 7.5101852416992E-5
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:60]', false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:1]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/library/content.php(3881)
#9 vB_Library_Content::fetchFromCache(array[len:1], 1) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/library/node.php(883)
#10 vB_Library_Node->getNodeBare('1') in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/library/node.php(958)
#11 vB_Library_Node->getNode('1') in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/usercontext.php(535)
#12 vB_UserContext->getChannelLimitPermission('forumpermissions', 'canview', '1', false, false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/usercontext.php(823)
#13 vB_UserContext->getChannelPermission('forumpermissions', 'canview', '1') in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/route.php(215)
#14 vB_Api_Route->getRoute('forum/inte[len:96]', 'explain=1') in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/wrapper.php(201)
#15 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#16 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#17 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#18 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #18

SELECT * FROM routenew
 WHERE `routeid` = 227 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	routenew	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927719.7323
Time After: 1713927719.7323
Time Taken: 7.5101852416992E-5
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:55]', false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('routenew', array[len:2], false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('routenew', array[len:2]) in /core/vb5/route.php(1199)
#8 vB5_Route::getRouteByIdent('227') in /core/vb5/route.php(1335)
#9 vB5_Route::getClassName('227', array[len:14]) in /core/vb5/route.php(1350)
#10 vB5_Route::getRoute('227', array[len:2], array[len:1], '') in /core/vb5/route/conversation.php(610)
#11 vB5_Route_Conversation->getCanonicalRoute() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/route.php(252)
#12 vB_Api_Route->getRoute('forum/inte[len:96]', 'explain=1') in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/wrapper.php(201)
#13 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#14 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#15 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#16 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #19

SELECT * FROM closure
 WHERE `child` IN (116) 
 ORDER BY `child` ASC, `depth` ASC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	closure	ref	child	child	4	const	4	Using where

Time Before: 1713927719.7324
Time After: 1713927719.7325
Time Taken: 7.5101852416992E-5
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:81]', false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('vBForum:closure', array[len:2], array[len:2]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/library/node.php(3526)
#7 vB_Library_Node->fetchClosureParent(array[len:1]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/library/node.php(988)
#8 vB_Library_Node->getNodeParents(116) in /core/vb5/route.php(360)
#9 vB5_Route->addParentNodeBreadcrumbs(116) in /core/vb5/route.php(342)
#10 vB5_Route->setBreadcrumbs() in /core/vb5/route.php(418)
#11 vB5_Route->getBreadcrumbs() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/route.php(315)
#12 vB_Api_Route->getRoute('forum/inte[len:96]', 'explain=1') in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/wrapper.php(201)
#13 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#14 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#15 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#16 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #20

SELECT * FROM cache
 WHERE `cacheid` IN ('node_2_lvl1data','node_113_lvl1data')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	range	PRIMARY	PRIMARY	66		2	Using where

Time Before: 1713927719.7326
Time After: 1713927719.7326
Time Taken: 7.4863433837891E-5
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:80]', false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:2], false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:4]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/library/content.php(3881)
#9 vB_Library_Content::fetchFromCache(array[len:4], 1) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/library/node.php(1025)
#10 vB_Library_Node->getNodes(array[len:4]) in /core/vb5/route.php(362)
#11 vB5_Route->addParentNodeBreadcrumbs(116) in /core/vb5/route.php(342)
#12 vB5_Route->setBreadcrumbs() in /core/vb5/route.php(418)
#13 vB5_Route->getBreadcrumbs() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/route.php(315)
#14 vB_Api_Route->getRoute('forum/inte[len:96]', 'explain=1') in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/wrapper.php(201)
#15 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#16 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#17 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#18 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #21

SELECT * FROM routenew
 WHERE `routeid` IN (48,220,226)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	routenew	range	PRIMARY	PRIMARY	4		3	Using where

Time Before: 1713927719.7327
Time After: 1713927719.7327
Time Taken: 7.2956085205078E-5
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:56]', false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('routenew', array[len:1]) in /core/vb5/route.php(1285)
#7 vB5_Route::preloadRoutes(array[len:3]) in /core/vb5/route.php(376)
#8 vB5_Route->addParentNodeBreadcrumbs(116) in /core/vb5/route.php(342)
#9 vB5_Route->setBreadcrumbs() in /core/vb5/route.php(418)
#10 vB5_Route->getBreadcrumbs() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/route.php(315)
#11 vB_Api_Route->getRoute('forum/inte[len:96]', 'explain=1') in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/wrapper.php(201)
#12 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#13 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#14 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#15 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #22

SELECT * FROM cache
 WHERE `cacheid` IN ('node_2_lvl3data')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1713927719.7328
Time After: 1713927719.7328
Time Taken: 3.6001205444336E-5
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:60]', false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:1]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/library/content.php(3881)
#9 vB_Library_Content::fetchFromCache(array[len:1], 3) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/library/content.php(2596)
#10 vB_Library_Content->getRawContent(array[len:1]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/library/content.php(2537)
#11 vB_Library_Content->getBareContent(array[len:1]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/library/content/channel.php(414)
#12 vB_Library_Content_Channel->getBareContent(2) in /core/vb5/route/channel.php(26)
#13 vB5_Route_Channel->__construct(array[len:14], array[len:0], '', '') in /core/vb5/route.php(1417)
#14 vB5_Route::buildUrl(array[len:1]) in /core/vb5/route.php(383)
#15 vB5_Route->addParentNodeBreadcrumbs(116) in /core/vb5/route.php(342)
#16 vB5_Route->setBreadcrumbs() in /core/vb5/route.php(418)
#17 vB5_Route->getBreadcrumbs() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/route.php(315)
#18 vB_Api_Route->getRoute('forum/inte[len:96]', 'explain=1') in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/wrapper.php(201)
#19 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#20 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#21 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#22 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #23

SELECT * FROM cache
 WHERE `cacheid` IN ('node_113_lvl3data')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1713927719.7329
Time After: 1713927719.7329
Time Taken: 3.4809112548828E-5
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:62]', false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:1]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/library/content.php(3881)
#9 vB_Library_Content::fetchFromCache(array[len:1], 3) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/library/content.php(2596)
#10 vB_Library_Content->getRawContent(array[len:1]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/library/content.php(2537)
#11 vB_Library_Content->getBareContent(array[len:1]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/library/content/channel.php(414)
#12 vB_Library_Content_Channel->getBareContent(113) in /core/vb5/route/channel.php(26)
#13 vB5_Route_Channel->__construct(array[len:14], array[len:0], '', '') in /core/vb5/route.php(1417)
#14 vB5_Route::buildUrl(array[len:1]) in /core/vb5/route.php(383)
#15 vB5_Route->addParentNodeBreadcrumbs(116) in /core/vb5/route.php(342)
#16 vB5_Route->setBreadcrumbs() in /core/vb5/route.php(418)
#17 vB5_Route->getBreadcrumbs() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/route.php(315)
#18 vB_Api_Route->getRoute('forum/inte[len:96]', 'explain=1') in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/wrapper.php(201)
#19 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#20 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#21 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#22 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #24

SELECT * FROM style
 WHERE `styleid` = 25 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	style	const	PRIMARY	PRIMARY	2	const	1

Time Before: 1713927719.7336
Time After: 1713927719.7337
Time Taken: 9.9897384643555E-5
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:51]', false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('style', array[len:2], false) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('style', array[len:2]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/library/style.php(700)
#8 vB_Library_Style->fetchStyleByID('25') in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/style.php(59)
#9 vB_Api_Style->fetchStyleVars(array[len:1]) in phar:///pages/07/f0/d0012939/home/htdocs/wortkompass/core/vb/vb.phar/api/wrapper.php(201)
#10 vB_Api_Wrapper->__call('fetchStyleVars', array[len:1]) in /includes/api/interface/collapsed.php(105)
#11 Api_Interface_Collapsed->callApi('style', 'fetchStyleVars', array[len:1]) in /includes/vb5/template/stylevar.php(155)
#12 vB5_Template_Stylevar->fetchStyleVars() in /includes/vb5/template/stylevar.php(38)
#13 vB5_Template_Stylevar->__construct() in /includes/vb5/template/stylevar.php(29)
#14 vB5_Template_Stylevar::instance() in /includes/vb5/frontend/application.php(22)
#15 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #25

SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (1216)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927719.7345
Time After: 1713927719.7345
Time Taken: 4.1961669921875E-5
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

SQL Query #26

SELECT * FROM page
 WHERE `pageid` = 403 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	page	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927719.7358
Time After: 1713927719.7358
Time Taken: 3.6954879760742E-5
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

SQL Query #27

SELECT `varname`,`languageid`,`text` FROM phrase
 WHERE `varname` IN ('page_4ecbdac82f039695291105_title','page_4ecbdac82f039695291105_metadesc') AND `languageid` IN (2,0,-1)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	phrase	range	name_lang_type,languageid	name_lang_type	768		6	Using index condition

Time Before: 1713927719.7359
Time After: 1713927719.7359
Time Taken: 7.7009201049805E-5
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

SQL Query #28

SELECT * FROM page
 WHERE `pageid` = 423 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	page	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927719.736
Time After: 1713927719.7361
Time Taken: 7.2002410888672E-5
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

SQL Query #29

SELECT `varname`,`languageid`,`text` FROM phrase
 WHERE `varname` IN ('page_4ecbdac82f2c2760323374_title','page_4ecbdac82f2c2760323374_metadesc') AND `languageid` IN (2,0,-1)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	phrase	range	name_lang_type,languageid	name_lang_type	768		6	Using index condition

Time Before: 1713927719.7361
Time After: 1713927719.7362
Time Taken: 7.1048736572266E-5
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

SQL Query #30

SELECT * FROM page
 WHERE `pageid` = 406 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	page	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927719.7362
Time After: 1713927719.7363
Time Taken: 6.9856643676758E-5
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

SQL Query #31

SELECT `varname`,`languageid`,`text` FROM phrase
 WHERE `varname` IN ('page_4ecbdac82f039695291108_title','page_4ecbdac82f039695291108_metadesc') AND `languageid` IN (2,0,-1)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	phrase	range	name_lang_type,languageid	name_lang_type	768		6	Using index condition

Time Before: 1713927719.7363
Time After: 1713927719.7364
Time Taken: 7.0095062255859E-5
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

SQL Query #32

SELECT * FROM page
 WHERE `pageid` = 405 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	page	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927719.7364
Time After: 1713927719.7365
Time Taken: 6.9141387939453E-5
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

SQL Query #33

SELECT `varname`,`languageid`,`text` FROM phrase
 WHERE `varname` IN ('page_4ecbdac82f039695291107_title','page_4ecbdac82f039695291107_metadesc') AND `languageid` IN (2,0,-1)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	phrase	range	name_lang_type,languageid	name_lang_type	768		6	Using index condition

Time Before: 1713927719.7365
Time After: 1713927719.7365
Time Taken: 3.2901763916016E-5
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

SQL Query #34

SELECT * FROM cache
 WHERE `cacheid` IN ('vbPre_conversation227.212.116.76984')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE noticed after reading const tables

Time Before: 1713927719.7376
Time After: 1713927719.7377
Time Taken: 8.702278137207E-5
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

SQL Query #35

UPDATE session SET `wol`='a:3:{s:6:\"action\";s:15:\"viewing_topic_x\";s:6:\"params\";a:2:{i:0;s:37:\"Freitagsinfusion #1 - Fantasiewörter\";i:1;s:129:\"https://wortkompass.de/forum/interne-schreibtreffs-und-übungen/fingerübungen/76984-freitagsinfusion-1-fantasiewörter?explain=1\";}s:6:\"nodeid\";s:5:\"76984\";}',`pagekey`='conversation227.212.116.76984',`location`='/forum/interne-schreibtreffs-und-übungen/fingerübungen/76984-freitagsinfusion-1-fantasiewörter?explain=1' 
 WHERE (`sessionhash` = '1537ea10079148efdafc9d46633e8324') 
/**session**/

Time Before: 1713927719.7379
Time After: 1713927719.8095
Time Taken: 0.071589946746826
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

SQL Query #36

				SELECT page.*, pagetemplate.screenlayoutid, screenlayout.template AS screenlayouttemplate, pagetemplate.title AS templatetitle
				FROM page AS page
				LEFT JOIN pagetemplate AS pagetemplate ON(page.pagetemplateid = pagetemplate.pagetemplateid)
				LEFT JOIN screenlayout AS screenlayout ON(pagetemplate.screenlayoutid = screenlayout.screenlayoutid)
				WHERE page.pageid = 212
			
/**fetch_page_pagetemplate_screenlayout**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows
1	SIMPLE	page	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	pagetemplate	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	screenlayout	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927719.81
Time After: 1713927719.8103
Time Taken: 0.00030303001403809
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

SQL Query #37

SELECT `varname`,`languageid`,`text` FROM phrase
 WHERE `varname` IN ('page_572601e8b4879640727562_title','page_572601e8b4879640727562_metadesc') AND `languageid` IN (2,0,-1)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	phrase	range	name_lang_type,languageid	name_lang_type	768		6	Using index condition

Time Before: 1713927719.8104
Time After: 1713927719.8107
Time Taken: 0.00027298927307129
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

SQL Query #38

SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (1035)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927719.8115
Time After: 1713927719.8118
Time Taken: 0.00029587745666504
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

SQL Query #39

SELECT * FROM widgetinstance
 WHERE `pagetemplateid` IN (4,-1) 
 ORDER BY `containerinstanceid`,`displaysection`,`displayorder`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	widgetinstance	range	pagetemplateid	pagetemplateid	4		4	Using index condition; Using filesort

Time Before: 1713927719.8122
Time After: 1713927719.8125
Time Taken: 0.00029587745666504
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

SQL Query #40

				SELECT widgetdefinition.*, widget.template
				FROM widgetdefinition AS widgetdefinition
				JOIN widget AS widget ON (widgetdefinition.widgetid = widget.widgetid)
				WHERE widgetdefinition.widgetid IN(8,37,57)
			
/**getWidgetdefinition**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	widgetdefinition	range	widgetid	widgetid	4		17	Using index condition
1	SIMPLE	widget	eq_ref	PRIMARY	PRIMARY	4	db00080272.widgetdefinition.widgetid	1

Time Before: 1713927719.8127
Time After: 1713927719.813
Time Taken: 0.00032615661621094
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

SQL Query #41

SELECT * FROM widgetinstance
 WHERE `widgetinstanceid` IN (22,20,21)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	widgetinstance	range	PRIMARY	PRIMARY	4		3	Using where

Time Before: 1713927719.8132
Time After: 1713927719.8135
Time Taken: 0.00027585029602051
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

SQL Query #42

SELECT * FROM widget
 WHERE `widgetid` IN (0,8,37,57)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	widget	range	PRIMARY	PRIMARY	4		4	Using where

Time Before: 1713927719.8136
Time After: 1713927719.8138
Time Taken: 0.00020694732666016
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

SQL Query #43

SELECT COUNT(*) AS count FROM moderator
 WHERE `userid` = 0

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	moderator	ref	userid_nodeid	userid_nodeid	4	const	1	Using index

Time Before: 1713927719.8142
Time After: 1713927719.8144
Time Taken: 0.00019502639770508
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

SQL Query #44

SELECT * FROM datastore
 WHERE `title` IN ('vBUgChannelAccessG1')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	datastore	const	PRIMARY	PRIMARY	200	const	1

Time Before: 1713927719.8145
Time After: 1713927719.8146
Time Taken: 0.00019288063049316
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

SQL Query #45

SELECT * FROM widgetchannelconfig
 WHERE `widgetinstanceid` = 22 AND `nodeid` = 116

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE noticed after reading const tables

Time Before: 1713927719.8151
Time After: 1713927719.8153
Time Taken: 0.00018692016601562
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

SQL Query #46

SELECT * FROM widgetchannelconfig
 WHERE `widgetinstanceid` = 20 AND `nodeid` = 116

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE noticed after reading const tables

Time Before: 1713927719.8154
Time After: 1713927719.8156
Time Taken: 0.00018405914306641
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

SQL Query #47

SELECT * FROM widgetchannelconfig
 WHERE `widgetinstanceid` = 21 AND `nodeid` = 116

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE noticed after reading const tables

Time Before: 1713927719.8156
Time After: 1713927719.8158
Time Taken: 0.00018095970153809
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

SQL Query #48

SELECT `varname`,`languageid`,`text` FROM phrase
 WHERE `varname` IN ('widget_conversationdisplay_widgettitle','system_widgetcat','widget_announcement_widgettitle','display_widgetcat','widget_pagetitle_widgettitle') AND `languageid` IN (2,0,-1)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	phrase	range	name_lang_type,languageid	name_lang_type	768		15	Using index condition

Time Before: 1713927719.816
Time After: 1713927719.8161
Time Taken: 0.00019407272338867
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

SQL Query #49

SELECT * FROM pagetemplate
 WHERE `pagetemplateid` = 4 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pagetemplate	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927719.8163
Time After: 1713927719.8165
Time Taken: 0.00018811225891113
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

SQL Query #50

SELECT * FROM screenlayout
 WHERE `screenlayoutid` = 1 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	screenlayout	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927719.8165
Time After: 1713927719.8167
Time Taken: 0.00018906593322754
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

SQL Query #51

SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (637,1045,1204)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	range	PRIMARY	PRIMARY	4		3	Using where

Time Before: 1713927719.8172
Time After: 1713927719.8175
Time Taken: 0.0002751350402832
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

SQL Query #52

SELECT * FROM cache
 WHERE `cacheid` IN ('node_76984_lvl3data')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE noticed after reading const tables

Time Before: 1713927719.8196
Time After: 1713927719.82
Time Taken: 0.00045204162597656
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

SQL Query #53

SELECT node.*,text.nodeid AS text_nodeid,text.previewtext,text.previewimage,text.previewvideo,text.imageheight,text.imagewidth,text.rawtext,text.moderated,text.pagetextimages,text.pagetext,text.htmlstate,text.allowsmilie,text.showsignature,text.attach,text.infraction,text.reportnodeid,text.sc_userids, icon.iconpath, ch.routeid AS channelroute, ch.title AS channeltitle, ch.nodeid AS channelid,
		 starter.routeid AS starterroute, starter.title AS startertitle, starter.authorname as starterauthorname, starter.prefixid as starterprefixid,
		 starter.userid as starteruserid, starter.lastcontentid as starterlastcontentid, starter.totalcount+1 as startertotalcount, starter.urlident AS starterurlident,
		 deleteuser.username AS deleteusername, lastauthor.username AS lastauthorname, editlog.reason AS edit_reason, editlog.userid AS edit_userid, editlog.username AS edit_username,
		 editlog.dateline AS edit_dateline, editlog.hashistory, starter.nodeoptions as starternodeoptions, ch.nodeoptions as channelnodeoptions
		 FROM node AS node
		 
			LEFT JOIN  text AS text
			ON text.nodeid = node.nodeid

		 LEFT JOIN editlog AS editlog ON (editlog.nodeid = node.nodeid)
		 LEFT JOIN node AS starter ON (starter.nodeid = node.starter)
		 LEFT JOIN node AS ch ON (ch.nodeid = starter.parentid)
		 LEFT JOIN user AS deleteuser ON (node.deleteuserid > 0 AND node.deleteuserid = deleteuser.userid)
		 LEFT JOIN user AS lastauthor ON (node.lastauthorid = lastauthor.userid)
		 LEFT JOIN icon AS icon ON (node.iconid = icon.iconid)
		
		 WHERE node.nodeid IN (76984)
/** getFullContent**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	node	const	PRIMARY,nodeid	PRIMARY	4	const	1
1	SIMPLE	text	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	editlog	const	PRIMARY	PRIMARY	4	const	0	Unique row not found
1	SIMPLE	starter	const	PRIMARY,nodeid	PRIMARY	4	const	1
1	SIMPLE	ch	const	PRIMARY,nodeid	PRIMARY	4	const	1
1	SIMPLE	deleteuser	const	PRIMARY				1
1	SIMPLE	lastauthor	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	icon	const	PRIMARY	PRIMARY	2	const	0	Unique row not found

Time Before: 1713927719.8203
Time After: 1713927719.8215
Time Taken: 0.0011470317840576
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

SQL Query #54

SELECT * FROM closure
 WHERE `child` IN (76984) 
 ORDER BY `child` ASC, `depth` ASC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	closure	ref	child	child	4	const	5	Using where

Time Before: 1713927719.8217
Time After: 1713927719.8222
Time Taken: 0.00050091743469238
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

SQL Query #55

SELECT `varname`,`languageid`,`text` FROM phrase
 WHERE `varname` IN ('infraction_for_x_y','infraction_for_x_y_in_topic_z','warning_for_x_y','warning_for_x_y_in_topic_z','infraction_topic_post','infraction_topic_profile','infraction_received_ginfraction','warning_received_ginfraction','infraction_received_post','infraction_received_profile','warning_received_post','warning_received_profile','x_days','x_weeks','x_months','x_years','permanent') AND `languageid` IN (2,0,-1)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	phrase	range	name_lang_type,languageid	name_lang_type	768		51	Using index condition

Time Before: 1713927719.8236
Time After: 1713927719.8239
Time Taken: 0.00027298927307129
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

SQL Query #56

SELECT * FROM cache
 WHERE `cacheid` IN ('vb_UserWPerms_1_2')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE noticed after reading const tables

Time Before: 1713927719.8242
Time After: 1713927719.8246
Time Taken: 0.00043392181396484
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

SQL Query #57

				SELECT 
					userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
					IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
				FROM user AS user
				LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
				LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) 
					WHERE user.userid IN (1)
					/** fetchUserinfo **/

id	select_type	table	type	possible_keys	key	key_len	ref	rows
1	SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	userfield	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	usertextfield	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927719.8247
Time After: 1713927719.8251
Time Taken: 0.00034713745117188
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

SQL Query #58

SELECT * FROM cache
 WHERE `cacheid` IN ('vB_UserPerms1')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1713927719.8252
Time After: 1713927719.8257
Time Taken: 0.00047492980957031
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

SQL Query #59

SELECT * FROM cache
 WHERE `cacheid` IN ('vBUserRep_1')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1713927719.826
Time After: 1713927719.8264
Time Taken: 0.00039911270141602
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

SQL Query #60

SELECT * FROM cache
 WHERE `cacheid` IN ('vBAtchmnts_76984')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE noticed after reading const tables

Time Before: 1713927719.8269
Time After: 1713927719.8273
Time Taken: 0.00043892860412598
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

SQL Query #61

				(
					SELECT
						a.filedataid,
						n.nodeid, n.parentid, n.contenttypeid,
						a.visible, a.counter, a.posthash, a.filename, a.reportthreadid, a.settings,
						NULL AS height, NULL AS width, NULL AS style,
						a.caption,
						n.displayorder
					FROM node AS n USE INDEX (contenttypeid_parentid)
						JOIN attach AS a ON (a.nodeid = n.nodeid)
					WHERE n.contenttypeid = 15 AND n.parentid IN (76984)
				)
				UNION ALL
				(
					SELECT
						p.filedataid,
						n.nodeid, n.parentid, n.contenttypeid,
						NULL AS visible, NULL AS counter, NULL AS posthash, NULL AS filename, NULL AS reportthreadid, NULL AS settings,
						p.height, p.width, p.style,
						p.caption,
						n.displayorder
					FROM node AS n USE INDEX (contenttypeid_parentid)
						JOIN photo AS p ON (p.nodeid = n.nodeid)
					WHERE n.contenttypeid = 16 AND n.parentid IN (76984)
				)
			
/**fetchNodeAttachments**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows
1	PRIMARY	n	ref	contenttypeid_parentid	contenttypeid_parentid	6	const,const	1
1	PRIMARY	a	eq_ref	PRIMARY	PRIMARY	4	db00080272.n.nodeid	1
2	UNION	n	ref	contenttypeid_parentid	contenttypeid_parentid	6	const,const	1
2	UNION	p	eq_ref	PRIMARY	PRIMARY	4	db00080272.n.nodeid	1

Time Before: 1713927719.8275
Time After: 1713927719.8283
Time Taken: 0.00088095664978027
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

SQL Query #62

SELECT user.userid, avatar.avatarid, avatar.avatarpath, user.avatarrevision,
					customavatar.dateline, customavatar.width, customavatar.height, customavatar.height_thumb, customavatar.width_thumb, customavatar.filename
			FROM user as user
				LEFT JOIN customavatar AS customavatar ON customavatar.userid = user.userid
				LEFT JOIN avatar AS avatar ON avatar.avatarid = user.avatarid
			WHERE user.userid IN (1,87)
/**fetchAvatarsForUsers**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	user	range	PRIMARY	PRIMARY	4		2	Using where
1	SIMPLE	customavatar	eq_ref	PRIMARY	PRIMARY	4	db00080272.user.userid	1
1	SIMPLE	avatar	eq_ref	PRIMARY	PRIMARY	2	db00080272.user.avatarid	1	Using where

Time Before: 1713927719.8285
Time After: 1713927719.8292
Time Taken: 0.00068283081054688
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

SQL Query #63

SELECT * FROM site
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	site	ALL					1

Time Before: 1713927719.8319
Time After: 1713927719.8322
Time Taken: 0.00026202201843262
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

SQL Query #64

SELECT * FROM cache
 WHERE `cacheid` IN ('vBAtchmnts_116')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1713927719.8327
Time After: 1713927719.833
Time Taken: 0.00025701522827148
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

SQL Query #65

SELECT user.userid, avatar.avatarid, avatar.avatarpath, user.avatarrevision,
					customavatar.dateline, customavatar.width, customavatar.height, customavatar.height_thumb, customavatar.width_thumb, customavatar.filename
			FROM user as user
				LEFT JOIN customavatar AS customavatar ON customavatar.userid = user.userid
				LEFT JOIN avatar AS avatar ON avatar.avatarid = user.avatarid
			WHERE user.userid IN (847)
/**fetchAvatarsForUsers**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	customavatar	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	avatar	const	PRIMARY	PRIMARY	2	const	0	Unique row not found

Time Before: 1713927719.8332
Time After: 1713927719.8334
Time Taken: 0.00026297569274902
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

SQL Query #66

SELECT * FROM channel
 WHERE `guid` IN ('vbulletin-4ecbdf567f2c35.70389590','vbulletin-4ecbdf567f3a38.99555305','vbulletin-4ecbdf567f3a38.99555306','vbulletin-c-cmshome5229fa38b251e2.92227401','vbulletin-4ecbdf567f3341.44451100')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	channel	range	guid	guid	601		5	Using index condition

Time Before: 1713927719.8337
Time After: 1713927719.8339
Time Taken: 0.00025701522827148
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

SQL Query #67

SELECT * FROM cache
 WHERE `cacheid` IN ('node_1_lvl3data')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1713927719.8344
Time After: 1713927719.8347
Time Taken: 0.00025796890258789
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

SQL Query #68

SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (1212,1087,1088,1050,1214)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	range	PRIMARY	PRIMARY	4		5	Using where

Time Before: 1713927719.8359
Time After: 1713927719.8362
Time Taken: 0.00027108192443848
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

SQL Query #69

SELECT * FROM loginlibrary
 WHERE `productid` = 'googlelogin' 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	loginlibrary	const	productid	productid	102	const	1

Time Before: 1713927719.8374
Time After: 1713927719.8376
Time Taken: 0.00020480155944824
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

SQL Query #70

SELECT * FROM loginlibrary
 WHERE `productid` = 'twitterlogin' 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	loginlibrary	const	productid	productid	102	const	1

Time Before: 1713927719.8383
Time After: 1713927719.8385
Time Taken: 0.00019383430480957
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

SQL Query #71

SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (1326,1330,1333,933,654,659)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	range	PRIMARY	PRIMARY	4		6	Using where

Time Before: 1713927719.8394
Time After: 1713927719.8396
Time Taken: 0.0002281665802002
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

SQL Query #72

SELECT `noticeid` FROM noticedismissed
 WHERE `userid` = 0

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	noticedismissed	ref	userid	userid	4	const	1	Using index

Time Before: 1713927719.842
Time After: 1713927719.8422
Time Taken: 0.00020194053649902
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

SQL Query #73

SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (1047)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927719.843
Time After: 1713927719.8432
Time Taken: 0.00022006034851074
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

SQL Query #74

SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (1048)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927719.8437
Time After: 1713927719.8439
Time Taken: 0.00020790100097656
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

SQL Query #75

SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (1113,1151)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	range	PRIMARY	PRIMARY	4		2	Using where

Time Before: 1713927719.8448
Time After: 1713927719.845
Time Taken: 0.00021100044250488
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

SQL Query #76

SELECT * FROM cache
 WHERE `cacheid` IN ('vB_Announcements_116')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1713927719.8456
Time After: 1713927719.8458
Time Taken: 0.00018310546875
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

SQL Query #77

SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (1192)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927719.846
Time After: 1713927719.8462
Time Taken: 0.00019717216491699
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

SQL Query #78

SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (640)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927719.8485
Time After: 1713927719.8487
Time Taken: 0.00027298927307129
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

SQL Query #79

SELECT * FROM searchlog
 WHERE `searchhash` IN ('22b0d4b97538055451e1db02424ea1ec') AND `userid` = 0  AND `dateline` >= 1713927659  AND `sortby` = 'isstarter'  AND `sortorder` = 'desc'  
 ORDER BY `dateline` DESC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	searchlog	ref\|filter	search,userfloodcheck,dateline	search\|dateline	197\|4	const,const,const,const	1 (1%)	Using index condition; Using where; Using filesort; Using rowid filter

Time Before: 1713927719.8524
Time After: 1713927719.853
Time Taken: 0.00063014030456543
Memory Before: 8388608
Memory After: 8388608
Memory Used: 0

SQL Query #80

SELECT * FROM cache
 WHERE `cacheid` IN ('vb_readperms')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1713927719.8531
Time After: 1713927719.8535
Time Taken: 0.00041604042053223
Memory Before: 8388608
Memory After: 8388608
Memory Used: 0

SQL Query #81

SELECT * FROM cache
 WHERE `cacheid` IN ('getSearchResults_b83b6a2bbb2476d7c11f2660a9aa4c71')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE noticed after reading const tables

Time Before: 1713927719.8543
Time After: 1713927719.8546
Time Taken: 0.00031900405883789
Memory Before: 8388608
Memory After: 8388608
Memory Used: 0

SQL Query #82

			SELECT node.nodeid, starter.parentid, starter.userid, IF(node.nodeid = node.starter, 1, 0) as isstarter, node.nodeid AS nodeid2
			FROM node as node
			
			JOIN closure AS closure  ON node.nodeid = closure.child  
				 LEFT JOIN node AS starter ON starter.nodeid = node.starter

			WHERE closure.parent = '76984' AND 
				closure.depth <= 1 AND 
				node.inlist = 1 AND 
				node.protected <> '1'
AND (node.public_preview = 1 OR  ( ( (  (starter.parentid IN (1,100,104,114,119,124,485,16428,161826,205721,102,115,120,125,486,33796,161827,105,116,121,488,113,487,118,489,122,17827) ) AND node.showapproved > 0 AND node.viewperms > 1 AND node.showpublished > 0 ))
 OR starter.parentid = 10 AND node.userid IN (0) OR (node.starter = 0 AND node.nodeid IN (1,100,104,114,119,124,485,16428,161826,205721,102,115,120,125,486,33796,161827,105,116,121,488,113,487,118,489,122,17827))))

 
			ORDER BY isstarter DESC,node.created ASC,nodeid2 ASC
			
			
/**getSearchResults**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	closure	range	closure_uniq,parent_2,child	parent_2	7		6	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	node	eq_ref	PRIMARY,node_user,node_starter,node_ppreview,node_showapproved,nodeid,node_inlist,showpublished	PRIMARY	4	db00080272.closure.child	1	Using where
1	SIMPLE	starter	eq_ref	PRIMARY,nodeid	PRIMARY	4	db00080272.node.starter	1	Using where

Time Before: 1713927719.8549
Time After: 1713927719.8563
Time Taken: 0.0014269351959229
Memory Before: 8388608
Memory After: 8388608
Memory Used: 0

SQL Query #83

			REPLACE INTO searchlog
				(type,userid,ipaddress,searchhash,sortby,sortorder,searchtime,dateline,json,results,results_count)
			VALUES
				('0','0','18.222.125.171','22b0d4b97538055451e1db02424ea1ec','isstarter','desc','0.002190113067627','1713927719','{\"sort\":{\"created\":\"ASC\"},\"channel\":\"76984\",\"depth\":1,\"include_starter\":1,\"ignore_protected\":1,\"nolimit\":1}','76984,76993,77068,77436,77440,79612','6')

Time Before: 1713927719.8565
Time After: 1713927719.8655
Time Taken: 0.0090241432189941
Memory Before: 8388608
Memory After: 8388608
Memory Used: 0

SQL Query #84

SELECT * FROM searchlog
 WHERE `searchlogid` = 23994722 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	searchlog	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927719.8657
Time After: 1713927719.8662
Time Taken: 0.00047802925109863
Memory Before: 8388608
Memory After: 8388608
Memory Used: 0

SQL Query #85

SELECT * FROM page
 WHERE `pageid` = 412 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	page	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927719.8663
Time After: 1713927719.8665
Time Taken: 0.00021004676818848
Memory Before: 8388608
Memory After: 8388608
Memory Used: 0

SQL Query #86

SELECT `varname`,`languageid`,`text` FROM phrase
 WHERE `varname` IN ('page_4ecbdac82f281504471586_title','page_4ecbdac82f281504471586_metadesc') AND `languageid` IN (2,0,-1)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	phrase	range	name_lang_type,languageid	name_lang_type	768		6	Using index condition

Time Before: 1713927719.8666
Time After: 1713927719.8668
Time Taken: 0.00019097328186035
Memory Before: 8388608
Memory After: 8388608
Memory Used: 0

SQL Query #87

SELECT * FROM cache
 WHERE `cacheid` IN ('node_76993_lvl1data','node_77068_lvl1data','node_77436_lvl1data','node_77440_lvl1data','node_79612_lvl1data')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	range	PRIMARY	PRIMARY	66		5	Using where

Time Before: 1713927719.867
Time After: 1713927719.8674
Time Taken: 0.00039911270141602
Memory Before: 8388608
Memory After: 8388608
Memory Used: 0

SQL Query #88

SELECT node.*, editlog.reason AS edit_reason, editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline, editlog.hashistory, 0 AS nodeVoted, 0 AS readtime
			FROM node AS node
			LEFT JOIN editlog AS editlog ON (editlog.nodeid = node.nodeid)
			 WHERE node.nodeid IN (76993,77068,77436,77440,79612) 
/**fetchNodeWithContent**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	node	range	PRIMARY,nodeid	nodeid	4		5	Using index condition
1	SIMPLE	editlog	eq_ref	PRIMARY	PRIMARY	4	db00080272.node.nodeid	1

Time Before: 1713927719.8675
Time After: 1713927719.8682
Time Taken: 0.00068211555480957
Memory Before: 8388608
Memory After: 8388608
Memory Used: 0

SQL Query #89

SELECT * FROM cache
 WHERE `cacheid` IN ('vb_UserWPerms_0_2','vb_UserWPerms_476_2','vb_UserWPerms_84_2','vb_UserWPerms_87_2','vb_UserWPerms_9_2')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	range	PRIMARY	PRIMARY	66		5	Using where

Time Before: 1713927719.8683
Time After: 1713927719.8687
Time Taken: 0.00035905838012695
Memory Before: 8388608
Memory After: 8388608
Memory Used: 0

SQL Query #90

				SELECT 
					userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
					IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
				FROM user AS user
				LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
				LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) 
					WHERE user.userid IN (0,476,84,87,9)
					/** fetchUserinfo **/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	user	range	PRIMARY	PRIMARY	4		5	Using where
1	SIMPLE	userfield	eq_ref	PRIMARY	PRIMARY	4	db00080272.user.userid	1
1	SIMPLE	usertextfield	eq_ref	PRIMARY	PRIMARY	4	db00080272.user.userid	1

Time Before: 1713927719.8687
Time After: 1713927719.8697
Time Taken: 0.00092101097106934
Memory Before: 8388608
Memory After: 8388608
Memory Used: 0

SQL Query #91

SELECT * FROM routenew
 WHERE `routeid` IN (226,227)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	routenew	range	PRIMARY	PRIMARY	4		2	Using where

Time Before: 1713927719.8698
Time After: 1713927719.87
Time Taken: 0.00018310546875
Memory Before: 8388608
Memory After: 8388608
Memory Used: 0

SQL Query #92

SELECT * FROM cache
 WHERE `cacheid` IN ('vBAtchmnts_76993','vBAtchmnts_77068','vBAtchmnts_77436','vBAtchmnts_77440','vBAtchmnts_79612')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	range	PRIMARY	PRIMARY	66		5	Using where

Time Before: 1713927719.8702
Time After: 1713927719.8705
Time Taken: 0.00031495094299316
Memory Before: 8388608
Memory After: 8388608
Memory Used: 0

SQL Query #93

				(
					SELECT
						a.filedataid,
						n.nodeid, n.parentid, n.contenttypeid,
						a.visible, a.counter, a.posthash, a.filename, a.reportthreadid, a.settings,
						NULL AS height, NULL AS width, NULL AS style,
						a.caption,
						n.displayorder
					FROM node AS n USE INDEX (contenttypeid_parentid)
						JOIN attach AS a ON (a.nodeid = n.nodeid)
					WHERE n.contenttypeid = 15 AND n.parentid IN (76993,77068,77436,77440,79612)
				)
				UNION ALL
				(
					SELECT
						p.filedataid,
						n.nodeid, n.parentid, n.contenttypeid,
						NULL AS visible, NULL AS counter, NULL AS posthash, NULL AS filename, NULL AS reportthreadid, NULL AS settings,
						p.height, p.width, p.style,
						p.caption,
						n.displayorder
					FROM node AS n USE INDEX (contenttypeid_parentid)
						JOIN photo AS p ON (p.nodeid = n.nodeid)
					WHERE n.contenttypeid = 16 AND n.parentid IN (76993,77068,77436,77440,79612)
				)
			
/**fetchNodeAttachments**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	n	range	contenttypeid_parentid	contenttypeid_parentid	6		5	Using index condition
1	PRIMARY	a	eq_ref	PRIMARY	PRIMARY	4	db00080272.n.nodeid	1
2	UNION	n	range	contenttypeid_parentid	contenttypeid_parentid	6		5	Using index condition
2	UNION	p	eq_ref	PRIMARY	PRIMARY	4	db00080272.n.nodeid	1

Time Before: 1713927719.8706
Time After: 1713927719.8713
Time Taken: 0.00068998336791992
Memory Before: 8388608
Memory After: 8388608
Memory Used: 0

SQL Query #94

				SELECT cl.parent AS nodeid, count(a.nodeid) AS count
				FROM closure AS cl
				INNER JOIN attach AS a ON (a.nodeid = cl.child)
				WHERE cl.parent in (76984,76993,77068,77436,77440,79612)
				GROUP BY cl.parent
			
/**getDescendantAttachCount**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cl	range	closure_uniq,parent_2,child	parent_2	4		77	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	db00080272.cl.child	1	Using index

Time Before: 1713927719.8714
Time After: 1713927719.8721
Time Taken: 0.000701904296875
Memory Before: 8388608
Memory After: 8388608
Memory Used: 0

SQL Query #95

				SELECT cl.parent AS nodeid, count(child.nodeid) AS count
				FROM closure AS cl
				INNER JOIN node AS child USE INDEX (nodeid, node_ctypid_userid_dispo_idx) ON (child.nodeid = cl.child)
				WHERE cl.parent in (76984,76993,77068,77436,77440,79612) AND child.contenttypeid = 16
				GROUP BY cl.parent
			
/**getDescendantPhotoCount**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	child	ref	node_ctypid_userid_dispo_idx,nodeid	node_ctypid_userid_dispo_idx	2	const	195	Using index; Using temporary; Using filesort
1	SIMPLE	cl	ref	closure_uniq,parent_2,child	child	4	db00080272.child.nodeid	3	Using where; Using index

Time Before: 1713927719.8722
Time After: 1713927719.8741
Time Taken: 0.0019049644470215
Memory Before: 8388608
Memory After: 8388608
Memory Used: 0

SQL Query #96

SELECT * FROM closure
 WHERE `child` IN (76993,77068,77436,77440,79612) 
 ORDER BY `child` ASC, `depth` ASC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	closure	range	child	child	4		30	Using index condition

Time Before: 1713927719.8743
Time After: 1713927719.8748
Time Taken: 0.00051307678222656
Memory Before: 8388608
Memory After: 8388608
Memory Used: 0

SQL Query #97

SELECT * FROM cache
 WHERE `cacheid` IN ('node_76993_lvl3data','node_77068_lvl3data','node_77436_lvl3data','node_77440_lvl3data','node_79612_lvl3data')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	range	PRIMARY	PRIMARY	66		5	Using where

Time Before: 1713927719.8749
Time After: 1713927719.8753
Time Taken: 0.00032711029052734
Memory Before: 8388608
Memory After: 8388608
Memory Used: 0

SQL Query #98

SELECT node.*,text.nodeid AS text_nodeid,text.previewtext,text.previewimage,text.previewvideo,text.imageheight,text.imagewidth,text.rawtext,text.moderated,text.pagetextimages,text.pagetext,text.htmlstate,text.allowsmilie,text.showsignature,text.attach,text.infraction,text.reportnodeid,text.sc_userids, icon.iconpath, ch.routeid AS channelroute, ch.title AS channeltitle, ch.nodeid AS channelid,
		 starter.routeid AS starterroute, starter.title AS startertitle, starter.authorname as starterauthorname, starter.prefixid as starterprefixid,
		 starter.userid as starteruserid, starter.lastcontentid as starterlastcontentid, starter.totalcount+1 as startertotalcount, starter.urlident AS starterurlident,
		 deleteuser.username AS deleteusername, lastauthor.username AS lastauthorname, editlog.reason AS edit_reason, editlog.userid AS edit_userid, editlog.username AS edit_username,
		 editlog.dateline AS edit_dateline, editlog.hashistory, starter.nodeoptions as starternodeoptions, ch.nodeoptions as channelnodeoptions
		 FROM node AS node
		 
			LEFT JOIN  text AS text
			ON text.nodeid = node.nodeid

		 LEFT JOIN editlog AS editlog ON (editlog.nodeid = node.nodeid)
		 LEFT JOIN node AS starter ON (starter.nodeid = node.starter)
		 LEFT JOIN node AS ch ON (ch.nodeid = starter.parentid)
		 LEFT JOIN user AS deleteuser ON (node.deleteuserid > 0 AND node.deleteuserid = deleteuser.userid)
		 LEFT JOIN user AS lastauthor ON (node.lastauthorid = lastauthor.userid)
		 LEFT JOIN icon AS icon ON (node.iconid = icon.iconid)
		
		 WHERE node.nodeid IN (76993,77068,77436,77440,79612)
/** getFullContent**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	node	range	PRIMARY,nodeid	nodeid	4		5	Using index condition
1	SIMPLE	text	eq_ref	PRIMARY	PRIMARY	4	db00080272.node.nodeid	1
1	SIMPLE	editlog	eq_ref	PRIMARY	PRIMARY	4	db00080272.node.nodeid	1
1	SIMPLE	starter	eq_ref	PRIMARY,nodeid	PRIMARY	4	db00080272.node.starter	1	Using where
1	SIMPLE	ch	eq_ref	PRIMARY,nodeid	PRIMARY	4	db00080272.starter.parentid	1	Using where
1	SIMPLE	deleteuser	eq_ref	PRIMARY	PRIMARY	4	db00080272.node.deleteuserid	1	Using where
1	SIMPLE	lastauthor	eq_ref	PRIMARY	PRIMARY	4	db00080272.node.lastauthorid	1
1	SIMPLE	icon	eq_ref	PRIMARY	PRIMARY	2	db00080272.node.iconid	1	Using where

Time Before: 1713927719.8754
Time After: 1713927719.8765
Time Taken: 0.0010979175567627
Memory Before: 8388608
Memory After: 8388608
Memory Used: 0

SQL Query #99

SELECT * FROM node
 WHERE `nodeid` = 76993 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	node	const	PRIMARY,nodeid	PRIMARY	4	const	1

Time Before: 1713927719.8769
Time After: 1713927719.8773
Time Taken: 0.00038480758666992
Memory Before: 8388608
Memory After: 8388608
Memory Used: 0

SQL Query #100

SELECT * FROM node
 WHERE `nodeid` = 77068 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	node	const	PRIMARY,nodeid	PRIMARY	4	const	1

Time Before: 1713927719.8776
Time After: 1713927719.878
Time Taken: 0.00036501884460449
Memory Before: 8388608
Memory After: 8388608
Memory Used: 0

SQL Query #101

SELECT * FROM node
 WHERE `nodeid` = 77436 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	node	const	PRIMARY,nodeid	PRIMARY	4	const	1

Time Before: 1713927719.8783
Time After: 1713927719.8788
Time Taken: 0.00041818618774414
Memory Before: 8388608
Memory After: 8388608
Memory Used: 0

SQL Query #102

SELECT * FROM node
 WHERE `nodeid` = 77440 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	node	const	PRIMARY,nodeid	PRIMARY	4	const	1

Time Before: 1713927719.8791
Time After: 1713927719.8795
Time Taken: 0.00043606758117676
Memory Before: 8388608
Memory After: 8388608
Memory Used: 0

SQL Query #103

SELECT * FROM node
 WHERE `nodeid` = 79612 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	node	const	PRIMARY,nodeid	PRIMARY	4	const	1

Time Before: 1713927719.8799
Time After: 1713927719.8803
Time Taken: 0.00041890144348145
Memory Before: 8388608
Memory After: 8388608
Memory Used: 0

SQL Query #104

				SELECT 
					userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
					IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
				FROM user AS user
				LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
				LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) 
					WHERE user.userid IN (0)
					/** fetchUserinfo **/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE noticed after reading const tables

Time Before: 1713927719.8806
Time After: 1713927719.8809
Time Taken: 0.00023198127746582
Memory Before: 8388608
Memory After: 8388608
Memory Used: 0

SQL Query #105

SELECT * FROM cache
 WHERE `cacheid` IN ('vB_UserPerms87')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1713927719.881
Time After: 1713927719.8813
Time Taken: 0.00033998489379883
Memory Before: 8388608
Memory After: 8388608
Memory Used: 0

SQL Query #106

SELECT * FROM cache
 WHERE `cacheid` IN ('vB_UserPerms9')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1713927719.8817
Time After: 1713927719.8821
Time Taken: 0.00034904479980469
Memory Before: 10485760
Memory After: 10485760
Memory Used: 0

SQL Query #107

SELECT * FROM cache
 WHERE `cacheid` IN ('vBUserRep_476','vBUserRep_84','vBUserRep_87','vBUserRep_9')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	range	PRIMARY	PRIMARY	66		4	Using where

Time Before: 1713927719.8823
Time After: 1713927719.8827
Time Taken: 0.00038003921508789
Memory Before: 10485760
Memory After: 10485760
Memory Used: 0

SQL Query #108

SELECT user.userid, avatar.avatarid, avatar.avatarpath, user.avatarrevision,
					customavatar.dateline, customavatar.width, customavatar.height, customavatar.height_thumb, customavatar.width_thumb, customavatar.filename
			FROM user as user
				LEFT JOIN customavatar AS customavatar ON customavatar.userid = user.userid
				LEFT JOIN avatar AS avatar ON avatar.avatarid = user.avatarid
			WHERE user.userid IN (476,84,9)
/**fetchAvatarsForUsers**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	user	range	PRIMARY	PRIMARY	4		3	Using where
1	SIMPLE	customavatar	eq_ref	PRIMARY	PRIMARY	4	db00080272.user.userid	1
1	SIMPLE	avatar	eq_ref	PRIMARY	PRIMARY	2	db00080272.user.avatarid	1	Using where

Time Before: 1713927719.8835
Time After: 1713927719.884
Time Taken: 0.00048089027404785
Memory Before: 10485760
Memory After: 10485760
Memory Used: 0

SQL Query #109

SELECT * FROM cache
 WHERE `cacheid` IN ('vbSig_1','vbSig_87','vbSig_9')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	range	PRIMARY	PRIMARY	66		3	Using where

Time Before: 1713927719.8854
Time After: 1713927719.8857
Time Taken: 0.00034403800964355
Memory Before: 10485760
Memory After: 10485760
Memory Used: 0

SQL Query #110

SELECT * FROM datastore
 WHERE `title` IN ('smiliecache')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	datastore	const	PRIMARY	PRIMARY	200	const	1

Time Before: 1713927719.886
Time After: 1713927719.8862
Time Taken: 0.0001981258392334
Memory Before: 10485760
Memory After: 10485760
Memory Used: 0

SQL Query #111

SELECT * FROM bbcode

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bbcode	ALL					3

Time Before: 1713927719.8864
Time After: 1713927719.8866
Time Taken: 0.00020098686218262
Memory Before: 10485760
Memory After: 10485760
Memory Used: 0

SQL Query #112

SELECT * FROM channel
 WHERE `nodeid` = 116 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	channel	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927719.8878
Time After: 1713927719.888
Time Taken: 0.00019097328186035
Memory Before: 10485760
Memory After: 10485760
Memory Used: 0

SQL Query #113

SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (1253,881,872,938)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	range	PRIMARY	PRIMARY	4		4	Using where

Time Before: 1713927719.8885
Time After: 1713927719.8888
Time Taken: 0.0003199577331543
Memory Before: 10485760
Memory After: 10485760
Memory Used: 0

SQL Query #114

SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (939)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927719.8927
Time After: 1713927719.8929
Time Taken: 0.00020503997802734
Memory Before: 12582912
Memory After: 12582912
Memory Used: 0

SQL Query #115

SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (897,896)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	range	PRIMARY	PRIMARY	4		2	Using where

Time Before: 1713927719.8936
Time After: 1713927719.8938
Time Taken: 0.00021815299987793
Memory Before: 12582912
Memory After: 12582912
Memory Used: 0

SQL Query #116

SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (735,903,861)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	range	PRIMARY	PRIMARY	4		3	Using where

Time Before: 1713927719.8948
Time After: 1713927719.895
Time Taken: 0.00018787384033203
Memory Before: 12582912
Memory After: 12582912
Memory Used: 0

SQL Query #117

SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (950,733)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	range	PRIMARY	PRIMARY	4		2	Using where

Time Before: 1713927719.8957
Time After: 1713927719.8958
Time Taken: 0.00016212463378906
Memory Before: 12582912
Memory After: 12582912
Memory Used: 0

SQL Query #118

SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (732,731)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	range	PRIMARY	PRIMARY	4		2	Using where

Time Before: 1713927719.8968
Time After: 1713927719.897
Time Taken: 0.00017213821411133
Memory Before: 12582912
Memory After: 12582912
Memory Used: 0

SQL Query #119

SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (1257,1322)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	range	PRIMARY	PRIMARY	4		2	Using where

Time Before: 1713927719.8977
Time After: 1713927719.8978
Time Taken: 0.00015902519226074
Memory Before: 12582912
Memory After: 12582912
Memory Used: 0

SQL Query #120

SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (854)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927719.9009
Time After: 1713927719.9011
Time Taken: 0.00014686584472656
Memory Before: 12582912
Memory After: 12582912
Memory Used: 0

SQL Query #121

SELECT * FROM cache
 WHERE `cacheid` IN ('SrchResults097951131')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE noticed after reading const tables

Time Before: 1713927719.9021
Time After: 1713927719.9023
Time Taken: 0.00023388862609863
Memory Before: 12582912
Memory After: 12582912
Memory Used: 0

SQL Query #122

			SELECT node.nodeid, node.nodeid AS nodeid2
			FROM node as node
			
			JOIN closure AS closure  ON node.nodeid = closure.child  
				 LEFT JOIN node AS starter ON starter.nodeid = node.starter

			WHERE closure.parent = '76993' AND 
				node.nodeid <> closure.parent AND 
				closure.depth <= 1 AND 
				node.inlist = 1
AND (node.public_preview = 1 OR  ( ( (  (starter.parentid IN (1,100,104,114,119,124,485,16428,161826,205721,102,115,120,125,486,33796,161827,105,116,121,488,113,487,118,489,122,17827) ) AND node.showapproved > 0 AND node.viewperms > 1 AND node.showpublished > 0 ))
 OR starter.parentid = 10 AND node.userid IN (0) OR (node.starter = 0 AND node.nodeid IN (1,100,104,114,119,124,485,16428,161826,205721,102,115,120,125,486,33796,161827,105,116,121,488,113,487,118,489,122,17827))))

 
			ORDER BY node.created DESC,nodeid2 DESC
			
			
/**getSearchResults**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	closure	ref	closure_uniq,parent_2,child	closure_uniq	4	const	9	Using where; Using temporary; Using filesort
1	SIMPLE	node	eq_ref	PRIMARY,node_user,node_starter,node_ppreview,node_showapproved,nodeid,node_inlist,showpublished	PRIMARY	4	db00080272.closure.child	1	Using where
1	SIMPLE	starter	eq_ref	PRIMARY,nodeid	PRIMARY	4	db00080272.node.starter	1	Using where

Time Before: 1713927719.9028
Time After: 1713927719.9039
Time Taken: 0.0010969638824463
Memory Before: 12582912
Memory After: 12582912
Memory Used: 0

SQL Query #123

			REPLACE INTO searchlog
				(type,userid,ipaddress,searchhash,sortby,sortorder,searchtime,dateline,json,results,results_count)
			VALUES
				('0','0','18.222.125.171','0b16b1e9bac8368d77af30bd01bb7a16','created','desc','0.0013000965118408','1713927719','{\"channel\":\"76993\",\"depth\":\"1\",\"nolimit\":1,\"disable_two_pass\":1}','77522,77455,77441,77028,77017,77007,76998,76996','8')

Time Before: 1713927719.9041
Time After: 1713927719.9094
Time Taken: 0.0053830146789551
Memory Before: 12582912
Memory After: 12582912
Memory Used: 0

SQL Query #124

SELECT * FROM searchlog
 WHERE `searchlogid` = 23994723 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	searchlog	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927719.9096
Time After: 1713927719.9102
Time Taken: 0.00057101249694824
Memory Before: 12582912
Memory After: 12582912
Memory Used: 0

SQL Query #125

SELECT * FROM cache
 WHERE `cacheid` IN ('node_77522_lvl1data','node_77455_lvl1data','node_77441_lvl1data')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	range	PRIMARY	PRIMARY	66		3	Using where

Time Before: 1713927719.9105
Time After: 1713927719.911
Time Taken: 0.00050020217895508
Memory Before: 12582912
Memory After: 12582912
Memory Used: 0

SQL Query #126

SELECT * FROM node
 WHERE `nodeid` IN (77522,77455,77441)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	node	range	PRIMARY,nodeid	nodeid	4		3	Using index condition

Time Before: 1713927719.9112
Time After: 1713927719.9119
Time Taken: 0.00070095062255859
Memory Before: 12582912
Memory After: 12582912
Memory Used: 0

SQL Query #127

				SELECT 
					userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
					IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
				FROM user AS user
				LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
				LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) 
					WHERE user.userid IN (0)
					/** fetchUserinfo **/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE noticed after reading const tables

Time Before: 1713927719.9121
Time After: 1713927719.9124
Time Taken: 0.0003349781036377
Memory Before: 12582912
Memory After: 12582912
Memory Used: 0

SQL Query #128

SELECT * FROM routenew
 WHERE `routeid` IN (227)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	routenew	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927719.9125
Time After: 1713927719.9128
Time Taken: 0.00025582313537598
Memory Before: 12582912
Memory After: 12582912
Memory Used: 0

SQL Query #129

SELECT * FROM cache
 WHERE `cacheid` IN ('vBAtchmnts_77522','vBAtchmnts_77455','vBAtchmnts_77441')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	range	PRIMARY	PRIMARY	66		3	Using where

Time Before: 1713927719.9129
Time After: 1713927719.9133
Time Taken: 0.00045609474182129
Memory Before: 12582912
Memory After: 12582912
Memory Used: 0

SQL Query #130

				(
					SELECT
						a.filedataid,
						n.nodeid, n.parentid, n.contenttypeid,
						a.visible, a.counter, a.posthash, a.filename, a.reportthreadid, a.settings,
						NULL AS height, NULL AS width, NULL AS style,
						a.caption,
						n.displayorder
					FROM node AS n USE INDEX (contenttypeid_parentid)
						JOIN attach AS a ON (a.nodeid = n.nodeid)
					WHERE n.contenttypeid = 15 AND n.parentid IN (77522,77455,77441)
				)
				UNION ALL
				(
					SELECT
						p.filedataid,
						n.nodeid, n.parentid, n.contenttypeid,
						NULL AS visible, NULL AS counter, NULL AS posthash, NULL AS filename, NULL AS reportthreadid, NULL AS settings,
						p.height, p.width, p.style,
						p.caption,
						n.displayorder
					FROM node AS n USE INDEX (contenttypeid_parentid)
						JOIN photo AS p ON (p.nodeid = n.nodeid)
					WHERE n.contenttypeid = 16 AND n.parentid IN (77522,77455,77441)
				)
			
/**fetchNodeAttachments**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	n	range	contenttypeid_parentid	contenttypeid_parentid	6		3	Using index condition
1	PRIMARY	a	eq_ref	PRIMARY	PRIMARY	4	db00080272.n.nodeid	1
2	UNION	n	range	contenttypeid_parentid	contenttypeid_parentid	6		3	Using index condition
2	UNION	p	eq_ref	PRIMARY	PRIMARY	4	db00080272.n.nodeid	1

Time Before: 1713927719.9135
Time After: 1713927719.9144
Time Taken: 0.00090503692626953
Memory Before: 12582912
Memory After: 12582912
Memory Used: 0

SQL Query #131

				SELECT cl.parent AS nodeid, count(a.nodeid) AS count
				FROM closure AS cl
				INNER JOIN attach AS a ON (a.nodeid = cl.child)
				WHERE cl.parent in (77522,77455,77441)
				GROUP BY cl.parent
			
/**getDescendantAttachCount**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cl	range	closure_uniq,parent_2,child	parent_2	4		3	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	db00080272.cl.child	1	Using index

Time Before: 1713927719.9145
Time After: 1713927719.9151
Time Taken: 0.00057291984558105
Memory Before: 12582912
Memory After: 12582912
Memory Used: 0

SQL Query #132

				SELECT cl.parent AS nodeid, count(child.nodeid) AS count
				FROM closure AS cl
				INNER JOIN node AS child USE INDEX (nodeid, node_ctypid_userid_dispo_idx) ON (child.nodeid = cl.child)
				WHERE cl.parent in (77522,77455,77441) AND child.contenttypeid = 16
				GROUP BY cl.parent
			
/**getDescendantPhotoCount**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cl	range	closure_uniq,parent_2,child	parent_2	4		3	Using where; Using index
1	SIMPLE	child	ref	node_ctypid_userid_dispo_idx,nodeid	nodeid	6	db00080272.cl.child,const	1	Using index

Time Before: 1713927719.9152
Time After: 1713927719.9158
Time Taken: 0.000579833984375
Memory Before: 12582912
Memory After: 12582912
Memory Used: 0

SQL Query #133

SELECT * FROM closure
 WHERE `child` IN (77522,77455,77441) 
 ORDER BY `child` ASC, `depth` ASC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	closure	range	child	child	4		21	Using index condition

Time Before: 1713927719.916
Time After: 1713927719.9166
Time Taken: 0.00060606002807617
Memory Before: 12582912
Memory After: 12582912
Memory Used: 0

SQL Query #134

SELECT * FROM cache
 WHERE `cacheid` IN ('node_77522_lvl3data','node_77455_lvl3data','node_77441_lvl3data')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	range	PRIMARY	PRIMARY	66		3	Using where

Time Before: 1713927719.9168
Time After: 1713927719.9172
Time Taken: 0.00043296813964844
Memory Before: 12582912
Memory After: 12582912
Memory Used: 0

SQL Query #135

SELECT node.*,text.nodeid AS text_nodeid,text.previewtext,text.previewimage,text.previewvideo,text.imageheight,text.imagewidth,text.rawtext,text.moderated,text.pagetextimages,text.pagetext,text.htmlstate,text.allowsmilie,text.showsignature,text.attach,text.infraction,text.reportnodeid,text.sc_userids, icon.iconpath, ch.routeid AS channelroute, ch.title AS channeltitle, ch.nodeid AS channelid,
		 starter.routeid AS starterroute, starter.title AS startertitle, starter.authorname as starterauthorname, starter.prefixid as starterprefixid,
		 starter.userid as starteruserid, starter.lastcontentid as starterlastcontentid, starter.totalcount+1 as startertotalcount, starter.urlident AS starterurlident,
		 deleteuser.username AS deleteusername, lastauthor.username AS lastauthorname, editlog.reason AS edit_reason, editlog.userid AS edit_userid, editlog.username AS edit_username,
		 editlog.dateline AS edit_dateline, editlog.hashistory, starter.nodeoptions as starternodeoptions, ch.nodeoptions as channelnodeoptions
		 FROM node AS node
		 
			LEFT JOIN  text AS text
			ON text.nodeid = node.nodeid

		 LEFT JOIN editlog AS editlog ON (editlog.nodeid = node.nodeid)
		 LEFT JOIN node AS starter ON (starter.nodeid = node.starter)
		 LEFT JOIN node AS ch ON (ch.nodeid = starter.parentid)
		 LEFT JOIN user AS deleteuser ON (node.deleteuserid > 0 AND node.deleteuserid = deleteuser.userid)
		 LEFT JOIN user AS lastauthor ON (node.lastauthorid = lastauthor.userid)
		 LEFT JOIN icon AS icon ON (node.iconid = icon.iconid)
		
		 WHERE node.nodeid IN (77522,77455,77441)
/** getFullContent**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	node	range	PRIMARY,nodeid	nodeid	4		3	Using index condition
1	SIMPLE	text	eq_ref	PRIMARY	PRIMARY	4	db00080272.node.nodeid	1
1	SIMPLE	editlog	eq_ref	PRIMARY	PRIMARY	4	db00080272.node.nodeid	1
1	SIMPLE	starter	eq_ref	PRIMARY,nodeid	PRIMARY	4	db00080272.node.starter	1	Using where
1	SIMPLE	ch	eq_ref	PRIMARY,nodeid	PRIMARY	4	db00080272.starter.parentid	1	Using where
1	SIMPLE	deleteuser	eq_ref	PRIMARY	PRIMARY	4	db00080272.node.deleteuserid	1	Using where
1	SIMPLE	lastauthor	eq_ref	PRIMARY	PRIMARY	4	db00080272.node.lastauthorid	1
1	SIMPLE	icon	eq_ref	PRIMARY	PRIMARY	2	db00080272.node.iconid	1	Using where

Time Before: 1713927719.9174
Time After: 1713927719.9187
Time Taken: 0.0012869834899902
Memory Before: 12582912
Memory After: 12582912
Memory Used: 0

SQL Query #136

				SELECT 
					userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
					IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
				FROM user AS user
				LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
				LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) 
					WHERE user.userid IN (0)
					/** fetchUserinfo **/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE noticed after reading const tables

Time Before: 1713927719.9197
Time After: 1713927719.92
Time Taken: 0.0003199577331543
Memory Before: 12582912
Memory After: 12582912
Memory Used: 0

SQL Query #137

SELECT * FROM searchlog
 WHERE `searchlogid` = 23994723 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	searchlog	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927719.9211
Time After: 1713927719.9214
Time Taken: 0.00024509429931641
Memory Before: 12582912
Memory After: 12582912
Memory Used: 0

SQL Query #138

SELECT `username`,`userid` FROM user
 WHERE `userid` IN ('','','')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	user	range	PRIMARY	PRIMARY	4		1	Using where

Time Before: 1713927719.9218
Time After: 1713927719.9222
Time Taken: 0.00043296813964844
Memory Before: 12582912
Memory After: 12582912
Memory Used: 0

SQL Query #139

SELECT user.userid, avatar.avatarid, avatar.avatarpath, user.avatarrevision,
					customavatar.dateline, customavatar.width, customavatar.height, customavatar.height_thumb, customavatar.width_thumb, customavatar.filename
			FROM user as user
				LEFT JOIN customavatar AS customavatar ON customavatar.userid = user.userid
				LEFT JOIN avatar AS avatar ON avatar.avatarid = user.avatarid
			WHERE user.userid IN (0)
/**fetchAvatarsForUsers**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE noticed after reading const tables

Time Before: 1713927719.9224
Time After: 1713927719.9226
Time Taken: 0.00020194053649902
Memory Before: 12582912
Memory After: 12582912
Memory Used: 0

SQL Query #140

SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (626)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927719.9229
Time After: 1713927719.9232
Time Taken: 0.00026297569274902
Memory Before: 12582912
Memory After: 12582912
Memory Used: 0

SQL Query #141

SELECT * FROM cache
 WHERE `cacheid` IN ('SrchResults02972120952')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE noticed after reading const tables

Time Before: 1713927719.9326
Time After: 1713927719.9329
Time Taken: 0.00030207633972168
Memory Before: 14680064
Memory After: 14680064
Memory Used: 0

SQL Query #142

			SELECT node.nodeid, node.nodeid AS nodeid2
			FROM node as node
			
			JOIN closure AS closure  ON node.nodeid = closure.child  
				 LEFT JOIN node AS starter ON starter.nodeid = node.starter

			WHERE closure.parent = '77068' AND 
				node.nodeid <> closure.parent AND 
				closure.depth <= 1 AND 
				node.inlist = 1
AND (node.public_preview = 1 OR  ( ( (  (starter.parentid IN (1,100,104,114,119,124,485,16428,161826,205721,102,115,120,125,486,33796,161827,105,116,121,488,113,487,118,489,122,17827) ) AND node.showapproved > 0 AND node.viewperms > 1 AND node.showpublished > 0 ))
 OR starter.parentid = 10 AND node.userid IN (0) OR (node.starter = 0 AND node.nodeid IN (1,100,104,114,119,124,485,16428,161826,205721,102,115,120,125,486,33796,161827,105,116,121,488,113,487,118,489,122,17827))))

 
			ORDER BY node.created DESC,nodeid2 DESC
			
			
/**getSearchResults**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	closure	ref	closure_uniq,parent_2,child	closure_uniq	4	const	8	Using where; Using temporary; Using filesort
1	SIMPLE	node	eq_ref	PRIMARY,node_user,node_starter,node_ppreview,node_showapproved,nodeid,node_inlist,showpublished	PRIMARY	4	db00080272.closure.child	1	Using where
1	SIMPLE	starter	eq_ref	PRIMARY,nodeid	PRIMARY	4	db00080272.node.starter	1	Using where

Time Before: 1713927719.9335
Time After: 1713927719.9349
Time Taken: 0.0013320446014404
Memory Before: 14680064
Memory After: 14680064
Memory Used: 0

SQL Query #143

			REPLACE INTO searchlog
				(type,userid,ipaddress,searchhash,sortby,sortorder,searchtime,dateline,json,results,results_count)
			VALUES
				('0','0','18.222.125.171','f15b49250a1893be02f696de1e0a8d82','created','desc','0.0015649795532227','1713927719','{\"channel\":\"77068\",\"depth\":\"1\",\"nolimit\":1,\"disable_two_pass\":1}','77284,77102,77093,77085,77083,77082,77080','7')

Time Before: 1713927719.935
Time After: 1713927719.9427
Time Taken: 0.0076899528503418
Memory Before: 14680064
Memory After: 14680064
Memory Used: 0

SQL Query #144

SELECT * FROM searchlog
 WHERE `searchlogid` = 23994724 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	searchlog	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927719.9428
Time After: 1713927719.9432
Time Taken: 0.00038695335388184
Memory Before: 14680064
Memory After: 14680064
Memory Used: 0

SQL Query #145

SELECT * FROM cache
 WHERE `cacheid` IN ('node_77284_lvl1data','node_77102_lvl1data','node_77093_lvl1data')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	range	PRIMARY	PRIMARY	66		3	Using where

Time Before: 1713927719.9434
Time After: 1713927719.9438
Time Taken: 0.00035905838012695
Memory Before: 14680064
Memory After: 14680064
Memory Used: 0

SQL Query #146

SELECT * FROM node
 WHERE `nodeid` IN (77284,77102,77093)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	node	range	PRIMARY,nodeid	nodeid	4		3	Using index condition

Time Before: 1713927719.9439
Time After: 1713927719.9443
Time Taken: 0.00044894218444824
Memory Before: 14680064
Memory After: 14680064
Memory Used: 0

SQL Query #147

SELECT * FROM cache
 WHERE `cacheid` IN ('vb_UserWPerms_2_2')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE noticed after reading const tables

Time Before: 1713927719.9445
Time After: 1713927719.9447
Time Taken: 0.00025796890258789
Memory Before: 14680064
Memory After: 14680064
Memory Used: 0

SQL Query #148

				SELECT 
					userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
					IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
				FROM user AS user
				LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
				LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) 
					WHERE user.userid IN (2)
					/** fetchUserinfo **/

id	select_type	table	type	possible_keys	key	key_len	ref	rows
1	SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	userfield	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	usertextfield	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927719.9448
Time After: 1713927719.945
Time Taken: 0.00022292137145996
Memory Before: 14680064
Memory After: 14680064
Memory Used: 0

SQL Query #149

SELECT * FROM routenew
 WHERE `routeid` IN (227)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	routenew	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927719.9451
Time After: 1713927719.9453
Time Taken: 0.00016212463378906
Memory Before: 14680064
Memory After: 14680064
Memory Used: 0

SQL Query #150

SELECT * FROM cache
 WHERE `cacheid` IN ('vBAtchmnts_77284','vBAtchmnts_77102','vBAtchmnts_77093')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	range	PRIMARY	PRIMARY	66		3	Using where

Time Before: 1713927719.9453
Time After: 1713927719.9456
Time Taken: 0.00028705596923828
Memory Before: 14680064
Memory After: 14680064
Memory Used: 0

SQL Query #151

				(
					SELECT
						a.filedataid,
						n.nodeid, n.parentid, n.contenttypeid,
						a.visible, a.counter, a.posthash, a.filename, a.reportthreadid, a.settings,
						NULL AS height, NULL AS width, NULL AS style,
						a.caption,
						n.displayorder
					FROM node AS n USE INDEX (contenttypeid_parentid)
						JOIN attach AS a ON (a.nodeid = n.nodeid)
					WHERE n.contenttypeid = 15 AND n.parentid IN (77284,77102,77093)
				)
				UNION ALL
				(
					SELECT
						p.filedataid,
						n.nodeid, n.parentid, n.contenttypeid,
						NULL AS visible, NULL AS counter, NULL AS posthash, NULL AS filename, NULL AS reportthreadid, NULL AS settings,
						p.height, p.width, p.style,
						p.caption,
						n.displayorder
					FROM node AS n USE INDEX (contenttypeid_parentid)
						JOIN photo AS p ON (p.nodeid = n.nodeid)
					WHERE n.contenttypeid = 16 AND n.parentid IN (77284,77102,77093)
				)
			
/**fetchNodeAttachments**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	n	range	contenttypeid_parentid	contenttypeid_parentid	6		3	Using index condition
1	PRIMARY	a	eq_ref	PRIMARY	PRIMARY	4	db00080272.n.nodeid	1
2	UNION	n	range	contenttypeid_parentid	contenttypeid_parentid	6		3	Using index condition
2	UNION	p	eq_ref	PRIMARY	PRIMARY	4	db00080272.n.nodeid	1

Time Before: 1713927719.9457
Time After: 1713927719.9463
Time Taken: 0.00056910514831543
Memory Before: 14680064
Memory After: 14680064
Memory Used: 0

SQL Query #152

				SELECT cl.parent AS nodeid, count(a.nodeid) AS count
				FROM closure AS cl
				INNER JOIN attach AS a ON (a.nodeid = cl.child)
				WHERE cl.parent in (77284,77102,77093)
				GROUP BY cl.parent
			
/**getDescendantAttachCount**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cl	range	closure_uniq,parent_2,child	parent_2	4		3	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	db00080272.cl.child	1	Using index

Time Before: 1713927719.9464
Time After: 1713927719.9467
Time Taken: 0.0003659725189209
Memory Before: 14680064
Memory After: 14680064
Memory Used: 0

SQL Query #153

				SELECT cl.parent AS nodeid, count(child.nodeid) AS count
				FROM closure AS cl
				INNER JOIN node AS child USE INDEX (nodeid, node_ctypid_userid_dispo_idx) ON (child.nodeid = cl.child)
				WHERE cl.parent in (77284,77102,77093) AND child.contenttypeid = 16
				GROUP BY cl.parent
			
/**getDescendantPhotoCount**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cl	range	closure_uniq,parent_2,child	parent_2	4		3	Using where; Using index
1	SIMPLE	child	ref	node_ctypid_userid_dispo_idx,nodeid	nodeid	6	db00080272.cl.child,const	1	Using index

Time Before: 1713927719.9468
Time After: 1713927719.9472
Time Taken: 0.00037693977355957
Memory Before: 14680064
Memory After: 14680064
Memory Used: 0

SQL Query #154

SELECT * FROM closure
 WHERE `child` IN (77284,77102,77093) 
 ORDER BY `child` ASC, `depth` ASC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	closure	range	child	child	4		21	Using index condition

Time Before: 1713927719.9473
Time After: 1713927719.9477
Time Taken: 0.00036907196044922
Memory Before: 14680064
Memory After: 14680064
Memory Used: 0

SQL Query #155

SELECT * FROM cache
 WHERE `cacheid` IN ('node_77284_lvl3data','node_77102_lvl3data','node_77093_lvl3data')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	range	PRIMARY	PRIMARY	66		3	Using where

Time Before: 1713927719.9478
Time After: 1713927719.948
Time Taken: 0.00025296211242676
Memory Before: 14680064
Memory After: 14680064
Memory Used: 0

SQL Query #156

SELECT node.*,text.nodeid AS text_nodeid,text.previewtext,text.previewimage,text.previewvideo,text.imageheight,text.imagewidth,text.rawtext,text.moderated,text.pagetextimages,text.pagetext,text.htmlstate,text.allowsmilie,text.showsignature,text.attach,text.infraction,text.reportnodeid,text.sc_userids, icon.iconpath, ch.routeid AS channelroute, ch.title AS channeltitle, ch.nodeid AS channelid,
		 starter.routeid AS starterroute, starter.title AS startertitle, starter.authorname as starterauthorname, starter.prefixid as starterprefixid,
		 starter.userid as starteruserid, starter.lastcontentid as starterlastcontentid, starter.totalcount+1 as startertotalcount, starter.urlident AS starterurlident,
		 deleteuser.username AS deleteusername, lastauthor.username AS lastauthorname, editlog.reason AS edit_reason, editlog.userid AS edit_userid, editlog.username AS edit_username,
		 editlog.dateline AS edit_dateline, editlog.hashistory, starter.nodeoptions as starternodeoptions, ch.nodeoptions as channelnodeoptions
		 FROM node AS node
		 
			LEFT JOIN  text AS text
			ON text.nodeid = node.nodeid

		 LEFT JOIN editlog AS editlog ON (editlog.nodeid = node.nodeid)
		 LEFT JOIN node AS starter ON (starter.nodeid = node.starter)
		 LEFT JOIN node AS ch ON (ch.nodeid = starter.parentid)
		 LEFT JOIN user AS deleteuser ON (node.deleteuserid > 0 AND node.deleteuserid = deleteuser.userid)
		 LEFT JOIN user AS lastauthor ON (node.lastauthorid = lastauthor.userid)
		 LEFT JOIN icon AS icon ON (node.iconid = icon.iconid)
		
		 WHERE node.nodeid IN (77284,77102,77093)
/** getFullContent**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	node	range	PRIMARY,nodeid	nodeid	4		3	Using index condition
1	SIMPLE	text	eq_ref	PRIMARY	PRIMARY	4	db00080272.node.nodeid	1
1	SIMPLE	editlog	eq_ref	PRIMARY	PRIMARY	4	db00080272.node.nodeid	1
1	SIMPLE	starter	eq_ref	PRIMARY,nodeid	PRIMARY	4	db00080272.node.starter	1	Using where
1	SIMPLE	ch	eq_ref	PRIMARY,nodeid	PRIMARY	4	db00080272.starter.parentid	1	Using where
1	SIMPLE	deleteuser	eq_ref	PRIMARY	PRIMARY	4	db00080272.node.deleteuserid	1	Using where
1	SIMPLE	lastauthor	eq_ref	PRIMARY	PRIMARY	4	db00080272.node.lastauthorid	1
1	SIMPLE	icon	eq_ref	PRIMARY	PRIMARY	2	db00080272.node.iconid	1	Using where

Time Before: 1713927719.9481
Time After: 1713927719.9489
Time Taken: 0.00077414512634277
Memory Before: 14680064
Memory After: 14680064
Memory Used: 0

SQL Query #157

SELECT * FROM cache
 WHERE `cacheid` IN ('vBUserRep_2')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1713927719.9496
Time After: 1713927719.9499
Time Taken: 0.00024914741516113
Memory Before: 14680064
Memory After: 14680064
Memory Used: 0

SQL Query #158

SELECT user.userid, avatar.avatarid, avatar.avatarpath, user.avatarrevision,
					customavatar.dateline, customavatar.width, customavatar.height, customavatar.height_thumb, customavatar.width_thumb, customavatar.filename
			FROM user as user
				LEFT JOIN customavatar AS customavatar ON customavatar.userid = user.userid
				LEFT JOIN avatar AS avatar ON avatar.avatarid = user.avatarid
			WHERE user.userid IN (2)
/**fetchAvatarsForUsers**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	customavatar	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	avatar	const	PRIMARY	PRIMARY	2	const	0	Unique row not found

Time Before: 1713927719.9503
Time After: 1713927719.9504
Time Taken: 0.00014495849609375
Memory Before: 14680064
Memory After: 14680064
Memory Used: 0

SQL Query #159

SELECT * FROM searchlog
 WHERE `searchlogid` = 23994724 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	searchlog	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927719.9509
Time After: 1713927719.951
Time Taken: 0.00015902519226074
Memory Before: 14680064
Memory After: 14680064
Memory Used: 0

SQL Query #160

SELECT `username`,`userid` FROM user
 WHERE `userid` IN ('','','')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	user	range	PRIMARY	PRIMARY	4		1	Using where

Time Before: 1713927719.9513
Time After: 1713927719.9516
Time Taken: 0.00028896331787109
Memory Before: 14680064
Memory After: 14680064
Memory Used: 0

SQL Query #161

SELECT * FROM cache
 WHERE `cacheid` IN ('SrchResults02813646269')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE noticed after reading const tables

Time Before: 1713927719.9577
Time After: 1713927719.958
Time Taken: 0.00026106834411621
Memory Before: 14680064
Memory After: 14680064
Memory Used: 0

SQL Query #162

			SELECT node.nodeid, node.nodeid AS nodeid2
			FROM node as node
			
			JOIN closure AS closure  ON node.nodeid = closure.child  
				 LEFT JOIN node AS starter ON starter.nodeid = node.starter

			WHERE closure.parent = '77436' AND 
				node.nodeid <> closure.parent AND 
				closure.depth <= 1 AND 
				node.inlist = 1
AND (node.public_preview = 1 OR  ( ( (  (starter.parentid IN (1,100,104,114,119,124,485,16428,161826,205721,102,115,120,125,486,33796,161827,105,116,121,488,113,487,118,489,122,17827) ) AND node.showapproved > 0 AND node.viewperms > 1 AND node.showpublished > 0 ))
 OR starter.parentid = 10 AND node.userid IN (0) OR (node.starter = 0 AND node.nodeid IN (1,100,104,114,119,124,485,16428,161826,205721,102,115,120,125,486,33796,161827,105,116,121,488,113,487,118,489,122,17827))))

 
			ORDER BY node.created DESC,nodeid2 DESC
			
			
/**getSearchResults**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	closure	ref	closure_uniq,parent_2,child	closure_uniq	4	const	6	Using where; Using temporary; Using filesort
1	SIMPLE	node	eq_ref	PRIMARY,node_user,node_starter,node_ppreview,node_showapproved,nodeid,node_inlist,showpublished	PRIMARY	4	db00080272.closure.child	1	Using where
1	SIMPLE	starter	eq_ref	PRIMARY,nodeid	PRIMARY	4	db00080272.node.starter	1	Using where

Time Before: 1713927719.9585
Time After: 1713927719.9596
Time Taken: 0.0011129379272461
Memory Before: 14680064
Memory After: 14680064
Memory Used: 0

SQL Query #163

			REPLACE INTO searchlog
				(type,userid,ipaddress,searchhash,sortby,sortorder,searchtime,dateline,json,results,results_count)
			VALUES
				('0','0','18.222.125.171','d31a94b4306517a2b588bf60bbd00117','created','desc','0.0013020038604736','1713927719','{\"channel\":\"77436\",\"depth\":\"1\",\"nolimit\":1,\"disable_two_pass\":1}','77526,77461,77457,77444,77442','5')

Time Before: 1713927719.9597
Time After: 1713927719.9677
Time Taken: 0.0079410076141357
Memory Before: 14680064
Memory After: 14680064
Memory Used: 0

SQL Query #164

SELECT * FROM searchlog
 WHERE `searchlogid` = 23994725 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	searchlog	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927719.9678
Time After: 1713927719.9682
Time Taken: 0.00038790702819824
Memory Before: 14680064
Memory After: 14680064
Memory Used: 0

SQL Query #165

SELECT * FROM cache
 WHERE `cacheid` IN ('node_77526_lvl1data','node_77461_lvl1data','node_77457_lvl1data')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	range	PRIMARY	PRIMARY	66		3	Using where

Time Before: 1713927719.9684
Time After: 1713927719.9688
Time Taken: 0.00035595893859863
Memory Before: 14680064
Memory After: 14680064
Memory Used: 0

SQL Query #166

SELECT * FROM node
 WHERE `nodeid` IN (77526,77461,77457)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	node	range	PRIMARY,nodeid	nodeid	4		3	Using index condition

Time Before: 1713927719.9689
Time After: 1713927719.9693
Time Taken: 0.0004570484161377
Memory Before: 14680064
Memory After: 14680064
Memory Used: 0

SQL Query #167

SELECT * FROM routenew
 WHERE `routeid` IN (227)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	routenew	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927719.9694
Time After: 1713927719.9696
Time Taken: 0.00016403198242188
Memory Before: 14680064
Memory After: 14680064
Memory Used: 0

SQL Query #168

SELECT * FROM cache
 WHERE `cacheid` IN ('vBAtchmnts_77526','vBAtchmnts_77461','vBAtchmnts_77457')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	range	PRIMARY	PRIMARY	66		3	Using where

Time Before: 1713927719.9697
Time After: 1713927719.97
Time Taken: 0.00028777122497559
Memory Before: 14680064
Memory After: 14680064
Memory Used: 0

SQL Query #169

				(
					SELECT
						a.filedataid,
						n.nodeid, n.parentid, n.contenttypeid,
						a.visible, a.counter, a.posthash, a.filename, a.reportthreadid, a.settings,
						NULL AS height, NULL AS width, NULL AS style,
						a.caption,
						n.displayorder
					FROM node AS n USE INDEX (contenttypeid_parentid)
						JOIN attach AS a ON (a.nodeid = n.nodeid)
					WHERE n.contenttypeid = 15 AND n.parentid IN (77526,77461,77457)
				)
				UNION ALL
				(
					SELECT
						p.filedataid,
						n.nodeid, n.parentid, n.contenttypeid,
						NULL AS visible, NULL AS counter, NULL AS posthash, NULL AS filename, NULL AS reportthreadid, NULL AS settings,
						p.height, p.width, p.style,
						p.caption,
						n.displayorder
					FROM node AS n USE INDEX (contenttypeid_parentid)
						JOIN photo AS p ON (p.nodeid = n.nodeid)
					WHERE n.contenttypeid = 16 AND n.parentid IN (77526,77461,77457)
				)
			
/**fetchNodeAttachments**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	n	range	contenttypeid_parentid	contenttypeid_parentid	6		3	Using index condition
1	PRIMARY	a	eq_ref	PRIMARY	PRIMARY	4	db00080272.n.nodeid	1
2	UNION	n	range	contenttypeid_parentid	contenttypeid_parentid	6		3	Using index condition
2	UNION	p	eq_ref	PRIMARY	PRIMARY	4	db00080272.n.nodeid	1

Time Before: 1713927719.9701
Time After: 1713927719.9707
Time Taken: 0.00059986114501953
Memory Before: 14680064
Memory After: 14680064
Memory Used: 0

SQL Query #170

				SELECT cl.parent AS nodeid, count(a.nodeid) AS count
				FROM closure AS cl
				INNER JOIN attach AS a ON (a.nodeid = cl.child)
				WHERE cl.parent in (77526,77461,77457)
				GROUP BY cl.parent
			
/**getDescendantAttachCount**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cl	range	closure_uniq,parent_2,child	parent_2	4		3	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	db00080272.cl.child	1	Using index

Time Before: 1713927719.9707
Time After: 1713927719.9711
Time Taken: 0.00039815902709961
Memory Before: 14680064
Memory After: 14680064
Memory Used: 0

SQL Query #171

				SELECT cl.parent AS nodeid, count(child.nodeid) AS count
				FROM closure AS cl
				INNER JOIN node AS child USE INDEX (nodeid, node_ctypid_userid_dispo_idx) ON (child.nodeid = cl.child)
				WHERE cl.parent in (77526,77461,77457) AND child.contenttypeid = 16
				GROUP BY cl.parent
			
/**getDescendantPhotoCount**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cl	range	closure_uniq,parent_2,child	parent_2	4		3	Using where; Using index
1	SIMPLE	child	ref	node_ctypid_userid_dispo_idx,nodeid	nodeid	6	db00080272.cl.child,const	1	Using index

Time Before: 1713927719.9712
Time After: 1713927719.9716
Time Taken: 0.0003819465637207
Memory Before: 14680064
Memory After: 14680064
Memory Used: 0

SQL Query #172

SELECT * FROM closure
 WHERE `child` IN (77526,77461,77457) 
 ORDER BY `child` ASC, `depth` ASC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	closure	range	child	child	4		21	Using index condition

Time Before: 1713927719.9717
Time After: 1713927719.972
Time Taken: 0.0003359317779541
Memory Before: 14680064
Memory After: 14680064
Memory Used: 0

SQL Query #173

SELECT * FROM cache
 WHERE `cacheid` IN ('node_77526_lvl3data','node_77461_lvl3data','node_77457_lvl3data')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	range	PRIMARY	PRIMARY	66		3	Using where

Time Before: 1713927719.9722
Time After: 1713927719.9724
Time Taken: 0.00023102760314941
Memory Before: 14680064
Memory After: 14680064
Memory Used: 0

SQL Query #174

SELECT node.*,text.nodeid AS text_nodeid,text.previewtext,text.previewimage,text.previewvideo,text.imageheight,text.imagewidth,text.rawtext,text.moderated,text.pagetextimages,text.pagetext,text.htmlstate,text.allowsmilie,text.showsignature,text.attach,text.infraction,text.reportnodeid,text.sc_userids, icon.iconpath, ch.routeid AS channelroute, ch.title AS channeltitle, ch.nodeid AS channelid,
		 starter.routeid AS starterroute, starter.title AS startertitle, starter.authorname as starterauthorname, starter.prefixid as starterprefixid,
		 starter.userid as starteruserid, starter.lastcontentid as starterlastcontentid, starter.totalcount+1 as startertotalcount, starter.urlident AS starterurlident,
		 deleteuser.username AS deleteusername, lastauthor.username AS lastauthorname, editlog.reason AS edit_reason, editlog.userid AS edit_userid, editlog.username AS edit_username,
		 editlog.dateline AS edit_dateline, editlog.hashistory, starter.nodeoptions as starternodeoptions, ch.nodeoptions as channelnodeoptions
		 FROM node AS node
		 
			LEFT JOIN  text AS text
			ON text.nodeid = node.nodeid

		 LEFT JOIN editlog AS editlog ON (editlog.nodeid = node.nodeid)
		 LEFT JOIN node AS starter ON (starter.nodeid = node.starter)
		 LEFT JOIN node AS ch ON (ch.nodeid = starter.parentid)
		 LEFT JOIN user AS deleteuser ON (node.deleteuserid > 0 AND node.deleteuserid = deleteuser.userid)
		 LEFT JOIN user AS lastauthor ON (node.lastauthorid = lastauthor.userid)
		 LEFT JOIN icon AS icon ON (node.iconid = icon.iconid)
		
		 WHERE node.nodeid IN (77526,77461,77457)
/** getFullContent**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	node	range	PRIMARY,nodeid	nodeid	4		3	Using index condition
1	SIMPLE	text	eq_ref	PRIMARY	PRIMARY	4	db00080272.node.nodeid	1
1	SIMPLE	editlog	eq_ref	PRIMARY	PRIMARY	4	db00080272.node.nodeid	1
1	SIMPLE	starter	eq_ref	PRIMARY,nodeid	PRIMARY	4	db00080272.node.starter	1	Using where
1	SIMPLE	ch	eq_ref	PRIMARY,nodeid	PRIMARY	4	db00080272.starter.parentid	1	Using where
1	SIMPLE	deleteuser	eq_ref	PRIMARY	PRIMARY	4	db00080272.node.deleteuserid	1	Using where
1	SIMPLE	lastauthor	eq_ref	PRIMARY	PRIMARY	4	db00080272.node.lastauthorid	1
1	SIMPLE	icon	eq_ref	PRIMARY	PRIMARY	2	db00080272.node.iconid	1	Using where

Time Before: 1713927719.9725
Time After: 1713927719.9733
Time Taken: 0.00081300735473633
Memory Before: 14680064
Memory After: 14680064
Memory Used: 0

SQL Query #175

SELECT * FROM searchlog
 WHERE `searchlogid` = 23994725 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	searchlog	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927719.9751
Time After: 1713927719.9752
Time Taken: 0.00012397766113281
Memory Before: 16777216
Memory After: 16777216
Memory Used: 0

SQL Query #176

SELECT `username`,`userid` FROM user
 WHERE `userid` IN ('','','')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	user	range	PRIMARY	PRIMARY	4		1	Using where

Time Before: 1713927719.9754
Time After: 1713927719.9757
Time Taken: 0.00028800964355469
Memory Before: 16777216
Memory After: 16777216
Memory Used: 0

SQL Query #177

SELECT * FROM cache
 WHERE `cacheid` IN ('SrchResults03654908741')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE noticed after reading const tables

Time Before: 1713927719.9819
Time After: 1713927719.9821
Time Taken: 0.00026798248291016
Memory Before: 16777216
Memory After: 16777216
Memory Used: 0

SQL Query #178

			SELECT node.nodeid, node.nodeid AS nodeid2
			FROM node as node
			
			JOIN closure AS closure  ON node.nodeid = closure.child  
				 LEFT JOIN node AS starter ON starter.nodeid = node.starter

			WHERE closure.parent = '77440' AND 
				node.nodeid <> closure.parent AND 
				closure.depth <= 1 AND 
				node.inlist = 1
AND (node.public_preview = 1 OR  ( ( (  (starter.parentid IN (1,100,104,114,119,124,485,16428,161826,205721,102,115,120,125,486,33796,161827,105,116,121,488,113,487,118,489,122,17827) ) AND node.showapproved > 0 AND node.viewperms > 1 AND node.showpublished > 0 ))
 OR starter.parentid = 10 AND node.userid IN (0) OR (node.starter = 0 AND node.nodeid IN (1,100,104,114,119,124,485,16428,161826,205721,102,115,120,125,486,33796,161827,105,116,121,488,113,487,118,489,122,17827))))

 
			ORDER BY node.created DESC,nodeid2 DESC
			
			
/**getSearchResults**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	closure	ref	closure_uniq,parent_2,child	closure_uniq	4	const	9	Using where; Using temporary; Using filesort
1	SIMPLE	node	eq_ref	PRIMARY,node_user,node_starter,node_ppreview,node_showapproved,nodeid,node_inlist,showpublished	PRIMARY	4	db00080272.closure.child	1	Using where
1	SIMPLE	starter	eq_ref	PRIMARY,nodeid	PRIMARY	4	db00080272.node.starter	1	Using where

Time Before: 1713927719.9826
Time After: 1713927719.9838
Time Taken: 0.0011131763458252
Memory Before: 16777216
Memory After: 16777216
Memory Used: 0

SQL Query #179

			REPLACE INTO searchlog
				(type,userid,ipaddress,searchhash,sortby,sortorder,searchtime,dateline,json,results,results_count)
			VALUES
				('0','0','18.222.125.171','6ba128424789348e3a66dddf78037ebf','created','desc','0.0013329982757568','1713927719','{\"channel\":\"77440\",\"depth\":\"1\",\"nolimit\":1,\"disable_two_pass\":1}','77566,77561,77555,77536,77527,77525,77458,77443','8')

Time Before: 1713927719.9839
Time After: 1713927719.9927
Time Taken: 0.0088210105895996
Memory Before: 16777216
Memory After: 16777216
Memory Used: 0

SQL Query #180

SELECT * FROM searchlog
 WHERE `searchlogid` = 23994726 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	searchlog	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927719.9929
Time After: 1713927719.9932
Time Taken: 0.00039482116699219
Memory Before: 16777216
Memory After: 16777216
Memory Used: 0

SQL Query #181

SELECT * FROM cache
 WHERE `cacheid` IN ('node_77566_lvl1data','node_77561_lvl1data','node_77555_lvl1data')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	range	PRIMARY	PRIMARY	66		3	Using where

Time Before: 1713927719.9935
Time After: 1713927719.9938
Time Taken: 0.00035309791564941
Memory Before: 16777216
Memory After: 16777216
Memory Used: 0

SQL Query #182

SELECT * FROM node
 WHERE `nodeid` IN (77566,77561,77555)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	node	range	PRIMARY,nodeid	nodeid	4		3	Using index condition

Time Before: 1713927719.9939
Time After: 1713927719.9944
Time Taken: 0.00044894218444824
Memory Before: 16777216
Memory After: 16777216
Memory Used: 0

SQL Query #183

SELECT * FROM routenew
 WHERE `routeid` IN (227)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	routenew	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927719.9945
Time After: 1713927719.9947
Time Taken: 0.00017499923706055
Memory Before: 16777216
Memory After: 16777216
Memory Used: 0

SQL Query #184

SELECT * FROM cache
 WHERE `cacheid` IN ('vBAtchmnts_77566','vBAtchmnts_77561','vBAtchmnts_77555')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	range	PRIMARY	PRIMARY	66		3	Using where

Time Before: 1713927719.9947
Time After: 1713927719.995
Time Taken: 0.00028800964355469
Memory Before: 16777216
Memory After: 16777216
Memory Used: 0

SQL Query #185

				(
					SELECT
						a.filedataid,
						n.nodeid, n.parentid, n.contenttypeid,
						a.visible, a.counter, a.posthash, a.filename, a.reportthreadid, a.settings,
						NULL AS height, NULL AS width, NULL AS style,
						a.caption,
						n.displayorder
					FROM node AS n USE INDEX (contenttypeid_parentid)
						JOIN attach AS a ON (a.nodeid = n.nodeid)
					WHERE n.contenttypeid = 15 AND n.parentid IN (77566,77561,77555)
				)
				UNION ALL
				(
					SELECT
						p.filedataid,
						n.nodeid, n.parentid, n.contenttypeid,
						NULL AS visible, NULL AS counter, NULL AS posthash, NULL AS filename, NULL AS reportthreadid, NULL AS settings,
						p.height, p.width, p.style,
						p.caption,
						n.displayorder
					FROM node AS n USE INDEX (contenttypeid_parentid)
						JOIN photo AS p ON (p.nodeid = n.nodeid)
					WHERE n.contenttypeid = 16 AND n.parentid IN (77566,77561,77555)
				)
			
/**fetchNodeAttachments**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	n	range	contenttypeid_parentid	contenttypeid_parentid	6		3	Using index condition
1	PRIMARY	a	eq_ref	PRIMARY	PRIMARY	4	db00080272.n.nodeid	1
2	UNION	n	range	contenttypeid_parentid	contenttypeid_parentid	6		3	Using index condition
2	UNION	p	eq_ref	PRIMARY	PRIMARY	4	db00080272.n.nodeid	1

Time Before: 1713927719.9951
Time After: 1713927719.9957
Time Taken: 0.00057506561279297
Memory Before: 16777216
Memory After: 16777216
Memory Used: 0

SQL Query #186

				SELECT cl.parent AS nodeid, count(a.nodeid) AS count
				FROM closure AS cl
				INNER JOIN attach AS a ON (a.nodeid = cl.child)
				WHERE cl.parent in (77566,77561,77555)
				GROUP BY cl.parent
			
/**getDescendantAttachCount**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cl	range	closure_uniq,parent_2,child	parent_2	4		3	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	db00080272.cl.child	1	Using index

Time Before: 1713927719.9958
Time After: 1713927719.9962
Time Taken: 0.00041985511779785
Memory Before: 16777216
Memory After: 16777216
Memory Used: 0

SQL Query #187

				SELECT cl.parent AS nodeid, count(child.nodeid) AS count
				FROM closure AS cl
				INNER JOIN node AS child USE INDEX (nodeid, node_ctypid_userid_dispo_idx) ON (child.nodeid = cl.child)
				WHERE cl.parent in (77566,77561,77555) AND child.contenttypeid = 16
				GROUP BY cl.parent
			
/**getDescendantPhotoCount**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cl	range	closure_uniq,parent_2,child	parent_2	4		3	Using where; Using index
1	SIMPLE	child	ref	node_ctypid_userid_dispo_idx,nodeid	nodeid	6	db00080272.cl.child,const	1	Using index

Time Before: 1713927719.9963
Time After: 1713927719.9966
Time Taken: 0.00038504600524902
Memory Before: 16777216
Memory After: 16777216
Memory Used: 0

SQL Query #188

SELECT * FROM closure
 WHERE `child` IN (77566,77561,77555) 
 ORDER BY `child` ASC, `depth` ASC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	closure	range	child	child	4		21	Using index condition

Time Before: 1713927719.9967
Time After: 1713927719.9971
Time Taken: 0.00038385391235352
Memory Before: 16777216
Memory After: 16777216
Memory Used: 0

SQL Query #189

SELECT * FROM cache
 WHERE `cacheid` IN ('node_77566_lvl3data','node_77561_lvl3data','node_77555_lvl3data')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	range	PRIMARY	PRIMARY	66		3	Using where

Time Before: 1713927719.9972
Time After: 1713927719.9975
Time Taken: 0.00025606155395508
Memory Before: 16777216
Memory After: 16777216
Memory Used: 0

SQL Query #190

SELECT node.*,text.nodeid AS text_nodeid,text.previewtext,text.previewimage,text.previewvideo,text.imageheight,text.imagewidth,text.rawtext,text.moderated,text.pagetextimages,text.pagetext,text.htmlstate,text.allowsmilie,text.showsignature,text.attach,text.infraction,text.reportnodeid,text.sc_userids, icon.iconpath, ch.routeid AS channelroute, ch.title AS channeltitle, ch.nodeid AS channelid,
		 starter.routeid AS starterroute, starter.title AS startertitle, starter.authorname as starterauthorname, starter.prefixid as starterprefixid,
		 starter.userid as starteruserid, starter.lastcontentid as starterlastcontentid, starter.totalcount+1 as startertotalcount, starter.urlident AS starterurlident,
		 deleteuser.username AS deleteusername, lastauthor.username AS lastauthorname, editlog.reason AS edit_reason, editlog.userid AS edit_userid, editlog.username AS edit_username,
		 editlog.dateline AS edit_dateline, editlog.hashistory, starter.nodeoptions as starternodeoptions, ch.nodeoptions as channelnodeoptions
		 FROM node AS node
		 
			LEFT JOIN  text AS text
			ON text.nodeid = node.nodeid

		 LEFT JOIN editlog AS editlog ON (editlog.nodeid = node.nodeid)
		 LEFT JOIN node AS starter ON (starter.nodeid = node.starter)
		 LEFT JOIN node AS ch ON (ch.nodeid = starter.parentid)
		 LEFT JOIN user AS deleteuser ON (node.deleteuserid > 0 AND node.deleteuserid = deleteuser.userid)
		 LEFT JOIN user AS lastauthor ON (node.lastauthorid = lastauthor.userid)
		 LEFT JOIN icon AS icon ON (node.iconid = icon.iconid)
		
		 WHERE node.nodeid IN (77566,77561,77555)
/** getFullContent**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	node	range	PRIMARY,nodeid	nodeid	4		3	Using index condition
1	SIMPLE	text	eq_ref	PRIMARY	PRIMARY	4	db00080272.node.nodeid	1
1	SIMPLE	editlog	eq_ref	PRIMARY	PRIMARY	4	db00080272.node.nodeid	1
1	SIMPLE	starter	eq_ref	PRIMARY,nodeid	PRIMARY	4	db00080272.node.starter	1	Using where
1	SIMPLE	ch	eq_ref	PRIMARY,nodeid	PRIMARY	4	db00080272.starter.parentid	1	Using where
1	SIMPLE	deleteuser	eq_ref	PRIMARY	PRIMARY	4	db00080272.node.deleteuserid	1	Using where
1	SIMPLE	lastauthor	eq_ref	PRIMARY	PRIMARY	4	db00080272.node.lastauthorid	1
1	SIMPLE	icon	eq_ref	PRIMARY	PRIMARY	2	db00080272.node.iconid	1	Using where

Time Before: 1713927719.9976
Time After: 1713927719.9984
Time Taken: 0.00080704689025879
Memory Before: 16777216
Memory After: 16777216
Memory Used: 0

SQL Query #191

SELECT * FROM searchlog
 WHERE `searchlogid` = 23994726 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	searchlog	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927719.9997
Time After: 1713927719.9999
Time Taken: 0.00014781951904297
Memory Before: 16777216
Memory After: 16777216
Memory Used: 0

SQL Query #192

SELECT `username`,`userid` FROM user
 WHERE `userid` IN ('','','')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	user	range	PRIMARY	PRIMARY	4		1	Using where

Time Before: 1713927720.0001
Time After: 1713927720.0004
Time Taken: 0.00028896331787109
Memory Before: 16777216
Memory After: 16777216
Memory Used: 0

SQL Query #193

SELECT * FROM cache
 WHERE `cacheid` IN ('SrchResults0893758877')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE noticed after reading const tables

Time Before: 1713927720.0067
Time After: 1713927720.0069
Time Taken: 0.00026893615722656
Memory Before: 16777216
Memory After: 16777216
Memory Used: 0

SQL Query #194

			SELECT node.nodeid, node.nodeid AS nodeid2
			FROM node as node
			
			JOIN closure AS closure  ON node.nodeid = closure.child  
				 LEFT JOIN node AS starter ON starter.nodeid = node.starter

			WHERE closure.parent = '79612' AND 
				node.nodeid <> closure.parent AND 
				closure.depth <= 1 AND 
				node.inlist = 1
AND (node.public_preview = 1 OR  ( ( (  (starter.parentid IN (1,100,104,114,119,124,485,16428,161826,205721,102,115,120,125,486,33796,161827,105,116,121,488,113,487,118,489,122,17827) ) AND node.showapproved > 0 AND node.viewperms > 1 AND node.showpublished > 0 ))
 OR starter.parentid = 10 AND node.userid IN (0) OR (node.starter = 0 AND node.nodeid IN (1,100,104,114,119,124,485,16428,161826,205721,102,115,120,125,486,33796,161827,105,116,121,488,113,487,118,489,122,17827))))

 
			ORDER BY node.created DESC,nodeid2 DESC
			
			
/**getSearchResults**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	closure	ref	closure_uniq,parent_2,child	closure_uniq	4	const	6	Using where; Using temporary; Using filesort
1	SIMPLE	node	eq_ref	PRIMARY,node_user,node_starter,node_ppreview,node_showapproved,nodeid,node_inlist,showpublished	PRIMARY	4	db00080272.closure.child	1	Using where
1	SIMPLE	starter	eq_ref	PRIMARY,nodeid	PRIMARY	4	db00080272.node.starter	1	Using where

Time Before: 1713927720.0074
Time After: 1713927720.0085
Time Taken: 0.0010969638824463
Memory Before: 16777216
Memory After: 16777216
Memory Used: 0

SQL Query #195

			REPLACE INTO searchlog
				(type,userid,ipaddress,searchhash,sortby,sortorder,searchtime,dateline,json,results,results_count)
			VALUES
				('0','0','18.222.125.171','c079b2b3833ef98761fbdd613db9bc56','created','desc','0.0012900829315186','1713927719','{\"channel\":\"79612\",\"depth\":\"1\",\"nolimit\":1,\"disable_two_pass\":1}','79966,79955,79946,79619,79616','5')

Time Before: 1713927720.0086
Time After: 1713927720.0177
Time Taken: 0.009077787399292
Memory Before: 16777216
Memory After: 16777216
Memory Used: 0

SQL Query #196

SELECT * FROM searchlog
 WHERE `searchlogid` = 23994727 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	searchlog	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927720.0179
Time After: 1713927720.0182
Time Taken: 0.00039100646972656
Memory Before: 16777216
Memory After: 16777216
Memory Used: 0

SQL Query #197

SELECT * FROM cache
 WHERE `cacheid` IN ('node_79966_lvl1data','node_79955_lvl1data','node_79946_lvl1data')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	range	PRIMARY	PRIMARY	66		3	Using where

Time Before: 1713927720.0185
Time After: 1713927720.0188
Time Taken: 0.00035810470581055
Memory Before: 16777216
Memory After: 16777216
Memory Used: 0

SQL Query #198

SELECT * FROM node
 WHERE `nodeid` IN (79966,79955,79946)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	node	range	PRIMARY,nodeid	nodeid	4		3	Using index condition

Time Before: 1713927720.0189
Time After: 1713927720.0194
Time Taken: 0.00046491622924805
Memory Before: 16777216
Memory After: 16777216
Memory Used: 0

SQL Query #199

SELECT * FROM routenew
 WHERE `routeid` IN (227)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	routenew	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927720.0195
Time After: 1713927720.0197
Time Taken: 0.00016498565673828
Memory Before: 16777216
Memory After: 16777216
Memory Used: 0

SQL Query #200

SELECT * FROM cache
 WHERE `cacheid` IN ('vBAtchmnts_79966','vBAtchmnts_79955','vBAtchmnts_79946')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	range	PRIMARY	PRIMARY	66		3	Using where

Time Before: 1713927720.0197
Time After: 1713927720.02
Time Taken: 0.00028586387634277
Memory Before: 16777216
Memory After: 16777216
Memory Used: 0

SQL Query #201

				(
					SELECT
						a.filedataid,
						n.nodeid, n.parentid, n.contenttypeid,
						a.visible, a.counter, a.posthash, a.filename, a.reportthreadid, a.settings,
						NULL AS height, NULL AS width, NULL AS style,
						a.caption,
						n.displayorder
					FROM node AS n USE INDEX (contenttypeid_parentid)
						JOIN attach AS a ON (a.nodeid = n.nodeid)
					WHERE n.contenttypeid = 15 AND n.parentid IN (79966,79955,79946)
				)
				UNION ALL
				(
					SELECT
						p.filedataid,
						n.nodeid, n.parentid, n.contenttypeid,
						NULL AS visible, NULL AS counter, NULL AS posthash, NULL AS filename, NULL AS reportthreadid, NULL AS settings,
						p.height, p.width, p.style,
						p.caption,
						n.displayorder
					FROM node AS n USE INDEX (contenttypeid_parentid)
						JOIN photo AS p ON (p.nodeid = n.nodeid)
					WHERE n.contenttypeid = 16 AND n.parentid IN (79966,79955,79946)
				)
			
/**fetchNodeAttachments**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	n	range	contenttypeid_parentid	contenttypeid_parentid	6		3	Using index condition
1	PRIMARY	a	eq_ref	PRIMARY	PRIMARY	4	db00080272.n.nodeid	1
2	UNION	n	range	contenttypeid_parentid	contenttypeid_parentid	6		3	Using index condition
2	UNION	p	eq_ref	PRIMARY	PRIMARY	4	db00080272.n.nodeid	1

Time Before: 1713927720.0201
Time After: 1713927720.0207
Time Taken: 0.00057506561279297
Memory Before: 16777216
Memory After: 16777216
Memory Used: 0

SQL Query #202

				SELECT cl.parent AS nodeid, count(a.nodeid) AS count
				FROM closure AS cl
				INNER JOIN attach AS a ON (a.nodeid = cl.child)
				WHERE cl.parent in (79966,79955,79946)
				GROUP BY cl.parent
			
/**getDescendantAttachCount**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cl	range	closure_uniq,parent_2,child	parent_2	4		3	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	db00080272.cl.child	1	Using index

Time Before: 1713927720.0208
Time After: 1713927720.0211
Time Taken: 0.00036311149597168
Memory Before: 16777216
Memory After: 16777216
Memory Used: 0

SQL Query #203

				SELECT cl.parent AS nodeid, count(child.nodeid) AS count
				FROM closure AS cl
				INNER JOIN node AS child USE INDEX (nodeid, node_ctypid_userid_dispo_idx) ON (child.nodeid = cl.child)
				WHERE cl.parent in (79966,79955,79946) AND child.contenttypeid = 16
				GROUP BY cl.parent
			
/**getDescendantPhotoCount**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cl	range	closure_uniq,parent_2,child	parent_2	4		3	Using where; Using index
1	SIMPLE	child	ref	node_ctypid_userid_dispo_idx,nodeid	nodeid	6	db00080272.cl.child,const	1	Using index

Time Before: 1713927720.0212
Time After: 1713927720.0216
Time Taken: 0.0003809928894043
Memory Before: 16777216
Memory After: 16777216
Memory Used: 0

SQL Query #204

SELECT * FROM closure
 WHERE `child` IN (79966,79955,79946) 
 ORDER BY `child` ASC, `depth` ASC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	closure	range	child	child	4		21	Using index condition

Time Before: 1713927720.0217
Time After: 1713927720.0221
Time Taken: 0.00036907196044922
Memory Before: 16777216
Memory After: 16777216
Memory Used: 0

SQL Query #205

SELECT * FROM cache
 WHERE `cacheid` IN ('node_79966_lvl3data','node_79955_lvl3data','node_79946_lvl3data')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	range	PRIMARY	PRIMARY	66		3	Using where

Time Before: 1713927720.0222
Time After: 1713927720.0224
Time Taken: 0.00025200843811035
Memory Before: 16777216
Memory After: 16777216
Memory Used: 0

SQL Query #206

SELECT node.*,text.nodeid AS text_nodeid,text.previewtext,text.previewimage,text.previewvideo,text.imageheight,text.imagewidth,text.rawtext,text.moderated,text.pagetextimages,text.pagetext,text.htmlstate,text.allowsmilie,text.showsignature,text.attach,text.infraction,text.reportnodeid,text.sc_userids, icon.iconpath, ch.routeid AS channelroute, ch.title AS channeltitle, ch.nodeid AS channelid,
		 starter.routeid AS starterroute, starter.title AS startertitle, starter.authorname as starterauthorname, starter.prefixid as starterprefixid,
		 starter.userid as starteruserid, starter.lastcontentid as starterlastcontentid, starter.totalcount+1 as startertotalcount, starter.urlident AS starterurlident,
		 deleteuser.username AS deleteusername, lastauthor.username AS lastauthorname, editlog.reason AS edit_reason, editlog.userid AS edit_userid, editlog.username AS edit_username,
		 editlog.dateline AS edit_dateline, editlog.hashistory, starter.nodeoptions as starternodeoptions, ch.nodeoptions as channelnodeoptions
		 FROM node AS node
		 
			LEFT JOIN  text AS text
			ON text.nodeid = node.nodeid

		 LEFT JOIN editlog AS editlog ON (editlog.nodeid = node.nodeid)
		 LEFT JOIN node AS starter ON (starter.nodeid = node.starter)
		 LEFT JOIN node AS ch ON (ch.nodeid = starter.parentid)
		 LEFT JOIN user AS deleteuser ON (node.deleteuserid > 0 AND node.deleteuserid = deleteuser.userid)
		 LEFT JOIN user AS lastauthor ON (node.lastauthorid = lastauthor.userid)
		 LEFT JOIN icon AS icon ON (node.iconid = icon.iconid)
		
		 WHERE node.nodeid IN (79966,79955,79946)
/** getFullContent**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	node	range	PRIMARY,nodeid	nodeid	4		3	Using index condition
1	SIMPLE	text	eq_ref	PRIMARY	PRIMARY	4	db00080272.node.nodeid	1
1	SIMPLE	editlog	eq_ref	PRIMARY	PRIMARY	4	db00080272.node.nodeid	1
1	SIMPLE	starter	eq_ref	PRIMARY,nodeid	PRIMARY	4	db00080272.node.starter	1	Using where
1	SIMPLE	ch	eq_ref	PRIMARY,nodeid	PRIMARY	4	db00080272.starter.parentid	1	Using where
1	SIMPLE	deleteuser	eq_ref	PRIMARY	PRIMARY	4	db00080272.node.deleteuserid	1	Using where
1	SIMPLE	lastauthor	eq_ref	PRIMARY	PRIMARY	4	db00080272.node.lastauthorid	1
1	SIMPLE	icon	eq_ref	PRIMARY	PRIMARY	2	db00080272.node.iconid	1	Using where

Time Before: 1713927720.0226
Time After: 1713927720.0234
Time Taken: 0.00079798698425293
Memory Before: 16777216
Memory After: 16777216
Memory Used: 0

SQL Query #207

SELECT * FROM searchlog
 WHERE `searchlogid` = 23994727 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	searchlog	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927720.0253
Time After: 1713927720.0255
Time Taken: 0.00015902519226074
Memory Before: 18874368
Memory After: 18874368
Memory Used: 0

SQL Query #208

SELECT `username`,`userid` FROM user
 WHERE `userid` IN ('','','')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	user	range	PRIMARY	PRIMARY	4		1	Using where

Time Before: 1713927720.0257
Time After: 1713927720.0261
Time Taken: 0.00031113624572754
Memory Before: 18874368
Memory After: 18874368
Memory Used: 0

SQL Query #209

SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (629,1325,1329,1332,1311,621,623)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	range	PRIMARY	PRIMARY	4		7	Using where

Time Before: 1713927720.0319
Time After: 1713927720.032
Time Taken: 0.00017595291137695
Memory Before: 18874368
Memory After: 18874368
Memory Used: 0

SQL Query #210

SELECT `varname`,`languageid`,`text` FROM phrase
 WHERE `varname` IN ('','logo','powered_by_vbulletin_title','search','navbar_home','navbar_team','navbar_newtopics','navbar_todays_posts','navbar_member_list','navbar_calendar','home','login_or_sign_up','you_can_also_login_as','logging_in','username','password','remember_me','log_in','forgot_password','or_sign_up','search_in_titles_only','search_in_x_only','advanced_search','notice_1_html','announcement','no_announcement','collapse','expand','page_title','posts','latest_activity','filter','time','all_time','today','last_week','last_month','show','all','discussions_only','photos_only','videos_only','links_only','polls_only','events_only','filtered_by','clear_all','conversation_new_posts','page','of_pagination','previous_page','next_page','previous','next','prefix_Inspiration_title_rich','reputation14','join_date','x_is_online_now','like_lower','tags','none','sc_bookmark','guest_avatar','x_is_offline','comment','type_your_comment_here','post','cancel','see_previous_comments','x_comments_lower','see_next_comments','commented','editing_a_comment','guest','navbar_help','navbar_contact_us','navbar_privacy','go_to_top','powered_by_vbulletin','footer_current_time','working_ellipsis','yes','no','ok','facebook_language') AND `languageid` IN (2,0,-1)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	phrase	range	name_lang_type,languageid	name_lang_type	768		255	Using index condition

Time Before: 1713927720.0335
Time After: 1713927720.0383
Time Taken: 0.0048601627349854
Memory Before: 18874368
Memory After: 18874368
Memory Used: 0

SQL Query #211

SELECT * FROM routenew
 WHERE `routeid` IN ('pmchat','register','activateuser','help','contact-us','search','lostpw','227','profile')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	routenew	range	PRIMARY	PRIMARY	4		2	Using where

Time Before: 1713927720.0499
Time After: 1713927720.0502
Time Taken: 0.00032401084899902
Memory Before: 18874368
Memory After: 18874368
Memory Used: 0

SQL Query #212

SELECT * FROM page
 WHERE `pageid` = 433 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	page	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927720.0506
Time After: 1713927720.0508
Time Taken: 0.00014019012451172
Memory Before: 18874368
Memory After: 18874368
Memory Used: 0

SQL Query #213

SELECT `varname`,`languageid`,`text` FROM phrase
 WHERE `varname` IN ('page_pmchat_page_chat_573cba8f1d228390944371_title','page_pmchat_page_chat_573cba8f1d228390944371_metadesc') AND `languageid` IN (2,0,-1)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	phrase	range	name_lang_type,languageid	name_lang_type	768		6	Using index condition

Time Before: 1713927720.0508
Time After: 1713927720.051
Time Taken: 0.00013589859008789
Memory Before: 18874368
Memory After: 18874368
Memory Used: 0

SQL Query #214

SELECT * FROM cache
 WHERE `cacheid` IN ('vbnodetext76984_25_2:09f14d73cd828b8c283774e754116338','vbnodetext76993_25_2:09f14d73cd828b8c283774e754116338','vbnodetext77441_25_2:5c59d03846355cc52bc59508e3f5bc30','vbnodetext77455_25_2:5c59d03846355cc52bc59508e3f5bc30','vbnodetext77522_25_2:5c59d03846355cc52bc59508e3f5bc30','vbnodetext77068_25_2:09f14d73cd828b8c283774e754116338','vbnodetext77093_25_2:5c59d03846355cc52bc59508e3f5bc30','vbnodetext77102_25_2:5c59d03846355cc52bc59508e3f5bc30','vbnodetext77284_25_2:5c59d03846355cc52bc59508e3f5bc30','vbnodetext77436_25_2:09f14d73cd828b8c283774e754116338','vbnodetext77457_25_2:5c59d03846355cc52bc59508e3f5bc30','vbnodetext77461_25_2:5c59d03846355cc52bc59508e3f5bc30','vbnodetext77526_25_2:5c59d03846355cc52bc59508e3f5bc30','vbnodetext77440_25_2:09f14d73cd828b8c283774e754116338','vbnodetext77555_25_2:5c59d03846355cc52bc59508e3f5bc30','vbnodetext77561_25_2:5c59d03846355cc52bc59508e3f5bc30','vbnodetext77566_25_2:5c59d03846355cc52bc59508e3f5bc30','vbnodetext79612_25_2:09f14d73cd828b8c283774e754116338','vbnodetext79946_25_2:5c59d03846355cc52bc59508e3f5bc30','vbnodetext79955_25_2:5c59d03846355cc52bc59508e3f5bc30','vbnodetext79966_25_2:5c59d03846355cc52bc59508e3f5bc30')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	range	PRIMARY	PRIMARY	66		21	Using where

Time Before: 1713927720.055
Time After: 1713927720.0554
Time Taken: 0.00032997131347656
Memory Before: 18874368
Memory After: 18874368
Memory Used: 0

SQL Query #215

SELECT node.*, channel.nodeid AS channelid, channel.options, channel.guid,
				text.rawtext, text.htmlstate, text.previewtext
			FROM node AS node
			INNER JOIN node AS starter ON starter.nodeid = node.starter
			INNER JOIN channel AS channel ON channel.nodeid = starter.parentid
			INNER JOIN text AS text ON text.nodeid = node.nodeid
			WHERE node.nodeid IN (76984,76993,77441,77455,77522,77068,77093,77102,77284,77436,77457,77461,77526,77440,77555,77561,77566,79612,79946,79955,79966) 
/**getDataForParse**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	node	range	PRIMARY,node_starter,nodeid	nodeid	4		21	Using index condition
1	SIMPLE	text	eq_ref	PRIMARY	PRIMARY	4	db00080272.node.nodeid	1
1	SIMPLE	starter	eq_ref	PRIMARY,node_parent_lastcontent,node_parent_inlist_lastcontent,node_parent_userid,nodeid	PRIMARY	4	db00080272.node.starter	1	Using where
1	SIMPLE	channel	eq_ref	PRIMARY	PRIMARY	4	db00080272.starter.parentid	1	Using where

Time Before: 1713927720.0555
Time After: 1713927720.0561
Time Taken: 0.00067305564880371
Memory Before: 18874368
Memory After: 18874368
Memory Used: 0

SQL Query #216

SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (1210)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1713927720.0671
Time After: 1713927720.0672
Time Taken: 0.00011610984802246
Memory Before: 20971520
Memory After: 20971520
Memory Used: 0

SQL Query #35 Time Taken: 0.071589946746826 Memory Used: 0

UPDATE session SET `wol`='a:3:{s:6:\"action\";s:15:\"viewing_topic_x\";s:6:\"params\";a:2:{i:0;s:37:\"Freitagsinfusion #1 - Fantasiewörter\";i:1;s:129:\"https://wortkompass.de/forum/interne-schreibtreffs-und-übungen/fingerübungen/76984-freitagsinfusion-1-fantasiewörter?explain=1\";}s:6:\"nodeid\";s:5:\"76984\";}',`pagekey`='conversation227.212.116.76984',`location`='/forum/interne-schreibtreffs-und-übungen/fingerübungen/76984-freitagsinfusion-1-fantasiewörter?explain=1' 
 WHERE (`sessionhash` = '1537ea10079148efdafc9d46633e8324') 
/**session**/

SQL Query #195 Time Taken: 0.009077787399292 Memory Used: 0

			REPLACE INTO searchlog
				(type,userid,ipaddress,searchhash,sortby,sortorder,searchtime,dateline,json,results,results_count)
			VALUES
				('0','0','18.222.125.171','c079b2b3833ef98761fbdd613db9bc56','created','desc','0.0012900829315186','1713927719','{\"channel\":\"79612\",\"depth\":\"1\",\"nolimit\":1,\"disable_two_pass\":1}','79966,79955,79946,79619,79616','5')

SQL Query #83 Time Taken: 0.0090241432189941 Memory Used: 0

			REPLACE INTO searchlog
				(type,userid,ipaddress,searchhash,sortby,sortorder,searchtime,dateline,json,results,results_count)
			VALUES
				('0','0','18.222.125.171','22b0d4b97538055451e1db02424ea1ec','isstarter','desc','0.002190113067627','1713927719','{\"sort\":{\"created\":\"ASC\"},\"channel\":\"76984\",\"depth\":1,\"include_starter\":1,\"ignore_protected\":1,\"nolimit\":1}','76984,76993,77068,77436,77440,79612','6')

SQL Query #179 Time Taken: 0.0088210105895996 Memory Used: 0

			REPLACE INTO searchlog
				(type,userid,ipaddress,searchhash,sortby,sortorder,searchtime,dateline,json,results,results_count)
			VALUES
				('0','0','18.222.125.171','6ba128424789348e3a66dddf78037ebf','created','desc','0.0013329982757568','1713927719','{\"channel\":\"77440\",\"depth\":\"1\",\"nolimit\":1,\"disable_two_pass\":1}','77566,77561,77555,77536,77527,77525,77458,77443','8')

SQL Query #163 Time Taken: 0.0079410076141357 Memory Used: 0

			REPLACE INTO searchlog
				(type,userid,ipaddress,searchhash,sortby,sortorder,searchtime,dateline,json,results,results_count)
			VALUES
				('0','0','18.222.125.171','d31a94b4306517a2b588bf60bbd00117','created','desc','0.0013020038604736','1713927719','{\"channel\":\"77436\",\"depth\":\"1\",\"nolimit\":1,\"disable_two_pass\":1}','77526,77461,77457,77444,77442','5')