GET https://suscripciones.baizel.co/api/subscribers/kokoriko.com.co

Query Metrics

7 Database Queries
7 Different statements
3.30 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
1.26 ms
(38.27%)
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
0.50 ms
(15.11%)
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.47 ms
(14.20%)
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.38 ms
(11.44%)
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"
]
0.25 ms
(7.63%)
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
]
0.23 ms
(6.84%)
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
]
0.22 ms
(6.51%)
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
]

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.