GET https://bill.flexzob.com/employer/applications/?status=applied

Response
200 OK
Browse referrer URL
IP
50.150.38.238
Profiled on
Token
9e254a

Query Metrics

29 Database Queries
14 Different statements
24.69 ms Query time
0 Invalid entities
123 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
3.96 ms
(16.03%) 		7 
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.type AS type_4, t0.is_completed AS is_completed_5, t0.created_at AS created_at_6, t0.completed_at AS completed_at_7, t0.provider_id AS provider_id_8, t0.employer_id AS employer_id_9, t0.staffing_agency_id AS staffing_agency_id_10, t0.recruiter_id AS recruiter_id_11, t0.bookmark_id AS bookmark_id_12, t0.job_id AS job_id_13, t0.application_id AS application_id_14, t0.document_request_id AS document_request_id_15 FROM to_do t0 WHERE t0.employer_id = ? AND t0.provider_id = ? AND t0.job_id = ? AND t0.is_completed = ? ORDER BY t0.created_at ASC
Parameters: 
[
  b"\x1F\x11<èÿ¾l¨»ºKú5\x18\x14‰"
  b"\x1F\x11ßL€)kl‚“¿À\x1FѾU"
  b"\x1F\x13│Ðð\x02`\fÅ>Ú¡\fÞ╝ã"
  0
]
View formatted query    View runnable query    Explain query    View query backtrace
3.47 ms
(14.07%) 		7 
SELECT t0.id AS id_1, t0.message AS message_2, t0.reviewed_by AS reviewed_by_3, t0.point AS point_4, t0.professionalism AS professionalism_5, t0.quality AS quality_6, t0.communication AS communication_7, t0.emotional_intelligence AS emotional_intelligence_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.provider_id AS provider_id_11, t0.employer_id AS employer_id_12, t0.recruiter_id AS recruiter_id_13, t0.staffing_agency_id AS staffing_agency_id_14, t0.application_id AS application_id_15 FROM b_review t0 WHERE t0.application_id = ?
Parameters: 
[
  b"\x1F\x13³ÔÉÑa\x1Cˆõ_SÂËâ|"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.93 ms
(11.87%) 		1 
SELECT b0_.employer_status AS employer_status_0, b0_.recruiter_status AS recruiter_status_1, b0_.staffing_agency_status AS staffing_agency_status_2, b0_.id AS id_3, b0_.status AS status_4, b0_.applied_at AS applied_at_5, b0_.hired_at AS hired_at_6, b0_.document_requested_at AS document_requested_at_7, b0_.document_provided_at AS document_provided_at_8, b0_.one_file_requested_at AS one_file_requested_at_9, b0_.one_file_provided_at AS one_file_provided_at_10, b0_.contract_sent_at AS contract_sent_at_11, b0_.contract_file_name AS contract_file_name_12, b0_.contract_url AS contract_url_13, b0_.contract_signed_at AS contract_signed_at_14, b0_.contract_signed_file_name AS contract_signed_file_name_15, b0_.`rank` AS rank_16, b0_.archived_at AS archived_at_17, b0_.is_rewards_awarded AS is_rewards_awarded_18, b0_.is_archived AS is_archived_19, b0_.created_at AS created_at_20, b0_.updated_at AS updated_at_21, b1_.status_mode AS status_mode_22, b1_.id AS id_23, b1_.title AS title_24, b1_.description AS description_25, b1_.status AS status_26, b1_.country AS country_27, b1_.state AS state_28, b1_.city AS city_29, b1_.street_address AS street_address_30, b1_.expiration_date AS expiration_date_31, b1_.highlight AS highlight_32, b1_.schedule AS schedule_33, b1_.start_date AS start_date_34, b1_.year_of_experience AS year_of_experience_35, b1_.pay_rate AS pay_rate_36, b1_.work_type AS work_type_37, b1_.need AS need_38, b1_.pay_rate_hourly AS pay_rate_hourly_39, b1_.pay_rate_daily AS pay_rate_daily_40, b1_.annual_salary AS annual_salary_41, b1_.monthly_salary AS monthly_salary_42, b1_.salary_type AS salary_type_43, b1_.blocked AS blocked_44, b1_.job_id AS job_id_45, b1_.verified AS verified_46, b1_.is_mediated AS is_mediated_47, b1_.`rank` AS rank_48, b1_.archived_at AS archived_at_49, b1_.is_archived AS is_archived_50, b1_.agency_payout_status AS agency_payout_status_51, b1_.agency_payout_amount AS agency_payout_amount_52, b1_.agency_payout_date AS agency_payout_date_53, b1_.agency_payout_reference AS agency_payout_reference_54, b1_.created_at AS created_at_55, b1_.updated_at AS updated_at_56, b2_.id AS id_57, b2_.name AS name_58, b2_.address AS address_59, b2_.phone1 AS phone1_60, b2_.phone2 AS phone2_61, b2_.email AS email_62, b2_.website AS website_63, b2_.logo AS logo_64, b2_.average_point AS average_point_65, b2_.company_name AS company_name_66, b2_.contact_person_name AS contact_person_name_67, b2_.contact_email AS contact_email_68, b2_.notification_preferences AS notification_preferences_69, b2_.auto_verify AS auto_verify_70, b2_.created_at AS created_at_71, b2_.updated_at AS updated_at_72, b3_.id AS id_73, b3_.name AS name_74, b3_.address AS address_75, b3_.phone1 AS phone1_76, b3_.phone2 AS phone2_77, b3_.email AS email_78, b3_.website AS website_79, b3_.logo AS logo_80, b3_.average_point AS average_point_81, b3_.company_name AS company_name_82, b3_.contact_person_name AS contact_person_name_83, b3_.contact_email AS contact_email_84, b3_.notification_preferences AS notification_preferences_85, b3_.auto_verify AS auto_verify_86, b3_.created_at AS created_at_87, b3_.updated_at AS updated_at_88, b4_.id AS id_89, b4_.name AS name_90, b4_.address AS address_91, b4_.phone1 AS phone1_92, b4_.phone2 AS phone2_93, b4_.email AS email_94, b4_.website AS website_95, b4_.logo AS logo_96, b4_.average_point AS average_point_97, b4_.company_name AS company_name_98, b4_.contact_person_name AS contact_person_name_99, b4_.contact_email AS contact_email_100, b4_.notification_preferences AS notification_preferences_101, b4_.auto_verify AS auto_verify_102, b4_.created_at AS created_at_103, b4_.updated_at AS updated_at_104, b5_.id AS id_105, b5_.name AS name_106, b5_.address AS address_107, b5_.phone1 AS phone1_108, b5_.phone2 AS phone2_109, b5_.email AS email_110, b5_.website AS website_111, b5_.logo AS logo_112, b5_.average_point AS average_point_113, b5_.company_name AS company_name_114, b5_.contact_person_name AS contact_person_name_115, b5_.contact_email AS contact_email_116, b5_.notification_preferences AS notification_preferences_117, b5_.auto_verify AS auto_verify_118, b5_.created_at AS created_at_119, b5_.updated_at AS updated_at_120, b6_.id AS id_121, b6_.company_name AS company_name_122, b6_.speciality AS speciality_123, b6_.membership_level AS membership_level_124, b6_.rating AS rating_125, b6_.is_verified AS is_verified_126, b6_.stripe_connect_account_id AS stripe_connect_account_id_127, b6_.stripe_account_status AS stripe_account_status_128, b6_.created_at AS created_at_129, b6_.updated_at AS updated_at_130, b7_.id AS id_131, b7_.company_name AS company_name_132, b7_.speciality AS speciality_133, b7_.membership_level AS membership_level_134, b7_.rating AS rating_135, b7_.is_verified AS is_verified_136, b7_.stripe_connect_account_id AS stripe_connect_account_id_137, b7_.stripe_account_status AS stripe_account_status_138, b7_.created_at AS created_at_139, b7_.updated_at AS updated_at_140, b8_.id AS id_141, b8_.name AS name_142, b8_.suffix AS suffix_143, b8_.title AS title_144, b8_.npi_number AS npi_number_145, b8_.phone_home AS phone_home_146, b8_.phone_work AS phone_work_147, b8_.phone_mobile AS phone_mobile_148, b8_.cv_filename AS cv_filename_149, b8_.country AS country_150, b8_.state AS state_151, b8_.city AS city_152, b8_.zip_code AS zip_code_153, b8_.street_address AS street_address_154, b8_.desired_pay_rate AS desired_pay_rate_155, b8_.pay_rate_hourly AS pay_rate_hourly_156, b8_.pay_rate_daily AS pay_rate_daily_157, b8_.desired_hour AS desired_hour_158, b8_.desired_states AS desired_states_159, b8_.availability_to_start AS availability_to_start_160, b8_.willing_to_travel AS willing_to_travel_161, b8_.preferred_patient_volume AS preferred_patient_volume_162, b8_.release_authorization_date AS release_authorization_date_163, b8_.ssn AS ssn_164, b8_.dob AS dob_165, b8_.country_of_birth AS country_of_birth_166, b8_.state_of_birth AS state_of_birth_167, b8_.city_of_birth AS city_of_birth_168, b8_.release_and_authorization_accepted AS release_and_authorization_accepted_169, b8_.application_certification_date AS application_certification_date_170, b8_.risk_assessment AS risk_assessment_171, b8_.health_assessment AS health_assessment_172, b8_.cashback AS cashback_173, b8_.notification_preferences AS notification_preferences_174, b8_.average_point AS average_point_175, b8_.skip_onboarding AS skip_onboarding_176, b8_.rewards_points AS rewards_points_177, b8_.created_at AS created_at_178, b8_.updated_at AS updated_at_179, b9_.id AS id_180, b9_.name AS name_181, b9_.email AS email_182, b9_.user_type AS user_type_183, b9_.roles AS roles_184, b9_.password AS password_185, b9_.is_verified AS is_verified_186, b9_.oauth_provider AS oauth_provider_187, b9_.oauth_id AS oauth_id_188, b9_.profile_picture_filename AS profile_picture_filename_189, b9_.oauth_data AS oauth_data_190, b9_.on_boarding_completed_at AS on_boarding_completed_at_191, b9_.dob AS dob_192, b9_.gender AS gender_193, b9_.stripe_customer_id AS stripe_customer_id_194, b9_.stripe_connect_id AS stripe_connect_id_195, b9_.stripe_account_status AS stripe_account_status_196, b9_.subscription_status AS subscription_status_197, b9_.subscription_ends_at AS subscription_ends_at_198, b9_.custom_fee_structure AS custom_fee_structure_199, b9_.phone1 AS phone1_200, b9_.phone2 AS phone2_201, b9_.bio AS bio_202, b9_.nickname AS nickname_203, b9_.blocked AS blocked_204, b9_.mfa_code AS mfa_code_205, b9_.mfa_expires_at AS mfa_expires_at_206, b9_.is_hybrid_recruiter AS is_hybrid_recruiter_207, b9_.address AS address_208, b9_.created_at AS created_at_209, b9_.updated_at AS updated_at_210, b10_.id AS id_211, b10_.name AS name_212, b10_.email AS email_213, b10_.user_type AS user_type_214, b10_.roles AS roles_215, b10_.password AS password_216, b10_.is_verified AS is_verified_217, b10_.oauth_provider AS oauth_provider_218, b10_.oauth_id AS oauth_id_219, b10_.profile_picture_filename AS profile_picture_filename_220, b10_.oauth_data AS oauth_data_221, b10_.on_boarding_completed_at AS on_boarding_completed_at_222, b10_.dob AS dob_223, b10_.gender AS gender_224, b10_.stripe_customer_id AS stripe_customer_id_225, b10_.stripe_connect_id AS stripe_connect_id_226, b10_.stripe_account_status AS stripe_account_status_227, b10_.subscription_status AS subscription_status_228, b10_.subscription_ends_at AS subscription_ends_at_229, b10_.custom_fee_structure AS custom_fee_structure_230, b10_.phone1 AS phone1_231, b10_.phone2 AS phone2_232, b10_.bio AS bio_233, b10_.nickname AS nickname_234, b10_.blocked AS blocked_235, b10_.mfa_code AS mfa_code_236, b10_.mfa_expires_at AS mfa_expires_at_237, b10_.is_hybrid_recruiter AS is_hybrid_recruiter_238, b10_.address AS address_239, b10_.created_at AS created_at_240, b10_.updated_at AS updated_at_241, b11_.id AS id_242, b11_.name AS name_243, b11_.address AS address_244, b11_.phone1 AS phone1_245, b11_.phone2 AS phone2_246, b11_.email AS email_247, b11_.website AS website_248, b11_.logo AS logo_249, b11_.average_point AS average_point_250, b11_.company_name AS company_name_251, b11_.contact_person_name AS contact_person_name_252, b11_.contact_email AS contact_email_253, b11_.notification_preferences AS notification_preferences_254, b11_.auto_verify AS auto_verify_255, b11_.created_at AS created_at_256, b11_.updated_at AS updated_at_257, b12_.id AS id_258, b12_.name AS name_259, b12_.address AS address_260, b12_.phone1 AS phone1_261, b12_.phone2 AS phone2_262, b12_.email AS email_263, b12_.website AS website_264, b12_.logo AS logo_265, b12_.average_point AS average_point_266, b12_.company_name AS company_name_267, b12_.contact_person_name AS contact_person_name_268, b12_.contact_email AS contact_email_269, b12_.notification_preferences AS notification_preferences_270, b12_.auto_verify AS auto_verify_271, b12_.created_at AS created_at_272, b12_.updated_at AS updated_at_273, b13_.id AS id_274, b13_.company_name AS company_name_275, b13_.speciality AS speciality_276, b13_.membership_level AS membership_level_277, b13_.rating AS rating_278, b13_.is_verified AS is_verified_279, b13_.stripe_connect_account_id AS stripe_connect_account_id_280, b13_.stripe_account_status AS stripe_account_status_281, b13_.created_at AS created_at_282, b13_.updated_at AS updated_at_283, b14_.id AS id_284, b14_.name AS name_285, b14_.email AS email_286, b14_.user_type AS user_type_287, b14_.roles AS roles_288, b14_.password AS password_289, b14_.is_verified AS is_verified_290, b14_.oauth_provider AS oauth_provider_291, b14_.oauth_id AS oauth_id_292, b14_.profile_picture_filename AS profile_picture_filename_293, b14_.oauth_data AS oauth_data_294, b14_.on_boarding_completed_at AS on_boarding_completed_at_295, b14_.dob AS dob_296, b14_.gender AS gender_297, b14_.stripe_customer_id AS stripe_customer_id_298, b14_.stripe_connect_id AS stripe_connect_id_299, b14_.stripe_account_status AS stripe_account_status_300, b14_.subscription_status AS subscription_status_301, b14_.subscription_ends_at AS subscription_ends_at_302, b14_.custom_fee_structure AS custom_fee_structure_303, b14_.phone1 AS phone1_304, b14_.phone2 AS phone2_305, b14_.bio AS bio_306, b14_.nickname AS nickname_307, b14_.blocked AS blocked_308, b14_.mfa_code AS mfa_code_309, b14_.mfa_expires_at AS mfa_expires_at_310, b14_.is_hybrid_recruiter AS is_hybrid_recruiter_311, b14_.address AS address_312, b14_.created_at AS created_at_313, b14_.updated_at AS updated_at_314, b0_.employer_id AS employer_id_315, b0_.staffing_agency_id AS staffing_agency_id_316, b0_.recruiter_id AS recruiter_id_317, b0_.provider_id AS provider_id_318, b0_.job_id AS job_id_319, b0_.interview_id AS interview_id_320, b1_.user_id AS user_id_321, b1_.employer_id AS employer_id_322, b1_.staffing_agency_id AS staffing_agency_id_323, b1_.profession_id AS profession_id_324, b1_.speciality_id AS speciality_id_325, b1_.assigned_recruiter_id AS assigned_recruiter_id_326, b2_.user_id AS user_id_327, b4_.user_id AS user_id_328, b6_.user_id AS user_id_329, b7_.user_id AS user_id_330, b8_.user_id AS user_id_331, b8_.profession_id AS profession_id_332, b9_.dtype AS dtype_333, b9_.employer_id AS employer_id_334, b9_.staffing_agency_id AS staffing_agency_id_335, b9_.membership_tier_id AS membership_tier_id_336, b9_.recruiter_id AS recruiter_id_337, b10_.dtype AS dtype_338, b10_.employer_id AS employer_id_339, b10_.staffing_agency_id AS staffing_agency_id_340, b10_.membership_tier_id AS membership_tier_id_341, b10_.recruiter_id AS recruiter_id_342, b11_.user_id AS user_id_343, b13_.user_id AS user_id_344, b14_.dtype AS dtype_345, b14_.employer_id AS employer_id_346, b14_.staffing_agency_id AS staffing_agency_id_347, b14_.membership_tier_id AS membership_tier_id_348, b14_.recruiter_id AS recruiter_id_349 FROM b_application b0_ INNER JOIN b_job b1_ ON b0_.job_id = b1_.id LEFT JOIN b_employer b2_ ON b0_.employer_id = b2_.id LEFT JOIN b_staffing_agency b3_ ON b0_.staffing_agency_id = b3_.id LEFT JOIN b_employer b4_ ON b1_.employer_id = b4_.id LEFT JOIN b_staffing_agency b5_ ON b1_.staffing_agency_id = b5_.id LEFT JOIN b_recruiter b6_ ON b0_.recruiter_id = b6_.id LEFT JOIN b_recruiter b7_ ON b1_.assigned_recruiter_id = b7_.id LEFT JOIN b_job_recruiter b15_ ON b1_.id = b15_.job_id LEFT JOIN b_provider b8_ ON b0_.provider_id = b8_.id LEFT JOIN b_user b9_ ON b8_.user_id = b9_.id AND b9_.dtype IN ('user') LEFT JOIN b_user b10_ ON b1_.user_id = b10_.id AND b10_.dtype IN ('user') LEFT JOIN b_employer b11_ ON b10_.employer_id = b11_.id LEFT JOIN b_staffing_agency b12_ ON b10_.staffing_agency_id = b12_.id LEFT JOIN b_recruiter b13_ ON b10_.id = b13_.user_id LEFT JOIN b_user b14_ ON b7_.user_id = b14_.id AND b14_.dtype IN ('user') WHERE 1 = 1 AND b0_.archived_at IS NULL AND b0_.status IN (?) AND b0_.employer_id = ? AND b0_.id IN (?, ?, ?, ?, ?, ?, ?) ORDER BY b0_.id DESC
Parameters: 
[
  "applied"
  b"\x1F\x11<èÿ¾l¨»ºKú5\x18\x14‰"
  b"\x1F\x13³ÔÉÑa\x1Cˆõ_SÂËâ|"
  b"\x1F\x13’DzEmx²2GÁjð;ô"
  b"\x1F\x13zÆÇn8ž›+ûH1F\x1E"
  b"\x1F\x13;bx\x1Cc蚈M.§v¿E"
  b"\x1F\x12░¦‗\x0Eb£é¿eeÉ#Oß"
  b"\x1F\x12`\x08¥œ`â›\x04\x07¤¿ø.f"
  b"\x1F\x12ZIûµhFöëôØ┌Å1ü"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.60 ms
(10.55%) 		1 
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_3 FROM (SELECT b0_.employer_status AS employer_status_0, b0_.recruiter_status AS recruiter_status_1, b0_.staffing_agency_status AS staffing_agency_status_2, b0_.id AS id_3, b0_.status AS status_4, b0_.applied_at AS applied_at_5, b0_.hired_at AS hired_at_6, b0_.document_requested_at AS document_requested_at_7, b0_.document_provided_at AS document_provided_at_8, b0_.one_file_requested_at AS one_file_requested_at_9, b0_.one_file_provided_at AS one_file_provided_at_10, b0_.contract_sent_at AS contract_sent_at_11, b0_.contract_file_name AS contract_file_name_12, b0_.contract_url AS contract_url_13, b0_.contract_signed_at AS contract_signed_at_14, b0_.contract_signed_file_name AS contract_signed_file_name_15, b0_.`rank` AS rank_16, b0_.archived_at AS archived_at_17, b0_.is_rewards_awarded AS is_rewards_awarded_18, b0_.is_archived AS is_archived_19, b0_.created_at AS created_at_20, b0_.updated_at AS updated_at_21, b1_.status_mode AS status_mode_22, b1_.id AS id_23, b1_.title AS title_24, b1_.description AS description_25, b1_.status AS status_26, b1_.country AS country_27, b1_.state AS state_28, b1_.city AS city_29, b1_.street_address AS street_address_30, b1_.expiration_date AS expiration_date_31, b1_.highlight AS highlight_32, b1_.schedule AS schedule_33, b1_.start_date AS start_date_34, b1_.year_of_experience AS year_of_experience_35, b1_.pay_rate AS pay_rate_36, b1_.work_type AS work_type_37, b1_.need AS need_38, b1_.pay_rate_hourly AS pay_rate_hourly_39, b1_.pay_rate_daily AS pay_rate_daily_40, b1_.annual_salary AS annual_salary_41, b1_.monthly_salary AS monthly_salary_42, b1_.salary_type AS salary_type_43, b1_.blocked AS blocked_44, b1_.job_id AS job_id_45, b1_.verified AS verified_46, b1_.is_mediated AS is_mediated_47, b1_.`rank` AS rank_48, b1_.archived_at AS archived_at_49, b1_.is_archived AS is_archived_50, b1_.agency_payout_status AS agency_payout_status_51, b1_.agency_payout_amount AS agency_payout_amount_52, b1_.agency_payout_date AS agency_payout_date_53, b1_.agency_payout_reference AS agency_payout_reference_54, b1_.created_at AS created_at_55, b1_.updated_at AS updated_at_56, b2_.id AS id_57, b2_.name AS name_58, b2_.address AS address_59, b2_.phone1 AS phone1_60, b2_.phone2 AS phone2_61, b2_.email AS email_62, b2_.website AS website_63, b2_.logo AS logo_64, b2_.average_point AS average_point_65, b2_.company_name AS company_name_66, b2_.contact_person_name AS contact_person_name_67, b2_.contact_email AS contact_email_68, b2_.notification_preferences AS notification_preferences_69, b2_.auto_verify AS auto_verify_70, b2_.created_at AS created_at_71, b2_.updated_at AS updated_at_72, b3_.id AS id_73, b3_.name AS name_74, b3_.address AS address_75, b3_.phone1 AS phone1_76, b3_.phone2 AS phone2_77, b3_.email AS email_78, b3_.website AS website_79, b3_.logo AS logo_80, b3_.average_point AS average_point_81, b3_.company_name AS company_name_82, b3_.contact_person_name AS contact_person_name_83, b3_.contact_email AS contact_email_84, b3_.notification_preferences AS notification_preferences_85, b3_.auto_verify AS auto_verify_86, b3_.created_at AS created_at_87, b3_.updated_at AS updated_at_88, b4_.id AS id_89, b4_.name AS name_90, b4_.address AS address_91, b4_.phone1 AS phone1_92, b4_.phone2 AS phone2_93, b4_.email AS email_94, b4_.website AS website_95, b4_.logo AS logo_96, b4_.average_point AS average_point_97, b4_.company_name AS company_name_98, b4_.contact_person_name AS contact_person_name_99, b4_.contact_email AS contact_email_100, b4_.notification_preferences AS notification_preferences_101, b4_.auto_verify AS auto_verify_102, b4_.created_at AS created_at_103, b4_.updated_at AS updated_at_104, b5_.id AS id_105, b5_.name AS name_106, b5_.address AS address_107, b5_.phone1 AS phone1_108, b5_.phone2 AS phone2_109, b5_.email AS email_110, b5_.website AS website_111, b5_.logo AS logo_112, b5_.average_point AS average_point_113, b5_.company_name AS company_name_114, b5_.contact_person_name AS contact_person_name_115, b5_.contact_email AS contact_email_116, b5_.notification_preferences AS notification_preferences_117, b5_.auto_verify AS auto_verify_118, b5_.created_at AS created_at_119, b5_.updated_at AS updated_at_120, b6_.id AS id_121, b6_.company_name AS company_name_122, b6_.speciality AS speciality_123, b6_.membership_level AS membership_level_124, b6_.rating AS rating_125, b6_.is_verified AS is_verified_126, b6_.stripe_connect_account_id AS stripe_connect_account_id_127, b6_.stripe_account_status AS stripe_account_status_128, b6_.created_at AS created_at_129, b6_.updated_at AS updated_at_130, b7_.id AS id_131, b7_.company_name AS company_name_132, b7_.speciality AS speciality_133, b7_.membership_level AS membership_level_134, b7_.rating AS rating_135, b7_.is_verified AS is_verified_136, b7_.stripe_connect_account_id AS stripe_connect_account_id_137, b7_.stripe_account_status AS stripe_account_status_138, b7_.created_at AS created_at_139, b7_.updated_at AS updated_at_140, b8_.id AS id_141, b8_.name AS name_142, b8_.suffix AS suffix_143, b8_.title AS title_144, b8_.npi_number AS npi_number_145, b8_.phone_home AS phone_home_146, b8_.phone_work AS phone_work_147, b8_.phone_mobile AS phone_mobile_148, b8_.cv_filename AS cv_filename_149, b8_.country AS country_150, b8_.state AS state_151, b8_.city AS city_152, b8_.zip_code AS zip_code_153, b8_.street_address AS street_address_154, b8_.desired_pay_rate AS desired_pay_rate_155, b8_.pay_rate_hourly AS pay_rate_hourly_156, b8_.pay_rate_daily AS pay_rate_daily_157, b8_.desired_hour AS desired_hour_158, b8_.desired_states AS desired_states_159, b8_.availability_to_start AS availability_to_start_160, b8_.willing_to_travel AS willing_to_travel_161, b8_.preferred_patient_volume AS preferred_patient_volume_162, b8_.release_authorization_date AS release_authorization_date_163, b8_.ssn AS ssn_164, b8_.dob AS dob_165, b8_.country_of_birth AS country_of_birth_166, b8_.state_of_birth AS state_of_birth_167, b8_.city_of_birth AS city_of_birth_168, b8_.release_and_authorization_accepted AS release_and_authorization_accepted_169, b8_.application_certification_date AS application_certification_date_170, b8_.risk_assessment AS risk_assessment_171, b8_.health_assessment AS health_assessment_172, b8_.cashback AS cashback_173, b8_.notification_preferences AS notification_preferences_174, b8_.average_point AS average_point_175, b8_.skip_onboarding AS skip_onboarding_176, b8_.rewards_points AS rewards_points_177, b8_.created_at AS created_at_178, b8_.updated_at AS updated_at_179, b9_.id AS id_180, b9_.name AS name_181, b9_.email AS email_182, b9_.user_type AS user_type_183, b9_.roles AS roles_184, b9_.password AS password_185, b9_.is_verified AS is_verified_186, b9_.oauth_provider AS oauth_provider_187, b9_.oauth_id AS oauth_id_188, b9_.profile_picture_filename AS profile_picture_filename_189, b9_.oauth_data AS oauth_data_190, b9_.on_boarding_completed_at AS on_boarding_completed_at_191, b9_.dob AS dob_192, b9_.gender AS gender_193, b9_.stripe_customer_id AS stripe_customer_id_194, b9_.stripe_connect_id AS stripe_connect_id_195, b9_.stripe_account_status AS stripe_account_status_196, b9_.subscription_status AS subscription_status_197, b9_.subscription_ends_at AS subscription_ends_at_198, b9_.custom_fee_structure AS custom_fee_structure_199, b9_.phone1 AS phone1_200, b9_.phone2 AS phone2_201, b9_.bio AS bio_202, b9_.nickname AS nickname_203, b9_.blocked AS blocked_204, b9_.mfa_code AS mfa_code_205, b9_.mfa_expires_at AS mfa_expires_at_206, b9_.is_hybrid_recruiter AS is_hybrid_recruiter_207, b9_.address AS address_208, b9_.created_at AS created_at_209, b9_.updated_at AS updated_at_210, b10_.id AS id_211, b10_.name AS name_212, b10_.email AS email_213, b10_.user_type AS user_type_214, b10_.roles AS roles_215, b10_.password AS password_216, b10_.is_verified AS is_verified_217, b10_.oauth_provider AS oauth_provider_218, b10_.oauth_id AS oauth_id_219, b10_.profile_picture_filename AS profile_picture_filename_220, b10_.oauth_data AS oauth_data_221, b10_.on_boarding_completed_at AS on_boarding_completed_at_222, b10_.dob AS dob_223, b10_.gender AS gender_224, b10_.stripe_customer_id AS stripe_customer_id_225, b10_.stripe_connect_id AS stripe_connect_id_226, b10_.stripe_account_status AS stripe_account_status_227, b10_.subscription_status AS subscription_status_228, b10_.subscription_ends_at AS subscription_ends_at_229, b10_.custom_fee_structure AS custom_fee_structure_230, b10_.phone1 AS phone1_231, b10_.phone2 AS phone2_232, b10_.bio AS bio_233, b10_.nickname AS nickname_234, b10_.blocked AS blocked_235, b10_.mfa_code AS mfa_code_236, b10_.mfa_expires_at AS mfa_expires_at_237, b10_.is_hybrid_recruiter AS is_hybrid_recruiter_238, b10_.address AS address_239, b10_.created_at AS created_at_240, b10_.updated_at AS updated_at_241, b11_.id AS id_242, b11_.name AS name_243, b11_.address AS address_244, b11_.phone1 AS phone1_245, b11_.phone2 AS phone2_246, b11_.email AS email_247, b11_.website AS website_248, b11_.logo AS logo_249, b11_.average_point AS average_point_250, b11_.company_name AS company_name_251, b11_.contact_person_name AS contact_person_name_252, b11_.contact_email AS contact_email_253, b11_.notification_preferences AS notification_preferences_254, b11_.auto_verify AS auto_verify_255, b11_.created_at AS created_at_256, b11_.updated_at AS updated_at_257, b12_.id AS id_258, b12_.name AS name_259, b12_.address AS address_260, b12_.phone1 AS phone1_261, b12_.phone2 AS phone2_262, b12_.email AS email_263, b12_.website AS website_264, b12_.logo AS logo_265, b12_.average_point AS average_point_266, b12_.company_name AS company_name_267, b12_.contact_person_name AS contact_person_name_268, b12_.contact_email AS contact_email_269, b12_.notification_preferences AS notification_preferences_270, b12_.auto_verify AS auto_verify_271, b12_.created_at AS created_at_272, b12_.updated_at AS updated_at_273, b13_.id AS id_274, b13_.company_name AS company_name_275, b13_.speciality AS speciality_276, b13_.membership_level AS membership_level_277, b13_.rating AS rating_278, b13_.is_verified AS is_verified_279, b13_.stripe_connect_account_id AS stripe_connect_account_id_280, b13_.stripe_account_status AS stripe_account_status_281, b13_.created_at AS created_at_282, b13_.updated_at AS updated_at_283, b14_.id AS id_284, b14_.name AS name_285, b14_.email AS email_286, b14_.user_type AS user_type_287, b14_.roles AS roles_288, b14_.password AS password_289, b14_.is_verified AS is_verified_290, b14_.oauth_provider AS oauth_provider_291, b14_.oauth_id AS oauth_id_292, b14_.profile_picture_filename AS profile_picture_filename_293, b14_.oauth_data AS oauth_data_294, b14_.on_boarding_completed_at AS on_boarding_completed_at_295, b14_.dob AS dob_296, b14_.gender AS gender_297, b14_.stripe_customer_id AS stripe_customer_id_298, b14_.stripe_connect_id AS stripe_connect_id_299, b14_.stripe_account_status AS stripe_account_status_300, b14_.subscription_status AS subscription_status_301, b14_.subscription_ends_at AS subscription_ends_at_302, b14_.custom_fee_structure AS custom_fee_structure_303, b14_.phone1 AS phone1_304, b14_.phone2 AS phone2_305, b14_.bio AS bio_306, b14_.nickname AS nickname_307, b14_.blocked AS blocked_308, b14_.mfa_code AS mfa_code_309, b14_.mfa_expires_at AS mfa_expires_at_310, b14_.is_hybrid_recruiter AS is_hybrid_recruiter_311, b14_.address AS address_312, b14_.created_at AS created_at_313, b14_.updated_at AS updated_at_314, b9_.dtype AS dtype_315, b10_.dtype AS dtype_316, b14_.dtype AS dtype_317 FROM b_application b0_ INNER JOIN b_job b1_ ON b0_.job_id = b1_.id LEFT JOIN b_employer b2_ ON b0_.employer_id = b2_.id LEFT JOIN b_staffing_agency b3_ ON b0_.staffing_agency_id = b3_.id LEFT JOIN b_employer b4_ ON b1_.employer_id = b4_.id LEFT JOIN b_staffing_agency b5_ ON b1_.staffing_agency_id = b5_.id LEFT JOIN b_recruiter b6_ ON b0_.recruiter_id = b6_.id LEFT JOIN b_recruiter b7_ ON b1_.assigned_recruiter_id = b7_.id LEFT JOIN b_job_recruiter b15_ ON b1_.id = b15_.job_id LEFT JOIN b_provider b8_ ON b0_.provider_id = b8_.id LEFT JOIN b_user b9_ ON b8_.user_id = b9_.id AND b9_.dtype IN ('user') LEFT JOIN b_user b10_ ON b1_.user_id = b10_.id AND b10_.dtype IN ('user') LEFT JOIN b_employer b11_ ON b10_.employer_id = b11_.id LEFT JOIN b_staffing_agency b12_ ON b10_.staffing_agency_id = b12_.id LEFT JOIN b_recruiter b13_ ON b10_.id = b13_.user_id LEFT JOIN b_user b14_ ON b7_.user_id = b14_.id AND b14_.dtype IN ('user') WHERE 1 = 1 AND b0_.archived_at IS NULL AND b0_.status IN (?) AND b0_.employer_id = ? ORDER BY b0_.id DESC) dctrn_result) dctrn_table
Parameters: 
[
  "applied"
  b"\x1F\x11<èÿ¾l¨»ºKú5\x18\x14‰"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.30 ms
(9.33%) 		1 
SELECT DISTINCT id_3 FROM (SELECT DISTINCT id_3 FROM (SELECT b0_.employer_status AS employer_status_0, b0_.recruiter_status AS recruiter_status_1, b0_.staffing_agency_status AS staffing_agency_status_2, b0_.id AS id_3, b0_.status AS status_4, b0_.applied_at AS applied_at_5, b0_.hired_at AS hired_at_6, b0_.document_requested_at AS document_requested_at_7, b0_.document_provided_at AS document_provided_at_8, b0_.one_file_requested_at AS one_file_requested_at_9, b0_.one_file_provided_at AS one_file_provided_at_10, b0_.contract_sent_at AS contract_sent_at_11, b0_.contract_file_name AS contract_file_name_12, b0_.contract_url AS contract_url_13, b0_.contract_signed_at AS contract_signed_at_14, b0_.contract_signed_file_name AS contract_signed_file_name_15, b0_.`rank` AS rank_16, b0_.archived_at AS archived_at_17, b0_.is_rewards_awarded AS is_rewards_awarded_18, b0_.is_archived AS is_archived_19, b0_.created_at AS created_at_20, b0_.updated_at AS updated_at_21, b1_.status_mode AS status_mode_22, b1_.id AS id_23, b1_.title AS title_24, b1_.description AS description_25, b1_.status AS status_26, b1_.country AS country_27, b1_.state AS state_28, b1_.city AS city_29, b1_.street_address AS street_address_30, b1_.expiration_date AS expiration_date_31, b1_.highlight AS highlight_32, b1_.schedule AS schedule_33, b1_.start_date AS start_date_34, b1_.year_of_experience AS year_of_experience_35, b1_.pay_rate AS pay_rate_36, b1_.work_type AS work_type_37, b1_.need AS need_38, b1_.pay_rate_hourly AS pay_rate_hourly_39, b1_.pay_rate_daily AS pay_rate_daily_40, b1_.annual_salary AS annual_salary_41, b1_.monthly_salary AS monthly_salary_42, b1_.salary_type AS salary_type_43, b1_.blocked AS blocked_44, b1_.job_id AS job_id_45, b1_.verified AS verified_46, b1_.is_mediated AS is_mediated_47, b1_.`rank` AS rank_48, b1_.archived_at AS archived_at_49, b1_.is_archived AS is_archived_50, b1_.agency_payout_status AS agency_payout_status_51, b1_.agency_payout_amount AS agency_payout_amount_52, b1_.agency_payout_date AS agency_payout_date_53, b1_.agency_payout_reference AS agency_payout_reference_54, b1_.created_at AS created_at_55, b1_.updated_at AS updated_at_56, b2_.id AS id_57, b2_.name AS name_58, b2_.address AS address_59, b2_.phone1 AS phone1_60, b2_.phone2 AS phone2_61, b2_.email AS email_62, b2_.website AS website_63, b2_.logo AS logo_64, b2_.average_point AS average_point_65, b2_.company_name AS company_name_66, b2_.contact_person_name AS contact_person_name_67, b2_.contact_email AS contact_email_68, b2_.notification_preferences AS notification_preferences_69, b2_.auto_verify AS auto_verify_70, b2_.created_at AS created_at_71, b2_.updated_at AS updated_at_72, b3_.id AS id_73, b3_.name AS name_74, b3_.address AS address_75, b3_.phone1 AS phone1_76, b3_.phone2 AS phone2_77, b3_.email AS email_78, b3_.website AS website_79, b3_.logo AS logo_80, b3_.average_point AS average_point_81, b3_.company_name AS company_name_82, b3_.contact_person_name AS contact_person_name_83, b3_.contact_email AS contact_email_84, b3_.notification_preferences AS notification_preferences_85, b3_.auto_verify AS auto_verify_86, b3_.created_at AS created_at_87, b3_.updated_at AS updated_at_88, b4_.id AS id_89, b4_.name AS name_90, b4_.address AS address_91, b4_.phone1 AS phone1_92, b4_.phone2 AS phone2_93, b4_.email AS email_94, b4_.website AS website_95, b4_.logo AS logo_96, b4_.average_point AS average_point_97, b4_.company_name AS company_name_98, b4_.contact_person_name AS contact_person_name_99, b4_.contact_email AS contact_email_100, b4_.notification_preferences AS notification_preferences_101, b4_.auto_verify AS auto_verify_102, b4_.created_at AS created_at_103, b4_.updated_at AS updated_at_104, b5_.id AS id_105, b5_.name AS name_106, b5_.address AS address_107, b5_.phone1 AS phone1_108, b5_.phone2 AS phone2_109, b5_.email AS email_110, b5_.website AS website_111, b5_.logo AS logo_112, b5_.average_point AS average_point_113, b5_.company_name AS company_name_114, b5_.contact_person_name AS contact_person_name_115, b5_.contact_email AS contact_email_116, b5_.notification_preferences AS notification_preferences_117, b5_.auto_verify AS auto_verify_118, b5_.created_at AS created_at_119, b5_.updated_at AS updated_at_120, b6_.id AS id_121, b6_.company_name AS company_name_122, b6_.speciality AS speciality_123, b6_.membership_level AS membership_level_124, b6_.rating AS rating_125, b6_.is_verified AS is_verified_126, b6_.stripe_connect_account_id AS stripe_connect_account_id_127, b6_.stripe_account_status AS stripe_account_status_128, b6_.created_at AS created_at_129, b6_.updated_at AS updated_at_130, b7_.id AS id_131, b7_.company_name AS company_name_132, b7_.speciality AS speciality_133, b7_.membership_level AS membership_level_134, b7_.rating AS rating_135, b7_.is_verified AS is_verified_136, b7_.stripe_connect_account_id AS stripe_connect_account_id_137, b7_.stripe_account_status AS stripe_account_status_138, b7_.created_at AS created_at_139, b7_.updated_at AS updated_at_140, b8_.id AS id_141, b8_.name AS name_142, b8_.suffix AS suffix_143, b8_.title AS title_144, b8_.npi_number AS npi_number_145, b8_.phone_home AS phone_home_146, b8_.phone_work AS phone_work_147, b8_.phone_mobile AS phone_mobile_148, b8_.cv_filename AS cv_filename_149, b8_.country AS country_150, b8_.state AS state_151, b8_.city AS city_152, b8_.zip_code AS zip_code_153, b8_.street_address AS street_address_154, b8_.desired_pay_rate AS desired_pay_rate_155, b8_.pay_rate_hourly AS pay_rate_hourly_156, b8_.pay_rate_daily AS pay_rate_daily_157, b8_.desired_hour AS desired_hour_158, b8_.desired_states AS desired_states_159, b8_.availability_to_start AS availability_to_start_160, b8_.willing_to_travel AS willing_to_travel_161, b8_.preferred_patient_volume AS preferred_patient_volume_162, b8_.release_authorization_date AS release_authorization_date_163, b8_.ssn AS ssn_164, b8_.dob AS dob_165, b8_.country_of_birth AS country_of_birth_166, b8_.state_of_birth AS state_of_birth_167, b8_.city_of_birth AS city_of_birth_168, b8_.release_and_authorization_accepted AS release_and_authorization_accepted_169, b8_.application_certification_date AS application_certification_date_170, b8_.risk_assessment AS risk_assessment_171, b8_.health_assessment AS health_assessment_172, b8_.cashback AS cashback_173, b8_.notification_preferences AS notification_preferences_174, b8_.average_point AS average_point_175, b8_.skip_onboarding AS skip_onboarding_176, b8_.rewards_points AS rewards_points_177, b8_.created_at AS created_at_178, b8_.updated_at AS updated_at_179, b9_.id AS id_180, b9_.name AS name_181, b9_.email AS email_182, b9_.user_type AS user_type_183, b9_.roles AS roles_184, b9_.password AS password_185, b9_.is_verified AS is_verified_186, b9_.oauth_provider AS oauth_provider_187, b9_.oauth_id AS oauth_id_188, b9_.profile_picture_filename AS profile_picture_filename_189, b9_.oauth_data AS oauth_data_190, b9_.on_boarding_completed_at AS on_boarding_completed_at_191, b9_.dob AS dob_192, b9_.gender AS gender_193, b9_.stripe_customer_id AS stripe_customer_id_194, b9_.stripe_connect_id AS stripe_connect_id_195, b9_.stripe_account_status AS stripe_account_status_196, b9_.subscription_status AS subscription_status_197, b9_.subscription_ends_at AS subscription_ends_at_198, b9_.custom_fee_structure AS custom_fee_structure_199, b9_.phone1 AS phone1_200, b9_.phone2 AS phone2_201, b9_.bio AS bio_202, b9_.nickname AS nickname_203, b9_.blocked AS blocked_204, b9_.mfa_code AS mfa_code_205, b9_.mfa_expires_at AS mfa_expires_at_206, b9_.is_hybrid_recruiter AS is_hybrid_recruiter_207, b9_.address AS address_208, b9_.created_at AS created_at_209, b9_.updated_at AS updated_at_210, b10_.id AS id_211, b10_.name AS name_212, b10_.email AS email_213, b10_.user_type AS user_type_214, b10_.roles AS roles_215, b10_.password AS password_216, b10_.is_verified AS is_verified_217, b10_.oauth_provider AS oauth_provider_218, b10_.oauth_id AS oauth_id_219, b10_.profile_picture_filename AS profile_picture_filename_220, b10_.oauth_data AS oauth_data_221, b10_.on_boarding_completed_at AS on_boarding_completed_at_222, b10_.dob AS dob_223, b10_.gender AS gender_224, b10_.stripe_customer_id AS stripe_customer_id_225, b10_.stripe_connect_id AS stripe_connect_id_226, b10_.stripe_account_status AS stripe_account_status_227, b10_.subscription_status AS subscription_status_228, b10_.subscription_ends_at AS subscription_ends_at_229, b10_.custom_fee_structure AS custom_fee_structure_230, b10_.phone1 AS phone1_231, b10_.phone2 AS phone2_232, b10_.bio AS bio_233, b10_.nickname AS nickname_234, b10_.blocked AS blocked_235, b10_.mfa_code AS mfa_code_236, b10_.mfa_expires_at AS mfa_expires_at_237, b10_.is_hybrid_recruiter AS is_hybrid_recruiter_238, b10_.address AS address_239, b10_.created_at AS created_at_240, b10_.updated_at AS updated_at_241, b11_.id AS id_242, b11_.name AS name_243, b11_.address AS address_244, b11_.phone1 AS phone1_245, b11_.phone2 AS phone2_246, b11_.email AS email_247, b11_.website AS website_248, b11_.logo AS logo_249, b11_.average_point AS average_point_250, b11_.company_name AS company_name_251, b11_.contact_person_name AS contact_person_name_252, b11_.contact_email AS contact_email_253, b11_.notification_preferences AS notification_preferences_254, b11_.auto_verify AS auto_verify_255, b11_.created_at AS created_at_256, b11_.updated_at AS updated_at_257, b12_.id AS id_258, b12_.name AS name_259, b12_.address AS address_260, b12_.phone1 AS phone1_261, b12_.phone2 AS phone2_262, b12_.email AS email_263, b12_.website AS website_264, b12_.logo AS logo_265, b12_.average_point AS average_point_266, b12_.company_name AS company_name_267, b12_.contact_person_name AS contact_person_name_268, b12_.contact_email AS contact_email_269, b12_.notification_preferences AS notification_preferences_270, b12_.auto_verify AS auto_verify_271, b12_.created_at AS created_at_272, b12_.updated_at AS updated_at_273, b13_.id AS id_274, b13_.company_name AS company_name_275, b13_.speciality AS speciality_276, b13_.membership_level AS membership_level_277, b13_.rating AS rating_278, b13_.is_verified AS is_verified_279, b13_.stripe_connect_account_id AS stripe_connect_account_id_280, b13_.stripe_account_status AS stripe_account_status_281, b13_.created_at AS created_at_282, b13_.updated_at AS updated_at_283, b14_.id AS id_284, b14_.name AS name_285, b14_.email AS email_286, b14_.user_type AS user_type_287, b14_.roles AS roles_288, b14_.password AS password_289, b14_.is_verified AS is_verified_290, b14_.oauth_provider AS oauth_provider_291, b14_.oauth_id AS oauth_id_292, b14_.profile_picture_filename AS profile_picture_filename_293, b14_.oauth_data AS oauth_data_294, b14_.on_boarding_completed_at AS on_boarding_completed_at_295, b14_.dob AS dob_296, b14_.gender AS gender_297, b14_.stripe_customer_id AS stripe_customer_id_298, b14_.stripe_connect_id AS stripe_connect_id_299, b14_.stripe_account_status AS stripe_account_status_300, b14_.subscription_status AS subscription_status_301, b14_.subscription_ends_at AS subscription_ends_at_302, b14_.custom_fee_structure AS custom_fee_structure_303, b14_.phone1 AS phone1_304, b14_.phone2 AS phone2_305, b14_.bio AS bio_306, b14_.nickname AS nickname_307, b14_.blocked AS blocked_308, b14_.mfa_code AS mfa_code_309, b14_.mfa_expires_at AS mfa_expires_at_310, b14_.is_hybrid_recruiter AS is_hybrid_recruiter_311, b14_.address AS address_312, b14_.created_at AS created_at_313, b14_.updated_at AS updated_at_314, b9_.dtype AS dtype_315, b10_.dtype AS dtype_316, b14_.dtype AS dtype_317 FROM b_application b0_ INNER JOIN b_job b1_ ON b0_.job_id = b1_.id LEFT JOIN b_employer b2_ ON b0_.employer_id = b2_.id LEFT JOIN b_staffing_agency b3_ ON b0_.staffing_agency_id = b3_.id LEFT JOIN b_employer b4_ ON b1_.employer_id = b4_.id LEFT JOIN b_staffing_agency b5_ ON b1_.staffing_agency_id = b5_.id LEFT JOIN b_recruiter b6_ ON b0_.recruiter_id = b6_.id LEFT JOIN b_recruiter b7_ ON b1_.assigned_recruiter_id = b7_.id LEFT JOIN b_job_recruiter b15_ ON b1_.id = b15_.job_id LEFT JOIN b_provider b8_ ON b0_.provider_id = b8_.id LEFT JOIN b_user b9_ ON b8_.user_id = b9_.id AND b9_.dtype IN ('user') LEFT JOIN b_user b10_ ON b1_.user_id = b10_.id AND b10_.dtype IN ('user') LEFT JOIN b_employer b11_ ON b10_.employer_id = b11_.id LEFT JOIN b_staffing_agency b12_ ON b10_.staffing_agency_id = b12_.id LEFT JOIN b_recruiter b13_ ON b10_.id = b13_.user_id LEFT JOIN b_user b14_ ON b7_.user_id = b14_.id AND b14_.dtype IN ('user') WHERE 1 = 1 AND b0_.archived_at IS NULL AND b0_.status IN (?) AND b0_.employer_id = ?) dctrn_result_inner ORDER BY id_3 DESC) dctrn_result LIMIT 25
Parameters: 
[
  "applied"
  b"\x1F\x11<èÿ¾l¨»ºKú5\x18\x14‰"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.46 ms
(5.90%) 		2 
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.speciality AS speciality_3, t0.membership_level AS membership_level_4, t0.rating AS rating_5, t0.is_verified AS is_verified_6, t0.stripe_connect_account_id AS stripe_connect_account_id_7, t0.stripe_account_status AS stripe_account_status_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.user_id AS user_id_11 FROM b_recruiter t0 WHERE t0.user_id = ?
Parameters: 
[
  b"""
    \x1F\x11=\x1E\x1Eýmx•¤µ\n
    Ã!ƒ¸
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
1.45 ms
(5.88%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.user_type AS user_type_4, t0.roles AS roles_5, t0.password AS password_6, t0.is_verified AS is_verified_7, t0.oauth_provider AS oauth_provider_8, t0.oauth_id AS oauth_id_9, t0.profile_picture_filename AS profile_picture_filename_10, t0.oauth_data AS oauth_data_11, t0.on_boarding_completed_at AS on_boarding_completed_at_12, t0.dob AS dob_13, t0.gender AS gender_14, t0.stripe_customer_id AS stripe_customer_id_15, t0.stripe_connect_id AS stripe_connect_id_16, t0.stripe_account_status AS stripe_account_status_17, t0.subscription_status AS subscription_status_18, t0.subscription_ends_at AS subscription_ends_at_19, t0.custom_fee_structure AS custom_fee_structure_20, t0.phone1 AS phone1_21, t0.phone2 AS phone2_22, t0.bio AS bio_23, t0.nickname AS nickname_24, t0.blocked AS blocked_25, t0.mfa_code AS mfa_code_26, t0.mfa_expires_at AS mfa_expires_at_27, t0.is_hybrid_recruiter AS is_hybrid_recruiter_28, t0.address AS address_29, t0.created_at AS created_at_30, t0.updated_at AS updated_at_31, t0.employer_id AS employer_id_32, t0.staffing_agency_id AS staffing_agency_id_33, t35.id AS id_34, t35.name AS name_36, t35.suffix AS suffix_37, t35.title AS title_38, t35.npi_number AS npi_number_39, t35.phone_home AS phone_home_40, t35.phone_work AS phone_work_41, t35.phone_mobile AS phone_mobile_42, t35.cv_filename AS cv_filename_43, t35.country AS country_44, t35.state AS state_45, t35.city AS city_46, t35.zip_code AS zip_code_47, t35.street_address AS street_address_48, t35.desired_pay_rate AS desired_pay_rate_49, t35.pay_rate_hourly AS pay_rate_hourly_50, t35.pay_rate_daily AS pay_rate_daily_51, t35.desired_hour AS desired_hour_52, t35.desired_states AS desired_states_53, t35.availability_to_start AS availability_to_start_54, t35.willing_to_travel AS willing_to_travel_55, t35.preferred_patient_volume AS preferred_patient_volume_56, t35.release_authorization_date AS release_authorization_date_57, t35.ssn AS ssn_58, t35.dob AS dob_59, t35.country_of_birth AS country_of_birth_60, t35.state_of_birth AS state_of_birth_61, t35.city_of_birth AS city_of_birth_62, t35.release_and_authorization_accepted AS release_and_authorization_accepted_63, t35.application_certification_date AS application_certification_date_64, t35.risk_assessment AS risk_assessment_65, t35.health_assessment AS health_assessment_66, t35.cashback AS cashback_67, t35.notification_preferences AS notification_preferences_68, t35.average_point AS average_point_69, t35.skip_onboarding AS skip_onboarding_70, t35.professional_references AS professional_references_71, t35.rewards_points AS rewards_points_72, t35.created_at AS created_at_73, t35.updated_at AS updated_at_74, t35.user_id AS user_id_75, t35.profession_id AS profession_id_76, t78.id AS id_77, t78.company_name AS company_name_79, t78.speciality AS speciality_80, t78.membership_level AS membership_level_81, t78.rating AS rating_82, t78.is_verified AS is_verified_83, t78.stripe_connect_account_id AS stripe_connect_account_id_84, t78.stripe_account_status AS stripe_account_status_85, t78.created_at AS created_at_86, t78.updated_at AS updated_at_87, t78.user_id AS user_id_88, t90.id AS id_89, t90.balance AS balance_91, t90.updated_at AS updated_at_92, t90.user_id AS user_id_93, t0.membership_tier_id AS membership_tier_id_94, t0.recruiter_id AS recruiter_id_95, t0.dtype FROM b_user t0 LEFT JOIN b_provider t35 ON t35.user_id = t0.id LEFT JOIN b_recruiter t78 ON t78.user_id = t0.id LEFT JOIN b_credit_wallet t90 ON t90.user_id = t0.id WHERE t0.id = ? AND t0.dtype IN ('user')
Parameters: 
[
  b"\x1F\x11<Ú\x1DÅd\x1C╗\x1FK·5\x18\x14ë"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.37 ms
(5.57%) 		2 
SELECT t0.id AS id_1, t0.balance AS balance_2, t0.updated_at AS updated_at_3, t0.user_id AS user_id_4 FROM b_credit_wallet t0 WHERE t0.user_id = ? LIMIT 1
Parameters: 
[
  b"\x1F\x11<Ú\x1DÅd\x1C╗\x1FK·5\x18\x14ë"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.10 ms
(4.46%) 		1 
SELECT b0_.status AS status_0, COUNT(b0_.id) AS sclr_1 FROM b_application b0_ WHERE b0_.employer_id = ? AND b0_.archived_at IS NULL GROUP BY b0_.status
Parameters: 
[
  b"\x1F\x11<èÿ¾l¨»ºKú5\x18\x14‰"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.06 ms
(4.29%) 		1 
SELECT t0.id AS id_1, t0.notification_type AS notification_type_2, t0.user_type AS user_type_3, t0.message AS message_4, t0.seen AS seen_5, t0.extra_data AS extra_data_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.user_id AS user_id_9 FROM b_notification t0 WHERE t0.user_type = ? AND t0.seen = ? AND t0.user_id = ? ORDER BY t0.created_at DESC LIMIT 5
Parameters: 
[
  "EMPLOYER"
  0
  b"\x1F\x11<Ú\x1DÅd\x1C╗\x1FK·5\x18\x14ë"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.96 ms
(3.90%) 		2 
SELECT t0.id AS id_1, t0.balance AS balance_2, t0.updated_at AS updated_at_3, t0.user_id AS user_id_4 FROM b_credit_wallet t0 WHERE t0.user_id = ?
Parameters: 
[
  b"""
    \x1F\x11=\x1E\x1Eýmx•¤µ\n
    Ã!ƒ¸
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
0.87 ms
(3.54%) 		1 
SELECT t0.id AS id_1, t0.notification_type AS notification_type_2, t0.user_type AS user_type_3, t0.message AS message_4, t0.seen AS seen_5, t0.extra_data AS extra_data_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.user_id AS user_id_9 FROM b_notification t0 WHERE t0.user_id = ? AND t0.user_type = ? AND t0.seen = ?
Parameters: 
[
  b"\x1F\x11<Ú\x1DÅd\x1C╗\x1FK·5\x18\x14ë"
  "EMPLOYER"
  0
]
View formatted query    View runnable query    Explain query    View query backtrace
0.60 ms
(2.41%) 		1 
SELECT count(b0_.id) AS sclr_0 FROM b_application b0_ INNER JOIN b_job b1_ ON b0_.job_id = b1_.id WHERE b1_.employer_id = ? AND b0_.archived_at IS NULL
Parameters: 
[
  b"\x1F\x11<èÿ¾l¨»ºKú5\x18\x14‰"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.55 ms
(2.22%) 		1 
SELECT t0.id AS id_1, t0.config_key AS config_key_2, t0.config_value AS config_value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM b_config t0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Notification 44
App\Entity\Config 23
App\Entity\ToDo 11
App\Entity\DocumentRequest 9
App\Entity\Application 7
App\Entity\Job 7
App\Entity\Speciality 6
App\Entity\Profession 4
App\Entity\User 3
App\Entity\MembershipTier 3
App\Entity\CreditWallet 2
App\Entity\Provider 2
App\Entity\Employer 1
App\Entity\Recruiter 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Employer No errors.
App\Entity\StaffingAgency No errors.
App\Entity\Provider No errors.
App\Entity\Profession No errors.
App\Entity\Recruiter No errors.
App\Entity\CreditWallet No errors.
App\Entity\MembershipTier No errors.
App\Entity\Education No errors.
App\Entity\Experience No errors.
App\Entity\Insurance No errors.
App\Entity\License No errors.
App\Entity\Application No errors.
App\Entity\Job No errors.
App\Entity\Interview No errors.
App\Entity\DocumentRequest No errors.
App\Entity\Review No errors.
App\Entity\JobRecruiter No errors.
App\Entity\Speciality No errors.
App\Entity\Invoice No errors.
App\Entity\ToDo No errors.
App\Entity\Bookmark No errors.
App\Entity\Config No errors.
App\Entity\Notification No errors.