|
|
SET NAMES 'utf8'
|
EXPLAIN
SELECT data, user_id, expiration_time FROM ezsession WHERE session_key='htn970ef9ksml0i9ssh4gvust0'
ANALYSIS:
+----+-------------+-----------+-------+---------------+---------+---------+-------+------+-------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-----------+-------+---------------+---------+---------+-------+------+-------+
| 1 | SIMPLE | ezsession | const | PRIMARY | PRIMARY | 98 | const | 1 | |
+----+-------------+-----------+-------+---------------+---------+---------+-------+------+-------+
|
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.alias_redirects AS e1_alias_redirects, e2.id AS e2_id, e2.link AS e2_link, e2.text AS e2_text, e2.text_md5 AS e2_text_md5, e2.is_alias AS e2_is_alias, e2.alias_redirects AS e2_alias_redirects, e3.id AS e3_id, e3.link AS e3_link, e3.text AS e3_text, e3.text_md5 AS e3_text_md5, e3.is_alias AS e3_is_alias, e3.alias_redirects AS e3_alias_redirects, e4.id AS e4_id, e4.link AS e4_link, e4.text AS e4_text, e4.text_md5 AS e4_text_md5, e4.is_alias AS e4_is_alias, e4.alias_redirects AS e4_alias_redirects, e5.id AS e5_id, e5.link AS e5_link, e5.text AS e5_text, e5.text_md5 AS e5_text_md5, e5.is_alias AS e5_is_alias, e5.alias_redirects AS e5_alias_redirects, e6.id AS e6_id, e6.link AS e6_link, e6.text AS e6_text, e6.text_md5 AS e6_text_md5, e6.is_alias AS e6_is_alias, e6.alias_redirects AS e6_alias_redirects, e7.id AS e7_id, e7.link AS e7_link, e7.text AS e7_text, e7.text_md5 AS e7_text_md5, e7.is_alias AS e7_is_alias, e7.action AS e7_action, e7.alias_redirects AS e7_alias_redirects FROM ezurlalias_ml e0, ezurlalias_ml e1, ezurlalias_ml e2, ezurlalias_ml e3, ezurlalias_ml e4, ezurlalias_ml e5, ezurlalias_ml e6, ezurlalias_ml e7 WHERE e0.parent = 0 AND (e0.lang_mask & 3 > 0) AND e0.text_md5 = MD5( 'visual' ) AND e1.parent = e0.link AND (e1.lang_mask & 3 > 0) AND e1.text_md5 = MD5( 'templateedit' ) AND e2.parent = e1.link AND (e2.lang_mask & 3 > 0) AND e2.text_md5 = MD5( 'design' ) AND e3.parent = e2.link AND (e3.lang_mask & 3 > 0) AND e3.text_md5 = MD5( 'general' ) AND e4.parent = e3.link AND (e4.lang_mask & 3 > 0) AND e4.text_md5 = MD5( 'override' ) AND e5.parent = e4.link AND (e5.lang_mask & 3 > 0) AND e5.text_md5 = MD5( 'templates' ) AND e6.parent = e5.link AND (e6.lang_mask & 3 > 0) AND e6.text_md5 = MD5( 'embed' ) AND e7.parent = e6.link AND (e7.lang_mask & 3 > 0) AND e7.text_md5 = MD5( 'image.tpl' )
LIMIT 0, 1
ANALYSIS:
+----+-------------+-------+------+---------------+-----+---------+-----+------+-----------------------------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------+------+---------------+-----+---------+-----+------+-----------------------------------------------------+
| 1 | SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
+----+-------------+-------+------+---------------+-----+---------+-----+------+-----------------------------------------------------+
|
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' => '305',
'mtime' => '1458460055',
'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
|
Module start 'visual'
|
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
|
Error ocurred using URI: /visual/templateedit/design/general/override/templates/embed/image.tpl/(siteAccess)/tiempo
|
Unknown get variable 'accesorestringido'
|
Unknown session variable 'LastAccessesURI'
|
SELECT COUNT( * ) AS row_count
FROM ngconnect WHERE user_id='10' AND login_method='facebook'
|
Query error: Table 'revista_tiempo.ngconnect' doesn't exist. Query: SELECT COUNT( * ) AS row_count
FROM ngconnect WHERE user_id='10' AND login_method='facebook'
|
mysql_query(): Query error: Table 'revista_tiempo.ngconnect' doesn't exist. Query: SELECT COUNT( * ) AS row_count
FROM ngconnect WHERE user_id='10' AND login_method='facebook' in /var/www/html/revistas/lib/ezdb/classes/ezmysqldb.php on line 433
|
SELECT COUNT( * ) AS row_count
FROM ngconnect WHERE user_id='10' AND login_method='facebook'
|
EXPLAIN
SELECT contentobject_id, login, email, password_hash, password_hash_type
FROM ezuser WHERE contentobject_id='10'
ANALYSIS:
+----+-------------+--------+-------+---------------+---------+---------+-------+------+-------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+--------+-------+---------------+---------+---------+-------+------+-------+
| 1 | SIMPLE | ezuser | const | PRIMARY | PRIMARY | 4 | const | 1 | |
+----+-------------+--------+-------+---------------+---------+---------+-------+------+-------+
|
Function required:
Module : visual
Function :
ClassID :
MainNodeID :
Policies that didn't match:
|
Module end 'error'
|
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 'visual/%' 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/3/6/3/3638699054.cache' )
|
Local file (mtime=) is older than timestamp () and ttl(86400), check with DB
|
SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/3/6/3/3638699054.cache')
RESULT:
false
|
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/6/3/3638699054.cache.generating', 'var/tiempo/cache/template-block/3/6/3/3638699054.cache.generating', MD5('var/tiempo/cache/template-block/3/6/3/3638699054.cache.generating'), '', '', 1458461466, 0)
|
Undefined index: url_alias in /var/www/html/revistas/extension/web/autoloads/zetatemplateoperators.php on line 86
|
EXPLAIN
SELECT url,codigo FROM publicidad_codes WHERE tipo = 7 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 |
+----+-------------+------------------+------+---------------+------+---------+-------+------+-----------------------------+
|
Checking cache generation timeout
|
UPDATE ezdfsfile SET mtime = 1458461466 WHERE name_hash = MD5('var/tiempo/cache/template-block/3/6/3/3638699054.cache.generating') AND mtime = 1458461466
|
dfs::storeContents( 'var/tiempo/cache/template-block/3/6/3/3638699054.cache.generating' )
|
BEGIN
|
INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/tiempo/cache/template-block/3/6/3/3638699054.cache.generating', 'var/tiempo/cache/template-block/3/6/3/3638699054.cache.generating', '9bbfa9ba2b0910138d1744bc5948b9a7', 'template-block', 549, 1458461466, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/tiempo/cache/template-block/3/6/3/3638699054.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/6/3/3638699054.cache.generating') FOR UPDATE
|
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/3/6/3/3638699054.cache') FOR UPDATE
|
INSERT INTO ezdfsfile ( datatype, name, name_trunk, name_hash, scope, size, mtime, expired ) VALUES( 'misc', 'var/tiempo/cache/template-block/3/6/3/3638699054.cache', 'var/tiempo/cache/template-block/3/6/3/3638699054.cache', '27ca9fcf2204eb45348f82a4b8b8c259', 'template-block', '549', '1458461466', '0')
|
eZClusterFileHandler::cleanupEmptyDirectories( '/ocfsmount/revistas_data/revistas_var/var/tiempo/cache/template-block/3/6/3' )
|
DELETE FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/3/6/3/3638699054.cache.generating')
|
COMMIT
|
Creating local copy of the file
|
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/2/3/9/2390641968.cache' )
|
Local file (mtime=) 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/2/3/9/2390641968.cache')
RESULT:
false
|
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/2/3/9/2390641968.cache.generating', 'var/tiempo/cache/template-block/2/3/9/2390641968.cache.generating', MD5('var/tiempo/cache/template-block/2/3/9/2390641968.cache.generating'), '', '', 1458461466, 0)
|
Undefined index: url_alias in /var/www/html/revistas/extension/web/autoloads/zetatemplateoperators.php on line 86
|
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 | 1 | 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 = 1458461466 WHERE name_hash = MD5('var/tiempo/cache/template-block/2/3/9/2390641968.cache.generating') AND mtime = 1458461466
|
dfs::storeContents( 'var/tiempo/cache/template-block/2/3/9/2390641968.cache.generating' )
|
BEGIN
|
INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/tiempo/cache/template-block/2/3/9/2390641968.cache.generating', 'var/tiempo/cache/template-block/2/3/9/2390641968.cache.generating', '74610b62d0e19590ebe817cca02790dc', 'template-block', 1637, 1458461466, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/tiempo/cache/template-block/2/3/9/2390641968.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/2/3/9/2390641968.cache.generating') FOR UPDATE
|
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/2/3/9/2390641968.cache') FOR UPDATE
|
INSERT INTO ezdfsfile ( datatype, name, name_trunk, name_hash, scope, size, mtime, expired ) VALUES( 'misc', 'var/tiempo/cache/template-block/2/3/9/2390641968.cache', 'var/tiempo/cache/template-block/2/3/9/2390641968.cache', '1ce81f033a1a3057d9924f26e89392b2', 'template-block', '1637', '1458461466', '0')
|
eZClusterFileHandler::cleanupEmptyDirectories( '/ocfsmount/revistas_data/revistas_var/var/tiempo/cache/template-block/2/3/9' )
|
DELETE FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/2/3/9/2390641968.cache.generating')
|
COMMIT
|
Creating local copy of the file
|
dfs::ctor( 'var/tiempo/cache/template-block/3/9/2/392952519.cache' )
|
SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/3/9/2/392952519.cache')
RESULT:
array (
'datatype' => 'misc',
'name' => 'var/tiempo/cache/template-block/3/9/2/392952519.cache',
'name_trunk' => 'var/tiempo/cache/template-block/3/9/2/392952519.cache',
'name_hash' => 'e8128dba847f62b41631855f8ee29144',
'scope' => 'template-block',
'size' => '3986',
'mtime' => '1458456382',
'expired' => '0',
)
|
Processing local cache file var/tiempo/cache/template-block/3/9/2/392952519.cache
|
dfs::ctor( 'var/tiempo/cache/template-block/9/4/2/942835475.cache' )
|
Local file (mtime=) is older than timestamp () and ttl(86400), check with DB
|
SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/9/4/2/942835475.cache')
RESULT:
false
|
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/9/4/2/942835475.cache.generating', 'var/tiempo/cache/template-block/9/4/2/942835475.cache.generating', MD5('var/tiempo/cache/template-block/9/4/2/942835475.cache.generating'), '', '', 1458461467, 0)
|
Undefined index: url_alias in /var/www/html/revistas/extension/web/autoloads/zetatemplateoperators.php on line 86
|
EXPLAIN
SELECT url,codigo FROM publicidad_codes WHERE tipo = 3 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 | 2 | Using where; Using filesort |
+----+-------------+------------------+------+---------------+------+---------+-------+------+-----------------------------+
|
Checking cache generation timeout
|
UPDATE ezdfsfile SET mtime = 1458461467 WHERE name_hash = MD5('var/tiempo/cache/template-block/9/4/2/942835475.cache.generating') AND mtime = 1458461467
|
dfs::storeContents( 'var/tiempo/cache/template-block/9/4/2/942835475.cache.generating' )
|
BEGIN
|
INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/tiempo/cache/template-block/9/4/2/942835475.cache.generating', 'var/tiempo/cache/template-block/9/4/2/942835475.cache.generating', 'a3c6706ebe2fd7acb3aa45a1335fc6b9', 'template-block', 1437, 1458461467, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/tiempo/cache/template-block/9/4/2/942835475.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/9/4/2/942835475.cache.generating') FOR UPDATE
|
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/9/4/2/942835475.cache') FOR UPDATE
|
INSERT INTO ezdfsfile ( datatype, name, name_trunk, name_hash, scope, size, mtime, expired ) VALUES( 'misc', 'var/tiempo/cache/template-block/9/4/2/942835475.cache', 'var/tiempo/cache/template-block/9/4/2/942835475.cache', '446dc508901fd74115c81a101c1fbb0e', 'template-block', '1437', '1458461467', '0')
|
eZClusterFileHandler::cleanupEmptyDirectories( '/ocfsmount/revistas_data/revistas_var/var/tiempo/cache/template-block/9/4/2' )
|
DELETE FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/9/4/2/942835475.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/7/0/3709136653.cache' )
|
Local file (mtime=) 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/7/0/3709136653.cache')
RESULT:
false
|
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/7/0/3709136653.cache.generating', 'var/tiempo/cache/template-block/3/7/0/3709136653.cache.generating', MD5('var/tiempo/cache/template-block/3/7/0/3709136653.cache.generating'), '', '', 1458461467, 0)
|
Checking cache generation timeout
|
UPDATE ezdfsfile SET mtime = 1458461467 WHERE name_hash = MD5('var/tiempo/cache/template-block/3/7/0/3709136653.cache.generating') AND mtime = 1458461467
|
dfs::storeContents( 'var/tiempo/cache/template-block/3/7/0/3709136653.cache.generating' )
|
BEGIN
|
INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/tiempo/cache/template-block/3/7/0/3709136653.cache.generating', 'var/tiempo/cache/template-block/3/7/0/3709136653.cache.generating', 'dc34163c1dd3fe43edcc42b345d504b8', 'template-block', 43, 1458461467, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/tiempo/cache/template-block/3/7/0/3709136653.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/7/0/3709136653.cache.generating') FOR UPDATE
|
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/3/7/0/3709136653.cache') FOR UPDATE
|
INSERT INTO ezdfsfile ( datatype, name, name_trunk, name_hash, scope, size, mtime, expired ) VALUES( 'misc', 'var/tiempo/cache/template-block/3/7/0/3709136653.cache', 'var/tiempo/cache/template-block/3/7/0/3709136653.cache', 'aa96cfc78cf3749752b4d4f96a14f456', 'template-block', '43', '1458461467', '0')
|
eZClusterFileHandler::cleanupEmptyDirectories( '/ocfsmount/revistas_data/revistas_var/var/tiempo/cache/template-block/3/7/0' )
|
DELETE FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/3/7/0/3709136653.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/7/8/4/784886286.cache' )
|
Local file (mtime=) is older than timestamp (1458460055) and ttl(1800), check with DB
|
SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/7/8/4/784886286.cache')
RESULT:
false
|
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/7/8/4/784886286.cache.generating', 'var/tiempo/cache/template-block/7/8/4/784886286.cache.generating', MD5('var/tiempo/cache/template-block/7/8/4/784886286.cache.generating'), '', '', 1458461467, 0)
|
Variable 'nodo' is already defined.
|
Checking cache generation timeout
|
UPDATE ezdfsfile SET mtime = 1458461467 WHERE name_hash = MD5('var/tiempo/cache/template-block/7/8/4/784886286.cache.generating') AND mtime = 1458461467
|
dfs::storeContents( 'var/tiempo/cache/template-block/7/8/4/784886286.cache.generating' )
|
BEGIN
|
INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/tiempo/cache/template-block/7/8/4/784886286.cache.generating', 'var/tiempo/cache/template-block/7/8/4/784886286.cache.generating', '9da1bfae840f522c2ff9116de12f6d1e', 'template-block', 35, 1458461467, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/tiempo/cache/template-block/7/8/4/784886286.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/7/8/4/784886286.cache.generating') FOR UPDATE
|
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/7/8/4/784886286.cache') FOR UPDATE
|
INSERT INTO ezdfsfile ( datatype, name, name_trunk, name_hash, scope, size, mtime, expired ) VALUES( 'misc', 'var/tiempo/cache/template-block/7/8/4/784886286.cache', 'var/tiempo/cache/template-block/7/8/4/784886286.cache', '60df68a8e4daca9e0419bc9ea2fdd0fa', 'template-block', '35', '1458461467', '0')
|
eZClusterFileHandler::cleanupEmptyDirectories( '/ocfsmount/revistas_data/revistas_var/var/tiempo/cache/template-block/7/8/4' )
|
DELETE FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/7/8/4/784886286.cache.generating')
|
COMMIT
|
Creating local copy of the file
|
dfs::ctor( 'var/tiempo/cache/template-block/1/2/7/1270703794.cache' )
|
Local file (mtime=) is older than timestamp () and ttl(86400), check with DB
|
SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/1/2/7/1270703794.cache')
RESULT:
false
|
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/1/2/7/1270703794.cache.generating', 'var/tiempo/cache/template-block/1/2/7/1270703794.cache.generating', MD5('var/tiempo/cache/template-block/1/2/7/1270703794.cache.generating'), '', '', 1458461467, 0)
|
Undefined index: url_alias in /var/www/html/revistas/extension/web/autoloads/zetatemplateoperators.php on line 86
|
EXPLAIN
SELECT url,codigo FROM publicidad_codes WHERE tipo = 4 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 | 1 | Using where; Using filesort |
+----+-------------+------------------+------+---------------+------+---------+-------+------+-----------------------------+
|
Undefined variable: default in /var/www/html/revistas/extension/web/classes/grupoz.php on line 214
|
Undefined index: url_alias in /var/www/html/revistas/extension/web/autoloads/zetatemplateoperators.php on line 86
|
EXPLAIN
SELECT url,codigo FROM publicidad_codes WHERE tipo = 5 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 | 1 | Using where; Using filesort |
+----+-------------+------------------+------+---------------+------+---------+-------+------+-----------------------------+
|
Checking cache generation timeout
|
UPDATE ezdfsfile SET mtime = 1458461467 WHERE name_hash = MD5('var/tiempo/cache/template-block/1/2/7/1270703794.cache.generating') AND mtime = 1458461467
|
dfs::storeContents( 'var/tiempo/cache/template-block/1/2/7/1270703794.cache.generating' )
|
BEGIN
|
INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/tiempo/cache/template-block/1/2/7/1270703794.cache.generating', 'var/tiempo/cache/template-block/1/2/7/1270703794.cache.generating', '3e1bc893f23520ddf43914fde97611fc', 'template-block', 1033, 1458461467, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/tiempo/cache/template-block/1/2/7/1270703794.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/1/2/7/1270703794.cache.generating') FOR UPDATE
|
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/1/2/7/1270703794.cache') FOR UPDATE
|
INSERT INTO ezdfsfile ( datatype, name, name_trunk, name_hash, scope, size, mtime, expired ) VALUES( 'misc', 'var/tiempo/cache/template-block/1/2/7/1270703794.cache', 'var/tiempo/cache/template-block/1/2/7/1270703794.cache', 'f03439759c0b830a8c5a4402b07b27f8', 'template-block', '1033', '1458461467', '0')
|
eZClusterFileHandler::cleanupEmptyDirectories( '/ocfsmount/revistas_data/revistas_var/var/tiempo/cache/template-block/1/2/7' )
|
DELETE FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/1/2/7/1270703794.cache.generating')
|
COMMIT
|
Creating local copy of the file
|
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' => '1458456382',
'expired' => '0',
)
|
Processing local cache file var/tiempo/cache/template-block/3/8/0/3805626181.cache
|
End
|
Timing points:
| Checkpoint |
Elapsed |
Rel. Elapsed |
Memory |
Rel. Memory |
| Module start 'visual' |
0.0000 sec |
0.0363 sec |
2,432.6094 KB |
1,334.3516 KB |
| Module end 'error' |
0.0363 sec |
0.6927 sec |
3,766.9609 KB |
3,000.0781 KB |
| End |
0.7289 sec |
|
6,767.0391 KB |
|
| Total runtime: |
0.7440 sec |
|
| Peak memory usage: |
9,190.0469 KB |
Time accumulators:
| Accumulator |
Elapsed |
Percent |
Count |
Average |
| ini_load |
|
|
|
|
| Load cache |
0.0122 sec |
1.5094% |
16 |
0.0008 sec |
| Mysql Total |
|
|
|
|
| Mysql_queries |
0.1179 sec |
14.5433% |
25 |
0.0047 sec |
| Looping result |
0.0006 sec |
0.0800% |
21 |
0.0000 sec |
| MySQL Cluster |
|
|
|
|
| DB queries |
0.1450 sec |
17.8918% |
83 |
0.0017 sec |
| DFS operations |
0.2736 sec |
33.7504% |
12 |
0.0228 sec |
| TS translator |
|
|
|
|
| TS init |
0.0060 sec |
0.7452% |
5 |
0.0012 sec |
| TS cache load |
0.0043 sec |
0.5285% |
5 |
0.0009 sec |
| TS context load |
0.0029 sec |
0.3573% |
5 |
0.0006 sec |
| Template Total |
0.7273 sec |
89.7% |
4 |
0.1818 sec |
| Template load |
0.0084 sec |
1.0361% |
4 |
0.0021 sec |
| Template processing |
0.7187 sec |
88.6621% |
4 |
0.1797 sec |
| Template load and register function |
0.0002 sec |
0.0289% |
1 |
0.0002 sec |
| override |
|
|
|
|
| Cache load |
0.0060 sec |
0.7448% |
5 |
0.0012 sec |
| Sytem overhead |
|
|
|
|
| Fetch class attribute name |
0.0035 sec |
0.4319% |
1 |
0.0035 sec |
| Fetch class attribute can translate value |
0.0037 sec |
0.4539% |
1 |
0.0037 sec |
| class_abstraction |
|
|
|
|
| Instantiating content class attribute |
0.0000 sec |
0.0020% |
1 |
0.0000 sec |
| XML |
|
|
|
|
| Image XML parsing |
0.0145 sec |
1.7891% |
1 |
0.0145 sec |
| General |
|
|
|
|
| String conversion |
0.0000 sec |
0.0032% |
2 |
0.0000 sec |
| Total script time: |
0.8106 sec |
|
Templates used to render the page:
| Usage count |
Requested template |
Template |
Template loaded |
Edit |
Override |
| 1 |
user/login.tpl
|
|
design/general/templates/user/login.tpl |
|
|
| 1 |
error/kernel/1.tpl
|
|
design/standard/templates/error/kernel/1.tpl |
|
|
| 1 |
pagelayout.tpl
|
|
design/tiempo/templates/pagelayout.tpl |
|
|
| 1 |
content/datatype/view/ezxmltext.tpl
|
|
design/standard/templates/content/datatype/view/ezxmltext.tpl |
|
|
| 1 |
setup/debug_toolbar.tpl
|
|
design/standard/templates/setup/debug_toolbar.tpl |
|
|
| |
|
|
|
|
|
Number of times templates used: 5
Number of unique templates used: 5 |
| Time used to render template usage: 0.0002 secs |
|
