yu-front-06.localdomain (172.30.2.194:443)
prod.yumping.com
/contenido-Show.php
BBDD->Prod_Yumping_co_UK
AMBITO->gb_de
AMBITO_AJAX->gb_de
AMBITO_AJAX COOKIE->
locale LO_CONFIG->de_GB
locale php->de_GB
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->de
id_contenido->1753
tpage->contenidoShow
rel_alternate->1
Total queries: 209
Tiempo total: 1.4377479553223
>0.1 and < 2 (2)
(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_de')
ORDER BY CFG.NAME;
Tiempo de la consulta:
0.015324115753174Tiempo acumulado:0.015324115753174
(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.0067038536071777Tiempo acumulado:0.022027969360352
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[3]: SELECT ID_PAIS
FROM ( SELECT 28 AS ID_PAIS
FROM Prod_Yumping_es_ES.LO_CONTENIDOS C
LEFT JOIN Prod_Yumping_es_ES.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = C.ID_CONTENIDO
WHERE C.ID_CONTENIDO = 1753
/*
AND (
fnGoogleUrl(C.TITULO) = 'was-ist-eine-tyrolische-traverse'
OR fnGoogleUrl(CT.TITULO) = 'was-ist-eine-tyrolische-traverse'
OR URL_CT = 'was-ist-eine-tyrolische-traverse') */ 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 = 1753
/*
AND (
fnGoogleUrl(C.TITULO) = 'was-ist-eine-tyrolische-traverse'
OR fnGoogleUrl(CT.TITULO) = 'was-ist-eine-tyrolische-traverse'
OR URL_CT = 'was-ist-eine-tyrolische-traverse') */ 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 = 1753
/*
AND (
fnGoogleUrl(C.TITULO) = 'was-ist-eine-tyrolische-traverse'
OR fnGoogleUrl(CT.TITULO) = 'was-ist-eine-tyrolische-traverse'
OR URL_CT = 'was-ist-eine-tyrolische-traverse') */ 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 = 1753
/*
AND (
fnGoogleUrl(C.TITULO) = 'was-ist-eine-tyrolische-traverse'
OR fnGoogleUrl(CT.TITULO) = 'was-ist-eine-tyrolische-traverse'
OR URL_CT = 'was-ist-eine-tyrolische-traverse') */ 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 = 1753
/*
AND (
fnGoogleUrl(C.TITULO) = 'was-ist-eine-tyrolische-traverse'
OR fnGoogleUrl(CT.TITULO) = 'was-ist-eine-tyrolische-traverse'
OR URL_CT = 'was-ist-eine-tyrolische-traverse') */ 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 = 1753
/*
AND (
fnGoogleUrl(C.TITULO) = 'was-ist-eine-tyrolische-traverse'
OR fnGoogleUrl(CT.TITULO) = 'was-ist-eine-tyrolische-traverse'
OR URL_CT = 'was-ist-eine-tyrolische-traverse') */ ) AS CONTENIDO;
Tiempo de la consulta:
0.03221321105957Tiempo acumulado:0.054241180419922
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[4]: SELECT CFG.ID, CFG.NAME, IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '', CFG.VALUE_PROD, CFG.VALUE) VALUE , CFG.AMBITO, CFG.VISIBLE_AJAX, CFG.TIME
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.AMBITO IN ('global', 'gb_de')
ORDER BY CFG.NAME;
Tiempo de la consulta:
0.019054889678955Tiempo acumulado:0.073296070098877
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[5]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.0027210712432861Tiempo acumulado:0.076017141342163
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[6]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.00093793869018555Tiempo acumulado:0.076955080032349
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[7]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'ambito_lang';
Tiempo de la consulta:
0.0008399486541748Tiempo acumulado:0.077795028686523
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[8]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'id_contenido';
Tiempo de la consulta:
0.00069785118103027Tiempo acumulado:0.078492879867554
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[9]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'tpage';
Tiempo de la consulta:
0.00040197372436523Tiempo acumulado:0.078894853591919
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[10]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'rel_alternate';
Tiempo de la consulta:
0.00078082084655762Tiempo acumulado:0.079675674438477
(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 = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00052690505981445Tiempo acumulado:0.080202579498291
(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 = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004889965057373Tiempo acumulado:0.080691576004028
(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 = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0036079883575439Tiempo acumulado:0.084299564361572
(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 = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0051591396331787Tiempo acumulado:0.089458703994751
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[15]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_multidioma'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0092179775238037Tiempo acumulado:0.098676681518555
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[16]: SELECT 'gb_de' AS AMBIO, CON.FK_ID_EMPRESA_CON, CON.ID_CONTENIDO,CON.TIPO_CONTENIDOS, CON.TITULO,
CON.DESCRIPCION, CON.TEXTO, CON.OPERATOR_INSERT,
DATE_FORMAT(CON.FEC_INSERT,'%d/%m/%y') AS FEC_INSERT, CON.GALERIA, CON.GALERIA_DESC, CON.FOTOPRINCIPAL,
AD.MAIL, CAT.ID_SECTOR,VIDEOS_CODE_CON,CON.VIDEOS_TEXT_CON,CON.VIDEOS_DESC_CON,CAT.ID_GRUPO_CAT/*,CON.NOMBRE_FIRMA_CON, NOMBRE_FIRMA_CON,PUESTO_FIRMA_CON,ENLACE_FIRMA_CON,FOTO_FIRMA_CON*/,AD.AVATAR,AD.NOMBRE,CAT.ID_CATEG
, CA.JOB, CA.AVATAR, CA.URL, IF(CA.NOMBRE IS NOT NULL, CA.NOMBRE, AD.NOMBRE) AS NOMBRE, CA.ID AS ID_AUTOR,
DATE_FORMAT(CON.FEC_INSERT, '%d') DAY_INSERT,
DATE_FORMAT(CON.FEC_INSERT, '%m') MONTH_INSERT,
DATE_FORMAT(CON.FEC_INSERT, '%Y') YEAR_INSERT,
DATE_FORMAT(CON.FEC_INSERT, '%H:%i') HORA_INSERT,
DATE_FORMAT(CON.FEC_ULT_MODIF, '%d') DAY_MOD,
DATE_FORMAT(CON.FEC_ULT_MODIF, '%m') MONTH_MOD,
DATE_FORMAT(CON.FEC_ULT_MODIF, '%Y') YEAR_MOD,
DATE_FORMAT(CON.FEC_ULT_MODIF, '%H:%i') HORA_MOD, DATE_FORMAT(CON.FEC_INSERT, '%Y-%m-%dT%H:%i') IN_GOOGLE, DATE_FORMAT(CON.FEC_ULT_MODIF, '%Y-%m-%dT%H:%i') MOD_GOOGLE , CT.DESCRIPCION AS DESC_CORTA,URL_CT ,CT.TITULO, CT.DESCRIPCION, CT.TEXTO, CT.GALERIA_DESC, CT.VIDEOS_TEXT_CON, CT.VIDEOS_DESC_CON
FROM Prod_Yumping_co_UK.LO_CONTENIDOS CON
INNER JOIN Prod_Yumping_co_UK.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = CON.ID_CONTENIDO
AND LANGUAGE = 'de'
INNER JOIN Prod_Yumping_co_UK.LO_CONTENIDOS_CATEG CAT ON CON.ID_CATEG=CAT.ID_CATEG
INNER JOIN Prod_Yumping_co_UK.LO_CONTENIDOS_CATEG_I18N CATI ON CON.ID_CATEG=CATI.ID_CATEG
AND CAT.ID_CATEG=CATI.ID_CATEG
INNER JOIN Prod_Yumping_co_UK.LO_ADMIN_USERS AD ON AD.LOGIN=CON.OPERATOR_INSERT
LEFT JOIN Prod_Yumping_co_UK.LO_CONTENIDO_AUTORES CA ON CA.ID_ADMIN = AD.ID_ADMIN
AND CA.ID_TROPIC = 27
WHERE CON.ID_CONTENIDO=1753
AND CON.VALID=1
AND CATI.ID_TROPIC=27;
Tiempo de la consulta:
0.0096209049224854Tiempo acumulado:0.10829758644104
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[17]: SELECT DISTINCT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO
FROM LO_SECTORES SEC, LO_SECTORES_I18N SECI, LO_CONTENIDOS CON, LO_CONTENIDOS_CATEG CAT, LO_CONTENIDOS_CATEG_I18N CATI
WHERE SEC.ID_SECTOR='24'
AND CAT.ID_CATEG=CATI.ID_CATEG
AND CON.ID_CONTENIDO='1753'
AND CON.VALID=1
AND SECI.ID_SECTOR=SEC.ID_SECTOR
AND SECI.ID_TROPIC = 27
AND CATI.ID_TROPIC = 2
AND CON.ID_CATEG = CATI.ID_CATEG
AND CAT.ID_SECTOR=SEC.ID_SECTOR;
Tiempo de la consulta:
0.0025568008422852Tiempo acumulado:0.11085438728333
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[18]: SELECT COMUS.ID_USER,COMUS.ROL, COMUS.AVATAR,COMUS.NOMBRE, CONTOP.COMENTARIO_CONTOP,
CONT.TITULO,CONT.ID_CONTENIDO,
DATE_FORMAT(FECHA_CONTOP,'%d/%m/%Y %H:%i') as FECHA_CONTOP
FROM LO_CONTENIDOS_OPINIONES CONTOP
INNER JOIN LO_CONTENIDOS CONT ON CONTOP.FK_ID_CONTENIDO=CONT.ID_CONTENIDO
AND CONT.ID_TROPIC='2'
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.025295972824097Tiempo acumulado:0.13615036010742
(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_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.00056791305541992Tiempo acumulado:0.13671827316284
(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_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('es_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0017409324645996Tiempo acumulado:0.13845920562744
(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_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('es_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0058248043060303Tiempo acumulado:0.14428400993347
(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_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.00063586235046387Tiempo acumulado:0.14491987228394
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[23]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_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.0027799606323242Tiempo acumulado:0.14769983291626
(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_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00065803527832031Tiempo acumulado:0.14835786819458
(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_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00074505805969238Tiempo acumulado:0.14910292625427
(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_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0040068626403809Tiempo acumulado:0.15310978889465
(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_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0018618106842041Tiempo acumulado:0.15497159957886
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[28]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00073099136352539Tiempo acumulado:0.15570259094238
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[29]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00061798095703125Tiempo acumulado:0.15632057189941
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[30]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0040450096130371Tiempo acumulado:0.16036558151245
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[31]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.003587007522583Tiempo acumulado:0.16395258903503
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[32]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0041768550872803Tiempo acumulado:0.16812944412231
(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_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0041999816894531Tiempo acumulado:0.17232942581177
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[34]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('mx_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00062108039855957Tiempo acumulado:0.17295050621033
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[35]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('mx_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0042431354522705Tiempo acumulado:0.1771936416626
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[36]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('mx_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0098769664764404Tiempo acumulado:0.18707060813904
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[37]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('mx_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0027258396148682Tiempo acumulado:0.18979644775391
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[38]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('mx_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00089311599731445Tiempo acumulado:0.19068956375122
(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_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('it_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00053215026855469Tiempo acumulado:0.19122171401978
(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_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('it_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00070309638977051Tiempo acumulado:0.19192481040955
(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_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('it_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0005791187286377Tiempo acumulado:0.19250392913818
(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_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('it_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0046350955963135Tiempo acumulado:0.1971390247345
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[43]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('it_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0030300617218018Tiempo acumulado:0.2001690864563
(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_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('fr_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0016210079193115Tiempo acumulado:0.20179009437561
(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_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('fr_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050783157348633Tiempo acumulado:0.2022979259491
(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_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('fr_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0007178783416748Tiempo acumulado:0.20301580429077
(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_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('fr_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049209594726562Tiempo acumulado:0.20350790023804
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[48]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('fr_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0011861324310303Tiempo acumulado:0.20469403266907
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[49]: SELECT SUM(TOTAL) AS TOTAL,TIPO_CONTENIDOS,ID_GRUPO_CAT, DESC_GRUPO, URL
FROM (SELECT COUNT(*) AS TOTAL,CON.TIPO_CONTENIDOS,CATEG.ID_GRUPO_CAT, CG.DESC_GRUPO, CG.URL
FROM Prod_Yumping_es_ES.LO_CONTENIDOS CON
INNER JOIN Prod_Yumping_es_ES.LO_ADMIN_USERS AD ON CON.OPERATOR_INSERT=AD.LOGIN
INNER JOIN Prod_Yumping_es_ES.LO_CONTENIDOS_CATEG CATEG ON CON.ID_CATEG=CATEG.ID_CATEG
INNER JOIN Prod_Yumping_es_ES.LO_CONTENIDOS_GRUPOS CG ON CG.ID_GRUPO_CAT = CATEG.ID_GRUPO_CAT
AND CG.ID_TROPIC = '17'
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 = '87'
WHERE (CON.GALERIA IS NOT NULL
AND CON.GALERIA<>'')
AND CON.ID_TROPIC='8'
AND CON.VALID=1
GROUP BY TIPO_CONTENIDOS,ID_GRUPO_CAT
UNION ALL SELECT COUNT(*) AS TOTAL,CON.TIPO_CONTENIDOS,CATEG.ID_GRUPO_CAT, CG.DESC_GRUPO, CG.URL
FROM Prod_Yumping_co_UK.LO_CONTENIDOS CON
INNER JOIN Prod_Yumping_co_UK.LO_ADMIN_USERS AD ON CON.OPERATOR_INSERT=AD.LOGIN
INNER JOIN Prod_Yumping_co_UK.LO_CONTENIDOS_CATEG CATEG ON CON.ID_CATEG=CATEG.ID_CATEG
INNER JOIN Prod_Yumping_co_UK.LO_CONTENIDOS_GRUPOS CG ON CG.ID_GRUPO_CAT = CATEG.ID_GRUPO_CAT
AND CG.ID_TROPIC = '27'
WHERE (CON.GALERIA IS NOT NULL
AND CON.GALERIA<>'')
AND CON.ID_TROPIC='2'
AND CON.VALID=1
GROUP BY TIPO_CONTENIDOS,ID_GRUPO_CAT
UNION ALL SELECT COUNT(*) AS TOTAL,CON.TIPO_CONTENIDOS,CATEG.ID_GRUPO_CAT, CG.DESC_GRUPO, CG.URL
FROM Prod_Yumping_mx_MX.LO_CONTENIDOS CON
INNER JOIN Prod_Yumping_mx_MX.LO_ADMIN_USERS AD ON CON.OPERATOR_INSERT=AD.LOGIN
INNER JOIN Prod_Yumping_mx_MX.LO_CONTENIDOS_CATEG CATEG ON CON.ID_CATEG=CATEG.ID_CATEG
INNER JOIN Prod_Yumping_mx_MX.LO_CONTENIDOS_GRUPOS CG ON CG.ID_GRUPO_CAT = CATEG.ID_GRUPO_CAT
AND CG.ID_TROPIC = '57'
WHERE (CON.GALERIA IS NOT NULL
AND CON.GALERIA<>'')
AND CON.ID_TROPIC='5'
AND CON.VALID=1
GROUP BY TIPO_CONTENIDOS,ID_GRUPO_CAT
UNION ALL SELECT COUNT(*) AS TOTAL,CON.TIPO_CONTENIDOS,CATEG.ID_GRUPO_CAT, CG.DESC_GRUPO, CG.URL
FROM Prod_Yumping_it_IT.LO_CONTENIDOS CON
INNER JOIN Prod_Yumping_it_IT.LO_ADMIN_USERS AD ON CON.OPERATOR_INSERT=AD.LOGIN
INNER JOIN Prod_Yumping_it_IT.LO_CONTENIDOS_CATEG CATEG ON CON.ID_CATEG=CATEG.ID_CATEG
INNER JOIN Prod_Yumping_it_IT.LO_CONTENIDOS_GRUPOS CG ON CG.ID_GRUPO_CAT = CATEG.ID_GRUPO_CAT
AND CG.ID_TROPIC = '37'
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 = '47'
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.056085824966431Tiempo acumulado:0.2607798576355
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[50]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1753
AND FOTO = 'c-1146-29932970621-d197d7dbae-c17011914961701191721.9156.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0097010135650635Tiempo acumulado:0.27048087120056
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[51]: SELECT OLD_URL, NEW_URL
FROM LO_URL_301 U
WHERE U.OLD_URL = '/de/meldungen-bezuglich-abenteuer/was-ist-eine-tyrolische-traverse--c1753';
Tiempo de la consulta:
0.001802921295166Tiempo acumulado:0.27228379249573
(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 = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0005190372467041Tiempo acumulado:0.27280282974243
(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 = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_multidioma'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0027189254760742Tiempo acumulado:0.27552175521851
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[54]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0099148750305176Tiempo acumulado:0.28543663024902
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[55]: SELECT C.* , C.DESCRIPCION AS DESC_CORTA,'' as URL_CT ,C.TITULO, C.DESCRIPCION, C.TEXTO, C.GALERIA_DESC, C.VIDEOS_TEXT_CON, C.VIDEOS_DESC_CON
FROM Prod_Yumping_co_UK.LO_CONTENIDOS C
WHERE C.ID_CONTENIDO = 1753;
Tiempo de la consulta:
0.00065302848815918Tiempo acumulado:0.28608965873718
(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 = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00051307678222656Tiempo acumulado:0.28660273551941
(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 = 'gb_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0057530403137207Tiempo acumulado:0.29235577583313
(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 = 'gb_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_multidioma'
AND CFG.AMBITO IN ('gb_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0018789768218994Tiempo acumulado:0.29423475265503
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[59]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('gb_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0060560703277588Tiempo acumulado:0.30029082298279
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[60]: 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_co_UK.LO_CONTENIDOS C
INNER JOIN Prod_Yumping_co_UK.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = C.ID_CONTENIDO
AND LANGUAGE = 'it'
WHERE C.ID_CONTENIDO = 1753;
Tiempo de la consulta:
0.001554012298584Tiempo acumulado:0.30184483528137
(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 = 'gb_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('gb_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049996376037598Tiempo acumulado:0.30234479904175
(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 = 'gb_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0010671615600586Tiempo acumulado:0.30341196060181
(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 = 'gb_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_multidioma'
AND CFG.AMBITO IN ('gb_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0058190822601318Tiempo acumulado:0.30923104286194
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[64]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('gb_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00136399269104Tiempo acumulado:0.31059503555298
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[65]: SELECT C.* , CT.DESCRIPCION AS DESC_CORTA,URL_CT ,CT.TITULO, CT.DESCRIPCION, CT.TEXTO, CT.GALERIA_DESC, CT.VIDEOS_TEXT_CON, CT.VIDEOS_DESC_CON
FROM Prod_Yumping_co_UK.LO_CONTENIDOS C
INNER JOIN Prod_Yumping_co_UK.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = C.ID_CONTENIDO
AND LANGUAGE = 'fr'
WHERE C.ID_CONTENIDO = 1753;
Tiempo de la consulta:
0.0022242069244385Tiempo acumulado:0.31281924247742
(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 = 'gb_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('gb_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0039088726043701Tiempo acumulado:0.31672811508179
(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 = '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.003654956817627Tiempo acumulado:0.32038307189941
(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 = 'gb_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_multidioma'
AND CFG.AMBITO IN ('gb_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0019791126251221Tiempo acumulado:0.32236218452454
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[69]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = '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.0022509098052979Tiempo acumulado:0.32461309432983
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[70]: SELECT C.* , CT.DESCRIPCION AS DESC_CORTA,URL_CT ,CT.TITULO, CT.DESCRIPCION, CT.TEXTO, CT.GALERIA_DESC, CT.VIDEOS_TEXT_CON, CT.VIDEOS_DESC_CON
FROM Prod_Yumping_co_UK.LO_CONTENIDOS C
INNER JOIN Prod_Yumping_co_UK.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = C.ID_CONTENIDO
AND LANGUAGE = 'es'
WHERE C.ID_CONTENIDO = 1753;
Tiempo de la consulta:
0.0029799938201904Tiempo acumulado:0.32759308815002
(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 = 'gb_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('gb_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.004040002822876Tiempo acumulado:0.3316330909729
(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 = 'gb_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0059349536895752Tiempo acumulado:0.33756804466248
(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 = 'gb_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_multidioma'
AND CFG.AMBITO IN ('gb_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0032598972320557Tiempo acumulado:0.34082794189453
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[74]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('gb_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00071501731872559Tiempo acumulado:0.34154295921326
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[75]: SELECT C.* , CT.DESCRIPCION AS DESC_CORTA,URL_CT ,CT.TITULO, CT.DESCRIPCION, CT.TEXTO, CT.GALERIA_DESC, CT.VIDEOS_TEXT_CON, CT.VIDEOS_DESC_CON
FROM Prod_Yumping_co_UK.LO_CONTENIDOS C
INNER JOIN Prod_Yumping_co_UK.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = C.ID_CONTENIDO
AND LANGUAGE = 'pt'
WHERE C.ID_CONTENIDO = 1753;
Tiempo de la consulta:
0.0057899951934814Tiempo acumulado:0.34733295440674
(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 = 'gb_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('gb_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00076198577880859Tiempo acumulado:0.34809494018555
(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 = 'gb_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0011379718780518Tiempo acumulado:0.3492329120636
(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 = 'gb_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_multidioma'
AND CFG.AMBITO IN ('gb_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0005800724029541Tiempo acumulado:0.34981298446655
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[79]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('gb_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00062394142150879Tiempo acumulado:0.35043692588806
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[80]: SELECT C.* , CT.DESCRIPCION AS DESC_CORTA,URL_CT ,CT.TITULO, CT.DESCRIPCION, CT.TEXTO, CT.GALERIA_DESC, CT.VIDEOS_TEXT_CON, CT.VIDEOS_DESC_CON
FROM Prod_Yumping_co_UK.LO_CONTENIDOS C
INNER JOIN Prod_Yumping_co_UK.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = C.ID_CONTENIDO
AND LANGUAGE = 'mx'
WHERE C.ID_CONTENIDO = 1753;
Tiempo de la consulta:
0.002924919128418Tiempo acumulado:0.35336184501648
(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 = 'gb_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('gb_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.001615047454834Tiempo acumulado:0.35497689247131
(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 = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047898292541504Tiempo acumulado:0.35545587539673
(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 = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_multidioma'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00052309036254883Tiempo acumulado:0.35597896575928
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[84]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00095105171203613Tiempo acumulado:0.35693001747131
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[85]: SELECT C.* , CT.DESCRIPCION AS DESC_CORTA,URL_CT ,CT.TITULO, CT.DESCRIPCION, CT.TEXTO, CT.GALERIA_DESC, CT.VIDEOS_TEXT_CON, CT.VIDEOS_DESC_CON
FROM Prod_Yumping_co_UK.LO_CONTENIDOS C
INNER JOIN Prod_Yumping_co_UK.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = C.ID_CONTENIDO
AND LANGUAGE = 'ch'
WHERE C.ID_CONTENIDO = 1753;
Tiempo de la consulta:
0.00063705444335938Tiempo acumulado:0.35756707191467
(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 = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_noticias'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050806999206543Tiempo acumulado:0.35807514190674
(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 = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046896934509277Tiempo acumulado:0.35854411125183
(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 = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043201446533203Tiempo acumulado:0.35897612571716
(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 = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045895576477051Tiempo acumulado:0.35943508148193
(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 = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00054311752319336Tiempo acumulado:0.35997819900513
(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 = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00073385238647461Tiempo acumulado:0.3607120513916
(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 = 'gb_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0065970420837402Tiempo acumulado:0.36730909347534
(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 = 'gb_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0064079761505127Tiempo acumulado:0.37371706962585
(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 = 'gb_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0015552043914795Tiempo acumulado:0.37527227401733
(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 = 'gb_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0040900707244873Tiempo acumulado:0.37936234474182
(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 = 'gb_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('gb_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00053095817565918Tiempo acumulado:0.37989330291748
(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 = 'gb_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004889965057373Tiempo acumulado:0.38038229942322
(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 = 'gb_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046086311340332Tiempo acumulado:0.38084316253662
(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 = 'gb_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00085997581481934Tiempo acumulado:0.38170313835144
(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 = 'gb_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0032830238342285Tiempo acumulado:0.38498616218567
(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 = 'gb_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('gb_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0022430419921875Tiempo acumulado:0.38722920417786
(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 = 'gb_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0008080005645752Tiempo acumulado:0.38803720474243
(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 = 'gb_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00063586235046387Tiempo acumulado:0.3886730670929
(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 = 'gb_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain'
AND CFG.AMBITO IN ('gb_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0071489810943604Tiempo acumulado:0.39582204818726
(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 = 'gb_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00084495544433594Tiempo acumulado:0.39666700363159
(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 = 'gb_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0029218196868896Tiempo acumulado:0.39958882331848
(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 = '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.0033340454101562Tiempo acumulado:0.40292286872864
(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 = 'gb_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0039420127868652Tiempo acumulado:0.4068648815155
(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 = 'gb_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0013301372528076Tiempo acumulado:0.40819501876831
(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 = 'gb_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0037069320678711Tiempo acumulado:0.41190195083618
(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 = 'gb_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0016908645629883Tiempo acumulado:0.41359281539917
(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 = 'gb_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('gb_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045299530029297Tiempo acumulado:0.41404581069946
(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 = 'gb_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0041911602020264Tiempo acumulado:0.41823697090149
(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 = 'gb_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0008080005645752Tiempo acumulado:0.41904497146606
(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 = 'gb_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.012012004852295Tiempo acumulado:0.43105697631836
(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 = 'gb_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0020298957824707Tiempo acumulado:0.43308687210083
(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 = 'gb_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('gb_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.01123309135437Tiempo acumulado:0.4443199634552
(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 = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0033750534057617Tiempo acumulado:0.44769501686096
(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 = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0010790824890137Tiempo acumulado:0.44877409934998
(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 = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0028660297393799Tiempo acumulado:0.45164012908936
(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 = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049114227294922Tiempo acumulado:0.4521312713623
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[122]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.008397102355957Tiempo acumulado:0.46052837371826
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[123]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.003882884979248Tiempo acumulado:0.46441125869751
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[124]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1753
AND FOTO = 'c-1146-29932970621-d197d7dbae-c17011914961701191721.9156.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0031981468200684Tiempo acumulado:0.46760940551758
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[125]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1753
AND FOTO = 'c-1146-53063365837-cdf1194b7c-h17011914951701191722.4794.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0013868808746338Tiempo acumulado:0.46899628639221
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[126]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1753
AND FOTO = 'c-1146-8331797334-063300b9c9-c17011914961701191723.2671.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0014269351959229Tiempo acumulado:0.47042322158813
(Prod_Yumping_co_UK) (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.00095796585083008Tiempo acumulado:0.47138118743896
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[128]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.00047707557678223Tiempo acumulado:0.47185826301575
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[129]: 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='27'
AND CON.ID_CONTENIDO='1753'
LIMIT 1;
Tiempo de la consulta:
0.00062394142150879Tiempo acumulado:0.47248220443726
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[130]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1753
AND FOTO = 'c-1146-29932970621-d197d7dbae-c17011914961701191721.9156.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00087594985961914Tiempo acumulado:0.47335815429688
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[131]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1753
AND FOTO = 'c-1146-53063365837-cdf1194b7c-h17011914951701191722.4794.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0017189979553223Tiempo acumulado:0.4750771522522
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[132]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1753
AND FOTO = 'c-1146-8331797334-063300b9c9-c17011914961701191723.2671.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0033860206604004Tiempo acumulado:0.4784631729126
(Prod_Yumping_co_UK) (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 = 27
WHERE C.TITULO LIKE '10 cosas que hacer en%'
AND C.ID_CONTENIDO = 1753;
Tiempo de la consulta:
0.0014400482177734Tiempo acumulado:0.47990322113037
(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 = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0005190372467041Tiempo acumulado:0.48042225837708
(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 = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0032718181610107Tiempo acumulado:0.48369407653809
(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 = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0015430450439453Tiempo acumulado:0.48523712158203
(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 = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0020251274108887Tiempo acumulado:0.48726224899292
(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 = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_multidioma'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0045950412750244Tiempo acumulado:0.49185729026794
(Prod_Yumping_co_UK) (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
, 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_co_UK.LO_CONTENIDOS CON
INNER JOIN Prod_Yumping_co_UK.LO_ADMIN_USERS AD ON AD.LOGIN = CON.OPERATOR_INSERT
INNER JOIN Prod_Yumping_co_UK.LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = CON.ID_CONTENIDO
AND LANGUAGE = 'de'
WHERE
(CON.GALERIA IS NOT NULL
AND CON.GALERIA<>'')
AND CON.ID_CATEG = 24
AND CON.VALID = 1
AND CON.ID_CONTENIDO !=1753
ORDER BY RAND()
LIMIT 4;
Tiempo de la consulta:
0.055491924285889Tiempo acumulado:0.54734921455383
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[140]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1661
AND FOTO = '25281518844-34b4d58c12-k1689338898.jpg'
AND VALID=1;
Tiempo de la consulta:
0.009080171585083Tiempo acumulado:0.55642938613892
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[141]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1701
AND FOTO = '52519835173-058a81482a-k1690468464.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0027589797973633Tiempo acumulado:0.55918836593628
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[142]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1716
AND FOTO = 'c-1107-3330790566-ae030a2eb0-k16886391091688639455.9874.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0055859088897705Tiempo acumulado:0.56477427482605
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[143]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1688
AND FOTO = '1432613982-62965e7f07-k1690187473.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0045309066772461Tiempo acumulado:0.5693051815033
(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_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.0010528564453125Tiempo acumulado:0.57035803794861
(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_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('es_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049901008605957Tiempo acumulado:0.57085704803467
(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_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('es_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0014469623565674Tiempo acumulado:0.57230401039124
(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_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.0041749477386475Tiempo acumulado:0.57647895812988
(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_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.0013480186462402Tiempo acumulado:0.57782697677612
(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_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0065438747406006Tiempo acumulado:0.58437085151672
(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_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0015819072723389Tiempo acumulado:0.58595275878906
(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_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0026021003723145Tiempo acumulado:0.58855485916138
(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_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00089001655578613Tiempo acumulado:0.58944487571716
(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_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0039849281311035Tiempo acumulado:0.59342980384827
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[154]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050687789916992Tiempo acumulado:0.59393668174744
(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 = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0036711692810059Tiempo acumulado:0.59760785102844
(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 = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0032439231872559Tiempo acumulado:0.6008517742157
(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 = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0038330554962158Tiempo acumulado:0.60468482971191
(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 = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0012259483337402Tiempo acumulado:0.60591077804565
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[159]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('mx_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.001147985458374Tiempo acumulado:0.60705876350403
(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 = 'mx_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('mx_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0029881000518799Tiempo acumulado:0.61004686355591
(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 = 'mx_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('mx_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046110153198242Tiempo acumulado:0.61050796508789
(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 = 'mx_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('mx_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0035951137542725Tiempo acumulado:0.61410307884216
(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 = 'mx_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('mx_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0043010711669922Tiempo acumulado:0.61840415000916
(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_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('it_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00094318389892578Tiempo acumulado:0.61934733390808
(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_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('it_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0033769607543945Tiempo acumulado:0.62272429466248
(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_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('it_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0010778903961182Tiempo acumulado:0.62380218505859
(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_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('it_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0030720233917236Tiempo acumulado:0.62687420845032
(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_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('it_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0040040016174316Tiempo acumulado:0.63087821006775
(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_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('fr_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0030868053436279Tiempo acumulado:0.63396501541138
(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_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic'
AND CFG.AMBITO IN ('fr_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0039818286895752Tiempo acumulado:0.63794684410095
(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_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('fr_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0010249614715576Tiempo acumulado:0.63897180557251
(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_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('fr_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0029060840606689Tiempo acumulado:0.64187788963318
(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_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_con_traducciones'
AND CFG.AMBITO IN ('fr_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0038690567016602Tiempo acumulado:0.64574694633484
(Prod_Yumping_co_UK) (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 = '17'
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 = '87'
WHERE (CON.GALERIA IS NOT NULL
AND CON.GALERIA<>'')
AND CON.ID_TROPIC='8'
AND CON.VALID=1
GROUP BY TIPO_CONTENIDOS,ID_GRUPO_CAT
UNION ALL SELECT COUNT(*) AS TOTAL,CON.TIPO_CONTENIDOS,CATEG.ID_GRUPO_CAT, CG.DESC_GRUPO, CG.URL
FROM Prod_Yumping_co_UK.LO_CONTENIDOS CON
INNER JOIN Prod_Yumping_co_UK.LO_ADMIN_USERS AD ON CON.OPERATOR_INSERT=AD.LOGIN
INNER JOIN Prod_Yumping_co_UK.LO_CONTENIDOS_CATEG CATEG ON CON.ID_CATEG=CATEG.ID_CATEG
INNER JOIN Prod_Yumping_co_UK.LO_CONTENIDOS_GRUPOS CG ON CG.ID_GRUPO_CAT = CATEG.ID_GRUPO_CAT
AND CG.ID_TROPIC = '27'
WHERE (CON.GALERIA IS NOT NULL
AND CON.GALERIA<>'')
AND CON.ID_TROPIC='2'
AND CON.VALID=1
GROUP BY TIPO_CONTENIDOS,ID_GRUPO_CAT
UNION ALL SELECT COUNT(*) AS TOTAL,CON.TIPO_CONTENIDOS,CATEG.ID_GRUPO_CAT, CG.DESC_GRUPO, CG.URL
FROM Prod_Yumping_mx_MX.LO_CONTENIDOS CON
INNER JOIN Prod_Yumping_mx_MX.LO_ADMIN_USERS AD ON CON.OPERATOR_INSERT=AD.LOGIN
INNER JOIN Prod_Yumping_mx_MX.LO_CONTENIDOS_CATEG CATEG ON CON.ID_CATEG=CATEG.ID_CATEG
INNER JOIN Prod_Yumping_mx_MX.LO_CONTENIDOS_GRUPOS CG ON CG.ID_GRUPO_CAT = CATEG.ID_GRUPO_CAT
AND CG.ID_TROPIC = '57'
WHERE (CON.GALERIA IS NOT NULL
AND CON.GALERIA<>'')
AND CON.ID_TROPIC='5'
AND CON.VALID=1
GROUP BY TIPO_CONTENIDOS,ID_GRUPO_CAT
UNION ALL SELECT COUNT(*) AS TOTAL,CON.TIPO_CONTENIDOS,CATEG.ID_GRUPO_CAT, CG.DESC_GRUPO, CG.URL
FROM Prod_Yumping_it_IT.LO_CONTENIDOS CON
INNER JOIN Prod_Yumping_it_IT.LO_ADMIN_USERS AD ON CON.OPERATOR_INSERT=AD.LOGIN
INNER JOIN Prod_Yumping_it_IT.LO_CONTENIDOS_CATEG CATEG ON CON.ID_CATEG=CATEG.ID_CATEG
INNER JOIN Prod_Yumping_it_IT.LO_CONTENIDOS_GRUPOS CG ON CG.ID_GRUPO_CAT = CATEG.ID_GRUPO_CAT
AND CG.ID_TROPIC = '37'
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 = '47'
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.060817003250122Tiempo acumulado:0.70656394958496
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[175]: SELECT PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, ID_PRECIO,
GALERIA_PRE,NOMBRE,SECI.DESC_SECTOR,REI.DESC_REGION,DESC_POBLACION,FOTOPRINCIPAL_PRE,
EMP.URL URL,SECI.ID_SECTOR ID_SECTOR, SECI.URL URL_SECTOR,REI.URL URL_REGION,
LEAST(if(PRECIO_MIN_PRE>0,PRECIO_MIN_PRE,PRECIO_PRE),PRECIO_PRE) PRECIO,
DESCUENTO_MIN_PRE DESCUENTO,
DATE_FORMAT(FECHA_CADUCIDAD_PD_PRE,'%d') AS DIA_CAD,
DATE_FORMAT(FECHA_CADUCIDAD_PD_PRE,'%m') AS MES_CAD,
DATE_FORMAT(FECHA_CADUCIDAD_PD_PRE,'%Y') AS ANYO_CAD, PRE.MULTIACTIVIDAD_PRE
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_DE PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'de'
INNER JOIN LO_PRECIOS_SECTORES PS ON PRE.ID_PRECIO=PS.ID_PRECIO_PS
AND ID_ACTIVIDAD_PS='24'
INNER JOIN LO_EMPRESAS EMP ON PRE.ID_EMPRESA_PRE=EMP.ID_EMPRESA AND( EMP.VALID=1 OR EMP.VALID='-3')
INNER JOIN LO_SECTORES SEC ON PS.ID_ACTIVIDAD_PS=SEC.ID_SECTOR
INNER JOIN LO_SECTORES_I18N SECI ON SEC.ID_SECTOR=SECI.ID_SECTOR
AND SECI.ID_TROPIC=27
AND SECI.FK_ID_IDIOMA_SI18N='de'
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PRE.ID_REGION_PRE
AND REI.IDIOMA='de'
INNER JOIN LO_POBLACION_GB PO ON PO.ID_POBLACION = PRE.ID_POBLACION_PRE
AND PO.IDIOMA='de'
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 (slow_query): 0.52126407623291Tiempo acumulado:1.2278280258179
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[176]: SELECT URL_PRE, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, ID_PRECIO, FK_ID_PAIS_PRE
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_DE PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'de'
WHERE PRE.ID_PRECIO = 21661;
Tiempo de la consulta:
0.0035419464111328Tiempo acumulado:1.231369972229
(Prod_Yumping_co_UK) (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 = 21661;
Tiempo de la consulta:
0.0027790069580078Tiempo acumulado:1.234148979187
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[178]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 21661
AND VALID = 1;
Tiempo de la consulta:
0.0052790641784668Tiempo acumulado:1.2394280433655
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[179]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 21661
AND FOTO = 'extreme-ven-rock-scrambling.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00053000450134277Tiempo acumulado:1.2399580478668
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[180]: SELECT ID_PRECIO, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_PRECIO =21661;
Tiempo de la consulta:
0.0022730827331543Tiempo acumulado:1.2422311306
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[181]: SELECT URL_PRE, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, ID_PRECIO, FK_ID_PAIS_PRE
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_DE PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'de'
WHERE PRE.ID_PRECIO = 7038;
Tiempo de la consulta:
0.00057411193847656Tiempo acumulado:1.2428052425385
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[182]: SELECT ID_PRECIO_PADRE
FROM LO_PRECIOS_ASIGNACION PA
INNER JOIN LO_PRECIOS PRE ON PRE.ID_PRECIO = PA.ID_PRECIO_PADRE
AND PRE.VALID_PRE = 4
WHERE PA.ID_PRECIO = 7038;
Tiempo de la consulta:
0.00064992904663086Tiempo acumulado:1.2434551715851
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[183]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 7038
AND VALID = 1;
Tiempo de la consulta:
0.0052239894866943Tiempo acumulado:1.2486791610718
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[184]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 7038
AND FOTO = 'outdoor-climbing.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00047802925109863Tiempo acumulado:1.2491571903229
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[185]: SELECT ID_PRECIO, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_PRECIO =7038;
Tiempo de la consulta:
0.0011250972747803Tiempo acumulado:1.2502822875977
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[186]: SELECT URL_PRE, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, ID_PRECIO, FK_ID_PAIS_PRE
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_DE PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'de'
WHERE PRE.ID_PRECIO = 86916;
Tiempo de la consulta:
0.00069999694824219Tiempo acumulado:1.2509822845459
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[187]: SELECT ID_PRECIO_PADRE
FROM LO_PRECIOS_ASIGNACION PA
INNER JOIN LO_PRECIOS PRE ON PRE.ID_PRECIO = PA.ID_PRECIO_PADRE
AND PRE.VALID_PRE = 4
WHERE PA.ID_PRECIO = 86916;
Tiempo de la consulta:
0.00044608116149902Tiempo acumulado:1.2514283657074
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[188]: SELECT PRE.URL_PRE, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, PRE.PRECIO_PRE, PRE.MAX_PERS_PRE, PRE.MIN_PERS_PRE, PRE.ID_PRECIO,
PRE.MULTIACTIVIDAD_PRE, PRE.ID_EMPRESA_PRE, PRE.ID_REGION_PRE,PRE.VALID_PRE, PRE.ALOJAMIENTO_PRE, PRE.EDAD_MINIMA_PRE,
PRE.TRANSPORTE_PRE, PRE.COMIDA_PRE,PRE.GALERIA_PRE, PRE.FOTOPRINCIPAL_PRE, PRECIO_UNITARIO_PRE
,REI.DESC_REGION DESC_REGION, EXI.N_VENTAS, EXI.EXITO, SECI.URL URL_SECTOR,REI.URL URL_REGION,
EMP.*, POI.DESC_POBLACION, POI.URL_POBLACION, SECI.DESC_SECTOR, SECP.ID_ACTIVIDAD_PS,Ceiling(AVG(OP.VALORACION)) AS VALORACION, SECI.DESC_SECTOR_ALT, SECI.DESC_SECTOR_ALT_PLURAL,
COUNT(DISTINCT OP.ID_OPINION) as N_OPINIONES,EMPS.CENTRAL_ACTIVA, REI.ID_REGION, SECI.ID_SECTOR, PD.OFERTA_PD,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%Y/%m/%d') AS FECHA,PERIODO_PRE,ANTELACION_PRE, SEC.ID_GRUPO,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%Y/%m/%d') AS FEC_ULT_COMPRA,
IF(PRECIO_PD>0,LEAST(MIN(PRECIO_PD),PRECIO_PRE),LEAST(999999999,PRECIO_PRE) ) PRECIO,
IF(PRECIO_PD>0
AND VALID_PD=1, (1-(MIN(PRECIO_PD)/PRECIO_PRE))*100 ,0) DESCUENTO,
DATE_FORMAT(PD.FECHA_CADUCIDAD_PD,'%d') AS DIA_CAD,
DATE_FORMAT(PD.FECHA_CADUCIDAD_PD,'%m') AS MES_CAD,
DATE_FORMAT(PD.FECHA_CADUCIDAD_PD,'%Y') AS ANYO_CAD,
SIN_FECHA_PRE, PRE.CANTIDAD_UNITARIO_PRE, DATE_FORMAT(PRE.FEC_INSERT_PRE,'%Y/%m/%d') AS FEC_INSERT_PRE, EMP.LATITUDE, EMP.LONGITUDE, PRE.N_VENTAS_PRE
,PRE.ID_POBLACION_PRE, PRE.ID_POBLACION_PRE AS ID_POBLACION
FROM LO_PRECIOS PRE
INNER JOIN LO_EMPRESAS EMP ON PRE.ID_EMPRESA_PRE=EMP.ID_EMPRESA
INNER JOIN LO_EMPRESAS_STAT EMPS ON EMP.ID_EMPRESA=EMPS.FK_ID_EST
INNER JOIN LO_PRECIOS_SECTORES SECP ON PRE.ID_PRECIO=SECP.ID_PRECIO_PS
/*
AND SECP.ID_ACTIVIDAD_PS NOT IN (100,101)*/
AND SECP.ID_ACTIVIDAD_PS = (SELECT PS.ID_ACTIVIDAD_PS
FROM LO_PRECIOS_SECTORES PS
WHERE PS.ID_PRECIO_PS = PRE.ID_PRECIO
ORDER BY IF(PS.ID_ACTIVIDAD_PS = 100 OR PS.ID_ACTIVIDAD_PS = 101, 10000, 1) ASC
LIMIT 1)
INNER JOIN LO_SECTORES SEC ON SECP.ID_ACTIVIDAD_PS=SEC.ID_SECTOR
INNER JOIN LO_SECTORES_I18N SECI ON SEC.ID_SECTOR=SECI.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N ='de'
AND SECI.ID_TROPIC = 27
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PRE.ID_REGION_PRE
AND REI.IDIOMA ='de'
INNER JOIN LO_POBLACION_GB POI ON POI.ID_POBLACION = PRE.ID_POBLACION_PRE
AND POI.IDIOMA ='de'
LEFT JOIN LO_PRECIOS_EXITO EXI ON PRE.ID_PRECIO = EXI.ID_PRECIO
LEFT JOIN LO_RESERVAS_COMPRAS RC ON RC.ID_PRECIO_RC = PRE.ID_PRECIO
AND RC.VALID_RC NOT IN (7,2,0)
LEFT JOIN LO_EMPRESAS_OPINIONES OP ON OP.RESERVA_FEEDBACK = RC.ID_RESERVA_COMPRA
AND OP.VALID = 1
LEFT JOIN LO_PRECIOS_DESCUENTOS PD ON PD.ID_PRECIO_PD = PRE.ID_PRECIO
AND PD.VALID_PD = 1
INNER JOIN LO_PRECIOS_TRADUCCION_DE PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'de'
WHERE REI.IDIOMA='de'
AND EMP.VALID=1
AND VALID_PRE IN(1,4,3)
AND PRE.ID_PRECIO='86912'
LIMIT 1;
Tiempo de la consulta:
0.0077760219573975Tiempo acumulado:1.2592043876648
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[189]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 86916
AND VALID = 1;
Tiempo de la consulta:
0.0033891201019287Tiempo acumulado:1.2625935077667
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[190]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 86916
AND FOTO = 'p-86916-62128739-1964343957004825-7603028296531443712-n1689592375_1689592998367.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00074386596679688Tiempo acumulado:1.2633373737335
(Prod_Yumping_co_UK) (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 =86916;
Tiempo de la consulta:
0.0056300163269043Tiempo acumulado:1.2689673900604
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[192]: SELECT URL_PRE, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, ID_PRECIO, FK_ID_PAIS_PRE
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_DE PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'de'
WHERE PRE.ID_PRECIO = 45090;
Tiempo de la consulta:
0.00053596496582031Tiempo acumulado:1.2695033550262
(Prod_Yumping_co_UK) (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 = 45090;
Tiempo de la consulta:
0.00048708915710449Tiempo acumulado:1.2699904441833
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[194]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 45090
AND VALID = 1;
Tiempo de la consulta:
0.0021951198577881Tiempo acumulado:1.2721855640411
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[195]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 45090
AND FOTO = 'p-45090-1514629-10155835018510459-8283647741817988981-n_14745443107135.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00054717063903809Tiempo acumulado:1.2727327346802
(Prod_Yumping_co_UK) (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 =45090;
Tiempo de la consulta:
0.0010979175567627Tiempo acumulado:1.2738306522369
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[197]: SELECT URL_PRE, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, ID_PRECIO, FK_ID_PAIS_PRE
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_DE PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'de'
WHERE PRE.ID_PRECIO = 44605;
Tiempo de la consulta:
0.00069880485534668Tiempo acumulado:1.2745294570923
(Prod_Yumping_co_UK) (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 = 44605;
Tiempo de la consulta:
0.0006110668182373Tiempo acumulado:1.2751405239105
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[199]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 44605
AND VALID = 1;
Tiempo de la consulta:
0.0032029151916504Tiempo acumulado:1.2783434391022
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[200]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 44605
AND FOTO = 'p-44605-mount2-adobe-express1678727168_16787818309353.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00075483322143555Tiempo acumulado:1.2790982723236
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[201]: SELECT ID_PRECIO, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_PRECIO =44605;
Tiempo de la consulta:
0.00045585632324219Tiempo acumulado:1.2795541286469
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[202]: SELECT CON.ID_CONTENIDO, CON.TITULO,CON.TIPO_CONTENIDOS, CON.DESCRIPCION, CON.TEXTO, CON.GALERIA,
CON.GALERIA_DESC, CON.FOTOPRINCIPAL, DATE_FORMAT(CON.FEC_INSERT,'%d/%m/%y') AS FEC_INSERT,
AD.NOMBRE, AD.MAIL,CON.NOMBRE_FIRMA_CON,TIPO_CONTENIDOS, CT.DESCRIPCION AS DESC_CORTA,URL_CT ,CT.TITULO, CT.DESCRIPCION, CT.TEXTO, CT.GALERIA_DESC, CT.VIDEOS_TEXT_CON, CT.VIDEOS_DESC_CON
FROM LO_CONTENIDOS CON
INNER JOIN LO_CONTENIDOS_TRADUCCION CT ON CT.ID_CONTENIDO = CON.ID_CONTENIDO
AND LANGUAGE = 'de'
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 = '2'
AND CON.VALID = 1
AND CON.ID_CONTENIDO NOT IN ('1753')
ORDER BY FIELD(TIPO_CONTENIDOS,1) DESC, CON.FEC_INSERT DESC
LIMIT 5;
Tiempo de la consulta:
0.042293071746826Tiempo acumulado:1.3218472003937
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[203]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1787
AND FOTO = 'c-1181-26977663838-216dad17ba-k17104162281710416454.4418.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0016379356384277Tiempo acumulado:1.3234851360321
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[204]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1786
AND FOTO = 'c-1180-380547166-685951523563845-6690618414481223694-n17102464211710246645.7735.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00057077407836914Tiempo acumulado:1.3240559101105
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[205]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1785
AND FOTO = 'c-1179-15423592468-aafd5071fe-k17098163701709817064.7075.jpg'
AND VALID=1;
Tiempo de la consulta:
0.002547025680542Tiempo acumulado:1.326602935791
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[206]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1784
AND FOTO = 'c-1178-44191651881-c71504c9c6-k17097397501709740524.4709.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00049996376037598Tiempo acumulado:1.3271028995514
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[207]: SELECT *
FROM LO_FOTOS
WHERE ID_CONTENIDO = 1783
AND FOTO = 'c-1177-331731140-748807996752677-2855618998684593648-n17096345011709634887.964.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0020182132720947Tiempo acumulado:1.3291211128235
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[208]: 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 = 27
AND SECI.FK_ID_IDIOMA_SI18N = 'de'
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PRE.ID_REGION_PRE
AND REI.IDIOMA = 'de'
INNER JOIN LO_REGION_STATS RS ON RS.ID_REGION = REI.ID_REGION
AND RS.N_OFERTAS > 0
WHERE PRE.VALID_PRE = 4
AND RS.ID_SECTOR = 24
AND (RS.ID_GRUPO IS NULL OR RS.ID_GRUPO = 0)
GROUP BY PRE.ID_REGION_PRE
ORDER BY NEMPRESAS DESC;
Tiempo de la consulta (slow_query): 0.10426592826843Tiempo acumulado:1.4333870410919
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[209]: SELECT *
FROM LO_EQUIPO_EDITORIAL EE
WHERE EE.ID_TROPIC = 27;
Tiempo de la consulta:
0.0043609142303467Tiempo acumulado:1.4377479553223
.Cerramos Conexiones BB.DD.