yu-front-06.localdomain (172.30.2.194:443)

prod.yumping.com

/empresa.php

BBDD->Prod_Yumping_it_IT
AMBITO->it_ch
AMBITO_AJAX->it_ch
AMBITO_AJAX COOKIE->es_ch
locale LO_CONFIG->cn_IT
locale php->cn_IT
Fuente tráfico->0

SESSION VARS

DEFINED VARS

$tpage->empresa

Cache VARS

NOCFG->memcache_port->11212
CFG->memcache_main_server->172.30.2.194
CFG->memcache_add_servers->172.30.2.194
YMMemcache::memcache_stats->

SERVER VARS

HTTP_REFERER

Request VARS

ambito_lang->zh-hans
id_empresa->19742358
tpage->empresa
nomb_emp->kitesurf-la-caletta
rel_alternate->1

Total queries: 179

Tiempo total: 0.23216009140015

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[1]: SELECT CFG.ID, CFG.NAME, IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '', CFG.VALUE_PROD, CFG.VALUE) VALUE , CFG.AMBITO, CFG.VISIBLE_AJAX, CFG.TIME
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.AMBITO IN ('global', 'es_ch')
            ORDER BY CFG.NAME;

Tiempo de la consulta: 0.0076839923858643

Tiempo acumulado:0.0076839923858643

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[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.00063920021057129

Tiempo acumulado:0.0083231925964355

(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[3]: SELECT ID_PAIS
            FROM ( SELECT EMP.ID_PAIS
            FROM Prod_Yumping_es_ES.LO_EMPRESAS EMP
            WHERE EMP.ID_EMPRESA = 19742358
                AND fnGoogleUrl(EMP.NOMBRE) = 'kitesurf-la-caletta' UNION ALL SELECT EMP.ID_PAIS
            FROM Prod_Yumping_pt_PT.LO_EMPRESAS EMP
            WHERE EMP.ID_EMPRESA = 19742358
                AND fnGoogleUrl(EMP.NOMBRE) = 'kitesurf-la-caletta' UNION ALL SELECT EMP.ID_PAIS
            FROM Prod_Yumping_it_IT.LO_EMPRESAS EMP
            WHERE EMP.ID_EMPRESA = 19742358
                AND fnGoogleUrl(EMP.NOMBRE) = 'kitesurf-la-caletta' UNION ALL SELECT EMP.ID_PAIS
            FROM Prod_Yumping_fr_FR.LO_EMPRESAS EMP
            WHERE EMP.ID_EMPRESA = 19742358
                AND fnGoogleUrl(EMP.NOMBRE) = 'kitesurf-la-caletta' UNION ALL SELECT EMP.ID_PAIS
            FROM Prod_Yumping_co_UK.LO_EMPRESAS EMP
            WHERE EMP.ID_EMPRESA = 19742358
                AND fnGoogleUrl(EMP.NOMBRE) = 'kitesurf-la-caletta' UNION ALL SELECT EMP.ID_PAIS
            FROM Prod_Yumping_mx_MX.LO_EMPRESAS EMP
            WHERE EMP.ID_EMPRESA = 19742358
                AND fnGoogleUrl(EMP.NOMBRE) = 'kitesurf-la-caletta' ) AS EMPRESA;

Tiempo de la consulta: 0.0064718723297119

Tiempo acumulado:0.014795064926147

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[4]: SELECT CFG.ID, CFG.NAME, IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '', CFG.VALUE_PROD, CFG.VALUE) VALUE , CFG.AMBITO, CFG.VISIBLE_AJAX, CFG.TIME
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.AMBITO IN ('global', 'it_ch')
            ORDER BY CFG.NAME;

Tiempo de la consulta: 0.0077278614044189

Tiempo acumulado:0.022522926330566

(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[5]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;

Tiempo de la consulta: 0.00049304962158203

Tiempo acumulado:0.023015975952148

(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[6]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;

Tiempo de la consulta: 0.0076031684875488

Tiempo acumulado:0.030619144439697

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[7]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'ambito_lang';

Tiempo de la consulta: 0.00060510635375977

Tiempo acumulado:0.031224250793457

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[8]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'id_empresa';

Tiempo de la consulta: 0.00036787986755371

Tiempo acumulado:0.031592130661011

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[9]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'tpage';

Tiempo de la consulta: 0.00035214424133301

Tiempo acumulado:0.031944274902344

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[10]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'nomb_emp';

Tiempo de la consulta: 0.00033807754516602

Tiempo acumulado:0.03228235244751

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[11]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'rel_alternate';

Tiempo de la consulta: 0.00032496452331543

Tiempo acumulado:0.032607316970825

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[12]: SELECT EMP.COMO_LLEGAR COMO_LLEGAR_ORI, EMP.GALERIA_DESC GALERIA_DESC_ORI, EMP.VIDEOS_TEXT VIDEOS_TEXT_ORI,EMP.VIDEOS_DESC VIDEOS_DESC_ORI, EMP.EMP_MADRE,EMP.LOGOTIPO,EMP.ID_EMPRESA,EMP.DIRECCION, PO.DESC_POBLACION, PO.URL_POBLACION, REI.DESC_REGION,EMP.DS_ACTIVO,EMP.ID_PAIS, EMP.TELEFONO,EMP.NOPINIONES,EMP.VIDEOS_CODE,SEC.ID_GRUPO,SECI.DESC_SECTOR,EMP.FOTOPRINCIPAL, EMP.GALERIA,EMP.MADRE_NAME,EMP.PRECIO_ACTIVIDAD,EMP.TIPOCUENTA,SECI.URL URL_SECTOR, EMP.LICENCIA_EMPRESA,EMP.ID_POBLACION,EMP.VALID,EMP.ID_PROVINCIA,EMP.ID_SECTOR, EMP.VIDEOS_CODE,EMP.VIDEOS_DESC,EMP.CLIENTE,RE.ID_REGION,N_VENTAS_EST, EMP.COLAB_EMPRESAS, EMP.ID_MADRE ID_MADRE,REI.URL URL_REGION, EMP.LATITUDE LATITUDE,EMP.COD_POSTAL, EMP.LONGITUDE LONGITUDE,PO.URL_POBLACION, ES.NOPINIONES_EST,ES.N_PRECIOS_EST,ES.VISITAS,PUNTOS_EST,EMP.LOGIN,EMP.PASSWORD,EMP.PERS_CTCTO, EMP.TELEFONOMOVIL, EMP.FAX,EMP.WEB,EMP.MAIL,EMP.ACCOUNT_MANAGER,RESPUESTARAPIDA,CENTRAL_ACTIVA, NOPINIONES_EST,EMP.MAIL_CC, EMP.ACEPTAR_CR,EMP.VIDEOS_TEXT,ES.PRECIO_EST, ES.PUNTOS_EST, ES.RIESGO_EST, ES.ATENCION_EST, EMP.URL, ET.DESCRIPCION_ET DESCRIPCION,GALERIA_DESC_ET GALERIA_DESC,VIDEOS_TEXT_ET VIDEOS_TEXT,VIDEOS_DESC_ET VIDEOS_DESC,COMO_LLEGAR_ET COMO_LLEGAR,URL_ET URL, EMP.NOMBRE NOMBRE, ET.EVENT_PLANNING EVENT_PLANNING, IF (EMP.EMP_MADRE = 0, CASE EMP.ID_SECTOR WHEN 13 THEN GRU.DESC_GRUPO WHEN 16 THEN GRU.DESC_GRUPO WHEN 2 THEN GRU.DESC_GRUPO WHEN 3 THEN GRU.DESC_GRUPO WHEN 56 THEN GRU.DESC_GRUPO WHEN 67 THEN GRU.DESC_GRUPO WHEN 7 THEN GRU.DESC_GRUPO WHEN 93 THEN GRU.DESC_GRUPO ELSE SECI.DESC_SECTOR END, SECI.DESC_SECTOR) AS DESC_SECTOR_BUSCADOR
            FROM LO_EMPRESAS EMP
            INNER JOIN LO_EMPRESAS_TRADUCCION_CH ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
                AND ET.IDIOMA_ET = 'ch'
            LEFT JOIN LO_EMPRESAS_STAT ES ON EMP.ID_EMPRESA = ES.FK_ID_EST
            INNER JOIN LO_REGION RE ON EMP.ID_PROVINCIA = RE.ID_REGION
            INNER JOIN LO_REGION_I18N REI ON RE.ID_REGION = REI.ID_REGION
                AND REI.IDIOMA='ch'
            INNER JOIN LO_REGION_ADM1 REIAD ON RE.ID_REGION_ADM1 = REIAD.ID_REGION_ADM1
            LEFT JOIN LO_POBLACION_IT PO ON EMP.ID_POBLACION = PO.ID_POBLACION
                AND PO.IDIOMA='ch'
            INNER JOIN LO_SECTORES SEC ON EMP.ID_SECTOR = SEC.ID_SECTOR
            INNER JOIN LO_SECTORES_I18N SECI ON SEC.ID_SECTOR = SECI.ID_SECTOR
                AND (SECI.ID_TROPIC = 36
                AND SECI.FK_ID_IDIOMA_SI18N = 'ch')
            INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
                AND (GRU.ID_TROPIC = 36)
            WHERE EMP.ID_EMPRESA = 19742358
                AND EMP.VALID IN ('1', '-3')
            LIMIT 1;

Tiempo de la consulta: 0.0099010467529297

Tiempo acumulado:0.042508363723755

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[13]: SELECT EMP.COMO_LLEGAR COMO_LLEGAR_ORI, EMP.GALERIA_DESC GALERIA_DESC_ORI, EMP.VIDEOS_TEXT VIDEOS_TEXT_ORI, EMP.EMP_MADRE,EMP.LOGOTIPO,EMP.ID_EMPRESA,EMP.DIRECCION, PO.DESC_POBLACION, PO.URL_POBLACION, REI.DESC_REGION,EMP.DS_ACTIVO,EMP.ID_PAIS, EMP.TELEFONO,EMP.NOPINIONES,EMP.VIDEOS_CODE,SEC.ID_GRUPO,SECI.DESC_SECTOR,EMP.FOTOPRINCIPAL, EMP.GALERIA,EMP.MADRE_NAME,EMP.PRECIO_ACTIVIDAD,EMP.TIPOCUENTA,SECI.URL URL_SECTOR, EMP.LICENCIA_EMPRESA,EMP.ID_POBLACION,EMP.VALID,EMP.ID_PROVINCIA,EMP.ID_SECTOR, EMP.VIDEOS_CODE,EMP.VIDEOS_DESC,EMP.CLIENTE,RE.ID_REGION,N_VENTAS_EST, EMP.COLAB_EMPRESAS, EMP.ID_MADRE ID_MADRE,REI.URL URL_REGION, EMP.LATITUDE LATITUDE,EMP.COD_POSTAL, EMP.LONGITUDE LONGITUDE,PO.URL_POBLACION, ES.NOPINIONES_EST,ES.N_PRECIOS_EST,ES.VISITAS,PUNTOS_EST,EMP.LOGIN,EMP.PASSWORD,EMP.PERS_CTCTO, EMP.TELEFONOMOVIL, EMP.FAX,EMP.WEB,EMP.MAIL,EMP.ACCOUNT_MANAGER,RESPUESTARAPIDA,CENTRAL_ACTIVA, NOPINIONES_EST,EMP.MAIL_CC, EMP.ACEPTAR_CR,EMP.VIDEOS_TEXT,ES.PRECIO_EST, ES.PUNTOS_EST, ES.RIESGO_EST, ES.ATENCION_EST, EMP.URL, ET.DESCRIPCION_ET DESCRIPCION,GALERIA_DESC_ET GALERIA_DESC,VIDEOS_TEXT_ET VIDEOS_TEXT,VIDEOS_DESC_ET VIDEOS_DESC,COMO_LLEGAR_ET COMO_LLEGAR,URL_ET URL, EMP.NOMBRE NOMBRE, ET.EVENT_PLANNING EVENT_PLANNING, IF (EMP.EMP_MADRE = 0, CASE EMP.ID_SECTOR WHEN 13 THEN GRU.DESC_GRUPO WHEN 16 THEN GRU.DESC_GRUPO WHEN 2 THEN GRU.DESC_GRUPO WHEN 3 THEN GRU.DESC_GRUPO WHEN 56 THEN GRU.DESC_GRUPO WHEN 67 THEN GRU.DESC_GRUPO WHEN 7 THEN GRU.DESC_GRUPO WHEN 93 THEN GRU.DESC_GRUPO ELSE SECI.DESC_SECTOR END, SECI.DESC_SECTOR) AS DESC_SECTOR_BUSCADOR
            FROM LO_EMPRESAS EMP
            INNER JOIN LO_EMPRESAS_TRADUCCION_CH ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
                AND ET.IDIOMA_ET = 'ch'
            LEFT JOIN LO_EMPRESAS_STAT ES ON EMP.ID_EMPRESA = ES.FK_ID_EST
            INNER JOIN LO_REGION RE ON EMP.ID_PROVINCIA = RE.ID_REGION
            INNER JOIN LO_REGION_I18N REI ON RE.ID_REGION = REI.ID_REGION
                AND REI.IDIOMA='ch'
            INNER JOIN LO_REGION_ADM1 REIAD ON RE.ID_REGION_ADM1 = REIAD.ID_REGION_ADM1
            LEFT JOIN LO_POBLACION_IT PO ON EMP.ID_POBLACION = PO.ID_POBLACION
                AND PO.IDIOMA='ch'
            INNER JOIN LO_SECTORES SEC ON EMP.ID_SECTOR = SEC.ID_SECTOR
            INNER JOIN LO_SECTORES_I18N SECI ON SEC.ID_SECTOR = SECI.ID_SECTOR
                AND (SECI.ID_TROPIC = 36
                AND SECI.FK_ID_IDIOMA_SI18N = 'ch')
            INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
                AND (GRU.ID_TROPIC = 36)
            WHERE EMP.ID_MADRE = 19742358
                AND EMP.EMP_MADRE IN(2,4)
                AND EMP.VALID IN ('1', '-3');

Tiempo de la consulta: 0.0012969970703125

Tiempo acumulado:0.043805360794067

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[14]: SELECT ID_EMPRESA, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_EMPRESA = 19742358;

Tiempo de la consulta: 0.0015130043029785

Tiempo acumulado:0.045318365097046

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[15]: SELECT SEC.EXCLUYE_ALOJAMIENTO
            FROM LO_SECTORES SEC
            WHERE ID_SECTOR = 12
                AND EXCLUYE_ALOJAMIENTO = 0;

Tiempo de la consulta: 0.00034499168395996

Tiempo acumulado:0.045663356781006

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[16]: SELECT count(*)*2 AS N_OPIS, ROUND(AVG(VALORACION),2) AS VALORACION, ROUND(AVG(PRECIO),2) AS PRECIO, ROUND(AVG(RIESGO),2) AS RIESGO, ROUND(AVG(ATENCION),2) AS ATENCION, ROUND(AVG(PAREJA),2) AS PAREJA, ROUND(AVG(AMIGOS),2) AS AMIGOS, ROUND(AVG(TEAMBUILDING),2) AS TEAMBUILDING, ROUND(AVG(FAMILIA),2) AS FAMILIA, ROUND(AVG(NINOS),2) AS NINOS, ROUND(AVG(DESPEDIDAS),2) AS DESPEDIDAS, ROUND(AVG(REGALAR),2) AS REGALAR
FROM LO_EMPRESAS_OPINIONES_GOOGLE
WHERE ID_EMPRESA = 19742358;

Tiempo de la consulta: 0.00096797943115234

Tiempo acumulado:0.046631336212158

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[17]: SELECT TITULO_PRE,DESCRIPCION_PRE,INCLUYE_PRE,ALOJAMIENTO_TEXT_PRE,TRANSPORTE_TEXT_PRE, GALERIA_DESC_PRE,HORARIO_PRE, ID_PRECIO , SECI.ID_SECTOR, SECI.URL URL_SECTOR,REI.URL URL_REGION,PRE.PRECIO_UNITARIO_PRE, 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, PRE.FK_ID_PAIS_PRE AS ID_PAIS, COUNT(DISTINCT RC.ID_RESERVA_COMPRA) AS VENTAS, DESCUENTO_MIN_PRE DESCUENTO, PRE.FOTOPRINCIPAL_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(MAX(RC.FEC_INSERT_RC),'%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, PD.MIN_PERSONAS_PD,PRE.MAX_PERS_PRE,PD.MAX_PERSONAS_PD,PRE.ALOJAMIENTO_PRE, PRE.COMIDA_PRE, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, PRE.TRANSPORTE_PRE,REI.DESC_REGION, PRE.MULTIACTIVIDAD_PRE, SECI.DESC_SECTOR
            FROM LO_PRECIOS PRE
            INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'ch'
            INNER JOIN LO_PRECIOS_SECTORES SECP ON PRE.ID_PRECIO=SECP.ID_PRECIO_PS
            INNER JOIN LO_REGION_I18N REI ON PRE.ID_REGION_PRE=REI.ID_REGION
            INNER JOIN LO_SECTORES_I18N SECI ON SECP.ID_ACTIVIDAD_PS=SECI.ID_SECTOR
            INNER JOIN LO_SECTORES SEC ON SECI.ID_SECTOR=SEC.ID_SECTOR
            LEFT JOIN LO_RESERVAS_COMPRAS RC ON RC.ID_PRECIO_RC = PRE.ID_PRECIO
                AND RC.VALID_RC NOT IN(0,2,6,7)
            LEFT JOIN LO_PRECIOS_DESCUENTOS PD ON PD.ID_PRECIO_PD = PRE.ID_PRECIO
                AND PD.VALID_PD = 1
            LEFT JOIN LO_EMPRESAS_OPINIONES OP ON OP.RESERVA_FEEDBACK = RC.ID_RESERVA_COMPRA
                AND OP.VALID=1
            WHERE SECI.ID_TROPIC='36'
                AND SECI.FK_ID_IDIOMA_SI18N='ch'
                AND REI.IDIOMA='ch'
                AND VALID_PRE IN(4)
                AND SEC.ID_SECTOR = 12
                AND REI.ID_REGION = 606
                AND PRE.ID_EMPRESA_PRE !='19742358'
            GROUP BY ID_PRECIO
            ORDER BY VENTAS DESC, OFERTA_PD DESC, N_ORDER_EMP_PRE IS NULL ASC,N_ORDER_EMP_PRE ASC,N_ORDER_PRE DESC,PRECIO ASC
            LIMIT 3;

Tiempo de la consulta: 0.006274938583374

Tiempo acumulado:0.052906274795532

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[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 = '606'
                AND REI.IDIOMA = 'ch';

Tiempo de la consulta: 0.0004889965057373

Tiempo acumulado:0.05339527130127

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[19]: SELECT IF(EMP.TIPOCUENTA = '4', ROUND((RAND() * (500-400))+500), IF(EMP.TIPOCUENTA = '3', ROUND((RAND() * (400-300))+400), IF(EMP.TIPOCUENTA = '2'
                AND EMP.PRECIO_ACTIVIDAD != 0, ROUND((RAND() * (300-400))+300), 0))) AS ORDENA, EMP.EMP_MADRE,EMP.PUNTOS, EMP.ID_EMPRESA, EMP.ID_MADRE, EMP.DESCRIPCION,EMP.COLAB_EMPRESAS,EMP.CLIENTE , EMP.ID_PROVINCIA, EMP.ID_POBLACION, EMP.COD_POSTAL, EMP.DIRECCION, EMP.MAIL, EMP.TELEFONO, EMP.TELEFONOMOVIL, EMP.FAX, EMP.WEB,SECI.URL URL_SECTOR, REI.DESC_REGION, PO.DESC_POBLACION, SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO, EMP.GALERIA, EMP.GALERIA_DESC, EMP.LONGITUDE, EMP.LATITUDE, EMP.LOGOTIPO, EMP.FOTOPRINCIPAL, EMP.PROMOSECTOR ,EMP.PRECIO_ACTIVIDAD,EMP.TIPOCUENTA, ET.DESCRIPCION_ET DESCRIPCION,GALERIA_DESC_ET GALERIA_DESC,VIDEOS_TEXT_ET VIDEOS_TEXT,VIDEOS_DESC_ET VIDEOS_DESC,COMO_LLEGAR_ET COMO_LLEGAR,URL_ET URL, EMP.NOMBRE NOMBRE, ET.EVENT_PLANNING EVENT_PLANNING, GRU.DESC_GRUPO
            FROM LO_EMPRESAS EMP
            INNER JOIN LO_EMPRESAS_TRADUCCION_CH ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
                AND ET.IDIOMA_ET = 'ch'
            INNER JOIN LO_REGION RE ON RE.ID_REGION=EMP.ID_PROVINCIA
            INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=RE.ID_REGION
                AND REI.IDIOMA='ch'
            LEFT JOIN LO_POBLACION_IT PO ON PO.ID_POBLACION=EMP.ID_POBLACION
                AND PO.IDIOMA='ch' /*
            LEFT JOIN LO_POBLACION_I18N POI ON POI.ID_POBLACION=PO.ID_POBLACION */
            INNER JOIN LO_SECTORES SEC ON SEC.ID_SECTOR=EMP.ID_SECTOR
            INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR=SEC.ID_SECTOR
                AND SECI.ID_TROPIC='36'
                AND SECI.FK_ID_IDIOMA_SI18N='ch'
                AND EMP.EMP_MADRE <> '0'
                AND SEC.ID_SECTOR='12'
            INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
                AND GRU.ID_TROPIC = '36' /*
            LEFT JOIN LO_EMPRESAS_SNIPPETS_RELACIONES ESR ON ESR.ID_EMPRESA = EMP.ID_EMPRESA
                AND ESR.ID_TROPIC = '36' */
            WHERE EMP.VALID=1
                AND EMP.ID_EMPRESA > '19742358'
                AND EMP.ID_PROVINCIA='606'
                AND EMP.EMP_MADRE <> '3'
            GROUP BY EMP.ID_EMPRESA
            ORDER BY EMP.ID_EMPRESA ASC
            LIMIT 4;

Tiempo de la consulta: 0.0057289600372314

Tiempo acumulado:0.059124231338501

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[20]: 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, POI.DESC_POBLACION, SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO, EMP.GALERIA, EMP.GALERIA_DESC, EMP.LONGITUDE, EMP.LATITUDE, EMP.LOGOTIPO, EMP.FOTOPRINCIPAL, EMP.PROMOSECTOR ,EMP.PRECIO_ACTIVIDAD,EMP.TIPOCUENTA, ET.DESCRIPCION_ET DESCRIPCION,GALERIA_DESC_ET GALERIA_DESC,VIDEOS_TEXT_ET VIDEOS_TEXT,VIDEOS_DESC_ET VIDEOS_DESC,COMO_LLEGAR_ET COMO_LLEGAR,URL_ET URL, EMP.NOMBRE NOMBRE, ET.EVENT_PLANNING EVENT_PLANNING, GRU.DESC_GRUPO
            FROM LO_EMPRESAS EMP
            INNER JOIN LO_EMPRESAS_TRADUCCION_CH ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
                AND ET.IDIOMA_ET = 'ch'
            INNER JOIN LO_REGION RE ON RE.ID_REGION=EMP.ID_PROVINCIA
            INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=RE.ID_REGION
                AND REI.IDIOMA='ch'
            LEFT JOIN LO_POBLACION_IT PO ON PO.ID_POBLACION=EMP.ID_POBLACION
            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='36'
                AND SECI.FK_ID_IDIOMA_SI18N='ch'
                AND EMP.EMP_MADRE <> '0'
                AND SEC.ID_SECTOR='12'
            INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
                AND GRU.ID_TROPIC = '36' --
            LEFT JOIN LO_EMPRESAS_SNIPPETS_RELACIONES ESR ON ESR.ID_EMPRESA = EMP.ID_EMPRESA
                AND ESR.ID_TROPIC = '36'
            WHERE EMP.VALID=1
                AND EMP.ID_EMPRESA < '19742358'
                AND EMP.ID_PROVINCIA='606'
                AND EMP.EMP_MADRE <> '3'
            GROUP BY EMP.ID_EMPRESA
            ORDER BY EMP.ID_EMPRESA ASC
            LIMIT 3;

Tiempo de la consulta: 0.011970043182373

Tiempo acumulado:0.071094274520874

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[21]: SELECT GALERIA,GALERIA_DESC
            FROM LO_EMPRESAS_OPINIONES OP
            WHERE (OP.ID_EMPRESA='19742358' OR OP.ID_MADRE='19742358' )
                AND OP.VALID=1
                AND GALERIA IS NOT NULL
                AND GALERIA NOT IN('')
            ORDER BY OP.FEC_INSERT DESC;

Tiempo de la consulta: 0.0007479190826416

Tiempo acumulado:0.071842193603516

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[22]: SELECT EMP_MADRE, ID_MADRE, ID_SECTOR
            FROM LO_EMPRESAS EMP
            INNER JOIN LO_EMPRESAS_TRADUCCION_CH ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
                AND ET.IDIOMA_ET = 'ch'
            WHERE EMP.ID_EMPRESA = 19742358;

Tiempo de la consulta: 0.00044798851013184

Tiempo acumulado:0.072290182113647

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[23]: SELECT PRECIO_PRE, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, PRECIO_PD, ID_DESCUENTO_PD,ID_PRECIO,DATE_FORMAT(FECHA_CADUCIDAD_PD,'%d/%m/%Y') FEC_CAD, INCLUYE_PRE,GALERIA_PRE,FOTOPRINCIPAL_PRE,PRECIO_PRE, EMP.URL URL,SECI.URL URL_SECTOR,REI.URL URL_REGION, if(PRECIO_PD>0,LEAST(MIN(PRECIO_PD),PRECIO_PRE),LEAST(999999999,PRECIO_PRE) ) PRECIO, if(PRECIO_PD>0, (1-(MIN(PRECIO_PD)/PRECIO_PRE))*100 ,0) DESCUENTO
            FROM LO_PRECIOS PRE
            INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'ch'
            INNER JOIN LO_PRECIOS_SECTORES SECP ON PRE.ID_PRECIO=SECP.ID_PRECIO_PS
            INNER JOIN LO_PRECIOS_DESCUENTOS PD ON PRE.ID_PRECIO=PD.ID_PRECIO_PD
            INNER JOIN LO_EMPRESAS EMP ON PRE.ID_EMPRESA_PRE=EMP.ID_EMPRESA
            INNER JOIN LO_SECTORES SEC ON SECP.ID_ACTIVIDAD_PS=SEC.ID_SECTOR
            INNER JOIN LO_SECTORES_I18N SECI ON SEC.ID_SECTOR=SECI.ID_SECTOR
            INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PRE.ID_REGION_PRE
            INNER JOIN LO_POBLACION_I18N POI ON POI.ID_POBLACION=PRE.ID_POBLACION_PRE
            WHERE SECI.ID_TROPIC='36'
                AND SECI.FK_ID_IDIOMA_SI18N='ch'
                AND REI.IDIOMA='ch'
                AND ID_EMPRESA='19742358'
                AND VALID_PD=1
                AND OFERTA_PD=1
                AND SECP.ID_ACTIVIDAD_PS = 12
                AND PRE.VALID_PRE = 4
            ORDER BY FECHA_CADUCIDAD_PD DESC
            LIMIT 1;

Tiempo de la consulta: 0.0013329982757568

Tiempo acumulado:0.073623180389404

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[24]: SELECT URL, ET.DESCRIPCION_ET DESCRIPCION,GALERIA_DESC_ET GALERIA_DESC,VIDEOS_TEXT_ET VIDEOS_TEXT,VIDEOS_DESC_ET VIDEOS_DESC,COMO_LLEGAR_ET COMO_LLEGAR,URL_ET URL, EMP.NOMBRE NOMBRE, ET.EVENT_PLANNING EVENT_PLANNING, ID_EMPRESA
            FROM LO_EMPRESAS EMP
            INNER JOIN LO_EMPRESAS_TRADUCCION_CH ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
                AND ET.IDIOMA_ET = 'ch'
            WHERE EMP.ID_EMPRESA = 19742358;

Tiempo de la consulta: 0.00060296058654785

Tiempo acumulado:0.074226140975952

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[25]: SELECT P.*, P.URL AS URL_PAIS
            FROM LO_PAIS_I18N P
            WHERE P.ID_PAIS = 29
                AND IDIOMA = 'ch';

Tiempo de la consulta: 0.00086402893066406

Tiempo acumulado:0.075090169906616

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[26]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.`URL` AS URL_REGION, REIA.ID_REGION_ADM1, REIA.DESC_REGION AS DESC_ADM, REIA.`URL` AS URL_ADM, P.ID_PAIS, P.DESC_PAIS, P.`URL` AS URL_PAIS
            FROM LO_EMPRESAS EMP
            INNER JOIN LO_REGION RE ON RE.ID_REGION = EMP.ID_PROVINCIA
            INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = RE.ID_REGION
                AND REI.IDIOMA = 'ch'
            LEFT JOIN LO_REGION_ADM1_I18N REIA ON REIA.ID_REGION_ADM1 = RE.ID_REGION_ADM1
                AND REIA.IDIOMA = 'ch'
                AND (SELECT COUNT(RE2.ID_REGION)
            FROM LO_REGION RE2
            INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = RE2.ID_REGION
                AND REI.IDIOMA = 'ch'
            WHERE RE2.ID_REGION_ADM1 = RE.ID_REGION_ADM1) > 1
            INNER JOIN LO_PAIS_I18N P ON P.ID_PAIS = RE.ID_PAIS
                AND P.IDIOMA = 'ch'
            WHERE EMP.ID_EMPRESA = 19742358;

Tiempo de la consulta: 0.0012588500976562

Tiempo acumulado:0.076349020004272

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[27]: SELECT *
            FROM LO_REGION_ADM1_STATS RS
            WHERE RS.ID_SECTOR = 12
                AND RS.ID_REGION_ADM1 = 14
                AND N_OFERTAS > 0;

Tiempo de la consulta: 0.0011839866638184

Tiempo acumulado:0.077533006668091

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[28]: SELECT *
            FROM LO_REGION_STATS RS
            WHERE RS.ID_SECTOR = 12
                AND RS.ID_REGION = 606
                AND ID_GRUPO = 0
                AND ID_SUBSECTOR = 0
                AND N_OFERTAS > 0;

Tiempo de la consulta: 0.00091195106506348

Tiempo acumulado:0.078444957733154

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[29]: SELECT *
            FROM LO_POBLACION_IT_STATS P
            WHERE P.ID_SECTOR = 12
                AND ID_POBLACION = 48315
                AND N_OFERTAS > 0;

Tiempo de la consulta: 0.0014100074768066

Tiempo acumulado:0.079854965209961

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[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_CH ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
                AND ET.IDIOMA_ET = 'ch'
            WHERE EMP.ID_EMPRESA = 19742358;

Tiempo de la consulta: 0.00048184394836426

Tiempo acumulado:0.080336809158325

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[31]: SELECT OLD_URL, NEW_URL
FROM LO_URL_301 U
WHERE U.OLD_URL = '/zh-hans/feng-zheng-chong-lang/kitesurf-la-caletta--e19742358';

Tiempo de la consulta: 0.0007319450378418

Tiempo acumulado:0.081068754196167

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[32]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_id_tropic_trad'
                AND CFG.AMBITO IN ('it', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00072288513183594

Tiempo acumulado:0.081791639328003

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[33]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_Language'
                AND CFG.AMBITO IN ('it', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00044488906860352

Tiempo acumulado:0.082236528396606

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[34]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_Data_Base'
                AND CFG.AMBITO IN ('it', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00051212310791016

Tiempo acumulado:0.082748651504517

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[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_it_IT.LO_EMPRESAS EMP
            LEFT JOIN Prod_Yumping_it_IT.LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
            LEFT JOIN Prod_Yumping_it_IT.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
                AND (SECI.ID_TROPIC = 3
                AND SECI.FK_ID_IDIOMA_SI18N = 'it')
            WHERE EMP.ID_EMPRESA = 19742358;

Tiempo de la consulta: 0.00058698654174805

Tiempo acumulado:0.083335638046265

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[36]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'RequestUrl_empresa_trad'
                AND CFG.AMBITO IN ('it', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00058794021606445

Tiempo acumulado:0.083923578262329

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[37]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_id_tropic_trad'
                AND CFG.AMBITO IN ('it_en', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0004420280456543

Tiempo acumulado:0.084365606307983

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[38]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_Language'
                AND CFG.AMBITO IN ('it_en', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00042080879211426

Tiempo acumulado:0.084786415100098

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[39]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_Data_Base'
                AND CFG.AMBITO IN ('it_en', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00041508674621582

Tiempo acumulado:0.085201501846313

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[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_it_IT.LO_EMPRESAS EMP
            LEFT JOIN Prod_Yumping_it_IT.LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
            LEFT JOIN Prod_Yumping_it_IT.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
                AND (SECI.ID_TROPIC = 32
                AND SECI.FK_ID_IDIOMA_SI18N = 'en')
            WHERE EMP.ID_EMPRESA = 19742358;

Tiempo de la consulta: 0.00059914588928223

Tiempo acumulado:0.085800647735596

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[41]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'RequestUrl_empresa_trad'
                AND CFG.AMBITO IN ('it_en', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00046515464782715

Tiempo acumulado:0.086265802383423

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[42]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_es', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_id_tropic_trad'
                AND CFG.AMBITO IN ('it_es', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00045895576477051

Tiempo acumulado:0.086724758148193

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[43]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_es', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_Language'
                AND CFG.AMBITO IN ('it_es', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00041294097900391

Tiempo acumulado:0.087137699127197

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[44]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_es', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_Data_Base'
                AND CFG.AMBITO IN ('it_es', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00044798851013184

Tiempo acumulado:0.087585687637329

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[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_it_IT.LO_EMPRESAS EMP
            LEFT JOIN Prod_Yumping_it_IT.LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
            LEFT JOIN Prod_Yumping_it_IT.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
                AND (SECI.ID_TROPIC = 31
                AND SECI.FK_ID_IDIOMA_SI18N = 'es')
            WHERE EMP.ID_EMPRESA = 19742358;

Tiempo de la consulta: 0.00062990188598633

Tiempo acumulado:0.088215589523315

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[46]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_es', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'RequestUrl_empresa_trad'
                AND CFG.AMBITO IN ('it_es', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0029768943786621

Tiempo acumulado:0.091192483901978

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[47]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_fr', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_id_tropic_trad'
                AND CFG.AMBITO IN ('it_fr', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0007178783416748

Tiempo acumulado:0.091910362243652

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[48]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_fr', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_Language'
                AND CFG.AMBITO IN ('it_fr', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00058507919311523

Tiempo acumulado:0.092495441436768

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[49]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_fr', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_Data_Base'
                AND CFG.AMBITO IN ('it_fr', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00048303604125977

Tiempo acumulado:0.092978477478027

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[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_it_IT.LO_EMPRESAS EMP
            LEFT JOIN Prod_Yumping_it_IT.LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
            LEFT JOIN Prod_Yumping_it_IT.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
                AND (SECI.ID_TROPIC = 34
                AND SECI.FK_ID_IDIOMA_SI18N = 'fr')
            WHERE EMP.ID_EMPRESA = 19742358;

Tiempo de la consulta: 0.00064396858215332

Tiempo acumulado:0.093622446060181

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[51]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_fr', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'RequestUrl_empresa_trad'
                AND CFG.AMBITO IN ('it_fr', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00058698654174805

Tiempo acumulado:0.094209432601929

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[52]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_de', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_id_tropic_trad'
                AND CFG.AMBITO IN ('it_de', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00057387351989746

Tiempo acumulado:0.094783306121826

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[53]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_de', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_Language'
                AND CFG.AMBITO IN ('it_de', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00046396255493164

Tiempo acumulado:0.095247268676758

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[54]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_de', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_Data_Base'
                AND CFG.AMBITO IN ('it_de', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00047111511230469

Tiempo acumulado:0.095718383789062

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[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_it_IT.LO_EMPRESAS EMP
            LEFT JOIN Prod_Yumping_it_IT.LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
            LEFT JOIN Prod_Yumping_it_IT.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
                AND (SECI.ID_TROPIC = 37
                AND SECI.FK_ID_IDIOMA_SI18N = 'de')
            WHERE EMP.ID_EMPRESA = 19742358;

Tiempo de la consulta: 0.00061607360839844

Tiempo acumulado:0.096334457397461

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[56]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_de', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'RequestUrl_empresa_trad'
                AND CFG.AMBITO IN ('it_de', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00045490264892578

Tiempo acumulado:0.096789360046387

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[57]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_pt', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_id_tropic_trad'
                AND CFG.AMBITO IN ('it_pt', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00048518180847168

Tiempo acumulado:0.097274541854858

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[58]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_pt', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_Language'
                AND CFG.AMBITO IN ('it_pt', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00047707557678223

Tiempo acumulado:0.097751617431641

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[59]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_pt', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_Data_Base'
                AND CFG.AMBITO IN ('it_pt', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00048708915710449

Tiempo acumulado:0.098238706588745

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[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_it_IT.LO_EMPRESAS EMP
            LEFT JOIN Prod_Yumping_it_IT.LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
            LEFT JOIN Prod_Yumping_it_IT.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
                AND (SECI.ID_TROPIC = 38
                AND SECI.FK_ID_IDIOMA_SI18N = 'pt')
            WHERE EMP.ID_EMPRESA = 19742358;

Tiempo de la consulta: 0.00063800811767578

Tiempo acumulado:0.098876714706421

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[61]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_pt', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'RequestUrl_empresa_trad'
                AND CFG.AMBITO IN ('it_pt', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00050592422485352

Tiempo acumulado:0.099382638931274

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[62]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_mx', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_id_tropic_trad'
                AND CFG.AMBITO IN ('it_mx', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00054097175598145

Tiempo acumulado:0.099923610687256

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[63]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_mx', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_Language'
                AND CFG.AMBITO IN ('it_mx', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00047016143798828

Tiempo acumulado:0.10039377212524

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[64]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_mx', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_Data_Base'
                AND CFG.AMBITO IN ('it_mx', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00042510032653809

Tiempo acumulado:0.10081887245178

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[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_it_IT.LO_EMPRESAS EMP
            LEFT JOIN Prod_Yumping_it_IT.LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
            LEFT JOIN Prod_Yumping_it_IT.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
                AND (SECI.ID_TROPIC = 35
                AND SECI.FK_ID_IDIOMA_SI18N = 'es')
            WHERE EMP.ID_EMPRESA = 19742358;

Tiempo de la consulta: 0.00071096420288086

Tiempo acumulado:0.10152983665466

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[66]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_mx', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'RequestUrl_empresa_trad'
                AND CFG.AMBITO IN ('it_mx', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00045418739318848

Tiempo acumulado:0.10198402404785

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[67]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('it', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0004270076751709

Tiempo acumulado:0.10241103172302

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[68]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('it', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00043320655822754

Tiempo acumulado:0.10284423828125

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[69]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('it', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00043511390686035

Tiempo acumulado:0.10327935218811

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[70]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('it', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00043702125549316

Tiempo acumulado:0.1037163734436

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[71]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'subdomain_lang'
                AND CFG.AMBITO IN ('it', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00045323371887207

Tiempo acumulado:0.10416960716248

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[72]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('it_en', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00043201446533203

Tiempo acumulado:0.10460162162781

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[73]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('it_en', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00050187110900879

Tiempo acumulado:0.10510349273682

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[74]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('it_en', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00045418739318848

Tiempo acumulado:0.10555768013

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[75]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('it_en', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00045514106750488

Tiempo acumulado:0.10601282119751

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[76]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'subdomain_lang'
                AND CFG.AMBITO IN ('it_en', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00046992301940918

Tiempo acumulado:0.10648274421692

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[77]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_es', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('it_es', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00048398971557617

Tiempo acumulado:0.1069667339325

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[78]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_es', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('it_es', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00044107437133789

Tiempo acumulado:0.10740780830383

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[79]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_es', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'subdomain'
                AND CFG.AMBITO IN ('it_es', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00047779083251953

Tiempo acumulado:0.10788559913635

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[80]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_es', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('it_es', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00043988227844238

Tiempo acumulado:0.10832548141479

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[81]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_es', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('it_es', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00045084953308105

Tiempo acumulado:0.10877633094788

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[82]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_es', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'subdomain_lang'
                AND CFG.AMBITO IN ('it_es', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00045084953308105

Tiempo acumulado:0.10922718048096

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[83]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_fr', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('it_fr', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00041604042053223

Tiempo acumulado:0.10964322090149

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[84]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_fr', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('it_fr', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00046586990356445

Tiempo acumulado:0.11010909080505

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[85]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_fr', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('it_fr', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00042986869812012

Tiempo acumulado:0.11053895950317

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[86]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_fr', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('it_fr', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00043487548828125

Tiempo acumulado:0.11097383499146

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[87]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_fr', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'subdomain_lang'
                AND CFG.AMBITO IN ('it_fr', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00046300888061523

Tiempo acumulado:0.11143684387207

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[88]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_de', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('it_de', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00046706199645996

Tiempo acumulado:0.11190390586853

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[89]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_de', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('it_de', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00042390823364258

Tiempo acumulado:0.11232781410217

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[90]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_de', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('it_de', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00041413307189941

Tiempo acumulado:0.11274194717407

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[91]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_de', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('it_de', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00041413307189941

Tiempo acumulado:0.11315608024597

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[92]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_de', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'subdomain_lang'
                AND CFG.AMBITO IN ('it_de', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00042295455932617

Tiempo acumulado:0.1135790348053

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[93]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_pt', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('it_pt', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00045609474182129

Tiempo acumulado:0.11403512954712

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[94]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_pt', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('it_pt', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00045180320739746

Tiempo acumulado:0.11448693275452

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[95]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_pt', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('it_pt', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00049209594726562

Tiempo acumulado:0.11497902870178

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[96]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_pt', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('it_pt', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00040602684020996

Tiempo acumulado:0.11538505554199

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[97]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_pt', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'subdomain_lang'
                AND CFG.AMBITO IN ('it_pt', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00041794776916504

Tiempo acumulado:0.11580300331116

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[98]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_mx', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('it_mx', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00040912628173828

Tiempo acumulado:0.1162121295929

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[99]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_mx', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('it_mx', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00041294097900391

Tiempo acumulado:0.1166250705719

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[100]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_mx', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('it_mx', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00040292739868164

Tiempo acumulado:0.11702799797058

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[101]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_mx', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('it_mx', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00039505958557129

Tiempo acumulado:0.11742305755615

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[102]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_mx', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'subdomain_lang'
                AND CFG.AMBITO IN ('it_mx', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00044894218444824

Tiempo acumulado:0.1178719997406

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[103]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
                AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_ch', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('it_ch', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00043106079101562

Tiempo acumulado:0.11830306053162

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[104]: SELECT URL, ET.DESCRIPCION_ET DESCRIPCION,GALERIA_DESC_ET GALERIA_DESC,VIDEOS_TEXT_ET VIDEOS_TEXT,VIDEOS_DESC_ET VIDEOS_DESC,COMO_LLEGAR_ET COMO_LLEGAR,URL_ET URL, EMP.NOMBRE NOMBRE, ET.EVENT_PLANNING EVENT_PLANNING, ID_EMPRESA
            FROM LO_EMPRESAS EMP
            INNER JOIN LO_EMPRESAS_TRADUCCION_CH ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
                AND ET.IDIOMA_ET = 'ch'
            WHERE EMP.ID_EMPRESA = 19742358;

Tiempo de la consulta: 0.00052094459533691

Tiempo acumulado:0.11882400512695

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[105]: SELECT ID_EMPRESA, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_EMPRESA = 19742358;

Tiempo de la consulta: 0.00040602684020996

Tiempo acumulado:0.11923003196716

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[106]: SELECT ID_EMPRESA, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_EMPRESA = 19742358;

Tiempo de la consulta: 0.00048208236694336

Tiempo acumulado:0.11971211433411

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[107]: SELECT ID_EMPRESA, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_EMPRESA = 19742358;

Tiempo de la consulta: 0.00029301643371582

Tiempo acumulado:0.12000513076782

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[108]: SELECT ID_EMPRESA, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_EMPRESA = 19742358;

Tiempo de la consulta: 0.00032806396484375

Tiempo acumulado:0.12033319473267

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[109]: SELECT ID_EMPRESA, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_EMPRESA = 19742358;

Tiempo de la consulta: 0.00053000450134277

Tiempo acumulado:0.12086319923401

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[110]: 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 = 19742358
                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 = 19742358
                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 = 19742358 OR EMP.ID_MADRE = 19742358
                AND EMP.VALID IN (1 ,- 3)
                AND EMP.PRECIO_ACTIVIDAD !=0 ) AS PRECIO_MIN_MAX;

Tiempo de la consulta: 0.0041499137878418

Tiempo acumulado:0.12501311302185

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[111]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;

Tiempo de la consulta: 0.0011310577392578

Tiempo acumulado:0.12614417076111

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[112]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;

Tiempo de la consulta: 0.00036501884460449

Tiempo acumulado:0.12650918960571

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[113]: SELECT *
            FROM LO_CASAS
            WHERE ID_EMPRESA_CA='19742358'
                AND VALID_CA=1
                AND CLIENTE_CA=1
            ORDER BY RAND()
            LIMIT 1;

Tiempo de la consulta: 0.002446174621582

Tiempo acumulado:0.12895536422729

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[114]: SELECT *,(6378*acos(cos(radians('40.608'))*cos(radians(LATITUD_CA))*cos(radians(LONGITUD_CA)-radians('9.7467')) +sin(radians('40.608'))*sin(radians(LATITUD_CA)))) AS DISTANCIA
            FROM LO_CASAS WHERE VALID_CA=1
                AND CLIENTE_CA=1 HAVING DISTANCIA < 30
            LIMIT 10;

Tiempo de la consulta: 0.00092482566833496

Tiempo acumulado:0.12988018989563

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[115]: SELECT *
            FROM LO_TOPRURAL_IT
            WHERE FK_ID_EMPRESA_TR='19742358'
            LIMIT 10;

Tiempo de la consulta: 0.001643180847168

Tiempo acumulado:0.1315233707428

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[116]: SELECT *,(6378*acos(cos(radians('40.608'))*cos(radians(LATITUD_TR))*cos(radians(LONGITUD_TR)-radians('9.7467')) +sin(radians('40.608'))*sin(radians(LATITUD_TR)))) AS DISTANCIA
            FROM LO_TOPRURAL_IT
            WHERE ID_PAIS_TR='29'
                AND PRECIO_MEDIO_TR<>0
                AND COMENTARIOS_TR<>''
                AND DIRECCION_TR<>''
                AND FK_ID_EMPRESA_TR<>'19742358' HAVING DISTANCIA < 30
            LIMIT 10;

Tiempo de la consulta: 0.023557186126709

Tiempo acumulado:0.15508055686951

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[117]: 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 = 19742358 OR EMP.ID_MADRE= 19742358
                AND EMP.VALID=1)
                AND STATUS_REGALO='1'
            LIMIT 3;

Tiempo de la consulta: 0.0019991397857666

Tiempo acumulado:0.15707969665527

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[118]: 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 = 36
                AND SECI.FK_ID_IDIOMA_SI18N = 'ch'
            LEFT JOIN LO_GRUPOS GRU ON GRU.ID_SECTOR = EMP.ID_SECTOR
                AND GRU.ID_TROPIC = 36
            WHERE EMP.ID_EMPRESA = 19742358 OR EMP.ID_MADRE = 19742358
                AND EMP.VALID = 1
                AND EMP.EMP_MADRE NOT IN(1,3)
            ORDER BY EMP_MADRE,DESC_SECTOR;

Tiempo de la consulta: 0.00091195106506348

Tiempo acumulado:0.15799164772034

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[119]: SELECT URL, ET.DESCRIPCION_ET DESCRIPCION,GALERIA_DESC_ET GALERIA_DESC,VIDEOS_TEXT_ET VIDEOS_TEXT,VIDEOS_DESC_ET VIDEOS_DESC,COMO_LLEGAR_ET COMO_LLEGAR,URL_ET URL, EMP.NOMBRE NOMBRE, ET.EVENT_PLANNING EVENT_PLANNING, ID_EMPRESA
            FROM LO_EMPRESAS EMP
            INNER JOIN LO_EMPRESAS_TRADUCCION_CH ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
                AND ET.IDIOMA_ET = 'ch'
            WHERE EMP.ID_EMPRESA = 19742358;

Tiempo de la consulta: 0.00050902366638184

Tiempo acumulado:0.15850067138672

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[120]: SELECT *
            FROM LO_FOTOS
            WHERE ID_EMPRESA = 19742358
                AND VALID = 1;

Tiempo de la consulta: 0.0040221214294434

Tiempo acumulado:0.16252279281616

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[121]: SELECT *
            FROM LO_FOTOS
            WHERE ID_EMPRESA = 19742358
                AND FOTO = 'e-19742358-logo-caletta15010082831169.jpg'
                AND VALID=1;

Tiempo de la consulta: 0.00058102607727051

Tiempo acumulado:0.16310381889343

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[122]: SELECT EMP_MADRE, ID_MADRE, ID_SECTOR
            FROM LO_EMPRESAS EMP
            INNER JOIN LO_EMPRESAS_TRADUCCION_CH ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
                AND ET.IDIOMA_ET = 'ch'
            WHERE EMP.ID_EMPRESA = 19742358;

Tiempo de la consulta: 0.00041604042053223

Tiempo acumulado:0.16351985931396

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[123]: SELECT PRECIO_PRE, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, PRECIO_PD, ID_DESCUENTO_PD,ID_PRECIO,DATE_FORMAT(FECHA_CADUCIDAD_PD,'%d/%m/%Y') FEC_CAD, INCLUYE_PRE,GALERIA_PRE,FOTOPRINCIPAL_PRE,PRECIO_PRE, EMP.URL URL,SECI.URL URL_SECTOR,REI.URL URL_REGION, if(PRECIO_PD>0,LEAST(MIN(PRECIO_PD),PRECIO_PRE),LEAST(999999999,PRECIO_PRE) ) PRECIO, if(PRECIO_PD>0, (1-(MIN(PRECIO_PD)/PRECIO_PRE))*100 ,0) DESCUENTO
            FROM LO_PRECIOS PRE
            INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'ch'
            INNER JOIN LO_PRECIOS_SECTORES SECP ON PRE.ID_PRECIO=SECP.ID_PRECIO_PS
            INNER JOIN LO_PRECIOS_DESCUENTOS PD ON PRE.ID_PRECIO=PD.ID_PRECIO_PD
            INNER JOIN LO_EMPRESAS EMP ON PRE.ID_EMPRESA_PRE=EMP.ID_EMPRESA
            INNER JOIN LO_SECTORES SEC ON SECP.ID_ACTIVIDAD_PS=SEC.ID_SECTOR
            INNER JOIN LO_SECTORES_I18N SECI ON SEC.ID_SECTOR=SECI.ID_SECTOR
            INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PRE.ID_REGION_PRE
            INNER JOIN LO_POBLACION_I18N POI ON POI.ID_POBLACION=PRE.ID_POBLACION_PRE
            WHERE SECI.ID_TROPIC='36'
                AND SECI.FK_ID_IDIOMA_SI18N='ch'
                AND REI.IDIOMA='ch'
                AND ID_EMPRESA='19742358'
                AND VALID_PD=1
                AND OFERTA_PD=1
                AND SECP.ID_ACTIVIDAD_PS = 12
                AND PRE.VALID_PRE = 4
            ORDER BY FECHA_CADUCIDAD_PD DESC
            LIMIT 1;

Tiempo de la consulta: 0.0014050006866455

Tiempo acumulado:0.16492486000061

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[124]: SELECT N_VENTAS_EST, FEC_ULT_COMPRA
            FROM LO_EMPRESAS_STAT
            WHERE FK_ID_EST = 19742358
                AND N_VENTAS_EST > 0
            LIMIT 1;

Tiempo de la consulta: 0.00039505958557129

Tiempo acumulado:0.16531991958618

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[125]: 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='19742358' OR OP.ID_MADRE='19742358' )
                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.00211501121521

Tiempo acumulado:0.16743493080139

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[126]: SELECT *
            FROM LO_FOTOS
            WHERE ID_EMPRESA = 19742358
                AND VALID = 1;

Tiempo de la consulta: 0.00063300132751465

Tiempo acumulado:0.16806793212891

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[127]: SELECT *
            FROM LO_FOTOS
            WHERE ID_EMPRESA = 19742358
                AND FOTO = 'e-19742358-partenzaa15010082842206.jpg'
                AND VALID = 1;

Tiempo de la consulta: 0.00044989585876465

Tiempo acumulado:0.16851782798767

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[128]: SELECT *
            FROM LO_FOTOS
            WHERE ID_EMPRESA = 19742358
                AND FOTO = 'e-19742358-partenzaa15010082842206.jpg'
                AND VALID=1;

Tiempo de la consulta: 0.0004270076751709

Tiempo acumulado:0.16894483566284

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[129]: SELECT *
            FROM LO_FOTOS
            WHERE ID_EMPRESA = 19742358
                AND FOTO = 'e-19742358-partenzaa15010082842206.jpg'
                AND VALID=1;

Tiempo de la consulta: 0.0004270076751709

Tiempo acumulado:0.16937184333801

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[130]: SELECT *
            FROM LO_FOTOS
            WHERE ID_EMPRESA = 19742358
                AND VALID = 1;

Tiempo de la consulta: 0.00061202049255371

Tiempo acumulado:0.16998386383057

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[131]: SELECT *
            FROM LO_FOTOS
            WHERE ID_EMPRESA = 19742358
                AND FOTO = 'e-19742358-abbiamo-tutto-il-necessario15010082821363.jpg'
                AND VALID = 1;

Tiempo de la consulta: 0.0004417896270752

Tiempo acumulado:0.17042565345764

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[132]: SELECT *
            FROM LO_FOTOS
            WHERE ID_EMPRESA = 19742358
                AND FOTO = 'e-19742358-abbiamo-tutto-il-necessario15010082821363.jpg'
                AND VALID=1;

Tiempo de la consulta: 0.00040912628173828

Tiempo acumulado:0.17083477973938

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[133]: SELECT *
            FROM LO_FOTOS
            WHERE ID_EMPRESA = 19742358
                AND FOTO = 'e-19742358-abbiamo-tutto-il-necessario15010082821363.jpg'
                AND VALID=1;

Tiempo de la consulta: 0.00039505958557129

Tiempo acumulado:0.17122983932495

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[134]: SELECT *
            FROM LO_FOTOS
            WHERE ID_EMPRESA = 19742358
                AND VALID = 1;

Tiempo de la consulta: 0.00062799453735352

Tiempo acumulado:0.1718578338623

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[135]: SELECT *
            FROM LO_FOTOS
            WHERE ID_EMPRESA = 19742358
                AND FOTO = 'e-19742358-governando-la-vela15010082825360.jpg'
                AND VALID = 1;

Tiempo de la consulta: 0.00049495697021484

Tiempo acumulado:0.17235279083252

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[136]: SELECT *
            FROM LO_FOTOS
            WHERE ID_EMPRESA = 19742358
                AND FOTO = 'e-19742358-governando-la-vela15010082825360.jpg'
                AND VALID=1;

Tiempo de la consulta: 0.00050497055053711

Tiempo acumulado:0.17285776138306

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[137]: SELECT *
            FROM LO_FOTOS
            WHERE ID_EMPRESA = 19742358
                AND FOTO = 'e-19742358-governando-la-vela15010082825360.jpg'
                AND VALID=1;

Tiempo de la consulta: 0.00041913986206055

Tiempo acumulado:0.17327690124512

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[138]: SELECT *
            FROM LO_FOTOS
            WHERE ID_EMPRESA = 19742358
                AND VALID = 1;

Tiempo de la consulta: 0.00057291984558105

Tiempo acumulado:0.1738498210907

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[139]: SELECT *
            FROM LO_FOTOS
            WHERE ID_EMPRESA = 19742358
                AND FOTO = 'e-19742358-la-nostra-base15010082838314.jpg'
                AND VALID = 1;

Tiempo de la consulta: 0.00046181678771973

Tiempo acumulado:0.17431163787842

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[140]: SELECT *
            FROM LO_FOTOS
            WHERE ID_EMPRESA = 19742358
                AND FOTO = 'e-19742358-la-nostra-base15010082838314.jpg'
                AND VALID=1;

Tiempo de la consulta: 0.00054001808166504

Tiempo acumulado:0.17485165596008

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[141]: SELECT *
            FROM LO_FOTOS
            WHERE ID_EMPRESA = 19742358
                AND FOTO = 'e-19742358-la-nostra-base15010082838314.jpg'
                AND VALID=1;

Tiempo de la consulta: 0.00041389465332031

Tiempo acumulado:0.1752655506134

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[142]: SELECT *
            FROM LO_FOTOS
            WHERE ID_EMPRESA = 19742358
                AND VALID = 1;

Tiempo de la consulta: 0.00057411193847656

Tiempo acumulado:0.17583966255188

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[143]: SELECT *
            FROM LO_FOTOS
            WHERE ID_EMPRESA = 19742358
                AND FOTO = 'e-19742358-preparandoci-a-scendere-in-acqua15010082849499.jpg'
                AND VALID = 1;

Tiempo de la consulta: 0.0004429817199707

Tiempo acumulado:0.17628264427185

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[144]: SELECT *
            FROM LO_FOTOS
            WHERE ID_EMPRESA = 19742358
                AND FOTO = 'e-19742358-preparandoci-a-scendere-in-acqua15010082849499.jpg'
                AND VALID=1;

Tiempo de la consulta: 0.00052499771118164

Tiempo acumulado:0.17680764198303

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[145]: SELECT *
            FROM LO_FOTOS
            WHERE ID_EMPRESA = 19742358
                AND FOTO = 'e-19742358-preparandoci-a-scendere-in-acqua15010082849499.jpg'
                AND VALID=1;

Tiempo de la consulta: 0.00045084953308105

Tiempo acumulado:0.17725849151611

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[146]: SELECT *
            FROM LO_FOTOS
            WHERE ID_EMPRESA = 19742358
                AND VALID = 1;

Tiempo de la consulta: 0.00059819221496582

Tiempo acumulado:0.17785668373108

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[147]: SELECT *
            FROM LO_FOTOS
            WHERE ID_EMPRESA = 19742358
                AND FOTO = 'e-19742358-pronti-ad-entrare-in-acqua15010082845991.jpg'
                AND VALID = 1;

Tiempo de la consulta: 0.00045084953308105

Tiempo acumulado:0.17830753326416

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[148]: SELECT *
            FROM LO_FOTOS
            WHERE ID_EMPRESA = 19742358
                AND FOTO = 'e-19742358-pronti-ad-entrare-in-acqua15010082845991.jpg'
                AND VALID=1;

Tiempo de la consulta: 0.00043797492980957

Tiempo acumulado:0.17874550819397

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[149]: SELECT *
            FROM LO_FOTOS
            WHERE ID_EMPRESA = 19742358
                AND FOTO = 'e-19742358-pronti-ad-entrare-in-acqua15010082845991.jpg'
                AND VALID=1;

Tiempo de la consulta: 0.00048112869262695

Tiempo acumulado:0.1792266368866

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[150]: SELECT EMP_MADRE, ID_MADRE, ID_SECTOR
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19742358;

Tiempo de la consulta: 0.00036096572875977

Tiempo acumulado:0.17958760261536

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[151]: SELECT PRE.ID_PRECIO,PRE.TITULO_PRE, if(PRECIO_PD>0,LEAST(MIN(PRECIO_PD),PRECIO_PRE),LEAST(999999999,PRECIO_PRE) ) PRECIO, PRE.FOTOPRINCIPAL_PRE, PRE.FK_ID_PAIS_PRE AS ID_PAIS, POI.URL_POBLACION, POI.DESC_POBLACION, POI.ID_POBLACION, REI.URL URL_REGION, REI.DESC_REGION,REI.ID_REGION, SECI.ID_SECTOR, SECI.URL URL_SECTOR, SECI.DESC_SECTOR,PRE.PRECIO_PRE, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, MULTIACTIVIDAD_PRE
            FROM LO_PRECIOS PRE
            INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'ch'
            LEFT JOIN LO_PRECIOS_DESCUENTOS PD ON PD.ID_PRECIO_PD = PRE.ID_PRECIO
                AND PD.VALID_PD=1
            INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PRE.ID_REGION_PRE
                AND REI.IDIOMA = 'ch'
            INNER JOIN LO_POBLACION_IT POI ON POI.ID_POBLACION = PRE.ID_POBLACION_PRE
                AND POI.IDIOMA = 'ch'
            INNER JOIN LO_PRECIOS_SECTORES PS ON PS.ID_PRECIO_PS = PRE.ID_PRECIO
            INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = PS.ID_ACTIVIDAD_PS
                AND SECI.FK_ID_IDIOMA_SI18N='ch'
                AND SECI.ID_TROPIC = 36
            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 = 19742358
                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.002079963684082

Tiempo acumulado:0.18166756629944

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[152]: SELECT URL, ET.DESCRIPCION_ET DESCRIPCION,GALERIA_DESC_ET GALERIA_DESC,VIDEOS_TEXT_ET VIDEOS_TEXT,VIDEOS_DESC_ET VIDEOS_DESC,COMO_LLEGAR_ET COMO_LLEGAR,URL_ET URL, EMP.NOMBRE NOMBRE, ET.EVENT_PLANNING EVENT_PLANNING, ID_EMPRESA
            FROM LO_EMPRESAS EMP
            INNER JOIN LO_EMPRESAS_TRADUCCION_CH ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
                AND ET.IDIOMA_ET = 'ch'
            WHERE EMP.ID_EMPRESA = 19742358;

Tiempo de la consulta: 0.00050783157348633

Tiempo acumulado:0.18217539787292

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[153]: 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_IT PO ON PO.ID_POBLACION = PED.ID_POBLACION
                AND PO.IDIOMA = 'ch'
            INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PO.ID_REGION
                AND REI.IDIOMA = 'ch'
            INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = 12
                AND SECI.FK_ID_IDIOMA_SI18N = 'ch';

Tiempo de la consulta: 0.0012068748474121

Tiempo acumulado:0.18338227272034

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[154]: SELECT *
            FROM LO_POBLACION_IT_STATS RS
            WHERE RS.ID_POBLACION = 2000077
                AND RS.ID_SECTOR = 12;

Tiempo de la consulta: 0.00043082237243652

Tiempo acumulado:0.18381309509277

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[155]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.`URL` AS URL_REGION, REIA.ID_REGION_ADM1, REIA.DESC_REGION AS DESC_ADM, REIA.`URL` AS URL_ADM, P.ID_PAIS, P.DESC_PAIS, P.`URL` AS URL_PAIS
            FROM LO_EMPRESAS EMP
            INNER JOIN LO_REGION RE ON RE.ID_REGION = EMP.ID_PROVINCIA
            INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = RE.ID_REGION
                AND REI.IDIOMA = 'ch'
            LEFT JOIN LO_REGION_ADM1_I18N REIA ON REIA.ID_REGION_ADM1 = RE.ID_REGION_ADM1
                AND REIA.IDIOMA = 'ch'
                AND (SELECT COUNT(RE2.ID_REGION)
            FROM LO_REGION RE2
            INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = RE2.ID_REGION
                AND REI.IDIOMA = 'ch'
            WHERE RE2.ID_REGION_ADM1 = RE.ID_REGION_ADM1) > 1
            INNER JOIN LO_PAIS_I18N P ON P.ID_PAIS = RE.ID_PAIS
                AND P.IDIOMA = 'ch'
            WHERE EMP.ID_EMPRESA = 19742358;

Tiempo de la consulta: 0.00072312355041504

Tiempo acumulado:0.18453621864319

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[156]: SELECT (N_OFERTAS) + (N_EMPRESAS) AS NEMPRESAS, N_OFERTAS AS NumOfertas, N_EMPRESAS as NumEmpresas, PS.ID_REGION_ADM1, IF ( MEDIA_AJUSTADA IS NOT NULL
                AND MEDIA_AJUSTADA != 0
                AND MEDIA_AJUSTADA < MEDIA_PRECIO, MEDIA_AJUSTADA, MEDIA_PRECIO ) AS MEDIA, N_OPIS FROM LO_REGION_ADM1_STATS PS
            WHERE (IF(ISNULL(PS.N_OFERTAS),0,PS.N_OFERTAS) > 0 OR IF(ISNULL(PS.N_EMPRESAS),0,PS.N_EMPRESAS) > 0 )
                AND PS.ID_REGION_ADM1 = 14
                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.00075793266296387

Tiempo acumulado:0.18529415130615

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[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 = 606
                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.00061416625976562

Tiempo acumulado:0.18590831756592

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[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 = 'ch'
            WHERE (PS.N_OFERTAS > 0 )
                AND PS.ID_REGION = 606
                AND PS.ID_SECTOR = 12
            GROUP BY PS.ID_REGION;

Tiempo de la consulta: 0.00044608116149902

Tiempo acumulado:0.18635439872742

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[159]: SELECT N_OFERTAS FROM LO_POBLACION_IT_STATS PS
            INNER JOIN LO_POBLACION_IT PO ON PS.ID_POBLACION = PO.ID_POBLACION
                AND PO.ID_REGION = 606
                AND PO.IDIOMA = 'ch'
            INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PO.ID_REGION
                AND REI.IDIOMA = 'ch'
            WHERE (PS.N_OFERTAS > 0 )
                AND PO.ID_REGION = 606
                AND PS.ID_POBLACION = 48315
                AND PS.ID_SECTOR = 12
            GROUP BY PS.ID_POBLACION;

Tiempo de la consulta: 0.00042104721069336

Tiempo acumulado:0.18677544593811

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[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 = 'ch'
            INNER JOIN LO_PRECIOS_SECTORES PS ON PS.ID_PRECIO_PS = PRE.ID_PRECIO
                AND PS.ID_ACTIVIDAD_PS = RSS.ID_SECTOR
            INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = PS.ID_ACTIVIDAD_PS
                AND SECI.ID_TROPIC = 36
                AND SECI.ID_SECTOR = 12
            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.0027971267700195

Tiempo acumulado:0.18957257270813

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[161]: SELECT EE.*, EET.DESCRIPCION, EET.CARGO, EE.IDIOMA AS IDIOMA_EE
            FROM LO_EMPRESAS_EQUIPO EE
            INNER JOIN LO_EMPRESAS_EQUIPO_TRADUCCION EET ON EET.ID_EQUIPO = EE.ID
                AND EET.IDIOMA = 'ch'
            WHERE EE.ID_EMPRESA = 19742358
                AND EE.VALID = 1;

Tiempo de la consulta: 0.0015950202941895

Tiempo acumulado:0.19116759300232

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[162]: SELECT MIN(DATE_FORMAT(EMP.FEC_INSERT,'%Y/%m/%d') ) AS FECHA
            FROM LO_EMPRESAS EMP
            WHERE EMP.ID_EMPRESA = 19742358 OR ID_MADRE = 19742358
                AND EMP.VALID = 1;

Tiempo de la consulta: 0.00057315826416016

Tiempo acumulado:0.19174075126648

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[163]: 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 = 19742358 OR ID_MADRE = 19742358
                AND EMP.VALID = 1;

Tiempo de la consulta: 0.00065207481384277

Tiempo acumulado:0.19239282608032

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[164]: SELECT *
FROM LO_RESERVAS_FISCAL
WHERE ID_EMPRESA_RF='19742358';

Tiempo de la consulta: 0.0025629997253418

Tiempo acumulado:0.19495582580566

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[165]: 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 = 19742358;

Tiempo de la consulta: 0.021577835083008

Tiempo acumulado:0.21653366088867

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[166]: SELECT *
FROM LO_EMPRESAS_IDIOMAS EI
WHERE EI.ID_EMPRESA = 19742358;

Tiempo de la consulta: 0.00092792510986328

Tiempo acumulado:0.21746158599854

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[167]: SELECT EMP.COMO_LLEGAR COMO_LLEGAR_ORI, EMP.GALERIA_DESC GALERIA_DESC_ORI, EMP.VIDEOS_TEXT VIDEOS_TEXT_ORI,EMP.VIDEOS_DESC VIDEOS_DESC_ORI, EMP.EMP_MADRE,EMP.LOGOTIPO,EMP.ID_EMPRESA,EMP.DIRECCION, PO.DESC_POBLACION, PO.URL_POBLACION, REI.DESC_REGION,EMP.DS_ACTIVO,EMP.ID_PAIS, EMP.TELEFONO,EMP.NOPINIONES,EMP.VIDEOS_CODE,SEC.ID_GRUPO,SECI.DESC_SECTOR,EMP.FOTOPRINCIPAL, EMP.GALERIA,EMP.MADRE_NAME,EMP.PRECIO_ACTIVIDAD,EMP.TIPOCUENTA,SECI.URL URL_SECTOR, EMP.LICENCIA_EMPRESA,EMP.ID_POBLACION,EMP.VALID,EMP.ID_PROVINCIA,EMP.ID_SECTOR, EMP.VIDEOS_CODE,EMP.VIDEOS_DESC,EMP.CLIENTE,RE.ID_REGION,N_VENTAS_EST, EMP.COLAB_EMPRESAS, EMP.ID_MADRE ID_MADRE,REI.URL URL_REGION, EMP.LATITUDE LATITUDE,EMP.COD_POSTAL, EMP.LONGITUDE LONGITUDE,PO.URL_POBLACION, ES.NOPINIONES_EST,ES.N_PRECIOS_EST,ES.VISITAS,PUNTOS_EST,EMP.LOGIN,EMP.PASSWORD,EMP.PERS_CTCTO, EMP.TELEFONOMOVIL, EMP.FAX,EMP.WEB,EMP.MAIL,EMP.ACCOUNT_MANAGER,RESPUESTARAPIDA,CENTRAL_ACTIVA, NOPINIONES_EST,EMP.MAIL_CC, EMP.ACEPTAR_CR,EMP.VIDEOS_TEXT,ES.PRECIO_EST, ES.PUNTOS_EST, ES.RIESGO_EST, ES.ATENCION_EST, EMP.URL, ET.DESCRIPCION_ET DESCRIPCION,GALERIA_DESC_ET GALERIA_DESC,VIDEOS_TEXT_ET VIDEOS_TEXT,VIDEOS_DESC_ET VIDEOS_DESC,COMO_LLEGAR_ET COMO_LLEGAR,URL_ET URL, EMP.NOMBRE NOMBRE, ET.EVENT_PLANNING EVENT_PLANNING, IF (EMP.EMP_MADRE = 0, CASE EMP.ID_SECTOR WHEN 13 THEN GRU.DESC_GRUPO WHEN 16 THEN GRU.DESC_GRUPO WHEN 2 THEN GRU.DESC_GRUPO WHEN 3 THEN GRU.DESC_GRUPO WHEN 56 THEN GRU.DESC_GRUPO WHEN 67 THEN GRU.DESC_GRUPO WHEN 7 THEN GRU.DESC_GRUPO WHEN 93 THEN GRU.DESC_GRUPO ELSE SECI.DESC_SECTOR END, SECI.DESC_SECTOR) AS DESC_SECTOR_BUSCADOR
            FROM LO_EMPRESAS EMP
            INNER JOIN LO_EMPRESAS_TRADUCCION_CH ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
                AND ET.IDIOMA_ET = 'ch'
            LEFT JOIN LO_EMPRESAS_STAT ES ON EMP.ID_EMPRESA = ES.FK_ID_EST
            INNER JOIN LO_REGION RE ON EMP.ID_PROVINCIA = RE.ID_REGION
            INNER JOIN LO_REGION_I18N REI ON RE.ID_REGION = REI.ID_REGION
                AND REI.IDIOMA='ch'
            INNER JOIN LO_REGION_ADM1 REIAD ON RE.ID_REGION_ADM1 = REIAD.ID_REGION_ADM1
            LEFT JOIN LO_POBLACION_IT PO ON EMP.ID_POBLACION = PO.ID_POBLACION
                AND PO.IDIOMA='ch'
            INNER JOIN LO_SECTORES SEC ON EMP.ID_SECTOR = SEC.ID_SECTOR
            INNER JOIN LO_SECTORES_I18N SECI ON SEC.ID_SECTOR = SECI.ID_SECTOR
                AND (SECI.ID_TROPIC = 36
                AND SECI.FK_ID_IDIOMA_SI18N = 'ch')
            INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
                AND (GRU.ID_TROPIC = 36)
            WHERE EMP.ID_EMPRESA = 19742358
                AND EMP.VALID IN ('1', '-3')
            LIMIT 1;

Tiempo de la consulta: 0.00136399269104

Tiempo acumulado:0.21882557868958

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[168]: SELECT *
            FROM LO_FOTOS
            WHERE ID_EMPRESA = 19742358
                AND VALID = 1;

Tiempo de la consulta: 0.0007328987121582

Tiempo acumulado:0.21955847740173

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[169]: SELECT *
            FROM LO_FOTOS
            WHERE ID_EMPRESA = 19742358
                AND FOTO = 'e-19742358-partenzaa15010082842206.jpg'
                AND VALID=1;

Tiempo de la consulta: 0.0004727840423584

Tiempo acumulado:0.22003126144409

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[170]: 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 = '606'
                AND REI.IDIOMA = 'ch';

Tiempo de la consulta: 0.00042510032653809

Tiempo acumulado:0.22045636177063

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingwrite_desk
SQL[171]: INSERT INTO LO_EMPRESAS_VISITAS_DIARIO (ID_EMPRESA,FECHA, VISITAS) VALUES (19742358, SYSDATE(), 1) ON DUPLICATE KEY UPDATE VISITAS = VISITAS + 1;

Tiempo de la consulta: 0.0063369274139404

Tiempo acumulado:0.22679328918457

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[172]: SELECT SECI.ID_SECTOR, N_OFERTAS AS NEMPRESAS, N_OFERTAS AS NumOfertas, N_EMPRESAS as NumEmpresas, REI.ID_REGION, REI.DESC_REGION, REI.URL URL_REGION, SECI.DESC_SECTOR, SECI.URL as URL_SECTOR, RE.ID_REGION_ADM1, SEC.ID_GRUPO, RE.ID_PAIS FROM LO_REGION_STATS PS
            INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PS.ID_REGION
                AND REI.IDIOMA = 'ch'
            INNER JOIN LO_REGION RE ON RE.ID_REGION = REI.ID_REGION
            INNER JOIN LO_SECTORES SEC ON SEC.ID_SECTOR = PS.ID_SECTOR
                AND SEC.ID_GRUPO = 1
            INNER JOIN LO_SECTORES_I18N SECI ON PS.ID_SECTOR = SECI.ID_SECTOR
                AND SECI.ID_TROPIC='36'
                AND SECI.FK_ID_IDIOMA_SI18N = 'ch'
            WHERE REI.ID_REGION = 606
                AND (PS.N_OFERTAS > 0
                AND PS.N_OFERTAS IS NOT NULL)
            ORDER BY NEMPRESAS DESC;

Tiempo de la consulta: 0.0015158653259277

Tiempo acumulado:0.2283091545105

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[173]: SELECT COUNT(*) AS NEMPRESAS
            FROM LO_REGION_STATS
            WHERE ID_REGION = 606
                AND ID_GRUPO = 1;

Tiempo de la consulta: 0.00047087669372559

Tiempo acumulado:0.22878003120422

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[174]: 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 = '606'
                AND REI.IDIOMA = 'ch';

Tiempo de la consulta: 0.00040602684020996

Tiempo acumulado:0.22918605804443

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[175]: SELECT SEO.KEYWORD
            FROM LO_SEO_KEYWORDS SEO
            WHERE SEO.ID_KEY = 'S23'
                AND (SEO.ID_TROPIC = 36 );

Tiempo de la consulta: 0.0009458065032959

Tiempo acumulado:0.23013186454773

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[176]: SELECT SEO.KEYWORD
            FROM LO_SEO_KEYWORDS SEO
            WHERE SEO.ID_KEY = 'S84'
                AND (SEO.ID_TROPIC = 36 );

Tiempo de la consulta: 0.00040316581726074

Tiempo acumulado:0.23053503036499

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[177]: SELECT SEO.KEYWORD
            FROM LO_SEO_KEYWORDS SEO
            WHERE SEO.ID_KEY = 'S51'
                AND (SEO.ID_TROPIC = 36 );

Tiempo de la consulta: 0.00037503242492676

Tiempo acumulado:0.23091006278992

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[178]: SELECT SEO.KEYWORD
            FROM LO_SEO_KEYWORDS SEO
            WHERE SEO.ID_KEY = 'S36'
                AND (SEO.ID_TROPIC = 36 );

Tiempo de la consulta: 0.00040602684020996

Tiempo acumulado:0.23131608963013

(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[179]: SELECT *
FROM LO_EQUIPO_EDITORIAL EE
WHERE EE.ID_TROPIC = 36;

Tiempo de la consulta: 0.00084400177001953

Kitesurf La Caletta

的描述 Kitesurf La Caletta

有用的信息

地图

相關活動

信息

Yumping信任

下载应用程序

支付方式

1260 条评论