https://accounting.woofy.ph/api/subscriber

Query Metrics

5 Database Queries
5 Different statements
7.05 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.72 ms
SELECT t0.id AS id_1, t0.token AS token_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM api_access_token t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "1"
]
2 0.88 ms
SELECT t0.id AS id_1, t0.subscriber_id AS subscriber_id_2, t0.location AS location_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.account_type AS account_type_6 FROM subscriber t0 WHERE t0.subscriber_id = ? LIMIT 1
Parameters:
[
  1000239796
]
3 0.32 ms
"START TRANSACTION"
Parameters:
[]
4 0.79 ms
INSERT INTO subscriber (subscriber_id, location, created_at, updated_at, account_type) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  1 => 1000239796
  2 => "Breeze"
  3 => "2026-04-05 23:51:02"
  4 => "2026-04-05 23:51:02"
  5 => "legacy"
]
5 4.34 ms
"COMMIT"
Parameters:
[]

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.

Entities Mapping

Class Mapping errors
App\Entity\ApiAccessToken No errors.
App\Entity\WalletTransaction No errors.
App\Entity\WalletProcessingFee No errors.
App\Entity\OtcTransaction No errors.
App\Entity\WoofyTransaction No errors.
App\Entity\EPaymentTransaction No errors.
App\Entity\DataGetter No errors.
App\Entity\Consolidator No errors.
App\Entity\CreditMemoTransaction No errors.
App\Entity\Subscriber No errors.
App\Entity\QuickBooksID No errors.
App\Entity\QuickbooksCompany
  • The mappings App\Entity\QuickbooksCompany#qBAccounts and App\Entity\QbAccount#quickbooksCompany are inconsistent with each other.
App\Entity\User No errors.
App\Entity\QbCustomer No errors.