Symfony Profiler

SELECT
  r0_.webspace AS webspace_0,
  r0_.locale AS locale_1,
  r0_.slug AS slug_2,
  r0_.resource_key AS resource_key_3,
  r0_.resource_id AS resource_id_4,
  r0_.id AS id_5,
  r0_.parent_id AS parent_id_6
FROM
  ro_routes r0_
WHERE
  (
    (
      r0_.webspace = ?
      OR r0_.webspace IS NULL
    )
  )
  AND r0_.locale = ?
  AND r0_.slug = ?
ORDER BY
  r0_.webspace DESC
LIMIT
  1

SELECT r0_.webspace AS webspace_0, r0_.locale AS locale_1, r0_.slug AS slug_2, r0_.resource_key AS resource_key_3, r0_.resource_id AS resource_id_4, r0_.id AS id_5, r0_.parent_id AS parent_id_6 FROM ro_routes r0_ WHERE ((r0_.webspace = 'website' OR r0_.webspace IS NULL)) AND r0_.locale = 'en' AND r0_.slug = '/' ORDER BY r0_.webspace DESC LIMIT 1;

SELECT
  p0_.webspaceKey AS webspaceKey_0,
  p0_.lft AS lft_1,
  p0_.rgt AS rgt_2,
  p0_.depth AS depth_3,
  p0_.uuid AS uuid_4,
  p0_.created AS created_5,
  p0_.changed AS changed_6,
  p1_.title AS title_7,
  p1_.id AS id_8,
  p1_.stage AS stage_9,
  p1_.locale AS locale_10,
  p1_.ghostLocale AS ghostLocale_11,
  p1_.availableLocales AS availableLocales_12,
  p1_.version AS version_13,
  p1_.shadowLocale AS shadowLocale_14,
  p1_.shadowLocales AS shadowLocales_15,
  p1_.templateKey AS templateKey_16,
  p1_.templateData AS templateData_17,
  p1_.seoData AS seoData_18,
  p1_.seoNoIndex AS seoNoIndex_19,
  p1_.seoNoFollow AS seoNoFollow_20,
  p1_.seoHideInSitemap AS seoHideInSitemap_21,
  p1_.excerptData AS excerptData_22,
  p1_.excerptSegment AS excerptSegment_23,
  p1_.authored AS authored_24,
  p1_.lastModified AS lastModified_25,
  p1_.workflowPlace AS workflowPlace_26,
  p1_.workflowPublished AS workflowPublished_27,
  p1_.linkProvider AS linkProvider_28,
  p1_.linkData AS linkData_29,
  p1_.created AS created_30,
  p1_.changed AS changed_31,
  t2_.name AS name_32,
  t2_.id AS id_33,
  t2_.created AS created_34,
  t2_.changed AS changed_35,
  c3_.category_key AS category_key_36,
  c3_.default_locale AS default_locale_37,
  c3_.lft AS lft_38,
  c3_.rgt AS rgt_39,
  c3_.depth AS depth_40,
  c3_.id AS id_41,
  c3_.created AS created_42,
  c3_.changed AS changed_43,
  c4_.translation AS translation_44,
  c4_.locale AS locale_45,
  c4_.description AS description_46,
  c4_.id AS id_47,
  c4_.created AS created_48,
  c4_.changed AS changed_49,
  p0_.parent_id AS parent_id_50,
  p0_.idUsersCreator AS idUsersCreator_51,
  p0_.idUsersChanger AS idUsersChanger_52,
  p1_.route_id AS route_id_53,
  p1_.pageUuid AS pageUuid_54,
  p1_.author_id AS author_id_55,
  p1_.idUsersCreator AS idUsersCreator_56,
  p1_.idUsersChanger AS idUsersChanger_57,
  t2_.idUsersCreator AS idUsersCreator_58,
  t2_.idUsersChanger AS idUsersChanger_59,
  c3_.idCategoriesParent AS idCategoriesParent_60,
  c3_.idUsersCreator AS idUsersCreator_61,
  c3_.idUsersChanger AS idUsersChanger_62,
  c4_.idCategories AS idCategories_63,
  c4_.idUsersCreator AS idUsersCreator_64,
  c4_.idUsersChanger AS idUsersChanger_65
FROM
  pa_pages p0_
  LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid
  AND (
    p1_.stage = ?
    AND p1_.version = ?
    AND (
      p1_.locale IS NULL
      OR p1_.locale = ?
    )
  )
  LEFT JOIN pa_page_dimension_content_excerpt_tags p5_ ON p1_.id = p5_.page_dimension_content_id
  LEFT JOIN ta_tags t2_ ON t2_.id = p5_.tag_id
  LEFT JOIN pa_page_dimension_content_excerpt_categories p6_ ON p1_.id = p6_.page_dimension_content_id
  LEFT JOIN ca_categories c3_ ON c3_.id = p6_.category_id
  LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories
WHERE
  p0_.uuid = ?

SELECT p0_.webspaceKey AS webspaceKey_0, p0_.lft AS lft_1, p0_.rgt AS rgt_2, p0_.depth AS depth_3, p0_.uuid AS uuid_4, p0_.created AS created_5, p0_.changed AS changed_6, p1_.title AS title_7, p1_.id AS id_8, p1_.stage AS stage_9, p1_.locale AS locale_10, p1_.ghostLocale AS ghostLocale_11, p1_.availableLocales AS availableLocales_12, p1_.version AS version_13, p1_.shadowLocale AS shadowLocale_14, p1_.shadowLocales AS shadowLocales_15, p1_.templateKey AS templateKey_16, p1_.templateData AS templateData_17, p1_.seoData AS seoData_18, p1_.seoNoIndex AS seoNoIndex_19, p1_.seoNoFollow AS seoNoFollow_20, p1_.seoHideInSitemap AS seoHideInSitemap_21, p1_.excerptData AS excerptData_22, p1_.excerptSegment AS excerptSegment_23, p1_.authored AS authored_24, p1_.lastModified AS lastModified_25, p1_.workflowPlace AS workflowPlace_26, p1_.workflowPublished AS workflowPublished_27, p1_.linkProvider AS linkProvider_28, p1_.linkData AS linkData_29, p1_.created AS created_30, p1_.changed AS changed_31, t2_.name AS name_32, t2_.id AS id_33, t2_.created AS created_34, t2_.changed AS changed_35, c3_.category_key AS category_key_36, c3_.default_locale AS default_locale_37, c3_.lft AS lft_38, c3_.rgt AS rgt_39, c3_.depth AS depth_40, c3_.id AS id_41, c3_.created AS created_42, c3_.changed AS changed_43, c4_.translation AS translation_44, c4_.locale AS locale_45, c4_.description AS description_46, c4_.id AS id_47, c4_.created AS created_48, c4_.changed AS changed_49, p0_.parent_id AS parent_id_50, p0_.idUsersCreator AS idUsersCreator_51, p0_.idUsersChanger AS idUsersChanger_52, p1_.route_id AS route_id_53, p1_.pageUuid AS pageUuid_54, p1_.author_id AS author_id_55, p1_.idUsersCreator AS idUsersCreator_56, p1_.idUsersChanger AS idUsersChanger_57, t2_.idUsersCreator AS idUsersCreator_58, t2_.idUsersChanger AS idUsersChanger_59, c3_.idCategoriesParent AS idCategoriesParent_60, c3_.idUsersCreator AS idUsersCreator_61, c3_.idUsersChanger AS idUsersChanger_62, c4_.idCategories AS idCategories_63, c4_.idUsersCreator AS idUsersCreator_64, c4_.idUsersChanger AS idUsersChanger_65 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid AND (p1_.stage = 'live' AND p1_.version = 0 AND (p1_.locale IS NULL OR p1_.locale = 'en')) LEFT JOIN pa_page_dimension_content_excerpt_tags p5_ ON p1_.id = p5_.page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p5_.tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p6_ ON p1_.id = p6_.page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = p6_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories WHERE p0_.uuid = '019ca6bb-42f6-7d2c-be2a-c5e1008281e7';

SELECT
  t0.name AS name_1,
  t0.id AS id_2,
  t0.page_dimension_content_id AS page_dimension_content_id_3
FROM
  pa_page_dimension_content_navigation_contexts t0
WHERE
  t0.page_dimension_content_id = ?

SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = 5;

SELECT
  t0.name AS name_1,
  t0.id AS id_2,
  t0.page_dimension_content_id AS page_dimension_content_id_3
FROM
  pa_page_dimension_content_navigation_contexts t0
WHERE
  t0.page_dimension_content_id = ?

SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = 6;

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.firstName AS firstName_1,
  c0_.lastName AS lastName_2
FROM
  co_contacts c0_
ORDER BY
  c0_.firstName ASC
LIMIT
  5

SELECT DISTINCT c0_.id AS id_0, c0_.firstName AS firstName_1, c0_.lastName AS lastName_2 FROM co_contacts c0_ ORDER BY c0_.firstName ASC LIMIT 5;

SELECT
  COUNT(DISTINCT c0_.id) AS sclr_0
FROM
  co_contacts c0_

SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM co_contacts c0_;

SELECT
  DISTINCT p0_.uuid AS uuid_0,
  p0_.webspaceKey AS webspaceKey_1,
  p1_.title AS title_2,
  p1_.workflowPublished AS workflowPublished_3
FROM
  pa_pages p0_
  LEFT JOIN pa_page_dimension_contents p1_ ON (p1_.pageUuid = p0_.uuid)
  LEFT JOIN pa_pages p2_ ON (p2_.uuid = ?)
WHERE
  p1_.locale = ?
  AND p1_.stage = ?
  AND p1_.version = ?
  AND p1_.templateKey IN (?, ?)
  AND p0_.lft > p2_.lft
  AND p0_.rgt < p2_.rgt
ORDER BY
  p1_.workflowPublished ASC
LIMIT
  5

SELECT DISTINCT p0_.uuid AS uuid_0, p0_.webspaceKey AS webspaceKey_1, p1_.title AS title_2, p1_.workflowPublished AS workflowPublished_3 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p1_ ON (p1_.pageUuid = p0_.uuid) LEFT JOIN pa_pages p2_ ON (p2_.uuid = '019ca6bb-42f6-7d2c-be2a-c5e1008281e7') WHERE p1_.locale = 'en' AND p1_.stage = 'live' AND p1_.version = 0 AND p1_.templateKey IN ('homepage', 'default') AND p0_.lft > p2_.lft AND p0_.rgt < p2_.rgt ORDER BY p1_.workflowPublished ASC LIMIT 5;

SELECT
  COUNT(DISTINCT p0_.uuid) AS sclr_0
FROM
  pa_pages p0_
  LEFT JOIN pa_page_dimension_contents p1_ ON (p1_.pageUuid = p0_.uuid)
  LEFT JOIN pa_pages p2_ ON (p2_.uuid = ?)
WHERE
  p1_.locale = ?
  AND p1_.stage = ?
  AND p1_.version = ?
  AND p1_.templateKey IN (?, ?)
  AND p0_.lft > p2_.lft
  AND p0_.rgt < p2_.rgt

SELECT COUNT(DISTINCT p0_.uuid) AS sclr_0 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p1_ ON (p1_.pageUuid = p0_.uuid) LEFT JOIN pa_pages p2_ ON (p2_.uuid = '019ca6bb-42f6-7d2c-be2a-c5e1008281e7') WHERE p1_.locale = 'en' AND p1_.stage = 'live' AND p1_.version = 0 AND p1_.templateKey IN ('homepage', 'default') AND p0_.lft > p2_.lft AND p0_.rgt < p2_.rgt;

SELECT
  c0_.firstName AS firstName_0,
  c0_.middleName AS middleName_1,
  c0_.lastName AS lastName_2,
  c0_.birthday AS birthday_3,
  c0_.salutation AS salutation_4,
  c0_.formOfAddress AS formOfAddress_5,
  c0_.newsletter AS newsletter_6,
  c0_.gender AS gender_7,
  c0_.note AS note_8,
  c0_.mainEmail AS mainEmail_9,
  c0_.mainPhone AS mainPhone_10,
  c0_.mainFax AS mainFax_11,
  c0_.mainUrl AS mainUrl_12,
  c0_.id AS id_13,
  c0_.created AS created_14,
  c0_.changed AS changed_15,
  c1_.main AS main_16,
  c1_.id AS id_17,
  c2_.lft AS lft_18,
  c2_.rgt AS rgt_19,
  c2_.depth AS depth_20,
  c2_.name AS name_21,
  c2_.externalId AS externalId_22,
  c2_.number AS number_23,
  c2_.corporation AS corporation_24,
  c2_.note AS note_25,
  c2_.uid AS uid_26,
  c2_.registerNumber AS registerNumber_27,
  c2_.placeOfJurisdiction AS placeOfJurisdiction_28,
  c2_.mainEmail AS mainEmail_29,
  c2_.mainPhone AS mainPhone_30,
  c2_.mainFax AS mainFax_31,
  c2_.mainUrl AS mainUrl_32,
  c2_.id AS id_33,
  c2_.created AS created_34,
  c2_.changed AS changed_35,
  c3_.firstName AS firstName_36,
  c3_.middleName AS middleName_37,
  c3_.lastName AS lastName_38,
  c3_.birthday AS birthday_39,
  c3_.salutation AS salutation_40,
  c3_.formOfAddress AS formOfAddress_41,
  c3_.newsletter AS newsletter_42,
  c3_.gender AS gender_43,
  c3_.note AS note_44,
  c3_.mainEmail AS mainEmail_45,
  c3_.mainPhone AS mainPhone_46,
  c3_.mainFax AS mainFax_47,
  c3_.mainUrl AS mainUrl_48,
  c3_.id AS id_49,
  c3_.created AS created_50,
  c3_.changed AS changed_51,
  c4_.main AS main_52,
  c4_.id AS id_53,
  c5_.title AS title_54,
  c5_.primaryAddress AS primaryAddress_55,
  c5_.deliveryAddress AS deliveryAddress_56,
  c5_.billingAddress AS billingAddress_57,
  c5_.street AS street_58,
  c5_.number AS number_59,
  c5_.addition AS addition_60,
  c5_.zip AS zip_61,
  c5_.city AS city_62,
  c5_.state AS state_63,
  c5_.countryCode AS countryCode_64,
  c5_.postboxNumber AS postboxNumber_65,
  c5_.postboxPostcode AS postboxPostcode_66,
  c5_.postboxCity AS postboxCity_67,
  c5_.latitude AS latitude_68,
  c5_.longitude AS longitude_69,
  c5_.note AS note_70,
  c5_.id AS id_71,
  c6_.name AS name_72,
  c6_.id AS id_73,
  c7_.locale AS locale_74,
  c7_.id AS id_75,
  c8_.email AS email_76,
  c8_.id AS id_77,
  c9_.name AS name_78,
  c9_.id AS id_79,
  c10_.fax AS fax_80,
  c10_.id AS id_81,
  c11_.name AS name_82,
  c11_.id AS id_83,
  c12_.value AS value_84,
  c12_.id AS id_85,
  c13_.phone AS phone_86,
  c13_.id AS id_87,
  c14_.name AS name_88,
  c14_.id AS id_89,
  t15_.name AS name_90,
  t15_.id AS id_91,
  c16_.url AS url_92,
  c16_.id AS id_93,
  c17_.name AS name_94,
  c17_.id AS id_95,
  c18_.title AS title_96,
  c18_.id AS id_97,
  c19_.position AS position_98,
  c19_.id AS id_99,
  m20_.type AS type_100,
  m20_.id AS id_101,
  m20_.created AS created_102,
  m20_.changed AS changed_103,
  c21_.category_key AS category_key_104,
  c21_.default_locale AS default_locale_105,
  c21_.lft AS lft_106,
  c21_.rgt AS rgt_107,
  c21_.depth AS depth_108,
  c21_.id AS id_109,
  c21_.created AS created_110,
  c21_.changed AS changed_111,
  c22_.translation AS translation_112,
  c22_.locale AS locale_113,
  c22_.description AS description_114,
  c22_.id AS id_115,
  c22_.created AS created_116,
  c22_.changed AS changed_117,
  c23_.bankName AS bankName_118,
  c23_.bic AS bic_119,
  c23_.iban AS iban_120,
  c23_.public AS public_121,
  c23_.id AS id_122,
  c0_.idTitles AS idTitles_123,
  c0_.avatar AS avatar_124,
  c0_.idUsersCreator AS idUsersCreator_125,
  c0_.idUsersChanger AS idUsersChanger_126,
  c1_.idPositions AS idPositions_127,
  c1_.idContacts AS idContacts_128,
  c1_.idAccounts AS idAccounts_129,
  c2_.idContactsMain AS idContactsMain_130,
  c2_.idAccountsParent AS idAccountsParent_131,
  c2_.logo AS logo_132,
  c2_.idUsersCreator AS idUsersCreator_133,
  c2_.idUsersChanger AS idUsersChanger_134,
  c3_.idTitles AS idTitles_135,
  c3_.avatar AS avatar_136,
  c3_.idUsersCreator AS idUsersCreator_137,
  c3_.idUsersChanger AS idUsersChanger_138,
  c4_.idAddresses AS idAddresses_139,
  c4_.idContacts AS idContacts_140,
  c5_.idAdressTypes AS idAdressTypes_141,
  c7_.idContacts AS idContacts_142,
  c8_.idEmailTypes AS idEmailTypes_143,
  c10_.idFaxTypes AS idFaxTypes_144,
  c13_.idPhoneTypes AS idPhoneTypes_145,
  t15_.idUsersCreator AS idUsersCreator_146,
  t15_.idUsersChanger AS idUsersChanger_147,
  c16_.idUrlTypes AS idUrlTypes_148,
  m20_.idPreviewImage AS idPreviewImage_149,
  m20_.idCollections AS idCollections_150,
  m20_.idUsersCreator AS idUsersCreator_151,
  m20_.idUsersChanger AS idUsersChanger_152,
  c21_.idCategoriesParent AS idCategoriesParent_153,
  c21_.idUsersCreator AS idUsersCreator_154,
  c21_.idUsersChanger AS idUsersChanger_155,
  c22_.idCategories AS idCategories_156,
  c22_.idUsersCreator AS idUsersCreator_157,
  c22_.idUsersChanger AS idUsersChanger_158
FROM
  co_contacts c0_
  LEFT JOIN co_account_contacts c1_ ON c0_.id = c1_.idContacts
  LEFT JOIN co_accounts c2_ ON c1_.idAccounts = c2_.id
  LEFT JOIN co_contacts c3_ ON c2_.idContactsMain = c3_.id
  LEFT JOIN co_contact_addresses c4_ ON c0_.id = c4_.idContacts
  LEFT JOIN co_addresses c5_ ON c4_.idAddresses = c5_.id
  LEFT JOIN co_address_types c6_ ON c5_.idAdressTypes = c6_.id
  LEFT JOIN co_contact_locales c7_ ON c0_.id = c7_.idContacts
  LEFT JOIN co_contact_emails c24_ ON c0_.id = c24_.idContacts
  LEFT JOIN co_emails c8_ ON c8_.id = c24_.idEmails
  LEFT JOIN co_email_types c9_ ON c8_.idEmailTypes = c9_.id
  LEFT JOIN co_contact_faxes c25_ ON c0_.id = c25_.idContacts
  LEFT JOIN co_faxes c10_ ON c10_.id = c25_.idFaxes
  LEFT JOIN co_fax_types c11_ ON c10_.idFaxTypes = c11_.id
  LEFT JOIN co_contact_notes c26_ ON c0_.id = c26_.idContacts
  LEFT JOIN co_notes c12_ ON c12_.id = c26_.idNotes
  LEFT JOIN co_contact_phones c27_ ON c0_.id = c27_.idContacts
  LEFT JOIN co_phones c13_ ON c13_.id = c27_.idPhones
  LEFT JOIN co_phone_types c14_ ON c13_.idPhoneTypes = c14_.id
  LEFT JOIN co_contact_tags c28_ ON c0_.id = c28_.idContacts
  LEFT JOIN ta_tags t15_ ON t15_.id = c28_.idTags
  LEFT JOIN co_contact_urls c29_ ON c0_.id = c29_.idContacts
  LEFT JOIN co_urls c16_ ON c16_.id = c29_.idUrls
  LEFT JOIN co_url_types c17_ ON c16_.idUrlTypes = c17_.id
  LEFT JOIN co_contact_titles c18_ ON c0_.idTitles = c18_.id
  LEFT JOIN co_positions c19_ ON c1_.idPositions = c19_.id
  LEFT JOIN co_contact_medias c30_ ON c0_.id = c30_.idContacts
  LEFT JOIN me_media m20_ ON m20_.id = c30_.idMedias
  LEFT JOIN co_contact_categories c31_ ON c0_.id = c31_.idContacts
  LEFT JOIN ca_categories c21_ ON c21_.id = c31_.idCategories
  LEFT JOIN ca_category_translations c22_ ON c21_.id = c22_.idCategories
  LEFT JOIN co_contact_bank_accounts c32_ ON c0_.id = c32_.idContacts
  LEFT JOIN co_bank_account c23_ ON c23_.id = c32_.idBankAccounts
WHERE
  c0_.id IN (?)
ORDER BY
  c0_.id ASC

SELECT c0_.firstName AS firstName_0, c0_.middleName AS middleName_1, c0_.lastName AS lastName_2, c0_.birthday AS birthday_3, c0_.salutation AS salutation_4, c0_.formOfAddress AS formOfAddress_5, c0_.newsletter AS newsletter_6, c0_.gender AS gender_7, c0_.note AS note_8, c0_.mainEmail AS mainEmail_9, c0_.mainPhone AS mainPhone_10, c0_.mainFax AS mainFax_11, c0_.mainUrl AS mainUrl_12, c0_.id AS id_13, c0_.created AS created_14, c0_.changed AS changed_15, c1_.main AS main_16, c1_.id AS id_17, c2_.lft AS lft_18, c2_.rgt AS rgt_19, c2_.depth AS depth_20, c2_.name AS name_21, c2_.externalId AS externalId_22, c2_.number AS number_23, c2_.corporation AS corporation_24, c2_.note AS note_25, c2_.uid AS uid_26, c2_.registerNumber AS registerNumber_27, c2_.placeOfJurisdiction AS placeOfJurisdiction_28, c2_.mainEmail AS mainEmail_29, c2_.mainPhone AS mainPhone_30, c2_.mainFax AS mainFax_31, c2_.mainUrl AS mainUrl_32, c2_.id AS id_33, c2_.created AS created_34, c2_.changed AS changed_35, c3_.firstName AS firstName_36, c3_.middleName AS middleName_37, c3_.lastName AS lastName_38, c3_.birthday AS birthday_39, c3_.salutation AS salutation_40, c3_.formOfAddress AS formOfAddress_41, c3_.newsletter AS newsletter_42, c3_.gender AS gender_43, c3_.note AS note_44, c3_.mainEmail AS mainEmail_45, c3_.mainPhone AS mainPhone_46, c3_.mainFax AS mainFax_47, c3_.mainUrl AS mainUrl_48, c3_.id AS id_49, c3_.created AS created_50, c3_.changed AS changed_51, c4_.main AS main_52, c4_.id AS id_53, c5_.title AS title_54, c5_.primaryAddress AS primaryAddress_55, c5_.deliveryAddress AS deliveryAddress_56, c5_.billingAddress AS billingAddress_57, c5_.street AS street_58, c5_.number AS number_59, c5_.addition AS addition_60, c5_.zip AS zip_61, c5_.city AS city_62, c5_.state AS state_63, c5_.countryCode AS countryCode_64, c5_.postboxNumber AS postboxNumber_65, c5_.postboxPostcode AS postboxPostcode_66, c5_.postboxCity AS postboxCity_67, c5_.latitude AS latitude_68, c5_.longitude AS longitude_69, c5_.note AS note_70, c5_.id AS id_71, c6_.name AS name_72, c6_.id AS id_73, c7_.locale AS locale_74, c7_.id AS id_75, c8_.email AS email_76, c8_.id AS id_77, c9_.name AS name_78, c9_.id AS id_79, c10_.fax AS fax_80, c10_.id AS id_81, c11_.name AS name_82, c11_.id AS id_83, c12_.value AS value_84, c12_.id AS id_85, c13_.phone AS phone_86, c13_.id AS id_87, c14_.name AS name_88, c14_.id AS id_89, t15_.name AS name_90, t15_.id AS id_91, c16_.url AS url_92, c16_.id AS id_93, c17_.name AS name_94, c17_.id AS id_95, c18_.title AS title_96, c18_.id AS id_97, c19_.position AS position_98, c19_.id AS id_99, m20_.type AS type_100, m20_.id AS id_101, m20_.created AS created_102, m20_.changed AS changed_103, c21_.category_key AS category_key_104, c21_.default_locale AS default_locale_105, c21_.lft AS lft_106, c21_.rgt AS rgt_107, c21_.depth AS depth_108, c21_.id AS id_109, c21_.created AS created_110, c21_.changed AS changed_111, c22_.translation AS translation_112, c22_.locale AS locale_113, c22_.description AS description_114, c22_.id AS id_115, c22_.created AS created_116, c22_.changed AS changed_117, c23_.bankName AS bankName_118, c23_.bic AS bic_119, c23_.iban AS iban_120, c23_.public AS public_121, c23_.id AS id_122, c0_.idTitles AS idTitles_123, c0_.avatar AS avatar_124, c0_.idUsersCreator AS idUsersCreator_125, c0_.idUsersChanger AS idUsersChanger_126, c1_.idPositions AS idPositions_127, c1_.idContacts AS idContacts_128, c1_.idAccounts AS idAccounts_129, c2_.idContactsMain AS idContactsMain_130, c2_.idAccountsParent AS idAccountsParent_131, c2_.logo AS logo_132, c2_.idUsersCreator AS idUsersCreator_133, c2_.idUsersChanger AS idUsersChanger_134, c3_.idTitles AS idTitles_135, c3_.avatar AS avatar_136, c3_.idUsersCreator AS idUsersCreator_137, c3_.idUsersChanger AS idUsersChanger_138, c4_.idAddresses AS idAddresses_139, c4_.idContacts AS idContacts_140, c5_.idAdressTypes AS idAdressTypes_141, c7_.idContacts AS idContacts_142, c8_.idEmailTypes AS idEmailTypes_143, c10_.idFaxTypes AS idFaxTypes_144, c13_.idPhoneTypes AS idPhoneTypes_145, t15_.idUsersCreator AS idUsersCreator_146, t15_.idUsersChanger AS idUsersChanger_147, c16_.idUrlTypes AS idUrlTypes_148, m20_.idPreviewImage AS idPreviewImage_149, m20_.idCollections AS idCollections_150, m20_.idUsersCreator AS idUsersCreator_151, m20_.idUsersChanger AS idUsersChanger_152, c21_.idCategoriesParent AS idCategoriesParent_153, c21_.idUsersCreator AS idUsersCreator_154, c21_.idUsersChanger AS idUsersChanger_155, c22_.idCategories AS idCategories_156, c22_.idUsersCreator AS idUsersCreator_157, c22_.idUsersChanger AS idUsersChanger_158 FROM co_contacts c0_ LEFT JOIN co_account_contacts c1_ ON c0_.id = c1_.idContacts LEFT JOIN co_accounts c2_ ON c1_.idAccounts = c2_.id LEFT JOIN co_contacts c3_ ON c2_.idContactsMain = c3_.id LEFT JOIN co_contact_addresses c4_ ON c0_.id = c4_.idContacts LEFT JOIN co_addresses c5_ ON c4_.idAddresses = c5_.id LEFT JOIN co_address_types c6_ ON c5_.idAdressTypes = c6_.id LEFT JOIN co_contact_locales c7_ ON c0_.id = c7_.idContacts LEFT JOIN co_contact_emails c24_ ON c0_.id = c24_.idContacts LEFT JOIN co_emails c8_ ON c8_.id = c24_.idEmails LEFT JOIN co_email_types c9_ ON c8_.idEmailTypes = c9_.id LEFT JOIN co_contact_faxes c25_ ON c0_.id = c25_.idContacts LEFT JOIN co_faxes c10_ ON c10_.id = c25_.idFaxes LEFT JOIN co_fax_types c11_ ON c10_.idFaxTypes = c11_.id LEFT JOIN co_contact_notes c26_ ON c0_.id = c26_.idContacts LEFT JOIN co_notes c12_ ON c12_.id = c26_.idNotes LEFT JOIN co_contact_phones c27_ ON c0_.id = c27_.idContacts LEFT JOIN co_phones c13_ ON c13_.id = c27_.idPhones LEFT JOIN co_phone_types c14_ ON c13_.idPhoneTypes = c14_.id LEFT JOIN co_contact_tags c28_ ON c0_.id = c28_.idContacts LEFT JOIN ta_tags t15_ ON t15_.id = c28_.idTags LEFT JOIN co_contact_urls c29_ ON c0_.id = c29_.idContacts LEFT JOIN co_urls c16_ ON c16_.id = c29_.idUrls LEFT JOIN co_url_types c17_ ON c16_.idUrlTypes = c17_.id LEFT JOIN co_contact_titles c18_ ON c0_.idTitles = c18_.id LEFT JOIN co_positions c19_ ON c1_.idPositions = c19_.id LEFT JOIN co_contact_medias c30_ ON c0_.id = c30_.idContacts LEFT JOIN me_media m20_ ON m20_.id = c30_.idMedias LEFT JOIN co_contact_categories c31_ ON c0_.id = c31_.idContacts LEFT JOIN ca_categories c21_ ON c21_.id = c31_.idCategories LEFT JOIN ca_category_translations c22_ ON c21_.id = c22_.idCategories LEFT JOIN co_contact_bank_accounts c32_ ON c0_.id = c32_.idContacts LEFT JOIN co_bank_account c23_ ON c23_.id = c32_.idBankAccounts WHERE c0_.id IN (1) ORDER BY c0_.id ASC;