SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533401 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533401 [ RunTime:0.001842s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (163606,247106,130932,866230,126413,586283,774525,510400,88186,475981,348197,1036179,923304,610160,195196,973745,94703,349186,981665,216747,921870,510940,18960,61845,624251,314405,618337,725645,799926,169853,348905,925595,612626,412040,742500,720722,769023,264616,21647,1033728,441359,583200,658852,33742,938857,186469,623909,576013,433688,279045,489759,271516,247153,454852,790002,504517,910644,892839,351182,592354) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]