db_queries.log растет

[hrulik]

С какого обновления стал сильно расти db_queries.log почти сотня мегабайт внутри примерно такое:

Code: Select all

10:39::query_time=109.2841770649::query=insert IGNORE into rot_gal2tag (site_id, gallery_id, tag_id) select 37, gallery_id, tag_id from rot_gal2tag where site_id = 1:: <= ...scj/admin/files/rot_settings.php (db_query) (time: 109.2841770649) <= ...scj/admin/index.php (unknown) (time: 109.2841770649)
07:36::query_time=18.200124025345::query=SELECT gt.tag_id, t.tag_name as tag_name, count(*) as hits FROM rot_gal2tag AS gt^M
                        left join rot_tags as t on t.tag_id = gt.tag_id^M
                        WHERE t.status = 'active'^M
                        GROUP BY gt.tag_id order by tag_name :: <= ...scj/bin/rotation.php (db_query) (time: 18.200124025345)
07:41::query_time=56.115200996399::query=INSERT INTO `rot_gallery_stats38` SELECT * FROM `rot_gallery_stats1` :: <= ...scj/admin/files/fastedit.php (db_query) (time: 56.115200996399) <= ...scj/admin/index.php (unknown) (time: 56.115200996399)
07:43::query_time=65.311324119568::query=insert IGNORE into rot_gal2tag (site_id, gallery_id, tag_id) select 38, gallery_id, tag_id from rot_gal2tag where site_id = 1:: <= ...scj/admin/files/rot_settings.php (db_query) (time: 65.311324119568) <= ...scj/admin/index.php (unknown) (time: 65.311324119568)
09:34::query_time=18.754151821136::query=SELECT gt.tag_id, t.tag_name as tag_name, count(*) as hits FROM rot_gal2tag AS gt^M
                        left join rot_tags as t on t.tag_id = gt.tag_id^M
                        WHERE t.status = 'active'^M
                        GROUP BY gt.tag_id order by tag_name :: <= ...scj/bin/rotation.php (db_query) (time: 18.754151821136)
11:27::query_time=3.6985709667206::query=SELECT group_id, count(distinct(gs.gallery_id)) as total FROM rot_gallery_stats1 as gs ^M
                        JOIN rot_gallery_info as gi on gi.gallery_id = gs.gallery_id^M
                        WHERE gi.gallery_status = 'active'  AND gi.gallery_type = 0  and gs.best_thumb = 'yes'          group by group_id :: <= ...scj/bin/rotation.php (db_query) (time: 3.6985709667206) <= ...scj/bin/rotation.php (cat0_categories) (time: 3.6985709667206)
11:29::query_time=17.966393947601::query=SELECT gt.tag_id, t.tag_name as tag_name, count(*) as hits FROM rot_gal2tag AS gt^M
                        left join rot_tags as t on t.tag_id = gt.tag_id^M
                        WHERE t.status = 'active'^M
                        GROUP BY gt.tag_id order by tag_name :: <= ...scj/bin/rotation.php (db_query) (time: 17.966393947601)
16:44::query_time=3.327064037323::query=SELECT   gs.gallery_id, gs.thumb_id, gi.sponsor_id, gi.content_count, gi.content_type, gs.total_shows, gs.total_clicks, gs.total_ctr, gt.thumb_url, gd.*, gi.content_count, gi.crop_profile_id, gs.activation_date, gi.added_date, gi.duration, gi.url, gi.gallery_total_shows, gi.sponsor_id, gi.source_url, gi.custom_gallery  FROM rot_gallery_stats38 as gs  STRAIGHT_JOIN rot_gallery_info as gi on gi.gallery_id = gs.gallery_id
STRAIGHT_JOIN rot_gallery_data38 as gd on gd.gallery_id = gs.gallery_id

JOIN rot_gal2tag on rot_gal2tag.gallery_id = gs.gallery_id
  JOIN rot_thumbs as gt on gt.thumb_id = gs.thumb_id ^M
                        WHERE 1 = 1  AND gi.gallery_status = 'active'  AND gi.gallery_type = 0  and gs.best_thumb = 'yes'  and gs.group_id = 0  AND gi.gallery_id IN (0,28653,18262,33676,48087,15767,59122,102969,83835,89012,50371,130889,51226,50284,50132,67613,49690,42646,50310,47948,19575,107257,51225,49509,93592,84042,51098,51485,16170,49475,114797,51219,26497,49800,86444,50418,48000,97428,30004,88861,48021,68487,51043,48866,57454,49045,50279,51233,50680,50314,49363)  ORDER BY field(gs.gallery_id, '0','28653','18262','33676','48087','15767','59122','102969','83835','89012','50371','130889','51226','50284','50132','67613','49690','42646','50310','47948','19575','107257','51225','49509','93592','84042','51098','51485','16170','49475','114797','51219','26497','49800','86444','50418','48000','97428','30004','88861','48021','68487','51043','48866','57454','49045','50279','51233','50680','50314','49363')# queryitems:: <= ...scj/includes/libs/tpl_tags.php (db_query) (time: 3.327064037323) <= ...scj/includes/libs/tpl_tags.php (rot_get_item_execute_query) (time: 3.327064037323) <= ...scj/includes/libs/tpl_functions.php (rot_get_items) (time: 3.327064037323) <= ...scj/tube/index.php (rot_create_page) (time: 3.327064037323)

Если я правильно понимаю сюда медленные запросы падают. Это сильно плохо? и как бороться?

[admin]

да, медленные запросы

если 100 метров то думаю у вас крон запускается как-то хитро, типа раз в 10 минут и потому не обрезает логи

так то запросы там не страшные - это при создании нового слейва из админки эти запросы идут.

[hrulik]

раз в минуту крон, стандартно, на старых слейвах таже картина, и на мастере тоже вот пример запроса с мастера:

Code: Select all

18:20::query_time=30.159228086472::query=UPDATE IGNORE rot_gallery_stats1 SET total_ctr = CASE  WHEN thumb_id = '1538' THEN '0.033665759756507'  WHEN thumb_id = '1542' THEN '0.034175213978465'  WHEN thumb_id = '1554' THEN '0.0086759618715045'  WHEN thumb_id = '1566' THEN '0.030519579609809'  WHEN thumb_id = '1611' THEN '0.022651605218538'  WHEN thumb_id = '1626' THEN '0.020232086729839'  WHEN thumb_id = '1677' THEN '0.018204626667199'  WHEN thumb_id = '1683' THEN '0.02968721569832'  WHEN thumb_id = '1686' THEN '0.015200456978228'  WHEN thumb_id = '1694' THEN '0.014275701976563'  WHEN thumb_id = '1774' THEN '0.02826103539055'  WHEN thumb_id = '1798' THEN '0.010248803422576'  WHEN thumb_id = '1808' THEN '0.045969278692054'  WHEN thumb_id = '1812' THEN '0.034222072763549'  WHEN thumb_id = '1866' THEN '0.025860872682874'  WHEN thumb_id = '1868' THEN '0.060885297003558'  WHEN thumb_id = '1940' THEN '0.015503214511899'  WHEN thumb_id = '1957' THEN '0.02851659391105'  WHEN thumb_id = '2024' THEN '0.024959556443832'  WHEN thumb_id = '2170' THEN '0.031936824912568'  WHEN thumb_id = '2254' THEN '0.04928645688802'  WHEN thumb_id = '2352' THEN '0.054586571502629'  WHEN thumb_id = '2369' THEN '0.02148343420446'  WHEN thumb_id = '2440' THEN '0.029526579031234'  WHEN thumb_id = '2508' THEN '0.0066504246801496'  WHEN thumb_id = '2540' THEN '0.01644867200205'  WHEN thumb_id = '2557' THEN '0.052940580969923'  WHEN thumb_id = '2648' THEN '0.032482161358596'  WHEN thumb_id = '23072' THEN '0.0020844197621853'  WHEN thumb_id = '23073' THEN '0.020435596799725'  WHEN thumb_id = '23100' THEN '0.014503725084736'  WHEN thumb_id = '23101' THEN '0.020270244366243'  WHEN thumb_id = '23107' THEN '0.025877909135814'  WHEN thumb_id = '23131' THEN '0.026668973931719'  WHEN thumb_id = '23141' THEN '0.018257615953429'  WHEN thumb_id = '23356' THEN '0.019941860189544'  WHEN thumb_id = '23375' THEN '0.011719619723214'  WHEN thumb_id = '23376' THEN '0.022270936432761'  WHEN thumb_id = '23493' THEN '0.0041198463065294'  WHEN thumb_id = '23697' THEN '0.012255502908999'  WHEN thumb_id = '23755' THEN '0.002697471557208'  WHEN thumb_id = '23757' THEN '0.022083165511936'  WHEN thumb_id = '23870' THEN '0.021743721512715'  WHEN thumb_id = '23872' THEN '0.036283822708863'  WHEN thumb_id = '23876' THEN '0.018459599487241'  WHEN thumb_id = '30019' THEN '0.018737713663026'  WHEN thumb_id = '30035' THEN '0.024711433884804'  WHEN thumb_id = '30036' THEN '0.017629193925557'  WHEN thumb_id = '30039' THEN '0.014729180451815'  WHEN thumb_id = '30065' THEN '0.020039654321069'  WHEN thumb_id = '30072' THEN '0.017592138739929'  WHEN thumb_id = '30194' THEN '0.0028985754335809'  WHEN thumb_id = '30214' THEN '0.0065420351517595'  WHEN thumb_id = '30221' THEN '0.022969609578588'  WHEN thumb_id = '30222' THEN '0.017651511391524'  WHEN thumb_id = '30371' THEN '0.022977204848443'  WHEN thumb_id = '30405' THEN '0.01886280115722'  WHEN thumb_id = '30597' THEN '0.041071122749211'  WHEN thumb_id = '30609' THEN '0.024039482105126'  WHEN thumb_id = '30615' THEN '0.021862129342537'  WHEN thumb_id = '30730' THEN '0.016894423708052'  WHEN thumb_id = '30732' THEN '0.0036831320100528'  WHEN thumb_id = '30782' THEN '0.034428948301676'  WHEN thumb_id = '30797' THEN '0.024940125716543'  WHEN thumb_id = '30910' THEN '0.03100015334201'  WHEN thumb_id = '30919' THEN '0.014785356084692'  WHEN thumb_id = '30924' THEN '0.017894314746892'  WHEN thumb_id = '30943' THEN '0.020798193963027'  WHEN thumb_id = '31132' THEN '0.014739506936891'  WHEN thumb_id = '31137' THEN '0.018512591727855'  WHEN thumb_id = '31142' THEN '0.020910073674244'  WHEN thumb_id = '31163' THEN '0.016739298747259'  WHEN thumb_id = '31183' THEN '0.005771610486991'  WHEN thumb_id = '31292' THEN '0.061422589695251'  WHEN thumb_id = '31308' THEN '0.010500834303322'  WHEN thumb_id = '31327' THEN '0.022788101808924'  WHEN thumb_id = '31329' THEN '0.044774752256923'  WHEN thumb_id = '31342' THEN '0.037483558421245'  WHEN thumb_id = '31349' THEN '0.020173254147364'  WHEN thumb_id = '31351' THEN '0.022091885627637'  WHEN thumb_id = '31353' THEN '0.023152491316702'  WHEN thumb_id = '31354' THEN '0.027709993688749'  WHEN thumb_id = '31474' THEN '0.017891308531116'  WHEN thumb_id = '31482' THEN '0.01781137827514'  WHEN thumb_id = '31514' THEN '0.016650150345742'  WHEN thumb_id = '31518' THEN '0.016383152366682'  WHEN thumb_id = '31519' THEN '0.024397117021624'  WHEN thumb_id = '31520' THEN '0.022044645003348'  WHEN thumb_id = '31525' THEN '0.01297620126318'  WHEN thumb_id = '31944' THEN '0.0024495687786491'  WHEN thumb_id = '31955' THEN '0.0068355457910546'  WHEN thumb_id = '31963' THEN '0.0067261412354608'  WHEN thumb_id = '32095' THEN '0.0031357097682862'  WHEN thumb_id = '32104' THEN '0.0052166523540668'  WHEN thumb_id = '32106' THEN '0.0070344654246434'  WHEN thumb_id = '32126' THEN '0.016114358109278'  WHEN thumb_id = '32127' THEN '0.026786266403161'  WHEN thumb_id = '32128' THEN '0.027733315956871'  WHEN thumb_id = '32132' THEN '0.017078764519509'  WHEN thumb_id = '32133' THEN '0.037920452837118'  WHEN thumb_id = '32134' THEN '0.024376173144807'  WHEN thumb_id = '32137' THEN '0.016866970594662'  WHEN thumb_id = '32142' THEN '0.027566601235721'  WHEN thumb_id = '32148' THEN '0.047454229948516'  WHEN thumb_id = '32154' THEN '0.045314153242749'  WHEN thumb_id = '32159' THEN '0.031549501652301'  WHEN thumb_id = '32164' THEN '0.0088661745912623'  WHEN thumb_id = '32269' THEN '0.038459400186527'  WHEN thumb_id = '32270' THEN '0.0049888751501745'  WHEN thumb_id = '32282' THEN '0.018675070956121'  WHEN thumb_id = '32298' THEN '0.018171835178358'  WHEN thumb_id = '32300' THEN '0.017049447417273'  WHEN thumb_id = '32310' THEN '0.013376509371699'  WHEN thumb_id = '32315' THEN '0.017629419906521'  WHEN thumb_id = '32331' THEN '0.018552716054197'  WHEN thumb_id = '32345' THEN '0.0021457587071749'  WHEN thumb_id = '32346' THEN '0.0040394158245153'  WHEN thumb_id = '32455' THEN '0.012857892966814'  WHEN thumb_id = '32460' THEN '0.010391526228167'  WHEN thumb_id = '32471' THEN '0.012939222100139'  WHEN thumb_id = '32472' THEN '0.041130023469313'  WHEN thumb_id = '32514' THEN '0.016296733322222'  WHEN thumb_id = '32516' THEN '0.0076188574460667'  WHEN thumb_id = '32672' THEN '0.018086468026996'  WHEN thumb_id = '32673' THEN '0.0097089685315134'  WHEN thumb_id = '32674' THEN '0.009079605064175'  WHEN thumb_id = '32675' THEN '0.018397585921863'  WHEN thumb_id = '32676' THEN '0.0093319986920538'  WHEN thumb_id = '32677' THEN '0.0383875109705'  WHEN thumb_id = '32678' THEN '0.018501566497779'  WHEN thumb_id = '32679' THEN '0.011951696754221'  WHEN thumb_id = '32680' THEN '0.037848034935505'  WHEN thumb_id = '32681' THEN '0.012906813140314'  WHEN thumb_id = '32682' THEN '0.0027460618607306'  WHEN thumb_id = '32684' THEN '0.019720647916087'  WHEN thumb_id = '32686' THEN '0.012042903661329'  WHEN thumb_id = '32687' THEN '0.018849770663592'  WHEN thumb_id = '32688' THEN '0.014918485851842'  WHEN thumb_id = '32691' THEN '0.029235471749714'  WHEN thumb_id = '38572' THEN '0.056906318707723'  WHEN thumb_id = '38575' THEN '0.050508539608838'  WHEN thumb_id = '38576' THEN '0.021105760375132'  WHEN thumb_id = '38578' THEN '0.021479661413208'  WHEN thumb_id = '38841' THEN '0.013871883110788'  WHEN thumb_id = '38853' THEN '0.018765280083193'  WHEN thumb_id = '38877' THEN '0.014902984095162'  WHEN thumb_id = '38997' THEN '0.018414643196089'  WHEN thumb_id = '39005' THEN '0.017180700074432'  WHEN thumb_id = '39028' THEN '0.023553946354215'  WHEN thumb_id = '39036' THEN '0.063653470836645'  WHEN thumb_id = '39049' THEN '0.020013732610188'  WHEN thumb_id = '39071' THEN '0.011130431712836'  WHEN thumb_id = '39205' THEN '0.023336111157704'  WHEN thumb_id = '39248' THEN '0.018983434514423'  WHEN thumb_id = '39252' THEN '0.020431348823479'  WHEN thumb_id = '39256' THEN '0.028857638416572'  WHEN thumb_id = '39265' THEN '0.013235357907396'  WHEN thumb_id = '39367' THEN '0.026827126927807'  WHEN thumb_id = '39382' THEN '0.011817410879732'  WHEN thumb_id = '39398' THEN '0.016560818698506'  WHEN thumb_id = '39563' THEN '0.018801833612009'  WHEN thumb_id = '39564' THEN '0.01949080544196'  WHEN thumb_id = '39594' THEN '0.015444682256327'  WHEN thumb_id = '39604' THEN '0.012788547128544'  WHEN thumb_id = '39612' THEN '0.046015990611505'  WHEN thumb_id = '39624' THEN '0.038066373838712'  WHEN thumb_id = '39626' THEN '0.016309866070613'  WHEN thumb_id = '39627' THEN '0.011861464405547'  WHEN thumb_id = '39629' THEN '0.04638000877853'  WHEN thumb_id = '39630' THEN '0.024472563575246'  WHEN thumb_id = '39637' THEN '0.023983811448787'  WHEN thumb_id = '39639' THEN '0.017291441069018'  WHEN thumb_id = '39640' THEN '0.03015076179662'  WHEN thumb_id = '39759' THEN '0.049496663972589'  WHEN thumb_id = '39769' THEN '0.018760307288019'  WHEN thumb_id = '39774' THEN '0.020415418144336'  WHEN thumb_id = '39777' THEN '0.033901877439565'  WHEN thumb_id = '39783' THEN '0.016311635566622'  WHEN thumb_id = '39784' THEN '0.017769127217485'  WHEN thumb_id = '39787' THEN '0.013130049712417'  WHEN thumb_id = '39789' THEN '0.008481334142328'  WHEN thumb_id = '39795' THEN '0.012487623264843'  WHEN thumb_id = '39802' THEN '0.015225636137767'  WHEN thumb_id = '39815' THEN '0.018886423915642'  WHEN thumb_id = '39820' THEN '0.034226138245871'  WHEN thumb_id = '39821' THEN '0.023870480368183'  WHEN thumb_id = '39957' THEN '0.021483379370148'  WHEN thumb_id = '39966' THEN '0.026531572399493'  WHEN thumb_id = '39976' THEN '0.030100386046115'  WHEN thumb_id = '39982' THEN '0.020077564329869'  WHEN thumb_id = '39983' THEN '0.010898214239008'  WHEN thumb_id = '39984' THEN '0.012462998404193'  WHEN thumb_id = '39985' THEN '0.010473916848505'  WHEN thumb_id = '39987' THEN '0.013101494917513'  WHEN thumb_id = '40003' THEN '0.013578497227847'  WHEN thumb_id = '40134' THEN '0.020488610918857'  WHEN thumb_id = '40177' THEN '0.018222764927699'  WHEN thumb_id = '40316' THEN '0.02139816438118'  WHEN thumb_id = '40327' THEN '0.015834245072265'  WHEN thumb_id = '40342' THEN '0.017376283840216'  WHEN thumb_id = '40455' THEN '0.043666418946886'  WHEN thumb_id = '40456' THEN '0.017532645540211'  WHEN thumb_id = '40467' THEN '0.019377042437194'  WHEN thumb_id = '40473' THEN '0.036850552395361'  WHEN thumb_id = '40482' THEN '0.018742744016187'  WHEN thumb_id = '40500' THEN '0.014231362450947'  WHEN thumb_id = '40681' THEN '0.012280555072109'  WHEN thumb_id = '40804' THEN '0.006963001122126'  WHEN thumb_id = '40829' THEN '0.02545828797744'  WHEN thumb_id = '40831' THEN '0.035657962171551'  WHEN thumb_id = '40957' THEN '0.027093193173275'  WHEN thumb_id = '40965' THEN '0.021515018893577'  WHEN thumb_id = '40968' THEN '0.028964710766364'  WHEN thumb_id = '40975' THEN '0.0017540780050723'  WHEN thumb_id = '40982' THEN '0.016303193427775'  WHEN thumb_id = '40983' THEN '0.020950219521611'  WHEN thumb_id = '40987' THEN '0.012470148010219'  WHEN thumb_id = '41004' THEN '0.020598581070117'  WHEN thumb_id = '41010' THEN '0.0088532967070984'  WHEN thumb_id = '41015' THEN '0.013344029840465'  WHEN thumb_id = '41046' THEN '0.016770030645392'  WHEN thumb_id = '41139' THEN '0.0088172853640236'  WHEN thumb_id = '41143' THEN '0.018187733714575'  WHEN thumb_id = '41149' THEN '0.040449350686727'  WHEN thumb_id = '41179' THEN '0.036031874321058'  WHEN thumb_id = '41181' THEN '0.021263195899912'  WHEN thumb_id = '41186' THEN '0.018148688622621'  WHEN thumb_id = '41188' THEN '0.020152449324821'  WHEN thumb_id = '41190' THEN '0.015173548285478'  WHEN thumb_id = '41191' THEN '0.015156252673798'  WHEN thumb_id = '41198' THEN '0.019374053191705'  WHEN thumb_id = '41199' THEN '0.006831946674081'  WHEN thumb_id = '41202' THEN '0.0015556990152543'  WHEN thumb_id = '41208' THEN '0.0058618330041772'  WHEN thumb_id = '41214' THEN '0.012907845635234'  WHEN thumb_id = '41215' THEN '0.006768468547244'  WHEN thumb_id = '41217' THEN '0.0020160567489365'  WHEN thumb_id = '41305' THEN '0.022842552341571'  WHEN thumb_id = '41314' THEN '0.023068277893185'  WHEN thumb_id = '41317' THEN '0.017283421895356'  WHEN thumb_id = '41318' THEN '0.01327675659913'  WHEN thumb_id = '41345' THEN '0.010610468552107'  WHEN thumb_id = '41357' THEN '0.022505279286558'  WHEN thumb_id = '41364' THEN '0.016815260087474'  WHEN thumb_id = '41497' THEN '0.025426673738206'  WHEN thumb_id = '41498' THEN '0.019919360776061'  WHEN thumb_id = '41523' THEN '0.0052622985908063'  WHEN thumb_id = '41542' THEN '0.015108373221399'  WHEN thumb_id = '41554' THEN '0.02446105765644'  WHEN thumb_id = '41671' THEN '0.016460027978692'  WHEN thumb_id = '41674' THEN '0.049967661680902'  WHEN thumb_id = '41676' THEN '0.019491124919501'  WHEN thumb_id = '41680' THEN '0.013573435644717'  WHEN thumb_id = '41684' THEN '0.017996781398712'  WHEN thumb_id = '41686' THEN '0.019282103941405'  WHEN thumb_id = '41689' THEN '0.015378231219942'  WHEN thumb_id = '41694' THEN '0.020499730007109'  WHEN thumb_id = '41698' THEN '0.01816564365135'  WHEN thumb_id = '41700' THEN '0.019683694598454'  WHEN thumb_id = '41703' THEN '0.010381806936662'  WHEN thumb_id = '42183' THEN '0.017894421899544'  WHEN thumb_id = '42477' THEN '0.0014864609464686'  WHEN thumb_id = '42481' THEN '0.020792842918686'  WHEN thumb_id = '42484' THEN '0.0014290896796275'  WHEN thumb_id = '43878' THEN '0.021605558171765'  WHEN thumb_id = '44130' THEN '0.023738603203094'  WHEN thumb_id = '44148' THEN '0.026305911093594'  WHEN thumb_id = '44187' THEN '0.023933835395003'  WHEN thumb_id = '44243' THEN '0.022421484783461'  WHEN thumb_id = '44261' THEN '0.034065724460321'  WHEN thumb_id = '44375' THEN '0.015610376663126'  WHEN thumb_id = '44463' THEN '0.014708074470157'  WHEN thumb_id = '44493' THEN '0.0096700165819193'  WHEN thumb_id = '44521' THEN '0.020731090022682'  WHEN thumb_id = '44539' THEN '0.022432251362536'  WHEN thumb_id = '44582' THEN '0.024889172195816'  WHEN thumb_id = '44624' THEN '0.021677276966635'  WHEN thumb_id = '44761' THEN '0.019024433814664'  WHEN thumb_id = '44804' THEN '0.018568703251824'  WHEN thumb_id = '44839' THEN '0.01931239688172'  WHEN thumb_id = '44877' THEN '0.01903213993056'  WHEN thumb_id = '44890' THEN '0.0018876957742289'  WHEN thumb_id = '44901' THEN '0.016112948405611'  WHEN thumb_id = '44903' THEN '0.022035677295406'  WHEN thumb_id = '44959' THEN '0.022156759365329'  WHEN thumb_id = '44979' THEN '0.015834053913294'  WHEN thumb_id = '45013' THEN '0.009360728408197'  WHEN thumb_id = '45019' THEN '0.02175917992053'  WHEN thumb_id = '45150' THEN '0.017094702352746'  WHEN thumb_id = '45163' THEN '0.0079773301894723'  WHEN thumb_id = '45171' THEN '0.020937081521908'  WHEN thumb_id = '45174' THEN '0.021839176817554'  WHEN thumb_id = '45208' THEN '0.016131345145837'  WHEN thumb_id = '45235' THEN '0.0067502554650515'  WHEN thumb_id = '45372' THEN '0.0094827733824019'  WHEN thumb_id = '45381' THEN '0.022164386962082'  WHEN thumb_id = '45398' THEN '0.011439398772437'  WHEN thumb_id = '45402' THEN '0.021330538429131'  WHEN thumb_id = '45406' THEN '0.01963935727056'  WHEN thumb_id = '45411' THEN '0.0026965539383016'  WHEN thumb_id = '45451' THEN '0.014144706916855'  WHEN thumb_id = '45529' THEN '0.0081912527440753'  WHEN thumb_id = '45563' THEN '0.0084379372582516'  WHEN thumb_id = '45595' THEN '0.030748016992529'  WHEN thumb_id = '45662' THEN '0.013494251374669'  WHEN thumb_id = '45676' THEN '0.018950201237263'  WHEN thumb_id = '45724' THEN '0.011990920485515'  WHEN thumb_id = '45782' THEN '0.0027102901684487'  WHEN thumb_id = '45811' THEN '0.015092576612119'  WHEN thumb_id = '45826' THEN '0.011593018456749'  WHEN thumb_id = '45827' THEN '0.017681512432689'  WHEN thumb_id = '46027' THEN '0.002232500127748'  WHEN thumb_id = '46064' THEN '0.016122912011024'  WHEN thumb_id = '46182' THEN '0.026765924239147'  WHEN thumb_id = '46282' THEN '0.01755530011217'  WHEN thumb_id = '46527' THEN '0.0078115588754948'  WHEN thumb_id = '46598' THEN '0.0093704581586241'  WHEN thumb_id = '46610' THEN '0.019596757048294'  WHEN thumb_id = '46681' THEN '0.01137344354926'  WHEN thumb_id = '46732' THEN '0.019398670879544'  WHEN thumb_id = '46733' THEN '0.012867678819801'  WHEN thumb_id = '46759' THEN '0.015532529138067'  WHEN thumb_id = '46859' THEN '0.016582527109953'  WHEN thumb_id = '46865' THEN '0.015205669544078'  WHEN thumb_id = '46934' THEN '0.024605955193065'  WHEN thumb_id = '47109' THEN '0.02014837520301'  WHEN thumb_id = '47145' THEN '0.0019944979053505'  WHEN thumb_id = '47285' THEN '0.0023629048359191'  WHEN thumb_id = '47298' THEN '0.014661512386889'  WHEN thumb_id = '47392' THEN '0.023890697215968'  WHEN thumb_id = '47432' THEN '0.013537423250565'  WHEN thumb_id = '47456' THEN '0.0047912526888804'  WHEN thumb_id = '47463' THEN '0.021522177715877'  WHEN thumb_id = '47670' THEN '0.021245871433417'  WHEN thumb_id = '47672' THEN '0.030770683489319'  WHEN thumb_id = '47721' THEN '0.00087992529797667'  WHEN thumb_id = '47745' THEN '0.019024486678659'  WHEN thumb_id = '47843' THEN '0.015298302924895'  WHEN thumb_id = '47984' THEN '0.0053534051495495'  WHEN thumb_id = '48088' THEN '0.016947700047757'  WHEN thumb_id = '48110' THEN '0.018845136022914'  WHEN thumb_id = '48135' THEN '0.010786139406569'  WHEN thumb_id = '48159' THEN '0.020319046220915'  WHEN thumb_id = '48180' THEN '0.011766936306703'  WHEN thumb_id = '48398' THEN '0.0076504286804663'  WHEN thumb_id = '48475' THEN '0.012181650194709'  WHEN thumb_id = '48484' THEN '0.012385094578139'  WHEN thumb_id = '48565' THEN '0.0045886002312093'  WHEN thumb_id = '48583' THEN '0.006807085586312'  WHEN thumb_id = '48589' THEN '0.017593570873906'  WHEN thumb_id = '48614' THEN '0.016915226681621'  WHEN thumb_id = '48636' THEN '0.021629641561696'  WHEN thumb_id = '48682' THEN '0.018259836141731'  WHEN thumb_id = '48688' THEN '0.0080712912764922'  WHEN thumb_id = '48764' THEN '0.01965468220834'  WHEN thumb_id = '48794' THEN '0.017765738161319'  WHEN thumb_id = '48946' THEN '0.016238040222813'  WHEN thumb_id = '48974' THEN '0.013718469345789'  WHEN thumb_id = '48988' THEN '0.060403586863749'  WHEN thumb_id = '49013' THEN '0.00081041468515394'  WHEN thumb_id = '49074' THEN '0.018353015299499'  WHEN thumb_id = '49324' THEN '0.01834468110373'  WHEN thumb_id = '49332' THEN '0.019713993767484'  WHEN thumb_id = '49339' THEN '0.017294130786879'  WHEN thumb_id = '49355' THEN '0.0088199530378363'  WHEN thumb_id = '49379' THEN '0.013195960972697'  WHEN thumb_id = '49518' THEN '0.016478897152035'  WHEN thumb_id = '49542' THEN '0.0063581767912735'  WHEN thumb_id = '49588' THEN '0.018018976989125'  WHEN thumb_id = '49663' THEN '0.018035959438353'  WHEN thumb_id = '49673' THEN '0.019244276024846'  WHEN thumb_id = '49694' THEN '0.015039645052546'  WHEN thumb_id = '49750' THEN '0.019133476541548'  WHEN thumb_id = '49794' THEN '0.052482045086999'  WHEN thumb_id = '49799' THEN '0.021893330084583'  WHEN thumb_id = '49824' THEN '0.019233139605541'  WHEN thumb_id = '49857' THEN '0.018822704166313'  WHEN thumb_id = '49914' THEN '0.020868896626631'  WHEN thumb_id = '49930' THEN '0.0056770910875253'  WHEN thumb_id = '50180' THEN '0.013298945174417'  WHEN thumb_id = '50247' THEN '0.0074764292961796'  WHEN thumb_id = '50292' THEN '0.0021856935165713'  WHEN thumb_id = '50325' THEN '0.016330445357642'  WHEN thumb_id = '50427' THEN '0.01328744286934'  WHEN thumb_id = '50469' THEN '0.007333848341682'  WHEN thumb_id = '50476' THEN '0.014783693549385'  WHEN thumb_id = '50498' THEN '0.016986069718654'  WHEN thumb_id = '50505' THEN '0.016118225196581'  WHEN thumb_id = '50518' THEN '0.018745313736815'  WHEN thumb_id = '50544' THEN '0.017497423804242'  WHEN thumb_id = '50715' THEN '0.018997357316272'  WHEN thumb_id = '50778' THEN '0.0078696981171739'  WHEN thumb_id = '50822' THEN '0.020081758171487'  WHEN thumb_id = '50827' THEN '0.014927702762679'  WHEN thumb_id = '50833' THEN '0.0077340359600444'  WHEN thumb_id = '50858' THEN '0.038934502309817'  WHEN thumb_id = '50929' THEN '0.022204417620212'  WHEN thumb_id = '50979' THEN '0.013420917768698'  WHEN thumb_id = '51026' THEN '0.014433610537671'  WHEN thumb_id = '51034' THEN '0.01630520067047'  WHEN thumb_id = '51109' THEN '0.019134541650997'  WHEN thumb_id = '51123' THEN '0.019159676898745'  WHEN thumb_id = '51128' THEN '0.011950183016904'  WHEN thumb_id = '51284' THEN '0.0020426795462062'  WHEN thumb_id = '51352' THEN '0.019967256433952'  WHEN thumb_id = '51389' THEN '0.01761289919365'  WHEN thumb_id = '51405' THEN '0.01305553903491'  WHEN thumb_id = '51415' THEN '0.021070553816472'  WHEN thumb_id = '51421' THEN '0.018135426072958'  WHEN thumb_id = '51453' THEN '0.019122036194576'  WHEN thumb_id = '51524' THEN '0.014895382328544'  WHEN thumb_id = '51566' THEN '0.020240978222463'  WHEN thumb_id = '51594' THEN '0.017081324137946'  WHEN thumb_id = '51616' THEN '0.02011133686051'  WHEN thumb_id = '51750' THEN '0.015465324482731'  WHEN thumb_id = '51755' THEN '0.017315856004062'  WHEN thumb_id = '51777' THEN '0.0084703652999573'  WHEN thumb_id = '51789' THEN '0.018347334360853'  WHEN thumb_id = '51854' THEN '0.014946322416414'  WHEN thumb_id = '51860' THEN '0.018329249467957'  WHEN thumb_id = '51883' THEN '0.017346443056797'  WHEN thumb_id = '51897' THEN '0.019039506119932'  WHEN thumb_id = '51899' THEN '0.010425572003078'  WHEN thumb_id = '51934' THEN '0.01951893469926'  WHEN thumb_id = '51953' THEN '0.015294803241008'  WHEN thumb_id = '51978' THEN '0.020183606786839'  WHEN thumb_id = '52027' THEN '0.020588320845895'  WHEN thumb_id = '52054' THEN '0.016382719951711'  WHEN thumb_id = '52081' THEN '0.018650680933658'  WHEN thumb_id = '52103' THEN '0.027923991959386'  WHEN thumb_id = '52172' THEN '0.018445291866267'  WHEN thumb_id = '52175' THEN '0.019993727476908'  WHEN thumb_id = '52189' THEN '0.025088436574097'  WHEN thumb_id = '52191' THEN '0.010433798256471'  WHEN thumb_id = '52200' THEN '0.030442247070177'  WHEN thumb_id = '52243' THEN '0.013343148117977'  WHEN thumb_id = '52270' THEN '0.011767381302062'  WHEN thumb_id = '52271' THEN '0.015683543400254'  WHEN thumb_id = '52292' THEN '0.021077243651436'  WHEN thumb_id = '52364' THEN '0.0060787184888386'  WHEN thumb_id = '52497' THEN '0.035011357206142'  WHEN thumb_id = '52527' THEN '0.017650239539932'  WHEN thumb_id = '52537' THEN '0.015766420981678'  WHEN thumb_id = '52555' THEN '0.0030161985516101'  WHEN thumb_id = '52586' THEN '0.015901516185798'  WHEN thumb_id = '52639' THEN '0.021348531297533'  WHEN thumb_id = '52709' THEN '0.014304685819433'  WHEN thumb_id = '52711' THEN '0.013674235636783'  WHEN thumb_id = '52718' THEN '0.0039135455161901'  WHEN thumb_id = '52719' THEN '0.01600482151298'  WHEN thumb_id = '52721' THEN '0.013075724245611'  WHEN thumb_id = '52725' THEN '0.025413318985609'  WHEN thumb_id = '52735' THEN '0.018678942201926'  WHEN thumb_id = '52761' THEN '0.016143581567797'  WHEN thumb_id = '52764' THEN '0.0022513460080083'  WHEN thumb_id = '52767' THEN '0.014952750844194'  WHEN thumb_id = '52774' THEN '0.0036659612110612'  WHEN thumb_id = '52804' THEN '0.011795228574209'  WHEN thumb_id = '52860' THEN '0.01868591755031'  WHEN thumb_id = '52873' THEN '0.017441147463133'  WHEN thumb_id = '52884' THEN '0.019008310822762'  WHEN thumb_id = '52897' THEN '0.022051147801652'  WHEN thumb_id = '52898' THEN '0.015666114828095'  WHEN thumb_id = '52902' THEN '0.022379325863912'  WHEN thumb_id = '52925' THEN '0.020358646644085'  WHEN thumb_id = '52926' THEN '0.015117329497409'  WHEN thumb_id = '52929' THEN '0.02347655073375'  WHEN thumb_id = '52943' THEN '0.014872325159387'  WHEN thumb_id = '52977' THEN '0.016555132263503'  WHEN thumb_id = '53011' THEN '0.0074081512456085'  WHEN thumb_id = '53028' THEN '0.0098137282948871'  WHEN thumb_id = '53036' THEN '0.011628990650484'  WHEN thumb_id = '53039' THEN '0.011568183754075'  WHEN thumb_id = '53046' THEN '0.003873156586985'  WHEN thumb_id = '53062' THEN '0.019735450626192'  WHEN thumb_id = '53075' THEN '0.022060964880083'  WHEN thumb_id = '53076' THEN '0.01225511055355'  WHEN thumb_id = '53096' THEN '0.016907139287849'  WHEN thumb_id = '53111' THEN '0.021325361620814'  WHEN thumb_id = '53125' THEN '0.0095752656160658'  WHEN thumb_id = '53154' THEN '0.0066014041685026'  WHEN thumb_id = '53170' THEN '0.0021020488368827'  WHEN thumb_id = '53196' THEN '0.024980624815231'  WHEN thumb_id = '53200' THEN '0.016930336225991'  WHEN thumb_id = '53210' THEN '0.013990177811228'  WHEN thumb_id = '53219' THEN '0.016145310647767'  WHEN thumb_id = '53220' THEN '0.016083702196173'  WHEN thumb_id = '53240' THEN '0.016286517186991'  WHEN thumb_id = '53276' THEN '0.016084778088187'  WHEN thumb_id = '53284' THEN '0.01538835240099'  WHEN thumb_id = '53302' THEN '0.0051066581030535'  WHEN thumb_id = '53351' THEN '0.005293170168109'  WHEN thumb_id = '53355' THEN '0.017968576074161'  WHEN thumb_id = '53391' THEN '0.0063096122033224'  WHEN thumb_id = '53411' THEN '0.010628256353076'  WHEN thumb_id = '53418' THEN '0.0066096432739756'  WHEN thumb_id = '53424' THEN '0.017516937736409'  WHEN thumb_id = '53427' THEN '0.0029166320398174'  WHEN thumb_id = '53428' THEN '0.0055293153873535'  WHEN thumb_id = '53444' THEN '0.01558342068117'  WHEN thumb_id = '53484' THEN '0.019358028419264'  WHEN thumb_id = '53530' THEN '0.013879205341985'  WHEN thumb_id = '53545' THEN '0.020730841949238'  WHEN thumb_id = '53569' THEN '0.018003855607182'  WHEN thumb_id = '53591' THEN '0.0084720169890677'  WHEN thumb_id = '53593' THEN '0.011210249928658'  WHEN thumb_id = '53599' THEN '0.018884973104178'  WHEN thumb_id = '53601' THEN '0.0021654259712739'  WHEN thumb_id = '53617' THEN '0.0063380470480193'  WHEN thumb_id = '53628' THEN '0.01533202906468'  WHEN thumb_id = '53638' THEN '0.018679235204908'  WHEN thumb_id = '53639' THEN '0.006381988217285'  WHEN thumb_id = '53642' THEN '0.018268369586434'  WHEN thumb_id = '53700' THEN '0.018330267023963'  WHEN thumb_id = '53706' THEN '0.016055023191114'  WHEN thumb_id = '53707' THEN '0.015569343881719'  WHEN thumb_id = '53727' THEN '0.0092351264504523'  WHEN thumb_id = '53733' THEN '0.011524555322497'  WHEN thumb_id = '53752' THEN '0.016477658289632'  WHEN thumb_id = '53786' THEN '0.0065909462863476'  WHEN thumb_id = '53818' THEN '0.006230899190253'  WHEN thumb_id = '53827' THEN '0.0014080563398508'  WHEN thumb_id = '53830' THEN '0.0082155364170442'  WHEN thumb_id = '53840' THEN '0.018999171024272'  WHEN thumb_id = '53842' THEN '0.0035151426011587'  WHEN thumb_id = '53845' THEN '0.0095638812893645'  WHEN thumb_id = '53879' THEN '0.013453398159376'  WHEN thumb_id = '53887' THEN '0.0066212594439168'  WHEN thumb_id = '53888' THEN '0.0072565534910958'  WHEN thumb_id = '53908' THEN '0.016470751898504'  WHEN thumb_id = '53915' THEN '0.004950316511279'  WHEN thumb_id = '53982' THEN '0.0027818445718888'  WHEN thumb_id = '53988' THEN '0.012087395850484'  WHEN thumb_id = '54009' THEN '0.02030761572513'  WHEN thumb_id = '54016' THEN '0.023290146887055'  WHEN thumb_id = '54031' THEN '0.0014161696193069'  WHEN thumb_id = '54052' THEN '0.0058003957576221'  WHEN thumb_id = '54067' THEN '0.0015097385068739'  WHEN thumb_id = '54083' THEN '0.0049272273573318'  WHEN thumb_id = '54095' THEN '0.0205172386641'  WHEN thumb_id = '54125' THEN '0.019447233601226'  WHEN thumb_id = '54144' THEN '0.0028432689025387'  WHEN thumb_id = '54148' THEN '0.011137014376202'  WHEN thumb_id = '54200' THEN '0.003517961172648'  WHEN thumb_id = '54202' THEN '0.014200160663985'  WHEN thumb_id = '54212' THEN '0.0016968422946398'  WHEN thumb_id = '54238' THEN '0.0066054266112052'  WHEN thumb_id = '54258' THEN '0.0059317253888371'  WHEN thumb_id = '54284' THEN '0.014450436840693'  WHEN thumb_id = '54848' THEN '0.0026176135028081'  WHEN thumb_id = '54849' THEN '0.0086123446584075'  WHEN thumb_id = '54852' THEN '0.0029079632227213'  WHEN thumb_id = '54854' THEN '0.0049952120058913'  WHEN thumb_id = '54855' THEN '0.0039730697839346'  WHEN thumb_id = '54856' THEN '0.0030323708875386'  WHEN thumb_id = '54857' THEN '0.0019133486248032'  WHEN thumb_id = '54859' THEN '0.0017154234968075'  WHEN thumb_id = '54860' THEN '0.0041407553716932'  WHEN thumb_id = '54862' THEN '0.01011141647504'  WHEN thumb_id = '54863' THEN '0.0067872474320799'  WHEN thumb_id = '54864' THEN '0.010563853041313'  WHEN thumb_id = '54866' THEN '0.015439306184171'  WHEN thumb_id = '54867' THEN '0.012376317955611'  WHEN thumb_id = '54868' THEN '0.009699191017848'  WHEN thumb_id = '54869' THEN '0.018070622021528'  WHEN thumb_id = '54870' THEN '0.0040176873778422'  WHEN thumb_id = '54872' THEN '0.0031634464448066'  WHEN thumb_id = '54875' THEN '0.050984336199707'  WHEN thumb_id = '54876' THEN '0.0041094755588634'  WHEN thumb_id = '54877' THEN '0.0039042504943092'  WHEN thumb_id = '54882' THEN '0.0029507424012321'  WHEN thumb_id = '54884' THEN '0.0039490361372677'  WHEN thumb_id = '54885' THEN '0.0049998129314705'  WHEN thumb_id = '54886' THEN '0.010425574124745'  WHEN thumb_id = '54887' THEN '0.0052215357750946'  WHEN thumb_id = '54888' THEN '0.0067014247780263'  WHEN thumb_id = '54889' THEN '0.0050749144957825'  WHEN thumb_id = '54891' THEN '0.0039373639870061'  WHEN thumb_id = '54892' THEN '0.0047693706675511'  WHEN thumb_id = '54895' THEN '0.0036175348311983'  WHEN thumb_id = '54897' THEN '0.0059746382111746'  WHEN thumb_id = '54899' THEN '0.013874142847349'  WHEN thumb_id = '54900' THEN '0.0034823711961766'  WHEN thumb_id = '54901' THEN '0.013116582953819'  WHEN thumb_id = '54902' THEN '0.005031504183566'  WHEN thumb_id = '54903' THEN '0.0045132451340362'  WHEN thumb_id = '54904' THEN '0.0037033723600886'  WHEN thumb_id = '54905' THEN '0.011664320947763'  WHEN thumb_id = '54908' THEN '0.0064531700374419'  WHEN thumb_id = '54909' THEN '0.0048094067678901'  WHEN thumb_id = '54915' THEN '0.032943928117813'  WHEN thumb_id = '54916' THEN '0.0058594280592236'  WHEN thumb_id = '54917' THEN '0.0084485621948562'  WHEN thumb_id = '54918' THEN '0.0042745217164887'  WHEN thumb_id = '54921' THEN '0.022166916335301'  WHEN thumb_id = '54922' THEN '0.022453989021037'  WHEN thumb_id = '54923' THEN '0.0061226001388014'  WHEN thumb_id = '54925' THEN '0.0049989210149632'  WHEN thumb_id = '54926' THEN '0.0045932159170039'  WHEN thumb_id = '54927' THEN '0.010837188045164'  WHEN thumb_id = '54928' THEN '0.0062456329563794'  WHEN thumb_id = '54930' THEN '0.0039092648082465'  WHEN thumb_id = '54931' THEN '0.032083719158614'  WHEN thumb_id = '54932' THEN '0.0049941982021355'  WHEN thumb_id = '54934' THEN '0.0041298974984559'  WHEN thumb_id = '54935' THEN '0.0082134447485268'  WHEN thumb_id = '54937' THEN '0.0060314431529594'  WHEN thumb_id = '54938' THEN '0.0037838940268423'  WHEN thumb_id = '54939' THEN '0.0012319795245746'  WHEN thumb_id = '54940' THEN '0.012539576605631'  WHEN thumb_id = '54941' THEN '0.034306368220313'  WHEN thumb_id = '54942' THEN '0.0040154924921719'  WHEN thumb_id = '54943' THEN '0.0017605243132865'  WHEN thumb_id = '54944' THEN '0.0091742281234711'  WHEN thumb_id = '54945' THEN '0.041703231603714'  WHEN thumb_id = '54948' THEN '0.0053921192907862'  WHEN thumb_id = '54949' THEN '0.0060145824994191'  WHEN thumb_id = '54951' THEN '0.012141597058357'  WHEN thumb_id = '54954' THEN '0.0079182628048585'  WHEN thumb_id = '54955' THEN '0.0037485650952874'  WHEN thumb_id = '54956' THEN '0.033206586544844'  WHEN thumb_id = '54959' THEN '0.026859201576578'  WHEN thumb_id = '54960' THEN '0.016407045337648'  WHEN thumb_id = '54961' THEN '0.0052806941787345'  WHEN thumb_id = '54962' THEN '0.041168685975422'  WHEN thumb_id = '54963' THEN '0.0043229984387308'  WHEN thumb_id = '54965' THEN '0.0086298881729727'  WHEN thumb_id = '54966' THEN '0.0058553942763773'  WHEN thumb_id = '54967' THEN '0.0021947781555169'  WHEN thumb_id = '54968' THEN '0.0077557513257977'  WHEN thumb_id = '54972' THEN '0.0037824207602615'  WHEN thumb_id = '54973' THEN '0.0071198863956311'  WHEN thumb_id = '54974' THEN '0.0052633454382178'  WHEN thumb_id = '54975' THEN '0.009032733225929'  WHEN thumb_id = '54976' THEN '0.01714778693748'  WHEN thumb_id = '54977' THEN '0.0054400050135579'  WHEN thumb_id = '54979' THEN '0.0056684676032729'  WHEN thumb_id = '54980' THEN '0.045840468605655'  WHEN thumb_id = '54981' THEN '0.071712955224839'  WHEN thumb_id = '54983' THEN '0.015783184341408'  WHEN thumb_id = '54984' THEN '0.0024035648925851'  WHEN thumb_id = '54985' THEN '0.009269724123321'  WHEN thumb_id = '54986' THEN '0.0072400321696776'  WHEN thumb_id = '54988' THEN '0.0035106051729336'  WHEN thumb_id = '54989' THEN '0.0082547981919271'  WHEN thumb_id = '54990' THEN '0.0014649456130538'  WHEN thumb_id = '54991' THEN '0.020220009790209'  WHEN thumb_id = '54992' THEN '0.0059253298543175'  WHEN thumb_id = '54993' THEN '0.0061499625393729'  WHEN thumb_id = '54994' THEN '0.017580550184889'  WHEN thumb_id = '54997' THEN '0.0047898670886168'  WHEN thumb_id = '54999' THEN '0.0017626142864718'  WHEN thumb_id = '55000' THEN '0.0042485723277466'  WHEN thumb_id = '55002' THEN '0.0029908564884827'  WHEN thumb_id = '55004' THEN '0.0040695251642922'  WHEN thumb_id = '55005' THEN '0.0076714483067906'  WHEN thumb_id = '55006' THEN '0.0069430371196507'  WHEN thumb_id = '55007' THEN '0.0058211428096978'  WHEN thumb_id = '55009' THEN '0.0039061885171664'  WHEN thumb_id = '55010' THEN '0.027183282363287'  WHEN thumb_id = '55011' THEN '0.0032362929489468'  WHEN thumb_id = '55013' THEN '0.0051760024068783'  WHEN thumb_id = '55017' THEN '0.0039429357668383'  WHEN thumb_id = '55018' THEN '0.013525672165022'  WHEN thumb_id = '55019' THEN '0.0069481451754786'  WHEN thumb_id = '55021' THEN '0.0026743436033254'  WHEN thumb_id = '55128' THEN '0.0036816858020327'  WHEN thumb_id = '58466' THEN '0.026294942194355'  WHEN thumb_id = '58484' THEN '0.024058448564135'  WHEN thumb_id = '58560' THEN '0.033050226346106'  WHEN thumb_id = '58570' THEN '0.023897880099168'  WHEN thumb_id = '58602' THEN '0.020481358629366'  WHEN thumb_id = '58630' THEN '0.028460676849952'  WHEN thumb_id = '58814' THEN '0.027480819406858'  WHEN thumb_id = '58852' THEN '0.028944274495267'  WHEN thumb_id = '58864' THEN '0.021898116050794'  WHEN thumb_id = '59318' THEN '0.019443615375341'  WHEN thumb_id = '59373' THEN '0.0099698589401295'  WHEN thumb_id = '59486' THEN '0.010724006297271'  WHEN thumb_id = '59514' THEN '0.01837585308818'  WHEN thumb_id = '59580' THEN '0.01431133086631'  WHEN thumb_id = '59686' THEN '0.023431495691283'  WHEN thumb_id = '59877' THEN '0.020456468769283'  WHEN thumb_id = '59925' THEN '0.021059231878713'  WHEN thumb_id = '59986' THEN '0.030988333014724'  WHEN thumb_id = '60841' THEN '0.028078844007375'  WHEN thumb_id = '61010' THEN '0.01455594375304'  WHEN thumb_id = '61119' THEN '0.016798437112286'  WHEN thumb_id = '61187' THEN '0.023877589418354'  WHEN thumb_id = '61214' THEN '0.017338068326439'  WHEN thumb_id = '61455' THEN '0.029213970709685'  WHEN thumb_id = '61649' THEN '0.011583449913649'  WHEN thumb_id = '62128' THEN '0.020117737145229'  WHEN thumb_id = '62359' THEN '0.021755175321316'  WHEN thumb_id = '62392' THEN '0.02024669791212'  WHEN thumb_id = '62494' THEN '0.015121848142672'  WHEN thumb_id = '62662' THEN '0.01717411586715'  WHEN thumb_id = '62690' THEN '0.018846246119062'  WHEN thumb_id = '62711' THEN '0.019990574273384'  WHEN thumb_id = '62792' THEN '0.019697707233311'  WHEN thumb_id = '63080' THEN '0.018707998425958'  WHEN thumb_id = '63103' THEN '0.021929745297091'  WHEN thumb_id = '63173' THEN '0.013404021476492'  WHEN thumb_id = '63480' THEN '0.024486356149981'  WHEN thumb_id = '63522' THEN '0.026803256280145'  WHEN thumb_id = '64138' THEN '0.018094290702716'  WHEN thumb_id = '64586' THEN '0.017568832029238'  WHEN thumb_id = '64720' THEN '0.019609359885581'  WHEN thumb_id = '64752' THEN '0.018509266463852'  WHEN thumb_id = '65203' THEN '0.02628998399527'  WHEN thumb_id = '65262' THEN '0.020060240033563'  WHEN thumb_id = '65925' THEN '0.018538837631231'  WHEN thumb_id = '67109' THEN '0.03436426453906'  WHEN thumb_id = '67138' THEN '0.011405546577736'  WHEN thumb_id = '67463' THEN '0.021486751400779'  WHEN thumb_id = '67891' THEN '0.021593294051707'  WHEN thumb_id = '68520' THEN '0.018470547445222'  WHEN thumb_id = '68568' THEN '0.018876154461687'  WHEN thumb_id = '68857' THEN '0.018828800862189'  WHEN thumb_id = '69219' THEN '0.018068790757836'  WHEN thumb_id = '69287' THEN '0.021537146637427'  WHEN thumb_id = '69347' THEN '0.012561877359262'  WHEN thumb_id = '69384' THEN '0.020418485298261'  WHEN thumb_id = '69412' THEN '0.019142032167338'  WHEN thumb_id = '69479' THEN '0.0124118481742'  WHEN thumb_id = '69609' THEN '0.032139029936187'  WHEN thumb_id = '70549' THEN '0.019046690078787'  WHEN thumb_id = '70715' THEN '0.024417176378792'  WHEN thumb_id = '70919' THEN '0.019174365377589'  WHEN thumb_id = '71655' THEN '0.010502442953201'  WHEN thumb_id = '71810' THEN '0.047292319197542'  WHEN thumb_id = '71834' THEN '0.0029228189604417'  WHEN thumb_id = '72030' THEN '0.018551982506622'  WHEN thumb_id = '72124' THEN '0.012393419366444'  WHEN thumb_id = '72147' THEN '0.015079164138003'  WHEN thumb_id = '72664' THEN '0.020322138786952'  WHEN thumb_id = '72804' THEN '0.018764190526152'  WHEN thumb_id = '74124' THEN '0.020155616054564'  WHEN thumb_id = '74259' THEN '0.0202054707886'  WHEN thumb_id = '74280' THEN '0.017884798457067'  WHEN thumb_id = '74290' THEN '0.020838293578603'  WHEN thumb_id = '74292' THEN '0.028782901466553'  WHEN thumb_id = '74304' THEN '0.015310967301973'  WHEN thumb_id = '74308' THEN '0.010762038796351'  WHEN thumb_id = '74316' THEN '0.013785387349124'  WHEN thumb_id = '74320' THEN '0.018532589039629'  WHEN thumb_id = '74331' THEN '0.013030913379167'  WHEN thumb_id = '74352' THEN '0.023728821883995'  WHEN thumb_id = '74371' THEN '0.0073650027932575'  WHEN thumb_id = '74386' THEN '0.018120176089396'  WHEN thumb_id = '74395' THEN '0.011234053952942'  WHEN thumb_id = '74427' THEN '0.016244504758317'  WHEN thumb_id = '74435' THEN '0.032255779194166'  WHEN thumb_id = '74469' THEN '0.021715793492853'  WHEN thumb_id = '74473' THEN '0.019749684128625'  WHEN thumb_id = '74478' THEN '0.019902836644199'  WHEN thumb_id = '74479' THEN '0.019004040097369'  WHEN thumb_id = '74481' THEN '0.019615461069903'  WHEN thumb_id = '74485' THEN '0.02006770518871'  WHEN thumb_id = '74503' THEN '0.021117570775091'  WHEN thumb_id = '74519' THEN '0.018472935885839'  WHEN thumb_id = '74526' THEN '0.017067839869536'  WHEN thumb_id = '74538' THEN '0.02206523349195'  WHEN thumb_id = '74557' THEN '0.015830101194618'  WHEN thumb_id = '74561' THEN '0.024741140308451'  WHEN thumb_id = '74563' THEN '0.019868726873813'  WHEN thumb_id = '74565' THEN '0.011239094989684'  WHEN thumb_id = '74574' THEN '0.020768907039699'  WHEN thumb_id = '74578' THEN '0.018907756831412'  WHEN thumb_id = '74598' THEN '0.030718391963028'  WHEN thumb_id = '74614' THEN '0.018367324094642'  WHEN thumb_id = '74638' THEN '0.027232871924976'  WHEN thumb_id = '74643' THEN '0.022666871559361'  WHEN thumb_id = '74658' THEN '0.010796515893987'  WHEN thumb_id = '74662' THEN '0.013193248378919'  WHEN thumb_id = '74686' THEN '0.013072087763205'  WHEN thumb_id = '74717' THEN '0.014796851045128'  WHEN thumb_id = '74722' THEN '0.024135330473793'  WHEN thumb_id = '74726' THEN '0.013008270293027'  WHEN thumb_id = '74727' THEN '0.027572701147892'  WHEN thumb_id = '74741' THEN '0.015229946683919'  WHEN thumb_id = '74744' THEN '0.013065164200067'  WHEN thumb_id = '74754' THEN '0.014881468553674'  WHEN thumb_id = '74756' THEN '0.020907657555814'  WHEN thumb_id = '74759' THEN '0.018379377492722'  WHEN thumb_id = '74786' THEN '0.017498147174255'  WHEN thumb_id = '74801' THEN '0.014344884077378'  WHEN thumb_id = '74807' THEN '0.016698737416427'  WHEN thumb_id = '74818' THEN '0.020597977417706'  WHEN thumb_id = '74870' THEN '0.026466975122206'  WHEN thumb_id = '74903' THEN '0.009960067288161'  WHEN thumb_id = '74908' THEN '0.016974093673337'  WHEN thumb_id = '74922' THEN '0.019359053238257'  WHEN thumb_id = '74923' THEN '0.01600635535498'  WHEN thumb_id = '74974' THEN '0.030701801766721'  WHEN thumb_id = '74980' THEN '0.012149374182047'  WHEN thumb_id = '74986' THEN '0.030669491633396'  WHEN thumb_id = '74989' THEN '0.01890380393865'  WHEN thumb_id = '74993' THEN '0.034801064970682'  WHEN thumb_id = '74996' THEN '0.022088769222247'  WHEN thumb_id = '74998' THEN '0.023034773789426'  WHEN thumb_id = '74999' THEN '0.019502482207891'  WHEN thumb_id = '75000' THEN '0.020357444150081'  WHEN thumb_id = '75001' THEN '0.014239770879495'  WHEN thumb_id = '75004' THEN '0.018755248842688'  WHEN thumb_id = '75005' THEN '0.0083850858170675'  WHEN thumb_id = '75009' THEN '0.017435468437021'  WHEN thumb_id = '75010' THEN '0.013067819361831'  WHEN thumb_id = '75012' THEN '0.02058791480553'  WHEN thumb_id = '75015' THEN '0.024482787627149'  WHEN thumb_id = '75016' THEN '0.014171172486578'  WHEN thumb_id = '75019' THEN '0.018127117667821'  WHEN thumb_id = '75020' THEN '0.017166153180847'  WHEN thumb_id = '75023' THEN '0.017704417053776'  WHEN thumb_id = '75028' THEN '0.011380332592533'  WHEN thumb_id = '75030' THEN '0.0090587976382585'  WHEN thumb_id = '75033' THEN '0.019012154961254'  WHEN thumb_id = '75034' THEN '0.011585463411196'  WHEN thumb_id = '75035' THEN '0.015602146640704'  WHEN thumb_id = '75036' THEN '0.021151543094287'  WHEN thumb_id = '75037' THEN '0.019677620850603'  WHEN thumb_id = '75039' THEN '0.01106024812395'  WHEN thumb_id = '75041' THEN '0.019693271088882'  WHEN thumb_id = '75043' THEN '0.01836366678366'  WHEN thumb_id = '75046' THEN '0.027251085946984'  WHEN thumb_id = '75047' THEN '0.020121602701526'  WHEN thumb_id = '75051' THEN '0.010714603486799'  WHEN thumb_id = '75052' THEN '0.019533932164155'  WHEN thumb_id = '75054' THEN '0.016443965357362'  WHEN thumb_id = '75056' THEN '0.060576792148207'  WHEN thumb_id = '75058' THEN '0.021932714332317'  WHEN thumb_id = '75059' THEN '0.013441123738048'  WHEN thumb_id = '75061' THEN '0.012327936662351'  WHEN thumb_id = '75062' THEN '0.054808434084651'  WHEN thumb_id = '75065' THEN '0.019057517052306'  WHEN thumb_id = '75068' THEN '0.032129823047773'  WHEN thumb_id = '75071' THEN '0.023873042456305'  WHEN thumb_id = '75081' THEN '0.02186907529154'  WHEN thumb_id = '75083' THEN '0.023404507637893'  WHEN thumb_id = '75084' THEN '0.021613435770899'  WHEN thumb_id = '75085' THEN '0.021105898039125'  WHEN thumb_id = '75091' THEN '0.020208939243462'  WHEN thumb_id = '75092' THEN '0.015668002306468'  WHEN thumb_id = '75102' THEN '0.020432674215026'  WHEN thumb_id = '75105' THEN '0.0082832726724908'  WHEN thumb_id = '75107' THEN '0.0071074397910287'  WHEN thumb_id = '251173' THEN '0.03496844437436'  WHEN thumb_id = '251174' THEN '0.010685308926814'  WHEN thumb_id = '251176' THEN '0.0093385621603425'  WHEN thumb_id = '251197' THEN '0.0057824158237244'  WHEN thumb_id = '251198' THEN '0.0025976717627797'  WHEN thumb_id = '251199' THEN '0.050536750802216'  WHEN thumb_id = '251200' THEN '0.010918742722889'  WHEN thumb_id = '251201' THEN '0.0020905168800411'  WHEN thumb_id = '251202' THEN '0.021255460227857'  WHEN thumb_id = '251203' THEN '0.0047796020694763'  WHEN thumb_id = '251204' THEN '0.024847335260655'  WHEN thumb_id = '251205' THEN '0.041517432137407'  WHEN thumb_id = '251206' THEN '0.018120893182409'  WHEN thumb_id = '251208' THEN '0.017449770393394'  WHEN thumb_id = '251209' THEN '0.005829590324661'  WHEN thumb_id = '251210' THEN '0.0082773663581388'  WHEN thumb_id = '251211' THEN '0.02882307733249'  WHEN thumb_id = '251212' THEN '0.010269089979187'  WHEN thumb_id = '251236' THEN '0.037707520728093'  WHEN thumb_id = '251240' THEN '0.21260582067483'  WHEN thumb_id = '251242' THEN '0.011734055758686'  WHEN thumb_id = '251243' THEN '0.034696849810115'  WHEN thumb_id = '251245' THEN '0.045969276801688'  WHEN thumb_id = '251246' THEN '0.026434025569816'  WHEN thumb_id = '251247' THEN '0.0048318652970437'  WHEN thumb_id = '251248' THEN '0.019645077189057'  END WHERE thumb_id IN ('194806','77033','78506','107893','233840','28739','84966','54940','54944','98098','30597','250919','120546','233060','90383','211684','89411','229716','221816','106623','54985','26376','98991','243197','54945','110605','86789','54960','113066','54965','207703','26751','89537','97997','236642','54931','220035','90931','174087','113326','35795','198583','120379','77199','87764','91091','85792','194083','64720','75761','207181','77888','207121','242952','185354','58814','2170','201182','89578','190257','28702','234509','25031','35436','185167','227368','41357','89628','31327','187728','183723','189023','32718','89209','241660','40455','189533','54867','229525','54886','83714','246466','108854','54875','87640','54941','39036','246230','108519','228535','55010','204340','38092','121270','193058','221600','185238','54981','106049','105698','247805','88402','54922','48614','205683','113081','184348','37598','54986','75527','105685','90136','250339','67109','187756','87189','245557','230521','54905','187168','246074','89241','186230','248765','115934','54860','55007','251130','1812','172859','213057','54863','111974','75452','90403','77289','87719','109116','209691','127289','80801','88388','210051','207252','245024','26583','246760','248740','246875','186954','26728','226760','116400','194851','87338','91165','205230','214486','90556','40831','183780','54980','115936','54915','251060','54935','27430','234023','245880','90392','48180','78809','48088','238979','199449','249857','90305','128200','86699','78089','241356','35074','105654','54852','35208','99193','80328','105623','89334','139142','125656','184390','54974','88226','54959','106612','105644','45381','25227','209321','111076','199061','79427','77927','111144','113314','242713','31329','78032','112801','75251','54943','236501','244420','158033','54901','55018','200710','190933','201274','251057','41191','32694','218637','120227','250388','202189','89857','89125','217007','89110','195126','77260','250923','88349','83729','85397','146456','90255','75034','37943','37558','54983','246768','35451','84727','24600','88940','46182','98721','250879','81424','83348','26747','54869','83259','84834','78883','54976','110364','105788','90471','90417','204705','77368','189391','195960','185324','250680','76373','45208','88284','59986','54862','34910','106512','79097','235933','76503','81073','111259','54993','82233','90524','85300','39256','251134','185696','183244','238483','180108','184630','184299','237444','231721','228605','198781','228074','209651','185900','228661','229723','112676','209441','236535','211424','204825','81120','81159','81525','81554','81563','81571','81578','81596','81643','81679','81743','81751','81777','81803','81843','82404','82418','82524','82553','82667','82669','82732','82737','82762','82822','82865','82909','83102','83156','83313','83317','83357','83382','83696','83760','83791','83821','83834','83844','83856','83866','83869','83870','83876','83891','83892','83909','83919','84049','84074','40177','228133','25560','27470','29470','83793','229307','45163','111260','41139','83312','25552','88814','34914','84468','84205','27336','29467','76478','90088','244328','237435','106199','190685','39966','34326','230923','37427','29811','118302','41554','228409','228577','105680','110102','178808','105950','107686','41314','106036','106156','106065','106189','105983','106194','107554','106177','105904','107592','106016','106066','54962','54956','54921','54991','54866','54994','54899','54864','54951','54927','54968','54849','54989','54868','54975','55005','54937','54977','54897','54973','54917','54948','54928','54916','54888','55019','55006','55013','54854','54908','54949','54992','54892','54954','54889','54923','54963','54877','54966','54900','54885','54932','54938','54884','54925','55017','54934','54988','54887','54891','54904','54909','54972','54979','54876','54961','54930','55011','55004','54855','54918','54870','54926','54895','55021','54903','54882','54942','54939','54997','54902','55000','54872','55128','55002','54856','54857','55009','54967','54955','54990','54848','54984','54859','54999','243893','247907','215923','232649','179078','189833','237396','237394','215386','219128','239064','242651','212337','237438','246630','235013','238182','244910','214299','85193','75056','85607','210418','85154','75431','240765','34831','184024','75296','75071','84973','85155','35949','75215','84983','75036','249890','27251','27647','29865','41179','84644','39624','24851','33803','24846','26788','36125','32159','27153','111077','36687','87469','24849','39637','41700','24844','24841','194731','87308','86897','240322','87403','35751','200525','81588','37738','39205','111688','25969','174465','120345','29872','89072','41694','157930','41181','89242','30405','27101','250901','39564','109334','205053','39563','240230','89320','29699','34324','177724','27098','24976','110024','37759','27118','243673','190321','74922','184122','31474','177820','38083','89329','235281','89203','248192','31482','34888','25970','87635','36639','32300','202251','202720','26970','109464','34322','82323','227267','234204','46064','50498','1677','25951','75335','87615','37586','198073','191705','85983','198637','186456','193676','251199','50858','36290','244522','40473','58560','28598','86904','86300','24127','87746','117846','207708','84337','40829','54016','239379','116098','53196','40482','30221','110002','213197','241599','211976','29435','84444','82817','223727','87576','53545','75107','78791','236300','208919','88959','85442','196800','87611','115946','78962','83541','242668','186684','77401','209807','80916','75102','87729','68857','84089','239266','215562','87660','87390','83766','28551','88800','227360','248063','235020','76770','201200','37213','84996','83926','203833','207428','87487','87399','214369','245602','53628','98385','100157','87144','53707','87043','97176','234999','28704','79345','238866','88002','203760','87450','87518','35254','78154','79936','186720','99420','89305','87365','247752','172808','172996','166402','166729','169287','168866','161518','166456','169367','166433','171981','191567','166102','166390','166728','173194','166756','166068','170877','165370','76419','19525,'218541','226334','232497','196676','53706','76345','83674','218545','53096','233745','226268','83888','75402','235928','79303','84879','79425','112651','215554','79212','83914','89477','52721','206873','51953','53569','49750','24268','87510','210674','79127','41317','90529','54095','243699','89694','184054','247067','85968','78974','79223','178277','194521','213236','81582','33788','98354','120257','99345','81904','98017','176925','96961','36349','96904','82173','99241','82124','98315','33801','62359','53284','45398','48135','98510','99470','97591','97198','98971','96142','98852','96717','98244','98720','99107','53617','95926','98207') :: <= /........./scj/bin/rotation.php (db_query) (time: 30.159228086472) <= /........./scj/bin/rotation.php (bayes_ctr) (time: 30.159228086472) <= /........./scj/bin/rotation.php (process_clicks) (time: 30.159228086472)

сократил его как мог, сам запрос 40кб....

[admin]

тогда оч странно почему не обрезает лог, я б проверил

как именно предлагается сократить данный запрос?

[hrulik]

Как проверить?
вот такие письма еще приходят со слейвов, не знаю связано или нет:

Code: Select all

Mysql error 1205: Lock wait timeout exceeded; try restarting transaction (UPDATE LOW_PRIORITY rot_gallery_info SET gallery_total_shows = CASE WHEN gallery_id = '113742' THEN gallery_total_shows + 1 WHEN gallery_id = '128605' THEN gallery_total_shows + 3 WHEN gallery_id = '27040' THEN gallery_total_shows + 1 WHEN gallery_id = '36298' THEN gallery_total_shows + 2 WHEN gallery_id = '61396' THEN gallery_total_shows + 1 WHEN gallery_id = '40842' THEN gallery_total_shows + 3 WHEN gallery_id = '30545' THEN gallery_total_shows + 2 WHEN gallery_id = '96934' THEN gallery_total_shows + 2 WHEN gallery_id = '130617' THEN gallery_total_shows + 12 WHEN gallery_id = '58877' THEN gallery_total_shows + 3 WHEN gallery_id = '38063' THEN gallery_total_shows + 3 WHEN gallery_id = '103497' THEN gallery_total_shows + 2 WHEN gallery_id = '64025' THEN gallery_total_shows + 5 WHEN gallery_id = '35487' THEN gallery_total_shows + 1 WHEN gallery_id = '61279' THEN gallery_total_shows + 1 END WHERE gallery_id IN ('
 113742','128605','27040','36298','61396','40842','30545','96934','130617','58877','38063','103497','64025','35487','61279')  )

[admin]

в cron.log должно быть Rotate logs записли раз в сутки

это скорее всего нагружен винт