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 = \"040oefg5fi20eqnok2shi5gd66\"",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"OK: DELETE FROM redirections WHERE timeout < UNIX_TIMESTAMP()",
"OK: SELECT * FROM redirections WHERE oldurl = \"clenbuterol-magnus-pharmaceuticals-clen-40mcg-100tablets\"",
"OK: SELECT * FROM documents WHERE published = 1 AND symbol=\"clenbuterol-magnus-pharmaceuticals-clen-40mcg-100tablets\"",
"OK: SELECT * FROM shop_products LEFT JOIN shop_products_parameters USING (product_code) WHERE seourl = \"clenbuterol-magnus-pharmaceuticals-clen-40mcg-100tablets\" ORDER BY price_a ASC",
"OK: SELECT * FROM shop_products_descriptions where product_code = \"MAG21\"",
"OK: SELECT category_id FROM shop_categorization WHERE product_code = \"MAG21\"",
"OK: SELECT * from shop_products WHERE product_code in (SELECT related_code FROM shop_related_products WHERE product_code = \"MAG21\") ",
"OK: SELECT * from shop_products WHERE product_code in (SELECT product_code FROM shop_related_products WHERE related_code = \"MAG21\") ",
"OK: SELECT count(ip) as total FROM blacklist WHERE ip = \"1679471611\"",
"OK: DELETE FROM sessions WHERE timeout < UNIX_TIMESTAMP()",
"OK: SELECT * FROM user_accounts WHERE accesslevel >7",
"OK: SELECT * FROM sessions WHERE session = \"040oefg5fi20eqnok2shi5gd66\"",
"OK: SELECT * from shop_products WHERE ( (tags LIKE \"%Clenbuterol, Magnus%\") ) AND product_code <> \"MAG21\" ORDER BY RAND() LIMIT 3",
"OK: SELECT count(ip) as total FROM blacklist WHERE ip = \"1679471611\"",
"OK: DELETE FROM sessions WHERE timeout < UNIX_TIMESTAMP()",
"OK: SELECT * FROM user_accounts WHERE accesslevel >7",
"OK: SELECT * FROM sessions WHERE session = \"040oefg5fi20eqnok2shi5gd66\"",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"OK: SELECT count(ip) as total FROM blacklist WHERE ip = \"1679471611\"",
"OK: DELETE FROM sessions WHERE timeout < UNIX_TIMESTAMP()",
"OK: SELECT * FROM user_accounts WHERE accesslevel >7",
"OK: SELECT * FROM sessions WHERE session = \"040oefg5fi20eqnok2shi5gd66\"",
"OK: SELECT count(ip) as total FROM blacklist WHERE ip = \"1679471611\"",
"OK: DELETE FROM sessions WHERE timeout < UNIX_TIMESTAMP()",
"OK: SELECT * FROM user_accounts WHERE accesslevel >7",
"OK: SELECT * FROM sessions WHERE session = \"040oefg5fi20eqnok2shi5gd66\"",
"OK: SELECT * FROM shop_cart, shop_products WHERE session_id = \"040oefg5fi20eqnok2shi5gd66\" AND shop_cart.code = shop_products.seourl",
"OK: SELECT count(ip) as total FROM blacklist WHERE ip = \"1679471611\"",
"OK: DELETE FROM sessions WHERE timeout < UNIX_TIMESTAMP()",
"OK: SELECT * FROM user_accounts WHERE accesslevel >7",
"OK: SELECT * FROM sessions WHERE session = \"040oefg5fi20eqnok2shi5gd66\"",
"OK: SELECT count(ip) as total FROM blacklist WHERE ip = \"1679471611\"",
"OK: DELETE FROM sessions WHERE timeout < UNIX_TIMESTAMP()",
"OK: SELECT * FROM user_accounts WHERE accesslevel >7",
"OK: SELECT * FROM sessions WHERE session = \"040oefg5fi20eqnok2shi5gd66\"",
"OK: SELECT * FROM shop_cart, shop_products WHERE session_id = \"040oefg5fi20eqnok2shi5gd66\" AND shop_cart.code = shop_products.seourl",
"OK: SELECT count(ip) as total FROM blacklist WHERE ip = \"1679471611\"",
"OK: DELETE FROM sessions WHERE timeout < UNIX_TIMESTAMP()",
"OK: SELECT * FROM user_accounts WHERE accesslevel >7",
"OK: SELECT * FROM sessions WHERE session = \"040oefg5fi20eqnok2shi5gd66\"",
"OK: SELECT * FROM shop_cart, shop_products WHERE session_id = \"040oefg5fi20eqnok2shi5gd66\" 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
}
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 = \"040oefg5fi20eqnok2shi5gd66\"",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"OK: DELETE FROM redirections WHERE timeout < UNIX_TIMESTAMP()",
"OK: SELECT * FROM redirections WHERE oldurl = \"clenbuterol-magnus-pharmaceuticals-clen-40mcg-100tablets\"",
"OK: SELECT * FROM documents WHERE published = 1 AND symbol=\"clenbuterol-magnus-pharmaceuticals-clen-40mcg-100tablets\"",
"OK: SELECT * FROM shop_products LEFT JOIN shop_products_parameters USING (product_code) WHERE seourl = \"clenbuterol-magnus-pharmaceuticals-clen-40mcg-100tablets\" ORDER BY price_a ASC",
"OK: SELECT * FROM shop_products_descriptions where product_code = \"MAG21\"",
"OK: SELECT category_id FROM shop_categorization WHERE product_code = \"MAG21\"",
"OK: SELECT * from shop_products WHERE product_code in (SELECT related_code FROM shop_related_products WHERE product_code = \"MAG21\") ",
"OK: SELECT * from shop_products WHERE product_code in (SELECT product_code FROM shop_related_products WHERE related_code = \"MAG21\") ",
"OK: SELECT count(ip) as total FROM blacklist WHERE ip = \"1679471611\"",
"OK: DELETE FROM sessions WHERE timeout < UNIX_TIMESTAMP()",
"OK: SELECT * FROM user_accounts WHERE accesslevel >7",
"OK: SELECT * FROM sessions WHERE session = \"040oefg5fi20eqnok2shi5gd66\"",
"OK: SELECT * from shop_products WHERE ( (tags LIKE \"%Clenbuterol, Magnus%\") ) AND product_code <> \"MAG21\" ORDER BY RAND() LIMIT 3",
"OK: SELECT count(ip) as total FROM blacklist WHERE ip = \"1679471611\"",
"OK: DELETE FROM sessions WHERE timeout < UNIX_TIMESTAMP()",
"OK: SELECT * FROM user_accounts WHERE accesslevel >7",
"OK: SELECT * FROM sessions WHERE session = \"040oefg5fi20eqnok2shi5gd66\"",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"OK: SELECT count(ip) as total FROM blacklist WHERE ip = \"1679471611\"",
"OK: DELETE FROM sessions WHERE timeout < UNIX_TIMESTAMP()",
"OK: SELECT * FROM user_accounts WHERE accesslevel >7",
"OK: SELECT * FROM sessions WHERE session = \"040oefg5fi20eqnok2shi5gd66\"",
"OK: SELECT count(ip) as total FROM blacklist WHERE ip = \"1679471611\"",
"OK: DELETE FROM sessions WHERE timeout < UNIX_TIMESTAMP()",
"OK: SELECT * FROM user_accounts WHERE accesslevel >7",
"OK: SELECT * FROM sessions WHERE session = \"040oefg5fi20eqnok2shi5gd66\"",
"OK: SELECT * FROM shop_cart, shop_products WHERE session_id = \"040oefg5fi20eqnok2shi5gd66\" AND shop_cart.code = shop_products.seourl",
"OK: SELECT count(ip) as total FROM blacklist WHERE ip = \"1679471611\"",
"OK: DELETE FROM sessions WHERE timeout < UNIX_TIMESTAMP()",
"OK: SELECT * FROM user_accounts WHERE accesslevel >7",
"OK: SELECT * FROM sessions WHERE session = \"040oefg5fi20eqnok2shi5gd66\"",
"OK: SELECT count(ip) as total FROM blacklist WHERE ip = \"1679471611\"",
"OK: DELETE FROM sessions WHERE timeout < UNIX_TIMESTAMP()",
"OK: SELECT * FROM user_accounts WHERE accesslevel >7",
"OK: SELECT * FROM sessions WHERE session = \"040oefg5fi20eqnok2shi5gd66\"",
"OK: SELECT * FROM shop_cart, shop_products WHERE session_id = \"040oefg5fi20eqnok2shi5gd66\" AND shop_cart.code = shop_products.seourl",
"OK: SELECT count(ip) as total FROM blacklist WHERE ip = \"1679471611\"",
"OK: DELETE FROM sessions WHERE timeout < UNIX_TIMESTAMP()",
"OK: SELECT * FROM user_accounts WHERE accesslevel >7",
"OK: SELECT * FROM sessions WHERE session = \"040oefg5fi20eqnok2shi5gd66\"",
"OK: SELECT * FROM shop_cart, shop_products WHERE session_id = \"040oefg5fi20eqnok2shi5gd66\" 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"
]