SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516881 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516881 [ RunTime:0.002603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (926672,682593,709156,481863,657437,938895,369930,150757,721641,450628,697529,880668,1028646,721033,503194,595589,661646,357502,866320,608765,168312,577490,274927,108134,542008,561594,639418,981368,583115,477390,431564,531427,820781,988390,653386,293855,126369,684190,805038,872746,262284,752501,309059,129375,996186,609199,880570,132945,362684,135562,91135,596061,860409,530534,98761,842651,17179,50243,936225,15708) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000937s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]