| SELECT sql_server FROM session WHERE hash='328j3eq2ppfu9l01ehc>c3go431' это что же надо в коде написать, что получить ЭТО?:
дофигаQuery: SELECT DISTINCT rule_id FROM closed_net WHERE (net_start<=3641561769 AND net_end>=3641561769) Time before: 4.5061111450195E-05 Time after: 0.00069689750671387 \n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
closed_net range net_start,net_end net_end 9 1 Using where; Using temporary
\n
\n\n
Query: SELECT *, if(rule_id,1,0) as closed
FROM firewall
WHERE (
(date_start<=1166552607 AND date_end>=1166552607)
OR
date_end=0
)
AND ( username="Исследователь Сефирот" )
ORDER BY rule_id DESC
Time before: 0.0011529922485352
Time after: 0.0019600391387939
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
firewall ref username username 102 const 1 Using where; Using filesort
\n
\n\n
Query: select * from modules
Time before: 0.0026130676269531
Time after: 0.0027859210968018
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
modules ALL 19
\n
\n\n
Query: select * from submodules where p_id="8"
Time before: 0.003324031829834
Time after: 0.0035800933837891
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
submodules ref p_id_idx p_id_idx 2 const 29
\n
\n\n
Query: delete quick from session where lastactivity<1166551707
Time before: 0.0041670799255371
Time after: 0.010755062103271
\n
\n\nQuery: select user_action_describe from submodules where id="73"
Time before: 0.01081109046936
Time after: 0.011053085327148
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
submodules const PRIMARY PRIMARY 2 const 1
\n
\n\n
Query: select shortname,username,userid,title from journal where shortname="asia-al-medham>"
Time before: 0.011526107788086
Time after: 0.012151002883911
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
journal ref shortname_idx shortname_idx 27 const 1 Using where
\n
\n\n
Query: SELECT sql_server FROM session WHERE hash='328j3eq2ppfu9l01ehc>c3go431'
Time before: 0.012671947479248
Time after: 0.015713930130005
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
session ref PRIMARY PRIMARY 34 const 1 Using where
\n
\n\n
Query: replace delayed into session (hash,userid,lastactivity,ip,username>,location,sql_server) values ("328j3eq2ppfu9l01ehcc3go431",
"210041","1166552607","21>7.13.210.169","Исследователь Сефирот",
"Читает комментарии",0)
Time before: 0.016139030456543
Time after: 0.016387939453125
\n
\n\nQuery: replace delayed user_last_activity set date="1166552607", userid="210041", ip="3641561769"
Time before: 0.016427993774414
Time after: 0.016741037368774
\n
\n\nQuery: SELECT *
FROM group_authority
WHERE module_id="8"
AND submodule_id="73"
AND group_id="2"
Time before: 0.017255067825317
Time after: 0.017679929733276
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
group_authority ref PRIMARY PRIMARY 12 const,const,const 1 Using index
\n
\n\n
Query: select * from journal where shortname="asia-al-medham>"
Time before: 0.018548011779785
Time after: 0.019511938095093
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
journal ref shortname_idx shortname_idx 27 const 1 Using where
\n
\n\n
Query: select access_mode,open,x_date,a>ccess_forwhat from journal where userid="138599"
Time before: 0.020108938217163
Time after: 0.02053689956665
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
journal const PRIMARY,userid_open_ispub>ic PRIMARY 4 const 1
\n
\n\n
Query: select count(*) from white_list where owner_id="138599" and userid="210041"
Time before: 0.021040916442871
Time after: 0.021492004394531
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
white_list ref owner_id owner_id 8 const,const 1 Using index
\n
\n\n
Query: set @x=0;
Time before: 0.021927118301392
Time after: 0.022149085998535
\n
\n\nQuery:
SELECT @x:=template_set_id
FROM template_set
WHERE set_name="head_include"
Time before: 0.022181034088135
Time after: 0.022622108459473
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
template_set ref tset_name tset_name 102 const 1 Using where
\n
\n\n
Query:
SELECT content
FROM template
WHERE template_set_id=@x
AND (group_id=2 or group_id =-1)
ORDER BY group_id DESC
LIMIT 1;
Time before: 0.023890972137451
Time after: 0.024434089660645
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
template ref template_set_id,group_id template_set_id 4 const 1 Using where; Using filesort
\n
\n\n
[OT="head_include"]: Start time: 0.02490496635437
[OT="head_include"]: End time: 0.024987936019897
Query: set @x=0;
Time before: 0.025039911270142
Time after: 0.02529501914978
\n
\n\nQuery:
SELECT @x:=template_set_id
FROM template_set
WHERE set_name="counterz"
Time before: 0.02534008026123
Time after: 0.025697946548462
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
template_set ref tset_name tset_name 102 const 1 Using where
\n
\n\n
Query:
SELECT content
FROM template
WHERE template_set_id=@x
AND (group_id=2 or group_id =-1)
ORDER BY group_id DESC
LIMIT 1;
Time before: 0.026089906692505
Time after: 0.026550054550171
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
template ref template_set_id,group_id template_set_id 4 const 1 Using where; Using filesort
\n
\n\n
[OT="counterz"]: Start time: 0.027159929275513
[OT="counterz"]: End time: 0.027291059494019
Query: SELECT * FROM image_store WHERE image_id=12856192
Time before: 0.050909042358398
Time after: 0.053009986877441
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
image_store const PRIMARY PRIMARY 4 const 1
\n
\n\n
Query: select * from user where shortname="asia-al-medham>"
Time before: 0.053630113601685
Time after: 0.054610967636108
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
user ref shortname shortname 28 const 1 Using where
\n
\n\n
Query: select photo_image_id from user where userid="138599"
Time before: 0.055233955383301
Time after: 0.05622410774231
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
\n
\n\n
Query: SELECT * FROM image_store WHERE image_id=11302763
Time before: 0.056616067886353
Time after: 0.057018995285034
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
image_store const PRIMARY PRIMARY 4 const 1
\n
\n\n
Query: select photo_image_id from user where userid="138599"
Time before: 0.059269905090332
Time after: 0.059514999389648
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
\n
\n\n
Query: SELECT * FROM image_store WHERE image_id=11302763
Time before: 0.059950113296509
Time after: 0.060156106948853
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
image_store const PRIMARY PRIMARY 4 const 1
\n
\n\n
Query: select journal_post.*,user.usert>itle from journal_post left join user on journal_post.userid=user.>userid where postid="20428787"
Time before: 0.08406400680542
Time after: 0.084673881530762
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
journal_post const PRIMARY PRIMARY 4 const 1
user const PRIMARY PRIMARY 4 const 1
\n
\n\n
Query: select use_avatar_id,avatar_coun>t from user where userid="138599"
Time before: 0.085563898086548
Time after: 0.085984945297241
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
\n
\n\n
Query: select image_id from avatars where id="875899"
Time before: 0.086323976516724
Time after: 0.086558103561401
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
avatars const PRIMARY PRIMARY 4 const 1
\n
\n\n
Query: SELECT * FROM image_store WHERE image_id=11302677
Time before: 0.08686900138855
Time after: 0.08719801902771
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
image_store const PRIMARY PRIMARY 4 const 1
\n
\n\n
Query:
SELECT s.code, concat('') as img
FROM smile as s
LEFT JOIN image_store as ims using(image_id)
Time before: 0.087640047073364
Time after: 0.088921070098877
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
s ALL 510
ims eq_ref PRIMARY PRIMARY 4 diary.s.image_id 1
\n
\n\n
Query: select * from censored
Time before: 0.094248056411743
Time after: 0.094559907913208
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
censored ALL 53
\n
\n\n
Query: select count(*) from comment_subs where userid="210041" and postid="20428787"
Time before: 0.095546960830688
Time after: 0.096491098403931
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
comment_subs const PRIMARY,postid PRIMARY 8 const,const 1 Using index
\n
\n\n
Query: SELECT dateline FROM journal_post_createlog WHERE postid=20428787
Time before: 0.096941947937012
Time after: 0.097450971603394
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
Impossible WHERE noticed after reading const tables
\n
\n\n
Query: set @x=0;
Time before: 0.097779989242554
Time after: 0.097966909408569
\n
\n\nQuery:
SELECT @x:=template_set_id
FROM template_set
WHERE set_name="old_comment_con>tent_bit"
Time before: 0.098000049591064
Time after: 0.20285892486572
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
template_set ref tset_name tset_name 102 const 1 Using where
\n
\n\n
Query:
SELECT content
FROM template
WHERE template_set_id=@x
AND (group_id=2 or group_id =-1)
ORDER BY group_id DESC
LIMIT 1;
Time before: 0.20340609550476
Time after: 0.20691990852356
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
template ref template_set_id,group_id template_set_id 4 const 1 Using where; Using filesort
\n
\n\n
[OT="old_comment_content_>bit"]: Start time: 0.20747995376587
[OT="old_comment_content_>bit"]: End time: 0.20795297622681
Query: select journal_comment.*,user.us>ertitle from journal_comment left join user
on journal_comment.userid=us>er.userid
where juserid="138599" and postid="20428787"
order by dateline limit 0,30
Time before: 0.20802593231201
Time after: 0.21307110786438
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
journal_comment ref postid_juserid_commentid,>juserid,juserid_2 postid_juserid_commentid 8 const,const 28 Using where; Using filesort
user eq_ref PRIMARY PRIMARY 4 diary.journal_comment.use>rid 1
\n
\n\n
Query: select image_id from avatars where id="585019"
Time before: 0.21791791915894
Time after: 0.21882891654968
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
avatars const PRIMARY PRIMARY 4 const 1
\n
\n\n
Query: SELECT * FROM image_store WHERE image_id=7376427
Time before: 0.22234988212585
Time after: 0.22323608398438
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
image_store const PRIMARY PRIMARY 4 const 1
\n
\n\n
Query: select email,show_email from user where userid="4206"
Time before: 0.22394895553589
Time after: 0.22599697113037
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
\n
\n\n
Query: set @x=0;
Time before: 0.22650408744812
Time after: 0.22668504714966
\n
\n\nQuery:
SELECT @x:=template_set_id
FROM template_set
WHERE set_name="old_comment_bit>"
Time before: 0.22671604156494
Time after: 0.22730588912964
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
template_set ref tset_name tset_name 102 const 1 Using where
\n
\n\n
Query:
SELECT content
FROM template
WHERE template_set_id=@x
AND (group_id=2 or group_id =-1)
ORDER BY group_id DESC
LIMIT 1;
Time before: 0.22775292396545
Time after: 0.2290370464325
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
template ref template_set_id,group_id template_set_id 4 const 1 Using where; Using filesort
\n
\n\n
[OT="old_comment_bit"]: Start time: 0.23002696037292
[OT="old_comment_bit"]: End time: 0.23039698600769
Query: select image_id from avatars where id="894292"
Time before: 0.23790907859802
Time after: 0.2386519908905
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
avatars const PRIMARY PRIMARY 4 const 1
\n
\n\n
Query: SELECT * FROM image_store WHERE image_id=11503294
Time before: 0.23907709121704
Time after: 0.24054789543152
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
image_store const PRIMARY PRIMARY 4 const 1
\n
\n\n
Query: select email,show_email from user where userid="166385"
Time before: 0.24111294746399
Time after: 0.24213290214539
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
\n
\n\n
[OT="old_comment_bit"]: Start time: 0.24290704727173
[OT="old_comment_bit"]: End time: 0.24335193634033
Query: select image_id from avatars where id="690531"
Time before: 0.24455809593201
Time after: 0.2452220916748
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
avatars const PRIMARY PRIMARY 4 const 1
\n
\n\n
Query: SELECT * FROM image_store WHERE image_id=8861499
Time before: 0.24570393562317
Time after: 0.24619507789612
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
image_store const PRIMARY PRIMARY 4 const 1
\n
\n\n
Query: select email,show_email from user where userid="159756"
Time before: 0.24779105186462
Time after: 0.24899411201477
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
\n
\n\n
[OT="old_comment_bit"]: Start time: 0.24969506263733
[OT="old_comment_bit"]: End time: 0.25132203102112
Query: select image_id from avatars where id="637253"
Time before: 0.26197004318237
Time after: 0.26214194297791
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
avatars const PRIMARY PRIMARY 4 const 1
\n
\n\n
Query: SELECT * FROM image_store WHERE image_id=8140249
Time before: 0.26259994506836
Time after: 0.26299691200256
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
image_store const PRIMARY PRIMARY 4 const 1
\n
\n\n
Query: select email,show_email from user where userid="210041"
Time before: 0.26398396492004
Time after: 0.26442503929138
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
\n
\n\n
[OT="old_comment_bit"]: Start time: 0.26562094688416
[OT="old_comment_bit"]: End time: 0.28315901756287
Query: select image_id from avatars where id="938371"
Time before: 0.28617811203003
Time after: 0.28667593002319
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
avatars const PRIMARY PRIMARY 4 const 1
\n
\n\n
Query: SELECT * FROM image_store WHERE image_id=12051653
Time before: 0.28713893890381
Time after: 0.28804588317871
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
image_store const PRIMARY PRIMARY 4 const 1
\n
\n\n
Query: select email,show_email from user where userid="24978"
Time before: 0.28856992721558
Time after: 0.28910899162292
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
\n
\n\n
[OT="old_comment_bit"]: Start time: 0.28956508636475
[OT="old_comment_bit"]: End time: 0.29015803337097
Query: select email,show_email from user where userid="4206"
Time before: 0.29249906539917
Time after: 0.29283595085144
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
\n
\n\n
[OT="old_comment_bit"]: Start time: 0.29356288909912
[OT="old_comment_bit"]: End time: 0.29384589195251
Query: select image_id from avatars where id="351228"
Time before: 0.29669094085693
Time after: 0.29765605926514
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
avatars const PRIMARY PRIMARY 4 const 1
\n
\n\n
Query: SELECT * FROM image_store WHERE image_id=4398392
Time before: 0.29836297035217
Time after: 0.29877305030823
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
image_store const PRIMARY PRIMARY 4 const 1
\n
\n\n
Query: select email,show_email from user where userid="12721"
Time before: 0.29923510551453
Time after: 0.29968690872192
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
\n
\n\n
[OT="old_comment_bit"]: Start time: 0.30011510848999
[OT="old_comment_bit"]: End time: 0.30052089691162
Query: select image_id from avatars where id="799557"
Time before: 0.30306506156921
Time after: 0.30342602729797
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
avatars const PRIMARY PRIMARY 4 const 1
\n
\n\n
Query: SELECT * FROM image_store WHERE image_id=10346857
Time before: 0.30398511886597
Time after: 0.30452299118042
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
image_store const PRIMARY PRIMARY 4 const 1
\n
\n\n
Query: select email,show_email from user where userid="205529"
Time before: 0.30561804771423
Time after: 0.30607008934021
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
\n
\n\n
[OT="old_comment_bit"]: Start time: 0.30654191970825
[OT="old_comment_bit"]: End time: 0.30680704116821
Query: select email,show_email from user where userid="138599"
Time before: 0.30967903137207
Time after: 0.3103449344635
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
\n
\n\n
[OT="old_comment_bit"]: Start time: 0.3109290599823
[OT="old_comment_bit"]: End time: 0.31119203567505
Query: select email,show_email from user where userid="12721"
Time before: 0.31676888465881
Time after: 0.31720304489136
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
\n
\n\n
[OT="old_comment_bit"]: Start time: 0.31766295433044
[OT="old_comment_bit"]: End time: 0.3184449672699
Query: select email,show_email from user where userid="138599"
Time before: 0.31967711448669
Time after: 0.3200089931488
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
\n
\n\n
[OT="old_comment_bit"]: Start time: 0.32051110267639
[OT="old_comment_bit"]: End time: 0.32094097137451
Query: select email,show_email from user where userid="12721"
Time before: 0.32378506660461
Time after: 0.35843801498413
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
\n
\n\n
[OT="old_comment_bit"]: Start time: 0.35969591140747
[OT="old_comment_bit"]: End time: 0.3599750995636
Query: select image_id from avatars where id="396723"
Time before: 0.36157393455505
Time after: 0.36542010307312
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
avatars const PRIMARY PRIMARY 4 const 1
\n
\n\n
Query: SELECT * FROM image_store WHERE image_id=4984369
Time before: 0.36641693115234
Time after: 0.36694407463074
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
image_store const PRIMARY PRIMARY 4 const 1
\n
\n\n
Query: select email,show_email from user where userid="23792"
Time before: 0.36843991279602
Time after: 0.36900591850281
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
\n
\n\n
[OT="old_comment_bit"]: Start time: 0.37488007545471
[OT="old_comment_bit"]: End time: 0.37524509429932
Query: select email,show_email from user where userid="138599"
Time before: 0.37691211700439
Time after: 0.37735795974731
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
\n
\n\n
[OT="old_comment_bit"]: Start time: 0.37805104255676
[OT="old_comment_bit"]: End time: 0.37832903862
Query: select image_id from avatars where id="20257"
Time before: 0.37939810752869
Time after: 0.37998509407043
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
avatars const PRIMARY PRIMARY 4 const 1
\n
\n\n
Query: SELECT * FROM image_store WHERE image_id=521486
Time before: 0.3805890083313
Time after: 0.38114094734192
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
image_store const PRIMARY PRIMARY 4 const 1
\n
\n\n
Query: select email,show_email from user where userid="4206"
Time before: 0.38161301612854
Time after: 0.38182711601257
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
\n
\n\n
[OT="old_comment_bit"]: Start time: 0.38245892524719
[OT="old_comment_bit"]: End time: 0.38283205032349
Query: select email,show_email from user where userid="138599"
Time before: 0.38383197784424
Time after: 0.38427710533142
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
\n
\n\n
[OT="old_comment_bit"]: Start time: 0.3848569393158
[OT="old_comment_bit"]: End time: 0.38513398170471
Query: select email,show_email from user where userid="24978"
Time before: 0.38606595993042
Time after: 0.38633990287781
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
\n
\n\n
[OT="old_comment_bit"]: Start time: 0.38701891899109
[OT="old_comment_bit"]: End time: 0.38729906082153
Query: select email,show_email from user where userid="138599"
Time before: 0.3926739692688
Time after: 0.3929591178894
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
\n
\n\n
[OT="old_comment_bit"]: Start time: 0.39357709884644
[OT="old_comment_bit"]: End time: 0.39386010169983
Query: select image_id from avatars where id="936404"
Time before: 0.39487504959106
Time after: 0.39544010162354
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
avatars const PRIMARY PRIMARY 4 const 1
\n
\n\n
Query: SELECT * FROM image_store WHERE image_id=12034338
Time before: 0.39587998390198
Time after: 0.39641094207764
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
image_store const PRIMARY PRIMARY 4 const 1
\n
\n\n
Query: select email,show_email from user where userid="4206"
Time before: 0.39732003211975
Time after: 0.39865589141846
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
\n
\n\n
[OT="old_comment_bit"]: Start time: 0.39913201332092
[OT="old_comment_bit"]: End time: 0.39940810203552
Query: select email,show_email from user where userid="138599"
Time before: 0.42273211479187
Time after: 0.42299890518188
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
\n
\n\n
[OT="old_comment_bit"]: Start time: 0.42473697662354
[OT="old_comment_bit"]: End time: 0.42501401901245
Query: select email,show_email from user where userid="205529"
Time before: 0.42610692977905
Time after: 0.42642688751221
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
\n
\n\n
[OT="old_comment_bit"]: Start time: 0.42697310447693
[OT="old_comment_bit"]: End time: 0.42733907699585
Query: select email,show_email from user where userid="4206"
Time before: 0.42826104164124
Time after: 0.42860698699951
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
\n
\n\n
[OT="old_comment_bit"]: Start time: 0.42964911460876
[OT="old_comment_bit"]: End time: 0.42992496490479
Query: select email,show_email from user where userid="138599"
Time before: 0.43121409416199
Time after: 0.4314169883728
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
\n
\n\n
[OT="old_comment_bit"]: Start time: 0.43190288543701
[OT="old_comment_bit"]: End time: 0.43215894699097
Query: select email,show_email from user where userid="138599"
Time before: 0.44664907455444
Time after: 0.45671510696411
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
\n
\n\n
[OT="old_comment_bit"]: Start time: 0.45735311508179
[OT="old_comment_bit"]: End time: 0.4577169418335
Query: select email,show_email from user where userid="4206"
Time before: 0.48307108879089
Time after: 0.48330092430115
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
\n
\n\n
[OT="old_comment_bit"]: Start time: 0.48400688171387
[OT="old_comment_bit"]: End time: 0.48539209365845
Query: select email,show_email from user where userid="210041"
Time before: 0.48719096183777
Time after: 0.48752593994141
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
\n
\n\n
[OT="old_comment_bit"]: Start time: 0.48821806907654
[OT="old_comment_bit"]: End time: 0.48848509788513
Query: select email,show_email from user where userid="138599"
Time before: 0.48963308334351
Time after: 0.48989701271057
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
\n
\n\n
[OT="old_comment_bit"]: Start time: 0.4903929233551
[OT="old_comment_bit"]: End time: 0.49068307876587
Query: select image_id from avatars where id="641457"
Time before: 0.49167799949646
Time after: 0.50310492515564
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
avatars const PRIMARY PRIMARY 4 const 1
\n
\n\n
Query: SELECT * FROM image_store WHERE image_id=8196057
Time before: 0.52280902862549
Time after: 0.52328491210938
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
image_store const PRIMARY PRIMARY 4 const 1
\n
\n\n
Query: select email,show_email from user where userid="210041"
Time before: 0.52383089065552
Time after: 0.52415108680725
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
\n
\n\n
[OT="old_comment_bit"]: Start time: 0.52510595321655
[OT="old_comment_bit"]: End time: 0.52558493614197
Query: select comments_access_mode,open from journal where userid="138599"
Time before: 0.52568006515503
Time after: 0.52607893943787
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
journal const PRIMARY,userid_open_ispub>ic PRIMARY 4 const 1
\n
\n\n
Query: set @x=0;
Time before: 0.52646708488464
Time after: 0.52675008773804
\n
\n\nQuery:
SELECT @x:=template_set_id
FROM template_set
WHERE set_name="codebuttons"
Time before: 0.52678298950195
Time after: 0.52728295326233
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
template_set ref tset_name tset_name 102 const 1 Using where
\n
\n\n
Query:
SELECT content
FROM template
WHERE template_set_id=@x
AND (group_id=2 or group_id =-1)
ORDER BY group_id DESC
LIMIT 1;
Time before: 0.52775192260742
Time after: 0.52837991714478
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
template ref template_set_id,group_id template_set_id 4 const 1 Using where; Using filesort
\n
\n\n
[OT="codebuttons"]: Start time: 0.52890110015869
[OT="codebuttons"]: End time: 0.53491497039795
Query: select count(*) from comment_subs where userid="210041" and postid="20428787"
Time before: 0.53505492210388
Time after: 0.53523588180542
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
comment_subs const PRIMARY,postid PRIMARY 8 const,const 1 Using index
\n
\n\n
Query: update comment_subs set new=0 where postid="20428787" and userid="210041"
Time before: 0.53582811355591
Time after: 0.53663802146912
\n
\n\nQuery: select count(*) from smile_favourite where userid="210041"
Time before: 0.53669190406799
Time after: 0.53774905204773
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
smile_favourite ref PRIMARY,userid PRIMARY 4 const 1 Using index
\n
\n\n
Query: set @x=0;
Time before: 0.53829288482666
Time after: 0.53846192359924
\n
\n\nQuery:
SELECT @x:=template_set_id
FROM template_set
WHERE set_name="journal_comment>_form"
Time before: 0.53849005699158
Time after: 0.53908395767212
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
template_set ref tset_name tset_name 102 const 1 Using where
\n
\n\n
Query:
SELECT content
FROM template
WHERE template_set_id=@x
AND (group_id=2 or group_id =-1)
ORDER BY group_id DESC
LIMIT 1;
Time before: 0.5396740436554
Time after: 0.54060697555542
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
template ref template_set_id,group_id template_set_id 4 const 1 Using where; Using filesort
\n
\n\n
[OT="journal_comment_form>"]: Start time: 0.54138708114624
[OT="journal_comment_form>"]: End time: 0.54181289672852
Query: select count(*) from umail where owner_user_id="210041" and is_readed=0
Time before: 0.54208993911743
Time after: 0.54274892807007
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
umail ref owner_user_id,owner_user_>id_folder_id_idx owner_user_id 5 const,const 1 Using index
\n
\n\n
Query: select sum(new) from comment_subs where userid="210041"
Time before: 0.5434410572052
Time after: 0.54959797859192
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
comment_subs ref PRIMARY PRIMARY 4 const 740
\n
\n\n
Query: select stat_access_mode,open from journal where userid="138599"
Time before: 0.55164194107056
Time after: 0.55223298072815
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
journal const PRIMARY,userid_open_ispub>ic PRIMARY 4 const 1
\n
\n\n
Query: select album_access_mode,open from journal where userid="138599"
Time before: 0.55283904075623
Time after: 0.55338311195374
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
journal const PRIMARY,userid_open_ispub>ic PRIMARY 4 const 1
\n
\n\n
Query: select email,show_email from user where userid="138599"
Time before: 0.55897188186646
Time after: 0.55928802490234
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
\n
\n\n
Query: select count(*) from favourites where owner_id="210041"
and userid="138599"
Time before: 0.55995202064514
Time after: 0.56035494804382
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
favourites const PRIMARY,owner_id,userid PRIMARY 8 const,const 1 Using index
\n
\n\n
Query: select count(*) from journal_subscribe where userid="210041"
and juserid="138599"
Time before: 0.56085109710693
Time after: 0.56132006645203
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
journal_subscribe ref juserid juserid 8 const,const 1 Using index
\n
\n\n
Query: set @x=0;
Time before: 0.56180906295776
Time after: 0.56198811531067
\n
\n\nQuery:
SELECT @x:=template_set_id
FROM template_set
WHERE set_name="journal_menu_ol>d"
Time before: 0.56201696395874
Time after: 0.56261110305786
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
template_set ref tset_name tset_name 102 const 1 Using where
\n
\n\n
Query:
SELECT content
FROM template
WHERE template_set_id=@x
AND (group_id=2 or group_id =-1)
ORDER BY group_id DESC
LIMIT 1;
Time before: 0.5631890296936
Time after: 0.56402397155762
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
template ref template_set_id,group_id template_set_id 4 const 1 Using where; Using filesort
\n
\n\n
[OT="journal_menu_old"]: Start time: 0.56459498405457
[OT="journal_menu_old"]: End time: 0.56630897521973
Query: INSERT advert_view SET userid='210041',ref='/~as>ia-al-medham?comments&po>stid=20428787&from=last',dateline='1166552607',adname='>begun',ip='217.13.210.169',`count`='4',class=0,typ>e=0
Time before: 0.63135695457458
Time after: 0.63343811035156
\n
\n\nQuery: set @x=0;
Time before: 0.63355994224548
Time after: 0.63408803939819
\n
\n\nQuery:
SELECT @x:=template_set_id
FROM template_set
WHERE set_name="journal_old"
Time before: 0.63413691520691
Time after: 0.63454103469849
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
template_set ref tset_name tset_name 102 const 1 Using where
\n
\n\n
Query:
SELECT content
FROM template
WHERE template_set_id=@x
AND (group_id=2 or group_id =-1)
ORDER BY group_id DESC
LIMIT 1;
Time before: 0.63549208641052
Time after: 0.63656497001648
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
template ref template_set_id,group_id template_set_id 4 const 1 Using where; Using filesort
\n
\n\n
[OT="journal_old"]: Start time: 0.63787198066711
[OT="journal_old"]: End time: 0.64195489883423
Query: SELECT findword, replaceword FROM replacement where replacementsetid<>-1
Time before: 0.64206099510193
Time after: 0.64246702194214
\n (storm.kubic.ru) table type possible_keys key key_len ref rows Extra
replacement ALL replacementsetid 80 Using where
\n
\n\n
|