SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520046 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520046 [ RunTime:0.001681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (335398,587262,572982,49392,922157,520908,678379,996661,323292,789994,1048701,378123,753226,284419,795815,999839,914770,968153,641275,220382,476553,884405,153024,591009,690151,835350,3757,11800,960303,1040882,138125,206549,164095,670054,123632,344369,557952,625957,389214,261512,233247,725052,698514,750021,765694,129650,255142,912050,671834,831538,37488,842648,246213,723451,6655,353070,91943,800333,847623,190391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]