Commercial Specialist job at US Embassy
Website :
572 Days Ago
Linkedid Twitter Share on facebook

Vacancy title:
Commercial Specialist

[ Type: FULL TIME , Industry: Public Administration, and Government , Category: Management ]

Jobs at:

US Embassy

Deadline of this Job:
Friday, October 20 2023 

Duty Station:
Within Zambia , Lusaka, South - Central Africa

Summary
Date Posted: Saturday, October 07 2023, Base Salary: Not Disclosed

Similar Jobs in Zambia
Learn more about US Embassy
US Embassy jobs in Zambia

JOB DETAILS:
Duties
• Commercial Specialist is responsible for representing the United States Department of Commerce (USDOC), United States and Foreign Commercial Service (USFCS) in Country/Region. Serves as a professional analyst and advisor to the U.S. staff in planning, organizing, and administering programs to facilitate the marketing of U.S. goods and services. Assists U.S. firms by developing and organizing marketing strategies, including market research and reporting, planning trade promotion events, identifying, and leveraging trade opportunities, and bringing U.S. and host country business representatives together. Develops and maintains key professional and social relationships (mid-to-high levels) to exchange information and gain cooperation and knowledge on substantive trade and commercial matters. Analyzes market trends and evaluates market research involving the sectors for which responsible. Performs research and prepares highly complex factual analysis on a variety of matters affecting U.S. exports and trade in assigned industry sectors. Advises U.S. and host-country clients on each other’s regulation as they affect trade and investment opportunities. Informs host country officials and business organizations about U.S. legislation, regulation and practices pertaining to foreign investment, all with limited supervision. Develops proposed solutions U.S, companies can pursue to enter the market or advance their engagement in the market. Prepares materials and briefings designed to influence companies to pursue proposed solutions. Is responsible for developing and implementing inbound investment promotions events and activities within their sectors of responsibility. Advocates for U.S. trade interests by implementing projects, identifying appropriate actions, and resolving trade problems. Investigates trade complaints in assigned industry sectors and makes recommendations for resolution. The incumbent has responsibility for the complex and strategic industrial sectors representing high potential for U.S. exporters and that require critical advocacy and addressing complex market-access issues. Assigned industry sectors generally include complex sectors, such as (but not limited to) Aerospace, Defense, Information Technologies, Medical Equipment, Energy, Safety & Security, Automotive, Environmental Technologies, Industrial Equipment, etc. Serves as a mentor or serves as a team lead for junior staff, interns and/or contractors who could benefit from additional training and support. Shares knowledge to foster electronic engagement in support of the agency’s mission. Supervision is provided by the Regional Senior Commercial Officer/ Senior Commercial Officer/ Deputy Senior Commercial Officer/ Commercial Officer or LE Supervisory Commercial Specialist. The incumbent has full technical responsibility for assignments, based on established guidelines and works mostly independently in accomplishing the work.

Qualifications and Evaluations
Requirements:
• EXPERIENCE: Minimum four (4) years of work experience in business, government, or industry association in one or more fields of marketing, international trade, economics, trade promotions, project management, and marketing analysis/research that includes significant analysis and report writing.
• JOB KNOWLEDGE: Thorough knowledge of the host country’s economy, commercial and industrial structures, business and industry customs and practices, trade and investment laws, regulation, and policies. Comprehensive working knowledge of international trade (terms and procedures). Significant understanding of legislation, rules and regulations affecting trade and investment.
• Education Requirements:
• Bachelor’s degree in business management, economics, marketing, international trade or international affair or host country equivalent is required.

• Evaluations:
• LANGUAGE: Fluent English Speaking, Reading and Writing is required.
• SKILLS AND ABILITIES: Strong interpersonal skills, salesmanship, critical and analytical thinking, problem solving, judgement and proactively assessing obstacles and identifying solutions to ensure programmatic success is essential. Proficiency in Microsoft Office Suite (Word, Excel, Power Point, Outlook) to create documents and spreadsheets, maintain and update databases, and develop presentations. Good keyboarding skill is required.

• EQUAL EMPLOYMENT OPPORTUNITY (EEO): The U.S. Mission provides equal opportunity and fair and equitable treatment in employment to all people without regard to race, color, religion, sex, national origin, age, disability, political affiliation, marital status, or sexual orientation.
• Qualifications:
• All applicants under consideration will be required to pass medical and security certifications.
• Benefits and Other Info
• Benefits:
• Agency Benefits:
• Locally Employed Staff, including Members of Household (MOHs), and Third-Country Nationals (TCNs), working at the U.S. Mission in Lusaka, Zambia may receive a compensation package that may include health, separation, and other benefits.
• For EFMs, benefits should be discussed with the Human Resources Office.
• The pay plan is assigned at the time of the conditional offer letter by the HR Office.
• Other Information:
• HIRING PREFERENCE SELECTION PROCESS: Applicants in the following hiring preference categories are extended a hiring preference in the order listed below. Therefore, it is essential that these applicants accurately describe their status on the application. Failure to do so may result in a determination that the applicant is not eligible for a hiring preference.
• HIRING PREFERENCE ORDER:
1. AEFM / USEFM who is a preference-eligible U.S. Veteran*
2. AEFM / USEFM
3. FS on LWOP and CS with reemployment rights **
• IMPORTANT: Applicants who claim status as a preference-eligible U.S. Veteran must submit a copy of their most recent DD-214 (“Certificate of Release or Discharge from Active Duty”), Letter from Veterans’ Affairs which indicates the present existence of a service-connected disability dated within the past six months, equivalent documentation, or certification. A “certification” is any written document from the armed forces that certifies the service member is expected to be discharged or released from active duty service in the armed forces under honorable conditions within 120 days after the certification is submitted by the applicant. The certification letter should be on letterhead of the appropriate military branch of the service and contain (1) the military service dates including the expected discharge or release date; and (2) the character of service. Acceptable documentation must be submitted in order for the preference to be given.
• ** This level of preference applies to all Foreign Service employees on LWOP and CS with re-employment rights back to their agency or bureau.
• For more information (i.e., what is an EFM, USEFM, AEFM, MOH, etc.?) and for additional employment considerations, please visit the following link.

Work Hours: 8


Experience in Months: 48

Level of Education:
Bachelor Degree

Job application procedure

• All candidates must be able to obtain and hold a Public Trust – Background Investigation clearance.
• To apply for this position, click the “Submit Application” button. For more information on how to apply visit the Mission internet site.
Required Documents:
• To qualify based on education, you MUST submit the requested degree and / or transcripts as verification of educational requirement by the closing date of this announcement. Failure to provide requested information, or the information is insufficient to verify eligibility, may result in disqualification for this position.

All Applicants:
• Residency and/or Work Permit
• Degree (not transcript)
• Driver’s License
• Certificate or License

Eligible Family Member Applicants:
• Copy of Sponsor’s Orders/Assignment Notification (or equivalent)
• Passport copy
• DD-214 – Member Copy 4, Letter from Veterans’ Affairs, or other supporting documentation (if applicable)
• SF-50 (if applicable)

Next Steps:
• Applicants who are invited to take a language or skills test, or who are selected for an interview will be contacted via email.
• For further information – the complete position description listing all of the duties, responsibilities, required qualifications, etc. may be obtained by contacting the Human Resources Office.
• Thank you for your application and your interest in working at the U.S. Mission in Lusaka, Zambia.

• Interested and qualified? Click here to apply

All Jobs

QUICK ALERT SUBSCRIPTION

Job Info
Job Category: Management jobs in Zambia
Job Type: Full-time
Deadline of this Job: Friday, October 20 2023
Duty Station: Lusaka
Posted: 06-10-2023
No of Jobs: 1
Start Publishing: 06-10-2023
Stop Publishing (Put date of 2030): 06-10-2066
Apply Now

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.
60MBMemory Usage574msRequest Duration
Joomla! Version4.4.10
PHP Version8.1.32
Identityguest
Response200
Templatejl_education_pro
Database
Server
mysql
Version
10.5.28-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
array:1 [ "1deb24708f7a51ca02b447b7f6862276" => "77ed472212b3ee2a841e77167d45c38e" ]
$_SERVER
array:64 [ "USER" => "greatzambiajobs" "HOME" => "/home/greatzambiajobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 3 "timer" => array:3 [ "start" => 1746101465 "last" => 1746101469...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
jsjobcur_usr
0
jsjobconfig_dft
array:171 [ "actk" => "0" "applybuttonredirecturl" => "http://www.greatzambiajobs.com/how-to-app...
JSItemid
"190"
  • afterLoad (4.12MB) (27.56ms)
  • afterInitialise (11.13MB) (83.78ms)
  • afterRoute (5.06MB) (27.14ms)
  • beforeRenderComponent com_jsjobs (10.12KB) (220μs)
  • afterRenderComponent com_jsjobs (3.13MB) (38.98ms)
  • Before Access::preloadComponents (all components) (243.64KB) (6.69ms)
  • After Access::preloadComponents (all components) (132.72KB) (1.05ms)
  • Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (20μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (311μs)
  • beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.59MB) (111ms)
  • afterRenderRawModule mod_gantry5_particle (Career Guide) (18.25MB) (92.04ms)
  • beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (6μs)
  • afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (382μs)
  • afterDispatch (83.57KB) (153μs)
  • afterRender (13.79MB) (183ms)
  • 1 x afterRender (13.79MB) (31.95%)
    183.37ms
    1 x beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.59MB) (19.37%)
    111.18ms
    1 x afterRenderRawModule mod_gantry5_particle (Career Guide) (18.25MB) (16.04%)
    92.04ms
    1 x afterInitialise (11.13MB) (14.6%)
    83.78ms
    1 x afterRenderComponent com_jsjobs (3.13MB) (6.79%)
    38.98ms
    1 x afterLoad (4.12MB) (4.8%)
    27.56ms
    1 x afterRoute (5.06MB) (4.73%)
    27.14ms
    1 x Before Access::preloadComponents (all components) (243.64KB) (1.17%)
    6.69ms
    1 x After Access::preloadComponents (all components) (132.72KB) (0.18%)
    1.05ms
    1 x afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (0.07%)
    382μs
    1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.05%)
    311μs
    1 x beforeRenderComponent com_jsjobs (10.12KB) (0.04%)
    220μs
    1 x afterDispatch (83.57KB) (0.03%)
    153μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (0%)
    20μs
    1 x beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (0%)
    6μs
90 statements were executed, 23 of which were duplicates, 67 unique19.86ms320.23KB
  • SELECT @@SESSION.sql_mode;59μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?168μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 1132μs1.63KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • UPDATE `icop0_session` SET `guest` = :guest , `time` = :time , `userid` = :user_id , `username` = :username , `client_id` = :client_id WHERE `session_id` = :session_id113μs992BParams/libraries/src/Session/MetadataManager.php:316Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`114μs1.55KB/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `icop0_usergroups` AS `a` LEFT JOIN `icop0_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest132μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'105μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`103μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'140μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config118μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'80μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'59μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'54μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'52μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Commercial-Specialist-job-at-US-Embassy-51270%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Commercial-Specialist-job-at-US-Embassy-51270%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Commercial-Specialist-job-at-US-Embassy-51270%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC195μs4.23KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Commercial-Specialist-job-at-US-Embassy-51270%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Commercial-Specialist-job-at-US-Embassy-51270%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Commercial-Specialist-job-at-US-Embassy-51270%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC217μs4.25KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT s.id, s.template, s.home, s.title AS long_title, s.params FROM icop0_template_styles AS s WHERE s.client_id = 0 AND s.template = 'jl_education_pro' ORDER BY s.id177μs3.7KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'348μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'217μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'social'204μs1.13KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'371μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'211μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'default_login_from'65μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'visitor_can_edit_job'74μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'284μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT job.params,job.id,job.title,job.city,job.metakeywords,job.metadescription,job.description,job.created,job.isgoldjob,job.isfeaturedjob,job.gender , job.jobcategory,job.duration,job.hidesalaryrange,job.zipcode,job.iseducationminimax,job.degreetitle,job.isexperienceminimax , job.startpublishing,job.requiredtravel,job.noofjobs,job.hits,job.stoppublishing,job.video,job.prefferdskills,job.qualifications,job.agreement,job.experiencetext,job.longitude,job.latitude , cat.cat_title, subcat.title as subcategory, company.name as companyname, jobtype.title AS jobtypetitle , jobstatus.title AS jobstatustitle, shift.title as shifttitle, company.url as companywebsite, company.contactname AS companycontactname, company.contactemail AS companycontactemail,company.since AS companysince,company.logofilename AS companylogo , department.name AS departmentname, company.id companyid,job.educationminimax,job.experienceminimax , salaryfrom.rangestart AS salaryfrom, salaryto.rangestart AS salaryto, salarytype.title AS salarytype , education.title AS educationtitle ,mineducation.title AS mineducationtitle, maxeducation.title AS maxeducationtitle , experience.title AS experiencetitle ,minexperience.title AS minexperiencetitle, maxexperience.title AS maxexperiencetitle , currency.symbol,CONCAT(job.alias,'-',job.id) AS jobaliasid, agefrom.title AS agefromtitle, ageto.title AS agetotitle ,company.isgoldcompany,company.isfeaturedcompany ,CONCAT(company.alias,'-',company.id) AS companyaliasid, workpermit.name as workpermitcountry ,company.endgolddate,company.endfeatureddate, job.jobapplylink,job.joblink, careerlevel.title AS careerleveltitle ,(SELECT COUNT(id) FROM `icop0_js_job_jobapply` WHERE jobid = job.id) AS totalapply FROM `icop0_js_job_jobs` AS job JOIN `icop0_js_job_categories` AS cat ON job.jobcategory = cat.id JOIN `icop0_js_job_companies` AS company ON job.companyid = company.id JOIN `icop0_js_job_jobtypes` AS jobtype ON job.jobtype = jobtype.id LEFT JOIN `icop0_js_job_ages` AS agefrom ON agefrom.id = job.agefrom LEFT JOIN `icop0_js_job_ages` AS ageto ON ageto.id = job.ageto LEFT JOIN `icop0_js_job_subcategories` AS subcat ON job.subcategoryid = subcat.id LEFT JOIN `icop0_js_job_jobstatus` AS jobstatus ON job.jobstatus = jobstatus.id LEFT JOIN `icop0_js_job_departments` AS department ON job.departmentid = department.id LEFT JOIN `icop0_js_job_salaryrange` AS salaryfrom ON job.salaryrangefrom = salaryfrom.id LEFT JOIN `icop0_js_job_salaryrange` AS salaryto ON job.salaryrangeto = salaryto.id LEFT JOIN `icop0_js_job_salaryrangetypes` AS salarytype ON job.salaryrangetype = salarytype.id LEFT JOIN `icop0_js_job_heighesteducation` AS education ON job.educationid = education.id LEFT JOIN `icop0_js_job_heighesteducation` AS mineducation ON job.mineducationrange = mineducation.id LEFT JOIN `icop0_js_job_heighesteducation` AS maxeducation ON job.maxeducationrange = maxeducation.id LEFT JOIN `icop0_js_job_experiences` AS experience ON job.experienceid = experience.id LEFT JOIN `icop0_js_job_experiences` AS minexperience ON job.minexperiencerange = minexperience.id LEFT JOIN `icop0_js_job_experiences` AS maxexperience ON job.maxexperiencerange = maxexperience.id LEFT JOIN `icop0_js_job_shifts` AS shift ON job.shift = shift.id LEFT JOIN `icop0_js_job_currencies` AS currency ON currency.id = job.currencyid LEFT JOIN `icop0_js_job_countries` AS workpermit ON workpermit.id = job.workpermit LEFT JOIN `icop0_js_job_careerlevels` AS careerlevel ON job.careerlevel = careerlevel.id WHERE job.id = 51270689μs60.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'272μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 512702.02ms48B/components/com_jsjobs/models/job.php:1588Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'284μs992B/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering305μs4.52KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'226μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'200μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 1 ORDER BY ordering216μs15.48KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'203μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'200μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'66μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'58μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'251μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'218μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'67μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'59μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobcategory' AND fieldfor = 2174μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 2135μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'553μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield918' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'469μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'noofjobs' AND fieldfor = 2154μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 2134μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'stoppublishing' AND fieldfor = 2156μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'206μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'267μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'219μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering170μs4.27KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `icop0_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43,:preparedArray44,:preparedArray45,:preparedArray46,:preparedArray47,:preparedArray48,:preparedArray49,:preparedArray50)640μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 0106μs936B/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 22112μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2496μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2886μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 38140μs73.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 39123μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 40130μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT `a`.`menutype`,`a`.`title` FROM `icop0_menu_types` AS `a` WHERE `a`.`client_id` = 0125μs1.19KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:138Copy
  • SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id FROM icop0_menu AS m WHERE m.menutype = 'mainmenu' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0 ORDER BY m.lft429μs1.8KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id FROM icop0_menu AS m WHERE m.menutype = 'distribution-channels' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0 ORDER BY m.lft240μs1.17KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id FROM icop0_menu AS m WHERE m.menutype = 'categories-list' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0 ORDER BY m.lft517μs2.3KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT * FROM icop0_jmap_metainfo WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Commercial-Specialist-job-at-US-Embassy-51270' AND `published` = 1148μs9.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Commercial-Specialist-job-at-US-Embassy-51270'68μs960B/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration370μs4.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'130μs2.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field137μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'95μs1.2KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `icop0_scheduler_tasks` AS `a` WHERE `a`.`state` = 1198μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'195μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`299μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'77μs912B/libraries/src/Table/Table.php:755Copy
  • SELECT a.* FROM icop0_gsd a WHERE a.state = 1 AND a.plugin = 'menus' AND a.appview IN ('menus','*') ORDER BY a.id desc185μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `icop0_users`351μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_users` WHERE `id` = :userid131μs4.41KBParams/libraries/src/Table/User.php:104Copy
  • SELECT `g`.`id`,`g`.`title` FROM `icop0_usergroups` AS `g` INNER JOIN `icop0_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id` WHERE `m`.`user_id` = :muserid155μs1.68KBParams/libraries/src/Table/User.php:132Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Commercial-Specialist-job-at-US-Embassy-51270'128μs1.05KB/plugins/system/jmap/jmap.php:1135Copy
  • SELECT `original_text`, `target_text`, `original_text_regex`, `target_text_regex` FROM `icop0_jmap_text_replacements` WHERE `published` = 178μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"301μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES1.08ms8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin88μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin81μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value` FROM icop0_usergroups AS `groups`91μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'104μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'248μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 193085μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?116μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?420μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy