yu-front-06.localdomain (172.30.2.194:443)
prod.yumping.com
/contenido-Show.php
BBDD->Prod_Yumping_es_ES
AMBITO->es_ch
AMBITO_AJAX->es_ch
AMBITO_AJAX COOKIE->
locale LO_CONFIG->zh_CN
locale php->zh_CN
Fuente tráfico->0
SESSION VARS
DEFINED VARS
$tpage->
contenidoShowCache VARS
NOCFG->memcache_port->11212
CFG->memcache_main_server->172.30.2.194
CFG->memcache_add_servers->172.30.2.194
YMMemcache::memcache_stats->
SERVER VARS
HTTP_REFERER
Request VARS
ambito_lang->zh-hans
id_contenido->912
tpage->contenidoShow
rel_alternate->1
Total queries: 222
Tiempo total: 3.497481584549
>= 2 and < 3 (1)
>0.1 and < 2 (1)
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[1]: SELECT CFG.ID, CFG.NAME, IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '', CFG.VALUE_PROD, CFG.VALUE) VALUE , CFG.AMBITO, CFG.VISIBLE_AJAX, CFG.TIME
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.AMBITO IN ('global', 'es_ch')
ORDER BY CFG.NAME;
Tiempo de la consulta:
0.011331081390381Tiempo acumulado:0.011331081390381
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[2]: SELECT IF(VALUE_PROD IS NULL, VALUE, VALUE_PROD) as VAL, NAME
FROM LO_CONFIG C
WHERE C.NAME in ('Request_Data_Base_Country','Request_Multi_Country')
AND AMBITO = 'es';
Tiempo de la consulta:
0.011940002441406Tiempo acumulado:0.023271083831787
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[3]: SELECT ID_PAIS
FROM ( SELECT 28 AS ID_PAIS
FROM Prod_Yumping_es_ES.LO_CONTENIDOS C
LEFT JOIN Prod_Yumping_es_ES.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = C.ID_CONTENIDO
WHERE C.ID_CONTENIDO = 912
/*
AND (
fnGoogleUrl(C.TITULO) = 'wan-sheng-jie-de-yuan-ji-hua'
OR fnGoogleUrl(CT.TITULO) = 'wan-sheng-jie-de-yuan-ji-hua'
OR URL_CT = 'wan-sheng-jie-de-yuan-ji-hua') */ UNION ALL SELECT 48 AS ID_PAIS
FROM Prod_Yumping_pt_PT.LO_CONTENIDOS C
LEFT JOIN Prod_Yumping_pt_PT.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = C.ID_CONTENIDO
WHERE C.ID_CONTENIDO = 912
/*
AND (
fnGoogleUrl(C.TITULO) = 'wan-sheng-jie-de-yuan-ji-hua'
OR fnGoogleUrl(CT.TITULO) = 'wan-sheng-jie-de-yuan-ji-hua'
OR URL_CT = 'wan-sheng-jie-de-yuan-ji-hua') */ UNION ALL SELECT 29 AS ID_PAIS
FROM Prod_Yumping_it_IT.LO_CONTENIDOS C
LEFT JOIN Prod_Yumping_it_IT.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = C.ID_CONTENIDO
WHERE C.ID_CONTENIDO = 912
/*
AND (
fnGoogleUrl(C.TITULO) = 'wan-sheng-jie-de-yuan-ji-hua'
OR fnGoogleUrl(CT.TITULO) = 'wan-sheng-jie-de-yuan-ji-hua'
OR URL_CT = 'wan-sheng-jie-de-yuan-ji-hua') */ UNION ALL SELECT 64 AS ID_PAIS
FROM Prod_Yumping_fr_FR.LO_CONTENIDOS C
LEFT JOIN Prod_Yumping_fr_FR.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = C.ID_CONTENIDO
WHERE C.ID_CONTENIDO = 912
/*
AND (
fnGoogleUrl(C.TITULO) = 'wan-sheng-jie-de-yuan-ji-hua'
OR fnGoogleUrl(CT.TITULO) = 'wan-sheng-jie-de-yuan-ji-hua'
OR URL_CT = 'wan-sheng-jie-de-yuan-ji-hua') */ UNION ALL SELECT 247 AS ID_PAIS
FROM Prod_Yumping_co_UK.LO_CONTENIDOS C
LEFT JOIN Prod_Yumping_co_UK.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = C.ID_CONTENIDO
WHERE C.ID_CONTENIDO = 912
/*
AND (
fnGoogleUrl(C.TITULO) = 'wan-sheng-jie-de-yuan-ji-hua'
OR fnGoogleUrl(CT.TITULO) = 'wan-sheng-jie-de-yuan-ji-hua'
OR URL_CT = 'wan-sheng-jie-de-yuan-ji-hua') */ UNION ALL SELECT 301 AS ID_PAIS
FROM Prod_Yumping_mx_MX.LO_CONTENIDOS C
LEFT JOIN Prod_Yumping_mx_MX.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = C.ID_CONTENIDO
WHERE C.ID_CONTENIDO = 912
/*
AND (
fnGoogleUrl(C.TITULO) = 'wan-sheng-jie-de-yuan-ji-hua'
OR fnGoogleUrl(CT.TITULO) = 'wan-sheng-jie-de-yuan-ji-hua'
OR URL_CT = 'wan-sheng-jie-de-yuan-ji-hua') */ ) AS CONTENIDO;
Tiempo de la consulta:
0.054666996002197Tiempo acumulado:0.077938079833984
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[4]: SELECT CFG.ID, CFG.NAME, IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '', CFG.VALUE_PROD, CFG.VALUE) VALUE , CFG.AMBITO, CFG.VISIBLE_AJAX, CFG.TIME
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.AMBITO IN ('global', 'es_ch')
ORDER BY CFG.NAME;
Tiempo de la consulta:
0.019540071487427Tiempo acumulado:0.097478151321411
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[5]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.0063900947570801Tiempo acumulado:0.10386824607849
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[6]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.0075500011444092Tiempo acumulado:0.1114182472229
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[7]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'ambito_lang';
Tiempo de la consulta:
0.00068902969360352Tiempo acumulado:0.1121072769165
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[8]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'id_contenido';
Tiempo de la consulta:
0.0086109638214111Tiempo acumulado:0.12071824073792
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[9]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'tpage';
Tiempo de la consulta:
0.00061798095703125Tiempo acumulado:0.12133622169495
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[10]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'rel_alternate';
Tiempo de la consulta:
0.0011610984802246Tiempo acumulado:0.12249732017517
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[11]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0066308975219727Tiempo acumulado:0.12912821769714
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[12]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.011245965957642Tiempo acumulado:0.14037418365479
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[13]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.01012396812439Tiempo acumulado:0.15049815177917
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[14]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0014889240264893Tiempo acumulado:0.15198707580566
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[15]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_multidioma'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0014700889587402Tiempo acumulado:0.1534571647644
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[16]: SELECT 'es_ch' AS AMBIO, CON.FK_ID_EMPRESA_CON, CON.ID_CONTENIDO,CON.TIPO_CONTENIDOS, CON.TITULO,
CON.DESCRIPCION, CON.TEXTO, CON.OPERATOR_INSERT,
DATE_FORMAT(CON.FEC_INSERT,'%d/%m/%y') AS FEC_INSERT, CON.GALERIA, CON.GALERIA_DESC, CON.FOTOPRINCIPAL,
AD.MAIL, CAT.ID_SECTOR,VIDEOS_CODE_CON,CON.VIDEOS_TEXT_CON,CON.VIDEOS_DESC_CON,CAT.ID_GRUPO_CAT/*,CON.NOMBRE_FIRMA_CON, NOMBRE_FIRMA_CON,PUESTO_FIRMA_CON,ENLACE_FIRMA_CON,FOTO_FIRMA_CON*/,AD.AVATAR,AD.NOMBRE,CAT.ID_CATEG
, CA.JOB, CA.AVATAR, CA.URL, IF(CA.NOMBRE IS NOT NULL, CA.NOMBRE, AD.NOMBRE) AS NOMBRE, CA.ID AS ID_AUTOR,
DATE_FORMAT(CON.FEC_INSERT, '%d') DAY_INSERT,
DATE_FORMAT(CON.FEC_INSERT, '%m') MONTH_INSERT,
DATE_FORMAT(CON.FEC_INSERT, '%Y') YEAR_INSERT,
DATE_FORMAT(CON.FEC_INSERT, '%H:%i') HORA_INSERT,
DATE_FORMAT(CON.FEC_ULT_MODIF, '%d') DAY_MOD,
DATE_FORMAT(CON.FEC_ULT_MODIF, '%m') MONTH_MOD,
DATE_FORMAT(CON.FEC_ULT_MODIF, '%Y') YEAR_MOD,
DATE_FORMAT(CON.FEC_ULT_MODIF, '%H:%i') HORA_MOD, DATE_FORMAT(CON.FEC_INSERT, '%Y-%m-%dT%H:%i') IN_GOOGLE, DATE_FORMAT(CON.FEC_ULT_MODIF, '%Y-%m-%dT%H:%i') MOD_GOOGLE , CT.DESCRIPCION AS DESC_CORTA,URL_CT ,CT.TITULO, CT.DESCRIPCION, CT.TEXTO, CT.GALERIA_DESC, CT.VIDEOS_TEXT_CON, CT.VIDEOS_DESC_CON
FROM Prod_Yumping_es_ES.LO_CONTENIDOS CON
INNER JOIN Prod_Yumping_es_ES.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = CON.ID_CONTENIDO
AND LANGUAGE = 'ch'
INNER JOIN Prod_Yumping_es_ES.LO_CONTENIDOS_CATEG CAT ON CON.ID_CATEG=CAT.ID_CATEG
INNER JOIN Prod_Yumping_es_ES.LO_CONTENIDOS_CATEG_I18N CATI ON CON.ID_CATEG=CATI.ID_CATEG
AND CAT.ID_CATEG=CATI.ID_CATEG
INNER JOIN Prod_Yumping_es_ES.LO_ADMIN_USERS AD ON AD.LOGIN=CON.OPERATOR_INSERT
LEFT JOIN Prod_Yumping_es_ES.LO_CONTENIDO_AUTORES CA ON CA.ID_ADMIN = AD.ID_ADMIN
AND CA.ID_TROPIC = 16
WHERE CON.ID_CONTENIDO=912
AND CON.VALID=1
AND CATI.ID_TROPIC=16;
Tiempo de la consulta:
0.0099251270294189Tiempo acumulado:0.16338229179382
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[17]: SELECT DISTINCT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO
FROM LO_SECTORES SEC, LO_SECTORES_I18N SECI, LO_CONTENIDOS CON, LO_CONTENIDOS_CATEG CAT, LO_CONTENIDOS_CATEG_I18N CATI
WHERE SEC.ID_SECTOR='0'
AND CAT.ID_CATEG=CATI.ID_CATEG
AND CON.ID_CONTENIDO='912'
AND CON.VALID=1
AND SECI.ID_SECTOR=SEC.ID_SECTOR
AND SECI.ID_TROPIC = 16
AND CATI.ID_TROPIC = 1
AND CON.ID_CATEG = CATI.ID_CATEG
AND CAT.ID_SECTOR=SEC.ID_SECTOR;
Tiempo de la consulta:
0.007112979888916Tiempo acumulado:0.17049527168274
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[18]: SELECT COMUS.ID_USER,COMUS.ROL, COMUS.AVATAR,COMUS.NOMBRE, CONTOP.COMENTARIO_CONTOP,
CONT.TITULO,CONT.ID_CONTENIDO,
DATE_FORMAT(FECHA_CONTOP,'%d/%m/%Y %H:%i') as FECHA_CONTOP
FROM LO_CONTENIDOS_OPINIONES CONTOP
INNER JOIN LO_CONTENIDOS CONT ON CONTOP.FK_ID_CONTENIDO=CONT.ID_CONTENIDO
AND CONT.ID_TROPIC='1'
INNER JOIN LO_COM_USERS COMUS ON CONTOP.ID_USER_CONTOP = COMUS.ID_USER
WHERE CONTOP.ID_USER_CONTOP<>'0'
ORDER BY RAND()
LIMIT 4;
Tiempo de la consulta:
0.013011932373047Tiempo acumulado:0.18350720405579
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[19]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00075006484985352Tiempo acumulado:0.18425726890564
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[20]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0042359828948975Tiempo acumulado:0.18849325180054
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[21]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0097260475158691Tiempo acumulado:0.19821929931641
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[22]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.010276079177856Tiempo acumulado:0.20849537849426
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[23]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00068998336791992Tiempo acumulado:0.20918536186218
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[24]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045299530029297Tiempo acumulado:0.20963835716248
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[25]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0010991096496582Tiempo acumulado:0.21073746681213
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[26]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0009610652923584Tiempo acumulado:0.21169853210449
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[27]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00056195259094238Tiempo acumulado:0.21226048469543
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[28]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0010159015655518Tiempo acumulado:0.21327638626099
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[29]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00068402290344238Tiempo acumulado:0.21396040916443
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[30]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00090193748474121Tiempo acumulado:0.21486234664917
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[31]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00142502784729Tiempo acumulado:0.21628737449646
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[32]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.005871057510376Tiempo acumulado:0.22215843200684
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[33]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00095105171203613Tiempo acumulado:0.22310948371887
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[34]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('mx_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0019831657409668Tiempo acumulado:0.22509264945984
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[35]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('mx_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0023510456085205Tiempo acumulado:0.22744369506836
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[36]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('mx_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0064849853515625Tiempo acumulado:0.23392868041992
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[37]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('mx_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00070095062255859Tiempo acumulado:0.23462963104248
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[38]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('mx_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00048279762268066Tiempo acumulado:0.23511242866516
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[39]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('it_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0031619071960449Tiempo acumulado:0.23827433586121
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[40]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('it_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0032730102539062Tiempo acumulado:0.24154734611511
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[41]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('it_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0018711090087891Tiempo acumulado:0.2434184551239
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[42]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('it_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00067400932312012Tiempo acumulado:0.24409246444702
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[43]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('it_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00069880485534668Tiempo acumulado:0.24479126930237
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[44]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('fr_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00076413154602051Tiempo acumulado:0.24555540084839
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[45]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('fr_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0037720203399658Tiempo acumulado:0.24932742118835
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[46]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('fr_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00061583518981934Tiempo acumulado:0.24994325637817
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[47]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('fr_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00063300132751465Tiempo acumulado:0.25057625770569
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[48]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('fr_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.003917932510376Tiempo acumulado:0.25449419021606
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[49]: SELECT SUM(TOTAL) AS TOTAL,TIPO_CONTENIDOS,ID_GRUPO_CAT, DESC_GRUPO, URL
FROM (SELECT COUNT(*) AS TOTAL,CON.TIPO_CONTENIDOS,CATEG.ID_GRUPO_CAT, CG.DESC_GRUPO, CG.URL
FROM Prod_Yumping_es_ES.LO_CONTENIDOS CON
INNER JOIN Prod_Yumping_es_ES.LO_ADMIN_USERS AD ON CON.OPERATOR_INSERT=AD.LOGIN
INNER JOIN Prod_Yumping_es_ES.LO_CONTENIDOS_CATEG CATEG ON CON.ID_CATEG=CATEG.ID_CATEG
INNER JOIN Prod_Yumping_es_ES.LO_CONTENIDOS_GRUPOS CG ON CG.ID_GRUPO_CAT = CATEG.ID_GRUPO_CAT
AND CG.ID_TROPIC = '16'
WHERE (CON.GALERIA IS NOT NULL
AND CON.GALERIA<>'')
AND CON.ID_TROPIC='1'
AND CON.VALID=1
GROUP BY TIPO_CONTENIDOS,ID_GRUPO_CAT
UNION ALL SELECT COUNT(*) AS TOTAL,CON.TIPO_CONTENIDOS,CATEG.ID_GRUPO_CAT, CG.DESC_GRUPO, CG.URL
FROM Prod_Yumping_pt_PT.LO_CONTENIDOS CON
INNER JOIN Prod_Yumping_pt_PT.LO_ADMIN_USERS AD ON CON.OPERATOR_INSERT=AD.LOGIN
INNER JOIN Prod_Yumping_pt_PT.LO_CONTENIDOS_CATEG CATEG ON CON.ID_CATEG=CATEG.ID_CATEG
INNER JOIN Prod_Yumping_pt_PT.LO_CONTENIDOS_GRUPOS CG ON CG.ID_GRUPO_CAT = CATEG.ID_GRUPO_CAT
AND CG.ID_TROPIC = '86'
WHERE (CON.GALERIA IS NOT NULL
AND CON.GALERIA<>'')
AND CON.ID_TROPIC='8'
AND CON.VALID=1
GROUP BY TIPO_CONTENIDOS,ID_GRUPO_CAT
UNION ALL SELECT COUNT(*) AS TOTAL,CON.TIPO_CONTENIDOS,CATEG.ID_GRUPO_CAT, CG.DESC_GRUPO, CG.URL
FROM Prod_Yumping_co_UK.LO_CONTENIDOS CON
INNER JOIN Prod_Yumping_co_UK.LO_ADMIN_USERS AD ON CON.OPERATOR_INSERT=AD.LOGIN
INNER JOIN Prod_Yumping_co_UK.LO_CONTENIDOS_CATEG CATEG ON CON.ID_CATEG=CATEG.ID_CATEG
INNER JOIN Prod_Yumping_co_UK.LO_CONTENIDOS_GRUPOS CG ON CG.ID_GRUPO_CAT = CATEG.ID_GRUPO_CAT
AND CG.ID_TROPIC = '26'
WHERE (CON.GALERIA IS NOT NULL
AND CON.GALERIA<>'')
AND CON.ID_TROPIC='2'
AND CON.VALID=1
GROUP BY TIPO_CONTENIDOS,ID_GRUPO_CAT
UNION ALL SELECT COUNT(*) AS TOTAL,CON.TIPO_CONTENIDOS,CATEG.ID_GRUPO_CAT, CG.DESC_GRUPO, CG.URL
FROM Prod_Yumping_mx_MX.LO_CONTENIDOS CON
INNER JOIN Prod_Yumping_mx_MX.LO_ADMIN_USERS AD ON CON.OPERATOR_INSERT=AD.LOGIN
INNER JOIN Prod_Yumping_mx_MX.LO_CONTENIDOS_CATEG CATEG ON CON.ID_CATEG=CATEG.ID_CATEG
INNER JOIN Prod_Yumping_mx_MX.LO_CONTENIDOS_GRUPOS CG ON CG.ID_GRUPO_CAT = CATEG.ID_GRUPO_CAT
AND CG.ID_TROPIC = '56'
WHERE (CON.GALERIA IS NOT NULL
AND CON.GALERIA<>'')
AND CON.ID_TROPIC='5'
AND CON.VALID=1
GROUP BY TIPO_CONTENIDOS,ID_GRUPO_CAT
UNION ALL SELECT COUNT(*) AS TOTAL,CON.TIPO_CONTENIDOS,CATEG.ID_GRUPO_CAT, CG.DESC_GRUPO, CG.URL
FROM Prod_Yumping_it_IT.LO_CONTENIDOS CON
INNER JOIN Prod_Yumping_it_IT.LO_ADMIN_USERS AD ON CON.OPERATOR_INSERT=AD.LOGIN
INNER JOIN Prod_Yumping_it_IT.LO_CONTENIDOS_CATEG CATEG ON CON.ID_CATEG=CATEG.ID_CATEG
INNER JOIN Prod_Yumping_it_IT.LO_CONTENIDOS_GRUPOS CG ON CG.ID_GRUPO_CAT = CATEG.ID_GRUPO_CAT
AND CG.ID_TROPIC = '36'
WHERE (CON.GALERIA IS NOT NULL
AND CON.GALERIA<>'')
AND CON.ID_TROPIC='3'
AND CON.VALID=1
GROUP BY TIPO_CONTENIDOS,ID_GRUPO_CAT
UNION ALL SELECT COUNT(*) AS TOTAL,CON.TIPO_CONTENIDOS,CATEG.ID_GRUPO_CAT, CG.DESC_GRUPO, CG.URL
FROM Prod_Yumping_fr_FR.LO_CONTENIDOS CON
INNER JOIN Prod_Yumping_fr_FR.LO_ADMIN_USERS AD ON CON.OPERATOR_INSERT=AD.LOGIN
INNER JOIN Prod_Yumping_fr_FR.LO_CONTENIDOS_CATEG CATEG ON CON.ID_CATEG=CATEG.ID_CATEG
INNER JOIN Prod_Yumping_fr_FR.LO_CONTENIDOS_GRUPOS CG ON CG.ID_GRUPO_CAT = CATEG.ID_GRUPO_CAT
AND CG.ID_TROPIC = '46'
WHERE (CON.GALERIA IS NOT NULL
AND CON.GALERIA<>'')
AND CON.ID_TROPIC='4'
AND CON.VALID=1
GROUP BY TIPO_CONTENIDOS,ID_GRUPO_CAT
) AS CATEGORIAS
GROUP BY TIPO_CONTENIDOS,ID_GRUPO_CAT
ORDER BY ID_GRUPO_CAT ASC;
Tiempo de la consulta:
0.075594902038574Tiempo acumulado:0.33008909225464
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[50]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 912
AND FOTO = 'Una espeluznante cena.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0019979476928711Tiempo acumulado:0.33208703994751
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[51]: SELECT OLD_URL, NEW_URL
FROM LO_URL_301 U
WHERE U.OLD_URL = '/zh-hans/mao-xian-ti-yu-xin-wen/wan-sheng-jie-de-yuan-ji-hua--c912';
Tiempo de la consulta:
0.0038290023803711Tiempo acumulado:0.33591604232788
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[52]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00052905082702637Tiempo acumulado:0.33644509315491
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[53]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_multidioma'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0041780471801758Tiempo acumulado:0.34062314033508
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[54]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0027840137481689Tiempo acumulado:0.34340715408325
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[55]: SELECT C.* , CT.DESCRIPCION AS DESC_CORTA,URL_CT ,CT.TITULO, CT.DESCRIPCION, CT.TEXTO, CT.GALERIA_DESC, CT.VIDEOS_TEXT_CON, CT.VIDEOS_DESC_CON
FROM Prod_Yumping_es_ES.LO_CONTENIDOS C
INNER JOIN Prod_Yumping_es_ES.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = C.ID_CONTENIDO
AND LANGUAGE = 'en'
WHERE C.ID_CONTENIDO = 912;
Tiempo de la consulta:
0.00065517425537109Tiempo acumulado:0.34406232833862
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[56]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.010548114776611Tiempo acumulado:0.35461044311523
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[57]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0005030632019043Tiempo acumulado:0.35511350631714
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[58]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_multidioma'
AND CFG.AMBITO IN ('es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.003554105758667Tiempo acumulado:0.35866761207581
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[59]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0013260841369629Tiempo acumulado:0.35999369621277
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[60]: SELECT C.* , C.DESCRIPCION AS DESC_CORTA,'' as URL_CT ,C.TITULO, C.DESCRIPCION, C.TEXTO, C.GALERIA_DESC, C.VIDEOS_TEXT_CON, C.VIDEOS_DESC_CON
FROM Prod_Yumping_es_ES.LO_CONTENIDOS C
WHERE C.ID_CONTENIDO = 912;
Tiempo de la consulta:
0.00078797340393066Tiempo acumulado:0.3607816696167
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[61]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0026259422302246Tiempo acumulado:0.36340761184692
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[62]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('es_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0028450489044189Tiempo acumulado:0.36625266075134
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[63]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_multidioma'
AND CFG.AMBITO IN ('es_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.001276969909668Tiempo acumulado:0.36752963066101
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[64]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('es_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0038661956787109Tiempo acumulado:0.37139582633972
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[65]: SELECT C.* , CT.DESCRIPCION AS DESC_CORTA,URL_CT ,CT.TITULO, CT.DESCRIPCION, CT.TEXTO, CT.GALERIA_DESC, CT.VIDEOS_TEXT_CON, CT.VIDEOS_DESC_CON
FROM Prod_Yumping_es_ES.LO_CONTENIDOS C
INNER JOIN Prod_Yumping_es_ES.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = C.ID_CONTENIDO
AND LANGUAGE = 'fr'
WHERE C.ID_CONTENIDO = 912;
Tiempo de la consulta:
0.0029258728027344Tiempo acumulado:0.37432169914246
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[66]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('es_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047087669372559Tiempo acumulado:0.37479257583618
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[67]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('es_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0044889450073242Tiempo acumulado:0.37928152084351
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[68]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_multidioma'
AND CFG.AMBITO IN ('es_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00075507164001465Tiempo acumulado:0.38003659248352
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[69]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('es_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0031619071960449Tiempo acumulado:0.38319849967957
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[70]: SELECT C.* , CT.DESCRIPCION AS DESC_CORTA,URL_CT ,CT.TITULO, CT.DESCRIPCION, CT.TEXTO, CT.GALERIA_DESC, CT.VIDEOS_TEXT_CON, CT.VIDEOS_DESC_CON
FROM Prod_Yumping_es_ES.LO_CONTENIDOS C
INNER JOIN Prod_Yumping_es_ES.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = C.ID_CONTENIDO
AND LANGUAGE = 'it'
WHERE C.ID_CONTENIDO = 912;
Tiempo de la consulta:
0.0018191337585449Tiempo acumulado:0.38501763343811
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[71]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('es_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0011482238769531Tiempo acumulado:0.38616585731506
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[72]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('es_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0044209957122803Tiempo acumulado:0.39058685302734
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[73]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_multidioma'
AND CFG.AMBITO IN ('es_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00052881240844727Tiempo acumulado:0.39111566543579
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[74]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('es_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00094699859619141Tiempo acumulado:0.39206266403198
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[75]: SELECT C.* , CT.DESCRIPCION AS DESC_CORTA,URL_CT ,CT.TITULO, CT.DESCRIPCION, CT.TEXTO, CT.GALERIA_DESC, CT.VIDEOS_TEXT_CON, CT.VIDEOS_DESC_CON
FROM Prod_Yumping_es_ES.LO_CONTENIDOS C
INNER JOIN Prod_Yumping_es_ES.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = C.ID_CONTENIDO
AND LANGUAGE = 'de'
WHERE C.ID_CONTENIDO = 912;
Tiempo de la consulta:
0.00088405609130859Tiempo acumulado:0.39294672012329
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[76]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('es_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049090385437012Tiempo acumulado:0.39343762397766
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[77]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('es_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049304962158203Tiempo acumulado:0.39393067359924
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[78]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_multidioma'
AND CFG.AMBITO IN ('es_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0019829273223877Tiempo acumulado:0.39591360092163
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[79]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('es_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00054287910461426Tiempo acumulado:0.39645648002625
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[80]: SELECT C.* , CT.DESCRIPCION AS DESC_CORTA,URL_CT ,CT.TITULO, CT.DESCRIPCION, CT.TEXTO, CT.GALERIA_DESC, CT.VIDEOS_TEXT_CON, CT.VIDEOS_DESC_CON
FROM Prod_Yumping_es_ES.LO_CONTENIDOS C
INNER JOIN Prod_Yumping_es_ES.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = C.ID_CONTENIDO
AND LANGUAGE = 'pt'
WHERE C.ID_CONTENIDO = 912;
Tiempo de la consulta:
0.00073504447937012Tiempo acumulado:0.39719152450562
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[81]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('es_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00084090232849121Tiempo acumulado:0.39803242683411
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[82]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('es_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00048589706420898Tiempo acumulado:0.39851832389832
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[83]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_multidioma'
AND CFG.AMBITO IN ('es_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0011649131774902Tiempo acumulado:0.39968323707581
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[84]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('es_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0030980110168457Tiempo acumulado:0.40278124809265
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[85]: SELECT C.* , CT.DESCRIPCION AS DESC_CORTA,URL_CT ,CT.TITULO, CT.DESCRIPCION, CT.TEXTO, CT.GALERIA_DESC, CT.VIDEOS_TEXT_CON, CT.VIDEOS_DESC_CON
FROM Prod_Yumping_es_ES.LO_CONTENIDOS C
INNER JOIN Prod_Yumping_es_ES.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = C.ID_CONTENIDO
AND LANGUAGE = 'mx'
WHERE C.ID_CONTENIDO = 912;
Tiempo de la consulta:
0.0012421607971191Tiempo acumulado:0.40402340888977
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[86]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('es_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00087594985961914Tiempo acumulado:0.40489935874939
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[87]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0012388229370117Tiempo acumulado:0.4061381816864
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[88]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00060009956359863Tiempo acumulado:0.40673828125
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[89]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00082492828369141Tiempo acumulado:0.40756320953369
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[90]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0021228790283203Tiempo acumulado:0.40968608856201
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[91]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00082898139953613Tiempo acumulado:0.41051506996155
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[92]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00084900856018066Tiempo acumulado:0.41136407852173
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[93]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0009150505065918Tiempo acumulado:0.41227912902832
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[94]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain'
AND CFG.AMBITO IN ('es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00077295303344727Tiempo acumulado:0.41305208206177
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[95]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0011107921600342Tiempo acumulado:0.4141628742218
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[96]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00061702728271484Tiempo acumulado:0.41477990150452
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[97]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00053095817565918Tiempo acumulado:0.41531085968018
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[98]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046706199645996Tiempo acumulado:0.41577792167664
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[99]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00053691864013672Tiempo acumulado:0.41631484031677
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[100]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0020840167999268Tiempo acumulado:0.4183988571167
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[101]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0030190944671631Tiempo acumulado:0.42141795158386
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[102]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('es_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0027499198913574Tiempo acumulado:0.42416787147522
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[103]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00068902969360352Tiempo acumulado:0.42485690116882
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[104]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0031619071960449Tiempo acumulado:0.42801880836487
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[105]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0035669803619385Tiempo acumulado:0.43158578872681
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[106]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0012979507446289Tiempo acumulado:0.43288373947144
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[107]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('es_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0016279220581055Tiempo acumulado:0.43451166152954
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[108]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0032639503479004Tiempo acumulado:0.43777561187744
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[109]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0015439987182617Tiempo acumulado:0.4393196105957
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[110]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0020740032196045Tiempo acumulado:0.44139361381531
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[111]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0018820762634277Tiempo acumulado:0.44327569007874
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[112]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('es_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00063014030456543Tiempo acumulado:0.4439058303833
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[113]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0015790462493896Tiempo acumulado:0.44548487663269
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[114]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00062990188598633Tiempo acumulado:0.44611477851868
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[115]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0016310214996338Tiempo acumulado:0.44774580001831
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[116]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.001575231552124Tiempo acumulado:0.44932103157043
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[117]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('es_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00073480606079102Tiempo acumulado:0.45005583763123
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[118]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0016598701477051Tiempo acumulado:0.45171570777893
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[119]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00062084197998047Tiempo acumulado:0.45233654975891
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[120]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00076413154602051Tiempo acumulado:0.45310068130493
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[121]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00065302848815918Tiempo acumulado:0.45375370979309
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[122]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('es_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050902366638184Tiempo acumulado:0.45426273345947
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[123]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004730224609375Tiempo acumulado:0.45473575592041
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[124]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 912
AND FOTO = 'Montando a caballo con disfraz.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0013339519500732Tiempo acumulado:0.45606970787048
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[125]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 912
AND FOTO = 'Un cluedo de lo mas divertido.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00066494941711426Tiempo acumulado:0.4567346572876
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[126]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 912
AND FOTO = 'Descubre los misterios de Valencia.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00056910514831543Tiempo acumulado:0.45730376243591
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[127]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 912
AND FOTO = 'Bruja secuestrada.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0010478496551514Tiempo acumulado:0.45835161209106
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[128]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 912
AND FOTO = 'Una espeluznante cena.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0005638599395752Tiempo acumulado:0.45891547203064
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[129]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 912
AND FOTO = 'Ruta nocturna misteriosa2.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00063085556030273Tiempo acumulado:0.45954632759094
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[130]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 912
AND FOTO = 'Un halloween haciendo paracaidismo.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00075602531433105Tiempo acumulado:0.46030235290527
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[131]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 912
AND FOTO = 'Preparado para una cena terrorifica.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0005340576171875Tiempo acumulado:0.46083641052246
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[132]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 912
AND FOTO = 'Halloween en centro infantil.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0030801296234131Tiempo acumulado:0.46391654014587
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[133]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 912
AND FOTO = 'Nino vestido de woody.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00052404403686523Tiempo acumulado:0.46444058418274
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[134]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.0007321834564209Tiempo acumulado:0.46517276763916
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[135]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.00042581558227539Tiempo acumulado:0.46559858322144
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[136]: SELECT CATEGG.DESC_GRUPO,CATEGG.URL as URL2
FROM LO_CONTENIDOS CON
INNER JOIN LO_CONTENIDOS_CATEG CATEG ON CON.ID_CATEG=CATEG.ID_CATEG
INNER JOIN LO_CONTENIDOS_CATEG_I18N CAI ON CAI.ID_CATEG=CATEG.ID_CATEG
INNER JOIN LO_CONTENIDOS_GRUPOS CATEGG ON CATEG.id_GRUPO_CAT=CATEGG.ID_GRUPO_CAT
WHERE CATEGG.ID_TROPIC='16'
AND CON.ID_CONTENIDO='912'
LIMIT 1;
Tiempo de la consulta:
0.00066113471984863Tiempo acumulado:0.46625971794128
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[137]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 912
AND FOTO = 'Montando a caballo con disfraz.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00051999092102051Tiempo acumulado:0.4667797088623
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[138]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 912
AND FOTO = 'Un cluedo de lo mas divertido.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0040149688720703Tiempo acumulado:0.47079467773438
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[139]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 912
AND FOTO = 'Descubre los misterios de Valencia.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00053501129150391Tiempo acumulado:0.47132968902588
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[140]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 912
AND FOTO = 'Bruja secuestrada.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00053596496582031Tiempo acumulado:0.4718656539917
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[141]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 912
AND FOTO = 'Una espeluznante cena.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0010190010070801Tiempo acumulado:0.47288465499878
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[142]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 912
AND FOTO = 'Ruta nocturna misteriosa2.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00082707405090332Tiempo acumulado:0.47371172904968
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[143]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 912
AND FOTO = 'Un halloween haciendo paracaidismo.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00062012672424316Tiempo acumulado:0.47433185577393
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[144]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 912
AND FOTO = 'Preparado para una cena terrorifica.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0026440620422363Tiempo acumulado:0.47697591781616
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[145]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 912
AND FOTO = 'Halloween en centro infantil.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00090408325195312Tiempo acumulado:0.47788000106812
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[146]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 912
AND FOTO = 'Nino vestido de woody.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0026869773864746Tiempo acumulado:0.48056697845459
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[147]: SELECT C.ID_REGION, DL.ID_SECTOR_1, DL.ID_SECTOR_2, DL.ID_SECTOR_3, DL.ID_SECTOR_4, DL.ID_SECTOR_5, DL.ID_SECTOR_6, DL.ID_SECTOR_7, DL.ID_SECTOR_8, DL.ID_SECTOR_9, DL.ID_SECTOR_10
FROM LO_CONTENIDOS C
INNER JOIN LO_SEO_DESCRIPTIONS_LANDING DL ON (ID_KEY = CONCAT('R',C.ID_REGION) OR ID_KEY = CONCAT('P',C.ID_REGION))
AND DL.ID_TROPIC = 16
WHERE C.TITULO LIKE '10 cosas que hacer en%'
AND C.ID_CONTENIDO = 912;
Tiempo de la consulta:
0.0017359256744385Tiempo acumulado:0.48230290412903
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[148]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00099396705627441Tiempo acumulado:0.4832968711853
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[149]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00053095817565918Tiempo acumulado:0.48382782936096
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[150]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00066590309143066Tiempo acumulado:0.48449373245239
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[151]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00051784515380859Tiempo acumulado:0.4850115776062
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[152]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_multidioma'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046205520629883Tiempo acumulado:0.4854736328125
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[153]: SELECT CON.ID_CONTENIDO , CON.TITULO, CON.DESCRIPCION, CON.TEXTO, CON.GALERIA, CON.GALERIA_DESC,
CON.FOTOPRINCIPAL, DATE_FORMAT(CON.FEC_INSERT,'%d/%m/%y') AS FEC_INSERT,
AD.NOMBRE, AD.MAIL,CON.TIPO_CONTENIDOS
, CT.DESCRIPCION AS DESC_CORTA,URL_CT ,CT.TITULO, CT.DESCRIPCION, CT.TEXTO, CT.GALERIA_DESC, CT.VIDEOS_TEXT_CON, CT.VIDEOS_DESC_CON
FROM Prod_Yumping_es_ES.LO_CONTENIDOS CON
INNER JOIN Prod_Yumping_es_ES.LO_ADMIN_USERS AD ON AD.LOGIN = CON.OPERATOR_INSERT
INNER JOIN Prod_Yumping_es_ES.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = CON.ID_CONTENIDO
AND LANGUAGE = 'ch'
WHERE
(CON.GALERIA IS NOT NULL
AND CON.GALERIA<>'')
AND CON.ID_CATEG = 55
AND CON.VALID = 1
AND CON.ID_CONTENIDO !=912
ORDER BY RAND()
LIMIT 4;
Tiempo de la consulta (slow_query): 0.6019971370697Tiempo acumulado:1.0874707698822
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[154]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 905
AND FOTO = 'Cuidado con la cremallera del traje2.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0011439323425293Tiempo acumulado:1.0886147022247
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[155]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 610
AND FOTO = 'practicar deportes de aventura (yumping)2.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0020120143890381Tiempo acumulado:1.0906267166138
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[156]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 169
AND FOTO = 'kitesurf.jpg'
AND VALID=1;
Tiempo de la consulta:
0.001331090927124Tiempo acumulado:1.0919578075409
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[157]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 973
AND FOTO = 'Hombre sentado en la montana.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0081188678741455Tiempo acumulado:1.100076675415
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[158]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0028281211853027Tiempo acumulado:1.1029047966003
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[159]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00067400932312012Tiempo acumulado:1.1035788059235
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[160]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0091161727905273Tiempo acumulado:1.112694978714
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[161]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00053596496582031Tiempo acumulado:1.1132309436798
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[162]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0019030570983887Tiempo acumulado:1.1151340007782
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[163]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0022809505462646Tiempo acumulado:1.1174149513245
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[164]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00060915946960449Tiempo acumulado:1.1180241107941
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[165]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00084400177001953Tiempo acumulado:1.1188681125641
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[166]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049805641174316Tiempo acumulado:1.1193661689758
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[167]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0013728141784668Tiempo acumulado:1.1207389831543
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[168]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0027451515197754Tiempo acumulado:1.1234841346741
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[169]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0023050308227539Tiempo acumulado:1.1257891654968
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[170]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00067877769470215Tiempo acumulado:1.1264679431915
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[171]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0011789798736572Tiempo acumulado:1.1276469230652
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[172]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047993659973145Tiempo acumulado:1.1281268596649
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[173]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('mx_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0005640983581543Tiempo acumulado:1.1286909580231
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[174]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('mx_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0015339851379395Tiempo acumulado:1.130224943161
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[175]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('mx_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0037291049957275Tiempo acumulado:1.1339540481567
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[176]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('mx_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0006568431854248Tiempo acumulado:1.1346108913422
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[177]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('mx_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00055503845214844Tiempo acumulado:1.1351659297943
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[178]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('it_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00052213668823242Tiempo acumulado:1.1356880664825
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[179]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('it_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0008690357208252Tiempo acumulado:1.1365571022034
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[180]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('it_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0015480518341064Tiempo acumulado:1.1381051540375
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[181]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('it_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00079703330993652Tiempo acumulado:1.1389021873474
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[182]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('it_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0006110668182373Tiempo acumulado:1.1395132541656
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[183]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('fr_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00086498260498047Tiempo acumulado:1.1403782367706
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[184]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('fr_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0011579990386963Tiempo acumulado:1.1415362358093
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[185]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('fr_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00064802169799805Tiempo acumulado:1.1421842575073
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[186]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('fr_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049400329589844Tiempo acumulado:1.1426782608032
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[187]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('fr_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045585632324219Tiempo acumulado:1.1431341171265
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[188]: SELECT SUM(TOTAL) AS TOTAL,TIPO_CONTENIDOS,ID_GRUPO_CAT, DESC_GRUPO, URL
FROM (SELECT COUNT(*) AS TOTAL,CON.TIPO_CONTENIDOS,CATEG.ID_GRUPO_CAT, CG.DESC_GRUPO, CG.URL
FROM Prod_Yumping_es_ES.LO_CONTENIDOS CON
INNER JOIN Prod_Yumping_es_ES.LO_ADMIN_USERS AD ON CON.OPERATOR_INSERT=AD.LOGIN
INNER JOIN Prod_Yumping_es_ES.LO_CONTENIDOS_CATEG CATEG ON CON.ID_CATEG=CATEG.ID_CATEG
INNER JOIN Prod_Yumping_es_ES.LO_CONTENIDOS_GRUPOS CG ON CG.ID_GRUPO_CAT = CATEG.ID_GRUPO_CAT
AND CG.ID_TROPIC = '16'
WHERE (CON.GALERIA IS NOT NULL
AND CON.GALERIA<>'')
AND CON.ID_TROPIC='1'
AND CON.VALID=1
GROUP BY TIPO_CONTENIDOS,ID_GRUPO_CAT
UNION ALL SELECT COUNT(*) AS TOTAL,CON.TIPO_CONTENIDOS,CATEG.ID_GRUPO_CAT, CG.DESC_GRUPO, CG.URL
FROM Prod_Yumping_pt_PT.LO_CONTENIDOS CON
INNER JOIN Prod_Yumping_pt_PT.LO_ADMIN_USERS AD ON CON.OPERATOR_INSERT=AD.LOGIN
INNER JOIN Prod_Yumping_pt_PT.LO_CONTENIDOS_CATEG CATEG ON CON.ID_CATEG=CATEG.ID_CATEG
INNER JOIN Prod_Yumping_pt_PT.LO_CONTENIDOS_GRUPOS CG ON CG.ID_GRUPO_CAT = CATEG.ID_GRUPO_CAT
AND CG.ID_TROPIC = '86'
WHERE (CON.GALERIA IS NOT NULL
AND CON.GALERIA<>'')
AND CON.ID_TROPIC='8'
AND CON.VALID=1
GROUP BY TIPO_CONTENIDOS,ID_GRUPO_CAT
UNION ALL SELECT COUNT(*) AS TOTAL,CON.TIPO_CONTENIDOS,CATEG.ID_GRUPO_CAT, CG.DESC_GRUPO, CG.URL
FROM Prod_Yumping_co_UK.LO_CONTENIDOS CON
INNER JOIN Prod_Yumping_co_UK.LO_ADMIN_USERS AD ON CON.OPERATOR_INSERT=AD.LOGIN
INNER JOIN Prod_Yumping_co_UK.LO_CONTENIDOS_CATEG CATEG ON CON.ID_CATEG=CATEG.ID_CATEG
INNER JOIN Prod_Yumping_co_UK.LO_CONTENIDOS_GRUPOS CG ON CG.ID_GRUPO_CAT = CATEG.ID_GRUPO_CAT
AND CG.ID_TROPIC = '26'
WHERE (CON.GALERIA IS NOT NULL
AND CON.GALERIA<>'')
AND CON.ID_TROPIC='2'
AND CON.VALID=1
GROUP BY TIPO_CONTENIDOS,ID_GRUPO_CAT
UNION ALL SELECT COUNT(*) AS TOTAL,CON.TIPO_CONTENIDOS,CATEG.ID_GRUPO_CAT, CG.DESC_GRUPO, CG.URL
FROM Prod_Yumping_mx_MX.LO_CONTENIDOS CON
INNER JOIN Prod_Yumping_mx_MX.LO_ADMIN_USERS AD ON CON.OPERATOR_INSERT=AD.LOGIN
INNER JOIN Prod_Yumping_mx_MX.LO_CONTENIDOS_CATEG CATEG ON CON.ID_CATEG=CATEG.ID_CATEG
INNER JOIN Prod_Yumping_mx_MX.LO_CONTENIDOS_GRUPOS CG ON CG.ID_GRUPO_CAT = CATEG.ID_GRUPO_CAT
AND CG.ID_TROPIC = '56'
WHERE (CON.GALERIA IS NOT NULL
AND CON.GALERIA<>'')
AND CON.ID_TROPIC='5'
AND CON.VALID=1
GROUP BY TIPO_CONTENIDOS,ID_GRUPO_CAT
UNION ALL SELECT COUNT(*) AS TOTAL,CON.TIPO_CONTENIDOS,CATEG.ID_GRUPO_CAT, CG.DESC_GRUPO, CG.URL
FROM Prod_Yumping_it_IT.LO_CONTENIDOS CON
INNER JOIN Prod_Yumping_it_IT.LO_ADMIN_USERS AD ON CON.OPERATOR_INSERT=AD.LOGIN
INNER JOIN Prod_Yumping_it_IT.LO_CONTENIDOS_CATEG CATEG ON CON.ID_CATEG=CATEG.ID_CATEG
INNER JOIN Prod_Yumping_it_IT.LO_CONTENIDOS_GRUPOS CG ON CG.ID_GRUPO_CAT = CATEG.ID_GRUPO_CAT
AND CG.ID_TROPIC = '36'
WHERE (CON.GALERIA IS NOT NULL
AND CON.GALERIA<>'')
AND CON.ID_TROPIC='3'
AND CON.VALID=1
GROUP BY TIPO_CONTENIDOS,ID_GRUPO_CAT
UNION ALL SELECT COUNT(*) AS TOTAL,CON.TIPO_CONTENIDOS,CATEG.ID_GRUPO_CAT, CG.DESC_GRUPO, CG.URL
FROM Prod_Yumping_fr_FR.LO_CONTENIDOS CON
INNER JOIN Prod_Yumping_fr_FR.LO_ADMIN_USERS AD ON CON.OPERATOR_INSERT=AD.LOGIN
INNER JOIN Prod_Yumping_fr_FR.LO_CONTENIDOS_CATEG CATEG ON CON.ID_CATEG=CATEG.ID_CATEG
INNER JOIN Prod_Yumping_fr_FR.LO_CONTENIDOS_GRUPOS CG ON CG.ID_GRUPO_CAT = CATEG.ID_GRUPO_CAT
AND CG.ID_TROPIC = '46'
WHERE (CON.GALERIA IS NOT NULL
AND CON.GALERIA<>'')
AND CON.ID_TROPIC='4'
AND CON.VALID=1
GROUP BY TIPO_CONTENIDOS,ID_GRUPO_CAT
) AS CATEGORIAS
GROUP BY TIPO_CONTENIDOS,ID_GRUPO_CAT
ORDER BY ID_GRUPO_CAT ASC;
Tiempo de la consulta:
0.049685001373291Tiempo acumulado:1.1928191184998
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[189]: SELECT PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, ID_PRECIO,
GALERIA_PRE,NOMBRE,SECI.DESC_SECTOR,REI.DESC_REGION,DESC_POBLACION,FOTOPRINCIPAL_PRE,
EMP.URL URL,SECI.ID_SECTOR ID_SECTOR, SECI.URL URL_SECTOR,REI.URL URL_REGION,
LEAST(if(PRECIO_MIN_PRE>0,PRECIO_MIN_PRE,PRECIO_PRE),PRECIO_PRE) PRECIO,
DESCUENTO_MIN_PRE DESCUENTO,
DATE_FORMAT(FECHA_CADUCIDAD_PD_PRE,'%d') AS DIA_CAD,
DATE_FORMAT(FECHA_CADUCIDAD_PD_PRE,'%m') AS MES_CAD,
DATE_FORMAT(FECHA_CADUCIDAD_PD_PRE,'%Y') AS ANYO_CAD, PRE.MULTIACTIVIDAD_PRE
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'ch'
INNER JOIN LO_PRECIOS_SECTORES PS ON PRE.ID_PRECIO=PS.ID_PRECIO_PS
INNER JOIN LO_EMPRESAS EMP ON PRE.ID_EMPRESA_PRE=EMP.ID_EMPRESA AND( EMP.VALID=1 OR EMP.VALID='-3')
INNER JOIN LO_SECTORES SEC ON PS.ID_ACTIVIDAD_PS=SEC.ID_SECTOR
INNER JOIN LO_SECTORES_I18N SECI ON SEC.ID_SECTOR=SECI.ID_SECTOR
AND SECI.ID_TROPIC=16
AND SECI.FK_ID_IDIOMA_SI18N='ch'
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PRE.ID_REGION_PRE
AND REI.IDIOMA='ch'
INNER JOIN LO_POBLACION_ES PO ON PO.ID_POBLACION = PRE.ID_POBLACION_PRE
AND PO.IDIOMA='ch'
INNER JOIN LO_REGION RE ON RE.ID_REGION = REI.ID_REGION
WHERE PRE.MULTIACTIVIDAD_PRE=0
AND PRE.VALID_PRE=4
GROUP BY ID_PRECIO
ORDER BY RAND()
LIMIT 5;
Tiempo de la consulta (super_slow_query): 2.1999518871307Tiempo acumulado:3.3927710056305
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[190]: SELECT URL_PRE, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, ID_PRECIO, FK_ID_PAIS_PRE
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'ch'
WHERE PRE.ID_PRECIO = 64479;
Tiempo de la consulta:
0.0047399997711182Tiempo acumulado:3.3975110054016
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[191]: SELECT ID_PRECIO_PADRE
FROM LO_PRECIOS_ASIGNACION PA
INNER JOIN LO_PRECIOS PRE ON PRE.ID_PRECIO = PA.ID_PRECIO_PADRE
AND PRE.VALID_PRE = 4
WHERE PA.ID_PRECIO = 64479;
Tiempo de la consulta:
0.0012228488922119Tiempo acumulado:3.3987338542938
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[192]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 64479
AND VALID = 1;
Tiempo de la consulta:
0.0087640285491943Tiempo acumulado:3.407497882843
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[193]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 64479
AND FOTO = 'p-64479-kayakpareja_15815026451877.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.0010190010070801Tiempo acumulado:3.4085168838501
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[194]: SELECT ID_PRECIO, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_PRECIO =64479;
Tiempo de la consulta:
0.0018160343170166Tiempo acumulado:3.4103329181671
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[195]: SELECT URL_PRE, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, ID_PRECIO, FK_ID_PAIS_PRE
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'ch'
WHERE PRE.ID_PRECIO = 16721;
Tiempo de la consulta:
0.0005500316619873Tiempo acumulado:3.4108829498291
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[196]: SELECT ID_PRECIO_PADRE
FROM LO_PRECIOS_ASIGNACION PA
INNER JOIN LO_PRECIOS PRE ON PRE.ID_PRECIO = PA.ID_PRECIO_PADRE
AND PRE.VALID_PRE = 4
WHERE PA.ID_PRECIO = 16721;
Tiempo de la consulta:
0.00063800811767578Tiempo acumulado:3.4115209579468
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[197]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 16721
AND VALID = 1;
Tiempo de la consulta:
0.0044920444488525Tiempo acumulado:3.4160130023956
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[198]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 16721
AND FOTO = 'remando-en-las-aguas-bravas.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00049710273742676Tiempo acumulado:3.4165101051331
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[199]: SELECT ID_PRECIO, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_PRECIO =16721;
Tiempo de la consulta:
0.001953125Tiempo acumulado:3.4184632301331
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[200]: SELECT URL_PRE, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, ID_PRECIO, FK_ID_PAIS_PRE
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'ch'
WHERE PRE.ID_PRECIO = 28865;
Tiempo de la consulta:
0.00051999092102051Tiempo acumulado:3.4189832210541
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[201]: SELECT ID_PRECIO_PADRE
FROM LO_PRECIOS_ASIGNACION PA
INNER JOIN LO_PRECIOS PRE ON PRE.ID_PRECIO = PA.ID_PRECIO_PADRE
AND PRE.VALID_PRE = 4
WHERE PA.ID_PRECIO = 28865;
Tiempo de la consulta:
0.0004730224609375Tiempo acumulado:3.419456243515
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[202]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 28865
AND VALID = 1;
Tiempo de la consulta:
0.0079159736633301Tiempo acumulado:3.4273722171783
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[203]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 28865
AND FOTO = '20140419-115714.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.0007178783416748Tiempo acumulado:3.42809009552
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[204]: SELECT ID_PRECIO, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_PRECIO =28865;
Tiempo de la consulta:
0.0010099411010742Tiempo acumulado:3.4291000366211
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[205]: SELECT URL_PRE, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, ID_PRECIO, FK_ID_PAIS_PRE
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'ch'
WHERE PRE.ID_PRECIO = 46391;
Tiempo de la consulta:
0.00063395500183105Tiempo acumulado:3.4297339916229
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[206]: SELECT ID_PRECIO_PADRE
FROM LO_PRECIOS_ASIGNACION PA
INNER JOIN LO_PRECIOS PRE ON PRE.ID_PRECIO = PA.ID_PRECIO_PADRE
AND PRE.VALID_PRE = 4
WHERE PA.ID_PRECIO = 46391;
Tiempo de la consulta:
0.00049996376037598Tiempo acumulado:3.4302339553833
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[207]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 46391
AND VALID = 1;
Tiempo de la consulta:
0.0033879280090332Tiempo acumulado:3.4336218833923
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[208]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 46391
AND FOTO = 'pre-46391-imagen-2.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00048613548278809Tiempo acumulado:3.4341080188751
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[209]: SELECT ID_PRECIO, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_PRECIO =46391;
Tiempo de la consulta:
0.00035405158996582Tiempo acumulado:3.4344620704651
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[210]: SELECT URL_PRE, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, ID_PRECIO, FK_ID_PAIS_PRE
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'ch'
WHERE PRE.ID_PRECIO = 31871;
Tiempo de la consulta:
0.00047802925109863Tiempo acumulado:3.4349400997162
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[211]: SELECT ID_PRECIO_PADRE
FROM LO_PRECIOS_ASIGNACION PA
INNER JOIN LO_PRECIOS PRE ON PRE.ID_PRECIO = PA.ID_PRECIO_PADRE
AND PRE.VALID_PRE = 4
WHERE PA.ID_PRECIO = 31871;
Tiempo de la consulta:
0.00043702125549316Tiempo acumulado:3.4353771209717
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[212]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 31871
AND VALID = 1;
Tiempo de la consulta:
0.0040919780731201Tiempo acumulado:3.4394690990448
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[213]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 31871
AND FOTO = 'equipo-de-laser-tag.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00050616264343262Tiempo acumulado:3.4399752616882
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[214]: SELECT ID_PRECIO, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_PRECIO =31871;
Tiempo de la consulta:
0.0012779235839844Tiempo acumulado:3.4412531852722
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[215]: SELECT CON.ID_CONTENIDO, CON.TITULO,CON.TIPO_CONTENIDOS, CON.DESCRIPCION, CON.TEXTO, CON.GALERIA,
CON.GALERIA_DESC, CON.FOTOPRINCIPAL, DATE_FORMAT(CON.FEC_INSERT,'%d/%m/%y') AS FEC_INSERT,
AD.NOMBRE, AD.MAIL,CON.NOMBRE_FIRMA_CON,TIPO_CONTENIDOS, CT.DESCRIPCION AS DESC_CORTA,URL_CT ,CT.TITULO, CT.DESCRIPCION, CT.TEXTO, CT.GALERIA_DESC, CT.VIDEOS_TEXT_CON, CT.VIDEOS_DESC_CON
FROM LO_CONTENIDOS CON
INNER JOIN LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = CON.ID_CONTENIDO
AND LANGUAGE = 'ch'
INNER JOIN LO_ADMIN_USERS AD ON AD.LOGIN = CON.OPERATOR_INSERT
INNER JOIN LO_CONTENIDOS_CATEG CATEG ON CATEG.ID_CATEG = CON.ID_CATEG
WHERE (CON.GALERIA IS NOT NULL
AND CON.GALERIA <> '')
AND CON.ID_TROPIC = '1'
AND CON.VALID = 1
AND CON.ID_CONTENIDO NOT IN ('912')
ORDER BY FIELD(TIPO_CONTENIDOS,1) DESC, CON.FEC_INSERT DESC
LIMIT 5;
Tiempo de la consulta:
0.010489940643311Tiempo acumulado:3.4517431259155
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[216]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1448
AND FOTO = '269397310-10159572405432534-8009798584194411997-n1740482843.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0096278190612793Tiempo acumulado:3.4613709449768
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[217]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1447
AND FOTO = 'yumping-trends-2-1736863447.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0060458183288574Tiempo acumulado:3.4674167633057
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[218]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1444
AND FOTO = '151474557-2254915741310557-1934111757783398706-n1732112561.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0010390281677246Tiempo acumulado:3.4684557914734
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[219]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1443
AND FOTO = 'los-destinos-mas-top-para-viajar-en-el-puente-de-noviembre1729246718.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0083839893341064Tiempo acumulado:3.4768397808075
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[220]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1441
AND FOTO = 'aa1727956772.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0087628364562988Tiempo acumulado:3.4856026172638
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[221]: SELECT RS.N_OFERTAS AS NEMPRESAS, REI.ID_REGION, REI.DESC_REGION, REI.URL URL_REGION
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_SECTORES PS ON PS.ID_PRECIO_PS = PRE.ID_PRECIO
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = PS.ID_ACTIVIDAD_PS
AND SECI.ID_TROPIC = 16
AND SECI.FK_ID_IDIOMA_SI18N = 'ch'
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PRE.ID_REGION_PRE
AND REI.IDIOMA = 'ch'
INNER JOIN LO_REGION_STATS RS ON RS.ID_REGION = REI.ID_REGION
AND RS.N_OFERTAS > 0
WHERE PRE.VALID_PRE = 4
AND (RS.ID_GRUPO IS NULL OR RS.ID_GRUPO = 0)
AND (RS.ID_SECTOR IS NULL OR RS.ID_SECTOR = 0)
AND (RS.ID_SUBSECTOR IS NULL OR RS.ID_SUBSECTOR = 0)
GROUP BY PRE.ID_REGION_PRE
ORDER BY NEMPRESAS DESC;
Tiempo de la consulta:
0.0081820487976074Tiempo acumulado:3.4937846660614
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[222]: SELECT *
FROM LO_EQUIPO_EDITORIAL EE
WHERE EE.ID_TROPIC = 16;
Tiempo de la consulta:
0.0036969184875488Tiempo acumulado:3.497481584549
