SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001718s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512343 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512343 [ RunTime:0.001889s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414995,1045340,433376,848492,544852,412365,530945,360154,550118,890237,573249,537822,846186,986972,664049,1019917,280458,890015,957525,630517,611434,446656,485550,851687,835433,999012,109124,257082,425744,659746,274461,690736,6425,846398,441845,877670,935362,302777,394592,379448,561757,487865,558260,186072,337005,490277,158605,319521,617325,843657,436370,612100,757581,732732,43702,447979,106626,494645,231121,140996) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001140s ]