SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803590 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803590 [ RunTime:0.001822s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (941682,136175,665412,6239,278922,745160,1019333,900410,640741,114925,406933,906563,780064,184717,425186,882158,14360,431760,898817,190558,374455,823940,910457,958151,452456,684434,784792,506765,529567,825717,429321,1016022,675085,995264,867104,835376,253572,868228,98165,735824,661774,255515,679242,585575,215614,9426,115702,672018,493555,203704,87327,1038397,742541,103510,210089,758468,585898,48440,445310,930999) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803590 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803590 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005355s ]