Total processing time: 276 ms; Peak memory: 13.009 MB. Show Profiling Timeline
Time | Duration | Category | Info |
---|---|---|---|
10:24:45.644 | 4.2 ms | yii\db\Command::query | SELECT `user`.* FROM `user` LEFT JOIN `profile` ON user.id = profile.user_id LEFT JOIN `auth_assignment` ON user.id = auth_assignment.user_id LEFT JOIN `user_meta` ON user.id = user_meta.user_id LEFT JOIN `meta` ON meta.id = user_meta.meta_id WHERE (`status`='1') AND (`auth_assignment`.`item_name` LIKE '%participante%') |
10:24:45.560 | 1.8 ms | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=sumalepuntoscoor_puntos |
10:24:45.562 | 1.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `user` |
10:24:45.566 | 0.9 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' |
10:24:45.689 | 0.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `profile` |
10:24:45.690 | 0.7 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` = 'profile' AND `kcu`.`TABLE_NAME` = 'profile' |
10:24:45.693 | 0.6 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` = 'auth_assignment' AND `kcu`.`TABLE_NAME` = 'auth_assignment' |
10:24:45.603 | 0.5 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`='1' |
10:24:45.575 | 0.5 ms | yii\db\Command::query | SELECT * FROM `user` WHERE `id`=1 |
10:24:45.692 | 0.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `auth_assignment` |
10:24:45.692 | 0.4 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=101 |
10:24:45.604 | 0.4 ms | yii\db\Command::query | SELECT * FROM `auth_item` WHERE `name`='Administrador' |
10:24:45.698 | 0.3 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=104 |
10:24:45.704 | 0.3 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=108 |
10:24:45.702 | 0.3 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=107 |
10:24:45.696 | 0.3 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=103 |
10:24:45.710 | 0.3 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=112 |
10:24:45.701 | 0.3 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=106 |
10:24:45.707 | 0.3 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=110 |
10:24:45.713 | 0.3 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=116 |
10:24:45.696 | 0.3 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=103 |
10:24:45.700 | 0.3 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=106 |
10:24:45.719 | 0.3 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=120 |
10:24:45.703 | 0.3 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=108 |
10:24:45.697 | 0.3 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=104 |
10:24:45.702 | 0.3 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=107 |
10:24:45.716 | 0.3 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=118 |
10:24:45.710 | 0.3 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=112 |
10:24:45.706 | 0.3 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=110 |
10:24:45.711 | 0.3 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=113 |
10:24:45.713 | 0.3 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=116 |
10:24:45.714 | 0.3 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=117 |
10:24:45.717 | 0.3 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=119 |
10:24:45.724 | 0.3 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=124 |
10:24:45.716 | 0.3 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=118 |
10:24:45.730 | 0.3 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=128 |
10:24:45.712 | 0.3 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=113 |
10:24:45.689 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=101 |
10:24:45.740 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=136 |
10:24:45.699 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=105 |
10:24:45.734 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=131 |
10:24:45.705 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=109 |
10:24:45.709 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=111 |
10:24:45.695 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=102 |
10:24:45.706 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=109 |
10:24:45.694 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=102 |
10:24:45.731 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=129 |
10:24:45.728 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=127 |
10:24:45.715 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=117 |
10:24:45.723 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=123 |
10:24:45.736 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=133 |
10:24:45.708 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=111 |
10:24:45.718 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=119 |
10:24:45.722 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=122 |
10:24:45.735 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=132 |
10:24:45.739 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=135 |
10:24:45.742 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=137 |
10:24:45.776 | 0.2 ms | yii\db\Command::query | SELECT `b`.* FROM `auth_assignment` `a`, `auth_item` `b` WHERE (`a`.`item_name`=`b`.`name`) AND (`a`.`user_id`='1') AND (`b`.`type`=1) |
10:24:45.733 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=131 |
10:24:45.699 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=105 |
10:24:45.727 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=126 |
10:24:45.723 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=123 |
10:24:45.721 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=122 |
10:24:45.718 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=120 |
10:24:45.729 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=128 |
10:24:45.743 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=138 |
10:24:45.739 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=135 |
10:24:45.732 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=130 |
10:24:45.735 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=132 |
10:24:45.726 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=125 |
10:24:45.754 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=147 |
10:24:45.731 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=129 |
10:24:45.756 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=149 |
10:24:45.733 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=130 |
10:24:45.738 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=134 |
10:24:45.743 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=138 |
10:24:45.745 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=140 |
10:24:45.727 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=126 |
10:24:45.777 | 0.2 ms | yii\db\Command::query | SELECT `b`.* FROM `auth_assignment` `a`, `auth_item` `b` WHERE (`a`.`item_name`=`b`.`name`) AND (`a`.`user_id`='1') AND (`b`.`type`=1) |
10:24:45.725 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=125 |
10:24:45.756 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=149 |
10:24:45.728 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=127 |
10:24:45.741 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=137 |
10:24:45.737 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=134 |
10:24:45.724 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=124 |
10:24:45.754 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=148 |
10:24:45.755 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=148 |
10:24:45.740 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=136 |
10:24:45.720 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=121 |
10:24:45.746 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=141 |
10:24:45.747 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=141 |
10:24:45.737 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=133 |
10:24:45.748 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=142 |
10:24:45.720 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=121 |
10:24:45.750 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=144 |
10:24:45.749 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=143 |
10:24:45.772 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=288 |
10:24:45.745 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=140 |
10:24:45.768 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=160 |
10:24:45.761 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=154 |
10:24:45.747 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=142 |
10:24:45.752 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=146 |
10:24:45.757 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=150 |
10:24:45.748 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=143 |
10:24:45.761 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=154 |
10:24:45.773 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=289 |
10:24:45.765 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=157 |
10:24:45.767 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=159 |
10:24:45.744 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=139 |
10:24:45.769 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=161 |
10:24:45.771 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=287 |
10:24:45.772 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=288 |
10:24:45.751 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=145 |
10:24:45.744 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=139 |
10:24:45.750 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=144 |
10:24:45.758 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=151 |
10:24:45.764 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=156 |
10:24:45.770 | 0.2 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=162 |
10:24:45.775 | 0.2 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=290 |
10:24:45.753 | 0.1 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=147 |
10:24:45.759 | 0.1 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=152 |
10:24:45.760 | 0.1 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=153 |
10:24:45.770 | 0.1 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=162 |
10:24:45.763 | 0.1 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=155 |
10:24:45.764 | 0.1 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=157 |
10:24:45.752 | 0.1 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=146 |
10:24:45.760 | 0.1 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=153 |
10:24:45.769 | 0.1 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=161 |
10:24:45.771 | 0.1 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=287 |
10:24:45.766 | 0.1 ms | yii\db\Command::query | SELECT * FROM `auth_assignment` WHERE `user_id`=158 |
10:24:45.751 | 0.1 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=145 |
10:24:45.773 | 0.1 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=289 |
10:24:45.762 | 0.1 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=155 |
10:24:45.759 | 0.1 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=152 |
10:24:45.758 | 0.1 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=151 |
10:24:45.757 | 0.1 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=150 |
10:24:45.765 | 0.1 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=158 |
10:24:45.774 | 0.1 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=290 |
10:24:45.767 | 0.1 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=159 |
10:24:45.768 | 0.1 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=160 |
10:24:45.763 | 0.1 ms | yii\db\Command::query | SELECT * FROM `profile` WHERE `user_id`=156 |