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_french AS tos_french_19,
  c0_.smtp AS smtp_20,
  c0_.email_from AS email_from_21,
  c0_.email_from_name AS email_from_name_22,
  c0_.business_email AS business_email_23,
  c0_.scalar_config AS scalar_config_24,
  c0_.commercial_settings AS commercial_settings_25,
  c0_.subscription_id AS subscription_id_26,
  c0_.owner_id AS owner_id_27,
  c0_.default_tax_id AS default_tax_id_28,
  c0_.favorite_status_id AS favorite_status_id_29,
  c0_.favorite_season_id AS favorite_season_id_30,
  c0_.favorite_obstruction_reason_id AS favorite_obstruction_reason_id_31,
  c0_.parent_company_id AS parent_company_id_32,
  c0_.snow_overage_charge_category_id AS snow_overage_charge_category_id_33,
  c0_.twili_config_id AS twili_config_id_34,
  c0_.file_collection_id AS file_collection_id_35
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_french AS tos_french_19, c0_.smtp AS smtp_20, c0_.email_from AS email_from_21, c0_.email_from_name AS email_from_name_22, c0_.business_email AS business_email_23, c0_.scalar_config AS scalar_config_24, c0_.commercial_settings AS commercial_settings_25, c0_.subscription_id AS subscription_id_26, c0_.owner_id AS owner_id_27, c0_.default_tax_id AS default_tax_id_28, c0_.favorite_status_id AS favorite_status_id_29, c0_.favorite_season_id AS favorite_season_id_30, c0_.favorite_obstruction_reason_id AS favorite_obstruction_reason_id_31, c0_.parent_company_id AS parent_company_id_32, c0_.snow_overage_charge_category_id AS snow_overage_charge_category_id_33, c0_.twili_config_id AS twili_config_id_34, c0_.file_collection_id AS file_collection_id_35 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_french AS tos_french_20,
  t0.smtp AS smtp_21,
  t0.email_from AS email_from_22,
  t0.email_from_name AS email_from_name_23,
  t0.business_email AS business_email_24,
  t0.scalar_config AS scalar_config_25,
  t0.commercial_settings AS commercial_settings_26,
  t0.subscription_id AS subscription_id_27,
  t0.owner_id AS owner_id_28,
  t0.default_tax_id AS default_tax_id_29,
  t0.favorite_status_id AS favorite_status_id_30,
  t0.favorite_season_id AS favorite_season_id_31,
  t0.favorite_obstruction_reason_id AS favorite_obstruction_reason_id_32,
  t0.parent_company_id AS parent_company_id_33,
  t34.slug AS slug_35,
  t34.dispatch_priority AS dispatch_priority_36,
  t34.payment_control AS payment_control_37,
  t34.marker_installation_payment_control AS marker_installation_payment_control_38,
  t34.aggregate_values AS aggregate_values_39,
  t34.email_timing_setup AS email_timing_setup_40,
  t34.customer_renewal_configuration AS customer_renewal_configuration_41,
  t34.payment_config AS payment_config_42,
  t34.payment_service AS payment_service_43,
  t34.snow_overage_limit_reached AS snow_overage_limit_reached_44,
  t34.id AS id_45,
  t34.import_id AS import_id_46,
  t34.name AS name_47,
  t34.phone AS phone_48,
  t34.fax AS fax_49,
  t34.address AS address_50,
  t34.url AS url_51,
  t34.tax_number AS tax_number_52,
  t34.tos AS tos_53,
  t34.tos_french AS tos_french_54,
  t34.smtp AS smtp_55,
  t34.email_from AS email_from_56,
  t34.email_from_name AS email_from_name_57,
  t34.business_email AS business_email_58,
  t34.scalar_config AS scalar_config_59,
  t34.commercial_settings AS commercial_settings_60,
  t34.subscription_id AS subscription_id_61,
  t34.owner_id AS owner_id_62,
  t34.default_tax_id AS default_tax_id_63,
  t34.favorite_status_id AS favorite_status_id_64,
  t34.favorite_season_id AS favorite_season_id_65,
  t34.favorite_obstruction_reason_id AS favorite_obstruction_reason_id_66,
  t34.parent_company_id AS parent_company_id_67,
  t34.snow_overage_charge_category_id AS snow_overage_charge_category_id_68,
  t34.twili_config_id AS twili_config_id_69,
  t34.file_collection_id AS file_collection_id_70,
  t0.snow_overage_charge_category_id AS snow_overage_charge_category_id_71,
  t0.twili_config_id AS twili_config_id_72,
  t73.sid AS sid_74,
  t73.token AS token_75,
  t73.phone_number AS phone_number_76,
  t73.send_batches AS send_batches_77,
  t73.send_for_completed_address AS send_for_completed_address_78,
  t73.send_for_obstructed_address AS send_for_obstructed_address_79,
  t73.batches_text AS batches_text_80,
  t73.completed_address_text AS completed_address_text_81,
  t73.obstructed_address_text AS obstructed_address_text_82,
  t73.id AS id_83,
  t0.file_collection_id AS file_collection_id_84
FROM
  company t0
  LEFT JOIN company t34 ON t0.parent_company_id = t34.id
  LEFT JOIN twilio_config t73 ON t0.twili_config_id = t73.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_french AS tos_french_20, t0.smtp AS smtp_21, t0.email_from AS email_from_22, t0.email_from_name AS email_from_name_23, t0.business_email AS business_email_24, t0.scalar_config AS scalar_config_25, t0.commercial_settings AS commercial_settings_26, t0.subscription_id AS subscription_id_27, t0.owner_id AS owner_id_28, t0.default_tax_id AS default_tax_id_29, t0.favorite_status_id AS favorite_status_id_30, t0.favorite_season_id AS favorite_season_id_31, t0.favorite_obstruction_reason_id AS favorite_obstruction_reason_id_32, t0.parent_company_id AS parent_company_id_33, t34.slug AS slug_35, t34.dispatch_priority AS dispatch_priority_36, t34.payment_control AS payment_control_37, t34.marker_installation_payment_control AS marker_installation_payment_control_38, t34.aggregate_values AS aggregate_values_39, t34.email_timing_setup AS email_timing_setup_40, t34.customer_renewal_configuration AS customer_renewal_configuration_41, t34.payment_config AS payment_config_42, t34.payment_service AS payment_service_43, t34.snow_overage_limit_reached AS snow_overage_limit_reached_44, t34.id AS id_45, t34.import_id AS import_id_46, t34.name AS name_47, t34.phone AS phone_48, t34.fax AS fax_49, t34.address AS address_50, t34.url AS url_51, t34.tax_number AS tax_number_52, t34.tos AS tos_53, t34.tos_french AS tos_french_54, t34.smtp AS smtp_55, t34.email_from AS email_from_56, t34.email_from_name AS email_from_name_57, t34.business_email AS business_email_58, t34.scalar_config AS scalar_config_59, t34.commercial_settings AS commercial_settings_60, t34.subscription_id AS subscription_id_61, t34.owner_id AS owner_id_62, t34.default_tax_id AS default_tax_id_63, t34.favorite_status_id AS favorite_status_id_64, t34.favorite_season_id AS favorite_season_id_65, t34.favorite_obstruction_reason_id AS favorite_obstruction_reason_id_66, t34.parent_company_id AS parent_company_id_67, t34.snow_overage_charge_category_id AS snow_overage_charge_category_id_68, t34.twili_config_id AS twili_config_id_69, t34.file_collection_id AS file_collection_id_70, t0.snow_overage_charge_category_id AS snow_overage_charge_category_id_71, t0.twili_config_id AS twili_config_id_72, t73.sid AS sid_74, t73.token AS token_75, t73.phone_number AS phone_number_76, t73.send_batches AS send_batches_77, t73.send_for_completed_address AS send_for_completed_address_78, t73.send_for_obstructed_address AS send_for_obstructed_address_79, t73.batches_text AS batches_text_80, t73.completed_address_text AS completed_address_text_81, t73.obstructed_address_text AS obstructed_address_text_82, t73.id AS id_83, t0.file_collection_id AS file_collection_id_84 FROM company t0 LEFT JOIN company t34 ON t0.parent_company_id = t34.id LEFT JOIN twilio_config t73 ON t0.twili_config_id = t73.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_french AS tos_french_20,
  t0.smtp AS smtp_21,
  t0.email_from AS email_from_22,
  t0.email_from_name AS email_from_name_23,
  t0.business_email AS business_email_24,
  t0.scalar_config AS scalar_config_25,
  t0.commercial_settings AS commercial_settings_26,
  t0.subscription_id AS subscription_id_27,
  t0.owner_id AS owner_id_28,
  t0.default_tax_id AS default_tax_id_29,
  t0.favorite_status_id AS favorite_status_id_30,
  t0.favorite_season_id AS favorite_season_id_31,
  t0.favorite_obstruction_reason_id AS favorite_obstruction_reason_id_32,
  t0.parent_company_id AS parent_company_id_33,
  t34.slug AS slug_35,
  t34.dispatch_priority AS dispatch_priority_36,
  t34.payment_control AS payment_control_37,
  t34.marker_installation_payment_control AS marker_installation_payment_control_38,
  t34.aggregate_values AS aggregate_values_39,
  t34.email_timing_setup AS email_timing_setup_40,
  t34.customer_renewal_configuration AS customer_renewal_configuration_41,
  t34.payment_config AS payment_config_42,
  t34.payment_service AS payment_service_43,
  t34.snow_overage_limit_reached AS snow_overage_limit_reached_44,
  t34.id AS id_45,
  t34.import_id AS import_id_46,
  t34.name AS name_47,
  t34.phone AS phone_48,
  t34.fax AS fax_49,
  t34.address AS address_50,
  t34.url AS url_51,
  t34.tax_number AS tax_number_52,
  t34.tos AS tos_53,
  t34.tos_french AS tos_french_54,
  t34.smtp AS smtp_55,
  t34.email_from AS email_from_56,
  t34.email_from_name AS email_from_name_57,
  t34.business_email AS business_email_58,
  t34.scalar_config AS scalar_config_59,
  t34.commercial_settings AS commercial_settings_60,
  t34.subscription_id AS subscription_id_61,
  t34.owner_id AS owner_id_62,
  t34.default_tax_id AS default_tax_id_63,
  t34.favorite_status_id AS favorite_status_id_64,
  t34.favorite_season_id AS favorite_season_id_65,
  t34.favorite_obstruction_reason_id AS favorite_obstruction_reason_id_66,
  t34.parent_company_id AS parent_company_id_67,
  t34.snow_overage_charge_category_id AS snow_overage_charge_category_id_68,
  t34.twili_config_id AS twili_config_id_69,
  t34.file_collection_id AS file_collection_id_70,
  t0.snow_overage_charge_category_id AS snow_overage_charge_category_id_71,
  t0.twili_config_id AS twili_config_id_72,
  t73.sid AS sid_74,
  t73.token AS token_75,
  t73.phone_number AS phone_number_76,
  t73.send_batches AS send_batches_77,
  t73.send_for_completed_address AS send_for_completed_address_78,
  t73.send_for_obstructed_address AS send_for_obstructed_address_79,
  t73.batches_text AS batches_text_80,
  t73.completed_address_text AS completed_address_text_81,
  t73.obstructed_address_text AS obstructed_address_text_82,
  t73.id AS id_83,
  t0.file_collection_id AS file_collection_id_84
FROM
  company t0
  LEFT JOIN company t34 ON t0.parent_company_id = t34.id
  LEFT JOIN twilio_config t73 ON t0.twili_config_id = t73.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_french AS tos_french_20, t0.smtp AS smtp_21, t0.email_from AS email_from_22, t0.email_from_name AS email_from_name_23, t0.business_email AS business_email_24, t0.scalar_config AS scalar_config_25, t0.commercial_settings AS commercial_settings_26, t0.subscription_id AS subscription_id_27, t0.owner_id AS owner_id_28, t0.default_tax_id AS default_tax_id_29, t0.favorite_status_id AS favorite_status_id_30, t0.favorite_season_id AS favorite_season_id_31, t0.favorite_obstruction_reason_id AS favorite_obstruction_reason_id_32, t0.parent_company_id AS parent_company_id_33, t34.slug AS slug_35, t34.dispatch_priority AS dispatch_priority_36, t34.payment_control AS payment_control_37, t34.marker_installation_payment_control AS marker_installation_payment_control_38, t34.aggregate_values AS aggregate_values_39, t34.email_timing_setup AS email_timing_setup_40, t34.customer_renewal_configuration AS customer_renewal_configuration_41, t34.payment_config AS payment_config_42, t34.payment_service AS payment_service_43, t34.snow_overage_limit_reached AS snow_overage_limit_reached_44, t34.id AS id_45, t34.import_id AS import_id_46, t34.name AS name_47, t34.phone AS phone_48, t34.fax AS fax_49, t34.address AS address_50, t34.url AS url_51, t34.tax_number AS tax_number_52, t34.tos AS tos_53, t34.tos_french AS tos_french_54, t34.smtp AS smtp_55, t34.email_from AS email_from_56, t34.email_from_name AS email_from_name_57, t34.business_email AS business_email_58, t34.scalar_config AS scalar_config_59, t34.commercial_settings AS commercial_settings_60, t34.subscription_id AS subscription_id_61, t34.owner_id AS owner_id_62, t34.default_tax_id AS default_tax_id_63, t34.favorite_status_id AS favorite_status_id_64, t34.favorite_season_id AS favorite_season_id_65, t34.favorite_obstruction_reason_id AS favorite_obstruction_reason_id_66, t34.parent_company_id AS parent_company_id_67, t34.snow_overage_charge_category_id AS snow_overage_charge_category_id_68, t34.twili_config_id AS twili_config_id_69, t34.file_collection_id AS file_collection_id_70, t0.snow_overage_charge_category_id AS snow_overage_charge_category_id_71, t0.twili_config_id AS twili_config_id_72, t73.sid AS sid_74, t73.token AS token_75, t73.phone_number AS phone_number_76, t73.send_batches AS send_batches_77, t73.send_for_completed_address AS send_for_completed_address_78, t73.send_for_obstructed_address AS send_for_obstructed_address_79, t73.batches_text AS batches_text_80, t73.completed_address_text AS completed_address_text_81, t73.obstructed_address_text AS obstructed_address_text_82, t73.id AS id_83, t0.file_collection_id AS file_collection_id_84 FROM company t0 LEFT JOIN company t34 ON t0.parent_company_id = t34.id LEFT JOIN twilio_config t73 ON t0.twili_config_id = t73.id WHERE t0.parent_company_id = '8438b66a-48ec-423d-9eeb-dde42bb256af';