Symfony Profiler

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
  v0_.id AS id_0,
  v0_.title AS title_1,
  v0_.description AS description_2,
  v0_.needed_from AS needed_from_3,
  v0_.needed_to AS needed_to_4,
  v0_.num_needed AS num_needed_5,
  v0_.created_at AS created_at_6,
  v1_.id AS id_7,
  v1_.created_at AS created_at_8,
  u2_.username AS username_9,
  u2_.username_canonical AS username_canonical_10,
  u2_.email AS email_11,
  u2_.email_canonical AS email_canonical_12,
  u2_.enabled AS enabled_13,
  u2_.salt AS salt_14,
  u2_.last_login AS last_login_15,
  u2_.confirmation_token AS confirmation_token_16,
  u2_.password_requested_at AS password_requested_at_17,
  u2_.roles AS roles_18,
  u2_.id AS id_19,
  u2_.fname AS fname_20,
  u2_.lname AS lname_21,
  u2_.phone AS phone_22,
  u2_.skip_mobile AS skip_mobile_23,
  u2_.sms_opt_in AS sms_opt_in_24,
  u2_.timezone AS timezone_25,
  u2_.user_allow_admin_update AS user_allow_admin_update_26,
  u2_.service_fee_type AS service_fee_type_27,
  u2_.notitication_preference AS notitication_preference_28,
  u2_.is_test AS is_test_29,
  u2_.email_optout AS email_optout_30,
  u2_.created_at AS created_at_31,
  u2_.modals AS modals_32,
  u2_.profile_update_dismissed_at AS profile_update_dismissed_at_33,
  u2_.has_logged_in AS has_logged_in_34,
  u2_.facebook_id AS facebook_id_35,
  u2_.facebook_access_token AS facebook_access_token_36,
  u2_.google_id AS google_id_37,
  u2_.nvidia_id AS nvidia_id_38,
  u2_.chg_id AS chg_id_39,
  u2_.use_fast_list AS use_fast_list_40,
  u2_.password AS password_41,
  u2_.address1 AS address1_42,
  u2_.address2 AS address2_43,
  u2_.city AS city_44,
  u2_.state AS state_45,
  u2_.country AS country_46,
  u2_.zip AS zip_47,
  v0_.campaign_id AS campaign_id_48,
  v1_.task_id AS task_id_49,
  v1_.user_id AS user_id_50,
  u2_.user_terms_id AS user_terms_id_51,
  u2_.preferred_payment_gateway_id AS preferred_payment_gateway_id_52,
  u2_.last_visit_organization_id AS last_visit_organization_id_53,
  u2_.last_visit_campaign_id AS last_visit_campaign_id_54
FROM
  volunteer_tasks v0_
  LEFT JOIN volunteer_assignments v1_ ON v0_.id = v1_.task_id
  LEFT JOIN users u2_ ON v1_.user_id = u2_.id
WHERE
  v0_.campaign_id = ?

SELECT v0_.id AS id_0, v0_.title AS title_1, v0_.description AS description_2, v0_.needed_from AS needed_from_3, v0_.needed_to AS needed_to_4, v0_.num_needed AS num_needed_5, v0_.created_at AS created_at_6, v1_.id AS id_7, v1_.created_at AS created_at_8, u2_.username AS username_9, u2_.username_canonical AS username_canonical_10, u2_.email AS email_11, u2_.email_canonical AS email_canonical_12, u2_.enabled AS enabled_13, u2_.salt AS salt_14, u2_.last_login AS last_login_15, u2_.confirmation_token AS confirmation_token_16, u2_.password_requested_at AS password_requested_at_17, u2_.roles AS roles_18, u2_.id AS id_19, u2_.fname AS fname_20, u2_.lname AS lname_21, u2_.phone AS phone_22, u2_.skip_mobile AS skip_mobile_23, u2_.sms_opt_in AS sms_opt_in_24, u2_.timezone AS timezone_25, u2_.user_allow_admin_update AS user_allow_admin_update_26, u2_.service_fee_type AS service_fee_type_27, u2_.notitication_preference AS notitication_preference_28, u2_.is_test AS is_test_29, u2_.email_optout AS email_optout_30, u2_.created_at AS created_at_31, u2_.modals AS modals_32, u2_.profile_update_dismissed_at AS profile_update_dismissed_at_33, u2_.has_logged_in AS has_logged_in_34, u2_.facebook_id AS facebook_id_35, u2_.facebook_access_token AS facebook_access_token_36, u2_.google_id AS google_id_37, u2_.nvidia_id AS nvidia_id_38, u2_.chg_id AS chg_id_39, u2_.use_fast_list AS use_fast_list_40, u2_.password AS password_41, u2_.address1 AS address1_42, u2_.address2 AS address2_43, u2_.city AS city_44, u2_.state AS state_45, u2_.country AS country_46, u2_.zip AS zip_47, v0_.campaign_id AS campaign_id_48, v1_.task_id AS task_id_49, v1_.user_id AS user_id_50, u2_.user_terms_id AS user_terms_id_51, u2_.preferred_payment_gateway_id AS preferred_payment_gateway_id_52, u2_.last_visit_organization_id AS last_visit_organization_id_53, u2_.last_visit_campaign_id AS last_visit_campaign_id_54 FROM volunteer_tasks v0_ LEFT JOIN volunteer_assignments v1_ ON v0_.id = v1_.task_id LEFT JOIN users u2_ ON v1_.user_id = u2_.id WHERE v0_.campaign_id = 1677;

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
  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');

SET
  time_zone = 'America/Chicago'

SET time_zone = 'America/Chicago';