GET https://cobraclaro.blackhorse.solutions/cobranza/

Query Metrics

9 Database Queries
7 Different statements
19.77 ms Query time
0 Invalid entities
3 Managed entities

Grouped Statements

Show all queries

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.