Query Metrics
3
Database Queries
3
Different statements
45.78 ms
Query time
0
Invalid entities
50
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 39.54 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 30000
Parameters:
[] |
| 2 | 0.82 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:
[ 27947 27948 27949 27950 27951 27952 27953 27954 27955 27956 27957 27958 27959 27960 27961 27962 27963 27964 27965 27966 27967 27968 27969 27970 27971 27972 27973 27974 30433 34308 19227 5696 3534 5171 2617 17319 34656 14145 34654 33954 33951 34649 34647 10430 34646 4312 5241 34326 33953 33946 ] |
| 3 | 5.43 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. |