vBulletin - Explain SQL Queries (157)

SQL Query #1

SET @@sql_mode = ''
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(561)
#1 vB_Database->query_write('') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(529)
#2 vB_Database->force_sql_mode('') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/mysql/assertor.php(79)
#3 vB_dB_MYSQL_Assertor->load_database(array[len:4], array[len:8]) in phar:///home/alnadawi/public_html/vb/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 hmq_datastore
 WHERE `title` IN ('options','bitfields','attachmentcache','usergroupcache','stylecache','languagecache','products','cron','profilefield','loadcache','miscoptions','noticecache','hooks','publicoptions','prefixcache','vBUgChannelPermissionsFrom','vBChannelTypes','locations') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_datastore rangePRIMARYPRIMARY52 18100.00Using index condition
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:303]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('datastore', array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/datastore.php(602)
#7 vB_Datastore->do_db_fetch(array[len:18]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/datastore.php(556)
#8 vB_Datastore->fetch(array[len:18]) in phar:///home/alnadawi/public_html/vb/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 hmq_session
 WHERE `sessionhash` = 'a9b42c345d4e78608f1acc5c0aa01786'  AND `lastactivity` > 1764944915  
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_session constPRIMARY,last_activityPRIMARY34const1100.00 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:127]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('session', array[len:3], false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('session', array[len:3]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/session.php(279)
#8 vB_Session->fetchStoredSession('a9b42c345d[len:32]', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/session.php(132)
#9 vB_Session->loadExistingSession('a9b42c345d[len:32]', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/session.php(498)
#10 vB_Session->__construct(vB_dB_MYSQL_Assertor, vB_Datastore, array[len:7], 'a9b42c345d[len:32]', array[len:2], 0, 0) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/session/web.php(31)
#11 vB_Session_Web->__construct(vB_dB_MYSQL_Assertor, vB_Datastore, array[len:7], 'a9b42c345d[len:32]', array[len:2], 0, 0) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/session/webapi.php(72)
#12 vB_Session_WebApi->__construct(vB_dB_MYSQL_Assertor, vB_Datastore, array[len:7], 'a9b42c345d[len:32]', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/session/webapi.php(66)
#13 vB_Session_WebApi::createSessionNew('a9b42c345d[len:32]', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/request/webapi.php(54)
#14 vB_Request_WebApi->createSessionNew('a9b42c345d[len:32]', array[len:2]) in /includes/api/interfaceabstract.php(180)
#15 Api_InterfaceAbstract->createSession(vB_Request_WebApi, array[len:402]) in /includes/api/interface/collapsed.php(60)
#16 Api_Interface_Collapsed->init() in /includes/api/interfaceabstract.php(71)
#17 Api_InterfaceAbstract::instance() in /includes/vb5/frontend/routing.php(120)
#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 #4

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('13bd7d9a9062e9bc75fb938051d62b32') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_cache constPRIMARYPRIMARY66const1100.00 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:81]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/language.php(75)
#9 vB_Language::getPhraseCache('13bd7d9a90[len:32]') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/language.php(50)
#10 vB_Language::getPhraseInfo(5) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/session.php(835)
#11 vB_Session->loadLanguage() in phar:///home/alnadawi/public_html/vb/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:///home/alnadawi/public_html/vb/core/vb/vb.phar/request.php(173)
#14 vB_Request->setSession(vB_Session_WebApi) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/request/webapi.php(55)
#15 vB_Request_WebApi->createSessionNew('a9b42c345d[len:32]', array[len:2]) in /includes/api/interfaceabstract.php(180)
#16 Api_InterfaceAbstract->createSession(vB_Request_WebApi, array[len:402]) 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 hmq_cache
 WHERE `cacheid` IN ('vB_CommonRoutes') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_cache constPRIMARYPRIMARY66const1100.00 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:64]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in phar:///home/alnadawi/public_html/vb/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:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(87)
#10 vB_Api_Route->getRoute('forum/c1/z[len:162]', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/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 hmq_routenew AS routenew
				WHERE routenew.prefix IN ('forum/c1/z4/49710-حي-النداوي-والله-انه-يرحم-اللي-رجّعوه-عزالله-انّا-فاقـدينه-جعل-مانفقد-عـزيز/page3','forum/c1/z4/49710-حي-النداوي-والله-انه-يرحم-اللي-رجّعوه-عزالله-انّا-فاقـدينه-جعل-مانفقد-عـزيز','forum/c1/z4','forum/c1','forum') OR ishomeroute = 1
			
/**get_best_routes**/
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEroutenew index_mergeprefix,ishomerouteprefix,ishomeroute202,2 8100.00Using sort_union(prefix,ishomeroute); Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, '\n\t\t\t\tSELEC[len:489]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/stored.php(104)
#4 vB_dB_Query_Stored->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#5 vB_dB_Assertor->assertQuery('get_best_routes', array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(127)
#6 vB_Api_Route->getRoute('forum/c1/z[len:162]', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/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 hmq_cache
 WHERE `cacheid` IN ('vB_UserPerms0') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_cache constPRIMARYPRIMARY66const1100.00 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:62]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/usercontext.php(142)
#9 vB_UserContext->reloadUserPerms() in phar:///home/alnadawi/public_html/vb/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:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/user.php(32)
#12 vB_Library_User->isBanned('0') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/user.php(61)
#13 vB_Library_User->fetchBannedInfo('0') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(152)
#14 vB_Api_Route->getRoute('forum/c1/z[len:162]', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/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 hmq_cache
 WHERE `cacheid` IN ('vb_types.types') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_cache constPRIMARYPRIMARY66const1100.00 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:63]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:1], true, true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/types.php(183)
#9 vB_Types->loadTypes() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/types.php(151)
#10 vB_Types->__construct() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/types.php(167)
#11 vB_Types::instance() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/content.php(149)
#12 vB_Library_Content->__construct() in phar:///home/alnadawi/public_html/vb/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:10], 'explain=1&[len:21]', '') in /core/vb5/route.php(1168)
#15 vB5_Route::checkRoute(array[len:14], 'forum/c1/z[len:159]', 'forum/c1/z[len:162]', 'explain=1&[len:21]', '') in /core/vb5/route.php(1104)
#16 vB5_Route::selectBestRoute('forum/c1/z[len:162]', 'explain=1&[len:21]', '', array[len:6]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(159)
#17 vB_Api_Route->getRoute('forum/c1/z[len:162]', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/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 hmq_cache
 WHERE `cacheid` IN ('node_18_lvl3data') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_cache constPRIMARYPRIMARY66const1100.00 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:65]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/content.php(3855)
#9 vB_Library_Content::fetchFromCache(array[len:1], 3) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/content.php(2598)
#10 vB_Library_Content->getRawContent(array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/content.php(2540)
#11 vB_Library_Content->getBareContent(array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/content/channel.php(413)
#12 vB_Library_Content_Channel->getBareContent(18) in /core/vb5/route/conversation.php(29)
#13 vB5_Route_Conversation->__construct(array[len:14], array[len:10], 'explain=1&[len:21]', '') in /core/vb5/route.php(1168)
#14 vB5_Route::checkRoute(array[len:14], 'forum/c1/z[len:159]', 'forum/c1/z[len:162]', 'explain=1&[len:21]', '') in /core/vb5/route.php(1104)
#15 vB5_Route::selectBestRoute('forum/c1/z[len:162]', 'explain=1&[len:21]', '', array[len:6]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(159)
#16 vB_Api_Route->getRoute('forum/c1/z[len:162]', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/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 hmq_cache
 WHERE `cacheid` IN ('node_49710_lvl1data') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_cache constPRIMARYPRIMARY66const1100.00 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:68]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/content.php(3855)
#9 vB_Library_Content::fetchFromCache(array[len:1], 1) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/node.php(883)
#10 vB_Library_Node->getNodeBare('49710') in /core/vb5/route/conversation.php(83)
#11 vB5_Route_Conversation->__construct(array[len:14], array[len:10], 'explain=1&[len:21]', '') in /core/vb5/route.php(1168)
#12 vB5_Route::checkRoute(array[len:14], 'forum/c1/z[len:159]', 'forum/c1/z[len:162]', 'explain=1&[len:21]', '') in /core/vb5/route.php(1104)
#13 vB5_Route::selectBestRoute('forum/c1/z[len:162]', 'explain=1&[len:21]', '', array[len:6]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(159)
#14 vB_Api_Route->getRoute('forum/c1/z[len:162]', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/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 hmq_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') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_channel ALLguid   5225.00Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:522]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('vBForum:channel', array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/content/channel.php(957)
#7 vB_Library_Content_Channel->fetchChannelByGUID('vbulletin-[len:33]') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/content/channel.php(156)
#8 vB_Api_Content_Channel->fetchChannelByGUID('vbulletin-[len:33]') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/node.php(2188)
#9 vB_Library_Node->fetchAlbumChannel() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/node.php(1968)
#10 vB_Api_Node->fetchAlbumChannel('49710') in phar:///home/alnadawi/public_html/vb/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:10], 'explain=1&[len:21]', '') in /core/vb5/route.php(1168)
#13 vB5_Route::checkRoute(array[len:14], 'forum/c1/z[len:159]', 'forum/c1/z[len:162]', 'explain=1&[len:21]', '') in /core/vb5/route.php(1104)
#14 vB5_Route::selectBestRoute('forum/c1/z[len:162]', 'explain=1&[len:21]', '', array[len:6]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(159)
#15 vB_Api_Route->getRoute('forum/c1/z[len:162]', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/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 #12

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vB_NamedRoutes') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_cache constPRIMARYPRIMARY66const1100.00 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:63]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in phar:///home/alnadawi/public_html/vb/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('66') in /core/vb5/route.php(1335)
#11 vB5_Route::getClassName('66', 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(18, array[len:10]) 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:10], 'explain=1&[len:21]', '') in /core/vb5/route.php(1168)
#17 vB5_Route::checkRoute(array[len:14], 'forum/c1/z[len:159]', 'forum/c1/z[len:162]', 'explain=1&[len:21]', '') in /core/vb5/route.php(1104)
#18 vB5_Route::selectBestRoute('forum/c1/z[len:162]', 'explain=1&[len:21]', '', array[len:6]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(159)
#19 vB_Api_Route->getRoute('forum/c1/z[len:162]', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/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 #13

SELECT * FROM hmq_routenew
 WHERE `routeid` = 66 
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_routenew constPRIMARYPRIMARY4const1100.00 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:58]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('routenew', array[len:2], false) in phar:///home/alnadawi/public_html/vb/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('66') in /core/vb5/route.php(1335)
#9 vB5_Route::getClassName('66', 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(18, array[len:10]) 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:10], 'explain=1&[len:21]', '') in /core/vb5/route.php(1168)
#15 vB5_Route::checkRoute(array[len:14], 'forum/c1/z[len:159]', 'forum/c1/z[len:162]', 'explain=1&[len:21]', '') in /core/vb5/route.php(1104)
#16 vB5_Route::selectBestRoute('forum/c1/z[len:162]', 'explain=1&[len:21]', '', array[len:6]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(159)
#17 vB_Api_Route->getRoute('forum/c1/z[len:162]', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/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 #14

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('node_18_lvl1data') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_cache constPRIMARYPRIMARY66const1100.00 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:65]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/content.php(3855)
#9 vB_Library_Content::fetchFromCache(array[len:1], 1) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/node.php(883)
#10 vB_Library_Node->getNodeBare(18) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/node.php(967)
#11 vB_Library_Node->getNode(18) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/usercontext.php(535)
#12 vB_UserContext->getChannelLimitPermission('forumpermissions', 'canview', 18, false, false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/usercontext.php(823)
#13 vB_UserContext->getChannelPermission('forumpermissions', 'canview', 18) 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(18, array[len:10]) 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:10], 'explain=1&[len:21]', '') in /core/vb5/route.php(1168)
#20 vB5_Route::checkRoute(array[len:14], 'forum/c1/z[len:159]', 'forum/c1/z[len:162]', 'explain=1&[len:21]', '') in /core/vb5/route.php(1104)
#21 vB5_Route::selectBestRoute('forum/c1/z[len:162]', 'explain=1&[len:21]', '', array[len:6]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(159)
#22 vB_Api_Route->getRoute('forum/c1/z[len:162]', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/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 #15

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('channelperms_1') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_cache constPRIMARYPRIMARY66const1100.00 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:63]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:1], true, false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/permissioncontext.php(872)
#9 vB_PermissionContext->loadChannelPermissions(1) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/permissioncontext.php(761)
#10 vB_PermissionContext->getChannelPerm(1, 'forumpermissions', 'canview', 18) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/usercontext.php(609)
#11 vB_UserContext->getChannelLimitPermission('forumpermissions', 'canview', 18, false, false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/usercontext.php(823)
#12 vB_UserContext->getChannelPermission('forumpermissions', 'canview', 18) 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(18, array[len:10]) 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:10], 'explain=1&[len:21]', '') in /core/vb5/route.php(1168)
#19 vB5_Route::checkRoute(array[len:14], 'forum/c1/z[len:159]', 'forum/c1/z[len:162]', 'explain=1&[len:21]', '') in /core/vb5/route.php(1104)
#20 vB5_Route::selectBestRoute('forum/c1/z[len:162]', 'explain=1&[len:21]', '', array[len:6]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(159)
#21 vB_Api_Route->getRoute('forum/c1/z[len:162]', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/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 #16

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('node_1_lvl1data') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_cache constPRIMARYPRIMARY66const1100.00 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:64]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/content.php(3855)
#9 vB_Library_Content::fetchFromCache(array[len:1], 1) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/node.php(883)
#10 vB_Library_Node->getNodeBare('1') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/node.php(967)
#11 vB_Library_Node->getNode('1') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/usercontext.php(535)
#12 vB_UserContext->getChannelLimitPermission('forumpermissions', 'canview', '1', false, false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/usercontext.php(823)
#13 vB_UserContext->getChannelPermission('forumpermissions', 'canview', '1') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(215)
#14 vB_Api_Route->getRoute('forum/c1/z[len:162]', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/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 #17

SELECT * FROM hmq_routenew
 WHERE `routeid` = 67 
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_routenew constPRIMARYPRIMARY4const1100.00 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:58]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('routenew', array[len:2], false) in phar:///home/alnadawi/public_html/vb/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('67') in /core/vb5/route.php(1335)
#9 vB5_Route::getClassName('67', array[len:14]) in /core/vb5/route.php(1350)
#10 vB5_Route::getRoute('67', array[len:3], array[len:2], '') in /core/vb5/route/conversation.php(610)
#11 vB5_Route_Conversation->getCanonicalRoute() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(252)
#12 vB_Api_Route->getRoute('forum/c1/z[len:162]', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/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 #18

SELECT * FROM hmq_closure
 WHERE `child` IN (18) 
 ORDER BY `child` ASC, `depth` ASC
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_closure refchildchild4const4100.00Using index condition
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:84]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('vBForum:closure', array[len:2], array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/node.php(3534)
#7 vB_Library_Node->fetchClosureParent(array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/node.php(997)
#8 vB_Library_Node->getNodeParents(18) in /core/vb5/route.php(360)
#9 vB5_Route->addParentNodeBreadcrumbs(18) in /core/vb5/route.php(342)
#10 vB5_Route->setBreadcrumbs() in /core/vb5/route.php(418)
#11 vB5_Route->getBreadcrumbs() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(315)
#12 vB_Api_Route->getRoute('forum/c1/z[len:162]', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/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 hmq_cache
 WHERE `cacheid` IN ('node_2_lvl1data','node_14_lvl1data') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_cache rangePRIMARYPRIMARY66 2100.00Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:83]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:2], false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:4]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/content.php(3855)
#9 vB_Library_Content::fetchFromCache(array[len:4], 1) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/node.php(1034)
#10 vB_Library_Node->getNodes(array[len:4]) in /core/vb5/route.php(362)
#11 vB5_Route->addParentNodeBreadcrumbs(18) in /core/vb5/route.php(342)
#12 vB5_Route->setBreadcrumbs() in /core/vb5/route.php(418)
#13 vB5_Route->getBreadcrumbs() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(315)
#14 vB_Api_Route->getRoute('forum/c1/z[len:162]', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/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 #20

SELECT * FROM hmq_routenew
 WHERE `routeid` IN (45,58,66) 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_routenew rangePRIMARYPRIMARY4 3100.00Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:58]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/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(18) in /core/vb5/route.php(342)
#9 vB5_Route->setBreadcrumbs() in /core/vb5/route.php(418)
#10 vB5_Route->getBreadcrumbs() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(315)
#11 vB_Api_Route->getRoute('forum/c1/z[len:162]', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/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 #21

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('node_2_lvl3data') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_cache constPRIMARYPRIMARY66const1100.00 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:64]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/content.php(3855)
#9 vB_Library_Content::fetchFromCache(array[len:1], 3) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/content.php(2598)
#10 vB_Library_Content->getRawContent(array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/content.php(2540)
#11 vB_Library_Content->getBareContent(array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/content/channel.php(413)
#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(18) in /core/vb5/route.php(342)
#16 vB5_Route->setBreadcrumbs() in /core/vb5/route.php(418)
#17 vB5_Route->getBreadcrumbs() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(315)
#18 vB_Api_Route->getRoute('forum/c1/z[len:162]', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/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 #22

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('node_14_lvl3data') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_cache constPRIMARYPRIMARY66const1100.00 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:65]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/content.php(3855)
#9 vB_Library_Content::fetchFromCache(array[len:1], 3) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/content.php(2598)
#10 vB_Library_Content->getRawContent(array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/content.php(2540)
#11 vB_Library_Content->getBareContent(array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/content/channel.php(413)
#12 vB_Library_Content_Channel->getBareContent(14) 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(18) in /core/vb5/route.php(342)
#16 vB5_Route->setBreadcrumbs() in /core/vb5/route.php(418)
#17 vB5_Route->getBreadcrumbs() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(315)
#18 vB_Api_Route->getRoute('forum/c1/z[len:162]', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/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 `styleid` FROM hmq_channel
 WHERE `styleid` IN (2,35,39,40,4,36,6,37,8,38,12,41,14,42,16,43,18,44,20,45,22,46,24,25,26,47,28,48,30,49,32,50,34,51) 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_channel ALL    5250.00Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT `st[len:154]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('vBForum:channel', array[len:2], false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(685)
#7 vB_dB_Assertor->getColumn('vBForum:channel', 'styleid', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/style.php(302)
#8 vB_Library_Style->loadForcedStyles() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/style.php(267)
#9 vB_Library_Style->getValidStyleFromPreference(array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/style.php(45)
#10 vB_Api_Style->getValidStyleFromPreference(array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#11 vB_Api_Wrapper->__call('getValidSt[len:27]', array[len:1]) in /includes/api/interface/collapsed.php(105)
#12 Api_Interface_Collapsed->callApi('style', 'getValidSt[len:27]', array[len:1]) in /includes/vb5/template/stylevar.php(108)
#13 vB5_Template_Stylevar->getStylePreference() in /includes/vb5/template/stylevar.php(37)
#14 vB5_Template_Stylevar->__construct() in /includes/vb5/template/stylevar.php(29)
#15 vB5_Template_Stylevar::instance() in /includes/vb5/frontend/application.php(22)
#16 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #24

SELECT * FROM hmq_style
 WHERE `styleid` = 14 
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_style constPRIMARYPRIMARY2const1100.00 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:55]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('style', array[len:2], false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('style', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/style.php(700)
#8 vB_Library_Style->fetchStyleByID(14) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/style.php(59)
#9 vB_Api_Style->fetchStyleVars(array[len:1]) in phar:///home/alnadawi/public_html/vb/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 hmq_template
 WHERE `templateid` IN (10763) 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_template constPRIMARYPRIMARY4const1100.00 

				

SQL Query #26

SELECT * FROM hmq_page
 WHERE `pageid` = 3 
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_page constPRIMARYPRIMARY4const1100.00 

				

SQL Query #27

SELECT `varname`,`languageid`,`text` FROM hmq_phrase
 WHERE `varname` IN ('page_4ecbdac82f039695291105_title','page_4ecbdac82f039695291105_metadesc') AND `languageid` IN (5,0,-1) 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_phrase rangename_lang_type,languageidname_lang_type195 6100.00Using index condition

				

SQL Query #28

SELECT * FROM hmq_page
 WHERE `pageid` = 23 
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_page constPRIMARYPRIMARY4const1100.00 

				

SQL Query #29

SELECT `varname`,`languageid`,`text` FROM hmq_phrase
 WHERE `varname` IN ('page_4ecbdac82f2c2760323374_title','page_4ecbdac82f2c2760323374_metadesc') AND `languageid` IN (5,0,-1) 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_phrase rangename_lang_type,languageidname_lang_type195 6100.00Using index condition

				

SQL Query #30

SELECT * FROM hmq_page
 WHERE `pageid` = 6 
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_page constPRIMARYPRIMARY4const1100.00 

				

SQL Query #31

SELECT `varname`,`languageid`,`text` FROM hmq_phrase
 WHERE `varname` IN ('page_4ecbdac82f039695291108_title','page_4ecbdac82f039695291108_metadesc') AND `languageid` IN (5,0,-1) 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_phrase rangename_lang_type,languageidname_lang_type195 6100.00Using index condition

				

SQL Query #32

SELECT * FROM hmq_page
 WHERE `pageid` = 5 
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_page constPRIMARYPRIMARY4const1100.00 

				

SQL Query #33

SELECT `varname`,`languageid`,`text` FROM hmq_phrase
 WHERE `varname` IN ('page_4ecbdac82f039695291107_title','page_4ecbdac82f039695291107_metadesc') AND `languageid` IN (5,0,-1) 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_phrase rangename_lang_type,languageidname_lang_type195 6100.00Using index condition

				

SQL Query #34

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vbPre_conversation67.51.18.49710') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLE         no matching row in const table

				

SQL Query #35


					
					
					

				

SQL Query #36

				SELECT page.*, pagetemplate.screenlayoutid, screenlayout.template AS screenlayouttemplate, pagetemplate.title AS templatetitle
				FROM hmq_page AS page
				LEFT JOIN hmq_pagetemplate AS pagetemplate ON(page.pagetemplateid = pagetemplate.pagetemplateid)
				LEFT JOIN hmq_screenlayout AS screenlayout ON(pagetemplate.screenlayoutid = screenlayout.screenlayoutid)
				WHERE page.pageid = 51
			
/**fetch_page_pagetemplate_screenlayout**/
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEpage constPRIMARYPRIMARY4const1100.00 
1SIMPLEpagetemplate constPRIMARYPRIMARY4const1100.00 
1SIMPLEscreenlayout constPRIMARYPRIMARY4const1100.00 

				

SQL Query #37

SELECT `varname`,`languageid`,`text` FROM hmq_phrase
 WHERE `varname` IN ('page_54c8a2f356da2666710783_title','page_54c8a2f356da2666710783_metadesc') AND `languageid` IN (5,0,-1) 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_phrase rangename_lang_type,languageidname_lang_type195 6100.00Using index condition

				

SQL Query #38

SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
 WHERE `templateid` IN (10582) 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_template constPRIMARYPRIMARY4const1100.00 

				

SQL Query #39

SELECT * FROM hmq_widgetinstance
 WHERE `pagetemplateid` IN (4,-1) 
 ORDER BY `containerinstanceid`,`displaysection`,`displayorder`
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_widgetinstance rangepagetemplateidpagetemplateid4 4100.00Using index condition; Using filesort

				

SQL Query #40

				SELECT widgetdefinition.*, widget.template
				FROM hmq_widgetdefinition AS widgetdefinition
				JOIN hmq_widget AS widget ON (widgetdefinition.widgetid = widget.widgetid)
				WHERE widgetdefinition.widgetid IN(190,213,236)
			
/**getWidgetdefinition**/
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEwidget rangePRIMARYPRIMARY4 3100.00Using where
1SIMPLEwidgetdefinition refwidgetidwidgetid4alnadawi_vb.widget.widgetid6100.00 

				

SQL Query #41

SELECT * FROM hmq_widgetinstance
 WHERE `widgetinstanceid` IN (20,18,19) 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_widgetinstance rangePRIMARYPRIMARY4 3100.00Using where

				

SQL Query #42

SELECT * FROM hmq_widget
 WHERE `widgetid` IN (0,190,213,236) 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_widget rangePRIMARYPRIMARY4 4100.00Using where

				

SQL Query #43

SELECT COUNT(*) AS count FROM hmq_moderator
 WHERE `userid` = 0 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_moderator refuserid_nodeiduserid_nodeid4const1100.00Using index

				

SQL Query #44

SELECT * FROM hmq_datastore
 WHERE `title` IN ('vBUgChannelAccessG1') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_datastore constPRIMARYPRIMARY52const1100.00 

				

SQL Query #45

SELECT * FROM hmq_widgetchannelconfig
 WHERE `widgetinstanceid` = 20 AND `nodeid` = 18 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLE         no matching row in const table

				

SQL Query #46

SELECT * FROM hmq_widgetchannelconfig
 WHERE `widgetinstanceid` = 18 AND `nodeid` = 18 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLE         no matching row in const table

				

SQL Query #47

SELECT * FROM hmq_widgetchannelconfig
 WHERE `widgetinstanceid` = 19 AND `nodeid` = 18 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLE         no matching row in const table

				

SQL Query #48

SELECT `varname`,`languageid`,`text` FROM hmq_phrase
 WHERE `varname` IN ('widget_conversationdisplay_widgettitle','system_widgetcat','widget_announcement_widgettitle','display_widgetcat','widget_pagetitle_widgettitle') AND `languageid` IN (5,0,-1) 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_phrase rangename_lang_type,languageidname_lang_type195 15100.00Using index condition

				

SQL Query #49

SELECT * FROM hmq_pagetemplate
 WHERE `pagetemplateid` = 4 
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_pagetemplate constPRIMARYPRIMARY4const1100.00 

				

SQL Query #50

SELECT * FROM hmq_screenlayout
 WHERE `screenlayoutid` = 1 
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_screenlayout constPRIMARYPRIMARY4const1100.00 

				

SQL Query #51

SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
 WHERE `templateid` IN (10738,10592,10751) 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_template rangePRIMARYPRIMARY4 3100.00Using index condition

				

SQL Query #52

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('node_49710_lvl3data') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_cache constPRIMARYPRIMARY66const1100.00 

				

SQL Query #53

SELECT * FROM hmq_closure
 WHERE `child` IN (49710) 
 ORDER BY `child` ASC, `depth` ASC
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_closure refchildchild4const5100.00Using index condition

				

SQL Query #54

SELECT `varname`,`languageid`,`text` FROM hmq_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 (5,0,-1) 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_phrase rangename_lang_type,languageidname_lang_type195 51100.00Using index condition

				

SQL Query #55

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vb_UserWPerms_1191_5') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLE         no matching row in const table

				

SQL Query #56

				SELECT 
					userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
					IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
				FROM hmq_user AS user
				LEFT JOIN hmq_userfield AS userfield ON (user.userid = userfield.userid)
				LEFT JOIN hmq_usertextfield AS usertextfield ON (usertextfield.userid = user.userid) 
					WHERE user.userid IN (1191)
					/** fetchUserinfo **/
			
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEuser constPRIMARYPRIMARY4const1100.00 
1SIMPLEuserfield constPRIMARYPRIMARY4const1100.00 
1SIMPLEusertextfield constPRIMARYPRIMARY4const1100.00 

				

SQL Query #57

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vB_UserPerms1191') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_cache constPRIMARYPRIMARY66const1100.00 

				

SQL Query #58

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vBUserRep_1191') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_cache constPRIMARYPRIMARY66const1100.00 

				

SQL Query #59

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vBAtchmnts_49710') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_cache constPRIMARYPRIMARY66const1100.00 

				

SQL Query #60

SELECT user.userid, avatar.avatarid, avatar.avatarpath, user.avatarrevision,
					customavatar.dateline, customavatar.width, customavatar.height, customavatar.height_thumb, customavatar.width_thumb, customavatar.filename
			FROM hmq_user as user
				LEFT JOIN hmq_customavatar AS customavatar ON customavatar.userid = user.userid
				LEFT JOIN hmq_avatar AS avatar ON avatar.avatarid = user.avatarid
			WHERE user.userid IN (1191,1761)
/**fetchAvatarsForUsers**/
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEavatar systemPRIMARY   00.00const row not found
1SIMPLEuser rangePRIMARYPRIMARY4 2100.00Using index condition
1SIMPLEcustomavatar eq_refPRIMARYPRIMARY4alnadawi_vb.user.userid1100.00 

				

SQL Query #61

SELECT * FROM hmq_site
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_site ALL    1100.00 

				

SQL Query #62

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vBAtchmnts_18') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_cache constPRIMARYPRIMARY66const1100.00 

				

SQL Query #63

SELECT user.userid, avatar.avatarid, avatar.avatarpath, user.avatarrevision,
					customavatar.dateline, customavatar.width, customavatar.height, customavatar.height_thumb, customavatar.width_thumb, customavatar.filename
			FROM hmq_user as user
				LEFT JOIN hmq_customavatar AS customavatar ON customavatar.userid = user.userid
				LEFT JOIN hmq_avatar AS avatar ON avatar.avatarid = user.avatarid
			WHERE user.userid IN (1,1315)
/**fetchAvatarsForUsers**/
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEavatar systemPRIMARY   00.00const row not found
1SIMPLEuser rangePRIMARYPRIMARY4 2100.00Using index condition
1SIMPLEcustomavatar eq_refPRIMARYPRIMARY4alnadawi_vb.user.userid1100.00 

				

SQL Query #64

SELECT * FROM hmq_channel
 WHERE `guid` IN ('vbulletin-4ecbdf567f2c35.70389590','vbulletin-4ecbdf567f3a38.99555305','vbulletin-4ecbdf567f3a38.99555306','vbulletin-c-cmshome5229fa38b251e2.92227401','vbulletin-4ecbdf567f3341.44451100') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_channel rangeguidguid151 5100.00Using index condition

				

SQL Query #65

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('node_1_lvl3data') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_cache constPRIMARYPRIMARY66const1100.00 

				

SQL Query #66

SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
 WHERE `templateid` IN (10759,10634,10635,10597,10761) 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_template rangePRIMARYPRIMARY4 5100.00Using index condition

				

SQL Query #67

SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
 WHERE `templateid` IN (10480) 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_template constPRIMARYPRIMARY4const1100.00 

				

SQL Query #68

SELECT `noticeid` FROM hmq_noticedismissed
 WHERE `userid` = 0 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLE         no matching row in const table

				

SQL Query #69

SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
 WHERE `templateid` IN (10594) 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_template constPRIMARYPRIMARY4const1100.00 

				

SQL Query #70

SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
 WHERE `templateid` IN (10595) 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_template constPRIMARYPRIMARY4const1100.00 

				

SQL Query #71

SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
 WHERE `templateid` IN (10660,10698) 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_template rangePRIMARYPRIMARY4 2100.00Using index condition

				

SQL Query #72

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vB_Announcements_18') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_cache constPRIMARYPRIMARY66const1100.00 

				

SQL Query #73

SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
 WHERE `templateid` IN (10739) 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_template constPRIMARYPRIMARY4const1100.00 

				

SQL Query #74

SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
 WHERE `templateid` IN (10683) 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_template constPRIMARYPRIMARY4const1100.00 

				

SQL Query #75

SELECT * FROM hmq_searchlog
 WHERE `searchhash` IN ('d2f7a93b1726934ddda7dbda365e613a') AND `userid` = 0  AND `dateline` >= 1765044855  AND `sortby` = 'isstarter'  AND `sortorder` = 'desc'  
 ORDER BY `dateline` DESC
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_searchlog refsearch,userfloodcheck,datelinesearch56const,const,const,const114.10Using index condition; Using where; Using filesort

				

SQL Query #76

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vb_readperms') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_cache constPRIMARYPRIMARY66const1100.00 

				

SQL Query #77

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('getSearchResults_d33f77f2afd8a920bde8c9e69aa7745d') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLE         no matching row in const table

				

SQL Query #78

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

			WHERE closure.parent = '49710' AND 
				closure.depth <= 1 AND 
				node.inlist = 1 AND 
				node.protected <> '1'
AND (node.public_preview = 1 OR  ( ( (  (starter.parentid IN (26,35,1,2,13,14,27,29,33,37,39,40,43,45,46,48,49,1441914,3,17,18,19,30,36,42,9,15,23,24,6,22,28,47,25,12,31) ) AND node.showapproved > 0 AND node.viewperms > 1 AND node.showpublished > 0 ))
 OR starter.parentid = 9 AND node.userid IN (0) OR (node.starter = 0 AND node.nodeid IN (26,35,1,2,13,14,27,29,33,37,39,40,43,45,46,48,49,1441914,3,17,18,19,30,36,42,9,15,23,24,6,22,28,47,25,12,31))))

 
			ORDER BY isstarter DESC,node.created ASC,nodeid2 ASC
			
			
/**getSearchResults**/
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEclosure refclosure_uniq,parent_2,childclosure_uniq4const5633.33Using where; Using temporary; Using filesort
1SIMPLEnode eq_refPRIMARY,node_user,node_starter,node_ppreview,node_showapproved,nodeid,ppreview,node_inlist,showpublishedPRIMARY4alnadawi_vb.closure.child145.00Using where
1SIMPLEstarter eq_refPRIMARY,nodeidPRIMARY4alnadawi_vb.node.starter1100.00Using where

				

SQL Query #79

			REPLACE INTO hmq_searchlog
				(type,userid,ipaddress,searchhash,sortby,sortorder,searchtime,dateline,json,results,results_count)
			VALUES
				('0','0','216.73.216.219','d2f7a93b1726934ddda7dbda365e613a','isstarter','desc','0.0052571296691895','1765044915','{\"sort\":{\"created\":\"ASC\"},\"channel\":\"49710\",\"depth\":1,\"include_starter\":1,\"ignore_protected\":1,\"nolimit\":1}','49710,1328920,1328925,1328956,1328962,1328971,1329029,1329037,1329094,1329096,1329097,1329103,1329105,1329108,1329109,1329112,1329113,1329115,1329118,1329119,1329146,1329148,1329157,1329158,1329161,1329167,1329169,1329173,1329184,1329197,1329198,1329224,1329233,1329274,1329275,1329277,1329279,1329343,1329363,1329365,1329367,1329392,1329394,1329413,1329444,1329465,1329466,1329469,1329470,1329475,1329476,1329551,1329560,1329561,1329690,1334005','56')
		

				

SQL Query #80

SELECT * FROM hmq_searchlog
 WHERE `searchlogid` = 97347130 
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_searchlog constPRIMARYPRIMARY4const1100.00 

				

SQL Query #81

SELECT * FROM hmq_page
 WHERE `pageid` = 12 
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_page constPRIMARYPRIMARY4const1100.00 

				

SQL Query #82

SELECT `varname`,`languageid`,`text` FROM hmq_phrase
 WHERE `varname` IN ('page_4ecbdac82f281504471586_title','page_4ecbdac82f281504471586_metadesc') AND `languageid` IN (5,0,-1) 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_phrase rangename_lang_type,languageidname_lang_type195 6100.00Using index condition

				

SQL Query #83

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('node_1329198_lvl1data','node_1329224_lvl1data','node_1329233_lvl1data','node_1329274_lvl1data','node_1329275_lvl1data','node_1329277_lvl1data','node_1329279_lvl1data','node_1329343_lvl1data','node_1329363_lvl1data','node_1329365_lvl1data','node_1329367_lvl1data','node_1329392_lvl1data','node_1329394_lvl1data','node_1329413_lvl1data','node_1329444_lvl1data') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_cache rangePRIMARYPRIMARY66 15100.00Using where

				

SQL Query #84

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 hmq_node AS node
			LEFT JOIN hmq_editlog AS editlog ON (editlog.nodeid = node.nodeid)
			 WHERE node.nodeid IN (1329198,1329224,1329233,1329274,1329275,1329277,1329279,1329343,1329363,1329365,1329367,1329392,1329394,1329413,1329444) 
/**fetchNodeWithContent**/
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEnode rangePRIMARY,nodeidPRIMARY4 15100.00Using where
1SIMPLEeditlog eq_refPRIMARYPRIMARY4alnadawi_vb.node.nodeid1100.00 

				

SQL Query #85

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vb_UserWPerms_2126_5','vb_UserWPerms_1923_5','vb_UserWPerms_1714_5','vb_UserWPerms_2197_5','vb_UserWPerms_405_5','vb_UserWPerms_2436_5','vb_UserWPerms_2471_5','vb_UserWPerms_2322_5') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_cache rangePRIMARYPRIMARY66 8100.00Using where

				

SQL Query #86

				SELECT 
					userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
					IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
				FROM hmq_user AS user
				LEFT JOIN hmq_userfield AS userfield ON (user.userid = userfield.userid)
				LEFT JOIN hmq_usertextfield AS usertextfield ON (usertextfield.userid = user.userid) 
					WHERE user.userid IN (2126,1923,1714,2197,405,2436,2471,2322)
					/** fetchUserinfo **/
			
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEuser rangePRIMARYPRIMARY4 8100.00Using index condition
1SIMPLEuserfield eq_refPRIMARYPRIMARY4alnadawi_vb.user.userid1100.00 
1SIMPLEusertextfield eq_refPRIMARYPRIMARY4alnadawi_vb.user.userid1100.00 

				

SQL Query #87

SELECT * FROM hmq_routenew
 WHERE `routeid` IN (67) 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_routenew constPRIMARYPRIMARY4const1100.00 

				

SQL Query #88

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vBAtchmnts_1329198','vBAtchmnts_1329224','vBAtchmnts_1329233','vBAtchmnts_1329274','vBAtchmnts_1329275','vBAtchmnts_1329277','vBAtchmnts_1329279','vBAtchmnts_1329343','vBAtchmnts_1329363','vBAtchmnts_1329365','vBAtchmnts_1329367','vBAtchmnts_1329392','vBAtchmnts_1329394','vBAtchmnts_1329413','vBAtchmnts_1329444') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_cache rangePRIMARYPRIMARY66 15100.00Using where

				

SQL Query #89

				(
					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 hmq_node AS n USE INDEX (contenttypeid_parentid)
						JOIN hmq_attach AS a ON (a.nodeid = n.nodeid)
					WHERE n.contenttypeid = 24 AND n.parentid IN (1329198,1329224,1329233,1329274,1329275,1329277,1329279,1329343,1329363,1329365,1329367,1329392,1329394,1329413,1329444)
				)
				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 hmq_node AS n USE INDEX (contenttypeid_parentid)
						JOIN hmq_photo AS p ON (p.nodeid = n.nodeid)
					WHERE n.contenttypeid = 23 AND n.parentid IN (1329198,1329224,1329233,1329274,1329275,1329277,1329279,1329343,1329363,1329365,1329367,1329392,1329394,1329413,1329444)
				)
			
/**fetchNodeAttachments**/
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1PRIMARYn rangecontenttypeid_parentidcontenttypeid_parentid6 15100.00Using index condition
1PRIMARYa eq_refPRIMARYPRIMARY4alnadawi_vb.n.nodeid1100.00 
2UNIONn rangecontenttypeid_parentidcontenttypeid_parentid6 15100.00Using index condition
2UNIONp eq_refPRIMARY,nodeidPRIMARY4alnadawi_vb.n.nodeid1100.00 

				

SQL Query #90

				SELECT cl.parent AS nodeid, count(a.nodeid) AS count
				FROM hmq_closure AS cl
				INNER JOIN hmq_attach AS a ON (a.nodeid = cl.child)
				WHERE cl.parent in (1329198,1329224,1329233,1329274,1329275,1329277,1329279,1329343,1329363,1329365,1329367,1329392,1329394,1329413,1329444)
				GROUP BY cl.parent
			
/**getDescendantAttachCount**/
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcl rangeclosure_uniq,parent_2,publishdate,child,displayorderparent_24 15100.00Using where; Using index
1SIMPLEa eq_refPRIMARYPRIMARY4alnadawi_vb.cl.child1100.00Using index

				

SQL Query #91

				SELECT cl.parent AS nodeid, count(child.nodeid) AS count
				FROM hmq_closure AS cl
				INNER JOIN hmq_node AS child USE INDEX (nodeid, node_ctypid_userid_dispo_idx) ON (child.nodeid = cl.child)
				WHERE cl.parent in (1329198,1329224,1329233,1329274,1329275,1329277,1329279,1329343,1329363,1329365,1329367,1329392,1329394,1329413,1329444) AND child.contenttypeid = 23
				GROUP BY cl.parent
			
/**getDescendantPhotoCount**/
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcl rangeclosure_uniq,parent_2,publishdate,child,displayorderparent_24 15100.00Using where; Using index
1SIMPLEchild eq_refnode_ctypid_userid_dispo_idx,nodeidnodeid6alnadawi_vb.cl.child,const1100.00Using index

				

SQL Query #92

SELECT * FROM hmq_closure
 WHERE `child` IN (1329198,1329224,1329233,1329274,1329275,1329277,1329279,1329343,1329363,1329365,1329367,1329392,1329394,1329413,1329444) 
 ORDER BY `child` ASC, `depth` ASC
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_closure rangechildchild4 90100.00Using index condition

				

SQL Query #93

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('node_1329198_lvl3data','node_1329224_lvl3data','node_1329233_lvl3data','node_1329274_lvl3data','node_1329275_lvl3data','node_1329277_lvl3data','node_1329279_lvl3data','node_1329343_lvl3data','node_1329363_lvl3data','node_1329365_lvl3data','node_1329367_lvl3data','node_1329392_lvl3data','node_1329394_lvl3data','node_1329413_lvl3data','node_1329444_lvl3data') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_cache rangePRIMARYPRIMARY66 15100.00Using where

				

SQL Query #94

SELECT node.*,text.allowsmilie,text.attach,text.htmlstate,text.imageheight,text.imagewidth,text.infraction,text.moderated,text.nodeid AS text_nodeid,text.pagetext,text.pagetextimages,text.previewimage,text.previewtext,text.previewvideo,text.rawtext,text.showsignature, 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 hmq_node AS node
		 
			LEFT JOIN  hmq_text AS text
			ON text.nodeid = node.nodeid

		 LEFT JOIN hmq_editlog AS editlog ON (editlog.nodeid = node.nodeid)
		 LEFT JOIN hmq_node AS starter ON (starter.nodeid = node.starter)
		 LEFT JOIN hmq_node AS ch ON (ch.nodeid = starter.parentid)
		 LEFT JOIN hmq_user AS deleteuser ON (node.deleteuserid > 0 AND node.deleteuserid = deleteuser.userid)
		 LEFT JOIN hmq_user AS lastauthor ON (node.lastauthorid = lastauthor.userid)
		 LEFT JOIN hmq_icon AS icon ON (node.iconid = icon.iconid)
		
		 WHERE node.nodeid IN (1329198,1329224,1329233,1329274,1329275,1329277,1329279,1329343,1329363,1329365,1329367,1329392,1329394,1329413,1329444)
/** getFullContent**/
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEnode rangePRIMARY,nodeidPRIMARY4 15100.00Using where
1SIMPLEtext eq_refPRIMARYPRIMARY4alnadawi_vb.node.nodeid1100.00 
1SIMPLEeditlog eq_refPRIMARYPRIMARY4alnadawi_vb.node.nodeid1100.00 
1SIMPLEstarter eq_refPRIMARY,nodeidPRIMARY4alnadawi_vb.node.starter1100.00Using where
1SIMPLEch eq_refPRIMARY,nodeidPRIMARY4alnadawi_vb.starter.parentid1100.00Using where
1SIMPLEdeleteuser eq_refPRIMARYPRIMARY4alnadawi_vb.node.deleteuserid1100.00Using where
1SIMPLElastauthor eq_refPRIMARYPRIMARY4alnadawi_vb.node.lastauthorid1100.00 
1SIMPLEicon eq_refPRIMARYPRIMARY2alnadawi_vb.node.iconid1100.00Using where

				

SQL Query #95

SELECT * FROM hmq_node
 WHERE `nodeid` = 1329198 
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_node constPRIMARY,nodeidPRIMARY4const1100.00 

				

SQL Query #96

SELECT * FROM hmq_node
 WHERE `nodeid` = 1329224 
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_node constPRIMARY,nodeidPRIMARY4const1100.00 

				

SQL Query #97

SELECT * FROM hmq_node
 WHERE `nodeid` = 1329233 
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_node constPRIMARY,nodeidPRIMARY4const1100.00 

				

SQL Query #98

SELECT * FROM hmq_node
 WHERE `nodeid` = 1329274 
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_node constPRIMARY,nodeidPRIMARY4const1100.00 

				

SQL Query #99

SELECT * FROM hmq_node
 WHERE `nodeid` = 1329275 
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_node constPRIMARY,nodeidPRIMARY4const1100.00 

				

SQL Query #100

SELECT * FROM hmq_node
 WHERE `nodeid` = 1329277 
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_node constPRIMARY,nodeidPRIMARY4const1100.00 

				

SQL Query #101

SELECT * FROM hmq_node
 WHERE `nodeid` = 1329279 
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_node constPRIMARY,nodeidPRIMARY4const1100.00 

				

SQL Query #102

SELECT * FROM hmq_node
 WHERE `nodeid` = 1329343 
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_node constPRIMARY,nodeidPRIMARY4const1100.00 

				

SQL Query #103

SELECT * FROM hmq_node
 WHERE `nodeid` = 1329363 
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_node constPRIMARY,nodeidPRIMARY4const1100.00 

				

SQL Query #104

SELECT * FROM hmq_node
 WHERE `nodeid` = 1329365 
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_node constPRIMARY,nodeidPRIMARY4const1100.00 

				

SQL Query #105

SELECT * FROM hmq_node
 WHERE `nodeid` = 1329367 
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_node constPRIMARY,nodeidPRIMARY4const1100.00 

				

SQL Query #106

SELECT * FROM hmq_node
 WHERE `nodeid` = 1329392 
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_node constPRIMARY,nodeidPRIMARY4const1100.00 

				

SQL Query #107

SELECT * FROM hmq_node
 WHERE `nodeid` = 1329394 
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_node constPRIMARY,nodeidPRIMARY4const1100.00 

				

SQL Query #108

SELECT * FROM hmq_node
 WHERE `nodeid` = 1329413 
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_node constPRIMARY,nodeidPRIMARY4const1100.00 

				

SQL Query #109

SELECT * FROM hmq_node
 WHERE `nodeid` = 1329444 
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_node constPRIMARY,nodeidPRIMARY4const1100.00 

				

SQL Query #110

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vB_UserPerms2126') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_cache constPRIMARYPRIMARY66const1100.00 

				

SQL Query #111

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vB_UserPerms1923') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_cache constPRIMARYPRIMARY66const1100.00 

				

SQL Query #112

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vB_UserPerms1714') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_cache constPRIMARYPRIMARY66const1100.00 

				

SQL Query #113

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vB_UserPerms2197') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_cache constPRIMARYPRIMARY66const1100.00 

				

SQL Query #114

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vB_UserPerms405') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_cache constPRIMARYPRIMARY66const1100.00 

				

SQL Query #115

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vB_UserPerms2436') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_cache constPRIMARYPRIMARY66const1100.00 

				

SQL Query #116

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vBUserRep_2126','vBUserRep_1923','vBUserRep_1714','vBUserRep_2197','vBUserRep_405','vBUserRep_2436','vBUserRep_2471','vBUserRep_2322') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_cache rangePRIMARYPRIMARY66 8100.00Using where

				

SQL Query #117

SELECT user.userid, avatar.avatarid, avatar.avatarpath, user.avatarrevision,
					customavatar.dateline, customavatar.width, customavatar.height, customavatar.height_thumb, customavatar.width_thumb, customavatar.filename
			FROM hmq_user as user
				LEFT JOIN hmq_customavatar AS customavatar ON customavatar.userid = user.userid
				LEFT JOIN hmq_avatar AS avatar ON avatar.avatarid = user.avatarid
			WHERE user.userid IN (2126,1923,1714,2197,405,2436,2471,2322)
/**fetchAvatarsForUsers**/
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEavatar systemPRIMARY   00.00const row not found
1SIMPLEuser rangePRIMARYPRIMARY4 8100.00Using index condition
1SIMPLEcustomavatar eq_refPRIMARYPRIMARY4alnadawi_vb.user.userid1100.00 

				

SQL Query #118

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vbSig_2126','vbSig_1923','vbSig_1191','vbSig_2197','vbSig_405') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_cache rangePRIMARYPRIMARY66 5100.00Using where

				

SQL Query #119

SELECT * FROM hmq_datastore
 WHERE `title` IN ('smiliecache') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_datastore constPRIMARYPRIMARY52const1100.00 

				

SQL Query #120

SELECT * FROM hmq_bbcode
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLE         no matching row in const table

				

SQL Query #121

SELECT * FROM hmq_channel
 WHERE `nodeid` = 18 
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_channel constPRIMARYPRIMARY4const1100.00 

				

SQL Query #122

SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
 WHERE `templateid` IN (10282,10420,10485) 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_template rangePRIMARYPRIMARY4 3100.00Using index condition

				

SQL Query #123

SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
 WHERE `templateid` IN (10486) 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_template constPRIMARYPRIMARY4const1100.00 

				

SQL Query #124

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('pageNav_3_4') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_cache constPRIMARYPRIMARY66const1100.00 

				

SQL Query #125

SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
 WHERE `templateid` IN (10444,10443) 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_template rangePRIMARYPRIMARY4 2100.00Using index condition

				

SQL Query #126

SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
 WHERE `templateid` IN (10283,10450,10409) 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_template rangePRIMARYPRIMARY4 3100.00Using index condition

				

SQL Query #127

SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
 WHERE `templateid` IN (10497,10281) 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_template rangePRIMARYPRIMARY4 2100.00Using index condition

				

SQL Query #128

SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
 WHERE `templateid` IN (10280,10279,10402) 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_template rangePRIMARYPRIMARY4 3100.00Using index condition

				

SQL Query #129

SELECT `varname`,`languageid`,`text` FROM hmq_phrase
 WHERE `varname` IN ('','logo','powered_by_vbulletin_title','search','navbar_home','navbar_blogs','navbar_articles','navbar_social_groups','navbar_todays_posts','navbar_mark_channels_read','navbar_member_list','navbar_calendar','home','login','you_can_also_login_as','logging_in','username','password','remember_me','log_in','forgot_password','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','reputation5','join_date','x_is_offline','facebook_share','twitter_tweet','comment','type_your_comment_here','post','cancel','see_previous_comments','see_next_comments','reputation_disabled','navbar_help','navbar_contact_us','go_to_top','powered_by_vbulletin','footer_current_time','working_ellipsis','yes','no','ok','facebook_language') AND `languageid` IN (5,0,-1) 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_phrase rangename_lang_type,languageidname_lang_type195 231100.00Using index condition

				

SQL Query #130

SELECT * FROM hmq_routenew
 WHERE `routeid` IN ('pmchat','register','activateuser','help','contact-us','search','lostpw','67','profile') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_routenew rangePRIMARYPRIMARY4 2100.00Using where

				

SQL Query #131

SELECT * FROM hmq_page
 WHERE `pageid` = 120 
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_page constPRIMARYPRIMARY4const1100.00 

				

SQL Query #132

SELECT `varname`,`languageid`,`text` FROM hmq_phrase
 WHERE `varname` IN ('page_pmchat_page_chat_573cba8f1d228390944371_title','page_pmchat_page_chat_573cba8f1d228390944371_metadesc') AND `languageid` IN (5,0,-1) 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_phrase rangename_lang_type,languageidname_lang_type195 6100.00Using index condition

				

SQL Query #133

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vbnodetext1329198_14_5:09f14d73cd828b8c283774e754116338','vbnodetext1329224_14_5:09f14d73cd828b8c283774e754116338','vbnodetext1329233_14_5:09f14d73cd828b8c283774e754116338','vbnodetext1329274_14_5:09f14d73cd828b8c283774e754116338','vbnodetext1329275_14_5:09f14d73cd828b8c283774e754116338','vbnodetext1329277_14_5:09f14d73cd828b8c283774e754116338','vbnodetext1329279_14_5:09f14d73cd828b8c283774e754116338','vbnodetext1329343_14_5:09f14d73cd828b8c283774e754116338','vbnodetext1329363_14_5:09f14d73cd828b8c283774e754116338','vbnodetext1329365_14_5:09f14d73cd828b8c283774e754116338','vbnodetext1329367_14_5:09f14d73cd828b8c283774e754116338','vbnodetext1329392_14_5:09f14d73cd828b8c283774e754116338','vbnodetext1329394_14_5:09f14d73cd828b8c283774e754116338','vbnodetext1329413_14_5:09f14d73cd828b8c283774e754116338','vbnodetext1329444_14_5:09f14d73cd828b8c283774e754116338') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_cache rangePRIMARYPRIMARY66 15100.00Using where

				

SQL Query #134

SELECT node.*, channel.nodeid AS channelid, channel.options, channel.guid,
				text.rawtext, text.htmlstate, text.previewtext
			FROM hmq_node AS node
			INNER JOIN hmq_node AS starter ON starter.nodeid = node.starter
			INNER JOIN hmq_channel AS channel ON channel.nodeid = starter.parentid
			INNER JOIN hmq_text AS text ON text.nodeid = node.nodeid
			WHERE node.nodeid IN (1329198,1329224,1329233,1329274,1329275,1329277,1329279,1329343,1329363,1329365,1329367,1329392,1329394,1329413,1329444) 
/**getDataForParse**/
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEtext rangePRIMARYPRIMARY4 15100.00Using where
1SIMPLEnode eq_refPRIMARY,node_starter,nodeidPRIMARY4alnadawi_vb.text.nodeid1100.00 
1SIMPLEstarter eq_refPRIMARY,nodeid,node_parent_lastcontent,node_parent_inlist_lastcontent,node_parent_useridPRIMARY4alnadawi_vb.node.starter1100.00Using where
1SIMPLEchannel eq_refPRIMARYPRIMARY4alnadawi_vb.starter.parentid1100.00Using where

				

SQL Query #135

SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
 WHERE `templateid` IN (10229) 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_template constPRIMARYPRIMARY4const1100.00 

				

SQL Query #136

				(SELECT nodeid, oldid, starter, routeid
				FROM hmq_node
				WHERE oldid IN (934028) AND oldcontenttypeid IN (1))
				UNION
				(SELECT t.nodeid, t.postid as oldid, n.starter, n.routeid
				FROM hmq_thread_post t
				INNER JOIN hmq_node n ON n.nodeid = t.nodeid
				WHERE t.postid IN (934028))
			
/**fetchLegacyPostIds**/
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1PRIMARYhmq_node refnode_oldinfonode_oldinfo10const,const1100.00 
2UNIONt refPRIMARY,postidpostid4const1100.00Using index
2UNIONn eq_refPRIMARY,nodeidPRIMARY4alnadawi_vb.t.nodeid1100.00 
 UNION RESULT ALL      Using temporary

				

SQL Query #137

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('node_1329197_lvl1data') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLE         no matching row in const table

				

SQL Query #138

SELECT * FROM hmq_node
 WHERE `nodeid` = 1329197 
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_node constPRIMARY,nodeidPRIMARY4const1100.00 

				

SQL Query #139

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('node_1329197_lvl3data') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLE         no matching row in const table

				

SQL Query #140

SELECT node.*,text.allowsmilie,text.attach,text.htmlstate,text.imageheight,text.imagewidth,text.infraction,text.moderated,text.nodeid AS text_nodeid,text.pagetext,text.pagetextimages,text.previewimage,text.previewtext,text.previewvideo,text.rawtext,text.showsignature, 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 hmq_node AS node
		 
			LEFT JOIN  hmq_text AS text
			ON text.nodeid = node.nodeid

		 LEFT JOIN hmq_editlog AS editlog ON (editlog.nodeid = node.nodeid)
		 LEFT JOIN hmq_node AS starter ON (starter.nodeid = node.starter)
		 LEFT JOIN hmq_node AS ch ON (ch.nodeid = starter.parentid)
		 LEFT JOIN hmq_user AS deleteuser ON (node.deleteuserid > 0 AND node.deleteuserid = deleteuser.userid)
		 LEFT JOIN hmq_user AS lastauthor ON (node.lastauthorid = lastauthor.userid)
		 LEFT JOIN hmq_icon AS icon ON (node.iconid = icon.iconid)
		
		 WHERE node.nodeid IN (1329197)
/** getFullContent**/
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEnode constPRIMARY,nodeidPRIMARY4const1100.00 
1SIMPLEtext constPRIMARYPRIMARY4const1100.00 
1SIMPLEeditlog constPRIMARYPRIMARY4const00.00unique row not found
1SIMPLEstarter constPRIMARY,nodeidPRIMARY4const1100.00 
1SIMPLEch constPRIMARY,nodeidPRIMARY4const1100.00 
1SIMPLEdeleteuser constPRIMARY   1100.00Impossible ON condition
1SIMPLElastauthor constPRIMARYPRIMARY4const00.00unique row not found
1SIMPLEicon constPRIMARYPRIMARY2const00.00unique row not found

				

SQL Query #141

SELECT * FROM hmq_closure
 WHERE `child` IN (1329197) 
 ORDER BY `child` ASC, `depth` ASC
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_closure refchildchild4const6100.00Using index condition

				

SQL Query #142

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vBAtchmnts_1329197') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLE         no matching row in const table

				

SQL Query #143

				(
					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 hmq_node AS n USE INDEX (contenttypeid_parentid)
						JOIN hmq_attach AS a ON (a.nodeid = n.nodeid)
					WHERE n.contenttypeid = 24 AND n.parentid IN (1329197)
				)
				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 hmq_node AS n USE INDEX (contenttypeid_parentid)
						JOIN hmq_photo AS p ON (p.nodeid = n.nodeid)
					WHERE n.contenttypeid = 23 AND n.parentid IN (1329197)
				)
			
/**fetchNodeAttachments**/
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1PRIMARYn refcontenttypeid_parentidcontenttypeid_parentid6const,const1100.00 
1PRIMARYa eq_refPRIMARYPRIMARY4alnadawi_vb.n.nodeid1100.00 
2UNIONn refcontenttypeid_parentidcontenttypeid_parentid6const,const1100.00 
2UNIONp eq_refPRIMARY,nodeidPRIMARY4alnadawi_vb.n.nodeid1100.00 

				

SQL Query #144

SELECT `varname`,`languageid`,`text` FROM hmq_phrase
 WHERE `varname` IN ('originally_posted_by_x','view_post') AND `languageid` IN (5,0,-1) 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_phrase rangename_lang_type,languageidname_lang_type195 6100.00Using index condition

				

SQL Query #145

				(SELECT nodeid, oldid, starter, routeid
				FROM hmq_node
				WHERE oldid IN (934029) AND oldcontenttypeid IN (1))
				UNION
				(SELECT t.nodeid, t.postid as oldid, n.starter, n.routeid
				FROM hmq_thread_post t
				INNER JOIN hmq_node n ON n.nodeid = t.nodeid
				WHERE t.postid IN (934029))
			
/**fetchLegacyPostIds**/
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1PRIMARYhmq_node refnode_oldinfonode_oldinfo10const,const1100.00 
2UNIONt refPRIMARY,postidpostid4const1100.00Using index
2UNIONn eq_refPRIMARY,nodeidPRIMARY4alnadawi_vb.t.nodeid1100.00 
 UNION RESULT ALL      Using temporary

				

SQL Query #146

				(SELECT nodeid, oldid, starter, routeid
				FROM hmq_node
				WHERE oldid IN (934058) AND oldcontenttypeid IN (1))
				UNION
				(SELECT t.nodeid, t.postid as oldid, n.starter, n.routeid
				FROM hmq_thread_post t
				INNER JOIN hmq_node n ON n.nodeid = t.nodeid
				WHERE t.postid IN (934058))
			
/**fetchLegacyPostIds**/
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1PRIMARYhmq_node refnode_oldinfonode_oldinfo10const,const1100.00 
2UNIONt refPRIMARY,postidpostid4const1100.00Using index
2UNIONn eq_refPRIMARY,nodeidPRIMARY4alnadawi_vb.t.nodeid1100.00 
 UNION RESULT ALL      Using temporary

				

SQL Query #147

				(SELECT nodeid, oldid, starter, routeid
				FROM hmq_node
				WHERE oldid IN (934069) AND oldcontenttypeid IN (1))
				UNION
				(SELECT t.nodeid, t.postid as oldid, n.starter, n.routeid
				FROM hmq_thread_post t
				INNER JOIN hmq_node n ON n.nodeid = t.nodeid
				WHERE t.postid IN (934069))
			
/**fetchLegacyPostIds**/
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1PRIMARYhmq_node refnode_oldinfonode_oldinfo10const,const1100.00 
2UNIONt refPRIMARY,postidpostid4const1100.00Using index
2UNIONn eq_refPRIMARY,nodeidPRIMARY4alnadawi_vb.t.nodeid1100.00 
 UNION RESULT ALL      Using temporary

				

SQL Query #148

				(SELECT nodeid, oldid, starter, routeid
				FROM hmq_node
				WHERE oldid IN (933936) AND oldcontenttypeid IN (1))
				UNION
				(SELECT t.nodeid, t.postid as oldid, n.starter, n.routeid
				FROM hmq_thread_post t
				INNER JOIN hmq_node n ON n.nodeid = t.nodeid
				WHERE t.postid IN (933936))
			
/**fetchLegacyPostIds**/
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1PRIMARYhmq_node refnode_oldinfonode_oldinfo10const,const1100.00 
2UNIONt refPRIMARY,postidpostid4const1100.00Using index
2UNIONn eq_refPRIMARY,nodeidPRIMARY4alnadawi_vb.t.nodeid1100.00 
 UNION RESULT ALL      Using temporary

				

SQL Query #149

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('node_1329115_lvl1data') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLE         no matching row in const table

				

SQL Query #150

SELECT * FROM hmq_node
 WHERE `nodeid` = 1329115 
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_node constPRIMARY,nodeidPRIMARY4const1100.00 

				

SQL Query #151

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('node_1329115_lvl3data') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLE         no matching row in const table

				

SQL Query #152

SELECT node.*,text.allowsmilie,text.attach,text.htmlstate,text.imageheight,text.imagewidth,text.infraction,text.moderated,text.nodeid AS text_nodeid,text.pagetext,text.pagetextimages,text.previewimage,text.previewtext,text.previewvideo,text.rawtext,text.showsignature, 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 hmq_node AS node
		 
			LEFT JOIN  hmq_text AS text
			ON text.nodeid = node.nodeid

		 LEFT JOIN hmq_editlog AS editlog ON (editlog.nodeid = node.nodeid)
		 LEFT JOIN hmq_node AS starter ON (starter.nodeid = node.starter)
		 LEFT JOIN hmq_node AS ch ON (ch.nodeid = starter.parentid)
		 LEFT JOIN hmq_user AS deleteuser ON (node.deleteuserid > 0 AND node.deleteuserid = deleteuser.userid)
		 LEFT JOIN hmq_user AS lastauthor ON (node.lastauthorid = lastauthor.userid)
		 LEFT JOIN hmq_icon AS icon ON (node.iconid = icon.iconid)
		
		 WHERE node.nodeid IN (1329115)
/** getFullContent**/
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEnode constPRIMARY,nodeidPRIMARY4const1100.00 
1SIMPLEtext constPRIMARYPRIMARY4const1100.00 
1SIMPLEeditlog constPRIMARYPRIMARY4const00.00unique row not found
1SIMPLEstarter constPRIMARY,nodeidPRIMARY4const1100.00 
1SIMPLEch constPRIMARY,nodeidPRIMARY4const1100.00 
1SIMPLEdeleteuser constPRIMARY   1100.00Impossible ON condition
1SIMPLElastauthor constPRIMARYPRIMARY4const00.00unique row not found
1SIMPLEicon constPRIMARYPRIMARY2const1100.00 

				

SQL Query #153

SELECT * FROM hmq_closure
 WHERE `child` IN (1329115) 
 ORDER BY `child` ASC, `depth` ASC
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_closure refchildchild4const6100.00Using index condition

				

SQL Query #154

SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vBAtchmnts_1329115') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLE         no matching row in const table

				

SQL Query #155

				(
					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 hmq_node AS n USE INDEX (contenttypeid_parentid)
						JOIN hmq_attach AS a ON (a.nodeid = n.nodeid)
					WHERE n.contenttypeid = 24 AND n.parentid IN (1329115)
				)
				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 hmq_node AS n USE INDEX (contenttypeid_parentid)
						JOIN hmq_photo AS p ON (p.nodeid = n.nodeid)
					WHERE n.contenttypeid = 23 AND n.parentid IN (1329115)
				)
			
/**fetchNodeAttachments**/
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1PRIMARYn refcontenttypeid_parentidcontenttypeid_parentid6const,const1100.00 
1PRIMARYa eq_refPRIMARYPRIMARY4alnadawi_vb.n.nodeid1100.00 
2UNIONn refcontenttypeid_parentidcontenttypeid_parentid6const,const1100.00 
2UNIONp eq_refPRIMARY,nodeidPRIMARY4alnadawi_vb.n.nodeid1100.00 

				

SQL Query #156

SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
 WHERE `templateid` IN (10757) 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_template constPRIMARYPRIMARY4const1100.00 

				

SQL Query #157

SELECT `varname`,`languageid`,`text` FROM hmq_phrase
 WHERE `varname` IN ('debug_information','page_id','page_parent_id','page_template_id','route_id','page_type','screen_layout_id','screen_layout_template','channel_id','node_id','database_asserts','ajax_requests','facebook_active','not_enabled_or_no_appid_secret_set','style_id','templates_renders','parent','css_templates','rollup','js_files','included_files','autoloaded_classes','not_loaded','current_time','page_time') AND `languageid` IN (5,0,-1) 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhmq_phrase rangename_lang_type,languageidname_lang_type195 75100.00Using index condition

				

5 Slowest Queries

SQL Query #150 Time Taken: 0.0073390007019043 Memory Used: 0
SELECT * FROM hmq_node
 WHERE `nodeid` = 1329115 
 LIMIT 1
SQL Query #117 Time Taken: 0.004086971282959 Memory Used: 0
SELECT user.userid, avatar.avatarid, avatar.avatarpath, user.avatarrevision,
					customavatar.dateline, customavatar.width, customavatar.height, customavatar.height_thumb, customavatar.width_thumb, customavatar.filename
			FROM hmq_user as user
				LEFT JOIN hmq_customavatar AS customavatar ON customavatar.userid = user.userid
				LEFT JOIN hmq_avatar AS avatar ON avatar.avatarid = user.avatarid
			WHERE user.userid IN (2126,1923,1714,2197,405,2436,2471,2322)
/**fetchAvatarsForUsers**/
SQL Query #136 Time Taken: 0.0037720203399658 Memory Used: 0
				(SELECT nodeid, oldid, starter, routeid
				FROM hmq_node
				WHERE oldid IN (934028) AND oldcontenttypeid IN (1))
				UNION
				(SELECT t.nodeid, t.postid as oldid, n.starter, n.routeid
				FROM hmq_thread_post t
				INNER JOIN hmq_node n ON n.nodeid = t.nodeid
				WHERE t.postid IN (934028))
			
/**fetchLegacyPostIds**/
SQL Query #140 Time Taken: 0.0037281513214111 Memory Used: 0
SELECT node.*,text.allowsmilie,text.attach,text.htmlstate,text.imageheight,text.imagewidth,text.infraction,text.moderated,text.nodeid AS text_nodeid,text.pagetext,text.pagetextimages,text.previewimage,text.previewtext,text.previewvideo,text.rawtext,text.showsignature, 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 hmq_node AS node
		 
			LEFT JOIN  hmq_text AS text
			ON text.nodeid = node.nodeid

		 LEFT JOIN hmq_editlog AS editlog ON (editlog.nodeid = node.nodeid)
		 LEFT JOIN hmq_node AS starter ON (starter.nodeid = node.starter)
		 LEFT JOIN hmq_node AS ch ON (ch.nodeid = starter.parentid)
		 LEFT JOIN hmq_user AS deleteuser ON (node.deleteuserid > 0 AND node.deleteuserid = deleteuser.userid)
		 LEFT JOIN hmq_user AS lastauthor ON (node.lastauthorid = lastauthor.userid)
		 LEFT JOIN hmq_icon AS icon ON (node.iconid = icon.iconid)
		
		 WHERE node.nodeid IN (1329197)
/** getFullContent**/
SQL Query #99 Time Taken: 0.0034909248352051 Memory Used: 0
SELECT * FROM hmq_node
 WHERE `nodeid` = 1329275 
 LIMIT 1

157 Queries Run : Total SQL time was 0.125724 seconds , Total PHP time was 0.404649 seconds , Overall time was 0.530373 seconds.