yu-front-06.localdomain (172.30.2.194:443)
prod.yumping.com
/landings/landing.php
BBDD->Prod_Yumping_co_UK
AMBITO->gb_mx
AMBITO_AJAX->gb_mx
AMBITO_AJAX COOKIE->es_en
locale LO_CONFIG->es_MX
locale php->es_MX
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-MX
filtro1->laser-tag
filtro2->edimburgo
rel_alternate->1
paginado_ofertas->
npage->
Total queries: 261
Tiempo total: 0.8258683681488
>0.1 and < 2 (2)
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[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', 'mx')
ORDER BY CFG.NAME;
Tiempo de la consulta:
0.011703014373779Tiempo acumulado:0.011703014373779
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[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.00073385238647461Tiempo acumulado:0.012436866760254
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[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 = 'edimburgo'
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 = 'edimburgo' 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 = 'edimburgo'
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 = 'edimburgo' 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 = 'edimburgo'
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 = 'edimburgo' 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 = 'edimburgo'
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 = 'edimburgo' 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 = 'edimburgo'
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 = 'edimburgo' 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 = 'edimburgo'
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 = 'edimburgo' )AS FIND_REGION
GROUP BY ID_PAIS;
Tiempo de la consulta:
0.01176118850708Tiempo acumulado:0.024198055267334
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[4]: SELECT CFG.ID, CFG.NAME, IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '', CFG.VALUE_PROD, CFG.VALUE) VALUE , CFG.AMBITO, CFG.VISIBLE_AJAX, CFG.TIME
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.AMBITO IN ('global', 'gb_mx')
ORDER BY CFG.NAME;
Tiempo de la consulta:
0.014868974685669Tiempo acumulado:0.039067029953003
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[5]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.00036811828613281Tiempo acumulado:0.039435148239136
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[6]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.0003209114074707Tiempo acumulado:0.039756059646606
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[7]: SELECT `TIMESTAMP`, VALUE
FROM LO_CURRENCIES_CONVERSION
WHERE `FROM` = 'EUR'
AND `TO` = 'MXN';
Tiempo de la consulta:
0.00084686279296875Tiempo acumulado:0.040602922439575
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[8]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'ambito_lang';
Tiempo de la consulta:
0.00046682357788086Tiempo acumulado:0.041069746017456
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[9]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'filtro1';
Tiempo de la consulta:
0.00033903121948242Tiempo acumulado:0.041408777236938
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[10]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'filtro2';
Tiempo de la consulta:
0.0003509521484375Tiempo acumulado:0.041759729385376
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[11]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'rel_alternate';
Tiempo de la consulta:
0.0005500316619873Tiempo acumulado:0.042309761047363
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[12]: SELECT G.DESC_GRUPO, G.ID_GRUPO, G.URL AS URL_GRUPO
FROM LO_GRUPOS G
WHERE G.URL = 'laser-tag'
AND G.ID_TROPIC = 25;
Tiempo de la consulta:
0.00042104721069336Tiempo acumulado:0.042730808258057
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[13]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.URL = 'edimburgo'
AND IDIOMA = 'es';
Tiempo de la consulta:
0.00037288665771484Tiempo acumulado:0.043103694915771
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[14]: SELECT '1', RE.ID_REGION, REI.ID_REGION, REI.DESC_REGION, REI.URL URL_REGION, RE.ID_REGION_ADM1, RE.ID_PAIS, LATITUDE, LONGITUDE
FROM LO_REGION RE
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = RE.ID_REGION
WHERE RE.ID_REGION = 'edimburgo'
AND REI.IDIOMA = 'es';
Tiempo de la consulta:
0.00056004524230957Tiempo acumulado:0.043663740158081
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[15]: SELECT '2', RE.ID_REGION, REI.DESC_REGION, REI.URL URL_REGION, RE.ID_REGION_ADM1, RE.ID_PAIS, LATITUDE, LONGITUDE
FROM LO_REGION_I18N REI
INNER JOIN LO_REGION RE ON REI.ID_REGION=RE.ID_REGION
AND URL = 'edimburgo'
AND IDIOMA = 'es'
LIMIT 1;
Tiempo de la consulta:
0.00042104721069336Tiempo acumulado:0.044084787368774
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[16]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM LO_SECTORES_I18N SECI
INNER JOIN LO_SECTORES SEC ON SECI.ID_SECTOR=SEC.ID_SECTOR
WHERE SECI.URL = 'laser-tag'
AND ID_TROPIC = 25
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
LIMIT 1;
Tiempo de la consulta:
0.00071001052856445Tiempo acumulado:0.044794797897339
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[17]: SELECT ORDER_LANDING
FROM LO_SECTORES SEC
WHERE ID_SECTOR = 50;
Tiempo de la consulta:
0.00033688545227051Tiempo acumulado:0.045131683349609
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[18]: SELECT GRU.URL URL_GRUPO, GRU.DESC_GRUPO, ID_GRUPO
FROM LO_GRUPOS GRU
WHERE GRU.ID_GRUPO = 4
AND (GRU.ID_TROPIC = 25);
Tiempo de la consulta:
0.00036501884460449Tiempo acumulado:0.045496702194214
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[19]: SELECT *
FROM LO_SEO_KEYWORDS_LANDING SKL
WHERE SKL.ID_SECTOR = 50
AND ID_TROPIC = 25;
Tiempo de la consulta:
0.00087809562683105Tiempo acumulado:0.046374797821045
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[20]: SELECT *
FROM LO_REGION_SKI REI
WHERE URL = 'edimburgo'
AND REI.IDIOMA='es'
AND TIPO = 1;
Tiempo de la consulta:
0.0011401176452637Tiempo acumulado:0.047514915466309
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[21]: 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 = 3205
LIMIT 1;
Tiempo de la consulta:
0.00040411949157715Tiempo acumulado:0.047919034957886
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[22]: SELECT SQL_CALC_FOUND_ROWS ID_EMPRESA
FROM LO_EMPRESAS EMP
INNER JOIN LO_REGION RE ON RE.ID_REGION = EMP.ID_PROVINCIA
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_MX ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'mx'
WHERE EMP.VALID IN (1)
AND RE.ID_REGION = 3205
AND EMP.EMP_MADRE NOT IN (0)
AND EMP.ID_SECTOR=50
GROUP BY EMP.NOMBRE
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.0028460025787354Tiempo acumulado:0.050765037536621
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[23]: SELECT FOUND_ROWS() NEMPRESAS;
Tiempo de la consulta:
0.00028204917907715Tiempo acumulado:0.051047086715698
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[24]: 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_REGION
WHERE ID_REGION = 3205)),
0) AS LAT_PUBLI
, IF (EMP.EMP_MADRE = 3,
CONCAT((SELECT LONGITUDE
FROM LO_REGION
WHERE ID_REGION = 3205)),
0) AS LONG_PUBLI
/* ELIMINAMOS MAX(EMP.LICENCIA_EMPRESA) */
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_GB 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 = 25
INNER JOIN LO_EMPRESAS_STAT EMPS ON EMPS.FK_ID_EST = EMP.ID_EMPRESA
INNER JOIN LO_EMPRESAS_TRADUCCION_MX ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'mx'
WHERE EMP.ID_EMPRESA IN (19765513)
ORDER BY IF(N_PRECIOS_EST > 0 , 1 ,0) DESC, N_VENTAS_EST DESC,N_ORDER_TSP_EST DESC;
Tiempo de la consulta:
0.0039479732513428Tiempo acumulado:0.054995059967041
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[25]: SELECT N_OFERTAS AS NumOfertas, N_EMPRESAS AS TOTAL_EMPRESAS, PRECIO_MIN, IF ( MEDIA_AJUSTADA IS NOT NULL
AND MEDIA_AJUSTADA != 0
AND MEDIA_AJUSTADA < MEDIA_PRECIO, MEDIA_AJUSTADA, MEDIA_PRECIO ) AS MEDIA
FROM LO_REGION_STATS
WHERE ID_REGION = 3205
AND ID_SECTOR = 50
GROUP BY ID_SECTOR;
Tiempo de la consulta:
0.00049090385437012Tiempo acumulado:0.055485963821411
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[26]: SELECT SS.*,PSS.*, SSF.*, PRE.*, EMP.*, PP.*, PPO.*, COUNT(*) AS TOTAL
FROM LO_SUBSECTORES SS
INNER JOIN LO_PRECIOS_SUBSECTORES PSS ON SS.ID_SUBSECTOR = PSS.ID_ACTIVIDAD_PSS
INNER JOIN LO_SUBSECTORES_FAM SSF ON SS.ID_FAM_SS=SSF.ID_SSF
AND SSF.ID_TROPIC = 25
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_MX PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'mx'
WHERE SS.ID_TROPIC = 25
AND VALID_PRE=4
AND ID_SECTOR_SS = '50'
AND (PRE.ID_REGION_PRE = 3205 OR (PP.ID_REGION_PP = 3205
AND PP.ID_POBLACION_PP IS NULL ))
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.0040199756622314Tiempo acumulado:0.059505939483643
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[27]: SELECT SEO.DESCRIPTION
FROM LO_SEO_DESCRIPTIONS SEO
WHERE SEO.ID_TROPIC='25'
AND SEO.ID_KEY='S50';
Tiempo de la consulta:
0.0012907981872559Tiempo acumulado:0.060796737670898
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[28]: SELECT SEOHOME.DESCRIPTION,SEOHOME.DESCRIPTION2,SEOHOME.HEIGHT, SEOHOME.CONTENT_MANAGER, DATE_FORMAT(SEOHOME.FEC_INSERT, '%d/%m/%Y %H:%i') FECHA_INSERT, DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%d/%m/%Y %H:%i') FECHA_MOD, CA.NOMBRE, CA.ID,DATE_FORMAT(SEOHOME.FEC_INSERT, '%Y-%m-%dT%H:%i') IN_GOOGLE,
DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%Y-%m-%dT%H:%i') MOD_GOOGLE,AU.ID_ADMIN, GALERIA, GALERIA_DESC, CA.JOB,
DATE_FORMAT(SEOHOME.FEC_INSERT, '%d') DAY_INSERT,
DATE_FORMAT(SEOHOME.FEC_INSERT, '%m') MONTH_INSERT,
DATE_FORMAT(SEOHOME.FEC_INSERT, '%Y') YEAR_INSERT,
DATE_FORMAT(SEOHOME.FEC_INSERT, '%H:%i') HORA_INSERT,
DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%d') DAY_MOD,
DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%m') MONTH_MOD,
DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%Y') YEAR_MOD,
DATE_FORMAT(SEOHOME.FEC_MODIFICACION, '%H:%i') HORA_MOD
FROM LO_SEO_DESCRIPTIONS_HOME SEOHOME
LEFT JOIN LO_ADMIN_USERS AU ON AU.LOGIN = SEOHOME.CONTENT_MANAGER
LEFT JOIN LO_CONTENIDO_AUTORES CA ON CA.ID_ADMIN = AU.ID_ADMIN
AND CA.ID_TROPIC = 25
WHERE SEOHOME.ID_TROPIC = 25
AND SEOHOME.ID_KEY = 'S50'
AND SEO_VALID in (0,1)
AND SEOHOME.ID_LOCALIZACION='3205';
Tiempo de la consulta:
0.0046608448028564Tiempo acumulado:0.065457582473755
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[29]: SELECT OLD_URL, NEW_URL
FROM LO_URL_301 U
WHERE U.OLD_URL = '/es-MX/laser-tag/edimburgo';
Tiempo de la consulta:
0.00045990943908691Tiempo acumulado:0.065917491912842
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[30]: SELECT *
FROM LO_SEO_DESCRIPTIONS_HOME SEO
WHERE SEO.ID_TROPIC='25'
AND SEO.ID_KEY='S50'
AND SEO.ID_LOCALIZACION='3205';
Tiempo de la consulta:
0.0052840709686279Tiempo acumulado:0.07120156288147
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[31]: SELECT TITLE, DESCRIPTION, KEYWORDS, ID_KEY
FROM LO_SEO_HEADERS SEO
WHERE SEO.ID_TROPIC='25'
AND VALID='1'
AND SEO.ID_KEY='S50';
Tiempo de la consulta:
0.0030379295349121Tiempo acumulado:0.074239492416382
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[32]: 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 = 'laser-tag'
AND ID_TROPIC = 25
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
LIMIT 1;
Tiempo de la consulta:
0.0047059059143066Tiempo acumulado:0.078945398330688
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[33]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0016739368438721Tiempo acumulado:0.080619335174561
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[34]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0020718574523926Tiempo acumulado:0.082691192626953
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[35]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046515464782715Tiempo acumulado:0.08315634727478
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[36]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM Prod_Yumping_co_UK.LO_SECTORES SEC
INNER JOIN Prod_Yumping_co_UK.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
WHERE SEC.ID_SECTOR=50
AND SECI.FK_ID_IDIOMA_SI18N = 'en'
AND SECI.ID_TROPIC=2;
Tiempo de la consulta:
0.002068042755127Tiempo acumulado:0.085224390029907
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[37]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.002734899520874Tiempo acumulado:0.087959289550781
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[38]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.001086950302124Tiempo acumulado:0.089046239852905
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[39]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
FROM LO_REGION RE, LO_REGION_I18N REI
WHERE REI.URL = 'edimburgo'
AND REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'es';
Tiempo de la consulta:
0.0022809505462646Tiempo acumulado:0.09132719039917
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[40]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00057291984558105Tiempo acumulado:0.091900110244751
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[41]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00069379806518555Tiempo acumulado:0.092593908309937
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[42]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043010711669922Tiempo acumulado:0.093024015426636
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[43]: SELECT RE.ID_REGION, REI.DESC_REGION,REI.URL URL_REGION
FROM Prod_Yumping_co_UK.LO_REGION RE, Prod_Yumping_co_UK.LO_REGION_I18N REI
WHERE RE.ID_REGION=3205
AND RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA = 'en';
Tiempo de la consulta:
0.00058579444885254Tiempo acumulado:0.093609809875488
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[44]: 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 = 'laser-tag'
AND ID_TROPIC = 25
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
LIMIT 1;
Tiempo de la consulta:
0.00077581405639648Tiempo acumulado:0.094385623931885
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[45]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050687789916992Tiempo acumulado:0.094892501831055
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[46]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('gb_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004889965057373Tiempo acumulado:0.095381498336792
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[47]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('gb_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00075292587280273Tiempo acumulado:0.096134424209595
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[48]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM Prod_Yumping_co_UK.LO_SECTORES SEC
INNER JOIN Prod_Yumping_co_UK.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
WHERE SEC.ID_SECTOR=50
AND SECI.FK_ID_IDIOMA_SI18N = 'it'
AND SECI.ID_TROPIC=23;
Tiempo de la consulta:
0.00053191184997559Tiempo acumulado:0.09666633605957
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[49]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('gb_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00048589706420898Tiempo acumulado:0.097152233123779
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[50]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('gb_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00051116943359375Tiempo acumulado:0.097663402557373
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[51]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
FROM LO_REGION RE, LO_REGION_I18N REI
WHERE REI.URL = 'edimburgo'
AND REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'es';
Tiempo de la consulta:
0.00044989585876465Tiempo acumulado:0.098113298416138
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[52]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('gb_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00054597854614258Tiempo acumulado:0.09865927696228
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[53]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('gb_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0007781982421875Tiempo acumulado:0.099437475204468
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[54]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00058507919311523Tiempo acumulado:0.10002255439758
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[55]: SELECT RE.ID_REGION, REI.DESC_REGION,REI.URL URL_REGION
FROM Prod_Yumping_co_UK.LO_REGION RE, Prod_Yumping_co_UK.LO_REGION_I18N REI
WHERE RE.ID_REGION=3205
AND RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA = 'it';
Tiempo de la consulta:
0.00037407875061035Tiempo acumulado:0.10039663314819
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[56]: 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 = 'laser-tag'
AND ID_TROPIC = 25
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
LIMIT 1;
Tiempo de la consulta:
0.00089502334594727Tiempo acumulado:0.10129165649414
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[57]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0014200210571289Tiempo acumulado:0.10271167755127
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[58]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('gb_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047898292541504Tiempo acumulado:0.10319066047668
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[59]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('gb_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004727840423584Tiempo acumulado:0.10366344451904
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[60]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM Prod_Yumping_co_UK.LO_SECTORES SEC
INNER JOIN Prod_Yumping_co_UK.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
WHERE SEC.ID_SECTOR=50
AND SECI.FK_ID_IDIOMA_SI18N = 'fr'
AND SECI.ID_TROPIC=24;
Tiempo de la consulta:
0.00054788589477539Tiempo acumulado:0.10421133041382
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[61]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('gb_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047397613525391Tiempo acumulado:0.10468530654907
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[62]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('gb_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00044584274291992Tiempo acumulado:0.10513114929199
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[63]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
FROM LO_REGION RE, LO_REGION_I18N REI
WHERE REI.URL = 'edimburgo'
AND REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'es';
Tiempo de la consulta:
0.00043606758117676Tiempo acumulado:0.10556721687317
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[64]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('gb_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043606758117676Tiempo acumulado:0.10600328445435
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[65]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('gb_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046491622924805Tiempo acumulado:0.10646820068359
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[66]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00044107437133789Tiempo acumulado:0.10690927505493
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[67]: SELECT RE.ID_REGION, REI.DESC_REGION,REI.URL URL_REGION
FROM Prod_Yumping_co_UK.LO_REGION RE, Prod_Yumping_co_UK.LO_REGION_I18N REI
WHERE RE.ID_REGION=3205
AND RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA = 'fr';
Tiempo de la consulta:
0.0003659725189209Tiempo acumulado:0.10727524757385
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[68]: 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 = 'laser-tag'
AND ID_TROPIC = 25
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
LIMIT 1;
Tiempo de la consulta:
0.00074601173400879Tiempo acumulado:0.10802125930786
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[69]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00059390068054199Tiempo acumulado:0.1086151599884
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[70]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('gb_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046396255493164Tiempo acumulado:0.10907912254333
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[71]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('gb_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00052094459533691Tiempo acumulado:0.10960006713867
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[72]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM Prod_Yumping_co_UK.LO_SECTORES SEC
INNER JOIN Prod_Yumping_co_UK.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
WHERE SEC.ID_SECTOR=50
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
AND SECI.ID_TROPIC=21;
Tiempo de la consulta:
0.00058197975158691Tiempo acumulado:0.11018204689026
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[73]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('gb_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047183036804199Tiempo acumulado:0.1106538772583
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[74]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('gb_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00044798851013184Tiempo acumulado:0.11110186576843
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[75]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
FROM LO_REGION RE, LO_REGION_I18N REI
WHERE REI.URL = 'edimburgo'
AND REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'es';
Tiempo de la consulta:
0.00055694580078125Tiempo acumulado:0.11165881156921
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[76]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('gb_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00053501129150391Tiempo acumulado:0.11219382286072
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[77]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('gb_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050497055053711Tiempo acumulado:0.11269879341125
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[78]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00063395500183105Tiempo acumulado:0.11333274841309
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[79]: SELECT RE.ID_REGION, REI.DESC_REGION,REI.URL URL_REGION
FROM Prod_Yumping_co_UK.LO_REGION RE, Prod_Yumping_co_UK.LO_REGION_I18N REI
WHERE RE.ID_REGION=3205
AND RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA = 'es';
Tiempo de la consulta:
0.00041604042053223Tiempo acumulado:0.11374878883362
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[80]: 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 = 'laser-tag'
AND ID_TROPIC = 25
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
LIMIT 1;
Tiempo de la consulta:
0.00069594383239746Tiempo acumulado:0.11444473266602
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[81]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00069594383239746Tiempo acumulado:0.11514067649841
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[82]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('gb_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00069117546081543Tiempo acumulado:0.11583185195923
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[83]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('gb_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00044989585876465Tiempo acumulado:0.11628174781799
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[84]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM Prod_Yumping_co_UK.LO_SECTORES SEC
INNER JOIN Prod_Yumping_co_UK.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
WHERE SEC.ID_SECTOR=50
AND SECI.FK_ID_IDIOMA_SI18N = 'pt'
AND SECI.ID_TROPIC=28;
Tiempo de la consulta:
0.00050997734069824Tiempo acumulado:0.11679172515869
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[85]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('gb_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0032989978790283Tiempo acumulado:0.12009072303772
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[86]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('gb_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0025558471679688Tiempo acumulado:0.12264657020569
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[87]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
FROM LO_REGION RE, LO_REGION_I18N REI
WHERE REI.URL = 'edimburgo'
AND REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'es';
Tiempo de la consulta:
0.00049400329589844Tiempo acumulado:0.12314057350159
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[88]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('gb_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046992301940918Tiempo acumulado:0.123610496521
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[89]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('gb_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0039610862731934Tiempo acumulado:0.12757158279419
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[90]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00089597702026367Tiempo acumulado:0.12846755981445
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[91]: SELECT RE.ID_REGION, REI.DESC_REGION,REI.URL URL_REGION
FROM Prod_Yumping_co_UK.LO_REGION RE, Prod_Yumping_co_UK.LO_REGION_I18N REI
WHERE RE.ID_REGION=3205
AND RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA = 'pt';
Tiempo de la consulta:
0.00096511840820312Tiempo acumulado:0.12943267822266
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[92]: 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 = 'laser-tag'
AND ID_TROPIC = 25
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
LIMIT 1;
Tiempo de la consulta:
0.00067591667175293Tiempo acumulado:0.13010859489441
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[93]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0010762214660645Tiempo acumulado:0.13118481636047
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[94]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0038819313049316Tiempo acumulado:0.13506674766541
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[95]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0030519962310791Tiempo acumulado:0.13811874389648
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[96]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM Prod_Yumping_co_UK.LO_SECTORES SEC
INNER JOIN Prod_Yumping_co_UK.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
WHERE SEC.ID_SECTOR=50
AND SECI.FK_ID_IDIOMA_SI18N = 'de'
AND SECI.ID_TROPIC=27;
Tiempo de la consulta:
0.0014050006866455Tiempo acumulado:0.13952374458313
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[97]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00066709518432617Tiempo acumulado:0.14019083976746
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[98]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0013728141784668Tiempo acumulado:0.14156365394592
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[99]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
FROM LO_REGION RE, LO_REGION_I18N REI
WHERE REI.URL = 'edimburgo'
AND REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'es';
Tiempo de la consulta:
0.0029258728027344Tiempo acumulado:0.14448952674866
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[100]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0026850700378418Tiempo acumulado:0.1471745967865
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[101]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0027210712432861Tiempo acumulado:0.14989566802979
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[102]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0037751197814941Tiempo acumulado:0.15367078781128
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[103]: SELECT RE.ID_REGION, REI.DESC_REGION,REI.URL URL_REGION
FROM Prod_Yumping_co_UK.LO_REGION RE, Prod_Yumping_co_UK.LO_REGION_I18N REI
WHERE RE.ID_REGION=3205
AND RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA = 'de';
Tiempo de la consulta:
0.0057258605957031Tiempo acumulado:0.15939664840698
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[104]: 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 = 'laser-tag'
AND ID_TROPIC = 25
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
LIMIT 1;
Tiempo de la consulta:
0.00089883804321289Tiempo acumulado:0.1602954864502
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[105]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00089502334594727Tiempo acumulado:0.16119050979614
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[106]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0048630237579346Tiempo acumulado:0.16605353355408
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[107]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0009768009185791Tiempo acumulado:0.16703033447266
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[108]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM Prod_Yumping_co_UK.LO_SECTORES SEC
INNER JOIN Prod_Yumping_co_UK.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
WHERE SEC.ID_SECTOR=50
AND SECI.FK_ID_IDIOMA_SI18N = 'ch'
AND SECI.ID_TROPIC=26;
Tiempo de la consulta:
0.00078511238098145Tiempo acumulado:0.16781544685364
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[109]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00066304206848145Tiempo acumulado:0.16847848892212
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[110]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00058317184448242Tiempo acumulado:0.1690616607666
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[111]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
FROM LO_REGION RE, LO_REGION_I18N REI
WHERE REI.URL = 'edimburgo'
AND REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'es';
Tiempo de la consulta:
0.0089669227600098Tiempo acumulado:0.17802858352661
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[112]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00054001808166504Tiempo acumulado:0.17856860160828
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[113]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0018188953399658Tiempo acumulado:0.18038749694824
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[114]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('gb_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045609474182129Tiempo acumulado:0.18084359169006
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[115]: SELECT RE.ID_REGION, REI.DESC_REGION,REI.URL URL_REGION
FROM Prod_Yumping_co_UK.LO_REGION RE, Prod_Yumping_co_UK.LO_REGION_I18N REI
WHERE RE.ID_REGION=3205
AND RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA = 'ch';
Tiempo de la consulta:
0.00061893463134766Tiempo acumulado:0.18146252632141
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[116]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.006065845489502Tiempo acumulado:0.18752837181091
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[117]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0034720897674561Tiempo acumulado:0.19100046157837
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[118]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0035700798034668Tiempo acumulado:0.19457054138184
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[119]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0018010139465332Tiempo acumulado:0.19637155532837
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[120]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('gb', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00065803527832031Tiempo acumulado:0.19702959060669
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[121]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043988227844238Tiempo acumulado:0.19746947288513
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[122]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00044393539428711Tiempo acumulado:0.19791340827942
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[123]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043892860412598Tiempo acumulado:0.19835233688354
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[124]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043702125549316Tiempo acumulado:0.19878935813904
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[125]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('gb_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00052618980407715Tiempo acumulado:0.19931554794312
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[126]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042295455932617Tiempo acumulado:0.19973850250244
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[127]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045204162597656Tiempo acumulado:0.20019054412842
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[128]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046706199645996Tiempo acumulado:0.20065760612488
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[129]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00044012069702148Tiempo acumulado:0.2010977268219
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[130]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('gb_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00044488906860352Tiempo acumulado:0.2015426158905
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[131]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043511390686035Tiempo acumulado:0.20197772979736
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[132]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043606758117676Tiempo acumulado:0.20241379737854
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[133]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain'
AND CFG.AMBITO IN ('gb_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047612190246582Tiempo acumulado:0.20288991928101
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[134]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004429817199707Tiempo acumulado:0.20333290100098
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[135]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043010711669922Tiempo acumulado:0.20376300811768
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[136]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('gb_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00071120262145996Tiempo acumulado:0.20447421073914
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[137]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0058889389038086Tiempo acumulado:0.21036314964294
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[138]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0015339851379395Tiempo acumulado:0.21189713478088
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[139]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00059390068054199Tiempo acumulado:0.21249103546143
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[140]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.000885009765625Tiempo acumulado:0.21337604522705
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[141]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('gb_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046801567077637Tiempo acumulado:0.21384406089783
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[142]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041604042053223Tiempo acumulado:0.21426010131836
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[143]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043916702270508Tiempo acumulado:0.21469926834106
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[144]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00040292739868164Tiempo acumulado:0.21510219573975
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[145]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00040078163146973Tiempo acumulado:0.21550297737122
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[146]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('gb_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042104721069336Tiempo acumulado:0.21592402458191
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[147]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00044393539428711Tiempo acumulado:0.2163679599762
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[148]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042605400085449Tiempo acumulado:0.21679401397705
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[149]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00040483474731445Tiempo acumulado:0.21719884872437
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[150]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004270076751709Tiempo acumulado:0.21762585639954
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[151]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('gb_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043392181396484Tiempo acumulado:0.2180597782135
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[152]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('gb_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0029871463775635Tiempo acumulado:0.22104692459106
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[153]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.ID_PAIS = 247
AND IDIOMA = 'es';
Tiempo de la consulta:
0.0061609745025635Tiempo acumulado:0.22720789909363
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[154]: SELECT SEOHOME.TITLE, SEOHOME.METADESCRIPTION,SEOHOME.DESCRIPTION,SEOHOME.DESCRIPTION2,SEOHOME.HEIGHT
FROM LO_SEO_DESCRIPTIONS_HOME SEOHOME
WHERE SEOHOME.ID_TROPIC = 25
AND SEOHOME.ID_KEY='S50'
AND SEOHOME.ID_LOCALIZACION='3205';
Tiempo de la consulta:
0.0087440013885498Tiempo acumulado:0.23595190048218
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[155]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.0054049491882324Tiempo acumulado:0.24135684967041
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[156]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.0016181468963623Tiempo acumulado:0.24297499656677
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[157]: SELECT N_OPIS AS TOTAL, MEDIA_OPIS_5 AS MEDIA, ROUND(MEDIA_OPIS_100,0) AS MEDIA2
FROM LO_REGION_STATS
WHERE ID_REGION = 3205
AND ID_SECTOR = 50;
Tiempo de la consulta:
0.0027239322662354Tiempo acumulado:0.24569892883301
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[158]: 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 = 50
AND PRE.ID_REGION_PRE ='3205'
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 = 50
AND PRE.ID_REGION_PRE ='3205'
/* 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 = 50
AND PRE.ID_REGION_PRE ='3205'
*/ ) AS PRECIO_MIN_MAX;
Tiempo de la consulta:
0.0021848678588867Tiempo acumulado:0.24788379669189
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[159]: SELECT *
FROM LO_SEO_KEYWORDS_LANDING SKL
WHERE SKL.ID_SECTOR = 50
AND SKL.ID_TROPIC = 25;
Tiempo de la consulta:
0.0013060569763184Tiempo acumulado:0.24918985366821
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[160]: SELECT '1' as TIPO, PRE.N_VENTAS_PRE AS VENTAS , IF(PP.ID_REGION_PP = 3205
AND PP.ID_POBLACION_PP IS NULL,1,IF (PT.N_ORDER_VENTAS_TROPIC = '0.0', 2, 0)) AS ES_PUBLI , IF (PRE.N_ORDER_VENTAS_TROPIC = '0.0', RCER.DISTANCIA_REAL +10000, RCER.DISTANCIA_REAL) AS DIST_REAL, RCER.DISTANCIA_REAL, RCER.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_MX PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'mx'
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_REGIONES_CERCANAS RCER ON RCER.ID_PROVINCIA_CERCANA = PRE.ID_REGION_PRE
AND RCER.ID_PROVINCIA = 3205
/*
INNER JOIN LO_POBLACION_GB 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 = 50 OR (ID_SECTOR_PP = 50
AND PP.ID_REGION_PP = 3205))
AND (PRE.ID_REGION_PRE = 3205 OR (PP.ID_REGION_PP = 3205
AND PP.ID_POBLACION_PP IS NULL ))
AND (PR.PROVINCIA = 0 OR PR.PROVINCIA 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.1494288444519Tiempo acumulado:0.39861869812012
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[161]: SELECT count(*) as NOFERTAS
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_MX PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'mx'
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_REGIONES_CERCANAS RCER ON RCER.ID_PROVINCIA_CERCANA = PRE.ID_REGION_PRE
AND RCER.ID_PROVINCIA = 3205
/*
INNER JOIN LO_POBLACION_GB 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 = 50 OR (ID_SECTOR_PP = 50
AND PP.ID_REGION_PP = 3205))
AND (PRE.ID_REGION_PRE = 3205 OR (PP.ID_REGION_PP = 3205
AND PP.ID_POBLACION_PP IS NULL ))
AND (PR.PROVINCIA = 0 OR PR.PROVINCIA IS NULL OR IF(PR.FECHA_INICIO IS NOT NULL,
CONCAT(DATE_FORMAT(NOW(), '%Y-'),DATE_FORMAT(PR.FECHA_INICIO, '%m-%d')) <= CONCAT(DATE_FORMAT(NOW(), '%Y-'),DATE_FORMAT(NOW(), '%m-%d'))
AND IF(DATE_FORMAT(PR.FECHA_FIN, '%m') >= DATE_FORMAT(PR.FECHA_INICIO, '%m'),
CONCAT(DATE_FORMAT(NOW(), '%Y-'),DATE_FORMAT(PR.FECHA_FIN, '%m-%d')) >= CONCAT(DATE_FORMAT(NOW(), '%Y-'),DATE_FORMAT(NOW(), '%m-%d')),
CONCAT( (1+DATE_FORMAT(NOW(), '%Y')),'-',DATE_FORMAT(PR.FECHA_FIN, '%m-%d')) >= CONCAT( DATE_FORMAT(NOW(), '%Y'),'-',DATE_FORMAT(NOW(), '%m-%d')))
,1!=1) )
GROUP BY PRE.ID_PRECIO;
Tiempo de la consulta:
0.083580017089844Tiempo acumulado:0.48219871520996
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[162]: SELECT '3' as TIPO, PRE.N_VENTAS_PRE AS VENTAS , IF(PP.ID_REGION_PP = 3205
AND PP.ID_POBLACION_PP IS NULL,1,IF (PT.N_ORDER_VENTAS_TROPIC = '0.0', 2, 0)) AS ES_PUBLI , IF (PRE.N_ORDER_VENTAS_TROPIC = '0.0', RCER.DISTANCIA_REAL +10000, RCER.DISTANCIA_REAL) AS DIST_REAL, RCER.DISTANCIA_REAL, RCER.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_MX PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'mx'
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 = 25)
LEFT JOIN LO_REGIONES_CERCANAS RCER ON RCER.ID_PROVINCIA_CERCANA = PRE.ID_REGION_PRE
AND RCER.ID_PROVINCIA = 3205
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_GB 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 (69733)
AND PRE.VALID_PRE = 4
AND (PS.ID_ACTIVIDAD_PS = 50 OR (ID_SECTOR_PP = 50
AND PP.ID_REGION_PP = 3205))
AND (PRE.ID_REGION_PRE = 3205 OR (PP.ID_REGION_PP = 3205
AND PP.ID_POBLACION_PP IS NULL ))
AND (PR.PROVINCIA = 0 OR PR.PROVINCIA 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.0044808387756348Tiempo acumulado:0.4866795539856
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[163]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'O1'
AND SEO.ID_TROPIC = 25
AND SEO.FK_ID_REG_ADM = 0
AND 1=1;
Tiempo de la consulta:
0.00053787231445312Tiempo acumulado:0.48721742630005
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[164]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S50'
AND SEO.ID_TROPIC = 25
AND SEO.FK_ID_REG_ADM = 0
AND 1=1;
Tiempo de la consulta:
0.00043797492980957Tiempo acumulado:0.48765540122986
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[165]: SELECT *
FROM LO_PRECIOS_CALENDARIO PC
WHERE PC.ID_PRECIO_PC = 69733
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.012798070907593Tiempo acumulado:0.50045347213745
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[166]: SELECT (PRE.PERIODO_PRE) AS PERIODO
FROM LO_PRECIOS PRE
WHERE PRE.ID_PRECIO = 69733
UNION ALL
SELECT PD.PERIODO_PD AS PERIODO
FROM LO_PRECIOS_DESCUENTOS PD
WHERE PD.ID_PRECIO_PD = 69733
AND PD.VALID_PD = 1;
Tiempo de la consulta:
0.00083804130554199Tiempo acumulado:0.50129151344299
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[167]: 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 = 25
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 = 69733
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 = 25
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 = 69733
GROUP BY PRE.ID_PRECIO
) AS X;
Tiempo de la consulta:
0.0024058818817139Tiempo acumulado:0.50369739532471
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[168]: SELECT *
FROM LO_PRECIOS_MODIFICAR_ORDEN
WHERE ID_PRECIO = 69733
AND DATE_FORMAT(FECHA, '%Y-%m-%d') >= NOW() - INTERVAL 3 MONTH;
Tiempo de la consulta:
0.00081110000610352Tiempo acumulado:0.50450849533081
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[169]: 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_MX ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'mx'
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_GB 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 = 25
AND SECI.FK_ID_IDIOMA_SI18N = 'es')
INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
AND (GRU.ID_TROPIC = 25)
WHERE EMP.ID_EMPRESA = 19765509
AND EMP.VALID IN ('1', '-3')
LIMIT 1;
Tiempo de la consulta:
0.0018057823181152Tiempo acumulado:0.50631427764893
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[170]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 69733
AND VALID = 1;
Tiempo de la consulta:
0.001655101776123Tiempo acumulado:0.50796937942505
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[171]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 69733
AND FOTO = 'p-69733-1_16213306153224.jpeg'
AND VALID = 1;
Tiempo de la consulta:
0.00045108795166016Tiempo acumulado:0.50842046737671
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[172]: SELECT F_WIDTH, F_HEIGHT
FROM LO_FOTOS
WHERE ID_PRECIO = 69733
AND FOTO = 'p-69733-1_16213306153224.jpeg';
Tiempo de la consulta:
0.00050997734069824Tiempo acumulado:0.50893044471741
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[173]: 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_MX PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'mx'
WHERE PRE.ID_PRECIO = 69733;
Tiempo de la consulta:
0.00096988677978516Tiempo acumulado:0.50990033149719
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[174]: 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 = 69733;
Tiempo de la consulta:
0.00049710273742676Tiempo acumulado:0.51039743423462
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[175]: SELECT *
FROM LO_EMPRESAS_OPINIONES_GOOGLE
WHERE ID_PRECIO = 69733;
Tiempo de la consulta:
0.00053906440734863Tiempo acumulado:0.51093649864197
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[176]: SELECT N_VENTAS_LAST_MONTH
FROM LO_PRECIOS_STATS PS
WHERE PS.ID_PRECIO = 69733;
Tiempo de la consulta:
0.00094699859619141Tiempo acumulado:0.51188349723816
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[177]: 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_MX PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'mx'
WHERE ID_PRECIO = 69733
AND VALID_PRE = 4
GROUP BY PRE.ID_PRECIO
HAVING FEC_ULT_COMPRA IS NOT NULL
LIMIT 1;
Tiempo de la consulta:
0.00045299530029297Tiempo acumulado:0.51233649253845
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[178]: SELECT EXITO
FROM LO_PRECIOS_EXITO
WHERE ID_PRECIO = 69733
LIMIT 1;
Tiempo de la consulta:
0.00035786628723145Tiempo acumulado:0.51269435882568
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[179]: SELECT COUNT(*) AS TOTAL
FROM LO_PRECIOS_SECTORES PS
WHERE PS.ID_ACTIVIDAD_PS NOT IN (100,101)
AND PS.ID_PRECIO_PS = 69733;
Tiempo de la consulta:
0.00047111511230469Tiempo acumulado:0.51316547393799
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[180]: SELECT *
FROM LO_PRECIOS_DIA_ESPECIAL PD
WHERE PD.ID_PRECIO_DE = 69733
AND ID_TIPO_DE = 7
AND VALID = 1;
Tiempo de la consulta:
0.00037908554077148Tiempo acumulado:0.51354455947876
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[181]: 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_MX PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'mx'
WHERE PRE.ID_PRECIO = 69733;
Tiempo de la consulta:
0.00049304962158203Tiempo acumulado:0.51403760910034
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[182]: 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 = 69733;
Tiempo de la consulta:
0.00043392181396484Tiempo acumulado:0.51447153091431
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[183]: 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 = '3205'
AND REI.IDIOMA = 'es';
Tiempo de la consulta:
0.00042891502380371Tiempo acumulado:0.51490044593811
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[184]: 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 = '50';
Tiempo de la consulta:
0.00096297264099121Tiempo acumulado:0.5158634185791
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[185]: 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('55.9117431641'))
* cos(radians(P.LATITUDE))
* cos(radians(P.LONGITUDE) - radians('-3.2770969868'))
+ sin(radians('55.9117431641'))
* sin(radians(P.LATITUDE))
)
) AS DISTANCIA
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_MX PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'mx'
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 = 25 )
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=50 OR ID_SECTOR_PP = 50)
AND (PRE.ID_REGION_PRE != 3205
AND IF(PP.ID_REGION_PP IS NOT NULL
AND PP.ID_REGION_PP != 0, PP.ID_REGION_PP != 3205, 1=1))
GROUP BY PRE.ID_PRECIO HAVING CAST(DISTANCIA AS UNSIGNED) <=50
ORDER BY DISTANCIA ASC, PT.N_ORDER_VENTAS_TROPIC DESC ,PRE.ID_PRECIO ASC
LIMIT 19;
Tiempo de la consulta (slow_query): 0.17934012413025Tiempo acumulado:0.69520354270935
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[186]: SELECT FOUND_ROWS() NOFERTAS;
Tiempo de la consulta:
0.004986047744751Tiempo acumulado:0.7001895904541
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[187]: SELECT
SYSDATE() AS FECHA_ACTUAL,
EMPS.PUNTOS_EST, EMPS.NOPINIONES_EST, PREST.N_VENTAS AS N_VENTAS_ORDER,
PREST.N_OPINIONES,PREST.PUNTUACION_GENERAL, PREST.PUNTUACION_REGION,
PO.DESC_POBLACION,
REI.DESC_REGION,
PP.ID_REGION_PP, PP.DESCRIPCION_PP,
REI.URL URL_REGION ,
SECI.DESC_SECTOR,
SECI.URL URL_SECTOR,
SECI.ID_SECTOR,
EMP.ID_EMPRESA, EMP.NOMBRE AS NOMBRE_EMPRESA, EMP.URL URL, EMP.FOTOPRINCIPAL,
IF(EMP.ID_PROVINCIA=PRE.ID_REGION_PRE,EMP.LATITUDE, REG.LATITUDE) LATITUDE,
IF(EMP.ID_PROVINCIA=PRE.ID_REGION_PRE,EMP.LONGITUDE, REG.LONGITUDE) LONGITUDE,
LEAST(if(PRECIO_MIN_PRE>0,PRECIO_MIN_PRE,PRECIO_PRE),PRECIO_PRE) PRECIO,
if(PRECIO_PD>0,LEAST(MIN(PRECIO_PD),PRECIO_PRE),LEAST(999999999,PRECIO_PRE) ) PRECIO_D,
IF(PD.PRECIO_PD > 0
AND PD.VALID_PD = 1, (1 - (MIN(PD.PRECIO_PD) / PRE.PRECIO_PRE))*100 , 0) AS DESCUENTO,
EMP.DS_ACTIVO AS CENTRAL_ACTIVA,
TRUNCATE(AVG(OP.VALORACION),0) AS VALORACION,COUNT(DISTINCT OP.ID_OPINION) AS OPIS, COUNT(DISTINCT RC.ID_RESERVA_COMPRA) AS VENTAS,
PRE.GALERIA_PRE, PRE.GALERIA_DESC_PRE, PRE.ID_PRECIO, PRE.FOTOPRINCIPAL_PRE, PRE.ALOJAMIENTO_PRE , PRE.PRECIO_UNITARIO_PRE,
PRE.MIN_PERS_PRE, PRE.MULTIACTIVIDAD_PRE, PRE.TITULO_PRE, PRE.DESCRIPCION_PRE,
PRE.MAX_PERS_PRE, PRE.ID_EMPRESA_PRE, DATE_FORMAT(PRE.FEC_ULT_COMPRA,'%d/%m/%Y') AS FEC_ULT_COMPRA, PRE.PRECIO_PRE, PRE.FK_ID_PAIS_PRE AS ID_PAIS, PRE.N_ORDER_VENTAS_TROPIC,
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,
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,
EXI.N_VENTAS, EXI.EXITO
,(6378
* acos(cos(radians('55.9117431641'))
* cos(radians(P.LATITUDE))
* cos(radians(P.LONGITUDE) - radians('-3.2770969868'))
+ sin(radians('55.9117431641'))
* sin(radians(P.LATITUDE))
)
) AS DISTANCIA
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_MX PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'mx'
LEFT JOIN LO_PRECIOS_POBLACIONES PPO ON PPO.ID_PRECIO = PRE.ID_PRECIO
INNER JOIN LO_PRECIOS_SECTORES PS ON PRE.ID_PRECIO=PS.ID_PRECIO_PS
INNER JOIN LO_EMPRESAS EMP ON PRE.ID_EMPRESA_PRE=EMP.ID_EMPRESA
AND (EMP.VALID IN (1,'-3'))
INNER JOIN LO_EMPRESAS_STAT EMPS ON EMP.ID_EMPRESA = EMPS.FK_ID_EST
INNER JOIN LO_SECTORES SEC ON PS.ID_ACTIVIDAD_PS = SEC.ID_SECTOR
INNER JOIN LO_SECTORES_I18N SECI ON SEC.ID_SECTOR=SECI.ID_SECTOR
AND (SECI.ID_TROPIC=25
AND SECI.FK_ID_IDIOMA_SI18N='es')
INNER JOIN LO_POBLACION P ON P.ID_POBLACION = PRE.ID_POBLACION_PRE
INNER JOIN LO_POBLACION_GB PO ON PO.ID_POBLACION = PRE.ID_POBLACION_PRE
AND PO.IDIOMA='es'
INNER JOIN LO_REGION REG ON REG.ID_REGION=PRE.ID_REGION_PRE
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PRE.ID_REGION_PRE
AND REI.IDIOMA='es'
LEFT JOIN LO_PRECIOS_EXITO EXI ON EXI.ID_PRECIO = PRE.ID_PRECIO
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
LEFT JOIN LO_EMPRESAS_ULTIMO_LISTADO EUL ON (EUL.ID_EMPRESA = PRE.ID_EMPRESA_PRE OR EUL.ID_EMPRESA IN( SELECT ID_EMPRESA
FROM LO_EMPRESAS EMP_S
WHERE EMP_S.ID_MADRE = EMP.ID_EMPRESA
AND EMP_S.ID_SECTOR = '50'))
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
LEFT JOIN LO_PRECIOS_RESTRICCIONES PR ON PRE.ID_PRECIO = PR.ID_PRECIO
INNER JOIN LO_GRUPOS GRU ON SEC.ID_GRUPO = GRU.ID_GRUPO
AND (GRU.ID_TROPIC = 25 )
LEFT JOIN LO_PRECIOS_STATS PREST ON PREST.ID_PRECIO = PRE.ID_PRECIO
WHERE PRE.ID_PRECIO IN (85703)
AND (PS.ID_ACTIVIDAD_PS=50 OR ID_SECTOR_PP = 50)
GROUP BY PRE.ID_PRECIO
ORDER BY DISTANCIA ASC, PT.N_ORDER_VENTAS_TROPIC DESC ,PRE.ID_PRECIO ASC;
Tiempo de la consulta:
0.0023980140686035Tiempo acumulado:0.70258760452271
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[188]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'O1'
AND SEO.ID_TROPIC = 25
AND SEO.FK_ID_REG_ADM = 0
AND 1=1;
Tiempo de la consulta:
0.010236024856567Tiempo acumulado:0.71282362937927
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[189]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S50'
AND SEO.ID_TROPIC = 25
AND SEO.FK_ID_REG_ADM = 0
AND 1=1;
Tiempo de la consulta:
0.00066995620727539Tiempo acumulado:0.71349358558655
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[190]: SELECT *
FROM LO_PRECIOS_CALENDARIO PC
WHERE PC.ID_PRECIO_PC = 85703
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.0035860538482666Tiempo acumulado:0.71707963943481
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[191]: SELECT (PRE.PERIODO_PRE) AS PERIODO
FROM LO_PRECIOS PRE
WHERE PRE.ID_PRECIO = 85703
UNION ALL
SELECT PD.PERIODO_PD AS PERIODO
FROM LO_PRECIOS_DESCUENTOS PD
WHERE PD.ID_PRECIO_PD = 85703
AND PD.VALID_PD = 1;
Tiempo de la consulta:
0.00056004524230957Tiempo acumulado:0.71763968467712
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[192]: 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 = 25
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 = 85703
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 = 25
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 = 85703
GROUP BY PRE.ID_PRECIO
) AS X;
Tiempo de la consulta:
0.0011320114135742Tiempo acumulado:0.7187716960907
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[193]: SELECT *
FROM LO_PRECIOS_MODIFICAR_ORDEN
WHERE ID_PRECIO = 85703
AND DATE_FORMAT(FECHA, '%Y-%m-%d') >= NOW() - INTERVAL 3 MONTH;
Tiempo de la consulta:
0.00064897537231445Tiempo acumulado:0.71942067146301
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[194]: 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_MX ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'mx'
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_GB 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 = 25
AND SECI.FK_ID_IDIOMA_SI18N = 'es')
INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
AND (GRU.ID_TROPIC = 25)
WHERE EMP.ID_EMPRESA = 19775952
AND EMP.VALID IN ('1', '-3')
LIMIT 1;
Tiempo de la consulta:
0.0023260116577148Tiempo acumulado:0.72174668312073
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[195]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 85703
AND VALID = 1;
Tiempo de la consulta:
0.0012609958648682Tiempo acumulado:0.7230076789856
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[196]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 85703
AND FOTO = 'p-85703-las51683729720_16837328135055.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00048613548278809Tiempo acumulado:0.72349381446838
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[197]: SELECT F_WIDTH, F_HEIGHT
FROM LO_FOTOS
WHERE ID_PRECIO = 85703
AND FOTO = 'p-85703-las51683729720_16837328135055.jpg';
Tiempo de la consulta:
0.00046801567077637Tiempo acumulado:0.72396183013916
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[198]: 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_MX PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'mx'
WHERE PRE.ID_PRECIO = 85703;
Tiempo de la consulta:
0.0005340576171875Tiempo acumulado:0.72449588775635
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[199]: 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 = 85703;
Tiempo de la consulta:
0.0014479160308838Tiempo acumulado:0.72594380378723
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[200]: SELECT *
FROM LO_EMPRESAS_OPINIONES_GOOGLE
WHERE ID_PRECIO = 85703;
Tiempo de la consulta:
0.00049114227294922Tiempo acumulado:0.72643494606018
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[201]: SELECT N_VENTAS_LAST_MONTH
FROM LO_PRECIOS_STATS PS
WHERE PS.ID_PRECIO = 85703;
Tiempo de la consulta:
0.00039505958557129Tiempo acumulado:0.72683000564575
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[202]: 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_MX PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'mx'
WHERE ID_PRECIO = 85703
AND VALID_PRE = 4
GROUP BY PRE.ID_PRECIO
HAVING FEC_ULT_COMPRA IS NOT NULL
LIMIT 1;
Tiempo de la consulta:
0.00050997734069824Tiempo acumulado:0.72733998298645
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[203]: SELECT EXITO
FROM LO_PRECIOS_EXITO
WHERE ID_PRECIO = 85703
LIMIT 1;
Tiempo de la consulta:
0.00066399574279785Tiempo acumulado:0.72800397872925
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[204]: SELECT COUNT(*) AS TOTAL
FROM LO_PRECIOS_SECTORES PS
WHERE PS.ID_ACTIVIDAD_PS NOT IN (100,101)
AND PS.ID_PRECIO_PS = 85703;
Tiempo de la consulta:
0.0010831356048584Tiempo acumulado:0.72908711433411
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[205]: SELECT *
FROM LO_PRECIOS_DIA_ESPECIAL PD
WHERE PD.ID_PRECIO_DE = 85703
AND ID_TIPO_DE = 7
AND VALID = 1;
Tiempo de la consulta:
0.00053501129150391Tiempo acumulado:0.72962212562561
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[206]: 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_MX PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'mx'
WHERE PRE.ID_PRECIO = 85703;
Tiempo de la consulta:
0.00095415115356445Tiempo acumulado:0.73057627677917
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[207]: 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 = 85703;
Tiempo de la consulta:
0.00071811676025391Tiempo acumulado:0.73129439353943
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[208]: 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 = 25)
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_MX PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'mx'
WHERE SS.ID_SECTOR_SS=50
AND SSF.ID_TROPIC = 25
GROUP BY SSF.ID_SSF
ORDER BY COUNT(SSF.ID_SSF) DESC;
Tiempo de la consulta:
0.0033290386199951Tiempo acumulado:0.73462343215942
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[209]: 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 = 25
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_REGION_STATS RS ON RS.ID_SECTOR = LSR.ID_SECTOR_RELACIONADO
AND RS.ID_REGION = 3205
AND RS.N_OFERTAS > 0
WHERE LSR.ID_SECTOR = 50
AND (PR.PROVINCIA = 0 OR PR.PROVINCIA 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.0038928985595703Tiempo acumulado:0.73851633071899
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[210]: SELECT (N_OFERTAS) + (N_EMPRESAS) AS NEMPRESAS,
N_OFERTAS AS NumOfertas, N_EMPRESAS as NumEmpresas,
PS.ID_REGION,
IF ( MEDIA_AJUSTADA IS NOT NULL
AND MEDIA_AJUSTADA != 0
AND MEDIA_AJUSTADA < MEDIA_PRECIO, MEDIA_AJUSTADA, MEDIA_PRECIO ) AS MEDIA, N_OPIS
FROM
LO_REGION_STATS PS
WHERE (IF(ISNULL(PS.N_OFERTAS),0,PS.N_OFERTAS) > 0 OR IF(ISNULL(PS.N_EMPRESAS),0,PS.N_EMPRESAS) > 0 )
AND PS.ID_REGION = 3205
AND PS.ID_SECTOR = 50
ORDER BY NEMPRESAS DESC;
Tiempo de la consulta:
0.00061202049255371Tiempo acumulado:0.73912835121155
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[211]: 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
FROM
LO_POBLACION_GB_STATS PS
INNER JOIN LO_POBLACION_GB PO ON PS.ID_POBLACION = PO.ID_POBLACION
AND PO.IDIOMA = 'es'
AND PO.ID_REGION = 3205
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
WHERE (PS.N_OFERTAS > 0 /* OR PS.N_EMPRESAS > 0 */)
AND PS.ID_SECTOR = 50
AND N_OFERTAS > 1
GROUP BY PS.ID_POBLACION
ORDER BY N_OFERTAS DESC;
Tiempo de la consulta:
0.0040140151977539Tiempo acumulado:0.7431423664093
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[212]: SELECT LO.ID_PRECIO
FROM LO_LANDING_OFERTAS LO
WHERE LO.STATUS = 2
AND LO.ID_SECTOR = 50
AND LO.ID_PROVINCIA = 3205;
Tiempo de la consulta:
0.00079703330993652Tiempo acumulado:0.74393939971924
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[213]: 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_MX PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'mx'
LEFT JOIN LO_PRECIOS_PUBLI PP ON PRE.ID_PRECIO = PP.ID_PRECIO_PP
LEFT JOIN LO_PRECIOS_STATS PRESTAT ON PRESTAT.ID_PRECIO = PRE.ID_PRECIO
LEFT JOIN LO_PRECIOS_DESCUENTOS PD ON PD.ID_PRECIO_PD = PRE.ID_PRECIO
AND PD.VALID_PD = 1
INNER JOIN LO_PRECIOS_SECTORES PS ON PS.ID_PRECIO_PS = PRE.ID_PRECIO
INNER JOIN LO_SECTORES SEC ON SEC.ID_SECTOR = PS.ID_ACTIVIDAD_PS
INNER JOIN LO_EMPRESAS_STAT EMPS ON EMPS.FK_ID_EST = PRE.ID_EMPRESA_PRE
INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
AND (EMP.VALID = 1 )
LEFT JOIN LO_LANDING_OFERTAS LO ON LO.ID_PRECIO = PRE.ID_PRECIO
AND LO.STATUS = 1
AND LO.ID_SECTOR = 50
AND LO.ID_PROVINCIA = 3205
LEFT JOIN LO_PRECIOS_RESTRICCIONES PR ON PRE.ID_PRECIO = PR.ID_PRECIO
WHERE PRE.VALID_PRE = 4
AND PS.ID_ACTIVIDAD_PS = 50
AND ( PRE.ID_REGION_PRE='3205' OR PP.ID_REGION_PP='3205' )
GROUP BY PRE.ID_PRECIO
ORDER BY LO.STATUS DESC, VENTAS DESC, OPIS DESC
LIMIT 4;
Tiempo de la consulta:
0.0045170783996582Tiempo acumulado:0.7484564781189
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[214]: 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_MX PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'mx'
LEFT JOIN LO_PRECIOS_PUBLI PP ON PRE.ID_PRECIO = PP.ID_PRECIO_PP
LEFT JOIN LO_RESERVAS_COMPRAS RC ON PRE.ID_PRECIO = RC.ID_PRECIO_RC
AND RC.VALID_RC NOT IN (0, 2, 6, 7)
LEFT JOIN LO_PRECIOS_STATS PRESTAT ON PRESTAT.ID_PRECIO = PRE.ID_PRECIO
LEFT JOIN LO_PRECIOS_DESCUENTOS PD ON PD.ID_PRECIO_PD = PRE.ID_PRECIO
AND PD.VALID_PD = 1
INNER JOIN LO_PRECIOS_SECTORES PS ON PS.ID_PRECIO_PS = PRE.ID_PRECIO
INNER JOIN LO_SECTORES SEC ON SEC.ID_SECTOR = PS.ID_ACTIVIDAD_PS
INNER JOIN LO_EMPRESAS_STAT EMPS ON EMPS.FK_ID_EST = PRE.ID_EMPRESA_PRE
INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
AND (EMP.VALID = 1 )
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = PS.ID_ACTIVIDAD_PS
AND (SECI.FK_ID_IDIOMA_SI18N = 'es'
AND SECI.ID_TROPIC = 25)
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PRE.ID_REGION_PRE
AND REI.IDIOMA = 'es'
INNER JOIN LO_POBLACION_GB 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 (69733)
AND PRE.VALID_PRE = 4
AND PS.ID_ACTIVIDAD_PS = 50
AND ( PRE.ID_REGION_PRE='3205' OR PP.ID_REGION_PP='3205' )
GROUP BY PRE.ID_PRECIO
ORDER BY VENTAS DESC, OPIS DESC
LIMIT 4;
Tiempo de la consulta:
0.0022649765014648Tiempo acumulado:0.75072145462036
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[215]: 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_MX PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'mx'
LEFT JOIN LO_PRECIOS_PUBLI PP ON PRE.ID_PRECIO = PP.ID_PRECIO_PP
LEFT JOIN LO_PRECIOS_STATS PRESTAT ON PRESTAT.ID_PRECIO = PRE.ID_PRECIO
LEFT JOIN LO_PRECIOS_DESCUENTOS PD ON PD.ID_PRECIO_PD = PRE.ID_PRECIO
AND PD.VALID_PD = 1
INNER JOIN LO_PRECIOS_SECTORES PS ON PS.ID_PRECIO_PS = PRE.ID_PRECIO
INNER JOIN LO_SECTORES SEC ON SEC.ID_SECTOR = PS.ID_ACTIVIDAD_PS
INNER JOIN LO_EMPRESAS_STAT EMPS ON EMPS.FK_ID_EST = PRE.ID_EMPRESA_PRE
INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
AND (EMP.VALID = 1 )
LEFT JOIN LO_LANDING_OFERTAS LO ON LO.ID_PRECIO = PRE.ID_PRECIO
AND LO.STATUS = 1
AND LO.ID_SECTOR = 50
AND LO.ID_PROVINCIA = 3205
LEFT JOIN LO_PRECIOS_RESTRICCIONES PR ON PRE.ID_PRECIO = PR.ID_PRECIO
WHERE PRE.VALID_PRE = 4
AND PS.ID_ACTIVIDAD_PS = 50
AND ( PRE.ID_REGION_PRE='3205' OR PP.ID_REGION_PP='3205' )
GROUP BY PRE.ID_PRECIO
ORDER BY LO.STATUS DESC, VENTAS DESC, OPIS DESC
LIMIT 4;
Tiempo de la consulta:
0.0039551258087158Tiempo acumulado:0.75467658042908
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[216]: 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_MX PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'mx'
LEFT JOIN LO_PRECIOS_PUBLI PP ON PRE.ID_PRECIO = PP.ID_PRECIO_PP
LEFT JOIN LO_RESERVAS_COMPRAS RC ON PRE.ID_PRECIO = RC.ID_PRECIO_RC
AND RC.VALID_RC NOT IN (0, 2, 6, 7)
LEFT JOIN LO_PRECIOS_STATS PRESTAT ON PRESTAT.ID_PRECIO = PRE.ID_PRECIO
LEFT JOIN LO_PRECIOS_DESCUENTOS PD ON PD.ID_PRECIO_PD = PRE.ID_PRECIO
AND PD.VALID_PD = 1
INNER JOIN LO_PRECIOS_SECTORES PS ON PS.ID_PRECIO_PS = PRE.ID_PRECIO
INNER JOIN LO_SECTORES SEC ON SEC.ID_SECTOR = PS.ID_ACTIVIDAD_PS
INNER JOIN LO_EMPRESAS_STAT EMPS ON EMPS.FK_ID_EST = PRE.ID_EMPRESA_PRE
INNER JOIN LO_EMPRESAS EMP ON EMP.ID_EMPRESA = PRE.ID_EMPRESA_PRE
AND (EMP.VALID = 1 )
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = PS.ID_ACTIVIDAD_PS
AND (SECI.FK_ID_IDIOMA_SI18N = 'es'
AND SECI.ID_TROPIC = 25)
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PRE.ID_REGION_PRE
AND REI.IDIOMA = 'es'
INNER JOIN LO_POBLACION_GB 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 (69733)
AND PRE.VALID_PRE = 4
AND PS.ID_ACTIVIDAD_PS = 50
AND ( PRE.ID_REGION_PRE='3205' OR PP.ID_REGION_PP='3205' )
GROUP BY PRE.ID_PRECIO
ORDER BY VENTAS DESC, OPIS DESC
LIMIT 4;
Tiempo de la consulta:
0.0017449855804443Tiempo acumulado:0.75642156600952
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[217]: 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_MX PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'mx'
WHERE PRE.ID_PRECIO = 69733;
Tiempo de la consulta:
0.0022408962249756Tiempo acumulado:0.7586624622345
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[218]: 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 = 69733;
Tiempo de la consulta:
0.00070786476135254Tiempo acumulado:0.75937032699585
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[219]: 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 = 50
AND ID_REGION = 3205
AND ID_POBLACION IS NULL
AND ID_REGION_ADM IS NULL
AND ID_PAIS IS NULL
GROUP BY ID_OPINION
ORDER BY ID_OPINION DESC
LIMIT 6;
Tiempo de la consulta:
0.0015261173248291Tiempo acumulado:0.76089644432068
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[220]: SELECT N_OPIS AS TOTAL, MEDIA_OPIS_5 AS MEDIA, ROUND(MEDIA_OPIS_100,0) AS MEDIA2
FROM LO_REGION_STATS
WHERE ID_REGION = 3205
AND ID_SECTOR = 50;
Tiempo de la consulta:
0.0015830993652344Tiempo acumulado:0.76247954368591
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[221]: 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_MX ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'mx'
WHERE EMP.ID_EMPRESA = 19765513;
Tiempo de la consulta:
0.00053596496582031Tiempo acumulado:0.76301550865173
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[222]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM LO_SECTORES SEC, LO_SECTORES_I18N SECI
WHERE SEC.ID_SECTOR = '50'
AND SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N = 'en'
AND SECI.ID_TROPIC = 2;
Tiempo de la consulta:
0.00052404403686523Tiempo acumulado:0.7635395526886
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[223]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM LO_SECTORES SEC, LO_SECTORES_I18N SECI
WHERE SEC.ID_SECTOR = '50'
AND SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
AND SECI.ID_TROPIC = 25;
Tiempo de la consulta:
0.00052499771118164Tiempo acumulado:0.76406455039978
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[224]: SELECT ID_MADRE
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19765513;
Tiempo de la consulta:
0.0003349781036377Tiempo acumulado:0.76439952850342
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[225]: SELECT NOMBRE, URL
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19765509;
Tiempo de la consulta:
0.00056314468383789Tiempo acumulado:0.76496267318726
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[226]: 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_MX ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'mx'
WHERE EMP.ID_EMPRESA = 19765513;
Tiempo de la consulta:
0.00045680999755859Tiempo acumulado:0.76541948318481
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[227]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM LO_SECTORES SEC, LO_SECTORES_I18N SECI
WHERE SEC.ID_SECTOR = '50'
AND SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N = 'en'
AND SECI.ID_TROPIC = 2;
Tiempo de la consulta:
0.00057697296142578Tiempo acumulado:0.76599645614624
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[228]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM LO_SECTORES SEC, LO_SECTORES_I18N SECI
WHERE SEC.ID_SECTOR = '50'
AND SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
AND SECI.ID_TROPIC = 25;
Tiempo de la consulta:
0.0015368461608887Tiempo acumulado:0.76753330230713
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[229]: SELECT ID_MADRE
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19765513;
Tiempo de la consulta:
0.0003669261932373Tiempo acumulado:0.76790022850037
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[230]: SELECT NOMBRE, URL
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19765509;
Tiempo de la consulta:
0.0058591365814209Tiempo acumulado:0.77375936508179
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[231]: 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_MX ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'mx'
WHERE EMP.ID_EMPRESA = 19765513;
Tiempo de la consulta:
0.0091841220855713Tiempo acumulado:0.78294348716736
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[232]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM LO_SECTORES SEC, LO_SECTORES_I18N SECI
WHERE SEC.ID_SECTOR = '50'
AND SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N = 'en'
AND SECI.ID_TROPIC = 2;
Tiempo de la consulta:
0.00070095062255859Tiempo acumulado:0.78364443778992
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[233]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM LO_SECTORES SEC, LO_SECTORES_I18N SECI
WHERE SEC.ID_SECTOR = '50'
AND SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
AND SECI.ID_TROPIC = 25;
Tiempo de la consulta:
0.00059700012207031Tiempo acumulado:0.78424143791199
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[234]: SELECT ID_MADRE
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19765513;
Tiempo de la consulta:
0.00041103363037109Tiempo acumulado:0.78465247154236
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[235]: SELECT NOMBRE, URL
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19765509;
Tiempo de la consulta:
0.00047206878662109Tiempo acumulado:0.78512454032898
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[236]: SELECT SECI.DESC_SECTOR,REI.URL,ID_EMPRESA,SECI.URL URL_SECTOR,EMP.ID_EMPRESA, SECI.ID_SECTOR, EMP.EMP_MADRE, ET.DESCRIPCION_ET DESCRIPCION,GALERIA_DESC_ET GALERIA_DESC,VIDEOS_TEXT_ET VIDEOS_TEXT,VIDEOS_DESC_ET VIDEOS_DESC,COMO_LLEGAR_ET COMO_LLEGAR,URL_ET URL, EMP.NOMBRE NOMBRE, ET.EVENT_PLANNING EVENT_PLANNING, GRU.ID_GRUPO
FROM LO_EMPRESAS EMP
INNER JOIN LO_EMPRESAS_TRADUCCION_MX ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'mx'
INNER JOIN LO_REGION RE ON EMP.ID_PROVINCIA=RE.ID_REGION
INNER JOIN LO_REGION_I18N REI ON RE.ID_REGION=REI.ID_REGION
AND REI.IDIOMA = '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='25'
INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
AND ( GRU.ID_TROPIC = 25)
WHERE
SECI.FK_ID_IDIOMA_SI18N='es'
AND EMP.ID_EMPRESA='19765509'
LIMIT 1;
Tiempo de la consulta:
0.00093603134155273Tiempo acumulado:0.78606057167053
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[237]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19765513
AND VALID = 1;
Tiempo de la consulta:
0.010541200637817Tiempo acumulado:0.79660177230835
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[238]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19765513
AND FOTO = 'e-19765513-bedlam-logo167516965716751712798354.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0024099349975586Tiempo acumulado:0.79901170730591
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[239]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19765513
AND VALID = 1;
Tiempo de la consulta:
0.00065088272094727Tiempo acumulado:0.79966259002686
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[240]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19765513
AND FOTO = 'e-19765513-12039299-845106298936801-3573216114659516496-n167516975916751712805685.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00055909156799316Tiempo acumulado:0.80022168159485
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[241]: SELECT ID_EMPRESA, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_EMPRESA = 19765513;
Tiempo de la consulta:
0.0028538703918457Tiempo acumulado:0.80307555198669
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[242]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19765513
AND VALID = 1;
Tiempo de la consulta:
0.00061798095703125Tiempo acumulado:0.80369353294373
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[243]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19765513
AND FOTO = 'e-19765513-12039299-845106298936801-3573216114659516496-n167516975916751712805685.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0018808841705322Tiempo acumulado:0.80557441711426
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[244]: SELECT ID_EMPRESA, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_EMPRESA = 19765513;
Tiempo de la consulta:
0.0009150505065918Tiempo acumulado:0.80648946762085
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[245]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19765513
AND VALID = 1;
Tiempo de la consulta:
0.00071883201599121Tiempo acumulado:0.80720829963684
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[246]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19765513
AND FOTO = 'e-19765513-12039299-845106298936801-3573216114659516496-n167516975916751712805685.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.00047183036804199Tiempo acumulado:0.80768013000488
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[247]: 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 = 25)
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_MX PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'mx'
WHERE SS.ID_SECTOR_SS=50
AND SSF.ID_TROPIC = 25
GROUP BY SSF.ID_SSF
ORDER BY COUNT(SSF.ID_SSF) DESC;
Tiempo de la consulta:
0.00071310997009277Tiempo acumulado:0.80839323997498
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[248]: 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 = 25
INNER JOIN LO_PRECIOS_SECTORES PS ON PS.ID_ACTIVIDAD_PS = LSR.ID_SECTOR_RELACIONADO
INNER JOIN LO_PRECIOS PRE ON PRE.ID_PRECIO = PS.ID_PRECIO_PS
AND PRE.VALID_PRE = 4
INNER JOIN LO_REGION RE ON RE.ID_REGION = PRE.ID_REGION_PRE
LEFT JOIN LO_PRECIOS_PUBLI PP ON PP.ID_PRECIO_PP = PRE.ID_PRECIO
LEFT JOIN LO_PRECIOS_RESTRICCIONES PR ON PRE.ID_PRECIO = PR.ID_PRECIO
WHERE LSR.ID_SECTOR = 50
AND (PRE.ID_REGION_PRE = 3205 OR ID_REGION_PP = 3205)
AND (PR.PROVINCIA = 0 OR PR.PROVINCIA 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.00097393989562988Tiempo acumulado:0.80936717987061
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[249]: SELECT SEO.DESCRIPTION
FROM LO_SEO_DESCRIPTIONS SEO
WHERE SEO.ID_TROPIC='25'
AND SEO.ID_KEY='S50';
Tiempo de la consulta:
0.0030081272125244Tiempo acumulado:0.81237530708313
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[250]: 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 = 25
WHERE SEOHOME.ID_TROPIC = 25
AND SEOHOME.ID_KEY = 'S50'
AND SEO_VALID in (0,1)
AND SEOHOME.ID_LOCALIZACION='3205';
Tiempo de la consulta:
0.0046639442443848Tiempo acumulado:0.81703925132751
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[251]: SELECT SECI.ID_SECTOR, N_OFERTAS AS NEMPRESAS, N_OFERTAS AS NumOfertas, N_EMPRESAS as NumEmpresas, REI.ID_REGION, REI.DESC_REGION, REI.URL URL_REGION, SECI.DESC_SECTOR, SECI.URL as URL_SECTOR, PO.DESC_POBLACION, PO.URL_POBLACION, PO.ID_POBLACION, RE.ID_REGION_ADM1, RE.ID_PAIS
FROM
LO_POBLACION_GB_STATS PS
INNER JOIN LO_POBLACION_GB 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='25'
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
WHERE
REI.ID_REGION = 3205
AND PS.ID_SECTOR = 50
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.0017039775848389Tiempo acumulado:0.81874322891235
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[252]: 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='25'
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
WHERE
REI.ID_REGION = 3205
AND (PS.N_OFERTAS > 0
AND PS.N_OFERTAS IS NOT NULL)
ORDER BY NEMPRESAS DESC;
Tiempo de la consulta:
0.00081586837768555Tiempo acumulado:0.81955909729004
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[253]: SELECT COUNT(*) AS NEMPRESAS
FROM LO_REGION_STATS
WHERE ID_REGION = 3205
AND ID_GRUPO = 4;
Tiempo de la consulta:
0.00043678283691406Tiempo acumulado:0.81999588012695
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[254]: 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 = '3205'
AND REI.IDIOMA = 'es';
Tiempo de la consulta:
0.00044488906860352Tiempo acumulado:0.82044076919556
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[255]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S3'
AND (SEO.ID_TROPIC = 25
);
Tiempo de la consulta:
0.00040197372436523Tiempo acumulado:0.82084274291992
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[256]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S32'
AND (SEO.ID_TROPIC = 25
);
Tiempo de la consulta:
0.00043010711669922Tiempo acumulado:0.82127285003662
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[257]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S122'
AND (SEO.ID_TROPIC = 25
);
Tiempo de la consulta:
0.00040006637573242Tiempo acumulado:0.82167291641235
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[258]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S111'
AND (SEO.ID_TROPIC = 25
);
Tiempo de la consulta:
0.00041985511779785Tiempo acumulado:0.82209277153015
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[259]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S50'
AND (SEO.ID_TROPIC = 25
);
Tiempo de la consulta:
0.00049781799316406Tiempo acumulado:0.82259058952332
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[260]: 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.0029158592224121Tiempo acumulado:0.82550644874573
(Prod_Yumping_co_UK) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[261]: SELECT *
FROM LO_EQUIPO_EDITORIAL EE
WHERE EE.ID_TROPIC = 25;
Tiempo de la consulta:
0.00036191940307617Tiempo acumulado:0.8258683681488
