SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003374s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432781 LIMIT 1 [ RunTime:0.001290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432781 [ RunTime:0.001912s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (820901,48858,591714,201574,503386,831390,255428,217627,201408,1025430,614112,469770,63890,352428,715022,677527,302228,841825,226508,60182,11568,523498,725897,671307,795248,739207,736944,384118,374082,345737,136850,154788,871336,625350,92784,460174,218026,279073,141726,426862,892535,892886,679132,1007579,275690,777910,821005,558425,1031286,740628,247641,838775,39660,554285,582175,274086,575564,978524,15539,174445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000714s ]