SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481981 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481981 [ RunTime:0.002191s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (110098,228204,489127,17637,701890,250438,789639,585344,200712,408408,309226,529447,774700,987300,400558,15809,977503,664774,848904,631261,479451,900585,608256,445242,943231,507628,153443,171894,678675,240246,365741,519188,651209,535418,27698,157583,429837,828389,507912,503681,114557,896081,917278,321755,664251,688209,435397,850699,302448,1032554,602939,99015,34023,689219,1026525,751050,912122,243817,803259,544793) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]