Symfony Profiler

SET
  time_zone = 'America/Chicago'

SET time_zone = 'America/Chicago';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.active AS active_4,
  t0.approved AS approved_5,
  t0.commission AS commission_6,
  t0.enable_customizations AS enable_customizations_7,
  t0.non_profit AS non_profit_8,
  t0.service_fees_cap AS service_fees_cap_9,
  t0.total_service_fees AS total_service_fees_10,
  t0.total_service_fees_capped AS total_service_fees_capped_11,
  t0.plan_renewal_amount AS plan_renewal_amount_12,
  t0.tin AS tin_13,
  t0.url_editable_until AS url_editable_until_14,
  t0.created_at AS created_at_15,
  t0.admin_org AS admin_org_16,
  t0.stripe_address_check AS stripe_address_check_17,
  t0.mandrill_subaccount AS mandrill_subaccount_18,
  t0.currency AS currency_19,
  t0.phone AS phone_20,
  t0.contact_name AS contact_name_21,
  t0.contact_email AS contact_email_22,
  t0.notes AS notes_23,
  t0.no_payment_gateway_required AS no_payment_gateway_required_24,
  t0.kindful_token AS kindful_token_25,
  t0.stripe_subscription_id AS stripe_subscription_id_26,
  t0.web_address AS web_address_27,
  t0.organization_type AS organization_type_28,
  t0.non_profit_approved AS non_profit_approved_29,
  t0.flight_simulator_status AS flight_simulator_status_30,
  t0.org_theme_primary_color AS org_theme_primary_color_31,
  t0.org_theme_secondary_color AS org_theme_secondary_color_32,
  t0.org_theme_tertiary_color AS org_theme_tertiary_color_33,
  t0.org_theme_background_color AS org_theme_background_color_34,
  t0.org_theme_name AS org_theme_name_35,
  t0.address1 AS address1_36,
  t0.address2 AS address2_37,
  t0.city AS city_38,
  t0.state AS state_39,
  t0.country AS country_40,
  t0.zip AS zip_41,
  t0.banner_image_id AS banner_image_id_42,
  t0.logo_image_id AS logo_image_id_43,
  t0.card_id AS card_id_44,
  t0.twilio_account AS twilio_account_45,
  t0.tax_certificate_id AS tax_certificate_id_46
FROM
  organizations t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.active AS active_4, t0.approved AS approved_5, t0.commission AS commission_6, t0.enable_customizations AS enable_customizations_7, t0.non_profit AS non_profit_8, t0.service_fees_cap AS service_fees_cap_9, t0.total_service_fees AS total_service_fees_10, t0.total_service_fees_capped AS total_service_fees_capped_11, t0.plan_renewal_amount AS plan_renewal_amount_12, t0.tin AS tin_13, t0.url_editable_until AS url_editable_until_14, t0.created_at AS created_at_15, t0.admin_org AS admin_org_16, t0.stripe_address_check AS stripe_address_check_17, t0.mandrill_subaccount AS mandrill_subaccount_18, t0.currency AS currency_19, t0.phone AS phone_20, t0.contact_name AS contact_name_21, t0.contact_email AS contact_email_22, t0.notes AS notes_23, t0.no_payment_gateway_required AS no_payment_gateway_required_24, t0.kindful_token AS kindful_token_25, t0.stripe_subscription_id AS stripe_subscription_id_26, t0.web_address AS web_address_27, t0.organization_type AS organization_type_28, t0.non_profit_approved AS non_profit_approved_29, t0.flight_simulator_status AS flight_simulator_status_30, t0.org_theme_primary_color AS org_theme_primary_color_31, t0.org_theme_secondary_color AS org_theme_secondary_color_32, t0.org_theme_tertiary_color AS org_theme_tertiary_color_33, t0.org_theme_background_color AS org_theme_background_color_34, t0.org_theme_name AS org_theme_name_35, t0.address1 AS address1_36, t0.address2 AS address2_37, t0.city AS city_38, t0.state AS state_39, t0.country AS country_40, t0.zip AS zip_41, t0.banner_image_id AS banner_image_id_42, t0.logo_image_id AS logo_image_id_43, t0.card_id AS card_id_44, t0.twilio_account AS twilio_account_45, t0.tax_certificate_id AS tax_certificate_id_46 FROM organizations t0 WHERE t0.slug = 'test' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.active AS active_4,
  t0.approved AS approved_5,
  t0.commission AS commission_6,
  t0.enable_customizations AS enable_customizations_7,
  t0.non_profit AS non_profit_8,
  t0.service_fees_cap AS service_fees_cap_9,
  t0.total_service_fees AS total_service_fees_10,
  t0.total_service_fees_capped AS total_service_fees_capped_11,
  t0.plan_renewal_amount AS plan_renewal_amount_12,
  t0.tin AS tin_13,
  t0.url_editable_until AS url_editable_until_14,
  t0.created_at AS created_at_15,
  t0.admin_org AS admin_org_16,
  t0.stripe_address_check AS stripe_address_check_17,
  t0.mandrill_subaccount AS mandrill_subaccount_18,
  t0.currency AS currency_19,
  t0.phone AS phone_20,
  t0.contact_name AS contact_name_21,
  t0.contact_email AS contact_email_22,
  t0.notes AS notes_23,
  t0.no_payment_gateway_required AS no_payment_gateway_required_24,
  t0.kindful_token AS kindful_token_25,
  t0.stripe_subscription_id AS stripe_subscription_id_26,
  t0.web_address AS web_address_27,
  t0.organization_type AS organization_type_28,
  t0.non_profit_approved AS non_profit_approved_29,
  t0.flight_simulator_status AS flight_simulator_status_30,
  t0.org_theme_primary_color AS org_theme_primary_color_31,
  t0.org_theme_secondary_color AS org_theme_secondary_color_32,
  t0.org_theme_tertiary_color AS org_theme_tertiary_color_33,
  t0.org_theme_background_color AS org_theme_background_color_34,
  t0.org_theme_name AS org_theme_name_35,
  t0.address1 AS address1_36,
  t0.address2 AS address2_37,
  t0.city AS city_38,
  t0.state AS state_39,
  t0.country AS country_40,
  t0.zip AS zip_41,
  t0.banner_image_id AS banner_image_id_42,
  t0.logo_image_id AS logo_image_id_43,
  t0.card_id AS card_id_44,
  t0.twilio_account AS twilio_account_45,
  t0.tax_certificate_id AS tax_certificate_id_46
FROM
  organizations t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.active AS active_4, t0.approved AS approved_5, t0.commission AS commission_6, t0.enable_customizations AS enable_customizations_7, t0.non_profit AS non_profit_8, t0.service_fees_cap AS service_fees_cap_9, t0.total_service_fees AS total_service_fees_10, t0.total_service_fees_capped AS total_service_fees_capped_11, t0.plan_renewal_amount AS plan_renewal_amount_12, t0.tin AS tin_13, t0.url_editable_until AS url_editable_until_14, t0.created_at AS created_at_15, t0.admin_org AS admin_org_16, t0.stripe_address_check AS stripe_address_check_17, t0.mandrill_subaccount AS mandrill_subaccount_18, t0.currency AS currency_19, t0.phone AS phone_20, t0.contact_name AS contact_name_21, t0.contact_email AS contact_email_22, t0.notes AS notes_23, t0.no_payment_gateway_required AS no_payment_gateway_required_24, t0.kindful_token AS kindful_token_25, t0.stripe_subscription_id AS stripe_subscription_id_26, t0.web_address AS web_address_27, t0.organization_type AS organization_type_28, t0.non_profit_approved AS non_profit_approved_29, t0.flight_simulator_status AS flight_simulator_status_30, t0.org_theme_primary_color AS org_theme_primary_color_31, t0.org_theme_secondary_color AS org_theme_secondary_color_32, t0.org_theme_tertiary_color AS org_theme_tertiary_color_33, t0.org_theme_background_color AS org_theme_background_color_34, t0.org_theme_name AS org_theme_name_35, t0.address1 AS address1_36, t0.address2 AS address2_37, t0.city AS city_38, t0.state AS state_39, t0.country AS country_40, t0.zip AS zip_41, t0.banner_image_id AS banner_image_id_42, t0.logo_image_id AS logo_image_id_43, t0.card_id AS card_id_44, t0.twilio_account AS twilio_account_45, t0.tax_certificate_id AS tax_certificate_id_46 FROM organizations t0 WHERE t0.slug = 'test' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.active AS active_4,
  t0.approved AS approved_5,
  t0.commission AS commission_6,
  t0.enable_customizations AS enable_customizations_7,
  t0.non_profit AS non_profit_8,
  t0.service_fees_cap AS service_fees_cap_9,
  t0.total_service_fees AS total_service_fees_10,
  t0.total_service_fees_capped AS total_service_fees_capped_11,
  t0.plan_renewal_amount AS plan_renewal_amount_12,
  t0.tin AS tin_13,
  t0.url_editable_until AS url_editable_until_14,
  t0.created_at AS created_at_15,
  t0.admin_org AS admin_org_16,
  t0.stripe_address_check AS stripe_address_check_17,
  t0.mandrill_subaccount AS mandrill_subaccount_18,
  t0.currency AS currency_19,
  t0.phone AS phone_20,
  t0.contact_name AS contact_name_21,
  t0.contact_email AS contact_email_22,
  t0.notes AS notes_23,
  t0.no_payment_gateway_required AS no_payment_gateway_required_24,
  t0.kindful_token AS kindful_token_25,
  t0.stripe_subscription_id AS stripe_subscription_id_26,
  t0.web_address AS web_address_27,
  t0.organization_type AS organization_type_28,
  t0.non_profit_approved AS non_profit_approved_29,
  t0.flight_simulator_status AS flight_simulator_status_30,
  t0.org_theme_primary_color AS org_theme_primary_color_31,
  t0.org_theme_secondary_color AS org_theme_secondary_color_32,
  t0.org_theme_tertiary_color AS org_theme_tertiary_color_33,
  t0.org_theme_background_color AS org_theme_background_color_34,
  t0.org_theme_name AS org_theme_name_35,
  t0.address1 AS address1_36,
  t0.address2 AS address2_37,
  t0.city AS city_38,
  t0.state AS state_39,
  t0.country AS country_40,
  t0.zip AS zip_41,
  t0.banner_image_id AS banner_image_id_42,
  t0.logo_image_id AS logo_image_id_43,
  t0.card_id AS card_id_44,
  t0.twilio_account AS twilio_account_45,
  t0.tax_certificate_id AS tax_certificate_id_46
FROM
  organizations t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.active AS active_4, t0.approved AS approved_5, t0.commission AS commission_6, t0.enable_customizations AS enable_customizations_7, t0.non_profit AS non_profit_8, t0.service_fees_cap AS service_fees_cap_9, t0.total_service_fees AS total_service_fees_10, t0.total_service_fees_capped AS total_service_fees_capped_11, t0.plan_renewal_amount AS plan_renewal_amount_12, t0.tin AS tin_13, t0.url_editable_until AS url_editable_until_14, t0.created_at AS created_at_15, t0.admin_org AS admin_org_16, t0.stripe_address_check AS stripe_address_check_17, t0.mandrill_subaccount AS mandrill_subaccount_18, t0.currency AS currency_19, t0.phone AS phone_20, t0.contact_name AS contact_name_21, t0.contact_email AS contact_email_22, t0.notes AS notes_23, t0.no_payment_gateway_required AS no_payment_gateway_required_24, t0.kindful_token AS kindful_token_25, t0.stripe_subscription_id AS stripe_subscription_id_26, t0.web_address AS web_address_27, t0.organization_type AS organization_type_28, t0.non_profit_approved AS non_profit_approved_29, t0.flight_simulator_status AS flight_simulator_status_30, t0.org_theme_primary_color AS org_theme_primary_color_31, t0.org_theme_secondary_color AS org_theme_secondary_color_32, t0.org_theme_tertiary_color AS org_theme_tertiary_color_33, t0.org_theme_background_color AS org_theme_background_color_34, t0.org_theme_name AS org_theme_name_35, t0.address1 AS address1_36, t0.address2 AS address2_37, t0.city AS city_38, t0.state AS state_39, t0.country AS country_40, t0.zip AS zip_41, t0.banner_image_id AS banner_image_id_42, t0.logo_image_id AS logo_image_id_43, t0.card_id AS card_id_44, t0.twilio_account AS twilio_account_45, t0.tax_certificate_id AS tax_certificate_id_46 FROM organizations t0 WHERE t0.slug = 'test' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.active AS active_4,
  t0.description AS description_5,
  t0.service_fee_type AS service_fee_type_6,
  t0.transaction_fee_passthrough AS transaction_fee_passthrough_7,
  t0.collect_cc_info AS collect_cc_info_8,
  t0.details_title AS details_title_9,
  t0.details_body AS details_body_10,
  t0.homepage_content AS homepage_content_11,
  t0.has_auction AS has_auction_12,
  t0.has_shop AS has_shop_13,
  t0.has_fund_a_need AS has_fund_a_need_14,
  t0.has_sponsorship AS has_sponsorship_15,
  t0.sponsorship_signup AS sponsorship_signup_16,
  t0.has_tickets AS has_tickets_17,
  t0.self_check_in_date AS self_check_in_date_18,
  t0.ticket_type AS ticket_type_19,
  t0.ticket_quantity AS ticket_quantity_20,
  t0.ticket_end AS ticket_end_21,
  t0.ticket_display_name AS ticket_display_name_22,
  t0.shop_display_name AS shop_display_name_23,
  t0.fundaneed_display_name AS fundaneed_display_name_24,
  t0.crew_up_setup_display_name AS crew_up_setup_display_name_25,
  t0.crew_up_setup_text_description AS crew_up_setup_text_description_26,
  t0.paddle_raise_display_name AS paddle_raise_display_name_27,
  t0.raffle_display_name AS raffle_display_name_28,
  t0.shop_goal AS shop_goal_29,
  t0.fund_a_need_goal AS fund_a_need_goal_30,
  t0.paddle_raise_goal AS paddle_raise_goal_31,
  t0.external_purchase_display_name AS external_purchase_display_name_32,
  t0.has_item_donations AS has_item_donations_33,
  t0.has_procurement AS has_procurement_34,
  t0.has_cash_donations AS has_cash_donations_35,
  t0.has_fund_drive AS has_fund_drive_36,
  t0.fund_drive_name AS fund_drive_name_37,
  t0.fund_drive_begin AS fund_drive_begin_38,
  t0.fund_drive_end AS fund_drive_end_39,
  t0.payment_notice AS payment_notice_40,
  t0.has_membership AS has_membership_41,
  t0.membership_begin AS membership_begin_42,
  t0.membership_end AS membership_end_43,
  t0.encourage_cash_donations AS encourage_cash_donations_44,
  t0.show_cash_donations AS show_cash_donations_45,
  t0.goal_cash_donations AS goal_cash_donations_46,
  t0.goal_cash_donation_display AS goal_cash_donation_display_47,
  t0.goal_cash_donation_display_progress AS goal_cash_donation_display_progress_48,
  t0.has_registrations AS has_registrations_49,
  t0.require_registration_waiver AS require_registration_waiver_50,
  t0.registration_waiver AS registration_waiver_51,
  t0.registration_start AS registration_start_52,
  t0.registration_end AS registration_end_53,
  t0.has_paddle_raise AS has_paddle_raise_54,
  t0.show_paddle_raise_mobile AS show_paddle_raise_mobile_55,
  t0.has_display_feeds AS has_display_feeds_56,
  t0.has_volunteers AS has_volunteers_57,
  t0.timezone AS timezone_58,
  t0.perpetual AS perpetual_59,
  t0.pay_by_check AS pay_by_check_60,
  t0.hold_items_in_cart AS hold_items_in_cart_61,
  t0.allow_custom_payment_instructions AS allow_custom_payment_instructions_62,
  t0.custom_payment_instructions AS custom_payment_instructions_63,
  t0.donation_text AS donation_text_64,
  t0.sms_reply AS sms_reply_65,
  t0.has_raffle AS has_raffle_66,
  t0.raffle_start AS raffle_start_67,
  t0.raffle_end AS raffle_end_68,
  t0.raffle_show_winners_on_homepage AS raffle_show_winners_on_homepage_69,
  t0.fees AS fees_70,
  t0.send_purchase_email AS send_purchase_email_71,
  t0.created_at AS created_at_72,
  t0.video_url AS video_url_73,
  t0.video_alignment AS video_alignment_74,
  t0.video_size AS video_size_75,
  t0.campaign_theme_primary_color AS campaign_theme_primary_color_76,
  t0.campaign_theme_secondary_color AS campaign_theme_secondary_color_77,
  t0.campaign_theme_tertiary_color AS campaign_theme_tertiary_color_78,
  t0.campaign_theme_background_color AS campaign_theme_background_color_79,
  t0.campaign_theme_name AS campaign_theme_name_80,
  t0.organization_id AS organization_id_81,
  t0.banner_image_id AS banner_image_id_82,
  t0.logo_image_id AS logo_image_id_83,
  t84.id AS id_85,
  t84.number AS number_86,
  t84.expires_at AS expires_at_87,
  t84.campaign_id AS campaign_id_88
FROM
  campaigns t0
  LEFT JOIN twilio_campaigns t84 ON t84.campaign_id = t0.id
WHERE
  t0.organization_id = ?
  AND t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.active AS active_4, t0.description AS description_5, t0.service_fee_type AS service_fee_type_6, t0.transaction_fee_passthrough AS transaction_fee_passthrough_7, t0.collect_cc_info AS collect_cc_info_8, t0.details_title AS details_title_9, t0.details_body AS details_body_10, t0.homepage_content AS homepage_content_11, t0.has_auction AS has_auction_12, t0.has_shop AS has_shop_13, t0.has_fund_a_need AS has_fund_a_need_14, t0.has_sponsorship AS has_sponsorship_15, t0.sponsorship_signup AS sponsorship_signup_16, t0.has_tickets AS has_tickets_17, t0.self_check_in_date AS self_check_in_date_18, t0.ticket_type AS ticket_type_19, t0.ticket_quantity AS ticket_quantity_20, t0.ticket_end AS ticket_end_21, t0.ticket_display_name AS ticket_display_name_22, t0.shop_display_name AS shop_display_name_23, t0.fundaneed_display_name AS fundaneed_display_name_24, t0.crew_up_setup_display_name AS crew_up_setup_display_name_25, t0.crew_up_setup_text_description AS crew_up_setup_text_description_26, t0.paddle_raise_display_name AS paddle_raise_display_name_27, t0.raffle_display_name AS raffle_display_name_28, t0.shop_goal AS shop_goal_29, t0.fund_a_need_goal AS fund_a_need_goal_30, t0.paddle_raise_goal AS paddle_raise_goal_31, t0.external_purchase_display_name AS external_purchase_display_name_32, t0.has_item_donations AS has_item_donations_33, t0.has_procurement AS has_procurement_34, t0.has_cash_donations AS has_cash_donations_35, t0.has_fund_drive AS has_fund_drive_36, t0.fund_drive_name AS fund_drive_name_37, t0.fund_drive_begin AS fund_drive_begin_38, t0.fund_drive_end AS fund_drive_end_39, t0.payment_notice AS payment_notice_40, t0.has_membership AS has_membership_41, t0.membership_begin AS membership_begin_42, t0.membership_end AS membership_end_43, t0.encourage_cash_donations AS encourage_cash_donations_44, t0.show_cash_donations AS show_cash_donations_45, t0.goal_cash_donations AS goal_cash_donations_46, t0.goal_cash_donation_display AS goal_cash_donation_display_47, t0.goal_cash_donation_display_progress AS goal_cash_donation_display_progress_48, t0.has_registrations AS has_registrations_49, t0.require_registration_waiver AS require_registration_waiver_50, t0.registration_waiver AS registration_waiver_51, t0.registration_start AS registration_start_52, t0.registration_end AS registration_end_53, t0.has_paddle_raise AS has_paddle_raise_54, t0.show_paddle_raise_mobile AS show_paddle_raise_mobile_55, t0.has_display_feeds AS has_display_feeds_56, t0.has_volunteers AS has_volunteers_57, t0.timezone AS timezone_58, t0.perpetual AS perpetual_59, t0.pay_by_check AS pay_by_check_60, t0.hold_items_in_cart AS hold_items_in_cart_61, t0.allow_custom_payment_instructions AS allow_custom_payment_instructions_62, t0.custom_payment_instructions AS custom_payment_instructions_63, t0.donation_text AS donation_text_64, t0.sms_reply AS sms_reply_65, t0.has_raffle AS has_raffle_66, t0.raffle_start AS raffle_start_67, t0.raffle_end AS raffle_end_68, t0.raffle_show_winners_on_homepage AS raffle_show_winners_on_homepage_69, t0.fees AS fees_70, t0.send_purchase_email AS send_purchase_email_71, t0.created_at AS created_at_72, t0.video_url AS video_url_73, t0.video_alignment AS video_alignment_74, t0.video_size AS video_size_75, t0.campaign_theme_primary_color AS campaign_theme_primary_color_76, t0.campaign_theme_secondary_color AS campaign_theme_secondary_color_77, t0.campaign_theme_tertiary_color AS campaign_theme_tertiary_color_78, t0.campaign_theme_background_color AS campaign_theme_background_color_79, t0.campaign_theme_name AS campaign_theme_name_80, t0.organization_id AS organization_id_81, t0.banner_image_id AS banner_image_id_82, t0.logo_image_id AS logo_image_id_83, t84.id AS id_85, t84.number AS number_86, t84.expires_at AS expires_at_87, t84.campaign_id AS campaign_id_88 FROM campaigns t0 LEFT JOIN twilio_campaigns t84 ON t84.campaign_id = t0.id WHERE t0.organization_id = 103 AND t0.slug = 'spring-2015-gala' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.online_begin AS online_begin_2,
  t0.online_end AS online_end_3,
  t0.onsite_begin AS onsite_begin_4,
  t0.onsite_end AS onsite_end_5,
  t0.has_online AS has_online_6,
  t0.has_onsite AS has_onsite_7,
  t0.online_ticket_required AS online_ticket_required_8,
  t0.onsite_ticket_required AS onsite_ticket_required_9,
  t0.online_registration_required AS online_registration_required_10,
  t0.onsite_registration_required AS onsite_registration_required_11,
  t0.location AS location_12,
  t0.location_link AS location_link_13,
  t0.bid_increment AS bid_increment_14,
  t0.pickup_instructions AS pickup_instructions_15,
  t0.bidding_rules AS bidding_rules_16,
  t0.overtime_bidding AS overtime_bidding_17,
  t0.created_at AS created_at_18,
  t0.show_auction_title AS show_auction_title_19,
  t0.show_qty_remaining AS show_qty_remaining_20,
  t0.are_you_sure_modal AS are_you_sure_modal_21,
  t0.campaign_id AS campaign_id_22,
  t0.type
FROM
  auctions t0
WHERE
  t0.campaign_id = ?
  AND t0.type IN ('auction', 'shop', 'fund-a-need')

SELECT t0.id AS id_1, t0.online_begin AS online_begin_2, t0.online_end AS online_end_3, t0.onsite_begin AS onsite_begin_4, t0.onsite_end AS onsite_end_5, t0.has_online AS has_online_6, t0.has_onsite AS has_onsite_7, t0.online_ticket_required AS online_ticket_required_8, t0.onsite_ticket_required AS onsite_ticket_required_9, t0.online_registration_required AS online_registration_required_10, t0.onsite_registration_required AS onsite_registration_required_11, t0.location AS location_12, t0.location_link AS location_link_13, t0.bid_increment AS bid_increment_14, t0.pickup_instructions AS pickup_instructions_15, t0.bidding_rules AS bidding_rules_16, t0.overtime_bidding AS overtime_bidding_17, t0.created_at AS created_at_18, t0.show_auction_title AS show_auction_title_19, t0.show_qty_remaining AS show_qty_remaining_20, t0.are_you_sure_modal AS are_you_sure_modal_21, t0.campaign_id AS campaign_id_22, t0.type FROM auctions t0 WHERE t0.campaign_id = 1677 AND t0.type IN ('auction', 'shop', 'fund-a-need');

SELECT
  t0.id AS id_1,
  t0.online_begin AS online_begin_2,
  t0.online_end AS online_end_3,
  t0.onsite_begin AS onsite_begin_4,
  t0.onsite_end AS onsite_end_5,
  t0.has_online AS has_online_6,
  t0.has_onsite AS has_onsite_7,
  t0.online_ticket_required AS online_ticket_required_8,
  t0.onsite_ticket_required AS onsite_ticket_required_9,
  t0.online_registration_required AS online_registration_required_10,
  t0.onsite_registration_required AS onsite_registration_required_11,
  t0.location AS location_12,
  t0.location_link AS location_link_13,
  t0.bid_increment AS bid_increment_14,
  t0.pickup_instructions AS pickup_instructions_15,
  t0.bidding_rules AS bidding_rules_16,
  t0.overtime_bidding AS overtime_bidding_17,
  t0.created_at AS created_at_18,
  t0.show_auction_title AS show_auction_title_19,
  t0.show_qty_remaining AS show_qty_remaining_20,
  t0.are_you_sure_modal AS are_you_sure_modal_21,
  t0.campaign_id AS campaign_id_22,
  t0.type
FROM
  auctions t0
WHERE
  t0.campaign_id = ?
  AND t0.type IN ('shop')

SELECT t0.id AS id_1, t0.online_begin AS online_begin_2, t0.online_end AS online_end_3, t0.onsite_begin AS onsite_begin_4, t0.onsite_end AS onsite_end_5, t0.has_online AS has_online_6, t0.has_onsite AS has_onsite_7, t0.online_ticket_required AS online_ticket_required_8, t0.onsite_ticket_required AS onsite_ticket_required_9, t0.online_registration_required AS online_registration_required_10, t0.onsite_registration_required AS onsite_registration_required_11, t0.location AS location_12, t0.location_link AS location_link_13, t0.bid_increment AS bid_increment_14, t0.pickup_instructions AS pickup_instructions_15, t0.bidding_rules AS bidding_rules_16, t0.overtime_bidding AS overtime_bidding_17, t0.created_at AS created_at_18, t0.show_auction_title AS show_auction_title_19, t0.show_qty_remaining AS show_qty_remaining_20, t0.are_you_sure_modal AS are_you_sure_modal_21, t0.campaign_id AS campaign_id_22, t0.type FROM auctions t0 WHERE t0.campaign_id = 1677 AND t0.type IN ('shop');

SELECT
  t0.id AS id_1,
  t0.online_begin AS online_begin_2,
  t0.online_end AS online_end_3,
  t0.onsite_begin AS onsite_begin_4,
  t0.onsite_end AS onsite_end_5,
  t0.has_online AS has_online_6,
  t0.has_onsite AS has_onsite_7,
  t0.online_ticket_required AS online_ticket_required_8,
  t0.onsite_ticket_required AS onsite_ticket_required_9,
  t0.online_registration_required AS online_registration_required_10,
  t0.onsite_registration_required AS onsite_registration_required_11,
  t0.location AS location_12,
  t0.location_link AS location_link_13,
  t0.bid_increment AS bid_increment_14,
  t0.pickup_instructions AS pickup_instructions_15,
  t0.bidding_rules AS bidding_rules_16,
  t0.overtime_bidding AS overtime_bidding_17,
  t0.created_at AS created_at_18,
  t0.show_auction_title AS show_auction_title_19,
  t0.show_qty_remaining AS show_qty_remaining_20,
  t0.are_you_sure_modal AS are_you_sure_modal_21,
  t0.campaign_id AS campaign_id_22,
  t0.type
FROM
  auctions t0
WHERE
  t0.campaign_id = ?
  AND t0.type IN ('fund-a-need')

SELECT t0.id AS id_1, t0.online_begin AS online_begin_2, t0.online_end AS online_end_3, t0.onsite_begin AS onsite_begin_4, t0.onsite_end AS onsite_end_5, t0.has_online AS has_online_6, t0.has_onsite AS has_onsite_7, t0.online_ticket_required AS online_ticket_required_8, t0.onsite_ticket_required AS onsite_ticket_required_9, t0.online_registration_required AS online_registration_required_10, t0.onsite_registration_required AS onsite_registration_required_11, t0.location AS location_12, t0.location_link AS location_link_13, t0.bid_increment AS bid_increment_14, t0.pickup_instructions AS pickup_instructions_15, t0.bidding_rules AS bidding_rules_16, t0.overtime_bidding AS overtime_bidding_17, t0.created_at AS created_at_18, t0.show_auction_title AS show_auction_title_19, t0.show_qty_remaining AS show_qty_remaining_20, t0.are_you_sure_modal AS are_you_sure_modal_21, t0.campaign_id AS campaign_id_22, t0.type FROM auctions t0 WHERE t0.campaign_id = 1677 AND t0.type IN ('fund-a-need');

SELECT
  (
    SELECT
      COUNT(w0_.id) AS sclr_1
    FROM
      watch_list w0_
    WHERE
      w0_.item_id = a1_.id
  ) AS sclr_0,
  (
    SELECT
      COUNT(b2_.id) AS sclr_3
    FROM
      bids b2_
    WHERE
      b2_.item_id = a1_.id
      AND b2_.active = 1
  ) AS sclr_2,
  (
    SELECT
      MAX(b3_.amount) AS sclr_5
    FROM
      bids b3_
    WHERE
      b3_.item_id = a1_.id
  ) AS sclr_4,
  a1_.id AS id_6,
  a1_.item_number AS item_number_7,
  a1_.name AS name_8,
  a1_.description AS description_9,
  a1_.short_description AS short_description_10,
  a1_.min_bid AS min_bid_11,
  a1_.reserve_price AS reserve_price_12,
  a1_.buy_it_now_price AS buy_it_now_price_13,
  a1_.bid_increment AS bid_increment_14,
  a1_.tax_deduct_amount AS tax_deduct_amount_15,
  a1_.est_value AS est_value_16,
  a1_.est_value_display AS est_value_display_17,
  a1_.begin_quantity AS begin_quantity_18,
  a1_.current_quantity AS current_quantity_19,
  a1_.overtime_bidding_extended AS overtime_bidding_extended_20,
  a1_.featured AS featured_21,
  a1_.donor_anonymous AS donor_anonymous_22,
  a1_.pickup_instructions AS pickup_instructions_23,
  a1_.bid_begin AS bid_begin_24,
  a1_.bid_end AS bid_end_25,
  a1_.active AS active_26,
  a1_.question_text AS question_text_27,
  a1_.question_required AS question_required_28,
  a1_.collect_email AS collect_email_29,
  a1_.sort_order AS sort_order_30,
  a1_.created_at AS created_at_31,
  a1_.show_purchasers AS show_purchasers_32,
  p4_.id AS id_33,
  p4_.amount AS amount_34,
  p4_.transaction_amount AS transaction_amount_35,
  p4_.tax_deduct_amount AS tax_deduct_amount_36,
  p4_.convenience_fee AS convenience_fee_37,
  p4_.service_fee AS service_fee_38,
  p4_.transaction_fee AS transaction_fee_39,
  p4_.expiration_date AS expiration_date_40,
  p4_.pickup_time AS pickup_time_41,
  p4_.external_payment AS external_payment_42,
  p4_.question_text AS question_text_43,
  p4_.question_answer AS question_answer_44,
  p4_.question_required AS question_required_45,
  p4_.date AS date_46,
  p4_.item_purchase_email AS item_purchase_email_47,
  i5_.id AS id_48,
  i5_.primmary AS primmary_49,
  i6_.id AS id_50,
  i6_.path AS path_51,
  i6_.hash AS hash_52,
  i6_.created_at AS created_at_53,
  t7_.id AS id_54,
  t7_.amount AS amount_55,
  t7_.tax_deduct_amt AS tax_deduct_amt_56,
  t7_.transaction_fee AS transaction_fee_57,
  t7_.service_fee AS service_fee_58,
  t7_.service_fee_capped AS service_fee_capped_59,
  t7_.captured_transaction_fee AS captured_transaction_fee_60,
  t7_.user_paid_fee AS user_paid_fee_61,
  t7_.profit AS profit_62,
  t7_.balance AS balance_63,
  t7_.status AS status_64,
  t7_.service_fee_type AS service_fee_type_65,
  t7_.payout_eligible AS payout_eligible_66,
  t7_.total AS total_67,
  t7_.date AS date_68,
  t7_.check_number AS check_number_69,
  t7_.paypal_txn_id AS paypal_txn_id_70,
  t7_.payout_note AS payout_note_71,
  t7_.stripe_charge_id AS stripe_charge_id_72,
  t7_.authorization AS authorization_73,
  t7_.stripe_refund_id AS stripe_refund_id_74,
  b8_.id AS id_75,
  b8_.amount AS amount_76,
  b8_.active AS active_77,
  b8_.created_at AS created_at_78,
  e9_.id AS id_79,
  e9_.hash AS hash_80,
  e9_.subject AS subject_81,
  e9_.email AS email_82,
  e9_.body AS body_83,
  e9_.data AS data_84,
  e9_.status AS status_85,
  e9_.error AS error_86,
  e9_.suppress_send AS suppress_send_87,
  e9_.created_at AS created_at_88,
  e9_.sent_at AS sent_at_89,
  e9_.delivered AS delivered_90,
  e9_.opened_at AS opened_at_91,
  e9_.clicked_at AS clicked_at_92,
  e9_.smtp_status AS smtp_status_93,
  e9_.preview AS preview_94,
  a10_.id AS id_95,
  a10_.item_number AS item_number_96,
  a10_.name AS name_97,
  a10_.description AS description_98,
  a10_.short_description AS short_description_99,
  a10_.min_bid AS min_bid_100,
  a10_.reserve_price AS reserve_price_101,
  a10_.buy_it_now_price AS buy_it_now_price_102,
  a10_.bid_increment AS bid_increment_103,
  a10_.tax_deduct_amount AS tax_deduct_amount_104,
  a10_.est_value AS est_value_105,
  a10_.est_value_display AS est_value_display_106,
  a10_.begin_quantity AS begin_quantity_107,
  a10_.current_quantity AS current_quantity_108,
  a10_.overtime_bidding_extended AS overtime_bidding_extended_109,
  a10_.featured AS featured_110,
  a10_.donor_anonymous AS donor_anonymous_111,
  a10_.pickup_instructions AS pickup_instructions_112,
  a10_.bid_begin AS bid_begin_113,
  a10_.bid_end AS bid_end_114,
  a10_.active AS active_115,
  a10_.question_text AS question_text_116,
  a10_.question_required AS question_required_117,
  a10_.collect_email AS collect_email_118,
  a10_.sort_order AS sort_order_119,
  a10_.created_at AS created_at_120,
  a10_.show_purchasers AS show_purchasers_121,
  a1_.auction_id AS auction_id_122,
  a1_.category_id AS category_id_123,
  a1_.type_id AS type_id_124,
  a1_.sale_type_id AS sale_type_id_125,
  a1_.condition_id AS condition_id_126,
  a1_.venue_id AS venue_id_127,
  a1_.user_id AS user_id_128,
  a1_.company_id AS company_id_129,
  a1_.winning_bid_id AS winning_bid_id_130,
  a1_.donor_receipt_email_id AS donor_receipt_email_id_131,
  a1_.item_package_id AS item_package_id_132,
  a1_.template_id AS template_id_133,
  p4_.type AS type_134,
  p4_.user_id AS user_id_135,
  p4_.campaign_id AS campaign_id_136,
  p4_.transaction_id AS transaction_id_137,
  p4_.refund_transaction_id AS refund_transaction_id_138,
  p4_.item_id AS item_id_139,
  p4_.bid_id AS bid_id_140,
  i5_.item_id AS item_id_141,
  i5_.image_id AS image_id_142,
  i6_.organization_id AS organization_id_143,
  i6_.campaign_id AS campaign_id_144,
  t7_.type AS type_145,
  t7_.user_id AS user_id_146,
  t7_.campaign_id AS campaign_id_147,
  t7_.refund_transaction_id AS refund_transaction_id_148,
  b8_.user_id AS user_id_149,
  b8_.item_id AS item_id_150,
  e9_.user_id AS user_id_151,
  e9_.template_id AS template_id_152,
  e9_.organization_id AS organization_id_153,
  e9_.campaign_id AS campaign_id_154,
  a10_.auction_id AS auction_id_155,
  a10_.category_id AS category_id_156,
  a10_.type_id AS type_id_157,
  a10_.sale_type_id AS sale_type_id_158,
  a10_.condition_id AS condition_id_159,
  a10_.venue_id AS venue_id_160,
  a10_.user_id AS user_id_161,
  a10_.company_id AS company_id_162,
  a10_.winning_bid_id AS winning_bid_id_163,
  a10_.donor_receipt_email_id AS donor_receipt_email_id_164,
  a10_.item_package_id AS item_package_id_165,
  a10_.template_id AS template_id_166
FROM
  auction_items a1_
  LEFT JOIN purchases p4_ ON a1_.id = p4_.item_id
  AND p4_.type IN (
    'item', 'buy_it_now', 'donation_item'
  )
  LEFT JOIN item_images i5_ ON a1_.id = i5_.item_id
  LEFT JOIN images i6_ ON i5_.image_id = i6_.id
  LEFT JOIN transactions t7_ ON p4_.transaction_id = t7_.id
  AND t7_.type IN (
    'cash', 'check', 'paypal', 'payout',
    'stripe', 'external', 'offlinecreditcard',
    'refund', 'stripe_refund', 'flight_simulator',
    ''
  )
  LEFT JOIN bids b8_ ON a1_.winning_bid_id = b8_.id
  LEFT JOIN emails e9_ ON a1_.donor_receipt_email_id = e9_.id
  LEFT JOIN auction_items a10_ ON a1_.id = a10_.item_package_id
  LEFT JOIN auction_venues a11_ ON a1_.venue_id = a11_.id
  LEFT JOIN auctions a12_ ON a1_.auction_id = a12_.id
  AND a12_.type IN ('auction', 'shop', 'fund-a-need')
WHERE
  a1_.auction_id = ?
  AND a1_.active = 1
  AND (
    (
      a1_.sale_type_id = ?
      AND a1_.current_quantity > 0
    )
    OR (
      a1_.sale_type_id = ?
      AND p4_.transaction_id IS NULL
    )
    OR a1_.sale_type_id = ?
    OR a1_.sale_type_id = ?
  )
  AND ? < CASE WHEN a1_.bid_end IS NOT NULL THEN a1_.bid_end WHEN a11_.id = ? THEN a12_.onsite_end ELSE a12_.online_end END
  AND a1_.item_package_id IS NULL
  AND a1_.featured = 1
  AND a1_.active = 1
ORDER BY
  a1_.sort_order DESC,
  a1_.item_number * 1 DESC