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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 56.50 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 35800
Parameters:
[]
2 1.31 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:
[
  29085
  29086
  29087
  29088
  29089
  29090
  29091
  29092
  29093
  29094
  29095
  29096
  29097
  29098
  29099
  29100
  29101
  29102
  29103
  29104
  29105
  29106
  29107
  29108
  29109
  29110
  29111
  29112
  29113
  29114
  29115
  29116
  29117
  29118
  29119
  29120
  29121
  29122
  29123
  29124
  29125
  29126
  29127
  29128
  29777
  29778
  29779
  29780
  30142
  34393
]
3 4.61 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.