Speed and Performance Issues with Woopress

Hello,

We always test plugins before including them to themes and our demos where those plugins are used, don’t have issues with slow loading.
We optimized our themes as much as we could.
Try to check your server settings. Also try to increase memory_limit value.

Best regards,
Jack Richardson.

Hello,

We recommend you to use the plugin “w3c total cache” and optimize your images. Also enable gzip compression on your server. It will make the site loading faster.

Thank you.
Regards,
Eva Kemp.

Hello @deea.b22@gmail.com,

Please try solution described in this article:
http://customizewp.com/eliminate-render-blocking-javascript-and-css-above-the-fold-content-in-wordpress-w3-total-cache/
Also you can try this plugin https://wordpress.org/plugins/footer-javascript/

Regards,
Eva Kemp.

Hello @pedro8,

Try to use W3 Total Cache plugin and set up it
http://www.onlinemediamasters.com/w3-total-cache-settings/
https://code.tutsplus.com/tutorials/configuring-w3-total-cache-general-settings-i–cms-20920
http://www.wpbeginner.com/plugins/how-to-install-and-setup-w3-total-cache-for-beginners/

As for Blog posts go to Theme Options > Blog Layout > Excerpt length(words) and enter words number you want to show.

Regards,
Eva Kemp.

Hello @pedro8,

As for speed issue, does the problem persist only with our theme? Please activate default WordPress theme and check it.

To get old posts features you can reupload the file content.php from the previous theme version.

Regards,
Eva Kemp.

Hi I sent an email to Olga about my previous message, but she might be to busy to respond.

Below are the queries that are slowing down my site dramatically and I really need some help.
If you log in you will be able to use the query monitor on the admin bar in the front end.

Slow Database Queries (above 0.05s)
Query Caller Time
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts
LEFT JOIN wp_term_relationships
ON (wp_posts.ID = wp_term_relationships.object_id)
INNER JOIN wp_postmeta
ON ( wp_posts.ID = wp_postmeta.post_id )
INNER JOIN wp_postmeta AS mt1
ON ( wp_posts.ID = mt1.post_id )
INNER JOIN wp_postmeta AS mt2
ON ( wp_posts.ID = mt2.post_id )
WHERE 1=1
AND ( wp_term_relationships.term_taxonomy_id IN (3095,3099,3100,3101,3102,3106,3107,3109,3119,3121,3154,3155,3223,3226,3245,3246,3248,3350,3437,3889) )
AND ( wp_postmeta.meta_key = ‘total_sales’
AND ( ( mt1.meta_key = ‘_visibility’
AND mt1.meta_value IN (‘visible’,’catalog’) )
AND ( mt2.meta_key = ‘_stock_status’
AND mt2.meta_value = ‘instock’ ) ) )
AND wp_posts.post_type = ‘product’
AND (wp_posts.post_status = ‘publish’
OR wp_posts.post_status = ‘private’)
GROUP BY wp_posts.ID
ORDER BY wp_postmeta.meta_value+0 DESC, wp_posts.post_date DESC
LIMIT 0, 100 /* From [alphaled.staging.wpengine.com/product-category/lighting-type/] in [/nas/content/staging/alphaled/index.php:17] */
WP_Query->get_posts
+ 3.4140
SELECT DISTINCT t.*, tt.*, tr.object_id
FROM wp_terms AS t
INNER JOIN wp_term_taxonomy AS tt
ON t.term_id = tt.term_id
INNER JOIN wp_term_relationships AS tr
ON tr.term_taxonomy_id = tt.term_taxonomy_id
LEFT JOIN wp_termmeta AS tm
ON (t.term_id = tm.term_id
AND tm.meta_key = ‘order’)
WHERE tt.taxonomy IN (‘brand’, ‘product_brand’, ‘product_type’, ‘product_cat’, ‘product_tag’, ‘product_shipping_class’, ‘pa_wattage’, ‘pa_efficacy’, ‘pa_color’, ‘pa_beam-angle’, ‘pa_mounting-options’, ‘pa_color-temperature’, ‘pa_driver’, ‘pa_chip’, ‘pa_lumens’, ‘pa_cri’, ‘pa_voltage-input’, ‘pa_voltage-output’, ‘pa_amperage’, ‘pa_hertz’, ‘pa_total-harmonic-distortion’, ‘pa_dimmability’, ‘pa_operating-temperature’, ‘pa_ip-rating’, ‘pa_ik-level’, ‘pa_lifetime’, ‘pa_accessories’, ‘pa_fixture-height’, ‘pa_fixture-width’, ‘pa_fixture-length’, ‘pa_bulb-number’, ‘pa_bulb-wattage’, ‘pa_bulb-type’, ‘pa_bulb-included’, ‘pa_voltage’, ‘pa_switch-type’, ‘pa_collection’, ‘pa_finish’, ‘pa_materials’, ‘pa_shade-glass-description’, ‘pa_shade-glass-finish’, ‘pa_shade-glass-materials’, ‘pa_shade-glass-width-at-top’, ‘pa_shade-glass-height’, ‘pa_extension-rods’, ‘pa_chain-length’, ‘pa_cord-legnth’, ‘pa_cord-color’, ‘pa_harp-sider’, ‘pa_outdoor-use’, ‘pa_available-with-led’, ‘pa_additional-features’, ‘pa_safety-rating’, ‘pa_base-type’, ‘pa_additional-bulb’, ‘pa_additional-bulb-wattage’, ‘pa_additional-bulb-type’, ‘pa_number-of-boxes’, ‘pa_second-box-length’, ‘pa_second-box-width’, ‘pa_second-box-height’, ‘pa_second-box-volume’, ‘pa_second-box-weight’)
AND tr.object_id IN (45762, 45763, 45764, 45765, 45766, 45769, 45770, 45772, 45778, 45779, 45780, 45782, 45784, 45789, 45793, 45797, 45800, 45802, 45805, 45807, 45808, 45812, 45816, 45819, 45820, 45822, 45825, 45826, 45832, 45833, 45836, 45840, 45845, 45846, 45848, 45850, 45852, 45857, 45859, 45862, 45863, 45864, 45867, 45868, 45870, 45871, 45874, 45876, 45884, 45888, 45889, 45891, 45892, 45893, 45894, 45895, 45896, 45900, 45906, 45910, 45911, 45912, 45917, 45921, 45923, 45925, 45926, 45928, 45929, 45931, 45932, 45935, 45941, 45943, 45944, 45947, 45954, 45955, 45957, 45962, 45963, 45966, 45967, 45969, 45970, 45971, 45972, 45973, 45976, 45978, 45979, 45980, 45989, 45991, 45992, 45994, 45996, 45997, 45998, 45999)
ORDER BY tm.meta_value+0 ASC, t.name ASC /* From [alphaled.staging.wpengine.com/product-category/lighting-type/] in [/nas/content/staging/alphaled/index.php:17] */
WP_Term_Query->get_terms
+ 0.1026
SELECT object_id, term_taxonomy_id
FROM wp_term_relationships
INNER JOIN wp_posts
ON object_id = ID
WHERE term_taxonomy_id IN (945,4879,3129,3154,3131,3151,3119,5890,75,5901,5974,3167,5849,3092,3093,5829,3350,5780,3095,5072,3165,76,3101,3155,6071,5828,4009,6266,5881,6175,101,491,6160,5883,5956,5897,3128,5819,5841,3168,3103,5831,3157,6174,5984,67,74,3099,3226,5862,3159,3164,5789,5844,5830,5781,5959,5868,3160,5777,68,3112,3163,3161,3162,66,220,418,65,4856,5827,6114,5820,5857,5832,3158,3090,5833,5939,3117,3130,3115,3111,69,3116,4352,3121,71,3106,175,3091,3169,70,3179,5847,5973,5940,3889,5872,5783,5848,6115,5882,5947,4857,5859,3118,5958,6034,3110,4584,6130,5778,3702,3292,72,5896,3291,3114,3113,3275,4865,73,218,3173,5898,5823,5853,3245,5965,5900,6119,5824,5825,5850,5805,5835,417,2513,3166,5768,6243,5942,5812,6227,5905,3223,5855,5941,3216,5568,5948,5639,3120,3437,3100,5929,5772,445,5843,419,3107,3156,3109,5807,5836,5878,5839,5822,5846,3246,5960,5932,5863,3102,4677,77,3248,5943)
AND post_type IN (‘product’)
AND post_status = ‘publish’ /* From [alphaled.staging.wpengine.com/product-category/lighting-type/] in [/nas/content/staging/alphaled/wp-content/plugins/woocommerce/includes/widgets/class-wc-widget-product-categories.php:242] */
_pad_term_counts
+ 0.2369
SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, terms.term_id as term_count_id
FROM wp_posts
INNER JOIN wp_term_relationships AS term_relationships
ON wp_posts.ID = term_relationships.object_id
INNER JOIN wp_term_taxonomy AS term_taxonomy USING( term_taxonomy_id )
INNER JOIN wp_terms AS terms USING( term_id )
LEFT JOIN wp_term_relationships
ON (wp_posts.ID = wp_term_relationships.object_id)
INNER JOIN wp_postmeta
ON ( wp_posts.ID = wp_postmeta.post_id )
INNER JOIN wp_postmeta AS mt1
ON ( wp_posts.ID = mt1.post_id )
WHERE wp_posts.post_type IN ( ‘product’ )
AND wp_posts.post_status = ‘publish’
AND ( wp_term_relationships.term_taxonomy_id IN (3095,3099,3100,3101,3102,3106,3107,3109,3119,3121,3154,3155,3223,3226,3245,3246,3248,3350,3437,3889) )
AND ( ( wp_postmeta.meta_key = ‘_visibility’
AND wp_postmeta.meta_value IN (‘visible’,’catalog’) )
AND ( mt1.meta_key = ‘_stock_status’
AND mt1.meta_value = ‘instock’ ) )
AND terms.term_id IN (4858,4862,4863,4861,6268,5581,4864,5826)
GROUP BY terms.term_id /* From [alphaled.staging.wpengine.com/product-category/lighting-type/] in [/nas/content/staging/alphaled/wp-content/plugins/woocommerce-brands/classes/widgets/class-wc-widget-brand-nav.php:433] */
WC_Widget_Brand_Nav->get_filtered_term_product_counts
+ 3.1309
SELECT DISTINCT t.*, tt.*
FROM wp_terms AS t
INNER JOIN wp_term_taxonomy AS tt
ON t.term_id = tt.term_id
LEFT JOIN wp_termmeta AS tm
ON (t.term_id = tm.term_id
AND tm.meta_key = ‘order_pa_collection’)
WHERE tt.taxonomy IN (‘pa_collection’)
ORDER BY tm.meta_value+0 ASC, t.name ASC /* From [alphaled.staging.wpengine.com/product-category/lighting-type/] in [/nas/content/staging/alphaled/wp-content/plugins/woocommerce/includes/widgets/class-wc-widget-layered-nav.php:145] */
WP_Term_Query->get_terms
+ 0.0542
SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, terms.term_id as term_count_id
FROM wp_posts
INNER JOIN wp_term_relationships AS term_relationships
ON wp_posts.ID = term_relationships.object_id
INNER JOIN wp_term_taxonomy AS term_taxonomy USING( term_taxonomy_id )
INNER JOIN wp_terms AS terms USING( term_id )
LEFT JOIN wp_term_relationships
ON (wp_posts.ID = wp_term_relationships.object_id)
INNER JOIN wp_postmeta
ON ( wp_posts.ID = wp_postmeta.post_id )
INNER JOIN wp_postmeta AS mt1
ON ( wp_posts.ID = mt1.post_id )
WHERE wp_posts.post_type IN ( ‘product’ )
AND wp_posts.post_status = ‘publish’
AND ( wp_term_relationships.term_taxonomy_id IN (3095,3099,3100,3101,3102,3106,3107,3109,3119,3121,3154,3155,3223,3226,3245,3246,3248,3350,3437,3889) )
AND ( ( wp_postmeta.meta_key = ‘_visibility’
AND wp_postmeta.meta_value IN (‘visible’,’catalog’) )
AND ( mt1.meta_key = ‘_stock_status’
AND mt1.meta_value = ‘instock’ ) )
AND terms.term_id IN (475,485,429,423,432,403,439,453,464,1784,4337,4786,4431,3589,3513,3211,2016,1038,1812,1460,2446,1815,3886,2131,1594,1704,2455,4117,4167,4048,5713,1408,2090,4321,4730,1612,2581,1071,4693,2492,4588,3317,1833,1123,4526,4305,3356,1591,1584,3230,2647,2040,3716,722,2634,2453,4102,2767,995,3194,1518,2172,2356,1328,4583,3731,4738,1313,3975,2619,2514,4150,1147,6366,1806,1819,544,1435,5589,4722,1809,3881,1582,3572,1429,4125,1138,4716,1308,1826,1830,1800,1828,5710,1666,4725,508,783,4768,3708,1959,4178,3756,3455,4141,2162,3543,3946,3338,4784,3354,1922,2083,3803,1727,1325,5704,1334,3895,3280,6297,4682,3622,2415,3420,4119,3696,2135,6394,4736,1171,1061,1113,2386,651,1179,3753,1293,1737,1200,1854,2443,1237,6373,5606,4680,4188,4076,2730,2633,3447,4443,4479,1133,3444,751,4073,3277,2392,3250,843,3552,3587,4334,3207,4206,1394,1636,3196,2471,3495,3439,503,4335,1188,1889,2697,4005,5611,1075,2032,2426,3759,2365,4213,1126,6267,3958,559,4699,2167,5512,4441,3773,4196,3208,1654,4770,3849,2463,2384,4164,5226,4447,1322,1482,1866,1367,1150,1864,1030,1451,3432,1745,4128,1028,3630,4515,4394,1156,2374,2772,1424,5565,4138,2033,4533,744,749,3713,6314,1978,2079,3407,1190,1558,1580,3825,3898,3796,4110,3475,4718,4186,639,2089,4676,3646,3452,1873,1898,681,2036,4312,4256,3979,3784,567,6375,3578,4109,4560,3325,3375,4429,1796,3877,3775,5555,3655,1222,4751,1642,3625,1380,4007,2574,2618,4740,4389,4267,3453,3698,4790,4530,3960,1305,3900,4779,6356,2447,5402,2604,4021,614,4686,2482,4273,769,3631,1619,908,866,3190,3202,3936,1358,4714,4678,3416,4324,4169,2534,3992,1677,5722,3704,6288,3287,3624,1472,3925,4689,3984,3303,3714,4096,1041,6328,4284,3948,3832,3659,4289,4303,4071,4281,3930,4489,3674,4340,3961,2001,710,4250,4260,3553,1926,1543,2594,3890,1546,1385,3935,1599,3645,3415,4762,3648,1961,4309,1603,4026,6434,1143,3956,3621,1503,3740,3273,3554,1514,4053,4091,4747,3916,826,3525,3393,1182,4532,2030,1427,1326,4210,1938,4708,1831,831,1024,1008,1375,1058,2580,5579,2583,1186,3628,3844,4246,4404,1914,4133,4711,1916,1497,4734,2738,4710,1116,2528,1528,1535,774,1910,4261,3777,3512,4145,5510,2506,552,2491,734,4029,1381,1309,3959,3957,4231,3239,3411,3182,2078,4218,3320,2571,4728,1521,848,3967,6338,1954,4504,1401,1643,4787,4258,1242,3861,2375,4034,5426,625,1447,1697,1371,849,1760,804,3726,6290,4523,4518,4183,2445,3918,4724,2052,1755,1316,4350,1462,3333,665,4559,4525,4427,2418,5732,1687,2028,4065,4679,1911,3199,3445,2166,1971,2591,3610,3611,3612,3613,3964,1913,4695,1659,4270,4101,1722,3725,4027,587,5298,3408,2496,3576,4154,4050,621,3874,4697,3826,4203,4775,1000,3557,3556,674,4577,4440,4013,4228,4498,5717,1596,787,6428,6321,1219,6419,4464,4384,3682,1856,3724,4232,4794,1006,1353,4175,2457,2564,1957,2422,2585,3410,3747,1119,3336,1129,6359,3337,3962,1674,4589,3249,4684,1153,1516,2621,2429,4720,6281,1865,1378,3511,1445,1197,2637,1984,3623,4422,2577,1981,4396,1733,1040,1014,3180,1414,3997,2094,676,1589,1869,4124,2620,1881,3968,1877,2579,4478,5691,1661,3322,1992,2105,2486,1906,3187,1883,519,1606,3888,3297,2616,4513,879,5322,3176,3171,4411,2544,3257,1789,580,1573,3436,4244,3693,4581,1175,813,1045,1901,3820,3865,3672,4283,4308,3376,4502,3689,4772,3233,1413,4225,1762,1017,1047,4691,4155,2371,3737,2525,6272,3749,5399,4497,867,4732,3816,4706,6277,4438,4777,2359,2169,4032,1479,874,4792,4758,2522,4268,668,4701,4331,3429,2138,5318,3722,634,1709,1646,5085,1440,4781,3518,2174,1629,4566,3745,1507,1287,3387,4704,1274,3188,1382,1405,4023,3236,3792,1433,2161,794,6300,4683,2435,3824,1269,1109,4294,4199,4098,2440,3926,1651,4344,4282,3633,3520,3306,3903,3363,2592,3862,3608,4025,3311,2071,1235,1578,3718,5697,1159,4681,1494,521,2531,2152,1054,5041,3735,3289,1564,4492,3399,6403,3600,4046,3465,1251,4756,1164,3293,4789,3893,1331,2551,5511,860,902,4279,3413,3544,6397,3252,1511,1648,4055,3191,3617,1278,3742,1746,3940,3644,3334,2126,671,4129,4524,3619,1680,3981,2101,3711,4568,3195,4467,1730,3503,2740,2096,1715,6302,2641,2722,3424,1457,3391,4501,2109,5720,1616,3284,1500,4011,3807,2394,4702,689,4576,3776,976,3379,3215,1318,1995,1998,3989,3555,1239,4742,1162,1416,3802,1361,2106,1436,1064,3695,3485,1989,2602,2601,2598,3592,609,4108,2529,2434,4200,4194,4067,2369,1341,2044,4392,859,2360,628,3666,4044,2467,3462,1772,3985,3547,3686,3454,3723,2400,645,3854,2624,942,2411,529,4753,1627,4130,3458,3598,4748,2086,6449,2458,3994,1673,4783,4191,1689,1987,2018,3650,3996,3778,2644,4399,2745,2024,1484,602,3715,4796,3741,2402,3343,1345,4147,1583,1884,700,6275,1683,1297,4266,4234,3496,2625,4799,1609,4249,1319,4310,2568,4760,2103,2539,4170,1886,3953,4330,4495,1892,1264,1757,877,2547,3183,1908,1020,3883,4274,839,1782,6353,3577,3680,1088,1532,2653,4745,999,1022,6421,1919,3951,1467,3744,5617,997,4446,4028,2466,4018,2589,6284,4171,3517,4215,2111,3457,3808,3990,4591,6386,1082,3943,4024,1740,1418,6349,1838,1684,4582,626,4182,4031,4127,3837,3558,799,2686,4332,3449,1741,3450,4134,3983,4420,3892,2041,1227,1952,2228,3500,2487,3815,6400,4022,1475,3781,2395,780,845,1282,2355,1454,3177,3359,1469,4111,2479,2430,2452,4503,1093,3779,3521,1411,4088,1777,536,2546,1536,662,1398,3478,3748,1555,3963,4423,2117,3347,3878,1388,4301,3307,1333,3406,3403,4120,5068,1167,4285,857,2022,3446,3720,4051,2627,3751,1292,3835,1860,4016,1565,4325,6392,4798,4038,1850,6295,4766,6364,4474,1665,1490,2450,4726,1657,1936,6291,4276,1822,2596,3649,4773,759,791,3949,4313,2399,1212,4265,4687,2499,1301,3787,2385,1841,2586,3539,6270,4105,1846,2123,1487,4063,1390,3568,3549,1091,1736,4135,656,1929,1842,1230,3378,607,2456,5727,1945,3800,1670,1464,3268,1621,3259,4220,3636,1748,1752,3499,1538,2145,1775,2565,1255,3870,3931,1098,2559,2058,4713,2597,4506,905,872,3917,1896,3304,2011,2170,1861,1035,4426,1832,1899,2424,6424,2389,3366,2754,1874,1068,2475,3840,1948,3228,5573,3396,3390,1871,4685,1615,4002,3471,1052,3812,1941,2363,786,3510,4081,3690,3743,4158,1530,991,5483,2377,4729,3755,4705,4320,3941,1050,796,3933,2043,2159,2705,3652,3423,4104,2623,4328,3685,4115,4112,3638,824,4496,4184,2061,3814,3599,4172,4004,5396,2501,3232,5623,695,3616,4300,590,3798,3829,4252,2004,4370,3285,3978,3827,3987,1245,2068,4580,3414,3626,3921,1258,2713,2102,730,4386,636,1172,2542,1706,3719,1441,1694,1338,1624,4342,1103,3614,1525,6279,2088,1069,2409,2015,1965,2460,4764,3309,3497,6380,4363,4327,3546,2158,2381,3710,4161,1586,4042,6306,3805,1078,1699,1804,765,2046,2048,3999,2649,1985,1204,3428,974,4235,3451,6335,971,4563,3867,3860,4198,3443,3739)
GROUP BY terms.term_id /* From [alphaled.staging.wpengine.com/product-category/lighting-type/] in [/nas/content/staging/alphaled/wp-content/plugins/woocommerce/includes/widgets/class-wc-widget-layered-nav.php:380] */
WC_Widget_Layered_Nav->get_filtered_term_product_counts
+ 2.9226
SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, terms.term_id as term_count_id
FROM wp_posts
INNER JOIN wp_term_relationships AS term_relationships
ON wp_posts.ID = term_relationships.object_id
INNER JOIN wp_term_taxonomy AS term_taxonomy USING( term_taxonomy_id )
INNER JOIN wp_terms AS terms USING( term_id )
LEFT JOIN wp_term_relationships
ON (wp_posts.ID = wp_term_relationships.object_id)
INNER JOIN wp_postmeta
ON ( wp_posts.ID = wp_postmeta.post_id )
INNER JOIN wp_postmeta AS mt1
ON ( wp_posts.ID = mt1.post_id )
WHERE wp_posts.post_type IN ( ‘product’ )
AND wp_posts.post_status = ‘publish’
AND ( wp_term_relationships.term_taxonomy_id IN (3095,3099,3100,3101,3102,3106,3107,3109,3119,3121,3154,3155,3223,3226,3245,3246,3248,3350,3437,3889) )
AND ( ( wp_postmeta.meta_key = ‘_visibility’
AND wp_postmeta.meta_value IN (‘visible’,’catalog’) )
AND ( mt1.meta_key = ‘_stock_status’
AND mt1.meta_value = ‘instock’ ) )
AND terms.term_id IN (487,425,405,441,477,466,493,6286,2317,683,868,2755,911,1547,3290,6368,2054,2062,981,2074,918,1420,987,2107,1437,1289,3344,3699,3294,3548,3368,771,1396,1203,1693,2372,1858,1967,1963,1780,3927,523,1997,531,6414,6405,2515,841,1023,2378,1062,2263,2469,1009,1032,1121,2265,1145,712,2397,1359,1315,5618,5625,2084,1431,5693,1350,5728,4382,4383,2060,5725,1848,1925,1720,2477,1931,2489,1631,6409,1220,1918,1509,2773,554,6293,2473,1214,1261,5590,538,4219,3783,904,4251,3476,4247,4380,5608,4700,937,886,928,949,979,957,5566,882,1958,2006,3972,851,1682,2209,701,3838,3939,3641,4156,2345,4168,2617,3982,2224,3388,1679,3937,3647,3526,3349,1363,2552,4454,4448,4020,3225,3891,3995,1140,960,3425,3427,3392,1100,3172,4061,3324,3270,3351,4472,4113,2734,1835,1084,1764,3934,1443,653,2427,2763,1993,2045,3774,5228,1675,546,6381,3178,6412,1271,1105,3550,1276,6379,1206,1343,1253,2382,1991,4475,2508,3705,3952,4295,735,1321,1477,4527,1228,4217,1266,1562,1663,954,6401,6452,5612,1915,5580,1346,4780,2294,4694,664,4248,2561,1541,3501,4253)
GROUP BY terms.term_id /* From [alphaled.staging.wpengine.com/product-category/lighting-type/] in [/nas/content/staging/alphaled/wp-content/plugins/woocommerce/includes/widgets/class-wc-widget-layered-nav.php:380] */
WC_Widget_Layered_Nav->get_filtered_term_product_counts
+ 2.2822
SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, terms.term_id as term_count_id
FROM wp_posts
INNER JOIN wp_term_relationships AS term_relationships
ON wp_posts.ID = term_relationships.object_id
INNER JOIN wp_term_taxonomy AS term_taxonomy USING( term_taxonomy_id )
INNER JOIN wp_terms AS terms USING( term_id )
LEFT JOIN wp_term_relationships
ON (wp_posts.ID = wp_term_relationships.object_id)
INNER JOIN wp_postmeta
ON ( wp_posts.ID = wp_postmeta.post_id )
INNER JOIN wp_postmeta AS mt1
ON ( wp_posts.ID = mt1.post_id )
WHERE wp_posts.post_type IN ( ‘product’ )
AND wp_posts.post_status = ‘publish’
AND ( wp_term_relationships.term_taxonomy_id IN (3095,3099,3100,3101,3102,3106,3107,3109,3119,3121,3154,3155,3223,3226,3245,3246,3248,3350,3437,3889) )
AND ( ( wp_postmeta.meta_key = ‘_visibility’
AND wp_postmeta.meta_value IN (‘visible’,’catalog’) )
AND ( mt1.meta_key = ‘_stock_status’
AND mt1.meta_value = ‘instock’ ) )
AND terms.term_id IN (457,424,404,433,476,465,435,440,486,430,4271,2077,3335,675,726,2922,3780,4746,4719,4744,4793,3221,4749,1731,672,840,2316,1283,1154,4136,2053,6438,1213,1834,2677,2664,1458,1002,1776,1501,2706,3412,2638,4014,2232,4043,873,568,2749,615,2493,1909,1710,4590,723,892,560,1758,2110,2262,563,1488,1630,1607,553,2206,4010,2234,1279,1917,4703,4727,4741,1124,825,781,537,2603,2173,6430,6350,1637,1335,545,1051,1139,4690,4688,4712,1042,4381,1018,805,1820,2348,2255,646,1184,1480,1240,1491,1617,2575,1031,2337,1039,2203,1048,1349,4765,1658,4757,2643,1483,3692,4056,1160,1662,2099,977,2357,906,1029,6395,6436,1855,2031,2651,1810,1816,4008,1134,1813,2050,4723,4739,881,2431,2451,2366,1667,2177,4089,1508,1372,4788,909,3251,1224,4696,3438,3880,3355,1681,3561,2412,4778,3793,3789,2342,1288,1209,1747,827,2444,4030,1036,1409,1094,5459,3514,2387,6448,2393,2472,2587,4721,3377,2361,4159,2330,2364,2340,652,1259,1198,2248,1320,1448,1559,1362,1430,1246,1570,2242,1151,3231,2273,3729,4187,1223,1317,1314,986,1927,2085,2605,1495,2613,2196,2483,2608,2611,1419,1201,2488,6315,1600,3498,1386,1311,1707,5475,1070,3402,1504,711,2628,2185,959,3015,1089,1275,1104,1176,4769,3323,1522,1907,1655,5457,1979,6273,3269,834,1205,4195,1187,1625,2318,3174,3260,3468,2436,2560,6384,4709,3258,4735,522,1065,6324,1130,2320,1688,2069,1231,1406,2569,1157,1399,3305,4692,1857,1872,4743,5229,1395,731,1778,927,6404,1202,6363,1302,1962,4107,1298,3434,1966,2039,2208,3442,2593,3441,4106,748,504,1021,2419,2725,1055,1183,2097,1943,1765,4800,657,2545,4717,2502,4585,1649,4759,3728,3281,2065,2034,2287,2326,2267,1994,955,2507,2236,2441,1972,2020,2199,2530,6292,1168,3479,3727,3401,1843,6278,2654,880,2403,3400,1996,5456,4752,6330,2059,1934,4358,1249,2276,4085,4785,2293,2329,1902,1905,5361,2339,1329,3809,885,4074,4075,5454,6422,1790,4189,4707,4214,637,1801,4259,2271,3253,3618,4077,4715,2104,4795,1597,1485,6342,2240,6346,1890,6407,1193,1191,2310,1692,6439,2373,2217,1442,3348,3237,1127,1144,4255,1756,1252,2344,1148,4227,1110,1644,5069,978,6367,936,2264,677,776,663,1887,2000,2464,1878,1969,2260,2037,1647,1099,1083,745,910,2338,1785,3998,2179,572,3797,4142,622,3419,2595,3804,3806,3418,808,2645,1455,1498,875,1685,1823,1120,1117,1610,1787,1786,4517,2259,4082,1533,1982,878,666,2590,1526,2080,6329,3417,5551,2396,998,3868,608,611,1473,4315,3894,1723,1476,3524,3788,581,3522,2500,4019,760,588,1079,6416,1092,775,2002,1561,1613,2171,1839,1976,1825,3721,3986,1402,2497,6298,5359,788,1705,2091,6390,3326,2448,4774,6443,950,1339,6271,1719,5523,5405,5404,3263,5403,2461,4393,3639,2599,2095,2017,2019,2025,3298,2023,1990,1512,4771,4767,1412,1604,903,1270,509,2723,2698,4733,2468,1189,2012,1180,1949,1930,1946,2480,2042,1233,1265,4797,2229,4698,4761,1939,1951,1955,4201,890,3813,3494,3950,3691,6432,530,3278,1761,4017,2257,4185,4057,6285,1368,6282,1076,4731,800,1851,1862,4379,1867,1870,4592,1354,1783,627,3681,850,690,832,6429,4754,2029,1942,2333,2768,1652,4230,4782,3229,4364,814,3472,4776,4791,2280,4763,2548,1779,3426,3911,3615,4216,4221,3782,4226,4000,4058,752,2687,4272,3433,4395,1114,1391,1885,682,6413,2328,948,2301,956,4398,1847,6360,770,1797,972,1974,2334,2657,2390,975,1342,973,2005,2650,4146,4054,1805,1769,943,1763,4233,4211,2323)
GROUP BY terms.term_id /* From [alphaled.staging.wpengine.com/product-category/lighting-type/] in [/nas/content/staging/alphaled/wp-content/plugins/woocommerce/includes/widgets/class-wc-widget-layered-nav.php:380] */
WC_Widget_Layered_Nav->get_filtered_term_product_counts
+ 2.4641
SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, terms.term_id as term_count_id
FROM wp_posts
INNER JOIN wp_term_relationships AS term_relationships
ON wp_posts.ID = term_relationships.object_id
INNER JOIN wp_term_taxonomy AS term_taxonomy USING( term_taxonomy_id )
INNER JOIN wp_terms AS terms USING( term_id )
LEFT JOIN wp_term_relationships
ON (wp_posts.ID = wp_term_relationships.object_id)
INNER JOIN wp_postmeta
ON ( wp_posts.ID = wp_postmeta.post_id )
INNER JOIN wp_postmeta AS mt1
ON ( wp_posts.ID = mt1.post_id )
WHERE wp_posts.post_type IN ( ‘product’ )
AND wp_posts.post_status = ‘publish’
AND ( wp_term_relationships.term_taxonomy_id IN (3095,3099,3100,3101,3102,3106,3107,3109,3119,3121,3154,3155,3223,3226,3245,3246,3248,3350,3437,3889) )
AND ( ( wp_postmeta.meta_key = ‘_visibility’
AND wp_postmeta.meta_value IN (‘visible’,’catalog’) )
AND ( mt1.meta_key = ‘_stock_status’
AND mt1.meta_value = ‘instock’ ) )
AND terms.term_id IN (420,470,427,461,431,395,482,436,5980,862,3189,594,5115,5912,6079,6002,6069,6018,6078,3389,5975,5946,6043,6000,6083,6148,6124,6206,6173,6141,6155,6122,921,5143,5870,5976,5921,5887,6092,3481,5949,5981,5950,6128,5944,6204,6183,6151,6197,6165,6198,6164,6144,6172,6120,6180,6154,6171,6185,6196,6163,6205,6162,6149,6194,6195,6202,5908,6140,6177,6192,6193,6189,6176,6125,6168,6135,6188,685,5141,2718,6262,5861,5860,6217,5927,4040,5875,6212,5837,6222,6137,6184,6132,6134,6233,6237,6239,898,5118,2983,6088,5919,5911,926,5842,6025,5893,5914,6238,6235,624,5082,2700,5967,5952,4079,6156,3588,5888,6147,5954,6236,640,5183,2833,6201,6023,5955,6200,3988,5951,6215,5879,6142,6161,1738,5089,5834,6045,5953,5917,3467,5926,6100,6234,5928,6158,6143,6157,6230,583,5112,2991,5992,5998,6098,3386,5866,5903,5891,5906,6203,5133,2848,5885,5913,6152,2198,5877,5961,6146,6167,5924,720,2715,6182,5994,6247,5991,6199,3519,5918,6127,5910,6116,6036,6153,3170,3535,6228,599,2924,6159,6121,2210,6260,6091,6035,6145,6181,680,5142,3023,6090,6112,6030,1195,5894,5964,6126,6039,5892,2425,5899,513,5962,6089,5869,2423,6150,4339,2810,6068,2771,5304,6033,5923,5909,4039,6169,6213,5985,741,5108,2739,6187,6166,6225,2322,5886,6190,715,5179,2909,6037,6022,6209,2325,5968,6261,2391,3001,5988,2073,6113,6133,505,5131,2708,6060,2207,6055,6218,6107,5135,2828,5920,6024,6032,4333,6057,2321,2299,527,5107,2796,708,6186,2205,1286,5986,2222,3184,5931,5719,6138,964,6123,5902,5737,5184,2955,6067,2195,6101,534,6038,6056,855,5925,2202,520,2751,2305,2192,6219,6104,6080,5211,2682,6102,2341,659,4139,2220,612,5268,5989,5969,5970,4033,6086,1161,5186,2689,4047,1037,6210,6226,5999,5922,2239,2313,618,2735,6208,846,5966,985,2970,6105,3181,6170,4353,5983,3227,6003,5743,5930,3308,631,6053,6054,6004,6005,6245,1128,6211,6084,5916,6040,1593,5990,5993,6087,638,5336,3474,2963,3435,5220,3005,6216,5987,5963,3492,3859,4001,6070,6103,575,4162,2680,5163,6224,4755,5620,3224,5093,6006,6007,6008,6231,6026,6051,6052,6010,4041,5977,5066,6049,6050,6019,4360,6046,6240,1788,6099,993,616,5262,2674,5600,3794,5370,2853,6094,6095,6028,6106,6096,2533,5972,6085,6027,6097,1545,6059,6076,6082,738,6075,6013,6220,5873,2139,6265,6014,6021,5874,1439,6042,6255,6015,6063,6072,6259,1229,2914,6254,6257,6017,6248,3212,5852,6081,6029,6229,6041,3752,5871,6244,4341,5996,5995,5979,1300,2727,5935,5937,6065,1216,6256,6263,6073,706,5413,2758,6253,6252,6062,6001,6110,551,2781,6251,6016,6250,6077,6258,6249,498,2879,733,5281,2873,6264,6214,823,6064,1166,2919,6074,1468,2816,811,589,5117,5938,6232,6009,6047,6048,6058,6012,6129,6241,6246,3460,5934,6011,5865,5945,1262,2114,6117,6061,541,916,989,2439,6111,1576,4173,5957,817,2413,641,5096,2693,6044,5711,6242,6031,6191,4045,5876,2746,5845,6020,5884,4737,3299,4750,6178,1567,3730,6093,6108,6179,893,5119,2742,5880,5997,5915,6066,3461,5889,5978,6207,6223,6221,5971,6139,6109,3712,5730,5695,6136,6131,6118)
GROUP BY terms.term_id /* From [alphaled.staging.wpengine.com/product-category/lighting-type/] in [/nas/content/staging/alphaled/wp-content/plugins/woocommerce/includes/widgets/class-wc-widget-layered-nav.php:380] */
WC_Widget_Layered_Nav->get_filtered_term_product_counts
+ 2.4277
SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, terms.term_id as term_count_id
FROM wp_posts
INNER JOIN wp_term_relationships AS term_relationships
ON wp_posts.ID = term_relationships.object_id
INNER JOIN wp_term_taxonomy AS term_taxonomy USING( term_taxonomy_id )
INNER JOIN wp_terms AS terms USING( term_id )
LEFT JOIN wp_term_relationships
ON (wp_posts.ID = wp_term_relationships.object_id)
INNER JOIN wp_postmeta
ON ( wp_posts.ID = wp_postmeta.post_id )
INNER JOIN wp_postmeta AS mt1
ON ( wp_posts.ID = mt1.post_id )
WHERE wp_posts.post_type IN ( ‘product’ )
AND wp_posts.post_status = ‘publish’
AND ( wp_term_relationships.term_taxonomy_id IN (3095,3099,3100,3101,3102,3106,3107,3109,3119,3121,3154,3155,3223,3226,3245,3246,3248,3350,3437,3889) )
AND ( ( wp_postmeta.meta_key = ‘_visibility’
AND wp_postmeta.meta_value IN (‘visible’,’catalog’) )
AND ( mt1.meta_key = ‘_stock_status’
AND mt1.meta_value = ‘instock’ ) )
AND terms.term_id IN (455,471,446,462,421,396,437,5587,863,5500,4345,4355,655,2752,3340,514,2716,3209,1735,5087,1356,5175,2759,694,2428,5083,1217,557,2420,1739,2300,3315,5097,1703,5113,856,528,5056,4180,2432,5201,3205,499,3175,4361,600,5193,2743,3203,3200,793,5043,2719,5702,4336,1803,5148,2690,3197,595,5064,2701,818,5157,5379,1696,5109,603,5046,4562,629,5054,2709,660,934,965,576,5060,2683,870,5217,3192,917,5049,2694,565,584,5169,3863,3493,5258,4176,632,2736,3657,647,5199,3255,4132,2668,4070,2335,2350,570,2459,1794,3234,1568,5734,3502,3875,2462,2728,3329,5167,894,5080,3213,3483,5254,3185,3342,3327,3300,686,2732,2190,958,5350,4174,1575,1577,2414,721,5138,5736,3217,5349,5591,5159,716,4262,758,5073,2588,506,2747,742,5776)
GROUP BY terms.term_id /* From [alphaled.staging.wpengine.com/product-category/lighting-type/] in [/nas/content/staging/alphaled/wp-content/plugins/woocommerce/includes/widgets/class-wc-widget-layered-nav.php:380] */
WC_Widget_Layered_Nav->get_filtered_term_product_counts
+ 2.4004
SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, terms.term_id as term_count_id
FROM wp_posts
INNER JOIN wp_term_relationships AS term_relationships
ON wp_posts.ID = term_relationships.object_id
INNER JOIN wp_term_taxonomy AS term_taxonomy USING( term_taxonomy_id )
INNER JOIN wp_terms AS terms USING( term_id )
LEFT JOIN wp_term_relationships
ON (wp_posts.ID = wp_term_relationships.object_id)
INNER JOIN wp_postmeta
ON ( wp_posts.ID = wp_postmeta.post_id )
INNER JOIN wp_postmeta AS mt1
ON ( wp_posts.ID = mt1.post_id )
WHERE wp_posts.post_type IN ( ‘product’ )
AND wp_posts.post_status = ‘publish’
AND ( wp_term_relationships.term_taxonomy_id IN (3095,3099,3100,3101,3102,3106,3107,3109,3119,3121,3154,3155,3223,3226,3245,3246,3248,3350,3437,3889) )
AND ( ( wp_postmeta.meta_key = ‘_visibility’
AND wp_postmeta.meta_value IN (‘visible’,’catalog’) )
AND ( mt1.meta_key = ‘_stock_status’
AND mt1.meta_value = ‘instock’ ) )
AND terms.term_id IN (483,447,463,422,397,438,456,472,1263,5586,4374,5501,4346,4356,535,2753,3341,515,3210,3319,5735,5035,6301,779,5185,2760,596,5090,1218,507,2421,2416,5745,3316,5098,2093,5114,6320,542,5057,4181,2433,5202,3206,500,2669,4362,601,5194,2744,3204,3201,5044,2720,5701,1729,5149,2691,3198,5747,617,5065,2702,819,5158,812,5110,604,5047,630,5055,2710,661,935,5729,577,5061,2684,871,5242,3193,1712,5050,2695,1060,5063,635,5170,3346,5190,4177,633,3658,648,5200,3256,966,3801,574,5261,1771,3469,5699,3235,1569,3609,5323,3440,4012,2729,3330,5168,895,2748,5081,3214,3484,5255,3186,3464,3882,3328,1714,3301,3459,4080,1754,3545,4052,687,2717,1357,3382,3470,1708,1774,1768,585,5084,3218,717,4263,5074,847,658,5145,743)
GROUP BY terms.term_id /* From [alphaled.staging.wpengine.com/product-category/lighting-type/] in [/nas/content/staging/alphaled/wp-content/plugins/woocommerce/includes/widgets/class-wc-widget-layered-nav.php:380] */
WC_Widget_Layered_Nav->get_filtered_term_product_counts
+ 2.0276

Are you saying there is no choice, the website has to run slow because that is the way it is?
I really hope that is not the case because I have been spending countless hours trying to speed up the site and it has just been a nightmare.In fact, I have been dealing with this for 3 months exactly.

We spent a load of money on advertising the site but no sales due to slow performance. We have determined this to be the main issue.

Rose, I have purchased both XStore and Woopress. XStore, gave me a load of issues with Speed and Woopress is now giving me these issues. My initial message above was very reasonable and I want you to see that I am not simply complaining. Especially after 3 months of dealing with this.

I expect a better answer or assistance with this issue. Not such a vague response. Last night we were up till 4 in the morning running various test with other themes and the site performed much faster. We purchased Woopress for it’s features, and like I said, performed well when we tested it on other sites to check for speed. This is why I am asking for help, because it doesn’t make sense to me.