1
0.07 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
2
14.57 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.27 ms
"COMMIT"
4
0.12 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
5
8.39 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.39 ms
"COMMIT"
7
0.12 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
8
7.71 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.18 ms
"COMMIT"
10
0.11 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
11
21.66 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.24 ms
"COMMIT"
13
0.13 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
14
1.84 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.14 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
17
1.60 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.11 ms
"COMMIT"
19
0.11 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
20
3.83 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.12 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
23
4.42 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.22 ms
"COMMIT"
25
0.14 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
26
3.73 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.17 ms
"COMMIT"
28
0.13 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
29
3.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' ; Copy
30
0.18 ms
"COMMIT"
31
0.16 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
32
3.58 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.12 ms
"COMMIT"
34
0.13 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
35
6.06 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.22 ms
"COMMIT"
37
0.14 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
38
5.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 = '019928c8-ea8d-7021-844b-124d52ea793b' ORDER BY created_at DESC LIMIT 1 ; Copy
39
0.19 ms
"COMMIT"
40
0.16 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
41
5.92 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.15 ms
"COMMIT"
43
0.15 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
44
5.27 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.21 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
47
2.51 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.18 ms
"COMMIT"
49
0.13 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
50
2.37 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.19 ms
"COMMIT"
