Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.notes AS notes_3,
  t0.company_id AS company_id_4
FROM
  potential_customer_company t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.notes AS notes_3, t0.company_id AS company_id_4 FROM potential_customer_company t0 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.banned AS banned_2,
  t0.contract AS contract_3,
  t0.contract_number AS contract_number_4,
  t0.contract_valid_to AS contract_valid_to_5,
  t0.currency AS currency_6,
  t0.electronic_invoicing_identifier AS electronic_invoicing_identifier_7,
  t0.electronic_invoicing_identifier_scheme AS electronic_invoicing_identifier_scheme_8,
  t0.electronic_invoicing_intermediator AS electronic_invoicing_intermediator_9,
  t0.indirect AS indirect_10,
  t0.name AS name_11,
  t0.notes AS notes_12,
  t0.warranty AS warranty_13,
  t0.address_row_1 AS address_row_1_14,
  t0.address_row_2 AS address_row_2_15,
  t0.address_row_3 AS address_row_3_16,
  t0.address_row_4 AS address_row_4_17,
  t0.city AS city_18,
  t0.contact_person_email AS contact_person_email_19,
  t0.contact_person_name AS contact_person_name_20,
  t0.country AS country_21,
  t0.postal_code AS postal_code_22,
  t0.vat_id AS vat_id_23,
  t0.terms_of_delivery AS terms_of_delivery_24,
  t0.terms_of_delivery_rules AS terms_of_delivery_rules_25,
  t0.transportation AS transportation_26,
  t0.bank_account_id AS bank_account_id_27,
  t0.price_group_id AS price_group_id_28,
  t29.id AS id_30,
  t29.name AS name_31,
  t29.notes AS notes_32,
  t29.company_id AS company_id_33
FROM
  company t0
  LEFT JOIN potential_customer_company t29 ON t29.company_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.banned AS banned_2, t0.contract AS contract_3, t0.contract_number AS contract_number_4, t0.contract_valid_to AS contract_valid_to_5, t0.currency AS currency_6, t0.electronic_invoicing_identifier AS electronic_invoicing_identifier_7, t0.electronic_invoicing_identifier_scheme AS electronic_invoicing_identifier_scheme_8, t0.electronic_invoicing_intermediator AS electronic_invoicing_intermediator_9, t0.indirect AS indirect_10, t0.name AS name_11, t0.notes AS notes_12, t0.warranty AS warranty_13, t0.address_row_1 AS address_row_1_14, t0.address_row_2 AS address_row_2_15, t0.address_row_3 AS address_row_3_16, t0.address_row_4 AS address_row_4_17, t0.city AS city_18, t0.contact_person_email AS contact_person_email_19, t0.contact_person_name AS contact_person_name_20, t0.country AS country_21, t0.postal_code AS postal_code_22, t0.vat_id AS vat_id_23, t0.terms_of_delivery AS terms_of_delivery_24, t0.terms_of_delivery_rules AS terms_of_delivery_rules_25, t0.transportation AS transportation_26, t0.bank_account_id AS bank_account_id_27, t0.price_group_id AS price_group_id_28, t29.id AS id_30, t29.name AS name_31, t29.notes AS notes_32, t29.company_id AS company_id_33 FROM company t0 LEFT JOIN potential_customer_company t29 ON t29.company_id = t0.id WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.name AS name_3,
  t0.phone AS phone_4,
  t0.role AS role_5,
  t0.company_id AS company_id_6
FROM
  potential_customer_company_contact t0
WHERE
  t0.company_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.phone AS phone_4, t0.role AS role_5, t0.company_id AS company_id_6 FROM potential_customer_company_contact t0 WHERE t0.company_id = 5 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.banned AS banned_2,
  t0.contract AS contract_3,
  t0.contract_number AS contract_number_4,
  t0.contract_valid_to AS contract_valid_to_5,
  t0.currency AS currency_6,
  t0.electronic_invoicing_identifier AS electronic_invoicing_identifier_7,
  t0.electronic_invoicing_identifier_scheme AS electronic_invoicing_identifier_scheme_8,
  t0.electronic_invoicing_intermediator AS electronic_invoicing_intermediator_9,
  t0.indirect AS indirect_10,
  t0.name AS name_11,
  t0.notes AS notes_12,
  t0.warranty AS warranty_13,
  t0.address_row_1 AS address_row_1_14,
  t0.address_row_2 AS address_row_2_15,
  t0.address_row_3 AS address_row_3_16,
  t0.address_row_4 AS address_row_4_17,
  t0.city AS city_18,
  t0.contact_person_email AS contact_person_email_19,
  t0.contact_person_name AS contact_person_name_20,
  t0.country AS country_21,
  t0.postal_code AS postal_code_22,
  t0.vat_id AS vat_id_23,
  t0.terms_of_delivery AS terms_of_delivery_24,
  t0.terms_of_delivery_rules AS terms_of_delivery_rules_25,
  t0.transportation AS transportation_26,
  t0.bank_account_id AS bank_account_id_27,
  t0.price_group_id AS price_group_id_28,
  t29.id AS id_30,
  t29.name AS name_31,
  t29.notes AS notes_32,
  t29.company_id AS company_id_33
FROM
  company t0
  LEFT JOIN potential_customer_company t29 ON t29.company_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.banned AS banned_2, t0.contract AS contract_3, t0.contract_number AS contract_number_4, t0.contract_valid_to AS contract_valid_to_5, t0.currency AS currency_6, t0.electronic_invoicing_identifier AS electronic_invoicing_identifier_7, t0.electronic_invoicing_identifier_scheme AS electronic_invoicing_identifier_scheme_8, t0.electronic_invoicing_intermediator AS electronic_invoicing_intermediator_9, t0.indirect AS indirect_10, t0.name AS name_11, t0.notes AS notes_12, t0.warranty AS warranty_13, t0.address_row_1 AS address_row_1_14, t0.address_row_2 AS address_row_2_15, t0.address_row_3 AS address_row_3_16, t0.address_row_4 AS address_row_4_17, t0.city AS city_18, t0.contact_person_email AS contact_person_email_19, t0.contact_person_name AS contact_person_name_20, t0.country AS country_21, t0.postal_code AS postal_code_22, t0.vat_id AS vat_id_23, t0.terms_of_delivery AS terms_of_delivery_24, t0.terms_of_delivery_rules AS terms_of_delivery_rules_25, t0.transportation AS transportation_26, t0.bank_account_id AS bank_account_id_27, t0.price_group_id AS price_group_id_28, t29.id AS id_30, t29.name AS name_31, t29.notes AS notes_32, t29.company_id AS company_id_33 FROM company t0 LEFT JOIN potential_customer_company t29 ON t29.company_id = t0.id WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.name AS name_3,
  t0.phone AS phone_4,
  t0.role AS role_5,
  t0.company_id AS company_id_6
FROM
  potential_customer_company_contact t0
WHERE
  t0.company_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.phone AS phone_4, t0.role AS role_5, t0.company_id AS company_id_6 FROM potential_customer_company_contact t0 WHERE t0.company_id = 6 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.banned AS banned_2,
  t0.contract AS contract_3,
  t0.contract_number AS contract_number_4,
  t0.contract_valid_to AS contract_valid_to_5,
  t0.currency AS currency_6,
  t0.electronic_invoicing_identifier AS electronic_invoicing_identifier_7,
  t0.electronic_invoicing_identifier_scheme AS electronic_invoicing_identifier_scheme_8,
  t0.electronic_invoicing_intermediator AS electronic_invoicing_intermediator_9,
  t0.indirect AS indirect_10,
  t0.name AS name_11,
  t0.notes AS notes_12,
  t0.warranty AS warranty_13,
  t0.address_row_1 AS address_row_1_14,
  t0.address_row_2 AS address_row_2_15,
  t0.address_row_3 AS address_row_3_16,
  t0.address_row_4 AS address_row_4_17,
  t0.city AS city_18,
  t0.contact_person_email AS contact_person_email_19,
  t0.contact_person_name AS contact_person_name_20,
  t0.country AS country_21,
  t0.postal_code AS postal_code_22,
  t0.vat_id AS vat_id_23,
  t0.terms_of_delivery AS terms_of_delivery_24,
  t0.terms_of_delivery_rules AS terms_of_delivery_rules_25,
  t0.transportation AS transportation_26,
  t0.bank_account_id AS bank_account_id_27,
  t0.price_group_id AS price_group_id_28,
  t29.id AS id_30,
  t29.name AS name_31,
  t29.notes AS notes_32,
  t29.company_id AS company_id_33
FROM
  company t0
  LEFT JOIN potential_customer_company t29 ON t29.company_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.banned AS banned_2, t0.contract AS contract_3, t0.contract_number AS contract_number_4, t0.contract_valid_to AS contract_valid_to_5, t0.currency AS currency_6, t0.electronic_invoicing_identifier AS electronic_invoicing_identifier_7, t0.electronic_invoicing_identifier_scheme AS electronic_invoicing_identifier_scheme_8, t0.electronic_invoicing_intermediator AS electronic_invoicing_intermediator_9, t0.indirect AS indirect_10, t0.name AS name_11, t0.notes AS notes_12, t0.warranty AS warranty_13, t0.address_row_1 AS address_row_1_14, t0.address_row_2 AS address_row_2_15, t0.address_row_3 AS address_row_3_16, t0.address_row_4 AS address_row_4_17, t0.city AS city_18, t0.contact_person_email AS contact_person_email_19, t0.contact_person_name AS contact_person_name_20, t0.country AS country_21, t0.postal_code AS postal_code_22, t0.vat_id AS vat_id_23, t0.terms_of_delivery AS terms_of_delivery_24, t0.terms_of_delivery_rules AS terms_of_delivery_rules_25, t0.transportation AS transportation_26, t0.bank_account_id AS bank_account_id_27, t0.price_group_id AS price_group_id_28, t29.id AS id_30, t29.name AS name_31, t29.notes AS notes_32, t29.company_id AS company_id_33 FROM company t0 LEFT JOIN potential_customer_company t29 ON t29.company_id = t0.id WHERE t0.id = 140;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.name AS name_3,
  t0.phone AS phone_4,
  t0.role AS role_5,
  t0.company_id AS company_id_6
FROM
  potential_customer_company_contact t0
WHERE
  t0.company_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.phone AS phone_4, t0.role AS role_5, t0.company_id AS company_id_6 FROM potential_customer_company_contact t0 WHERE t0.company_id = 134 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.banned AS banned_2,
  t0.contract AS contract_3,
  t0.contract_number AS contract_number_4,
  t0.contract_valid_to AS contract_valid_to_5,
  t0.currency AS currency_6,
  t0.electronic_invoicing_identifier AS electronic_invoicing_identifier_7,
  t0.electronic_invoicing_identifier_scheme AS electronic_invoicing_identifier_scheme_8,
  t0.electronic_invoicing_intermediator AS electronic_invoicing_intermediator_9,
  t0.indirect AS indirect_10,
  t0.name AS name_11,
  t0.notes AS notes_12,
  t0.warranty AS warranty_13,
  t0.address_row_1 AS address_row_1_14,
  t0.address_row_2 AS address_row_2_15,
  t0.address_row_3 AS address_row_3_16,
  t0.address_row_4 AS address_row_4_17,
  t0.city AS city_18,
  t0.contact_person_email AS contact_person_email_19,
  t0.contact_person_name AS contact_person_name_20,
  t0.country AS country_21,
  t0.postal_code AS postal_code_22,
  t0.vat_id AS vat_id_23,
  t0.terms_of_delivery AS terms_of_delivery_24,
  t0.terms_of_delivery_rules AS terms_of_delivery_rules_25,
  t0.transportation AS transportation_26,
  t0.bank_account_id AS bank_account_id_27,
  t0.price_group_id AS price_group_id_28,
  t29.id AS id_30,
  t29.name AS name_31,
  t29.notes AS notes_32,
  t29.company_id AS company_id_33
FROM
  company t0
  LEFT JOIN potential_customer_company t29 ON t29.company_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.banned AS banned_2, t0.contract AS contract_3, t0.contract_number AS contract_number_4, t0.contract_valid_to AS contract_valid_to_5, t0.currency AS currency_6, t0.electronic_invoicing_identifier AS electronic_invoicing_identifier_7, t0.electronic_invoicing_identifier_scheme AS electronic_invoicing_identifier_scheme_8, t0.electronic_invoicing_intermediator AS electronic_invoicing_intermediator_9, t0.indirect AS indirect_10, t0.name AS name_11, t0.notes AS notes_12, t0.warranty AS warranty_13, t0.address_row_1 AS address_row_1_14, t0.address_row_2 AS address_row_2_15, t0.address_row_3 AS address_row_3_16, t0.address_row_4 AS address_row_4_17, t0.city AS city_18, t0.contact_person_email AS contact_person_email_19, t0.contact_person_name AS contact_person_name_20, t0.country AS country_21, t0.postal_code AS postal_code_22, t0.vat_id AS vat_id_23, t0.terms_of_delivery AS terms_of_delivery_24, t0.terms_of_delivery_rules AS terms_of_delivery_rules_25, t0.transportation AS transportation_26, t0.bank_account_id AS bank_account_id_27, t0.price_group_id AS price_group_id_28, t29.id AS id_30, t29.name AS name_31, t29.notes AS notes_32, t29.company_id AS company_id_33 FROM company t0 LEFT JOIN potential_customer_company t29 ON t29.company_id = t0.id WHERE t0.id = 156;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.name AS name_3,
  t0.phone AS phone_4,
  t0.role AS role_5,
  t0.company_id AS company_id_6
FROM
  potential_customer_company_contact t0
WHERE
  t0.company_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.phone AS phone_4, t0.role AS role_5, t0.company_id AS company_id_6 FROM potential_customer_company_contact t0 WHERE t0.company_id = 150 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.banned AS banned_2,
  t0.contract AS contract_3,
  t0.contract_number AS contract_number_4,
  t0.contract_valid_to AS contract_valid_to_5,
  t0.currency AS currency_6,
  t0.electronic_invoicing_identifier AS electronic_invoicing_identifier_7,
  t0.electronic_invoicing_identifier_scheme AS electronic_invoicing_identifier_scheme_8,
  t0.electronic_invoicing_intermediator AS electronic_invoicing_intermediator_9,
  t0.indirect AS indirect_10,
  t0.name AS name_11,
  t0.notes AS notes_12,
  t0.warranty AS warranty_13,
  t0.address_row_1 AS address_row_1_14,
  t0.address_row_2 AS address_row_2_15,
  t0.address_row_3 AS address_row_3_16,
  t0.address_row_4 AS address_row_4_17,
  t0.city AS city_18,
  t0.contact_person_email AS contact_person_email_19,
  t0.contact_person_name AS contact_person_name_20,
  t0.country AS country_21,
  t0.postal_code AS postal_code_22,
  t0.vat_id AS vat_id_23,
  t0.terms_of_delivery AS terms_of_delivery_24,
  t0.terms_of_delivery_rules AS terms_of_delivery_rules_25,
  t0.transportation AS transportation_26,
  t0.bank_account_id AS bank_account_id_27,
  t0.price_group_id AS price_group_id_28,
  t29.id AS id_30,
  t29.name AS name_31,
  t29.notes AS notes_32,
  t29.company_id AS company_id_33
FROM
  company t0
  LEFT JOIN potential_customer_company t29 ON t29.company_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.banned AS banned_2, t0.contract AS contract_3, t0.contract_number AS contract_number_4, t0.contract_valid_to AS contract_valid_to_5, t0.currency AS currency_6, t0.electronic_invoicing_identifier AS electronic_invoicing_identifier_7, t0.electronic_invoicing_identifier_scheme AS electronic_invoicing_identifier_scheme_8, t0.electronic_invoicing_intermediator AS electronic_invoicing_intermediator_9, t0.indirect AS indirect_10, t0.name AS name_11, t0.notes AS notes_12, t0.warranty AS warranty_13, t0.address_row_1 AS address_row_1_14, t0.address_row_2 AS address_row_2_15, t0.address_row_3 AS address_row_3_16, t0.address_row_4 AS address_row_4_17, t0.city AS city_18, t0.contact_person_email AS contact_person_email_19, t0.contact_person_name AS contact_person_name_20, t0.country AS country_21, t0.postal_code AS postal_code_22, t0.vat_id AS vat_id_23, t0.terms_of_delivery AS terms_of_delivery_24, t0.terms_of_delivery_rules AS terms_of_delivery_rules_25, t0.transportation AS transportation_26, t0.bank_account_id AS bank_account_id_27, t0.price_group_id AS price_group_id_28, t29.id AS id_30, t29.name AS name_31, t29.notes AS notes_32, t29.company_id AS company_id_33 FROM company t0 LEFT JOIN potential_customer_company t29 ON t29.company_id = t0.id WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.name AS name_3,
  t0.phone AS phone_4,
  t0.role AS role_5,
  t0.company_id AS company_id_6
FROM
  potential_customer_company_contact t0
WHERE
  t0.company_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.phone AS phone_4, t0.role AS role_5, t0.company_id AS company_id_6 FROM potential_customer_company_contact t0 WHERE t0.company_id = 7 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.banned AS banned_2,
  t0.contract AS contract_3,
  t0.contract_number AS contract_number_4,
  t0.contract_valid_to AS contract_valid_to_5,
  t0.currency AS currency_6,
  t0.electronic_invoicing_identifier AS electronic_invoicing_identifier_7,
  t0.electronic_invoicing_identifier_scheme AS electronic_invoicing_identifier_scheme_8,
  t0.electronic_invoicing_intermediator AS electronic_invoicing_intermediator_9,
  t0.indirect AS indirect_10,
  t0.name AS name_11,
  t0.notes AS notes_12,
  t0.warranty AS warranty_13,
  t0.address_row_1 AS address_row_1_14,
  t0.address_row_2 AS address_row_2_15,
  t0.address_row_3 AS address_row_3_16,
  t0.address_row_4 AS address_row_4_17,
  t0.city AS city_18,
  t0.contact_person_email AS contact_person_email_19,
  t0.contact_person_name AS contact_person_name_20,
  t0.country AS country_21,
  t0.postal_code AS postal_code_22,
  t0.vat_id AS vat_id_23,
  t0.terms_of_delivery AS terms_of_delivery_24,
  t0.terms_of_delivery_rules AS terms_of_delivery_rules_25,
  t0.transportation AS transportation_26,
  t0.bank_account_id AS bank_account_id_27,
  t0.price_group_id AS price_group_id_28,
  t29.id AS id_30,
  t29.name AS name_31,
  t29.notes AS notes_32,
  t29.company_id AS company_id_33
FROM
  company t0
  LEFT JOIN potential_customer_company t29 ON t29.company_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.banned AS banned_2, t0.contract AS contract_3, t0.contract_number AS contract_number_4, t0.contract_valid_to AS contract_valid_to_5, t0.currency AS currency_6, t0.electronic_invoicing_identifier AS electronic_invoicing_identifier_7, t0.electronic_invoicing_identifier_scheme AS electronic_invoicing_identifier_scheme_8, t0.electronic_invoicing_intermediator AS electronic_invoicing_intermediator_9, t0.indirect AS indirect_10, t0.name AS name_11, t0.notes AS notes_12, t0.warranty AS warranty_13, t0.address_row_1 AS address_row_1_14, t0.address_row_2 AS address_row_2_15, t0.address_row_3 AS address_row_3_16, t0.address_row_4 AS address_row_4_17, t0.city AS city_18, t0.contact_person_email AS contact_person_email_19, t0.contact_person_name AS contact_person_name_20, t0.country AS country_21, t0.postal_code AS postal_code_22, t0.vat_id AS vat_id_23, t0.terms_of_delivery AS terms_of_delivery_24, t0.terms_of_delivery_rules AS terms_of_delivery_rules_25, t0.transportation AS transportation_26, t0.bank_account_id AS bank_account_id_27, t0.price_group_id AS price_group_id_28, t29.id AS id_30, t29.name AS name_31, t29.notes AS notes_32, t29.company_id AS company_id_33 FROM company t0 LEFT JOIN potential_customer_company t29 ON t29.company_id = t0.id WHERE t0.id = 108;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.name AS name_3,
  t0.phone AS phone_4,
  t0.role AS role_5,
  t0.company_id AS company_id_6
FROM
  potential_customer_company_contact t0
WHERE
  t0.company_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.phone AS phone_4, t0.role AS role_5, t0.company_id AS company_id_6 FROM potential_customer_company_contact t0 WHERE t0.company_id = 8 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.banned AS banned_2,
  t0.contract AS contract_3,
  t0.contract_number AS contract_number_4,
  t0.contract_valid_to AS contract_valid_to_5,
  t0.currency AS currency_6,
  t0.electronic_invoicing_identifier AS electronic_invoicing_identifier_7,
  t0.electronic_invoicing_identifier_scheme AS electronic_invoicing_identifier_scheme_8,
  t0.electronic_invoicing_intermediator AS electronic_invoicing_intermediator_9,
  t0.indirect AS indirect_10,
  t0.name AS name_11,
  t0.notes AS notes_12,
  t0.warranty AS warranty_13,
  t0.address_row_1 AS address_row_1_14,
  t0.address_row_2 AS address_row_2_15,
  t0.address_row_3 AS address_row_3_16,
  t0.address_row_4 AS address_row_4_17,
  t0.city AS city_18,
  t0.contact_person_email AS contact_person_email_19,
  t0.contact_person_name AS contact_person_name_20,
  t0.country AS country_21,
  t0.postal_code AS postal_code_22,
  t0.vat_id AS vat_id_23,
  t0.terms_of_delivery AS terms_of_delivery_24,
  t0.terms_of_delivery_rules AS terms_of_delivery_rules_25,
  t0.transportation AS transportation_26,
  t0.bank_account_id AS bank_account_id_27,
  t0.price_group_id AS price_group_id_28,
  t29.id AS id_30,
  t29.name AS name_31,
  t29.notes AS notes_32,
  t29.company_id AS company_id_33
FROM
  company t0
  LEFT JOIN potential_customer_company t29 ON t29.company_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.banned AS banned_2, t0.contract AS contract_3, t0.contract_number AS contract_number_4, t0.contract_valid_to AS contract_valid_to_5, t0.currency AS currency_6, t0.electronic_invoicing_identifier AS electronic_invoicing_identifier_7, t0.electronic_invoicing_identifier_scheme AS electronic_invoicing_identifier_scheme_8, t0.electronic_invoicing_intermediator AS electronic_invoicing_intermediator_9, t0.indirect AS indirect_10, t0.name AS name_11, t0.notes AS notes_12, t0.warranty AS warranty_13, t0.address_row_1 AS address_row_1_14, t0.address_row_2 AS address_row_2_15, t0.address_row_3 AS address_row_3_16, t0.address_row_4 AS address_row_4_17, t0.city AS city_18, t0.contact_person_email AS contact_person_email_19, t0.contact_person_name AS contact_person_name_20, t0.country AS country_21, t0.postal_code AS postal_code_22, t0.vat_id AS vat_id_23, t0.terms_of_delivery AS terms_of_delivery_24, t0.terms_of_delivery_rules AS terms_of_delivery_rules_25, t0.transportation AS transportation_26, t0.bank_account_id AS bank_account_id_27, t0.price_group_id AS price_group_id_28, t29.id AS id_30, t29.name AS name_31, t29.notes AS notes_32, t29.company_id AS company_id_33 FROM company t0 LEFT JOIN potential_customer_company t29 ON t29.company_id = t0.id WHERE t0.id = 181;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.name AS name_3,
  t0.phone AS phone_4,
  t0.role AS role_5,
  t0.company_id AS company_id_6
FROM
  potential_customer_company_contact t0
WHERE
  t0.company_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.phone AS phone_4, t0.role AS role_5, t0.company_id AS company_id_6 FROM potential_customer_company_contact t0 WHERE t0.company_id = 177 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.banned AS banned_2,
  t0.contract AS contract_3,
  t0.contract_number AS contract_number_4,
  t0.contract_valid_to AS contract_valid_to_5,
  t0.currency AS currency_6,
  t0.electronic_invoicing_identifier AS electronic_invoicing_identifier_7,
  t0.electronic_invoicing_identifier_scheme AS electronic_invoicing_identifier_scheme_8,
  t0.electronic_invoicing_intermediator AS electronic_invoicing_intermediator_9,
  t0.indirect AS indirect_10,
  t0.name AS name_11,
  t0.notes AS notes_12,
  t0.warranty AS warranty_13,
  t0.address_row_1 AS address_row_1_14,
  t0.address_row_2 AS address_row_2_15,
  t0.address_row_3 AS address_row_3_16,
  t0.address_row_4 AS address_row_4_17,
  t0.city AS city_18,
  t0.contact_person_email AS contact_person_email_19,
  t0.contact_person_name AS contact_person_name_20,
  t0.country AS country_21,
  t0.postal_code AS postal_code_22,
  t0.vat_id AS vat_id_23,
  t0.terms_of_delivery AS terms_of_delivery_24,
  t0.terms_of_delivery_rules AS terms_of_delivery_rules_25,
  t0.transportation AS transportation_26,
  t0.bank_account_id AS bank_account_id_27,
  t0.price_group_id AS price_group_id_28,
  t29.id AS id_30,
  t29.name AS name_31,
  t29.notes AS notes_32,
  t29.company_id AS company_id_33
FROM
  company t0
  LEFT JOIN potential_customer_company t29 ON t29.company_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.banned AS banned_2, t0.contract AS contract_3, t0.contract_number AS contract_number_4, t0.contract_valid_to AS contract_valid_to_5, t0.currency AS currency_6, t0.electronic_invoicing_identifier AS electronic_invoicing_identifier_7, t0.electronic_invoicing_identifier_scheme AS electronic_invoicing_identifier_scheme_8, t0.electronic_invoicing_intermediator AS electronic_invoicing_intermediator_9, t0.indirect AS indirect_10, t0.name AS name_11, t0.notes AS notes_12, t0.warranty AS warranty_13, t0.address_row_1 AS address_row_1_14, t0.address_row_2 AS address_row_2_15, t0.address_row_3 AS address_row_3_16, t0.address_row_4 AS address_row_4_17, t0.city AS city_18, t0.contact_person_email AS contact_person_email_19, t0.contact_person_name AS contact_person_name_20, t0.country AS country_21, t0.postal_code AS postal_code_22, t0.vat_id AS vat_id_23, t0.terms_of_delivery AS terms_of_delivery_24, t0.terms_of_delivery_rules AS terms_of_delivery_rules_25, t0.transportation AS transportation_26, t0.bank_account_id AS bank_account_id_27, t0.price_group_id AS price_group_id_28, t29.id AS id_30, t29.name AS name_31, t29.notes AS notes_32, t29.company_id AS company_id_33 FROM company t0 LEFT JOIN potential_customer_company t29 ON t29.company_id = t0.id WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.name AS name_3,
  t0.phone AS phone_4,
  t0.role AS role_5,
  t0.company_id AS company_id_6
FROM
  potential_customer_company_contact t0
WHERE
  t0.company_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.phone AS phone_4, t0.role AS role_5, t0.company_id AS company_id_6 FROM potential_customer_company_contact t0 WHERE t0.company_id = 9 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.banned AS banned_2,
  t0.contract AS contract_3,
  t0.contract_number AS contract_number_4,
  t0.contract_valid_to AS contract_valid_to_5,
  t0.currency AS currency_6,
  t0.electronic_invoicing_identifier AS electronic_invoicing_identifier_7,
  t0.electronic_invoicing_identifier_scheme AS electronic_invoicing_identifier_scheme_8,
  t0.electronic_invoicing_intermediator AS electronic_invoicing_intermediator_9,
  t0.indirect AS indirect_10,
  t0.name AS name_11,
  t0.notes AS notes_12,
  t0.warranty AS warranty_13,
  t0.address_row_1 AS address_row_1_14,
  t0.address_row_2 AS address_row_2_15,
  t0.address_row_3 AS address_row_3_16,
  t0.address_row_4 AS address_row_4_17,
  t0.city AS city_18,
  t0.contact_person_email AS contact_person_email_19,
  t0.contact_person_name AS contact_person_name_20,
  t0.country AS country_21,
  t0.postal_code AS postal_code_22,
  t0.vat_id AS vat_id_23,
  t0.terms_of_delivery AS terms_of_delivery_24,
  t0.terms_of_delivery_rules AS terms_of_delivery_rules_25,
  t0.transportation AS transportation_26,
  t0.bank_account_id AS bank_account_id_27,
  t0.price_group_id AS price_group_id_28,
  t29.id AS id_30,
  t29.name AS name_31,
  t29.notes AS notes_32,
  t29.company_id AS company_id_33
FROM
  company t0
  LEFT JOIN potential_customer_company t29 ON t29.company_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.banned AS banned_2, t0.contract AS contract_3, t0.contract_number AS contract_number_4, t0.contract_valid_to AS contract_valid_to_5, t0.currency AS currency_6, t0.electronic_invoicing_identifier AS electronic_invoicing_identifier_7, t0.electronic_invoicing_identifier_scheme AS electronic_invoicing_identifier_scheme_8, t0.electronic_invoicing_intermediator AS electronic_invoicing_intermediator_9, t0.indirect AS indirect_10, t0.name AS name_11, t0.notes AS notes_12, t0.warranty AS warranty_13, t0.address_row_1 AS address_row_1_14, t0.address_row_2 AS address_row_2_15, t0.address_row_3 AS address_row_3_16, t0.address_row_4 AS address_row_4_17, t0.city AS city_18, t0.contact_person_email AS contact_person_email_19, t0.contact_person_name AS contact_person_name_20, t0.country AS country_21, t0.postal_code AS postal_code_22, t0.vat_id AS vat_id_23, t0.terms_of_delivery AS terms_of_delivery_24, t0.terms_of_delivery_rules AS terms_of_delivery_rules_25, t0.transportation AS transportation_26, t0.bank_account_id AS bank_account_id_27, t0.price_group_id AS price_group_id_28, t29.id AS id_30, t29.name AS name_31, t29.notes AS notes_32, t29.company_id AS company_id_33 FROM company t0 LEFT JOIN potential_customer_company t29 ON t29.company_id = t0.id WHERE t0.id = 183;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.name AS name_3,
  t0.phone AS phone_4,
  t0.role AS role_5,
  t0.company_id AS company_id_6
FROM
  potential_customer_company_contact t0
WHERE
  t0.company_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.phone AS phone_4, t0.role AS role_5, t0.company_id AS company_id_6 FROM potential_customer_company_contact t0 WHERE t0.company_id = 179 ORDER BY t0.name ASC;