https://mbobanen.staging.03.getnoticed.nl/applicant_snippet/open

Query Metrics

8 Database Queries
6 Different statements
20.47 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
13.63 ms
(66.59%)
1
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.insertion AS insertion_3, t0.last_name AS last_name_4, t0.city AS city_5, t0.phone AS phone_6, t0.intl_phone AS intl_phone_7, t0.email AS email_8, t0.created_at AS created_at_9, t0.file_name AS file_name_10, t0.file_size AS file_size_11, t0.file_name_motivation AS file_name_motivation_12, t0.file_size_motivation AS file_size_motivation_13, t0.motivation AS motivation_14, t0.description AS description_15, t0.data AS data_16, t0.question_answer_data AS question_answer_data_17, t0.privacy_policy AS privacy_policy_18, t0.applicant_send_to_applicant_mail AS applicant_send_to_applicant_mail_19, t0.linkedin_profile_url AS linkedin_profile_url_20, t0.deleted_at AS deleted_at_21, t0.clone AS clone_22, t0.manual AS manual_23, t0.sent_at AS sent_at_24, t0.external_id AS external_id_25, t0.external_candidate_id AS external_candidate_id_26, t0.updated_at AS updated_at_27, t0.utm AS utm_28, t0.knockout_question_answers AS knockout_question_answers_29, t0.rejected_by_knockout AS rejected_by_knockout_30, t0.locale AS locale_31, t0.external_resume_id AS external_resume_id_32, t0.apply_url AS apply_url_33, t0.anonymized AS anonymized_34, t0.vacancy_id AS vacancy_id_35, t36.id AS id_37, t36.active AS active_38, t36.created AS created_39, t36.updated AS updated_40, t36.sort_date AS sort_date_41, t36.contact_person AS contact_person_42, t36.contact_person_phone AS contact_person_phone_43, t36.slug AS slug_44, t36.title AS title_45, t36.company_name AS company_name_46, t36.city AS city_47, t36.zipcode AS zipcode_48, t36.external_url AS external_url_49, t36.intro AS intro_50, t36.description AS description_51, t36.featured AS featured_52, t36.internal_vacancy AS internal_vacancy_53, t36.start_date AS start_date_54, t36.end_date AS end_date_55, t36.job_start_date AS job_start_date_56, t36.applicant_form_custom AS applicant_form_custom_57, t36.applicant_email AS applicant_email_58, t36.deleted AS deleted_59, t36.external_reference AS external_reference_60, t36.synced AS synced_61, t36.youtube AS youtube_62, t36.external_id AS external_id_63, t36.displayable_external_id AS displayable_external_id_64, t36.master_vacancy AS master_vacancy_65, t36.country AS country_66, t36.salary_amount AS salary_amount_67, t36.salary_currency AS salary_currency_68, t36.min_salary_amount AS min_salary_amount_69, t36.min_salary_currency AS min_salary_currency_70, t36.max_salary_amount AS max_salary_amount_71, t36.max_salary_currency AS max_salary_currency_72, t36.custom_salary AS custom_salary_73, t36.redirect_count AS redirect_count_74, t36.province AS province_75, t36.company_information AS company_information_76, t36.has_more_info_button AS has_more_info_button_77, t36.owner_notified AS owner_notified_78, t36.`function` AS function_79, t36.external_detail_url AS external_detail_url_80, t36.google_for_job_mapping AS google_for_job_mapping_81, t36.salary_unit AS salary_unit_82, t36.department AS department_83, t36.google_cloud_name AS google_cloud_name_84, t36.address AS address_85, t36.latitude AS latitude_86, t36.longitude AS longitude_87, t36.external_hash AS external_hash_88, t36.meta_title AS meta_title_89, t36.meta_description AS meta_description_90, t36.utm_medium AS utm_medium_91, t36.utm_campaign AS utm_campaign_92, t36.detail_image_asset_id AS detail_image_asset_id_93, t36.overview_image_asset_id AS overview_image_asset_id_94, t36.hero_image_asset_id AS hero_image_asset_id_95, t36.company_id AS company_id_96, t36.recruiter_id AS recruiter_id_97, t36.main_icon_id AS main_icon_id_98, t36.usp_sub_title_id AS usp_sub_title_id_99, t36.description_form_id AS description_form_id_100, t36.applicant_form_id AS applicant_form_id_101, t36.custom_applicant_form_id AS custom_applicant_form_id_102, t36.invoice_id AS invoice_id_103, t36.template_id AS template_id_104, t36.company_logo_asset_id AS company_logo_asset_id_105, t36.multi_poster_id AS multi_poster_id_106, t36.primary_discipline_id AS primary_discipline_id_107, t36.secundary_discipline_id AS secundary_discipline_id_108, t36.harver_experience_id AS harver_experience_id_109, t36.application_process_id AS application_process_id_110, t36.domain_id AS domain_id_111, t36.calendar_id AS calendar_id_112, t36.gallery_id AS gallery_id_113, t36.og_image_id AS og_image_id_114, t36.site_id AS site_id_115, t0.status_id AS status_id_116, t0.manual_mail_id AS manual_mail_id_117, t0.gdpr_id AS gdpr_id_118, t0.company_id AS company_id_119, t0.applicant_form_id AS applicant_form_id_120 FROM applicant t0 LEFT JOIN vacancy t36 ON t0.vacancy_id = t36.id AND ((t36.deleted IS NULL)) WHERE t0.applicant_form_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  1
]
1.95 ms
(9.53%)
2
SELECT f0_.name AS name_0, f0_.active AS active_1 FROM feature f0_
Parameters:
[]
1.89 ms
(9.22%)
2
SELECT t0.name AS name_1, t0.section AS section_2, t0.value AS value_3, t0.type AS type_4 FROM configuration_setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_vacancy_mobile_open_application_form"
]
1.31 ms
(6.39%)
1
SELECT DATABASE()
Parameters:
[]
0.95 ms
(4.65%)
1
SELECT g0_.id AS id_0, g0_.title AS title_1, g0_.location AS location_2, g0_.script AS script_3, g0_.type AS type_4 FROM google_tag_manager g0_ WHERE g0_.type = ?
Parameters:
[
  "script"
]
0.74 ms
(3.62%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.privacy_statement AS privacy_statement_3, t0.privacy_statement_is_required AS privacy_statement_is_required_4, t0.privacy_statement_text AS privacy_statement_text_5, t0.`default` AS default_6, t0.fields AS fields_7, t0.open_form AS open_form_8, t0.captcha AS captcha_9, t0.external_vacancy_id AS external_vacancy_id_10, t0.external_id AS external_id_11, t0.external_reference AS external_reference_12, t0.external_hash AS external_hash_13 FROM applicant_form t0 WHERE t0.id = ?
Parameters:
[
  "1"
]

Database Connections

Name Service
default doctrine.dbal.default_connection
parent doctrine.dbal.parent_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
parent doctrine.orm.parent_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\CustomTranslation No errors.
App\Entity\GoogleTagManager No errors.
App\Entity\CompanyMatch No errors.
App\Entity\Vacancy No errors.
App\Entity\WebServiceApiKey No errors.
App\Entity\Redirect No errors.
App\Entity\ApplicantForm No errors.
App\Entity\ConfigurationSetting No errors.
App\Entity\GdprStatement No errors.
App\Entity\OptionValue No errors.
App\Entity\Applicant No errors.
App\Entity\Feature No errors.
App\Entity\Asset No errors.
App\Entity\Company No errors.
App\Entity\Base No errors.
App\Entity\ContentBase No errors.
App\Entity\Recruiter No errors.
App\Entity\USP No errors.
App\Entity\VacancyDescriptionForm No errors.
App\Entity\Invoice No errors.
App\Entity\VacancyTemplate No errors.
App\Entity\MultiPoster No errors.
App\Entity\HarverExperience No errors.
App\Entity\ApplicationProcessItemCollection No errors.
App\Entity\VacancyDomain No errors.
App\Entity\Calendar No errors.
App\Entity\Gallery No errors.
App\Entity\OgImage No errors.
App\Entity\Site No errors.
App\Entity\Status No errors.
App\Entity\Mail No errors.

parent entity manager

No loaded entities.