yu-front-06.localdomain (172.30.2.194:443)
prod.yumping.com
/empresa.php
BBDD->Prod_Yumping_fr_FR
AMBITO->fr_ch
AMBITO_AJAX->fr_ch
AMBITO_AJAX COOKIE->it_ch
locale LO_CONFIG->cn_FR
locale php->cn_FR
Fuente tráfico->0
SESSION VARS
DEFINED VARS
$tpage->
empresaCache VARS
NOCFG->memcache_port->11212
CFG->memcache_main_server->172.30.2.194
CFG->memcache_add_servers->172.30.2.194
YMMemcache::memcache_stats->
SERVER VARS
HTTP_REFERER
Request VARS
ambito_lang->zh-hans
id_empresa->19864699
tpage->empresa
nomb_emp->goelette-alliance
rel_alternate->1
Total queries: 231
Tiempo total: 0.63226914405823
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[1]: SELECT CFG.ID, CFG.NAME, IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '', CFG.VALUE_PROD, CFG.VALUE) VALUE , CFG.AMBITO, CFG.VISIBLE_AJAX, CFG.TIME
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.AMBITO IN ('global', 'es_ch')
ORDER BY CFG.NAME;
Tiempo de la consulta:
0.018061876296997Tiempo acumulado:0.018061876296997
(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.003896951675415Tiempo acumulado:0.021958827972412
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[3]: SELECT ID_PAIS
FROM ( SELECT EMP.ID_PAIS
FROM Prod_Yumping_es_ES.LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19864699
AND fnGoogleUrl(EMP.NOMBRE) = 'goelette-alliance' UNION ALL SELECT EMP.ID_PAIS
FROM Prod_Yumping_pt_PT.LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19864699
AND fnGoogleUrl(EMP.NOMBRE) = 'goelette-alliance' UNION ALL SELECT EMP.ID_PAIS
FROM Prod_Yumping_it_IT.LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19864699
AND fnGoogleUrl(EMP.NOMBRE) = 'goelette-alliance' UNION ALL SELECT EMP.ID_PAIS
FROM Prod_Yumping_fr_FR.LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19864699
AND fnGoogleUrl(EMP.NOMBRE) = 'goelette-alliance' UNION ALL SELECT EMP.ID_PAIS
FROM Prod_Yumping_co_UK.LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19864699
AND fnGoogleUrl(EMP.NOMBRE) = 'goelette-alliance' UNION ALL SELECT EMP.ID_PAIS
FROM Prod_Yumping_mx_MX.LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19864699
AND fnGoogleUrl(EMP.NOMBRE) = 'goelette-alliance' ) AS EMPRESA;
Tiempo de la consulta:
0.046936988830566Tiempo acumulado:0.068895816802979
(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', 'fr_ch')
ORDER BY CFG.NAME;
Tiempo de la consulta:
0.019423961639404Tiempo acumulado:0.088319778442383
(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.00065803527832031Tiempo acumulado:0.088977813720703
(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.00049304962158203Tiempo acumulado:0.089470863342285
(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.00083398818969727Tiempo acumulado:0.090304851531982
(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_empresa';
Tiempo de la consulta:
0.00050616264343262Tiempo acumulado:0.090811014175415
(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.0007939338684082Tiempo acumulado:0.091604948043823
(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 = 'nomb_emp';
Tiempo de la consulta:
0.00053715705871582Tiempo acumulado:0.092142105102539
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[11]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'rel_alternate';
Tiempo de la consulta:
0.0011370182037354Tiempo acumulado:0.093279123306274
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[12]: SELECT EMP.COMO_LLEGAR COMO_LLEGAR_ORI, EMP.GALERIA_DESC GALERIA_DESC_ORI, EMP.VIDEOS_TEXT VIDEOS_TEXT_ORI,EMP.VIDEOS_DESC VIDEOS_DESC_ORI,
EMP.EMP_MADRE,EMP.LOGOTIPO,EMP.ID_EMPRESA,EMP.DIRECCION,
PO.DESC_POBLACION, PO.URL_POBLACION, REI.DESC_REGION,EMP.DS_ACTIVO,EMP.ID_PAIS,
EMP.TELEFONO,EMP.NOPINIONES,EMP.VIDEOS_CODE,SEC.ID_GRUPO,SECI.DESC_SECTOR,EMP.FOTOPRINCIPAL,
EMP.GALERIA,EMP.MADRE_NAME,EMP.PRECIO_ACTIVIDAD,EMP.TIPOCUENTA,SECI.URL URL_SECTOR,
EMP.LICENCIA_EMPRESA,EMP.ID_POBLACION,EMP.VALID,EMP.ID_PROVINCIA,EMP.ID_SECTOR,
EMP.VIDEOS_CODE,EMP.VIDEOS_DESC,EMP.CLIENTE,RE.ID_REGION,N_VENTAS_EST,
EMP.COLAB_EMPRESAS, EMP.ID_MADRE ID_MADRE,REI.URL URL_REGION,
EMP.LATITUDE LATITUDE,EMP.COD_POSTAL, EMP.LONGITUDE LONGITUDE,PO.URL_POBLACION,
ES.NOPINIONES_EST,ES.N_PRECIOS_EST,ES.VISITAS,PUNTOS_EST,EMP.LOGIN,EMP.PASSWORD,EMP.PERS_CTCTO,
EMP.TELEFONOMOVIL, EMP.FAX,EMP.WEB,EMP.MAIL,EMP.ACCOUNT_MANAGER,RESPUESTARAPIDA,CENTRAL_ACTIVA,
NOPINIONES_EST,EMP.MAIL_CC, EMP.ACEPTAR_CR,EMP.VIDEOS_TEXT,ES.PRECIO_EST, ES.PUNTOS_EST,
ES.RIESGO_EST, ES.ATENCION_EST, EMP.URL,
ET.DESCRIPCION_ET DESCRIPCION,GALERIA_DESC_ET GALERIA_DESC,VIDEOS_TEXT_ET VIDEOS_TEXT,VIDEOS_DESC_ET VIDEOS_DESC,COMO_LLEGAR_ET COMO_LLEGAR,URL_ET URL, EMP.NOMBRE NOMBRE, ET.EVENT_PLANNING EVENT_PLANNING,
IF (EMP.EMP_MADRE = 0,
CASE EMP.ID_SECTOR
WHEN 13 THEN GRU.DESC_GRUPO
WHEN 16 THEN GRU.DESC_GRUPO
WHEN 2 THEN GRU.DESC_GRUPO
WHEN 3 THEN GRU.DESC_GRUPO
WHEN 56 THEN GRU.DESC_GRUPO
WHEN 67 THEN GRU.DESC_GRUPO
WHEN 7 THEN GRU.DESC_GRUPO
WHEN 93 THEN GRU.DESC_GRUPO
ELSE SECI.DESC_SECTOR
END,
SECI.DESC_SECTOR) AS DESC_SECTOR_BUSCADOR
FROM LO_EMPRESAS EMP
INNER JOIN LO_EMPRESAS_TRADUCCION_CH ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'ch'
LEFT JOIN LO_EMPRESAS_STAT ES ON EMP.ID_EMPRESA = ES.FK_ID_EST
INNER JOIN LO_REGION RE ON EMP.ID_PROVINCIA = RE.ID_REGION
INNER JOIN LO_REGION_I18N REI ON RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA='ch'
INNER JOIN LO_REGION_ADM1 REIAD ON RE.ID_REGION_ADM1 = REIAD.ID_REGION_ADM1
LEFT JOIN LO_POBLACION_FR PO ON EMP.ID_POBLACION = PO.ID_POBLACION
AND PO.IDIOMA='ch'
INNER JOIN LO_SECTORES SEC ON EMP.ID_SECTOR = SEC.ID_SECTOR
INNER JOIN LO_SECTORES_I18N SECI ON SEC.ID_SECTOR = SECI.ID_SECTOR
AND (SECI.ID_TROPIC = 46
AND SECI.FK_ID_IDIOMA_SI18N = 'ch')
INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
AND (GRU.ID_TROPIC = 46)
WHERE EMP.ID_EMPRESA = 19864699
AND EMP.VALID IN ('1', '-3')
LIMIT 1;
Tiempo de la consulta:
0.015957832336426Tiempo acumulado:0.1092369556427
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[13]: SELECT EMP.COMO_LLEGAR COMO_LLEGAR_ORI, EMP.GALERIA_DESC GALERIA_DESC_ORI, EMP.VIDEOS_TEXT VIDEOS_TEXT_ORI,
EMP.EMP_MADRE,EMP.LOGOTIPO,EMP.ID_EMPRESA,EMP.DIRECCION,
PO.DESC_POBLACION, PO.URL_POBLACION, REI.DESC_REGION,EMP.DS_ACTIVO,EMP.ID_PAIS,
EMP.TELEFONO,EMP.NOPINIONES,EMP.VIDEOS_CODE,SEC.ID_GRUPO,SECI.DESC_SECTOR,EMP.FOTOPRINCIPAL,
EMP.GALERIA,EMP.MADRE_NAME,EMP.PRECIO_ACTIVIDAD,EMP.TIPOCUENTA,SECI.URL URL_SECTOR,
EMP.LICENCIA_EMPRESA,EMP.ID_POBLACION,EMP.VALID,EMP.ID_PROVINCIA,EMP.ID_SECTOR,
EMP.VIDEOS_CODE,EMP.VIDEOS_DESC,EMP.CLIENTE,RE.ID_REGION,N_VENTAS_EST,
EMP.COLAB_EMPRESAS, EMP.ID_MADRE ID_MADRE,REI.URL URL_REGION,
EMP.LATITUDE LATITUDE,EMP.COD_POSTAL, EMP.LONGITUDE LONGITUDE,PO.URL_POBLACION,
ES.NOPINIONES_EST,ES.N_PRECIOS_EST,ES.VISITAS,PUNTOS_EST,EMP.LOGIN,EMP.PASSWORD,EMP.PERS_CTCTO,
EMP.TELEFONOMOVIL, EMP.FAX,EMP.WEB,EMP.MAIL,EMP.ACCOUNT_MANAGER,RESPUESTARAPIDA,CENTRAL_ACTIVA,
NOPINIONES_EST,EMP.MAIL_CC, EMP.ACEPTAR_CR,EMP.VIDEOS_TEXT,ES.PRECIO_EST, ES.PUNTOS_EST,
ES.RIESGO_EST, ES.ATENCION_EST, EMP.URL,
ET.DESCRIPCION_ET DESCRIPCION,GALERIA_DESC_ET GALERIA_DESC,VIDEOS_TEXT_ET VIDEOS_TEXT,VIDEOS_DESC_ET VIDEOS_DESC,COMO_LLEGAR_ET COMO_LLEGAR,URL_ET URL, EMP.NOMBRE NOMBRE, ET.EVENT_PLANNING EVENT_PLANNING,
IF (EMP.EMP_MADRE = 0,
CASE EMP.ID_SECTOR
WHEN 13 THEN GRU.DESC_GRUPO
WHEN 16 THEN GRU.DESC_GRUPO
WHEN 2 THEN GRU.DESC_GRUPO
WHEN 3 THEN GRU.DESC_GRUPO
WHEN 56 THEN GRU.DESC_GRUPO
WHEN 67 THEN GRU.DESC_GRUPO
WHEN 7 THEN GRU.DESC_GRUPO
WHEN 93 THEN GRU.DESC_GRUPO
ELSE SECI.DESC_SECTOR
END,
SECI.DESC_SECTOR) AS DESC_SECTOR_BUSCADOR
FROM LO_EMPRESAS EMP
INNER JOIN LO_EMPRESAS_TRADUCCION_CH ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'ch'
LEFT JOIN LO_EMPRESAS_STAT ES ON EMP.ID_EMPRESA = ES.FK_ID_EST
INNER JOIN LO_REGION RE ON EMP.ID_PROVINCIA = RE.ID_REGION
INNER JOIN LO_REGION_I18N REI ON RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA='ch'
INNER JOIN LO_REGION_ADM1 REIAD ON RE.ID_REGION_ADM1 = REIAD.ID_REGION_ADM1
LEFT JOIN LO_POBLACION_FR PO ON EMP.ID_POBLACION = PO.ID_POBLACION
AND PO.IDIOMA='ch'
INNER JOIN LO_SECTORES SEC ON EMP.ID_SECTOR = SEC.ID_SECTOR
INNER JOIN LO_SECTORES_I18N SECI ON SEC.ID_SECTOR = SECI.ID_SECTOR
AND (SECI.ID_TROPIC = 46
AND SECI.FK_ID_IDIOMA_SI18N = 'ch')
INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
AND (GRU.ID_TROPIC = 46)
WHERE EMP.ID_MADRE = 19864699
AND EMP.EMP_MADRE IN(2,4)
AND EMP.VALID IN ('1', '-3');
Tiempo de la consulta:
0.0040709972381592Tiempo acumulado:0.11330795288086
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[14]: SELECT ID_EMPRESA, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_EMPRESA = 19864699;
Tiempo de la consulta:
0.0075521469116211Tiempo acumulado:0.12086009979248
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[15]: SELECT SEC.EXCLUYE_ALOJAMIENTO
FROM LO_SECTORES SEC
WHERE ID_SECTOR = 51
AND EXCLUYE_ALOJAMIENTO = 0;
Tiempo de la consulta:
0.0029120445251465Tiempo acumulado:0.12377214431763
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[16]: SELECT count(*)*2 AS N_OPIS, ROUND(AVG(VALORACION),2) AS VALORACION, ROUND(AVG(PRECIO),2) AS PRECIO, ROUND(AVG(RIESGO),2) AS RIESGO, ROUND(AVG(ATENCION),2) AS ATENCION, ROUND(AVG(PAREJA),2) AS PAREJA, ROUND(AVG(AMIGOS),2) AS AMIGOS, ROUND(AVG(TEAMBUILDING),2) AS TEAMBUILDING, ROUND(AVG(FAMILIA),2) AS FAMILIA, ROUND(AVG(NINOS),2) AS NINOS, ROUND(AVG(DESPEDIDAS),2) AS DESPEDIDAS, ROUND(AVG(REGALAR),2) AS REGALAR
FROM LO_EMPRESAS_OPINIONES_GOOGLE
WHERE ID_EMPRESA = 19864699;
Tiempo de la consulta:
0.011296033859253Tiempo acumulado:0.13506817817688
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[17]: SELECT TITULO_PRE,DESCRIPCION_PRE,INCLUYE_PRE,ALOJAMIENTO_TEXT_PRE,TRANSPORTE_TEXT_PRE,GALERIA_PRE,GALERIA_DESC_PRE,HORARIO_PRE, DURACION_PRE, PRE.ID_PRECIO ,SECI.ID_SECTOR, SECI.URL URL_SECTOR,REI.URL URL_REGION, PRE.FK_ID_PAIS_PRE AS ID_PAIS,
/*LEAST(if(PRECIO_MIN_PRE>0,PRECIO_MIN_PRE,PRECIO_PRE),PRECIO_PRE) PRECIO,*/
if(PRECIO_PD>0,LEAST(MIN(PRECIO_PD),PRECIO_PRE),LEAST(999999999,PRECIO_PRE) ) PRECIO_D,
IF(PD.PRECIO_PD > 0
AND PD.VALID_PD = 1,
LEAST(MIN(PD.PRECIO_PD), PRE.PRECIO_PRE),
LEAST(999999999, PRECIO_PRE)) AS PRECIO,
PRECIO_PRE, COUNT(DISTINCT RC.ID_RESERVA_COMPRA) AS VENTAS,
IF(PD.PRECIO_PD > 0
AND PD.VALID_PD = 1,
(1 - (MIN(PD.PRECIO_PD) / PRE.PRECIO_PRE))*100 , 0) AS DESCUENTO,
DESCUENTO_MIN_PRE DESCUENTO, PRE.FOTOPRINCIPAL_PRE,PRE.PRECIO_UNITARIO_PRE,
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,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%Y/%m/%d') AS FECHA,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%d') AS DIA_COM,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%m') AS MES_COM,
OP.VALORACION,COUNT(OP.ID_OPINION) AS OPIS, PD.OFERTA_PD,VALID_PD,
PRE.MIN_PERS_PRE,
MIN(PD.MIN_PERSONAS_PD) AS MIN_PERSONAS_PD,
PRE.MAX_PERS_PRE,
MAX(PD.MAX_PERSONAS_PD) AS MAX_PERSONAS_PD,
PRE.ALOJAMIENTO_PRE, PRE.FK_ID_PAIS_PRE AS ID_PAIS,
PRE.COMIDA_PRE,PRE.TRANSPORTE_PRE,REI.DESC_REGION, PRE.MULTIACTIVIDAD_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, SECI.DESC_SECTOR
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'ch'
INNER JOIN LO_PRECIOS_SECTORES SECP ON PRE.ID_PRECIO=SECP.ID_PRECIO_PS
INNER JOIN LO_REGION_I18N REI ON PRE.ID_REGION_PRE=REI.ID_REGION
INNER JOIN LO_SECTORES_I18N SECI ON SECP.ID_ACTIVIDAD_PS=SECI.ID_SECTOR
INNER JOIN LO_SECTORES SEC ON SECI.ID_SECTOR=SEC.ID_SECTOR
LEFT JOIN LO_RESERVAS_COMPRAS RC ON RC.ID_PRECIO_RC = PRE.ID_PRECIO
AND RC.VALID_RC NOT IN(0,2,6,7)
LEFT JOIN LO_PRECIOS_DESCUENTOS PD ON PD.ID_PRECIO_PD = PRE.ID_PRECIO
AND PD.VALID_PD = 1
LEFT JOIN LO_EMPRESAS_OPINIONES OP ON OP.RESERVA_FEEDBACK = RC.ID_RESERVA_COMPRA
AND OP.VALID=1
LEFT JOIN LO_PRECIOS_RESTRICCIONES PR ON PRE.ID_PRECIO = PR.ID_PRECIO
WHERE SECI.ID_TROPIC='46'
AND SECI.FK_ID_IDIOMA_SI18N='ch'
AND REI.IDIOMA='ch'
AND VALID_PRE IN(4)
AND PRE.ID_EMPRESA_PRE ='19864699'
AND (PR.FICHA = 0 OR PR.FICHA IS NULL OR IF(PR.FECHA_INICIO IS NOT NULL, CONCAT(DATE_FORMAT(NOW(), '%Y-'), DATE_FORMAT(PR.FECHA_INICIO, '%m-%d')) <= CONCAT(DATE_FORMAT(NOW(), '%Y-'), DATE_FORMAT(NOW(), '%m-%d'))
AND IF(DATE_FORMAT(PR.FECHA_FIN, '%m') >= DATE_FORMAT(PR.FECHA_INICIO, '%m'), CONCAT(DATE_FORMAT(NOW(), '%Y-'), DATE_FORMAT(PR.FECHA_FIN, '%m-%d')) >= CONCAT(DATE_FORMAT(NOW(), '%Y-'), DATE_FORMAT(NOW(), '%m-%d')), CONCAT((1+ DATE_FORMAT(NOW(), '%Y')),'-', DATE_FORMAT(PR.FECHA_FIN, '%m-%d')) >= CONCAT(DATE_FORMAT(NOW(), '%Y'),'-', DATE_FORMAT(NOW(), '%m-%d'))),1!=1))
GROUP BY PRE.ID_PRECIO
ORDER BY VENTAS desc, N_ORDER_EMP_PRE IS NULL ASC,N_ORDER_EMP_PRE ASC, OFERTA_PD DESC, N_ORDER_PRE DESC,PRECIO ASC
LIMIT 4;
Tiempo de la consulta:
0.016255140304565Tiempo acumulado:0.15132331848145
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[18]: SELECT '1', RE.ID_REGION, REI.ID_REGION, REI.DESC_REGION, REI.URL URL_REGION, RE.ID_REGION_ADM1, RE.ID_PAIS, LATITUDE, LONGITUDE
FROM LO_REGION RE
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = RE.ID_REGION
WHERE RE.ID_REGION = '424'
AND REI.IDIOMA = 'ch';
Tiempo de la consulta:
0.0041801929473877Tiempo acumulado:0.15550351142883
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[19]: SELECT IF(EMP.TIPOCUENTA = '4',
ROUND((RAND() * (500-400))+500),
IF(EMP.TIPOCUENTA = '3',
ROUND((RAND() * (400-300))+400),
IF(EMP.TIPOCUENTA = '2'
AND EMP.PRECIO_ACTIVIDAD != 0,
ROUND((RAND() * (300-400))+300),
0))) AS ORDENA,
EMP.EMP_MADRE,EMP.PUNTOS, EMP.ID_EMPRESA, EMP.ID_MADRE, EMP.DESCRIPCION,EMP.COLAB_EMPRESAS,EMP.CLIENTE , EMP.ID_PROVINCIA, EMP.ID_POBLACION,
EMP.COD_POSTAL, EMP.DIRECCION, EMP.MAIL, EMP.TELEFONO, EMP.TELEFONOMOVIL, EMP.FAX, EMP.WEB,SECI.URL URL_SECTOR,
REI.DESC_REGION, PO.DESC_POBLACION, SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO, EMP.GALERIA, EMP.GALERIA_DESC, EMP.LONGITUDE, EMP.LATITUDE, EMP.LOGOTIPO, EMP.FOTOPRINCIPAL, EMP.PROMOSECTOR
,EMP.PRECIO_ACTIVIDAD,EMP.TIPOCUENTA,
ET.DESCRIPCION_ET DESCRIPCION,GALERIA_DESC_ET GALERIA_DESC,VIDEOS_TEXT_ET VIDEOS_TEXT,VIDEOS_DESC_ET VIDEOS_DESC,COMO_LLEGAR_ET COMO_LLEGAR,URL_ET URL, EMP.NOMBRE NOMBRE, ET.EVENT_PLANNING EVENT_PLANNING,
GRU.DESC_GRUPO
FROM LO_EMPRESAS EMP
INNER JOIN LO_EMPRESAS_TRADUCCION_CH ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'ch'
INNER JOIN LO_REGION RE ON RE.ID_REGION=EMP.ID_PROVINCIA
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=RE.ID_REGION
AND REI.IDIOMA='ch'
LEFT JOIN LO_POBLACION_FR PO ON PO.ID_POBLACION=EMP.ID_POBLACION
AND PO.IDIOMA='ch'
/*
LEFT JOIN LO_POBLACION_I18N POI ON POI.ID_POBLACION=PO.ID_POBLACION */
INNER JOIN LO_SECTORES SEC ON SEC.ID_SECTOR=EMP.ID_SECTOR
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR=SEC.ID_SECTOR
AND SECI.ID_TROPIC='46'
AND SECI.FK_ID_IDIOMA_SI18N='ch'
AND EMP.EMP_MADRE <> '0'
AND SEC.ID_SECTOR='51'
INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
AND GRU.ID_TROPIC = '46'
/*
LEFT JOIN LO_EMPRESAS_SNIPPETS_RELACIONES ESR ON ESR.ID_EMPRESA = EMP.ID_EMPRESA
AND ESR.ID_TROPIC = '46' */
WHERE EMP.VALID=1
AND EMP.ID_EMPRESA > '19864699'
AND EMP.ID_PROVINCIA='424'
AND EMP.EMP_MADRE <> '3'
GROUP BY EMP.ID_EMPRESA
ORDER BY EMP.ID_EMPRESA ASC
LIMIT 4;
Tiempo de la consulta:
0.0074429512023926Tiempo acumulado:0.16294646263123
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[20]: SELECT GALERIA,GALERIA_DESC
FROM LO_EMPRESAS_OPINIONES OP
WHERE (OP.ID_EMPRESA='19864699'
OR OP.ID_MADRE='19864699' )
AND OP.VALID=1
AND GALERIA IS NOT NULL
AND GALERIA NOT IN('')
ORDER BY OP.FEC_INSERT DESC;
Tiempo de la consulta:
0.0022428035736084Tiempo acumulado:0.16518926620483
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[21]: SELECT EMP_MADRE, ID_MADRE, ID_SECTOR
FROM LO_EMPRESAS EMP
INNER JOIN LO_EMPRESAS_TRADUCCION_CH ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'ch'
WHERE EMP.ID_EMPRESA = 19864699;
Tiempo de la consulta:
0.0098118782043457Tiempo acumulado:0.17500114440918
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[22]: SELECT PRECIO_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, PRECIO_PD,
ID_DESCUENTO_PD,ID_PRECIO,DATE_FORMAT(FECHA_CADUCIDAD_PD,'%d/%m/%Y') FEC_CAD,
INCLUYE_PRE,GALERIA_PRE,FOTOPRINCIPAL_PRE,PRECIO_PRE,
EMP.URL URL,SECI.URL URL_SECTOR,REI.URL URL_REGION,
if(PRECIO_PD>0,LEAST(MIN(PRECIO_PD),PRECIO_PRE),LEAST(999999999,PRECIO_PRE) ) PRECIO,
if(PRECIO_PD>0, (1-(MIN(PRECIO_PD)/PRECIO_PRE))*100 ,0) DESCUENTO
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'ch'
INNER JOIN LO_PRECIOS_SECTORES SECP ON PRE.ID_PRECIO=SECP.ID_PRECIO_PS
INNER JOIN LO_PRECIOS_DESCUENTOS PD ON PRE.ID_PRECIO=PD.ID_PRECIO_PD
INNER JOIN LO_EMPRESAS EMP ON PRE.ID_EMPRESA_PRE=EMP.ID_EMPRESA
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
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PRE.ID_REGION_PRE
INNER JOIN LO_POBLACION_I18N POI ON POI.ID_POBLACION=PRE.ID_POBLACION_PRE
WHERE SECI.ID_TROPIC='46'
AND SECI.FK_ID_IDIOMA_SI18N='ch'
AND REI.IDIOMA='ch'
AND ID_EMPRESA='19864699'
AND VALID_PD=1
AND OFERTA_PD=1
AND SECP.ID_ACTIVIDAD_PS = 51
AND PRE.VALID_PRE = 4
ORDER BY FECHA_CADUCIDAD_PD DESC
LIMIT 1;
Tiempo de la consulta:
0.0018949508666992Tiempo acumulado:0.17689609527588
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[23]: SELECT URL, ET.DESCRIPCION_ET DESCRIPCION,GALERIA_DESC_ET GALERIA_DESC,VIDEOS_TEXT_ET VIDEOS_TEXT,VIDEOS_DESC_ET VIDEOS_DESC,COMO_LLEGAR_ET COMO_LLEGAR,URL_ET URL, EMP.NOMBRE NOMBRE, ET.EVENT_PLANNING EVENT_PLANNING, ID_EMPRESA
FROM LO_EMPRESAS EMP
INNER JOIN LO_EMPRESAS_TRADUCCION_CH ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'ch'
WHERE EMP.ID_EMPRESA = 19864699;
Tiempo de la consulta:
0.0045840740203857Tiempo acumulado:0.18148016929626
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[24]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.ID_PAIS = 64
AND IDIOMA = 'ch';
Tiempo de la consulta:
0.0015580654144287Tiempo acumulado:0.18303823471069
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[25]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.`URL` AS URL_REGION, REIA.ID_REGION_ADM1, REIA.DESC_REGION AS DESC_ADM,
REIA.`URL` AS URL_ADM, P.ID_PAIS, P.DESC_PAIS, P.`URL` AS URL_PAIS
FROM LO_EMPRESAS EMP
INNER JOIN LO_REGION RE ON RE.ID_REGION = EMP.ID_PROVINCIA
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'ch'
LEFT JOIN LO_REGION_ADM1_I18N REIA ON REIA.ID_REGION_ADM1 = RE.ID_REGION_ADM1
AND REIA.IDIOMA = 'ch'
AND (SELECT COUNT(RE2.ID_REGION)
FROM LO_REGION RE2
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = RE2.ID_REGION
AND REI.IDIOMA = 'ch'
WHERE RE2.ID_REGION_ADM1 = RE.ID_REGION_ADM1) > 1
INNER JOIN LO_PAIS_I18N P ON P.ID_PAIS = RE.ID_PAIS
AND P.IDIOMA = 'ch'
WHERE EMP.ID_EMPRESA = 19864699;
Tiempo de la consulta:
0.0013840198516846Tiempo acumulado:0.18442225456238
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[26]: SELECT *
FROM LO_REGION_ADM1_STATS RS
WHERE RS.ID_SECTOR = 51
AND RS.ID_REGION_ADM1 = 41
AND N_OFERTAS > 0;
Tiempo de la consulta:
0.010823011398315Tiempo acumulado:0.19524526596069
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[27]: SELECT *
FROM LO_REGION_STATS RS
WHERE RS.ID_SECTOR = 51
AND RS.ID_REGION = 424
AND ID_GRUPO = 0
AND ID_SUBSECTOR = 0
AND N_OFERTAS > 0;
Tiempo de la consulta:
0.002946138381958Tiempo acumulado:0.19819140434265
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[28]: SELECT *
FROM LO_POBLACION_FR_STATS P
WHERE P.ID_SECTOR = 51
AND ID_POBLACION = 9414
AND N_OFERTAS > 0;
Tiempo de la consulta:
0.0046610832214355Tiempo acumulado:0.20285248756409
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[29]: SELECT URL AS URL_REGION, SIMCAPN, ID_CAPITAL
FROM LO_REGION_I18N REI
INNER JOIN LO_REGION RE ON RE.ID_REGION = REI.ID_REGION
WHERE REI.ID_REGION = 424
AND REI.IDIOMA = 'fr';
Tiempo de la consulta:
0.00048112869262695Tiempo acumulado:0.20333361625671
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[30]: SELECT URL_POBLACION, ID_POBLACION
FROM LO_POBLACION_FR PO
WHERE PO.ID_POBLACION = 9414
AND PO.IDIOMA = 'fr';
Tiempo de la consulta:
0.010828018188477Tiempo acumulado:0.21416163444519
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[31]: SELECT URL, ET.DESCRIPCION_ET DESCRIPCION,GALERIA_DESC_ET GALERIA_DESC,VIDEOS_TEXT_ET VIDEOS_TEXT,VIDEOS_DESC_ET VIDEOS_DESC,COMO_LLEGAR_ET COMO_LLEGAR,URL_ET URL, EMP.NOMBRE NOMBRE, ET.EVENT_PLANNING EVENT_PLANNING, ID_EMPRESA
FROM LO_EMPRESAS EMP
INNER JOIN LO_EMPRESAS_TRADUCCION_CH ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'ch'
WHERE EMP.ID_EMPRESA = 19864699;
Tiempo de la consulta:
0.007451057434082Tiempo acumulado:0.22161269187927
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[32]: SELECT OLD_URL, NEW_URL
FROM LO_URL_301 U
WHERE U.OLD_URL = '/zh-hans/cheng-chuan-you-lan/goelette-alliance--e19864699';
Tiempo de la consulta:
0.0011038780212402Tiempo acumulado:0.22271656990051
(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 = 'fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00066494941711426Tiempo acumulado:0.22338151931763
(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 = 'fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00048613548278809Tiempo acumulado:0.22386765480042
(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 = 'fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00084805488586426Tiempo acumulado:0.22471570968628
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[36]: SELECT EMP.ID_EMPRESA, EMP.EMP_MADRE, EMP.ID_MADRE, EMP.URL, EMP.NOMBRE, EMP.MAIL, EMP.ID_PAIS,
EMP.LOGIN, EMP.PASSWORD, EMP.PASSCODE, EMP.VALID,
EMP.ID_SECTOR,
SEC.ID_GRUPO,
SECI.URL AS URL_SECTOR, SECI.DESC_SECTOR
FROM Prod_Yumping_fr_FR.LO_EMPRESAS EMP
LEFT JOIN Prod_Yumping_fr_FR.LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
LEFT JOIN Prod_Yumping_fr_FR.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND (SECI.ID_TROPIC = 4
AND SECI.FK_ID_IDIOMA_SI18N = 'fr')
WHERE EMP.ID_EMPRESA = 19864699;
Tiempo de la consulta:
0.00062894821166992Tiempo acumulado:0.22534465789795
(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 = 'fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_empresa_trad'
AND CFG.AMBITO IN ('fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0012848377227783Tiempo acumulado:0.22662949562073
(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 = 'fr_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('fr_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0014331340789795Tiempo acumulado:0.22806262969971
(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 = 'fr_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('fr_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004880428314209Tiempo acumulado:0.22855067253113
(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 = 'fr_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('fr_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0046219825744629Tiempo acumulado:0.23317265510559
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[41]: SELECT EMP.ID_EMPRESA, EMP.EMP_MADRE, EMP.ID_MADRE, EMP.URL, EMP.NOMBRE, EMP.MAIL, EMP.ID_PAIS,
EMP.LOGIN, EMP.PASSWORD, EMP.PASSCODE, EMP.VALID,
EMP.ID_SECTOR,
SEC.ID_GRUPO,
SECI.URL AS URL_SECTOR, SECI.DESC_SECTOR
FROM Prod_Yumping_fr_FR.LO_EMPRESAS EMP
LEFT JOIN Prod_Yumping_fr_FR.LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
LEFT JOIN Prod_Yumping_fr_FR.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND (SECI.ID_TROPIC = 42
AND SECI.FK_ID_IDIOMA_SI18N = 'en')
WHERE EMP.ID_EMPRESA = 19864699;
Tiempo de la consulta:
0.0019130706787109Tiempo acumulado:0.2350857257843
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[42]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_empresa_trad'
AND CFG.AMBITO IN ('fr_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045490264892578Tiempo acumulado:0.23554062843323
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[43]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('fr_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043320655822754Tiempo acumulado:0.23597383499146
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[44]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('fr_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0016319751739502Tiempo acumulado:0.23760581016541
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[45]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('fr_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045585632324219Tiempo acumulado:0.23806166648865
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[46]: SELECT EMP.ID_EMPRESA, EMP.EMP_MADRE, EMP.ID_MADRE, EMP.URL, EMP.NOMBRE, EMP.MAIL, EMP.ID_PAIS,
EMP.LOGIN, EMP.PASSWORD, EMP.PASSCODE, EMP.VALID,
EMP.ID_SECTOR,
SEC.ID_GRUPO,
SECI.URL AS URL_SECTOR, SECI.DESC_SECTOR
FROM Prod_Yumping_fr_FR.LO_EMPRESAS EMP
LEFT JOIN Prod_Yumping_fr_FR.LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
LEFT JOIN Prod_Yumping_fr_FR.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND (SECI.ID_TROPIC = 41
AND SECI.FK_ID_IDIOMA_SI18N = 'es')
WHERE EMP.ID_EMPRESA = 19864699;
Tiempo de la consulta:
0.00067687034606934Tiempo acumulado:0.23873853683472
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[47]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_empresa_trad'
AND CFG.AMBITO IN ('fr_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00060701370239258Tiempo acumulado:0.23934555053711
(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_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('fr_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049209594726562Tiempo acumulado:0.23983764648438
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[49]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('fr_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047588348388672Tiempo acumulado:0.24031352996826
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[50]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('fr_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00079798698425293Tiempo acumulado:0.24111151695251
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[51]: SELECT EMP.ID_EMPRESA, EMP.EMP_MADRE, EMP.ID_MADRE, EMP.URL, EMP.NOMBRE, EMP.MAIL, EMP.ID_PAIS,
EMP.LOGIN, EMP.PASSWORD, EMP.PASSCODE, EMP.VALID,
EMP.ID_SECTOR,
SEC.ID_GRUPO,
SECI.URL AS URL_SECTOR, SECI.DESC_SECTOR
FROM Prod_Yumping_fr_FR.LO_EMPRESAS EMP
LEFT JOIN Prod_Yumping_fr_FR.LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
LEFT JOIN Prod_Yumping_fr_FR.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND (SECI.ID_TROPIC = 43
AND SECI.FK_ID_IDIOMA_SI18N = 'it')
WHERE EMP.ID_EMPRESA = 19864699;
Tiempo de la consulta:
0.0032398700714111Tiempo acumulado:0.24435138702393
(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 = 'fr_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_empresa_trad'
AND CFG.AMBITO IN ('fr_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0033109188079834Tiempo acumulado:0.24766230583191
(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 = '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.00063800811767578Tiempo acumulado:0.24830031394958
(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 = 'fr_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('fr_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0012211799621582Tiempo acumulado:0.24952149391174
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[55]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = '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.0009009838104248Tiempo acumulado:0.25042247772217
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[56]: SELECT EMP.ID_EMPRESA, EMP.EMP_MADRE, EMP.ID_MADRE, EMP.URL, EMP.NOMBRE, EMP.MAIL, EMP.ID_PAIS,
EMP.LOGIN, EMP.PASSWORD, EMP.PASSCODE, EMP.VALID,
EMP.ID_SECTOR,
SEC.ID_GRUPO,
SECI.URL AS URL_SECTOR, SECI.DESC_SECTOR
FROM Prod_Yumping_fr_FR.LO_EMPRESAS EMP
LEFT JOIN Prod_Yumping_fr_FR.LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
LEFT JOIN Prod_Yumping_fr_FR.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND (SECI.ID_TROPIC = 47
AND SECI.FK_ID_IDIOMA_SI18N = 'de')
WHERE EMP.ID_EMPRESA = 19864699;
Tiempo de la consulta:
0.0043361186981201Tiempo acumulado:0.25475859642029
(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 = 'fr_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_empresa_trad'
AND CFG.AMBITO IN ('fr_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.002687931060791Tiempo acumulado:0.25744652748108
(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 = 'fr_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('fr_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004730224609375Tiempo acumulado:0.25791954994202
(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 = 'fr_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('fr_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.005871057510376Tiempo acumulado:0.26379060745239
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[60]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('fr_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0029709339141846Tiempo acumulado:0.26676154136658
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[61]: SELECT EMP.ID_EMPRESA, EMP.EMP_MADRE, EMP.ID_MADRE, EMP.URL, EMP.NOMBRE, EMP.MAIL, EMP.ID_PAIS,
EMP.LOGIN, EMP.PASSWORD, EMP.PASSCODE, EMP.VALID,
EMP.ID_SECTOR,
SEC.ID_GRUPO,
SECI.URL AS URL_SECTOR, SECI.DESC_SECTOR
FROM Prod_Yumping_fr_FR.LO_EMPRESAS EMP
LEFT JOIN Prod_Yumping_fr_FR.LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
LEFT JOIN Prod_Yumping_fr_FR.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND (SECI.ID_TROPIC = 48
AND SECI.FK_ID_IDIOMA_SI18N = 'pt')
WHERE EMP.ID_EMPRESA = 19864699;
Tiempo de la consulta:
0.0106360912323Tiempo acumulado:0.27739763259888
(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 = 'fr_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_empresa_trad'
AND CFG.AMBITO IN ('fr_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0038068294525146Tiempo acumulado:0.28120446205139
(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 = 'fr_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('fr_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0051658153533936Tiempo acumulado:0.28637027740479
(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 = 'fr_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('fr_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0049188137054443Tiempo acumulado:0.29128909111023
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[65]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('fr_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00384521484375Tiempo acumulado:0.29513430595398
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[66]: SELECT EMP.ID_EMPRESA, EMP.EMP_MADRE, EMP.ID_MADRE, EMP.URL, EMP.NOMBRE, EMP.MAIL, EMP.ID_PAIS,
EMP.LOGIN, EMP.PASSWORD, EMP.PASSCODE, EMP.VALID,
EMP.ID_SECTOR,
SEC.ID_GRUPO,
SECI.URL AS URL_SECTOR, SECI.DESC_SECTOR
FROM Prod_Yumping_fr_FR.LO_EMPRESAS EMP
LEFT JOIN Prod_Yumping_fr_FR.LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
LEFT JOIN Prod_Yumping_fr_FR.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND (SECI.ID_TROPIC = 45
AND SECI.FK_ID_IDIOMA_SI18N = 'es')
WHERE EMP.ID_EMPRESA = 19864699;
Tiempo de la consulta:
0.0011589527130127Tiempo acumulado:0.29629325866699
(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 = 'fr_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_empresa_trad'
AND CFG.AMBITO IN ('fr_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00083494186401367Tiempo acumulado:0.29712820053101
(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 = 'fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0039329528808594Tiempo acumulado:0.30106115341187
(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 = 'fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0030090808868408Tiempo acumulado:0.30407023429871
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[70]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0037908554077148Tiempo acumulado:0.30786108970642
(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 = 'fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.005836009979248Tiempo acumulado:0.31369709968567
(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 = 'fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0098159313201904Tiempo acumulado:0.32351303100586
(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 = 'fr_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0011129379272461Tiempo acumulado:0.32462596893311
(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 = 'fr_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0086760520935059Tiempo acumulado:0.33330202102661
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[75]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046992301940918Tiempo acumulado:0.33377194404602
(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 = 'fr_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0006709098815918Tiempo acumulado:0.33444285392761
(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 = 'fr_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('fr_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0043659210205078Tiempo acumulado:0.33880877494812
(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 = 'fr_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0032401084899902Tiempo acumulado:0.34204888343811
(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 = 'fr_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0080840587615967Tiempo acumulado:0.35013294219971
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[80]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain'
AND CFG.AMBITO IN ('fr_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0051219463348389Tiempo acumulado:0.35525488853455
(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 = 'fr_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0046520233154297Tiempo acumulado:0.35990691184998
(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 = 'fr_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0020878314971924Tiempo acumulado:0.36199474334717
(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 = 'fr_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('fr_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049996376037598Tiempo acumulado:0.36249470710754
(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 = 'fr_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0026061534881592Tiempo acumulado:0.3651008605957
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[85]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'fr_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041794776916504Tiempo acumulado:0.36551880836487
(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 = 'fr_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00056004524230957Tiempo acumulado:0.36607885360718
(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 = 'fr_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00052690505981445Tiempo acumulado:0.36660575866699
(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 = 'fr_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('fr_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00055885314941406Tiempo acumulado:0.36716461181641
(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 = 'fr_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00074601173400879Tiempo acumulado:0.36791062355042
(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 = 'fr_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0012710094451904Tiempo acumulado:0.36918163299561
(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 = 'fr_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0012111663818359Tiempo acumulado:0.37039279937744
(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 = 'fr_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00089883804321289Tiempo acumulado:0.37129163742065
(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 = '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.00083684921264648Tiempo acumulado:0.3721284866333
(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 = 'fr_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047016143798828Tiempo acumulado:0.37259864807129
(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 = 'fr_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00044798851013184Tiempo acumulado:0.37304663658142
(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 = 'fr_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004270076751709Tiempo acumulado:0.37347364425659
(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 = 'fr_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043106079101562Tiempo acumulado:0.37390470504761
(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 = 'fr_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('fr_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00055789947509766Tiempo acumulado:0.37446260452271
(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 = 'fr_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045299530029297Tiempo acumulado:0.374915599823
(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 = 'fr_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046014785766602Tiempo acumulado:0.37537574768066
(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 = 'fr_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0011801719665527Tiempo acumulado:0.37655591964722
(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 = 'fr_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0013630390167236Tiempo acumulado:0.37791895866394
(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 = 'fr_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('fr_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00054502487182617Tiempo acumulado:0.37846398353577
(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 = 'fr_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('fr_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0010340213775635Tiempo acumulado:0.37949800491333
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[105]: SELECT URL, ET.DESCRIPCION_ET DESCRIPCION,GALERIA_DESC_ET GALERIA_DESC,VIDEOS_TEXT_ET VIDEOS_TEXT,VIDEOS_DESC_ET VIDEOS_DESC,COMO_LLEGAR_ET COMO_LLEGAR,URL_ET URL, EMP.NOMBRE NOMBRE, ET.EVENT_PLANNING EVENT_PLANNING, ID_EMPRESA
FROM LO_EMPRESAS EMP
INNER JOIN LO_EMPRESAS_TRADUCCION_CH ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'ch'
WHERE EMP.ID_EMPRESA = 19864699;
Tiempo de la consulta:
0.0016400814056396Tiempo acumulado:0.38113808631897
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[106]: SELECT ID_EMPRESA, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_EMPRESA = 19864699;
Tiempo de la consulta:
0.0031960010528564Tiempo acumulado:0.38433408737183
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[107]: SELECT ID_EMPRESA, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_EMPRESA = 19864699;
Tiempo de la consulta:
0.0021440982818604Tiempo acumulado:0.38647818565369
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[108]: SELECT ID_EMPRESA, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_EMPRESA = 19864699;
Tiempo de la consulta:
0.00046491622924805Tiempo acumulado:0.38694310188293
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[109]: SELECT ID_EMPRESA, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_EMPRESA = 19864699;
Tiempo de la consulta:
0.00037503242492676Tiempo acumulado:0.38731813430786
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[110]: SELECT ID_EMPRESA, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_EMPRESA = 19864699;
Tiempo de la consulta:
0.0032510757446289Tiempo acumulado:0.39056921005249
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[111]: SELECT MIN(MIN_PRECIO) AS MIN_PRECIO, MAX(MAX_PRECIO) AS MAX_PRECIO
FROM
(
SELECT MIN(PRE.PRECIO_PRE) MIN_PRECIO, MAX(PRE.PRECIO_PRE) MAX_PRECIO
FROM LO_PRECIOS PRE
INNER JOIN LO_EMPRESAS EMP ON PRE.ID_EMPRESA_PRE = EMP.ID_EMPRESA
WHERE EMP.ID_EMPRESA = 19864699
AND EMP.VALID IN (1,-3)
AND PRE.VALID_PRE = 4
UNION ALL
SELECT MIN(PD.PRECIO_PD) MIN_PRECIO, MAX(PD.PRECIO_PD) MAX_PRECIO
FROM LO_PRECIOS PRE
INNER JOIN LO_EMPRESAS EMP ON PRE.ID_EMPRESA_PRE = EMP.ID_EMPRESA
INNER JOIN LO_PRECIOS_DESCUENTOS PD ON PRE.ID_PRECIO = PD.ID_PRECIO_PD
WHERE
EMP.ID_EMPRESA = 19864699
AND EMP.VALID IN (1,-3)
AND PRE.VALID_PRE = 4
AND PD.VALID_PD = 1
UNION ALL
SELECT EMP.PRECIO_ACTIVIDAD AS MIN_PRECIO, NULL MAX_PRECIO
FROM LO_EMPRESAS EMP
LEFT JOIN LO_PRECIOS PRE ON PRE.ID_EMPRESA_PRE = EMP.ID_EMPRESA
AND PRE.VALID_PRE = 4
WHERE EMP.ID_EMPRESA = 19864699 OR EMP.ID_MADRE = 19864699
AND EMP.VALID IN (1 ,- 3)
AND EMP.PRECIO_ACTIVIDAD !=0
) AS PRECIO_MIN_MAX;
Tiempo de la consulta:
0.0018880367279053Tiempo acumulado:0.3924572467804
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[112]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.0012369155883789Tiempo acumulado:0.39369416236877
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[113]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.00088882446289062Tiempo acumulado:0.39458298683167
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[114]: SELECT *
FROM LO_CASAS
WHERE ID_EMPRESA_CA='19864699'
AND VALID_CA=1
AND CLIENTE_CA=1
ORDER BY RAND()
LIMIT 1;
Tiempo de la consulta:
0.0021581649780273Tiempo acumulado:0.39674115180969
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[115]: SELECT *,(6378*acos(cos(radians('43.2962'))*cos(radians(LATITUD_CA))*cos(radians(LONGITUD_CA)-radians('5.36937')) +sin(radians('43.2962'))*sin(radians(LATITUD_CA)))) AS DISTANCIA
FROM LO_CASAS WHERE
VALID_CA=1
AND CLIENTE_CA=1
HAVING DISTANCIA < 30
LIMIT 10;
Tiempo de la consulta:
0.001460075378418Tiempo acumulado:0.39820122718811
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[116]: SELECT *
FROM LO_TOPRURAL_FR
WHERE FK_ID_EMPRESA_TR='19864699'
LIMIT 10;
Tiempo de la consulta:
0.0015370845794678Tiempo acumulado:0.39973831176758
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[117]: SELECT *,(6378*acos(cos(radians('43.2962'))*cos(radians(LATITUD_TR))*cos(radians(LONGITUD_TR)-radians('5.36937')) +sin(radians('43.2962'))*sin(radians(LATITUD_TR)))) AS DISTANCIA
FROM LO_TOPRURAL_FR
WHERE ID_PAIS_TR='64'
AND PRECIO_MEDIO_TR<>0
AND COMENTARIOS_TR<>''
AND DIRECCION_TR<>''
AND FK_ID_EMPRESA_TR<>'19864699'
HAVING DISTANCIA < 30
LIMIT 10;
Tiempo de la consulta:
0.048565149307251Tiempo acumulado:0.44830346107483
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[118]: SELECT COUNT(ID_REGALO) AS CUENTA
FROM LO_REGALOS
WHERE FK_ID_CUSTOMER_REGALO IN (SELECT ID_EMPRESA
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19864699
OR EMP.ID_MADRE= 19864699
AND EMP.VALID=1)
AND STATUS_REGALO='1'
LIMIT 3;
Tiempo de la consulta:
0.0057289600372314Tiempo acumulado:0.45403242111206
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[119]: SELECT ID_EMPRESA, NOMBRE,IF(EMP_MADRE = 0,GRU.URL,SECI.URL) AS URL_SECTOR, ID_MADRE, SECI.ID_SECTOR,
IF(EMP_MADRE = 0,GRU.DESC_GRUPO,SECI.DESC_SECTOR) AS DESC_SECTOR, EMP_MADRE
FROM LO_EMPRESAS EMP
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = EMP.ID_SECTOR
AND SECI.ID_TROPIC = 46
AND SECI.FK_ID_IDIOMA_SI18N = 'ch'
LEFT JOIN LO_GRUPOS GRU ON GRU.ID_SECTOR = EMP.ID_SECTOR
AND GRU.ID_TROPIC = 46
WHERE EMP.ID_EMPRESA = 19864699 OR EMP.ID_MADRE = 19864699
AND EMP.VALID = 1
AND EMP.EMP_MADRE NOT IN(1,3)
ORDER BY EMP_MADRE,DESC_SECTOR;
Tiempo de la consulta:
0.0038180351257324Tiempo acumulado:0.45785045623779
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[120]: SELECT URL, ET.DESCRIPCION_ET DESCRIPCION,GALERIA_DESC_ET GALERIA_DESC,VIDEOS_TEXT_ET VIDEOS_TEXT,VIDEOS_DESC_ET VIDEOS_DESC,COMO_LLEGAR_ET COMO_LLEGAR,URL_ET URL, EMP.NOMBRE NOMBRE, ET.EVENT_PLANNING EVENT_PLANNING, ID_EMPRESA
FROM LO_EMPRESAS EMP
INNER JOIN LO_EMPRESAS_TRADUCCION_CH ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'ch'
WHERE EMP.ID_EMPRESA = 19864699;
Tiempo de la consulta:
0.0035820007324219Tiempo acumulado:0.46143245697021
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[121]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864699
AND VALID = 1;
Tiempo de la consulta:
0.0087771415710449Tiempo acumulado:0.47020959854126
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[122]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864699
AND FOTO = 'e-19864699-beige-nude-business-organization-chart-55172078153417207815439810.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00049996376037598Tiempo acumulado:0.47070956230164
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[123]: SELECT EMP_MADRE, ID_MADRE, ID_SECTOR
FROM LO_EMPRESAS EMP
INNER JOIN LO_EMPRESAS_TRADUCCION_CH ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'ch'
WHERE EMP.ID_EMPRESA = 19864699;
Tiempo de la consulta:
0.00040698051452637Tiempo acumulado:0.47111654281616
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[124]: SELECT PRECIO_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, PRECIO_PD,
ID_DESCUENTO_PD,ID_PRECIO,DATE_FORMAT(FECHA_CADUCIDAD_PD,'%d/%m/%Y') FEC_CAD,
INCLUYE_PRE,GALERIA_PRE,FOTOPRINCIPAL_PRE,PRECIO_PRE,
EMP.URL URL,SECI.URL URL_SECTOR,REI.URL URL_REGION,
if(PRECIO_PD>0,LEAST(MIN(PRECIO_PD),PRECIO_PRE),LEAST(999999999,PRECIO_PRE) ) PRECIO,
if(PRECIO_PD>0, (1-(MIN(PRECIO_PD)/PRECIO_PRE))*100 ,0) DESCUENTO
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'ch'
INNER JOIN LO_PRECIOS_SECTORES SECP ON PRE.ID_PRECIO=SECP.ID_PRECIO_PS
INNER JOIN LO_PRECIOS_DESCUENTOS PD ON PRE.ID_PRECIO=PD.ID_PRECIO_PD
INNER JOIN LO_EMPRESAS EMP ON PRE.ID_EMPRESA_PRE=EMP.ID_EMPRESA
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
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PRE.ID_REGION_PRE
INNER JOIN LO_POBLACION_I18N POI ON POI.ID_POBLACION=PRE.ID_POBLACION_PRE
WHERE SECI.ID_TROPIC='46'
AND SECI.FK_ID_IDIOMA_SI18N='ch'
AND REI.IDIOMA='ch'
AND ID_EMPRESA='19864699'
AND VALID_PD=1
AND OFERTA_PD=1
AND SECP.ID_ACTIVIDAD_PS = 51
AND PRE.VALID_PRE = 4
ORDER BY FECHA_CADUCIDAD_PD DESC
LIMIT 1;
Tiempo de la consulta:
0.0013389587402344Tiempo acumulado:0.4724555015564
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[125]: SELECT N_VENTAS_EST, FEC_ULT_COMPRA
FROM LO_EMPRESAS_STAT
WHERE FK_ID_EST = 19864699
AND N_VENTAS_EST > 0
LIMIT 1;
Tiempo de la consulta:
0.0033118724822998Tiempo acumulado:0.4757673740387
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[126]: SELECT OP.GALERIA,OP.GALERIA_DESC, OP.RESERVA_FEEDBACK, OP.SOLICITUD_FEEDBACK,
COM.ID_USER,OP.ID_OPINION, COM.NOMBRE, DATE_FORMAT(OP.FEC_INSERT, '%d/%m/%y') AS FECHA
FROM LO_EMPRESAS_OPINIONES OP
INNER JOIN LO_COM_USERS COM ON COM.ID_USER = OP.ID_USER
WHERE (OP.ID_EMPRESA='19864699'
OR OP.ID_MADRE='19864699' )
AND OP.VALID=1
AND OP.GALERIA IS NOT NULL
AND OP.GALERIA NOT IN('')
ORDER BY OP.ID_OPINION DESC;
Tiempo de la consulta:
0.0052070617675781Tiempo acumulado:0.48097443580627
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[127]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864699
AND VALID = 1;
Tiempo de la consulta:
0.00066995620727539Tiempo acumulado:0.48164439201355
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[128]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864699
AND FOTO = 'e-19864699-14172077926117207814258160.jpeg'
AND VALID = 1;
Tiempo de la consulta:
0.0010230541229248Tiempo acumulado:0.48266744613647
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[129]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864699
AND FOTO = 'e-19864699-14172077926117207814258160.jpeg'
AND VALID=1;
Tiempo de la consulta:
0.00045013427734375Tiempo acumulado:0.48311758041382
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[130]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864699
AND FOTO = 'e-19864699-14172077926117207814258160.jpeg'
AND VALID=1;
Tiempo de la consulta:
0.00044608116149902Tiempo acumulado:0.48356366157532
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[131]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864699
AND VALID = 1;
Tiempo de la consulta:
0.0006859302520752Tiempo acumulado:0.48424959182739
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[132]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864699
AND FOTO = 'e-19864699-2172077923017207814239401.jpeg'
AND VALID = 1;
Tiempo de la consulta:
0.00050497055053711Tiempo acumulado:0.48475456237793
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[133]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864699
AND FOTO = 'e-19864699-2172077923017207814239401.jpeg'
AND VALID=1;
Tiempo de la consulta:
0.00044393539428711Tiempo acumulado:0.48519849777222
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[134]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864699
AND FOTO = 'e-19864699-2172077923017207814239401.jpeg'
AND VALID=1;
Tiempo de la consulta:
0.00042486190795898Tiempo acumulado:0.48562335968018
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[135]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864699
AND VALID = 1;
Tiempo de la consulta:
0.00057101249694824Tiempo acumulado:0.48619437217712
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[136]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864699
AND FOTO = 'e-19864699-7172077924017207814248404.jpeg'
AND VALID = 1;
Tiempo de la consulta:
0.00054597854614258Tiempo acumulado:0.48674035072327
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[137]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864699
AND FOTO = 'e-19864699-7172077924017207814248404.jpeg'
AND VALID=1;
Tiempo de la consulta:
0.00056195259094238Tiempo acumulado:0.48730230331421
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[138]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864699
AND FOTO = 'e-19864699-7172077924017207814248404.jpeg'
AND VALID=1;
Tiempo de la consulta:
0.0032260417938232Tiempo acumulado:0.49052834510803
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[139]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864699
AND VALID = 1;
Tiempo de la consulta:
0.0031368732452393Tiempo acumulado:0.49366521835327
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[140]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864699
AND FOTO = 'e-19864699-9172077925017207814248921.jpeg'
AND VALID = 1;
Tiempo de la consulta:
0.0035290718078613Tiempo acumulado:0.49719429016113
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[141]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864699
AND FOTO = 'e-19864699-9172077925017207814248921.jpeg'
AND VALID=1;
Tiempo de la consulta:
0.0062639713287354Tiempo acumulado:0.50345826148987
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[142]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864699
AND FOTO = 'e-19864699-9172077925017207814248921.jpeg'
AND VALID=1;
Tiempo de la consulta:
0.001284122467041Tiempo acumulado:0.50474238395691
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[143]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864699
AND VALID = 1;
Tiempo de la consulta:
0.00060391426086426Tiempo acumulado:0.50534629821777
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[144]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864699
AND FOTO = 'e-19864699-6172077923917207814266631.jpeg'
AND VALID = 1;
Tiempo de la consulta:
0.00045204162597656Tiempo acumulado:0.50579833984375
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[145]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864699
AND FOTO = 'e-19864699-6172077923917207814266631.jpeg'
AND VALID=1;
Tiempo de la consulta:
0.0016181468963623Tiempo acumulado:0.50741648674011
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[146]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864699
AND FOTO = 'e-19864699-6172077923917207814266631.jpeg'
AND VALID=1;
Tiempo de la consulta:
0.0017600059509277Tiempo acumulado:0.50917649269104
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[147]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864699
AND VALID = 1;
Tiempo de la consulta:
0.00057005882263184Tiempo acumulado:0.50974655151367
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[148]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864699
AND FOTO = 'e-19864699-c3172077927017207814279979.jpeg'
AND VALID = 1;
Tiempo de la consulta:
0.00048708915710449Tiempo acumulado:0.51023364067078
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[149]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864699
AND FOTO = 'e-19864699-c3172077927017207814279979.jpeg'
AND VALID=1;
Tiempo de la consulta:
0.00046086311340332Tiempo acumulado:0.51069450378418
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[150]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864699
AND FOTO = 'e-19864699-c3172077927017207814279979.jpeg'
AND VALID=1;
Tiempo de la consulta:
0.00044703483581543Tiempo acumulado:0.51114153862
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[151]: SELECT EMP_MADRE, ID_MADRE, ID_SECTOR
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19864699;
Tiempo de la consulta:
0.00036382675170898Tiempo acumulado:0.5115053653717
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[152]: SELECT PRE.ID_PRECIO,PRE.TITULO_PRE,
if(PRECIO_PD>0,LEAST(MIN(PRECIO_PD),PRECIO_PRE),LEAST(999999999,PRECIO_PRE) ) PRECIO, PRE.FOTOPRINCIPAL_PRE, PRE.FK_ID_PAIS_PRE AS ID_PAIS,
POI.URL_POBLACION, POI.DESC_POBLACION, POI.ID_POBLACION, REI.URL URL_REGION, REI.DESC_REGION,REI.ID_REGION, SECI.ID_SECTOR, SECI.URL URL_SECTOR, SECI.DESC_SECTOR,PRE.PRECIO_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, MULTIACTIVIDAD_PRE
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'ch'
LEFT JOIN LO_PRECIOS_DESCUENTOS PD ON PD.ID_PRECIO_PD = PRE.ID_PRECIO
AND PD.VALID_PD=1
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PRE.ID_REGION_PRE
AND REI.IDIOMA = 'ch'
INNER JOIN LO_POBLACION_FR POI ON POI.ID_POBLACION = PRE.ID_POBLACION_PRE
AND POI.IDIOMA = 'ch'
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.FK_ID_IDIOMA_SI18N='ch'
AND SECI.ID_TROPIC = 46
INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
LEFT JOIN LO_PRECIOS_RESTRICCIONES PR ON PRE.ID_PRECIO = PR.ID_PRECIO
WHERE EMP.ID_EMPRESA = 19864699
AND PRE.VALID_PRE = 4
AND (PR.FICHA = 0 OR PR.FICHA IS NULL OR IF(PR.FECHA_INICIO IS NOT NULL, CONCAT(DATE_FORMAT(NOW(), '%Y-'),DATE_FORMAT(PR.FECHA_INICIO, '%m-%d')) <= CONCAT(DATE_FORMAT(NOW(), '%Y-'),DATE_FORMAT(NOW(), '%m-%d'))
AND IF(DATE_FORMAT(PR.FECHA_FIN, '%m') >= DATE_FORMAT(PR.FECHA_INICIO, '%m'), CONCAT(DATE_FORMAT(NOW(), '%Y-'),DATE_FORMAT(PR.FECHA_FIN, '%m-%d')) >= CONCAT(DATE_FORMAT(NOW(), '%Y-'),DATE_FORMAT(NOW(), '%m-%d')), CONCAT( (1+DATE_FORMAT(NOW(), '%Y')),'-',DATE_FORMAT(PR.FECHA_FIN, '%m-%d')) >= CONCAT( DATE_FORMAT(NOW(), '%Y'),'-',DATE_FORMAT(NOW(), '%m-%d'))) ,1!=1) )
GROUP BY PRE.ID_PRECIO
ORDER BY N_VENTAS_PRE DESC, PRECIO ASC
LIMIT 3;
Tiempo de la consulta:
0.0024569034576416Tiempo acumulado:0.51396226882935
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[153]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 90048
AND VALID = 1;
Tiempo de la consulta:
0.0039641857147217Tiempo acumulado:0.51792645454407
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[154]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 90048
AND FOTO = 'p-90048-31720786799_1720788751127.jpeg'
AND VALID = 1;
Tiempo de la consulta:
0.00049495697021484Tiempo acumulado:0.51842141151428
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[155]: SELECT F_WIDTH, F_HEIGHT
FROM LO_FOTOS
WHERE ID_PRECIO = 90048
AND FOTO = 'p-90048-31720786799_1720788751127.jpeg';
Tiempo de la consulta:
0.00036096572875977Tiempo acumulado:0.51878237724304
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[156]: SELECT DATE_FORMAT(PRE.FEC_ULT_COMPRA, '%Y-%m-%d') AS FEC_ULT_COMPRA,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%d') AS DIA_COM,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%m') AS MES_COM
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'ch'
WHERE ID_PRECIO = 90048
AND VALID_PRE = 4
GROUP BY PRE.ID_PRECIO
HAVING FEC_ULT_COMPRA IS NOT NULL
LIMIT 1;
Tiempo de la consulta:
0.00044679641723633Tiempo acumulado:0.51922917366028
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[157]: SELECT URL_PRE, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, ID_PRECIO, FK_ID_PAIS_PRE
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'ch'
WHERE PRE.ID_PRECIO = 90048;
Tiempo de la consulta:
0.00060892105102539Tiempo acumulado:0.5198380947113
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[158]: 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 = 90048;
Tiempo de la consulta:
0.00099492073059082Tiempo acumulado:0.52083301544189
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[159]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 90047
AND VALID = 1;
Tiempo de la consulta:
0.00064611434936523Tiempo acumulado:0.52147912979126
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[160]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 90047
AND FOTO = 'p-90047-81720782375_17207860103074.jpeg'
AND VALID = 1;
Tiempo de la consulta:
0.00046801567077637Tiempo acumulado:0.52194714546204
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[161]: SELECT F_WIDTH, F_HEIGHT
FROM LO_FOTOS
WHERE ID_PRECIO = 90047
AND FOTO = 'p-90047-81720782375_17207860103074.jpeg';
Tiempo de la consulta:
0.00034809112548828Tiempo acumulado:0.52229523658752
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[162]: SELECT DATE_FORMAT(PRE.FEC_ULT_COMPRA, '%Y-%m-%d') AS FEC_ULT_COMPRA,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%d') AS DIA_COM,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%m') AS MES_COM
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'ch'
WHERE ID_PRECIO = 90047
AND VALID_PRE = 4
GROUP BY PRE.ID_PRECIO
HAVING FEC_ULT_COMPRA IS NOT NULL
LIMIT 1;
Tiempo de la consulta:
0.00041389465332031Tiempo acumulado:0.52270913124084
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[163]: SELECT URL_PRE, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, ID_PRECIO, FK_ID_PAIS_PRE
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'ch'
WHERE PRE.ID_PRECIO = 90047;
Tiempo de la consulta:
0.00048089027404785Tiempo acumulado:0.52319002151489
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[164]: 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 = 90047;
Tiempo de la consulta:
0.00045013427734375Tiempo acumulado:0.52364015579224
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[165]: SELECT URL, ET.DESCRIPCION_ET DESCRIPCION,GALERIA_DESC_ET GALERIA_DESC,VIDEOS_TEXT_ET VIDEOS_TEXT,VIDEOS_DESC_ET VIDEOS_DESC,COMO_LLEGAR_ET COMO_LLEGAR,URL_ET URL, EMP.NOMBRE NOMBRE, ET.EVENT_PLANNING EVENT_PLANNING, ID_EMPRESA
FROM LO_EMPRESAS EMP
INNER JOIN LO_EMPRESAS_TRADUCCION_CH ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'ch'
WHERE EMP.ID_EMPRESA = 19864699;
Tiempo de la consulta:
0.00048708915710449Tiempo acumulado:0.52412724494934
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[166]: SELECT PED.ID_POBLACION, PED.IDS_SECTORES, PO.DESC_POBLACION, PO.DESC_REGION, PO.URL_REGION, PO.URL_POBLACION,SECI.DESC_SECTOR, SECI.URL
FROM LO_POBLACION_ENLAZADA_DESC PED
INNER JOIN LO_POBLACION_FR PO ON PO.ID_POBLACION = PED.ID_POBLACION
AND PO.IDIOMA = 'ch'
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PO.ID_REGION
AND REI.IDIOMA = 'ch'
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = 51
AND SECI.FK_ID_IDIOMA_SI18N = 'ch';
Tiempo de la consulta:
0.0011329650878906Tiempo acumulado:0.52526021003723
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[167]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.`URL` AS URL_REGION, REIA.ID_REGION_ADM1, REIA.DESC_REGION AS DESC_ADM,
REIA.`URL` AS URL_ADM, P.ID_PAIS, P.DESC_PAIS, P.`URL` AS URL_PAIS
FROM LO_EMPRESAS EMP
INNER JOIN LO_REGION RE ON RE.ID_REGION = EMP.ID_PROVINCIA
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'ch'
LEFT JOIN LO_REGION_ADM1_I18N REIA ON REIA.ID_REGION_ADM1 = RE.ID_REGION_ADM1
AND REIA.IDIOMA = 'ch'
AND (SELECT COUNT(RE2.ID_REGION)
FROM LO_REGION RE2
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = RE2.ID_REGION
AND REI.IDIOMA = 'ch'
WHERE RE2.ID_REGION_ADM1 = RE.ID_REGION_ADM1) > 1
INNER JOIN LO_PAIS_I18N P ON P.ID_PAIS = RE.ID_PAIS
AND P.IDIOMA = 'ch'
WHERE EMP.ID_EMPRESA = 19864699;
Tiempo de la consulta:
0.00068998336791992Tiempo acumulado:0.52595019340515
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[168]: SELECT (N_OFERTAS) + (N_EMPRESAS) AS NEMPRESAS,
N_OFERTAS AS NumOfertas, N_EMPRESAS as NumEmpresas,
PS.ID_REGION_ADM1,
IF ( MEDIA_AJUSTADA IS NOT NULL
AND MEDIA_AJUSTADA != 0
AND MEDIA_AJUSTADA < MEDIA_PRECIO, MEDIA_AJUSTADA, MEDIA_PRECIO ) AS MEDIA, N_OPIS
FROM
LO_REGION_ADM1_STATS PS
WHERE (IF(ISNULL(PS.N_OFERTAS),0,PS.N_OFERTAS) > 0 OR IF(ISNULL(PS.N_EMPRESAS),0,PS.N_EMPRESAS) > 0 )
AND PS.ID_REGION_ADM1 = 41
AND (PS.ID_SUBSECTOR = 0 OR PS.ID_SUBSECTOR IS NULL)
AND (PS.ID_GRUPO = 0 OR PS.ID_GRUPO IS NULL)
ORDER BY NEMPRESAS DESC;
Tiempo de la consulta:
0.00079584121704102Tiempo acumulado:0.52674603462219
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[169]: SELECT (N_OFERTAS) + (N_EMPRESAS) AS NEMPRESAS,
N_OFERTAS AS NumOfertas, N_EMPRESAS as NumEmpresas,
PS.ID_REGION,
IF ( MEDIA_AJUSTADA IS NOT NULL
AND MEDIA_AJUSTADA != 0
AND MEDIA_AJUSTADA < MEDIA_PRECIO, MEDIA_AJUSTADA, MEDIA_PRECIO ) AS MEDIA, N_OPIS
FROM
LO_REGION_STATS PS
WHERE (IF(ISNULL(PS.N_OFERTAS),0,PS.N_OFERTAS) > 0 OR IF(ISNULL(PS.N_EMPRESAS),0,PS.N_EMPRESAS) > 0 )
AND PS.ID_REGION = 424
AND (PS.ID_SUBSECTOR = 0 OR PS.ID_SUBSECTOR IS NULL)
AND (PS.ID_GRUPO = 0 OR PS.ID_GRUPO IS NULL)
ORDER BY NEMPRESAS DESC;
Tiempo de la consulta:
0.00070810317993164Tiempo acumulado:0.52745413780212
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[170]: SELECT N_OFERTAS
FROM
LO_REGION_STATS PS
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PS.ID_REGION
AND REI.IDIOMA = 'ch'
WHERE (PS.N_OFERTAS > 0 )
AND PS.ID_REGION = 424
AND PS.ID_SECTOR = 51
GROUP BY PS.ID_REGION;
Tiempo de la consulta:
0.00073003768920898Tiempo acumulado:0.52818417549133
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[171]: SELECT N_OFERTAS
FROM
LO_POBLACION_FR_STATS PS
INNER JOIN LO_POBLACION_FR PO ON PS.ID_POBLACION = PO.ID_POBLACION
AND PO.ID_REGION = 424
AND PO.IDIOMA = 'ch'
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PO.ID_REGION
AND REI.IDIOMA = 'ch'
WHERE (PS.N_OFERTAS > 0 )
AND PO.ID_REGION = 424
AND PS.ID_POBLACION = 9414
AND PS.ID_SECTOR = 51
GROUP BY PS.ID_POBLACION;
Tiempo de la consulta:
0.0004570484161377Tiempo acumulado:0.52864122390747
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[172]: SELECT SECI.DESC_SECTOR, SECI.URL AS URL_SECTOR, REI.DESC_REGION, REI.URL AS URL_REGION
FROM LO_REGION_SKI_STATS RSS
INNER JOIN LO_PRECIOS_PUBLI PP ON PP.ID_REGION_PP = RSS.ID_REGION
INNER JOIN LO_PRECIOS PRE ON PRE.ID_PRECIO = PP.ID_PRECIO_PP
AND PRE.ID_EMPRESA_PRE = 0
AND PRE.VALID_PRE = 4
INNER JOIN LO_REGION_SKI REI ON REI.ID_REGION = RSS.ID_REGION
AND REI.IDIOMA = 'ch'
INNER JOIN LO_PRECIOS_SECTORES PS ON PS.ID_PRECIO_PS = PRE.ID_PRECIO
AND PS.ID_ACTIVIDAD_PS = RSS.ID_SECTOR
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = PS.ID_ACTIVIDAD_PS
AND SECI.ID_TROPIC = 46
AND SECI.ID_SECTOR = 51
INNER JOIN LO_SECTORES SEC ON SEC.ID_SECTOR = SECI.ID_SECTOR
WHERE RSS.N_OFERTAS > 0
AND RSS.N_OFERTAS IS NOT NULL
AND IF(SEC.ID_GRUPO != 3
AND REI.ID_REGION != 10202, 1=2, 1=1)
GROUP BY RSS.ID_REGION, RSS.ID_SECTOR;
Tiempo de la consulta:
0.0024220943450928Tiempo acumulado:0.53106331825256
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[173]: SELECT URL, ET.DESCRIPCION_ET DESCRIPCION,GALERIA_DESC_ET GALERIA_DESC,VIDEOS_TEXT_ET VIDEOS_TEXT,VIDEOS_DESC_ET VIDEOS_DESC,COMO_LLEGAR_ET COMO_LLEGAR,URL_ET URL, EMP.NOMBRE NOMBRE, ET.EVENT_PLANNING EVENT_PLANNING, ID_EMPRESA
FROM LO_EMPRESAS EMP
INNER JOIN LO_EMPRESAS_TRADUCCION_CH ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'ch'
WHERE EMP.ID_EMPRESA = 19864699;
Tiempo de la consulta:
0.00052309036254883Tiempo acumulado:0.53158640861511
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[174]: SELECT OP.*, DATE_FORMAT(OP.FEC_INSERT,'%d/%m/%y') as DIA,
DATE_FORMAT(OP.FEC_INSERT,'%m/%d/%y') as DIA2,
DATE_FORMAT(OP.FEC_INSERT,'%H:%i') as HORA
FROM LO_EMPRESAS_OPINIONES OP
WHERE OP.GALERIA IS NOT NULL
AND OP.GALERIA != ''
AND (OP.ID_EMPRESA = 19864699 OR OP.ID_MADRE = 19864699)
AND OP.VALID = 1
ORDER BY OP.FEC_INSERT DESC;
Tiempo de la consulta:
0.0008080005645752Tiempo acumulado:0.53239440917969
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[175]: SELECT EMP.COMO_LLEGAR COMO_LLEGAR_ORI, EMP.GALERIA_DESC GALERIA_DESC_ORI, EMP.VIDEOS_TEXT VIDEOS_TEXT_ORI,EMP.VIDEOS_DESC VIDEOS_DESC_ORI,
EMP.EMP_MADRE,EMP.LOGOTIPO,EMP.ID_EMPRESA,EMP.DIRECCION,
PO.DESC_POBLACION, PO.URL_POBLACION, REI.DESC_REGION,EMP.DS_ACTIVO,EMP.ID_PAIS,
EMP.TELEFONO,EMP.NOPINIONES,EMP.VIDEOS_CODE,SEC.ID_GRUPO,SECI.DESC_SECTOR,EMP.FOTOPRINCIPAL,
EMP.GALERIA,EMP.MADRE_NAME,EMP.PRECIO_ACTIVIDAD,EMP.TIPOCUENTA,SECI.URL URL_SECTOR,
EMP.LICENCIA_EMPRESA,EMP.ID_POBLACION,EMP.VALID,EMP.ID_PROVINCIA,EMP.ID_SECTOR,
EMP.VIDEOS_CODE,EMP.VIDEOS_DESC,EMP.CLIENTE,RE.ID_REGION,N_VENTAS_EST,
EMP.COLAB_EMPRESAS, EMP.ID_MADRE ID_MADRE,REI.URL URL_REGION,
EMP.LATITUDE LATITUDE,EMP.COD_POSTAL, EMP.LONGITUDE LONGITUDE,PO.URL_POBLACION,
ES.NOPINIONES_EST,ES.N_PRECIOS_EST,ES.VISITAS,PUNTOS_EST,EMP.LOGIN,EMP.PASSWORD,EMP.PERS_CTCTO,
EMP.TELEFONOMOVIL, EMP.FAX,EMP.WEB,EMP.MAIL,EMP.ACCOUNT_MANAGER,RESPUESTARAPIDA,CENTRAL_ACTIVA,
NOPINIONES_EST,EMP.MAIL_CC, EMP.ACEPTAR_CR,EMP.VIDEOS_TEXT,ES.PRECIO_EST, ES.PUNTOS_EST,
ES.RIESGO_EST, ES.ATENCION_EST, EMP.URL,
ET.DESCRIPCION_ET DESCRIPCION,GALERIA_DESC_ET GALERIA_DESC,VIDEOS_TEXT_ET VIDEOS_TEXT,VIDEOS_DESC_ET VIDEOS_DESC,COMO_LLEGAR_ET COMO_LLEGAR,URL_ET URL, EMP.NOMBRE NOMBRE, ET.EVENT_PLANNING EVENT_PLANNING,
IF (EMP.EMP_MADRE = 0,
CASE EMP.ID_SECTOR
WHEN 13 THEN GRU.DESC_GRUPO
WHEN 16 THEN GRU.DESC_GRUPO
WHEN 2 THEN GRU.DESC_GRUPO
WHEN 3 THEN GRU.DESC_GRUPO
WHEN 56 THEN GRU.DESC_GRUPO
WHEN 67 THEN GRU.DESC_GRUPO
WHEN 7 THEN GRU.DESC_GRUPO
WHEN 93 THEN GRU.DESC_GRUPO
ELSE SECI.DESC_SECTOR
END,
SECI.DESC_SECTOR) AS DESC_SECTOR_BUSCADOR
FROM LO_EMPRESAS EMP
INNER JOIN LO_EMPRESAS_TRADUCCION_CH ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'ch'
LEFT JOIN LO_EMPRESAS_STAT ES ON EMP.ID_EMPRESA = ES.FK_ID_EST
INNER JOIN LO_REGION RE ON EMP.ID_PROVINCIA = RE.ID_REGION
INNER JOIN LO_REGION_I18N REI ON RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA='ch'
INNER JOIN LO_REGION_ADM1 REIAD ON RE.ID_REGION_ADM1 = REIAD.ID_REGION_ADM1
LEFT JOIN LO_POBLACION_FR PO ON EMP.ID_POBLACION = PO.ID_POBLACION
AND PO.IDIOMA='ch'
INNER JOIN LO_SECTORES SEC ON EMP.ID_SECTOR = SEC.ID_SECTOR
INNER JOIN LO_SECTORES_I18N SECI ON SEC.ID_SECTOR = SECI.ID_SECTOR
AND (SECI.ID_TROPIC = 46
AND SECI.FK_ID_IDIOMA_SI18N = 'ch')
INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
AND (GRU.ID_TROPIC = 46)
WHERE EMP.ID_EMPRESA = 19864699
AND EMP.VALID IN ('1', '-3')
LIMIT 1;
Tiempo de la consulta:
0.0012409687042236Tiempo acumulado:0.53363537788391
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[176]: SELECT TITULO_PRE,DESCRIPCION_PRE,INCLUYE_PRE,ALOJAMIENTO_TEXT_PRE,TRANSPORTE_TEXT_PRE,GALERIA_PRE,GALERIA_DESC_PRE,HORARIO_PRE, DURACION_PRE, PRE.ID_PRECIO ,SECI.ID_SECTOR, SECI.URL URL_SECTOR,REI.URL URL_REGION, PRE.FK_ID_PAIS_PRE AS ID_PAIS,
/*LEAST(if(PRECIO_MIN_PRE>0,PRECIO_MIN_PRE,PRECIO_PRE),PRECIO_PRE) PRECIO,*/
if(PRECIO_PD>0,LEAST(MIN(PRECIO_PD),PRECIO_PRE),LEAST(999999999,PRECIO_PRE) ) PRECIO_D,
IF(PD.PRECIO_PD > 0
AND PD.VALID_PD = 1,
LEAST(MIN(PD.PRECIO_PD), PRE.PRECIO_PRE),
LEAST(999999999, PRECIO_PRE)) AS PRECIO,
PRECIO_PRE, COUNT(DISTINCT RC.ID_RESERVA_COMPRA) AS VENTAS,
IF(PD.PRECIO_PD > 0
AND PD.VALID_PD = 1,
(1 - (MIN(PD.PRECIO_PD) / PRE.PRECIO_PRE))*100 , 0) AS DESCUENTO,
DESCUENTO_MIN_PRE DESCUENTO, PRE.FOTOPRINCIPAL_PRE,PRE.PRECIO_UNITARIO_PRE,
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,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%Y/%m/%d') AS FECHA,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%d') AS DIA_COM,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%m') AS MES_COM,
OP.VALORACION,COUNT(OP.ID_OPINION) AS OPIS, PD.OFERTA_PD,VALID_PD,
PRE.MIN_PERS_PRE,
MIN(PD.MIN_PERSONAS_PD) AS MIN_PERSONAS_PD,
PRE.MAX_PERS_PRE,
MAX(PD.MAX_PERSONAS_PD) AS MAX_PERSONAS_PD,
PRE.ALOJAMIENTO_PRE, PRE.FK_ID_PAIS_PRE AS ID_PAIS,
PRE.COMIDA_PRE,PRE.TRANSPORTE_PRE,REI.DESC_REGION, PRE.MULTIACTIVIDAD_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, SECI.DESC_SECTOR
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'ch'
INNER JOIN LO_PRECIOS_SECTORES SECP ON PRE.ID_PRECIO=SECP.ID_PRECIO_PS
INNER JOIN LO_REGION_I18N REI ON PRE.ID_REGION_PRE=REI.ID_REGION
INNER JOIN LO_SECTORES_I18N SECI ON SECP.ID_ACTIVIDAD_PS=SECI.ID_SECTOR
INNER JOIN LO_SECTORES SEC ON SECI.ID_SECTOR=SEC.ID_SECTOR
LEFT JOIN LO_RESERVAS_COMPRAS RC ON RC.ID_PRECIO_RC = PRE.ID_PRECIO
AND RC.VALID_RC NOT IN(0,2,6,7)
LEFT JOIN LO_PRECIOS_DESCUENTOS PD ON PD.ID_PRECIO_PD = PRE.ID_PRECIO
AND PD.VALID_PD = 1
LEFT JOIN LO_EMPRESAS_OPINIONES OP ON OP.RESERVA_FEEDBACK = RC.ID_RESERVA_COMPRA
AND OP.VALID=1
LEFT JOIN LO_PRECIOS_RESTRICCIONES PR ON PRE.ID_PRECIO = PR.ID_PRECIO
WHERE SECI.ID_TROPIC='46'
AND SECI.FK_ID_IDIOMA_SI18N='ch'
AND REI.IDIOMA='ch'
AND VALID_PRE IN(4)
AND PRE.ID_EMPRESA_PRE ='19864699'
AND (PR.FICHA = 0 OR PR.FICHA IS NULL OR IF(PR.FECHA_INICIO IS NOT NULL, CONCAT(DATE_FORMAT(NOW(), '%Y-'), DATE_FORMAT(PR.FECHA_INICIO, '%m-%d')) <= CONCAT(DATE_FORMAT(NOW(), '%Y-'), DATE_FORMAT(NOW(), '%m-%d'))
AND IF(DATE_FORMAT(PR.FECHA_FIN, '%m') >= DATE_FORMAT(PR.FECHA_INICIO, '%m'), CONCAT(DATE_FORMAT(NOW(), '%Y-'), DATE_FORMAT(PR.FECHA_FIN, '%m-%d')) >= CONCAT(DATE_FORMAT(NOW(), '%Y-'), DATE_FORMAT(NOW(), '%m-%d')), CONCAT((1+ DATE_FORMAT(NOW(), '%Y')),'-', DATE_FORMAT(PR.FECHA_FIN, '%m-%d')) >= CONCAT(DATE_FORMAT(NOW(), '%Y'),'-', DATE_FORMAT(NOW(), '%m-%d'))),1!=1))
GROUP BY PRE.ID_PRECIO
ORDER BY VENTAS desc, N_ORDER_EMP_PRE IS NULL ASC,N_ORDER_EMP_PRE ASC, OFERTA_PD DESC, N_ORDER_PRE DESC,PRECIO ASC;
Tiempo de la consulta:
0.0022330284118652Tiempo acumulado:0.53586840629578
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[177]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = ''
AND SEO.ID_TROPIC = 46
AND SEO.FK_ID_REG_ADM = 0
AND 1=1;
Tiempo de la consulta:
0.00091004371643066Tiempo acumulado:0.53677845001221
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[178]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S51'
AND SEO.ID_TROPIC = 46
AND SEO.FK_ID_REG_ADM = 0
AND 1=1;
Tiempo de la consulta:
0.00047898292541504Tiempo acumulado:0.53725743293762
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[179]: SELECT URL, ET.DESCRIPCION_ET DESCRIPCION,GALERIA_DESC_ET GALERIA_DESC,VIDEOS_TEXT_ET VIDEOS_TEXT,VIDEOS_DESC_ET VIDEOS_DESC,COMO_LLEGAR_ET COMO_LLEGAR,URL_ET URL, EMP.NOMBRE NOMBRE, ET.EVENT_PLANNING EVENT_PLANNING, ID_EMPRESA
FROM LO_EMPRESAS EMP
INNER JOIN LO_EMPRESAS_TRADUCCION_CH ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'ch'
WHERE EMP.ID_EMPRESA = 19864699;
Tiempo de la consulta:
0.0005040168762207Tiempo acumulado:0.53776144981384
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[180]: SELECT DATE_FORMAT(PRE.FEC_ULT_COMPRA, '%Y-%m-%d') AS FEC_ULT_COMPRA,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%d') AS DIA_COM,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%m') AS MES_COM
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'ch'
WHERE ID_PRECIO = 90048
AND VALID_PRE = 4
GROUP BY PRE.ID_PRECIO
HAVING FEC_ULT_COMPRA IS NOT NULL
LIMIT 1;
Tiempo de la consulta:
0.0035300254821777Tiempo acumulado:0.54129147529602
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[181]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = ''
AND SEO.ID_TROPIC = 46
AND SEO.FK_ID_REG_ADM = 0
AND 1=1;
Tiempo de la consulta:
0.00039005279541016Tiempo acumulado:0.54168152809143
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[182]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S51'
AND SEO.ID_TROPIC = 46
AND SEO.FK_ID_REG_ADM = 0
AND 1=1;
Tiempo de la consulta:
0.0030031204223633Tiempo acumulado:0.54468464851379
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[183]: SELECT SEOHOME.DESCRIPTION,SEOHOME.DESCRIPTION2,SEOHOME.HEIGHT, SEOHOME.CONTENT_MANAGER, DATE_FORMAT(SEOHOME.FEC_INSERT, '%d/%m/%Y %H:%i') FECHA_INSERT, DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%d/%m/%Y %H:%i') FECHA_MOD, CA.NOMBRE, CA.ID,DATE_FORMAT(SEOHOME.FEC_INSERT, '%Y-%m-%dT%H:%i') IN_GOOGLE,
DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%Y-%m-%dT%H:%i') MOD_GOOGLE,AU.ID_ADMIN, GALERIA, GALERIA_DESC, CA.JOB,
DATE_FORMAT(SEOHOME.FEC_INSERT, '%d') DAY_INSERT,
DATE_FORMAT(SEOHOME.FEC_INSERT, '%m') MONTH_INSERT,
DATE_FORMAT(SEOHOME.FEC_INSERT, '%Y') YEAR_INSERT,
DATE_FORMAT(SEOHOME.FEC_INSERT, '%H:%i') HORA_INSERT,
DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%d') DAY_MOD,
DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%m') MONTH_MOD,
DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%Y') YEAR_MOD,
DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%H:%i') HORA_MOD
FROM LO_SEO_DESCRIPTIONS_HOME SEOHOME
LEFT JOIN LO_ADMIN_USERS AU ON AU.LOGIN = SEOHOME.CONTENT_MANAGER
LEFT JOIN LO_CONTENIDO_AUTORES CA ON CA.ID_ADMIN = AU.ID_ADMIN
AND CA.ID_TROPIC = 46
WHERE SEOHOME.ID_TROPIC = 46
AND SEOHOME.ID_KEY = 'S51'
AND SEO_VALID in (0,1)
AND SEOHOME.ID_LOCALIZACION='';
Tiempo de la consulta:
0.0093019008636475Tiempo acumulado:0.55398654937744
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[184]: SELECT COUNT(*) AS NUMOPINIONES, (SUM(VALORACION) / COUNT(*)) /20 AS VALORACION
FROM LO_EMPRESAS_OPINIONES OP
LEFT JOIN LO_RESERVAS_COMPRAS RC ON OP.RESERVA_FEEDBACK = RC.ID_RESERVA_COMPRA
LEFT JOIN LO_PRECIOS PRE ON RC.ID_PRECIO_RC = PRE.ID_PRECIO
WHERE PRE.ID_PRECIO = 90048
AND OP.VALID = 1;
Tiempo de la consulta:
0.010852813720703Tiempo acumulado:0.56483936309814
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[185]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 90048
AND VALID = 1;
Tiempo de la consulta:
0.00072908401489258Tiempo acumulado:0.56556844711304
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[186]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 90048
AND FOTO = 'p-90048-31720786799_1720788751127.jpeg'
AND VALID = 1;
Tiempo de la consulta:
0.0030760765075684Tiempo acumulado:0.56864452362061
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[187]: SELECT URL_PRE, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, ID_PRECIO, FK_ID_PAIS_PRE
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'ch'
WHERE PRE.ID_PRECIO = 90048;
Tiempo de la consulta:
0.0010910034179688Tiempo acumulado:0.56973552703857
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[188]: SELECT ID_PRECIO_PADRE
FROM LO_PRECIOS_ASIGNACION PA
INNER JOIN LO_PRECIOS PRE ON PRE.ID_PRECIO = PA.ID_PRECIO_PADRE
AND PRE.VALID_PRE = 4
WHERE PA.ID_PRECIO = 90048;
Tiempo de la consulta:
0.00048589706420898Tiempo acumulado:0.57022142410278
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[189]: SELECT EXITO
FROM LO_PRECIOS_EXITO
WHERE ID_PRECIO = 90048
LIMIT 1;
Tiempo de la consulta:
0.000885009765625Tiempo acumulado:0.57110643386841
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[190]: SELECT COUNT(*) AS TOTAL
FROM LO_PRECIOS_SECTORES PS
WHERE PS.ID_ACTIVIDAD_PS NOT IN (100,101)
AND PS.ID_PRECIO_PS = 90048;
Tiempo de la consulta:
0.00044918060302734Tiempo acumulado:0.57155561447144
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[191]: SELECT *
FROM LO_PRECIOS_DIA_ESPECIAL PD
WHERE PD.ID_PRECIO_DE = 90048
AND ID_TIPO_DE = 7
AND VALID = 1;
Tiempo de la consulta:
0.00089597702026367Tiempo acumulado:0.5724515914917
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[192]: SELECT *
FROM LO_PRECIOS_DISPONIBILIDAD_CALENDARIO
WHERE VALID = 1
AND ID_PRECIO = 90048;
Tiempo de la consulta:
0.00079703330993652Tiempo acumulado:0.57324862480164
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[193]: SELECT DATE_FORMAT(PRE.FEC_ULT_COMPRA, '%Y-%m-%d') AS FEC_ULT_COMPRA,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%d') AS DIA_COM,
DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%m') AS MES_COM
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'ch'
WHERE ID_PRECIO = 90047
AND VALID_PRE = 4
GROUP BY PRE.ID_PRECIO
HAVING FEC_ULT_COMPRA IS NOT NULL
LIMIT 1;
Tiempo de la consulta:
0.0038330554962158Tiempo acumulado:0.57708168029785
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[194]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = ''
AND SEO.ID_TROPIC = 46
AND SEO.FK_ID_REG_ADM = 0
AND 1=1;
Tiempo de la consulta:
0.00051021575927734Tiempo acumulado:0.57759189605713
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[195]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S51'
AND SEO.ID_TROPIC = 46
AND SEO.FK_ID_REG_ADM = 0
AND 1=1;
Tiempo de la consulta:
0.0015139579772949Tiempo acumulado:0.57910585403442
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[196]: SELECT SEOHOME.DESCRIPTION,SEOHOME.DESCRIPTION2,SEOHOME.HEIGHT, SEOHOME.CONTENT_MANAGER, DATE_FORMAT(SEOHOME.FEC_INSERT, '%d/%m/%Y %H:%i') FECHA_INSERT, DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%d/%m/%Y %H:%i') FECHA_MOD, CA.NOMBRE, CA.ID,DATE_FORMAT(SEOHOME.FEC_INSERT, '%Y-%m-%dT%H:%i') IN_GOOGLE,
DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%Y-%m-%dT%H:%i') MOD_GOOGLE,AU.ID_ADMIN, GALERIA, GALERIA_DESC, CA.JOB,
DATE_FORMAT(SEOHOME.FEC_INSERT, '%d') DAY_INSERT,
DATE_FORMAT(SEOHOME.FEC_INSERT, '%m') MONTH_INSERT,
DATE_FORMAT(SEOHOME.FEC_INSERT, '%Y') YEAR_INSERT,
DATE_FORMAT(SEOHOME.FEC_INSERT, '%H:%i') HORA_INSERT,
DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%d') DAY_MOD,
DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%m') MONTH_MOD,
DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%Y') YEAR_MOD,
DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%H:%i') HORA_MOD
FROM LO_SEO_DESCRIPTIONS_HOME SEOHOME
LEFT JOIN LO_ADMIN_USERS AU ON AU.LOGIN = SEOHOME.CONTENT_MANAGER
LEFT JOIN LO_CONTENIDO_AUTORES CA ON CA.ID_ADMIN = AU.ID_ADMIN
AND CA.ID_TROPIC = 46
WHERE SEOHOME.ID_TROPIC = 46
AND SEOHOME.ID_KEY = 'S51'
AND SEO_VALID in (0,1)
AND SEOHOME.ID_LOCALIZACION='';
Tiempo de la consulta:
0.0031299591064453Tiempo acumulado:0.58223581314087
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[197]: SELECT COUNT(*) AS NUMOPINIONES, (SUM(VALORACION) / COUNT(*)) /20 AS VALORACION
FROM LO_EMPRESAS_OPINIONES OP
LEFT JOIN LO_RESERVAS_COMPRAS RC ON OP.RESERVA_FEEDBACK = RC.ID_RESERVA_COMPRA
LEFT JOIN LO_PRECIOS PRE ON RC.ID_PRECIO_RC = PRE.ID_PRECIO
WHERE PRE.ID_PRECIO = 90047
AND OP.VALID = 1;
Tiempo de la consulta:
0.00092411041259766Tiempo acumulado:0.58315992355347
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[198]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 90047
AND VALID = 1;
Tiempo de la consulta:
0.00064611434936523Tiempo acumulado:0.58380603790283
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[199]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 90047
AND FOTO = 'p-90047-81720782375_17207860103074.jpeg'
AND VALID = 1;
Tiempo de la consulta:
0.00050091743469238Tiempo acumulado:0.58430695533752
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[200]: SELECT URL_PRE, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, ID_PRECIO, FK_ID_PAIS_PRE
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'ch'
WHERE PRE.ID_PRECIO = 90047;
Tiempo de la consulta:
0.0038690567016602Tiempo acumulado:0.58817601203918
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[201]: SELECT ID_PRECIO_PADRE
FROM LO_PRECIOS_ASIGNACION PA
INNER JOIN LO_PRECIOS PRE ON PRE.ID_PRECIO = PA.ID_PRECIO_PADRE
AND PRE.VALID_PRE = 4
WHERE PA.ID_PRECIO = 90047;
Tiempo de la consulta:
0.00093793869018555Tiempo acumulado:0.58911395072937
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[202]: SELECT EXITO
FROM LO_PRECIOS_EXITO
WHERE ID_PRECIO = 90047
LIMIT 1;
Tiempo de la consulta:
0.0025990009307861Tiempo acumulado:0.59171295166016
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[203]: SELECT COUNT(*) AS TOTAL
FROM LO_PRECIOS_SECTORES PS
WHERE PS.ID_ACTIVIDAD_PS NOT IN (100,101)
AND PS.ID_PRECIO_PS = 90047;
Tiempo de la consulta:
0.0027949810028076Tiempo acumulado:0.59450793266296
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[204]: SELECT *
FROM LO_PRECIOS_DIA_ESPECIAL PD
WHERE PD.ID_PRECIO_DE = 90047
AND ID_TIPO_DE = 7
AND VALID = 1;
Tiempo de la consulta:
0.00046801567077637Tiempo acumulado:0.59497594833374
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[205]: SELECT *
FROM LO_PRECIOS_DISPONIBILIDAD_CALENDARIO
WHERE VALID = 1
AND ID_PRECIO = 90047;
Tiempo de la consulta:
0.00048708915710449Tiempo acumulado:0.59546303749084
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[206]: SELECT EE.*, EET.DESCRIPCION, EET.CARGO, EE.IDIOMA AS IDIOMA_EE
FROM LO_EMPRESAS_EQUIPO EE
INNER JOIN LO_EMPRESAS_EQUIPO_TRADUCCION EET ON EET.ID_EQUIPO = EE.ID
AND EET.IDIOMA = 'ch'
WHERE EE.ID_EMPRESA = 19864699
AND EE.VALID = 1;
Tiempo de la consulta:
0.0015761852264404Tiempo acumulado:0.59703922271729
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[207]: SELECT MIN(DATE_FORMAT(EMP.FEC_INSERT,'%Y/%m/%d') ) AS FECHA
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19864699 OR ID_MADRE = 19864699
AND EMP.VALID = 1;
Tiempo de la consulta:
0.002615213394165Tiempo acumulado:0.59965443611145
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[208]: SELECT MAX(DATE_FORMAT(EMP.FEC_ULT_CONNECT,'%Y/%m/%d')) AS FECHA
FROM LO_EMPRESAS EMP
INNER JOIN LO_PRECIOS PRE ON PRE.ID_EMPRESA_PRE = EMP.ID_EMPRESA
AND VALID_PRE = 4
WHERE EMP.ID_EMPRESA = 19864699 OR ID_MADRE = 19864699
AND EMP.VALID = 1;
Tiempo de la consulta:
0.00067496299743652Tiempo acumulado:0.60032939910889
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[209]: SELECT *
FROM LO_RESERVAS_FISCAL
WHERE ID_EMPRESA_RF='19864699';
Tiempo de la consulta:
0.001708984375Tiempo acumulado:0.60203838348389
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[210]: SELECT EXI.EXITO,EXI.N_VENTAS,EXI.N_DEVOLUCIONES
FROM LO_EMPRESAS EMP
LEFT JOIN LO_EMPRESAS_EXITO EXI ON EMP.ID_EMPRESA = EXI.ID_EMPRESA
WHERE EMP.ID_EMPRESA = 19864699;
Tiempo de la consulta:
0.0018258094787598Tiempo acumulado:0.60386419296265
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[211]: SELECT *
FROM LO_EMPRESAS_IDIOMAS EI
WHERE EI.ID_EMPRESA = 19864699;
Tiempo de la consulta:
0.00076580047607422Tiempo acumulado:0.60462999343872
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[212]: SELECT AW.*, SECI.DESC_SECTOR, REG.DESC_REGION
FROM LO_EMPRESAS_AWARDS AW
LEFT JOIN LO_SECTORES_I18N SECI ON AW.ID_SECTOR = SECI.ID_SECTOR
AND SECI.ID_TROPIC = 46
LEFT JOIN LO_REGION_I18N REG ON REG.ID_REGION = AW.ID_PROVINCIA
AND REG.IDIOMA = 'ch'
WHERE (ID_EMPRESA = 19864699 OR ID_MADRE = 19864699)
GROUP BY ANO, ID_SECTOR, ID_PROVINCIA
ORDER BY ANO DESC;
Tiempo de la consulta:
0.0061168670654297Tiempo acumulado:0.61074686050415
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[213]: SELECT EMP.COMO_LLEGAR COMO_LLEGAR_ORI, EMP.GALERIA_DESC GALERIA_DESC_ORI, EMP.VIDEOS_TEXT VIDEOS_TEXT_ORI,EMP.VIDEOS_DESC VIDEOS_DESC_ORI,
EMP.EMP_MADRE,EMP.LOGOTIPO,EMP.ID_EMPRESA,EMP.DIRECCION,
PO.DESC_POBLACION, PO.URL_POBLACION, REI.DESC_REGION,EMP.DS_ACTIVO,EMP.ID_PAIS,
EMP.TELEFONO,EMP.NOPINIONES,EMP.VIDEOS_CODE,SEC.ID_GRUPO,SECI.DESC_SECTOR,EMP.FOTOPRINCIPAL,
EMP.GALERIA,EMP.MADRE_NAME,EMP.PRECIO_ACTIVIDAD,EMP.TIPOCUENTA,SECI.URL URL_SECTOR,
EMP.LICENCIA_EMPRESA,EMP.ID_POBLACION,EMP.VALID,EMP.ID_PROVINCIA,EMP.ID_SECTOR,
EMP.VIDEOS_CODE,EMP.VIDEOS_DESC,EMP.CLIENTE,RE.ID_REGION,N_VENTAS_EST,
EMP.COLAB_EMPRESAS, EMP.ID_MADRE ID_MADRE,REI.URL URL_REGION,
EMP.LATITUDE LATITUDE,EMP.COD_POSTAL, EMP.LONGITUDE LONGITUDE,PO.URL_POBLACION,
ES.NOPINIONES_EST,ES.N_PRECIOS_EST,ES.VISITAS,PUNTOS_EST,EMP.LOGIN,EMP.PASSWORD,EMP.PERS_CTCTO,
EMP.TELEFONOMOVIL, EMP.FAX,EMP.WEB,EMP.MAIL,EMP.ACCOUNT_MANAGER,RESPUESTARAPIDA,CENTRAL_ACTIVA,
NOPINIONES_EST,EMP.MAIL_CC, EMP.ACEPTAR_CR,EMP.VIDEOS_TEXT,ES.PRECIO_EST, ES.PUNTOS_EST,
ES.RIESGO_EST, ES.ATENCION_EST, EMP.URL,
ET.DESCRIPCION_ET DESCRIPCION,GALERIA_DESC_ET GALERIA_DESC,VIDEOS_TEXT_ET VIDEOS_TEXT,VIDEOS_DESC_ET VIDEOS_DESC,COMO_LLEGAR_ET COMO_LLEGAR,URL_ET URL, EMP.NOMBRE NOMBRE, ET.EVENT_PLANNING EVENT_PLANNING,
IF (EMP.EMP_MADRE = 0,
CASE EMP.ID_SECTOR
WHEN 13 THEN GRU.DESC_GRUPO
WHEN 16 THEN GRU.DESC_GRUPO
WHEN 2 THEN GRU.DESC_GRUPO
WHEN 3 THEN GRU.DESC_GRUPO
WHEN 56 THEN GRU.DESC_GRUPO
WHEN 67 THEN GRU.DESC_GRUPO
WHEN 7 THEN GRU.DESC_GRUPO
WHEN 93 THEN GRU.DESC_GRUPO
ELSE SECI.DESC_SECTOR
END,
SECI.DESC_SECTOR) AS DESC_SECTOR_BUSCADOR
FROM LO_EMPRESAS EMP
INNER JOIN LO_EMPRESAS_TRADUCCION_CH ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'ch'
LEFT JOIN LO_EMPRESAS_STAT ES ON EMP.ID_EMPRESA = ES.FK_ID_EST
INNER JOIN LO_REGION RE ON EMP.ID_PROVINCIA = RE.ID_REGION
INNER JOIN LO_REGION_I18N REI ON RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA='ch'
INNER JOIN LO_REGION_ADM1 REIAD ON RE.ID_REGION_ADM1 = REIAD.ID_REGION_ADM1
LEFT JOIN LO_POBLACION_FR PO ON EMP.ID_POBLACION = PO.ID_POBLACION
AND PO.IDIOMA='ch'
INNER JOIN LO_SECTORES SEC ON EMP.ID_SECTOR = SEC.ID_SECTOR
INNER JOIN LO_SECTORES_I18N SECI ON SEC.ID_SECTOR = SECI.ID_SECTOR
AND (SECI.ID_TROPIC = 46
AND SECI.FK_ID_IDIOMA_SI18N = 'ch')
INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
AND (GRU.ID_TROPIC = 46)
WHERE EMP.ID_EMPRESA = 19864699
AND EMP.VALID IN ('1', '-3')
LIMIT 1;
Tiempo de la consulta:
0.0017209053039551Tiempo acumulado:0.61246776580811
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[214]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864699
AND VALID = 1;
Tiempo de la consulta:
0.00058197975158691Tiempo acumulado:0.61304974555969
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[215]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864699
AND FOTO = 'e-19864699-14172077926117207814258160.jpeg'
AND VALID=1;
Tiempo de la consulta:
0.00044608116149902Tiempo acumulado:0.61349582672119
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[216]: SELECT '1', RE.ID_REGION, REI.ID_REGION, REI.DESC_REGION, REI.URL URL_REGION, RE.ID_REGION_ADM1, RE.ID_PAIS, LATITUDE, LONGITUDE
FROM LO_REGION RE
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = RE.ID_REGION
WHERE RE.ID_REGION = '424'
AND REI.IDIOMA = 'ch';
Tiempo de la consulta:
0.00040292739868164Tiempo acumulado:0.61389875411987
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingwrite_deskSQL[217]: INSERT INTO LO_EMPRESAS_VISITAS_DIARIO
(ID_EMPRESA,FECHA, VISITAS)
VALUES
(19864699, SYSDATE(), 1)
ON DUPLICATE KEY UPDATE
VISITAS = VISITAS + 1;
Tiempo de la consulta:
0.0076091289520264Tiempo acumulado:0.6215078830719
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[218]: SELECT SECI.ID_SECTOR, N_OFERTAS AS NEMPRESAS, N_OFERTAS AS NumOfertas, N_EMPRESAS as NumEmpresas, REI.ID_REGION, REI.DESC_REGION, REI.URL URL_REGION, SECI.DESC_SECTOR, SECI.URL as URL_SECTOR, RE.ID_REGION_ADM1, SEC.ID_GRUPO, RE.ID_PAIS
FROM
LO_REGION_STATS PS
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PS.ID_REGION
AND REI.IDIOMA = 'ch'
INNER JOIN LO_REGION RE ON RE.ID_REGION = REI.ID_REGION
INNER JOIN LO_SECTORES SEC ON SEC.ID_SECTOR = PS.ID_SECTOR
AND SEC.ID_GRUPO = 1
INNER JOIN LO_SECTORES_I18N SECI ON PS.ID_SECTOR = SECI.ID_SECTOR
AND SECI.ID_TROPIC='46'
AND SECI.FK_ID_IDIOMA_SI18N = 'ch'
WHERE
REI.ID_REGION = 424
AND (PS.N_OFERTAS > 0
AND PS.N_OFERTAS IS NOT NULL)
ORDER BY NEMPRESAS DESC;
Tiempo de la consulta:
0.0015020370483398Tiempo acumulado:0.62300992012024
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[219]: SELECT COUNT(*) AS NEMPRESAS
FROM LO_REGION_STATS
WHERE ID_REGION = 424
AND ID_GRUPO = 1;
Tiempo de la consulta:
0.00053787231445312Tiempo acumulado:0.62354779243469
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[220]: SELECT '1', RE.ID_REGION, REI.ID_REGION, REI.DESC_REGION, REI.URL URL_REGION, RE.ID_REGION_ADM1, RE.ID_PAIS, LATITUDE, LONGITUDE
FROM LO_REGION RE
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = RE.ID_REGION
WHERE RE.ID_REGION = '424'
AND REI.IDIOMA = 'ch';
Tiempo de la consulta:
0.00044107437133789Tiempo acumulado:0.62398886680603
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[221]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S11'
AND (SEO.ID_TROPIC = 46
);
Tiempo de la consulta:
0.00059199333190918Tiempo acumulado:0.62458086013794
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[222]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S55'
AND (SEO.ID_TROPIC = 46
);
Tiempo de la consulta:
0.00043106079101562Tiempo acumulado:0.62501192092896
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[223]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S45'
AND (SEO.ID_TROPIC = 46
);
Tiempo de la consulta:
0.00043201446533203Tiempo acumulado:0.62544393539429
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[224]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S51'
AND (SEO.ID_TROPIC = 46
);
Tiempo de la consulta:
0.00049710273742676Tiempo acumulado:0.62594103813171
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[225]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S8'
AND (SEO.ID_TROPIC = 46
);
Tiempo de la consulta:
0.00042486190795898Tiempo acumulado:0.62636590003967
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[226]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S29'
AND (SEO.ID_TROPIC = 46
);
Tiempo de la consulta:
0.0027680397033691Tiempo acumulado:0.62913393974304
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[227]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S7'
AND (SEO.ID_TROPIC = 46
);
Tiempo de la consulta:
0.00045299530029297Tiempo acumulado:0.62958693504333
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[228]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S110'
AND (SEO.ID_TROPIC = 46
);
Tiempo de la consulta:
0.0009610652923584Tiempo acumulado:0.63054800033569
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[229]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S84'
AND (SEO.ID_TROPIC = 46
);
Tiempo de la consulta:
0.00042104721069336Tiempo acumulado:0.63096904754639
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[230]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S23'
AND (SEO.ID_TROPIC = 46
);
Tiempo de la consulta:
0.00038695335388184Tiempo acumulado:0.63135600090027
(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[231]: SELECT *
FROM LO_EQUIPO_EDITORIAL EE
WHERE EE.ID_TROPIC = 46;
Tiempo de la consulta:
0.00091314315795898Tiempo acumulado:0.63226914405823
