48 Connect top@localhost on
150509 14:56:34 48 Init DB top
48 Query set character_set_results=utf8
48 Query set character_set_client=utf8
48 Query set character_set_connection=utf8
48 Query SELECT * FROM `top_settings`
48 Query SELECT * FROM `top_users` WHERE `login`='Admin' AND `password`='34e1cfe'
48 Query SELECT * FROM `top_online` WHERE `ip` = '127.0.0.1' AND `ua` = 'Mozilla' AND `time` > '1431172414'
48 Query UPDATE `top_online` SET `time` = '1431172594' WHERE `ip` = '127.0.0.1' AND `ua` = 'Mozilla' LIMIT 1
48 Query SELECT * FROM `top_online` WHERE `time` > '1431172414'
48 Query SELECT * FROM `top_sait` WHERE `status` = '1' AND `id` = '122'
48 Query SELECT * FROM `top_images` WHERE `name` = '6'
48 Query SELECT `id_c` FROM `top_ip` WHERE INET_ATON('127.0.0.1') BETWEEN `start` AND `finish`
48 Query SELECT * FROM `top_hosts` WHERE `id_sait` = '122' AND `ip` = '127.0.0.1' AND `time` > '1431118800'
48 Query INSERT INTO `top_hits` SET
`time` = '1431172594',
`id_sait` = '122',
`ip` = '127.0.0.1',
`browser` = 'Mozilla',
`operator` = '1000'
48 Query UPDATE `top_sait` SET `hits` = (`hits` + 1), `all_hits` = (`all_hits` + 1) WHERE `id` = '122'
48 Query SELECT * FROM `top_sait_online` WHERE `ip` = '127.0.0.1' AND `ua` = 'Mozilla' AND `time` > '1431172414' AND `id_sait` = '122'
48 Query UPDATE `top_sait_online` SET `time` = '1431172594' WHERE `ip` = '127.0.0.1' AND `ua` = 'Mozilla' AND `id_sait` = '122' LIMIT 1
48 Query SELECT * FROM `top_sait` WHERE `id` = '122'
48 Quit
24. VipRockzip, как я и говорил ранее, у вас статистика живая, все записывается и перезаписывается в реальном времени, для записи еще ладно, но для чтения из базы и генерацию изображения можно дописать кеширование.