SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511118 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511118 [ RunTime:0.001566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (615037,70329,372096,757715,91553,828849,585483,922450,315278,73719,48581,789502,561895,745403,262082,931280,980700,226617,974092,396357,307149,433291,486295,509973,754581,260568,635417,366245,858269,35211,944760,616002,992449,633751,82718,132057,602156,523394,297638,382533,718960,628942,108713,524781,510203,207951,586448,579525,900358,959657,94465,248192,715415,77930,842379,399426,621592,415955,150113,699653) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000879s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]