SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 315027 LIMIT 1 [ RunTime:0.000469s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 315027 [ RunTime:0.002750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (766756,668803,1005448,432701,480873,565324,1017136,772711,53874,844021,491561,100211,47479,167949,972082,834326,643975,240497,977741,919962,460997,786410,41308,397309,1004141,245092,566257,940793,849904,70299,304851,527233,716029,929366,242715,515884,60172,1015517,928249,126944,858163,1048574,651278,516242,729950,416352,252132,664162,719800,591366,113638,273089,982590,886141,1002191,264033,957693,201638,149470,987871) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 315027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000677s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 315027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]