Query Metrics
2
Database Queries
2
Different statements
2.95 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.29 ms (77.54%) |
1 |
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
]
]
|
|
0.66 ms (22.46%) |
1 |
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"
]
|
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 |
|
| App\Entity\User | No errors. |
| App\Entity\QbCustomer | No errors. |