hn.kpaste.net RSS- root@octans [~]# mysql
- Welcome to the MySQL monitor. Commands end with ; or \g.
- Your MySQL connection id is 912
- Server version: 5.5.32-cll 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 |
- +-----+--------------+-----------+--------------+---------+------+----------------------+--------------------------------------------------------------------------------------------------------------------------------------------------+
- | 1 | leechprotect | localhost | leechprotect | Sleep | 565 | | NULL |
- | 862 | ag_user | localhost | ag_portal | Sleep | 27 | | NULL |
- | 864 | ag_user | localhost | ag_portal | Sleep | 27 | | NULL |
- | 891 | ag_user | localhost | ag_portal | Query | 0 | Copying to tmp table | SELECT * FROM ag_category c LEFT JOIN ag_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN ag_category_to_store c2s ON (c.cat|
- | 899 | ag_user | localhost | ag_portal | Sleep | 0 | | NULL |
- | 902 | ag_user | localhost | ag_portal | Sleep | 0 | | NULL |
- | 903 | ag_user | localhost | ag_portal | Sleep | 0 | | NULL |
- | 906 | ag_user | localhost | ag_portal | Sleep | 0 | | NULL |
- | 907 | ag_user | localhost | ag_portal | Sleep | 0 | | NULL |
- | 908 | ag_user | localhost | ag_portal | Query | 0 | Sending data | SELECT * FROM ag_category c
- LEFT JOIN ag_category_description cd ON
- (c.category_id = cd.category_id) LEFT JOIN ag_category_to_store c2s ON (c.category_id = c2s.category_id)
- WHERE c.parent_id = '310'
- AND
- (
- select count(*) from ag_product_to_category ptc1 where ptc1.category_id = c.category_id
- and
- (
- select count(*) from ag_product_to_category ptc2 where ptc2.product_id = ptc1.product_id
- and ptc2.category_id = 1344
- and
- (
- select count(*) from ag_product p where p.product_id = ptc2.product_id and p.status = '1' and p.quantity > 2
- ) > 0
- ) > 0
- ) > 0
- AND cd.language_id = '1'
- AND c2s.store_id = '0'
- AND c.status = '1'
- ORDER BY c.sort_order, LCASE(cd.name) |
- | 909 | ag_user | localhost | ag_portal | Sleep | 6 | | NULL |
- | 912 | root | localhost | NULL | Query | 0 | NULL | show full processlist |
- | 913 | ag_user | localhost | ag_portal | Sleep | 1 | | NULL |
- | 914 | ag_user | localhost | ag_portal | Sleep | 1 | | NULL |
- | 915 | ag_user | localhost | ag_portal | Sleep | 0 | | NULL |
- +-----+--------------+-----------+--------------+---------+------+----------------------+--------------------------------------------------------------------------------------------------------------------------------------------------+
- 15 rows in set (0.01 sec)
- mysql>
Untitled
Posted by NotLim on Tue 12th Nov 2013 19:59
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.