SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 271945 LIMIT 1 [ RunTime:0.000673s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 271945 [ RunTime:0.002929s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (567834,855158,269935,135991,640515,616843,537863,229934,127306,116926,735593,617623,791451,220293,443442,224464,160781,93524,809812,321819,876580,824935,961226,260562,828406,546934,93924,722714,720659,227594,725352,281757,520099,399316,161202,442436,717616,845973,622874,433967,579516,317944,323406,446423,306186,641413,211971,516791,337080,926992,563383,324837,680308,202442,194922,952332,243476,442250,847183,546824) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001694s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 271945 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 271945 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]