© 1996-2011 Copyright Jay Kassirer. All rights reserved. No part of this work may be reproduced or used in any means without prior permission of the author.
Messages:
1. Environment + 6 ms
2. Database + 7 ms
3. 31SQL =
SELECT
node.id, node.title, (COUNT(parent.id) - 1) AS depth , node.lft, node.rgt, node.description, node.metatags, node.metadescription
FROM resources_en AS node,
resources_en AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
GROUP BY node.id
HAVING depth <= 0
ORDER BY node.lft
4. Helper + 33 ms
5. ValueList + 33 ms
6. xxxxxxx________Session checker =
7. Session Result = load
8. Session Result = 266BB3D30521404F71nlFF194CA9
9. Has Plan ID =
10. STK_logged_in Defined = true,
11. STK_resp_arr_size = 2
12. Size greater than one = tools-of-change
13. Contains a controller in addition = tools-of-change
14. Contains a STK - Size = 2
15. controller
16. Action x Pageword-of-mouth
17. Routes 333333 x Page
18. There are tools of change forms.
19. String to actionword-of-mouth
20. String to unclude
21. Routes and URL handling + 43 ms
22. Response Path = /en/tools-of-change/word-of-mouth/
23. Response Local Path = ///home/toolsofc/toolsofchange.com/html/en/tools-of-change/word-of-mouth/
24. Response Path = /en/tools-of-change/word-of-mouth/
25. do = /en/tools-of-change/word-of-mouth/
26. ____________0_____________SELECT SQL_CALC_FOUND_ROWS `page_url` FROM toolsofc_toolsofchange.resources_fr WHERE (`lft` = '48' AND `rgt` = '49') LIMIT 0,1__1__/Outils-de-Changement/De-bouche-a-oreille/___fr/outils-de-changement/de-bouche-a-oreille/
27. Tool_Example==================(SELECT example_desc, id FROM tools_ex_en WHERE section = "word1" AND ( category LIKE "%%"
) ORDER by DateModified DESC LIMIT 4) Union
(SELECT example_desc, id FROM tools_ex_en WHERE section = "word1" AND ( category LIKE "%%"
) ORDER by DateModified DESC LIMIT 3) Union
(SELECT example_desc, id FROM tools_ex_en WHERE section = "word1" AND ( category LIKE "%%"
) ORDER by DateModified DESC LIMIT 2)
28. SELECT example_desc, id
FROM tools_ex_en
WHERE section = "word1"
ORDER by SortOrder DESC, DateModified DESC
LIMIT 6
29. Tool_Example==================(SELECT example_desc, id FROM tools_ex_en WHERE section = "word2" AND ( category LIKE "%%"
) ORDER by DateModified DESC LIMIT 4) Union
(SELECT example_desc, id FROM tools_ex_en WHERE section = "word2" AND ( category LIKE "%%"
) ORDER by DateModified DESC LIMIT 3) Union
(SELECT example_desc, id FROM tools_ex_en WHERE section = "word2" AND ( category LIKE "%%"
) ORDER by DateModified DESC LIMIT 2)
30. SELECT example_desc, id
FROM tools_ex_en
WHERE section = "word2"
ORDER by SortOrder DESC, DateModified DESC
LIMIT 6
31. Tool_Example==================(SELECT example_desc, id FROM tools_ex_en WHERE section = "word3" AND ( category LIKE "%%"
) ORDER by DateModified DESC LIMIT 4) Union
(SELECT example_desc, id FROM tools_ex_en WHERE section = "word3" AND ( category LIKE "%%"
) ORDER by DateModified DESC LIMIT 3) Union
(SELECT example_desc, id FROM tools_ex_en WHERE section = "word3" AND ( category LIKE "%%"
) ORDER by DateModified DESC LIMIT 2)
32. SELECT example_desc, id
FROM tools_ex_en
WHERE section = "word3"
ORDER by SortOrder DESC, DateModified DESC
LIMIT 6
33. Tool_Example==================(SELECT example_desc, id FROM tools_ex_en WHERE section = "word4" AND ( category LIKE "%%"
) ORDER by DateModified DESC LIMIT 4) Union
(SELECT example_desc, id FROM tools_ex_en WHERE section = "word4" AND ( category LIKE "%%"
) ORDER by DateModified DESC LIMIT 3) Union
(SELECT example_desc, id FROM tools_ex_en WHERE section = "word4" AND ( category LIKE "%%"
) ORDER by DateModified DESC LIMIT 2)
34. SELECT example_desc, id
FROM tools_ex_en
WHERE section = "word4"
ORDER by SortOrder DESC, DateModified DESC
LIMIT 6
35. Tool_Example==================(SELECT example_desc, id FROM tools_ex_en WHERE section = "word5" AND ( category LIKE "%%"
) ORDER by DateModified DESC LIMIT 4) Union
(SELECT example_desc, id FROM tools_ex_en WHERE section = "word5" AND ( category LIKE "%%"
) ORDER by DateModified DESC LIMIT 3) Union
(SELECT example_desc, id FROM tools_ex_en WHERE section = "word5" AND ( category LIKE "%%"
) ORDER by DateModified DESC LIMIT 2)
36. SELECT example_desc, id
FROM tools_ex_en
WHERE section = "word5"
ORDER by SortOrder DESC, DateModified DESC
LIMIT 6
37. Cookie PlanID =
38. ---------------------------------------STK_action = word-of-mouth
39. Response Paths + 71 ms
40. Taga Loads + 71 ms

