| 1 |
0.14 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 2 |
32.31 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.97 ms |
SELECT COUNT(id) FROM vacancy_read WHERE status = ?
SELECT COUNT(id) FROM vacancy_read WHERE status = 'public';
|
| 4 |
0.46 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;
|
| 5 |
0.57 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.34 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.34 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.33 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.21 ms |
"COMMIT"
|
| 10 |
0.11 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 11 |
7.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 = '019d5367-e342-70e2-b367-8a51c0fb7764' ORDER BY created_at DESC LIMIT 1;
|
| 12 |
2.74 ms |
SELECT COUNT(id) FROM vacancy_read WHERE id = ?
SELECT COUNT(id) FROM vacancy_read WHERE id = '019d5367-e342-70e2-b367-8a51c0fb7764';
|
| 13 |
0.23 ms |
"COMMIT"
|
| 14 |
0.17 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 15 |
14.29 ms |
SELECT * FROM company_view WHERE id = ?
Parameters: [
"019d5364-2179-73eb-a978-c26d17484b89"
]
SELECT * FROM company_view WHERE id = '019d5364-2179-73eb-a978-c26d17484b89';
|
| 16 |
0.24 ms |
"COMMIT"
|
| 17 |
0.18 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 18 |
6.66 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.51 ms |
SELECT COUNT(id) FROM vacancy_read WHERE id = ?
SELECT COUNT(id) FROM vacancy_read WHERE id = '019c09b3-d267-70e9-8ba1-066a008e7a39';
|
| 20 |
0.16 ms |
"COMMIT"
|
| 21 |
0.17 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 22 |
5.95 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.25 ms |
"COMMIT"
|
| 24 |
0.16 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 25 |
6.39 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 |
2.48 ms |
SELECT COUNT(id) FROM vacancy_read WHERE id = ?
SELECT COUNT(id) FROM vacancy_read WHERE id = '019b313a-1cd0-73ca-acc0-5e0abf856736';
|
| 27 |
0.21 ms |
"COMMIT"
|
| 28 |
0.18 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 29 |
5.90 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.19 ms |
"COMMIT"
|
| 31 |
0.11 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 32 |
6.40 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 |
2.55 ms |
SELECT COUNT(id) FROM vacancy_read WHERE id = ?
SELECT COUNT(id) FROM vacancy_read WHERE id = '019afdb6-2e5c-703c-98ee-c8afccfb4ac5';
|
| 34 |
0.18 ms |
"COMMIT"
|
| 35 |
0.10 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 36 |
5.99 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.22 ms |
"COMMIT"
|
| 38 |
0.18 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 39 |
6.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;
|
| 40 |
2.30 ms |
SELECT COUNT(id) FROM vacancy_read WHERE id = ?
SELECT COUNT(id) FROM vacancy_read WHERE id = '019afd78-9fb5-70e8-a765-33ffccb2157b';
|
| 41 |
0.17 ms |
"COMMIT"
|
| 42 |
0.12 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 43 |
5.56 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.20 ms |
"COMMIT"
|
