yu-front-06.localdomain (172.30.2.194:443)
prod.yumping.com
/index.php
BBDD->Prod_Yumping_it_IT
AMBITO->it
AMBITO_AJAX->it
AMBITO_AJAX COOKIE->mx_it
locale LO_CONFIG->it_IT
locale php->it_IT
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->it
Total queries: 86
Tiempo total: 0.32594656944275
(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', 'it')
ORDER BY CFG.NAME;
Tiempo de la consulta:
0.0097179412841797Tiempo acumulado:0.0097179412841797
(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.001662015914917Tiempo acumulado:0.011379957199097
(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', 'it')
ORDER BY CFG.NAME;
Tiempo de la consulta:
0.012601137161255Tiempo acumulado:0.023981094360352
(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.0060851573944092Tiempo acumulado:0.030066251754761
(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.00072383880615234Tiempo acumulado:0.030790090560913
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[6]: SELECT `PARAM`, `TYPE`, `CHECK`
FROM Yumping_proc_comun.LO_CHECK_PARAMETERS
WHERE PARAM = 'ambito_lang';
Tiempo de la consulta:
0.0020129680633545Tiempo acumulado:0.032803058624268
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[7]: SELECT OLD_URL, NEW_URL
FROM LO_URL_301 U
WHERE U.OLD_URL = '/it';
Tiempo de la consulta:
0.00084400177001953Tiempo acumulado:0.033647060394287
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[8]: SELECT *
FROM LO_SEO_INDEX SI
WHERE ID_TROPIC = 3;
Tiempo de la consulta:
0.0033509731292725Tiempo acumulado:0.03699803352356
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[9]: 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.0033938884735107Tiempo acumulado:0.04039192199707
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[10]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'it_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00055503845214844Tiempo acumulado:0.040946960449219
(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 = 'it_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00059294700622559Tiempo acumulado:0.041539907455444
(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 = 'it_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00051307678222656Tiempo acumulado:0.042052984237671
(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 = 'it_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049495697021484Tiempo acumulado:0.042547941207886
(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 = 'it_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('it_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00051617622375488Tiempo acumulado:0.043064117431641
(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 = 'it_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0005638599395752Tiempo acumulado:0.043627977371216
(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 = 'it_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00051593780517578Tiempo acumulado:0.044143915176392
(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 = 'it_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain'
AND CFG.AMBITO IN ('it_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00053000450134277Tiempo acumulado:0.044673919677734
(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 = 'it_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00056004524230957Tiempo acumulado:0.045233964920044
(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 = 'it_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00052809715270996Tiempo acumulado:0.045762062072754
(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 = 'it_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('it_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00048708915710449Tiempo acumulado:0.046249151229858
(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 = 'it_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00053977966308594Tiempo acumulado:0.046788930892944
(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 = 'it_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0018610954284668Tiempo acumulado:0.048650026321411
(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 = 'it_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00053191184997559Tiempo acumulado:0.049181938171387
(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 = 'it_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.001716136932373Tiempo acumulado:0.05089807510376
(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 = 'it_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('it_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00081706047058105Tiempo acumulado:0.051715135574341
(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 = 'it_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0058639049530029Tiempo acumulado:0.057579040527344
(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 = 'it_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00052595138549805Tiempo acumulado:0.058104991912842
(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 = 'it_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.010951995849609Tiempo acumulado:0.069056987762451
(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 = 'it_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00051212310791016Tiempo acumulado:0.069569110870361
(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 = 'it_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('it_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00052714347839355Tiempo acumulado:0.070096254348755
(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 = 'it_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050187110900879Tiempo acumulado:0.070598125457764
(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 = 'it_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0008089542388916Tiempo acumulado:0.071407079696655
(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 = 'it_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00066089630126953Tiempo acumulado:0.072067975997925
(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 = 'it_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00064301490783691Tiempo acumulado:0.072710990905762
(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 = 'it_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('it_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00057697296142578Tiempo acumulado:0.073287963867188
(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 = 'it_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00047588348388672Tiempo acumulado:0.073763847351074
(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 = 'it_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046277046203613Tiempo acumulado:0.07422661781311
(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 = 'it_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00097393989562988Tiempo acumulado:0.07520055770874
(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 = 'it_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00072002410888672Tiempo acumulado:0.075920581817627
(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 = 'it_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('it_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00056910514831543Tiempo acumulado:0.076489686965942
(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 = 'it_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0006871223449707Tiempo acumulado:0.077176809310913
(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 = 'it_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00056695938110352Tiempo acumulado:0.077743768692017
(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 = 'it_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004889965057373Tiempo acumulado:0.078232765197754
(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 = 'it_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050592422485352Tiempo acumulado:0.078738689422607
(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 = 'it_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('it_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050020217895508Tiempo acumulado:0.079238891601562
(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 = 'it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050711631774902Tiempo acumulado:0.079746007919312
(Prod_Yumping_es_ES) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[47]: SELECT CURRENCY_PRINCIPAL, CURRENCIES_DISPONIBLE
FROM LO_CURRENCIES_AVAILABLES
WHERE ACTIVE = 1;
Tiempo de la consulta:
0.0011680126190186Tiempo acumulado:0.08091402053833
(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.0011990070343018Tiempo acumulado:0.082113027572632
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[49]: 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.014318943023682Tiempo acumulado:0.096431970596313
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[50]: 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 = 3
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.012443065643311Tiempo acumulado:0.10887503623962
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[51]: 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.0014128684997559Tiempo acumulado:0.11028790473938
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[52]: 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 = 3
AND SECI.FK_ID_IDIOMA_SI18N = 'it'
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.017397165298462Tiempo acumulado:0.12768507003784
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[53]: 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.0061259269714355Tiempo acumulado:0.13381099700928
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[54]: 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 = 3
AND SECI.FK_ID_IDIOMA_SI18N = 'it'
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.00382399559021Tiempo acumulado:0.13763499259949
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[55]: 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.0009758472442627Tiempo acumulado:0.13861083984375
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[56]: 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 = 3
AND SECI.FK_ID_IDIOMA_SI18N = 'it'
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.00242018699646Tiempo acumulado:0.14103102684021
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[57]: 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.0045359134674072Tiempo acumulado:0.14556694030762
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[58]: 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 = 3
AND SECI.FK_ID_IDIOMA_SI18N = 'it'
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.0023670196533203Tiempo acumulado:0.14793395996094
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[59]: 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.0014607906341553Tiempo acumulado:0.14939475059509
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[60]: 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 = 3
AND SECI.FK_ID_IDIOMA_SI18N = 'it'
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.0015020370483398Tiempo acumulado:0.15089678764343
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[61]: 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.00060796737670898Tiempo acumulado:0.15150475502014
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[62]: 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 = 3
AND SECI.FK_ID_IDIOMA_SI18N = 'it'
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.001474142074585Tiempo acumulado:0.15297889709473
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[63]: SELECT TEXTO_SINDEX, TEXTO_SINDEX2
FROM LO_SEO_INDEX
WHERE ID_TROPIC='3'
LIMIT 1;
Tiempo de la consulta:
0.00042891502380371Tiempo acumulado:0.15340781211853
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[64]: SELECT *
FROM LO_VENTAS_STATS
WHERE ID_TROPIC = 3;
Tiempo de la consulta:
0.00091099739074707Tiempo acumulado:0.15431880950928
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[65]: 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 = '3'
LEFT JOIN LO_REGION_ADM1_I18N REA ON REA.ID_REGION_ADM1 = ST.ID_REGION_ADM
AND REA.IDIOMA = 'it'
LEFT JOIN LO_POBLACION_IT POI ON POI.ID_POBLACION = ST.ID_POBLACION
AND POI.IDIOMA = 'it'
LEFT JOIN LO_REGION_I18N REI ON REI.ID_REGION = IF(POI.ID_REGION, POI.ID_REGION,ST.ID_REGION)
AND REI.IDIOMA = 'it'
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.018796920776367Tiempo acumulado:0.17311573028564
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[66]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.ID_PAIS = 29
AND IDIOMA = 'it';
Tiempo de la consulta:
0.0012760162353516Tiempo acumulado:0.174391746521
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[67]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'es_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('es_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050806999206543Tiempo acumulado:0.17489981651306
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[68]: 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 = '13'
LEFT JOIN Prod_Yumping_es_ES.LO_REGION_ADM1_I18N REA ON REA.ID_REGION_ADM1 = ST.ID_REGION_ADM
AND REA.IDIOMA = 'it'
LEFT JOIN Prod_Yumping_es_ES.LO_POBLACION_ES POI ON POI.ID_POBLACION = ST.ID_POBLACION
AND POI.IDIOMA = 'it'
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 = 'it'
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.016031980514526Tiempo acumulado:0.19093179702759
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[69]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.ID_PAIS = 28
AND IDIOMA = 'it';
Tiempo de la consulta:
0.00036191940307617Tiempo acumulado:0.19129371643066
(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 = 'pt_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00067400932312012Tiempo acumulado:0.19196772575378
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[71]: 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 = '83'
LEFT JOIN Prod_Yumping_pt_PT.LO_REGION_ADM1_I18N REA ON REA.ID_REGION_ADM1 = ST.ID_REGION_ADM
AND REA.IDIOMA = 'it'
LEFT JOIN Prod_Yumping_pt_PT.LO_POBLACION_PT POI ON POI.ID_POBLACION = ST.ID_POBLACION
AND POI.IDIOMA = 'it'
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 = 'it'
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.019753932952881Tiempo acumulado:0.21172165870667
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[72]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.ID_PAIS = 48
AND IDIOMA = 'it';
Tiempo de la consulta:
0.00040602684020996Tiempo acumulado:0.21212768554688
(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 = 'fr_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('fr_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049519538879395Tiempo acumulado:0.21262288093567
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[74]: 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 = '43'
LEFT JOIN Prod_Yumping_fr_FR.LO_REGION_ADM1_I18N REA ON REA.ID_REGION_ADM1 = ST.ID_REGION_ADM
AND REA.IDIOMA = 'it'
LEFT JOIN Prod_Yumping_fr_FR.LO_POBLACION_FR POI ON POI.ID_POBLACION = ST.ID_POBLACION
AND POI.IDIOMA = 'it'
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 = 'it'
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.030556917190552Tiempo acumulado:0.24317979812622
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[75]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.ID_PAIS = 64
AND IDIOMA = 'it';
Tiempo de la consulta:
0.00049710273742676Tiempo acumulado:0.24367690086365
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[76]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('gb_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00051188468933105Tiempo acumulado:0.24418878555298
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[77]: 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 = '23'
LEFT JOIN Prod_Yumping_co_UK.LO_REGION_ADM1_I18N REA ON REA.ID_REGION_ADM1 = ST.ID_REGION_ADM
AND REA.IDIOMA = 'it'
LEFT JOIN Prod_Yumping_co_UK.LO_POBLACION_GB POI ON POI.ID_POBLACION = ST.ID_POBLACION
AND POI.IDIOMA = 'it'
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 = 'it'
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.027837038040161Tiempo acumulado:0.27202582359314
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[78]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.ID_PAIS = 247
AND IDIOMA = 'it';
Tiempo de la consulta:
0.0019898414611816Tiempo acumulado:0.27401566505432
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[79]: 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.00051712989807129Tiempo acumulado:0.27453279495239
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[80]: 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_mx_MX.LO_VENTAS_STATS ST
INNER JOIN Prod_Yumping_mx_MX.LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = ST.ID_SECTOR
AND SECI.ID_TROPIC = '53'
LEFT JOIN Prod_Yumping_mx_MX.LO_REGION_ADM1_I18N REA ON REA.ID_REGION_ADM1 = ST.ID_REGION_ADM
AND REA.IDIOMA = 'it'
LEFT JOIN Prod_Yumping_mx_MX.LO_POBLACION_MX POI ON POI.ID_POBLACION = ST.ID_POBLACION
AND POI.IDIOMA = 'it'
LEFT JOIN Prod_Yumping_mx_MX.LO_REGION_I18N REI ON REI.ID_REGION = IF(POI.ID_REGION, POI.ID_REGION,ST.ID_REGION)
AND REI.IDIOMA = 'it'
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.015645027160645Tiempo acumulado:0.29017782211304
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[81]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.ID_PAIS = 301
AND IDIOMA = 'it';
Tiempo de la consulta:
0.00038003921508789Tiempo acumulado:0.29055786132812
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[82]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.ID_PAIS = 29
AND IDIOMA = 'it';
Tiempo de la consulta:
0.00037789344787598Tiempo acumulado:0.290935754776
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[83]: SELECT ID_REGION_ADM1
FROM LO_REGION RE
GROUP BY ID_REGION_ADM1
HAVING count(*) > 1;
Tiempo de la consulta:
0.00096702575683594Tiempo acumulado:0.29190278053284
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[84]: 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_it_IT.LO_REGION_STATS RS
INNER JOIN Prod_Yumping_it_IT.LO_REGION RE ON RE.ID_REGION = RS.ID_REGION
AND RE.ID_PAIS = 29
INNER JOIN Prod_Yumping_it_IT.LO_REGION_I18N REI ON REI.ID_REGION = RS.ID_REGION
AND REI.IDIOMA = 'it'
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_it_IT.LO_REGION_ADM1_STATS RAS
INNER JOIN Prod_Yumping_it_IT.LO_REGION RE ON RE.ID_REGION_ADM1 = RAS.ID_REGION_ADM1
AND RE.ID_PAIS = 29
INNER JOIN Prod_Yumping_it_IT.LO_REGION_ADM1_I18N REA ON REA.ID_REGION_ADM1 = RAS.ID_REGION_ADM1
AND REA.IDIOMA = 'it'
WHERE /*RAS.N_OFERTAS >= 15
AND*/ RAS.ID_SECTOR IS NOT NULL
AND RAS.ID_SECTOR != 0
AND REA.ID_REGION_ADM1 in ( 12,9,17,20,6,8,5,16,18,10,7,1,11,4,13,2,3,15,14)
GROUP BY REA.ID_REGION_ADM1
) AS REGIONES
ORDER BY N_OFERTAS DESC
LIMIT 20;
Tiempo de la consulta:
0.028756856918335Tiempo acumulado:0.32065963745117
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[85]: 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='it'
AND PAI.ID_PAIS='29'
ORDER BY DESC_PAIS;
Tiempo de la consulta:
0.004749059677124Tiempo acumulado:0.3254086971283
(Prod_Yumping_it_IT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[86]: SELECT *
FROM LO_EQUIPO_EDITORIAL EE
WHERE EE.ID_TROPIC = 3;
Tiempo de la consulta:
0.00053787231445312Tiempo acumulado:0.32594656944275
