Code: Select all
user count query_time lock_time rows_sent rows_examined
dbo168278365 154 1453[23](9.44) 582[16](3.78) 210[50](1.36)
101690[2566](660.32)
dbo168278365 24 select * from wp_fgfad_manager where banners_group = %%
order by rand() limit %%;
dbo168278365 20 SELECT * FROM
wp_fgfmypictures,wp_fgfmygprelation,wp_fgfmygallery WHERE
wp_fgfmypictures.id = %% AND wp_fgfmygprelation.pid = %% AND
wp_fgfmygallery.id =%%;
dbo168278365 18 SET timestamp=%%; update wp_fgfad_manager_bnr_history
set `banners_shown`=`banners_shown`+%% ,
`banners_history_date`=sysdate() where `banners_id`=%% and
`banners_history_date`=%%;
dbo168278365 15 select sum(banners_shown) as total from
wp_fgfad_manager_bnr_history where banners_id = %%;
dbo168278365 11 select sum(banners_shown) as total from
wp_fgfad_manager_bnr_history where banners_id = %% and
banners_history_date>=%%;
dbo168278365 10 select MAX(`banners_history_date`) as
banners_history_date from wp_fgfad_manager_bnr_history;
dbo168278365 10 SELECT `time` FROM `wp_fgfonlinecounter` WHERE ip=%%;
dbo168278365 9 select MAX(banners_history_date) as banners_history_date
from wp_fgfad_manager_bnr_history where banners_id=%%;
dbo168278365 8 select banners_id from wp_fgfad_manager_bnr_history where
`banners_history_date`=%%;
dbo168278365 7 UPDATE `wp_fgfonlinecounter` SET time=%% WHERE ip=%%;
dbo168278365 6 select MAX(`banners_history_date`) as
max_banners_history_date from wp_fgfad_manager_bnr_history;
dbo168278365 4 INSERT INTO wp_fgfslim_stats ( `remote_ip`, `language`,
`country`, `referer`, `domain`, `searchterms`, `resource`, `platform`,
`browser`, `version`, `dt` ) VALUES %%;
dbo168278365 3 SELECT * FROM
wp_fgfmypictures,wp_fgfmygprelation,wp_fgfmygallery WHERE
wp_fgfmypictures.id = %% AND wp_fgfmygprelation.gid = %% AND
wp_fgfmygallery.name = %% AND (wp_fgfmypictures.picexclude IS NULL OR
wp_fgfmypictures.picexclude=%%) ORDER BY wp_fgfmypictures.id;
dbo168278365 2 SELECT * FROM wp_fgfposts WHERE ID = %% LIMIT %%;
dbo168278365 1 SELECT t.*, tt.*, tr.object_id FROM wp_fgfterms AS t
INNER JOIN wp_fgfterm_taxonomy AS tt ON tt.term_id = %% INNER JOIN
wp_fgfterm_relationships AS tr ON tr.term_taxonomy_id = %% WHERE
tt.taxonomy IN %% AND tr.object_id IN %% ORDER BY t.name ASC;
dbo168278365 1 SELECT post_id, meta_key, meta_value FROM wp_fgfpostmeta
WHERE post_id IN %% ORDER BY post_id, meta_key;
dbo168278365 1 SELECT id FROM wp_fgfmygallery WHERE name = %%;
dbo168278365 1 SELECT `country_code` FROM `wp_fgfslim_countries` WHERE
`ip_from` <= %% AND `ip_to` >= %%;
dbo168278365 1 SELECT COUNT(pid) FROM
wp_fgfmypictures,wp_fgfmygprelation,wp_fgfmygallery WHERE
wp_fgfmypictures.id = %% AND wp_fgfmygprelation.gid = %% AND
wp_fgfmygallery.name = %% AND (wp_fgfmypictures.picexclude IS NULL OR
wp_fgfmypictures.picexclude=%%);
dbo168278365 1 SELECT `counter` FROM `wp_fgfvisitcounter` WHERE date=%%;
dbo168278365 1 SELECT p.ID, p.post_title FROM wp_fgfposts AS p WHERE
p.post_date < %% AND p.post_type = %% AND p.post_status = %% LIMIT %%;
rdb63:~# myslowana /db/logs/mysql.slowlog.?.gz -e 'user dbo164426697' -s
user count query_time lock_time rows_sent rows_examined
dbo164426697 131 1161[25](8.86) 423[17](3.23) 421[113](3.21)
121291[2651](925.89)
dbo164426697 29 SELECT mn.*, mnc.news_category_name, mnc.long_name,
u.username, u.first_name, u.last_name FROM cms_module_news mn LEFT OUTER
JOIN cms_module_news_categories mnc ON mnc.news_category_id = %% LEFT
OUTER JOIN cms_users u ON u.user_id = %% WHERE status = %% AND
(upper(mnc.long_name) like upper(%%)) AND ( IFNULL(start_time, %%) < %%)
AND (( IFNULL(end_time, %%) = %%) OR (end_time > %%)) ORDER BY news_date
asc;
dbo164426697 24 SELECT count(mn.news_id) as count FROM cms_module_news
mn LEFT OUTER JOIN cms_module_news_categories mnc ON
mnc.news_category_id = %% LEFT OUTER JOIN cms_users u ON u.user_id = %%
WHERE status = %% AND (upper(mnc.long_name) like upper(%%)) AND (
IFNULL(start_time, %%) < %%) AND (( IFNULL(end_time, %%) = %%) OR
(end_time > %%));
dbo164426697 19 SELECT * FROM cms_content WHERE content_id = %%;
dbo164426697 16 SELECT A.value,B.id,B.name,B.type FROM
cms_module_news_fieldvals A, cms_module_news_fielddefs B WHERE
A.fielddef_id = %% AND B.public = %% AND A.news_id = %% ORDER BY
B.item_order;
dbo164426697 7 SELECT * FROM tvh_content WHERE content_id = %%;
dbo164426697 6 SELECT A.value,B.id,B.name,B.type FROM
tvh_module_news_fieldvals A, tvh_module_news_fielddefs B WHERE
A.fielddef_id = %% AND B.public = %% AND A.news_id = %% ORDER BY
B.item_order;
dbo164426697 4 SELECT * FROM tvh_content_props WHERE content_id = %%;
dbo164426697 3 SELECT * FROM cms_content_props WHERE content_id = %%;
dbo164426697 3 SELECT A.value,B.id,B.name,B.type FROM
cms_module_news_fieldvals A, cms_module_news_fielddefs B WHERE
A.fielddef_id = %% AND A.news_id = %% AND B.public = %% ORDER BY
B.item_order;
dbo164426697 2 SELECT mn.*, mnc.news_category_name, mnc.long_name,
u.username, u.first_name, u.last_name FROM cms_module_news mn LEFT OUTER
JOIN cms_module_news_categories mnc ON mnc.news_category_id = %% LEFT
OUTER JOIN cms_users u ON u.user_id = %% WHERE status = %% AND
(mnc.news_category_name = %% OR mnc.news_category_name = %%) AND (
IFNULL(start_time, %%) < %%) AND (( IFNULL(end_time, %%) = %%) OR
(end_time > %%)) LIMIT %%;
dbo164426697 2 SELECT mn.*, mnc.news_category_name FROM cms_module_news
mn LEFT OUTER JOIN cms_module_news_categories mnc ON
mnc.news_category_id = %% WHERE status = %% AND news_id = %%;
dbo164426697 1 SELECT content_id FROM cms_content WHERE default_content
= %%;
dbo164426697 1 SELECT htmlblob_id, htmlblob_name, html, owner,
modified_date FROM cms_htmlblobs WHERE htmlblob_name = %%;
dbo164426697 1 SELECT c.content_id, c.content_name, c.content_alias,
c.menu_text, c.titleattribute, c.hierarchy, c.metadata, c.id_hierarchy,
c.prop_names, c.create_date AS c_create_date, c.modified_date AS c_date,
c.cachable, c.last_modified_by, t.template_id, t.encoding,
t.modified_date AS t_date FROM tvh_templates t INNER JOIN tvh_content c
ON c.template_id = %% WHERE (c.content_alias = %% OR c.content_id = %%)
AND c.active = %%;
dbo164426697 1 SELECT module_name,template_name,modified_date FROM
tvh_module_templates;
dbo164426697 1 SELECT * FROM tvh_userplugins;
dbo164426697 1 UPDATE tvh_siteprefs SET sitepref_value = %% WHERE
sitepref_name = %%;
dbo164426697 1 SELECT count(mn.news_id) as count FROM tvh_module_news mn
LEFT OUTER JOIN tvh_module_news_categories mnc ON mnc.news_category_id =
%% LEFT OUTER JOIN tvh_users u ON u.user_id = %% WHERE status = %% AND
(mnc.news_category_name = %%) AND ( IFNULL(start_time, %%) < %%) AND ((
IFNULL(end_time, %%) = %%) OR (end_time > %%));
dbo164426697 1 SELECT module_name,template_name,modified_date FROM
cms_module_templates;
dbo164426697 1 SELECT mn.*, mnc.news_category_name, mnc.long_name,
u.username, u.first_name, u.last_name FROM tvh_module_news mn LEFT OUTER
JOIN tvh_module_news_categories mnc ON mnc.news_category_id = %% LEFT
OUTER JOIN tvh_users u ON u.user_id = %% WHERE status = %% AND
(mnc.news_category_name = %%) AND ( IFNULL(start_time, %%) < %%) AND ((
IFNULL(end_time, %%) = %%) OR (end_time > %%)) LIMIT %%;
dbo164426697 1 SELECT c.content_id, c.content_name, c.content_alias,
c.menu_text, c.titleattribute, c.hierarchy, c.metadata, c.id_hierarchy,
c.prop_names, c.create_date AS c_create_date, c.modified_date AS c_date,
c.cachable, c.last_modified_by,t.template_id, t.encoding,
t.modified_date AS t_date FROM tvh_templates t INNER JOIN tvh_content c
ON c.template_id = %% WHERE c.content_alias = %% AND c.active = %%;
dbo164426697 1 SELECT * FROM tvh_modules WHERE admin_only = %% AND
active = %% ORDER by module_name;
dbo164426697 1 SELECT sitepref_name, sitepref_value from tvh_siteprefs;
dbo164426697 1 SELECT content_id FROM tvh_content WHERE default_content
= %%;
dbo164426697 1 SELECT COUNT(*) AS total FROM tvh_module_guestbook WHERE
approved=%%;
dbo164426697 1 SELECT sitepref_value from tvh_siteprefs WHERE
sitepref_name = %%;
dbo164426697 1 SELECT DISTINCT A.css_id,A.media_type,B.assoc_order FROM
tvh_css A, tvh_css_assoc B WHERE A.css_id = %% AND B.assoc_type = %% AND
B.assoc_to_id = %% ORDER BY B.assoc_order;
