SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320311 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320311 [ RunTime:0.001546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (248579,320484,656377,66778,581218,921924,1004054,46480,414105,335497,571493,698812,29587,766286,418396,311242,734329,493335,672163,882432,783794,244189,891461,880372,526662,755759,211774,608335,304828,550771,813277,6638,755745,442709,212897,80193,63266,512242,64013,48614,483163,827533,410019,369040,880780,621099,153082,93565,625984,238344,458450,441990,699895,466662,99506,961831,770651,867259,1023193,207340) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001806s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]