2019-06-21 16:39:45 GMT+0000 (DEBUG): Slow query (32.57 seconds): /* ------------------ /home/middletonj/public_html/wp-content/plugins/404-solution/includes/sql/getRedirectsForView.sql BEGIN ----- */

select
wp_abj404_redirects.id,
wp_abj404_redirects.url,
wp_abj404_redirects.status,
(CASE
when wp_abj404_redirects.status = 1 then 'Man'
when wp_abj404_redirects.status = 2 then 'Auto'
when wp_abj404_redirects.status = 6 then 'RegEx'
else 'Unknown'
end) as status_for_view,
wp_abj404_redirects.type,
(CASE
when wp_abj404_redirects.type = 4 then 'External'
when wp_abj404_redirects.type = 2 then 'Category'
when wp_abj404_redirects.type = 3 then 'Tag'
when wp_abj404_redirects.type = 5 then 'Home Page'
when wp_abj404_redirects.type = 1 then
CONCAT(UCASE(LEFT(wp_posts.post_type, 1)), LCASE(SUBSTRING(wp_posts.post_type, 2)))
else 'Unknown'
end) as type_for_view,
wp_abj404_redirects.final_dest,
(case
when wp_abj404_redirects.type = 4 then wp_abj404_redirects.final_dest
when wp_abj404_redirects.type = 1 then wp_posts.post_title
when wp_abj404_redirects.type = 2 then terms.name
when wp_abj404_redirects.type = 3 then terms.name
when wp_abj404_redirects.type = 5 then wp_options.option_value
else '? Dest Type'
end) as dest_for_view,

wp_abj404_redirects.code,
wp_abj404_redirects.timestamp,
wp_posts.id as wp_post_id,

logstable.logshits as logshits,
logstable.logsid,
logstable.last_used,


wp_posts.post_type as wp_post_type

from msyyx_abj404_redirects wp_abj404_redirects

LEFT OUTER JOIN msyyx_posts wp_posts
on wp_abj404_redirects.final_dest = wp_posts.id

LEFT OUTER JOIN msyyx_abj404_logs_hits logstable
on wp_abj404_redirects.url = logstable.requested_url



left outer join msyyx_terms terms
on wp_abj404_redirects.final_dest = terms.term_id

left outer join msyyx_options wp_options
on wp_options.option_name = 'blogname'

where 1 and (status in (1, 2, 6)) and disabled = 0

/* no redirects fiter text found
and replace(lower(CONCAT(wp_abj404_redirects.url, '////',
(CASE
when wp_abj404_redirects.status = 1 then 'Man'
when wp_abj404_redirects.status = 2 then 'Auto'
when wp_abj404_redirects.status = 6 then 'RegEx'
else 'Unknown'
end), '////',
(CASE
when wp_abj404_redirects.type = 4 then 'External'
when wp_abj404_redirects.type = 2 then 'Category'
when wp_abj404_redirects.type = 3 then 'Tag'
when wp_abj404_redirects.type = 5 then 'Home Page'
when wp_abj404_redirects.type = 1 then
CONCAT(UCASE(LEFT(wp_posts.post_type, 1)), LCASE(SUBSTRING(wp_posts.post_type, 2)))
else 'Unknown'
end), '////',
(case
when wp_abj404_redirects.type = 4 then wp_abj404_redirects.final_dest
when wp_abj404_redirects.type = 1 then wp_posts.post_title
when wp_abj404_redirects.type = 2 then terms.name
when wp_abj404_redirects.type = 3 then terms.name
when wp_abj404_redirects.type = 5 then wp_options.option_value
else '? Dest Type'
end), '////',
wp_abj404_redirects.code)
), ' ', '')
like replace(lower('%%'), ' ', '')
/* */

/* no captured 404s filter text found
and replace(lower(wp_abj404_redirects.url), ' ', '') like replace(lower('%%'), ' ', '')
/* */

order by logshits ASC

limit 0, 500

/* ------------------ /home/middletonj/public_html/wp-content/plugins/404-solution/includes/sql/getRedirectsForView.sql END ----- */

2019-06-21 16:39:58 GMT+0000 (DEBUG): Processing request for action: (none)
2019-06-21 16:39:58 GMT+0000 (DEBUG): Displaying sub page: abj404_options
2019-06-21 16:40:11 GMT+0000 (DEBUG): Processing request for action: (none)
2019-06-21 16:40:11 GMT+0000 (DEBUG): Displaying sub page: abj404_debugfile