hn.kpaste.net RSS- Welcome to the MySQL monitor. Commands end with ; or \g.
- Your MySQL connection id is 966956
- Server version: 5.5.32-cll-lve MySQL Community Server (GPL)
- Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
- Oracle is a registered trademark of Oracle Corporation and/or its
- affiliates. Other names may be trademarks of their respective
- owners.
- Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
- mysql> show full processlist;
- +--------+-----------------+-----------+--------------------+---------+-------+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
- | Id | User | Host | db | Command | Time | State | Info |
- +--------+-----------------+-----------+--------------------+---------+-------+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
- | 19 | root | localhost | information_schema | Sleep | 10 | | NULL |
- | 918947 | leechprotect | localhost | leechprotect | Sleep | 22100 | | NULL |
- | 965849 | magiceve_admin | localhost | magiceve_bd | Query | 546 | Sending data | select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id) left join specials s on p.products_id = s.products_id, products_description pd, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '2' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.products_id = p.products_id and p2c.products_id = pd.products_id and (p2c.categories_id = '83') or pd.products_description like '%rareza: com_n%' |
- | 965864 | magiceve_admin | localhost | magiceve_bd | Query | 533 | Sending data | select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id) left join specials s on p.products_id = s.products_id, products_description pd, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '2' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.products_id = p.products_id and p2c.products_id = pd.products_id and (p2c.categories_id = '83') or pd.products_description like '%rareza: infrecuente%' |
- | 966002 | magiceve_admin | localhost | magiceve_bd | Query | 451 | Sending data | select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id) left join specials s on p.products_id = s.products_id, products_description pd, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '2' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.products_id = p.products_id and p2c.products_id = pd.products_id and (p2c.categories_id = '83') and pd.products_description like '%rareza: rara%' or pd.products_description like '%rareza: infrecuente%' |
- | 966956 | root | localhost | NULL | Query | 0 | NULL | show full processlist |
- | 966958 | mundoali_master | localhost | mundoali_web | Sleep | 0 | | NULL |
- | 966959 | mundoali_master | localhost | mundoali_web | Sleep | 0 | | NULL |
- +--------+-----------------+-----------+--------------------+---------+-------+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
- 8 rows in set (0.01 sec)
- mysql> quit
- Bye
Untitled
Posted by NotLim on Tue 4th Feb 2014 18:03
raw | new post
Submit a correction or amendment below (click here to make a fresh posting)
After submitting an amendment, you'll be able to view the differences between the old and new posts easily.