SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515977 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515977 [ RunTime:0.005611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (981028,216880,618615,682930,170789,376470,467626,725630,832127,596269,162690,708400,444070,427503,119570,180964,503641,1032777,439001,857639,61460,309299,935750,285245,505310,690386,793642,968688,554026,97213,454787,900908,768560,913811,313997,604138,993394,348288,274341,1006546,132646,3368,935733,445777,750404,86868,23449,1032071,254630,531471,24696,317992,68548,236523,962654,64156,414073,101907,153974,288098) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515977 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000646s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515977 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]