SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002086s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320591 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320591 [ RunTime:0.002417s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (325994,972176,438145,426375,489464,181718,913540,714071,265464,636151,819897,413579,1008761,236871,964534,33275,159478,592483,233239,732911,722887,405514,725364,904344,815898,791763,914582,859049,574866,808325,476883,697453,463220,12059,833343,219997,489883,125857,412057,835091,659340,154366,585874,481608,252925,1022019,874995,954967,292003,139785,201062,194219,465875,497656,991830,377021,548186,812197,166922,623901) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]