Thames Jet, prices and bookings 2025

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

prod.yumping.com

/empresa.php

BBDD->Prod_Yumping_co_UK
AMBITO->gb
AMBITO_AJAX->gb
AMBITO_AJAX COOKIE->it
locale LO_CONFIG->en_GB
locale php->en_GB
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->en
id_empresa->19743630
tpage->empresa
nomb_emp->thames-jet
rel_alternate->1

Total queries: 262

Tiempo total: 0.59258341789246

(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', 'gb')
            ORDER BY CFG.NAME;

Tiempo de la consulta: 0.017889022827148

Tiempo acumulado:0.017889022827148

(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.0036880970001221

Tiempo acumulado:0.021577119827271

(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 = 19743630
                AND fnGoogleUrl(EMP.NOMBRE) = 'thames-jet' UNION ALL SELECT EMP.ID_PAIS
            FROM Prod_Yumping_pt_PT.LO_EMPRESAS EMP
            WHERE EMP.ID_EMPRESA = 19743630
                AND fnGoogleUrl(EMP.NOMBRE) = 'thames-jet' UNION ALL SELECT EMP.ID_PAIS
            FROM Prod_Yumping_it_IT.LO_EMPRESAS EMP
            WHERE EMP.ID_EMPRESA = 19743630
                AND fnGoogleUrl(EMP.NOMBRE) = 'thames-jet' UNION ALL SELECT EMP.ID_PAIS
            FROM Prod_Yumping_fr_FR.LO_EMPRESAS EMP
            WHERE EMP.ID_EMPRESA = 19743630
                AND fnGoogleUrl(EMP.NOMBRE) = 'thames-jet' UNION ALL SELECT EMP.ID_PAIS
            FROM Prod_Yumping_co_UK.LO_EMPRESAS EMP
            WHERE EMP.ID_EMPRESA = 19743630
                AND fnGoogleUrl(EMP.NOMBRE) = 'thames-jet' UNION ALL SELECT EMP.ID_PAIS
            FROM Prod_Yumping_mx_MX.LO_EMPRESAS EMP
            WHERE EMP.ID_EMPRESA = 19743630
                AND fnGoogleUrl(EMP.NOMBRE) = 'thames-jet' ) AS EMPRESA;

Tiempo de la consulta: 0.022044897079468

Tiempo acumulado:0.043622016906738

(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', 'gb')
            ORDER BY CFG.NAME;

Tiempo de la consulta: 0.029169082641602

Tiempo acumulado:0.07279109954834

(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.0013630390167236

Tiempo acumulado:0.074154138565063

(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.00043892860412598

Tiempo acumulado:0.074593067169189

(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[7]: SELECT `TIMESTAMP`, VALUE
            FROM LO_CURRENCIES_CONVERSION
            WHERE `FROM` = 'EUR'
                AND `TO` = 'GBP';

Tiempo de la consulta: 0.0018520355224609

Tiempo acumulado:0.07644510269165

(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 = 'ambito_lang';

Tiempo de la consulta: 0.0020949840545654

Tiempo acumulado:0.078540086746216

(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 = 'id_empresa';

Tiempo de la consulta: 0.003058910369873

Tiempo acumulado:0.081598997116089

(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 = 'tpage';

Tiempo de la consulta: 0.0059449672698975

Tiempo acumulado:0.087543964385986

(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 = 'nomb_emp';

Tiempo de la consulta: 0.0040988922119141

Tiempo acumulado:0.0916428565979

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

Tiempo de la consulta: 0.0066840648651123

Tiempo acumulado:0.098326921463013

(Prod_Yumping_co_UK) (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.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, DESCRIPCION,GALERIA_DESC,VIDEOS_TEXT,VIDEOS_DESC,COMO_LLEGAR, EMP.URL, EMP.NOMBRE, 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
            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='en'
            INNER JOIN LO_REGION_ADM1 REIAD ON RE.ID_REGION_ADM1 = REIAD.ID_REGION_ADM1
            LEFT JOIN LO_POBLACION_GB PO ON EMP.ID_POBLACION = PO.ID_POBLACION
                AND PO.IDIOMA='en'
            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 = 2
                AND SECI.FK_ID_IDIOMA_SI18N = 'en')
            INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
                AND (GRU.ID_TROPIC = 2)
            WHERE EMP.ID_EMPRESA = 19743630
                AND EMP.VALID IN ('1', '-3')
            LIMIT 1;

Tiempo de la consulta: 0.011468887329102

Tiempo acumulado:0.10979580879211

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[14]: SELECT EMP.COMO_LLEGAR COMO_LLEGAR_ORI, EMP.GALERIA_DESC GALERIA_DESC_ORI, EMP.VIDEOS_TEXT VIDEOS_TEXT_ORI, EMP.EMP_MADRE,EMP.LOGOTIPO,EMP.ID_EMPRESA,EMP.DIRECCION, PO.DESC_POBLACION, PO.URL_POBLACION, REI.DESC_REGION,EMP.DS_ACTIVO,EMP.ID_PAIS, EMP.TELEFONO,EMP.NOPINIONES,EMP.VIDEOS_CODE,SEC.ID_GRUPO,SECI.DESC_SECTOR,EMP.FOTOPRINCIPAL, EMP.GALERIA,EMP.MADRE_NAME,EMP.PRECIO_ACTIVIDAD,EMP.TIPOCUENTA,SECI.URL URL_SECTOR, EMP.LICENCIA_EMPRESA,EMP.ID_POBLACION,EMP.VALID,EMP.ID_PROVINCIA,EMP.ID_SECTOR, EMP.VIDEOS_CODE,EMP.VIDEOS_DESC,EMP.CLIENTE,RE.ID_REGION,N_VENTAS_EST, EMP.COLAB_EMPRESAS, EMP.ID_MADRE ID_MADRE,REI.URL URL_REGION, EMP.LATITUDE LATITUDE,EMP.COD_POSTAL, EMP.LONGITUDE LONGITUDE,PO.URL_POBLACION, ES.NOPINIONES_EST,ES.N_PRECIOS_EST,ES.VISITAS,PUNTOS_EST,EMP.LOGIN,EMP.PASSWORD,EMP.PERS_CTCTO, EMP.TELEFONOMOVIL, EMP.FAX,EMP.WEB,EMP.MAIL,EMP.ACCOUNT_MANAGER,RESPUESTARAPIDA,CENTRAL_ACTIVA, NOPINIONES_EST,EMP.MAIL_CC, EMP.ACEPTAR_CR,EMP.VIDEOS_TEXT,ES.PRECIO_EST, ES.PUNTOS_EST, ES.RIESGO_EST, ES.ATENCION_EST, EMP.URL, DESCRIPCION,GALERIA_DESC,VIDEOS_TEXT,VIDEOS_DESC,COMO_LLEGAR, EMP.URL, EMP.NOMBRE, 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
            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='en'
            INNER JOIN LO_REGION_ADM1 REIAD ON RE.ID_REGION_ADM1 = REIAD.ID_REGION_ADM1
            LEFT JOIN LO_POBLACION_GB PO ON EMP.ID_POBLACION = PO.ID_POBLACION
                AND PO.IDIOMA='en'
            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 = 2
                AND SECI.FK_ID_IDIOMA_SI18N = 'en')
            INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
                AND (GRU.ID_TROPIC = 2)
            WHERE EMP.ID_MADRE = 19743630
                AND EMP.EMP_MADRE IN(2,4)
                AND EMP.VALID IN ('1', '-3');

Tiempo de la consulta: 0.0022239685058594

Tiempo acumulado:0.11201977729797

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

Tiempo de la consulta: 0.003525972366333

Tiempo acumulado:0.11554574966431

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

Tiempo de la consulta: 0.00069212913513184

Tiempo acumulado:0.11623787879944

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

Tiempo de la consulta: 0.0015361309051514

Tiempo acumulado:0.11777400970459

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[18]: 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, URL_PRE,TITULO_PRE,DESCRIPCION_PRE,INCLUYE_PRE,ALOJAMIENTO_TEXT_PRE,TRANSPORTE_TEXT_PRE,GALERIA_DESC_PRE,HORARIO_PRE, DURACION_PRE, PRE.TRANSPORTE_PRE,REI.DESC_REGION, PRE.MULTIACTIVIDAD_PRE, SECI.DESC_SECTOR
            FROM LO_PRECIOS PRE
            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='2'
                AND SECI.FK_ID_IDIOMA_SI18N='en'
                AND REI.IDIOMA='en'
                AND VALID_PRE IN(4)
                AND SEC.ID_SECTOR = 88
                AND REI.ID_REGION = 3144
                AND PRE.ID_EMPRESA_PRE !='19743630'
            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.010651111602783

Tiempo acumulado:0.12842512130737

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

Tiempo de la consulta: 0.00075602531433105

Tiempo acumulado:0.1291811466217

(Prod_Yumping_co_UK) (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, 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, DESCRIPCION,GALERIA_DESC,VIDEOS_TEXT,VIDEOS_DESC,COMO_LLEGAR, EMP.URL, EMP.NOMBRE, GRU.DESC_GRUPO
            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='en'
            LEFT JOIN LO_POBLACION_GB PO ON PO.ID_POBLACION=EMP.ID_POBLACION
                AND PO.IDIOMA='en' /*
            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='2'
                AND SECI.FK_ID_IDIOMA_SI18N='en'
                AND EMP.EMP_MADRE <> '0'
                AND SEC.ID_SECTOR='88'
            INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
                AND GRU.ID_TROPIC = '2' /*
            LEFT JOIN LO_EMPRESAS_SNIPPETS_RELACIONES ESR ON ESR.ID_EMPRESA = EMP.ID_EMPRESA
                AND ESR.ID_TROPIC = '2' */
            WHERE EMP.VALID=1
                AND EMP.ID_EMPRESA > '19743630'
                AND EMP.ID_PROVINCIA='3144'
                AND EMP.EMP_MADRE <> '3'
            GROUP BY EMP.ID_EMPRESA
            ORDER BY EMP.ID_EMPRESA ASC
            LIMIT 4;

Tiempo de la consulta: 0.0084738731384277

Tiempo acumulado:0.13765501976013

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[21]: 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, DESCRIPCION,GALERIA_DESC,VIDEOS_TEXT,VIDEOS_DESC,COMO_LLEGAR, EMP.URL, EMP.NOMBRE, GRU.DESC_GRUPO
            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='en'
            LEFT JOIN LO_POBLACION_GB 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='2'
                AND SECI.FK_ID_IDIOMA_SI18N='en'
                AND EMP.EMP_MADRE <> '0'
                AND SEC.ID_SECTOR='88'
            INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
                AND GRU.ID_TROPIC = '2' --
            LEFT JOIN LO_EMPRESAS_SNIPPETS_RELACIONES ESR ON ESR.ID_EMPRESA = EMP.ID_EMPRESA
                AND ESR.ID_TROPIC = '2'
            WHERE EMP.VALID=1
                AND EMP.ID_EMPRESA < '19743630'
                AND EMP.ID_PROVINCIA='3144'
                AND EMP.EMP_MADRE <> '3'
            GROUP BY EMP.ID_EMPRESA
            ORDER BY EMP.ID_EMPRESA ASC
            LIMIT 3;

Tiempo de la consulta: 0.016182899475098

Tiempo acumulado:0.15383791923523

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

Tiempo de la consulta: 0.0026769638061523

Tiempo acumulado:0.15651488304138

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

Tiempo de la consulta: 0.00062799453735352

Tiempo acumulado:0.15714287757874

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[24]: SELECT PRECIO_PRE, URL_PRE,TITULO_PRE,DESCRIPCION_PRE,INCLUYE_PRE,ALOJAMIENTO_TEXT_PRE,TRANSPORTE_TEXT_PRE,GALERIA_DESC_PRE,HORARIO_PRE, DURACION_PRE, 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_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='2'
                AND SECI.FK_ID_IDIOMA_SI18N='en'
                AND REI.IDIOMA='en'
                AND ID_EMPRESA='19743630'
                AND VALID_PD=1
                AND OFERTA_PD=1
                AND SECP.ID_ACTIVIDAD_PS = 88
                AND PRE.VALID_PRE = 4
            ORDER BY FECHA_CADUCIDAD_PD DESC
            LIMIT 1;

Tiempo de la consulta: 0.001704216003418

Tiempo acumulado:0.15884709358215

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[25]: SELECT URL, DESCRIPCION,GALERIA_DESC,VIDEOS_TEXT,VIDEOS_DESC,COMO_LLEGAR, EMP.URL, EMP.NOMBRE, ID_EMPRESA
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19743630;

Tiempo de la consulta: 0.001209020614624

Tiempo acumulado:0.16005611419678

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

Tiempo de la consulta: 0.0011391639709473

Tiempo acumulado:0.16119527816772

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[27]: 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 = 'en'
            LEFT JOIN LO_REGION_ADM1_I18N REIA ON REIA.ID_REGION_ADM1 = RE.ID_REGION_ADM1
                AND REIA.IDIOMA = 'en'
                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 = 'en'
            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 = 'en'
            WHERE EMP.ID_EMPRESA = 19743630;

Tiempo de la consulta: 0.0014839172363281

Tiempo acumulado:0.16267919540405

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

Tiempo de la consulta: 0.0014550685882568

Tiempo acumulado:0.16413426399231

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

Tiempo de la consulta: 0.0032968521118164

Tiempo acumulado:0.16743111610413

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[30]: SELECT URL AS URL_REGION, SIMCAPN, ID_CAPITAL
            FROM LO_REGION_I18N REI
            INNER JOIN LO_REGION RE ON RE.ID_REGION = REI.ID_REGION
            WHERE REI.ID_REGION = 3144
                AND REI.IDIOMA = 'en';

Tiempo de la consulta: 0.0017189979553223

Tiempo acumulado:0.16915011405945

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[31]: SELECT URL_POBLACION, ID_POBLACION
            FROM LO_POBLACION_GB PO
            WHERE PO.ID_POBLACION = 991695
                AND PO.IDIOMA = 'en';

Tiempo de la consulta: 0.0028829574584961

Tiempo acumulado:0.17203307151794

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[32]: SELECT URL, DESCRIPCION,GALERIA_DESC,VIDEOS_TEXT,VIDEOS_DESC,COMO_LLEGAR, EMP.URL, EMP.NOMBRE, ID_EMPRESA
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19743630;

Tiempo de la consulta: 0.00091886520385742

Tiempo acumulado:0.1729519367218

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[33]: SELECT OLD_URL, NEW_URL
FROM LO_URL_301 U
WHERE U.OLD_URL = '/en/powerboating/thames-jet--e19743630';

Tiempo de la consulta: 0.0012290477752686

Tiempo acumulado:0.17418098449707

(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 = 'gb_es', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_id_tropic_trad'
                AND CFG.AMBITO IN ('gb_es', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0043020248413086

Tiempo acumulado:0.17848300933838

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

Tiempo de la consulta: 0.00079798698425293

Tiempo acumulado:0.17928099632263

(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 = 'gb_es', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_Data_Base'
                AND CFG.AMBITO IN ('gb_es', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0047051906585693

Tiempo acumulado:0.1839861869812

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[37]: 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_co_UK.LO_EMPRESAS EMP
            LEFT JOIN Prod_Yumping_co_UK.LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
            LEFT JOIN Prod_Yumping_co_UK.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
                AND (SECI.ID_TROPIC = 21
                AND SECI.FK_ID_IDIOMA_SI18N = 'es')
            WHERE EMP.ID_EMPRESA = 19743630;

Tiempo de la consulta: 0.00095701217651367

Tiempo acumulado:0.18494319915771

(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 = 'gb_es', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'RequestUrl_empresa_trad'
                AND CFG.AMBITO IN ('gb_es', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0031449794769287

Tiempo acumulado:0.18808817863464

(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 = 'gb_it', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_id_tropic_trad'
                AND CFG.AMBITO IN ('gb_it', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0036041736602783

Tiempo acumulado:0.19169235229492

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

Tiempo de la consulta: 0.0055949687957764

Tiempo acumulado:0.1972873210907

(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 = 'gb_it', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_Data_Base'
                AND CFG.AMBITO IN ('gb_it', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0054647922515869

Tiempo acumulado:0.20275211334229

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[42]: 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_co_UK.LO_EMPRESAS EMP
            LEFT JOIN Prod_Yumping_co_UK.LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
            LEFT JOIN Prod_Yumping_co_UK.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
                AND (SECI.ID_TROPIC = 23
                AND SECI.FK_ID_IDIOMA_SI18N = 'it')
            WHERE EMP.ID_EMPRESA = 19743630;

Tiempo de la consulta: 0.00077295303344727

Tiempo acumulado:0.20352506637573

(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 = 'gb_it', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'RequestUrl_empresa_trad'
                AND CFG.AMBITO IN ('gb_it', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0035040378570557

Tiempo acumulado:0.20702910423279

(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 = 'gb_fr', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_id_tropic_trad'
                AND CFG.AMBITO IN ('gb_fr', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0051400661468506

Tiempo acumulado:0.21216917037964

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

Tiempo de la consulta: 0.0041790008544922

Tiempo acumulado:0.21634817123413

(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 = 'gb_fr', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_Data_Base'
                AND CFG.AMBITO IN ('gb_fr', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.005357027053833

Tiempo acumulado:0.22170519828796

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[47]: 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_co_UK.LO_EMPRESAS EMP
            LEFT JOIN Prod_Yumping_co_UK.LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
            LEFT JOIN Prod_Yumping_co_UK.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
                AND (SECI.ID_TROPIC = 24
                AND SECI.FK_ID_IDIOMA_SI18N = 'fr')
            WHERE EMP.ID_EMPRESA = 19743630;

Tiempo de la consulta: 0.0043339729309082

Tiempo acumulado:0.22603917121887

(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 = 'gb_fr', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'RequestUrl_empresa_trad'
                AND CFG.AMBITO IN ('gb_fr', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00072097778320312

Tiempo acumulado:0.22676014900208

(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 = 'gb_de', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_id_tropic_trad'
                AND CFG.AMBITO IN ('gb_de', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0043430328369141

Tiempo acumulado:0.23110318183899

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

Tiempo de la consulta: 0.003460168838501

Tiempo acumulado:0.23456335067749

(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 = 'gb_de', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_Data_Base'
                AND CFG.AMBITO IN ('gb_de', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0060310363769531

Tiempo acumulado:0.24059438705444

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[52]: 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_co_UK.LO_EMPRESAS EMP
            LEFT JOIN Prod_Yumping_co_UK.LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
            LEFT JOIN Prod_Yumping_co_UK.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
                AND (SECI.ID_TROPIC = 27
                AND SECI.FK_ID_IDIOMA_SI18N = 'de')
            WHERE EMP.ID_EMPRESA = 19743630;

Tiempo de la consulta: 0.0087249279022217

Tiempo acumulado:0.24931931495667

(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 = 'gb_de', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'RequestUrl_empresa_trad'
                AND CFG.AMBITO IN ('gb_de', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0044839382171631

Tiempo acumulado:0.25380325317383

(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 = 'gb_pt', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_id_tropic_trad'
                AND CFG.AMBITO IN ('gb_pt', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0028939247131348

Tiempo acumulado:0.25669717788696

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

Tiempo de la consulta: 0.00070881843566895

Tiempo acumulado:0.25740599632263

(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 = 'gb_pt', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_Data_Base'
                AND CFG.AMBITO IN ('gb_pt', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0024449825286865

Tiempo acumulado:0.25985097885132

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[57]: 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_co_UK.LO_EMPRESAS EMP
            LEFT JOIN Prod_Yumping_co_UK.LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
            LEFT JOIN Prod_Yumping_co_UK.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
                AND (SECI.ID_TROPIC = 28
                AND SECI.FK_ID_IDIOMA_SI18N = 'pt')
            WHERE EMP.ID_EMPRESA = 19743630;

Tiempo de la consulta: 0.0010571479797363

Tiempo acumulado:0.26090812683105

(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 = 'gb_pt', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'RequestUrl_empresa_trad'
                AND CFG.AMBITO IN ('gb_pt', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0031669139862061

Tiempo acumulado:0.26407504081726

(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 = 'gb_mx', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_id_tropic_trad'
                AND CFG.AMBITO IN ('gb_mx', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0046100616455078

Tiempo acumulado:0.26868510246277

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

Tiempo de la consulta: 0.00095200538635254

Tiempo acumulado:0.26963710784912

(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 = 'gb_mx', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_Data_Base'
                AND CFG.AMBITO IN ('gb_mx', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0011320114135742

Tiempo acumulado:0.2707691192627

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[62]: 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_co_UK.LO_EMPRESAS EMP
            LEFT JOIN Prod_Yumping_co_UK.LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
            LEFT JOIN Prod_Yumping_co_UK.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
                AND (SECI.ID_TROPIC = 25
                AND SECI.FK_ID_IDIOMA_SI18N = 'es')
            WHERE EMP.ID_EMPRESA = 19743630;

Tiempo de la consulta: 0.0029280185699463

Tiempo acumulado:0.27369713783264

(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 = 'gb_mx', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'RequestUrl_empresa_trad'
                AND CFG.AMBITO IN ('gb_mx', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0011849403381348

Tiempo acumulado:0.27488207817078

(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 = 'gb_ch', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_id_tropic_trad'
                AND CFG.AMBITO IN ('gb_ch', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00084209442138672

Tiempo acumulado:0.27572417259216

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

Tiempo de la consulta: 0.003680944442749

Tiempo acumulado:0.27940511703491

(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 = 'gb_ch', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_Data_Base'
                AND CFG.AMBITO IN ('gb_ch', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00063300132751465

Tiempo acumulado:0.28003811836243

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[67]: 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_co_UK.LO_EMPRESAS EMP
            LEFT JOIN Prod_Yumping_co_UK.LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
            LEFT JOIN Prod_Yumping_co_UK.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
                AND (SECI.ID_TROPIC = 26
                AND SECI.FK_ID_IDIOMA_SI18N = 'ch')
            WHERE EMP.ID_EMPRESA = 19743630;

Tiempo de la consulta: 0.00080299377441406

Tiempo acumulado:0.28084111213684

(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 = 'gb_ch', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'RequestUrl_empresa_trad'
                AND CFG.AMBITO IN ('gb_ch', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0022590160369873

Tiempo acumulado:0.28310012817383

(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 = 'gb_es', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('gb_es', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00061798095703125

Tiempo acumulado:0.28371810913086

(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 = 'gb_es', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('gb_es', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0023131370544434

Tiempo acumulado:0.2860312461853

(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 = 'gb_es', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'subdomain'
                AND CFG.AMBITO IN ('gb_es', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0054919719696045

Tiempo acumulado:0.29152321815491

(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 = 'gb_es', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('gb_es', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0039081573486328

Tiempo acumulado:0.29543137550354

(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 = 'gb_es', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('gb_es', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0041878223419189

Tiempo acumulado:0.29961919784546

(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 = 'gb_es', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'subdomain_lang'
                AND CFG.AMBITO IN ('gb_es', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0037710666656494

Tiempo acumulado:0.30339026451111

(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 = 'gb_it', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('gb_it', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0038909912109375

Tiempo acumulado:0.30728125572205

(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 = 'gb_it', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('gb_it', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00081110000610352

Tiempo acumulado:0.30809235572815

(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 = 'gb_it', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('gb_it', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0027270317077637

Tiempo acumulado:0.31081938743591

(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 = 'gb_it', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('gb_it', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0031189918518066

Tiempo acumulado:0.31393837928772

(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 = 'gb_it', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'subdomain_lang'
                AND CFG.AMBITO IN ('gb_it', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0044388771057129

Tiempo acumulado:0.31837725639343

(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 = 'gb_fr', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('gb_fr', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0031061172485352

Tiempo acumulado:0.32148337364197

(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 = 'gb_fr', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('gb_fr', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0045919418334961

Tiempo acumulado:0.32607531547546

(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 = 'gb_fr', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('gb_fr', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0030601024627686

Tiempo acumulado:0.32913541793823

(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 = 'gb_fr', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('gb_fr', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0035910606384277

Tiempo acumulado:0.33272647857666

(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 = 'gb_fr', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'subdomain_lang'
                AND CFG.AMBITO IN ('gb_fr', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0032341480255127

Tiempo acumulado:0.33596062660217

(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 = 'gb_de', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('gb_de', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0062928199768066

Tiempo acumulado:0.34225344657898

(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 = 'gb_de', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('gb_de', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0033419132232666

Tiempo acumulado:0.34559535980225

(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 = 'gb_de', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('gb_de', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0043158531188965

Tiempo acumulado:0.34991121292114

(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 = 'gb_de', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('gb_de', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0053310394287109

Tiempo acumulado:0.35524225234985

(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 = 'gb_de', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'subdomain_lang'
                AND CFG.AMBITO IN ('gb_de', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0060639381408691

Tiempo acumulado:0.36130619049072

(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 = 'gb_pt', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('gb_pt', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0009620189666748

Tiempo acumulado:0.3622682094574

(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 = 'gb_pt', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('gb_pt', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0054810047149658

Tiempo acumulado:0.36774921417236

(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 = 'gb_pt', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('gb_pt', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0029458999633789

Tiempo acumulado:0.37069511413574

(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 = 'gb_pt', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('gb_pt', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0071067810058594

Tiempo acumulado:0.3778018951416

(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 = 'gb_pt', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'subdomain_lang'
                AND CFG.AMBITO IN ('gb_pt', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0023999214172363

Tiempo acumulado:0.38020181655884

(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 = 'gb_mx', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('gb_mx', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0054421424865723

Tiempo acumulado:0.38564395904541

(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 = 'gb_mx', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('gb_mx', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00066304206848145

Tiempo acumulado:0.38630700111389

(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 = 'gb_mx', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('gb_mx', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00065207481384277

Tiempo acumulado:0.38695907592773

(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 = 'gb_mx', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('gb_mx', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.0012209415435791

Tiempo acumulado:0.38818001747131

(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 = 'gb_mx', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'subdomain_lang'
                AND CFG.AMBITO IN ('gb_mx', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.001392126083374

Tiempo acumulado:0.38957214355469

(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 = 'gb_ch', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('gb_ch', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.001945972442627

Tiempo acumulado:0.39151811599731

(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 = 'gb_ch', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('gb_ch', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00060105323791504

Tiempo acumulado:0.39211916923523

(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 = 'gb_ch', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('gb_ch', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00053906440734863

Tiempo acumulado:0.39265823364258

(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 = 'gb_ch', 1, 0) AS PESO
            FROM Yumping_proc_comun.LO_CONFIG CFG
            WHERE CFG.NAME = 'Request_href_lang'
                AND CFG.AMBITO IN ('gb_ch', 'global')
            ORDER BY PESO DESC
            LIMIT 1;

Tiempo de la consulta: 0.00062203407287598

Tiempo acumulado:0.39328026771545

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

Tiempo de la consulta: 0.00052714347839355

Tiempo acumulado:0.39380741119385

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

Tiempo de la consulta: 0.00052499771118164

Tiempo acumulado:0.39433240890503

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[106]: SELECT URL, DESCRIPCION,GALERIA_DESC,VIDEOS_TEXT,VIDEOS_DESC,COMO_LLEGAR, EMP.URL, EMP.NOMBRE, ID_EMPRESA
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19743630;

Tiempo de la consulta: 0.00057697296142578

Tiempo acumulado:0.39490938186646

(Prod_Yumping_co_UK) (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 = 19743630;

Tiempo de la consulta: 0.00089097023010254

Tiempo acumulado:0.39580035209656

(Prod_Yumping_co_UK) (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 = 19743630;

Tiempo de la consulta: 0.00041317939758301

Tiempo acumulado:0.39621353149414

(Prod_Yumping_co_UK) (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 = 19743630;

Tiempo de la consulta: 0.00094103813171387

Tiempo acumulado:0.39715456962585

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

Tiempo de la consulta: 0.0010290145874023

Tiempo acumulado:0.39818358421326

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

Tiempo de la consulta: 0.00080704689025879

Tiempo acumulado:0.39899063110352

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

Tiempo de la consulta: 0.00062704086303711

Tiempo acumulado:0.39961767196655

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

Tiempo de la consulta: 0.00037288665771484

Tiempo acumulado:0.39999055862427

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

Tiempo de la consulta: 0.00095105171203613

Tiempo acumulado:0.4009416103363

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

Tiempo de la consulta: 0.0031790733337402

Tiempo acumulado:0.40412068367004

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

Tiempo de la consulta: 0.0006709098815918

Tiempo acumulado:0.40479159355164

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

Tiempo de la consulta: 0.00037693977355957

Tiempo acumulado:0.4051685333252

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

Tiempo de la consulta: 0.0042908191680908

Tiempo acumulado:0.40945935249329

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

Tiempo de la consulta: 0.0027880668640137

Tiempo acumulado:0.4122474193573

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

Tiempo de la consulta: 0.0011169910430908

Tiempo acumulado:0.41336441040039

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

Tiempo de la consulta: 0.0014138221740723

Tiempo acumulado:0.41477823257446

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

Tiempo de la consulta: 0.0082690715789795

Tiempo acumulado:0.42304730415344

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[123]: SELECT *,(6378*acos(cos(radians('51.5009'))*cos(radians(LATITUD_CA))*cos(radians(LONGITUD_CA)-radians('-0.122008')) +sin(radians('51.5009'))*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.0010490417480469

Tiempo acumulado:0.42409634590149

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[124]: SELECT *
            FROM LO_TOPRURAL_GB
            WHERE FK_ID_EMPRESA_TR='19743630'
            LIMIT 10;

Tiempo de la consulta: 0.0059690475463867

Tiempo acumulado:0.43006539344788

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[125]: SELECT *,(6378*acos(cos(radians('51.5009'))*cos(radians(LATITUD_TR))*cos(radians(LONGITUD_TR)-radians('-0.122008')) +sin(radians('51.5009'))*sin(radians(LATITUD_TR)))) AS DISTANCIA
            FROM LO_TOPRURAL_GB
            WHERE ID_PAIS_TR='247'
                AND PRECIO_MEDIO_TR<>0
                AND COMENTARIOS_TR<>''
                AND DIRECCION_TR<>''
                AND FK_ID_EMPRESA_TR<>'19743630' HAVING DISTANCIA < 30
            LIMIT 10;

Tiempo de la consulta: 0.0011448860168457

Tiempo acumulado:0.43121027946472

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

Tiempo de la consulta: 0.0071539878845215

Tiempo acumulado:0.43836426734924

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

Tiempo de la consulta: 0.0013120174407959

Tiempo acumulado:0.43967628479004

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[128]: SELECT URL, DESCRIPCION,GALERIA_DESC,VIDEOS_TEXT,VIDEOS_DESC,COMO_LLEGAR, EMP.URL, EMP.NOMBRE, ID_EMPRESA
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19743630;

Tiempo de la consulta: 0.0027937889099121

Tiempo acumulado:0.44247007369995

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

Tiempo de la consulta: 0.01776909828186

Tiempo acumulado:0.46023917198181

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

Tiempo de la consulta: 0.00074982643127441

Tiempo acumulado:0.46098899841309

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

Tiempo de la consulta: 0.00041294097900391

Tiempo acumulado:0.46140193939209

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[132]: SELECT PRECIO_PRE, URL_PRE,TITULO_PRE,DESCRIPCION_PRE,INCLUYE_PRE,ALOJAMIENTO_TEXT_PRE,TRANSPORTE_TEXT_PRE,GALERIA_DESC_PRE,HORARIO_PRE, DURACION_PRE, 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_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='2'
                AND SECI.FK_ID_IDIOMA_SI18N='en'
                AND REI.IDIOMA='en'
                AND ID_EMPRESA='19743630'
                AND VALID_PD=1
                AND OFERTA_PD=1
                AND SECP.ID_ACTIVIDAD_PS = 88
                AND PRE.VALID_PRE = 4
            ORDER BY FECHA_CADUCIDAD_PD DESC
            LIMIT 1;

Tiempo de la consulta: 0.0051860809326172

Tiempo acumulado:0.46658802032471

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

Tiempo de la consulta: 0.001431941986084

Tiempo acumulado:0.46801996231079

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[134]: 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='19743630' OR OP.ID_MADRE='19743630' )
                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.0021319389343262

Tiempo acumulado:0.47015190124512

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

Tiempo de la consulta: 0.00082516670227051

Tiempo acumulado:0.47097706794739

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

Tiempo de la consulta: 0.00049996376037598

Tiempo acumulado:0.47147703170776

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

Tiempo de la consulta: 0.0014259815216064

Tiempo acumulado:0.47290301322937

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

Tiempo de la consulta: 0.0011918544769287

Tiempo acumulado:0.4740948677063

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

Tiempo de la consulta: 0.0011289119720459

Tiempo acumulado:0.47522377967834

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

Tiempo de la consulta: 0.0006721019744873

Tiempo acumulado:0.47589588165283

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

Tiempo de la consulta: 0.00050783157348633

Tiempo acumulado:0.47640371322632

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

Tiempo de la consulta: 0.00052690505981445

Tiempo acumulado:0.47693061828613

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

Tiempo de la consulta: 0.00071907043457031

Tiempo acumulado:0.4776496887207

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

Tiempo de la consulta: 0.00047993659973145

Tiempo acumulado:0.47812962532043

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

Tiempo de la consulta: 0.00044488906860352

Tiempo acumulado:0.47857451438904

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

Tiempo de la consulta: 0.00044608116149902

Tiempo acumulado:0.47902059555054

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

Tiempo de la consulta: 0.00070309638977051

Tiempo acumulado:0.47972369194031

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

Tiempo de la consulta: 0.0005030632019043

Tiempo acumulado:0.48022675514221

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

Tiempo de la consulta: 0.00049591064453125

Tiempo acumulado:0.48072266578674

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

Tiempo de la consulta: 0.00047111511230469

Tiempo acumulado:0.48119378089905

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

Tiempo de la consulta: 0.00073790550231934

Tiempo acumulado:0.48193168640137

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

Tiempo de la consulta: 0.00050592422485352

Tiempo acumulado:0.48243761062622

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

Tiempo de la consulta: 0.00046586990356445

Tiempo acumulado:0.48290348052979

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

Tiempo de la consulta: 0.00044012069702148

Tiempo acumulado:0.48334360122681

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

Tiempo de la consulta: 0.00069284439086914

Tiempo acumulado:0.48403644561768

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

Tiempo de la consulta: 0.0005030632019043

Tiempo acumulado:0.48453950881958

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

Tiempo de la consulta: 0.00044608116149902

Tiempo acumulado:0.48498558998108

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

Tiempo de la consulta: 0.00042295455932617

Tiempo acumulado:0.48540854454041

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

Tiempo de la consulta: 0.00072407722473145

Tiempo acumulado:0.48613262176514

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

Tiempo de la consulta: 0.00062394142150879

Tiempo acumulado:0.48675656318665

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

Tiempo de la consulta: 0.00054502487182617

Tiempo acumulado:0.48730158805847

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

Tiempo de la consulta: 0.00067687034606934

Tiempo acumulado:0.48797845840454

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

Tiempo de la consulta: 0.00070905685424805

Tiempo acumulado:0.48868751525879

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

Tiempo de la consulta: 0.00047993659973145

Tiempo acumulado:0.48916745185852

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

Tiempo de la consulta: 0.00049209594726562

Tiempo acumulado:0.48965954780579

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

Tiempo de la consulta: 0.00045895576477051

Tiempo acumulado:0.49011850357056

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

Tiempo de la consulta: 0.00073003768920898

Tiempo acumulado:0.49084854125977

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

Tiempo de la consulta: 0.00052309036254883

Tiempo acumulado:0.49137163162231

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

Tiempo de la consulta: 0.0004580020904541

Tiempo acumulado:0.49182963371277

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

Tiempo de la consulta: 0.00043606758117676

Tiempo acumulado:0.49226570129395

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

Tiempo de la consulta: 0.00095796585083008

Tiempo acumulado:0.49322366714478

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

Tiempo de la consulta: 0.00075387954711914

Tiempo acumulado:0.49397754669189

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

Tiempo de la consulta: 0.00052404403686523

Tiempo acumulado:0.49450159072876

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

Tiempo de la consulta: 0.00068402290344238

Tiempo acumulado:0.4951856136322

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

Tiempo de la consulta: 0.00066089630126953

Tiempo acumulado:0.49584650993347

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

Tiempo de la consulta: 0.00047206878662109

Tiempo acumulado:0.49631857872009

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

Tiempo de la consulta: 0.00046396255493164

Tiempo acumulado:0.49678254127502

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

Tiempo de la consulta: 0.00042915344238281

Tiempo acumulado:0.49721169471741

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

Tiempo de la consulta: 0.00068902969360352

Tiempo acumulado:0.49790072441101

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

Tiempo de la consulta: 0.00069403648376465

Tiempo acumulado:0.49859476089478

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

Tiempo de la consulta: 0.00043010711669922

Tiempo acumulado:0.49902486801147

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

Tiempo de la consulta: 0.00042605400085449

Tiempo acumulado:0.49945092201233

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

Tiempo de la consulta: 0.0007481575012207

Tiempo acumulado:0.50019907951355

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

Tiempo de la consulta: 0.0004580020904541

Tiempo acumulado:0.500657081604

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

Tiempo de la consulta: 0.00047016143798828

Tiempo acumulado:0.50112724304199

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

Tiempo de la consulta: 0.00046205520629883

Tiempo acumulado:0.50158929824829

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

Tiempo de la consulta: 0.00038003921508789

Tiempo acumulado:0.50196933746338

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[188]: 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, URL_PRE,TITULO_PRE,DESCRIPCION_PRE,INCLUYE_PRE,ALOJAMIENTO_TEXT_PRE,TRANSPORTE_TEXT_PRE,GALERIA_DESC_PRE,HORARIO_PRE, DURACION_PRE, MULTIACTIVIDAD_PRE
            FROM LO_PRECIOS PRE
            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 = 'en'
            INNER JOIN LO_POBLACION_GB POI ON POI.ID_POBLACION = PRE.ID_POBLACION_PRE
                AND POI.IDIOMA = 'en'
            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='en'
                AND SECI.ID_TROPIC = 2
            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 = 19743630
                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.0019700527191162

Tiempo acumulado:0.5039393901825

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[189]: 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, DESCRIPCION,GALERIA_DESC,VIDEOS_TEXT,VIDEOS_DESC,COMO_LLEGAR, EMP.URL, EMP.NOMBRE, 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
            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='en'
            INNER JOIN LO_REGION_ADM1 REIAD ON RE.ID_REGION_ADM1 = REIAD.ID_REGION_ADM1
            LEFT JOIN LO_POBLACION_GB PO ON EMP.ID_POBLACION = PO.ID_POBLACION
                AND PO.IDIOMA='en'
            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 = 2
                AND SECI.FK_ID_IDIOMA_SI18N = 'en')
            INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
                AND (GRU.ID_TROPIC = 2)
            WHERE EMP.ID_EMPRESA = 19743630
                AND EMP.VALID IN ('1', '-3')
            LIMIT 1;

Tiempo de la consulta: 0.0013442039489746

Tiempo acumulado:0.50528359413147

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[190]: SELECT TITULO_PRE,DESCRIPCION_PRE,INCLUYE_PRE,ALOJAMIENTO_TEXT_PRE,TRANSPORTE_TEXT_PRE,GALERIA_PRE,GALERIA_DESC_PRE,HORARIO_PRE, DURACION_PRE, PRE.ID_PRECIO ,SECI.ID_SECTOR, SECI.URL URL_SECTOR,REI.URL URL_REGION, PRE.FK_ID_PAIS_PRE AS ID_PAIS, /*LEAST(if(PRECIO_MIN_PRE>0,PRECIO_MIN_PRE,PRECIO_PRE),PRECIO_PRE) PRECIO,*/ if(PRECIO_PD>0,LEAST(MIN(PRECIO_PD),PRECIO_PRE),LEAST(999999999,PRECIO_PRE) ) PRECIO_D, IF(PD.PRECIO_PD > 0
                AND PD.VALID_PD = 1, LEAST(MIN(PD.PRECIO_PD), PRE.PRECIO_PRE), LEAST(999999999, PRECIO_PRE)) AS PRECIO, PRECIO_PRE, COUNT(DISTINCT RC.ID_RESERVA_COMPRA) AS VENTAS, IF(PD.PRECIO_PD > 0
                AND PD.VALID_PD = 1, (1 - (MIN(PD.PRECIO_PD) / PRE.PRECIO_PRE))*100 , 0) AS DESCUENTO, DESCUENTO_MIN_PRE DESCUENTO, PRE.FOTOPRINCIPAL_PRE,PRE.PRECIO_UNITARIO_PRE, DATE_FORMAT(PD.FECHA_CADUCIDAD_PD,'%d') AS DIA_CAD, DATE_FORMAT(PD.FECHA_CADUCIDAD_PD,'%m') AS MES_CAD, DATE_FORMAT(PD.FECHA_CADUCIDAD_PD,'%Y') AS ANYO_CAD, DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%Y/%m/%d') AS FECHA, DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%d') AS DIA_COM, DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%m') AS MES_COM, OP.VALORACION,COUNT(OP.ID_OPINION) AS OPIS, PD.OFERTA_PD,VALID_PD, PRE.MIN_PERS_PRE, MIN(PD.MIN_PERSONAS_PD) AS MIN_PERSONAS_PD, PRE.MAX_PERS_PRE, MAX(PD.MAX_PERSONAS_PD) AS MAX_PERSONAS_PD, PRE.ALOJAMIENTO_PRE, PRE.FK_ID_PAIS_PRE AS ID_PAIS, PRE.COMIDA_PRE,PRE.TRANSPORTE_PRE,REI.DESC_REGION, PRE.MULTIACTIVIDAD_PRE, URL_PRE,TITULO_PRE,DESCRIPCION_PRE,INCLUYE_PRE,ALOJAMIENTO_TEXT_PRE,TRANSPORTE_TEXT_PRE,GALERIA_DESC_PRE,HORARIO_PRE, DURACION_PRE, SECI.DESC_SECTOR
            FROM LO_PRECIOS PRE
            INNER JOIN LO_PRECIOS_SECTORES SECP ON PRE.ID_PRECIO=SECP.ID_PRECIO_PS
            INNER JOIN LO_REGION_I18N REI ON PRE.ID_REGION_PRE=REI.ID_REGION
            INNER JOIN LO_SECTORES_I18N SECI ON SECP.ID_ACTIVIDAD_PS=SECI.ID_SECTOR
            INNER JOIN LO_SECTORES SEC ON SECI.ID_SECTOR=SEC.ID_SECTOR
            LEFT JOIN LO_RESERVAS_COMPRAS RC ON RC.ID_PRECIO_RC = PRE.ID_PRECIO
                AND RC.VALID_RC NOT IN(0,2,6,7)
            LEFT JOIN LO_PRECIOS_DESCUENTOS PD ON PD.ID_PRECIO_PD = PRE.ID_PRECIO
                AND PD.VALID_PD = 1
            LEFT JOIN LO_EMPRESAS_OPINIONES OP ON OP.RESERVA_FEEDBACK = RC.ID_RESERVA_COMPRA
                AND OP.VALID=1
            LEFT JOIN LO_PRECIOS_RESTRICCIONES PR ON PRE.ID_PRECIO = PR.ID_PRECIO
            WHERE SECI.ID_TROPIC='2'
                AND SECI.FK_ID_IDIOMA_SI18N='en'
                AND REI.IDIOMA='en'
                AND VALID_PRE IN(4)
                AND PRE.ID_EMPRESA_PRE ='19743630'
                AND (PR.FICHA = 0 OR PR.FICHA IS NULL OR IF(PR.FECHA_INICIO IS NOT NULL, CONCAT(DATE_FORMAT(NOW(), '%Y-'), DATE_FORMAT(PR.FECHA_INICIO, '%m-%d')) <= CONCAT(DATE_FORMAT(NOW(), '%Y-'), DATE_FORMAT(NOW(), '%m-%d'))
                AND IF(DATE_FORMAT(PR.FECHA_FIN, '%m') >= DATE_FORMAT(PR.FECHA_INICIO, '%m'), CONCAT(DATE_FORMAT(NOW(), '%Y-'), DATE_FORMAT(PR.FECHA_FIN, '%m-%d')) >= CONCAT(DATE_FORMAT(NOW(), '%Y-'), DATE_FORMAT(NOW(), '%m-%d')), CONCAT((1+ DATE_FORMAT(NOW(), '%Y')),'-', DATE_FORMAT(PR.FECHA_FIN, '%m-%d')) >= CONCAT(DATE_FORMAT(NOW(), '%Y'),'-', DATE_FORMAT(NOW(), '%m-%d'))),1!=1))
            GROUP BY PRE.ID_PRECIO
            ORDER BY VENTAS desc, N_ORDER_EMP_PRE IS NULL ASC,N_ORDER_EMP_PRE ASC, OFERTA_PD DESC, N_ORDER_PRE DESC,PRECIO ASC;

Tiempo de la consulta: 0.0017311573028564

Tiempo acumulado:0.50701475143433

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[191]: 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, URL_PRE,TITULO_PRE,DESCRIPCION_PRE,INCLUYE_PRE,ALOJAMIENTO_TEXT_PRE,TRANSPORTE_TEXT_PRE,GALERIA_DESC_PRE,HORARIO_PRE, DURACION_PRE, PRE.TRANSPORTE_PRE,REI.DESC_REGION, PRE.MULTIACTIVIDAD_PRE, SECI.DESC_SECTOR
            FROM LO_PRECIOS PRE
            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='2'
                AND SECI.FK_ID_IDIOMA_SI18N='en'
                AND REI.IDIOMA='en'
                AND VALID_PRE IN(4)
                AND SEC.ID_SECTOR = 88
                AND REI.ID_REGION = 3144
                AND PRE.ID_EMPRESA_PRE !='19743630'
            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.0036201477050781

Tiempo acumulado:0.5106348991394

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[192]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
            FROM LO_SEO_KEYWORDS SEO
            WHERE SEO.ID_KEY = ''
                AND SEO.ID_TROPIC = 2
                AND SEO.FK_ID_REG_ADM = 0
                AND 1=1;

Tiempo de la consulta: 0.0011179447174072

Tiempo acumulado:0.51175284385681

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[193]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
            FROM LO_SEO_KEYWORDS SEO
            WHERE SEO.ID_KEY = 'S88'
                AND SEO.ID_TROPIC = 2
                AND SEO.FK_ID_REG_ADM = 0
                AND 1=1;

Tiempo de la consulta: 0.00058484077453613

Tiempo acumulado:0.51233768463135

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[194]: SELECT DATE_FORMAT(PRE.FEC_ULT_COMPRA, '%Y-%m-%d') AS FEC_ULT_COMPRA, DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%d') AS DIA_COM, DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%m') AS MES_COM
            FROM LO_PRECIOS PRE
            WHERE ID_PRECIO = 68320
                AND VALID_PRE = 4
            GROUP BY PRE.ID_PRECIO HAVING FEC_ULT_COMPRA IS NOT NULL
            LIMIT 1;

Tiempo de la consulta: 0.00047183036804199

Tiempo acumulado:0.51280951499939

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[195]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
            FROM LO_SEO_KEYWORDS SEO
            WHERE SEO.ID_KEY = ''
                AND SEO.ID_TROPIC = 2
                AND SEO.FK_ID_REG_ADM = 0
                AND 1=1;

Tiempo de la consulta: 0.00042605400085449

Tiempo acumulado:0.51323556900024

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[196]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
            FROM LO_SEO_KEYWORDS SEO
            WHERE SEO.ID_KEY = 'S88'
                AND SEO.ID_TROPIC = 2
                AND SEO.FK_ID_REG_ADM = 0
                AND 1=1;

Tiempo de la consulta: 0.00050497055053711

Tiempo acumulado:0.51374053955078

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[197]: SELECT SEOHOME.DESCRIPTION,SEOHOME.DESCRIPTION2,SEOHOME.HEIGHT, SEOHOME.CONTENT_MANAGER, DATE_FORMAT(SEOHOME.FEC_INSERT, '%d/%m/%Y %H:%i') FECHA_INSERT, DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%d/%m/%Y %H:%i') FECHA_MOD, CA.NOMBRE, CA.ID,DATE_FORMAT(SEOHOME.FEC_INSERT, '%Y-%m-%dT%H:%i') IN_GOOGLE, DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%Y-%m-%dT%H:%i') MOD_GOOGLE,AU.ID_ADMIN, GALERIA, GALERIA_DESC, CA.JOB, DATE_FORMAT(SEOHOME.FEC_INSERT, '%d') DAY_INSERT, DATE_FORMAT(SEOHOME.FEC_INSERT, '%m') MONTH_INSERT, DATE_FORMAT(SEOHOME.FEC_INSERT, '%Y') YEAR_INSERT, DATE_FORMAT(SEOHOME.FEC_INSERT, '%H:%i') HORA_INSERT, DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%d') DAY_MOD, DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%m') MONTH_MOD, DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%Y') YEAR_MOD, DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%H:%i') HORA_MOD
            FROM LO_SEO_DESCRIPTIONS_HOME SEOHOME
            LEFT JOIN LO_ADMIN_USERS AU ON AU.LOGIN = SEOHOME.CONTENT_MANAGER
            LEFT JOIN LO_CONTENIDO_AUTORES CA ON CA.ID_ADMIN = AU.ID_ADMIN
                AND CA.ID_TROPIC = 2
            WHERE SEOHOME.ID_TROPIC = 2
                AND SEOHOME.ID_KEY = 'S88'
                AND SEO_VALID in (0,1)
                AND SEOHOME.ID_LOCALIZACION='';

Tiempo de la consulta: 0.0080361366271973

Tiempo acumulado:0.52177667617798

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[198]: SELECT COUNT(*) AS NUMOPINIONES, (SUM(VALORACION) / COUNT(*)) /20 AS VALORACION
            FROM LO_EMPRESAS_OPINIONES OP
            LEFT JOIN LO_RESERVAS_COMPRAS RC ON OP.RESERVA_FEEDBACK = RC.ID_RESERVA_COMPRA
            LEFT JOIN LO_PRECIOS PRE ON RC.ID_PRECIO_RC = PRE.ID_PRECIO
            WHERE PRE.ID_PRECIO = 68320
                AND OP.VALID = 1;

Tiempo de la consulta: 0.00070905685424805

Tiempo acumulado:0.52248573303223

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[199]: SELECT *
            FROM LO_FOTOS
            WHERE ID_PRECIO = 68320
                AND VALID = 1;

Tiempo de la consulta: 0.0016379356384277

Tiempo acumulado:0.52412366867065

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[200]: SELECT *
            FROM LO_FOTOS
            WHERE ID_PRECIO = 68320
                AND FOTO = 'p-68320-tower-millennium-pier-1_16159865574198.jpeg'
                AND VALID = 1;

Tiempo de la consulta: 0.00053310394287109

Tiempo acumulado:0.52465677261353

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[201]: SELECT URL_PRE, URL_PRE,TITULO_PRE,DESCRIPCION_PRE,INCLUYE_PRE,ALOJAMIENTO_TEXT_PRE,TRANSPORTE_TEXT_PRE,GALERIA_DESC_PRE,HORARIO_PRE, DURACION_PRE, ID_PRECIO, FK_ID_PAIS_PRE
FROM LO_PRECIOS PRE
WHERE PRE.ID_PRECIO = 68320;

Tiempo de la consulta: 0.00043201446533203

Tiempo acumulado:0.52508878707886

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[202]: SELECT ID_PRECIO_PADRE
            FROM LO_PRECIOS_ASIGNACION PA
            INNER JOIN LO_PRECIOS PRE ON PRE.ID_PRECIO = PA.ID_PRECIO_PADRE
                AND PRE.VALID_PRE = 4
            WHERE PA.ID_PRECIO = 68320;

Tiempo de la consulta: 0.0011110305786133

Tiempo acumulado:0.52619981765747

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[203]: SELECT EXITO
            FROM LO_PRECIOS_EXITO
            WHERE ID_PRECIO = 68320
            LIMIT 1;

Tiempo de la consulta: 0.0010180473327637

Tiempo acumulado:0.52721786499023

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[204]: SELECT COUNT(*) AS TOTAL
            FROM LO_PRECIOS_SECTORES PS
            WHERE PS.ID_ACTIVIDAD_PS NOT IN (100,101)
                AND PS.ID_PRECIO_PS = 68320;

Tiempo de la consulta: 0.00047707557678223

Tiempo acumulado:0.52769494056702

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[205]: SELECT *
            FROM LO_PRECIOS_DIA_ESPECIAL PD
            WHERE PD.ID_PRECIO_DE = 68320
                AND ID_TIPO_DE = 7
                AND VALID = 1;

Tiempo de la consulta: 0.0011007785797119

Tiempo acumulado:0.52879571914673

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[206]: SELECT *
            FROM LO_PRECIOS_DISPONIBILIDAD_CALENDARIO
            WHERE VALID = 1
                AND ID_PRECIO = 68320;

Tiempo de la consulta: 0.0011270046234131

Tiempo acumulado:0.52992272377014

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[207]: SELECT DATE_FORMAT(PRE.FEC_ULT_COMPRA, '%Y-%m-%d') AS FEC_ULT_COMPRA, DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%d') AS DIA_COM, DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%m') AS MES_COM
            FROM LO_PRECIOS PRE
            WHERE ID_PRECIO = 68319
                AND VALID_PRE = 4
            GROUP BY PRE.ID_PRECIO HAVING FEC_ULT_COMPRA IS NOT NULL
            LIMIT 1;

Tiempo de la consulta: 0.00046801567077637

Tiempo acumulado:0.53039073944092

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[208]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
            FROM LO_SEO_KEYWORDS SEO
            WHERE SEO.ID_KEY = ''
                AND SEO.ID_TROPIC = 2
                AND SEO.FK_ID_REG_ADM = 0
                AND 1=1;

Tiempo de la consulta: 0.00041604042053223

Tiempo acumulado:0.53080677986145

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[209]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
            FROM LO_SEO_KEYWORDS SEO
            WHERE SEO.ID_KEY = 'S88'
                AND SEO.ID_TROPIC = 2
                AND SEO.FK_ID_REG_ADM = 0
                AND 1=1;

Tiempo de la consulta: 0.00046992301940918

Tiempo acumulado:0.53127670288086

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[210]: SELECT SEOHOME.DESCRIPTION,SEOHOME.DESCRIPTION2,SEOHOME.HEIGHT, SEOHOME.CONTENT_MANAGER, DATE_FORMAT(SEOHOME.FEC_INSERT, '%d/%m/%Y %H:%i') FECHA_INSERT, DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%d/%m/%Y %H:%i') FECHA_MOD, CA.NOMBRE, CA.ID,DATE_FORMAT(SEOHOME.FEC_INSERT, '%Y-%m-%dT%H:%i') IN_GOOGLE, DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%Y-%m-%dT%H:%i') MOD_GOOGLE,AU.ID_ADMIN, GALERIA, GALERIA_DESC, CA.JOB, DATE_FORMAT(SEOHOME.FEC_INSERT, '%d') DAY_INSERT, DATE_FORMAT(SEOHOME.FEC_INSERT, '%m') MONTH_INSERT, DATE_FORMAT(SEOHOME.FEC_INSERT, '%Y') YEAR_INSERT, DATE_FORMAT(SEOHOME.FEC_INSERT, '%H:%i') HORA_INSERT, DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%d') DAY_MOD, DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%m') MONTH_MOD, DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%Y') YEAR_MOD, DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%H:%i') HORA_MOD
            FROM LO_SEO_DESCRIPTIONS_HOME SEOHOME
            LEFT JOIN LO_ADMIN_USERS AU ON AU.LOGIN = SEOHOME.CONTENT_MANAGER
            LEFT JOIN LO_CONTENIDO_AUTORES CA ON CA.ID_ADMIN = AU.ID_ADMIN
                AND CA.ID_TROPIC = 2
            WHERE SEOHOME.ID_TROPIC = 2
                AND SEOHOME.ID_KEY = 'S88'
                AND SEO_VALID in (0,1)
                AND SEOHOME.ID_LOCALIZACION='';

Tiempo de la consulta: 0.0051860809326172

Tiempo acumulado:0.53646278381348

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[211]: SELECT COUNT(*) AS NUMOPINIONES, (SUM(VALORACION) / COUNT(*)) /20 AS VALORACION
            FROM LO_EMPRESAS_OPINIONES OP
            LEFT JOIN LO_RESERVAS_COMPRAS RC ON OP.RESERVA_FEEDBACK = RC.ID_RESERVA_COMPRA
            LEFT JOIN LO_PRECIOS PRE ON RC.ID_PRECIO_RC = PRE.ID_PRECIO
            WHERE PRE.ID_PRECIO = 68319
                AND OP.VALID = 1;

Tiempo de la consulta: 0.00084996223449707

Tiempo acumulado:0.53731274604797

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[212]: SELECT *
            FROM LO_FOTOS
            WHERE ID_PRECIO = 68319
                AND VALID = 1;

Tiempo de la consulta: 0.0007319450378418

Tiempo acumulado:0.53804469108582

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[213]: SELECT *
            FROM LO_FOTOS
            WHERE ID_PRECIO = 68319
                AND FOTO = 'p-68319-joseph-gilbey-tzh6fecrae0-unsplash_1615985547902.jpg'
                AND VALID = 1;

Tiempo de la consulta: 0.00051712989807129

Tiempo acumulado:0.53856182098389

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[214]: SELECT URL_PRE, URL_PRE,TITULO_PRE,DESCRIPCION_PRE,INCLUYE_PRE,ALOJAMIENTO_TEXT_PRE,TRANSPORTE_TEXT_PRE,GALERIA_DESC_PRE,HORARIO_PRE, DURACION_PRE, ID_PRECIO, FK_ID_PAIS_PRE
FROM LO_PRECIOS PRE
WHERE PRE.ID_PRECIO = 68319;

Tiempo de la consulta: 0.00044918060302734

Tiempo acumulado:0.53901100158691

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[215]: SELECT ID_PRECIO_PADRE
            FROM LO_PRECIOS_ASIGNACION PA
            INNER JOIN LO_PRECIOS PRE ON PRE.ID_PRECIO = PA.ID_PRECIO_PADRE
                AND PRE.VALID_PRE = 4
            WHERE PA.ID_PRECIO = 68319;

Tiempo de la consulta: 0.00059390068054199

Tiempo acumulado:0.53960490226746

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[216]: SELECT EXITO
            FROM LO_PRECIOS_EXITO
            WHERE ID_PRECIO = 68319
            LIMIT 1;

Tiempo de la consulta: 0.00097894668579102

Tiempo acumulado:0.54058384895325

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[217]: SELECT COUNT(*) AS TOTAL
            FROM LO_PRECIOS_SECTORES PS
            WHERE PS.ID_ACTIVIDAD_PS NOT IN (100,101)
                AND PS.ID_PRECIO_PS = 68319;

Tiempo de la consulta: 0.00071907043457031

Tiempo acumulado:0.54130291938782

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[218]: SELECT *
            FROM LO_PRECIOS_DIA_ESPECIAL PD
            WHERE PD.ID_PRECIO_DE = 68319
                AND ID_TIPO_DE = 7
                AND VALID = 1;

Tiempo de la consulta: 0.00040411949157715

Tiempo acumulado:0.54170703887939

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[219]: SELECT *
            FROM LO_PRECIOS_DISPONIBILIDAD_CALENDARIO
            WHERE VALID = 1
                AND ID_PRECIO = 68319;

Tiempo de la consulta: 0.00033211708068848

Tiempo acumulado:0.54203915596008

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[220]: SELECT DATE_FORMAT(PRE.FEC_ULT_COMPRA, '%Y-%m-%d') AS FEC_ULT_COMPRA, DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%d') AS DIA_COM, DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%m') AS MES_COM
            FROM LO_PRECIOS PRE
            WHERE ID_PRECIO = 68299
                AND VALID_PRE = 4
            GROUP BY PRE.ID_PRECIO HAVING FEC_ULT_COMPRA IS NOT NULL
            LIMIT 1;

Tiempo de la consulta: 0.00064301490783691

Tiempo acumulado:0.54268217086792

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[221]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
            FROM LO_SEO_KEYWORDS SEO
            WHERE SEO.ID_KEY = ''
                AND SEO.ID_TROPIC = 2
                AND SEO.FK_ID_REG_ADM = 0
                AND 1=1;

Tiempo de la consulta: 0.00050687789916992

Tiempo acumulado:0.54318904876709

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[222]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
            FROM LO_SEO_KEYWORDS SEO
            WHERE SEO.ID_KEY = 'S88'
                AND SEO.ID_TROPIC = 2
                AND SEO.FK_ID_REG_ADM = 0
                AND 1=1;

Tiempo de la consulta: 0.00054001808166504

Tiempo acumulado:0.54372906684875

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[223]: SELECT SEOHOME.DESCRIPTION,SEOHOME.DESCRIPTION2,SEOHOME.HEIGHT, SEOHOME.CONTENT_MANAGER, DATE_FORMAT(SEOHOME.FEC_INSERT, '%d/%m/%Y %H:%i') FECHA_INSERT, DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%d/%m/%Y %H:%i') FECHA_MOD, CA.NOMBRE, CA.ID,DATE_FORMAT(SEOHOME.FEC_INSERT, '%Y-%m-%dT%H:%i') IN_GOOGLE, DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%Y-%m-%dT%H:%i') MOD_GOOGLE,AU.ID_ADMIN, GALERIA, GALERIA_DESC, CA.JOB, DATE_FORMAT(SEOHOME.FEC_INSERT, '%d') DAY_INSERT, DATE_FORMAT(SEOHOME.FEC_INSERT, '%m') MONTH_INSERT, DATE_FORMAT(SEOHOME.FEC_INSERT, '%Y') YEAR_INSERT, DATE_FORMAT(SEOHOME.FEC_INSERT, '%H:%i') HORA_INSERT, DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%d') DAY_MOD, DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%m') MONTH_MOD, DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%Y') YEAR_MOD, DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%H:%i') HORA_MOD
            FROM LO_SEO_DESCRIPTIONS_HOME SEOHOME
            LEFT JOIN LO_ADMIN_USERS AU ON AU.LOGIN = SEOHOME.CONTENT_MANAGER
            LEFT JOIN LO_CONTENIDO_AUTORES CA ON CA.ID_ADMIN = AU.ID_ADMIN
                AND CA.ID_TROPIC = 2
            WHERE SEOHOME.ID_TROPIC = 2
                AND SEOHOME.ID_KEY = 'S88'
                AND SEO_VALID in (0,1)
                AND SEOHOME.ID_LOCALIZACION='';

Tiempo de la consulta: 0.0053861141204834

Tiempo acumulado:0.54911518096924

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[224]: SELECT COUNT(*) AS NUMOPINIONES, (SUM(VALORACION) / COUNT(*)) /20 AS VALORACION
            FROM LO_EMPRESAS_OPINIONES OP
            LEFT JOIN LO_RESERVAS_COMPRAS RC ON OP.RESERVA_FEEDBACK = RC.ID_RESERVA_COMPRA
            LEFT JOIN LO_PRECIOS PRE ON RC.ID_PRECIO_RC = PRE.ID_PRECIO
            WHERE PRE.ID_PRECIO = 68299
                AND OP.VALID = 1;

Tiempo de la consulta: 0.00066494941711426

Tiempo acumulado:0.54978013038635

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[225]: SELECT *
            FROM LO_FOTOS
            WHERE ID_PRECIO = 68299
                AND VALID = 1;

Tiempo de la consulta: 0.0014669895172119

Tiempo acumulado:0.55124711990356

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[226]: SELECT *
            FROM LO_FOTOS
            WHERE ID_PRECIO = 68299
                AND FOTO = 'p-68299-img-0054_16159027601086.jpg'
                AND VALID = 1;

Tiempo de la consulta: 0.00048184394836426

Tiempo acumulado:0.55172896385193

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[227]: SELECT URL_PRE, URL_PRE,TITULO_PRE,DESCRIPCION_PRE,INCLUYE_PRE,ALOJAMIENTO_TEXT_PRE,TRANSPORTE_TEXT_PRE,GALERIA_DESC_PRE,HORARIO_PRE, DURACION_PRE, ID_PRECIO, FK_ID_PAIS_PRE
FROM LO_PRECIOS PRE
WHERE PRE.ID_PRECIO = 68299;

Tiempo de la consulta: 0.00045394897460938

Tiempo acumulado:0.55218291282654

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[228]: SELECT ID_PRECIO_PADRE
            FROM LO_PRECIOS_ASIGNACION PA
            INNER JOIN LO_PRECIOS PRE ON PRE.ID_PRECIO = PA.ID_PRECIO_PADRE
                AND PRE.VALID_PRE = 4
            WHERE PA.ID_PRECIO = 68299;

Tiempo de la consulta: 0.00051212310791016

Tiempo acumulado:0.55269503593445

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[229]: SELECT EXITO
            FROM LO_PRECIOS_EXITO
            WHERE ID_PRECIO = 68299
            LIMIT 1;

Tiempo de la consulta: 0.00039792060852051

Tiempo acumulado:0.55309295654297

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[230]: SELECT COUNT(*) AS TOTAL
            FROM LO_PRECIOS_SECTORES PS
            WHERE PS.ID_ACTIVIDAD_PS NOT IN (100,101)
                AND PS.ID_PRECIO_PS = 68299;

Tiempo de la consulta: 0.00048398971557617

Tiempo acumulado:0.55357694625854

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[231]: SELECT *
            FROM LO_PRECIOS_DIA_ESPECIAL PD
            WHERE PD.ID_PRECIO_DE = 68299
                AND ID_TIPO_DE = 7
                AND VALID = 1;

Tiempo de la consulta: 0.00045013427734375

Tiempo acumulado:0.55402708053589

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[232]: SELECT *
            FROM LO_PRECIOS_DISPONIBILIDAD_CALENDARIO
            WHERE VALID = 1
                AND ID_PRECIO = 68299;

Tiempo de la consulta: 0.00041389465332031

Tiempo acumulado:0.55444097518921

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[233]: SELECT URL, DESCRIPCION,GALERIA_DESC,VIDEOS_TEXT,VIDEOS_DESC,COMO_LLEGAR, EMP.URL, EMP.NOMBRE, ID_EMPRESA
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19743630;

Tiempo de la consulta: 0.00152587890625

Tiempo acumulado:0.55596685409546

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

Tiempo de la consulta: 0.0016191005706787

Tiempo acumulado:0.55758595466614

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[235]: 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 = 'en'
            LEFT JOIN LO_REGION_ADM1_I18N REIA ON REIA.ID_REGION_ADM1 = RE.ID_REGION_ADM1
                AND REIA.IDIOMA = 'en'
                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 = 'en'
            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 = 'en'
            WHERE EMP.ID_EMPRESA = 19743630;

Tiempo de la consulta: 0.00084900856018066

Tiempo acumulado:0.55843496322632

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[236]: 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 = 3144
                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.0008540153503418

Tiempo acumulado:0.55928897857666

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[237]: SELECT N_OFERTAS FROM LO_REGION_STATS PS
            INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PS.ID_REGION
                AND REI.IDIOMA = 'en'
            WHERE (PS.N_OFERTAS > 0 )
                AND PS.ID_REGION = 3144
                AND PS.ID_SECTOR = 88
            GROUP BY PS.ID_REGION;

Tiempo de la consulta: 0.0004889965057373

Tiempo acumulado:0.5597779750824

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[238]: SELECT N_OFERTAS FROM LO_POBLACION_GB_STATS PS
            INNER JOIN LO_POBLACION_GB PO ON PS.ID_POBLACION = PO.ID_POBLACION
                AND PO.ID_REGION = 3144
                AND PO.IDIOMA = 'en'
            INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PO.ID_REGION
                AND REI.IDIOMA = 'en'
            WHERE (PS.N_OFERTAS > 0 )
                AND PO.ID_REGION = 3144
                AND PS.ID_POBLACION = 991695
                AND PS.ID_SECTOR = 88
            GROUP BY PS.ID_POBLACION;

Tiempo de la consulta: 0.00049400329589844

Tiempo acumulado:0.5602719783783

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[239]: 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 = 'en'
            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 = 2
                AND SECI.ID_SECTOR = 88
            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.0028879642486572

Tiempo acumulado:0.56315994262695

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[240]: SELECT TITULO_ENCP, TITULO_ENCR
            FROM LO_ENCUESTAS_RESPUESTAS_EMPRESA ERE
            INNER JOIN LO_ENCUESTAS_PREGUNTAS EP ON ERE.ID_PREGUNTA_ENCRE = EP.ID_PREGUNTA
            INNER JOIN LO_ENCUESTAS_RESPUESTAS ER ON ERE.ID_RESPUESTA_ENCRE = ER.ID_RESPUESTA
            WHERE ERE.ID_RESPUESTA_EMP =19743630;

Tiempo de la consulta: 0.0021960735321045

Tiempo acumulado:0.56535601615906

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[241]: SELECT EE.*, EE.DESCRIPCION, EE.CARGO, EE.IDIOMA AS IDIOMA_EE
            FROM LO_EMPRESAS_EQUIPO EE
            WHERE EE.ID_EMPRESA = 19743630
                AND EE.VALID = 1;

Tiempo de la consulta: 0.0011508464813232

Tiempo acumulado:0.56650686264038

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

Tiempo de la consulta: 0.00079584121704102

Tiempo acumulado:0.56730270385742

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

Tiempo de la consulta: 0.00088810920715332

Tiempo acumulado:0.56819081306458

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

Tiempo de la consulta: 0.001784086227417

Tiempo acumulado:0.56997489929199

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

Tiempo de la consulta: 0.0016410350799561

Tiempo acumulado:0.57161593437195

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

Tiempo de la consulta: 0.0010199546813965

Tiempo acumulado:0.57263588905334

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[247]: 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, DESCRIPCION,GALERIA_DESC,VIDEOS_TEXT,VIDEOS_DESC,COMO_LLEGAR, EMP.URL, EMP.NOMBRE, 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
            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='en'
            INNER JOIN LO_REGION_ADM1 REIAD ON RE.ID_REGION_ADM1 = REIAD.ID_REGION_ADM1
            LEFT JOIN LO_POBLACION_GB PO ON EMP.ID_POBLACION = PO.ID_POBLACION
                AND PO.IDIOMA='en'
            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 = 2
                AND SECI.FK_ID_IDIOMA_SI18N = 'en')
            INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
                AND (GRU.ID_TROPIC = 2)
            WHERE EMP.ID_EMPRESA = 19743630
                AND EMP.VALID IN ('1', '-3')
            LIMIT 1;

Tiempo de la consulta: 0.0014410018920898

Tiempo acumulado:0.57407689094543

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

Tiempo de la consulta: 0.0020091533660889

Tiempo acumulado:0.57608604431152

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

Tiempo de la consulta: 0.001399040222168

Tiempo acumulado:0.57748508453369

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

Tiempo de la consulta: 0.0062718391418457

Tiempo acumulado:0.58375692367554

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[251]: 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 = 'en'
            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='2'
                AND SECI.FK_ID_IDIOMA_SI18N = 'en'
            WHERE REI.ID_REGION = 3144
                AND (PS.N_OFERTAS > 0
                AND PS.N_OFERTAS IS NOT NULL)
            ORDER BY NEMPRESAS DESC;

Tiempo de la consulta: 0.0018000602722168

Tiempo acumulado:0.58555698394775

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

Tiempo de la consulta: 0.00051498413085938

Tiempo acumulado:0.58607196807861

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

Tiempo de la consulta: 0.00062417984008789

Tiempo acumulado:0.5866961479187

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

Tiempo de la consulta: 0.00041699409484863

Tiempo acumulado:0.58711314201355

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[255]: SELECT SEO.KEYWORD
            FROM LO_SEO_KEYWORDS SEO
            WHERE SEO.ID_KEY = 'S55'
                AND (SEO.ID_TROPIC = 2 );

Tiempo de la consulta: 0.00057601928710938

Tiempo acumulado:0.58768916130066

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[256]: SELECT SEO.KEYWORD
            FROM LO_SEO_KEYWORDS SEO
            WHERE SEO.ID_KEY = 'S88'
                AND (SEO.ID_TROPIC = 2 );

Tiempo de la consulta: 0.00042510032653809

Tiempo acumulado:0.5881142616272

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[257]: SELECT SEO.KEYWORD
            FROM LO_SEO_KEYWORDS SEO
            WHERE SEO.ID_KEY = 'S45'
                AND (SEO.ID_TROPIC = 2 );

Tiempo de la consulta: 0.00042390823364258

Tiempo acumulado:0.58853816986084

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[258]: SELECT SEO.KEYWORD
            FROM LO_SEO_KEYWORDS SEO
            WHERE SEO.ID_KEY = 'S11'
                AND (SEO.ID_TROPIC = 2 );

Tiempo de la consulta: 0.00049304962158203

Tiempo acumulado:0.58903121948242

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[259]: SELECT SEO.KEYWORD
            FROM LO_SEO_KEYWORDS SEO
            WHERE SEO.ID_KEY = 'S10'
                AND (SEO.ID_TROPIC = 2 );

Tiempo de la consulta: 0.00040698051452637

Tiempo acumulado:0.58943819999695

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[260]: SELECT SEO.KEYWORD
            FROM LO_SEO_KEYWORDS SEO
            WHERE SEO.ID_KEY = 'S109'
                AND (SEO.ID_TROPIC = 2 );

Tiempo de la consulta: 0.00039100646972656

Tiempo acumulado:0.58982920646667

(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[261]: SELECT SEO.KEYWORD
            FROM LO_SEO_KEYWORDS SEO
            WHERE SEO.ID_KEY = 'S8'
                AND (SEO.ID_TROPIC = 2 );

Tiempo de la consulta: 0.00037217140197754

Tiempo acumulado:0.59020137786865

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

Tiempo de la consulta: 0.0023820400238037

Thames Jet

Offers of Powerboating near London City

Junior Speedboat Tour Tower Millennium Pier 20min

Adult Speedboat Tour Tower Millennium Pier 20min

Open Speedboat Tour for Kids Canary Wharf 45min

Description of Thames Jet

Useful information

Map

Related activities

Information

YUMPING TRUST

Download the app

Payment methods

1260 reviews on