G2A Many GEOs
SHARE
TWEET

Untitled

a guest Oct 18th, 2012 407 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. mysql> EXPLAIN SELECT distinct(vendorid)  FROM products where pid in(select pid from orders_content  WHERE oid='663');
  2. +----+--------------------+----------------+------+---------------+------+---------+-------+------+------------------------------+
  3. | id | select_type        | table          | type | possible_keys | key  | key_len | ref   | rows | Extra                        |
  4. +----+--------------------+----------------+------+---------------+------+---------+-------+------+------------------------------+
  5. |  1 | PRIMARY            | products       | ALL  | NULL          | NULL | NULL    | NULL  | 9219 | Using where; Using temporary |
  6. |  2 | DEPENDENT SUBQUERY | orders_content | ref  | oid,pid       | oid  | 4       | const |    1 | Using where                  |
  7. +----+--------------------+----------------+------+---------------+------+---------+-------+------+------------------------------+
  8. 2 rows in set (0.00 sec)
RAW Paste Data
Ledger Nano X - The secure hardware wallet
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top