Performance Profiling

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

#TimeDurationCategoryInfo
   
116:16:04.0510.6 msyii\db\Connection::openOpening DB connection: mysql:host=localhost;dbname=dev.recrm.com.ua
216:16:04.0520.6 msyii\db\Command::querySELECT * FROM `tbl_user` WHERE (`id` IS NULL) AND (`status`='10')
316:16:04.0531.3 msyii\db\Command::querySHOW FULL COLUMNS FROM `tbl_user`
416:16:04.0550.4 msyii\db\Command::querySELECT 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'
516:16:04.0560.1 msyii\db\Command::querySELECT * FROM `tbl_user` WHERE `id` IS NULL
616:16:04.0561.5 msyii\db\Command::querySHOW FULL COLUMNS FROM `tbl_feed`
716:16:04.0580.4 msyii\db\Command::querySELECT 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'
816:16:04.0590.2 msyii\db\Command::querySELECT * FROM `tbl_feed` WHERE `id`='2' ORDER BY `created_at`
916:16:04.0604.0 msyii\db\Connection::openOpening DB connection: mysql:host=46.101.89.202;dbname=estbase
1016:16:04.0640.3 msyii\db\Command::querySELECT * FROM `tbl_portal` WHERE `id`=2
1116:16:04.0640.9 msyii\db\Command::querySHOW FULL COLUMNS FROM `tbl_portal`
1216:16:04.0650.7 msyii\db\Command::querySELECT 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'
1316:16:04.0670.4 msyii\db\Command::querySELECT COUNT(*) FROM `tbl_user` WHERE `status`='10'
1416:16:04.0692.2 msyii\db\Command::querySELECT `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')
1516:16:04.0722.6 msyii\db\Command::querySHOW FULL COLUMNS FROM `tbl_estate`
1616:16:04.0770.6 msyii\db\Command::querySELECT 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'
1716:16:04.0890.6 msyii\db\Command::querySELECT * FROM `tbl_currency` WHERE `id` IN (3, 2) ORDER BY `position`
1816:16:04.0891.0 msyii\db\Command::querySHOW FULL COLUMNS FROM `tbl_currency`
1916:16:04.0910.8 msyii\db\Command::querySELECT 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'
2016:16:04.0920.4 msyii\db\Command::querySELECT * FROM `tbl_street` WHERE `id` IN (857, 354, 326, 688, 64, 11098, 460)
2116:16:04.0930.9 msyii\db\Command::querySHOW FULL COLUMNS FROM `tbl_street`
2216:16:04.0941.7 msyii\db\Command::querySELECT 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'
2316:16:04.0962.6 msyii\db\Command::querySELECT * FROM `tbl_client` WHERE `id` IN (20, 6, 14, 1, 28)
2416:16:04.1001.4 msyii\db\Command::querySHOW FULL COLUMNS FROM `tbl_client`
2516:16:04.1020.5 msyii\db\Command::querySELECT 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'
2616:16:04.1032.3 msyii\db\Command::querySELECT * FROM `tbl_phone` WHERE (`owner_name`='client') AND (`owner_id` IN (1, 6, 14, 20, 28))
2716:16:04.1061.1 msyii\db\Command::querySHOW FULL COLUMNS FROM `tbl_phone`
2816:16:04.1070.4 msyii\db\Command::querySELECT 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'
2916:16:04.1090.6 msyii\db\Command::querySELECT * FROM `tbl_metro` WHERE `id`=14
3016:16:04.1091.0 msyii\db\Command::querySHOW FULL COLUMNS FROM `tbl_metro`
3116:16:04.1110.8 msyii\db\Command::querySELECT 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'
3216:16:04.1121.9 msyii\db\Command::querySELECT * FROM `tbl_meeting` WHERE (`status`='planning') AND (`estate_id` IN (28, 29, 30, 31, 10, 1, 8)) ORDER BY `start_at` DESC
3316:16:04.1141.3 msyii\db\Command::querySHOW FULL COLUMNS FROM `tbl_meeting`
3416:16:04.1160.5 msyii\db\Command::querySELECT 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'
3516:16:04.1170.3 msyii\db\Command::querySELECT * FROM `tbl_user` WHERE `id`=1
3616:16:04.1221.7 msyii\db\Command::querySELECT `email` FROM `tbl_department` WHERE `id` IN ('1', '2')
3716:16:04.1240.3 msyii\db\Command::querySELECT `username` FROM `tbl_user` WHERE `id` IN ('1', '15', '18', '16')
3816:16:04.1250.6 msyii\db\Command::querySELECT `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
3916:16:04.1271.1 msyii\db\Command::querySHOW FULL COLUMNS FROM `tbl_location_source`
4016:16:04.12815.2 msyii\db\Command::querySELECT 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'
4116:16:04.1440.5 msyii\db\Command::querySELECT * FROM `tbl_location_source` WHERE `id`=6860
4216:16:04.1450.5 msyii\db\Command::querySELECT * FROM `tbl_location_source` WHERE `id`=6637
4316:16:04.1470.5 msyii\db\Command::querySELECT `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')
4416:16:04.1493.1 msyii\db\Command::querySELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=28) ORDER BY `position`
4516:16:04.1521.1 msyii\db\Command::querySHOW FULL COLUMNS FROM `tbl_estate_image`
4616:16:04.1540.4 msyii\db\Command::querySELECT 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'
4716:16:04.1560.2 msyii\db\Command::querySELECT `email` FROM `tbl_department` WHERE `id`='2'
4816:16:04.1570.2 msyii\db\Command::querySELECT `username` FROM `tbl_user` WHERE `id` IN ('1', '11', '16', '17')
4916:16:04.1570.5 msyii\db\Command::querySELECT `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
5016:16:04.1580.4 msyii\db\Command::querySELECT * FROM `tbl_location_source` WHERE `id`=6860
5116:16:04.1590.3 msyii\db\Command::querySELECT * FROM `tbl_location_source` WHERE `id`=6637
5216:16:04.1600.4 msyii\db\Command::querySELECT `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')
5316:16:04.1610.3 msyii\db\Command::querySELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=29) ORDER BY `position`
5416:16:04.1620.2 msyii\db\Command::querySELECT `email` FROM `tbl_department` WHERE `id`='1'
5516:16:04.1620.1 msyii\db\Command::querySELECT `username` FROM `tbl_user` WHERE `id`='1'
5616:16:04.1630.5 msyii\db\Command::querySELECT `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
5716:16:04.1630.5 msyii\db\Command::querySELECT * FROM `tbl_location_source` WHERE `id`=6860
5816:16:04.1640.4 msyii\db\Command::querySELECT * FROM `tbl_location_source` WHERE `id`=6637
5916:16:04.1650.4 msyii\db\Command::querySELECT `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')
6016:16:04.1660.3 msyii\db\Command::querySELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=30) ORDER BY `position`
6116:16:04.1670.2 msyii\db\Command::querySELECT `email` FROM `tbl_department` WHERE FALSE
6216:16:04.1670.1 msyii\db\Command::querySELECT `username` FROM `tbl_user` WHERE `id`='1'
6316:16:04.1670.5 msyii\db\Command::querySELECT `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
6416:16:04.1680.4 msyii\db\Command::querySELECT * FROM `tbl_location_source` WHERE `id`=6860
6516:16:04.1690.4 msyii\db\Command::querySELECT * FROM `tbl_location_source` WHERE `id`=6637
6616:16:04.1700.4 msyii\db\Command::querySELECT `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')
6716:16:04.1710.8 msyii\db\Command::querySELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=31) ORDER BY `position`
6816:16:04.1720.2 msyii\db\Command::querySELECT `email` FROM `tbl_department` WHERE `id`='1'
6916:16:04.1730.1 msyii\db\Command::querySELECT `username` FROM `tbl_user` WHERE `id`='1'
7016:16:04.1730.5 msyii\db\Command::querySELECT `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
7116:16:04.1740.5 msyii\db\Command::querySELECT * FROM `tbl_location_source` WHERE `id`=6860
7216:16:04.1750.5 msyii\db\Command::querySELECT * FROM `tbl_location_source` WHERE `id`=6637
7316:16:04.1760.3 msyii\db\Command::querySELECT `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')
7416:16:04.1760.3 msyii\db\Command::querySELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=10) ORDER BY `position`
7516:16:04.1780.2 msyii\db\Command::querySELECT `email` FROM `tbl_department` WHERE `id`='1'
7616:16:04.1780.2 msyii\db\Command::querySELECT `username` FROM `tbl_user` WHERE `id` IN ('1', '2', '19')
7716:16:04.1780.5 msyii\db\Command::querySELECT `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
7816:16:04.1790.4 msyii\db\Command::querySELECT * FROM `tbl_location_source` WHERE `id`=6860
7916:16:04.1800.5 msyii\db\Command::querySELECT * FROM `tbl_location_source` WHERE `id`=6637
8016:16:04.1810.4 msyii\db\Command::querySELECT `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')
8116:16:04.1810.9 msyii\db\Command::querySHOW FULL COLUMNS FROM `tbl_metro_source`
8216:16:04.1820.8 msyii\db\Command::querySELECT 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'
8316:16:04.1841.6 msyii\db\Command::querySELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=1) ORDER BY `position`
8416:16:04.1860.2 msyii\db\Command::querySELECT `email` FROM `tbl_department` WHERE `id`='1'
8516:16:04.1870.1 msyii\db\Command::querySELECT `username` FROM `tbl_user` WHERE `id`='15'
8616:16:04.1870.6 msyii\db\Command::querySELECT `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
8716:16:04.1880.4 msyii\db\Command::querySELECT * FROM `tbl_location_source` WHERE `id`=6860
8816:16:04.1890.4 msyii\db\Command::querySELECT * FROM `tbl_location_source` WHERE `id`=6637
8916:16:04.1900.3 msyii\db\Command::querySELECT `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')
9016:16:04.1900.3 msyii\db\Command::querySELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=8) ORDER BY `position`