Describimos un proyecto interesante, aunque todavía sea del tipo analógico, pero que sirve para monitorear eventos a distancia usando una frecuencia libre de la banda de FM. El circuito emite bits intervalos cuya cadencia se altera cuando algún objeto o persona entra en el campo de actuación de su sensor.

   El circuito que describimos puede ser usado como detector de presencia, en experimentos que deban ser monitoreados a distancia o aún en demostraciones.

   Lo que tenemos es un oscilador que produce bips que son controlados por un sensor de luz.

   La señal del sensor se aplica a un transmisor de FM cuyo alcance puede llegar a 200 metros en condiciones favorables.

   Cuando algo entra en el campo de acción del sensor, cambiando la luz incidente, la frecuencia con la que se emiten los bips se cambia, lo que se puede percibir en el receptor.

   En la figura 1 tenemos el diagrama de bloques para el sistema completo.

 

 

   Figura 1 - Diagrama de bloques del sistema
   Figura 1 - Diagrama de bloques del sistema | Clique na imagem para ampliar |

 

   

El sensor utilizado es un LDR que se monta en un tubo opaco teniendo delante de sí una lente convergente, como muestra la figura 2.

 

   Figura 2- El sensor
   Figura 2- El sensor | Clique na imagem para ampliar |

 

   

Con este arreglo consigue excelente sensibilidad y directividad, con el sensor detectando la presencia incluso de pequeños objetos.

   La curva de respuesta del LDR es muy buena en relación a la intensidad de luz que recibe, como muestra la figura 3.

 

  Figura 3 - Curva del LDR
  Figura 3 - Curva del LDR | Clique na imagem para ampliar |

 

   

El LDR se utiliza para controlar un oscilador con el circuito integrado 555 que produce pulsos como se muestra en la figura 4.

 

   Figura 4 - Las señales del LDR
   Figura 4 - Las señales del LDR | Clique na imagem para ampliar |

 

   

Estas señales controlan un segundo oscilador que genera los bips sonoros usando otro 555.

   En el caso de que se produzca un cambio en el valor de la energía eléctrica,

 

   Figura 5 - La etapa transmisora
   Figura 5 - La etapa transmisora | Clique na imagem para ampliar |

 

   

La modulación es hecha por el emisor del transistor y la frecuencia determinada por el ajuste de CV y ​​la bobina.

   

 

Montaje

 

   En la figura 6 tenemos el diagrama completo del transmisor controlado por la presencia de personas u objetos.

 

   Figura 6 - Diagrama del monitor de eventos
   Figura 6 - Diagrama del monitor de eventos | Clique na imagem para ampliar |

 

   

En la figura 7 tenemos el montaje en una matriz de contactos, aunque el lector puede crear su propia placa de circuito impreso para ello.

 

 

   Figura 7 - Montaje en matriz de contactos
   Figura 7 - Montaje en matriz de contactos | Clique na imagem para ampliar |

 

  

Al realizar el montaje observe las posiciones de los circuitos integrados y de los transistores.

   También se deben observar las polaridades de los capacitores electrolíticos y del LED de monitorización.

   La conexión de un bocina para monitorear las señales de forma sonora es opcional.

   Los resistores son todos de 1/8 W con cualquier tolerancia y la bobina formada por 4 espiras de hilo 26 o 28 en forma de 1 cm de diámetro sin núcleo.

   Para el trimmer también se puede utilizar un moderno de tipo redondo, con capacidad máxima de 20 a 40 pF.

   El LDR es común redondo y la antena un pedazo fijo rígido de 20 a 60 cm de longitud.

   El ajuste de la frecuencia de emisión se realiza en CV y ​​la frecuencia del bips en P1.

   Para usar, apunte el LDR al lugar donde se desea detectar alguna variación de luz.

   Evite lugares muy claros, ya que esto puede dificultar el ajuste.

 

CI-1, CI-2 - 555 - circuitos integrados

Q1, Q2 - BC548 - transistores NPN de uso general

Q3- BF494 - transistores NPN de RF

LED - LED rojo común

L1 - Bobina - ver el texto

CV - trimmer - ver el texto

S1- Interruptor simple

B1 - 6 V - 4 pilas pequeñas

LDR - LDR redondo común

P1 - 100 k ohms - trimpot

R1, R5, R8 - 10 k ohms - resistores - marrón, negro, naranja

R2, R3 - 4k7 - resistores - amarillo, violeta, rojo

R4, R6 - 1 k ohms - resistores - marrón, negro, rojo

R7 - 15 k ohms - resistor - marrón, verde, naranja

R9 - 8k2 ohms - resistor - gris, rojo, rojo

R10 - 5k6 ohms - resistor - verde, azul, rojo

R11 - 100 ohms - marrón, negro, marrón

C1 - 22 uF - capacitor electrolítico

C2, C4 - 100 nF - 22 nF - capacitores cerámicos

C3 - 10 nF - capacitor de cerámica

C5 - 5p6 - capacitor de cerámica

Varios:

Matriz de contactos o placa de circuito impreso, soporte de pilas, caja para montaje, hilos, soldadura, etc.

 

 

18.924MBMemory Usage38.55msRequest Duration
Joomla! Version5.2.3
PHP Version8.3.20
Identityguest
Response200
Templatecassiopeia
Database
Server
mysql
Version
10.5.22-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:51 [ "USER" => "apache" "HOME" => "/usr/share/httpd" "SCRIPT_NAME" => "/index.php" "RE...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1746663034 "last" => 1746663034...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (85.39KB) (323μs)
  • afterInitialise (1.14MB) (3.61ms)
  • afterRoute (179.16KB) (869μs)
  • beforeRenderComponent com_content (100.65KB) (431μs)
  • Before Access::preloadComponents (all components) (33.45KB) (196μs)
  • After Access::preloadComponents (all components) (107.06KB) (355μs)
  • Before Access::preloadPermissions (com_content) (1.57KB) (8μs)
  • After Access::preloadPermissions (com_content) (16.22MB) (18.69ms)
  • Before Access::getAssetRules (id:27059 name:com_content.article.30697) (514.65KB) (589μs)
  • After Access::getAssetRules (id:27059 name:com_content.article.30697) (7.38KB) (32μs)
  • afterRenderComponent com_content (382.13KB) (6.03ms)
  • afterDispatch (2.25KB) (59μs)
  • beforeRenderRawModule mod_articles_category (Banco de Circuitos) (359.33KB) (1.61ms)
  • afterRenderRawModule mod_articles_category (Banco de Circuitos) (15.43KB) (318μs)
  • beforeRenderRawModule mod_finder (Busca_inteligente) (5.9KB) (97μs)
  • afterRenderRawModule mod_finder (Busca_inteligente) (129.21KB) (1.14ms)
  • beforeRenderModule mod_articles_category (Banco de Circuitos) (10.1KB) (540μs)
  • afterRenderModule mod_articles_category (Banco de Circuitos) (5.47KB) (73μs)
  • beforeRenderModule mod_finder (Busca_inteligente) (6.39KB) (184μs)
  • afterRenderModule mod_finder (Busca_inteligente) (4.44KB) (56μs)
  • afterRender (258.06KB) (3.22ms)
  • 1 x After Access::preloadPermissions (com_content) (16.22MB) (48.49%)
    18.69ms
    1 x afterRenderComponent com_content (382.13KB) (15.64%)
    6.03ms
    1 x afterInitialise (1.14MB) (9.35%)
    3.61ms
    1 x afterRender (258.06KB) (8.35%)
    3.22ms
    1 x beforeRenderRawModule mod_articles_category (Banco de Circuitos) (359.33KB) (4.18%)
    1.61ms
    1 x afterRenderRawModule mod_finder (Busca_inteligente) (129.21KB) (2.96%)
    1.14ms
    1 x afterRoute (179.16KB) (2.25%)
    869μs
    1 x Before Access::getAssetRules (id:27059 name:com_content.article.30697) (514.65KB) (1.53%)
    589μs
    1 x beforeRenderModule mod_articles_category (Banco de Circuitos) (10.1KB) (1.4%)
    540μs
    1 x beforeRenderComponent com_content (100.65KB) (1.12%)
    431μs
    1 x After Access::preloadComponents (all components) (107.06KB) (0.92%)
    355μs
    1 x afterLoad (85.39KB) (0.84%)
    323μs
    1 x afterRenderRawModule mod_articles_category (Banco de Circuitos) (15.43KB) (0.82%)
    318μs
    1 x Before Access::preloadComponents (all components) (33.45KB) (0.51%)
    196μs
    1 x beforeRenderModule mod_finder (Busca_inteligente) (6.39KB) (0.48%)
    184μs
    1 x beforeRenderRawModule mod_finder (Busca_inteligente) (5.9KB) (0.25%)
    97μs
    1 x afterRenderModule mod_articles_category (Banco de Circuitos) (5.47KB) (0.19%)
    73μs
    1 x afterDispatch (2.25KB) (0.15%)
    59μs
    1 x afterRenderModule mod_finder (Busca_inteligente) (4.44KB) (0.15%)
    56μs
    1 x After Access::getAssetRules (id:27059 name:com_content.article.30697) (7.38KB) (0.08%)
    32μs
    1 x Before Access::preloadPermissions (com_content) (1.57KB) (0.02%)
    8μs
21 statements were executed, 5 of which were duplicates, 16 unique10.98ms1.58MB
  • SELECT @@SESSION.sql_mode;31μs968B/libraries/src/Session/MetadataManager.php:184Copy
  • SELECT `session_id` FROM `incbmx_session` WHERE `session_id` = :session_id LIMIT 174μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `incbmx_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)158μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `incbmx_viewlevels`50μs656B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `incbmx_usergroups` AS `a` LEFT JOIN `incbmx_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest75μs1.64KBParams/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 `incbmx_categories` AS `s` INNER JOIN `incbmx_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`232μs20.2KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `incbmx_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)210μs7.44KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `incbmx_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 07.78ms1.48MBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `incbmx_content`340μs2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • UPDATE `incbmx_content` SET `hits` = (`hits` + 1) WHERE `id` = '30697'161μs48B/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 `incbmx_content` AS `a` INNER JOIN `incbmx_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `incbmx_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `incbmx_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `incbmx_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `incbmx_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)173μ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 `incbmx_categories` AS `s` INNER JOIN `incbmx_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`186μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `incbmx_contentitem_tag_map` AS `m` INNER JOIN `incbmx_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)221μ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 `incbmx_categories` AS `s` INNER JOIN `incbmx_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`168μ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 incbmx_fields AS a LEFT JOIN `incbmx_languages` AS l ON l.lang_code = a.language LEFT JOIN incbmx_users AS uc ON uc.id=a.checked_out LEFT JOIN incbmx_viewlevels AS ag ON ag.id = a.access LEFT JOIN incbmx_users AS ua ON ua.id = a.created_user_id LEFT JOIN incbmx_fields_groups AS g ON g.id = a.group_id LEFT JOIN `incbmx_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 ASC385μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • 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 `incbmx_categories` AS `s` INNER JOIN `incbmx_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`198μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `name`,`element` FROM `incbmx_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1153μs1.89KB/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `incbmx_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)91μs648B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • SELECT * FROM `incbmx_schemaorg` WHERE `itemId` = :itemId AND `context` = :context60μs1.55KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:403Copy
  • 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 `incbmx_content` AS `a` INNER JOIN `incbmx_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `incbmx_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `incbmx_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `incbmx_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `incbmx_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)174μ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 `incbmx_scheduler_tasks` AS `a` WHERE `a`.`state` = 162μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:465Copy