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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 56.30 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 20950
Parameters:
[]
2 0.67 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:
[
  15097
  15353
  15609
  15865
  16121
  16377
  16633
  16889
  17145
  17401
  17657
  17913
  18169
  18425
  18681
  18937
  19193
  19449
  19705
  19961
  20217
  20473
  20729
  20985
  21241
  250
  506
  762
  1018
  1274
  1530
  1786
  2042
  2298
  2554
  2810
  3066
  3322
  3578
  3834
  4090
  4346
  4602
  4858
  5114
  5370
  5626
  5882
  6138
  6394
]
3 18.66 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.