SESSION [close]: {
"language": "en",
"currency": "USD",
"debug_queries": [
"OK: SET NAMES 'utf8'",
"OK: SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=\"buylegit_new\" AND TABLE_TYPE=\"BASE TABLE\"",
"OK: SELECT count(ip) as total FROM blacklist WHERE ip = \"65843052\"",
"OK: SELECT count(ip) as total FROM blacklist WHERE ip = \"65843052\"",
"OK: DELETE FROM sessions WHERE timeout < UNIX_TIMESTAMP()",
"OK: SELECT * FROM user_accounts WHERE accesslevel >7",
"OK: SELECT * FROM sessions WHERE session = \"4quacs9jkf0chu2etmei97qpi2\"",
"OK: SELECT count(ip) as total FROM blacklist WHERE ip = \"65843052\"",
"OK: DELETE FROM sessions WHERE timeout < UNIX_TIMESTAMP()",
"OK: SELECT * FROM user_accounts WHERE accesslevel >7",
"OK: SELECT * FROM sessions WHERE session = \"4quacs9jkf0chu2etmei97qpi2\"",
"OK: SELECT * FROM shop_cart, shop_products WHERE session_id = \"4quacs9jkf0chu2etmei97qpi2\" AND shop_cart.code = shop_products.seourl",
"OK: SELECT count(ip) as total FROM blacklist WHERE ip = \"65843052\"",
"OK: DELETE FROM sessions WHERE timeout < UNIX_TIMESTAMP()",
"OK: SELECT * FROM user_accounts WHERE accesslevel >7",
"OK: SELECT * FROM sessions WHERE session = \"4quacs9jkf0chu2etmei97qpi2\"",
"OK: SELECT count(ip) as total FROM blacklist WHERE ip = \"65843052\"",
"OK: DELETE FROM sessions WHERE timeout < UNIX_TIMESTAMP()",
"OK: SELECT * FROM user_accounts WHERE accesslevel >7",
"OK: SELECT * FROM sessions WHERE session = \"4quacs9jkf0chu2etmei97qpi2\"",
"OK: SELECT * FROM shop_cart, shop_products WHERE session_id = \"4quacs9jkf0chu2etmei97qpi2\" AND shop_cart.code = shop_products.seourl",
"OK: SELECT count(ip) as total FROM blacklist WHERE ip = \"65843052\"",
"OK: DELETE FROM sessions WHERE timeout < UNIX_TIMESTAMP()",
"OK: SELECT * FROM user_accounts WHERE accesslevel >7",
"OK: SELECT * FROM sessions WHERE session = \"4quacs9jkf0chu2etmei97qpi2\"",
"OK: SELECT * FROM shop_cart, shop_products WHERE session_id = \"4quacs9jkf0chu2etmei97qpi2\" AND shop_cart.code = shop_products.seourl",
"OK: SELECT title, symbol, intro, created FROM documents\r\n\tLEFT JOIN (SELECT ratings.key, COUNT(ratings.ip) as rating_count, SUM(ratings.rating) as rating_value,\r\n\t(SUM(ratings.rating) DIV COUNT(ratings.ip)) as rating FROM ratings GROUP BY `key`) as ratings\r\n\tON documents.id = ratings.key WHERE published = 1 AND (symbol LIKE \"blog-%\") ORDER BY created DESC LIMIT 0, 9",
"OK: SELECT userID, userPic FROM tbl_users ORDER BY userID DESC"
]
}
SQL [close] [
"OK: SET NAMES 'utf8'",
"OK: SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=\"buylegit_new\" AND TABLE_TYPE=\"BASE TABLE\"",
"OK: SELECT count(ip) as total FROM blacklist WHERE ip = \"65843052\"",
"OK: SELECT count(ip) as total FROM blacklist WHERE ip = \"65843052\"",
"OK: DELETE FROM sessions WHERE timeout < UNIX_TIMESTAMP()",
"OK: SELECT * FROM user_accounts WHERE accesslevel >7",
"OK: SELECT * FROM sessions WHERE session = \"4quacs9jkf0chu2etmei97qpi2\"",
"OK: SELECT count(ip) as total FROM blacklist WHERE ip = \"65843052\"",
"OK: DELETE FROM sessions WHERE timeout < UNIX_TIMESTAMP()",
"OK: SELECT * FROM user_accounts WHERE accesslevel >7",
"OK: SELECT * FROM sessions WHERE session = \"4quacs9jkf0chu2etmei97qpi2\"",
"OK: SELECT * FROM shop_cart, shop_products WHERE session_id = \"4quacs9jkf0chu2etmei97qpi2\" AND shop_cart.code = shop_products.seourl",
"OK: SELECT count(ip) as total FROM blacklist WHERE ip = \"65843052\"",
"OK: DELETE FROM sessions WHERE timeout < UNIX_TIMESTAMP()",
"OK: SELECT * FROM user_accounts WHERE accesslevel >7",
"OK: SELECT * FROM sessions WHERE session = \"4quacs9jkf0chu2etmei97qpi2\"",
"OK: SELECT count(ip) as total FROM blacklist WHERE ip = \"65843052\"",
"OK: DELETE FROM sessions WHERE timeout < UNIX_TIMESTAMP()",
"OK: SELECT * FROM user_accounts WHERE accesslevel >7",
"OK: SELECT * FROM sessions WHERE session = \"4quacs9jkf0chu2etmei97qpi2\"",
"OK: SELECT * FROM shop_cart, shop_products WHERE session_id = \"4quacs9jkf0chu2etmei97qpi2\" AND shop_cart.code = shop_products.seourl",
"OK: SELECT count(ip) as total FROM blacklist WHERE ip = \"65843052\"",
"OK: DELETE FROM sessions WHERE timeout < UNIX_TIMESTAMP()",
"OK: SELECT * FROM user_accounts WHERE accesslevel >7",
"OK: SELECT * FROM sessions WHERE session = \"4quacs9jkf0chu2etmei97qpi2\"",
"OK: SELECT * FROM shop_cart, shop_products WHERE session_id = \"4quacs9jkf0chu2etmei97qpi2\" AND shop_cart.code = shop_products.seourl",
"OK: SELECT title, symbol, intro, created FROM documents\r\n\tLEFT JOIN (SELECT ratings.key, COUNT(ratings.ip) as rating_count, SUM(ratings.rating) as rating_value,\r\n\t(SUM(ratings.rating) DIV COUNT(ratings.ip)) as rating FROM ratings GROUP BY `key`) as ratings\r\n\tON documents.id = ratings.key WHERE published = 1 AND (symbol LIKE \"blog-%\") ORDER BY created DESC LIMIT 0, 9",
"OK: SELECT userID, userPic FROM tbl_users ORDER BY userID DESC"
]