vBulletin - Explain SQL Queries (114)

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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_datastorerangePRIMARYPRIMARY52 18Using 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` = 'a2bd2c8da98d5081c77a0b0a10b93b2f'  AND `lastactivity` > 1783309801  
 LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_sessionconstPRIMARY,last_activityPRIMARY34const1 
#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('a2bd2c8da9[len:32]', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/session.php(132)
#9 vB_Session->loadExistingSession('a2bd2c8da9[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], 'a2bd2c8da9[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], 'a2bd2c8da9[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], 'a2bd2c8da9[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('a2bd2c8da9[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('a2bd2c8da9[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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_cacheconstPRIMARYPRIMARY66const1 
#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('a2bd2c8da9[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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_cacheconstPRIMARYPRIMARY66const1 
#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:79]', 'explain=1') 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/29029-محاوره-شعريه-جماعيه-باخر-كلمه/page20','forum/c1/z4/29029-محاوره-شعريه-جماعيه-باخر-كلمه','forum/c1/z4','forum/c1','forum') OR ishomeroute = 1
			
/**get_best_routes**/
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEroutenewindex_mergeprefix,ishomerouteprefix,ishomeroute202,2 8Using 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:322]', 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:79]', 'explain=1') 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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_cacheconstPRIMARYPRIMARY66const1 
#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:79]', 'explain=1') 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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_cacheconstPRIMARYPRIMARY66const1 
#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', '') in /core/vb5/route.php(1168)
#15 vB5_Route::checkRoute(array[len:14], 'forum/c1/z[len:159]', 'forum/c1/z[len:79]', 'explain=1', '') in /core/vb5/route.php(1104)
#16 vB5_Route::selectBestRoute('forum/c1/z[len:79]', 'explain=1', '', 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:79]', 'explain=1') 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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_cacheconstPRIMARYPRIMARY66const1 
#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', '') in /core/vb5/route.php(1168)
#14 vB5_Route::checkRoute(array[len:14], 'forum/c1/z[len:159]', 'forum/c1/z[len:79]', 'explain=1', '') in /core/vb5/route.php(1104)
#15 vB5_Route::selectBestRoute('forum/c1/z[len:79]', 'explain=1', '', 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:79]', 'explain=1') 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_29029_lvl1data')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_cacheconstPRIMARYPRIMARY66const1 
#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('29029') in /core/vb5/route/conversation.php(83)
#11 vB5_Route_Conversation->__construct(array[len:14], array[len:10], 'explain=1', '') in /core/vb5/route.php(1168)
#12 vB5_Route::checkRoute(array[len:14], 'forum/c1/z[len:159]', 'forum/c1/z[len:79]', 'explain=1', '') in /core/vb5/route.php(1104)
#13 vB5_Route::selectBestRoute('forum/c1/z[len:79]', 'explain=1', '', 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:79]', 'explain=1') 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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_channelALLguid   52Using 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('29029') 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', '') in /core/vb5/route.php(1168)
#13 vB5_Route::checkRoute(array[len:14], 'forum/c1/z[len:159]', 'forum/c1/z[len:79]', 'explain=1', '') in /core/vb5/route.php(1104)
#14 vB5_Route::selectBestRoute('forum/c1/z[len:79]', 'explain=1', '', 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:79]', 'explain=1') 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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_cacheconstPRIMARYPRIMARY66const1 
#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', '') in /core/vb5/route.php(1168)
#17 vB5_Route::checkRoute(array[len:14], 'forum/c1/z[len:159]', 'forum/c1/z[len:79]', 'explain=1', '') in /core/vb5/route.php(1104)
#18 vB5_Route::selectBestRoute('forum/c1/z[len:79]', 'explain=1', '', 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:79]', 'explain=1') 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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_routenewconstPRIMARYPRIMARY4const1 
#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', '') in /core/vb5/route.php(1168)
#15 vB5_Route::checkRoute(array[len:14], 'forum/c1/z[len:159]', 'forum/c1/z[len:79]', 'explain=1', '') in /core/vb5/route.php(1104)
#16 vB5_Route::selectBestRoute('forum/c1/z[len:79]', 'explain=1', '', 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:79]', 'explain=1') 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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_cacheconstPRIMARYPRIMARY66const1 
#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', '') in /core/vb5/route.php(1168)
#20 vB5_Route::checkRoute(array[len:14], 'forum/c1/z[len:159]', 'forum/c1/z[len:79]', 'explain=1', '') in /core/vb5/route.php(1104)
#21 vB5_Route::selectBestRoute('forum/c1/z[len:79]', 'explain=1', '', 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:79]', 'explain=1') 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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_cacheconstPRIMARYPRIMARY66const1 
#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', '') in /core/vb5/route.php(1168)
#19 vB5_Route::checkRoute(array[len:14], 'forum/c1/z[len:159]', 'forum/c1/z[len:79]', 'explain=1', '') in /core/vb5/route.php(1104)
#20 vB5_Route::selectBestRoute('forum/c1/z[len:79]', 'explain=1', '', 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:79]', 'explain=1') 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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_cacheconstPRIMARYPRIMARY66const1 
#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:79]', 'explain=1') 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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_routenewconstPRIMARYPRIMARY4const1 
#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:1], '') 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:79]', 'explain=1') 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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_closurerefchildchild4const4Using 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: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:79]', 'explain=1') 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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_cacherangePRIMARYPRIMARY66 2Using 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:79]', 'explain=1') 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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_routenewrangePRIMARYPRIMARY4 3Using 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:79]', 'explain=1') 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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_cacheconstPRIMARYPRIMARY66const1 
#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:79]', 'explain=1') 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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_cacheconstPRIMARYPRIMARY66const1 
#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:79]', 'explain=1') 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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_channelALL    52Using 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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_styleconstPRIMARYPRIMARY2const1 
#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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_templateconstPRIMARYPRIMARY4const1 

				

				
				

					
SQL Query #26

					
SELECT * FROM hmq_page
 WHERE `pageid` = 3 
 LIMIT 1

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_pageconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_phraserangename_lang_type,languageidname_lang_type195 6Using index condition

					
					

				

				
				

					
SQL Query #28

					
SELECT * FROM hmq_page
 WHERE `pageid` = 23 
 LIMIT 1

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_pageconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_phraserangename_lang_type,languageidname_lang_type195 6Using index condition

					
					

				

				
				

					
SQL Query #30

					
SELECT * FROM hmq_page
 WHERE `pageid` = 6 
 LIMIT 1

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_pageconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_phraserangename_lang_type,languageidname_lang_type195 6Using index condition

					
					

				

				
				

					
SQL Query #32

					
SELECT * FROM hmq_page
 WHERE `pageid` = 5 
 LIMIT 1

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_pageconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_phraserangename_lang_type,languageidname_lang_type195 6Using index condition

					
					

				

				
				

					
SQL Query #34

					
SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vbPre_conversation67.51.18.29029') 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_cacheconstPRIMARYPRIMARY66const1 

					
					

				

				
				

					
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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpageconstPRIMARYPRIMARY4const1 
1SIMPLEpagetemplateconstPRIMARYPRIMARY4const1 
1SIMPLEscreenlayoutconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_phraserangename_lang_type,languageidname_lang_type195 6Using index condition

					
					

				

				
				

					
SQL Query #38

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_templateconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #39

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_widgetinstancerangepagetemplateidpagetemplateid4 4Using 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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEwidgetdefinitionrangewidgetidwidgetid4 17Using index condition
1SIMPLEwidgeteq_refPRIMARYPRIMARY4alnadawi_vb.widgetdefinition.widgetid1 

					
					

				

				
				

					
SQL Query #41

					
SELECT * FROM hmq_widgetinstance
 WHERE `widgetinstanceid` IN (20,18,19) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_widgetinstancerangePRIMARYPRIMARY4 3Using where

					
					

				

				
				

					
SQL Query #42

					
SELECT * FROM hmq_widget
 WHERE `widgetid` IN (0,190,213,236) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_widgetrangePRIMARYPRIMARY4 4Using where

					
					

				

				
				

					
SQL Query #43

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_moderatorrefuserid_nodeiduserid_nodeid4const1Using index

					
					

				

				
				

					
SQL Query #44

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_datastoreconstPRIMARYPRIMARY52const1 

					
					

				

				
				

					
SQL Query #45

					
SELECT * FROM hmq_widgetchannelconfig
 WHERE `widgetinstanceid` = 20 AND `nodeid` = 18 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

					
					

				

				
				

					
SQL Query #46

					
SELECT * FROM hmq_widgetchannelconfig
 WHERE `widgetinstanceid` = 18 AND `nodeid` = 18 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

					
					

				

				
				

					
SQL Query #47

					
SELECT * FROM hmq_widgetchannelconfig
 WHERE `widgetinstanceid` = 19 AND `nodeid` = 18 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

					
					

				

				
				

					
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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_phraserangename_lang_type,languageidname_lang_type195 15Using index condition

					
					

				

				
				

					
SQL Query #49

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_pagetemplateconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #50

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_screenlayoutconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #51

					
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
 WHERE `templateid` IN (10738,10592,10751) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_templaterangePRIMARYPRIMARY4 3Using index condition

					
					

				

				
				

					
SQL Query #52

					
SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('node_29029_lvl3data') 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_cacheconstPRIMARYPRIMARY66const1 

					
					

				

				
				

					
SQL Query #53

					
SELECT * FROM hmq_closure
 WHERE `child` IN (29029) 
 ORDER BY `child` ASC, `depth` ASC

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_closurerefchildchild4const5Using where

					
					

				

				
				

					
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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_phraserangename_lang_type,languageidname_lang_type195 51Using index condition

					
					

				

				
				

					
SQL Query #55

					
SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vb_UserWPerms_1876_5') 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

					
					

				

				
				

					
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 (1876)
					/** fetchUserinfo **/
			

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserconstPRIMARYPRIMARY4const1 
1SIMPLEuserfieldconstPRIMARYPRIMARY4const1 
1SIMPLEusertextfieldconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #57

					
SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vBUserRep_1876') 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_cacheconstPRIMARYPRIMARY66const1 

					
					

				

				
				

					
SQL Query #58

					
SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vBAtchmnts_29029') 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_cacheconstPRIMARYPRIMARY66const1 

					
					

				

				
				

					
SQL Query #59

					
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 (1876,2190)
/**fetchAvatarsForUsers**/

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEavatarsystemPRIMARY   0Const row not found
1SIMPLEuserrangePRIMARYPRIMARY4 2Using index condition
1SIMPLEcustomavatareq_refPRIMARYPRIMARY4alnadawi_vb.user.userid1 

					
					

				

				
				

					
SQL Query #60

					
SELECT * FROM hmq_site
 LIMIT 1

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_siteALL    1 

					
					

				

				
				

					
SQL Query #61

					
SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vBAtchmnts_18') 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_cacheconstPRIMARYPRIMARY66const1 

					
					

				

				
				

					
SQL Query #62

					
SELECT user.userid, avatar.avatarid, avatar.avatarpath, user.avatarrevision,
					customavatar.dateline, customavatar.width, customavatar.height, customavatar.height_thumb, customavatar.width_thumb, customavatar.filename
			FROM 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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEavatarsystemPRIMARY   0Const row not found
1SIMPLEuserrangePRIMARYPRIMARY4 2Using index condition
1SIMPLEcustomavatareq_refPRIMARYPRIMARY4alnadawi_vb.user.userid1 

					
					

				

				
				

					
SQL Query #63

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_channelrangeguidguid151 5Using index condition

					
					

				

				
				

					
SQL Query #64

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_cacheconstPRIMARYPRIMARY66const1 

					
					

				

				
				

					
SQL Query #65

					
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
 WHERE `templateid` IN (10759,10634,10635,10597,10761) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_templaterangePRIMARYPRIMARY4 5Using index condition

					
					

				

				
				

					
SQL Query #66

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_templateconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #67

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

					
					

				

				
				

					
SQL Query #68

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_templateconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #69

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_templateconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #70

					
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
 WHERE `templateid` IN (10660,10698) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_templaterangePRIMARYPRIMARY4 2Using index condition

					
					

				

				
				

					
SQL Query #71

					
SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vB_Announcements_18') 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_cacheconstPRIMARYPRIMARY66const1 

					
					

				

				
				

					
SQL Query #72

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_templateconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #73

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_templateconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #74

					
SELECT * FROM hmq_searchlog
 WHERE `searchhash` IN ('0c8c068f2c1205ad0eef7825b4d3cc4e') AND `userid` = 0  AND `dateline` >= 1783409741  AND `sortby` = 'isstarter'  AND `sortorder` = 'desc'  
 ORDER BY `dateline` DESC

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_searchlogref|filtersearch,userfloodcheck,datelinesearch|dateline56|4const,const,const,const112 (0%)Using index condition; Using where; Using filesort; Using rowid filter

					
					

				

				
				

					
SQL Query #75

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_cacheconstPRIMARYPRIMARY66const1 

					
					

				

				
				

					
SQL Query #76

					
SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('getSearchResults_d35bb1b10b9f190223e583d4c3786946') 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_cacheconstPRIMARYPRIMARY66const1 

					
					

				

				
				

					
SQL Query #77

					
			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 = '29029' 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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEclosurerefclosure_uniq,parent_2,childclosure_uniq4const595Using where; Using temporary; Using filesort
1SIMPLEnodeeq_refPRIMARY,node_user,node_starter,node_ppreview,node_showapproved,nodeid,ppreview,node_inlist,showpublishedPRIMARY4alnadawi_vb.closure.child1Using where
1SIMPLEstartereq_refPRIMARY,nodeidPRIMARY4alnadawi_vb.node.starter1Using where

					
					

				

				
				

					
SQL Query #78

					
			REPLACE INTO hmq_searchlog
				(type,userid,ipaddress,searchhash,sortby,sortorder,searchtime,dateline,json,results,results_count)
			VALUES
				('0','0','216.73.216.63','0c8c068f2c1205ad0eef7825b4d3cc4e','isstarter','desc','0.0095961093902588','1783409801','{\"sort\":{\"created\":\"ASC\"},\"channel\":\"29029\",\"depth\":1,\"include_starter\":1,\"ignore_protected\":1,\"nolimit\":1}','29029,828906,828950,828958,829019,829023,829086,829110,829144,829228,829446,829482,829593,829621,829646,829670,829723,829774,829781,829963,829975,830033,830055,830101,830118,830121,830134,830140,830141,830229,830232,830234,830237,830241,830242,830243,830246,830248,830249,830250,830256,830434,830480,830485,830490,830554,830615,830682,830699,830710,830715,830729,830732,830737,830738,830740,830741,830749,830753,830839,830853,830880,830884,830931,831036,831077,831081,831087,831095,831098,831099,831107,831158,833947,834130,834228,834236,834333,835158,842361,845627,845660,846533,846916,878911,878940,879177,879218,879230,879237,879238,879244,879263,879276,879414,879424,879451,879452,879465,879540,879565,879566,879567,879723,879728,879730,879751,879755,879760,879785,879817,880161,883063,883543,883559,883560,883562,883566,883574,883580,883588,883591,883598,883602,883840,883842,883848,883849,883851,883855,883859,883866,883874,884076,884083,884125,884245,886063,887905,892936,892943,892948,892952,892967,892974,892977,893246,893337,893418,893536,893545,893548,893554,893561,893562,893601,893608,893731,893805,893829,894232,894335,895978,899951,899953,900037,900265,900302,902391,902467,902471,902491,903080,903132,928252,928265,928288,928294,928320,928541,928718,928731,928748,929028,929062,929083,929119,929251,929550,929585,929611,932339,932373,932507,932734,932933,932936,932954,949418,949790,949865,949878,949955,951936,951982,1005980,1006005,1006036,1006059,1006062,1006073,1025433,1025465,1025469,1025470,1025477,1025478,1025481,1025483,1025488,1025493,1025504,1025512,1025525,1025528,1025540,1025547,1025602,1025642,1025647,1025648,1025651,1025652,1025655,1025657,1025660,1025661,1025662,1025663,1025665,1025667,1025668,1025670,1025674,1025676,1025678,1025680,1025681,1025682,1025685,1025688,1025689,1025691,1025695,1025710,1025737,1025763,1025850,1025919,1025942,1025965,1025979,1025983,1026021,1026035,1026037,1026040,1026049,1026061,1026063,1026066,1026073,1026140,1026271,1026286,1026290,1026307,1026315,1026321,1026333,1026336,1026337,1026340,1026342,1026343,1026344,1026347,1026350,1026353,1026432,1026442,1026502,1026614,1026679,1026709,1026719,1026743,1026850,1027011,1027047,1027074,1027084,1027087,1027095,1027142,1027150,1027163,1027164,1027166,1027167,1027168,1027169,1027171,1027172,1027174,1027177,1027179,1027181,1027183,1027185,1027187,1027192,1027197,1027199,1027202,1027204,1027213,1027223,1027238,1027243,1027245,1027257,1027272,1027282,1027292,1027313,1027388,1027420,1027428,1027462,1027577,1027612,1027648,1027671,1027699,1027782,1027819,1027826,1027827,1027844,1027913,1027943,1027949,1027966,1030485,1030492,1030495,1030498,1030499,1030501,1030502,1030508,1030526,1030528,1030535,1030538,1030643,1030801,1031052,1031054,1031060,1031063,1031101,1031104,1031108,1031112,1031188,1031190,1031191,1031195,1031196,1031201,1031229,1031250,1031289,1031418,1031542,1031561,1031657,1031663,1031769,1031771,1031798,1031896,1031974,1031978,1032023,1032209,1032213,1032259,1032295,1032301,1032304,1032314,1032333,1032334,1032336,1032337,1032339,1032340,1032343,1032345,1032353,1032355,1032356,1032360,1032407,1032444,1032466,1032472,1033076,1033132,1033213,1033610,1033616,1033626,1033884,1033895,1033946,1033953,1033966,1033974,1033982,1033993,1034009,1034043,1034126,1034156,1034173,1034176,1034290,1034293,1034334,1034336,1034526,1034564,1034589,1034602,1034624,1034629,1034631,1034632,1034760,1034785,1034794,1034795,1034797,1034801,1034803,1034868,1034906,1035019,1035057,1035060,1035093,1035107,1035120,1035122,1035124,1035162,1035164,1035228,1035335,1035369,1035500,1035511,1035558,1035632,1035644,1035975,1039160,1039168,1039210,1039220,1039316,1039413,1039894,1039896,1039898,1039909,1039953,1040098,1040174,1040335,1040359,1040390,1040393,1040397,1040400,1040409,1040742,1040949,1041286,1041350,1041469,1041480,1041482,1041559,1042745,1043133,1043717,1043886,1047413,1048491,1049730,1052562,1058836,1060485,1060619,1060620,1060623,1063428,1063478,1063482,1063483,1064100,1064102,1064104,1064106,1064108,1064113,1064116,1064125,1064157,1064164,1064168,1064205,1064214,1064241,1064251,1064258,1064268,1064285,1064497,1064499,1064511,1064512,1064513,1064515,1064518,1064645,1064656,1064661,1064665,1064674,1064751,1065237,1067138,1067522,1067583,1072126,1073268,1073279,1073325,1073413,1073574,1073582,1075204,1075503,1075508,1075519,1075530,1075550,1076478,1076658,1076706,1080272,1080415,1080598,1081010,1081259,1088247,1088401,1088443,1088573,1091192,1091560,1092626,1096489,1096490,1130476,1130496,1130749,1131881','594')
		

					
					
					

				

				
				

					
SQL Query #79

					
SELECT * FROM hmq_searchlog
 WHERE `searchlogid` = 112253274 
 LIMIT 1

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_searchlogconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #80

					
SELECT * FROM hmq_page
 WHERE `pageid` = 12 
 LIMIT 1

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_pageconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #81

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_phraserangename_lang_type,languageidname_lang_type195 6Using index condition

					
					

				

				
				

					
SQL Query #82

					
SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('node_1026344_lvl1data','node_1026347_lvl1data','node_1026350_lvl1data','node_1026353_lvl1data','node_1026432_lvl1data','node_1026442_lvl1data','node_1026502_lvl1data','node_1026614_lvl1data','node_1026679_lvl1data','node_1026709_lvl1data','node_1026719_lvl1data','node_1026743_lvl1data','node_1026850_lvl1data','node_1027011_lvl1data','node_1027047_lvl1data') 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_cacherangePRIMARYPRIMARY66 15Using where

					
					

				

				
				

					
SQL Query #83

					
SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vb_UserWPerms_1839_5','vb_UserWPerms_1952_5','vb_UserWPerms_2007_5','vb_UserWPerms_1997_5','vb_UserWPerms_2069_5','vb_UserWPerms_2046_5') 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_cacherangePRIMARYPRIMARY66 6Using where

					
					

				

				
				

					
SQL Query #84

					
				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 (1839,1952,2007,1997,2069,2046)
					/** fetchUserinfo **/
			

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserrangePRIMARYPRIMARY4 6Using index condition
1SIMPLEuserfieldeq_refPRIMARYPRIMARY4alnadawi_vb.user.userid1 
1SIMPLEusertextfieldeq_refPRIMARYPRIMARY4alnadawi_vb.user.userid1 

					
					

				

				
				

					
SQL Query #85

					
SELECT * FROM hmq_routenew
 WHERE `routeid` IN (67) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_routenewconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #86

					
SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vBAtchmnts_1026344','vBAtchmnts_1026347','vBAtchmnts_1026350','vBAtchmnts_1026353','vBAtchmnts_1026432','vBAtchmnts_1026442','vBAtchmnts_1026502','vBAtchmnts_1026614','vBAtchmnts_1026679','vBAtchmnts_1026709','vBAtchmnts_1026719','vBAtchmnts_1026743','vBAtchmnts_1026850','vBAtchmnts_1027011','vBAtchmnts_1027047') 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_cacherangePRIMARYPRIMARY66 15Using where

					
					

				

				
				

					
SQL Query #87

					
				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 (1026344,1026347,1026350,1026353,1026432,1026442,1026502,1026614,1026679,1026709,1026719,1026743,1026850,1027011,1027047)
				GROUP BY cl.parent
			
/**getDescendantAttachCount**/

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEclrangeclosure_uniq,parent_2,childparent_24 15Using where; Using index
1SIMPLEaeq_refPRIMARYPRIMARY4alnadawi_vb.cl.child1Using index

					
					

				

				
				

					
SQL Query #88

					
				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 (1026344,1026347,1026350,1026353,1026432,1026442,1026502,1026614,1026679,1026709,1026719,1026743,1026850,1027011,1027047) AND child.contenttypeid = 23
				GROUP BY cl.parent
			
/**getDescendantPhotoCount**/

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEclrangeclosure_uniq,parent_2,childparent_24 15Using where; Using index
1SIMPLEchildrefnode_ctypid_userid_dispo_idx,nodeidnodeid6alnadawi_vb.cl.child,const1Using index

					
					

				

				
				

					
SQL Query #89

					
SELECT * FROM hmq_closure
 WHERE `child` IN (1026344,1026347,1026350,1026353,1026432,1026442,1026502,1026614,1026679,1026709,1026719,1026743,1026850,1027011,1027047) 
 ORDER BY `child` ASC, `depth` ASC

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_closurerangechildchild4 90Using index condition

					
					

				

				
				

					
SQL Query #90

					
SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('node_1026344_lvl3data','node_1026347_lvl3data','node_1026350_lvl3data','node_1026353_lvl3data','node_1026432_lvl3data','node_1026442_lvl3data','node_1026502_lvl3data','node_1026614_lvl3data','node_1026679_lvl3data','node_1026709_lvl3data','node_1026719_lvl3data','node_1026743_lvl3data','node_1026850_lvl3data','node_1027011_lvl3data','node_1027047_lvl3data') 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_cacherangePRIMARYPRIMARY66 15Using where

					
					

				

				
				

					
SQL Query #91

					
SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vB_UserPerms1839') 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_cacheconstPRIMARYPRIMARY66const1 

					
					

				

				
				

					
SQL Query #92

					
SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vB_UserPerms2007') 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_cacheconstPRIMARYPRIMARY66const1 

					
					

				

				
				

					
SQL Query #93

					
SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vB_UserPerms2069') 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_cacheconstPRIMARYPRIMARY66const1 

					
					

				

				
				

					
SQL Query #94

					
SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vB_UserPerms2046') 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_cacheconstPRIMARYPRIMARY66const1 

					
					

				

				
				

					
SQL Query #95

					
SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vBUserRep_1839','vBUserRep_1952','vBUserRep_2007','vBUserRep_1997','vBUserRep_2069','vBUserRep_2046') 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_cacherangePRIMARYPRIMARY66 6Using where

					
					

				

				
				

					
SQL Query #96

					
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 (1839,1952,2007,1997,2069,2046)
/**fetchAvatarsForUsers**/

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEavatarsystemPRIMARY   0Const row not found
1SIMPLEuserrangePRIMARYPRIMARY4 6Using index condition
1SIMPLEcustomavatareq_refPRIMARYPRIMARY4alnadawi_vb.user.userid1 

					
					

				

				
				

					
SQL Query #97

					
SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vbSig_1839','vbSig_2007') 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_cacherangePRIMARYPRIMARY66 2Using where

					
					

				

				
				

					
SQL Query #98

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_datastoreconstPRIMARYPRIMARY52const1 

					
					

				

				
				

					
SQL Query #99

					
SELECT * FROM hmq_bbcode

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_bbcodesystem    0Const row not found

					
					

				

				
				

					
SQL Query #100

					
SELECT * FROM hmq_channel
 WHERE `nodeid` = 18 
 LIMIT 1

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_channelconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #101

					
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
 WHERE `templateid` IN (10282,10420,10485) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_templaterangePRIMARYPRIMARY4 3Using index condition

					
					

				

				
				

					
SQL Query #102

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_templateconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #103

					
SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('pageNav_20_40') 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_cacheconstPRIMARYPRIMARY66const1 

					
					

				

				
				

					
SQL Query #104

					
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
 WHERE `templateid` IN (10444,10443) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_templaterangePRIMARYPRIMARY4 2Using index condition

					
					

				

				
				

					
SQL Query #105

					
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
 WHERE `templateid` IN (10283,10450,10409) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_templaterangePRIMARYPRIMARY4 3Using index condition

					
					

				

				
				

					
SQL Query #106

					
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
 WHERE `templateid` IN (10497,10281) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_templaterangePRIMARYPRIMARY4 2Using index condition

					
					

				

				
				

					
SQL Query #107

					
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
 WHERE `templateid` IN (10280,10279,10402) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_templaterangePRIMARYPRIMARY4 3Using index condition

					
					

				

				
				

					
SQL Query #108

					
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','last_edited_by_x_on_y_at_z','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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_phraserangename_lang_type,languageidname_lang_type195 231Using index condition

					
					

				

				
				

					
SQL Query #109

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_routenewrangePRIMARYPRIMARY4 2Using where

					
					

				

				
				

					
SQL Query #110

					
SELECT * FROM hmq_page
 WHERE `pageid` = 120 
 LIMIT 1

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_pageconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #111

					
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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_phraserangename_lang_type,languageidname_lang_type195 6Using index condition

					
					

				

				
				

					
SQL Query #112

					
SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vbnodetext1026344_14_5:09f14d73cd828b8c283774e754116338','vbnodetext1026347_14_5:09f14d73cd828b8c283774e754116338','vbnodetext1026350_14_5:09f14d73cd828b8c283774e754116338','vbnodetext1026353_14_5:09f14d73cd828b8c283774e754116338','vbnodetext1026432_14_5:09f14d73cd828b8c283774e754116338','vbnodetext1026442_14_5:09f14d73cd828b8c283774e754116338','vbnodetext1026502_14_5:09f14d73cd828b8c283774e754116338','vbnodetext1026614_14_5:09f14d73cd828b8c283774e754116338','vbnodetext1026679_14_5:09f14d73cd828b8c283774e754116338','vbnodetext1026709_14_5:09f14d73cd828b8c283774e754116338','vbnodetext1026719_14_5:09f14d73cd828b8c283774e754116338','vbnodetext1026743_14_5:09f14d73cd828b8c283774e754116338','vbnodetext1026850_14_5:09f14d73cd828b8c283774e754116338','vbnodetext1027011_14_5:09f14d73cd828b8c283774e754116338','vbnodetext1027047_14_5:09f14d73cd828b8c283774e754116338') 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_cacherangePRIMARYPRIMARY66 15Using where

					
					

				

				
				

					
SQL Query #113

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_templateconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #114

					
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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhmq_phraserangename_lang_type,languageidname_lang_type195 75Using index condition

					
					

				

				
5 Slowest Queries

					

						SQL Query #82
						Time Taken: 0.028382062911987
						Memory Used: 0
					


					
SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('node_1026344_lvl1data','node_1026347_lvl1data','node_1026350_lvl1data','node_1026353_lvl1data','node_1026432_lvl1data','node_1026442_lvl1data','node_1026502_lvl1data','node_1026614_lvl1data','node_1026679_lvl1data','node_1026709_lvl1data','node_1026719_lvl1data','node_1026743_lvl1data','node_1026850_lvl1data','node_1027011_lvl1data','node_1027047_lvl1data') 

				
					

						SQL Query #90
						Time Taken: 0.025585889816284
						Memory Used: 0
					


					
SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('node_1026344_lvl3data','node_1026347_lvl3data','node_1026350_lvl3data','node_1026353_lvl3data','node_1026432_lvl3data','node_1026442_lvl3data','node_1026502_lvl3data','node_1026614_lvl3data','node_1026679_lvl3data','node_1026709_lvl3data','node_1026719_lvl3data','node_1026743_lvl3data','node_1026850_lvl3data','node_1027011_lvl3data','node_1027047_lvl3data') 

				
					

						SQL Query #88
						Time Taken: 0.022783041000366
						Memory Used: 0
					


					
				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 (1026344,1026347,1026350,1026353,1026432,1026442,1026502,1026614,1026679,1026709,1026719,1026743,1026850,1027011,1027047) AND child.contenttypeid = 23
				GROUP BY cl.parent
			
/**getDescendantPhotoCount**/

				
					

						SQL Query #86
						Time Taken: 0.021589994430542
						Memory Used: 0
					


					
SELECT * FROM hmq_cache
 WHERE `cacheid` IN ('vBAtchmnts_1026344','vBAtchmnts_1026347','vBAtchmnts_1026350','vBAtchmnts_1026353','vBAtchmnts_1026432','vBAtchmnts_1026442','vBAtchmnts_1026502','vBAtchmnts_1026614','vBAtchmnts_1026679','vBAtchmnts_1026709','vBAtchmnts_1026719','vBAtchmnts_1026743','vBAtchmnts_1026850','vBAtchmnts_1027011','vBAtchmnts_1027047') 

				
					

						SQL Query #79
						Time Taken: 0.015664100646973
						Memory Used: 0
					


					
SELECT * FROM hmq_searchlog
 WHERE `searchlogid` = 112253274 
 LIMIT 1

				
114 Queries Run : Total SQL time was 0.306670 seconds , Total PHP time was 0.329913 seconds , Overall time was 0.636583 seconds.