SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002659s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803071 LIMIT 1 [ RunTime:0.000623s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803071 [ RunTime:0.001776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (849021,998300,778264,625476,200484,451124,75043,147961,631190,468089,466301,209092,12128,416246,617890,522751,730209,689697,484476,633685,497981,458107,531482,82834,491227,799146,488927,382754,163012,24764,920984,728914,955578,475154,27969,266672,787046,1039340,111363,111576,691660,561798,609282,439847,171422,1031600,779561,752047,99020,169053,880079,417860,228284,753371,478953,688214,300151,146093,68539,693219) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000638s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002174s ]