SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458831 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458831 [ RunTime:0.003550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31512,99505,579287,1012789,718997,952852,453028,511553,695991,514148,695956,608148,845797,52309,345688,535978,612278,181206,381283,219176,789330,624580,946811,785667,496087,237565,30450,701141,417912,967447,319744,132683,47397,802693,272017,351139,62275,185634,609563,119246,870346,244494,692698,676483,845610,126138,343136,1012652,899253,360655,136206,1023200,576272,511352,486027,1010269,286004,932258,979805,54389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000572s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]