SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522913 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522913 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (618019,601447,386433,329140,879115,248063,818535,95919,1046090,629665,366733,308953,502900,946376,949021,66398,1013070,753993,805042,647097,194532,591961,397027,665592,431359,936869,394804,156216,6182,177217,1048604,944376,237137,381002,624266,266655,276089,270018,734398,628276,793835,585794,463785,270517,228051,936040,407240,738221,22582,1018313,537471,761266,217677,281923,690201,933068,858143,487184,618532,8684) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]