Symfony Profiler

SELECT
  t0.username AS username_1,
  t0.username_canonical AS username_canonical_2,
  t0.email AS email_3,
  t0.email_canonical AS email_canonical_4,
  t0.enabled AS enabled_5,
  t0.salt AS salt_6,
  t0.password AS password_7,
  t0.last_login AS last_login_8,
  t0.confirmation_token AS confirmation_token_9,
  t0.password_requested_at AS password_requested_at_10,
  t0.roles AS roles_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.id AS id_14,
  t0.two_step_code AS two_step_code_15,
  t0.date_of_birth AS date_of_birth_16,
  t0.firstname AS firstname_17,
  t0.lastname AS lastname_18,
  t0.website AS website_19,
  t0.biography AS biography_20,
  t0.gender AS gender_21,
  t0.locale AS locale_22,
  t0.timezone AS timezone_23,
  t0.phone AS phone_24,
  t0.facebook_uid AS facebook_uid_25,
  t0.facebook_name AS facebook_name_26,
  t0.facebook_data AS facebook_data_27,
  t0.twitter_uid AS twitter_uid_28,
  t0.twitter_name AS twitter_name_29,
  t0.twitter_data AS twitter_data_30,
  t0.gplus_uid AS gplus_uid_31,
  t0.gplus_name AS gplus_name_32,
  t0.gplus_data AS gplus_data_33,
  t0.token AS token_34,
  t0.api_key AS api_key_35,
  t0.allow_ips_to_login AS allow_ips_to_login_36,
  t0.device_id AS device_id_37,
  t0.device_uid AS device_uid_38,
  t0.device_xid AS device_xid_39,
  t0.device_application_name AS device_application_name_40,
  t0.device_application_version AS device_application_version_41,
  t0.device_model AS device_model_42,
  t0.device_product AS device_product_43,
  t0.device_type AS device_type_44,
  t0.device_vendor AS device_vendor_45,
  t0.device_os_api_version AS device_os_api_version_46,
  t0.device_os_type AS device_os_type_47,
  t0.device_os_version AS device_os_version_48,
  t0.device_sandbox AS device_sandbox_49,
  t0.device_screen_density AS device_screen_density_50,
  t0.device_screen_height AS device_screen_height_51,
  t0.device_screen_orientation AS device_screen_orientation_52,
  t0.device_screen_width AS device_screen_width_53,
  t0.device_time_zone AS device_time_zone_54,
  t0.device_datetime AS device_datetime_55,
  t0.apple_uid AS apple_uid_56,
  t0.braintree_customer AS braintree_customer_57,
  t0.stripe_customer AS stripe_customer_58,
  t0.review_rating AS review_rating_59,
  t60.id AS id_61,
  t60.title AS title_62,
  t60.birth_date AS birth_date_63,
  t60.name AS name_64,
  t60.phone AS phone_65,
  t60.email AS email_66,
  t60.department AS department_67,
  t60.job_title AS job_title_68,
  t60.ba_address1 AS ba_address1_69,
  t60.ba_address2 AS ba_address2_70,
  t60.ba_door_number AS ba_door_number_71,
  t60.ba_store_apt AS ba_store_apt_72,
  t60.ba_city AS ba_city_73,
  t60.ba_postcode AS ba_postcode_74,
  t60.ba_country AS ba_country_75,
  t60.picture AS picture_76,
  t60.notes AS notes_77,
  t60.credit AS credit_78,
  t60.creation_date AS creation_date_79,
  t60.updated AS updated_80,
  t60.employer_name AS employer_name_81,
  t60.employer_phone AS employer_phone_82,
  t60.employer_type AS employer_type_83,
  t60.workplace_postcode AS workplace_postcode_84,
  t60.badge_proof_picture AS badge_proof_picture_85,
  t60.worker_voucher_usage AS worker_voucher_usage_86,
  t60.last_used_worker_voucher AS last_used_worker_voucher_87,
  t60.group_account_id AS group_account_id_88,
  t60.company_id AS company_id_89,
  t60.user_id AS user_id_90,
  t91.id AS id_92,
  t91.business_name AS business_name_93,
  t91.ref AS ref_94,
  t91.organization_name AS organization_name_95,
  t91.main_contact_name AS main_contact_name_96,
  t91.ba_address1 AS ba_address1_97,
  t91.ba_address2 AS ba_address2_98,
  t91.ba_door_number AS ba_door_number_99,
  t91.ba_store_apt AS ba_store_apt_100,
  t91.ba_city AS ba_city_101,
  t91.ba_postcode AS ba_postcode_102,
  t91.ba_country AS ba_country_103,
  t91.vat_id AS vat_id_104,
  t91.notes AS notes_105,
  t91.config_booking_emails AS config_booking_emails_106,
  t91.price_discount AS price_discount_107,
  t91.price_discount_fixed AS price_discount_fixed_108,
  t91.payment_type AS payment_type_109,
  t91.company_invoice_type AS company_invoice_type_110,
  t91.user_id AS user_id_111,
  t112.id AS id_113,
  t112.internal_name AS internal_name_114,
  t112.license AS license_115,
  t112.license_expire_date AS license_expire_date_116,
  t112.license_issue_date AS license_issue_date_117,
  t112.public_carriage_office_expiry_date AS public_carriage_office_expiry_date_118,
  t112.public_carriage_office_licence_number AS public_carriage_office_licence_number_119,
  t112.hack_license_expiration_date AS hack_license_expiration_date_120,
  t112.hack_license_number AS hack_license_number_121,
  t112.registration_date AS registration_date_122,
  t112.end_date AS end_date_123,
  t112.updated AS updated_124,
  t112.phone AS phone_125,
  t112.mobile_phone AS mobile_phone_126,
  t112.status AS status_127,
  t112.start_interval AS start_interval_128,
  t112.selected_start_interval AS selected_start_interval_129,
  t112.simple_status AS simple_status_130,
  t112.house_street_number AS house_street_number_131,
  t112.home_address_1 AS home_address_1_132,
  t112.home_address_2 AS home_address_2_133,
  t112.home_address_city AS home_address_city_134,
  t112.home_address_postcode AS home_address_postcode_135,
  t112.home_address_lat AS home_address_lat_136,
  t112.home_address_lng AS home_address_lng_137,
  t112.home_address_country AS home_address_country_138,
  t112.description AS description_139,
  t112.last_update_pozition AS last_update_pozition_140,
  t112.lat AS lat_141,
  t112.lng AS lng_142,
  t112.picture AS picture_143,
  t112.pco_license_file AS pco_license_file_144,
  t112.hack_license_file AS hack_license_file_145,
  t112.proof_of_right_to_work AS proof_of_right_to_work_146,
  t112.nino_file AS nino_file_147,
  t112.dbs_criminal_check_file AS dbs_criminal_check_file_148,
  t112.driver_agreement_file AS driver_agreement_file_149,
  t112.other_document AS other_document_150,
  t112.driver_licence_picture AS driver_licence_picture_151,
  t112.nationality AS nationality_152,
  t112.national_insurance_number AS national_insurance_number_153,
  t112.social_security_number AS social_security_number_154,
  t112.bank_society AS bank_society_155,
  t112.bank_sort_code AS bank_sort_code_156,
  t112.all_day_shift AS all_day_shift_157,
  t112.day_time_shift_start AS day_time_shift_start_158,
  t112.day_time_shift_end AS day_time_shift_end_159,
  t112.night_time_shift_start AS night_time_shift_start_160,
  t112.night_time_shift_end AS night_time_shift_end_161,
  t112.departure_location AS departure_location_162,
  t112.departure_location_lat AS departure_location_lat_163,
  t112.departure_location_lng AS departure_location_lng_164,
  t112.favorite_airport AS favorite_airport_165,
  t112.favorite_airport_lat AS favorite_airport_lat_166,
  t112.favorite_airport_lng AS favorite_airport_lng_167,
  t112.bank_account_number AS bank_account_number_168,
  t112.commission_office_up_to500 AS commission_office_up_to500_169,
  t112.commission_office_up_to1000 AS commission_office_up_to1000_170,
  t112.commission_office_up_to1500 AS commission_office_up_to1500_171,
  t112.commission_office_over1500 AS commission_office_over1500_172,
  t112.off_days AS off_days_173,
  t112.suspended_until_date AS suspended_until_date_174,
  t112.internal_reputation AS internal_reputation_175,
  t112.activity_reputation AS activity_reputation_176,
  t112.reputation_points AS reputation_points_177,
  t112.top_reputation_points AS top_reputation_points_178,
  t112.new_linked_booking_count AS new_linked_booking_count_179,
  t112.deactivated_until AS deactivated_until_180,
  t112.user_id AS user_id_181,
  t112.car_id AS car_id_182
FROM
  user t0
  LEFT JOIN account t60 ON t60.user_id = t0.id
  LEFT JOIN company t91 ON t91.user_id = t0.id
  LEFT JOIN driver t112 ON t112.user_id = t0.id
WHERE
  t0.api_key = ?
LIMIT
  1

SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.id AS id_14, t0.two_step_code AS two_step_code_15, t0.date_of_birth AS date_of_birth_16, t0.firstname AS firstname_17, t0.lastname AS lastname_18, t0.website AS website_19, t0.biography AS biography_20, t0.gender AS gender_21, t0.locale AS locale_22, t0.timezone AS timezone_23, t0.phone AS phone_24, t0.facebook_uid AS facebook_uid_25, t0.facebook_name AS facebook_name_26, t0.facebook_data AS facebook_data_27, t0.twitter_uid AS twitter_uid_28, t0.twitter_name AS twitter_name_29, t0.twitter_data AS twitter_data_30, t0.gplus_uid AS gplus_uid_31, t0.gplus_name AS gplus_name_32, t0.gplus_data AS gplus_data_33, t0.token AS token_34, t0.api_key AS api_key_35, t0.allow_ips_to_login AS allow_ips_to_login_36, t0.device_id AS device_id_37, t0.device_uid AS device_uid_38, t0.device_xid AS device_xid_39, t0.device_application_name AS device_application_name_40, t0.device_application_version AS device_application_version_41, t0.device_model AS device_model_42, t0.device_product AS device_product_43, t0.device_type AS device_type_44, t0.device_vendor AS device_vendor_45, t0.device_os_api_version AS device_os_api_version_46, t0.device_os_type AS device_os_type_47, t0.device_os_version AS device_os_version_48, t0.device_sandbox AS device_sandbox_49, t0.device_screen_density AS device_screen_density_50, t0.device_screen_height AS device_screen_height_51, t0.device_screen_orientation AS device_screen_orientation_52, t0.device_screen_width AS device_screen_width_53, t0.device_time_zone AS device_time_zone_54, t0.device_datetime AS device_datetime_55, t0.apple_uid AS apple_uid_56, t0.braintree_customer AS braintree_customer_57, t0.stripe_customer AS stripe_customer_58, t0.review_rating AS review_rating_59, t60.id AS id_61, t60.title AS title_62, t60.birth_date AS birth_date_63, t60.name AS name_64, t60.phone AS phone_65, t60.email AS email_66, t60.department AS department_67, t60.job_title AS job_title_68, t60.ba_address1 AS ba_address1_69, t60.ba_address2 AS ba_address2_70, t60.ba_door_number AS ba_door_number_71, t60.ba_store_apt AS ba_store_apt_72, t60.ba_city AS ba_city_73, t60.ba_postcode AS ba_postcode_74, t60.ba_country AS ba_country_75, t60.picture AS picture_76, t60.notes AS notes_77, t60.credit AS credit_78, t60.creation_date AS creation_date_79, t60.updated AS updated_80, t60.employer_name AS employer_name_81, t60.employer_phone AS employer_phone_82, t60.employer_type AS employer_type_83, t60.workplace_postcode AS workplace_postcode_84, t60.badge_proof_picture AS badge_proof_picture_85, t60.worker_voucher_usage AS worker_voucher_usage_86, t60.last_used_worker_voucher AS last_used_worker_voucher_87, t60.group_account_id AS group_account_id_88, t60.company_id AS company_id_89, t60.user_id AS user_id_90, t91.id AS id_92, t91.business_name AS business_name_93, t91.ref AS ref_94, t91.organization_name AS organization_name_95, t91.main_contact_name AS main_contact_name_96, t91.ba_address1 AS ba_address1_97, t91.ba_address2 AS ba_address2_98, t91.ba_door_number AS ba_door_number_99, t91.ba_store_apt AS ba_store_apt_100, t91.ba_city AS ba_city_101, t91.ba_postcode AS ba_postcode_102, t91.ba_country AS ba_country_103, t91.vat_id AS vat_id_104, t91.notes AS notes_105, t91.config_booking_emails AS config_booking_emails_106, t91.price_discount AS price_discount_107, t91.price_discount_fixed AS price_discount_fixed_108, t91.payment_type AS payment_type_109, t91.company_invoice_type AS company_invoice_type_110, t91.user_id AS user_id_111, t112.id AS id_113, t112.internal_name AS internal_name_114, t112.license AS license_115, t112.license_expire_date AS license_expire_date_116, t112.license_issue_date AS license_issue_date_117, t112.public_carriage_office_expiry_date AS public_carriage_office_expiry_date_118, t112.public_carriage_office_licence_number AS public_carriage_office_licence_number_119, t112.hack_license_expiration_date AS hack_license_expiration_date_120, t112.hack_license_number AS hack_license_number_121, t112.registration_date AS registration_date_122, t112.end_date AS end_date_123, t112.updated AS updated_124, t112.phone AS phone_125, t112.mobile_phone AS mobile_phone_126, t112.status AS status_127, t112.start_interval AS start_interval_128, t112.selected_start_interval AS selected_start_interval_129, t112.simple_status AS simple_status_130, t112.house_street_number AS house_street_number_131, t112.home_address_1 AS home_address_1_132, t112.home_address_2 AS home_address_2_133, t112.home_address_city AS home_address_city_134, t112.home_address_postcode AS home_address_postcode_135, t112.home_address_lat AS home_address_lat_136, t112.home_address_lng AS home_address_lng_137, t112.home_address_country AS home_address_country_138, t112.description AS description_139, t112.last_update_pozition AS last_update_pozition_140, t112.lat AS lat_141, t112.lng AS lng_142, t112.picture AS picture_143, t112.pco_license_file AS pco_license_file_144, t112.hack_license_file AS hack_license_file_145, t112.proof_of_right_to_work AS proof_of_right_to_work_146, t112.nino_file AS nino_file_147, t112.dbs_criminal_check_file AS dbs_criminal_check_file_148, t112.driver_agreement_file AS driver_agreement_file_149, t112.other_document AS other_document_150, t112.driver_licence_picture AS driver_licence_picture_151, t112.nationality AS nationality_152, t112.national_insurance_number AS national_insurance_number_153, t112.social_security_number AS social_security_number_154, t112.bank_society AS bank_society_155, t112.bank_sort_code AS bank_sort_code_156, t112.all_day_shift AS all_day_shift_157, t112.day_time_shift_start AS day_time_shift_start_158, t112.day_time_shift_end AS day_time_shift_end_159, t112.night_time_shift_start AS night_time_shift_start_160, t112.night_time_shift_end AS night_time_shift_end_161, t112.departure_location AS departure_location_162, t112.departure_location_lat AS departure_location_lat_163, t112.departure_location_lng AS departure_location_lng_164, t112.favorite_airport AS favorite_airport_165, t112.favorite_airport_lat AS favorite_airport_lat_166, t112.favorite_airport_lng AS favorite_airport_lng_167, t112.bank_account_number AS bank_account_number_168, t112.commission_office_up_to500 AS commission_office_up_to500_169, t112.commission_office_up_to1000 AS commission_office_up_to1000_170, t112.commission_office_up_to1500 AS commission_office_up_to1500_171, t112.commission_office_over1500 AS commission_office_over1500_172, t112.off_days AS off_days_173, t112.suspended_until_date AS suspended_until_date_174, t112.internal_reputation AS internal_reputation_175, t112.activity_reputation AS activity_reputation_176, t112.reputation_points AS reputation_points_177, t112.top_reputation_points AS top_reputation_points_178, t112.new_linked_booking_count AS new_linked_booking_count_179, t112.deactivated_until AS deactivated_until_180, t112.user_id AS user_id_181, t112.car_id AS car_id_182 FROM user t0 LEFT JOIN account t60 ON t60.user_id = t0.id LEFT JOIN company t91 ON t91.user_id = t0.id LEFT JOIN driver t112 ON t112.user_id = t0.id WHERE t0.api_key = '29a2d4341ef8c6a7adfeb3aa67b2c0231a09c5df' LIMIT 1;