SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 290963 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 290963 [ RunTime:0.001993s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (875510,930442,552441,345141,185601,839338,509288,461219,1010103,208974,165765,982008,261062,448976,703643,600158,712540,696603,825138,147268,870323,717230,179587,88990,357870,339747,518984,464042,500163,657937,514719,243314,1005816,372494,635446,62699,291790,244737,233801,892867,271362,568233,797995,227086,461603,954185,630144,709097,635124,812325,36894,98383,684239,684815,284081,742295,641815,176975,994112,831864) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 290963 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 290963 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]