SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035068 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035068 [ RunTime:0.002262s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (784700,124064,600099,101531,341562,1047023,663272,803846,292678,234768,918878,43155,609689,140229,729034,879084,708214,319817,536383,731437,500882,460655,550310,183142,520121,1003744,523964,623059,772822,850061,937887,54312,243321,7487,187229,983451,465334,1039823,1392,194805,363661,851145,136224,721644,633680,56696,349894,139341,845946,542127,644303,150021,929380,1028818,509381,843400,496557,719065,942024,221078) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035068 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035068 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]