SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104913 LIMIT 1 [ RunTime:0.000588s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104913 [ RunTime:0.002676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (507787,398211,14522,164892,361789,391740,303561,866017,427365,304506,804405,383055,825297,182706,898309,134139,143514,616560,932567,526545,653433,82218,587097,748237,947197,883952,541596,474191,210076,923067,517834,178486,852988,195570,744075,536779,267644,750011,462859,988646,171466,981868,197876,561909,169560,826535,212571,643001,800211,623058,963422,420126,987684,711687,526467,441292,311422,1419,849113,983361) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000693s ]