grant512
Forum Replies Created
-
Forum: Plugins
In reply to: [Index WP MySQL For Speed] Using WBW Filter and it makes the website slowHello John, here is the Query Report
SELECT tr.term_taxonomy_id, tt.term_id, tt.taxonomy, tt.parent, COUNT(*) as cnt
FROM wpf_temp_table AS wpf_temp
INNER JOIN wp_term_relationships tr
ON (tr.object_id=wpf_temp.ID)
INNER JOIN wp_term_taxonomy tt
ON (tt.term_taxonomy_id=tr.term_taxonomy_id)
INNER JOIN wp_terms ttt
ON (ttt.term_id=tt.term_id)
INNER JOIN wp_wpf_meta_data md_type
ON (md_type.product_id=wpf_temp.ID
AND md_type.key_id=1)
WHERE tt.taxonomy IN (‘product_cat’, ‘pwb-brand’, ‘pa_series’, ‘pa_fender-type’, ‘pa_width-sf’, ‘pa_diameter’, ‘pa_bend-size’, ‘pa_size-diam’, ‘pa_base-diameter’, ‘pa_measurements’, ‘pa_centre-hole’, ‘pa_overal-length-sf’, ‘pa_inlet-type’, ‘pa_round-barrel’, ‘pa_size-a-od’, ‘pa_id-size’, ‘pa_od-size’, ‘pa_inlet-id’, ‘pa_stacks-length’, ‘pa_inlet’, ‘pa_nat-aspirated’, ‘pa_length’, ‘pa_body-od’, ‘pa_barrel-diameter-am’, ‘pa_barrel-length’, ‘pa_working-range’, ‘pa_size-a-id’, ‘pa_suits-sb’, ‘pa_style’, ‘pa_configuration’, ‘pa_leg-length’, ‘pa_id-clamping-size’, ‘pa_od-clamping-size’, ‘product_tag’)
AND (md_type.val_id!=3
OR tt.taxonomy NOT IN (‘pa_series’,’pa_width-sf’,’pa_diameter’,’pa_bend-size’,’pa_size-diam’,’pa_overal-length-sf’,’pa_id-size’,’pa_od-size’,’pa_inlet-id’,’pa_stacks-length’,’pa_inlet’,’pa_nat-aspirated’,’pa_length’,’pa_body-od’,’pa_barrel-diameter-am’,’pa_barrel-length’)
OR EXISTS(SELECT 1
FROM wpf_temp_table_var_attrs as p_childs
WHERE p_childs.id=wpf_temp.id and p_childs.taxonomy=tt.taxonomy and p_childs.value=ttt.slug
LIMIT 1))
GROUP BY tr.term_taxonomy_id /* From [cscparts.com.au/tag/truck/] in [/nas/content/live/cscparts/wp-content/plugins/woo-product-filter/modules/woofilters/mod.php:4155] */Unsure why the monitor is logging Sept 7 only. I did start monioting just now and its not updating.
Saved monitors monitor September 4, 2025 5:41 am―September 7, 2025 8:56 pm (3.6d) 3,105 queries captured.VersionsPlugin:1.5.4 MySQL:8.0.43-34 WordPress:6.8.3 WordPress database:60421 php:8.2.29
Forum: Plugins
In reply to: [Index WP MySQL For Speed] Using WBW Filter and it makes the website slowHI, I did start a monitor again. Still the same id MmxRy9RR
Forum: Plugins
In reply to: [Index WP MySQL For Speed] Using WBW Filter and it makes the website slowI noticed a slow response when doing an update with products. Also when importing csv resulting to Bad gateway.
- This reply was modified 8 months, 3 weeks ago by grant512.
Support is getting worst. I have issues as well and in PRO version still no response.
Try adding a container under Settings-Option-Main-Product Container Selector or it looks like a java scripting issue. PLay around with the other settings. How’s thewebsite speed when doing filter?
Forum: Plugins
In reply to: [Index WP MySQL For Speed] Using WBW Filter and it makes the website slowHello Ollie, did not really notice much difference when I converted to high-performance keys. Any other ways I can improve the speed? do you think?
Forum: Plugins
In reply to: [Index WP MySQL For Speed] Using WBW Filter and it makes the website slowHello Ollie, yesterday I tried converting all to high -performance keys including wp-postmeta. Also I did upload the result using monitor tab with ID MmxRy9RR. Thank you.
Also unsure if I capture the latest as I was testing a preload cache and disabled it when I did a fresh monitor.
Forum: Plugins
In reply to: [Product Filter for WooCommerce by WBW] Clean slugs/urlIs there a way to shorten? example domain.com/product-category/truck-parts/?wpf_filter_cat_0=2023&wpf_fbv=1&wpf_dpv=1&wpf_filter_pwb_list_1=272&product_tag_25=socks
above example are three filters only but notice how it looks clutter
Looks like this Plugin’s support is dead. It was a risk using this plugin should have went with other well known filtering product.
Hi any luck with the speed? seems like I am having similar problem
Forum: Plugins
In reply to: [Perfect Brands for WooCommerce] Shortcode does not display in Archieve loophello @jmatiasmastro I’;ve been contacting every support and still didnt get an answer. Could you let me know how to solve issue. Do I need a PRO version?
Forum: Plugins
In reply to: [Perfect Brands for WooCommerce] Shortcode does not display in Archieve loopup.. 6 days and still no reply
Forum: Plugins
In reply to: [Perfect Brands for WooCommerce] Shortcode does not display in Archieve loopup
Hi, will the plugin works in Simple Products? and display attributes?
I just wanted to display attributes of a single product in a table manner.
Yup, is there a way to auto-copy the SKU and attributes of an active product?
I addded a table shortcode with sku and description and I was expecting it to sync with the active product.
- This reply was modified 2 years, 4 months ago by grant512.