Spaces of Coexistence
EMoDiR
Early Modern Dissents and Radicalism
The EMoDiR Blog
Seeing the Early Modern World
Mar
27
Jul
12
Recent Comments
Herr Labadie
That can not be true!
Tuesday, 12 July 2016 22:08
Henning Hoppe
It is!
Tuesday, 12 July 2016 22:30
Debug information
Expand
Total SQL queries executed by: 97
Before application load usage: 2MB
After application load usage: 6MB
Before application load usage: 2MB
After application load usage: 6MB
-
SELECT * FROM `emo_easyblog_post` WHERE `publish_up`<='2021-03-07 03:13:19' AND `published`='2' AND `state`='0' ORDER BY `id` LIMIT 5 -
SELECT id, created_by FROM`emo_easyblog_post` WHERE `publish_down` > `publish_up` AND `publish_down` <= '2021-03-07 03:13:19' AND `publish_down` != '0000-00-00 00:00:00' AND `published` = '1' AND `state` = '0' -
SELECT * FROM `emo_easyblog_uploader_tmp` WHERE `created` <= DATE_SUB('2021-03-07 03:13:19' , INTERVAL 120 MINUTE) -
delete a, b from `emo_easyblog_post` as a inner join `emo_easyblog_revisions` as b on a.`id` = b.`post_id` where a.`published` = '9' and a.`created` <= DATE_SUB('2021-03-07 03:13:19', INTERVAL 3 DAY) -
SELECT * FROM `emo_menu` WHERE `published`='1' AND `link` LIKE 'index.php?option=com_easyblog%' -
SELECT * FROM `emo_easyblog_acl` WHERE `published`='1' ORDER BY `id` ASC -
SELECT * FROM `emo_easyblog_acl_group` WHERE `content_id`='1' AND `type`='group' -
SELECT `id`,`name`,`rules`,`parent_id` FROM `emo_assets` WHERE `name` IN ('root.1','com_acmanager','com_acymailing','com_admin','com_advancedmodules','com_ajax','com_akeeba','com_api','com_arkeditor','com_arkmedia','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easyblog','com_easydiscuss','com_easysocial','com_excelcsv_users_import','com_fields','com_finder','com_geommunity3es','com_installer','com_invitex','com_j2xml','com_jaextmanager','com_jbolo','com_jfbconnect','com_jgive','com_joomlaupdate','com_jticketing','com_komento','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_myplayer','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_regularlabsmanager','com_search','com_tags','com_templates','com_tjfields','com_users','com_wrapper') -
SELECT * FROM emo_easyblog_category WHERE `id` = '3' -
SELECT * FROM emo_easyblog_meta WHERE `content_id` = '3' AND `type` = 'category' -
SELECT * FROM emo_easyblog_category WHERE `id` = '3' -
select a.`id`, a.`title`, a.`alias`, a.`private`, a.`parent_id` from `emo_easyblog_category` as a WHERE a.`lft` > '3' AND a.`lft` < '4' and a.`published` = '1' AND (( ( a.`private` = 0) OR ( a.`private` = 1 and 1 > 0) OR ( a.`private` = 2 and (select count(1) from `emo_easyblog_category_acl` where `category_id` = a.`id` and `acl_id` = 1 and `content_id` in (9)) > 0))) ORDER BY a.`lft` ASC -
SELECT COUNT(1) AS `cnt` FROM `emo_easyblog_post_category` AS `a` INNER JOIN `emo_easyblog_post` AS `b` ON a.`post_id` = b.`id` AND b.`published`='1' INNER JOIN `emo_easyblog_category` AS `c` ON a.`category_id` = c.`id` AND b.`access`='0' WHERE ( c.`id` IN (3) or c.`parent_id` IN (3)) AND b.`state`='0' -
SELECT COUNT(1) FROM `emo_easyblog_post` AS a WHERE a.`published`='1' AND a.`state`='0' AND ( (a.`source_type` = 'easyblog.sitewide') OR ( a.`source_type` = 'easyblog.team' and 1 <= (select count(1) from `emo_easyblog_team` as srcteam where srcteam.`id` = a.`source_id` and srcteam.`published` = 1 and ( (srcteam.`access` = 3) OR (srcteam.`access` = 2 and (select count(1) from `emo_easyblog_team_groups` as srcteamgrp where srcteamgrp.`team_id` = srcteam.`id` and srcteamgrp.`group_id` IN (9) ) > 0)))) OR ( a.`source_type` = 'easysocial.group' and 1 <= (select count(1) from `emo_social_clusters` as srcesgroup where srcesgroup.`id` = a.`source_id` and srcesgroup.`cluster_type` = 'group' and srcesgroup.`type` = '1')) OR ( a.`source_type` = 'easysocial.page' and 1 <= (select count(1) from `emo_social_clusters` as srcesgroup where srcesgroup.`id` = a.`source_id` and srcesgroup.`cluster_type` = 'page' and srcesgroup.`type` = '1')) OR ( a.`source_type` = 'easysocial.event' and 1 <= (select count(1) from `emo_social_clusters` as srcesgroup where srcesgroup.`id` = a.`source_id` and srcesgroup.`cluster_type` = 'event' and srcesgroup.`type` = '1'))) AND (1 <= (select count(1) from `emo_easyblog_post_category` AS acp INNER JOIN `emo_easyblog_category` as cat on acp.`category_id` = cat.`id` where acp.`post_id` = a.`id` AND cat.`id` = 3 and ( ( cat.`private` = 0 ) OR ( (cat.`private` = 1) and (0 > 0) ) OR ( (cat.`private` = 2) and ( (select count(1) from `emo_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.`access`='0' ORDER BY a.`created` desc -
SELECT a.* FROM `emo_easyblog_post` AS a WHERE a.`published`='1' AND a.`state`='0' AND ( (a.`source_type` = 'easyblog.sitewide') OR ( a.`source_type` = 'easyblog.team' and 1 <= (select count(1) from `emo_easyblog_team` as srcteam where srcteam.`id` = a.`source_id` and srcteam.`published` = 1 and ( (srcteam.`access` = 3) OR (srcteam.`access` = 2 and (select count(1) from `emo_easyblog_team_groups` as srcteamgrp where srcteamgrp.`team_id` = srcteam.`id` and srcteamgrp.`group_id` IN (9) ) > 0)))) OR ( a.`source_type` = 'easysocial.group' and 1 <= (select count(1) from `emo_social_clusters` as srcesgroup where srcesgroup.`id` = a.`source_id` and srcesgroup.`cluster_type` = 'group' and srcesgroup.`type` = '1')) OR ( a.`source_type` = 'easysocial.page' and 1 <= (select count(1) from `emo_social_clusters` as srcesgroup where srcesgroup.`id` = a.`source_id` and srcesgroup.`cluster_type` = 'page' and srcesgroup.`type` = '1')) OR ( a.`source_type` = 'easysocial.event' and 1 <= (select count(1) from `emo_social_clusters` as srcesgroup where srcesgroup.`id` = a.`source_id` and srcesgroup.`cluster_type` = 'event' and srcesgroup.`type` = '1'))) AND (1 <= (select count(1) from `emo_easyblog_post_category` AS acp INNER JOIN `emo_easyblog_category` as cat on acp.`category_id` = cat.`id` where acp.`post_id` = a.`id` AND cat.`id` = 3 and ( ( cat.`private` = 0 ) OR ( (cat.`private` = 1) and (0 > 0) ) OR ( (cat.`private` = 2) and ( (select count(1) from `emo_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.`access`='0' ORDER BY a.`created` desc LIMIT 0,5 -
SELECT COUNT(1) FROM `emo_easyblog_category_acl` WHERE `acl_id` = '1' AND `status` = '1' AND `category_id` = '3' AND `content_id` IN ('9') -
SELECT COUNT(1) as `voted`, `uid` FROM `emo_easyblog_ratings` WHERE `uid` IN (278076,102034) AND `type`='entry' AND `created_by`='0' AND (`sessionid` = '7e47d9294b676505341a17a84bde611e7653f3dd' OR `ip` = '44.192.10.166') GROUP BY `uid` ORDER BY NULL -
SELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid` FROM `emo_easyblog_ratings` AS a WHERE a.`uid` IN(278076,102034) AND `type`='entry' GROUP BY `uid` ORDER BY NULL -
SELECT a.* FROM `emo_easyblog_comment` AS a WHERE a.`post_id` IN(278076,102034) AND a.`published`='1' -
SELECT a.`post_id`, COUNT(1) AS `count` FROM `emo_easyblog_comment` AS a WHERE a.`post_id` IN(278076,102034) AND a.`published`='1' GROUP BY a.`post_id` -
select a.*, b.`post_id`, b.`primary` from `emo_easyblog_category` as a inner join `emo_easyblog_post_category` as b on a.`id` = b.`category_id` where b.`post_id` IN ( 278076,102034) -
select a.*, b.`post_id` from `emo_easyblog_tag` as a inner join `emo_easyblog_post_tag` as b on a.`id` = b.`tag_id` where b.`post_id` IN ( 278076,102034) -
select a.* from `emo_easyblog_revisions` as a where a.`id` IN ( 278285,107899) -
select 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` from `emo_users` as u left join `emo_easyblog_users` as e ON u.`id` = e.`id` where u.`id` = 42 -
SHOW FULL COLUMNS FROM `emo_users` -
SELECT * FROM `emo_users` WHERE `id` = 42 -
SELECT `g`.`id`,`g`.`title` FROM `emo_usergroups` AS g INNER JOIN `emo_user_usergroup_map` AS m ON m.group_id = g.id WHERE `m`.`user_id` = 42 -
select `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`, `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 `emo_easyblog_category_fields_groups` as a inner join `emo_easyblog_post_category` as p on `a`.`category_id` = `p`.`category_id` inner join `emo_easyblog_fields_groups` as fg on `a`.`group_id` = `fg`.`id` inner join `emo_easyblog_fields` as f on `fg`.`id` = `f`.`group_id` left join `emo_easyblog_fields_values` as fv on `fv`.`field_id` = `f`.`id` and `fv`.`post_id` = `p`.`post_id` where p.post_id IN (278076,102034) -
select * from `emo_easyblog_meta` where `content_id` in (278076,102034) and `type` = 'post' -
SELECT * FROM `emo_easyblog_featured` WHERE `content_id` IN(278076,102034) AND `type`='post' -
SELECT `group_id` FROM `emo_easyblog_category_fields_groups` WHERE `category_id`='9' -
SELECT a.* FROM `emo_easyblog_fields` AS a INNER JOIN `emo_easyblog_category_fields_groups` AS b ON a.`group_id`= b.`group_id` WHERE b.`category_id`='9' AND a.`state`='1' ORDER BY a.`created` DESC -
SELECT `group_id` FROM `emo_easyblog_category_fields_groups` WHERE `category_id`='3' -
SELECT a.* FROM `emo_easyblog_fields` AS a INNER JOIN `emo_easyblog_category_fields_groups` AS b ON a.`group_id`= b.`group_id` WHERE b.`category_id`='3' AND a.`state`='1' ORDER BY a.`created` DESC -
SELECT `id` FROM `emo_easyblog_subscriptions` WHERE `uid` = '3' AND `utype` = 'category' AND `email` = '' -
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0' -
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0' -
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0' -
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0' -
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0' -
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0' -
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0' -
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0' -
SELECT MAX(ordering) FROM `emo_extensions` WHERE `type` = 'plugin' AND `folder` = 'content' -
SELECT `ordering` FROM `emo_extensions` WHERE `type` = 'plugin' AND `folder` = 'content' AND `element` = 'perfect_everything_in_everyway' -
SELECT 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,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 FROM emo_fields AS a LEFT JOIN `emo_languages` AS l ON l.lang_code = a.language LEFT JOIN emo_users AS uc ON uc.id=a.checked_out LEFT JOIN emo_viewlevels AS ag ON ag.id = a.access LEFT JOIN emo_users AS ua ON ua.id = a.created_user_id LEFT JOIN emo_fields_groups AS g ON g.id = a.group_id LEFT JOIN `emo_fields_categories` AS fc ON fc.field_id = a.id WHERE a.context = 'easyblog.blog' AND (fc.category_id IS NULL OR fc.category_id IN (3,0)) AND a.access IN (1,1,5) AND (a.group_id = 0 OR g.access IN (1,1,5)) AND a.state = 1 AND (a.group_id = 0 OR g.state = 1) ORDER BY a.ordering ASC -
SELECT * FROM `emo_social_access_rules` WHERE `group` = 'user' AND `state` = '1' -
SELECT `params` FROM `emo_social_access` WHERE `uid` = NULL AND `type` = 'profiles' -
SELECT COUNT(1) FROM `emo_social_comments` AS `a` WHERE `a`.`stream_id` = '' AND `a`.`element` = 'article.user.create' AND `a`.`uid` = '278076' AND `a`.`parent` = '0' -
SELECT COUNT(1) FROM `emo_social_apps` AS `a` WHERE `a`.`state` = '1' AND `a`.`type` = 'apps' AND `a`.`group` = 'user' OR `a`.`default` = '1' -
SELECT `a`.* FROM `emo_social_apps` AS `a` WHERE `a`.`state` = '1' AND `a`.`type` = 'apps' AND `a`.`group` = 'user' OR `a`.`default` = '1' -
SELECT * FROM `emo_social_themes` WHERE `element` = 'wireframe' -
SELECT namekey,value FROM `emo_invitex_config` -
SELECT namekey,value FROM `emo_invitex_config` -
SELECT namekey,value FROM `emo_invitex_config` -
SELECT namekey,value FROM `emo_invitex_config` -
SELECT template FROM `emo_template_styles` AS s LEFT JOIN `emo_extensions` AS e ON e.type = `template` AND e.element=s.template AND e.client_id=s.client_id WHERE s.client_id = '0' AND home = 1 -
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0' -
SELECT * FROM emo_easyblog_tag WHERE `id` = '23' -
SELECT * FROM emo_easyblog_tag WHERE `id` = '22' -
SELECT * FROM emo_easyblog_tag WHERE `id` = '21' -
SELECT * FROM emo_easyblog_tag WHERE `id` = '20' -
SELECT * FROM emo_easyblog_tag WHERE `id` = '19' -
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0' -
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0' -
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0' -
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0' -
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0' -
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0' -
SELECT a.* FROM `emo_easyblog_comment` a INNER JOIN emo_users AS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '278076' AND a.`published` = 1 ORDER BY a.`lft` asc LIMIT 3 -
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0' -
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0' -
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0' -
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0' -
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0' -
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0' -
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0' -
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0' -
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0' -
SELECT COUNT(1) FROM `emo_social_comments` AS `a` WHERE `a`.`stream_id` = '' AND `a`.`element` = 'article.user.create' AND `a`.`uid` = '102034' AND `a`.`parent` = '0' -
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0' -
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0' -
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0' -
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0' -
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0' -
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0' -
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0' -
SELECT a.* FROM `emo_easyblog_comment` a INNER JOIN emo_users AS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '102034' AND a.`published` = 1 ORDER BY a.`lft` asc LIMIT 3 -
select 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` from `emo_users` as u left join `emo_easyblog_users` as e ON u.`id` = e.`id` where u.`id` = 49 -
SELECT * FROM `emo_users` WHERE `id` = 49 -
SELECT `g`.`id`,`g`.`title` FROM `emo_usergroups` AS g INNER JOIN `emo_user_usergroup_map` AS m ON m.group_id = g.id WHERE `m`.`user_id` = 49 -
select a.id as `user_id`, c.id, a.name as `displayname` FROM `emo_users` as a inner join `emo_easyblog_users` as b on a.id = b.id inner join `emo_easyblog_likes` as c on a.id = c.created_by where c.content_id = '1' and c.`type` = 'comment' order by c.id desc -
select a.id as `user_id`, c.id, a.name as `displayname` FROM `emo_users` as a inner join `emo_easyblog_users` as b on a.id = b.id inner join `emo_easyblog_likes` as c on a.id = c.created_by where c.content_id = '5' and c.`type` = 'comment' order by c.id desc -
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0' -
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0' -
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0' -
SELECT `template` FROM `emo_template_styles` WHERE `home`='1' AND `client_id`='0'
Newsletters
Featured Blogs
We would like to hear from you