SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001651s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681311 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681311 [ RunTime:0.001805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (848422,296129,139379,18173,737027,278232,123033,190190,725248,550264,90675,493972,976691,836923,674406,570320,69913,783804,30535,707833,971437,919444,476446,361630,117487,150085,662441,912492,569903,896652,850283,82540,351179,326717,347970,331017,194547,526331,276515,866216,44393,197471,393272,658840,945965,649325,370989,717387,1033882,579338,145760,790951,202723,837510,116626,115754,734149,518068,418441,211677) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]