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
  a0_.id AS id_0,
  a0_.item_number AS item_number_1,
  a0_.name AS name_2,
  a0_.description AS description_3,
  a0_.short_description AS short_description_4,
  a0_.min_bid AS min_bid_5,
  a0_.reserve_price AS reserve_price_6,
  a0_.buy_it_now_price AS buy_it_now_price_7,
  a0_.bid_increment AS bid_increment_8,
  a0_.tax_deduct_amount AS tax_deduct_amount_9,
  a0_.est_value AS est_value_10,
  a0_.est_value_display AS est_value_display_11,
  a0_.begin_quantity AS begin_quantity_12,
  a0_.current_quantity AS current_quantity_13,
  a0_.overtime_bidding_extended AS overtime_bidding_extended_14,
  a0_.featured AS featured_15,
  a0_.donor_anonymous AS donor_anonymous_16,
  a0_.pickup_instructions AS pickup_instructions_17,
  a0_.bid_begin AS bid_begin_18,
  a0_.bid_end AS bid_end_19,
  a0_.active AS active_20,
  a0_.question_text AS question_text_21,
  a0_.question_required AS question_required_22,
  a0_.collect_email AS collect_email_23,
  a0_.sort_order AS sort_order_24,
  a0_.created_at AS created_at_25,
  a0_.show_purchasers AS show_purchasers_26,
  p1_.id AS id_27,
  p1_.amount AS amount_28,
  p1_.transaction_amount AS transaction_amount_29,
  p1_.tax_deduct_amount AS tax_deduct_amount_30,
  p1_.convenience_fee AS convenience_fee_31,
  p1_.service_fee AS service_fee_32,
  p1_.transaction_fee AS transaction_fee_33,
  p1_.expiration_date AS expiration_date_34,
  p1_.pickup_time AS pickup_time_35,
  p1_.external_payment AS external_payment_36,
  p1_.question_text AS question_text_37,
  p1_.question_answer AS question_answer_38,
  p1_.question_required AS question_required_39,
  p1_.date AS date_40,
  p1_.item_purchase_email AS item_purchase_email_41,
  t2_.id AS id_42,
  t2_.amount AS amount_43,
  t2_.tax_deduct_amt AS tax_deduct_amt_44,
  t2_.transaction_fee AS transaction_fee_45,
  t2_.service_fee AS service_fee_46,
  t2_.service_fee_capped AS service_fee_capped_47,
  t2_.captured_transaction_fee AS captured_transaction_fee_48,
  t2_.user_paid_fee AS user_paid_fee_49,
  t2_.profit AS profit_50,
  t2_.balance AS balance_51,
  t2_.status AS status_52,
  t2_.service_fee_type AS service_fee_type_53,
  t2_.payout_eligible AS payout_eligible_54,
  t2_.total AS total_55,
  t2_.date AS date_56,
  t2_.check_number AS check_number_57,
  t2_.paypal_txn_id AS paypal_txn_id_58,
  t2_.payout_note AS payout_note_59,
  t2_.stripe_charge_id AS stripe_charge_id_60,
  t2_.authorization AS authorization_61,
  t2_.stripe_refund_id AS stripe_refund_id_62,
  a0_.auction_id AS auction_id_63,
  a0_.category_id AS category_id_64,
  a0_.type_id AS type_id_65,
  a0_.sale_type_id AS sale_type_id_66,
  a0_.condition_id AS condition_id_67,
  a0_.venue_id AS venue_id_68,
  a0_.user_id AS user_id_69,
  a0_.company_id AS company_id_70,
  a0_.winning_bid_id AS winning_bid_id_71,
  a0_.donor_receipt_email_id AS donor_receipt_email_id_72,
  a0_.item_package_id AS item_package_id_73,
  a0_.template_id AS template_id_74,
  p1_.type AS type_75,
  p1_.user_id AS user_id_76,
  p1_.campaign_id AS campaign_id_77,
  p1_.transaction_id AS transaction_id_78,
  p1_.refund_transaction_id AS refund_transaction_id_79,
  p1_.item_id AS item_id_80,
  p1_.bid_id AS bid_id_81,
  t2_.type AS type_82,
  t2_.user_id AS user_id_83,
  t2_.campaign_id AS campaign_id_84,
  t2_.refund_transaction_id AS refund_transaction_id_85
FROM
  auction_items a0_
  LEFT JOIN purchases p1_ ON a0_.id = p1_.item_id
  AND p1_.type IN (
    'item', 'buy_it_now', 'donation_item'
  )
  LEFT JOIN transactions t2_ ON p1_.transaction_id = t2_.id
  AND t2_.type IN (
    'cash', 'check', 'paypal', 'payout',
    'stripe', 'external', 'offlinecreditcard',
    'refund', 'stripe_refund', 'flight_simulator',
    ''
  )
WHERE
  a0_.id = ?

SELECT a0_.id AS id_0, a0_.item_number AS item_number_1, a0_.name AS name_2, a0_.description AS description_3, a0_.short_description AS short_description_4, a0_.min_bid AS min_bid_5, a0_.reserve_price AS reserve_price_6, a0_.buy_it_now_price AS buy_it_now_price_7, a0_.bid_increment AS bid_increment_8, a0_.tax_deduct_amount AS tax_deduct_amount_9, a0_.est_value AS est_value_10, a0_.est_value_display AS est_value_display_11, a0_.begin_quantity AS begin_quantity_12, a0_.current_quantity AS current_quantity_13, a0_.overtime_bidding_extended AS overtime_bidding_extended_14, a0_.featured AS featured_15, a0_.donor_anonymous AS donor_anonymous_16, a0_.pickup_instructions AS pickup_instructions_17, a0_.bid_begin AS bid_begin_18, a0_.bid_end AS bid_end_19, a0_.active AS active_20, a0_.question_text AS question_text_21, a0_.question_required AS question_required_22, a0_.collect_email AS collect_email_23, a0_.sort_order AS sort_order_24, a0_.created_at AS created_at_25, a0_.show_purchasers AS show_purchasers_26, p1_.id AS id_27, p1_.amount AS amount_28, p1_.transaction_amount AS transaction_amount_29, p1_.tax_deduct_amount AS tax_deduct_amount_30, p1_.convenience_fee AS convenience_fee_31, p1_.service_fee AS service_fee_32, p1_.transaction_fee AS transaction_fee_33, p1_.expiration_date AS expiration_date_34, p1_.pickup_time AS pickup_time_35, p1_.external_payment AS external_payment_36, p1_.question_text AS question_text_37, p1_.question_answer AS question_answer_38, p1_.question_required AS question_required_39, p1_.date AS date_40, p1_.item_purchase_email AS item_purchase_email_41, t2_.id AS id_42, t2_.amount AS amount_43, t2_.tax_deduct_amt AS tax_deduct_amt_44, t2_.transaction_fee AS transaction_fee_45, t2_.service_fee AS service_fee_46, t2_.service_fee_capped AS service_fee_capped_47, t2_.captured_transaction_fee AS captured_transaction_fee_48, t2_.user_paid_fee AS user_paid_fee_49, t2_.profit AS profit_50, t2_.balance AS balance_51, t2_.status AS status_52, t2_.service_fee_type AS service_fee_type_53, t2_.payout_eligible AS payout_eligible_54, t2_.total AS total_55, t2_.date AS date_56, t2_.check_number AS check_number_57, t2_.paypal_txn_id AS paypal_txn_id_58, t2_.payout_note AS payout_note_59, t2_.stripe_charge_id AS stripe_charge_id_60, t2_.authorization AS authorization_61, t2_.stripe_refund_id AS stripe_refund_id_62, a0_.auction_id AS auction_id_63, a0_.category_id AS category_id_64, a0_.type_id AS type_id_65, a0_.sale_type_id AS sale_type_id_66, a0_.condition_id AS condition_id_67, a0_.venue_id AS venue_id_68, a0_.user_id AS user_id_69, a0_.company_id AS company_id_70, a0_.winning_bid_id AS winning_bid_id_71, a0_.donor_receipt_email_id AS donor_receipt_email_id_72, a0_.item_package_id AS item_package_id_73, a0_.template_id AS template_id_74, p1_.type AS type_75, p1_.user_id AS user_id_76, p1_.campaign_id AS campaign_id_77, p1_.transaction_id AS transaction_id_78, p1_.refund_transaction_id AS refund_transaction_id_79, p1_.item_id AS item_id_80, p1_.bid_id AS bid_id_81, t2_.type AS type_82, t2_.user_id AS user_id_83, t2_.campaign_id AS campaign_id_84, t2_.refund_transaction_id AS refund_transaction_id_85 FROM auction_items a0_ LEFT JOIN purchases p1_ ON a0_.id = p1_.item_id AND p1_.type IN ('item', 'buy_it_now', 'donation_item') LEFT JOIN transactions t2_ ON p1_.transaction_id = t2_.id AND t2_.type IN ('cash', 'check', 'paypal', 'payout', 'stripe', 'external', 'offlinecreditcard', 'refund', 'stripe_refund', 'flight_simulator', '') WHERE a0_.id = 52171;

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.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.id = 1173 AND t0.type IN ('auction', 'shop', 'fund-a-need');

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