SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41023 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41023 [ RunTime:0.002305s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (236043,939457,183438,576379,856978,258920,110463,411200,176140,235294,439431,944418,674259,276136,665185,784070,23093,691062,782039,399722,243952,6006,726924,248908,728506,233847,925238,825992,493805,73404,153065,910581,840496,845481,882047,680788,627606,244638,455776,864322,319922,647431,391299,400969,955623,429934,930088,1014323,515370,881434,522328,1028986,955272,708489,576880,192007,909522,33252,862150,775200) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000753s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]