SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018857 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018857 [ RunTime:0.001888s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (704242,814350,59354,1022239,800112,765798,147083,673877,290782,1041838,699415,760136,518641,387994,819620,900444,477635,258795,992963,733697,707661,1020736,1039354,282568,689828,784223,472046,146431,299239,809663,500529,262343,585253,934956,312725,827786,336069,233943,442475,738848,829638,738451,649099,159492,6419,939191,148683,990627,311720,372618,941961,385219,718624,207027,1029236,602336,81367,172404,989882,766059) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018857 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018857 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]