yu-front-06.localdomain (172.30.2.194:443)
prod.yumping.com
/index.php
BBDD->Prod_Yumping_mx_MX
AMBITO->mx
AMBITO_AJAX->mx
AMBITO_AJAX COOKIE->es
locale LO_CONFIG->es_MX
locale php->es_MX
Fuente tráfico->0
SESSION VARS
DEFINED VARS
$tpage->
homeCache VARS
NOCFG->memcache_port->11212
CFG->memcache_main_server->172.30.2.194
CFG->memcache_add_servers->172.30.2.194
YMMemcache::memcache_stats->
SERVER VARS
HTTP_REFERER
Request VARS
ambito_lang->es-MX
Total queries: 91
Tiempo total: 0.32057404518127
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[1]: SELECT CFG.ID, CFG.NAME, IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '', CFG.VALUE_PROD, CFG.VALUE) VALUE , CFG.AMBITO, CFG.VISIBLE_AJAX, CFG.TIME
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.AMBITO IN ('global', 'mx')
ORDER BY CFG.NAME;
Tiempo de la consulta:
0.0071711540222168Tiempo acumulado:0.0071711540222168
(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.00049996376037598Tiempo acumulado:0.0076711177825928
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[3]: SELECT CFG.ID, CFG.NAME, IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '', CFG.VALUE_PROD, CFG.VALUE) VALUE , CFG.AMBITO, CFG.VISIBLE_AJAX, CFG.TIME
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.AMBITO IN ('global', 'mx')
ORDER BY CFG.NAME;
Tiempo de la consulta:
0.007328987121582Tiempo acumulado:0.015000104904175
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[4]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.002593994140625Tiempo acumulado:0.0175940990448
(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.00030779838562012Tiempo acumulado:0.01790189743042
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[6]: SELECT `TIMESTAMP`, VALUE
FROM LO_CURRENCIES_CONVERSION
WHERE `FROM` = 'EUR'
AND `TO` = 'MXN';
Tiempo de la consulta:
0.00032997131347656Tiempo acumulado:0.018231868743896
(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.00060606002807617Tiempo acumulado:0.018837928771973
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[8]: SELECT OLD_URL, NEW_URL
FROM LO_URL_301 U
WHERE U.OLD_URL = '/es-MX';
Tiempo de la consulta:
0.00092720985412598Tiempo acumulado:0.019765138626099
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[9]: SELECT *
FROM LO_SEO_INDEX SI
WHERE ID_TROPIC = 5;
Tiempo de la consulta:
0.0099589824676514Tiempo acumulado:0.02972412109375
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[10]: SELECT SUM(NUM_PRECIOS) AS NUM_PRECIOS
FROM (
SELECT s.NUM_PRECIOS
FROM Yumping.LO_YUMPING_STATS s
UNION ALL
SELECT s.NUM_PRECIOS
FROM Yumping_it_IT.LO_YUMPING_STATS s
UNION ALL
SELECT s.NUM_PRECIOS
FROM Yumping_fr_FR.LO_YUMPING_STATS s
UNION ALL
SELECT s.NUM_PRECIOS
FROM Yumping_co_UK.LO_YUMPING_STATS s
UNION ALL
SELECT s.NUM_PRECIOS
FROM Yumping_mx_MX.LO_YUMPING_STATS s
) AS STATS;
Tiempo de la consulta:
0.0029690265655518Tiempo acumulado:0.032693147659302
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[11]: 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.00055885314941406Tiempo acumulado:0.033252000808716
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[12]: 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.00073719024658203Tiempo acumulado:0.033989191055298
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[13]: 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.00068998336791992Tiempo acumulado:0.034679174423218
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[14]: 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.00049209594726562Tiempo acumulado:0.035171270370483
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[15]: 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.0039668083190918Tiempo acumulado:0.039138078689575
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[16]: 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.00048303604125977Tiempo acumulado:0.039621114730835
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[17]: 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.00075984001159668Tiempo acumulado:0.040380954742432
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[18]: 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.00055384635925293Tiempo acumulado:0.040934801101685
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[19]: 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.0019440650939941Tiempo acumulado:0.042878866195679
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[20]: 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.00053310394287109Tiempo acumulado:0.04341197013855
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[21]: 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.00058698654174805Tiempo acumulado:0.043998956680298
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[22]: 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.0010161399841309Tiempo acumulado:0.045015096664429
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[23]: 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.00052809715270996Tiempo acumulado:0.045543193817139
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[24]: 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.0010809898376465Tiempo acumulado:0.046624183654785
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[25]: 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 = 'subdomain_lang'
AND CFG.AMBITO IN ('mx_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00076794624328613Tiempo acumulado:0.047392129898071
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[26]: 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.00056982040405273Tiempo acumulado:0.047961950302124
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[27]: 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.00069403648376465Tiempo acumulado:0.048655986785889
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[28]: 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.0015628337860107Tiempo acumulado:0.050218820571899
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[29]: 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.00088810920715332Tiempo acumulado:0.051106929779053
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[30]: 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.00095796585083008Tiempo acumulado:0.052064895629883
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[31]: 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.00068020820617676Tiempo acumulado:0.05274510383606
(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_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.0016059875488281Tiempo acumulado:0.054351091384888
(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_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.00066018104553223Tiempo acumulado:0.05501127243042
(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_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.00049495697021484Tiempo acumulado:0.055506229400635
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[35]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = '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.00081682205200195Tiempo acumulado:0.056323051452637
(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_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.0019919872283936Tiempo acumulado:0.05831503868103
(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_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.00051712989807129Tiempo acumulado:0.058832168579102
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[38]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = '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.00053501129150391Tiempo acumulado:0.059367179870605
(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_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.0043981075286865Tiempo acumulado:0.063765287399292
(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_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.00055909156799316Tiempo acumulado:0.064324378967285
(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_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.0042951107025146Tiempo acumulado:0.0686194896698
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[42]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = '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.00070285797119141Tiempo acumulado:0.069322347640991
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[43]: 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.00062799453735352Tiempo acumulado:0.069950342178345
(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_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.00059700012207031Tiempo acumulado:0.070547342300415
(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_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.00081801414489746Tiempo acumulado:0.071365356445312
(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_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.0015089511871338Tiempo acumulado:0.072874307632446
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[47]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = '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.0031929016113281Tiempo acumulado:0.076067209243774
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[48]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.0004119873046875Tiempo acumulado:0.076479196548462
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[49]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.00035595893859863Tiempo acumulado:0.076835155487061
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[50]: SELECT sum(NUM_PRECIOS) AS NUM_PRECIOS, SUM(NUM_EMPRESAS) AS NUM_EMPRESAS,
SUM(NUM_OPINIONES) AS NUM_OPINIONES, SUM(NUM_COMPRAS) AS NUM_COMPRAS
FROM (
SELECT NUM_PRECIOS, NUM_EMPRESAS,NUM_OPINIONES,NUM_COMPRAS
FROM Yumping.LO_YUMPING_STATS
WHERE TYPE = 1
UNION ALL
SELECT NUM_PRECIOS, NUM_EMPRESAS,NUM_OPINIONES,NUM_COMPRAS
FROM Yumping_co_UK.LO_YUMPING_STATS
WHERE TYPE = 1
UNION ALL
SELECT NUM_PRECIOS, NUM_EMPRESAS,NUM_OPINIONES,NUM_COMPRAS
FROM Yumping_fr_FR.LO_YUMPING_STATS
WHERE TYPE = 1
UNION ALL
SELECT NUM_PRECIOS, NUM_EMPRESAS,NUM_OPINIONES,NUM_COMPRAS
FROM Yumping_it_IT.LO_YUMPING_STATS
WHERE TYPE = 1
UNION ALL
SELECT NUM_PRECIOS, NUM_EMPRESAS,NUM_OPINIONES,NUM_COMPRAS
FROM Yumping_mx_MX.LO_YUMPING_STATS
WHERE TYPE = 1
) AS stats;
Tiempo de la consulta:
0.0085761547088623Tiempo acumulado:0.085411310195923
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[51]: SELECT G.ID_GRUPO, G.DESC_GRUPO, G.URL URL_GRUPO
FROM LO_SECTORES SEC
INNER JOIN LO_GRUPOS G ON G.ID_GRUPO = SEC.ID_GRUPO
AND G.ID_TROPIC = 5
LEFT JOIN LO_VENTAS_STATS VS ON VS.ID_SECTOR = SEC.ID_SECTOR
WHERE G.ID_GRUPO != 8
AND G.ID_GRUPO != 10
GROUP BY SEC.ID_GRUPO
ORDER BY SUM(VS.N_VENTAS) DESC;
Tiempo de la consulta:
0.0075249671936035Tiempo acumulado:0.092936277389526
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[52]: SELECT SUM(SS.N_OFERTAS) AS OFERTAS
FROM LO_SECTORES_STATS SS
INNER JOIN LO_SECTORES SEC ON SS.ID_SECTOR = SEC.ID_SECTOR
WHERE (SS.N_OFERTAS > 0
AND SS.N_OFERTAS IS NOT NULL)
AND SEC.ID_GRUPO = 2
GROUP BY SEC.ID_GRUPO;
Tiempo de la consulta:
0.0011799335479736Tiempo acumulado:0.0941162109375
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[53]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SECI.URL URL_SECTOR, MOSTRAR_HOME
FROM LO_SECTORES SEC
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.ID_TROPIC = 5
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
INNER JOIN LO_SECTORES_STATS SS ON SS.ID_SECTOR = SECI.ID_SECTOR
AND (SS.N_OFERTAS > 0
AND SS.N_OFERTAS IS NOT NULL)
LEFT JOIN LO_VENTAS_STATS VS ON VS.ID_SECTOR = SEC.ID_SECTOR
WHERE SEC.ID_GRUPO = 2
AND MOSTRAR_HOME = 1
GROUP BY SEC.ID_SECTOR
ORDER BY MAX(VS.N_VENTAS) DESC;
Tiempo de la consulta:
0.0024540424346924Tiempo acumulado:0.096570253372192
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[54]: SELECT SUM(SS.N_OFERTAS) AS OFERTAS
FROM LO_SECTORES_STATS SS
INNER JOIN LO_SECTORES SEC ON SS.ID_SECTOR = SEC.ID_SECTOR
WHERE (SS.N_OFERTAS > 0
AND SS.N_OFERTAS IS NOT NULL)
AND SEC.ID_GRUPO = 4
GROUP BY SEC.ID_GRUPO;
Tiempo de la consulta:
0.0004730224609375Tiempo acumulado:0.09704327583313
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[55]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SECI.URL URL_SECTOR, MOSTRAR_HOME
FROM LO_SECTORES SEC
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.ID_TROPIC = 5
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
INNER JOIN LO_SECTORES_STATS SS ON SS.ID_SECTOR = SECI.ID_SECTOR
AND (SS.N_OFERTAS > 0
AND SS.N_OFERTAS IS NOT NULL)
LEFT JOIN LO_VENTAS_STATS VS ON VS.ID_SECTOR = SEC.ID_SECTOR
WHERE SEC.ID_GRUPO = 4
AND MOSTRAR_HOME = 1
GROUP BY SEC.ID_SECTOR
ORDER BY MAX(VS.N_VENTAS) DESC;
Tiempo de la consulta:
0.0015490055084229Tiempo acumulado:0.098592281341553
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[56]: SELECT SUM(SS.N_OFERTAS) AS OFERTAS
FROM LO_SECTORES_STATS SS
INNER JOIN LO_SECTORES SEC ON SS.ID_SECTOR = SEC.ID_SECTOR
WHERE (SS.N_OFERTAS > 0
AND SS.N_OFERTAS IS NOT NULL)
AND SEC.ID_GRUPO = 1
GROUP BY SEC.ID_GRUPO;
Tiempo de la consulta:
0.00053620338439941Tiempo acumulado:0.099128484725952
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[57]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SECI.URL URL_SECTOR, MOSTRAR_HOME
FROM LO_SECTORES SEC
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.ID_TROPIC = 5
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
INNER JOIN LO_SECTORES_STATS SS ON SS.ID_SECTOR = SECI.ID_SECTOR
AND (SS.N_OFERTAS > 0
AND SS.N_OFERTAS IS NOT NULL)
LEFT JOIN LO_VENTAS_STATS VS ON VS.ID_SECTOR = SEC.ID_SECTOR
WHERE SEC.ID_GRUPO = 1
AND MOSTRAR_HOME = 1
GROUP BY SEC.ID_SECTOR
ORDER BY MAX(VS.N_VENTAS) DESC;
Tiempo de la consulta:
0.0070669651031494Tiempo acumulado:0.1061954498291
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[58]: SELECT SUM(SS.N_OFERTAS) AS OFERTAS
FROM LO_SECTORES_STATS SS
INNER JOIN LO_SECTORES SEC ON SS.ID_SECTOR = SEC.ID_SECTOR
WHERE (SS.N_OFERTAS > 0
AND SS.N_OFERTAS IS NOT NULL)
AND SEC.ID_GRUPO = 6
GROUP BY SEC.ID_GRUPO;
Tiempo de la consulta:
0.00044989585876465Tiempo acumulado:0.10664534568787
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[59]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SECI.URL URL_SECTOR, MOSTRAR_HOME
FROM LO_SECTORES SEC
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.ID_TROPIC = 5
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
INNER JOIN LO_SECTORES_STATS SS ON SS.ID_SECTOR = SECI.ID_SECTOR
AND (SS.N_OFERTAS > 0
AND SS.N_OFERTAS IS NOT NULL)
LEFT JOIN LO_VENTAS_STATS VS ON VS.ID_SECTOR = SEC.ID_SECTOR
WHERE SEC.ID_GRUPO = 6
AND MOSTRAR_HOME = 1
GROUP BY SEC.ID_SECTOR
ORDER BY MAX(VS.N_VENTAS) DESC;
Tiempo de la consulta:
0.0013070106506348Tiempo acumulado:0.1079523563385
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[60]: SELECT SUM(SS.N_OFERTAS) AS OFERTAS
FROM LO_SECTORES_STATS SS
INNER JOIN LO_SECTORES SEC ON SS.ID_SECTOR = SEC.ID_SECTOR
WHERE (SS.N_OFERTAS > 0
AND SS.N_OFERTAS IS NOT NULL)
AND SEC.ID_GRUPO = 5
GROUP BY SEC.ID_GRUPO;
Tiempo de la consulta:
0.00041699409484863Tiempo acumulado:0.10836935043335
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[61]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SECI.URL URL_SECTOR, MOSTRAR_HOME
FROM LO_SECTORES SEC
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.ID_TROPIC = 5
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
INNER JOIN LO_SECTORES_STATS SS ON SS.ID_SECTOR = SECI.ID_SECTOR
AND (SS.N_OFERTAS > 0
AND SS.N_OFERTAS IS NOT NULL)
LEFT JOIN LO_VENTAS_STATS VS ON VS.ID_SECTOR = SEC.ID_SECTOR
WHERE SEC.ID_GRUPO = 5
AND MOSTRAR_HOME = 1
GROUP BY SEC.ID_SECTOR
ORDER BY MAX(VS.N_VENTAS) DESC;
Tiempo de la consulta:
0.00098800659179688Tiempo acumulado:0.10935735702515
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[62]: SELECT SUM(SS.N_OFERTAS) AS OFERTAS
FROM LO_SECTORES_STATS SS
INNER JOIN LO_SECTORES SEC ON SS.ID_SECTOR = SEC.ID_SECTOR
WHERE (SS.N_OFERTAS > 0
AND SS.N_OFERTAS IS NOT NULL)
AND SEC.ID_GRUPO = 7
GROUP BY SEC.ID_GRUPO;
Tiempo de la consulta:
0.00047898292541504Tiempo acumulado:0.10983633995056
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[63]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SECI.URL URL_SECTOR, MOSTRAR_HOME
FROM LO_SECTORES SEC
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.ID_TROPIC = 5
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
INNER JOIN LO_SECTORES_STATS SS ON SS.ID_SECTOR = SECI.ID_SECTOR
AND (SS.N_OFERTAS > 0
AND SS.N_OFERTAS IS NOT NULL)
LEFT JOIN LO_VENTAS_STATS VS ON VS.ID_SECTOR = SEC.ID_SECTOR
WHERE SEC.ID_GRUPO = 7
AND MOSTRAR_HOME = 1
GROUP BY SEC.ID_SECTOR
ORDER BY MAX(VS.N_VENTAS) DESC;
Tiempo de la consulta:
0.00082898139953613Tiempo acumulado:0.1106653213501
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[64]: SELECT SUM(SS.N_OFERTAS) AS OFERTAS
FROM LO_SECTORES_STATS SS
INNER JOIN LO_SECTORES SEC ON SS.ID_SECTOR = SEC.ID_SECTOR
WHERE (SS.N_OFERTAS > 0
AND SS.N_OFERTAS IS NOT NULL)
AND SEC.ID_GRUPO = 3
GROUP BY SEC.ID_GRUPO;
Tiempo de la consulta:
0.00064897537231445Tiempo acumulado:0.11131429672241
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[65]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SECI.URL URL_SECTOR, MOSTRAR_HOME
FROM LO_SECTORES SEC
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.ID_TROPIC = 5
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
INNER JOIN LO_SECTORES_STATS SS ON SS.ID_SECTOR = SECI.ID_SECTOR
AND (SS.N_OFERTAS > 0
AND SS.N_OFERTAS IS NOT NULL)
LEFT JOIN LO_VENTAS_STATS VS ON VS.ID_SECTOR = SEC.ID_SECTOR
WHERE SEC.ID_GRUPO = 3
AND MOSTRAR_HOME = 1
GROUP BY SEC.ID_SECTOR
ORDER BY MAX(VS.N_VENTAS) DESC;
Tiempo de la consulta:
0.0012249946594238Tiempo acumulado:0.11253929138184
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[66]: SELECT SUM(SS.N_OFERTAS) AS OFERTAS
FROM LO_SECTORES_STATS SS
INNER JOIN LO_SECTORES SEC ON SS.ID_SECTOR = SEC.ID_SECTOR
WHERE (SS.N_OFERTAS > 0
AND SS.N_OFERTAS IS NOT NULL)
AND SEC.ID_GRUPO = 9
GROUP BY SEC.ID_GRUPO;
Tiempo de la consulta:
0.0003960132598877Tiempo acumulado:0.11293530464172
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[67]: SELECT SEC.ID_SECTOR, SECI.DESC_SECTOR, SECI.URL URL_SECTOR, MOSTRAR_HOME
FROM LO_SECTORES SEC
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = SEC.ID_SECTOR
AND SECI.ID_TROPIC = 5
AND SECI.FK_ID_IDIOMA_SI18N = 'es'
INNER JOIN LO_SECTORES_STATS SS ON SS.ID_SECTOR = SECI.ID_SECTOR
AND (SS.N_OFERTAS > 0
AND SS.N_OFERTAS IS NOT NULL)
LEFT JOIN LO_VENTAS_STATS VS ON VS.ID_SECTOR = SEC.ID_SECTOR
WHERE SEC.ID_GRUPO = 9
AND MOSTRAR_HOME = 1
GROUP BY SEC.ID_SECTOR
ORDER BY MAX(VS.N_VENTAS) DESC;
Tiempo de la consulta:
0.00077199935913086Tiempo acumulado:0.11370730400085
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[68]: SELECT TEXTO_SINDEX, TEXTO_SINDEX2
FROM LO_SEO_INDEX
WHERE ID_TROPIC='5'
LIMIT 1;
Tiempo de la consulta:
0.00037980079650879Tiempo acumulado:0.11408710479736
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[69]: SELECT *
FROM LO_VENTAS_STATS
WHERE ID_TROPIC = 5;
Tiempo de la consulta:
0.00060701370239258Tiempo acumulado:0.11469411849976
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[70]: SELECT DISTINCT
ST.ID_SECTOR,
SECI.DESC_SECTOR,
SECI.URL AS URL_SECTOR,
IF (POI.ID_REGION, POI.ID_REGION, ST.ID_REGION) AS ID_REGION,
REI.DESC_REGION,
REI.URL AS URL_REGION,
ST.ID_REGION_ADM,
REA.DESC_REGION AS DESC_REGION_ADM,
REA.URL AS URL_REGION_ADM,
ST.ID_POBLACION,
POI.DESC_POBLACION AS DESC_POBLACION,
POI.URL_POBLACION AS URL_POBLACION,
ST.N_VENTAS
, ST.META_TITLE_ALT
FROM
LO_VENTAS_STATS ST
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = ST.ID_SECTOR
AND SECI.ID_TROPIC = '5'
LEFT JOIN LO_REGION_ADM1_I18N REA ON REA.ID_REGION_ADM1 = ST.ID_REGION_ADM
AND REA.IDIOMA = 'es'
LEFT JOIN LO_POBLACION_MX POI ON POI.ID_POBLACION = ST.ID_POBLACION
AND POI.IDIOMA = 'es'
LEFT JOIN LO_REGION_I18N REI ON REI.ID_REGION = IF(POI.ID_REGION, POI.ID_REGION,ST.ID_REGION)
AND REI.IDIOMA = 'es'
WHERE MOSTRAR = 1
AND (ST.ID_TROPIC = 0)
ORDER BY
FIJO DESC,
IF(ORDEN IS NOT NULL,ORDEN,100000) ASC,
ANUAL ASC,
N_VENTAS DESC
LIMIT 30;
Tiempo de la consulta:
0.0090458393096924Tiempo acumulado:0.12373995780945
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[71]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.ID_PAIS = 301
AND IDIOMA = 'es';
Tiempo de la consulta:
0.0009911060333252Tiempo acumulado:0.12473106384277
(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 = 'es_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('es_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00058293342590332Tiempo acumulado:0.12531399726868
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[73]: SELECT DISTINCT ST.ID_SECTOR, SECI.DESC_SECTOR, SECI.URL AS URL_SECTOR, IF (POI.ID_REGION, POI.ID_REGION, ST.ID_REGION) AS ID_REGION,
REI.DESC_REGION, REI.URL AS URL_REGION, ST.ID_REGION_ADM, REA.DESC_REGION AS DESC_REGION_ADM, REA.URL AS URL_REGION_ADM, ST.ID_POBLACION,
POI.DESC_POBLACION AS DESC_POBLACION, POI.URL_POBLACION AS URL_POBLACION, ST.N_VENTAS , ST.META_TITLE_ALT
FROM Prod_Yumping_es_ES.LO_VENTAS_STATS ST
INNER JOIN Prod_Yumping_es_ES.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = ST.ID_SECTOR
AND SECI.ID_TROPIC = '15'
LEFT JOIN Prod_Yumping_es_ES.LO_REGION_ADM1_I18N REA ON REA.ID_REGION_ADM1 = ST.ID_REGION_ADM
AND REA.IDIOMA = 'es'
LEFT JOIN Prod_Yumping_es_ES.LO_POBLACION_ES POI ON POI.ID_POBLACION = ST.ID_POBLACION
AND POI.IDIOMA = 'es'
LEFT JOIN Prod_Yumping_es_ES.LO_REGION_I18N REI ON REI.ID_REGION = IF(POI.ID_REGION, POI.ID_REGION,ST.ID_REGION)
AND REI.IDIOMA = 'es'
WHERE MOSTRAR = 1
AND (ST.ID_TROPIC = 0)
ORDER BY FIJO DESC, IF(ORDEN IS NOT NULL,ORDEN,100000) ASC, ANUAL ASC, N_VENTAS DESC
LIMIT 15;
Tiempo de la consulta:
0.017359018325806Tiempo acumulado:0.14267301559448
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[74]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.ID_PAIS = 28
AND IDIOMA = 'es';
Tiempo de la consulta:
0.0052280426025391Tiempo acumulado:0.14790105819702
(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 = 'pt_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0012969970703125Tiempo acumulado:0.14919805526733
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[76]: SELECT DISTINCT ST.ID_SECTOR, SECI.DESC_SECTOR, SECI.URL AS URL_SECTOR, IF (POI.ID_REGION, POI.ID_REGION, ST.ID_REGION) AS ID_REGION,
REI.DESC_REGION, REI.URL AS URL_REGION, ST.ID_REGION_ADM, REA.DESC_REGION AS DESC_REGION_ADM, REA.URL AS URL_REGION_ADM, ST.ID_POBLACION,
POI.DESC_POBLACION AS DESC_POBLACION, POI.URL_POBLACION AS URL_POBLACION, ST.N_VENTAS , ST.META_TITLE_ALT
FROM Prod_Yumping_pt_PT.LO_VENTAS_STATS ST
INNER JOIN Prod_Yumping_pt_PT.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = ST.ID_SECTOR
AND SECI.ID_TROPIC = '85'
LEFT JOIN Prod_Yumping_pt_PT.LO_REGION_ADM1_I18N REA ON REA.ID_REGION_ADM1 = ST.ID_REGION_ADM
AND REA.IDIOMA = 'es'
LEFT JOIN Prod_Yumping_pt_PT.LO_POBLACION_PT POI ON POI.ID_POBLACION = ST.ID_POBLACION
AND POI.IDIOMA = 'es'
LEFT JOIN Prod_Yumping_pt_PT.LO_REGION_I18N REI ON REI.ID_REGION = IF(POI.ID_REGION, POI.ID_REGION,ST.ID_REGION)
AND REI.IDIOMA = 'es'
WHERE MOSTRAR = 1
AND (ST.ID_TROPIC = 0)
ORDER BY FIJO DESC, IF(ORDEN IS NOT NULL,ORDEN,100000) ASC, ANUAL ASC, N_VENTAS DESC
LIMIT 15;
Tiempo de la consulta:
0.037256956100464Tiempo acumulado:0.1864550113678
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[77]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.ID_PAIS = 48
AND IDIOMA = 'es';
Tiempo de la consulta:
0.0011050701141357Tiempo acumulado:0.18756008148193
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[78]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('it_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0064260959625244Tiempo acumulado:0.19398617744446
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[79]: SELECT DISTINCT ST.ID_SECTOR, SECI.DESC_SECTOR, SECI.URL AS URL_SECTOR, IF (POI.ID_REGION, POI.ID_REGION, ST.ID_REGION) AS ID_REGION,
REI.DESC_REGION, REI.URL AS URL_REGION, ST.ID_REGION_ADM, REA.DESC_REGION AS DESC_REGION_ADM, REA.URL AS URL_REGION_ADM, ST.ID_POBLACION,
POI.DESC_POBLACION AS DESC_POBLACION, POI.URL_POBLACION AS URL_POBLACION, ST.N_VENTAS , ST.META_TITLE_ALT
FROM Prod_Yumping_it_IT.LO_VENTAS_STATS ST
INNER JOIN Prod_Yumping_it_IT.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = ST.ID_SECTOR
AND SECI.ID_TROPIC = '35'
LEFT JOIN Prod_Yumping_it_IT.LO_REGION_ADM1_I18N REA ON REA.ID_REGION_ADM1 = ST.ID_REGION_ADM
AND REA.IDIOMA = 'es'
LEFT JOIN Prod_Yumping_it_IT.LO_POBLACION_IT POI ON POI.ID_POBLACION = ST.ID_POBLACION
AND POI.IDIOMA = 'es'
LEFT JOIN Prod_Yumping_it_IT.LO_REGION_I18N REI ON REI.ID_REGION = IF(POI.ID_REGION, POI.ID_REGION,ST.ID_REGION)
AND REI.IDIOMA = 'es'
WHERE MOSTRAR = 1
AND (ST.ID_TROPIC = 0)
ORDER BY FIJO DESC, IF(ORDEN IS NOT NULL,ORDEN,100000) ASC, ANUAL ASC, N_VENTAS DESC
LIMIT 15;
Tiempo de la consulta:
0.055016040802002Tiempo acumulado:0.24900221824646
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[80]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.ID_PAIS = 29
AND IDIOMA = 'es';
Tiempo de la consulta:
0.00057101249694824Tiempo acumulado:0.24957323074341
(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 = 'fr_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('fr_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0017440319061279Tiempo acumulado:0.25131726264954
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[82]: SELECT DISTINCT ST.ID_SECTOR, SECI.DESC_SECTOR, SECI.URL AS URL_SECTOR, IF (POI.ID_REGION, POI.ID_REGION, ST.ID_REGION) AS ID_REGION,
REI.DESC_REGION, REI.URL AS URL_REGION, ST.ID_REGION_ADM, REA.DESC_REGION AS DESC_REGION_ADM, REA.URL AS URL_REGION_ADM, ST.ID_POBLACION,
POI.DESC_POBLACION AS DESC_POBLACION, POI.URL_POBLACION AS URL_POBLACION, ST.N_VENTAS , ST.META_TITLE_ALT
FROM Prod_Yumping_fr_FR.LO_VENTAS_STATS ST
INNER JOIN Prod_Yumping_fr_FR.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = ST.ID_SECTOR
AND SECI.ID_TROPIC = '45'
LEFT JOIN Prod_Yumping_fr_FR.LO_REGION_ADM1_I18N REA ON REA.ID_REGION_ADM1 = ST.ID_REGION_ADM
AND REA.IDIOMA = 'es'
LEFT JOIN Prod_Yumping_fr_FR.LO_POBLACION_FR POI ON POI.ID_POBLACION = ST.ID_POBLACION
AND POI.IDIOMA = 'es'
LEFT JOIN Prod_Yumping_fr_FR.LO_REGION_I18N REI ON REI.ID_REGION = IF(POI.ID_REGION, POI.ID_REGION,ST.ID_REGION)
AND REI.IDIOMA = 'es'
WHERE MOSTRAR = 1
AND (ST.ID_TROPIC = 0)
ORDER BY FIJO DESC, IF(ORDEN IS NOT NULL,ORDEN,100000) ASC, ANUAL ASC, N_VENTAS DESC
LIMIT 15;
Tiempo de la consulta:
0.032646894454956Tiempo acumulado:0.28396415710449
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[83]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.ID_PAIS = 64
AND IDIOMA = 'es';
Tiempo de la consulta:
0.00036406517028809Tiempo acumulado:0.28432822227478
(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 = 'gb_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('gb_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00055885314941406Tiempo acumulado:0.28488707542419
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[85]: SELECT DISTINCT ST.ID_SECTOR, SECI.DESC_SECTOR, SECI.URL AS URL_SECTOR, IF (POI.ID_REGION, POI.ID_REGION, ST.ID_REGION) AS ID_REGION,
REI.DESC_REGION, REI.URL AS URL_REGION, ST.ID_REGION_ADM, REA.DESC_REGION AS DESC_REGION_ADM, REA.URL AS URL_REGION_ADM, ST.ID_POBLACION,
POI.DESC_POBLACION AS DESC_POBLACION, POI.URL_POBLACION AS URL_POBLACION, ST.N_VENTAS , ST.META_TITLE_ALT
FROM Prod_Yumping_co_UK.LO_VENTAS_STATS ST
INNER JOIN Prod_Yumping_co_UK.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = ST.ID_SECTOR
AND SECI.ID_TROPIC = '25'
LEFT JOIN Prod_Yumping_co_UK.LO_REGION_ADM1_I18N REA ON REA.ID_REGION_ADM1 = ST.ID_REGION_ADM
AND REA.IDIOMA = 'es'
LEFT JOIN Prod_Yumping_co_UK.LO_POBLACION_GB POI ON POI.ID_POBLACION = ST.ID_POBLACION
AND POI.IDIOMA = 'es'
LEFT JOIN Prod_Yumping_co_UK.LO_REGION_I18N REI ON REI.ID_REGION = IF(POI.ID_REGION, POI.ID_REGION,ST.ID_REGION)
AND REI.IDIOMA = 'es'
WHERE MOSTRAR = 1
AND (ST.ID_TROPIC = 0)
ORDER BY FIJO DESC, IF(ORDEN IS NOT NULL,ORDEN,100000) ASC, ANUAL ASC, N_VENTAS DESC
LIMIT 15;
Tiempo de la consulta:
0.018999814987183Tiempo acumulado:0.30388689041138
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[86]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.ID_PAIS = 247
AND IDIOMA = 'es';
Tiempo de la consulta:
0.0003669261932373Tiempo acumulado:0.30425381660461
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[87]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.ID_PAIS = 301
AND IDIOMA = 'es';
Tiempo de la consulta:
0.00032305717468262Tiempo acumulado:0.3045768737793
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[88]: SELECT ID_REGION_ADM1
FROM LO_REGION RE
GROUP BY ID_REGION_ADM1
HAVING count(*) > 1;
Tiempo de la consulta:
0.00085806846618652Tiempo acumulado:0.30543494224548
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[89]: SELECT ID_REGION, DESC_REGION, URL_REGION, N_OFERTAS
FROM (
SELECT REI.ID_REGION, REI.DESC_REGION, REI.URL AS URL_REGION, RS.N_OFERTAS
FROM Prod_Yumping_mx_MX.LO_REGION_STATS RS
INNER JOIN Prod_Yumping_mx_MX.LO_REGION RE ON RE.ID_REGION = RS.ID_REGION
AND RE.ID_PAIS = 301
INNER JOIN Prod_Yumping_mx_MX.LO_REGION_I18N REI ON REI.ID_REGION = RS.ID_REGION
AND REI.IDIOMA = 'es'
WHERE /*RS.N_OFERTAS >= 15
AND*/ RS.ID_SECTOR IS NOT NULL
AND RS.ID_SECTOR != 0
GROUP BY REI.ID_REGION
UNION ALL
SELECT REA.ID_REGION_ADM1 AS ID_REGION, REA.DESC_REGION, REA.URL AS URL_REGION, RAS.N_OFERTAS
FROM Prod_Yumping_mx_MX.LO_REGION_ADM1_STATS RAS
INNER JOIN Prod_Yumping_mx_MX.LO_REGION RE ON RE.ID_REGION_ADM1 = RAS.ID_REGION_ADM1
AND RE.ID_PAIS = 301
INNER JOIN Prod_Yumping_mx_MX.LO_REGION_ADM1_I18N REA ON REA.ID_REGION_ADM1 = RAS.ID_REGION_ADM1
AND REA.IDIOMA = 'es'
WHERE /*RAS.N_OFERTAS >= 15
AND*/ RAS.ID_SECTOR IS NOT NULL
AND RAS.ID_SECTOR != 0
AND REA.ID_REGION_ADM1 in ( 212)
GROUP BY REA.ID_REGION_ADM1
) AS REGIONES
ORDER BY N_OFERTAS DESC
LIMIT 20;
Tiempo de la consulta:
0.01228404045105Tiempo acumulado:0.31771898269653
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[90]: SELECT PAI.ID_PAIS, PAI.DESC_PAIS, PAI.URL URL_PAIS
FROM LO_PAIS PA, LO_PAIS_I18N PAI
WHERE PAI.ID_PAIS=PA.ID_PAIS
AND PAI.IDIOMA='es'
AND PAI.ID_PAIS='301'
ORDER BY DESC_PAIS;
Tiempo de la consulta:
0.0019681453704834Tiempo acumulado:0.31968712806702
(Prod_Yumping_mx_MX) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[91]: SELECT *
FROM LO_EQUIPO_EDITORIAL EE
WHERE EE.ID_TROPIC = 5;
Tiempo de la consulta:
0.00088691711425781Tiempo acumulado:0.32057404518127
