SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 459299 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 459299 [ RunTime:0.003586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470989,48525,993954,679384,185707,55137,607633,385869,82031,724055,287855,789957,672253,794003,486529,890500,960403,991945,25041,315962,433194,952494,711214,204490,584079,715357,702747,789892,276248,268072,737389,272761,202855,302606,161132,440568,695931,259073,851654,863484,209289,22876,31643,754508,503656,787113,532284,283088,996013,304145,400063,1031093,543346,183332,239265,546380,680063,640458,442469,509934) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 459299 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 459299 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]