SQL Analyzer


Explain Extended

ID Select Type Table Access Type Possible Keys Used Key Key Length Ref Rows Examined Filtered Extra
1 SIMPLE mini_ip ref idx,idx2 idx 30 const 1 100.00% Using index condition; Using where

Original SQL Statement

select 
  count(*) 
from 
  mini_ip 
where 
  idx_date = 20210922 
  and ip = '34.239.160.86'

Converted SQL Statement (MySQL Optimizer)

/* select#1 */
select 
  count(0) AS `count(*)` 
from 
  `pravs`.`mini_ip` 
where 
  (
    (
      `pravs`.`mini_ip`.`ip` = '34.239.160.86'
    ) 
    and (
      `pravs`.`mini_ip`.`idx_date` = 20210922
    )
  )