GET http://rc.liftapp.it/extraordinary_jobs/283

Query Metrics

65 Database Queries
8 Different statements
28.06 ms Query time
4 Invalid entities

Queries

Group similar statements

# Time Info
1 0.51 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.email AS email_5, t0.roles AS roles_6, t0.username AS username_7, t0.password AS password_8, t0.last_access AS last_access_9 FROM sys_user t0 WHERE t0.id = ?
Parameters:
[
  4
]
2 0.45 ms
SELECT s0_.created_at AS created_at_0, s0_.updated_at AS updated_at_1, s0_.deleted_at AS deleted_at_2, s0_.id AS id_3, s0_.name AS name_4, s0_.road AS road_5, s0_.house_number AS house_number_6, s0_.city AS city_7, s0_.cap AS cap_8, s0_.province AS province_9, s0_.state AS state_10, s0_.country AS country_11, s0_.company_type AS company_type_12, s0_.phone AS phone_13, s0_.mail AS mail_14 FROM sys_company s0_ WHERE s0_.id = ?
Parameters:
[
  3
]
3 0.85 ms
SELECT j0_.created_at AS created_at_0, j0_.updated_at AS updated_at_1, j0_.deleted_at AS deleted_at_2, j0_.id AS id_3, j0_.expected_man_hours AS expected_man_hours_4, j0_.price_man_hour AS price_man_hour_5, j0_.job_total_price AS job_total_price_6, j0_.total_advanced_payment AS total_advanced_payment_7, j0_.job_offer_price AS job_offer_price_8, j0_.total_work_price AS total_work_price_9, j0_.name AS name_10, j0_.description AS description_11, j0_.status AS status_12, j0_.offer_number AS offer_number_13, j0_.offer_date AS offer_date_14, j0_.job_total_price_material AS job_total_price_material_15, j0_.priority AS priority_16, j0_.offer_acceptance_date AS offer_acceptance_date_17, j0_.relief_enabled AS relief_enabled_18, j0_.installation_enabled AS installation_enabled_19, j0_.material_enabled AS material_enabled_20, j0_.documentation_enabled AS documentation_enabled_21, j0_.documentation_ready AS documentation_ready_22, j0_.order_ref AS order_ref_23, j0_.type AS type_24, j0_.company_id AS company_id_25, j0_.implant_id AS implant_id_26 FROM job j0_ WHERE (j0_.company_id = ? AND j0_.deleted_at IS NULL AND j0_.id = ?) AND j0_.type IN (1)
Parameters:
[
  3
  283
]
4 0.44 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.identifier AS identifier_5, t0.serial_number AS serial_number_6, t0.name AS name_7, t0.maintenance_start_date AS maintenance_start_date_8, t0.road AS road_9, t0.house_number AS house_number_10, t0.city AS city_11, t0.cap AS cap_12, t0.province AS province_13, t0.longitude AS longitude_14, t0.latitude AS latitude_15, t0.radius AS radius_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.building_manager_id AS building_manager_id_19, t0.condominium_id AS condominium_id_20, t0.invoice_to_id AS invoice_to_id_21 FROM implant t0 WHERE t0.id = ?
Parameters:
[
  183
]
5 0.70 ms
SELECT s0_.created_at AS created_at_0, s0_.updated_at AS updated_at_1, s0_.deleted_at AS deleted_at_2, s0_.id AS id_3, s0_.name AS name_4, s0_.road AS road_5, s0_.house_number AS house_number_6, s0_.city AS city_7, s0_.cap AS cap_8, s0_.province AS province_9, s0_.state AS state_10, s0_.country AS country_11, s0_.company_type AS company_type_12, s0_.phone AS phone_13, s0_.mail AS mail_14 FROM sys_company s0_ WHERE s0_.id = ?
Parameters:
[
  3
]
6 1.43 ms
SELECT i0_.created_at AS created_at_0, i0_.updated_at AS updated_at_1, i0_.deleted_at AS deleted_at_2, i0_.id AS id_3, i0_.identifier AS identifier_4, i0_.serial_number AS serial_number_5, i0_.name AS name_6, i0_.maintenance_start_date AS maintenance_start_date_7, i0_.road AS road_8, i0_.house_number AS house_number_9, i0_.city AS city_10, i0_.cap AS cap_11, i0_.province AS province_12, i0_.longitude AS longitude_13, i0_.latitude AS latitude_14, i0_.radius AS radius_15, i0_.state AS state_16, i0_.company_id AS company_id_17, i0_.building_manager_id AS building_manager_id_18, i0_.condominium_id AS condominium_id_19, i0_.invoice_to_id AS invoice_to_id_20 FROM implant i0_ WHERE i0_.company_id = ? AND i0_.deleted_at IS NULL
Parameters:
[
  3
]
7 0.56 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  20
]
8 0.40 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  54
]
9 0.44 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  64
]
10 0.49 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  69
]
11 0.39 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  70
]
12 0.40 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  118
]
13 0.46 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  133
]
14 0.43 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  214
]
15 0.38 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  218
]
16 0.36 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  247
]
17 0.51 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  258
]
18 0.33 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  259
]
19 0.33 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  268
]
20 0.33 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  270
]
21 0.31 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  272
]
22 0.38 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  275
]
23 0.42 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  281
]
24 0.34 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  299
]
25 0.37 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  310
]
26 0.42 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  311
]
27 0.31 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  315
]
28 0.29 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  317
]
29 0.37 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  320
]
30 0.50 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  322
]
31 0.48 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  323
]
32 0.46 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  341
]
33 0.50 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  365
]
34 0.47 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  366
]
35 0.34 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  373
]
36 0.31 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  374
]
37 0.42 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  403
]
38 0.36 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  408
]
39 0.36 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  409
]
40 0.36 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  412
]
41 0.34 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  416
]
42 0.36 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  417
]
43 0.36 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  436
]
44 0.37 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  447
]
45 0.35 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  462
]
46 0.35 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  464
]
47 0.37 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  467
]
48 0.36 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  478
]
49 0.33 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  485
]
50 0.33 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  489
]
51 0.33 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  493
]
52 0.39 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  497
]
53 0.39 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  449
]
54 0.33 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  504
]
55 0.37 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  507
]
56 0.31 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  511
]
57 0.31 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  516
]
58 0.35 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  529
]
59 0.32 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  533
]
60 0.33 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  535
]
61 0.31 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  543
]
62 0.39 ms
SELECT s0_.created_at AS created_at_0, s0_.updated_at AS updated_at_1, s0_.deleted_at AS deleted_at_2, s0_.id AS id_3, s0_.name AS name_4, s0_.road AS road_5, s0_.house_number AS house_number_6, s0_.city AS city_7, s0_.cap AS cap_8, s0_.province AS province_9, s0_.state AS state_10, s0_.country AS country_11, s0_.company_type AS company_type_12, s0_.phone AS phone_13, s0_.mail AS mail_14 FROM sys_company s0_ WHERE s0_.id = ?
Parameters:
[
  3
]
63 1.40 ms
SELECT i0_.created_at AS created_at_0, i0_.updated_at AS updated_at_1, i0_.deleted_at AS deleted_at_2, i0_.id AS id_3, i0_.identifier AS identifier_4, i0_.serial_number AS serial_number_5, i0_.name AS name_6, i0_.maintenance_start_date AS maintenance_start_date_7, i0_.road AS road_8, i0_.house_number AS house_number_9, i0_.city AS city_10, i0_.cap AS cap_11, i0_.province AS province_12, i0_.longitude AS longitude_13, i0_.latitude AS latitude_14, i0_.radius AS radius_15, i0_.state AS state_16, i0_.company_id AS company_id_17, i0_.building_manager_id AS building_manager_id_18, i0_.condominium_id AS condominium_id_19, i0_.invoice_to_id AS invoice_to_id_20 FROM implant i0_ WHERE i0_.company_id = ? AND i0_.deleted_at IS NULL
Parameters:
[
  3
]
64 0.58 ms
SELECT s0_.created_at AS created_at_0, s0_.updated_at AS updated_at_1, s0_.deleted_at AS deleted_at_2, s0_.id AS id_3, s0_.email AS email_4, s0_.roles AS roles_5, s0_.username AS username_6, s0_.password AS password_7, s0_.last_access AS last_access_8 FROM sys_user s0_ WHERE s0_.username = ?
Parameters:
[
  "e.andrei@ascensoriservizimecherini.it"
]
65 0.47 ms
SELECT c0_.created_at AS created_at_0, c0_.updated_at AS updated_at_1, c0_.deleted_at AS deleted_at_2, c0_.id AS id_3, c0_.role AS role_4, c0_.user_id AS user_id_5, c0_.company_id AS company_id_6 FROM coll_sys_user_sys_company c0_ WHERE c0_.user_id = ?
Parameters:
[
  4
]

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.

Entities Mapping

Class Mapping errors
App\Entity\BaseEntity No errors.
App\Entity\SysUser
  • The mappings App\Entity\SysUser#sysRoles and App\Entity\CollSysUserSysCompany#user are inconsistent with each other.
App\Entity\CollSysUserSysCompany
  • The association App\Entity\CollSysUserSysCompany#user refers to the inverse side field App\Entity\SysUser#roles which is not defined as association.
  • The association App\Entity\CollSysUserSysCompany#user refers to the inverse side field App\Entity\SysUser#roles which does not exist.
App\Entity\Job No errors.
App\Entity\ExtraordinaryJob No errors.
App\Entity\SysCompany No errors.
App\Entity\Registry No errors.
App\Entity\SysCompanyAddresses No errors.
App\Entity\Implant
  • The field App\Entity\Implant#jobs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Job#implant does not contain the required 'inversedBy="jobs"' attribute.
App\Entity\WorkOrder No errors.
App\Entity\OnSiteJob No errors.
App\Entity\Relief No errors.
App\Entity\CollJobMaterial No errors.
App\Entity\CollJobPayment No errors.
App\Entity\CondominiumAdministrator No errors.
App\Entity\Condominium No errors.
App\Entity\Customer No errors.
App\Entity\Employee No errors.
App\Entity\Supplier
  • The field App\Entity\Supplier#jobMaterials is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\CollJobMaterial#supplier does not contain the required 'inversedBy="jobMaterials"' attribute.
  • The field App\Entity\Supplier#orders is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Order#supplier does not contain the required 'inversedBy="orders"' attribute.