SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506090 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506090 [ RunTime:0.001921s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544368,679639,41413,411199,316479,81072,184925,1004228,297344,813040,207914,713795,35785,396001,812440,987019,965578,113141,603250,578309,900693,833429,505066,787492,245007,243775,303498,556579,298737,889258,160012,694085,940205,424106,355598,746960,942337,913922,900625,955653,668707,676436,884463,57286,584689,404204,665900,989240,769395,340522,827335,70054,350751,623653,530085,824589,571991,799794,412668,479953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506090 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001612s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506090 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]