6a453709a5faf: GET http://dev.recrm.com.ua/feed/export?id=2 at 2026-07-01 06:49:29 pm by 114.119.132.89
Database Queries
| # | Time | Duration | Type | Query |
|---|---|---|---|---|
| 1 | 18:49:29.747 | 19.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' |
| 2 | 18:49:29.771 | 3.2 ms | SELECT | SELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=28) ORDER BY `position` |
| 3 | 18:49:29.719 | 2.3 ms | SELECT | SELECT * FROM `tbl_client` WHERE `id` IN (20, 6, 14, 1, 28) |
| 4 | 18:49:29.700 | 2.0 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_estate` |
| 5 | 18:49:29.698 | 1.8 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') |
| 6 | 18:49:29.733 | 1.8 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 |
| 7 | 18:49:29.741 | 1.8 ms | SELECT | SELECT `email` FROM `tbl_department` WHERE `id` IN ('1', '2') |
| 8 | 18:49:29.725 | 1.7 ms | SELECT | SELECT * FROM `tbl_phone` WHERE (`owner_name`='client') AND (`owner_id` IN (1, 6, 14, 20, 28)) |
| 9 | 18:49:29.805 | 1.7 ms | SELECT | SELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=1) ORDER BY `position` |
| 10 | 18:49:29.686 | 1.4 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_feed` |
| 11 | 18:49:29.803 | 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 | 18:49:29.723 | 1.2 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_client` |
| 13 | 18:49:29.684 | 1.1 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_user` |
| 14 | 18:49:29.775 | 1.1 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_estate_image` |
| 15 | 18:49:29.746 | 1.0 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_location_source` |
| 16 | 18:49:29.730 | 1.0 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_metro` |
| 17 | 18:49:29.717 | 1.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_street' AND kcu.table_name = 'tbl_street' |
| 18 | 18:49:29.735 | 1.0 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_meeting` |
| 19 | 18:49:29.716 | 0.9 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_street` |
| 20 | 18:49:29.727 | 0.9 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_phone` |
| 21 | 18:49:29.731 | 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_metro' AND kcu.table_name = 'tbl_metro' |
| 22 | 18:49:29.713 | 0.8 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_currency` |
| 23 | 18:49:29.802 | 0.8 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_metro_source` |
| 24 | 18:49:29.793 | 0.8 ms | SELECT | SELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=31) ORDER BY `position` |
| 25 | 18:49:29.694 | 0.8 ms | SHOW | SHOW FULL COLUMNS FROM `tbl_portal` |
| 26 | 18:49:29.729 | 0.8 ms | SELECT | SELECT * FROM `tbl_metro` WHERE `id`=14 |
| 27 | 18:49:29.715 | 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' |
| 28 | 18:49:29.779 | 0.7 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 |
| 29 | 18:49:29.786 | 0.6 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6860 |
| 30 | 18:49:29.695 | 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_portal' AND kcu.table_name = 'tbl_portal' |
| 31 | 18:49:29.785 | 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`=711) AND (`t`.`portal_id`=2)) AND (`t`.`can_be_send`=1) ORDER BY `t`.`level` DESC |
| 32 | 18:49:29.744 | 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 | 18:49:29.713 | 0.6 ms | SELECT | SELECT * FROM `tbl_currency` WHERE `id` IN (3, 2) ORDER BY `position` |
| 34 | 18:49:29.780 | 0.6 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6860 |
| 35 | 18:49:29.683 | 0.6 ms | SELECT | SELECT * FROM `tbl_user` WHERE (`id` IS NULL) AND (`status`='10') |
| 36 | 18:49:29.800 | 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 |
| 37 | 18:49:29.767 | 0.5 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6860 |
| 38 | 18:49:29.809 | 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 |
| 39 | 18:49:29.769 | 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') |
| 40 | 18:49:29.787 | 0.5 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6637 |
| 41 | 18:49:29.796 | 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 |
| 42 | 18:49:29.783 | 0.5 ms | SELECT | SELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=29) ORDER BY `position` |
| 43 | 18:49:29.790 | 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 |
| 44 | 18:49:29.716 | 0.4 ms | SELECT | SELECT * FROM `tbl_street` WHERE `id` IN (857, 354, 326, 688, 64, 11098, 460) |
| 45 | 18:49:29.811 | 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') |
| 46 | 18:49:29.704 | 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' |
| 47 | 18:49:29.796 | 0.4 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6860 |
| 48 | 18:49:29.768 | 0.4 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6637 |
| 49 | 18:49:29.782 | 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') |
| 50 | 18:49:29.685 | 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' |
| 51 | 18:49:29.696 | 0.4 ms | SELECT | SELECT COUNT(*) FROM `tbl_user` WHERE `status`='10' |
| 52 | 18:49:29.724 | 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' |
| 53 | 18:49:29.792 | 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') |
| 54 | 18:49:29.810 | 0.4 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6637 |
| 55 | 18:49:29.809 | 0.4 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6860 |
| 56 | 18:49:29.736 | 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' |
| 57 | 18:49:29.781 | 0.4 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6637 |
| 58 | 18:49:29.801 | 0.4 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6860 |
| 59 | 18:49:29.776 | 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' |
| 60 | 18:49:29.797 | 0.3 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6637 |
| 61 | 18:49:29.789 | 0.3 ms | SELECT | SELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=30) ORDER BY `position` |
| 62 | 18:49:29.792 | 0.3 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6637 |
| 63 | 18:49:29.801 | 0.3 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6637 |
| 64 | 18:49:29.791 | 0.3 ms | SELECT | SELECT * FROM `tbl_location_source` WHERE `id`=6860 |
| 65 | 18:49:29.788 | 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') |
| 66 | 18:49:29.688 | 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' |
| 67 | 18:49:29.798 | 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 | 18:49:29.802 | 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') |
| 69 | 18:49:29.798 | 0.3 ms | SELECT | SELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=10) ORDER BY `position` |
| 70 | 18:49:29.693 | 0.3 ms | SELECT | SELECT * FROM `tbl_portal` WHERE `id`=2 |
| 71 | 18:49:29.728 | 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' |
| 72 | 18:49:29.812 | 0.3 ms | SELECT | SELECT * FROM `tbl_estate_image` WHERE (`not_upload`=0) AND (`estate_id`=8) ORDER BY `position` |
| 73 | 18:49:29.784 | 0.3 ms | SELECT | SELECT `email` FROM `tbl_department` WHERE `id`='1' |
| 74 | 18:49:29.779 | 0.3 ms | SELECT | SELECT `username` FROM `tbl_user` WHERE `id` IN ('1', '11', '16', '17') |
| 75 | 18:49:29.778 | 0.2 ms | SELECT | SELECT `email` FROM `tbl_department` WHERE `id`='2' |
| 76 | 18:49:29.790 | 0.2 ms | SELECT | SELECT `email` FROM `tbl_department` WHERE FALSE |
| 77 | 18:49:29.808 | 0.2 ms | SELECT | SELECT `email` FROM `tbl_department` WHERE `id`='1' |
| 78 | 18:49:29.743 | 0.2 ms | SELECT | SELECT `username` FROM `tbl_user` WHERE `id` IN ('1', '15', '18', '16') |
| 79 | 18:49:29.795 | 0.2 ms | SELECT | SELECT `email` FROM `tbl_department` WHERE `id`='1' |
| 80 | 18:49:29.790 | 0.2 ms | SELECT | SELECT `username` FROM `tbl_user` WHERE `id`='1' |
| 81 | 18:49:29.799 | 0.2 ms | SELECT | SELECT `email` FROM `tbl_department` WHERE `id`='1' |
| 82 | 18:49:29.737 | 0.2 ms | SELECT | SELECT * FROM `tbl_user` WHERE `id`=1 |
| 83 | 18:49:29.689 | 0.2 ms | SELECT | SELECT * FROM `tbl_feed` WHERE `id`='2' ORDER BY `created_at` |
| 84 | 18:49:29.785 | 0.1 ms | SELECT | SELECT `username` FROM `tbl_user` WHERE `id`='1' |
| 85 | 18:49:29.800 | 0.1 ms | SELECT | SELECT `username` FROM `tbl_user` WHERE `id` IN ('1', '2', '19') |
| 86 | 18:49:29.686 | 0.1 ms | SELECT | SELECT * FROM `tbl_user` WHERE `id` IS NULL |
| 87 | 18:49:29.808 | 0.1 ms | SELECT | SELECT `username` FROM `tbl_user` WHERE `id`='15' |
| 88 | 18:49:29.795 | 0.1 ms | SELECT | SELECT `username` FROM `tbl_user` WHERE `id`='1' |