1
0.12 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
2
15.08 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.20 ms
"COMMIT"
4
0.13 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
5
7.89 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.40 ms
"COMMIT"
7
0.09 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
8
8.21 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.25 ms
"COMMIT"
10
0.17 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
11
22.40 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.20 ms
"COMMIT"
13
0.12 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
14
1.86 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.21 ms
"COMMIT"
16
0.09 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
17
1.64 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.21 ms
"COMMIT"
19
0.20 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
20
3.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 = '019c09b3-d267-70e9-8ba1-066a008e7a39' ORDER BY created_at DESC LIMIT 1 ; Copy
21
0.15 ms
"COMMIT"
22
0.15 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
23
3.94 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.18 ms
"COMMIT"
25
0.14 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
26
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 = '019b313a-1cd0-73ca-acc0-5e0abf856736' ORDER BY created_at DESC LIMIT 1 ; Copy
27
0.16 ms
"COMMIT"
28
0.14 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
29
4.24 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.18 ms
"COMMIT"
31
0.13 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
32
4.10 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.13 ms
"COMMIT"
34
0.08 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
35
4.30 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.13 ms
"COMMIT"
37
0.10 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
38
3.50 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.20 ms
"COMMIT"
40
0.09 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
41
3.84 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.12 ms
"COMMIT"
43
0.11 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
44
3.82 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.22 ms
"COMMIT"
46
0.11 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
47
1.62 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.20 ms
"COMMIT"
49
0.11 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
50
1.58 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.16 ms
"COMMIT"
