https://ourhoneybee.eu/hire

Method
GET
HTTP Status
200
IP
18.97.14.91
Profiled on
Token
6c145c

Query Metrics

1 Database Queries
1 Different statements
47.26 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

company_group connection

Time▼ Count Info
47.26 ms
(100.00%) 		1 
SELECT e0_.applicant_id AS applicant_id_0, e0_.sync_flag AS sync_flag_1, e0_.ids_by_device AS ids_by_device_2, e0_.schedule_available_flag AS schedule_available_flag_3, e0_.device_id AS device_id_4, e0_.device_id_locked_flag AS device_id_locked_flag_5, e0_.lock_device_id_on_next_login_flag AS lock_device_id_on_next_login_flag_6, e0_.username AS username_7, e0_.email AS email_8, e0_.o_auth_unique_id AS o_auth_unique_id_9, e0_.o_auth_email AS o_auth_email_10, e0_.fb_unique_id AS fb_unique_id_11, e0_.li_unique_id AS li_unique_id_12, e0_.google_unique_id AS google_unique_id_13, e0_.fb_profile_link AS fb_profile_link_14, e0_.fb_profile_id AS fb_profile_id_15, e0_.ig_profile_link AS ig_profile_link_16, e0_.ig_profile_id AS ig_profile_id_17, e0_.li_profile_link AS li_profile_link_18, e0_.li_profile_id AS li_profile_id_19, e0_.user_suspended_app_ids AS user_suspended_app_ids_20, e0_.user_app_ids AS user_app_ids_21, e0_.user_types_by_app_ids AS user_types_by_app_ids_22, e0_.password AS password_23, e0_.temp_password AS temp_password_24, e0_.salt AS salt_25, e0_.email_verification_hash AS email_verification_hash_26, e0_.phone_verification_hash AS phone_verification_hash_27, e0_.trigger_reset_password AS trigger_reset_password_28, e0_.otp_action_id AS otp_action_id_29, e0_.otp AS otp_30, e0_.otp_expire_ts AS otp_expire_ts_31, e0_.forgot_password_token AS forgot_password_token_32, e0_.forgot_password_token_expire_ts AS forgot_password_token_expire_ts_33, e0_.is_email_verified AS is_email_verified_34, e0_.is_phone_verified AS is_phone_verified_35, e0_.is_banned AS is_banned_36, e0_.ban_expires AS ban_expires_37, e0_.strike_count AS strike_count_38, e0_.strike_threshold AS strike_threshold_39, e0_.account_status AS account_status_40, e0_.student_level AS student_level_41, e0_.job_applicant_level AS job_applicant_level_42, e0_.consultant_level AS consultant_level_43, e0_.nationality_country_id AS nationality_country_id_44, e0_.current_country_id AS current_country_id_45, e0_.user_id AS user_id_46, e0_.firstname AS firstname_47, e0_.lastname AS lastname_48, e0_.image AS image_49, e0_.is_img_legal AS is_img_legal_50, e0_.nid AS nid_51, e0_.dob AS dob_52, e0_.sex AS sex_53, e0_.father AS father_54, e0_.mother AS mother_55, e0_.spouse AS spouse_56, e0_.child_1 AS child_1_57, e0_.child_2 AS child_2_58, e0_.blood AS blood_59, e0_.religion AS religion_60, e0_.phone AS phone_61, e0_.official_phone AS official_phone_62, e0_.phone_with_country_code AS phone_with_country_code_63, e0_.phone_country_code AS phone_country_code_64, e0_.curr_addr_state AS curr_addr_state_65, e0_.curr_addr_city AS curr_addr_city_66, e0_.curr_addr_zip AS curr_addr_zip_67, e0_.curr_addr AS curr_addr_68, e0_.curr_addr_lat AS curr_addr_lat_69, e0_.curr_addr_lng AS curr_addr_lng_70, e0_.perm_addr AS perm_addr_71, e0_.emm_contact AS emm_contact_72, e0_.skill AS skill_73, e0_.preferred_topic_ids_as_consultant AS preferred_topic_ids_as_consultant_74, e0_.preferred_topic_ids_as_student AS preferred_topic_ids_as_student_75, e0_.preferred_country_ids_as_consultant AS preferred_country_ids_as_consultant_76, e0_.preferred_country_ids_as_student AS preferred_country_ids_as_student_77, e0_.joining_date AS joining_date_78, e0_.emp_valid_till AS emp_valid_till_79, e0_.emp_status AS emp_status_80, e0_.emp_type AS emp_type_81, e0_.emp_code AS emp_code_82, e0_.emp_label AS emp_label_83, e0_.tin AS tin_84, e0_.tin_valid_till AS tin_valid_till_85, e0_.med_ins AS med_ins_86, e0_.med_ins_valid_till AS med_ins_valid_till_87, e0_.docs AS docs_88, e0_.inst1 AS inst1_89, e0_.yr1 AS yr1_90, e0_.dur1 AS dur1_91, e0_.inst2 AS inst2_92, e0_.yr2 AS yr2_93, e0_.dur2 AS dur2_94, e0_.inst3 AS inst3_95, e0_.yr3 AS yr3_96, e0_.dur3 AS dur3_97, e0_.einst1 AS einst1_98, e0_.eyr1 AS eyr1_99, e0_.edeg1 AS edeg1_100, e0_.einst2 AS einst2_101, e0_.eyr2 AS eyr2_102, e0_.edeg2 AS edeg2_103, e0_.einst3 AS einst3_104, e0_.eyr3 AS eyr3_105, e0_.edeg3 AS edeg3_106, e0_.tax_code AS tax_code_107, e0_.allowed_working_hours_per_day AS allowed_working_hours_per_day_108, e0_.allowed_working_hours_per_week AS allowed_working_hours_per_week_109, e0_.allowed_working_hours_per_month AS allowed_working_hours_per_month_110, e0_.allowed_working_hours_per_year AS allowed_working_hours_per_year_111, e0_.allowed_earning_per_day AS allowed_earning_per_day_112, e0_.allowed_earning_per_week AS allowed_earning_per_week_113, e0_.allowed_earning_per_month AS allowed_earning_per_month_114, e0_.allowed_earning_per_year AS allowed_earning_per_year_115, e0_.revenue_percentage_per_session AS revenue_percentage_per_session_116, e0_.transaction_acc_no AS transaction_acc_no_117, e0_.transaction_acc_name AS transaction_acc_name_118, e0_.bank_id AS bank_id_119, e0_.bank_branch_code AS bank_branch_code_120, e0_.bank_acc AS bank_acc_121, e0_.bank_name AS bank_name_122, e0_.bank_acc_name AS bank_acc_name_123, e0_.bank_acc_type AS bank_acc_type_124, e0_.bank_acc_valid_from AS bank_acc_valid_from_125, e0_.bank_acc_valid_to AS bank_acc_valid_to_126, e0_.routing_code AS routing_code_127, e0_.swift_code AS swift_code_128, e0_.mobile_wallet_no AS mobile_wallet_no_129, e0_.mobile_wallet_type AS mobile_wallet_type_130, e0_.ear1 AS ear1_131, e0_.ear2 AS ear2_132, e0_.ear3 AS ear3_133, e0_.ear4 AS ear4_134, e0_.ear5 AS ear5_135, e0_.ear6 AS ear6_136, e0_.eart AS eart_137, e0_.ded1 AS ded1_138, e0_.ded2 AS ded2_139, e0_.ded3 AS ded3_140, e0_.ded4 AS ded4_141, e0_.dedt AS dedt_142, e0_.payable AS payable_143, e0_.hand_cash AS hand_cash_144, e0_.bank_transfer AS bank_transfer_145, e0_.sec_dep AS sec_dep_146, e0_.sec_dep_span AS sec_dep_span_147, e0_.sec_dep_rem_mon AS sec_dep_rem_mon_148, e0_.sec_dep_rem_amount AS sec_dep_rem_amount_149, e0_.sl_qty AS sl_qty_150, e0_.sl_tkn AS sl_tkn_151, e0_.sl_freq AS sl_freq_152, e0_.ml_qty AS ml_qty_153, e0_.ml_tkn AS ml_tkn_154, e0_.ml_freq AS ml_freq_155, e0_.el_qty AS el_qty_156, e0_.el_tkn AS el_tkn_157, e0_.el_freq AS el_freq_158, e0_.cl_qty AS cl_qty_159, e0_.cl_tkn AS cl_tkn_160, e0_.cl_freq AS cl_freq_161, e0_.levt AS levt_162, e0_.weekly_holiday AS weekly_holiday_163, e0_.files AS files_164, e0_.supervisor AS supervisor_165, e0_.dept AS dept_166, e0_.desg AS desg_167, e0_.branch AS branch_168, e0_.division AS division_169, e0_.application_text AS application_text_170, e0_.current_employment AS current_employment_171, e0_.emergency_contact_number AS emergency_contact_number_172, e0_.postal_code AS postal_code_173, e0_.country AS country_174, e0_.education_data AS education_data_175, e0_.work_experience_data AS work_experience_data_176, e0_.certificate_data AS certificate_data_177, e0_.languages_data AS languages_data_178, e0_.important_comm_tags AS important_comm_tags_179, e0_.is_consultant AS is_consultant_180, e0_.is_featured AS is_featured_181, e0_.featured_duration_end_ts AS featured_duration_end_ts_182, e0_.is_moderator AS is_moderator_183, e0_.is_admin AS is_admin_184, e0_.admin_level AS admin_level_185, e0_.is_retailer AS is_retailer_186, e0_.retailer_level AS retailer_level_187, e0_.is_student AS is_student_188, e0_.preferred_consultancy_types_as_student AS preferred_consultancy_types_as_student_189, e0_.preferred_consultancy_types_as_consultant AS preferred_consultancy_types_as_consultant_190, e0_.online_status AS online_status_191, e0_.assigned_sales_representative_id AS assigned_sales_representative_id_192, e0_.lead_created_by_id AS lead_created_by_id_193, e0_.is_temporary_entry AS is_temporary_entry_194, e0_.lead_type AS lead_type_195, e0_.lead_level AS lead_level_196, e0_.immediate_follow_up_flag AS immediate_follow_up_flag_197, e0_.pending_initial_communication AS pending_initial_communication_198, e0_.last_online_ts AS last_online_ts_199, e0_.courses_data AS courses_data_200, e0_.video_link AS video_link_201, e0_.account_balance AS account_balance_202, e0_.session_count_balance AS session_count_balance_203, e0_.total_session_used AS total_session_used_204, e0_.total_consultancy_session_provided AS total_consultancy_session_provided_205, e0_.total_individual_consultancy_session_provided AS total_individual_consultancy_session_provided_206, e0_.default_currency_id AS default_currency_id_207, e0_.default_language_id AS default_language_id_208, e0_.country_id AS country_id_209, e0_.following_consultant_ids AS following_consultant_ids_210, e0_.following_topic_ids AS following_topic_ids_211, e0_.viewed_topic_ids AS viewed_topic_ids_212, e0_.viewed_consultant_ids AS viewed_consultant_ids_213, e0_.following_event_ids AS following_event_ids_214, e0_.attending_event_ids AS attending_event_ids_215, e0_.skip_event_ids AS skip_event_ids_216, e0_.rating AS rating_217, e0_.applicant_specific_note AS applicant_specific_note_218, e0_.promo_discount_percentage AS promo_discount_percentage_219, e0_.promo_discount_balance_count AS promo_discount_balance_count_220, e0_.code_as_referer AS code_as_referer_221, e0_.referred_code AS referred_code_222, e0_.is_referred_code_used AS is_referred_code_used_223, e0_.promo_code_id AS promo_code_id_224, e0_.max_discount_allowed AS max_discount_allowed_225, e0_.claimed_promo_code_ids AS claimed_promo_code_ids_226, e0_.referred_coins_earned AS referred_coins_earned_227, e0_.referred_amount_earned AS referred_amount_earned_228, e0_.rating_weight AS rating_weight_229, e0_.rating_total AS rating_total_230, e0_.rating_count AS rating_count_231, e0_.preferred_consultancy_language_ids AS preferred_consultancy_language_ids_232, e0_.preferred_consultancy_topic_country_ids AS preferred_consultancy_topic_country_ids_233, e0_.preferred_consultancy_student_country_ids AS preferred_consultancy_student_country_ids_234, e0_.preferred_schedule_data_for_getting_consultancy AS preferred_schedule_data_for_getting_consultancy_235, e0_.preferred_schedule_data_for_providing_consultancy AS preferred_schedule_data_for_providing_consultancy_236, e0_.selector AS selector_237, e0_.apply_for_consultant AS apply_for_consultant_238, e0_.apply_for_consultant_date AS apply_for_consultant_date_239, e0_.consultant_application_feedback AS consultant_application_feedback_240, e0_.apply_for_retailer AS apply_for_retailer_241, e0_.apply_for_retailer_date AS apply_for_retailer_date_242, e0_.doc_image AS doc_image_243, e0_.document_list AS document_list_244, e0_.document_list_by_topic_id AS document_list_by_topic_id_245, e0_.document_list_by_session_id AS document_list_by_session_id_246, e0_.work_experience_year AS work_experience_year_247, e0_.description AS description_248, e0_.summary_text AS summary_text_249, e0_.professional_title AS professional_title_250, e0_.work_experience_text AS work_experience_text_251, e0_.profession_text AS profession_text_252, e0_.education_text AS education_text_253, e0_.education_major_text AS education_major_text_254, e0_.highest_degree_achieved AS highest_degree_achieved_255, e0_.target_education_degree AS target_education_degree_256, e0_.target_education_major AS target_education_major_257, e0_.lead_query_text AS lead_query_text_258, e0_.university_text AS university_text_259, e0_.experience_text AS experience_text_260, e0_.skillstext AS skillstext_261, e0_.interest AS interest_262, e0_.speciality AS speciality_263, e0_.last_settings_updated_ts AS last_settings_updated_ts_264, e0_.created_at AS created_at_265, e0_.actual_registration_at AS actual_registration_at_266, e0_.updated_at AS updated_at_267 FROM entity_applicant_details e0_ WHERE e0_.is_consultant = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection
company_group doctrine.dbal.company_group_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
company_group doctrine.orm.company_group_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

No loaded entities.

company_group entity manager

Class Mapping errors
CompanyGroupBundle\Entity\EntityApplicantDetails No errors.