::Factions - SWC Dev Server::

Query Count: 15
SQL Time: 0.0023856163024902
PHP Execution Time: 0.0600
Memory Usage: 8.143 MB

Using devmode.

Show $_GET Request

Array
(
)

Show $_POST Request

Array
(
)

Show $_SESSION Request

Array
(
)

Show included libs

Array
(
    [0] => /swcombine/http/svn/trunk/www/htdocs/community/factions.php
    [1] => /swcombine/http/svn/trunk/libs/path.php
    [2] => /swcombine/http/svn/trunk/libs/server21/constants/constants.inc
    [3] => /swcombine/http/svn/trunk/libs/server21/database/DB.inc
    [4] => /swcombine/http/svn/trunk/libs/server21/entities/entityInfo.inc
    [5] => /swcombine/http/svn/trunk/libs/ext/cache/Lite.php
    [6] => /swcombine/http/svn/trunk/libs/server21/entities/entity.inc
    [7] => /swcombine/http/svn/trunk/libs/server21/factions/factions.inc
    [8] => /swcombine/http/svn/trunk/libs/server21/other/misc.inc
    [9] => /swcombine/http/svn/trunk/libs/server21/gui/constructionGUI.inc
    [10] => /swcombine/http/svn/trunk/libs/server21/gui/darkness.inc
    [11] => /swcombine/http/svn/trunk/libs/server21/gui/xajaxClass.inc
    [12] => /swcombine/http/svn/trunk/libs/server21/gui/xajaxResponseClass.inc
    [13] => /swcombine/http/svn/trunk/libs/server21/players/access.inc
    [14] => /swcombine/http/svn/trunk/libs/ext/browserClass.inc
    [15] => /swcombine/http/svn/trunk/libs/server21/entities/capabilities.inc
    [16] => /swcombine/http/svn/trunk/libs/server21/constants/specific.inc
    [17] => /swcombine/http/svn/trunk/libs/server21/classes/autoload.inc
    [18] => /swcombine/http/svn/trunk/libs/server3/context/SWCContextClass.inc
    [19] => /swcombine/http/svn/trunk/libs/server3/context/ContextClass.inc
    [20] => /swcombine/http/svn/trunk/libs/server21/database/MySQLDatabaseClass.inc
    [21] => /swcombine/http/svn/trunk/libs/server21/database/DBClass.inc
    [22] => /swcombine/http/svn/trunk/libs/server21/database/LoggingDBAuditClass.inc
    [23] => /swcombine/http/svn/trunk/libs/server21/other/StringUtilClass.inc
    [24] => /swcombine/http/svn/trunk/libs/server21/other/ShutdownUtilClass.inc
    [25] => /swcombine/http/svn/trunk/libs/server21/players/AccessUtilClass.inc
    [26] => /swcombine/http/svn/trunk/libs/server21/players/LoginUtilClass.inc
    [27] => /swcombine/http/svn/trunk/libs/server21/other/BacktraceUtilClass.inc
    [28] => /swcombine/http/svn/trunk/libs/server21/database/AuditQueryClass.inc
    [29] => /swcombine/http/svn/trunk/libs/server21/database/DBAtomicClass.inc
    [30] => /swcombine/http/svn/trunk/libs/server21/other/ErrorHandlerClass.inc
    [31] => /swcombine/http/svn/trunk/libs/server21/gui/MasterTemplateClass.inc
    [32] => /swcombine/http/svn/trunk/www/inc/login.inc
    [33] => /swcombine/http/svn/trunk/libs/server21/classes/CSSClass.inc
    [34] => /swcombine/http/svn/trunk/libs/server3/ajax/Ajax2Class.inc
    [35] => /swcombine/http/svn/trunk/libs/server21/classes/JSClass.inc
    [36] => /swcombine/http/svn/trunk/libs/server21/gui/MasterTemplateErrorHandlerClass.inc
    [37] => /swcombine/http/svn/trunk/libs/server21/classes/AJAXClass.inc
    [38] => /swcombine/http/svn/trunk/libs/server21/entities/galaxy/GovernmentUtilClass.inc
    [39] => /swcombine/http/svn/trunk/libs/server21/factions/FactionUtilClass.inc
    [40] => /swcombine/http/svn/trunk/libs/server21/entities/factions/FactionClass.inc
    [41] => /swcombine/http/svn/trunk/libs/server21/entities/AbstractEntityClass.inc
    [42] => /swcombine/http/svn/trunk/libs/server21/entities/ObjectClass.inc
    [43] => /swcombine/http/svn/trunk/libs/server21/entities/interfaces/EntityClass.inc
    [44] => /swcombine/http/svn/trunk/libs/server21/entities/interfaces/DescriptionClass.inc
    [45] => /swcombine/http/svn/trunk/libs/server21/entities/interfaces/JsonableClass.inc
    [46] => /swcombine/http/svn/trunk/libs/server21/entities/interfaces/OwnerClass.inc
    [47] => /swcombine/http/svn/trunk/libs/server21/entities/interfaces/NamedClass.inc
    [48] => /swcombine/http/svn/trunk/libs/server21/entities/interfaces/LinkableClass.inc
    [49] => /swcombine/http/svn/trunk/libs/server21/enumerators/enumEntityTypeClass.inc
    [50] => /swcombine/http/svn/trunk/libs/server21/enumerators/EnumeratedBaseClass.inc
    [51] => /swcombine/http/svn/trunk/libs/server21/interfaces/IEnumerated.inc
    [52] => /swcombine/http/svn/trunk/libs/server21/other/ArrayUtilClass.inc
    [53] => /swcombine/http/svn/trunk/libs/server21/cache/CacheClass.inc
    [54] => /swcombine/http/svn/trunk/libs/server21/cache/FirstLevelCacheClass.inc
    [55] => /swcombine/http/svn/trunk/libs/server21/cache/CacheProviderClass.inc
    [56] => /swcombine/http/svn/trunk/libs/server21/cache/SecondLevelCacheClass.inc
    [57] => /swcombine/http/svn/trunk/libs/server21/entities/EntityLocationUtilClass.inc
    [58] => /swcombine/http/svn/trunk/www/inc/swc_header.inc
    [59] => /swcombine/http/svn/trunk/libs/server21/other/CGTUtilClass.inc
    [60] => /swcombine/http/svn/trunk/libs/server21/other/CGTTimeClass.inc
    [61] => /swcombine/http/svn/trunk/libs/server21/classes/RSSClass.inc
    [62] => /swcombine/http/svn/trunk/libs/server21/gui/FlashClass.inc
    [63] => /swcombine/http/svn/trunk/www/inc/swc_footer.inc
    [64] => /swcombine/http/svn/trunk/www/inc/menus/community.inc
    [65] => /swcombine/http/svn/trunk/libs/server21/gui/widgets/SideMenuClass.inc
    [66] => /swcombine/http/svn/trunk/www/inc/swc_dev_footer.inc
)

Page rendering SQL Queries

[0.00008] SET mysql_set_charset = utf8;
[0.00007] USE staging_prod
[0.00009] SET autocommit = 0;
[0.00006] SET SQL_MODE = TRADITIONAL;
[0.00006] SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ
[0.00005] START TRANSACTION;
[0.00006] USE staging_prod
[0.00007] SELECT ROUND(SUM( basePop * steadyPopTaxChange * transientTaxCollect )) as population, government FROM planets AS p, factions AS f, factionTypes AS ft WHERE p.government=f.name AND f.typeID=ft.typeID AND ft.typeID=20 GROUP BY p.government ORDER BY `population` DESC LIMIT 1
[0.00005] SELECT ROUND(SUM( basePop * steadyPopTaxChange * transientTaxCollect )) as population FROM planets WHERE basePop >0
[0.00005] SELECT count( government) govtCount, government FROM planets AS p, factions AS f, factionTypes AS ft WHERE government!='none' AND p.government=f.name AND f.typeID=ft.typeID AND ft.typeID=20 GROUP BY government ORDER BY govtCount DESC LIMIT 1
[0.00006] SELECT ID FROM factions

getEntityInfoInternals(1, 18, 31, 32, 40, 45, 53, Faction)

[0.00009] SELECT f.*, t.type1, t.type2, t.facilities, t.stations, (SELECT SUM(fo.stocks) FROM factionOwners AS fo WHERE fo.factionID = f.ID) AS totStocks FROM factions as f, factionTypes as t WHERE f.ID IN (1, 18, 31, 32, 40, 45, 53) AND f.typeID = t.typeID

Header

[0.00028] SELECT count(*) AS ttl FROM `players` WHERE `loginStamp` > 415395021
[0.00016] SELECT count(*) AS ttl FROM `players` WHERE `loginStamp` > 415998021

Footer

Banner Exchange

[0.00023] SELECT DISTINCT counter FROM bannerRotate WHERE type=0
[0.00033] SELECT counter FROM bannerRotate WHERE name='Purchasing Banner Counter' LIMIT 1
[0.00029] SELECT * FROM bannerRotate WHERE type=0 ORDER BY counter LIMIT 1
[0.00015] UPDATE bannerRotate SET counter=0 WHERE name='Purchasing Banner Counter' LIMIT 1
[0.00014] UPDATE bannerRotate SET counter=counter+1 WHERE bannerID=1

	Year	Day	Time
	13	69	19:30:21

MySQLDatabase::	connect	[]	(/swcombine/http/svn/trunk/libs/path.php:84)
	require_once	["/swcombine/http/svn/trunk/libs/path.php"]	(/swcombine/http/svn/trunk/www/htdocs/community/factions.php:2)

	db_select	["staging_prod"]	(/swcombine/http/svn/trunk/libs/server21/database/MySQLDatabaseClass.inc:72)
MySQLDatabase::	changeDatabase	["staging_prod"]	(/swcombine/http/svn/trunk/libs/server21/database/DB.inc:28)
	db_query	["SET autocommit = 0;"]	(/swcombine/http/svn/trunk/libs/server21/database/MySQLDatabaseClass.inc:46)
MySQLDatabase::	connect	[]	(/swcombine/http/svn/trunk/libs/path.php:84)
	require_once	["/swcombine/http/svn/trunk/libs/path.php"]	(/swcombine/http/svn/trunk/www/htdocs/community/factions.php:2)

	db_query	["SET autocommit = 0;"]	(/swcombine/http/svn/trunk/libs/server21/database/MySQLDatabaseClass.inc:46)
MySQLDatabase::	connect	[]	(/swcombine/http/svn/trunk/libs/path.php:84)
	require_once	["/swcombine/http/svn/trunk/libs/path.php"]	(/swcombine/http/svn/trunk/www/htdocs/community/factions.php:2)

	db_query	["SET SQL_MODE = TRADITIONAL;"]	(/swcombine/http/svn/trunk/libs/server21/database/MySQLDatabaseClass.inc:50)
MySQLDatabase::	connect	[]	(/swcombine/http/svn/trunk/libs/path.php:84)
	require_once	["/swcombine/http/svn/trunk/libs/path.php"]	(/swcombine/http/svn/trunk/www/htdocs/community/factions.php:2)

	db_query	["SET SESSION TRANSACTION ISOLATION LEVEL REPEA...TABLE READ"]	(/swcombine/http/svn/trunk/libs/server21/database/MySQLDatabaseClass.inc:57)
MySQLDatabase::	connect	[]	(/swcombine/http/svn/trunk/libs/path.php:84)
	require_once	["/swcombine/http/svn/trunk/libs/path.php"]	(/swcombine/http/svn/trunk/www/htdocs/community/factions.php:2)

	db_query	["START TRANSACTION;"]	(/swcombine/http/svn/trunk/libs/server21/database/MySQLDatabaseClass.inc:61)
MySQLDatabase::	connect	[]	(/swcombine/http/svn/trunk/libs/path.php:84)
	require_once	["/swcombine/http/svn/trunk/libs/path.php"]	(/swcombine/http/svn/trunk/www/htdocs/community/factions.php:2)

	db_query	["SELECT ROUND(SUM( basePop * steadyPopTaxChang...e * transientTaxCollect )) as population, government FROM planets AS p, factions AS f, factionTypes AS ft WHERE p.government=f.name AND f.typeID=ft.typeID AND ft.typeID=20 GROUP BY p.government ORDER BY `population` DESC LIMIT 1"]	(/swcombine/http/svn/trunk/libs/server21/entities/galaxy/GovernmentUtilClass.inc:375)
GovernmentUtil::	isGovernmentAll	["Galaxy"]	(/swcombine/http/svn/trunk/libs/server21/gui/darkness.inc:1021)
	gui_factionList	["category"]	(/swcombine/http/svn/trunk/www/htdocs/community/factions.php:49)

	db_query	["SELECT ROUND(SUM( basePop steadyPopTaxChang...e * transientTaxCollect )) as population FROM planets WHERE basePop >0 "]*	(/swcombine/http/svn/trunk/libs/server21/entities/galaxy/GovernmentUtilClass.inc:380)
GovernmentUtil::	isGovernmentAll	["Galaxy"]	(/swcombine/http/svn/trunk/libs/server21/gui/darkness.inc:1021)
	gui_factionList	["category"]	(/swcombine/http/svn/trunk/www/htdocs/community/factions.php:49)

	db_query	["SELECT count( government) govtCount, governm...ent FROM planets AS p, factions AS f, factionTypes AS ft WHERE government!='none' AND p.government=f.name AND f.typeID=ft.typeID AND ft.typeID=20 GROUP BY government ORDER BY govtCount DESC LIMIT 1"]	(/swcombine/http/svn/trunk/libs/server21/entities/galaxy/GovernmentUtilClass.inc:381)
GovernmentUtil::	isGovernmentAll	["Galaxy"]	(/swcombine/http/svn/trunk/libs/server21/gui/darkness.inc:1021)
	gui_factionList	["category"]	(/swcombine/http/svn/trunk/www/htdocs/community/factions.php:49)

	db_query	["SELECT ID FROM factions"]	(/swcombine/http/svn/trunk/libs/server21/database/DB.inc:595)
	db_prepare	["SELECT !! FROM !!", "ID", "factions"]	(/swcombine/http/svn/trunk/libs/server21/entities/AbstractEntityClass.inc:50)
AbstractEntity::	all	[]	(/swcombine/http/svn/trunk/libs/server21/factions/FactionUtilClass.inc:56)
FactionUtil::	getFactions	[]	(/swcombine/http/svn/trunk/libs/server21/gui/darkness.inc:1022)
	gui_factionList	["category"]	(/swcombine/http/svn/trunk/www/htdocs/community/factions.php:49)

	db_query	["SELECT f.*, t.type1, t.type2, t.facilities, t....stations, (SELECT SUM(fo.stocks) FROM factionOwners AS fo WHERE fo.factionID = f.ID) AS totStocks FROM factions as f, factionTypes as t WHERE f.ID IN (1, 18, 31, 32, 40, 45, 53) AND f.typeID = t.typeID"]	(/swcombine/http/svn/trunk/libs/server21/database/DB.inc:595)
	db_prepare	["SELECT f., t.type1, t.type2, t.facilities, t....stations, (SELECT SUM(fo.stocks) FROM factionOwners AS fo WHERE fo.factionID = f.ID) AS totStocks FROM factions as f, factionTypes as t WHERE f.ID IN ? AND f.typeID = t.typeID", [1, 18, 31, 32, 40, 45, 53]*]	(/swcombine/http/svn/trunk/libs/server21/entities/factions/FactionClass.inc:22)
Faction::	load	[[1, 18, 31, 32, 40, 45, 53], True]
	call_user_func	[["Faction", "load"], [1, 18, 31, 32, 40, 45, 53], True]	(/swcombine/http/svn/trunk/libs/server21/entities/entityInfo.inc:323)
	getEntityInfoInternals	[[1, 18, 31, 32, 40, 45, 53], 20, True]	(/swcombine/http/svn/trunk/libs/server21/entities/entityInfo.inc:279)
	getEntityInfoByRange	[[1, 18, 31, 32, 40, 45, 53], 20, True]	(/swcombine/http/svn/trunk/libs/server21/entities/AbstractEntityClass.inc:51)
AbstractEntity::	all	[]	(/swcombine/http/svn/trunk/libs/server21/factions/FactionUtilClass.inc:56)
FactionUtil::	getFactions	[]	(/swcombine/http/svn/trunk/libs/server21/gui/darkness.inc:1022)
	gui_factionList	["category"]	(/swcombine/http/svn/trunk/www/htdocs/community/factions.php:49)

Logged in as
Guest