SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 344284 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 344284 [ RunTime:0.001557s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (163411,451634,176542,123497,633863,240675,415650,1003709,760363,614563,397508,77959,43698,734864,358866,469377,543366,875709,603779,437294,975304,830215,433304,910413,753287,52511,810793,449543,798129,465381,97131,538979,150915,465432,923780,860019,890846,556896,721633,817249,428470,187124,659600,499578,294753,327455,336237,742838,119386,709202,833443,49899,639605,213032,716838,473084,801407,929850,587924,179277) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 344284 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000620s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 344284 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000854s ]