SQL debug output

Next topic

Author	Message
Victor Dujardin	Tuesday 17 February 2009 7:45:24 am Hello everyone, I'm newbie on eZ Publish (v 4.0.1). My aim is to see which queries are executed when I run one of my eZ website page. For example, the query executed when there is a "fetch" in my template. I checked the documentation and the forum (even google) and did several manipulations, with no results. I managed to get a debug on the administrator interface but the queries are not what I am looking for. I'm sure I'veg just missed something obvious but, after several hours, I still don't what. I'd be pleased if anyone could explain me the right manipulation. Thank you. Victor
justin kazadi	Tuesday 17 February 2009 8:39:12 am Hi victor, could you please be very clear? what do you want to do exactly? do you want to activate the sql debug? if so go to the administrator interface to the right menu check the sql debut output , apply the change and clear the cache. i think is what you want. The theory is when we know everything and nothing works. The practice is when everything works and nobody knows why. If the practice and theory are met, nothing works and we do not know why. Albert Einstein
Victor Dujardin	Tuesday 17 February 2009 9:34:28 am First, thanks for the answer. Second, my aim is to get the query executed by the template when I load a page. I did activate SQL debug output: I checked the SQL Debug Output and Debug Output boxes after selecting my website Siteaccess in the dropdownlist. So I'm sure to have done something wrong in those two steps. Because, I don't get anything anywhere. But, when I select the "Global (override)" Siteaccess, I get an eZ Debug but not the one I want. Thank you.
André R.	Tuesday 17 February 2009 12:31:03 pm Database settings: http://ez.no/doc/ez_publish/technical_manual/4_0/reference/configuration_files/site_ini/databasesettings Debug settings: http://ez.no/doc/ez_publish/technical_manual/4_0/reference/configuration_files/site_ini/debugsettings And how to work with ini files: http://ez.no/doc/ez_publish/technical_manual/4_0/concepts_and_basics/configuration eZ Online Editor 5: http://projects.ez.no/ezoe \|\| eZJSCore (Ajax): http://projects.ez.no/ezjscore \|\| eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription @: http://twitter.com/andrerom
Victor Dujardin	Wednesday 18 February 2009 5:49:52 am What I was looking for was in the /var/log/notice.ini file. I was expecting it to be displayed on my website page, like for the admin interface. My mistake. Thank you for your time and reply. Victor

eZ debug

Timing:	Jan 18 2025 20:56:55
Script start
Timing:	Jan 18 2025 20:56:55
Module start 'layout'
Timing:	Jan 18 2025 20:56:55
Module start 'content'
Timing:	Jan 18 2025 20:56:56
Module end 'content'
Timing:	Jan 18 2025 20:56:56
Script end

Main resources:

Total runtime	0.9830 sec
Peak memory usage	4,096.0000 KB
Database Queries	65

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0086	587.7969	152.6094
Module start 'layout'	0.0086	0.0049	740.4063	39.4141
Module start 'content'	0.0134	0.9681	779.8203	611.9297
Module end 'content'	0.9815	0.0014	1,391.7500	16.1875
Script end	0.9830		1,407.9375

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0043	0.4379	16	0.0003
Check MTime	0.0021	0.2132	16	0.0001
Mysql Total
Database connection	0.0010	0.1044	1	0.0010
Mysqli_queries	0.9009	91.6413	65	0.0139
Looping result	0.0007	0.0671	63	0.0000
Template Total	0.9401	95.6	2	0.4700
Template load	0.0028	0.2887	2	0.0014
Template processing	0.9372	95.3421	2	0.4686
Template load and register function	0.0002	0.0182	1	0.0002
states
state_id_array	0.0011	0.1145	1	0.0011
state_identifier_array	0.0014	0.1463	2	0.0007
Override
Cache load	0.0024	0.2479	42	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0007	0.0723	3	0.0002
Fetch class attribute name	0.0015	0.1559	8	0.0002
XML
Image XML parsing	0.0029	0.2944	3	0.0010
class_abstraction
Instantiating content class attribute	0.0000	0.0032	10	0.0000
General
dbfile	0.0025	0.2506	29	0.0001
String conversion	0.0000	0.0011	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
5	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
5	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
10	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
6	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 28 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs