Query Metrics
3
Database Queries
3
Different statements
7.84 ms
Query time
0
Invalid entities
50
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.80 ms |
SELECT DISTINCT s0_.id AS id_0, s0_.id AS id_1 FROM stock s0_ ORDER BY s0_.id DESC LIMIT 50 OFFSET 1800
Parameters:
[] |
| 2 | 2.82 ms |
SELECT s0_.id AS id_0, s0_.sku AS sku_1, s0_.ls_stock AS ls_stock_2, s0_.ls_cp AS ls_cp_3, s0_.alloy_stock AS alloy_stock_4, s0_.alloy_cp AS alloy_cp_5, s0_.mmt_stock AS mmt_stock_6, s0_.mmt_cp AS mmt_cp_7, s0_.ds_stock AS ds_stock_8, s0_.ds_cp AS ds_cp_9, s0_.dd_stock AS dd_stock_10, s0_.dd_cp AS dd_cp_11, s0_.dd_status AS dd_status_12, s0_.rrp AS rrp_13, s0_.synnex_cp AS synnex_cp_14, s0_.synnex_stock AS synnex_stock_15 FROM stock s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.id DESC
Parameters:
[ 34359 34358 34357 34356 34355 34354 34353 34352 34351 34350 34349 34348 34347 34346 34345 34344 34343 34342 34341 34340 34339 34338 34337 34336 34335 34334 34333 34332 34331 34330 34329 34328 34327 34326 34325 34324 34323 34322 34321 34320 34319 34318 34317 34316 34315 34314 34313 34312 34311 34310 ] |
| 3 | 4.22 ms |
SELECT count(*) AS sclr_0 FROM stock 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\Stock | 50 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Stock | No errors. |