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 = '1611' 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 = 178;

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

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 = 1611 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 = 1611 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 = 1611 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 = 'geographic-breakdown-international' 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-value' 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 = 1611 AND t0.tableId = 16 AND t0.valueNameId = 29 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 = 'breakdown-by-interest-rate' 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-value' 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 = 1611 AND t0.tableId = 7 AND t0.valueNameId = 29 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 = 'breakdown-by-repayment-type' 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-value' 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 = 1611 AND t0.tableId = 9 AND t0.valueNameId = 29 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 = 'loan-seasoning-bar' 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-value' 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 = 1611 AND t0.tableId = 10 AND t0.valueNameId = 29 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 = 'loan-size-information-residential' 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-value' 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 = 1611 AND t0.tableId = 11 AND t0.valueNameId = 29 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 = 'ltv-distribution-indexed' 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-value' 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 = 1611 AND t0.tableId = 12 AND t0.valueNameId = 29 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 = 'type-of-tenure-residential' 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-value' 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 = 1611 AND t0.tableId = 14 AND t0.valueNameId = 29 AND t0.poolTypeId = 1 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;