SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440028 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440028 [ RunTime:0.002638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (160902,705609,418561,641090,949479,795056,181694,74914,975802,365466,317057,907559,959538,964960,808366,602977,661800,607783,737735,529996,92504,445939,984215,723077,1037923,497459,368896,670901,705777,440284,703403,581118,771293,835850,497306,466063,484283,154356,292090,126420,141497,651460,963165,803057,319449,770230,923996,347198,822087,498765,695086,266557,617045,509763,473028,714028,399604,579466,842331,644996) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000777s ]