Query Metrics
10
Database Queries
10
Different statements
3.20 ms
Query time
0
Invalid entities
70
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.37 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.position AS position_7, t0.user_group AS user_group_8, t0.email AS email_9, t0.created_at AS created_at_10, t0.created_by_name AS created_by_name_11, t0.is_active AS is_active_12, t0.countries AS countries_13 FROM users t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 2 | 0.77 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.created_by_name AS created_by_name_5, t0.created_at AS created_at_6, t0.is_active AS is_active_7, t0.width AS width_8, t0.depth AS depth_9 FROM warehouses t0 WHERE t0.is_active = ? ORDER BY t0.name ASC LIMIT 1
Parameters:
[
1
]
|
| 3 | 0.26 ms |
SELECT MAX(p0_.seq) AS sclr_0 FROM purchase_orders p0_ WHERE p0_.year = ?
Parameters:
[
26
]
|
| 4 | 0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.tax_id AS tax_id_3, t0.email AS email_4, t0.phone AS phone_5, t0.address AS address_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8 FROM suppliers t0 WHERE t0.is_active = ? ORDER BY t0.name ASC
Parameters:
[
1
]
|
| 5 | 0.20 ms |
SELECT t0.id AS id_1, t0.number AS number_2, t0.client_project_number AS client_project_number_3, t0.client_address AS client_address_4, t0.client_city AS client_city_5, t0.client_nip AS client_nip_6, t0.description AS description_7, t0.planned_hours AS planned_hours_8, t0.hourly_rate AS hourly_rate_9, t0.total_cost AS total_cost_10, t0.created_at AS created_at_11, t0.created_by_name AS created_by_name_12, t0.delivery_place AS delivery_place_13, t0.delivery_person AS delivery_person_14, t0.delivery_date AS delivery_date_15, t0.delivery_cost AS delivery_cost_16, t0.delivery_notes AS delivery_notes_17, t0.delivery_type AS delivery_type_18, t0.estimate_hours AS estimate_hours_19, t0.estimate_rate AS estimate_rate_20, t0.estimate_offer AS estimate_offer_21, t0.estimate_materials AS estimate_materials_22, t0.estimate_services AS estimate_services_23, t0.currency AS currency_24, t0.estimate_status AS estimate_status_25, t0.estimate_accepted_at AS estimate_accepted_at_26, t0.estimate_eur_rate AS estimate_eur_rate_27, t0.estimate_eur_rate_date AS estimate_eur_rate_date_28, t0.estimate_accepted_by AS estimate_accepted_by_29, t0.name AS name_30, t0.status AS status_31, t0.country AS country_32, t0.offer_number AS offer_number_33, t0.location AS location_34, t0.client_id AS client_id_35, t0.company_id AS company_id_36, t0.category_id AS category_id_37, t0.manager_id AS manager_id_38, t0.foreman_id AS foreman_id_39 FROM projects t0 ORDER BY t0.number DESC
Parameters:
[] |
| 6 | 0.50 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.number AS number_3, t0.name AS name_4, t0.is_active AS is_active_5 FROM cost_categories t0 WHERE t0.is_active = ? ORDER BY t0.type ASC, t0.number ASC
Parameters:
[
1
]
|
| 7 | 0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.created_by_name AS created_by_name_5, t0.created_at AS created_at_6, t0.is_active AS is_active_7, t0.width AS width_8, t0.depth AS depth_9 FROM warehouses t0 WHERE t0.is_active = ? ORDER BY t0.name ASC
Parameters:
[
1
]
|
| 8 | 0.37 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.is_cut AS is_cut_4, t0.is_active AS is_active_5 FROM warehouse_units t0 WHERE t0.is_active = ? ORDER BY t0.name ASC
Parameters:
[
1
]
|
| 9 | 0.14 ms |
SELECT COUNT(t0_.id) AS sclr_0 FROM tickets t0_ WHERE t0_.status <> ?
Parameters:
[
"zakończone"
]
|
| 10 | 0.13 ms |
SELECT COUNT(p0_.id) AS sclr_0 FROM project_tasks p0_ WHERE p0_.assigned_to_id = ? AND p0_.status <> ?
Parameters:
[ 1 "zakończone" ] |
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\CostCategory | 49 |
| App\Entity\WarehouseUnit | 5 |
| App\Entity\Project | 4 |
| App\Entity\Client | 4 |
| App\Entity\User | 3 |
| App\Entity\Company | 2 |
| App\Entity\Warehouse | 1 |
| App\Entity\Supplier | 1 |
| App\Entity\ProjectCategory | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Company | No errors. |
| App\Entity\Warehouse | No errors. |
| App\Entity\WarehouseCategory | No errors. |
| App\Entity\WarehouseItem | No errors. |
| App\Entity\StorageZone | No errors. |
| App\Entity\PurchaseOrder | No errors. |
| App\Entity\Supplier | No errors. |
| App\Entity\Project | No errors. |
| App\Entity\Client | No errors. |
| App\Entity\ProjectCategory | No errors. |
| App\Entity\ProjectSchedule | No errors. |
| App\Entity\ProjectAttachment | No errors. |
| App\Entity\TechCard | No errors. |
| App\Entity\ProjectMaterial | No errors. |
| App\Entity\ProjectExtraCost | No errors. |
| App\Entity\ProjectCalculation | No errors. |
| App\Entity\ProjectEstimateItem | No errors. |
| App\Entity\Ncr | No errors. |
| App\Entity\ChangeOrder | No errors. |
| App\Entity\ProjectEmployee | No errors. |
| App\Entity\ProjectOrder | No errors. |
| App\Entity\ProjectTask | No errors. |
| App\Entity\CostCategory | No errors. |
| App\Entity\WarehouseUnit | No errors. |
| App\Entity\Ticket | No errors. |