SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451863 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451863 [ RunTime:0.003175s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (953598,438943,382086,114321,433700,289102,509222,193000,209069,349889,346435,770745,203632,1000798,784001,1032484,761303,531278,699379,233487,623841,841830,30664,971045,440537,491561,233381,33508,578137,185549,74428,612372,580223,284617,352768,560854,813830,553309,584770,338475,497583,766405,797142,954624,880706,499587,470537,35347,80346,517026,613751,644491,507255,913075,331195,140112,889160,698389,306645,643191) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451863 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451863 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]