Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#25 2015-07-09 00:24:46

hcgtv
Plugin Author
From: Key Largo, Florida
Registered: 2005-11-29
Posts: 2,722
Website

Re: To 4.6 and beyond ...

makss wrote #292775:

For me, this is very useful trace output.

For me also, thank you.

Here it is, the default 4.6-dev install tag trace:

<!-- Runtime:    0.0258 -->
<!-- Query time: 0.010948 -->
<!-- Queries: 19 -->
<!-- Memory: 2912Kb, Form='default', Tag='<txp:category2 title="1" link="1" />' -->
<!-- txp tag trace: 
Mem(Kb)_|_+(Kb)_|_Trace___
   2600 |  2600 |[SQL (0.0018949508666992): select name, data from txp_lang where lang='en-us' and event in('public','common')]
   2715 |   115 |[SQL (0.00095605850219727): select name, code, version from txp_plugin where status = 1 AND type IN (0,1,5) order by load_order asc, name asc]
   2751 |    36 |[SQL (0.00077104568481445): select page, css from txp_section where name = 'default' limit 1]
   2730 |       |[SQL (0.0003049373626709): insert into txp_log set `time` = now(), page = '/zendstudio/textpattern-dev/', ip='192.168.1.23', host='192.168.1.23', refer='', status='200', method='GET']
   2693 |       |[SQL (0.00064396858215332): select user_html from txp_page where name = 'default']
   2700 |     7 |[Page: default]
   2743 |    43 |<txp:lang />
   2750 |     7 |<txp:text item="lang_dir" />
   2751 |     1 |<txp:page_title />
   2752 |     1 |<txp:css format="link" media="" />
   2752 |       |<txp:site_url />
   2753 |     1 |<txp:meta_description />
   2757 |     4 |	[SQL (0.00023889541625977): select description from txp_section where name = 'default']
   2754 |       |<txp:if_search>
   2755 |     1 |	[<txp:if_search>: false]
   2764 |     9 |	<txp:if_category>
   2765 |     1 |		[<txp:if_category>: false]
   2769 |     4 |		<txp:if_author>
   2770 |     1 |			[<txp:if_author>: false]
   2769 |       |		</txp:if_author>
   2765 |       |	</txp:if_category>
   2765 |       |	<txp:if_section name="">
   2771 |     6 |		[<txp:if_section name="">: true]
   2773 |     2 |		<txp:site_url />
   2766 |       |	</txp:if_section>
   2758 |       |</txp:if_search>
   2757 |       |<txp:feed_link flavor="atom" format="link" label="Atom" />
   2758 |     1 |<txp:feed_link flavor="rss" format="link" label="RSS" />
   2759 |     1 |<txp:css format="link" media="" name="ie8" />
   2759 |       |<txp:if_section name="">
   2765 |     6 |	[<txp:if_section name="">: true]
   2771 |     6 |	<txp:if_search>
   2772 |     1 |		[<txp:if_search>: false]
   2777 |     5 |		<txp:if_category>
   2778 |     1 |			[<txp:if_category>: false]
   2782 |     4 |			<txp:if_author>
   2784 |     2 |				[<txp:if_author>: false]
   2783 |       |			</txp:if_author>
   2778 |       |		</txp:if_category>
   2773 |       |	</txp:if_search>
   2762 |       |</txp:if_section>
   2762 |       |<txp:link_to_home>
   2765 |     3 |	<txp:site_name />
   2762 |       |</txp:link_to_home>
   2763 |     1 |<txp:site_slogan />
   2763 |       |<txp:text item="navigation" />
   2764 |     1 |<txp:section_list default_title='<txp:text item="home" />' include_default="1" wraptag="ul" break="">
   2768 |     4 |	[attribute 'default_title']
   2770 |     2 |	<txp:text item="home" />
   2768 |       |	[/attribute]
   2772 |     4 |	[SQL (0.00035190582275391): select name, title, description from txp_section where 1 order by name != 'default', name asc]
   2776 |     4 |	<txp:if_section name='<txp:section />'>
   2778 |     2 |		[attribute 'name']
   2780 |     2 |		<txp:section />
   2778 |       |		[/attribute]
   2782 |     4 |		[<txp:if_section name='<txp:section />'>: true]
   2777 |       |	</txp:if_section>
   2777 |       |	<txp:section url="1" />
   2778 |     1 |	<txp:section title="1" />
   2779 |     1 |	<txp:if_section name='<txp:section />'>
   2780 |     1 |		[attribute 'name']
   2782 |     2 |		<txp:section />
   2781 |       |		[/attribute]
   2784 |     3 |		[<txp:if_section name='<txp:section />'>: false]
   2780 |       |	</txp:if_section>
   2780 |       |	<txp:section url="1" />
   2781 |     1 |	<txp:section title="1" />
   2770 |       |</txp:section_list>
   2770 |       |<txp:text item="main_content" />
   2773 |     3 |<txp:if_search>
   2774 |     1 |	[<txp:if_search>: false]
   2792 |    18 |	<txp:if_category>
   2793 |     1 |		[<txp:if_category>: false]
   2799 |     6 |		<txp:if_author>
   2801 |     2 |			[<txp:if_author>: false]
   2803 |     2 |			<txp:article limit="5" />
   2834 |    31 |				[filterAtts accepted]
   2842 |     8 |				[SQL (0.00055885314941406): select name from txp_section where on_frontpage != '1']
   2843 |     1 |				[SQL (0.00090193748474121): select count(*) from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00')]
   2847 |     4 |				[SQL (0.00053000450134277): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') order by Posted desc limit 0, 5]
   2859 |    12 |				[Article 1]
   2865 |     6 |				[SQL (0.00079202651977539): select Form from txp_form where name = 'default']
   2866 |     1 |				[Form: default]
   2885 |    19 |				<txp:if_individual_article>
   2886 |     1 |					[<txp:if_individual_article>: false]
   2889 |     3 |					<txp:permlink />
   2890 |     1 |					<txp:title />
   2887 |       |				</txp:if_individual_article>
   2887 |       |				<txp:text item="posted" />
   2888 |     1 |				<txp:posted format="iso8601" />
   2888 |       |				<txp:posted />
   2889 |     1 |				<txp:if_comments>
   2890 |     1 |					[<txp:if_comments>: true]
   2894 |     4 |					<txp:text item="comments" />
   2894 |       |					<txp:permlink />
   2895 |     1 |					<txp:text item="view" />
   2895 |       |					<txp:comments_count />
   2895 |       |					<txp:comments_count />
   2891 |       |				</txp:if_comments>
   2891 |       |				<txp:if_article_image>
   2891 |       |					[<txp:if_article_image>: false]
   2891 |       |				</txp:if_article_image>
   2891 |       |				<txp:body />
   2894 |     3 |				<txp:text item="author" />
   2895 |     1 |				<txp:author link="1" this_section="1" />
   2899 |     4 |					[SQL (0.00034213066101074): select RealName from txp_users where `name` = 'hcgtv' limit 1]
   2896 |       |				<txp:if_article_category>
   2898 |     2 |					[<txp:if_article_category>: true]
   2903 |     5 |					<txp:text item="categories" />
   2904 |     1 |					<txp:if_article_category number="1">
   2906 |     2 |						[<txp:if_article_category number="1">: true]
   2908 |     2 |						<txp:category1 title="1" link="1" />
   2913 |     5 |							[SQL (0.00042986869812012): select title from txp_category where name='hope-for-the-future' and type='article']
   2906 |       |					</txp:if_article_category>
   2906 |       |					<txp:if_article_category number="2">
   2908 |     2 |						[<txp:if_article_category number="2">: true]
   2911 |     3 |						<txp:if_article_category number="1">
   2913 |     2 |							[<txp:if_article_category number="1">: true]
   2911 |       |						</txp:if_article_category>
   2912 |     1 |						<txp:category2 title="1" link="1" />
   2916 |     4 |							[SQL (0.00018095970153809): select title from txp_category where name='meaningful-labor' and type='article']
   2908 |       |					</txp:if_article_category>
   2902 |       |				</txp:if_article_category>
   2902 |       |				<txp:if_individual_article>
   2902 |       |					[<txp:if_individual_article>: false]
   2902 |       |				</txp:if_individual_article>
   2829 |       |		</txp:if_author>
   2823 |       |	</txp:if_category>
   2822 |       |	<txp:variable name="more" value='<txp:newer /><txp:older />' />
   2826 |     4 |		[attribute 'value']
   2828 |     2 |		<txp:newer />
   2829 |     1 |		<txp:older />
   2827 |       |		[/attribute]
   2825 |       |	<txp:variable name="prev" value='<txp:newer />' />
   2828 |     3 |		[attribute 'value']
   2830 |     2 |		<txp:newer />
   2828 |       |		[/attribute]
   2826 |       |	<txp:variable name="next" value='<txp:older />' />
   2828 |     2 |		[attribute 'value']
   2831 |     3 |		<txp:older />
   2829 |       |		[/attribute]
   2827 |       |	<txp:if_variable name="more" value="">
   2830 |     3 |		[<txp:if_variable name="more" value="">: true]
   2828 |       |	</txp:if_variable>
   2810 |       |</txp:if_search>
   2808 |       |<txp:search_input />
   2812 |     4 |	[SQL (0.00034618377685547): select form from txp_form where `name` = 'search_input' limit 1]
   2816 |     4 |	<txp:text item="search" />
   2816 |       |	<txp:site_url />
   2817 |     1 |	<txp:site_url />
   2817 |       |	<txp:site_url />
   2817 |       |	<txp:if_search>
   2818 |     1 |		[<txp:if_search>: false]
   2818 |       |	</txp:if_search>
   2818 |       |	<txp:text item="go" />
   2811 |       |<txp:feed_link class="feed-rss" label="RSS" />
   2811 |       |<txp:feed_link class="feed-atom" flavor="atom" label="Atom" />
   2812 |     1 |<txp:variable name="links" value='<txp:linklist limit="1" />' />
   2814 |     2 |	[attribute 'value']
   2817 |     3 |	<txp:linklist limit="1" />
   2825 |     8 |		[SQL (0.00032401084899902): select *, unix_timestamp(date) as uDate from txp_link where 1=1 order by linksort asc limit 0, 1]
   2829 |     4 |		[SQL (0.00013399124145508): select Form from txp_form where name = 'plainlinks']
   2828 |       |		[Form: plainlinks]
   2830 |     2 |		<txp:linkdesctitle rel="external" />
   2817 |       |	[/attribute]
   2815 |       |<txp:if_variable name="links" value="">
   2817 |     2 |	[<txp:if_variable name="links" value="">: false]
   2820 |     3 |	<txp:text item="links" />
   2821 |     1 |	<txp:linklist wraptag="ul" break="li" />
   2829 |     8 |		[SQL (0.00018501281738281): select *, unix_timestamp(date) as uDate from txp_link where 1=1 order by linksort asc ]
   2831 |     2 |		[Form: plainlinks]
   2834 |     3 |		<txp:linkdesctitle rel="external" />
   2832 |       |		[Form: plainlinks]
   2835 |     3 |		<txp:linkdesctitle rel="external" />
   2833 |       |		[Form: plainlinks]
   2835 |     2 |		<txp:linkdesctitle rel="external" />
   2833 |       |		[Form: plainlinks]
   2836 |     3 |		<txp:linkdesctitle rel="external" />
   2834 |       |		[Form: plainlinks]
   2837 |     3 |		<txp:linkdesctitle rel="external" />
   2835 |       |		[Form: plainlinks]
   2837 |     2 |		<txp:linkdesctitle rel="external" />
   2820 |       |</txp:if_variable>
   2820 |       |<txp:text item="published_with" />
   2820 |       |<txp:text item="go_txp_com" />
   2770 |       |[ ~~~ secondpass ~~~ ]
 -->

Offline

#26 2015-07-13 08:55:01

makss
Plugin Author
From: Ukraine
Registered: 2008-10-21
Posts: 355
Website

Re: To 4.6 and beyond ...

I’m almost finished with the log trace. I invite you to discuss and test this functionality. Pull Request

I would like to hear your opinion, what else can be added or removed? What activities or events must also benefit from logging?

To test you need to go here and click the Download ZIP.

Last edited by makss (2015-07-13 09:01:20)


aks_cron : Cron inside Textpattern | aks_article : extended article_custom tag
aks_cache : cache for TxP | aks_dragdrop : Drag&Drop categories (article, link, image, file)

Offline

#27 2015-07-13 09:12:07

gaekwad
Server grease monkey
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 4,134
GitHub

Re: To 4.6 and beyond ...

makss wrote #293111:

I would like to hear your opinion, what else can be added or removed? What activities or events must also benefit from logging?

This looks great. Thank you!

Offline

Board footer

Powered by FluxBB