warning messages from the Query Monitor plugin “Slow Queries”.

  • Resolved Radovan

    (@radovand)


    2 years, 5 months ago

    Hi,

    I’m getting the following warning messages from the Query Monitor plugin “Slow Queries”.

    The messages only appear when loading certain pages in both frontend and backend.
    The warning messages disappear if I disable the CFF plugin.

    I noticed a conflict between CFF and Forminator. Some of the messages disappear if I disable the Forminator plugin, but some remain.

    Are these warnings due to the CFF plugin or due to the JS code I entered in the Calculated field?

    Example warning:

    Query Caller Time
    SELECT DISTINCT meta_key
    FROM dfs2_postmeta
    WHERE meta_key NOT BETWEEN ‘_’
    AND ‘_z’
    HAVING meta_key NOT LIKE ‘\\_%’
    ORDER BY meta_key
    LIMIT 30
    meta_form
    post_custom_meta_box
    do_meta_boxes
    require(‘wp-admin/edit-form-advanced.php’)
    0.0540

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @radovand

    Thank you very much for using our plugin.

    The query you are referring to is not part of our plugin, and our plugin should not affect it. The forms in our plugin are not posts, and their structures are stored in the “dfs2_cp_calculated_fields_form_settings” database table. So, the forms do not create entries in the “dfs2_postmeta” table.

    Could you please indicate the messages that disappear after enabling both plugins, forminator, and our plugin?

    Best regards.

    Thread Starter Radovan

    (@radovand)

    Yes. These are the messages:

    Query	Caller	Time
SELECT <code>view_id</code>
FROM dfs2_frmt_form_views
WHERE <code>form_id</code> = 4445
AND <code>page_id</code> = 277
AND <code>ip</code> IS NULL
AND DATE(<code>date_created</code>) = CURDATE()	
Forminator_Form_Views_Model->save_view
Forminator_Render_Form->get_form
Forminator_Render_Form->render
Forminator_CForm_Front->get_html
Forminator_CForm_Front->display
Forminator_Render_Form->render_shortcode
do_shortcode_tag
preg_replace_callback
do_shortcode
ux_col
do_shortcode_tag
preg_replace_callback
do_shortcode
ux_row
do_shortcode_tag
preg_replace_callback
do_shortcode
block_shortcode
do_shortcode_tag
preg_replace_callback
do_shortcode
ux_lightbox
do_shortcode_tag
preg_replace_callback
do_shortcode
flatsome_footer_scripts
do_action('wp_footer')
wp_footer
require_once('/themes/flatsome/footer.php')
load_template
locate_template
get_footer
include('/themes/flatsome/page-blank.php')
require_once('wp-includes/template-loader.php')
require('wp-blog-header.php')
0.2221
SELECT <code>view_id</code>
FROM dfs2_frmt_form_views
WHERE <code>form_id</code> = 4445
AND <code>page_id</code> = 277
AND <code>ip</code> IS NULL
AND DATE(<code>date_created</code>) = CURDATE()	
Forminator_Form_Views_Model->save_view
Forminator_Render_Form->get_form
Forminator_Render_Form->render
Forminator_CForm_Front->get_html
Forminator_CForm_Front->display
Forminator_Render_Form->render_shortcode
do_shortcode_tag
preg_replace_callback
do_shortcode
ux_col
do_shortcode_tag
preg_replace_callback
do_shortcode
ux_row
do_shortcode_tag
preg_replace_callback
do_shortcode
block_shortcode
do_shortcode_tag
preg_replace_callback
do_shortcode
ux_lightbox
do_shortcode_tag
preg_replace_callback
do_shortcode
flatsome_footer_scripts
do_action('wp_footer')
wp_footer
require_once('/themes/flatsome/footer.php')
load_template
locate_template
get_footer
include('/themes/flatsome/page-blank.php')
require_once('wp-includes/template-loader.php')
require('wp-blog-header.php')
0.2019
SELECT <code>view_id</code>
FROM dfs2_frmt_form_views
WHERE <code>form_id</code> = 4445
AND <code>page_id</code> = 277
AND <code>ip</code> IS NULL
AND DATE(<code>date_created</code>) = CURDATE()	
Forminator_Form_Views_Model->save_view
Forminator_Render_Form->get_form
Forminator_Render_Form->render
Forminator_CForm_Front->get_html
Forminator_CForm_Front->display
Forminator_Render_Form->render_shortcode
do_shortcode_tag
preg_replace_callback
do_shortcode
ux_col
do_shortcode_tag
preg_replace_callback
do_shortcode
ux_row
do_shortcode_tag
preg_replace_callback
do_shortcode
block_shortcode
do_shortcode_tag
preg_replace_callback
do_shortcode
ux_lightbox
do_shortcode_tag
preg_replace_callback
do_shortcode
flatsome_footer_scripts
do_action('wp_footer')
wp_footer
require_once('/themes/flatsome/footer.php')
load_template
locate_template
get_footer
include('/themes/flatsome/page-blank.php')
require_once('wp-includes/template-loader.php')
require('wp-blog-header.php')
0.2200
SELECT <code>view_id</code>
FROM dfs2_frmt_form_views
WHERE <code>form_id</code> = 4445
AND <code>page_id</code> = 277
AND <code>ip</code> IS NULL
AND DATE(<code>date_created</code>) = CURDATE()	
Forminator_Form_Views_Model->save_view
Forminator_Render_Form->get_form
Forminator_Render_Form->render
Forminator_CForm_Front->get_html
Forminator_CForm_Front->display
Forminator_Render_Form->render_shortcode
do_shortcode_tag
preg_replace_callback
do_shortcode
ux_col
do_shortcode_tag
preg_replace_callback
do_shortcode
ux_row
do_shortcode_tag
preg_replace_callback
do_shortcode
block_shortcode
do_shortcode_tag
preg_replace_callback
do_shortcode
ux_lightbox
do_shortcode_tag
preg_replace_callback
do_shortcode
flatsome_footer_scripts
do_action('wp_footer')
wp_footer
require_once('/themes/flatsome/footer.php')
load_template
locate_template
get_footer
include('/themes/flatsome/page-blank.php')
require_once('wp-includes/template-loader.php')
require('wp-blog-header.php')
0.2120
SELECT <code>view_id</code>
FROM dfs2_frmt_form_views
WHERE <code>form_id</code> = 4445
AND <code>page_id</code> = 277
AND <code>ip</code> IS NULL
AND DATE(<code>date_created</code>) = CURDATE()	
Forminator_Form_Views_Model->save_view
Forminator_Render_Form->get_form
Forminator_Render_Form->render
Forminator_CForm_Front->get_html
Forminator_CForm_Front->display
Forminator_Render_Form->render_shortcode
do_shortcode_tag
preg_replace_callback
do_shortcode
ux_col
do_shortcode_tag
preg_replace_callback
do_shortcode
ux_row
do_shortcode_tag
preg_replace_callback
do_shortcode
block_shortcode
do_shortcode_tag
preg_replace_callback
do_shortcode
ux_lightbox
do_shortcode_tag
preg_replace_callback
do_shortcode
flatsome_footer_scripts
do_action('wp_footer')
wp_footer
require_once('/themes/flatsome/footer.php')
load_template
locate_template
get_footer
include('/themes/flatsome/page-blank.php')
require_once('wp-includes/template-loader.php')
require('wp-blog-header.php')
0.2695
SELECT <code>view_id</code>
FROM dfs2_frmt_form_views
WHERE <code>form_id</code> = 4445
AND <code>page_id</code> = 277
AND <code>ip</code> IS NULL
AND DATE(<code>date_created</code>) = CURDATE()	
Forminator_Form_Views_Model->save_view
Forminator_Render_Form->get_form
Forminator_Render_Form->render
Forminator_CForm_Front->get_html
Forminator_CForm_Front->display
Forminator_Render_Form->render_shortcode
do_shortcode_tag
preg_replace_callback
do_shortcode
ux_col
do_shortcode_tag
preg_replace_callback
do_shortcode
ux_row
do_shortcode_tag
preg_replace_callback
do_shortcode
block_shortcode
do_shortcode_tag
preg_replace_callback
do_shortcode
ux_lightbox
do_shortcode_tag
preg_replace_callback
do_shortcode
flatsome_footer_scripts
do_action('wp_footer')
wp_footer
require_once('/themes/flatsome/footer.php')
load_template
locate_template
get_footer
include('/themes/flatsome/page-blank.php')
require_once('wp-includes/template-loader.php')
require('wp-blog-header.php')
    Plugin Author codepeople

    (@codepeople)

    Hello @radovand

    I’m sorry, but those messages are related to Forminator and not our plugin. When are these messages generated exactly? Are those messages displayed in our forms’ previews?

    Best regards.

    Thread Starter Radovan

    (@radovand)

    Hello,
    I will look into the warnings in more detail and come back with new information.
    Best regards,
    Radovan D.

    Thread Starter Radovan

    (@radovand)

    Hello,

    It seems that most of the warnings are due to the Forminator plugin.

    There is one warning generated by CFF.
    With the Flasome theme and all plugins disabled except CFF, I get the following warning:

    Querry:
    SELECT ftable.form_name, ptable.*
    FROM dfs2_cp_calculated_fields_form_settings as ftable, dfs2_cp_calculated_fields_form_posts as ptable
    WHERE ptable.formid=ftable.id
    AND ptable.time > CURDATE() – INTERVAL 7 DAY
    ORDER BY ptable.time DESC;

    Caller:
    CPCFF_DASHBOART_WIDGET->dashboard_widget.

    Plugin Author codepeople

    (@codepeople)

    Hello @radovand

    That query loads the last seven days’ submissions in the WordPress Dashboard. You can disable this list by unticking the “Calculated Fields Form Activity” checkbox in the “Screen Options.”.

    Best regards.

    Thread Starter Radovan

    (@radovand)

    It doesn’t change anything if untick the “Calculated Fields Form Activity” checkbox in the “Screen Options.”.

    Plugin Author codepeople

    (@codepeople)

    Hello @radovand

    I will check this behavior and implement an optimized query in the next plugin update.

    Best regards.

    Thread Starter Radovan

    (@radovand)

    Thank you.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘warning messages from the Query Monitor plugin “Slow Queries”.’ is closed to new replies.