SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101528 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101528 [ RunTime:0.002970s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (80842,762474,500993,301422,821230,14323,879295,422023,477644,554001,883155,901262,38011,426010,929479,339820,62101,167630,55985,658729,89719,284309,579030,441907,1004907,241312,1020654,278072,150437,903685,416707,768604,263445,724975,875615,639454,973955,1045262,514276,133115,16721,779712,200118,539687,849626,892560,859526,269406,702579,74271,852999,113092,201724,179842,669949,418396,687284,27990,178379,923119) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001749s ]