SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001463s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 98471 LIMIT 1 [ RunTime:0.000917s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 98471 [ RunTime:0.002159s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402234,989283,522030,607809,214112,387902,127086,306948,249684,178804,384490,355267,1410,56015,958236,176275,307301,159259,749976,476496,451938,301145,267392,639844,95306,319673,579775,1010813,563135,572669,944340,357808,304025,471372,36405,253322,161880,497222,118359,394474,847412,912317,583238,804741,430294,364469,22822,622794,618423,266651,1013251,929737,133078,780890,878718,775819,439880,962309,35644,405069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 98471 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 98471 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]