SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201657 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201657 [ RunTime:0.002343s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (912826,958417,509014,990770,841382,1003012,100722,39063,895417,712550,484801,973655,96548,388871,208929,962544,766881,247658,412890,70805,43912,113412,933800,703787,264885,241897,689639,686109,803174,155850,596663,660498,525959,903029,203592,372739,167822,729196,282258,36997,820711,210658,789002,216448,386989,599732,889352,911799,742788,161558,818472,674333,375143,931593,798635,519705,920703,218848,133185,460488) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201657 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201657 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]