GET https://tadkik.online/manager/api/subscription/list?_t=1745065304308&t=1745065304306

Query Metrics

14 Database Queries
3 Different statements
8.82 ms Query time
0 Invalid entities
37 Managed entities

Queries

Group similar statements

default connection

# Time Info
1 1.83 ms
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.fiscal_id AS fiscal_id_3, t0.phone_number AS phone_number_4, t0.full_name AS full_name_5, t0.username AS username_6, t0.email AS email_7, t0.password AS password_8, t0.roles AS roles_9, t0.tenant_db_config_id AS tenant_db_config_id_10 FROM user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "supad@mail.com"
]
2 1.47 ms
SELECT t0.id AS id_1, t0.total_ht AS total_ht_2, t0.total_ttc AS total_ttc_3, t0.vat AS vat_4, t0.discount_applied AS discount_applied_5, t0.status AS status_6, t0.plan_id AS plan_id_7, t0.engagement_id AS engagement_id_8, t0.user_id AS user_id_9 FROM subscription t0
Parameters:
[]
3 0.92 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.base_price AS base_price_3, t0.logo AS logo_4, t0.description AS description_5, t0.type AS type_6 FROM plan t0 WHERE t0.id = ?
Parameters:
[
  2
]
4 0.61 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.base_price AS base_price_3, t0.logo AS logo_4, t0.description AS description_5, t0.type AS type_6 FROM plan t0 WHERE t0.id = ?
Parameters:
[
  4
]
5 0.53 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.base_price AS base_price_3, t0.logo AS logo_4, t0.description AS description_5, t0.type AS type_6 FROM plan t0 WHERE t0.id = ?
Parameters:
[
  5
]
6 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.base_price AS base_price_3, t0.logo AS logo_4, t0.description AS description_5, t0.type AS type_6 FROM plan t0 WHERE t0.id = ?
Parameters:
[
  6
]
7 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.base_price AS base_price_3, t0.logo AS logo_4, t0.description AS description_5, t0.type AS type_6 FROM plan t0 WHERE t0.id = ?
Parameters:
[
  7
]
8 0.47 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.base_price AS base_price_3, t0.logo AS logo_4, t0.description AS description_5, t0.type AS type_6 FROM plan t0 WHERE t0.id = ?
Parameters:
[
  8
]
9 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.base_price AS base_price_3, t0.logo AS logo_4, t0.description AS description_5, t0.type AS type_6 FROM plan t0 WHERE t0.id = ?
Parameters:
[
  9
]
10 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.base_price AS base_price_3, t0.logo AS logo_4, t0.description AS description_5, t0.type AS type_6 FROM plan t0 WHERE t0.id = ?
Parameters:
[
  10
]
11 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.base_price AS base_price_3, t0.logo AS logo_4, t0.description AS description_5, t0.type AS type_6 FROM plan t0 WHERE t0.id = ?
Parameters:
[
  11
]
12 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.base_price AS base_price_3, t0.logo AS logo_4, t0.description AS description_5, t0.type AS type_6 FROM plan t0 WHERE t0.id = ?
Parameters:
[
  12
]
13 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.base_price AS base_price_3, t0.logo AS logo_4, t0.description AS description_5, t0.type AS type_6 FROM plan t0 WHERE t0.id = ?
Parameters:
[
  13
]
14 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.base_price AS base_price_3, t0.logo AS logo_4, t0.description AS description_5, t0.type AS type_6 FROM plan t0 WHERE t0.id = ?
Parameters:
[
  14
]

Database Connections

Name Service
tenant doctrine.dbal.tenant_connection
default doctrine.dbal.default_connection

Entity Managers

Name Service
tenant doctrine.orm.tenant_entity_manager
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

tenant entity manager

Class Amount of managed objects

default entity manager

Class Amount of managed objects
App\Entity\Main\Subscription 12
App\Entity\Main\Plan 12
App\Entity\Main\User 10
App\Entity\Main\Engagement 3

Entities Mapping

tenant entity manager

No loaded entities.

default entity manager

Class Mapping errors
App\Entity\Main\User No errors.
App\Entity\Main\TenantDbConfig No errors.
App\Entity\Main\Subscription No errors.
App\Entity\Main\Plan No errors.
App\Entity\Main\Engagement No errors.
App\Entity\Main\Payment No errors.
App\Entity\Main\PlanFeature No errors.