yu-front-06.localdomain (172.30.2.194:443)
prod.yumping.com
/index.php
BBDD->Prod_Yumping_pt_PT
AMBITO->pt
AMBITO_AJAX->pt
AMBITO_AJAX COOKIE->mx_es
locale LO_CONFIG->pt_PT
locale php->pt_PT
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->pt
Total queries: 88
Tiempo total: 0.52820634841919
(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', 'pt')
ORDER BY CFG.NAME;
Tiempo de la consulta:
0.010278940200806Tiempo acumulado:0.010278940200806
(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.0023510456085205Tiempo acumulado:0.012629985809326
(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', 'pt')
ORDER BY CFG.NAME;
Tiempo de la consulta:
0.012620210647583Tiempo acumulado:0.025250196456909
(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.011115074157715Tiempo acumulado:0.036365270614624
(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.0014669895172119Tiempo acumulado:0.037832260131836
(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.0010581016540527Tiempo acumulado:0.038890361785889
(Prod_Yumping_pt_PT) (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 = '/pt';
Tiempo de la consulta:
0.0011849403381348Tiempo acumulado:0.040075302124023
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[8]: SELECT *
FROM LO_SEO_INDEX SI
WHERE ID_TROPIC = 8;
Tiempo de la consulta:
0.0054278373718262Tiempo acumulado:0.04550313949585
(Prod_Yumping_pt_PT) (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.0046379566192627Tiempo acumulado:0.050141096115112
(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 = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00055718421936035Tiempo acumulado:0.050698280334473
(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 = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00053691864013672Tiempo acumulado:0.051235198974609
(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 = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045108795166016Tiempo acumulado:0.05168628692627
(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 = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00055599212646484Tiempo acumulado:0.052242279052734
(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 = 'pt_en', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('pt_en', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045490264892578Tiempo acumulado:0.05269718170166
(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 = 'pt_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046396255493164Tiempo acumulado:0.053161144256592
(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 = 'pt_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046300888061523Tiempo acumulado:0.053624153137207
(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 = 'pt_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045394897460938Tiempo acumulado:0.054078102111816
(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 = 'pt_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00043702125549316Tiempo acumulado:0.05451512336731
(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 = 'pt_it', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('pt_it', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0016179084777832Tiempo acumulado:0.056133031845093
(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 = 'pt_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00056004524230957Tiempo acumulado:0.056693077087402
(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 = 'pt_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00052094459533691Tiempo acumulado:0.057214021682739
(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 = 'pt_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00058102607727051Tiempo acumulado:0.05779504776001
(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 = 'pt_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00046896934509277Tiempo acumulado:0.058264017105103
(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 = 'pt_fr', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('pt_fr', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00048494338989258Tiempo acumulado:0.058748960494995
(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 = 'pt_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0012609958648682Tiempo acumulado:0.060009956359863
(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 = 'pt_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00050902366638184Tiempo acumulado:0.060518980026245
(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 = 'pt_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain'
AND CFG.AMBITO IN ('pt_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004432201385498Tiempo acumulado:0.060962200164795
(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 = 'pt_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00045299530029297Tiempo acumulado:0.061415195465088
(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 = 'pt_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00053811073303223Tiempo acumulado:0.06195330619812
(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 = 'pt_es', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('pt_es', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0012490749359131Tiempo acumulado:0.063202381134033
(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 = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0004570484161377Tiempo acumulado:0.063659429550171
(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 = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00049495697021484Tiempo acumulado:0.064154386520386
(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 = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00059914588928223Tiempo acumulado:0.064753532409668
(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 = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00052595138549805Tiempo acumulado:0.065279483795166
(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 = 'pt_ch', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('pt_ch', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00071811676025391Tiempo acumulado:0.06599760055542
(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 = 'pt_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00058698654174805Tiempo acumulado:0.066584587097168
(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 = 'pt_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0047190189361572Tiempo acumulado:0.071303606033325
(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 = 'pt_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00054812431335449Tiempo acumulado:0.07185173034668
(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 = 'pt_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00054788589477539Tiempo acumulado:0.072399616241455
(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 = 'pt_de', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('pt_de', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00319504737854Tiempo acumulado:0.075594663619995
(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 = 'pt_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0067639350891113Tiempo acumulado:0.082358598709106
(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 = 'pt_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00057697296142578Tiempo acumulado:0.082935571670532
(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 = 'pt_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00055694580078125Tiempo acumulado:0.083492517471313
(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 = 'pt_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00058388710021973Tiempo acumulado:0.084076404571533
(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 = 'pt_mx', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'subdomain_lang'
AND CFG.AMBITO IN ('pt_mx', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0010550022125244Tiempo acumulado:0.085131406784058
(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 = 'pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_href_lang'
AND CFG.AMBITO IN ('pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.003169059753418Tiempo acumulado:0.088300466537476
(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.00046801567077637Tiempo acumulado:0.088768482208252
(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.0005030632019043Tiempo acumulado:0.089271545410156
(Prod_Yumping_pt_PT) (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.00084495544433594Tiempo acumulado:0.090116500854492
(Prod_Yumping_pt_PT) (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 = 8
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.034585952758789Tiempo acumulado:0.12470245361328
(Prod_Yumping_pt_PT) (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 = 1
GROUP BY SEC.ID_GRUPO;
Tiempo de la consulta:
0.0030369758605957Tiempo acumulado:0.12773942947388
(Prod_Yumping_pt_PT) (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 = 8
AND SECI.FK_ID_IDIOMA_SI18N = 'pt'
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.017865180969238Tiempo acumulado:0.14560461044312
(Prod_Yumping_pt_PT) (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.0010030269622803Tiempo acumulado:0.1466076374054
(Prod_Yumping_pt_PT) (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 = 8
AND SECI.FK_ID_IDIOMA_SI18N = 'pt'
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.0039160251617432Tiempo acumulado:0.15052366256714
(Prod_Yumping_pt_PT) (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 = 4
GROUP BY SEC.ID_GRUPO;
Tiempo de la consulta:
0.0018000602722168Tiempo acumulado:0.15232372283936
(Prod_Yumping_pt_PT) (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 = 8
AND SECI.FK_ID_IDIOMA_SI18N = 'pt'
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.0041680335998535Tiempo acumulado:0.15649175643921
(Prod_Yumping_pt_PT) (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.0026111602783203Tiempo acumulado:0.15910291671753
(Prod_Yumping_pt_PT) (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 = 8
AND SECI.FK_ID_IDIOMA_SI18N = 'pt'
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.0034110546112061Tiempo acumulado:0.16251397132874
(Prod_Yumping_pt_PT) (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.0099818706512451Tiempo acumulado:0.17249584197998
(Prod_Yumping_pt_PT) (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 = 8
AND SECI.FK_ID_IDIOMA_SI18N = 'pt'
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.0041069984436035Tiempo acumulado:0.17660284042358
(Prod_Yumping_pt_PT) (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.0053789615631104Tiempo acumulado:0.18198180198669
(Prod_Yumping_pt_PT) (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 = 8
AND SECI.FK_ID_IDIOMA_SI18N = 'pt'
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.0026211738586426Tiempo acumulado:0.18460297584534
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[63]: 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.0071611404418945Tiempo acumulado:0.19176411628723
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[64]: 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 = 8
AND SECI.FK_ID_IDIOMA_SI18N = 'pt'
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.0028820037841797Tiempo acumulado:0.19464612007141
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[65]: SELECT TEXTO_SINDEX, TEXTO_SINDEX2
FROM LO_SEO_INDEX
WHERE ID_TROPIC='8'
LIMIT 1;
Tiempo de la consulta:
0.00057697296142578Tiempo acumulado:0.19522309303284
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[66]: SELECT *
FROM LO_VENTAS_STATS
WHERE ID_TROPIC = 8;
Tiempo de la consulta:
0.0067310333251953Tiempo acumulado:0.20195412635803
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[67]: 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 = '8'
LEFT JOIN LO_REGION_ADM1_I18N REA ON REA.ID_REGION_ADM1 = ST.ID_REGION_ADM
AND REA.IDIOMA = 'pt'
LEFT JOIN LO_POBLACION_PT POI ON POI.ID_POBLACION = ST.ID_POBLACION
AND POI.IDIOMA = 'pt'
LEFT JOIN LO_REGION_I18N REI ON REI.ID_REGION = IF(POI.ID_REGION, POI.ID_REGION,ST.ID_REGION)
AND REI.IDIOMA = 'pt'
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.034171104431152Tiempo acumulado:0.23612523078918
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[68]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.ID_PAIS = 48
AND IDIOMA = 'pt';
Tiempo de la consulta:
0.0049829483032227Tiempo acumulado:0.24110817909241
(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 = 'es_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('es_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0010161399841309Tiempo acumulado:0.24212431907654
(Prod_Yumping_pt_PT) (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 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 = '18'
LEFT JOIN Prod_Yumping_es_ES.LO_REGION_ADM1_I18N REA ON REA.ID_REGION_ADM1 = ST.ID_REGION_ADM
AND REA.IDIOMA = 'pt'
LEFT JOIN Prod_Yumping_es_ES.LO_POBLACION_ES POI ON POI.ID_POBLACION = ST.ID_POBLACION
AND POI.IDIOMA = 'pt'
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 = 'pt'
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.035165071487427Tiempo acumulado:0.27728939056396
(Prod_Yumping_pt_PT) (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 = 28
AND IDIOMA = 'pt';
Tiempo de la consulta:
0.0045559406280518Tiempo acumulado:0.28184533119202
(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 = 'it_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('it_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0025079250335693Tiempo acumulado:0.28435325622559
(Prod_Yumping_pt_PT) (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_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 = '38'
LEFT JOIN Prod_Yumping_it_IT.LO_REGION_ADM1_I18N REA ON REA.ID_REGION_ADM1 = ST.ID_REGION_ADM
AND REA.IDIOMA = 'pt'
LEFT JOIN Prod_Yumping_it_IT.LO_POBLACION_IT POI ON POI.ID_POBLACION = ST.ID_POBLACION
AND POI.IDIOMA = 'pt'
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 = 'pt'
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.057977914810181Tiempo acumulado:0.34233117103577
(Prod_Yumping_pt_PT) (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 = 29
AND IDIOMA = 'pt';
Tiempo de la consulta:
0.0063581466674805Tiempo acumulado:0.34868931770325
(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 = 'fr_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('fr_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00060296058654785Tiempo acumulado:0.34929227828979
(Prod_Yumping_pt_PT) (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_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 = '48'
LEFT JOIN Prod_Yumping_fr_FR.LO_REGION_ADM1_I18N REA ON REA.ID_REGION_ADM1 = ST.ID_REGION_ADM
AND REA.IDIOMA = 'pt'
LEFT JOIN Prod_Yumping_fr_FR.LO_POBLACION_FR POI ON POI.ID_POBLACION = ST.ID_POBLACION
AND POI.IDIOMA = 'pt'
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 = 'pt'
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.056892871856689Tiempo acumulado:0.40618515014648
(Prod_Yumping_pt_PT) (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 = 64
AND IDIOMA = 'pt';
Tiempo de la consulta:
0.0030121803283691Tiempo acumulado:0.40919733047485
(Yumping_proc_comun) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingreadSQL[78]: SELECT IF (CFG.VALUE_PROD IS NOT NULL
AND CFG.VALUE_PROD != '',CFG.VALUE_PROD, CFG.VALUE) AS RESULT, IF (CFG.AMBITO = 'gb_pt', 1, 0) AS PESO
FROM Yumping_proc_comun.LO_CONFIG CFG
WHERE CFG.NAME = 'Request_id_tropic_trad'
AND CFG.AMBITO IN ('gb_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.00059914588928223Tiempo acumulado:0.40979647636414
(Prod_Yumping_pt_PT) (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_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 = '28'
LEFT JOIN Prod_Yumping_co_UK.LO_REGION_ADM1_I18N REA ON REA.ID_REGION_ADM1 = ST.ID_REGION_ADM
AND REA.IDIOMA = 'pt'
LEFT JOIN Prod_Yumping_co_UK.LO_POBLACION_GB POI ON POI.ID_POBLACION = ST.ID_POBLACION
AND POI.IDIOMA = 'pt'
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 = 'pt'
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.023396968841553Tiempo acumulado:0.43319344520569
(Prod_Yumping_pt_PT) (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 = 247
AND IDIOMA = 'pt';
Tiempo de la consulta:
0.0059189796447754Tiempo acumulado:0.43911242485046
(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_id_tropic_trad'
AND CFG.AMBITO IN ('mx_pt', 'global')
ORDER BY PESO DESC
LIMIT 1;
Tiempo de la consulta:
0.0015339851379395Tiempo acumulado:0.4406464099884
(Prod_Yumping_pt_PT) (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_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 = '58'
LEFT JOIN Prod_Yumping_mx_MX.LO_REGION_ADM1_I18N REA ON REA.ID_REGION_ADM1 = ST.ID_REGION_ADM
AND REA.IDIOMA = 'pt'
LEFT JOIN Prod_Yumping_mx_MX.LO_POBLACION_MX POI ON POI.ID_POBLACION = ST.ID_POBLACION
AND POI.IDIOMA = 'pt'
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 = 'pt'
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.053366899490356Tiempo acumulado:0.49401330947876
(Prod_Yumping_pt_PT) (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 = 301
AND IDIOMA = 'pt';
Tiempo de la consulta:
0.0060949325561523Tiempo acumulado:0.50010824203491
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[84]: SELECT P.*, P.URL AS URL_PAIS
FROM LO_PAIS_I18N P
WHERE P.ID_PAIS = 48
AND IDIOMA = 'pt';
Tiempo de la consulta:
0.002396821975708Tiempo acumulado:0.50250506401062
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[85]: SELECT ID_REGION_ADM1
FROM LO_REGION RE
GROUP BY ID_REGION_ADM1
HAVING count(*) > 1;
Tiempo de la consulta:
0.0027391910552979Tiempo acumulado:0.50524425506592
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[86]: 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_pt_PT.LO_REGION_STATS RS
INNER JOIN Prod_Yumping_pt_PT.LO_REGION RE ON RE.ID_REGION = RS.ID_REGION
AND RE.ID_PAIS = 48
INNER JOIN Prod_Yumping_pt_PT.LO_REGION_I18N REI ON REI.ID_REGION = RS.ID_REGION
AND REI.IDIOMA = 'pt'
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_pt_PT.LO_REGION_ADM1_STATS RAS
INNER JOIN Prod_Yumping_pt_PT.LO_REGION RE ON RE.ID_REGION_ADM1 = RAS.ID_REGION_ADM1
AND RE.ID_PAIS = 48
INNER JOIN Prod_Yumping_pt_PT.LO_REGION_ADM1_I18N REA ON REA.ID_REGION_ADM1 = RAS.ID_REGION_ADM1
AND REA.IDIOMA = 'pt'
WHERE /*RAS.N_OFERTAS >= 15
AND*/ RAS.ID_SECTOR IS NOT NULL
AND RAS.ID_SECTOR != 0
AND REA.ID_REGION_ADM1 in ( 102,103,100,101)
GROUP BY REA.ID_REGION_ADM1
) AS REGIONES
ORDER BY N_OFERTAS DESC
LIMIT 20;
Tiempo de la consulta:
0.011528015136719Tiempo acumulado:0.51677227020264
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[87]: 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='pt'
AND PAI.ID_PAIS='48'
ORDER BY DESC_PAIS;
Tiempo de la consulta:
0.0086729526519775Tiempo acumulado:0.52544522285461
(Prod_Yumping_pt_PT) (yu-mysql-02.cdwi8qjrxoj3.eu-west-1.rds.amazonaws.com) yumpingread_deskSQL[88]: SELECT *
FROM LO_EQUIPO_EDITORIAL EE
WHERE EE.ID_TROPIC = 8;
Tiempo de la consulta:
0.0027611255645752Tiempo acumulado:0.52820634841919
