SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 324823 LIMIT 1 [ RunTime:0.000476s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 324823 [ RunTime:0.001690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (537336,182899,360848,595797,394576,194646,26907,272133,887858,253727,298948,668244,685437,102191,684364,946309,773061,6022,501933,360438,68226,1033005,651997,87866,354932,648998,525045,681464,930667,984517,853151,694117,908686,558894,514695,1025400,452757,670737,517044,774222,186425,265,1045064,173898,650461,495697,812796,913208,1048798,1008499,902348,188923,732215,60269,293505,759461,622456,875909,893390,603006) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 324823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 324823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000405s ]