Una de las preguntas más comunes entre las empresas que invierten en marketing digital es: ¿Cómo puedo medir el retorno de inversión (ROI) de mis campañas en redes sociales? Medir el ROI es fundamental para determinar si el esfuerzo, tiempo y dinero que destinas a tus campañas está generando los resultados deseados. Sin embargo, el cálculo puede ser complicado, ya que las redes sociales no solo impulsan ventas directas, sino también la interacción, reconocimiento de marca y fidelización de clientes.
En este artículo, te explicamos de manera sencilla cómo medir el ROI de tus campañas en redes sociales y cómo asegurarte de que tu inversión esté dando frutos.
¿Qué es el ROI?El retorno de inversión (ROI) es una métrica que permite evaluar la rentabilidad de una campaña en función del dinero que se invirtió. La fórmula básica para calcularlo es:
ROI=(Ingresosgenerados−Inversioón)×100 / Inversión ROI = \frac{(Ingresos generados - Inversión) \times 100}{Inversión}ROI=Inversión(Ingresosgenerados−Inversión)×100Este cálculo proporciona un porcentaje que indica el beneficio que has obtenido en relación con lo que has gastado. Si el resultado es positivo, tu campaña fue rentable; si es negativo, significa que perdiste dinero.
La importancia de medir el ROI en redes socialesMedir el ROI en redes sociales es crucial por varias razones:
Antes de sumergirnos en los pasos para calcular el ROI, es importante entender que no todo el impacto de las redes sociales se traduce en ingresos directos. Las redes sociales generan varios tipos de valor, como:
Para calcular el ROI de una campaña, es fundamental que definas qué tipo de valor estás midiendo. En la mayoría de los casos, el ROI se mide a partir de las conversiones y las ventas, pero también puedes establecer métricas de éxito basadas en el crecimiento de seguidores, el reconocimiento de marca o el tráfico a tu sitio web.
Pasos para medir el ROI de las campañas en redes socialesA continuación, te explicamos los pasos básicos para medir el ROI de tus campañas en redes sociales.
1. Establecer objetivos clarosEl primer paso para medir el ROI es establecer objetivos concretos y medibles. Sin objetivos claros, es difícil evaluar si una campaña fue exitosa o no. Algunos ejemplos de objetivos pueden ser:
Recuerda que estos objetivos deben ser SMART (específicos, medibles, alcanzables, relevantes y con un tiempo determinado).
2. Rastrear métricas clavePara medir el ROI, debes rastrear las métricas que te ayudarán a cumplir los objetivos establecidos. Algunas de las métricas más comunes en redes sociales son:
Afortunadamente, existen varias herramientas que te ayudan a rastrear las métricas de tus campañas en redes sociales. Las más populares son:
1. Google AnalyticsGoogle Analytics es una de las herramientas más potentes para medir el rendimiento de las redes sociales. Con él, puedes rastrear el tráfico que llega a tu sitio web desde redes sociales, las conversiones generadas y el comportamiento de los usuarios en tu página. Para medir el ROI, debes configurar el seguimiento de objetivos en Google Analytics, como ventas o registros.
2. Facebook Ads ManagerSi realizas campañas pagadas en Facebook o Instagram, Facebook Ads Manager te permite ver métricas detalladas sobre el rendimiento de tus anuncios, como clics, impresiones, conversiones y costo por conversión. También te permite configurar píxeles de seguimiento, que te ayudan a rastrear el comportamiento de los usuarios después de hacer clic en tus anuncios.
3. Hootsuite o BufferHerramientas como Hootsuite y Buffer te permiten programar publicaciones y rastrear el rendimiento de tus campañas orgánicas. Puedes ver el engagement de tus publicaciones, el crecimiento de seguidores y el tráfico que generan a tu sitio web.
Calcular el ROI en ventasEl cálculo más directo del ROI proviene de las ventas generadas directamente por una campaña. Si has invertido $500 en una campaña y generaste $1,500 en ventas gracias a esa campaña, el cálculo sería:
ROI=(1500−500)×100500=200%ROI = \frac{(1500 - 500) \times 100}{500} = 200\%ROI=500(1500−500)×100=200%Esto significa que has obtenido un retorno del 200%, lo que indica que tu campaña fue altamente rentable.
Calcular el ROI en base a otros valoresNo todas las campañas de redes sociales se enfocan en generar ventas inmediatas. Algunas tienen como objetivo mejorar el reconocimiento de marca o el engagement. Para calcular el ROI en estos casos, puedes asignar un valor monetario a estos resultados. Por ejemplo, puedes calcular cuánto te costaría conseguir la misma visibilidad o interacción a través de otros medios publicitarios y compararlo con lo que has invertido en redes sociales.
Optimización del ROIMedir el ROI no es suficiente. Debes usar los datos para optimizar tus futuras campañas. Si notas que ciertos anuncios o tipos de contenido generan más conversiones o engagement, ajusta tu estrategia para centrarte en ellos. De igual forma, si una plataforma no te está dando los resultados esperados, considera reducir tu inversión en ella y probar nuevas estrategias.
ConclusiónMedir el ROI de tus campañas en redes sociales es esencial para saber si tu inversión está generando resultados. Al establecer objetivos claros, rastrear las métricas correctas y utilizar herramientas adecuadas, puedes obtener una visión precisa de cómo tus campañas impactan en tu negocio.
En codigoseo.com, te ayudamos a medir y mejorar el rendimiento de tus campañas en redes sociales. Con nuestra experiencia en marketing digital y análisis de datos, aseguramos que cada dólar que inviertes en redes sociales se traduzca en resultados medibles y significativos. ¡Contáctanos para optimizar tus campañas hoy mismo!
Al suscribirte al blog te enviaremos un correo electrónico cuando haya nuevas actualizaciones en el sitio para que no te las pierdas.
Al aceptar, accederá a un servicio proporcionado por un tercero externo a https://codigoseo.com/
Joomla! Version | 5.1.4 |
PHP Version | 8.1.32 |
Identity | guest |
Response | 200 |
Template | ja_company |
Database |
|
1 x beforeRenderModule mod_stackideas_toolbar (StackIdeas Toolbar) (18.74MB) (30.04%) | 332ms |
1 x afterInitialise (19.41MB) (19.49%) | 216ms |
1 x afterRenderRawModule mod_banners (Anuncio Google Blog) (249.44KB) (9.21%) | 102ms |
1 x afterRoute (11.65MB) (8.59%) | 95.06ms |
1 x afterRenderRawModule mod_banners (Anuncio) (95.71KB) (8.19%) | 90.60ms |
1 x afterRender (2.02MB) (4.19%) | 46.39ms |
1 x afterRenderRawModule mod_jux_weather_forecast (El Clima) (52.2KB) (3.55%) | 39.30ms |
1 x afterDispatch (75.81KB) (3.08%) | 34.11ms |
1 x afterLoad (3.53MB) (2.27%) | 25.07ms |
1 x afterRenderRawModule mod_easyblogtagcloud (Etiquetas) (424.38KB) (2.19%) | 24.23ms |
1 x afterRenderRawModule mod_easyblogcategories (Categorías) (372.71KB) (1.8%) | 19.92ms |
1 x afterRenderRawModule mod_stackideas_toolbar (StackIdeas Toolbar) (1018.94KB) (1.79%) | 19.83ms |
1 x afterRenderRawModule mod_page_qr_code (Código QR) (54.27KB) (0.94%) | 10.42ms |
1 x afterRenderRawModule mod_menu (Main Menu) (140.37KB) (0.47%) | 5.19ms |
1 x beforeRenderModule mod_footer (Footer) (510.24KB) (0.4%) | 4.40ms |
1 x afterRenderRawModule mod_djmegamenu (Enlaces de Interés) (281.3KB) (0.4%) | 4.38ms |
1 x afterRenderRawModule mod_djmegamenu (Redes Sociales) (185.33KB) (0.39%) | 4.35ms |
1 x afterRenderRawModule mod_acym (Boletín de Noticias) (379.46KB) (0.38%) | 4.15ms |
1 x afterRenderRawModule mod_djmegamenu (Otros Enlaces) (111.13KB) (0.34%) | 3.74ms |
1 x afterRenderRawModule mod_easyblogsearch (Buscar en el Blog) (78.22KB) (0.26%) | 2.89ms |
1 x afterRenderRawModule mod_easyblogmostpopularpost (+Populares) (34.55KB) (0.21%) | 2.32ms |
1 x afterRenderRawModule mod_footer (Footer) (17.71KB) (0.2%) | 2.26ms |
1 x afterRenderRawModule mod_whatsapppremium (Whatsapp Premium) (21.31KB) (0.19%) | 2.10ms |
1 x afterRenderRawModule mod_custom (Footer 3) (9.13KB) (0.16%) | 1.83ms |
1 x afterRenderRawModule mod_easyblogcalendar (Calendario de Artículos) (5.55KB) (0.12%) | 1.38ms |
1 x afterRenderModule mod_stackideas_toolbar (StackIdeas Toolbar) (197.46KB) (0.12%) | 1.34ms |
1 x Before Access::preloadComponents (all components) (160.64KB) (0.11%) | 1.23ms |
1 x After Access::preloadComponents (all components) (188.81KB) (0.09%) | 1.05ms |
1 x afterRenderComponent com_easyblog (161.48KB) (0.05%) | 549μs |
1 x beforeRenderComponent com_easyblog (12.79KB) (0.05%) | 513μs |
1 x After Access::getAssetRules (id:1 name:root.1) (27.21KB) (0.03%) | 298μs |
1 x beforeRenderModule mod_djmegamenu (Redes Sociales) (33.77KB) (0.02%) | 264μs |
1 x afterRenderModule mod_footer (Footer) (4.3KB) (0.02%) | 215μs |
1 x afterRenderModule mod_jux_weather_forecast (El Clima) (1.73KB) (0.02%) | 209μs |
1 x afterRenderModule mod_easyblogmostpopularpost (+Populares) (12.73KB) (0.02%) | 199μs |
1 x afterRenderRawModule mod_custom ([Topbar-left] Slogan) (976B) (0.02%) | 184μs |
1 x afterRenderModule mod_banners (Anuncio Google Blog) (1.77KB) (0.02%) | 177μs |
1 x afterRenderModule mod_easyblogcategories (Categorías) (1.77KB) (0.02%) | 169μs |
1 x afterRenderModule mod_page_qr_code (Código QR) (5.77KB) (0.02%) | 167μs |
1 x afterRenderModule mod_easyblogtagcloud (Etiquetas) (1.77KB) (0.01%) | 163μs |
1 x afterRenderModule mod_custom (Footer 3) (1.91KB) (0.01%) | 160μs |
1 x afterRenderModule mod_djmegamenu (Redes Sociales) (2.02KB) (0.01%) | 159μs |
1 x afterRenderModule mod_menu (Main Menu) (1.97KB) (0.01%) | 159μs |
1 x afterRenderRawModule mod_custom (Acceso Clientes) (1008B) (0.01%) | 159μs |
1 x afterRenderModule mod_easyblogcalendar (Calendario de Artículos) (2.03KB) (0.01%) | 156μs |
1 x afterRenderModule mod_easyblogsearch (Buscar en el Blog) (1.91KB) (0.01%) | 155μs |
1 x afterRenderModule mod_whatsapppremium (Whatsapp Premium) (1.74KB) (0.01%) | 148μs |
1 x afterRenderRawModule mod_custom (Footer logo) (976B) (0.01%) | 137μs |
1 x afterRenderModule mod_acym (Boletín de Noticias) (1.77KB) (0.01%) | 136μs |
1 x afterRenderModule mod_djmegamenu (Enlaces de Interés) (1.77KB) (0.01%) | 134μs |
1 x afterRenderModule mod_djmegamenu (Otros Enlaces) (4.27KB) (0.01%) | 133μs |
1 x afterRenderModule mod_banners (Anuncio) (1.71KB) (0.01%) | 130μs |
1 x beforeRenderModule mod_custom ([Topbar-left] Slogan) (3.07KB) (0.01%) | 120μs |
1 x afterRenderModule mod_custom (Footer logo) (1.89KB) (0.01%) | 117μs |
1 x beforeRenderModule mod_djmegamenu (Otros Enlaces) (23.52KB) (0.01%) | 113μs |
1 x afterRenderModule mod_custom ([Topbar-left] Slogan) (1.73KB) (0.01%) | 113μs |
1 x afterRenderModule mod_custom (Acceso Clientes) (1.73KB) (0.01%) | 111μs |
1 x beforeRenderModule mod_djmegamenu (Enlaces de Interés) (200B) (0.01%) | 92μs |
1 x beforeRenderModule mod_menu (Main Menu) (4.11KB) (0.01%) | 86μs |
1 x beforeRenderModule mod_jux_weather_forecast (El Clima) (1.59KB) (0.01%) | 81μs |
1 x beforeRenderModule mod_custom (Acceso Clientes) (3.46KB) (0.01%) | 79μs |
1 x beforeRenderModule mod_banners (Anuncio) (1016B) (0.01%) | 78μs |
1 x beforeRenderModule mod_page_qr_code (Código QR) (2.4KB) (0.01%) | 76μs |
1 x beforeRenderModule mod_custom (Footer logo) (23.59KB) (0.01%) | 73μs |
1 x beforeRenderModule mod_easyblogsearch (Buscar en el Blog) (968B) (0.01%) | 61μs |
1 x beforeRenderModule mod_easyblogmostpopularpost (+Populares) (6.39KB) (0%) | 42μs |
1 x beforeRenderModule mod_banners (Anuncio Google Blog) (13.38KB) (0%) | 38μs |
1 x beforeRenderModule mod_whatsapppremium (Whatsapp Premium) (6.48KB) (0%) | 38μs |
1 x beforeRenderModule mod_custom (Footer 3) (23.95KB) (0%) | 31μs |
1 x beforeRenderModule mod_acym (Boletín de Noticias) (4.94KB) (0%) | 31μs |
1 x beforeRenderModule mod_easyblogtagcloud (Etiquetas) (5.05KB) (0%) | 31μs |
1 x beforeRenderModule mod_easyblogcalendar (Calendario de Artículos) (3.41KB) (0%) | 28μs |
1 x beforeRenderModule mod_easyblogcategories (Categorías) (656B) (0%) | 27μs |
1 x Before Access::getAssetRules (id:1 name:root.1) (4.04KB) (0%) | 21μs |
1 x beforeRenderModule mod_jux_weather_forecast (El Clima) (720B) (0%) | 13μs |
1 x beforeRenderModule mod_stackideas_toolbar (StackIdeas Toolbar) (736B) (0%) | 11μs |
1 x beforeRenderModule mod_whatsapppremium (Whatsapp Premium) (736B) (0%) | 11μs |
1 x beforeRenderModule mod_footer (Footer) (704B) (0%) | 10μs |
1 x beforeRenderModule mod_custom (Footer 3) (720B) (0%) | 10μs |
1 x beforeRenderModule mod_page_qr_code (Código QR) (720B) (0%) | 10μs |
1 x beforeRenderModule mod_easyblogsearch (Buscar en el Blog) (736B) (0%) | 10μs |
1 x beforeRenderModule mod_easyblogcategories (Categorías) (720B) (0%) | 10μs |
1 x beforeRenderModule mod_banners (Anuncio Google Blog) (704B) (0%) | 10μs |
1 x beforeRenderModule mod_easyblogmostpopularpost (+Populares) (736B) (0%) | 10μs |
1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%) | 10μs |
1 x beforeRenderModule mod_easyblogtagcloud (Etiquetas) (720B) (0%) | 10μs |
1 x beforeRenderModule mod_banners (Anuncio) (704B) (0%) | 9μs |
1 x beforeRenderModule mod_easyblogcalendar (Calendario de Artículos) (736B) (0%) | 9μs |
1 x beforeRenderModule mod_djmegamenu (Redes Sociales) (720B) (0%) | 8μs |
1 x beforeRenderModule mod_djmegamenu (Otros Enlaces) (720B) (0%) | 7μs |
1 x beforeRenderModule mod_djmegamenu (Enlaces de Interés) (720B) (0%) | 7μs |
1 x beforeRenderModule mod_acym (Boletín de Noticias) (720B) (0%) | 7μs |
1 x beforeRenderModule mod_custom (Acceso Clientes) (720B) (0%) | 6μs |
1 x beforeRenderModule mod_custom ([Topbar-left] Slogan) (720B) (0%) | 6μs |
1 x beforeRenderModule mod_custom (Footer logo) (720B) (0%) | 5μs |
SELECT @@SESSION.sql_mode;
73μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308CopySELECT `data`
FROM `eua3m_session`
WHERE `session_id` = ?
131μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250CopySELECT `session_id`
FROM `eua3m_session`
WHERE `session_id` = :session_id LIMIT 1
94μs1.61KBParams/libraries/src/Session/MetadataManager.php:187CopyINSERT INTO `eua3m_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)
83.16ms944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `eua3m_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
360μs34.48KB/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `eua3m_viewlevels`
100μs976B/libraries/src/Access/Access.php:955CopySELECT `b`.`id`
FROM `eua3m_usergroups` AS `a`
LEFT JOIN `eua3m_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `a`.`id` = :guest
190μs1.64KBParams/libraries/src/Access/Access.php:868CopySELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM `eua3m_extensions`
WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2)
ORDER BY `ordering`
1.07ms60.8KBParams/libraries/src/Plugin/PluginHelper.php:294CopySELECT `template`
FROM `eua3m_template_styles`
WHERE `client_id` = 0 AND `home` = 1
222μs2.09KB/components/com_sppagebuilder/parser/addon-parser.php:1335CopySELECT *
FROM `eua3m_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC
218μs2.22KB/libraries/src/Language/LanguageHelper.php:177CopySELECT params FROM eua3m_extensions WHERE element = 'cookiespolicynotificationbar' AND folder = 'system'
173μs16.84KB/plugins/system/cookiespolicynotificationbar/cookiespolicynotificationbar.php:217CopySELECT `enabled`
FROM `eua3m_extensions`
WHERE `type` = 'plugin' AND `element` = 'cache' AND `folder` = 'system'
127μs856B/plugins/system/cookiespolicynotificationbar/cookiespolicynotificationbar.php:2618CopySELECT *
FROM eua3m_rsform_config
172μs1.5KB/administrator/components/com_rsform/helpers/config.php:52CopySELECT `template`
FROM `eua3m_template_styles`
WHERE `client_id` = 0 AND `home` = 1
159μs856B/plugins/system/helix3/helix3.php:247CopySELECT `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 `eua3m_menu` AS `m`
LEFT JOIN `eua3m_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`
552μs53.05KBParams/libraries/src/Menu/SiteMenu.php:166CopySELECT *
FROM `eua3m_easyblog_configs`
WHERE `name` = 'config'
194μs64.89KB/libraries/src/Table/Table.php:780CopySELECT * FROM `eua3m_easyblog_acl` WHERE `published`='1' ORDER BY `id` ASC
335μs4.55KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT * FROM `eua3m_easyblog_acl_group` WHERE `content_id` IN (1, 9) AND `type`='group'
401μs2.8KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT `id` FROM `eua3m_easyblog_post` WHERE `permalink`='como-medir-el-roi-de-las-campanas-en-redes-sociales'
181μs856B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT *
FROM `eua3m_easyblog_post`
WHERE `id` = '104'
281μs143.84KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_revisions`
WHERE `id` = '116'
165μs153.91KB/libraries/src/Table/Table.php:780CopySELECT COUNT(1) FROM `eua3m_easyblog_featured` WHERE `content_id`='104' AND `type`='post'
202μs856B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT * FROM `eua3m_easyblog_meta` WHERE `type`='post' AND `content_id`='104'
151μs1.22KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent`
FROM `eua3m_template_styles` AS `s`
LEFT JOIN `eua3m_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` = 1
214μs1.14KB/administrator/components/com_templates/src/Model/StyleModel.php:775CopySELECT DISTINCT a.*
FROM `eua3m_ampz` AS a LIMIT 20
129μs960B/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySHOW FULL TABLES WHERE table_type="BASE TABLE"
2.16ms8.88KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:635CopySELECT * FROM eua3m_acym_configuration
204μs2.88KB/administrator/components/com_acym/libraries/joomla/database.php:30CopySELECT * FROM eua3m_acym_plugin
93μs2.11KB/administrator/components/com_acym/libraries/joomla/database.php:30CopySELECT * FROM eua3m_acym_plugin WHERE folder_name = 'acychecker' LIMIT 1
118μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM eua3m_acym_plugin WHERE folder_name = 'acymailer' LIMIT 1
112μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM eua3m_acym_plugin WHERE folder_name = 'amazon' LIMIT 1
97μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM eua3m_acym_plugin WHERE folder_name = 'article' LIMIT 1
111μs2.09KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM eua3m_acym_plugin WHERE folder_name = 'birthday' LIMIT 1
111μs13.08KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM eua3m_acym_plugin WHERE folder_name = 'brevo' LIMIT 1
95μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM eua3m_acym_plugin WHERE folder_name = 'createuser' LIMIT 1
112μs2.09KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value`
FROM eua3m_usergroups AS `groups`
83μs1.33KB/administrator/components/com_acym/libraries/joomla/database.php:30CopySELECT * FROM eua3m_acym_plugin WHERE folder_name = 'elasticemail' LIMIT 1
133μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM eua3m_acym_plugin WHERE folder_name = 'forward' LIMIT 1
123μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM eua3m_acym_plugin WHERE folder_name = 'mailgun' LIMIT 1
123μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM eua3m_acym_plugin WHERE folder_name = 'module' LIMIT 1
133μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM eua3m_acym_plugin WHERE folder_name = 'online' LIMIT 1
122μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM eua3m_acym_plugin WHERE folder_name = 'override' LIMIT 1
132μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM eua3m_acym_plugin WHERE folder_name = 'phpmail' LIMIT 1
120μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM eua3m_acym_plugin WHERE folder_name = 'postmark' LIMIT 1
135μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM eua3m_acym_plugin WHERE folder_name = 'qmail' LIMIT 1
120μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM eua3m_acym_plugin WHERE folder_name = 'segment' LIMIT 1
122μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM eua3m_acym_plugin WHERE folder_name = 'sendgrid' LIMIT 1
122μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM eua3m_acym_plugin WHERE folder_name = 'sendinblue' LIMIT 1
132μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM eua3m_acym_plugin WHERE folder_name = 'luecredentials' LIMIT 1
145μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM eua3m_acym_plugin WHERE folder_name = 'lueintegration' LIMIT 1
119μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM eua3m_acym_plugin WHERE folder_name = 'luetransactional' LIMIT 1
116μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM eua3m_acym_plugin WHERE folder_name = 'luelist' LIMIT 1
114μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM eua3m_acym_plugin WHERE folder_name = 'lueusers' LIMIT 1
123μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM eua3m_acym_plugin WHERE folder_name = 'luesender' LIMIT 1
113μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM eua3m_acym_plugin WHERE folder_name = 'luecampaign' LIMIT 1
111μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM eua3m_acym_plugin WHERE folder_name = 'luewebhooks' LIMIT 1
111μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM eua3m_acym_plugin WHERE folder_name = 'sendmail' LIMIT 1
117μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM eua3m_acym_plugin WHERE folder_name = 'smtp' LIMIT 1
122μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM eua3m_acym_plugin WHERE folder_name = 'statistics' LIMIT 1
122μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM eua3m_acym_plugin WHERE folder_name = 'subscriber' LIMIT 1
124μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM eua3m_acym_plugin WHERE folder_name = 'subscription' LIMIT 1
126μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM eua3m_acym_plugin WHERE folder_name = 'time' LIMIT 1
123μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM eua3m_acym_plugin WHERE folder_name = 'user' LIMIT 1
135μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM eua3m_acym_plugin WHERE folder_name = 'managetext' LIMIT 1
123μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `eua3m_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,:preparedArray51,:preparedArray52,:preparedArray53)
643μs16.25KBParams/libraries/src/Access/Access.php:357CopyDELETE FROM `eua3m_easyblog_mailq` WHERE `status`='1' AND DATEDIFF(NOW(), `created`) >='7'
121μs0B/administrator/components/com_easyblog/includes/utils.php:166CopySELECT `id` FROM `eua3m_easyblog_mailq` WHERE `status`='0' ORDER BY `id` ASC LIMIT 20
136μs840B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT * FROM `eua3m_easyblog_post` WHERE `publish_up`<='2025-04-09 13:58:38' AND `published`='2' AND `state`='0' ORDER BY `id` LIMIT 1
337μs7.83KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT id, created_by FROM`eua3m_easyblog_post` WHERE `publish_down` > `publish_up` AND `publish_down` <= '2025-04-09 13:58:38' AND `publish_down` != '0000-00-00 00:00:00' AND `published` = '1' AND `state` = '0'
210μs896B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT * FROM `eua3m_easyblog_uploader_tmp` WHERE `created` <= DATE_SUB('2025-04-09 13:58:38' , INTERVAL 120 MINUTE)
128μs1.17KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT a.`id` FROM `eua3m_easyblog_post` as a inner join `eua3m_easyblog_revisions` as b on a.`id` = b.`post_id` where a.`published` = '9' and a.`created` <= DATE_SUB('2025-04-09 13:58:38', INTERVAL 3 DAY)
177μs840B/administrator/components/com_easyblog/includes/utils.php:298CopyDELETE a, b FROM `eua3m_easyblog_post` as a inner join `eua3m_easyblog_revisions` as b on a.`id` = b.`post_id` where a.`published` = '9' and a.`created` <= DATE_SUB('2025-04-09 13:58:38', INTERVAL 3 DAY)
184μs0B/administrator/components/com_easyblog/includes/utils.php:166CopySELECT * FROM `eua3m_menu` WHERE `published`='1' AND `link` LIKE 'index.php?option=com_easyblog%' AND `client_id` = '0' ORDER BY `id`
337μs4.09KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT *
FROM `eua3m_easyblog_post`
WHERE `id` = '104'
293μs143.84KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_revisions`
WHERE `id` = '116'
169μs153.91KB/libraries/src/Table/Table.php:780CopySELECT * FROM `eua3m_easyblog_meta` WHERE `type`='post' AND `content_id`='104'
177μs1.22KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT COUNT(1) as `voted`, `uid` FROM `eua3m_easyblog_ratings` WHERE `uid` = '104' AND `type`='entry' AND `created_by`='0' AND (`sessionid` = '07dc7687aaec6d28778d96006ffb8739' OR `ip` = '3.133.130.103') GROUP BY `uid` ORDER BY NULL
182μs896B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid` FROM `eua3m_easyblog_ratings` AS a WHERE a.`uid` IN(104) AND `type`='entry' GROUP BY `uid` ORDER BY NULL
141μs960B/administrator/components/com_easyblog/includes/utils.php:298Copyselect a.*, b.`post_id`, b.`primary` from `eua3m_easyblog_category` as a inner join `eua3m_easyblog_post_category` as b on a.`id` = b.`category_id` where b.`post_id` IN (104) order by a.`lft` asc
274μs4.03KB/administrator/components/com_easyblog/includes/utils.php:298Copyselect a.*, b.`post_id` from `eua3m_easyblog_tag` as a inner join `eua3m_easyblog_post_tag` as b on a.`id` = b.`tag_id` where b.`post_id` IN (104)
191μs2.13KB/administrator/components/com_easyblog/includes/utils.php:298Copyselect a.* from `eua3m_easyblog_revisions` as a where a.`id` IN ( 116)
202μs153.91KB/administrator/components/com_easyblog/includes/utils.php:298Copyselect u.*, e.`id` as `eb_id`, e.`nickname`, e.`avatar`, e.`description`, e.`url`, e.`params` as `eb_params`, e.`published` as `eb_published`, e.`title` as `eb_title`, e.`biography`, e.`permalink`, e.`custom_css`, e.`ordering` from `eua3m_users` as u left join `eua3m_easyblog_users` as e ON u.`id` = e.`id` where u.`id` = 42
178μs4.31KB/administrator/components/com_easyblog/includes/utils.php:298CopySHOW FULL COLUMNS FROM `eua3m_users`
716μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySELECT *
FROM `eua3m_users`
WHERE `id` = :userid
155μs4.41KBParams/libraries/src/Table/User.php:106CopySELECT `g`.`id`,`g`.`title`
FROM `eua3m_usergroups` AS `g`
INNER JOIN `eua3m_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id`
WHERE `m`.`user_id` = :muserid
214μs1.68KBParams/libraries/src/Table/User.php:134Copyselect `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `f`.`ordering` as `f_ordering`,`fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value` from `eua3m_easyblog_category_fields_groups` as a inner join `eua3m_easyblog_post_category` as p on `a`.`category_id` = `p`.`category_id` inner join `eua3m_easyblog_fields_groups` as fg on `a`.`group_id` = `fg`.`id` inner join `eua3m_easyblog_fields` as f on `fg`.`id` = `f`.`group_id` left join `eua3m_easyblog_fields_values` as fv on `fv`.`field_id` = `f`.`id` and `fv`.`post_id` = `p`.`post_id` LEFT JOIN `eua3m_easyblog_fields_groups_acl` AS acl ON fg.`id` = acl.`group_id` where `p`.`post_id` = '104' AND ( acl.`acl_id` IN(9) AND acl.`acl_type` = 'read' OR acl.`id` IS NULL )
337μs4.08KB/administrator/components/com_easyblog/includes/utils.php:298Copyselect * from `eua3m_easyblog_meta` where `content_id` in (104) and `type` = 'post'
164μs1.22KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT *
FROM `eua3m_easyblog_meta`
WHERE `content_id` = '104' AND `type` = 'post'
151μs1.22KB/libraries/src/Table/Table.php:780CopySELECT enabled
FROM `eua3m_extensions`
WHERE `element` = 'com_sppagebuilder' AND `type` = 'component'
233μs856B/plugins/content/sppagebuilder/sppagebuilder.php:306CopySELECT 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 eua3m_fields AS a
LEFT JOIN `eua3m_languages` AS l ON l.lang_code = a.language
LEFT JOIN eua3m_users AS uc ON uc.id=a.checked_out
LEFT JOIN eua3m_viewlevels AS ag ON ag.id = a.access
LEFT JOIN eua3m_users AS ua ON ua.id = a.created_user_id
LEFT JOIN eua3m_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `eua3m_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)) AND `a`.`access` IN (:preparedArray3,:preparedArray4)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5,:preparedArray6)) 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 ASC
446μs6KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT t.*
FROM eua3m_seoglossary as t
LEFT JOIN eua3m_seoglossaries g ON t.catid = g.id
WHERE t.state = 1 AND g.state = 1 AND ((LOWER('Una de las preguntas más comunes entre las empresas que invierten en marketing digital es: ¿Cómo puedo medir el retorno de inversión (ROI) de mis campañas en redes sociales? Medir el ROI es fundamental para determinar si el esfuerzo, tiempo y dinero que destinas a tus campañas está generando los resultados deseados. Sin embargo, el cálculo puede se...\n') LIKE CONCAT('%', LOWER(t.tterm), '%')) OR (LOWER('Una de las preguntas más comunes entre las empresas que invierten en marketing digital es: ¿Cómo puedo medir el retorno de inversión (ROI) de mis campañas en redes sociales? Medir el ROI es fundamental para determinar si el esfuerzo, tiempo y dinero que destinas a tus campañas está generando los resultados deseados. Sin embargo, el cálculo puede se...\n') LIKE CONCAT('%', LOWER(t.tsynonyms), '%'))) AND g.language IN ('es-ES','*') AND (t.publish_up = '0000-00-00 00:00:00' OR t.publish_up <= '2025-04-09 13:58:38') AND ((t.publish_down = '0000-00-00 00:00:00' OR t.publish_down >= '2025-04-09 13:58:38')) AND NOT FIND_IN_SET('easyblog.blog',g.disable_context) AND NOT FIND_IN_SET(440,g.disable_menu) AND NOT FIND_IN_SET('easyblog',g.disable_component)
ORDER BY t.ordering
317μs4.27KB/plugins/content/seoglossary/seoglossary.php:184CopyUPDATE `eua3m_easyblog_post`
SET `hits` = (`hits` + 1)
WHERE `id` = '104'
79.13ms48B/libraries/src/Table/Table.php:1348CopySELECT `key`,`value` FROM `eua3m_easyblog_post_assets` WHERE `post_id`='104'
171μs848B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT COUNT(1) FROM `eua3m_easyblog_feeds_history` WHERE `post_id`='104'
133μs856B/administrator/components/com_easyblog/includes/utils.php:298Copyselect `id` FROM `eua3m_easyblog_adsense` where user_id = '42'
133μs856B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT *
FROM `eua3m_easyblog_adsense`
WHERE `id` = '1'
116μs1.06KB/libraries/src/Table/Table.php:780CopySELECT `id` FROM `eua3m_menu` WHERE ( `link` LIKE 'index.php?option=com_easyblog&view=entry&id=104%' OR `link` LIKE 'index.php?option=com_easyblog&view=entry&id=104%' ) AND `published`='1' AND (`language`='es-ES' OR `language`='' OR `language`='*') LIMIT 1
700μs840B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT a.`id`, a.`title` FROM `eua3m_easyblog_post` AS `a` INNER JOIN `eua3m_users` AS uu ON a.`created_by` = uu.`id` and uu.`block` = 0 WHERE a.`published` = '1' AND a.`state` = '0' AND a.`access`='0' AND ( NOT EXISTS ( select acp.post_id from `eua3m_easyblog_post_category` as acp inner join `eua3m_easyblog_category` as cat on acp.`category_id` = cat.`id` where acp.`post_id` = a.`id` and ( ( cat.`private` = 1 and (0 = 0) ) OR ( cat.`private` = 2 and (select count(1) from `eua3m_easyblog_category_acl` as cacl where cacl.`category_id` = cat.`id` and cacl.`acl_id` = 1 and cacl.`content_id` IN (9)) = 0 ) ))) AND a.`source_type`='easyblog.sitewide' AND a.`id` NOT IN(104) AND a.`created` < '2024-09-20 22:40:25' ORDER BY a.`created` DESC LIMIT 1
1.64ms912B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT a.`id`, a.`title` FROM `eua3m_easyblog_post` AS `a` INNER JOIN `eua3m_users` AS uu ON a.`created_by` = uu.`id` and uu.`block` = 0 WHERE a.`published` = '1' AND a.`state` = '0' AND a.`access`='0' AND ( NOT EXISTS ( select acp.post_id from `eua3m_easyblog_post_category` as acp inner join `eua3m_easyblog_category` as cat on acp.`category_id` = cat.`id` where acp.`post_id` = a.`id` and ( ( cat.`private` = 1 and (0 = 0) ) OR ( cat.`private` = 2 and (select count(1) from `eua3m_easyblog_category_acl` as cacl where cacl.`category_id` = cat.`id` and cacl.`acl_id` = 1 and cacl.`content_id` IN (9)) = 0 ) ))) AND a.`source_type`='easyblog.sitewide' AND a.`id` NOT IN(104) AND a.`created` > '2024-09-20 22:40:25' ORDER BY a.`created` ASC LIMIT 1
1.86ms912B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT *
FROM `eua3m_easyblog_post`
WHERE `id` = '103'
264μs87.84KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_revisions`
WHERE `id` = '114'
154μs89.91KB/libraries/src/Table/Table.php:780CopySELECT COUNT(1) FROM `eua3m_easyblog_featured` WHERE `content_id`='103' AND `type`='post'
140μs856B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT * FROM `eua3m_easyblog_meta` WHERE `type`='post' AND `content_id`='103'
154μs1.22KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT *
FROM `eua3m_easyblog_post`
WHERE `id` = '105'
240μs87.84KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_revisions`
WHERE `id` = '117'
179μs89.91KB/libraries/src/Table/Table.php:780CopySELECT COUNT(1) FROM `eua3m_easyblog_featured` WHERE `content_id`='105' AND `type`='post'
135μs856B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT * FROM `eua3m_easyblog_meta` WHERE `type`='post' AND `content_id`='105'
153μs1.22KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT COUNT(1) as `voted`, `uid` FROM `eua3m_easyblog_ratings` WHERE `uid` IN (103,105) AND `type`='entry' AND `created_by`='0' AND (`sessionid` = '07dc7687aaec6d28778d96006ffb8739' OR `ip` = '3.133.130.103') GROUP BY `uid` ORDER BY NULL
219μs896B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid` FROM `eua3m_easyblog_ratings` AS a WHERE a.`uid` IN(103,105) AND `type`='entry' GROUP BY `uid` ORDER BY NULL
162μs960B/administrator/components/com_easyblog/includes/utils.php:298Copyselect a.*, b.`post_id`, b.`primary` from `eua3m_easyblog_category` as a inner join `eua3m_easyblog_post_category` as b on a.`id` = b.`category_id` where b.`post_id` IN (103,105) order by a.`lft` asc
270μs4.05KB/administrator/components/com_easyblog/includes/utils.php:298Copyselect a.*, b.`post_id` from `eua3m_easyblog_tag` as a inner join `eua3m_easyblog_post_tag` as b on a.`id` = b.`tag_id` where b.`post_id` IN (103,105)
202μs2.17KB/administrator/components/com_easyblog/includes/utils.php:298Copyselect a.* from `eua3m_easyblog_revisions` as a where a.`id` IN ( 114,117)
193μs89.92KB/administrator/components/com_easyblog/includes/utils.php:298Copyselect `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `f`.`ordering` as `f_ordering`,`fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value` from `eua3m_easyblog_category_fields_groups` as a inner join `eua3m_easyblog_post_category` as p on `a`.`category_id` = `p`.`category_id` inner join `eua3m_easyblog_fields_groups` as fg on `a`.`group_id` = `fg`.`id` inner join `eua3m_easyblog_fields` as f on `fg`.`id` = `f`.`group_id` left join `eua3m_easyblog_fields_values` as fv on `fv`.`field_id` = `f`.`id` and `fv`.`post_id` = `p`.`post_id` LEFT JOIN `eua3m_easyblog_fields_groups_acl` AS acl ON fg.`id` = acl.`group_id` where p.post_id IN (103,105) AND ( acl.`acl_id` IN(9) AND acl.`acl_type` = 'read' OR acl.`id` IS NULL )
453μs4.08KB/administrator/components/com_easyblog/includes/utils.php:298Copyselect * from `eua3m_easyblog_meta` where `content_id` in (103,105) and `type` = 'post'
169μs1.23KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT t.*
FROM eua3m_seoglossary as t
LEFT JOIN eua3m_seoglossaries g ON t.catid = g.id
WHERE t.state = 1 AND g.state = 1 AND ((LOWER('\nUna de las preguntas más comunes entre las empresas que invierten en marketing digital es: ¿Cómo puedo medir el retorno de inversión (ROI) de mis campañas en redes sociales? Medir el ROI es fundamental para determinar si el esfuerzo, tiempo y dinero que destinas a tus campañas está generando los resultados deseados. Sin embargo, el cálculo puede ser complicado, ya que las redes sociales no solo impulsan ventas directas, sino también la interacción, reconocimiento de marca y fidelización de clientes.\nEn este artículo, te explicamos de manera sencilla cómo medir el ROI de tus campañas en redes sociales y cómo asegurarte de que tu inversión esté dando frutos.\n¿Qué es el ROI?\nEl retorno de inversión (ROI) es una métrica que permite evaluar la rentabilidad de una campaña en función del dinero que se invirtió. La fórmula básica para calcularlo es:\nROI=(Ingresosgenerados−Inversioón)×100 / Inversión ROI = \\frac{(Ingresos generados - Inversión) \\times 100}{Inversión}ROI=Inversión(Ingresosgenerados−Inversión)×100\nEste cálculo proporciona un porcentaje que indica el beneficio que has obtenido en relación con lo que has gastado. Si el resultado es positivo, tu campaña fue rentable; si es negativo, significa que perdiste dinero.\nLa importancia de medir el ROI en redes sociales\nMedir el ROI en redes sociales es crucial por varias razones:\n\nEvaluar el éxito: Te ayuda a determinar si tus esfuerzos en redes sociales están funcionando como esperabas.\nOptimización: Si identificas qué campañas o tácticas generan un mayor retorno, puedes ajustar tu estrategia para enfocarte en ellas.\nJustificación de la inversión: Si necesitas justificar ante tu equipo o tus superiores la inversión en redes sociales, el ROI te proporciona cifras concretas.\n\n¿Qué se puede medir en una campaña de redes sociales?\nAntes de sumergirnos en los pasos para calcular el ROI, es importante entender que no todo el impacto de las redes sociales se traduce en ingresos directos. Las redes sociales generan varios tipos de valor, como:\n\nVentas directas: Conversiones que resultan directamente de una interacción en redes sociales.\nReconocimiento de marca: El valor que aportan las impresiones y la visibilidad.\nInteracción: Likes, comentarios, compartidos y retuits que contribuyen al engagement de tu marca.\nFidelización de clientes: Las redes sociales pueden ayudar a mejorar la lealtad del cliente y las relaciones a largo plazo.\n\nPara calcular el ROI de una campaña, es fundamental que definas qué tipo de valor estás midiendo. En la mayoría de los casos, el ROI se mide a partir de las conversiones y las ventas, pero también puedes establecer métricas de éxito basadas en el crecimiento de seguidores, el reconocimiento de marca o el tráfico a tu sitio web.\nPasos para medir el ROI de las campañas en redes sociales\nA continuación, te explicamos los pasos básicos para medir el ROI de tus campañas en redes sociales.\n1. Establecer objetivos claros\nEl primer paso para medir el ROI es establecer objetivos concretos y medibles. Sin objetivos claros, es difícil evaluar si una campaña fue exitosa o no. Algunos ejemplos de objetivos pueden ser:\n\nAumentar las ventas: Este es un objetivo común para las empresas que utilizan redes sociales para impulsar sus productos o servicios.\nGenerar tráfico a tu sitio web: Puedes medir cuántos usuarios hacen clic en los enlaces de tus publicaciones para visitar tu página.\nIncrementar el engagement: Aumentar los likes, comentarios y compartidos puede ser un objetivo si buscas mejorar la interacción con tu audiencia.\nCapturar leads: Si tu campaña está diseñada para recopilar datos de clientes potenciales, este sería un objetivo medible.\n\nRecuerda que estos objetivos deben ser SMART (específicos, medibles, alcanzables, relevantes y con un tiempo determinado).\n2. Rastrear métricas clave\nPara medir el ROI, debes rastrear las métricas que te ayudarán a cumplir los objetivos establecidos. Algunas de las métricas más comunes en redes sociales son:\n\nCTR (Click-Through Rate): Porcentaje de usuarios que hicieron clic en un enlace en comparación con el total de usuarios que vieron la publicación.\nConversiones: Número de acciones completadas (ventas, registros, suscripciones) generadas a partir de una campaña.\nEngagement: Número total de interacciones (likes, comentarios, compartidos) dividido por el número de impresiones.\nCPC (Costo por clic): Costo promedio que pagas por cada clic en tus anuncios.\nCosto por conversión: El costo total de la campaña dividido por el número de conversiones generadas.\n\nHerramientas para medir el ROI en redes sociales\nAfortunadamente, existen varias herramientas que te ayudan a rastrear las métricas de tus campañas en redes sociales. Las más populares son:\n1. Google Analytics\nGoogle Analytics es una de las herramientas más potentes para medir el rendimiento de las redes sociales. Con él, puedes rastrear el tráfico que llega a tu sitio web desde redes sociales, las conversiones generadas y el comportamiento de los usuarios en tu página. Para medir el ROI, debes configurar el seguimiento de objetivos en Google Analytics, como ventas o registros.\n2. Facebook Ads Manager\nSi realizas campañas pagadas en Facebook o Instagram, Facebook Ads Manager te permite ver métricas detalladas sobre el rendimiento de tus anuncios, como clics, impresiones, conversiones y costo por conversión. También te permite configurar píxeles de seguimiento, que te ayudan a rastrear el comportamiento de los usuarios después de hacer clic en tus anuncios.\n3. Hootsuite o Buffer\nHerramientas como Hootsuite y Buffer te permiten programar publicaciones y rastrear el rendimiento de tus campañas orgánicas. Puedes ver el engagement de tus publicaciones, el crecimiento de seguidores y el tráfico que generan a tu sitio web.\nCalcular el ROI en ventas\nEl cálculo más directo del ROI proviene de las ventas generadas directamente por una campaña. Si has invertido $500 en una campaña y generaste $1,500 en ventas gracias a esa campaña, el cálculo sería:\nROI=(1500−500)×100500=200%ROI = \\frac{(1500 - 500) \\times 100}{500} = 200\\%ROI=500(1500−500)×100=200%\nEsto significa que has obtenido un retorno del 200%, lo que indica que tu campaña fue altamente rentable.\nCalcular el ROI en base a otros valores\nNo todas las campañas de redes sociales se enfocan en generar ventas inmediatas. Algunas tienen como objetivo mejorar el reconocimiento de marca o el engagement. Para calcular el ROI en estos casos, puedes asignar un valor monetario a estos resultados. Por ejemplo, puedes calcular cuánto te costaría conseguir la misma visibilidad o interacción a través de otros medios publicitarios y compararlo con lo que has invertido en redes sociales.\nOptimización del ROI\nMedir el ROI no es suficiente. Debes usar los datos para optimizar tus futuras campañas. Si notas que ciertos anuncios o tipos de contenido generan más conversiones o engagement, ajusta tu estrategia para centrarte en ellos. De igual forma, si una plataforma no te está dando los resultados esperados, considera reducir tu inversión en ella y probar nuevas estrategias.\nConclusión\nMedir el ROI de tus campañas en redes sociales es esencial para saber si tu inversión está generando resultados. Al establecer objetivos claros, rastrear las métricas correctas y utilizar herramientas adecuadas, puedes obtener una visión precisa de cómo tus campañas impactan en tu negocio.\nEn codigoseo.com, te ayudamos a medir y mejorar el rendimiento de tus campañas en redes sociales. Con nuestra experiencia en marketing digital y análisis de datos, aseguramos que cada dólar que inviertes en redes sociales se traduzca en resultados medibles y significativos. ¡Contáctanos para optimizar tus campañas hoy mismo! \n\n') LIKE CONCAT('%', LOWER(t.tterm), '%')) OR (LOWER('\nUna de las preguntas más comunes entre las empresas que invierten en marketing digital es: ¿Cómo puedo medir el retorno de inversión (ROI) de mis campañas en redes sociales? Medir el ROI es fundamental para determinar si el esfuerzo, tiempo y dinero que destinas a tus campañas está generando los resultados deseados. Sin embargo, el cálculo puede ser complicado, ya que las redes sociales no solo impulsan ventas directas, sino también la interacción, reconocimiento de marca y fidelización de clientes.\nEn este artículo, te explicamos de manera sencilla cómo medir el ROI de tus campañas en redes sociales y cómo asegurarte de que tu inversión esté dando frutos.\n¿Qué es el ROI?\nEl retorno de inversión (ROI) es una métrica que permite evaluar la rentabilidad de una campaña en función del dinero que se invirtió. La fórmula básica para calcularlo es:\nROI=(Ingresosgenerados−Inversioón)×100 / Inversión ROI = \\frac{(Ingresos generados - Inversión) \\times 100}{Inversión}ROI=Inversión(Ingresosgenerados−Inversión)×100\nEste cálculo proporciona un porcentaje que indica el beneficio que has obtenido en relación con lo que has gastado. Si el resultado es positivo, tu campaña fue rentable; si es negativo, significa que perdiste dinero.\nLa importancia de medir el ROI en redes sociales\nMedir el ROI en redes sociales es crucial por varias razones:\n\nEvaluar el éxito: Te ayuda a determinar si tus esfuerzos en redes sociales están funcionando como esperabas.\nOptimización: Si identificas qué campañas o tácticas generan un mayor retorno, puedes ajustar tu estrategia para enfocarte en ellas.\nJustificación de la inversión: Si necesitas justificar ante tu equipo o tus superiores la inversión en redes sociales, el ROI te proporciona cifras concretas.\n\n¿Qué se puede medir en una campaña de redes sociales?\nAntes de sumergirnos en los pasos para calcular el ROI, es importante entender que no todo el impacto de las redes sociales se traduce en ingresos directos. Las redes sociales generan varios tipos de valor, como:\n\nVentas directas: Conversiones que resultan directamente de una interacción en redes sociales.\nReconocimiento de marca: El valor que aportan las impresiones y la visibilidad.\nInteracción: Likes, comentarios, compartidos y retuits que contribuyen al engagement de tu marca.\nFidelización de clientes: Las redes sociales pueden ayudar a mejorar la lealtad del cliente y las relaciones a largo plazo.\n\nPara calcular el ROI de una campaña, es fundamental que definas qué tipo de valor estás midiendo. En la mayoría de los casos, el ROI se mide a partir de las conversiones y las ventas, pero también puedes establecer métricas de éxito basadas en el crecimiento de seguidores, el reconocimiento de marca o el tráfico a tu sitio web.\nPasos para medir el ROI de las campañas en redes sociales\nA continuación, te explicamos los pasos básicos para medir el ROI de tus campañas en redes sociales.\n1. Establecer objetivos claros\nEl primer paso para medir el ROI es establecer objetivos concretos y medibles. Sin objetivos claros, es difícil evaluar si una campaña fue exitosa o no. Algunos ejemplos de objetivos pueden ser:\n\nAumentar las ventas: Este es un objetivo común para las empresas que utilizan redes sociales para impulsar sus productos o servicios.\nGenerar tráfico a tu sitio web: Puedes medir cuántos usuarios hacen clic en los enlaces de tus publicaciones para visitar tu página.\nIncrementar el engagement: Aumentar los likes, comentarios y compartidos puede ser un objetivo si buscas mejorar la interacción con tu audiencia.\nCapturar leads: Si tu campaña está diseñada para recopilar datos de clientes potenciales, este sería un objetivo medible.\n\nRecuerda que estos objetivos deben ser SMART (específicos, medibles, alcanzables, relevantes y con un tiempo determinado).\n2. Rastrear métricas clave\nPara medir el ROI, debes rastrear las métricas que te ayudarán a cumplir los objetivos establecidos. Algunas de las métricas más comunes en redes sociales son:\n\nCTR (Click-Through Rate): Porcentaje de usuarios que hicieron clic en un enlace en comparación con el total de usuarios que vieron la publicación.\nConversiones: Número de acciones completadas (ventas, registros, suscripciones) generadas a partir de una campaña.\nEngagement: Número total de interacciones (likes, comentarios, compartidos) dividido por el número de impresiones.\nCPC (Costo por clic): Costo promedio que pagas por cada clic en tus anuncios.\nCosto por conversión: El costo total de la campaña dividido por el número de conversiones generadas.\n\nHerramientas para medir el ROI en redes sociales\nAfortunadamente, existen varias herramientas que te ayudan a rastrear las métricas de tus campañas en redes sociales. Las más populares son:\n1. Google Analytics\nGoogle Analytics es una de las herramientas más potentes para medir el rendimiento de las redes sociales. Con él, puedes rastrear el tráfico que llega a tu sitio web desde redes sociales, las conversiones generadas y el comportamiento de los usuarios en tu página. Para medir el ROI, debes configurar el seguimiento de objetivos en Google Analytics, como ventas o registros.\n2. Facebook Ads Manager\nSi realizas campañas pagadas en Facebook o Instagram, Facebook Ads Manager te permite ver métricas detalladas sobre el rendimiento de tus anuncios, como clics, impresiones, conversiones y costo por conversión. También te permite configurar píxeles de seguimiento, que te ayudan a rastrear el comportamiento de los usuarios después de hacer clic en tus anuncios.\n3. Hootsuite o Buffer\nHerramientas como Hootsuite y Buffer te permiten programar publicaciones y rastrear el rendimiento de tus campañas orgánicas. Puedes ver el engagement de tus publicaciones, el crecimiento de seguidores y el tráfico que generan a tu sitio web.\nCalcular el ROI en ventas\nEl cálculo más directo del ROI proviene de las ventas generadas directamente por una campaña. Si has invertido $500 en una campaña y generaste $1,500 en ventas gracias a esa campaña, el cálculo sería:\nROI=(1500−500)×100500=200%ROI = \\frac{(1500 - 500) \\times 100}{500} = 200\\%ROI=500(1500−500)×100=200%\nEsto significa que has obtenido un retorno del 200%, lo que indica que tu campaña fue altamente rentable.\nCalcular el ROI en base a otros valores\nNo todas las campañas de redes sociales se enfocan en generar ventas inmediatas. Algunas tienen como objetivo mejorar el reconocimiento de marca o el engagement. Para calcular el ROI en estos casos, puedes asignar un valor monetario a estos resultados. Por ejemplo, puedes calcular cuánto te costaría conseguir la misma visibilidad o interacción a través de otros medios publicitarios y compararlo con lo que has invertido en redes sociales.\nOptimización del ROI\nMedir el ROI no es suficiente. Debes usar los datos para optimizar tus futuras campañas. Si notas que ciertos anuncios o tipos de contenido generan más conversiones o engagement, ajusta tu estrategia para centrarte en ellos. De igual forma, si una plataforma no te está dando los resultados esperados, considera reducir tu inversión en ella y probar nuevas estrategias.\nConclusión\nMedir el ROI de tus campañas en redes sociales es esencial para saber si tu inversión está generando resultados. Al establecer objetivos claros, rastrear las métricas correctas y utilizar herramientas adecuadas, puedes obtener una visión precisa de cómo tus campañas impactan en tu negocio.\nEn codigoseo.com, te ayudamos a medir y mejorar el rendimiento de tus campañas en redes sociales. Con nuestra experiencia en marketing digital y análisis de datos, aseguramos que cada dólar que inviertes en redes sociales se traduzca en resultados medibles y significativos. ¡Contáctanos para optimizar tus campañas hoy mismo! \n\n') LIKE CONCAT('%', LOWER(t.tsynonyms), '%'))) AND g.language IN ('es-ES','*') AND (t.publish_up = '0000-00-00 00:00:00' OR t.publish_up <= '2025-04-09 13:58:38') AND ((t.publish_down = '0000-00-00 00:00:00' OR t.publish_down >= '2025-04-09 13:58:38')) AND NOT FIND_IN_SET('easyblog.blog',g.disable_context) AND NOT FIND_IN_SET(440,g.disable_menu) AND NOT FIND_IN_SET('easyblog',g.disable_component)
ORDER BY t.ordering
262μs4.27KB/plugins/content/seoglossary/seoglossary.php:184CopySELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `eua3m_modules` AS `m`
LEFT JOIN `eua3m_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `eua3m_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`
1.08ms18.75KBParams/libraries/src/Cache/Controller/CallbackController.php:51CopySELECT `group_id` FROM `eua3m_user_usergroup_map` WHERE `user_id` = '42'
133μs856B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT * FROM `eua3m_easyblog_acl_group` WHERE `content_id` IN (8) AND `type`='group'
240μs1.92KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT a.*, count(b.`id`) AS total FROM `eua3m_easyblog_reactions` AS a LEFT JOIN `eua3m_easyblog_reactions_history` AS b ON a.`id` = b.`reaction_id` AND b.`post_id`='104' WHERE a.`published`='1' GROUP BY a.`id`
205μs1.13KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT b.* FROM `eua3m_easyblog_reactions_history` AS a LEFT JOIN `eua3m_easyblog_reactions`AS b ON a.`reaction_id` = b.`id` WHERE a.`post_id` = '104' AND a.`token_id` = '75846119cb2ee13a8e12fbb11c966858'
152μs1008B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT `id` FROM `eua3m_easyblog_subscriptions` WHERE `uid` = '42' AND `utype` = 'blogger' AND `email` = ''
196μs840B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT a.`id` AS key1, a.*, ifnull(f.`id`, 0) as `featured` FROM `eua3m_easyblog_post` AS a INNER JOIN `eua3m_users` AS uu ON a.`created_by` = uu.`id` and uu.`block` = 0 LEFT JOIN `eua3m_easyblog_featured` AS f ON a.`id` = f.`content_id` AND f.`type` = 'post' WHERE a.`published`='1' AND a.`state`='0' AND a.`access` = '0' AND a.`created_by` = '42' AND ( NOT EXISTS ( select acp.post_id from `eua3m_easyblog_post_category` as acp inner join `eua3m_easyblog_category` as cat on acp.`category_id` = cat.`id` where acp.`post_id` = a.`id` and ( ( cat.`private` = 1 and (0 = 0) ) OR ( cat.`private` = 2 and (select count(1) from `eua3m_easyblog_category_acl` as cacl where cacl.`category_id` = cat.`id` and cacl.`acl_id` = 1 and cacl.`content_id` IN (9)) = 0 ) ))) AND ((a.`source_type` = 'easyblog.sitewide') ) AND a.`id` NOT IN ('104') ORDER BY a.`created` desc LIMIT 0,3
12.14ms103.94KB/administrator/components/com_easyblog/includes/utils.php:298Copyselect count(1) from `eua3m_easyblog_post` AS a WHERE a.`published`='1' AND a.`state`='0' AND a.`access` = '0' AND a.`created_by` = '42' AND ( NOT EXISTS ( select acp.post_id from `eua3m_easyblog_post_category` as acp inner join `eua3m_easyblog_category` as cat on acp.`category_id` = cat.`id` where acp.`post_id` = a.`id` and ( ( cat.`private` = 1 and (0 = 0) ) OR ( cat.`private` = 2 and (select count(1) from `eua3m_easyblog_category_acl` as cacl where cacl.`category_id` = cat.`id` and cacl.`acl_id` = 1 and cacl.`content_id` IN (9)) = 0 ) ))) AND ((a.`source_type` = 'easyblog.sitewide') ) AND a.`id` NOT IN ('104')
1.69ms856B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT COUNT(1) as `voted`, `uid` FROM `eua3m_easyblog_ratings` WHERE `uid` IN (302,301,300) AND `type`='entry' AND `created_by`='0' AND (`sessionid` = '07dc7687aaec6d28778d96006ffb8739' OR `ip` = '3.133.130.103') GROUP BY `uid` ORDER BY NULL
231μs896B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid` FROM `eua3m_easyblog_ratings` AS a WHERE a.`uid` IN(302,301,300) AND `type`='entry' GROUP BY `uid` ORDER BY NULL
175μs960B/administrator/components/com_easyblog/includes/utils.php:298Copyselect a.*, b.`post_id`, b.`primary` from `eua3m_easyblog_category` as a inner join `eua3m_easyblog_post_category` as b on a.`id` = b.`category_id` where b.`post_id` IN (302,301,300) order by a.`lft` asc
301μs4.06KB/administrator/components/com_easyblog/includes/utils.php:298Copyselect a.*, b.`post_id` from `eua3m_easyblog_tag` as a inner join `eua3m_easyblog_post_tag` as b on a.`id` = b.`tag_id` where b.`post_id` IN (302,301,300)
241μs2.33KB/administrator/components/com_easyblog/includes/utils.php:298Copyselect a.* from `eua3m_easyblog_revisions` as a where a.`id` IN ( 325,324,323)
204μs117.94KB/administrator/components/com_easyblog/includes/utils.php:298Copyselect `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `f`.`ordering` as `f_ordering`,`fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value` from `eua3m_easyblog_category_fields_groups` as a inner join `eua3m_easyblog_post_category` as p on `a`.`category_id` = `p`.`category_id` inner join `eua3m_easyblog_fields_groups` as fg on `a`.`group_id` = `fg`.`id` inner join `eua3m_easyblog_fields` as f on `fg`.`id` = `f`.`group_id` left join `eua3m_easyblog_fields_values` as fv on `fv`.`field_id` = `f`.`id` and `fv`.`post_id` = `p`.`post_id` LEFT JOIN `eua3m_easyblog_fields_groups_acl` AS acl ON fg.`id` = acl.`group_id` where p.post_id IN (302,301,300) AND ( acl.`acl_id` IN(9) AND acl.`acl_type` = 'read' OR acl.`id` IS NULL )
448μs20.08KB/administrator/components/com_easyblog/includes/utils.php:298Copyselect * from `eua3m_easyblog_meta` where `content_id` in (302,301,300) and `type` = 'post'
180μs1.25KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT `template` FROM `eua3m_template_styles` WHERE `home`!='0' AND `client_id`='0'
166μs856B/libraries/foundry/helper.php:553CopySELECT COUNT(1) FROM `eua3m_easyblog_featured` WHERE `content_id`='302' AND `type`='post'
146μs856B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT COUNT(1) FROM `eua3m_easyblog_featured` WHERE `content_id`='301' AND `type`='post'
137μs856B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT COUNT(1) FROM `eua3m_easyblog_featured` WHERE `content_id`='300' AND `type`='post'
136μs856B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT DISTINCT c.*, 0 as `featured` FROM `eua3m_easyblog_category` AS a INNER JOIN `eua3m_easyblog_category` AS a1 ON a.`id` = a1.`id` AND a1.`id` = '7' INNER JOIN `eua3m_easyblog_post` AS c ON a1.`id` = c.`category_id` INNER JOIN `eua3m_users` AS uu ON c.`created_by` = uu.`id` and uu.`block` = 0 WHERE c.`id`!='104' AND c.`published`='1' AND c.`state`='0' AND ( NOT EXISTS ( select acp.post_id from `eua3m_easyblog_post_category` as acp inner join `eua3m_easyblog_category` as cat on acp.`category_id` = cat.`id` where acp.`post_id` = c.`id` and ( ( cat.`private` = 1 and (0 = 0) ) OR ( cat.`private` = 2 and (select count(1) from `eua3m_easyblog_category_acl` as cacl where cacl.`category_id` = cat.`id` and cacl.`acl_id` = 1 and cacl.`content_id` IN (9)) = 0 ) ))) ORDER BY c.`created` desc LIMIT 6
6.33ms243.95KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT COUNT(1) as `voted`, `uid` FROM `eua3m_easyblog_ratings` WHERE `uid` IN (300,261,260,259,240,237) AND `type`='entry' AND `created_by`='0' AND (`sessionid` = '07dc7687aaec6d28778d96006ffb8739' OR `ip` = '3.133.130.103') GROUP BY `uid` ORDER BY NULL
303μs896B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid` FROM `eua3m_easyblog_ratings` AS a WHERE a.`uid` IN(300,261,260,259,240,237) AND `type`='entry' GROUP BY `uid` ORDER BY NULL
220μs960B/administrator/components/com_easyblog/includes/utils.php:298Copyselect a.*, b.`post_id`, b.`primary` from `eua3m_easyblog_category` as a inner join `eua3m_easyblog_post_category` as b on a.`id` = b.`category_id` where b.`post_id` IN (300,261,260,259,240,237) order by a.`lft` asc
336μs4.11KB/administrator/components/com_easyblog/includes/utils.php:298Copyselect a.*, b.`post_id` from `eua3m_easyblog_tag` as a inner join `eua3m_easyblog_post_tag` as b on a.`id` = b.`tag_id` where b.`post_id` IN (300,261,260,259,240,237)
273μs2.39KB/administrator/components/com_easyblog/includes/utils.php:298Copyselect a.* from `eua3m_easyblog_revisions` as a where a.`id` IN ( 323,283,282,281,261,258)
552μs249.98KB/administrator/components/com_easyblog/includes/utils.php:298Copyselect `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `f`.`ordering` as `f_ordering`,`fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value` from `eua3m_easyblog_category_fields_groups` as a inner join `eua3m_easyblog_post_category` as p on `a`.`category_id` = `p`.`category_id` inner join `eua3m_easyblog_fields_groups` as fg on `a`.`group_id` = `fg`.`id` inner join `eua3m_easyblog_fields` as f on `fg`.`id` = `f`.`group_id` left join `eua3m_easyblog_fields_values` as fv on `fv`.`field_id` = `f`.`id` and `fv`.`post_id` = `p`.`post_id` LEFT JOIN `eua3m_easyblog_fields_groups_acl` AS acl ON fg.`id` = acl.`group_id` where p.post_id IN (300,261,260,259,240,237) AND ( acl.`acl_id` IN(9) AND acl.`acl_type` = 'read' OR acl.`id` IS NULL )
520μs4.08KB/administrator/components/com_easyblog/includes/utils.php:298Copyselect * from `eua3m_easyblog_meta` where `content_id` in (300,261,260,259,240,237) and `type` = 'post'
213μs1.3KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT * FROM `eua3m_easyblog_composer_blocks`
203μs2.83KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT `template` FROM `eua3m_template_styles` WHERE `home` = '1' AND `client_id` ='0'
237μs856B/modules/mod_stackideas_toolbar/includes/themes/themes.php:160CopySELECT `id` FROM `eua3m_menu` WHERE (`link`='index.php?option=com_easyblog&view=search' OR `link` LIKE 'index.php?option=com_easyblog&view=search&limit=%') AND `published`='1'AND `client_id`='0' AND (`language`='es-ES' OR `language`='' OR `language`='*') ORDER BY `id` ASC LIMIT 1
372μs840B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT `id` FROM `eua3m_menu` WHERE `link` LIKE 'index.php?option=com_easyblog&view=search%' AND `published`='1'AND `client_id`='0' AND (`language`='es-ES' OR `language`='' OR `language`='*') LIMIT 1
272μs840B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT `id` FROM `eua3m_menu` WHERE `link`='index.php?option=com_easyblog&view=latest' AND `published`='1'AND `client_id`='0' AND (`language`='es-ES' OR `language`='' OR `language`='*') LIMIT 1
253μs840B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT `id` FROM `eua3m_menu` WHERE `link` LIKE 'index.php?option=com_easyblog&view=%' AND `published`='1'AND `client_id`='0' AND (`language`='es-ES' OR `language`='' OR `language`='*') ORDER BY `id` LIMIT 1
211μs856B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT `template` FROM `eua3m_template_styles` WHERE `home` = '1' AND `client_id` ='0'
131μs856B/modules/mod_stackideas_toolbar/includes/themes/themes.php:160CopySELECT `template` FROM `eua3m_template_styles` WHERE `home` = '1' AND `client_id` ='0'
131μs856B/modules/mod_stackideas_toolbar/includes/themes/themes.php:160CopySELECT `template` FROM `eua3m_template_styles` WHERE `home` = '1' AND `client_id` ='0'
137μs856B/modules/mod_stackideas_toolbar/includes/themes/themes.php:160CopySELECT `template` FROM `eua3m_template_styles` WHERE `home` = '1' AND `client_id` ='0'
139μs856B/modules/mod_stackideas_toolbar/includes/themes/themes.php:160CopySELECT `template` FROM `eua3m_template_styles` WHERE `home` = '1' AND `client_id` ='0'
146μs856B/modules/mod_stackideas_toolbar/includes/themes/themes.php:160CopySELECT extension_id FROM eua3m_extensions WHERE type='plugin' AND element = 'cookiespolicynotificationbar' AND folder='system'
202μs856B/plugins/system/cookiespolicynotificationbar/cookiespolicynotificationbar.php:769CopySELECT extension_id FROM eua3m_extensions WHERE type='plugin' AND element = 'cookiespolicynotificationbar' AND folder='system'
144μs40B/plugins/system/cookiespolicynotificationbar/cookiespolicynotificationbar.php:770CopySELECT `content`
FROM `eua3m_modules`
WHERE `published` = 1 AND `client_id` = 0 AND `content` <> ''
298μs920B/plugins/system/ampz/helper.php:88CopySELECT manifest_cache FROM eua3m_extensions WHERE element='mod_djmegamenu' LIMIT 1
223μs856B/modules/mod_djmegamenu/helpers/helper.php:412CopySELECT * FROM eua3m_acym_list WHERE `type` = 'standard'
204μs2.28KB/administrator/components/com_acym/libraries/joomla/database.php:30CopySELECT * FROM eua3m_acym_field WHERE `id` IN(1,2) ORDER BY `ordering` ASC
183μs3.64KB/administrator/components/com_acym/libraries/joomla/database.php:30CopySELECT COUNT(1) FROM `eua3m_easyblog_category_acl` as a LEFT JOIN `eua3m_easyblog_category` as b ON a.`category_id` = b.`id` WHERE b.`published` = '1' AND a.`acl_id` = '2' AND a.`type` = 'user' AND a.`content_id` = ''
267μs856B/administrator/components/com_easyblog/includes/utils.php:298Copyselect a.*, count(p.`id`) as `cnt` from `eua3m_easyblog_category` as a inner join `eua3m_easyblog_category` as c on a.`lft` <= c.`lft` and a.`rgt` >= c.`rgt` left join `eua3m_easyblog_post_category` as `pcat` on c.`id` = pcat.`category_id` left join `eua3m_easyblog_post` as p on pcat.`post_id` = p.`id` and p.`published` = '1' and p.`state` = '0' and not exists ( select acp2.post_id from `eua3m_easyblog_post_category` as acp2 inner join `eua3m_easyblog_category` as cat2 on acp2.`category_id` = cat2.`id` where acp2.`post_id` = pcat.`post_id` and ( (cat2.`private` = 1 and (0 = 0)) OR (cat2.`private` = 2 and (select count(1) from `eua3m_easyblog_category_acl` as cacl2 where cacl2.`category_id` = cat2.`id` and cacl2.`acl_id` = 1 and cacl2.`content_id` IN (9)) = 0) )) AND EXISTS (select uu.id from `eua3m_users` as uu where uu.`id` = p.`created_by` and uu.`block` = 0) WHERE a.`published`='1' and a.`parent_id` = 0 and (( (a.`private` = 0) OR (a.`private` = 1 AND '0' > 0) OR (a.`private` = 2 AND ( SELECT COUNT(1) FROM `eua3m_easyblog_category_acl` as ca WHERE ca.`category_id` = a.`id` AND ca.`acl_id` = '1' AND ( (ca.`content_id` IN ('9') AND ca.`type` = 'group') OR (ca.`content_id` = '0' AND ca.`type` = 'user') ) ) > 0 ) )) GROUP BY a.`id` ORDER BY `cnt` DESC LIMIT 10
2.15ms20.14KB/administrator/components/com_easyblog/includes/utils.php:298Copyselect count(1) from (select a.*, count(p.`id`) as `cnt` from `eua3m_easyblog_category` as a inner join `eua3m_easyblog_category` as c on a.`lft` <= c.`lft` and a.`rgt` >= c.`rgt` left join `eua3m_easyblog_post_category` as `pcat` on c.`id` = pcat.`category_id` left join `eua3m_easyblog_post` as p on pcat.`post_id` = p.`id` and p.`published` = '1' and p.`state` = '0' and not exists ( select acp2.post_id from `eua3m_easyblog_post_category` as acp2 inner join `eua3m_easyblog_category` as cat2 on acp2.`category_id` = cat2.`id` where acp2.`post_id` = pcat.`post_id` and ( (cat2.`private` = 1 and (0 = 0)) OR (cat2.`private` = 2 and (select count(1) from `eua3m_easyblog_category_acl` as cacl2 where cacl2.`category_id` = cat2.`id` and cacl2.`acl_id` = 1 and cacl2.`content_id` IN (9)) = 0) )) AND EXISTS (select uu.id from `eua3m_users` as uu where uu.`id` = p.`created_by` and uu.`block` = 0) WHERE a.`published`='1' and a.`parent_id` = 0 and (( (a.`private` = 0) OR (a.`private` = 1 AND '0' > 0) OR (a.`private` = 2 AND ( SELECT COUNT(1) FROM `eua3m_easyblog_category_acl` as ca WHERE ca.`category_id` = a.`id` AND ca.`acl_id` = '1' AND ( (ca.`content_id` IN ('9') AND ca.`type` = 'group') OR (ca.`content_id` = '0' AND ca.`type` = 'user') ) ) > 0 ) )) GROUP BY a.`id`) as x
1.98ms856B/administrator/components/com_easyblog/includes/utils.php:298CopySELECT a.*, COUNT(`b`.`id`) AS `cnt`,'1' AS `level` FROM `eua3m_easyblog_category` AS a LEFT JOIN `eua3m_easyblog_post_category` AS pc ON `a`.`id`=`pc`.`category_id` LEFT JOIN `eua3m_easyblog_post` AS b ON `b`.`id`=`pc`.`post_id` AND `b`.`published`='1' AND `b`.`state`='0' WHERE `a`.`published`='1' AND `parent_id`='9' GROUP BY `a`.`id` ORDER BY `cnt` desc
308μs4.02KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT a.*, COUNT(`b`.`id`) AS `cnt`,'1' AS `level` FROM `eua3m_easyblog_category` AS a LEFT JOIN `eua3m_easyblog_post_category` AS pc ON `a`.`id`=`pc`.`category_id` LEFT JOIN `eua3m_easyblog_post` AS b ON `b`.`id`=`pc`.`post_id` AND `b`.`published`='1' AND `b`.`state`='0' WHERE `a`.`published`='1' AND `parent_id`='2' GROUP BY `a`.`id` ORDER BY `cnt` desc
283μs4.02KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT a.*, COUNT(`b`.`id`) AS `cnt`,'1' AS `level` FROM `eua3m_easyblog_category` AS a LEFT JOIN `eua3m_easyblog_post_category` AS pc ON `a`.`id`=`pc`.`category_id` LEFT JOIN `eua3m_easyblog_post` AS b ON `b`.`id`=`pc`.`post_id` AND `b`.`published`='1' AND `b`.`state`='0' WHERE `a`.`published`='1' AND `parent_id`='8' GROUP BY `a`.`id` ORDER BY `cnt` desc
279μs4.02KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT a.*, COUNT(`b`.`id`) AS `cnt`,'1' AS `level` FROM `eua3m_easyblog_category` AS a LEFT JOIN `eua3m_easyblog_post_category` AS pc ON `a`.`id`=`pc`.`category_id` LEFT JOIN `eua3m_easyblog_post` AS b ON `b`.`id`=`pc`.`post_id` AND `b`.`published`='1' AND `b`.`state`='0' WHERE `a`.`published`='1' AND `parent_id`='1' GROUP BY `a`.`id` ORDER BY `cnt` desc
279μs4.02KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT a.*, COUNT(`b`.`id`) AS `cnt`,'1' AS `level` FROM `eua3m_easyblog_category` AS a LEFT JOIN `eua3m_easyblog_post_category` AS pc ON `a`.`id`=`pc`.`category_id` LEFT JOIN `eua3m_easyblog_post` AS b ON `b`.`id`=`pc`.`post_id` AND `b`.`published`='1' AND `b`.`state`='0' WHERE `a`.`published`='1' AND `parent_id`='3' GROUP BY `a`.`id` ORDER BY `cnt` desc
278μs4.02KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT a.*, COUNT(`b`.`id`) AS `cnt`,'1' AS `level` FROM `eua3m_easyblog_category` AS a LEFT JOIN `eua3m_easyblog_post_category` AS pc ON `a`.`id`=`pc`.`category_id` LEFT JOIN `eua3m_easyblog_post` AS b ON `b`.`id`=`pc`.`post_id` AND `b`.`published`='1' AND `b`.`state`='0' WHERE `a`.`published`='1' AND `parent_id`='7' GROUP BY `a`.`id` ORDER BY `cnt` desc
289μs4.02KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT a.*, COUNT(`b`.`id`) AS `cnt`,'1' AS `level` FROM `eua3m_easyblog_category` AS a LEFT JOIN `eua3m_easyblog_post_category` AS pc ON `a`.`id`=`pc`.`category_id` LEFT JOIN `eua3m_easyblog_post` AS b ON `b`.`id`=`pc`.`post_id` AND `b`.`published`='1' AND `b`.`state`='0' WHERE `a`.`published`='1' AND `parent_id`='4' GROUP BY `a`.`id` ORDER BY `cnt` desc
279μs4.02KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT a.*, COUNT(`b`.`id`) AS `cnt`,'1' AS `level` FROM `eua3m_easyblog_category` AS a LEFT JOIN `eua3m_easyblog_post_category` AS pc ON `a`.`id`=`pc`.`category_id` LEFT JOIN `eua3m_easyblog_post` AS b ON `b`.`id`=`pc`.`post_id` AND `b`.`published`='1' AND `b`.`state`='0' WHERE `a`.`published`='1' AND `parent_id`='6' GROUP BY `a`.`id` ORDER BY `cnt` desc
286μs4.02KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT a.*, COUNT(`b`.`id`) AS `cnt`,'1' AS `level` FROM `eua3m_easyblog_category` AS a LEFT JOIN `eua3m_easyblog_post_category` AS pc ON `a`.`id`=`pc`.`category_id` LEFT JOIN `eua3m_easyblog_post` AS b ON `b`.`id`=`pc`.`post_id` AND `b`.`published`='1' AND `b`.`state`='0' WHERE `a`.`published`='1' AND `parent_id`='10' GROUP BY `a`.`id` ORDER BY `cnt` desc
279μs4.02KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT *
FROM `eua3m_easyblog_category`
WHERE `id` = '9'
150μs3.97KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_category`
WHERE `id` = '2'
146μs3.97KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_category`
WHERE `id` = '8'
142μs3.97KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_category`
WHERE `id` = '1'
153μs3.97KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_category`
WHERE `id` = '3'
142μs3.97KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_category`
WHERE `id` = '6'
143μs3.97KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_category`
WHERE `id` = '10'
141μs3.97KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_banners`
WHERE
(`reset` <= :date AND `reset` IS NOT NULL) AND
(`checked_out` IS NULL OR `checked_out` = :userId)
346μs7.89KBParams/administrator/components/com_banners/src/Helper/BannersHelper.php:69CopySELECT `a`.`id`,`a`.`type`,`a`.`name`,`a`.`clickurl`,`a`.`sticky`,`a`.`cid`,`a`.`description`,`a`.`params`,`a`.`custombannercode`,`a`.`track_impressions`,`cl`.`track_impressions` AS `client_track_impressions`
FROM `eua3m_banners` AS `a`
LEFT JOIN `eua3m_banner_clients` AS `cl` ON `cl`.`id` = `a`.`cid`
WHERE
(
(
(`a`.`state` = 1) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :nowDate1)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :nowDate2)) AND
(`a`.`imptotal` = 0 OR `a`.`impmade` < `a`.`imptotal`) AND `a`.`cid` = :clientId AND `cl`.`state` = 1 AND `a`.`catid` IN (:preparedArray1)
ORDER BY `a`.`sticky` DESC, `a`.`ordering` LIMIT 1
397μs2.92KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopyUPDATE `eua3m_banners`
SET `impmade` = `impmade` + 1
WHERE `id` IN (:preparedArray1)
46.92ms856BParams/components/com_banners/src/Model/BannersModel.php:315CopyUPDATE `eua3m_banner_tracks`
SET `count` = `count` + 1
WHERE `track_type` = 1 AND `banner_id` = :id AND `track_date` = :trackDate
48.9ms832BParams/components/com_banners/src/Model/BannersModel.php:352CopySELECT a.`id` AS key1, a.*, ifnull(f.`id`, 0) as `featured` FROM `eua3m_easyblog_post` AS a INNER JOIN `eua3m_users` AS uu ON a.`created_by` = uu.`id` and uu.`block` = 0 LEFT JOIN `eua3m_easyblog_featured` AS f ON a.`id` = f.`content_id` AND f.`type` = 'post' WHERE a.`published`='1' AND a.`state`='0' AND a.`access` = '0' AND ( NOT EXISTS ( select acp.post_id from `eua3m_easyblog_post_category` as acp inner join `eua3m_easyblog_category` as cat on acp.`category_id` = cat.`id` where acp.`post_id` = a.`id` and ( ( cat.`private` = 1 and (0 = 0) ) OR ( cat.`private` = 2 and (select count(1) from `eua3m_easyblog_category_acl` as cacl where cacl.`category_id` = cat.`id` and cacl.`acl_id` = 1 and cacl.`content_id` IN (9)) = 0 ) ))) AND a.`created` <= '2025-04-09 13:58:38' and a.`created` >= DATE_ADD('2025-04-09 13:58:38', INTERVAL -5 DAY) AND ((a.`source_type` = 'easyblog.sitewide') ) ORDER BY a.`hits` desc LIMIT 5
610μs7.84KB/administrator/components/com_easyblog/includes/utils.php:298Copyselect SQL_CALC_FOUND_ROWS a.*, count(c.`id`) as `post_count` from `eua3m_easyblog_tag` as a left join `eua3m_easyblog_post_tag` as b on a.`id` = b.`tag_id` left join `eua3m_easyblog_post` as c on b.`post_id` = c.`id` and c.`published` = '1' and c.`state` = '0' LEFT JOIN `eua3m_users` AS uu ON c.`created_by` = uu.`id` where a.`published` = '1' AND (uu.`block` = 0 OR uu.`id` IS NULL) group by (a.`id`) order by a.`title` ASC LIMIT 30
6.15ms2.58KB/administrator/components/com_easyblog/includes/utils.php:298CopySELECT *
FROM `eua3m_easyblog_tag`
WHERE `id` = '423'
130μs2.06KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_tag`
WHERE `id` = '371'
120μs2.06KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_tag`
WHERE `id` = '47'
118μs2.06KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_tag`
WHERE `id` = '49'
118μs2.06KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_tag`
WHERE `id` = '321'
117μs2.06KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_tag`
WHERE `id` = '351'
118μs2.06KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_tag`
WHERE `id` = '82'
117μs2.06KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_tag`
WHERE `id` = '171'
120μs2.06KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_tag`
WHERE `id` = '220'
127μs2.06KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_tag`
WHERE `id` = '320'
118μs2.06KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_tag`
WHERE `id` = '129'
127μs2.06KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_tag`
WHERE `id` = '22'
117μs2.06KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_tag`
WHERE `id` = '192'
125μs2.06KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_tag`
WHERE `id` = '53'
118μs2.06KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_tag`
WHERE `id` = '39'
119μs2.06KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_tag`
WHERE `id` = '147'
118μs2.06KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_tag`
WHERE `id` = '242'
117μs2.06KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_tag`
WHERE `id` = '36'
117μs2.06KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_tag`
WHERE `id` = '157'
116μs2.06KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_tag`
WHERE `id` = '200'
118μs2.06KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_tag`
WHERE `id` = '360'
118μs2.06KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_tag`
WHERE `id` = '405'
115μs2.06KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_tag`
WHERE `id` = '237'
117μs2.06KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_tag`
WHERE `id` = '98'
117μs2.06KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_tag`
WHERE `id` = '188'
118μs2.06KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_tag`
WHERE `id` = '241'
117μs2.06KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_easyblog_tag`
WHERE `id` = '81'
117μs2.06KB/libraries/src/Table/Table.php:780CopySELECT *
FROM `eua3m_banners`
WHERE
(`reset` <= :date AND `reset` IS NOT NULL) AND
(`checked_out` IS NULL OR `checked_out` = :userId)
331μs7.89KBParams/administrator/components/com_banners/src/Helper/BannersHelper.php:69CopySELECT `a`.`id`,`a`.`type`,`a`.`name`,`a`.`clickurl`,`a`.`sticky`,`a`.`cid`,`a`.`description`,`a`.`params`,`a`.`custombannercode`,`a`.`track_impressions`,`cl`.`track_impressions` AS `client_track_impressions`
FROM `eua3m_banners` AS `a`
LEFT JOIN `eua3m_banner_clients` AS `cl` ON `cl`.`id` = `a`.`cid`
WHERE
(
(
(`a`.`state` = 1) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :nowDate1)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :nowDate2)) AND
(`a`.`imptotal` = 0 OR `a`.`impmade` < `a`.`imptotal`) AND `a`.`cid` = :clientId AND `cl`.`state` = 1 AND `a`.`catid` IN (:preparedArray1)
ORDER BY `a`.`sticky` DESC, RAND() LIMIT 1
421μs2.92KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopyUPDATE `eua3m_banners`
SET `impmade` = `impmade` + 1
WHERE `id` IN (:preparedArray1)
46.03ms856BParams/components/com_banners/src/Model/BannersModel.php:315CopyUPDATE `eua3m_banner_tracks`
SET `count` = `count` + 1
WHERE `track_type` = 1 AND `banner_id` = :id AND `track_date` = :trackDate
41.6ms832BParams/components/com_banners/src/Model/BannersModel.php:352CopySELECT a.*
FROM eua3m_extensions AS a
WHERE a.element LIKE "mod_jux_weather_forecast"
302μs3.73KB/modules/mod_jux_weather_forecast/helper.php:62CopySELECT *
FROM `eua3m_extensions`
WHERE `element` = 'com_gsd' AND `type` = 'component'
282μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160CopySHOW FULL COLUMNS FROM `eua3m_gsd_config`
495μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySELECT *
FROM `eua3m_gsd_config`
WHERE `name` = 'config'
99μs912B/libraries/src/Table/Table.php:780CopySELECT a.*
FROM eua3m_gsd a
WHERE a.state = 1 AND a.plugin = 'easyblog' AND a.appview IN ('entry','*')
ORDER BY a.id desc
261μs2.05KB/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT a.*
FROM eua3m_gsd a
WHERE a.state = 1 AND a.plugin = 'menus' AND a.appview IN ('menus','*')
ORDER BY a.id desc
205μs2.14KB/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT * FROM eua3m_acym_list WHERE type = 'standard'
190μs2.28KB/administrator/components/com_acym/libraries/joomla/database.php:30CopySELECT * FROM eua3m_acym_field
129μs3.66KB/administrator/components/com_acym/libraries/joomla/database.php:30CopySELECT * FROM eua3m_acym_form WHERE active = 1 AND type != 'shortcode'
110μs1.2KB/administrator/components/com_acym/libraries/joomla/database.php:30CopySELECT *
FROM eua3m_jmap_metainfo
WHERE `linkurl` = 'https://codigoseo.com/blog/como-medir-el-roi-de-las-campanas-en-redes-sociales'
AND `published` = 1
147μs1.2KB/plugins/system/jmap/jmap.php:838CopySELECT *
FROM eua3m_jmap_canonicals
WHERE `linkurl` = 'https://codigoseo.com/blog/como-medir-el-roi-de-las-campanas-en-redes-sociales'
90μs960B/plugins/system/jmap/jmap.php:968CopySELECT 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 `eua3m_scheduler_tasks` AS `a`
WHERE `a`.`state` = 1
173μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466CopySELECT `value` FROM eua3m_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"
271μs856B/plugins/system/acymtriggers/acymtriggers.php:155CopySHOW FULL TABLES WHERE table_type="BASE TABLE"
2.06ms8.88KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:635CopySELECT *
FROM eua3m_jmap_headings
WHERE `linkurl` = 'https://codigoseo.com/blog/como-medir-el-roi-de-las-campanas-en-redes-sociales'
112μs1.05KB/plugins/system/jmap/jmap.php:1192CopySELECT
`original_text`,
`target_text`,
`original_text_regex`,
`target_text_regex`
FROM
`eua3m_jmap_text_replacements`
WHERE
`published` = 1
96μs1008B/plugins/system/jmap/jmap.php:508CopySELECT `session_id`
FROM `eua3m_session`
WHERE `session_id` = ?
182μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277CopyUPDATE `eua3m_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?
69.73ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy