vBulletin - Explain SQL Queries (136)
Duplicate Queries: (Exact textual duplicates, also included in the full listing of queries below)
- Times run: 3
SELECT * FROM hmq_routenew
WHERE `routeid` IN (74)
- Times run: 2
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 (40234)
GROUP BY cl.parent
/**getDescendantAttachCount**/
- Times run: 2
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 (40234) AND child.contenttypeid = 23
GROUP BY cl.parent
/**getDescendantPhotoCount**/
- Times run: 5
SELECT channel.nodeid
FROM hmq_channel AS channel
INNER JOIN hmq_closure AS closure
ON channel.nodeid = closure.child
WHERE closure.parent IN (22)
/**getDescendantChannelsIn**/
SET @@sql_mode = ''
- Time Before: 1765479343.5763
- Time After: 1765479343.5765
- Time Taken: 0.00017213821411133
- Memory Before: 4194304
- Memory After: 4194304
- Memory Used: 0
#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)
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')
- Time Before: 1765479343.5958
- Time After: 1765479343.5961
- Time Taken: 0.0003349781036377
- Memory Before: 6291456
- Memory After: 6291456
- Memory Used: 0
#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)
SELECT * FROM hmq_session
WHERE `sessionhash` = '0f4394167d0ec09511f022bec707c541' AND `lastactivity` > 1765379343
LIMIT 1
- Time Before: 1765479343.6021
- Time After: 1765479343.6025
- Time Taken: 0.00039076805114746
- Memory Before: 6291456
- Memory After: 6291456
- Memory Used: 0
#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('0f4394167d[len:32]', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/session.php(132)
#9 vB_Session->loadExistingSession('0f4394167d[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], '0f4394167d[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], '0f4394167d[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], '0f4394167d[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('0f4394167d[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('0f4394167d[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)
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('13bd7d9a9062e9bc75fb938051d62b32')
- Time Before: 1765479343.6037
- Time After: 1765479343.6043
- Time Taken: 0.00056195259094238
- Memory Before: 6291456
- Memory After: 6291456
- Memory Used: 0
#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('0f4394167d[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)
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_CommonRoutes')
- Time Before: 1765479343.6173
- Time After: 1765479343.6175
- Time Taken: 0.0001368522644043
- Memory Before: 10485760
- Memory After: 10485760
- Memory Used: 0
#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/z8/page160', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#11 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#12 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#13 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#14 vB5_Frontend_Application::init('config.php') in /index.php(48)
SELECT routenew.*
FROM hmq_routenew AS routenew
WHERE routenew.prefix IN ('forum/c1/z8/page160','forum/c1/z8','forum/c1','forum') OR ishomeroute = 1
/**get_best_routes**/
- Time Before: 1765479343.6182
- Time After: 1765479343.6214
- Time Taken: 0.0031821727752686
- Memory Before: 10485760
- Memory After: 10485760
- Memory Used: 0
#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:187]', 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/z8/page160', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#7 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#8 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#9 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#10 vB5_Frontend_Application::init('config.php') in /index.php(48)
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_UserPerms0')
- Time Before: 1765479343.6308
- Time After: 1765479343.6309
- Time Taken: 0.00016498565673828
- Memory Before: 10485760
- Memory After: 10485760
- Memory Used: 0
#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/z8/page160', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#15 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#16 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#17 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#18 vB5_Frontend_Application::init('config.php') in /index.php(48)
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vb_types.types')
- Time Before: 1765479343.653
- Time After: 1765479343.6533
- Time Taken: 0.0002591609954834
- Memory Before: 12582912
- Memory After: 12582912
- Memory Used: 0
#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/node.php(60)
#12 vB_Library_Node->__construct() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library.php(46)
#13 vB_Library::instance('node') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/usercontext.php(534)
#14 vB_UserContext->getChannelLimitPermission('forumpermissions', 'canview', 22, false, false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/usercontext.php(823)
#15 vB_UserContext->getChannelPermission('forumpermissions', 'canview', 22) in /core/vb5/route/channel.php(21)
#16 vB5_Route_Channel->__construct(array[len:14], array[len:3], 'explain=1&[len:21]', '') in /core/vb5/route.php(1168)
#17 vB5_Route::checkRoute(array[len:14], 'forum/c1/z[len:46]', 'forum/c1/z8/page160', 'explain=1&[len:21]', '') in /core/vb5/route.php(1104)
#18 vB5_Route::selectBestRoute('forum/c1/z8/page160', 'explain=1&[len:21]', '', array[len:6]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(159)
#19 vB_Api_Route->getRoute('forum/c1/z8/page160', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#20 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#21 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#22 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#23 vB5_Frontend_Application::init('config.php') in /index.php(48)
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')
- Time Before: 1765479343.6797
- Time After: 1765479343.6798
- Time Taken: 0.00017881393432617
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#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(2222)
#9 vB_Library_Node->fetchVMChannel() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/usercontext.php(534)
#10 vB_UserContext->getChannelLimitPermission('forumpermissions', 'canview', 22, false, false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/usercontext.php(823)
#11 vB_UserContext->getChannelPermission('forumpermissions', 'canview', 22) in /core/vb5/route/channel.php(21)
#12 vB5_Route_Channel->__construct(array[len:14], array[len:3], 'explain=1&[len:21]', '') in /core/vb5/route.php(1168)
#13 vB5_Route::checkRoute(array[len:14], 'forum/c1/z[len:46]', 'forum/c1/z8/page160', 'explain=1&[len:21]', '') in /core/vb5/route.php(1104)
#14 vB5_Route::selectBestRoute('forum/c1/z8/page160', 'explain=1&[len:21]', '', array[len:6]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(159)
#15 vB_Api_Route->getRoute('forum/c1/z8/page160', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#16 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#17 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#18 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#19 vB5_Frontend_Application::init('config.php') in /index.php(48)
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('node_22_lvl1data')
- Time Before: 1765479343.68
- Time After: 1765479343.6804
- Time Taken: 0.0003960132598877
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#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(22) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/node.php(967)
#11 vB_Library_Node->getNode(22) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/usercontext.php(535)
#12 vB_UserContext->getChannelLimitPermission('forumpermissions', 'canview', 22, false, false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/usercontext.php(823)
#13 vB_UserContext->getChannelPermission('forumpermissions', 'canview', 22) in /core/vb5/route/channel.php(21)
#14 vB5_Route_Channel->__construct(array[len:14], array[len:3], 'explain=1&[len:21]', '') in /core/vb5/route.php(1168)
#15 vB5_Route::checkRoute(array[len:14], 'forum/c1/z[len:46]', 'forum/c1/z8/page160', 'explain=1&[len:21]', '') in /core/vb5/route.php(1104)
#16 vB5_Route::selectBestRoute('forum/c1/z8/page160', 'explain=1&[len:21]', '', array[len:6]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(159)
#17 vB_Api_Route->getRoute('forum/c1/z8/page160', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#18 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#19 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#20 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#21 vB5_Frontend_Application::init('config.php') in /index.php(48)
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('channelperms_1')
- Time Before: 1765479343.6805
- Time After: 1765479343.6818
- Time Taken: 0.0012760162353516
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#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', 22) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/usercontext.php(609)
#11 vB_UserContext->getChannelLimitPermission('forumpermissions', 'canview', 22, false, false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/usercontext.php(823)
#12 vB_UserContext->getChannelPermission('forumpermissions', 'canview', 22) in /core/vb5/route/channel.php(21)
#13 vB5_Route_Channel->__construct(array[len:14], array[len:3], 'explain=1&[len:21]', '') in /core/vb5/route.php(1168)
#14 vB5_Route::checkRoute(array[len:14], 'forum/c1/z[len:46]', 'forum/c1/z8/page160', 'explain=1&[len:21]', '') in /core/vb5/route.php(1104)
#15 vB5_Route::selectBestRoute('forum/c1/z8/page160', 'explain=1&[len:21]', '', array[len:6]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(159)
#16 vB_Api_Route->getRoute('forum/c1/z8/page160', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#17 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#18 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#19 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#20 vB5_Frontend_Application::init('config.php') in /index.php(48)
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('node_22_lvl3data')
- Time Before: 1765479343.6819
- Time After: 1765479343.6822
- Time Taken: 0.00029516220092773
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#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(22) in /core/vb5/route/channel.php(26)
#13 vB5_Route_Channel->__construct(array[len:14], array[len:3], 'explain=1&[len:21]', '') in /core/vb5/route.php(1168)
#14 vB5_Route::checkRoute(array[len:14], 'forum/c1/z[len:46]', 'forum/c1/z8/page160', 'explain=1&[len:21]', '') in /core/vb5/route.php(1104)
#15 vB5_Route::selectBestRoute('forum/c1/z8/page160', 'explain=1&[len:21]', '', array[len:6]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(159)
#16 vB_Api_Route->getRoute('forum/c1/z8/page160', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#17 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#18 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#19 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#20 vB5_Frontend_Application::init('config.php') in /index.php(48)
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('node_1_lvl1data')
- Time Before: 1765479343.687
- Time After: 1765479343.6872
- Time Taken: 0.00021481513977051
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#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/z8/page160', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#15 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#16 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#17 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#18 vB5_Frontend_Application::init('config.php') in /index.php(48)
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_NamedRoutes')
- Time Before: 1765479343.6874
- Time After: 1765479343.6875
- Time Taken: 0.00017380714416504
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#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('74') in /core/vb5/route.php(1335)
#11 vB5_Route::getClassName('74', array[len:14]) in /core/vb5/route.php(1350)
#12 vB5_Route::getRoute('74', array[len:1], array[len:2]) in /core/vb5/route/channel.php(432)
#13 vB5_Route_Channel->getCanonicalRoute() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(252)
#14 vB_Api_Route->getRoute('forum/c1/z8/page160', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#15 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#16 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#17 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#18 vB5_Frontend_Application::init('config.php') in /index.php(48)
SELECT * FROM hmq_routenew
WHERE `routeid` = 74
LIMIT 1
- Time Before: 1765479343.6878
- Time After: 1765479343.6879
- Time Taken: 0.00010013580322266
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#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('74') in /core/vb5/route.php(1335)
#9 vB5_Route::getClassName('74', array[len:14]) in /core/vb5/route.php(1350)
#10 vB5_Route::getRoute('74', array[len:1], array[len:2]) in /core/vb5/route/channel.php(432)
#11 vB5_Route_Channel->getCanonicalRoute() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(252)
#12 vB_Api_Route->getRoute('forum/c1/z8/page160', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#13 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#14 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#15 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#16 vB5_Frontend_Application::init('config.php') in /index.php(48)
SELECT * FROM hmq_closure
WHERE `child` IN (22)
ORDER BY `child` ASC, `depth` ASC
- Time Before: 1765479343.6892
- Time After: 1765479343.6894
- Time Taken: 0.0001671314239502
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#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(22) in /core/vb5/route.php(360)
#9 vB5_Route->addParentNodeBreadcrumbs(22) in /core/vb5/route.php(342)
#10 vB5_Route->setBreadcrumbs() in /core/vb5/route/channel.php(75)
#11 vB5_Route_Channel->setBreadCrumbs() in /core/vb5/route.php(418)
#12 vB5_Route->getBreadcrumbs() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(315)
#13 vB_Api_Route->getRoute('forum/c1/z8/page160', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#14 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#15 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#16 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#17 vB5_Frontend_Application::init('config.php') in /index.php(48)
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('node_2_lvl1data','node_14_lvl1data')
- Time Before: 1765479343.6895
- Time After: 1765479343.6896
- Time Taken: 0.00010204315185547
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#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(22) in /core/vb5/route.php(342)
#12 vB5_Route->setBreadcrumbs() in /core/vb5/route/channel.php(75)
#13 vB5_Route_Channel->setBreadCrumbs() in /core/vb5/route.php(418)
#14 vB5_Route->getBreadcrumbs() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(315)
#15 vB_Api_Route->getRoute('forum/c1/z8/page160', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#16 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#17 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#18 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#19 vB5_Frontend_Application::init('config.php') in /index.php(48)
SELECT * FROM hmq_routenew
WHERE `routeid` IN (45,58,74)
- Time Before: 1765479343.6897
- Time After: 1765479343.6898
- Time Taken: 0.00010991096496582
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#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(22) in /core/vb5/route.php(342)
#9 vB5_Route->setBreadcrumbs() in /core/vb5/route/channel.php(75)
#10 vB5_Route_Channel->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/z8/page160', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#13 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#14 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#15 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#16 vB5_Frontend_Application::init('config.php') in /index.php(48)
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('node_2_lvl3data')
- Time Before: 1765479343.6899
- Time After: 1765479343.69
- Time Taken: 6.2942504882812E-5
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#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(22) in /core/vb5/route.php(342)
#16 vB5_Route->setBreadcrumbs() in /core/vb5/route/channel.php(75)
#17 vB5_Route_Channel->setBreadCrumbs() in /core/vb5/route.php(418)
#18 vB5_Route->getBreadcrumbs() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(315)
#19 vB_Api_Route->getRoute('forum/c1/z8/page160', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#20 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#21 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#22 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#23 vB5_Frontend_Application::init('config.php') in /index.php(48)
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('node_14_lvl3data')
- Time Before: 1765479343.6902
- Time After: 1765479343.6904
- Time Taken: 0.00017905235290527
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#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(22) in /core/vb5/route.php(342)
#16 vB5_Route->setBreadcrumbs() in /core/vb5/route/channel.php(75)
#17 vB5_Route_Channel->setBreadCrumbs() in /core/vb5/route.php(418)
#18 vB5_Route->getBreadcrumbs() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(315)
#19 vB_Api_Route->getRoute('forum/c1/z8/page160', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#20 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#21 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#22 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#23 vB5_Frontend_Application::init('config.php') in /index.php(48)
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)
- Time Before: 1765479343.7147
- Time After: 1765479343.7149
- Time Taken: 0.00015401840209961
- Memory Before: 16777216
- Memory After: 16777216
- Memory Used: 0
#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)
SELECT * FROM hmq_style
WHERE `styleid` = 14
LIMIT 1
- Time Before: 1765479343.715
- Time After: 1765479343.7158
- Time Taken: 0.00078892707824707
- Memory Before: 16777216
- Memory After: 16777216
- Memory Used: 0
#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)
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10763)
- Time Before: 1765479343.73
- Time After: 1765479343.7302
- Time Taken: 0.00025200843811035
- Memory Before: 16777216
- Memory After: 16777216
- Memory Used: 0
SELECT * FROM hmq_page
WHERE `pageid` = 3
LIMIT 1
- Time Before: 1765479343.7359
- Time After: 1765479343.736
- Time Taken: 0.00014114379882812
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT `varname`,`languageid`,`text` FROM hmq_phrase
WHERE `varname` IN ('page_4ecbdac82f039695291105_title','page_4ecbdac82f039695291105_metadesc') AND `languageid` IN (5,0,-1)
- Time Before: 1765479343.7386
- Time After: 1765479343.7387
- Time Taken: 0.00013303756713867
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT * FROM hmq_page
WHERE `pageid` = 23
LIMIT 1
- Time Before: 1765479343.7396
- Time After: 1765479343.7397
- Time Taken: 0.0001368522644043
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT `varname`,`languageid`,`text` FROM hmq_phrase
WHERE `varname` IN ('page_4ecbdac82f2c2760323374_title','page_4ecbdac82f2c2760323374_metadesc') AND `languageid` IN (5,0,-1)
- Time Before: 1765479343.7398
- Time After: 1765479343.7399
- Time Taken: 9.7990036010742E-5
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT * FROM hmq_page
WHERE `pageid` = 6
LIMIT 1
- Time Before: 1765479343.74
- Time After: 1765479343.7402
- Time Taken: 0.00016999244689941
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT `varname`,`languageid`,`text` FROM hmq_phrase
WHERE `varname` IN ('page_4ecbdac82f039695291108_title','page_4ecbdac82f039695291108_metadesc') AND `languageid` IN (5,0,-1)
- Time Before: 1765479343.7403
- Time After: 1765479343.7404
- Time Taken: 0.0001220703125
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT * FROM hmq_page
WHERE `pageid` = 5
LIMIT 1
- Time Before: 1765479343.7405
- Time After: 1765479343.7406
- Time Taken: 0.00010299682617188
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT `varname`,`languageid`,`text` FROM hmq_phrase
WHERE `varname` IN ('page_4ecbdac82f039695291107_title','page_4ecbdac82f039695291107_metadesc') AND `languageid` IN (5,0,-1)
- Time Before: 1765479343.7407
- Time After: 1765479343.7408
- Time Taken: 0.00011396408081055
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vbPre_channel74.58.22')
- Time Before: 1765479343.7475
- Time After: 1765479343.7494
- Time Taken: 0.0019760131835938
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('node_40234_lvl1data')
- Time Before: 1765479343.7496
- Time After: 1765479343.7499
- Time Taken: 0.00029993057250977
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vb_UserWPerms_1224_5')
- Time Before: 1765479343.75
- Time After: 1765479343.7516
- Time Taken: 0.0016188621520996
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
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 (1224)
/** fetchUserinfo **/
- Time Before: 1765479343.7521
- Time After: 1765479343.7524
- Time Taken: 0.00028610229492188
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT * FROM hmq_routenew
WHERE `routeid` IN (74)
- Time Before: 1765479343.7525
- Time After: 1765479343.7526
- Time Taken: 0.00012993812561035
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vBAtchmnts_40234')
- Time Before: 1765479343.7532
- Time After: 1765479343.7543
- Time Taken: 0.0011169910430908
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
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 (40234)
GROUP BY cl.parent
/**getDescendantAttachCount**/
- Time Before: 1765479343.7545
- Time After: 1765479343.7546
- Time Taken: 0.00018000602722168
- Memory Before: 18874368
- Memory After: 18874368
- 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 (40234) AND child.contenttypeid = 23
GROUP BY cl.parent
/**getDescendantPhotoCount**/
- Time Before: 1765479343.7547
- Time After: 1765479343.7549
- Time Taken: 0.00017380714416504
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT * FROM hmq_closure
WHERE `child` IN (40234)
ORDER BY `child` ASC, `depth` ASC
- Time Before: 1765479343.755
- Time After: 1765479343.7551
- Time Taken: 9.3936920166016E-5
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('node_40234_lvl3data')
- Time Before: 1765479343.759
- Time After: 1765479343.7593
- Time Taken: 0.00034499168395996
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
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)
- Time Before: 1765479343.7687
- Time After: 1765479343.7689
- Time Taken: 0.00015091896057129
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_UserPerms1224')
- Time Before: 1765479343.7692
- Time After: 1765479343.7695
- Time Taken: 0.00033688545227051
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vBUserRep_1224')
- Time Before: 1765479343.7696
- Time After: 1765479343.77
- Time Taken: 0.00035595893859863
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT user.userid, avatar.avatarid, avatar.avatarpath, user.avatarrevision,
customavatar.dateline, customavatar.width, customavatar.height, customavatar.height_thumb, customavatar.width_thumb, customavatar.filename
FROM hmq_user as user
LEFT JOIN hmq_customavatar AS customavatar ON customavatar.userid = user.userid
LEFT JOIN hmq_avatar AS avatar ON avatar.avatarid = user.avatarid
WHERE user.userid IN (1224,897)
/**fetchAvatarsForUsers**/
- Time Before: 1765479343.7714
- Time After: 1765479343.7716
- Time Taken: 0.00019288063049316
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
- Time Before: 1765479343.7777
- Time After: 1765479343.7789
- Time Taken: 0.0011579990386963
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
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 = 58
/**fetch_page_pagetemplate_screenlayout**/
- Time Before: 1765479343.779
- Time After: 1765479343.7791
- Time Taken: 8.6069107055664E-5
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT `varname`,`languageid`,`text` FROM hmq_phrase
WHERE `varname` IN ('page_54c8a2f63df26904441746_title','page_54c8a2f63df26904441746_metadesc') AND `languageid` IN (5,0,-1)
- Time Before: 1765479343.7792
- Time After: 1765479343.7794
- Time Taken: 0.00016117095947266
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10582)
- Time Before: 1765479343.7799
- Time After: 1765479343.78
- Time Taken: 0.00010085105895996
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_widgetinstance
WHERE `pagetemplateid` IN (2,-1)
ORDER BY `containerinstanceid`,`displaysection`,`displayorder`
- Time Before: 1765479343.7861
- Time After: 1765479343.7863
- Time Taken: 0.00023198127746582
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT widgetdefinition.*, widget.template
FROM hmq_widgetdefinition AS widgetdefinition
JOIN hmq_widget AS widget ON (widgetdefinition.widgetid = widget.widgetid)
WHERE widgetdefinition.widgetid IN(191,189,213,236)
/**getWidgetdefinition**/
- Time Before: 1765479343.7865
- Time After: 1765479343.7866
- Time Taken: 0.00012803077697754
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_widgetinstance
WHERE `widgetinstanceid` IN (13,12,10,11)
- Time Before: 1765479343.7868
- Time After: 1765479343.7869
- Time Taken: 0.0001060962677002
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_widget
WHERE `widgetid` IN (0,191,189,213,236)
- Time Before: 1765479343.787
- Time After: 1765479343.787
- Time Taken: 6.2227249145508E-5
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT COUNT(*) AS count FROM hmq_moderator
WHERE `userid` = 0
- Time Before: 1765479343.7893
- Time After: 1765479343.7895
- Time Taken: 0.00013089179992676
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_datastore
WHERE `title` IN ('vBUgChannelAccessG1')
- Time Before: 1765479343.7895
- Time After: 1765479343.7896
- Time Taken: 9.8943710327148E-5
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_widgetchannelconfig
WHERE `widgetinstanceid` = 13 AND `nodeid` = 22
- Time Before: 1765479343.7898
- Time After: 1765479343.7899
- Time Taken: 9.9897384643555E-5
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_widgetchannelconfig
WHERE `widgetinstanceid` = 12 AND `nodeid` = 22
- Time Before: 1765479343.79
- Time After: 1765479343.79
- Time Taken: 5.2928924560547E-5
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_widgetchannelconfig
WHERE `widgetinstanceid` = 10 AND `nodeid` = 22
- Time Before: 1765479343.7901
- Time After: 1765479343.7903
- Time Taken: 0.00019407272338867
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_widgetchannelconfig
WHERE `widgetinstanceid` = 11 AND `nodeid` = 22
- Time Before: 1765479343.7904
- Time After: 1765479343.7905
- Time Taken: 0.00010204315185547
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT `varname`,`languageid`,`text` FROM hmq_phrase
WHERE `varname` IN ('widget_subchannelsdisplay_widgettitle','system_widgetcat','widget_channeldisplay_widgettitle','widget_announcement_widgettitle','display_widgetcat','widget_pagetitle_widgettitle') AND `languageid` IN (5,0,-1)
- Time Before: 1765479343.7906
- Time After: 1765479343.7907
- Time Taken: 9.9897384643555E-5
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_pagetemplate
WHERE `pagetemplateid` = 2
LIMIT 1
- Time Before: 1765479343.7908
- Time After: 1765479343.7908
- Time Taken: 5.4836273193359E-5
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT * FROM hmq_screenlayout
WHERE `screenlayoutid` = 1
LIMIT 1
- Time Before: 1765479343.7909
- Time After: 1765479343.7909
- Time Taken: 4.6014785766602E-5
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10738,10592,10751)
- Time Before: 1765479343.7912
- Time After: 1765479343.7914
- Time Taken: 0.00022101402282715
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vBAtchmnts_22')
- Time Before: 1765479343.7938
- Time After: 1765479343.7941
- Time Taken: 0.0002589225769043
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT user.userid, avatar.avatarid, avatar.avatarpath, user.avatarrevision,
customavatar.dateline, customavatar.width, customavatar.height, customavatar.height_thumb, customavatar.width_thumb, customavatar.filename
FROM hmq_user as user
LEFT JOIN hmq_customavatar AS customavatar ON customavatar.userid = user.userid
LEFT JOIN hmq_avatar AS avatar ON avatar.avatarid = user.avatarid
WHERE user.userid IN (1,2570)
/**fetchAvatarsForUsers**/
- Time Before: 1765479343.7942
- Time After: 1765479343.7943
- Time Taken: 9.608268737793E-5
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT * FROM hmq_routenew
WHERE `class` IN ('vB5_Route_Conversation','vB5_Route_Article') AND `contentid` = 22 AND `redirect301` IS NULL
LIMIT 1
- Time Before: 1765479343.7946
- Time After: 1765479343.7947
- Time Taken: 0.00010800361633301
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT * FROM hmq_site
LIMIT 1
- Time Before: 1765479343.8006
- Time After: 1765479343.8007
- Time Taken: 0.00010800361633301
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT * FROM hmq_channel
WHERE `guid` IN ('vbulletin-4ecbdf567f2c35.70389590','vbulletin-4ecbdf567f3a38.99555305','vbulletin-4ecbdf567f3a38.99555306','vbulletin-c-cmshome5229fa38b251e2.92227401','vbulletin-4ecbdf567f3341.44451100')
- Time Before: 1765479343.8013
- Time After: 1765479343.8014
- Time Taken: 0.0001370906829834
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('node_1_lvl3data')
- Time Before: 1765479343.8015
- Time After: 1765479343.8017
- Time Taken: 0.00011014938354492
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10759,10634,10635,10597,10761)
- Time Before: 1765479343.8027
- Time After: 1765479343.8028
- Time Taken: 0.0001220703125
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10480)
- Time Before: 1765479343.8059
- Time After: 1765479343.806
- Time Taken: 0.00010800361633301
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT `noticeid` FROM hmq_noticedismissed
WHERE `userid` = 0
- Time Before: 1765479343.8092
- Time After: 1765479343.8093
- Time Taken: 9.7990036010742E-5
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10594)
- Time Before: 1765479343.8101
- Time After: 1765479343.8102
- Time Taken: 0.00011110305786133
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10595)
- Time Before: 1765479343.8106
- Time After: 1765479343.8107
- Time Taken: 0.00010800361633301
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10660,10698)
- Time Before: 1765479343.8114
- Time After: 1765479343.8116
- Time Taken: 0.00012993812561035
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_Announcements_22')
- Time Before: 1765479343.8122
- Time After: 1765479343.8124
- Time Taken: 0.00022602081298828
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10739)
- Time Before: 1765479343.8125
- Time After: 1765479343.8128
- Time Taken: 0.00025296211242676
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10726,10673)
- Time Before: 1765479343.8144
- Time After: 1765479343.8147
- Time Taken: 0.00026607513427734
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_ChannelTreeRaw_0')
- Time Before: 1765479343.8158
- Time After: 1765479343.8161
- Time Taken: 0.00027108192443848
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_ChTreeWithLast')
- Time Before: 1765479343.8163
- Time After: 1765479343.822
- Time Taken: 0.005713939666748
- Memory Before: 25165824
- Memory After: 25165824
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10446)
- Time Before: 1765479343.8226
- Time After: 1765479343.8228
- Time Taken: 0.00017285346984863
- Memory Before: 25165824
- Memory After: 25165824
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10448)
- Time Before: 1765479343.8231
- Time After: 1765479343.8233
- Time Taken: 0.00020599365234375
- Memory Before: 25165824
- Memory After: 25165824
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10447)
- Time Before: 1765479343.8239
- Time After: 1765479343.8241
- Time Taken: 0.00013494491577148
- Memory Before: 25165824
- Memory After: 25165824
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10746)
- Time Before: 1765479343.8253
- Time After: 1765479343.8255
- Time Taken: 0.00018906593322754
- Memory Before: 25165824
- Memory After: 25165824
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vb_readperms')
- Time Before: 1765479343.8374
- Time After: 1765479343.8381
- Time Taken: 0.00070786476135254
- Memory Before: 25165824
- Memory After: 25165824
- Memory Used: 0
SELECT channel.nodeid
FROM hmq_channel AS channel
INNER JOIN hmq_closure AS closure
ON channel.nodeid = closure.child
WHERE closure.parent IN (22)
/**getDescendantChannelsIn**/
- Time Before: 1765479343.8438
- Time After: 1765479343.8439
- Time Taken: 0.00011086463928223
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT node.starter AS nodeid
FROM hmq_node as node
IGNORE INDEX (node_lastcontent)
WHERE node.starter = node.nodeid AND
node.sticky = '1' AND
node.contenttypeid <> 19 AND
node.parentid = 22 AND
node.starter > 0 AND
node.showpublished = 1 AND
node.showapproved = 1 AND
node.viewperms = 2 AND
node.inlist = 1 AND
node.protected <> '1'
ORDER BY node.lastcontent DESC
LIMIT 0, 999
/**getSearchResults**/
- Time Before: 1765479343.844
- Time After: 1765479343.8441
- Time Taken: 9.8943710327148E-5
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_routenew
WHERE `routeid` IN (74)
- Time Before: 1765479343.8443
- Time After: 1765479343.8444
- Time Taken: 0.00019192695617676
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
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 (40234)
GROUP BY cl.parent
/**getDescendantAttachCount**/
- Time Before: 1765479343.8446
- Time After: 1765479343.8447
- Time Taken: 0.00011587142944336
- Memory Before: 27262976
- Memory After: 27262976
- 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 (40234) AND child.contenttypeid = 23
GROUP BY cl.parent
/**getDescendantPhotoCount**/
- Time Before: 1765479343.8447
- Time After: 1765479343.8448
- Time Taken: 0.00011610984802246
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT channel.nodeid
FROM hmq_channel AS channel
INNER JOIN hmq_closure AS closure
ON channel.nodeid = closure.child
WHERE closure.parent IN (22)
/**getDescendantChannelsIn**/
- Time Before: 1765479343.8457
- Time After: 1765479343.8459
- Time Taken: 0.00010991096496582
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT node.starter AS nodeid
FROM hmq_node as node
IGNORE INDEX (node_lastcontent)
WHERE node.starter = node.nodeid AND
node.sticky <> '1' AND
node.contenttypeid <> 19 AND
node.parentid = 22 AND
node.starter > 0 AND
node.showpublished = 1 AND
node.showapproved = 1 AND
node.viewperms = 2 AND
node.inlist = 1 AND
node.protected <> '1'
ORDER BY node.lastcontent DESC
LIMIT 1590, 10
/**getSearchResults**/
- Time Before: 1765479343.846
- Time After: 1765479343.852
- Time Taken: 0.0060050487518311
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('node_10406_lvl1data','node_10095_lvl1data','node_10119_lvl1data','node_8610_lvl1data','node_10333_lvl1data','node_10296_lvl1data','node_9955_lvl1data','node_10303_lvl1data','node_10010_lvl1data','node_10129_lvl1data')
- Time Before: 1765479343.8521
- Time After: 1765479343.853
- Time Taken: 0.00086116790771484
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT node.*, editlog.reason AS edit_reason, editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline, editlog.hashistory, 0 AS nodeVoted, 0 AS readtime
FROM hmq_node AS node
LEFT JOIN hmq_editlog AS editlog ON (editlog.nodeid = node.nodeid)
WHERE node.nodeid IN (10095,10333,10296,9955,10010)
/**fetchNodeWithContent**/
- Time Before: 1765479343.8533
- Time After: 1765479343.857
- Time Taken: 0.0037758350372314
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vb_UserWPerms_995_5','vb_UserWPerms_1055_5','vb_UserWPerms_655_5','vb_UserWPerms_90_5','vb_UserWPerms_604_5','vb_UserWPerms_1009_5','vb_UserWPerms_917_5','vb_UserWPerms_1010_5')
- Time Before: 1765479343.8572
- Time After: 1765479343.8582
- Time Taken: 0.00099277496337891
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
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 (995,1055,655,90,604,1009,917,1010)
/** fetchUserinfo **/
- Time Before: 1765479343.8583
- Time After: 1765479343.8592
- Time Taken: 0.00093817710876465
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_routenew
WHERE `routeid` IN (74)
- Time Before: 1765479343.8595
- Time After: 1765479343.8597
- Time Taken: 0.00024104118347168
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vBAtchmnts_10406','vBAtchmnts_10095','vBAtchmnts_10119','vBAtchmnts_8610','vBAtchmnts_10333','vBAtchmnts_10296','vBAtchmnts_9955','vBAtchmnts_10303','vBAtchmnts_10010','vBAtchmnts_10129')
- Time Before: 1765479343.8598
- Time After: 1765479343.8604
- Time Taken: 0.0005950927734375
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
(
SELECT
a.filedataid,
n.nodeid, n.parentid, n.contenttypeid,
a.visible, a.counter, a.posthash, a.filename, a.reportthreadid, a.settings,
NULL AS height, NULL AS width, NULL AS style,
a.caption,
n.displayorder
FROM hmq_node AS n USE INDEX (contenttypeid_parentid)
JOIN hmq_attach AS a ON (a.nodeid = n.nodeid)
WHERE n.contenttypeid = 24 AND n.parentid IN (10095,10333,10296,9955,10010)
)
UNION ALL
(
SELECT
p.filedataid,
n.nodeid, n.parentid, n.contenttypeid,
NULL AS visible, NULL AS counter, NULL AS posthash, NULL AS filename, NULL AS reportthreadid, NULL AS settings,
p.height, p.width, p.style,
p.caption,
n.displayorder
FROM hmq_node AS n USE INDEX (contenttypeid_parentid)
JOIN hmq_photo AS p ON (p.nodeid = n.nodeid)
WHERE n.contenttypeid = 23 AND n.parentid IN (10095,10333,10296,9955,10010)
)
/**fetchNodeAttachments**/
- Time Before: 1765479343.8606
- Time After: 1765479343.8613
- Time Taken: 0.00070691108703613
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
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 (10406,10095,10119,8610,10333,10296,9955,10303,10010,10129)
GROUP BY cl.parent
/**getDescendantAttachCount**/
- Time Before: 1765479343.8615
- Time After: 1765479343.8626
- Time Taken: 0.0011870861053467
- Memory Before: 27262976
- Memory After: 27262976
- 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 (10406,10095,10119,8610,10333,10296,9955,10303,10010,10129) AND child.contenttypeid = 23
GROUP BY cl.parent
/**getDescendantPhotoCount**/
- Time Before: 1765479343.8627
- Time After: 1765479343.8654
- Time Taken: 0.0027258396148682
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_closure
WHERE `child` IN (10406,10095,10119,8610,10333,10296,9955,10303,10010,10129)
ORDER BY `child` ASC, `depth` ASC
- Time Before: 1765479343.8655
- Time After: 1765479343.8673
- Time Taken: 0.001727819442749
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('node_10406_lvl3data','node_10095_lvl3data','node_10119_lvl3data','node_8610_lvl3data','node_10333_lvl3data','node_10296_lvl3data','node_9955_lvl3data','node_10303_lvl3data','node_10010_lvl3data','node_10129_lvl3data')
- Time Before: 1765479343.8675
- Time After: 1765479343.8716
- Time Taken: 0.0040931701660156
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT node.*,text.allowsmilie,text.attach,text.htmlstate,text.imageheight,text.imagewidth,text.infraction,text.moderated,text.nodeid AS text_nodeid,text.pagetext,text.pagetextimages,text.previewimage,text.previewtext,text.previewvideo,text.rawtext,text.showsignature, icon.iconpath, ch.routeid AS channelroute, ch.title AS channeltitle, ch.nodeid AS channelid,
starter.routeid AS starterroute, starter.title AS startertitle, starter.authorname as starterauthorname, starter.prefixid as starterprefixid,
starter.userid as starteruserid, starter.lastcontentid as starterlastcontentid, starter.totalcount+1 as startertotalcount, starter.urlident AS starterurlident,
deleteuser.username AS deleteusername, lastauthor.username AS lastauthorname, editlog.reason AS edit_reason, editlog.userid AS edit_userid, editlog.username AS edit_username,
editlog.dateline AS edit_dateline, editlog.hashistory, starter.nodeoptions as starternodeoptions, ch.nodeoptions as channelnodeoptions
FROM hmq_node AS node
LEFT JOIN hmq_text AS text
ON text.nodeid = node.nodeid
LEFT JOIN hmq_editlog AS editlog ON (editlog.nodeid = node.nodeid)
LEFT JOIN hmq_node AS starter ON (starter.nodeid = node.starter)
LEFT JOIN hmq_node AS ch ON (ch.nodeid = starter.parentid)
LEFT JOIN hmq_user AS deleteuser ON (node.deleteuserid > 0 AND node.deleteuserid = deleteuser.userid)
LEFT JOIN hmq_user AS lastauthor ON (node.lastauthorid = lastauthor.userid)
LEFT JOIN hmq_icon AS icon ON (node.iconid = icon.iconid)
WHERE node.nodeid IN (10095,10333,10296,9955,10010)
/** getFullContent**/
- Time Before: 1765479343.872
- Time After: 1765479343.8751
- Time Taken: 0.0030670166015625
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_node
WHERE `nodeid` = 9955
LIMIT 1
- Time Before: 1765479343.8766
- Time After: 1765479343.877
- Time Taken: 0.00040006637573242
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_node
WHERE `nodeid` = 10010
LIMIT 1
- Time Before: 1765479343.8774
- Time After: 1765479343.8778
- Time Taken: 0.00039410591125488
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_node
WHERE `nodeid` = 10095
LIMIT 1
- Time Before: 1765479343.8781
- Time After: 1765479343.8785
- Time Taken: 0.00041699409484863
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_node
WHERE `nodeid` = 10296
LIMIT 1
- Time Before: 1765479343.8789
- Time After: 1765479343.8804
- Time Taken: 0.0015521049499512
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_node
WHERE `nodeid` = 10333
LIMIT 1
- Time Before: 1765479343.8808
- Time After: 1765479343.8819
- Time Taken: 0.0010600090026855
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_UserPerms995')
- Time Before: 1765479343.8822
- Time After: 1765479343.8826
- Time Taken: 0.00031304359436035
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_UserPerms1009')
- Time Before: 1765479343.8827
- Time After: 1765479343.8832
- Time Taken: 0.00046110153198242
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_UserPerms1010')
- Time Before: 1765479343.8834
- Time After: 1765479343.8837
- Time Taken: 0.00030303001403809
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_UserPerms917')
- Time Before: 1765479343.8838
- Time After: 1765479343.8846
- Time Taken: 0.00081396102905273
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_UserPerms1055')
- Time Before: 1765479343.8848
- Time After: 1765479343.8851
- Time Taken: 0.00035905838012695
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_UserPerms90')
- Time Before: 1765479343.8853
- Time After: 1765479343.8855
- Time Taken: 0.00025391578674316
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vBUserRep_995','vBUserRep_655','vBUserRep_1009','vBUserRep_1010','vBUserRep_917','vBUserRep_1055','vBUserRep_604','vBUserRep_90')
- Time Before: 1765479343.8857
- Time After: 1765479343.8866
- Time Taken: 0.00090909004211426
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT user.userid, avatar.avatarid, avatar.avatarpath, user.avatarrevision,
customavatar.dateline, customavatar.width, customavatar.height, customavatar.height_thumb, customavatar.width_thumb, customavatar.filename
FROM hmq_user as user
LEFT JOIN hmq_customavatar AS customavatar ON customavatar.userid = user.userid
LEFT JOIN hmq_avatar AS avatar ON avatar.avatarid = user.avatarid
WHERE user.userid IN (995,1055,490,655,1010,90,604,1009,917)
/**fetchAvatarsForUsers**/
- Time Before: 1765479343.8885
- Time After: 1765479343.889
- Time Taken: 0.0005180835723877
- Memory Before: 29360128
- Memory After: 29360128
- Memory Used: 0
SELECT channel.nodeid
FROM hmq_channel AS channel
INNER JOIN hmq_closure AS closure
ON channel.nodeid = closure.child
WHERE closure.parent IN (22)
/**getDescendantChannelsIn**/
- Time Before: 1765479343.8898
- Time After: 1765479343.8899
- Time Taken: 0.00011110305786133
- Memory Before: 29360128
- Memory After: 29360128
- Memory Used: 0
SELECT COUNT(node.starter) AS count
FROM hmq_node as node
IGNORE INDEX (node_lastcontent)
WHERE node.starter = node.nodeid AND
node.sticky <> '1' AND
node.contenttypeid <> 19 AND
node.parentid = 22 AND
node.starter > 0 AND
node.showpublished = 1 AND
node.showapproved = 1 AND
node.viewperms = 2 AND
node.inlist = 1 AND
node.showpublished = '0' AND
node.showapproved = '1' AND
node.protected <> '1'
/**getSearchResults**/
- Time Before: 1765479343.89
- Time After: 1765479343.8901
- Time Taken: 8.2969665527344E-5
- Memory Before: 29360128
- Memory After: 29360128
- Memory Used: 0
SELECT channel.nodeid
FROM hmq_channel AS channel
INNER JOIN hmq_closure AS closure
ON channel.nodeid = closure.child
WHERE closure.parent IN (22)
/**getDescendantChannelsIn**/
- Time Before: 1765479343.8904
- Time After: 1765479343.8916
- Time Taken: 0.0012021064758301
- Memory Before: 29360128
- Memory After: 29360128
- Memory Used: 0
SELECT COUNT(node.starter) AS count
FROM hmq_node as node
IGNORE INDEX (node_lastcontent)
WHERE node.starter = node.nodeid AND
node.sticky <> '1' AND
node.contenttypeid <> 19 AND
node.parentid = 22 AND
node.starter > 0 AND
node.showpublished = 1 AND
node.showapproved = 1 AND
node.viewperms = 2 AND
node.inlist = 1 AND
node.showpublished = '1' AND
node.showapproved = '0' AND
node.protected <> '1'
/**getSearchResults**/
- Time Before: 1765479343.8917
- Time After: 1765479343.8919
- Time Taken: 0.00018501281738281
- Memory Before: 29360128
- Memory After: 29360128
- Memory Used: 0
SELECT channel.nodeid
FROM hmq_channel AS channel
INNER JOIN hmq_closure AS closure
ON channel.nodeid = closure.child
WHERE closure.parent IN (22)
/**getDescendantChannelsIn**/
- Time Before: 1765479343.8922
- Time After:
- Time Taken:
- Memory Before: 29360128
- Memory After:
- Memory Used:
SELECT * FROM hmq_user
WHERE `email` = 'info@alnadawi.com'
LIMIT 1
- Time Before: 1765479343.8953
- Time After:
- Time Taken:
- Memory Before: 29360128
- Memory After:
- Memory Used:
UPDATE hmq_session SET `styleid`=14,`languageid`=5,`emailstamp`=1765479343
WHERE (`sessionhash` = '0f4394167d0ec09511f022bec707c541')
/**session**/
- Time Before: 1765479344.1005
- Time After:
- Time Taken:
- Memory Before: 29360128
- Memory After:
- Memory Used:
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10282,10485,10452,10563)
- Time Before: 1765479344.1014
- Time After:
- Time Taken:
- Memory Before: 29360128
- Memory After:
- Memory Used:
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10282)
- Time Before: 1765479344.1017
- Time After:
- Time Taken:
- Memory Before: 29360128
- Memory After:
- Memory Used:
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10485)
- Time Before: 1765479344.1019
- Time After:
- Time Taken:
- Memory Before: 29360128
- Memory After:
- Memory Used:
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10452)
- Time Before: 1765479344.1021
- Time After:
- Time Taken:
- Memory Before: 29360128
- Memory After:
- Memory Used:
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10563)
- Time Before: 1765479344.1023
- Time After:
- Time Taken:
- Memory Before: 29360128
- Memory After:
- Memory Used:
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','subforums','topics','posts','last_post','mark_channels_read','new_posts','by_x','topic','latest_activity','my_subscriptions','photos','no_conversations_in_channel','please_login_to_view_subscribed_posts','no_topics_found','mark_this_channel_read','navbar_help','navbar_contact_us','go_to_top','powered_by_vbulletin','today','footer_current_time','working_ellipsis','yes','no','ok','cancel','facebook_language') AND `languageid` IN (5,0,-1)
- Time Before: 1765479344.1061
- Time After:
- Time Taken:
- Memory Before: 29360128
- Memory After:
- Memory Used:
SELECT * FROM hmq_routenew
WHERE `routeid` IN ('pmchat','register','activateuser','help','contact-us','search','lostpw','128','129','profile')
- Time Before: 1765479344.1076
- Time After:
- Time Taken:
- Memory Before: 29360128
- Memory After:
- Memory Used:
SELECT * FROM hmq_routenew
WHERE `routeid` = 128
LIMIT 1
- Time Before: 1765479344.1078
- Time After:
- Time Taken:
- Memory Before: 29360128
- Memory After:
- Memory Used:
SELECT * FROM hmq_routenew
WHERE `routeid` = 129
LIMIT 1
- Time Before: 1765479344.1079
- Time After:
- Time Taken:
- Memory Before: 29360128
- Memory After:
- Memory Used:
SELECT * FROM hmq_page
WHERE `pageid` = 120
LIMIT 1
- Time Before: 1765479344.1085
- Time After:
- Time Taken:
- Memory Before: 29360128
- Memory After:
- Memory Used:
SELECT `varname`,`languageid`,`text` FROM hmq_phrase
WHERE `varname` IN ('page__title','page__metadesc') AND `languageid` IN (5,0,-1)
- Time Before: 1765479344.1086
- Time After:
- Time Taken:
- Memory Before: 29360128
- Memory After:
- Memory Used:
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10757)
- Time Before: 1765479344.1105
- Time After:
- Time Taken:
- Memory Before: 29360128
- Memory After:
- Memory Used:
5 Slowest Queries
SELECT node.starter AS nodeid
FROM hmq_node as node
IGNORE INDEX (node_lastcontent)
WHERE node.starter = node.nodeid AND
node.sticky <> '1' AND
node.contenttypeid <> 19 AND
node.parentid = 22 AND
node.starter > 0 AND
node.showpublished = 1 AND
node.showapproved = 1 AND
node.viewperms = 2 AND
node.inlist = 1 AND
node.protected <> '1'
ORDER BY node.lastcontent DESC
LIMIT 1590, 10
/**getSearchResults**/
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_ChTreeWithLast')
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('node_10406_lvl3data','node_10095_lvl3data','node_10119_lvl3data','node_8610_lvl3data','node_10333_lvl3data','node_10296_lvl3data','node_9955_lvl3data','node_10303_lvl3data','node_10010_lvl3data','node_10129_lvl3data')
SELECT node.*, editlog.reason AS edit_reason, editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline, editlog.hashistory, 0 AS nodeVoted, 0 AS readtime
FROM hmq_node AS node
LEFT JOIN hmq_editlog AS editlog ON (editlog.nodeid = node.nodeid)
WHERE node.nodeid IN (10095,10333,10296,9955,10010)
/**fetchNodeWithContent**/
SELECT routenew.*
FROM hmq_routenew AS routenew
WHERE routenew.prefix IN ('forum/c1/z8/page160','forum/c1/z8','forum/c1','forum') OR ishomeroute = 1
/**get_best_routes**/
136 Queries Run : Total SQL time was 0.067697 seconds , Total PHP time was 0.247869 seconds , Overall time was 0.315565 seconds.