|
Alex Yes
|
Thursday 28 January 2010 2:55:27 am
The cache is not flushed, the queries still occur after the first request of the page.
Below are the queries from one page with an empty pagelayout. I have shortened the queries so that it is more clearly.
SELECT data, user_id, user_hash, expiration_time FROM ezsession WHERE session_key='...'
SELECT id, name, locale, disabled FROM ezcontent_language ORDER BY name ASC
SELECT e0.id AS e0_id, ... FROM ezurlalias_ml e0, ezurlalias_ml e1, ezurlalias_ml e2, ezurlalias_ml e3, ezurlalias_ml e4 WHERE e0.parent = 0 AND ... LIMIT 0, 1
Module start 'layout'
SELECT e0.id AS e0_id, ... FROM ezurlalias_ml e0, ezurlalias_ml e1 WHERE e0.parent = 0 AND (e0.lang_mask & 3 > 0) ... LIMIT 0, 1
Module start 'content'
SELECT path_string FROM ezcontentobject_tree WHERE node_id='102'
SELECT DISTINCT e0.id AS e0_id, e0.parent AS e0_parent, ... FROM ezurlalias_ml e0 WHERE e0.parent = 0 AND (e0.lang_mask & 3 > 0) ...
SELECT ezcontentobject.*, ezcontentobject_tree.*, ... FROM ezcontentobject_tree, ezcontentobject, ezcontentclass, ezcontentobject_name WHERE node_id = 98 AND ...
SELECT DISTINCT e0.id AS e0_id, ... FROM ezurlalias_ml e0, ezurlalias_ml e1 WHERE e0.parent = 0 AND (e0.lang_mask & 3 > 0) ...
SELECT ezcontentobject.*, ezcontentobject_tree.*, ... FROM ezcontentobject_tree, ezcontentobject, ezcontentclass, ezcontentobject_name WHERE node_id = 274848 AND ...
BEGIN WORK
SELECT id, main, memento_key, main_key, memento_data FROM ezoperation_memento WHERE memento_key='...' AND main='1'
SELECT id, main, memento_key, main_key, memento_data FROM ezoperation_memento WHERE memento_key='...' AND main='0'
SELECT id, module_name, function_name, connect_type, workflow_id, name FROM eztrigger WHERE name='pre_read' AND module_name='content' AND function_name='read'
SELECT ezcontentobject.*, ezcontentobject_tree.*, ... FROM ezcontentobject_tree, ezcontentobject, ezcontentclass, ezcontentobject_name WHERE node_id = 102 ...
COMMIT
SELECT ezcontentobject.*, ezcontentobject_tree.*, ... FROM ezcontentobject_tree, ezcontentobject, ezcontentclass, ezcontentobject_name WHERE node_id = 102 ...
SELECT id, name, navigation_part_identifier, locale FROM ezsection WHERE id='1'
SELECT remote_id FROM ezcontentobject WHERE id = '102'
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) ...
SELECT contentobject_state_id, group_id FROM ezcobj_state_link, ezcobj_state WHERE ezcobj_state.id=ezcobj_state_link.contentobject_state_id ...
SELECT l.contentobject_state_id, ... FROM ezcobj_state_link l, ezcobj_state s, ezcobj_state_group g WHERE l.contentobject_id=102 AND ...
SELECT ezcontentobject.*, ezcontentobject_tree.*,... FROM ezcontentobject_tree, ezcontentobject, ezcontentclass, ezcontentobject_name WHERE node_id = 93 AND ...
SELECT id, version, serialized_name_list, ... FROM ezcontentclass WHERE id='23' AND version='0' ORDER BY version ASC LIMIT 0, 2
SELECT ezcontentobject.*, ezcontentobject_tree.*, ... FROM ezcontentobject_tree, ezcontentobject, ezcontentclass, ezcontentobject_name WHERE ... ORDER BY path_string
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND ...
SELECT name, content_translation FROM ezcontentobject_name WHERE contentobject_id = '102' ...
SELECT name, content_translation FROM ezcontentobject_name WHERE contentobject_id = '102' ...
SELECT ezcontentobject_attribute.*, ... FROM ezcontentobject_attribute, ezcontentclass_attribute, ezcontentobject_version WHERE ...
SELECT ezcontentobject.*, ... FROM ezcontentobject, ezcontentclass WHERE ezcontentobject.id='102' ...
SELECT id, serialized_name_list, version, contentclass_id, ... FROM ezcontentclass_attribute WHERE id='236' AND version='0'
SELECT * FROM ezm_pool, ezcontentobject_tree WHERE ezm_pool.block_id='...' ... ORDER BY ezm_pool.priority DESC
SELECT ezcontentobject.*, ezcontentobject_tree.*, FROM ezcontentobject_tree, ezcontentobject, ezcontentclass, ezcontentobject_name WHERE node_id = 277715 AND ...
SELECT ezcontentobject.*, ezcontentobject_tree.*, FROM ezcontentobject_tree, ezcontentobject, ezcontentclass, ezcontentobject_name WHERE node_id = 277711 AND ...
SELECT ezcontentobject.*, ezcontentobject_tree.*, FROM ezcontentobject_tree, ezcontentobject, ezcontentclass, ezcontentobject_name WHERE node_id = 277704 AND ...
SELECT ezcontentobject.*, ezcontentobject_tree.*, FROM ezcontentobject_tree, ezcontentobject, ezcontentclass, ezcontentobject_name WHERE node_id = 277589 AND ...
SELECT ezcontentobject.*, ezcontentobject_tree.*, FROM ezcontentobject_tree, ezcontentobject, ezcontentclass, ezcontentobject_name WHERE node_id = 277549 AND ...
SELECT ezcontentobject.*, ezcontentobject_tree.*, FROM ezcontentobject_tree, ezcontentobject, ezcontentclass, ezcontentobject_name WHERE node_id = 248 AND ...
SELECT ezcontentobject.*, ezcontentobject_tree.*, FROM ezcontentobject_tree, ezcontentobject, ezcontentclass, ezcontentobject_name WHERE node_id = 102 AND ...
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND ...
SELECT contentobject_state_id, group_id FROM ezcobj_state_link, ezcobj_state WHERE ezcobj_state.id=ezcobj_state_link.contentobject_state_id AND ...
SELECT l.contentobject_state_id, ... FROM ezcobj_state_link l, ezcobj_state s, ezcobj_state_group g WHERE l.contentobject_id=286981 AND ...
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND ...
SELECT remote_id FROM ezcontentobject WHERE id = '286981'
SELECT ezcontentobject.*, ezcontentobject_tree.*, FROM ezcontentobject_tree, ezcontentobject, ezcontentclass, ezcontentobject_name WHERE node_id = 277715 AND ...
SELECT ezcontentobject.*, ezcontentobject_tree.*, FROM ezcontentobject_tree, ezcontentobject, ezcontentclass, ezcontentobject_name WHERE node_id = 248 AND ...
|