© 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 + 7 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 + 32 ms
5. ValueList + 32 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 Pagepeer-support-groups
17. Routes 333333 x Page
18. There are tools of change forms.
19. String to actionpeer-support-groups
20. String to unclude
21. Routes and URL handling + 42 ms
22. Response Path = /en/tools-of-change/peer-support-groups/
23. Response Local Path = ///home/toolsofc/toolsofchange.com/html/en/tools-of-change/peer-support-groups/
24. Response Path = /en/tools-of-change/peer-support-groups/
25. do = /en/tools-of-change/peer-support-groups/
26. ____________0_____________SELECT SQL_CALC_FOUND_ROWS `page_url` FROM toolsofc_toolsofchange.resources_fr WHERE (`lft` = '44' AND `rgt` = '45') LIMIT 0,1__1__/Outils-de-Changement/Groupes-de-soutien-par-les-pairs/___fr/outils-de-changement/groupes-de-soutien-par-les-pairs/
27. Tool_Example==================(SELECT example_desc, id FROM tools_ex_en WHERE section = "peer1" AND ( category LIKE "%%"
) ORDER by DateModified DESC LIMIT 4) Union
(SELECT example_desc, id FROM tools_ex_en WHERE section = "peer1" AND ( category LIKE "%%"
) ORDER by DateModified DESC LIMIT 3) Union
(SELECT example_desc, id FROM tools_ex_en WHERE section = "peer1" AND ( category LIKE "%%"
) ORDER by DateModified DESC LIMIT 2)
28. SELECT example_desc, id
FROM tools_ex_en
WHERE section = "peer1"
ORDER by SortOrder DESC, DateModified DESC
LIMIT 6
29. Tool_Example==================(SELECT example_desc, id FROM tools_ex_en WHERE section = "peer2" AND ( category LIKE "%%"
) ORDER by DateModified DESC LIMIT 4) Union
(SELECT example_desc, id FROM tools_ex_en WHERE section = "peer2" AND ( category LIKE "%%"
) ORDER by DateModified DESC LIMIT 3) Union
(SELECT example_desc, id FROM tools_ex_en WHERE section = "peer2" AND ( category LIKE "%%"
) ORDER by DateModified DESC LIMIT 2)
30. SELECT example_desc, id
FROM tools_ex_en
WHERE section = "peer2"
ORDER by SortOrder DESC, DateModified DESC
LIMIT 6
31. Tool_Example==================(SELECT example_desc, id FROM tools_ex_en WHERE section = "peer3" AND ( category LIKE "%%"
) ORDER by DateModified DESC LIMIT 4) Union
(SELECT example_desc, id FROM tools_ex_en WHERE section = "peer3" AND ( category LIKE "%%"
) ORDER by DateModified DESC LIMIT 3) Union
(SELECT example_desc, id FROM tools_ex_en WHERE section = "peer3" AND ( category LIKE "%%"
) ORDER by DateModified DESC LIMIT 2)
32. SELECT example_desc, id
FROM tools_ex_en
WHERE section = "peer3"
ORDER by SortOrder DESC, DateModified DESC
LIMIT 6
33. Tool_Example==================(SELECT example_desc, id FROM tools_ex_en WHERE section = "peer4" AND ( category LIKE "%%"
) ORDER by DateModified DESC LIMIT 4) Union
(SELECT example_desc, id FROM tools_ex_en WHERE section = "peer4" AND ( category LIKE "%%"
) ORDER by DateModified DESC LIMIT 3) Union
(SELECT example_desc, id FROM tools_ex_en WHERE section = "peer4" AND ( category LIKE "%%"
) ORDER by DateModified DESC LIMIT 2)
34. SELECT example_desc, id
FROM tools_ex_en
WHERE section = "peer4"
ORDER by SortOrder DESC, DateModified DESC
LIMIT 6
35. Tool_Example==================(SELECT example_desc, id FROM tools_ex_en WHERE section = "peer5" AND ( category LIKE "%%"
) ORDER by DateModified DESC LIMIT 4) Union
(SELECT example_desc, id FROM tools_ex_en WHERE section = "peer5" AND ( category LIKE "%%"
) ORDER by DateModified DESC LIMIT 3) Union
(SELECT example_desc, id FROM tools_ex_en WHERE section = "peer5" AND ( category LIKE "%%"
) ORDER by DateModified DESC LIMIT 2)
36. SELECT example_desc, id
FROM tools_ex_en
WHERE section = "peer5"
ORDER by SortOrder DESC, DateModified DESC
LIMIT 6
37. Tool_Example==================(SELECT example_desc, id FROM tools_ex_en WHERE section = "peer6" AND ( category LIKE "%%"
) ORDER by DateModified DESC LIMIT 4) Union
(SELECT example_desc, id FROM tools_ex_en WHERE section = "peer6" AND ( category LIKE "%%"
) ORDER by DateModified DESC LIMIT 3) Union
(SELECT example_desc, id FROM tools_ex_en WHERE section = "peer6" AND ( category LIKE "%%"
) ORDER by DateModified DESC LIMIT 2)
38. SELECT example_desc, id
FROM tools_ex_en
WHERE section = "peer6"
ORDER by SortOrder DESC, DateModified DESC
LIMIT 6
39. Cookie PlanID =
40. ---------------------------------------STK_action = peer-support-groups
41. Response Paths + 73 ms
42. Taga Loads + 73 ms

