yu-front-06.localdomain (172.30.2.194:443)
prod.yumping.com
/contenido-Show.php
BBDD->Prod_Yumping_es_ES
AMBITO->es_en
AMBITO_AJAX->es_en
AMBITO_AJAX COOKIE->
locale LO_CONFIG->en_IN
locale php->en_IN
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->en
id_contenido->1051
tpage->contenidoShow
rel_alternate->1
Total queries: 214
Tiempo total: 0.47809505462646
>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', 'gb')
ORDER BY CFG.NAME;
Tiempo de la consulta:
0.015630006790161Tiempo acumulado:0.015630006790161
(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.00073122978210449Tiempo acumulado:0.016361236572266
(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 = 1051
/*
AND (
fnGoogleUrl(C.TITULO) = 'from-bungee-jumping-to-canyoning-in-valencia-with-en-ruta'
OR fnGoogleUrl(CT.TITULO) = 'from-bungee-jumping-to-canyoning-in-valencia-with-en-ruta'
OR URL_CT = 'from-bungee-jumping-to-canyoning-in-valencia-with-en-ruta') */ 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 = 1051
/*
AND (
fnGoogleUrl(C.TITULO) = 'from-bungee-jumping-to-canyoning-in-valencia-with-en-ruta'
OR fnGoogleUrl(CT.TITULO) = 'from-bungee-jumping-to-canyoning-in-valencia-with-en-ruta'
OR URL_CT = 'from-bungee-jumping-to-canyoning-in-valencia-with-en-ruta') */ 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 = 1051
/*
AND (
fnGoogleUrl(C.TITULO) = 'from-bungee-jumping-to-canyoning-in-valencia-with-en-ruta'
OR fnGoogleUrl(CT.TITULO) = 'from-bungee-jumping-to-canyoning-in-valencia-with-en-ruta'
OR URL_CT = 'from-bungee-jumping-to-canyoning-in-valencia-with-en-ruta') */ 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 = 1051
/*
AND (
fnGoogleUrl(C.TITULO) = 'from-bungee-jumping-to-canyoning-in-valencia-with-en-ruta'
OR fnGoogleUrl(CT.TITULO) = 'from-bungee-jumping-to-canyoning-in-valencia-with-en-ruta'
OR URL_CT = 'from-bungee-jumping-to-canyoning-in-valencia-with-en-ruta') */ 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 = 1051
/*
AND (
fnGoogleUrl(C.TITULO) = 'from-bungee-jumping-to-canyoning-in-valencia-with-en-ruta'
OR fnGoogleUrl(CT.TITULO) = 'from-bungee-jumping-to-canyoning-in-valencia-with-en-ruta'
OR URL_CT = 'from-bungee-jumping-to-canyoning-in-valencia-with-en-ruta') */ 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 = 1051
/*
AND (
fnGoogleUrl(C.TITULO) = 'from-bungee-jumping-to-canyoning-in-valencia-with-en-ruta'
OR fnGoogleUrl(CT.TITULO) = 'from-bungee-jumping-to-canyoning-in-valencia-with-en-ruta'
OR URL_CT = 'from-bungee-jumping-to-canyoning-in-valencia-with-en-ruta') */ ) AS CONTENIDO;
Tiempo de la consulta:
0.036067962646484Tiempo acumulado:0.05242919921875
(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_en')
ORDER BY CFG.NAME;
Tiempo de la consulta:
0.0076909065246582Tiempo acumulado:0.060120105743408
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[5]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.0011868476867676Tiempo acumulado:0.061306953430176
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[6]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.0021631717681885Tiempo acumulado:0.063470125198364
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[7]: SELECT `TIMESTAMP`, VALUE
FROM LO_CURRENCIES_CONVERSION
WHERE `FROM` = 'EUR'
AND `TO` = 'GBP';
Tiempo de la consulta:
0.00076699256896973Tiempo acumulado:0.064237117767334
(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 = 'ambito_lang';
Tiempo de la consulta:
0.00061202049255371Tiempo acumulado:0.064849138259888
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[9]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'id_contenido';
Tiempo de la consulta:
0.00036382675170898Tiempo acumulado:0.065212965011597
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[10]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'tpage';
Tiempo de la consulta:
0.00054121017456055Tiempo acumulado:0.065754175186157
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[11]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'rel_alternate';
Tiempo de la consulta:
0.00036001205444336Tiempo acumulado:0.066114187240601
(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_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.00054383277893066Tiempo acumulado:0.066658020019531
(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_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00055694580078125Tiempo acumulado:0.067214965820312
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[14]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_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.00057005882263184Tiempo acumulado:0.067785024642944
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[15]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_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.0013589859008789Tiempo acumulado:0.069144010543823
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[16]: 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.00065302848815918Tiempo acumulado:0.069797039031982
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[17]: SELECT 'es_en' 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 = 'en'
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 = 12
WHERE CON.ID_CONTENIDO=1051
AND CON.VALID=1
AND CATI.ID_TROPIC=12;
Tiempo de la consulta:
0.003464937210083Tiempo acumulado:0.073261976242065
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[18]: 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='32'
AND CAT.ID_CATEG=CATI.ID_CATEG
AND CON.ID_CONTENIDO='1051'
AND CON.VALID=1
AND SECI.ID_SECTOR=SEC.ID_SECTOR
AND SECI.ID_TROPIC = 12
AND CATI.ID_TROPIC = 1
AND CON.ID_CATEG = CATI.ID_CATEG
AND CAT.ID_SECTOR=SEC.ID_SECTOR;
Tiempo de la consulta:
0.0010011196136475Tiempo acumulado:0.074263095855713
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[19]: 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.0038120746612549Tiempo acumulado:0.078075170516968
(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_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.00050091743469238Tiempo acumulado:0.07857608795166
(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_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049185752868652Tiempo acumulado:0.079067945480347
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[22]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00056219100952148Tiempo acumulado:0.079630136489868
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[23]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_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.0013821125030518Tiempo acumulado:0.08101224899292
(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 = '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.00050806999206543Tiempo acumulado:0.081520318984985
(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_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049304962158203Tiempo acumulado:0.082013368606567
(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_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00048398971557617Tiempo acumulado:0.082497358322144
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[27]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00048112869262695Tiempo acumulado:0.082978487014771
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[28]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050806999206543Tiempo acumulado:0.083486557006836
(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 = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004880428314209Tiempo acumulado:0.083974599838257
(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', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00048398971557617Tiempo acumulado:0.084458589553833
(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', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0012948513031006Tiempo acumulado:0.085753440856934
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[32]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047183036804199Tiempo acumulado:0.086225271224976
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[33]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00048303604125977Tiempo acumulado:0.086708307266235
(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 = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049185752868652Tiempo acumulado:0.087200164794922
(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_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('mx_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045108795166016Tiempo acumulado:0.087651252746582
(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_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('mx_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00048589706420898Tiempo acumulado:0.088137149810791
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[37]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('mx_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047206878662109Tiempo acumulado:0.088609218597412
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[38]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('mx_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047898292541504Tiempo acumulado:0.089088201522827
(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 = 'mx_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('mx_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.001305103302002Tiempo acumulado:0.090393304824829
(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_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050497055053711Tiempo acumulado:0.090898275375366
(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_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.002263069152832Tiempo acumulado:0.093161344528198
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[42]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00051188468933105Tiempo acumulado:0.093673229217529
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[43]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050902366638184Tiempo acumulado:0.094182252883911
(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 = 'it_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00048708915710449Tiempo acumulado:0.094669342041016
(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_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('fr_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049281120300293Tiempo acumulado:0.095162153244019
(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_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('fr_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0012772083282471Tiempo acumulado:0.096439361572266
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[47]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('fr_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045895576477051Tiempo acumulado:0.096898317337036
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[48]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('fr_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004727840423584Tiempo acumulado:0.097371101379395
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[49]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('fr_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00052094459533691Tiempo acumulado:0.097892045974731
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[50]: 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 = '12'
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 = '82'
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 = '2'
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 = '52'
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 = '32'
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 = '42'
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.028695106506348Tiempo acumulado:0.12658715248108
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[51]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1051
AND FOTO = 'c-1051-emocionado-ante-el-momento-del-salto1510655587.0161.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0015921592712402Tiempo acumulado:0.12817931175232
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[52]: SELECT OLD_URL, NEW_URL
FROM LO_URL_301 U
WHERE U.OLD_URL = '/en/adventure-sports-news/from-bungee-jumping-to-canyoning-in-valencia-with-en-ruta--c1051';
Tiempo de la consulta:
0.0003821849822998Tiempo acumulado:0.12856149673462
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[53]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es', 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.00049805641174316Tiempo acumulado:0.12905955314636
(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', 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.00053906440734863Tiempo acumulado:0.12959861755371
(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_con_traducciones'
AND CFG.AMBITO IN ('es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00048685073852539Tiempo acumulado:0.13008546829224
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[56]: 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 = 1051;
Tiempo de la consulta:
0.0007319450378418Tiempo acumulado:0.13081741333008
(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 = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046396255493164Tiempo acumulado:0.13128137588501
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[58]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_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.00049304962158203Tiempo acumulado:0.13177442550659
(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_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.00050497055053711Tiempo acumulado:0.13227939605713
(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_con_traducciones'
AND CFG.AMBITO IN ('es_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00048303604125977Tiempo acumulado:0.13276243209839
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[61]: 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 = 1051;
Tiempo de la consulta:
0.00075602531433105Tiempo acumulado:0.13351845741272
(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 = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('es_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046181678771973Tiempo acumulado:0.13398027420044
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[63]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_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.00048494338989258Tiempo acumulado:0.13446521759033
(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_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.00048208236694336Tiempo acumulado:0.13494729995728
(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_con_traducciones'
AND CFG.AMBITO IN ('es_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047397613525391Tiempo acumulado:0.13542127609253
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[66]: 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 = 1051;
Tiempo de la consulta:
0.00068402290344238Tiempo acumulado:0.13610529899597
(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 = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('es_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045084953308105Tiempo acumulado:0.13655614852905
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[68]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_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.00049304962158203Tiempo acumulado:0.13704919815063
(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_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.00047683715820312Tiempo acumulado:0.13752603530884
(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_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.00048995018005371Tiempo acumulado:0.13801598548889
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[71]: 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 = 'ch'
WHERE C.ID_CONTENIDO = 1051;
Tiempo de la consulta:
0.0006859302520752Tiempo acumulado:0.13870191574097
(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_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045394897460938Tiempo acumulado:0.13915586471558
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[73]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('es_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047588348388672Tiempo acumulado:0.13963174819946
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[74]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_multidioma'
AND CFG.AMBITO IN ('es_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00086379051208496Tiempo acumulado:0.14049553871155
(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_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.00051212310791016Tiempo acumulado:0.14100766181946
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[76]: 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 = 1051;
Tiempo de la consulta:
0.00075411796569824Tiempo acumulado:0.14176177978516
(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_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.00045895576477051Tiempo acumulado:0.14222073554993
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[78]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('es_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046992301940918Tiempo acumulado:0.14269065856934
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[79]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_multidioma'
AND CFG.AMBITO IN ('es_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00089597702026367Tiempo acumulado:0.1435866355896
(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_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.0004730224609375Tiempo acumulado:0.14405965805054
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[81]: 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 = 1051;
Tiempo de la consulta:
0.00066900253295898Tiempo acumulado:0.1447286605835
(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_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.00046801567077637Tiempo acumulado:0.14519667625427
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[83]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('es_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046205520629883Tiempo acumulado:0.14565873146057
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[84]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_multidioma'
AND CFG.AMBITO IN ('es_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047588348388672Tiempo acumulado:0.14613461494446
(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_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.00047898292541504Tiempo acumulado:0.14661359786987
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[86]: 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 = 1051;
Tiempo de la consulta:
0.00065898895263672Tiempo acumulado:0.14727258682251
(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_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.00044703483581543Tiempo acumulado:0.14771962165833
(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', 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.0004417896270752Tiempo acumulado:0.1481614112854
(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', 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.00047016143798828Tiempo acumulado:0.14863157272339
(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 = 'subdomain'
AND CFG.AMBITO IN ('es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045204162597656Tiempo acumulado:0.14908361434937
(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.00046515464782715Tiempo acumulado:0.14954876899719
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[92]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045418739318848Tiempo acumulado:0.15000295639038
(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 = 'subdomain_lang'
AND CFG.AMBITO IN ('es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0006110668182373Tiempo acumulado:0.15061402320862
(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_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.00050497055053711Tiempo acumulado:0.15111899375916
(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_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.0060889720916748Tiempo acumulado:0.15720796585083
(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.0004880428314209Tiempo acumulado:0.15769600868225
(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.00046181678771973Tiempo acumulado:0.15815782546997
(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 = 'subdomain_lang'
AND CFG.AMBITO IN ('es_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047707557678223Tiempo acumulado:0.15863490104675
(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_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.00049805641174316Tiempo acumulado:0.1591329574585
(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_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.00053715705871582Tiempo acumulado:0.15967011451721
(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.00050997734069824Tiempo acumulado:0.16018009185791
(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.00054407119750977Tiempo acumulado:0.16072416305542
(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 = 'subdomain_lang'
AND CFG.AMBITO IN ('es_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050902366638184Tiempo acumulado:0.1612331867218
(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_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.00047492980957031Tiempo acumulado:0.16170811653137
(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_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.00054097175598145Tiempo acumulado:0.16224908828735
(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_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.00048589706420898Tiempo acumulado:0.16273498535156
(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_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.00045585632324219Tiempo acumulado:0.1631908416748
(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_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.00045514106750488Tiempo acumulado:0.16364598274231
(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.00099992752075195Tiempo acumulado:0.16464591026306
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[110]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0017268657684326Tiempo acumulado:0.16637277603149
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[111]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00048494338989258Tiempo acumulado:0.16685771942139
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[112]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049185752868652Tiempo acumulado:0.16734957695007
(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_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.0028398036956787Tiempo acumulado:0.17018938064575
(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.0065112113952637Tiempo acumulado:0.17670059204102
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[115]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.006537914276123Tiempo acumulado:0.18323850631714
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[116]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0062580108642578Tiempo acumulado:0.1894965171814
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[117]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0038559436798096Tiempo acumulado:0.19335246086121
(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_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.0091731548309326Tiempo acumulado:0.20252561569214
(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.0068478584289551Tiempo acumulado:0.20937347412109
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[120]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0005340576171875Tiempo acumulado:0.20990753173828
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[121]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00051307678222656Tiempo acumulado:0.21042060852051
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[122]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004889965057373Tiempo acumulado:0.21090960502625
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[123]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_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.00051999092102051Tiempo acumulado:0.21142959594727
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[124]: 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.00050115585327148Tiempo acumulado:0.21193075180054
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[125]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1051
AND FOTO = 'c-1051-subiendo-la-ferrata-en-grupo1510655586.4581.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00060510635375977Tiempo acumulado:0.2125358581543
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[126]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1051
AND FOTO = 'c-1051-emocionado-ante-el-momento-del-salto1510655587.0161.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00049400329589844Tiempo acumulado:0.2130298614502
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[127]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1051
AND FOTO = 'c-1051-lanzandose-desde-el-puente1510655587.5299.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00049209594726562Tiempo acumulado:0.21352195739746
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[128]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1051
AND FOTO = 'c-1051-tobogan-en-el-barranco1510655588.0109.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0005030632019043Tiempo acumulado:0.21402502059937
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[129]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1051
AND FOTO = 'c-1051-escalada-familiar1510655588.5115.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00051712989807129Tiempo acumulado:0.21454215049744
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[130]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.00035285949707031Tiempo acumulado:0.21489500999451
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[131]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.00030398368835449Tiempo acumulado:0.21519899368286
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[132]: 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='12'
AND CON.ID_CONTENIDO='1051'
LIMIT 1;
Tiempo de la consulta:
0.00055098533630371Tiempo acumulado:0.21574997901917
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[133]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1051
AND FOTO = 'c-1051-subiendo-la-ferrata-en-grupo1510655586.4581.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00051307678222656Tiempo acumulado:0.21626305580139
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[134]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1051
AND FOTO = 'c-1051-emocionado-ante-el-momento-del-salto1510655587.0161.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00047612190246582Tiempo acumulado:0.21673917770386
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[135]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1051
AND FOTO = 'c-1051-lanzandose-desde-el-puente1510655587.5299.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00052499771118164Tiempo acumulado:0.21726417541504
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[136]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1051
AND FOTO = 'c-1051-tobogan-en-el-barranco1510655588.0109.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00054001808166504Tiempo acumulado:0.2178041934967
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[137]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1051
AND FOTO = 'c-1051-escalada-familiar1510655588.5115.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00047993659973145Tiempo acumulado:0.21828413009644
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[138]: 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 = 12
WHERE C.TITULO LIKE '10 cosas que hacer en%'
AND C.ID_CONTENIDO = 1051;
Tiempo de la consulta:
0.001223087310791Tiempo acumulado:0.21950721740723
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[139]: 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.0005500316619873Tiempo acumulado:0.22005724906921
(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_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0016970634460449Tiempo acumulado:0.22175431251526
(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_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.00054001808166504Tiempo acumulado:0.22229433059692
(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_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.0004880428314209Tiempo acumulado:0.22278237342834
(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_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.00046086311340332Tiempo acumulado:0.22324323654175
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[144]: 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 = 'en'
WHERE
(CON.GALERIA IS NOT NULL
AND CON.GALERIA<>'')
AND CON.ID_CATEG = 32
AND CON.VALID = 1
AND CON.ID_CONTENIDO !=1051
ORDER BY RAND()
LIMIT 4;
Tiempo de la consulta:
0.015758991241455Tiempo acumulado:0.2390022277832
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[145]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 995
AND FOTO = 'Saltando desde un puente en murcia.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0015997886657715Tiempo acumulado:0.24060201644897
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[146]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 54
AND FOTO = 'portada1698335011.jpg'
AND VALID=1;
Tiempo de la consulta:
0.001694917678833Tiempo acumulado:0.24229693412781
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[147]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1297
AND FOTO = '119448255-3178108252285767-4807189603890350995-o.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0015308856964111Tiempo acumulado:0.24382781982422
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[148]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 923
AND FOTO = 'Saltando desde un puente.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0010290145874023Tiempo acumulado:0.24485683441162
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[149]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_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.00054287910461426Tiempo acumulado:0.24539971351624
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[150]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00056314468383789Tiempo acumulado:0.24596285820007
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[151]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047612190246582Tiempo acumulado:0.24643898010254
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[152]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_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.00047898292541504Tiempo acumulado:0.24691796302795
(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 = '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.00047087669372559Tiempo acumulado:0.24738883972168
(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 = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046491622924805Tiempo acumulado:0.24785375595093
(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 = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004580020904541Tiempo acumulado:0.24831175804138
(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 = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046396255493164Tiempo acumulado:0.24877572059631
(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 = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046801567077637Tiempo acumulado:0.24924373626709
(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 = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00048089027404785Tiempo acumulado:0.24972462654114
(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 = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045990943908691Tiempo acumulado:0.25018453598022
(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 = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046300888061523Tiempo acumulado:0.25064754486084
(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 = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047588348388672Tiempo acumulado:0.25112342834473
(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 = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00048398971557617Tiempo acumulado:0.2516074180603
(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 = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046920776367188Tiempo acumulado:0.25207662582397
(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 = 'mx_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('mx_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046491622924805Tiempo acumulado:0.25254154205322
(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 = 'mx_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('mx_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046706199645996Tiempo acumulado:0.25300860404968
(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 = 'mx_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('mx_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042486190795898Tiempo acumulado:0.25343346595764
(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 = 'mx_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('mx_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041890144348145Tiempo acumulado:0.25385236740112
(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 = 'mx_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('mx_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043106079101562Tiempo acumulado:0.25428342819214
(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 = 'it_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042891502380371Tiempo acumulado:0.25471234321594
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[170]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00040793418884277Tiempo acumulado:0.25512027740479
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[171]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00040602684020996Tiempo acumulado:0.255526304245
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[172]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00040984153747559Tiempo acumulado:0.25593614578247
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[173]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041484832763672Tiempo acumulado:0.25635099411011
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[174]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('fr_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004119873046875Tiempo acumulado:0.25676298141479
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[175]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('fr_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00040411949157715Tiempo acumulado:0.25716710090637
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[176]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('fr_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00048398971557617Tiempo acumulado:0.25765109062195
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[177]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('fr_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004420280456543Tiempo acumulado:0.2580931186676
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[178]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('fr_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041985511779785Tiempo acumulado:0.2585129737854
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[179]: 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 = '12'
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 = '82'
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 = '2'
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 = '52'
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 = '32'
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 = '42'
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.018049001693726Tiempo acumulado:0.27656197547913
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[180]: 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_EN PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'en'
INNER JOIN LO_PRECIOS_SECTORES PS ON PRE.ID_PRECIO=PS.ID_PRECIO_PS
AND ID_ACTIVIDAD_PS='32'
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=12
AND SECI.FK_ID_IDIOMA_SI18N='en'
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PRE.ID_REGION_PRE
AND REI.IDIOMA='en'
INNER JOIN LO_POBLACION_ES PO ON PO.ID_POBLACION = PRE.ID_POBLACION_PRE
AND PO.IDIOMA='en'
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.02223014831543Tiempo acumulado:0.29879212379456
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[181]: 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_EN PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'en'
WHERE PRE.ID_PRECIO = 50480;
Tiempo de la consulta:
0.00055789947509766Tiempo acumulado:0.29935002326965
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[182]: 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 = 50480;
Tiempo de la consulta:
0.00045895576477051Tiempo acumulado:0.29980897903442
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[183]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 50480
AND VALID = 1;
Tiempo de la consulta:
0.0022649765014648Tiempo acumulado:0.30207395553589
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[184]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 50480
AND FOTO = 'p-50480-impresionante-salto-de-puenting_14972657603033.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00049901008605957Tiempo acumulado:0.30257296562195
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[185]: SELECT ID_PRECIO, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_PRECIO =50480;
Tiempo de la consulta:
0.0010709762573242Tiempo acumulado:0.30364394187927
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[186]: 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_EN PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'en'
WHERE PRE.ID_PRECIO = 37971;
Tiempo de la consulta:
0.00049805641174316Tiempo acumulado:0.30414199829102
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[187]: 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 = 37971;
Tiempo de la consulta:
0.00035595893859863Tiempo acumulado:0.30449795722961
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[188]: SELECT PRE.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, PRE.PRECIO_PRE, PRE.MAX_PERS_PRE, PRE.MIN_PERS_PRE, PRE.ID_PRECIO,
PRE.MULTIACTIVIDAD_PRE, PRE.ID_EMPRESA_PRE, PRE.ID_REGION_PRE,PRE.VALID_PRE, PRE.ALOJAMIENTO_PRE, PRE.EDAD_MINIMA_PRE,
PRE.TRANSPORTE_PRE, PRE.COMIDA_PRE,PRE.GALERIA_PRE, PRE.FOTOPRINCIPAL_PRE, PRECIO_UNITARIO_PRE
,REI.DESC_REGION DESC_REGION, EXI.N_VENTAS, EXI.EXITO, SECI.URL URL_SECTOR,REI.URL URL_REGION,
EMP.*, POI.DESC_POBLACION, POI.URL_POBLACION, SECI.DESC_SECTOR, SECP.ID_ACTIVIDAD_PS,Ceiling(AVG(OP.VALORACION)) AS VALORACION, SECI.DESC_SECTOR_ALT, SECI.DESC_SECTOR_ALT_PLURAL,
COUNT(DISTINCT OP.ID_OPINION) as N_OPINIONES,EMPS.CENTRAL_ACTIVA, REI.ID_REGION, SECI.ID_SECTOR, PD.OFERTA_PD,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%Y/%m/%d') AS FECHA,PERIODO_PRE,ANTELACION_PRE, SEC.ID_GRUPO,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%Y/%m/%d') AS FEC_ULT_COMPRA,
IF(PRECIO_PD>0,LEAST(MIN(PRECIO_PD),PRECIO_PRE),LEAST(999999999,PRECIO_PRE) ) PRECIO,
IF(PRECIO_PD>0
AND VALID_PD=1, (1-(MIN(PRECIO_PD)/PRECIO_PRE))*100 ,0) DESCUENTO,
DATE_FORMAT(PD.FECHA_CADUCIDAD_PD,'%d') AS DIA_CAD,
DATE_FORMAT(PD.FECHA_CADUCIDAD_PD,'%m') AS MES_CAD,
DATE_FORMAT(PD.FECHA_CADUCIDAD_PD,'%Y') AS ANYO_CAD,
SIN_FECHA_PRE, PRE.CANTIDAD_UNITARIO_PRE, DATE_FORMAT(PRE.FEC_INSERT_PRE,'%Y/%m/%d') AS FEC_INSERT_PRE, EMP.LATITUDE, EMP.LONGITUDE, PRE.N_VENTAS_PRE
,PRE.ID_POBLACION_PRE, PRE.ID_POBLACION_PRE AS ID_POBLACION
FROM LO_PRECIOS PRE
INNER JOIN LO_EMPRESAS EMP ON PRE.ID_EMPRESA_PRE=EMP.ID_EMPRESA
INNER JOIN LO_EMPRESAS_STAT EMPS ON EMP.ID_EMPRESA=EMPS.FK_ID_EST
INNER JOIN LO_PRECIOS_SECTORES SECP ON PRE.ID_PRECIO=SECP.ID_PRECIO_PS
/*
AND SECP.ID_ACTIVIDAD_PS NOT IN (100,101)*/
AND SECP.ID_ACTIVIDAD_PS = (SELECT PS.ID_ACTIVIDAD_PS
FROM LO_PRECIOS_SECTORES PS
WHERE PS.ID_PRECIO_PS = PRE.ID_PRECIO
ORDER BY IF(PS.ID_ACTIVIDAD_PS = 100 OR PS.ID_ACTIVIDAD_PS = 101, 10000, 1) ASC
LIMIT 1)
INNER JOIN LO_SECTORES SEC ON SECP.ID_ACTIVIDAD_PS=SEC.ID_SECTOR
INNER JOIN LO_SECTORES_I18N SECI ON SEC.ID_SECTOR=SECI.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N ='en'
AND SECI.ID_TROPIC = 12
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PRE.ID_REGION_PRE
AND REI.IDIOMA ='en'
INNER JOIN LO_POBLACION_ES POI ON POI.ID_POBLACION = PRE.ID_POBLACION_PRE
AND POI.IDIOMA ='en'
LEFT JOIN LO_PRECIOS_EXITO EXI ON PRE.ID_PRECIO = EXI.ID_PRECIO
LEFT JOIN LO_RESERVAS_COMPRAS RC ON RC.ID_PRECIO_RC = PRE.ID_PRECIO
AND RC.VALID_RC NOT IN (7,2,0)
LEFT JOIN LO_EMPRESAS_OPINIONES OP ON OP.RESERVA_FEEDBACK = RC.ID_RESERVA_COMPRA
AND OP.VALID = 1
LEFT JOIN LO_PRECIOS_DESCUENTOS PD ON PD.ID_PRECIO_PD = PRE.ID_PRECIO
AND PD.VALID_PD = 1
INNER JOIN LO_PRECIOS_TRADUCCION_EN PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'en'
WHERE REI.IDIOMA='en'
AND EMP.VALID=1
AND VALID_PRE IN(1,4,3)
AND PRE.ID_PRECIO='43215'
LIMIT 1;
Tiempo de la consulta:
0.0027811527252197Tiempo acumulado:0.30727910995483
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[189]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 37971
AND VALID = 1;
Tiempo de la consulta:
0.0026581287384033Tiempo acumulado:0.30993723869324
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[190]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 37971
AND FOTO = 'salto-de-puenting.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00047397613525391Tiempo acumulado:0.31041121482849
(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 =37971;
Tiempo de la consulta:
0.00034403800964355Tiempo acumulado:0.31075525283813
(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_EN PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'en'
WHERE PRE.ID_PRECIO = 52830;
Tiempo de la consulta:
0.00047898292541504Tiempo acumulado:0.31123423576355
(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 = 52830;
Tiempo de la consulta:
0.00045394897460938Tiempo acumulado:0.31168818473816
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[194]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 52830
AND VALID = 1;
Tiempo de la consulta:
0.0021431446075439Tiempo acumulado:0.3138313293457
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[195]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 52830
AND FOTO = 'p-52830-a-punto-de-saltar_15054799012541.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00048494338989258Tiempo acumulado:0.3143162727356
(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 =52830;
Tiempo de la consulta:
0.00033688545227051Tiempo acumulado:0.31465315818787
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[197]: 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_EN PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'en'
WHERE PRE.ID_PRECIO = 9790;
Tiempo de la consulta:
0.00049996376037598Tiempo acumulado:0.31515312194824
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[198]: 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 = 9790;
Tiempo de la consulta:
0.00046014785766602Tiempo acumulado:0.31561326980591
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[199]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 9790
AND VALID = 1;
Tiempo de la consulta:
0.0014748573303223Tiempo acumulado:0.31708812713623
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[200]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 9790
AND FOTO = 'charate.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00046300888061523Tiempo acumulado:0.31755113601685
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[201]: SELECT ID_PRECIO, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_PRECIO =9790;
Tiempo de la consulta:
0.00082015991210938Tiempo acumulado:0.31837129592896
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[202]: 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_EN PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'en'
WHERE PRE.ID_PRECIO = 63139;
Tiempo de la consulta:
0.00049781799316406Tiempo acumulado:0.31886911392212
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[203]: 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 = 63139;
Tiempo de la consulta:
0.00046801567077637Tiempo acumulado:0.3193371295929
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[204]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 63139
AND VALID = 1;
Tiempo de la consulta:
0.0037071704864502Tiempo acumulado:0.32304430007935
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[205]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 63139
AND FOTO = 'p-63139-mascarat_1570789763280.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00049495697021484Tiempo acumulado:0.32353925704956
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[206]: SELECT ID_PRECIO, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_PRECIO =63139;
Tiempo de la consulta:
0.00036096572875977Tiempo acumulado:0.32390022277832
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[207]: 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 = 'en'
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 ('1051')
ORDER BY FIELD(TIPO_CONTENIDOS,1) DESC, CON.FEC_INSERT DESC
LIMIT 5;
Tiempo de la consulta:
0.0086641311645508Tiempo acumulado:0.33256435394287
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[208]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1448
AND FOTO = '269397310-10159572405432534-8009798584194411997-n1740482843.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00051784515380859Tiempo acumulado:0.33308219909668
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[209]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1447
AND FOTO = 'yumping-trends-2-1736863447.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00051093101501465Tiempo acumulado:0.33359313011169
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[210]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1444
AND FOTO = '151474557-2254915741310557-1934111757783398706-n1732112561.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00051403045654297Tiempo acumulado:0.33410716056824
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[211]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1443
AND FOTO = 'los-destinos-mas-top-para-viajar-en-el-puente-de-noviembre1729246718.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00051498413085938Tiempo acumulado:0.3346221446991
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[212]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1441
AND FOTO = 'aa1727956772.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00049281120300293Tiempo acumulado:0.3351149559021
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[213]: 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 = 12
AND SECI.FK_ID_IDIOMA_SI18N = 'en'
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PRE.ID_REGION_PRE
AND REI.IDIOMA = 'en'
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 = 32
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.14248299598694Tiempo acumulado:0.47759795188904
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[214]: SELECT *
FROM LO_EQUIPO_EDITORIAL EE
WHERE EE.ID_TROPIC = 12;
Tiempo de la consulta:
0.00049710273742676Tiempo acumulado:0.47809505462646