Find hereafter the 10 lasts ajaxSearch requests executed with the 1.8.3 demo site.
AjaxSearch logs
| Searchstring | Nb results | Results | Comment | As call | As select | Date | Ip |
|---|---|---|---|---|---|---|---|
| Peterhof | 1 | 104 | [!AjaxSearch? &debug=`-1` &language=`english-utf8` &whereSearch=`content:null|maxigallery|jot` &minChars=`3` &documents=`104,155` &tplLayout=`optionMultipleList` &searchWordList=`galWordList` &tvPhx=`` &asLog=`2:1:10` &ajaxMax=`10` &tplAjaxResult=`withMaxigalleryJotAjaxResult`!] | SELECT sc.id, sc.pagetitle, sc.longtitle, sc.description, sc.alias, sc.introtext, sc.template, sc.menutitle, sc.content, sc.publishedon, GROUP_CONCAT( DISTINCT CAST(ngal.id AS CHAR) SEPARATOR "," ) AS gal_id, GROUP_CONCAT( DISTINCT CAST(njot.id AS CHAR) SEPARATOR "," ) AS jot_id, GROUP_CONCAT( DISTINCT ngal.title SEPARATOR ", " ) AS gal_title, GROUP_CONCAT( DISTINCT ngal.descr SEPARATOR ", " ) AS gal_descr, GROUP_CONCAT( DISTINCT ngal.filename SEPARATOR ", " ) AS gal_filename, GROUP_CONCAT( DISTINCT njot.content SEPARATOR ", " ) AS jot_content FROM `mod2_site_content` sc LEFT JOIN( SELECT DISTINCT gal.id, gal.title, gal.descr, gal.filename, gal.gal_id FROM `mod2_maxigallery` gal WHERE (((gal.hide=0)) AND ((gal.title LIKE '%Peterhof%') OR (gal.descr LIKE '%Peterhof%'))) ) AS ngal ON sc.id = ngal.gal_id LEFT JOIN( SELECT DISTINCT jot.id, jot.content, jot.uparent FROM `mod2_jot_content` jot WHERE (((jot.published=1)) AND ((jot.content LIKE '%Peterhof%'))) ) AS njot ON sc.id = njot.uparent WHERE ((sc.id IN (104,155)) AND (sc.published=1) AND (sc.searchable=1) AND (sc.deleted=0) AND (sc.type='document') AND (sc.privateweb=0)) GROUP BY sc.id HAVING (((gal_title LIKE '%Peterhof%') OR (gal_descr LIKE '%Peterhof%') OR (jot_content LIKE '%Peterhof%'))) ORDER BY sc.publishedon,sc.pagetitle | 2010-09-07 21:57:40 | 90.221.20.180 | |
| test | 4 | 64 308 67 71 | [!AjaxSearch? &debug=`3` &language=`english-utf8` &minChars=`3` &extract=`99:content` &parents=`61` &tplLayout=`optionSearch` &clearDefault=`1` &asLog=`2:1:10` &ajaxMax=`4` &showMoreResults=`1` &moreResultsPage=`272`!] | SELECT sc.id, sc.pagetitle, sc.longtitle, sc.description, sc.alias, sc.introtext, sc.menutitle, sc.content, sc.publishedon, GROUP_CONCAT( DISTINCT CAST(ntv.id AS CHAR) SEPARATOR "," ) AS tv_id, GROUP_CONCAT( DISTINCT ntv.value SEPARATOR ", " ) AS tv_value FROM `mod2_site_content` sc LEFT JOIN( SELECT DISTINCT tv.id, tv.value, tv.contentid FROM `mod2_site_tmplvar_contentvalues` tv WHERE (((tv.value LIKE '%test%'))) ) AS ntv ON sc.id = ntv.contentid WHERE ((sc.id IN (63,308,64,65,66,67,68,69,70,71,72,73,97)) AND (sc.published=1) AND (sc.searchable=1) AND (sc.deleted=0) AND (sc.type='document') AND (sc.privateweb=0)) GROUP BY sc.id HAVING (((sc.pagetitle LIKE '%test%') OR (sc.longtitle LIKE '%test%') OR (sc.description LIKE '%test%') OR (sc.alias LIKE '%test%') OR (sc.introtext LIKE '%test%') OR (sc.menutitle LIKE '%test%') OR (sc.content LIKE '%test%') OR (tv_value LIKE '%test%'))) ORDER BY sc.publishedon,sc.pagetitle | 2010-09-07 12:01:18 | 83.31.254.110 | |
| ssss | 0 | [!AjaxSearch? &debug=`3` &language=`english-utf8` &minChars=`3` &extract=`99:content` &parents=`61` &tplLayout=`optionSearch` &clearDefault=`1` &asLog=`2:1:10` &ajaxMax=`4` &showMoreResults=`1` &moreResultsPage=`272`!] | SELECT sc.id, sc.pagetitle, sc.longtitle, sc.description, sc.alias, sc.introtext, sc.menutitle, sc.content, sc.publishedon, GROUP_CONCAT( DISTINCT CAST(ntv.id AS CHAR) SEPARATOR "," ) AS tv_id, GROUP_CONCAT( DISTINCT ntv.value SEPARATOR ", " ) AS tv_value FROM `mod2_site_content` sc LEFT JOIN( SELECT DISTINCT tv.id, tv.value, tv.contentid FROM `mod2_site_tmplvar_contentvalues` tv WHERE (((tv.value LIKE '%ssss%'))) ) AS ntv ON sc.id = ntv.contentid WHERE ((sc.id IN (63,308,64,65,66,67,68,69,70,71,72,73,97)) AND (sc.published=1) AND (sc.searchable=1) AND (sc.deleted=0) AND (sc.type='document') AND (sc.privateweb=0)) GROUP BY sc.id HAVING (((sc.pagetitle LIKE '%ssss%') OR (sc.longtitle LIKE '%ssss%') OR (sc.description LIKE '%ssss%') OR (sc.alias LIKE '%ssss%') OR (sc.introtext LIKE '%ssss%') OR (sc.menutitle LIKE '%ssss%') OR (sc.content LIKE '%ssss%') OR (tv_value LIKE '%ssss%'))) ORDER BY sc.publishedon,sc.pagetitle | 2010-09-07 12:01:02 | 83.31.254.110 | ||
| peter | 1 | 104 | [!AjaxSearch? &debug=`1` &language=`english-utf8` &ajaxSearch=`0` &whereSearch=`content:null|maxigallery` &minChars=`3` &AS_showForm=`0` &documents=`104` &tplResult=`withMaxigalleryResult` &tvPhx=`` &asLog=`2:1:10`!] | SELECT sc.id, sc.pagetitle, sc.longtitle, sc.description, sc.alias, sc.introtext, sc.template, sc.menutitle, sc.content, sc.publishedon, GROUP_CONCAT( DISTINCT CAST(ngal.id AS CHAR) SEPARATOR "," ) AS gal_id, GROUP_CONCAT( DISTINCT ngal.title SEPARATOR ", " ) AS gal_title, GROUP_CONCAT( DISTINCT ngal.descr SEPARATOR ", " ) AS gal_descr, GROUP_CONCAT( DISTINCT ngal.filename SEPARATOR ", " ) AS gal_filename FROM `mod2_site_content` sc LEFT JOIN( SELECT DISTINCT gal.id, gal.title, gal.descr, gal.filename, gal.gal_id FROM `mod2_maxigallery` gal WHERE (((gal.hide=0)) AND ((gal.title LIKE '%peter%') OR (gal.descr LIKE '%peter%'))) ) AS ngal ON sc.id = ngal.gal_id WHERE ((sc.id IN (104)) AND (sc.published=1) AND (sc.searchable=1) AND (sc.deleted=0) AND (sc.type='document') AND (sc.privateweb=0)) GROUP BY sc.id HAVING (((gal_title LIKE '%peter%') OR (gal_descr LIKE '%peter%'))) ORDER BY sc.publishedon,sc.pagetitle | 2010-09-06 23:24:09 | 90.214.19.189 |