SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319762 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319762 [ RunTime:0.001539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (585556,671273,398809,299857,585248,961620,200495,149758,164878,880378,737756,32859,687451,96615,965575,390391,762666,246539,429527,804516,359488,546758,381638,631912,119895,84124,413248,109653,968917,792069,147285,201792,39745,686207,511517,402199,433539,116686,1031485,665789,321953,244564,12618,740903,776570,621607,570727,514672,1002215,448571,694682,620330,281472,986694,962866,847373,870843,893148,43516,674547) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319762 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319762 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]