Symfony Profiler

SELECT
  COUNT(l0_.id) AS sclr_0
FROM
  leads l0_
WHERE
  l0_.user_ip = ?
  AND l0_.created_at >= ?

SELECT COUNT(l0_.id) AS sclr_0 FROM leads l0_ WHERE l0_.user_ip = '192.168.5.202' AND l0_.created_at >= '2024-09-28 21:16:50';

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.category AS category_4,
  t0.pending_photos_status AS pending_photos_status_5,
  t0.pending_payment_status AS pending_payment_status_6,
  t0.relist_status AS relist_status_7,
  t0.seller_role AS seller_role_8,
  t0.area AS area_9,
  t0.price AS price_10,
  t0.address AS address_11,
  t0.center_lat AS center_lat_12,
  t0.center_lng AS center_lng_13,
  t0.status AS status_14,
  t0.property_view AS property_view_15,
  t0.payment_method AS payment_method_16,
  t0.featured AS featured_17,
  t0.views AS views_18,
  t0.phone_counter AS phone_counter_19,
  t0.messages_counter AS messages_counter_20,
  t0.leads_counter AS leads_counter_21,
  t0.sent_notifiers AS sent_notifiers_22,
  t0.relist_counter AS relist_counter_23,
  t0.ip AS ip_24,
  t0.video_url AS video_url_25,
  t0.slug AS slug_26,
  t0.custom_slug AS custom_slug_27,
  t0.score AS score_28,
  t0.created_at AS created_at_29,
  t0.updated_at AS updated_at_30,
  t0.pending_status_created_at AS pending_status_created_at_31,
  t0.published_at AS published_at_32,
  t0.expires_at AS expires_at_33,
  t0.deleted_at AS deleted_at_34,
  t0.rejected_at AS rejected_at_35,
  t0.campaign AS campaign_36,
  t0.final_price AS final_price_37,
  t0.source_of_sale AS source_of_sale_38,
  t0.delete_reason AS delete_reason_39,
  t0.delete_reason_details AS delete_reason_details_40,
  t0.source AS source_41,
  t0.impressions AS impressions_42,
  t0.impressions_monthly_count AS impressions_monthly_count_43,
  t0.impressions_weekly_count AS impressions_weekly_count_44,
  t0.impression_updated_at AS impression_updated_at_45,
  t0.price_level AS price_level_46,
  t0.compound_status AS compound_status_47,
  t0.price_per_meter AS price_per_meter_48,
  t0.is_bumped AS is_bumped_49,
  t0.is_send_email AS is_send_email_50,
  t0.market_property_type AS market_property_type_51,
  t0.creation_source AS creation_source_52,
  t0.click_through_rate AS click_through_rate_53,
  t0.label AS label_54,
  t0.is_top_picks AS is_top_picks_55,
  t0.contact_rate AS contact_rate_56,
  t0.synced AS synced_57,
  t0.reference_id AS reference_id_58,
  t0.is_pending_featuring AS is_pending_featuring_59,
  t0.pending_featuring_type AS pending_featuring_type_60,
  t0.rate_status AS rate_status_61,
  t0.is_rate_reviewed AS is_rate_reviewed_62,
  t0.is_call_request AS is_call_request_63,
  t0.is_shown_in_homepage AS is_shown_in_homepage_64,
  t0.is_commercial AS is_commercial_65,
  t0.is_resale AS is_resale_66,
  t0.is_rent AS is_rent_67,
  t0.is_primary AS is_primary_68,
  t0.is_mortgage_approved AS is_mortgage_approved_69,
  t0.meta_title AS meta_title_70,
  t0.meta_description AS meta_description_71,
  t0.is_mortgage AS is_mortgage_72,
  t0.eligible_for_mortgage AS eligible_for_mortgage_73,
  t0.property_registration_status AS property_registration_status_74,
  t0.advertiser_number AS advertiser_number_75,
  t0.authorization_number AS authorization_number_76,
  t0.freezed_at AS freezed_at_77,
  t0.eligible_for_bumpup AS eligible_for_bumpup_78,
  t0.waiting_time AS waiting_time_79,
  t0.reference_number AS reference_number_80,
  t0.parent_id AS parent_id_81,
  t0.relist_id AS relist_id_82,
  t0.section_id AS section_id_83,
  t0.property_type_id AS property_type_id_84,
  t0.location_id AS location_id_85,
  t0.compound_location_id AS compound_location_id_86,
  t0.user_id AS user_id_87,
  t0.compound_field_id AS compound_field_id_88
FROM
  listings t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.category AS category_4, t0.pending_photos_status AS pending_photos_status_5, t0.pending_payment_status AS pending_payment_status_6, t0.relist_status AS relist_status_7, t0.seller_role AS seller_role_8, t0.area AS area_9, t0.price AS price_10, t0.address AS address_11, t0.center_lat AS center_lat_12, t0.center_lng AS center_lng_13, t0.status AS status_14, t0.property_view AS property_view_15, t0.payment_method AS payment_method_16, t0.featured AS featured_17, t0.views AS views_18, t0.phone_counter AS phone_counter_19, t0.messages_counter AS messages_counter_20, t0.leads_counter AS leads_counter_21, t0.sent_notifiers AS sent_notifiers_22, t0.relist_counter AS relist_counter_23, t0.ip AS ip_24, t0.video_url AS video_url_25, t0.slug AS slug_26, t0.custom_slug AS custom_slug_27, t0.score AS score_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.pending_status_created_at AS pending_status_created_at_31, t0.published_at AS published_at_32, t0.expires_at AS expires_at_33, t0.deleted_at AS deleted_at_34, t0.rejected_at AS rejected_at_35, t0.campaign AS campaign_36, t0.final_price AS final_price_37, t0.source_of_sale AS source_of_sale_38, t0.delete_reason AS delete_reason_39, t0.delete_reason_details AS delete_reason_details_40, t0.source AS source_41, t0.impressions AS impressions_42, t0.impressions_monthly_count AS impressions_monthly_count_43, t0.impressions_weekly_count AS impressions_weekly_count_44, t0.impression_updated_at AS impression_updated_at_45, t0.price_level AS price_level_46, t0.compound_status AS compound_status_47, t0.price_per_meter AS price_per_meter_48, t0.is_bumped AS is_bumped_49, t0.is_send_email AS is_send_email_50, t0.market_property_type AS market_property_type_51, t0.creation_source AS creation_source_52, t0.click_through_rate AS click_through_rate_53, t0.label AS label_54, t0.is_top_picks AS is_top_picks_55, t0.contact_rate AS contact_rate_56, t0.synced AS synced_57, t0.reference_id AS reference_id_58, t0.is_pending_featuring AS is_pending_featuring_59, t0.pending_featuring_type AS pending_featuring_type_60, t0.rate_status AS rate_status_61, t0.is_rate_reviewed AS is_rate_reviewed_62, t0.is_call_request AS is_call_request_63, t0.is_shown_in_homepage AS is_shown_in_homepage_64, t0.is_commercial AS is_commercial_65, t0.is_resale AS is_resale_66, t0.is_rent AS is_rent_67, t0.is_primary AS is_primary_68, t0.is_mortgage_approved AS is_mortgage_approved_69, t0.meta_title AS meta_title_70, t0.meta_description AS meta_description_71, t0.is_mortgage AS is_mortgage_72, t0.eligible_for_mortgage AS eligible_for_mortgage_73, t0.property_registration_status AS property_registration_status_74, t0.advertiser_number AS advertiser_number_75, t0.authorization_number AS authorization_number_76, t0.freezed_at AS freezed_at_77, t0.eligible_for_bumpup AS eligible_for_bumpup_78, t0.waiting_time AS waiting_time_79, t0.reference_number AS reference_number_80, t0.parent_id AS parent_id_81, t0.relist_id AS relist_id_82, t0.section_id AS section_id_83, t0.property_type_id AS property_type_id_84, t0.location_id AS location_id_85, t0.compound_location_id AS compound_location_id_86, t0.user_id AS user_id_87, t0.compound_field_id AS compound_field_id_88 FROM listings t0 WHERE t0.id = '430';

SELECT
  i0_.id AS id_0,
  i0_.type AS type_1,
  i0_.user_ip AS user_ip_2,
  i0_.created_at AS created_at_3,
  i0_.source AS source_4,
  i0_.campaign AS campaign_5,
  i0_.user_id AS user_id_6,
  i0_.listing_id AS listing_id_7
FROM
  interactions i0_
WHERE
  i0_.listing_id = ?
  AND i0_.type = ?
  AND i0_.user_ip = ?
  AND i0_.created_at >= ?
ORDER BY
  i0_.id DESC
LIMIT
  1

SELECT i0_.id AS id_0, i0_.type AS type_1, i0_.user_ip AS user_ip_2, i0_.created_at AS created_at_3, i0_.source AS source_4, i0_.campaign AS campaign_5, i0_.user_id AS user_id_6, i0_.listing_id AS listing_id_7 FROM interactions i0_ WHERE i0_.listing_id = 430 AND i0_.type = 4 AND i0_.user_ip = '192.168.5.202' AND i0_.created_at >= '2024-09-26 21:31:50' ORDER BY i0_.id DESC LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO interactions (
  TYPE, user_ip, created_at, source,
  campaign, user_id, listing_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO interactions (TYPE, user_ip, created_at, source, campaign, user_id, listing_id) VALUES (4, '192.168.5.202', '2024-09-28 21:31:50', 'interaction-service', NULL, NULL, 430);

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  listings
SET
  views = ?
WHERE
  id = ?

UPDATE listings SET views = 26 WHERE id = 430;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.listing_id AS listing_id_3,
  t0.custome_field_id AS custome_field_id_4
FROM
  listings_attributes t0
WHERE
  t0.listing_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.listing_id AS listing_id_3, t0.custome_field_id AS custome_field_id_4 FROM listings_attributes t0 WHERE t0.listing_id = 430;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.created_at AS created_at_3,
  t0.expires_at AS expires_at_4,
  t0.approved_at AS approved_at_5,
  t0.bump_up_duration AS bump_up_duration_6,
  t0.bump_up_occurrences AS bump_up_occurrences_7,
  t0.bumps_count AS bumps_count_8,
  t0.last_bumped_at AS last_bumped_at_9,
  t0.paused_at AS paused_at_10,
  t0.processed AS processed_11,
  t0.leads_count_snapshot AS leads_count_snapshot_12,
  t0.next_bump_date AS next_bump_date_13,
  t0.featuring_status AS featuring_status_14,
  t0.listing_id AS listing_id_15,
  t16.id AS id_17,
  t16.title AS title_18,
  t16.description AS description_19,
  t16.category AS category_20,
  t16.pending_photos_status AS pending_photos_status_21,
  t16.pending_payment_status AS pending_payment_status_22,
  t16.relist_status AS relist_status_23,
  t16.seller_role AS seller_role_24,
  t16.area AS area_25,
  t16.price AS price_26,
  t16.address AS address_27,
  t16.center_lat AS center_lat_28,
  t16.center_lng AS center_lng_29,
  t16.status AS status_30,
  t16.property_view AS property_view_31,
  t16.payment_method AS payment_method_32,
  t16.featured AS featured_33,
  t16.views AS views_34,
  t16.phone_counter AS phone_counter_35,
  t16.messages_counter AS messages_counter_36,
  t16.leads_counter AS leads_counter_37,
  t16.sent_notifiers AS sent_notifiers_38,
  t16.relist_counter AS relist_counter_39,
  t16.ip AS ip_40,
  t16.video_url AS video_url_41,
  t16.slug AS slug_42,
  t16.custom_slug AS custom_slug_43,
  t16.score AS score_44,
  t16.created_at AS created_at_45,
  t16.updated_at AS updated_at_46,
  t16.pending_status_created_at AS pending_status_created_at_47,
  t16.published_at AS published_at_48,
  t16.expires_at AS expires_at_49,
  t16.deleted_at AS deleted_at_50,
  t16.rejected_at AS rejected_at_51,
  t16.campaign AS campaign_52,
  t16.final_price AS final_price_53,
  t16.source_of_sale AS source_of_sale_54,
  t16.delete_reason AS delete_reason_55,
  t16.delete_reason_details AS delete_reason_details_56,
  t16.source AS source_57,
  t16.impressions AS impressions_58,
  t16.impressions_monthly_count AS impressions_monthly_count_59,
  t16.impressions_weekly_count AS impressions_weekly_count_60,
  t16.impression_updated_at AS impression_updated_at_61,
  t16.price_level AS price_level_62,
  t16.compound_status AS compound_status_63,
  t16.price_per_meter AS price_per_meter_64,
  t16.is_bumped AS is_bumped_65,
  t16.is_send_email AS is_send_email_66,
  t16.market_property_type AS market_property_type_67,
  t16.creation_source AS creation_source_68,
  t16.click_through_rate AS click_through_rate_69,
  t16.label AS label_70,
  t16.is_top_picks AS is_top_picks_71,
  t16.contact_rate AS contact_rate_72,
  t16.synced AS synced_73,
  t16.reference_id AS reference_id_74,
  t16.is_pending_featuring AS is_pending_featuring_75,
  t16.pending_featuring_type AS pending_featuring_type_76,
  t16.rate_status AS rate_status_77,
  t16.is_rate_reviewed AS is_rate_reviewed_78,
  t16.is_call_request AS is_call_request_79,
  t16.is_shown_in_homepage AS is_shown_in_homepage_80,
  t16.is_commercial AS is_commercial_81,
  t16.is_resale AS is_resale_82,
  t16.is_rent AS is_rent_83,
  t16.is_primary AS is_primary_84,
  t16.is_mortgage_approved AS is_mortgage_approved_85,
  t16.meta_title AS meta_title_86,
  t16.meta_description AS meta_description_87,
  t16.is_mortgage AS is_mortgage_88,
  t16.eligible_for_mortgage AS eligible_for_mortgage_89,
  t16.property_registration_status AS property_registration_status_90,
  t16.advertiser_number AS advertiser_number_91,
  t16.authorization_number AS authorization_number_92,
  t16.freezed_at AS freezed_at_93,
  t16.eligible_for_bumpup AS eligible_for_bumpup_94,
  t16.waiting_time AS waiting_time_95,
  t16.reference_number AS reference_number_96,
  t16.parent_id AS parent_id_97,
  t16.relist_id AS relist_id_98,
  t16.section_id AS section_id_99,
  t16.property_type_id AS property_type_id_100,
  t16.location_id AS location_id_101,
  t16.compound_location_id AS compound_location_id_102,
  t16.user_id AS user_id_103,
  t16.compound_field_id AS compound_field_id_104,
  t0.credit_id AS credit_id_105,
  t0.bump_up_owner_id AS bump_up_owner_id_106
FROM
  listings_features t0
  INNER JOIN listings t16 ON t0.listing_id = t16.id
WHERE
  (
    (
      (
        t0.type = ?
        AND t0.expires_at >= ?
      )
      OR t0.expires_at IS NULL
    )
    AND t0.listing_id = ?
  )
ORDER BY
  t0.id DESC

SELECT t0.id AS id_1, t0.type AS type_2, t0.created_at AS created_at_3, t0.expires_at AS expires_at_4, t0.approved_at AS approved_at_5, t0.bump_up_duration AS bump_up_duration_6, t0.bump_up_occurrences AS bump_up_occurrences_7, t0.bumps_count AS bumps_count_8, t0.last_bumped_at AS last_bumped_at_9, t0.paused_at AS paused_at_10, t0.processed AS processed_11, t0.leads_count_snapshot AS leads_count_snapshot_12, t0.next_bump_date AS next_bump_date_13, t0.featuring_status AS featuring_status_14, t0.listing_id AS listing_id_15, t16.id AS id_17, t16.title AS title_18, t16.description AS description_19, t16.category AS category_20, t16.pending_photos_status AS pending_photos_status_21, t16.pending_payment_status AS pending_payment_status_22, t16.relist_status AS relist_status_23, t16.seller_role AS seller_role_24, t16.area AS area_25, t16.price AS price_26, t16.address AS address_27, t16.center_lat AS center_lat_28, t16.center_lng AS center_lng_29, t16.status AS status_30, t16.property_view AS property_view_31, t16.payment_method AS payment_method_32, t16.featured AS featured_33, t16.views AS views_34, t16.phone_counter AS phone_counter_35, t16.messages_counter AS messages_counter_36, t16.leads_counter AS leads_counter_37, t16.sent_notifiers AS sent_notifiers_38, t16.relist_counter AS relist_counter_39, t16.ip AS ip_40, t16.video_url AS video_url_41, t16.slug AS slug_42, t16.custom_slug AS custom_slug_43, t16.score AS score_44, t16.created_at AS created_at_45, t16.updated_at AS updated_at_46, t16.pending_status_created_at AS pending_status_created_at_47, t16.published_at AS published_at_48, t16.expires_at AS expires_at_49, t16.deleted_at AS deleted_at_50, t16.rejected_at AS rejected_at_51, t16.campaign AS campaign_52, t16.final_price AS final_price_53, t16.source_of_sale AS source_of_sale_54, t16.delete_reason AS delete_reason_55, t16.delete_reason_details AS delete_reason_details_56, t16.source AS source_57, t16.impressions AS impressions_58, t16.impressions_monthly_count AS impressions_monthly_count_59, t16.impressions_weekly_count AS impressions_weekly_count_60, t16.impression_updated_at AS impression_updated_at_61, t16.price_level AS price_level_62, t16.compound_status AS compound_status_63, t16.price_per_meter AS price_per_meter_64, t16.is_bumped AS is_bumped_65, t16.is_send_email AS is_send_email_66, t16.market_property_type AS market_property_type_67, t16.creation_source AS creation_source_68, t16.click_through_rate AS click_through_rate_69, t16.label AS label_70, t16.is_top_picks AS is_top_picks_71, t16.contact_rate AS contact_rate_72, t16.synced AS synced_73, t16.reference_id AS reference_id_74, t16.is_pending_featuring AS is_pending_featuring_75, t16.pending_featuring_type AS pending_featuring_type_76, t16.rate_status AS rate_status_77, t16.is_rate_reviewed AS is_rate_reviewed_78, t16.is_call_request AS is_call_request_79, t16.is_shown_in_homepage AS is_shown_in_homepage_80, t16.is_commercial AS is_commercial_81, t16.is_resale AS is_resale_82, t16.is_rent AS is_rent_83, t16.is_primary AS is_primary_84, t16.is_mortgage_approved AS is_mortgage_approved_85, t16.meta_title AS meta_title_86, t16.meta_description AS meta_description_87, t16.is_mortgage AS is_mortgage_88, t16.eligible_for_mortgage AS eligible_for_mortgage_89, t16.property_registration_status AS property_registration_status_90, t16.advertiser_number AS advertiser_number_91, t16.authorization_number AS authorization_number_92, t16.freezed_at AS freezed_at_93, t16.eligible_for_bumpup AS eligible_for_bumpup_94, t16.waiting_time AS waiting_time_95, t16.reference_number AS reference_number_96, t16.parent_id AS parent_id_97, t16.relist_id AS relist_id_98, t16.section_id AS section_id_99, t16.property_type_id AS property_type_id_100, t16.location_id AS location_id_101, t16.compound_location_id AS compound_location_id_102, t16.user_id AS user_id_103, t16.compound_field_id AS compound_field_id_104, t0.credit_id AS credit_id_105, t0.bump_up_owner_id AS bump_up_owner_id_106 FROM listings_features t0 INNER JOIN listings t16 ON t0.listing_id = t16.id WHERE (((t0.type = 3 AND t0.expires_at >= '2024-09-28 21:31:50') OR t0.expires_at IS NULL) AND t0.listing_id = 430) ORDER BY t0.id DESC;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.created_at AS created_at_3,
  t0.expires_at AS expires_at_4,
  t0.approved_at AS approved_at_5,
  t0.bump_up_duration AS bump_up_duration_6,
  t0.bump_up_occurrences AS bump_up_occurrences_7,
  t0.bumps_count AS bumps_count_8,
  t0.last_bumped_at AS last_bumped_at_9,
  t0.paused_at AS paused_at_10,
  t0.processed AS processed_11,
  t0.leads_count_snapshot AS leads_count_snapshot_12,
  t0.next_bump_date AS next_bump_date_13,
  t0.featuring_status AS featuring_status_14,
  t0.listing_id AS listing_id_15,
  t16.id AS id_17,
  t16.title AS title_18,
  t16.description AS description_19,
  t16.category AS category_20,
  t16.pending_photos_status AS pending_photos_status_21,
  t16.pending_payment_status AS pending_payment_status_22,
  t16.relist_status AS relist_status_23,
  t16.seller_role AS seller_role_24,
  t16.area AS area_25,
  t16.price AS price_26,
  t16.address AS address_27,
  t16.center_lat AS center_lat_28,
  t16.center_lng AS center_lng_29,
  t16.status AS status_30,
  t16.property_view AS property_view_31,
  t16.payment_method AS payment_method_32,
  t16.featured AS featured_33,
  t16.views AS views_34,
  t16.phone_counter AS phone_counter_35,
  t16.messages_counter AS messages_counter_36,
  t16.leads_counter AS leads_counter_37,
  t16.sent_notifiers AS sent_notifiers_38,
  t16.relist_counter AS relist_counter_39,
  t16.ip AS ip_40,
  t16.video_url AS video_url_41,
  t16.slug AS slug_42,
  t16.custom_slug AS custom_slug_43,
  t16.score AS score_44,
  t16.created_at AS created_at_45,
  t16.updated_at AS updated_at_46,
  t16.pending_status_created_at AS pending_status_created_at_47,
  t16.published_at AS published_at_48,
  t16.expires_at AS expires_at_49,
  t16.deleted_at AS deleted_at_50,
  t16.rejected_at AS rejected_at_51,
  t16.campaign AS campaign_52,
  t16.final_price AS final_price_53,
  t16.source_of_sale AS source_of_sale_54,
  t16.delete_reason AS delete_reason_55,
  t16.delete_reason_details AS delete_reason_details_56,
  t16.source AS source_57,
  t16.impressions AS impressions_58,
  t16.impressions_monthly_count AS impressions_monthly_count_59,
  t16.impressions_weekly_count AS impressions_weekly_count_60,
  t16.impression_updated_at AS impression_updated_at_61,
  t16.price_level AS price_level_62,
  t16.compound_status AS compound_status_63,
  t16.price_per_meter AS price_per_meter_64,
  t16.is_bumped AS is_bumped_65,
  t16.is_send_email AS is_send_email_66,
  t16.market_property_type AS market_property_type_67,
  t16.creation_source AS creation_source_68,
  t16.click_through_rate AS click_through_rate_69,
  t16.label AS label_70,
  t16.is_top_picks AS is_top_picks_71,
  t16.contact_rate AS contact_rate_72,
  t16.synced AS synced_73,
  t16.reference_id AS reference_id_74,
  t16.is_pending_featuring AS is_pending_featuring_75,
  t16.pending_featuring_type AS pending_featuring_type_76,
  t16.rate_status AS rate_status_77,
  t16.is_rate_reviewed AS is_rate_reviewed_78,
  t16.is_call_request AS is_call_request_79,
  t16.is_shown_in_homepage AS is_shown_in_homepage_80,
  t16.is_commercial AS is_commercial_81,
  t16.is_resale AS is_resale_82,
  t16.is_rent AS is_rent_83,
  t16.is_primary AS is_primary_84,
  t16.is_mortgage_approved AS is_mortgage_approved_85,
  t16.meta_title AS meta_title_86,
  t16.meta_description AS meta_description_87,
  t16.is_mortgage AS is_mortgage_88,
  t16.eligible_for_mortgage AS eligible_for_mortgage_89,
  t16.property_registration_status AS property_registration_status_90,
  t16.advertiser_number AS advertiser_number_91,
  t16.authorization_number AS authorization_number_92,
  t16.freezed_at AS freezed_at_93,
  t16.eligible_for_bumpup AS eligible_for_bumpup_94,
  t16.waiting_time AS waiting_time_95,
  t16.reference_number AS reference_number_96,
  t16.parent_id AS parent_id_97,
  t16.relist_id AS relist_id_98,
  t16.section_id AS section_id_99,
  t16.property_type_id AS property_type_id_100,
  t16.location_id AS location_id_101,
  t16.compound_location_id AS compound_location_id_102,
  t16.user_id AS user_id_103,
  t16.compound_field_id AS compound_field_id_104,
  t0.credit_id AS credit_id_105,
  t0.bump_up_owner_id AS bump_up_owner_id_106
FROM
  listings_features t0
  INNER JOIN listings t16 ON t0.listing_id = t16.id
WHERE
  (
    (
      t0.type != ?
      AND t0.type != ?
    )
    AND t0.listing_id = ?
  )
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.created_at AS created_at_3, t0.expires_at AS expires_at_4, t0.approved_at AS approved_at_5, t0.bump_up_duration AS bump_up_duration_6, t0.bump_up_occurrences AS bump_up_occurrences_7, t0.bumps_count AS bumps_count_8, t0.last_bumped_at AS last_bumped_at_9, t0.paused_at AS paused_at_10, t0.processed AS processed_11, t0.leads_count_snapshot AS leads_count_snapshot_12, t0.next_bump_date AS next_bump_date_13, t0.featuring_status AS featuring_status_14, t0.listing_id AS listing_id_15, t16.id AS id_17, t16.title AS title_18, t16.description AS description_19, t16.category AS category_20, t16.pending_photos_status AS pending_photos_status_21, t16.pending_payment_status AS pending_payment_status_22, t16.relist_status AS relist_status_23, t16.seller_role AS seller_role_24, t16.area AS area_25, t16.price AS price_26, t16.address AS address_27, t16.center_lat AS center_lat_28, t16.center_lng AS center_lng_29, t16.status AS status_30, t16.property_view AS property_view_31, t16.payment_method AS payment_method_32, t16.featured AS featured_33, t16.views AS views_34, t16.phone_counter AS phone_counter_35, t16.messages_counter AS messages_counter_36, t16.leads_counter AS leads_counter_37, t16.sent_notifiers AS sent_notifiers_38, t16.relist_counter AS relist_counter_39, t16.ip AS ip_40, t16.video_url AS video_url_41, t16.slug AS slug_42, t16.custom_slug AS custom_slug_43, t16.score AS score_44, t16.created_at AS created_at_45, t16.updated_at AS updated_at_46, t16.pending_status_created_at AS pending_status_created_at_47, t16.published_at AS published_at_48, t16.expires_at AS expires_at_49, t16.deleted_at AS deleted_at_50, t16.rejected_at AS rejected_at_51, t16.campaign AS campaign_52, t16.final_price AS final_price_53, t16.source_of_sale AS source_of_sale_54, t16.delete_reason AS delete_reason_55, t16.delete_reason_details AS delete_reason_details_56, t16.source AS source_57, t16.impressions AS impressions_58, t16.impressions_monthly_count AS impressions_monthly_count_59, t16.impressions_weekly_count AS impressions_weekly_count_60, t16.impression_updated_at AS impression_updated_at_61, t16.price_level AS price_level_62, t16.compound_status AS compound_status_63, t16.price_per_meter AS price_per_meter_64, t16.is_bumped AS is_bumped_65, t16.is_send_email AS is_send_email_66, t16.market_property_type AS market_property_type_67, t16.creation_source AS creation_source_68, t16.click_through_rate AS click_through_rate_69, t16.label AS label_70, t16.is_top_picks AS is_top_picks_71, t16.contact_rate AS contact_rate_72, t16.synced AS synced_73, t16.reference_id AS reference_id_74, t16.is_pending_featuring AS is_pending_featuring_75, t16.pending_featuring_type AS pending_featuring_type_76, t16.rate_status AS rate_status_77, t16.is_rate_reviewed AS is_rate_reviewed_78, t16.is_call_request AS is_call_request_79, t16.is_shown_in_homepage AS is_shown_in_homepage_80, t16.is_commercial AS is_commercial_81, t16.is_resale AS is_resale_82, t16.is_rent AS is_rent_83, t16.is_primary AS is_primary_84, t16.is_mortgage_approved AS is_mortgage_approved_85, t16.meta_title AS meta_title_86, t16.meta_description AS meta_description_87, t16.is_mortgage AS is_mortgage_88, t16.eligible_for_mortgage AS eligible_for_mortgage_89, t16.property_registration_status AS property_registration_status_90, t16.advertiser_number AS advertiser_number_91, t16.authorization_number AS authorization_number_92, t16.freezed_at AS freezed_at_93, t16.eligible_for_bumpup AS eligible_for_bumpup_94, t16.waiting_time AS waiting_time_95, t16.reference_number AS reference_number_96, t16.parent_id AS parent_id_97, t16.relist_id AS relist_id_98, t16.section_id AS section_id_99, t16.property_type_id AS property_type_id_100, t16.location_id AS location_id_101, t16.compound_location_id AS compound_location_id_102, t16.user_id AS user_id_103, t16.compound_field_id AS compound_field_id_104, t0.credit_id AS credit_id_105, t0.bump_up_owner_id AS bump_up_owner_id_106 FROM listings_features t0 INNER JOIN listings t16 ON t0.listing_id = t16.id WHERE ((t0.type != 1 AND t0.type != 3) AND t0.listing_id = 430) ORDER BY t0.id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.created_at AS created_at_3,
  t0.expires_at AS expires_at_4,
  t0.approved_at AS approved_at_5,
  t0.bump_up_duration AS bump_up_duration_6,
  t0.bump_up_occurrences AS bump_up_occurrences_7,
  t0.bumps_count AS bumps_count_8,
  t0.last_bumped_at AS last_bumped_at_9,
  t0.paused_at AS paused_at_10,
  t0.processed AS processed_11,
  t0.leads_count_snapshot AS leads_count_snapshot_12,
  t0.next_bump_date AS next_bump_date_13,
  t0.featuring_status AS featuring_status_14,
  t0.listing_id AS listing_id_15,
  t16.id AS id_17,
  t16.title AS title_18,
  t16.description AS description_19,
  t16.category AS category_20,
  t16.pending_photos_status AS pending_photos_status_21,
  t16.pending_payment_status AS pending_payment_status_22,
  t16.relist_status AS relist_status_23,
  t16.seller_role AS seller_role_24,
  t16.area AS area_25,
  t16.price AS price_26,
  t16.address AS address_27,
  t16.center_lat AS center_lat_28,
  t16.center_lng AS center_lng_29,
  t16.status AS status_30,
  t16.property_view AS property_view_31,
  t16.payment_method AS payment_method_32,
  t16.featured AS featured_33,
  t16.views AS views_34,
  t16.phone_counter AS phone_counter_35,
  t16.messages_counter AS messages_counter_36,
  t16.leads_counter AS leads_counter_37,
  t16.sent_notifiers AS sent_notifiers_38,
  t16.relist_counter AS relist_counter_39,
  t16.ip AS ip_40,
  t16.video_url AS video_url_41,
  t16.slug AS slug_42,
  t16.custom_slug AS custom_slug_43,
  t16.score AS score_44,
  t16.created_at AS created_at_45,
  t16.updated_at AS updated_at_46,
  t16.pending_status_created_at AS pending_status_created_at_47,
  t16.published_at AS published_at_48,
  t16.expires_at AS expires_at_49,
  t16.deleted_at AS deleted_at_50,
  t16.rejected_at AS rejected_at_51,
  t16.campaign AS campaign_52,
  t16.final_price AS final_price_53,
  t16.source_of_sale AS source_of_sale_54,
  t16.delete_reason AS delete_reason_55,
  t16.delete_reason_details AS delete_reason_details_56,
  t16.source AS source_57,
  t16.impressions AS impressions_58,
  t16.impressions_monthly_count AS impressions_monthly_count_59,
  t16.impressions_weekly_count AS impressions_weekly_count_60,
  t16.impression_updated_at AS impression_updated_at_61,
  t16.price_level AS price_level_62,
  t16.compound_status AS compound_status_63,
  t16.price_per_meter AS price_per_meter_64,
  t16.is_bumped AS is_bumped_65,
  t16.is_send_email AS is_send_email_66,
  t16.market_property_type AS market_property_type_67,
  t16.creation_source AS creation_source_68,
  t16.click_through_rate AS click_through_rate_69,
  t16.label AS label_70,
  t16.is_top_picks AS is_top_picks_71,
  t16.contact_rate AS contact_rate_72,
  t16.synced AS synced_73,
  t16.reference_id AS reference_id_74,
  t16.is_pending_featuring AS is_pending_featuring_75,
  t16.pending_featuring_type AS pending_featuring_type_76,
  t16.rate_status AS rate_status_77,
  t16.is_rate_reviewed AS is_rate_reviewed_78,
  t16.is_call_request AS is_call_request_79,
  t16.is_shown_in_homepage AS is_shown_in_homepage_80,
  t16.is_commercial AS is_commercial_81,
  t16.is_resale AS is_resale_82,
  t16.is_rent AS is_rent_83,
  t16.is_primary AS is_primary_84,
  t16.is_mortgage_approved AS is_mortgage_approved_85,
  t16.meta_title AS meta_title_86,
  t16.meta_description AS meta_description_87,
  t16.is_mortgage AS is_mortgage_88,
  t16.eligible_for_mortgage AS eligible_for_mortgage_89,
  t16.property_registration_status AS property_registration_status_90,
  t16.advertiser_number AS advertiser_number_91,
  t16.authorization_number AS authorization_number_92,
  t16.freezed_at AS freezed_at_93,
  t16.eligible_for_bumpup AS eligible_for_bumpup_94,
  t16.waiting_time AS waiting_time_95,
  t16.reference_number AS reference_number_96,
  t16.parent_id AS parent_id_97,
  t16.relist_id AS relist_id_98,
  t16.section_id AS section_id_99,
  t16.property_type_id AS property_type_id_100,
  t16.location_id AS location_id_101,
  t16.compound_location_id AS compound_location_id_102,
  t16.user_id AS user_id_103,
  t16.compound_field_id AS compound_field_id_104,
  t0.credit_id AS credit_id_105,
  t0.bump_up_owner_id AS bump_up_owner_id_106
FROM
  listings_features t0
  INNER JOIN listings t16 ON t0.listing_id = t16.id
WHERE
  (
    (
      (
        t0.type = ?
        AND t0.expires_at >= ?
      )
      OR t0.expires_at IS NULL
    )
    AND t0.listing_id = ?
  )
ORDER BY
  t0.id DESC