Confianza Yumping

Descárgate la app

Copyright YUMPING ADVENTURE, S.L. © 2009-2025 - Todos los derechos reservados. N.I.F.: ESB-65584286
Registro mercantil de Madrid; Tomo 32807, Folio 29, Hoja M-590539, Inscripción 2º.

¡Síguenos!

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

prod.yumping.com

/landings/landing.php

BBDD->Prod_Yumping_fr_FR
AMBITO->fr_es
AMBITO_AJAX->fr_es
AMBITO_AJAX COOKIE->fr_en
locale LO_CONFIG->es_FR
locale php->es_FR
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->es_ES
filtro1->rutas-a-caballo
filtro2->costas-de-armor
filtro3->trebeurden
rel_alternate->1
paginado_ofertas->
npage->

Total queries: 377

Tiempo total: 0.98477649688721

>0.1 and < 2 (3)

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

Tiempo de la consulta: 0.0071430206298828

Tiempo acumulado:0.0071430206298828

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

Tiempo acumulado:0.0077040195465088

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

Tiempo de la consulta: 0.0067200660705566

Tiempo acumulado:0.014424085617065

(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread
SQL[4]: SELECT *
            FROM LO_CONFIG C
            WHERE C.AMBITO = ( SELECT AMBITO
            FROM LO_CONFIG C
            WHERE CONCAT('/',C.VALUE) = ''
                AND NAME = 'Request_url_partner'
            LIMIT 1)
                AND (NAME = 'subdomain' OR NAME = 'subdomain_lang');

Tiempo de la consulta: 0.0046250820159912

Tiempo acumulado:0.019049167633057

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

Tiempo de la consulta: 0.012192010879517

Tiempo acumulado:0.031241178512573

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

Tiempo acumulado:0.031626224517822

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

Tiempo de la consulta: 0.00032591819763184

Tiempo acumulado:0.031952142715454

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

Tiempo de la consulta: 0.00048208236694336

Tiempo acumulado:0.032434225082397

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

Tiempo de la consulta: 0.00038409233093262

Tiempo acumulado:0.03281831741333

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

Tiempo de la consulta: 0.00035595893859863

Tiempo acumulado:0.033174276351929

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

Tiempo de la consulta: 0.00040888786315918

Tiempo acumulado:0.033583164215088

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

Tiempo de la consulta: 0.00039815902709961

Tiempo acumulado:0.033981323242188

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[13]: SELECT G.DESC_GRUPO, G.ID_GRUPO, G.URL AS URL_GRUPO
            FROM LO_GRUPOS G
            WHERE G.URL = 'rutas-a-caballo'
                AND G.ID_TROPIC = 41;

Tiempo de la consulta: 0.0010600090026855

Tiempo acumulado:0.035041332244873

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[14]: SELECT P.*, P.URL AS URL_PAIS
            FROM LO_PAIS_I18N P
            WHERE P.URL = 'costas-de-armor'
                AND IDIOMA = 'es';

Tiempo de la consulta: 0.0010321140289307

Tiempo acumulado:0.036073446273804

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[15]: 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 = 'costas-de-armor'
                AND REI.IDIOMA = 'es';

Tiempo de la consulta: 0.00055599212646484

Tiempo acumulado:0.036629438400269

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[16]: 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 = 'costas-de-armor'
                AND IDIOMA = 'es'
            LIMIT 1;

Tiempo de la consulta: 0.00047802925109863

Tiempo acumulado:0.037107467651367

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[17]: 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 = 'rutas-a-caballo'
                AND ID_TROPIC = 41
                AND SECI.FK_ID_IDIOMA_SI18N = 'es'
            LIMIT 1;

Tiempo de la consulta: 0.0016689300537109

Tiempo acumulado:0.038776397705078

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[18]: SELECT DESC_POBLACION,ID_POBLACION,URL_POBLACION
            FROM LO_POBLACION_FR PO
            WHERE ID_REGION='435'
                AND ID_POBLACION='trebeurden'
                AND IDIOMA = 'es'
            LIMIT 1;

Tiempo de la consulta: 0.0009160041809082

Tiempo acumulado:0.039692401885986

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[19]: SELECT DESC_POBLACION,ID_POBLACION,URL_POBLACION
            FROM LO_POBLACION_FR PO
            WHERE ID_REGION='435'
                AND URL_POBLACION='trebeurden'
                AND IDIOMA = 'es'
            LIMIT 1;

Tiempo de la consulta: 0.015373945236206

Tiempo acumulado:0.055066347122192

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

Tiempo de la consulta: 0.00067901611328125

Tiempo acumulado:0.055745363235474

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

Tiempo de la consulta: 0.0011048316955566

Tiempo acumulado:0.05685019493103

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

Tiempo de la consulta: 0.0011820793151855

Tiempo acumulado:0.058032274246216

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[23]: SELECT DESC_POBLACION,ID_POBLACION,URL_POBLACION
            FROM LO_POBLACION_FR PO
            WHERE ID_REGION='435'
                AND ID_POBLACION='13152'
                AND IDIOMA = 'es'
            LIMIT 1;

Tiempo de la consulta: 0.0024600028991699

Tiempo acumulado:0.060492277145386

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[24]: SELECT *
            FROM LO_REGION_SKI REI
            WHERE URL = 'costas-de-armor'
                AND REI.IDIOMA='es'
                AND TIPO = 1;

Tiempo de la consulta: 0.0011179447174072

Tiempo acumulado:0.061610221862793

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

Tiempo de la consulta: 0.00050091743469238

Tiempo acumulado:0.062111139297485

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[26]: SELECT SQL_CALC_FOUND_ROWS ID_EMPRESA
            FROM LO_EMPRESAS EMP
            INNER JOIN LO_REGION RE ON RE.ID_REGION = EMP.ID_PROVINCIA
            LEFT JOIN LO_POBLACION PO ON PO.ID_POBLACION = EMP.ID_POBLACION
            INNER JOIN LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
            INNER JOIN LO_EMPRESAS_STAT EMPS ON EMPS.FK_ID_EST = EMP.ID_EMPRESA
            INNER JOIN LO_EMPRESAS_TRADUCCION_ES ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
                AND ET.IDIOMA_ET = 'es'
            WHERE EMP.VALID IN (1)
                AND RE.ID_REGION = 435
                AND EMP.EMP_MADRE <> 0
                AND PO.ID_POBLACION = 13152
                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 = 435)
            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.0058391094207764

Tiempo acumulado:0.067950248718262

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

Tiempo de la consulta: 0.00027203559875488

Tiempo acumulado:0.068222284317017

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[28]: SELECT SQL_CALC_FOUND_ROWS (SELECT EM2.RESPUESTARAPIDA
            FROM LO_EMPRESAS_STAT EM2
            WHERE EM2.FK_ID_EST = EMP.ID_MADRE) AS RESPUESTA, EMP.ID_MADRE, SEC.ID_GRUPO, EMP.ID_EMPRESA,if(EMP.TIPOCUENTA=0,1,EMP.TIPOCUENTA) AS TIPOCUENTA, EMP.NOPINIONES,EMP.COLAB_EMPRESAS,EMP.VALID, EMP.CLIENTE, EMP.PUNTOS,EMP.PRECIO_ACTIVIDAD, EMP.TOPSECTOR_PROVINCIA, EMP.PROMOGRUPO, EMP.URL, EMP.EMP_MADRE, EMP.ID_EMPRESA, EMP.ID_MADRE, EMP.NOMBRE, EMP.DESCRIPCION, EMP.ID_PROVINCIA, EMP.ID_POBLACION, EMP.ID_PAIS, EMP.COD_POSTAL, EMP.DIRECCION, EMP.MAIL, EMP.TELEFONO, EMP.TELEFONOMOVIL, EMP.FAX, EMP.WEB, EMPS.CENTRAL_ACTIVA, ET.DESCRIPCION_ET DESCRIPCION,GALERIA_DESC_ET GALERIA_DESC,VIDEOS_TEXT_ET VIDEOS_TEXT,VIDEOS_DESC_ET VIDEOS_DESC,COMO_LLEGAR_ET COMO_LLEGAR,URL_ET URL, EMP.NOMBRE NOMBRE, ET.EVENT_PLANNING EVENT_PLANNING, EMP.DESCRIPCION SNIPPET, REI.DESC_REGION, POI.DESC_POBLACION, SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO, EMP.GALERIA, EMP.GALERIA_DESC, EMP.LONGITUDE, EMP.LATITUDE, EMP.LOGOTIPO, EMP.FOTOPRINCIPAL, EMP.PROMOSECTOR, REIA.DESC_REGION DESC_REGION_ADM1,EMP.TIPOCUENTA,EMP.VIDEOS_CODE,MULTIFICHA,EMPS.*,SECI.URL URL_SECTOR ,( SELECT (EMP.LICENCIA_EMPRESA)
            FROM LO_EMPRESAS EMP3
            WHERE (EMP3.ID_EMPRESA= EMP.ID_EMPRESA OR EMP3.ID_EMPRESA = EMP.ID_EMPRESA)
                AND EMP3.LICENCIA_EMPRESA IS NOT NULL
                AND EMP3.LICENCIA_EMPRESA!='' ) AS LICENCIA_EMPRESA , IF (EMP.EMP_MADRE = 3, CONCAT((SELECT LATITUDE
            FROM LO_POBLACION
            WHERE ID_POBLACION = 13152)), 0) AS LAT_PUBLI , IF (EMP.EMP_MADRE = 3, CONCAT((SELECT LONGITUDE
            FROM LO_POBLACION
            WHERE ID_POBLACION = 13152)), 0) AS LONG_PUBLI /* ELIMINAMOS MAX(EMP.LICENCIA_EMPRESA) */ , IF (EMP.EMP_MADRE = 3, ID_MADRE, ID_EMPRESA ) AS ID_P
            FROM LO_EMPRESAS EMP
            INNER JOIN LO_REGION RE ON RE.ID_REGION = EMP.ID_PROVINCIA
            INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = RE.ID_REGION
                AND REI.IDIOMA = 'es'
            INNER JOIN LO_REGION_ADM1_I18N REIA ON REIA.ID_REGION_ADM1 = RE.ID_REGION_ADM1
                AND REIA.IDIOMA = 'es'
            LEFT JOIN LO_POBLACION PO ON PO.ID_POBLACION = EMP.ID_POBLACION
            LEFT JOIN LO_POBLACION_FR POI ON EMP.ID_POBLACION = POI.ID_POBLACION
                AND POI.IDIOMA='es'
            INNER JOIN LO_SECTORES SEC ON SEC.ID_SECTOR = EMP.ID_SECTOR
            INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
                AND SECI.ID_TROPIC = 41
            INNER JOIN LO_EMPRESAS_STAT EMPS ON EMPS.FK_ID_EST = EMP.ID_EMPRESA
            INNER JOIN LO_EMPRESAS_TRADUCCION_ES ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
                AND ET.IDIOMA_ET = 'es'
            WHERE EMP.ID_EMPRESA IN (19784874)
            ORDER BY IF(N_PRECIOS_EST > 0 , 1 ,0) DESC, N_VENTAS_EST DESC,N_ORDER_TSP_EST DESC;

Tiempo de la consulta: 0.0019509792327881

Tiempo acumulado:0.070173263549805

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

Tiempo de la consulta: 0.0037798881530762

Tiempo acumulado:0.073953151702881

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[30]: 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 = 41
            INNER JOIN LO_PRECIOS PRE ON PSS.ID_PRECIO_PSS=PRE.ID_PRECIO
            INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
            LEFT JOIN LO_PRECIOS_PUBLI PP ON PP.ID_PRECIO_PP = PRE.ID_PRECIO
            LEFT JOIN LO_PRECIOS_POBLACIONES PPO ON PPO.ID_PRECIO = PRE.ID_PRECIO
            INNER JOIN LO_PRECIOS_TRADUCCION_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'es'
            WHERE SS.ID_TROPIC = 41
                AND VALID_PRE=4
                AND ID_SECTOR_SS = '21'
                AND (PRE.ID_POBLACION_PRE = 13152 OR ID_POBLACION_PP = 13152 )
            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.0077400207519531

Tiempo acumulado:0.081693172454834

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

Tiempo de la consulta: 0.0012049674987793

Tiempo acumulado:0.082898139953613

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

Tiempo de la consulta: 0.014833927154541

Tiempo acumulado:0.097732067108154

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

Tiempo de la consulta: 0.0022101402282715

Tiempo acumulado:0.099942207336426

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[34]: SELECT URL_POBLACION, ID_POBLACION
            FROM LO_POBLACION_FR PO
            WHERE PO.ID_POBLACION = 13152
                AND PO.IDIOMA = 'fr';

Tiempo de la consulta: 0.0032689571380615

Tiempo acumulado:0.10321116447449

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[35]: SELECT OLD_URL, NEW_URL
FROM LO_URL_301 U
WHERE U.OLD_URL = '/rutas-a-caballo/costas-de-armor/trebeurden';

Tiempo de la consulta: 0.00079894065856934

Tiempo acumulado:0.10401010513306

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

Tiempo de la consulta: 0.0031640529632568

Tiempo acumulado:0.10717415809631

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

Tiempo de la consulta: 0.0017211437225342

Tiempo acumulado:0.10889530181885

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[38]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
            FROM LO_SECTORES_I18N SECI
            INNER JOIN LO_SECTORES SEC ON SECI.ID_SECTOR=SEC.ID_SECTOR
            WHERE SECI.URL = 'rutas-a-caballo'
                AND ID_TROPIC = 41
                AND SECI.FK_ID_IDIOMA_SI18N = 'es'
            LIMIT 1;

Tiempo de la consulta: 0.00056004524230957

Tiempo acumulado:0.10945534706116

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

Tiempo de la consulta: 0.00053811073303223

Tiempo acumulado:0.10999345779419

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

Tiempo de la consulta: 0.00047087669372559

Tiempo acumulado:0.11046433448792

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

Tiempo de la consulta: 0.00050616264343262

Tiempo acumulado:0.11097049713135

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[42]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
            FROM Prod_Yumping_fr_FR.LO_SECTORES SEC
            INNER JOIN Prod_Yumping_fr_FR.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=4;

Tiempo de la consulta: 0.0005500316619873

Tiempo acumulado:0.11152052879333

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

Tiempo de la consulta: 0.0025839805603027

Tiempo acumulado:0.11410450935364

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

Tiempo de la consulta: 0.00044918060302734

Tiempo acumulado:0.11455368995667

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

Tiempo de la consulta: 0.00043416023254395

Tiempo acumulado:0.11498785018921

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

Tiempo de la consulta: 0.00044107437133789

Tiempo acumulado:0.11542892456055

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

Tiempo de la consulta: 0.00044107437133789

Tiempo acumulado:0.11586999893188

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

Tiempo de la consulta: 0.0061359405517578

Tiempo acumulado:0.12200593948364

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

Tiempo de la consulta: 0.0021440982818604

Tiempo acumulado:0.1241500377655

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

Tiempo de la consulta: 0.0022869110107422

Tiempo acumulado:0.12643694877625

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

Tiempo de la consulta: 0.00069594383239746

Tiempo acumulado:0.12713289260864

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[52]: SELECT PO.ID_POBLACION_PADRE AS ID_POBLACION_PADRE,POI.DESC_POBLACION, POI.URL_POBLACION
            FROM LO_POBLACION PO, LO_POBLACION_FR POI
            WHERE POI.URL_POBLACION='trebeurden'
                AND POI.ID_REGION='435'
                AND IDIOMA = 'es'
                AND POI.ID_POBLACION=PO.ID_POBLACION
            ORDER BY PO.ID_POBLACION;

Tiempo de la consulta: 0.00050497055053711

Tiempo acumulado:0.12763786315918

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

Tiempo de la consulta: 0.0019369125366211

Tiempo acumulado:0.1295747756958

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

Tiempo de la consulta: 0.00043392181396484

Tiempo acumulado:0.13000869750977

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

Tiempo de la consulta: 0.00086688995361328

Tiempo acumulado:0.13087558746338

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

Tiempo de la consulta: 0.00040507316589355

Tiempo acumulado:0.13128066062927

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[57]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
            FROM LO_SECTORES_I18N SECI
            INNER JOIN LO_SECTORES SEC ON SECI.ID_SECTOR=SEC.ID_SECTOR
            WHERE SECI.URL = 'rutas-a-caballo'
                AND ID_TROPIC = 41
                AND SECI.FK_ID_IDIOMA_SI18N = 'es'
            LIMIT 1;

Tiempo de la consulta: 0.00053310394287109

Tiempo acumulado:0.13181376457214

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

Tiempo de la consulta: 0.00060105323791504

Tiempo acumulado:0.13241481781006

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

Tiempo de la consulta: 0.00042581558227539

Tiempo acumulado:0.13284063339233

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

Tiempo de la consulta: 0.0014140605926514

Tiempo acumulado:0.13425469398499

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[61]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
            FROM Prod_Yumping_fr_FR.LO_SECTORES SEC
            INNER JOIN Prod_Yumping_fr_FR.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=42;

Tiempo de la consulta: 0.00090503692626953

Tiempo acumulado:0.13515973091125

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

Tiempo de la consulta: 0.00070309638977051

Tiempo acumulado:0.13586282730103

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

Tiempo de la consulta: 0.00084400177001953

Tiempo acumulado:0.13670682907104

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

Tiempo de la consulta: 0.0020179748535156

Tiempo acumulado:0.13872480392456

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

Tiempo de la consulta: 0.0034859180450439

Tiempo acumulado:0.1422107219696

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

Tiempo de la consulta: 0.0038001537322998

Tiempo acumulado:0.1460108757019

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

Tiempo de la consulta: 0.00070285797119141

Tiempo acumulado:0.1467137336731

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

Tiempo de la consulta: 0.0022850036621094

Tiempo acumulado:0.14899873733521

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

Tiempo de la consulta: 0.00051498413085938

Tiempo acumulado:0.14951372146606

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

Tiempo de la consulta: 0.00071811676025391

Tiempo acumulado:0.15023183822632

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[71]: SELECT PO.ID_POBLACION_PADRE AS ID_POBLACION_PADRE,POI.DESC_POBLACION, POI.URL_POBLACION
            FROM LO_POBLACION PO, LO_POBLACION_FR POI
            WHERE POI.URL_POBLACION='trebeurden'
                AND POI.ID_REGION='435'
                AND IDIOMA = 'es'
                AND POI.ID_POBLACION=PO.ID_POBLACION
            ORDER BY PO.ID_POBLACION;

Tiempo de la consulta: 0.00066399574279785

Tiempo acumulado:0.15089583396912

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

Tiempo de la consulta: 0.00052189826965332

Tiempo acumulado:0.15141773223877

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

Tiempo de la consulta: 0.00066494941711426

Tiempo acumulado:0.15208268165588

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

Tiempo de la consulta: 0.00042486190795898

Tiempo acumulado:0.15250754356384

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

Tiempo de la consulta: 0.0003969669342041

Tiempo acumulado:0.15290451049805

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[76]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
            FROM LO_SECTORES_I18N SECI
            INNER JOIN LO_SECTORES SEC ON SECI.ID_SECTOR=SEC.ID_SECTOR
            WHERE SECI.URL = 'rutas-a-caballo'
                AND ID_TROPIC = 41
                AND SECI.FK_ID_IDIOMA_SI18N = 'es'
            LIMIT 1;

Tiempo de la consulta: 0.00063300132751465

Tiempo acumulado:0.15353751182556

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

Tiempo de la consulta: 0.00051593780517578

Tiempo acumulado:0.15405344963074

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

Tiempo de la consulta: 0.00062203407287598

Tiempo acumulado:0.15467548370361

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

Tiempo de la consulta: 0.00043797492980957

Tiempo acumulado:0.15511345863342

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

Tiempo de la consulta: 0.00055909156799316

Tiempo acumulado:0.15567255020142

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

Tiempo de la consulta: 0.00046706199645996

Tiempo acumulado:0.15613961219788

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

Tiempo de la consulta: 0.0021450519561768

Tiempo acumulado:0.15828466415405

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

Tiempo de la consulta: 0.00046610832214355

Tiempo acumulado:0.1587507724762

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

Tiempo de la consulta: 0.00046992301940918

Tiempo acumulado:0.15922069549561

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

Tiempo de la consulta: 0.0005500316619873

Tiempo acumulado:0.15977072715759

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

Tiempo de la consulta: 0.00050806999206543

Tiempo acumulado:0.16027879714966

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

Tiempo de la consulta: 0.00045299530029297

Tiempo acumulado:0.16073179244995

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

Tiempo de la consulta: 0.00075292587280273

Tiempo acumulado:0.16148471832275

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

Tiempo de la consulta: 0.00050020217895508

Tiempo acumulado:0.16198492050171

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[90]: SELECT PO.ID_POBLACION_PADRE AS ID_POBLACION_PADRE,POI.DESC_POBLACION, POI.URL_POBLACION
            FROM LO_POBLACION PO, LO_POBLACION_FR POI
            WHERE POI.URL_POBLACION='trebeurden'
                AND POI.ID_REGION='435'
                AND IDIOMA = 'es'
                AND POI.ID_POBLACION=PO.ID_POBLACION
            ORDER BY PO.ID_POBLACION;

Tiempo de la consulta: 0.00053906440734863

Tiempo acumulado:0.16252398490906

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

Tiempo de la consulta: 0.00050497055053711

Tiempo acumulado:0.16302895545959

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

Tiempo de la consulta: 0.00048017501831055

Tiempo acumulado:0.16350913047791

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

Tiempo de la consulta: 0.00069904327392578

Tiempo acumulado:0.16420817375183

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

Tiempo de la consulta: 0.00038909912109375

Tiempo acumulado:0.16459727287292

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[95]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
            FROM LO_SECTORES_I18N SECI
            INNER JOIN LO_SECTORES SEC ON SECI.ID_SECTOR=SEC.ID_SECTOR
            WHERE SECI.URL = 'rutas-a-caballo'
                AND ID_TROPIC = 41
                AND SECI.FK_ID_IDIOMA_SI18N = 'es'
            LIMIT 1;

Tiempo de la consulta: 0.00064301490783691

Tiempo acumulado:0.16524028778076

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

Tiempo de la consulta: 0.00049090385437012

Tiempo acumulado:0.16573119163513

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

Tiempo de la consulta: 0.00048017501831055

Tiempo acumulado:0.16621136665344

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

Tiempo de la consulta: 0.00049400329589844

Tiempo acumulado:0.16670536994934

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[99]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
            FROM Prod_Yumping_fr_FR.LO_SECTORES SEC
            INNER JOIN Prod_Yumping_fr_FR.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=47;

Tiempo de la consulta: 0.00055599212646484

Tiempo acumulado:0.16726136207581

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

Tiempo de la consulta: 0.00045394897460938

Tiempo acumulado:0.16771531105042

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

Tiempo de la consulta: 0.00042891502380371

Tiempo acumulado:0.16814422607422

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

Tiempo de la consulta: 0.00043106079101562

Tiempo acumulado:0.16857528686523

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

Tiempo de la consulta: 0.002316951751709

Tiempo acumulado:0.17089223861694

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

Tiempo de la consulta: 0.00049090385437012

Tiempo acumulado:0.17138314247131

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

Tiempo de la consulta: 0.00044083595275879

Tiempo acumulado:0.17182397842407

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

Tiempo de la consulta: 0.00039005279541016

Tiempo acumulado:0.17221403121948

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

Tiempo de la consulta: 0.0011060237884521

Tiempo acumulado:0.17332005500793

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

Tiempo de la consulta: 0.00043606758117676

Tiempo acumulado:0.17375612258911

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[109]: SELECT PO.ID_POBLACION_PADRE AS ID_POBLACION_PADRE,POI.DESC_POBLACION, POI.URL_POBLACION
            FROM LO_POBLACION PO, LO_POBLACION_FR POI
            WHERE POI.URL_POBLACION='trebeurden'
                AND POI.ID_REGION='435'
                AND IDIOMA = 'es'
                AND POI.ID_POBLACION=PO.ID_POBLACION
            ORDER BY PO.ID_POBLACION;

Tiempo de la consulta: 0.00056099891662598

Tiempo acumulado:0.17431712150574

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

Tiempo de la consulta: 0.0006108283996582

Tiempo acumulado:0.1749279499054

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

Tiempo de la consulta: 0.00059199333190918

Tiempo acumulado:0.1755199432373

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

Tiempo de la consulta: 0.00041484832763672

Tiempo acumulado:0.17593479156494

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

Tiempo de la consulta: 0.00037503242492676

Tiempo acumulado:0.17630982398987

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

Tiempo de la consulta: 0.00067877769470215

Tiempo acumulado:0.17698860168457

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

Tiempo de la consulta: 0.00061798095703125

Tiempo acumulado:0.1776065826416

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

Tiempo de la consulta: 0.0021500587463379

Tiempo acumulado:0.17975664138794

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

Tiempo de la consulta: 0.0024929046630859

Tiempo acumulado:0.18224954605103

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[118]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
            FROM Prod_Yumping_fr_FR.LO_SECTORES SEC
            INNER JOIN Prod_Yumping_fr_FR.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=48;

Tiempo de la consulta: 0.0029630661010742

Tiempo acumulado:0.1852126121521

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

Tiempo de la consulta: 0.0007479190826416

Tiempo acumulado:0.18596053123474

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

Tiempo de la consulta: 0.00063800811767578

Tiempo acumulado:0.18659853935242

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

Tiempo de la consulta: 0.00047183036804199

Tiempo acumulado:0.18707036972046

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

Tiempo de la consulta: 0.00063800811767578

Tiempo acumulado:0.18770837783813

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

Tiempo de la consulta: 0.00043010711669922

Tiempo acumulado:0.18813848495483

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

Tiempo de la consulta: 0.00046300888061523

Tiempo acumulado:0.18860149383545

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

Tiempo de la consulta: 0.00039887428283691

Tiempo acumulado:0.18900036811829

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

Tiempo de la consulta: 0.00042510032653809

Tiempo acumulado:0.18942546844482

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

Tiempo de la consulta: 0.00065302848815918

Tiempo acumulado:0.19007849693298

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[128]: SELECT PO.ID_POBLACION_PADRE AS ID_POBLACION_PADRE,POI.DESC_POBLACION, POI.URL_POBLACION
            FROM LO_POBLACION PO, LO_POBLACION_FR POI
            WHERE POI.URL_POBLACION='trebeurden'
                AND POI.ID_REGION='435'
                AND IDIOMA = 'es'
                AND POI.ID_POBLACION=PO.ID_POBLACION
            ORDER BY PO.ID_POBLACION;

Tiempo de la consulta: 0.0005500316619873

Tiempo acumulado:0.19062852859497

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

Tiempo de la consulta: 0.00067901611328125

Tiempo acumulado:0.19130754470825

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

Tiempo de la consulta: 0.00048398971557617

Tiempo acumulado:0.19179153442383

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

Tiempo de la consulta: 0.00043010711669922

Tiempo acumulado:0.19222164154053

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

Tiempo de la consulta: 0.00042319297790527

Tiempo acumulado:0.19264483451843

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[133]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
            FROM LO_SECTORES_I18N SECI
            INNER JOIN LO_SECTORES SEC ON SECI.ID_SECTOR=SEC.ID_SECTOR
            WHERE SECI.URL = 'rutas-a-caballo'
                AND ID_TROPIC = 41
                AND SECI.FK_ID_IDIOMA_SI18N = 'es'
            LIMIT 1;

Tiempo de la consulta: 0.0014910697937012

Tiempo acumulado:0.19413590431213

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

Tiempo de la consulta: 0.00050497055053711

Tiempo acumulado:0.19464087486267

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

Tiempo de la consulta: 0.00049281120300293

Tiempo acumulado:0.19513368606567

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

Tiempo de la consulta: 0.00049090385437012

Tiempo acumulado:0.19562458992004

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[137]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
            FROM Prod_Yumping_fr_FR.LO_SECTORES SEC
            INNER JOIN Prod_Yumping_fr_FR.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=45;

Tiempo de la consulta: 0.00055909156799316

Tiempo acumulado:0.19618368148804

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

Tiempo de la consulta: 0.00052404403686523

Tiempo acumulado:0.1967077255249

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

Tiempo de la consulta: 0.00046801567077637

Tiempo acumulado:0.19717574119568

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

Tiempo de la consulta: 0.00050210952758789

Tiempo acumulado:0.19767785072327

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

Tiempo de la consulta: 0.00046706199645996

Tiempo acumulado:0.19814491271973

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

Tiempo de la consulta: 0.00046205520629883

Tiempo acumulado:0.19860696792603

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

Tiempo de la consulta: 0.001284122467041

Tiempo acumulado:0.19989109039307

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

Tiempo de la consulta: 0.0004270076751709

Tiempo acumulado:0.20031809806824

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

Tiempo de la consulta: 0.00048184394836426

Tiempo acumulado:0.2007999420166

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

Tiempo de la consulta: 0.0012869834899902

Tiempo acumulado:0.20208692550659

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[147]: SELECT PO.ID_POBLACION_PADRE AS ID_POBLACION_PADRE,POI.DESC_POBLACION, POI.URL_POBLACION
            FROM LO_POBLACION PO, LO_POBLACION_FR POI
            WHERE POI.URL_POBLACION='trebeurden'
                AND POI.ID_REGION='435'
                AND IDIOMA = 'es'
                AND POI.ID_POBLACION=PO.ID_POBLACION
            ORDER BY PO.ID_POBLACION;

Tiempo de la consulta: 0.00060105323791504

Tiempo acumulado:0.20268797874451

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

Tiempo de la consulta: 0.00049805641174316

Tiempo acumulado:0.20318603515625

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

Tiempo de la consulta: 0.00046491622924805

Tiempo acumulado:0.2036509513855

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

Tiempo de la consulta: 0.00045299530029297

Tiempo acumulado:0.20410394668579

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

Tiempo de la consulta: 0.00043392181396484

Tiempo acumulado:0.20453786849976

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

Tiempo de la consulta: 0.0012481212615967

Tiempo acumulado:0.20578598976135

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

Tiempo de la consulta: 0.00046801567077637

Tiempo acumulado:0.20625400543213

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

Tiempo de la consulta: 0.00048685073852539

Tiempo acumulado:0.20674085617065

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

Tiempo de la consulta: 0.00045609474182129

Tiempo acumulado:0.20719695091248

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[156]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
            FROM Prod_Yumping_fr_FR.LO_SECTORES SEC
            INNER JOIN Prod_Yumping_fr_FR.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=46;

Tiempo de la consulta: 0.00053715705871582

Tiempo acumulado:0.20773410797119

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

Tiempo de la consulta: 0.00045895576477051

Tiempo acumulado:0.20819306373596

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

Tiempo de la consulta: 0.00045108795166016

Tiempo acumulado:0.20864415168762

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

Tiempo de la consulta: 0.00044417381286621

Tiempo acumulado:0.20908832550049

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

Tiempo de la consulta: 0.00055193901062012

Tiempo acumulado:0.20964026451111

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

Tiempo de la consulta: 0.00048184394836426

Tiempo acumulado:0.21012210845947

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

Tiempo de la consulta: 0.00066709518432617

Tiempo acumulado:0.2107892036438

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

Tiempo de la consulta: 0.00039005279541016

Tiempo acumulado:0.21117925643921

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

Tiempo de la consulta: 0.00065493583679199

Tiempo acumulado:0.211834192276

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

Tiempo de la consulta: 0.00043487548828125

Tiempo acumulado:0.21226906776428

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[166]: SELECT PO.ID_POBLACION_PADRE AS ID_POBLACION_PADRE,POI.DESC_POBLACION, POI.URL_POBLACION
            FROM LO_POBLACION PO, LO_POBLACION_FR POI
            WHERE POI.URL_POBLACION='trebeurden'
                AND POI.ID_REGION='435'
                AND IDIOMA = 'es'
                AND POI.ID_POBLACION=PO.ID_POBLACION
            ORDER BY PO.ID_POBLACION;

Tiempo de la consulta: 0.00053501129150391

Tiempo acumulado:0.21280407905579

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

Tiempo de la consulta: 0.0004889965057373

Tiempo acumulado:0.21329307556152

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

Tiempo de la consulta: 0.0004889965057373

Tiempo acumulado:0.21378207206726

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

Tiempo de la consulta: 0.00044918060302734

Tiempo acumulado:0.21423125267029

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[170]: SELECT POI.ID_POBLACION, POI.DESC_POBLACION, POI.URL_POBLACION
            FROM Prod_Yumping_fr_FR.LO_POBLACION PO, Prod_Yumping_fr_FR.LO_POBLACION_FR POI
            WHERE PO.ID_POBLACION = POI.ID_POBLACION
                AND PO.ID_POBLACION=13152
                AND POI.IDIOMA = 'ch';

Tiempo de la consulta: 0.00043201446533203

Tiempo acumulado:0.21466326713562

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

Tiempo de la consulta: 0.00042104721069336

Tiempo acumulado:0.21508431434631

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

Tiempo de la consulta: 0.00073385238647461

Tiempo acumulado:0.21581816673279

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

Tiempo de la consulta: 0.00043416023254395

Tiempo acumulado:0.21625232696533

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

Tiempo de la consulta: 0.00091695785522461

Tiempo acumulado:0.21716928482056

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

Tiempo de la consulta: 0.00052809715270996

Tiempo acumulado:0.21769738197327

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

Tiempo de la consulta: 0.00047492980957031

Tiempo acumulado:0.21817231178284

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

Tiempo de la consulta: 0.00044608116149902

Tiempo acumulado:0.21861839294434

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

Tiempo de la consulta: 0.00047707557678223

Tiempo acumulado:0.21909546852112

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

Tiempo de la consulta: 0.00043106079101562

Tiempo acumulado:0.21952652931213

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

Tiempo de la consulta: 0.00054311752319336

Tiempo acumulado:0.22006964683533

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

Tiempo de la consulta: 0.0005028247833252

Tiempo acumulado:0.22057247161865

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

Tiempo de la consulta: 0.00051689147949219

Tiempo acumulado:0.22108936309814

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

Tiempo de la consulta: 0.00045490264892578

Tiempo acumulado:0.22154426574707

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

Tiempo de la consulta: 0.0004420280456543

Tiempo acumulado:0.22198629379272

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

Tiempo de la consulta: 0.0004580020904541

Tiempo acumulado:0.22244429588318

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

Tiempo de la consulta: 0.00044512748718262

Tiempo acumulado:0.22288942337036

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

Tiempo de la consulta: 0.00048398971557617

Tiempo acumulado:0.22337341308594

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

Tiempo de la consulta: 0.00046992301940918

Tiempo acumulado:0.22384333610535

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

Tiempo de la consulta: 0.00049114227294922

Tiempo acumulado:0.2243344783783

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

Tiempo de la consulta: 0.00047802925109863

Tiempo acumulado:0.22481250762939

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

Tiempo de la consulta: 0.00047898292541504

Tiempo acumulado:0.22529149055481

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

Tiempo de la consulta: 0.00045299530029297

Tiempo acumulado:0.2257444858551

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

Tiempo de la consulta: 0.00044894218444824

Tiempo acumulado:0.22619342803955

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

Tiempo de la consulta: 0.00045394897460938

Tiempo acumulado:0.22664737701416

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

Tiempo de la consulta: 0.00065803527832031

Tiempo acumulado:0.22730541229248

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

Tiempo de la consulta: 0.00043702125549316

Tiempo acumulado:0.22774243354797

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

Tiempo de la consulta: 0.00042390823364258

Tiempo acumulado:0.22816634178162

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

Tiempo de la consulta: 0.00043797492980957

Tiempo acumulado:0.22860431671143

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

Tiempo de la consulta: 0.00047516822814941

Tiempo acumulado:0.22907948493958

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

Tiempo de la consulta: 0.00044703483581543

Tiempo acumulado:0.22952651977539

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

Tiempo de la consulta: 0.00045204162597656

Tiempo acumulado:0.22997856140137

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

Tiempo de la consulta: 0.00041699409484863

Tiempo acumulado:0.23039555549622

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

Tiempo de la consulta: 0.00042915344238281

Tiempo acumulado:0.2308247089386

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

Tiempo de la consulta: 0.00045394897460938

Tiempo acumulado:0.23127865791321

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

Tiempo de la consulta: 0.00051307678222656

Tiempo acumulado:0.23179173469543

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

Tiempo de la consulta: 0.0004580020904541

Tiempo acumulado:0.23224973678589

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

Tiempo de la consulta: 0.001227855682373

Tiempo acumulado:0.23347759246826

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

Tiempo de la consulta: 0.00041484832763672

Tiempo acumulado:0.2338924407959

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

Tiempo de la consulta: 0.0004119873046875

Tiempo acumulado:0.23430442810059

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[210]: SELECT URL_POBLACION, ID_POBLACION
            FROM LO_POBLACION_FR PO
            WHERE PO.ID_POBLACION = 13152
                AND PO.IDIOMA = 'fr';

Tiempo de la consulta: 0.00037598609924316

Tiempo acumulado:0.23468041419983

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

Tiempo de la consulta: 0.00045299530029297

Tiempo acumulado:0.23513340950012

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

Tiempo de la consulta: 0.0011861324310303

Tiempo acumulado:0.23631954193115

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

Tiempo de la consulta: 0.00049996376037598

Tiempo acumulado:0.23681950569153

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

Tiempo de la consulta: 0.00040912628173828

Tiempo acumulado:0.23722863197327

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[215]: 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 ='13152' 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 ='13152' /* 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 ='13152' */ ) AS PRECIO_MIN_MAX;

Tiempo de la consulta: 0.0048739910125732

Tiempo acumulado:0.24210262298584

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

Tiempo de la consulta: 0.00039482116699219

Tiempo acumulado:0.24249744415283

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[217]: 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 = 41)
            INNER JOIN LO_PRECIOS_SUBSECTORES PSS ON SS.ID_SUBSECTOR=PSS.ID_ACTIVIDAD_PSS
            INNER JOIN LO_PRECIOS PRE ON PSS.ID_PRECIO_PSS = PRE.ID_PRECIO
            LEFT JOIN LO_PRECIOS_PUBLI PP ON PP.ID_PRECIO_PP = PRE.ID_PRECIO
            INNER JOIN LO_PRECIOS_TRADUCCION_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'es'
            WHERE SS.ID_SECTOR_SS=21
                AND SSF.ID_TROPIC = 41
                AND (PRE.ID_REGION_PRE = 435 OR PP.ID_REGION_PP = 435)
            GROUP BY SSF.ID_SSF
            ORDER BY COUNT(SSF.ID_SSF) DESC;

Tiempo de la consulta: 0.0025291442871094

Tiempo acumulado:0.24502658843994

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[218]: SELECT SQL_CALC_FOUND_ROWS COUNT(*) AS NPRECIOS,REI.ID_REGION, REI.DESC_REGION, REI.URL URL_REGION
            FROM LO_PRECIOS PRE
            INNER JOIN LO_PRECIOS_TRADUCCION_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'es'
            INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PRE.ID_REGION_PRE
                AND REI.IDIOMA = 'es'
            INNER JOIN LO_PRECIOS_SECTORES PS ON PRE.ID_PRECIO = PS.ID_PRECIO_PS
            WHERE PRE.VALID_PRE = 4
                AND PS.ID_ACTIVIDAD_PS = 21
            GROUP BY REI.ID_REGION
            ORDER BY NPRECIOS DESC
            LIMIT 3;

Tiempo de la consulta: 0.0047409534454346

Tiempo acumulado:0.24976754188538

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[219]: SELECT FOUND_ROWS() NOFERTAS;

Tiempo de la consulta: 0.00028491020202637

Tiempo acumulado:0.2500524520874

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[220]: SELECT '1' as TIPO, PRE.N_VENTAS_PRE AS VENTAS , IF(PP.ID_POBLACION_PP = 13152,1,IF (PT.N_ORDER_VENTAS_TROPIC = '0.0', 2, 0)) AS ES_PUBLI , IF (PRE.N_ORDER_VENTAS_TROPIC = '0.0', PCER.DISTANCIA_REAL +10000, PCER.DISTANCIA_REAL) AS DIST_REAL, PCER.DISTANCIA_REAL, PCER.DISTANCIA, PCER.DURACION , IF (PT.N_ORDER_VENTAS_TROPIC = '0.0', null, PR.PRIORIZA_ORDEN) AS PRIO_ORDEN , PRE.ID_PRECIO
            FROM LO_PRECIOS PRE
            INNER JOIN LO_PRECIOS_TRADUCCION_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'es'
            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 = 13152 /*
            INNER JOIN LO_POBLACION_FR PO ON PO.ID_POBLACION = PRE.ID_POBLACION_PRE
                AND PO.IDIOMA='es'
            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 = 13152))
                AND (PRE.ID_POBLACION_PRE = 13152 OR ID_POBLACION_PP = 13152)
                AND (PRE.ID_POBLACION_PRE =13152 OR ID_POBLACION_PP = 13152 )
                AND (PR.POBLACION = 0 OR PR.POBLACION IS NULL OR IF(PR.FECHA_INICIO IS NOT NULL, CONCAT(DATE_FORMAT(NOW(), '%Y-'),DATE_FORMAT(PR.FECHA_INICIO, '%m-%d')) <= CONCAT(DATE_FORMAT(NOW(), '%Y-'),DATE_FORMAT(NOW(), '%m-%d'))
                AND IF(DATE_FORMAT(PR.FECHA_FIN, '%m') >= DATE_FORMAT(PR.FECHA_INICIO, '%m'), CONCAT(DATE_FORMAT(NOW(), '%Y-'),DATE_FORMAT(PR.FECHA_FIN, '%m-%d')) >= CONCAT(DATE_FORMAT(NOW(), '%Y-'),DATE_FORMAT(NOW(), '%m-%d')), CONCAT( (1+DATE_FORMAT(NOW(), '%Y')),'-',DATE_FORMAT(PR.FECHA_FIN, '%m-%d')) >= CONCAT( DATE_FORMAT(NOW(), '%Y'),'-',DATE_FORMAT(NOW(), '%m-%d'))) ,1!=1) )
            GROUP BY PRE.ID_PRECIO
            ORDER BY PRIO_ORDEN DESC, ES_PUBLI ASC , DIST_REAL ASC , PT.N_ORDER_VENTAS_TROPIC DESC ,PRE.ID_PRECIO ASC
            LIMIT 20;

Tiempo de la consulta (slow_query): 0.18966507911682

Tiempo acumulado:0.43971753120422

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[221]: SELECT count(*) as NOFERTAS
            FROM LO_PRECIOS PRE
            INNER JOIN LO_PRECIOS_TRADUCCION_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'es'
            LEFT JOIN LO_PRECIOS_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 = 13152 /*
            INNER JOIN LO_POBLACION_FR PO ON PO.ID_POBLACION = PRE.ID_POBLACION_PRE
                AND PO.IDIOMA='es'
            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 = 13152))
                AND (PRE.ID_POBLACION_PRE = 13152 OR ID_POBLACION_PP = 13152)
                AND (PRE.ID_POBLACION_PRE =13152 OR ID_POBLACION_PP = 13152 )
                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 (slow_query): 0.14701986312866

Tiempo acumulado:0.58673739433289

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[222]: SELECT '3' as TIPO, PRE.N_VENTAS_PRE AS VENTAS , IF(PP.ID_POBLACION_PP = 13152,1,IF (PT.N_ORDER_VENTAS_TROPIC = '0.0', 2, 0)) AS ES_PUBLI , IF (PRE.N_ORDER_VENTAS_TROPIC = '0.0', PCER.DISTANCIA_REAL +10000, PCER.DISTANCIA_REAL) AS DIST_REAL, PCER.DISTANCIA_REAL, PCER.DISTANCIA, PCER.DURACION , IF (PT.N_ORDER_VENTAS_TROPIC = '0.0', null, PR.PRIORIZA_ORDEN) AS PRIO_ORDEN , COUNT(DISTINCT RC.ID_RESERVA_COMPRA) AS VENTAS, PRE.ID_EMPRESA_PRE, PO.DESC_POBLACION, PRE.ID_PRECIO, SECI.ID_SECTOR, SECI.DESC_SECTOR, SECI.URL URL_SECTOR, REI.ID_REGION, REI.URL URL_REGION, REI.DESC_REGION, PP.ID_REGION_PP, EMP.NOMBRE, PRE.MIN_PERS_PRE, PD.MIN_PERSONAS_PD,PRE.MAX_PERS_PRE,PD.MAX_PERSONAS_PD,PRE.ALOJAMIENTO_PRE, PRE.COMIDA_PRE,PRE.TRANSPORTE_PRE,REI.DESC_REGION,PRE.FOTOPRINCIPAL_PRE, PRE.GALERIA_PRE,EMPS.CENTRAL_ACTIVA, PRE.MULTIACTIVIDAD_PRE, PRE.FK_ID_PAIS_PRE AS ID_PAIS ,PT.N_ORDER_VENTAS_TROPIC , if(PRECIO_PD>0,LEAST(MIN(PRECIO_PD),PRECIO_PRE),LEAST(999999999,PRECIO_PRE) ) PRECIO, PRE.PRECIO_PRE, if(PRECIO_PD>0,LEAST(MIN(PRECIO_PD),PRECIO_PRE),LEAST(999999999,PRECIO_PRE) ) PRECIO_D, IF(PD.PRECIO_PD > 0
                AND PD.VALID_PD = 1, (1 - (MIN(PD.PRECIO_PD) / PRE.PRECIO_PRE))*100 , 0) AS DESCUENTO, PD.OFERTA_PD, DATE_FORMAT(PD.FECHA_CADUCIDAD_PD,'%d') AS DIA_CAD, DATE_FORMAT(PD.FECHA_CADUCIDAD_PD,'%m') AS MES_CAD, DATE_FORMAT(PD.FECHA_CADUCIDAD_PD,'%Y') AS ANYO_CAD, DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%Y/%m/%d') AS FECHA, DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%d') AS DIA_COM, DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%m') AS MES_COM, DATE_FORMAT(PR.FECHA_INICIO, '%d/%m') AS FEC_RES_INI, DATE_FORMAT(PR.FECHA_FIN, '%d/%m') AS FEC_RES_FIN, TRUNCATE(AVG(OP.VALORACION),0) AS VALORACION,COUNT(DISTINCT OP.ID_OPINION) AS OPIS, PD.OFERTA_PD,VALID_PD, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, PRECIO_UNITARIO_PRE , PPT.DESCRIPCION_PPT AS DESCRIPCION_PP ,IF ( PRE.MIN_PERS_PRE > MIN(PD.MIN_PERSONAS_PD)
                AND PD.MIN_PERSONAS_PD IS NOT NULL, MIN(PD.MIN_PERSONAS_PD), PRE.MIN_PERS_PRE ) AS MIN_PERSONAS_PD ,IF ( PRE.MAX_PERS_PRE < MAX(PD.MAX_PERSONAS_PD)
                AND PD.MAX_PERSONAS_PD IS NOT NULL, MAX(PD.MAX_PERSONAS_PD), PRE.MAX_PERS_PRE ) AS MAX_PERSONAS_PD, REIA.DESC_REGION AS DESC_REGION_ADM, RE.ID_CAPITAL, PO.ID_POBLACION, RE.SIMCAPN, IF(DATE(PRE.FEC_INSERT_PRE) > DATE(NOW()) - INTERVAL 3 MONTH, 1, 0) AS IS_NEW
            FROM LO_PRECIOS PRE
            INNER JOIN LO_PRECIOS_TRADUCCION_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'es'
            LEFT JOIN LO_PRECIOS_PUBLI PP ON PRE.ID_PRECIO = PP.ID_PRECIO_PP
            LEFT JOIN LO_RESERVAS_COMPRAS RC ON PRE.ID_PRECIO = RC.ID_PRECIO_RC
                AND RC.VALID_RC NOT IN (0, 2, 6, 7)
            LEFT JOIN LO_PRECIOS_PUBLI_TRADUCCION PPT ON PPT.ID_PUBLI_PP = PP.ID_PUBLI_PP
                AND PPT.IDIOMA = 'es'
            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 = 'es'
                AND SECI.ID_TROPIC = 41)
            LEFT JOIN LO_POBLACION_CERCANAS PCER ON PCER.ID_POBLACION_CERCANA = PRE.ID_POBLACION_PRE
                AND PCER.ID_POBLACION = 13152
            LEFT JOIN LO_REGION_I18N REI ON REI.ID_REGION = PRE.ID_REGION_PRE
                AND REI.IDIOMA='es'
            INNER JOIN LO_REGION_ADM1_I18N REIA ON REIA.ID_REGION_ADM1 = RE.ID_REGION_ADM1
                AND REIA.IDIOMA = 'es'
            LEFT JOIN LO_POBLACION_FR PO ON PO.ID_POBLACION = PRE.ID_POBLACION_PRE
                AND PO.IDIOMA='es'
            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 (87766, 87767, 87768)
                AND PRE.VALID_PRE = 4
                AND (PS.ID_ACTIVIDAD_PS = 21 OR (ID_SECTOR_PP = 21
                AND PP.ID_POBLACION_PP = 13152))
                AND (PRE.ID_POBLACION_PRE = 13152 OR ID_POBLACION_PP = 13152)
                AND (PRE.ID_POBLACION_PRE =13152 OR ID_POBLACION_PP = 13152 )
                AND (PR.POBLACION = 0 OR PR.POBLACION IS NULL OR IF(PR.FECHA_INICIO IS NOT NULL, CONCAT(DATE_FORMAT(NOW(), '%Y-'),DATE_FORMAT(PR.FECHA_INICIO, '%m-%d')) <= CONCAT(DATE_FORMAT(NOW(), '%Y-'),DATE_FORMAT(NOW(), '%m-%d'))
                AND IF(DATE_FORMAT(PR.FECHA_FIN, '%m') >= DATE_FORMAT(PR.FECHA_INICIO, '%m'), CONCAT(DATE_FORMAT(NOW(), '%Y-'),DATE_FORMAT(PR.FECHA_FIN, '%m-%d')) >= CONCAT(DATE_FORMAT(NOW(), '%Y-'),DATE_FORMAT(NOW(), '%m-%d')), CONCAT( (1+DATE_FORMAT(NOW(), '%Y')),'-',DATE_FORMAT(PR.FECHA_FIN, '%m-%d')) >= CONCAT( DATE_FORMAT(NOW(), '%Y'),'-',DATE_FORMAT(NOW(), '%m-%d'))) ,1!=1) )
            GROUP BY PRE.ID_PRECIO
            ORDER BY PRIO_ORDEN DESC, ES_PUBLI ASC , DIST_REAL ASC , PT.N_ORDER_VENTAS_TROPIC DESC ,PRE.ID_PRECIO ASC
            LIMIT 20;

Tiempo de la consulta: 0.021172046661377

Tiempo acumulado:0.60790944099426

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

Tiempo de la consulta: 0.00065898895263672

Tiempo acumulado:0.6085684299469

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

Tiempo de la consulta: 0.0011429786682129

Tiempo acumulado:0.60971140861511

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

Tiempo de la consulta: 0.0032510757446289

Tiempo acumulado:0.61296248435974

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[226]: SELECT *
            FROM LO_FOTOS
            WHERE ID_PRECIO = 87766
                AND FOTO = 'p-87766-illustration-sans-titre1715950561_17159506073344.jpg'
                AND VALID = 1;

Tiempo de la consulta: 0.00052905082702637

Tiempo acumulado:0.61349153518677

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[227]: SELECT ID_PRECIO, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_PRECIO =87766;

Tiempo de la consulta: 0.0016119480133057

Tiempo acumulado:0.61510348320007

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

Tiempo de la consulta: 0.00057101249694824

Tiempo acumulado:0.61567449569702

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

Tiempo de la consulta: 0.00048303604125977

Tiempo acumulado:0.61615753173828

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

Tiempo de la consulta: 0.00070500373840332

Tiempo acumulado:0.61686253547668

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[231]: SELECT *
            FROM LO_FOTOS
            WHERE ID_PRECIO = 87767
                AND FOTO = 'p-87767-345054602-1382808385908093-6166647135411899273-n1698160679_1698160731286.jpg'
                AND VALID = 1;

Tiempo de la consulta: 0.00049901008605957

Tiempo acumulado:0.61736154556274

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[232]: SELECT ID_PRECIO, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_PRECIO =87767;

Tiempo de la consulta: 0.0003960132598877

Tiempo acumulado:0.61775755882263

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

Tiempo de la consulta: 0.00053906440734863

Tiempo acumulado:0.61829662322998

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

Tiempo de la consulta: 0.00047683715820312

Tiempo acumulado:0.61877346038818

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

Tiempo de la consulta: 0.00065302848815918

Tiempo acumulado:0.61942648887634

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[236]: SELECT *
            FROM LO_FOTOS
            WHERE ID_PRECIO = 87768
                AND FOTO = 'p-87768-31721206205_17212063688921.jpeg'
                AND VALID = 1;

Tiempo de la consulta: 0.00065803527832031

Tiempo acumulado:0.62008452415466

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[237]: SELECT ID_PRECIO, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_PRECIO =87768;

Tiempo de la consulta: 0.00034403800964355

Tiempo acumulado:0.62042856216431

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

Tiempo de la consulta: 0.00093913078308105

Tiempo acumulado:0.62136769294739

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

Tiempo de la consulta: 0.00047898292541504

Tiempo acumulado:0.6218466758728

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

Tiempo acumulado:0.62424373626709

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

Tiempo de la consulta: 0.0005180835723877

Tiempo acumulado:0.62476181983948

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

Tiempo de la consulta: 0.0012428760528564

Tiempo acumulado:0.62600469589233

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

Tiempo de la consulta: 0.00090789794921875

Tiempo acumulado:0.62691259384155

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

Tiempo de la consulta: 0.0016860961914062

Tiempo acumulado:0.62859869003296

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

Tiempo de la consulta: 0.00067687034606934

Tiempo acumulado:0.62927556037903

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[246]: SELECT *
            FROM LO_FOTOS
            WHERE ID_PRECIO = 87766
                AND FOTO = 'p-87766-illustration-sans-titre1715950561_17159506073344.jpg'
                AND VALID = 1;

Tiempo de la consulta: 0.00049805641174316

Tiempo acumulado:0.62977361679077

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[247]: SELECT F_WIDTH, F_HEIGHT
            FROM LO_FOTOS
            WHERE ID_PRECIO = 87766
                AND FOTO = 'p-87766-illustration-sans-titre1715950561_17159506073344.jpg';

Tiempo de la consulta: 0.00040292739868164

Tiempo acumulado:0.63017654418945

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

Tiempo de la consulta: 0.00051283836364746

Tiempo acumulado:0.6306893825531

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

Tiempo de la consulta: 0.00046491622924805

Tiempo acumulado:0.63115429878235

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

Tiempo de la consulta: 0.0011100769042969

Tiempo acumulado:0.63226437568665

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

Tiempo de la consulta: 0.0010108947753906

Tiempo acumulado:0.63327527046204

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

Tiempo de la consulta: 0.00050902366638184

Tiempo acumulado:0.63378429412842

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

Tiempo de la consulta: 0.00090503692626953

Tiempo acumulado:0.63468933105469

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

Tiempo de la consulta: 0.00043892860412598

Tiempo acumulado:0.63512825965881

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

Tiempo de la consulta: 0.0010361671447754

Tiempo acumulado:0.63616442680359

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

Tiempo de la consulta: 0.00059795379638672

Tiempo acumulado:0.63676238059998

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

Tiempo de la consulta: 0.00047111511230469

Tiempo acumulado:0.63723349571228

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

Tiempo de la consulta: 0.00045418739318848

Tiempo acumulado:0.63768768310547

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

Tiempo de la consulta: 0.00050616264343262

Tiempo acumulado:0.6381938457489

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

Tiempo acumulado:0.63866496086121

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

Tiempo de la consulta: 0.00052189826965332

Tiempo acumulado:0.63918685913086

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[262]: 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 = 41
                AND DATE_FORMAT(RC.FEC_INSERT_RC, '%Y-%m-%d') >= NOW() - INTERVAL 2 YEAR
            INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
                AND EMP.VALID = 1
            WHERE PRE.VALID_PRE = 4
                AND ID_PRECIO = 87767
            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 = 41
                AND RC.DEVOLUCION_RC IN (1,2)
                AND DATE_FORMAT(RC.FEC_INSERT_RC, '%Y-%m-%d') >= NOW() - INTERVAL 2 YEAR
            INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
                AND EMP.VALID = 1
            WHERE PRE.VALID_PRE = 4
                AND ID_PRECIO = 87767
            GROUP BY PRE.ID_PRECIO ) AS X;

Tiempo de la consulta: 0.001115083694458

Tiempo acumulado:0.64030194282532

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

Tiempo de la consulta: 0.00039887428283691

Tiempo acumulado:0.64070081710815

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

Tiempo de la consulta: 0.0013349056243896

Tiempo acumulado:0.64203572273254

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

Tiempo de la consulta: 0.00068187713623047

Tiempo acumulado:0.64271759986877

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[266]: SELECT *
            FROM LO_FOTOS
            WHERE ID_PRECIO = 87767
                AND FOTO = 'p-87767-345054602-1382808385908093-6166647135411899273-n1698160679_1698160731286.jpg'
                AND VALID = 1;

Tiempo de la consulta: 0.00051593780517578

Tiempo acumulado:0.64323353767395

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[267]: SELECT F_WIDTH, F_HEIGHT
            FROM LO_FOTOS
            WHERE ID_PRECIO = 87767
                AND FOTO = 'p-87767-345054602-1382808385908093-6166647135411899273-n1698160679_1698160731286.jpg';

Tiempo de la consulta: 0.00038385391235352

Tiempo acumulado:0.6436173915863

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

Tiempo de la consulta: 0.0012919902801514

Tiempo acumulado:0.64490938186646

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

Tiempo de la consulta: 0.00047707557678223

Tiempo acumulado:0.64538645744324

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

Tiempo de la consulta: 0.00047612190246582

Tiempo acumulado:0.6458625793457

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

Tiempo de la consulta: 0.00038480758666992

Tiempo acumulado:0.64624738693237

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

Tiempo de la consulta: 0.00044798851013184

Tiempo acumulado:0.6466953754425

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

Tiempo de la consulta: 0.00035619735717773

Tiempo acumulado:0.64705157279968

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

Tiempo de la consulta: 0.00040388107299805

Tiempo acumulado:0.64745545387268

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

Tiempo de la consulta: 0.00045394897460938

Tiempo acumulado:0.64790940284729

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

Tiempo de la consulta: 0.00051093101501465

Tiempo acumulado:0.6484203338623

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

Tiempo de la consulta: 0.00051093101501465

Tiempo acumulado:0.64893126487732

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

Tiempo de la consulta: 0.00044512748718262

Tiempo acumulado:0.6493763923645

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

Tiempo de la consulta: 0.00048398971557617

Tiempo acumulado:0.64986038208008

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

Tiempo acumulado:0.65031933784485

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

Tiempo de la consulta: 0.00052213668823242

Tiempo acumulado:0.65084147453308

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[282]: 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 = 41
                AND DATE_FORMAT(RC.FEC_INSERT_RC, '%Y-%m-%d') >= NOW() - INTERVAL 2 YEAR
            INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
                AND EMP.VALID = 1
            WHERE PRE.VALID_PRE = 4
                AND ID_PRECIO = 87768
            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 = 41
                AND RC.DEVOLUCION_RC IN (1,2)
                AND DATE_FORMAT(RC.FEC_INSERT_RC, '%Y-%m-%d') >= NOW() - INTERVAL 2 YEAR
            INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
                AND EMP.VALID = 1
            WHERE PRE.VALID_PRE = 4
                AND ID_PRECIO = 87768
            GROUP BY PRE.ID_PRECIO ) AS X;

Tiempo de la consulta: 0.002223014831543

Tiempo acumulado:0.65306448936462

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

Tiempo de la consulta: 0.00037598609924316

Tiempo acumulado:0.65344047546387

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

Tiempo de la consulta: 0.0012030601501465

Tiempo acumulado:0.65464353561401

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

Tiempo de la consulta: 0.00061702728271484

Tiempo acumulado:0.65526056289673

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[286]: SELECT *
            FROM LO_FOTOS
            WHERE ID_PRECIO = 87768
                AND FOTO = 'p-87768-31721206205_17212063688921.jpeg'
                AND VALID = 1;

Tiempo de la consulta: 0.00042605400085449

Tiempo acumulado:0.65568661689758

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[287]: SELECT F_WIDTH, F_HEIGHT
            FROM LO_FOTOS
            WHERE ID_PRECIO = 87768
                AND FOTO = 'p-87768-31721206205_17212063688921.jpeg';

Tiempo de la consulta: 0.00032997131347656

Tiempo acumulado:0.65601658821106

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

Tiempo de la consulta: 0.00049996376037598

Tiempo acumulado:0.65651655197144

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

Tiempo de la consulta: 0.00044703483581543

Tiempo acumulado:0.65696358680725

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

Tiempo de la consulta: 0.00035595893859863

Tiempo acumulado:0.65731954574585

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

Tiempo de la consulta: 0.00069403648376465

Tiempo acumulado:0.65801358222961

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

Tiempo de la consulta: 0.00034689903259277

Tiempo acumulado:0.65836048126221

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

Tiempo de la consulta: 0.00060606002807617

Tiempo acumulado:0.65896654129028

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

Tiempo de la consulta: 0.00039005279541016

Tiempo acumulado:0.65935659408569

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

Tiempo de la consulta: 0.00051498413085938

Tiempo acumulado:0.65987157821655

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

Tiempo de la consulta: 0.00045299530029297

Tiempo acumulado:0.66032457351685

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[297]: SELECT DESC_POBLACION,PO.ID_POBLACION,URL_POBLACION,LATITUDE, LONGITUDE
            FROM LO_POBLACION_FR PO
            INNER JOIN LO_POBLACION P ON P.ID_POBLACION = PO.ID_POBLACION
            WHERE PO.ID_POBLACION='13152'
                AND IDIOMA = 'es'
            LIMIT 1;

Tiempo de la consulta: 0.00051307678222656

Tiempo acumulado:0.66083765029907

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[298]: SELECT COUNT(*) AS TOTAL
            FROM LO_EMPRESAS_ULTIMO_LISTADO EUL
            INNER JOIN LO_EMPRESAS EMP ON EUL.ID_EMPRESA = EMP.ID_EMPRESA
            WHERE EMP.ID_SECTOR = '21';

Tiempo de la consulta: 0.0014200210571289

Tiempo acumulado:0.6622576713562

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[299]: SELECT SQL_CALC_FOUND_ROWS PD.ID_DESCUENTO_PD, PD.FECHA_CADUCIDAD_PD, PD.OFERTA_PD, PD.VALID_PD, IF(PD.PRECIO_PD > 0
                AND PD.VALID_PD = 1, LEAST(MIN(PD.PRECIO_PD), PRE.PRECIO_PRE), LEAST(999999999, PRECIO_PRE)) AS PRECIO, IF(PD.PRECIO_PD > 0
                AND PD.VALID_PD = 1, (1 - (MIN(PD.PRECIO_PD) / PRE.PRECIO_PRE))*100 , 0) AS DESCUENTO, IF(PD.PRECIO_PD > 0
                AND PD.VALID_PD = 1, DATE_FORMAT(FECHA_CADUCIDAD_PD, '%d'), 0) AS DIA_CAD, IF(PD.PRECIO_PD > 0
                AND PD.VALID_PD = 1, DATE_FORMAT(PD.FECHA_CADUCIDAD_PD, '%m'), 0) AS MES_CAD, IF(PD.PRECIO_PD > 0
                AND PD.VALID_PD = 1, DATE_FORMAT(PD.FECHA_CADUCIDAD_PD, '%Y'), 0) AS ANYO_CAD, PRE.ID_PRECIO ,(6378 * acos(cos(radians('48.7695198059')) * cos(radians(P.LATITUDE)) * cos(radians(P.LONGITUDE) - radians('-3.5644140244')) + sin(radians('48.7695198059')) * sin(radians(P.LATITUDE)) ) ) AS DISTANCIA
            FROM LO_PRECIOS PRE
            INNER JOIN LO_PRECIOS_TRADUCCION_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'es'
            INNER JOIN LO_PRECIOS_SECTORES PS ON PRE.ID_PRECIO=PS.ID_PRECIO_PS
            INNER JOIN LO_SECTORES SEC ON PS.ID_ACTIVIDAD_PS = SEC.ID_SECTOR
            INNER JOIN LO_GRUPOS GRU ON SEC.ID_GRUPO = GRU.ID_GRUPO
                AND (GRU.ID_TROPIC = 41 )
            INNER JOIN LO_EMPRESAS EMP ON PRE.ID_EMPRESA_PRE=EMP.ID_EMPRESA
                AND ( EMP.VALID IN (1,'-3'))
            LEFT JOIN LO_PRECIOS_DESCUENTOS PD ON PD.ID_PRECIO_PD = PRE.ID_PRECIO
                AND (PD.VALID_PD = 1)
            LEFT JOIN LO_PRECIOS_PUBLI PP ON PRE.ID_PRECIO=PP.ID_PRECIO_PP
            INNER JOIN LO_POBLACION P ON P.ID_POBLACION = PRE.ID_POBLACION_PRE
            LEFT JOIN LO_PRECIOS_RESTRICCIONES PR ON PRE.ID_PRECIO = PR.ID_PRECIO
            WHERE PRE.VALID_PRE=4
                AND PRE.EXCLUYE_PRE IN (0,1)
                AND (PS.ID_ACTIVIDAD_PS=21 OR ID_SECTOR_PP = 21)
                AND (PRE.ID_POBLACION_PRE != 13152
                AND IF(PP.ID_POBLACION_PP IS NOT NULL
                AND PP.ID_POBLACION_PP != 0, PP.ID_POBLACION_PP != 13152, 1=1))
            GROUP BY PRE.ID_PRECIO HAVING CAST(DISTANCIA AS UNSIGNED) <=25
            ORDER BY DISTANCIA ASC, PT.N_ORDER_VENTAS_TROPIC DESC ,PRE.ID_PRECIO ASC
            LIMIT 17;

Tiempo de la consulta (slow_query): 0.20803713798523

Tiempo acumulado:0.87029480934143

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[300]: SELECT FOUND_ROWS() NOFERTAS;

Tiempo de la consulta: 0.00032401084899902

Tiempo acumulado:0.87061882019043

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[301]: 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 = 41)
            INNER JOIN LO_PRECIOS_SUBSECTORES PSS ON SS.ID_SUBSECTOR=PSS.ID_ACTIVIDAD_PSS
            INNER JOIN LO_PRECIOS PRE ON PSS.ID_PRECIO_PSS = PRE.ID_PRECIO
            LEFT JOIN LO_PRECIOS_PUBLI PP ON PP.ID_PRECIO_PP = PRE.ID_PRECIO
            INNER JOIN LO_PRECIOS_TRADUCCION_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'es'
            WHERE SS.ID_SECTOR_SS=21
                AND SSF.ID_TROPIC = 41
            GROUP BY SSF.ID_SSF
            ORDER BY COUNT(SSF.ID_SSF) DESC;

Tiempo de la consulta: 0.0026991367340088

Tiempo acumulado:0.87331795692444

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[302]: SELECT *, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, 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
            INNER JOIN LO_PRECIOS_TRADUCCION_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'es'
            WHERE SS.ID_TROPIC = 41
                AND SS.ID_FAM_SS IN (981,980,979)
                AND 1=1
                AND (PRE.ID_REGION_PRE = 435 OR (PP.ID_REGION_PP = 435
                AND PP.ID_POBLACION_PP IS NULL ))
                AND (PRE.ID_POBLACION_PRE = 13152 OR (ID_POBLACION_PP = 13152))
                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.0054931640625

Tiempo acumulado:0.87881112098694

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

Tiempo de la consulta: 0.00050806999206543

Tiempo acumulado:0.879319190979

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[304]: 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_FR_STATS PS
            INNER JOIN LO_POBLACION_FR PO ON PS.ID_POBLACION = PO.ID_POBLACION
                AND PO.IDIOMA = 'es'
                AND PO.ID_REGION = 435
            INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PO.ID_REGION
                AND REI.IDIOMA = 'es'
            INNER JOIN LO_REGION RE ON RE.ID_REGION = REI.ID_REGION
            LEFT JOIN LO_POBLACION_CERCANAS PC ON PC.ID_POBLACION = 13152
                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.035561084747314

Tiempo acumulado:0.91488027572632

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

Tiempo de la consulta: 0.0004570484161377

Tiempo acumulado:0.91533732414246

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[306]: SELECT URL_POBLACION, ID_POBLACION
            FROM LO_POBLACION_FR PO
            WHERE PO.ID_POBLACION = 12982
                AND PO.IDIOMA = 'fr';

Tiempo de la consulta: 0.00033998489379883

Tiempo acumulado:0.91567730903625

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

Tiempo de la consulta: 0.00035786628723145

Tiempo acumulado:0.91603517532349

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[308]: SELECT URL_POBLACION, ID_POBLACION
            FROM LO_POBLACION_FR PO
            WHERE PO.ID_POBLACION = 13152
                AND PO.IDIOMA = 'fr';

Tiempo de la consulta: 0.00033903121948242

Tiempo acumulado:0.91637420654297

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

Tiempo de la consulta: 0.00033092498779297

Tiempo acumulado:0.91670513153076

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[310]: SELECT URL_POBLACION, ID_POBLACION
            FROM LO_POBLACION_FR PO
            WHERE PO.ID_POBLACION = 12875
                AND PO.IDIOMA = 'fr';

Tiempo de la consulta: 0.00034594535827637

Tiempo acumulado:0.91705107688904

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

Tiempo de la consulta: 0.00034999847412109

Tiempo acumulado:0.91740107536316

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[312]: SELECT URL_POBLACION, ID_POBLACION
            FROM LO_POBLACION_FR PO
            WHERE PO.ID_POBLACION = 2000155
                AND PO.IDIOMA = 'fr';

Tiempo de la consulta: 0.00031304359436035

Tiempo acumulado:0.91771411895752

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

Tiempo de la consulta: 0.001007080078125

Tiempo acumulado:0.91872119903564

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[314]: SELECT PRESTAT.N_OPINIONES OPIS, PRESTAT.N_VENTAS AS VENTAS , PRE.ID_PRECIO, SEC.ID_SECTOR, ID_REGION_PRE
            FROM LO_PRECIOS PRE
            INNER JOIN LO_PRECIOS_TRADUCCION_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'es'
            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 )
            INNER JOIN LO_REGION RE ON RE.ID_REGION = PRE.ID_REGION_PRE
            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 = 13152
            LEFT JOIN LO_PRECIOS_RESTRICCIONES PR ON PRE.ID_PRECIO = PR.ID_PRECIO
            WHERE PRE.VALID_PRE = 4
                AND ( PRE.ID_REGION_PRE='435' OR PP.ID_REGION_PP='435' )
                AND PRE.ID_POBLACION_PRE = 13152
            GROUP BY PRE.ID_PRECIO
            ORDER BY LO.STATUS DESC, VENTAS DESC, OPIS DESC
            LIMIT 4;

Tiempo de la consulta: 0.0013041496276855

Tiempo acumulado:0.92002534866333

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[315]: SELECT '2' as TIPO, PRESTAT.N_OPINIONES OPIS, PRESTAT.N_VENTAS AS VENTAS , PO.DESC_POBLACION, PRE.ID_PRECIO, SECI.ID_SECTOR, SECI.DESC_SECTOR, SECI.URL URL_SECTOR, REI.ID_REGION, REI.URL URL_REGION, REI.DESC_REGION, PP.ID_REGION_PP, PP.DESCRIPCION_PP, PRE.MIN_PERS_PRE, PD.MIN_PERSONAS_PD,PRE.MAX_PERS_PRE,PD.MAX_PERSONAS_PD,PRE.ALOJAMIENTO_PRE, PRE.COMIDA_PRE,PRE.TRANSPORTE_PRE,REI.DESC_REGION,PRE.FOTOPRINCIPAL_PRE, PRE.GALERIA_PRE,EMPS.CENTRAL_ACTIVA, PRE.MULTIACTIVIDAD_PRE, LEAST(if(PRECIO_MIN_PRE>0,PRECIO_MIN_PRE,PRECIO_PRE),PRECIO_PRE) PRECIO, if(PRECIO_PD>0,LEAST(MIN(PRECIO_PD),PRECIO_PRE),LEAST(999999999,PRECIO_PRE) ) PRECIO_D, PD.OFERTA_PD, DATE_FORMAT(PD.FECHA_CADUCIDAD_PD,'%d') AS DIA_CAD, DATE_FORMAT(PD.FECHA_CADUCIDAD_PD,'%m') AS MES_CAD, DATE_FORMAT(PD.FECHA_CADUCIDAD_PD,'%Y') AS ANYO_CAD, DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%Y/%m/%d') AS FECHA, DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%d') AS DIA_COM, DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%m') AS MES_COM, TRUNCATE(AVG(OP.VALORACION),0) AS VALORACION, PD.OFERTA_PD,VALID_PD, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, PRECIO_UNITARIO_PRE ,IF ( PRE.MIN_PERS_PRE > MIN(PD.MIN_PERSONAS_PD)
                AND PD.MIN_PERSONAS_PD IS NOT NULL, MIN(PD.MIN_PERSONAS_PD), PRE.MIN_PERS_PRE ) AS MIN_PERSONAS_PD ,IF ( PRE.MAX_PERS_PRE < MAX(PD.MAX_PERSONAS_PD)
                AND PD.MAX_PERSONAS_PD IS NOT NULL, MAX(PD.MAX_PERSONAS_PD), PRE.MAX_PERS_PRE ) AS MAX_PERSONAS_PD ,IF(PD.PRECIO_PD > 0
                AND PD.VALID_PD = 1, (1 - (MIN(PD.PRECIO_PD) / PRE.PRECIO_PRE))*100 , 0) AS DESCUENTO
            FROM LO_PRECIOS PRE
            INNER JOIN LO_PRECIOS_TRADUCCION_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'es'
            LEFT JOIN LO_PRECIOS_PUBLI PP ON PRE.ID_PRECIO = PP.ID_PRECIO_PP
            LEFT JOIN LO_RESERVAS_COMPRAS RC ON PRE.ID_PRECIO = RC.ID_PRECIO_RC
                AND RC.VALID_RC NOT IN (0, 2, 6, 7)
            LEFT JOIN LO_PRECIOS_STATS PRESTAT ON PRESTAT.ID_PRECIO = PRE.ID_PRECIO
            LEFT JOIN LO_PRECIOS_DESCUENTOS PD ON PD.ID_PRECIO_PD = PRE.ID_PRECIO
                AND PD.VALID_PD = 1
            INNER JOIN LO_PRECIOS_SECTORES PS ON PS.ID_PRECIO_PS = PRE.ID_PRECIO
            INNER JOIN LO_SECTORES SEC ON SEC.ID_SECTOR = PS.ID_ACTIVIDAD_PS
            INNER JOIN LO_EMPRESAS_STAT EMPS ON EMPS.FK_ID_EST = PRE.ID_EMPRESA_PRE
            INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
                AND (EMP.VALID = 1 )
            INNER JOIN LO_REGION RE ON RE.ID_REGION = PRE.ID_REGION_PRE
            INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = PS.ID_ACTIVIDAD_PS
                AND (SECI.FK_ID_IDIOMA_SI18N = 'es'
                AND SECI.ID_TROPIC = 41)
            INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PRE.ID_REGION_PRE
                AND REI.IDIOMA = 'es'
            INNER JOIN LO_POBLACION_FR PO ON PRE.ID_POBLACION_PRE = PO.ID_POBLACION
                AND PO.IDIOMA = 'es'
            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 (87768, 87767, 87766)
                AND PRE.VALID_PRE = 4
                AND ( PRE.ID_REGION_PRE='435' OR PP.ID_REGION_PP='435' )
                AND PRE.ID_POBLACION_PRE = 13152
            GROUP BY PRE.ID_PRECIO
            ORDER BY VENTAS DESC, OPIS DESC
            LIMIT 4;

Tiempo de la consulta: 0.003079891204834

Tiempo acumulado:0.92310523986816

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[316]: SELECT PRESTAT.N_OPINIONES OPIS, PRESTAT.N_VENTAS AS VENTAS , PRE.ID_PRECIO, SEC.ID_SECTOR, ID_REGION_PRE
            FROM LO_PRECIOS PRE
            INNER JOIN LO_PRECIOS_TRADUCCION_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'es'
            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 )
            INNER JOIN LO_REGION RE ON RE.ID_REGION = PRE.ID_REGION_PRE
            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 = 13152
            LEFT JOIN LO_PRECIOS_RESTRICCIONES PR ON PRE.ID_PRECIO = PR.ID_PRECIO
            WHERE PRE.VALID_PRE = 4
                AND ( PRE.ID_REGION_PRE='435' OR PP.ID_REGION_PP='435' )
                AND PRE.ID_POBLACION_PRE = 13152
            GROUP BY PRE.ID_PRECIO
            ORDER BY LO.STATUS DESC, VENTAS DESC, OPIS DESC
            LIMIT 4;

Tiempo de la consulta: 0.0011959075927734

Tiempo acumulado:0.92430114746094

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[317]: SELECT '2' as TIPO, PRESTAT.N_OPINIONES OPIS, PRESTAT.N_VENTAS AS VENTAS , PO.DESC_POBLACION, PRE.ID_PRECIO, SECI.ID_SECTOR, SECI.DESC_SECTOR, SECI.URL URL_SECTOR, REI.ID_REGION, REI.URL URL_REGION, REI.DESC_REGION, PP.ID_REGION_PP, PP.DESCRIPCION_PP, PRE.MIN_PERS_PRE, PD.MIN_PERSONAS_PD,PRE.MAX_PERS_PRE,PD.MAX_PERSONAS_PD,PRE.ALOJAMIENTO_PRE, PRE.COMIDA_PRE,PRE.TRANSPORTE_PRE,REI.DESC_REGION,PRE.FOTOPRINCIPAL_PRE, PRE.GALERIA_PRE,EMPS.CENTRAL_ACTIVA, PRE.MULTIACTIVIDAD_PRE, LEAST(if(PRECIO_MIN_PRE>0,PRECIO_MIN_PRE,PRECIO_PRE),PRECIO_PRE) PRECIO, if(PRECIO_PD>0,LEAST(MIN(PRECIO_PD),PRECIO_PRE),LEAST(999999999,PRECIO_PRE) ) PRECIO_D, PD.OFERTA_PD, DATE_FORMAT(PD.FECHA_CADUCIDAD_PD,'%d') AS DIA_CAD, DATE_FORMAT(PD.FECHA_CADUCIDAD_PD,'%m') AS MES_CAD, DATE_FORMAT(PD.FECHA_CADUCIDAD_PD,'%Y') AS ANYO_CAD, DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%Y/%m/%d') AS FECHA, DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%d') AS DIA_COM, DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%m') AS MES_COM, TRUNCATE(AVG(OP.VALORACION),0) AS VALORACION, PD.OFERTA_PD,VALID_PD, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, PRECIO_UNITARIO_PRE ,IF ( PRE.MIN_PERS_PRE > MIN(PD.MIN_PERSONAS_PD)
                AND PD.MIN_PERSONAS_PD IS NOT NULL, MIN(PD.MIN_PERSONAS_PD), PRE.MIN_PERS_PRE ) AS MIN_PERSONAS_PD ,IF ( PRE.MAX_PERS_PRE < MAX(PD.MAX_PERSONAS_PD)
                AND PD.MAX_PERSONAS_PD IS NOT NULL, MAX(PD.MAX_PERSONAS_PD), PRE.MAX_PERS_PRE ) AS MAX_PERSONAS_PD ,IF(PD.PRECIO_PD > 0
                AND PD.VALID_PD = 1, (1 - (MIN(PD.PRECIO_PD) / PRE.PRECIO_PRE))*100 , 0) AS DESCUENTO
            FROM LO_PRECIOS PRE
            INNER JOIN LO_PRECIOS_TRADUCCION_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'es'
            LEFT JOIN LO_PRECIOS_PUBLI PP ON PRE.ID_PRECIO = PP.ID_PRECIO_PP
            LEFT JOIN LO_RESERVAS_COMPRAS RC ON PRE.ID_PRECIO = RC.ID_PRECIO_RC
                AND RC.VALID_RC NOT IN (0, 2, 6, 7)
            LEFT JOIN LO_PRECIOS_STATS PRESTAT ON PRESTAT.ID_PRECIO = PRE.ID_PRECIO
            LEFT JOIN LO_PRECIOS_DESCUENTOS PD ON PD.ID_PRECIO_PD = PRE.ID_PRECIO
                AND PD.VALID_PD = 1
            INNER JOIN LO_PRECIOS_SECTORES PS ON PS.ID_PRECIO_PS = PRE.ID_PRECIO
            INNER JOIN LO_SECTORES SEC ON SEC.ID_SECTOR = PS.ID_ACTIVIDAD_PS
            INNER JOIN LO_EMPRESAS_STAT EMPS ON EMPS.FK_ID_EST = PRE.ID_EMPRESA_PRE
            INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
                AND (EMP.VALID = 1 )
            INNER JOIN LO_REGION RE ON RE.ID_REGION = PRE.ID_REGION_PRE
            INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = PS.ID_ACTIVIDAD_PS
                AND (SECI.FK_ID_IDIOMA_SI18N = 'es'
                AND SECI.ID_TROPIC = 41)
            INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PRE.ID_REGION_PRE
                AND REI.IDIOMA = 'es'
            INNER JOIN LO_POBLACION_FR PO ON PRE.ID_POBLACION_PRE = PO.ID_POBLACION
                AND PO.IDIOMA = 'es'
            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 (87768, 87767, 87766)
                AND PRE.VALID_PRE = 4
                AND ( PRE.ID_REGION_PRE='435' OR PP.ID_REGION_PP='435' )
                AND PRE.ID_POBLACION_PRE = 13152
            GROUP BY PRE.ID_PRECIO
            ORDER BY VENTAS DESC, OPIS DESC
            LIMIT 4;

Tiempo de la consulta: 0.0029449462890625

Tiempo acumulado:0.92724609375

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

Tiempo de la consulta: 0.00054407119750977

Tiempo acumulado:0.92779016494751

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

Tiempo de la consulta: 0.00050091743469238

Tiempo acumulado:0.9282910823822

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

Tiempo de la consulta: 0.00046205520629883

Tiempo acumulado:0.9287531375885

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

Tiempo de la consulta: 0.00038385391235352

Tiempo acumulado:0.92913699150085

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

Tiempo de la consulta: 0.0004580020904541

Tiempo acumulado:0.92959499359131

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

Tiempo de la consulta: 0.00037097930908203

Tiempo acumulado:0.92996597290039

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[324]: 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 = 13152
                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.002000093460083

Tiempo acumulado:0.93196606636047

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

Tiempo de la consulta: 0.00037598609924316

Tiempo acumulado:0.93234205245972

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[326]: SELECT OP.*, OP.ID_OPINION
FROM LO_EMPRESAS_OPINIONES OP
WHERE OP.ID_OPINION = 42022;

Tiempo de la consulta: 0.00059199333190918

Tiempo acumulado:0.93293404579163

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[327]: SELECT ID_USER, FACEBOOK_ID , MAIL, PASSWORD, NOMBRE, ADMIN, AUTHCODEVALID, AVATAR, USER_ONLINE_TIME, MODIF_PASSWORD, NUM_LOGINS, ROL, ID_PROVINCIA, TELEFONO, DESC_POBLACION, ID_PAIS, ID_POBLACION, BOLETIN, OFERTAS, FEC_NACIMIENTO, DAY(FEC_NACIMIENTO) AS DIA, MONTH(FEC_NACIMIENTO) AS MES, YEAR(FEC_NACIMIENTO) AS ANO
            FROM LO_COM_USERS
            WHERE ID_USER=1934175
                AND VALID!=2 /*
                AND ID_PROJECT='4'*/;

Tiempo de la consulta: 0.0019819736480713

Tiempo acumulado:0.9349160194397

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[328]: SELECT NOMBRE
FROM LO_COM_USERS
WHERE ID_USER=1934175;

Tiempo de la consulta: 0.00034713745117188

Tiempo acumulado:0.93526315689087

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[329]: SELECT ID_USER, AVATAR, NOMBRE, ROL, FACEBOOK_ID
FROM LO_COM_USERS
WHERE ID_USER='1934175';

Tiempo de la consulta: 0.00035786628723145

Tiempo acumulado:0.9356210231781

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[330]: SELECT UF.ID_USER, SILUETA, AVATAR
FROM LO_COM_USERS_FB_AVATAR UF
WHERE ID_USER = '1934175';

Tiempo de la consulta: 0.00079703330993652

Tiempo acumulado:0.93641805648804

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[331]: SELECT ID_PRECIO_RC
FROM LO_RESERVAS_COMPRAS
WHERE ID_RESERVA_COMPRA = '1964622';

Tiempo de la consulta: 0.0003509521484375

Tiempo acumulado:0.93676900863647

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[332]: SELECT DESCRIPCION_PRE,INCLUYE_PRE,ALOJAMIENTO_PRE,ALOJAMIENTO_TEXT_PRE,ID_EMPRESA_PRE,PERIODO_PRE, MIN_PERS_PRE,MAX_PERS_PRE,ANTELACION_PRE,PRECIO_UNITARIO_PRE, PRE.MULTIACTIVIDAD_PRE,HORARIO_PRE, TRANSPORTE_PRE,TRANSPORTE_TEXT_PRE,DURACION_PRE,GALERIA_DESC_PRE, PRECIO_PD,PRECIO_PRE,ID_PRECIO,TITULO_PRE,GALERIA_PRE,FOTOPRINCIPAL_PRE, REI.URL URL_REGION, REI.ID_REGION, REI.DESC_REGION, SECI.ID_SECTOR, SECI.DESC_SECTOR, SECI.URL URL_SECTOR, EMP.DS_ACTIVO, SECP.ID_ACTIVIDAD_PS,EMPS.NOPINIONES_EST, PRE.FEC_ULT_COMPRA,EMP.LATITUDE,EMP.LONGITUDE,EMP.DIRECCION, EMP.ID_POBLACION, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, IF(PRECIO_PD>0,LEAST(MIN(PRECIO_PD),PRECIO_PRE),LEAST(999999999,PRECIO_PRE) ) PRECIO, IF(PRECIO_PD>0
                AND VALID_PD=1, (1-(MIN(PRECIO_PD)/PRECIO_PRE))*100 ,0) DESCUENTO, IF(PRECIO_PD>0
                AND VALID_PD=1,DATE_FORMAT(FECHA_CADUCIDAD_PD,'%d'),0) AS DIA_CAD, IF(PRECIO_PD>0
                AND VALID_PD=1,DATE_FORMAT(FECHA_CADUCIDAD_PD,'%m'),0) AS MES_CAD, IF(PRECIO_PD>0
                AND VALID_PD=1,DATE_FORMAT(FECHA_CADUCIDAD_PD,'%Y'),0) AS ANYO_CAD, FEC_INSERT_PRE
            FROM LO_PRECIOS PRE
            INNER JOIN LO_PRECIOS_TRADUCCION_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'es'
            LEFT JOIN LO_PRECIOS_DESCUENTOS PD ON (PRE.ID_PRECIO=PD.ID_PRECIO_PD
                AND VALID_PD=1 )
            INNER JOIN LO_PRECIOS_SECTORES SECP ON PRE.ID_PRECIO=SECP.ID_PRECIO_PS
            INNER JOIN LO_REGION_I18N REI ON PRE.ID_REGION_PRE=REI.ID_REGION
                AND REI.IDIOMA='es'
            INNER JOIN LO_SECTORES_I18N SECI ON SECP.ID_ACTIVIDAD_PS=SECI.ID_SECTOR
                AND SECI.ID_TROPIC='41'
            INNER JOIN LO_EMPRESAS EMP ON PRE.ID_EMPRESA_PRE=EMP.ID_EMPRESA
            INNER JOIN LO_EMPRESAS_STAT EMPS ON EMPS.FK_ID_EST = EMP.ID_EMPRESA
            WHERE VALID_PRE IN (1,2,4)
                AND ID_PRECIO = '87768'
            GROUP BY PRE.ID_PRECIO
            LIMIT 1;

Tiempo de la consulta: 0.0012471675872803

Tiempo acumulado:0.93801617622375

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[333]: SELECT ID_PRECIO, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_PRECIO =87768;

Tiempo de la consulta: 0.00038695335388184

Tiempo acumulado:0.93840312957764

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[334]: SELECT ID_PRECIO, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_PRECIO =87768;

Tiempo de la consulta: 0.00032305717468262

Tiempo acumulado:0.93872618675232

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[335]: SELECT ID_PRECIO, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_PRECIO =87768;

Tiempo de la consulta: 0.00030398368835449

Tiempo acumulado:0.93903017044067

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

Tiempo de la consulta: 0.00058794021606445

Tiempo acumulado:0.93961811065674

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[337]: SELECT *
            FROM LO_FOTOS
            WHERE ID_EMPRESA = 87768
                AND FOTO = 'p-87768-31721206205_17212063688921.jpeg'
                AND VALID = 1;

Tiempo de la consulta: 0.0009620189666748

Tiempo acumulado:0.94058012962341

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

Tiempo de la consulta: 0.0005040168762207

Tiempo acumulado:0.94108414649963

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

Tiempo de la consulta: 0.00057411193847656

Tiempo acumulado:0.94165825843811

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

Tiempo de la consulta: 0.00080680847167969

Tiempo acumulado:0.94246506690979

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[341]: SELECT *
            FROM LO_EMPRESAS_OPINIONES_TRADUCCIONES
            WHERE ID_OPINION =42022
                AND IDIOMA ='es'
            LIMIT 1;

Tiempo de la consulta: 0.0017340183258057

Tiempo acumulado:0.9441990852356

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[342]: SELECT TRUNCATE(avg(VALORACION)/10,1) AS MEDIA, COUNT(DISTINCT OP.ID_OPINION) AS NOPINIONES
            FROM LO_EMPRESAS_OPINIONES OP
            WHERE (OP.ID_EMPRESA='19784874' OR OP.ID_MADRE='19784874')
                AND OP.VALID=1;

Tiempo de la consulta: 0.00065088272094727

Tiempo acumulado:0.94484996795654

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

Tiempo de la consulta: 0.00052094459533691

Tiempo acumulado:0.94537091255188

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[344]: SELECT COUNT(*) AS NUMOPINIONES, (SUM(VALORACION) / COUNT(*)) /20 AS VALORACION
            FROM LO_EMPRESAS_OPINIONES OP
            LEFT JOIN LO_RESERVAS_COMPRAS RC ON OP.RESERVA_FEEDBACK = RC.ID_RESERVA_COMPRA
            WHERE (OP.ID_EMPRESA = 19784874 OR OP.ID_MADRE = 19784874)
                AND OP.VALID = 1;

Tiempo de la consulta: 0.00069403648376465

Tiempo acumulado:0.94606494903564

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

Tiempo de la consulta: 0.0035960674285889

Tiempo acumulado:0.94966101646423

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[346]: SELECT *
            FROM LO_FOTOS
            WHERE ID_EMPRESA = 19784874
                AND FOTO = 'e-19784874-272853359-466796108361062-7257216807632320384-n1698157977169815798555.jpg'
                AND VALID=1;

Tiempo de la consulta: 0.00053095817565918

Tiempo acumulado:0.95019197463989

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

Tiempo de la consulta: 0.00072908401489258

Tiempo acumulado:0.95092105865479

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

Tiempo de la consulta: 0.00047492980957031

Tiempo acumulado:0.95139598846436

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

Tiempo de la consulta: 0.00035905838012695

Tiempo acumulado:0.95175504684448

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

Tiempo de la consulta: 0.00076508522033691

Tiempo acumulado:0.95252013206482

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

Tiempo de la consulta: 0.0005040168762207

Tiempo acumulado:0.95302414894104

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

Tiempo de la consulta: 0.00042486190795898

Tiempo acumulado:0.953449010849

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

Tiempo de la consulta: 0.00059318542480469

Tiempo acumulado:0.9540421962738

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

Tiempo de la consulta: 0.00050210952758789

Tiempo acumulado:0.95454430580139

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[355]: 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 = 41)
            INNER JOIN LO_PRECIOS_SUBSECTORES PSS ON SS.ID_SUBSECTOR=PSS.ID_ACTIVIDAD_PSS
            INNER JOIN LO_PRECIOS PRE ON PSS.ID_PRECIO_PSS = PRE.ID_PRECIO
            LEFT JOIN LO_PRECIOS_PUBLI PP ON PP.ID_PRECIO_PP = PRE.ID_PRECIO
            INNER JOIN LO_PRECIOS_TRADUCCION_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'es'
            WHERE SS.ID_SECTOR_SS=21
                AND SSF.ID_TROPIC = 41
            GROUP BY SSF.ID_SSF
            ORDER BY COUNT(SSF.ID_SSF) DESC;

Tiempo de la consulta: 0.0031321048736572

Tiempo acumulado:0.95767641067505

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[356]: 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 = 'es'
                AND ID_TROPIC = 41
            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_FR_STATS RS ON RS.ID_POBLACION = 13152
                AND RS.ID_SECTOR = PS.ID_ACTIVIDAD_PS
                AND RS.N_OFERTAS > 1
            WHERE LSR.ID_SECTOR = 21
                AND (PRE.ID_POBLACION_PRE = 13152 OR ID_POBLACION_PP = 13152)
                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.0022227764129639

Tiempo acumulado:0.95989918708801

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[357]: SELECT *, PT.URL_PT URL_PRE, PT.TITULO_PT TITULO_PRE,PT.DESCRIPCION_PT DESCRIPCION_PRE,INCLUYE_PT INCLUYE_PRE,ALOJAMIENTO_PT ALOJAMIENTO_TEXT_PRE,TRANSPORTE_PT TRANSPORTE_TEXT_PRE,GALERIA_DESC_PT GALERIA_DESC_PRE,HORARIO_PT HORARIO_PRE, PT.DURACION_PT AS DURACION_PRE,PT.DESCRIPCION_PT DESCRIPCION_PP, 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
            INNER JOIN LO_PRECIOS_TRADUCCION_ES PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
                AND PT.IDIOMA_PT = 'es'
            WHERE SS.ID_TROPIC = 41
                AND SS.ID_FAM_SS IN (981,980,979)
                AND 1=1
                AND (PRE.ID_REGION_PRE = 435 OR (PP.ID_REGION_PP = 435
                AND PP.ID_POBLACION_PP IS NULL ))
                AND (PRE.ID_POBLACION_PRE = 13152 OR (ID_POBLACION_PP = 13152))
                AND SHOW_LANDING = 1
            GROUP BY ID_SUBSECTOR HAVING TOTAL_PRECIOS > 1
            ORDER BY ORDER_LANDING ASC;

Tiempo de la consulta: 0.0057389736175537

Tiempo acumulado:0.96563816070557

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

Tiempo de la consulta: 0.0014159679412842

Tiempo acumulado:0.96705412864685

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

Tiempo de la consulta: 0.0034289360046387

Tiempo acumulado:0.97048306465149

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[360]: 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_FR_STATS PS
            INNER JOIN LO_POBLACION_FR PO ON PO.ID_POBLACION = PS.ID_POBLACION
                AND PO.IDIOMA = 'es'
            INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PO.ID_REGION
                AND REI.IDIOMA = 'es'
            INNER JOIN LO_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='41'
                AND SECI.FK_ID_IDIOMA_SI18N = 'es'
            WHERE REI.ID_REGION = 435
                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.0055279731750488

Tiempo acumulado:0.97601103782654

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

Tiempo de la consulta: 0.00039386749267578

Tiempo acumulado:0.97640490531921

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[362]: SELECT URL_POBLACION, ID_POBLACION
            FROM LO_POBLACION_FR PO
            WHERE PO.ID_POBLACION = 12982
                AND PO.IDIOMA = 'fr';

Tiempo de la consulta: 0.00033092498779297

Tiempo acumulado:0.97673583030701

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

Tiempo de la consulta: 0.00034689903259277

Tiempo acumulado:0.9770827293396

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[364]: SELECT URL_POBLACION, ID_POBLACION
            FROM LO_POBLACION_FR PO
            WHERE PO.ID_POBLACION = 12875
                AND PO.IDIOMA = 'fr';

Tiempo de la consulta: 0.00031709671020508

Tiempo acumulado:0.9773998260498

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

Tiempo de la consulta: 0.00034785270690918

Tiempo acumulado:0.97774767875671

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[366]: SELECT URL_POBLACION, ID_POBLACION
            FROM LO_POBLACION_FR PO
            WHERE PO.ID_POBLACION = 13152
                AND PO.IDIOMA = 'fr';

Tiempo de la consulta: 0.00031900405883789

Tiempo acumulado:0.97806668281555

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

Tiempo de la consulta: 0.00033688545227051

Tiempo acumulado:0.97840356826782

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[368]: SELECT URL_POBLACION, ID_POBLACION
            FROM LO_POBLACION_FR PO
            WHERE PO.ID_POBLACION = 2000155
                AND PO.IDIOMA = 'fr';

Tiempo de la consulta: 0.00031399726867676

Tiempo acumulado:0.9787175655365

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[369]: 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_FR PO ON PO.ID_POBLACION = PRM.ID_POBLACION
                AND PO.IDIOMA = 'es'
            INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PO.ID_REGION
                AND REI.IDIOMA = 'es'
            INNER JOIN LO_POBLACION_FR_STATS POS ON POS.ID_POBLACION = PO.ID_POBLACION
                AND POS.ID_SECTOR = 21
                AND POS.N_OFERTAS > 1
            WHERE PRM.ID_REGION = 435;

Tiempo de la consulta: 0.0010800361633301

Tiempo acumulado:0.97979760169983

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

Tiempo de la consulta: 0.00075697898864746

Tiempo acumulado:0.98055458068848

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

Tiempo de la consulta: 0.00043702125549316

Tiempo acumulado:0.98099160194397

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

Tiempo de la consulta: 0.0004270076751709

Tiempo acumulado:0.98141860961914

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

Tiempo de la consulta: 0.00036287307739258

Tiempo acumulado:0.98178148269653

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

Tiempo de la consulta: 0.00032496452331543

Tiempo acumulado:0.98210644721985

(Prod_Yumping_fr_FR) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_desk
SQL[375]: SELECT SEO.KEYWORD
            FROM LO_SEO_KEYWORDS SEO
            WHERE SEO.ID_KEY = 'S21'
                AND (SEO.ID_TROPIC = 41
                AND (FK_ID_REG_ADM = 0 OR FK_ID_REG_ADM='26') );

Tiempo de la consulta: 0.00049281120300293

Tiempo acumulado:0.98259925842285

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

Tiempo de la consulta: 0.0013091564178467

Tiempo acumulado:0.9839084148407

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

Tiempo de la consulta: 0.00086808204650879

Tiempo acumulado:0.98477649688721

.Cerramos Conexiones BB.DD.

Rutas a Caballo Trébeurden 3 precios y ofertas 2025

3 Resultados

Paseo infantil en pony Côte de Granit Rose 1 hora

Paseo a caballo adulto Côte de Granit Rose 1 hora

Paseo a caballo por la playa de Penvern 2 horas

Experiencias reales de reservas de Rutas a Caballo en Trébeurden 5/5 (1 Opiniones)