1) SELECT * FROM `vs_config` WHERE `id` = '1'
2) SELECT *
FROM `vs_user`
WHERE `id` = 28
LIMIT 1
3) SELECT `id`
FROM `vs_login`
WHERE `id_user` = 28 AND
`stat` = 1 AND
`kash` = '0956aa7e55250087494f996c3a61f5a3'
LIMIT 1
4) SELECT t1.id_user, t1.last_type, t1.last_time, t1.id_pole, t2.time_comp, t3.a_id, t3.a_time
FROM `vs_asd` AS t1,
`vs_pole` AS t2,
`vs_farm` AS t3
WHERE t1.id = 74 AND
t2.id = t1.id_pole AND
t3.id = t2.type
LIMIT 1
5) SELECT `id_cur`, `kol`
FROM `vs_asd_cur`
WHERE `id_animal` = 401 AND
`kol` < 0
6) SELECT `id_cur`, `num`, `id`
FROM `vs_balance`
WHERE `id_user` = 28
7) UPDATE `vs_balance`
SET `num` =
CASE
WHEN `id` = 7 THEN 1655
WHEN `id` = 8 THEN 3545
END
WHERE `id` IN (7, 8)
8) UPDATE `vs_asd`
SET `last_type` = 1,
`last_time` = 1437484847
WHERE `id` = 74
9) UPDATE `vs_my`
SET `time_comp` = (
(SELECT MIN(`last_time`) AS tt
FROM `vs_animals`
WHERE `id_user` = 28 AND
`id_pole` = 200
LIMIT 4) + 60)
WHERE `id` = 200
10) SELECT t2.id_quest, t1.tag, t1.num, t1.type, t1.num, t2.progress, t2.id AS id_qus
FROM `vs_quest` AS t1,
`vs_quest_user` AS t2
WHERE t1.id = t2.id_quest AND
t2.time_end = 0 AND
t2.id_user = 28
11) UPDATE `vs_quest_user`
SET `progress` = 4
WHERE `id` = 25
Может встречаться 1-2 инсерта...
В каждой таблице планируется иметь ОТ 3.000.000 записей
Что лучше выбрать? innodb или myisam?