Symfony Profiler

SELECT
  c0_.slug AS slug_0,
  c0_.dispatch_priority AS dispatch_priority_1,
  c0_.payment_control AS payment_control_2,
  c0_.marker_installation_payment_control AS marker_installation_payment_control_3,
  c0_.aggregate_values AS aggregate_values_4,
  c0_.email_timing_setup AS email_timing_setup_5,
  c0_.customer_renewal_configuration AS customer_renewal_configuration_6,
  c0_.payment_config AS payment_config_7,
  c0_.payment_service AS payment_service_8,
  c0_.snow_overage_limit_reached AS snow_overage_limit_reached_9,
  c0_.id AS id_10,
  c0_.import_id AS import_id_11,
  c0_.name AS name_12,
  c0_.phone AS phone_13,
  c0_.fax AS fax_14,
  c0_.address AS address_15,
  c0_.url AS url_16,
  c0_.tax_number AS tax_number_17,
  c0_.tos AS tos_18,
  c0_.tos_eco AS tos_eco_19,
  c0_.tos_french AS tos_french_20,
  c0_.tos_eco_french AS tos_eco_french_21,
  c0_.smtp AS smtp_22,
  c0_.email_from AS email_from_23,
  c0_.email_from_name AS email_from_name_24,
  c0_.business_email AS business_email_25,
  c0_.scalar_config AS scalar_config_26,
  c0_.commercial_settings AS commercial_settings_27,
  c0_.subscription_id AS subscription_id_28,
  c0_.owner_id AS owner_id_29,
  c0_.default_tax_id AS default_tax_id_30,
  c0_.favorite_status_id AS favorite_status_id_31,
  c0_.favorite_season_id AS favorite_season_id_32,
  c0_.favorite_obstruction_reason_id AS favorite_obstruction_reason_id_33,
  c0_.parent_company_id AS parent_company_id_34,
  c0_.snow_overage_charge_category_id AS snow_overage_charge_category_id_35,
  c0_.twili_config_id AS twili_config_id_36,
  c0_.file_collection_id AS file_collection_id_37
FROM
  company c0_
WHERE
  c0_.slug = ?
LIMIT
  1

SELECT c0_.slug AS slug_0, c0_.dispatch_priority AS dispatch_priority_1, c0_.payment_control AS payment_control_2, c0_.marker_installation_payment_control AS marker_installation_payment_control_3, c0_.aggregate_values AS aggregate_values_4, c0_.email_timing_setup AS email_timing_setup_5, c0_.customer_renewal_configuration AS customer_renewal_configuration_6, c0_.payment_config AS payment_config_7, c0_.payment_service AS payment_service_8, c0_.snow_overage_limit_reached AS snow_overage_limit_reached_9, c0_.id AS id_10, c0_.import_id AS import_id_11, c0_.name AS name_12, c0_.phone AS phone_13, c0_.fax AS fax_14, c0_.address AS address_15, c0_.url AS url_16, c0_.tax_number AS tax_number_17, c0_.tos AS tos_18, c0_.tos_eco AS tos_eco_19, c0_.tos_french AS tos_french_20, c0_.tos_eco_french AS tos_eco_french_21, c0_.smtp AS smtp_22, c0_.email_from AS email_from_23, c0_.email_from_name AS email_from_name_24, c0_.business_email AS business_email_25, c0_.scalar_config AS scalar_config_26, c0_.commercial_settings AS commercial_settings_27, c0_.subscription_id AS subscription_id_28, c0_.owner_id AS owner_id_29, c0_.default_tax_id AS default_tax_id_30, c0_.favorite_status_id AS favorite_status_id_31, c0_.favorite_season_id AS favorite_season_id_32, c0_.favorite_obstruction_reason_id AS favorite_obstruction_reason_id_33, c0_.parent_company_id AS parent_company_id_34, c0_.snow_overage_charge_category_id AS snow_overage_charge_category_id_35, c0_.twili_config_id AS twili_config_id_36, c0_.file_collection_id AS file_collection_id_37 FROM company c0_ WHERE c0_.slug = 'ksr' LIMIT 1;

SELECT
  t0.slug AS slug_1,
  t0.dispatch_priority AS dispatch_priority_2,
  t0.payment_control AS payment_control_3,
  t0.marker_installation_payment_control AS marker_installation_payment_control_4,
  t0.aggregate_values AS aggregate_values_5,
  t0.email_timing_setup AS email_timing_setup_6,
  t0.customer_renewal_configuration AS customer_renewal_configuration_7,
  t0.payment_config AS payment_config_8,
  t0.payment_service AS payment_service_9,
  t0.snow_overage_limit_reached AS snow_overage_limit_reached_10,
  t0.id AS id_11,
  t0.import_id AS import_id_12,
  t0.name AS name_13,
  t0.phone AS phone_14,
  t0.fax AS fax_15,
  t0.address AS address_16,
  t0.url AS url_17,
  t0.tax_number AS tax_number_18,
  t0.tos AS tos_19,
  t0.tos_eco AS tos_eco_20,
  t0.tos_french AS tos_french_21,
  t0.tos_eco_french AS tos_eco_french_22,
  t0.smtp AS smtp_23,
  t0.email_from AS email_from_24,
  t0.email_from_name AS email_from_name_25,
  t0.business_email AS business_email_26,
  t0.scalar_config AS scalar_config_27,
  t0.commercial_settings AS commercial_settings_28,
  t0.subscription_id AS subscription_id_29,
  t0.owner_id AS owner_id_30,
  t0.default_tax_id AS default_tax_id_31,
  t0.favorite_status_id AS favorite_status_id_32,
  t0.favorite_season_id AS favorite_season_id_33,
  t0.favorite_obstruction_reason_id AS favorite_obstruction_reason_id_34,
  t0.parent_company_id AS parent_company_id_35,
  t36.slug AS slug_37,
  t36.dispatch_priority AS dispatch_priority_38,
  t36.payment_control AS payment_control_39,
  t36.marker_installation_payment_control AS marker_installation_payment_control_40,
  t36.aggregate_values AS aggregate_values_41,
  t36.email_timing_setup AS email_timing_setup_42,
  t36.customer_renewal_configuration AS customer_renewal_configuration_43,
  t36.payment_config AS payment_config_44,
  t36.payment_service AS payment_service_45,
  t36.snow_overage_limit_reached AS snow_overage_limit_reached_46,
  t36.id AS id_47,
  t36.import_id AS import_id_48,
  t36.name AS name_49,
  t36.phone AS phone_50,
  t36.fax AS fax_51,
  t36.address AS address_52,
  t36.url AS url_53,
  t36.tax_number AS tax_number_54,
  t36.tos AS tos_55,
  t36.tos_eco AS tos_eco_56,
  t36.tos_french AS tos_french_57,
  t36.tos_eco_french AS tos_eco_french_58,
  t36.smtp AS smtp_59,
  t36.email_from AS email_from_60,
  t36.email_from_name AS email_from_name_61,
  t36.business_email AS business_email_62,
  t36.scalar_config AS scalar_config_63,
  t36.commercial_settings AS commercial_settings_64,
  t36.subscription_id AS subscription_id_65,
  t36.owner_id AS owner_id_66,
  t36.default_tax_id AS default_tax_id_67,
  t36.favorite_status_id AS favorite_status_id_68,
  t36.favorite_season_id AS favorite_season_id_69,
  t36.favorite_obstruction_reason_id AS favorite_obstruction_reason_id_70,
  t36.parent_company_id AS parent_company_id_71,
  t36.snow_overage_charge_category_id AS snow_overage_charge_category_id_72,
  t36.twili_config_id AS twili_config_id_73,
  t36.file_collection_id AS file_collection_id_74,
  t0.snow_overage_charge_category_id AS snow_overage_charge_category_id_75,
  t0.twili_config_id AS twili_config_id_76,
  t77.sid AS sid_78,
  t77.token AS token_79,
  t77.phone_number AS phone_number_80,
  t77.send_batches AS send_batches_81,
  t77.send_for_completed_address AS send_for_completed_address_82,
  t77.send_for_obstructed_address AS send_for_obstructed_address_83,
  t77.batches_text AS batches_text_84,
  t77.completed_address_text AS completed_address_text_85,
  t77.obstructed_address_text AS obstructed_address_text_86,
  t77.id AS id_87,
  t0.file_collection_id AS file_collection_id_88
FROM
  company t0
  LEFT JOIN company t36 ON t0.parent_company_id = t36.id
  LEFT JOIN twilio_config t77 ON t0.twili_config_id = t77.id
WHERE
  t0.id IN (?)

SELECT t0.slug AS slug_1, t0.dispatch_priority AS dispatch_priority_2, t0.payment_control AS payment_control_3, t0.marker_installation_payment_control AS marker_installation_payment_control_4, t0.aggregate_values AS aggregate_values_5, t0.email_timing_setup AS email_timing_setup_6, t0.customer_renewal_configuration AS customer_renewal_configuration_7, t0.payment_config AS payment_config_8, t0.payment_service AS payment_service_9, t0.snow_overage_limit_reached AS snow_overage_limit_reached_10, t0.id AS id_11, t0.import_id AS import_id_12, t0.name AS name_13, t0.phone AS phone_14, t0.fax AS fax_15, t0.address AS address_16, t0.url AS url_17, t0.tax_number AS tax_number_18, t0.tos AS tos_19, t0.tos_eco AS tos_eco_20, t0.tos_french AS tos_french_21, t0.tos_eco_french AS tos_eco_french_22, t0.smtp AS smtp_23, t0.email_from AS email_from_24, t0.email_from_name AS email_from_name_25, t0.business_email AS business_email_26, t0.scalar_config AS scalar_config_27, t0.commercial_settings AS commercial_settings_28, t0.subscription_id AS subscription_id_29, t0.owner_id AS owner_id_30, t0.default_tax_id AS default_tax_id_31, t0.favorite_status_id AS favorite_status_id_32, t0.favorite_season_id AS favorite_season_id_33, t0.favorite_obstruction_reason_id AS favorite_obstruction_reason_id_34, t0.parent_company_id AS parent_company_id_35, t36.slug AS slug_37, t36.dispatch_priority AS dispatch_priority_38, t36.payment_control AS payment_control_39, t36.marker_installation_payment_control AS marker_installation_payment_control_40, t36.aggregate_values AS aggregate_values_41, t36.email_timing_setup AS email_timing_setup_42, t36.customer_renewal_configuration AS customer_renewal_configuration_43, t36.payment_config AS payment_config_44, t36.payment_service AS payment_service_45, t36.snow_overage_limit_reached AS snow_overage_limit_reached_46, t36.id AS id_47, t36.import_id AS import_id_48, t36.name AS name_49, t36.phone AS phone_50, t36.fax AS fax_51, t36.address AS address_52, t36.url AS url_53, t36.tax_number AS tax_number_54, t36.tos AS tos_55, t36.tos_eco AS tos_eco_56, t36.tos_french AS tos_french_57, t36.tos_eco_french AS tos_eco_french_58, t36.smtp AS smtp_59, t36.email_from AS email_from_60, t36.email_from_name AS email_from_name_61, t36.business_email AS business_email_62, t36.scalar_config AS scalar_config_63, t36.commercial_settings AS commercial_settings_64, t36.subscription_id AS subscription_id_65, t36.owner_id AS owner_id_66, t36.default_tax_id AS default_tax_id_67, t36.favorite_status_id AS favorite_status_id_68, t36.favorite_season_id AS favorite_season_id_69, t36.favorite_obstruction_reason_id AS favorite_obstruction_reason_id_70, t36.parent_company_id AS parent_company_id_71, t36.snow_overage_charge_category_id AS snow_overage_charge_category_id_72, t36.twili_config_id AS twili_config_id_73, t36.file_collection_id AS file_collection_id_74, t0.snow_overage_charge_category_id AS snow_overage_charge_category_id_75, t0.twili_config_id AS twili_config_id_76, t77.sid AS sid_78, t77.token AS token_79, t77.phone_number AS phone_number_80, t77.send_batches AS send_batches_81, t77.send_for_completed_address AS send_for_completed_address_82, t77.send_for_obstructed_address AS send_for_obstructed_address_83, t77.batches_text AS batches_text_84, t77.completed_address_text AS completed_address_text_85, t77.obstructed_address_text AS obstructed_address_text_86, t77.id AS id_87, t0.file_collection_id AS file_collection_id_88 FROM company t0 LEFT JOIN company t36 ON t0.parent_company_id = t36.id LEFT JOIN twilio_config t77 ON t0.twili_config_id = t77.id WHERE t0.id IN ('fec5fd77-f624-47f9-baa4-14eaa335ab87');

SELECT
  t0.sid AS sid_1,
  t0.token AS token_2,
  t0.phone_number AS phone_number_3,
  t0.send_batches AS send_batches_4,
  t0.send_for_completed_address AS send_for_completed_address_5,
  t0.send_for_obstructed_address AS send_for_obstructed_address_6,
  t0.batches_text AS batches_text_7,
  t0.completed_address_text AS completed_address_text_8,
  t0.obstructed_address_text AS obstructed_address_text_9,
  t0.id AS id_10
FROM
  twilio_config t0
WHERE
  t0.id IN (?)

SELECT t0.sid AS sid_1, t0.token AS token_2, t0.phone_number AS phone_number_3, t0.send_batches AS send_batches_4, t0.send_for_completed_address AS send_for_completed_address_5, t0.send_for_obstructed_address AS send_for_obstructed_address_6, t0.batches_text AS batches_text_7, t0.completed_address_text AS completed_address_text_8, t0.obstructed_address_text AS obstructed_address_text_9, t0.id AS id_10 FROM twilio_config t0 WHERE t0.id IN ('70f72994-58c1-4825-8e95-9cae9eaf5547');

SELECT
  t0.slug AS slug_1,
  t0.dispatch_priority AS dispatch_priority_2,
  t0.payment_control AS payment_control_3,
  t0.marker_installation_payment_control AS marker_installation_payment_control_4,
  t0.aggregate_values AS aggregate_values_5,
  t0.email_timing_setup AS email_timing_setup_6,
  t0.customer_renewal_configuration AS customer_renewal_configuration_7,
  t0.payment_config AS payment_config_8,
  t0.payment_service AS payment_service_9,
  t0.snow_overage_limit_reached AS snow_overage_limit_reached_10,
  t0.id AS id_11,
  t0.import_id AS import_id_12,
  t0.name AS name_13,
  t0.phone AS phone_14,
  t0.fax AS fax_15,
  t0.address AS address_16,
  t0.url AS url_17,
  t0.tax_number AS tax_number_18,
  t0.tos AS tos_19,
  t0.tos_eco AS tos_eco_20,
  t0.tos_french AS tos_french_21,
  t0.tos_eco_french AS tos_eco_french_22,
  t0.smtp AS smtp_23,
  t0.email_from AS email_from_24,
  t0.email_from_name AS email_from_name_25,
  t0.business_email AS business_email_26,
  t0.scalar_config AS scalar_config_27,
  t0.commercial_settings AS commercial_settings_28,
  t0.subscription_id AS subscription_id_29,
  t0.owner_id AS owner_id_30,
  t0.default_tax_id AS default_tax_id_31,
  t0.favorite_status_id AS favorite_status_id_32,
  t0.favorite_season_id AS favorite_season_id_33,
  t0.favorite_obstruction_reason_id AS favorite_obstruction_reason_id_34,
  t0.parent_company_id AS parent_company_id_35,
  t36.slug AS slug_37,
  t36.dispatch_priority AS dispatch_priority_38,
  t36.payment_control AS payment_control_39,
  t36.marker_installation_payment_control AS marker_installation_payment_control_40,
  t36.aggregate_values AS aggregate_values_41,
  t36.email_timing_setup AS email_timing_setup_42,
  t36.customer_renewal_configuration AS customer_renewal_configuration_43,
  t36.payment_config AS payment_config_44,
  t36.payment_service AS payment_service_45,
  t36.snow_overage_limit_reached AS snow_overage_limit_reached_46,
  t36.id AS id_47,
  t36.import_id AS import_id_48,
  t36.name AS name_49,
  t36.phone AS phone_50,
  t36.fax AS fax_51,
  t36.address AS address_52,
  t36.url AS url_53,
  t36.tax_number AS tax_number_54,
  t36.tos AS tos_55,
  t36.tos_eco AS tos_eco_56,
  t36.tos_french AS tos_french_57,
  t36.tos_eco_french AS tos_eco_french_58,
  t36.smtp AS smtp_59,
  t36.email_from AS email_from_60,
  t36.email_from_name AS email_from_name_61,
  t36.business_email AS business_email_62,
  t36.scalar_config AS scalar_config_63,
  t36.commercial_settings AS commercial_settings_64,
  t36.subscription_id AS subscription_id_65,
  t36.owner_id AS owner_id_66,
  t36.default_tax_id AS default_tax_id_67,
  t36.favorite_status_id AS favorite_status_id_68,
  t36.favorite_season_id AS favorite_season_id_69,
  t36.favorite_obstruction_reason_id AS favorite_obstruction_reason_id_70,
  t36.parent_company_id AS parent_company_id_71,
  t36.snow_overage_charge_category_id AS snow_overage_charge_category_id_72,
  t36.twili_config_id AS twili_config_id_73,
  t36.file_collection_id AS file_collection_id_74,
  t0.snow_overage_charge_category_id AS snow_overage_charge_category_id_75,
  t0.twili_config_id AS twili_config_id_76,
  t77.sid AS sid_78,
  t77.token AS token_79,
  t77.phone_number AS phone_number_80,
  t77.send_batches AS send_batches_81,
  t77.send_for_completed_address AS send_for_completed_address_82,
  t77.send_for_obstructed_address AS send_for_obstructed_address_83,
  t77.batches_text AS batches_text_84,
  t77.completed_address_text AS completed_address_text_85,
  t77.obstructed_address_text AS obstructed_address_text_86,
  t77.id AS id_87,
  t0.file_collection_id AS file_collection_id_88
FROM
  company t0
  LEFT JOIN company t36 ON t0.parent_company_id = t36.id
  LEFT JOIN twilio_config t77 ON t0.twili_config_id = t77.id
WHERE
  t0.parent_company_id = ?

SELECT t0.slug AS slug_1, t0.dispatch_priority AS dispatch_priority_2, t0.payment_control AS payment_control_3, t0.marker_installation_payment_control AS marker_installation_payment_control_4, t0.aggregate_values AS aggregate_values_5, t0.email_timing_setup AS email_timing_setup_6, t0.customer_renewal_configuration AS customer_renewal_configuration_7, t0.payment_config AS payment_config_8, t0.payment_service AS payment_service_9, t0.snow_overage_limit_reached AS snow_overage_limit_reached_10, t0.id AS id_11, t0.import_id AS import_id_12, t0.name AS name_13, t0.phone AS phone_14, t0.fax AS fax_15, t0.address AS address_16, t0.url AS url_17, t0.tax_number AS tax_number_18, t0.tos AS tos_19, t0.tos_eco AS tos_eco_20, t0.tos_french AS tos_french_21, t0.tos_eco_french AS tos_eco_french_22, t0.smtp AS smtp_23, t0.email_from AS email_from_24, t0.email_from_name AS email_from_name_25, t0.business_email AS business_email_26, t0.scalar_config AS scalar_config_27, t0.commercial_settings AS commercial_settings_28, t0.subscription_id AS subscription_id_29, t0.owner_id AS owner_id_30, t0.default_tax_id AS default_tax_id_31, t0.favorite_status_id AS favorite_status_id_32, t0.favorite_season_id AS favorite_season_id_33, t0.favorite_obstruction_reason_id AS favorite_obstruction_reason_id_34, t0.parent_company_id AS parent_company_id_35, t36.slug AS slug_37, t36.dispatch_priority AS dispatch_priority_38, t36.payment_control AS payment_control_39, t36.marker_installation_payment_control AS marker_installation_payment_control_40, t36.aggregate_values AS aggregate_values_41, t36.email_timing_setup AS email_timing_setup_42, t36.customer_renewal_configuration AS customer_renewal_configuration_43, t36.payment_config AS payment_config_44, t36.payment_service AS payment_service_45, t36.snow_overage_limit_reached AS snow_overage_limit_reached_46, t36.id AS id_47, t36.import_id AS import_id_48, t36.name AS name_49, t36.phone AS phone_50, t36.fax AS fax_51, t36.address AS address_52, t36.url AS url_53, t36.tax_number AS tax_number_54, t36.tos AS tos_55, t36.tos_eco AS tos_eco_56, t36.tos_french AS tos_french_57, t36.tos_eco_french AS tos_eco_french_58, t36.smtp AS smtp_59, t36.email_from AS email_from_60, t36.email_from_name AS email_from_name_61, t36.business_email AS business_email_62, t36.scalar_config AS scalar_config_63, t36.commercial_settings AS commercial_settings_64, t36.subscription_id AS subscription_id_65, t36.owner_id AS owner_id_66, t36.default_tax_id AS default_tax_id_67, t36.favorite_status_id AS favorite_status_id_68, t36.favorite_season_id AS favorite_season_id_69, t36.favorite_obstruction_reason_id AS favorite_obstruction_reason_id_70, t36.parent_company_id AS parent_company_id_71, t36.snow_overage_charge_category_id AS snow_overage_charge_category_id_72, t36.twili_config_id AS twili_config_id_73, t36.file_collection_id AS file_collection_id_74, t0.snow_overage_charge_category_id AS snow_overage_charge_category_id_75, t0.twili_config_id AS twili_config_id_76, t77.sid AS sid_78, t77.token AS token_79, t77.phone_number AS phone_number_80, t77.send_batches AS send_batches_81, t77.send_for_completed_address AS send_for_completed_address_82, t77.send_for_obstructed_address AS send_for_obstructed_address_83, t77.batches_text AS batches_text_84, t77.completed_address_text AS completed_address_text_85, t77.obstructed_address_text AS obstructed_address_text_86, t77.id AS id_87, t0.file_collection_id AS file_collection_id_88 FROM company t0 LEFT JOIN company t36 ON t0.parent_company_id = t36.id LEFT JOIN twilio_config t77 ON t0.twili_config_id = t77.id WHERE t0.parent_company_id = '8438b66a-48ec-423d-9eeb-dde42bb256af';