SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003530s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535980 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535980 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (612214,617538,1018355,828842,669941,238231,920004,952710,350062,412136,33244,1041334,817934,990006,409307,536189,518343,140644,73173,246365,843035,460318,607564,902701,686505,370519,899519,123824,352677,785684,142508,318373,622490,262694,587984,573916,162285,701542,1021522,52546,600369,567650,753479,300090,288981,1026125,615939,90599,662776,474589,800116,723931,264281,426159,978517,962449,454868,57483,145310,414643) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002922s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001384s ]