GET https://content.gamingdesktop.com.au/admin/supplier-ref?page=221&sort%5BdsCode%5D=ASC

Query Metrics

3 Database Queries
3 Different statements
135.24 ms Query time
0 Invalid entities
50 Managed entities

Queries

Group similar statements

# Time Info
1 130.91 ms
SELECT DISTINCT s0_.id AS id_0, s0_.ds_code AS ds_code_1 FROM supplier_ref s0_ ORDER BY s0_.ds_code ASC LIMIT 50 OFFSET 11000
Parameters:
[]
2 1.02 ms
SELECT s0_.id AS id_0, s0_.sku AS sku_1, s0_.ls_code AS ls_code_2, s0_.alloy_code AS alloy_code_3, s0_.mmt_code AS mmt_code_4, s0_.ds_code AS ds_code_5, s0_.dd_code AS dd_code_6, s0_.synnex_code AS synnex_code_7 FROM supplier_ref s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.ds_code ASC
Parameters:
[
  20866
  21122
  21378
  131
  387
  643
  899
  1155
  1411
  1667
  1923
  2179
  2435
  2691
  2947
  3203
  3459
  3715
  3971
  4227
  4483
  4739
  4995
  5251
  5507
  5763
  6019
  6275
  6531
  6787
  7043
  7299
  7555
  7811
  8067
  8323
  8579
  8835
  9091
  9347
  9603
  9859
  10115
  10371
  10627
  10883
  11139
  11395
  11651
  11907
]
3 3.31 ms
SELECT count(*) AS sclr_0 FROM supplier_ref s0_
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\SupplierRef 50

Entities Mapping

Class Mapping errors
App\Entity\SupplierRef No errors.