SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585511 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585511 [ RunTime:0.002717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (624667,473043,1024169,330821,301737,538914,486311,312115,606364,362751,131917,902065,445857,118157,607899,689289,918541,807824,163936,652806,961167,805838,724691,465304,1017961,933998,402959,415358,586046,417648,105391,174826,49783,250742,892546,452661,230318,37708,210226,662460,171299,366487,239290,295383,361405,644160,807119,60391,872299,25335,311211,395686,686391,904117,182842,612876,6388,418014,802713,641299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000722s ]