Не могу понять в чем дело…
При записи в базу SQLite делает 3 запроса вместо одного
$posts=new Posts;
$posts->title='aaa';
$posts->note='bbb';
$posts->save();
Таблица SQLite
CREATE TABLE [posts] (
[id] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
[title] VARCHAR(200) NULL,
[note] TEXT NULL
)
Затем генерирую через gii, модель Posts и контроллер PostsController
Запись делаю в actionIndex
public function actionIndex()
{
$posts=new Posts;
$posts->title='aaa';
$posts->note='bbb';
$posts->save();
$this->render('index');
}
Перехожу site.com/posts/
И в базе получаю 3 записи
id title note
1 aaa bbb
2 aaa bbb
3 aaa bbb
В лог-файле получаю следующее
2011/11/20 15:33:32 [trace] [system.db.CDbCommand] Querying SQL: PRAGMA table_info('posts')
in /usr/local/www/vhosts/test.dev/www/test/protected/controllers/PostsController.php (7)
in /usr/local/www/vhosts/test.dev/www/test/index.php (13)
2011/11/20 15:33:32 [trace] [system.db.CDbCommand] Querying SQL: PRAGMA foreign_key_list('posts')
in /usr/local/www/vhosts/test.dev/www/test/protected/controllers/PostsController.php (7)
in /usr/local/www/vhosts/test.dev/www/test/index.php (13)
2011/11/20 15:33:32 [trace] [system.db.CDbCommand] Executing SQL: INSERT INTO 'posts' ("title", "note") VALUES (:yp0, :yp1)
in /usr/local/www/vhosts/test.dev/www/test/protected/controllers/PostsController.php (10)
in /usr/local/www/vhosts/test.dev/www/test/index.php (13)
2011/11/20 15:33:32 [trace] [system.db.CDbCommand] Querying SQL: PRAGMA table_info('posts')
in /usr/local/www/vhosts/test.dev/www/test/protected/controllers/PostsController.php (7)
in /usr/local/www/vhosts/test.dev/www/test/index.php (13)
2011/11/20 15:33:32 [trace] [system.db.CDbCommand] Querying SQL: PRAGMA foreign_key_list('posts')
in /usr/local/www/vhosts/test.dev/www/test/protected/controllers/PostsController.php (7)
in /usr/local/www/vhosts/test.dev/www/test/index.php (13)
2011/11/20 15:33:32 [trace] [system.db.CDbCommand] Executing SQL: INSERT INTO 'posts' ("title", "note") VALUES (:yp0, :yp1)
in /usr/local/www/vhosts/test.dev/www/test/protected/controllers/PostsController.php (10)
in /usr/local/www/vhosts/test.dev/www/test/index.php (13)
2011/11/20 15:33:32 [trace] [system.db.CDbCommand] Querying SQL: PRAGMA table_info('posts')
in /usr/local/www/vhosts/test.dev/www/test/protected/controllers/PostsController.php (7)
in /usr/local/www/vhosts/test.dev/www/test/index.php (13)
2011/11/20 15:33:32 [trace] [system.db.CDbCommand] Querying SQL: PRAGMA foreign_key_list('posts')
in /usr/local/www/vhosts/test.dev/www/test/protected/controllers/PostsController.php (7)
in /usr/local/www/vhosts/test.dev/www/test/index.php (13)
2011/11/20 15:33:32 [trace] [system.db.CDbCommand] Executing SQL: INSERT INTO 'posts' ("title", "note") VALUES (:yp0, :yp1)
in /usr/local/www/vhosts/test.dev/www/test/protected/controllers/PostsController.php (10)
in /usr/local/www/vhosts/test.dev/www/test/index.php (13)
Все действия производятся на свежем yii 1.1.8 и созданном тестовом проекте yiic webapp test