Query Metrics
9
Database Queries
7
Different statements
19.77 ms
Query time
0
Invalid entities
3
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
7.56 ms (38.25%) |
2 |
SELECT a0_.id AS id_0, a0_.uuid AS uuid_1, a0_.share_token AS share_token_2, a0_.name AS name_3, a0_.description AS description_4, a0_.discount_percent AS discount_percent_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a0_.deleted_at AS deleted_at_8, c1_.id AS id_9, c1_.uuid AS uuid_10, c1_.name AS name_11, c1_.email AS email_12, c1_.phone AS phone_13, c1_.alias AS alias_14, c1_.credit_days AS credit_days_15, c1_.discount_percent AS discount_percent_16, c1_.notes AS notes_17, c1_.is_active AS is_active_18, c1_.created_at AS created_at_19, c1_.updated_at AS updated_at_20, c1_.deleted_at AS deleted_at_21, a0_.contact_id AS contact_id_22, a0_.organization_id AS organization_id_23, c1_.organization_id AS organization_id_24 FROM account a0_ INNER JOIN contact c1_ ON a0_.contact_id = c1_.id WHERE a0_.deleted_at IS NULL AND a0_.organization_id IN (?, ?) ORDER BY c1_.name ASC, a0_.name ASC
Parameters:
[ 2 1 ]
|
||||||||||||||||||||||||||||||||
|
2.47 ms (12.47%) |
1 |
SELECT SUM(p0_.amount) AS sclr_0 FROM payment p0_ WHERE p0_.deleted_at IS NULL AND p0_.paid_at >= ? AND p0_.paid_at <= ? AND p0_.organization_id IN (?, ?)
Parameters:
[ "2026-09-01 03:10:33" "2026-09-30 23:59:59" 2 1 ]
|
||||||||||||||||||||||||||||||||
|
2.26 ms (11.42%) |
2 |
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.name AS name_2, c0_.email AS email_3, c0_.phone AS phone_4, c0_.alias AS alias_5, c0_.credit_days AS credit_days_6, c0_.discount_percent AS discount_percent_7, c0_.notes AS notes_8, c0_.is_active AS is_active_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11, c0_.deleted_at AS deleted_at_12, c0_.organization_id AS organization_id_13 FROM contact c0_ WHERE c0_.deleted_at IS NULL AND c0_.organization_id IN (?, ?) ORDER BY c0_.name ASC
Parameters:
[ 2 1 ]
|
||||||||||||||||||||||||||||||||
|
2.06 ms (10.41%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.name AS name_4, t0.roles AS roles_5, t0.theme AS theme_6, t0.is_active AS is_active_7, t0.telegram_chat_id AS telegram_chat_id_8, t0.telegram_link_token AS telegram_link_token_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.organization_id AS organization_id_13 FROM "user" t0 WHERE t0.id = ?
Parameters:
[
2
]
|
||||||||||||||||||||||||||||||||
|
1.93 ms (9.75%) |
1 |
SELECT a0_.id AS id_0, a0_.uuid AS uuid_1, a0_.share_token AS share_token_2, a0_.name AS name_3, a0_.description AS description_4, a0_.discount_percent AS discount_percent_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a0_.deleted_at AS deleted_at_8, c1_.id AS id_9, c1_.uuid AS uuid_10, c1_.name AS name_11, c1_.email AS email_12, c1_.phone AS phone_13, c1_.alias AS alias_14, c1_.credit_days AS credit_days_15, c1_.discount_percent AS discount_percent_16, c1_.notes AS notes_17, c1_.is_active AS is_active_18, c1_.created_at AS created_at_19, c1_.updated_at AS updated_at_20, c1_.deleted_at AS deleted_at_21, a0_.contact_id AS contact_id_22, a0_.organization_id AS organization_id_23, c1_.organization_id AS organization_id_24 FROM account a0_ INNER JOIN contact c1_ ON a0_.contact_id = c1_.id WHERE a0_.deleted_at IS NULL AND a0_.organization_id IN (?, ?) ORDER BY c1_.name ASC, a0_.name ASC LIMIT 1000
Parameters:
[ 2 1 ]
|
||||||||||||||||||||||||||||||||
|
1.81 ms (9.15%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.primary_color AS primary_color_5, t0.secondary_color AS secondary_color_6, t0.accent_color AS accent_color_7, t0.navbar_color AS navbar_color_8, t0.logo_path AS logo_path_9, t0.timezone AS timezone_10, t0.plan AS plan_11, t0.billing_started_at AS billing_started_at_12, t0.plan_expires_at AS plan_expires_at_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM organization t0 WHERE t0.id = ?
Parameters:
[
2
]
|
||||||||||||||||||||||||||||||||
|
1.69 ms (8.54%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.primary_color AS primary_color_5, t0.secondary_color AS secondary_color_6, t0.accent_color AS accent_color_7, t0.navbar_color AS navbar_color_8, t0.logo_path AS logo_path_9, t0.timezone AS timezone_10, t0.plan AS plan_11, t0.billing_started_at AS billing_started_at_12, t0.plan_expires_at AS plan_expires_at_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM organization t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"sistema"
]
|
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 |
|---|---|
| App\Entity\Organization | 2 |
| App\Entity\User | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Organization | No errors. |
| App\Entity\Contact | No errors. |
| App\Entity\BillingPayment | No errors. |
| App\Entity\WhatsAppConfig | No errors. |
| App\Entity\Account | No errors. |
| App\Entity\Payment | No errors. |