1
0.09 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
2
14.91 ms
SELECT * FROM company_view WHERE id = ?
Parameters :
[
"019928bf-6c98-7335-9538-a583751b6f76 "
]
SELECT * FROM company_view WHERE id = '019928bf-6c98-7335-9538-a583751b6f76' ; Copy
3
0.22 ms
"COMMIT"
4
0.10 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
5
8.54 ms
SELECT COUNT (f . id ) FROM company_feedback_read f WHERE (f . company_id = ? ) AND (f . moderation_status = ? )
SELECT COUNT (f . id ) FROM company_feedback_read f WHERE (f . company_id = '019928bf-6c98-7335-9538-a583751b6f76' ) AND (f . moderation_status = 'CONFIRMED' ); Copy
6
0.48 ms
"COMMIT"
7
0.09 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
8
8.19 ms
SELECT * FROM company_feedback_read f WHERE (f . company_id = ? ) AND (f . moderation_status = ? ) ORDER BY f . created_at DESC LIMIT 3
SELECT * FROM company_feedback_read f WHERE (f . company_id = '019928bf-6c98-7335-9538-a583751b6f76' ) AND (f . moderation_status = 'CONFIRMED' ) ORDER BY f . created_at DESC LIMIT 3 ; Copy
9
0.14 ms
"COMMIT"
10
0.09 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
11
23.34 ms
SELECT * , ST_AsEWKT (coordinates ) AS coordinates FROM vacancy_read WHERE (status = ? ) AND (company_id = ? ) ORDER BY created_at DESC LIMIT 10
Parameters :
[
"public "
"019928bf-6c98-7335-9538-a583751b6f76 "
]
SELECT * , ST_AsEWKT (coordinates ) AS coordinates FROM vacancy_read WHERE (status = 'public' ) AND (company_id = '019928bf-6c98-7335-9538-a583751b6f76' ) ORDER BY created_at DESC LIMIT 10 ; Copy
12
0.18 ms
"COMMIT"
13
0.12 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
14
1.99 ms
SELECT COUNT (id ) FROM vacancy_read WHERE (status = ? ) AND (company_id = ? )
Parameters :
[
"public "
"019928bf-6c98-7335-9538-a583751b6f76 "
]
SELECT COUNT (id ) FROM vacancy_read WHERE (status = 'public' ) AND (company_id = '019928bf-6c98-7335-9538-a583751b6f76' ); Copy
15
0.20 ms
"COMMIT"
16
0.13 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
17
1.88 ms
SELECT COUNT (d . id ) FROM deal_read d WHERE d . company_id = ?
SELECT COUNT (d . id ) FROM deal_read d WHERE d . company_id = '019928bf-6c98-7335-9538-a583751b6f76' ; Copy
18
0.15 ms
"COMMIT"
19
0.11 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
20
4.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 = '019c09b3-d267-70e9-8ba1-066a008e7a39' ORDER BY created_at DESC LIMIT 1 ; Copy
21
0.17 ms
"COMMIT"
22
0.15 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
23
4.46 ms
SELECT * FROM company_view WHERE id = ?
Parameters :
[
"019928bf-6c98-7335-9538-a583751b6f76 "
]
SELECT * FROM company_view WHERE id = '019928bf-6c98-7335-9538-a583751b6f76' ; Copy
24
0.14 ms
"COMMIT"
25
0.10 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
26
4.02 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 ; Copy
27
0.14 ms
"COMMIT"
28
0.11 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
29
4.98 ms
SELECT * FROM company_view WHERE id = ?
Parameters :
[
"019928bf-6c98-7335-9538-a583751b6f76 "
]
SELECT * FROM company_view WHERE id = '019928bf-6c98-7335-9538-a583751b6f76' ; Copy
30
0.14 ms
"COMMIT"
31
0.11 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
32
4.16 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 ; Copy
33
0.14 ms
"COMMIT"
34
0.09 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
35
4.29 ms
SELECT * FROM company_view WHERE id = ?
Parameters :
[
"019928bf-6c98-7335-9538-a583751b6f76 "
]
SELECT * FROM company_view WHERE id = '019928bf-6c98-7335-9538-a583751b6f76' ; Copy
36
0.14 ms
"COMMIT"
37
0.10 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
38
3.93 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 = '019928c8-ea8d-7021-844b-124d52ea793b' ORDER BY created_at DESC LIMIT 1 ; Copy
39
0.14 ms
"COMMIT"
40
0.10 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
41
4.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' ; Copy
42
0.23 ms
"COMMIT"
43
0.13 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
44
4.52 ms
SELECT * FROM company_view WHERE id = ?
Parameters :
[
"019928bf-6c98-7335-9538-a583751b6f76 "
]
SELECT * FROM company_view WHERE id = '019928bf-6c98-7335-9538-a583751b6f76' ; Copy
45
0.17 ms
"COMMIT"
46
0.09 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
47
1.80 ms
SELECT COUNT (id ) FROM vacancy_read WHERE (status = ? ) AND (company_id = ? )
Parameters :
[
"public "
"019928bf-6c98-7335-9538-a583751b6f76 "
]
SELECT COUNT (id ) FROM vacancy_read WHERE (status = 'public' ) AND (company_id = '019928bf-6c98-7335-9538-a583751b6f76' ); Copy
48
0.11 ms
"COMMIT"
49
0.10 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
50
1.70 ms
SELECT COUNT (d . id ) FROM deal_read d WHERE d . company_id = ?
SELECT COUNT (d . id ) FROM deal_read d WHERE d . company_id = '019928bf-6c98-7335-9538-a583751b6f76' ; Copy
51
0.18 ms
"COMMIT"
