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: DELETE FROM shop_cart WHERE timeout < UNIX_TIMESTAMP()",
"OK: UPDATE shop_cart SET timeout = UNIX_TIMESTAMP()+3600 WHERE session_id = \"eih7osfui96lhu3b4q7lbom1u5\"",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"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 = \"eih7osfui96lhu3b4q7lbom1u5\"",
"OK: SELECT * FROM shop_cart, shop_products WHERE session_id = \"eih7osfui96lhu3b4q7lbom1u5\" 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 = \"eih7osfui96lhu3b4q7lbom1u5\"",
"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 = \"eih7osfui96lhu3b4q7lbom1u5\"",
"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 = \"eih7osfui96lhu3b4q7lbom1u5\"",
"OK: SELECT * FROM shop_cart, shop_products WHERE session_id = \"eih7osfui96lhu3b4q7lbom1u5\" 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 = \"eih7osfui96lhu3b4q7lbom1u5\"",
"OK: SELECT * FROM shop_cart, shop_products WHERE session_id = \"eih7osfui96lhu3b4q7lbom1u5\" AND shop_cart.code = shop_products.seourl",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"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"
],
"product_filter": [],
"product_search": null,
"fsort": 0,
"flimit": "18",
"fcategory": "0",
"showuni": 0,
"brandfilter": null,
"ctype": ""
}
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: DELETE FROM shop_cart WHERE timeout < UNIX_TIMESTAMP()",
"OK: UPDATE shop_cart SET timeout = UNIX_TIMESTAMP()+3600 WHERE session_id = \"eih7osfui96lhu3b4q7lbom1u5\"",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"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 = \"eih7osfui96lhu3b4q7lbom1u5\"",
"OK: SELECT * FROM shop_cart, shop_products WHERE session_id = \"eih7osfui96lhu3b4q7lbom1u5\" 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 = \"eih7osfui96lhu3b4q7lbom1u5\"",
"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 = \"eih7osfui96lhu3b4q7lbom1u5\"",
"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 = \"eih7osfui96lhu3b4q7lbom1u5\"",
"OK: SELECT * FROM shop_cart, shop_products WHERE session_id = \"eih7osfui96lhu3b4q7lbom1u5\" 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 = \"eih7osfui96lhu3b4q7lbom1u5\"",
"OK: SELECT * FROM shop_cart, shop_products WHERE session_id = \"eih7osfui96lhu3b4q7lbom1u5\" AND shop_cart.code = shop_products.seourl",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"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"
]