# | Time | Since previous | Level | Category | Message |
---|---|---|---|---|---|
1 | 09:47:06.766 | < 0ms > | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
2 | 09:47:06.766 | trace | yii\base\Module::getModule | Loading module: gii | |
3 | 09:47:06.767 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() | |
4 | 09:47:06.768 | trace | yii\base\Module::getModule | Loading module: debug | |
5 | 09:47:06.777 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() | |
6 | 09:47:06.778 | trace | yii\base\Application::bootstrap | Bootstrap with common\components\maintenance\Maintenance::bootstrap() | |
7 | 09:47:06.789 | info | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;port=3306;dbname=harmiinf_kisan | |
8 | 09:47:06.791 | info | yii\db\Command::query | SELECT * FROM `key_storage_item` WHERE `key`='frontend.maintenance' | |
9 | 09:47:06.791 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `key_storage_item` | |
10 | 09:47:06.792 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'key_storage_item' AND `kcu`.`TABLE_NAME` = 'key_storage_item' | |
11 | 09:47:06.793 | info | yii\web\Session::open | Session started | |
12 | 09:47:06.794 | trace | yii\web\Application::handleRequest | Route requested: 'post/view' | |
13 | 09:47:06.796 | trace | yii\base\Controller::runAction | Route to run: post/view | |
14 | 09:47:06.797 | trace | yii\base\InlineAction::runWithParams | Running action: frontend\controllers\PostController::actionView() | |
15 | 09:47:06.800 | info | yii\db\Command::query | SELECT * FROM `post` WHERE (`status`=1) AND (`show_frontend`=1) AND (`id`=21) | |
16 | 09:47:06.801 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `post` | |
17 | 09:47:06.801 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'post' AND `kcu`.`TABLE_NAME` = 'post' | |
18 | 09:47:06.803 | info | yii\db\Command::query | SELECT * FROM `post_attachment` WHERE `post_id`=21 | |
19 | 09:47:06.803 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `post_attachment` | |
20 | 09:47:06.804 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'post_attachment' AND `kcu`.`TABLE_NAME` = 'post_attachment' | |
21 | 09:47:06.805 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `post_view` | |
22 | 09:47:06.806 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'post_view' AND `kcu`.`TABLE_NAME` = 'post_view' | |
23 | 09:47:06.853 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `post` WHERE `post`.`id`=21) | |
24 | 09:47:06.854 | info | yii\db\Command::execute | INSERT INTO `post_view` (`post_id`, `created_at`, `user_id`) VALUES (21, 1745209026, NULL) | |
25 | 09:47:06.855 | info | yii\db\Command::query | SELECT COUNT(*) FROM `post_view` WHERE `post_id`=21 | |
26 | 09:47:06.855 | info | yii\db\Command::query | SELECT * FROM `post` WHERE (`status`=1) AND (`show_frontend`=1) AND (`id`=21) | |
27 | 09:47:06.883 | info | yii\db\Command::query | SELECT * FROM `post_attachment` WHERE `post_id`=21 | |
28 | 09:47:13.345 | trace | yii\base\View::renderFile | Rendering view file: /var/www/vhosts/mobikisan.com/httpdocs/frontend/views/post/view.php | |
29 | 09:47:13.489 | info | yii\db\Command::query | SELECT * FROM `crop_type` WHERE `id`=3 | |
30 | 09:47:13.489 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `crop_type` | |
31 | 09:47:13.490 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'crop_type' AND `kcu`.`TABLE_NAME` = 'crop_type' | |
32 | 09:47:13.512 | info | yii\db\Command::query | SELECT `crop`.*, `crop`.`id` AS `id`, `crop_lang`.`name` AS `name` FROM `crop` LEFT JOIN `crop_lang` ON crop.id = crop_lang.crop_id WHERE (`crop`.`status`=1) AND (`crop`.`show_frontend`=1) AND ((`crop_lang`.`language_id`=1) OR (`crop_lang`.`language_id`=1)) AND (`crop`.`id`=9) ORDER BY `crop_lang`.`language_id` DESC | |
33 | 09:47:13.512 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `crop` | |
34 | 09:47:13.513 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'crop' AND `kcu`.`TABLE_NAME` = 'crop' | |
35 | 09:47:13.520 | info | yii\db\Command::query | SELECT * FROM `crop_attachment` WHERE `crop_id`=9 | |
36 | 09:47:13.660 | info | yii\db\Command::query | SELECT * FROM `state` WHERE `id`=21 | |
37 | 09:47:13.672 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `state` | |
38 | 09:47:13.673 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'state' AND `kcu`.`TABLE_NAME` = 'state' | |
39 | 09:47:13.810 | info | yii\db\Command::query | SELECT * FROM `district` WHERE `id`=3 | |
40 | 09:47:13.810 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `district` | |
41 | 09:47:13.811 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'district' AND `kcu`.`TABLE_NAME` = 'district' | |
42 | 09:47:13.822 | info | yii\db\Command::query | SELECT * FROM `taluka` WHERE `id`=1 | |
43 | 09:47:13.822 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `taluka` | |
44 | 09:47:13.823 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'taluka' AND `kcu`.`TABLE_NAME` = 'taluka' | |
45 | 09:47:13.823 | info | yii\db\Command::query | SELECT COUNT(*) FROM `post_view` WHERE `post_id`=21 | |
46 | 09:47:17.621 | trace | yii\base\View::renderFile | Rendering view file: /var/www/vhosts/mobikisan.com/httpdocs/frontend/views/post/_buttons_like_dislike.php | |
47 | 09:47:17.641 | info | yii\db\Command::query | SELECT * FROM `post_like` WHERE (`post_id`=21) AND (`user_id` IS NULL) | |
48 | 09:47:17.641 | info | yii\db\Command::query | SELECT COUNT(*) FROM `post_like` WHERE `post_id`=21 | |
49 | 09:47:17.790 | trace | yii\base\View::renderFile | Rendering view file: /var/www/vhosts/mobikisan.com/httpdocs/frontend/views/layouts/main.php | |
50 | 09:47:17.790 | trace | yii\base\View::renderFile | Rendering view file: /var/www/vhosts/mobikisan.com/httpdocs/frontend/views/layouts/common.php | |
51 | 09:47:17.792 | info | test | yii\i18n\DbMessageSource | |
52 | 09:47:17.792 | info | yii\db\Command::query | SELECT COUNT(*) FROM `system_log` | |
53 | 09:47:17.792 | info | yii\db\Command::query | SELECT * FROM `system_log` ORDER BY `log_time` DESC LIMIT 5 | |
54 | 09:47:17.793 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `system_log` | |
55 | 09:47:17.793 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'system_log' AND `kcu`.`TABLE_NAME` = 'system_log' | |
56 | 09:47:17.796 | info | yii\db\Command::query | SELECT * FROM `key_storage_item` WHERE `key`='adminlte.navbar-no-border' | |
57 | 09:47:17.797 | info | yii\db\Command::query | SELECT * FROM `key_storage_item` WHERE `key`='adminlte.navbar-small-text' | |
58 | 09:47:17.799 | info | yii\db\Command::query | SELECT COUNT(*) FROM `timeline_event` WHERE `created_at` >= 1745173800 | |
59 | 09:47:17.799 | info | yii\db\Command::query | SELECT COUNT(*) FROM `system_log` | |
60 | 09:47:17.802 | info | yii\db\Command::query | SELECT * FROM `key_storage_item` WHERE `key`='adminlte.sidebar-no-expand' | |
61 | 09:47:17.802 | info | yii\db\Command::query | SELECT * FROM `key_storage_item` WHERE `key`='adminlte.brand-text-small' | |
62 | 09:47:17.803 | info | yii\db\Command::query | SELECT * FROM `key_storage_item` WHERE `key`='adminlte.sidebar-small-text' | |
63 | 09:47:17.803 | info | yii\db\Command::query | SELECT * FROM `key_storage_item` WHERE `key`='adminlte.sidebar-flat' | |
64 | 09:47:17.803 | info | yii\db\Command::query | SELECT * FROM `key_storage_item` WHERE `key`='adminlte.sidebar-legacy' | |
65 | 09:47:17.803 | info | yii\db\Command::query | SELECT * FROM `key_storage_item` WHERE `key`='adminlte.sidebar-compact' | |
66 | 09:47:17.804 | info | yii\db\Command::query | SELECT * FROM `key_storage_item` WHERE `key`='adminlte.sidebar-child-indent' | |
67 | 09:47:17.804 | info | yii\db\Command::query | SELECT COUNT(*) FROM `timeline_event` WHERE `created_at` >= 1745173800 | |
68 | 09:47:17.805 | info | yii\db\Command::query | SELECT * FROM `key_storage_item` WHERE `key`='adminlte.footer-small-text' | |
69 | 09:47:17.805 | trace | yii\base\View::renderFile | Rendering view file: /var/www/vhosts/mobikisan.com/httpdocs/backend/views/layouts/base.php | |
70 | 09:47:17.806 | info | yii\db\Command::query | SELECT * FROM `key_storage_item` WHERE `key`='adminlte.sidebar-fixed' | |
71 | 09:47:17.807 | info | yii\db\Command::query | SELECT * FROM `key_storage_item` WHERE `key`='adminlte.sidebar-mini' | |
72 | 09:47:17.807 | info | yii\db\Command::query | SELECT * FROM `key_storage_item` WHERE `key`='adminlte.sidebar-collapsed' | |
73 | 09:47:17.807 | info | yii\db\Command::query | SELECT * FROM `key_storage_item` WHERE `key`='adminlte.navbar-fixed' | |
74 | 09:47:17.807 | info | yii\db\Command::query | SELECT * FROM `key_storage_item` WHERE `key`='adminlte.body-small-text' | |
75 | 09:47:17.807 | < 0ms > | info | yii\db\Command::query | SELECT * FROM `key_storage_item` WHERE `key`='adminlte.footer-fixed' |