Yumping信任

下载应用程序

关注我们

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

prod.yumping.com

/landings/landing.php

BBDD->Prod_Yumping_pt_PT
AMBITO->pt_ch
AMBITO_AJAX->pt_ch
AMBITO_AJAX COOKIE->es_en
locale LO_CONFIG->cn_PT
locale php->cn_PT
getActiveCurrency->GBP
currencyConversionActiveValueDefault->
Fuente tráfico->0

SESSION VARS

DEFINED VARS

$tpage->

Cache VARS

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

SERVER VARS

HTTP_REFERER

Request VARS

ambito_lang->zh-hans
filtro1->re-qi-qiu-fei-xing
filtro2->fa-lu
filtro3->alvor
rel_alternate->1
paginado_ofertas->
npage->

Total queries: 319

Tiempo total: 1.0181708335876

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

Tiempo de la consulta: 0.020379066467285

Tiempo acumulado:0.020379066467285

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

Tiempo acumulado:0.021503925323486

(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[3]: SELECT ID_PAIS, IS_PROVINCIA, IS_REGION
            FROM ( SELECT RE.ID_PAIS, 1 AS IS_PROVINCIA, 0 AS IS_REGION
            FROM Prod_Yumping_es_ES.LO_REGION_I18N REI
            INNER JOIN Prod_Yumping_es_ES.LO_REGION RE ON RE.ID_REGION = REI.ID_REGION
            WHERE REI.URL = 'fa-lu' UNION ALL SELECT RE.ID_PAIS, 0 AS IS_PROVINCIA, 1 AS IS_REGION
            FROM Prod_Yumping_es_ES.LO_REGION_ADM1_I18N REI
            INNER JOIN Prod_Yumping_es_ES.LO_REGION_ADM1 RE ON RE.ID_REGION_ADM1 = REI.ID_REGION_ADM1
            WHERE REI.URL = 'fa-lu' UNION ALL SELECT RE.ID_PAIS, 1 AS IS_PROVINCIA, 0 AS IS_REGION
            FROM Prod_Yumping_pt_PT.LO_REGION_I18N REI
            INNER JOIN Prod_Yumping_pt_PT.LO_REGION RE ON RE.ID_REGION = REI.ID_REGION
            WHERE REI.URL = 'fa-lu' UNION ALL SELECT RE.ID_PAIS, 0 AS IS_PROVINCIA, 1 AS IS_REGION
            FROM Prod_Yumping_pt_PT.LO_REGION_ADM1_I18N REI
            INNER JOIN Prod_Yumping_pt_PT.LO_REGION_ADM1 RE ON RE.ID_REGION_ADM1 = REI.ID_REGION_ADM1
            WHERE REI.URL = 'fa-lu' UNION ALL SELECT RE.ID_PAIS, 1 AS IS_PROVINCIA, 0 AS IS_REGION
            FROM Prod_Yumping_it_IT.LO_REGION_I18N REI
            INNER JOIN Prod_Yumping_it_IT.LO_REGION RE ON RE.ID_REGION = REI.ID_REGION
            WHERE REI.URL = 'fa-lu' UNION ALL SELECT RE.ID_PAIS, 0 AS IS_PROVINCIA, 1 AS IS_REGION
            FROM Prod_Yumping_it_IT.LO_REGION_ADM1_I18N REI
            INNER JOIN Prod_Yumping_it_IT.LO_REGION_ADM1 RE ON RE.ID_REGION_ADM1 = REI.ID_REGION_ADM1
            WHERE REI.URL = 'fa-lu' UNION ALL SELECT RE.ID_PAIS, 1 AS IS_PROVINCIA, 0 AS IS_REGION
            FROM Prod_Yumping_fr_FR.LO_REGION_I18N REI
            INNER JOIN Prod_Yumping_fr_FR.LO_REGION RE ON RE.ID_REGION = REI.ID_REGION
            WHERE REI.URL = 'fa-lu' UNION ALL SELECT RE.ID_PAIS, 0 AS IS_PROVINCIA, 1 AS IS_REGION
            FROM Prod_Yumping_fr_FR.LO_REGION_ADM1_I18N REI
            INNER JOIN Prod_Yumping_fr_FR.LO_REGION_ADM1 RE ON RE.ID_REGION_ADM1 = REI.ID_REGION_ADM1
            WHERE REI.URL = 'fa-lu' UNION ALL SELECT RE.ID_PAIS, 1 AS IS_PROVINCIA, 0 AS IS_REGION
            FROM Prod_Yumping_co_UK.LO_REGION_I18N REI
            INNER JOIN Prod_Yumping_co_UK.LO_REGION RE ON RE.ID_REGION = REI.ID_REGION
            WHERE REI.URL = 'fa-lu' UNION ALL SELECT RE.ID_PAIS, 0 AS IS_PROVINCIA, 1 AS IS_REGION
            FROM Prod_Yumping_co_UK.LO_REGION_ADM1_I18N REI
            INNER JOIN Prod_Yumping_co_UK.LO_REGION_ADM1 RE ON RE.ID_REGION_ADM1 = REI.ID_REGION_ADM1
            WHERE REI.URL = 'fa-lu' UNION ALL SELECT RE.ID_PAIS, 1 AS IS_PROVINCIA, 0 AS IS_REGION
            FROM Prod_Yumping_mx_MX.LO_REGION_I18N REI
            INNER JOIN Prod_Yumping_mx_MX.LO_REGION RE ON RE.ID_REGION = REI.ID_REGION
            WHERE REI.URL = 'fa-lu' UNION ALL SELECT RE.ID_PAIS, 0 AS IS_PROVINCIA, 1 AS IS_REGION
            FROM Prod_Yumping_mx_MX.LO_REGION_ADM1_I18N REI
            INNER JOIN Prod_Yumping_mx_MX.LO_REGION_ADM1 RE ON RE.ID_REGION_ADM1 = REI.ID_REGION_ADM1
            WHERE REI.URL = 'fa-lu' )AS FIND_REGION
            GROUP BY ID_PAIS;

Tiempo de la consulta: 0.021358013153076

Tiempo acumulado:0.042861938476562

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

Tiempo de la consulta: 0.045370101928711

Tiempo acumulado:0.088232040405273

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

Tiempo de la consulta: 0.00098705291748047

Tiempo acumulado:0.089219093322754

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

Tiempo de la consulta: 0.00061297416687012

Tiempo acumulado:0.089832067489624

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

Tiempo de la consulta: 0.00052094459533691

Tiempo acumulado:0.090353012084961

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

Tiempo de la consulta: 0.0035009384155273

Tiempo acumulado:0.093853950500488

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

Tiempo de la consulta: 0.0016348361968994

Tiempo acumulado:0.095488786697388

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[10]: SELECT G.DESC_GRUPO, G.ID_GRUPO, G.URL AS URL_GRUPO
            FROM LO_GRUPOS G
            WHERE G.URL = 're-qi-qiu-fei-xing'
                AND G.ID_TROPIC = 86;

Tiempo de la consulta: 0.00054502487182617

Tiempo acumulado:0.096033811569214

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

Tiempo de la consulta: 0.0062439441680908

Tiempo acumulado:0.1022777557373

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

Tiempo de la consulta: 0.0017969608306885

Tiempo acumulado:0.10407471656799

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[13]: SELECT '2', RE.ID_REGION, REI.DESC_REGION, REI.URL URL_REGION, RE.ID_REGION_ADM1, RE.ID_PAIS, LATITUDE, LONGITUDE
            FROM LO_REGION_I18N REI
            INNER JOIN LO_REGION RE ON REI.ID_REGION=RE.ID_REGION
                AND URL = 'fa-lu'
                AND IDIOMA = 'ch'
            LIMIT 1;

Tiempo de la consulta: 0.00061511993408203

Tiempo acumulado:0.10468983650208

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[14]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
            FROM LO_SECTORES_I18N SECI
            INNER JOIN LO_SECTORES SEC ON SECI.ID_SECTOR=SEC.ID_SECTOR
            WHERE SECI.URL = 're-qi-qiu-fei-xing'
                AND ID_TROPIC = 86
                AND SECI.FK_ID_IDIOMA_SI18N = 'ch'
            LIMIT 1;

Tiempo de la consulta: 0.0013740062713623

Tiempo acumulado:0.10606384277344

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[15]: SELECT DESC_POBLACION,ID_POBLACION,URL_POBLACION
            FROM LO_POBLACION_PT PO
            WHERE ID_REGION='756'
                AND ID_POBLACION='alvor'
                AND IDIOMA = 'ch'
            LIMIT 1;

Tiempo de la consulta: 0.0044119358062744

Tiempo acumulado:0.11047577857971

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[16]: SELECT DESC_POBLACION,ID_POBLACION,URL_POBLACION
            FROM LO_POBLACION_PT PO
            WHERE ID_REGION='756'
                AND URL_POBLACION='alvor'
                AND IDIOMA = 'ch'
            LIMIT 1;

Tiempo de la consulta: 0.015773057937622

Tiempo acumulado:0.12624883651733

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[17]: SELECT ORDER_LANDING
FROM LO_SECTORES SEC
WHERE ID_SECTOR = 19;

Tiempo de la consulta: 0.0038809776306152

Tiempo acumulado:0.13012981414795

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[18]: SELECT GRU.URL URL_GRUPO, GRU.DESC_GRUPO, ID_GRUPO
            FROM LO_GRUPOS GRU
            WHERE GRU.ID_GRUPO = 2
                AND (GRU.ID_TROPIC = 86);

Tiempo de la consulta: 0.0057449340820312

Tiempo acumulado:0.13587474822998

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[19]: SELECT *
            FROM LO_SEO_KEYWORDS_LANDING SKL
            WHERE SKL.ID_SECTOR = 19
                AND ID_TROPIC = 86;

Tiempo de la consulta: 0.00063395500183105

Tiempo acumulado:0.13650870323181

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[20]: SELECT DESC_POBLACION,ID_POBLACION,URL_POBLACION
            FROM LO_POBLACION_PT PO
            WHERE ID_REGION='756'
                AND ID_POBLACION='70060'
                AND IDIOMA = 'ch'
            LIMIT 1;

Tiempo de la consulta: 0.0078189373016357

Tiempo acumulado:0.14432764053345

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[21]: SELECT *
            FROM LO_REGION_SKI REI
            WHERE URL = 'fa-lu'
                AND REI.IDIOMA='ch'
                AND TIPO = 1;

Tiempo de la consulta: 0.0085511207580566

Tiempo acumulado:0.1528787612915

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[22]: SELECT REIA.ID_REGION_ADM1
            FROM LO_REGION RE
            INNER JOIN LO_REGION_ADM1_I18N REIA ON REIA.ID_REGION_ADM1 = RE.ID_REGION_ADM1
            WHERE RE.ID_REGION = 756
            LIMIT 1;

Tiempo de la consulta: 0.0016489028930664

Tiempo acumulado:0.15452766418457

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[23]: SELECT SQL_CALC_FOUND_ROWS ID_EMPRESA
            FROM LO_EMPRESAS EMP
            INNER JOIN LO_REGION RE ON RE.ID_REGION = EMP.ID_PROVINCIA
            LEFT JOIN LO_POBLACION PO ON PO.ID_POBLACION = EMP.ID_POBLACION
            INNER JOIN LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
            INNER JOIN LO_EMPRESAS_STAT EMPS ON EMPS.FK_ID_EST = EMP.ID_EMPRESA
            INNER JOIN LO_EMPRESAS_TRADUCCION_CH ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
                AND ET.IDIOMA_ET = 'ch'
            WHERE EMP.VALID IN (1)
                AND RE.ID_REGION = 756
                AND EMP.EMP_MADRE <> 0
                AND PO.ID_POBLACION = 70060
                AND EMP.ID_SECTOR = 19
            GROUP BY EMP.NOMBRE HAVING ID_EMPRESA IN (SELECT /*IF (EMP.EMP_MADRE = 3, ID_MADRE,*/ ID_EMPRESA AS ID_P
            FROM LO_EMPRESAS EMP
            WHERE EMP.ID_PROVINCIA = 756)
            ORDER BY IF(N_PRECIOS_EST > 0 , 1 ,0) DESC, N_VENTAS_EST DESC,N_ORDER_TSP_EST DESC
            LIMIT 0,12;

Tiempo de la consulta: 0.0064342021942139

Tiempo acumulado:0.16096186637878

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[24]: SELECT FOUND_ROWS() NEMPRESAS;

Tiempo de la consulta: 0.004133939743042

Tiempo acumulado:0.16509580612183

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[25]: SELECT N_OFERTAS AS NumOfertas, N_EMPRESAS AS TOTAL_EMPRESAS, PRECIO_MIN, IF ( MEDIA_AJUSTADA IS NOT NULL
                AND MEDIA_AJUSTADA != 0
                AND MEDIA_AJUSTADA < MEDIA_PRECIO, MEDIA_AJUSTADA, MEDIA_PRECIO ) AS MEDIA
            FROM LO_POBLACION_PT_STATS
            WHERE ID_POBLACION = 70060
                AND ID_SECTOR = 19
            GROUP BY ID_SECTOR;

Tiempo de la consulta: 0.0068609714508057

Tiempo acumulado:0.17195677757263

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[26]: SELECT SS.*,PSS.*, SSF.*, PRE.*, EMP.*, PP.*, PPO.*, COUNT(*) AS TOTAL
            FROM LO_SUBSECTORES SS
            INNER JOIN LO_PRECIOS_SUBSECTORES PSS ON SS.ID_SUBSECTOR = PSS.ID_ACTIVIDAD_PSS
            INNER JOIN LO_SUBSECTORES_FAM SSF ON SS.ID_FAM_SS=SSF.ID_SSF
                AND SSF.ID_TROPIC = 86
            INNER JOIN LO_PRECIOS PRE ON PSS.ID_PRECIO_PSS=PRE.ID_PRECIO
            INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
            LEFT JOIN LO_PRECIOS_PUBLI PP ON PP.ID_PRECIO_PP = PRE.ID_PRECIO
            LEFT JOIN LO_PRECIOS_POBLACIONES PPO ON PPO.ID_PRECIO = PRE.ID_PRECIO
            INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'ch'
            WHERE SS.ID_TROPIC = 86
                AND VALID_PRE=4
                AND ID_SECTOR_SS = '19'
                AND (PRE.ID_POBLACION_PRE = 70060 OR ID_POBLACION_PP = 70060 )
            GROUP BY SS.ID_SUBSECTOR
            ORDER BY SS.ID_FAM_SS DESC,SS.ID_SUBFAM_SS DESC,PRINCIPAL_SS DESC,COUNT(*) DESC;

Tiempo de la consulta: 0.014124155044556

Tiempo acumulado:0.18608093261719

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[27]: SELECT SEO.DESCRIPTION
            FROM LO_SEO_DESCRIPTIONS SEO
            WHERE SEO.ID_TROPIC='86'
                AND SEO.ID_KEY='S19';

Tiempo de la consulta: 0.0094139575958252

Tiempo acumulado:0.19549489021301

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[28]: 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 = 86
            WHERE SEOHOME.ID_TROPIC = 86
                AND SEOHOME.ID_KEY = 'S19'
                AND SEO_VALID in (0,1)
                AND SEOHOME.ID_LOCALIZACION='70060';

Tiempo de la consulta: 0.016563892364502

Tiempo acumulado:0.21205878257751

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

Tiempo de la consulta: 0.0026788711547852

Tiempo acumulado:0.2147376537323

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[30]: SELECT URL_POBLACION, ID_POBLACION
            FROM LO_POBLACION_PT PO
            WHERE PO.ID_POBLACION = 70060
                AND PO.IDIOMA = 'pt';

Tiempo de la consulta: 0.010697841644287

Tiempo acumulado:0.22543549537659

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[31]: SELECT OLD_URL, NEW_URL
FROM LO_URL_301 U
WHERE U.OLD_URL = '/zh-hans/re-qi-qiu-fei-xing/fa-lu/alvor';

Tiempo de la consulta: 0.0006411075592041

Tiempo acumulado:0.22607660293579

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[32]: SELECT *
            FROM LO_SEO_DESCRIPTIONS_HOME SEO
            WHERE SEO.ID_TROPIC='86'
                AND SEO.ID_KEY='S19'
                AND SEO.ID_LOCALIZACION='70060';

Tiempo de la consulta: 0.021841049194336

Tiempo acumulado:0.24791765213013

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[33]: SELECT TITLE, DESCRIPTION, KEYWORDS, ID_KEY
            FROM LO_SEO_HEADERS SEO
            WHERE SEO.ID_TROPIC='86'
                AND VALID='1'
                AND SEO.ID_KEY='S19';

Tiempo de la consulta: 0.015997171401978

Tiempo acumulado:0.2639148235321

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[34]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
            FROM LO_SECTORES_I18N SECI
            INNER JOIN LO_SECTORES SEC ON SECI.ID_SECTOR=SEC.ID_SECTOR
            WHERE SECI.URL = 're-qi-qiu-fei-xing'
                AND ID_TROPIC = 86
                AND SECI.FK_ID_IDIOMA_SI18N = 'ch'
            LIMIT 1;

Tiempo de la consulta: 0.010756015777588

Tiempo acumulado:0.27467083930969

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

Tiempo de la consulta: 0.003242015838623

Tiempo acumulado:0.27791285514832

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

Tiempo de la consulta: 0.0031819343566895

Tiempo acumulado:0.281094789505

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

Tiempo de la consulta: 0.0018699169158936

Tiempo acumulado:0.2829647064209

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[38]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
            FROM Prod_Yumping_pt_PT.LO_SECTORES SEC
            INNER JOIN Prod_Yumping_pt_PT.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
            WHERE SEC.ID_SECTOR=19
                AND SECI.FK_ID_IDIOMA_SI18N = 'pt'
                AND SECI.ID_TROPIC=8;

Tiempo de la consulta: 0.016803026199341

Tiempo acumulado:0.29976773262024

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

Tiempo de la consulta: 0.00063085556030273

Tiempo acumulado:0.30039858818054

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

Tiempo de la consulta: 0.00148606300354

Tiempo acumulado:0.30188465118408

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[41]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
            FROM LO_REGION RE, LO_REGION_I18N REI
            WHERE REI.URL = 'fa-lu'
                AND REI.ID_REGION = RE.ID_REGION
                AND REI.IDIOMA = 'ch';

Tiempo de la consulta: 0.00049614906311035

Tiempo acumulado:0.30238080024719

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

Tiempo de la consulta: 0.00097298622131348

Tiempo acumulado:0.30335378646851

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

Tiempo de la consulta: 0.00064706802368164

Tiempo acumulado:0.30400085449219

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

Tiempo de la consulta: 0.0018668174743652

Tiempo acumulado:0.30586767196655

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[45]: SELECT RE.ID_REGION, REI.DESC_REGION,REI.URL URL_REGION
            FROM Prod_Yumping_pt_PT.LO_REGION RE, Prod_Yumping_pt_PT.LO_REGION_I18N REI
            WHERE RE.ID_REGION=756
                AND RE.ID_REGION = REI.ID_REGION
                AND REI.IDIOMA = 'pt';

Tiempo de la consulta: 0.00063300132751465

Tiempo acumulado:0.30650067329407

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

Tiempo de la consulta: 0.00062108039855957

Tiempo acumulado:0.30712175369263

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

Tiempo de la consulta: 0.0048460960388184

Tiempo acumulado:0.31196784973145

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[48]: SELECT PO.ID_POBLACION_PADRE AS ID_POBLACION_PADRE,POI.DESC_POBLACION, POI.URL_POBLACION
            FROM LO_POBLACION PO, LO_POBLACION_PT POI
            WHERE POI.URL_POBLACION='alvor'
                AND POI.ID_REGION='756'
                AND IDIOMA = 'ch'
                AND POI.ID_POBLACION=PO.ID_POBLACION
            ORDER BY PO.ID_POBLACION;

Tiempo de la consulta: 0.0013539791107178

Tiempo acumulado:0.31332182884216

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

Tiempo de la consulta: 0.00055980682373047

Tiempo acumulado:0.31388163566589

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

Tiempo de la consulta: 0.00055599212646484

Tiempo acumulado:0.31443762779236

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

Tiempo de la consulta: 0.0054481029510498

Tiempo acumulado:0.31988573074341

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[52]: SELECT POI.ID_POBLACION, POI.DESC_POBLACION, POI.URL_POBLACION
            FROM Prod_Yumping_pt_PT.LO_POBLACION PO, Prod_Yumping_pt_PT.LO_POBLACION_PT POI
            WHERE PO.ID_POBLACION = POI.ID_POBLACION
                AND PO.ID_POBLACION=70060
                AND POI.IDIOMA = 'pt';

Tiempo de la consulta: 0.0039329528808594

Tiempo acumulado:0.32381868362427

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[53]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
            FROM LO_SECTORES_I18N SECI
            INNER JOIN LO_SECTORES SEC ON SECI.ID_SECTOR=SEC.ID_SECTOR
            WHERE SECI.URL = 're-qi-qiu-fei-xing'
                AND ID_TROPIC = 86
                AND SECI.FK_ID_IDIOMA_SI18N = 'ch'
            LIMIT 1;

Tiempo de la consulta: 0.00098299980163574

Tiempo acumulado:0.3248016834259

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

Tiempo de la consulta: 0.00092101097106934

Tiempo acumulado:0.32572269439697

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

Tiempo de la consulta: 0.00078797340393066

Tiempo acumulado:0.3265106678009

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

Tiempo de la consulta: 0.0010528564453125

Tiempo acumulado:0.32756352424622

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[57]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
            FROM Prod_Yumping_pt_PT.LO_SECTORES SEC
            INNER JOIN Prod_Yumping_pt_PT.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
            WHERE SEC.ID_SECTOR=19
                AND SECI.FK_ID_IDIOMA_SI18N = 'en'
                AND SECI.ID_TROPIC=82;

Tiempo de la consulta: 0.010209798812866

Tiempo acumulado:0.33777332305908

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

Tiempo de la consulta: 0.0080370903015137

Tiempo acumulado:0.3458104133606

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

Tiempo de la consulta: 0.0012431144714355

Tiempo acumulado:0.34705352783203

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[60]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
            FROM LO_REGION RE, LO_REGION_I18N REI
            WHERE REI.URL = 'fa-lu'
                AND REI.ID_REGION = RE.ID_REGION
                AND REI.IDIOMA = 'ch';

Tiempo de la consulta: 0.0039658546447754

Tiempo acumulado:0.35101938247681

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

Tiempo de la consulta: 0.00054717063903809

Tiempo acumulado:0.35156655311584

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

Tiempo de la consulta: 0.0006558895111084

Tiempo acumulado:0.35222244262695

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

Tiempo de la consulta: 0.0034589767456055

Tiempo acumulado:0.35568141937256

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[64]: SELECT RE.ID_REGION, REI.DESC_REGION,REI.URL URL_REGION
            FROM Prod_Yumping_pt_PT.LO_REGION RE, Prod_Yumping_pt_PT.LO_REGION_I18N REI
            WHERE RE.ID_REGION=756
                AND RE.ID_REGION = REI.ID_REGION
                AND REI.IDIOMA = 'en';

Tiempo de la consulta: 0.00042819976806641

Tiempo acumulado:0.35610961914062

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

Tiempo de la consulta: 0.0037198066711426

Tiempo acumulado:0.35982942581177

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

Tiempo de la consulta: 0.0007789134979248

Tiempo acumulado:0.36060833930969

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[67]: SELECT PO.ID_POBLACION_PADRE AS ID_POBLACION_PADRE,POI.DESC_POBLACION, POI.URL_POBLACION
            FROM LO_POBLACION PO, LO_POBLACION_PT POI
            WHERE POI.URL_POBLACION='alvor'
                AND POI.ID_REGION='756'
                AND IDIOMA = 'ch'
                AND POI.ID_POBLACION=PO.ID_POBLACION
            ORDER BY PO.ID_POBLACION;

Tiempo de la consulta: 0.0049550533294678

Tiempo acumulado:0.36556339263916

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

Tiempo de la consulta: 0.0012130737304688

Tiempo acumulado:0.36677646636963

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

Tiempo de la consulta: 0.001129150390625

Tiempo acumulado:0.36790561676025

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

Tiempo de la consulta: 0.0016047954559326

Tiempo acumulado:0.36951041221619

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[71]: SELECT POI.ID_POBLACION, POI.DESC_POBLACION, POI.URL_POBLACION
            FROM Prod_Yumping_pt_PT.LO_POBLACION PO, Prod_Yumping_pt_PT.LO_POBLACION_PT POI
            WHERE PO.ID_POBLACION = POI.ID_POBLACION
                AND PO.ID_POBLACION=70060
                AND POI.IDIOMA = 'en';

Tiempo de la consulta: 0.0034551620483398

Tiempo acumulado:0.37296557426453

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[72]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
            FROM LO_SECTORES_I18N SECI
            INNER JOIN LO_SECTORES SEC ON SECI.ID_SECTOR=SEC.ID_SECTOR
            WHERE SECI.URL = 're-qi-qiu-fei-xing'
                AND ID_TROPIC = 86
                AND SECI.FK_ID_IDIOMA_SI18N = 'ch'
            LIMIT 1;

Tiempo de la consulta: 0.0014579296112061

Tiempo acumulado:0.37442350387573

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

Tiempo de la consulta: 0.0010619163513184

Tiempo acumulado:0.37548542022705

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

Tiempo de la consulta: 0.0027811527252197

Tiempo acumulado:0.37826657295227

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

Tiempo de la consulta: 0.00095796585083008

Tiempo acumulado:0.3792245388031

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[76]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
            FROM Prod_Yumping_pt_PT.LO_SECTORES SEC
            INNER JOIN Prod_Yumping_pt_PT.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
            WHERE SEC.ID_SECTOR=19
                AND SECI.FK_ID_IDIOMA_SI18N = 'it'
                AND SECI.ID_TROPIC=83;

Tiempo de la consulta: 0.0010600090026855

Tiempo acumulado:0.38028454780579

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

Tiempo de la consulta: 0.0012190341949463

Tiempo acumulado:0.38150358200073

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

Tiempo de la consulta: 0.0029990673065186

Tiempo acumulado:0.38450264930725

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[79]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
            FROM LO_REGION RE, LO_REGION_I18N REI
            WHERE REI.URL = 'fa-lu'
                AND REI.ID_REGION = RE.ID_REGION
                AND REI.IDIOMA = 'ch';

Tiempo de la consulta: 0.003471851348877

Tiempo acumulado:0.38797450065613

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

Tiempo de la consulta: 0.0053038597106934

Tiempo acumulado:0.39327836036682

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

Tiempo de la consulta: 0.00063085556030273

Tiempo acumulado:0.39390921592712

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

Tiempo de la consulta: 0.00061583518981934

Tiempo acumulado:0.39452505111694

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[83]: SELECT RE.ID_REGION, REI.DESC_REGION,REI.URL URL_REGION
            FROM Prod_Yumping_pt_PT.LO_REGION RE, Prod_Yumping_pt_PT.LO_REGION_I18N REI
            WHERE RE.ID_REGION=756
                AND RE.ID_REGION = REI.ID_REGION
                AND REI.IDIOMA = 'it';

Tiempo de la consulta: 0.00084400177001953

Tiempo acumulado:0.39536905288696

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

Tiempo de la consulta: 0.0060849189758301

Tiempo acumulado:0.40145397186279

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

Tiempo de la consulta: 0.0006260871887207

Tiempo acumulado:0.40208005905151

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[86]: SELECT PO.ID_POBLACION_PADRE AS ID_POBLACION_PADRE,POI.DESC_POBLACION, POI.URL_POBLACION
            FROM LO_POBLACION PO, LO_POBLACION_PT POI
            WHERE POI.URL_POBLACION='alvor'
                AND POI.ID_REGION='756'
                AND IDIOMA = 'ch'
                AND POI.ID_POBLACION=PO.ID_POBLACION
            ORDER BY PO.ID_POBLACION;

Tiempo de la consulta: 0.003978967666626

Tiempo acumulado:0.40605902671814

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

Tiempo de la consulta: 0.00054216384887695

Tiempo acumulado:0.40660119056702

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

Tiempo de la consulta: 0.002269983291626

Tiempo acumulado:0.40887117385864

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

Tiempo de la consulta: 0.00055503845214844

Tiempo acumulado:0.40942621231079

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[90]: SELECT POI.ID_POBLACION, POI.DESC_POBLACION, POI.URL_POBLACION
            FROM Prod_Yumping_pt_PT.LO_POBLACION PO, Prod_Yumping_pt_PT.LO_POBLACION_PT POI
            WHERE PO.ID_POBLACION = POI.ID_POBLACION
                AND PO.ID_POBLACION=70060
                AND POI.IDIOMA = 'it';

Tiempo de la consulta: 0.00097322463989258

Tiempo acumulado:0.41039943695068

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[91]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
            FROM LO_SECTORES_I18N SECI
            INNER JOIN LO_SECTORES SEC ON SECI.ID_SECTOR=SEC.ID_SECTOR
            WHERE SECI.URL = 're-qi-qiu-fei-xing'
                AND ID_TROPIC = 86
                AND SECI.FK_ID_IDIOMA_SI18N = 'ch'
            LIMIT 1;

Tiempo de la consulta: 0.0020880699157715

Tiempo acumulado:0.41248750686646

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

Tiempo de la consulta: 0.0081541538238525

Tiempo acumulado:0.42064166069031

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

Tiempo de la consulta: 0.0006558895111084

Tiempo acumulado:0.42129755020142

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

Tiempo de la consulta: 0.00064206123352051

Tiempo acumulado:0.42193961143494

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[95]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
            FROM Prod_Yumping_pt_PT.LO_SECTORES SEC
            INNER JOIN Prod_Yumping_pt_PT.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
            WHERE SEC.ID_SECTOR=19
                AND SECI.FK_ID_IDIOMA_SI18N = 'fr'
                AND SECI.ID_TROPIC=84;

Tiempo de la consulta: 0.00099992752075195

Tiempo acumulado:0.42293953895569

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

Tiempo de la consulta: 0.00079107284545898

Tiempo acumulado:0.42373061180115

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

Tiempo de la consulta: 0.0019991397857666

Tiempo acumulado:0.42572975158691

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[98]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
            FROM LO_REGION RE, LO_REGION_I18N REI
            WHERE REI.URL = 'fa-lu'
                AND REI.ID_REGION = RE.ID_REGION
                AND REI.IDIOMA = 'ch';

Tiempo de la consulta: 0.0006248950958252

Tiempo acumulado:0.42635464668274

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

Tiempo de la consulta: 0.001230001449585

Tiempo acumulado:0.42758464813232

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

Tiempo de la consulta: 0.0029339790344238

Tiempo acumulado:0.43051862716675

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

Tiempo de la consulta: 0.00064301490783691

Tiempo acumulado:0.43116164207458

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[102]: SELECT RE.ID_REGION, REI.DESC_REGION,REI.URL URL_REGION
            FROM Prod_Yumping_pt_PT.LO_REGION RE, Prod_Yumping_pt_PT.LO_REGION_I18N REI
            WHERE RE.ID_REGION=756
                AND RE.ID_REGION = REI.ID_REGION
                AND REI.IDIOMA = 'fr';

Tiempo de la consulta: 0.0011439323425293

Tiempo acumulado:0.43230557441711

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

Tiempo de la consulta: 0.002877950668335

Tiempo acumulado:0.43518352508545

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

Tiempo de la consulta: 0.00059914588928223

Tiempo acumulado:0.43578267097473

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[105]: SELECT PO.ID_POBLACION_PADRE AS ID_POBLACION_PADRE,POI.DESC_POBLACION, POI.URL_POBLACION
            FROM LO_POBLACION PO, LO_POBLACION_PT POI
            WHERE POI.URL_POBLACION='alvor'
                AND POI.ID_REGION='756'
                AND IDIOMA = 'ch'
                AND POI.ID_POBLACION=PO.ID_POBLACION
            ORDER BY PO.ID_POBLACION;

Tiempo de la consulta: 0.00070714950561523

Tiempo acumulado:0.43648982048035

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

Tiempo de la consulta: 0.0017099380493164

Tiempo acumulado:0.43819975852966

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

Tiempo de la consulta: 0.00056600570678711

Tiempo acumulado:0.43876576423645

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

Tiempo de la consulta: 0.0032448768615723

Tiempo acumulado:0.44201064109802

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[109]: SELECT POI.ID_POBLACION, POI.DESC_POBLACION, POI.URL_POBLACION
            FROM Prod_Yumping_pt_PT.LO_POBLACION PO, Prod_Yumping_pt_PT.LO_POBLACION_PT POI
            WHERE PO.ID_POBLACION = POI.ID_POBLACION
                AND PO.ID_POBLACION=70060
                AND POI.IDIOMA = 'fr';

Tiempo de la consulta: 0.00070095062255859

Tiempo acumulado:0.44271159172058

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[110]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
            FROM LO_SECTORES_I18N SECI
            INNER JOIN LO_SECTORES SEC ON SECI.ID_SECTOR=SEC.ID_SECTOR
            WHERE SECI.URL = 're-qi-qiu-fei-xing'
                AND ID_TROPIC = 86
                AND SECI.FK_ID_IDIOMA_SI18N = 'ch'
            LIMIT 1;

Tiempo de la consulta: 0.0007169246673584

Tiempo acumulado:0.44342851638794

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

Tiempo de la consulta: 0.00097084045410156

Tiempo acumulado:0.44439935684204

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

Tiempo de la consulta: 0.0010960102081299

Tiempo acumulado:0.44549536705017

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

Tiempo de la consulta: 0.0010139942169189

Tiempo acumulado:0.44650936126709

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[114]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
            FROM Prod_Yumping_pt_PT.LO_SECTORES SEC
            INNER JOIN Prod_Yumping_pt_PT.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
            WHERE SEC.ID_SECTOR=19
                AND SECI.FK_ID_IDIOMA_SI18N = 'es'
                AND SECI.ID_TROPIC=81;

Tiempo de la consulta: 0.0006101131439209

Tiempo acumulado:0.44711947441101

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

Tiempo de la consulta: 0.00091409683227539

Tiempo acumulado:0.44803357124329

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

Tiempo de la consulta: 0.00082111358642578

Tiempo acumulado:0.44885468482971

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[117]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
            FROM LO_REGION RE, LO_REGION_I18N REI
            WHERE REI.URL = 'fa-lu'
                AND REI.ID_REGION = RE.ID_REGION
                AND REI.IDIOMA = 'ch';

Tiempo de la consulta: 0.00047612190246582

Tiempo acumulado:0.44933080673218

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

Tiempo de la consulta: 0.00053501129150391

Tiempo acumulado:0.44986581802368

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

Tiempo de la consulta: 0.0096981525421143

Tiempo acumulado:0.4595639705658

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

Tiempo de la consulta: 0.00065803527832031

Tiempo acumulado:0.46022200584412

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[121]: SELECT RE.ID_REGION, REI.DESC_REGION,REI.URL URL_REGION
            FROM Prod_Yumping_pt_PT.LO_REGION RE, Prod_Yumping_pt_PT.LO_REGION_I18N REI
            WHERE RE.ID_REGION=756
                AND RE.ID_REGION = REI.ID_REGION
                AND REI.IDIOMA = 'es';

Tiempo de la consulta: 0.00048995018005371

Tiempo acumulado:0.46071195602417

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

Tiempo de la consulta: 0.00078892707824707

Tiempo acumulado:0.46150088310242

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

Tiempo de la consulta: 0.0045080184936523

Tiempo acumulado:0.46600890159607

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[124]: SELECT PO.ID_POBLACION_PADRE AS ID_POBLACION_PADRE,POI.DESC_POBLACION, POI.URL_POBLACION
            FROM LO_POBLACION PO, LO_POBLACION_PT POI
            WHERE POI.URL_POBLACION='alvor'
                AND POI.ID_REGION='756'
                AND IDIOMA = 'ch'
                AND POI.ID_POBLACION=PO.ID_POBLACION
            ORDER BY PO.ID_POBLACION;

Tiempo de la consulta: 0.00077581405639648

Tiempo acumulado:0.46678471565247

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

Tiempo de la consulta: 0.005734920501709

Tiempo acumulado:0.47251963615417

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

Tiempo de la consulta: 0.0017099380493164

Tiempo acumulado:0.47422957420349

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

Tiempo de la consulta: 0.0011570453643799

Tiempo acumulado:0.47538661956787

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[128]: SELECT POI.ID_POBLACION, POI.DESC_POBLACION, POI.URL_POBLACION
            FROM Prod_Yumping_pt_PT.LO_POBLACION PO, Prod_Yumping_pt_PT.LO_POBLACION_PT POI
            WHERE PO.ID_POBLACION = POI.ID_POBLACION
                AND PO.ID_POBLACION=70060
                AND POI.IDIOMA = 'es';

Tiempo de la consulta: 0.007774829864502

Tiempo acumulado:0.48316144943237

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[129]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
            FROM LO_SECTORES_I18N SECI
            INNER JOIN LO_SECTORES SEC ON SECI.ID_SECTOR=SEC.ID_SECTOR
            WHERE SECI.URL = 're-qi-qiu-fei-xing'
                AND ID_TROPIC = 86
                AND SECI.FK_ID_IDIOMA_SI18N = 'ch'
            LIMIT 1;

Tiempo de la consulta: 0.0022671222686768

Tiempo acumulado:0.48542857170105

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

Tiempo de la consulta: 0.0041429996490479

Tiempo acumulado:0.4895715713501

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

Tiempo de la consulta: 0.0031828880310059

Tiempo acumulado:0.4927544593811

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

Tiempo de la consulta: 0.00062203407287598

Tiempo acumulado:0.49337649345398

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[133]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
            FROM Prod_Yumping_pt_PT.LO_SECTORES SEC
            INNER JOIN Prod_Yumping_pt_PT.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
            WHERE SEC.ID_SECTOR=19
                AND SECI.FK_ID_IDIOMA_SI18N = 'de'
                AND SECI.ID_TROPIC=87;

Tiempo de la consulta: 0.00062394142150879

Tiempo acumulado:0.49400043487549

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

Tiempo de la consulta: 0.00064706802368164

Tiempo acumulado:0.49464750289917

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

Tiempo de la consulta: 0.00066995620727539

Tiempo acumulado:0.49531745910645

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[136]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
            FROM LO_REGION RE, LO_REGION_I18N REI
            WHERE REI.URL = 'fa-lu'
                AND REI.ID_REGION = RE.ID_REGION
                AND REI.IDIOMA = 'ch';

Tiempo de la consulta: 0.00058794021606445

Tiempo acumulado:0.49590539932251

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

Tiempo de la consulta: 0.00055503845214844

Tiempo acumulado:0.49646043777466

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

Tiempo de la consulta: 0.0011940002441406

Tiempo acumulado:0.4976544380188

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

Tiempo de la consulta: 0.00060486793518066

Tiempo acumulado:0.49825930595398

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[140]: SELECT RE.ID_REGION, REI.DESC_REGION,REI.URL URL_REGION
            FROM Prod_Yumping_pt_PT.LO_REGION RE, Prod_Yumping_pt_PT.LO_REGION_I18N REI
            WHERE RE.ID_REGION=756
                AND RE.ID_REGION = REI.ID_REGION
                AND REI.IDIOMA = 'de';

Tiempo de la consulta: 0.00050020217895508

Tiempo acumulado:0.49875950813293

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

Tiempo de la consulta: 0.00057196617126465

Tiempo acumulado:0.4993314743042

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

Tiempo de la consulta: 0.00061202049255371

Tiempo acumulado:0.49994349479675

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[143]: SELECT PO.ID_POBLACION_PADRE AS ID_POBLACION_PADRE,POI.DESC_POBLACION, POI.URL_POBLACION
            FROM LO_POBLACION PO, LO_POBLACION_PT POI
            WHERE POI.URL_POBLACION='alvor'
                AND POI.ID_REGION='756'
                AND IDIOMA = 'ch'
                AND POI.ID_POBLACION=PO.ID_POBLACION
            ORDER BY PO.ID_POBLACION;

Tiempo de la consulta: 0.00072407722473145

Tiempo acumulado:0.50066757202148

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

Tiempo de la consulta: 0.00056314468383789

Tiempo acumulado:0.50123071670532

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

Tiempo de la consulta: 0.010069131851196

Tiempo acumulado:0.51129984855652

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

Tiempo de la consulta: 0.00068187713623047

Tiempo acumulado:0.51198172569275

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[147]: SELECT POI.ID_POBLACION, POI.DESC_POBLACION, POI.URL_POBLACION
            FROM Prod_Yumping_pt_PT.LO_POBLACION PO, Prod_Yumping_pt_PT.LO_POBLACION_PT POI
            WHERE PO.ID_POBLACION = POI.ID_POBLACION
                AND PO.ID_POBLACION=70060
                AND POI.IDIOMA = 'de';

Tiempo de la consulta: 0.0051889419555664

Tiempo acumulado:0.51717066764832

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[148]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
            FROM LO_SECTORES_I18N SECI
            INNER JOIN LO_SECTORES SEC ON SECI.ID_SECTOR=SEC.ID_SECTOR
            WHERE SECI.URL = 're-qi-qiu-fei-xing'
                AND ID_TROPIC = 86
                AND SECI.FK_ID_IDIOMA_SI18N = 'ch'
            LIMIT 1;

Tiempo de la consulta: 0.00453782081604

Tiempo acumulado:0.52170848846436

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

Tiempo de la consulta: 0.0010099411010742

Tiempo acumulado:0.52271842956543

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

Tiempo de la consulta: 0.0056769847869873

Tiempo acumulado:0.52839541435242

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

Tiempo de la consulta: 0.000701904296875

Tiempo acumulado:0.52909731864929

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[152]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
            FROM Prod_Yumping_pt_PT.LO_SECTORES SEC
            INNER JOIN Prod_Yumping_pt_PT.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
            WHERE SEC.ID_SECTOR=19
                AND SECI.FK_ID_IDIOMA_SI18N = 'es'
                AND SECI.ID_TROPIC=85;

Tiempo de la consulta: 0.000640869140625

Tiempo acumulado:0.52973818778992

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

Tiempo de la consulta: 0.00061511993408203

Tiempo acumulado:0.530353307724

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

Tiempo de la consulta: 0.0011711120605469

Tiempo acumulado:0.53152441978455

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[155]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
            FROM LO_REGION RE, LO_REGION_I18N REI
            WHERE REI.URL = 'fa-lu'
                AND REI.ID_REGION = RE.ID_REGION
                AND REI.IDIOMA = 'ch';

Tiempo de la consulta: 0.00054311752319336

Tiempo acumulado:0.53206753730774

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

Tiempo de la consulta: 0.00055384635925293

Tiempo acumulado:0.53262138366699

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

Tiempo de la consulta: 0.0059499740600586

Tiempo acumulado:0.53857135772705

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

Tiempo de la consulta: 0.0013039112091064

Tiempo acumulado:0.53987526893616

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[159]: SELECT RE.ID_REGION, REI.DESC_REGION,REI.URL URL_REGION
            FROM Prod_Yumping_pt_PT.LO_REGION RE, Prod_Yumping_pt_PT.LO_REGION_I18N REI
            WHERE RE.ID_REGION=756
                AND RE.ID_REGION = REI.ID_REGION
                AND REI.IDIOMA = 'es';

Tiempo de la consulta: 0.00089907646179199

Tiempo acumulado:0.54077434539795

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

Tiempo de la consulta: 0.00090813636779785

Tiempo acumulado:0.54168248176575

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

Tiempo de la consulta: 0.0014240741729736

Tiempo acumulado:0.54310655593872

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[162]: SELECT PO.ID_POBLACION_PADRE AS ID_POBLACION_PADRE,POI.DESC_POBLACION, POI.URL_POBLACION
            FROM LO_POBLACION PO, LO_POBLACION_PT POI
            WHERE POI.URL_POBLACION='alvor'
                AND POI.ID_REGION='756'
                AND IDIOMA = 'ch'
                AND POI.ID_POBLACION=PO.ID_POBLACION
            ORDER BY PO.ID_POBLACION;

Tiempo de la consulta: 0.0035748481750488

Tiempo acumulado:0.54668140411377

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

Tiempo de la consulta: 0.00094199180603027

Tiempo acumulado:0.5476233959198

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

Tiempo de la consulta: 0.0006251335144043

Tiempo acumulado:0.5482485294342

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

Tiempo de la consulta: 0.00071382522583008

Tiempo acumulado:0.54896235466003

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[166]: SELECT POI.ID_POBLACION, POI.DESC_POBLACION, POI.URL_POBLACION
            FROM Prod_Yumping_pt_PT.LO_POBLACION PO, Prod_Yumping_pt_PT.LO_POBLACION_PT POI
            WHERE PO.ID_POBLACION = POI.ID_POBLACION
                AND PO.ID_POBLACION=70060
                AND POI.IDIOMA = 'es';

Tiempo de la consulta: 0.0085990428924561

Tiempo acumulado:0.55756139755249

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

Tiempo de la consulta: 0.00085091590881348

Tiempo acumulado:0.5584123134613

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

Tiempo de la consulta: 0.00064802169799805

Tiempo acumulado:0.5590603351593

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

Tiempo de la consulta: 0.0037281513214111

Tiempo acumulado:0.56278848648071

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

Tiempo de la consulta: 0.0049920082092285

Tiempo acumulado:0.56778049468994

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

Tiempo de la consulta: 0.00059390068054199

Tiempo acumulado:0.56837439537048

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

Tiempo de la consulta: 0.00068187713623047

Tiempo acumulado:0.56905627250671

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

Tiempo de la consulta: 0.00076508522033691

Tiempo acumulado:0.56982135772705

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

Tiempo de la consulta: 0.00062704086303711

Tiempo acumulado:0.57044839859009

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

Tiempo de la consulta: 0.00056195259094238

Tiempo acumulado:0.57101035118103

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

Tiempo de la consulta: 0.00057816505432129

Tiempo acumulado:0.57158851623535

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

Tiempo de la consulta: 0.0037899017333984

Tiempo acumulado:0.57537841796875

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

Tiempo de la consulta: 0.0016930103302002

Tiempo acumulado:0.57707142829895

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

Tiempo de la consulta: 0.0024969577789307

Tiempo acumulado:0.57956838607788

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

Tiempo de la consulta: 0.0021929740905762

Tiempo acumulado:0.58176136016846

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

Tiempo de la consulta: 0.00059819221496582

Tiempo acumulado:0.58235955238342

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

Tiempo de la consulta: 0.00062203407287598

Tiempo acumulado:0.5829815864563

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

Tiempo de la consulta: 0.00061988830566406

Tiempo acumulado:0.58360147476196

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

Tiempo de la consulta: 0.00060701370239258

Tiempo acumulado:0.58420848846436

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

Tiempo de la consulta: 0.00083589553833008

Tiempo acumulado:0.58504438400269

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

Tiempo de la consulta: 0.00065779685974121

Tiempo acumulado:0.58570218086243

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

Tiempo de la consulta: 0.00068497657775879

Tiempo acumulado:0.58638715744019

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

Tiempo de la consulta: 0.0041639804840088

Tiempo acumulado:0.59055113792419

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

Tiempo de la consulta: 0.00089001655578613

Tiempo acumulado:0.59144115447998

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

Tiempo de la consulta: 0.0006721019744873

Tiempo acumulado:0.59211325645447

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

Tiempo de la consulta: 0.00058102607727051

Tiempo acumulado:0.59269428253174

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

Tiempo de la consulta: 0.0022838115692139

Tiempo acumulado:0.59497809410095

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

Tiempo de la consulta: 0.00058698654174805

Tiempo acumulado:0.5955650806427

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

Tiempo de la consulta: 0.00075387954711914

Tiempo acumulado:0.59631896018982

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

Tiempo de la consulta: 0.00059795379638672

Tiempo acumulado:0.59691691398621

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

Tiempo de la consulta: 0.0011641979217529

Tiempo acumulado:0.59808111190796

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

Tiempo de la consulta: 0.00069284439086914

Tiempo acumulado:0.59877395629883

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

Tiempo de la consulta: 0.0092411041259766

Tiempo acumulado:0.6080150604248

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

Tiempo de la consulta: 0.00667405128479

Tiempo acumulado:0.61468911170959

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

Tiempo de la consulta: 0.002190113067627

Tiempo acumulado:0.61687922477722

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

Tiempo de la consulta: 0.0030050277709961

Tiempo acumulado:0.61988425254822

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

Tiempo de la consulta: 0.00066113471984863

Tiempo acumulado:0.62054538726807

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

Tiempo de la consulta: 0.0078129768371582

Tiempo acumulado:0.62835836410522

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

Tiempo de la consulta: 0.011139154434204

Tiempo acumulado:0.63949751853943

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

Tiempo de la consulta: 0.0033900737762451

Tiempo acumulado:0.64288759231567

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

Tiempo de la consulta: 0.0031030178070068

Tiempo acumulado:0.64599061012268

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[207]: SELECT URL_POBLACION, ID_POBLACION
            FROM LO_POBLACION_PT PO
            WHERE PO.ID_POBLACION = 70060
                AND PO.IDIOMA = 'pt';

Tiempo de la consulta: 0.0018320083618164

Tiempo acumulado:0.6478226184845

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[208]: SELECT (N_OFERTAS)+(N_EMPRESAS) AS NEMPRESAS, N_OFERTAS AS NumOfertas, N_EMPRESAS as NumEmpresas, PS.ID_POBLACION, 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_POBLACION_PT_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_POBLACION = 70060
                AND PS.ID_SECTOR = 19
            ORDER BY NEMPRESAS DESC;

Tiempo de la consulta: 0.0029351711273193

Tiempo acumulado:0.65075778961182

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[209]: SELECT SEOHOME.TITLE, SEOHOME.METADESCRIPTION,SEOHOME.DESCRIPTION,SEOHOME.DESCRIPTION2,SEOHOME.HEIGHT
            FROM LO_SEO_DESCRIPTIONS_HOME SEOHOME
            WHERE SEOHOME.ID_TROPIC = 86
                AND SEOHOME.ID_KEY='S19'
                AND SEOHOME.ID_LOCALIZACION='70060';

Tiempo de la consulta: 0.027101039886475

Tiempo acumulado:0.67785882949829

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

Tiempo de la consulta: 0.0038421154022217

Tiempo acumulado:0.68170094490051

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

Tiempo de la consulta: 0.0033810138702393

Tiempo acumulado:0.68508195877075

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[212]: SELECT N_OPIS AS TOTAL, MEDIA_OPIS_5 AS MEDIA, ROUND(MEDIA_OPIS_100,0) AS MEDIA2
            FROM LO_POBLACION_PT_STATS
            WHERE ID_POBLACION = 70060
                AND ID_SECTOR = 19;

Tiempo de la consulta: 0.0058071613311768

Tiempo acumulado:0.69088912010193

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[213]: 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_PRECIOS_SECTORES PSEC ON PSEC.ID_PRECIO_PS = PRE.ID_PRECIO
            INNER JOIN LO_EMPRESAS EMP ON PRE.ID_EMPRESA_PRE = EMP.ID_EMPRESA
            WHERE EMP.VALID IN (1)
                AND PRE.VALID_PRE = 4
                AND PSEC.ID_ACTIVIDAD_PS = 19
                AND PRE.ID_POBLACION_PRE ='70060' UNION ALL SELECT MIN(PD.PRECIO_PD) MIN_PRECIO, MAX(PD.PRECIO_PD) MAX_PRECIO
            FROM LO_PRECIOS PRE
            INNER JOIN LO_PRECIOS_SECTORES PSEC ON PSEC.ID_PRECIO_PS = PRE.ID_PRECIO
            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.VALID IN (1)
                AND PRE.VALID_PRE = 4
                AND PD.VALID_PD = 1
                AND PSEC.ID_ACTIVIDAD_PS = 19
                AND PRE.ID_POBLACION_PRE ='70060' /* 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
            LEFT JOIN LO_PRECIOS_SECTORES PSEC ON PSEC.ID_PRECIO_PS = PRE.ID_PRECIO
            WHERE EMP.VALID IN (1 )
                AND EMP.PRECIO_ACTIVIDAD !=0
                AND PSEC.ID_ACTIVIDAD_PS = 19
                AND PRE.ID_POBLACION_PRE ='70060' */ ) AS PRECIO_MIN_MAX;

Tiempo de la consulta: 0.0097100734710693

Tiempo acumulado:0.700599193573

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

Tiempo de la consulta: 0.0059819221496582

Tiempo acumulado:0.70658111572266

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[215]: SELECT *
            FROM LO_SEO_KEYWORDS_LANDING SKL
            WHERE SKL.ID_SECTOR = 19
                AND SKL.ID_TROPIC = 86;

Tiempo de la consulta: 0.0033509731292725

Tiempo acumulado:0.70993208885193

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[216]: SELECT '1' as TIPO, PRE.N_VENTAS_PRE AS VENTAS , IF(PP.ID_POBLACION_PP = 70060,1,IF (PT.N_ORDER_VENTAS_TROPIC = '0.0', 2, 0)) AS ES_PUBLI , IF (PRE.N_ORDER_VENTAS_TROPIC = '0.0', PCER.DISTANCIA_REAL +10000, PCER.DISTANCIA_REAL) AS DIST_REAL, PCER.DISTANCIA_REAL, PCER.DISTANCIA, PCER.DURACION , IF (PT.N_ORDER_VENTAS_TROPIC = '0.0', null, PR.PRIORIZA_ORDEN) AS PRIO_ORDEN , PRE.ID_PRECIO
            FROM LO_PRECIOS PRE
            INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'ch'
            LEFT JOIN LO_PRECIOS_PUBLI PP ON PRE.ID_PRECIO = PP.ID_PRECIO_PP
            INNER JOIN LO_PRECIOS_SECTORES PS ON PS.ID_PRECIO_PS = PRE.ID_PRECIO
            INNER JOIN LO_SECTORES SEC ON SEC.ID_SECTOR = PS.ID_ACTIVIDAD_PS
            INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
                AND EMP.VALID = 1
            INNER JOIN LO_REGION RE ON RE.ID_REGION = PRE.ID_REGION_PRE OR RE.ID_REGION = PP.ID_REGION_PP
            LEFT JOIN LO_POBLACION_CERCANAS PCER ON PCER.ID_POBLACION_CERCANA = PRE.ID_POBLACION_PRE
                AND PCER.ID_POBLACION = 70060 /*
            INNER JOIN LO_POBLACION_PT PO ON PO.ID_POBLACION = PRE.ID_POBLACION_PRE
                AND PO.IDIOMA='ch'
            LEFT JOIN LO_RESERVAS_COMPRAS RC ON PRE.ID_PRECIO = RC.ID_PRECIO_RC
                AND RC.VALID_RC NOT IN (0, 2, 6, 7)
            LEFT JOIN LO_EMPRESAS_OPINIONES OP ON OP.RESERVA_FEEDBACK = RC.ID_RESERVA_COMPRA
                AND OP.VALID = 1
            INNER JOIN LO_REGION RE ON RE.ID_REGION = PRE.ID_REGION_PRE*/
            LEFT JOIN LO_PRECIOS_RESTRICCIONES PR ON PRE.ID_PRECIO = PR.ID_PRECIO
            WHERE PRE.VALID_PRE = 4
                AND (PS.ID_ACTIVIDAD_PS = 19 OR (ID_SECTOR_PP = 19
                AND PP.ID_POBLACION_PP = 70060))
                AND (PRE.ID_POBLACION_PRE = 70060 OR ID_POBLACION_PP = 70060)
                AND (PRE.ID_POBLACION_PRE =70060 OR ID_POBLACION_PP = 70060 )
                AND (PR.POBLACION = 0 OR PR.POBLACION 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 PRIO_ORDEN DESC, ES_PUBLI ASC , DIST_REAL ASC , PT.N_ORDER_VENTAS_TROPIC DESC ,PRE.ID_PRECIO ASC
            LIMIT 20;

Tiempo de la consulta: 0.061521053314209

Tiempo acumulado:0.77145314216614

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[217]: SELECT count(*) as NOFERTAS
            FROM LO_PRECIOS PRE
            INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'ch'
            LEFT JOIN LO_PRECIOS_PUBLI PP ON PRE.ID_PRECIO = PP.ID_PRECIO_PP
            INNER JOIN LO_PRECIOS_SECTORES PS ON PS.ID_PRECIO_PS = PRE.ID_PRECIO
            INNER JOIN LO_SECTORES SEC ON SEC.ID_SECTOR = PS.ID_ACTIVIDAD_PS
            INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
                AND EMP.VALID = 1
            INNER JOIN LO_REGION RE ON RE.ID_REGION = PRE.ID_REGION_PRE OR RE.ID_REGION = PP.ID_REGION_PP
            LEFT JOIN LO_POBLACION_CERCANAS PCER ON PCER.ID_POBLACION_CERCANA = PRE.ID_POBLACION_PRE
                AND PCER.ID_POBLACION = 70060 /*
            INNER JOIN LO_POBLACION_PT PO ON PO.ID_POBLACION = PRE.ID_POBLACION_PRE
                AND PO.IDIOMA='ch'
            LEFT JOIN LO_RESERVAS_COMPRAS RC ON PRE.ID_PRECIO = RC.ID_PRECIO_RC
                AND RC.VALID_RC NOT IN (0, 2, 6, 7)
            LEFT JOIN LO_EMPRESAS_OPINIONES OP ON OP.RESERVA_FEEDBACK = RC.ID_RESERVA_COMPRA
                AND OP.VALID = 1
            INNER JOIN LO_REGION RE ON RE.ID_REGION = PRE.ID_REGION_PRE*/
            LEFT JOIN LO_PRECIOS_RESTRICCIONES PR ON PRE.ID_PRECIO = PR.ID_PRECIO
            WHERE PRE.VALID_PRE = 4
                AND (PS.ID_ACTIVIDAD_PS = 19 OR (ID_SECTOR_PP = 19
                AND PP.ID_POBLACION_PP = 70060))
                AND (PRE.ID_POBLACION_PRE = 70060 OR ID_POBLACION_PP = 70060)
                AND (PRE.ID_POBLACION_PRE =70060 OR ID_POBLACION_PP = 70060 )
                AND (PR.POBLACION = 0 OR PR.POBLACION 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;

Tiempo de la consulta: 0.044997930526733

Tiempo acumulado:0.81645107269287

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[218]: SELECT '3' as TIPO, PRE.N_VENTAS_PRE AS VENTAS , IF(PP.ID_POBLACION_PP = 70060,1,IF (PT.N_ORDER_VENTAS_TROPIC = '0.0', 2, 0)) AS ES_PUBLI , IF (PRE.N_ORDER_VENTAS_TROPIC = '0.0', PCER.DISTANCIA_REAL +10000, PCER.DISTANCIA_REAL) AS DIST_REAL, PCER.DISTANCIA_REAL, PCER.DISTANCIA, PCER.DURACION , IF (PT.N_ORDER_VENTAS_TROPIC = '0.0', null, PR.PRIORIZA_ORDEN) AS PRIO_ORDEN , COUNT(DISTINCT RC.ID_RESERVA_COMPRA) AS VENTAS, PRE.ID_EMPRESA_PRE, PO.DESC_POBLACION, PRE.ID_PRECIO, SECI.ID_SECTOR, SECI.DESC_SECTOR, SECI.URL URL_SECTOR, REI.ID_REGION, REI.URL URL_REGION, REI.DESC_REGION, PP.ID_REGION_PP, EMP.NOMBRE, PRE.MIN_PERS_PRE, PD.MIN_PERSONAS_PD,PRE.MAX_PERS_PRE,PD.MAX_PERSONAS_PD,PRE.ALOJAMIENTO_PRE, PRE.COMIDA_PRE,PRE.TRANSPORTE_PRE,REI.DESC_REGION,PRE.FOTOPRINCIPAL_PRE, PRE.GALERIA_PRE,EMPS.CENTRAL_ACTIVA, PRE.MULTIACTIVIDAD_PRE, PRE.FK_ID_PAIS_PRE AS ID_PAIS ,PT.N_ORDER_VENTAS_TROPIC , if(PRECIO_PD>0,LEAST(MIN(PRECIO_PD),PRECIO_PRE),LEAST(999999999,PRECIO_PRE) ) PRECIO, PRE.PRECIO_PRE, 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, (1 - (MIN(PD.PRECIO_PD) / PRE.PRECIO_PRE))*100 , 0) AS DESCUENTO, PD.OFERTA_PD, 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, DATE_FORMAT(PR.FECHA_INICIO, '%d/%m') AS FEC_RES_INI, DATE_FORMAT(PR.FECHA_FIN, '%d/%m') AS FEC_RES_FIN, TRUNCATE(AVG(OP.VALORACION),0) AS VALORACION,COUNT(DISTINCT OP.ID_OPINION) AS OPIS, PD.OFERTA_PD,VALID_PD, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, PRECIO_UNITARIO_PRE , PPT.DESCRIPCION_PPT AS DESCRIPCION_PP ,IF ( PRE.MIN_PERS_PRE > MIN(PD.MIN_PERSONAS_PD)
                AND PD.MIN_PERSONAS_PD IS NOT NULL, MIN(PD.MIN_PERSONAS_PD), PRE.MIN_PERS_PRE ) AS MIN_PERSONAS_PD ,IF ( PRE.MAX_PERS_PRE < MAX(PD.MAX_PERSONAS_PD)
                AND PD.MAX_PERSONAS_PD IS NOT NULL, MAX(PD.MAX_PERSONAS_PD), PRE.MAX_PERS_PRE ) AS MAX_PERSONAS_PD, REIA.DESC_REGION AS DESC_REGION_ADM, RE.ID_CAPITAL, PO.ID_POBLACION, RE.SIMCAPN, IF(DATE(PRE.FEC_INSERT_PRE) > DATE(NOW()) - INTERVAL 3 MONTH, 1, 0) AS IS_NEW
            FROM LO_PRECIOS PRE
            INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'ch'
            LEFT JOIN LO_PRECIOS_PUBLI PP ON PRE.ID_PRECIO = PP.ID_PRECIO_PP
            LEFT JOIN LO_RESERVAS_COMPRAS RC ON PRE.ID_PRECIO = RC.ID_PRECIO_RC
                AND RC.VALID_RC NOT IN (0, 2, 6, 7)
            LEFT JOIN LO_PRECIOS_PUBLI_TRADUCCION PPT ON PPT.ID_PUBLI_PP = PP.ID_PUBLI_PP
                AND PPT.IDIOMA = 'ch'
            LEFT JOIN LO_PRECIOS_DESCUENTOS PD ON PD.ID_PRECIO_PD = PRE.ID_PRECIO
                AND PD.VALID_PD = 1
            INNER JOIN LO_REGION RE ON RE.ID_REGION = PRE.ID_REGION_PRE OR RE.ID_REGION = PP.ID_REGION_PP
            INNER JOIN LO_PRECIOS_SECTORES PS ON PS.ID_PRECIO_PS = PRE.ID_PRECIO
            INNER JOIN LO_SECTORES SEC ON SEC.ID_SECTOR = PS.ID_ACTIVIDAD_PS
            INNER JOIN LO_EMPRESAS_STAT EMPS ON EMPS.FK_ID_EST = PRE.ID_EMPRESA_PRE
            INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
                AND EMP.VALID = 1
            INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = PS.ID_ACTIVIDAD_PS
                AND (SECI.FK_ID_IDIOMA_SI18N = 'ch'
                AND SECI.ID_TROPIC = 86)
            LEFT JOIN LO_POBLACION_CERCANAS PCER ON PCER.ID_POBLACION_CERCANA = PRE.ID_POBLACION_PRE
                AND PCER.ID_POBLACION = 70060
            LEFT JOIN LO_REGION_I18N REI ON REI.ID_REGION = PRE.ID_REGION_PRE
                AND REI.IDIOMA='ch'
            INNER JOIN LO_REGION_ADM1_I18N REIA ON REIA.ID_REGION_ADM1 = RE.ID_REGION_ADM1
                AND REIA.IDIOMA = 'ch'
            LEFT JOIN LO_POBLACION_PT PO ON PO.ID_POBLACION = PRE.ID_POBLACION_PRE
                AND PO.IDIOMA='ch'
            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 1 = 1
                AND PRE.ID_PRECIO IN (72654, 72691)
                AND PRE.VALID_PRE = 4
                AND (PS.ID_ACTIVIDAD_PS = 19 OR (ID_SECTOR_PP = 19
                AND PP.ID_POBLACION_PP = 70060))
                AND (PRE.ID_POBLACION_PRE = 70060 OR ID_POBLACION_PP = 70060)
                AND (PRE.ID_POBLACION_PRE =70060 OR ID_POBLACION_PP = 70060 )
                AND (PR.POBLACION = 0 OR PR.POBLACION 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 PRIO_ORDEN DESC, ES_PUBLI ASC , DIST_REAL ASC , PT.N_ORDER_VENTAS_TROPIC DESC ,PRE.ID_PRECIO ASC
            LIMIT 20;

Tiempo de la consulta: 0.025573015213013

Tiempo acumulado:0.84202408790588

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

Tiempo de la consulta: 0.0011260509490967

Tiempo acumulado:0.84315013885498

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

Tiempo de la consulta: 0.0013728141784668

Tiempo acumulado:0.84452295303345

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[221]: SELECT *
            FROM LO_PRECIOS_CALENDARIO PC
            WHERE PC.ID_PRECIO_PC = 72654
                AND DATE(PC.FECHA_PC) <= (DATE(NOW()) + INTERVAL 3 MONTH)
                AND DATE(PC.FECHA_PC) >= DATE(NOW())
                AND TIPO_PC = 2;

Tiempo de la consulta: 0.0040080547332764

Tiempo acumulado:0.84853100776672

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[222]: SELECT (PRE.PERIODO_PRE) AS PERIODO
            FROM LO_PRECIOS PRE
            WHERE PRE.ID_PRECIO = 72654 UNION ALL SELECT PD.PERIODO_PD AS PERIODO
            FROM LO_PRECIOS_DESCUENTOS PD
            WHERE PD.ID_PRECIO_PD = 72654
                AND PD.VALID_PD = 1;

Tiempo de la consulta: 0.00073599815368652

Tiempo acumulado:0.84926700592041

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[223]: SELECT ID_PRECIO, SUM(VENTAS) VENTAS, SUM(DEVOS) DEVOS, SUM(COMISION) COMISION, SUM(TOTAL) TOTAL, ID_EMPRESA_PRE AS ID_EMPRESA FROM( SELECT PRE.ID_PRECIO, COUNT(RC.ID_RESERVA_COMPRA) AS VENTAS, 0 AS DEVOS, EMP.COMISION , (COUNT(RC.ID_RESERVA_COMPRA) * EMP.COMISION / 100 ) AS TOTAL, PRE.ID_EMPRESA_PRE
            FROM LO_PRECIOS PRE
            LEFT JOIN LO_RESERVAS_COMPRAS RC ON RC.ID_PRECIO_RC = PRE.ID_PRECIO
                AND VALID_RC NOT IN (0, 2, 7)
                AND ID_TROPIC = 86
                AND DATE_FORMAT(RC.FEC_INSERT_RC, '%Y-%m-%d') >= NOW() - INTERVAL 2 YEAR
            INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
                AND EMP.VALID = 1
            WHERE PRE.VALID_PRE = 4
                AND ID_PRECIO = 72654
            GROUP BY PRE.ID_PRECIO UNION ALL SELECT PRE.ID_PRECIO, 0 AS VENTAS, COUNT(RC.ID_RESERVA_COMPRA) AS DEVOS, 0 , 0 AS TOTAL, PRE.ID_EMPRESA_PRE
            FROM LO_PRECIOS PRE
            LEFT JOIN LO_RESERVAS_COMPRAS RC ON RC.ID_PRECIO_RC = PRE.ID_PRECIO
                AND VALID_RC IN (7)
                AND ID_TROPIC = 86
                AND RC.DEVOLUCION_RC IN (1,2)
                AND DATE_FORMAT(RC.FEC_INSERT_RC, '%Y-%m-%d') >= NOW() - INTERVAL 2 YEAR
            INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
                AND EMP.VALID = 1
            WHERE PRE.VALID_PRE = 4
                AND ID_PRECIO = 72654
            GROUP BY PRE.ID_PRECIO ) AS X;

Tiempo de la consulta: 0.0021958351135254

Tiempo acumulado:0.85146284103394

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[224]: SELECT *
            FROM LO_PRECIOS_MODIFICAR_ORDEN
            WHERE ID_PRECIO = 72654
                AND DATE_FORMAT(FECHA, '%Y-%m-%d') >= NOW() - INTERVAL 3 MONTH;

Tiempo de la consulta: 0.00048303604125977

Tiempo acumulado:0.8519458770752

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

Tiempo de la consulta: 0.0037119388580322

Tiempo acumulado:0.85565781593323

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

Tiempo de la consulta: 0.00502610206604

Tiempo acumulado:0.86068391799927

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[227]: SELECT *
            FROM LO_FOTOS
            WHERE ID_PRECIO = 72654
                AND FOTO = 'p-72654-preparando-el-globo-aerostatico_16363601984284.jpg'
                AND VALID = 1;

Tiempo de la consulta: 0.00058889389038086

Tiempo acumulado:0.86127281188965

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[228]: SELECT F_WIDTH, F_HEIGHT
            FROM LO_FOTOS
            WHERE ID_PRECIO = 72654
                AND FOTO = 'p-72654-preparando-el-globo-aerostatico_16363601984284.jpg';

Tiempo de la consulta: 0.00039792060852051

Tiempo acumulado:0.86167073249817

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[229]: SELECT URL_PRE, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, ID_PRECIO, FK_ID_PAIS_PRE
            FROM LO_PRECIOS PRE
            INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'ch'
            WHERE PRE.ID_PRECIO = 72654;

Tiempo de la consulta: 0.00085306167602539

Tiempo acumulado:0.86252379417419

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

Tiempo de la consulta: 0.00060391426086426

Tiempo acumulado:0.86312770843506

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[231]: SELECT N_VENTAS_LAST_MONTH
FROM LO_PRECIOS_STATS PS
WHERE PS.ID_PRECIO = 72654;

Tiempo de la consulta: 0.00080394744873047

Tiempo acumulado:0.86393165588379

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[232]: SELECT DATE_FORMAT(PRE.FEC_ULT_COMPRA, '%Y-%m-%d') AS FEC_ULT_COMPRA, DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%d') AS DIA_COM, DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%m') AS MES_COM
            FROM LO_PRECIOS PRE
            INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'ch'
            WHERE ID_PRECIO = 72654
                AND VALID_PRE = 4
            GROUP BY PRE.ID_PRECIO HAVING FEC_ULT_COMPRA IS NOT NULL
            LIMIT 1;

Tiempo de la consulta: 0.00096797943115234

Tiempo acumulado:0.86489963531494

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

Tiempo de la consulta: 0.00085306167602539

Tiempo acumulado:0.86575269699097

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

Tiempo de la consulta: 0.0015709400177002

Tiempo acumulado:0.86732363700867

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

Tiempo de la consulta: 0.0006709098815918

Tiempo acumulado:0.86799454689026

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[236]: SELECT URL_PRE, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, ID_PRECIO, FK_ID_PAIS_PRE
            FROM LO_PRECIOS PRE
            INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'ch'
            WHERE PRE.ID_PRECIO = 72654;

Tiempo de la consulta: 0.00069499015808105

Tiempo acumulado:0.86868953704834

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

Tiempo de la consulta: 0.0014300346374512

Tiempo acumulado:0.87011957168579

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

Tiempo de la consulta: 0.00040006637573242

Tiempo acumulado:0.87051963806152

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

Tiempo de la consulta: 0.0011038780212402

Tiempo acumulado:0.87162351608276

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[240]: SELECT *
            FROM LO_PRECIOS_CALENDARIO PC
            WHERE PC.ID_PRECIO_PC = 72691
                AND DATE(PC.FECHA_PC) <= (DATE(NOW()) + INTERVAL 3 MONTH)
                AND DATE(PC.FECHA_PC) >= DATE(NOW())
                AND TIPO_PC = 2;

Tiempo de la consulta: 0.0022399425506592

Tiempo acumulado:0.87386345863342

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[241]: SELECT (PRE.PERIODO_PRE) AS PERIODO
            FROM LO_PRECIOS PRE
            WHERE PRE.ID_PRECIO = 72691 UNION ALL SELECT PD.PERIODO_PD AS PERIODO
            FROM LO_PRECIOS_DESCUENTOS PD
            WHERE PD.ID_PRECIO_PD = 72691
                AND PD.VALID_PD = 1;

Tiempo de la consulta: 0.00047993659973145

Tiempo acumulado:0.87434339523315

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[242]: SELECT ID_PRECIO, SUM(VENTAS) VENTAS, SUM(DEVOS) DEVOS, SUM(COMISION) COMISION, SUM(TOTAL) TOTAL, ID_EMPRESA_PRE AS ID_EMPRESA FROM( SELECT PRE.ID_PRECIO, COUNT(RC.ID_RESERVA_COMPRA) AS VENTAS, 0 AS DEVOS, EMP.COMISION , (COUNT(RC.ID_RESERVA_COMPRA) * EMP.COMISION / 100 ) AS TOTAL, PRE.ID_EMPRESA_PRE
            FROM LO_PRECIOS PRE
            LEFT JOIN LO_RESERVAS_COMPRAS RC ON RC.ID_PRECIO_RC = PRE.ID_PRECIO
                AND VALID_RC NOT IN (0, 2, 7)
                AND ID_TROPIC = 86
                AND DATE_FORMAT(RC.FEC_INSERT_RC, '%Y-%m-%d') >= NOW() - INTERVAL 2 YEAR
            INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
                AND EMP.VALID = 1
            WHERE PRE.VALID_PRE = 4
                AND ID_PRECIO = 72691
            GROUP BY PRE.ID_PRECIO UNION ALL SELECT PRE.ID_PRECIO, 0 AS VENTAS, COUNT(RC.ID_RESERVA_COMPRA) AS DEVOS, 0 , 0 AS TOTAL, PRE.ID_EMPRESA_PRE
            FROM LO_PRECIOS PRE
            LEFT JOIN LO_RESERVAS_COMPRAS RC ON RC.ID_PRECIO_RC = PRE.ID_PRECIO
                AND VALID_RC IN (7)
                AND ID_TROPIC = 86
                AND RC.DEVOLUCION_RC IN (1,2)
                AND DATE_FORMAT(RC.FEC_INSERT_RC, '%Y-%m-%d') >= NOW() - INTERVAL 2 YEAR
            INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
                AND EMP.VALID = 1
            WHERE PRE.VALID_PRE = 4
                AND ID_PRECIO = 72691
            GROUP BY PRE.ID_PRECIO ) AS X;

Tiempo de la consulta: 0.0028069019317627

Tiempo acumulado:0.87715029716492

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[243]: SELECT *
            FROM LO_PRECIOS_MODIFICAR_ORDEN
            WHERE ID_PRECIO = 72691
                AND DATE_FORMAT(FECHA, '%Y-%m-%d') >= NOW() - INTERVAL 3 MONTH;

Tiempo de la consulta: 0.00080204010009766

Tiempo acumulado:0.87795233726501

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

Tiempo de la consulta: 0.0012969970703125

Tiempo acumulado:0.87924933433533

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

Tiempo de la consulta: 0.0014550685882568

Tiempo acumulado:0.88070440292358

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[246]: SELECT *
            FROM LO_FOTOS
            WHERE ID_PRECIO = 72691
                AND FOTO = 'p-72691-vuelos-en-globo-en-portugal_16365344198214.jpg'
                AND VALID = 1;

Tiempo de la consulta: 0.0006558895111084

Tiempo acumulado:0.88136029243469

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[247]: SELECT F_WIDTH, F_HEIGHT
            FROM LO_FOTOS
            WHERE ID_PRECIO = 72691
                AND FOTO = 'p-72691-vuelos-en-globo-en-portugal_16365344198214.jpg';

Tiempo de la consulta: 0.00043201446533203

Tiempo acumulado:0.88179230690002

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[248]: SELECT URL_PRE, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, ID_PRECIO, FK_ID_PAIS_PRE
            FROM LO_PRECIOS PRE
            INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'ch'
            WHERE PRE.ID_PRECIO = 72691;

Tiempo de la consulta: 0.00055193901062012

Tiempo acumulado:0.88234424591064

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

Tiempo de la consulta: 0.00090384483337402

Tiempo acumulado:0.88324809074402

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[250]: SELECT N_VENTAS_LAST_MONTH
FROM LO_PRECIOS_STATS PS
WHERE PS.ID_PRECIO = 72691;

Tiempo de la consulta: 0.00063109397888184

Tiempo acumulado:0.8838791847229

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[251]: SELECT DATE_FORMAT(PRE.FEC_ULT_COMPRA, '%Y-%m-%d') AS FEC_ULT_COMPRA, DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%d') AS DIA_COM, DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%m') AS MES_COM
            FROM LO_PRECIOS PRE
            INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'ch'
            WHERE ID_PRECIO = 72691
                AND VALID_PRE = 4
            GROUP BY PRE.ID_PRECIO HAVING FEC_ULT_COMPRA IS NOT NULL
            LIMIT 1;

Tiempo de la consulta: 0.00044512748718262

Tiempo acumulado:0.88432431221008

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

Tiempo de la consulta: 0.0011239051818848

Tiempo acumulado:0.88544821739197

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

Tiempo de la consulta: 0.00050997734069824

Tiempo acumulado:0.88595819473267

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

Tiempo de la consulta: 0.00049209594726562

Tiempo acumulado:0.88645029067993

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[255]: SELECT URL_PRE, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, ID_PRECIO, FK_ID_PAIS_PRE
            FROM LO_PRECIOS PRE
            INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'ch'
            WHERE PRE.ID_PRECIO = 72691;

Tiempo de la consulta: 0.00055098533630371

Tiempo acumulado:0.88700127601624

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

Tiempo de la consulta: 0.00061297416687012

Tiempo acumulado:0.88761425018311

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[257]: SELECT SSF.DESC_SSF,SSF.ID_SSF,SS.INDEXA_SS, SS.ID_SUBFAM_SS
            FROM LO_SUBSECTORES_FAM SSF
            INNER JOIN LO_SUBSECTORES SS ON SS.ID_FAM_SS=SSF.ID_SSF
                AND (SS.ID_TROPIC = 86)
            INNER JOIN LO_PRECIOS_SUBSECTORES PSS ON SS.ID_SUBSECTOR=PSS.ID_ACTIVIDAD_PSS
            INNER JOIN LO_PRECIOS PRE ON PSS.ID_PRECIO_PSS = PRE.ID_PRECIO
            LEFT JOIN LO_PRECIOS_PUBLI PP ON PP.ID_PRECIO_PP = PRE.ID_PRECIO
            INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'ch'
            WHERE SS.ID_SECTOR_SS=19
                AND SSF.ID_TROPIC = 86
            GROUP BY SSF.ID_SSF
            ORDER BY COUNT(SSF.ID_SSF) DESC;

Tiempo de la consulta: 0.00065994262695312

Tiempo acumulado:0.88827419281006

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[258]: SELECT (N_OFERTAS)+(N_EMPRESAS) AS NEMPRESAS, N_OFERTAS AS NumOfertas, N_EMPRESAS as NumEmpresas, PS.ID_POBLACION, 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_POBLACION_PT_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_POBLACION = 70060
                AND PS.ID_SECTOR = 19
            ORDER BY NEMPRESAS DESC;

Tiempo de la consulta: 0.00044703483581543

Tiempo acumulado:0.88872122764587

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[259]: SELECT IF(PO.ID_POBLACION = RE.ID_CAPITAL,1,2) AS CAPITAL, IF(ISNULL(N_OFERTAS),0,N_OFERTAS)+IF(ISNULL(N_EMPRESAS),0,N_EMPRESAS) AS NEMPRESAS, N_OFERTAS AS NumOfertas, N_EMPRESAS as NumEmpresas, PO.ID_POBLACION, PO.DESC_POBLACION, PO.URL_POBLACION AS URL_POBLACION, PO.ID_REGION, REI.DESC_REGION, REI.URL AS URL_REGION, '' AS DESC_SECTOR, '' AS ID_GRUPO, IF(PC.DISTANCIA_REAL IS NULL, 20000, PC.DISTANCIA_REAL) AS DISTANCIA_R FROM LO_POBLACION_PT_STATS PS
            INNER JOIN LO_POBLACION_PT PO ON PS.ID_POBLACION = PO.ID_POBLACION
                AND PO.IDIOMA = 'ch'
                AND PO.ID_REGION = 756
            INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PO.ID_REGION
                AND REI.IDIOMA = 'ch'
            INNER JOIN LO_REGION RE ON RE.ID_REGION = REI.ID_REGION
            LEFT JOIN LO_POBLACION_CERCANAS PC ON PC.ID_POBLACION = 70060
                AND PC.ID_POBLACION_CERCANA = PO.ID_POBLACION
            WHERE (PS.N_OFERTAS > 0 /* OR PS.N_EMPRESAS > 0 */)
                AND IF(RE.SIMCAPN = 1,PO.ID_POBLACION != RE.ID_CAPITAL, 1=1)
                AND PS.ID_SECTOR = 19
            GROUP BY PS.ID_POBLACION
            ORDER BY DISTANCIA_R, PC.DISTANCIA ASC, PS.N_OFERTAS DESC;

Tiempo de la consulta: 0.0057318210601807

Tiempo acumulado:0.89445304870605

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

Tiempo de la consulta: 0.00052189826965332

Tiempo acumulado:0.89497494697571

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[261]: SELECT URL_POBLACION, ID_POBLACION
            FROM LO_POBLACION_PT PO
            WHERE PO.ID_POBLACION = 80899
                AND PO.IDIOMA = 'pt';

Tiempo de la consulta: 0.00049996376037598

Tiempo acumulado:0.89547491073608

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

Tiempo de la consulta: 0.0003960132598877

Tiempo acumulado:0.89587092399597

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[263]: SELECT URL_POBLACION, ID_POBLACION
            FROM LO_POBLACION_PT PO
            WHERE PO.ID_POBLACION = 76856
                AND PO.IDIOMA = 'pt';

Tiempo de la consulta: 0.00096893310546875

Tiempo acumulado:0.89683985710144

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

Tiempo de la consulta: 0.00038886070251465

Tiempo acumulado:0.89722871780396

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[265]: SELECT URL_POBLACION, ID_POBLACION
            FROM LO_POBLACION_PT PO
            WHERE PO.ID_POBLACION = 84001
                AND PO.IDIOMA = 'pt';

Tiempo de la consulta: 0.00036811828613281

Tiempo acumulado:0.89759683609009

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

Tiempo de la consulta: 0.00040411949157715

Tiempo acumulado:0.89800095558167

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[267]: SELECT URL_POBLACION, ID_POBLACION
            FROM LO_POBLACION_PT PO
            WHERE PO.ID_POBLACION = 78275
                AND PO.IDIOMA = 'pt';

Tiempo de la consulta: 0.00039196014404297

Tiempo acumulado:0.89839291572571

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

Tiempo de la consulta: 0.00039315223693848

Tiempo acumulado:0.89878606796265

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[269]: SELECT URL_POBLACION, ID_POBLACION
            FROM LO_POBLACION_PT PO
            WHERE PO.ID_POBLACION = 70060
                AND PO.IDIOMA = 'pt';

Tiempo de la consulta: 0.00034499168395996

Tiempo acumulado:0.89913105964661

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[270]: SELECT LO.ID_PRECIO
            FROM LO_LANDING_OFERTAS LO
            WHERE LO.STATUS = 2
                AND LO.ID_SECTOR = 19
                AND LO.ID_POBLACION = 70060;

Tiempo de la consulta: 0.00049686431884766

Tiempo acumulado:0.89962792396545

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[271]: SELECT PRESTAT.N_OPINIONES OPIS, PRESTAT.N_VENTAS AS VENTAS , PRE.ID_PRECIO, SEC.ID_SECTOR, ID_REGION_PRE
            FROM LO_PRECIOS PRE
            INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'ch'
            LEFT JOIN LO_PRECIOS_PUBLI PP ON PRE.ID_PRECIO = PP.ID_PRECIO_PP
            LEFT JOIN LO_PRECIOS_STATS PRESTAT ON PRESTAT.ID_PRECIO = PRE.ID_PRECIO
            LEFT JOIN LO_PRECIOS_DESCUENTOS PD ON PD.ID_PRECIO_PD = PRE.ID_PRECIO
                AND PD.VALID_PD = 1
            INNER JOIN LO_PRECIOS_SECTORES PS ON PS.ID_PRECIO_PS = PRE.ID_PRECIO
            INNER JOIN LO_SECTORES SEC ON SEC.ID_SECTOR = PS.ID_ACTIVIDAD_PS
            INNER JOIN LO_EMPRESAS_STAT EMPS ON EMPS.FK_ID_EST = PRE.ID_EMPRESA_PRE
            INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
                AND (EMP.VALID = 1 )
            LEFT JOIN LO_LANDING_OFERTAS LO ON LO.ID_PRECIO = PRE.ID_PRECIO
                AND LO.STATUS = 1
                AND LO.ID_SECTOR = 19
                AND LO.ID_POBLACION = 70060
            LEFT JOIN LO_PRECIOS_RESTRICCIONES PR ON PRE.ID_PRECIO = PR.ID_PRECIO
            WHERE PRE.VALID_PRE = 4
                AND PS.ID_ACTIVIDAD_PS = 19
                AND ( PRE.ID_REGION_PRE='756' OR PP.ID_REGION_PP='756' )
                AND PRE.ID_POBLACION_PRE = 70060
            GROUP BY PRE.ID_PRECIO
            ORDER BY LO.STATUS DESC, VENTAS DESC, OPIS DESC
            LIMIT 4;

Tiempo de la consulta: 0.0013229846954346

Tiempo acumulado:0.90095090866089

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[272]: SELECT '2' as TIPO, PRESTAT.N_OPINIONES OPIS, PRESTAT.N_VENTAS AS VENTAS , PO.DESC_POBLACION, PRE.ID_PRECIO, SECI.ID_SECTOR, SECI.DESC_SECTOR, SECI.URL URL_SECTOR, REI.ID_REGION, REI.URL URL_REGION, REI.DESC_REGION, PP.ID_REGION_PP, PP.DESCRIPCION_PP, PRE.MIN_PERS_PRE, PD.MIN_PERSONAS_PD,PRE.MAX_PERS_PRE,PD.MAX_PERSONAS_PD,PRE.ALOJAMIENTO_PRE, PRE.COMIDA_PRE,PRE.TRANSPORTE_PRE,REI.DESC_REGION,PRE.FOTOPRINCIPAL_PRE, PRE.GALERIA_PRE,EMPS.CENTRAL_ACTIVA, PRE.MULTIACTIVIDAD_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, PD.OFERTA_PD, 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, TRUNCATE(AVG(OP.VALORACION),0) AS VALORACION, PD.OFERTA_PD,VALID_PD, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, PRECIO_UNITARIO_PRE ,IF ( PRE.MIN_PERS_PRE > MIN(PD.MIN_PERSONAS_PD)
                AND PD.MIN_PERSONAS_PD IS NOT NULL, MIN(PD.MIN_PERSONAS_PD), PRE.MIN_PERS_PRE ) AS MIN_PERSONAS_PD ,IF ( PRE.MAX_PERS_PRE < MAX(PD.MAX_PERSONAS_PD)
                AND PD.MAX_PERSONAS_PD IS NOT NULL, MAX(PD.MAX_PERSONAS_PD), PRE.MAX_PERS_PRE ) AS MAX_PERSONAS_PD ,IF(PD.PRECIO_PD > 0
                AND PD.VALID_PD = 1, (1 - (MIN(PD.PRECIO_PD) / PRE.PRECIO_PRE))*100 , 0) AS DESCUENTO
            FROM LO_PRECIOS PRE
            INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'ch'
            LEFT JOIN LO_PRECIOS_PUBLI PP ON PRE.ID_PRECIO = PP.ID_PRECIO_PP
            LEFT JOIN LO_RESERVAS_COMPRAS RC ON PRE.ID_PRECIO = RC.ID_PRECIO_RC
                AND RC.VALID_RC NOT IN (0, 2, 6, 7)
            LEFT JOIN LO_PRECIOS_STATS PRESTAT ON PRESTAT.ID_PRECIO = PRE.ID_PRECIO
            LEFT JOIN LO_PRECIOS_DESCUENTOS PD ON PD.ID_PRECIO_PD = PRE.ID_PRECIO
                AND PD.VALID_PD = 1
            INNER JOIN LO_PRECIOS_SECTORES PS ON PS.ID_PRECIO_PS = PRE.ID_PRECIO
            INNER JOIN LO_SECTORES SEC ON SEC.ID_SECTOR = PS.ID_ACTIVIDAD_PS
            INNER JOIN LO_EMPRESAS_STAT EMPS ON EMPS.FK_ID_EST = PRE.ID_EMPRESA_PRE
            INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
                AND (EMP.VALID = 1 )
            INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = PS.ID_ACTIVIDAD_PS
                AND (SECI.FK_ID_IDIOMA_SI18N = 'ch'
                AND SECI.ID_TROPIC = 86)
            INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PRE.ID_REGION_PRE
                AND REI.IDIOMA = 'ch'
            INNER JOIN LO_POBLACION_PT PO ON PRE.ID_POBLACION_PRE = PO.ID_POBLACION
                AND PO.IDIOMA = 'ch'
            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 1 = 1
                AND PRE.ID_PRECIO IN (72691, 72654)
                AND PRE.VALID_PRE = 4
                AND PS.ID_ACTIVIDAD_PS = 19
                AND ( PRE.ID_REGION_PRE='756' OR PP.ID_REGION_PP='756' )
                AND PRE.ID_POBLACION_PRE = 70060
            GROUP BY PRE.ID_PRECIO
            ORDER BY VENTAS DESC, OPIS DESC
            LIMIT 4;

Tiempo de la consulta: 0.0033340454101562

Tiempo acumulado:0.90428495407104

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[273]: SELECT PRESTAT.N_OPINIONES OPIS, PRESTAT.N_VENTAS AS VENTAS , PRE.ID_PRECIO, SEC.ID_SECTOR, ID_REGION_PRE
            FROM LO_PRECIOS PRE
            INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'ch'
            LEFT JOIN LO_PRECIOS_PUBLI PP ON PRE.ID_PRECIO = PP.ID_PRECIO_PP
            LEFT JOIN LO_PRECIOS_STATS PRESTAT ON PRESTAT.ID_PRECIO = PRE.ID_PRECIO
            LEFT JOIN LO_PRECIOS_DESCUENTOS PD ON PD.ID_PRECIO_PD = PRE.ID_PRECIO
                AND PD.VALID_PD = 1
            INNER JOIN LO_PRECIOS_SECTORES PS ON PS.ID_PRECIO_PS = PRE.ID_PRECIO
            INNER JOIN LO_SECTORES SEC ON SEC.ID_SECTOR = PS.ID_ACTIVIDAD_PS
            INNER JOIN LO_EMPRESAS_STAT EMPS ON EMPS.FK_ID_EST = PRE.ID_EMPRESA_PRE
            INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
                AND (EMP.VALID = 1 )
            LEFT JOIN LO_LANDING_OFERTAS LO ON LO.ID_PRECIO = PRE.ID_PRECIO
                AND LO.STATUS = 1
                AND LO.ID_SECTOR = 19
                AND LO.ID_POBLACION = 70060
            LEFT JOIN LO_PRECIOS_RESTRICCIONES PR ON PRE.ID_PRECIO = PR.ID_PRECIO
            WHERE PRE.VALID_PRE = 4
                AND PS.ID_ACTIVIDAD_PS = 19
                AND ( PRE.ID_REGION_PRE='756' OR PP.ID_REGION_PP='756' )
                AND PRE.ID_POBLACION_PRE = 70060
            GROUP BY PRE.ID_PRECIO
            ORDER BY LO.STATUS DESC, VENTAS DESC, OPIS DESC
            LIMIT 4;

Tiempo de la consulta: 0.002377986907959

Tiempo acumulado:0.906662940979

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[274]: SELECT '2' as TIPO, PRESTAT.N_OPINIONES OPIS, PRESTAT.N_VENTAS AS VENTAS , PO.DESC_POBLACION, PRE.ID_PRECIO, SECI.ID_SECTOR, SECI.DESC_SECTOR, SECI.URL URL_SECTOR, REI.ID_REGION, REI.URL URL_REGION, REI.DESC_REGION, PP.ID_REGION_PP, PP.DESCRIPCION_PP, PRE.MIN_PERS_PRE, PD.MIN_PERSONAS_PD,PRE.MAX_PERS_PRE,PD.MAX_PERSONAS_PD,PRE.ALOJAMIENTO_PRE, PRE.COMIDA_PRE,PRE.TRANSPORTE_PRE,REI.DESC_REGION,PRE.FOTOPRINCIPAL_PRE, PRE.GALERIA_PRE,EMPS.CENTRAL_ACTIVA, PRE.MULTIACTIVIDAD_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, PD.OFERTA_PD, 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, TRUNCATE(AVG(OP.VALORACION),0) AS VALORACION, PD.OFERTA_PD,VALID_PD, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, PRECIO_UNITARIO_PRE ,IF ( PRE.MIN_PERS_PRE > MIN(PD.MIN_PERSONAS_PD)
                AND PD.MIN_PERSONAS_PD IS NOT NULL, MIN(PD.MIN_PERSONAS_PD), PRE.MIN_PERS_PRE ) AS MIN_PERSONAS_PD ,IF ( PRE.MAX_PERS_PRE < MAX(PD.MAX_PERSONAS_PD)
                AND PD.MAX_PERSONAS_PD IS NOT NULL, MAX(PD.MAX_PERSONAS_PD), PRE.MAX_PERS_PRE ) AS MAX_PERSONAS_PD ,IF(PD.PRECIO_PD > 0
                AND PD.VALID_PD = 1, (1 - (MIN(PD.PRECIO_PD) / PRE.PRECIO_PRE))*100 , 0) AS DESCUENTO
            FROM LO_PRECIOS PRE
            INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'ch'
            LEFT JOIN LO_PRECIOS_PUBLI PP ON PRE.ID_PRECIO = PP.ID_PRECIO_PP
            LEFT JOIN LO_RESERVAS_COMPRAS RC ON PRE.ID_PRECIO = RC.ID_PRECIO_RC
                AND RC.VALID_RC NOT IN (0, 2, 6, 7)
            LEFT JOIN LO_PRECIOS_STATS PRESTAT ON PRESTAT.ID_PRECIO = PRE.ID_PRECIO
            LEFT JOIN LO_PRECIOS_DESCUENTOS PD ON PD.ID_PRECIO_PD = PRE.ID_PRECIO
                AND PD.VALID_PD = 1
            INNER JOIN LO_PRECIOS_SECTORES PS ON PS.ID_PRECIO_PS = PRE.ID_PRECIO
            INNER JOIN LO_SECTORES SEC ON SEC.ID_SECTOR = PS.ID_ACTIVIDAD_PS
            INNER JOIN LO_EMPRESAS_STAT EMPS ON EMPS.FK_ID_EST = PRE.ID_EMPRESA_PRE
            INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
                AND (EMP.VALID = 1 )
            INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = PS.ID_ACTIVIDAD_PS
                AND (SECI.FK_ID_IDIOMA_SI18N = 'ch'
                AND SECI.ID_TROPIC = 86)
            INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PRE.ID_REGION_PRE
                AND REI.IDIOMA = 'ch'
            INNER JOIN LO_POBLACION_PT PO ON PRE.ID_POBLACION_PRE = PO.ID_POBLACION
                AND PO.IDIOMA = 'ch'
            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 1 = 1
                AND PRE.ID_PRECIO IN (72691, 72654)
                AND PRE.VALID_PRE = 4
                AND PS.ID_ACTIVIDAD_PS = 19
                AND ( PRE.ID_REGION_PRE='756' OR PP.ID_REGION_PP='756' )
                AND PRE.ID_POBLACION_PRE = 70060
            GROUP BY PRE.ID_PRECIO
            ORDER BY VENTAS DESC, OPIS DESC
            LIMIT 4;

Tiempo de la consulta: 0.0041351318359375

Tiempo acumulado:0.91079807281494

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[275]: SELECT URL_PRE, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, ID_PRECIO, FK_ID_PAIS_PRE
            FROM LO_PRECIOS PRE
            INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'ch'
            WHERE PRE.ID_PRECIO = 72691;

Tiempo de la consulta: 0.0020959377288818

Tiempo acumulado:0.91289401054382

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

Tiempo de la consulta: 0.0026190280914307

Tiempo acumulado:0.91551303863525

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[277]: SELECT URL_PRE, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, ID_PRECIO, FK_ID_PAIS_PRE
            FROM LO_PRECIOS PRE
            INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'ch'
            WHERE PRE.ID_PRECIO = 72654;

Tiempo de la consulta: 0.00076699256896973

Tiempo acumulado:0.91628003120422

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

Tiempo de la consulta: 0.00046992301940918

Tiempo acumulado:0.91674995422363

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[279]: SELECT LUO.ID_OPINION, LUO.ID_PRECIO,VALORACION, LUOF.FOTO_OPINION, LUOF.POSICION_FOTO_PRECIO, LUOF.ID_OPINION AS ID_OPINION_FOTO, LUOF.ID_RESERVA AS ID_RESERVA_FOTO, LUO.FEC_OPINION
            FROM LO_LISTADOS_ULTIMAS_OPINIONES LUO
            LEFT JOIN LO_LISTADOS_ULTIMAS_OPINIONES_FOTOS LUOF ON LUOF.ID_LISTADO_ULTIMAS_OPINIONES = LUO.ID
            WHERE ID_SECTOR = 19
                AND ID_POBLACION = 70060
                AND ID_REGION_ADM IS NULL
                AND ID_REGION IS NULL
                AND ID_PAIS IS NULL
            GROUP BY ID_OPINION
            ORDER BY ID_OPINION DESC
            LIMIT 6;

Tiempo de la consulta: 0.00090909004211426

Tiempo acumulado:0.91765904426575

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[280]: SELECT N_OPIS AS TOTAL, MEDIA_OPIS_5 AS MEDIA, ROUND(MEDIA_OPIS_100,0) AS MEDIA2
            FROM LO_POBLACION_PT_STATS
            WHERE ID_POBLACION = 70060
                AND ID_SECTOR = 19;

Tiempo de la consulta: 0.00051212310791016

Tiempo acumulado:0.91817116737366

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[281]: SELECT SSF.DESC_SSF,SSF.ID_SSF,SS.INDEXA_SS, SS.ID_SUBFAM_SS
            FROM LO_SUBSECTORES_FAM SSF
            INNER JOIN LO_SUBSECTORES SS ON SS.ID_FAM_SS=SSF.ID_SSF
                AND (SS.ID_TROPIC = 86)
            INNER JOIN LO_PRECIOS_SUBSECTORES PSS ON SS.ID_SUBSECTOR=PSS.ID_ACTIVIDAD_PSS
            INNER JOIN LO_PRECIOS PRE ON PSS.ID_PRECIO_PSS = PRE.ID_PRECIO
            LEFT JOIN LO_PRECIOS_PUBLI PP ON PP.ID_PRECIO_PP = PRE.ID_PRECIO
            INNER JOIN LO_PRECIOS_TRADUCCION_CH PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'ch'
            WHERE SS.ID_SECTOR_SS=19
                AND SSF.ID_TROPIC = 86
            GROUP BY SSF.ID_SSF
            ORDER BY COUNT(SSF.ID_SSF) DESC;

Tiempo de la consulta: 0.00086188316345215

Tiempo acumulado:0.91903305053711

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[282]: SELECT LSR.ID_SECTOR_RELACIONADO AS ID_SECTOR, SECI.DESC_SECTOR, SECI.URL AS URL_SECTOR, PRE.ID_PRECIO, PRE.FOTOPRINCIPAL_PRE
            FROM LO_LANDING_SECTORES_RELACION LSR
            INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = LSR.ID_SECTOR_RELACIONADO
                AND SECI.FK_ID_IDIOMA_SI18N = 'ch'
                AND ID_TROPIC = 86
            INNER JOIN LO_PRECIOS_SECTORES PS ON PS.ID_ACTIVIDAD_PS = LSR.ID_SECTOR_RELACIONADO
            INNER JOIN LO_PRECIOS PRE ON PRE.ID_PRECIO = PS.ID_PRECIO_PS
                AND PRE.VALID_PRE = 4
            INNER JOIN LO_REGION RE ON RE.ID_REGION = PRE.ID_REGION_PRE
            LEFT JOIN LO_PRECIOS_PUBLI PP ON PP.ID_PRECIO_PP = PRE.ID_PRECIO
            LEFT JOIN LO_PRECIOS_RESTRICCIONES PR ON PRE.ID_PRECIO = PR.ID_PRECIO
            WHERE LSR.ID_SECTOR = 19
                AND (PRE.ID_POBLACION_PRE = 70060 OR ID_POBLACION_PP = 70060)
                AND (PR.POBLACION = 0 OR PR.POBLACION 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 LSR.ID_SECTOR_RELACIONADO;

Tiempo de la consulta: 0.0026090145111084

Tiempo acumulado:0.92164206504822

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[283]: SELECT SEO.DESCRIPTION
            FROM LO_SEO_DESCRIPTIONS SEO
            WHERE SEO.ID_TROPIC='86'
                AND SEO.ID_KEY='S19';

Tiempo de la consulta: 0.00081992149353027

Tiempo acumulado:0.92246198654175

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[284]: 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 = 86
            WHERE SEOHOME.ID_TROPIC = 86
                AND SEOHOME.ID_KEY = 'S19'
                AND SEO_VALID in (0,1)
                AND SEOHOME.ID_LOCALIZACION='70060';

Tiempo de la consulta: 0.010812997817993

Tiempo acumulado:0.93327498435974

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[285]: 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, PO.DESC_POBLACION, PO.URL_POBLACION, PO.ID_POBLACION, RE.ID_REGION_ADM1, RE.ID_PAIS FROM LO_POBLACION_PT_STATS PS
            INNER JOIN LO_POBLACION_PT PO ON PO.ID_POBLACION = PS.ID_POBLACION
                AND PO.IDIOMA = 'ch'
            INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PO.ID_REGION
                AND REI.IDIOMA = 'ch'
            INNER JOIN LO_REGION RE ON RE.ID_REGION = REI.ID_REGION
                AND IF(RE.ID_CAPITAL = PO.ID_POBLACION
                AND RE.SIMCAPN = 1, 1=2, 1=1)
            INNER JOIN LO_SECTORES_I18N SECI ON PS.ID_SECTOR = SECI.ID_SECTOR
                AND SECI.ID_TROPIC='86'
                AND SECI.FK_ID_IDIOMA_SI18N = 'ch'
            WHERE REI.ID_REGION = 756
                AND PS.ID_SECTOR = 19
                AND (PS.N_OFERTAS > 0
                AND PS.N_OFERTAS IS NOT NULL)
            ORDER BY NEMPRESAS DESC;

Tiempo de la consulta: 0.0017659664154053

Tiempo acumulado:0.93504095077515

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

Tiempo de la consulta: 0.00092697143554688

Tiempo acumulado:0.93596792221069

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[287]: SELECT URL_POBLACION, ID_POBLACION
            FROM LO_POBLACION_PT PO
            WHERE PO.ID_POBLACION = 76856
                AND PO.IDIOMA = 'pt';

Tiempo de la consulta: 0.0004270076751709

Tiempo acumulado:0.93639492988586

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

Tiempo de la consulta: 0.00092291831970215

Tiempo acumulado:0.93731784820557

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[289]: SELECT URL_POBLACION, ID_POBLACION
            FROM LO_POBLACION_PT PO
            WHERE PO.ID_POBLACION = 70060
                AND PO.IDIOMA = 'pt';

Tiempo de la consulta: 0.0004417896270752

Tiempo acumulado:0.93775963783264

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

Tiempo de la consulta: 0.00036907196044922

Tiempo acumulado:0.93812870979309

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[291]: SELECT URL_POBLACION, ID_POBLACION
            FROM LO_POBLACION_PT PO
            WHERE PO.ID_POBLACION = 78275
                AND PO.IDIOMA = 'pt';

Tiempo de la consulta: 0.00061988830566406

Tiempo acumulado:0.93874859809875

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

Tiempo de la consulta: 0.00060176849365234

Tiempo acumulado:0.93935036659241

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[293]: SELECT URL_POBLACION, ID_POBLACION
            FROM LO_POBLACION_PT PO
            WHERE PO.ID_POBLACION = 80899
                AND PO.IDIOMA = 'pt';

Tiempo de la consulta: 0.00078392028808594

Tiempo acumulado:0.94013428688049

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

Tiempo de la consulta: 0.00042295455932617

Tiempo acumulado:0.94055724143982

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[295]: SELECT URL_POBLACION, ID_POBLACION
            FROM LO_POBLACION_PT PO
            WHERE PO.ID_POBLACION = 84001
                AND PO.IDIOMA = 'pt';

Tiempo de la consulta: 0.003835916519165

Tiempo acumulado:0.94439315795898

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[296]: SELECT REI.DESC_REGION, REI.URL AS URL_REGION, PO.DESC_POBLACION, PO.URL_POBLACION, POS.N_OFERTAS
            FROM LO_POBLACION_REGION_MULTIPLE PRM
            INNER JOIN LO_POBLACION_PT PO ON PO.ID_POBLACION = PRM.ID_POBLACION
                AND PO.IDIOMA = 'ch'
            INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PO.ID_REGION
                AND REI.IDIOMA = 'ch'
            INNER JOIN LO_POBLACION_PT_STATS POS ON POS.ID_POBLACION = PO.ID_POBLACION
                AND POS.ID_SECTOR = 19
                AND POS.N_OFERTAS > 1
            WHERE PRM.ID_REGION = 756;

Tiempo de la consulta: 0.0012609958648682

Tiempo acumulado:0.94565415382385

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

Tiempo de la consulta: 0.0013740062713623

Tiempo acumulado:0.94702816009521

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

Tiempo de la consulta: 0.0020849704742432

Tiempo acumulado:0.94911313056946

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

Tiempo de la consulta: 0.00055789947509766

Tiempo acumulado:0.94967103004456

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[300]: SELECT ID_REGION
            FROM LO_POBLACION
            WHERE ID_POBLACION='70060'
            LIMIT 1;

Tiempo de la consulta: 0.002410888671875

Tiempo acumulado:0.95208191871643

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[301]: SELECT ID_REGION_ADM1
            FROM LO_REGION
            WHERE ID_REGION='756'
            LIMIT 1;

Tiempo de la consulta: 0.00054311752319336

Tiempo acumulado:0.95262503623962

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[302]: SELECT SEO.KEYWORD
            FROM LO_SEO_KEYWORDS SEO
            WHERE SEO.ID_KEY = 'S19'
                AND (SEO.ID_TROPIC = 86
                AND (FK_ID_REG_ADM = 0 OR FK_ID_REG_ADM='104') );

Tiempo de la consulta: 0.00065994262695312

Tiempo acumulado:0.95328497886658

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[303]: SELECT ID_REGION
            FROM LO_POBLACION
            WHERE ID_POBLACION='70060'
            LIMIT 1;

Tiempo de la consulta: 0.0012829303741455

Tiempo acumulado:0.95456790924072

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[304]: SELECT ID_REGION_ADM1
            FROM LO_REGION
            WHERE ID_REGION='756'
            LIMIT 1;

Tiempo de la consulta: 0.00094318389892578

Tiempo acumulado:0.95551109313965

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[305]: SELECT SEO.KEYWORD
            FROM LO_SEO_KEYWORDS SEO
            WHERE SEO.ID_KEY = 'S20'
                AND (SEO.ID_TROPIC = 86
                AND (FK_ID_REG_ADM = 0 OR FK_ID_REG_ADM='104') );

Tiempo de la consulta: 0.00087094306945801

Tiempo acumulado:0.95638203620911

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[306]: SELECT ID_REGION
            FROM LO_POBLACION
            WHERE ID_POBLACION='70060'
            LIMIT 1;

Tiempo de la consulta: 0.00095701217651367

Tiempo acumulado:0.95733904838562

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[307]: SELECT ID_REGION_ADM1
            FROM LO_REGION
            WHERE ID_REGION='756'
            LIMIT 1;

Tiempo de la consulta: 0.0011651515960693

Tiempo acumulado:0.95850419998169

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[308]: SELECT SEO.KEYWORD
            FROM LO_SEO_KEYWORDS SEO
            WHERE SEO.ID_KEY = 'S34'
                AND (SEO.ID_TROPIC = 86
                AND (FK_ID_REG_ADM = 0 OR FK_ID_REG_ADM='104') );

Tiempo de la consulta: 0.00078105926513672

Tiempo acumulado:0.95928525924683

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[309]: SELECT ID_REGION
            FROM LO_POBLACION
            WHERE ID_POBLACION='70060'
            LIMIT 1;

Tiempo de la consulta: 0.00051689147949219

Tiempo acumulado:0.95980215072632

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[310]: SELECT ID_REGION_ADM1
            FROM LO_REGION
            WHERE ID_REGION='756'
            LIMIT 1;

Tiempo de la consulta: 0.00091195106506348

Tiempo acumulado:0.96071410179138

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[311]: SELECT SEO.KEYWORD
            FROM LO_SEO_KEYWORDS SEO
            WHERE SEO.ID_KEY = 'S17'
                AND (SEO.ID_TROPIC = 86
                AND (FK_ID_REG_ADM = 0 OR FK_ID_REG_ADM='104') );

Tiempo de la consulta: 0.00092601776123047

Tiempo acumulado:0.96164011955261

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[312]: SELECT ID_REGION
            FROM LO_POBLACION
            WHERE ID_POBLACION='70060'
            LIMIT 1;

Tiempo de la consulta: 0.0089888572692871

Tiempo acumulado:0.9706289768219

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[313]: SELECT ID_REGION_ADM1
            FROM LO_REGION
            WHERE ID_REGION='756'
            LIMIT 1;

Tiempo de la consulta: 0.00089383125305176

Tiempo acumulado:0.97152280807495

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[314]: SELECT SEO.KEYWORD
            FROM LO_SEO_KEYWORDS SEO
            WHERE SEO.ID_KEY = 'S18'
                AND (SEO.ID_TROPIC = 86
                AND (FK_ID_REG_ADM = 0 OR FK_ID_REG_ADM='104') );

Tiempo de la consulta: 0.0028941631317139

Tiempo acumulado:0.97441697120667

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[315]: SELECT ID_REGION
            FROM LO_POBLACION
            WHERE ID_POBLACION='70060'
            LIMIT 1;

Tiempo de la consulta: 0.010051012039185

Tiempo acumulado:0.98446798324585

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[316]: SELECT ID_REGION_ADM1
            FROM LO_REGION
            WHERE ID_REGION='756'
            LIMIT 1;

Tiempo de la consulta: 0.0099430084228516

Tiempo acumulado:0.9944109916687

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[317]: SELECT SEO.KEYWORD
            FROM LO_SEO_KEYWORDS SEO
            WHERE SEO.ID_KEY = 'S33'
                AND (SEO.ID_TROPIC = 86
                AND (FK_ID_REG_ADM = 0 OR FK_ID_REG_ADM='104') );

Tiempo de la consulta: 0.00394606590271

Tiempo acumulado:0.99835705757141

(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[318]: SELECT *
            FROM LO_REGION
            INNER JOIN LO_REGION_I18N ON LO_REGION.ID_REGION = LO_REGION_I18N.ID_REGION
            WHERE IDIOMA = 'ch'
            ORDER BY DESC_REGION ASC;

Tiempo de la consulta: 0.010393857955933

Tiempo acumulado:1.0087509155273

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

Tiempo de la consulta: 0.0094199180603027

Tiempo acumulado:1.0181708335876

.Cerramos Conexiones BB.DD.

热气球飞行 Alvor 2 價格和優惠 2025

2 结果

儿童乘坐热气球飞越阿尔加维阿尔沃尔 1 小时

乘坐热气球飞越阿尔沃 (Alvor)，阿尔加维 (Algarve) 成人 1 小时

在 Yumping，您有 3 种选择可以赠送！

在购物车中选择发送礼品邮件。

在购物车中选择邮寄礼盒。

3.礼品卡

Alvor: 所有目的地

Alvor：相關活動

信息