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

Query Metrics

2 Database Queries
2 Different statements
3.77 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.66 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 3.11 ms
SELECT w0_.timestamp AS timestamp_0, w0_.subscriber_id AS subscriber_id_1, c1_.id AS id_2, c1_.doc_number AS doc_number_3, w0_.amount AS amount_4, w0_.transaction_id AS transaction_id_5, w0_.otc_name AS otc_name_6, w0_.first_name AS first_name_7, w0_.last_name AS last_name_8, w0_.unit_number AS unit_number_9, w0_.location AS location_10, w0_.tower_name AS tower_name_11, w0_.sales_agent AS sales_agent_12, w0_.mobile_number AS mobile_number_13, w0_.email AS email_14, w0_.collector AS collector_15, w0_.deposit_date AS deposit_date_16, w0_.bank AS bank_17, w0_.reference_number AS reference_number_18, w0_.deposit_amount AS deposit_amount_19, w0_.branch_code AS branch_code_20, w0_.teller_id AS teller_id_21, w0_.teller_id_transaction_number AS teller_id_transaction_number_22, w0_.commission AS commission_23, w0_.sales_manager AS sales_manager_24 FROM woofy_transaction w0_ LEFT JOIN consolidator c1_ ON w0_.consolidator_id = c1_.id WHERE w0_.id IN (?) ORDER BY w0_.timestamp ASC
Parameters:
[
  [
    169288
    169314
    169410
    169210
    169239
    169259
    169264
    169296
    169317
    169400
    169421
    169365
    169358
    169434
    169368
    169289
    169284
    169319
    169497
    169297
    169313
    169440
    169442
    169385
    169483
    169500
    169495
    169342
    169343
    169387
    169506
    169395
    169360
    169449
    169445
    169193
    169225
    169469
    169470
    169371
    169404
    169417
    169422
    169472
    169341
    169435
    169454
    169447
    169397
    169452
    169369
    169478
    169525
    169356
    169376
    169383
    169426
    169429
    169464
    169522
    169513
    169344
    169432
    169310
    169335
    169192
    169286
    169293
    169300
    169539
    169362
    169374
    169545
    169551
    169520
    169262
    169280
    169450
    169294
    169457
    169336
    169346
    169380
    169448
    169510
    169537
    169523
    169499
    169227
    169283
    169377
    169381
    169482
    169559
    169219
    169318
    169372
    169561
    169550
    169361
    169549
    169578
    169324
    169228
    169251
    169455
    169592
    169132
    169567
    169515
    169409
    169530
    169463
    169226
    169249
    169277
    169505
    169205
    169399
    169504
    169590
    169614
    169408
    169527
    169608
    169611
    169626
    169367
    169441
    169370
    169433
    169605
    169635
    169641
    169456
    169632
    169584
    169575
    169544
    169534
    169508
    169509
    169511
    169476
    169581
    169493
    169507
    169572
    169558
    169272
    169475
    169521
    169555
    169606
    169573
    169588
    169613
    169622
    169630
    169639
    169600
    169642
    169644
    169401
    169547
  ]
]

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.