SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427043 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427043 [ RunTime:0.001926s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (947728,638601,764758,270561,38290,656450,509696,461867,784384,187688,1008416,4227,46166,692895,101050,49433,693674,939228,740965,725051,330689,363099,938113,262088,835752,474755,925488,459488,194256,473100,605748,192987,185535,408365,62346,262580,108869,801457,13796,517,957601,558429,81865,983873,883369,431095,916220,471362,711722,135852,285418,813895,176985,152163,980261,8586,656835,503256,689623,572222) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]