|
Mr Win
|
Monday 21 April 2003 3:24:52 am
eZ debug
Timing: Apr 21 2003 14:25:23
Script start
Timing: Apr 21 2003 14:25:23
Module start 'content'
Warning: eZModuleOperationInfo::execute Apr 21 2003 14:25:23
Missing main operation memento for key: 1b2a22dece048a124d0fddbec6690d8d
Debug: Apr 21 2003 14:25:23
checking viewmode 'full' #1
Debug: Apr 21 2003 14:25:23
cache used #1
Debug: Apr 21 2003 14:25:23
checking viewmode 'full' #1
Debug: Apr 21 2003 14:25:23
cache used #2
Timing: Apr 21 2003 14:25:23
Module end 'content'
Error: eZMySQLDB Apr 21 2003 14:25:23
Query error: You have an error in your SQL syntax near '))
ORDER BY ezcontentobject_tree.priority ASC' at line 20. Query: SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.name as class_name
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name
WHERE path_string like '/1/2/222/%' and
depth <= 3 and
ezcontentclass.version=0 AND
node_id != 222 AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentobject_tree.contentobject_is_published = 1
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
ezcontentobject_name.content_translation = 'eng-gb'
AND ((ezcontentobject.contentclass_id in (1,2,5,6,8,22,23,24,25,26)) or (ezcontentobject.contentclass_id in (27)) or ())
ORDER BY ezcontentobject_tree.priority ASC
Notice: eZMySQLDB::query(0.000 ms) query number per page:0 Apr 21 2003 14:25:23
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.name as class_name
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name
WHERE path_string like '/1/2/222/%' and
depth <= 3 and
ezcontentclass.version=0 AND
node_id != 222 AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentobject_tree.contentobject_is_published = 1
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
ezcontentobject_name.content_translation = 'eng-gb'
AND ((ezcontentobject.contentclass_id in (1,2,5,6,8,22,23,24,25,26)) or (ezcontentobject.contentclass_id in (27)) or ())
ORDER BY ezcontentobject_tree.priority ASC
Timing: Apr 21 2003 14:25:23
End
Timing points:
Checkpoint Elapsed Rel. Elapsed
Script start 0.0000 sec 0.1257 sec
Module start 'content' 0.1257 sec 0.3315 sec
Module end 'content' 0.4572 sec 0.4453 sec
End 0.9024 sec
Total runtime: 0.9027 sec
Time accumulators:
Accumulator Elapsed Percent Count Average
Mysql Total
Mysql_queries 0.0125 sec 1.3259% 10 0.0013 sec
Looping result 0.0003 sec 0.0299% 3 0.0001 sec
Template Total 0.4365 sec 46.2% 1 0.4365 sec
Template load 0.2352 sec 24.9113% 1 0.2352 sec
String conversion in template resource 0.0562 sec 5.9567% 1 0.0562 sec
Template parser: create text elements 0.0043 sec 0.4562% 1 0.0043 sec
Template parser: remove whitespace 0.0010 sec 0.1107% 1 0.0010 sec
Template parser: construct tree 0.0361 sec 3.8220% 1 0.0361 sec
Template load and register function 0.0140 sec 1.4844% 4 0.0035 sec
Template processing 0.2009 sec 21.2711% 1 0.2009 sec
General
String conversion 0.0560 sec 5.9312% 1 0.0560 sec
String conversion w/ codepage 0.0558 sec 5.9066% 1 0.0558 sec
Total script time: 0.9443 sec
|