Query Metrics
7
Database Queries
7
Different statements
18.56 ms
Query time
0
Invalid entities
Grouped Statements
default connection
Time▼ | Count | Info |
---|---|---|
4.86 ms (26.17%) |
1 |
SELECT t0.id AS id_1, t0.fqdn AS fqdn_2, t0.username AS username_3, t0.host AS host_4, t0.password AS password_5, t0.databaseName AS databaseName_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.tenant_id AS tenant_id_10, t11.id AS id_12, t11.uuid AS uuid_13, t11.created_at AS created_at_14, t11.updated_at AS updated_at_15, t11.deleted_at AS deleted_at_16, t11.local AS local_17 FROM Hostname t0 INNER JOIN Tenant t11 ON t0.tenant_id = t11.id WHERE t0.fqdn = ? LIMIT 1
Parameters:
[
"baizel"
]
|
tenant connection
Time▼ | Count | Info |
---|---|---|
4.89 ms (26.34%) |
1 |
SELECT t0.id AS id_1, t0.createdAt AS createdAt_2, t0.updatedAt AS updatedAt_3, t0.finalDate AS finalDate_4, t0.subscriber_id AS subscriber_id_5 FROM FreeTrial t0 WHERE t0.subscriber_id = ?
Parameters:
[
10
]
|
3.83 ms (20.62%) |
1 |
SELECT t0.id AS id_1, t0.createdAt AS createdAt_2, t0.updatedAt AS updatedAt_3, t0.name AS name_4, t0.frequencyValue AS frequencyValue_5, t0.frequencyUnit AS frequencyUnit_6, t0.enabled AS enabled_7, t0.deadlineAfterExpiry AS deadlineAfterExpiry_8, t0.price AS price_9, t0.description AS description_10, t0.permissions AS permissions_11 FROM Plan t0 WHERE t0.id = ?
Parameters:
[
2
]
|
3.04 ms (16.37%) |
1 |
SELECT t0.id AS id_1, t0.createdAt AS createdAt_2, t0.updatedAt AS updatedAt_3, t0.externalId AS externalId_4, t0.name AS name_5, t0.lastName AS lastName_6, t0.email AS email_7, t8.id AS id_9, t8.createdAt AS createdAt_10, t8.updatedAt AS updatedAt_11, t8.finalDate AS finalDate_12, t8.subscriber_id AS subscriber_id_13, t14.id AS id_15, t14.createdAt AS createdAt_16, t14.updatedAt AS updatedAt_17, t14.status AS status_18, t14.serviceEnabled AS serviceEnabled_19, t14.cancelled AS cancelled_20, t14.nextRenewalDate AS nextRenewalDate_21, t14.lastRenewalDate AS lastRenewalDate_22, t14.subscriber_id AS subscriber_id_23, t14.plan_id AS plan_id_24 FROM Subscriber t0 LEFT JOIN FreeTrial t8 ON t8.subscriber_id = t0.id LEFT JOIN Subscription t14 ON t14.subscriber_id = t0.id WHERE t0.externalId = ? LIMIT 1
Parameters:
[
"kokoriko.com.co"
]
|
0.74 ms (3.97%) |
1 |
SELECT t0.id AS id_1, t0.createdAt AS createdAt_2, t0.name AS name_3, t0.description AS description_4, t0.price AS price_5 FROM Module t0 INNER JOIN module_subscription ON t0.id = module_subscription.module_id WHERE module_subscription.subscription_id = ?
Parameters:
[
3
]
|
0.69 ms (3.74%) |
1 |
SELECT t0.id AS id_1, t0.createdAt AS createdAt_2, t0.updatedAt AS updatedAt_3, t0.status AS status_4, t0.serviceEnabled AS serviceEnabled_5, t0.cancelled AS cancelled_6, t0.nextRenewalDate AS nextRenewalDate_7, t0.lastRenewalDate AS lastRenewalDate_8, t0.subscriber_id AS subscriber_id_9, t0.plan_id AS plan_id_10 FROM Subscription t0 WHERE t0.subscriber_id = ?
Parameters:
[
10
]
|
0.52 ms (2.79%) |
1 |
SELECT s0_.id AS id_0, s0_.createdAt AS createdAt_1, s0_.updatedAt AS updatedAt_2, s0_.externalId AS externalId_3, s0_.name AS name_4, s0_.lastName AS lastName_5, s0_.email AS email_6 FROM Subscriber s0_ WHERE s0_.externalId = ?
Parameters:
[
"kokoriko.com.co"
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
tenant | doctrine.dbal.tenant_connection |
tenant_test | doctrine.dbal.tenant_test_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
tenant | doctrine.orm.tenant_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
Class | Mapping errors |
---|---|
MultiTenancyBundle\Entity\Hostname | No errors. |
MultiTenancyBundle\Entity\Tenant | No errors. |
tenant entity manager
Class | Mapping errors |
---|---|
App\Entity\Tenant\Subscriber | No errors. |
App\Entity\Tenant\FreeTrial | No errors. |
App\Entity\Tenant\Event | No errors. |
App\Entity\Tenant\Subscription | No errors. |
App\Entity\Tenant\Plan | No errors. |
App\Entity\Tenant\Renewal | No errors. |
App\Entity\Tenant\Module | No errors. |