Comment centrer un trou dans l’épaisseur d’une planche


Il arrive souvent que l’on ait besoin de percer un trou exactement au milieu de l’épaisseur d’une planche ou d’un profilé quelconque. La précision nécessaire est d’autant plus exigeante que l’épaisseur est faible. Je vous présente deux moyens de percer à l’endroit précis à tous les coups !

 

It is often necessary to drill a hole exactly in the middle of the thickness of any board or profile. The precision required is all the more demanding when the thickness is small. I present you two ways to drill in the right place every time!

Avec un foret à centrer

Le foret à centrer permet d’amorcer un perçage. C’est un outil peu utilisé par les bricoleurs et pourtant c’est un accessoire fort utile. Sa rigidité lui permet de ne pas fléchir et de percer à l’endroit précis où il se pose, sans dévier d’une petite fraction de mm.

 foret a centrer

Les dessins suivants montrent comment centrer le perçage d’un profilé de section rectangulaire.

foret a centrer

Dans le premier cas la largeur du profilé est exactement égale au diamètre du corps du foret.

Deux petites cales en contre-plaqué, par exemple (en vert sur l’image), guide le foret. Elles sont maintenues à la main si cela n’offre aucun danger (portez tout de même des gants ! On peut aussi utiliser une pince étau ou un serre-joint.

Dans le deuxième cas, le profilé à percer est un peu moins large que le diamètre du foret. On a introduit deux autres cales d’épaisseurs identiques de part et d’autre du profilé.

Dans le troisième cas, le profilé à percer est un peu plus large que le diamètre du foret. On a introduit deux autres cales d’épaisseurs identiques de part et d’autre du foret, collées sur les cales de contre-plaqué.

Une méthode plus générale

La technique du foret à centrer est surtout intéressante quand on dispose du diamètre qui va bien. Autant dire pas souvent. Voici une autre astuce qui marche à tous les coups.

pointage mi epaisseur
Le dessin (A) montre l’outil à réaliser. Il est composé de 3 pièces. La barre horizontale est posée sur les deux barres verticales. L’assemblage permet le pivotement de la barre horizontale. Le petit trou doit être parfaitement centré par rapport aux deux points de pivotement.

Le dessin (B) montre comment utiliser notre outil en l’adaptant sur l’épaisseur à percer.

Une chose sympathique est que l’erreur de centrage du petit trou est constante en valeur relative. Supposons que l’écart entre les deux pivots soit de 100 mm et que le trou soit décentré de 1mm soit 1 %. Dans le cas où l’on perce une pièce de 10 mm d’épaisseur, l’erreur sera de 1 % de 10mm soit 0,1mm.

Réalisation de l’outil

Pour réaliser l’outil, nous allons mettre en pratique le premier paragraphe.

Les trois pièces seront débitées dans du tube à section carrée de 10mm. Les longueurs ne sont pas critiques. Disons 200 mm pour les barres verticales et 100 mm pour la barre transversale.

Le foret à centrer devra avoir un diamètre de 10 mm. Utiliser des cales d’ajustement si nécessaire.

Les trous des barres verticales n’ont pas besoin d’être rigoureusement au milieu de la longueur, mais doivent être parfaitement centrés sur la largeur.

Amorcez le perçage au foret à centrer comme expliqué, puis terminez le trou au diamètre 4.

Pour la 3e barre, percez le trou central centré au foret à centrer puis terminé au diamètre 3 mm.

Il faut maintenant faire deux trous rigoureusement symétriques. Je vous propose de procéder ainsi :

Prenez une planche d’environ 20 x 20 cm. Fixer votre pièce avec une vis à bois à tête fraisée passée dans le trou central, aux environs du milieu de la planche. Fixer la planche sur le plateau d’une perceuse à colonne de telle façon que le foret à centrer tombe au milieu de l’épaisseur et à proximité d’une extrémité (mais pas trop près). Pointez votre trou avec le foret à centrer.

Maintenant, faites pivoter votre barre de 180° pour amener l’autre extrémité sous le mandrin et pointez de la même façon. Les trous seront ainsi parfaitement symétriques.

Terminez le perçage des extrémités au diamètre 4 mm.

Il reste juste à assembler les 3 pièces de telle sorte qu’elles soient plaquées les unes contre les autres mais tout en permettant leur pivotement. Différentes solutions sont envisageables. Je vous propose d’utiliser la technique du contre-écrou.

Pour ceux qui ne sauraient pas :

On met en place une vis de mécanicien (diamètre 4 mm dans notre cas ; on visse un écrou jusqu’au contact mais sans serrer ; on visse un deuxième écrou (contre-écrou) jusqu’au contact avec le premier. On prend deux clés. Celle de l’écrou est une clé à fourche ; son épaisseur doit être inférieurs à celle de l’écrou. La clé du contre écrou peut être à fourche, à œil ou à pipe. Et là, il faut faire le bon geste ! Les deux clés doivent avoir des mouvements symétriques : l’écrou va dans le sens du dévissage et le contre-écrou dans le sens du vissage. Au final, l’écrou fait du sur-place et l’assemblage garde ni plus ni moins son jeu initial.

Une version minimaliste de l'outil de centrage

On peut faire plus simple. Il suffit d'un petit bout de baguette de section carrée (ou pas) de 10 à 15 mm de coté et de deux clous tête d'homme (on peut aussi couper les têtes).

Le dessin ci-dessous explique tout. L'inconvénient est qu'on ne peut pas faire un centrage près du bord.

outil mini

 

***** © M Guignard *****

Comments (0)

    Attach images by dragging & dropping or by selecting them.
    The maximum file size for uploads is 10MB. Only gif,jpg,png files are allowed.
     
    The maximum number of 3 allowed files to upload has been reached. If you want to upload more files you have to delete one of the existing uploaded files first.
    The maximum number of 3 allowed files to upload has been reached. If you want to upload more files you have to delete one of the existing uploaded files first.
    Posting as

    Comments powered by CComment

    Settings6.936MBMemory Usage478msRequest Duration
    Theme
    Open Button Position
    Hide Empty Tabs
    Autoshow
    Reset to defaults
    Joomla! Version5.3.0
    PHP Version8.3.21
    Identityguest
    Response200
    Templatecassiopeia
    Database
    Server
    mysql
    Version
    10.11.11-MariaDB-0+deb12u1
    Collation
    utf8mb3_general_ci
    Conn Collation
    utf8mb4_general_ci
    $_GET
    []
    $_POST
    []
    $_SESSION
    array:1 [ "joomla" => "***redacted***" ]
    $_COOKIE
    []
    $_SERVER
    array:51 [ "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin" "PP_CUSTOM_P...
    session
    array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1747633495 "last" => 1747633495...
    registry
    array:3 [ "data" => [] "initialized" => false "separator" => "." ]
    user
    array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
    plg_system_webauthn
    array:1 [ "returnUrl" => "https://www.doubsastuces.fr/index.php/bricolage/astuces-de-bricoleur/59-...
    • afterLoad (85.46KB) (17.23ms)
    • afterInitialise (1.14MB) (82.12ms)
    • afterRoute (213.14KB) (24.48ms)
    • beforeRenderComponent com_content (37.91KB) (6.52ms)
    • Before Access::preloadComponents (all components) (34.52KB) (8.14ms)
    • After Access::preloadComponents (all components) (122.51KB) (1.79ms)
    • Before Access::preloadPermissions (com_content) (1.66KB) (29μs)
    • After Access::preloadPermissions (com_content) (93.53KB) (1.1ms)
    • Before Access::getAssetRules (id:145 name:com_content.article.59) (6.65KB) (24μs)
    • After Access::getAssetRules (id:145 name:com_content.article.59) (7.56KB) (1.17ms)
    • Before Access::getAssetRules (id:305 name:com_comment) (1.43MB) (188ms)
    • After Access::getAssetRules (id:305 name:com_comment) (7.12KB) (65μs)
    • afterRenderComponent com_content (14.9KB) (23.77ms)
    • afterDispatch (2.14KB) (592μs)
    • beforeRenderRawModule mod_login (Connexion) (28.02KB) (2.93ms)
    • afterRenderRawModule mod_login (Connexion) (51.98KB) (12.2ms)
    • beforeRenderRawModule mod_tags_popular (Tags populaires) (848B) (68μs)
    • afterRenderRawModule mod_tags_popular (Tags populaires) (30.28KB) (10.95ms)
    • afterRender (392.18KB) (96.32ms)
    • 1 x Before Access::getAssetRules (id:305 name:com_comment) (1.43MB) (39.24%)
      188ms
      1 x afterRender (392.18KB) (20.13%)
      96.32ms
      1 x afterInitialise (1.14MB) (17.17%)
      82.12ms
      1 x afterRoute (213.14KB) (5.12%)
      24.48ms
      1 x afterRenderComponent com_content (14.9KB) (4.97%)
      23.77ms
      1 x afterLoad (85.46KB) (3.6%)
      17.23ms
      1 x afterRenderRawModule mod_login (Connexion) (51.98KB) (2.55%)
      12.20ms
      1 x afterRenderRawModule mod_tags_popular (Tags populaires) (30.28KB) (2.29%)
      10.95ms
      1 x Before Access::preloadComponents (all components) (34.52KB) (1.7%)
      8.14ms
      1 x beforeRenderComponent com_content (37.91KB) (1.36%)
      6.52ms
      1 x beforeRenderRawModule mod_login (Connexion) (28.02KB) (0.61%)
      2.93ms
      1 x After Access::preloadComponents (all components) (122.51KB) (0.37%)
      1.79ms
      1 x After Access::getAssetRules (id:145 name:com_content.article.59) (7.56KB) (0.25%)
      1.17ms
      1 x After Access::preloadPermissions (com_content) (93.53KB) (0.23%)
      1.10ms
      1 x afterDispatch (2.14KB) (0.12%)
      592μs
      1 x beforeRenderRawModule mod_tags_popular (Tags populaires) (848B) (0.01%)
      68μs
      1 x After Access::getAssetRules (id:305 name:com_comment) (7.12KB) (0.01%)
      65μs
      1 x Before Access::preloadPermissions (com_content) (1.66KB) (0.01%)
      29μs
      1 x Before Access::getAssetRules (id:145 name:com_content.article.59) (6.65KB) (0.01%)
      24μs
    32 statements were executed, 6 of which were duplicates, 26 unique43.05ms131.42KB
    • SELECT @@SESSION.sql_mode;147μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
    • SELECT `data` FROM `sn27j_session` WHERE `session_id` = ?935μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
    • SELECT `session_id` FROM `sn27j_session` WHERE `session_id` = :session_id LIMIT 1225μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
    • INSERT INTO `sn27j_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)2.15ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
    • SELECT `id`,`rules` FROM `sn27j_viewlevels`215μs976B/libraries/src/Access/Access.php:955Copy
    • SELECT `b`.`id` FROM `sn27j_usergroups` AS `a` LEFT JOIN `sn27j_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest350μs1.33KBParams/libraries/src/Access/Access.php:868Copy
    • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `sn27j_categories` AS `s` INNER JOIN `sn27j_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`948μs3.88KBParams/libraries/src/Categories/Categories.php:375Copy
    • SELECT `alias` FROM `sn27j_content` WHERE `id` = :id360μs1.31KBParams/components/com_content/src/Service/Router.php:289Copy
    • SELECT `id`,`name`,`rules`,`parent_id` FROM `sn27j_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)1.05ms8.19KBParams/libraries/src/Access/Access.php:357Copy
    • SELECT `id`,`name`,`rules`,`parent_id` FROM `sn27j_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0566μs4.48KBParams/libraries/src/Access/Access.php:301Copy
    • SHOW FULL COLUMNS FROM `sn27j_content`6.81ms1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
    • UPDATE `sn27j_content` SET `hits` = (`hits` + 1) WHERE `id` = '59'1.22ms48B/libraries/src/Table/Table.php:1348Copy
    • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `sn27j_content` AS `a` INNER JOIN `sn27j_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `sn27j_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `sn27j_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `sn27j_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `sn27j_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)854μs22.13KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
    • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `sn27j_categories` AS `s` INNER JOIN `sn27j_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`742μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
    • SELECT `m`.`tag_id`,`t`.* FROM `sn27j_contentitem_tag_map` AS `m` INNER JOIN `sn27j_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2)502μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
    • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `sn27j_categories` AS `s` INNER JOIN `sn27j_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`795μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
    • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM sn27j_fields AS a LEFT JOIN `sn27j_languages` AS l ON l.lang_code = a.language LEFT JOIN sn27j_users AS uc ON uc.id=a.checked_out LEFT JOIN sn27j_viewlevels AS ag ON ag.id = a.access LEFT JOIN sn27j_users AS ua ON ua.id = a.created_user_id LEFT JOIN sn27j_fields_groups AS g ON g.id = a.group_id LEFT JOIN `sn27j_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2,:preparedArray3)) AND `a`.`access` IN (:preparedArray4,:preparedArray5)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC5.09ms6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
    • SELECT `a`.`id`,`a`.`title`,`a`.`catid`,`a`.`language`, CASE WHEN CHAR_LENGTH(`a`.`alias`) != 0 THEN CONCAT_WS(':', `a`.`id`, `a`.`alias`) ELSE a.id END AS `slug`, CASE WHEN CHAR_LENGTH(`cc`.`alias`) != 0 THEN CONCAT_WS(':', `cc`.`id`, `cc`.`alias`) ELSE cc.id END AS `catslug` FROM `sn27j_content` AS `a` LEFT JOIN `sn27j_categories` AS `cc` ON `cc`.`id` = `a`.`catid` WHERE `a`.`catid` = :catid AND `a`.`state` = :state AND `a`.`access` IN (:preparedArray1,:preparedArray2) AND (`publish_up` IS NULL OR `publish_up` <= :nowDate1) AND (`publish_down` IS NULL OR `publish_down` >= :nowDate2) ORDER BY CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END DESC7.15ms2.16KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:205Copy
    • SELECT * FROM `sn27j_comment_setting` WHERE `component`='com_content'381μs704B/administrator/components/com_comment/library/config.php:85Copy
    • SELECT * FROM sn27j_comment_queue WHERE status = 0 ORDER BY created ASC LIMIT 5934μs1.27KB/components/com_comment/helpers/queue.php:40Copy
    • SELECT COUNT(*) FROM sn27j_comment WHERE contentid='59' AND component='com_content' AND published=1448μs536B/components/com_comment/models/comment.php:152Copy
    • SELECT f.*, c.catid as catid FROM sn27j_compojoom_customfields as f LEFT JOIN sn27j_compojoom_customfields_cats AS c ON f.id = c.compojoom_customfields_id WHERE `f`.`show`='all' AND `f`.`enabled` = '1' AND `f`.`component` = 'com_comment'1.19ms2.39KB/libraries/compojoom/model/customfieldsconfig.php:51Copy
    • SELECT f.* FROM sn27j_compojoom_customfields AS f INNER JOIN sn27j_compojoom_customfields_cats AS c ON f.id = c.compojoom_customfields_id WHERE `f`.`show`='category' AND `c`.`catid` IN ('1') AND `f`.`enabled` = '1' AND `f`.`component` = 'com_comment'302μs2.36KB/libraries/compojoom/model/customfieldsconfig.php:70Copy
    • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `sn27j_categories` AS `s` INNER JOIN `sn27j_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`738μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
    • SELECT `alias`,`catid` FROM sn27j_content WHERE `id` = :key288μs1.37KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
    • SELECT MAX(`tag_id`) AS `tag_id`,COUNT(*) AS `count`,MAX(`t`.`title`) AS `title`,MAX(`t`.`access`) AS `access`,MAX(`t`.`alias`) AS `alias`,MAX(`t`.`params`) AS `params`,MAX(`t`.`language`) AS `language` FROM `sn27j_contentitem_tag_map` AS `m` INNER JOIN `sn27j_ucm_content` AS `ucm` ON `m`.`content_item_id` = `ucm`.`core_content_item_id` AND `m`.`type_id` = `ucm`.`core_type_id` INNER JOIN `sn27j_categories` AS `cat` ON `ucm`.`core_catid` = `cat`.`id` INNER JOIN `sn27j_tags` AS `t` ON `tag_id` = `t`.`id` INNER JOIN `sn27j_ucm_content` AS `c` ON `m`.`core_content_id` = `c`.`core_content_id` WHERE `t`.`access` IN (:preparedArray1,:preparedArray2) AND `t`.`published` = 1 AND `cat`.`published` > 0 AND `m`.`type_alias` = `c`.`core_type_alias` AND `c`.`core_state` = 1 AND (`c`.`core_access` IN (:preparedArray3,:preparedArray4) OR `c`.`core_access` = 0) AND (`c`.`core_publish_up` IS NULL OR `c`.`core_publish_up` = :nullDate2 OR `c`.`core_publish_up` <= :nowDate2) AND (`c`.`core_publish_down` IS NULL OR `c`.`core_publish_down` = :nullDate3 OR `c`.`core_publish_down` >= :nowDate3) GROUP BY `tag_id`,`t`.`title`,`t`.`access`,`t`.`alias` ORDER BY `count` DESC LIMIT 104.94ms1.81KBParams/modules/mod_tags_popular/src/Helper/TagsPopularHelper.php:188Copy
    • SELECT * FROM `sn27j_schemaorg` WHERE `itemId` = :itemId AND `context` = :context891μs1.55KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:406Copy
    • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `sn27j_content` AS `a` INNER JOIN `sn27j_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `sn27j_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `sn27j_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `sn27j_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `sn27j_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)658μs22.17KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
    • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `sn27j_content` AS `a` INNER JOIN `sn27j_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `sn27j_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `sn27j_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `sn27j_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `sn27j_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)585μs22.17KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
    • 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 `sn27j_scheduler_tasks` AS `a` WHERE `a`.`state` = 1323μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
    • SELECT `session_id` FROM `sn27j_session` WHERE `session_id` = ?258μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
    • UPDATE `sn27j_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?994μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy