Welcome to PrestaTalent, where E-commerce expertise meets limitless possibilities! Discover the perfect synergy between PrestaShop professionals and cutting-edge opportunities. Join our vibrant community and unlock the doors to your E-commerce success story today!

 

Database Administrator

Job Position
Database Administrator
Description
We're seeking an experienced Database Administrator to manage and optimize our databases. Your role will involve database design, performance tuning, and data security. Certification in database administration is a plus.
Company
DBExperts
2.54MBMemory Usage122msRequest Duration
Joomla! Version4.4.10
PHP Version8.1.31
Identityguest
Response200
Templatecassiopeia_prestatalent
Database
Server
mysql
Version
10.5.22-MariaDB-1:10.5.22+maria~ubu1804
Collation
utf8_general_ci
Conn Collation
utf8mb4_general_ci
$_GET
array:2 [ "id" => "14" "view" => "item" ]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:61 [ "USER" => "prestatalent" "HOME" => "/var/www/vhosts/prestatalent.com" "PATH_TRANSLA...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1736660355 "last" => 1736660355...
registry
array:3 [ "data" => array:1 [ "com_heptajobs" => array:1 [ "edit" => array:1 [ "...
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (540.84KB) (10.14ms)
  • afterInitialise (954.3KB) (47.9ms)
  • afterRoute (15.36KB) (6.46ms)
  • beforeRenderComponent com_heptajobs (50.31KB) (8.54ms)
  • Before Access::preloadComponents (all components) (193.09KB) (10.29ms)
  • After Access::preloadComponents (all components) (112.7KB) (1.29ms)
  • Before Access::getAssetRules (id:103 name:com_heptajobs) (2.43KB) (47μs)
  • After Access::getAssetRules (id:103 name:com_heptajobs) (8.75KB) (273μs)
  • afterRenderComponent com_heptajobs (34.55KB) (154μs)
  • afterDispatch (2.91KB) (329μs)
  • beforeRenderRawModule mod_menu (Main Menu) (225.04KB) (8.99ms)
  • afterRenderRawModule mod_menu (Main Menu) (93.9KB) (9.34ms)
  • beforeRenderRawModule mod_custom (Welcome message) (896B) (54μs)
  • afterRenderRawModule mod_custom (Welcome message) (4.51KB) (1.47ms)
  • beforeRenderRawModule mod_custom (Windows Shop) (1008B) (45μs)
  • afterRenderRawModule mod_custom (Windows Shop) (1.91KB) (620μs)
  • beforeRenderModule mod_custom (Welcome message) (4.45KB) (647μs)
  • afterRenderModule mod_custom (Welcome message) (5.24KB) (788μs)
  • beforeRenderModule mod_custom (Windows Shop) (1016B) (48μs)
  • afterRenderModule mod_custom (Windows Shop) (3.27KB) (244μs)
  • beforeRenderModule mod_menu (Main Menu) (448B) (46μs)
  • afterRenderModule mod_menu (Main Menu) (3.37KB) (421μs)
  • afterRender (36.76KB) (12.42ms)
  • 1 x afterInitialise (954.3KB) (39.39%)
    47.90ms
    1 x afterRender (36.76KB) (10.22%)
    12.42ms
    1 x Before Access::preloadComponents (all components) (193.09KB) (8.46%)
    10.29ms
    1 x afterLoad (540.84KB) (8.34%)
    10.14ms
    1 x afterRenderRawModule mod_menu (Main Menu) (93.9KB) (7.68%)
    9.34ms
    1 x beforeRenderRawModule mod_menu (Main Menu) (225.04KB) (7.39%)
    8.99ms
    1 x beforeRenderComponent com_heptajobs (50.31KB) (7.02%)
    8.54ms
    1 x afterRoute (15.36KB) (5.32%)
    6.46ms
    1 x afterRenderRawModule mod_custom (Welcome message) (4.51KB) (1.21%)
    1.47ms
    1 x After Access::preloadComponents (all components) (112.7KB) (1.06%)
    1.29ms
    1 x afterRenderModule mod_custom (Welcome message) (5.24KB) (0.65%)
    788μs
    1 x beforeRenderModule mod_custom (Welcome message) (4.45KB) (0.53%)
    647μs
    1 x afterRenderRawModule mod_custom (Windows Shop) (1.91KB) (0.51%)
    620μs
    1 x afterRenderModule mod_menu (Main Menu) (3.37KB) (0.35%)
    421μs
    1 x afterDispatch (2.91KB) (0.27%)
    329μs
    1 x After Access::getAssetRules (id:103 name:com_heptajobs) (8.75KB) (0.22%)
    273μs
    1 x afterRenderModule mod_custom (Windows Shop) (3.27KB) (0.2%)
    244μs
    1 x afterRenderComponent com_heptajobs (34.55KB) (0.13%)
    154μs
    1 x beforeRenderRawModule mod_custom (Welcome message) (896B) (0.04%)
    54μs
    1 x beforeRenderModule mod_custom (Windows Shop) (1016B) (0.04%)
    48μs
    1 x Before Access::getAssetRules (id:103 name:com_heptajobs) (2.43KB) (0.04%)
    47μs
    1 x beforeRenderModule mod_menu (Main Menu) (448B) (0.04%)
    46μs
    1 x beforeRenderRawModule mod_custom (Windows Shop) (1008B) (0.04%)
    45μs
19 statements were executed, 2 of which were duplicates, 17 unique9.82ms49.92KB
  • SELECT @@SESSION.sql_mode;149μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `k1x42_session` WHERE `session_id` = ?412μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `k1x42_session` WHERE `session_id` = :session_id LIMIT 1235μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `k1x42_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)2.32ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `k1x42_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1502μs2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `k1x42_viewlevels`251μs976B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `k1x42_usergroups` AS `a` LEFT JOIN `k1x42_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest303μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `k1x42_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`560μs3.8KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `k1x42_menu` AS `m` LEFT JOIN `k1x42_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2) ORDER BY `m`.`lft`614μs5.88KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM `k1x42_languages` WHERE `published` = 1 ORDER BY `ordering` ASC368μs2.23KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `k1x42_template_styles` AS `s` LEFT JOIN `k1x42_extensions` AS `e` ON `e`.`element` = `s`.`template` AND `e`.`type` = 'template' AND `e`.`client_id` = `s`.`client_id` WHERE `s`.`client_id` = 0 AND `e`.`enabled` = 1460μs1.14KB/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SHOW FULL COLUMNS FROM `k1x42_heptajobs_items`613μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `k1x42_heptajobs_items` WHERE `id` = '14'340μs3.75KB/libraries/src/Table/Table.php:755Copy
  • SELECT * FROM `k1x42_heptajobs_items` WHERE `id` = '14'536μs3.75KB/libraries/src/Table/Table.php:755Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `k1x42_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)552μs7.75KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `k1x42_modules` AS `m` LEFT JOIN `k1x42_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `k1x42_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id` WHERE ( ( (`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) ORDER BY `m`.`position`,`m`.`ordering`549μs2.19KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • 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 `k1x42_scheduler_tasks` AS `a` WHERE `a`.`state` = 1229μs4.18KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `k1x42_session` WHERE `session_id` = ?149μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `k1x42_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?678μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy