SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 945728 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 945728 [ RunTime:0.002069s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200399,1031604,40693,984383,272859,553501,96154,269821,996432,802187,751979,784850,1014840,613325,560959,623494,173355,458072,859540,201786,771322,570331,376819,1041262,93001,544153,1026051,456215,281887,981758,571972,188374,538881,524348,1013682,709002,112030,137627,652565,11802,755214,856595,345582,219241,1040339,610990,915084,678829,597857,379919,932541,523594,593729,764806,617782,670769,982089,311527,129612,976630) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 945728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 945728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]