Symfony Profiler

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 = ?

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 = 7;

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 = ?

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 = 3;

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
  AND i0_.id = ?

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 = 3 AND i0_.deleted_at IS NULL AND i0_.id = 388;

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 = ?

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 = 3;

SELECT
  r0_.created_at AS created_at_0,
  r0_.updated_at AS updated_at_1,
  r0_.deleted_at AS deleted_at_2,
  r0_.id AS id_3,
  r0_.name AS name_4,
  r0_.cf AS cf_5,
  r0_.role AS role_6,
  r0_.road AS road_7,
  r0_.house_number AS house_number_8,
  r0_.city AS city_9,
  r0_.cap AS cap_10,
  r0_.province AS province_11,
  r0_.email AS email_12,
  r0_.telephone AS telephone_13,
  r0_.cellphone AS cellphone_14,
  r0_.p_iva AS p_iva_15,
  r0_.state AS state_16,
  r0_.type AS type_17,
  r0_.company_id AS company_id_18
FROM
  registry r0_
WHERE
  (
    r0_.company_id = ?
    AND r0_.deleted_at IS NULL
  )
  AND r0_.type IN (2)

SELECT r0_.created_at AS created_at_0, r0_.updated_at AS updated_at_1, r0_.deleted_at AS deleted_at_2, r0_.id AS id_3, r0_.name AS name_4, r0_.cf AS cf_5, r0_.role AS role_6, r0_.road AS road_7, r0_.house_number AS house_number_8, r0_.city AS city_9, r0_.cap AS cap_10, r0_.province AS province_11, r0_.email AS email_12, r0_.telephone AS telephone_13, r0_.cellphone AS cellphone_14, r0_.p_iva AS p_iva_15, r0_.state AS state_16, r0_.type AS type_17, r0_.company_id AS company_id_18 FROM registry r0_ WHERE (r0_.company_id = 3 AND r0_.deleted_at IS NULL) AND r0_.type IN (2);

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 = ?

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 = 3;

SELECT
  r0_.created_at AS created_at_0,
  r0_.updated_at AS updated_at_1,
  r0_.deleted_at AS deleted_at_2,
  r0_.id AS id_3,
  r0_.name AS name_4,
  r0_.cf AS cf_5,
  r0_.role AS role_6,
  r0_.road AS road_7,
  r0_.house_number AS house_number_8,
  r0_.city AS city_9,
  r0_.cap AS cap_10,
  r0_.province AS province_11,
  r0_.email AS email_12,
  r0_.telephone AS telephone_13,
  r0_.cellphone AS cellphone_14,
  r0_.p_iva AS p_iva_15,
  r0_.state AS state_16,
  r0_.type AS type_17,
  r0_.company_id AS company_id_18
FROM
  registry r0_
WHERE
  (
    r0_.company_id = ?
    AND r0_.deleted_at IS NULL
  )
  AND r0_.type IN (1)

SELECT r0_.created_at AS created_at_0, r0_.updated_at AS updated_at_1, r0_.deleted_at AS deleted_at_2, r0_.id AS id_3, r0_.name AS name_4, r0_.cf AS cf_5, r0_.role AS role_6, r0_.road AS road_7, r0_.house_number AS house_number_8, r0_.city AS city_9, r0_.cap AS cap_10, r0_.province AS province_11, r0_.email AS email_12, r0_.telephone AS telephone_13, r0_.cellphone AS cellphone_14, r0_.p_iva AS p_iva_15, r0_.state AS state_16, r0_.type AS type_17, r0_.company_id AS company_id_18 FROM registry r0_ WHERE (r0_.company_id = 3 AND r0_.deleted_at IS NULL) AND r0_.type IN (1);

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 = ?

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 = 3;

SELECT
  r0_.created_at AS created_at_0,
  r0_.updated_at AS updated_at_1,
  r0_.deleted_at AS deleted_at_2,
  r0_.id AS id_3,
  r0_.name AS name_4,
  r0_.cf AS cf_5,
  r0_.role AS role_6,
  r0_.road AS road_7,
  r0_.house_number AS house_number_8,
  r0_.city AS city_9,
  r0_.cap AS cap_10,
  r0_.province AS province_11,
  r0_.email AS email_12,
  r0_.telephone AS telephone_13,
  r0_.cellphone AS cellphone_14,
  r0_.p_iva AS p_iva_15,
  r0_.state AS state_16,
  r0_.type AS type_17,
  r0_.company_id AS company_id_18
FROM
  registry r0_
WHERE
  (
    r0_.company_id = ?
    AND r0_.deleted_at IS NULL
  )
  AND r0_.type IN (5)

SELECT r0_.created_at AS created_at_0, r0_.updated_at AS updated_at_1, r0_.deleted_at AS deleted_at_2, r0_.id AS id_3, r0_.name AS name_4, r0_.cf AS cf_5, r0_.role AS role_6, r0_.road AS road_7, r0_.house_number AS house_number_8, r0_.city AS city_9, r0_.cap AS cap_10, r0_.province AS province_11, r0_.email AS email_12, r0_.telephone AS telephone_13, r0_.cellphone AS cellphone_14, r0_.p_iva AS p_iva_15, r0_.state AS state_16, r0_.type AS type_17, r0_.company_id AS company_id_18 FROM registry r0_ WHERE (r0_.company_id = 3 AND r0_.deleted_at IS NULL) AND r0_.type IN (5);

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 = ?

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 = 3;

SELECT
  r0_.created_at AS created_at_0,
  r0_.updated_at AS updated_at_1,
  r0_.deleted_at AS deleted_at_2,
  r0_.id AS id_3,
  r0_.name AS name_4,
  r0_.cf AS cf_5,
  r0_.role AS role_6,
  r0_.road AS road_7,
  r0_.house_number AS house_number_8,
  r0_.city AS city_9,
  r0_.cap AS cap_10,
  r0_.province AS province_11,
  r0_.email AS email_12,
  r0_.telephone AS telephone_13,
  r0_.cellphone AS cellphone_14,
  r0_.p_iva AS p_iva_15,
  r0_.state AS state_16,
  r0_.type AS type_17,
  r0_.company_id AS company_id_18
FROM
  registry r0_
WHERE
  (
    r0_.company_id = ?
    AND r0_.deleted_at IS NULL
  )
  AND r0_.type IN (1)

SELECT r0_.created_at AS created_at_0, r0_.updated_at AS updated_at_1, r0_.deleted_at AS deleted_at_2, r0_.id AS id_3, r0_.name AS name_4, r0_.cf AS cf_5, r0_.role AS role_6, r0_.road AS road_7, r0_.house_number AS house_number_8, r0_.city AS city_9, r0_.cap AS cap_10, r0_.province AS province_11, r0_.email AS email_12, r0_.telephone AS telephone_13, r0_.cellphone AS cellphone_14, r0_.p_iva AS p_iva_15, r0_.state AS state_16, r0_.type AS type_17, r0_.company_id AS company_id_18 FROM registry r0_ WHERE (r0_.company_id = 3 AND r0_.deleted_at IS NULL) AND r0_.type IN (1);

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 = ?

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 = 3;

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 = ?

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 = 3;

SELECT
  r0_.created_at AS created_at_0,
  r0_.updated_at AS updated_at_1,
  r0_.deleted_at AS deleted_at_2,
  r0_.id AS id_3,
  r0_.name AS name_4,
  r0_.cf AS cf_5,
  r0_.role AS role_6,
  r0_.road AS road_7,
  r0_.house_number AS house_number_8,
  r0_.city AS city_9,
  r0_.cap AS cap_10,
  r0_.province AS province_11,
  r0_.email AS email_12,
  r0_.telephone AS telephone_13,
  r0_.cellphone AS cellphone_14,
  r0_.p_iva AS p_iva_15,
  r0_.state AS state_16,
  r0_.type AS type_17,
  r0_.company_id AS company_id_18
FROM
  registry r0_
WHERE
  (
    r0_.company_id = ?
    AND r0_.deleted_at IS NULL
  )
  AND r0_.type IN (5)

SELECT r0_.created_at AS created_at_0, r0_.updated_at AS updated_at_1, r0_.deleted_at AS deleted_at_2, r0_.id AS id_3, r0_.name AS name_4, r0_.cf AS cf_5, r0_.role AS role_6, r0_.road AS road_7, r0_.house_number AS house_number_8, r0_.city AS city_9, r0_.cap AS cap_10, r0_.province AS province_11, r0_.email AS email_12, r0_.telephone AS telephone_13, r0_.cellphone AS cellphone_14, r0_.p_iva AS p_iva_15, r0_.state AS state_16, r0_.type AS type_17, r0_.company_id AS company_id_18 FROM registry r0_ WHERE (r0_.company_id = 3 AND r0_.deleted_at IS NULL) AND r0_.type IN (5);

SELECT
  r0_.created_at AS created_at_0,
  r0_.updated_at AS updated_at_1,
  r0_.deleted_at AS deleted_at_2,
  r0_.id AS id_3,
  r0_.name AS name_4,
  r0_.cf AS cf_5,
  r0_.role AS role_6,
  r0_.road AS road_7,
  r0_.house_number AS house_number_8,
  r0_.city AS city_9,
  r0_.cap AS cap_10,
  r0_.province AS province_11,
  r0_.email AS email_12,
  r0_.telephone AS telephone_13,
  r0_.cellphone AS cellphone_14,
  r0_.p_iva AS p_iva_15,
  r0_.state AS state_16,
  r0_.type AS type_17,
  r0_.company_id AS company_id_18
FROM
  registry r0_
WHERE
  (
    r0_.company_id = ?
    AND r0_.deleted_at IS NULL
  )
  AND r0_.type IN (1)

SELECT r0_.created_at AS created_at_0, r0_.updated_at AS updated_at_1, r0_.deleted_at AS deleted_at_2, r0_.id AS id_3, r0_.name AS name_4, r0_.cf AS cf_5, r0_.role AS role_6, r0_.road AS road_7, r0_.house_number AS house_number_8, r0_.city AS city_9, r0_.cap AS cap_10, r0_.province AS province_11, r0_.email AS email_12, r0_.telephone AS telephone_13, r0_.cellphone AS cellphone_14, r0_.p_iva AS p_iva_15, r0_.state AS state_16, r0_.type AS type_17, r0_.company_id AS company_id_18 FROM registry r0_ WHERE (r0_.company_id = 3 AND r0_.deleted_at IS NULL) AND r0_.type IN (1);