Query Metrics
7
Database Queries
7
Different statements
16.02 ms
Query time
0
Invalid entities
5
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.45 ms |
SELECT t0.id AS id_1, t0.roles AS roles_2, t0.password AS password_3, t0.avatar AS avatar_4, t0.full_path_avatar AS full_path_avatar_5, t0.email AS email_6, t0.name AS name_7 FROM administration_user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"yankervip@gmail.com"
]
|
| 2 | 0.96 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.organization_id AS organization_id_3 FROM administration_project t0 WHERE t0.id = ?
Parameters:
[ Ramsey\Uuid\Lazy\LazyUuidFromString {#2731 : "cce0d658-3d37-4eb3-936c-cc6cad514074" } ] |
| 3 | 1.74 ms |
SELECT t0.id AS id_1, t0.logo AS logo_2, t0.full_path_logo AS full_path_logo_3, t0.name AS name_4 FROM administration_organization t0 INNER JOIN administration_user_organization ON t0.id = administration_user_organization.organization_id WHERE administration_user_organization.amply_user_id = ?
Parameters:
[
"413049a2-edcd-430f-b955-a0dfdae60678"
]
|
| 4 | 0.38 ms |
"START TRANSACTION"
Parameters:
[] |
| 5 | 2.76 ms |
INSERT INTO campaign (id, type, state, name, triggering, targeting, content, created_at, updated_at, project_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "18779279-4d83-40eb-a246-42c3ab9dfa12" "RateReview" "Draft" "asdasd" "{"event":"MyEvent","repeat":{"repeatType":"interval","repeatEntity":"session","repeatValue":[1],"subRepeat":{"repeatType":"every","repeatEntity":"event","repeatValue":[2,5],"subRepeat":null}},"limit":{"count":7,"limit":2,"limitType":"session","interval":2,"intervalDimension":"day"}}" "[{"country":{"type":"include","values":["AI","AF"]}},{"osVersion":{"compareType":"equal","value":"1"}},{"osVersion":{"compareType":"equal","value":"1"}},{"appVersion":{"compareType":"equal","value":"1"}},{"appVersion":{"compareType":"equal","value":"1"}},{"appInstallVersion":{"compareType":"equal","value":"1"}},{"application":{"type":"include","values":["c30db438-3e6b-42f2-8983-e7faecfba38c"]}}]" null "2025-05-04 12:04:33" "2025-05-04 12:04:33" "cce0d658-3d37-4eb3-936c-cc6cad514074" ] |
| 6 | 6.64 ms |
"COMMIT"
Parameters:
[] |
| 7 | 1.09 ms |
SELECT t0.id AS id_1, t0.bundle_id AS bundle_id_2, t0.platform AS platform_3, t0.name AS name_4, t0.project_id AS project_id_5 FROM administration_application t0 WHERE t0.id IN (?)
Parameters:
[
"c30db438-3e6b-42f2-8983-e7faecfba38c"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_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 |
|---|---|
| Amply\Administration\Entity\AmplyUser | 1 |
| Amply\Administration\Entity\Project | 1 |
| Amply\Administration\Entity\Organization | 1 |
| Amply\Campaign\Entity\Campaign | 1 |
| Amply\Administration\Entity\Application | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| Amply\Administration\Entity\AmplyUser | No errors. |
| Amply\Administration\Entity\Organization | No errors. |
| Amply\Administration\Entity\Project | No errors. |
| Amply\Administration\Entity\Application | No errors. |
| Amply\Campaign\Entity\Campaign | No errors. |
| Amply\Administration\Entity\ApiKey | No errors. |