6a39022a043ea: GET http://dev.recrm.com.ua/feed/export?id=2 at 2026-06-22 12:36:42 pm by 114.119.147.71
Database Queries
| # | Time | Duration | Type | Query |
|---|---|---|---|---|
| 1 | 12:36:42.086 | 18.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_location_source' AND kcu.table_name = 'tbl_location_source' |
| 2 | 12:36:42.110 | 3.1 ms | SELECT | SELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=28) ORDER BY `position` |
| 3 | 12:36:42.035 | 2.6 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') |
| 4 | 12:36:42.059 | 2.3 ms | SELECT | SELECT * FROM `tbl_client` WHERE `id` IN (20, 6, 14, 1, 28) |
| 5 | 12:36:42.072 | 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 |
| 6 | 12:36:42.065 | 1.8 ms | SELECT | SELECT * FROM `tbl_phone` WHERE (`owner_name`='client') AND (`owner_id` IN (1, 6, 14, 20, 28)) |
| 7 | 12:36:42.080 | 1.7 ms | SELECT | SELECT `email` FROM `tbl_department` WHERE `id` IN ('1', '2') |
| 8 | 12:36:42.038 | 1.6 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_estate` |
| 9 | 12:36:42.056 | 1.3 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_street` |
| 10 | 12:36:42.142 | 1.3 ms | SELECT | SELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=1) ORDER BY `position` |
| 11 | 12:36:42.140 | 1.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_metro_source' AND kcu.table_name = 'tbl_metro_source' |
| 12 | 12:36:42.023 | 1.2 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_feed` |
| 13 | 12:36:42.062 | 1.1 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_client` |
| 14 | 12:36:42.074 | 1.0 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_meeting` |
| 15 | 12:36:42.113 | 1.0 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_estate_image` |
| 16 | 12:36:42.021 | 1.0 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_user` |
| 17 | 12:36:42.067 | 1.0 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_phone` |
| 18 | 12:36:42.085 | 1.0 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_location_source` |
| 19 | 12:36:42.052 | 0.9 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_currency` |
| 20 | 12:36:42.058 | 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_street' AND kcu.table_name = 'tbl_street' |
| 21 | 12:36:42.139 | 0.8 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_metro_source` |
| 22 | 12:36:42.030 | 0.8 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_portal` |
| 23 | 12:36:42.070 | 0.7 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_metro` |
| 24 | 12:36:42.054 | 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' |
| 25 | 12:36:42.031 | 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' |
| 26 | 12:36:42.130 | 0.6 ms | SELECT | SELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=31) ORDER BY `position` |
| 27 | 12:36:42.052 | 0.6 ms | SELECT | SELECT * FROM `tbl_currency` WHERE `id` IN (3, 2) ORDER BY `position` |
| 28 | 12:36:42.071 | 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 | 12:36:42.117 | 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 | 12:36:42.083 | 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 |
| 31 | 12:36:42.069 | 0.6 ms | SELECT | SELECT * FROM `tbl_metro` WHERE `id`=14 |
| 32 | 12:36:42.020 | 0.6 ms | SELECT | SELECT * FROM `tbl_user` WHERE (`id` IS NULL) AND (`status`='10') |
| 33 | 12:36:42.145 | 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`=662) AND (`t`.`portal_id`=2)) AND (`t`.`can_be_send`=1) ORDER BY `t`.`level` DESC |
| 34 | 12:36:42.105 | 0.5 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6860 |
| 35 | 12:36:42.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') |
| 36 | 12:36:42.122 | 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 |
| 37 | 12:36:42.029 | 0.5 ms | SELECT | SELECT * FROM `tbl_portal` WHERE `id`=2 |
| 38 | 12:36:42.137 | 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 |
| 39 | 12:36:42.138 | 0.5 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6860 |
| 40 | 12:36:42.132 | 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 |
| 41 | 12:36:42.118 | 0.4 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6860 |
| 42 | 12:36:42.127 | 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`=712) AND (`t`.`portal_id`=2)) AND (`t`.`can_be_send`=1) ORDER BY `t`.`level` DESC |
| 43 | 12:36:42.128 | 0.4 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6637 |
| 44 | 12:36:42.108 | 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') |
| 45 | 12:36:42.106 | 0.4 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6637 |
| 46 | 12:36:42.146 | 0.4 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6637 |
| 47 | 12:36:42.064 | 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_client' AND kcu.table_name = 'tbl_client' |
| 48 | 12:36:42.055 | 0.4 ms | SELECT | SELECT * FROM `tbl_street` WHERE `id` IN (857, 354, 326, 688, 64, 11098, 460) |
| 49 | 12:36:42.133 | 0.4 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6637 |
| 50 | 12:36:42.041 | 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' AND kcu.table_name = 'tbl_estate' |
| 51 | 12:36:42.146 | 0.4 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6860 |
| 52 | 12:36:42.075 | 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_meeting' AND kcu.table_name = 'tbl_meeting' |
| 53 | 12:36:42.120 | 0.4 ms | SELECT | SELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=29) ORDER BY `position` |
| 54 | 12:36:42.129 | 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') |
| 55 | 12:36:42.119 | 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') |
| 56 | 12:36:42.128 | 0.4 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6860 |
| 57 | 12:36:42.135 | 0.4 ms | SELECT | SELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=10) ORDER BY `position` |
| 58 | 12:36:42.119 | 0.4 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6637 |
| 59 | 12:36:42.134 | 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') |
| 60 | 12:36:42.148 | 0.4 ms | SELECT | SELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=8) ORDER BY `position` |
| 61 | 12:36:42.123 | 0.3 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6860 |
| 62 | 12:36:42.022 | 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_user' AND kcu.table_name = 'tbl_user' |
| 63 | 12:36:42.125 | 0.3 ms | SELECT | SELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=30) ORDER BY `position` |
| 64 | 12:36:42.133 | 0.3 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6860 |
| 65 | 12:36:42.139 | 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') |
| 66 | 12:36:42.138 | 0.3 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6637 |
| 67 | 12:36:42.124 | 0.3 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6637 |
| 68 | 12:36:42.124 | 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 | 12:36:42.025 | 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_feed' AND kcu.table_name = 'tbl_feed' |
| 70 | 12:36:42.114 | 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' |
| 71 | 12:36:42.032 | 0.3 ms | SELECT | SELECT COUNT(*) FROM `tbl_user` WHERE `status`='10' |
| 72 | 12:36:42.068 | 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_phone' AND kcu.table_name = 'tbl_phone' |
| 73 | 12:36:42.121 | 0.2 ms | SELECT | SELECT `email` FROM `tbl_department` WHERE `id`='1' |
| 74 | 12:36:42.131 | 0.2 ms | SELECT | SELECT `email` FROM `tbl_department` WHERE `id`='1' |
| 75 | 12:36:42.076 | 0.2 ms | SELECT | SELECT * FROM `tbl_user` WHERE `id`=1 |
| 76 | 12:36:42.116 | 0.2 ms | SELECT | SELECT `email` FROM `tbl_department` WHERE `id`='2' |
| 77 | 12:36:42.025 | 0.2 ms | SELECT | SELECT * FROM `tbl_feed` WHERE `id`='2' ORDER BY `created_at` |
| 78 | 12:36:42.144 | 0.2 ms | SELECT | SELECT `email` FROM `tbl_department` WHERE `id`='1' |
| 79 | 12:36:42.117 | 0.2 ms | SELECT | SELECT `username` FROM `tbl_user` WHERE `id` IN ('1', '11', '16', '17') |
| 80 | 12:36:42.082 | 0.2 ms | SELECT | SELECT `username` FROM `tbl_user` WHERE `id` IN ('1', '15', '18', '16') |
| 81 | 12:36:42.136 | 0.2 ms | SELECT | SELECT `email` FROM `tbl_department` WHERE `id`='1' |
| 82 | 12:36:42.126 | 0.2 ms | SELECT | SELECT `email` FROM `tbl_department` WHERE FALSE |
| 83 | 12:36:42.126 | 0.1 ms | SELECT | SELECT `username` FROM `tbl_user` WHERE `id`='1' |
| 84 | 12:36:42.136 | 0.1 ms | SELECT | SELECT `username` FROM `tbl_user` WHERE `id` IN ('1', '2', '19') |
| 85 | 12:36:42.131 | 0.1 ms | SELECT | SELECT `username` FROM `tbl_user` WHERE `id`='1' |
| 86 | 12:36:42.144 | 0.1 ms | SELECT | SELECT `username` FROM `tbl_user` WHERE `id`='15' |
| 87 | 12:36:42.122 | 0.1 ms | SELECT | SELECT `username` FROM `tbl_user` WHERE `id`='1' |
| 88 | 12:36:42.023 | 0.1 ms | SELECT | SELECT * FROM `tbl_user` WHERE `id` IS NULL |