| 1 |
0.13 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 2 |
27.79 ms |
SELECT *, ST_AsEWKT(coordinates) AS coordinates FROM vacancy_read WHERE status = ? ORDER BY created_at DESC LIMIT 5
SELECT *, ST_AsEWKT(coordinates) AS coordinates FROM vacancy_read WHERE status = 'public' ORDER BY created_at DESC LIMIT 5;
|
| 3 |
2.51 ms |
SELECT COUNT(id) FROM vacancy_read WHERE status = ?
SELECT COUNT(id) FROM vacancy_read WHERE status = 'public';
|
| 4 |
0.37 ms |
SELECT id
FROM vacancy_publication
WHERE vacancy_id = ?
ORDER BY published_at DESC
OFFSET 0 LIMIT 1
Parameters: [
"019afdb6-2e5c-703c-98ee-c8afccfb4ac5"
]
SELECT id
FROM vacancy_publication
WHERE vacancy_id = '019afdb6-2e5c-703c-98ee-c8afccfb4ac5'
ORDER BY published_at DESC
OFFSET 0 LIMIT 1;
|
| 5 |
0.32 ms |
SELECT id
FROM vacancy_publication
WHERE vacancy_id = ?
ORDER BY published_at DESC
OFFSET 0 LIMIT 1
Parameters: [
"019afd78-9fb5-70e8-a765-33ffccb2157b"
]
SELECT id
FROM vacancy_publication
WHERE vacancy_id = '019afd78-9fb5-70e8-a765-33ffccb2157b'
ORDER BY published_at DESC
OFFSET 0 LIMIT 1;
|
| 6 |
0.30 ms |
SELECT id
FROM vacancy_publication
WHERE vacancy_id = ?
ORDER BY published_at DESC
OFFSET 0 LIMIT 1
Parameters: [
"019afd4a-6c33-7214-9577-4909759e3b3c"
]
SELECT id
FROM vacancy_publication
WHERE vacancy_id = '019afd4a-6c33-7214-9577-4909759e3b3c'
ORDER BY published_at DESC
OFFSET 0 LIMIT 1;
|
| 7 |
0.30 ms |
SELECT id
FROM vacancy_publication
WHERE vacancy_id = ?
ORDER BY published_at DESC
OFFSET 0 LIMIT 1
Parameters: [
"01997a4f-2b13-7280-9de8-be6b58ffd5b1"
]
SELECT id
FROM vacancy_publication
WHERE vacancy_id = '01997a4f-2b13-7280-9de8-be6b58ffd5b1'
ORDER BY published_at DESC
OFFSET 0 LIMIT 1;
|
| 8 |
0.25 ms |
SELECT id
FROM vacancy_publication
WHERE vacancy_id = ?
ORDER BY published_at DESC
OFFSET 0 LIMIT 1
Parameters: [
"01994d11-9b38-7155-af08-5ce80a96ebad"
]
SELECT id
FROM vacancy_publication
WHERE vacancy_id = '01994d11-9b38-7155-af08-5ce80a96ebad'
ORDER BY published_at DESC
OFFSET 0 LIMIT 1;
|
| 9 |
0.11 ms |
"COMMIT"
|
| 10 |
0.17 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 11 |
4.21 ms |
SELECT *, ST_AsEWKT(coordinates) AS coordinates FROM vacancy_read WHERE id = ? ORDER BY created_at DESC LIMIT 1
SELECT *, ST_AsEWKT(coordinates) AS coordinates FROM vacancy_read WHERE id = '019afdb6-2e5c-703c-98ee-c8afccfb4ac5' ORDER BY created_at DESC LIMIT 1;
|
| 12 |
1.39 ms |
SELECT COUNT(id) FROM vacancy_read WHERE id = ?
SELECT COUNT(id) FROM vacancy_read WHERE id = '019afdb6-2e5c-703c-98ee-c8afccfb4ac5';
|
| 13 |
0.20 ms |
"COMMIT"
|
| 14 |
0.17 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 15 |
7.56 ms |
SELECT * FROM company_view WHERE id = ?
Parameters: [
"019afd3d-8061-730a-997b-e9c9a37eb323"
]
SELECT * FROM company_view WHERE id = '019afd3d-8061-730a-997b-e9c9a37eb323';
|
| 16 |
0.39 ms |
"COMMIT"
|
| 17 |
0.17 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 18 |
4.33 ms |
SELECT *, ST_AsEWKT(coordinates) AS coordinates FROM vacancy_read WHERE id = ? ORDER BY created_at DESC LIMIT 1
SELECT *, ST_AsEWKT(coordinates) AS coordinates FROM vacancy_read WHERE id = '019afd78-9fb5-70e8-a765-33ffccb2157b' ORDER BY created_at DESC LIMIT 1;
|
| 19 |
1.39 ms |
SELECT COUNT(id) FROM vacancy_read WHERE id = ?
SELECT COUNT(id) FROM vacancy_read WHERE id = '019afd78-9fb5-70e8-a765-33ffccb2157b';
|
| 20 |
0.20 ms |
"COMMIT"
|
| 21 |
0.16 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 22 |
3.80 ms |
SELECT * FROM company_view WHERE id = ?
Parameters: [
"019afd72-984b-7002-90f7-97c834ea58a6"
]
SELECT * FROM company_view WHERE id = '019afd72-984b-7002-90f7-97c834ea58a6';
|
| 23 |
0.34 ms |
"COMMIT"
|
| 24 |
0.20 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 25 |
4.26 ms |
SELECT *, ST_AsEWKT(coordinates) AS coordinates FROM vacancy_read WHERE id = ? ORDER BY created_at DESC LIMIT 1
SELECT *, ST_AsEWKT(coordinates) AS coordinates FROM vacancy_read WHERE id = '019afd4a-6c33-7214-9577-4909759e3b3c' ORDER BY created_at DESC LIMIT 1;
|
| 26 |
1.30 ms |
SELECT COUNT(id) FROM vacancy_read WHERE id = ?
SELECT COUNT(id) FROM vacancy_read WHERE id = '019afd4a-6c33-7214-9577-4909759e3b3c';
|
| 27 |
0.10 ms |
"COMMIT"
|
| 28 |
0.26 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 29 |
3.80 ms |
SELECT * FROM company_view WHERE id = ?
Parameters: [
"019afd3d-8061-730a-997b-e9c9a37eb323"
]
SELECT * FROM company_view WHERE id = '019afd3d-8061-730a-997b-e9c9a37eb323';
|
| 30 |
0.34 ms |
"COMMIT"
|
| 31 |
0.18 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 32 |
4.24 ms |
SELECT *, ST_AsEWKT(coordinates) AS coordinates FROM vacancy_read WHERE id = ? ORDER BY created_at DESC LIMIT 1
SELECT *, ST_AsEWKT(coordinates) AS coordinates FROM vacancy_read WHERE id = '01997a4f-2b13-7280-9de8-be6b58ffd5b1' ORDER BY created_at DESC LIMIT 1;
|
| 33 |
1.36 ms |
SELECT COUNT(id) FROM vacancy_read WHERE id = ?
SELECT COUNT(id) FROM vacancy_read WHERE id = '01997a4f-2b13-7280-9de8-be6b58ffd5b1';
|
| 34 |
0.20 ms |
"COMMIT"
|
| 35 |
0.14 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 36 |
3.77 ms |
SELECT * FROM company_view WHERE id = ?
Parameters: [
"01997a4e-cf54-7124-8097-5acd4ff2fef6"
]
SELECT * FROM company_view WHERE id = '01997a4e-cf54-7124-8097-5acd4ff2fef6';
|
| 37 |
0.30 ms |
"COMMIT"
|
| 38 |
0.16 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 39 |
4.26 ms |
SELECT *, ST_AsEWKT(coordinates) AS coordinates FROM vacancy_read WHERE id = ? ORDER BY created_at DESC LIMIT 1
SELECT *, ST_AsEWKT(coordinates) AS coordinates FROM vacancy_read WHERE id = '01994d11-9b38-7155-af08-5ce80a96ebad' ORDER BY created_at DESC LIMIT 1;
|
| 40 |
1.30 ms |
SELECT COUNT(id) FROM vacancy_read WHERE id = ?
SELECT COUNT(id) FROM vacancy_read WHERE id = '01994d11-9b38-7155-af08-5ce80a96ebad';
|
| 41 |
0.17 ms |
"COMMIT"
|
| 42 |
0.14 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 43 |
3.75 ms |
SELECT * FROM company_view WHERE id = ?
Parameters: [
"01994cfa-365d-73aa-9ffb-ca62bd7fbc63"
]
SELECT * FROM company_view WHERE id = '01994cfa-365d-73aa-9ffb-ca62bd7fbc63';
|
| 44 |
0.32 ms |
"COMMIT"
|
