SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 807681 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 807681 [ RunTime:0.001566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516054,222039,825425,332702,103516,761336,950681,535254,123199,613578,421375,921868,982149,508107,288568,170114,516999,594270,435962,668709,636241,4072,938670,604055,622640,36049,483527,46821,647095,912918,963051,297172,36797,231955,482361,889757,348458,80658,1031562,514846,241217,293339,368042,263026,403622,1018630,735496,256083,487153,896677,962402,735154,103283,282173,136378,420982,825593,281533,70119,686245) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 807681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 807681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]