[2-Jul-12 10:24:47]  0.0492s  3.74Mb > AjaxSearch 1.9.2 - Php5.2.17 - MySql 5.1.40
[2-Jul-12 10:24:47]  0.0940s  4.67Mb > displayConfig - Config before parameter checking : Array
(
    [version] => 1.9.2
    [config] =>
    [debug] => 3
    [timeLimit] => 60
    [language] => english
    [asId] =>
    [ajaxSearch] => 1
    [advSearch] => oneword
    [whereSearch] => content|tv
    [sites] =>
    [subSearch] =>
    [category] =>
    [display] => unmixed
    [tags] =>
    [init] => none
    [withTvs] =>
    [tvPhx] =>
    [order] => publishedon,pagetitle
    [rank] =>
    [maxWords] => 5
    [minChars] => 3
    [showInputForm] => 1
    [showIntro] => 1
    [resultsPage] => 0
    [grabMax] => 6
    [extract] => 1:content,description,introtext,tv_value
    [extractLength] => 200
    [extractEllips] => ...
    [extractSeparator] => <br />
    [formatDate] => d/m/y : H:i:s
    [highlightResult] => 1
    [pagingType] => 1
    [showPagingAlways] => 0
    [pageLinkSeparator] =>  |
    [landingPage] =>
    [showResults] => 1
    [parents] => 32,33,34,35
    [documents] =>
    [depth] => 1
    [hideMenu] => 2
    [hideLink] => 0
    [filter] =>
    [output] => 0
    [tplInput] => @FILE:assets/snippets/ajaxSearch/templates/input.tpl.html
    [tplResults] => @FILE:assets/snippets/ajaxSearch/templates/results.tpl.html
    [tplGrpResult] => @FILE:assets/snippets/ajaxSearch/templates/grpResult.tpl.html
    [tplResult] => @FILE:assets/snippets/ajaxSearch/templates/result.tpl.html
    [tplPaging0] => @FILE:assets/snippets/ajaxSearch/templates/paging0.tpl.html
    [tplPaging1] => @FILE:assets/snippets/ajaxSearch/templates/paging1.tpl.html
    [tplComment] => @FILE:assets/snippets/ajaxSearch/templates/comment.tpl.html
    [stripInput] => defaultStripInput
    [stripOutput] => defaultStripOutput
    [searchWordList] =>
    [breadcrumbs] =>
    [clearDefault] => 0
    [jsClearDefault] => assets/snippets/ajaxSearch/js/clearDefault/clearDefault.js
    [mbstring] => 1
    [asLog] => 0:0:200
    [liveSearch] => 1
    [ajaxMax] => 5
    [showMoreResults] => 0
    [moreResultsPage] => 0
    [opacity] => 1
    [tplAjaxResults] => @FILE:assets/snippets/ajaxSearch/templates/ajaxResults.tpl.html
    [tplAjaxGrpResult] => @FILE:assets/snippets/ajaxSearch/templates/ajaxGrpResult.tpl.html
    [tplAjaxResult] => @FILE:assets/snippets/ajaxSearch/templates/ajaxResult.tpl.html
    [tplPaging2] => @FILE:assets/snippets/ajaxSearch/templates/paging2.tpl.html
    [jscript] => jquery
    [addJscript] => 1
    [jsMooTools] => manager/media/script/mootools/mootools.js
    [jsMooTools2] => assets/snippets/ajaxSearch/js/mootools2/mootools-1.2.4.js
    [jsJquery] => assets/js/jquery-1.3.2.min.js
)

[2-Jul-12 10:24:47]  0.0946s  4.68Mb > getSearchString - searchString : Costa Rica
[2-Jul-12 10:24:47]  0.0948s  4.68Mb > getSearchString - advSearch : oneword
[2-Jul-12 10:24:47]  0.0949s  4.67Mb > getEvents - subsearch :
[2-Jul-12 10:24:47]  0.0951s  4.67Mb > getEvents - asf :
[2-Jul-12 10:24:47]  0.0953s  4.67Mb > getEvents - offset : 0,0
[2-Jul-12 10:24:47]  0.0954s  4.67Mb > getEvents - pgn :
[2-Jul-12 10:24:47]  0.0956s  4.68Mb > checkSearchString - searchString : Costa Rica
[2-Jul-12 10:24:47]  0.0958s  4.68Mb > checkSearchString - searchSubmitted : 1
[2-Jul-12 10:24:47]  0.0959s  4.68Mb > checkSearchString - asfSubmitted :
[2-Jul-12 10:24:47]  0.0960s  4.68Mb > checkSearchString - checkString : 1
[2-Jul-12 10:24:47]  0.0962s  4.68Mb > checkSearchString - searchString used : Costa Rica
[2-Jul-12 10:24:47]  0.1274s  4.80Mb > tplInputForm template@FILE:assets/snippets/ajaxSearch/templates/input.tpl.html : [+as.showInputForm:is=`1`:then=`
<form id="[+as.formId+]" action="[+as.formAction+]" method="post">
    <fieldset>[+as.showAsId:is=`1`:then=`<input type="hidden" name="[+as.asName+]" value="[+as.asId+]" />`+]
    <input type="hidden" name="advsearch" value="[+as.advSearch+]" />
    <label>
      <input id="[+as.inputId+]" class="cleardefault" type="text" name="search" value="[+as.inputValue+]"[+as.inputOptions+] />
    </label>
    [+as.liveSearch:is=`0`:then=`
        <label>
            <input id="[+as.submitId+]" type="submit" name="sub" value="[+as.submitText+]" />
        </label>
    `+]
    </fieldset>
</form>
`+]
[+as.showIntro:is=`1`:then=`
<p class="ajaxSearch_intro" id="ajaxSearch_intro">[+as.introMessage+]</p>
`+]
[2-Jul-12 10:24:47]  0.1277s  4.80Mb > displayInputForm - searchString : Costa Rica
[2-Jul-12 10:24:47]  0.1278s  4.80Mb > displayInputForm - searchString : Costa Rica
[2-Jul-12 10:24:47]  0.1568s  5.01Mb > pgCharset : UTF-8
[2-Jul-12 10:24:47]  0.1570s  5.01Mb > getSiteList - siteList : Array
(
    [0] => defsite
)

[2-Jul-12 10:24:47]  0.1574s  5.01Mb > getSubsiteList - subsiteList : Array
(
    [0] => site_wide
)

[2-Jul-12 10:24:47]  0.2353s  5.03Mb > Select :
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(ntv.id AS CHAR) SEPARATOR "," ) AS tv_id,
GROUP_CONCAT( DISTINCT ntv.value SEPARATOR "," ) AS tv_value
FROM `modxlac_site_content` sc
LEFT JOIN(
SELECT DISTINCT tv.id, tv.value, tv.contentid
FROM `modxlac_site_tmplvar_contentvalues` tv ) AS ntv ON sc.id = ntv.contentid
WHERE ((sc.id IN (68,75,61,54,39,630,703,709,716,723,730,737,743,749,755,761,767,773,779,785,821,827,833,839,853,879,892,904,911,917,931,944,950,956,969,1900,2081,2087,2423,2402,2572,2860,2291,2536,1899,2350,1487,1488,1490,1492,1494,1495,1585,1586,1898,2583,2220,2531,2533,2626,2802,2628,2730,2275,2204,2782,2787,983,101,84,91,100,455,462,469,476,483,490,497,1106,2444,846,872,865,885,924,996,1014,1058,1085,1032,1020,1026,1038,1113,1133,1140,1154,1160,1166,1172,1178,1184,1190,1200,1213,1233,1240,1246,1259,1265,1478,2063,2653,1887,1906,2458,2430,2069,2075,2172,2486,2885,2892,2719,2774,2807,2830,2851,1916,1784,1498,1506,1507,1514,1515,1540,1541,1549,1557,1556,1582,1587,1912,1913,1915,1921,2740,2218,2513,2522,2538,2725,2769,2268,2010,2017,2018,2023,2024,2192,2878,2222,1791,1844,1843,2496,2315,937,962,989,1005,1066,1078,1091,1098,1044,1051,1123,1206,1219,1226,1252,1277,1283,1289,1295,1301,1307,1325,1337,1344,1351,1357,1366,1374,1381,1388,1394,1403,1409,1415,1421,1427,1433,1439,1445,1451,1457,1464,1471,1613,1499,1508,1522,1516,1528,1534,1543,1550,1558,1564,1570,1576,1605,1592,1599,1619,1625,1631,1637,1643,1649,1655,1661,1667,1673,1679,2472,1852,1866,1873,1880,2465,2451,1940,2409,2296,2368,2382,2525,2541,2566,2663,2632,2673,2816,2823,2837,2844,2899,2913,2927,2941,2948,1239,2550,1785,2352,2360,1583,1611,1612,1584,1588,1589,1591,1590,1598,1685,1687,1688,1689,1690,1691,1692,1693,1694,1696,1697,1698,1700,1701,1702,1773,1774,1775,1776,1928,1924,1925,1929,1930,1931,1932,2354,2356,2358,2338,2736,2738,2553,2630,2025,2007,2021,2022,2026,2747,2670,2732,2681,2734,2758,2749,2257,2624,2672,2590,2592,1923,108,324,331,338,345,427,434,441,507,513,519,529,539,545,560,554,569,579,587,599,613,643,649,658,667,674,681,695,2437,2093,2099,2416,2182,2324,2375,2906,2920,1772,1895,2579,2293,2362,2552,2771,2870,2260,2793,1832,2511,2512)) AND (sc.published=1) AND (sc.searchable=1) AND (sc.deleted=0) AND (sc.privateweb=0))
GROUP BY sc.id
HAVING (((sc.pagetitle LIKE '%Costa%') OR (sc.longtitle LIKE '%Costa%') OR (sc.description LIKE '%Costa%') OR (sc.alias LIKE '%Costa%') OR (sc.introtext LIKE '%Costa%') OR (sc.menutitle LIKE '%Costa%') OR (sc.content LIKE '%Costa%') OR (tv_value LIKE '%Costa%')) OR ((sc.pagetitle LIKE '%Rica%') OR (sc.longtitle LIKE '%Rica%') OR (sc.description LIKE '%Rica%') OR (sc.alias LIKE '%Rica%') OR (sc.introtext LIKE '%Rica%') OR (sc.menutitle LIKE '%Rica%') OR (sc.content LIKE '%Rica%') OR (tv_value LIKE '%Rica%')))
ORDER BY publishedon,pagetitle
[2-Jul-12 10:25:33]  45.6427s  5.03Mb > End of select
[2-Jul-12 10:25:33]  46.2601s  5.89Mb > AjaxSearch - rs : Array
(
    [0] => Array
        (
...
            )

[2-Jul-12 10:25:33]  46.3501s  5.89Mb > AjaxSearch - Elapsed Time : 46.3500s