Long loading time

Hello,

Not sure what exactly cause this issue.
You can try to use Query monitor plugin to check what exactly slow query or function page has.

Regards,
Oleg

Hi, This is the slowest query that is from

1. BeRocket_Brand_Base_Ordered_Widget->get_brands()
   wp-content/plugins/brands-for-woocommerce/includes/widgets/base-widget_ordered.php:338
2. BeRocket_Brand_Base_Ordered_Widget->widget()
   wp-content/plugins/brands-for-woocommerce/includes/widgets/base-widget_ordered.php:132
3. BeRocket_alphabet_brand_widget->widget()

How can I speed this up?

SELECT?t.slug, tt.description, t.term_id, t.name, tt.count, tm_image.meta_value as image, tm_tooltip.meta_value?AS?tooltip
FROM?tjgn_5_terms?AS?t
LEFT?JOIN?tjgn_5_term_taxonomy?AS?tt
ON?t.term_id = tt.term_id
LEFT?JOIN?tjgn_5_termmeta?AS?tm_image
ON?t.term_id = tm_image.term_id
AND?tm_image.meta_key=’brand_image_url’
LEFT?JOIN?tjgn_5_termmeta?AS?tm_tooltip
ON?t.term_id = tm_tooltip.term_id
AND?tm_tooltip.meta_key=’br_brand_tooltip’
LEFT?JOIN?tjgn_5_termmeta?AS?tm_featured
ON?t.term_id = tm_featured.term_id
AND?tm_featured.meta_key=’br_brand_featured’
WHERE?tt.taxonomy=’berocket_brand’
AND?t.term_id?IN?(11907,11992,11906,11908,11705,11687,11655,11840,11836,11737,11832,11615,11766,12032,11552,11524,11752,11532,11819,11525,11825,11511,11642,11485,11744,12021,11480,11486,12067,11762,12069,11807,11650,11784,12381,11664,11624,11767,11633,11786,12356,11835,11808,11623,11464,11533,12357,11556,11509,11788,11584,11694,11672,11605,11447,11866,11682,11563,11749,11592,11588,11848,11546,11706,11658,11539,12045,12363,11639,11602,11747,11763,11553,11469,11466,12053,12375,11445,11478,11566,11442,11707,11708,11567,11629,11538,11530,11812,11709,11569,11778,11652,11844,11559,11661,11674,11578,11589,11777,11512,11753,11572,11612,11693,11683,12358,11771,11802,11710,11630,11768,11646,11527,11911,11912,11913,11914,11915,11916,12071,11917,11918,11919,11998,11920,11921,12057,11922,11923,11924,11925,11926,11927,11928,11929,11930,11931,11932,11933,12068,11934,11935,11936,11937,12060,11938,11999,12000,11939,11940,11941,11942,12001,11943,11944,11945,11946,11947,11948,11949,11950,11951,12008,11952,11953,11954,11955,11956,11957,11958,11959,11960,11997,11961,12002,11996,12003,11962,11963,11964,11965,12007,11966,11974,11975,11976,11967,11968,11969,12005,11970,11971,12006,11972,11973,11977,12382,12004,11978,11994,11979,11980,11981,11982,11983,11984,12009,11985,11986,12010,12072,11987,11988,11995,12017,11989,11990,11991,11600,11636,12034,11550,12367,11518,11699,11526,12030,11520,11725,11522,11704,11828,11689,11663,11561,11727,12359,11739,11726,11542,11449,11628,11728,11516,11531,11780,11627,11773,11611,11574,11583,11805,12350,11856,12049,12346,11795,11688,12018,11681,11513,11568,11729,12383,11858,11460,11496,11670,11811,12029,11521,12070,11691,11791,11461,11847,11441,11444,11730,11826,11626,11632,11579,11462,11548,11649,11599,11575,11565,11536,11850,11451,11545,11514,11581,11794,11482,11774,12345,11660,11479,11665,11555,11806,11792,11842,11582,12063,11864,11562,11817,11810,11455,11457,11686,12361,11591,11487,11453,11837,12368,11488,11489,11492,11491,11490,11493,12365,11494,11667,11796,11761,11573,11497,11551,11657,11499,11549,11820,11818,11852,11498,11643,11830,11829,11853,11500,11501,11502,11481,11622,11666,11503,11508,12037,11443,11515,11507,12370,11760,11803,11860,11843,11869,11596,11631,11483,12040,11799,11473,11474,11529,11577,11648,11859,11731,11637,12056,11668,11751,11586,11510,11772,11733,11640,11775,11613,11608,11743,11662,11738,11732,11734,11833,11816,11638,11815,11675,11450,11610,11750,11735,11609,11495,11785,12374,11558,11862,11783,11607,11621,11769,11770,11789,11861,11793,11593,11618,11790,11571,11651,11585,11782,11831,11756,11619,11452,11741,11736,11865,11838,11765,11641,11776,11839,11535,11543,11654,11677,11614,11759,11695,11634,11468,11477,12055,12041,11797,11671,11560,12054,11863,11821,11595,11645,11841,11475,11594,11690)
AND?tt.count <> ”
ORDER?BY?cast(tm_featured.meta_value?AS?unsigned)?DESC, t.name?ASC

Hi, I give it a try and created a new thread with this, since I did not get any feedback, There I also deactivated all other plugins, changed to standard theme. Please help me in the new thread