Performance Profiling

Total processing time: 4,030 ms; Peak memory: 12.040 MB. Show Profiling Timeline

Total 47 items.

Time	Duration	Category	Info

11:20:34.821	0.4 ms	yii\db\Command::query	SELECT * FROM `system_log` ORDER BY `log_time` DESC LIMIT 5
11:20:34.727	0.3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `crop`
11:20:30.839	0.3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `question`
11:20:30.841	0.3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `question_attachment`
11:20:30.834	0.3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `key_storage_item`
11:20:34.599	0.3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `user`
11:20:34.822	0.3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `system_log`
11:20:30.839	0.3 ms	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` = 'question' AND `kcu`.`TABLE_NAME` = 'question'
11:20:34.727	0.3 ms	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`=3) ORDER BY `crop_lang`.`language_id` DESC
11:20:34.821	0.2 ms	yii\db\Command::query	SELECT COUNT(*) FROM `system_log`
11:20:30.833	0.2 ms	yii\db\Connection::open	Opening DB connection: mysql:host=localhost;port=3306;dbname=harmiinf_kisan
11:20:30.835	0.2 ms	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:20:34.826	0.2 ms	yii\db\Command::query	SELECT COUNT(*) FROM `system_log`
11:20:34.600	0.2 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `crop_type`
11:20:34.599	0.2 ms	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` = 'user' AND `kcu`.`TABLE_NAME` = 'user'
11:20:30.841	0.2 ms	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` = 'question_attachment' AND `kcu`.`TABLE_NAME` = 'question_attachment'
11:20:34.822	0.2 ms	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'
11:20:34.728	0.2 ms	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'
11:20:30.834	0.2 ms	yii\db\Command::query	SELECT * FROM `key_storage_item` WHERE `key`='frontend.maintenance'
11:20:30.841	0.2 ms	yii\db\Command::query	SELECT * FROM `question_attachment` WHERE `question_id`=14
11:20:34.820	0.1 ms	yii\db\Command::query	SELECT * FROM `crop_attachment` WHERE `crop_id`=3
11:20:34.601	0.1 ms	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'
11:20:30.847	0.1 ms	yii\db\Command::query	SELECT COUNT(*) FROM `question_view` WHERE `question_id`=14
11:20:34.598	0.1 ms	yii\db\Command::query	SELECT * FROM `user` WHERE `id`=1
11:20:34.594	0.1 ms	yii\db\Command::query	SELECT COUNT(*) FROM `question_like` WHERE `question_id`=14
11:20:34.594	0.1 ms	yii\db\Command::query	SELECT * FROM `question_like` WHERE (`question_id`=14) AND (`user_id` IS NULL)
11:20:30.838	0.1 ms	yii\db\Command::query	SELECT * FROM `question` WHERE (`status`=1) AND (`show_frontend`=1) AND (`id`=14)
11:20:34.829	0.1 ms	yii\db\Command::query	SELECT COUNT(*) FROM `timeline_event` WHERE `created_at` >= 1746037800
11:20:34.829	0.1 ms	yii\db\Command::query	SELECT * FROM `key_storage_item` WHERE `key`='adminlte.footer-small-text'
11:20:34.826	0.1 ms	yii\db\Command::query	SELECT COUNT(*) FROM `timeline_event` WHERE `created_at` >= 1746037800
11:20:34.600	0.1 ms	yii\db\Command::query	SELECT * FROM `crop_type` WHERE `id`=1
11:20:34.829	0.1 ms	yii\db\Command::query	SELECT * FROM `key_storage_item` WHERE `key`='adminlte.sidebar-child-indent'
11:20:34.824	0.1 ms	yii\db\Command::query	SELECT * FROM `key_storage_item` WHERE `key`='adminlte.navbar-no-border'
11:20:34.829	0.1 ms	yii\db\Command::query	SELECT * FROM `key_storage_item` WHERE `key`='adminlte.sidebar-compact'
11:20:34.830	0.1 ms	yii\db\Command::query	SELECT * FROM `key_storage_item` WHERE `key`='adminlte.sidebar-fixed'
11:20:34.831	0.1 ms	yii\db\Command::query	SELECT * FROM `key_storage_item` WHERE `key`='adminlte.navbar-fixed'
11:20:30.848	0.1 ms	yii\db\Command::query	SELECT COUNT(*) FROM `question_view` WHERE `question_id`=14
11:20:34.828	0.1 ms	yii\db\Command::query	SELECT * FROM `key_storage_item` WHERE `key`='adminlte.sidebar-no-expand'
11:20:34.824	0.1 ms	yii\db\Command::query	SELECT * FROM `key_storage_item` WHERE `key`='adminlte.navbar-small-text'
11:20:34.828	0.1 ms	yii\db\Command::query	SELECT * FROM `key_storage_item` WHERE `key`='adminlte.sidebar-small-text'
11:20:34.831	0.1 ms	yii\db\Command::query	SELECT * FROM `key_storage_item` WHERE `key`='adminlte.sidebar-mini'
11:20:34.831	0.1 ms	yii\db\Command::query	SELECT * FROM `key_storage_item` WHERE `key`='adminlte.sidebar-collapsed'
11:20:34.828	0.1 ms	yii\db\Command::query	SELECT * FROM `key_storage_item` WHERE `key`='adminlte.sidebar-flat'
11:20:34.831	0.1 ms	yii\db\Command::query	SELECT * FROM `key_storage_item` WHERE `key`='adminlte.body-small-text'
11:20:34.828	0.1 ms	yii\db\Command::query	SELECT * FROM `key_storage_item` WHERE `key`='adminlte.sidebar-legacy'
11:20:34.831	0.1 ms	yii\db\Command::query	SELECT * FROM `key_storage_item` WHERE `key`='adminlte.footer-fixed'
11:20:34.828	0.0 ms	yii\db\Command::query	SELECT * FROM `key_storage_item` WHERE `key`='adminlte.brand-text-small'