5

6 Risultati

Filtri
Mappa
    Scuderia Castello | COM: 20.00% | VTAS AÑO: 7 | DEVOS AÑO: 71.43% | DISPO PRÓX 3M FINDES: 100%
  • 7

    Tour a cavallo con degustazione lago di Garda 90m

    Tour a cavallo con degustazione lago di Garda 90m

    Toscolano Maderno, Brescia - Distanza: 10Km
    (4 recensioni) Eccellente 
    47 Prenotazioni Verificate
    Più Venduti
    da 50€ prezzo/persona
  • ASD Circolo Ippico La Collina | COM: 20.00% | VTAS AÑO: 1 | DEVOS AÑO: 71.43% | DISPO PRÓX 3M FINDES: 100%
  • 4

    Lezione e Tour a cavallo nel Lago di Garda 1h30m

    Lezione e Tour a cavallo nel Lago di Garda 1h30m

    Gavardo, Brescia - Distanza: 21Km
    (2 recensioni) Eccellente 
    7 Prenotazioni Verificate
    da 43€ prezzo/persona
  • ASD Circolo Ippico La Collina | COM: 20.00% | VTAS AÑO: 1 | DEVOS AÑO: 71.43% | DISPO PRÓX 3M FINDES: 100%
  • 5

    Tour a cavallo nei pressi del Lago di Garda di 2h

    Tour a cavallo nei pressi del Lago di Garda di 2h

    Gavardo, Brescia - Distanza: 21Km
    (2 recensioni) Eccellente 
    4 Prenotazioni Verificate
    da 50€ prezzo/persona
  • ASD Circolo Ippico La Collina | COM: 20.00% | VTAS AÑO: 1 | DEVOS AÑO: 71.43% | DISPO PRÓX 3M FINDES: 100%
  • 5

    Tour a cavallo nei pressi del Lago di Garda di 1h

    Tour a cavallo nei pressi del Lago di Garda di 1h

    Gavardo, Brescia - Distanza: 21Km
    (2 recensioni) Eccellente 
    6 Prenotazioni Verificate
    da 30€ prezzo/persona
  • ASD Circolo Ippico La Collina | COM: 20.00% | VTAS AÑO: 0 | DEVOS AÑO: 71.43% | DISPO PRÓX 3M FINDES: 100%
  • 5

    Lezione di equitazione sul Lago di Garda di 1h

    Lezione di equitazione sul Lago di Garda di 1h

    Gavardo, Brescia - Distanza: 21Km
    (2 recensioni) Eccellente 
    1 Prenotazione Verificata
    da 30€ prezzo/persona
  • ASD Circolo Ippico La Collina | COM: 20.00% | VTAS AÑO: 0 | DEVOS AÑO: 71.43% | DISPO PRÓX 3M FINDES: 100%
  • 5

    Passeggiata a cavallo vicino al Lago di Garda 3h

    Passeggiata a cavallo vicino al Lago di Garda 3h

    Gavardo, Brescia - Distanza: 21Km
    (2 recensioni) Eccellente 
    1 Prenotazione Verificata
    da 80€ prezzo/persona

Hai 3 opzioni da regalare in Yumping!

MI ISCRIVO!

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


prod.yumping.com


/landings/landing.php


BBDD->Prod_Yumping_it_IT
AMBITO->it
AMBITO_AJAX->it
AMBITO_AJAX COOKIE->es
locale LO_CONFIG->it_IT
locale php->it_IT
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->it
filtro1->passeggiate-a-cavallo
filtro2->verona
filtro3->lago-di-garda
rel_alternate->1
paginado_ofertas->
npage->

Total queries: 351

Tiempo total: 0.49369406700134


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


Tiempo de la consulta: 0.0079898834228516

Tiempo acumulado:0.0079898834228516



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

Tiempo acumulado:0.0086119174957275



(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 = 'verona' 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 = 'verona' 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 = 'verona' 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 = 'verona' 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 = 'verona' 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 = 'verona' 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 = 'verona' 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 = 'verona' 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 = 'verona' 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 = 'verona' 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 = 'verona' 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 = 'verona' )AS FIND_REGION
            GROUP BY ID_PAIS;


Tiempo de la consulta: 0.0040349960327148

Tiempo acumulado:0.012646913528442



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


Tiempo de la consulta: 0.007159948348999

Tiempo acumulado:0.019806861877441



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


Tiempo de la consulta: 0.0004580020904541

Tiempo acumulado:0.020264863967896



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


Tiempo de la consulta: 0.00035405158996582

Tiempo acumulado:0.020618915557861



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


Tiempo de la consulta: 0.00052618980407715

Tiempo acumulado:0.021145105361938



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


Tiempo de la consulta: 0.00040102005004883

Tiempo acumulado:0.021546125411987



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


Tiempo de la consulta: 0.0003659725189209

Tiempo acumulado:0.021912097930908



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


Tiempo de la consulta: 0.00035405158996582

Tiempo acumulado:0.022266149520874



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


Tiempo de la consulta: 0.00036811828613281

Tiempo acumulado:0.022634267807007



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[12]: SELECT G.DESC_GRUPO, G.ID_GRUPO, G.URL AS URL_GRUPO
            FROM LO_GRUPOS G
            WHERE G.URL = 'passeggiate-a-cavallo'
                AND G.ID_TROPIC = 3;


Tiempo de la consulta: 0.00051689147949219

Tiempo acumulado:0.023151159286499



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


Tiempo de la consulta: 0.00039386749267578

Tiempo acumulado:0.023545026779175



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


Tiempo de la consulta: 0.00041294097900391

Tiempo acumulado:0.023957967758179



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


Tiempo de la consulta: 0.00053000450134277

Tiempo acumulado:0.024487972259521



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[16]: 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 = 'passeggiate-a-cavallo'
                AND ID_TROPIC = 3
                AND SECI.FK_ID_IDIOMA_SI18N = 'it'
            LIMIT 1;


Tiempo de la consulta: 0.00054597854614258

Tiempo acumulado:0.025033950805664



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[17]: SELECT DESC_POBLACION,ID_POBLACION,URL_POBLACION
            FROM LO_POBLACION_IT PO
            WHERE ID_REGION='533'
                AND ID_POBLACION='lago-di-garda'
                AND IDIOMA = 'it'
            LIMIT 1;


Tiempo de la consulta: 0.00039100646972656

Tiempo acumulado:0.025424957275391



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[18]: SELECT DESC_POBLACION,ID_POBLACION,URL_POBLACION
            FROM LO_POBLACION_IT PO
            WHERE ID_REGION='533'
                AND URL_POBLACION='lago-di-garda'
                AND IDIOMA = 'it'
            LIMIT 1;


Tiempo de la consulta: 0.0020248889923096

Tiempo acumulado:0.0274498462677



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


Tiempo de la consulta: 0.00035405158996582

Tiempo acumulado:0.027803897857666



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


Tiempo de la consulta: 0.00039291381835938

Tiempo acumulado:0.028196811676025



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


Tiempo de la consulta: 0.0010168552398682

Tiempo acumulado:0.029213666915894



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[22]: SELECT DESC_POBLACION,ID_POBLACION,URL_POBLACION
            FROM LO_POBLACION_IT PO
            WHERE ID_REGION='533'
                AND ID_POBLACION='2000077'
                AND IDIOMA = 'it'
            LIMIT 1;


Tiempo de la consulta: 0.00039005279541016

Tiempo acumulado:0.029603719711304



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[23]: SELECT *
            FROM LO_REGION_SKI REI
            WHERE URL = 'verona'
                AND REI.IDIOMA='it'
                AND TIPO = 1;


Tiempo de la consulta: 0.00040411949157715

Tiempo acumulado:0.030007839202881



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


Tiempo de la consulta: 0.00037717819213867

Tiempo acumulado:0.03038501739502



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[25]: 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
            WHERE EMP.VALID IN (1)
                AND RE.ID_REGION = 533
                AND EMP.EMP_MADRE <> 0
                AND PO.ID_POBLACION = 2000077
                AND EMP.ID_SECTOR = 21
            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 = 533)
            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.0022451877593994

Tiempo acumulado:0.032630205154419



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

Tiempo de la consulta: 0.00028705596923828

Tiempo acumulado:0.032917261123657



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[27]: 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_IT_STATS
            WHERE ID_POBLACION = 2000077
                AND ID_SECTOR = 21
            GROUP BY ID_SECTOR;


Tiempo de la consulta: 0.00038599967956543

Tiempo acumulado:0.033303260803223



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[28]: 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 = 3
            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
            WHERE SS.ID_TROPIC = 3
                AND VALID_PRE=4
                AND ID_SECTOR_SS = '21'
                AND (PRE.ID_POBLACION_PRE = 2000077 OR ID_POBLACION_PP = 2000077 )
            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.0081350803375244

Tiempo acumulado:0.041438341140747



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[29]: SELECT SEO.DESCRIPTION
            FROM LO_SEO_DESCRIPTIONS SEO
            WHERE SEO.ID_TROPIC='3'
                AND SEO.ID_KEY='S21';


Tiempo de la consulta: 0.0015158653259277

Tiempo acumulado:0.042954206466675



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[30]: 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 = 3
            WHERE SEOHOME.ID_TROPIC = 3
                AND SEOHOME.ID_KEY = 'S21'
                AND SEO_VALID in (0,1)
                AND SEOHOME.ID_LOCALIZACION='2000077';


Tiempo de la consulta: 0.0032949447631836

Tiempo acumulado:0.046249151229858



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


Tiempo de la consulta: 0.00046396255493164

Tiempo acumulado:0.04671311378479



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[32]: SELECT URL_POBLACION, ID_POBLACION
            FROM LO_POBLACION_IT PO
            WHERE PO.ID_POBLACION = 2000077
                AND PO.IDIOMA = 'it';


Tiempo de la consulta: 0.00061798095703125

Tiempo acumulado:0.047331094741821



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[33]: SELECT OLD_URL, NEW_URL
            FROM LO_URL_301 U
            WHERE U.OLD_URL = '/it/passeggiate-a-cavallo/verona/lago-di-garda';


Tiempo de la consulta: 0.00033688545227051

Tiempo acumulado:0.047667980194092



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[34]: SELECT *
            FROM LO_SEO_DESCRIPTIONS_HOME SEO
            WHERE SEO.ID_TROPIC='3'
                AND SEO.ID_KEY='S21'
                AND SEO.ID_LOCALIZACION='2000077';


Tiempo de la consulta: 0.0032198429107666

Tiempo acumulado:0.050887823104858



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


Tiempo de la consulta: 0.0017158985137939

Tiempo acumulado:0.052603721618652



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[36]: 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 = 'passeggiate-a-cavallo'
                AND ID_TROPIC = 3
                AND SECI.FK_ID_IDIOMA_SI18N = 'it'
            LIMIT 1;


Tiempo de la consulta: 0.00074195861816406

Tiempo acumulado:0.053345680236816



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


Tiempo de la consulta: 0.00061297416687012

Tiempo acumulado:0.053958654403687



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


Tiempo de la consulta: 0.0005340576171875

Tiempo acumulado:0.054492712020874



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


Tiempo de la consulta: 0.00047206878662109

Tiempo acumulado:0.054964780807495



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


Tiempo de la consulta: 0.00062894821166992

Tiempo acumulado:0.055593729019165



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


Tiempo de la consulta: 0.0005180835723877

Tiempo acumulado:0.056111812591553



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


Tiempo de la consulta: 0.00046992301940918

Tiempo acumulado:0.056581735610962



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


Tiempo de la consulta: 0.00055599212646484

Tiempo acumulado:0.057137727737427



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


Tiempo de la consulta: 0.00048995018005371

Tiempo acumulado:0.05762767791748



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


Tiempo de la consulta: 0.00045108795166016

Tiempo acumulado:0.058078765869141



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


Tiempo de la consulta: 0.00054287910461426

Tiempo acumulado:0.058621644973755



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


Tiempo de la consulta: 0.00042486190795898

Tiempo acumulado:0.059046506881714



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


Tiempo de la consulta: 0.00051403045654297

Tiempo acumulado:0.059560537338257



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


Tiempo de la consulta: 0.00047492980957031

Tiempo acumulado:0.060035467147827



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[50]: SELECT PO.ID_POBLACION_PADRE AS ID_POBLACION_PADRE,POI.DESC_POBLACION, POI.URL_POBLACION
            FROM LO_POBLACION PO, LO_POBLACION_IT POI
            WHERE POI.URL_POBLACION='lago-di-garda'
                AND POI.ID_REGION='533'
                AND IDIOMA = 'it'
                AND POI.ID_POBLACION=PO.ID_POBLACION
            ORDER BY PO.ID_POBLACION;


Tiempo de la consulta: 0.00055289268493652

Tiempo acumulado:0.060588359832764



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[51]: 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 = 'passeggiate-a-cavallo'
                AND ID_TROPIC = 3
                AND SECI.FK_ID_IDIOMA_SI18N = 'it'
            LIMIT 1;


Tiempo de la consulta: 0.00057792663574219

Tiempo acumulado:0.061166286468506



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


Tiempo de la consulta: 0.00057005882263184

Tiempo acumulado:0.061736345291138



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


Tiempo de la consulta: 0.00049901008605957

Tiempo acumulado:0.062235355377197



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


Tiempo de la consulta: 0.00047588348388672

Tiempo acumulado:0.062711238861084



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


Tiempo de la consulta: 0.00055789947509766

Tiempo acumulado:0.063269138336182



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


Tiempo de la consulta: 0.00049614906311035

Tiempo acumulado:0.063765287399292



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


Tiempo de la consulta: 0.00047898292541504

Tiempo acumulado:0.064244270324707



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


Tiempo de la consulta: 0.00052905082702637

Tiempo acumulado:0.064773321151733



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


Tiempo de la consulta: 0.00049901008605957

Tiempo acumulado:0.065272331237793



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


Tiempo de la consulta: 0.00049400329589844

Tiempo acumulado:0.065766334533691



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


Tiempo de la consulta: 0.00047993659973145

Tiempo acumulado:0.066246271133423



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


Tiempo de la consulta: 0.00041794776916504

Tiempo acumulado:0.066664218902588



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


Tiempo de la consulta: 0.00046205520629883

Tiempo acumulado:0.067126274108887



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


Tiempo de la consulta: 0.00045180320739746

Tiempo acumulado:0.067578077316284



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[65]: SELECT PO.ID_POBLACION_PADRE AS ID_POBLACION_PADRE,POI.DESC_POBLACION, POI.URL_POBLACION
            FROM LO_POBLACION PO, LO_POBLACION_IT POI
            WHERE POI.URL_POBLACION='lago-di-garda'
                AND POI.ID_REGION='533'
                AND IDIOMA = 'it'
                AND POI.ID_POBLACION=PO.ID_POBLACION
            ORDER BY PO.ID_POBLACION;


Tiempo de la consulta: 0.00055599212646484

Tiempo acumulado:0.068134069442749



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[66]: 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 = 'passeggiate-a-cavallo'
                AND ID_TROPIC = 3
                AND SECI.FK_ID_IDIOMA_SI18N = 'it'
            LIMIT 1;


Tiempo de la consulta: 0.00057792663574219

Tiempo acumulado:0.068711996078491



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


Tiempo de la consulta: 0.00048589706420898

Tiempo acumulado:0.0691978931427



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


Tiempo de la consulta: 0.00046515464782715

Tiempo acumulado:0.069663047790527



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


Tiempo de la consulta: 0.00047397613525391

Tiempo acumulado:0.070137023925781



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


Tiempo de la consulta: 0.00056195259094238

Tiempo acumulado:0.070698976516724



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


Tiempo de la consulta: 0.00049710273742676

Tiempo acumulado:0.07119607925415



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


Tiempo de la consulta: 0.0004730224609375

Tiempo acumulado:0.071669101715088



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


Tiempo de la consulta: 0.00055503845214844

Tiempo acumulado:0.072224140167236



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


Tiempo de la consulta: 0.00050902366638184

Tiempo acumulado:0.072733163833618



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


Tiempo de la consulta: 0.00045609474182129

Tiempo acumulado:0.073189258575439



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


Tiempo de la consulta: 0.00046896934509277

Tiempo acumulado:0.073658227920532



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


Tiempo de la consulta: 0.0004279613494873

Tiempo acumulado:0.07408618927002



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


Tiempo de la consulta: 0.00049114227294922

Tiempo acumulado:0.074577331542969



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


Tiempo de la consulta: 0.00045919418334961

Tiempo acumulado:0.075036525726318



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[80]: SELECT PO.ID_POBLACION_PADRE AS ID_POBLACION_PADRE,POI.DESC_POBLACION, POI.URL_POBLACION
            FROM LO_POBLACION PO, LO_POBLACION_IT POI
            WHERE POI.URL_POBLACION='lago-di-garda'
                AND POI.ID_REGION='533'
                AND IDIOMA = 'it'
                AND POI.ID_POBLACION=PO.ID_POBLACION
            ORDER BY PO.ID_POBLACION;


Tiempo de la consulta: 0.00054001808166504

Tiempo acumulado:0.075576543807983



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[81]: 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 = 'passeggiate-a-cavallo'
                AND ID_TROPIC = 3
                AND SECI.FK_ID_IDIOMA_SI18N = 'it'
            LIMIT 1;


Tiempo de la consulta: 0.00051999092102051

Tiempo acumulado:0.076096534729004



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


Tiempo de la consulta: 0.0005030632019043

Tiempo acumulado:0.076599597930908



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


Tiempo de la consulta: 0.00047612190246582

Tiempo acumulado:0.077075719833374



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


Tiempo de la consulta: 0.0005040168762207

Tiempo acumulado:0.077579736709595



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


Tiempo de la consulta: 0.00058507919311523

Tiempo acumulado:0.07816481590271



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


Tiempo de la consulta: 0.00054788589477539

Tiempo acumulado:0.078712701797485



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


Tiempo de la consulta: 0.00046205520629883

Tiempo acumulado:0.079174757003784



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


Tiempo de la consulta: 0.00056695938110352

Tiempo acumulado:0.079741716384888



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


Tiempo de la consulta: 0.00049901008605957

Tiempo acumulado:0.080240726470947



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


Tiempo de la consulta: 0.00052189826965332

Tiempo acumulado:0.080762624740601



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


Tiempo de la consulta: 0.00047898292541504

Tiempo acumulado:0.081241607666016



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


Tiempo de la consulta: 0.00042009353637695

Tiempo acumulado:0.081661701202393



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


Tiempo de la consulta: 0.00046610832214355

Tiempo acumulado:0.082127809524536



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


Tiempo de la consulta: 0.00046396255493164

Tiempo acumulado:0.082591772079468



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[95]: SELECT PO.ID_POBLACION_PADRE AS ID_POBLACION_PADRE,POI.DESC_POBLACION, POI.URL_POBLACION
            FROM LO_POBLACION PO, LO_POBLACION_IT POI
            WHERE POI.URL_POBLACION='lago-di-garda'
                AND POI.ID_REGION='533'
                AND IDIOMA = 'it'
                AND POI.ID_POBLACION=PO.ID_POBLACION
            ORDER BY PO.ID_POBLACION;


Tiempo de la consulta: 0.00053596496582031

Tiempo acumulado:0.083127737045288



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[96]: 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 = 'passeggiate-a-cavallo'
                AND ID_TROPIC = 3
                AND SECI.FK_ID_IDIOMA_SI18N = 'it'
            LIMIT 1;


Tiempo de la consulta: 0.00051593780517578

Tiempo acumulado:0.083643674850464



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


Tiempo de la consulta: 0.00052213668823242

Tiempo acumulado:0.084165811538696



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


Tiempo de la consulta: 0.00046396255493164

Tiempo acumulado:0.084629774093628



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


Tiempo de la consulta: 0.00046086311340332

Tiempo acumulado:0.085090637207031



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


Tiempo de la consulta: 0.00057888031005859

Tiempo acumulado:0.08566951751709



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


Tiempo de la consulta: 0.0005180835723877

Tiempo acumulado:0.086187601089478



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


Tiempo de la consulta: 0.00047492980957031

Tiempo acumulado:0.086662530899048



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


Tiempo de la consulta: 0.00052404403686523

Tiempo acumulado:0.087186574935913



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


Tiempo de la consulta: 0.00060486793518066

Tiempo acumulado:0.087791442871094



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


Tiempo de la consulta: 0.00045490264892578

Tiempo acumulado:0.08824634552002



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


Tiempo de la consulta: 0.00048708915710449

Tiempo acumulado:0.088733434677124



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


Tiempo de la consulta: 0.00044107437133789

Tiempo acumulado:0.089174509048462



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


Tiempo de la consulta: 0.00047802925109863

Tiempo acumulado:0.089652538299561



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


Tiempo de la consulta: 0.0004570484161377

Tiempo acumulado:0.090109586715698



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[110]: SELECT PO.ID_POBLACION_PADRE AS ID_POBLACION_PADRE,POI.DESC_POBLACION, POI.URL_POBLACION
            FROM LO_POBLACION PO, LO_POBLACION_IT POI
            WHERE POI.URL_POBLACION='lago-di-garda'
                AND POI.ID_REGION='533'
                AND IDIOMA = 'it'
                AND POI.ID_POBLACION=PO.ID_POBLACION
            ORDER BY PO.ID_POBLACION;


Tiempo de la consulta: 0.00056910514831543

Tiempo acumulado:0.090678691864014



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[111]: 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 = 'passeggiate-a-cavallo'
                AND ID_TROPIC = 3
                AND SECI.FK_ID_IDIOMA_SI18N = 'it'
            LIMIT 1;


Tiempo de la consulta: 0.00058603286743164

Tiempo acumulado:0.091264724731445



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


Tiempo de la consulta: 0.0005190372467041

Tiempo acumulado:0.091783761978149



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


Tiempo de la consulta: 0.00048184394836426

Tiempo acumulado:0.092265605926514



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


Tiempo de la consulta: 0.00046801567077637

Tiempo acumulado:0.09273362159729



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


Tiempo de la consulta: 0.00057697296142578

Tiempo acumulado:0.093310594558716



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


Tiempo de la consulta: 0.00047898292541504

Tiempo acumulado:0.093789577484131



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


Tiempo de la consulta: 0.00046110153198242

Tiempo acumulado:0.094250679016113



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


Tiempo de la consulta: 0.00054311752319336

Tiempo acumulado:0.094793796539307



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


Tiempo de la consulta: 0.00050687789916992

Tiempo acumulado:0.095300674438477



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


Tiempo de la consulta: 0.00051522254943848

Tiempo acumulado:0.095815896987915



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


Tiempo de la consulta: 0.00050497055053711

Tiempo acumulado:0.096320867538452



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


Tiempo de la consulta: 0.00040292739868164

Tiempo acumulado:0.096723794937134



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


Tiempo de la consulta: 0.00049209594726562

Tiempo acumulado:0.097215890884399



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


Tiempo de la consulta: 0.00049996376037598

Tiempo acumulado:0.097715854644775



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[125]: SELECT PO.ID_POBLACION_PADRE AS ID_POBLACION_PADRE,POI.DESC_POBLACION, POI.URL_POBLACION
            FROM LO_POBLACION PO, LO_POBLACION_IT POI
            WHERE POI.URL_POBLACION='lago-di-garda'
                AND POI.ID_REGION='533'
                AND IDIOMA = 'it'
                AND POI.ID_POBLACION=PO.ID_POBLACION
            ORDER BY PO.ID_POBLACION;


Tiempo de la consulta: 0.0005650520324707

Tiempo acumulado:0.098280906677246



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[126]: 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 = 'passeggiate-a-cavallo'
                AND ID_TROPIC = 3
                AND SECI.FK_ID_IDIOMA_SI18N = 'it'
            LIMIT 1;


Tiempo de la consulta: 0.00055384635925293

Tiempo acumulado:0.098834753036499



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


Tiempo de la consulta: 0.00050091743469238

Tiempo acumulado:0.099335670471191



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


Tiempo de la consulta: 0.00086498260498047

Tiempo acumulado:0.10020065307617



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


Tiempo de la consulta: 0.00049495697021484

Tiempo acumulado:0.10069561004639



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


Tiempo de la consulta: 0.00061392784118652

Tiempo acumulado:0.10130953788757



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


Tiempo de la consulta: 0.0005190372467041

Tiempo acumulado:0.10182857513428



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


Tiempo de la consulta: 0.00046801567077637

Tiempo acumulado:0.10229659080505



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


Tiempo de la consulta: 0.00055789947509766

Tiempo acumulado:0.10285449028015



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


Tiempo de la consulta: 0.00054192543029785

Tiempo acumulado:0.10339641571045



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


Tiempo de la consulta: 0.00047397613525391

Tiempo acumulado:0.1038703918457



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


Tiempo de la consulta: 0.0004727840423584

Tiempo acumulado:0.10434317588806



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


Tiempo de la consulta: 0.00044393539428711

Tiempo acumulado:0.10478711128235



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


Tiempo de la consulta: 0.00050497055053711

Tiempo acumulado:0.10529208183289



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


Tiempo de la consulta: 0.00049400329589844

Tiempo acumulado:0.10578608512878



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[140]: SELECT PO.ID_POBLACION_PADRE AS ID_POBLACION_PADRE,POI.DESC_POBLACION, POI.URL_POBLACION
            FROM LO_POBLACION PO, LO_POBLACION_IT POI
            WHERE POI.URL_POBLACION='lago-di-garda'
                AND POI.ID_REGION='533'
                AND IDIOMA = 'it'
                AND POI.ID_POBLACION=PO.ID_POBLACION
            ORDER BY PO.ID_POBLACION;


Tiempo de la consulta: 0.00058388710021973

Tiempo acumulado:0.106369972229



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


Tiempo de la consulta: 0.0014021396636963

Tiempo acumulado:0.1077721118927



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


Tiempo de la consulta: 0.00049018859863281

Tiempo acumulado:0.10826230049133



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


Tiempo de la consulta: 0.00050520896911621

Tiempo acumulado:0.10876750946045



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


Tiempo de la consulta: 0.0010359287261963

Tiempo acumulado:0.10980343818665



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


Tiempo de la consulta: 0.00047898292541504

Tiempo acumulado:0.11028242111206



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


Tiempo de la consulta: 0.00049400329589844

Tiempo acumulado:0.11077642440796



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


Tiempo de la consulta: 0.00049901008605957

Tiempo acumulado:0.11127543449402



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


Tiempo de la consulta: 0.00081300735473633

Tiempo acumulado:0.11208844184875



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


Tiempo de la consulta: 0.00045895576477051

Tiempo acumulado:0.11254739761353



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


Tiempo de la consulta: 0.00048112869262695

Tiempo acumulado:0.11302852630615



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


Tiempo de la consulta: 0.00049185752868652

Tiempo acumulado:0.11352038383484



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


Tiempo de la consulta: 0.00050210952758789

Tiempo acumulado:0.11402249336243



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


Tiempo de la consulta: 0.00047898292541504

Tiempo acumulado:0.11450147628784



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


Tiempo de la consulta: 0.00043892860412598

Tiempo acumulado:0.11494040489197



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


Tiempo de la consulta: 0.00091910362243652

Tiempo acumulado:0.1158595085144



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


Tiempo de la consulta: 0.00072002410888672

Tiempo acumulado:0.11657953262329



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


Tiempo de la consulta: 0.00045514106750488

Tiempo acumulado:0.1170346736908



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


Tiempo de la consulta: 0.00045490264892578

Tiempo acumulado:0.11748957633972



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


Tiempo de la consulta: 0.0004880428314209

Tiempo acumulado:0.11797761917114



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


Tiempo de la consulta: 0.00045299530029297

Tiempo acumulado:0.11843061447144



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


Tiempo de la consulta: 0.00045394897460938

Tiempo acumulado:0.11888456344604



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


Tiempo de la consulta: 0.00045490264892578

Tiempo acumulado:0.11933946609497



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


Tiempo de la consulta: 0.00049495697021484

Tiempo acumulado:0.11983442306519



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


Tiempo de la consulta: 0.00046777725219727

Tiempo acumulado:0.12030220031738



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


Tiempo de la consulta: 0.00045490264892578

Tiempo acumulado:0.12075710296631



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


Tiempo de la consulta: 0.00050020217895508

Tiempo acumulado:0.12125730514526



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


Tiempo de la consulta: 0.00047612190246582

Tiempo acumulado:0.12173342704773



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


Tiempo de la consulta: 0.00045490264892578

Tiempo acumulado:0.12218832969666



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


Tiempo de la consulta: 0.00043606758117676

Tiempo acumulado:0.12262439727783



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


Tiempo de la consulta: 0.00046300888061523

Tiempo acumulado:0.12308740615845



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


Tiempo de la consulta: 0.00047707557678223

Tiempo acumulado:0.12356448173523



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


Tiempo de la consulta: 0.00049495697021484

Tiempo acumulado:0.12405943870544



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


Tiempo de la consulta: 0.00054502487182617

Tiempo acumulado:0.12460446357727



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


Tiempo de la consulta: 0.0004730224609375

Tiempo acumulado:0.12507748603821



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


Tiempo de la consulta: 0.00043797492980957

Tiempo acumulado:0.12551546096802



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


Tiempo de la consulta: 0.0004580020904541

Tiempo acumulado:0.12597346305847



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


Tiempo de la consulta: 0.00045394897460938

Tiempo acumulado:0.12642741203308



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


Tiempo de la consulta: 0.00046992301940918

Tiempo acumulado:0.12689733505249



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


Tiempo de la consulta: 0.00035500526428223

Tiempo acumulado:0.12725234031677



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


Tiempo de la consulta: 0.00040006637573242

Tiempo acumulado:0.1276524066925



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[181]: SELECT URL_POBLACION, ID_POBLACION
            FROM LO_POBLACION_IT PO
            WHERE PO.ID_POBLACION = 2000077
                AND PO.IDIOMA = 'it';


Tiempo de la consulta: 0.0003509521484375

Tiempo acumulado:0.12800335884094



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[182]: 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_IT_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 = 2000077
                AND PS.ID_SECTOR = 21
            ORDER BY NEMPRESAS DESC;


Tiempo de la consulta: 0.00044393539428711

Tiempo acumulado:0.12844729423523



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[183]: SELECT SEOHOME.TITLE, SEOHOME.METADESCRIPTION,SEOHOME.DESCRIPTION,SEOHOME.DESCRIPTION2,SEOHOME.HEIGHT
            FROM LO_SEO_DESCRIPTIONS_HOME SEOHOME
            WHERE SEOHOME.ID_TROPIC = 3
                AND SEOHOME.ID_KEY='S21'
                AND SEOHOME.ID_LOCALIZACION='2000077';


Tiempo de la consulta: 0.0028688907623291

Tiempo acumulado:0.13131618499756



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


Tiempo de la consulta: 0.0004119873046875

Tiempo acumulado:0.13172817230225



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


Tiempo de la consulta: 0.00033187866210938

Tiempo acumulado:0.13206005096436



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[186]: SELECT N_OPIS AS TOTAL, MEDIA_OPIS_5 AS MEDIA, ROUND(MEDIA_OPIS_100,0) AS MEDIA2
            FROM LO_POBLACION_IT_STATS
            WHERE ID_POBLACION = 2000077
                AND ID_SECTOR = 21;


Tiempo de la consulta: 0.00040602684020996

Tiempo acumulado:0.13246607780457



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[187]: 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 = 21
                AND PRE.ID_POBLACION_PRE ='2000077' 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 = 21
                AND PRE.ID_POBLACION_PRE ='2000077' /* 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 = 21
                AND PRE.ID_POBLACION_PRE ='2000077' */ ) AS PRECIO_MIN_MAX;


Tiempo de la consulta: 0.0029821395874023

Tiempo acumulado:0.13544821739197



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


Tiempo de la consulta: 0.00042200088500977

Tiempo acumulado:0.13587021827698



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[189]: SELECT '1' as TIPO, PRE.N_VENTAS_PRE AS VENTAS , IF(PP.ID_POBLACION_PP = 2000077,1,IF (PRE.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 (PRE.N_ORDER_VENTAS_TROPIC = '0.0', null, PR.PRIORIZA_ORDEN) AS PRIO_ORDEN , PRE.ID_PRECIO
            FROM LO_PRECIOS PRE
            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 = 2000077 /*
            INNER JOIN LO_POBLACION_IT PO ON PO.ID_POBLACION = PRE.ID_POBLACION_PRE
                AND PO.IDIOMA='it'
            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 = 21 OR (ID_SECTOR_PP = 21
                AND PP.ID_POBLACION_PP = 2000077))
                AND (PRE.ID_POBLACION_PRE = 2000077 OR ID_POBLACION_PP = 2000077)
                AND (PRE.ID_POBLACION_PRE =2000077 OR ID_POBLACION_PP = 2000077 )
                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 , PRE.N_ORDER_VENTAS_TROPIC DESC ,PRE.ID_PRECIO ASC
            LIMIT 20;


Tiempo de la consulta: 0.085621118545532

Tiempo acumulado:0.22149133682251



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[190]: SELECT count(*) as NOFERTAS
            FROM LO_PRECIOS PRE
            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 = 2000077 /*
            INNER JOIN LO_POBLACION_IT PO ON PO.ID_POBLACION = PRE.ID_POBLACION_PRE
                AND PO.IDIOMA='it'
            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 = 21 OR (ID_SECTOR_PP = 21
                AND PP.ID_POBLACION_PP = 2000077))
                AND (PRE.ID_POBLACION_PRE = 2000077 OR ID_POBLACION_PP = 2000077)
                AND (PRE.ID_POBLACION_PRE =2000077 OR ID_POBLACION_PP = 2000077 )
                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.074712038040161

Tiempo acumulado:0.29620337486267



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[191]: SELECT '3' as TIPO, PRE.N_VENTAS_PRE AS VENTAS , IF(PP.ID_POBLACION_PP = 2000077,1,IF (PRE.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 (PRE.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 ,PRE.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, URL_PRE,TITULO_PRE,DESCRIPCION_PRE,INCLUYE_PRE,ALOJAMIENTO_TEXT_PRE,TRANSPORTE_TEXT_PRE,GALERIA_DESC_PRE,HORARIO_PRE, DURACION_PRE, PRECIO_UNITARIO_PRE , PP.DESCRIPCION_PP 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
            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_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 = 'it'
                AND SECI.ID_TROPIC = 3)
            LEFT JOIN LO_POBLACION_CERCANAS PCER ON PCER.ID_POBLACION_CERCANA = PRE.ID_POBLACION_PRE
                AND PCER.ID_POBLACION = 2000077
            LEFT JOIN LO_REGION_I18N REI ON REI.ID_REGION = PRE.ID_REGION_PRE
                AND REI.IDIOMA='it'
            INNER JOIN LO_REGION_ADM1_I18N REIA ON REIA.ID_REGION_ADM1 = RE.ID_REGION_ADM1
                AND REIA.IDIOMA = 'it'
            LEFT JOIN LO_POBLACION_IT PO ON PO.ID_POBLACION = PRE.ID_POBLACION_PRE
                AND PO.IDIOMA='it'
            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 (74696, 75223, 75224, 75221, 75225, 81096)
                AND PRE.VALID_PRE = 4
                AND (PS.ID_ACTIVIDAD_PS = 21 OR (ID_SECTOR_PP = 21
                AND PP.ID_POBLACION_PP = 2000077))
                AND (PRE.ID_POBLACION_PRE = 2000077 OR ID_POBLACION_PP = 2000077)
                AND (PRE.ID_POBLACION_PRE =2000077 OR ID_POBLACION_PP = 2000077 )
                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 , PRE.N_ORDER_VENTAS_TROPIC DESC ,PRE.ID_PRECIO ASC
            LIMIT 20;


Tiempo de la consulta: 0.072009086608887

Tiempo acumulado:0.36821246147156



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


Tiempo de la consulta: 0.00054812431335449

Tiempo acumulado:0.36876058578491



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


Tiempo de la consulta: 0.00054407119750977

Tiempo acumulado:0.36930465698242



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[194]: SELECT *
            FROM LO_PRECIOS_CALENDARIO PC
            WHERE PC.ID_PRECIO_PC = 74696
                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.0024900436401367

Tiempo acumulado:0.37179470062256



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


Tiempo de la consulta: 0.00056695938110352

Tiempo acumulado:0.37236166000366



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[196]: 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 = 3
                AND DATE_FORMAT(RC.FEC_INSERT_RC, '%Y-%m-%d') >= NOW() - INTERVAL 1 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 = 74696
            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 = 3
                AND RC.DEVOLUCION_RC IN (1,2)
                AND DATE_FORMAT(RC.FEC_INSERT_RC, '%Y-%m-%d') >= NOW() - INTERVAL 1 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 = 74696
            GROUP BY PRE.ID_PRECIO ) AS X;


Tiempo de la consulta: 0.0047860145568848

Tiempo acumulado:0.37714767456055



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


Tiempo de la consulta: 0.0010519027709961

Tiempo acumulado:0.37819957733154



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


Tiempo de la consulta: 0.0016219615936279

Tiempo acumulado:0.37982153892517



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


Tiempo de la consulta: 0.0029928684234619

Tiempo acumulado:0.38281440734863



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[200]: SELECT *
            FROM LO_FOTOS
            WHERE ID_PRECIO = 74696
                AND FOTO = 'cavallo-sul-garda.jpg'
                AND VALID = 1;


Tiempo de la consulta: 0.00049185752868652

Tiempo acumulado:0.38330626487732



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[201]: SELECT F_WIDTH, F_HEIGHT
            FROM LO_FOTOS
            WHERE ID_PRECIO = 74696
                AND FOTO = 'cavallo-sul-garda.jpg';


Tiempo de la consulta: 0.00034785270690918

Tiempo acumulado:0.38365411758423



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


Tiempo de la consulta: 0.00040698051452637

Tiempo acumulado:0.38406109809875



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


Tiempo de la consulta: 0.00044798851013184

Tiempo acumulado:0.38450908660889



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


Tiempo de la consulta: 0.00096988677978516

Tiempo acumulado:0.38547897338867



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


Tiempo de la consulta: 0.00041604042053223

Tiempo acumulado:0.3858950138092



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


Tiempo de la consulta: 0.00033402442932129

Tiempo acumulado:0.38622903823853



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


Tiempo de la consulta: 0.00040483474731445

Tiempo acumulado:0.38663387298584



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


Tiempo de la consulta: 0.00041508674621582

Tiempo acumulado:0.38704895973206



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


Tiempo de la consulta: 0.00044894218444824

Tiempo acumulado:0.3874979019165



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


Tiempo de la consulta: 0.00044608116149902

Tiempo acumulado:0.387943983078



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


Tiempo de la consulta: 0.00042104721069336

Tiempo acumulado:0.3883650302887



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


Tiempo de la consulta: 0.00048208236694336

Tiempo acumulado:0.38884711265564



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[213]: SELECT *
            FROM LO_PRECIOS_CALENDARIO PC
            WHERE PC.ID_PRECIO_PC = 75223
                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.0015130043029785

Tiempo acumulado:0.39036011695862



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


Tiempo de la consulta: 0.00049805641174316

Tiempo acumulado:0.39085817337036



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[215]: 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 = 3
                AND DATE_FORMAT(RC.FEC_INSERT_RC, '%Y-%m-%d') >= NOW() - INTERVAL 1 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 = 75223
            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 = 3
                AND RC.DEVOLUCION_RC IN (1,2)
                AND DATE_FORMAT(RC.FEC_INSERT_RC, '%Y-%m-%d') >= NOW() - INTERVAL 1 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 = 75223
            GROUP BY PRE.ID_PRECIO ) AS X;


Tiempo de la consulta: 0.0025889873504639

Tiempo acumulado:0.39344716072083



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


Tiempo de la consulta: 0.0003809928894043

Tiempo acumulado:0.39382815361023



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


Tiempo de la consulta: 0.0011451244354248

Tiempo acumulado:0.39497327804565



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


Tiempo de la consulta: 0.0021038055419922

Tiempo acumulado:0.39707708358765



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[219]: SELECT *
            FROM LO_FOTOS
            WHERE ID_PRECIO = 75223
                AND FOTO = 'p-75223-cavallo-81644935844_16449368461713.jpeg'
                AND VALID = 1;


Tiempo de la consulta: 0.00048303604125977

Tiempo acumulado:0.39756011962891



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[220]: SELECT F_WIDTH, F_HEIGHT
            FROM LO_FOTOS
            WHERE ID_PRECIO = 75223
                AND FOTO = 'p-75223-cavallo-81644935844_16449368461713.jpeg';


Tiempo de la consulta: 0.00040411949157715

Tiempo acumulado:0.39796423912048



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


Tiempo de la consulta: 0.00040698051452637

Tiempo acumulado:0.39837121963501



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


Tiempo de la consulta: 0.00045609474182129

Tiempo acumulado:0.39882731437683



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[223]: SELECT *
            FROM LO_EMPRESAS_OPINIONES_GOOGLE
            WHERE ID_PRECIO = 75223;


Tiempo de la consulta: 0.0016570091247559

Tiempo acumulado:0.40048432350159



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


Tiempo de la consulta: 0.00037503242492676

Tiempo acumulado:0.40085935592651



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


Tiempo de la consulta: 0.00042104721069336

Tiempo acumulado:0.40128040313721



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


Tiempo de la consulta: 0.00033879280090332

Tiempo acumulado:0.40161919593811



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


Tiempo de la consulta: 0.0004270076751709

Tiempo acumulado:0.40204620361328



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


Tiempo de la consulta: 0.00039792060852051

Tiempo acumulado:0.4024441242218



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


Tiempo de la consulta: 0.00040006637573242

Tiempo acumulado:0.40284419059753



(Prod_Yumping_it_IT) (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 = 75223;


Tiempo de la consulta: 0.00043392181396484

Tiempo acumulado:0.4032781124115



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


Tiempo de la consulta: 0.00040888786315918

Tiempo acumulado:0.40368700027466



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


Tiempo de la consulta: 0.00047421455383301

Tiempo acumulado:0.40416121482849



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[233]: SELECT *
            FROM LO_PRECIOS_CALENDARIO PC
            WHERE PC.ID_PRECIO_PC = 75224
                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.00043797492980957

Tiempo acumulado:0.4045991897583



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


Tiempo de la consulta: 0.00047492980957031

Tiempo acumulado:0.40507411956787



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[235]: 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 = 3
                AND DATE_FORMAT(RC.FEC_INSERT_RC, '%Y-%m-%d') >= NOW() - INTERVAL 1 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 = 75224
            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 = 3
                AND RC.DEVOLUCION_RC IN (1,2)
                AND DATE_FORMAT(RC.FEC_INSERT_RC, '%Y-%m-%d') >= NOW() - INTERVAL 1 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 = 75224
            GROUP BY PRE.ID_PRECIO ) AS X;


Tiempo de la consulta: 0.0010478496551514

Tiempo acumulado:0.40612196922302



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


Tiempo de la consulta: 0.00036215782165527

Tiempo acumulado:0.40648412704468



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


Tiempo de la consulta: 0.0011119842529297

Tiempo acumulado:0.40759611129761



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


Tiempo de la consulta: 0.0010979175567627

Tiempo acumulado:0.40869402885437



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[239]: SELECT *
            FROM LO_FOTOS
            WHERE ID_PRECIO = 75224
                AND FOTO = 'p-75224-equi41644937890_16449388281423.jpeg'
                AND VALID = 1;


Tiempo de la consulta: 0.00046706199645996

Tiempo acumulado:0.40916109085083



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[240]: SELECT F_WIDTH, F_HEIGHT
            FROM LO_FOTOS
            WHERE ID_PRECIO = 75224
                AND FOTO = 'p-75224-equi41644937890_16449388281423.jpeg';


Tiempo de la consulta: 0.00034189224243164

Tiempo acumulado:0.40950298309326



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


Tiempo de la consulta: 0.0003969669342041

Tiempo acumulado:0.40989995002747



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


Tiempo de la consulta: 0.00045514106750488

Tiempo acumulado:0.41035509109497



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[243]: SELECT *
            FROM LO_EMPRESAS_OPINIONES_GOOGLE
            WHERE ID_PRECIO = 75224;


Tiempo de la consulta: 0.00087213516235352

Tiempo acumulado:0.41122722625732



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


Tiempo de la consulta: 0.00035905838012695

Tiempo acumulado:0.41158628463745



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


Tiempo de la consulta: 0.00039815902709961

Tiempo acumulado:0.41198444366455



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


Tiempo de la consulta: 0.00032901763916016

Tiempo acumulado:0.41231346130371



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


Tiempo de la consulta: 0.00041103363037109

Tiempo acumulado:0.41272449493408



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


Tiempo de la consulta: 0.00039005279541016

Tiempo acumulado:0.41311454772949



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


Tiempo de la consulta: 0.00039911270141602

Tiempo acumulado:0.41351366043091



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


Tiempo de la consulta: 0.00043606758117676

Tiempo acumulado:0.41394972801208



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


Tiempo de la consulta: 0.00041508674621582

Tiempo acumulado:0.4143648147583



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


Tiempo de la consulta: 0.00048613548278809

Tiempo acumulado:0.41485095024109



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[253]: SELECT *
            FROM LO_PRECIOS_CALENDARIO PC
            WHERE PC.ID_PRECIO_PC = 75221
                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.00043106079101562

Tiempo acumulado:0.4152820110321



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


Tiempo de la consulta: 0.00046896934509277

Tiempo acumulado:0.4157509803772



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[255]: 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 = 3
                AND DATE_FORMAT(RC.FEC_INSERT_RC, '%Y-%m-%d') >= NOW() - INTERVAL 1 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 = 75221
            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 = 3
                AND RC.DEVOLUCION_RC IN (1,2)
                AND DATE_FORMAT(RC.FEC_INSERT_RC, '%Y-%m-%d') >= NOW() - INTERVAL 1 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 = 75221
            GROUP BY PRE.ID_PRECIO ) AS X;


Tiempo de la consulta: 0.0026259422302246

Tiempo acumulado:0.41837692260742



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


Tiempo de la consulta: 0.00037813186645508

Tiempo acumulado:0.41875505447388



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


Tiempo de la consulta: 0.0011141300201416

Tiempo acumulado:0.41986918449402



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


Tiempo de la consulta: 0.00061297416687012

Tiempo acumulado:0.42048215866089



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[259]: SELECT *
            FROM LO_FOTOS
            WHERE ID_PRECIO = 75221
                AND FOTO = 'p-75221-cavallo-151644933687_16449343551489.jpeg'
                AND VALID = 1;


Tiempo de la consulta: 0.0004570484161377

Tiempo acumulado:0.42093920707703



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[260]: SELECT F_WIDTH, F_HEIGHT
            FROM LO_FOTOS
            WHERE ID_PRECIO = 75221
                AND FOTO = 'p-75221-cavallo-151644933687_16449343551489.jpeg';


Tiempo de la consulta: 0.00034618377685547

Tiempo acumulado:0.42128539085388



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


Tiempo de la consulta: 0.00040984153747559

Tiempo acumulado:0.42169523239136



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


Tiempo de la consulta: 0.00043988227844238

Tiempo acumulado:0.4221351146698



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[263]: SELECT *
            FROM LO_EMPRESAS_OPINIONES_GOOGLE
            WHERE ID_PRECIO = 75221;


Tiempo de la consulta: 0.0004270076751709

Tiempo acumulado:0.42256212234497



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


Tiempo de la consulta: 0.00034689903259277

Tiempo acumulado:0.42290902137756



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


Tiempo de la consulta: 0.00039100646972656

Tiempo acumulado:0.42330002784729



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


Tiempo de la consulta: 0.00033092498779297

Tiempo acumulado:0.42363095283508



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


Tiempo de la consulta: 0.00041794776916504

Tiempo acumulado:0.42404890060425



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


Tiempo de la consulta: 0.00040888786315918

Tiempo acumulado:0.42445778846741



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


Tiempo de la consulta: 0.00040888786315918

Tiempo acumulado:0.42486667633057



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


Tiempo de la consulta: 0.00043296813964844

Tiempo acumulado:0.42529964447021



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


Tiempo de la consulta: 0.00040316581726074

Tiempo acumulado:0.42570281028748



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


Tiempo de la consulta: 0.00047492980957031

Tiempo acumulado:0.42617774009705



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[273]: SELECT *
            FROM LO_PRECIOS_CALENDARIO PC
            WHERE PC.ID_PRECIO_PC = 75225
                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.00052094459533691

Tiempo acumulado:0.42669868469238



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


Tiempo de la consulta: 0.00048685073852539

Tiempo acumulado:0.42718553543091



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[275]: 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 = 3
                AND DATE_FORMAT(RC.FEC_INSERT_RC, '%Y-%m-%d') >= NOW() - INTERVAL 1 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 = 75225
            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 = 3
                AND RC.DEVOLUCION_RC IN (1,2)
                AND DATE_FORMAT(RC.FEC_INSERT_RC, '%Y-%m-%d') >= NOW() - INTERVAL 1 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 = 75225
            GROUP BY PRE.ID_PRECIO ) AS X;


Tiempo de la consulta: 0.001032829284668

Tiempo acumulado:0.42821836471558



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


Tiempo de la consulta: 0.00037980079650879

Tiempo acumulado:0.42859816551208



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


Tiempo de la consulta: 0.0011661052703857

Tiempo acumulado:0.42976427078247



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


Tiempo de la consulta: 0.00069499015808105

Tiempo acumulado:0.43045926094055



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[279]: SELECT *
            FROM LO_FOTOS
            WHERE ID_PRECIO = 75225
                AND FOTO = 'p-75225-caballo-21644940345_16449404614630.jpeg'
                AND VALID = 1;


Tiempo de la consulta: 0.00046706199645996

Tiempo acumulado:0.43092632293701



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[280]: SELECT F_WIDTH, F_HEIGHT
            FROM LO_FOTOS
            WHERE ID_PRECIO = 75225
                AND FOTO = 'p-75225-caballo-21644940345_16449404614630.jpeg';


Tiempo de la consulta: 0.00035905838012695

Tiempo acumulado:0.43128538131714



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


Tiempo de la consulta: 0.00043106079101562

Tiempo acumulado:0.43171644210815



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


Tiempo de la consulta: 0.0004730224609375

Tiempo acumulado:0.43218946456909



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[283]: SELECT *
            FROM LO_EMPRESAS_OPINIONES_GOOGLE
            WHERE ID_PRECIO = 75225;


Tiempo de la consulta: 0.00043892860412598

Tiempo acumulado:0.43262839317322



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


Tiempo de la consulta: 0.00036287307739258

Tiempo acumulado:0.43299126625061



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


Tiempo de la consulta: 0.0003960132598877

Tiempo acumulado:0.4333872795105



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


Tiempo de la consulta: 0.00036406517028809

Tiempo acumulado:0.43375134468079



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


Tiempo de la consulta: 0.00043392181396484

Tiempo acumulado:0.43418526649475



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


Tiempo de la consulta: 0.00040817260742188

Tiempo acumulado:0.43459343910217



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


Tiempo de la consulta: 0.00042009353637695

Tiempo acumulado:0.43501353263855



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


Tiempo de la consulta: 0.00044798851013184

Tiempo acumulado:0.43546152114868



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


Tiempo de la consulta: 0.00043416023254395

Tiempo acumulado:0.43589568138123



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


Tiempo de la consulta: 0.00049090385437012

Tiempo acumulado:0.4363865852356



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[293]: SELECT *
            FROM LO_PRECIOS_CALENDARIO PC
            WHERE PC.ID_PRECIO_PC = 81096
                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.0017931461334229

Tiempo acumulado:0.43817973136902



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


Tiempo de la consulta: 0.00050997734069824

Tiempo acumulado:0.43868970870972



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[295]: 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 = 3
                AND DATE_FORMAT(RC.FEC_INSERT_RC, '%Y-%m-%d') >= NOW() - INTERVAL 1 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 = 81096
            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 = 3
                AND RC.DEVOLUCION_RC IN (1,2)
                AND DATE_FORMAT(RC.FEC_INSERT_RC, '%Y-%m-%d') >= NOW() - INTERVAL 1 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 = 81096
            GROUP BY PRE.ID_PRECIO ) AS X;


Tiempo de la consulta: 0.0011179447174072

Tiempo acumulado:0.43980765342712



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


Tiempo de la consulta: 0.00039196014404297

Tiempo acumulado:0.44019961357117



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


Tiempo de la consulta: 0.0011360645294189

Tiempo acumulado:0.44133567810059



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


Tiempo de la consulta: 0.0012228488922119

Tiempo acumulado:0.4425585269928



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[299]: SELECT *
            FROM LO_FOTOS
            WHERE ID_PRECIO = 81096
                AND FOTO = 'p-81096-schermata-2022-08-03-alle-131659525246_16595263182765.08.jpg'
                AND VALID = 1;


Tiempo de la consulta: 0.00050210952758789

Tiempo acumulado:0.44306063652039



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[300]: SELECT F_WIDTH, F_HEIGHT
            FROM LO_FOTOS
            WHERE ID_PRECIO = 81096
                AND FOTO = 'p-81096-schermata-2022-08-03-alle-131659525246_16595263182765.08.jpg';


Tiempo de la consulta: 0.00035500526428223

Tiempo acumulado:0.44341564178467



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


Tiempo de la consulta: 0.00040888786315918

Tiempo acumulado:0.44382452964783



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


Tiempo de la consulta: 0.00044894218444824

Tiempo acumulado:0.44427347183228



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[303]: SELECT *
            FROM LO_EMPRESAS_OPINIONES_GOOGLE
            WHERE ID_PRECIO = 81096;


Tiempo de la consulta: 0.00047898292541504

Tiempo acumulado:0.44475245475769



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


Tiempo de la consulta: 0.00037217140197754

Tiempo acumulado:0.44512462615967



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


Tiempo de la consulta: 0.00040698051452637

Tiempo acumulado:0.44553160667419



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


Tiempo de la consulta: 0.00034308433532715

Tiempo acumulado:0.44587469100952



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


Tiempo de la consulta: 0.00041007995605469

Tiempo acumulado:0.44628477096558



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


Tiempo de la consulta: 0.00044012069702148

Tiempo acumulado:0.4467248916626



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


Tiempo de la consulta: 0.00043797492980957

Tiempo acumulado:0.44716286659241



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


Tiempo de la consulta: 0.00046300888061523

Tiempo acumulado:0.44762587547302



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[311]: 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 = 3)
            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
            WHERE SS.ID_SECTOR_SS=21
                AND SSF.ID_TROPIC = 3
            GROUP BY SSF.ID_SSF
            ORDER BY COUNT(SSF.ID_SSF) DESC;


Tiempo de la consulta: 0.0016210079193115

Tiempo acumulado:0.44924688339233



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[312]: SELECT *, URL_PRE,TITULO_PRE,DESCRIPCION_PRE,INCLUYE_PRE,ALOJAMIENTO_TEXT_PRE,TRANSPORTE_TEXT_PRE,GALERIA_DESC_PRE,HORARIO_PRE, DURACION_PRE, COUNT(PRE.ID_PRECIO) AS TOTAL_PRECIOS
            FROM LO_SUBSECTORES SS
            INNER JOIN LO_PRECIOS_SUBSECTORES PSS ON PSS.ID_ACTIVIDAD_PSS = SS.ID_SUBSECTOR
            INNER JOIN LO_PRECIOS PRE ON PRE.ID_PRECIO = PSS.ID_PRECIO_PSS
                AND PRE.VALID_PRE = 4
            INNER JOIN LO_PRECIOS_SECTORES PS ON PS.ID_PRECIO_PS = PRE.ID_PRECIO
            INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
                AND EMP.VALID = 1
            LEFT JOIN LO_PRECIOS_POBLACIONES PPO ON PPO.ID_PRECIO = PRE.ID_PRECIO
            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
            WHERE SS.ID_TROPIC = 3
                AND SS.ID_FAM_SS IN (980,979,981)
                AND 1=1
                AND (PRE.ID_REGION_PRE = 533 OR (PP.ID_REGION_PP = 533
                AND PP.ID_POBLACION_PP IS NULL ))
                AND (PRE.ID_POBLACION_PRE = 2000077 OR (ID_POBLACION_PP = 2000077))
                AND 3=3
                AND SHOW_LANDING = 1
            GROUP BY ID_SUBSECTOR HAVING TOTAL_PRECIOS > 1
            ORDER BY ORDER_LANDING ASC;


Tiempo de la consulta: 0.0027909278869629

Tiempo acumulado:0.4520378112793



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[313]: 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_IT_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 = 2000077
                AND PS.ID_SECTOR = 21
            ORDER BY NEMPRESAS DESC;


Tiempo de la consulta: 0.00053906440734863

Tiempo acumulado:0.45257687568665



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[314]: 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_IT_STATS PS
            INNER JOIN LO_POBLACION_IT PO ON PS.ID_POBLACION = PO.ID_POBLACION
                AND PO.IDIOMA = 'it'
                AND PO.ID_REGION = 533
            INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PO.ID_REGION
                AND REI.IDIOMA = 'it'
            INNER JOIN LO_REGION RE ON RE.ID_REGION = REI.ID_REGION
            LEFT JOIN LO_POBLACION_CERCANAS PC ON PC.ID_POBLACION = 2000077
                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 = 21
                AND N_OFERTAS > 1
            GROUP BY PS.ID_POBLACION
            ORDER BY DISTANCIA_R, PC.DISTANCIA ASC, PS.N_OFERTAS DESC;


Tiempo de la consulta: 0.004237174987793

Tiempo acumulado:0.45681405067444



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


Tiempo de la consulta: 0.00044894218444824

Tiempo acumulado:0.45726299285889



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[316]: SELECT URL_POBLACION, ID_POBLACION
            FROM LO_POBLACION_IT PO
            WHERE PO.ID_POBLACION = 43975
                AND PO.IDIOMA = 'it';


Tiempo de la consulta: 0.00034308433532715

Tiempo acumulado:0.45760607719421



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


Tiempo de la consulta: 0.00035190582275391

Tiempo acumulado:0.45795798301697



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[318]: SELECT URL_POBLACION, ID_POBLACION
            FROM LO_POBLACION_IT PO
            WHERE PO.ID_POBLACION = 2000077
                AND PO.IDIOMA = 'it';


Tiempo de la consulta: 0.00032496452331543

Tiempo acumulado:0.45828294754028



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


Tiempo de la consulta: 0.00099492073059082

Tiempo acumulado:0.45927786827087



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[320]: SELECT PRESTAT.N_OPINIONES OPIS, PRESTAT.N_VENTAS AS VENTAS , PRE.ID_PRECIO, SEC.ID_SECTOR, ID_REGION_PRE
            FROM LO_PRECIOS PRE
            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 = 21
                AND LO.ID_POBLACION = 2000077
            LEFT JOIN LO_PRECIOS_RESTRICCIONES PR ON PRE.ID_PRECIO = PR.ID_PRECIO
            WHERE PRE.VALID_PRE = 4
                AND PS.ID_ACTIVIDAD_PS = 21
                AND ( PRE.ID_REGION_PRE='533' OR PP.ID_REGION_PP='533' )
                AND PRE.ID_POBLACION_PRE = 2000077
            GROUP BY PRE.ID_PRECIO
            ORDER BY LO.STATUS DESC, VENTAS DESC, OPIS DESC
            LIMIT 4;


Tiempo de la consulta: 0.0011441707611084

Tiempo acumulado:0.46042203903198



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[321]: 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 = 21
                AND ID_POBLACION = 2000077
                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.0019829273223877

Tiempo acumulado:0.46240496635437



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[322]: SELECT N_OPIS AS TOTAL, MEDIA_OPIS_5 AS MEDIA, ROUND(MEDIA_OPIS_100,0) AS MEDIA2
            FROM LO_POBLACION_IT_STATS
            WHERE ID_POBLACION = 2000077
                AND ID_SECTOR = 21;


Tiempo de la consulta: 0.00039505958557129

Tiempo acumulado:0.46280002593994



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[323]: 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 = 3)
            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
            WHERE SS.ID_SECTOR_SS=21
                AND SSF.ID_TROPIC = 3
            GROUP BY SSF.ID_SSF
            ORDER BY COUNT(SSF.ID_SSF) DESC;


Tiempo de la consulta: 0.001554012298584

Tiempo acumulado:0.46435403823853



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[324]: 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 = 'it'
                AND ID_TROPIC = 3
            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
            INNER JOIN LO_POBLACION_IT_STATS RS ON RS.ID_POBLACION = 2000077
                AND RS.ID_SECTOR = PS.ID_ACTIVIDAD_PS
                AND RS.N_OFERTAS > 1
            WHERE LSR.ID_SECTOR = 21
                AND (PRE.ID_POBLACION_PRE = 2000077 OR ID_POBLACION_PP = 2000077)
                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.0015580654144287

Tiempo acumulado:0.46591210365295



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[325]: SELECT *, URL_PRE,TITULO_PRE,DESCRIPCION_PRE,INCLUYE_PRE,ALOJAMIENTO_TEXT_PRE,TRANSPORTE_TEXT_PRE,GALERIA_DESC_PRE,HORARIO_PRE, DURACION_PRE, COUNT(PRE.ID_PRECIO) AS TOTAL_PRECIOS
            FROM LO_SUBSECTORES SS
            INNER JOIN LO_PRECIOS_SUBSECTORES PSS ON PSS.ID_ACTIVIDAD_PSS = SS.ID_SUBSECTOR
            INNER JOIN LO_PRECIOS PRE ON PRE.ID_PRECIO = PSS.ID_PRECIO_PSS
                AND PRE.VALID_PRE = 4
            INNER JOIN LO_PRECIOS_SECTORES PS ON PS.ID_PRECIO_PS = PRE.ID_PRECIO
            INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
                AND EMP.VALID = 1
            LEFT JOIN LO_PRECIOS_POBLACIONES PPO ON PPO.ID_PRECIO = PRE.ID_PRECIO
            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
            WHERE SS.ID_TROPIC = 3
                AND SS.ID_FAM_SS IN (980,979,981)
                AND 1=1
                AND (PRE.ID_REGION_PRE = 533 OR (PP.ID_REGION_PP = 533
                AND PP.ID_POBLACION_PP IS NULL ))
                AND (PRE.ID_POBLACION_PRE = 2000077 OR (ID_POBLACION_PP = 2000077))
                AND SHOW_LANDING = 1
            GROUP BY ID_SUBSECTOR HAVING TOTAL_PRECIOS > 1
            ORDER BY ORDER_LANDING ASC;


Tiempo de la consulta: 0.0028719902038574

Tiempo acumulado:0.46878409385681



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[326]: SELECT SEO.DESCRIPTION
            FROM LO_SEO_DESCRIPTIONS SEO
            WHERE SEO.ID_TROPIC='3'
                AND SEO.ID_KEY='S21';


Tiempo de la consulta: 0.00077080726623535

Tiempo acumulado:0.46955490112305



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[327]: 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 = 3
            WHERE SEOHOME.ID_TROPIC = 3
                AND SEOHOME.ID_KEY = 'S21'
                AND SEO_VALID in (0,1)
                AND SEOHOME.ID_LOCALIZACION='2000077';


Tiempo de la consulta: 0.0032279491424561

Tiempo acumulado:0.4727828502655



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[328]: SELECT *
            FROM LO_CONTENIDOS_INTERESES CI
            INNER JOIN LO_CONTENIDOS C ON C.ID_CONTENIDO = CI.ID_CONTENIDO
                AND C.VALID = 1
            WHERE CI.ID_SECTOR = 21
                AND CI.ID_POBLACION = 2000077
                AND CI.ID_REGION = 0
                AND CI.ID_PROVINCIA = 0;


Tiempo de la consulta: 0.0033841133117676

Tiempo acumulado:0.47616696357727



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[329]: 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_IT_STATS PS
            INNER JOIN LO_POBLACION_IT PO ON PO.ID_POBLACION = PS.ID_POBLACION
                AND PO.IDIOMA = 'it'
            INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PO.ID_REGION
                AND REI.IDIOMA = 'it'
            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='3'
                AND SECI.FK_ID_IDIOMA_SI18N = 'it'
            WHERE REI.ID_REGION = 533
                AND PS.ID_SECTOR = 21
                AND (PS.N_OFERTAS > 0
                AND PS.N_OFERTAS IS NOT NULL)
                AND N_OFERTAS > 1
            ORDER BY NEMPRESAS DESC;


Tiempo de la consulta: 0.0018270015716553

Tiempo acumulado:0.47799396514893



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


Tiempo de la consulta: 0.00044083595275879

Tiempo acumulado:0.47843480110168



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[331]: SELECT URL_POBLACION, ID_POBLACION
            FROM LO_POBLACION_IT PO
            WHERE PO.ID_POBLACION = 43975
                AND PO.IDIOMA = 'it';


Tiempo de la consulta: 0.00033688545227051

Tiempo acumulado:0.47877168655396



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


Tiempo de la consulta: 0.00034213066101074

Tiempo acumulado:0.47911381721497



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[333]: SELECT URL_POBLACION, ID_POBLACION
            FROM LO_POBLACION_IT PO
            WHERE PO.ID_POBLACION = 2000077
                AND PO.IDIOMA = 'it';


Tiempo de la consulta: 0.00031614303588867

Tiempo acumulado:0.47942996025085



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[334]: 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_IT PO ON PO.ID_POBLACION = PRM.ID_POBLACION
                AND PO.IDIOMA = 'it'
            INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PO.ID_REGION
                AND REI.IDIOMA = 'it'
            INNER JOIN LO_POBLACION_IT_STATS POS ON POS.ID_POBLACION = PO.ID_POBLACION
                AND POS.ID_SECTOR = 21
                AND POS.N_OFERTAS > 1
            WHERE PRM.ID_REGION = 533;


Tiempo de la consulta: 0.0025570392608643

Tiempo acumulado:0.48198699951172



(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[335]: 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 = 'it'
            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 = 4
            INNER JOIN LO_SECTORES_I18N SECI ON PS.ID_SECTOR = SECI.ID_SECTOR
                AND SECI.ID_TROPIC='3'
                AND SECI.FK_ID_IDIOMA_SI18N = 'it'
            WHERE REI.ID_REGION = 533
                AND (PS.N_OFERTAS > 0
                AND PS.N_OFERTAS IS NOT NULL)
            ORDER BY NEMPRESAS DESC;


Tiempo de la consulta: 0.0013659000396729

Tiempo acumulado:0.48335289955139



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


Tiempo de la consulta: 0.00051116943359375

Tiempo acumulado:0.48386406898499



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


Tiempo de la consulta: 0.00042104721069336

Tiempo acumulado:0.48428511619568



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


Tiempo de la consulta: 0.00032997131347656

Tiempo acumulado:0.48461508750916



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


Tiempo de la consulta: 0.00046205520629883

Tiempo acumulado:0.48507714271545



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


Tiempo de la consulta: 0.00036191940307617

Tiempo acumulado:0.48543906211853



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


Tiempo de la consulta: 0.00040698051452637

Tiempo acumulado:0.48584604263306



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


Tiempo de la consulta: 0.0003659725189209

Tiempo acumulado:0.48621201515198



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


Tiempo de la consulta: 0.00038504600524902

Tiempo acumulado:0.48659706115723



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


Tiempo de la consulta: 0.0003209114074707

Tiempo acumulado:0.4869179725647



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


Tiempo de la consulta: 0.00037813186645508

Tiempo acumulado:0.48729610443115



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


Tiempo de la consulta: 0.0025351047515869

Tiempo acumulado:0.48983120918274



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


Tiempo de la consulta: 0.0013909339904785

Tiempo acumulado:0.49122214317322



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


Tiempo de la consulta: 0.00035691261291504

Tiempo acumulado:0.49157905578613



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


Tiempo de la consulta: 0.00038409233093262

Tiempo acumulado:0.49196314811707



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


Tiempo de la consulta: 0.0013129711151123

Tiempo acumulado:0.49327611923218



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


Tiempo de la consulta: 0.00041794776916504

Tiempo acumulado:0.49369406700134



.Cerramos Conexiones BB.DD.