BoldMinded

Publisher does not support the Fluid field type. Please do not contact asking when support will be available.

If you purchased an add-on from expressionengine.com, be sure to visit boldminded.com/claim to add the license to your account here on boldminded.com.

Ticket: CP requests become insanely slow (minutes) with Publisher installed.

Status Resolved
Add-on / Version Publisher
Severity Critical
EE Version

Timothy Kelty

Apr 24, 2013

As soon as I uninstall, everything is back to normal.

From EE footer:
(Script executed in 103.7703 seconds - 56 SQL queries used)

I logged all the queries for a request to see if it was mysql…
The following are all queries for going to “Publisher -> Settings”

130424 15:59:05    53 Connect root@localhost on 
     53 Init DB telx_local
     53 Query SET NAMES utf8
     53 Query SELECT *
FROM (`exp_sites`)
WHERE `site_id` =  1
     53 Query SELECT DISTINCT ee.* FROM exp_extensions ee WHERE enabled = 'y' ORDER BY hook, priority ASC, class
130424 16:00:49    53 Query SELECT *
FROM (`exp_publisher_settings`)
     53 Query SELECT *
FROM (`exp_publisher_languages`)
ORDER BY `is_default` desc, `long_name` asc
     53 Query SELECT `id`
FROM (`exp_publisher_languages`)
WHERE `is_default` =  'y'
     52 Quit 
     53 Query SELECT LOWER(module_name) AS module_name, module_version, has_cp_backend, module_id
FROM (`exp_modules`)
     53 Query SELECT module_id FROM exp_modules WHERE module_name = 'Structure'
     53 Query SELECT var_value, var FROM exp_structure_settings WHERE site_id IN (0,1)
     53 Query SELECT `member_id`, `admin_sess`, `last_activity`
FROM (`exp_sessions`)
WHERE `session_id` =  'a14a81080fbe35b6b1f153ddff5f572eeee0ea14'
AND `user_agent` =  'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_3) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.57 Safari/537.17'
     53 Query SELECT *
FROM (`exp_members` m, `exp_member_groups` g)
WHERE `g`.`site_id` =  1
AND m.group_id =  g.group_id
AND `member_id` =  2
     53 Query SELECT `channel_id`, `channel_title`
FROM (`exp_channels`)
WHERE `site_id` =  '1'
ORDER BY `channel_title`
     53 Query SELECT `module_id`
FROM (`exp_module_member_groups`)
WHERE `group_id` =  '1'
     53 Query SELECT `template_group_id`
FROM (`exp_template_member_groups`)
WHERE `group_id` =  '1'
     53 Query SELECT `site_id`, `site_label`
FROM (`exp_sites`)
ORDER BY `site_label`
     53 Query UPDATE `exp_sessions` SET `session_id` = 'a14a81080fbe35b6b1f153ddff5f572eeee0ea14', `member_id` = 2, `admin_sess` = 1, `ip_address` = '127.0.0.1', `user_agent` = 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_3) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.57 Safari/537.17', `last_activity` = 1366833545 WHERE session_id ='a14a81080fbe35b6b1f153ddff5f572eeee0ea14'
     53 Query SELECT `field_id`
FROM (`exp_channel_fields`)
     53 Query SHOW COLUMNS FROM `exp_publisher_data`
     53 Query SELECT `field_id`
FROM (`exp_category_fields`)
     53 Query SHOW COLUMNS FROM `exp_publisher_categories`
     53 Query SELECT `name`
FROM (`exp_fieldtypes`)
     53 Query SHOW TABLES FROM `telx_local`
     53 Query SHOW COLUMNS FROM `exp_matrix_data`
     53 Query SHOW COLUMNS FROM `exp_playa_relationships`
     53 Query SHOW COLUMNS FROM `exp_assets_selections`
     53 Query SELECT *
FROM (`exp_fieldtypes`)
     53 Query SELECT `col_type`, `col_id`, `field_id`
FROM (`exp_matrix_cols`)
     53 Query SELECT `startpage`, `hide_sidebar`
FROM (`exp_zoo_flexible_admin_menus`)
WHERE `group_id` =  '1'
AND `site_id` =  '1'
     53 Query INSERT INTO `exp_security_hashes` (`date`, `hash`, `session_id`) VALUES (1366833545,'271dde2d44f99c8604c6461a61e79b54c5e27aa8','a14a81080fbe35b6b1f153ddff5f572eeee0ea14')
     53 Query SELECT `screen_name`, `notepad`, `quick_links`, `avatar_filename`, `avatar_width`, `avatar_height`
FROM (`exp_members`)
WHERE `member_id` =  2
     53 Query SELECT `channel_title`, `channel_name`, `channel_id`, `cat_group`, `status_group`, `field_group`
FROM (`exp_channels`)
WHERE `site_id` =  '1'
ORDER BY `channel_title`
     53 Query SELECT *
FROM (`exp_template_groups`)
WHERE `site_id` =  '1'
ORDER BY `group_order`, `group_name` ASC
     53 Query SELECT `exp_template_groups`.`group_id`, `template_id`, `template_name`, `group_name`
FROM (`exp_templates`)
JOIN `exp_template_groups` ON `exp_templates`.`group_id` = `exp_template_groups`.`group_id`
WHERE `exp_templates`.`site_id` =  '1'
ORDER BY `group_name`, `template_name`
     53 Query SELECT *
FROM (`exp_field_groups`)
WHERE `site_id` =  '1'
ORDER BY `group_name` asc
     53 Query SELECT *
FROM (`exp_accessories`)
     53 Query SELECT *
FROM (`exp_publisher_languages`)
ORDER BY `is_default` desc, `long_name` asc
     53 Query SELECT `id`
FROM (`exp_publisher_languages`)
WHERE `is_default` =  'y'
     53 Query SELECT *
FROM (`exp_publisher_approvals`)
WHERE `type` =  'entry'
ORDER BY `date` desc
LIMIT 20
     53 Query SELECT *
FROM (`exp_publisher_approvals`)
WHERE `type` =  'phrase'
ORDER BY `date` desc
LIMIT 20
     53 Query SELECT *
FROM (`exp_publisher_approvals`)
WHERE `type` =  'category'
ORDER BY `date` desc
LIMIT 20
     53 Query SELECT COUNT(*) AS `numrows`
FROM (`exp_publisher_approvals`)
     53 Query SELECT module_id FROM exp_modules WHERE module_name = 'Structure'
     53 Query SELECT ec.channel_id, ec.channel_title, esc.template_id, esc.type, ec.site_id
    FROM exp_channels AS ec 
    LEFT JOIN exp_structure_channels AS esc ON ec.channel_id = esc.channel_id
    WHERE ec.site_id = '1' AND esc.type = 'asset'
     53 Query SELECT * FROM exp_extensions WHERE class = 'Switchboard_ext' LIMIT 1
     53 Query SELECT cp_theme FROM exp_members WHERE member_id = '2' AND cp_theme != '' LIMIT 1
     53 Query SELECT *
FROM (`exp_switchboard_recent`)
WHERE `member_id` =  2
ORDER BY `date` desc
     53 Query SELECT
    fg.group_id,
    fg.group_name,
    cf.field_id,
    cf.field_label,
    cf.field_order,
    cf.field_name,
    cf.field_type
   FROM
    exp_field_groups fg
   LEFT JOIN
    exp_channel_fields cf
   ON fg.group_id = cf.group_id
   WHERE fg.site_id='1'
   ORDER BY cf.field_order, fg.group_name ASC
     53 Query SELECT snippet_id, snippet_name FROM exp_snippets
     53 Query SELECT variable_id, variable_name FROM exp_global_variables
     53 Query SELECT `action_id`
FROM (`exp_actions`)
WHERE `class` =  'Publisher'
AND `method` =  'deny_approval'
     53 Query SELECT `upload_id`
FROM (`exp_upload_no_access`)
WHERE `member_group` IS NULL
     53 Query SELECT *
FROM (`exp_upload_prefs`)
WHERE `site_id` =  '1'
ORDER BY `name`
     53 Query SELECT `exp_members`.`member_id`, `exp_members`.`group_id`, `exp_members`.`username`, `exp_members`.`screen_name`, `exp_members`.`in_authorlist`
FROM (`exp_members`)
JOIN `exp_member_groups` ON `exp_member_groups`.`group_id` = `exp_members`.`group_id`
WHERE `exp_members`.`group_id` = exp_member_groups.group_id
AND `exp_member_groups`.`site_id` =  '1'
AND `exp_members`.`group_id` NOT IN (1) 
ORDER BY `exp_members`.`screen_name` ASC, `exp_members`.`username` ASC
     53 Query SELECT `group_id`, `group_title`
FROM (`exp_member_groups`)
WHERE `site_id` =  '1'
AND `group_id` !=  1
ORDER BY `group_id`, `group_title`
     53 Query SELECT *
FROM (`exp_channels`)
WHERE `site_id` = '1'
ORDER BY `channel_name` asc
     53 Query SELECT *
FROM (`exp_channels`)
WHERE `site_id` = '1'
ORDER BY `channel_name` asc
     53 Query SELECT *
FROM (`exp_channel_fields`)
WHERE `site_id` = '1'
ORDER BY `group_id`, `field_name` ASC
     53 Quit 
     54 Connect root@localhost on 
     54 Init DB telx_local
     54 Query SET NAMES utf8
     54 Query SELECT *
FROM (`exp_sites`)
WHERE `site_id` =  1
     55 Connect root@localhost on 
     55 Init DB telx_local
     55 Query SET NAMES utf8
     56 Connect root@localhost on 
     55 Query SELECT *
FROM (`exp_sites`)
WHERE `site_id` =  1
     56 Init DB telx_local
     56 Query SET NAMES utf8
     56 Query SELECT *
FROM (`exp_sites`)
WHERE `site_id` =  1
     57 Connect root@localhost on 
     57 Init DB telx_local
     57 Query SET NAMES utf8
     57 Query SELECT *
FROM (`exp_sites`)
WHERE `site_id` =  1
     54 Query SELECT DISTINCT ee.* FROM exp_extensions ee WHERE enabled = 'y' ORDER BY hook, priority ASC, class
     58 Connect root@localhost on 
     58 Init DB telx_local
     58 Query SET NAMES utf8
     58 Query SELECT *
FROM (`exp_sites`)
WHERE `site_id` =  1
     59 Connect root@localhost on 
     56 Query SELECT DISTINCT ee.* FROM exp_extensions ee WHERE enabled = 'y' ORDER BY hook, priority ASC, class
     59 Init DB telx_local
     59 Query SET NAMES utf8
     59 Query SELECT *
FROM (`exp_sites`)
WHERE `site_id` =  1
     55 Query SELECT DISTINCT ee.* FROM exp_extensions ee WHERE enabled = 'y' ORDER BY hook, priority ASC, class
     58 Query SELECT DISTINCT ee.* FROM exp_extensions ee WHERE enabled = 'y' ORDER BY hook, priority ASC, class
     57 Query SELECT DISTINCT ee.* FROM exp_extensions ee WHERE enabled = 'y' ORDER BY hook, priority ASC, class
     59 Query SELECT DISTINCT ee.* FROM exp_extensions ee WHERE enabled = 'y' ORDER BY hook, priority ASC, class
     54 Query SELECT *
FROM (`exp_publisher_settings`)
130424 16:00:50    54 Query SELECT *
FROM (`exp_publisher_languages`)
ORDER BY `is_default` desc, `long_name` asc
     54 Query SELECT `id`
FROM (`exp_publisher_languages`)
WHERE `is_default` =  'y'
     54 Query SELECT LOWER(module_name) AS module_name, module_version, has_cp_backend, module_id
FROM (`exp_modules`)
     54 Query SELECT module_id FROM exp_modules WHERE module_name = 'Structure'
     54 Query SELECT var_value, var FROM exp_structure_settings WHERE site_id IN (0,1)
     54 Query SELECT `member_id`, `admin_sess`, `last_activity`
FROM (`exp_sessions`)
WHERE `session_id` =  'a14a81080fbe35b6b1f153ddff5f572eeee0ea14'
AND `user_agent` =  'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_3) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.57 Safari/537.17'
     54 Query SELECT *
FROM (`exp_members` m, `exp_member_groups` g)
WHERE `g`.`site_id` =  1
AND m.group_id =  g.group_id
AND `member_id` =  2
     54 Query SELECT `channel_id`, `channel_title`
FROM (`exp_channels`)
WHERE `site_id` =  '1'
ORDER BY `channel_title`
     54 Query SELECT `module_id`
FROM (`exp_module_member_groups`)
WHERE `group_id` =  '1'
     54 Query SELECT `template_group_id`
FROM (`exp_template_member_groups`)
WHERE `group_id` =  '1'
     54 Query SELECT `site_id`, `site_label`
FROM (`exp_sites`)
ORDER BY `site_label`
     54 Query UPDATE `exp_sessions` SET `session_id` = 'a14a81080fbe35b6b1f153ddff5f572eeee0ea14', `member_id` = 2, `admin_sess` = 1, `ip_address` = '127.0.0.1', `user_agent` = 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_3) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.57 Safari/537.17', `last_activity` = 1366833649 WHERE session_id ='a14a81080fbe35b6b1f153ddff5f572eeee0ea14'
     54 Query SELECT `field_id`
FROM (`exp_channel_fields`)
     54 Query SHOW COLUMNS FROM `exp_publisher_data`
     54 Query SELECT `field_id`
FROM (`exp_category_fields`)
     54 Query SHOW COLUMNS FROM `exp_publisher_categories`
     54 Query SELECT `name`
FROM (`exp_fieldtypes`)
     54 Query SHOW TABLES FROM `telx_local`
     54 Query SHOW COLUMNS FROM `exp_matrix_data`
     54 Query SHOW COLUMNS FROM `exp_playa_relationships`
     54 Query SHOW COLUMNS FROM `exp_assets_selections`
     54 Query SELECT *
FROM (`exp_fieldtypes`)
     54 Query SELECT `col_type`, `col_id`, `field_id`
FROM (`exp_matrix_cols`)
     54 Query SELECT `startpage`, `hide_sidebar`
FROM (`exp_zoo_flexible_admin_menus`)
WHERE `group_id` =  '1'
AND `site_id` =  '1'
     56 Query SELECT *
FROM (`exp_publisher_settings`)
     56 Query SELECT *
FROM (`exp_publisher_languages`)
ORDER BY `is_default` desc, `long_name` asc
     56 Query SELECT `id`
FROM (`exp_publisher_languages`)
WHERE `is_default` =  'y'
     54 Quit 
     56 Query SELECT LOWER(module_name) AS module_name, module_version, has_cp_backend, module_id
FROM (`exp_modules`)
     60 Connect root@localhost on 
     60 Init DB telx_local
     60 Query SET NAMES utf8
     60 Query SELECT *
FROM (`exp_sites`)
WHERE `site_id` =  1
     56 Query SELECT module_id FROM exp_modules WHERE module_name = 'Structure'
     56 Query SELECT var_value, var FROM exp_structure_settings WHERE site_id IN (0,1)
     60 Query SELECT DISTINCT ee.* FROM exp_extensions ee WHERE enabled = 'y' ORDER BY hook, priority ASC, class
     56 Query SELECT `member_id`, `admin_sess`, `last_activity`
FROM (`exp_sessions`)
WHERE `session_id` =  'a14a81080fbe35b6b1f153ddff5f572eeee0ea14'
AND `user_agent` =  'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_3) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.57 Safari/537.17'
     56 Query SELECT *
FROM (`exp_members` m, `exp_member_groups` g)
WHERE `g`.`site_id` =  1
AND m.group_id =  g.group_id
AND `member_id` =  2
     56 Query SELECT `channel_id`, `channel_title`
FROM (`exp_channels`)
WHERE `site_id` =  '1'
ORDER BY `channel_title`
     56 Query SELECT `module_id`
FROM (`exp_module_member_groups`)
WHERE `group_id` =  '1'
     56 Query SELECT `template_group_id`
FROM (`exp_template_member_groups`)
WHERE `group_id` =  '1'
     56 Query SELECT `site_id`, `site_label`
FROM (`exp_sites`)
ORDER BY `site_label`
     56 Query UPDATE `exp_sessions` SET `session_id` = 'a14a81080fbe35b6b1f153ddff5f572eeee0ea14', `member_id` = 2, `admin_sess` = 1, `ip_address` = '127.0.0.1', `user_agent` = 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_3) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.57 Safari/537.17', `last_activity` = 1366833649 WHERE session_id ='a14a81080fbe35b6b1f153ddff5f572eeee0ea14'
     56 Query SELECT `field_id`
FROM (`exp_channel_fields`)
     56 Query SHOW COLUMNS FROM `exp_publisher_data`
     56 Query SELECT `field_id`
FROM (`exp_category_fields`)
     56 Query SHOW COLUMNS FROM `exp_publisher_categories`
     56 Query SELECT `name`
FROM (`exp_fieldtypes`)
     56 Query SHOW TABLES FROM `telx_local`
     56 Query SHOW COLUMNS FROM `exp_matrix_data`
     56 Query SHOW COLUMNS FROM `exp_playa_relationships`
     56 Query SHOW COLUMNS FROM `exp_assets_selections`
     56 Query SELECT *
FROM (`exp_fieldtypes`)
     56 Query SELECT `col_type`, `col_id`, `field_id`
FROM (`exp_matrix_cols`)
     56 Query SELECT `startpage`, `hide_sidebar`
FROM (`exp_zoo_flexible_admin_menus`)
WHERE `group_id` =  '1'
AND `site_id` =  '1'
     55 Query SELECT *
FROM (`exp_publisher_settings`)
     55 Query SELECT *
FROM (`exp_publisher_languages`)
ORDER BY `is_default` desc, `long_name` asc
     55 Query SELECT `id`
FROM (`exp_publisher_languages`)
WHERE `is_default` =  'y'
     56 Quit 
     55 Query SELECT LOWER(module_name) AS module_name, module_version, has_cp_backend, module_id
FROM (`exp_modules`)
     61 Connect root@localhost on 
     61 Init DB telx_local
     61 Query SET NAMES utf8
     61 Query SELECT *
FROM (`exp_sites`)
WHERE `site_id` =  1
     55 Query SELECT module_id FROM exp_modules WHERE module_name = 'Structure'
     55 Query SELECT var_value, var FROM exp_structure_settings WHERE site_id IN (0,1)
     61 Query SELECT DISTINCT ee.* FROM exp_extensions ee WHERE enabled = 'y' ORDER BY hook, priority ASC, class
     55 Query SELECT `member_id`, `admin_sess`, `last_activity`
FROM (`exp_sessions`)
WHERE `session_id` =  'a14a81080fbe35b6b1f153ddff5f572eeee0ea14'
AND `user_agent` =  'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_3) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.57 Safari/537.17'
     55 Query SELECT *
FROM (`exp_members` m, `exp_member_groups` g)
WHERE `g`.`site_id` =  1
AND m.group_id =  g.group_id
AND `member_id` =  2
     55 Query SELECT `channel_id`, `channel_title`
FROM (`exp_channels`)
WHERE `site_id` =  '1'
ORDER BY `channel_title`
     55 Query SELECT `module_id`
FROM (`exp_module_member_groups`)
WHERE `group_id` =  '1'
     55 Query SELECT `template_group_id`
FROM (`exp_template_member_groups`)
WHERE `group_id` =  '1'
     55 Query SELECT `site_id`, `site_label`
FROM (`exp_sites`)
ORDER BY `site_label`
     55 Query UPDATE `exp_sessions` SET `session_id` = 'a14a81080fbe35b6b1f153ddff5f572eeee0ea14', `member_id` = 2, `admin_sess` = 1, `ip_address` = '127.0.0.1', `user_agent` = 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_3) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.57 Safari/537.17', `last_activity` = 1366833649 WHERE session_id ='a14a81080fbe35b6b1f153ddff5f572eeee0ea14'
     55 Query SELECT `field_id`
FROM (`exp_channel_fields`)
     55 Query SHOW COLUMNS FROM `exp_publisher_data`
     55 Query SELECT `field_id`
FROM (`exp_category_fields`)
     55 Query SHOW COLUMNS FROM `exp_publisher_categories`
     55 Query SELECT `name`
FROM (`exp_fieldtypes`)
     55 Query SHOW TABLES FROM `telx_local`
     55 Query SHOW COLUMNS FROM `exp_matrix_data`
     55 Query SHOW COLUMNS FROM `exp_playa_relationships`
     55 Query SHOW COLUMNS FROM `exp_assets_selections`
     55 Query SELECT *
FROM (`exp_fieldtypes`)
     55 Query SELECT `col_type`, `col_id`, `field_id`
FROM (`exp_matrix_cols`)
     55 Query SELECT `startpage`, `hide_sidebar`
FROM (`exp_zoo_flexible_admin_menus`)
WHERE `group_id` =  '1'
AND `site_id` =  '1'
     58 Query SELECT *
FROM (`exp_publisher_settings`)
     58 Query SELECT *
FROM (`exp_publisher_languages`)
ORDER BY `is_default` desc, `long_name` asc
     58 Query SELECT `id`
FROM (`exp_publisher_languages`)
WHERE `is_default` =  'y'
     55 Quit 
     58 Query SELECT LOWER(module_name) AS module_name, module_version, has_cp_backend, module_id
FROM (`exp_modules`)
     62 Connect root@localhost on 
     62 Init DB telx_local
     62 Query SET NAMES utf8
     62 Query SELECT *
FROM (`exp_sites`)
WHERE `site_id` =  1
     58 Query SELECT module_id FROM exp_modules WHERE module_name = 'Structure'
     58 Query SELECT var_value, var FROM exp_structure_settings WHERE site_id IN (0,1)
     62 Query SELECT DISTINCT ee.* FROM exp_extensions ee WHERE enabled = 'y' ORDER BY hook, priority ASC, class
     58 Query SELECT `member_id`, `admin_sess`, `last_activity`
FROM (`exp_sessions`)
WHERE `session_id` =  'a14a81080fbe35b6b1f153ddff5f572eeee0ea14'
AND `user_agent` =  'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_3) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.57 Safari/537.17'
     58 Query SELECT *
FROM (`exp_members` m, `exp_member_groups` g)
WHERE `g`.`site_id` =  1
AND m.group_id =  g.group_id
AND `member_id` =  2
     58 Query SELECT `channel_id`, `channel_title`
FROM (`exp_channels`)
WHERE `site_id` =  '1'
ORDER BY `channel_title`
     58 Query SELECT `module_id`
FROM (`exp_module_member_groups`)
WHERE `group_id` =  '1'
     58 Query SELECT `template_group_id`
FROM (`exp_template_member_groups`)
WHERE `group_id` =  '1'
     58 Query SELECT `site_id`, `site_label`
FROM (`exp_sites`)
ORDER BY `site_label`
     58 Query UPDATE `exp_sessions` SET `session_id` = 'a14a81080fbe35b6b1f153ddff5f572eeee0ea14', `member_id` = 2, `admin_sess` = 1, `ip_address` = '127.0.0.1', `user_agent` = 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_3) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.57 Safari/537.17', `last_activity` = 1366833649 WHERE session_id ='a14a81080fbe35b6b1f153ddff5f572eeee0ea14'
     58 Query SELECT `field_id`
FROM (`exp_channel_fields`)
     58 Query SHOW COLUMNS FROM `exp_publisher_data`
     58 Query SELECT `field_id`
FROM (`exp_category_fields`)
     58 Query SHOW COLUMNS FROM `exp_publisher_categories`
     58 Query SELECT `name`
FROM (`exp_fieldtypes`)
     58 Query SHOW TABLES FROM `telx_local`
     58 Query SHOW COLUMNS FROM `exp_matrix_data`
     58 Query SHOW COLUMNS FROM `exp_playa_relationships`
     58 Query SHOW COLUMNS FROM `exp_assets_selections`
     58 Query SELECT *
FROM (`exp_fieldtypes`)
     58 Query SELECT `col_type`, `col_id`, `field_id`
FROM (`exp_matrix_cols`)
     58 Query SELECT `startpage`, `hide_sidebar`
FROM (`exp_zoo_flexible_admin_menus`)
WHERE `group_id` =  '1'
AND `site_id` =  '1'
     58 Query SELECT `nav`, `autopopulate`, `hide_sidebar`
FROM (`exp_zoo_flexible_admin_menus`)
WHERE `group_id` =  '1'
AND `site_id` =  '1'
     58 Query SELECT `exp_modules`.`module_name`
FROM (`exp_modules`, `exp_module_member_groups`)
WHERE `exp_module_member_groups`.`group_id` =  '1'
AND exp_modules.module_id = exp_module_member_groups.module_id
AND `exp_modules`.`module_name` =  'Zenbu'
     58 Query SELECT `channel_title`, `channel_name`, `channel_id`, `cat_group`, `status_group`, `field_group`
FROM (`exp_channels`)
WHERE `site_id` =  '1'
ORDER BY `channel_title`
     58 Query SELECT `channel_title`, `channel_name`, `channel_id`, `cat_group`, `status_group`, `field_group`
FROM (`exp_channels`)
WHERE `site_id` =  '1'
ORDER BY `channel_title`
     58 Query SELECT module_name FROM exp_modules WHERE has_cp_backend = "y" ORDER BY module_name
     58 Quit 
     57 Query SELECT *
FROM (`exp_publisher_settings`)
     57 Query SELECT *
FROM (`exp_publisher_languages`)
ORDER BY `is_default` desc, `long_name` asc
     57 Query SELECT `id`
FROM (`exp_publisher_languages`)
WHERE `is_default` =  'y'
130424 16:00:51    57 Query SELECT LOWER(module_name) AS module_name, module_version, has_cp_backend, module_id
FROM (`exp_modules`)
     63 Connect root@localhost on 
     63 Init DB telx_local
     63 Query SET NAMES utf8
     63 Query SELECT *
FROM (`exp_sites`)
WHERE `site_id` =  1
     57 Query SELECT module_id FROM exp_modules WHERE module_name = 'Structure'
     57 Query SELECT var_value, var FROM exp_structure_settings WHERE site_id IN (0,1)
     63 Query SELECT DISTINCT ee.* FROM exp_extensions ee WHERE enabled = 'y' ORDER BY hook, priority ASC, class
     57 Query SELECT `member_id`, `admin_sess`, `last_activity`
FROM (`exp_sessions`)
WHERE `session_id` =  'a14a81080fbe35b6b1f153ddff5f572eeee0ea14'
AND `user_agent` =  'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_3) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.57 Safari/537.17'
     57 Query SELECT *
FROM (`exp_members` m, `exp_member_groups` g)
WHERE `g`.`site_id` =  1
AND m.group_id =  g.group_id
AND `member_id` =  2
     57 Query SELECT `channel_id`, `channel_title`
FROM (`exp_channels`)
WHERE `site_id` =  '1'
ORDER BY `channel_title`
     57 Query SELECT `module_id`
FROM (`exp_module_member_groups`)
WHERE `group_id` =  '1'
     57 Query SELECT `template_group_id`
FROM (`exp_template_member_groups`)
WHERE `group_id` =  '1'
     57 Query SELECT `site_id`, `site_label`
FROM (`exp_sites`)
ORDER BY `site_label`
     57 Query UPDATE `exp_sessions` SET `session_id` = 'a14a81080fbe35b6b1f153ddff5f572eeee0ea14', `member_id` = 2, `admin_sess` = 1, `ip_address` = '127.0.0.1', `user_agent` = 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_3) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.57 Safari/537.17', `last_activity` = 1366833649 WHERE session_id ='a14a81080fbe35b6b1f153ddff5f572eeee0ea14'
     57 Query SELECT `field_id`
FROM (`exp_channel_fields`)
     57 Query SHOW COLUMNS FROM `exp_publisher_data`
     57 Query SELECT `field_id`
FROM (`exp_category_fields`)
     57 Query SHOW COLUMNS FROM `exp_publisher_categories`
     57 Query SELECT `name`
FROM (`exp_fieldtypes`)
     57 Query SHOW TABLES FROM `telx_local`
     57 Query SHOW COLUMNS FROM `exp_matrix_data`
     57 Query SHOW COLUMNS FROM `exp_playa_relationships`
     57 Query SHOW COLUMNS FROM `exp_assets_selections`
     57 Query SELECT *
FROM (`exp_fieldtypes`)
     57 Query SELECT `col_type`, `col_id`, `field_id`
FROM (`exp_matrix_cols`)
     57 Query SELECT `startpage`, `hide_sidebar`
FROM (`exp_zoo_flexible_admin_menus`)
WHERE `group_id` =  '1'
AND `site_id` =  '1'
     59 Query SELECT *
FROM (`exp_publisher_settings`)
     59 Query SELECT *
FROM (`exp_publisher_languages`)
ORDER BY `is_default` desc, `long_name` asc
     59 Query SELECT `id`
FROM (`exp_publisher_languages`)
WHERE `is_default` =  'y'
     57 Quit 
     59 Query SELECT LOWER(module_name) AS module_name, module_version, has_cp_backend, module_id
FROM (`exp_modules`)
     59 Query SELECT module_id FROM exp_modules WHERE module_name = 'Structure'
     59 Query SELECT var_value, var FROM exp_structure_settings WHERE site_id IN (0,1)
     59 Query SELECT `member_id`, `admin_sess`, `last_activity`
FROM (`exp_sessions`)
WHERE `session_id` =  'a14a81080fbe35b6b1f153ddff5f572eeee0ea14'
AND `user_agent` =  'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_3) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.57 Safari/537.17'
     59 Query SELECT *
FROM (`exp_members` m, `exp_member_groups` g)
WHERE `g`.`site_id` =  1
AND m.group_id =  g.group_id
AND `member_id` =  2
     59 Query SELECT `channel_id`, `channel_title`
FROM (`exp_channels`)
WHERE `site_id` =  '1'
ORDER BY `channel_title`
     59 Query SELECT `module_id`
FROM (`exp_module_member_groups`)
WHERE `group_id` =  '1'
     59 Query SELECT `template_group_id`
FROM (`exp_template_member_groups`)
WHERE `group_id` =  '1'
     59 Query SELECT `site_id`, `site_label`
FROM (`exp_sites`)
ORDER BY `site_label`
     59 Query UPDATE `exp_sessions` SET `session_id` = 'a14a81080fbe35b6b1f153ddff5f572eeee0ea14', `member_id` = 2, `admin_sess` = 1, `ip_address` = '127.0.0.1', `user_agent` = 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_3) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.57 Safari/537.17', `last_activity` = 1366833649 WHERE session_id ='a14a81080fbe35b6b1f153ddff5f572eeee0ea14'
     59 Query SELECT `field_id`
FROM (`exp_channel_fields`)
     59 Query SHOW COLUMNS FROM `exp_publisher_data`
     59 Query SELECT `field_id`
FROM (`exp_category_fields`)
     59 Query SHOW COLUMNS FROM `exp_publisher_categories`
     59 Query SELECT `name`
FROM (`exp_fieldtypes`)
     59 Query SHOW TABLES FROM `telx_local`
     59 Query SHOW COLUMNS FROM `exp_matrix_data`
     59 Query SHOW COLUMNS FROM `exp_playa_relationships`
     59 Query SHOW COLUMNS FROM `exp_assets_selections`
     59 Query SELECT *
FROM (`exp_fieldtypes`)
     59 Query SELECT `col_type`, `col_id`, `field_id`
FROM (`exp_matrix_cols`)
     59 Query SELECT `startpage`, `hide_sidebar`
FROM (`exp_zoo_flexible_admin_menus`)
WHERE `group_id` =  '1'
AND `site_id` =  '1'
     59 Query SELECT `nav`, `autopopulate`, `hide_sidebar`
FROM (`exp_zoo_flexible_admin_menus`)
WHERE `group_id` =  '1'
AND `site_id` =  '1'
     59 Quit 
     60 Query SELECT *
FROM (`exp_publisher_settings`)
     60 Query SELECT *
FROM (`exp_publisher_languages`)
ORDER BY `is_default` desc, `long_name` asc
     60 Query SELECT `id`
FROM (`exp_publisher_languages`)
WHERE `is_default` =  'y'
     60 Query SELECT LOWER(module_name) AS module_name, module_version, has_cp_backend, module_id
FROM (`exp_modules`)
     60 Query SELECT module_id FROM exp_modules WHERE module_name = 'Structure'
     60 Query SELECT var_value, var FROM exp_structure_settings WHERE site_id IN (0,1)
     60 Query SELECT `member_id`, `admin_sess`, `last_activity`
FROM (`exp_sessions`)
WHERE `session_id` =  'a14a81080fbe35b6b1f153ddff5f572eeee0ea14'
AND `user_agent` =  'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_3) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.57 Safari/537.17'
     60 Query SELECT *
FROM (`exp_members` m, `exp_member_groups` g)
WHERE `g`.`site_id` =  1
AND m.group_id =  g.group_id
AND `member_id` =  2
     60 Query SELECT `channel_id`, `channel_title`
FROM (`exp_channels`)
WHERE `site_id` =  '1'
ORDER BY `channel_title`
     60 Query SELECT `module_id`
FROM (`exp_module_member_groups`)
WHERE `group_id` =  '1'
     60 Query SELECT `template_group_id`
FROM (`exp_template_member_groups`)
WHERE `group_id` =  '1'
     60 Query SELECT `site_id`, `site_label`
FROM (`exp_sites`)
ORDER BY `site_label`
     60 Query UPDATE `exp_sessions` SET `session_id` = 'a14a81080fbe35b6b1f153ddff5f572eeee0ea14', `member_id` = 2, `admin_sess` = 1, `ip_address` = '127.0.0.1', `user_agent` = 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_3) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.57 Safari/537.17', `last_activity` = 1366833650 WHERE session_id ='a14a81080fbe35b6b1f153ddff5f572eeee0ea14'
     60 Query SELECT `field_id`
FROM (`exp_channel_fields`)
     60 Query SHOW COLUMNS FROM `exp_publisher_data`
     60 Query SELECT `field_id`
FROM (`exp_category_fields`)
     60 Query SHOW COLUMNS FROM `exp_publisher_categories`
     60 Query SELECT `name`
FROM (`exp_fieldtypes`)
     60 Query SHOW TABLES FROM `telx_local`
     60 Query SHOW COLUMNS FROM `exp_matrix_data`
     60 Query SHOW COLUMNS FROM `exp_playa_relationships`
     60 Query SHOW COLUMNS FROM `exp_assets_selections`
     60 Query SELECT *
FROM (`exp_fieldtypes`)
     60 Query SELECT `col_type`, `col_id`, `field_id`
FROM (`exp_matrix_cols`)
     60 Query SELECT `startpage`, `hide_sidebar`
FROM (`exp_zoo_flexible_admin_menus`)
WHERE `group_id` =  '1'
AND `site_id` =  '1'
     61 Query SELECT *
FROM (`exp_publisher_settings`)
     60 Quit 
     61 Query SELECT *
FROM (`exp_publisher_languages`)
ORDER BY `is_default` desc, `long_name` asc
     61 Query SELECT `id`
FROM (`exp_publisher_languages`)
WHERE `is_default` =  'y'
     61 Query SELECT LOWER(module_name) AS module_name, module_version, has_cp_backend, module_id
FROM (`exp_modules`)
     64 Connect root@localhost on 
     64 Init DB telx_local
     64 Query SET NAMES utf8
     64 Query SELECT *
FROM (`exp_sites`)
WHERE `site_id` =  1
     61 Query SELECT module_id FROM exp_modules WHERE module_name = 'Structure'
     61 Query SELECT var_value, var FROM exp_structure_settings WHERE site_id IN (0,1)
     64 Query SELECT DISTINCT ee.* FROM exp_extensions ee WHERE enabled = 'y' ORDER BY hook, priority ASC, class
     61 Query SELECT `member_id`, `admin_sess`, `last_activity`
FROM (`exp_sessions`)
WHERE `session_id` =  'a14a81080fbe35b6b1f153ddff5f572eeee0ea14'
AND `user_agent` =  'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_3) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.57 Safari/537.17'
     61 Query SELECT *
FROM (`exp_members` m, `exp_member_groups` g)
WHERE `g`.`site_id` =  1
AND m.group_id =  g.group_id
AND `member_id` =  2
     61 Query SELECT `channel_id`, `channel_title`
FROM (`exp_channels`)
WHERE `site_id` =  '1'
ORDER BY `channel_title`
     61 Query SELECT `module_id`
FROM (`exp_module_member_groups`)
WHERE `group_id` =  '1'
     61 Query SELECT `template_group_id`
FROM (`exp_template_member_groups`)
WHERE `group_id` =  '1'
     61 Query SELECT `site_id`, `site_label`
FROM (`exp_sites`)
ORDER BY `site_label`
     61 Query UPDATE `exp_sessions` SET `session_id` = 'a14a81080fbe35b6b1f153ddff5f572eeee0ea14', `member_id` = 2, `admin_sess` = 1, `ip_address` = '127.0.0.1', `user_agent` = 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_3) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.57 Safari/537.17', `last_activity` = 1366833650 WHERE session_id ='a14a81080fbe35b6b1f153ddff5f572eeee0ea14'
     61 Query SELECT `field_id`
FROM (`exp_channel_fields`)
     61 Query SHOW COLUMNS FROM `exp_publisher_data`
     61 Query SELECT `field_id`
FROM (`exp_category_fields`)
     61 Query SHOW COLUMNS FROM `exp_publisher_categories`
     61 Query SELECT `name`
FROM (`exp_fieldtypes`)
     61 Query SHOW TABLES FROM `telx_local`
     61 Query SHOW COLUMNS FROM `exp_matrix_data`
     61 Query SHOW COLUMNS FROM `exp_playa_relationships`
     61 Query SHOW COLUMNS FROM `exp_assets_selections`
     61 Query SELECT *
FROM (`exp_fieldtypes`)
     61 Query SELECT `col_type`, `col_id`, `field_id`
FROM (`exp_matrix_cols`)
     61 Query SELECT `startpage`, `hide_sidebar`
FROM (`exp_zoo_flexible_admin_menus`)
WHERE `group_id` =  '1'
AND `site_id` =  '1'
     62 Query SELECT *
FROM (`exp_publisher_settings`)
     62 Query SELECT *
FROM (`exp_publisher_languages`)
ORDER BY `is_default` desc, `long_name` asc
     62 Query SELECT `id`
FROM (`exp_publisher_languages`)
WHERE `is_default` =  'y'
     61 Quit 
130424 16:00:52    62 Query SELECT LOWER(module_name) AS module_name, module_version, has_cp_backend, module_id
FROM (`exp_modules`)
     62 Query SELECT module_id FROM exp_modules WHERE module_name = 'Structure'
     62 Query SELECT var_value, var FROM exp_structure_settings WHERE site_id IN (0,1)
     62 Query SELECT `member_id`, `admin_sess`, `last_activity`
FROM (`exp_sessions`)
WHERE `session_id` =  'a14a81080fbe35b6b1f153ddff5f572eeee0ea14'
AND `user_agent` =  'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_3) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.57 Safari/537.17'
     62 Query SELECT *
FROM (`exp_members` m, `exp_member_groups` g)
WHERE `g`.`site_id` =  1
AND m.group_id =  g.group_id
AND `member_id` =  2
     62 Query SELECT `channel_id`, `channel_title`
FROM (`exp_channels`)
WHERE `site_id` =  '1'
ORDER BY `channel_title`
     62 Query SELECT `module_id`
FROM (`exp_module_member_groups`)
WHERE `group_id` =  '1'
     62 Query SELECT `template_group_id`
FROM (`exp_template_member_groups`)
WHERE `group_id` =  '1'
     62 Query SELECT `site_id`, `site_label`
FROM (`exp_sites`)
ORDER BY `site_label`
     62 Query UPDATE `exp_sessions` SET `session_id` = 'a14a81080fbe35b6b1f153ddff5f572eeee0ea14', `member_id` = 2, `admin_sess` = 1, `ip_address` = '127.0.0.1', `user_agent` = 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_3) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.57 Safari/537.17', `last_activity` = 1366833650 WHERE session_id ='a14a81080fbe35b6b1f153ddff5f572eeee0ea14'
     62 Query SELECT `field_id`
FROM (`exp_channel_fields`)
     62 Query SHOW COLUMNS FROM `exp_publisher_data`
     62 Query SELECT `field_id`
FROM (`exp_category_fields`)
     62 Query SHOW COLUMNS FROM `exp_publisher_categories`
     62 Query SELECT `name`
FROM (`exp_fieldtypes`)
     62 Query SHOW TABLES FROM `telx_local`
     62 Query SHOW COLUMNS FROM `exp_matrix_data`
     62 Query SHOW COLUMNS FROM `exp_playa_relationships`
     62 Query SHOW COLUMNS FROM `exp_assets_selections`
     62 Query SELECT *
FROM (`exp_fieldtypes`)
     62 Query SELECT `col_type`, `col_id`, `field_id`
FROM (`exp_matrix_cols`)
     62 Query SELECT `startpage`, `hide_sidebar`
FROM (`exp_zoo_flexible_admin_menus`)
WHERE `group_id` =  '1'
AND `site_id` =  '1'
     63 Query SELECT *
FROM (`exp_publisher_settings`)
     63 Query SELECT *
FROM (`exp_publisher_languages`)
ORDER BY `is_default` desc, `long_name` asc
     63 Query SELECT `id`
FROM (`exp_publisher_languages`)
WHERE `is_default` =  'y'
     62 Quit 
     63 Query SELECT LOWER(module_name) AS module_name, module_version, has_cp_backend, module_id
FROM (`exp_modules`)
     63 Query SELECT module_id FROM exp_modules WHERE module_name = 'Structure'
     63 Query SELECT var_value, var FROM exp_structure_settings WHERE site_id IN (0,1)
     63 Query SELECT `member_id`, `admin_sess`, `last_activity`
FROM (`exp_sessions`)
WHERE `session_id` =  'a14a81080fbe35b6b1f153ddff5f572eeee0ea14'
AND `user_agent` =  'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_3) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.57 Safari/537.17'
     63 Query SELECT *
FROM (`exp_members` m, `exp_member_groups` g)
WHERE `g`.`site_id` =  1
AND m.group_id =  g.group_id
AND `member_id` =  2
     63 Query SELECT `channel_id`, `channel_title`
FROM (`exp_channels`)
WHERE `site_id` =  '1'
ORDER BY `channel_title`
     63 Query SELECT `module_id`
FROM (`exp_module_member_groups`)
WHERE `group_id` =  '1'
     63 Query SELECT `template_group_id`
FROM (`exp_template_member_groups`)
WHERE `group_id` =  '1'
     63 Query SELECT `site_id`, `site_label`
FROM (`exp_sites`)
ORDER BY `site_label`
     63 Query UPDATE `exp_sessions` SET `session_id` = 'a14a81080fbe35b6b1f153ddff5f572eeee0ea14', `member_id` = 2, `admin_sess` = 1, `ip_address` = '127.0.0.1', `user_agent` = 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_3) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.57 Safari/537.17', `last_activity` = 1366833651 WHERE session_id ='a14a81080fbe35b6b1f153ddff5f572eeee0ea14'
     63 Query SELECT `field_id`
FROM (`exp_channel_fields`)
     63 Query SHOW COLUMNS FROM `exp_publisher_data`
     63 Query SELECT `field_id`
FROM (`exp_category_fields`)
     63 Query SHOW COLUMNS FROM `exp_publisher_categories`
     63 Query SELECT `name`
FROM (`exp_fieldtypes`)
     63 Query SHOW TABLES FROM `telx_local`
     63 Query SHOW COLUMNS FROM `exp_matrix_data`
     63 Query SHOW COLUMNS FROM `exp_playa_relationships`
     63 Query SHOW COLUMNS FROM `exp_assets_selections`
     63 Query SELECT *
FROM (`exp_fieldtypes`)
     63 Query SELECT `col_type`, `col_id`, `field_id`
FROM (`exp_matrix_cols`)
     63 Query SELECT `startpage`, `hide_sidebar`
FROM (`exp_zoo_flexible_admin_menus`)
WHERE `group_id` =  '1'
AND `site_id` =  '1'
     64 Query SELECT *
FROM (`exp_publisher_settings`)
     64 Query SELECT *
FROM (`exp_publisher_languages`)
ORDER BY `is_default` desc, `long_name` asc
     64 Query SELECT `id`
FROM (`exp_publisher_languages`)
WHERE `is_default` =  'y'
     63 Quit 
     64 Query SELECT LOWER(module_name) AS module_name, module_version, has_cp_backend, module_id
FROM (`exp_modules`)
     64 Query SELECT module_id FROM exp_modules WHERE module_name = 'Structure'
     64 Query SELECT var_value, var FROM exp_structure_settings WHERE site_id IN (0,1)
     64 Query SELECT `member_id`, `admin_sess`, `last_activity`
FROM (`exp_sessions`)
WHERE `session_id` =  'a14a81080fbe35b6b1f153ddff5f572eeee0ea14'
AND `user_agent` =  'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_3) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.57 Safari/537.17'
     64 Query SELECT *
FROM (`exp_members` m, `exp_member_groups` g)
WHERE `g`.`site_id` =  1
AND m.group_id =  g.group_id
AND `member_id` =  2
     64 Query SELECT `channel_id`, `channel_title`
FROM (`exp_channels`)
WHERE `site_id` =  '1'
ORDER BY `channel_title`
     64 Query SELECT `module_id`
FROM (`exp_module_member_groups`)
WHERE `group_id` =  '1'
     64 Query SELECT `template_group_id`
FROM (`exp_template_member_groups`)
WHERE `group_id` =  '1'
     64 Query SELECT `site_id`, `site_label`
FROM (`exp_sites`)
ORDER BY `site_label`
     64 Query UPDATE `exp_sessions` SET `session_id` = 'a14a81080fbe35b6b1f153ddff5f572eeee0ea14', `member_id` = 2, `admin_sess` = 1, `ip_address` = '127.0.0.1', `user_agent` = 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_3) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.57 Safari/537.17', `last_activity` = 1366833651 WHERE session_id ='a14a81080fbe35b6b1f153ddff5f572eeee0ea14'
     64 Query SELECT `field_id`
FROM (`exp_channel_fields`)
     64 Query SHOW COLUMNS FROM `exp_publisher_data`
     64 Query SELECT `field_id`
FROM (`exp_category_fields`)
     64 Query SHOW COLUMNS FROM `exp_publisher_categories`
     64 Query SELECT `name`
FROM (`exp_fieldtypes`)
     64 Query SHOW TABLES FROM `telx_local`
     64 Query SHOW COLUMNS FROM `exp_matrix_data`
     64 Query SHOW COLUMNS FROM `exp_playa_relationships`
     64 Query SHOW COLUMNS FROM `exp_assets_selections`
     64 Query SELECT *
FROM (`exp_fieldtypes`)
     64 Query SELECT `col_type`, `col_id`, `field_id`
FROM (`exp_matrix_cols`)
     64 Query SELECT `startpage`, `hide_sidebar`
FROM (`exp_zoo_flexible_admin_menus`)
WHERE `group_id` =  '1'
AND `site_id` =  '1'
     64 Query INSERT INTO `exp_security_hashes` (`date`, `hash`, `session_id`) VALUES (1366833651,'1513974f0cef0dab54f80199654dbe9fdcd8cdb2','a14a81080fbe35b6b1f153ddff5f572eeee0ea14')
     64 Query SELECT `screen_name`, `notepad`, `quick_links`, `avatar_filename`, `avatar_width`, `avatar_height`
FROM (`exp_members`)
WHERE `member_id` =  2
     64 Query SELECT `channel_title`, `channel_name`, `channel_id`, `cat_group`, `status_group`, `field_group`
FROM (`exp_channels`)
WHERE `site_id` =  '1'
ORDER BY `channel_title`
     64 Query SELECT *
FROM (`exp_template_groups`)
WHERE `site_id` =  '1'
ORDER BY `group_order`, `group_name` ASC
     64 Query SELECT `exp_template_groups`.`group_id`, `template_id`, `template_name`, `group_name`
FROM (`exp_templates`)
JOIN `exp_template_groups` ON `exp_templates`.`group_id` = `exp_template_groups`.`group_id`
WHERE `exp_templates`.`site_id` =  '1'
ORDER BY `group_name`, `template_name`
     64 Query SELECT *
FROM (`exp_field_groups`)
WHERE `site_id` =  '1'
ORDER BY `group_name` asc
     64 Query SELECT *
FROM (`exp_accessories`)
     64 Query SELECT *
FROM (`exp_publisher_languages`)
ORDER BY `is_default` desc, `long_name` asc
     64 Query SELECT `id`
FROM (`exp_publisher_languages`)
WHERE `is_default` =  'y'
     64 Query SELECT *
FROM (`exp_publisher_approvals`)
WHERE `type` =  'entry'
ORDER BY `date` desc
LIMIT 20
     64 Query SELECT *
FROM (`exp_publisher_approvals`)
WHERE `type` =  'phrase'
ORDER BY `date` desc
LIMIT 20
     64 Query SELECT *
FROM (`exp_publisher_approvals`)
WHERE `type` =  'category'
ORDER BY `date` desc
LIMIT 20
     64 Query SELECT COUNT(*) AS `numrows`
FROM (`exp_publisher_approvals`)
     64 Query SELECT module_id FROM exp_modules WHERE module_name = 'Structure'
     64 Query SELECT ec.channel_id, ec.channel_title, esc.template_id, esc.type, ec.site_id
    FROM exp_channels AS ec 
    LEFT JOIN exp_structure_channels AS esc ON ec.channel_id = esc.channel_id
    WHERE ec.site_id = '1' AND esc.type = 'asset'
     64 Query SELECT * FROM exp_extensions WHERE class = 'Switchboard_ext' LIMIT 1
     64 Query SELECT cp_theme FROM exp_members WHERE member_id = '2' AND cp_theme != '' LIMIT 1
     64 Query SELECT *
FROM (`exp_switchboard_recent`)
WHERE `member_id` =  2
ORDER BY `date` desc
     64 Query SELECT
    fg.group_id,
    fg.group_name,
    cf.field_id,
    cf.field_label,
    cf.field_order,
    cf.field_name,
    cf.field_type
   FROM
    exp_field_groups fg
   LEFT JOIN
    exp_channel_fields cf
   ON fg.group_id = cf.group_id
   WHERE fg.site_id='1'
   ORDER BY cf.field_order, fg.group_name ASC
     64 Query SELECT snippet_id, snippet_name FROM exp_snippets
     64 Query SELECT variable_id, variable_name FROM exp_global_variables
     64 Query SELECT `group_id`, `group_title`
FROM (`exp_member_groups`)
WHERE `site_id` =  '1'
AND `group_id` NOT IN (2, 3, 4) 
ORDER BY `group_id`
#1

BoldMinded (Brian)

What page can I load to see it happen?

#2

BoldMinded (Brian)

Oh, I see Publisher isn’t installed. Can I install it or do you want to?

#3

Timothy Kelty

Go for it.

#4

Timothy Kelty

I turned on profiling for another request and resulted in:

Loading Time: Base Classes 0.0240 Total Execution Time 62.1578 Controller Execution Time ( Content Edit / Index ) 62.1350

Last query was executed at 0.0006, so it doesn’t seem like mysql.

#5

Timothy Kelty

It’s been ANY page for me. Sometimes a reload of a page that you’ve already loaded doesn’t take as long, presumably it’s cached.

#6

Timothy Kelty

And my bad, it looks like i have 0.98.6 on there. I can deploy 0.98.7 if you think it’ll help.

#7

BoldMinded (Brian)

yeah, lets go to the latest before I dig too deep into this.

#8

Timothy Kelty

ok $config[‘allow_extensions’] = ‘n’; also fixes it, so locally I’m going to go through and disable addons to see if its a conflict.

#9

BoldMinded (Brian)

Sounds good. Yeah, this is definitely new to me. I’ve tested on 2 different computers and haven’t seen any issues like this. There are a lot of queries, but I’m using the session object to prevent excessive querying. There is no persistent caching though.

#10

Timothy Kelty

Ok, I updated to the latest, but I had to uninstall again so the CP is usable.

I’ll set up a dev site for you to test on shortly.

#11

BoldMinded (Brian)

Will you be able to provide FTP?

#12

BoldMinded (Brian)

Another idea. Can you zip the whole site and .sql file and send it to me so I can setup locally? Just to try another environment?

#13

Timothy Kelty

Brian, I narrowed it down to:

if ( ! session_id())
        {
            session_start();
        }

in the sessions_start method of ext.publisher.php

If I comment those lines out, the CP is back to normal.

I haven’t seen anyone else (but you, in Custom System Messages) manually start a session in the sessions_start class. As a test I also installed CSM and had the same result.

Funky huh? Wonder why it’s only a problem for me!?

#14

BoldMinded (Brian)

Transcribe does that too. I had to add that check b/c if I remember correctly during the installation process $_SESSION didn’t yet exist for some reason. If things work fine for you having that commented out then I would say roll with it. I can look into possible reasons why that would slow it down for you and not anyone else (that I know of thus far).

#15

Timothy Kelty

After some googling (“php slow session_start”), it seems like it’s a rather common problem. Sounds like it has to do with the session write file being locked, perhaps.

I’ve found that I can leave the session_start in, and add session_write_close(); right at the end of that method, and the slowdown is also prevented.

#16

Timothy Kelty

I tested on a bare/vanilla 2.6 install of EE and just publisher and had no issues. It may be somehow related to my config bootstrap. I’ll let you know if I find anything else.

#17

Timothy Kelty

I just emailed you a link to the zipped up site/sql.

Thanks for your help!

#18

BoldMinded (Brian)

Tim, I’m going to close this as I haven’t seen any similar type reports, and in the next release I actually added @ to surpress any errors from session_start(), even though that is frowned upon, which I think will fix/prevent the file lock issues(?).

#19

Timothy Kelty

That’s cool.

It’s a mystery, I just had it come up with another site too (that was using CSM). The strangest part is that it’s happening in 2 very different environments (local/MAMP, remote/ubuntu).

I’m thinking something isn’t playing nicely with my bootstrap setup. I’ll let you know if I find anything out.

Unfortunately suppression doesn’t fix it.

#20

Timothy Kelty

Aghhhhh!

It was NSM Addon Updater all along! Must be doing some sort of fread() with no timeout or something. I didn’t look at the code b/c I knew it would just make me mad.

Anyway, I don’t need it, so I just removed it.

I tried disabling every module and extension, but I didn’t even think about accessories!

Login to reply