6a398d8b1434b: GET http://dev.recrm.com.ua/feed/export?id=2 at 2026-06-22 10:31:23 pm by 114.119.158.97
Database Queries
| # | Time | Duration | Type | Query |
|---|---|---|---|---|
| 1 | 22:31:23.109 | 20.6 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_portal` |
| 2 | 22:31:23.164 | 14.0 ms | SELECT | 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' |
| 3 | 22:31:23.091 | 8.5 ms | SELECT | SELECT * FROM `tbl_user` WHERE `id` IS NULL |
| 4 | 22:31:23.087 | 3.4 ms | SELECT | 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 | 22:31:23.181 | 2.4 ms | SELECT | SELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=28) ORDER BY `position` |
| 6 | 22:31:23.133 | 2.3 ms | SELECT | 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') |
| 7 | 22:31:23.100 | 1.7 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_feed` |
| 8 | 22:31:23.147 | 1.6 ms | SELECT | SELECT * FROM `tbl_client` WHERE `id` IN (20, 6, 14, 1, 28) |
| 9 | 22:31:23.135 | 1.6 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_estate` |
| 10 | 22:31:23.156 | 1.4 ms | SELECT | SELECT * FROM `tbl_meeting` WHERE (`status`='planning') AND (`estate_id` IN (28, 29, 30, 31, 10, 1, 8)) ORDER BY `start_at` DESC |
| 11 | 22:31:23.151 | 1.4 ms | SELECT | SELECT * FROM `tbl_phone` WHERE (`owner_name`='client') AND (`owner_id` IN (1, 6, 14, 20, 28)) |
| 12 | 22:31:23.161 | 1.2 ms | SELECT | SELECT `email` FROM `tbl_department` WHERE `id` IN ('1', '2') |
| 13 | 22:31:23.206 | 1.2 ms | SELECT | SELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=1) ORDER BY `position` |
| 14 | 22:31:23.086 | 1.0 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_user` |
| 15 | 22:31:23.130 | 0.9 ms | SELECT | 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' |
| 16 | 22:31:23.149 | 0.9 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_client` |
| 17 | 22:31:23.142 | 0.9 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_currency` |
| 18 | 22:31:23.145 | 0.8 ms | SELECT | 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' |
| 19 | 22:31:23.154 | 0.8 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_metro` |
| 20 | 22:31:23.163 | 0.8 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_location_source` |
| 21 | 22:31:23.144 | 0.8 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_street` |
| 22 | 22:31:23.158 | 0.8 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_meeting` |
| 23 | 22:31:23.184 | 0.8 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_estate_image` |
| 24 | 22:31:23.204 | 0.7 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_metro_source` |
| 25 | 22:31:23.143 | 0.7 ms | SELECT | 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' |
| 26 | 22:31:23.152 | 0.7 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_phone` |
| 27 | 22:31:23.141 | 0.7 ms | SELECT | SELECT * FROM `tbl_currency` WHERE `id` IN (3, 2) ORDER BY `position` |
| 28 | 22:31:23.155 | 0.6 ms | SELECT | 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' |
| 29 | 22:31:23.186 | 0.6 ms | SELECT | 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 |
| 30 | 22:31:23.205 | 0.6 ms | SELECT | 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' |
| 31 | 22:31:23.208 | 0.6 ms | SELECT | 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 |
| 32 | 22:31:23.085 | 0.5 ms | SELECT | SELECT * FROM `tbl_user` WHERE (`id` IS NULL) AND (`status`='10') |
| 33 | 22:31:23.195 | 0.5 ms | SELECT | 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') |
| 34 | 22:31:23.196 | 0.5 ms | SELECT | SELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=31) ORDER BY `position` |
| 35 | 22:31:23.163 | 0.5 ms | SELECT | 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 |
| 36 | 22:31:23.154 | 0.5 ms | SELECT | SELECT * FROM `tbl_metro` WHERE `id`=14 |
| 37 | 22:31:23.108 | 0.5 ms | SELECT | SELECT * FROM `tbl_portal` WHERE `id`=2 |
| 38 | 22:31:23.179 | 0.4 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6860 |
| 39 | 22:31:23.209 | 0.4 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6637 |
| 40 | 22:31:23.179 | 0.4 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6637 |
| 41 | 22:31:23.198 | 0.4 ms | SELECT | 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 |
| 42 | 22:31:23.131 | 0.4 ms | SELECT | SELECT COUNT(*) FROM `tbl_user` WHERE `status`='10' |
| 43 | 22:31:23.187 | 0.4 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6860 |
| 44 | 22:31:23.190 | 0.4 ms | SELECT | 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 |
| 45 | 22:31:23.202 | 0.4 ms | SELECT | 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 |
| 46 | 22:31:23.199 | 0.4 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6860 |
| 47 | 22:31:23.144 | 0.4 ms | SELECT | SELECT * FROM `tbl_street` WHERE `id` IN (857, 354, 326, 688, 64, 11098, 460) |
| 48 | 22:31:23.191 | 0.4 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6637 |
| 49 | 22:31:23.102 | 0.4 ms | SELECT | 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' |
| 50 | 22:31:23.139 | 0.3 ms | SELECT | 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' |
| 51 | 22:31:23.209 | 0.3 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6860 |
| 52 | 22:31:23.203 | 0.3 ms | SELECT | 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') |
| 53 | 22:31:23.194 | 0.3 ms | SELECT | 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 |
| 54 | 22:31:23.202 | 0.3 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6860 |
| 55 | 22:31:23.203 | 0.3 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6637 |
| 56 | 22:31:23.192 | 0.3 ms | SELECT | 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') |
| 57 | 22:31:23.191 | 0.3 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6860 |
| 58 | 22:31:23.200 | 0.3 ms | SELECT | 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') |
| 59 | 22:31:23.159 | 0.3 ms | SELECT | 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' |
| 60 | 22:31:23.210 | 0.3 ms | SELECT | 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') |
| 61 | 22:31:23.150 | 0.3 ms | SELECT | 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' |
| 62 | 22:31:23.188 | 0.3 ms | SELECT | 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') |
| 63 | 22:31:23.180 | 0.3 ms | SELECT | 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') |
| 64 | 22:31:23.185 | 0.3 ms | SELECT | 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' |
| 65 | 22:31:23.195 | 0.3 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6637 |
| 66 | 22:31:23.199 | 0.3 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6637 |
| 67 | 22:31:23.188 | 0.3 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6637 |
| 68 | 22:31:23.194 | 0.3 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6860 |
| 69 | 22:31:23.153 | 0.2 ms | SELECT | 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' |
| 70 | 22:31:23.189 | 0.2 ms | SELECT | SELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=29) ORDER BY `position` |
| 71 | 22:31:23.103 | 0.2 ms | SELECT | SELECT * FROM `tbl_feed` WHERE `id`='2' ORDER BY `created_at` |
| 72 | 22:31:23.211 | 0.2 ms | SELECT | SELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=8) ORDER BY `position` |
| 73 | 22:31:23.200 | 0.2 ms | SELECT | SELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=10) ORDER BY `position` |
| 74 | 22:31:23.193 | 0.2 ms | SELECT | SELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=30) ORDER BY `position` |
| 75 | 22:31:23.160 | 0.2 ms | SELECT | SELECT * FROM `tbl_user` WHERE `id`=1 |
| 76 | 22:31:23.190 | 0.2 ms | SELECT | SELECT `email` FROM `tbl_department` WHERE `id`='1' |
| 77 | 22:31:23.162 | 0.2 ms | SELECT | SELECT `username` FROM `tbl_user` WHERE `id` IN ('1', '15', '18', '16') |
| 78 | 22:31:23.186 | 0.2 ms | SELECT | SELECT `email` FROM `tbl_department` WHERE `id`='2' |
| 79 | 22:31:23.207 | 0.1 ms | SELECT | SELECT `email` FROM `tbl_department` WHERE `id`='1' |
| 80 | 22:31:23.186 | 0.1 ms | SELECT | SELECT `username` FROM `tbl_user` WHERE `id` IN ('1', '11', '16', '17') |
| 81 | 22:31:23.208 | 0.1 ms | SELECT | SELECT `username` FROM `tbl_user` WHERE `id`='15' |
| 82 | 22:31:23.197 | 0.1 ms | SELECT | SELECT `email` FROM `tbl_department` WHERE `id`='1' |
| 83 | 22:31:23.201 | 0.1 ms | SELECT | SELECT `username` FROM `tbl_user` WHERE `id` IN ('1', '2', '19') |
| 84 | 22:31:23.201 | 0.1 ms | SELECT | SELECT `email` FROM `tbl_department` WHERE `id`='1' |
| 85 | 22:31:23.193 | 0.1 ms | SELECT | SELECT `username` FROM `tbl_user` WHERE `id`='1' |
| 86 | 22:31:23.193 | 0.1 ms | SELECT | SELECT `email` FROM `tbl_department` WHERE FALSE |
| 87 | 22:31:23.190 | 0.1 ms | SELECT | SELECT `username` FROM `tbl_user` WHERE `id`='1' |
| 88 | 22:31:23.198 | 0.1 ms | SELECT | SELECT `username` FROM `tbl_user` WHERE `id`='1' |