SQL Analyzer


Explain Extended

ID Select Type Table Access Type Possible Keys Used Key Key Length Ref Rows Examined Filtered Extra
1 SIMPLE mini_counter ALL 1,132 100.00% Using where

Original SQL Statement

select 
  count(*) 
from 
  mini_counter 
where 
  day = 20211025

Converted SQL Statement (MySQL Optimizer)

/* select#1 */
select 
  count(0) AS `count(*)` 
from 
  `pravs`.`mini_counter` 
where 
  (
    `pravs`.`mini_counter`.`day` = 20211025
  )