SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456851 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456851 [ RunTime:0.001860s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (606169,1041084,200537,741955,814584,610185,940080,362916,434801,601687,613791,15897,625043,474874,485542,222447,665482,995425,135149,858391,720203,300342,863143,827154,724086,114800,612739,180670,381231,458805,398901,797375,887249,324417,929635,136394,586721,1042986,911906,986080,314718,867388,346932,135267,410088,357099,863100,447529,335148,333135,117311,861672,622288,157040,932311,904926,750543,331926,397693,1029649) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]