Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

50 Database Queries

29 Different statements

211.38 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼	Count	Info
62.64 ms (29.63%)	1	SELECT t0.id AS id_1, t0.active AS active_2, t0.created AS created_3, t0.updated AS updated_4, t0.sort_date AS sort_date_5, t0.contact_person AS contact_person_6, t0.contact_person_phone AS contact_person_phone_7, t0.slug AS slug_8, t0.title AS title_9, t0.company_name AS company_name_10, t0.city AS city_11, t0.zipcode AS zipcode_12, t0.external_url AS external_url_13, t0.intro AS intro_14, t0.description AS description_15, t0.featured AS featured_16, t0.internal_vacancy AS internal_vacancy_17, t0.start_date AS start_date_18, t0.end_date AS end_date_19, t0.job_start_date AS job_start_date_20, t0.applicant_form_custom AS applicant_form_custom_21, t0.applicant_email AS applicant_email_22, t0.deleted AS deleted_23, t0.external_reference AS external_reference_24, t0.synced AS synced_25, t0.youtube AS youtube_26, t0.external_id AS external_id_27, t0.displayable_external_id AS displayable_external_id_28, t0.master_vacancy AS master_vacancy_29, t0.country AS country_30, t0.salary_amount AS salary_amount_31, t0.salary_currency AS salary_currency_32, t0.min_salary_amount AS min_salary_amount_33, t0.min_salary_currency AS min_salary_currency_34, t0.max_salary_amount AS max_salary_amount_35, t0.max_salary_currency AS max_salary_currency_36, t0.custom_salary AS custom_salary_37, t0.redirect_count AS redirect_count_38, t0.province AS province_39, t0.company_information AS company_information_40, t0.has_more_info_button AS has_more_info_button_41, t0.owner_notified AS owner_notified_42, t0.`function` AS function_43, t0.external_detail_url AS external_detail_url_44, t0.google_for_job_mapping AS google_for_job_mapping_45, t0.salary_unit AS salary_unit_46, t0.department AS department_47, t0.google_cloud_name AS google_cloud_name_48, t0.address AS address_49, t0.latitude AS latitude_50, t0.longitude AS longitude_51, t0.external_hash AS external_hash_52, t0.meta_title AS meta_title_53, t0.meta_description AS meta_description_54, t0.utm_medium AS utm_medium_55, t0.utm_campaign AS utm_campaign_56, t0.detail_image_asset_id AS detail_image_asset_id_57, t0.overview_image_asset_id AS overview_image_asset_id_58, t59.id AS id_60, t59.file_name AS file_name_61, t59.file_size AS file_size_62, t59.file_mime_type AS file_mime_type_63, t59.meta_information AS meta_information_64, t59.updated_at AS updated_at_65, t59.external_id AS external_id_66, t59.folder_id AS folder_id_67, t0.hero_image_asset_id AS hero_image_asset_id_68, t0.company_id AS company_id_69, t70.id AS id_71, t70.slug AS slug_72, t70.name AS name_73, t70.zipcode AS zipcode_74, t70.city AS city_75, t70.country AS country_76, t70.contact_person AS contact_person_77, t70.contact_person_gender AS contact_person_gender_78, t70.contact_person_first_name AS contact_person_first_name_79, t70.contact_person_initials AS contact_person_initials_80, t70.contact_person_prefix AS contact_person_prefix_81, t70.contact_person_last_name AS contact_person_last_name_82, t70.phone AS phone_83, t70.extension AS extension_84, t70.mobile AS mobile_85, t70.website AS website_86, t70.email AS email_87, t70.updated_at AS updated_at_88, t70.applicant_email AS applicant_email_89, t70.description AS description_90, t70.external_id AS external_id_91, t70.canonical_url AS canonical_url_92, t70.deleted AS deleted_93, t70.openinghours AS openinghours_94, t70.accessibility AS accessibility_95, t70.credits AS credits_96, t70.video AS video_97, t70.action_date AS action_date_98, t70.action_type AS action_type_99, t70.friendly_url AS friendly_url_100, t70.province AS province_101, t70.company_information AS company_information_102, t70.multi_poster_id AS multi_poster_id_103, t70.google_cloud_name AS google_cloud_name_104, t70.featured AS featured_105, t70.department AS department_106, t70.po_number AS po_number_107, t70.invoice_company_name AS invoice_company_name_108, t70.invoice_department AS invoice_department_109, t70.invoice_contact_person AS invoice_contact_person_110, t70.invoice_email_address AS invoice_email_address_111, t70.invoice_address AS invoice_address_112, t70.invoice_zipcode AS invoice_zipcode_113, t70.invoice_city AS invoice_city_114, t70.invoice_phone AS invoice_phone_115, t70.detail_page AS detail_page_116, t70.detail_page_expiration_date AS detail_page_expiration_date_117, t70.address AS address_118, t70.latitude AS latitude_119, t70.longitude AS longitude_120, t70.meta_title AS meta_title_121, t70.meta_description AS meta_description_122, t70.utm_medium AS utm_medium_123, t70.utm_campaign AS utm_campaign_124, t70.logo_asset_id AS logo_asset_id_125, t70.hero_asset_id AS hero_asset_id_126, t70.overview_image_asset_id AS overview_image_asset_id_127, t70.fields_form_id AS fields_form_id_128, t70.hero_configuration_id AS hero_configuration_id_129, t70.company_status_id AS company_status_id_130, t70.action_assignee_id AS action_assignee_id_131, t70.consultant_id AS consultant_id_132, t70.application_process_id AS application_process_id_133, t70.gallery_id AS gallery_id_134, t70.site_id AS site_id_135, t0.recruiter_id AS recruiter_id_136, t137.first_name AS first_name_138, t137.last_name_prefix AS last_name_prefix_139, t137.last_name AS last_name_140, t137.email AS email_141, t137.phone AS phone_142, t137.linkedin_url AS linkedin_url_143, t137.intro AS intro_144, t137.description AS description_145, t137.picture_name AS picture_name_146, t137.country AS country_147, t137.id AS id_148, t137.created_at AS created_at_149, t137.updated_at AS updated_at_150, t137.robots AS robots_151, t137.external_id AS external_id_152, t137.external_reference AS external_reference_153, t137.external_hash AS external_hash_154, t0.main_icon_id AS main_icon_id_155, t0.usp_sub_title_id AS usp_sub_title_id_156, t0.description_form_id AS description_form_id_157, t0.applicant_form_id AS applicant_form_id_158, t0.custom_applicant_form_id AS custom_applicant_form_id_159, t0.invoice_id AS invoice_id_160, t0.template_id AS template_id_161, t0.company_logo_asset_id AS company_logo_asset_id_162, t163.id AS id_164, t163.file_name AS file_name_165, t163.file_size AS file_size_166, t163.file_mime_type AS file_mime_type_167, t163.meta_information AS meta_information_168, t163.updated_at AS updated_at_169, t163.external_id AS external_id_170, t163.folder_id AS folder_id_171, t0.multi_poster_id AS multi_poster_id_172, t0.primary_discipline_id AS primary_discipline_id_173, t0.secundary_discipline_id AS secundary_discipline_id_174, t0.harver_experience_id AS harver_experience_id_175, t0.application_process_id AS application_process_id_176, t0.domain_id AS domain_id_177, t0.calendar_id AS calendar_id_178, t0.gallery_id AS gallery_id_179, t180.id AS id_181, t180.name AS name_182, t180.title AS title_183, t180.intro AS intro_184, t180.context AS context_185, t180.format AS format_186, t180.enabled AS enabled_187, t180.video_embed_id AS video_embed_id_188, t0.og_image_id AS og_image_id_189, t190.id AS id_191, t190.field AS field_192, t190.text_size AS text_size_193, t190.text_color AS text_color_194, t190.text_position AS text_position_195, t190.image_id AS image_id_196, t0.site_id AS site_id_197 FROM vacancy t0 LEFT JOIN asset t59 ON t0.overview_image_asset_id = t59.id LEFT JOIN company t70 ON t0.company_id = t70.id LEFT JOIN recruiter t137 ON t0.recruiter_id = t137.id LEFT JOIN asset t163 ON t0.company_logo_asset_id = t163.id LEFT JOIN gallery t180 ON t0.gallery_id = t180.id LEFT JOIN og_image t190 ON t0.og_image_id = t190.id WHERE t0.id = ? Parameters: [`"351"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.active AS active_2, t0.created AS created_3, t0.updated AS updated_4, t0.sort_date AS sort_date_5, t0.contact_person AS contact_person_6, t0.contact_person_phone AS contact_person_phone_7, t0.slug AS slug_8, t0.title AS title_9, t0.company_name AS company_name_10, t0.city AS city_11, t0.zipcode AS zipcode_12, t0.external_url AS external_url_13, t0.intro AS intro_14, t0.description AS description_15, t0.featured AS featured_16, t0.internal_vacancy AS internal_vacancy_17, t0.start_date AS start_date_18, t0.end_date AS end_date_19, t0.job_start_date AS job_start_date_20, t0.applicant_form_custom AS applicant_form_custom_21, t0.applicant_email AS applicant_email_22, t0.deleted AS deleted_23, t0.external_reference AS external_reference_24, t0.synced AS synced_25, t0.youtube AS youtube_26, t0.external_id AS external_id_27, t0.displayable_external_id AS displayable_external_id_28, t0.master_vacancy AS master_vacancy_29, t0.country AS country_30, t0.salary_amount AS salary_amount_31, t0.salary_currency AS salary_currency_32, t0.min_salary_amount AS min_salary_amount_33, t0.min_salary_currency AS min_salary_currency_34, t0.max_salary_amount AS max_salary_amount_35, t0.max_salary_currency AS max_salary_currency_36, t0.custom_salary AS custom_salary_37, t0.redirect_count AS redirect_count_38, t0.province AS province_39, t0.company_information AS company_information_40, t0.has_more_info_button AS has_more_info_button_41, t0.owner_notified AS owner_notified_42, t0.`function` AS function_43, t0.external_detail_url AS external_detail_url_44, t0.google_for_job_mapping AS google_for_job_mapping_45, t0.salary_unit AS salary_unit_46, t0.department AS department_47, t0.google_cloud_name AS google_cloud_name_48, t0.address AS address_49, t0.latitude AS latitude_50, t0.longitude AS longitude_51, t0.external_hash AS external_hash_52, t0.meta_title AS meta_title_53, t0.meta_description AS meta_description_54, t0.utm_medium AS utm_medium_55, t0.utm_campaign AS utm_campaign_56, t0.detail_image_asset_id AS detail_image_asset_id_57, t0.overview_image_asset_id AS overview_image_asset_id_58, t59.id AS id_60, t59.file_name AS file_name_61, t59.file_size AS file_size_62, t59.file_mime_type AS file_mime_type_63, t59.meta_information AS meta_information_64, t59.updated_at AS updated_at_65, t59.external_id AS external_id_66, t59.folder_id AS folder_id_67, t0.hero_image_asset_id AS hero_image_asset_id_68, t0.company_id AS company_id_69, t70.id AS id_71, t70.slug AS slug_72, t70.name AS name_73, t70.zipcode AS zipcode_74, t70.city AS city_75, t70.country AS country_76, t70.contact_person AS contact_person_77, t70.contact_person_gender AS contact_person_gender_78, t70.contact_person_first_name AS contact_person_first_name_79, t70.contact_person_initials AS contact_person_initials_80, t70.contact_person_prefix AS contact_person_prefix_81, t70.contact_person_last_name AS contact_person_last_name_82, t70.phone AS phone_83, t70.extension AS extension_84, t70.mobile AS mobile_85, t70.website AS website_86, t70.email AS email_87, t70.updated_at AS updated_at_88, t70.applicant_email AS applicant_email_89, t70.description AS description_90, t70.external_id AS external_id_91, t70.canonical_url AS canonical_url_92, t70.deleted AS deleted_93, t70.openinghours AS openinghours_94, t70.accessibility AS accessibility_95, t70.credits AS credits_96, t70.video AS video_97, t70.action_date AS action_date_98, t70.action_type AS action_type_99, t70.friendly_url AS friendly_url_100, t70.province AS province_101, t70.company_information AS company_information_102, t70.multi_poster_id AS multi_poster_id_103, t70.google_cloud_name AS google_cloud_name_104, t70.featured AS featured_105, t70.department AS department_106, t70.po_number AS po_number_107, t70.invoice_company_name AS invoice_company_name_108, t70.invoice_department AS invoice_department_109, t70.invoice_contact_person AS invoice_contact_person_110, t70.invoice_email_address AS invoice_email_address_111, t70.invoice_address AS invoice_address_112, t70.invoice_zipcode AS invoice_zipcode_113, t70.invoice_city AS invoice_city_114, t70.invoice_phone AS invoice_phone_115, t70.detail_page AS detail_page_116, t70.detail_page_expiration_date AS detail_page_expiration_date_117, t70.address AS address_118, t70.latitude AS latitude_119, t70.longitude AS longitude_120, t70.meta_title AS meta_title_121, t70.meta_description AS meta_description_122, t70.utm_medium AS utm_medium_123, t70.utm_campaign AS utm_campaign_124, t70.logo_asset_id AS logo_asset_id_125, t70.hero_asset_id AS hero_asset_id_126, t70.overview_image_asset_id AS overview_image_asset_id_127, t70.fields_form_id AS fields_form_id_128, t70.hero_configuration_id AS hero_configuration_id_129, t70.company_status_id AS company_status_id_130, t70.action_assignee_id AS action_assignee_id_131, t70.consultant_id AS consultant_id_132, t70.application_process_id AS application_process_id_133, t70.gallery_id AS gallery_id_134, t70.site_id AS site_id_135, t0.recruiter_id AS recruiter_id_136, t137.first_name AS first_name_138, t137.last_name_prefix AS last_name_prefix_139, t137.last_name AS last_name_140, t137.email AS email_141, t137.phone AS phone_142, t137.linkedin_url AS linkedin_url_143, t137.intro AS intro_144, t137.description AS description_145, t137.picture_name AS picture_name_146, t137.country AS country_147, t137.id AS id_148, t137.created_at AS created_at_149, t137.updated_at AS updated_at_150, t137.robots AS robots_151, t137.external_id AS external_id_152, t137.external_reference AS external_reference_153, t137.external_hash AS external_hash_154, t0.main_icon_id AS main_icon_id_155, t0.usp_sub_title_id AS usp_sub_title_id_156, t0.description_form_id AS description_form_id_157, t0.applicant_form_id AS applicant_form_id_158, t0.custom_applicant_form_id AS custom_applicant_form_id_159, t0.invoice_id AS invoice_id_160, t0.template_id AS template_id_161, t0.company_logo_asset_id AS company_logo_asset_id_162, t163.id AS id_164, t163.file_name AS file_name_165, t163.file_size AS file_size_166, t163.file_mime_type AS file_mime_type_167, t163.meta_information AS meta_information_168, t163.updated_at AS updated_at_169, t163.external_id AS external_id_170, t163.folder_id AS folder_id_171, t0.multi_poster_id AS multi_poster_id_172, t0.primary_discipline_id AS primary_discipline_id_173, t0.secundary_discipline_id AS secundary_discipline_id_174, t0.harver_experience_id AS harver_experience_id_175, t0.application_process_id AS application_process_id_176, t0.domain_id AS domain_id_177, t0.calendar_id AS calendar_id_178, t0.gallery_id AS gallery_id_179, t180.id AS id_181, t180.name AS name_182, t180.title AS title_183, t180.intro AS intro_184, t180.context AS context_185, t180.format AS format_186, t180.enabled AS enabled_187, t180.video_embed_id AS video_embed_id_188, t0.og_image_id AS og_image_id_189, t190.id AS id_191, t190.field AS field_192, t190.text_size AS text_size_193, t190.text_color AS text_color_194, t190.text_position AS text_position_195, t190.image_id AS image_id_196, t0.site_id AS site_id_197 FROM vacancy t0 LEFT JOIN asset t59 ON t0.overview_image_asset_id = t59.id LEFT JOIN company t70 ON t0.company_id = t70.id LEFT JOIN recruiter t137 ON t0.recruiter_id = t137.id LEFT JOIN asset t163 ON t0.company_logo_asset_id = t163.id LEFT JOIN gallery t180 ON t0.gallery_id = t180.id LEFT JOIN og_image t190 ON t0.og_image_id = t190.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.active AS active_2, t0.created AS created_3, t0.updated AS updated_4, t0.sort_date AS sort_date_5, t0.contact_person AS contact_person_6, t0.contact_person_phone AS contact_person_phone_7, t0.slug AS slug_8, t0.title AS title_9, t0.company_name AS company_name_10, t0.city AS city_11, t0.zipcode AS zipcode_12, t0.external_url AS external_url_13, t0.intro AS intro_14, t0.description AS description_15, t0.featured AS featured_16, t0.internal_vacancy AS internal_vacancy_17, t0.start_date AS start_date_18, t0.end_date AS end_date_19, t0.job_start_date AS job_start_date_20, t0.applicant_form_custom AS applicant_form_custom_21, t0.applicant_email AS applicant_email_22, t0.deleted AS deleted_23, t0.external_reference AS external_reference_24, t0.synced AS synced_25, t0.youtube AS youtube_26, t0.external_id AS external_id_27, t0.displayable_external_id AS displayable_external_id_28, t0.master_vacancy AS master_vacancy_29, t0.country AS country_30, t0.salary_amount AS salary_amount_31, t0.salary_currency AS salary_currency_32, t0.min_salary_amount AS min_salary_amount_33, t0.min_salary_currency AS min_salary_currency_34, t0.max_salary_amount AS max_salary_amount_35, t0.max_salary_currency AS max_salary_currency_36, t0.custom_salary AS custom_salary_37, t0.redirect_count AS redirect_count_38, t0.province AS province_39, t0.company_information AS company_information_40, t0.has_more_info_button AS has_more_info_button_41, t0.owner_notified AS owner_notified_42, t0.`function` AS function_43, t0.external_detail_url AS external_detail_url_44, t0.google_for_job_mapping AS google_for_job_mapping_45, t0.salary_unit AS salary_unit_46, t0.department AS department_47, t0.google_cloud_name AS google_cloud_name_48, t0.address AS address_49, t0.latitude AS latitude_50, t0.longitude AS longitude_51, t0.external_hash AS external_hash_52, t0.meta_title AS meta_title_53, t0.meta_description AS meta_description_54, t0.utm_medium AS utm_medium_55, t0.utm_campaign AS utm_campaign_56, t0.detail_image_asset_id AS detail_image_asset_id_57, t0.overview_image_asset_id AS overview_image_asset_id_58, t59.id AS id_60, t59.file_name AS file_name_61, t59.file_size AS file_size_62, t59.file_mime_type AS file_mime_type_63, t59.meta_information AS meta_information_64, t59.updated_at AS updated_at_65, t59.external_id AS external_id_66, t59.folder_id AS folder_id_67, t0.hero_image_asset_id AS hero_image_asset_id_68, t0.company_id AS company_id_69, t70.id AS id_71, t70.slug AS slug_72, t70.name AS name_73, t70.zipcode AS zipcode_74, t70.city AS city_75, t70.country AS country_76, t70.contact_person AS contact_person_77, t70.contact_person_gender AS contact_person_gender_78, t70.contact_person_first_name AS contact_person_first_name_79, t70.contact_person_initials AS contact_person_initials_80, t70.contact_person_prefix AS contact_person_prefix_81, t70.contact_person_last_name AS contact_person_last_name_82, t70.phone AS phone_83, t70.extension AS extension_84, t70.mobile AS mobile_85, t70.website AS website_86, t70.email AS email_87, t70.updated_at AS updated_at_88, t70.applicant_email AS applicant_email_89, t70.description AS description_90, t70.external_id AS external_id_91, t70.canonical_url AS canonical_url_92, t70.deleted AS deleted_93, t70.openinghours AS openinghours_94, t70.accessibility AS accessibility_95, t70.credits AS credits_96, t70.video AS video_97, t70.action_date AS action_date_98, t70.action_type AS action_type_99, t70.friendly_url AS friendly_url_100, t70.province AS province_101, t70.company_information AS company_information_102, t70.multi_poster_id AS multi_poster_id_103, t70.google_cloud_name AS google_cloud_name_104, t70.featured AS featured_105, t70.department AS department_106, t70.po_number AS po_number_107, t70.invoice_company_name AS invoice_company_name_108, t70.invoice_department AS invoice_department_109, t70.invoice_contact_person AS invoice_contact_person_110, t70.invoice_email_address AS invoice_email_address_111, t70.invoice_address AS invoice_address_112, t70.invoice_zipcode AS invoice_zipcode_113, t70.invoice_city AS invoice_city_114, t70.invoice_phone AS invoice_phone_115, t70.detail_page AS detail_page_116, t70.detail_page_expiration_date AS detail_page_expiration_date_117, t70.address AS address_118, t70.latitude AS latitude_119, t70.longitude AS longitude_120, t70.meta_title AS meta_title_121, t70.meta_description AS meta_description_122, t70.utm_medium AS utm_medium_123, t70.utm_campaign AS utm_campaign_124, t70.logo_asset_id AS logo_asset_id_125, t70.hero_asset_id AS hero_asset_id_126, t70.overview_image_asset_id AS overview_image_asset_id_127, t70.fields_form_id AS fields_form_id_128, t70.hero_configuration_id AS hero_configuration_id_129, t70.company_status_id AS company_status_id_130, t70.action_assignee_id AS action_assignee_id_131, t70.consultant_id AS consultant_id_132, t70.application_process_id AS application_process_id_133, t70.gallery_id AS gallery_id_134, t70.site_id AS site_id_135, t0.recruiter_id AS recruiter_id_136, t137.first_name AS first_name_138, t137.last_name_prefix AS last_name_prefix_139, t137.last_name AS last_name_140, t137.email AS email_141, t137.phone AS phone_142, t137.linkedin_url AS linkedin_url_143, t137.intro AS intro_144, t137.description AS description_145, t137.picture_name AS picture_name_146, t137.country AS country_147, t137.id AS id_148, t137.created_at AS created_at_149, t137.updated_at AS updated_at_150, t137.robots AS robots_151, t137.external_id AS external_id_152, t137.external_reference AS external_reference_153, t137.external_hash AS external_hash_154, t0.main_icon_id AS main_icon_id_155, t0.usp_sub_title_id AS usp_sub_title_id_156, t0.description_form_id AS description_form_id_157, t0.applicant_form_id AS applicant_form_id_158, t0.custom_applicant_form_id AS custom_applicant_form_id_159, t0.invoice_id AS invoice_id_160, t0.template_id AS template_id_161, t0.company_logo_asset_id AS company_logo_asset_id_162, t163.id AS id_164, t163.file_name AS file_name_165, t163.file_size AS file_size_166, t163.file_mime_type AS file_mime_type_167, t163.meta_information AS meta_information_168, t163.updated_at AS updated_at_169, t163.external_id AS external_id_170, t163.folder_id AS folder_id_171, t0.multi_poster_id AS multi_poster_id_172, t0.primary_discipline_id AS primary_discipline_id_173, t0.secundary_discipline_id AS secundary_discipline_id_174, t0.harver_experience_id AS harver_experience_id_175, t0.application_process_id AS application_process_id_176, t0.domain_id AS domain_id_177, t0.calendar_id AS calendar_id_178, t0.gallery_id AS gallery_id_179, t180.id AS id_181, t180.name AS name_182, t180.title AS title_183, t180.intro AS intro_184, t180.context AS context_185, t180.format AS format_186, t180.enabled AS enabled_187, t180.video_embed_id AS video_embed_id_188, t0.og_image_id AS og_image_id_189, t190.id AS id_191, t190.field AS field_192, t190.text_size AS text_size_193, t190.text_color AS text_color_194, t190.text_position AS text_position_195, t190.image_id AS image_id_196, t0.site_id AS site_id_197 FROM vacancy t0 LEFT JOIN asset t59 ON t0.overview_image_asset_id = t59.id LEFT JOIN company t70 ON t0.company_id = t70.id LEFT JOIN recruiter t137 ON t0.recruiter_id = t137.id LEFT JOIN asset t163 ON t0.company_logo_asset_id = t163.id LEFT JOIN gallery t180 ON t0.gallery_id = t180.id LEFT JOIN og_image t190 ON t0.og_image_id = t190.id WHERE t0.id = '351';
16.23 ms (7.68%)	1	SELECT t0.id AS id_1, t0.value AS value_2, t0.title AS title_3, t0.sub_title AS sub_title_4, t0.slug AS slug_5, t0.position AS position_6, t0.font_awesome_icon AS font_awesome_icon_7, t0.youtube_video_url AS youtube_video_url_8, t0.content AS content_9, t0.content_truncate_at AS content_truncate_at_10, t0.external_reference AS external_reference_11, t0.visibility_days AS visibility_days_12, t0.click_target AS click_target_13, t0.detail_page AS detail_page_14, t0.matchable_values AS matchable_values_15, t0.meta_title AS meta_title_16, t0.meta_description AS meta_description_17, t0.external_id AS external_id_18, t0.external_hash AS external_hash_19, t0.layout_file AS layout_file_20, t0.option_id AS option_id_21, t22.id AS id_23, t22.title AS title_24, t22.slug AS slug_25, t22.font_awesome_icon AS font_awesome_icon_26, t22.expanded_by_default AS expanded_by_default_27, t22.strategy_on_overview AS strategy_on_overview_28, t22.visible_in_detail AS visible_in_detail_29, t22.group_text AS group_text_30, t22.group_at_count AS group_at_count_31, t22.internal_name AS internal_name_32, t22.sort_option_images AS sort_option_images_33, t22.strategy_on_job_profile_overview AS strategy_on_job_profile_overview_34, t22.display_type AS display_type_35, t22.expanded_strategy AS expanded_strategy_36, t22.contextual_title AS contextual_title_37, t22.external_id AS external_id_38, t22.external_reference AS external_reference_39, t22.external_hash AS external_hash_40, t22.position AS position_41, t22.job_alert_setting_id AS job_alert_setting_id_42, t0.youtube_video_fallback_image_asset_id AS youtube_video_fallback_image_asset_id_43, t44.id AS id_45, t44.file_name AS file_name_46, t44.file_size AS file_size_47, t44.file_mime_type AS file_mime_type_48, t44.meta_information AS meta_information_49, t44.updated_at AS updated_at_50, t44.external_id AS external_id_51, t44.folder_id AS folder_id_52, t0.event_category_id AS event_category_id_53, t0.parent_id AS parent_id_54, t0.application_process_id AS application_process_id_55, t0.applicant_form_id AS applicant_form_id_56, t0.recruiter_id AS recruiter_id_57, t0.calendar_id AS calendar_id_58, t0.gallery_id AS gallery_id_59, t60.id AS id_61, t60.name AS name_62, t60.title AS title_63, t60.intro AS intro_64, t60.context AS context_65, t60.format AS format_66, t60.enabled AS enabled_67, t60.video_embed_id AS video_embed_id_68, t0.site_id AS site_id_69 FROM vacancy_option_value t0 LEFT JOIN vacancy_option t22 ON t0.option_id = t22.id LEFT JOIN asset t44 ON t0.youtube_video_fallback_image_asset_id = t44.id LEFT JOIN gallery t60 ON t0.gallery_id = t60.id INNER JOIN vacancy_option_value_option ON t0.id = vacancy_option_value_option.option_value_id WHERE vacancy_option_value_option.vacancy_id = ? ORDER BY t0.position ASC Parameters: [`351`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.value AS value_2, t0.title AS title_3, t0.sub_title AS sub_title_4, t0.slug AS slug_5, t0.position AS position_6, t0.font_awesome_icon AS font_awesome_icon_7, t0.youtube_video_url AS youtube_video_url_8, t0.content AS content_9, t0.content_truncate_at AS content_truncate_at_10, t0.external_reference AS external_reference_11, t0.visibility_days AS visibility_days_12, t0.click_target AS click_target_13, t0.detail_page AS detail_page_14, t0.matchable_values AS matchable_values_15, t0.meta_title AS meta_title_16, t0.meta_description AS meta_description_17, t0.external_id AS external_id_18, t0.external_hash AS external_hash_19, t0.layout_file AS layout_file_20, t0.option_id AS option_id_21, t22.id AS id_23, t22.title AS title_24, t22.slug AS slug_25, t22.font_awesome_icon AS font_awesome_icon_26, t22.expanded_by_default AS expanded_by_default_27, t22.strategy_on_overview AS strategy_on_overview_28, t22.visible_in_detail AS visible_in_detail_29, t22.group_text AS group_text_30, t22.group_at_count AS group_at_count_31, t22.internal_name AS internal_name_32, t22.sort_option_images AS sort_option_images_33, t22.strategy_on_job_profile_overview AS strategy_on_job_profile_overview_34, t22.display_type AS display_type_35, t22.expanded_strategy AS expanded_strategy_36, t22.contextual_title AS contextual_title_37, t22.external_id AS external_id_38, t22.external_reference AS external_reference_39, t22.external_hash AS external_hash_40, t22.position AS position_41, t22.job_alert_setting_id AS job_alert_setting_id_42, t0.youtube_video_fallback_image_asset_id AS youtube_video_fallback_image_asset_id_43, t44.id AS id_45, t44.file_name AS file_name_46, t44.file_size AS file_size_47, t44.file_mime_type AS file_mime_type_48, t44.meta_information AS meta_information_49, t44.updated_at AS updated_at_50, t44.external_id AS external_id_51, t44.folder_id AS folder_id_52, t0.event_category_id AS event_category_id_53, t0.parent_id AS parent_id_54, t0.application_process_id AS application_process_id_55, t0.applicant_form_id AS applicant_form_id_56, t0.recruiter_id AS recruiter_id_57, t0.calendar_id AS calendar_id_58, t0.gallery_id AS gallery_id_59, t60.id AS id_61, t60.name AS name_62, t60.title AS title_63, t60.intro AS intro_64, t60.context AS context_65, t60.format AS format_66, t60.enabled AS enabled_67, t60.video_embed_id AS video_embed_id_68, t0.site_id AS site_id_69 FROM vacancy_option_value t0 LEFT JOIN vacancy_option t22 ON t0.option_id = t22.id LEFT JOIN asset t44 ON t0.youtube_video_fallback_image_asset_id = t44.id LEFT JOIN gallery t60 ON t0.gallery_id = t60.id INNER JOIN vacancy_option_value_option ON t0.id = vacancy_option_value_option.option_value_id WHERE vacancy_option_value_option.vacancy_id = ? ORDER BY t0.position ASC SELECT t0.id AS id_1, t0.value AS value_2, t0.title AS title_3, t0.sub_title AS sub_title_4, t0.slug AS slug_5, t0.position AS position_6, t0.font_awesome_icon AS font_awesome_icon_7, t0.youtube_video_url AS youtube_video_url_8, t0.content AS content_9, t0.content_truncate_at AS content_truncate_at_10, t0.external_reference AS external_reference_11, t0.visibility_days AS visibility_days_12, t0.click_target AS click_target_13, t0.detail_page AS detail_page_14, t0.matchable_values AS matchable_values_15, t0.meta_title AS meta_title_16, t0.meta_description AS meta_description_17, t0.external_id AS external_id_18, t0.external_hash AS external_hash_19, t0.layout_file AS layout_file_20, t0.option_id AS option_id_21, t22.id AS id_23, t22.title AS title_24, t22.slug AS slug_25, t22.font_awesome_icon AS font_awesome_icon_26, t22.expanded_by_default AS expanded_by_default_27, t22.strategy_on_overview AS strategy_on_overview_28, t22.visible_in_detail AS visible_in_detail_29, t22.group_text AS group_text_30, t22.group_at_count AS group_at_count_31, t22.internal_name AS internal_name_32, t22.sort_option_images AS sort_option_images_33, t22.strategy_on_job_profile_overview AS strategy_on_job_profile_overview_34, t22.display_type AS display_type_35, t22.expanded_strategy AS expanded_strategy_36, t22.contextual_title AS contextual_title_37, t22.external_id AS external_id_38, t22.external_reference AS external_reference_39, t22.external_hash AS external_hash_40, t22.position AS position_41, t22.job_alert_setting_id AS job_alert_setting_id_42, t0.youtube_video_fallback_image_asset_id AS youtube_video_fallback_image_asset_id_43, t44.id AS id_45, t44.file_name AS file_name_46, t44.file_size AS file_size_47, t44.file_mime_type AS file_mime_type_48, t44.meta_information AS meta_information_49, t44.updated_at AS updated_at_50, t44.external_id AS external_id_51, t44.folder_id AS folder_id_52, t0.event_category_id AS event_category_id_53, t0.parent_id AS parent_id_54, t0.application_process_id AS application_process_id_55, t0.applicant_form_id AS applicant_form_id_56, t0.recruiter_id AS recruiter_id_57, t0.calendar_id AS calendar_id_58, t0.gallery_id AS gallery_id_59, t60.id AS id_61, t60.name AS name_62, t60.title AS title_63, t60.intro AS intro_64, t60.context AS context_65, t60.format AS format_66, t60.enabled AS enabled_67, t60.video_embed_id AS video_embed_id_68, t0.site_id AS site_id_69 FROM vacancy_option_value t0 LEFT JOIN vacancy_option t22 ON t0.option_id = t22.id LEFT JOIN asset t44 ON t0.youtube_video_fallback_image_asset_id = t44.id LEFT JOIN gallery t60 ON t0.gallery_id = t60.id INNER JOIN vacancy_option_value_option ON t0.id = vacancy_option_value_option.option_value_id WHERE vacancy_option_value_option.vacancy_id = 351 ORDER BY t0.position ASC;
15.18 ms (7.18%)	15	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_related_vacancy_options"`] View formatted query View runnable query Explain query 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 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 = 'site_vacancy_related_vacancy_options' LIMIT 1;
9.84 ms (4.65%)	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"`] View formatted query View runnable query Explain query 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 = ? 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 = '1';
8.91 ms (4.21%)	1	SELECT t0.id AS id_1, t0.value AS value_2, t0.appearance AS appearance_3 FROM tag t0 INNER JOIN page_tag ON t0.id = page_tag.tag_id WHERE page_tag.page_id = ? Parameters: [`38`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.value AS value_2, t0.appearance AS appearance_3 FROM tag t0 INNER JOIN page_tag ON t0.id = page_tag.tag_id WHERE page_tag.page_id = ? SELECT t0.id AS id_1, t0.value AS value_2, t0.appearance AS appearance_3 FROM tag t0 INNER JOIN page_tag ON t0.id = page_tag.tag_id WHERE page_tag.page_id = 38;
8.18 ms (3.87%)	1	SELECT t0.id AS id_1, t0.url AS url_2, t0.site_id AS site_id_3, t4.id AS id_5, t4.name AS name_6, t4.country AS country_7, t4.default_locale AS default_locale_8, t4.locales AS locales_9, t4.mapping_values AS mapping_values_10, t4.parent AS parent_11, t4.all_vacancies AS all_vacancies_12, t4.address AS address_13, t4.latitude AS latitude_14, t4.longitude AS longitude_15 FROM site_domain t0 LEFT JOIN site t4 ON t0.site_id = t4.id WHERE t0.url = ? LIMIT 1 Parameters: [`"mbobanen.staging.03.getnoticed.nl"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.url AS url_2, t0.site_id AS site_id_3, t4.id AS id_5, t4.name AS name_6, t4.country AS country_7, t4.default_locale AS default_locale_8, t4.locales AS locales_9, t4.mapping_values AS mapping_values_10, t4.parent AS parent_11, t4.all_vacancies AS all_vacancies_12, t4.address AS address_13, t4.latitude AS latitude_14, t4.longitude AS longitude_15 FROM site_domain t0 LEFT JOIN site t4 ON t0.site_id = t4.id WHERE t0.url = ? LIMIT 1 SELECT t0.id AS id_1, t0.url AS url_2, t0.site_id AS site_id_3, t4.id AS id_5, t4.name AS name_6, t4.country AS country_7, t4.default_locale AS default_locale_8, t4.locales AS locales_9, t4.mapping_values AS mapping_values_10, t4.parent AS parent_11, t4.all_vacancies AS all_vacancies_12, t4.address AS address_13, t4.latitude AS latitude_14, t4.longitude AS longitude_15 FROM site_domain t0 LEFT JOIN site t4 ON t0.site_id = t4.id WHERE t0.url = 'mbobanen.staging.03.getnoticed.nl' LIMIT 1;
8.08 ms (3.82%)	1	SELECT e0_.id AS id_0, e0_.updated AS updated_1, e0_.date_from AS date_from_2, e0_.date_to AS date_to_3, e0_.deleted AS deleted_4, e0_.title AS title_5, e0_.status AS status_6, e0_.slug AS slug_7, e0_.close_registrations_at AS close_registrations_at_8, e0_.available_registration_spots AS available_registration_spots_9, e0_.body AS body_10, e0_.intro AS intro_11, e0_.requires_registrations AS requires_registrations_12, e0_.external_registration_url AS external_registration_url_13, e0_.external_url_strategy AS external_url_strategy_14, e0_.external_id AS external_id_15, e0_.external_reference AS external_reference_16, e0_.external_hash AS external_hash_17, e0_.meta_title AS meta_title_18, e0_.meta_description AS meta_description_19, e0_.location_id AS location_id_20, e0_.owner_id AS owner_id_21, e0_.image_id AS image_id_22, e0_.mail_id AS mail_id_23, e0_.og_image_id AS og_image_id_24, e0_.video_embed_id AS video_embed_id_25 FROM event e0_ WHERE (e0_.date_from > ? AND e0_.status = ?) AND (e0_.deleted IS NULL) ORDER BY e0_.date_from ASC LIMIT 1 Parameters: [`"2024-11-10 02:26:04" "live"`] View formatted query View runnable query Explain query SELECT e0_.id AS id_0, e0_.updated AS updated_1, e0_.date_from AS date_from_2, e0_.date_to AS date_to_3, e0_.deleted AS deleted_4, e0_.title AS title_5, e0_.status AS status_6, e0_.slug AS slug_7, e0_.close_registrations_at AS close_registrations_at_8, e0_.available_registration_spots AS available_registration_spots_9, e0_.body AS body_10, e0_.intro AS intro_11, e0_.requires_registrations AS requires_registrations_12, e0_.external_registration_url AS external_registration_url_13, e0_.external_url_strategy AS external_url_strategy_14, e0_.external_id AS external_id_15, e0_.external_reference AS external_reference_16, e0_.external_hash AS external_hash_17, e0_.meta_title AS meta_title_18, e0_.meta_description AS meta_description_19, e0_.location_id AS location_id_20, e0_.owner_id AS owner_id_21, e0_.image_id AS image_id_22, e0_.mail_id AS mail_id_23, e0_.og_image_id AS og_image_id_24, e0_.video_embed_id AS video_embed_id_25 FROM event e0_ WHERE ( e0_.date_from > ? AND e0_.status = ? ) AND (e0_.deleted IS NULL) ORDER BY e0_.date_from ASC LIMIT 1 SELECT e0_.id AS id_0, e0_.updated AS updated_1, e0_.date_from AS date_from_2, e0_.date_to AS date_to_3, e0_.deleted AS deleted_4, e0_.title AS title_5, e0_.status AS status_6, e0_.slug AS slug_7, e0_.close_registrations_at AS close_registrations_at_8, e0_.available_registration_spots AS available_registration_spots_9, e0_.body AS body_10, e0_.intro AS intro_11, e0_.requires_registrations AS requires_registrations_12, e0_.external_registration_url AS external_registration_url_13, e0_.external_url_strategy AS external_url_strategy_14, e0_.external_id AS external_id_15, e0_.external_reference AS external_reference_16, e0_.external_hash AS external_hash_17, e0_.meta_title AS meta_title_18, e0_.meta_description AS meta_description_19, e0_.location_id AS location_id_20, e0_.owner_id AS owner_id_21, e0_.image_id AS image_id_22, e0_.mail_id AS mail_id_23, e0_.og_image_id AS og_image_id_24, e0_.video_embed_id AS video_embed_id_25 FROM event e0_ WHERE (e0_.date_from > '2024-11-10 02:26:04' AND e0_.status = 'live') AND (e0_.deleted IS NULL) ORDER BY e0_.date_from ASC LIMIT 1;
7.95 ms (3.76%)	1	SELECT t0.avatar_file_name AS avatar_file_name_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.city AS city_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.phone AS phone_7, t0.file_name AS file_name_8, t0.file_size AS file_size_9, t0.motivation AS motivation_10, t0.user_search_words AS user_search_words_11, t0.manager_search_words AS manager_search_words_12, t0.linked_in AS linked_in_13, t0.company_match_token AS company_match_token_14, t0.approach_strategy AS approach_strategy_15, t0.id AS id_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.user_id AS user_id_19 FROM pages_user_site_user_data t0 WHERE t0.user_id IS NULL LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT t0.avatar_file_name AS avatar_file_name_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.city AS city_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.phone AS phone_7, t0.file_name AS file_name_8, t0.file_size AS file_size_9, t0.motivation AS motivation_10, t0.user_search_words AS user_search_words_11, t0.manager_search_words AS manager_search_words_12, t0.linked_in AS linked_in_13, t0.company_match_token AS company_match_token_14, t0.approach_strategy AS approach_strategy_15, t0.id AS id_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.user_id AS user_id_19 FROM pages_user_site_user_data t0 WHERE t0.user_id IS NULL LIMIT 1 SELECT t0.avatar_file_name AS avatar_file_name_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.city AS city_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.phone AS phone_7, t0.file_name AS file_name_8, t0.file_size AS file_size_9, t0.motivation AS motivation_10, t0.user_search_words AS user_search_words_11, t0.manager_search_words AS manager_search_words_12, t0.linked_in AS linked_in_13, t0.company_match_token AS company_match_token_14, t0.approach_strategy AS approach_strategy_15, t0.id AS id_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.user_id AS user_id_19 FROM pages_user_site_user_data t0 WHERE t0.user_id IS NULL LIMIT 1;
7.02 ms (3.32%)	1	SELECT t0.id AS id_1, t0.external_reference AS external_reference_2, t0.value AS value_3, t0.type AS type_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.vacancy_id AS vacancy_id_7, t8.id AS id_9, t8.active AS active_10, t8.created AS created_11, t8.updated AS updated_12, t8.sort_date AS sort_date_13, t8.contact_person AS contact_person_14, t8.contact_person_phone AS contact_person_phone_15, t8.slug AS slug_16, t8.title AS title_17, t8.company_name AS company_name_18, t8.city AS city_19, t8.zipcode AS zipcode_20, t8.external_url AS external_url_21, t8.intro AS intro_22, t8.description AS description_23, t8.featured AS featured_24, t8.internal_vacancy AS internal_vacancy_25, t8.start_date AS start_date_26, t8.end_date AS end_date_27, t8.job_start_date AS job_start_date_28, t8.applicant_form_custom AS applicant_form_custom_29, t8.applicant_email AS applicant_email_30, t8.deleted AS deleted_31, t8.external_reference AS external_reference_32, t8.synced AS synced_33, t8.youtube AS youtube_34, t8.external_id AS external_id_35, t8.displayable_external_id AS displayable_external_id_36, t8.master_vacancy AS master_vacancy_37, t8.country AS country_38, t8.salary_amount AS salary_amount_39, t8.salary_currency AS salary_currency_40, t8.min_salary_amount AS min_salary_amount_41, t8.min_salary_currency AS min_salary_currency_42, t8.max_salary_amount AS max_salary_amount_43, t8.max_salary_currency AS max_salary_currency_44, t8.custom_salary AS custom_salary_45, t8.redirect_count AS redirect_count_46, t8.province AS province_47, t8.company_information AS company_information_48, t8.has_more_info_button AS has_more_info_button_49, t8.owner_notified AS owner_notified_50, t8.`function` AS function_51, t8.external_detail_url AS external_detail_url_52, t8.google_for_job_mapping AS google_for_job_mapping_53, t8.salary_unit AS salary_unit_54, t8.department AS department_55, t8.google_cloud_name AS google_cloud_name_56, t8.address AS address_57, t8.latitude AS latitude_58, t8.longitude AS longitude_59, t8.external_hash AS external_hash_60, t8.meta_title AS meta_title_61, t8.meta_description AS meta_description_62, t8.utm_medium AS utm_medium_63, t8.utm_campaign AS utm_campaign_64, t8.detail_image_asset_id AS detail_image_asset_id_65, t8.overview_image_asset_id AS overview_image_asset_id_66, t8.hero_image_asset_id AS hero_image_asset_id_67, t8.company_id AS company_id_68, t8.recruiter_id AS recruiter_id_69, t8.main_icon_id AS main_icon_id_70, t8.usp_sub_title_id AS usp_sub_title_id_71, t8.description_form_id AS description_form_id_72, t8.applicant_form_id AS applicant_form_id_73, t8.custom_applicant_form_id AS custom_applicant_form_id_74, t8.invoice_id AS invoice_id_75, t8.template_id AS template_id_76, t8.company_logo_asset_id AS company_logo_asset_id_77, t8.multi_poster_id AS multi_poster_id_78, t8.primary_discipline_id AS primary_discipline_id_79, t8.secundary_discipline_id AS secundary_discipline_id_80, t8.harver_experience_id AS harver_experience_id_81, t8.application_process_id AS application_process_id_82, t8.domain_id AS domain_id_83, t8.calendar_id AS calendar_id_84, t8.gallery_id AS gallery_id_85, t8.og_image_id AS og_image_id_86, t8.site_id AS site_id_87 FROM vacancy_question t0 LEFT JOIN vacancy t8 ON t0.vacancy_id = t8.id AND ((t8.deleted IS NULL)) WHERE t0.vacancy_id = ? Parameters: [`351`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.external_reference AS external_reference_2, t0.value AS value_3, t0.type AS type_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.vacancy_id AS vacancy_id_7, t8.id AS id_9, t8.active AS active_10, t8.created AS created_11, t8.updated AS updated_12, t8.sort_date AS sort_date_13, t8.contact_person AS contact_person_14, t8.contact_person_phone AS contact_person_phone_15, t8.slug AS slug_16, t8.title AS title_17, t8.company_name AS company_name_18, t8.city AS city_19, t8.zipcode AS zipcode_20, t8.external_url AS external_url_21, t8.intro AS intro_22, t8.description AS description_23, t8.featured AS featured_24, t8.internal_vacancy AS internal_vacancy_25, t8.start_date AS start_date_26, t8.end_date AS end_date_27, t8.job_start_date AS job_start_date_28, t8.applicant_form_custom AS applicant_form_custom_29, t8.applicant_email AS applicant_email_30, t8.deleted AS deleted_31, t8.external_reference AS external_reference_32, t8.synced AS synced_33, t8.youtube AS youtube_34, t8.external_id AS external_id_35, t8.displayable_external_id AS displayable_external_id_36, t8.master_vacancy AS master_vacancy_37, t8.country AS country_38, t8.salary_amount AS salary_amount_39, t8.salary_currency AS salary_currency_40, t8.min_salary_amount AS min_salary_amount_41, t8.min_salary_currency AS min_salary_currency_42, t8.max_salary_amount AS max_salary_amount_43, t8.max_salary_currency AS max_salary_currency_44, t8.custom_salary AS custom_salary_45, t8.redirect_count AS redirect_count_46, t8.province AS province_47, t8.company_information AS company_information_48, t8.has_more_info_button AS has_more_info_button_49, t8.owner_notified AS owner_notified_50, t8.`function` AS function_51, t8.external_detail_url AS external_detail_url_52, t8.google_for_job_mapping AS google_for_job_mapping_53, t8.salary_unit AS salary_unit_54, t8.department AS department_55, t8.google_cloud_name AS google_cloud_name_56, t8.address AS address_57, t8.latitude AS latitude_58, t8.longitude AS longitude_59, t8.external_hash AS external_hash_60, t8.meta_title AS meta_title_61, t8.meta_description AS meta_description_62, t8.utm_medium AS utm_medium_63, t8.utm_campaign AS utm_campaign_64, t8.detail_image_asset_id AS detail_image_asset_id_65, t8.overview_image_asset_id AS overview_image_asset_id_66, t8.hero_image_asset_id AS hero_image_asset_id_67, t8.company_id AS company_id_68, t8.recruiter_id AS recruiter_id_69, t8.main_icon_id AS main_icon_id_70, t8.usp_sub_title_id AS usp_sub_title_id_71, t8.description_form_id AS description_form_id_72, t8.applicant_form_id AS applicant_form_id_73, t8.custom_applicant_form_id AS custom_applicant_form_id_74, t8.invoice_id AS invoice_id_75, t8.template_id AS template_id_76, t8.company_logo_asset_id AS company_logo_asset_id_77, t8.multi_poster_id AS multi_poster_id_78, t8.primary_discipline_id AS primary_discipline_id_79, t8.secundary_discipline_id AS secundary_discipline_id_80, t8.harver_experience_id AS harver_experience_id_81, t8.application_process_id AS application_process_id_82, t8.domain_id AS domain_id_83, t8.calendar_id AS calendar_id_84, t8.gallery_id AS gallery_id_85, t8.og_image_id AS og_image_id_86, t8.site_id AS site_id_87 FROM vacancy_question t0 LEFT JOIN vacancy t8 ON t0.vacancy_id = t8.id AND ( (t8.deleted IS NULL) ) WHERE t0.vacancy_id = ? SELECT t0.id AS id_1, t0.external_reference AS external_reference_2, t0.value AS value_3, t0.type AS type_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.vacancy_id AS vacancy_id_7, t8.id AS id_9, t8.active AS active_10, t8.created AS created_11, t8.updated AS updated_12, t8.sort_date AS sort_date_13, t8.contact_person AS contact_person_14, t8.contact_person_phone AS contact_person_phone_15, t8.slug AS slug_16, t8.title AS title_17, t8.company_name AS company_name_18, t8.city AS city_19, t8.zipcode AS zipcode_20, t8.external_url AS external_url_21, t8.intro AS intro_22, t8.description AS description_23, t8.featured AS featured_24, t8.internal_vacancy AS internal_vacancy_25, t8.start_date AS start_date_26, t8.end_date AS end_date_27, t8.job_start_date AS job_start_date_28, t8.applicant_form_custom AS applicant_form_custom_29, t8.applicant_email AS applicant_email_30, t8.deleted AS deleted_31, t8.external_reference AS external_reference_32, t8.synced AS synced_33, t8.youtube AS youtube_34, t8.external_id AS external_id_35, t8.displayable_external_id AS displayable_external_id_36, t8.master_vacancy AS master_vacancy_37, t8.country AS country_38, t8.salary_amount AS salary_amount_39, t8.salary_currency AS salary_currency_40, t8.min_salary_amount AS min_salary_amount_41, t8.min_salary_currency AS min_salary_currency_42, t8.max_salary_amount AS max_salary_amount_43, t8.max_salary_currency AS max_salary_currency_44, t8.custom_salary AS custom_salary_45, t8.redirect_count AS redirect_count_46, t8.province AS province_47, t8.company_information AS company_information_48, t8.has_more_info_button AS has_more_info_button_49, t8.owner_notified AS owner_notified_50, t8.`function` AS function_51, t8.external_detail_url AS external_detail_url_52, t8.google_for_job_mapping AS google_for_job_mapping_53, t8.salary_unit AS salary_unit_54, t8.department AS department_55, t8.google_cloud_name AS google_cloud_name_56, t8.address AS address_57, t8.latitude AS latitude_58, t8.longitude AS longitude_59, t8.external_hash AS external_hash_60, t8.meta_title AS meta_title_61, t8.meta_description AS meta_description_62, t8.utm_medium AS utm_medium_63, t8.utm_campaign AS utm_campaign_64, t8.detail_image_asset_id AS detail_image_asset_id_65, t8.overview_image_asset_id AS overview_image_asset_id_66, t8.hero_image_asset_id AS hero_image_asset_id_67, t8.company_id AS company_id_68, t8.recruiter_id AS recruiter_id_69, t8.main_icon_id AS main_icon_id_70, t8.usp_sub_title_id AS usp_sub_title_id_71, t8.description_form_id AS description_form_id_72, t8.applicant_form_id AS applicant_form_id_73, t8.custom_applicant_form_id AS custom_applicant_form_id_74, t8.invoice_id AS invoice_id_75, t8.template_id AS template_id_76, t8.company_logo_asset_id AS company_logo_asset_id_77, t8.multi_poster_id AS multi_poster_id_78, t8.primary_discipline_id AS primary_discipline_id_79, t8.secundary_discipline_id AS secundary_discipline_id_80, t8.harver_experience_id AS harver_experience_id_81, t8.application_process_id AS application_process_id_82, t8.domain_id AS domain_id_83, t8.calendar_id AS calendar_id_84, t8.gallery_id AS gallery_id_85, t8.og_image_id AS og_image_id_86, t8.site_id AS site_id_87 FROM vacancy_question t0 LEFT JOIN vacancy t8 ON t0.vacancy_id = t8.id AND ((t8.deleted IS NULL)) WHERE t0.vacancy_id = 351;
6.65 ms (3.14%)	2	SELECT t0.id AS id_1, t0.`name` AS name_2, t0.defaults AS defaults_3, t0.staticPrefix AS staticPrefix_4, t0.variable_pattern AS variable_pattern_5, t0.requirements AS requirements_6, t0.options AS options_7, t0.host AS host_8, t0.schemes AS schemes_9, t0.`methods` AS methods_10, t0.`condition` AS condition_11, t0.locale AS locale_12, t0.page_id AS page_id_13 FROM route t0 WHERE t0.`name` = ? LIMIT 1 Parameters: [`"vacancy_detail_without_slug"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.`name` AS name_2, t0.defaults AS defaults_3, t0.staticPrefix AS staticPrefix_4, t0.variable_pattern AS variable_pattern_5, t0.requirements AS requirements_6, t0.options AS options_7, t0.host AS host_8, t0.schemes AS schemes_9, t0.`methods` AS methods_10, t0.`condition` AS condition_11, t0.locale AS locale_12, t0.page_id AS page_id_13 FROM route t0 WHERE t0.`name` = ? LIMIT 1 SELECT t0.id AS id_1, t0.`name` AS name_2, t0.defaults AS defaults_3, t0.staticPrefix AS staticPrefix_4, t0.variable_pattern AS variable_pattern_5, t0.requirements AS requirements_6, t0.options AS options_7, t0.host AS host_8, t0.schemes AS schemes_9, t0.`methods` AS methods_10, t0.`condition` AS condition_11, t0.locale AS locale_12, t0.page_id AS page_id_13 FROM route t0 WHERE t0.`name` = 'vacancy_detail_without_slug' LIMIT 1;
6.52 ms (3.08%)	4	SELECT t0.deleted_at AS deleted_at_1, t0.type AS type_2, t0.title AS title_3, t0.fixed_header_title AS fixed_header_title_4, t0.body AS body_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.symlink_variable_pattern AS symlink_variable_pattern_9, t0.show_in_menu AS show_in_menu_10, t0.alias AS alias_11, t0.deletable AS deletable_12, t0.class AS class_13, t0.body_class AS body_class_14, t0.breadcrumbs AS breadcrumbs_15, t0.controller AS controller_16, t0.feature AS feature_17, t0.icon_class AS icon_class_18, t0.hide_title AS hide_title_19, t0.concept AS concept_20, t0.target AS target_21, t0.mega_menu AS mega_menu_22, t0.mega_menu_title AS mega_menu_title_23, t0.mega_menu_intro AS mega_menu_intro_24, t0.mega_menu_outro AS mega_menu_outro_25, t0.id AS id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.robots AS robots_29, t0.meta_title AS meta_title_30, t0.meta_description AS meta_description_31, t0.parent_id AS parent_id_32, t33.id AS id_34, t33.`name` AS name_35, t33.defaults AS defaults_36, t33.staticPrefix AS staticPrefix_37, t33.variable_pattern AS variable_pattern_38, t33.requirements AS requirements_39, t33.options AS options_40, t33.host AS host_41, t33.schemes AS schemes_42, t33.`methods` AS methods_43, t33.`condition` AS condition_44, t33.locale AS locale_45, t33.page_id AS page_id_46, t0.symlink_id AS symlink_id_47, t0.mega_menu_item_id AS mega_menu_item_id_48, t0.hero_configuration_id AS hero_configuration_id_49, t0.connexys_page_configuration_id AS connexys_page_configuration_id_50, t0.og_image_id AS og_image_id_51, t52.id AS id_53, t52.field AS field_54, t52.text_size AS text_size_55, t52.text_color AS text_color_56, t52.text_position AS text_position_57, t52.image_id AS image_id_58 FROM page t0 LEFT JOIN route t33 ON t33.page_id = t0.id LEFT JOIN og_image t52 ON t0.og_image_id = t52.id WHERE t0.id = ? AND ((t0.deleted_at IS NULL)) Parameters: [`38`] View formatted query View runnable query Explain query SELECT t0.deleted_at AS deleted_at_1, t0.type AS type_2, t0.title AS title_3, t0.fixed_header_title AS fixed_header_title_4, t0.body AS body_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.symlink_variable_pattern AS symlink_variable_pattern_9, t0.show_in_menu AS show_in_menu_10, t0.alias AS alias_11, t0.deletable AS deletable_12, t0.class AS class_13, t0.body_class AS body_class_14, t0.breadcrumbs AS breadcrumbs_15, t0.controller AS controller_16, t0.feature AS feature_17, t0.icon_class AS icon_class_18, t0.hide_title AS hide_title_19, t0.concept AS concept_20, t0.target AS target_21, t0.mega_menu AS mega_menu_22, t0.mega_menu_title AS mega_menu_title_23, t0.mega_menu_intro AS mega_menu_intro_24, t0.mega_menu_outro AS mega_menu_outro_25, t0.id AS id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.robots AS robots_29, t0.meta_title AS meta_title_30, t0.meta_description AS meta_description_31, t0.parent_id AS parent_id_32, t33.id AS id_34, t33.`name` AS name_35, t33.defaults AS defaults_36, t33.staticPrefix AS staticPrefix_37, t33.variable_pattern AS variable_pattern_38, t33.requirements AS requirements_39, t33.options AS options_40, t33.host AS host_41, t33.schemes AS schemes_42, t33.`methods` AS methods_43, t33.`condition` AS condition_44, t33.locale AS locale_45, t33.page_id AS page_id_46, t0.symlink_id AS symlink_id_47, t0.mega_menu_item_id AS mega_menu_item_id_48, t0.hero_configuration_id AS hero_configuration_id_49, t0.connexys_page_configuration_id AS connexys_page_configuration_id_50, t0.og_image_id AS og_image_id_51, t52.id AS id_53, t52.field AS field_54, t52.text_size AS text_size_55, t52.text_color AS text_color_56, t52.text_position AS text_position_57, t52.image_id AS image_id_58 FROM page t0 LEFT JOIN route t33 ON t33.page_id = t0.id LEFT JOIN og_image t52 ON t0.og_image_id = t52.id WHERE t0.id = ? AND ( (t0.deleted_at IS NULL) ) SELECT t0.deleted_at AS deleted_at_1, t0.type AS type_2, t0.title AS title_3, t0.fixed_header_title AS fixed_header_title_4, t0.body AS body_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.symlink_variable_pattern AS symlink_variable_pattern_9, t0.show_in_menu AS show_in_menu_10, t0.alias AS alias_11, t0.deletable AS deletable_12, t0.class AS class_13, t0.body_class AS body_class_14, t0.breadcrumbs AS breadcrumbs_15, t0.controller AS controller_16, t0.feature AS feature_17, t0.icon_class AS icon_class_18, t0.hide_title AS hide_title_19, t0.concept AS concept_20, t0.target AS target_21, t0.mega_menu AS mega_menu_22, t0.mega_menu_title AS mega_menu_title_23, t0.mega_menu_intro AS mega_menu_intro_24, t0.mega_menu_outro AS mega_menu_outro_25, t0.id AS id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.robots AS robots_29, t0.meta_title AS meta_title_30, t0.meta_description AS meta_description_31, t0.parent_id AS parent_id_32, t33.id AS id_34, t33.`name` AS name_35, t33.defaults AS defaults_36, t33.staticPrefix AS staticPrefix_37, t33.variable_pattern AS variable_pattern_38, t33.requirements AS requirements_39, t33.options AS options_40, t33.host AS host_41, t33.schemes AS schemes_42, t33.`methods` AS methods_43, t33.`condition` AS condition_44, t33.locale AS locale_45, t33.page_id AS page_id_46, t0.symlink_id AS symlink_id_47, t0.mega_menu_item_id AS mega_menu_item_id_48, t0.hero_configuration_id AS hero_configuration_id_49, t0.connexys_page_configuration_id AS connexys_page_configuration_id_50, t0.og_image_id AS og_image_id_51, t52.id AS id_53, t52.field AS field_54, t52.text_size AS text_size_55, t52.text_color AS text_color_56, t52.text_position AS text_position_57, t52.image_id AS image_id_58 FROM page t0 LEFT JOIN route t33 ON t33.page_id = t0.id LEFT JOIN og_image t52 ON t0.og_image_id = t52.id WHERE t0.id = 38 AND ((t0.deleted_at IS NULL));
6.17 ms (2.92%)	1	SELECT t0.id AS id_1, t0.value AS value_2, t0.slug AS slug_3, t0.position AS position_4, t0.font_awesome_icon AS font_awesome_icon_5, t0.content AS content_6, t0.external_id AS external_id_7, t0.external_reference AS external_reference_8, t0.external_hash AS external_hash_9, t0.vacancy_usp_id AS vacancy_usp_id_10, t11.id AS id_12, t11.title AS title_13, t11.slug AS slug_14, t11.font_awesome_icon AS font_awesome_icon_15, t11.internal_name AS internal_name_16, t11.external_id AS external_id_17, t11.external_reference AS external_reference_18, t11.external_hash AS external_hash_19, t11.position AS position_20 FROM vacancy_usp_value t0 LEFT JOIN vacancy_usp t11 ON t0.vacancy_usp_id = t11.id INNER JOIN vacancy_usp_value_usp ON t0.id = vacancy_usp_value_usp.vacancy_usp_value_id WHERE vacancy_usp_value_usp.vacancy_id = ? Parameters: [`351`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.value AS value_2, t0.slug AS slug_3, t0.position AS position_4, t0.font_awesome_icon AS font_awesome_icon_5, t0.content AS content_6, t0.external_id AS external_id_7, t0.external_reference AS external_reference_8, t0.external_hash AS external_hash_9, t0.vacancy_usp_id AS vacancy_usp_id_10, t11.id AS id_12, t11.title AS title_13, t11.slug AS slug_14, t11.font_awesome_icon AS font_awesome_icon_15, t11.internal_name AS internal_name_16, t11.external_id AS external_id_17, t11.external_reference AS external_reference_18, t11.external_hash AS external_hash_19, t11.position AS position_20 FROM vacancy_usp_value t0 LEFT JOIN vacancy_usp t11 ON t0.vacancy_usp_id = t11.id INNER JOIN vacancy_usp_value_usp ON t0.id = vacancy_usp_value_usp.vacancy_usp_value_id WHERE vacancy_usp_value_usp.vacancy_id = ? SELECT t0.id AS id_1, t0.value AS value_2, t0.slug AS slug_3, t0.position AS position_4, t0.font_awesome_icon AS font_awesome_icon_5, t0.content AS content_6, t0.external_id AS external_id_7, t0.external_reference AS external_reference_8, t0.external_hash AS external_hash_9, t0.vacancy_usp_id AS vacancy_usp_id_10, t11.id AS id_12, t11.title AS title_13, t11.slug AS slug_14, t11.font_awesome_icon AS font_awesome_icon_15, t11.internal_name AS internal_name_16, t11.external_id AS external_id_17, t11.external_reference AS external_reference_18, t11.external_hash AS external_hash_19, t11.position AS position_20 FROM vacancy_usp_value t0 LEFT JOIN vacancy_usp t11 ON t0.vacancy_usp_id = t11.id INNER JOIN vacancy_usp_value_usp ON t0.id = vacancy_usp_value_usp.vacancy_usp_value_id WHERE vacancy_usp_value_usp.vacancy_id = 351;
5.93 ms (2.80%)	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"`] View formatted query View runnable query Explain query 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 = ? 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 = 'script';
5.64 ms (2.67%)	1	SELECT t0_.title AS title_0, t0_.employee_name AS employee_name_1, t0_.company AS company_2, t0_.slug AS slug_3, t0_.intro AS intro_4, t0_.url AS url_5, t0_.url_target AS url_target_6, t0_.value AS value_7, t0_.picture_title AS picture_title_8, t0_.meta_title AS meta_title_9, t0_.meta_description AS meta_description_10, t0_.detail_page AS detail_page_11, t0_.id AS id_12, t0_.created_at AS created_at_13, t0_.updated_at AS updated_at_14, t0_.robots AS robots_15, t0_.layout_file AS layout_file_16, count(t1_.id) AS sclr_17, t0_.picture_asset_id AS picture_asset_id_18, t0_.author_picture_asset_id AS author_picture_asset_id_19, t0_.og_asset_id AS og_asset_id_20, t0_.company_logo_asset_id AS company_logo_asset_id_21, t0_.employee_id AS employee_id_22, t0_.product_id AS product_id_23, t0_.portfolio_id AS portfolio_id_24, t0_.calendar_id AS calendar_id_25, t0_.gallery_id AS gallery_id_26, t0_.video_embed_id AS video_embed_id_27 FROM testimonial t0_ INNER JOIN testimonial_tags t2_ ON t0_.id = t2_.testimonial_id INNER JOIN tag t1_ ON t1_.id = t2_.tag_id AND (t1_.id IN (NULL)) GROUP BY t0_.id ORDER BY sclr_17 DESC Parameters: [] View formatted query View runnable query Explain query SELECT t0_.title AS title_0, t0_.employee_name AS employee_name_1, t0_.company AS company_2, t0_.slug AS slug_3, t0_.intro AS intro_4, t0_.url AS url_5, t0_.url_target AS url_target_6, t0_.value AS value_7, t0_.picture_title AS picture_title_8, t0_.meta_title AS meta_title_9, t0_.meta_description AS meta_description_10, t0_.detail_page AS detail_page_11, t0_.id AS id_12, t0_.created_at AS created_at_13, t0_.updated_at AS updated_at_14, t0_.robots AS robots_15, t0_.layout_file AS layout_file_16, count(t1_.id) AS sclr_17, t0_.picture_asset_id AS picture_asset_id_18, t0_.author_picture_asset_id AS author_picture_asset_id_19, t0_.og_asset_id AS og_asset_id_20, t0_.company_logo_asset_id AS company_logo_asset_id_21, t0_.employee_id AS employee_id_22, t0_.product_id AS product_id_23, t0_.portfolio_id AS portfolio_id_24, t0_.calendar_id AS calendar_id_25, t0_.gallery_id AS gallery_id_26, t0_.video_embed_id AS video_embed_id_27 FROM testimonial t0_ INNER JOIN testimonial_tags t2_ ON t0_.id = t2_.testimonial_id INNER JOIN tag t1_ ON t1_.id = t2_.tag_id AND ( t1_.id IN (NULL) ) GROUP BY t0_.id ORDER BY sclr_17 DESC SELECT t0_.title AS title_0, t0_.employee_name AS employee_name_1, t0_.company AS company_2, t0_.slug AS slug_3, t0_.intro AS intro_4, t0_.url AS url_5, t0_.url_target AS url_target_6, t0_.value AS value_7, t0_.picture_title AS picture_title_8, t0_.meta_title AS meta_title_9, t0_.meta_description AS meta_description_10, t0_.detail_page AS detail_page_11, t0_.id AS id_12, t0_.created_at AS created_at_13, t0_.updated_at AS updated_at_14, t0_.robots AS robots_15, t0_.layout_file AS layout_file_16, count(t1_.id) AS sclr_17, t0_.picture_asset_id AS picture_asset_id_18, t0_.author_picture_asset_id AS author_picture_asset_id_19, t0_.og_asset_id AS og_asset_id_20, t0_.company_logo_asset_id AS company_logo_asset_id_21, t0_.employee_id AS employee_id_22, t0_.product_id AS product_id_23, t0_.portfolio_id AS portfolio_id_24, t0_.calendar_id AS calendar_id_25, t0_.gallery_id AS gallery_id_26, t0_.video_embed_id AS video_embed_id_27 FROM testimonial t0_ INNER JOIN testimonial_tags t2_ ON t0_.id = t2_.testimonial_id INNER JOIN tag t1_ ON t1_.id = t2_.tag_id AND (t1_.id IN (NULL)) GROUP BY t0_.id ORDER BY sclr_17 DESC;
4.50 ms (2.13%)	1	SELECT t0.id AS id_1, t0.value AS value_2, t0.appearance AS appearance_3 FROM tag t0 INNER JOIN vacancy_tags ON t0.id = vacancy_tags.tag_id WHERE vacancy_tags.vacancy_id = ? Parameters: [`351`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.value AS value_2, t0.appearance AS appearance_3 FROM tag t0 INNER JOIN vacancy_tags ON t0.id = vacancy_tags.tag_id WHERE vacancy_tags.vacancy_id = ? SELECT t0.id AS id_1, t0.value AS value_2, t0.appearance AS appearance_3 FROM tag t0 INNER JOIN vacancy_tags ON t0.id = vacancy_tags.tag_id WHERE vacancy_tags.vacancy_id = 351;
4.01 ms (1.90%)	2	SELECT t0.id AS id_1, t0.value AS value_2, t0.font_awesome_icon AS font_awesome_icon_3, t0.counter AS counter_4, t0.`type` AS type_5, t0.category AS category_6, t0.description AS description_7, t0.url AS url_8, t0.url_target AS url_target_9, t0.dot_start_at AS dot_start_at_10, t0.prefix AS prefix_11, t0.suffix AS suffix_12, t0.position AS position_13, t0.usp_image_asset_id AS usp_image_asset_id_14, t15.id AS id_16, t15.file_name AS file_name_17, t15.file_size AS file_size_18, t15.file_mime_type AS file_mime_type_19, t15.meta_information AS meta_information_20, t15.updated_at AS updated_at_21, t15.external_id AS external_id_22, t15.folder_id AS folder_id_23 FROM usp t0 LEFT JOIN asset t15 ON t0.usp_image_asset_id = t15.id Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.value AS value_2, t0.font_awesome_icon AS font_awesome_icon_3, t0.counter AS counter_4, t0.`type` AS type_5, t0.category AS category_6, t0.description AS description_7, t0.url AS url_8, t0.url_target AS url_target_9, t0.dot_start_at AS dot_start_at_10, t0.prefix AS prefix_11, t0.suffix AS suffix_12, t0.position AS position_13, t0.usp_image_asset_id AS usp_image_asset_id_14, t15.id AS id_16, t15.file_name AS file_name_17, t15.file_size AS file_size_18, t15.file_mime_type AS file_mime_type_19, t15.meta_information AS meta_information_20, t15.updated_at AS updated_at_21, t15.external_id AS external_id_22, t15.folder_id AS folder_id_23 FROM usp t0 LEFT JOIN asset t15 ON t0.usp_image_asset_id = t15.id SELECT t0.id AS id_1, t0.value AS value_2, t0.font_awesome_icon AS font_awesome_icon_3, t0.counter AS counter_4, t0.`type` AS type_5, t0.category AS category_6, t0.description AS description_7, t0.url AS url_8, t0.url_target AS url_target_9, t0.dot_start_at AS dot_start_at_10, t0.prefix AS prefix_11, t0.suffix AS suffix_12, t0.position AS position_13, t0.usp_image_asset_id AS usp_image_asset_id_14, t15.id AS id_16, t15.file_name AS file_name_17, t15.file_size AS file_size_18, t15.file_mime_type AS file_mime_type_19, t15.meta_information AS meta_information_20, t15.updated_at AS updated_at_21, t15.external_id AS external_id_22, t15.folder_id AS folder_id_23 FROM usp t0 LEFT JOIN asset t15 ON t0.usp_image_asset_id = t15.id;
3.56 ms (1.68%)	1	SELECT v0_.id AS id_0, v0_.active AS active_1, v0_.created AS created_2, v0_.updated AS updated_3, v0_.sort_date AS sort_date_4, v0_.contact_person AS contact_person_5, v0_.contact_person_phone AS contact_person_phone_6, v0_.slug AS slug_7, v0_.title AS title_8, v0_.company_name AS company_name_9, v0_.city AS city_10, v0_.zipcode AS zipcode_11, v0_.external_url AS external_url_12, v0_.intro AS intro_13, v0_.description AS description_14, v0_.featured AS featured_15, v0_.internal_vacancy AS internal_vacancy_16, v0_.start_date AS start_date_17, v0_.end_date AS end_date_18, v0_.job_start_date AS job_start_date_19, v0_.applicant_form_custom AS applicant_form_custom_20, v0_.applicant_email AS applicant_email_21, v0_.deleted AS deleted_22, v0_.external_reference AS external_reference_23, v0_.synced AS synced_24, v0_.youtube AS youtube_25, v0_.external_id AS external_id_26, v0_.displayable_external_id AS displayable_external_id_27, v0_.master_vacancy AS master_vacancy_28, v0_.country AS country_29, v0_.salary_amount AS salary_amount_30, v0_.salary_currency AS salary_currency_31, v0_.min_salary_amount AS min_salary_amount_32, v0_.min_salary_currency AS min_salary_currency_33, v0_.max_salary_amount AS max_salary_amount_34, v0_.max_salary_currency AS max_salary_currency_35, v0_.custom_salary AS custom_salary_36, v0_.redirect_count AS redirect_count_37, v0_.province AS province_38, v0_.company_information AS company_information_39, v0_.has_more_info_button AS has_more_info_button_40, v0_.owner_notified AS owner_notified_41, v0_.`function` AS function_42, v0_.external_detail_url AS external_detail_url_43, v0_.google_for_job_mapping AS google_for_job_mapping_44, v0_.salary_unit AS salary_unit_45, v0_.department AS department_46, v0_.google_cloud_name AS google_cloud_name_47, v0_.address AS address_48, v0_.latitude AS latitude_49, v0_.longitude AS longitude_50, v0_.external_hash AS external_hash_51, v0_.meta_title AS meta_title_52, v0_.meta_description AS meta_description_53, v0_.utm_medium AS utm_medium_54, v0_.utm_campaign AS utm_campaign_55, v0_.detail_image_asset_id AS detail_image_asset_id_56, v0_.overview_image_asset_id AS overview_image_asset_id_57, v0_.hero_image_asset_id AS hero_image_asset_id_58, v0_.company_id AS company_id_59, v0_.recruiter_id AS recruiter_id_60, v0_.main_icon_id AS main_icon_id_61, v0_.usp_sub_title_id AS usp_sub_title_id_62, v0_.description_form_id AS description_form_id_63, v0_.applicant_form_id AS applicant_form_id_64, v0_.custom_applicant_form_id AS custom_applicant_form_id_65, v0_.invoice_id AS invoice_id_66, v0_.template_id AS template_id_67, v0_.company_logo_asset_id AS company_logo_asset_id_68, v0_.multi_poster_id AS multi_poster_id_69, v0_.primary_discipline_id AS primary_discipline_id_70, v0_.secundary_discipline_id AS secundary_discipline_id_71, v0_.harver_experience_id AS harver_experience_id_72, v0_.application_process_id AS application_process_id_73, v0_.domain_id AS domain_id_74, v0_.calendar_id AS calendar_id_75, v0_.gallery_id AS gallery_id_76, v0_.og_image_id AS og_image_id_77, v0_.site_id AS site_id_78 FROM vacancy v0_ INNER JOIN vacancy_option_value_option v2_ ON v0_.id = v2_.vacancy_id INNER JOIN vacancy_option_value v1_ ON v1_.id = v2_.option_value_id WHERE (v1_.id IN (NULL) AND v0_.deleted IS NULL AND v0_.active = ? AND (v0_.start_date IS NULL OR v0_.start_date <= ?) AND (v0_.end_date IS NULL OR v0_.end_date > ?) AND v0_.id <> ?) AND (v0_.deleted IS NULL) LIMIT 4 Parameters: [`1 "2024-11-10 02:26:03" "2024-11-10 02:26:03" 351`] View formatted query View runnable query Explain query SELECT v0_.id AS id_0, v0_.active AS active_1, v0_.created AS created_2, v0_.updated AS updated_3, v0_.sort_date AS sort_date_4, v0_.contact_person AS contact_person_5, v0_.contact_person_phone AS contact_person_phone_6, v0_.slug AS slug_7, v0_.title AS title_8, v0_.company_name AS company_name_9, v0_.city AS city_10, v0_.zipcode AS zipcode_11, v0_.external_url AS external_url_12, v0_.intro AS intro_13, v0_.description AS description_14, v0_.featured AS featured_15, v0_.internal_vacancy AS internal_vacancy_16, v0_.start_date AS start_date_17, v0_.end_date AS end_date_18, v0_.job_start_date AS job_start_date_19, v0_.applicant_form_custom AS applicant_form_custom_20, v0_.applicant_email AS applicant_email_21, v0_.deleted AS deleted_22, v0_.external_reference AS external_reference_23, v0_.synced AS synced_24, v0_.youtube AS youtube_25, v0_.external_id AS external_id_26, v0_.displayable_external_id AS displayable_external_id_27, v0_.master_vacancy AS master_vacancy_28, v0_.country AS country_29, v0_.salary_amount AS salary_amount_30, v0_.salary_currency AS salary_currency_31, v0_.min_salary_amount AS min_salary_amount_32, v0_.min_salary_currency AS min_salary_currency_33, v0_.max_salary_amount AS max_salary_amount_34, v0_.max_salary_currency AS max_salary_currency_35, v0_.custom_salary AS custom_salary_36, v0_.redirect_count AS redirect_count_37, v0_.province AS province_38, v0_.company_information AS company_information_39, v0_.has_more_info_button AS has_more_info_button_40, v0_.owner_notified AS owner_notified_41, v0_.`function` AS function_42, v0_.external_detail_url AS external_detail_url_43, v0_.google_for_job_mapping AS google_for_job_mapping_44, v0_.salary_unit AS salary_unit_45, v0_.department AS department_46, v0_.google_cloud_name AS google_cloud_name_47, v0_.address AS address_48, v0_.latitude AS latitude_49, v0_.longitude AS longitude_50, v0_.external_hash AS external_hash_51, v0_.meta_title AS meta_title_52, v0_.meta_description AS meta_description_53, v0_.utm_medium AS utm_medium_54, v0_.utm_campaign AS utm_campaign_55, v0_.detail_image_asset_id AS detail_image_asset_id_56, v0_.overview_image_asset_id AS overview_image_asset_id_57, v0_.hero_image_asset_id AS hero_image_asset_id_58, v0_.company_id AS company_id_59, v0_.recruiter_id AS recruiter_id_60, v0_.main_icon_id AS main_icon_id_61, v0_.usp_sub_title_id AS usp_sub_title_id_62, v0_.description_form_id AS description_form_id_63, v0_.applicant_form_id AS applicant_form_id_64, v0_.custom_applicant_form_id AS custom_applicant_form_id_65, v0_.invoice_id AS invoice_id_66, v0_.template_id AS template_id_67, v0_.company_logo_asset_id AS company_logo_asset_id_68, v0_.multi_poster_id AS multi_poster_id_69, v0_.primary_discipline_id AS primary_discipline_id_70, v0_.secundary_discipline_id AS secundary_discipline_id_71, v0_.harver_experience_id AS harver_experience_id_72, v0_.application_process_id AS application_process_id_73, v0_.domain_id AS domain_id_74, v0_.calendar_id AS calendar_id_75, v0_.gallery_id AS gallery_id_76, v0_.og_image_id AS og_image_id_77, v0_.site_id AS site_id_78 FROM vacancy v0_ INNER JOIN vacancy_option_value_option v2_ ON v0_.id = v2_.vacancy_id INNER JOIN vacancy_option_value v1_ ON v1_.id = v2_.option_value_id WHERE ( v1_.id IN (NULL) AND v0_.deleted IS NULL AND v0_.active = ? AND ( v0_.start_date IS NULL OR v0_.start_date <= ? ) AND ( v0_.end_date IS NULL OR v0_.end_date > ? ) AND v0_.id <> ? ) AND (v0_.deleted IS NULL) LIMIT 4 SELECT v0_.id AS id_0, v0_.active AS active_1, v0_.created AS created_2, v0_.updated AS updated_3, v0_.sort_date AS sort_date_4, v0_.contact_person AS contact_person_5, v0_.contact_person_phone AS contact_person_phone_6, v0_.slug AS slug_7, v0_.title AS title_8, v0_.company_name AS company_name_9, v0_.city AS city_10, v0_.zipcode AS zipcode_11, v0_.external_url AS external_url_12, v0_.intro AS intro_13, v0_.description AS description_14, v0_.featured AS featured_15, v0_.internal_vacancy AS internal_vacancy_16, v0_.start_date AS start_date_17, v0_.end_date AS end_date_18, v0_.job_start_date AS job_start_date_19, v0_.applicant_form_custom AS applicant_form_custom_20, v0_.applicant_email AS applicant_email_21, v0_.deleted AS deleted_22, v0_.external_reference AS external_reference_23, v0_.synced AS synced_24, v0_.youtube AS youtube_25, v0_.external_id AS external_id_26, v0_.displayable_external_id AS displayable_external_id_27, v0_.master_vacancy AS master_vacancy_28, v0_.country AS country_29, v0_.salary_amount AS salary_amount_30, v0_.salary_currency AS salary_currency_31, v0_.min_salary_amount AS min_salary_amount_32, v0_.min_salary_currency AS min_salary_currency_33, v0_.max_salary_amount AS max_salary_amount_34, v0_.max_salary_currency AS max_salary_currency_35, v0_.custom_salary AS custom_salary_36, v0_.redirect_count AS redirect_count_37, v0_.province AS province_38, v0_.company_information AS company_information_39, v0_.has_more_info_button AS has_more_info_button_40, v0_.owner_notified AS owner_notified_41, v0_.`function` AS function_42, v0_.external_detail_url AS external_detail_url_43, v0_.google_for_job_mapping AS google_for_job_mapping_44, v0_.salary_unit AS salary_unit_45, v0_.department AS department_46, v0_.google_cloud_name AS google_cloud_name_47, v0_.address AS address_48, v0_.latitude AS latitude_49, v0_.longitude AS longitude_50, v0_.external_hash AS external_hash_51, v0_.meta_title AS meta_title_52, v0_.meta_description AS meta_description_53, v0_.utm_medium AS utm_medium_54, v0_.utm_campaign AS utm_campaign_55, v0_.detail_image_asset_id AS detail_image_asset_id_56, v0_.overview_image_asset_id AS overview_image_asset_id_57, v0_.hero_image_asset_id AS hero_image_asset_id_58, v0_.company_id AS company_id_59, v0_.recruiter_id AS recruiter_id_60, v0_.main_icon_id AS main_icon_id_61, v0_.usp_sub_title_id AS usp_sub_title_id_62, v0_.description_form_id AS description_form_id_63, v0_.applicant_form_id AS applicant_form_id_64, v0_.custom_applicant_form_id AS custom_applicant_form_id_65, v0_.invoice_id AS invoice_id_66, v0_.template_id AS template_id_67, v0_.company_logo_asset_id AS company_logo_asset_id_68, v0_.multi_poster_id AS multi_poster_id_69, v0_.primary_discipline_id AS primary_discipline_id_70, v0_.secundary_discipline_id AS secundary_discipline_id_71, v0_.harver_experience_id AS harver_experience_id_72, v0_.application_process_id AS application_process_id_73, v0_.domain_id AS domain_id_74, v0_.calendar_id AS calendar_id_75, v0_.gallery_id AS gallery_id_76, v0_.og_image_id AS og_image_id_77, v0_.site_id AS site_id_78 FROM vacancy v0_ INNER JOIN vacancy_option_value_option v2_ ON v0_.id = v2_.vacancy_id INNER JOIN vacancy_option_value v1_ ON v1_.id = v2_.option_value_id WHERE (v1_.id IN (NULL) AND v0_.deleted IS NULL AND v0_.active = 1 AND (v0_.start_date IS NULL OR v0_.start_date <= '2024-11-10 02:26:03') AND (v0_.end_date IS NULL OR v0_.end_date > '2024-11-10 02:26:03') AND v0_.id <> 351) AND (v0_.deleted IS NULL) LIMIT 4;
3.51 ms (1.66%)	1	SELECT t0.id AS id_1, t0.title_template AS title_template_2, t0.description_template AS description_template_3, t0.object_class AS object_class_4, t0.foreign_key AS foreign_key_5, t0.date_format AS date_format_6 FROM meta_templates t0 WHERE t0.object_class = ? AND t0.foreign_key = ? LIMIT 1 Parameters: [`"App\Entity\Vacancy" 351`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title_template AS title_template_2, t0.description_template AS description_template_3, t0.object_class AS object_class_4, t0.foreign_key AS foreign_key_5, t0.date_format AS date_format_6 FROM meta_templates t0 WHERE t0.object_class = ? AND t0.foreign_key = ? LIMIT 1 SELECT t0.id AS id_1, t0.title_template AS title_template_2, t0.description_template AS description_template_3, t0.object_class AS object_class_4, t0.foreign_key AS foreign_key_5, t0.date_format AS date_format_6 FROM meta_templates t0 WHERE t0.object_class = 'App\\Entity\\Vacancy' AND t0.foreign_key = 351 LIMIT 1;
3.50 ms (1.65%)	2	SELECT t0.id AS id_1, t0.fields AS fields_2, t0.type AS type_3 FROM vacancy_description_form t0 WHERE t0.type = ? LIMIT 1 Parameters: [`"featured"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fields AS fields_2, t0.type AS type_3 FROM vacancy_description_form t0 WHERE t0.type = ? LIMIT 1 SELECT t0.id AS id_1, t0.fields AS fields_2, t0.type AS type_3 FROM vacancy_description_form t0 WHERE t0.type = 'featured' LIMIT 1;
3.23 ms (1.53%)	1	SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.font_awesome_icon AS font_awesome_icon_4, t0.expanded_by_default AS expanded_by_default_5, t0.strategy_on_overview AS strategy_on_overview_6, t0.visible_in_detail AS visible_in_detail_7, t0.group_text AS group_text_8, t0.group_at_count AS group_at_count_9, t0.internal_name AS internal_name_10, t0.sort_option_images AS sort_option_images_11, t0.strategy_on_job_profile_overview AS strategy_on_job_profile_overview_12, t0.display_type AS display_type_13, t0.expanded_strategy AS expanded_strategy_14, t0.contextual_title AS contextual_title_15, t0.external_id AS external_id_16, t0.external_reference AS external_reference_17, t0.external_hash AS external_hash_18, t0.position AS position_19, t0.job_alert_setting_id AS job_alert_setting_id_20 FROM vacancy_option t0 WHERE t0.id = ? Parameters: [`"3"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.font_awesome_icon AS font_awesome_icon_4, t0.expanded_by_default AS expanded_by_default_5, t0.strategy_on_overview AS strategy_on_overview_6, t0.visible_in_detail AS visible_in_detail_7, t0.group_text AS group_text_8, t0.group_at_count AS group_at_count_9, t0.internal_name AS internal_name_10, t0.sort_option_images AS sort_option_images_11, t0.strategy_on_job_profile_overview AS strategy_on_job_profile_overview_12, t0.display_type AS display_type_13, t0.expanded_strategy AS expanded_strategy_14, t0.contextual_title AS contextual_title_15, t0.external_id AS external_id_16, t0.external_reference AS external_reference_17, t0.external_hash AS external_hash_18, t0.position AS position_19, t0.job_alert_setting_id AS job_alert_setting_id_20 FROM vacancy_option t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.font_awesome_icon AS font_awesome_icon_4, t0.expanded_by_default AS expanded_by_default_5, t0.strategy_on_overview AS strategy_on_overview_6, t0.visible_in_detail AS visible_in_detail_7, t0.group_text AS group_text_8, t0.group_at_count AS group_at_count_9, t0.internal_name AS internal_name_10, t0.sort_option_images AS sort_option_images_11, t0.strategy_on_job_profile_overview AS strategy_on_job_profile_overview_12, t0.display_type AS display_type_13, t0.expanded_strategy AS expanded_strategy_14, t0.contextual_title AS contextual_title_15, t0.external_id AS external_id_16, t0.external_reference AS external_reference_17, t0.external_hash AS external_hash_18, t0.position AS position_19, t0.job_alert_setting_id AS job_alert_setting_id_20 FROM vacancy_option t0 WHERE t0.id = '3';
3.03 ms (1.43%)	1	SELECT t0.id AS id_1, t0.value AS value_2, t0.font_awesome_icon AS font_awesome_icon_3, t0.counter AS counter_4, t0.`type` AS type_5, t0.category AS category_6, t0.description AS description_7, t0.url AS url_8, t0.url_target AS url_target_9, t0.dot_start_at AS dot_start_at_10, t0.prefix AS prefix_11, t0.suffix AS suffix_12, t0.position AS position_13, t0.usp_image_asset_id AS usp_image_asset_id_14, t15.id AS id_16, t15.file_name AS file_name_17, t15.file_size AS file_size_18, t15.file_mime_type AS file_mime_type_19, t15.meta_information AS meta_information_20, t15.updated_at AS updated_at_21, t15.external_id AS external_id_22, t15.folder_id AS folder_id_23 FROM usp t0 LEFT JOIN asset t15 ON t0.usp_image_asset_id = t15.id INNER JOIN vacancy_usp_option ON t0.id = vacancy_usp_option.usp_id WHERE vacancy_usp_option.vacancy_id = ? Parameters: [`351`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.value AS value_2, t0.font_awesome_icon AS font_awesome_icon_3, t0.counter AS counter_4, t0.`type` AS type_5, t0.category AS category_6, t0.description AS description_7, t0.url AS url_8, t0.url_target AS url_target_9, t0.dot_start_at AS dot_start_at_10, t0.prefix AS prefix_11, t0.suffix AS suffix_12, t0.position AS position_13, t0.usp_image_asset_id AS usp_image_asset_id_14, t15.id AS id_16, t15.file_name AS file_name_17, t15.file_size AS file_size_18, t15.file_mime_type AS file_mime_type_19, t15.meta_information AS meta_information_20, t15.updated_at AS updated_at_21, t15.external_id AS external_id_22, t15.folder_id AS folder_id_23 FROM usp t0 LEFT JOIN asset t15 ON t0.usp_image_asset_id = t15.id INNER JOIN vacancy_usp_option ON t0.id = vacancy_usp_option.usp_id WHERE vacancy_usp_option.vacancy_id = ? SELECT t0.id AS id_1, t0.value AS value_2, t0.font_awesome_icon AS font_awesome_icon_3, t0.counter AS counter_4, t0.`type` AS type_5, t0.category AS category_6, t0.description AS description_7, t0.url AS url_8, t0.url_target AS url_target_9, t0.dot_start_at AS dot_start_at_10, t0.prefix AS prefix_11, t0.suffix AS suffix_12, t0.position AS position_13, t0.usp_image_asset_id AS usp_image_asset_id_14, t15.id AS id_16, t15.file_name AS file_name_17, t15.file_size AS file_size_18, t15.file_mime_type AS file_mime_type_19, t15.meta_information AS meta_information_20, t15.updated_at AS updated_at_21, t15.external_id AS external_id_22, t15.folder_id AS folder_id_23 FROM usp t0 LEFT JOIN asset t15 ON t0.usp_image_asset_id = t15.id INNER JOIN vacancy_usp_option ON t0.id = vacancy_usp_option.usp_id WHERE vacancy_usp_option.vacancy_id = 351;
2.45 ms (1.16%)	2	SELECT f0_.name AS name_0, f0_.active AS active_1 FROM feature f0_ Parameters: [] View formatted query View runnable query Explain query SELECT f0_.name AS name_0, f0_.active AS active_1 FROM feature f0_ SELECT f0_.name AS name_0, f0_.active AS active_1 FROM feature f0_;
2.18 ms (1.03%)	1	SELECT t0.id AS id_1, t0.active AS active_2, t0.created AS created_3, t0.updated AS updated_4, t0.sort_date AS sort_date_5, t0.contact_person AS contact_person_6, t0.contact_person_phone AS contact_person_phone_7, t0.slug AS slug_8, t0.title AS title_9, t0.company_name AS company_name_10, t0.city AS city_11, t0.zipcode AS zipcode_12, t0.external_url AS external_url_13, t0.intro AS intro_14, t0.description AS description_15, t0.featured AS featured_16, t0.internal_vacancy AS internal_vacancy_17, t0.start_date AS start_date_18, t0.end_date AS end_date_19, t0.job_start_date AS job_start_date_20, t0.applicant_form_custom AS applicant_form_custom_21, t0.applicant_email AS applicant_email_22, t0.deleted AS deleted_23, t0.external_reference AS external_reference_24, t0.synced AS synced_25, t0.youtube AS youtube_26, t0.external_id AS external_id_27, t0.displayable_external_id AS displayable_external_id_28, t0.master_vacancy AS master_vacancy_29, t0.country AS country_30, t0.salary_amount AS salary_amount_31, t0.salary_currency AS salary_currency_32, t0.min_salary_amount AS min_salary_amount_33, t0.min_salary_currency AS min_salary_currency_34, t0.max_salary_amount AS max_salary_amount_35, t0.max_salary_currency AS max_salary_currency_36, t0.custom_salary AS custom_salary_37, t0.redirect_count AS redirect_count_38, t0.province AS province_39, t0.company_information AS company_information_40, t0.has_more_info_button AS has_more_info_button_41, t0.owner_notified AS owner_notified_42, t0.`function` AS function_43, t0.external_detail_url AS external_detail_url_44, t0.google_for_job_mapping AS google_for_job_mapping_45, t0.salary_unit AS salary_unit_46, t0.department AS department_47, t0.google_cloud_name AS google_cloud_name_48, t0.address AS address_49, t0.latitude AS latitude_50, t0.longitude AS longitude_51, t0.external_hash AS external_hash_52, t0.meta_title AS meta_title_53, t0.meta_description AS meta_description_54, t0.utm_medium AS utm_medium_55, t0.utm_campaign AS utm_campaign_56, t0.detail_image_asset_id AS detail_image_asset_id_57, t0.overview_image_asset_id AS overview_image_asset_id_58, t59.id AS id_60, t59.file_name AS file_name_61, t59.file_size AS file_size_62, t59.file_mime_type AS file_mime_type_63, t59.meta_information AS meta_information_64, t59.updated_at AS updated_at_65, t59.external_id AS external_id_66, t59.folder_id AS folder_id_67, t0.hero_image_asset_id AS hero_image_asset_id_68, t0.company_id AS company_id_69, t70.id AS id_71, t70.slug AS slug_72, t70.name AS name_73, t70.zipcode AS zipcode_74, t70.city AS city_75, t70.country AS country_76, t70.contact_person AS contact_person_77, t70.contact_person_gender AS contact_person_gender_78, t70.contact_person_first_name AS contact_person_first_name_79, t70.contact_person_initials AS contact_person_initials_80, t70.contact_person_prefix AS contact_person_prefix_81, t70.contact_person_last_name AS contact_person_last_name_82, t70.phone AS phone_83, t70.extension AS extension_84, t70.mobile AS mobile_85, t70.website AS website_86, t70.email AS email_87, t70.updated_at AS updated_at_88, t70.applicant_email AS applicant_email_89, t70.description AS description_90, t70.external_id AS external_id_91, t70.canonical_url AS canonical_url_92, t70.deleted AS deleted_93, t70.openinghours AS openinghours_94, t70.accessibility AS accessibility_95, t70.credits AS credits_96, t70.video AS video_97, t70.action_date AS action_date_98, t70.action_type AS action_type_99, t70.friendly_url AS friendly_url_100, t70.province AS province_101, t70.company_information AS company_information_102, t70.multi_poster_id AS multi_poster_id_103, t70.google_cloud_name AS google_cloud_name_104, t70.featured AS featured_105, t70.department AS department_106, t70.po_number AS po_number_107, t70.invoice_company_name AS invoice_company_name_108, t70.invoice_department AS invoice_department_109, t70.invoice_contact_person AS invoice_contact_person_110, t70.invoice_email_address AS invoice_email_address_111, t70.invoice_address AS invoice_address_112, t70.invoice_zipcode AS invoice_zipcode_113, t70.invoice_city AS invoice_city_114, t70.invoice_phone AS invoice_phone_115, t70.detail_page AS detail_page_116, t70.detail_page_expiration_date AS detail_page_expiration_date_117, t70.address AS address_118, t70.latitude AS latitude_119, t70.longitude AS longitude_120, t70.meta_title AS meta_title_121, t70.meta_description AS meta_description_122, t70.utm_medium AS utm_medium_123, t70.utm_campaign AS utm_campaign_124, t70.logo_asset_id AS logo_asset_id_125, t70.hero_asset_id AS hero_asset_id_126, t70.overview_image_asset_id AS overview_image_asset_id_127, t70.fields_form_id AS fields_form_id_128, t70.hero_configuration_id AS hero_configuration_id_129, t70.company_status_id AS company_status_id_130, t70.action_assignee_id AS action_assignee_id_131, t70.consultant_id AS consultant_id_132, t70.application_process_id AS application_process_id_133, t70.gallery_id AS gallery_id_134, t70.site_id AS site_id_135, t0.recruiter_id AS recruiter_id_136, t137.first_name AS first_name_138, t137.last_name_prefix AS last_name_prefix_139, t137.last_name AS last_name_140, t137.email AS email_141, t137.phone AS phone_142, t137.linkedin_url AS linkedin_url_143, t137.intro AS intro_144, t137.description AS description_145, t137.picture_name AS picture_name_146, t137.country AS country_147, t137.id AS id_148, t137.created_at AS created_at_149, t137.updated_at AS updated_at_150, t137.robots AS robots_151, t137.external_id AS external_id_152, t137.external_reference AS external_reference_153, t137.external_hash AS external_hash_154, t0.main_icon_id AS main_icon_id_155, t0.usp_sub_title_id AS usp_sub_title_id_156, t0.description_form_id AS description_form_id_157, t0.applicant_form_id AS applicant_form_id_158, t0.custom_applicant_form_id AS custom_applicant_form_id_159, t0.invoice_id AS invoice_id_160, t0.template_id AS template_id_161, t0.company_logo_asset_id AS company_logo_asset_id_162, t163.id AS id_164, t163.file_name AS file_name_165, t163.file_size AS file_size_166, t163.file_mime_type AS file_mime_type_167, t163.meta_information AS meta_information_168, t163.updated_at AS updated_at_169, t163.external_id AS external_id_170, t163.folder_id AS folder_id_171, t0.multi_poster_id AS multi_poster_id_172, t0.primary_discipline_id AS primary_discipline_id_173, t0.secundary_discipline_id AS secundary_discipline_id_174, t0.harver_experience_id AS harver_experience_id_175, t0.application_process_id AS application_process_id_176, t0.domain_id AS domain_id_177, t0.calendar_id AS calendar_id_178, t0.gallery_id AS gallery_id_179, t180.id AS id_181, t180.name AS name_182, t180.title AS title_183, t180.intro AS intro_184, t180.context AS context_185, t180.format AS format_186, t180.enabled AS enabled_187, t180.video_embed_id AS video_embed_id_188, t0.og_image_id AS og_image_id_189, t190.id AS id_191, t190.field AS field_192, t190.text_size AS text_size_193, t190.text_color AS text_color_194, t190.text_position AS text_position_195, t190.image_id AS image_id_196, t0.site_id AS site_id_197 FROM vacancy t0 LEFT JOIN asset t59 ON t0.overview_image_asset_id = t59.id LEFT JOIN company t70 ON t0.company_id = t70.id LEFT JOIN recruiter t137 ON t0.recruiter_id = t137.id LEFT JOIN asset t163 ON t0.company_logo_asset_id = t163.id LEFT JOIN gallery t180 ON t0.gallery_id = t180.id LEFT JOIN og_image t190 ON t0.og_image_id = t190.id WHERE t0.id = ? AND ((t0.deleted IS NULL)) Parameters: [`351`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.active AS active_2, t0.created AS created_3, t0.updated AS updated_4, t0.sort_date AS sort_date_5, t0.contact_person AS contact_person_6, t0.contact_person_phone AS contact_person_phone_7, t0.slug AS slug_8, t0.title AS title_9, t0.company_name AS company_name_10, t0.city AS city_11, t0.zipcode AS zipcode_12, t0.external_url AS external_url_13, t0.intro AS intro_14, t0.description AS description_15, t0.featured AS featured_16, t0.internal_vacancy AS internal_vacancy_17, t0.start_date AS start_date_18, t0.end_date AS end_date_19, t0.job_start_date AS job_start_date_20, t0.applicant_form_custom AS applicant_form_custom_21, t0.applicant_email AS applicant_email_22, t0.deleted AS deleted_23, t0.external_reference AS external_reference_24, t0.synced AS synced_25, t0.youtube AS youtube_26, t0.external_id AS external_id_27, t0.displayable_external_id AS displayable_external_id_28, t0.master_vacancy AS master_vacancy_29, t0.country AS country_30, t0.salary_amount AS salary_amount_31, t0.salary_currency AS salary_currency_32, t0.min_salary_amount AS min_salary_amount_33, t0.min_salary_currency AS min_salary_currency_34, t0.max_salary_amount AS max_salary_amount_35, t0.max_salary_currency AS max_salary_currency_36, t0.custom_salary AS custom_salary_37, t0.redirect_count AS redirect_count_38, t0.province AS province_39, t0.company_information AS company_information_40, t0.has_more_info_button AS has_more_info_button_41, t0.owner_notified AS owner_notified_42, t0.`function` AS function_43, t0.external_detail_url AS external_detail_url_44, t0.google_for_job_mapping AS google_for_job_mapping_45, t0.salary_unit AS salary_unit_46, t0.department AS department_47, t0.google_cloud_name AS google_cloud_name_48, t0.address AS address_49, t0.latitude AS latitude_50, t0.longitude AS longitude_51, t0.external_hash AS external_hash_52, t0.meta_title AS meta_title_53, t0.meta_description AS meta_description_54, t0.utm_medium AS utm_medium_55, t0.utm_campaign AS utm_campaign_56, t0.detail_image_asset_id AS detail_image_asset_id_57, t0.overview_image_asset_id AS overview_image_asset_id_58, t59.id AS id_60, t59.file_name AS file_name_61, t59.file_size AS file_size_62, t59.file_mime_type AS file_mime_type_63, t59.meta_information AS meta_information_64, t59.updated_at AS updated_at_65, t59.external_id AS external_id_66, t59.folder_id AS folder_id_67, t0.hero_image_asset_id AS hero_image_asset_id_68, t0.company_id AS company_id_69, t70.id AS id_71, t70.slug AS slug_72, t70.name AS name_73, t70.zipcode AS zipcode_74, t70.city AS city_75, t70.country AS country_76, t70.contact_person AS contact_person_77, t70.contact_person_gender AS contact_person_gender_78, t70.contact_person_first_name AS contact_person_first_name_79, t70.contact_person_initials AS contact_person_initials_80, t70.contact_person_prefix AS contact_person_prefix_81, t70.contact_person_last_name AS contact_person_last_name_82, t70.phone AS phone_83, t70.extension AS extension_84, t70.mobile AS mobile_85, t70.website AS website_86, t70.email AS email_87, t70.updated_at AS updated_at_88, t70.applicant_email AS applicant_email_89, t70.description AS description_90, t70.external_id AS external_id_91, t70.canonical_url AS canonical_url_92, t70.deleted AS deleted_93, t70.openinghours AS openinghours_94, t70.accessibility AS accessibility_95, t70.credits AS credits_96, t70.video AS video_97, t70.action_date AS action_date_98, t70.action_type AS action_type_99, t70.friendly_url AS friendly_url_100, t70.province AS province_101, t70.company_information AS company_information_102, t70.multi_poster_id AS multi_poster_id_103, t70.google_cloud_name AS google_cloud_name_104, t70.featured AS featured_105, t70.department AS department_106, t70.po_number AS po_number_107, t70.invoice_company_name AS invoice_company_name_108, t70.invoice_department AS invoice_department_109, t70.invoice_contact_person AS invoice_contact_person_110, t70.invoice_email_address AS invoice_email_address_111, t70.invoice_address AS invoice_address_112, t70.invoice_zipcode AS invoice_zipcode_113, t70.invoice_city AS invoice_city_114, t70.invoice_phone AS invoice_phone_115, t70.detail_page AS detail_page_116, t70.detail_page_expiration_date AS detail_page_expiration_date_117, t70.address AS address_118, t70.latitude AS latitude_119, t70.longitude AS longitude_120, t70.meta_title AS meta_title_121, t70.meta_description AS meta_description_122, t70.utm_medium AS utm_medium_123, t70.utm_campaign AS utm_campaign_124, t70.logo_asset_id AS logo_asset_id_125, t70.hero_asset_id AS hero_asset_id_126, t70.overview_image_asset_id AS overview_image_asset_id_127, t70.fields_form_id AS fields_form_id_128, t70.hero_configuration_id AS hero_configuration_id_129, t70.company_status_id AS company_status_id_130, t70.action_assignee_id AS action_assignee_id_131, t70.consultant_id AS consultant_id_132, t70.application_process_id AS application_process_id_133, t70.gallery_id AS gallery_id_134, t70.site_id AS site_id_135, t0.recruiter_id AS recruiter_id_136, t137.first_name AS first_name_138, t137.last_name_prefix AS last_name_prefix_139, t137.last_name AS last_name_140, t137.email AS email_141, t137.phone AS phone_142, t137.linkedin_url AS linkedin_url_143, t137.intro AS intro_144, t137.description AS description_145, t137.picture_name AS picture_name_146, t137.country AS country_147, t137.id AS id_148, t137.created_at AS created_at_149, t137.updated_at AS updated_at_150, t137.robots AS robots_151, t137.external_id AS external_id_152, t137.external_reference AS external_reference_153, t137.external_hash AS external_hash_154, t0.main_icon_id AS main_icon_id_155, t0.usp_sub_title_id AS usp_sub_title_id_156, t0.description_form_id AS description_form_id_157, t0.applicant_form_id AS applicant_form_id_158, t0.custom_applicant_form_id AS custom_applicant_form_id_159, t0.invoice_id AS invoice_id_160, t0.template_id AS template_id_161, t0.company_logo_asset_id AS company_logo_asset_id_162, t163.id AS id_164, t163.file_name AS file_name_165, t163.file_size AS file_size_166, t163.file_mime_type AS file_mime_type_167, t163.meta_information AS meta_information_168, t163.updated_at AS updated_at_169, t163.external_id AS external_id_170, t163.folder_id AS folder_id_171, t0.multi_poster_id AS multi_poster_id_172, t0.primary_discipline_id AS primary_discipline_id_173, t0.secundary_discipline_id AS secundary_discipline_id_174, t0.harver_experience_id AS harver_experience_id_175, t0.application_process_id AS application_process_id_176, t0.domain_id AS domain_id_177, t0.calendar_id AS calendar_id_178, t0.gallery_id AS gallery_id_179, t180.id AS id_181, t180.name AS name_182, t180.title AS title_183, t180.intro AS intro_184, t180.context AS context_185, t180.format AS format_186, t180.enabled AS enabled_187, t180.video_embed_id AS video_embed_id_188, t0.og_image_id AS og_image_id_189, t190.id AS id_191, t190.field AS field_192, t190.text_size AS text_size_193, t190.text_color AS text_color_194, t190.text_position AS text_position_195, t190.image_id AS image_id_196, t0.site_id AS site_id_197 FROM vacancy t0 LEFT JOIN asset t59 ON t0.overview_image_asset_id = t59.id LEFT JOIN company t70 ON t0.company_id = t70.id LEFT JOIN recruiter t137 ON t0.recruiter_id = t137.id LEFT JOIN asset t163 ON t0.company_logo_asset_id = t163.id LEFT JOIN gallery t180 ON t0.gallery_id = t180.id LEFT JOIN og_image t190 ON t0.og_image_id = t190.id WHERE t0.id = ? AND ( (t0.deleted IS NULL) ) SELECT t0.id AS id_1, t0.active AS active_2, t0.created AS created_3, t0.updated AS updated_4, t0.sort_date AS sort_date_5, t0.contact_person AS contact_person_6, t0.contact_person_phone AS contact_person_phone_7, t0.slug AS slug_8, t0.title AS title_9, t0.company_name AS company_name_10, t0.city AS city_11, t0.zipcode AS zipcode_12, t0.external_url AS external_url_13, t0.intro AS intro_14, t0.description AS description_15, t0.featured AS featured_16, t0.internal_vacancy AS internal_vacancy_17, t0.start_date AS start_date_18, t0.end_date AS end_date_19, t0.job_start_date AS job_start_date_20, t0.applicant_form_custom AS applicant_form_custom_21, t0.applicant_email AS applicant_email_22, t0.deleted AS deleted_23, t0.external_reference AS external_reference_24, t0.synced AS synced_25, t0.youtube AS youtube_26, t0.external_id AS external_id_27, t0.displayable_external_id AS displayable_external_id_28, t0.master_vacancy AS master_vacancy_29, t0.country AS country_30, t0.salary_amount AS salary_amount_31, t0.salary_currency AS salary_currency_32, t0.min_salary_amount AS min_salary_amount_33, t0.min_salary_currency AS min_salary_currency_34, t0.max_salary_amount AS max_salary_amount_35, t0.max_salary_currency AS max_salary_currency_36, t0.custom_salary AS custom_salary_37, t0.redirect_count AS redirect_count_38, t0.province AS province_39, t0.company_information AS company_information_40, t0.has_more_info_button AS has_more_info_button_41, t0.owner_notified AS owner_notified_42, t0.`function` AS function_43, t0.external_detail_url AS external_detail_url_44, t0.google_for_job_mapping AS google_for_job_mapping_45, t0.salary_unit AS salary_unit_46, t0.department AS department_47, t0.google_cloud_name AS google_cloud_name_48, t0.address AS address_49, t0.latitude AS latitude_50, t0.longitude AS longitude_51, t0.external_hash AS external_hash_52, t0.meta_title AS meta_title_53, t0.meta_description AS meta_description_54, t0.utm_medium AS utm_medium_55, t0.utm_campaign AS utm_campaign_56, t0.detail_image_asset_id AS detail_image_asset_id_57, t0.overview_image_asset_id AS overview_image_asset_id_58, t59.id AS id_60, t59.file_name AS file_name_61, t59.file_size AS file_size_62, t59.file_mime_type AS file_mime_type_63, t59.meta_information AS meta_information_64, t59.updated_at AS updated_at_65, t59.external_id AS external_id_66, t59.folder_id AS folder_id_67, t0.hero_image_asset_id AS hero_image_asset_id_68, t0.company_id AS company_id_69, t70.id AS id_71, t70.slug AS slug_72, t70.name AS name_73, t70.zipcode AS zipcode_74, t70.city AS city_75, t70.country AS country_76, t70.contact_person AS contact_person_77, t70.contact_person_gender AS contact_person_gender_78, t70.contact_person_first_name AS contact_person_first_name_79, t70.contact_person_initials AS contact_person_initials_80, t70.contact_person_prefix AS contact_person_prefix_81, t70.contact_person_last_name AS contact_person_last_name_82, t70.phone AS phone_83, t70.extension AS extension_84, t70.mobile AS mobile_85, t70.website AS website_86, t70.email AS email_87, t70.updated_at AS updated_at_88, t70.applicant_email AS applicant_email_89, t70.description AS description_90, t70.external_id AS external_id_91, t70.canonical_url AS canonical_url_92, t70.deleted AS deleted_93, t70.openinghours AS openinghours_94, t70.accessibility AS accessibility_95, t70.credits AS credits_96, t70.video AS video_97, t70.action_date AS action_date_98, t70.action_type AS action_type_99, t70.friendly_url AS friendly_url_100, t70.province AS province_101, t70.company_information AS company_information_102, t70.multi_poster_id AS multi_poster_id_103, t70.google_cloud_name AS google_cloud_name_104, t70.featured AS featured_105, t70.department AS department_106, t70.po_number AS po_number_107, t70.invoice_company_name AS invoice_company_name_108, t70.invoice_department AS invoice_department_109, t70.invoice_contact_person AS invoice_contact_person_110, t70.invoice_email_address AS invoice_email_address_111, t70.invoice_address AS invoice_address_112, t70.invoice_zipcode AS invoice_zipcode_113, t70.invoice_city AS invoice_city_114, t70.invoice_phone AS invoice_phone_115, t70.detail_page AS detail_page_116, t70.detail_page_expiration_date AS detail_page_expiration_date_117, t70.address AS address_118, t70.latitude AS latitude_119, t70.longitude AS longitude_120, t70.meta_title AS meta_title_121, t70.meta_description AS meta_description_122, t70.utm_medium AS utm_medium_123, t70.utm_campaign AS utm_campaign_124, t70.logo_asset_id AS logo_asset_id_125, t70.hero_asset_id AS hero_asset_id_126, t70.overview_image_asset_id AS overview_image_asset_id_127, t70.fields_form_id AS fields_form_id_128, t70.hero_configuration_id AS hero_configuration_id_129, t70.company_status_id AS company_status_id_130, t70.action_assignee_id AS action_assignee_id_131, t70.consultant_id AS consultant_id_132, t70.application_process_id AS application_process_id_133, t70.gallery_id AS gallery_id_134, t70.site_id AS site_id_135, t0.recruiter_id AS recruiter_id_136, t137.first_name AS first_name_138, t137.last_name_prefix AS last_name_prefix_139, t137.last_name AS last_name_140, t137.email AS email_141, t137.phone AS phone_142, t137.linkedin_url AS linkedin_url_143, t137.intro AS intro_144, t137.description AS description_145, t137.picture_name AS picture_name_146, t137.country AS country_147, t137.id AS id_148, t137.created_at AS created_at_149, t137.updated_at AS updated_at_150, t137.robots AS robots_151, t137.external_id AS external_id_152, t137.external_reference AS external_reference_153, t137.external_hash AS external_hash_154, t0.main_icon_id AS main_icon_id_155, t0.usp_sub_title_id AS usp_sub_title_id_156, t0.description_form_id AS description_form_id_157, t0.applicant_form_id AS applicant_form_id_158, t0.custom_applicant_form_id AS custom_applicant_form_id_159, t0.invoice_id AS invoice_id_160, t0.template_id AS template_id_161, t0.company_logo_asset_id AS company_logo_asset_id_162, t163.id AS id_164, t163.file_name AS file_name_165, t163.file_size AS file_size_166, t163.file_mime_type AS file_mime_type_167, t163.meta_information AS meta_information_168, t163.updated_at AS updated_at_169, t163.external_id AS external_id_170, t163.folder_id AS folder_id_171, t0.multi_poster_id AS multi_poster_id_172, t0.primary_discipline_id AS primary_discipline_id_173, t0.secundary_discipline_id AS secundary_discipline_id_174, t0.harver_experience_id AS harver_experience_id_175, t0.application_process_id AS application_process_id_176, t0.domain_id AS domain_id_177, t0.calendar_id AS calendar_id_178, t0.gallery_id AS gallery_id_179, t180.id AS id_181, t180.name AS name_182, t180.title AS title_183, t180.intro AS intro_184, t180.context AS context_185, t180.format AS format_186, t180.enabled AS enabled_187, t180.video_embed_id AS video_embed_id_188, t0.og_image_id AS og_image_id_189, t190.id AS id_191, t190.field AS field_192, t190.text_size AS text_size_193, t190.text_color AS text_color_194, t190.text_position AS text_position_195, t190.image_id AS image_id_196, t0.site_id AS site_id_197 FROM vacancy t0 LEFT JOIN asset t59 ON t0.overview_image_asset_id = t59.id LEFT JOIN company t70 ON t0.company_id = t70.id LEFT JOIN recruiter t137 ON t0.recruiter_id = t137.id LEFT JOIN asset t163 ON t0.company_logo_asset_id = t163.id LEFT JOIN gallery t180 ON t0.gallery_id = t180.id LEFT JOIN og_image t190 ON t0.og_image_id = t190.id WHERE t0.id = 351 AND ((t0.deleted IS NULL));
1.68 ms (0.79%)	1	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
1.15 ms (0.55%)	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.`default` = ? LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query 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.`default` = ? LIMIT 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.`default` = 1 LIMIT 1;
1.06 ms (0.50%)	1	SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.file_size AS file_size_3, t0.file_mime_type AS file_mime_type_4, t0.meta_information AS meta_information_5, t0.updated_at AS updated_at_6, t0.external_id AS external_id_7, t0.folder_id AS folder_id_8 FROM asset t0 WHERE t0.id IN (?) Parameters: [`157`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.file_size AS file_size_3, t0.file_mime_type AS file_mime_type_4, t0.meta_information AS meta_information_5, t0.updated_at AS updated_at_6, t0.external_id AS external_id_7, t0.folder_id AS folder_id_8 FROM asset t0 WHERE t0.id IN (?) SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.file_size AS file_size_3, t0.file_mime_type AS file_mime_type_4, t0.meta_information AS meta_information_5, t0.updated_at AS updated_at_6, t0.external_id AS external_id_7, t0.folder_id AS folder_id_8 FROM asset t0 WHERE t0.id IN (157);
0.97 ms (0.46%)	1	SELECT v0_.id AS id_0, v0_.title AS title_1, v0_.position AS position_2 FROM vacancy_option v0_ Parameters: [] View formatted query View runnable query Explain query SELECT v0_.id AS id_0, v0_.title AS title_1, v0_.position AS position_2 FROM vacancy_option v0_ SELECT v0_.id AS id_0, v0_.title AS title_1, v0_.position AS position_2 FROM vacancy_option v0_;
0.87 ms (0.41%)	1	SELECT t0.id AS id_1, t0.fields AS fields_2, t0.type AS type_3 FROM vacancy_description_form t0 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fields AS fields_2, t0.type AS type_3 FROM vacancy_description_form t0 LIMIT 1 SELECT t0.id AS id_1, t0.fields AS fields_2, t0.type AS type_3 FROM vacancy_description_form t0 LIMIT 1;
0.76 ms (0.36%)	1	SELECT m0_.id AS id_0, m0_.title_template AS title_template_1, m0_.description_template AS description_template_2, m0_.object_class AS object_class_3, m0_.foreign_key AS foreign_key_4, m0_.date_format AS date_format_5 FROM meta_templates m0_ WHERE m0_.object_class = ? AND m0_.foreign_key IS NULL Parameters: [`"App\Entity\Vacancy"`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.title_template AS title_template_1, m0_.description_template AS description_template_2, m0_.object_class AS object_class_3, m0_.foreign_key AS foreign_key_4, m0_.date_format AS date_format_5 FROM meta_templates m0_ WHERE m0_.object_class = ? AND m0_.foreign_key IS NULL SELECT m0_.id AS id_0, m0_.title_template AS title_template_1, m0_.description_template AS description_template_2, m0_.object_class AS object_class_3, m0_.foreign_key AS foreign_key_4, m0_.date_format AS date_format_5 FROM meta_templates m0_ WHERE m0_.object_class = 'App\\Entity\\Vacancy' AND m0_.foreign_key IS NULL;

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\Feature	No errors.
App\Entity\Asset	No errors.
App\Entity\AssetFolder	No errors.
App\Entity\Company	No errors.
App\Entity\CompanyFields	No errors.
App\Entity\HeroConfiguration	No errors.
App\Entity\CompanyStatus	No errors.
FOS\UserBundle\Model\User	No errors.
App\Entity\User	No errors.
App\Entity\ApplicationProcessItemCollection	No errors.
App\Entity\Gallery	No errors.
App\Entity\Site	No errors.
App\Entity\Base	No errors.
App\Entity\ContentBase	No errors.
App\Entity\Recruiter	No errors.
App\Entity\OptionValue	No errors.
App\Entity\USP	No errors.
App\Entity\VacancyDescriptionForm	No errors.
App\Entity\ApplicantForm	No errors.
App\Entity\Invoice	No errors.
App\Entity\VacancyTemplate	No errors.
App\Entity\MultiPoster	No errors.
App\Entity\HarverExperience	No errors.
App\Entity\VacancyDomain	No errors.
App\Entity\Calendar	No errors.
App\Entity\VideoEmbed	No errors.
App\Entity\OgImage	No errors.
App\Entity\Applicant	No errors.
App\Entity\VacancyUspValue	No errors.
App\Entity\Intermediary	No errors.
App\Entity\VacancyQuestion	No errors.
App\Entity\Tag	No errors.
App\Entity\Synonym	No errors.
App\Entity\TopJob	No errors.
App\Entity\KnockoutQuestion	No errors.
App\Entity\CallMeBackRequest	No errors.
App\Entity\SiteBlock	No errors.
App\Entity\Employee	No errors.
App\Entity\ContactCompany	No errors.
App\Entity\Office	No errors.
App\Entity\Notice	No errors.
App\Entity\CompanyContactMoment	No errors.
App\Entity\Portfolio	No errors.
App\Entity\YearSlot	No errors.
App\Entity\Attribute	No errors.
App\Entity\VacancyAttribute	No errors.
App\Entity\CompanyAttribute	No errors.
App\Entity\SiteDomain	No errors.
App\Entity\ConfigurationSetting	No errors.
App\Entity\Option	No errors.
App\Entity\JobAlertSetting	No errors.
App\Entity\EventCategory	No errors.
App\Entity\Testimonial	No errors.
App\Entity\Product	No errors.
App\Entity\Route	No errors.
App\Entity\Page	No errors.
App\Entity\RedirectRoute	No errors.
App\Entity\VacancyUsp	No errors.
App\Entity\Event	No errors.
App\Entity\Location	No errors.
App\Entity\Mail	No errors.
App\Entity\MegaMenuItem	No errors.
App\Entity\ConnexysPageConfiguration	No errors.
App\Entity\MetaTemplates	No errors.
App\Entity\SiteUserData	No errors.
App\Entity\GdprStatement	No errors.

parent entity manager

No loaded entities.

Symfony Profiler

https://mbobanen.staging.03.getnoticed.nl/_fragment?_path=_format%3Dhtml%26_locale%3Dnl%26_controller%3DApp%255CController%255CPage%255CApplicantController%253A%253AformModalAction

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

default entity manager

parent entity manager