SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555681 LIMIT 1 [ RunTime:0.000732s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555681 [ RunTime:0.001981s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (386635,1014387,1035845,935736,831558,393693,180134,664733,930150,359177,749891,171914,138601,686445,310625,256489,394241,987815,358752,658113,220179,366835,1020727,397604,459416,611220,959127,405629,356129,960196,738119,41828,385895,108129,9551,193554,725681,742302,122780,979315,751981,444614,154033,17028,59885,91027,622742,536002,406310,20806,37198,800399,545330,91682,324945,41334,246920,628406,741547,191399) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]