...

View Full Version : I need a mySQL expert very badly.



doublerainbow
01-24-2012, 02:41 AM
my site has serious database problems, here are the queries i am getting that are locking up the site and bringing it repatedly down




+---------+---------------+-----------+-------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+---------+---------------+-----------+-------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
| 5713272 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT t.id_topic, m.subject, t.id_board
FROM smf_topics AS t
INNER JOIN smf_messages AS m ON |
| 5713273 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT COUNT(*)
FROM smf_topics AS t
LEFT JOIN smf_log_boards AS lb ON (lb.id_board = 520 A |
| 5713274 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT
IFNULL(lo.log_time, 0) AS is_online, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.at |
| 5713275 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | SELECT
IFNULL(lo.log_time, 0) AS is_online, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.at |
| 5713276 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | SELECT

t.id_topic, t.num_replies, t.locked, t.num_views, t.id_board, b.name AS board_name,

I |
| 5713277 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT t.id_topic, m.subject, t.id_board
FROM smf_topics AS t
INNER JOIN smf_messages AS m ON |
| 5713278 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | REPLACE INTO smf_log_topics(`id_member`, `id_topic`, `id_msg`)
VALUES
(41168, 342441, 9330477) |
| 5713279 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT t.id_topic, m.subject, t.id_board
FROM smf_topics AS t
INNER JOIN smf_messages AS m ON |
| 5713280 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | INSERT INTO smf_messages(`id_board`, `id_topic`, `id_member`, `subject`, `body`, `poster_name`, `pos |
| 5713281 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | SELECT
p.question, p.voting_locked, p.hide_results, p.expire_time, p.max_votes, p.change_vote,
|
| 5713282 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | INSERT IGNORE INTO smf_log_topics(`id_member`, `id_topic`, `id_msg`)
VALUES
(40315, 347784, 933 |
| 5713283 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT m.subject, IFNULL(mem.real_name, m.poster_name) AS poster_name, m.poster_time, m.body
FRO |
| 5713284 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | SELECT
lo.id_member, lo.log_time, mem.real_name, mem.member_name, mem.show_online,
mg.online |
| 5713285 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT
ms.subject AS first_subject, ms.poster_time AS first_poster_time, ms.id_topic, t.id_boar |
| 5713286 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT IFNULL(mem.real_name, m.poster_name) AS poster_name, m.poster_time, m.body, m.smileys_enabled |
| 5713287 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT mem.id_member, mem.real_name, mem.member_name, mem.is_shareable
FROM smf_members AS mem
|
| 5713288 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | UPDATE smf_members
SET unread_messages = 0
WHERE id_member = 22869 |
| 5713289 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | UPDATE smf_messages
SET id_msg_modified = 9330486
WHERE id_msg = 9330486 |
| 5713290 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT
IFNULL(lo.log_time, 0) AS is_online, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.at |
| 5713291 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | INSERT IGNORE INTO smf_log_topics(`id_member`, `id_topic`, `id_msg`)
VALUES
(37830, 347815, 933 |
| 5713292 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | REPLACE INTO smf_log_topics(`id_member`, `id_topic`, `id_msg`)
VALUES
(18789, 331337, 9330477) |
| 5713293 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | SELECT
IFNULL(lo.log_time, 0) AS is_online, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.at |
| 5713294 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | UPDATE smf_members
SET last_login = 1327369591, member_ip = '99.100.6.105', member_ip2 = '99.100.6 |
| 5713295 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT IFNULL(lt.id_msg, IFNULL(lmr.id_msg, -1)) + 1 AS new_from
FROM smf_topics AS t
LEF |
| 5713296 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | SELECT
lo.id_member, lo.log_time, mem.real_name, mem.member_name, mem.show_online,
mg.online |
| 5713297 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT IFNULL(mem.real_name, m.poster_name) AS poster_name, m.poster_time, m.body, m.smileys_enabled |
| 5713298 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | UPDATE smf_members
SET last_login = 1327369591, member_ip = '173.71.210.228', member_ip2 = '173.71 |
| 5713299 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | REPLACE INTO smf_log_topics(`id_member`, `id_topic`, `id_msg`)
VALUES
(17017, 346170, 9330477) |
| 5713300 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT
pm.id_pm, CASE WHEN pm.id_pm_head = 0 THEN pm.id_pm ELSE pm.id_pm_head END AS pm_head,
|
| 5713301 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | UPDATE smf_members
SET last_login = 1327369591, member_ip = '142.167.59.244', member_ip2 = '142.16 |
| 5713302 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT
p.question, p.voting_locked, p.hide_results, p.expire_time, p.max_votes, p.change_vote,
|
| 5713303 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT mem.id_member, mem.real_name, mem.member_name, mem.is_shareable
FROM smf_members AS mem
|
| 5713304 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | REPLACE INTO smf_log_topics(`id_member`, `id_topic`, `id_msg`)
VALUES
(17017, 346170, 9330477) |
| 5713307 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | UPDATE smf_members
SET last_login = 1327369591, member_ip = '99.57.180.215', member_ip2 = '99.57.1 |
| 5713308 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT COUNT(mem.id_member)
FROM smf_members AS mem
LEFT JOIN smf_subaccounts AS sub ON (sub.id |
| 5713309 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | SELECT
p.question, p.voting_locked, p.hide_results, p.expire_time, p.max_votes, p.change_vote,
|
| 5713311 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | UPDATE smf_messages
SET id_msg_modified = 9330479
WHERE id_msg = 9330479 |

(42203, 290496, 9330477) |
| 5713348 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT mem.id_member, mem.real_name, mem.member_name, mem.is_shareable
FROM smf_members AS mem
|
| 5713349 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT
p.question, p.voting_locked, p.hide_results, p.expire_time, p.max_votes, p.change_vote,
|
| 5713350 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | UPDATE smf_messages
SET id_msg_modified = 9330483
WHERE id_msg = 9330483 |
| 5713351 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT IFNULL(mem.real_name, m.poster_name) AS poster_name, m.poster_time, m.body, m.smileys_enabled |
| 5713352 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT
IFNULL(lo.log_time, 0) AS is_online, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.at |
| 5713353 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | UPDATE smf_members
SET last_login = 1327369591, member_ip = '99.57.180.215', member_ip2 = '99.57.1 |
| 5713354 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | SELECT IFNULL(mem.real_name, m.poster_name) AS poster_name, m.poster_time, m.body, m.smileys_enabled |
| 5713355 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT
mem.id_member AS id_member, mem.real_name AS real_name, mem.is_activated AS is_activated,
|
| 5713356 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT id_member, real_name
FROM smf_members
WHERE id_member IN (4383, 32119, 29749, 41833, 29 |
| 5713357 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT IFNULL(mem.real_name, m.poster_name) AS poster_name, m.poster_time, m.body, m.smileys_enabled |
| 5713358 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | SELECT IFNULL(mem.real_name, m.poster_name) AS poster_name, m.poster_time, m.body, m.smileys_enabled |
| 5713360 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT
IFNULL(lo.log_time, 0) AS is_online, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.at |
| 5713361 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT IFNULL(mem.real_name, m.poster_name) AS poster_name, m.poster_time, m.body, m.smileys_enabled |
| 5713362 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | SELECT IFNULL(lt.id_msg, IFNULL(lmr.id_msg, -1)) + 1 AS new_from
FROM smf_topics AS t
LEF |
| 5713363 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | UPDATE smf_members
SET last_login = 1327369591, member_ip = '96.228.181.2', member_ip2 = '96.228.1 |
| 5713364 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT
IFNULL(lo.log_time, 0) AS is_online, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.at |
| 5713365 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | UPDATE smf_messages
SET id_msg_modified = 9330481
WHERE id_msg = 9330481 |
| 5713366 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | UPDATE smf_members
SET last_login = 1327369591, member_ip = '207.102.46.103', member_ip2 = '207.10 |
| 5713367 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | UPDATE smf_log_topics
SET id_msg = 9330478
WHERE id_member = 34804
AND id_topic = 28126 |
| 5713369 | warrior_acorn | localhost | warrior_smf | Query | 233 | Copying to tmp table | SELECT mem.id_member, mem.real_name, mem.money
FROM smf_members AS mem
LEFT JOIN smf_subaccount |
| 5713370 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | SELECT
ms.subject AS first_subject, ms.poster_time AS first_poster_time, ms.id_topic, t.id_boar |
| 5713371 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT mem.id_member, mem.real_name, mem.member_name, mem.is_shareable
FROM smf_members AS mem
|
| 5713372 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | INSERT IGNORE INTO smf_log_topics(`id_member`, `id_topic`, `id_msg`)
VALUES
(40315, 347784, 933 |
| 5713374 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT
IFNULL(lo.log_time, 0) AS is_online, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.at |
| 5713375 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | UPDATE smf_members
SET last_login = 1327369591, member_ip = '76.30.156.90', member_ip2 = '76.30.15 |
| 5713376 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT
mem.id_member AS id_member, mem.real_name AS real_name, mem.is_activated AS is_activated,
|
| 5713377 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT lngfile
FROM smf_members
WHERE id_member = 42588 |
| 5713379 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT
ms.subject AS first_subject, ms.poster_time AS first_poster_time, ms.id_topic, t.id_boar |
| 5713380 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | UPDATE smf_messages
SET id_msg_modified = 9330485
WHERE id_msg = 9330485 |
| 5713383 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | SELECT
mem.id_member AS id_member, mem.real_name AS real_name, mem.is_activated AS is_activated,
|
| 5713384 | warrior_acorn | localhost | warrior_smf | Query | 252 | Locked | SELECT IFNULL(mem.real_name, m.poster_name) AS poster_name, m.poster_time, m.body, m.smileys_enabled |
| 5713385 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT
lo.id_member, lo.log_time, mem.real_name, mem.member_name, mem.show_online,
mg.online |
| 5713386 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | SELECT
IFNULL(lo.log_time, 0) AS is_online, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.at |
| 5713387 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT IFNULL(mem.real_name, m.poster_name) AS poster_name, m.poster_time, m.body, m.smileys_enabled |
| 5713388 | warrior_acorn | localhost | warrior_smf | Query | 233 | Locked | SELECT IFNULL(lt.id_msg, IFNULL(lmr.id_msg, -1)) + 1 AS new_from
FROM smf_topics AS t
LEF |
| 5713390 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT IFNULL(mem.real_name, m.poster_name) AS poster_name, m.poster_time, m.body, m.smileys_enabled |
| 5713393 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT id_member, real_name
FROM smf_members
| 5713576 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
IFNULL(sub.id |
| 5713577 | warrior_acorn | localhost | warrior_smf | Query | 232 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
IFNULL(sub.id |
| 5713578 | warrior_acorn | localhost | warrior_smf | Query | 230 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
IFNULL(sub.id |
| 5713580 | warrior_acorn | localhost | warrior_smf | Query | 229 | Locked | UPDATE smf_members
SET last_login = 1327369594, member_ip = '50.55.45.229', member_ip2 = '50.55.45 |
| 5713581 | warrior_acorn | localhost | warrior_smf | Query | 229 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
IFNULL(sub.id |
| 5713582 | warrior_acorn | localhost | warrior_smf | Query | 229 | Locked | SELECT mem.id_member, mem.real_name, mem.member_name, mem.is_shareable
FROM smf_members AS mem
|
| 5713583 | warrior_acorn | localhost | warrior_smf | Query | 227 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
IFNULL(sub.id |
| 5713584 | warrior_acorn | localhost | warrior_smf | Query | 223 | Locked | SELECT
c.id_cat, b.name AS bname, b.description, b.num_topics, b.member_groups,
b.id_parent, |
| 5713585 | warrior_acorn | localhost | warrior_smf | Query | 221 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
IFNULL(sub.id |
| 5713586 | warrior_acorn | localhost | warrior_smf | Query | 213 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
IFNULL(sub.id |
| 5713587 | warrior_acorn | localhost | warrior_smf | Query | 183 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
IFNULL(sub.id |
| 5713588 | warrior_acorn | localhost | warrior_smf | Query | 178 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
IFNULL(sub.id |
| 5713589 | warrior_acorn | localhost | warrior_smf | Query | 177 | Locked | SELECT
c.id_cat, b.name AS bname, b.description, b.num_topics, b.member_groups,
b.id_parent, |
| 5713590 | warrior_acorn | localhost | warrior_smf | Query | 174 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
IFNULL(sub.id |
| 5713591 | warrior_acorn | localhost | warrior_smf | Query | 174 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
IFNULL(sub.id |
| 5713592 | warrior_acorn | localhost | warrior_smf | Query | 172 | Locked | SELECT
c.id_cat, b.name AS bname, b.description, b.num_topics, b.member_groups,
b.id_parent, |
| 5713593 | warrior_acorn | localhost | warrior_smf | Query | 161 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
IFNULL(sub.id |
| 5713594 | warrior_acorn | localhost | warrior_smf | Query | 155 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
IFNULL(sub.id |
| 5713595 | warrior_acorn | localhost | warrior_smf | Query | 155 | Locked | SELECT
c.id_cat, b.name AS bname, b.description, b.num_topics, b.member_groups,
b.id_parent, |
| 5713596 | warrior_acorn | localhost | warrior_smf | Query | 120 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
IFNULL(sub.id |
| 5713597 | warrior_acorn | localhost | warrior_smf | Query | 117 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
IFNULL(sub.id |
| 5713598 | warrior_acorn | localhost | warrior_smf | Query | 116 | Locked | SELECT
c.id_cat, b.name AS bname, b.description, b.num_topics, b.member_groups,
b.id_parent, |
| 5713599 | warrior_acorn | localhost | warrior_smf | Query | 100 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
IFNULL(sub.id |
| 5713601 | warrior_acorn | localhost | warrior_smf | Query | 100 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
IFNULL(sub.id |
| 5713602 | warrior_acorn | localhost | warrior_smf | Query | 84 | Locked | SELECT
c.id_cat, b.name AS bname, b.description, b.num_topics, b.member_groups,
b.id_parent, |
| 5713603 | warrior_acorn | localhost | warrior_smf | Query | 84 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
IFNULL(sub.id |
| 5713604 | warrior_acorn | localhost | warrior_smf | Query | 74 | Locked | SELECT
c.id_cat, b.name AS bname, b.description, b.num_topics, b.member_groups,
b.id_parent, |
| 5713605 | warrior_acorn | localhost | warrior_smf | Query | 61 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
IFNULL(sub.id |
| 5713608 | eximstats | localhost | eximstats | Sleep | 25 | | |
| 5713610 | warrior_acorn | localhost | warrior_smf | Query | 19 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
IFNULL(sub.id |
| 5713611 | warrior_acorn | localhost | warrior_smf | Query | 16 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
IFNULL(sub.id |
| 5713613 | warrior_acorn | localhost | warrior_smf | Query | 8 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type,
IFNULL(sub.id |
| 5713615 | root | localhost | | Query | 0 | | show processlist |


I need serious help. I need an expert. please, anybody...

KuriosJon
01-25-2012, 12:52 PM
Can you do a show full processlist. The normal show processlist truncates your queries so it's impossible to tell what they are doing.

Also, while it may be possible to identify a slow query merely by the SQL statement, you often have to use other tools like explain to see what indexes SQL is using. A database structure would also be helpful.

At least start with show full processlist and post those results.

doublerainbow
01-29-2012, 04:06 AM
All right. Thank you for the response. I am going to try here. I was given this as being my full process list. I am using memcached. The tables are myISAM.



ame, mem.is_shareable
FROM smf_members AS mem
LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
WHERE sub.id_parent = 18754
|
| 4418331 | x | localhost | warrior_smf | Query | 7 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS
id_attach, a.filename, a.attachment_type,
IFNULL(sub.id_parent, 0) as id_parent
FROM smf_members AS mem
LEFT JOIN smf_attachments AS a ON (a.id_member = 43318)
LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
WHERE mem.id_member = 43318
LIMIT 1
|
| 4418332 | x | localhost | x | Query | 7 | Locked | SELECT
c.id_cat, b.name AS bname, b.description, b.num_topics, b.member_groups,
b.id_parent, c.name AS cname, IFNULL(mem.id_member, 0) AS id_moderator,
mem.real_name, b.id_board, b.child_level,
b.id_theme, b.override_theme, b.count_posts, b.id_profile, b.redirect,
b.unapproved_topics, b.unapproved_posts, t.approved, t.id_member_started, b.post_template
FROM smf_boards AS b
INNER JOIN smf_topics AS t ON (t.id_topic = 178270)
LEFT JOIN smf_categories AS c ON (c.id_cat = b.id_cat)
LEFT JOIN smf_moderators AS mods ON (mods.id_board = t.id_board)
LEFT JOIN smf_members AS mem ON (mem.id_member = mods.id_member)
WHERE b.id_board = t.id_board
|
| 4418333 | x | localhost | x | Query | 7 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS
id_attach, a.filename, a.attachment_type,
IFNULL(sub.id_parent, 0) as id_parent
FROM smf_members AS mem
LEFT JOIN smf_attachments AS a ON (a.id_member = 33393)
LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
WHERE mem.id_member = 33393
LIMIT 1
|
| 4418334 |x | localhost | x | Query | 7 | Locked | SELECT mem.id_member, mem.real_name,
mem.member_name, mem.is_shareable
FROM smf_members AS mem
LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
WHERE sub.id_parent = 37312
|
| 4418335 | x | localhost | x | Query | 7 | Locked | SELECT mem.id_member, mem.real_name,
mem.member_name, mem.is_shareable
FROM smf_members AS mem
LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
WHERE sub.id_parent = 27525
|
| 4418336 | warrior_acorn | localhost | warrior_smf | Query | 7 | Locked | SELECT mem.id_member, mem.real_name,
mem.member_name, mem.is_shareable
FROM smf_members AS mem
LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
WHERE sub.id_parent = 33603
|
| 4418337 | x| localhost | x | Query | 7 | Locked | SELECT mem.id_member, mem.real_name,
mem.member_name, mem.is_shareable
FROM smf_members AS mem
LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
WHERE sub.id_parent = 20084
|
| 4418338 | x | localhost | x | Query | 7 | Locked | UPDATE smf_members
SET last_login = 1327810157, member_ip = '24.154.26.173', member_ip2 = '24.154.26.173', total_time_logged_in = 1393548
WHERE id_member = 11103
|
| 4418339 | x | localhost | x | Query | 7 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS
id_attach, a.filename, a.attachment_type,
IFNULL(sub.id_parent, 0) as id_parent
FROM smf_members AS mem
LEFT JOIN smf_attachments AS a ON (a.id_member = 23271)
LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
WHERE mem.id_member = 23271
LIMIT 1
|
| 4418340 | x | localhost | x| Query | 7 | Locked | SELECT
c.id_cat, b.name AS bname, b.description, b.num_topics, b.member_groups,
b.id_parent, c.name AS cname, IFNULL(mem.id_member, 0) AS id_moderator,
mem.real_name, b.id_board, b.child_level,
b.id_theme, b.override_theme, b.count_posts, b.id_profile, b.redirect,
b.unapproved_topics, b.unapproved_posts, t.approved, t.id_member_started, b.post_template
FROM smf_boards AS b
INNER JOIN smf_topics AS t ON (t.id_topic = 341288)
LEFT JOIN smf_categories AS c ON (c.id_cat = b.id_cat)
LEFT JOIN smf_moderators AS mods ON (mods.id_board = t.id_board)
LEFT JOIN smf_members AS mem ON (mem.id_member = mods.id_member)
WHERE b.id_board = t.id_board
|
| 4418341 | x | localhost | x| Query | 7 | Locked | SELECT mem.id_member, mem.real_name,
mem.member_name, mem.is_shareable
FROM smf_members AS mem
LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
WHERE sub.id_parent = 21527
|
| 4418342 | x | localhost | x| Query | 6 | Locked | SELECT mem.id_member, mem.real_name,
mem.member_name, mem.is_shareable
FROM smf_members AS mem
LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
WHERE sub.id_parent = 39045
|
| 4418343 | x | localhost | x | Query | 6 | Locked | SELECT mem.id_member, mem.real_name,
mem.member_name, mem.is_shareable
FROM smf_members AS mem
LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
WHERE sub.id_parent = 37558
|
| 4418344 | x | localhost | x | Query | 6 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS
id_attach, a.filename, a.attachment_type,
IFNULL(sub.id_parent, 0) as id_parent
FROM smf_members AS mem
LEFT JOIN smf_attachments AS a ON (a.id_member = 15244)
LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
WHERE mem.id_member = 15244
LIMIT 1
|
| 4418345 | x | localhost | x | Query | 6 | Locked | SELECT mem.*, IFNULL(a.id_attach, 0) AS
id_attach, a.filename, a.attachment_type,
IFNULL(sub.id_parent, 0) as id_parent
FROM smf_members AS mem
LEFT JOIN smf_attachments AS a ON (a.id_member = 36868)
LEFT JOIN smf_subaccounts AS sub ON (sub.id_member = mem.id_member)
WHERE mem.id_member = 36868
LIMIT 1



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum