Comment visser un boulon sans accès à la tête de vis

 

Il arrive parfois que l’on doive visser un boulon sans avoir accès à l’intérieur de la pièce concernée. Voici une petite astuce pour résoudre ce problème.

L’idée est de placer la tête de vis à l’intérieur et de visser l’écrou à l’extérieur.

Il y a deux petites difficultés :

  • Comment introduire la tête de vis ?

  • Comment empêcher la vis de tourner pendant qu’on serre l’écrou ?

 

trou_serrure.png La figure ci-contre montre la forme du trou à réaliser.

On perce deux trous, l’un au diamètre de la tête de vis, l’autre au diamètre de la vis.

Les lignes droites seront découpées à la scie sauteuse si possible, sinon on peut utiliser un bout de lame de scie à métaux, une lime ou une fraise, voire un foret utilisé comme fraise.

À la limite, les trous pourront être tangents ce qui réduira la longueur des lignes droites à un stricte minimum.

 

Pour bloquer la vis en rotation pendant que l’on serre l’écrou, on a plusieurs solutions :

  • On peut utiliser une vis de type poêlier présentant un carré sous la tête. Dans ce cas , le 2em trou sera percé non pas au diamètre de la vis mais au coté du carré.

  • On peut limer 2 plats parallèles sous la tête de vis. Dans ce cas , le 2em trou sera percé non pas au diamètre de la vis, mais en-dessous, à la distance entre les 2 plats.

  • On peut faire une fente de tournevis au bout de la vis. Voir cet article.

  • Si la vis est suffisamment longue, on peut visser au dessus de l'écrou  de fixation (je raisonne sur une vis verticale avec la tête en bas) un premier écrou, passer une rondelle, visser un second écrou, bloquer très fort les deux écrous l'un sur l'autre. On peut alors maintenir l'un des 2 écrous pour empêcher la vis de tourner pendant qu'on bloque l'écrou de fixation. Pour débloquer les 2 écrous, il faut maintenir celui du bas en position et faire tourner celui du haut parce-que son mouvement tend à entraîner la vis dans le sens du serrage de l'écrou de fixation.

  • Notez que cette méthode peut aussi être utilisée pour dévisser un écrou lorsque la tête se prête mal a son blocage en rotation par un tournevis (cas des vis poêlier).

 

Un petit conseil pour terminer : Passez une rondelle d’un diamètre supérieur au gros trou dans la vis et vissez l’écrou sur quelques tours avant de mettre la vis en place,  ainsi elle ne risquera pas de tomber dans cet intérieur inatteignable.

Si le trou doit être entièrement bouché, il suffira de faire une pièce rectangulaire de faible épaisseur, percée d’un trou au diamètre de la vis ou mieux de 2 trous. Celui qui se situera au niveau du gros trou sera muni d’un court boulon avec la tête de vis à l’intérieur, qui bloquera la pièce rectangulaire en rotation pendant le vissage de l’écrou.

Si ce deuxième écrou vous gène, vous pouvez scier la vis du gros trou quelques mm sous la tête et collez cette tête à l'araldite ou à la cyanolite.

Autre méthode

On perce un trou simple au diamètre de la tête de vis.

On découpe une petite plaque carrée de coté largement supérieur au diamètre du trou.

On perce un trou au milieu de la plaque, au diamètre de la vis.

On passe la vis dans la plaque, on visse partiellement un écrou après l'avoir légèrement enduit de graisse (la graisse empêchera un collage inopiné de l'écrou).

On met de la colle sur la plaque face du dessous (coté tête de vis).

On met la plaque en place, on visse complètement l'écrou à la main. On presse la plaque.

On attend la fin du collage.

Si on dispose d'une fente

Supposons que la pièce creuse présente une fente de 6mm de large et quelques cm de long là où l'on veut placer un boulon. On peut alors procéder ainsi:

On part d'une vis poêlier de diamètre 5 ou 6.

On scie la tête suivant deux lignes parallèles de façon à ce qu'elle ait une largeur légèrement inférieure à  6mm. On peut alors l'introduire dans la fente. Avant cela on donne un trait de scie à l'extrémité de la vis suivant la direction perpendiculaire (ou parallèle) à la grande dimension de la tête. On saura ainsi quelle direction donner à la tête de vis pour qu'elle soit en travers de la fente.

teteCoupee

 

Comments (1)

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

Settings7.78MBMemory Usage298msRequest Duration
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
Joomla! Version5.4.0-alpha1
PHP Version8.3.22
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" => 1751068649 "last" => 1751068649...
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/126...
  • afterLoad (84.46KB) (4.71ms)
  • afterInitialise (1.14MB) (25.18ms)
  • afterRoute (281.13KB) (11.81ms)
  • beforeRenderComponent com_content (38.42KB) (3.28ms)
  • Before Access::preloadComponents (all components) (99.23KB) (4.62ms)
  • After Access::preloadComponents (all components) (122.51KB) (767μs)
  • Before Access::preloadPermissions (com_content) (1.66KB) (13μs)
  • After Access::preloadPermissions (com_content) (93.53KB) (530μs)
  • Before Access::getAssetRules (id:293 name:com_content.article.126) (6.65KB) (13μs)
  • After Access::getAssetRules (id:293 name:com_content.article.126) (7.56KB) (583μs)
  • Before Access::getAssetRules (id:305 name:com_comment) (1.58MB) (77.61ms)
  • After Access::getAssetRules (id:305 name:com_comment) (7.12KB) (34μs)
  • afterRenderComponent com_content (16.12KB) (9.86ms)
  • afterDispatch (2.14KB) (188μs)
  • beforeRenderRawModule mod_login (Connexion) (28.55KB) (2.01ms)
  • afterRenderRawModule mod_login (Connexion) (118.86KB) (8.08ms)
  • beforeRenderRawModule mod_tags_popular (Tags populaires) (848B) (22μs)
  • afterRenderRawModule mod_tags_popular (Tags populaires) (31.3KB) (5.65ms)
  • beforeRenderRawModule mod_breadcrumbs (Fil de navigation) (44.3KB) (806μs)
  • afterRenderRawModule mod_breadcrumbs (Fil de navigation) (13.65KB) (1.93ms)
  • beforeRenderRawModule mod_search (Recherche) (3.93KB) (1.27ms)
  • afterRenderRawModule mod_search (Recherche) (16.2KB) (1.58ms)
  • beforeRenderRawModule mod_menu (Menu principal) (1.66KB) (1.43ms)
  • afterRenderRawModule mod_menu (Menu principal) (135.53KB) (6.04ms)
  • beforeRenderModule mod_breadcrumbs (Fil de navigation) (2.06MB) (4.65ms)
  • afterRenderModule mod_breadcrumbs (Fil de navigation) (4.53KB) (866μs)
  • beforeRenderModule mod_search (Recherche) (112B) (1.26ms)
  • afterRenderModule mod_search (Recherche) (3.31KB) (162μs)
  • beforeRenderModule mod_login (Connexion) (223.64KB) (56.63ms)
  • afterRenderModule mod_login (Connexion) (10.42KB) (246μs)
  • beforeRenderModule mod_tags_popular (Tags populaires) (752B) (24μs)
  • afterRenderModule mod_tags_popular (Tags populaires) (1.76KB) (137μs)
  • beforeRenderModule mod_menu (Menu principal) (90.38KB) (14.58ms)
  • afterRenderModule mod_menu (Menu principal) (7.34KB) (366μs)
  • beforeRenderRawModule mod_menu (Menu utilisateur) (59.95KB) (16.2ms)
  • afterRenderRawModule mod_menu (Menu utilisateur) (1008B) (1.2ms)
  • beforeRenderModule mod_menu (Menu utilisateur) (720B) (8μs)
  • afterRenderModule mod_menu (Menu utilisateur) (1.66KB) (164μs)
  • afterRender (2.12MB) (32.92ms)
  • 1 x Before Access::getAssetRules (id:305 name:com_comment) (1.58MB) (26.05%)
    77.61ms
    1 x beforeRenderModule mod_login (Connexion) (223.64KB) (19.01%)
    56.63ms
    1 x afterRender (2.12MB) (11.05%)
    32.92ms
    1 x afterInitialise (1.14MB) (8.45%)
    25.18ms
    1 x beforeRenderRawModule mod_menu (Menu utilisateur) (59.95KB) (5.44%)
    16.20ms
    1 x beforeRenderModule mod_menu (Menu principal) (90.38KB) (4.89%)
    14.58ms
    1 x afterRoute (281.13KB) (3.96%)
    11.81ms
    1 x afterRenderComponent com_content (16.12KB) (3.31%)
    9.86ms
    1 x afterRenderRawModule mod_login (Connexion) (118.86KB) (2.71%)
    8.08ms
    1 x afterRenderRawModule mod_menu (Menu principal) (135.53KB) (2.03%)
    6.04ms
    1 x afterRenderRawModule mod_tags_popular (Tags populaires) (31.3KB) (1.9%)
    5.65ms
    1 x afterLoad (84.46KB) (1.58%)
    4.71ms
    1 x beforeRenderModule mod_breadcrumbs (Fil de navigation) (2.06MB) (1.56%)
    4.65ms
    1 x Before Access::preloadComponents (all components) (99.23KB) (1.55%)
    4.62ms
    1 x beforeRenderComponent com_content (38.42KB) (1.1%)
    3.28ms
    1 x beforeRenderRawModule mod_login (Connexion) (28.55KB) (0.67%)
    2.01ms
    1 x afterRenderRawModule mod_breadcrumbs (Fil de navigation) (13.65KB) (0.65%)
    1.93ms
    1 x afterRenderRawModule mod_search (Recherche) (16.2KB) (0.53%)
    1.58ms
    1 x beforeRenderRawModule mod_menu (Menu principal) (1.66KB) (0.48%)
    1.43ms
    1 x beforeRenderRawModule mod_search (Recherche) (3.93KB) (0.42%)
    1.27ms
    1 x beforeRenderModule mod_search (Recherche) (112B) (0.42%)
    1.26ms
    1 x afterRenderRawModule mod_menu (Menu utilisateur) (1008B) (0.4%)
    1.20ms
    1 x afterRenderModule mod_breadcrumbs (Fil de navigation) (4.53KB) (0.29%)
    866μs
    1 x beforeRenderRawModule mod_breadcrumbs (Fil de navigation) (44.3KB) (0.27%)
    806μs
    1 x After Access::preloadComponents (all components) (122.51KB) (0.26%)
    767μs
    1 x After Access::getAssetRules (id:293 name:com_content.article.126) (7.56KB) (0.2%)
    583μs
    1 x After Access::preloadPermissions (com_content) (93.53KB) (0.18%)
    530μs
    1 x afterRenderModule mod_menu (Menu principal) (7.34KB) (0.12%)
    366μs
    1 x afterRenderModule mod_login (Connexion) (10.42KB) (0.08%)
    246μs
    1 x afterDispatch (2.14KB) (0.06%)
    188μs
    1 x afterRenderModule mod_menu (Menu utilisateur) (1.66KB) (0.05%)
    164μs
    1 x afterRenderModule mod_search (Recherche) (3.31KB) (0.05%)
    162μs
    1 x afterRenderModule mod_tags_popular (Tags populaires) (1.76KB) (0.05%)
    137μs
    1 x After Access::getAssetRules (id:305 name:com_comment) (7.12KB) (0.01%)
    34μs
    1 x beforeRenderModule mod_tags_popular (Tags populaires) (752B) (0.01%)
    24μs
    1 x beforeRenderRawModule mod_tags_popular (Tags populaires) (848B) (0.01%)
    22μs
    1 x Before Access::getAssetRules (id:293 name:com_content.article.126) (6.65KB) (0%)
    13μs
    1 x Before Access::preloadPermissions (com_content) (1.66KB) (0%)
    13μs
    1 x beforeRenderModule mod_menu (Menu utilisateur) (720B) (0%)
    8μs
34 statements were executed, 6 of which were duplicates, 28 unique15.05ms137.23KB
  • SELECT @@SESSION.sql_mode;68μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `sn27j_session` WHERE `session_id` = ?977μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `sn27j_session` WHERE `session_id` = :session_id LIMIT 1110μ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)902μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `sn27j_viewlevels`90μ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` = :guest125μ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`351μs3.88KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `sn27j_content` WHERE `id` = :id108μ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)442μs8.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` = 0291μs4.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `sn27j_content`2.48ms1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `sn27j_content` SET `hits` = (`hits` + 1) WHERE `id` = '126'330μs48B/libraries/src/Table/Table.php:1414Copy
  • 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)268μ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`257μ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)161μ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`259μ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 ASC1.53ms6.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 DESC1.28ms2.16KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:205Copy
  • SELECT * FROM `sn27j_comment_setting` WHERE `component`='com_content'127μs704B/administrator/components/com_comment/library/config.php:85Copy
  • SELECT * FROM sn27j_comment_queue WHERE status = 0 ORDER BY created ASC LIMIT 5142μs1.27KB/components/com_comment/helpers/queue.php:40Copy
  • SELECT COUNT(*) FROM sn27j_comment WHERE contentid='126' AND component='com_content' AND published=1119μ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'114μs2.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'119μs2.36KB/libraries/compojoom/model/customfieldsconfig.php:70Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `sn27j_modules` AS `m` LEFT JOIN `sn27j_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `sn27j_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`369μs1.94KBParams/libraries/src/Cache/Controller/CallbackController.php:120Copy
  • 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`282μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias`,`catid` FROM sn27j_content WHERE `id` = :key122μ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 102.08ms1.81KBParams/modules/mod_tags_popular/src/Helper/TagsPopularHelper.php:188Copy
  • SELECT `alias`,`catid` FROM sn27j_content WHERE `id` = :key131μs1.37KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • SELECT * FROM `sn27j_schemaorg` WHERE `itemId` = :itemId AND `context` = :context145μ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)308μ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)237μ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` = 1132μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `sn27j_session` WHERE `session_id` = ?99μs3.5KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `sn27j_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?497μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy