SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528706 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528706 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532979,838190,990524,746246,914660,416387,843357,1011901,1047087,774421,640194,839146,408026,140513,275500,75827,139436,917028,780297,506858,199951,367123,652517,416166,1037598,865885,454031,394978,102026,886004,32995,456090,525087,502246,587368,320984,644810,918233,502446,432366,773199,247107,697823,310210,80484,888682,139746,986375,284760,216702,998771,563378,96513,174508,578647,698200,720043,973121,647068,638447) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528706 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528706 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]