Performance Profiling

Total processing time: 132 ms; Peak memory: 6.509 MB.

#TimeDurationCategoryInfo
   
122:31:23.0850.4 msyii\db\Connection::openOpening DB connection: mysql:host=localhost;dbname=dev.recrm.com.ua
222:31:23.0850.5 msyii\db\Command::querySELECT * FROM `tbl_user` WHERE (`id` IS NULL) AND (`status`='10')
322:31:23.0861.0 msyii\db\Command::querySHOW FULL COLUMNS FROM `tbl_user`
422:31:23.0873.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'
522:31:23.0918.5 msyii\db\Command::querySELECT * FROM `tbl_user` WHERE `id` IS NULL
622:31:23.1001.7 msyii\db\Command::querySHOW FULL COLUMNS FROM `tbl_feed`
722:31:23.1020.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'
822:31:23.1030.2 msyii\db\Command::querySELECT * FROM `tbl_feed` WHERE `id`='2' ORDER BY `created_at`
922:31:23.1044.7 msyii\db\Connection::openOpening DB connection: mysql:host=46.101.89.202;dbname=estbase
1022:31:23.1080.5 msyii\db\Command::querySELECT * FROM `tbl_portal` WHERE `id`=2
1122:31:23.10920.6 msyii\db\Command::querySHOW FULL COLUMNS FROM `tbl_portal`
1222:31:23.1300.9 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'
1322:31:23.1310.4 msyii\db\Command::querySELECT COUNT(*) FROM `tbl_user` WHERE `status`='10'
1422:31:23.1332.3 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')
1522:31:23.1351.6 msyii\db\Command::querySHOW FULL COLUMNS FROM `tbl_estate`
1622:31:23.1390.3 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'
1722:31:23.1410.7 msyii\db\Command::querySELECT * FROM `tbl_currency` WHERE `id` IN (3, 2) ORDER BY `position`
1822:31:23.1420.9 msyii\db\Command::querySHOW FULL COLUMNS FROM `tbl_currency`
1922:31:23.1430.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_currency' AND kcu.table_name = 'tbl_currency'
2022:31:23.1440.4 msyii\db\Command::querySELECT * FROM `tbl_street` WHERE `id` IN (857, 354, 326, 688, 64, 11098, 460)
2122:31:23.1440.8 msyii\db\Command::querySHOW FULL COLUMNS FROM `tbl_street`
2222:31:23.1450.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_street' AND kcu.table_name = 'tbl_street'
2322:31:23.1471.6 msyii\db\Command::querySELECT * FROM `tbl_client` WHERE `id` IN (20, 6, 14, 1, 28)
2422:31:23.1490.9 msyii\db\Command::querySHOW FULL COLUMNS FROM `tbl_client`
2522:31:23.1500.3 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'
2622:31:23.1511.4 msyii\db\Command::querySELECT * FROM `tbl_phone` WHERE (`owner_name`='client') AND (`owner_id` IN (1, 6, 14, 20, 28))
2722:31:23.1520.7 msyii\db\Command::querySHOW FULL COLUMNS FROM `tbl_phone`
2822:31:23.1530.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_phone' AND kcu.table_name = 'tbl_phone'
2922:31:23.1540.5 msyii\db\Command::querySELECT * FROM `tbl_metro` WHERE `id`=14
3022:31:23.1540.8 msyii\db\Command::querySHOW FULL COLUMNS FROM `tbl_metro`
3122:31:23.1550.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_metro' AND kcu.table_name = 'tbl_metro'
3222:31:23.1561.4 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
3322:31:23.1580.8 msyii\db\Command::querySHOW FULL COLUMNS FROM `tbl_meeting`
3422:31:23.1590.3 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'
3522:31:23.1600.2 msyii\db\Command::querySELECT * FROM `tbl_user` WHERE `id`=1
3622:31:23.1611.2 msyii\db\Command::querySELECT `email` FROM `tbl_department` WHERE `id` IN ('1', '2')
3722:31:23.1620.2 msyii\db\Command::querySELECT `username` FROM `tbl_user` WHERE `id` IN ('1', '15', '18', '16')
3822:31:23.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`=668) AND (`t`.`portal_id`=2)) AND (`t`.`can_be_send`=1) ORDER BY `t`.`level` DESC
3922:31:23.1630.8 msyii\db\Command::querySHOW FULL COLUMNS FROM `tbl_location_source`
4022:31:23.16414.0 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'
4122:31:23.1790.4 msyii\db\Command::querySELECT * FROM `tbl_location_source` WHERE `id`=6860
4222:31:23.1790.4 msyii\db\Command::querySELECT * FROM `tbl_location_source` WHERE `id`=6637
4322:31:23.1800.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')
4422:31:23.1812.4 msyii\db\Command::querySELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=28) ORDER BY `position`
4522:31:23.1840.8 msyii\db\Command::querySHOW FULL COLUMNS FROM `tbl_estate_image`
4622:31:23.1850.3 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'
4722:31:23.1860.2 msyii\db\Command::querySELECT `email` FROM `tbl_department` WHERE `id`='2'
4822:31:23.1860.1 msyii\db\Command::querySELECT `username` FROM `tbl_user` WHERE `id` IN ('1', '11', '16', '17')
4922:31:23.1860.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`=723) AND (`t`.`portal_id`=2)) AND (`t`.`can_be_send`=1) ORDER BY `t`.`level` DESC
5022:31:23.1870.4 msyii\db\Command::querySELECT * FROM `tbl_location_source` WHERE `id`=6860
5122:31:23.1880.3 msyii\db\Command::querySELECT * FROM `tbl_location_source` WHERE `id`=6637
5222:31:23.1880.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')
5322:31:23.1890.2 msyii\db\Command::querySELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=29) ORDER BY `position`
5422:31:23.1900.2 msyii\db\Command::querySELECT `email` FROM `tbl_department` WHERE `id`='1'
5522:31:23.1900.1 msyii\db\Command::querySELECT `username` FROM `tbl_user` WHERE `id`='1'
5622:31:23.1900.4 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
5722:31:23.1910.3 msyii\db\Command::querySELECT * FROM `tbl_location_source` WHERE `id`=6860
5822:31:23.1910.4 msyii\db\Command::querySELECT * FROM `tbl_location_source` WHERE `id`=6637
5922:31:23.1920.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')
6022:31:23.1930.2 msyii\db\Command::querySELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=30) ORDER BY `position`
6122:31:23.1930.1 msyii\db\Command::querySELECT `email` FROM `tbl_department` WHERE FALSE
6222:31:23.1930.1 msyii\db\Command::querySELECT `username` FROM `tbl_user` WHERE `id`='1'
6322:31:23.1940.3 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
6422:31:23.1940.3 msyii\db\Command::querySELECT * FROM `tbl_location_source` WHERE `id`=6860
6522:31:23.1950.3 msyii\db\Command::querySELECT * FROM `tbl_location_source` WHERE `id`=6637
6622:31:23.1950.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')
6722:31:23.1960.5 msyii\db\Command::querySELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=31) ORDER BY `position`
6822:31:23.1970.1 msyii\db\Command::querySELECT `email` FROM `tbl_department` WHERE `id`='1'
6922:31:23.1980.1 msyii\db\Command::querySELECT `username` FROM `tbl_user` WHERE `id`='1'
7022:31:23.1980.4 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
7122:31:23.1990.4 msyii\db\Command::querySELECT * FROM `tbl_location_source` WHERE `id`=6860
7222:31:23.1990.3 msyii\db\Command::querySELECT * FROM `tbl_location_source` WHERE `id`=6637
7322:31:23.2000.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')
7422:31:23.2000.2 msyii\db\Command::querySELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=10) ORDER BY `position`
7522:31:23.2010.1 msyii\db\Command::querySELECT `email` FROM `tbl_department` WHERE `id`='1'
7622:31:23.2010.1 msyii\db\Command::querySELECT `username` FROM `tbl_user` WHERE `id` IN ('1', '2', '19')
7722:31:23.2020.4 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
7822:31:23.2020.3 msyii\db\Command::querySELECT * FROM `tbl_location_source` WHERE `id`=6860
7922:31:23.2030.3 msyii\db\Command::querySELECT * FROM `tbl_location_source` WHERE `id`=6637
8022:31:23.2030.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`=14) AND (`t`.`portal_id`=2)) AND (`t`.`type`='station')
8122:31:23.2040.7 msyii\db\Command::querySHOW FULL COLUMNS FROM `tbl_metro_source`
8222:31:23.2050.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_metro_source' AND kcu.table_name = 'tbl_metro_source'
8322:31:23.2061.2 msyii\db\Command::querySELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=1) ORDER BY `position`
8422:31:23.2070.1 msyii\db\Command::querySELECT `email` FROM `tbl_department` WHERE `id`='1'
8522:31:23.2080.1 msyii\db\Command::querySELECT `username` FROM `tbl_user` WHERE `id`='15'
8622:31:23.2080.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
8722:31:23.2090.3 msyii\db\Command::querySELECT * FROM `tbl_location_source` WHERE `id`=6860
8822:31:23.2090.4 msyii\db\Command::querySELECT * FROM `tbl_location_source` WHERE `id`=6637
8922:31:23.2100.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')
9022:31:23.2110.2 msyii\db\Command::querySELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=8) ORDER BY `position`