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
