yu-front-06.localdomain (172.30.2.194:443)
prod.yumping.com
/empresa.php
BBDD->Prod_Yumping_pt_PT
AMBITO->pt_es
AMBITO_AJAX->pt_es
AMBITO_AJAX COOKIE->mx_es
locale LO_CONFIG->es_PT
locale php->es_PT
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->es_ES
id_empresa->19864742
tpage->empresa
nomb_emp->green-devil-safari
rel_alternate->1
Total queries: 210
Tiempo total: 0.50340175628662
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[1]: SELECT CFG.ID, CFG.NAME, IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '', CFG.VALUE_PROD, CFG.VALUE) VALUE , CFG.AMBITO, CFG.VISIBLE_AJAX, CFG.TIME
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.AMBITO IN ('global', 'es')
ORDER BY CFG.NAME;
Tiempo de la consulta:
0.019937992095947Tiempo acumulado:0.019937992095947
(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.00063109397888184Tiempo acumulado:0.020569086074829
(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 = 19864742
AND fnGoogleUrl(EMP.NOMBRE) = 'green-devil-safari' UNION ALL SELECT EMP.ID_PAIS
FROM Prod_Yumping_pt_PT.LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19864742
AND fnGoogleUrl(EMP.NOMBRE) = 'green-devil-safari' UNION ALL SELECT EMP.ID_PAIS
FROM Prod_Yumping_it_IT.LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19864742
AND fnGoogleUrl(EMP.NOMBRE) = 'green-devil-safari' UNION ALL SELECT EMP.ID_PAIS
FROM Prod_Yumping_fr_FR.LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19864742
AND fnGoogleUrl(EMP.NOMBRE) = 'green-devil-safari' UNION ALL SELECT EMP.ID_PAIS
FROM Prod_Yumping_co_UK.LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19864742
AND fnGoogleUrl(EMP.NOMBRE) = 'green-devil-safari' UNION ALL SELECT EMP.ID_PAIS
FROM Prod_Yumping_mx_MX.LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19864742
AND fnGoogleUrl(EMP.NOMBRE) = 'green-devil-safari' ) AS EMPRESA;
Tiempo de la consulta:
0.0066959857940674Tiempo acumulado:0.027265071868896
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[4]: SELECT *
FROM LO_CONFIG C
WHERE C.AMBITO = (
SELECT AMBITO
FROM LO_CONFIG C
WHERE CONCAT('/',C.VALUE) = ''
AND NAME = 'Request_url_partner'
LIMIT 1)
AND (NAME = 'subdomain' OR NAME = 'subdomain_lang');
Tiempo de la consulta:
0.0021171569824219Tiempo acumulado:0.029382228851318
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[5]: SELECT CFG.ID, CFG.NAME, IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '', CFG.VALUE_PROD, CFG.VALUE) VALUE , CFG.AMBITO, CFG.VISIBLE_AJAX, CFG.TIME
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.AMBITO IN ('global', 'pt_es')
ORDER BY CFG.NAME;
Tiempo de la consulta:
0.007267951965332Tiempo acumulado:0.03665018081665
(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.00041103363037109Tiempo acumulado:0.037061214447021
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[7]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.0004279613494873Tiempo acumulado:0.037489175796509
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[8]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'ambito_lang';
Tiempo de la consulta:
0.00061607360839844Tiempo acumulado:0.038105249404907
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[9]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'id_empresa';
Tiempo de la consulta:
0.00042295455932617Tiempo acumulado:0.038528203964233
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[10]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'tpage';
Tiempo de la consulta:
0.00039386749267578Tiempo acumulado:0.038922071456909
(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 = 'nomb_emp';
Tiempo de la consulta:
0.00038290023803711Tiempo acumulado:0.039304971694946
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[12]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'rel_alternate';
Tiempo de la consulta:
0.00057196617126465Tiempo acumulado:0.039876937866211
(Prod_Yumping_pt_PT) (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.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_ES ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'es'
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='es'
INNER JOIN LO_REGION_ADM1 REIAD ON RE.ID_REGION_ADM1 = REIAD.ID_REGION_ADM1
LEFT JOIN LO_POBLACION_PT PO ON EMP.ID_POBLACION = PO.ID_POBLACION
AND PO.IDIOMA='es'
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 = 81
AND SECI.FK_ID_IDIOMA_SI18N = 'es')
INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
AND (GRU.ID_TROPIC = 81)
WHERE EMP.ID_EMPRESA = 19864742
AND EMP.VALID IN ('1', '-3')
LIMIT 1;
Tiempo de la consulta:
0.0094590187072754Tiempo acumulado:0.049335956573486
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[14]: 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_ES ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'es'
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='es'
INNER JOIN LO_REGION_ADM1 REIAD ON RE.ID_REGION_ADM1 = REIAD.ID_REGION_ADM1
LEFT JOIN LO_POBLACION_PT PO ON EMP.ID_POBLACION = PO.ID_POBLACION
AND PO.IDIOMA='es'
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 = 81
AND SECI.FK_ID_IDIOMA_SI18N = 'es')
INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
AND (GRU.ID_TROPIC = 81)
WHERE EMP.ID_MADRE = 19864742
AND EMP.EMP_MADRE IN(2,4)
AND EMP.VALID IN ('1', '-3');
Tiempo de la consulta:
0.001276969909668Tiempo acumulado:0.050612926483154
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[15]: SELECT ID_EMPRESA, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_EMPRESA = 19864742;
Tiempo de la consulta:
0.0013868808746338Tiempo acumulado:0.051999807357788
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[16]: SELECT SEC.EXCLUYE_ALOJAMIENTO
FROM LO_SECTORES SEC
WHERE ID_SECTOR = 22
AND EXCLUYE_ALOJAMIENTO = 0;
Tiempo de la consulta:
0.0003819465637207Tiempo acumulado:0.052381753921509
(Prod_Yumping_pt_PT) (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_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'es'
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='81'
AND SECI.FK_ID_IDIOMA_SI18N='es'
AND REI.IDIOMA='es'
AND VALID_PRE IN(4)
AND PRE.ID_EMPRESA_PRE ='19864742'
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.011314868927002Tiempo acumulado:0.063696622848511
(Prod_Yumping_pt_PT) (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 = '757'
AND REI.IDIOMA = 'es';
Tiempo de la consulta:
0.0004730224609375Tiempo acumulado:0.064169645309448
(Prod_Yumping_pt_PT) (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_ES ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'es'
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='es'
LEFT JOIN LO_POBLACION_PT PO ON PO.ID_POBLACION=EMP.ID_POBLACION
AND PO.IDIOMA='es'
/*
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='81'
AND SECI.FK_ID_IDIOMA_SI18N='es'
AND EMP.EMP_MADRE <> '0'
AND SEC.ID_SECTOR='22'
INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
AND GRU.ID_TROPIC = '81'
/*
LEFT JOIN LO_EMPRESAS_SNIPPETS_RELACIONES ESR ON ESR.ID_EMPRESA = EMP.ID_EMPRESA
AND ESR.ID_TROPIC = '81' */
WHERE EMP.VALID=1
AND EMP.ID_EMPRESA > '19864742'
AND EMP.ID_PROVINCIA='757'
AND EMP.EMP_MADRE <> '3'
GROUP BY EMP.ID_EMPRESA
ORDER BY EMP.ID_EMPRESA ASC
LIMIT 4;
Tiempo de la consulta:
0.0012929439544678Tiempo acumulado:0.065462589263916
(Prod_Yumping_pt_PT) (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='19864742'
OR OP.ID_MADRE='19864742' )
AND OP.VALID=1
AND GALERIA IS NOT NULL
AND GALERIA NOT IN('')
ORDER BY OP.FEC_INSERT DESC;
Tiempo de la consulta:
0.00079011917114258Tiempo acumulado:0.066252708435059
(Prod_Yumping_pt_PT) (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_ES ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'es'
WHERE EMP.ID_EMPRESA = 19864742;
Tiempo de la consulta:
0.00064206123352051Tiempo acumulado:0.066894769668579
(Prod_Yumping_pt_PT) (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_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'es'
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='81'
AND SECI.FK_ID_IDIOMA_SI18N='es'
AND REI.IDIOMA='es'
AND ID_EMPRESA='19864742'
AND VALID_PD=1
AND OFERTA_PD=1
AND SECP.ID_ACTIVIDAD_PS = 22
AND PRE.VALID_PRE = 4
ORDER BY FECHA_CADUCIDAD_PD DESC
LIMIT 1;
Tiempo de la consulta:
0.0027470588684082Tiempo acumulado:0.069641828536987
(Prod_Yumping_pt_PT) (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_ES ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'es'
WHERE EMP.ID_EMPRESA = 19864742;
Tiempo de la consulta:
0.00053095817565918Tiempo acumulado:0.070172786712646
(Prod_Yumping_pt_PT) (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 = 48
AND IDIOMA = 'es';
Tiempo de la consulta:
0.00089597702026367Tiempo acumulado:0.07106876373291
(Prod_Yumping_pt_PT) (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 = 'es'
LEFT JOIN LO_REGION_ADM1_I18N REIA ON REIA.ID_REGION_ADM1 = RE.ID_REGION_ADM1
AND REIA.IDIOMA = 'es'
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 = 'es'
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 = 'es'
WHERE EMP.ID_EMPRESA = 19864742;
Tiempo de la consulta:
0.0015649795532227Tiempo acumulado:0.072633743286133
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[26]: SELECT *
FROM LO_REGION_STATS RS
WHERE RS.ID_SECTOR = 22
AND RS.ID_REGION = 757
AND ID_GRUPO = 0
AND ID_SUBSECTOR = 0
AND N_OFERTAS > 0;
Tiempo de la consulta:
0.0011417865753174Tiempo acumulado:0.07377552986145
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[27]: SELECT *
FROM LO_POBLACION_PT_STATS P
WHERE P.ID_SECTOR = 22
AND ID_POBLACION = 75982
AND N_OFERTAS > 0;
Tiempo de la consulta:
0.0010478496551514Tiempo acumulado:0.074823379516602
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[28]: 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 = 757
AND REI.IDIOMA = 'pt';
Tiempo de la consulta:
0.00040602684020996Tiempo acumulado:0.075229406356812
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[29]: SELECT URL_POBLACION, ID_POBLACION
FROM LO_POBLACION_PT PO
WHERE PO.ID_POBLACION = 75982
AND PO.IDIOMA = 'pt';
Tiempo de la consulta:
0.00070405006408691Tiempo acumulado:0.075933456420898
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[30]: 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_ES ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'es'
WHERE EMP.ID_EMPRESA = 19864742;
Tiempo de la consulta:
0.00073504447937012Tiempo acumulado:0.076668500900269
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[31]: SELECT OLD_URL, NEW_URL
FROM LO_URL_301 U
WHERE U.OLD_URL = '/rutas-4x4/green-devil-safari--e19864742';
Tiempo de la consulta:
0.00092411041259766Tiempo acumulado:0.077592611312866
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[32]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.001878023147583Tiempo acumulado:0.079470634460449
(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 = 'pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00070810317993164Tiempo acumulado:0.080178737640381
(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 = 'pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00059294700622559Tiempo acumulado:0.080771684646606
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[35]: 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_pt_PT.LO_EMPRESAS EMP
LEFT JOIN Prod_Yumping_pt_PT.LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
LEFT JOIN Prod_Yumping_pt_PT.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND (SECI.ID_TROPIC = 8
AND SECI.FK_ID_IDIOMA_SI18N = 'pt')
WHERE EMP.ID_EMPRESA = 19864742;
Tiempo de la consulta:
0.00076007843017578Tiempo acumulado:0.081531763076782
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[36]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_empresa_trad'
AND CFG.AMBITO IN ('pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050806999206543Tiempo acumulado:0.082039833068848
(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 = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00056219100952148Tiempo acumulado:0.082602024078369
(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 = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0023491382598877Tiempo acumulado:0.084951162338257
(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 = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0028529167175293Tiempo acumulado:0.087804079055786
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[40]: 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_pt_PT.LO_EMPRESAS EMP
LEFT JOIN Prod_Yumping_pt_PT.LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
LEFT JOIN Prod_Yumping_pt_PT.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND (SECI.ID_TROPIC = 82
AND SECI.FK_ID_IDIOMA_SI18N = 'en')
WHERE EMP.ID_EMPRESA = 19864742;
Tiempo de la consulta:
0.00073003768920898Tiempo acumulado:0.088534116744995
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[41]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_empresa_trad'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050711631774902Tiempo acumulado:0.089041233062744
(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 = 'pt_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00071096420288086Tiempo acumulado:0.089752197265625
(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 = 'pt_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00078511238098145Tiempo acumulado:0.090537309646606
(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 = 'pt_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00055694580078125Tiempo acumulado:0.091094255447388
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[45]: 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_pt_PT.LO_EMPRESAS EMP
LEFT JOIN Prod_Yumping_pt_PT.LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
LEFT JOIN Prod_Yumping_pt_PT.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND (SECI.ID_TROPIC = 83
AND SECI.FK_ID_IDIOMA_SI18N = 'it')
WHERE EMP.ID_EMPRESA = 19864742;
Tiempo de la consulta:
0.00083398818969727Tiempo acumulado:0.091928243637085
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[46]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_empresa_trad'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00054502487182617Tiempo acumulado:0.092473268508911
(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 = 'pt_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0019872188568115Tiempo acumulado:0.094460487365723
(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 = 'pt_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('pt_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0031228065490723Tiempo acumulado:0.097583293914795
(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 = 'pt_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0029289722442627Tiempo acumulado:0.10051226615906
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[50]: 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_pt_PT.LO_EMPRESAS EMP
LEFT JOIN Prod_Yumping_pt_PT.LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
LEFT JOIN Prod_Yumping_pt_PT.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND (SECI.ID_TROPIC = 84
AND SECI.FK_ID_IDIOMA_SI18N = 'fr')
WHERE EMP.ID_EMPRESA = 19864742;
Tiempo de la consulta:
0.00068998336791992Tiempo acumulado:0.10120224952698
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[51]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_empresa_trad'
AND CFG.AMBITO IN ('pt_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0054531097412109Tiempo acumulado:0.10665535926819
(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 = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0005490779876709Tiempo acumulado:0.10720443725586
(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 = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00097799301147461Tiempo acumulado:0.10818243026733
(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 = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00055408477783203Tiempo acumulado:0.10873651504517
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[55]: 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_pt_PT.LO_EMPRESAS EMP
LEFT JOIN Prod_Yumping_pt_PT.LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
LEFT JOIN Prod_Yumping_pt_PT.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND (SECI.ID_TROPIC = 86
AND SECI.FK_ID_IDIOMA_SI18N = 'ch')
WHERE EMP.ID_EMPRESA = 19864742;
Tiempo de la consulta:
0.00067901611328125Tiempo acumulado:0.10941553115845
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[56]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_empresa_trad'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00092387199401855Tiempo acumulado:0.11033940315247
(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 = 'pt_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00058889389038086Tiempo acumulado:0.11092829704285
(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 = 'pt_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0022540092468262Tiempo acumulado:0.11318230628967
(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 = 'pt_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0019299983978271Tiempo acumulado:0.1151123046875
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[60]: 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_pt_PT.LO_EMPRESAS EMP
LEFT JOIN Prod_Yumping_pt_PT.LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
LEFT JOIN Prod_Yumping_pt_PT.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND (SECI.ID_TROPIC = 87
AND SECI.FK_ID_IDIOMA_SI18N = 'de')
WHERE EMP.ID_EMPRESA = 19864742;
Tiempo de la consulta:
0.00068807601928711Tiempo acumulado:0.11580038070679
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[61]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_empresa_trad'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0037579536437988Tiempo acumulado:0.11955833435059
(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 = 'pt_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00055217742919922Tiempo acumulado:0.12011051177979
(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 = 'pt_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('pt_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0021159648895264Tiempo acumulado:0.12222647666931
(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 = 'pt_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('pt_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00054812431335449Tiempo acumulado:0.12277460098267
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[65]: 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_pt_PT.LO_EMPRESAS EMP
LEFT JOIN Prod_Yumping_pt_PT.LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
LEFT JOIN Prod_Yumping_pt_PT.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND (SECI.ID_TROPIC = 85
AND SECI.FK_ID_IDIOMA_SI18N = 'es')
WHERE EMP.ID_EMPRESA = 19864742;
Tiempo de la consulta:
0.00067305564880371Tiempo acumulado:0.12344765663147
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[66]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'pt_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'RequestUrl_empresa_trad'
AND CFG.AMBITO IN ('pt_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.002161979675293Tiempo acumulado:0.12560963630676
(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 = 'pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0059590339660645Tiempo acumulado:0.13156867027283
(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 = 'pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0033400058746338Tiempo acumulado:0.13490867614746
(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 = 'pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0019278526306152Tiempo acumulado:0.13683652877808
(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 = 'pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0021259784698486Tiempo acumulado:0.13896250724792
(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 = 'pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0025460720062256Tiempo acumulado:0.14150857925415
(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 = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0020310878753662Tiempo acumulado:0.14353966712952
(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 = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0020909309387207Tiempo acumulado:0.14563059806824
(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 = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00054001808166504Tiempo acumulado:0.1461706161499
(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 = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00052595138549805Tiempo acumulado:0.1466965675354
(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 = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00052189826965332Tiempo acumulado:0.14721846580505
(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 = 'pt_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049304962158203Tiempo acumulado:0.14771151542664
(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 = 'pt_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.001708984375Tiempo acumulado:0.14942049980164
(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 = 'pt_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00060606002807617Tiempo acumulado:0.15002655982971
(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 = 'pt_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00059914588928223Tiempo acumulado:0.15062570571899
(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 = 'pt_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00056695938110352Tiempo acumulado:0.1511926651001
(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 = 'pt_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00053811073303223Tiempo acumulado:0.15173077583313
(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 = 'pt_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0030369758605957Tiempo acumulado:0.15476775169373
(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 = 'pt_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0013399124145508Tiempo acumulado:0.15610766410828
(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 = 'pt_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00051093101501465Tiempo acumulado:0.15661859512329
(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 = 'pt_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('pt_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00060200691223145Tiempo acumulado:0.15722060203552
(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 = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00051999092102051Tiempo acumulado:0.15774059295654
(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 = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.002816915512085Tiempo acumulado:0.16055750846863
(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 = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00058197975158691Tiempo acumulado:0.16113948822021
(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 = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00084495544433594Tiempo acumulado:0.16198444366455
(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 = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0005640983581543Tiempo acumulado:0.16254854202271
(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 = 'pt_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0034539699554443Tiempo acumulado:0.16600251197815
(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 = 'pt_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0059330463409424Tiempo acumulado:0.17193555831909
(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 = 'pt_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0012040138244629Tiempo acumulado:0.17313957214355
(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 = 'pt_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00071120262145996Tiempo acumulado:0.17385077476501
(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 = 'pt_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0019161701202393Tiempo acumulado:0.17576694488525
(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 = 'pt_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0051817893981934Tiempo acumulado:0.18094873428345
(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 = 'pt_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.002007007598877Tiempo acumulado:0.18295574188232
(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 = 'pt_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0046188831329346Tiempo acumulado:0.18757462501526
(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 = 'pt_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.000823974609375Tiempo acumulado:0.18839859962463
(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 = 'pt_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('pt_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049686431884766Tiempo acumulado:0.18889546394348
(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 = 'pt_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049400329589844Tiempo acumulado:0.18938946723938
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[103]: 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_ES ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'es'
WHERE EMP.ID_EMPRESA = 19864742;
Tiempo de la consulta:
0.00060892105102539Tiempo acumulado:0.18999838829041
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[104]: SELECT ID_EMPRESA, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_EMPRESA = 19864742;
Tiempo de la consulta:
0.00040411949157715Tiempo acumulado:0.19040250778198
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[105]: SELECT ID_EMPRESA, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_EMPRESA = 19864742;
Tiempo de la consulta:
0.00050687789916992Tiempo acumulado:0.19090938568115
(Prod_Yumping_pt_PT) (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 = 19864742;
Tiempo de la consulta:
0.00035905838012695Tiempo acumulado:0.19126844406128
(Prod_Yumping_pt_PT) (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 = 19864742;
Tiempo de la consulta:
0.0022060871124268Tiempo acumulado:0.19347453117371
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[108]: 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 = 19864742
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 = 19864742
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 = 19864742 OR EMP.ID_MADRE = 19864742
AND EMP.VALID IN (1 ,- 3)
AND EMP.PRECIO_ACTIVIDAD !=0
) AS PRECIO_MIN_MAX;
Tiempo de la consulta:
0.0052390098571777Tiempo acumulado:0.19871354103088
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[109]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.0013089179992676Tiempo acumulado:0.20002245903015
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[110]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.00037097930908203Tiempo acumulado:0.20039343833923
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[111]: 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 = 19864742
OR EMP.ID_MADRE= 19864742
AND EMP.VALID=1)
AND STATUS_REGALO='1'
LIMIT 3;
Tiempo de la consulta:
0.0016047954559326Tiempo acumulado:0.20199823379517
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[112]: 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 = 81
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
LEFT JOIN LO_GRUPOS GRU ON GRU.ID_SECTOR = EMP.ID_SECTOR
AND GRU.ID_TROPIC = 81
WHERE EMP.ID_EMPRESA = 19864742 OR EMP.ID_MADRE = 19864742
AND EMP.VALID = 1
AND EMP.EMP_MADRE NOT IN(1,3)
ORDER BY EMP_MADRE,DESC_SECTOR;
Tiempo de la consulta:
0.00076103210449219Tiempo acumulado:0.20275926589966
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[113]: 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_ES ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'es'
WHERE EMP.ID_EMPRESA = 19864742;
Tiempo de la consulta:
0.00049114227294922Tiempo acumulado:0.20325040817261
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[114]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864742
AND VALID = 1;
Tiempo de la consulta:
0.011964082717896Tiempo acumulado:0.2152144908905
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[115]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864742
AND FOTO = 'e-19864742-logos-97-172112858317211293159034.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0050749778747559Tiempo acumulado:0.22028946876526
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[116]: SELECT EMP_MADRE, ID_MADRE, ID_SECTOR
FROM LO_EMPRESAS EMP
INNER JOIN LO_EMPRESAS_TRADUCCION_ES ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'es'
WHERE EMP.ID_EMPRESA = 19864742;
Tiempo de la consulta:
0.00044488906860352Tiempo acumulado:0.22073435783386
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[117]: 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_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'es'
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='81'
AND SECI.FK_ID_IDIOMA_SI18N='es'
AND REI.IDIOMA='es'
AND ID_EMPRESA='19864742'
AND VALID_PD=1
AND OFERTA_PD=1
AND SECP.ID_ACTIVIDAD_PS = 22
AND PRE.VALID_PRE = 4
ORDER BY FECHA_CADUCIDAD_PD DESC
LIMIT 1;
Tiempo de la consulta:
0.002269983291626Tiempo acumulado:0.22300434112549
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[118]: SELECT N_VENTAS_EST, FEC_ULT_COMPRA
FROM LO_EMPRESAS_STAT
WHERE FK_ID_EST = 19864742
AND N_VENTAS_EST > 0
LIMIT 1;
Tiempo de la consulta:
0.0060930252075195Tiempo acumulado:0.22909736633301
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[119]: 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='19864742'
OR OP.ID_MADRE='19864742' )
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.0060908794403076Tiempo acumulado:0.23518824577332
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[120]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864742
AND VALID = 1;
Tiempo de la consulta:
0.0029160976409912Tiempo acumulado:0.23810434341431
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[121]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864742
AND FOTO = 'e-19864742-168613965-1624362071082029-3561974684773798462-n172112888917211293166713.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.0048680305480957Tiempo acumulado:0.2429723739624
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[122]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864742
AND FOTO = 'e-19864742-168613965-1624362071082029-3561974684773798462-n172112888917211293166713.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00063204765319824Tiempo acumulado:0.2436044216156
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[123]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864742
AND FOTO = 'e-19864742-168613965-1624362071082029-3561974684773798462-n172112888917211293166713.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0032060146331787Tiempo acumulado:0.24681043624878
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[124]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864742
AND VALID = 1;
Tiempo de la consulta:
0.0062317848205566Tiempo acumulado:0.25304222106934
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[125]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864742
AND FOTO = 'e-19864742-349117178-198413176465179-5130502868601707947-n172112890417211293175814.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00085711479187012Tiempo acumulado:0.25389933586121
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[126]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864742
AND FOTO = 'e-19864742-349117178-198413176465179-5130502868601707947-n172112890417211293175814.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0037381649017334Tiempo acumulado:0.25763750076294
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[127]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864742
AND FOTO = 'e-19864742-349117178-198413176465179-5130502868601707947-n172112890417211293175814.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0033199787139893Tiempo acumulado:0.26095747947693
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[128]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864742
AND VALID = 1;
Tiempo de la consulta:
0.007598876953125Tiempo acumulado:0.26855635643005
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[129]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864742
AND FOTO = 'e-19864742-348845951-216132921205912-8460848030749760930-n172112890717211293181091.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.001594066619873Tiempo acumulado:0.27015042304993
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[130]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864742
AND FOTO = 'e-19864742-348845951-216132921205912-8460848030749760930-n172112890717211293181091.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00082707405090332Tiempo acumulado:0.27097749710083
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[131]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864742
AND FOTO = 'e-19864742-348845951-216132921205912-8460848030749760930-n172112890717211293181091.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00047898292541504Tiempo acumulado:0.27145648002625
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[132]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864742
AND VALID = 1;
Tiempo de la consulta:
0.0024080276489258Tiempo acumulado:0.27386450767517
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[133]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864742
AND FOTO = 'e-19864742-imagenes-web-12-172112902417211293194197.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.0012218952178955Tiempo acumulado:0.27508640289307
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[134]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864742
AND FOTO = 'e-19864742-imagenes-web-12-172112902417211293194197.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00051689147949219Tiempo acumulado:0.27560329437256
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[135]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864742
AND FOTO = 'e-19864742-imagenes-web-12-172112902417211293194197.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0027821063995361Tiempo acumulado:0.27838540077209
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[136]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864742
AND VALID = 1;
Tiempo de la consulta:
0.00058197975158691Tiempo acumulado:0.27896738052368
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[137]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864742
AND FOTO = 'e-19864742-disfrutando-de-las-vistas172112911717211293217174.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00049209594726562Tiempo acumulado:0.27945947647095
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[138]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864742
AND FOTO = 'e-19864742-disfrutando-de-las-vistas172112911717211293217174.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0018570423126221Tiempo acumulado:0.28131651878357
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[139]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864742
AND FOTO = 'e-19864742-disfrutando-de-las-vistas172112911717211293217174.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0085937976837158Tiempo acumulado:0.28991031646729
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[140]: SELECT EMP_MADRE, ID_MADRE, ID_SECTOR
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19864742;
Tiempo de la consulta:
0.0010440349578857Tiempo acumulado:0.29095435142517
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[141]: 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_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'es'
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 = 'es'
INNER JOIN LO_POBLACION_PT POI ON POI.ID_POBLACION = PRE.ID_POBLACION_PRE
AND POI.IDIOMA = 'es'
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='es'
AND SECI.ID_TROPIC = 81
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 = 19864742
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.0075709819793701Tiempo acumulado:0.29852533340454
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[142]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 90066
AND VALID = 1;
Tiempo de la consulta:
0.0018370151519775Tiempo acumulado:0.30036234855652
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[143]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 90066
AND FOTO = 'p-90066-4x41721132841_17211341121097.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.0026810169219971Tiempo acumulado:0.30304336547852
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[144]: SELECT F_WIDTH, F_HEIGHT
FROM LO_FOTOS
WHERE ID_PRECIO = 90066
AND FOTO = 'p-90066-4x41721132841_17211341121097.jpg';
Tiempo de la consulta:
0.0025718212127686Tiempo acumulado:0.30561518669128
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[145]: 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_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'es'
WHERE ID_PRECIO = 90066
AND VALID_PRE = 4
GROUP BY PRE.ID_PRECIO
HAVING FEC_ULT_COMPRA IS NOT NULL
LIMIT 1;
Tiempo de la consulta:
0.00073122978210449Tiempo acumulado:0.30634641647339
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[146]: 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_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'es'
WHERE PRE.ID_PRECIO = 90066;
Tiempo de la consulta:
0.001072883605957Tiempo acumulado:0.30741930007935
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[147]: 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 = 90066;
Tiempo de la consulta:
0.0033318996429443Tiempo acumulado:0.31075119972229
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[148]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 90068
AND VALID = 1;
Tiempo de la consulta:
0.0022678375244141Tiempo acumulado:0.3130190372467
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[149]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 90068
AND FOTO = 'p-90068-337411407-201408332518312-4955312160672574795-n1721136364_17211429072273.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.0018508434295654Tiempo acumulado:0.31486988067627
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[150]: SELECT F_WIDTH, F_HEIGHT
FROM LO_FOTOS
WHERE ID_PRECIO = 90068
AND FOTO = 'p-90068-337411407-201408332518312-4955312160672574795-n1721136364_17211429072273.jpg';
Tiempo de la consulta:
0.0019130706787109Tiempo acumulado:0.31678295135498
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[151]: 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_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'es'
WHERE ID_PRECIO = 90068
AND VALID_PRE = 4
GROUP BY PRE.ID_PRECIO
HAVING FEC_ULT_COMPRA IS NOT NULL
LIMIT 1;
Tiempo de la consulta:
0.00086808204650879Tiempo acumulado:0.31765103340149
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[152]: 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_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'es'
WHERE PRE.ID_PRECIO = 90068;
Tiempo de la consulta:
0.00086092948913574Tiempo acumulado:0.31851196289062
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[153]: 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 = 90068;
Tiempo de la consulta:
0.00098991394042969Tiempo acumulado:0.31950187683105
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[154]: 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_ES ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'es'
WHERE EMP.ID_EMPRESA = 19864742;
Tiempo de la consulta:
0.0007789134979248Tiempo acumulado:0.32028079032898
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[155]: 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_PT PO ON PO.ID_POBLACION = PED.ID_POBLACION
AND PO.IDIOMA = 'es'
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PO.ID_REGION
AND REI.IDIOMA = 'es'
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = 22
AND SECI.FK_ID_IDIOMA_SI18N = 'es';
Tiempo de la consulta:
0.0033330917358398Tiempo acumulado:0.32361388206482
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[156]: 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 = 'es'
LEFT JOIN LO_REGION_ADM1_I18N REIA ON REIA.ID_REGION_ADM1 = RE.ID_REGION_ADM1
AND REIA.IDIOMA = 'es'
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 = 'es'
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 = 'es'
WHERE EMP.ID_EMPRESA = 19864742;
Tiempo de la consulta:
0.0014090538024902Tiempo acumulado:0.32502293586731
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[157]: 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 = 757
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.0027289390563965Tiempo acumulado:0.32775187492371
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[158]: SELECT N_OFERTAS
FROM
LO_REGION_STATS PS
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PS.ID_REGION
AND REI.IDIOMA = 'es'
WHERE (PS.N_OFERTAS > 0 )
AND PS.ID_REGION = 757
AND PS.ID_SECTOR = 22
GROUP BY PS.ID_REGION;
Tiempo de la consulta:
0.00062203407287598Tiempo acumulado:0.32837390899658
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[159]: SELECT N_OFERTAS
FROM
LO_POBLACION_PT_STATS PS
INNER JOIN LO_POBLACION_PT PO ON PS.ID_POBLACION = PO.ID_POBLACION
AND PO.ID_REGION = 757
AND PO.IDIOMA = 'es'
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PO.ID_REGION
AND REI.IDIOMA = 'es'
WHERE (PS.N_OFERTAS > 0 )
AND PO.ID_REGION = 757
AND PS.ID_POBLACION = 75982
AND PS.ID_SECTOR = 22
GROUP BY PS.ID_POBLACION;
Tiempo de la consulta:
0.001039981842041Tiempo acumulado:0.32941389083862
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[160]: 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 = 'es'
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 = 81
AND SECI.ID_SECTOR = 22
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.0044460296630859Tiempo acumulado:0.33385992050171
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[161]: 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_ES ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'es'
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='es'
INNER JOIN LO_REGION_ADM1 REIAD ON RE.ID_REGION_ADM1 = REIAD.ID_REGION_ADM1
LEFT JOIN LO_POBLACION_PT PO ON EMP.ID_POBLACION = PO.ID_POBLACION
AND PO.IDIOMA='es'
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 = 81
AND SECI.FK_ID_IDIOMA_SI18N = 'es')
INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
AND (GRU.ID_TROPIC = 81)
WHERE EMP.ID_EMPRESA = 19864742
AND EMP.VALID IN ('1', '-3')
LIMIT 1;
Tiempo de la consulta:
0.0038299560546875Tiempo acumulado:0.3376898765564
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[162]: 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_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'es'
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='81'
AND SECI.FK_ID_IDIOMA_SI18N='es'
AND REI.IDIOMA='es'
AND VALID_PRE IN(4)
AND PRE.ID_EMPRESA_PRE ='19864742'
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.0035121440887451Tiempo acumulado:0.34120202064514
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[163]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = ''
AND SEO.ID_TROPIC = 81
AND SEO.FK_ID_REG_ADM = 0
AND 1=1;
Tiempo de la consulta:
0.0057730674743652Tiempo acumulado:0.34697508811951
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[164]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S22'
AND SEO.ID_TROPIC = 81
AND SEO.FK_ID_REG_ADM = 0
AND 1=1;
Tiempo de la consulta:
0.0066180229187012Tiempo acumulado:0.35359311103821
(Prod_Yumping_pt_PT) (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_ES ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'es'
WHERE EMP.ID_EMPRESA = 19864742;
Tiempo de la consulta:
0.0015912055969238Tiempo acumulado:0.35518431663513
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[166]: 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_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'es'
WHERE ID_PRECIO = 90066
AND VALID_PRE = 4
GROUP BY PRE.ID_PRECIO
HAVING FEC_ULT_COMPRA IS NOT NULL
LIMIT 1;
Tiempo de la consulta:
0.0023791790008545Tiempo acumulado:0.35756349563599
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[167]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = ''
AND SEO.ID_TROPIC = 81
AND SEO.FK_ID_REG_ADM = 0
AND 1=1;
Tiempo de la consulta:
0.0047111511230469Tiempo acumulado:0.36227464675903
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[168]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S22'
AND SEO.ID_TROPIC = 81
AND SEO.FK_ID_REG_ADM = 0
AND 1=1;
Tiempo de la consulta:
0.0012860298156738Tiempo acumulado:0.36356067657471
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[169]: 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 = 81
WHERE SEOHOME.ID_TROPIC = 81
AND SEOHOME.ID_KEY = 'S22'
AND SEO_VALID in (0,1)
AND SEOHOME.ID_LOCALIZACION='';
Tiempo de la consulta:
0.011535882949829Tiempo acumulado:0.37509655952454
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[170]: 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 = 90066
AND OP.VALID = 1;
Tiempo de la consulta:
0.016685009002686Tiempo acumulado:0.39178156852722
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[171]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 90066
AND VALID = 1;
Tiempo de la consulta:
0.0036191940307617Tiempo acumulado:0.39540076255798
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[172]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 90066
AND FOTO = 'p-90066-4x41721132841_17211341121097.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.0011889934539795Tiempo acumulado:0.39658975601196
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[173]: 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_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'es'
WHERE PRE.ID_PRECIO = 90066;
Tiempo de la consulta:
0.0023479461669922Tiempo acumulado:0.39893770217896
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[174]: 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 = 90066;
Tiempo de la consulta:
0.0009920597076416Tiempo acumulado:0.3999297618866
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[175]: SELECT EXITO
FROM LO_PRECIOS_EXITO
WHERE ID_PRECIO = 90066
LIMIT 1;
Tiempo de la consulta:
0.0010201930999756Tiempo acumulado:0.40094995498657
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[176]: SELECT COUNT(*) AS TOTAL
FROM LO_PRECIOS_SECTORES PS
WHERE PS.ID_ACTIVIDAD_PS NOT IN (100,101)
AND PS.ID_PRECIO_PS = 90066;
Tiempo de la consulta:
0.00082588195800781Tiempo acumulado:0.40177583694458
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[177]: SELECT *
FROM LO_PRECIOS_DIA_ESPECIAL PD
WHERE PD.ID_PRECIO_DE = 90066
AND ID_TIPO_DE = 7
AND VALID = 1;
Tiempo de la consulta:
0.0033259391784668Tiempo acumulado:0.40510177612305
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[178]: SELECT *
FROM LO_PRECIOS_DISPONIBILIDAD_CALENDARIO
WHERE VALID = 1
AND ID_PRECIO = 90066;
Tiempo de la consulta:
0.00097489356994629Tiempo acumulado:0.40607666969299
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[179]: 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_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'es'
WHERE ID_PRECIO = 90068
AND VALID_PRE = 4
GROUP BY PRE.ID_PRECIO
HAVING FEC_ULT_COMPRA IS NOT NULL
LIMIT 1;
Tiempo de la consulta:
0.0011639595031738Tiempo acumulado:0.40724062919617
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[180]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = ''
AND SEO.ID_TROPIC = 81
AND SEO.FK_ID_REG_ADM = 0
AND 1=1;
Tiempo de la consulta:
0.00069999694824219Tiempo acumulado:0.40794062614441
(Prod_Yumping_pt_PT) (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 = 'S22'
AND SEO.ID_TROPIC = 81
AND SEO.FK_ID_REG_ADM = 0
AND 1=1;
Tiempo de la consulta:
0.00060510635375977Tiempo acumulado:0.40854573249817
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[182]: 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 = 81
WHERE SEOHOME.ID_TROPIC = 81
AND SEOHOME.ID_KEY = 'S22'
AND SEO_VALID in (0,1)
AND SEOHOME.ID_LOCALIZACION='';
Tiempo de la consulta:
0.0095150470733643Tiempo acumulado:0.41806077957153
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[183]: 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 = 90068
AND OP.VALID = 1;
Tiempo de la consulta:
0.00067901611328125Tiempo acumulado:0.41873979568481
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[184]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 90068
AND VALID = 1;
Tiempo de la consulta:
0.00078105926513672Tiempo acumulado:0.41952085494995
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[185]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 90068
AND FOTO = 'p-90068-337411407-201408332518312-4955312160672574795-n1721136364_17211429072273.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00093483924865723Tiempo acumulado:0.42045569419861
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[186]: SELECT URL_PRE, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, ID_PRECIO, FK_ID_PAIS_PRE
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'es'
WHERE PRE.ID_PRECIO = 90068;
Tiempo de la consulta:
0.00051999092102051Tiempo acumulado:0.42097568511963
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[187]: SELECT ID_PRECIO_PADRE
FROM LO_PRECIOS_ASIGNACION PA
INNER JOIN LO_PRECIOS PRE ON PRE.ID_PRECIO = PA.ID_PRECIO_PADRE
AND PRE.VALID_PRE = 4
WHERE PA.ID_PRECIO = 90068;
Tiempo de la consulta:
0.00046515464782715Tiempo acumulado:0.42144083976746
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[188]: SELECT EXITO
FROM LO_PRECIOS_EXITO
WHERE ID_PRECIO = 90068
LIMIT 1;
Tiempo de la consulta:
0.00037884712219238Tiempo acumulado:0.42181968688965
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[189]: SELECT COUNT(*) AS TOTAL
FROM LO_PRECIOS_SECTORES PS
WHERE PS.ID_ACTIVIDAD_PS NOT IN (100,101)
AND PS.ID_PRECIO_PS = 90068;
Tiempo de la consulta:
0.00073909759521484Tiempo acumulado:0.42255878448486
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[190]: SELECT *
FROM LO_PRECIOS_DIA_ESPECIAL PD
WHERE PD.ID_PRECIO_DE = 90068
AND ID_TIPO_DE = 7
AND VALID = 1;
Tiempo de la consulta:
0.00054311752319336Tiempo acumulado:0.42310190200806
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[191]: SELECT *
FROM LO_PRECIOS_DISPONIBILIDAD_CALENDARIO
WHERE VALID = 1
AND ID_PRECIO = 90068;
Tiempo de la consulta:
0.0026571750640869Tiempo acumulado:0.42575907707214
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[192]: SELECT EE.*, EE.DESCRIPCION, EE.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 = 'es'
WHERE EE.ID_EMPRESA = 19864742
AND EE.VALID = 1;
Tiempo de la consulta:
0.0015289783477783Tiempo acumulado:0.42728805541992
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[193]: SELECT MIN(DATE_FORMAT(EMP.FEC_INSERT,'%Y/%m/%d') ) AS FECHA
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19864742 OR ID_MADRE = 19864742
AND EMP.VALID = 1;
Tiempo de la consulta:
0.004979133605957Tiempo acumulado:0.43226718902588
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[194]: 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 = 19864742 OR ID_MADRE = 19864742
AND EMP.VALID = 1;
Tiempo de la consulta:
0.0036170482635498Tiempo acumulado:0.43588423728943
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[195]: SELECT *
FROM LO_RESERVAS_FISCAL
WHERE ID_EMPRESA_RF='19864742';
Tiempo de la consulta:
0.0092470645904541Tiempo acumulado:0.44513130187988
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[196]: 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 = 19864742;
Tiempo de la consulta:
0.0039200782775879Tiempo acumulado:0.44905138015747
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[197]: SELECT *
FROM LO_EMPRESAS_IDIOMAS EI
WHERE EI.ID_EMPRESA = 19864742;
Tiempo de la consulta:
0.00093603134155273Tiempo acumulado:0.44998741149902
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[198]: 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 = 81
LEFT JOIN LO_REGION_I18N REG ON REG.ID_REGION = AW.ID_PROVINCIA
AND REG.IDIOMA = 'es'
WHERE (ID_EMPRESA = 19864742 OR ID_MADRE = 19864742)
GROUP BY ANO, ID_SECTOR, ID_PROVINCIA
ORDER BY ANO DESC;
Tiempo de la consulta:
0.011856079101562Tiempo acumulado:0.46184349060059
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[199]: 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_ES ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'es'
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='es'
INNER JOIN LO_REGION_ADM1 REIAD ON RE.ID_REGION_ADM1 = REIAD.ID_REGION_ADM1
LEFT JOIN LO_POBLACION_PT PO ON EMP.ID_POBLACION = PO.ID_POBLACION
AND PO.IDIOMA='es'
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 = 81
AND SECI.FK_ID_IDIOMA_SI18N = 'es')
INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
AND (GRU.ID_TROPIC = 81)
WHERE EMP.ID_EMPRESA = 19864742
AND EMP.VALID IN ('1', '-3')
LIMIT 1;
Tiempo de la consulta:
0.0013241767883301Tiempo acumulado:0.46316766738892
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[200]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864742
AND VALID = 1;
Tiempo de la consulta:
0.00074601173400879Tiempo acumulado:0.46391367912292
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[201]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19864742
AND FOTO = 'e-19864742-168613965-1624362071082029-3561974684773798462-n172112888917211293166713.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00052499771118164Tiempo acumulado:0.46443867683411
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[202]: 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 = '757'
AND REI.IDIOMA = 'es';
Tiempo de la consulta:
0.00048708915710449Tiempo acumulado:0.46492576599121
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingwrite_deskSQL[203]: INSERT INTO LO_EMPRESAS_VISITAS_DIARIO
(ID_EMPRESA,FECHA, VISITAS)
VALUES
(19864742, SYSDATE(), 1)
ON DUPLICATE KEY UPDATE
VISITAS = VISITAS + 1;
Tiempo de la consulta:
0.021201848983765Tiempo acumulado:0.48612761497498
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[204]: 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 = 'es'
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 = 6
INNER JOIN LO_SECTORES_I18N SECI ON PS.ID_SECTOR = SECI.ID_SECTOR
AND SECI.ID_TROPIC='81'
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
WHERE
REI.ID_REGION = 757
AND (PS.N_OFERTAS > 0
AND PS.N_OFERTAS IS NOT NULL)
ORDER BY NEMPRESAS DESC;
Tiempo de la consulta:
0.0010378360748291Tiempo acumulado:0.4871654510498
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[205]: SELECT COUNT(*) AS NEMPRESAS
FROM LO_REGION_STATS
WHERE ID_REGION = 757
AND ID_GRUPO = 6;
Tiempo de la consulta:
0.0079350471496582Tiempo acumulado:0.49510049819946
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[206]: 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 = '757'
AND REI.IDIOMA = 'es';
Tiempo de la consulta:
0.00045299530029297Tiempo acumulado:0.49555349349976
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[207]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S22'
AND (SEO.ID_TROPIC = 81
);
Tiempo de la consulta:
0.0024800300598145Tiempo acumulado:0.49803352355957
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[208]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S2'
AND (SEO.ID_TROPIC = 81
);
Tiempo de la consulta:
0.00044512748718262Tiempo acumulado:0.49847865104675
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[209]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S6'
AND (SEO.ID_TROPIC = 81
);
Tiempo de la consulta:
0.0035121440887451Tiempo acumulado:0.5019907951355
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[210]: SELECT *
FROM LO_EQUIPO_EDITORIAL EE
WHERE EE.ID_TROPIC = 81;
Tiempo de la consulta:
0.001410961151123Tiempo acumulado:0.50340175628662
