tommy_3652
มือใหม่หัดโพส
Karma: 0
 Offline
Posts: 9
|
 |
« on: October 29, 2009, 08:27:31 pm » |
|
ด้านข้าง และด้านล่างเวปเพจมันขึ้นข้อความพวกนี้อะครับ เอามันออกยังไง
6 queries executed
1
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='0'
2
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='51' LIMIT 1
3
DELETE FROM mos_session
WHERE (time < 1256822153)
4
SELECT * FROM mos_session WHERE session_id='ec8e83140d8076af61c6261ff0ab1ef1'
5
UPDATE mos_session SET `time`='1256823053',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1' WHERE session_id='ec8e83140d8076af61c6261ff0ab1ef1'
6
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors'
ORDER BY ordering
7
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors-xtd'
ORDER BY ordering
8
SELECT access FROM mos_menu WHERE id='51'
9
SELECT a.*, ROUND(v.rating_sum/v.rating_count) AS rating, v.rating_count, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups
FROM mos_content AS a
LEFT JOIN mos_categories AS cc ON cc.id = a.catid
LEFT JOIN mos_sections AS s ON s.id = cc.section AND s.scope='content'
LEFT JOIN mos_users AS u ON u.id = a.created_by
LEFT JOIN mos_content_rating AS v ON a.id = v.content_id
LEFT JOIN mos_groups AS g ON a.access = g.id
WHERE a.id='46' AND (a.state = '1' OR a.state = '-1')
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2009-10-29 20:30:53')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2009-10-29 20:30:53')
AND a.access <= 0
10
SELECT a.id
FROM mos_content AS a
WHERE a.catid = 23
AND a.state = 1 AND ordering < 5
AND a.access <= '0'
ORDER BY a.ordering DESC
LIMIT 1
11
SELECT a.id
FROM mos_content AS a
WHERE a.catid = 23
AND a.state = 1 AND ordering > 5
AND a.access <= '0'
ORDER BY a.ordering
LIMIT 1
12
UPDATE mos_content SET hits=(hits+1) WHERE id='46'
13
SELECT hits
FROM mos_core_log_items
WHERE time_stamp='2009-10-29' AND item_table='#__content' AND item_id='46'
14
UPDATE mos_core_log_items SET hits=(hits+1)
WHERE time_stamp='2009-10-29' AND item_table='#__content' AND item_id='46'
15
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='content'
ORDER BY ordering
16
SELECT id FROM mos_mambots WHERE element = 'mosimage' AND folder = 'content'
17
SELECT * FROM mos_mambots WHERE id='1'
18
SELECT id FROM mos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'
19
SELECT * FROM mos_mambots WHERE id='16'
20
SELECT g.*
FROM mos_core_acl_aro_groups AS g
INNER JOIN mos_core_acl_groups_aro_map AS gm ON gm.group_id = g.group_id
INNER JOIN mos_core_acl_aro AS ao ON ao.aro_id = gm.aro_id
WHERE ao.value='62'
21
SELECT a.id
FROM mos_components AS a
WHERE a.name = 'Syndicate'
22
SELECT * FROM mos_components WHERE id='17'
23
SELECT id, title, module, position, content, showtitle, params
FROM mos_modules AS m, mos_modules_menu AS mm
WHERE m.published='1' AND m.access <= '0' AND m.client_id='0'
AND mm.moduleid=m.id
AND (mm.menuid = '51' OR mm.menuid = '0')
ORDER BY ordering
24
SELECT m.* FROM mos_menu AS m
WHERE menutype='topmenu' AND published='1' AND access <= '0' AND parent='0'
ORDER BY ordering
25
SELECT m.* FROM mos_menu AS m
WHERE menutype='mainmenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering
26
SELECT id
FROM mos_menu
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=30'
27
SELECT id
FROM mos_menu
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=30'
28
SELECT id
FROM mos_menu
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=38'
29
SELECT id
FROM mos_menu
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=38'
30
SELECT m.* FROM mos_menu AS m
WHERE menutype='othermenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering
31
SELECT a.id, a.title, a.sectionid, a.catid,a.publish_up
FROM mos_content AS a
LEFT JOIN mos_content_frontpage AS f ON f.content_id = a.id
WHERE ( a.state = '1' AND a.checked_out = '0' AND a.sectionid > '0' )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-10-29 20:30:53' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-10-29 20:30:53' )
AND a.access <= '0'
ORDER BY a.created DESC LIMIT 20
32
SELECT COUNT( m.id )
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id
WHERE m.type='content_blog_section'
AND m.published='1'
33
SELECT COUNT( m.id )
FROM mos_content AS i
LEFT JOIN mos_categories AS c ON i.catid=c.id
LEFT JOIN mos_menu AS m ON m.componentid=c.id
WHERE m.type='content_blog_category'
AND m.published='1'
34
SELECT COUNT( id )
FROM mos_menu
WHERE type='content_blog_section'
AND published='1'
AND componentid=0
35
SELECT m.id
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id
WHERE m.type='content_section' AND m.published='1' AND i.id=66
36
SELECT m.id
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id
WHERE m.type='content_section' AND m.published='1' AND i.id=65
37
SELECT m.id
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id
WHERE m.type='content_section' AND m.published='1' AND i.id=64
38
SELECT m.id
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id
WHERE m.type='content_section' AND m.published='1' AND i.id=63
39
SELECT m.id
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id
WHERE m.type='content_section' AND m.published='1' AND i.id=62
40
SELECT m.id
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id
WHERE m.type='content_section' AND m.published='1' AND i.id=61
41
SELECT m.id
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id
WHERE m.type='content_section' AND m.published='1' AND i.id=60
42
SELECT m.id
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id
WHERE m.type='content_section' AND m.published='1' AND i.id=59
43
SELECT m.id
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id
WHERE m.type='content_section' AND m.published='1' AND i.id=57
44
SELECT m.id
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id
WHERE m.type='content_section' AND m.published='1' AND i.id=56
45
SELECT m.id
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id
WHERE m.type='content_section' AND m.published='1' AND i.id=55
46
SELECT m.id
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id
WHERE m.type='content_section' AND m.published='1' AND i.id=54
47
SELECT m.id
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id
WHERE m.type='content_section' AND m.published='1' AND i.id=52
48
SELECT m.id
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id
WHERE m.type='content_section' AND m.published='1' AND i.id=51
49
SELECT m.id
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id
WHERE m.type='content_section' AND m.published='1' AND i.id=50
50
SELECT m.id
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id
WHERE m.type='content_section' AND m.published='1' AND i.id=49
51
SELECT m.id
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id
WHERE m.type='content_section' AND m.published='1' AND i.id=46
52
SELECT m.id
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id
WHERE m.type='content_section' AND m.published='1' AND i.id=45
53
SELECT m.id
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id
WHERE m.type='content_section' AND m.published='1' AND i.id=44
54
SELECT m.id
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id
WHERE m.type='content_section' AND m.published='1' AND i.id=43
55
SELECT sum(hits) AS count FROM mos_stats_agents WHERE type='1'
56
SELECT *
FROM mos_menu
WHERE menutype='mainmenu' AND published='1'
ORDER BY parent, ordering LIMIT 1
57
SELECT id, name, link, parent, type
FROM mos_menu
WHERE published='1'
ORDER BY parent, ordering
58
SELECT title, catid, id FROM mos_content WHERE id=46
59
SELECT c.title AS title, s.id AS sectionid FROM mos_categories AS c LEFT JOIN mos_sections AS s ON c.section=s.id WHERE c.id=23
60
SELECT a.id
FROM mos_content AS a
INNER JOIN mos_categories AS b ON b.id = a.catid
WHERE a.state = 1
AND a.access <= '0' AND b.access <= '0'
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-10-29 20:30:53')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-10-29 20:30:53')
AND catid='3'
ORDER BY a.ordering
LIMIT 10
61
SELECT * FROM mos_content WHERE id='4'
62
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='content'
ORDER BY ordering
63
SELECT id FROM mos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'
64
SELECT * FROM mos_mambots WHERE id='16'
65
SELECT count(*) AS numrows FROM mos_banner WHERE showBanner=1
66
SELECT * FROM mos_banner WHERE showBanner=1
LIMIT 0,1
|
Mambo 
