Long Database Query in debug mode
-
bonaventure
-
Topic Author
-
Offline
-
Junior Member
-
Less
More
-
Posts: 33
-
Thank you received: 0
-
-
9 years 7 months ago #2936
by bonaventure
I'm getting a very long query from ReDJ when I have debug mode turned on. Is this normal? The redirect seems to work perfectly, but this query seems very long.
SELECT *
FROM ( SELECT *
FROM prefix_redj_redirects
WHERE ( ( ('/horses/29-aa-aa' REGEXP BINARY fromurl)>0
AND (case_sensitive<>0)
AND (decode_url<>0)
AND (request_only<>0) ) OR ( ('/horses/29-aa-aa' REGEXP BINARY fromurl)>0
AND (case_sensitive<>0)
AND (decode_url=0)
AND (request_only<>0) ) OR ( ('http://www.mysite.com/horses/29-aa-aa' REGEXP BINARY fromurl)>0
AND (case_sensitive<>0)
AND (decode_url<>0)
AND (request_only=0) ) OR ( ('http://www.mysite.com/horses/29-aa-aa' REGEXP BINARY fromurl)>0
AND (case_sensitive<>0)
AND (decode_url=0)
AND (request_only=0) ) OR ( ('/horses/29-aa-aa' REGEXP fromurl)>0
AND (case_sensitive=0)
AND (decode_url<>0)
AND (request_only<>0) ) OR ( ('/horses/29-aa-aa' REGEXP fromurl)>0
AND (case_sensitive=0)
AND (decode_url=0)
AND (request_only<>0) ) OR ( ('http://www.mysite.com/horses/29-aa-aa' REGEXP fromurl)>0
AND (case_sensitive=0)
AND (decode_url<>0)
AND (request_only=0) ) OR ( ('http://www.mysite.com/horses/29-aa-aa' REGEXP fromurl)>0
AND (case_sensitive=0)
AND (decode_url=0)
AND (request_only=0) ) )
AND published=1
ORDER BY ordering ) AS A
WHERE A.skip='' OR ( ('http://www.mysite.com/horses/29-aa-aa' REGEXP BINARY A.skip)=0
AND (case_sensitive<>0)
AND (decode_url<>0) ) OR ( ('http://www.mysite.com/horses/29-aa-aa' REGEXP BINARY A.skip)=0
AND (case_sensitive<>0)
AND (decode_url=0) ) OR ( ('http://www.mysite.com/horses/29-aa-aa' REGEXP A.skip)=0
AND (case_sensitive=0)
AND (decode_url<>0) ) OR ( ('http://www.mysite.com/horses/29-aa-aa' REGEXP A.skip)=0
AND (case_sensitive=0)
AND (decode_url=0) )
Please Log in or Create an account to join the conversation.
Less
More
-
Posts: 3194
-
Thank you received: 441
-
-
Time to create page: 0.113 seconds
