eZ debug

SET NAMES 'utf8'

dfs::ctor( 'var/tiempo/cache/ezcontentlanguage_cache.php' )

SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/ezcontentlanguage_cache.php')

RESULT:
array (
  'datatype' => 'php',
  'name' => 'var/tiempo/cache/ezcontentlanguage_cache.php',
  'name_trunk' => 'var/tiempo/cache/ezcontentlanguage_cache.php',
  'name_hash' => 'd9f8bf39414b8ae78d1e01cd2ed8df88',
  'scope' => 'content',
  'size' => '173',
  'mtime' => '1457944612',
  'expired' => '0',
)

Processing local cache file var/tiempo/cache/ezcontentlanguage_cache.php

EXPLAIN
SELECT e0.id AS e0_id, e0.link AS e0_link, e0.text AS e0_text, e0.text_md5 AS e0_text_md5, e0.is_alias AS e0_is_alias, e0.alias_redirects AS e0_alias_redirects, e1.id AS e1_id, e1.link AS e1_link, e1.text AS e1_text, e1.text_md5 AS e1_text_md5, e1.is_alias AS e1_is_alias, e1.action AS e1_action, e1.alias_redirects AS e1_alias_redirects FROM ezurlalias_ml e0, ezurlalias_ml e1 WHERE e0.parent = 0 AND (e0.lang_mask & 3 > 0) AND e0.text_md5 =  MD5( 'espana' )  AND e1.parent = e0.link AND (e1.lang_mask & 3 > 0) AND e1.text_md5 =  MD5( 'brujula-electoral' ) 
LIMIT 0, 1

ANALYSIS:
+----+-------------+-------+-------+--------------------------------------------------------------------------------------+---------+---------+-------------+------+-------+
| id | select_type | table | type  | possible_keys                                                                        | key     | key_len | ref         | rows | Extra |
+----+-------------+-------+-------+--------------------------------------------------------------------------------------+---------+---------+-------------+------+-------+
|  1 | SIMPLE      | e0    | const | PRIMARY,ezurlalias_ml_par_act_id_lnk,ezurlalias_ml_par_lnk_txt,ezurlalias_ml_par_txt | PRIMARY |     102 | const,const |    1 |       |
+----+-------------+-------+-------+--------------------------------------------------------------------------------------+---------+---------+-------------+------+-------+
|  1 | SIMPLE      | e1    | const | PRIMARY,ezurlalias_ml_par_act_id_lnk,ezurlalias_ml_par_lnk_txt,ezurlalias_ml_par_txt | PRIMARY |     102 | const,const |    1 |       |
+----+-------------+-------+-------+--------------------------------------------------------------------------------------+---------+---------+-------------+------+-------+

dfs::ctor( 'var/tiempo/cache/wildcard/wildcard_836918d2396f83b4c0f0fee1b978d1e3_index.php' )

dfs::ctor( 'var/tiempo/cache/expiry.php' )

SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/expiry.php')

RESULT:
array (
  'datatype' => 'misc',
  'name' => 'var/tiempo/cache/expiry.php',
  'name_trunk' => 'var/tiempo/cache/expiry.php',
  'name_hash' => '54ce2e919dc0167ebd58826631444e5b',
  'scope' => 'expirycache',
  'size' => '361',
  'mtime' => '1458561975',
  'expired' => '0',
)

Processing local cache file var/tiempo/cache/expiry.php

SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/wildcard/wildcard_836918d2396f83b4c0f0fee1b978d1e3_index.php')

RESULT:
array (
  'datatype' => 'php',
  'name' => 'var/tiempo/cache/wildcard/wildcard_836918d2396f83b4c0f0fee1b978d1e3_index.php',
  'name_trunk' => 'var/tiempo/cache/wildcard/wildcard_836918d2396f83b4c0f0fee1b978d1e3_index.php',
  'name_hash' => 'c98e64cdad536dbf059950103842b63b',
  'scope' => 'wildcard-cache-index',
  'size' => '54',
  'mtime' => '1458447938',
  'expired' => '0',
)

Processing local cache file var/tiempo/cache/wildcard/wildcard_836918d2396f83b4c0f0fee1b978d1e3_index.php

dfs::ctor( 'var/tiempo/cache/statelimitations_130ddb5a4463d808f7d249e05d0196a8.php' )

SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/statelimitations_130ddb5a4463d808f7d249e05d0196a8.php')

RESULT:
array (
  'datatype' => 'php',
  'name' => 'var/tiempo/cache/statelimitations_130ddb5a4463d808f7d249e05d0196a8.php',
  'name_trunk' => 'var/tiempo/cache/statelimitations_130ddb5a4463d808f7d249e05d0196a8.php',
  'name_hash' => 'f8fbf87af53cbdef543685aa96460845',
  'scope' => 'statelimitations',
  'size' => '39',
  'mtime' => '1458447518',
  'expired' => '0',
)

Processing local cache file var/tiempo/cache/statelimitations_130ddb5a4463d808f7d249e05d0196a8.php

Module start 'content'

dfs::ctor( 'var/tiempo/cache/user-info/1/0/user-data-10.cache.php' )

SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/user-info/1/0/user-data-10.cache.php')

RESULT:
array (
  'datatype' => 'php',
  'name' => 'var/tiempo/cache/user-info/1/0/user-data-10.cache.php',
  'name_trunk' => 'var/tiempo/cache/user-info/1/0/user-data-10.cache.php',
  'name_hash' => '5e4fc72cf86dbe50813c5a939d3329b3',
  'scope' => 'user-info-cache',
  'size' => '2146',
  'mtime' => '1458447516',
  'expired' => '0',
)

Processing local cache file var/tiempo/cache/user-info/1/0/user-data-10.cache.php

dfs::ctor( 'var/tiempo/cache/user-info/1/0/user-data-10.cache.php' )

Processing local cache file var/tiempo/cache/user-info/1/0/user-data-10.cache.php

dfs::ctor( 'var/tiempo/cache/content/tiempo/1/0/5/4/105481-e95113e75012a10f337778226e13fb4a.cache' )

SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/content/tiempo/1/0/5/4/105481-e95113e75012a10f337778226e13fb4a.cache')

RESULT:
array (
  'datatype' => 'misc',
  'name' => 'var/tiempo/cache/content/tiempo/1/0/5/4/105481-e95113e75012a10f337778226e13fb4a.cache',
  'name_trunk' => 'var/tiempo/cache/content/tiempo/1/0/5/4/105481-',
  'name_hash' => 'e60b65a50d735a7b84d9aa471c1a2610',
  'scope' => 'viewcache',
  'size' => '2029',
  'mtime' => '1458513969',
  'expired' => '0',
)

Processing local cache file var/tiempo/cache/content/tiempo/1/0/5/4/105481-e95113e75012a10f337778226e13fb4a.cache

Content cache is expired by eZContentObject::isCacheExpired(1458513969)

Starting cache generation

INSERT INTO ezdfsfile ( name, name_trunk, name_hash, scope, datatype, mtime, expired ) VALUES('var/tiempo/cache/content/tiempo/1/0/5/4/105481-e95113e75012a10f337778226e13fb4a.cache.generating', 'var/tiempo/cache/content/tiempo/1/0/5/4/105481-e95113e75012a10f337778226e13fb4a.cache.generating', MD5('var/tiempo/cache/content/tiempo/1/0/5/4/105481-e95113e75012a10f337778226e13fb4a.cache.generating'), '', '', 1458578245, 0)

EXPLAIN
SELECT ezcontentobject.*,
                       ezcontentobject_tree.*,
                       ezcontentclass.serialized_name_list as class_serialized_name_list,
                       ezcontentclass.identifier as class_identifier,
                       ezcontentclass.is_container as is_container
                       , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                FROM ezcontentobject_tree,
                     ezcontentobject,
                     ezcontentclass
                     , ezcontentobject_name 
                WHERE node_id = 105481 AND 
                      ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
                      ezcontentclass.version=0  AND
                      ezcontentclass.id = ezcontentobject.contentclass_id
                       AND 
 ezcontentobject.language_mask & 3 > 0 

                       and  ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
                                  ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) )
 )

ANALYSIS:
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
| id | select_type | table                | type  | possible_keys                                                  | key     | key_len | ref         | rows | Extra       |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
|  1 | SIMPLE      | ezcontentobject_tree | const | PRIMARY,ezcontentobject_tree_co_id                             | PRIMARY |       4 | const       |    1 |             |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
|  1 | SIMPLE      | ezcontentobject      | const | PRIMARY,ezcontentobject_classid                                | PRIMARY |       4 | const       |    1 |             |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
|  1 | SIMPLE      | ezcontentclass       | const | PRIMARY,ezcontentclass_version                                 | PRIMARY |       8 | const,const |    1 |             |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
|  1 | SIMPLE      | ezcontentobject_name | ref   | PRIMARY,ezcontentobject_name_co_id,ezcontentobject_name_cov_id | PRIMARY |       8 | const,const |    1 | Using where |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+

EXPLAIN
SELECT id, name, navigation_part_identifier, locale, identifier
                    FROM   ezsection WHERE  id='1'

ANALYSIS:
+----+-------------+-----------+-------+---------------+---------+---------+-------+------+-------+
| id | select_type | table     | type  | possible_keys | key     | key_len | ref   | rows | Extra |
+----+-------------+-----------+-------+---------------+---------+---------+-------+------+-------+
|  1 | SIMPLE      | ezsection | const | PRIMARY       | PRIMARY |       4 | const |    1 |       |
+----+-------------+-----------+-------+---------------+---------+---------+-------+------+-------+

EXPLAIN
SELECT remote_id FROM ezcontentobject WHERE id = '105681'

ANALYSIS:
+----+-------------+-----------------+-------+---------------+---------+---------+-------+------+-------+
| id | select_type | table           | type  | possible_keys | key     | key_len | ref   | rows | Extra |
+----+-------------+-----------------+-------+---------------+---------+---------+-------+------+-------+
|  1 | SIMPLE      | ezcontentobject | const | PRIMARY       | PRIMARY |       4 | const |    1 |       |
+----+-------------+-----------------+-------+---------------+---------+---------+-------+------+-------+

EXPLAIN
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:80', 'eznode:105481' ) AND is_original = 1 AND is_alias=0

ANALYSIS:
+----+-------------+---------------+-------+--------------------------------------------+-----------------------+---------+-----+------+-------------+
| id | select_type | table         | type  | possible_keys                              | key                   | key_len | ref | rows | Extra       |
+----+-------------+---------------+-------+--------------------------------------------+-----------------------+---------+-----+------+-------------+
|  1 | SIMPLE      | ezurlalias_ml | range | ezurlalias_ml_act_org,ezurlalias_ml_action | ezurlalias_ml_act_org |     102 |     |    3 | Using where |
+----+-------------+---------------+-------+--------------------------------------------+-----------------------+---------+-----+------+-------------+

EXPLAIN
SELECT contentobject_state_id, group_id FROM ezcobj_state_link, ezcobj_state
                    WHERE ezcobj_state.id=ezcobj_state_link.contentobject_state_id AND
                          contentobject_id=105681

ANALYSIS:
+----+-------------+-------------------+--------+---------------+---------+---------+---------------------------------------------------------+------+-------------+
| id | select_type | table             | type   | possible_keys | key     | key_len | ref                                                     | rows | Extra       |
+----+-------------+-------------------+--------+---------------+---------+---------+---------------------------------------------------------+------+-------------+
|  1 | SIMPLE      | ezcobj_state_link | ref    | PRIMARY       | PRIMARY |       4 | const                                                   |    1 | Using index |
+----+-------------+-------------------+--------+---------------+---------+---------+---------------------------------------------------------+------+-------------+
|  1 | SIMPLE      | ezcobj_state      | eq_ref | PRIMARY       | PRIMARY |       4 | revista_tiempo.ezcobj_state_link.contentobject_state_id |    1 |             |
+----+-------------+-------------------+--------+---------------+---------+---------+---------------------------------------------------------+------+-------------+

EXPLAIN
SELECT l.contentobject_state_id, s.identifier AS state_identifier, g.identifier AS state_group_identifier
                FROM ezcobj_state_link l, ezcobj_state s, ezcobj_state_group g
                WHERE l.contentobject_id=105681 AND
                      s.id=l.contentobject_state_id AND
                      g.id=s.group_id

ANALYSIS:
+----+-------------+-------+--------+---------------------------------+-------------------------------+---------+-----------------------------------------+------+--------------------------------+
| id | select_type | table | type   | possible_keys                   | key                           | key_len | ref                                     | rows | Extra                          |
+----+-------------+-------+--------+---------------------------------+-------------------------------+---------+-----------------------------------------+------+--------------------------------+
|  1 | SIMPLE      | l     | ref    | PRIMARY                         | PRIMARY                       |       4 | const                                   |    1 | Using index                    |
+----+-------------+-------+--------+---------------------------------+-------------------------------+---------+-----------------------------------------+------+--------------------------------+
|  1 | SIMPLE      | g     | index  | PRIMARY                         | ezcobj_state_group_identifier |     137 |                                         |    1 | Using index; Using join buffer |
+----+-------------+-------+--------+---------------------------------+-------------------------------+---------+-----------------------------------------+------+--------------------------------+
|  1 | SIMPLE      | s     | eq_ref | PRIMARY,ezcobj_state_identifier | PRIMARY                       |       4 | revista_tiempo.l.contentobject_state_id |    1 | Using where                    |
+----+-------------+-------+--------+---------------------------------+-------------------------------+---------+-----------------------------------------+------+--------------------------------+

EXPLAIN
SELECT ezcontentobject.*,
                       ezcontentobject_tree.*,
                       ezcontentclass.serialized_name_list as class_serialized_name_list,
                       ezcontentclass.identifier as class_identifier,
                       ezcontentclass.is_container as is_container
                       , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                FROM ezcontentobject_tree,
                     ezcontentobject,
                     ezcontentclass
                     , ezcontentobject_name 
                WHERE node_id = 80 AND 
                      ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
                      ezcontentclass.version=0  AND
                      ezcontentclass.id = ezcontentobject.contentclass_id
                       AND 
 ezcontentobject.language_mask & 3 > 0 

                       and  ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
                                  ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) )
 )

ANALYSIS:
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
| id | select_type | table                | type  | possible_keys                                                  | key     | key_len | ref         | rows | Extra       |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
|  1 | SIMPLE      | ezcontentobject_tree | const | PRIMARY,ezcontentobject_tree_co_id                             | PRIMARY |       4 | const       |    1 |             |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
|  1 | SIMPLE      | ezcontentobject      | const | PRIMARY,ezcontentobject_classid                                | PRIMARY |       4 | const       |    1 |             |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
|  1 | SIMPLE      | ezcontentclass       | const | PRIMARY,ezcontentclass_version                                 | PRIMARY |       8 | const,const |    1 |             |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
|  1 | SIMPLE      | ezcontentobject_name | ref   | PRIMARY,ezcontentobject_name_co_id,ezcontentobject_name_cov_id | PRIMARY |       8 | const,const |    1 | Using where |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+

EXPLAIN
SELECT id, version, serialized_name_list, serialized_description_list, identifier, contentobject_name, url_alias_name,       creator_id, modifier_id, created, remote_id, modified, is_container, always_available,       language_mask, initial_language_id, sort_field, sort_order
                    FROM   ezcontentclass WHERE  id='49' AND version='0' ORDER BY version ASC
LIMIT 0, 2

ANALYSIS:
+----+-------------+----------------+-------+--------------------------------+---------+---------+-------------+------+-------+
| id | select_type | table          | type  | possible_keys                  | key     | key_len | ref         | rows | Extra |
+----+-------------+----------------+-------+--------------------------------+---------+---------+-------------+------+-------+
|  1 | SIMPLE      | ezcontentclass | const | PRIMARY,ezcontentclass_version | PRIMARY |       8 | const,const |    1 |       |
+----+-------------+----------------+-------+--------------------------------+---------+---------+-------------+------+-------+

EXPLAIN
SELECT ezcontentobject.*,
                             ezcontentobject_tree.*,
                             ezcontentclass.serialized_name_list as class_serialized_name_list,
                             ezcontentclass.identifier as class_identifier,
                             ezcontentclass.is_container as is_container
                             , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                      FROM ezcontentobject_tree,
                           ezcontentobject,
                           ezcontentclass
                           , ezcontentobject_name 
                      WHERE  node_id IN ( 1, 2, 80 ) and 
                            ezcontentobject_tree.contentobject_id=ezcontentobject.id  AND
                            ezcontentclass.version=0 AND
                            ezcontentclass.id = ezcontentobject.contentclass_id
                             AND  ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
                                   ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) )
 ) 

                      ORDER BY path_string

ANALYSIS:
+----+-------------+----------------------+--------+----------------------------------------------------------------+---------+---------+---------------------------------------------------------------------------------------------+------+-----------------------------+
| id | select_type | table                | type   | possible_keys                                                  | key     | key_len | ref                                                                                         | rows | Extra                       |
+----+-------------+----------------------+--------+----------------------------------------------------------------+---------+---------+---------------------------------------------------------------------------------------------+------+-----------------------------+
|  1 | SIMPLE      | ezcontentobject_tree | range  | PRIMARY,ezcontentobject_tree_co_id                             | PRIMARY |       4 |                                                                                             |    3 | Using where; Using filesort |
+----+-------------+----------------------+--------+----------------------------------------------------------------+---------+---------+---------------------------------------------------------------------------------------------+------+-----------------------------+
|  1 | SIMPLE      | ezcontentobject      | eq_ref | PRIMARY,ezcontentobject_classid                                | PRIMARY |       4 | revista_tiempo.ezcontentobject_tree.contentobject_id                                        |    1 |                             |
+----+-------------+----------------------+--------+----------------------------------------------------------------+---------+---------+---------------------------------------------------------------------------------------------+------+-----------------------------+
|  1 | SIMPLE      | ezcontentclass       | eq_ref | PRIMARY,ezcontentclass_version                                 | PRIMARY |       8 | revista_tiempo.ezcontentobject.contentclass_id,const                                        |    1 |                             |
+----+-------------+----------------------+--------+----------------------------------------------------------------+---------+---------+---------------------------------------------------------------------------------------------+------+-----------------------------+
|  1 | SIMPLE      | ezcontentobject_name | ref    | PRIMARY,ezcontentobject_name_co_id,ezcontentobject_name_cov_id | PRIMARY |       8 | revista_tiempo.ezcontentobject.id,revista_tiempo.ezcontentobject_tree.contentobject_version |    1 | Using where                 |
+----+-------------+----------------------+--------+----------------------------------------------------------------+---------+---------+---------------------------------------------------------------------------------------------+------+-----------------------------+

EXPLAIN
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:80' ) AND is_original = 1 AND is_alias=0

ANALYSIS:
+----+-------------+---------------+-------+--------------------------------------------+-----------------------+---------+-----+------+-------------+
| id | select_type | table         | type  | possible_keys                              | key                   | key_len | ref | rows | Extra       |
+----+-------------+---------------+-------+--------------------------------------------+-----------------------+---------+-----+------+-------------+
|  1 | SIMPLE      | ezurlalias_ml | range | ezurlalias_ml_act_org,ezurlalias_ml_action | ezurlalias_ml_act_org |     102 |     |    2 | Using where |
+----+-------------+---------------+-------+--------------------------------------------+-----------------------+---------+-----+------+-------------+

EXPLAIN
SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '105681'
                       AND content_version = '1'
                       AND ( content_translation = 'esl-ES' OR language_id = '2' )

ANALYSIS:
+----+-------------+----------------------+------+---------------------------------------------------------------------------------------------+---------+---------+-------------+------+-------------+
| id | select_type | table                | type | possible_keys                                                                               | key     | key_len | ref         | rows | Extra       |
+----+-------------+----------------------+------+---------------------------------------------------------------------------------------------+---------+---------+-------------+------+-------------+
|  1 | SIMPLE      | ezcontentobject_name | ref  | PRIMARY,ezcontentobject_name_co_id,ezcontentobject_name_cov_id,ezcontentobject_name_lang_id | PRIMARY |       8 | const,const |    1 | Using where |
+----+-------------+----------------------+------+---------------------------------------------------------------------------------------------+---------+---------+-------------+------+-------------+

EXPLAIN
SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '105681'
                       AND content_version = '1'
                       AND ( content_translation = 'esl-ES' OR language_id = '2' )

ANALYSIS:
+----+-------------+----------------------+------+---------------------------------------------------------------------------------------------+---------+---------+-------------+------+-------------+
| id | select_type | table                | type | possible_keys                                                                               | key     | key_len | ref         | rows | Extra       |
+----+-------------+----------------------+------+---------------------------------------------------------------------------------------------+---------+---------+-------------+------+-------------+
|  1 | SIMPLE      | ezcontentobject_name | ref  | PRIMARY,ezcontentobject_name_co_id,ezcontentobject_name_cov_id,ezcontentobject_name_lang_id | PRIMARY |       8 | const,const |    1 | Using where |
+----+-------------+----------------------+------+---------------------------------------------------------------------------------------------+---------+---------+-------------+------+-------------+

EXPLAIN
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
                    ezcontentobject_attribute, ezcontentclass_attribute, ezcontentobject_version
                  WHERE
                    ezcontentclass_attribute.version = '0' AND
                    ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
                    ezcontentobject_version.contentobject_id = '105681' AND
                    ezcontentobject_version.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '105681' AND                    ezcontentobject_attribute.version = '1' AND                    ezcontentobject_attribute.language_code = 'esl-ES' 
                  
                  ORDER BY
                    ezcontentclass_attribute.placement ASC,
                    ezcontentobject_attribute.language_code ASC

ANALYSIS:
+----+-------------+---------------------------+--------+----------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------+---------+-------------------------------------------------------------------------+------+-----------------------------------------------------------+
| id | select_type | table                     | type   | possible_keys                                                                                                                    | key                                           | key_len | ref                                                                     | rows | Extra                                                     |
+----+-------------+---------------------------+--------+----------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------+---------+-------------------------------------------------------------------------+------+-----------------------------------------------------------+
|  1 | SIMPLE      | ezcontentobject_version   | ref    | idx_object_version_objver                                                                                                        | idx_object_version_objver                     |       9 | const,const                                                             |    1 | Using where; Using index; Using temporary; Using filesort |
+----+-------------+---------------------------+--------+----------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------+---------+-------------------------------------------------------------------------+------+-----------------------------------------------------------+
|  1 | SIMPLE      | ezcontentobject_attribute | ref    | ezcontentobject_attribute_co_id_ver_lang_code,ezcontentobject_attribute_contentobject_id,ezcontentobject_attribute_language_code | ezcontentobject_attribute_co_id_ver_lang_code |      70 | const,const,const                                                       |   10 | Using where                                               |
+----+-------------+---------------------------+--------+----------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------+---------+-------------------------------------------------------------------------+------+-----------------------------------------------------------+
|  1 | SIMPLE      | ezcontentclass_attribute  | eq_ref | PRIMARY                                                                                                                          | PRIMARY                                       |       8 | revista_tiempo.ezcontentobject_attribute.contentclassattribute_id,const |    1 |                                                           |
+----+-------------+---------------------------+--------+----------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------+---------+-------------------------------------------------------------------------+------+-----------------------------------------------------------+

EXPLAIN
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:80', 'eznode:105481' ) AND is_original = 1 AND is_alias=0

ANALYSIS:
+----+-------------+---------------+-------+--------------------------------------------+-----------------------+---------+-----+------+-------------+
| id | select_type | table         | type  | possible_keys                              | key                   | key_len | ref | rows | Extra       |
+----+-------------+---------------+-------+--------------------------------------------+-----------------------+---------+-----+------+-------------+
|  1 | SIMPLE      | ezurlalias_ml | range | ezurlalias_ml_act_org,ezurlalias_ml_action | ezurlalias_ml_act_org |     102 |     |    3 | Using where |
+----+-------------+---------------+-------+--------------------------------------------+-----------------------+---------+-----+------+-------------+

EXPLAIN
SELECT l.contentobject_state_id, s.identifier AS state_identifier, g.identifier AS state_group_identifier
                FROM ezcobj_state_link l, ezcobj_state s, ezcobj_state_group g
                WHERE l.contentobject_id=105681 AND
                      s.id=l.contentobject_state_id AND
                      g.id=s.group_id

ANALYSIS:
+----+-------------+-------+--------+---------------------------------+-------------------------------+---------+-----------------------------------------+------+--------------------------------+
| id | select_type | table | type   | possible_keys                   | key                           | key_len | ref                                     | rows | Extra                          |
+----+-------------+-------+--------+---------------------------------+-------------------------------+---------+-----------------------------------------+------+--------------------------------+
|  1 | SIMPLE      | l     | ref    | PRIMARY                         | PRIMARY                       |       4 | const                                   |    1 | Using index                    |
+----+-------------+-------+--------+---------------------------------+-------------------------------+---------+-----------------------------------------+------+--------------------------------+
|  1 | SIMPLE      | g     | index  | PRIMARY                         | ezcobj_state_group_identifier |     137 |                                         |    1 | Using index; Using join buffer |
+----+-------------+-------+--------+---------------------------------+-------------------------------+---------+-----------------------------------------+------+--------------------------------+
|  1 | SIMPLE      | s     | eq_ref | PRIMARY,ezcobj_state_identifier | PRIMARY                       |       4 | revista_tiempo.l.contentobject_state_id |    1 | Using where                    |
+----+-------------+-------+--------+---------------------------------+-------------------------------+---------+-----------------------------------------+------+--------------------------------+

Checking cache generation timeout

UPDATE ezdfsfile SET mtime = 1458578245 WHERE name_hash = MD5('var/tiempo/cache/content/tiempo/1/0/5/4/105481-e95113e75012a10f337778226e13fb4a.cache.generating') AND mtime = 1458578245

dfs::storeContents( 'var/tiempo/cache/content/tiempo/1/0/5/4/105481-e95113e75012a10f337778226e13fb4a.cache.generating' )

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/tiempo/cache/content/tiempo/1/0/5/4/105481-e95113e75012a10f337778226e13fb4a.cache.generating', 'var/tiempo/cache/content/tiempo/1/0/5/4/105481-', 'b2ce751064264c8b549a35019f28ff14', 'viewcache', 2029, 1458578245, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/tiempo/cache/content/tiempo/1/0/5/4/105481-', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Ending cache generation

BEGIN

SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/content/tiempo/1/0/5/4/105481-e95113e75012a10f337778226e13fb4a.cache.generating') FOR UPDATE

SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/content/tiempo/1/0/5/4/105481-e95113e75012a10f337778226e13fb4a.cache') FOR UPDATE

eZClusterFileHandler::cleanupEmptyDirectories( '/ocfsmount/revistas_data/revistas_var/var/tiempo/cache/content/tiempo/1/0/5/4' )

UPDATE ezdfsfile SET mtime = '1458578245', expired = 0, size = '2029' WHERE name_hash=MD5('var/tiempo/cache/content/tiempo/1/0/5/4/105481-e95113e75012a10f337778226e13fb4a.cache')

DELETE FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/content/tiempo/1/0/5/4/105481-e95113e75012a10f337778226e13fb4a.cache.generating')

COMMIT

Creating local copy of the file

Module end 'content'

Missing translation for message in context: 'kernel/navigationpart' with comment: 'Navigation part'. The untranslated message is: 'eZFind'

EXPLAIN
SELECT url, permiso, padre FROM permisos WHERE url LIKE 'espana/%' ORDER BY url DESC

ANALYSIS:
+----+-------------+----------+-------+---------------+-----+---------+-----+------+-------------+
| id | select_type | table    | type  | possible_keys | key | key_len | ref | rows | Extra       |
+----+-------------+----------+-------+---------------+-----+---------+-----+------+-------------+
|  1 | SIMPLE      | permisos | range | url           | url |     767 |     |    1 | Using where |
+----+-------------+----------+-------+---------------+-----+---------+-----+------+-------------+

EXPLAIN
SELECT ezcontentobject.*,
                       ezcontentobject_tree.*,
                       ezcontentclass.serialized_name_list as class_serialized_name_list,
                       ezcontentclass.identifier as class_identifier,
                       ezcontentclass.is_container as is_container
                       , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                FROM ezcontentobject_tree,
                     ezcontentobject,
                     ezcontentclass
                     , ezcontentobject_name 
                WHERE node_id = 2 AND 
                      ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
                      ezcontentclass.version=0  AND
                      ezcontentclass.id = ezcontentobject.contentclass_id
                       AND 
 ezcontentobject.language_mask & 3 > 0 

                       and  ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
                                  ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) )
 )

ANALYSIS:
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
| id | select_type | table                | type  | possible_keys                                                  | key     | key_len | ref         | rows | Extra       |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
|  1 | SIMPLE      | ezcontentobject_tree | const | PRIMARY,ezcontentobject_tree_co_id                             | PRIMARY |       4 | const       |    1 |             |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
|  1 | SIMPLE      | ezcontentobject      | const | PRIMARY,ezcontentobject_classid                                | PRIMARY |       4 | const       |    1 |             |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
|  1 | SIMPLE      | ezcontentclass       | const | PRIMARY,ezcontentclass_version                                 | PRIMARY |       8 | const,const |    1 |             |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
|  1 | SIMPLE      | ezcontentobject_name | ref   | PRIMARY,ezcontentobject_name_co_id,ezcontentobject_name_cov_id | PRIMARY |       8 | const,const |    1 | Using where |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+

dfs::ctor( 'var/tiempo/cache/classidentifiers_130ddb5a4463d808f7d249e05d0196a8.php' )

SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/classidentifiers_130ddb5a4463d808f7d249e05d0196a8.php')

RESULT:
array (
  'datatype' => 'php',
  'name' => 'var/tiempo/cache/classidentifiers_130ddb5a4463d808f7d249e05d0196a8.php',
  'name_trunk' => 'var/tiempo/cache/classidentifiers_130ddb5a4463d808f7d249e05d0196a8.php',
  'name_hash' => 'f685b79f8cd497a52a18e38761631c53',
  'scope' => 'classidentifiers',
  'size' => '2107',
  'mtime' => '1458050874',
  'expired' => '0',
)

Processing local cache file var/tiempo/cache/classidentifiers_130ddb5a4463d808f7d249e05d0196a8.php

EXPLAIN
SELECT id, section_id, owner_id, contentclass_id, name, published, modified,       current_version, status, remote_id, language_mask, initial_language_id
                    FROM   ezcontentobject WHERE  contentclass_id='15' ORDER BY id ASC
LIMIT 0, 1

ANALYSIS:
+----+-------------+-----------------+------+-------------------------+-------------------------+---------+-------+------+-------------+
| id | select_type | table           | type | possible_keys           | key                     | key_len | ref   | rows | Extra       |
+----+-------------+-----------------+------+-------------------------+-------------------------+---------+-------+------+-------------+
|  1 | SIMPLE      | ezcontentobject | ref  | ezcontentobject_classid | ezcontentobject_classid |       4 | const |    1 | Using where |
+----+-------------+-----------------+------+-------------------------+-------------------------+---------+-------+------+-------------+

Could not find: stylesheets/ezflow.css

Could not find: javascript/taptap/jquery.jsmovie.1.4.2.min.js

Could not find: javascript/taptap/adLibrary.min.js

dfs::ctor( 'var/tiempo/cache/template-block/2/2/2/2229110522.cache' )

SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/2/2/2/2229110522.cache')

RESULT:
array (
  'datatype' => 'misc',
  'name' => 'var/tiempo/cache/template-block/2/2/2/2229110522.cache',
  'name_trunk' => 'var/tiempo/cache/template-block/2/2/2/2229110522.cache',
  'name_hash' => '08121a15712e747a2a573bdfd7416d6c',
  'scope' => 'template-block',
  'size' => '549',
  'mtime' => '1458513969',
  'expired' => '0',
)

Processing local cache file var/tiempo/cache/template-block/2/2/2/2229110522.cache

EXPLAIN
SELECT ezcontentobject.*,
                               ezcontentclass.serialized_name_list as serialized_name_list,
                               ezcontentclass.identifier as contentclass_identifier,
                               ezcontentclass.is_container as is_container
                           FROM
                               ezcontentobject,
                               ezcontentclass
                           WHERE
                               ezcontentobject.id='10' AND
                               ezcontentclass.id = ezcontentobject.contentclass_id AND
                               ezcontentclass.version=0

ANALYSIS:
+----+-------------+-----------------+-------+---------------------------------+---------+---------+-------------+------+-------+
| id | select_type | table           | type  | possible_keys                   | key     | key_len | ref         | rows | Extra |
+----+-------------+-----------------+-------+---------------------------------+---------+---------+-------------+------+-------+
|  1 | SIMPLE      | ezcontentobject | const | PRIMARY,ezcontentobject_classid | PRIMARY |       4 | const       |    1 |       |
+----+-------------+-----------------+-------+---------------------------------+---------+---------+-------------+------+-------+
|  1 | SIMPLE      | ezcontentclass  | const | PRIMARY,ezcontentclass_version  | PRIMARY |       8 | const,const |    1 |       |
+----+-------------+-----------------+-------+---------------------------------+---------+---------+-------------+------+-------+

dfs::ctor( 'var/tiempo/cache/template-block/3/8/3/38346368.cache' )

Local file (mtime=1458513969) is older than timestamp () and ttl(7200), check with DB

SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/3/8/3/38346368.cache')

RESULT:
array (
  'datatype' => 'misc',
  'name' => 'var/tiempo/cache/template-block/3/8/3/38346368.cache',
  'name_trunk' => 'var/tiempo/cache/template-block/3/8/3/38346368.cache',
  'name_hash' => 'cf87cf99b1736b1e2366791c50888fd0',
  'scope' => 'template-block',
  'size' => '1635',
  'mtime' => '1458536730',
  'expired' => '0',
)

Database file is deleted, need to regenerate data

Starting cache generation

INSERT INTO ezdfsfile ( name, name_trunk, name_hash, scope, datatype, mtime, expired ) VALUES('var/tiempo/cache/template-block/3/8/3/38346368.cache.generating', 'var/tiempo/cache/template-block/3/8/3/38346368.cache.generating', MD5('var/tiempo/cache/template-block/3/8/3/38346368.cache.generating'), '', '', 1458578245, 0)

EXPLAIN
SELECT url,codigo FROM publicidad_codes WHERE tipo = 0 ORDER BY url DESC

ANALYSIS:
+----+-------------+------------------+------+---------------+------+---------+-------+------+-----------------------------+
| id | select_type | table            | type | possible_keys | key  | key_len | ref   | rows | Extra                       |
+----+-------------+------------------+------+---------------+------+---------+-------+------+-----------------------------+
|  1 | SIMPLE      | publicidad_codes | ref  | tipo          | tipo |       4 | const |    4 | Using where; Using filesort |
+----+-------------+------------------+------+---------------+------+---------+-------+------+-----------------------------+

Missing function definition file for module: usuario

Cannot execute function 'name' in module 'usuario', no valid data

dfs::ctor( 'var/tiempo/cache/classattributeidentifiers_130ddb5a4463d808f7d249e05d0196a8.php' )

SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/classattributeidentifiers_130ddb5a4463d808f7d249e05d0196a8.php')

RESULT:
array (
  'datatype' => 'php',
  'name' => 'var/tiempo/cache/classattributeidentifiers_130ddb5a4463d808f7d249e05d0196a8.php',
  'name_trunk' => 'var/tiempo/cache/classattributeidentifiers_130ddb5a4463d808f7d249e05d0196a8.php',
  'name_hash' => '9e88ffb02100d5b4361aa21bec043196',
  'scope' => 'classattridentifiers',
  'size' => '15166',
  'mtime' => '1458050870',
  'expired' => '0',
)

Processing local cache file var/tiempo/cache/classattributeidentifiers_130ddb5a4463d808f7d249e05d0196a8.php

dfs::ctor( 'var/tiempo/cache/sortkey_130ddb5a4463d808f7d249e05d0196a8.php' )

SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/sortkey_130ddb5a4463d808f7d249e05d0196a8.php')

RESULT:
array (
  'datatype' => 'php',
  'name' => 'var/tiempo/cache/sortkey_130ddb5a4463d808f7d249e05d0196a8.php',
  'name_trunk' => 'var/tiempo/cache/sortkey_130ddb5a4463d808f7d249e05d0196a8.php',
  'name_hash' => '5464cb63973a9167637a3a9ed0b126e0',
  'scope' => 'sortkey',
  'size' => '14357',
  'mtime' => '1458050872',
  'expired' => '0',
)

Processing local cache file var/tiempo/cache/sortkey_130ddb5a4463d808f7d249e05d0196a8.php

dfs::ctor( 'var/tiempo/cache/sortkey_130ddb5a4463d808f7d249e05d0196a8.php' )

Processing local cache file var/tiempo/cache/sortkey_130ddb5a4463d808f7d249e05d0196a8.php

EXPLAIN
SELECT ezcontentobject.*,
                       ezcontentobject_tree.*,
                       ezcontentclass.serialized_name_list as class_serialized_name_list,
                       ezcontentclass.identifier as class_identifier,
                       ezcontentclass.is_container as is_container
                       , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                FROM ezcontentobject_tree,
                     ezcontentobject,
                     ezcontentclass
                     , ezcontentobject_name 
                WHERE node_id = 2 AND 
                      ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
                      ezcontentclass.version=0  AND
                      ezcontentclass.id = ezcontentobject.contentclass_id
                       AND 
 ezcontentobject.language_mask & 3 > 0 

                       and  ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
                                  ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) )
 )

ANALYSIS:
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
| id | select_type | table                | type  | possible_keys                                                  | key     | key_len | ref         | rows | Extra       |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
|  1 | SIMPLE      | ezcontentobject_tree | const | PRIMARY,ezcontentobject_tree_co_id                             | PRIMARY |       4 | const       |    1 |             |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
|  1 | SIMPLE      | ezcontentobject      | const | PRIMARY,ezcontentobject_classid                                | PRIMARY |       4 | const       |    1 |             |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
|  1 | SIMPLE      | ezcontentclass       | const | PRIMARY,ezcontentclass_version                                 | PRIMARY |       8 | const,const |    1 |             |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
|  1 | SIMPLE      | ezcontentobject_name | ref   | PRIMARY,ezcontentobject_name_co_id,ezcontentobject_name_cov_id | PRIMARY |       8 | const,const |    1 | Using where |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+

EXPLAIN
SELECT DISTINCT
                       ezcontentobject.*,
                       ezcontentobject_tree.*,
                       ezcontentclass.serialized_name_list as class_serialized_name_list,
                       ezcontentclass.identifier as class_identifier,
                       ezcontentclass.is_container as is_container
                       
                       , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                       , a0.sort_key_int
                       
                   FROM
                      ezcontentobject_tree,
                      ezcontentobject,ezcontentclass
                      , ezcontentobject_name 
                      , ezcontentobject_attribute a0
                      
                      
                      
                   WHERE
                       ezcontentobject_tree.path_string like '/1/2/%' and  
                      
                      
                                   a0.contentobject_id = ezcontentobject.id AND
                                   a0.contentclassattribute_id = 441 AND
                                   a0.version = ezcontentobject_name.content_version AND
 ( a0.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & a0.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a0.language_id ) ) & 2 ) )
   <
     ( a0.language_id & 1 )
   + ( ( a0.language_id & 2 ) )
 ) 
 AND 
                      
                      ezcontentclass.version=0 AND
                      ezcontentobject_tree.node_id != 2 AND
                      ezcontentobject_tree.contentobject_id = ezcontentobject.id  AND
                      ezcontentclass.id = ezcontentobject.contentclass_id AND
                      
                         ezcontentobject.contentclass_id  IN  ( 62 ) AND
                       ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
                                   ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) )
 ) 

                      AND ezcontentobject_tree.is_invisible = 0
                       AND ((ezcontentobject.section_id in (1)) OR (ezcontentobject.contentclass_id in (28, 29, 33, 35, 36, 37, 52, 53, 73, 88) AND ezcontentobject.section_id in (3))) 
                      
                       AND 
 ezcontentobject.language_mask & 3 > 0 

                 ORDER BY a0.sort_key_int DESC
LIMIT 0, 1

ANALYSIS:
+----+-------------+----------------------+-------+------------------------------------------------------------------------------------------+-----------------------------------------------+---------+----------------------------------------------------------------------------------------------------------+------+---------------------------------+
| id | select_type | table                | type  | possible_keys                                                                            | key                                           | key_len | ref                                                                                                      | rows | Extra                           |
+----+-------------+----------------------+-------+------------------------------------------------------------------------------------------+-----------------------------------------------+---------+----------------------------------------------------------------------------------------------------------+------+---------------------------------+
|  1 | SIMPLE      | ezcontentclass       | const | PRIMARY,ezcontentclass_version                                                           | PRIMARY                                       |       8 | const,const                                                                                              |    1 | Using temporary; Using filesort |
+----+-------------+----------------------+-------+------------------------------------------------------------------------------------------+-----------------------------------------------+---------+----------------------------------------------------------------------------------------------------------+------+---------------------------------+
|  1 | SIMPLE      | ezcontentobject      | ref   | PRIMARY,ezcontentobject_classid                                                          | ezcontentobject_classid                       |       4 | const                                                                                                    |  516 | Using where                     |
+----+-------------+----------------------+-------+------------------------------------------------------------------------------------------+-----------------------------------------------+---------+----------------------------------------------------------------------------------------------------------+------+---------------------------------+
|  1 | SIMPLE      | ezcontentobject_tree | ref   | PRIMARY,ezcontentobject_tree_co_id,ezcontentobject_tree_path                             | ezcontentobject_tree_co_id                    |       5 | revista_tiempo.ezcontentobject.id                                                                        |    1 | Using where                     |
+----+-------------+----------------------+-------+------------------------------------------------------------------------------------------+-----------------------------------------------+---------+----------------------------------------------------------------------------------------------------------+------+---------------------------------+
|  1 | SIMPLE      | ezcontentobject_name | ref   | PRIMARY,ezcontentobject_name_co_id,ezcontentobject_name_cov_id                           | PRIMARY                                       |       8 | revista_tiempo.ezcontentobject.id,revista_tiempo.ezcontentobject_tree.contentobject_version              |    1 | Using where                     |
+----+-------------+----------------------+-------+------------------------------------------------------------------------------------------+-----------------------------------------------+---------+----------------------------------------------------------------------------------------------------------+------+---------------------------------+
|  1 | SIMPLE      | a0                   | ref   | ezcontentobject_attribute_co_id_ver_lang_code,ezcontentobject_attribute_contentobject_id | ezcontentobject_attribute_co_id_ver_lang_code |       8 | revista_tiempo.ezcontentobject_name.contentobject_id,revista_tiempo.ezcontentobject_name.content_version |    4 | Using where                     |
+----+-------------+----------------------+-------+------------------------------------------------------------------------------------------+-----------------------------------------------+---------+----------------------------------------------------------------------------------------------------------+------+---------------------------------+

EXPLAIN
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
                    ezcontentobject_attribute, ezcontentclass_attribute
                  WHERE
                    ezcontentclass_attribute.version = '0' AND
                    ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
                    ( ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '107985' AND
                    ezcontentobject_attribute.language_code = 'esl-ES' )  )
                  ORDER BY
                    ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASC

ANALYSIS:
+----+-------------+---------------------------+--------+----------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------+---------+-------------------------------------------------------------------------+------+----------------------------------------------+
| id | select_type | table                     | type   | possible_keys                                                                                                                    | key                                           | key_len | ref                                                                     | rows | Extra                                        |
+----+-------------+---------------------------+--------+----------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------+---------+-------------------------------------------------------------------------+------+----------------------------------------------+
|  1 | SIMPLE      | ezcontentobject_attribute | ref    | ezcontentobject_attribute_co_id_ver_lang_code,ezcontentobject_attribute_contentobject_id,ezcontentobject_attribute_language_code | ezcontentobject_attribute_co_id_ver_lang_code |      70 | const,const,const                                                       |    9 | Using where; Using temporary; Using filesort |
+----+-------------+---------------------------+--------+----------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------+---------+-------------------------------------------------------------------------+------+----------------------------------------------+
|  1 | SIMPLE      | ezcontentclass_attribute  | eq_ref | PRIMARY                                                                                                                          | PRIMARY                                       |       8 | revista_tiempo.ezcontentobject_attribute.contentclassattribute_id,const |    1 |                                              |
+----+-------------+---------------------------+--------+----------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------+---------+-------------------------------------------------------------------------+------+----------------------------------------------+

EXPLAIN
SELECT ezcontentobject.*,
                               ezcontentclass.serialized_name_list as serialized_name_list,
                               ezcontentclass.identifier as contentclass_identifier,
                               ezcontentclass.is_container as is_container
                           FROM
                               ezcontentobject,
                               ezcontentclass
                           WHERE
                               ezcontentobject.id='107985' AND
                               ezcontentclass.id = ezcontentobject.contentclass_id AND
                               ezcontentclass.version=0

ANALYSIS:
+----+-------------+-----------------+-------+---------------------------------+---------+---------+-------------+------+-------+
| id | select_type | table           | type  | possible_keys                   | key     | key_len | ref         | rows | Extra |
+----+-------------+-----------------+-------+---------------------------------+---------+---------+-------------+------+-------+
|  1 | SIMPLE      | ezcontentobject | const | PRIMARY,ezcontentobject_classid | PRIMARY |       4 | const       |    1 |       |
+----+-------------+-----------------+-------+---------------------------------+---------+---------+-------------+------+-------+
|  1 | SIMPLE      | ezcontentclass  | const | PRIMARY,ezcontentclass_version  | PRIMARY |       8 | const,const |    1 |       |
+----+-------------+-----------------+-------+---------------------------------+---------+---------+-------------+------+-------+

EXPLAIN
SELECT id, serialized_name_list, serialized_description_list, version, contentclass_id, identifier, placement,       is_searchable, is_required, can_translate, is_information_collector, data_type_string, data_int1, data_int2,       data_int3, data_int4, data_float1, data_float2, data_float3, data_float4, data_text1,       data_text2, data_text3, data_text4, data_text5, serialized_data_text, category
                    FROM   ezcontentclass_attribute WHERE  id='437' AND version='0'

ANALYSIS:
+----+-------------+--------------------------+-------+---------------+---------+---------+-------------+------+-------+
| id | select_type | table                    | type  | possible_keys | key     | key_len | ref         | rows | Extra |
+----+-------------+--------------------------+-------+---------------+---------+---------+-------------+------+-------+
|  1 | SIMPLE      | ezcontentclass_attribute | const | PRIMARY       | PRIMARY |       8 | const,const |    1 |       |
+----+-------------+--------------------------+-------+---------------+---------+---------+-------------+------+-------+

EXPLAIN
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:98394', 'eznode:107740' ) AND is_original = 1 AND is_alias=0

ANALYSIS:
+----+-------------+---------------+-------+--------------------------------------------+-----------------------+---------+-----+------+-------------+
| id | select_type | table         | type  | possible_keys                              | key                   | key_len | ref | rows | Extra       |
+----+-------------+---------------+-------+--------------------------------------------+-----------------------+---------+-----+------+-------------+
|  1 | SIMPLE      | ezurlalias_ml | range | ezurlalias_ml_act_org,ezurlalias_ml_action | ezurlalias_ml_act_org |     102 |     |    3 | Using where |
+----+-------------+---------------+-------+--------------------------------------------+-----------------------+---------+-----+------+-------------+

EXPLAIN
SELECT ezcontentobject.*,
                       ezcontentobject_tree.*,
                       ezcontentclass.serialized_name_list as class_serialized_name_list,
                       ezcontentclass.identifier as class_identifier,
                       ezcontentclass.is_container as is_container
                       , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                FROM ezcontentobject_tree,
                     ezcontentobject,
                     ezcontentclass
                     , ezcontentobject_name 
                WHERE node_id = 107741 AND 
                      ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
                      ezcontentclass.version=0  AND
                      ezcontentclass.id = ezcontentobject.contentclass_id
                       AND 
 ezcontentobject.language_mask & 3 > 0 

                       and  ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
                                  ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) )
 )

ANALYSIS:
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
| id | select_type | table                | type  | possible_keys                                                  | key     | key_len | ref         | rows | Extra       |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
|  1 | SIMPLE      | ezcontentobject_tree | const | PRIMARY,ezcontentobject_tree_co_id                             | PRIMARY |       4 | const       |    1 |             |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
|  1 | SIMPLE      | ezcontentobject      | const | PRIMARY,ezcontentobject_classid                                | PRIMARY |       4 | const       |    1 |             |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
|  1 | SIMPLE      | ezcontentclass       | const | PRIMARY,ezcontentclass_version                                 | PRIMARY |       8 | const,const |    1 |             |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
|  1 | SIMPLE      | ezcontentobject_name | ref   | PRIMARY,ezcontentobject_name_co_id,ezcontentobject_name_cov_id | PRIMARY |       8 | const,const |    1 | Using where |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+

EXPLAIN
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:98394', 'eznode:107740' ) AND is_original = 1 AND is_alias=0

ANALYSIS:
+----+-------------+---------------+-------+--------------------------------------------+-----------------------+---------+-----+------+-------------+
| id | select_type | table         | type  | possible_keys                              | key                   | key_len | ref | rows | Extra       |
+----+-------------+---------------+-------+--------------------------------------------+-----------------------+---------+-----+------+-------------+
|  1 | SIMPLE      | ezurlalias_ml | range | ezurlalias_ml_act_org,ezurlalias_ml_action | ezurlalias_ml_act_org |     102 |     |    3 | Using where |
+----+-------------+---------------+-------+--------------------------------------------+-----------------------+---------+-----+------+-------------+

EXPLAIN
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
                    ezcontentobject_attribute, ezcontentclass_attribute, ezcontentobject_version
                  WHERE
                    ezcontentclass_attribute.version = '0' AND
                    ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
                    ezcontentobject_version.contentobject_id = '107986' AND
                    ezcontentobject_version.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '107986' AND                    ezcontentobject_attribute.version = '1' AND                    ezcontentobject_attribute.language_code = 'esl-ES' 
                  
                  ORDER BY
                    ezcontentclass_attribute.placement ASC,
                    ezcontentobject_attribute.language_code ASC

ANALYSIS:
+----+-------------+---------------------------+--------+----------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------+---------+-------------------------------------------------------------------------+------+-----------------------------------------------------------+
| id | select_type | table                     | type   | possible_keys                                                                                                                    | key                                           | key_len | ref                                                                     | rows | Extra                                                     |
+----+-------------+---------------------------+--------+----------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------+---------+-------------------------------------------------------------------------+------+-----------------------------------------------------------+
|  1 | SIMPLE      | ezcontentobject_version   | ref    | idx_object_version_objver                                                                                                        | idx_object_version_objver                     |       9 | const,const                                                             |    1 | Using where; Using index; Using temporary; Using filesort |
+----+-------------+---------------------------+--------+----------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------+---------+-------------------------------------------------------------------------+------+-----------------------------------------------------------+
|  1 | SIMPLE      | ezcontentobject_attribute | ref    | ezcontentobject_attribute_co_id_ver_lang_code,ezcontentobject_attribute_contentobject_id,ezcontentobject_attribute_language_code | ezcontentobject_attribute_co_id_ver_lang_code |      70 | const,const,const                                                       |    7 | Using where                                               |
+----+-------------+---------------------------+--------+----------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------+---------+-------------------------------------------------------------------------+------+-----------------------------------------------------------+
|  1 | SIMPLE      | ezcontentclass_attribute  | eq_ref | PRIMARY                                                                                                                          | PRIMARY                                       |       8 | revista_tiempo.ezcontentobject_attribute.contentclassattribute_id,const |    1 |                                                           |
+----+-------------+---------------------------+--------+----------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------+---------+-------------------------------------------------------------------------+------+-----------------------------------------------------------+

EXPLAIN
SELECT id, serialized_name_list, serialized_description_list, version, contentclass_id, identifier, placement,       is_searchable, is_required, can_translate, is_information_collector, data_type_string, data_int1, data_int2,       data_int3, data_int4, data_float1, data_float2, data_float3, data_float4, data_text1,       data_text2, data_text3, data_text4, data_text5, serialized_data_text, category
                    FROM   ezcontentclass_attribute WHERE  id='393' AND version='0'

ANALYSIS:
+----+-------------+--------------------------+-------+---------------+---------+---------+-------------+------+-------+
| id | select_type | table                    | type  | possible_keys | key     | key_len | ref         | rows | Extra |
+----+-------------+--------------------------+-------+---------------+---------+---------+-------------+------+-------+
|  1 | SIMPLE      | ezcontentclass_attribute | const | PRIMARY       | PRIMARY |       8 | const,const |    1 |       |
+----+-------------+--------------------------+-------+---------------+---------+---------+-------------+------+-------+

dfs::ctor( 'var/tiempo/storage/images/media/imagenes-y-videos/imagenes-sumarios/numero-1739/1081953-1-esl-ES/numero-1739.jpg' )

dfs::exists( 'var/tiempo/storage/images/media/imagenes-y-videos/imagenes-sumarios/numero-1739/1081953-1-esl-ES/numero-1739.jpg' )

SQL for _selectOneAssoc:
SELECT name, mtime FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/storage/images/media/imagenes-y-videos/imagenes-sumarios/numero-1739/1081953-1-esl-ES/numero-1739.jpg')

RESULT:
array (
  0 => 'var/tiempo/storage/images/media/imagenes-y-videos/imagenes-sumarios/numero-1739/1081953-1-esl-ES/numero-1739.jpg',
  1 => '1458287897',
)

dfs::size()

SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/storage/images/media/imagenes-y-videos/imagenes-sumarios/numero-1739/1081953-1-esl-ES/numero-1739.jpg')

RESULT:
array (
  'datatype' => 'image/jpeg',
  'name' => 'var/tiempo/storage/images/media/imagenes-y-videos/imagenes-sumarios/numero-1739/1081953-1-esl-ES/numero-1739.jpg',
  'name_trunk' => 'var/tiempo/storage/images/media/imagenes-y-videos/imagenes-sumarios/numero-1739/1081953-1-esl-ES/numero-1739.jpg',
  'name_hash' => 'f640ec13f998b0846d26e325aaab72c2',
  'scope' => 'image',
  'size' => '629857',
  'mtime' => '1458287897',
  'expired' => '0',
)

dfs::ctor( 'var/tiempo/storage/images/media/imagenes-y-videos/imagenes-sumarios/numero-1739/1081953-1-esl-ES/numero-1739_sumariobloque_tiempo.jpg' )

dfs::exists( 'var/tiempo/storage/images/media/imagenes-y-videos/imagenes-sumarios/numero-1739/1081953-1-esl-ES/numero-1739_sumariobloque_tiempo.jpg' )

SQL for _selectOneAssoc:
SELECT name, mtime FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/storage/images/media/imagenes-y-videos/imagenes-sumarios/numero-1739/1081953-1-esl-ES/numero-1739_sumariobloque_tiempo.jpg')

RESULT:
array (
  0 => 'var/tiempo/storage/images/media/imagenes-y-videos/imagenes-sumarios/numero-1739/1081953-1-esl-ES/numero-1739_sumariobloque_tiempo.jpg',
  1 => '1458287904',
)

dfs::size()

SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/storage/images/media/imagenes-y-videos/imagenes-sumarios/numero-1739/1081953-1-esl-ES/numero-1739_sumariobloque_tiempo.jpg')

RESULT:
array (
  'datatype' => 'image/jpeg',
  'name' => 'var/tiempo/storage/images/media/imagenes-y-videos/imagenes-sumarios/numero-1739/1081953-1-esl-ES/numero-1739_sumariobloque_tiempo.jpg',
  'name_trunk' => 'var/tiempo/storage/images/media/imagenes-y-videos/imagenes-sumarios/numero-1739/1081953-1-esl-ES/numero-1739_sumariobloque_tiempo.jpg',
  'name_hash' => '46058cc7d2b30c31739af93d917232ea',
  'scope' => 'image',
  'size' => '59908',
  'mtime' => '1458287904',
  'expired' => '0',
)

dfs::ctor( 'var/tiempo/storage/images/media/imagenes-y-videos/imagenes-sumarios/numero-1739/1081953-1-esl-ES/numero-1739_sumario.jpg' )

dfs::exists( 'var/tiempo/storage/images/media/imagenes-y-videos/imagenes-sumarios/numero-1739/1081953-1-esl-ES/numero-1739_sumario.jpg' )

SQL for _selectOneAssoc:
SELECT name, mtime FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/storage/images/media/imagenes-y-videos/imagenes-sumarios/numero-1739/1081953-1-esl-ES/numero-1739_sumario.jpg')

RESULT:
array (
  0 => 'var/tiempo/storage/images/media/imagenes-y-videos/imagenes-sumarios/numero-1739/1081953-1-esl-ES/numero-1739_sumario.jpg',
  1 => '1458288155',
)

dfs::size()

SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/storage/images/media/imagenes-y-videos/imagenes-sumarios/numero-1739/1081953-1-esl-ES/numero-1739_sumario.jpg')

RESULT:
array (
  'datatype' => 'image/jpeg',
  'name' => 'var/tiempo/storage/images/media/imagenes-y-videos/imagenes-sumarios/numero-1739/1081953-1-esl-ES/numero-1739_sumario.jpg',
  'name_trunk' => 'var/tiempo/storage/images/media/imagenes-y-videos/imagenes-sumarios/numero-1739/1081953-1-esl-ES/numero-1739_sumario.jpg',
  'name_hash' => '72d17e89e9af181cd4c8526642d46ebe',
  'scope' => 'image',
  'size' => '106341',
  'mtime' => '1458288155',
  'expired' => '0',
)

dfs::ctor( 'var/tiempo/storage/images/media/imagenes-y-videos/imagenes-sumarios/numero-1739/1081953-1-esl-ES/numero-1739_bloque_articulo.jpg' )

dfs::exists( 'var/tiempo/storage/images/media/imagenes-y-videos/imagenes-sumarios/numero-1739/1081953-1-esl-ES/numero-1739_bloque_articulo.jpg' )

SQL for _selectOneAssoc:
SELECT name, mtime FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/storage/images/media/imagenes-y-videos/imagenes-sumarios/numero-1739/1081953-1-esl-ES/numero-1739_bloque_articulo.jpg')

RESULT:
array (
  0 => 'var/tiempo/storage/images/media/imagenes-y-videos/imagenes-sumarios/numero-1739/1081953-1-esl-ES/numero-1739_bloque_articulo.jpg',
  1 => '1458291991',
)

dfs::size()

SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/storage/images/media/imagenes-y-videos/imagenes-sumarios/numero-1739/1081953-1-esl-ES/numero-1739_bloque_articulo.jpg')

RESULT:
array (
  'datatype' => 'image/jpeg',
  'name' => 'var/tiempo/storage/images/media/imagenes-y-videos/imagenes-sumarios/numero-1739/1081953-1-esl-ES/numero-1739_bloque_articulo.jpg',
  'name_trunk' => 'var/tiempo/storage/images/media/imagenes-y-videos/imagenes-sumarios/numero-1739/1081953-1-esl-ES/numero-1739_bloque_articulo.jpg',
  'name_hash' => 'bc9d1f31e041baf3e20a57a01574384e',
  'scope' => 'image',
  'size' => '61534',
  'mtime' => '1458291991',
  'expired' => '0',
)

Checking cache generation timeout

UPDATE ezdfsfile SET mtime = 1458578245 WHERE name_hash = MD5('var/tiempo/cache/template-block/3/8/3/38346368.cache.generating') AND mtime = 1458578245

dfs::storeContents( 'var/tiempo/cache/template-block/3/8/3/38346368.cache.generating' )

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/tiempo/cache/template-block/3/8/3/38346368.cache.generating', 'var/tiempo/cache/template-block/3/8/3/38346368.cache.generating', '54ada5d04477f8b047dd1071a2f500ba', 'template-block', 1635, 1458578245, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/tiempo/cache/template-block/3/8/3/38346368.cache.generating', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Ending cache generation

BEGIN

SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/3/8/3/38346368.cache.generating') FOR UPDATE

SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/3/8/3/38346368.cache') FOR UPDATE

eZClusterFileHandler::cleanupEmptyDirectories( '/ocfsmount/revistas_data/revistas_var/var/tiempo/cache/template-block/3/8/3' )

UPDATE ezdfsfile SET mtime = '1458578245', expired = 0, size = '1635' WHERE name_hash=MD5('var/tiempo/cache/template-block/3/8/3/38346368.cache')

DELETE FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/3/8/3/38346368.cache.generating')

COMMIT

Creating local copy of the file

dfs::ctor( 'var/tiempo/cache/template-block/3/4/0/3403941913.cache' )

SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/3/4/0/3403941913.cache')

RESULT:
array (
  'datatype' => 'misc',
  'name' => 'var/tiempo/cache/template-block/3/4/0/3403941913.cache',
  'name_trunk' => 'var/tiempo/cache/template-block/3/4/0/3403941913.cache',
  'name_hash' => 'fc6c4c04233f5a35ad1954a3c2a0ef9b',
  'scope' => 'template-block',
  'size' => '4006',
  'mtime' => '1458571909',
  'expired' => '0',
)

Processing local cache file var/tiempo/cache/template-block/3/4/0/3403941913.cache

dfs::ctor( 'var/tiempo/cache/template-block/1/6/7/1678583239.cache' )

SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/1/6/7/1678583239.cache')

RESULT:
array (
  'datatype' => 'misc',
  'name' => 'var/tiempo/cache/template-block/1/6/7/1678583239.cache',
  'name_trunk' => 'var/tiempo/cache/template-block/1/6/7/1678583239.cache',
  'name_hash' => '0fcd21554071057fc6d1b042e78f143e',
  'scope' => 'template-block',
  'size' => '1437',
  'mtime' => '1458513969',
  'expired' => '0',
)

Processing local cache file var/tiempo/cache/template-block/1/6/7/1678583239.cache

EXPLAIN
SELECT id, section_id, owner_id, contentclass_id, name, published, modified,       current_version, status, remote_id, language_mask, initial_language_id
                    FROM   ezcontentobject WHERE  contentclass_id='15' ORDER BY id ASC
LIMIT 0, 1

ANALYSIS:
+----+-------------+-----------------+------+-------------------------+-------------------------+---------+-------+------+-------------+
| id | select_type | table           | type | possible_keys           | key                     | key_len | ref   | rows | Extra       |
+----+-------------+-----------------+------+-------------------------+-------------------------+---------+-------+------+-------------+
|  1 | SIMPLE      | ezcontentobject | ref  | ezcontentobject_classid | ezcontentobject_classid |       4 | const |    1 | Using where |
+----+-------------+-----------------+------+-------------------------+-------------------------+---------+-------+------+-------------+

EXPLAIN
SELECT id, section_id, owner_id, contentclass_id, name, published, modified,       current_version, status, remote_id, language_mask, initial_language_id
                    FROM   ezcontentobject WHERE  contentclass_id='15' ORDER BY id ASC
LIMIT 0, 1

ANALYSIS:
+----+-------------+-----------------+------+-------------------------+-------------------------+---------+-------+------+-------------+
| id | select_type | table           | type | possible_keys           | key                     | key_len | ref   | rows | Extra       |
+----+-------------+-----------------+------+-------------------------+-------------------------+---------+-------+------+-------------+
|  1 | SIMPLE      | ezcontentobject | ref  | ezcontentobject_classid | ezcontentobject_classid |       4 | const |    1 | Using where |
+----+-------------+-----------------+------+-------------------------+-------------------------+---------+-------+------+-------------+

dfs::ctor( 'var/tiempo/cache/template-block/subtree/2/cache/2/1/6/2167098841.cache' )

EXPLAIN
SELECT modified_subnode FROM ezcontentobject_tree WHERE node_id=2

ANALYSIS:
+----+-------------+----------------------+-------+---------------+---------+---------+-------+------+-------+
| id | select_type | table                | type  | possible_keys | key     | key_len | ref   | rows | Extra |
+----+-------------+----------------------+-------+---------------+---------+---------+-------+------+-------+
|  1 | SIMPLE      | ezcontentobject_tree | const | PRIMARY       | PRIMARY |       4 | const |    1 |       |
+----+-------------+----------------------+-------+---------------+---------+---------+-------+------+-------+

Local file (mtime=1458513969) is older than timestamp (1458561974) and ttl(7200), check with DB

SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/subtree/2/cache/2/1/6/2167098841.cache')

RESULT:
array (
  'datatype' => 'misc',
  'name' => 'var/tiempo/cache/template-block/subtree/2/cache/2/1/6/2167098841.cache',
  'name_trunk' => 'var/tiempo/cache/template-block/subtree/2/cache/',
  'name_hash' => 'c86d2c06447c9846214ee3c182f83be2',
  'scope' => 'template-block',
  'size' => '211',
  'mtime' => '1458536731',
  'expired' => '0',
)

Database file is deleted, need to regenerate data

Starting cache generation

INSERT INTO ezdfsfile ( name, name_trunk, name_hash, scope, datatype, mtime, expired ) VALUES('var/tiempo/cache/template-block/subtree/2/cache/2/1/6/2167098841.cache.generating', 'var/tiempo/cache/template-block/subtree/2/cache/2/1/6/2167098841.cache.generating', MD5('var/tiempo/cache/template-block/subtree/2/cache/2/1/6/2167098841.cache.generating'), '', '', 1458578245, 0)

EXPLAIN
SELECT ezcontentobject.*,
                       ezcontentobject_tree.*,
                       ezcontentclass.serialized_name_list as class_serialized_name_list,
                       ezcontentclass.identifier as class_identifier,
                       ezcontentclass.is_container as is_container
                       , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                FROM ezcontentobject_tree,
                     ezcontentobject,
                     ezcontentclass
                     , ezcontentobject_name 
                WHERE node_id = 2 AND 
                      ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
                      ezcontentclass.version=0  AND
                      ezcontentclass.id = ezcontentobject.contentclass_id
                       AND 
 ezcontentobject.language_mask & 3 > 0 

                       and  ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
                                  ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) )
 )

ANALYSIS:
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
| id | select_type | table                | type  | possible_keys                                                  | key     | key_len | ref         | rows | Extra       |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
|  1 | SIMPLE      | ezcontentobject_tree | const | PRIMARY,ezcontentobject_tree_co_id                             | PRIMARY |       4 | const       |    1 |             |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
|  1 | SIMPLE      | ezcontentobject      | const | PRIMARY,ezcontentobject_classid                                | PRIMARY |       4 | const       |    1 |             |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
|  1 | SIMPLE      | ezcontentclass       | const | PRIMARY,ezcontentclass_version                                 | PRIMARY |       8 | const,const |    1 |             |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
|  1 | SIMPLE      | ezcontentobject_name | ref   | PRIMARY,ezcontentobject_name_co_id,ezcontentobject_name_cov_id | PRIMARY |       8 | const,const |    1 | Using where |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+

EXPLAIN
SELECT ezcontentobject.*,
                       ezcontentobject_tree.*,
                       ezcontentclass.serialized_name_list as class_serialized_name_list,
                       ezcontentclass.identifier as class_identifier,
                       ezcontentclass.is_container as is_container
                       , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                FROM ezcontentobject_tree,
                     ezcontentobject,
                     ezcontentclass
                     , ezcontentobject_name 
                WHERE node_id = 80 AND 
                      ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
                      ezcontentclass.version=0  AND
                      ezcontentclass.id = ezcontentobject.contentclass_id
                       AND 
 ezcontentobject.language_mask & 3 > 0 

                       and  ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
                                  ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) )
 )

ANALYSIS:
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
| id | select_type | table                | type  | possible_keys                                                  | key     | key_len | ref         | rows | Extra       |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
|  1 | SIMPLE      | ezcontentobject_tree | const | PRIMARY,ezcontentobject_tree_co_id                             | PRIMARY |       4 | const       |    1 |             |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
|  1 | SIMPLE      | ezcontentobject      | const | PRIMARY,ezcontentobject_classid                                | PRIMARY |       4 | const       |    1 |             |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
|  1 | SIMPLE      | ezcontentclass       | const | PRIMARY,ezcontentclass_version                                 | PRIMARY |       8 | const,const |    1 |             |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
|  1 | SIMPLE      | ezcontentobject_name | ref   | PRIMARY,ezcontentobject_name_co_id,ezcontentobject_name_cov_id | PRIMARY |       8 | const,const |    1 | Using where |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+

EXPLAIN
SELECT ezcontentobject.*,
                       ezcontentobject_tree.*,
                       ezcontentclass.serialized_name_list as class_serialized_name_list,
                       ezcontentclass.identifier as class_identifier,
                       ezcontentclass.is_container as is_container
                       , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                FROM ezcontentobject_tree,
                     ezcontentobject,
                     ezcontentclass
                     , ezcontentobject_name 
                WHERE node_id = 105481 AND 
                      ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
                      ezcontentclass.version=0  AND
                      ezcontentclass.id = ezcontentobject.contentclass_id
                       AND 
 ezcontentobject.language_mask & 3 > 0 

                       and  ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
                                  ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) )
 )

ANALYSIS:
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
| id | select_type | table                | type  | possible_keys                                                  | key     | key_len | ref         | rows | Extra       |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
|  1 | SIMPLE      | ezcontentobject_tree | const | PRIMARY,ezcontentobject_tree_co_id                             | PRIMARY |       4 | const       |    1 |             |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
|  1 | SIMPLE      | ezcontentobject      | const | PRIMARY,ezcontentobject_classid                                | PRIMARY |       4 | const       |    1 |             |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
|  1 | SIMPLE      | ezcontentclass       | const | PRIMARY,ezcontentclass_version                                 | PRIMARY |       8 | const,const |    1 |             |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
|  1 | SIMPLE      | ezcontentobject_name | ref   | PRIMARY,ezcontentobject_name_co_id,ezcontentobject_name_cov_id | PRIMARY |       8 | const,const |    1 | Using where |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+

Checking cache generation timeout

UPDATE ezdfsfile SET mtime = 1458578245 WHERE name_hash = MD5('var/tiempo/cache/template-block/subtree/2/cache/2/1/6/2167098841.cache.generating') AND mtime = 1458578245

dfs::storeContents( 'var/tiempo/cache/template-block/subtree/2/cache/2/1/6/2167098841.cache.generating' )

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/tiempo/cache/template-block/subtree/2/cache/2/1/6/2167098841.cache.generating', 'var/tiempo/cache/template-block/subtree/2/cache/', '6145979edaef519e3f89c491f82bbae2', 'template-block', 211, 1458578245, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/tiempo/cache/template-block/subtree/2/cache/', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Ending cache generation

BEGIN

SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/subtree/2/cache/2/1/6/2167098841.cache.generating') FOR UPDATE

SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/subtree/2/cache/2/1/6/2167098841.cache') FOR UPDATE

eZClusterFileHandler::cleanupEmptyDirectories( '/ocfsmount/revistas_data/revistas_var/var/tiempo/cache/template-block/subtree/2/cache/2/1/6' )

UPDATE ezdfsfile SET mtime = '1458578245', expired = 0, size = '211' WHERE name_hash=MD5('var/tiempo/cache/template-block/subtree/2/cache/2/1/6/2167098841.cache')

DELETE FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/subtree/2/cache/2/1/6/2167098841.cache.generating')

COMMIT

Creating local copy of the file

EXPLAIN
SELECT id, section_id, owner_id, contentclass_id, name, published, modified,       current_version, status, remote_id, language_mask, initial_language_id
                    FROM   ezcontentobject WHERE  contentclass_id='15' ORDER BY id ASC
LIMIT 0, 1

ANALYSIS:
+----+-------------+-----------------+------+-------------------------+-------------------------+---------+-------+------+-------------+
| id | select_type | table           | type | possible_keys           | key                     | key_len | ref   | rows | Extra       |
+----+-------------+-----------------+------+-------------------------+-------------------------+---------+-------+------+-------------+
|  1 | SIMPLE      | ezcontentobject | ref  | ezcontentobject_classid | ezcontentobject_classid |       4 | const |    1 | Using where |
+----+-------------+-----------------+------+-------------------------+-------------------------+---------+-------+------+-------------+

dfs::ctor( 'var/tiempo/cache/template-block/3/9/4/394445926.cache' )

SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/3/9/4/394445926.cache')

RESULT:
array (
  'datatype' => 'misc',
  'name' => 'var/tiempo/cache/template-block/3/9/4/394445926.cache',
  'name_trunk' => 'var/tiempo/cache/template-block/3/9/4/394445926.cache',
  'name_hash' => '8560871ccd8c4450a20eb37ca7bc06e3',
  'scope' => 'template-block',
  'size' => '1033',
  'mtime' => '1458513969',
  'expired' => '0',
)

Processing local cache file var/tiempo/cache/template-block/3/9/4/394445926.cache

dfs::ctor( 'var/tiempo/cache/template-block/3/8/0/3805626181.cache' )

SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/3/8/0/3805626181.cache')

RESULT:
array (
  'datatype' => 'misc',
  'name' => 'var/tiempo/cache/template-block/3/8/0/3805626181.cache',
  'name_trunk' => 'var/tiempo/cache/template-block/3/8/0/3805626181.cache',
  'name_hash' => 'b5083423780adf1f189f97090bab63bd',
  'scope' => 'template-block',
  'size' => '2976',
  'mtime' => '1458571639',
  'expired' => '0',
)

Processing local cache file var/tiempo/cache/template-block/3/8/0/3805626181.cache

End