6a3935940b997: GET http://dev.recrm.com.ua/feed/export?id=2 at 2026-06-22 04:16:04 pm by 216.73.217.126
Database Queries
| # | Time | Duration | Type | Query |
|---|---|---|---|---|
| 1 | 16:16:04.128 | 15.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_location_source' AND kcu.table_name = 'tbl_location_source' |
| 2 | 16:16:04.149 | 3.1 ms | SELECT | SELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=28) ORDER BY `position` |
| 3 | 16:16:04.072 | 2.6 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_estate` |
| 4 | 16:16:04.096 | 2.6 ms | SELECT | SELECT * FROM `tbl_client` WHERE `id` IN (20, 6, 14, 1, 28) |
| 5 | 16:16:04.103 | 2.3 ms | SELECT | SELECT * FROM `tbl_phone` WHERE (`owner_name`='client') AND (`owner_id` IN (1, 6, 14, 20, 28)) |
| 6 | 16:16:04.069 | 2.2 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 | 16:16:04.112 | 1.9 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 |
| 8 | 16:16:04.122 | 1.7 ms | SELECT | SELECT `email` FROM `tbl_department` WHERE `id` IN ('1', '2') |
| 9 | 16:16:04.094 | 1.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_street' AND kcu.table_name = 'tbl_street' |
| 10 | 16:16:04.184 | 1.6 ms | SELECT | SELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=1) ORDER BY `position` |
| 11 | 16:16:04.056 | 1.5 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_feed` |
| 12 | 16:16:04.100 | 1.4 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_client` |
| 13 | 16:16:04.114 | 1.3 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_meeting` |
| 14 | 16:16:04.053 | 1.3 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_user` |
| 15 | 16:16:04.106 | 1.1 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_phone` |
| 16 | 16:16:04.152 | 1.1 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_estate_image` |
| 17 | 16:16:04.127 | 1.1 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_location_source` |
| 18 | 16:16:04.089 | 1.0 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_currency` |
| 19 | 16:16:04.109 | 1.0 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_metro` |
| 20 | 16:16:04.093 | 0.9 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_street` |
| 21 | 16:16:04.181 | 0.9 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_metro_source` |
| 22 | 16:16:04.064 | 0.9 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_portal` |
| 23 | 16:16:04.111 | 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_metro' AND kcu.table_name = 'tbl_metro' |
| 24 | 16:16:04.182 | 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_metro_source' AND kcu.table_name = 'tbl_metro_source' |
| 25 | 16:16:04.171 | 0.8 ms | SELECT | SELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=31) ORDER BY `position` |
| 26 | 16:16:04.091 | 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_currency' AND kcu.table_name = 'tbl_currency' |
| 27 | 16:16:04.065 | 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_portal' AND kcu.table_name = 'tbl_portal' |
| 28 | 16:16:04.052 | 0.6 ms | SELECT | SELECT * FROM `tbl_user` WHERE (`id` IS NULL) AND (`status`='10') |
| 29 | 16:16:04.089 | 0.6 ms | SELECT | SELECT * FROM `tbl_currency` WHERE `id` IN (3, 2) ORDER BY `position` |
| 30 | 16:16:04.077 | 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_estate' AND kcu.table_name = 'tbl_estate' |
| 31 | 16:16:04.109 | 0.6 ms | SELECT | SELECT * FROM `tbl_metro` WHERE `id`=14 |
| 32 | 16:16:04.125 | 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`=668) AND (`t`.`portal_id`=2)) AND (`t`.`can_be_send`=1) ORDER BY `t`.`level` DESC |
| 33 | 16:16:04.187 | 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 |
| 34 | 16:16:04.157 | 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`=723) AND (`t`.`portal_id`=2)) AND (`t`.`can_be_send`=1) ORDER BY `t`.`level` DESC |
| 35 | 16:16:04.116 | 0.5 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' |
| 36 | 16:16:04.173 | 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`=636) AND (`t`.`portal_id`=2)) AND (`t`.`can_be_send`=1) ORDER BY `t`.`level` DESC |
| 37 | 16:16:04.144 | 0.5 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6860 |
| 38 | 16:16:04.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`=711) AND (`t`.`portal_id`=2)) AND (`t`.`can_be_send`=1) ORDER BY `t`.`level` DESC |
| 39 | 16:16:04.102 | 0.5 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' |
| 40 | 16:16:04.174 | 0.5 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6860 |
| 41 | 16:16:04.145 | 0.5 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6637 |
| 42 | 16:16:04.175 | 0.5 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6637 |
| 43 | 16:16:04.180 | 0.5 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6637 |
| 44 | 16:16:04.147 | 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') |
| 45 | 16:16:04.178 | 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`=674) AND (`t`.`portal_id`=2)) AND (`t`.`can_be_send`=1) ORDER BY `t`.`level` DESC |
| 46 | 16:16:04.167 | 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`=712) AND (`t`.`portal_id`=2)) AND (`t`.`can_be_send`=1) ORDER BY `t`.`level` DESC |
| 47 | 16:16:04.163 | 0.5 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6860 |
| 48 | 16:16:04.055 | 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_user' AND kcu.table_name = 'tbl_user' |
| 49 | 16:16:04.154 | 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_estate_image' AND kcu.table_name = 'tbl_estate_image' |
| 50 | 16:16:04.158 | 0.4 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6860 |
| 51 | 16:16:04.092 | 0.4 ms | SELECT | SELECT * FROM `tbl_street` WHERE `id` IN (857, 354, 326, 688, 64, 11098, 460) |
| 52 | 16:16:04.170 | 0.4 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') |
| 53 | 16:16:04.067 | 0.4 ms | SELECT | SELECT COUNT(*) FROM `tbl_user` WHERE `status`='10' |
| 54 | 16:16:04.107 | 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_phone' AND kcu.table_name = 'tbl_phone' |
| 55 | 16:16:04.188 | 0.4 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6860 |
| 56 | 16:16:04.168 | 0.4 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6860 |
| 57 | 16:16:04.160 | 0.4 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') |
| 58 | 16:16:04.164 | 0.4 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6637 |
| 59 | 16:16:04.179 | 0.4 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6860 |
| 60 | 16:16:04.181 | 0.4 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') |
| 61 | 16:16:04.058 | 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' |
| 62 | 16:16:04.169 | 0.4 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6637 |
| 63 | 16:16:04.189 | 0.4 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6637 |
| 64 | 16:16:04.165 | 0.4 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') |
| 65 | 16:16:04.161 | 0.3 ms | SELECT | SELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=29) ORDER BY `position` |
| 66 | 16:16:04.159 | 0.3 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6637 |
| 67 | 16:16:04.176 | 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') |
| 68 | 16:16:04.190 | 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') |
| 69 | 16:16:04.064 | 0.3 ms | SELECT | SELECT * FROM `tbl_portal` WHERE `id`=2 |
| 70 | 16:16:04.176 | 0.3 ms | SELECT | SELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=10) ORDER BY `position` |
| 71 | 16:16:04.117 | 0.3 ms | SELECT | SELECT * FROM `tbl_user` WHERE `id`=1 |
| 72 | 16:16:04.190 | 0.3 ms | SELECT | SELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=8) ORDER BY `position` |
| 73 | 16:16:04.166 | 0.3 ms | SELECT | SELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=30) ORDER BY `position` |
| 74 | 16:16:04.124 | 0.3 ms | SELECT | SELECT `username` FROM `tbl_user` WHERE `id` IN ('1', '15', '18', '16') |
| 75 | 16:16:04.186 | 0.2 ms | SELECT | SELECT `email` FROM `tbl_department` WHERE `id`='1' |
| 76 | 16:16:04.156 | 0.2 ms | SELECT | SELECT `email` FROM `tbl_department` WHERE `id`='2' |
| 77 | 16:16:04.059 | 0.2 ms | SELECT | SELECT * FROM `tbl_feed` WHERE `id`='2' ORDER BY `created_at` |
| 78 | 16:16:04.172 | 0.2 ms | SELECT | SELECT `email` FROM `tbl_department` WHERE `id`='1' |
| 79 | 16:16:04.157 | 0.2 ms | SELECT | SELECT `username` FROM `tbl_user` WHERE `id` IN ('1', '11', '16', '17') |
| 80 | 16:16:04.162 | 0.2 ms | SELECT | SELECT `email` FROM `tbl_department` WHERE `id`='1' |
| 81 | 16:16:04.178 | 0.2 ms | SELECT | SELECT `email` FROM `tbl_department` WHERE `id`='1' |
| 82 | 16:16:04.178 | 0.2 ms | SELECT | SELECT `username` FROM `tbl_user` WHERE `id` IN ('1', '2', '19') |
| 83 | 16:16:04.167 | 0.2 ms | SELECT | SELECT `email` FROM `tbl_department` WHERE FALSE |
| 84 | 16:16:04.167 | 0.1 ms | SELECT | SELECT `username` FROM `tbl_user` WHERE `id`='1' |
| 85 | 16:16:04.056 | 0.1 ms | SELECT | SELECT * FROM `tbl_user` WHERE `id` IS NULL |
| 86 | 16:16:04.187 | 0.1 ms | SELECT | SELECT `username` FROM `tbl_user` WHERE `id`='15' |
| 87 | 16:16:04.173 | 0.1 ms | SELECT | SELECT `username` FROM `tbl_user` WHERE `id`='1' |
| 88 | 16:16:04.162 | 0.1 ms | SELECT | SELECT `username` FROM `tbl_user` WHERE `id`='1' |