SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001389s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445981 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445981 [ RunTime:0.002030s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98082,640633,414869,621247,322226,279695,798832,615795,535719,756214,875919,593994,1006365,974316,276654,446142,941119,758818,622651,397351,720392,707735,204893,173067,273588,446030,352054,716826,784458,132785,534433,290846,194858,644131,504212,963005,657452,566848,470589,41124,940245,590951,912033,555428,265831,89579,902660,768951,962186,1032119,109043,722743,811213,51664,21388,1015320,718849,600236,836443,582787) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001604s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]