SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50693 LIMIT 1 [ RunTime:0.001243s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50693 [ RunTime:0.002845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519478,827833,280275,878041,650179,514836,22230,208484,1018877,10195,956869,564696,380576,440782,553901,305191,665306,476286,565893,993744,46848,605905,107595,926727,103048,414573,268569,783267,847409,324292,112642,205363,807117,655002,780540,816212,147438,959745,405782,648239,499796,772705,469995,899714,742175,903471,736916,436584,110602,8696,511667,285490,213850,924169,93151,226282,233679,404134,503694,427525) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50693 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50693 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002368s ]