SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38750 LIMIT 1 [ RunTime:0.000709s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38750 [ RunTime:0.001453s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502502,486955,721992,312126,10943,973921,245151,370964,296557,634964,736817,200197,550022,817872,68904,223888,230969,867491,379373,735799,198939,1012164,383604,873659,204432,910039,312235,81410,814961,311225,599249,342321,132964,816545,472655,813341,797203,874205,974530,493072,727935,170053,535234,738476,451261,935017,1032940,655359,474648,846758,320016,30809,912798,493169,388732,328682,966588,549943,15617,253450) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38750 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38750 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]