SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419169 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419169 [ RunTime:0.001695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (143724,138576,78510,322670,379542,339,831497,302155,1012820,370837,514761,475464,838864,592981,466950,616027,768442,977706,964048,952443,410269,261973,240368,627444,652073,233750,939487,248533,801495,328639,812827,420862,27595,675999,111087,370765,41983,367054,100771,861051,159199,987510,849566,464606,198949,676649,677234,335137,905937,858434,104691,37557,529795,845066,449796,967471,310127,323821,823245,599636) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419169 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419169 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]