SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5148 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5148 [ RunTime:0.002681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (285905,659562,1037860,570422,250410,756310,507201,372117,224426,438534,311244,920586,491840,926974,498724,248284,791089,159194,365037,650052,931924,38321,173508,529063,158604,99236,721479,911196,996204,383291,805343,347026,206821,603428,413325,8542,419644,248469,860392,560375,174204,447373,320649,476023,230214,318811,106173,398269,473604,576076,164215,529158,895255,800859,852284,5538,130232,493883,633570,857504) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003917s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]