Conversation
supportHello, This query takes 3.2535 sec: https://dpaste.com/C2CR33ZNB If you replace wp_posts.post_date with wp_posts.id then it takes 0.0386 sec: https://dpaste.com/CA5Z8XPU5 Result is the same. Can you please make this change to the next version? Thank you.
Hello @cybercr33p Thanks for contacting us and taking your valuable time to investigate the issue. We have taken it into consideration and will hopefully implement it in the next update. Best Regards, Support Team
Hi @cybercr33p We have checked that, the slow queries are not happening from us also the queries are not same as like you provided above. There might be other plugins are modifying your query. We have tried to reproduced the issue but unfortunately we are not abled to do that. Would you please tell us from where did you get the SQL query? Have you used the “Query Monitor” plugin to check the slow SQL queries. If you would provide us a little more information with a instruction to reproduce the issue would be very beneficial to solve the issue. If you have any questions, please let us know. Thanks!
I found the query using mysqladmin processlist status while visiting the page. As it took ~3 seconds for the page to load, I was able to see the query. And I identified your plugin because the query containts _whols_mark_this_product_as_wholesale_only
Hi @cybercr33p Thanks for your reply. We have checked that the ORDER_BY is not post_date from our side. Please check this https://dpaste.com/EW75YLMYP While we were checking the Woocommerce & Whols plugins were only activated other plugins were disabled. The default ORDER_BY value is the menu_order which is displaying correctly from our side. There might be 3rd party plugins OR your custom coding may affected your query. We will recommend you to check after deactivating other plugin except “Woocommerce & Whols” and also use a Default theme. Anyway, if you don’t want to do the above. You can use the snippet below to change the order by “ID” manually. add_filter( 'woocommerce_default_catalog_orderby', 'hasthemes_change_orderby', 9999 ); function hasthemes_change_orderby( $sort_by ) { return 'id'; } If you have any questions, please let us know. Thanks!
Thank you. It solve the issue.
Glad to know that!
Hello @cybercr33p Thanks for contacting us and taking your valuable time to investigate the issue. We have taken it into consideration and will hopefully implement it in the next update. Best Regards, Support Team
Hi @cybercr33p We have checked that, the slow queries are not happening from us also the queries are not same as like you provided above. There might be other plugins are modifying your query. We have tried to reproduced the issue but unfortunately we are not abled to do that. Would you please tell us from where did you get the SQL query? Have you used the “Query Monitor” plugin to check the slow SQL queries. If you would provide us a little more information with a instruction to reproduce the issue would be very beneficial to solve the issue. If you have any questions, please let us know. Thanks!
I found the query using mysqladmin processlist status while visiting the page. As it took ~3 seconds for the page to load, I was able to see the query. And I identified your plugin because the query containts _whols_mark_this_product_as_wholesale_only
Hi @cybercr33p Thanks for your reply. We have checked that the ORDER_BY is not post_date from our side. Please check this https://dpaste.com/EW75YLMYP While we were checking the Woocommerce & Whols plugins were only activated other plugins were disabled. The default ORDER_BY value is the menu_order which is displaying correctly from our side. There might be 3rd party plugins OR your custom coding may affected your query. We will recommend you to check after deactivating other plugin except “Woocommerce & Whols” and also use a Default theme. Anyway, if you don’t want to do the above. You can use the snippet below to change the order by “ID” manually. add_filter( 'woocommerce_default_catalog_orderby', 'hasthemes_change_orderby', 9999 ); function hasthemes_change_orderby( $sort_by ) { return 'id'; } If you have any questions, please let us know. Thanks!
Thank you. It solve the issue.
Glad to know that!