| 1 |
0.23 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 2 |
37.85 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.99 ms |
SELECT COUNT(id) FROM vacancy_read WHERE status = ?
SELECT COUNT(id) FROM vacancy_read WHERE status = 'public';
|
| 4 |
0.52 ms |
SELECT id
FROM vacancy_publication
WHERE vacancy_id = ?
ORDER BY published_at DESC
OFFSET 0 LIMIT 1
Parameters: [
"019c513b-ee08-71d9-bb86-2248ec741f97"
]
SELECT id
FROM vacancy_publication
WHERE vacancy_id = '019c513b-ee08-71d9-bb86-2248ec741f97'
ORDER BY published_at DESC
OFFSET 0 LIMIT 1;
|
| 5 |
0.45 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;
|
| 6 |
0.46 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;
|
| 7 |
0.45 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;
|
| 8 |
0.46 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;
|
| 9 |
0.32 ms |
"COMMIT"
|
| 10 |
0.24 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 11 |
5.87 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 = '019c513b-ee08-71d9-bb86-2248ec741f97' ORDER BY created_at DESC LIMIT 1;
|
| 12 |
2.00 ms |
SELECT COUNT(id) FROM vacancy_read WHERE id = ?
SELECT COUNT(id) FROM vacancy_read WHERE id = '019c513b-ee08-71d9-bb86-2248ec741f97';
|
| 13 |
0.29 ms |
"COMMIT"
|
| 14 |
0.21 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 15 |
10.02 ms |
SELECT * FROM company_view WHERE id = ?
Parameters: [
"019c31ef-6056-712e-a4f0-087225049283"
]
SELECT * FROM company_view WHERE id = '019c31ef-6056-712e-a4f0-087225049283';
|
| 16 |
0.52 ms |
"COMMIT"
|
| 17 |
0.23 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 18 |
6.06 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;
|
| 19 |
2.01 ms |
SELECT COUNT(id) FROM vacancy_read WHERE id = ?
SELECT COUNT(id) FROM vacancy_read WHERE id = '019c09b3-d267-70e9-8ba1-066a008e7a39';
|
| 20 |
0.30 ms |
"COMMIT"
|
| 21 |
0.24 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 22 |
5.41 ms |
SELECT * FROM company_view WHERE id = ?
Parameters: [
"019928bf-6c98-7335-9538-a583751b6f76"
]
SELECT * FROM company_view WHERE id = '019928bf-6c98-7335-9538-a583751b6f76';
|
| 23 |
0.52 ms |
"COMMIT"
|
| 24 |
0.28 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 25 |
6.13 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;
|
| 26 |
1.90 ms |
SELECT COUNT(id) FROM vacancy_read WHERE id = ?
SELECT COUNT(id) FROM vacancy_read WHERE id = '019b313a-1cd0-73ca-acc0-5e0abf856736';
|
| 27 |
0.29 ms |
"COMMIT"
|
| 28 |
0.26 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 29 |
5.40 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.49 ms |
"COMMIT"
|
| 31 |
0.26 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 32 |
6.11 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;
|
| 33 |
1.96 ms |
SELECT COUNT(id) FROM vacancy_read WHERE id = ?
SELECT COUNT(id) FROM vacancy_read WHERE id = '019afdb6-2e5c-703c-98ee-c8afccfb4ac5';
|
| 34 |
0.27 ms |
"COMMIT"
|
| 35 |
0.25 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 36 |
5.26 ms |
SELECT * FROM company_view WHERE id = ?
Parameters: [
"019afd3d-8061-730a-997b-e9c9a37eb323"
]
SELECT * FROM company_view WHERE id = '019afd3d-8061-730a-997b-e9c9a37eb323';
|
| 37 |
0.47 ms |
"COMMIT"
|
| 38 |
0.17 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 39 |
5.99 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;
|
| 40 |
1.88 ms |
SELECT COUNT(id) FROM vacancy_read WHERE id = ?
SELECT COUNT(id) FROM vacancy_read WHERE id = '019afd78-9fb5-70e8-a765-33ffccb2157b';
|
| 41 |
0.26 ms |
"COMMIT"
|
| 42 |
0.23 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 43 |
5.42 ms |
SELECT * FROM company_view WHERE id = ?
Parameters: [
"019afd72-984b-7002-90f7-97c834ea58a6"
]
SELECT * FROM company_view WHERE id = '019afd72-984b-7002-90f7-97c834ea58a6';
|
| 44 |
0.51 ms |
"COMMIT"
|
