Untitled
Posted by NotLim on Mon 13th Jan 2014 22:03
raw | new post

| 16894 | mejorhos_dev | localhost | mejorhos_mh | Query   | 27996 | statistics | SELECT   wp_posts.* FROM wp_posts  INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id)
INNER JOIN wp_postmeta AS mt1 ON (wp_posts.ID = mt1.post_id)
INNER JOIN wp_postmeta AS mt2 ON (wp_posts.ID = mt2.post_id)
INNER JOIN wp_postmeta AS mt3 ON (wp_posts.ID = mt3.post_id)
INNER JOIN wp_postmeta AS mt4 ON (wp_posts.ID = mt4.post_id)
INNER JOIN wp_postmeta AS mt5 ON (wp_posts.ID = mt5.post_id)
INNER JOIN wp_postmeta AS mt6 ON (wp_posts.ID = mt6.post_id)
INNER JOIN wp_postmeta AS mt7 ON (wp_posts.ID = mt7.post_id)
INNER JOIN wp_postmeta AS mt8 ON (wp_posts.ID = mt8.post_id)
INNER JOIN wp_postmeta AS mt9 ON (wp_posts.ID = mt9.post_id)
INNER JOIN wp_postmeta AS mt10 ON (wp_posts.ID = mt10.post_id)
INNER JOIN wp_postmeta AS mt11 ON (wp_posts.ID = mt11.post_id)
INNER JOIN wp_postmeta AS mt12 ON (wp_posts.ID = mt12.post_id)
INNER JOIN wp_postmeta AS mt13 ON (wp_posts.ID = mt13.post_id)
INNER JOIN wp_postmeta AS mt14 ON (wp_posts.ID = mt14.post_id)
INNER JOIN wp_postmeta AS mt15 ON (wp_posts.ID = mt15.post_id)
INNER JOIN wp_postmeta AS mt16 ON (wp_posts.ID = mt16.post_id) WHERE 1=1  AND ( wp_term_relationships.term_taxonomy_id IN (13) ) AND wp_posts.post_type = 'planes' AND (wp_posts.post_status = 'publish') AND (wp_postmeta.meta_key = 'calidad'
AND  (mt1.meta_key = 'espacio_en_disco' AND CAST(mt1.meta_value AS SIGNED) >= '0')
AND  (mt2.meta_key = 'respaldo_externo' AND CAST(mt2.meta_value AS CHAR) = '1')
AND  (mt3.meta_key = 'cuenta_de_correo' AND CAST(mt3.meta_value AS SIGNED) >= '1')
AND  (mt4.meta_key = 'precio' AND CAST(mt4.meta_value AS SIGNED) <= '5000')
AND  (mt5.meta_key = 'cpanel' AND CAST(mt5.meta_value AS CHAR) = '1')
AND  (mt6.meta_key = 'ftp' AND CAST(mt6.meta_value AS CHAR) = '1')
AND  (mt7.meta_key = 'aplicaciones_preinstaladas' AND CAST(mt7.meta_value AS CHAR) = '1')
AND  (mt8.meta_key = 'constructor_web' AND CAST(mt8.meta_value AS CHAR) = '1')
AND  (mt9.meta_key = 'transferencia_mensual' AND CAST(mt9.meta_value AS SIGNED) >= '1')
AND  (mt10.meta_key = 'respaldo_interno' AND CAST(mt10.meta_value AS CHAR) = '1')
AND  (mt11.meta_key = 'firewall_fisico' AND CAST(mt11.meta_value AS CHAR) = '1')
AND  (mt12.meta_key = 'servidores_en_chile' AND CAST(mt12.meta_value AS CHAR) = '1')
AND  (mt13.meta_key = 'facturacion_electronica' AND CAST(mt13.meta_value AS CHAR) = '1')
AND  (mt14.meta_key = 'call_center' AND CAST(mt14.meta_value AS CHAR) = '1')
AND  (mt15.meta_key = 'datacenter_propio' AND CAST(mt15.meta_value AS CHAR) = '1')
AND  (mt16.meta_key = 'soporte_24_7' AND CAST(mt16.meta_value AS CHAR) = '1') ) GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value+0 DESC |
| 26061 | root         | localhost | NULL        | Query   |     0 | NULL       | show full processlist