Site down due to plugin
-
Hello, our page stopped responding at some point, restarting the server helped for a few minutes, but the source of the problem was looped database queries from the plugin:
| 419 | site_name | localhost | site_name | Query | 310 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 421 | site_name | localhost | site_name | Query | 306 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 422 | site_name | localhost | site_name | Query | 308 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 426 | site_name | localhost | site_name | Query | 304 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 427 | site_name | localhost | site_name | Query | 302 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 428 | site_name | localhost | site_name | Query | 301 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 431 | site_name | localhost | site_name | Query | 302 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 435 | site_name | localhost | site_name | Query | 299 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 442 | site_name | localhost | site_name | Query | 300 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 445 | site_name | localhost | site_name | Query | 292 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 448 | site_name | localhost | site_name | Query | 299 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 452 | site_name | localhost | site_name | Query | 296 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 472 | site_name | localhost | site_name | Query | 291 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 477 | site_name | localhost | site_name | Query | 291 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 482 | site_name | localhost | site_name | Query | 289 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 487 | site_name | localhost | site_name | Query | 284 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 488 | site_name | localhost | site_name | Query | 289 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 489 | site_name | localhost | site_name | Query | 283 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 492 | site_name | localhost | site_name | Query | 290 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 493 | site_name | localhost | site_name | Query | 289 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 508 | site_name | localhost | site_name | Query | 285 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 513 | site_name | localhost | site_name | Query | 283 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 515 | site_name | localhost | site_name | Query | 283 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 516 | site_name | localhost | site_name | Query | 282 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 519 | site_name | localhost | site_name | Query | 281 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 540 | site_name | localhost | site_name | Query | 280 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 546 | site_name | localhost | site_name | Query | 276 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 549 | site_name | localhost | site_name | Query | 277 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 562 | site_name | localhost | site_name | Query | 277 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 563 | site_name | localhost | site_name | Query | 276 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 568 | site_name | localhost | site_name | Query | 274 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 574 | site_name | localhost | site_name | Query | 270 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 575 | site_name | localhost | site_name | Query | 275 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 576 | site_name | localhost | site_name | Query | 275 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 578 | site_name | localhost | site_name | Query | 275 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 579 | site_name | localhost | site_name | Query | 275 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 580 | site_name | localhost | site_name | Query | 274 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 582 | site_name | localhost | site_name | Query | 271 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 586 | site_name | localhost | site_name | Query | 270 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 587 | site_name | localhost | site_name | Query | 270 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 594 | site_name | localhost | site_name | Query | 268 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 603 | site_name | localhost | site_name | Query | 265 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 618 | site_name | localhost | site_name | Query | 261 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 619 | site_name | localhost | site_name | Query | 260 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 625 | site_name | localhost | site_name | Query | 259 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 632 | site_name | localhost | site_name | Query | 255 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 633 | site_name | localhost | site_name | Query | 255 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 635 | site_name | localhost | site_name | Query | 255 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 641 | site_name | localhost | site_name | Query | 250 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 | | 642 | site_name | localhost | site_name | Query | 247 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term | 0.000 |
Sample query content:
SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, MAX(term_relationships.term_taxonomy_id) as term_count_id FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_relationships AS tt1 ON (wp_posts.ID = tt1.object_id) INNER JOIN wp_term_relationships AS term_relationships ON wp_posts.ID = term_relationships.object_id LEFT JOIN (SELECT wp_braapf_product_variation_attributes.parent_id as ID, wp_term_taxonomy.term_taxonomy_id as term_id, MIN(out_of_stock_var.out_of_stock) AS out_of_stock FROM wp_braapf_product_variation_attributes LEFT JOIN ( SELECT filtered_post.post_id as var_id, filtered_post.parent_id as ID, COUNT(filtered_post.post_id) as meta_count, max(filtered_post.stock_status) as stock_status, max_filtered_post.max_meta_count, IF(max_filtered_post.max_meta_count != COUNT(filtered_post.post_id) OR max(filtered_post.stock_status) = 0, 1, 0) as out_of_stock FROM wp_braapf_product_variation_attributes as filtered_post INNER JOIN ( SELECT post_id as ID, COUNT(post_id) as max_meta_count FROM wp_braapf_variable_attributes WHERE attribute IN ('pa_rozmiar') GROUP BY post_id ) as max_filtered_post ON max_filtered_post.ID = filtered_post.parent_id WHERE filtered_post.meta_value_id IN (0,125,264,273,207,90,147,91,202,92,93,94,95,96,97,141,142,210,146,124,215,282,245,251,292,239,177,266,204,242,271,236,163,198,167,287,179,165,203,181,237,174,205,178,286,183,229,161,244,194,280,201,102,101,246,184,267,182,265,213,278,220,199,176,162,263,260,180,208,284,197,268,100,232,209,214,103,99,98,175,269,150,247,185) GROUP BY var_id ) AS out_of_stock_var ON wp_braapf_product_variation_attributes.post_id = out_of_stock_var.var_id INNER JOIN wp_term_taxonomy on wp_braapf_product_variation_attributes.meta_value_id = wp_term_taxonomy.term_id WHERE wp_braapf_product_variation_attributes.meta_value_id IN (0,125,264,273,207,90,147,91,202,92,93,94,95,96,97,141,142,210,146,124,215,282,245,251,292,239,177,266,204,242,271,236,163,198,167,287,179,165,203,181,237,174,205,178,286,183,229,161,244,194,280,201,102,101,246,184,267,182,265,213,278,220,199,176,162,263,260,180,208,284,197,268,100,232,209,214,103,99,98,175,269,150,247,185) GROUP BY ID, term_id HAVING out_of_stock = 1) as out_of_stock_variable on wp_posts.ID = out_of_stock_variable.ID AND term_relationships.term_taxonomy_id = out_of_stock_variable.term_id WHERE wp_posts.post_type IN ( 'product' ) AND wp_posts.post_status = 'publish' AND ( wp_term_relationships.term_taxonomy_id IN (33,51,58) AND wp_posts.ID NOT IN ( SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id IN (7,9) ) AND tt1.term_taxonomy_id IN (93) ) AND wp_posts.ID NOT IN ("13761","13775","13788","13803","13830","13862","13873","13890","13907","13922","13948","13972","13979","13990","13999","14008","14019","14034","14051","14090","14103","14118","14143","14152","14190","14203","14212","14227","14249","14334","14345","14360","14373","14398","14417","14453","14475","14486","14497","14510","14532","14549","14562","14582","14608","14625","14634","14647","14656","14669","14716","14727","14736","14783","14796","14829","14844","14876","14885","14901","14912","14923","14934","14945","14956","14963","14978","15004","15015","15032","15051","15075","15086","15099","15110","15119","15130","15143","15156","15171","15197","15214","15246","15264","15277","15288","15318","15348","15377","15394","15407","15427","15438","15453","15487","15507","15522","15546","15553","15564","15577","15601","15614","15623","15634","15649","15660","15682","15691","15706","15719","15732","15743","15760","15783","15794","15807","15820","15837","15842","15855","15890","15930","15945","15970","15986","16003","16025","16034","16045","16056","16067","16097","16110","16127","16153","16166","16190","16205","16220","16233","16248","16277","16325","16336","16360","16380","16399","16438","16461","16470","16483","16494","16507","16524","16539","16571","16586","16597","16610","16619","16634","16662","16675","16700","16711","16724","16737","16754","16780","16795","16812","16825","16838","16845","16856","16882","16891","16902","16913","16936","16945","16956","16969","16982","16993","17017","17032","17043","17067","17076","17083","17128","17152","17227","17236","17249","17270","17285","17300","17319","17332","17343","17356","17373","17386","17401","17431","17440","17451","17468","17481","17490","17505","17553","17566","17581","17594","17611","17633","17652","17702","17715","17722","17804","17817","17828","17841","17854","17865","17882","17891","17912","17927","17940","17962","17998","18011","18031","18044","18059","18076","18093","18108","18147","18177","18190","18203","18216","18231","18244","18259","18291","18306","18323","18340","18353","18372","18383","18405","18422","18433","18455","18478","18502","18544","18574","18600","18624","18639","18658","18675","18690","18701","18718","18731","18746","18787","18809","18818","18833","18842","18952","18963","18974","18987","18998","19011","19024","19039","19056","19073","19088","19105","19122","19137","19176","19187","19208","19231","19253","19278","19299","19318","19341","19350","19359","19404","19417","19438","19451","19462","19480","19493","19504","19517","19528","19552","19567","19582","19597","19627","19638","19657","19676","19689","19710","19721","19738","19766","19783","19798","19811","19824","19837","19859","19909","19922","19944","19968","19983","20004","20030","20052","20074","20098","20115","20130","20145","20160","20173","20186","20199","20214","20227","20238","20257","20274","20285","20296","20307","20316","20327","20338","20351","20364","20371","20386","20397","20408","20421","20436","20449","20462","20473","20484","20495","20512","20527","20561","20578","20606","20617","20638","20671","20690","20705","20720","20741","20763","20776","20791","20802","20818","20829","20844","20859","20876","20891","20902","20915","20934","20949","21003","21014","21029","21068","21079","21096","21113","21130","21147","21175","21201","21223","21238","21253","21268","21281","21300","21317","21332","21359","21398","21411","21424","21444","21513","21524","21535","21542","21562","21584","21601","21614","21625","21640","21659","21674","21687","21703","21712","21725","21751","21760","21775","21872","21889","21904","21921","21934","21949","21970","21987","22004","22017","22030","22041","22062","22079","22141","22169","22186","22199","22212","22223","22232","22243","22256","22271","22282","22295","22308","22319","22334","22349","22365","22378","22389","22400","22411","22422","22437","22485","22496","22509","22522","22537","22552","22613","22626","22637","22652","22665","22676","22687","22698","22709","22726","22739","22756","22765","22793","22804","22817","22828","22839","22850","22863","22876","22891","22905","22918","22929","22938","22953","22966","22979","22998","23009","23024","23035","23044","23057","23072","23089","23098","23109","23122","23135","23144","23157","23168","23179","23192","23203","23218","23231","23248","23272","23287","23304","23317","23335","23352","23363","23380","23393","23402","23419","23430","23441","23454","23463","23595","23610","23629","23648","23667","23716","23729","23740","23759","23772","23787","23800","23811","23832","23841","23856","23869","23884","23899","23912","23931","23946","23959","23970","23981","23996","24009","24035","24078","24104","24115","24130","24152","24194","24205","24222","24233","24244","24257","24274","24289","24311","24324","24339","24462","24475","24497","24534","24573","24580","24593","24617","24626","24637","24654","24663","24670","24692","24743","24756","24767","24776","24787","24813","24838","24849","24860","24869","24893","24908","24917","24945","24958","24976","24998","25024","25039","25052","25063","25085","25106","25143","25158","25206","25215","25369","25380","25414","25463","25480","25493","25508","25542","25557","25578","25595","25608","25621","25640","25657","25674","25690","25707","25728","25743","25760","25771","25784","25805","25835","25846","25865","25876","25897","25910","25929","25957","25974","26021","26036","26053","26068","26083","26100","26113","26126","26141","26162","26183","26230","26251","26273","26288","26310","26323","26346","26359","26376","26391","26406","26440","26449","26468","26483","26502","26523","26540","26547","26558","26575","26594","26657","26680","26699","26712","26723","26742","26757","26774","26783","26794","26803","26816","26829","26841","26854","26865","26878","26887","26900","26913","26926","26943","26956","26967","26980","26993","27012","27023","27039","27054","27071","27084","27095","27128","27141","27160","27173","27188","27214","27229","27246","27263","27282","27295","27306","27319","27330","27351","27370","27383","27396","27411","27422","27433","27442","27455","27477","27490","27503","27518","27533","27548","27559","27574","27585","27594","27605","27625","27636","27649","27668","27681","27694","27705","27728","27741","27763","27774","27785","27800","27822","27837","27850","27859","27895","27906","27917","27928","27939","27952","28014","28025","28038","28047","28058","28071","28082","28097","28110","28121","28134","28145","28162","28173","28180","28181","28194","28207","28222","28235","28248","28259","28272","28283","28301","28316","28327","28342","28353","28368","28381","28392","28416","28433","28464","28479","28492","28507","28522","28537","28550","28561","28592","28605","28616","28635","28658","28679","28696","28711","28722","28769","28782","28803","28820","28833","28846","28857","28870","28885","28896","28907","28922","28952","28974","28989","29015","29026","29043","29060","29084","29099","29114","29125","29142","29159","29172","29183","29196","29222","29237","29257","29266","29275","29286","29301","29314","29327","29338","29360","29375","29390","29409","29422","29433","29450","29463","29474","29485","29506","29523","29536","29549","29562","29585","29600","29623","29638","29655","29670","29681","29692","29711","29716","33040","33053","33077","33107","33122","33139","33152","33163","33194","33211","33224","33241","33258","33275","33292","33303","33322","33337","33348","33369","33384","33397","33414","33429","33446","33459","33487","33500","33511","33522","33533","33548","33561","33585","33594","33607","33618","33631","33692","33716","33737","33746","33755","33774","33791","33806","33817","33830","33843","33856","33869","33884","33906","33919","33936","33971","33982","33997","34012","34025","34036","34053","34068","34079","34088","34105","34127","34136","34147","34162","34173","34186","34209","34244","60586","60716","61040","61341","65991","66008","72422","83314","83862","83911","85300","85373","86027","86037","86072","86140","86977","87007","87024","87148","87444","87505","87581","87673","87714","87853","88138","88467","88741","88750","88847","88888","88962","89062","89106","89472","89659","89727","90070","90252","90534","90540","90792","90852","90859","90867","90877","90886","90967","91144","91292","91303","91337","91399","91474","91571","91616","91666","91687","91736","91759","91889","91914","91927","92273","92279","92313","92347","92388","92395","92401","92406","92412","92418","92458","92507","92526","92568","92580","92629","92643","92666","92699","92800","92871","92909","92943","93163","93276","93514","93545","93554","93569","93579","93799","93963","93970","94204","94217","94240","94304","94335","94385","94412","94435","94593","94605","94614","94649","94668","94735","94743","94803","94878","94893","95029","95041","95050","95068","95091","95163","95191","95198","95233","95244","95260","95293","95300","95314","95322","95375","95416","95444","95445","96960","96996","97052","98127","98211","100353","100575","100663","100672","100710","100719","101290","101310","101329","101347","101395","101421","101439","104304","104949","105075","111835","112431","112528") AND term_relationships.term_taxonomy_id IN (125,264,273,207,90,147,91,202,92,93,94,95,96,97,141,142,210,146,124,215,282,245,251,292,239,177,266,204,242,271,236,163,198,167,287,179,165,203,181,237,174,205,178,286,183,229,161,244,194,280,201,102,101,246,184,267,182,265,213,278,220,199,176,162,263,260,180,208,284,197,268,100,232,209,214,103,99,98,175,269,150,247,185) AND out_of_stock_variable.term_id IS NULL GROUP BY term_relationships.term_taxonomy_id
What caused this?
Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
- The topic ‘Site down due to plugin’ is closed to new replies.