Strange Query on Client's Site

I just received an e-mail from a shared hosting provider regarding one of my clients site. I imagine it has something to do with the direct resize plugin, but was wondering if anyone had more insight on the cause.

Thanks,
Jesse

System administration has been tracking higher resource usage on the machine housing your account, and has traced some of these issues to longer running mysql queries related to your account.

Unfortunately, at this time it is not clear exactly what on your site is causing these issues, but we do need you to see if you can reduce the burden these queries cause on the server.

In the shared system, most queries should complete through the server in less than a second. Some of the queries related to your account take a good deal longer than this to complete, and seem to be the source of some latency we are seeing in server response.

Here are examples of such queries:

| 32473 | bluesk5_bluesk5 | localhost | bluesk5_modx | Query | 0 | Copying to tmp table | SELECT DISTINCT sc.id, sc.pagetitle, sc.description, sc.content, sc.introtext, sc.longtitle FROM `bluesk5_modx`.`modx_site_content` sc LEFT JOIN `bluesk5_modx`.`modx_site_tmplvar_contentvalues` stc ON sc.id = stc.contentid WHERE ((sc.pagetitle LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.description LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.content LIKE ’%food%’ OR sc.introtext LIKE ’%food%’ OR stc.value LIKE ’%food%’) OR (sc.pagetitle LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.description LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.content LIKE ’%assets%’ OR sc.introtext LIKE ’%assets%’ OR stc.value LIKE ’%assets%’) OR (sc.pagetitle LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.description LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.content LIKE ’%assets%’ OR sc.introtext LIKE ’%assets%’ OR stc.value LIKE ’%assets%’) OR (sc.pagetitle LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.description LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.content LIKE ’%assets%’ OR sc.introtext LIKE ’%assets%’ OR stc.value LIKE ’%assets%’) OR (sc.pagetitle LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.description LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.content LIKE ’%assets%’ OR sc.introtext LIKE ’%assets%’ OR stc.value LIKE ’%assets%’) OR (sc.pagetitle LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.description LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.content LIKE ’%assets%’ OR sc.introtext LIKE ’%assets%’ OR stc.value LIKE ’%assets%’) OR (sc.pagetitle LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.description LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.content LIKE ’%assets%’ OR sc.introtext LIKE ’%assets%’ OR stc.value LIKE ’%assets%’) OR (sc.pagetitle LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.description LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.content LIKE ’%assets%’ OR sc.introtext LIKE ’%assets%’ OR stc.value LIKE ’%assets%’) OR (sc.pagetitle LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.description LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.content LIKE ’%assets%’ OR sc.introtext LIKE ’%assets%’ OR stc.value LIKE ’%assets%’) OR (sc.pagetitle LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.description LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.content LIKE ’%assets%’ OR sc.introtext LIKE ’%assets%’ OR stc.value LIKE ’%assets%’) OR (sc.pagetitle LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.description LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.content LIKE ’%assets%’ OR sc.introtext LIKE ’%assets%’ OR stc.value LIKE ’%assets%’) OR (sc.pagetitle LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.description LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.content LIKE ’%assets%’ OR sc.introtext LIKE ’%assets%’ OR stc.value LIKE ’%assets%’) OR (sc.pagetitle LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.description LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.content LIKE ’%plugins%’ OR sc.introtext LIKE ’%plugins%’ OR stc.value LIKE ’%plugins%’) OR (sc.pagetitle LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.description LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.content LIKE ’%directresize%’ OR sc.introtext LIKE ’%directresize%’ OR stc.value LIKE ’%directresize%’) OR (sc.pagetitle LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.description LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.content LIKE ’%highslide%’ OR sc.introtext LIKE ’%highslide%’ OR stc.value LIKE ’%highslide%’) OR (sc.pagetitle LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.description LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.content LIKE ’%assets%’ OR sc.introtext LIKE ’%assets%’ OR stc.value LIKE ’%assets%’) OR (sc.pagetitle LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.description LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.content LIKE ’%assets%’ OR sc.introtext LIKE ’%assets%’ OR stc.value LIKE ’%assets%’) OR (sc.pagetitle LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.description LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.content LIKE ’%plugins%’ OR sc.introtext LIKE ’%plugins%’ OR stc.value LIKE ’%plugins%’) OR (sc.pagetitle LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.description LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.content LIKE ’%directresize%’ OR sc.introtext LIKE ’%directresize%’ OR stc.value LIKE ’%directresize%’) OR (sc.pagetitle LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.description LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.content LIKE ’%highslide%’ OR sc.introtext LIKE ’%highslide%’ OR stc.value LIKE ’%highslide%’) OR (sc.pagetitle LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.description LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.content LIKE ’%assets%’ OR sc.introtext LIKE ’%assets%’ OR stc.value LIKE ’%assets%’) OR (sc.pagetitle LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.description LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.content LIKE ’%assets%’ OR sc.introtext LIKE ’%assets%’ OR stc.value LIKE ’%assets%’) OR (sc.pagetitle LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.description LIKE ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’ OR sc.content LIKE ’%jquery-1.2.1.min.js.gz%’ OR sc.introtext LIKE ’%jquery-1.2.1.min.js.gz%’ OR stc.value LIKE ’%jquery-1.2.1.min.js.gz%’)) AND sc.privateweb = 0 AND sc.published = 1 AND sc.searchable=1 AND sc.deleted=0 |

Well, this query sure looks disastrous...



assets, anyone?

Try to completely delete the directResize stuff, and reinstall again. Check if there’s a newer version available.

I think the query is being generated by Ditto, but unsure why it is coming up with that.

Which version of Ditto are you running? Try updating to the latest if it’s not running that.

It is running Ditto 2.1. I reinstalled a fresh copy in case something was corrupted on its original install, but I would imagine I would have run into other issues if that was the case.

Which snippet use AjaxSearch ? Because I recognize AS query but with strange searchterms.

As I undertstand a search as be done with the search Term = ’%food assets assets assets assets assets assets assets assets assets assets assets plugins directresize highslide assets assets plugins directresize highslide assets assets jquery-1.2.1.min.js.gz%’

A bit strange. But as I am changed the sql query this snippet could be now deprecated

No finally, It’s not an AjaxSearch query.
I have checked the form of an AS query and hereafter is the first terms selected:

It is a bit different of :


So I don’t know from which snippet comes this query.

From what I can tell it looks like a query produced by Ditto, but again I am unsure how it is generating this query.

I would check for any filtering in Ditto (if that is the culprit). It seems to be mixing up a filter for "food" with the location for some assets. Could this be a corrupted cache file? Have you tried clearing the cache?

I have not cleared the cache yet. I will try that and check filters, although I don’t think I have any set, and see if I hear back from the host.