|
|
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( 'fuerte-paron-por-la-interinidad' )
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' => '1458386078',
'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' => '1458050870',
'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' => '1458132027',
'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' => '1458132023',
'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/7/6/107676-c614dbdfc2ad23ce6a7d3f9c213e2f6b.cache' )
|
SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/content/tiempo/1/0/7/6/107676-c614dbdfc2ad23ce6a7d3f9c213e2f6b.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/content/tiempo/1/0/7/6/107676-c614dbdfc2ad23ce6a7d3f9c213e2f6b.cache.generating', 'var/tiempo/cache/content/tiempo/1/0/7/6/107676-c614dbdfc2ad23ce6a7d3f9c213e2f6b.cache.generating', MD5('var/tiempo/cache/content/tiempo/1/0/7/6/107676-c614dbdfc2ad23ce6a7d3f9c213e2f6b.cache.generating'), '', '', 1458401563, 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 = 107676 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 = '107918'
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:107676' ) 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=107918
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=107918 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 = '107918'
AND content_version = '2'
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 = '107918'
AND content_version = '2'
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 = '107918' AND
ezcontentobject_version.version = '2' AND
ezcontentobject_attribute.contentobject_id = '107918' AND ezcontentobject_attribute.version = '2' 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 | 22 | Using where |
+----+-------------+---------------------------+--------+----------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------+---------+-------------------------------------------------------------------------+------+-----------------------------------------------------------+
| 1 | SIMPLE | ezcontentclass_attribute | eq_ref | PRIMARY | PRIMARY | 8 | revista_tiempo.ezcontentobject_attribute.contentclassattribute_id,const | 1 | |
+----+-------------+---------------------------+--------+----------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------+---------+-------------------------------------------------------------------------+------+-----------------------------------------------------------+
|
EXPLAIN
SELECT ezkeyword.keyword FROM ezkeyword_attribute_link, ezkeyword
WHERE ezkeyword_attribute_link.keyword_id=ezkeyword.id AND
ezkeyword_attribute_link.objectattribute_id='1081311'
ANALYSIS:
+----+-------------+--------------------------+--------+--------------------------------------------------------------------------------------+--------------------------+---------+----------------------------------------------------+------+-------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+--------------------------+--------+--------------------------------------------------------------------------------------+--------------------------+---------+----------------------------------------------------+------+-------+
| 1 | SIMPLE | ezkeyword_attribute_link | ref | ezkeyword_attr_link_keyword_id,ezkeyword_attr_link_kid_oaid,ezkeyword_attr_link_oaid | ezkeyword_attr_link_oaid | 4 | const | 1 | |
+----+-------------+--------------------------+--------+--------------------------------------------------------------------------------------+--------------------------+---------+----------------------------------------------------+------+-------+
| 1 | SIMPLE | ezkeyword | eq_ref | PRIMARY | PRIMARY | 4 | revista_tiempo.ezkeyword_attribute_link.keyword_id | 1 | |
+----+-------------+--------------------------+--------+--------------------------------------------------------------------------------------+--------------------------+---------+----------------------------------------------------+------+-------+
|
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 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
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name
WHERE
ezcontentobject_tree.parent_node_id = 107676 and
ezcontentclass.version=0 AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentobject.contentclass_id IN ( 67 ) 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 path_string ASC
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_tree | ref | ezcontentobject_tree_co_id,ezcontentobject_tree_p_node_id | ezcontentobject_tree_p_node_id | 4 | const | 1 | Using where |
+----+-------------+----------------------+--------+----------------------------------------------------------------+--------------------------------+---------+---------------------------------------------------------------------------------------------+------+---------------------------------+
| 1 | SIMPLE | ezcontentobject | eq_ref | PRIMARY,ezcontentobject_classid | PRIMARY | 4 | revista_tiempo.ezcontentobject_tree.contentobject_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 |
+----+-------------+----------------------+--------+----------------------------------------------------------------+--------------------------------+---------+---------------------------------------------------------------------------------------------+------+---------------------------------+
|
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 = '107920' 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 | 1 | 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
count( DISTINCT ezcontentobject_tree.node_id ) as count
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name
WHERE ezcontentobject_tree.parent_node_id = 107678 and
ezcontentobject.contentclass_id IN ( 54 ) AND
ezcontentclass.version=0 AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id 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 ) )
)
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
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 index |
+----+-------------+----------------------+--------+----------------------------------------------------------------+--------------------------------+---------+----------------------------------------------------------------------------------------------------------------+------+-------------+
| 1 | SIMPLE | ezcontentobject_tree | ref | ezcontentobject_tree_co_id,ezcontentobject_tree_p_node_id | ezcontentobject_tree_p_node_id | 4 | const | 1 | Using where |
+----+-------------+----------------------+--------+----------------------------------------------------------------+--------------------------------+---------+----------------------------------------------------------------------------------------------------------------+------+-------------+
| 1 | SIMPLE | ezcontentobject | eq_ref | PRIMARY,ezcontentobject_classid | PRIMARY | 4 | revista_tiempo.ezcontentobject_tree.contentobject_id | 1 | Using where |
+----+-------------+----------------------+--------+----------------------------------------------------------------+--------------------------------+---------+----------------------------------------------------------------------------------------------------------------+------+-------------+
| 1 | SIMPLE | ezcontentobject_name | ref | PRIMARY,ezcontentobject_name_co_id,ezcontentobject_name_cov_id | PRIMARY | 8 | revista_tiempo.ezcontentobject_tree.contentobject_id,revista_tiempo.ezcontentobject_tree.contentobject_version | 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
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name
WHERE
ezcontentobject_tree.parent_node_id = 107678 and
ezcontentclass.version=0 AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentobject.contentclass_id IN ( 54 ) 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 ezcontentobject.published DESC
LIMIT 0, 5
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_tree | ref | ezcontentobject_tree_co_id,ezcontentobject_tree_p_node_id | ezcontentobject_tree_p_node_id | 4 | const | 1 | Using where |
+----+-------------+----------------------+--------+----------------------------------------------------------------+--------------------------------+---------+---------------------------------------------------------------------------------------------+------+---------------------------------+
| 1 | SIMPLE | ezcontentobject | eq_ref | PRIMARY,ezcontentobject_classid | PRIMARY | 4 | revista_tiempo.ezcontentobject_tree.contentobject_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 |
+----+-------------+----------------------+--------+----------------------------------------------------------------+--------------------------------+---------+---------------------------------------------------------------------------------------------+------+---------------------------------+
|
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='107918' 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='347' 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, 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='581' 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 contentobject_id, contentobject_attribute_id, rating_average, rating_count
FROM ezstarrating WHERE contentobject_id='107918' AND contentobject_attribute_id='1081321'
ANALYSIS:
+----+-------------+-------+------+---------------+-----+---------+-----+------+-----------------------------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------+------+---------------+-----+---------+-----+------+-----------------------------------------------------+
| 1 | SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
+----+-------------+-------+------+---------------+-----+---------+-----+------+-----------------------------------------------------+
|
EXPLAIN
SELECT
count( DISTINCT ezcontentobject_tree.node_id ) as count
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name
WHERE ezcontentobject_tree.parent_node_id = 107678 and
ezcontentclass.version=0 AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id 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 ) )
)
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
ANALYSIS:
+----+-------------+----------------------+--------+----------------------------------------------------------------+--------------------------------+---------+---------------------------------------------------------------------------------------------+------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+----------------------+--------+----------------------------------------------------------------+--------------------------------+---------+---------------------------------------------------------------------------------------------+------+-------------+
| 1 | SIMPLE | ezcontentobject_tree | ref | ezcontentobject_tree_co_id,ezcontentobject_tree_p_node_id | ezcontentobject_tree_p_node_id | 4 | const | 1 | Using where |
+----+-------------+----------------------+--------+----------------------------------------------------------------+--------------------------------+---------+---------------------------------------------------------------------------------------------+------+-------------+
| 1 | SIMPLE | ezcontentobject | eq_ref | PRIMARY,ezcontentobject_classid | PRIMARY | 4 | revista_tiempo.ezcontentobject_tree.contentobject_id | 1 | Using where |
+----+-------------+----------------------+--------+----------------------------------------------------------------+--------------------------------+---------+---------------------------------------------------------------------------------------------+------+-------------+
| 1 | SIMPLE | ezcontentclass | eq_ref | PRIMARY,ezcontentclass_version | PRIMARY | 8 | revista_tiempo.ezcontentobject.contentclass_id,const | 1 | Using index |
+----+-------------+----------------------+--------+----------------------------------------------------------------+--------------------------------+---------+---------------------------------------------------------------------------------------------+------+-------------+
| 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', 'eznode:107676' ) 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 permitir, url FROM comentarios_permitirmoderar WHERE (url LIKE 'espana/%') ORDER BY url DESC
ANALYSIS:
+----+-------------+-----------------------------+-------+---------------+-----+---------+-----+------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-----------------------------+-------+---------------+-----+---------+-----+------+-------------+
| 1 | SIMPLE | comentarios_permitirmoderar | range | url | url | 257 | | 1 | Using where |
+----+-------------+-----------------------------+-------+---------------+-----+---------+-----+------+-------------+
|
Undefined index: permitir in /var/www/html/revistas/extension/web/classes/grupoz.php on line 430
|
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='352' 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
ezcontentclass.serialized_name_list AS class_serialized_name_list,
ezcontentclass.identifier as contentclass_identifier,
ezcontentclass.is_container as is_container,
ezcontentobject.* , ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM
ezcontentclass,
ezcontentobject,
ezcontentobject_link
, ezcontentobject_name
WHERE
ezcontentclass.id=ezcontentobject.contentclass_id AND
ezcontentclass.version=0 AND
ezcontentobject.status=1 AND
ezcontentobject_link.op_code='0'
AND contentclassattribute_id=291 AND ( relation_type & 8 ) <> 0
AND ezcontentobject.id=ezcontentobject_link.from_contentobject_id AND
ezcontentobject_link.to_contentobject_id=107918 AND
ezcontentobject_link.from_contentobject_version=ezcontentobject.current_version
AND ezcontentobject.id = ezcontentobject_name.contentobject_id AND
ezcontentobject.current_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 ezcontentobject_name.name ASC
ANALYSIS:
+----+-------------+----------------------+--------+---------------------------------------------------------------------------------------+--------------------+---------+----------------------------------------------------------------------------------------------------------+------+----------------------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+----------------------+--------+---------------------------------------------------------------------------------------+--------------------+---------+----------------------------------------------------------------------------------------------------------+------+----------------------------------------------+
| 1 | SIMPLE | ezcontentobject_link | ref | ezco_link_from,ezco_link_to_co_id | ezco_link_to_co_id | 4 | const | 1 | Using where; Using temporary; Using filesort |
+----+-------------+----------------------+--------+---------------------------------------------------------------------------------------+--------------------+---------+----------------------------------------------------------------------------------------------------------+------+----------------------------------------------+
| 1 | SIMPLE | ezcontentobject | eq_ref | PRIMARY,ezcontentobject_classid,ezcontentobject_currentversion,ezcontentobject_status | PRIMARY | 4 | revista_tiempo.ezcontentobject_link.from_contentobject_id | 1 | Using where |
+----+-------------+----------------------+--------+---------------------------------------------------------------------------------------+--------------------+---------+----------------------------------------------------------------------------------------------------------+------+----------------------------------------------+
| 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_link.from_contentobject_id,revista_tiempo.ezcontentobject.current_version | 1 | Using where |
+----+-------------+----------------------+--------+---------------------------------------------------------------------------------------+--------------------+---------+----------------------------------------------------------------------------------------------------------+------+----------------------------------------------+
|
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='107919' 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 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 = '107919' AND
ezcontentobject_version.version = '1' AND
ezcontentobject_attribute.contentobject_id = '107919' 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/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad.jpg' )
|
dfs::exists( 'var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad.jpg' )
|
SQL for _selectOneAssoc:
SELECT name, mtime FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad.jpg')
RESULT:
array (
0 => 'var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad.jpg',
1 => '1458029627',
)
|
dfs::size()
|
SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad.jpg')
RESULT:
array (
'datatype' => 'image/jpeg',
'name' => 'var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad.jpg',
'name_trunk' => 'var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad.jpg',
'name_hash' => 'd7916f0fb0a5a7d20e92b0e88943add0',
'scope' => 'image',
'size' => '272040',
'mtime' => '1458029627',
'expired' => '0',
)
|
dfs::ctor( 'var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_bloque_imagen_grande2.jpg' )
|
dfs::exists( 'var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_bloque_imagen_grande2.jpg' )
|
SQL for _selectOneAssoc:
SELECT name, mtime FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_bloque_imagen_grande2.jpg')
RESULT:
array (
0 => 'var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_bloque_imagen_grande2.jpg',
1 => '1458050897',
)
|
dfs::size()
|
SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_bloque_imagen_grande2.jpg')
RESULT:
array (
'datatype' => 'image/jpeg',
'name' => 'var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_bloque_imagen_grande2.jpg',
'name_trunk' => 'var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_bloque_imagen_grande2.jpg',
'name_hash' => '8dbd5257b57273f62cf1033418d4acec',
'scope' => 'image',
'size' => '33980',
'mtime' => '1458050897',
'expired' => '0',
)
|
dfs::ctor( 'var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_detalle_articulo.jpg' )
|
dfs::exists( 'var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_detalle_articulo.jpg' )
|
SQL for _selectOneAssoc:
SELECT name, mtime FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_detalle_articulo.jpg')
RESULT:
array (
0 => 'var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_detalle_articulo.jpg',
1 => '1458051101',
)
|
dfs::size()
|
SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_detalle_articulo.jpg')
RESULT:
array (
'datatype' => 'image/jpeg',
'name' => 'var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_detalle_articulo.jpg',
'name_trunk' => 'var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_detalle_articulo.jpg',
'name_hash' => '1c078ddba62daadc87db47f5002c75a8',
'scope' => 'image',
'size' => '39922',
'mtime' => '1458051101',
'expired' => '0',
)
|
dfs::ctor( 'var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_bloque_articulo.jpg' )
|
dfs::exists( 'var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_bloque_articulo.jpg' )
|
SQL for _selectOneAssoc:
SELECT name, mtime FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_bloque_articulo.jpg')
RESULT:
array (
0 => 'var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_bloque_articulo.jpg',
1 => '1458050884',
)
|
dfs::size()
|
SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_bloque_articulo.jpg')
RESULT:
array (
'datatype' => 'image/jpeg',
'name' => 'var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_bloque_articulo.jpg',
'name_trunk' => 'var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_bloque_articulo.jpg',
'name_hash' => '6b61dcac0ab6689f6756052f8d1bff7c',
'scope' => 'image',
'size' => '11580',
'mtime' => '1458050884',
'expired' => '0',
)
|
dfs::ctor( 'var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_listado_articulos.jpg' )
|
dfs::exists( 'var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_listado_articulos.jpg' )
|
SQL for _selectOneAssoc:
SELECT name, mtime FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_listado_articulos.jpg')
RESULT:
array (
0 => 'var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_listado_articulos.jpg',
1 => '1458052737',
)
|
dfs::size()
|
SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_listado_articulos.jpg')
RESULT:
array (
'datatype' => 'image/jpeg',
'name' => 'var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_listado_articulos.jpg',
'name_trunk' => 'var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_listado_articulos.jpg',
'name_hash' => '6691f750a0f8ece43ac7a9e4ffeb337c',
'scope' => 'image',
'size' => '17024',
'mtime' => '1458052737',
'expired' => '0',
)
|
dfs::ctor( 'var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_medium.jpg' )
|
dfs::exists( 'var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_medium.jpg' )
|
SQL for _selectOneAssoc:
SELECT name, mtime FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_medium.jpg')
RESULT:
array (
0 => 'var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_medium.jpg',
1 => '1458203492',
)
|
dfs::size()
|
SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_medium.jpg')
RESULT:
array (
'datatype' => 'image/jpeg',
'name' => 'var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_medium.jpg',
'name_trunk' => 'var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_medium.jpg',
'name_hash' => 'ef347bb163edd6e05d0e1923e6259a1f',
'scope' => 'image',
'size' => '19498',
'mtime' => '1458203492',
'expired' => '0',
)
|
dfs::ctor( 'var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_bloque_tres_columnas.jpg' )
|
dfs::exists( 'var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_bloque_tres_columnas.jpg' )
|
SQL for _selectOneAssoc:
SELECT name, mtime FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_bloque_tres_columnas.jpg')
RESULT:
array (
0 => 'var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_bloque_tres_columnas.jpg',
1 => '1458290696',
)
|
dfs::size()
|
SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_bloque_tres_columnas.jpg')
RESULT:
array (
'datatype' => 'image/jpeg',
'name' => 'var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_bloque_tres_columnas.jpg',
'name_trunk' => 'var/tiempo/storage/images/media/imagenes-y-videos/fuerte-paron-por-la-interinidad/1081327-1-esl-ES/fuerte-paron-por-la-interinidad_bloque_tres_columnas.jpg',
'name_hash' => '3abede6081fe8ef67265aba4a89d9930',
'scope' => 'image',
'size' => '15323',
'mtime' => '1458290696',
'expired' => '0',
)
|
EXPLAIN
SELECT ezkeyword.keyword FROM ezkeyword_attribute_link, ezkeyword
WHERE ezkeyword_attribute_link.keyword_id=ezkeyword.id AND
ezkeyword_attribute_link.objectattribute_id='1081311'
ANALYSIS:
+----+-------------+--------------------------+--------+--------------------------------------------------------------------------------------+--------------------------+---------+----------------------------------------------------+------+-------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+--------------------------+--------+--------------------------------------------------------------------------------------+--------------------------+---------+----------------------------------------------------+------+-------+
| 1 | SIMPLE | ezkeyword_attribute_link | ref | ezkeyword_attr_link_keyword_id,ezkeyword_attr_link_kid_oaid,ezkeyword_attr_link_oaid | ezkeyword_attr_link_oaid | 4 | const | 1 | |
+----+-------------+--------------------------+--------+--------------------------------------------------------------------------------------+--------------------------+---------+----------------------------------------------------+------+-------+
| 1 | SIMPLE | ezkeyword | eq_ref | PRIMARY | PRIMARY | 4 | revista_tiempo.ezkeyword_attribute_link.keyword_id | 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:107676' ) 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 id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:80', 'eznode:107676' ) 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 id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:80', 'eznode:107676' ) 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 id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:80', 'eznode:107676' ) 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 url,codigo FROM publicidad_codes WHERE tipo = 10 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 |
+----+-------------+------------------+------+---------------+------+---------+-------+------+-----------------------------+
|
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:107676' ) 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 permitir, url FROM comentarios_permitirmoderar WHERE (url LIKE 'espana/%') ORDER BY url DESC
ANALYSIS:
+----+-------------+-----------------------------+-------+---------------+-----+---------+-----+------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-----------------------------+-------+---------------+-----+---------+-----+------+-------------+
| 1 | SIMPLE | comentarios_permitirmoderar | range | url | url | 257 | | 1 | Using where |
+----+-------------+-----------------------------+-------+---------------+-----+---------+-----+------+-------------+
|
Undefined index: permitir in /var/www/html/revistas/extension/web/classes/grupoz.php on line 430
|
Unknown session variable 'formulario_comentario'
|
Function session_unregister() is deprecated in /var/www/html/revistas/extension/borrarSesion/classes/borrarSesion.php on line 6
|
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:107676' ) 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=107918 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 = 1458401563 WHERE name_hash = MD5('var/tiempo/cache/content/tiempo/1/0/7/6/107676-c614dbdfc2ad23ce6a7d3f9c213e2f6b.cache.generating') AND mtime = 1458401563
|
dfs::storeContents( 'var/tiempo/cache/content/tiempo/1/0/7/6/107676-c614dbdfc2ad23ce6a7d3f9c213e2f6b.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/7/6/107676-c614dbdfc2ad23ce6a7d3f9c213e2f6b.cache.generating', 'var/tiempo/cache/content/tiempo/1/0/7/6/107676-', '695a45f2f3dec0707af2949d18daceaf', 'viewcache', 20606, 1458401563, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/tiempo/cache/content/tiempo/1/0/7/6/107676-', 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/7/6/107676-c614dbdfc2ad23ce6a7d3f9c213e2f6b.cache.generating') FOR UPDATE
|
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/content/tiempo/1/0/7/6/107676-c614dbdfc2ad23ce6a7d3f9c213e2f6b.cache') FOR UPDATE
|
INSERT INTO ezdfsfile ( datatype, name, name_trunk, name_hash, scope, size, mtime, expired ) VALUES( 'misc', 'var/tiempo/cache/content/tiempo/1/0/7/6/107676-c614dbdfc2ad23ce6a7d3f9c213e2f6b.cache', 'var/tiempo/cache/content/tiempo/1/0/7/6/107676-', '10521ce1fde06b541625d89fea48d124', 'viewcache', '20606', '1458401563', '0')
|
eZClusterFileHandler::cleanupEmptyDirectories( '/ocfsmount/revistas_data/revistas_var/var/tiempo/cache/content/tiempo/1/0/7/6' )
|
DELETE FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/content/tiempo/1/0/7/6/107676-c614dbdfc2ad23ce6a7d3f9c213e2f6b.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 |
+----+-------------+----------------------+-------+----------------------------------------------------------------+---------+---------+-------------+------+-------------+
|
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/5/1/351165300.cache' )
|
SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/3/5/1/351165300.cache')
RESULT:
array (
'datatype' => 'misc',
'name' => 'var/tiempo/cache/template-block/3/5/1/351165300.cache',
'name_trunk' => 'var/tiempo/cache/template-block/3/5/1/351165300.cache',
'name_hash' => '6f8c4e7b56cf03296a72acc3d90c418b',
'scope' => 'template-block',
'size' => '549',
'mtime' => '1458315517',
'expired' => '0',
)
|
Processing local cache file var/tiempo/cache/template-block/3/5/1/351165300.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/7/2/372620011.cache' )
|
SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/3/7/2/372620011.cache')
RESULT:
array (
'datatype' => 'misc',
'name' => 'var/tiempo/cache/template-block/3/7/2/372620011.cache',
'name_trunk' => 'var/tiempo/cache/template-block/3/7/2/372620011.cache',
'name_hash' => '8ae0056c917775c0d5833e00a475bdfd',
'scope' => 'template-block',
'size' => '1637',
'mtime' => '1458388757',
'expired' => '0',
)
|
Processing local cache file var/tiempo/cache/template-block/3/7/2/372620011.cache
|
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' => '1458397459',
'expired' => '0',
)
|
Processing local cache file var/tiempo/cache/template-block/3/4/0/3403941913.cache
|
dfs::ctor( 'var/tiempo/cache/template-block/4/0/9/4097767497.cache' )
|
SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/4/0/9/4097767497.cache')
RESULT:
array (
'datatype' => 'misc',
'name' => 'var/tiempo/cache/template-block/4/0/9/4097767497.cache',
'name_trunk' => 'var/tiempo/cache/template-block/4/0/9/4097767497.cache',
'name_hash' => 'c9d4dec8f55baa42705a0458e3232de4',
'scope' => 'template-block',
'size' => '1437',
'mtime' => '1458315517',
'expired' => '0',
)
|
Processing local cache file var/tiempo/cache/template-block/4/0/9/4097767497.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 |
+----+-------------+-----------------+------+-------------------------+-------------------------+---------+-------+------+-------------+
|
dfs::ctor( 'var/tiempo/cache/template-block/subtree/2/cache/2/8/6/286822487.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 | |
+----+-------------+----------------------+-------+---------------+---------+---------+-------+------+-------+
|
SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/subtree/2/cache/2/8/6/286822487.cache')
RESULT:
array (
'datatype' => 'misc',
'name' => 'var/tiempo/cache/template-block/subtree/2/cache/2/8/6/286822487.cache',
'name_trunk' => 'var/tiempo/cache/template-block/subtree/2/cache/',
'name_hash' => '418fad77d92bd7b21bc81a3e2ae367d9',
'scope' => 'template-block',
'size' => '225',
'mtime' => '1458388757',
'expired' => '0',
)
|
Processing local cache file var/tiempo/cache/template-block/subtree/2/cache/2/8/6/286822487.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 |
+----+-------------+-----------------+------+-------------------------+-------------------------+---------+-------+------+-------------+
|
dfs::ctor( 'var/tiempo/cache/template-block/3/8/0/3804501332.cache' )
|
SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/3/8/0/3804501332.cache')
RESULT:
array (
'datatype' => 'misc',
'name' => 'var/tiempo/cache/template-block/3/8/0/3804501332.cache',
'name_trunk' => 'var/tiempo/cache/template-block/3/8/0/3804501332.cache',
'name_hash' => 'c0932cdafe49056b5864b314c704c68c',
'scope' => 'template-block',
'size' => '66891',
'mtime' => '1458400649',
'expired' => '0',
)
|
Processing local cache file var/tiempo/cache/template-block/3/8/0/3804501332.cache
|
dfs::ctor( 'var/tiempo/cache/template-block/2/2/7/2276530664.cache' )
|
SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/2/2/7/2276530664.cache')
RESULT:
array (
'datatype' => 'misc',
'name' => 'var/tiempo/cache/template-block/2/2/7/2276530664.cache',
'name_trunk' => 'var/tiempo/cache/template-block/2/2/7/2276530664.cache',
'name_hash' => 'bf7e85ce9cafca4de78e8c0641053fbe',
'scope' => 'template-block',
'size' => '1033',
'mtime' => '1458315526',
'expired' => '0',
)
|
Processing local cache file var/tiempo/cache/template-block/2/2/7/2276530664.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' => '1458396713',
'expired' => '0',
)
|
Processing local cache file var/tiempo/cache/template-block/3/8/0/3805626181.cache
|
EXPLAIN
SELECT visits
FROM ezhit WHERE node_id='107676' AND startdatetimestamp='1458342000'
ANALYSIS:
+----+-------------+-------+-------+------------------------------------+---------+---------+-------------+------+-------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------+-------+------------------------------------+---------+---------+-------------+------+-------+
| 1 | SIMPLE | ezhit | const | PRIMARY,node_id,startdatetimestamp | PRIMARY | 8 | const,const | 1 | |
+----+-------------+-------+-------+------------------------------------+---------+---------+-------------+------+-------+
|
EXPLAIN
SELECT node_id, startdatetimestamp
FROM ezhit WHERE node_id='107676' AND startdatetimestamp='1458342000'
ANALYSIS:
+----+-------------+-------+-------+------------------------------------+---------+---------+-------------+------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------+-------+------------------------------------+---------+---------+-------------+------+-------------+
| 1 | SIMPLE | ezhit | const | PRIMARY,node_id,startdatetimestamp | PRIMARY | 8 | const,const | 1 | Using index |
+----+-------------+-------+-------+------------------------------------+---------+---------+-------------+------+-------------+
|
UPDATE ezhit SET visits=17 WHERE node_id='107676' AND startdatetimestamp='1458342000'
|
End
|
Timing points:
| Checkpoint |
Elapsed |
Rel. Elapsed |
Memory |
Rel. Memory |
| Module start 'content' |
0.0000 sec |
0.4263 sec |
2,661.8203 KB |
4,503.7969 KB |
| Module end 'content' |
0.4263 sec |
0.0964 sec |
7,165.6172 KB |
403.5938 KB |
| End |
0.5227 sec |
|
7,569.2109 KB |
|
| Total runtime: |
0.5368 sec |
|
| Peak memory usage: |
10,383.5313 KB |
Time accumulators:
| Accumulator |
Elapsed |
Percent |
Count |
Average |
| ini_load |
|
|
|
|
| Load cache |
0.0105 sec |
1.6392% |
15 |
0.0007 sec |
| Mysql Total |
|
|
|
|
| Mysql_queries |
0.2360 sec |
36.6993% |
51 |
0.0046 sec |
| Looping result |
0.0012 sec |
0.1811% |
42 |
0.0000 sec |
| MySQL Cluster |
|
|
|
|
| DB queries |
0.1069 sec |
16.6220% |
39 |
0.0027 sec |
| DFS operations |
0.0057 sec |
0.8884% |
2 |
0.0029 sec |
| TS translator |
|
|
|
|
| TS init |
0.0055 sec |
0.8558% |
4 |
0.0014 sec |
| TS cache load |
0.0040 sec |
0.6150% |
4 |
0.0010 sec |
| TS context load |
0.0027 sec |
0.4166% |
4 |
0.0007 sec |
| Template Total |
0.3855 sec |
59.9% |
3 |
0.1285 sec |
| Template load |
0.0082 sec |
1.2702% |
3 |
0.0027 sec |
| Template processing |
0.3771 sec |
58.6360% |
3 |
0.1257 sec |
| Template load and register function |
0.0002 sec |
0.0314% |
1 |
0.0002 sec |
| states |
|
|
|
|
| state_id_array |
0.0023 sec |
0.3609% |
1 |
0.0023 sec |
| state_identifier_array |
0.0109 sec |
1.7012% |
2 |
0.0055 sec |
| override |
|
|
|
|
| Cache load |
0.0074 sec |
1.1495% |
30 |
0.0002 sec |
| Sytem overhead |
|
|
|
|
| Fetch class attribute name |
0.0130 sec |
2.0145% |
3 |
0.0043 sec |
| Fetch class attribute can translate value |
0.0043 sec |
0.6648% |
1 |
0.0043 sec |
| class_abstraction |
|
|
|
|
| Instantiating content class attribute |
0.0001 sec |
0.0097% |
4 |
0.0000 sec |
| XML |
|
|
|
|
| Image XML parsing |
0.0367 sec |
5.7141% |
1 |
0.0367 sec |
| General |
|
|
|
|
| String conversion |
0.0000 sec |
0.0045% |
2 |
0.0000 sec |
| Total script time: |
0.6431 sec |
|
Templates used to render the page:
|
