Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.cut_off_date AS cut_off_date_2,
  t0.is_preview AS is_preview_3,
  t0.url_excel AS url_excel_4,
  t0.created_on AS created_on_5,
  t0.updated_on AS updated_on_6,
  t0.poolId AS poolId_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9
FROM
  htt_parsing t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.cut_off_date AS cut_off_date_2, t0.is_preview AS is_preview_3, t0.url_excel AS url_excel_4, t0.created_on AS created_on_5, t0.updated_on AS updated_on_6, t0.poolId AS poolId_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9 FROM htt_parsing t0 WHERE t0.id = '1877' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.display_order AS display_order_4
FROM
  poolprogram_type t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.display_order AS display_order_4 FROM poolprogram_type t0 WHERE t0.name = 'mortgage' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.ext_ref_id AS ext_ref_id_2,
  t0.identifier AS identifier_3,
  t0.url_excel_htt AS url_excel_htt_4,
  t0.description AS description_5,
  t0.validation_date AS validation_date_6,
  t0.is_deleted AS is_deleted_7,
  t0.has_custom_disclaimer AS has_custom_disclaimer_8,
  t0.disclaimer_text AS disclaimer_text_9,
  t0.disclaimer_agree_label AS disclaimer_agree_label_10,
  t0.disclaimer_decline_label AS disclaimer_decline_label_11,
  t0.last_htt_parsing_date AS last_htt_parsing_date_12,
  t0.created_on AS created_on_13,
  t0.updated_on AS updated_on_14,
  t0.typeId AS typeId_15,
  t0.euLabelId AS euLabelId_16,
  t0.issuerId AS issuerId_17,
  t0.currencyId AS currencyId_18,
  t0.modelId AS modelId_19,
  t0.created_by_id AS created_by_id_20,
  t0.updated_by_id AS updated_by_id_21
FROM
  poolprogram t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.ext_ref_id AS ext_ref_id_2, t0.identifier AS identifier_3, t0.url_excel_htt AS url_excel_htt_4, t0.description AS description_5, t0.validation_date AS validation_date_6, t0.is_deleted AS is_deleted_7, t0.has_custom_disclaimer AS has_custom_disclaimer_8, t0.disclaimer_text AS disclaimer_text_9, t0.disclaimer_agree_label AS disclaimer_agree_label_10, t0.disclaimer_decline_label AS disclaimer_decline_label_11, t0.last_htt_parsing_date AS last_htt_parsing_date_12, t0.created_on AS created_on_13, t0.updated_on AS updated_on_14, t0.typeId AS typeId_15, t0.euLabelId AS euLabelId_16, t0.issuerId AS issuerId_17, t0.currencyId AS currencyId_18, t0.modelId AS modelId_19, t0.created_by_id AS created_by_id_20, t0.updated_by_id AS updated_by_id_21 FROM poolprogram t0 WHERE t0.id = 199;

SELECT
  t0.id AS id_1,
  t0.ext_ref_id AS ext_ref_id_2,
  t0.slug AS slug_3,
  t0.company_name AS company_name_4,
  t0.company_short_name AS company_short_name_5,
  t0.description AS description_6,
  t0.type_other_specify AS type_other_specify_7,
  t0.website_url AS website_url_8,
  t0.linkedin_url AS linkedin_url_9,
  t0.twitter_url AS twitter_url_10,
  t0.street_name AS street_name_11,
  t0.street_number AS street_number_12,
  t0.zip_code AS zip_code_13,
  t0.city AS city_14,
  t0.phone AS phone_15,
  t0.iban AS iban_16,
  t0.bic AS bic_17,
  t0.vat AS vat_18,
  t0.fax AS fax_19,
  t0.is_htt AS is_htt_20,
  t0.htt_automated AS htt_automated_21,
  t0.last_htt_update AS last_htt_update_22,
  t0.htt_automated_scheduling AS htt_automated_scheduling_23,
  t0.htt_automated_montly_day AS htt_automated_montly_day_24,
  t0.htt_automated_quarterly_day AS htt_automated_quarterly_day_25,
  t0.htt_reminder_step AS htt_reminder_step_26,
  t0.is_visible AS is_visible_27,
  t0.is_active AS is_active_28,
  t0.is_deleted AS is_deleted_29,
  t0.created_on AS created_on_30,
  t0.updated_on AS updated_on_31,
  t0.countryId AS countryId_32,
  t0.modelId AS modelId_33,
  t0.logoId AS logoId_34,
  t0.vectorialLogoId AS vectorialLogoId_35,
  t0.created_by_id AS created_by_id_36,
  t0.updated_by_id AS updated_by_id_37
FROM
  issuer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.ext_ref_id AS ext_ref_id_2, t0.slug AS slug_3, t0.company_name AS company_name_4, t0.company_short_name AS company_short_name_5, t0.description AS description_6, t0.type_other_specify AS type_other_specify_7, t0.website_url AS website_url_8, t0.linkedin_url AS linkedin_url_9, t0.twitter_url AS twitter_url_10, t0.street_name AS street_name_11, t0.street_number AS street_number_12, t0.zip_code AS zip_code_13, t0.city AS city_14, t0.phone AS phone_15, t0.iban AS iban_16, t0.bic AS bic_17, t0.vat AS vat_18, t0.fax AS fax_19, t0.is_htt AS is_htt_20, t0.htt_automated AS htt_automated_21, t0.last_htt_update AS last_htt_update_22, t0.htt_automated_scheduling AS htt_automated_scheduling_23, t0.htt_automated_montly_day AS htt_automated_montly_day_24, t0.htt_automated_quarterly_day AS htt_automated_quarterly_day_25, t0.htt_reminder_step AS htt_reminder_step_26, t0.is_visible AS is_visible_27, t0.is_active AS is_active_28, t0.is_deleted AS is_deleted_29, t0.created_on AS created_on_30, t0.updated_on AS updated_on_31, t0.countryId AS countryId_32, t0.modelId AS modelId_33, t0.logoId AS logoId_34, t0.vectorialLogoId AS vectorialLogoId_35, t0.created_by_id AS created_by_id_36, t0.updated_by_id AS updated_by_id_37 FROM issuer t0 WHERE t0.id = 162;

SELECT
  p0_.id AS id_0,
  p0_.ext_ref_id AS ext_ref_id_1,
  p0_.identifier AS identifier_2,
  p0_.url_excel_htt AS url_excel_htt_3,
  p0_.description AS description_4,
  p0_.validation_date AS validation_date_5,
  p0_.is_deleted AS is_deleted_6,
  p0_.has_custom_disclaimer AS has_custom_disclaimer_7,
  p0_.disclaimer_text AS disclaimer_text_8,
  p0_.disclaimer_agree_label AS disclaimer_agree_label_9,
  p0_.disclaimer_decline_label AS disclaimer_decline_label_10,
  p0_.last_htt_parsing_date AS last_htt_parsing_date_11,
  p0_.created_on AS created_on_12,
  p0_.updated_on AS updated_on_13,
  p0_.typeId AS typeId_14,
  p0_.euLabelId AS euLabelId_15,
  p0_.issuerId AS issuerId_16,
  p0_.currencyId AS currencyId_17,
  p0_.modelId AS modelId_18,
  p0_.created_by_id AS created_by_id_19,
  p0_.updated_by_id AS updated_by_id_20
FROM
  poolprogram p0_
  INNER JOIN issuer i1_ ON p0_.issuerId = i1_.id
  LEFT JOIN currency c2_ ON p0_.currencyId = c2_.id
  INNER JOIN country c3_ ON i1_.countryId = c3_.id
WHERE
  p0_.is_deleted = 0
  AND i1_.is_deleted = 0
  AND i1_.is_active = ?
  AND c3_.is_active = ?
  AND i1_.id = ?
ORDER BY
  p0_.identifier ASC

SELECT p0_.id AS id_0, p0_.ext_ref_id AS ext_ref_id_1, p0_.identifier AS identifier_2, p0_.url_excel_htt AS url_excel_htt_3, p0_.description AS description_4, p0_.validation_date AS validation_date_5, p0_.is_deleted AS is_deleted_6, p0_.has_custom_disclaimer AS has_custom_disclaimer_7, p0_.disclaimer_text AS disclaimer_text_8, p0_.disclaimer_agree_label AS disclaimer_agree_label_9, p0_.disclaimer_decline_label AS disclaimer_decline_label_10, p0_.last_htt_parsing_date AS last_htt_parsing_date_11, p0_.created_on AS created_on_12, p0_.updated_on AS updated_on_13, p0_.typeId AS typeId_14, p0_.euLabelId AS euLabelId_15, p0_.issuerId AS issuerId_16, p0_.currencyId AS currencyId_17, p0_.modelId AS modelId_18, p0_.created_by_id AS created_by_id_19, p0_.updated_by_id AS updated_by_id_20 FROM poolprogram p0_ INNER JOIN issuer i1_ ON p0_.issuerId = i1_.id LEFT JOIN currency c2_ ON p0_.currencyId = c2_.id INNER JOIN country c3_ ON i1_.countryId = c3_.id WHERE p0_.is_deleted = 0 AND i1_.is_deleted = 0 AND i1_.is_active = 1 AND c3_.is_active = 1 AND i1_.id = 162 ORDER BY p0_.identifier ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.filename AS filename_3,
  t0.path AS path_4,
  t0.extension AS extension_5,
  t0.exclude_from_library AS exclude_from_library_6,
  t0.onStorage AS onStorage_7,
  t0.created_on AS created_on_8,
  t0.updated_on AS updated_on_9,
  t0.created_by_id AS created_by_id_10,
  t0.updated_by_id AS updated_by_id_11
FROM
  photos t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.filename AS filename_3, t0.path AS path_4, t0.extension AS extension_5, t0.exclude_from_library AS exclude_from_library_6, t0.onStorage AS onStorage_7, t0.created_on AS created_on_8, t0.updated_on AS updated_on_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 FROM photos t0 WHERE t0.id = 219;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.eem_label_committee_member AS eem_label_committee_member_4,
  t0.eem_label_committee_name AS eem_label_committee_name_5,
  t0.eem_label_committee_email AS eem_label_committee_email_6,
  t0.national_coordinator AS national_coordinator_7,
  t0.national_coordinator2 AS national_coordinator2_8,
  t0.website AS website_9,
  t0.website2 AS website2_10,
  t0.contact_name AS contact_name_11,
  t0.contact_email AS contact_email_12,
  t0.contact_email2 AS contact_email2_13,
  t0.national_dtlink AS national_dtlink_14,
  t0.is_active AS is_active_15,
  t0.is_eea AS is_eea_16,
  t0.is_eu AS is_eu_17,
  t0.is_eligible AS is_eligible_18,
  t0.is_harmonised_tt AS is_harmonised_tt_19,
  t0.has_commitee_member AS has_commitee_member_20,
  t0.total_oustanding AS total_oustanding_21,
  t0.total_number_issuers AS total_number_issuers_22,
  t0.compare_database_url AS compare_database_url_23,
  t0.updatedOn AS updatedOn_24,
  t0.updatedById AS updatedById_25,
  t0.statusId AS statusId_26,
  t0.currencyId AS currencyId_27
FROM
  country t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.eem_label_committee_member AS eem_label_committee_member_4, t0.eem_label_committee_name AS eem_label_committee_name_5, t0.eem_label_committee_email AS eem_label_committee_email_6, t0.national_coordinator AS national_coordinator_7, t0.national_coordinator2 AS national_coordinator2_8, t0.website AS website_9, t0.website2 AS website2_10, t0.contact_name AS contact_name_11, t0.contact_email AS contact_email_12, t0.contact_email2 AS contact_email2_13, t0.national_dtlink AS national_dtlink_14, t0.is_active AS is_active_15, t0.is_eea AS is_eea_16, t0.is_eu AS is_eu_17, t0.is_eligible AS is_eligible_18, t0.is_harmonised_tt AS is_harmonised_tt_19, t0.has_commitee_member AS has_commitee_member_20, t0.total_oustanding AS total_oustanding_21, t0.total_number_issuers AS total_number_issuers_22, t0.compare_database_url AS compare_database_url_23, t0.updatedOn AS updatedOn_24, t0.updatedById AS updatedById_25, t0.statusId AS statusId_26, t0.currencyId AS currencyId_27 FROM country t0 WHERE t0.id = 10;

SELECT
  t0.id AS id_1,
  t0.cut_off_date AS cut_off_date_2,
  t0.is_preview AS is_preview_3,
  t0.url_excel AS url_excel_4,
  t0.created_on AS created_on_5,
  t0.updated_on AS updated_on_6,
  t0.poolId AS poolId_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9
FROM
  htt_parsing t0
WHERE
  t0.poolId = ?

SELECT t0.id AS id_1, t0.cut_off_date AS cut_off_date_2, t0.is_preview AS is_preview_3, t0.url_excel AS url_excel_4, t0.created_on AS created_on_5, t0.updated_on AS updated_on_6, t0.poolId AS poolId_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9 FROM htt_parsing t0 WHERE t0.poolId = 199;

SELECT
  t0.id AS id_1,
  t0.cut_off_date AS cut_off_date_2,
  t0.is_preview AS is_preview_3,
  t0.url_excel AS url_excel_4,
  t0.created_on AS created_on_5,
  t0.updated_on AS updated_on_6,
  t0.poolId AS poolId_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9
FROM
  htt_parsing t0
WHERE
  t0.poolId = ?

SELECT t0.id AS id_1, t0.cut_off_date AS cut_off_date_2, t0.is_preview AS is_preview_3, t0.url_excel AS url_excel_4, t0.created_on AS created_on_5, t0.updated_on AS updated_on_6, t0.poolId AS poolId_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9 FROM htt_parsing t0 WHERE t0.poolId = 200;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  htt_parsing_table t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2 FROM htt_parsing_table t0 WHERE t0.name = 'general-data' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  htt_parsing_value_name t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2 FROM htt_parsing_value_name t0 WHERE t0.name = 'reporting-currency' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.string_value AS string_value_3,
  t0.serialized_value AS serialized_value_4,
  t0.created_on AS created_on_5,
  t0.updated_on AS updated_on_6,
  t0.parsingId AS parsingId_7,
  t0.tableId AS tableId_8,
  t0.valueNameId AS valueNameId_9,
  t0.valueTypeId AS valueTypeId_10,
  t0.poolTypeId AS poolTypeId_11,
  t0.created_by_id AS created_by_id_12,
  t0.updated_by_id AS updated_by_id_13
FROM
  htt_parsing_value t0
WHERE
  t0.parsingId = ?
  AND t0.tableId = ?
  AND t0.valueNameId = ?
  AND t0.poolTypeId IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.value AS value_2, t0.string_value AS string_value_3, t0.serialized_value AS serialized_value_4, t0.created_on AS created_on_5, t0.updated_on AS updated_on_6, t0.parsingId AS parsingId_7, t0.tableId AS tableId_8, t0.valueNameId AS valueNameId_9, t0.valueTypeId AS valueTypeId_10, t0.poolTypeId AS poolTypeId_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13 FROM htt_parsing_value t0 WHERE t0.parsingId = 1877 AND t0.tableId = 2 AND t0.valueNameId = 4 AND t0.poolTypeId IS NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  htt_parsing_table t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2 FROM htt_parsing_table t0 WHERE t0.name = 'general-data' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  htt_parsing_value_name t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2 FROM htt_parsing_value_name t0 WHERE t0.name = 'total-cover-assets' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.string_value AS string_value_3,
  t0.serialized_value AS serialized_value_4,
  t0.created_on AS created_on_5,
  t0.updated_on AS updated_on_6,
  t0.parsingId AS parsingId_7,
  t0.tableId AS tableId_8,
  t0.valueNameId AS valueNameId_9,
  t0.valueTypeId AS valueTypeId_10,
  t0.poolTypeId AS poolTypeId_11,
  t0.created_by_id AS created_by_id_12,
  t0.updated_by_id AS updated_by_id_13
FROM
  htt_parsing_value t0
WHERE
  t0.parsingId = ?
  AND t0.tableId = ?
  AND t0.valueNameId = ?
  AND t0.poolTypeId IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.value AS value_2, t0.string_value AS string_value_3, t0.serialized_value AS serialized_value_4, t0.created_on AS created_on_5, t0.updated_on AS updated_on_6, t0.parsingId AS parsingId_7, t0.tableId AS tableId_8, t0.valueNameId AS valueNameId_9, t0.valueTypeId AS valueTypeId_10, t0.poolTypeId AS poolTypeId_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13 FROM htt_parsing_value t0 WHERE t0.parsingId = 1877 AND t0.tableId = 2 AND t0.valueNameId = 5 AND t0.poolTypeId IS NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  htt_parsing_table t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2 FROM htt_parsing_table t0 WHERE t0.name = 'general-data' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  htt_parsing_value_name t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2 FROM htt_parsing_value_name t0 WHERE t0.name = 'total-cover-bonds' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.string_value AS string_value_3,
  t0.serialized_value AS serialized_value_4,
  t0.created_on AS created_on_5,
  t0.updated_on AS updated_on_6,
  t0.parsingId AS parsingId_7,
  t0.tableId AS tableId_8,
  t0.valueNameId AS valueNameId_9,
  t0.valueTypeId AS valueTypeId_10,
  t0.poolTypeId AS poolTypeId_11,
  t0.created_by_id AS created_by_id_12,
  t0.updated_by_id AS updated_by_id_13
FROM
  htt_parsing_value t0
WHERE
  t0.parsingId = ?
  AND t0.tableId = ?
  AND t0.valueNameId = ?
  AND t0.poolTypeId IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.value AS value_2, t0.string_value AS string_value_3, t0.serialized_value AS serialized_value_4, t0.created_on AS created_on_5, t0.updated_on AS updated_on_6, t0.parsingId AS parsingId_7, t0.tableId AS tableId_8, t0.valueNameId AS valueNameId_9, t0.valueTypeId AS valueTypeId_10, t0.poolTypeId AS poolTypeId_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13 FROM htt_parsing_value t0 WHERE t0.parsingId = 1877 AND t0.tableId = 2 AND t0.valueNameId = 6 AND t0.poolTypeId IS NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  htt_parsing_table t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2 FROM htt_parsing_table t0 WHERE t0.name = 'pool-type-availability' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  htt_parsing_value_name t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2 FROM htt_parsing_value_name t0 WHERE t0.name = 'has-shipping' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.string_value AS string_value_3,
  t0.serialized_value AS serialized_value_4,
  t0.created_on AS created_on_5,
  t0.updated_on AS updated_on_6,
  t0.parsingId AS parsingId_7,
  t0.tableId AS tableId_8,
  t0.valueNameId AS valueNameId_9,
  t0.valueTypeId AS valueTypeId_10,
  t0.poolTypeId AS poolTypeId_11,
  t0.created_by_id AS created_by_id_12,
  t0.updated_by_id AS updated_by_id_13
FROM
  htt_parsing_value t0
WHERE
  t0.parsingId = ?
  AND t0.tableId = ?
  AND t0.valueNameId = ?
  AND t0.poolTypeId IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.value AS value_2, t0.string_value AS string_value_3, t0.serialized_value AS serialized_value_4, t0.created_on AS created_on_5, t0.updated_on AS updated_on_6, t0.parsingId AS parsingId_7, t0.tableId AS tableId_8, t0.valueNameId AS valueNameId_9, t0.valueTypeId AS valueTypeId_10, t0.poolTypeId AS poolTypeId_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13 FROM htt_parsing_value t0 WHERE t0.parsingId = 1877 AND t0.tableId = 1 AND t0.valueNameId = 1 AND t0.poolTypeId IS NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  htt_parsing_table t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2 FROM htt_parsing_table t0 WHERE t0.name = 'pool-type-availability' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  htt_parsing_value_name t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2 FROM htt_parsing_value_name t0 WHERE t0.name = 'has-mortgage' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.string_value AS string_value_3,
  t0.serialized_value AS serialized_value_4,
  t0.created_on AS created_on_5,
  t0.updated_on AS updated_on_6,
  t0.parsingId AS parsingId_7,
  t0.tableId AS tableId_8,
  t0.valueNameId AS valueNameId_9,
  t0.valueTypeId AS valueTypeId_10,
  t0.poolTypeId AS poolTypeId_11,
  t0.created_by_id AS created_by_id_12,
  t0.updated_by_id AS updated_by_id_13
FROM
  htt_parsing_value t0
WHERE
  t0.parsingId = ?
  AND t0.tableId = ?
  AND t0.valueNameId = ?
  AND t0.poolTypeId IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.value AS value_2, t0.string_value AS string_value_3, t0.serialized_value AS serialized_value_4, t0.created_on AS created_on_5, t0.updated_on AS updated_on_6, t0.parsingId AS parsingId_7, t0.tableId AS tableId_8, t0.valueNameId AS valueNameId_9, t0.valueTypeId AS valueTypeId_10, t0.poolTypeId AS poolTypeId_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13 FROM htt_parsing_value t0 WHERE t0.parsingId = 1877 AND t0.tableId = 1 AND t0.valueNameId = 2 AND t0.poolTypeId IS NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  htt_parsing_table t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2 FROM htt_parsing_table t0 WHERE t0.name = 'pool-type-availability' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  htt_parsing_value_name t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2 FROM htt_parsing_value_name t0 WHERE t0.name = 'has-public' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.string_value AS string_value_3,
  t0.serialized_value AS serialized_value_4,
  t0.created_on AS created_on_5,
  t0.updated_on AS updated_on_6,
  t0.parsingId AS parsingId_7,
  t0.tableId AS tableId_8,
  t0.valueNameId AS valueNameId_9,
  t0.valueTypeId AS valueTypeId_10,
  t0.poolTypeId AS poolTypeId_11,
  t0.created_by_id AS created_by_id_12,
  t0.updated_by_id AS updated_by_id_13
FROM
  htt_parsing_value t0
WHERE
  t0.parsingId = ?
  AND t0.tableId = ?
  AND t0.valueNameId = ?
  AND t0.poolTypeId IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.value AS value_2, t0.string_value AS string_value_3, t0.serialized_value AS serialized_value_4, t0.created_on AS created_on_5, t0.updated_on AS updated_on_6, t0.parsingId AS parsingId_7, t0.tableId AS tableId_8, t0.valueNameId AS valueNameId_9, t0.valueTypeId AS valueTypeId_10, t0.poolTypeId AS poolTypeId_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13 FROM htt_parsing_value t0 WHERE t0.parsingId = 1877 AND t0.tableId = 1 AND t0.valueNameId = 3 AND t0.poolTypeId IS NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.display_order AS display_order_4
FROM
  poolprogram_type t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.display_order AS display_order_4 FROM poolprogram_type t0 WHERE t0.name = 'mortgage' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  htt_parsing_table t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2 FROM htt_parsing_table t0 WHERE t0.name = 'property-type-information' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  htt_parsing_value_name t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2 FROM htt_parsing_value_name t0 WHERE t0.name = 'residential' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.string_value AS string_value_3,
  t0.serialized_value AS serialized_value_4,
  t0.created_on AS created_on_5,
  t0.updated_on AS updated_on_6,
  t0.parsingId AS parsingId_7,
  t0.tableId AS tableId_8,
  t0.valueNameId AS valueNameId_9,
  t0.valueTypeId AS valueTypeId_10,
  t0.poolTypeId AS poolTypeId_11,
  t0.created_by_id AS created_by_id_12,
  t0.updated_by_id AS updated_by_id_13
FROM
  htt_parsing_value t0
WHERE
  t0.parsingId = ?
  AND t0.tableId = ?
  AND t0.valueNameId = ?
  AND t0.poolTypeId = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.value AS value_2, t0.string_value AS string_value_3, t0.serialized_value AS serialized_value_4, t0.created_on AS created_on_5, t0.updated_on AS updated_on_6, t0.parsingId AS parsingId_7, t0.tableId AS tableId_8, t0.valueNameId AS valueNameId_9, t0.valueTypeId AS valueTypeId_10, t0.poolTypeId AS poolTypeId_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13 FROM htt_parsing_value t0 WHERE t0.parsingId = 1877 AND t0.tableId = 23 AND t0.valueNameId = 46 AND t0.poolTypeId = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.display_order AS display_order_4
FROM
  poolprogram_type t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.display_order AS display_order_4 FROM poolprogram_type t0 WHERE t0.name = 'mortgage' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  htt_parsing_table t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2 FROM htt_parsing_table t0 WHERE t0.name = 'property-type-information' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  htt_parsing_value_name t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2 FROM htt_parsing_value_name t0 WHERE t0.name = 'commercial' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.string_value AS string_value_3,
  t0.serialized_value AS serialized_value_4,
  t0.created_on AS created_on_5,
  t0.updated_on AS updated_on_6,
  t0.parsingId AS parsingId_7,
  t0.tableId AS tableId_8,
  t0.valueNameId AS valueNameId_9,
  t0.valueTypeId AS valueTypeId_10,
  t0.poolTypeId AS poolTypeId_11,
  t0.created_by_id AS created_by_id_12,
  t0.updated_by_id AS updated_by_id_13
FROM
  htt_parsing_value t0
WHERE
  t0.parsingId = ?
  AND t0.tableId = ?
  AND t0.valueNameId = ?
  AND t0.poolTypeId = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.value AS value_2, t0.string_value AS string_value_3, t0.serialized_value AS serialized_value_4, t0.created_on AS created_on_5, t0.updated_on AS updated_on_6, t0.parsingId AS parsingId_7, t0.tableId AS tableId_8, t0.valueNameId AS valueNameId_9, t0.valueTypeId AS valueTypeId_10, t0.poolTypeId AS poolTypeId_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13 FROM htt_parsing_value t0 WHERE t0.parsingId = 1877 AND t0.tableId = 23 AND t0.valueNameId = 47 AND t0.poolTypeId = 1 LIMIT 1;