mysql> show profiles;
+----------+------------+-----------------------------------------------------------------------------------------------------+
| Query_ID | Duration   | Query                                                                                               |
+----------+------------+-----------------------------------------------------------------------------------------------------+
|        1 | 0.00042025 | SELECT sql_no_cache sid FROM scald_atoms WHERE base_id ='493457' AND provider =  'rf_ressource_son' |
|        2 | 0.07981000 | SELECT sql_no_cache sid FROM scald_atoms WHERE base_id =493457 AND provider =  'rf_ressource_son'   |
|        3 | 0.00045675 | SELECT sql_no_cache sid FROM scald_atoms WHERE base_id ='493457' AND provider =  'rf_ressource_son' |
|        4 | 0.08060225 | SELECT sql_no_cache sid FROM scald_atoms WHERE base_id =493457 AND provider =  'rf_ressource_son'   |
+----------+------------+-----------------------------------------------------------------------------------------------------+

mysql> show index from scald_atoms;
+-------------+------------+-------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table       | Non_unique | Key_name                | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-------------+------------+-------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| scald_atoms |          0 | PRIMARY                 |            1 | sid         | A         |       87622 |     NULL | NULL   |      | BTREE      |         |               |
| scald_atoms |          0 | u_provider_base_id_type |            1 | provider    | A         |         199 |       64 | NULL   |      | BTREE      |         |               |
| scald_atoms |          0 | u_provider_base_id_type |            2 | base_id     | A         |         199 |       64 | NULL   | YES  | BTREE      |         |               |
| scald_atoms |          0 | u_provider_base_id_type |            3 | type        | A         |         199 |       64 | NULL   |      | BTREE      |         |               |
| scald_atoms |          1 | i_sid_provider_base_id  |            1 | sid         | A         |       87622 |     NULL | NULL   |      | BTREE      |         |               |
| scald_atoms |          1 | i_sid_provider_base_id  |            2 | provider    | A         |       87622 |       64 | NULL   |      | BTREE      |         |               |
| scald_atoms |          1 | i_sid_provider_base_id  |            3 | base_id     | A         |       87622 |       64 | NULL   | YES  | BTREE      |         |               |
| scald_atoms |          1 | i_sid_actions           |            1 | sid         | A         |       87622 |     NULL | NULL   |      | BTREE      |         |               |
| scald_atoms |          1 | i_sid_actions           |            2 | actions     | A         |       87622 |     NULL | NULL   |      | BTREE      |         |               |
| scald_atoms |          1 | i_type_sid              |            1 | type        | A         |           3 |     NULL | NULL   |      | BTREE      |         |               |
| scald_atoms |          1 | i_type_sid              |            2 | sid         | A         |       87622 |     NULL | NULL   |      | BTREE      |         |               |
| scald_atoms |          1 | i_publisher_sid         |            1 | publisher   | A         |           3 |     NULL | NULL   |      | BTREE      |         |               |
| scald_atoms |          1 | i_publisher_sid         |            2 | sid         | A         |       87622 |     NULL | NULL   |      | BTREE      |         |               |
+-------------+------------+-------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+