Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.iatanumber AS iatanumber_2,
  c0_.description AS description_3,
  c0_.internal_comment AS internal_comment_4,
  c0_.address_line1 AS address_line1_5,
  c0_.address_line2 AS address_line2_6,
  c0_.zip_code AS zip_code_7,
  c0_.city AS city_8,
  c0_.phone AS phone_9,
  c0_.fax AS fax_10,
  c0_.email AS email_11,
  c0_.logo AS logo_12,
  c0_.website_logo AS website_logo_13,
  c0_.hotel_blacklist AS hotel_blacklist_14,
  c0_.domains AS domains_15,
  c0_.custom_css AS custom_css_16,
  c0_.website AS website_17,
  c0_.markup_hotel AS markup_hotel_18,
  c0_.markup_activity AS markup_activity_19,
  c0_.markup_transfer AS markup_transfer_20,
  c0_.markup_car_rental AS markup_car_rental_21,
  c0_.markup_flight AS markup_flight_22,
  c0_.commission_hotel AS commission_hotel_23,
  c0_.commission_activity AS commission_activity_24,
  c0_.commission_transfer AS commission_transfer_25,
  c0_.commission_car_rental AS commission_car_rental_26,
  c0_.commission_flight AS commission_flight_27,
  c0_.created_at AS created_at_28,
  c0_.updated_at AS updated_at_29,
  c0_.deleted_at AS deleted_at_30,
  c0_.deactivated_at AS deactivated_at_31,
  c0_.credit_level AS credit_level_32,
  c0_.is_commission_customer_account AS is_commission_customer_account_33,
  c0_.can_edit_commission AS can_edit_commission_34,
  c0_.send_pending_payments_email AS send_pending_payments_email_35,
  c0_.pending_payment_email_config AS pending_payment_email_config_36,
  c0_.concierge_service_price AS concierge_service_price_37,
  c0_.can_add_customer_account_fee AS can_add_customer_account_fee_38,
  c0_.customer_account_fee_processing_fee_percentage AS customer_account_fee_processing_fee_percentage_39,
  c0_.concierge_service_tax_percentage AS concierge_service_tax_percentage_40,
  c0_.can_add_concierge_service AS can_add_concierge_service_41,
  c0_.can_filter_by_taxes AS can_filter_by_taxes_42,
  c0_.send_commission_to_parent AS send_commission_to_parent_43,
  c0_.send_children_commission_to_parent AS send_children_commission_to_parent_44,
  c0_.parent_can_view AS parent_can_view_45,
  c0_.parent_can_edit AS parent_can_edit_46,
  c0_.use_parent_logo AS use_parent_logo_47,
  c0_.send_customer_account_fee_to_parent AS send_customer_account_fee_to_parent_48,
  c0_.send_children_customer_account_fee_to_parent AS send_children_customer_account_fee_to_parent_49,
  c0_.quickbooks_id AS quickbooks_id_50,
  c0_.quickbooks_vendor_id AS quickbooks_vendor_id_51,
  c0_.is_virtuoso_agency AS is_virtuoso_agency_52,
  c0_.is_net_commission_agency AS is_net_commission_agency_53,
  c0_.show_shopping_cart AS show_shopping_cart_54,
  c0_.country_id AS country_id_55,
  c0_.phone_country_code_id AS phone_country_code_id_56,
  c0_.language_id AS language_id_57,
  c0_.currency_id AS currency_id_58,
  c0_.state_id AS state_id_59,
  c0_.parent_customer_account_id AS parent_customer_account_id_60,
  c0_.customer_account_type_id AS customer_account_type_id_61,
  c0_.host_id AS host_id_62,
  c0_.team_owner_id AS team_owner_id_63,
  c0_.on_agent_owner_id AS on_agent_owner_id_64
FROM
  customer_account c0_
  INNER JOIN customer_account_type c1_ ON c0_.customer_account_type_id = c1_.id
WHERE
  c1_.name = 'Agency host'
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.iatanumber AS iatanumber_2, c0_.description AS description_3, c0_.internal_comment AS internal_comment_4, c0_.address_line1 AS address_line1_5, c0_.address_line2 AS address_line2_6, c0_.zip_code AS zip_code_7, c0_.city AS city_8, c0_.phone AS phone_9, c0_.fax AS fax_10, c0_.email AS email_11, c0_.logo AS logo_12, c0_.website_logo AS website_logo_13, c0_.hotel_blacklist AS hotel_blacklist_14, c0_.domains AS domains_15, c0_.custom_css AS custom_css_16, c0_.website AS website_17, c0_.markup_hotel AS markup_hotel_18, c0_.markup_activity AS markup_activity_19, c0_.markup_transfer AS markup_transfer_20, c0_.markup_car_rental AS markup_car_rental_21, c0_.markup_flight AS markup_flight_22, c0_.commission_hotel AS commission_hotel_23, c0_.commission_activity AS commission_activity_24, c0_.commission_transfer AS commission_transfer_25, c0_.commission_car_rental AS commission_car_rental_26, c0_.commission_flight AS commission_flight_27, c0_.created_at AS created_at_28, c0_.updated_at AS updated_at_29, c0_.deleted_at AS deleted_at_30, c0_.deactivated_at AS deactivated_at_31, c0_.credit_level AS credit_level_32, c0_.is_commission_customer_account AS is_commission_customer_account_33, c0_.can_edit_commission AS can_edit_commission_34, c0_.send_pending_payments_email AS send_pending_payments_email_35, c0_.pending_payment_email_config AS pending_payment_email_config_36, c0_.concierge_service_price AS concierge_service_price_37, c0_.can_add_customer_account_fee AS can_add_customer_account_fee_38, c0_.customer_account_fee_processing_fee_percentage AS customer_account_fee_processing_fee_percentage_39, c0_.concierge_service_tax_percentage AS concierge_service_tax_percentage_40, c0_.can_add_concierge_service AS can_add_concierge_service_41, c0_.can_filter_by_taxes AS can_filter_by_taxes_42, c0_.send_commission_to_parent AS send_commission_to_parent_43, c0_.send_children_commission_to_parent AS send_children_commission_to_parent_44, c0_.parent_can_view AS parent_can_view_45, c0_.parent_can_edit AS parent_can_edit_46, c0_.use_parent_logo AS use_parent_logo_47, c0_.send_customer_account_fee_to_parent AS send_customer_account_fee_to_parent_48, c0_.send_children_customer_account_fee_to_parent AS send_children_customer_account_fee_to_parent_49, c0_.quickbooks_id AS quickbooks_id_50, c0_.quickbooks_vendor_id AS quickbooks_vendor_id_51, c0_.is_virtuoso_agency AS is_virtuoso_agency_52, c0_.is_net_commission_agency AS is_net_commission_agency_53, c0_.show_shopping_cart AS show_shopping_cart_54, c0_.country_id AS country_id_55, c0_.phone_country_code_id AS phone_country_code_id_56, c0_.language_id AS language_id_57, c0_.currency_id AS currency_id_58, c0_.state_id AS state_id_59, c0_.parent_customer_account_id AS parent_customer_account_id_60, c0_.customer_account_type_id AS customer_account_type_id_61, c0_.host_id AS host_id_62, c0_.team_owner_id AS team_owner_id_63, c0_.on_agent_owner_id AS on_agent_owner_id_64 FROM customer_account c0_ INNER JOIN customer_account_type c1_ ON c0_.customer_account_type_id = c1_.id WHERE c1_.name = 'Agency host' ORDER BY c0_.name ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.iatanumber AS iatanumber_2,
  c0_.description AS description_3,
  c0_.internal_comment AS internal_comment_4,
  c0_.address_line1 AS address_line1_5,
  c0_.address_line2 AS address_line2_6,
  c0_.zip_code AS zip_code_7,
  c0_.city AS city_8,
  c0_.phone AS phone_9,
  c0_.fax AS fax_10,
  c0_.email AS email_11,
  c0_.logo AS logo_12,
  c0_.website_logo AS website_logo_13,
  c0_.hotel_blacklist AS hotel_blacklist_14,
  c0_.domains AS domains_15,
  c0_.custom_css AS custom_css_16,
  c0_.website AS website_17,
  c0_.markup_hotel AS markup_hotel_18,
  c0_.markup_activity AS markup_activity_19,
  c0_.markup_transfer AS markup_transfer_20,
  c0_.markup_car_rental AS markup_car_rental_21,
  c0_.markup_flight AS markup_flight_22,
  c0_.commission_hotel AS commission_hotel_23,
  c0_.commission_activity AS commission_activity_24,
  c0_.commission_transfer AS commission_transfer_25,
  c0_.commission_car_rental AS commission_car_rental_26,
  c0_.commission_flight AS commission_flight_27,
  c0_.created_at AS created_at_28,
  c0_.updated_at AS updated_at_29,
  c0_.deleted_at AS deleted_at_30,
  c0_.deactivated_at AS deactivated_at_31,
  c0_.credit_level AS credit_level_32,
  c0_.is_commission_customer_account AS is_commission_customer_account_33,
  c0_.can_edit_commission AS can_edit_commission_34,
  c0_.send_pending_payments_email AS send_pending_payments_email_35,
  c0_.pending_payment_email_config AS pending_payment_email_config_36,
  c0_.concierge_service_price AS concierge_service_price_37,
  c0_.can_add_customer_account_fee AS can_add_customer_account_fee_38,
  c0_.customer_account_fee_processing_fee_percentage AS customer_account_fee_processing_fee_percentage_39,
  c0_.concierge_service_tax_percentage AS concierge_service_tax_percentage_40,
  c0_.can_add_concierge_service AS can_add_concierge_service_41,
  c0_.can_filter_by_taxes AS can_filter_by_taxes_42,
  c0_.send_commission_to_parent AS send_commission_to_parent_43,
  c0_.send_children_commission_to_parent AS send_children_commission_to_parent_44,
  c0_.parent_can_view AS parent_can_view_45,
  c0_.parent_can_edit AS parent_can_edit_46,
  c0_.use_parent_logo AS use_parent_logo_47,
  c0_.send_customer_account_fee_to_parent AS send_customer_account_fee_to_parent_48,
  c0_.send_children_customer_account_fee_to_parent AS send_children_customer_account_fee_to_parent_49,
  c0_.quickbooks_id AS quickbooks_id_50,
  c0_.quickbooks_vendor_id AS quickbooks_vendor_id_51,
  c0_.is_virtuoso_agency AS is_virtuoso_agency_52,
  c0_.is_net_commission_agency AS is_net_commission_agency_53,
  c0_.show_shopping_cart AS show_shopping_cart_54,
  c0_.country_id AS country_id_55,
  c0_.phone_country_code_id AS phone_country_code_id_56,
  c0_.language_id AS language_id_57,
  c0_.currency_id AS currency_id_58,
  c0_.state_id AS state_id_59,
  c0_.parent_customer_account_id AS parent_customer_account_id_60,
  c0_.customer_account_type_id AS customer_account_type_id_61,
  c0_.host_id AS host_id_62,
  c0_.team_owner_id AS team_owner_id_63,
  c0_.on_agent_owner_id AS on_agent_owner_id_64
FROM
  customer_account c0_
WHERE
  c0_.domains LIKE LOWER(?)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.iatanumber AS iatanumber_2, c0_.description AS description_3, c0_.internal_comment AS internal_comment_4, c0_.address_line1 AS address_line1_5, c0_.address_line2 AS address_line2_6, c0_.zip_code AS zip_code_7, c0_.city AS city_8, c0_.phone AS phone_9, c0_.fax AS fax_10, c0_.email AS email_11, c0_.logo AS logo_12, c0_.website_logo AS website_logo_13, c0_.hotel_blacklist AS hotel_blacklist_14, c0_.domains AS domains_15, c0_.custom_css AS custom_css_16, c0_.website AS website_17, c0_.markup_hotel AS markup_hotel_18, c0_.markup_activity AS markup_activity_19, c0_.markup_transfer AS markup_transfer_20, c0_.markup_car_rental AS markup_car_rental_21, c0_.markup_flight AS markup_flight_22, c0_.commission_hotel AS commission_hotel_23, c0_.commission_activity AS commission_activity_24, c0_.commission_transfer AS commission_transfer_25, c0_.commission_car_rental AS commission_car_rental_26, c0_.commission_flight AS commission_flight_27, c0_.created_at AS created_at_28, c0_.updated_at AS updated_at_29, c0_.deleted_at AS deleted_at_30, c0_.deactivated_at AS deactivated_at_31, c0_.credit_level AS credit_level_32, c0_.is_commission_customer_account AS is_commission_customer_account_33, c0_.can_edit_commission AS can_edit_commission_34, c0_.send_pending_payments_email AS send_pending_payments_email_35, c0_.pending_payment_email_config AS pending_payment_email_config_36, c0_.concierge_service_price AS concierge_service_price_37, c0_.can_add_customer_account_fee AS can_add_customer_account_fee_38, c0_.customer_account_fee_processing_fee_percentage AS customer_account_fee_processing_fee_percentage_39, c0_.concierge_service_tax_percentage AS concierge_service_tax_percentage_40, c0_.can_add_concierge_service AS can_add_concierge_service_41, c0_.can_filter_by_taxes AS can_filter_by_taxes_42, c0_.send_commission_to_parent AS send_commission_to_parent_43, c0_.send_children_commission_to_parent AS send_children_commission_to_parent_44, c0_.parent_can_view AS parent_can_view_45, c0_.parent_can_edit AS parent_can_edit_46, c0_.use_parent_logo AS use_parent_logo_47, c0_.send_customer_account_fee_to_parent AS send_customer_account_fee_to_parent_48, c0_.send_children_customer_account_fee_to_parent AS send_children_customer_account_fee_to_parent_49, c0_.quickbooks_id AS quickbooks_id_50, c0_.quickbooks_vendor_id AS quickbooks_vendor_id_51, c0_.is_virtuoso_agency AS is_virtuoso_agency_52, c0_.is_net_commission_agency AS is_net_commission_agency_53, c0_.show_shopping_cart AS show_shopping_cart_54, c0_.country_id AS country_id_55, c0_.phone_country_code_id AS phone_country_code_id_56, c0_.language_id AS language_id_57, c0_.currency_id AS currency_id_58, c0_.state_id AS state_id_59, c0_.parent_customer_account_id AS parent_customer_account_id_60, c0_.customer_account_type_id AS customer_account_type_id_61, c0_.host_id AS host_id_62, c0_.team_owner_id AS team_owner_id_63, c0_.on_agent_owner_id AS on_agent_owner_id_64 FROM customer_account c0_ WHERE c0_.domains LIKE LOWER('%\"domain1\": \"qa2.otitestserver.com\"%');

SELECT
  c0_.id AS id_0,
  c0_.country_code AS country_code_1,
  c0_.regex_for_phone_number AS regex_for_phone_number_2,
  c0_.name AS name_3,
  c0_.phone_code AS phone_code_4
FROM
  country c0_
WHERE
  c0_.phone_code <> 0
GROUP BY
  c0_.phone_code
ORDER BY
  c0_.phone_code ASC

SELECT c0_.id AS id_0, c0_.country_code AS country_code_1, c0_.regex_for_phone_number AS regex_for_phone_number_2, c0_.name AS name_3, c0_.phone_code AS phone_code_4 FROM country c0_ WHERE c0_.phone_code <> 0 GROUP BY c0_.phone_code ORDER BY c0_.phone_code ASC;

SELECT
  l0_.id AS id_0,
  l0_.code AS code_1,
  l0_.name AS name_2
FROM
  language l0_

SELECT l0_.id AS id_0, l0_.code AS code_1, l0_.name AS name_2 FROM language l0_;