CREATE TABLE `nurse` ( `staff_ ... ERENCES `ward` ... |
HospitalDB |
|
1 |
0 |
0 |
1.21 s |
1.21 s |
1.21 s |
0 |
0 |
0 |
0 |
2024-09-27 21:31:38.979933 |
2024-09-27 21:31:38.979933 |
fe06b71605e0d4bc6902e8c9c3c610d6a589b3eb68303efde0... |
CREATE TABLE `treatment` ( `st ... S `patient` ( `... |
HospitalDB |
|
1 |
0 |
0 |
275.06 ms |
275.06 ms |
275.06 ms |
0 |
0 |
0 |
0 |
2024-09-27 21:31:40.057314 |
2024-09-27 21:31:40.057314 |
3862ed37e4769f366b43964498622c8ada66d21299eb846768... |
CREATE TABLE `patient` ( `pati ... ERENCES `ward` ... |
HospitalDB |
|
1 |
0 |
0 |
272.79 ms |
272.79 ms |
272.79 ms |
0 |
0 |
0 |
0 |
2024-09-27 21:31:39.580866 |
2024-09-27 21:31:39.580866 |
41b72a9f3bbe56a422f7fc021ac11bc5e316f7d08b940397d3... |
CREATE TABLE `consists_of` ( ` ... ENCES `team` ( ... |
HospitalDB |
|
1 |
0 |
0 |
258.22 ms |
258.22 ms |
258.22 ms |
0 |
0 |
0 |
0 |
2024-09-27 21:31:41.040739 |
2024-09-27 21:31:41.040739 |
a04bec1f66cb88ff7dd9182dcb283e68a45c020f0ab8539723... |
CREATE TABLE `supervises` ( `s ... ENCES `nurse` (... |
HospitalDB |
|
1 |
0 |
0 |
256.18 ms |
256.18 ms |
256.18 ms |
0 |
0 |
0 |
0 |
2024-09-27 21:31:40.781682 |
2024-09-27 21:31:40.781682 |
9b4b04338504104292f71c33b9dcfdb06e48b5abe109a07b2a... |
CREATE TABLE `prescription` ( ... ENCES `drug` ( ... |
HospitalDB |
|
1 |
0 |
0 |
254.51 ms |
254.51 ms |
254.51 ms |
0 |
0 |
0 |
0 |
2024-09-27 21:31:40.524759 |
2024-09-27 21:31:40.524759 |
58f9b5f6ad7993ae1f2e66956e339292fcf4253ee82c6d881a... |
CREATE TABLE `ward` ( `ward_no ... , PRIMARY KEY ... |
HospitalDB |
|
1 |
0 |
0 |
246.52 ms |
246.52 ms |
246.52 ms |
0 |
0 |
0 |
0 |
2024-09-27 21:31:37.764969 |
2024-09-27 21:31:37.764969 |
05aff47ce99272f89cec481d74a164c5f94c82f66615830ac5... |
CREATE TABLE `drug` ( `drug_co ... PRIMARY KEY ( ... |
HospitalDB |
|
1 |
0 |
0 |
211.57 ms |
211.57 ms |
211.57 ms |
0 |
0 |
0 |
0 |
2024-09-27 21:31:40.269482 |
2024-09-27 21:31:40.269482 |
cfbd74847340463ad346aedd82c1639e51ed4c9062e7e5868e... |
CREATE TABLE `team` ( `team_co ... NCES `doctor` (... |
HospitalDB |
|
1 |
0 |
0 |
200.40 ms |
200.40 ms |
200.40 ms |
0 |
0 |
0 |
0 |
2024-09-27 21:31:39.782081 |
2024-09-27 21:31:39.782081 |
8a2a9bfcc43abd3b950d9c76e77f853b0a5cf48f9674d2eb93... |
CREATE TABLE `small_ward` ( `w ... , PRIMARY KEY ... |
HospitalDB |
|
1 |
0 |
0 |
199.78 ms |
199.78 ms |
199.78 ms |
0 |
0 |
0 |
0 |
2024-09-27 21:31:41.414507 |
2024-09-27 21:31:41.414507 |
3628790b48c8c54a547f634eb1f959150cdf46ce42ebcf6277... |
CREATE TABLE `specialist` ( `s ... NCES `doctor` (... |
HospitalDB |
|
1 |
0 |
0 |
174.69 ms |
174.69 ms |
174.69 ms |
0 |
0 |
0 |
0 |
2024-09-27 21:31:39.307648 |
2024-09-27 21:31:39.307648 |
72cbd1f282307f7e38f4e2b15f75ce6cbe4428a22d4767b54b... |
CREATE TABLE `small_occupied_b ... PRIMARY KEY ( `... |
HospitalDB |
|
1 |
0 |
0 |
172.71 ms |
172.71 ms |
172.71 ms |
0 |
0 |
0 |
0 |
2024-09-27 21:31:41.213861 |
2024-09-27 21:31:41.213861 |
4719d0127fac0253dfd909dd286be3d976c782c5108b1f61dd... |
CREATE TABLE `doctor` ( `staff ... , PRIMARY KEY (... |
HospitalDB |
|
1 |
0 |
0 |
152.38 ms |
152.38 ms |
152.38 ms |
0 |
0 |
0 |
0 |
2024-09-27 21:31:39.132657 |
2024-09-27 21:31:39.132657 |
06ae246c1655cce32681416e483c7fe7e7e5b1f52b276d1c3c... |
SELECT COUNT (?) AS `cnt` , `r ... y_by_digest` GR... |
sys |
* |
3 |
0 |
0 |
443.74 ms |
395.26 ms |
147.91 ms |
2 |
1 |
3745 |
1248 |
2024-09-27 21:31:50.144340 |
2024-09-27 21:31:50.279380 |
92ff97b05a2a2e654025eae1e78fdeafead5be7e942f76f5dc... |
SELECT `a` . `actor_id` AS `ac ... irst_name` , `a... |
sakila |
* |
12 |
0 |
0 |
1.51 s |
345.79 ms |
125.97 ms |
29 |
2 |
1614019 |
134502 |
2024-09-27 21:31:05.538531 |
2024-09-27 21:32:24.083726 |
91c1850ed235cf0a034cf8492d2dec30e38a40c16f4dc5a7c6... |
SELECT IF ( ( `locate` ( ? , ` ... ` . `COMPRESSED... |
sys |
* |
5 |
0 |
0 |
505.17 ms |
340.99 ms |
101.03 ms |
9 |
2 |
9 |
2 |
2024-09-27 21:32:10.666194 |
2024-09-27 21:32:19.268333 |
c552f840b97cf2c164de85ef343eae0b410364ed59846f9192... |
CREATE SCHEMA `HospitalDB` |
NULL
|
|
1 |
0 |
0 |
76.05 ms |
76.05 ms |
76.05 ms |
0 |
0 |
0 |
0 |
2024-09-27 21:31:37.517608 |
2024-09-27 21:31:37.517608 |
982b333f314cf67d71bb95692203554280c60eed85d601a46e... |
CREATE VIEW `occupying` ( `pat ... . `ward_no` = ... |
HospitalDB |
|
1 |
0 |
0 |
66.86 ms |
66.86 ms |
66.86 ms |
0 |
0 |
0 |
0 |
2024-09-27 21:31:45.059215 |
2024-09-27 21:31:45.059215 |
919687556eed08b818112d1ca8ceaf533e6edd5abf9c0d88db... |
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... |
sakila |
* |
7 |
0 |
0 |
461.62 ms |
379.98 ms |
65.95 ms |
73 |
10 |
527 |
75 |
2024-09-27 21:31:03.139272 |
2024-09-27 21:32:31.722877 |
ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... |
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... |
sys |
* |
7 |
0 |
0 |
409.41 ms |
398.62 ms |
58.49 ms |
107 |
15 |
2675 |
382 |
2024-09-27 21:31:49.760810 |
2024-09-27 21:32:53.111577 |
ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... |
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... |
NULL
|
|
1 |
0 |
0 |
52.78 ms |
52.78 ms |
52.78 ms |
4 |
4 |
31 |
31 |
2024-09-27 21:32:25.724872 |
2024-09-27 21:32:25.724872 |
e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... |
INSERT INTO `small_occupied_by ... id` , `ward_no`... |
HospitalDB |
|
3 |
0 |
0 |
150.95 ms |
58.91 ms |
50.32 ms |
0 |
0 |
0 |
0 |
2024-09-27 21:31:44.811750 |
2024-09-27 21:31:44.904687 |
404ea664927beb4e6020ece81da71637ef5d96e0b627111dde... |
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... |
HospitalDB |
* |
7 |
0 |
0 |
343.23 ms |
337.16 ms |
49.03 ms |
59 |
8 |
392 |
56 |
2024-09-27 21:31:47.979902 |
2024-09-27 21:32:21.447673 |
ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... |
INSERT INTO `small_ward` ( `wa ... me` , `no_beds`... |
HospitalDB |
|
2 |
0 |
0 |
84.43 ms |
47.42 ms |
42.21 ms |
0 |
0 |
0 |
0 |
2024-09-27 21:31:44.953174 |
2024-09-27 21:31:44.991424 |
ea7fb0536ec80b5d53f0ff96cf877755a2c18d41b80b3c1bfd... |
SELECT `c` . `name` AS `catego ... e` ORDER BY `to... |
sakila |
* |
3 |
0 |
0 |
121.75 ms |
71.91 ms |
40.58 ms |
17 |
6 |
17 |
6 |
2024-09-27 21:32:17.218310 |
2024-09-27 21:32:17.378024 |
a5caeb258efa481e69eb8ef233fdcdc5da21db15e515ca13d4... |