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->es_ch
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->1405
tpage->contenidoShow
rel_alternate->1
Total queries: 204
Tiempo total: 0.37039089202881
>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.007631778717041Tiempo acumulado:0.007631778717041
(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.00053691864013672Tiempo acumulado:0.0081686973571777
(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 = 1405
/*
AND (
fnGoogleUrl(C.TITULO) = 'er-tong-pan-yan-qiang'
OR fnGoogleUrl(CT.TITULO) = 'er-tong-pan-yan-qiang'
OR URL_CT = 'er-tong-pan-yan-qiang') */ 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 = 1405
/*
AND (
fnGoogleUrl(C.TITULO) = 'er-tong-pan-yan-qiang'
OR fnGoogleUrl(CT.TITULO) = 'er-tong-pan-yan-qiang'
OR URL_CT = 'er-tong-pan-yan-qiang') */ 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 = 1405
/*
AND (
fnGoogleUrl(C.TITULO) = 'er-tong-pan-yan-qiang'
OR fnGoogleUrl(CT.TITULO) = 'er-tong-pan-yan-qiang'
OR URL_CT = 'er-tong-pan-yan-qiang') */ 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 = 1405
/*
AND (
fnGoogleUrl(C.TITULO) = 'er-tong-pan-yan-qiang'
OR fnGoogleUrl(CT.TITULO) = 'er-tong-pan-yan-qiang'
OR URL_CT = 'er-tong-pan-yan-qiang') */ 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 = 1405
/*
AND (
fnGoogleUrl(C.TITULO) = 'er-tong-pan-yan-qiang'
OR fnGoogleUrl(CT.TITULO) = 'er-tong-pan-yan-qiang'
OR URL_CT = 'er-tong-pan-yan-qiang') */ 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 = 1405
/*
AND (
fnGoogleUrl(C.TITULO) = 'er-tong-pan-yan-qiang'
OR fnGoogleUrl(CT.TITULO) = 'er-tong-pan-yan-qiang'
OR URL_CT = 'er-tong-pan-yan-qiang') */ ) AS CONTENIDO;
Tiempo de la consulta:
0.013686895370483Tiempo acumulado:0.021855592727661
(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.0074009895324707Tiempo acumulado:0.029256582260132
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[5]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'ambito_lang';
Tiempo de la consulta:
0.0006108283996582Tiempo acumulado:0.02986741065979
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[6]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'id_contenido';
Tiempo de la consulta:
0.00044393539428711Tiempo acumulado:0.030311346054077
(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 = 'tpage';
Tiempo de la consulta:
0.00037789344787598Tiempo acumulado:0.030689239501953
(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 = 'rel_alternate';
Tiempo de la consulta:
0.00042009353637695Tiempo acumulado:0.03110933303833
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[9]: 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.00047492980957031Tiempo acumulado:0.0315842628479
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[10]: 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.00043702125549316Tiempo acumulado:0.032021284103394
(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 = 'subdomain_lang'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043106079101562Tiempo acumulado:0.032452344894409
(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_con_traducciones'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00044012069702148Tiempo acumulado:0.032892465591431
(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 = 'Request_con_multidioma'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046300888061523Tiempo acumulado:0.033355474472046
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[14]: 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=1405
AND CON.VALID=1
AND CATI.ID_TROPIC=16;
Tiempo de la consulta:
0.0013279914855957Tiempo acumulado:0.034683465957642
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[15]: 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='24'
AND CAT.ID_CATEG=CATI.ID_CATEG
AND CON.ID_CONTENIDO='1405'
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.0010001659393311Tiempo acumulado:0.035683631896973
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[16]: 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.0032429695129395Tiempo acumulado:0.038926601409912
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[17]: 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.0004570484161377Tiempo acumulado:0.03938364982605
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[18]: 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.00046396255493164Tiempo acumulado:0.039847612380981
(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_id_tropic_trad'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046610832214355Tiempo acumulado:0.040313720703125
(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 = 'subdomain_lang'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042510032653809Tiempo acumulado:0.040738821029663
(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_con_traducciones'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004270076751709Tiempo acumulado:0.041165828704834
(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 = '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.00041890144348145Tiempo acumulado:0.041584730148315
(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 = '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.00042080879211426Tiempo acumulado:0.04200553894043
(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_id_tropic_trad'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041508674621582Tiempo acumulado:0.042420625686646
(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 = 'subdomain_lang'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043392181396484Tiempo acumulado:0.04285454750061
(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_con_traducciones'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041913986206055Tiempo acumulado:0.043273687362671
(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 = '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.00047206878662109Tiempo acumulado:0.043745756149292
(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 = '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.00044608116149902Tiempo acumulado:0.044191837310791
(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_id_tropic_trad'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004279613494873Tiempo acumulado:0.044619798660278
(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 = 'subdomain_lang'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004730224609375Tiempo acumulado:0.045092821121216
(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_con_traducciones'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0019750595092773Tiempo acumulado:0.047067880630493
(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 = '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.00044798851013184Tiempo acumulado:0.047515869140625
(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 = '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.00045108795166016Tiempo acumulado:0.047966957092285
(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_id_tropic_trad'
AND CFG.AMBITO IN ('mx_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041484832763672Tiempo acumulado:0.048381805419922
(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 = 'subdomain_lang'
AND CFG.AMBITO IN ('mx_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00040888786315918Tiempo acumulado:0.048790693283081
(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_con_traducciones'
AND CFG.AMBITO IN ('mx_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041604042053223Tiempo acumulado:0.049206733703613
(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 = '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.00048708915710449Tiempo acumulado:0.049693822860718
(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 = '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.00054001808166504Tiempo acumulado:0.050233840942383
(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_id_tropic_trad'
AND CFG.AMBITO IN ('it_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00054097175598145Tiempo acumulado:0.050774812698364
(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 = 'subdomain_lang'
AND CFG.AMBITO IN ('it_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0005650520324707Tiempo acumulado:0.051339864730835
(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_con_traducciones'
AND CFG.AMBITO IN ('it_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.000579833984375Tiempo acumulado:0.05191969871521
(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 = '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.00048112869262695Tiempo acumulado:0.052400827407837
(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 = '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.00077295303344727Tiempo acumulado:0.053173780441284
(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_id_tropic_trad'
AND CFG.AMBITO IN ('fr_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00083398818969727Tiempo acumulado:0.054007768630981
(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 = 'subdomain_lang'
AND CFG.AMBITO IN ('fr_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00056195259094238Tiempo acumulado:0.054569721221924
(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_con_traducciones'
AND CFG.AMBITO IN ('fr_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00054812431335449Tiempo acumulado:0.055117845535278
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[47]: 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.017021894454956Tiempo acumulado:0.072139739990234
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[48]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1405
AND FOTO = 'jovenes-escalando-el-rocodromo.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0005650520324707Tiempo acumulado:0.072704792022705
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[49]: SELECT OLD_URL, NEW_URL
FROM LO_URL_301 U
WHERE U.OLD_URL = '/zh-hans/mao-xian-ti-yu-xin-wen/er-tong-pan-yan-qiang--c1405';
Tiempo de la consulta:
0.00036883354187012Tiempo acumulado:0.073073625564575
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[50]: 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.0004889965057373Tiempo acumulado:0.073562622070312
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[51]: 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.00045895576477051Tiempo acumulado:0.074021577835083
(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_con_traducciones'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050783157348633Tiempo acumulado:0.074529409408569
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[53]: 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 = 1405;
Tiempo de la consulta:
0.00075101852416992Tiempo acumulado:0.075280427932739
(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 = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046491622924805Tiempo acumulado:0.075745344161987
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[55]: 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.00050020217895508Tiempo acumulado:0.076245546340942
(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', 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.00056314468383789Tiempo acumulado:0.07680869102478
(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_con_traducciones'
AND CFG.AMBITO IN ('es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00051593780517578Tiempo acumulado:0.077324628829956
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[58]: 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 = 1405;
Tiempo de la consulta:
0.00083279609680176Tiempo acumulado:0.078157424926758
(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 = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049805641174316Tiempo acumulado:0.078655481338501
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[60]: 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.00049281120300293Tiempo acumulado:0.079148292541504
(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_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.00052809715270996Tiempo acumulado:0.079676389694214
(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_con_traducciones'
AND CFG.AMBITO IN ('es_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00054001808166504Tiempo acumulado:0.080216407775879
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[63]: 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 = 1405;
Tiempo de la consulta:
0.00073909759521484Tiempo acumulado:0.080955505371094
(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 = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('es_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050997734069824Tiempo acumulado:0.081465482711792
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[65]: 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.00048112869262695Tiempo acumulado:0.081946611404419
(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_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.00049400329589844Tiempo acumulado:0.082440614700317
(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_con_traducciones'
AND CFG.AMBITO IN ('es_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049686431884766Tiempo acumulado:0.082937479019165
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[68]: 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 = 1405;
Tiempo de la consulta:
0.00068998336791992Tiempo acumulado:0.083627462387085
(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 = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('es_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047397613525391Tiempo acumulado:0.084101438522339
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[70]: 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.00051999092102051Tiempo acumulado:0.084621429443359
(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_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.00046491622924805Tiempo acumulado:0.085086345672607
(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_con_traducciones'
AND CFG.AMBITO IN ('es_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00072717666625977Tiempo acumulado:0.085813522338867
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[73]: 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 = 1405;
Tiempo de la consulta:
0.00062680244445801Tiempo acumulado:0.086440324783325
(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 = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('es_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004420280456543Tiempo acumulado:0.086882352828979
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[75]: 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.00047898292541504Tiempo acumulado:0.087361335754395
(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_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.00050902366638184Tiempo acumulado:0.087870359420776
(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_con_traducciones'
AND CFG.AMBITO IN ('es_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00053000450134277Tiempo acumulado:0.088400363922119
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[78]: 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 = 1405;
Tiempo de la consulta:
0.00081801414489746Tiempo acumulado:0.089218378067017
(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 = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('es_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004580020904541Tiempo acumulado:0.089676380157471
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[80]: 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.00080704689025879Tiempo acumulado:0.090483427047729
(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_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.00054001808166504Tiempo acumulado:0.091023445129395
(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_con_traducciones'
AND CFG.AMBITO IN ('es_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00058698654174805Tiempo acumulado:0.091610431671143
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[83]: 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 = 1405;
Tiempo de la consulta:
0.00068902969360352Tiempo acumulado:0.092299461364746
(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 = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('es_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047612190246582Tiempo acumulado:0.092775583267212
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[85]: 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.00044798851013184Tiempo acumulado:0.093223571777344
(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_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.00054812431335449Tiempo acumulado:0.093771696090698
(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.00050687789916992Tiempo acumulado:0.094278573989868
(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.0006868839263916Tiempo acumulado:0.09496545791626
(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 = 'subdomain_lang'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00054097175598145Tiempo acumulado:0.095506429672241
(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', 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.00055694580078125Tiempo acumulado:0.096063375473022
(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', 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.00047707557678223Tiempo acumulado:0.096540451049805
(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 = 'subdomain'
AND CFG.AMBITO IN ('es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00059008598327637Tiempo acumulado:0.097130537033081
(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.00055289268493652Tiempo acumulado:0.097683429718018
(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 = 'Request_href_lang'
AND CFG.AMBITO IN ('es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00053501129150391Tiempo acumulado:0.098218441009521
(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 = 'subdomain_lang'
AND CFG.AMBITO IN ('es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00058102607727051Tiempo acumulado:0.098799467086792
(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_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.00055694580078125Tiempo acumulado:0.099356412887573
(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_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.00052499771118164Tiempo acumulado:0.099881410598755
(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.00048398971557617Tiempo acumulado:0.10036540031433
(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.00049710273742676Tiempo acumulado:0.10086250305176
(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 = 'subdomain_lang'
AND CFG.AMBITO IN ('es_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00054502487182617Tiempo acumulado:0.10140752792358
(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_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.00051403045654297Tiempo acumulado:0.10192155838013
(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_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.00053191184997559Tiempo acumulado:0.1024534702301
(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.00055193901062012Tiempo acumulado:0.10300540924072
(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.00052595138549805Tiempo acumulado:0.10353136062622
(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 = 'subdomain_lang'
AND CFG.AMBITO IN ('es_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00054001808166504Tiempo acumulado:0.10407137870789
(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_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.0005180835723877Tiempo acumulado:0.10458946228027
(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_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.00047588348388672Tiempo acumulado:0.10506534576416
(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.00047111511230469Tiempo acumulado:0.10553646087646
(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.00047683715820312Tiempo acumulado:0.10601329803467
(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 = 'subdomain_lang'
AND CFG.AMBITO IN ('es_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049304962158203Tiempo acumulado:0.10650634765625
(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_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.00048685073852539Tiempo acumulado:0.10699319839478
(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_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.0004730224609375Tiempo acumulado:0.10746622085571
(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.00047397613525391Tiempo acumulado:0.10794019699097
(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.00047993659973145Tiempo acumulado:0.1084201335907
(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 = 'subdomain_lang'
AND CFG.AMBITO IN ('es_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047802925109863Tiempo acumulado:0.1088981628418
(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_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.00046181678771973Tiempo acumulado:0.10935997962952
(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_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.00046896934509277Tiempo acumulado:0.10982894897461
(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.00046610832214355Tiempo acumulado:0.11029505729675
(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.00049400329589844Tiempo acumulado:0.11078906059265
(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 = 'subdomain_lang'
AND CFG.AMBITO IN ('es_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049400329589844Tiempo acumulado:0.11128306388855
(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_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.00048494338989258Tiempo acumulado:0.11176800727844
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[122]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1405
AND FOTO = 'nino-escalando-en-rocodromo.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00064206123352051Tiempo acumulado:0.11241006851196
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[123]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1405
AND FOTO = 'jovenes-escalando-el-rocodromo.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00054097175598145Tiempo acumulado:0.11295104026794
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[124]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.00035881996154785Tiempo acumulado:0.11330986022949
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[125]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.00033903121948242Tiempo acumulado:0.11364889144897
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[126]: 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='1405'
LIMIT 1;
Tiempo de la consulta:
0.00057721138000488Tiempo acumulado:0.11422610282898
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[127]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1405
AND FOTO = 'nino-escalando-en-rocodromo.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00059008598327637Tiempo acumulado:0.11481618881226
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[128]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1405
AND FOTO = 'jovenes-escalando-el-rocodromo.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00054216384887695Tiempo acumulado:0.11535835266113
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[129]: 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 = 1405;
Tiempo de la consulta:
0.00043177604675293Tiempo acumulado:0.11579012870789
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[130]: 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.00051403045654297Tiempo acumulado:0.11630415916443
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[131]: 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.00049519538879395Tiempo acumulado:0.11679935455322
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[132]: 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.00048995018005371Tiempo acumulado:0.11728930473328
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[133]: 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.00051307678222656Tiempo acumulado:0.1178023815155
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[134]: 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.00048995018005371Tiempo acumulado:0.11829233169556
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[135]: 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 = 24
AND CON.VALID = 1
AND CON.ID_CONTENIDO !=1405
ORDER BY RAND()
LIMIT 4;
Tiempo de la consulta:
0.0023748874664307Tiempo acumulado:0.12066721916199
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[136]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 162
AND FOTO = 'magnesio.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0010139942169189Tiempo acumulado:0.12168121337891
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[137]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 738
AND FOTO = 'Carlos Suarez5.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0011711120605469Tiempo acumulado:0.12285232543945
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[138]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 6
AND FOTO = 'edurne2.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0016300678253174Tiempo acumulado:0.12448239326477
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[139]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 751
AND FOTO = 'Luis Fernandez.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00049114227294922Tiempo acumulado:0.12497353553772
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[140]: 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.00064587593078613Tiempo acumulado:0.12561941146851
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[141]: 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.0004570484161377Tiempo acumulado:0.12607645988464
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[142]: 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.00046491622924805Tiempo acumulado:0.12654137611389
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[143]: 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.00046610832214355Tiempo acumulado:0.12700748443604
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[144]: 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.00049495697021484Tiempo acumulado:0.12750244140625
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[145]: 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.00049018859863281Tiempo acumulado:0.12799263000488
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[146]: 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.00045490264892578Tiempo acumulado:0.12844753265381
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[147]: 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.00046110153198242Tiempo acumulado:0.12890863418579
(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 = '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.00046610832214355Tiempo acumulado:0.12937474250793
(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 = '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.00046396255493164Tiempo acumulado:0.12983870506287
(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 = '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.00046205520629883Tiempo acumulado:0.13030076026917
(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 = '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.00047993659973145Tiempo acumulado:0.1307806968689
(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 = '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.00044584274291992Tiempo acumulado:0.13122653961182
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[153]: 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.00043201446533203Tiempo acumulado:0.13165855407715
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[154]: 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.00042104721069336Tiempo acumulado:0.13207960128784
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[155]: 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.00041985511779785Tiempo acumulado:0.13249945640564
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[156]: 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.00040912628173828Tiempo acumulado:0.13290858268738
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[157]: 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.00040602684020996Tiempo acumulado:0.13331460952759
(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 = '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.00040888786315918Tiempo acumulado:0.13372349739075
(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 = '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.00041604042053223Tiempo acumulado:0.13413953781128
(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 = '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.00041007995605469Tiempo acumulado:0.13454961776733
(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 = '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.00040102005004883Tiempo acumulado:0.13495063781738
(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 = '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.00039887428283691Tiempo acumulado:0.13534951210022
(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 = '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.00041604042053223Tiempo acumulado:0.13576555252075
(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 = '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.0004279613494873Tiempo acumulado:0.13619351387024
(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 = '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.0004270076751709Tiempo acumulado:0.13662052154541
(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 = '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.00041604042053223Tiempo acumulado:0.13703656196594
(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 = '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.00040388107299805Tiempo acumulado:0.13744044303894
(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 = '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.00041699409484863Tiempo acumulado:0.13785743713379
(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 = '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.00041604042053223Tiempo acumulado:0.13827347755432
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[170]: 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.016762971878052Tiempo acumulado:0.15503644943237
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[171]: 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
AND ID_ACTIVIDAD_PS='24'
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:
0.012337923049927Tiempo acumulado:0.1673743724823
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[172]: 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 = 45872;
Tiempo de la consulta:
0.0043511390686035Tiempo acumulado:0.1717255115509
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[173]: 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 = 45872;
Tiempo de la consulta:
0.00048685073852539Tiempo acumulado:0.17221236228943
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[174]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 45872
AND VALID = 1;
Tiempo de la consulta:
0.0028500556945801Tiempo acumulado:0.17506241798401
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[175]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 45872
AND FOTO = 'p-45872-alpinismo_14792291107909.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00052809715270996Tiempo acumulado:0.17559051513672
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[176]: SELECT ID_PRECIO, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_PRECIO =45872;
Tiempo de la consulta:
0.00032901763916016Tiempo acumulado:0.17591953277588
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[177]: 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 = 14217;
Tiempo de la consulta:
0.00047397613525391Tiempo acumulado:0.17639350891113
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[178]: 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 = 14217;
Tiempo de la consulta:
0.00044584274291992Tiempo acumulado:0.17683935165405
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[179]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 14217
AND VALID = 1;
Tiempo de la consulta:
0.0020210742950439Tiempo acumulado:0.1788604259491
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[180]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 14217
AND FOTO = 'con-la-atencion-en-la-roca.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00044798851013184Tiempo acumulado:0.17930841445923
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[181]: SELECT ID_PRECIO, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_PRECIO =14217;
Tiempo de la consulta:
0.00033903121948242Tiempo acumulado:0.17964744567871
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[182]: 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 = 60076;
Tiempo de la consulta:
0.00049185752868652Tiempo acumulado:0.1801393032074
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[183]: 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 = 60076;
Tiempo de la consulta:
0.00042986869812012Tiempo acumulado:0.18056917190552
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[184]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 60076
AND VALID = 1;
Tiempo de la consulta:
0.0024650096893311Tiempo acumulado:0.18303418159485
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[185]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 60076
AND FOTO = 'p-60076-chica-escalando-en-montserrat_15450491982794.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00045895576477051Tiempo acumulado:0.18349313735962
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[186]: SELECT ID_PRECIO, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_PRECIO =60076;
Tiempo de la consulta:
0.00035691261291504Tiempo acumulado:0.18385004997253
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[187]: 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 = 40677;
Tiempo de la consulta:
0.00049901008605957Tiempo acumulado:0.18434906005859
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[188]: 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 = 40677;
Tiempo de la consulta:
0.00042486190795898Tiempo acumulado:0.18477392196655
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[189]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 40677
AND VALID = 1;
Tiempo de la consulta:
0.0024440288543701Tiempo acumulado:0.18721795082092
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[190]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 40677
AND FOTO = 'p-40677-escalada-en-pars-de-sobira_15505976212166.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00046205520629883Tiempo acumulado:0.18768000602722
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[191]: SELECT ID_PRECIO, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_PRECIO =40677;
Tiempo de la consulta:
0.00034093856811523Tiempo acumulado:0.18802094459534
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[192]: 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 = 25719;
Tiempo de la consulta:
0.0004580020904541Tiempo acumulado:0.18847894668579
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[193]: 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 = 25719;
Tiempo de la consulta:
0.00050497055053711Tiempo acumulado:0.18898391723633
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[194]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 25719
AND VALID = 1;
Tiempo de la consulta:
0.0020549297332764Tiempo acumulado:0.1910388469696
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[195]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 25719
AND FOTO = 'ascension-por-el-hielo-en-gerona.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00044417381286621Tiempo acumulado:0.19148302078247
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[196]: SELECT ID_PRECIO, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_PRECIO =25719;
Tiempo de la consulta:
0.00035285949707031Tiempo acumulado:0.19183588027954
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[197]: 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 ('1405')
ORDER BY FIELD(TIPO_CONTENIDOS,2) DESC, CON.FEC_INSERT DESC
LIMIT 5;
Tiempo de la consulta:
0.0066440105438232Tiempo acumulado:0.19847989082336
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[198]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1440
AND FOTO = 'rosafernandez-montana-1715619284-3367181065376628508-15541999721717594131.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0010149478912354Tiempo acumulado:0.1994948387146
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[199]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1220
AND FOTO = 'entrevista-richi-navarro-1.jpg'
AND VALID=1;
Tiempo de la consulta:
0.001539945602417Tiempo acumulado:0.20103478431702
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[200]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1198
AND FOTO = 'entrevista-blanca-manchon-2.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0015048980712891Tiempo acumulado:0.20253968238831
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[201]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1095
AND FOTO = 'c-1095-entrevista-a-carlos-pedro-briceno-11528292523.7674.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00051999092102051Tiempo acumulado:0.20305967330933
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[202]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1120
AND FOTO = 'entrevista-a-gerard-rull-principal-1.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0011169910430908Tiempo acumulado:0.20417666435242
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[203]: 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_SECTOR = 24
AND (RS.ID_GRUPO IS NULL OR RS.ID_GRUPO = 0)
GROUP BY PRE.ID_REGION_PRE
ORDER BY NEMPRESAS DESC;
Tiempo de la consulta (slow_query): 0.16579508781433Tiempo acumulado:0.36997175216675
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[204]: SELECT *
FROM LO_EQUIPO_EDITORIAL EE
WHERE EE.ID_TROPIC = 16;
Tiempo de la consulta:
0.00041913986206055Tiempo acumulado:0.37039089202881
