SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001619s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485246 LIMIT 1 [ RunTime:0.000945s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485246 [ RunTime:0.001598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (828265,595123,887092,836155,970482,623139,652913,167834,536236,58297,890521,511437,127467,582924,611537,267338,182733,753167,450286,36288,408699,670374,368347,384942,318095,331637,625387,389790,538002,219444,448889,548498,325298,487797,848229,806231,910294,930414,1023789,765422,707942,636809,584996,196794,236998,269170,1002817,897706,565618,341962,692250,320833,423267,541382,523982,218051,7842,180906,520220,732159) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485246 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485246 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]