SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460514 LIMIT 1 [ RunTime:0.000497s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460514 [ RunTime:0.001518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (389971,686619,886710,477444,1009974,740279,131344,553957,928958,18201,750151,363151,44312,675491,1024378,1035298,593202,456236,471550,474462,766846,77079,65891,864694,829957,931448,524177,801548,1018812,190470,602976,7016,730446,772983,94470,568941,470120,605614,153319,287432,336495,146619,191631,1030597,747756,770896,716374,840689,275605,980602,803885,522105,568440,337333,427394,1047909,214059,795776,627596,360104) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]