1 - Query: SELECT COUNT(1) FROM information_schema.tables WHERE table_schema='beato-uat' AND table_name='wp_bookingpress_settings'
Time: 1.063 ms
2 - Query: SELECT COUNT(1) FROM information_schema.tables WHERE table_schema='beato-uat' AND table_name='wp_bookingpress_customize_settings'
Time: 0.572 ms
3 - Query: SELECT name, val FROM wp_wfconfig WHERE autoload = 'yes'
Time: 0.825 ms
4 - Query: SELECT `name`, `value` FROM `wp_wfls_settings` WHERE `autoload` = 'yes'
Time: 0.276 ms
5 - Query: SELECT name, val, autoload FROM wp_wfconfig WHERE name = 'detectProxyRecommendation'
Time: 0.212 ms
6 - Query: SHOW FULL COLUMNS FROM `wp_wfblocks7`
Time: 1.544 ms
7 - Query: SELECT * FROM `wp_wfblocks7` WHERE `IP` = '\0\0\0\0\0\0\0\0\0\0ÿÿ4§µ' AND `type` = 7 AND (`expiration` = 0 OR `expiration` > UNIX_TIMESTAMP())
Time: 0.282 ms
8 - Query: SELECT name, val, autoload FROM wp_wfconfig WHERE name = 'wordfenceCentralConnected'
Time: 0.210 ms
9 - Query: SHOW TABLES LIKE 'wp\\_affiliate\\_wp\\_connections'
Time: 1.758 ms
12 - Query: DESC wp_affiliate_wp_connections
Time: 1.049 ms
13 - Query: SHOW TABLES LIKE 'wp\\_affiliate\\_wp\\_groups'
Time: 1.346 ms
14 - Query: SELECT DATA_TYPEFROM INFORMATION_SCHEMA.COLUMNSWHERE `table_name` = 'wp_affiliate_wp_groups'AND `column_name` = 'meta'AND `table_schema` = 'beato-uat'
Time: 0.659 ms
15 - Query: SHOW TABLES LIKE 'wp\\_affiliate\\_wp\\_affiliates'
Time: 1.034 ms
17 - Query: DESC wp_affiliate_wp_affiliates
Time: 0.896 ms
20 - Query: SHOW TABLES LIKE 'wp\\_affiliate\\_wp\\_creatives'
Time: 0.985 ms
22 - Query: DESC wp_affiliate_wp_creatives
Time: 0.828 ms
27 - Query: DESC wp_affiliate_wp_groups
Time: 0.702 ms
30 - Query: show tables like 'wp_wdr_rules'
Time: 1.352 ms
31 - Query: SELECT * FROM wp_wdr_rules WHERE enabled = 1 AND deleted = 0 AND (date_from <= 1712110317 OR date_from IS NULL) AND (date_to >= 1712110317 OR date_to IS NULL) AND (usage_limits > used_limits OR used_limits IS NULL OR usage_limits = 0) ORDER BY priority ASC
Time: 0.479 ms
32 - Query: SELECT name, val, autoload FROM wp_wfconfig WHERE name = 'needsGeoIPSync'
Time: 0.486 ms
34 - Query: SELECT MAX(attackLogTime) FROM wp_wfhits
Time: 0.141 ms
35 - Query: SELECT *, CASE WHEN `type` = 3 THEN 0WHEN `type` = 4 THEN 1WHEN `type` = 7 THEN 2WHEN `type` = 6 THEN 3WHEN `type` = 5 THEN 4WHEN `type` = 9 THEN 5WHEN `type` = 8 THEN 6WHEN `type` = 2 THEN 7WHEN `type` = 1 THEN 8ELSE 9999END AS `typeSort`, CASE WHEN `type` = 3 THEN `parameters`WHEN `type` = 4 THEN `parameters`WHEN `type` = 1 THEN `IP`WHEN `type` = 9 THEN `IP`WHEN `type` = 5 THEN `IP`WHEN `type` = 6 THEN `IP`WHEN `type` = 7 THEN `IP`WHEN `type` = 2 THEN `IP`WHEN `type` = 8 THEN `IP`ELSE 9999END AS `detailSort` FROM `wp_wfblocks7` WHERE `type` IN (4) AND (`expiration` = 0 OR `expiration` > UNIX_TIMESTAMP()) ORDER BY `typeSort` ASC, `id` DESC
Time: 0.496 ms
36 - Query: SELECT *, CASE WHEN `type` = 3 THEN 0WHEN `type` = 4 THEN 1WHEN `type` = 7 THEN 2WHEN `type` = 6 THEN 3WHEN `type` = 5 THEN 4WHEN `type` = 9 THEN 5WHEN `type` = 8 THEN 6WHEN `type` = 2 THEN 7WHEN `type` = 1 THEN 8ELSE 9999END AS `typeSort`, CASE WHEN `type` = 3 THEN `parameters`WHEN `type` = 4 THEN `parameters`WHEN `type` = 1 THEN `IP`WHEN `type` = 9 THEN `IP`WHEN `type` = 5 THEN `IP`WHEN `type` = 6 THEN `IP`WHEN `type` = 7 THEN `IP`WHEN `type` = 2 THEN `IP`WHEN `type` = 8 THEN `IP`ELSE 9999END AS `detailSort` FROM `wp_wfblocks7` WHERE `type` IN (3) AND (`expiration` = 0 OR `expiration` > UNIX_TIMESTAMP()) ORDER BY `typeSort` ASC, `id` DESC
Time: 0.249 ms
37 - Query: SELECT * FROM `wp_wfblocks7` WHERE `type` IN (1, 8, 9, 2, 5, 6) AND `IP` = '\0\0\0\0\0\0\0\0\0\0ÿÿ4§µ' AND (`expiration` = 0 OR `expiration` > UNIX_TIMESTAMP()) ORDER BY `blockedTime` DESC LIMIT 1
Time: 0.288 ms
38 - Query: SELECT COUNT(*)FROM wp_optionsWHERE option_name LIKE 'elementor\\_1\\_custom\\_task\\_manger\\_batch\\_%'
Time: 0.755 ms
39 - Query: SELECT SQL_CALC_FOUND_ROWS wp_posts.IDFROM wp_posts 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 1=1 AND ( wp_postmeta.meta_key = '_elementor_template_type' AND ( ( mt1.meta_key = '_elementor_template_type' AND mt1.meta_value = 'popup' ) )) AND wp_posts.post_type = 'elementor_library' AND ((wp_posts.post_status <> 'trash' AND wp_posts.post_status <> 'auto-draft'))GROUP BY wp_posts.IDORDER BY wp_posts.post_date DESCLIMIT 0, 1
Time: 1.817 ms
40 - Query: SELECT wp_posts.IDFROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'elementor_snippet' AND ((wp_posts.post_status = 'publish'))ORDER BY wp_posts.post_date DESCLIMIT 0, 1
Time: 0.609 ms
41 - Query: select * from wp_addonlibrary_addons as addons where addons.addontype in('elementor','bg_addon') and addons.is_active=1
Time: 1.071 ms
42 - Query: SELECT a.hook FROM wp_actionscheduler_actions aJOIN wp_actionscheduler_groups g ON g.group_id = a.group_idWHERE g.slug = 'easy_wp_smtp' AND a.status IN ('in-progress', 'pending')
Time: 0.824 ms
43 - Query: SELECT autoload FROM wp_options WHERE option_name = 'rscheckcronsafter'
Time: 0.472 ms
44 - Query: SELECT a.action_id FROM wp_actionscheduler_actions a LEFT JOIN wp_actionscheduler_groups g ON g.group_id=a.group_id WHERE 1=1 AND g.slug='affiliatewp' AND a.hook='affwp_daily_scheduled_events' AND a.args='[]' AND a.status IN ('in-progress', 'pending') LIMIT 0, 1
Time: 0.790 ms
45 - Query: SELECT a.action_id FROM wp_actionscheduler_actions a LEFT JOIN wp_actionscheduler_groups g ON g.group_id=a.group_id WHERE 1=1 AND g.slug='affiliatewp' AND a.hook='affwp_monthly_email_summaries' AND a.args='[]' AND a.status IN ('in-progress', 'pending') LIMIT 0, 1
Time: 0.308 ms
46 - Query: SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook='affwp_monthly_affiliate_email_summaries' AND a.status IN ('pending') LIMIT 0, 1000
Time: 0.212 ms
47 - Query: SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook='affwp_send_scheduled_summary' AND a.status IN ('pending') LIMIT 0, 1000
Time: 0.184 ms
48 - Query: SELECT a.action_id FROM wp_actionscheduler_actions a LEFT JOIN wp_actionscheduler_groups g ON g.group_id=a.group_id WHERE 1=1 AND g.slug='affiliatewp' AND a.hook='affwp_scheduled_creative_status_check' AND a.args='[]' AND a.status IN ('in-progress', 'pending') LIMIT 0, 1
Time: 0.397 ms
49 - Query: SELECT wp_posts.IDFROM wp_posts WHERE 1=1 AND ((wp_posts.post_type = 'patterns_ai_data' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'ywgc-disabled' OR wp_posts.post_status = 'ywgc-dismissed' OR wp_posts.post_status = 'ywgc-code-not-valid' OR wp_posts.post_status = 'acf-disabled')))ORDER BY wp_posts.post_date DESCLIMIT 0, 1
Time: 0.656 ms
50 - Query: SHOW FULL COLUMNS FROM `wp_wflivetraffichuman`
Time: 1.800 ms
51 - Query: SELECT COUNT(*) FROM wp_wflivetraffichuman WHERE IP = '\0\0\0\0\0\0\0\0\0\0ÿÿ4§µ' AND identifier = '¨ðêä¶zÃiS¼ïè§Àc\'¡<ú\n$~Ó2únçï\r' AND expiration >= UNIX_TIMESTAMP()
Time: 0.211 ms
52 - Query: SELECT SQL_CALC_FOUND_ROWS wp_posts.IDFROM wp_posts 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_postmeta.meta_key = '_wp_page_template' AND wp_postmeta.meta_value = 'blog.php' ) AND ( mt1.meta_key = 'joly_options_post_type' AND mt1.meta_value = 'post' ) AND ( mt2.meta_key = 'joly_options_parent_cat' AND mt2.meta_value < '1' )) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))GROUP BY wp_posts.IDORDER BY wp_posts.post_date ASCLIMIT 0, 1
Time: 0.835 ms
53 - Query: SELECT FOUND_ROWS()
Time: 0.110 ms
54 - Query: SELECT SQL_CALC_FOUND_ROWS wp_posts.IDFROM wp_posts 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_postmeta.meta_key = '_wp_page_template' AND wp_postmeta.meta_value = 'blog.php' ) AND ( mt1.meta_key = 'joly_options_post_type' AND mt1.meta_value = 'cpt_portfolio' ) AND ( mt2.meta_key = 'joly_options_parent_cat' AND mt2.meta_value < '1' )) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))GROUP BY wp_posts.IDORDER BY wp_posts.post_date ASCLIMIT 0, 1
Time: 0.836 ms
55 - Query: SELECT SQL_CALC_FOUND_ROWS wp_posts.IDFROM wp_posts 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_postmeta.meta_key = '_wp_page_template' AND wp_postmeta.meta_value = 'blog.php' ) AND ( mt1.meta_key = 'joly_options_post_type' AND mt1.meta_value = 'cpt_services' ) AND ( mt2.meta_key = 'joly_options_parent_cat' AND mt2.meta_value < '1' )) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))GROUP BY wp_posts.IDORDER BY wp_posts.post_date ASCLIMIT 0, 1
Time: 0.563 ms
56 - Query: SELECT SQL_CALC_FOUND_ROWS wp_posts.IDFROM wp_posts 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_postmeta.meta_key = '_wp_page_template' AND wp_postmeta.meta_value = 'blog.php' ) AND ( mt1.meta_key = 'joly_options_post_type' AND mt1.meta_value = 'cpt_team' ) AND ( mt2.meta_key = 'joly_options_parent_cat' AND mt2.meta_value < '1' )) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))GROUP BY wp_posts.IDORDER BY wp_posts.post_date ASCLIMIT 0, 1
Time: 0.744 ms
57 - Query: SELECT ID, post_name, post_parent, post_typeFROM wp_postsWHERE post_name IN ('8-best-places-in-singapore-to-have-valentines-day-dinner')AND post_type IN ('page','attachment')
Time: 0.594 ms
58 - Query: SELECT wp_posts.IDFROM wp_posts WHERE 1=1 AND wp_posts.post_name = '8-best-places-in-singapore-to-have-valentines-day-dinner' AND wp_posts.post_type IN ('post', 'page', 'e-landing-page')ORDER BY wp_posts.post_date DESC
Time: 0.456 ms
59 - Query: SELECT DISTINCT t.term_id, tr.object_idFROM 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_idWHERE tt.taxonomy IN ('category', 'post_tag', 'post_format', 'elementor_library_type', 'page-cat') AND tr.object_id IN (24370)ORDER BY t.name ASC
Time: 0.675 ms
60 - Query: SELECT option_value FROM wp_options WHERE option_name = 'sumomemberships_restrict_members_with_particular_plan_no_of_rules_added24370' LIMIT 1
Time: 0.381 ms
61 - Query: SELECT option_value FROM wp_options WHERE option_name = 'sumomemberships_restrict_users_without_particular_plan_no_of_rules_added24370' LIMIT 1
Time: 0.231 ms
62 - Query: SELECT wp_posts.IDFROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'sumomembers'ORDER BY wp_posts.post_date DESC
Time: 0.502 ms
64 - Query: SELECT meta_id FROM wp_postmeta WHERE meta_key = '_eael_post_view_count' AND post_id = 24370
Time: 0.789 ms
65 - Query: SHOW FULL COLUMNS FROM `wp_postmeta`
Time: 1.542 ms
66 - Query: UPDATE `wp_postmeta` SET `meta_value` = '3' WHERE `post_id` = 24370 AND `meta_key` = '_eael_post_view_count'
Time: 0.451 ms
67 - Query: SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (24370) ORDER BY meta_id ASC
Time: 0.567 ms
69 - Query: SELECT * FROM `wp_yoast_indexable` WHERE `object_id` = '24370' AND `object_type` = 'post' LIMIT 1
Time: 0.759 ms
70 - Query: SELECT wp_posts.IDFROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'sumomemberships_userid' AND wp_postmeta.meta_value IN ('0') )) AND wp_posts.post_type = 'sumomembers' AND ((wp_posts.post_status = 'publish'))GROUP BY wp_posts.IDORDER BY wp_posts.post_date DESCLIMIT 0, 5
Time: 0.910 ms
72 - Query: SELECT * FROM `wp_yoast_indexable` WHERE `object_id` = '372' AND `object_type` = 'post' LIMIT 1
Time: 0.768 ms
73 - Query: SELECT `ancestor_id` FROM `wp_yoast_indexable_hierarchy` WHERE `indexable_id` = '539' ORDER BY `depth` DESC
Time: 0.261 ms
74 - Query: SELECT * FROM wp_rspointexpiry WHERE expirydate < 1712081518 and expirydate NOT IN(999999999999) and expiredpoints IN(0) and userid = 0
Time: 0.687 ms
75 - Query: SELECT * FROM wp_rspointexpiry WHERE earnedpoints=usedpoints and expiredpoints IN(0) and userid = 0
Time: 0.198 ms
76 - Query: SELECT * FROM wp_rspointexpiry WHERE earnedpoints=(usedpoints+expiredpoints) and expiredpoints NOT IN(0) and userid = 0
Time: 0.207 ms
77 - Query: SELECT meta_id FROM wp_postmeta WHERE meta_key = 'trx_addons_post_views_count' AND post_id = 24370
Time: 0.306 ms
78 - Query: UPDATE `wp_postmeta` SET `meta_value` = '3' WHERE `post_id` = 24370 AND `meta_key` = 'trx_addons_post_views_count'
Time: 0.336 ms
79 - Query: SELECT wp_posts.IDFROM wp_posts 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 1=1 AND ( wp_postmeta.meta_key = '_elementor_priority' AND ( ( mt1.meta_key = '_elementor_location' AND mt1.meta_value = 'elementor_head' ) )) AND wp_posts.post_type = 'elementor_snippet' AND ((wp_posts.post_status = 'publish'))GROUP BY wp_posts.IDORDER BY wp_postmeta.meta_value+0 ASC
Time: 1.072 ms
81 - Query: SELECT wp_posts.IDFROM wp_posts 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 1=1 AND ( wp_postmeta.meta_key = '_elementor_priority' AND ( ( mt1.meta_key = '_elementor_location' AND mt1.meta_value = 'elementor_body_start' ) )) AND wp_posts.post_type = 'elementor_snippet' AND ((wp_posts.post_status = 'publish'))GROUP BY wp_posts.IDORDER BY wp_postmeta.meta_value+0 ASC
Time: 0.659 ms
82 - Query: SELECT wp_posts.IDFROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (175)) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish'))GROUP BY wp_posts.IDORDER BY wp_posts.menu_order ASC
Time: 0.916 ms
83 - Query: SELECT DISTINCT t.term_idFROM 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_idWHERE tt.taxonomy IN ('category') AND tr.object_id IN (24370)ORDER BY t.name ASC
Time: 0.652 ms
108 - Query: SELECT p.ID FROM wp_posts AS p WHERE p.post_date < '2023-02-13 10:19:03' AND p.post_type = 'post' AND p.post_status = 'publish' ORDER BY p.post_date DESC LIMIT 1
Time: 0.377 ms
109 - Query: SELECT p.ID FROM wp_posts AS p WHERE p.post_date > '2023-02-13 10:19:03' AND p.post_type = 'post' AND p.post_status = 'publish' ORDER BY p.post_date ASC LIMIT 1
Time: 0.232 ms
110 - Query: SELECT SQL_CALC_FOUND_ROWS wp_comments.comment_IDFROM wp_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 24370 AND comment_parent = 0 AND comment_type != 'order_note' AND comment_type != 'webhook_delivery' ORDER BY wp_comments.comment_date_gmt ASC, wp_comments.comment_ID ASC
Time: 0.582 ms
111 - Query: SELECT SQL_CALC_FOUND_ROWS wp_posts.IDFROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)WHERE 1=1 AND wp_posts.ID NOT IN (24370) AND ( wp_term_relationships.term_taxonomy_id IN (557)) AND wp_posts.post_type = 'post' AND ((wp_posts.post_status = 'publish'))GROUP BY wp_posts.IDORDER BY RAND()LIMIT 0, 2
Time: 0.990 ms
113 - Query: SELECT * FROM wp_posts WHERE post_parent = 24370 AND post_name LIKE '24370-autosave%' AND post_modified_gmt > '2023-02-13 10:19:03' AND post_type = 'revision'
Time: 0.604 ms
114 - Query: SELECT wp_posts.IDFROM wp_posts 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 1=1 AND ( wp_postmeta.meta_key = '_elementor_priority' AND ( ( mt1.meta_key = '_elementor_location' AND mt1.meta_value = 'elementor_body_end' ) )) AND wp_posts.post_type = 'elementor_snippet' AND ((wp_posts.post_status = 'publish'))GROUP BY wp_posts.IDORDER BY wp_postmeta.meta_value+0 ASC
Time: 0.940 ms
Total Queries: 114
Total Time: 48.570 ms