SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535313 LIMIT 1 [ RunTime:0.000585s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535313 [ RunTime:0.001916s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (341226,293654,393001,673447,256502,693605,404082,54631,117017,1018989,798260,419867,183674,867991,603811,160681,781630,273852,286287,234785,706092,695108,752816,595314,761182,212332,155646,799204,167484,629740,567183,137405,608444,580081,267005,906920,7906,544617,364883,778937,750051,102034,231006,459326,1028804,1044610,568509,659359,166097,287232,1041392,377556,426034,153885,608914,377190,512054,780852,719276,739743) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]