SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001960s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420781 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420781 [ RunTime:0.002589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482940,1040256,708235,1042102,230357,755678,1258,167153,15509,365694,780753,579147,364490,429951,737460,25208,304638,363802,919154,832126,525952,764167,377399,386727,474573,24623,151771,744645,533659,3505,159384,616504,378210,711907,973159,583933,514026,470886,353718,426708,901902,18085,744980,304304,1011470,423339,653702,998534,381664,179881,998806,1037258,209868,539800,593069,219637,885056,1039235,844507,317995) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]