Hi, This is the slowest query that is from
BeRocket_Brand_Base_Ordered_Widget->get_brands()
wp-content/plugins/brands-for-woocommerce/includes/widgets/base-widget_ordered.php:338BeRocket_Brand_Base_Ordered_Widget->widget()
wp-content/plugins/brands-for-woocommerce/includes/widgets/base-widget_ordered.php:132BeRocket_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
