|
|
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.alias_redirects AS e1_alias_redirects, e2.id AS e2_id, e2.link AS e2_link, e2.text AS e2_text, e2.text_md5 AS e2_text_md5, e2.is_alias AS e2_is_alias, e2.action AS e2_action, e2.alias_redirects AS e2_alias_redirects FROM ezurlalias_ml e0, ezurlalias_ml e1, ezurlalias_ml e2 WHERE e0.parent = 0 AND (e0.lang_mask & 3 > 0) AND e0.text_md5 = MD5( 'opinion' ) AND e1.parent = e0.link AND (e1.lang_mask & 3 > 0) AND e1.text_md5 = MD5( 'jesus-marinas' ) AND e2.parent = e1.link AND (e2.lang_mask & 3 > 0) AND e2.text_md5 = MD5( 'la-infanta-cristina-se-autorretrata-goyesca' )
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 | |
+----+-------------+-------+-------+--------------------------------------------------------------------------------------+---------+---------+-------------+------+-------+
| 1 | SIMPLE | e2 | 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' => '1458380708',
'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/107679-5e4d46556b3e1d87d401a04c6401aacd.cache' )
|
SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/content/tiempo/1/0/7/6/107679-5e4d46556b3e1d87d401a04c6401aacd.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/107679-5e4d46556b3e1d87d401a04c6401aacd.cache.generating', 'var/tiempo/cache/content/tiempo/1/0/7/6/107679-5e4d46556b3e1d87d401a04c6401aacd.cache.generating', MD5('var/tiempo/cache/content/tiempo/1/0/7/6/107679-5e4d46556b3e1d87d401a04c6401aacd.cache.generating'), '', '', 1458383842, 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 = 107679 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 = '107921'
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:68', 'eznode:92', 'eznode:107679' ) 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 | | 4 | 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=107921
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=107921 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 = 92 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='50' 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, 68, 92 ) 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 | | 4 | 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:68' ) 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 id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:68', 'eznode:92' ) 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 name, content_translation
FROM ezcontentobject_name
WHERE contentobject_id = '107921'
AND content_version = '1'
AND ( content_translation = 'esl-ES' OR language_id = '2' )
ANALYSIS:
+----+-------------+----------------------+------+---------------------------------------------------------------------------------------------+---------+---------+-------------+------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+----------------------+------+---------------------------------------------------------------------------------------------+---------+---------+-------------+------+-------------+
| 1 | SIMPLE | ezcontentobject_name | ref | PRIMARY,ezcontentobject_name_co_id,ezcontentobject_name_cov_id,ezcontentobject_name_lang_id | PRIMARY | 8 | const,const | 1 | Using where |
+----+-------------+----------------------+------+---------------------------------------------------------------------------------------------+---------+---------+-------------+------+-------------+
|
EXPLAIN
SELECT name, content_translation
FROM ezcontentobject_name
WHERE contentobject_id = '107921'
AND content_version = '1'
AND ( content_translation = 'esl-ES' OR language_id = '2' )
ANALYSIS:
+----+-------------+----------------------+------+---------------------------------------------------------------------------------------------+---------+---------+-------------+------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+----------------------+------+---------------------------------------------------------------------------------------------+---------+---------+-------------+------+-------------+
| 1 | SIMPLE | ezcontentobject_name | ref | PRIMARY,ezcontentobject_name_co_id,ezcontentobject_name_cov_id,ezcontentobject_name_lang_id | PRIMARY | 8 | const,const | 1 | Using where |
+----+-------------+----------------------+------+---------------------------------------------------------------------------------------------+---------+---------+-------------+------+-------------+
|
EXPLAIN
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
ezcontentobject_attribute, ezcontentclass_attribute, ezcontentobject_version
WHERE
ezcontentclass_attribute.version = '0' AND
ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
ezcontentobject_version.contentobject_id = '107921' AND
ezcontentobject_version.version = '1' AND
ezcontentobject_attribute.contentobject_id = '107921' 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 | 21 | 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='1081341'
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 = 107679 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 = '107923' 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 = 107681 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 = 107681 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='107921' 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='107921' AND contentobject_attribute_id='1081351'
ANALYSIS:
+----+-------------+--------------+-------+---------------+---------+---------+-------------+------+-------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+--------------+-------+---------------+---------+---------+-------------+------+-------+
| 1 | SIMPLE | ezstarrating | const | PRIMARY | PRIMARY | 8 | const,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 = 107681 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:68', 'eznode:92', 'eznode:107679' ) 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 | | 4 | Using where |
+----+-------------+---------------+-------+--------------------------------------------+-----------------------+---------+-----+------+-------------+
|
EXPLAIN
SELECT permitir, url FROM comentarios_permitirmoderar WHERE (url LIKE 'opinion/%') 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=107921 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='107922' 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 = '107922' AND
ezcontentobject_version.version = '1' AND
ezcontentobject_attribute.contentobject_id = '107922' 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/la-infanta-cristina-se-autorretrata-goyesca/1081357-1-esl-ES/la-infanta-cristina-se-autorretrata-goyesca.jpg' )
|
dfs::exists( 'var/tiempo/storage/images/media/imagenes-y-videos/la-infanta-cristina-se-autorretrata-goyesca/1081357-1-esl-ES/la-infanta-cristina-se-autorretrata-goyesca.jpg' )
|
SQL for _selectOneAssoc:
SELECT name, mtime FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/storage/images/media/imagenes-y-videos/la-infanta-cristina-se-autorretrata-goyesca/1081357-1-esl-ES/la-infanta-cristina-se-autorretrata-goyesca.jpg')
RESULT:
array (
0 => 'var/tiempo/storage/images/media/imagenes-y-videos/la-infanta-cristina-se-autorretrata-goyesca/1081357-1-esl-ES/la-infanta-cristina-se-autorretrata-goyesca.jpg',
1 => '1458029944',
)
|
dfs::size()
|
SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/storage/images/media/imagenes-y-videos/la-infanta-cristina-se-autorretrata-goyesca/1081357-1-esl-ES/la-infanta-cristina-se-autorretrata-goyesca.jpg')
RESULT:
array (
'datatype' => 'image/jpeg',
'name' => 'var/tiempo/storage/images/media/imagenes-y-videos/la-infanta-cristina-se-autorretrata-goyesca/1081357-1-esl-ES/la-infanta-cristina-se-autorretrata-goyesca.jpg',
'name_trunk' => 'var/tiempo/storage/images/media/imagenes-y-videos/la-infanta-cristina-se-autorretrata-goyesca/1081357-1-esl-ES/la-infanta-cristina-se-autorretrata-goyesca.jpg',
'name_hash' => '2f96666226cd7da8963801bc8862b1e3',
'scope' => 'image',
'size' => '317679',
'mtime' => '1458029944',
'expired' => '0',
)
|
dfs::ctor( 'var/tiempo/storage/images/media/imagenes-y-videos/la-infanta-cristina-se-autorretrata-goyesca/1081357-1-esl-ES/la-infanta-cristina-se-autorretrata-goyesca_bloque_articulo.jpg' )
|
dfs::exists( 'var/tiempo/storage/images/media/imagenes-y-videos/la-infanta-cristina-se-autorretrata-goyesca/1081357-1-esl-ES/la-infanta-cristina-se-autorretrata-goyesca_bloque_articulo.jpg' )
|
SQL for _selectOneAssoc:
SELECT name, mtime FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/storage/images/media/imagenes-y-videos/la-infanta-cristina-se-autorretrata-goyesca/1081357-1-esl-ES/la-infanta-cristina-se-autorretrata-goyesca_bloque_articulo.jpg')
RESULT:
array (
0 => 'var/tiempo/storage/images/media/imagenes-y-videos/la-infanta-cristina-se-autorretrata-goyesca/1081357-1-esl-ES/la-infanta-cristina-se-autorretrata-goyesca_bloque_articulo.jpg',
1 => '1458050883',
)
|
dfs::size()
|
SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/storage/images/media/imagenes-y-videos/la-infanta-cristina-se-autorretrata-goyesca/1081357-1-esl-ES/la-infanta-cristina-se-autorretrata-goyesca_bloque_articulo.jpg')
RESULT:
array (
'datatype' => 'image/jpeg',
'name' => 'var/tiempo/storage/images/media/imagenes-y-videos/la-infanta-cristina-se-autorretrata-goyesca/1081357-1-esl-ES/la-infanta-cristina-se-autorretrata-goyesca_bloque_articulo.jpg',
'name_trunk' => 'var/tiempo/storage/images/media/imagenes-y-videos/la-infanta-cristina-se-autorretrata-goyesca/1081357-1-esl-ES/la-infanta-cristina-se-autorretrata-goyesca_bloque_articulo.jpg',
'name_hash' => 'c56d190f5c70bb0ca4d1fc17e0c47304',
'scope' => 'image',
'size' => '10582',
'mtime' => '1458050883',
'expired' => '0',
)
|
dfs::ctor( 'var/tiempo/storage/images/media/imagenes-y-videos/la-infanta-cristina-se-autorretrata-goyesca/1081357-1-esl-ES/la-infanta-cristina-se-autorretrata-goyesca_detalle_articulo.jpg' )
|
dfs::exists( 'var/tiempo/storage/images/media/imagenes-y-videos/la-infanta-cristina-se-autorretrata-goyesca/1081357-1-esl-ES/la-infanta-cristina-se-autorretrata-goyesca_detalle_articulo.jpg' )
|
SQL for _selectOneAssoc:
SELECT name, mtime FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/storage/images/media/imagenes-y-videos/la-infanta-cristina-se-autorretrata-goyesca/1081357-1-esl-ES/la-infanta-cristina-se-autorretrata-goyesca_detalle_articulo.jpg')
RESULT:
array (
0 => 'var/tiempo/storage/images/media/imagenes-y-videos/la-infanta-cristina-se-autorretrata-goyesca/1081357-1-esl-ES/la-infanta-cristina-se-autorretrata-goyesca_detalle_articulo.jpg',
1 => '1458050991',
)
|
dfs::size()
|
SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/storage/images/media/imagenes-y-videos/la-infanta-cristina-se-autorretrata-goyesca/1081357-1-esl-ES/la-infanta-cristina-se-autorretrata-goyesca_detalle_articulo.jpg')
RESULT:
array (
'datatype' => 'image/jpeg',
'name' => 'var/tiempo/storage/images/media/imagenes-y-videos/la-infanta-cristina-se-autorretrata-goyesca/1081357-1-esl-ES/la-infanta-cristina-se-autorretrata-goyesca_detalle_articulo.jpg',
'name_trunk' => 'var/tiempo/storage/images/media/imagenes-y-videos/la-infanta-cristina-se-autorretrata-goyesca/1081357-1-esl-ES/la-infanta-cristina-se-autorretrata-goyesca_detalle_articulo.jpg',
'name_hash' => '9d08e8b5378ea8ba34b0dc7e7587d5e1',
'scope' => 'image',
'size' => '40447',
'mtime' => '1458050991',
'expired' => '0',
)
|
dfs::ctor( 'var/tiempo/storage/images/media/imagenes-y-videos/la-infanta-cristina-se-autorretrata-goyesca/1081357-1-esl-ES/la-infanta-cristina-se-autorretrata-goyesca_bloque_imagen_grande2.jpg' )
|
dfs::exists( 'var/tiempo/storage/images/media/imagenes-y-videos/la-infanta-cristina-se-autorretrata-goyesca/1081357-1-esl-ES/la-infanta-cristina-se-autorretrata-goyesca_bloque_imagen_grande2.jpg' )
|
SQL for _selectOneAssoc:
SELECT name, mtime FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/storage/images/media/imagenes-y-videos/la-infanta-cristina-se-autorretrata-goyesca/1081357-1-esl-ES/la-infanta-cristina-se-autorretrata-goyesca_bloque_imagen_grande2.jpg')
RESULT:
array (
0 => 'var/tiempo/storage/images/media/imagenes-y-videos/la-infanta-cristina-se-autorretrata-goyesca/1081357-1-esl-ES/la-infanta-cristina-se-autorretrata-goyesca_bloque_imagen_grande2.jpg',
1 => '1458050921',
)
|
dfs::size()
|
SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/storage/images/media/imagenes-y-videos/la-infanta-cristina-se-autorretrata-goyesca/1081357-1-esl-ES/la-infanta-cristina-se-autorretrata-goyesca_bloque_imagen_grande2.jpg')
RESULT:
array (
'datatype' => 'image/jpeg',
'name' => 'var/tiempo/storage/images/media/imagenes-y-videos/la-infanta-cristina-se-autorretrata-goyesca/1081357-1-esl-ES/la-infanta-cristina-se-autorretrata-goyesca_bloque_imagen_grande2.jpg',
'name_trunk' => 'var/tiempo/storage/images/media/imagenes-y-videos/la-infanta-cristina-se-autorretrata-goyesca/1081357-1-esl-ES/la-infanta-cristina-se-autorretrata-goyesca_bloque_imagen_grande2.jpg',
'name_hash' => 'a8947c1b4d7d396c94549f45056c84ec',
'scope' => 'image',
'size' => '27338',
'mtime' => '1458050921',
'expired' => '0',
)
|
dfs::ctor( 'var/tiempo/storage/images/media/imagenes-y-videos/la-infanta-cristina-se-autorretrata-goyesca/1081357-1-esl-ES/la-infanta-cristina-se-autorretrata-goyesca_listado_articulos.jpg' )
|
dfs::exists( 'var/tiempo/storage/images/media/imagenes-y-videos/la-infanta-cristina-se-autorretrata-goyesca/1081357-1-esl-ES/la-infanta-cristina-se-autorretrata-goyesca_listado_articulos.jpg' )
|
SQL for _selectOneAssoc:
SELECT name, mtime FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/storage/images/media/imagenes-y-videos/la-infanta-cristina-se-autorretrata-goyesca/1081357-1-esl-ES/la-infanta-cristina-se-autorretrata-goyesca_listado_articulos.jpg')
RESULT:
array (
0 => 'var/tiempo/storage/images/media/imagenes-y-videos/la-infanta-cristina-se-autorretrata-goyesca/1081357-1-esl-ES/la-infanta-cristina-se-autorretrata-goyesca_listado_articulos.jpg',
1 => '1458065814',
)
|
dfs::size()
|
SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/storage/images/media/imagenes-y-videos/la-infanta-cristina-se-autorretrata-goyesca/1081357-1-esl-ES/la-infanta-cristina-se-autorretrata-goyesca_listado_articulos.jpg')
RESULT:
array (
'datatype' => 'image/jpeg',
'name' => 'var/tiempo/storage/images/media/imagenes-y-videos/la-infanta-cristina-se-autorretrata-goyesca/1081357-1-esl-ES/la-infanta-cristina-se-autorretrata-goyesca_listado_articulos.jpg',
'name_trunk' => 'var/tiempo/storage/images/media/imagenes-y-videos/la-infanta-cristina-se-autorretrata-goyesca/1081357-1-esl-ES/la-infanta-cristina-se-autorretrata-goyesca_listado_articulos.jpg',
'name_hash' => '0edabf34dd4d9aa04152f46d9f87e535',
'scope' => 'image',
'size' => '14334',
'mtime' => '1458065814',
'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='1081341'
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:68', 'eznode:92', 'eznode:107679' ) 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 | | 4 | 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:68', 'eznode:92', 'eznode:107679' ) 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 | | 4 | 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:68', 'eznode:92', 'eznode:107679' ) 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 | | 4 | 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:68', 'eznode:92', 'eznode:107679' ) 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 | | 4 | 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:68', 'eznode:92', 'eznode:107679' ) 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 | | 4 | Using where |
+----+-------------+---------------+-------+--------------------------------------------+-----------------------+---------+-----+------+-------------+
|
EXPLAIN
SELECT permitir, url FROM comentarios_permitirmoderar WHERE (url LIKE 'opinion/%') 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:68', 'eznode:92', 'eznode:107679' ) 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 | | 4 | 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=107921 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 = 1458383843 WHERE name_hash = MD5('var/tiempo/cache/content/tiempo/1/0/7/6/107679-5e4d46556b3e1d87d401a04c6401aacd.cache.generating') AND mtime = 1458383842
|
dfs::storeContents( 'var/tiempo/cache/content/tiempo/1/0/7/6/107679-5e4d46556b3e1d87d401a04c6401aacd.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/107679-5e4d46556b3e1d87d401a04c6401aacd.cache.generating', 'var/tiempo/cache/content/tiempo/1/0/7/6/107679-', 'e73fa23fd874cf6bc8ad71f478acf722', 'viewcache', 25736, 1458383843, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/tiempo/cache/content/tiempo/1/0/7/6/107679-', 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/107679-5e4d46556b3e1d87d401a04c6401aacd.cache.generating') FOR UPDATE
|
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/content/tiempo/1/0/7/6/107679-5e4d46556b3e1d87d401a04c6401aacd.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/107679-5e4d46556b3e1d87d401a04c6401aacd.cache', 'var/tiempo/cache/content/tiempo/1/0/7/6/107679-', '3df4d5d554d219747e7e30e67c2908a2', 'viewcache', '25736', '1458383843', '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/107679-5e4d46556b3e1d87d401a04c6401aacd.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 'opinion/%' 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/4/2/0/4209172993.cache' )
|
SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/4/2/0/4209172993.cache')
RESULT:
array (
'datatype' => 'misc',
'name' => 'var/tiempo/cache/template-block/4/2/0/4209172993.cache',
'name_trunk' => 'var/tiempo/cache/template-block/4/2/0/4209172993.cache',
'name_hash' => '1bb0f8be31024e01e8a9475f27e7f478',
'scope' => 'template-block',
'size' => '549',
'mtime' => '1458315453',
'expired' => '0',
)
|
Processing local cache file var/tiempo/cache/template-block/4/2/0/4209172993.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/5/6/5/565137246.cache' )
|
SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/5/6/5/565137246.cache')
RESULT:
array (
'datatype' => 'misc',
'name' => 'var/tiempo/cache/template-block/5/6/5/565137246.cache',
'name_trunk' => 'var/tiempo/cache/template-block/5/6/5/565137246.cache',
'name_hash' => '5dd24748f4ab89bb10013a93cbb1c711',
'scope' => 'template-block',
'size' => '1637',
'mtime' => '1458378035',
'expired' => '0',
)
|
Processing local cache file var/tiempo/cache/template-block/5/6/5/565137246.cache
|
dfs::ctor( 'var/tiempo/cache/template-block/2/9/5/295714944.cache' )
|
SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/2/9/5/295714944.cache')
RESULT:
array (
'datatype' => 'misc',
'name' => 'var/tiempo/cache/template-block/2/9/5/295714944.cache',
'name_trunk' => 'var/tiempo/cache/template-block/2/9/5/295714944.cache',
'name_hash' => 'e422d5cc0f4af8aa4c44171e5ba77be0',
'scope' => 'template-block',
'size' => '4006',
'mtime' => '1458376903',
'expired' => '0',
)
|
Processing local cache file var/tiempo/cache/template-block/2/9/5/295714944.cache
|
dfs::ctor( 'var/tiempo/cache/template-block/4/3/9/439501116.cache' )
|
SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/4/3/9/439501116.cache')
RESULT:
array (
'datatype' => 'misc',
'name' => 'var/tiempo/cache/template-block/4/3/9/439501116.cache',
'name_trunk' => 'var/tiempo/cache/template-block/4/3/9/439501116.cache',
'name_hash' => '8e49376e34c7e752f03b5b4027e028f8',
'scope' => 'template-block',
'size' => '1437',
'mtime' => '1458315453',
'expired' => '0',
)
|
Processing local cache file var/tiempo/cache/template-block/4/3/9/439501116.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/4/2/7/4279511330.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/4/2/7/4279511330.cache')
RESULT:
array (
'datatype' => 'misc',
'name' => 'var/tiempo/cache/template-block/subtree/2/cache/4/2/7/4279511330.cache',
'name_trunk' => 'var/tiempo/cache/template-block/subtree/2/cache/',
'name_hash' => '087c9b847a8db78bf1070a904ae54f4e',
'scope' => 'template-block',
'size' => '319',
'mtime' => '1458378035',
'expired' => '0',
)
|
Processing local cache file var/tiempo/cache/template-block/subtree/2/cache/4/2/7/4279511330.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/2/1/4/214477857.cache' )
|
Local file (mtime=1458379578) is older than timestamp (1458380708) and ttl(1800), check with DB
|
SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/2/1/4/214477857.cache')
RESULT:
array (
'datatype' => 'misc',
'name' => 'var/tiempo/cache/template-block/2/1/4/214477857.cache',
'name_trunk' => 'var/tiempo/cache/template-block/2/1/4/214477857.cache',
'name_hash' => 'd17e58d0ee24761a35ea86729277f4d8',
'scope' => 'template-block',
'size' => '66902',
'mtime' => '1458382937',
'expired' => '0',
)
|
Callback from DB file var/tiempo/cache/template-block/2/1/4/214477857.cache
|
dfs::fileFetch( 'var/tiempo/cache/template-block/2/1/4/214477857.cache' )
|
SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/2/1/4/214477857.cache')
RESULT:
array (
'datatype' => 'misc',
'name' => 'var/tiempo/cache/template-block/2/1/4/214477857.cache',
'name_trunk' => 'var/tiempo/cache/template-block/2/1/4/214477857.cache',
'name_hash' => 'd17e58d0ee24761a35ea86729277f4d8',
'scope' => 'template-block',
'size' => '66902',
'mtime' => '1458382937',
'expired' => '0',
)
|
dfs::ctor( 'var/tiempo/cache/template-block/1/7/7/1774035101.cache' )
|
SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/tiempo/cache/template-block/1/7/7/1774035101.cache')
RESULT:
array (
'datatype' => 'misc',
'name' => 'var/tiempo/cache/template-block/1/7/7/1774035101.cache',
'name_trunk' => 'var/tiempo/cache/template-block/1/7/7/1774035101.cache',
'name_hash' => '134f56c9ce50355abb65d85728b91e68',
'scope' => 'template-block',
'size' => '1033',
'mtime' => '1458315453',
'expired' => '0',
)
|
Processing local cache file var/tiempo/cache/template-block/1/7/7/1774035101.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' => '1458382304',
'expired' => '0',
)
|
Processing local cache file var/tiempo/cache/template-block/3/8/0/3805626181.cache
|
EXPLAIN
SELECT visits
FROM ezhit WHERE node_id='107679' 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='107679' 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=33 WHERE node_id='107679' AND startdatetimestamp='1458342000'
|
End
|
Timing points:
| Checkpoint |
Elapsed |
Rel. Elapsed |
Memory |
Rel. Memory |
| Module start 'content' |
0.0000 sec |
0.2759 sec |
2,662.8125 KB |
4,539.3672 KB |
| Module end 'content' |
0.2759 sec |
0.0567 sec |
7,202.1797 KB |
412.9844 KB |
| End |
0.3326 sec |
|
7,615.1641 KB |
|
| Total runtime: |
0.3398 sec |
|
| Peak memory usage: |
10,414.0938 KB |
Time accumulators:
| Accumulator |
Elapsed |
Percent |
Count |
Average |
| ini_load |
|
|
|
|
| Load cache |
0.0063 sec |
1.6784% |
15 |
0.0004 sec |
| Mysql Total |
|
|
|
|
| Mysql_queries |
0.1397 sec |
37.1726% |
52 |
0.0027 sec |
| Looping result |
0.0006 sec |
0.1616% |
44 |
0.0000 sec |
| MySQL Cluster |
|
|
|
|
| DB queries |
0.0383 sec |
10.1810% |
36 |
0.0011 sec |
| DFS operations |
0.0170 sec |
4.5356% |
3 |
0.0057 sec |
| TS translator |
|
|
|
|
| TS init |
0.0031 sec |
0.8200% |
4 |
0.0008 sec |
| TS cache load |
0.0023 sec |
0.6077% |
4 |
0.0006 sec |
| TS context load |
0.0017 sec |
0.4613% |
4 |
0.0004 sec |
| Template Total |
0.2479 sec |
66.0% |
3 |
0.0826 sec |
| Template load |
0.0057 sec |
1.5080% |
3 |
0.0019 sec |
| Template processing |
0.2421 sec |
64.4105% |
3 |
0.0807 sec |
| Template load and register function |
0.0001 sec |
0.0295% |
1 |
0.0001 sec |
| states |
|
|
|
|
| state_id_array |
0.0018 sec |
0.4773% |
1 |
0.0018 sec |
| state_identifier_array |
0.0080 sec |
2.1238% |
2 |
0.0040 sec |
| override |
|
|
|
|
| Cache load |
0.0055 sec |
1.4548% |
108 |
0.0001 sec |
| Sytem overhead |
|
|
|
|
| Fetch class attribute name |
0.0107 sec |
2.8553% |
3 |
0.0036 sec |
| Fetch class attribute can translate value |
0.0032 sec |
0.8394% |
1 |
0.0032 sec |
| class_abstraction |
|
|
|
|
| Instantiating content class attribute |
0.0000 sec |
0.0093% |
4 |
0.0000 sec |
| XML |
|
|
|
|
| Image XML parsing |
0.0119 sec |
3.1542% |
1 |
0.0119 sec |
| General |
|
|
|
|
| String conversion |
0.0000 sec |
0.0032% |
2 |
0.0000 sec |
| Total script time: |
0.3759 sec |
|
Templates used to render the page:
|
