Query Metrics
8
Database Queries
5
Different statements
2.40 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
0.86 ms (35.72%) |
2 |
INSERT INTO HttpLogs (type, userAgent, device, os, osVersion, routeName, url, method, status, appVersion, data, formData, IpAddress, createdAt, updatedAt, deletedAt, userId, organizationId, requestId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "REQUEST" null "" "UNK" "UNK" "oauth_server_token" "http://andrew.dev.exacthire.ngrok.app/api/public/oauth/token?subdomain=sandboxclient" "POST" null "1.0.0" Symfony\Component\HttpFoundation\Request {#13 : """ POST /api/public/oauth/token?subdomain=sandboxclient HTTP/1.1\r\n Accept: application/json\r\n Accept-Encoding: gzip,deflate\r\n Authorization: Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3OTAyNjgwOTQsImV4cCI6MTc5MDM1NDQ5NCwicm9sZXMiOlsiUk9MRV9BRE1JTklTVFJBVE9SIl0sInNjb3BlIjoiam9iczpyZWFkIGFwcGxpY2F0aW9uczpyZWFkIGFwcGxpY2F0aW9uczpzdGF0dXMgYXBwbGljYXRpb25zOm5vdGVzIGFwcGxpY2F0aW9uczphcmNoaXZlIGFwcGxpY2F0aW9uczpjb3B5IGFwcGxpY2F0aW9uczpjcmVhdGUgd2ViaG9va3M6bWFuYWdlIG9mZmxpbmVfYWNjZXNzIiwiZ2lkIjoxLCJnZW4iOjEsIm9yZ2FuaXphdGlvbklkIjozLCJpZCI6NjU3LCJ0aW1lWm9uZSI6bnVsbH0.ykgNXlGrIpTJl_8smaxpbn7RrnR-23qX_mB0pO-ozWifwJnCGzPOdzOgh0BsaA2PoYHCs7KBavkxPnzYzdlCZmrtVpuPRwsiXZUtQB-OpV_ArbdgYrYO0NiSYNEqSDFMShrdW6k2VAmqO8pjUe7bztcO4K8fA_X6og_p8hg7cu9aUIDQOtSh1jtlfizs0t8xS4VLrrJrnqRP-nzhWQda8LvkinoyK4mcYoJk2UvpdupNt3LtTQxfRT8CchwpwbDs5FtNsbC5E1lQIHD9WZ5Jw5oiTBcCC0VP1dPyp46_l_Jsd5g65uoc2WbYvEcFTniPi1a6Bv7EXlfQdetIE6sew8OLZ-6TXBSA4zppCuElzwq5IqWOWJ7FRMXIRtiYz9dOXAcBuFBLFysM9FQFqd2Q4pi6C11WQO5LkgGTIyk89uv93fG3IjNUWxd3cwDKY6zac23bldUUjmg2z4bosES0bn85tJdpjPfB_zV6M8RAFgOL0qqAXJNoUnsc6ERzSExMBJZGYDcXptM-yJbmiBJYhEgmsepx8MAWrKoRfQuSr2XlBjkbsM7JgBf3bLGlzbN5aetYS7bL2GD83RWALdJ6Xd8-qNYZpumJSpDuA0XdiPfwK72kU24aANZm_Dc-MXJfqu45DamUTH710XcL2dtWl20_2dkhFHcCmknktRSh8Xo\r\n Content-Length: 107\r\n Content-Type: application/x-www-form-urlencoded\r\n Host: andrew.dev.exacthire.ngrok.app\r\n User-Agent: Zapier\r\n X-Forwarded-For: 44.200.173.12\r\n X-Forwarded-Host: andrew.dev.exacthire.ngrok.app\r\n X-Forwarded-Proto: https\r\n X-Php-Ob-Level: 0\r\n X-Subdomain: sandboxclient\r\n \r\n refresh_token=1.1.705435b01fcc52f8f22ce1cca33d75f50003ed183febce48fe953ed4df2e9955&grant_type=refresh_token """ } "refresh_token=1.1.705435b01fcc52f8f22ce1cca33d75f50003ed183febce48fe953ed4df2e9955&grant_type=refresh_token" "44.200.173.12" "2026-09-28 20:02:31" "2026-09-28 20:02:31" null null null null ] |
|
0.56 ms (23.29%) |
1 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.clientId AS clientId_3, t0.clientSecretHash AS clientSecretHash_4, t0.redirectUris AS redirectUris_5, t0.environment AS environment_6, t0.clientName AS clientName_7, t0.dynamicallyRegisteredAt AS dynamicallyRegisteredAt_8, t0.isActive AS isActive_9, t0.createdAt AS createdAt_10, t0.updatedAt AS updatedAt_11, t0.deletedAt AS deletedAt_12, t0.providerId AS providerId_13 FROM ProviderClients t0 WHERE t0.clientId = ? AND t0.isActive = ? AND t0.type = ? AND ((t0.deletedAt IS NULL)) LIMIT 1
Parameters:
[ "" 1 "oauth2" ] |
|
0.37 ms (15.40%) |
1 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.userAgent AS userAgent_3, t0.device AS device_4, t0.os AS os_5, t0.osVersion AS osVersion_6, t0.routeName AS routeName_7, t0.url AS url_8, t0.method AS method_9, t0.status AS status_10, t0.appVersion AS appVersion_11, t0.data AS data_12, t0.formData AS formData_13, t0.IpAddress AS IpAddress_14, t0.createdAt AS createdAt_15, t0.updatedAt AS updatedAt_16, t0.deletedAt AS deletedAt_17, t0.userId AS userId_18, t0.organizationId AS organizationId_19, t0.requestId AS requestId_20 FROM HttpLogs t0 WHERE t0.id = ?
Parameters:
[
208545
]
|
|
0.36 ms (14.99%) |
2 |
"COMMIT"
Parameters:
[] |
|
0.25 ms (10.60%) |
2 |
"START TRANSACTION"
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| hirecentric | doctrine.dbal.hirecentric_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
| Class | Mapping errors |
|---|---|
| ExactHireApi\Entity\ProviderClient | No errors. |
| ExactHireApi\Entity\Provider | No errors. |