SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522013 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522013 [ RunTime:0.001636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (366228,810618,290079,490325,686465,464199,220962,1040574,770452,544520,13015,53883,169965,316643,691273,996003,668087,685573,599981,815608,729205,577616,777710,867033,537151,581561,545498,404916,977298,738626,888428,354325,43319,836083,722576,229091,968530,41742,225088,702426,836738,247541,461579,205725,753126,983864,722828,459476,795955,69228,678830,947889,310366,309524,83288,807034,3116,307146,281486,163845) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]