# Slow query with IN

**URL:** <https://forums.percona.com/t/slow-query-with-in/5411>\
**Category:** Percona Server for MySQL 5.6\
**Created:** [February 13, 2017, 11:44am UTC](https://forums.percona.com/t/slow-query-with-in/5411 "2017-02-13T11:44:46Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sixart](https://avatars.discourse-cdn.com/v4/letter/s/76d3ee/32.png) [@sixart](https://forums.percona.com/u/sixart)\
**Post date:** [February 13, 2017, 11:44am UTC](https://forums.percona.com/t/slow-query-with-in/5411/1 "2017-02-13T11:44:46Z")

</div>

Hi,

I have problem with query with IN option, is very slow or I have DEADLOCK.

The query is:  
SELECT \* FROM token WHERE id in  
(SELECT token\_id FROM tokeninfo WHERE `Value` = ‘546845’)  
in this case or is very slow or I have “ERROR 1213 - Deadlock found when trying to get lock;”

If my query is "SELECT \* FROM token WHERE id in (‘367’), it is very fast.

Where is the problem?

Regards,  
Dario

---

<div class="post-metadata">

**Author:** ![howkey](https://avatars.discourse-cdn.com/v4/letter/h/71e660/32.png) [@howkey](https://forums.percona.com/u/howkey)\
**Post date:** [May 16, 2017, 3:30am UTC](https://forums.percona.com/t/slow-query-with-in/5411/2 "2017-05-16T03:30:46Z")

</div>

The problem will be slow subselect

```auto
SELECT token_id FROM tokeninfo WHERE `Value` = '546845'

```

. Look if it is using any index by running EXPLAIN on that query. How many rows do you have in the table tokeninfo?