SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 586331 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 586331 [ RunTime:0.001864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (995054,517061,379647,1039505,814622,42601,750023,600858,792672,802389,751216,236321,811483,671126,1022907,511730,252522,481710,658529,288222,415089,508198,160855,24045,15590,999130,933931,388160,866741,807077,539449,1002245,555620,703221,947703,198351,676380,196090,457521,907900,430305,40955,697006,436858,585749,31514,210579,919683,485667,208828,386431,597336,704617,712926,683022,912000,921081,689465,535954,857052) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 586331 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 586331 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000975s ]