Performance Profiling

Total processing time: 135 ms; Peak memory: 6.563 MB.

#	Time	Duration	Category	Info

1	12:36:42.020	0.4 ms	yii\db\Connection::open	Opening DB connection: mysql:host=localhost;dbname=dev.recrm.com.ua
2	12:36:42.020	0.6 ms	yii\db\Command::query	SELECT * FROM `tbl_user` WHERE (`id` IS NULL) AND (`status`='10')
3	12:36:42.021	1.0 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `tbl_user`
4	12:36:42.022	0.3 ms	yii\db\Command::query	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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 = 'tbl_user' AND kcu.table_name = 'tbl_user'
5	12:36:42.023	0.1 ms	yii\db\Command::query	SELECT * FROM `tbl_user` WHERE `id` IS NULL
6	12:36:42.023	1.2 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `tbl_feed`
7	12:36:42.025	0.3 ms	yii\db\Command::query	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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 = 'tbl_feed' AND kcu.table_name = 'tbl_feed'
8	12:36:42.025	0.2 ms	yii\db\Command::query	SELECT * FROM `tbl_feed` WHERE `id`='2' ORDER BY `created_at`
9	12:36:42.026	3.3 ms	yii\db\Connection::open	Opening DB connection: mysql:host=46.101.89.202;dbname=estbase
10	12:36:42.029	0.5 ms	yii\db\Command::query	SELECT * FROM `tbl_portal` WHERE `id`=2
11	12:36:42.030	0.8 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `tbl_portal`
12	12:36:42.031	0.7 ms	yii\db\Command::query	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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 = 'tbl_portal' AND kcu.table_name = 'tbl_portal'
13	12:36:42.032	0.3 ms	yii\db\Command::query	SELECT COUNT(*) FROM `tbl_user` WHERE `status`='10'
14	12:36:42.035	2.6 ms	yii\db\Command::query	SELECT `t`.* FROM `tbl_estate` `t` JOIN `tbl_estate_publish` `ep` ON ep.estate_id = t.id WHERE ((`ep`.`feed_id`=2) AND (`t`.`status` IN ('actual', 'req_actual'))) AND (`ep`.`status`='active')
15	12:36:42.038	1.6 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `tbl_estate`
16	12:36:42.041	0.4 ms	yii\db\Command::query	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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 = 'tbl_estate' AND kcu.table_name = 'tbl_estate'
17	12:36:42.052	0.6 ms	yii\db\Command::query	SELECT * FROM `tbl_currency` WHERE `id` IN (3, 2) ORDER BY `position`
18	12:36:42.052	0.9 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `tbl_currency`
19	12:36:42.054	0.7 ms	yii\db\Command::query	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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 = 'tbl_currency' AND kcu.table_name = 'tbl_currency'
20	12:36:42.055	0.4 ms	yii\db\Command::query	SELECT * FROM `tbl_street` WHERE `id` IN (857, 354, 326, 688, 64, 11098, 460)
21	12:36:42.056	1.3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `tbl_street`
22	12:36:42.058	0.9 ms	yii\db\Command::query	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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 = 'tbl_street' AND kcu.table_name = 'tbl_street'
23	12:36:42.059	2.3 ms	yii\db\Command::query	SELECT * FROM `tbl_client` WHERE `id` IN (20, 6, 14, 1, 28)
24	12:36:42.062	1.1 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `tbl_client`
25	12:36:42.064	0.4 ms	yii\db\Command::query	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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 = 'tbl_client' AND kcu.table_name = 'tbl_client'
26	12:36:42.065	1.8 ms	yii\db\Command::query	SELECT * FROM `tbl_phone` WHERE (`owner_name`='client') AND (`owner_id` IN (1, 6, 14, 20, 28))
27	12:36:42.067	1.0 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `tbl_phone`
28	12:36:42.068	0.3 ms	yii\db\Command::query	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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 = 'tbl_phone' AND kcu.table_name = 'tbl_phone'
29	12:36:42.069	0.6 ms	yii\db\Command::query	SELECT * FROM `tbl_metro` WHERE `id`=14
30	12:36:42.070	0.7 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `tbl_metro`
31	12:36:42.071	0.6 ms	yii\db\Command::query	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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 = 'tbl_metro' AND kcu.table_name = 'tbl_metro'
32	12:36:42.072	1.9 ms	yii\db\Command::query	SELECT * FROM `tbl_meeting` WHERE (`status`='planning') AND (`estate_id` IN (28, 29, 30, 31, 10, 1, 8)) ORDER BY `start_at` DESC
33	12:36:42.074	1.0 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `tbl_meeting`
34	12:36:42.075	0.4 ms	yii\db\Command::query	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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 = 'tbl_meeting' AND kcu.table_name = 'tbl_meeting'
35	12:36:42.076	0.2 ms	yii\db\Command::query	SELECT * FROM `tbl_user` WHERE `id`=1
36	12:36:42.080	1.7 ms	yii\db\Command::query	SELECT `email` FROM `tbl_department` WHERE `id` IN ('1', '2')
37	12:36:42.082	0.2 ms	yii\db\Command::query	SELECT `username` FROM `tbl_user` WHERE `id` IN ('1', '15', '18', '16')
38	12:36:42.083	0.6 ms	yii\db\Command::query	SELECT `t`.* FROM `tbl_location_source` `t` JOIN `tbl_location_connect` `connect` ON connect.source_id = t.id WHERE ((`connect`.`location_id`=668) AND (`t`.`portal_id`=2)) AND (`t`.`can_be_send`=1) ORDER BY `t`.`level` DESC
39	12:36:42.085	1.0 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `tbl_location_source`
40	12:36:42.086	18.8 ms	yii\db\Command::query	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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 = 'tbl_location_source' AND kcu.table_name = 'tbl_location_source'
41	12:36:42.105	0.5 ms	yii\db\Command::query	SELECT * FROM `tbl_location_source` WHERE `id`=6860
42	12:36:42.106	0.4 ms	yii\db\Command::query	SELECT * FROM `tbl_location_source` WHERE `id`=6637
43	12:36:42.108	0.4 ms	yii\db\Command::query	SELECT `t`.* FROM `tbl_metro_source` `t` JOIN `tbl_metro_connect` `connect` ON connect.source_id = t.id WHERE ((`connect`.`metro_id` IS NULL) AND (`t`.`portal_id`=2)) AND (`t`.`type`='station')
44	12:36:42.110	3.1 ms	yii\db\Command::query	SELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=28) ORDER BY `position`
45	12:36:42.113	1.0 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `tbl_estate_image`
46	12:36:42.114	0.3 ms	yii\db\Command::query	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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 = 'tbl_estate_image' AND kcu.table_name = 'tbl_estate_image'
47	12:36:42.116	0.2 ms	yii\db\Command::query	SELECT `email` FROM `tbl_department` WHERE `id`='2'
48	12:36:42.117	0.2 ms	yii\db\Command::query	SELECT `username` FROM `tbl_user` WHERE `id` IN ('1', '11', '16', '17')
49	12:36:42.117	0.6 ms	yii\db\Command::query	SELECT `t`.* FROM `tbl_location_source` `t` JOIN `tbl_location_connect` `connect` ON connect.source_id = t.id WHERE ((`connect`.`location_id`=723) AND (`t`.`portal_id`=2)) AND (`t`.`can_be_send`=1) ORDER BY `t`.`level` DESC
50	12:36:42.118	0.4 ms	yii\db\Command::query	SELECT * FROM `tbl_location_source` WHERE `id`=6860
51	12:36:42.119	0.4 ms	yii\db\Command::query	SELECT * FROM `tbl_location_source` WHERE `id`=6637
52	12:36:42.119	0.4 ms	yii\db\Command::query	SELECT `t`.* FROM `tbl_metro_source` `t` JOIN `tbl_metro_connect` `connect` ON connect.source_id = t.id WHERE ((`connect`.`metro_id` IS NULL) AND (`t`.`portal_id`=2)) AND (`t`.`type`='station')
53	12:36:42.120	0.4 ms	yii\db\Command::query	SELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=29) ORDER BY `position`
54	12:36:42.121	0.2 ms	yii\db\Command::query	SELECT `email` FROM `tbl_department` WHERE `id`='1'
55	12:36:42.122	0.1 ms	yii\db\Command::query	SELECT `username` FROM `tbl_user` WHERE `id`='1'
56	12:36:42.122	0.5 ms	yii\db\Command::query	SELECT `t`.* FROM `tbl_location_source` `t` JOIN `tbl_location_connect` `connect` ON connect.source_id = t.id WHERE ((`connect`.`location_id`=711) AND (`t`.`portal_id`=2)) AND (`t`.`can_be_send`=1) ORDER BY `t`.`level` DESC
57	12:36:42.123	0.3 ms	yii\db\Command::query	SELECT * FROM `tbl_location_source` WHERE `id`=6860
58	12:36:42.124	0.3 ms	yii\db\Command::query	SELECT * FROM `tbl_location_source` WHERE `id`=6637
59	12:36:42.124	0.3 ms	yii\db\Command::query	SELECT `t`.* FROM `tbl_metro_source` `t` JOIN `tbl_metro_connect` `connect` ON connect.source_id = t.id WHERE ((`connect`.`metro_id` IS NULL) AND (`t`.`portal_id`=2)) AND (`t`.`type`='station')
60	12:36:42.125	0.3 ms	yii\db\Command::query	SELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=30) ORDER BY `position`
61	12:36:42.126	0.2 ms	yii\db\Command::query	SELECT `email` FROM `tbl_department` WHERE FALSE
62	12:36:42.126	0.1 ms	yii\db\Command::query	SELECT `username` FROM `tbl_user` WHERE `id`='1'
63	12:36:42.127	0.4 ms	yii\db\Command::query	SELECT `t`.* FROM `tbl_location_source` `t` JOIN `tbl_location_connect` `connect` ON connect.source_id = t.id WHERE ((`connect`.`location_id`=712) AND (`t`.`portal_id`=2)) AND (`t`.`can_be_send`=1) ORDER BY `t`.`level` DESC
64	12:36:42.128	0.4 ms	yii\db\Command::query	SELECT * FROM `tbl_location_source` WHERE `id`=6860
65	12:36:42.128	0.4 ms	yii\db\Command::query	SELECT * FROM `tbl_location_source` WHERE `id`=6637
66	12:36:42.129	0.4 ms	yii\db\Command::query	SELECT `t`.* FROM `tbl_metro_source` `t` JOIN `tbl_metro_connect` `connect` ON connect.source_id = t.id WHERE ((`connect`.`metro_id` IS NULL) AND (`t`.`portal_id`=2)) AND (`t`.`type`='station')
67	12:36:42.130	0.6 ms	yii\db\Command::query	SELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=31) ORDER BY `position`
68	12:36:42.131	0.2 ms	yii\db\Command::query	SELECT `email` FROM `tbl_department` WHERE `id`='1'
69	12:36:42.131	0.1 ms	yii\db\Command::query	SELECT `username` FROM `tbl_user` WHERE `id`='1'
70	12:36:42.132	0.5 ms	yii\db\Command::query	SELECT `t`.* FROM `tbl_location_source` `t` JOIN `tbl_location_connect` `connect` ON connect.source_id = t.id WHERE ((`connect`.`location_id`=636) AND (`t`.`portal_id`=2)) AND (`t`.`can_be_send`=1) ORDER BY `t`.`level` DESC
71	12:36:42.133	0.3 ms	yii\db\Command::query	SELECT * FROM `tbl_location_source` WHERE `id`=6860
72	12:36:42.133	0.4 ms	yii\db\Command::query	SELECT * FROM `tbl_location_source` WHERE `id`=6637
73	12:36:42.134	0.4 ms	yii\db\Command::query	SELECT `t`.* FROM `tbl_metro_source` `t` JOIN `tbl_metro_connect` `connect` ON connect.source_id = t.id WHERE ((`connect`.`metro_id` IS NULL) AND (`t`.`portal_id`=2)) AND (`t`.`type`='station')
74	12:36:42.135	0.4 ms	yii\db\Command::query	SELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=10) ORDER BY `position`
75	12:36:42.136	0.2 ms	yii\db\Command::query	SELECT `email` FROM `tbl_department` WHERE `id`='1'
76	12:36:42.136	0.1 ms	yii\db\Command::query	SELECT `username` FROM `tbl_user` WHERE `id` IN ('1', '2', '19')
77	12:36:42.137	0.5 ms	yii\db\Command::query	SELECT `t`.* FROM `tbl_location_source` `t` JOIN `tbl_location_connect` `connect` ON connect.source_id = t.id WHERE ((`connect`.`location_id`=674) AND (`t`.`portal_id`=2)) AND (`t`.`can_be_send`=1) ORDER BY `t`.`level` DESC
78	12:36:42.138	0.5 ms	yii\db\Command::query	SELECT * FROM `tbl_location_source` WHERE `id`=6860
79	12:36:42.138	0.3 ms	yii\db\Command::query	SELECT * FROM `tbl_location_source` WHERE `id`=6637
80	12:36:42.139	0.3 ms	yii\db\Command::query	SELECT `t`.* FROM `tbl_metro_source` `t` JOIN `tbl_metro_connect` `connect` ON connect.source_id = t.id WHERE ((`connect`.`metro_id`=14) AND (`t`.`portal_id`=2)) AND (`t`.`type`='station')
81	12:36:42.139	0.8 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `tbl_metro_source`
82	12:36:42.140	1.2 ms	yii\db\Command::query	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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 = 'tbl_metro_source' AND kcu.table_name = 'tbl_metro_source'
83	12:36:42.142	1.3 ms	yii\db\Command::query	SELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=1) ORDER BY `position`
84	12:36:42.144	0.2 ms	yii\db\Command::query	SELECT `email` FROM `tbl_department` WHERE `id`='1'
85	12:36:42.144	0.1 ms	yii\db\Command::query	SELECT `username` FROM `tbl_user` WHERE `id`='15'
86	12:36:42.145	0.5 ms	yii\db\Command::query	SELECT `t`.* FROM `tbl_location_source` `t` JOIN `tbl_location_connect` `connect` ON connect.source_id = t.id WHERE ((`connect`.`location_id`=662) AND (`t`.`portal_id`=2)) AND (`t`.`can_be_send`=1) ORDER BY `t`.`level` DESC
87	12:36:42.146	0.4 ms	yii\db\Command::query	SELECT * FROM `tbl_location_source` WHERE `id`=6860
88	12:36:42.146	0.4 ms	yii\db\Command::query	SELECT * FROM `tbl_location_source` WHERE `id`=6637
89	12:36:42.147	0.5 ms	yii\db\Command::query	SELECT `t`.* FROM `tbl_metro_source` `t` JOIN `tbl_metro_connect` `connect` ON connect.source_id = t.id WHERE ((`connect`.`metro_id` IS NULL) AND (`t`.`portal_id`=2)) AND (`t`.`type`='station')
90	12:36:42.148	0.4 ms	yii\db\Command::query	SELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=8) ORDER BY `position`