Forums / Developer / NULLs and zeroes in ezcontentobject_attribute

NULLs and zeroes in ezcontentobject_attribute

Previous topic

Developer

Next topic

Author	Message
Marko Žmak	Monday 07 March 2011 12:51:16 pm I noticed that in ezcontenobject_attribute table there are for the same attribute type (i.e. ezobjectrelation) rows where data_int is NULL but alo others where data_int is 0. Why does this happend and what's the difference? -- Nothing is impossible. Not if you can imagine it! Hubert Farnsworth

Author

Message

Marko Žmak

Monday 07 March 2011 12:51:16 pm

I noticed that in ezcontenobject_attribute table there are for the same attribute type (i.e. ezobjectrelation) rows where data_int is NULL but alo others where data_int is 0.

Why does this happend and what's the difference?

--
Nothing is impossible. Not if you can imagine it!

Hubert Farnsworth

eZ debug

Timing:

Jan 29 2025 13:38:07

Script start

Timing:

Jan 29 2025 13:38:07

Module start 'content'

Timing:

Jan 29 2025 13:38:07

Module end 'content'

Timing:

Jan 29 2025 13:38:07

Script end

Main resources:

Total runtime

0.1538 sec

Peak memory usage

2,048.0000 KB

Database Queries

141

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0077	588.0703	180.8203
Module start 'content'	0.0077	0.0063	768.8906	89.8516
Module end 'content'	0.0140	0.1397	858.7422	517.9844
Script end	0.1537		1,376.7266

Checkpoint

Start (sec)

Duration (sec)

Memory at start (KB)

Memory used (KB)

Script start

0.0000

0.0077

588.0703

180.8203

Module start 'content'

0.0077

0.0063

768.8906

89.8516

Module end 'content'

0.0140

0.1397

858.7422

517.9844

Script end

0.1537

1,376.7266

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0036	2.3297	20	0.0002
Check MTime	0.0012	0.7583	20	0.0001
Mysql Total
Database connection	0.0019	1.2122	1	0.0019
Mysqli_queries	0.1043	67.8207	141	0.0007
Looping result	0.0011	0.7278	139	0.0000
Template Total	0.1393	90.6	1	0.1393
Template load	0.0009	0.5838	1	0.0009
Template processing	0.1384	89.9673	1	0.1384
Override
Cache load	0.0006	0.3888	1	0.0006
Sytem overhead
Fetch class attribute can translate value	0.0007	0.4778	1	0.0007
XML
Image XML parsing	0.0004	0.2652	1	0.0004
General
dbfile	0.0061	3.9461	20	0.0003
String conversion	0.0000	0.0020	3	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Accumulator

Duration (sec)

Duration (%)

Count

Average (sec)

Ini load

Load cache

0.0036

2.3297

0.0002

Check MTime

0.0012

0.7583

0.0001

Mysql Total

Database connection

0.0019

1.2122

0.0019

Mysqli_queries

0.1043

67.8207

141

0.0007

Looping result

0.0011

0.7278

139

0.0000

Template Total

0.1393

90.6

0.1393

Template load

0.0009

0.5838

0.0009

Template processing

0.1384

89.9673

0.1384

Override

Cache load

0.0006

0.3888

0.0006

Sytem overhead

Fetch class attribute can translate value

0.0007

0.4778

0.0007

XML

Image XML parsing

0.0004

0.2652

0.0004

General

dbfile

0.0061

3.9461

0.0003

String conversion

0.0000

0.0020

0.0000

Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

Cache	Type	Packlevel	SourceFiles
	CSS	0	extension/community/design/community/stylesheets/ext/jquery.autocomplete.css extension/community_design/design/suncana/stylesheets/scrollbars.css extension/community_design/design/suncana/stylesheets/tabs.css extension/community_design/design/suncana/stylesheets/roadmap.css extension/community_design/design/suncana/stylesheets/content.css extension/community_design/design/suncana/stylesheets/star-rating.css extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css extension/community_design/design/suncana/stylesheets/buttons.css extension/community_design/design/suncana/stylesheets/tweetbox.css extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css extension/sevenx/design/simple/stylesheets/star_rating.css extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css extension/sevenx/design/simple/stylesheets/main.v02.css extension/sevenx/design/simple/stylesheets/main.v02.res.css
	JS	0	extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js extension/community_design/design/suncana/javascript/jquery.ui.core.min.js extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js extension/community_design/design/suncana/javascript/jquery.easing.1.3.js extension/community_design/design/suncana/javascript/jquery.ui.tabs.js extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js extension/community_design/design/suncana/javascript/jquery.popmenu.js extension/community_design/design/suncana/javascript/jScrollPane.js extension/community_design/design/suncana/javascript/jquery.mousewheel.js extension/community_design/design/suncana/javascript/jquery.cycle.all.js extension/sevenx/design/simple/javascript/jquery.scrollTo.js extension/community_design/design/suncana/javascript/jquery.cookie.js extension/community_design/design/suncana/javascript/ezstarrating_jquery.js extension/community_design/design/suncana/javascript/jquery.initboxes.js extension/community_design/design/suncana/javascript/app.js extension/community_design/design/suncana/javascript/twitterwidget.js extension/community_design/design/suncana/javascript/community.js extension/community_design/design/suncana/javascript/roadmap.js extension/community_design/design/suncana/javascript/ez.js extension/community_design/design/suncana/javascript/ezshareevents.js extension/sevenx/design/simple/javascript/main.js

Cache

Type

Packlevel

SourceFiles

CSS

extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css

extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	pagelayout.tpl	<No override>	extension/sevenx/design/simple/templates/pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Usage

Requested template

Template

Template loaded

Edit

Override

pagelayout.tpl

<No override>

extension/sevenx/design/simple/templates/pagelayout.tpl

Number of times templates used: 1
Number of unique templates used: 1

Time used to render debug report: 0.0002 secs