| 1 |
0.14 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 2 |
29.88 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.40 ms |
SELECT COUNT(id) FROM vacancy_read WHERE status = ?
SELECT COUNT(id) FROM vacancy_read WHERE status = 'public';
|
| 4 |
0.39 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.29 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.26 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.20 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.13 ms |
"COMMIT"
|
| 10 |
0.13 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 11 |
4.70 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.63 ms |
SELECT COUNT(id) FROM vacancy_read WHERE id = ?
SELECT COUNT(id) FROM vacancy_read WHERE id = '019afdb6-2e5c-703c-98ee-c8afccfb4ac5';
|
| 13 |
0.21 ms |
"COMMIT"
|
| 14 |
0.15 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 15 |
8.18 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.14 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 18 |
4.71 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.55 ms |
SELECT COUNT(id) FROM vacancy_read WHERE id = ?
SELECT COUNT(id) FROM vacancy_read WHERE id = '019afd78-9fb5-70e8-a765-33ffccb2157b';
|
| 20 |
0.21 ms |
"COMMIT"
|
| 21 |
0.22 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 22 |
4.19 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.33 ms |
"COMMIT"
|
| 24 |
0.09 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 25 |
4.85 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.52 ms |
SELECT COUNT(id) FROM vacancy_read WHERE id = ?
SELECT COUNT(id) FROM vacancy_read WHERE id = '019afd4a-6c33-7214-9577-4909759e3b3c';
|
| 27 |
0.21 ms |
"COMMIT"
|
| 28 |
0.17 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 29 |
4.33 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.41 ms |
"COMMIT"
|
| 31 |
0.09 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 32 |
4.83 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.55 ms |
SELECT COUNT(id) FROM vacancy_read WHERE id = ?
SELECT COUNT(id) FROM vacancy_read WHERE id = '01997a4f-2b13-7280-9de8-be6b58ffd5b1';
|
| 34 |
0.16 ms |
"COMMIT"
|
| 35 |
0.08 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 36 |
4.28 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.37 ms |
"COMMIT"
|
| 38 |
0.19 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 39 |
4.79 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.52 ms |
SELECT COUNT(id) FROM vacancy_read WHERE id = ?
SELECT COUNT(id) FROM vacancy_read WHERE id = '01994d11-9b38-7155-af08-5ce80a96ebad';
|
| 41 |
0.14 ms |
"COMMIT"
|
| 42 |
0.25 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 43 |
4.26 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.38 ms |
"COMMIT"
|
