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 = \"q9b7fhh8tbq0pupqamo18o9d04\"",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"OK: SELECT DISTINCT manufacturer FROM shop_products ORDER BY manufacturer ASC",
"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 = \"q9b7fhh8tbq0pupqamo18o9d04\"",
"OK: SELECT COUNT(DISTINCT seourl) as total FROM (SELECT seourl FROM shop_products as sp where status = 1 and status = 1 AND sp.product_code in (SELECT product_code FROM shop_categorization WHERE (category_id = 15) ) GROUP BY group_id) as counttable",
"OK: SELECT * FROM shop_products as sp LEFT JOIN shop_products_descriptions on sp.product_code=shop_products_descriptions.product_code WHERE language = \"en\" and status = 1 AND sp.product_code in (SELECT product_code FROM shop_categorization WHERE (category_id = 15) ) GROUP BY group_id ORDER BY product_name ASC LIMIT 0, 18 ",
"OK: SELECT * FROM shop_products_descriptions WHERE language = \"en\" AND product_code \r\n\t\tIN (\"STK10\",\"G33\",\"MAG25\",\"HB14\",\"MAG24\",\"STK11\",\"G10\",\"STK14\",\"HB11\",\"HCG3\",\"HCG9\",\"P01\",\"STK12\",\"MAG23\",\"G09\")",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"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 = \"q9b7fhh8tbq0pupqamo18o9d04\"",
"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 = \"q9b7fhh8tbq0pupqamo18o9d04\"",
"OK: SELECT * FROM shop_cart, shop_products WHERE session_id = \"q9b7fhh8tbq0pupqamo18o9d04\" 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 = \"q9b7fhh8tbq0pupqamo18o9d04\"",
"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 = \"q9b7fhh8tbq0pupqamo18o9d04\"",
"OK: SELECT * FROM shop_cart, shop_products WHERE session_id = \"q9b7fhh8tbq0pupqamo18o9d04\" 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 = \"q9b7fhh8tbq0pupqamo18o9d04\"",
"OK: SELECT * FROM shop_cart, shop_products WHERE session_id = \"q9b7fhh8tbq0pupqamo18o9d04\" 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,
"fcategory": "15",
"fsort": 0,
"flimit": "18",
"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 = \"q9b7fhh8tbq0pupqamo18o9d04\"",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"OK: SELECT DISTINCT manufacturer FROM shop_products ORDER BY manufacturer ASC",
"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 = \"q9b7fhh8tbq0pupqamo18o9d04\"",
"OK: SELECT COUNT(DISTINCT seourl) as total FROM (SELECT seourl FROM shop_products as sp where status = 1 and status = 1 AND sp.product_code in (SELECT product_code FROM shop_categorization WHERE (category_id = 15) ) GROUP BY group_id) as counttable",
"OK: SELECT * FROM shop_products as sp LEFT JOIN shop_products_descriptions on sp.product_code=shop_products_descriptions.product_code WHERE language = \"en\" and status = 1 AND sp.product_code in (SELECT product_code FROM shop_categorization WHERE (category_id = 15) ) GROUP BY group_id ORDER BY product_name ASC LIMIT 0, 18 ",
"OK: SELECT * FROM shop_products_descriptions WHERE language = \"en\" AND product_code \r\n\t\tIN (\"STK10\",\"G33\",\"MAG25\",\"HB14\",\"MAG24\",\"STK11\",\"G10\",\"STK14\",\"HB11\",\"HCG3\",\"HCG9\",\"P01\",\"STK12\",\"MAG23\",\"G09\")",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"OK: SELECT * FROM shop_categories",
"OK: SELECT * FROM shop_parameters",
"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 = \"q9b7fhh8tbq0pupqamo18o9d04\"",
"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 = \"q9b7fhh8tbq0pupqamo18o9d04\"",
"OK: SELECT * FROM shop_cart, shop_products WHERE session_id = \"q9b7fhh8tbq0pupqamo18o9d04\" 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 = \"q9b7fhh8tbq0pupqamo18o9d04\"",
"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 = \"q9b7fhh8tbq0pupqamo18o9d04\"",
"OK: SELECT * FROM shop_cart, shop_products WHERE session_id = \"q9b7fhh8tbq0pupqamo18o9d04\" 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 = \"q9b7fhh8tbq0pupqamo18o9d04\"",
"OK: SELECT * FROM shop_cart, shop_products WHERE session_id = \"q9b7fhh8tbq0pupqamo18o9d04\" 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"
]