SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 989283 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 989283 [ RunTime:0.001470s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (602540,920164,602149,483940,968358,846376,458014,594811,666340,372121,468247,41165,668314,405670,29903,505584,846995,204319,185430,316375,906285,655392,906859,633243,797700,243954,115698,619051,612415,460265,775061,361800,482805,1017610,556243,970228,499964,934034,117441,395144,231191,519899,561283,654224,100635,544749,371469,1002089,603225,166717,321377,325372,60562,796530,659788,84733,22922,198062,757803,929261) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 989283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 989283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]