SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431098 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431098 [ RunTime:0.003206s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (393497,602080,343160,1002904,336271,584815,526531,429372,1027647,71126,644301,582070,197139,335322,354771,609715,821022,883754,27000,152345,812593,779468,11582,917215,925400,814758,487173,711546,764836,24472,43367,496515,324937,953410,783345,529214,526589,614212,677541,672171,696416,450690,166053,898142,147293,728402,274528,288272,799883,867708,46365,1032954,439969,490184,756991,81375,428892,564705,721814,326067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000807s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]