Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 27 Queries Logged
- SELECT `data`
- FROM `tnzet_session`
- WHERE `session_id` = '14v7391onuimsek6dgf2nuslb2'
- SELECT folder AS type, element AS name, params
- FROM tnzet_extensions
- WHERE enabled >= 1
- AND type ='plugin'
- AND state >= 0
- AND access IN (1,1,2,3)
- ORDER BY ordering
- SELECT extension_id AS "id", element AS "option", params, enabled
- FROM tnzet_extensions
- WHERE `type` = 'component'
- AND `element` = 'com_languages'
- SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,m.language,e.element as component
- FROM tnzet_menu AS m
- LEFT JOIN tnzet_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.access IN (1,1,2,3)
- ORDER BY m.lft
- SELECT extension_id AS "id", element AS "option", params, enabled
- FROM tnzet_extensions
- WHERE `type` = 'component'
- AND `element` = 'com_comprofiler'
- SELECT *
- FROM tnzet_languages
- WHERE published=1
- ORDER BY ordering ASC
- SELECT id, home, template, s.params
- FROM tnzet_template_styles as s
- LEFT JOIN tnzet_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
- SELECT c.*, u.*
- FROM tnzet_users AS u
- LEFT JOIN tnzet_comprofiler AS c
- ON c.id = u.id
- WHERE u.id = 42
- SHOW FULL COLUMNS
- FROM `tnzet_users`
- SELECT *
- FROM tnzet_users
- WHERE id = 42
- SELECT g.id, g.title
- FROM tnzet_usergroups AS g JOIN tnzet_user_usergroup_map AS m
- ON m.group_id = g.id
- WHERE m.user_id = 42
- SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name
- FROM tnzet_comprofiler_plugin
- WHERE published = 1
- AND access <= 8
- AND type = 'user'
- ORDER BY ordering
- SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name
- FROM tnzet_comprofiler_plugin
- WHERE published = 1
- AND access <= 8
- AND type = 'templates'
- ORDER BY ordering
- SELECT `group_id`
- FROM `tnzet_user_usergroup_map`
- WHERE `user_id` = 42
- SELECT *
- FROM `tnzet_usergroups`
- ORDER BY `lft`
- SELECT *
- FROM `tnzet_usergroups`
- ORDER BY `lft`
- SELECT *
- FROM tnzet_comprofiler_tabs t
- WHERE t.enabled=1
- AND t.useraccessgroupid IN (1,2,3,4,5,6,7,8,-2,-1)
- ORDER BY t.position, t.ordering
- SELECT id
- FROM tnzet_menu
- WHERE link = 'index.php?option=com_comprofiler'
- AND published=1
- AND access <= 8
- SELECT f.*
- FROM tnzet_comprofiler_fields f
- INNER JOIN tnzet_comprofiler_tabs AS t
- ON (f.tabid = t.tabid)
- WHERE f.published = 1
- AND f.profile != 0
- AND t.enabled = 1
- AND t.useraccessgroupid IN (1,2,3,4,5,6,7,8,-2,-1)
- ORDER BY t.position, t.ordering, f.ordering
- SELECT MAX(time)
- FROM tnzet_session
- WHERE userid = 42
- AND guest = 0
- SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
- FROM tnzet_modules AS m
- LEFT JOIN tnzet_modules_menu AS mm
- ON mm.moduleid = m.id
- LEFT JOIN tnzet_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.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2011-08-04 04:07:26')
- AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2011-08-04 04:07:26')
- AND m.access IN (1,1,2,3)
- AND m.client_id = 0
- AND (mm.menuid = 110 OR mm.menuid <= 0)
- ORDER BY m.position, m.ordering
- SELECT *
- FROM tnzet_banners
- WHERE NOW() >= `reset`
- AND `reset` != '0000-00-00 00:00:00'
- AND `reset`!=NULL
- AND (`checked_out` = 0 OR `checked_out` = 0)
- SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
- FROM tnzet_banners as a
- LEFT JOIN tnzet_banner_clients AS cl
- ON cl.id = a.cid
- LEFT JOIN tnzet_categories as cat
- ON a.catid = cat.id
- WHERE a.state=1
- AND (NOW() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
- AND (NOW() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
- AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
- AND a.cid = 3
- AND cl.state = 1
- ORDER BY a.sticky DESC,a.ordering
- SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
- FROM tnzet_banners as a
- LEFT JOIN tnzet_banner_clients AS cl
- ON cl.id = a.cid
- LEFT JOIN tnzet_categories as cat
- ON a.catid = cat.id
- WHERE a.state=1
- AND (NOW() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
- AND (NOW() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
- AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
- AND a.cid = 3
- AND cl.state = 1
- ORDER BY a.sticky DESC,a.ordering
- LIMIT 0, 1
- SELECT extension_id AS "id", element AS "option", params, enabled
- FROM tnzet_extensions
- WHERE `type` = 'component'
- AND `element` = 'com_content'
- SELECT id
- FROM tnzet_menu
- WHERE link LIKE 'index.php?option=com_comprofiler&task=registers%'
- AND published=1
- AND access <= 8
- UPDATE `tnzet_session`
- SET `data` = '__default|a:7:{s:15:\"session.counter\";i:26;s:19:\"session.timer.start\";i:1312429871;s:18:\"session.timer.last\";i:1312430846;s:17:\"session.timer.now\";i:1312430846;s:22:\"session.client.browser\";s:70:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"42\";s:4:\"name\";s:10:\"Super User\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:13:\"[email protected]\";s:8:\"password\";s:65:\"d4fe2c57aa14dbc9f7342b3206b323df:k6Gnpx8MDYBluVvSMPdiPeBhWjPpvkyP\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2011-08-04 03:49:22\";s:13:\"lastvisitDate\";s:19:\"2011-08-04 03:49:28\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:0:\"\";s:6:\"groups\";a:1:{s:11:\"Super Users\";s:1:\"8\";}s:5:\"guest\";i:0;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{i:0;s:92:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}', `time` = 1312430846
- WHERE `session_id` = '14v7391onuimsek6dgf2nuslb2'
- 21 Query Types Logged, Sorted by Occurrences.
- SELECT Tables:
- 3 × SELECT extension_id AS "id", element AS "option", params, enabled FROM tnzet_extensions
- 2 × SELECT id FROM tnzet_menu
- 2 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions FROM tnzet_banners as a LEFT JOIN tnzet_banner_clients AS cl ON cl.id = a.cid LEFT JOIN tnzet_categories as cat ON a.catid = cat.id
- 2 × SELECT * FROM `tnzet_usergroups`
- 2 × SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name FROM tnzet_comprofiler_plugin
- 1 × SELECT f.* FROM tnzet_comprofiler_fields f INNER JOIN tnzet_comprofiler_tabs AS t ON (f.tabid = t.tabid)
- 1 × SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,m.language,e.element as component FROM tnzet_menu AS m LEFT JOIN tnzet_extensions AS e ON m.component_id = e.extension_id
- 1 × SELECT MAX(time) FROM tnzet_session
- 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM tnzet_modules AS m LEFT JOIN tnzet_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN tnzet_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
- 1 × SELECT folder AS type, element AS name, params FROM tnzet_extensions
- 1 × SELECT * FROM tnzet_banners
- 1 × SELECT * FROM tnzet_comprofiler_tabs t
- 1 × SELECT * FROM tnzet_languages
- 1 × SELECT * FROM tnzet_users
- 1 × SELECT c.*, u.* FROM tnzet_users AS u LEFT JOIN tnzet_comprofiler AS c ON c.id = u.id
- 1 × SELECT g.id, g.title FROM tnzet_usergroups AS g JOIN tnzet_user_usergroup_map AS m ON m.group_id = g.id
- 1 × SELECT `data` FROM `tnzet_session`
- 1 × SELECT `group_id` FROM `tnzet_user_usergroup_map`
- 1 × SELECT id, home, template, s.params FROM tnzet_template_styles as s LEFT JOIN tnzet_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
- OTHER Tables:
- 1 × UPDATE `tnzet_session` SET `data` = '__default|a:7:{s:15:\"session.counter\";i:26;s:19:\"session.timer.start\";i:1312429871;s:18:\"session.timer.last\";i:1312430846;s:17:\"session.timer.now\";i:1312430846;s:22:\"session.client.browser\";s:70:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"42\";s:4:\"name\";s:10:\"Super User\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:13:\"[email protected]\";s:8:\"password\";s:65:\"d4fe2c57aa14dbc9f7342b3206b323df:k6Gnpx8MDYBluVvSMPdiPeBhWjPpvkyP\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2011-08-04 03:49:22\";s:13:\"lastvisitDate\";s:19:\"2011-08-04 03:49:28\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:0:\"\";s:6:\"groups\";a:1:{s:11:\"Super Users\";s:1:\"8\";}s:5:\"guest\";i:0;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{i:0;s:92:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}', `time` = 1312430846
- 1 × SHOW FULL COLUMNS FROM `tnzet_users
Advertisement
Add Comment
Please, Sign In to add comment