• 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)
  • Plugin Author Dmytro Holovnia

    (@dholovnia)

    Hello,

    99% of such issues are conflict with another plugin. It is attached to some hook that we have and we are running the code with the hook it is attached to.

    Do you have dev/test server?
    Best option is to install storefront theme + WooCommerce + our plugin and test it it work ok. After that install your theme and plugins one by one. Check on what step will it fall.

    Regards,
    Dima

Viewing 1 replies (of 1 total)
  • The topic ‘Site down due to plugin’ is closed to new replies.