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 = 20211014 
  and ip = '44.192.92.223'

Converted SQL Statement (MySQL Optimizer)

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