yu-front-06.localdomain (172.30.2.194:443)
prod.yumping.com
/contenido-Show.php
BBDD->Prod_Yumping_es_ES
AMBITO->es
AMBITO_AJAX->es
AMBITO_AJAX COOKIE->es
locale LO_CONFIG->es_ES
locale php->es_ES
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->es_ES
id_contenido->197
tpage->contenidoShow
rel_alternate->1
Total queries: 210
Tiempo total: 0.32836103439331
>0.1 and < 2 (1)
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[1]: SELECT CFG.ID, CFG.NAME, IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '', CFG.VALUE_PROD, CFG.VALUE) VALUE , CFG.AMBITO, CFG.VISIBLE_AJAX, CFG.TIME
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.AMBITO IN ('global', 'es')
ORDER BY CFG.NAME;
Tiempo de la consulta:
0.0068378448486328Tiempo acumulado:0.0068378448486328
(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.00054502487182617Tiempo acumulado:0.007382869720459
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[3]: SELECT *
FROM LO_CONFIG C
WHERE C.AMBITO = (
SELECT AMBITO
FROM LO_CONFIG C
WHERE CONCAT('/',C.VALUE) = ''
AND NAME = 'Request_url_partner'
LIMIT 1)
AND (NAME = 'subdomain' OR NAME = 'subdomain_lang');
Tiempo de la consulta:
0.00058102607727051Tiempo acumulado:0.0079638957977295
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[4]: 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 = 197
/*
AND (
fnGoogleUrl(C.TITULO) = 'garazi-sanchez'
OR fnGoogleUrl(CT.TITULO) = 'garazi-sanchez'
OR URL_CT = 'garazi-sanchez') */ 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 = 197
/*
AND (
fnGoogleUrl(C.TITULO) = 'garazi-sanchez'
OR fnGoogleUrl(CT.TITULO) = 'garazi-sanchez'
OR URL_CT = 'garazi-sanchez') */ 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 = 197
/*
AND (
fnGoogleUrl(C.TITULO) = 'garazi-sanchez'
OR fnGoogleUrl(CT.TITULO) = 'garazi-sanchez'
OR URL_CT = 'garazi-sanchez') */ 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 = 197
/*
AND (
fnGoogleUrl(C.TITULO) = 'garazi-sanchez'
OR fnGoogleUrl(CT.TITULO) = 'garazi-sanchez'
OR URL_CT = 'garazi-sanchez') */ 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 = 197
/*
AND (
fnGoogleUrl(C.TITULO) = 'garazi-sanchez'
OR fnGoogleUrl(CT.TITULO) = 'garazi-sanchez'
OR URL_CT = 'garazi-sanchez') */ 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 = 197
/*
AND (
fnGoogleUrl(C.TITULO) = 'garazi-sanchez'
OR fnGoogleUrl(CT.TITULO) = 'garazi-sanchez'
OR URL_CT = 'garazi-sanchez') */ ) AS CONTENIDO;
Tiempo de la consulta:
0.0061740875244141Tiempo acumulado:0.014137983322144
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[5]: 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')
ORDER BY CFG.NAME;
Tiempo de la consulta:
0.0064358711242676Tiempo acumulado:0.020573854446411
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[6]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'ambito_lang';
Tiempo de la consulta:
0.00047898292541504Tiempo acumulado:0.021052837371826
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[7]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'id_contenido';
Tiempo de la consulta:
0.00041913986206055Tiempo acumulado:0.021471977233887
(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 = 'tpage';
Tiempo de la consulta:
0.00039196014404297Tiempo acumulado:0.02186393737793
(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 = 'rel_alternate';
Tiempo de la consulta:
0.00035190582275391Tiempo acumulado:0.022215843200684
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[10]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es', 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.00050210952758789Tiempo acumulado:0.022717952728271
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[11]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004270076751709Tiempo acumulado:0.023144960403442
(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', 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.00042915344238281Tiempo acumulado:0.023574113845825
(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', 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.00043892860412598Tiempo acumulado:0.024013042449951
(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', 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.00041103363037109Tiempo acumulado:0.024424076080322
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[15]: SELECT 'es' 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 , CON.DESCRIPCION AS DESC_CORTA,'' as URL_CT ,CON.TITULO, CON.DESCRIPCION, CON.TEXTO, CON.GALERIA_DESC, CON.VIDEOS_TEXT_CON, CON.VIDEOS_DESC_CON
FROM Prod_Yumping_es_ES.LO_CONTENIDOS CON
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 = 1
WHERE CON.ID_CONTENIDO=197
AND CON.VALID=1
AND CATI.ID_TROPIC=1;
Tiempo de la consulta:
0.00189208984375Tiempo acumulado:0.026316165924072
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[16]: 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='29'
AND CAT.ID_CATEG=CATI.ID_CATEG
AND CON.ID_CONTENIDO='197'
AND CON.VALID=1
AND SECI.ID_SECTOR=SEC.ID_SECTOR
AND SECI.ID_TROPIC = 1
AND CATI.ID_TROPIC = 1
AND CON.ID_CATEG = CATI.ID_CATEG
AND CAT.ID_SECTOR=SEC.ID_SECTOR;
Tiempo de la consulta:
0.0018880367279053Tiempo acumulado:0.028204202651978
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[17]: 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.0041558742523193Tiempo acumulado:0.032360076904297
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[18]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es', 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.00047206878662109Tiempo acumulado:0.032832145690918
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[19]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043106079101562Tiempo acumulado:0.033263206481934
(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', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004119873046875Tiempo acumulado:0.033675193786621
(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', 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.0004119873046875Tiempo acumulado:0.034087181091309
(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', 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.00042605400085449Tiempo acumulado:0.034513235092163
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[23]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043201446533203Tiempo acumulado:0.034945249557495
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[24]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('pt_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041508674621582Tiempo acumulado:0.035360336303711
(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_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042104721069336Tiempo acumulado:0.035781383514404
(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_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('pt_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041294097900391Tiempo acumulado:0.036194324493408
(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_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('pt_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041508674621582Tiempo acumulado:0.036609411239624
(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 = 'mx_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('mx_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041508674621582Tiempo acumulado:0.03702449798584
(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 = 'mx_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('mx_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043606758117676Tiempo acumulado:0.037460565567017
(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 = 'mx_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('mx_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004270076751709Tiempo acumulado:0.037887573242188
(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 = 'mx_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('mx_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043201446533203Tiempo acumulado:0.03831958770752
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[32]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('mx_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041103363037109Tiempo acumulado:0.038730621337891
(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_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00044989585876465Tiempo acumulado:0.039180517196655
(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_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('gb_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042891502380371Tiempo acumulado:0.039609432220459
(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 = 'gb_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('gb_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004429817199707Tiempo acumulado:0.04005241394043
(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 = 'gb_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('gb_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00048685073852539Tiempo acumulado:0.040539264678955
(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 = 'gb_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('gb_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043988227844238Tiempo acumulado:0.040979146957397
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[38]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('it_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043201446533203Tiempo acumulado:0.041411161422729
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[39]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('it_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045084953308105Tiempo acumulado:0.041862010955811
(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_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('it_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042009353637695Tiempo acumulado:0.042282104492188
(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_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('it_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041890144348145Tiempo acumulado:0.042701005935669
(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_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('it_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042486190795898Tiempo acumulado:0.043125867843628
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[43]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('fr_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046300888061523Tiempo acumulado:0.043588876724243
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[44]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('fr_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041699409484863Tiempo acumulado:0.044005870819092
(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_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('fr_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041103363037109Tiempo acumulado:0.044416904449463
(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_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('fr_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041604042053223Tiempo acumulado:0.044832944869995
(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_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('fr_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043106079101562Tiempo acumulado:0.045264005661011
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[48]: 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 = '1'
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 = '81'
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_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 = '51'
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_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 = '21'
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_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 = '31'
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 = '41'
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.021044015884399Tiempo acumulado:0.06630802154541
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[49]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 197
AND FOTO = 'Garazi4.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0012600421905518Tiempo acumulado:0.067568063735962
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[50]: SELECT OLD_URL, NEW_URL
FROM LO_URL_301 U
WHERE U.OLD_URL = '/noticias-aventura/garazi-sanchez--c197';
Tiempo de la consulta:
0.00076007843017578Tiempo acumulado:0.068328142166138
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[51]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049996376037598Tiempo acumulado:0.068828105926514
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[52]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_multidioma'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043296813964844Tiempo acumulado:0.069261074066162
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[53]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042891502380371Tiempo acumulado:0.069689989089966
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[54]: SELECT C.* , CT.DESCRIPCION AS DESC_CORTA,URL_CT ,CT.TITULO, CT.DESCRIPCION, CT.TEXTO, CT.GALERIA_DESC, CT.VIDEOS_TEXT_CON, CT.VIDEOS_DESC_CON
FROM Prod_Yumping_es_ES.LO_CONTENIDOS C
INNER JOIN Prod_Yumping_es_ES.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = C.ID_CONTENIDO
AND LANGUAGE = 'en'
WHERE C.ID_CONTENIDO = 197;
Tiempo de la consulta:
0.00074386596679688Tiempo acumulado:0.070433855056763
(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_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004570484161377Tiempo acumulado:0.0708909034729
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[56]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_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.00043201446533203Tiempo acumulado:0.071322917938232
(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_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.00042510032653809Tiempo acumulado:0.071748018264771
(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_con_traducciones'
AND CFG.AMBITO IN ('es_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004279613494873Tiempo acumulado:0.072175979614258
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[59]: 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 = 197;
Tiempo de la consulta:
0.00058794021606445Tiempo acumulado:0.072763919830322
(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 = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('es_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043892860412598Tiempo acumulado:0.073202848434448
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[61]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_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.00043797492980957Tiempo acumulado:0.073640823364258
(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_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.00042200088500977Tiempo acumulado:0.074062824249268
(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_con_traducciones'
AND CFG.AMBITO IN ('es_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041913986206055Tiempo acumulado:0.074481964111328
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[64]: 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 = 197;
Tiempo de la consulta:
0.00059890747070312Tiempo acumulado:0.075080871582031
(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 = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('es_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046682357788086Tiempo acumulado:0.075547695159912
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[66]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_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.00043106079101562Tiempo acumulado:0.075978755950928
(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_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.00043201446533203Tiempo acumulado:0.07641077041626
(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_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.00041508674621582Tiempo acumulado:0.076825857162476
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[69]: 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 = 197;
Tiempo de la consulta:
0.00057196617126465Tiempo acumulado:0.07739782333374
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[70]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('es_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043797492980957Tiempo acumulado:0.07783579826355
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[71]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_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.00042581558227539Tiempo acumulado:0.078261613845825
(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 = 'Request_con_multidioma'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042819976806641Tiempo acumulado:0.078689813613892
(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_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.00042819976806641Tiempo acumulado:0.079118013381958
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[74]: 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 = 197;
Tiempo de la consulta:
0.00056099891662598Tiempo acumulado:0.079679012298584
(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_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.00043797492980957Tiempo acumulado:0.080116987228394
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[76]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('es_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042510032653809Tiempo acumulado:0.080542087554932
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[77]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_multidioma'
AND CFG.AMBITO IN ('es_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004119873046875Tiempo acumulado:0.080954074859619
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[78]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('es_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042200088500977Tiempo acumulado:0.081376075744629
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[79]: 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 = 197;
Tiempo de la consulta:
0.00061297416687012Tiempo acumulado:0.081989049911499
(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 = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('es_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045490264892578Tiempo acumulado:0.082443952560425
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[81]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('es_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004420280456543Tiempo acumulado:0.082885980606079
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[82]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_multidioma'
AND CFG.AMBITO IN ('es_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004270076751709Tiempo acumulado:0.08331298828125
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[83]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('es_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042009353637695Tiempo acumulado:0.083733081817627
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[84]: 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 = 197;
Tiempo de la consulta:
0.00055694580078125Tiempo acumulado:0.084290027618408
(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 = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('es_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00044798851013184Tiempo acumulado:0.08473801612854
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[86]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043010711669922Tiempo acumulado:0.085168123245239
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[87]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00040888786315918Tiempo acumulado:0.085577011108398
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[88]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00040698051452637Tiempo acumulado:0.085983991622925
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[89]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041699409484863Tiempo acumulado:0.086400985717773
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[90]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('es_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004270076751709Tiempo acumulado:0.086827993392944
(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_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.00041103363037109Tiempo acumulado:0.087239027023315
(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_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.0004122257232666Tiempo acumulado:0.087651252746582
(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_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.00040507316589355Tiempo acumulado:0.088056325912476
(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.00047707557678223Tiempo acumulado:0.088533401489258
(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 = 'subdomain_lang'
AND CFG.AMBITO IN ('es_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004420280456543Tiempo acumulado:0.088975429534912
(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_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.00043606758117676Tiempo acumulado:0.089411497116089
(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_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.00045514106750488Tiempo acumulado:0.089866638183594
(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_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.00043487548828125Tiempo acumulado:0.090301513671875
(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.00044798851013184Tiempo acumulado:0.090749502182007
(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 = 'subdomain_lang'
AND CFG.AMBITO IN ('es_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046300888061523Tiempo acumulado:0.091212511062622
(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_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.00060915946960449Tiempo acumulado:0.091821670532227
(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_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.00042819976806641Tiempo acumulado:0.092249870300293
(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_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.00042104721069336Tiempo acumulado:0.092670917510986
(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_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.00040411949157715Tiempo acumulado:0.093075037002563
(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_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.00041580200195312Tiempo acumulado:0.093490839004517
(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.00042104721069336Tiempo acumulado:0.09391188621521
(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.00040817260742188Tiempo acumulado:0.094320058822632
(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 = 'Request_href_lang'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00040006637573242Tiempo acumulado:0.094720125198364
(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_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.00044512748718262Tiempo acumulado:0.095165252685547
(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_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('es_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043106079101562Tiempo acumulado:0.095596313476562
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[111]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041699409484863Tiempo acumulado:0.096013307571411
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[112]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00040483474731445Tiempo acumulado:0.096418142318726
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[113]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041413307189941Tiempo acumulado:0.096832275390625
(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.00040817260742188Tiempo acumulado:0.097240447998047
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[115]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('es_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043487548828125Tiempo acumulado:0.097675323486328
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[116]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042510032653809Tiempo acumulado:0.098100423812866
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[117]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00040817260742188Tiempo acumulado:0.098508596420288
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[118]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('es_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041294097900391Tiempo acumulado:0.098921537399292
(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.00043392181396484Tiempo acumulado:0.099355459213257
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[120]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('es_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043296813964844Tiempo acumulado:0.099788427352905
(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', 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.00043201446533203Tiempo acumulado:0.10022044181824
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[122]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 197
AND FOTO = 'Garazi.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0005791187286377Tiempo acumulado:0.10079956054688
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[123]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 197
AND FOTO = 'Garazi2.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00049901008605957Tiempo acumulado:0.10129857063293
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[124]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 197
AND FOTO = 'Garazi3.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00052285194396973Tiempo acumulado:0.1018214225769
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[125]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 197
AND FOTO = 'Garazi4.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0004889965057373Tiempo acumulado:0.10231041908264
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[126]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.0003349781036377Tiempo acumulado:0.10264539718628
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[127]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.00033307075500488Tiempo acumulado:0.10297846794128
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[128]: 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='1'
AND CON.ID_CONTENIDO='197'
LIMIT 1;
Tiempo de la consulta:
0.00062394142150879Tiempo acumulado:0.10360240936279
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[129]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 197
AND FOTO = 'Garazi.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0005030632019043Tiempo acumulado:0.1041054725647
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[130]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 197
AND FOTO = 'Garazi2.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00050711631774902Tiempo acumulado:0.10461258888245
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[131]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 197
AND FOTO = 'Garazi3.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00052189826965332Tiempo acumulado:0.1051344871521
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[132]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 197
AND FOTO = 'Garazi4.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00049781799316406Tiempo acumulado:0.10563230514526
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[133]: 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 = 1
WHERE C.TITULO LIKE '10 cosas que hacer en%'
AND C.ID_CONTENIDO = 197;
Tiempo de la consulta:
0.00053501129150391Tiempo acumulado:0.10616731643677
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[134]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es', 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.00049495697021484Tiempo acumulado:0.10666227340698
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[135]: 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_id_tropic_trad'
AND CFG.AMBITO IN ('es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0010249614715576Tiempo acumulado:0.10768723487854
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[136]: 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.00045299530029297Tiempo acumulado:0.10814023017883
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[137]: 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.00043606758117676Tiempo acumulado:0.10857629776001
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[138]: 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.00043988227844238Tiempo acumulado:0.10901618003845
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[139]: 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
, CON.DESCRIPCION AS DESC_CORTA,'' as URL_CT ,CON.TITULO, CON.DESCRIPCION, CON.TEXTO, CON.GALERIA_DESC, CON.VIDEOS_TEXT_CON, CON.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
WHERE
(CON.GALERIA IS NOT NULL
AND CON.GALERIA<>'')
AND CON.ID_CATEG = 29
AND CON.VALID = 1
AND CON.ID_CONTENIDO !=197
ORDER BY RAND()
LIMIT 4;
Tiempo de la consulta:
0.0017390251159668Tiempo acumulado:0.11075520515442
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[140]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 286
AND FOTO = 'escuela2.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00048494338989258Tiempo acumulado:0.11124014854431
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[141]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 956
AND FOTO = 'Surfera sin escarpines ni guantes.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00049400329589844Tiempo acumulado:0.11173415184021
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[142]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 837
AND FOTO = 'Puma Time2.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0012798309326172Tiempo acumulado:0.11301398277283
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[143]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 278
AND FOTO = 'Gony Zubizarreta.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0016288757324219Tiempo acumulado:0.11464285850525
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[144]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es', 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.00051212310791016Tiempo acumulado:0.11515498161316
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[145]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00044393539428711Tiempo acumulado:0.11559891700745
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[146]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043010711669922Tiempo acumulado:0.11602902412415
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[147]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = '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.00065708160400391Tiempo acumulado:0.11668610572815
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[148]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es', 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.00043392181396484Tiempo acumulado:0.11712002754211
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[149]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042390823364258Tiempo acumulado:0.11754393577576
(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 = 'pt_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('pt_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00063991546630859Tiempo acumulado:0.11818385124207
(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 = 'pt_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043320655822754Tiempo acumulado:0.11861705780029
(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 = 'pt_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('pt_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004429817199707Tiempo acumulado:0.11906003952026
(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 = 'pt_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('pt_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043392181396484Tiempo acumulado:0.11949396133423
(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 = 'mx_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('mx_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00136399269104Tiempo acumulado:0.12085795402527
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[155]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('mx_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045609474182129Tiempo acumulado:0.12131404876709
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[156]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('mx_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043082237243652Tiempo acumulado:0.12174487113953
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[157]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('mx_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042414665222168Tiempo acumulado:0.12216901779175
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[158]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('mx_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042986869812012Tiempo acumulado:0.12259888648987
(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_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043106079101562Tiempo acumulado:0.12302994728088
(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_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('gb_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00044798851013184Tiempo acumulado:0.12347793579102
(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_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('gb_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042581558227539Tiempo acumulado:0.12390375137329
(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_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('gb_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043320655822754Tiempo acumulado:0.12433695793152
(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_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('gb_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043416023254395Tiempo acumulado:0.12477111816406
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[164]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('it_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00056290626525879Tiempo acumulado:0.12533402442932
(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 = 'it_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('it_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046896934509277Tiempo acumulado:0.12580299377441
(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 = 'it_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('it_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047516822814941Tiempo acumulado:0.12627816200256
(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 = 'it_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('it_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042200088500977Tiempo acumulado:0.12670016288757
(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 = 'it_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('it_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043106079101562Tiempo acumulado:0.12713122367859
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[169]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('fr_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042510032653809Tiempo acumulado:0.12755632400513
(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 = 'fr_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('fr_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00044798851013184Tiempo acumulado:0.12800431251526
(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 = 'fr_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('fr_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042605400085449Tiempo acumulado:0.12843036651611
(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 = 'fr_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('fr_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004429817199707Tiempo acumulado:0.12887334823608
(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 = 'fr_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('fr_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042915344238281Tiempo acumulado:0.12930250167847
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[174]: 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 = '1'
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 = '81'
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_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 = '51'
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_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 = '21'
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_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 = '31'
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 = '41'
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.016829013824463Tiempo acumulado:0.14613151550293
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[175]: SELECT URL_PRE,TITULO_PRE,DESCRIPCION_PRE,INCLUYE_PRE,ALOJAMIENTO_TEXT_PRE,TRANSPORTE_TEXT_PRE,GALERIA_DESC_PRE,HORARIO_PRE, DURACION_PRE, 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_SECTORES PS ON PRE.ID_PRECIO=PS.ID_PRECIO_PS
AND ID_ACTIVIDAD_PS='29'
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=1
AND SECI.FK_ID_IDIOMA_SI18N='es'
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PRE.ID_REGION_PRE
AND REI.IDIOMA='es'
INNER JOIN LO_POBLACION_ES PO ON PO.ID_POBLACION = PRE.ID_POBLACION_PRE
AND PO.IDIOMA='es'
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.01640510559082Tiempo acumulado:0.16253662109375
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[176]: SELECT URL_PRE, URL_PRE,TITULO_PRE,DESCRIPCION_PRE,INCLUYE_PRE,ALOJAMIENTO_TEXT_PRE,TRANSPORTE_TEXT_PRE,GALERIA_DESC_PRE,HORARIO_PRE, DURACION_PRE, ID_PRECIO, FK_ID_PAIS_PRE
FROM LO_PRECIOS PRE
WHERE PRE.ID_PRECIO = 69157;
Tiempo de la consulta:
0.00044822692871094Tiempo acumulado:0.16298484802246
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[177]: 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 = 69157;
Tiempo de la consulta:
0.0009300708770752Tiempo acumulado:0.16391491889954
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[178]: SELECT PRE.URL_PRE, URL_PRE,TITULO_PRE,DESCRIPCION_PRE,INCLUYE_PRE,ALOJAMIENTO_TEXT_PRE,TRANSPORTE_TEXT_PRE,GALERIA_DESC_PRE,HORARIO_PRE, DURACION_PRE, 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 ='es'
AND SECI.ID_TROPIC = 1
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PRE.ID_REGION_PRE
AND REI.IDIOMA ='es'
INNER JOIN LO_POBLACION_ES POI ON POI.ID_POBLACION = PRE.ID_POBLACION_PRE
AND POI.IDIOMA ='es'
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
WHERE REI.IDIOMA='es'
AND EMP.VALID=1
AND VALID_PRE IN(1,4,3)
AND PRE.ID_PRECIO='69153'
LIMIT 1;
Tiempo de la consulta:
0.0070497989654541Tiempo acumulado:0.17096471786499
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[179]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 69157
AND VALID = 1;
Tiempo de la consulta:
0.0033318996429443Tiempo acumulado:0.17429661750793
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[180]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 69157
AND FOTO = 'p-69157-1236_16194361102715.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00049996376037598Tiempo acumulado:0.17479658126831
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[181]: SELECT ID_PRECIO, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_PRECIO =69157;
Tiempo de la consulta:
0.00089597702026367Tiempo acumulado:0.17569255828857
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[182]: SELECT URL_PRE, URL_PRE,TITULO_PRE,DESCRIPCION_PRE,INCLUYE_PRE,ALOJAMIENTO_TEXT_PRE,TRANSPORTE_TEXT_PRE,GALERIA_DESC_PRE,HORARIO_PRE, DURACION_PRE, ID_PRECIO, FK_ID_PAIS_PRE
FROM LO_PRECIOS PRE
WHERE PRE.ID_PRECIO = 21282;
Tiempo de la consulta:
0.00045418739318848Tiempo acumulado:0.17614674568176
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[183]: SELECT ID_PRECIO_PADRE
FROM LO_PRECIOS_ASIGNACION PA
INNER JOIN LO_PRECIOS PRE ON PRE.ID_PRECIO = PA.ID_PRECIO_PADRE
AND PRE.VALID_PRE = 4
WHERE PA.ID_PRECIO = 21282;
Tiempo de la consulta:
0.00045299530029297Tiempo acumulado:0.17659974098206
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[184]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 21282
AND VALID = 1;
Tiempo de la consulta:
0.0035459995269775Tiempo acumulado:0.18014574050903
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[185]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 21282
AND FOTO = 'p-21282-antes-de-entrar-al-agua_14901027716096.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00049495697021484Tiempo acumulado:0.18064069747925
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[186]: SELECT ID_PRECIO, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_PRECIO =21282;
Tiempo de la consulta:
0.00033903121948242Tiempo acumulado:0.18097972869873
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[187]: SELECT URL_PRE, URL_PRE,TITULO_PRE,DESCRIPCION_PRE,INCLUYE_PRE,ALOJAMIENTO_TEXT_PRE,TRANSPORTE_TEXT_PRE,GALERIA_DESC_PRE,HORARIO_PRE, DURACION_PRE, ID_PRECIO, FK_ID_PAIS_PRE
FROM LO_PRECIOS PRE
WHERE PRE.ID_PRECIO = 42779;
Tiempo de la consulta:
0.0003960132598877Tiempo acumulado:0.18137574195862
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[188]: SELECT ID_PRECIO_PADRE
FROM LO_PRECIOS_ASIGNACION PA
INNER JOIN LO_PRECIOS PRE ON PRE.ID_PRECIO = PA.ID_PRECIO_PADRE
AND PRE.VALID_PRE = 4
WHERE PA.ID_PRECIO = 42779;
Tiempo de la consulta:
0.00047993659973145Tiempo acumulado:0.18185567855835
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[189]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 42779
AND VALID = 1;
Tiempo de la consulta:
0.0015201568603516Tiempo acumulado:0.1833758354187
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[190]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 42779
AND FOTO = 'p-42779-surf-para-ninos-en-zarautz1648115751_16481157884991.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00050687789916992Tiempo acumulado:0.18388271331787
(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 =42779;
Tiempo de la consulta:
0.00035405158996582Tiempo acumulado:0.18423676490784
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[192]: SELECT URL_PRE, URL_PRE,TITULO_PRE,DESCRIPCION_PRE,INCLUYE_PRE,ALOJAMIENTO_TEXT_PRE,TRANSPORTE_TEXT_PRE,GALERIA_DESC_PRE,HORARIO_PRE, DURACION_PRE, ID_PRECIO, FK_ID_PAIS_PRE
FROM LO_PRECIOS PRE
WHERE PRE.ID_PRECIO = 53390;
Tiempo de la consulta:
0.00038790702819824Tiempo acumulado:0.18462467193604
(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 = 53390;
Tiempo de la consulta:
0.00049591064453125Tiempo acumulado:0.18512058258057
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[194]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 53390
AND VALID = 1;
Tiempo de la consulta:
0.0010509490966797Tiempo acumulado:0.18617153167725
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[195]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 53390
AND FOTO = 'p-53390-disfruta-del-surf_15081387671568.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00052404403686523Tiempo acumulado:0.18669557571411
(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 =53390;
Tiempo de la consulta:
0.00074291229248047Tiempo acumulado:0.18743848800659
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[197]: SELECT URL_PRE, URL_PRE,TITULO_PRE,DESCRIPCION_PRE,INCLUYE_PRE,ALOJAMIENTO_TEXT_PRE,TRANSPORTE_TEXT_PRE,GALERIA_DESC_PRE,HORARIO_PRE, DURACION_PRE, ID_PRECIO, FK_ID_PAIS_PRE
FROM LO_PRECIOS PRE
WHERE PRE.ID_PRECIO = 20840;
Tiempo de la consulta:
0.00043106079101562Tiempo acumulado:0.18786954879761
(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 = 20840;
Tiempo de la consulta:
0.00038599967956543Tiempo acumulado:0.18825554847717
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[199]: SELECT PRE.URL_PRE, URL_PRE,TITULO_PRE,DESCRIPCION_PRE,INCLUYE_PRE,ALOJAMIENTO_TEXT_PRE,TRANSPORTE_TEXT_PRE,GALERIA_DESC_PRE,HORARIO_PRE, DURACION_PRE, 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 ='es'
AND SECI.ID_TROPIC = 1
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PRE.ID_REGION_PRE
AND REI.IDIOMA ='es'
INNER JOIN LO_POBLACION_ES POI ON POI.ID_POBLACION = PRE.ID_POBLACION_PRE
AND POI.IDIOMA ='es'
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
WHERE REI.IDIOMA='es'
AND EMP.VALID=1
AND VALID_PRE IN(1,4,3)
AND PRE.ID_PRECIO='34577'
LIMIT 1;
Tiempo de la consulta:
0.003201961517334Tiempo acumulado:0.19145750999451
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[200]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 20840
AND VALID = 1;
Tiempo de la consulta:
0.0036430358886719Tiempo acumulado:0.19510054588318
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[201]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 20840
AND FOTO = 'p-20840-clases-grupales-de-surf1681214697_16812147216352.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00050687789916992Tiempo acumulado:0.19560742378235
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[202]: SELECT ID_PRECIO, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_PRECIO =20840;
Tiempo de la consulta:
0.00034403800964355Tiempo acumulado:0.19595146179199
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[203]: 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, CON.DESCRIPCION AS DESC_CORTA,'' as URL_CT ,CON.TITULO, CON.DESCRIPCION, CON.TEXTO, CON.GALERIA_DESC, CON.VIDEOS_TEXT_CON, CON.VIDEOS_DESC_CON
FROM LO_CONTENIDOS CON
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 ('197')
ORDER BY FIELD(TIPO_CONTENIDOS,1) DESC, CON.FEC_INSERT DESC
LIMIT 5;
Tiempo de la consulta:
0.0049929618835449Tiempo acumulado:0.20094442367554
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[204]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1448
AND FOTO = '269397310-10159572405432534-8009798584194411997-n1740482843.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00056600570678711Tiempo acumulado:0.20151042938232
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[205]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1447
AND FOTO = 'yumping-trends-2-1736863447.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00048589706420898Tiempo acumulado:0.20199632644653
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[206]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1444
AND FOTO = '151474557-2254915741310557-1934111757783398706-n1732112561.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00049686431884766Tiempo acumulado:0.20249319076538
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[207]: 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.00049996376037598Tiempo acumulado:0.20299315452576
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[208]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1441
AND FOTO = 'aa1727956772.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00051999092102051Tiempo acumulado:0.20351314544678
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[209]: 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 = 1
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PRE.ID_REGION_PRE
AND REI.IDIOMA = 'es'
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 = 29
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.12406086921692Tiempo acumulado:0.3275740146637
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[210]: SELECT *
FROM LO_EQUIPO_EDITORIAL EE
WHERE EE.ID_TROPIC = 1;
Tiempo de la consulta:
0.00078701972961426Tiempo acumulado:0.32836103439331