GET https://westmar.intgate.io/purchase-orders/new

Query Metrics

10 Database Queries
10 Different statements
3.20 ms Query time
0 Invalid entities
70 Managed entities

Queries

Group similar statements

#▲ 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