SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 387951 LIMIT 1 [ RunTime:0.000580s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 387951 [ RunTime:0.001533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404194,509225,601209,528692,405535,437132,34428,931864,388669,513440,226055,287901,173618,712502,1041836,541416,244568,329632,6178,685424,582446,906303,831028,594669,101795,876967,826328,443110,329596,393765,98403,420387,683212,791474,619103,45203,57617,666748,273977,405890,451432,988013,565099,285793,632139,709547,905884,236573,586509,16167,369915,113975,24842,103562,212146,39822,324103,688727,200208,695775) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 387951 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 387951 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]