| 1 |
0.27 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 2 |
28.43 ms |
SELECT *, ST_AsEWKT(coordinates) AS coordinates FROM vacancy_read WHERE status = ? ORDER BY created_at DESC LIMIT 0
SELECT *, ST_AsEWKT(coordinates) AS coordinates FROM vacancy_read WHERE status = 'public' ORDER BY created_at DESC LIMIT 0;
|
| 3 |
2.62 ms |
SELECT COUNT(id) FROM vacancy_read WHERE status = ?
SELECT COUNT(id) FROM vacancy_read WHERE status = 'public';
|
| 4 |
0.21 ms |
"COMMIT"
|
| 5 |
0.12 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 6 |
8.79 ms |
SELECT *, ST_AsEWKT(coordinates) AS coordinates FROM vacancy_read WHERE status = ? ORDER BY created_at DESC LIMIT 10
SELECT *, ST_AsEWKT(coordinates) AS coordinates FROM vacancy_read WHERE status = 'public' ORDER BY created_at DESC LIMIT 10;
|
| 7 |
1.95 ms |
SELECT COUNT(id) FROM vacancy_read WHERE status = ?
SELECT COUNT(id) FROM vacancy_read WHERE status = 'public';
|
| 8 |
0.40 ms |
SELECT id
FROM vacancy_publication
WHERE vacancy_id = ?
ORDER BY published_at DESC
OFFSET 0 LIMIT 1
Parameters: [
"019d5367-e342-70e2-b367-8a51c0fb7764"
]
SELECT id
FROM vacancy_publication
WHERE vacancy_id = '019d5367-e342-70e2-b367-8a51c0fb7764'
ORDER BY published_at DESC
OFFSET 0 LIMIT 1;
|
| 9 |
0.30 ms |
SELECT id
FROM vacancy_publication
WHERE vacancy_id = ?
ORDER BY published_at DESC
OFFSET 0 LIMIT 1
Parameters: [
"019c09b3-d267-70e9-8ba1-066a008e7a39"
]
SELECT id
FROM vacancy_publication
WHERE vacancy_id = '019c09b3-d267-70e9-8ba1-066a008e7a39'
ORDER BY published_at DESC
OFFSET 0 LIMIT 1;
|
| 10 |
0.30 ms |
SELECT id
FROM vacancy_publication
WHERE vacancy_id = ?
ORDER BY published_at DESC
OFFSET 0 LIMIT 1
Parameters: [
"019b313a-1cd0-73ca-acc0-5e0abf856736"
]
SELECT id
FROM vacancy_publication
WHERE vacancy_id = '019b313a-1cd0-73ca-acc0-5e0abf856736'
ORDER BY published_at DESC
OFFSET 0 LIMIT 1;
|
| 11 |
0.29 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;
|
| 12 |
0.25 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;
|
| 13 |
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;
|
| 14 |
0.24 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;
|
| 15 |
0.19 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;
|
| 16 |
0.18 ms |
SELECT id
FROM vacancy_publication
WHERE vacancy_id = ?
ORDER BY published_at DESC
OFFSET 0 LIMIT 1
Parameters: [
"01994cfb-807d-7312-bab2-a668daf33fb9"
]
SELECT id
FROM vacancy_publication
WHERE vacancy_id = '01994cfb-807d-7312-bab2-a668daf33fb9'
ORDER BY published_at DESC
OFFSET 0 LIMIT 1;
|
| 17 |
0.18 ms |
SELECT id
FROM vacancy_publication
WHERE vacancy_id = ?
ORDER BY published_at DESC
OFFSET 0 LIMIT 1
Parameters: [
"019928f5-ee50-701e-99a3-b67422353c71"
]
SELECT id
FROM vacancy_publication
WHERE vacancy_id = '019928f5-ee50-701e-99a3-b67422353c71'
ORDER BY published_at DESC
OFFSET 0 LIMIT 1;
|
| 18 |
0.10 ms |
"COMMIT"
|
| 19 |
0.09 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 20 |
3.95 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 = '019d5367-e342-70e2-b367-8a51c0fb7764' ORDER BY created_at DESC LIMIT 1;
|
| 21 |
0.16 ms |
"COMMIT"
|
| 22 |
0.15 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 23 |
9.47 ms |
SELECT * FROM company_view WHERE id = ?
Parameters: [
"019d5364-2179-73eb-a978-c26d17484b89"
]
SELECT * FROM company_view WHERE id = '019d5364-2179-73eb-a978-c26d17484b89';
|
| 24 |
0.40 ms |
"COMMIT"
|
| 25 |
0.13 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 26 |
4.53 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 = '019c09b3-d267-70e9-8ba1-066a008e7a39' ORDER BY created_at DESC LIMIT 1;
|
| 27 |
0.20 ms |
"COMMIT"
|
| 28 |
0.12 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 29 |
5.36 ms |
SELECT * FROM company_view WHERE id = ?
Parameters: [
"019928bf-6c98-7335-9538-a583751b6f76"
]
SELECT * FROM company_view WHERE id = '019928bf-6c98-7335-9538-a583751b6f76';
|
| 30 |
0.37 ms |
"COMMIT"
|
| 31 |
0.24 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 32 |
4.53 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 = '019b313a-1cd0-73ca-acc0-5e0abf856736' ORDER BY created_at DESC LIMIT 1;
|
| 33 |
0.15 ms |
"COMMIT"
|
| 34 |
0.09 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 35 |
5.13 ms |
SELECT * FROM company_view WHERE id = ?
Parameters: [
"019928bf-6c98-7335-9538-a583751b6f76"
]
SELECT * FROM company_view WHERE id = '019928bf-6c98-7335-9538-a583751b6f76';
|
| 36 |
0.33 ms |
"COMMIT"
|
| 37 |
0.08 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 38 |
4.46 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;
|
| 39 |
0.12 ms |
"COMMIT"
|
| 40 |
0.08 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 41 |
5.15 ms |
SELECT * FROM company_view WHERE id = ?
Parameters: [
"019afd3d-8061-730a-997b-e9c9a37eb323"
]
SELECT * FROM company_view WHERE id = '019afd3d-8061-730a-997b-e9c9a37eb323';
|
| 42 |
0.44 ms |
"COMMIT"
|
| 43 |
0.19 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 44 |
4.53 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;
|
| 45 |
0.13 ms |
"COMMIT"
|
| 46 |
0.08 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 47 |
5.18 ms |
SELECT * FROM company_view WHERE id = ?
Parameters: [
"019afd72-984b-7002-90f7-97c834ea58a6"
]
SELECT * FROM company_view WHERE id = '019afd72-984b-7002-90f7-97c834ea58a6';
|
| 48 |
0.34 ms |
"COMMIT"
|
| 49 |
0.10 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 50 |
4.49 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;
|
| 51 |
0.13 ms |
"COMMIT"
|
| 52 |
0.11 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 53 |
5.34 ms |
SELECT * FROM company_view WHERE id = ?
Parameters: [
"019afd3d-8061-730a-997b-e9c9a37eb323"
]
SELECT * FROM company_view WHERE id = '019afd3d-8061-730a-997b-e9c9a37eb323';
|
| 54 |
0.37 ms |
"COMMIT"
|
| 55 |
0.16 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 56 |
4.53 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;
|
| 57 |
0.17 ms |
"COMMIT"
|
| 58 |
0.12 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 59 |
5.20 ms |
SELECT * FROM company_view WHERE id = ?
Parameters: [
"01997a4e-cf54-7124-8097-5acd4ff2fef6"
]
SELECT * FROM company_view WHERE id = '01997a4e-cf54-7124-8097-5acd4ff2fef6';
|
| 60 |
0.37 ms |
"COMMIT"
|
| 61 |
0.12 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 62 |
4.61 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;
|
| 63 |
0.18 ms |
"COMMIT"
|
| 64 |
0.10 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 65 |
5.87 ms |
SELECT * FROM company_view WHERE id = ?
Parameters: [
"01994cfa-365d-73aa-9ffb-ca62bd7fbc63"
]
SELECT * FROM company_view WHERE id = '01994cfa-365d-73aa-9ffb-ca62bd7fbc63';
|
| 66 |
0.38 ms |
"COMMIT"
|
| 67 |
0.19 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 68 |
4.57 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 = '01994cfb-807d-7312-bab2-a668daf33fb9' ORDER BY created_at DESC LIMIT 1;
|
| 69 |
0.15 ms |
"COMMIT"
|
| 70 |
0.24 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 71 |
5.55 ms |
SELECT * FROM company_view WHERE id = ?
Parameters: [
"01994cfa-365d-73aa-9ffb-ca62bd7fbc63"
]
SELECT * FROM company_view WHERE id = '01994cfa-365d-73aa-9ffb-ca62bd7fbc63';
|
| 72 |
0.47 ms |
"COMMIT"
|
| 73 |
0.14 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 74 |
5.43 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 = '019928f5-ee50-701e-99a3-b67422353c71' ORDER BY created_at DESC LIMIT 1;
|
| 75 |
0.23 ms |
"COMMIT"
|
| 76 |
0.14 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 77 |
5.44 ms |
SELECT * FROM company_view WHERE id = ?
Parameters: [
"019928bf-6c98-7335-9538-a583751b6f76"
]
SELECT * FROM company_view WHERE id = '019928bf-6c98-7335-9538-a583751b6f76';
|
| 78 |
0.44 ms |
"COMMIT"
|
