SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54670 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54670 [ RunTime:0.002348s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (431900,1014600,947273,749354,469054,19155,430670,635472,681667,665321,965178,406073,812953,130864,171693,200364,927823,308248,396004,617339,132052,105318,920625,489924,238651,601295,161720,908869,376502,802233,748294,337638,644557,16122,162399,629520,517980,838057,539122,460025,404075,23302,34245,883983,209636,320826,425780,779960,854763,78632,608120,418956,472054,882249,795276,127123,687838,513842,630590,115683) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54670 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54670 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]