SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331680 LIMIT 1 [ RunTime:0.001378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331680 [ RunTime:0.001966s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (321702,628406,286365,495845,563300,797678,609938,959902,296724,796621,1002886,964234,516632,650239,744304,98823,629182,673399,549409,356696,291696,331330,348806,711940,224984,806797,319442,803791,599489,589395,721187,10738,311593,262118,532597,842606,100782,994146,306751,327835,148064,475373,532734,584874,340028,331571,887438,3638,766445,172702,594070,403162,98138,153926,981896,732207,867384,865834,179992,447591) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]