yu-front-06.localdomain (172.30.2.194:443)
prod.yumping.com
/landings/landing.php
BBDD->Prod_Yumping_mx_MX
AMBITO->mx_de
AMBITO_AJAX->mx_de
AMBITO_AJAX COOKIE->gb_ch
locale LO_CONFIG->de_MX
locale php->de_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->de
filtro1->flyboard
filtro2->jalisco
rel_alternate->1
paginado_ofertas->
npage->
Total queries: 312
Tiempo total: 2.0385413169861
>0.1 and < 2 (3)
(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', 'es_de')
ORDER BY CFG.NAME;
Tiempo de la consulta:
0.010439157485962Tiempo acumulado:0.010439157485962
(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.00072598457336426Tiempo acumulado:0.011165142059326
(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 = 'jalisco'
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 = 'jalisco' 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 = 'jalisco'
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 = 'jalisco' 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 = 'jalisco'
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 = 'jalisco' 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 = 'jalisco'
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 = 'jalisco' 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 = 'jalisco'
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 = 'jalisco' 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 = 'jalisco'
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 = 'jalisco' )AS FIND_REGION
GROUP BY ID_PAIS;
Tiempo de la consulta:
0.01259708404541Tiempo acumulado:0.023762226104736
(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', 'mx_de')
ORDER BY CFG.NAME;
Tiempo de la consulta:
0.0079200267791748Tiempo acumulado:0.031682252883911
(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.00042200088500977Tiempo acumulado:0.032104253768921
(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.00095891952514648Tiempo acumulado:0.033063173294067
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[7]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'ambito_lang';
Tiempo de la consulta:
0.0022459030151367Tiempo acumulado:0.035309076309204
(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 = 'filtro1';
Tiempo de la consulta:
0.0033571720123291Tiempo acumulado:0.038666248321533
(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 = 'filtro2';
Tiempo de la consulta:
0.0028011798858643Tiempo acumulado:0.041467428207397
(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 = 'rel_alternate';
Tiempo de la consulta:
0.0020871162414551Tiempo acumulado:0.043554544448853
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[11]: SELECT G.DESC_GRUPO, G.ID_GRUPO, G.URL AS URL_GRUPO
FROM LO_GRUPOS G
WHERE G.URL = 'flyboard'
AND G.ID_TROPIC = 57;
Tiempo de la consulta:
0.0019688606262207Tiempo acumulado:0.045523405075073
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[12]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.URL = 'jalisco'
AND IDIOMA = 'de';
Tiempo de la consulta:
0.0042331218719482Tiempo acumulado:0.049756526947021
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[13]: 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 = 'jalisco'
AND REI.IDIOMA = 'de';
Tiempo de la consulta:
0.00060296058654785Tiempo acumulado:0.050359487533569
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[14]: 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 = 'jalisco'
AND IDIOMA = 'de'
LIMIT 1;
Tiempo de la consulta:
0.0007939338684082Tiempo acumulado:0.051153421401978
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[15]: 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 = 'flyboard'
AND ID_TROPIC = 57
AND SECI.FK_ID_IDIOMA_SI18N = 'de'
LIMIT 1;
Tiempo de la consulta:
0.0022871494293213Tiempo acumulado:0.053440570831299
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[16]: SELECT ORDER_LANDING
FROM LO_SECTORES SEC
WHERE ID_SECTOR = 109;
Tiempo de la consulta:
0.00036883354187012Tiempo acumulado:0.053809404373169
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[17]: SELECT GRU.URL URL_GRUPO, GRU.DESC_GRUPO, ID_GRUPO
FROM LO_GRUPOS GRU
WHERE GRU.ID_GRUPO = 1
AND (GRU.ID_TROPIC = 57);
Tiempo de la consulta:
0.0033209323883057Tiempo acumulado:0.057130336761475
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[18]: SELECT *
FROM LO_SEO_KEYWORDS_LANDING SKL
WHERE SKL.ID_SECTOR = 109
AND ID_TROPIC = 57;
Tiempo de la consulta:
0.0010478496551514Tiempo acumulado:0.058178186416626
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[19]: SELECT *
FROM LO_REGION_SKI REI
WHERE URL = 'jalisco'
AND REI.IDIOMA='de'
AND TIPO = 1;
Tiempo de la consulta:
0.0018069744110107Tiempo acumulado:0.059985160827637
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[20]: 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 = 8732
LIMIT 1;
Tiempo de la consulta:
0.00090885162353516Tiempo acumulado:0.060894012451172
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[21]: 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_DE ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'de'
WHERE EMP.VALID IN (1)
AND RE.ID_REGION = 8732
AND EMP.EMP_MADRE NOT IN (0)
AND EMP.ID_SECTOR=109
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.019971132278442Tiempo acumulado:0.080865144729614
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[22]: SELECT FOUND_ROWS() NEMPRESAS;
Tiempo de la consulta:
0.00083589553833008Tiempo acumulado:0.081701040267944
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[23]: 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 = 8732)),
0) AS LAT_PUBLI
, IF (EMP.EMP_MADRE = 3,
CONCAT((SELECT LONGITUDE
FROM LO_REGION
WHERE ID_REGION = 8732)),
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 = 'de'
INNER JOIN LO_REGION_ADM1_I18N REIA ON REIA.ID_REGION_ADM1 = RE.ID_REGION_ADM1
AND REIA.IDIOMA = 'de'
LEFT JOIN LO_POBLACION PO ON PO.ID_POBLACION = EMP.ID_POBLACION
LEFT JOIN LO_POBLACION_MX POI ON EMP.ID_POBLACION = POI.ID_POBLACION
AND POI.IDIOMA='de'
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 = 57
INNER JOIN LO_EMPRESAS_STAT EMPS ON EMPS.FK_ID_EST = EMP.ID_EMPRESA
INNER JOIN LO_EMPRESAS_TRADUCCION_DE ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'de'
WHERE EMP.ID_EMPRESA IN (19756744 , 19727522 , 19727834 , 19737793)
ORDER BY IF(N_PRECIOS_EST > 0 , 1 ,0) DESC, N_VENTAS_EST DESC,N_ORDER_TSP_EST DESC;
Tiempo de la consulta:
0.019731998443604Tiempo acumulado:0.10143303871155
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[24]: 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 = 8732
AND ID_SECTOR = 109
GROUP BY ID_SECTOR;
Tiempo de la consulta:
0.001784086227417Tiempo acumulado:0.10321712493896
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[25]: 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 = 57
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_DE PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'de'
WHERE SS.ID_TROPIC = 57
AND VALID_PRE=4
AND ID_SECTOR_SS = '109'
AND (PRE.ID_REGION_PRE = 8732 OR (PP.ID_REGION_PP = 8732
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.013202905654907Tiempo acumulado:0.11642003059387
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[26]: SELECT SEO.DESCRIPTION
FROM LO_SEO_DESCRIPTIONS SEO
WHERE SEO.ID_TROPIC='57'
AND SEO.ID_KEY='S109';
Tiempo de la consulta:
0.0015690326690674Tiempo acumulado:0.11798906326294
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[27]: 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 = 57
WHERE SEOHOME.ID_TROPIC = 57
AND SEOHOME.ID_KEY = 'S109'
AND SEO_VALID in (0,1)
AND SEOHOME.ID_LOCALIZACION='8732';
Tiempo de la consulta:
0.0092201232910156Tiempo acumulado:0.12720918655396
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[28]: SELECT OLD_URL, NEW_URL
FROM LO_URL_301 U
WHERE U.OLD_URL = '/de/flyboard/jalisco';
Tiempo de la consulta:
0.00136399269104Tiempo acumulado:0.128573179245
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[29]: SELECT *
FROM LO_SEO_DESCRIPTIONS_HOME SEO
WHERE SEO.ID_TROPIC='57'
AND SEO.ID_KEY='S109'
AND SEO.ID_LOCALIZACION='8732';
Tiempo de la consulta:
0.0023870468139648Tiempo acumulado:0.13096022605896
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[30]: SELECT TITLE, DESCRIPTION, KEYWORDS, ID_KEY
FROM LO_SEO_HEADERS SEO
WHERE SEO.ID_TROPIC='57'
AND VALID='1'
AND SEO.ID_KEY='S109';
Tiempo de la consulta:
0.0019059181213379Tiempo acumulado:0.1328661441803
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[31]: 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 = 'flyboard'
AND ID_TROPIC = 57
AND SECI.FK_ID_IDIOMA_SI18N = 'de'
LIMIT 1;
Tiempo de la consulta:
0.00072884559631348Tiempo acumulado:0.13359498977661
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[32]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00054311752319336Tiempo acumulado:0.1341381072998
(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 = 'mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047183036804199Tiempo acumulado:0.13460993766785
(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 = 'mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046396255493164Tiempo acumulado:0.13507390022278
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[35]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM Prod_Yumping_mx_MX.LO_SECTORES SEC
INNER JOIN Prod_Yumping_mx_MX.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
WHERE SEC.ID_SECTOR=109
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
AND SECI.ID_TROPIC=5;
Tiempo de la consulta:
0.00063300132751465Tiempo acumulado:0.13570690155029
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[36]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0006561279296875Tiempo acumulado:0.13636302947998
(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 = 'mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00061392784118652Tiempo acumulado:0.13697695732117
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[38]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
FROM LO_REGION RE, LO_REGION_I18N REI
WHERE REI.URL = 'jalisco'
AND REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'de';
Tiempo de la consulta:
0.0005190372467041Tiempo acumulado:0.13749599456787
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[39]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050091743469238Tiempo acumulado:0.13799691200256
(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 = 'mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00064706802368164Tiempo acumulado:0.13864398002625
(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 = 'mx_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('mx_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049495697021484Tiempo acumulado:0.13913893699646
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[42]: SELECT RE.ID_REGION, REI.DESC_REGION,REI.URL URL_REGION
FROM Prod_Yumping_mx_MX.LO_REGION RE, Prod_Yumping_mx_MX.LO_REGION_I18N REI
WHERE RE.ID_REGION=8732
AND RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA = 'es';
Tiempo de la consulta:
0.00047588348388672Tiempo acumulado:0.13961482048035
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[43]: 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 = 'flyboard'
AND ID_TROPIC = 57
AND SECI.FK_ID_IDIOMA_SI18N = 'de'
LIMIT 1;
Tiempo de la consulta:
0.00066304206848145Tiempo acumulado:0.14027786254883
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[44]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('mx_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046110153198242Tiempo acumulado:0.14073896408081
(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 = 'mx_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('mx_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046610832214355Tiempo acumulado:0.14120507240295
(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 = 'mx_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('mx_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004420280456543Tiempo acumulado:0.14164710044861
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[47]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM Prod_Yumping_mx_MX.LO_SECTORES SEC
INNER JOIN Prod_Yumping_mx_MX.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
WHERE SEC.ID_SECTOR=109
AND SECI.FK_ID_IDIOMA_SI18N = 'en'
AND SECI.ID_TROPIC=52;
Tiempo de la consulta:
0.00056195259094238Tiempo acumulado:0.14220905303955
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[48]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('mx_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046110153198242Tiempo acumulado:0.14267015457153
(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 = 'mx_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('mx_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045299530029297Tiempo acumulado:0.14312314987183
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[50]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
FROM LO_REGION RE, LO_REGION_I18N REI
WHERE REI.URL = 'jalisco'
AND REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'de';
Tiempo de la consulta:
0.00049304962158203Tiempo acumulado:0.14361619949341
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[51]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('mx_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00048685073852539Tiempo acumulado:0.14410305023193
(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 = 'mx_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('mx_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00048589706420898Tiempo acumulado:0.14458894729614
(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 = 'mx_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('mx_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00048089027404785Tiempo acumulado:0.14506983757019
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[54]: SELECT RE.ID_REGION, REI.DESC_REGION,REI.URL URL_REGION
FROM Prod_Yumping_mx_MX.LO_REGION RE, Prod_Yumping_mx_MX.LO_REGION_I18N REI
WHERE RE.ID_REGION=8732
AND RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA = 'en';
Tiempo de la consulta:
0.00065803527832031Tiempo acumulado:0.14572787284851
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[55]: 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 = 'flyboard'
AND ID_TROPIC = 57
AND SECI.FK_ID_IDIOMA_SI18N = 'de'
LIMIT 1;
Tiempo de la consulta:
0.00096011161804199Tiempo acumulado:0.14668798446655
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[56]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('mx_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050616264343262Tiempo acumulado:0.14719414710999
(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 = 'mx_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('mx_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049304962158203Tiempo acumulado:0.14768719673157
(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 = 'mx_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('mx_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046682357788086Tiempo acumulado:0.14815402030945
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[59]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM Prod_Yumping_mx_MX.LO_SECTORES SEC
INNER JOIN Prod_Yumping_mx_MX.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
WHERE SEC.ID_SECTOR=109
AND SECI.FK_ID_IDIOMA_SI18N = 'fr'
AND SECI.ID_TROPIC=54;
Tiempo de la consulta:
0.00056600570678711Tiempo acumulado:0.14872002601624
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[60]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('mx_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049495697021484Tiempo acumulado:0.14921498298645
(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 = 'mx_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('mx_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00044894218444824Tiempo acumulado:0.1496639251709
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[62]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
FROM LO_REGION RE, LO_REGION_I18N REI
WHERE REI.URL = 'jalisco'
AND REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'de';
Tiempo de la consulta:
0.00052499771118164Tiempo acumulado:0.15018892288208
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[63]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('mx_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047993659973145Tiempo acumulado:0.15066885948181
(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 = 'mx_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('mx_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045609474182129Tiempo acumulado:0.15112495422363
(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 = 'mx_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('mx_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045990943908691Tiempo acumulado:0.15158486366272
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[66]: SELECT RE.ID_REGION, REI.DESC_REGION,REI.URL URL_REGION
FROM Prod_Yumping_mx_MX.LO_REGION RE, Prod_Yumping_mx_MX.LO_REGION_I18N REI
WHERE RE.ID_REGION=8732
AND RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA = 'fr';
Tiempo de la consulta:
0.00040817260742188Tiempo acumulado:0.15199303627014
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[67]: 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 = 'flyboard'
AND ID_TROPIC = 57
AND SECI.FK_ID_IDIOMA_SI18N = 'de'
LIMIT 1;
Tiempo de la consulta:
0.00063800811767578Tiempo acumulado:0.15263104438782
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[68]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('mx_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00072908401489258Tiempo acumulado:0.15336012840271
(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 = 'mx_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('mx_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046086311340332Tiempo acumulado:0.15382099151611
(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 = 'mx_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('mx_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042390823364258Tiempo acumulado:0.15424489974976
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[71]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM Prod_Yumping_mx_MX.LO_SECTORES SEC
INNER JOIN Prod_Yumping_mx_MX.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
WHERE SEC.ID_SECTOR=109
AND SECI.FK_ID_IDIOMA_SI18N = 'it'
AND SECI.ID_TROPIC=53;
Tiempo de la consulta:
0.00069189071655273Tiempo acumulado:0.15493679046631
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[72]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('mx_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046014785766602Tiempo acumulado:0.15539693832397
(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 = 'mx_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('mx_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0020849704742432Tiempo acumulado:0.15748190879822
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[74]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
FROM LO_REGION RE, LO_REGION_I18N REI
WHERE REI.URL = 'jalisco'
AND REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'de';
Tiempo de la consulta:
0.00052714347839355Tiempo acumulado:0.15800905227661
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[75]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('mx_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00066304206848145Tiempo acumulado:0.15867209434509
(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 = 'mx_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('mx_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0023529529571533Tiempo acumulado:0.16102504730225
(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 = 'mx_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('mx_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050616264343262Tiempo acumulado:0.16153120994568
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[78]: SELECT RE.ID_REGION, REI.DESC_REGION,REI.URL URL_REGION
FROM Prod_Yumping_mx_MX.LO_REGION RE, Prod_Yumping_mx_MX.LO_REGION_I18N REI
WHERE RE.ID_REGION=8732
AND RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA = 'it';
Tiempo de la consulta:
0.00039911270141602Tiempo acumulado:0.16193032264709
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[79]: 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 = 'flyboard'
AND ID_TROPIC = 57
AND SECI.FK_ID_IDIOMA_SI18N = 'de'
LIMIT 1;
Tiempo de la consulta:
0.0020871162414551Tiempo acumulado:0.16401743888855
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[80]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('mx_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00052118301391602Tiempo acumulado:0.16453862190247
(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 = 'mx_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('mx_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.001107931137085Tiempo acumulado:0.16564655303955
(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 = 'mx_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('mx_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00056600570678711Tiempo acumulado:0.16621255874634
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[83]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM Prod_Yumping_mx_MX.LO_SECTORES SEC
INNER JOIN Prod_Yumping_mx_MX.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
WHERE SEC.ID_SECTOR=109
AND SECI.FK_ID_IDIOMA_SI18N = 'pt'
AND SECI.ID_TROPIC=58;
Tiempo de la consulta:
0.0006108283996582Tiempo acumulado:0.166823387146
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[84]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('mx_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050187110900879Tiempo acumulado:0.167325258255
(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 = 'mx_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('mx_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00069403648376465Tiempo acumulado:0.16801929473877
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[86]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
FROM LO_REGION RE, LO_REGION_I18N REI
WHERE REI.URL = 'jalisco'
AND REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'de';
Tiempo de la consulta:
0.00093603134155273Tiempo acumulado:0.16895532608032
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[87]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('mx_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0011780261993408Tiempo acumulado:0.17013335227966
(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 = 'mx_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('mx_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00083303451538086Tiempo acumulado:0.17096638679504
(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 = 'mx_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('mx_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00081419944763184Tiempo acumulado:0.17178058624268
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[90]: SELECT RE.ID_REGION, REI.DESC_REGION,REI.URL URL_REGION
FROM Prod_Yumping_mx_MX.LO_REGION RE, Prod_Yumping_mx_MX.LO_REGION_I18N REI
WHERE RE.ID_REGION=8732
AND RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA = 'pt';
Tiempo de la consulta:
0.00039291381835938Tiempo acumulado:0.17217350006104
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[91]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM LO_SECTORES_I18N SECI
INNER JOIN LO_SECTORES SEC ON SECI.ID_SECTOR=SEC.ID_SECTOR
WHERE SECI.URL = 'flyboard'
AND ID_TROPIC = 57
AND SECI.FK_ID_IDIOMA_SI18N = 'de'
LIMIT 1;
Tiempo de la consulta:
0.001255989074707Tiempo acumulado:0.17342948913574
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[92]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('mx_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00052189826965332Tiempo acumulado:0.1739513874054
(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 = 'mx_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('mx_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00048089027404785Tiempo acumulado:0.17443227767944
(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 = 'mx_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('mx_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00048208236694336Tiempo acumulado:0.17491436004639
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[95]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM Prod_Yumping_mx_MX.LO_SECTORES SEC
INNER JOIN Prod_Yumping_mx_MX.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
WHERE SEC.ID_SECTOR=109
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
AND SECI.ID_TROPIC=51;
Tiempo de la consulta:
0.00072002410888672Tiempo acumulado:0.17563438415527
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[96]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('mx_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00068306922912598Tiempo acumulado:0.1763174533844
(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 = 'mx_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('mx_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00061893463134766Tiempo acumulado:0.17693638801575
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[98]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
FROM LO_REGION RE, LO_REGION_I18N REI
WHERE REI.URL = 'jalisco'
AND REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'de';
Tiempo de la consulta:
0.00050806999206543Tiempo acumulado:0.17744445800781
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[99]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('mx_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0014641284942627Tiempo acumulado:0.17890858650208
(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 = 'mx_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('mx_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047206878662109Tiempo acumulado:0.1793806552887
(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 = 'mx_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('mx_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046896934509277Tiempo acumulado:0.17984962463379
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[102]: SELECT RE.ID_REGION, REI.DESC_REGION,REI.URL URL_REGION
FROM Prod_Yumping_mx_MX.LO_REGION RE, Prod_Yumping_mx_MX.LO_REGION_I18N REI
WHERE RE.ID_REGION=8732
AND RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA = 'es';
Tiempo de la consulta:
0.00040197372436523Tiempo acumulado:0.18025159835815
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[103]: 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 = 'flyboard'
AND ID_TROPIC = 57
AND SECI.FK_ID_IDIOMA_SI18N = 'de'
LIMIT 1;
Tiempo de la consulta:
0.00065493583679199Tiempo acumulado:0.18090653419495
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[104]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('mx_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049400329589844Tiempo acumulado:0.18140053749084
(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 = 'mx_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language'
AND CFG.AMBITO IN ('mx_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047183036804199Tiempo acumulado:0.18187236785889
(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 = 'mx_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('mx_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00044894218444824Tiempo acumulado:0.18232131004333
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[107]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SEC.ID_GRUPO,SECI.URL URL_SECTOR,ID_GRUPO,SECI.TURISMO_ACTIVO
FROM Prod_Yumping_mx_MX.LO_SECTORES SEC
INNER JOIN Prod_Yumping_mx_MX.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
WHERE SEC.ID_SECTOR=109
AND SECI.FK_ID_IDIOMA_SI18N = 'ch'
AND SECI.ID_TROPIC=56;
Tiempo de la consulta:
0.00055122375488281Tiempo acumulado:0.18287253379822
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[108]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('mx_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045013427734375Tiempo acumulado:0.18332266807556
(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 = 'mx_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('mx_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00044894218444824Tiempo acumulado:0.18377161026001
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[110]: SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL
FROM LO_REGION RE, LO_REGION_I18N REI
WHERE REI.URL = 'jalisco'
AND REI.ID_REGION = RE.ID_REGION
AND REI.IDIOMA = 'de';
Tiempo de la consulta:
0.00054621696472168Tiempo acumulado:0.18431782722473
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[111]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('mx_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046801567077637Tiempo acumulado:0.18478584289551
(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 = 'mx_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Language_Regiones'
AND CFG.AMBITO IN ('mx_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045514106750488Tiempo acumulado:0.18524098396301
(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 = 'mx_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_Data_Base'
AND CFG.AMBITO IN ('mx_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046706199645996Tiempo acumulado:0.18570804595947
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[114]: SELECT RE.ID_REGION, REI.DESC_REGION,REI.URL URL_REGION
FROM Prod_Yumping_mx_MX.LO_REGION RE, Prod_Yumping_mx_MX.LO_REGION_I18N REI
WHERE RE.ID_REGION=8732
AND RE.ID_REGION = REI.ID_REGION
AND REI.IDIOMA = 'ch';
Tiempo de la consulta:
0.00042200088500977Tiempo acumulado:0.18613004684448
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[115]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00048017501831055Tiempo acumulado:0.18661022186279
(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 = 'mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043797492980957Tiempo acumulado:0.1870481967926
(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 = 'mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045514106750488Tiempo acumulado:0.18750333786011
(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 = 'mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043296813964844Tiempo acumulado:0.18793630599976
(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 = 'mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0018720626831055Tiempo acumulado:0.18980836868286
(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 = 'mx_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('mx_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00044083595275879Tiempo acumulado:0.19024920463562
(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 = 'mx_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('mx_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042200088500977Tiempo acumulado:0.19067120552063
(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 = 'mx_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('mx_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00041794776916504Tiempo acumulado:0.19108915328979
(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 = 'mx_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('mx_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042200088500977Tiempo acumulado:0.1915111541748
(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 = 'mx_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('mx_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004420280456543Tiempo acumulado:0.19195318222046
(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 = 'mx_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('mx_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043797492980957Tiempo acumulado:0.19239115715027
(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 = 'mx_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('mx_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045990943908691Tiempo acumulado:0.19285106658936
(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 = 'mx_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('mx_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0006411075592041Tiempo acumulado:0.19349217414856
(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 = 'mx_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('mx_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00044393539428711Tiempo acumulado:0.19393610954285
(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 = 'mx_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('mx_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00048995018005371Tiempo acumulado:0.1944260597229
(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 = 'mx_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('mx_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00093293190002441Tiempo acumulado:0.19535899162292
(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 = 'mx_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('mx_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00054812431335449Tiempo acumulado:0.19590711593628
(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 = 'mx_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('mx_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00053620338439941Tiempo acumulado:0.19644331932068
(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 = 'mx_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('mx_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00059413909912109Tiempo acumulado:0.1970374584198
(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 = 'mx_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('mx_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045108795166016Tiempo acumulado:0.19748854637146
(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 = 'mx_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('mx_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00042891502380371Tiempo acumulado:0.19791746139526
(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 = 'mx_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('mx_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0023179054260254Tiempo acumulado:0.20023536682129
(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 = 'mx_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('mx_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043392181396484Tiempo acumulado:0.20066928863525
(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 = 'mx_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('mx_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046086311340332Tiempo acumulado:0.20113015174866
(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 = 'mx_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('mx_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0017189979553223Tiempo acumulado:0.20284914970398
(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 = 'mx_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('mx_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046014785766602Tiempo acumulado:0.20330929756165
(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 = 'mx_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('mx_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043606758117676Tiempo acumulado:0.20374536514282
(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 = 'mx_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain'
AND CFG.AMBITO IN ('mx_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00044512748718262Tiempo acumulado:0.20419049263
(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 = 'mx_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('mx_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0006248950958252Tiempo acumulado:0.20481538772583
(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 = 'mx_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('mx_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00044584274291992Tiempo acumulado:0.20526123046875
(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 = 'mx_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('mx_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0010251998901367Tiempo acumulado:0.20628643035889
(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 = 'mx_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('mx_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.001384973526001Tiempo acumulado:0.20767140388489
(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 = 'mx_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('mx_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047802925109863Tiempo acumulado:0.20814943313599
(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 = 'mx_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('mx_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00059008598327637Tiempo acumulado:0.20873951911926
(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 = 'mx_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('mx_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00072097778320312Tiempo acumulado:0.20946049690247
(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 = 'mx_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('mx_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00060081481933594Tiempo acumulado:0.2100613117218
(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 = 'mx_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('mx_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0014288425445557Tiempo acumulado:0.21149015426636
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[152]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.ID_PAIS = 301
AND IDIOMA = 'de';
Tiempo de la consulta:
0.0004279613494873Tiempo acumulado:0.21191811561584
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[153]: SELECT SEOHOME.TITLE, SEOHOME.METADESCRIPTION,SEOHOME.DESCRIPTION,SEOHOME.DESCRIPTION2,SEOHOME.HEIGHT
FROM LO_SEO_DESCRIPTIONS_HOME SEOHOME
WHERE SEOHOME.ID_TROPIC = 57
AND SEOHOME.ID_KEY='S109'
AND SEOHOME.ID_LOCALIZACION='8732';
Tiempo de la consulta:
0.0018131732940674Tiempo acumulado:0.21373128890991
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[154]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.001068115234375Tiempo acumulado:0.21479940414429
(Prod_Yumping_mx_MX) (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.00036001205444336Tiempo acumulado:0.21515941619873
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[156]: SELECT N_OPIS AS TOTAL, MEDIA_OPIS_5 AS MEDIA, ROUND(MEDIA_OPIS_100,0) AS MEDIA2
FROM LO_REGION_STATS
WHERE ID_REGION = 8732
AND ID_SECTOR = 109;
Tiempo de la consulta:
0.00042200088500977Tiempo acumulado:0.21558141708374
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[157]: 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 = 109
AND PRE.ID_REGION_PRE ='8732'
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 = 109
AND PRE.ID_REGION_PRE ='8732'
/* 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 = 109
AND PRE.ID_REGION_PRE ='8732'
*/ ) AS PRECIO_MIN_MAX;
Tiempo de la consulta:
0.0049328804016113Tiempo acumulado:0.22051429748535
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[158]: SELECT *
FROM LO_SEO_KEYWORDS_LANDING SKL
WHERE SKL.ID_SECTOR = 109
AND SKL.ID_TROPIC = 57;
Tiempo de la consulta:
0.00045990943908691Tiempo acumulado:0.22097420692444
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[159]: SELECT '1' as TIPO, PRE.N_VENTAS_PRE AS VENTAS , IF(PP.ID_REGION_PP = 8732
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_DE PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'de'
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 = 8732
/*
INNER JOIN LO_POBLACION_MX PO ON PO.ID_POBLACION = PRE.ID_POBLACION_PRE
AND PO.IDIOMA='de'
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 = 109 OR (ID_SECTOR_PP = 109
AND PP.ID_REGION_PP = 8732))
AND (PRE.ID_REGION_PRE = 8732 OR (PP.ID_REGION_PP = 8732
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.90470695495605Tiempo acumulado:1.1256811618805
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[160]: SELECT count(*) as NOFERTAS
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_DE PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'de'
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 = 8732
/*
INNER JOIN LO_POBLACION_MX PO ON PO.ID_POBLACION = PRE.ID_POBLACION_PRE
AND PO.IDIOMA='de'
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 = 109 OR (ID_SECTOR_PP = 109
AND PP.ID_REGION_PP = 8732))
AND (PRE.ID_REGION_PRE = 8732 OR (PP.ID_REGION_PP = 8732
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 (slow_query): 0.10575079917908Tiempo acumulado:1.2314319610596
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[161]: SELECT '3' as TIPO, PRE.N_VENTAS_PRE AS VENTAS , IF(PP.ID_REGION_PP = 8732
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_DE PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'de'
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 = 'de'
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 = 'de'
AND SECI.ID_TROPIC = 57)
LEFT JOIN LO_REGIONES_CERCANAS RCER ON RCER.ID_PROVINCIA_CERCANA = PRE.ID_REGION_PRE
AND RCER.ID_PROVINCIA = 8732
LEFT JOIN LO_REGION_I18N REI ON REI.ID_REGION = PRE.ID_REGION_PRE
AND REI.IDIOMA='de'
INNER JOIN LO_REGION_ADM1_I18N REIA ON REIA.ID_REGION_ADM1 = RE.ID_REGION_ADM1
AND REIA.IDIOMA = 'de'
LEFT JOIN LO_POBLACION_MX PO ON PO.ID_POBLACION = PRE.ID_POBLACION_PRE
AND PO.IDIOMA='de'
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 (67922)
AND PRE.VALID_PRE = 4
AND (PS.ID_ACTIVIDAD_PS = 109 OR (ID_SECTOR_PP = 109
AND PP.ID_REGION_PP = 8732))
AND (PRE.ID_REGION_PRE = 8732 OR (PP.ID_REGION_PP = 8732
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.010210037231445Tiempo acumulado:1.241641998291
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[162]: SELECT SEO.KEYWORD, ID_KEY, SEO.PESO_FOOTER
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'O1'
AND SEO.ID_TROPIC = 57
AND SEO.FK_ID_REG_ADM = 0
AND 1=1;
Tiempo de la consulta:
0.0012149810791016Tiempo acumulado:1.2428569793701
(Prod_Yumping_mx_MX) (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 = 'S109'
AND SEO.ID_TROPIC = 57
AND SEO.FK_ID_REG_ADM = 0
AND 1=1;
Tiempo de la consulta:
0.00076484680175781Tiempo acumulado:1.2436218261719
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[164]: SELECT *
FROM LO_PRECIOS_CALENDARIO PC
WHERE PC.ID_PRECIO_PC = 67922
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.0031628608703613Tiempo acumulado:1.2467846870422
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[165]: SELECT (PRE.PERIODO_PRE) AS PERIODO
FROM LO_PRECIOS PRE
WHERE PRE.ID_PRECIO = 67922
UNION ALL
SELECT PD.PERIODO_PD AS PERIODO
FROM LO_PRECIOS_DESCUENTOS PD
WHERE PD.ID_PRECIO_PD = 67922
AND PD.VALID_PD = 1;
Tiempo de la consulta:
0.00052905082702637Tiempo acumulado:1.2473137378693
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[166]: 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 = 57
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 = 67922
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 = 57
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 = 67922
GROUP BY PRE.ID_PRECIO
) AS X;
Tiempo de la consulta:
0.0012760162353516Tiempo acumulado:1.2485897541046
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[167]: SELECT *
FROM LO_PRECIOS_MODIFICAR_ORDEN
WHERE ID_PRECIO = 67922
AND DATE_FORMAT(FECHA, '%Y-%m-%d') >= NOW() - INTERVAL 3 MONTH;
Tiempo de la consulta:
0.0011780261993408Tiempo acumulado:1.249767780304
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[168]: 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_DE ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'de'
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='de'
LEFT JOIN LO_REGION_ADM1 REIAD ON RE.ID_REGION_ADM1 = REIAD.ID_REGION_ADM1
LEFT JOIN LO_POBLACION_MX PO ON EMP.ID_POBLACION = PO.ID_POBLACION
AND PO.IDIOMA='de'
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 = 57
AND SECI.FK_ID_IDIOMA_SI18N = 'de')
INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
AND (GRU.ID_TROPIC = 57)
WHERE EMP.ID_EMPRESA = 19756743
AND EMP.VALID IN ('1', '-3')
LIMIT 1;
Tiempo de la consulta:
0.0017189979553223Tiempo acumulado:1.2514867782593
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[169]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 67922
AND VALID = 1;
Tiempo de la consulta:
0.0033178329467773Tiempo acumulado:1.2548046112061
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[170]: SELECT *
FROM LO_FOTOS
WHERE ID_PRECIO = 67922
AND FOTO = 'p-67922-flyboard_16143275025342.jpeg'
AND VALID = 1;
Tiempo de la consulta:
0.00049591064453125Tiempo acumulado:1.2553005218506
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[171]: SELECT F_WIDTH, F_HEIGHT
FROM LO_FOTOS
WHERE ID_PRECIO = 67922
AND FOTO = 'p-67922-flyboard_16143275025342.jpeg';
Tiempo de la consulta:
0.00033807754516602Tiempo acumulado:1.2556385993958
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[172]: 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_DE PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'de'
WHERE PRE.ID_PRECIO = 67922;
Tiempo de la consulta:
0.00051307678222656Tiempo acumulado:1.256151676178
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[173]: 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 = 67922;
Tiempo de la consulta:
0.0010640621185303Tiempo acumulado:1.2572157382965
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[174]: SELECT N_VENTAS_LAST_MONTH
FROM LO_PRECIOS_STATS PS
WHERE PS.ID_PRECIO = 67922;
Tiempo de la consulta:
0.0011000633239746Tiempo acumulado:1.2583158016205
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[175]: 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_DE PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'de'
WHERE ID_PRECIO = 67922
AND VALID_PRE = 4
GROUP BY PRE.ID_PRECIO
HAVING FEC_ULT_COMPRA IS NOT NULL
LIMIT 1;
Tiempo de la consulta:
0.00051999092102051Tiempo acumulado:1.2588357925415
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[176]: SELECT EXITO
FROM LO_PRECIOS_EXITO
WHERE ID_PRECIO = 67922
LIMIT 1;
Tiempo de la consulta:
0.0010790824890137Tiempo acumulado:1.2599148750305
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[177]: SELECT COUNT(*) AS TOTAL
FROM LO_PRECIOS_SECTORES PS
WHERE PS.ID_ACTIVIDAD_PS NOT IN (100,101)
AND PS.ID_PRECIO_PS = 67922;
Tiempo de la consulta:
0.00042414665222168Tiempo acumulado:1.2603390216827
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[178]: SELECT *
FROM LO_PRECIOS_DIA_ESPECIAL PD
WHERE PD.ID_PRECIO_DE = 67922
AND ID_TIPO_DE = 7
AND VALID = 1;
Tiempo de la consulta:
0.0010948181152344Tiempo acumulado:1.261433839798
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[179]: 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_DE PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'de'
WHERE PRE.ID_PRECIO = 67922;
Tiempo de la consulta:
0.00064992904663086Tiempo acumulado:1.2620837688446
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[180]: 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 = 67922;
Tiempo de la consulta:
0.00045299530029297Tiempo acumulado:1.2625367641449
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[181]: 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 = '8732'
AND REI.IDIOMA = 'de';
Tiempo de la consulta:
0.0083940029144287Tiempo acumulado:1.2709307670593
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[182]: 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 = '109';
Tiempo de la consulta:
0.010401010513306Tiempo acumulado:1.2813317775726
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[183]: 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('20.7730007172'))
* cos(radians(P.LATITUDE))
* cos(radians(P.LONGITUDE) - radians('-102.9096603394'))
+ sin(radians('20.7730007172'))
* sin(radians(P.LATITUDE))
)
) AS DISTANCIA
FROM LO_PRECIOS PRE
INNER JOIN LO_PRECIOS_TRADUCCION_DE PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'de'
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 = 57 )
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=109 OR ID_SECTOR_PP = 109)
AND (PRE.ID_REGION_PRE != 8732
AND IF(PP.ID_REGION_PP IS NOT NULL
AND PP.ID_REGION_PP != 0, PP.ID_REGION_PP != 8732, 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.24041819572449Tiempo acumulado:1.5217499732971
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[184]: SELECT FOUND_ROWS() NOFERTAS;
Tiempo de la consulta:
0.00030708312988281Tiempo acumulado:1.522057056427
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[185]: 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 = 57)
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_DE PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'de'
WHERE SS.ID_SECTOR_SS=109
AND SSF.ID_TROPIC = 57
GROUP BY SSF.ID_SSF
ORDER BY COUNT(SSF.ID_SSF) DESC;
Tiempo de la consulta:
0.0007929801940918Tiempo acumulado:1.5228500366211
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[186]: 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 = 'de'
AND ID_TROPIC = 57
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 = 8732
AND RS.N_OFERTAS > 0
WHERE LSR.ID_SECTOR = 109
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.0018010139465332Tiempo acumulado:1.5246510505676
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[187]: 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 = 8732
AND PS.ID_SECTOR = 109
ORDER BY NEMPRESAS DESC;
Tiempo de la consulta:
0.00053000450134277Tiempo acumulado:1.525181055069
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[188]: 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_MX_STATS PS
INNER JOIN LO_POBLACION_MX PO ON PS.ID_POBLACION = PO.ID_POBLACION
AND PO.IDIOMA = 'de'
AND PO.ID_REGION = 8732
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PO.ID_REGION
AND REI.IDIOMA = 'de'
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 = 109
AND N_OFERTAS > 1
GROUP BY PS.ID_POBLACION
ORDER BY N_OFERTAS DESC;
Tiempo de la consulta:
0.0052618980407715Tiempo acumulado:1.5304429531097
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[189]: SELECT LO.ID_PRECIO
FROM LO_LANDING_OFERTAS LO
WHERE LO.STATUS = 2
AND LO.ID_SECTOR = 109
AND LO.ID_PROVINCIA = 8732;
Tiempo de la consulta:
0.0010700225830078Tiempo acumulado:1.5315129756927
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[190]: 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_DE PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'de'
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 = 109
AND LO.ID_PROVINCIA = 8732
LEFT JOIN LO_PRECIOS_RESTRICCIONES PR ON PRE.ID_PRECIO = PR.ID_PRECIO
WHERE PRE.VALID_PRE = 4
AND PS.ID_ACTIVIDAD_PS = 109
AND ( PRE.ID_REGION_PRE='8732' OR PP.ID_REGION_PP='8732' )
GROUP BY PRE.ID_PRECIO
ORDER BY LO.STATUS DESC, VENTAS DESC, OPIS DESC
LIMIT 4;
Tiempo de la consulta:
0.0040609836578369Tiempo acumulado:1.5355739593506
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[191]: 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_DE PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'de'
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 = 'de'
AND SECI.ID_TROPIC = 57)
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PRE.ID_REGION_PRE
AND REI.IDIOMA = 'de'
INNER JOIN LO_POBLACION_MX PO ON PRE.ID_POBLACION_PRE = PO.ID_POBLACION
AND PO.IDIOMA = 'de'
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 (67922)
AND PRE.VALID_PRE = 4
AND PS.ID_ACTIVIDAD_PS = 109
AND ( PRE.ID_REGION_PRE='8732' OR PP.ID_REGION_PP='8732' )
GROUP BY PRE.ID_PRECIO
ORDER BY VENTAS DESC, OPIS DESC
LIMIT 4;
Tiempo de la consulta:
0.0023229122161865Tiempo acumulado:1.5378968715668
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[192]: 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_DE PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'de'
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 = 109
AND LO.ID_PROVINCIA = 8732
LEFT JOIN LO_PRECIOS_RESTRICCIONES PR ON PRE.ID_PRECIO = PR.ID_PRECIO
WHERE PRE.VALID_PRE = 4
AND PS.ID_ACTIVIDAD_PS = 109
AND ( PRE.ID_REGION_PRE='8732' OR PP.ID_REGION_PP='8732' )
GROUP BY PRE.ID_PRECIO
ORDER BY LO.STATUS DESC, VENTAS DESC, OPIS DESC
LIMIT 4;
Tiempo de la consulta:
0.0020380020141602Tiempo acumulado:1.5399348735809
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[193]: 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_DE PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'de'
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 = 'de'
AND SECI.ID_TROPIC = 57)
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PRE.ID_REGION_PRE
AND REI.IDIOMA = 'de'
INNER JOIN LO_POBLACION_MX PO ON PRE.ID_POBLACION_PRE = PO.ID_POBLACION
AND PO.IDIOMA = 'de'
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 (67922)
AND PRE.VALID_PRE = 4
AND PS.ID_ACTIVIDAD_PS = 109
AND ( PRE.ID_REGION_PRE='8732' OR PP.ID_REGION_PP='8732' )
GROUP BY PRE.ID_PRECIO
ORDER BY VENTAS DESC, OPIS DESC
LIMIT 4;
Tiempo de la consulta:
0.0058178901672363Tiempo acumulado:1.5457527637482
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[194]: 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_DE PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'de'
WHERE PRE.ID_PRECIO = 67922;
Tiempo de la consulta:
0.0015308856964111Tiempo acumulado:1.5472836494446
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[195]: 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 = 67922;
Tiempo de la consulta:
0.0088629722595215Tiempo acumulado:1.5561466217041
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[196]: 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 = 109
AND ID_REGION = 8732
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.005277156829834Tiempo acumulado:1.5614237785339
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[197]: SELECT N_OPIS AS TOTAL, MEDIA_OPIS_5 AS MEDIA, ROUND(MEDIA_OPIS_100,0) AS MEDIA2
FROM LO_REGION_STATS
WHERE ID_REGION = 8732
AND ID_SECTOR = 109;
Tiempo de la consulta:
0.00070595741271973Tiempo acumulado:1.5621297359467
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[198]: 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_DE ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'de'
WHERE EMP.ID_EMPRESA = 19756744;
Tiempo de la consulta:
0.004417896270752Tiempo acumulado:1.5665476322174
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[199]: 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 = '109'
AND SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
AND SECI.ID_TROPIC = 5;
Tiempo de la consulta:
0.0032660961151123Tiempo acumulado:1.5698137283325
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[200]: 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 = '109'
AND SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N = 'de'
AND SECI.ID_TROPIC = 57;
Tiempo de la consulta:
0.0034301280975342Tiempo acumulado:1.5732438564301
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[201]: SELECT ID_MADRE
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19756744;
Tiempo de la consulta:
0.0022299289703369Tiempo acumulado:1.5754737854004
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[202]: SELECT NOMBRE, URL
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19756743;
Tiempo de la consulta:
0.0020649433135986Tiempo acumulado:1.577538728714
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[203]: 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_DE ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'de'
WHERE EMP.ID_EMPRESA = 19756744;
Tiempo de la consulta:
0.0021281242370605Tiempo acumulado:1.579666852951
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[204]: 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 = '109'
AND SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
AND SECI.ID_TROPIC = 5;
Tiempo de la consulta:
0.0065360069274902Tiempo acumulado:1.5862028598785
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[205]: 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 = '109'
AND SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N = 'de'
AND SECI.ID_TROPIC = 57;
Tiempo de la consulta:
0.0043940544128418Tiempo acumulado:1.5905969142914
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[206]: SELECT ID_MADRE
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19756744;
Tiempo de la consulta:
0.0037879943847656Tiempo acumulado:1.5943849086761
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[207]: SELECT NOMBRE, URL
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19756743;
Tiempo de la consulta:
0.0040948390960693Tiempo acumulado:1.5984797477722
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[208]: 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_DE ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'de'
WHERE EMP.ID_EMPRESA = 19756744;
Tiempo de la consulta:
0.0042679309844971Tiempo acumulado:1.6027476787567
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[209]: 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 = '109'
AND SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
AND SECI.ID_TROPIC = 5;
Tiempo de la consulta:
0.0040290355682373Tiempo acumulado:1.606776714325
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[210]: 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 = '109'
AND SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N = 'de'
AND SECI.ID_TROPIC = 57;
Tiempo de la consulta:
0.00073909759521484Tiempo acumulado:1.6075158119202
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[211]: SELECT ID_MADRE
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19756744;
Tiempo de la consulta:
0.0026888847351074Tiempo acumulado:1.6102046966553
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[212]: SELECT NOMBRE, URL
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19756743;
Tiempo de la consulta:
0.0051760673522949Tiempo acumulado:1.6153807640076
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[213]: 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_DE ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'de'
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 = 'de'
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='57'
INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
AND ( GRU.ID_TROPIC = 57)
WHERE
SECI.FK_ID_IDIOMA_SI18N='de'
AND EMP.ID_EMPRESA='19756743'
LIMIT 1;
Tiempo de la consulta:
0.0033299922943115Tiempo acumulado:1.6187107563019
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[214]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19756744
AND VALID = 1;
Tiempo de la consulta:
0.017361879348755Tiempo acumulado:1.6360726356506
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[215]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19756744
AND FOTO = 'e-19756744-logo-caletillas1613488623930.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0025079250335693Tiempo acumulado:1.6385805606842
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[216]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19756744
AND VALID = 1;
Tiempo de la consulta:
0.0024430751800537Tiempo acumulado:1.6410236358643
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[217]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19756744
AND FOTO = 'e-19756744-8910875115-e96d244a6b-k1613488624252.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0085480213165283Tiempo acumulado:1.6495716571808
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[218]: SELECT ID_EMPRESA, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_EMPRESA = 19756744;
Tiempo de la consulta:
0.011831998825073Tiempo acumulado:1.6614036560059
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[219]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19756744
AND VALID = 1;
Tiempo de la consulta:
0.0047779083251953Tiempo acumulado:1.6661815643311
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[220]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19756744
AND FOTO = 'e-19756744-8910875115-e96d244a6b-k1613488624252.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0098090171813965Tiempo acumulado:1.6759905815125
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[221]: SELECT ID_EMPRESA, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_EMPRESA = 19756744;
Tiempo de la consulta:
0.0098919868469238Tiempo acumulado:1.6858825683594
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[222]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19756744
AND VALID = 1;
Tiempo de la consulta:
0.00068783760070801Tiempo acumulado:1.6865704059601
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[223]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19756744
AND FOTO = 'e-19756744-8910875115-e96d244a6b-k1613488624252.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.0048809051513672Tiempo acumulado:1.6914513111115
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[224]: 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_DE ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'de'
WHERE EMP.ID_EMPRESA = 19727522;
Tiempo de la consulta:
0.0043129920959473Tiempo acumulado:1.6957643032074
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[225]: 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 = '109'
AND SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
AND SECI.ID_TROPIC = 5;
Tiempo de la consulta:
0.0039651393890381Tiempo acumulado:1.6997294425964
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[226]: 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 = '109'
AND SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N = 'de'
AND SECI.ID_TROPIC = 57;
Tiempo de la consulta:
0.0027589797973633Tiempo acumulado:1.7024884223938
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[227]: SELECT ID_MADRE
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19727522;
Tiempo de la consulta:
0.0021960735321045Tiempo acumulado:1.7046844959259
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[228]: SELECT NOMBRE, URL
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19679979;
Tiempo de la consulta:
0.0084741115570068Tiempo acumulado:1.7131586074829
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[229]: 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_DE ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'de'
WHERE EMP.ID_EMPRESA = 19727522;
Tiempo de la consulta:
0.0044269561767578Tiempo acumulado:1.7175855636597
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[230]: 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 = '109'
AND SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
AND SECI.ID_TROPIC = 5;
Tiempo de la consulta:
0.001762866973877Tiempo acumulado:1.7193484306335
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[231]: 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 = '109'
AND SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N = 'de'
AND SECI.ID_TROPIC = 57;
Tiempo de la consulta:
0.0015652179718018Tiempo acumulado:1.7209136486053
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[232]: SELECT ID_MADRE
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19727522;
Tiempo de la consulta:
0.0039279460906982Tiempo acumulado:1.724841594696
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[233]: SELECT NOMBRE, URL
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19679979;
Tiempo de la consulta:
0.00039792060852051Tiempo acumulado:1.7252395153046
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[234]: 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_DE ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'de'
WHERE EMP.ID_EMPRESA = 19727522;
Tiempo de la consulta:
0.0055270195007324Tiempo acumulado:1.7307665348053
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[235]: 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 = '109'
AND SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
AND SECI.ID_TROPIC = 5;
Tiempo de la consulta:
0.009915828704834Tiempo acumulado:1.7406823635101
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[236]: 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 = '109'
AND SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N = 'de'
AND SECI.ID_TROPIC = 57;
Tiempo de la consulta:
0.0085151195526123Tiempo acumulado:1.7491974830627
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[237]: SELECT ID_MADRE
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19727522;
Tiempo de la consulta:
0.00063514709472656Tiempo acumulado:1.7498326301575
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[238]: SELECT NOMBRE, URL
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19679979;
Tiempo de la consulta:
0.0040020942687988Tiempo acumulado:1.7538347244263
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[239]: 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_DE ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'de'
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 = 'de'
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='57'
INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
AND ( GRU.ID_TROPIC = 57)
WHERE
SECI.FK_ID_IDIOMA_SI18N='de'
AND EMP.ID_EMPRESA='19679979'
LIMIT 1;
Tiempo de la consulta:
0.0081717967987061Tiempo acumulado:1.762006521225
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[240]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19727522
AND VALID = 1;
Tiempo de la consulta:
0.021111965179443Tiempo acumulado:1.7831184864044
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[241]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19727522
AND FOTO = 'Logo de OV Fishing
AND sailing.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00061488151550293Tiempo acumulado:1.7837333679199
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[242]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19727522
AND VALID = 1;
Tiempo de la consulta:
0.00072908401489258Tiempo acumulado:1.7844624519348
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[243]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19727522
AND FOTO = 'vamos al agua.jpg'
AND VALID=1;
Tiempo de la consulta:
0.011073112487793Tiempo acumulado:1.7955355644226
(Prod_Yumping_mx_MX) (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 = 19727522;
Tiempo de la consulta:
0.0097658634185791Tiempo acumulado:1.8053014278412
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[245]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19727522
AND VALID = 1;
Tiempo de la consulta:
0.00075387954711914Tiempo acumulado:1.8060553073883
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[246]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19727522
AND FOTO = 'vamos al agua.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0019500255584717Tiempo acumulado:1.8080053329468
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[247]: SELECT ID_EMPRESA, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_EMPRESA = 19727522;
Tiempo de la consulta:
0.00065088272094727Tiempo acumulado:1.8086562156677
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[248]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19727522
AND VALID = 1;
Tiempo de la consulta:
0.00074195861816406Tiempo acumulado:1.8093981742859
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[249]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19727522
AND FOTO = 'vamos al agua.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.0036501884460449Tiempo acumulado:1.8130483627319
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[250]: 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_DE ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'de'
WHERE EMP.ID_EMPRESA = 19727834;
Tiempo de la consulta:
0.0021829605102539Tiempo acumulado:1.8152313232422
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[251]: 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 = '109'
AND SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
AND SECI.ID_TROPIC = 5;
Tiempo de la consulta:
0.0016708374023438Tiempo acumulado:1.8169021606445
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[252]: 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 = '109'
AND SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N = 'de'
AND SECI.ID_TROPIC = 57;
Tiempo de la consulta:
0.00086498260498047Tiempo acumulado:1.8177671432495
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[253]: SELECT ID_MADRE
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19727834;
Tiempo de la consulta:
0.00055289268493652Tiempo acumulado:1.8183200359344
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[254]: SELECT NOMBRE, URL
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19704117;
Tiempo de la consulta:
0.00058317184448242Tiempo acumulado:1.8189032077789
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[255]: 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_DE ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'de'
WHERE EMP.ID_EMPRESA = 19727834;
Tiempo de la consulta:
0.0046579837799072Tiempo acumulado:1.8235611915588
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[256]: 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 = '109'
AND SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
AND SECI.ID_TROPIC = 5;
Tiempo de la consulta:
0.0007779598236084Tiempo acumulado:1.8243391513824
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[257]: 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 = '109'
AND SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N = 'de'
AND SECI.ID_TROPIC = 57;
Tiempo de la consulta:
0.00075888633728027Tiempo acumulado:1.8250980377197
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[258]: SELECT ID_MADRE
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19727834;
Tiempo de la consulta:
0.0023469924926758Tiempo acumulado:1.8274450302124
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[259]: SELECT NOMBRE, URL
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19704117;
Tiempo de la consulta:
0.0040528774261475Tiempo acumulado:1.8314979076385
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[260]: 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_DE ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'de'
WHERE EMP.ID_EMPRESA = 19727834;
Tiempo de la consulta:
0.0033810138702393Tiempo acumulado:1.8348789215088
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[261]: 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 = '109'
AND SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
AND SECI.ID_TROPIC = 5;
Tiempo de la consulta:
0.00071883201599121Tiempo acumulado:1.8355977535248
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[262]: 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 = '109'
AND SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.FK_ID_IDIOMA_SI18N = 'de'
AND SECI.ID_TROPIC = 57;
Tiempo de la consulta:
0.00070381164550781Tiempo acumulado:1.8363015651703
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[263]: SELECT ID_MADRE
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19727834;
Tiempo de la consulta:
0.00052094459533691Tiempo acumulado:1.8368225097656
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[264]: SELECT NOMBRE, URL
FROM LO_EMPRESAS EMP
WHERE EMP.ID_EMPRESA = 19704117;
Tiempo de la consulta:
0.0024750232696533Tiempo acumulado:1.8392975330353
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[265]: 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_DE ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'de'
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 = 'de'
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='57'
INNER JOIN LO_GRUPOS GRU ON GRU.ID_GRUPO = SEC.ID_GRUPO
AND ( GRU.ID_TROPIC = 57)
WHERE
SECI.FK_ID_IDIOMA_SI18N='de'
AND EMP.ID_EMPRESA='19704117'
LIMIT 1;
Tiempo de la consulta:
0.0039858818054199Tiempo acumulado:1.8432834148407
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[266]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19727834
AND VALID = 1;
Tiempo de la consulta:
0.0046560764312744Tiempo acumulado:1.847939491272
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[267]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19727834
AND FOTO = 'Logo de vip access vallarta.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00060200691223145Tiempo acumulado:1.8485414981842
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[268]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19727834
AND VALID = 1;
Tiempo de la consulta:
0.0011382102966309Tiempo acumulado:1.8496797084808
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[269]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19727834
AND FOTO = 'haciendo el delfin.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00051593780517578Tiempo acumulado:1.850195646286
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[270]: SELECT ID_EMPRESA, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_EMPRESA = 19727834;
Tiempo de la consulta:
0.00060606002807617Tiempo acumulado:1.8508017063141
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[271]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19727834
AND VALID = 1;
Tiempo de la consulta:
0.0016689300537109Tiempo acumulado:1.8524706363678
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[272]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19727834
AND FOTO = 'haciendo el delfin.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00052618980407715Tiempo acumulado:1.8529968261719
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[273]: SELECT ID_EMPRESA, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_EMPRESA = 19727834;
Tiempo de la consulta:
0.0016980171203613Tiempo acumulado:1.8546948432922
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[274]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19727834
AND VALID = 1;
Tiempo de la consulta:
0.00072813034057617Tiempo acumulado:1.8554229736328
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[275]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19727834
AND FOTO = 'haciendo el delfin.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.0066280364990234Tiempo acumulado:1.8620510101318
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[276]: 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_DE ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'de'
WHERE EMP.ID_EMPRESA = 19737793;
Tiempo de la consulta:
0.0098240375518799Tiempo acumulado:1.8718750476837
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[277]: 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_DE ET ON EMP.ID_EMPRESA = ET.ID_EMPRESA_ET
AND ET.IDIOMA_ET = 'de'
WHERE EMP.ID_EMPRESA = 19737793;
Tiempo de la consulta:
0.0099160671234131Tiempo acumulado:1.8817911148071
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[278]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19737793
AND VALID = 1;
Tiempo de la consulta:
0.013846158981323Tiempo acumulado:1.8956372737885
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[279]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19737793
AND FOTO = 'e-19737793-logo-flyboard-pv14872761813659.jpg'
AND VALID=1;
Tiempo de la consulta:
0.00055980682373047Tiempo acumulado:1.8961970806122
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[280]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19737793
AND VALID = 1;
Tiempo de la consulta:
0.0099050998687744Tiempo acumulado:1.906102180481
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[281]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19737793
AND FOTO = 'e-19737793-gira-en-el-agua14872761794348.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0096859931945801Tiempo acumulado:1.9157881736755
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[282]: SELECT ID_EMPRESA, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_EMPRESA = 19737793;
Tiempo de la consulta:
0.0042870044708252Tiempo acumulado:1.9200751781464
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[283]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19737793
AND VALID = 1;
Tiempo de la consulta:
0.0099279880523682Tiempo acumulado:1.9300031661987
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[284]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19737793
AND FOTO = 'e-19737793-gira-en-el-agua14872761794348.jpg'
AND VALID=1;
Tiempo de la consulta:
0.0038740634918213Tiempo acumulado:1.9338772296906
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[285]: SELECT ID_EMPRESA, ERROR, CHECK_NEW_FORMATS
FROM LO_COM_IMAGES_NEW_FORMATS
WHERE ID_EMPRESA = 19737793;
Tiempo de la consulta:
0.0016939640045166Tiempo acumulado:1.9355711936951
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[286]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19737793
AND VALID = 1;
Tiempo de la consulta:
0.0053811073303223Tiempo acumulado:1.9409523010254
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[287]: SELECT *
FROM LO_FOTOS
WHERE ID_EMPRESA = 19737793
AND FOTO = 'e-19737793-gira-en-el-agua14872761794348.jpg'
AND VALID = 1;
Tiempo de la consulta:
0.0038809776306152Tiempo acumulado:1.944833278656
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[288]: 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 = 57)
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_DE PT ON PRE.ID_PRECIO = PT.ID_PRECIO_PT
AND PT.IDIOMA_PT = 'de'
WHERE SS.ID_SECTOR_SS=109
AND SSF.ID_TROPIC = 57
GROUP BY SSF.ID_SSF
ORDER BY COUNT(SSF.ID_SSF) DESC;
Tiempo de la consulta:
0.010050058364868Tiempo acumulado:1.9548833370209
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[289]: 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 = 'de'
AND ID_TROPIC = 57
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 = 109
AND (PRE.ID_REGION_PRE = 8732 OR ID_REGION_PP = 8732)
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.0022568702697754Tiempo acumulado:1.9571402072906
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[290]: SELECT SEO.DESCRIPTION
FROM LO_SEO_DESCRIPTIONS SEO
WHERE SEO.ID_TROPIC='57'
AND SEO.ID_KEY='S109';
Tiempo de la consulta:
0.0013601779937744Tiempo acumulado:1.9585003852844
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[291]: 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 = 57
WHERE SEOHOME.ID_TROPIC = 57
AND SEOHOME.ID_KEY = 'S109'
AND SEO_VALID in (0,1)
AND SEOHOME.ID_LOCALIZACION='8732';
Tiempo de la consulta:
0.0049209594726562Tiempo acumulado:1.9634213447571
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[292]: 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_MX_STATS PS
INNER JOIN LO_POBLACION_MX PO ON PO.ID_POBLACION = PS.ID_POBLACION
AND PO.IDIOMA = 'de'
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION = PO.ID_REGION
AND REI.IDIOMA = 'de'
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='57'
AND SECI.FK_ID_IDIOMA_SI18N = 'de'
WHERE
REI.ID_REGION = 8732
AND PS.ID_SECTOR = 109
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.0017879009246826Tiempo acumulado:1.9652092456818
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[293]: 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 = 'de'
INNER JOIN LO_REGION RE ON RE.ID_REGION = REI.ID_REGION
INNER JOIN LO_SECTORES SEC ON SEC.ID_SECTOR = PS.ID_SECTOR
AND SEC.ID_GRUPO = 1
INNER JOIN LO_SECTORES_I18N SECI ON PS.ID_SECTOR = SECI.ID_SECTOR
AND SECI.ID_TROPIC='57'
AND SECI.FK_ID_IDIOMA_SI18N = 'de'
WHERE
REI.ID_REGION = 8732
AND (PS.N_OFERTAS > 0
AND PS.N_OFERTAS IS NOT NULL)
ORDER BY NEMPRESAS DESC;
Tiempo de la consulta:
0.0027401447296143Tiempo acumulado:1.9679493904114
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[294]: SELECT COUNT(*) AS NEMPRESAS
FROM LO_REGION_STATS
WHERE ID_REGION = 8732
AND ID_GRUPO = 1;
Tiempo de la consulta:
0.001453161239624Tiempo acumulado:1.969402551651
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[295]: 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 = '8732'
AND REI.IDIOMA = 'de';
Tiempo de la consulta:
0.0076210498809814Tiempo acumulado:1.977023601532
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[296]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S51'
AND (SEO.ID_TROPIC = 57
);
Tiempo de la consulta:
0.0015389919281006Tiempo acumulado:1.9785625934601
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[297]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S8'
AND (SEO.ID_TROPIC = 57
);
Tiempo de la consulta:
0.00086307525634766Tiempo acumulado:1.9794256687164
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[298]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S92'
AND (SEO.ID_TROPIC = 57
);
Tiempo de la consulta:
0.0065670013427734Tiempo acumulado:1.9859926700592
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[299]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S7'
AND (SEO.ID_TROPIC = 57
);
Tiempo de la consulta:
0.0039479732513428Tiempo acumulado:1.9899406433105
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[300]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S66'
AND (SEO.ID_TROPIC = 57
);
Tiempo de la consulta:
0.00052499771118164Tiempo acumulado:1.9904656410217
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[301]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S45'
AND (SEO.ID_TROPIC = 57
);
Tiempo de la consulta:
0.0027780532836914Tiempo acumulado:1.9932436943054
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[302]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S11'
AND (SEO.ID_TROPIC = 57
);
Tiempo de la consulta:
0.0068228244781494Tiempo acumulado:2.0000665187836
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[303]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S29'
AND (SEO.ID_TROPIC = 57
);
Tiempo de la consulta:
0.0091159343719482Tiempo acumulado:2.0091824531555
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[304]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S55'
AND (SEO.ID_TROPIC = 57
);
Tiempo de la consulta:
0.0067400932312012Tiempo acumulado:2.0159225463867
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[305]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S23'
AND (SEO.ID_TROPIC = 57
);
Tiempo de la consulta:
0.0036418437957764Tiempo acumulado:2.0195643901825
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[306]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S12'
AND (SEO.ID_TROPIC = 57
);
Tiempo de la consulta:
0.0065348148345947Tiempo acumulado:2.0260992050171
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[307]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S44'
AND (SEO.ID_TROPIC = 57
);
Tiempo de la consulta:
0.0040640830993652Tiempo acumulado:2.0301632881165
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[308]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S27'
AND (SEO.ID_TROPIC = 57
);
Tiempo de la consulta:
0.00081896781921387Tiempo acumulado:2.0309822559357
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[309]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S28'
AND (SEO.ID_TROPIC = 57
);
Tiempo de la consulta:
0.0024170875549316Tiempo acumulado:2.0333993434906
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[310]: SELECT SEO.KEYWORD
FROM LO_SEO_KEYWORDS SEO
WHERE SEO.ID_KEY = 'S109'
AND (SEO.ID_TROPIC = 57
);
Tiempo de la consulta:
0.0031709671020508Tiempo acumulado:2.0365703105927
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[311]: SELECT *
FROM LO_REGION
INNER JOIN LO_REGION_I18N ON LO_REGION.ID_REGION = LO_REGION_I18N.ID_REGION
WHERE IDIOMA = 'de'
ORDER BY DESC_REGION ASC;
Tiempo de la consulta:
0.0008389949798584Tiempo acumulado:2.0374093055725
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[312]: SELECT *
FROM LO_EQUIPO_EDITORIAL EE
WHERE EE.ID_TROPIC = 57;
Tiempo de la consulta:
0.0011320114135742Tiempo acumulado:2.0385413169861
.Cerramos Conexiones BB.DD.
